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.CSP_PACKLIST_LINES_PVT dependencies on DBMS_SQL

Line 757: dbms_sql.define_column(p_cur_get_PLL, 1, P_PLL_Rec.PACKLIST_LINE_ID);

753: -- Debug Message
754: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Begins');
755:
756: -- define all columns for CSP_PACKLIST_LINES_V view
757: dbms_sql.define_column(p_cur_get_PLL, 1, P_PLL_Rec.PACKLIST_LINE_ID);
758: dbms_sql.define_column(p_cur_get_PLL, 2, P_PLL_Rec.ORGANIZATION_ID);
759: dbms_sql.define_column(p_cur_get_PLL, 3, P_PLL_Rec.PACKLIST_LINE_NUMBER);
760: dbms_sql.define_column(p_cur_get_PLL, 4, P_PLL_Rec.PACKLIST_HEADER_ID);
761: dbms_sql.define_column(p_cur_get_PLL, 5, P_PLL_Rec.BOX_ID);

Line 758: dbms_sql.define_column(p_cur_get_PLL, 2, P_PLL_Rec.ORGANIZATION_ID);

754: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Begins');
755:
756: -- define all columns for CSP_PACKLIST_LINES_V view
757: dbms_sql.define_column(p_cur_get_PLL, 1, P_PLL_Rec.PACKLIST_LINE_ID);
758: dbms_sql.define_column(p_cur_get_PLL, 2, P_PLL_Rec.ORGANIZATION_ID);
759: dbms_sql.define_column(p_cur_get_PLL, 3, P_PLL_Rec.PACKLIST_LINE_NUMBER);
760: dbms_sql.define_column(p_cur_get_PLL, 4, P_PLL_Rec.PACKLIST_HEADER_ID);
761: dbms_sql.define_column(p_cur_get_PLL, 5, P_PLL_Rec.BOX_ID);
762: dbms_sql.define_column(p_cur_get_PLL, 6, P_PLL_Rec.PICKLIST_LINE_ID);

Line 759: dbms_sql.define_column(p_cur_get_PLL, 3, P_PLL_Rec.PACKLIST_LINE_NUMBER);

755:
756: -- define all columns for CSP_PACKLIST_LINES_V view
757: dbms_sql.define_column(p_cur_get_PLL, 1, P_PLL_Rec.PACKLIST_LINE_ID);
758: dbms_sql.define_column(p_cur_get_PLL, 2, P_PLL_Rec.ORGANIZATION_ID);
759: dbms_sql.define_column(p_cur_get_PLL, 3, P_PLL_Rec.PACKLIST_LINE_NUMBER);
760: dbms_sql.define_column(p_cur_get_PLL, 4, P_PLL_Rec.PACKLIST_HEADER_ID);
761: dbms_sql.define_column(p_cur_get_PLL, 5, P_PLL_Rec.BOX_ID);
762: dbms_sql.define_column(p_cur_get_PLL, 6, P_PLL_Rec.PICKLIST_LINE_ID);
763: dbms_sql.define_column(p_cur_get_PLL, 7, P_PLL_Rec.PACKLIST_LINE_STATUS, 30);

Line 760: dbms_sql.define_column(p_cur_get_PLL, 4, P_PLL_Rec.PACKLIST_HEADER_ID);

756: -- define all columns for CSP_PACKLIST_LINES_V view
757: dbms_sql.define_column(p_cur_get_PLL, 1, P_PLL_Rec.PACKLIST_LINE_ID);
758: dbms_sql.define_column(p_cur_get_PLL, 2, P_PLL_Rec.ORGANIZATION_ID);
759: dbms_sql.define_column(p_cur_get_PLL, 3, P_PLL_Rec.PACKLIST_LINE_NUMBER);
760: dbms_sql.define_column(p_cur_get_PLL, 4, P_PLL_Rec.PACKLIST_HEADER_ID);
761: dbms_sql.define_column(p_cur_get_PLL, 5, P_PLL_Rec.BOX_ID);
762: dbms_sql.define_column(p_cur_get_PLL, 6, P_PLL_Rec.PICKLIST_LINE_ID);
763: dbms_sql.define_column(p_cur_get_PLL, 7, P_PLL_Rec.PACKLIST_LINE_STATUS, 30);
764: dbms_sql.define_column(p_cur_get_PLL, 8, P_PLL_Rec.INVENTORY_ITEM_ID);

Line 761: dbms_sql.define_column(p_cur_get_PLL, 5, P_PLL_Rec.BOX_ID);

757: dbms_sql.define_column(p_cur_get_PLL, 1, P_PLL_Rec.PACKLIST_LINE_ID);
758: dbms_sql.define_column(p_cur_get_PLL, 2, P_PLL_Rec.ORGANIZATION_ID);
759: dbms_sql.define_column(p_cur_get_PLL, 3, P_PLL_Rec.PACKLIST_LINE_NUMBER);
760: dbms_sql.define_column(p_cur_get_PLL, 4, P_PLL_Rec.PACKLIST_HEADER_ID);
761: dbms_sql.define_column(p_cur_get_PLL, 5, P_PLL_Rec.BOX_ID);
762: dbms_sql.define_column(p_cur_get_PLL, 6, P_PLL_Rec.PICKLIST_LINE_ID);
763: dbms_sql.define_column(p_cur_get_PLL, 7, P_PLL_Rec.PACKLIST_LINE_STATUS, 30);
764: dbms_sql.define_column(p_cur_get_PLL, 8, P_PLL_Rec.INVENTORY_ITEM_ID);
765: dbms_sql.define_column(p_cur_get_PLL, 9, P_PLL_Rec.QUANTITY_PACKED);

Line 762: dbms_sql.define_column(p_cur_get_PLL, 6, P_PLL_Rec.PICKLIST_LINE_ID);

758: dbms_sql.define_column(p_cur_get_PLL, 2, P_PLL_Rec.ORGANIZATION_ID);
759: dbms_sql.define_column(p_cur_get_PLL, 3, P_PLL_Rec.PACKLIST_LINE_NUMBER);
760: dbms_sql.define_column(p_cur_get_PLL, 4, P_PLL_Rec.PACKLIST_HEADER_ID);
761: dbms_sql.define_column(p_cur_get_PLL, 5, P_PLL_Rec.BOX_ID);
762: dbms_sql.define_column(p_cur_get_PLL, 6, P_PLL_Rec.PICKLIST_LINE_ID);
763: dbms_sql.define_column(p_cur_get_PLL, 7, P_PLL_Rec.PACKLIST_LINE_STATUS, 30);
764: dbms_sql.define_column(p_cur_get_PLL, 8, P_PLL_Rec.INVENTORY_ITEM_ID);
765: dbms_sql.define_column(p_cur_get_PLL, 9, P_PLL_Rec.QUANTITY_PACKED);
766: dbms_sql.define_column(p_cur_get_PLL, 10, P_PLL_Rec.QUANTITY_SHIPPED);

Line 763: dbms_sql.define_column(p_cur_get_PLL, 7, P_PLL_Rec.PACKLIST_LINE_STATUS, 30);

759: dbms_sql.define_column(p_cur_get_PLL, 3, P_PLL_Rec.PACKLIST_LINE_NUMBER);
760: dbms_sql.define_column(p_cur_get_PLL, 4, P_PLL_Rec.PACKLIST_HEADER_ID);
761: dbms_sql.define_column(p_cur_get_PLL, 5, P_PLL_Rec.BOX_ID);
762: dbms_sql.define_column(p_cur_get_PLL, 6, P_PLL_Rec.PICKLIST_LINE_ID);
763: dbms_sql.define_column(p_cur_get_PLL, 7, P_PLL_Rec.PACKLIST_LINE_STATUS, 30);
764: dbms_sql.define_column(p_cur_get_PLL, 8, P_PLL_Rec.INVENTORY_ITEM_ID);
765: dbms_sql.define_column(p_cur_get_PLL, 9, P_PLL_Rec.QUANTITY_PACKED);
766: dbms_sql.define_column(p_cur_get_PLL, 10, P_PLL_Rec.QUANTITY_SHIPPED);
767: dbms_sql.define_column(p_cur_get_PLL, 11, P_PLL_Rec.QUANTITY_RECEIVED);

Line 764: dbms_sql.define_column(p_cur_get_PLL, 8, P_PLL_Rec.INVENTORY_ITEM_ID);

