DBA Data[Home] [Help]

APPS.JA_JAINAR3R_XMLP_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 33: OE_ORDER_HEADERS_ALL

29: CURSOR C_GET_ORDER_NUMBER(P_ORDER_NUMBER IN NUMBER) IS
30: SELECT
31: TO_CHAR(ORDER_NUMBER)
32: FROM
33: OE_ORDER_HEADERS_ALL
34: WHERE HEADER_ID = P_ORDER_NUMBER;
35: BEGIN
36: IF TRX_TYPE = 'ORDER' THEN
37: OPEN C_GET_ORDER_NUMBER(L_TRX_NUMBER);