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
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,
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,
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,
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;
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;
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;
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
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));
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;
1858: X_MSG_DATA OUT NOCOPY VARCHAR2)
1859: IS
1860:
1861: P_HDR_ACK_TBL_ APPS.OE_ACKNOWLEDGMENT_PUB.HEADER_ACK_TBL_TYPE;
1862: P_LINE_ACK_TBL_ APPS.OE_ACKNOWLEDGMENT_PUB.LINE_ACK_TBL_TYPE;
1863: BEGIN
1864:
1865: oe_debug_pub.add('Entering Procedure Sync_Order');
1866: