PACKAGE: APPS.BPEL_UPDATEORDEREBS11I10TOCOMS

Source

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_)
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;
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 
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;
35 
36   PROCEDURE OE_SYNC_ORDER_PVT$PROCESS_ORD
37           (P_HEADER_ID NUMBER,
38            P_HDR_REQ_ID NUMBER,
39            P_LINE_ID NUMBER,
40            P_LIN_REQ_ID NUMBER,
41            P_HOLD_SOURCE_ID NUMBER,
42            P_ORDER_HOLD_ID NUMBER,
43            P_CHANGE_TYPE VARCHAR2,
44            P_HDR_ACK_TBL OUT NOCOPY OE_SYNC_ORDER_PVT_HEADER_ACK_,
45            P_LINE_ACK_TBL OUT NOCOPY OE_SYNC_ORDER_PVT_LINE_ACK_TB,
46            X_RETURN_STATUS OUT NOCOPY VARCHAR2,
47            X_MSG_COUNT OUT NOCOPY NUMBER,
48            X_MSG_DATA OUT NOCOPY VARCHAR2);
49 
50 END BPEL_UPDATEORDEREBS11I10TOCOMS;
51