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