[Home] [Help]
PACKAGE BODY: APPS.BPEL_UPDATEORDEREBS11I10TOCOMS
Source
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);
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);
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;
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;
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;
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;
68 END SQL_TO_PL1;
69
70 PROCEDURE OE_SYNC_ORDER_PVT$PROCESS_ORD (
71 P_HEADER_ID NUMBER,
72 P_HDR_REQ_ID NUMBER,
73 P_LINE_ID NUMBER,
74 P_LIN_REQ_ID NUMBER,
75 P_HOLD_SOURCE_ID NUMBER,
76 P_ORDER_HOLD_ID NUMBER,
77 P_CHANGE_TYPE VARCHAR2,
78 P_HDR_ACK_TBL OUT NOCOPY OE_SYNC_ORDER_PVT_HEADER_ACK_,
79 P_LINE_ACK_TBL OUT NOCOPY OE_SYNC_ORDER_PVT_LINE_ACK_TB,
80 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
81 X_MSG_COUNT OUT NOCOPY NUMBER,
82 X_MSG_DATA OUT NOCOPY VARCHAR2)
83 IS
84 BEGIN
85 oe_debug_pub.add('Entering Procedure oe_outbound_int.sync_order...');
86
87 oe_outbound_int.Sync_Order
88 (
89 P_HEADER_ID,
90 P_HDR_REQ_ID,
91 P_LINE_ID,
92 P_LIN_REQ_ID,
93 P_HOLD_SOURCE_ID,
94 P_ORDER_HOLD_ID,
95 P_CHANGE_TYPE,
96 P_HDR_ACK_TBL,
97 P_LINE_ACK_TBL,
98 X_RETURN_STATUS,
99 X_MSG_COUNT,
100 X_MSG_DATA
101 );
102 oe_debug_pub.add('Entering Procedure oe_outbound_int.sync_order...');
103 END OE_SYNC_ORDER_PVT$PROCESS_ORD;
104
105 END BPEL_UPDATEORDEREBS11I10TOCOMS;
106