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_HEADERS_PVT dependencies on DBMS_SQL

Line 763: dbms_sql.define_column(p_cur_get_PLH, 1, P_PLH_Rec.PACKLIST_HEADER_ID);

759: -- Debug Message
760: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Begins');
761:
762: -- define all columns for CSP_PACKLIST_HEADERS_V view
763: dbms_sql.define_column(p_cur_get_PLH, 1, P_PLH_Rec.PACKLIST_HEADER_ID);
764: dbms_sql.define_column(p_cur_get_PLH, 2, P_PLH_Rec.ORGANIZATION_ID);
765: dbms_sql.define_column(p_cur_get_PLH, 3, P_PLH_Rec.PACKLIST_NUMBER, 10);
766: dbms_sql.define_column(p_cur_get_PLH, 4, P_PLH_Rec.SUBINVENTORY_CODE, 10);
767: dbms_sql.define_column(p_cur_get_PLH, 5, P_PLH_Rec.PACKLIST_STATUS, 30);

Line 764: dbms_sql.define_column(p_cur_get_PLH, 2, P_PLH_Rec.ORGANIZATION_ID);

760: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Begins');
761:
762: -- define all columns for CSP_PACKLIST_HEADERS_V view
763: dbms_sql.define_column(p_cur_get_PLH, 1, P_PLH_Rec.PACKLIST_HEADER_ID);
764: dbms_sql.define_column(p_cur_get_PLH, 2, P_PLH_Rec.ORGANIZATION_ID);
765: dbms_sql.define_column(p_cur_get_PLH, 3, P_PLH_Rec.PACKLIST_NUMBER, 10);
766: dbms_sql.define_column(p_cur_get_PLH, 4, P_PLH_Rec.SUBINVENTORY_CODE, 10);
767: dbms_sql.define_column(p_cur_get_PLH, 5, P_PLH_Rec.PACKLIST_STATUS, 30);
768: dbms_sql.define_column(p_cur_get_PLH, 6, P_PLH_Rec.DATE_CREATED);

Line 765: dbms_sql.define_column(p_cur_get_PLH, 3, P_PLH_Rec.PACKLIST_NUMBER, 10);

761:
762: -- define all columns for CSP_PACKLIST_HEADERS_V view
763: dbms_sql.define_column(p_cur_get_PLH, 1, P_PLH_Rec.PACKLIST_HEADER_ID);
764: dbms_sql.define_column(p_cur_get_PLH, 2, P_PLH_Rec.ORGANIZATION_ID);
765: dbms_sql.define_column(p_cur_get_PLH, 3, P_PLH_Rec.PACKLIST_NUMBER, 10);
766: dbms_sql.define_column(p_cur_get_PLH, 4, P_PLH_Rec.SUBINVENTORY_CODE, 10);
767: dbms_sql.define_column(p_cur_get_PLH, 5, P_PLH_Rec.PACKLIST_STATUS, 30);
768: dbms_sql.define_column(p_cur_get_PLH, 6, P_PLH_Rec.DATE_CREATED);
769: dbms_sql.define_column(p_cur_get_PLH, 7, P_PLH_Rec.DATE_PACKED);

Line 766: dbms_sql.define_column(p_cur_get_PLH, 4, P_PLH_Rec.SUBINVENTORY_CODE, 10);

762: -- define all columns for CSP_PACKLIST_HEADERS_V view
763: dbms_sql.define_column(p_cur_get_PLH, 1, P_PLH_Rec.PACKLIST_HEADER_ID);
764: dbms_sql.define_column(p_cur_get_PLH, 2, P_PLH_Rec.ORGANIZATION_ID);
765: dbms_sql.define_column(p_cur_get_PLH, 3, P_PLH_Rec.PACKLIST_NUMBER, 10);
766: dbms_sql.define_column(p_cur_get_PLH, 4, P_PLH_Rec.SUBINVENTORY_CODE, 10);
767: dbms_sql.define_column(p_cur_get_PLH, 5, P_PLH_Rec.PACKLIST_STATUS, 30);
768: dbms_sql.define_column(p_cur_get_PLH, 6, P_PLH_Rec.DATE_CREATED);
769: dbms_sql.define_column(p_cur_get_PLH, 7, P_PLH_Rec.DATE_PACKED);
770: dbms_sql.define_column(p_cur_get_PLH, 8, P_PLH_Rec.DATE_SHIPPED);

Line 767: dbms_sql.define_column(p_cur_get_PLH, 5, P_PLH_Rec.PACKLIST_STATUS, 30);

763: dbms_sql.define_column(p_cur_get_PLH, 1, P_PLH_Rec.PACKLIST_HEADER_ID);
764: dbms_sql.define_column(p_cur_get_PLH, 2, P_PLH_Rec.ORGANIZATION_ID);
765: dbms_sql.define_column(p_cur_get_PLH, 3, P_PLH_Rec.PACKLIST_NUMBER, 10);
766: dbms_sql.define_column(p_cur_get_PLH, 4, P_PLH_Rec.SUBINVENTORY_CODE, 10);
767: dbms_sql.define_column(p_cur_get_PLH, 5, P_PLH_Rec.PACKLIST_STATUS, 30);
768: dbms_sql.define_column(p_cur_get_PLH, 6, P_PLH_Rec.DATE_CREATED);
769: dbms_sql.define_column(p_cur_get_PLH, 7, P_PLH_Rec.DATE_PACKED);
770: dbms_sql.define_column(p_cur_get_PLH, 8, P_PLH_Rec.DATE_SHIPPED);
771: dbms_sql.define_column(p_cur_get_PLH, 9, P_PLH_Rec.DATE_RECEIVED);

Line 768: dbms_sql.define_column(p_cur_get_PLH, 6, P_PLH_Rec.DATE_CREATED);

764: dbms_sql.define_column(p_cur_get_PLH, 2, P_PLH_Rec.ORGANIZATION_ID);
765: dbms_sql.define_column(p_cur_get_PLH, 3, P_PLH_Rec.PACKLIST_NUMBER, 10);
766: dbms_sql.define_column(p_cur_get_PLH, 4, P_PLH_Rec.SUBINVENTORY_CODE, 10);
767: dbms_sql.define_column(p_cur_get_PLH, 5, P_PLH_Rec.PACKLIST_STATUS, 30);
768: dbms_sql.define_column(p_cur_get_PLH, 6, P_PLH_Rec.DATE_CREATED);
769: dbms_sql.define_column(p_cur_get_PLH, 7, P_PLH_Rec.DATE_PACKED);
770: dbms_sql.define_column(p_cur_get_PLH, 8, P_PLH_Rec.DATE_SHIPPED);
771: dbms_sql.define_column(p_cur_get_PLH, 9, P_PLH_Rec.DATE_RECEIVED);
772: dbms_sql.define_column(p_cur_get_PLH, 10, P_PLH_Rec.CARRIER, 60);

Line 769: dbms_sql.define_column(p_cur_get_PLH, 7, P_PLH_Rec.DATE_PACKED);

765: dbms_sql.define_column(p_cur_get_PLH, 3, P_PLH_Rec.PACKLIST_NUMBER, 10);
766: dbms_sql.define_column(p_cur_get_PLH, 4, P_PLH_Rec.SUBINVENTORY_CODE, 10);
767: dbms_sql.define_column(p_cur_get_PLH, 5, P_PLH_Rec.PACKLIST_STATUS, 30);
768: dbms_sql.define_column(p_cur_get_PLH, 6, P_PLH_Rec.DATE_CREATED);
769: dbms_sql.define_column(p_cur_get_PLH, 7, P_PLH_Rec.DATE_PACKED);
770: dbms_sql.define_column(p_cur_get_PLH, 8, P_PLH_Rec.DATE_SHIPPED);
771: dbms_sql.define_column(p_cur_get_PLH, 9, P_PLH_Rec.DATE_RECEIVED);
772: dbms_sql.define_column(p_cur_get_PLH, 10, P_PLH_Rec.CARRIER, 60);
773: dbms_sql.define_column(p_cur_get_PLH, 11, P_PLH_Rec.SHIPMENT_METHOD, 60);

Line 770: dbms_sql.define_column(p_cur_get_PLH, 8, P_PLH_Rec.DATE_SHIPPED);

766: dbms_sql.define_column(p_cur_get_PLH, 4, P_PLH_Rec.SUBINVENTORY_CODE, 10);
767: dbms_sql.define_column(p_cur_get_PLH, 5, P_PLH_Rec.PACKLIST_STATUS, 30);
768: dbms_sql.define_column(p_cur_get_PLH, 6, P_PLH_Rec.DATE_CREATED);
769: dbms_sql.define_column(p_cur_get_PLH, 7, P_PLH_Rec.DATE_PACKED);
770: dbms_sql.define_column(p_cur_get_PLH, 8, P_PLH_Rec.DATE_SHIPPED);
771: dbms_sql.define_column(p_cur_get_PLH, 9, P_PLH_Rec.DATE_RECEIVED);
772: dbms_sql.define_column(p_cur_get_PLH, 10, P_PLH_Rec.CARRIER, 60);
773: dbms_sql.define_column(p_cur_get_PLH, 11, P_PLH_Rec.SHIPMENT_METHOD, 60);
774: dbms_sql.define_column(p_cur_get_PLH, 12, P_PLH_Rec.WAYBILL, 60);

Line 771: dbms_sql.define_column(p_cur_get_PLH, 9, P_PLH_Rec.DATE_RECEIVED);

767: dbms_sql.define_column(p_cur_get_PLH, 5, P_PLH_Rec.PACKLIST_STATUS, 30);
768: dbms_sql.define_column(p_cur_get_PLH, 6, P_PLH_Rec.DATE_CREATED);
769: dbms_sql.define_column(p_cur_get_PLH, 7, P_PLH_Rec.DATE_PACKED);
770: dbms_sql.define_column(p_cur_get_PLH, 8, P_PLH_Rec.DATE_SHIPPED);
771: dbms_sql.define_column(p_cur_get_PLH, 9, P_PLH_Rec.DATE_RECEIVED);
772: dbms_sql.define_column(p_cur_get_PLH, 10, P_PLH_Rec.CARRIER, 60);
773: dbms_sql.define_column(p_cur_get_PLH, 11, P_PLH_Rec.SHIPMENT_METHOD, 60);
774: dbms_sql.define_column(p_cur_get_PLH, 12, P_PLH_Rec.WAYBILL, 60);
775: dbms_sql.define_column(p_cur_get_PLH, 13, P_PLH_Rec.COMMENTS, 240);

Line 772: dbms_sql.define_column(p_cur_get_PLH, 10, P_PLH_Rec.CARRIER, 60);

768: dbms_sql.define_column(p_cur_get_PLH, 6, P_PLH_Rec.DATE_CREATED);
769: dbms_sql.define_column(p_cur_get_PLH, 7, P_PLH_Rec.DATE_PACKED);
770: dbms_sql.define_column(p_cur_get_PLH, 8, P_PLH_Rec.DATE_SHIPPED);
771: dbms_sql.define_column(p_cur_get_PLH, 9, P_PLH_Rec.DATE_RECEIVED);
772: dbms_sql.define_column(p_cur_get_PLH, 10, P_PLH_Rec.CARRIER, 60);
773: dbms_sql.define_column(p_cur_get_PLH, 11, P_PLH_Rec.SHIPMENT_METHOD, 60);
774: dbms_sql.define_column(p_cur_get_PLH, 12, P_PLH_Rec.WAYBILL, 60);
775: dbms_sql.define_column(p_cur_get_PLH, 13, P_PLH_Rec.COMMENTS, 240);
776: dbms_sql.define_column(p_cur_get_PLH, 15, P_PLH_Rec.LOCATION_ID);

Line 773: dbms_sql.define_column(p_cur_get_PLH, 11, P_PLH_Rec.SHIPMENT_METHOD, 60);

769: dbms_sql.define_column(p_cur_get_PLH, 7, P_PLH_Rec.DATE_PACKED);
770: dbms_sql.define_column(p_cur_get_PLH, 8, P_PLH_Rec.DATE_SHIPPED);
771: dbms_sql.define_column(p_cur_get_PLH, 9, P_PLH_Rec.DATE_RECEIVED);
772: dbms_sql.define_column(p_cur_get_PLH, 10, P_PLH_Rec.CARRIER, 60);
773: dbms_sql.define_column(p_cur_get_PLH, 11, P_PLH_Rec.SHIPMENT_METHOD, 60);
774: dbms_sql.define_column(p_cur_get_PLH, 12, P_PLH_Rec.WAYBILL, 60);
775: dbms_sql.define_column(p_cur_get_PLH, 13, P_PLH_Rec.COMMENTS, 240);
776: dbms_sql.define_column(p_cur_get_PLH, 15, P_PLH_Rec.LOCATION_ID);
777: dbms_sql.define_column(p_cur_get_PLH, 16, P_PLH_Rec.PARTY_SITE_ID);

Line 774: dbms_sql.define_column(p_cur_get_PLH, 12, P_PLH_Rec.WAYBILL, 60);

770: dbms_sql.define_column(p_cur_get_PLH, 8, P_PLH_Rec.DATE_SHIPPED);
771: dbms_sql.define_column(p_cur_get_PLH, 9, P_PLH_Rec.DATE_RECEIVED);
772: dbms_sql.define_column(p_cur_get_PLH, 10, P_PLH_Rec.CARRIER, 60);
773: dbms_sql.define_column(p_cur_get_PLH, 11, P_PLH_Rec.SHIPMENT_METHOD, 60);
774: dbms_sql.define_column(p_cur_get_PLH, 12, P_PLH_Rec.WAYBILL, 60);
775: dbms_sql.define_column(p_cur_get_PLH, 13, P_PLH_Rec.COMMENTS, 240);
776: dbms_sql.define_column(p_cur_get_PLH, 15, P_PLH_Rec.LOCATION_ID);
777: dbms_sql.define_column(p_cur_get_PLH, 16, P_PLH_Rec.PARTY_SITE_ID);
778: dbms_sql.define_column(p_cur_get_PLH, 23, P_PLH_Rec.ATTRIBUTE_CATEGORY, 30);

Line 775: dbms_sql.define_column(p_cur_get_PLH, 13, P_PLH_Rec.COMMENTS, 240);

771: dbms_sql.define_column(p_cur_get_PLH, 9, P_PLH_Rec.DATE_RECEIVED);
772: dbms_sql.define_column(p_cur_get_PLH, 10, P_PLH_Rec.CARRIER, 60);
773: dbms_sql.define_column(p_cur_get_PLH, 11, P_PLH_Rec.SHIPMENT_METHOD, 60);
774: dbms_sql.define_column(p_cur_get_PLH, 12, P_PLH_Rec.WAYBILL, 60);
775: dbms_sql.define_column(p_cur_get_PLH, 13, P_PLH_Rec.COMMENTS, 240);
776: dbms_sql.define_column(p_cur_get_PLH, 15, P_PLH_Rec.LOCATION_ID);
777: dbms_sql.define_column(p_cur_get_PLH, 16, P_PLH_Rec.PARTY_SITE_ID);
778: dbms_sql.define_column(p_cur_get_PLH, 23, P_PLH_Rec.ATTRIBUTE_CATEGORY, 30);
779: dbms_sql.define_column(p_cur_get_PLH, 24, P_PLH_Rec.ATTRIBUTE1, 150);

Line 776: dbms_sql.define_column(p_cur_get_PLH, 15, P_PLH_Rec.LOCATION_ID);

772: dbms_sql.define_column(p_cur_get_PLH, 10, P_PLH_Rec.CARRIER, 60);
773: dbms_sql.define_column(p_cur_get_PLH, 11, P_PLH_Rec.SHIPMENT_METHOD, 60);
774: dbms_sql.define_column(p_cur_get_PLH, 12, P_PLH_Rec.WAYBILL, 60);
775: dbms_sql.define_column(p_cur_get_PLH, 13, P_PLH_Rec.COMMENTS, 240);
776: dbms_sql.define_column(p_cur_get_PLH, 15, P_PLH_Rec.LOCATION_ID);
777: dbms_sql.define_column(p_cur_get_PLH, 16, P_PLH_Rec.PARTY_SITE_ID);
778: dbms_sql.define_column(p_cur_get_PLH, 23, P_PLH_Rec.ATTRIBUTE_CATEGORY, 30);
779: dbms_sql.define_column(p_cur_get_PLH, 24, P_PLH_Rec.ATTRIBUTE1, 150);
780: dbms_sql.define_column(p_cur_get_PLH, 25, P_PLH_Rec.ATTRIBUTE2, 150);

Line 777: dbms_sql.define_column(p_cur_get_PLH, 16, P_PLH_Rec.PARTY_SITE_ID);

773: dbms_sql.define_column(p_cur_get_PLH, 11, P_PLH_Rec.SHIPMENT_METHOD, 60);
774: dbms_sql.define_column(p_cur_get_PLH, 12, P_PLH_Rec.WAYBILL, 60);
775: dbms_sql.define_column(p_cur_get_PLH, 13, P_PLH_Rec.COMMENTS, 240);
776: dbms_sql.define_column(p_cur_get_PLH, 15, P_PLH_Rec.LOCATION_ID);
777: dbms_sql.define_column(p_cur_get_PLH, 16, P_PLH_Rec.PARTY_SITE_ID);
778: dbms_sql.define_column(p_cur_get_PLH, 23, P_PLH_Rec.ATTRIBUTE_CATEGORY, 30);
779: dbms_sql.define_column(p_cur_get_PLH, 24, P_PLH_Rec.ATTRIBUTE1, 150);
780: dbms_sql.define_column(p_cur_get_PLH, 25, P_PLH_Rec.ATTRIBUTE2, 150);
781: dbms_sql.define_column(p_cur_get_PLH, 26, P_PLH_Rec.ATTRIBUTE3, 150);

Line 778: dbms_sql.define_column(p_cur_get_PLH, 23, P_PLH_Rec.ATTRIBUTE_CATEGORY, 30);

774: dbms_sql.define_column(p_cur_get_PLH, 12, P_PLH_Rec.WAYBILL, 60);
775: dbms_sql.define_column(p_cur_get_PLH, 13, P_PLH_Rec.COMMENTS, 240);
776: dbms_sql.define_column(p_cur_get_PLH, 15, P_PLH_Rec.LOCATION_ID);
777: dbms_sql.define_column(p_cur_get_PLH, 16, P_PLH_Rec.PARTY_SITE_ID);
778: dbms_sql.define_column(p_cur_get_PLH, 23, P_PLH_Rec.ATTRIBUTE_CATEGORY, 30);
779: dbms_sql.define_column(p_cur_get_PLH, 24, P_PLH_Rec.ATTRIBUTE1, 150);
780: dbms_sql.define_column(p_cur_get_PLH, 25, P_PLH_Rec.ATTRIBUTE2, 150);
781: dbms_sql.define_column(p_cur_get_PLH, 26, P_PLH_Rec.ATTRIBUTE3, 150);
782: dbms_sql.define_column(p_cur_get_PLH, 27, P_PLH_Rec.ATTRIBUTE4, 150);

Line 779: dbms_sql.define_column(p_cur_get_PLH, 24, P_PLH_Rec.ATTRIBUTE1, 150);

775: dbms_sql.define_column(p_cur_get_PLH, 13, P_PLH_Rec.COMMENTS, 240);
776: dbms_sql.define_column(p_cur_get_PLH, 15, P_PLH_Rec.LOCATION_ID);
777: dbms_sql.define_column(p_cur_get_PLH, 16, P_PLH_Rec.PARTY_SITE_ID);
778: dbms_sql.define_column(p_cur_get_PLH, 23, P_PLH_Rec.ATTRIBUTE_CATEGORY, 30);
779: dbms_sql.define_column(p_cur_get_PLH, 24, P_PLH_Rec.ATTRIBUTE1, 150);
780: dbms_sql.define_column(p_cur_get_PLH, 25, P_PLH_Rec.ATTRIBUTE2, 150);
781: dbms_sql.define_column(p_cur_get_PLH, 26, P_PLH_Rec.ATTRIBUTE3, 150);
782: dbms_sql.define_column(p_cur_get_PLH, 27, P_PLH_Rec.ATTRIBUTE4, 150);
783: dbms_sql.define_column(p_cur_get_PLH, 28, P_PLH_Rec.ATTRIBUTE5, 150);

Line 780: dbms_sql.define_column(p_cur_get_PLH, 25, P_PLH_Rec.ATTRIBUTE2, 150);

776: dbms_sql.define_column(p_cur_get_PLH, 15, P_PLH_Rec.LOCATION_ID);
777: dbms_sql.define_column(p_cur_get_PLH, 16, P_PLH_Rec.PARTY_SITE_ID);
778: dbms_sql.define_column(p_cur_get_PLH, 23, P_PLH_Rec.ATTRIBUTE_CATEGORY, 30);
779: dbms_sql.define_column(p_cur_get_PLH, 24, P_PLH_Rec.ATTRIBUTE1, 150);
780: dbms_sql.define_column(p_cur_get_PLH, 25, P_PLH_Rec.ATTRIBUTE2, 150);
781: dbms_sql.define_column(p_cur_get_PLH, 26, P_PLH_Rec.ATTRIBUTE3, 150);
782: dbms_sql.define_column(p_cur_get_PLH, 27, P_PLH_Rec.ATTRIBUTE4, 150);
783: dbms_sql.define_column(p_cur_get_PLH, 28, P_PLH_Rec.ATTRIBUTE5, 150);
784: dbms_sql.define_column(p_cur_get_PLH, 29, P_PLH_Rec.ATTRIBUTE6, 150);

Line 781: dbms_sql.define_column(p_cur_get_PLH, 26, P_PLH_Rec.ATTRIBUTE3, 150);

777: dbms_sql.define_column(p_cur_get_PLH, 16, P_PLH_Rec.PARTY_SITE_ID);
778: dbms_sql.define_column(p_cur_get_PLH, 23, P_PLH_Rec.ATTRIBUTE_CATEGORY, 30);
779: dbms_sql.define_column(p_cur_get_PLH, 24, P_PLH_Rec.ATTRIBUTE1, 150);
780: dbms_sql.define_column(p_cur_get_PLH, 25, P_PLH_Rec.ATTRIBUTE2, 150);
781: dbms_sql.define_column(p_cur_get_PLH, 26, P_PLH_Rec.ATTRIBUTE3, 150);
782: dbms_sql.define_column(p_cur_get_PLH, 27, P_PLH_Rec.ATTRIBUTE4, 150);
783: dbms_sql.define_column(p_cur_get_PLH, 28, P_PLH_Rec.ATTRIBUTE5, 150);
784: dbms_sql.define_column(p_cur_get_PLH, 29, P_PLH_Rec.ATTRIBUTE6, 150);
785: dbms_sql.define_column(p_cur_get_PLH, 30, P_PLH_Rec.ATTRIBUTE7, 150);

Line 782: dbms_sql.define_column(p_cur_get_PLH, 27, P_PLH_Rec.ATTRIBUTE4, 150);

778: dbms_sql.define_column(p_cur_get_PLH, 23, P_PLH_Rec.ATTRIBUTE_CATEGORY, 30);
779: dbms_sql.define_column(p_cur_get_PLH, 24, P_PLH_Rec.ATTRIBUTE1, 150);
780: dbms_sql.define_column(p_cur_get_PLH, 25, P_PLH_Rec.ATTRIBUTE2, 150);
781: dbms_sql.define_column(p_cur_get_PLH, 26, P_PLH_Rec.ATTRIBUTE3, 150);
782: dbms_sql.define_column(p_cur_get_PLH, 27, P_PLH_Rec.ATTRIBUTE4, 150);
783: dbms_sql.define_column(p_cur_get_PLH, 28, P_PLH_Rec.ATTRIBUTE5, 150);
784: dbms_sql.define_column(p_cur_get_PLH, 29, P_PLH_Rec.ATTRIBUTE6, 150);
785: dbms_sql.define_column(p_cur_get_PLH, 30, P_PLH_Rec.ATTRIBUTE7, 150);
786: dbms_sql.define_column(p_cur_get_PLH, 31, P_PLH_Rec.ATTRIBUTE8, 150);

Line 783: dbms_sql.define_column(p_cur_get_PLH, 28, P_PLH_Rec.ATTRIBUTE5, 150);

779: dbms_sql.define_column(p_cur_get_PLH, 24, P_PLH_Rec.ATTRIBUTE1, 150);
780: dbms_sql.define_column(p_cur_get_PLH, 25, P_PLH_Rec.ATTRIBUTE2, 150);
781: dbms_sql.define_column(p_cur_get_PLH, 26, P_PLH_Rec.ATTRIBUTE3, 150);
782: dbms_sql.define_column(p_cur_get_PLH, 27, P_PLH_Rec.ATTRIBUTE4, 150);
783: dbms_sql.define_column(p_cur_get_PLH, 28, P_PLH_Rec.ATTRIBUTE5, 150);
784: dbms_sql.define_column(p_cur_get_PLH, 29, P_PLH_Rec.ATTRIBUTE6, 150);
785: dbms_sql.define_column(p_cur_get_PLH, 30, P_PLH_Rec.ATTRIBUTE7, 150);
786: dbms_sql.define_column(p_cur_get_PLH, 31, P_PLH_Rec.ATTRIBUTE8, 150);
787: dbms_sql.define_column(p_cur_get_PLH, 32, P_PLH_Rec.ATTRIBUTE9, 150);

Line 784: dbms_sql.define_column(p_cur_get_PLH, 29, P_PLH_Rec.ATTRIBUTE6, 150);

780: dbms_sql.define_column(p_cur_get_PLH, 25, P_PLH_Rec.ATTRIBUTE2, 150);
781: dbms_sql.define_column(p_cur_get_PLH, 26, P_PLH_Rec.ATTRIBUTE3, 150);
782: dbms_sql.define_column(p_cur_get_PLH, 27, P_PLH_Rec.ATTRIBUTE4, 150);
783: dbms_sql.define_column(p_cur_get_PLH, 28, P_PLH_Rec.ATTRIBUTE5, 150);
784: dbms_sql.define_column(p_cur_get_PLH, 29, P_PLH_Rec.ATTRIBUTE6, 150);
785: dbms_sql.define_column(p_cur_get_PLH, 30, P_PLH_Rec.ATTRIBUTE7, 150);
786: dbms_sql.define_column(p_cur_get_PLH, 31, P_PLH_Rec.ATTRIBUTE8, 150);
787: dbms_sql.define_column(p_cur_get_PLH, 32, P_PLH_Rec.ATTRIBUTE9, 150);
788: dbms_sql.define_column(p_cur_get_PLH, 33, P_PLH_Rec.ATTRIBUTE10, 150);

Line 785: dbms_sql.define_column(p_cur_get_PLH, 30, P_PLH_Rec.ATTRIBUTE7, 150);

781: dbms_sql.define_column(p_cur_get_PLH, 26, P_PLH_Rec.ATTRIBUTE3, 150);
782: dbms_sql.define_column(p_cur_get_PLH, 27, P_PLH_Rec.ATTRIBUTE4, 150);
783: dbms_sql.define_column(p_cur_get_PLH, 28, P_PLH_Rec.ATTRIBUTE5, 150);
784: dbms_sql.define_column(p_cur_get_PLH, 29, P_PLH_Rec.ATTRIBUTE6, 150);
785: dbms_sql.define_column(p_cur_get_PLH, 30, P_PLH_Rec.ATTRIBUTE7, 150);
786: dbms_sql.define_column(p_cur_get_PLH, 31, P_PLH_Rec.ATTRIBUTE8, 150);
787: dbms_sql.define_column(p_cur_get_PLH, 32, P_PLH_Rec.ATTRIBUTE9, 150);
788: dbms_sql.define_column(p_cur_get_PLH, 33, P_PLH_Rec.ATTRIBUTE10, 150);
789: dbms_sql.define_column(p_cur_get_PLH, 34, P_PLH_Rec.ATTRIBUTE11, 150);

Line 786: dbms_sql.define_column(p_cur_get_PLH, 31, P_PLH_Rec.ATTRIBUTE8, 150);

782: dbms_sql.define_column(p_cur_get_PLH, 27, P_PLH_Rec.ATTRIBUTE4, 150);
783: dbms_sql.define_column(p_cur_get_PLH, 28, P_PLH_Rec.ATTRIBUTE5, 150);
784: dbms_sql.define_column(p_cur_get_PLH, 29, P_PLH_Rec.ATTRIBUTE6, 150);
785: dbms_sql.define_column(p_cur_get_PLH, 30, P_PLH_Rec.ATTRIBUTE7, 150);
786: dbms_sql.define_column(p_cur_get_PLH, 31, P_PLH_Rec.ATTRIBUTE8, 150);
787: dbms_sql.define_column(p_cur_get_PLH, 32, P_PLH_Rec.ATTRIBUTE9, 150);
788: dbms_sql.define_column(p_cur_get_PLH, 33, P_PLH_Rec.ATTRIBUTE10, 150);
789: dbms_sql.define_column(p_cur_get_PLH, 34, P_PLH_Rec.ATTRIBUTE11, 150);
790: dbms_sql.define_column(p_cur_get_PLH, 35, P_PLH_Rec.ATTRIBUTE12, 150);

Line 787: dbms_sql.define_column(p_cur_get_PLH, 32, P_PLH_Rec.ATTRIBUTE9, 150);

783: dbms_sql.define_column(p_cur_get_PLH, 28, P_PLH_Rec.ATTRIBUTE5, 150);
784: dbms_sql.define_column(p_cur_get_PLH, 29, P_PLH_Rec.ATTRIBUTE6, 150);
785: dbms_sql.define_column(p_cur_get_PLH, 30, P_PLH_Rec.ATTRIBUTE7, 150);
786: dbms_sql.define_column(p_cur_get_PLH, 31, P_PLH_Rec.ATTRIBUTE8, 150);
787: dbms_sql.define_column(p_cur_get_PLH, 32, P_PLH_Rec.ATTRIBUTE9, 150);
788: dbms_sql.define_column(p_cur_get_PLH, 33, P_PLH_Rec.ATTRIBUTE10, 150);
789: dbms_sql.define_column(p_cur_get_PLH, 34, P_PLH_Rec.ATTRIBUTE11, 150);
790: dbms_sql.define_column(p_cur_get_PLH, 35, P_PLH_Rec.ATTRIBUTE12, 150);
791: dbms_sql.define_column(p_cur_get_PLH, 36, P_PLH_Rec.ATTRIBUTE13, 150);

Line 788: dbms_sql.define_column(p_cur_get_PLH, 33, P_PLH_Rec.ATTRIBUTE10, 150);

784: dbms_sql.define_column(p_cur_get_PLH, 29, P_PLH_Rec.ATTRIBUTE6, 150);
785: dbms_sql.define_column(p_cur_get_PLH, 30, P_PLH_Rec.ATTRIBUTE7, 150);
786: dbms_sql.define_column(p_cur_get_PLH, 31, P_PLH_Rec.ATTRIBUTE8, 150);
787: dbms_sql.define_column(p_cur_get_PLH, 32, P_PLH_Rec.ATTRIBUTE9, 150);
788: dbms_sql.define_column(p_cur_get_PLH, 33, P_PLH_Rec.ATTRIBUTE10, 150);
789: dbms_sql.define_column(p_cur_get_PLH, 34, P_PLH_Rec.ATTRIBUTE11, 150);
790: dbms_sql.define_column(p_cur_get_PLH, 35, P_PLH_Rec.ATTRIBUTE12, 150);
791: dbms_sql.define_column(p_cur_get_PLH, 36, P_PLH_Rec.ATTRIBUTE13, 150);
792: dbms_sql.define_column(p_cur_get_PLH, 37, P_PLH_Rec.ATTRIBUTE14, 150);

Line 789: dbms_sql.define_column(p_cur_get_PLH, 34, P_PLH_Rec.ATTRIBUTE11, 150);

785: dbms_sql.define_column(p_cur_get_PLH, 30, P_PLH_Rec.ATTRIBUTE7, 150);
786: dbms_sql.define_column(p_cur_get_PLH, 31, P_PLH_Rec.ATTRIBUTE8, 150);
787: dbms_sql.define_column(p_cur_get_PLH, 32, P_PLH_Rec.ATTRIBUTE9, 150);
788: dbms_sql.define_column(p_cur_get_PLH, 33, P_PLH_Rec.ATTRIBUTE10, 150);
789: dbms_sql.define_column(p_cur_get_PLH, 34, P_PLH_Rec.ATTRIBUTE11, 150);
790: dbms_sql.define_column(p_cur_get_PLH, 35, P_PLH_Rec.ATTRIBUTE12, 150);
791: dbms_sql.define_column(p_cur_get_PLH, 36, P_PLH_Rec.ATTRIBUTE13, 150);
792: dbms_sql.define_column(p_cur_get_PLH, 37, P_PLH_Rec.ATTRIBUTE14, 150);
793: dbms_sql.define_column(p_cur_get_PLH, 38, P_PLH_Rec.ATTRIBUTE15, 150);

Line 790: dbms_sql.define_column(p_cur_get_PLH, 35, P_PLH_Rec.ATTRIBUTE12, 150);

786: dbms_sql.define_column(p_cur_get_PLH, 31, P_PLH_Rec.ATTRIBUTE8, 150);
787: dbms_sql.define_column(p_cur_get_PLH, 32, P_PLH_Rec.ATTRIBUTE9, 150);
788: dbms_sql.define_column(p_cur_get_PLH, 33, P_PLH_Rec.ATTRIBUTE10, 150);
789: dbms_sql.define_column(p_cur_get_PLH, 34, P_PLH_Rec.ATTRIBUTE11, 150);
790: dbms_sql.define_column(p_cur_get_PLH, 35, P_PLH_Rec.ATTRIBUTE12, 150);
791: dbms_sql.define_column(p_cur_get_PLH, 36, P_PLH_Rec.ATTRIBUTE13, 150);
792: dbms_sql.define_column(p_cur_get_PLH, 37, P_PLH_Rec.ATTRIBUTE14, 150);
793: dbms_sql.define_column(p_cur_get_PLH, 38, P_PLH_Rec.ATTRIBUTE15, 150);
794:

Line 791: dbms_sql.define_column(p_cur_get_PLH, 36, P_PLH_Rec.ATTRIBUTE13, 150);

787: dbms_sql.define_column(p_cur_get_PLH, 32, P_PLH_Rec.ATTRIBUTE9, 150);
788: dbms_sql.define_column(p_cur_get_PLH, 33, P_PLH_Rec.ATTRIBUTE10, 150);
789: dbms_sql.define_column(p_cur_get_PLH, 34, P_PLH_Rec.ATTRIBUTE11, 150);
790: dbms_sql.define_column(p_cur_get_PLH, 35, P_PLH_Rec.ATTRIBUTE12, 150);
791: dbms_sql.define_column(p_cur_get_PLH, 36, P_PLH_Rec.ATTRIBUTE13, 150);
792: dbms_sql.define_column(p_cur_get_PLH, 37, P_PLH_Rec.ATTRIBUTE14, 150);
793: dbms_sql.define_column(p_cur_get_PLH, 38, P_PLH_Rec.ATTRIBUTE15, 150);
794:
795: -- Debug Message

Line 792: dbms_sql.define_column(p_cur_get_PLH, 37, P_PLH_Rec.ATTRIBUTE14, 150);

788: dbms_sql.define_column(p_cur_get_PLH, 33, P_PLH_Rec.ATTRIBUTE10, 150);
789: dbms_sql.define_column(p_cur_get_PLH, 34, P_PLH_Rec.ATTRIBUTE11, 150);
790: dbms_sql.define_column(p_cur_get_PLH, 35, P_PLH_Rec.ATTRIBUTE12, 150);
791: dbms_sql.define_column(p_cur_get_PLH, 36, P_PLH_Rec.ATTRIBUTE13, 150);
792: dbms_sql.define_column(p_cur_get_PLH, 37, P_PLH_Rec.ATTRIBUTE14, 150);
793: dbms_sql.define_column(p_cur_get_PLH, 38, P_PLH_Rec.ATTRIBUTE15, 150);
794:
795: -- Debug Message
796: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Ends');

Line 793: dbms_sql.define_column(p_cur_get_PLH, 38, P_PLH_Rec.ATTRIBUTE15, 150);

789: dbms_sql.define_column(p_cur_get_PLH, 34, P_PLH_Rec.ATTRIBUTE11, 150);
790: dbms_sql.define_column(p_cur_get_PLH, 35, P_PLH_Rec.ATTRIBUTE12, 150);
791: dbms_sql.define_column(p_cur_get_PLH, 36, P_PLH_Rec.ATTRIBUTE13, 150);
792: dbms_sql.define_column(p_cur_get_PLH, 37, P_PLH_Rec.ATTRIBUTE14, 150);
793: dbms_sql.define_column(p_cur_get_PLH, 38, P_PLH_Rec.ATTRIBUTE15, 150);
794:
795: -- Debug Message
796: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Ends');
797: END Define_Columns;

Line 810: dbms_sql.column_value(p_cur_get_PLH, 1, X_PLH_Rec.ROW_ID);

806: -- Debug Message
807: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Begins');
808:
809: -- get all column values for CSP_PACKLIST_HEADERS_V table
810: dbms_sql.column_value(p_cur_get_PLH, 1, X_PLH_Rec.ROW_ID);
811: dbms_sql.column_value(p_cur_get_PLH, 2, X_PLH_Rec.PACKLIST_HEADER_ID);
812: dbms_sql.column_value(p_cur_get_PLH, 3, X_PLH_Rec.ORGANIZATION_ID);
813: dbms_sql.column_value(p_cur_get_PLH, 4, X_PLH_Rec.PACKLIST_NUMBER);
814: dbms_sql.column_value(p_cur_get_PLH, 5, X_PLH_Rec.SUBINVENTORY_CODE);

Line 811: dbms_sql.column_value(p_cur_get_PLH, 2, X_PLH_Rec.PACKLIST_HEADER_ID);

807: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Begins');
808:
809: -- get all column values for CSP_PACKLIST_HEADERS_V table
810: dbms_sql.column_value(p_cur_get_PLH, 1, X_PLH_Rec.ROW_ID);
811: dbms_sql.column_value(p_cur_get_PLH, 2, X_PLH_Rec.PACKLIST_HEADER_ID);
812: dbms_sql.column_value(p_cur_get_PLH, 3, X_PLH_Rec.ORGANIZATION_ID);
813: dbms_sql.column_value(p_cur_get_PLH, 4, X_PLH_Rec.PACKLIST_NUMBER);
814: dbms_sql.column_value(p_cur_get_PLH, 5, X_PLH_Rec.SUBINVENTORY_CODE);
815: dbms_sql.column_value(p_cur_get_PLH, 6, X_PLH_Rec.PACKLIST_STATUS);

Line 812: dbms_sql.column_value(p_cur_get_PLH, 3, X_PLH_Rec.ORGANIZATION_ID);

808:
809: -- get all column values for CSP_PACKLIST_HEADERS_V table
810: dbms_sql.column_value(p_cur_get_PLH, 1, X_PLH_Rec.ROW_ID);
811: dbms_sql.column_value(p_cur_get_PLH, 2, X_PLH_Rec.PACKLIST_HEADER_ID);
812: dbms_sql.column_value(p_cur_get_PLH, 3, X_PLH_Rec.ORGANIZATION_ID);
813: dbms_sql.column_value(p_cur_get_PLH, 4, X_PLH_Rec.PACKLIST_NUMBER);
814: dbms_sql.column_value(p_cur_get_PLH, 5, X_PLH_Rec.SUBINVENTORY_CODE);
815: dbms_sql.column_value(p_cur_get_PLH, 6, X_PLH_Rec.PACKLIST_STATUS);
816: dbms_sql.column_value(p_cur_get_PLH, 7, X_PLH_Rec.DATE_CREATED);

Line 813: dbms_sql.column_value(p_cur_get_PLH, 4, X_PLH_Rec.PACKLIST_NUMBER);

809: -- get all column values for CSP_PACKLIST_HEADERS_V table
810: dbms_sql.column_value(p_cur_get_PLH, 1, X_PLH_Rec.ROW_ID);
811: dbms_sql.column_value(p_cur_get_PLH, 2, X_PLH_Rec.PACKLIST_HEADER_ID);
812: dbms_sql.column_value(p_cur_get_PLH, 3, X_PLH_Rec.ORGANIZATION_ID);
813: dbms_sql.column_value(p_cur_get_PLH, 4, X_PLH_Rec.PACKLIST_NUMBER);
814: dbms_sql.column_value(p_cur_get_PLH, 5, X_PLH_Rec.SUBINVENTORY_CODE);
815: dbms_sql.column_value(p_cur_get_PLH, 6, X_PLH_Rec.PACKLIST_STATUS);
816: dbms_sql.column_value(p_cur_get_PLH, 7, X_PLH_Rec.DATE_CREATED);
817: dbms_sql.column_value(p_cur_get_PLH, 8, X_PLH_Rec.DATE_PACKED);

Line 814: dbms_sql.column_value(p_cur_get_PLH, 5, X_PLH_Rec.SUBINVENTORY_CODE);

810: dbms_sql.column_value(p_cur_get_PLH, 1, X_PLH_Rec.ROW_ID);
811: dbms_sql.column_value(p_cur_get_PLH, 2, X_PLH_Rec.PACKLIST_HEADER_ID);
812: dbms_sql.column_value(p_cur_get_PLH, 3, X_PLH_Rec.ORGANIZATION_ID);
813: dbms_sql.column_value(p_cur_get_PLH, 4, X_PLH_Rec.PACKLIST_NUMBER);
814: dbms_sql.column_value(p_cur_get_PLH, 5, X_PLH_Rec.SUBINVENTORY_CODE);
815: dbms_sql.column_value(p_cur_get_PLH, 6, X_PLH_Rec.PACKLIST_STATUS);
816: dbms_sql.column_value(p_cur_get_PLH, 7, X_PLH_Rec.DATE_CREATED);
817: dbms_sql.column_value(p_cur_get_PLH, 8, X_PLH_Rec.DATE_PACKED);
818: dbms_sql.column_value(p_cur_get_PLH, 9, X_PLH_Rec.DATE_SHIPPED);

Line 815: dbms_sql.column_value(p_cur_get_PLH, 6, X_PLH_Rec.PACKLIST_STATUS);

811: dbms_sql.column_value(p_cur_get_PLH, 2, X_PLH_Rec.PACKLIST_HEADER_ID);
812: dbms_sql.column_value(p_cur_get_PLH, 3, X_PLH_Rec.ORGANIZATION_ID);
813: dbms_sql.column_value(p_cur_get_PLH, 4, X_PLH_Rec.PACKLIST_NUMBER);
814: dbms_sql.column_value(p_cur_get_PLH, 5, X_PLH_Rec.SUBINVENTORY_CODE);
815: dbms_sql.column_value(p_cur_get_PLH, 6, X_PLH_Rec.PACKLIST_STATUS);
816: dbms_sql.column_value(p_cur_get_PLH, 7, X_PLH_Rec.DATE_CREATED);
817: dbms_sql.column_value(p_cur_get_PLH, 8, X_PLH_Rec.DATE_PACKED);
818: dbms_sql.column_value(p_cur_get_PLH, 9, X_PLH_Rec.DATE_SHIPPED);
819: dbms_sql.column_value(p_cur_get_PLH, 10, X_PLH_Rec.DATE_RECEIVED);

Line 816: dbms_sql.column_value(p_cur_get_PLH, 7, X_PLH_Rec.DATE_CREATED);

812: dbms_sql.column_value(p_cur_get_PLH, 3, X_PLH_Rec.ORGANIZATION_ID);
813: dbms_sql.column_value(p_cur_get_PLH, 4, X_PLH_Rec.PACKLIST_NUMBER);
814: dbms_sql.column_value(p_cur_get_PLH, 5, X_PLH_Rec.SUBINVENTORY_CODE);
815: dbms_sql.column_value(p_cur_get_PLH, 6, X_PLH_Rec.PACKLIST_STATUS);
816: dbms_sql.column_value(p_cur_get_PLH, 7, X_PLH_Rec.DATE_CREATED);
817: dbms_sql.column_value(p_cur_get_PLH, 8, X_PLH_Rec.DATE_PACKED);
818: dbms_sql.column_value(p_cur_get_PLH, 9, X_PLH_Rec.DATE_SHIPPED);
819: dbms_sql.column_value(p_cur_get_PLH, 10, X_PLH_Rec.DATE_RECEIVED);
820: dbms_sql.column_value(p_cur_get_PLH, 11, X_PLH_Rec.CARRIER);

Line 817: dbms_sql.column_value(p_cur_get_PLH, 8, X_PLH_Rec.DATE_PACKED);

813: dbms_sql.column_value(p_cur_get_PLH, 4, X_PLH_Rec.PACKLIST_NUMBER);
814: dbms_sql.column_value(p_cur_get_PLH, 5, X_PLH_Rec.SUBINVENTORY_CODE);
815: dbms_sql.column_value(p_cur_get_PLH, 6, X_PLH_Rec.PACKLIST_STATUS);
816: dbms_sql.column_value(p_cur_get_PLH, 7, X_PLH_Rec.DATE_CREATED);
817: dbms_sql.column_value(p_cur_get_PLH, 8, X_PLH_Rec.DATE_PACKED);
818: dbms_sql.column_value(p_cur_get_PLH, 9, X_PLH_Rec.DATE_SHIPPED);
819: dbms_sql.column_value(p_cur_get_PLH, 10, X_PLH_Rec.DATE_RECEIVED);
820: dbms_sql.column_value(p_cur_get_PLH, 11, X_PLH_Rec.CARRIER);
821: dbms_sql.column_value(p_cur_get_PLH, 12, X_PLH_Rec.SHIPMENT_METHOD);

Line 818: dbms_sql.column_value(p_cur_get_PLH, 9, X_PLH_Rec.DATE_SHIPPED);

