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