eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_OUTBOUND_INT dependencies on OE_SYNC_ORDER_PVT

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 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 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 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 1867: OE_SYNC_ORDER_PVT.PROCESS_ORDER_SYNC(

1863: BEGIN
1864:
1865: oe_debug_pub.add('Entering Procedure Sync_Order');
1866:
1867: OE_SYNC_ORDER_PVT.PROCESS_ORDER_SYNC(
1868: P_HEADER_ID,
1869: P_HDR_REQ_ID,
1870: P_LINE_ID,
1871: P_LIN_REQ_ID,

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

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