760: dbms_sql.define_column(p_cur_get_PLL, 4, P_PLL_Rec.PACKLIST_HEADER_ID);
761: dbms_sql.define_column(p_cur_get_PLL, 5, P_PLL_Rec.BOX_ID);
762: dbms_sql.define_column(p_cur_get_PLL, 6, P_PLL_Rec.PICKLIST_LINE_ID);
763: dbms_sql.define_column(p_cur_get_PLL, 7, P_PLL_Rec.PACKLIST_LINE_STATUS, 30);
764: dbms_sql.define_column(p_cur_get_PLL, 8, P_PLL_Rec.INVENTORY_ITEM_ID);
765: dbms_sql.define_column(p_cur_get_PLL, 9, P_PLL_Rec.QUANTITY_PACKED);
766: dbms_sql.define_column(p_cur_get_PLL, 10, P_PLL_Rec.QUANTITY_SHIPPED);
767: dbms_sql.define_column(p_cur_get_PLL, 11, P_PLL_Rec.QUANTITY_RECEIVED);
768: dbms_sql.define_column(p_cur_get_PLL, 12, P_PLL_Rec.ATTRIBUTE_CATEGORY, 30);

Line 765: dbms_sql.define_column(p_cur_get_PLL, 9, P_PLL_Rec.QUANTITY_PACKED);

761: dbms_sql.define_column(p_cur_get_PLL, 5, P_PLL_Rec.BOX_ID);
762: dbms_sql.define_column(p_cur_get_PLL, 6, P_PLL_Rec.PICKLIST_LINE_ID);
763: dbms_sql.define_column(p_cur_get_PLL, 7, P_PLL_Rec.PACKLIST_LINE_STATUS, 30);
764: dbms_sql.define_column(p_cur_get_PLL, 8, P_PLL_Rec.INVENTORY_ITEM_ID);
765: dbms_sql.define_column(p_cur_get_PLL, 9, P_PLL_Rec.QUANTITY_PACKED);
766: dbms_sql.define_column(p_cur_get_PLL, 10, P_PLL_Rec.QUANTITY_SHIPPED);
767: dbms_sql.define_column(p_cur_get_PLL, 11, P_PLL_Rec.QUANTITY_RECEIVED);
768: dbms_sql.define_column(p_cur_get_PLL, 12, P_PLL_Rec.ATTRIBUTE_CATEGORY, 30);
769: dbms_sql.define_column(p_cur_get_PLL, 13, P_PLL_Rec.ATTRIBUTE1, 150);

Line 766: dbms_sql.define_column(p_cur_get_PLL, 10, P_PLL_Rec.QUANTITY_SHIPPED);

762: dbms_sql.define_column(p_cur_get_PLL, 6, P_PLL_Rec.PICKLIST_LINE_ID);
763: dbms_sql.define_column(p_cur_get_PLL, 7, P_PLL_Rec.PACKLIST_LINE_STATUS, 30);
764: dbms_sql.define_column(p_cur_get_PLL, 8, P_PLL_Rec.INVENTORY_ITEM_ID);
765: dbms_sql.define_column(p_cur_get_PLL, 9, P_PLL_Rec.QUANTITY_PACKED);
766: dbms_sql.define_column(p_cur_get_PLL, 10, P_PLL_Rec.QUANTITY_SHIPPED);
767: dbms_sql.define_column(p_cur_get_PLL, 11, P_PLL_Rec.QUANTITY_RECEIVED);
768: dbms_sql.define_column(p_cur_get_PLL, 12, P_PLL_Rec.ATTRIBUTE_CATEGORY, 30);
769: dbms_sql.define_column(p_cur_get_PLL, 13, P_PLL_Rec.ATTRIBUTE1, 150);
770: dbms_sql.define_column(p_cur_get_PLL, 14, P_PLL_Rec.ATTRIBUTE2, 150);

Line 767: dbms_sql.define_column(p_cur_get_PLL, 11, P_PLL_Rec.QUANTITY_RECEIVED);

763: dbms_sql.define_column(p_cur_get_PLL, 7, P_PLL_Rec.PACKLIST_LINE_STATUS, 30);
764: dbms_sql.define_column(p_cur_get_PLL, 8, P_PLL_Rec.INVENTORY_ITEM_ID);
765: dbms_sql.define_column(p_cur_get_PLL, 9, P_PLL_Rec.QUANTITY_PACKED);
766: dbms_sql.define_column(p_cur_get_PLL, 10, P_PLL_Rec.QUANTITY_SHIPPED);
767: dbms_sql.define_column(p_cur_get_PLL, 11, P_PLL_Rec.QUANTITY_RECEIVED);
768: dbms_sql.define_column(p_cur_get_PLL, 12, P_PLL_Rec.ATTRIBUTE_CATEGORY, 30);
769: dbms_sql.define_column(p_cur_get_PLL, 13, P_PLL_Rec.ATTRIBUTE1, 150);
770: dbms_sql.define_column(p_cur_get_PLL, 14, P_PLL_Rec.ATTRIBUTE2, 150);
771: dbms_sql.define_column(p_cur_get_PLL, 15, P_PLL_Rec.ATTRIBUTE3, 150);

Line 768: dbms_sql.define_column(p_cur_get_PLL, 12, P_PLL_Rec.ATTRIBUTE_CATEGORY, 30);

764: dbms_sql.define_column(p_cur_get_PLL, 8, P_PLL_Rec.INVENTORY_ITEM_ID);
765: dbms_sql.define_column(p_cur_get_PLL, 9, P_PLL_Rec.QUANTITY_PACKED);
766: dbms_sql.define_column(p_cur_get_PLL, 10, P_PLL_Rec.QUANTITY_SHIPPED);
767: dbms_sql.define_column(p_cur_get_PLL, 11, P_PLL_Rec.QUANTITY_RECEIVED);
768: dbms_sql.define_column(p_cur_get_PLL, 12, P_PLL_Rec.ATTRIBUTE_CATEGORY, 30);
769: dbms_sql.define_column(p_cur_get_PLL, 13, P_PLL_Rec.ATTRIBUTE1, 150);
770: dbms_sql.define_column(p_cur_get_PLL, 14, P_PLL_Rec.ATTRIBUTE2, 150);
771: dbms_sql.define_column(p_cur_get_PLL, 15, P_PLL_Rec.ATTRIBUTE3, 150);
772: dbms_sql.define_column(p_cur_get_PLL, 16, P_PLL_Rec.ATTRIBUTE4, 150);

Line 769: dbms_sql.define_column(p_cur_get_PLL, 13, P_PLL_Rec.ATTRIBUTE1, 150);

765: dbms_sql.define_column(p_cur_get_PLL, 9, P_PLL_Rec.QUANTITY_PACKED);
766: dbms_sql.define_column(p_cur_get_PLL, 10, P_PLL_Rec.QUANTITY_SHIPPED);
767: dbms_sql.define_column(p_cur_get_PLL, 11, P_PLL_Rec.QUANTITY_RECEIVED);
768: dbms_sql.define_column(p_cur_get_PLL, 12, P_PLL_Rec.ATTRIBUTE_CATEGORY, 30);
769: dbms_sql.define_column(p_cur_get_PLL, 13, P_PLL_Rec.ATTRIBUTE1, 150);
770: dbms_sql.define_column(p_cur_get_PLL, 14, P_PLL_Rec.ATTRIBUTE2, 150);
771: dbms_sql.define_column(p_cur_get_PLL, 15, P_PLL_Rec.ATTRIBUTE3, 150);
772: dbms_sql.define_column(p_cur_get_PLL, 16, P_PLL_Rec.ATTRIBUTE4, 150);
773: dbms_sql.define_column(p_cur_get_PLL, 17, P_PLL_Rec.ATTRIBUTE5, 150);

Line 770: dbms_sql.define_column(p_cur_get_PLL, 14, P_PLL_Rec.ATTRIBUTE2, 150);

766: dbms_sql.define_column(p_cur_get_PLL, 10, P_PLL_Rec.QUANTITY_SHIPPED);
767: dbms_sql.define_column(p_cur_get_PLL, 11, P_PLL_Rec.QUANTITY_RECEIVED);
768: dbms_sql.define_column(p_cur_get_PLL, 12, P_PLL_Rec.ATTRIBUTE_CATEGORY, 30);
769: dbms_sql.define_column(p_cur_get_PLL, 13, P_PLL_Rec.ATTRIBUTE1, 150);
770: dbms_sql.define_column(p_cur_get_PLL, 14, P_PLL_Rec.ATTRIBUTE2, 150);
771: dbms_sql.define_column(p_cur_get_PLL, 15, P_PLL_Rec.ATTRIBUTE3, 150);
772: dbms_sql.define_column(p_cur_get_PLL, 16, P_PLL_Rec.ATTRIBUTE4, 150);
773: dbms_sql.define_column(p_cur_get_PLL, 17, P_PLL_Rec.ATTRIBUTE5, 150);
774: dbms_sql.define_column(p_cur_get_PLL, 18, P_PLL_Rec.ATTRIBUTE6, 150);

Line 771: dbms_sql.define_column(p_cur_get_PLL, 15, P_PLL_Rec.ATTRIBUTE3, 150);

767: dbms_sql.define_column(p_cur_get_PLL, 11, P_PLL_Rec.QUANTITY_RECEIVED);
768: dbms_sql.define_column(p_cur_get_PLL, 12, P_PLL_Rec.ATTRIBUTE_CATEGORY, 30);
769: dbms_sql.define_column(p_cur_get_PLL, 13, P_PLL_Rec.ATTRIBUTE1, 150);
770: dbms_sql.define_column(p_cur_get_PLL, 14, P_PLL_Rec.ATTRIBUTE2, 150);
771: dbms_sql.define_column(p_cur_get_PLL, 15, P_PLL_Rec.ATTRIBUTE3, 150);
772: dbms_sql.define_column(p_cur_get_PLL, 16, P_PLL_Rec.ATTRIBUTE4, 150);
773: dbms_sql.define_column(p_cur_get_PLL, 17, P_PLL_Rec.ATTRIBUTE5, 150);
774: dbms_sql.define_column(p_cur_get_PLL, 18, P_PLL_Rec.ATTRIBUTE6, 150);
775: dbms_sql.define_column(p_cur_get_PLL, 19, P_PLL_Rec.ATTRIBUTE7, 150);

Line 772: dbms_sql.define_column(p_cur_get_PLL, 16, P_PLL_Rec.ATTRIBUTE4, 150);

768: dbms_sql.define_column(p_cur_get_PLL, 12, P_PLL_Rec.ATTRIBUTE_CATEGORY, 30);
769: dbms_sql.define_column(p_cur_get_PLL, 13, P_PLL_Rec.ATTRIBUTE1, 150);
770: dbms_sql.define_column(p_cur_get_PLL, 14, P_PLL_Rec.ATTRIBUTE2, 150);
771: dbms_sql.define_column(p_cur_get_PLL, 15, P_PLL_Rec.ATTRIBUTE3, 150);
772: dbms_sql.define_column(p_cur_get_PLL, 16, P_PLL_Rec.ATTRIBUTE4, 150);
773: dbms_sql.define_column(p_cur_get_PLL, 17, P_PLL_Rec.ATTRIBUTE5, 150);
774: dbms_sql.define_column(p_cur_get_PLL, 18, P_PLL_Rec.ATTRIBUTE6, 150);
775: dbms_sql.define_column(p_cur_get_PLL, 19, P_PLL_Rec.ATTRIBUTE7, 150);
776: dbms_sql.define_column(p_cur_get_PLL, 20, P_PLL_Rec.ATTRIBUTE8, 150);

Line 773: dbms_sql.define_column(p_cur_get_PLL, 17, P_PLL_Rec.ATTRIBUTE5, 150);

769: dbms_sql.define_column(p_cur_get_PLL, 13, P_PLL_Rec.ATTRIBUTE1, 150);
770: dbms_sql.define_column(p_cur_get_PLL, 14, P_PLL_Rec.ATTRIBUTE2, 150);
771: dbms_sql.define_column(p_cur_get_PLL, 15, P_PLL_Rec.ATTRIBUTE3, 150);
772: dbms_sql.define_column(p_cur_get_PLL, 16, P_PLL_Rec.ATTRIBUTE4, 150);
773: dbms_sql.define_column(p_cur_get_PLL, 17, P_PLL_Rec.ATTRIBUTE5, 150);
774: dbms_sql.define_column(p_cur_get_PLL, 18, P_PLL_Rec.ATTRIBUTE6, 150);
775: dbms_sql.define_column(p_cur_get_PLL, 19, P_PLL_Rec.ATTRIBUTE7, 150);
776: dbms_sql.define_column(p_cur_get_PLL, 20, P_PLL_Rec.ATTRIBUTE8, 150);
777: dbms_sql.define_column(p_cur_get_PLL, 21, P_PLL_Rec.ATTRIBUTE9, 150);

Line 774: dbms_sql.define_column(p_cur_get_PLL, 18, P_PLL_Rec.ATTRIBUTE6, 150);

770: dbms_sql.define_column(p_cur_get_PLL, 14, P_PLL_Rec.ATTRIBUTE2, 150);
771: dbms_sql.define_column(p_cur_get_PLL, 15, P_PLL_Rec.ATTRIBUTE3, 150);
772: dbms_sql.define_column(p_cur_get_PLL, 16, P_PLL_Rec.ATTRIBUTE4, 150);
773: dbms_sql.define_column(p_cur_get_PLL, 17, P_PLL_Rec.ATTRIBUTE5, 150);
774: dbms_sql.define_column(p_cur_get_PLL, 18, P_PLL_Rec.ATTRIBUTE6, 150);
775: dbms_sql.define_column(p_cur_get_PLL, 19, P_PLL_Rec.ATTRIBUTE7, 150);
776: dbms_sql.define_column(p_cur_get_PLL, 20, P_PLL_Rec.ATTRIBUTE8, 150);
777: dbms_sql.define_column(p_cur_get_PLL, 21, P_PLL_Rec.ATTRIBUTE9, 150);
778: dbms_sql.define_column(p_cur_get_PLL, 22, P_PLL_Rec.ATTRIBUTE10, 150);

Line 775: dbms_sql.define_column(p_cur_get_PLL, 19, P_PLL_Rec.ATTRIBUTE7, 150);

771: dbms_sql.define_column(p_cur_get_PLL, 15, P_PLL_Rec.ATTRIBUTE3, 150);
772: dbms_sql.define_column(p_cur_get_PLL, 16, P_PLL_Rec.ATTRIBUTE4, 150);
773: dbms_sql.define_column(p_cur_get_PLL, 17, P_PLL_Rec.ATTRIBUTE5, 150);
774: dbms_sql.define_column(p_cur_get_PLL, 18, P_PLL_Rec.ATTRIBUTE6, 150);
775: dbms_sql.define_column(p_cur_get_PLL, 19, P_PLL_Rec.ATTRIBUTE7, 150);
776: dbms_sql.define_column(p_cur_get_PLL, 20, P_PLL_Rec.ATTRIBUTE8, 150);
777: dbms_sql.define_column(p_cur_get_PLL, 21, P_PLL_Rec.ATTRIBUTE9, 150);
778: dbms_sql.define_column(p_cur_get_PLL, 22, P_PLL_Rec.ATTRIBUTE10, 150);
779: dbms_sql.define_column(p_cur_get_PLL, 23, P_PLL_Rec.ATTRIBUTE11, 150);

Line 776: dbms_sql.define_column(p_cur_get_PLL, 20, P_PLL_Rec.ATTRIBUTE8, 150);

772: dbms_sql.define_column(p_cur_get_PLL, 16, P_PLL_Rec.ATTRIBUTE4, 150);
773: dbms_sql.define_column(p_cur_get_PLL, 17, P_PLL_Rec.ATTRIBUTE5, 150);
774: dbms_sql.define_column(p_cur_get_PLL, 18, P_PLL_Rec.ATTRIBUTE6, 150);
775: dbms_sql.define_column(p_cur_get_PLL, 19, P_PLL_Rec.ATTRIBUTE7, 150);
776: dbms_sql.define_column(p_cur_get_PLL, 20, P_PLL_Rec.ATTRIBUTE8, 150);
777: dbms_sql.define_column(p_cur_get_PLL, 21, P_PLL_Rec.ATTRIBUTE9, 150);
778: dbms_sql.define_column(p_cur_get_PLL, 22, P_PLL_Rec.ATTRIBUTE10, 150);
779: dbms_sql.define_column(p_cur_get_PLL, 23, P_PLL_Rec.ATTRIBUTE11, 150);
780: dbms_sql.define_column(p_cur_get_PLL, 24, P_PLL_Rec.ATTRIBUTE12, 150);

Line 777: dbms_sql.define_column(p_cur_get_PLL, 21, P_PLL_Rec.ATTRIBUTE9, 150);

773: dbms_sql.define_column(p_cur_get_PLL, 17, P_PLL_Rec.ATTRIBUTE5, 150);
774: dbms_sql.define_column(p_cur_get_PLL, 18, P_PLL_Rec.ATTRIBUTE6, 150);
775: dbms_sql.define_column(p_cur_get_PLL, 19, P_PLL_Rec.ATTRIBUTE7, 150);
776: dbms_sql.define_column(p_cur_get_PLL, 20, P_PLL_Rec.ATTRIBUTE8, 150);
777: dbms_sql.define_column(p_cur_get_PLL, 21, P_PLL_Rec.ATTRIBUTE9, 150);
778: dbms_sql.define_column(p_cur_get_PLL, 22, P_PLL_Rec.ATTRIBUTE10, 150);
779: dbms_sql.define_column(p_cur_get_PLL, 23, P_PLL_Rec.ATTRIBUTE11, 150);
780: dbms_sql.define_column(p_cur_get_PLL, 24, P_PLL_Rec.ATTRIBUTE12, 150);
781: dbms_sql.define_column(p_cur_get_PLL, 25, P_PLL_Rec.ATTRIBUTE13, 150);

