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_ACKNOWLEDGMENT_PUB_LINE_AC

Line 748: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE)

744: aPlsqlItem(I) := SQL_TO_PL2(aSqlItem(I));
745: END LOOP;
746: RETURN aPlsqlItem;
747: END SQL_TO_PL0;
748: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE)
749: RETURN OE_ACKNOWLEDGMENT_PUB_LINE_AC IS
750: aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC;
751: BEGIN
752: -- initialize the object

Line 749: RETURN OE_ACKNOWLEDGMENT_PUB_LINE_AC IS

745: END LOOP;
746: RETURN aPlsqlItem;
747: END SQL_TO_PL0;
748: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE)
749: RETURN OE_ACKNOWLEDGMENT_PUB_LINE_AC IS
750: aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC;
751: BEGIN
752: -- initialize the object
753: aSqlItem := OE_ACKNOWLEDGMENT_PUB_LINE_AC(NULL, NULL, NULL, NULL,

Line 750: aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC;

746: RETURN aPlsqlItem;
747: END SQL_TO_PL0;
748: FUNCTION PL_TO_SQL3(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE)
749: RETURN OE_ACKNOWLEDGMENT_PUB_LINE_AC IS
750: aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC;
751: BEGIN
752: -- initialize the object
753: aSqlItem := OE_ACKNOWLEDGMENT_PUB_LINE_AC(NULL, NULL, NULL, NULL,
754: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 753: aSqlItem := OE_ACKNOWLEDGMENT_PUB_LINE_AC(NULL, NULL, NULL, NULL,

749: RETURN OE_ACKNOWLEDGMENT_PUB_LINE_AC IS
750: aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC;
751: BEGIN
752: -- initialize the object
753: aSqlItem := OE_ACKNOWLEDGMENT_PUB_LINE_AC(NULL, NULL, NULL, NULL,
754: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
755: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
756: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
757: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 1309: FUNCTION SQL_TO_PL3(aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC)

1305: aSqlItem.DELIVERY_ID := aPlsqlItem.DELIVERY_ID;
1306: aSqlItem.DELIVER_TO_CONTACT := aPlsqlItem.DELIVER_TO_CONTACT;
1307: RETURN aSqlItem;
1308: END PL_TO_SQL3;
1309: FUNCTION SQL_TO_PL3(aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC)
1310: RETURN OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE IS
1311: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE;
1312: BEGIN
1313: aPlsqlItem.END_CUSTOMER_CONTACT_LAST_NAME := aSqlItem.END_CUSTOMER_CONTACT_LAST_NAME;

Line 1310: RETURN OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE IS

1306: aSqlItem.DELIVER_TO_CONTACT := aPlsqlItem.DELIVER_TO_CONTACT;
1307: RETURN aSqlItem;
1308: END PL_TO_SQL3;
1309: FUNCTION SQL_TO_PL3(aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC)
1310: RETURN OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE IS
1311: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE;
1312: BEGIN
1313: aPlsqlItem.END_CUSTOMER_CONTACT_LAST_NAME := aSqlItem.END_CUSTOMER_CONTACT_LAST_NAME;
1314: aPlsqlItem.END_CUSTOMER_CONTACT_FIRST_NAM := aSqlItem.END_CUSTOMER_CONTACT_FIRST_NAM;

Line 1311: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE;

1307: RETURN aSqlItem;
1308: END PL_TO_SQL3;
1309: FUNCTION SQL_TO_PL3(aSqlItem OE_ACKNOWLEDGMENT_PUB_LINE_AC)
1310: RETURN OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE IS
1311: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_REC_TYPE;
1312: BEGIN
1313: aPlsqlItem.END_CUSTOMER_CONTACT_LAST_NAME := aSqlItem.END_CUSTOMER_CONTACT_LAST_NAME;
1314: aPlsqlItem.END_CUSTOMER_CONTACT_FIRST_NAM := aSqlItem.END_CUSTOMER_CONTACT_FIRST_NAM;
1315: aPlsqlItem.END_CUSTOMER_NAME := aSqlItem.END_CUSTOMER_NAME;

Line 1824: FUNCTION PL_TO_SQL1(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE)

1820: aPlsqlItem.DELIVERY_ID := aSqlItem.DELIVERY_ID;
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

Line 1837: RETURN OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE IS

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
1841: aPlsqlItem(I) := SQL_TO_PL3(aSqlItem(I));

Line 1838: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE;

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
1841: aPlsqlItem(I) := SQL_TO_PL3(aSqlItem(I));
1842: END LOOP;

Line 1862: P_LINE_ACK_TBL_ OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE;

1858: X_MSG_DATA OUT NOCOPY VARCHAR2)
1859: IS
1860:
1861: P_HDR_ACK_TBL_ OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE;
1862: P_LINE_ACK_TBL_ OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE;
1863: BEGIN
1864:
1865: oe_debug_pub.add('Entering Procedure Sync_Order');
1866: