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

Line 276: l_rowid_tbl DBMS_SQL.URowid_Table;

272: l_grp_by_freight_terms VARCHAR2(1);
273: l_grp_by_fob_code VARCHAR2(1);
274: l_grp_by_within_order VARCHAR2(1);
275:
276: l_rowid_tbl DBMS_SQL.URowid_Table;
277: l_del_detail_tbl DBMS_SQL.Number_Table;
278: l_src_line_id_tbl DBMS_SQL.Number_Table;
279: l_org_id_tbl DBMS_SQL.Number_Table;
280: l_customer_id_tbl DBMS_SQL.Number_Table;

Line 277: l_del_detail_tbl DBMS_SQL.Number_Table;

273: l_grp_by_fob_code VARCHAR2(1);
274: l_grp_by_within_order VARCHAR2(1);
275:
276: l_rowid_tbl DBMS_SQL.URowid_Table;
277: l_del_detail_tbl DBMS_SQL.Number_Table;
278: l_src_line_id_tbl DBMS_SQL.Number_Table;
279: l_org_id_tbl DBMS_SQL.Number_Table;
280: l_customer_id_tbl DBMS_SQL.Number_Table;
281: l_organization_id_tbl DBMS_SQL.Number_Table;

Line 278: l_src_line_id_tbl DBMS_SQL.Number_Table;

274: l_grp_by_within_order VARCHAR2(1);
275:
276: l_rowid_tbl DBMS_SQL.URowid_Table;
277: l_del_detail_tbl DBMS_SQL.Number_Table;
278: l_src_line_id_tbl DBMS_SQL.Number_Table;
279: l_org_id_tbl DBMS_SQL.Number_Table;
280: l_customer_id_tbl DBMS_SQL.Number_Table;
281: l_organization_id_tbl DBMS_SQL.Number_Table;
282: l_ship_from_loc_tbl DBMS_SQL.Number_Table;

Line 279: l_org_id_tbl DBMS_SQL.Number_Table;

275:
276: l_rowid_tbl DBMS_SQL.URowid_Table;
277: l_del_detail_tbl DBMS_SQL.Number_Table;
278: l_src_line_id_tbl DBMS_SQL.Number_Table;
279: l_org_id_tbl DBMS_SQL.Number_Table;
280: l_customer_id_tbl DBMS_SQL.Number_Table;
281: l_organization_id_tbl DBMS_SQL.Number_Table;
282: l_ship_from_loc_tbl DBMS_SQL.Number_Table;
283: l_ship_to_site_tbl DBMS_SQL.Number_Table;

Line 280: l_customer_id_tbl DBMS_SQL.Number_Table;

276: l_rowid_tbl DBMS_SQL.URowid_Table;
277: l_del_detail_tbl DBMS_SQL.Number_Table;
278: l_src_line_id_tbl DBMS_SQL.Number_Table;
279: l_org_id_tbl DBMS_SQL.Number_Table;
280: l_customer_id_tbl DBMS_SQL.Number_Table;
281: l_organization_id_tbl DBMS_SQL.Number_Table;
282: l_ship_from_loc_tbl DBMS_SQL.Number_Table;
283: l_ship_to_site_tbl DBMS_SQL.Number_Table;
284: l_invoice_to_site_tbl DBMS_SQL.Number_Table;

Line 281: l_organization_id_tbl DBMS_SQL.Number_Table;

277: l_del_detail_tbl DBMS_SQL.Number_Table;
278: l_src_line_id_tbl DBMS_SQL.Number_Table;
279: l_org_id_tbl DBMS_SQL.Number_Table;
280: l_customer_id_tbl DBMS_SQL.Number_Table;
281: l_organization_id_tbl DBMS_SQL.Number_Table;
282: l_ship_from_loc_tbl DBMS_SQL.Number_Table;
283: l_ship_to_site_tbl DBMS_SQL.Number_Table;
284: l_invoice_to_site_tbl DBMS_SQL.Number_Table;
285: l_deliver_to_site_tbl DBMS_SQL.Number_Table;

Line 282: l_ship_from_loc_tbl DBMS_SQL.Number_Table;

278: l_src_line_id_tbl DBMS_SQL.Number_Table;
279: l_org_id_tbl DBMS_SQL.Number_Table;
280: l_customer_id_tbl DBMS_SQL.Number_Table;
281: l_organization_id_tbl DBMS_SQL.Number_Table;
282: l_ship_from_loc_tbl DBMS_SQL.Number_Table;
283: l_ship_to_site_tbl DBMS_SQL.Number_Table;
284: l_invoice_to_site_tbl DBMS_SQL.Number_Table;
285: l_deliver_to_site_tbl DBMS_SQL.Number_Table;
286: l_ship_to_con_tbl DBMS_SQL.Number_Table;

Line 283: l_ship_to_site_tbl DBMS_SQL.Number_Table;

279: l_org_id_tbl DBMS_SQL.Number_Table;
280: l_customer_id_tbl DBMS_SQL.Number_Table;
281: l_organization_id_tbl DBMS_SQL.Number_Table;
282: l_ship_from_loc_tbl DBMS_SQL.Number_Table;
283: l_ship_to_site_tbl DBMS_SQL.Number_Table;
284: l_invoice_to_site_tbl DBMS_SQL.Number_Table;
285: l_deliver_to_site_tbl DBMS_SQL.Number_Table;
286: l_ship_to_con_tbl DBMS_SQL.Number_Table;
287: l_invoice_to_con_tbl DBMS_SQL.Number_Table;

Line 284: l_invoice_to_site_tbl DBMS_SQL.Number_Table;

280: l_customer_id_tbl DBMS_SQL.Number_Table;
281: l_organization_id_tbl DBMS_SQL.Number_Table;
282: l_ship_from_loc_tbl DBMS_SQL.Number_Table;
283: l_ship_to_site_tbl DBMS_SQL.Number_Table;
284: l_invoice_to_site_tbl DBMS_SQL.Number_Table;
285: l_deliver_to_site_tbl DBMS_SQL.Number_Table;
286: l_ship_to_con_tbl DBMS_SQL.Number_Table;
287: l_invoice_to_con_tbl DBMS_SQL.Number_Table;
288: l_deliver_to_con_tbl DBMS_SQL.Number_Table;

Line 285: l_deliver_to_site_tbl DBMS_SQL.Number_Table;

281: l_organization_id_tbl DBMS_SQL.Number_Table;
282: l_ship_from_loc_tbl DBMS_SQL.Number_Table;
283: l_ship_to_site_tbl DBMS_SQL.Number_Table;
284: l_invoice_to_site_tbl DBMS_SQL.Number_Table;
285: l_deliver_to_site_tbl DBMS_SQL.Number_Table;
286: l_ship_to_con_tbl DBMS_SQL.Number_Table;
287: l_invoice_to_con_tbl DBMS_SQL.Number_Table;
288: l_deliver_to_con_tbl DBMS_SQL.Number_Table;
289: l_curr_code_tbl DBMS_SQL.Varchar2_Table;

Line 286: l_ship_to_con_tbl DBMS_SQL.Number_Table;

282: l_ship_from_loc_tbl DBMS_SQL.Number_Table;
283: l_ship_to_site_tbl DBMS_SQL.Number_Table;
284: l_invoice_to_site_tbl DBMS_SQL.Number_Table;
285: l_deliver_to_site_tbl DBMS_SQL.Number_Table;
286: l_ship_to_con_tbl DBMS_SQL.Number_Table;
287: l_invoice_to_con_tbl DBMS_SQL.Number_Table;
288: l_deliver_to_con_tbl DBMS_SQL.Number_Table;
289: l_curr_code_tbl DBMS_SQL.Varchar2_Table;
290: l_ship_method_tbl DBMS_SQL.Varchar2_Table;

