APPS.OE_LINE_UTILITY dependencies on OE_QUERY

Line 15: P_BASE_LINE_NUMBER := OE_QUERY.BASE_LINE_NUMBER (P_PARENT_LINE_ID, P_SERVICE_PARENT_LINE_ID,

11: , P_OPTION_LINE_NUMBER OUT NUMBER
12: )
13: IS
14: BEGIN
15: P_BASE_LINE_NUMBER := OE_QUERY.BASE_LINE_NUMBER (P_PARENT_LINE_ID, P_SERVICE_PARENT_LINE_ID,
16: P_SHIPMENT_SCHEDULE_LINE_ID, P_LINE_NUMBER);
17: P_SHIPMENT_SCHEDULE_NUMBER := OE_QUERY.SHIPMENT_SCHEDULE_NUMBER (P_PARENT_LINE_ID,
18: P_SERVICE_PARENT_LINE_ID, P_SHIPMENT_SCHEDULE_LINE_ID,
19: P_LINE_NUMBER);

Line 17: P_SHIPMENT_SCHEDULE_NUMBER := OE_QUERY.SHIPMENT_SCHEDULE_NUMBER (P_PARENT_LINE_ID,

13: IS
14: BEGIN
15: P_BASE_LINE_NUMBER := OE_QUERY.BASE_LINE_NUMBER (P_PARENT_LINE_ID, P_SERVICE_PARENT_LINE_ID,
16: P_SHIPMENT_SCHEDULE_LINE_ID, P_LINE_NUMBER);
17: P_SHIPMENT_SCHEDULE_NUMBER := OE_QUERY.SHIPMENT_SCHEDULE_NUMBER (P_PARENT_LINE_ID,
18: P_SERVICE_PARENT_LINE_ID, P_SHIPMENT_SCHEDULE_LINE_ID,
19: P_LINE_NUMBER);
20: P_OPTION_LINE_NUMBER := OE_QUERY.OPTION_LINE_NUMBER (P_PARENT_LINE_ID, P_SERVICE_PARENT_LINE_ID,
21: P_SHIPMENT_SCHEDULE_LINE_ID, P_LINE_NUMBER);

Line 20: P_OPTION_LINE_NUMBER := OE_QUERY.OPTION_LINE_NUMBER (P_PARENT_LINE_ID, P_SERVICE_PARENT_LINE_ID,

16: P_SHIPMENT_SCHEDULE_LINE_ID, P_LINE_NUMBER);
17: P_SHIPMENT_SCHEDULE_NUMBER := OE_QUERY.SHIPMENT_SCHEDULE_NUMBER (P_PARENT_LINE_ID,
18: P_SERVICE_PARENT_LINE_ID, P_SHIPMENT_SCHEDULE_LINE_ID,
19: P_LINE_NUMBER);
20: P_OPTION_LINE_NUMBER := OE_QUERY.OPTION_LINE_NUMBER (P_PARENT_LINE_ID, P_SERVICE_PARENT_LINE_ID,
21: P_SHIPMENT_SCHEDULE_LINE_ID, P_LINE_NUMBER);
22: END GET_LINE_TRIPLET;
23:
24: procedure GET_LINE_QUADRUPLET(

Line 44: P_BASE_LINE_NUMBER := OE_QUERY.BASE_LINE_NUMBER (V_PARENT_LINE_ID, V_SERVICE_PARENT_LINE_ID,

40: V_LINE_NUMBER
41: FROM SO_LINES
42: WHERE LINE_ID = P_LINE_ID;
43:
44: P_BASE_LINE_NUMBER := OE_QUERY.BASE_LINE_NUMBER (V_PARENT_LINE_ID, V_SERVICE_PARENT_LINE_ID,
45: V_SHIPMENT_SCHEDULE_LINE_ID, V_LINE_NUMBER);
46: P_SHIPMENT_SCHEDULE_NUMBER := OE_QUERY.SHIPMENT_SCHEDULE_NUMBER (V_PARENT_LINE_ID,
47: V_SERVICE_PARENT_LINE_ID, V_SHIPMENT_SCHEDULE_LINE_ID,
48: V_LINE_NUMBER);

Line 46: P_SHIPMENT_SCHEDULE_NUMBER := OE_QUERY.SHIPMENT_SCHEDULE_NUMBER (V_PARENT_LINE_ID,

42: WHERE LINE_ID = P_LINE_ID;
43:
44: P_BASE_LINE_NUMBER := OE_QUERY.BASE_LINE_NUMBER (V_PARENT_LINE_ID, V_SERVICE_PARENT_LINE_ID,
45: V_SHIPMENT_SCHEDULE_LINE_ID, V_LINE_NUMBER);
46: P_SHIPMENT_SCHEDULE_NUMBER := OE_QUERY.SHIPMENT_SCHEDULE_NUMBER (V_PARENT_LINE_ID,
47: V_SERVICE_PARENT_LINE_ID, V_SHIPMENT_SCHEDULE_LINE_ID,
48: V_LINE_NUMBER);
49: P_OPTION_LINE_NUMBER := OE_QUERY.OPTION_LINE_NUMBER (V_PARENT_LINE_ID, V_SERVICE_PARENT_LINE_ID,
50: V_SHIPMENT_SCHEDULE_LINE_ID, V_LINE_NUMBER);

Line 49: P_OPTION_LINE_NUMBER := OE_QUERY.OPTION_LINE_NUMBER (V_PARENT_LINE_ID, V_SERVICE_PARENT_LINE_ID,

45: V_SHIPMENT_SCHEDULE_LINE_ID, V_LINE_NUMBER);
46: P_SHIPMENT_SCHEDULE_NUMBER := OE_QUERY.SHIPMENT_SCHEDULE_NUMBER (V_PARENT_LINE_ID,
47: V_SERVICE_PARENT_LINE_ID, V_SHIPMENT_SCHEDULE_LINE_ID,
48: V_LINE_NUMBER);
49: P_OPTION_LINE_NUMBER := OE_QUERY.OPTION_LINE_NUMBER (V_PARENT_LINE_ID, V_SERVICE_PARENT_LINE_ID,
50: V_SHIPMENT_SCHEDULE_LINE_ID, V_LINE_NUMBER);
51:
52: IF (V_SERVICE_PARENT_LINE_ID IS NULL) THEN
53: P_SERVICE_LINE_NUMBER := NULL;