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 4: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE)

1: PACKAGE BODY Oe_Outbound_Int AS
2: /* $Header: OEXOEOBB.pls 120.4 2011/04/25 07:04:08 snimmaga ship $ */
3:
4: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE)
5: RETURN OE_ACKNOWLEDGMENT_PUB_HEADER_ IS
6: aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_;
7: BEGIN
8: -- initialize the object

Line 5: RETURN OE_ACKNOWLEDGMENT_PUB_HEADER_ IS

1: PACKAGE BODY Oe_Outbound_Int AS
2: /* $Header: OEXOEOBB.pls 120.4 2011/04/25 07:04:08 snimmaga ship $ */
3:
4: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE)
5: RETURN OE_ACKNOWLEDGMENT_PUB_HEADER_ IS
6: aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_;
7: BEGIN
8: -- initialize the object
9: aSqlItem := OE_ACKNOWLEDGMENT_PUB_HEADER_(NULL, NULL, NULL, NULL, NULL,

Line 6: aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_;

2: /* $Header: OEXOEOBB.pls 120.4 2011/04/25 07:04:08 snimmaga ship $ */
3:
4: FUNCTION PL_TO_SQL2(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE)
5: RETURN OE_ACKNOWLEDGMENT_PUB_HEADER_ IS
6: aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_;
7: BEGIN
8: -- initialize the object
9: aSqlItem := OE_ACKNOWLEDGMENT_PUB_HEADER_(NULL, NULL, NULL, NULL, NULL,
10: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 9: aSqlItem := OE_ACKNOWLEDGMENT_PUB_HEADER_(NULL, NULL, NULL, NULL, NULL,

5: RETURN OE_ACKNOWLEDGMENT_PUB_HEADER_ IS
6: aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_;
7: BEGIN
8: -- initialize the object
9: aSqlItem := OE_ACKNOWLEDGMENT_PUB_HEADER_(NULL, NULL, NULL, NULL, NULL,
10: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
11: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
12: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
13: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,

Line 380: FUNCTION SQL_TO_PL2(aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_)

376: aSqlItem.ACCOUNTING_RULE := aPlsqlItem.ACCOUNTING_RULE;
377: aSqlItem.ACKNOWLEDGMENT_FLAG := aPlsqlItem.ACKNOWLEDGMENT_FLAG;
378: RETURN aSqlItem;
379: END PL_TO_SQL2;
380: FUNCTION SQL_TO_PL2(aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_)
381: RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE IS
382: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE;
383: BEGIN
384: aPlsqlItem.IB_OWNER_CODE := aSqlItem.IB_OWNER_CODE;

Line 381: RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE IS

377: aSqlItem.ACKNOWLEDGMENT_FLAG := aPlsqlItem.ACKNOWLEDGMENT_FLAG;
378: RETURN aSqlItem;
379: END PL_TO_SQL2;
380: FUNCTION SQL_TO_PL2(aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_)
381: RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE IS
382: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE;
383: BEGIN
384: aPlsqlItem.IB_OWNER_CODE := aSqlItem.IB_OWNER_CODE;
385: aPlsqlItem.IB_CURRENT_LOCATION_CODE := aSqlItem.IB_CURRENT_LOCATION_CODE;

Line 382: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE;

378: RETURN aSqlItem;
379: END PL_TO_SQL2;
380: FUNCTION SQL_TO_PL2(aSqlItem OE_ACKNOWLEDGMENT_PUB_HEADER_)
381: RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE IS
382: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_REC_TYPE;
383: BEGIN
384: aPlsqlItem.IB_OWNER_CODE := aSqlItem.IB_OWNER_CODE;
385: aPlsqlItem.IB_CURRENT_LOCATION_CODE := aSqlItem.IB_CURRENT_LOCATION_CODE;
386: aPlsqlItem.IB_INSTALLED_AT_LOCATION_CODE := aSqlItem.IB_INSTALLED_AT_LOCATION_CODE;

Line 727: FUNCTION PL_TO_SQL0(aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE)

723: aPlsqlItem.ACCOUNTING_RULE := aSqlItem.ACCOUNTING_RULE;
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

Line 740: RETURN OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE IS

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

Line 741: aPlsqlItem OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE;

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
744: aPlsqlItem(I) := SQL_TO_PL2(aSqlItem(I));
745: END LOOP;

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 1861: P_HDR_ACK_TBL_ OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE;

1857: X_MSG_COUNT OUT NOCOPY NUMBER,
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');

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: