Wednesday, June 23, 2010
API to confirm on Order Header Status (OE_HEADER_STATUS_PUB)
We have an API to check whether the Order has crossed its important statuses.
For example with the below script we can check whether the particular order got CLOSED or not.
SET SERVEROUTPUT ON;
DECLARE
P_HEADER_ID NUMBER;
X_RESULT VARCHAR2(200);
X_RESULT_DATE DATE;
BEGIN
P_HEADER_ID := 1331;
OE_HEADER_STATUS_PUB.GET_CLOSED_STATUS(
P_HEADER_ID => P_HEADER_ID,
X_RESULT => X_RESULT,
X_RESULT_DATE => X_RESULT_DATE
);
DBMS_OUTPUT.PUT_LINE('X_RESULT = ' || X_RESULT);
DBMS_OUTPUT.PUT_LINE('X_RESULT_DATE = ' || X_RESULT_DATE);
END;
Below is the list other procedures available in the package OE_HEADER_STATUS_PUB,
| SI NO | Procedure | Parameters | |
| IN | OUT | ||
| 1 | GET_BOOKED_STATUS | p_header_id | x_result |
| 2 | GET_BOOKED_STATUS | p_header_id | x_result, x_result_date |
| 3 | GET_CLOSED_STATUS | p_header_id | x_result |
| 4 | GET_CLOSED_STATUS | p_header_id | x_result, x_result_date |
| 5 | GET_CANCELLED_STATUS | p_header_id | x_result |
| 6 | GET_CANCELLED_STATUS | p_header_id | x_result, x_result_date |
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
0 Responses to “API to confirm on Order Header Status (OE_HEADER_STATUS_PUB)”
Post a Comment