1: PACKAGE BPEL_UPDATEORDEREBS11I10TOCOMS AS
2: /* $Header: OEXCGNOS.pls 120.1 2007/12/14 09:53:58 sahvivek noship $ */
3:
4: -- Declare the conversion functions the PL/SQL
5: -- type OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE
6: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE)
7: RETURN OE_ACKNOWLEDGMENT_PUB_HEADER_;
8:
9: FUNCTION SQL_TO_PL2(aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_)
2: /* $Header: OEXCGNOS.pls 120.1 2007/12/14 09:53:58 sahvivek noship $ */
3:
4: -- Declare the conversion functions the PL/SQL
5: -- type OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE
6: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE)
7: RETURN OE_ACKNOWLEDGMENT_PUB_HEADER_;
8:
9: FUNCTION SQL_TO_PL2(aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_)
10: RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE;
3:
4: -- Declare the conversion functions the PL/SQL
5: -- type OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE
6: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE)
7: RETURN OE_ACKNOWLEDGMENT_PUB_HEADER_;
8:
9: FUNCTION SQL_TO_PL2(aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_)
10: RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE;
11:
5: -- type OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE
6: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE)
7: RETURN OE_ACKNOWLEDGMENT_PUB_HEADER_;
8:
9: FUNCTION SQL_TO_PL2(aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_)
10: RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE;
11:
12: -- Declare the conversion functions the PL/SQL
13: -- type OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE
6: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE)
7: RETURN OE_ACKNOWLEDGMENT_PUB_HEADER_;
8:
9: FUNCTION SQL_TO_PL2(aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_)
10: RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE;
11:
12: -- Declare the conversion functions the PL/SQL
13: -- type OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE
14: FUNCTION PL_TO_SQL0(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE)
9: FUNCTION SQL_TO_PL2(aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_)
10: RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE;
11:
12: -- Declare the conversion functions the PL/SQL
13: -- type OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE
14: FUNCTION PL_TO_SQL0(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE)
15: RETURN OE_SYNC_ORDER_PVT_HEADER_ACK_;
16:
17: FUNCTION SQL_TO_PL0(aSqlItem OE_SYNC_ORDER_PVT_HEADER_ACK_)
10: RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE;
11:
12: -- Declare the conversion functions the PL/SQL
13: -- type OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE
14: FUNCTION PL_TO_SQL0(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE)
15: RETURN OE_SYNC_ORDER_PVT_HEADER_ACK_;
16:
17: FUNCTION SQL_TO_PL0(aSqlItem OE_SYNC_ORDER_PVT_HEADER_ACK_)
18: RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE;
14: FUNCTION PL_TO_SQL0(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE)
15: RETURN OE_SYNC_ORDER_PVT_HEADER_ACK_;
16:
17: FUNCTION SQL_TO_PL0(aSqlItem OE_SYNC_ORDER_PVT_HEADER_ACK_)
18: RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE;
19:
20: -- Declare the conversion functions the PL/SQL
21: -- type OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE
22: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE)
17: FUNCTION SQL_TO_PL0(aSqlItem OE_SYNC_ORDER_PVT_HEADER_ACK_)
18: RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE;
19:
20: -- Declare the conversion functions the PL/SQL
21: -- type OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE
22: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE)
23: RETURN OE_ACKNOWLEDGMENT_PUB_LINE_AC;
24:
25: FUNCTION SQL_TO_PL3(aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC)
18: RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE;
19:
20: -- Declare the conversion functions the PL/SQL
21: -- type OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE
22: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE)
23: RETURN OE_ACKNOWLEDGMENT_PUB_LINE_AC;
24:
25: FUNCTION SQL_TO_PL3(aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC)
26: RETURN OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE;
19:
20: -- Declare the conversion functions the PL/SQL
21: -- type OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE
22: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE)
23: RETURN OE_ACKNOWLEDGMENT_PUB_LINE_AC;
24:
25: FUNCTION SQL_TO_PL3(aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC)
26: RETURN OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE;
27:
21: -- type OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE
22: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE)
23: RETURN OE_ACKNOWLEDGMENT_PUB_LINE_AC;
24:
25: FUNCTION SQL_TO_PL3(aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC)
26: RETURN OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE;
27:
28: -- Declare the conversion functions the PL/SQL
29: -- type OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE
22: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE)
23: RETURN OE_ACKNOWLEDGMENT_PUB_LINE_AC;
24:
25: FUNCTION SQL_TO_PL3(aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC)
26: RETURN OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE;
27:
28: -- Declare the conversion functions the PL/SQL
29: -- type OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE
30: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE)
25: FUNCTION SQL_TO_PL3(aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC)
26: RETURN OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE;
27:
28: -- Declare the conversion functions the PL/SQL
29: -- type OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE
30: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE)
31: RETURN OE_SYNC_ORDER_PVT_LINE_ACK_TB;
32:
33: FUNCTION SQL_TO_PL1(aSqlItem OE_SYNC_ORDER_PVT_LINE_ACK_TB)
26: RETURN OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE;
27:
28: -- Declare the conversion functions the PL/SQL
29: -- type OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE
30: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE)
31: RETURN OE_SYNC_ORDER_PVT_LINE_ACK_TB;
32:
33: FUNCTION SQL_TO_PL1(aSqlItem OE_SYNC_ORDER_PVT_LINE_ACK_TB)
34: RETURN OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE;
30: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE)
31: RETURN OE_SYNC_ORDER_PVT_LINE_ACK_TB;
32:
33: FUNCTION SQL_TO_PL1(aSqlItem OE_SYNC_ORDER_PVT_LINE_ACK_TB)
34: RETURN OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE;
35:
36: PROCEDURE OE_SYNC_ORDER_PVT$PROCESS_ORD
37: (P_HEADER_ID NUMBER,
38: P_HDR_REQ_ID NUMBER,