Line 778: dbms_sql.define_column(p_cur_get_PLL, 22, P_PLL_Rec.ATTRIBUTE10, 150);

774: dbms_sql.define_column(p_cur_get_PLL, 18, P_PLL_Rec.ATTRIBUTE6, 150);
775: dbms_sql.define_column(p_cur_get_PLL, 19, P_PLL_Rec.ATTRIBUTE7, 150);
776: dbms_sql.define_column(p_cur_get_PLL, 20, P_PLL_Rec.ATTRIBUTE8, 150);
777: dbms_sql.define_column(p_cur_get_PLL, 21, P_PLL_Rec.ATTRIBUTE9, 150);
778: dbms_sql.define_column(p_cur_get_PLL, 22, P_PLL_Rec.ATTRIBUTE10, 150);
779: dbms_sql.define_column(p_cur_get_PLL, 23, P_PLL_Rec.ATTRIBUTE11, 150);
780: dbms_sql.define_column(p_cur_get_PLL, 24, P_PLL_Rec.ATTRIBUTE12, 150);
781: dbms_sql.define_column(p_cur_get_PLL, 25, P_PLL_Rec.ATTRIBUTE13, 150);
782: dbms_sql.define_column(p_cur_get_PLL, 26, P_PLL_Rec.ATTRIBUTE14, 150);

Line 779: dbms_sql.define_column(p_cur_get_PLL, 23, P_PLL_Rec.ATTRIBUTE11, 150);

775: dbms_sql.define_column(p_cur_get_PLL, 19, P_PLL_Rec.ATTRIBUTE7, 150);
776: dbms_sql.define_column(p_cur_get_PLL, 20, P_PLL_Rec.ATTRIBUTE8, 150);
777: dbms_sql.define_column(p_cur_get_PLL, 21, P_PLL_Rec.ATTRIBUTE9, 150);
778: dbms_sql.define_column(p_cur_get_PLL, 22, P_PLL_Rec.ATTRIBUTE10, 150);
779: dbms_sql.define_column(p_cur_get_PLL, 23, P_PLL_Rec.ATTRIBUTE11, 150);
780: dbms_sql.define_column(p_cur_get_PLL, 24, P_PLL_Rec.ATTRIBUTE12, 150);
781: dbms_sql.define_column(p_cur_get_PLL, 25, P_PLL_Rec.ATTRIBUTE13, 150);
782: dbms_sql.define_column(p_cur_get_PLL, 26, P_PLL_Rec.ATTRIBUTE14, 150);
783: dbms_sql.define_column(p_cur_get_PLL, 27, P_PLL_Rec.ATTRIBUTE15, 150);

Line 780: dbms_sql.define_column(p_cur_get_PLL, 24, P_PLL_Rec.ATTRIBUTE12, 150);

776: dbms_sql.define_column(p_cur_get_PLL, 20, P_PLL_Rec.ATTRIBUTE8, 150);
777: dbms_sql.define_column(p_cur_get_PLL, 21, P_PLL_Rec.ATTRIBUTE9, 150);
778: dbms_sql.define_column(p_cur_get_PLL, 22, P_PLL_Rec.ATTRIBUTE10, 150);
779: dbms_sql.define_column(p_cur_get_PLL, 23, P_PLL_Rec.ATTRIBUTE11, 150);
780: dbms_sql.define_column(p_cur_get_PLL, 24, P_PLL_Rec.ATTRIBUTE12, 150);
781: dbms_sql.define_column(p_cur_get_PLL, 25, P_PLL_Rec.ATTRIBUTE13, 150);
782: dbms_sql.define_column(p_cur_get_PLL, 26, P_PLL_Rec.ATTRIBUTE14, 150);
783: dbms_sql.define_column(p_cur_get_PLL, 27, P_PLL_Rec.ATTRIBUTE15, 150);
784: dbms_sql.define_column(p_cur_get_PLL, 28, P_PLL_Rec.UOM_CODE, 3);

Line 781: dbms_sql.define_column(p_cur_get_PLL, 25, P_PLL_Rec.ATTRIBUTE13, 150);

777: dbms_sql.define_column(p_cur_get_PLL, 21, P_PLL_Rec.ATTRIBUTE9, 150);
778: dbms_sql.define_column(p_cur_get_PLL, 22, P_PLL_Rec.ATTRIBUTE10, 150);
779: dbms_sql.define_column(p_cur_get_PLL, 23, P_PLL_Rec.ATTRIBUTE11, 150);
780: dbms_sql.define_column(p_cur_get_PLL, 24, P_PLL_Rec.ATTRIBUTE12, 150);
781: dbms_sql.define_column(p_cur_get_PLL, 25, P_PLL_Rec.ATTRIBUTE13, 150);
782: dbms_sql.define_column(p_cur_get_PLL, 26, P_PLL_Rec.ATTRIBUTE14, 150);
783: dbms_sql.define_column(p_cur_get_PLL, 27, P_PLL_Rec.ATTRIBUTE15, 150);
784: dbms_sql.define_column(p_cur_get_PLL, 28, P_PLL_Rec.UOM_CODE, 3);
785: dbms_sql.define_column(p_cur_get_PLL, 29, P_PLL_Rec.LINE_ID);

Line 782: dbms_sql.define_column(p_cur_get_PLL, 26, P_PLL_Rec.ATTRIBUTE14, 150);

778: dbms_sql.define_column(p_cur_get_PLL, 22, P_PLL_Rec.ATTRIBUTE10, 150);
779: dbms_sql.define_column(p_cur_get_PLL, 23, P_PLL_Rec.ATTRIBUTE11, 150);
780: dbms_sql.define_column(p_cur_get_PLL, 24, P_PLL_Rec.ATTRIBUTE12, 150);
781: dbms_sql.define_column(p_cur_get_PLL, 25, P_PLL_Rec.ATTRIBUTE13, 150);
782: dbms_sql.define_column(p_cur_get_PLL, 26, P_PLL_Rec.ATTRIBUTE14, 150);
783: dbms_sql.define_column(p_cur_get_PLL, 27, P_PLL_Rec.ATTRIBUTE15, 150);
784: dbms_sql.define_column(p_cur_get_PLL, 28, P_PLL_Rec.UOM_CODE, 3);
785: dbms_sql.define_column(p_cur_get_PLL, 29, P_PLL_Rec.LINE_ID);
786:

Line 783: dbms_sql.define_column(p_cur_get_PLL, 27, P_PLL_Rec.ATTRIBUTE15, 150);

779: dbms_sql.define_column(p_cur_get_PLL, 23, P_PLL_Rec.ATTRIBUTE11, 150);
780: dbms_sql.define_column(p_cur_get_PLL, 24, P_PLL_Rec.ATTRIBUTE12, 150);
781: dbms_sql.define_column(p_cur_get_PLL, 25, P_PLL_Rec.ATTRIBUTE13, 150);
782: dbms_sql.define_column(p_cur_get_PLL, 26, P_PLL_Rec.ATTRIBUTE14, 150);
783: dbms_sql.define_column(p_cur_get_PLL, 27, P_PLL_Rec.ATTRIBUTE15, 150);
784: dbms_sql.define_column(p_cur_get_PLL, 28, P_PLL_Rec.UOM_CODE, 3);
785: dbms_sql.define_column(p_cur_get_PLL, 29, P_PLL_Rec.LINE_ID);
786:
787: -- Debug Message

Line 784: dbms_sql.define_column(p_cur_get_PLL, 28, P_PLL_Rec.UOM_CODE, 3);

780: dbms_sql.define_column(p_cur_get_PLL, 24, P_PLL_Rec.ATTRIBUTE12, 150);
781: dbms_sql.define_column(p_cur_get_PLL, 25, P_PLL_Rec.ATTRIBUTE13, 150);
782: dbms_sql.define_column(p_cur_get_PLL, 26, P_PLL_Rec.ATTRIBUTE14, 150);
783: dbms_sql.define_column(p_cur_get_PLL, 27, P_PLL_Rec.ATTRIBUTE15, 150);
784: dbms_sql.define_column(p_cur_get_PLL, 28, P_PLL_Rec.UOM_CODE, 3);
785: dbms_sql.define_column(p_cur_get_PLL, 29, P_PLL_Rec.LINE_ID);
786:
787: -- Debug Message
788: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Ends');

Line 785: dbms_sql.define_column(p_cur_get_PLL, 29, P_PLL_Rec.LINE_ID);

781: dbms_sql.define_column(p_cur_get_PLL, 25, P_PLL_Rec.ATTRIBUTE13, 150);
782: dbms_sql.define_column(p_cur_get_PLL, 26, P_PLL_Rec.ATTRIBUTE14, 150);
783: dbms_sql.define_column(p_cur_get_PLL, 27, P_PLL_Rec.ATTRIBUTE15, 150);
784: dbms_sql.define_column(p_cur_get_PLL, 28, P_PLL_Rec.UOM_CODE, 3);
785: dbms_sql.define_column(p_cur_get_PLL, 29, P_PLL_Rec.LINE_ID);
786:
787: -- Debug Message
788: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Ends');
789: END Define_Columns;

Line 802: dbms_sql.column_value(p_cur_get_PLL, 1, X_PLL_Rec.PACKLIST_LINE_ID);

798: -- Debug Message
799: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Begins');
800:
801: -- get all column values for CSP_PACKLIST_LINES_V table
802: dbms_sql.column_value(p_cur_get_PLL, 1, X_PLL_Rec.PACKLIST_LINE_ID);
803: dbms_sql.column_value(p_cur_get_PLL, 2, X_PLL_Rec.ORGANIZATION_ID);
804: dbms_sql.column_value(p_cur_get_PLL, 3, X_PLL_Rec.PACKLIST_LINE_NUMBER);
805: dbms_sql.column_value(p_cur_get_PLL, 4, X_PLL_Rec.PACKLIST_HEADER_ID);
806: dbms_sql.column_value(p_cur_get_PLL, 5, X_PLL_Rec.BOX_ID);

Line 803: dbms_sql.column_value(p_cur_get_PLL, 2, X_PLL_Rec.ORGANIZATION_ID);

799: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Begins');
800:
801: -- get all column values for CSP_PACKLIST_LINES_V table
802: dbms_sql.column_value(p_cur_get_PLL, 1, X_PLL_Rec.PACKLIST_LINE_ID);
803: dbms_sql.column_value(p_cur_get_PLL, 2, X_PLL_Rec.ORGANIZATION_ID);
804: dbms_sql.column_value(p_cur_get_PLL, 3, X_PLL_Rec.PACKLIST_LINE_NUMBER);
805: dbms_sql.column_value(p_cur_get_PLL, 4, X_PLL_Rec.PACKLIST_HEADER_ID);
806: dbms_sql.column_value(p_cur_get_PLL, 5, X_PLL_Rec.BOX_ID);
807: dbms_sql.column_value(p_cur_get_PLL, 6, X_PLL_Rec.PICKLIST_LINE_ID);

Line 804: dbms_sql.column_value(p_cur_get_PLL, 3, X_PLL_Rec.PACKLIST_LINE_NUMBER);

800:
801: -- get all column values for CSP_PACKLIST_LINES_V table
802: dbms_sql.column_value(p_cur_get_PLL, 1, X_PLL_Rec.PACKLIST_LINE_ID);
803: dbms_sql.column_value(p_cur_get_PLL, 2, X_PLL_Rec.ORGANIZATION_ID);
804: dbms_sql.column_value(p_cur_get_PLL, 3, X_PLL_Rec.PACKLIST_LINE_NUMBER);
805: dbms_sql.column_value(p_cur_get_PLL, 4, X_PLL_Rec.PACKLIST_HEADER_ID);
806: dbms_sql.column_value(p_cur_get_PLL, 5, X_PLL_Rec.BOX_ID);
807: dbms_sql.column_value(p_cur_get_PLL, 6, X_PLL_Rec.PICKLIST_LINE_ID);
808: dbms_sql.column_value(p_cur_get_PLL, 7, X_PLL_Rec.PACKLIST_LINE_STATUS);

Line 805: dbms_sql.column_value(p_cur_get_PLL, 4, X_PLL_Rec.PACKLIST_HEADER_ID);

801: -- get all column values for CSP_PACKLIST_LINES_V table
802: dbms_sql.column_value(p_cur_get_PLL, 1, X_PLL_Rec.PACKLIST_LINE_ID);
803: dbms_sql.column_value(p_cur_get_PLL, 2, X_PLL_Rec.ORGANIZATION_ID);
804: dbms_sql.column_value(p_cur_get_PLL, 3, X_PLL_Rec.PACKLIST_LINE_NUMBER);
805: dbms_sql.column_value(p_cur_get_PLL, 4, X_PLL_Rec.PACKLIST_HEADER_ID);
806: dbms_sql.column_value(p_cur_get_PLL, 5, X_PLL_Rec.BOX_ID);
807: dbms_sql.column_value(p_cur_get_PLL, 6, X_PLL_Rec.PICKLIST_LINE_ID);
808: dbms_sql.column_value(p_cur_get_PLL, 7, X_PLL_Rec.PACKLIST_LINE_STATUS);
809: dbms_sql.column_value(p_cur_get_PLL, 8, X_PLL_Rec.INVENTORY_ITEM_ID);

Line 806: dbms_sql.column_value(p_cur_get_PLL, 5, X_PLL_Rec.BOX_ID);

802: dbms_sql.column_value(p_cur_get_PLL, 1, X_PLL_Rec.PACKLIST_LINE_ID);
803: dbms_sql.column_value(p_cur_get_PLL, 2, X_PLL_Rec.ORGANIZATION_ID);
804: dbms_sql.column_value(p_cur_get_PLL, 3, X_PLL_Rec.PACKLIST_LINE_NUMBER);
805: dbms_sql.column_value(p_cur_get_PLL, 4, X_PLL_Rec.PACKLIST_HEADER_ID);
806: dbms_sql.column_value(p_cur_get_PLL, 5, X_PLL_Rec.BOX_ID);
807: dbms_sql.column_value(p_cur_get_PLL, 6, X_PLL_Rec.PICKLIST_LINE_ID);
808: dbms_sql.column_value(p_cur_get_PLL, 7, X_PLL_Rec.PACKLIST_LINE_STATUS);
809: dbms_sql.column_value(p_cur_get_PLL, 8, X_PLL_Rec.INVENTORY_ITEM_ID);
810: dbms_sql.column_value(p_cur_get_PLL, 9, X_PLL_Rec.QUANTITY_PACKED);

Line 807: dbms_sql.column_value(p_cur_get_PLL, 6, X_PLL_Rec.PICKLIST_LINE_ID);

803: dbms_sql.column_value(p_cur_get_PLL, 2, X_PLL_Rec.ORGANIZATION_ID);
804: dbms_sql.column_value(p_cur_get_PLL, 3, X_PLL_Rec.PACKLIST_LINE_NUMBER);
805: dbms_sql.column_value(p_cur_get_PLL, 4, X_PLL_Rec.PACKLIST_HEADER_ID);
806: dbms_sql.column_value(p_cur_get_PLL, 5, X_PLL_Rec.BOX_ID);
807: dbms_sql.column_value(p_cur_get_PLL, 6, X_PLL_Rec.PICKLIST_LINE_ID);
808: dbms_sql.column_value(p_cur_get_PLL, 7, X_PLL_Rec.PACKLIST_LINE_STATUS);
809: dbms_sql.column_value(p_cur_get_PLL, 8, X_PLL_Rec.INVENTORY_ITEM_ID);
810: dbms_sql.column_value(p_cur_get_PLL, 9, X_PLL_Rec.QUANTITY_PACKED);
811: dbms_sql.column_value(p_cur_get_PLL, 10, X_PLL_Rec.QUANTITY_SHIPPED);

Line 808: dbms_sql.column_value(p_cur_get_PLL, 7, X_PLL_Rec.PACKLIST_LINE_STATUS);

804: dbms_sql.column_value(p_cur_get_PLL, 3, X_PLL_Rec.PACKLIST_LINE_NUMBER);
805: dbms_sql.column_value(p_cur_get_PLL, 4, X_PLL_Rec.PACKLIST_HEADER_ID);
806: dbms_sql.column_value(p_cur_get_PLL, 5, X_PLL_Rec.BOX_ID);
807: dbms_sql.column_value(p_cur_get_PLL, 6, X_PLL_Rec.PICKLIST_LINE_ID);
808: dbms_sql.column_value(p_cur_get_PLL, 7, X_PLL_Rec.PACKLIST_LINE_STATUS);
809: dbms_sql.column_value(p_cur_get_PLL, 8, X_PLL_Rec.INVENTORY_ITEM_ID);
810: dbms_sql.column_value(p_cur_get_PLL, 9, X_PLL_Rec.QUANTITY_PACKED);
811: dbms_sql.column_value(p_cur_get_PLL, 10, X_PLL_Rec.QUANTITY_SHIPPED);
812: dbms_sql.column_value(p_cur_get_PLL, 11, X_PLL_Rec.QUANTITY_RECEIVED);

Line 809: dbms_sql.column_value(p_cur_get_PLL, 8, X_PLL_Rec.INVENTORY_ITEM_ID);

