APPS.OE_OUTBOUND_INT dependencies on OE_SYNC_ORDER_PVT_LINE_ACK_TB

Line 1825: RETURN OE_SYNC_ORDER_PVT_LINE_ACK_TB IS

1821: aPlsqlItem.DELIVER_TO_CONTACT := aSqlItem.DELIVER_TO_CONTACT;
1822: RETURN aPlsqlItem;
1823: END SQL_TO_PL3;
1824: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE)
1825: RETURN OE_SYNC_ORDER_PVT_LINE_ACK_TB IS
1826: aSqlItem OE_SYNC_ORDER_PVT_LINE_ACK_TB;
1827: BEGIN
1828: -- initialize the table
1829: aSqlItem := OE_SYNC_ORDER_PVT_LINE_ACK_TB();

Line 1826: aSqlItem OE_SYNC_ORDER_PVT_LINE_ACK_TB;

1822: RETURN aPlsqlItem;
1823: END SQL_TO_PL3;
1824: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE)
1825: RETURN OE_SYNC_ORDER_PVT_LINE_ACK_TB IS
1826: aSqlItem OE_SYNC_ORDER_PVT_LINE_ACK_TB;
1827: BEGIN
1828: -- initialize the table
1829: aSqlItem := OE_SYNC_ORDER_PVT_LINE_ACK_TB();
1830: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 1829: aSqlItem := OE_SYNC_ORDER_PVT_LINE_ACK_TB();

1825: RETURN OE_SYNC_ORDER_PVT_LINE_ACK_TB IS
1826: aSqlItem OE_SYNC_ORDER_PVT_LINE_ACK_TB;
1827: BEGIN
1828: -- initialize the table
1829: aSqlItem := OE_SYNC_ORDER_PVT_LINE_ACK_TB();
1830: aSqlItem.EXTEND(aPlsqlItem.COUNT);
1831: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
1832: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL3(aPlsqlItem(I));
1833: END LOOP;

Line 1836: FUNCTION SQL_TO_PL1(aSqlItem OE_SYNC_ORDER_PVT_LINE_ACK_TB)

1832: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL3(aPlsqlItem(I));
1833: END LOOP;
1834: RETURN aSqlItem;
1835: END PL_TO_SQL1;
1836: FUNCTION SQL_TO_PL1(aSqlItem OE_SYNC_ORDER_PVT_LINE_ACK_TB)
1837: RETURN OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE IS
1838: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE;
1839: BEGIN
1840: FOR I IN 1..aSqlItem.COUNT LOOP

Line 1855: P_LINE_ACK_TBL OUT NOCOPY OE_SYNC_ORDER_PVT_LINE_ACK_TB,

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)
1859: IS

Line 1913: P_LINE_ACK_TBL_ OE_SYNC_ORDER_PVT_LINE_ACK_TB;

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
1917: IF l_debug_level > 0 THEN