DBA Data[Home] [Help]

APPS.BPEL_UPDATEORDEREBS11I10TOCOMS dependencies on OE_ACKNOWLEDGMENT_PUB

Line 5: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE)

1: PACKAGE BODY BPEL_UPDATEORDEREBS11I10TOCOMS AS
2: /* $Header: OEXCGNOB.pls 120.2 2007/12/19 13:33:16 sahvivek noship $ */
3:
4:
5: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE)
6: RETURN OE_ACKNOWLEDGMENT_PUB_HEADER_ IS
7: aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_;
8: BEGIN
9: aSqlItem := oe_outbound_int.PL_TO_SQL2(aPlsqlItem);

Line 6: RETURN OE_ACKNOWLEDGMENT_PUB_HEADER_ IS

2: /* $Header: OEXCGNOB.pls 120.2 2007/12/19 13:33:16 sahvivek noship $ */
3:
4:
5: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE)
6: RETURN OE_ACKNOWLEDGMENT_PUB_HEADER_ IS
7: aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_;
8: BEGIN
9: aSqlItem := oe_outbound_int.PL_TO_SQL2(aPlsqlItem);
10: RETURN aSqlItem;

Line 7: aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_;

3:
4:
5: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE)
6: RETURN OE_ACKNOWLEDGMENT_PUB_HEADER_ IS
7: aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_;
8: BEGIN
9: aSqlItem := oe_outbound_int.PL_TO_SQL2(aPlsqlItem);
10: RETURN aSqlItem;
11: END PL_TO_SQL2;

Line 14: FUNCTION SQL_TO_PL2(aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_)

10: RETURN aSqlItem;
11: END PL_TO_SQL2;
12:
13:
14: FUNCTION SQL_TO_PL2(aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_)
15: RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE IS
16: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE;
17: BEGIN
18: aPlsqlItem := oe_outbound_int.SQL_TO_PL2(aSqlItem);

Line 15: RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE IS

11: END PL_TO_SQL2;
12:
13:
14: FUNCTION SQL_TO_PL2(aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_)
15: RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE IS
16: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE;
17: BEGIN
18: aPlsqlItem := oe_outbound_int.SQL_TO_PL2(aSqlItem);
19: RETURN aPlsqlItem;

Line 16: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE;

12:
13:
14: FUNCTION SQL_TO_PL2(aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_)
15: RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE IS
16: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE;
17: BEGIN
18: aPlsqlItem := oe_outbound_int.SQL_TO_PL2(aSqlItem);
19: RETURN aPlsqlItem;
20: END SQL_TO_PL2;

Line 22: FUNCTION PL_TO_SQL0(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE)

18: aPlsqlItem := oe_outbound_int.SQL_TO_PL2(aSqlItem);
19: RETURN aPlsqlItem;
20: END SQL_TO_PL2;
21:
22: FUNCTION PL_TO_SQL0(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE)
23: RETURN OE_SYNC_ORDER_PVT_HEADER_ACK_ IS
24: aSqlItem OE_SYNC_ORDER_PVT_HEADER_ACK_;
25: BEGIN
26: aSqlItem := oe_outbound_int.PL_TO_SQL0(aPlsqlItem);

Line 31: RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE IS

27: RETURN aSqlItem;
28: END PL_TO_SQL0;
29:
30: FUNCTION SQL_TO_PL0(aSqlItem OE_SYNC_ORDER_PVT_HEADER_ACK_)
31: RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE IS
32: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE;
33: BEGIN
34: aPlsqlItem := oe_outbound_int.SQL_TO_PL0(aSqlItem);
35: RETURN aPlsqlItem;

Line 32: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE;

28: END PL_TO_SQL0;
29:
30: FUNCTION SQL_TO_PL0(aSqlItem OE_SYNC_ORDER_PVT_HEADER_ACK_)
31: RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE IS
32: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE;
33: BEGIN
34: aPlsqlItem := oe_outbound_int.SQL_TO_PL0(aSqlItem);
35: RETURN aPlsqlItem;
36: END SQL_TO_PL0;