805: dbms_sql.column_value(p_cur_get_PLL, 4, X_PLL_Rec.PACKLIST_HEADER_ID);
806: dbms_sql.column_value(p_cur_get_PLL, 5, X_PLL_Rec.BOX_ID);
807: dbms_sql.column_value(p_cur_get_PLL, 6, X_PLL_Rec.PICKLIST_LINE_ID);
808: dbms_sql.column_value(p_cur_get_PLL, 7, X_PLL_Rec.PACKLIST_LINE_STATUS);
809: dbms_sql.column_value(p_cur_get_PLL, 8, X_PLL_Rec.INVENTORY_ITEM_ID);
810: dbms_sql.column_value(p_cur_get_PLL, 9, X_PLL_Rec.QUANTITY_PACKED);
811: dbms_sql.column_value(p_cur_get_PLL, 10, X_PLL_Rec.QUANTITY_SHIPPED);
812: dbms_sql.column_value(p_cur_get_PLL, 11, X_PLL_Rec.QUANTITY_RECEIVED);
813: dbms_sql.column_value(p_cur_get_PLL, 12, X_PLL_Rec.ATTRIBUTE_CATEGORY);

Line 810: dbms_sql.column_value(p_cur_get_PLL, 9, X_PLL_Rec.QUANTITY_PACKED);

806: dbms_sql.column_value(p_cur_get_PLL, 5, X_PLL_Rec.BOX_ID);
807: dbms_sql.column_value(p_cur_get_PLL, 6, X_PLL_Rec.PICKLIST_LINE_ID);
808: dbms_sql.column_value(p_cur_get_PLL, 7, X_PLL_Rec.PACKLIST_LINE_STATUS);
809: dbms_sql.column_value(p_cur_get_PLL, 8, X_PLL_Rec.INVENTORY_ITEM_ID);
810: dbms_sql.column_value(p_cur_get_PLL, 9, X_PLL_Rec.QUANTITY_PACKED);
811: dbms_sql.column_value(p_cur_get_PLL, 10, X_PLL_Rec.QUANTITY_SHIPPED);
812: dbms_sql.column_value(p_cur_get_PLL, 11, X_PLL_Rec.QUANTITY_RECEIVED);
813: dbms_sql.column_value(p_cur_get_PLL, 12, X_PLL_Rec.ATTRIBUTE_CATEGORY);
814: dbms_sql.column_value(p_cur_get_PLL, 13, X_PLL_Rec.ATTRIBUTE1);

Line 811: dbms_sql.column_value(p_cur_get_PLL, 10, X_PLL_Rec.QUANTITY_SHIPPED);

807: dbms_sql.column_value(p_cur_get_PLL, 6, X_PLL_Rec.PICKLIST_LINE_ID);
808: dbms_sql.column_value(p_cur_get_PLL, 7, X_PLL_Rec.PACKLIST_LINE_STATUS);
809: dbms_sql.column_value(p_cur_get_PLL, 8, X_PLL_Rec.INVENTORY_ITEM_ID);
810: dbms_sql.column_value(p_cur_get_PLL, 9, X_PLL_Rec.QUANTITY_PACKED);
811: dbms_sql.column_value(p_cur_get_PLL, 10, X_PLL_Rec.QUANTITY_SHIPPED);
812: dbms_sql.column_value(p_cur_get_PLL, 11, X_PLL_Rec.QUANTITY_RECEIVED);
813: dbms_sql.column_value(p_cur_get_PLL, 12, X_PLL_Rec.ATTRIBUTE_CATEGORY);
814: dbms_sql.column_value(p_cur_get_PLL, 13, X_PLL_Rec.ATTRIBUTE1);
815: dbms_sql.column_value(p_cur_get_PLL, 14, X_PLL_Rec.ATTRIBUTE2);

Line 812: dbms_sql.column_value(p_cur_get_PLL, 11, X_PLL_Rec.QUANTITY_RECEIVED);

808: dbms_sql.column_value(p_cur_get_PLL, 7, X_PLL_Rec.PACKLIST_LINE_STATUS);
809: dbms_sql.column_value(p_cur_get_PLL, 8, X_PLL_Rec.INVENTORY_ITEM_ID);
810: dbms_sql.column_value(p_cur_get_PLL, 9, X_PLL_Rec.QUANTITY_PACKED);
811: dbms_sql.column_value(p_cur_get_PLL, 10, X_PLL_Rec.QUANTITY_SHIPPED);
812: dbms_sql.column_value(p_cur_get_PLL, 11, X_PLL_Rec.QUANTITY_RECEIVED);
813: dbms_sql.column_value(p_cur_get_PLL, 12, X_PLL_Rec.ATTRIBUTE_CATEGORY);
814: dbms_sql.column_value(p_cur_get_PLL, 13, X_PLL_Rec.ATTRIBUTE1);
815: dbms_sql.column_value(p_cur_get_PLL, 14, X_PLL_Rec.ATTRIBUTE2);
816: dbms_sql.column_value(p_cur_get_PLL, 15, X_PLL_Rec.ATTRIBUTE3);

Line 813: dbms_sql.column_value(p_cur_get_PLL, 12, X_PLL_Rec.ATTRIBUTE_CATEGORY);

809: dbms_sql.column_value(p_cur_get_PLL, 8, X_PLL_Rec.INVENTORY_ITEM_ID);
810: dbms_sql.column_value(p_cur_get_PLL, 9, X_PLL_Rec.QUANTITY_PACKED);
811: dbms_sql.column_value(p_cur_get_PLL, 10, X_PLL_Rec.QUANTITY_SHIPPED);
812: dbms_sql.column_value(p_cur_get_PLL, 11, X_PLL_Rec.QUANTITY_RECEIVED);
813: dbms_sql.column_value(p_cur_get_PLL, 12, X_PLL_Rec.ATTRIBUTE_CATEGORY);
814: dbms_sql.column_value(p_cur_get_PLL, 13, X_PLL_Rec.ATTRIBUTE1);
815: dbms_sql.column_value(p_cur_get_PLL, 14, X_PLL_Rec.ATTRIBUTE2);
816: dbms_sql.column_value(p_cur_get_PLL, 15, X_PLL_Rec.ATTRIBUTE3);
817: dbms_sql.column_value(p_cur_get_PLL, 16, X_PLL_Rec.ATTRIBUTE4);

Line 814: dbms_sql.column_value(p_cur_get_PLL, 13, X_PLL_Rec.ATTRIBUTE1);

810: dbms_sql.column_value(p_cur_get_PLL, 9, X_PLL_Rec.QUANTITY_PACKED);
811: dbms_sql.column_value(p_cur_get_PLL, 10, X_PLL_Rec.QUANTITY_SHIPPED);
812: dbms_sql.column_value(p_cur_get_PLL, 11, X_PLL_Rec.QUANTITY_RECEIVED);
813: dbms_sql.column_value(p_cur_get_PLL, 12, X_PLL_Rec.ATTRIBUTE_CATEGORY);
814: dbms_sql.column_value(p_cur_get_PLL, 13, X_PLL_Rec.ATTRIBUTE1);
815: dbms_sql.column_value(p_cur_get_PLL, 14, X_PLL_Rec.ATTRIBUTE2);
816: dbms_sql.column_value(p_cur_get_PLL, 15, X_PLL_Rec.ATTRIBUTE3);
817: dbms_sql.column_value(p_cur_get_PLL, 16, X_PLL_Rec.ATTRIBUTE4);
818: dbms_sql.column_value(p_cur_get_PLL, 17, X_PLL_Rec.ATTRIBUTE5);

Line 815: dbms_sql.column_value(p_cur_get_PLL, 14, X_PLL_Rec.ATTRIBUTE2);

811: dbms_sql.column_value(p_cur_get_PLL, 10, X_PLL_Rec.QUANTITY_SHIPPED);
812: dbms_sql.column_value(p_cur_get_PLL, 11, X_PLL_Rec.QUANTITY_RECEIVED);
813: dbms_sql.column_value(p_cur_get_PLL, 12, X_PLL_Rec.ATTRIBUTE_CATEGORY);
814: dbms_sql.column_value(p_cur_get_PLL, 13, X_PLL_Rec.ATTRIBUTE1);
815: dbms_sql.column_value(p_cur_get_PLL, 14, X_PLL_Rec.ATTRIBUTE2);
816: dbms_sql.column_value(p_cur_get_PLL, 15, X_PLL_Rec.ATTRIBUTE3);
817: dbms_sql.column_value(p_cur_get_PLL, 16, X_PLL_Rec.ATTRIBUTE4);
818: dbms_sql.column_value(p_cur_get_PLL, 17, X_PLL_Rec.ATTRIBUTE5);
819: dbms_sql.column_value(p_cur_get_PLL, 18, X_PLL_Rec.ATTRIBUTE6);

Line 816: dbms_sql.column_value(p_cur_get_PLL, 15, X_PLL_Rec.ATTRIBUTE3);