Line 287: l_invoice_to_con_tbl DBMS_SQL.Number_Table;

283: l_ship_to_site_tbl DBMS_SQL.Number_Table;
284: l_invoice_to_site_tbl DBMS_SQL.Number_Table;
285: l_deliver_to_site_tbl DBMS_SQL.Number_Table;
286: l_ship_to_con_tbl DBMS_SQL.Number_Table;
287: l_invoice_to_con_tbl DBMS_SQL.Number_Table;
288: l_deliver_to_con_tbl DBMS_SQL.Number_Table;
289: l_curr_code_tbl DBMS_SQL.Varchar2_Table;
290: l_ship_method_tbl DBMS_SQL.Varchar2_Table;
291: l_freight_terms_tbl DBMS_SQL.Varchar2_Table;

Line 288: l_deliver_to_con_tbl DBMS_SQL.Number_Table;

284: l_invoice_to_site_tbl DBMS_SQL.Number_Table;
285: l_deliver_to_site_tbl DBMS_SQL.Number_Table;
286: l_ship_to_con_tbl DBMS_SQL.Number_Table;
287: l_invoice_to_con_tbl DBMS_SQL.Number_Table;
288: l_deliver_to_con_tbl DBMS_SQL.Number_Table;
289: l_curr_code_tbl DBMS_SQL.Varchar2_Table;
290: l_ship_method_tbl DBMS_SQL.Varchar2_Table;
291: l_freight_terms_tbl DBMS_SQL.Varchar2_Table;
292: l_fob_code_tbl DBMS_SQL.Varchar2_Table;

Line 289: l_curr_code_tbl DBMS_SQL.Varchar2_Table;

285: l_deliver_to_site_tbl DBMS_SQL.Number_Table;
286: l_ship_to_con_tbl DBMS_SQL.Number_Table;
287: l_invoice_to_con_tbl DBMS_SQL.Number_Table;
288: l_deliver_to_con_tbl DBMS_SQL.Number_Table;
289: l_curr_code_tbl DBMS_SQL.Varchar2_Table;
290: l_ship_method_tbl DBMS_SQL.Varchar2_Table;
291: l_freight_terms_tbl DBMS_SQL.Varchar2_Table;
292: l_fob_code_tbl DBMS_SQL.Varchar2_Table;
293: l_group_id_tbl DBMS_SQL.Number_Table;

Line 290: l_ship_method_tbl DBMS_SQL.Varchar2_Table;

286: l_ship_to_con_tbl DBMS_SQL.Number_Table;
287: l_invoice_to_con_tbl DBMS_SQL.Number_Table;
288: l_deliver_to_con_tbl DBMS_SQL.Number_Table;
289: l_curr_code_tbl DBMS_SQL.Varchar2_Table;
290: l_ship_method_tbl DBMS_SQL.Varchar2_Table;
291: l_freight_terms_tbl DBMS_SQL.Varchar2_Table;
292: l_fob_code_tbl DBMS_SQL.Varchar2_Table;
293: l_group_id_tbl DBMS_SQL.Number_Table;
294:

Line 291: l_freight_terms_tbl DBMS_SQL.Varchar2_Table;

287: l_invoice_to_con_tbl DBMS_SQL.Number_Table;
288: l_deliver_to_con_tbl DBMS_SQL.Number_Table;
289: l_curr_code_tbl DBMS_SQL.Varchar2_Table;
290: l_ship_method_tbl DBMS_SQL.Varchar2_Table;
291: l_freight_terms_tbl DBMS_SQL.Varchar2_Table;
292: l_fob_code_tbl DBMS_SQL.Varchar2_Table;
293: l_group_id_tbl DBMS_SQL.Number_Table;
294:
295: l_shipment_batch_tbl Shipment_Batch_Tbl;

Line 292: l_fob_code_tbl DBMS_SQL.Varchar2_Table;

288: l_deliver_to_con_tbl DBMS_SQL.Number_Table;
289: l_curr_code_tbl DBMS_SQL.Varchar2_Table;
290: l_ship_method_tbl DBMS_SQL.Varchar2_Table;
291: l_freight_terms_tbl DBMS_SQL.Varchar2_Table;
292: l_fob_code_tbl DBMS_SQL.Varchar2_Table;
293: l_group_id_tbl DBMS_SQL.Number_Table;
294:
295: l_shipment_batch_tbl Shipment_Batch_Tbl;
296: l_dd_batch_id_tbl WSH_UTIL_CORE.Id_Tab_Type;

Line 293: l_group_id_tbl DBMS_SQL.Number_Table;

289: l_curr_code_tbl DBMS_SQL.Varchar2_Table;
290: l_ship_method_tbl DBMS_SQL.Varchar2_Table;
291: l_freight_terms_tbl DBMS_SQL.Varchar2_Table;
292: l_fob_code_tbl DBMS_SQL.Varchar2_Table;
293: l_group_id_tbl DBMS_SQL.Number_Table;
294:
295: l_shipment_batch_tbl Shipment_Batch_Tbl;
296: l_dd_batch_id_tbl WSH_UTIL_CORE.Id_Tab_Type;
297: l_dd_line_num_tbl WSH_UTIL_CORE.Id_Tab_Type;

Line 586: v_cursorid := DBMS_SQL.Open_Cursor;

582: WSH_DEBUG_SV.log(l_module_name, 'Transaction Query', l_dyn_query);
583: END IF;
584: --
585:
586: v_cursorid := DBMS_SQL.Open_Cursor;
587: DBMS_SQL.Parse(v_cursorid, l_dyn_query, DBMS_SQL.v7 );
588: --
589: IF l_debug_on THEN
590: WSH_DEBUG_SV.log(l_module_name, 'Opened and Pasred cursor successfully', v_cursorid);

Line 587: DBMS_SQL.Parse(v_cursorid, l_dyn_query, DBMS_SQL.v7 );

583: END IF;
584: --
585:
586: v_cursorid := DBMS_SQL.Open_Cursor;
587: DBMS_SQL.Parse(v_cursorid, l_dyn_query, DBMS_SQL.v7 );
588: --
589: IF l_debug_on THEN
590: WSH_DEBUG_SV.log(l_module_name, 'Opened and Pasred cursor successfully', v_cursorid);
591: END IF;

Line 595: DBMS_SQL.Define_Array(v_cursorid, 1, l_rowid_tbl , l_bulk_count, 1);

591: END IF;
592: --
593: --Using Define_Array to fetch in BULK based on l_bulk_count.
594: --Index of PL/SQL table will start from 1.
595: DBMS_SQL.Define_Array(v_cursorid, 1, l_rowid_tbl , l_bulk_count, 1);
596: DBMS_SQL.Define_Array(v_cursorid, 2, l_del_detail_tbl , l_bulk_count, 1);
597: DBMS_SQL.Define_Array(v_cursorid, 3, l_src_line_id_tbl , l_bulk_count, 1);
598: DBMS_SQL.Define_Array(v_cursorid, 4, l_org_id_tbl , l_bulk_count, 1);
599: DBMS_SQL.Define_Array(v_cursorid, 5, l_curr_code_tbl , l_bulk_count, 1);

Line 596: DBMS_SQL.Define_Array(v_cursorid, 2, l_del_detail_tbl , l_bulk_count, 1);

592: --
593: --Using Define_Array to fetch in BULK based on l_bulk_count.
594: --Index of PL/SQL table will start from 1.
595: DBMS_SQL.Define_Array(v_cursorid, 1, l_rowid_tbl , l_bulk_count, 1);
596: DBMS_SQL.Define_Array(v_cursorid, 2, l_del_detail_tbl , l_bulk_count, 1);
597: DBMS_SQL.Define_Array(v_cursorid, 3, l_src_line_id_tbl , l_bulk_count, 1);
598: DBMS_SQL.Define_Array(v_cursorid, 4, l_org_id_tbl , l_bulk_count, 1);
599: DBMS_SQL.Define_Array(v_cursorid, 5, l_curr_code_tbl , l_bulk_count, 1);
600: DBMS_SQL.Define_Array(v_cursorid, 6, l_customer_id_tbl , l_bulk_count, 1);

Line 597: DBMS_SQL.Define_Array(v_cursorid, 3, l_src_line_id_tbl , l_bulk_count, 1);

593: --Using Define_Array to fetch in BULK based on l_bulk_count.
594: --Index of PL/SQL table will start from 1.
595: DBMS_SQL.Define_Array(v_cursorid, 1, l_rowid_tbl , l_bulk_count, 1);
596: DBMS_SQL.Define_Array(v_cursorid, 2, l_del_detail_tbl , l_bulk_count, 1);
597: DBMS_SQL.Define_Array(v_cursorid, 3, l_src_line_id_tbl , l_bulk_count, 1);
598: DBMS_SQL.Define_Array(v_cursorid, 4, l_org_id_tbl , l_bulk_count, 1);
599: DBMS_SQL.Define_Array(v_cursorid, 5, l_curr_code_tbl , l_bulk_count, 1);
600: DBMS_SQL.Define_Array(v_cursorid, 6, l_customer_id_tbl , l_bulk_count, 1);
601: DBMS_SQL.Define_Array(v_cursorid, 7, l_organization_id_tbl , l_bulk_count, 1);

Line 598: DBMS_SQL.Define_Array(v_cursorid, 4, l_org_id_tbl , l_bulk_count, 1);

594: --Index of PL/SQL table will start from 1.
595: DBMS_SQL.Define_Array(v_cursorid, 1, l_rowid_tbl , l_bulk_count, 1);
596: DBMS_SQL.Define_Array(v_cursorid, 2, l_del_detail_tbl , l_bulk_count, 1);
597: DBMS_SQL.Define_Array(v_cursorid, 3, l_src_line_id_tbl , l_bulk_count, 1);
598: DBMS_SQL.Define_Array(v_cursorid, 4, l_org_id_tbl , l_bulk_count, 1);
599: DBMS_SQL.Define_Array(v_cursorid, 5, l_curr_code_tbl , l_bulk_count, 1);
600: DBMS_SQL.Define_Array(v_cursorid, 6, l_customer_id_tbl , l_bulk_count, 1);
601: DBMS_SQL.Define_Array(v_cursorid, 7, l_organization_id_tbl , l_bulk_count, 1);
602: DBMS_SQL.Define_Array(v_cursorid, 8, l_ship_from_loc_tbl , l_bulk_count, 1);

Line 599: DBMS_SQL.Define_Array(v_cursorid, 5, l_curr_code_tbl , l_bulk_count, 1);

595: DBMS_SQL.Define_Array(v_cursorid, 1, l_rowid_tbl , l_bulk_count, 1);
596: DBMS_SQL.Define_Array(v_cursorid, 2, l_del_detail_tbl , l_bulk_count, 1);
597: DBMS_SQL.Define_Array(v_cursorid, 3, l_src_line_id_tbl , l_bulk_count, 1);
598: DBMS_SQL.Define_Array(v_cursorid, 4, l_org_id_tbl , l_bulk_count, 1);
599: DBMS_SQL.Define_Array(v_cursorid, 5, l_curr_code_tbl , l_bulk_count, 1);
600: DBMS_SQL.Define_Array(v_cursorid, 6, l_customer_id_tbl , l_bulk_count, 1);
601: DBMS_SQL.Define_Array(v_cursorid, 7, l_organization_id_tbl , l_bulk_count, 1);
602: DBMS_SQL.Define_Array(v_cursorid, 8, l_ship_from_loc_tbl , l_bulk_count, 1);
603: DBMS_SQL.Define_Array(v_cursorid, 9, l_ship_to_site_tbl , l_bulk_count, 1);

Line 600: DBMS_SQL.Define_Array(v_cursorid, 6, l_customer_id_tbl , l_bulk_count, 1);

596: DBMS_SQL.Define_Array(v_cursorid, 2, l_del_detail_tbl , l_bulk_count, 1);
597: DBMS_SQL.Define_Array(v_cursorid, 3, l_src_line_id_tbl , l_bulk_count, 1);
598: DBMS_SQL.Define_Array(v_cursorid, 4, l_org_id_tbl , l_bulk_count, 1);
599: DBMS_SQL.Define_Array(v_cursorid, 5, l_curr_code_tbl , l_bulk_count, 1);
600: DBMS_SQL.Define_Array(v_cursorid, 6, l_customer_id_tbl , l_bulk_count, 1);
601: DBMS_SQL.Define_Array(v_cursorid, 7, l_organization_id_tbl , l_bulk_count, 1);
602: DBMS_SQL.Define_Array(v_cursorid, 8, l_ship_from_loc_tbl , l_bulk_count, 1);
603: DBMS_SQL.Define_Array(v_cursorid, 9, l_ship_to_site_tbl , l_bulk_count, 1);
604: DBMS_SQL.Define_Array(v_cursorid, 10, l_invoice_to_site_tbl , l_bulk_count, 1);

Line 601: DBMS_SQL.Define_Array(v_cursorid, 7, l_organization_id_tbl , l_bulk_count, 1);

597: DBMS_SQL.Define_Array(v_cursorid, 3, l_src_line_id_tbl , l_bulk_count, 1);
598: DBMS_SQL.Define_Array(v_cursorid, 4, l_org_id_tbl , l_bulk_count, 1);
599: DBMS_SQL.Define_Array(v_cursorid, 5, l_curr_code_tbl , l_bulk_count, 1);
600: DBMS_SQL.Define_Array(v_cursorid, 6, l_customer_id_tbl , l_bulk_count, 1);
601: DBMS_SQL.Define_Array(v_cursorid, 7, l_organization_id_tbl , l_bulk_count, 1);
602: DBMS_SQL.Define_Array(v_cursorid, 8, l_ship_from_loc_tbl , l_bulk_count, 1);
603: DBMS_SQL.Define_Array(v_cursorid, 9, l_ship_to_site_tbl , l_bulk_count, 1);
604: DBMS_SQL.Define_Array(v_cursorid, 10, l_invoice_to_site_tbl , l_bulk_count, 1);
605: DBMS_SQL.Define_Array(v_cursorid, 11, l_deliver_to_site_tbl , l_bulk_count, 1);

Line 602: DBMS_SQL.Define_Array(v_cursorid, 8, l_ship_from_loc_tbl , l_bulk_count, 1);

598: DBMS_SQL.Define_Array(v_cursorid, 4, l_org_id_tbl , l_bulk_count, 1);
599: DBMS_SQL.Define_Array(v_cursorid, 5, l_curr_code_tbl , l_bulk_count, 1);
600: DBMS_SQL.Define_Array(v_cursorid, 6, l_customer_id_tbl , l_bulk_count, 1);
601: DBMS_SQL.Define_Array(v_cursorid, 7, l_organization_id_tbl , l_bulk_count, 1);
602: DBMS_SQL.Define_Array(v_cursorid, 8, l_ship_from_loc_tbl , l_bulk_count, 1);
603: DBMS_SQL.Define_Array(v_cursorid, 9, l_ship_to_site_tbl , l_bulk_count, 1);
604: DBMS_SQL.Define_Array(v_cursorid, 10, l_invoice_to_site_tbl , l_bulk_count, 1);
605: DBMS_SQL.Define_Array(v_cursorid, 11, l_deliver_to_site_tbl , l_bulk_count, 1);
606: DBMS_SQL.Define_Array(v_cursorid, 12, l_ship_to_con_tbl , l_bulk_count, 1);

