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