Line 38: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE)

34: aPlsqlItem := oe_outbound_int.SQL_TO_PL0(aSqlItem);
35: RETURN aPlsqlItem;
36: END SQL_TO_PL0;
37:
38: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE)
39: RETURN OE_ACKNOWLEDGMENT_PUB_LINE_AC IS
40: aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC;
41: BEGIN
42: aSqlItem := oe_outbound_int.PL_TO_SQL3(aPlsqlItem);

Line 39: RETURN OE_ACKNOWLEDGMENT_PUB_LINE_AC IS

35: RETURN aPlsqlItem;
36: END SQL_TO_PL0;
37:
38: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE)
39: RETURN OE_ACKNOWLEDGMENT_PUB_LINE_AC IS
40: aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC;
41: BEGIN
42: aSqlItem := oe_outbound_int.PL_TO_SQL3(aPlsqlItem);
43: RETURN aSqlItem;

Line 40: aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC;

36: END SQL_TO_PL0;
37:
38: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE)
39: RETURN OE_ACKNOWLEDGMENT_PUB_LINE_AC IS
40: aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC;
41: BEGIN
42: aSqlItem := oe_outbound_int.PL_TO_SQL3(aPlsqlItem);
43: RETURN aSqlItem;
44: END PL_TO_SQL3;

Line 46: FUNCTION SQL_TO_PL3(aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC)

42: aSqlItem := oe_outbound_int.PL_TO_SQL3(aPlsqlItem);
43: RETURN aSqlItem;
44: END PL_TO_SQL3;
45:
46: FUNCTION SQL_TO_PL3(aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC)
47: RETURN OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE IS
48: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE;
49: BEGIN
50: aPlsqlItem := oe_outbound_int.SQL_TO_PL3(aSqlItem);

Line 47: RETURN OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE IS

43: RETURN aSqlItem;
44: END PL_TO_SQL3;
45:
46: FUNCTION SQL_TO_PL3(aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC)
47: RETURN OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE IS
48: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE;
49: BEGIN
50: aPlsqlItem := oe_outbound_int.SQL_TO_PL3(aSqlItem);
51: RETURN aPlsqlItem;

Line 48: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE;

44: END PL_TO_SQL3;
45:
46: FUNCTION SQL_TO_PL3(aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC)
47: RETURN OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE IS
48: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE;
49: BEGIN
50: aPlsqlItem := oe_outbound_int.SQL_TO_PL3(aSqlItem);
51: RETURN aPlsqlItem;
52: END SQL_TO_PL3;

Line 54: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE)

50: aPlsqlItem := oe_outbound_int.SQL_TO_PL3(aSqlItem);
51: RETURN aPlsqlItem;
52: END SQL_TO_PL3;
53:
54: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE)
55: RETURN OE_SYNC_ORDER_PVT_LINE_ACK_TB IS
56: aSqlItem OE_SYNC_ORDER_PVT_LINE_ACK_TB;
57: BEGIN
58: aSqlItem := oe_outbound_int.PL_TO_SQL1(aPlsqlItem);

Line 63: RETURN OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE IS

59: RETURN aSqlItem;
60: END PL_TO_SQL1;
61:
62: FUNCTION SQL_TO_PL1(aSqlItem OE_SYNC_ORDER_PVT_LINE_ACK_TB)
63: RETURN OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE IS
64: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE;
65: BEGIN
66: aPlsqlItem := oe_outbound_int.SQL_TO_PL1(aSqlItem);
67: RETURN aPlsqlItem;

Line 64: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE;

60: END PL_TO_SQL1;
61:
62: FUNCTION SQL_TO_PL1(aSqlItem OE_SYNC_ORDER_PVT_LINE_ACK_TB)
63: RETURN OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE IS
64: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE;
65: BEGIN
66: aPlsqlItem := oe_outbound_int.SQL_TO_PL1(aSqlItem);
67: RETURN aPlsqlItem;
68: END SQL_TO_PL1;