Line 603: DBMS_SQL.Define_Array(v_cursorid, 9, l_ship_to_site_tbl , l_bulk_count, 1);

599: DBMS_SQL.Define_Array(v_cursorid, 5, l_curr_code_tbl , l_bulk_count, 1);
600: DBMS_SQL.Define_Array(v_cursorid, 6, l_customer_id_tbl , l_bulk_count, 1);
601: DBMS_SQL.Define_Array(v_cursorid, 7, l_organization_id_tbl , l_bulk_count, 1);
602: DBMS_SQL.Define_Array(v_cursorid, 8, l_ship_from_loc_tbl , l_bulk_count, 1);
603: DBMS_SQL.Define_Array(v_cursorid, 9, l_ship_to_site_tbl , l_bulk_count, 1);
604: DBMS_SQL.Define_Array(v_cursorid, 10, l_invoice_to_site_tbl , l_bulk_count, 1);
605: DBMS_SQL.Define_Array(v_cursorid, 11, l_deliver_to_site_tbl , l_bulk_count, 1);
606: DBMS_SQL.Define_Array(v_cursorid, 12, l_ship_to_con_tbl , l_bulk_count, 1);
607: DBMS_SQL.Define_Array(v_cursorid, 13, l_invoice_to_con_tbl , l_bulk_count, 1);

Line 604: DBMS_SQL.Define_Array(v_cursorid, 10, l_invoice_to_site_tbl , l_bulk_count, 1);

600: DBMS_SQL.Define_Array(v_cursorid, 6, l_customer_id_tbl , l_bulk_count, 1);
601: DBMS_SQL.Define_Array(v_cursorid, 7, l_organization_id_tbl , l_bulk_count, 1);
602: DBMS_SQL.Define_Array(v_cursorid, 8, l_ship_from_loc_tbl , l_bulk_count, 1);
603: DBMS_SQL.Define_Array(v_cursorid, 9, l_ship_to_site_tbl , l_bulk_count, 1);
604: DBMS_SQL.Define_Array(v_cursorid, 10, l_invoice_to_site_tbl , l_bulk_count, 1);
605: DBMS_SQL.Define_Array(v_cursorid, 11, l_deliver_to_site_tbl , l_bulk_count, 1);
606: DBMS_SQL.Define_Array(v_cursorid, 12, l_ship_to_con_tbl , l_bulk_count, 1);
607: DBMS_SQL.Define_Array(v_cursorid, 13, l_invoice_to_con_tbl , l_bulk_count, 1);
608: DBMS_SQL.Define_Array(v_cursorid, 14, l_deliver_to_con_tbl , l_bulk_count, 1);

Line 605: DBMS_SQL.Define_Array(v_cursorid, 11, l_deliver_to_site_tbl , l_bulk_count, 1);

601: DBMS_SQL.Define_Array(v_cursorid, 7, l_organization_id_tbl , l_bulk_count, 1);
602: DBMS_SQL.Define_Array(v_cursorid, 8, l_ship_from_loc_tbl , l_bulk_count, 1);
603: DBMS_SQL.Define_Array(v_cursorid, 9, l_ship_to_site_tbl , l_bulk_count, 1);
604: DBMS_SQL.Define_Array(v_cursorid, 10, l_invoice_to_site_tbl , l_bulk_count, 1);
605: DBMS_SQL.Define_Array(v_cursorid, 11, l_deliver_to_site_tbl , l_bulk_count, 1);
606: DBMS_SQL.Define_Array(v_cursorid, 12, l_ship_to_con_tbl , l_bulk_count, 1);
607: DBMS_SQL.Define_Array(v_cursorid, 13, l_invoice_to_con_tbl , l_bulk_count, 1);
608: DBMS_SQL.Define_Array(v_cursorid, 14, l_deliver_to_con_tbl , l_bulk_count, 1);
609: DBMS_SQL.Define_Array(v_cursorid, 15, l_ship_method_tbl , l_bulk_count, 1);

Line 606: DBMS_SQL.Define_Array(v_cursorid, 12, l_ship_to_con_tbl , l_bulk_count, 1);

602: DBMS_SQL.Define_Array(v_cursorid, 8, l_ship_from_loc_tbl , l_bulk_count, 1);
603: DBMS_SQL.Define_Array(v_cursorid, 9, l_ship_to_site_tbl , l_bulk_count, 1);
604: DBMS_SQL.Define_Array(v_cursorid, 10, l_invoice_to_site_tbl , l_bulk_count, 1);
605: DBMS_SQL.Define_Array(v_cursorid, 11, l_deliver_to_site_tbl , l_bulk_count, 1);
606: DBMS_SQL.Define_Array(v_cursorid, 12, l_ship_to_con_tbl , l_bulk_count, 1);
607: DBMS_SQL.Define_Array(v_cursorid, 13, l_invoice_to_con_tbl , l_bulk_count, 1);
608: DBMS_SQL.Define_Array(v_cursorid, 14, l_deliver_to_con_tbl , l_bulk_count, 1);
609: DBMS_SQL.Define_Array(v_cursorid, 15, l_ship_method_tbl , l_bulk_count, 1);
610: DBMS_SQL.Define_Array(v_cursorid, 16, l_freight_terms_tbl , l_bulk_count, 1);

Line 607: DBMS_SQL.Define_Array(v_cursorid, 13, l_invoice_to_con_tbl , l_bulk_count, 1);

603: DBMS_SQL.Define_Array(v_cursorid, 9, l_ship_to_site_tbl , l_bulk_count, 1);
604: DBMS_SQL.Define_Array(v_cursorid, 10, l_invoice_to_site_tbl , l_bulk_count, 1);
605: DBMS_SQL.Define_Array(v_cursorid, 11, l_deliver_to_site_tbl , l_bulk_count, 1);
606: DBMS_SQL.Define_Array(v_cursorid, 12, l_ship_to_con_tbl , l_bulk_count, 1);
607: DBMS_SQL.Define_Array(v_cursorid, 13, l_invoice_to_con_tbl , l_bulk_count, 1);
608: DBMS_SQL.Define_Array(v_cursorid, 14, l_deliver_to_con_tbl , l_bulk_count, 1);
609: DBMS_SQL.Define_Array(v_cursorid, 15, l_ship_method_tbl , l_bulk_count, 1);
610: DBMS_SQL.Define_Array(v_cursorid, 16, l_freight_terms_tbl , l_bulk_count, 1);
611: DBMS_SQL.Define_Array(v_cursorid, 17, l_fob_code_tbl , l_bulk_count, 1);

Line 608: DBMS_SQL.Define_Array(v_cursorid, 14, l_deliver_to_con_tbl , l_bulk_count, 1);

604: DBMS_SQL.Define_Array(v_cursorid, 10, l_invoice_to_site_tbl , l_bulk_count, 1);
605: DBMS_SQL.Define_Array(v_cursorid, 11, l_deliver_to_site_tbl , l_bulk_count, 1);
606: DBMS_SQL.Define_Array(v_cursorid, 12, l_ship_to_con_tbl , l_bulk_count, 1);
607: DBMS_SQL.Define_Array(v_cursorid, 13, l_invoice_to_con_tbl , l_bulk_count, 1);
608: DBMS_SQL.Define_Array(v_cursorid, 14, l_deliver_to_con_tbl , l_bulk_count, 1);
609: DBMS_SQL.Define_Array(v_cursorid, 15, l_ship_method_tbl , l_bulk_count, 1);
610: DBMS_SQL.Define_Array(v_cursorid, 16, l_freight_terms_tbl , l_bulk_count, 1);
611: DBMS_SQL.Define_Array(v_cursorid, 17, l_fob_code_tbl , l_bulk_count, 1);
612: DBMS_SQL.Define_Array(v_cursorid, 18, l_group_id_tbl , l_bulk_count, 1);

Line 609: DBMS_SQL.Define_Array(v_cursorid, 15, l_ship_method_tbl , l_bulk_count, 1);

605: DBMS_SQL.Define_Array(v_cursorid, 11, l_deliver_to_site_tbl , l_bulk_count, 1);
606: DBMS_SQL.Define_Array(v_cursorid, 12, l_ship_to_con_tbl , l_bulk_count, 1);
607: DBMS_SQL.Define_Array(v_cursorid, 13, l_invoice_to_con_tbl , l_bulk_count, 1);
608: DBMS_SQL.Define_Array(v_cursorid, 14, l_deliver_to_con_tbl , l_bulk_count, 1);
609: DBMS_SQL.Define_Array(v_cursorid, 15, l_ship_method_tbl , l_bulk_count, 1);
610: DBMS_SQL.Define_Array(v_cursorid, 16, l_freight_terms_tbl , l_bulk_count, 1);
611: DBMS_SQL.Define_Array(v_cursorid, 17, l_fob_code_tbl , l_bulk_count, 1);
612: DBMS_SQL.Define_Array(v_cursorid, 18, l_group_id_tbl , l_bulk_count, 1);
613:

Line 610: DBMS_SQL.Define_Array(v_cursorid, 16, l_freight_terms_tbl , l_bulk_count, 1);

606: DBMS_SQL.Define_Array(v_cursorid, 12, l_ship_to_con_tbl , l_bulk_count, 1);
607: DBMS_SQL.Define_Array(v_cursorid, 13, l_invoice_to_con_tbl , l_bulk_count, 1);
608: DBMS_SQL.Define_Array(v_cursorid, 14, l_deliver_to_con_tbl , l_bulk_count, 1);
609: DBMS_SQL.Define_Array(v_cursorid, 15, l_ship_method_tbl , l_bulk_count, 1);
610: DBMS_SQL.Define_Array(v_cursorid, 16, l_freight_terms_tbl , l_bulk_count, 1);
611: DBMS_SQL.Define_Array(v_cursorid, 17, l_fob_code_tbl , l_bulk_count, 1);
612: DBMS_SQL.Define_Array(v_cursorid, 18, l_group_id_tbl , l_bulk_count, 1);
613:
614: --Assigning Bind Values

Line 611: DBMS_SQL.Define_Array(v_cursorid, 17, l_fob_code_tbl , l_bulk_count, 1);

607: DBMS_SQL.Define_Array(v_cursorid, 13, l_invoice_to_con_tbl , l_bulk_count, 1);
608: DBMS_SQL.Define_Array(v_cursorid, 14, l_deliver_to_con_tbl , l_bulk_count, 1);
609: DBMS_SQL.Define_Array(v_cursorid, 15, l_ship_method_tbl , l_bulk_count, 1);
610: DBMS_SQL.Define_Array(v_cursorid, 16, l_freight_terms_tbl , l_bulk_count, 1);
611: DBMS_SQL.Define_Array(v_cursorid, 17, l_fob_code_tbl , l_bulk_count, 1);
612: DBMS_SQL.Define_Array(v_cursorid, 18, l_group_id_tbl , l_bulk_count, 1);
613:
614: --Assigning Bind Values
615: -- { Binding Starts Here

Line 612: DBMS_SQL.Define_Array(v_cursorid, 18, l_group_id_tbl , l_bulk_count, 1);

608: DBMS_SQL.Define_Array(v_cursorid, 14, l_deliver_to_con_tbl , l_bulk_count, 1);
609: DBMS_SQL.Define_Array(v_cursorid, 15, l_ship_method_tbl , l_bulk_count, 1);
610: DBMS_SQL.Define_Array(v_cursorid, 16, l_freight_terms_tbl , l_bulk_count, 1);
611: DBMS_SQL.Define_Array(v_cursorid, 17, l_fob_code_tbl , l_bulk_count, 1);
612: DBMS_SQL.Define_Array(v_cursorid, 18, l_group_id_tbl , l_bulk_count, 1);
613:
614: --Assigning Bind Values
615: -- { Binding Starts Here
616: IF p_organization_id is not null THEN

Line 617: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_organization_id', p_organization_id);

613:
614: --Assigning Bind Values
615: -- { Binding Starts Here
616: IF p_organization_id is not null THEN
617: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_organization_id', p_organization_id);
618: END IF;
619:
620: IF p_customer_id is not null THEN
621: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_customer_id', p_customer_id);

Line 621: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_customer_id', p_customer_id);

617: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_organization_id', p_organization_id);
618: END IF;
619:
620: IF p_customer_id is not null THEN
621: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_customer_id', p_customer_id);
622: END IF;
623:
624: IF p_ship_to_location_id is not null THEN
625: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_ship_to_location_id', p_ship_to_location_id);

Line 625: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_ship_to_location_id', p_ship_to_location_id);

621: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_customer_id', p_customer_id);
622: END IF;
623:
624: IF p_ship_to_location_id is not null THEN
625: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_ship_to_location_id', p_ship_to_location_id);
626: END IF;
627:
628: IF p_transaction_type_id is not null THEN
629: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_transaction_type_id', p_transaction_type_id);

Line 629: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_transaction_type_id', p_transaction_type_id);

625: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_ship_to_location_id', p_ship_to_location_id);
626: END IF;
627:
628: IF p_transaction_type_id is not null THEN
629: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_transaction_type_id', p_transaction_type_id);
630: END IF;
631:
632: IF p_from_order_number is not null and p_to_order_number is not null
633: THEN

Line 634: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_from_order_number', p_from_order_number);

630: END IF;
631:
632: IF p_from_order_number is not null and p_to_order_number is not null
633: THEN
634: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_from_order_number', p_from_order_number);
635: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_to_order_number', p_to_order_number);
636: ELSIF p_from_order_number is not null and p_to_order_number is null
637: THEN
638: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_from_order_number', p_from_order_number);

Line 635: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_to_order_number', p_to_order_number);

631:
632: IF p_from_order_number is not null and p_to_order_number is not null
633: THEN
634: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_from_order_number', p_from_order_number);
635: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_to_order_number', p_to_order_number);
636: ELSIF p_from_order_number is not null and p_to_order_number is null
637: THEN
638: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_from_order_number', p_from_order_number);
639: ELSIF p_from_order_number is null and p_to_order_number is not null

Line 638: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_from_order_number', p_from_order_number);

634: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_from_order_number', p_from_order_number);
635: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_to_order_number', p_to_order_number);
636: ELSIF p_from_order_number is not null and p_to_order_number is null
637: THEN
638: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_from_order_number', p_from_order_number);
639: ELSIF p_from_order_number is null and p_to_order_number is not null
640: THEN
641: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_to_order_number', p_to_order_number);
642: END IF;

Line 641: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_to_order_number', p_to_order_number);

637: THEN
638: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_from_order_number', p_from_order_number);
639: ELSIF p_from_order_number is null and p_to_order_number is not null
640: THEN
641: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_to_order_number', p_to_order_number);
642: END IF;
643:
644: IF l_from_request_date is not null and l_to_request_date is not null
645: THEN

Line 646: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_from_request_date', l_from_request_date);

642: END IF;
643:
644: IF l_from_request_date is not null and l_to_request_date is not null
645: THEN
646: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_from_request_date', l_from_request_date);
647: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_to_request_date', l_to_request_date);
648: ELSIF l_from_request_date is not null and l_to_request_date is null
649: THEN
650: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_from_request_date', l_from_request_date);

Line 647: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_to_request_date', l_to_request_date);

643:
644: IF l_from_request_date is not null and l_to_request_date is not null
645: THEN
646: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_from_request_date', l_from_request_date);
647: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_to_request_date', l_to_request_date);
648: ELSIF l_from_request_date is not null and l_to_request_date is null
649: THEN
650: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_from_request_date', l_from_request_date);
651: ELSIF l_from_request_date is null and l_to_request_date is not null

Line 650: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_from_request_date', l_from_request_date);

646: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_from_request_date', l_from_request_date);
647: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_to_request_date', l_to_request_date);
648: ELSIF l_from_request_date is not null and l_to_request_date is null
649: THEN
650: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_from_request_date', l_from_request_date);
651: ELSIF l_from_request_date is null and l_to_request_date is not null
652: THEN
653: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_to_request_date', l_to_request_date);
654: END IF;

Line 653: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_to_request_date', l_to_request_date);

649: THEN
650: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_from_request_date', l_from_request_date);
651: ELSIF l_from_request_date is null and l_to_request_date is not null
652: THEN
653: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_to_request_date', l_to_request_date);
654: END IF;
655:
656: IF l_from_schedule_date is not null and l_to_schedule_date is not null
657: THEN

Line 658: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_from_schedule_date', l_from_schedule_date);

654: END IF;
655:
656: IF l_from_schedule_date is not null and l_to_schedule_date is not null
657: THEN
658: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_from_schedule_date', l_from_schedule_date);
659: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_to_schedule_date', l_to_schedule_date);
660: ELSIF l_from_schedule_date is not null and l_to_schedule_date is null
661: THEN
662: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_from_schedule_date', l_from_schedule_date);

Line 659: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_to_schedule_date', l_to_schedule_date);

655:
656: IF l_from_schedule_date is not null and l_to_schedule_date is not null
657: THEN
658: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_from_schedule_date', l_from_schedule_date);
659: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_to_schedule_date', l_to_schedule_date);
660: ELSIF l_from_schedule_date is not null and l_to_schedule_date is null
661: THEN
662: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_from_schedule_date', l_from_schedule_date);
663: ELSIF l_from_schedule_date is null and l_to_schedule_date is not null

Line 662: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_from_schedule_date', l_from_schedule_date);

658: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_from_schedule_date', l_from_schedule_date);
659: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_to_schedule_date', l_to_schedule_date);
660: ELSIF l_from_schedule_date is not null and l_to_schedule_date is null
661: THEN
662: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_from_schedule_date', l_from_schedule_date);
663: ELSIF l_from_schedule_date is null and l_to_schedule_date is not null
664: THEN
665: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_to_schedule_date', l_to_schedule_date);
666: END IF;

Line 665: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_to_schedule_date', l_to_schedule_date);

661: THEN
662: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_from_schedule_date', l_from_schedule_date);
663: ELSIF l_from_schedule_date is null and l_to_schedule_date is not null
664: THEN
665: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_to_schedule_date', l_to_schedule_date);
666: END IF;
667:
668: IF p_shipment_priority is not null THEN
669: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_shipment_priority', p_shipment_priority);

Line 669: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_shipment_priority', p_shipment_priority);

665: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_to_schedule_date', l_to_schedule_date);
666: END IF;
667:
668: IF p_shipment_priority is not null THEN
669: DBMS_SQL.BIND_VARIABLE(v_cursorid, ':x_shipment_priority', p_shipment_priority);
670: END IF;
671: -- } Binding End Here
672:
673:

Line 678: v_ignore := DBMS_SQL.Execute(v_cursorid);

674: -- A current index into each array is maintained automatically. This index is initialized
675: -- to 1 at EXECUTE and keeps getting updated every time a COLUMN_VALUE call
676: -- is made. If you reexecute at any point, then the current index for each DEFINE is
677: -- re-initialized to 1.
678: v_ignore := DBMS_SQL.Execute(v_cursorid);
679:
680: l_prev_group_id := 0;
681: l_line_number := 0;
682: --{ Loop for fetching records - Starts

Line 685: -- are kept in DBMS_SQL buffers. When the COLUMN_VALUE call is run, those rows

681: l_line_number := 0;
682: --{ Loop for fetching records - Starts
683: LOOP
684: -- Each time when FETCH_ROWS is called, it fetches l_bulk_count(1000) rows and
685: -- are kept in DBMS_SQL buffers. When the COLUMN_VALUE call is run, those rows
686: -- move into the PL/SQL table specified (in this case l_rowid_tbl..l_group_id_tbl), at positions 1 to l_bulk_count(1000),
687: -- as specified in the DEFINE statements.
688: -- When the second batch is fetched in the loop, the rows go to positions 1001 to 2000; and so on.
689: v_ignore := DBMS_SQL.Fetch_Rows(v_cursorid);

Line 689: v_ignore := DBMS_SQL.Fetch_Rows(v_cursorid);

685: -- are kept in DBMS_SQL buffers. When the COLUMN_VALUE call is run, those rows
686: -- move into the PL/SQL table specified (in this case l_rowid_tbl..l_group_id_tbl), at positions 1 to l_bulk_count(1000),
687: -- as specified in the DEFINE statements.
688: -- When the second batch is fetched in the loop, the rows go to positions 1001 to 2000; and so on.
689: v_ignore := DBMS_SQL.Fetch_Rows(v_cursorid);
690: IF v_ignore = 0 THEN
691: EXIT;
692: END IF;
693:

Line 694: DBMS_SQL.Column_Value(v_cursorid, 1, l_rowid_tbl );

690: IF v_ignore = 0 THEN
691: EXIT;
692: END IF;
693:
694: DBMS_SQL.Column_Value(v_cursorid, 1, l_rowid_tbl );
695: DBMS_SQL.Column_Value(v_cursorid, 2, l_del_detail_tbl );
696: DBMS_SQL.Column_Value(v_cursorid, 3, l_src_line_id_tbl );
697: DBMS_SQL.Column_Value(v_cursorid, 4, l_org_id_tbl );
698: DBMS_SQL.Column_Value(v_cursorid, 5, l_curr_code_tbl );

Line 695: DBMS_SQL.Column_Value(v_cursorid, 2, l_del_detail_tbl );

691: EXIT;
692: END IF;
693:
694: DBMS_SQL.Column_Value(v_cursorid, 1, l_rowid_tbl );
695: DBMS_SQL.Column_Value(v_cursorid, 2, l_del_detail_tbl );
696: DBMS_SQL.Column_Value(v_cursorid, 3, l_src_line_id_tbl );
697: DBMS_SQL.Column_Value(v_cursorid, 4, l_org_id_tbl );
698: DBMS_SQL.Column_Value(v_cursorid, 5, l_curr_code_tbl );
699: DBMS_SQL.Column_Value(v_cursorid, 6, l_customer_id_tbl );

Line 696: DBMS_SQL.Column_Value(v_cursorid, 3, l_src_line_id_tbl );

692: END IF;
693:
694: DBMS_SQL.Column_Value(v_cursorid, 1, l_rowid_tbl );
695: DBMS_SQL.Column_Value(v_cursorid, 2, l_del_detail_tbl );
696: DBMS_SQL.Column_Value(v_cursorid, 3, l_src_line_id_tbl );
697: DBMS_SQL.Column_Value(v_cursorid, 4, l_org_id_tbl );
698: DBMS_SQL.Column_Value(v_cursorid, 5, l_curr_code_tbl );
699: DBMS_SQL.Column_Value(v_cursorid, 6, l_customer_id_tbl );
700: DBMS_SQL.Column_Value(v_cursorid, 7, l_organization_id_tbl );

Line 697: DBMS_SQL.Column_Value(v_cursorid, 4, l_org_id_tbl );

693:
694: DBMS_SQL.Column_Value(v_cursorid, 1, l_rowid_tbl );
695: DBMS_SQL.Column_Value(v_cursorid, 2, l_del_detail_tbl );
696: DBMS_SQL.Column_Value(v_cursorid, 3, l_src_line_id_tbl );
697: DBMS_SQL.Column_Value(v_cursorid, 4, l_org_id_tbl );
698: DBMS_SQL.Column_Value(v_cursorid, 5, l_curr_code_tbl );
699: DBMS_SQL.Column_Value(v_cursorid, 6, l_customer_id_tbl );
700: DBMS_SQL.Column_Value(v_cursorid, 7, l_organization_id_tbl );
701: DBMS_SQL.Column_Value(v_cursorid, 8, l_ship_from_loc_tbl );

Line 698: DBMS_SQL.Column_Value(v_cursorid, 5, l_curr_code_tbl );

694: DBMS_SQL.Column_Value(v_cursorid, 1, l_rowid_tbl );
695: DBMS_SQL.Column_Value(v_cursorid, 2, l_del_detail_tbl );
696: DBMS_SQL.Column_Value(v_cursorid, 3, l_src_line_id_tbl );
697: DBMS_SQL.Column_Value(v_cursorid, 4, l_org_id_tbl );
698: DBMS_SQL.Column_Value(v_cursorid, 5, l_curr_code_tbl );
699: DBMS_SQL.Column_Value(v_cursorid, 6, l_customer_id_tbl );
700: DBMS_SQL.Column_Value(v_cursorid, 7, l_organization_id_tbl );
701: DBMS_SQL.Column_Value(v_cursorid, 8, l_ship_from_loc_tbl );
702: DBMS_SQL.Column_Value(v_cursorid, 9, l_ship_to_site_tbl );

Line 699: DBMS_SQL.Column_Value(v_cursorid, 6, l_customer_id_tbl );

695: DBMS_SQL.Column_Value(v_cursorid, 2, l_del_detail_tbl );
696: DBMS_SQL.Column_Value(v_cursorid, 3, l_src_line_id_tbl );
697: DBMS_SQL.Column_Value(v_cursorid, 4, l_org_id_tbl );
698: DBMS_SQL.Column_Value(v_cursorid, 5, l_curr_code_tbl );
699: DBMS_SQL.Column_Value(v_cursorid, 6, l_customer_id_tbl );
700: DBMS_SQL.Column_Value(v_cursorid, 7, l_organization_id_tbl );
701: DBMS_SQL.Column_Value(v_cursorid, 8, l_ship_from_loc_tbl );
702: DBMS_SQL.Column_Value(v_cursorid, 9, l_ship_to_site_tbl );
703: DBMS_SQL.Column_Value(v_cursorid, 10, l_invoice_to_site_tbl );

Line 700: DBMS_SQL.Column_Value(v_cursorid, 7, l_organization_id_tbl );

696: DBMS_SQL.Column_Value(v_cursorid, 3, l_src_line_id_tbl );
697: DBMS_SQL.Column_Value(v_cursorid, 4, l_org_id_tbl );
698: DBMS_SQL.Column_Value(v_cursorid, 5, l_curr_code_tbl );
699: DBMS_SQL.Column_Value(v_cursorid, 6, l_customer_id_tbl );
700: DBMS_SQL.Column_Value(v_cursorid, 7, l_organization_id_tbl );
701: DBMS_SQL.Column_Value(v_cursorid, 8, l_ship_from_loc_tbl );
702: DBMS_SQL.Column_Value(v_cursorid, 9, l_ship_to_site_tbl );
703: DBMS_SQL.Column_Value(v_cursorid, 10, l_invoice_to_site_tbl );
704: DBMS_SQL.Column_Value(v_cursorid, 11, l_deliver_to_site_tbl );

Line 701: DBMS_SQL.Column_Value(v_cursorid, 8, l_ship_from_loc_tbl );

697: DBMS_SQL.Column_Value(v_cursorid, 4, l_org_id_tbl );
698: DBMS_SQL.Column_Value(v_cursorid, 5, l_curr_code_tbl );
699: DBMS_SQL.Column_Value(v_cursorid, 6, l_customer_id_tbl );
700: DBMS_SQL.Column_Value(v_cursorid, 7, l_organization_id_tbl );
701: DBMS_SQL.Column_Value(v_cursorid, 8, l_ship_from_loc_tbl );
702: DBMS_SQL.Column_Value(v_cursorid, 9, l_ship_to_site_tbl );
703: DBMS_SQL.Column_Value(v_cursorid, 10, l_invoice_to_site_tbl );
704: DBMS_SQL.Column_Value(v_cursorid, 11, l_deliver_to_site_tbl );
705: DBMS_SQL.Column_Value(v_cursorid, 12, l_ship_to_con_tbl );

Line 702: DBMS_SQL.Column_Value(v_cursorid, 9, l_ship_to_site_tbl );

698: DBMS_SQL.Column_Value(v_cursorid, 5, l_curr_code_tbl );
699: DBMS_SQL.Column_Value(v_cursorid, 6, l_customer_id_tbl );
700: DBMS_SQL.Column_Value(v_cursorid, 7, l_organization_id_tbl );
701: DBMS_SQL.Column_Value(v_cursorid, 8, l_ship_from_loc_tbl );
702: DBMS_SQL.Column_Value(v_cursorid, 9, l_ship_to_site_tbl );
703: DBMS_SQL.Column_Value(v_cursorid, 10, l_invoice_to_site_tbl );
704: DBMS_SQL.Column_Value(v_cursorid, 11, l_deliver_to_site_tbl );
705: DBMS_SQL.Column_Value(v_cursorid, 12, l_ship_to_con_tbl );
706: DBMS_SQL.Column_Value(v_cursorid, 13, l_invoice_to_con_tbl );

Line 703: DBMS_SQL.Column_Value(v_cursorid, 10, l_invoice_to_site_tbl );

699: DBMS_SQL.Column_Value(v_cursorid, 6, l_customer_id_tbl );
700: DBMS_SQL.Column_Value(v_cursorid, 7, l_organization_id_tbl );
701: DBMS_SQL.Column_Value(v_cursorid, 8, l_ship_from_loc_tbl );
702: DBMS_SQL.Column_Value(v_cursorid, 9, l_ship_to_site_tbl );
703: DBMS_SQL.Column_Value(v_cursorid, 10, l_invoice_to_site_tbl );
704: DBMS_SQL.Column_Value(v_cursorid, 11, l_deliver_to_site_tbl );
705: DBMS_SQL.Column_Value(v_cursorid, 12, l_ship_to_con_tbl );
706: DBMS_SQL.Column_Value(v_cursorid, 13, l_invoice_to_con_tbl );
707: DBMS_SQL.Column_Value(v_cursorid, 14, l_deliver_to_con_tbl );

Line 704: DBMS_SQL.Column_Value(v_cursorid, 11, l_deliver_to_site_tbl );

700: DBMS_SQL.Column_Value(v_cursorid, 7, l_organization_id_tbl );
701: DBMS_SQL.Column_Value(v_cursorid, 8, l_ship_from_loc_tbl );
702: DBMS_SQL.Column_Value(v_cursorid, 9, l_ship_to_site_tbl );
703: DBMS_SQL.Column_Value(v_cursorid, 10, l_invoice_to_site_tbl );
704: DBMS_SQL.Column_Value(v_cursorid, 11, l_deliver_to_site_tbl );
705: DBMS_SQL.Column_Value(v_cursorid, 12, l_ship_to_con_tbl );
706: DBMS_SQL.Column_Value(v_cursorid, 13, l_invoice_to_con_tbl );
707: DBMS_SQL.Column_Value(v_cursorid, 14, l_deliver_to_con_tbl );
708: DBMS_SQL.Column_Value(v_cursorid, 15, l_ship_method_tbl );

Line 705: DBMS_SQL.Column_Value(v_cursorid, 12, l_ship_to_con_tbl );

701: DBMS_SQL.Column_Value(v_cursorid, 8, l_ship_from_loc_tbl );
702: DBMS_SQL.Column_Value(v_cursorid, 9, l_ship_to_site_tbl );
703: DBMS_SQL.Column_Value(v_cursorid, 10, l_invoice_to_site_tbl );
704: DBMS_SQL.Column_Value(v_cursorid, 11, l_deliver_to_site_tbl );
705: DBMS_SQL.Column_Value(v_cursorid, 12, l_ship_to_con_tbl );
706: DBMS_SQL.Column_Value(v_cursorid, 13, l_invoice_to_con_tbl );
707: DBMS_SQL.Column_Value(v_cursorid, 14, l_deliver_to_con_tbl );
708: DBMS_SQL.Column_Value(v_cursorid, 15, l_ship_method_tbl );
709: DBMS_SQL.Column_Value(v_cursorid, 16, l_freight_terms_tbl );

Line 706: DBMS_SQL.Column_Value(v_cursorid, 13, l_invoice_to_con_tbl );

702: DBMS_SQL.Column_Value(v_cursorid, 9, l_ship_to_site_tbl );
703: DBMS_SQL.Column_Value(v_cursorid, 10, l_invoice_to_site_tbl );
704: DBMS_SQL.Column_Value(v_cursorid, 11, l_deliver_to_site_tbl );
705: DBMS_SQL.Column_Value(v_cursorid, 12, l_ship_to_con_tbl );
706: DBMS_SQL.Column_Value(v_cursorid, 13, l_invoice_to_con_tbl );
707: DBMS_SQL.Column_Value(v_cursorid, 14, l_deliver_to_con_tbl );
708: DBMS_SQL.Column_Value(v_cursorid, 15, l_ship_method_tbl );
709: DBMS_SQL.Column_Value(v_cursorid, 16, l_freight_terms_tbl );
710: DBMS_SQL.Column_Value(v_cursorid, 17, l_fob_code_tbl );

Line 707: DBMS_SQL.Column_Value(v_cursorid, 14, l_deliver_to_con_tbl );

703: DBMS_SQL.Column_Value(v_cursorid, 10, l_invoice_to_site_tbl );
704: DBMS_SQL.Column_Value(v_cursorid, 11, l_deliver_to_site_tbl );
705: DBMS_SQL.Column_Value(v_cursorid, 12, l_ship_to_con_tbl );
706: DBMS_SQL.Column_Value(v_cursorid, 13, l_invoice_to_con_tbl );
707: DBMS_SQL.Column_Value(v_cursorid, 14, l_deliver_to_con_tbl );
708: DBMS_SQL.Column_Value(v_cursorid, 15, l_ship_method_tbl );
709: DBMS_SQL.Column_Value(v_cursorid, 16, l_freight_terms_tbl );
710: DBMS_SQL.Column_Value(v_cursorid, 17, l_fob_code_tbl );
711: DBMS_SQL.Column_Value(v_cursorid, 18, l_group_id_tbl );

Line 708: DBMS_SQL.Column_Value(v_cursorid, 15, l_ship_method_tbl );

704: DBMS_SQL.Column_Value(v_cursorid, 11, l_deliver_to_site_tbl );
705: DBMS_SQL.Column_Value(v_cursorid, 12, l_ship_to_con_tbl );
706: DBMS_SQL.Column_Value(v_cursorid, 13, l_invoice_to_con_tbl );
707: DBMS_SQL.Column_Value(v_cursorid, 14, l_deliver_to_con_tbl );
708: DBMS_SQL.Column_Value(v_cursorid, 15, l_ship_method_tbl );
709: DBMS_SQL.Column_Value(v_cursorid, 16, l_freight_terms_tbl );
710: DBMS_SQL.Column_Value(v_cursorid, 17, l_fob_code_tbl );
711: DBMS_SQL.Column_Value(v_cursorid, 18, l_group_id_tbl );
712:

Line 709: DBMS_SQL.Column_Value(v_cursorid, 16, l_freight_terms_tbl );

705: DBMS_SQL.Column_Value(v_cursorid, 12, l_ship_to_con_tbl );
706: DBMS_SQL.Column_Value(v_cursorid, 13, l_invoice_to_con_tbl );
707: DBMS_SQL.Column_Value(v_cursorid, 14, l_deliver_to_con_tbl );
708: DBMS_SQL.Column_Value(v_cursorid, 15, l_ship_method_tbl );
709: DBMS_SQL.Column_Value(v_cursorid, 16, l_freight_terms_tbl );
710: DBMS_SQL.Column_Value(v_cursorid, 17, l_fob_code_tbl );
711: DBMS_SQL.Column_Value(v_cursorid, 18, l_group_id_tbl );
712:
713: --

Line 710: DBMS_SQL.Column_Value(v_cursorid, 17, l_fob_code_tbl );

706: DBMS_SQL.Column_Value(v_cursorid, 13, l_invoice_to_con_tbl );
707: DBMS_SQL.Column_Value(v_cursorid, 14, l_deliver_to_con_tbl );
708: DBMS_SQL.Column_Value(v_cursorid, 15, l_ship_method_tbl );
709: DBMS_SQL.Column_Value(v_cursorid, 16, l_freight_terms_tbl );
710: DBMS_SQL.Column_Value(v_cursorid, 17, l_fob_code_tbl );
711: DBMS_SQL.Column_Value(v_cursorid, 18, l_group_id_tbl );
712:
713: --
714: IF l_debug_on THEN

Line 711: DBMS_SQL.Column_Value(v_cursorid, 18, l_group_id_tbl );

707: DBMS_SQL.Column_Value(v_cursorid, 14, l_deliver_to_con_tbl );
708: DBMS_SQL.Column_Value(v_cursorid, 15, l_ship_method_tbl );
709: DBMS_SQL.Column_Value(v_cursorid, 16, l_freight_terms_tbl );
710: DBMS_SQL.Column_Value(v_cursorid, 17, l_fob_code_tbl );
711: DBMS_SQL.Column_Value(v_cursorid, 18, l_group_id_tbl );
712:
713: --
714: IF l_debug_on THEN
715: WSH_DEBUG_SV.log(l_module_name, 'Fetched successfully', v_ignore);

Line 1018: IF DBMS_SQL.Is_Open(v_cursorid) THEN

1014: END LOOP;
1015: --} Loop for fetching records - Ends
1016:
1017: -- Closing Dynamic Cursor
1018: IF DBMS_SQL.Is_Open(v_cursorid) THEN
1019: --
1020: IF l_debug_on THEN
1021: WSH_DEBUG_SV.logmsg(l_module_name, 'Closing cursor');
1022: END IF;

Line 1024: DBMS_SQL.Close_Cursor(v_cursorid);

1020: IF l_debug_on THEN
1021: WSH_DEBUG_SV.logmsg(l_module_name, 'Closing cursor');
1022: END IF;
1023: --
1024: DBMS_SQL.Close_Cursor(v_cursorid);
1025: v_cursorid := null;
1026: END IF;
1027:
1028: --