APPS.OE_OUTBOUND_INT dependencies on OE_SYNC_ORDER_PVT_HEADER_ACK_

Line 728: RETURN OE_SYNC_ORDER_PVT_HEADER_ACK_ IS

724: aPlsqlItem.ACKNOWLEDGMENT_FLAG := aSqlItem.ACKNOWLEDGMENT_FLAG;
725: RETURN aPlsqlItem;
726: END SQL_TO_PL2;
727: FUNCTION PL_TO_SQL0(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE)
728: RETURN OE_SYNC_ORDER_PVT_HEADER_ACK_ IS
729: aSqlItem OE_SYNC_ORDER_PVT_HEADER_ACK_;
730: BEGIN
731: -- initialize the table
732: aSqlItem := OE_SYNC_ORDER_PVT_HEADER_ACK_();

Line 729: aSqlItem OE_SYNC_ORDER_PVT_HEADER_ACK_;

725: RETURN aPlsqlItem;
726: END SQL_TO_PL2;
727: FUNCTION PL_TO_SQL0(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE)
728: RETURN OE_SYNC_ORDER_PVT_HEADER_ACK_ IS
729: aSqlItem OE_SYNC_ORDER_PVT_HEADER_ACK_;
730: BEGIN
731: -- initialize the table
732: aSqlItem := OE_SYNC_ORDER_PVT_HEADER_ACK_();
733: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 732: aSqlItem := OE_SYNC_ORDER_PVT_HEADER_ACK_();

728: RETURN OE_SYNC_ORDER_PVT_HEADER_ACK_ IS
729: aSqlItem OE_SYNC_ORDER_PVT_HEADER_ACK_;
730: BEGIN
731: -- initialize the table
732: aSqlItem := OE_SYNC_ORDER_PVT_HEADER_ACK_();
733: aSqlItem.EXTEND(aPlsqlItem.COUNT);
734: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
735: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL2(aPlsqlItem(I));
736: END LOOP;

Line 739: FUNCTION SQL_TO_PL0(aSqlItem OE_SYNC_ORDER_PVT_HEADER_ACK_)

735: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL2(aPlsqlItem(I));
736: END LOOP;
737: RETURN aSqlItem;
738: END PL_TO_SQL0;
739: FUNCTION SQL_TO_PL0(aSqlItem OE_SYNC_ORDER_PVT_HEADER_ACK_)
740: RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE IS
741: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE;
742: BEGIN
743: FOR I IN 1..aSqlItem.COUNT LOOP

Line 1854: P_HDR_ACK_TBL OUT NOCOPY OE_SYNC_ORDER_PVT_HEADER_ACK_,

1850: P_LIN_REQ_ID NUMBER,
1851: P_HOLD_SOURCE_ID NUMBER,
1852: P_ORDER_HOLD_ID NUMBER,
1853: P_CHANGE_TYPE VARCHAR2,
1854: P_HDR_ACK_TBL OUT NOCOPY OE_SYNC_ORDER_PVT_HEADER_ACK_,
1855: P_LINE_ACK_TBL OUT NOCOPY OE_SYNC_ORDER_PVT_LINE_ACK_TB,
1856: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
1857: X_MSG_COUNT OUT NOCOPY NUMBER,
1858: X_MSG_DATA OUT NOCOPY VARCHAR2)

Line 1912: P_HDR_ACK_TBL_ OE_SYNC_ORDER_PVT_HEADER_ACK_;

1908: X_MSG_COUNT OUT NOCOPY NUMBER,
1909: X_MSG_DATA OUT NOCOPY VARCHAR2
1910: )
1911: IS
1912: P_HDR_ACK_TBL_ OE_SYNC_ORDER_PVT_HEADER_ACK_;
1913: P_LINE_ACK_TBL_ OE_SYNC_ORDER_PVT_LINE_ACK_TB;
1914:
1915: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1916: BEGIN