DBA Data[Home] [Help]

APPS.BPEL_UPDATEORDEREBS11I10TOCOMS dependencies on OE_ACKNOWLEDGMENT_PUB

Line 5: -- type OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE

1: PACKAGE BPEL_UPDATEORDEREBS11I10TOCOMS AUTHID CURRENT_USER 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_)

Line 6: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE)

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;

Line 7: RETURN OE_ACKNOWLEDGMENT_PUB_HEADER_;

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:

Line 9: FUNCTION SQL_TO_PL2(aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_)

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

Line 10: RETURN 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
14: FUNCTION PL_TO_SQL0(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE)

Line 13: -- type 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_)

Line 14: FUNCTION PL_TO_SQL0(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE)

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;

Line 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)

Line 21: -- type 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)

Line 22: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE)

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;

Line 23: RETURN OE_ACKNOWLEDGMENT_PUB_LINE_AC;

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:

Line 25: FUNCTION SQL_TO_PL3(aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC)

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

Line 26: RETURN 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
30: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE)

Line 29: -- type 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)

Line 30: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE)

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;

Line 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,