814: dbms_sql.column_value(p_cur_get_PLH, 5, X_PLH_Rec.SUBINVENTORY_CODE);
815: dbms_sql.column_value(p_cur_get_PLH, 6, X_PLH_Rec.PACKLIST_STATUS);
816: dbms_sql.column_value(p_cur_get_PLH, 7, X_PLH_Rec.DATE_CREATED);
817: dbms_sql.column_value(p_cur_get_PLH, 8, X_PLH_Rec.DATE_PACKED);
818: dbms_sql.column_value(p_cur_get_PLH, 9, X_PLH_Rec.DATE_SHIPPED);
819: dbms_sql.column_value(p_cur_get_PLH, 10, X_PLH_Rec.DATE_RECEIVED);
820: dbms_sql.column_value(p_cur_get_PLH, 11, X_PLH_Rec.CARRIER);
821: dbms_sql.column_value(p_cur_get_PLH, 12, X_PLH_Rec.SHIPMENT_METHOD);
822: dbms_sql.column_value(p_cur_get_PLH, 13, X_PLH_Rec.WAYBILL);

Line 819: dbms_sql.column_value(p_cur_get_PLH, 10, X_PLH_Rec.DATE_RECEIVED);

815: dbms_sql.column_value(p_cur_get_PLH, 6, X_PLH_Rec.PACKLIST_STATUS);
816: dbms_sql.column_value(p_cur_get_PLH, 7, X_PLH_Rec.DATE_CREATED);
817: dbms_sql.column_value(p_cur_get_PLH, 8, X_PLH_Rec.DATE_PACKED);
818: dbms_sql.column_value(p_cur_get_PLH, 9, X_PLH_Rec.DATE_SHIPPED);
819: dbms_sql.column_value(p_cur_get_PLH, 10, X_PLH_Rec.DATE_RECEIVED);
820: dbms_sql.column_value(p_cur_get_PLH, 11, X_PLH_Rec.CARRIER);
821: dbms_sql.column_value(p_cur_get_PLH, 12, X_PLH_Rec.SHIPMENT_METHOD);
822: dbms_sql.column_value(p_cur_get_PLH, 13, X_PLH_Rec.WAYBILL);
823: dbms_sql.column_value(p_cur_get_PLH, 14, X_PLH_Rec.COMMENTS);

Line 820: dbms_sql.column_value(p_cur_get_PLH, 11, X_PLH_Rec.CARRIER);

816: dbms_sql.column_value(p_cur_get_PLH, 7, X_PLH_Rec.DATE_CREATED);
817: dbms_sql.column_value(p_cur_get_PLH, 8, X_PLH_Rec.DATE_PACKED);
818: dbms_sql.column_value(p_cur_get_PLH, 9, X_PLH_Rec.DATE_SHIPPED);
819: dbms_sql.column_value(p_cur_get_PLH, 10, X_PLH_Rec.DATE_RECEIVED);
820: dbms_sql.column_value(p_cur_get_PLH, 11, X_PLH_Rec.CARRIER);
821: dbms_sql.column_value(p_cur_get_PLH, 12, X_PLH_Rec.SHIPMENT_METHOD);
822: dbms_sql.column_value(p_cur_get_PLH, 13, X_PLH_Rec.WAYBILL);
823: dbms_sql.column_value(p_cur_get_PLH, 14, X_PLH_Rec.COMMENTS);
824: dbms_sql.define_column(p_cur_get_PLH,15, x_PLH_Rec.LOCATION_ID);

Line 821: dbms_sql.column_value(p_cur_get_PLH, 12, X_PLH_Rec.SHIPMENT_METHOD);

817: dbms_sql.column_value(p_cur_get_PLH, 8, X_PLH_Rec.DATE_PACKED);
818: dbms_sql.column_value(p_cur_get_PLH, 9, X_PLH_Rec.DATE_SHIPPED);
819: dbms_sql.column_value(p_cur_get_PLH, 10, X_PLH_Rec.DATE_RECEIVED);
820: dbms_sql.column_value(p_cur_get_PLH, 11, X_PLH_Rec.CARRIER);
821: dbms_sql.column_value(p_cur_get_PLH, 12, X_PLH_Rec.SHIPMENT_METHOD);
822: dbms_sql.column_value(p_cur_get_PLH, 13, X_PLH_Rec.WAYBILL);
823: dbms_sql.column_value(p_cur_get_PLH, 14, X_PLH_Rec.COMMENTS);
824: dbms_sql.define_column(p_cur_get_PLH,15, x_PLH_Rec.LOCATION_ID);
825: dbms_sql.define_column(p_cur_get_PLH,16, x_PLH_Rec.PARTY_SITE_ID);

Line 822: dbms_sql.column_value(p_cur_get_PLH, 13, X_PLH_Rec.WAYBILL);

818: dbms_sql.column_value(p_cur_get_PLH, 9, X_PLH_Rec.DATE_SHIPPED);
819: dbms_sql.column_value(p_cur_get_PLH, 10, X_PLH_Rec.DATE_RECEIVED);
820: dbms_sql.column_value(p_cur_get_PLH, 11, X_PLH_Rec.CARRIER);
821: dbms_sql.column_value(p_cur_get_PLH, 12, X_PLH_Rec.SHIPMENT_METHOD);
822: dbms_sql.column_value(p_cur_get_PLH, 13, X_PLH_Rec.WAYBILL);
823: dbms_sql.column_value(p_cur_get_PLH, 14, X_PLH_Rec.COMMENTS);
824: dbms_sql.define_column(p_cur_get_PLH,15, x_PLH_Rec.LOCATION_ID);
825: dbms_sql.define_column(p_cur_get_PLH,16, x_PLH_Rec.PARTY_SITE_ID);
826: dbms_sql.column_value(p_cur_get_PLH, 24, X_PLH_Rec.ATTRIBUTE_CATEGORY);

Line 823: dbms_sql.column_value(p_cur_get_PLH, 14, X_PLH_Rec.COMMENTS);

819: dbms_sql.column_value(p_cur_get_PLH, 10, X_PLH_Rec.DATE_RECEIVED);
820: dbms_sql.column_value(p_cur_get_PLH, 11, X_PLH_Rec.CARRIER);
821: dbms_sql.column_value(p_cur_get_PLH, 12, X_PLH_Rec.SHIPMENT_METHOD);
822: dbms_sql.column_value(p_cur_get_PLH, 13, X_PLH_Rec.WAYBILL);
823: dbms_sql.column_value(p_cur_get_PLH, 14, X_PLH_Rec.COMMENTS);
824: dbms_sql.define_column(p_cur_get_PLH,15, x_PLH_Rec.LOCATION_ID);
825: dbms_sql.define_column(p_cur_get_PLH,16, x_PLH_Rec.PARTY_SITE_ID);
826: dbms_sql.column_value(p_cur_get_PLH, 24, X_PLH_Rec.ATTRIBUTE_CATEGORY);
827: dbms_sql.column_value(p_cur_get_PLH, 25, X_PLH_Rec.ATTRIBUTE1);

Line 824: dbms_sql.define_column(p_cur_get_PLH,15, x_PLH_Rec.LOCATION_ID);

820: dbms_sql.column_value(p_cur_get_PLH, 11, X_PLH_Rec.CARRIER);
821: dbms_sql.column_value(p_cur_get_PLH, 12, X_PLH_Rec.SHIPMENT_METHOD);
822: dbms_sql.column_value(p_cur_get_PLH, 13, X_PLH_Rec.WAYBILL);
823: dbms_sql.column_value(p_cur_get_PLH, 14, X_PLH_Rec.COMMENTS);
824: dbms_sql.define_column(p_cur_get_PLH,15, x_PLH_Rec.LOCATION_ID);
825: dbms_sql.define_column(p_cur_get_PLH,16, x_PLH_Rec.PARTY_SITE_ID);
826: dbms_sql.column_value(p_cur_get_PLH, 24, X_PLH_Rec.ATTRIBUTE_CATEGORY);
827: dbms_sql.column_value(p_cur_get_PLH, 25, X_PLH_Rec.ATTRIBUTE1);
828: dbms_sql.column_value(p_cur_get_PLH, 26, X_PLH_Rec.ATTRIBUTE2);

Line 825: dbms_sql.define_column(p_cur_get_PLH,16, x_PLH_Rec.PARTY_SITE_ID);

821: dbms_sql.column_value(p_cur_get_PLH, 12, X_PLH_Rec.SHIPMENT_METHOD);
822: dbms_sql.column_value(p_cur_get_PLH, 13, X_PLH_Rec.WAYBILL);
823: dbms_sql.column_value(p_cur_get_PLH, 14, X_PLH_Rec.COMMENTS);
824: dbms_sql.define_column(p_cur_get_PLH,15, x_PLH_Rec.LOCATION_ID);
825: dbms_sql.define_column(p_cur_get_PLH,16, x_PLH_Rec.PARTY_SITE_ID);
826: dbms_sql.column_value(p_cur_get_PLH, 24, X_PLH_Rec.ATTRIBUTE_CATEGORY);
827: dbms_sql.column_value(p_cur_get_PLH, 25, X_PLH_Rec.ATTRIBUTE1);
828: dbms_sql.column_value(p_cur_get_PLH, 26, X_PLH_Rec.ATTRIBUTE2);
829: dbms_sql.column_value(p_cur_get_PLH, 27, X_PLH_Rec.ATTRIBUTE3);

Line 826: dbms_sql.column_value(p_cur_get_PLH, 24, X_PLH_Rec.ATTRIBUTE_CATEGORY);

822: dbms_sql.column_value(p_cur_get_PLH, 13, X_PLH_Rec.WAYBILL);
823: dbms_sql.column_value(p_cur_get_PLH, 14, X_PLH_Rec.COMMENTS);
824: dbms_sql.define_column(p_cur_get_PLH,15, x_PLH_Rec.LOCATION_ID);
825: dbms_sql.define_column(p_cur_get_PLH,16, x_PLH_Rec.PARTY_SITE_ID);
826: dbms_sql.column_value(p_cur_get_PLH, 24, X_PLH_Rec.ATTRIBUTE_CATEGORY);
827: dbms_sql.column_value(p_cur_get_PLH, 25, X_PLH_Rec.ATTRIBUTE1);
828: dbms_sql.column_value(p_cur_get_PLH, 26, X_PLH_Rec.ATTRIBUTE2);
829: dbms_sql.column_value(p_cur_get_PLH, 27, X_PLH_Rec.ATTRIBUTE3);
830: dbms_sql.column_value(p_cur_get_PLH, 28, X_PLH_Rec.ATTRIBUTE4);

Line 827: dbms_sql.column_value(p_cur_get_PLH, 25, X_PLH_Rec.ATTRIBUTE1);

823: dbms_sql.column_value(p_cur_get_PLH, 14, X_PLH_Rec.COMMENTS);
824: dbms_sql.define_column(p_cur_get_PLH,15, x_PLH_Rec.LOCATION_ID);
825: dbms_sql.define_column(p_cur_get_PLH,16, x_PLH_Rec.PARTY_SITE_ID);
826: dbms_sql.column_value(p_cur_get_PLH, 24, X_PLH_Rec.ATTRIBUTE_CATEGORY);
827: dbms_sql.column_value(p_cur_get_PLH, 25, X_PLH_Rec.ATTRIBUTE1);
828: dbms_sql.column_value(p_cur_get_PLH, 26, X_PLH_Rec.ATTRIBUTE2);
829: dbms_sql.column_value(p_cur_get_PLH, 27, X_PLH_Rec.ATTRIBUTE3);
830: dbms_sql.column_value(p_cur_get_PLH, 28, X_PLH_Rec.ATTRIBUTE4);
831: dbms_sql.column_value(p_cur_get_PLH, 29, X_PLH_Rec.ATTRIBUTE5);

Line 828: dbms_sql.column_value(p_cur_get_PLH, 26, X_PLH_Rec.ATTRIBUTE2);

824: dbms_sql.define_column(p_cur_get_PLH,15, x_PLH_Rec.LOCATION_ID);
825: dbms_sql.define_column(p_cur_get_PLH,16, x_PLH_Rec.PARTY_SITE_ID);
826: dbms_sql.column_value(p_cur_get_PLH, 24, X_PLH_Rec.ATTRIBUTE_CATEGORY);
827: dbms_sql.column_value(p_cur_get_PLH, 25, X_PLH_Rec.ATTRIBUTE1);
828: dbms_sql.column_value(p_cur_get_PLH, 26, X_PLH_Rec.ATTRIBUTE2);
829: dbms_sql.column_value(p_cur_get_PLH, 27, X_PLH_Rec.ATTRIBUTE3);
830: dbms_sql.column_value(p_cur_get_PLH, 28, X_PLH_Rec.ATTRIBUTE4);
831: dbms_sql.column_value(p_cur_get_PLH, 29, X_PLH_Rec.ATTRIBUTE5);
832: dbms_sql.column_value(p_cur_get_PLH, 30, X_PLH_Rec.ATTRIBUTE6);

Line 829: dbms_sql.column_value(p_cur_get_PLH, 27, X_PLH_Rec.ATTRIBUTE3);

825: dbms_sql.define_column(p_cur_get_PLH,16, x_PLH_Rec.PARTY_SITE_ID);
826: dbms_sql.column_value(p_cur_get_PLH, 24, X_PLH_Rec.ATTRIBUTE_CATEGORY);
827: dbms_sql.column_value(p_cur_get_PLH, 25, X_PLH_Rec.ATTRIBUTE1);
828: dbms_sql.column_value(p_cur_get_PLH, 26, X_PLH_Rec.ATTRIBUTE2);
829: dbms_sql.column_value(p_cur_get_PLH, 27, X_PLH_Rec.ATTRIBUTE3);
830: dbms_sql.column_value(p_cur_get_PLH, 28, X_PLH_Rec.ATTRIBUTE4);
831: dbms_sql.column_value(p_cur_get_PLH, 29, X_PLH_Rec.ATTRIBUTE5);
832: dbms_sql.column_value(p_cur_get_PLH, 30, X_PLH_Rec.ATTRIBUTE6);
833: dbms_sql.column_value(p_cur_get_PLH, 31, X_PLH_Rec.ATTRIBUTE7);

Line 830: dbms_sql.column_value(p_cur_get_PLH, 28, X_PLH_Rec.ATTRIBUTE4);

826: dbms_sql.column_value(p_cur_get_PLH, 24, X_PLH_Rec.ATTRIBUTE_CATEGORY);
827: dbms_sql.column_value(p_cur_get_PLH, 25, X_PLH_Rec.ATTRIBUTE1);
828: dbms_sql.column_value(p_cur_get_PLH, 26, X_PLH_Rec.ATTRIBUTE2);
829: dbms_sql.column_value(p_cur_get_PLH, 27, X_PLH_Rec.ATTRIBUTE3);
830: dbms_sql.column_value(p_cur_get_PLH, 28, X_PLH_Rec.ATTRIBUTE4);
831: dbms_sql.column_value(p_cur_get_PLH, 29, X_PLH_Rec.ATTRIBUTE5);
832: dbms_sql.column_value(p_cur_get_PLH, 30, X_PLH_Rec.ATTRIBUTE6);
833: dbms_sql.column_value(p_cur_get_PLH, 31, X_PLH_Rec.ATTRIBUTE7);
834: dbms_sql.column_value(p_cur_get_PLH, 32, X_PLH_Rec.ATTRIBUTE8);

Line 831: dbms_sql.column_value(p_cur_get_PLH, 29, X_PLH_Rec.ATTRIBUTE5);

827: dbms_sql.column_value(p_cur_get_PLH, 25, X_PLH_Rec.ATTRIBUTE1);
828: dbms_sql.column_value(p_cur_get_PLH, 26, X_PLH_Rec.ATTRIBUTE2);
829: dbms_sql.column_value(p_cur_get_PLH, 27, X_PLH_Rec.ATTRIBUTE3);
830: dbms_sql.column_value(p_cur_get_PLH, 28, X_PLH_Rec.ATTRIBUTE4);
831: dbms_sql.column_value(p_cur_get_PLH, 29, X_PLH_Rec.ATTRIBUTE5);
832: dbms_sql.column_value(p_cur_get_PLH, 30, X_PLH_Rec.ATTRIBUTE6);
833: dbms_sql.column_value(p_cur_get_PLH, 31, X_PLH_Rec.ATTRIBUTE7);
834: dbms_sql.column_value(p_cur_get_PLH, 32, X_PLH_Rec.ATTRIBUTE8);
835: dbms_sql.column_value(p_cur_get_PLH, 33, X_PLH_Rec.ATTRIBUTE9);

Line 832: dbms_sql.column_value(p_cur_get_PLH, 30, X_PLH_Rec.ATTRIBUTE6);

828: dbms_sql.column_value(p_cur_get_PLH, 26, X_PLH_Rec.ATTRIBUTE2);
829: dbms_sql.column_value(p_cur_get_PLH, 27, X_PLH_Rec.ATTRIBUTE3);
830: dbms_sql.column_value(p_cur_get_PLH, 28, X_PLH_Rec.ATTRIBUTE4);
831: dbms_sql.column_value(p_cur_get_PLH, 29, X_PLH_Rec.ATTRIBUTE5);
832: dbms_sql.column_value(p_cur_get_PLH, 30, X_PLH_Rec.ATTRIBUTE6);
833: dbms_sql.column_value(p_cur_get_PLH, 31, X_PLH_Rec.ATTRIBUTE7);
834: dbms_sql.column_value(p_cur_get_PLH, 32, X_PLH_Rec.ATTRIBUTE8);
835: dbms_sql.column_value(p_cur_get_PLH, 33, X_PLH_Rec.ATTRIBUTE9);
836: dbms_sql.column_value(p_cur_get_PLH, 34, X_PLH_Rec.ATTRIBUTE10);

Line 833: dbms_sql.column_value(p_cur_get_PLH, 31, X_PLH_Rec.ATTRIBUTE7);

829: dbms_sql.column_value(p_cur_get_PLH, 27, X_PLH_Rec.ATTRIBUTE3);
830: dbms_sql.column_value(p_cur_get_PLH, 28, X_PLH_Rec.ATTRIBUTE4);
831: dbms_sql.column_value(p_cur_get_PLH, 29, X_PLH_Rec.ATTRIBUTE5);
832: dbms_sql.column_value(p_cur_get_PLH, 30, X_PLH_Rec.ATTRIBUTE6);
833: dbms_sql.column_value(p_cur_get_PLH, 31, X_PLH_Rec.ATTRIBUTE7);
834: dbms_sql.column_value(p_cur_get_PLH, 32, X_PLH_Rec.ATTRIBUTE8);
835: dbms_sql.column_value(p_cur_get_PLH, 33, X_PLH_Rec.ATTRIBUTE9);
836: dbms_sql.column_value(p_cur_get_PLH, 34, X_PLH_Rec.ATTRIBUTE10);
837: dbms_sql.column_value(p_cur_get_PLH, 35, X_PLH_Rec.ATTRIBUTE11);

Line 834: dbms_sql.column_value(p_cur_get_PLH, 32, X_PLH_Rec.ATTRIBUTE8);

