1 PACKAGE OE_LINE_UTILITY AUTHID CURRENT_USER as
2 /* $Header: OEXLUTSS.pls 115.0 99/07/16 08:13:26 porting ship $ */
3
4 procedure GET_LINE_TRIPLET(
5 P_PARENT_LINE_ID IN NUMBER DEFAULT NULL
6 , P_SERVICE_PARENT_LINE_ID IN NUMBER DEFAULT NULL
7 , P_SHIPMENT_SCHEDULE_LINE_ID IN NUMBER DEFAULT NULL
8 , P_LINE_NUMBER IN NUMBER DEFAULT NULL
9 , P_BASE_LINE_NUMBER OUT NUMBER
10 , P_SHIPMENT_SCHEDULE_NUMBER OUT NUMBER
11 , P_OPTION_LINE_NUMBER OUT NUMBER
12 );
13
14 procedure GET_LINE_QUADRUPLET(
15 P_LINE_ID IN NUMBER
16 , P_BASE_LINE_NUMBER OUT NUMBER
17 , P_SHIPMENT_SCHEDULE_NUMBER OUT NUMBER
18 , P_OPTION_LINE_NUMBER OUT NUMBER
19 , P_SERVICE_LINE_NUMBER OUT NUMBER
20 );
21
22 END OE_LINE_UTILITY;