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