812: dbms_sql.column_value(p_cur_get_PLL, 11, X_PLL_Rec.QUANTITY_RECEIVED);
813: dbms_sql.column_value(p_cur_get_PLL, 12, X_PLL_Rec.ATTRIBUTE_CATEGORY);
814: dbms_sql.column_value(p_cur_get_PLL, 13, X_PLL_Rec.ATTRIBUTE1);
815: dbms_sql.column_value(p_cur_get_PLL, 14, X_PLL_Rec.ATTRIBUTE2);
816: dbms_sql.column_value(p_cur_get_PLL, 15, X_PLL_Rec.ATTRIBUTE3);
817: dbms_sql.column_value(p_cur_get_PLL, 16, X_PLL_Rec.ATTRIBUTE4);
818: dbms_sql.column_value(p_cur_get_PLL, 17, X_PLL_Rec.ATTRIBUTE5);
819: dbms_sql.column_value(p_cur_get_PLL, 18, X_PLL_Rec.ATTRIBUTE6);
820: dbms_sql.column_value(p_cur_get_PLL, 19, X_PLL_Rec.ATTRIBUTE7);

Line 817: dbms_sql.column_value(p_cur_get_PLL, 16, X_PLL_Rec.ATTRIBUTE4);

813: dbms_sql.column_value(p_cur_get_PLL, 12, X_PLL_Rec.ATTRIBUTE_CATEGORY);
814: dbms_sql.column_value(p_cur_get_PLL, 13, X_PLL_Rec.ATTRIBUTE1);
815: dbms_sql.column_value(p_cur_get_PLL, 14, X_PLL_Rec.ATTRIBUTE2);
816: dbms_sql.column_value(p_cur_get_PLL, 15, X_PLL_Rec.ATTRIBUTE3);
817: dbms_sql.column_value(p_cur_get_PLL, 16, X_PLL_Rec.ATTRIBUTE4);
818: dbms_sql.column_value(p_cur_get_PLL, 17, X_PLL_Rec.ATTRIBUTE5);
819: dbms_sql.column_value(p_cur_get_PLL, 18, X_PLL_Rec.ATTRIBUTE6);
820: dbms_sql.column_value(p_cur_get_PLL, 19, X_PLL_Rec.ATTRIBUTE7);
821: dbms_sql.column_value(p_cur_get_PLL, 20, X_PLL_Rec.ATTRIBUTE8);

Line 818: dbms_sql.column_value(p_cur_get_PLL, 17, X_PLL_Rec.ATTRIBUTE5);

814: dbms_sql.column_value(p_cur_get_PLL, 13, X_PLL_Rec.ATTRIBUTE1);
815: dbms_sql.column_value(p_cur_get_PLL, 14, X_PLL_Rec.ATTRIBUTE2);
816: dbms_sql.column_value(p_cur_get_PLL, 15, X_PLL_Rec.ATTRIBUTE3);
817: dbms_sql.column_value(p_cur_get_PLL, 16, X_PLL_Rec.ATTRIBUTE4);
818: dbms_sql.column_value(p_cur_get_PLL, 17, X_PLL_Rec.ATTRIBUTE5);
819: dbms_sql.column_value(p_cur_get_PLL, 18, X_PLL_Rec.ATTRIBUTE6);
820: dbms_sql.column_value(p_cur_get_PLL, 19, X_PLL_Rec.ATTRIBUTE7);
821: dbms_sql.column_value(p_cur_get_PLL, 20, X_PLL_Rec.ATTRIBUTE8);
822: dbms_sql.column_value(p_cur_get_PLL, 21, X_PLL_Rec.ATTRIBUTE9);

Line 819: dbms_sql.column_value(p_cur_get_PLL, 18, X_PLL_Rec.ATTRIBUTE6);

815: dbms_sql.column_value(p_cur_get_PLL, 14, X_PLL_Rec.ATTRIBUTE2);
816: dbms_sql.column_value(p_cur_get_PLL, 15, X_PLL_Rec.ATTRIBUTE3);
817: dbms_sql.column_value(p_cur_get_PLL, 16, X_PLL_Rec.ATTRIBUTE4);
818: dbms_sql.column_value(p_cur_get_PLL, 17, X_PLL_Rec.ATTRIBUTE5);
819: dbms_sql.column_value(p_cur_get_PLL, 18, X_PLL_Rec.ATTRIBUTE6);
820: dbms_sql.column_value(p_cur_get_PLL, 19, X_PLL_Rec.ATTRIBUTE7);
821: dbms_sql.column_value(p_cur_get_PLL, 20, X_PLL_Rec.ATTRIBUTE8);
822: dbms_sql.column_value(p_cur_get_PLL, 21, X_PLL_Rec.ATTRIBUTE9);
823: dbms_sql.column_value(p_cur_get_PLL, 22, X_PLL_Rec.ATTRIBUTE10);

Line 820: dbms_sql.column_value(p_cur_get_PLL, 19, X_PLL_Rec.ATTRIBUTE7);

816: dbms_sql.column_value(p_cur_get_PLL, 15, X_PLL_Rec.ATTRIBUTE3);
817: dbms_sql.column_value(p_cur_get_PLL, 16, X_PLL_Rec.ATTRIBUTE4);
818: dbms_sql.column_value(p_cur_get_PLL, 17, X_PLL_Rec.ATTRIBUTE5);
819: dbms_sql.column_value(p_cur_get_PLL, 18, X_PLL_Rec.ATTRIBUTE6);
820: dbms_sql.column_value(p_cur_get_PLL, 19, X_PLL_Rec.ATTRIBUTE7);
821: dbms_sql.column_value(p_cur_get_PLL, 20, X_PLL_Rec.ATTRIBUTE8);
822: dbms_sql.column_value(p_cur_get_PLL, 21, X_PLL_Rec.ATTRIBUTE9);
823: dbms_sql.column_value(p_cur_get_PLL, 22, X_PLL_Rec.ATTRIBUTE10);
824: dbms_sql.column_value(p_cur_get_PLL, 23, X_PLL_Rec.ATTRIBUTE11);

Line 821: dbms_sql.column_value(p_cur_get_PLL, 20, X_PLL_Rec.ATTRIBUTE8);

817: dbms_sql.column_value(p_cur_get_PLL, 16, X_PLL_Rec.ATTRIBUTE4);
818: dbms_sql.column_value(p_cur_get_PLL, 17, X_PLL_Rec.ATTRIBUTE5);
819: dbms_sql.column_value(p_cur_get_PLL, 18, X_PLL_Rec.ATTRIBUTE6);
820: dbms_sql.column_value(p_cur_get_PLL, 19, X_PLL_Rec.ATTRIBUTE7);
821: dbms_sql.column_value(p_cur_get_PLL, 20, X_PLL_Rec.ATTRIBUTE8);
822: dbms_sql.column_value(p_cur_get_PLL, 21, X_PLL_Rec.ATTRIBUTE9);
823: dbms_sql.column_value(p_cur_get_PLL, 22, X_PLL_Rec.ATTRIBUTE10);
824: dbms_sql.column_value(p_cur_get_PLL, 23, X_PLL_Rec.ATTRIBUTE11);
825: dbms_sql.column_value(p_cur_get_PLL, 24, X_PLL_Rec.ATTRIBUTE12);

Line 822: dbms_sql.column_value(p_cur_get_PLL, 21, X_PLL_Rec.ATTRIBUTE9);

818: dbms_sql.column_value(p_cur_get_PLL, 17, X_PLL_Rec.ATTRIBUTE5);
819: dbms_sql.column_value(p_cur_get_PLL, 18, X_PLL_Rec.ATTRIBUTE6);
820: dbms_sql.column_value(p_cur_get_PLL, 19, X_PLL_Rec.ATTRIBUTE7);
821: dbms_sql.column_value(p_cur_get_PLL, 20, X_PLL_Rec.ATTRIBUTE8);
822: dbms_sql.column_value(p_cur_get_PLL, 21, X_PLL_Rec.ATTRIBUTE9);
823: dbms_sql.column_value(p_cur_get_PLL, 22, X_PLL_Rec.ATTRIBUTE10);
824: dbms_sql.column_value(p_cur_get_PLL, 23, X_PLL_Rec.ATTRIBUTE11);
825: dbms_sql.column_value(p_cur_get_PLL, 24, X_PLL_Rec.ATTRIBUTE12);
826: dbms_sql.column_value(p_cur_get_PLL, 25, X_PLL_Rec.ATTRIBUTE13);

Line 823: dbms_sql.column_value(p_cur_get_PLL, 22, X_PLL_Rec.ATTRIBUTE10);

