PACKAGE: APPS.OE_OUTBOUND_INT

Source

1 PACKAGE Oe_Outbound_Int AUTHID CURRENT_USER AS
2 /* $Header: OEXOEOBS.pls 120.0.12010000.2 2009/06/16 09:46:35 snimmaga ship $ */
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 Sync_Order
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 
51 ----- O2C25
52   PROCEDURE Sync_Order_25
53           (P_HEADER_ID          NUMBER,
54            P_HDR_REQ_ID         NUMBER,
55            P_LINE_ID            NUMBER,
56            P_LIN_REQ_ID         NUMBER,
57            P_HOLD_SOURCE_ID     NUMBER,
58            P_ORDER_HOLD_ID      NUMBER,
59            P_CHANGE_TYPE        VARCHAR2,
60            P_HDR_ACK_TBL25    OUT NOCOPY oe_ack_pub_hdr_tab25,
61            P_LINE_ACK_TBL25   OUT NOCOPY oe_ack_pub_line_tab25,
62            X_RETURN_STATUS    OUT NOCOPY VARCHAR2,
63            X_MSG_COUNT        OUT NOCOPY NUMBER,
64            X_MSG_DATA         OUT NOCOPY VARCHAR2
65           );
66 ----- O2C25
67 
68 END Oe_Outbound_Int;