We have an API to check whether the Line has crossed each of the important statuses.
For example with the below script we can check the particular lines picking status.
SET SERVEROUTPUT ON;
DECLARE
P_LINE_ID NUMBER;
X_RESULT VARCHAR2(200);
X_PICKED_QUANTITY NUMBER;
X_PICKED_QUANTITY_UOM VARCHAR2(200);
BEGIN
P_LINE_ID:= 1358;
OE_LINE_STATUS_PUB.GET_PICK_STATUS(
P_LINE_ID => P_LINE_ID,
X_RESULT => X_RESULT,
X_PICKED_QUANTITY => X_PICKED_QUANTITY,
X_PICKED_QUANTITY_UOM => X_PICKED_QUANTITY_UOM
);
DBMS_OUTPUT.PUT_LINE('X_RESULT = ' || X_RESULT);
DBMS_OUTPUT.PUT_LINE('X_PICKED_QUANTITY = ' || X_PICKED_QUANTITY);
DBMS_OUTPUT.PUT_LINE('X_PICKED_QUANTITY_UOM = ' || X_PICKED_QUANTITY_UOM);
END;
/
Below is the list other procedures available in the package OE_LINE_STATUS_PUB,
| SI NO | Procedure | Parameters |
| IN | OUT |
| 1 | GET_CLOSED_STATUS | p_line_id | x_result |
| 2 | GET_CLOSED_STATUS | p_line_id | x_result, x_result_date |
| 3 | GET_CANCELLED_STATUS | p_line_id | x_result |
| 4 | GET_CANCELLED_STATUS | p_line_id | x_result, x_result_date |
| 5 | GET_PURCHASE_RELEASE_STATUS | p_line_id | x_result |
| 6 | GET_PURCHASE_RELEASE_STATUS | p_line_id | x_result, x_result_date |
| 7 | GET_SHIP_STATUS | p_line_id | x_result |
| 8 | GET_SHIP_STATUS | p_line_id | x_result, x_result_date |
| 9 | GET_PICK_STATUS | p_line_id | x_result |
| 10 | GET_PICK_STATUS | p_line_id | x_result, x_result_date |
| 11 | GET_RECEIVED_STATUS | p_line_id | x_result |
| 12 | GET_RECEIVED_STATUS | p_line_id | x_result, x_result_date |
| 13 | GET_INVOICED_STATUS | p_line_id | x_result |
| 14 | GET_INVOICED_STATUS | p_line_id | x_result, x_result_date |
Apart from the above Procedures we have one Function also
FUNCTION Get_Line_Status
( p_line_id IN NUMBER
,p_flow_status_code IN VARCHAR2)
RETURN VARCHAR2;
Do you think this Article is useful?
0 Responses to “API to confirm on Order Line Status (OE_LINE_STATUS_PUB)”
Post a Comment