819: dbms_sql.column_value(p_cur_get_PLL, 18, X_PLL_Rec.ATTRIBUTE6);
820: dbms_sql.column_value(p_cur_get_PLL, 19, X_PLL_Rec.ATTRIBUTE7);
821: dbms_sql.column_value(p_cur_get_PLL, 20, X_PLL_Rec.ATTRIBUTE8);
822: dbms_sql.column_value(p_cur_get_PLL, 21, X_PLL_Rec.ATTRIBUTE9);
823: dbms_sql.column_value(p_cur_get_PLL, 22, X_PLL_Rec.ATTRIBUTE10);
824: dbms_sql.column_value(p_cur_get_PLL, 23, X_PLL_Rec.ATTRIBUTE11);
825: dbms_sql.column_value(p_cur_get_PLL, 24, X_PLL_Rec.ATTRIBUTE12);
826: dbms_sql.column_value(p_cur_get_PLL, 25, X_PLL_Rec.ATTRIBUTE13);
827: dbms_sql.column_value(p_cur_get_PLL, 26, X_PLL_Rec.ATTRIBUTE14);

Line 824: dbms_sql.column_value(p_cur_get_PLL, 23, X_PLL_Rec.ATTRIBUTE11);

820: dbms_sql.column_value(p_cur_get_PLL, 19, X_PLL_Rec.ATTRIBUTE7);
821: dbms_sql.column_value(p_cur_get_PLL, 20, X_PLL_Rec.ATTRIBUTE8);
822: dbms_sql.column_value(p_cur_get_PLL, 21, X_PLL_Rec.ATTRIBUTE9);
823: dbms_sql.column_value(p_cur_get_PLL, 22, X_PLL_Rec.ATTRIBUTE10);
824: dbms_sql.column_value(p_cur_get_PLL, 23, X_PLL_Rec.ATTRIBUTE11);
825: dbms_sql.column_value(p_cur_get_PLL, 24, X_PLL_Rec.ATTRIBUTE12);
826: dbms_sql.column_value(p_cur_get_PLL, 25, X_PLL_Rec.ATTRIBUTE13);
827: dbms_sql.column_value(p_cur_get_PLL, 26, X_PLL_Rec.ATTRIBUTE14);
828: dbms_sql.column_value(p_cur_get_PLL, 27, X_PLL_Rec.ATTRIBUTE15);

Line 825: dbms_sql.column_value(p_cur_get_PLL, 24, X_PLL_Rec.ATTRIBUTE12);

821: dbms_sql.column_value(p_cur_get_PLL, 20, X_PLL_Rec.ATTRIBUTE8);
822: dbms_sql.column_value(p_cur_get_PLL, 21, X_PLL_Rec.ATTRIBUTE9);
823: dbms_sql.column_value(p_cur_get_PLL, 22, X_PLL_Rec.ATTRIBUTE10);
824: dbms_sql.column_value(p_cur_get_PLL, 23, X_PLL_Rec.ATTRIBUTE11);
825: dbms_sql.column_value(p_cur_get_PLL, 24, X_PLL_Rec.ATTRIBUTE12);
826: dbms_sql.column_value(p_cur_get_PLL, 25, X_PLL_Rec.ATTRIBUTE13);
827: dbms_sql.column_value(p_cur_get_PLL, 26, X_PLL_Rec.ATTRIBUTE14);
828: dbms_sql.column_value(p_cur_get_PLL, 27, X_PLL_Rec.ATTRIBUTE15);
829: dbms_sql.column_value(p_cur_get_PLL, 28, X_PLL_Rec.UOM_CODE);

Line 826: dbms_sql.column_value(p_cur_get_PLL, 25, X_PLL_Rec.ATTRIBUTE13);

822: dbms_sql.column_value(p_cur_get_PLL, 21, X_PLL_Rec.ATTRIBUTE9);
823: dbms_sql.column_value(p_cur_get_PLL, 22, X_PLL_Rec.ATTRIBUTE10);
824: dbms_sql.column_value(p_cur_get_PLL, 23, X_PLL_Rec.ATTRIBUTE11);
825: dbms_sql.column_value(p_cur_get_PLL, 24, X_PLL_Rec.ATTRIBUTE12);
826: dbms_sql.column_value(p_cur_get_PLL, 25, X_PLL_Rec.ATTRIBUTE13);
827: dbms_sql.column_value(p_cur_get_PLL, 26, X_PLL_Rec.ATTRIBUTE14);
828: dbms_sql.column_value(p_cur_get_PLL, 27, X_PLL_Rec.ATTRIBUTE15);
829: dbms_sql.column_value(p_cur_get_PLL, 28, X_PLL_Rec.UOM_CODE);
830: dbms_sql.column_value(p_cur_get_PLL, 29, X_PLL_Rec.LINE_ID);

Line 827: dbms_sql.column_value(p_cur_get_PLL, 26, X_PLL_Rec.ATTRIBUTE14);

823: dbms_sql.column_value(p_cur_get_PLL, 22, X_PLL_Rec.ATTRIBUTE10);
824: dbms_sql.column_value(p_cur_get_PLL, 23, X_PLL_Rec.ATTRIBUTE11);
825: dbms_sql.column_value(p_cur_get_PLL, 24, X_PLL_Rec.ATTRIBUTE12);
826: dbms_sql.column_value(p_cur_get_PLL, 25, X_PLL_Rec.ATTRIBUTE13);
827: dbms_sql.column_value(p_cur_get_PLL, 26, X_PLL_Rec.ATTRIBUTE14);
828: dbms_sql.column_value(p_cur_get_PLL, 27, X_PLL_Rec.ATTRIBUTE15);
829: dbms_sql.column_value(p_cur_get_PLL, 28, X_PLL_Rec.UOM_CODE);
830: dbms_sql.column_value(p_cur_get_PLL, 29, X_PLL_Rec.LINE_ID);
831:

Line 828: dbms_sql.column_value(p_cur_get_PLL, 27, X_PLL_Rec.ATTRIBUTE15);

824: dbms_sql.column_value(p_cur_get_PLL, 23, X_PLL_Rec.ATTRIBUTE11);
825: dbms_sql.column_value(p_cur_get_PLL, 24, X_PLL_Rec.ATTRIBUTE12);
826: dbms_sql.column_value(p_cur_get_PLL, 25, X_PLL_Rec.ATTRIBUTE13);
827: dbms_sql.column_value(p_cur_get_PLL, 26, X_PLL_Rec.ATTRIBUTE14);
828: dbms_sql.column_value(p_cur_get_PLL, 27, X_PLL_Rec.ATTRIBUTE15);
829: dbms_sql.column_value(p_cur_get_PLL, 28, X_PLL_Rec.UOM_CODE);
830: dbms_sql.column_value(p_cur_get_PLL, 29, X_PLL_Rec.LINE_ID);
831:
832: -- Debug Message

Line 829: dbms_sql.column_value(p_cur_get_PLL, 28, X_PLL_Rec.UOM_CODE);

825: dbms_sql.column_value(p_cur_get_PLL, 24, X_PLL_Rec.ATTRIBUTE12);
826: dbms_sql.column_value(p_cur_get_PLL, 25, X_PLL_Rec.ATTRIBUTE13);
827: dbms_sql.column_value(p_cur_get_PLL, 26, X_PLL_Rec.ATTRIBUTE14);
828: dbms_sql.column_value(p_cur_get_PLL, 27, X_PLL_Rec.ATTRIBUTE15);
829: dbms_sql.column_value(p_cur_get_PLL, 28, X_PLL_Rec.UOM_CODE);
830: dbms_sql.column_value(p_cur_get_PLL, 29, X_PLL_Rec.LINE_ID);
831:
832: -- Debug Message
833: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Ends');

Line 830: dbms_sql.column_value(p_cur_get_PLL, 29, X_PLL_Rec.LINE_ID);

826: dbms_sql.column_value(p_cur_get_PLL, 25, X_PLL_Rec.ATTRIBUTE13);
827: dbms_sql.column_value(p_cur_get_PLL, 26, X_PLL_Rec.ATTRIBUTE14);
828: dbms_sql.column_value(p_cur_get_PLL, 27, X_PLL_Rec.ATTRIBUTE15);
829: dbms_sql.column_value(p_cur_get_PLL, 28, X_PLL_Rec.UOM_CODE);
830: dbms_sql.column_value(p_cur_get_PLL, 29, X_PLL_Rec.LINE_ID);
831:
832: -- Debug Message
833: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Ends');
834: END Get_Column_Values;

Line 895: DBMS_SQL.BIND_VARIABLE(p_cur_get_PLL, ':p_PACKLIST_LINE_ID', P_PLL_Rec.PACKLIST_LINE_ID);

891: -- The following example applies to all columns,
892: -- developers can copy and paste them.
893: IF( (P_PLL_Rec.PACKLIST_LINE_ID IS NOT NULL) AND (P_PLL_Rec.PACKLIST_LINE_ID <> FND_API.G_MISS_NUM) )
894: THEN
895: DBMS_SQL.BIND_VARIABLE(p_cur_get_PLL, ':p_PACKLIST_LINE_ID', P_PLL_Rec.PACKLIST_LINE_ID);
896: END IF;
897:
898: -- Debug Message
899: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Bind Variables Ends');