DBA Data[Home] [Help]

APPS.BPEL_UPDATEORDEREBS11I10TOCOMS dependencies on OE_SYNC_ORDER_PVT_LINE_ACK_TB

Line 55: RETURN OE_SYNC_ORDER_PVT_LINE_ACK_TB IS

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;

Line 56: aSqlItem OE_SYNC_ORDER_PVT_LINE_ACK_TB;

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;

Line 62: FUNCTION SQL_TO_PL1(aSqlItem OE_SYNC_ORDER_PVT_LINE_ACK_TB)

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

Line 79: P_LINE_ACK_TBL OUT NOCOPY OE_SYNC_ORDER_PVT_LINE_ACK_TB,

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