830: dbms_sql.column_value(p_cur_get_PLH, 28, X_PLH_Rec.ATTRIBUTE4);
831: dbms_sql.column_value(p_cur_get_PLH, 29, X_PLH_Rec.ATTRIBUTE5);
832: dbms_sql.column_value(p_cur_get_PLH, 30, X_PLH_Rec.ATTRIBUTE6);
833: dbms_sql.column_value(p_cur_get_PLH, 31, X_PLH_Rec.ATTRIBUTE7);
834: dbms_sql.column_value(p_cur_get_PLH, 32, X_PLH_Rec.ATTRIBUTE8);
835: dbms_sql.column_value(p_cur_get_PLH, 33, X_PLH_Rec.ATTRIBUTE9);
836: dbms_sql.column_value(p_cur_get_PLH, 34, X_PLH_Rec.ATTRIBUTE10);
837: dbms_sql.column_value(p_cur_get_PLH, 35, X_PLH_Rec.ATTRIBUTE11);
838: dbms_sql.column_value(p_cur_get_PLH, 36, X_PLH_Rec.ATTRIBUTE12);

Line 835: dbms_sql.column_value(p_cur_get_PLH, 33, X_PLH_Rec.ATTRIBUTE9);

831: dbms_sql.column_value(p_cur_get_PLH, 29, X_PLH_Rec.ATTRIBUTE5);
832: dbms_sql.column_value(p_cur_get_PLH, 30, X_PLH_Rec.ATTRIBUTE6);
833: dbms_sql.column_value(p_cur_get_PLH, 31, X_PLH_Rec.ATTRIBUTE7);
834: dbms_sql.column_value(p_cur_get_PLH, 32, X_PLH_Rec.ATTRIBUTE8);
835: dbms_sql.column_value(p_cur_get_PLH, 33, X_PLH_Rec.ATTRIBUTE9);
836: dbms_sql.column_value(p_cur_get_PLH, 34, X_PLH_Rec.ATTRIBUTE10);
837: dbms_sql.column_value(p_cur_get_PLH, 35, X_PLH_Rec.ATTRIBUTE11);
838: dbms_sql.column_value(p_cur_get_PLH, 36, X_PLH_Rec.ATTRIBUTE12);
839: dbms_sql.column_value(p_cur_get_PLH, 37, X_PLH_Rec.ATTRIBUTE13);

Line 836: dbms_sql.column_value(p_cur_get_PLH, 34, X_PLH_Rec.ATTRIBUTE10);

832: dbms_sql.column_value(p_cur_get_PLH, 30, X_PLH_Rec.ATTRIBUTE6);
833: dbms_sql.column_value(p_cur_get_PLH, 31, X_PLH_Rec.ATTRIBUTE7);
834: dbms_sql.column_value(p_cur_get_PLH, 32, X_PLH_Rec.ATTRIBUTE8);
835: dbms_sql.column_value(p_cur_get_PLH, 33, X_PLH_Rec.ATTRIBUTE9);
836: dbms_sql.column_value(p_cur_get_PLH, 34, X_PLH_Rec.ATTRIBUTE10);
837: dbms_sql.column_value(p_cur_get_PLH, 35, X_PLH_Rec.ATTRIBUTE11);
838: dbms_sql.column_value(p_cur_get_PLH, 36, X_PLH_Rec.ATTRIBUTE12);
839: dbms_sql.column_value(p_cur_get_PLH, 37, X_PLH_Rec.ATTRIBUTE13);
840: dbms_sql.column_value(p_cur_get_PLH, 38, X_PLH_Rec.ATTRIBUTE14);

Line 837: dbms_sql.column_value(p_cur_get_PLH, 35, X_PLH_Rec.ATTRIBUTE11);

833: dbms_sql.column_value(p_cur_get_PLH, 31, X_PLH_Rec.ATTRIBUTE7);
834: dbms_sql.column_value(p_cur_get_PLH, 32, X_PLH_Rec.ATTRIBUTE8);
835: dbms_sql.column_value(p_cur_get_PLH, 33, X_PLH_Rec.ATTRIBUTE9);
836: dbms_sql.column_value(p_cur_get_PLH, 34, X_PLH_Rec.ATTRIBUTE10);
837: dbms_sql.column_value(p_cur_get_PLH, 35, X_PLH_Rec.ATTRIBUTE11);
838: dbms_sql.column_value(p_cur_get_PLH, 36, X_PLH_Rec.ATTRIBUTE12);
839: dbms_sql.column_value(p_cur_get_PLH, 37, X_PLH_Rec.ATTRIBUTE13);
840: dbms_sql.column_value(p_cur_get_PLH, 38, X_PLH_Rec.ATTRIBUTE14);
841: dbms_sql.column_value(p_cur_get_PLH, 39, X_PLH_Rec.ATTRIBUTE15);

Line 838: dbms_sql.column_value(p_cur_get_PLH, 36, X_PLH_Rec.ATTRIBUTE12);

834: dbms_sql.column_value(p_cur_get_PLH, 32, X_PLH_Rec.ATTRIBUTE8);
835: dbms_sql.column_value(p_cur_get_PLH, 33, X_PLH_Rec.ATTRIBUTE9);
836: dbms_sql.column_value(p_cur_get_PLH, 34, X_PLH_Rec.ATTRIBUTE10);
837: dbms_sql.column_value(p_cur_get_PLH, 35, X_PLH_Rec.ATTRIBUTE11);
838: dbms_sql.column_value(p_cur_get_PLH, 36, X_PLH_Rec.ATTRIBUTE12);
839: dbms_sql.column_value(p_cur_get_PLH, 37, X_PLH_Rec.ATTRIBUTE13);
840: dbms_sql.column_value(p_cur_get_PLH, 38, X_PLH_Rec.ATTRIBUTE14);
841: dbms_sql.column_value(p_cur_get_PLH, 39, X_PLH_Rec.ATTRIBUTE15);
842:

Line 839: dbms_sql.column_value(p_cur_get_PLH, 37, X_PLH_Rec.ATTRIBUTE13);

835: dbms_sql.column_value(p_cur_get_PLH, 33, X_PLH_Rec.ATTRIBUTE9);
836: dbms_sql.column_value(p_cur_get_PLH, 34, X_PLH_Rec.ATTRIBUTE10);
837: dbms_sql.column_value(p_cur_get_PLH, 35, X_PLH_Rec.ATTRIBUTE11);
838: dbms_sql.column_value(p_cur_get_PLH, 36, X_PLH_Rec.ATTRIBUTE12);
839: dbms_sql.column_value(p_cur_get_PLH, 37, X_PLH_Rec.ATTRIBUTE13);
840: dbms_sql.column_value(p_cur_get_PLH, 38, X_PLH_Rec.ATTRIBUTE14);
841: dbms_sql.column_value(p_cur_get_PLH, 39, X_PLH_Rec.ATTRIBUTE15);
842:
843: -- Debug Message

Line 840: dbms_sql.column_value(p_cur_get_PLH, 38, X_PLH_Rec.ATTRIBUTE14);

836: dbms_sql.column_value(p_cur_get_PLH, 34, X_PLH_Rec.ATTRIBUTE10);
837: dbms_sql.column_value(p_cur_get_PLH, 35, X_PLH_Rec.ATTRIBUTE11);
838: dbms_sql.column_value(p_cur_get_PLH, 36, X_PLH_Rec.ATTRIBUTE12);
839: dbms_sql.column_value(p_cur_get_PLH, 37, X_PLH_Rec.ATTRIBUTE13);
840: dbms_sql.column_value(p_cur_get_PLH, 38, X_PLH_Rec.ATTRIBUTE14);
841: dbms_sql.column_value(p_cur_get_PLH, 39, X_PLH_Rec.ATTRIBUTE15);
842:
843: -- Debug Message
844: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Ends');

Line 841: dbms_sql.column_value(p_cur_get_PLH, 39, X_PLH_Rec.ATTRIBUTE15);

837: dbms_sql.column_value(p_cur_get_PLH, 35, X_PLH_Rec.ATTRIBUTE11);
838: dbms_sql.column_value(p_cur_get_PLH, 36, X_PLH_Rec.ATTRIBUTE12);
839: dbms_sql.column_value(p_cur_get_PLH, 37, X_PLH_Rec.ATTRIBUTE13);
840: dbms_sql.column_value(p_cur_get_PLH, 38, X_PLH_Rec.ATTRIBUTE14);
841: dbms_sql.column_value(p_cur_get_PLH, 39, X_PLH_Rec.ATTRIBUTE15);
842:
843: -- Debug Message
844: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Ends');
845: END Get_Column_Values;

Line 906: DBMS_SQL.BIND_VARIABLE(p_cur_get_PLH, ':p_PACKLIST_HEADER_ID', P_PLH_Rec.PACKLIST_HEADER_ID);

902: -- The following example applies to all columns,
903: -- developers can copy and paste them.
904: IF( (P_PLH_Rec.PACKLIST_HEADER_ID IS NOT NULL) AND (P_PLH_Rec.PACKLIST_HEADER_ID <> FND_API.G_MISS_NUM) )
905: THEN
906: DBMS_SQL.BIND_VARIABLE(p_cur_get_PLH, ':p_PACKLIST_HEADER_ID', P_PLH_Rec.PACKLIST_HEADER_ID);
907: END IF;
908:
909: -- Debug Message
910: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Bind Variables Ends');