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

Line 344: v_CursorID := DBMS_SQL.Open_Cursor;

340: -- i := i + WSH_UTIL_CORE.G_MAX_LENGTH;
341: END LOOP;
342: END IF;
343:
344: v_CursorID := DBMS_SQL.Open_Cursor;
345:
346: DBMS_SQL.Parse(v_CursorID, l_sc_FINAL, DBMS_SQL.v7 );
347:
348: DBMS_SQL.Define_Column(v_CursorID, 1, v_delivery_id);

Line 346: DBMS_SQL.Parse(v_CursorID, l_sc_FINAL, DBMS_SQL.v7 );

342: END IF;
343:
344: v_CursorID := DBMS_SQL.Open_Cursor;
345:
346: DBMS_SQL.Parse(v_CursorID, l_sc_FINAL, DBMS_SQL.v7 );
347:
348: DBMS_SQL.Define_Column(v_CursorID, 1, v_delivery_id);
349: DBMS_SQL.Define_Column(v_CursorID, 2, v_organization_id);
350: DBMS_SQL.Define_Column(v_CursorID, 3, v_initial_pickup_location_id);

Line 348: DBMS_SQL.Define_Column(v_CursorID, 1, v_delivery_id);

344: v_CursorID := DBMS_SQL.Open_Cursor;
345:
346: DBMS_SQL.Parse(v_CursorID, l_sc_FINAL, DBMS_SQL.v7 );
347:
348: DBMS_SQL.Define_Column(v_CursorID, 1, v_delivery_id);
349: DBMS_SQL.Define_Column(v_CursorID, 2, v_organization_id);
350: DBMS_SQL.Define_Column(v_CursorID, 3, v_initial_pickup_location_id);
351:
352: /* Modified R12.1.1 LSP PROJECT*/

Line 349: DBMS_SQL.Define_Column(v_CursorID, 2, v_organization_id);

345:
346: DBMS_SQL.Parse(v_CursorID, l_sc_FINAL, DBMS_SQL.v7 );
347:
348: DBMS_SQL.Define_Column(v_CursorID, 1, v_delivery_id);
349: DBMS_SQL.Define_Column(v_CursorID, 2, v_organization_id);
350: DBMS_SQL.Define_Column(v_CursorID, 3, v_initial_pickup_location_id);
351:
352: /* Modified R12.1.1 LSP PROJECT*/
353: IF p_input_info.client_id IS NOT NULL THEN

Line 350: DBMS_SQL.Define_Column(v_CursorID, 3, v_initial_pickup_location_id);

346: DBMS_SQL.Parse(v_CursorID, l_sc_FINAL, DBMS_SQL.v7 );
347:
348: DBMS_SQL.Define_Column(v_CursorID, 1, v_delivery_id);
349: DBMS_SQL.Define_Column(v_CursorID, 2, v_organization_id);
350: DBMS_SQL.Define_Column(v_CursorID, 3, v_initial_pickup_location_id);
351:
352: /* Modified R12.1.1 LSP PROJECT*/
353: IF p_input_info.client_id IS NOT NULL THEN
354: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_client_id', p_input_info.client_id); --Modified R12.1.1 LSP PROJECT

Line 354: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_client_id', p_input_info.client_id); --Modified R12.1.1 LSP PROJECT

350: DBMS_SQL.Define_Column(v_CursorID, 3, v_initial_pickup_location_id);
351:
352: /* Modified R12.1.1 LSP PROJECT*/
353: IF p_input_info.client_id IS NOT NULL THEN
354: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_client_id', p_input_info.client_id); --Modified R12.1.1 LSP PROJECT
355: END IF;
356: /* Modified R12.1.1 LSP PROJECT*/
357:
358: IF p_input_info.organization_id IS NOT NULL THEN

Line 359: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_organization_id', p_input_info.organization_id);

355: END IF;
356: /* Modified R12.1.1 LSP PROJECT*/
357:
358: IF p_input_info.organization_id IS NOT NULL THEN
359: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_organization_id', p_input_info.organization_id);
360: END IF;
361:
362: IF p_input_info.pr_batch_id IS NOT NULL THEN
363: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_pr_batch_id', p_input_info.pr_batch_id);

Line 363: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_pr_batch_id', p_input_info.pr_batch_id);

359: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_organization_id', p_input_info.organization_id);
360: END IF;
361:
362: IF p_input_info.pr_batch_id IS NOT NULL THEN
363: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_pr_batch_id', p_input_info.pr_batch_id);
364: END IF;
365:
366: IF p_input_info.ap_batch_id IS NOT NULL THEN
367: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ap_batch_id', p_input_info.ap_batch_id);

Line 367: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ap_batch_id', p_input_info.ap_batch_id);

363: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_pr_batch_id', p_input_info.pr_batch_id);
364: END IF;
365:
366: IF p_input_info.ap_batch_id IS NOT NULL THEN
367: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ap_batch_id', p_input_info.ap_batch_id);
368: END IF;
369:
370: IF p_input_info.delivery_name_lo IS NOT NULL THEN
371: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_delivery_name_lo', p_input_info.delivery_name_lo);

Line 371: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_delivery_name_lo', p_input_info.delivery_name_lo);

367: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ap_batch_id', p_input_info.ap_batch_id);
368: END IF;
369:
370: IF p_input_info.delivery_name_lo IS NOT NULL THEN
371: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_delivery_name_lo', p_input_info.delivery_name_lo);
372: END IF;
373:
374: IF p_input_info.delivery_name_hi IS NOT NULL THEN
375: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_delivery_name_hi', p_input_info.delivery_name_hi);

Line 375: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_delivery_name_hi', p_input_info.delivery_name_hi);

371: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_delivery_name_lo', p_input_info.delivery_name_lo);
372: END IF;
373:
374: IF p_input_info.delivery_name_hi IS NOT NULL THEN
375: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_delivery_name_hi', p_input_info.delivery_name_hi);
376: END IF;
377:
378:
379: IF p_input_info.bol_number_lo IS NOT NULL THEN

Line 380: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_bol_number_lo', p_input_info.bol_number_lo) ;

376: END IF;
377:
378:
379: IF p_input_info.bol_number_lo IS NOT NULL THEN
380: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_bol_number_lo', p_input_info.bol_number_lo) ;
381: END IF;
382:
383: IF p_input_info.bol_number_hi IS NOT NULL THEN
384: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_bol_number_hi', p_input_info.bol_number_hi);

Line 384: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_bol_number_hi', p_input_info.bol_number_hi);

380: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_bol_number_lo', p_input_info.bol_number_lo) ;
381: END IF;
382:
383: IF p_input_info.bol_number_hi IS NOT NULL THEN
384: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_bol_number_hi', p_input_info.bol_number_hi);
385: END IF;
386:
387:
388: IF p_input_info.planned_flag IS NOT NULL THEN

Line 389: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_planned_flag', p_input_info.planned_flag);

385: END IF;
386:
387:
388: IF p_input_info.planned_flag IS NOT NULL THEN
389: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_planned_flag', p_input_info.planned_flag);
390: END IF;
391:
392: IF p_input_info.ship_from_loc_id IS NOT NULL THEN
393: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_from_loc_id', p_input_info.ship_from_loc_id);

Line 393: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_from_loc_id', p_input_info.ship_from_loc_id);

389: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_planned_flag', p_input_info.planned_flag);
390: END IF;
391:
392: IF p_input_info.ship_from_loc_id IS NOT NULL THEN
393: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_from_loc_id', p_input_info.ship_from_loc_id);
394: END IF;
395:
396: IF p_input_info.ship_to_loc_id IS NOT NULL THEN
397: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_to_loc_id', p_input_info.ship_to_loc_id);

Line 397: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_to_loc_id', p_input_info.ship_to_loc_id);

393: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_from_loc_id', p_input_info.ship_from_loc_id);
394: END IF;
395:
396: IF p_input_info.ship_to_loc_id IS NOT NULL THEN
397: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_to_loc_id', p_input_info.ship_to_loc_id);
398: END IF;
399:
400: IF p_input_info.intmed_ship_to_loc_id IS NOT NULL THEN
401: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_intmed_ship_to_loc_id', p_input_info.intmed_ship_to_loc_id);

Line 401: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_intmed_ship_to_loc_id', p_input_info.intmed_ship_to_loc_id);

397: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_to_loc_id', p_input_info.ship_to_loc_id);
398: END IF;
399:
400: IF p_input_info.intmed_ship_to_loc_id IS NOT NULL THEN
401: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_intmed_ship_to_loc_id', p_input_info.intmed_ship_to_loc_id);
402: END IF;
403:
404: IF p_input_info.pooled_ship_to_loc_id IS NOT NULL THEN
405: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_pooled_ship_to_loc_id', p_input_info.pooled_ship_to_loc_id);

Line 405: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_pooled_ship_to_loc_id', p_input_info.pooled_ship_to_loc_id);

401: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_intmed_ship_to_loc_id', p_input_info.intmed_ship_to_loc_id);
402: END IF;
403:
404: IF p_input_info.pooled_ship_to_loc_id IS NOT NULL THEN
405: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_pooled_ship_to_loc_id', p_input_info.pooled_ship_to_loc_id);
406: END IF;
407:
408: IF p_input_info.customer_id IS NOT NULL THEN
409: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_customer_id', to_number(substr(p_input_info.customer_id,3))); --RTV changes

Line 409: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_customer_id', to_number(substr(p_input_info.customer_id,3))); --RTV changes

405: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_pooled_ship_to_loc_id', p_input_info.pooled_ship_to_loc_id);
406: END IF;
407:
408: IF p_input_info.customer_id IS NOT NULL THEN
409: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_customer_id', to_number(substr(p_input_info.customer_id,3))); --RTV changes
410: END IF;
411:
412: IF p_input_info.ship_method_code IS NOT NULL THEN
413: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_method_code', p_input_info.ship_method_code);

Line 413: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_method_code', p_input_info.ship_method_code);

409: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_customer_id', to_number(substr(p_input_info.customer_id,3))); --RTV changes
410: END IF;
411:
412: IF p_input_info.ship_method_code IS NOT NULL THEN
413: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_method_code', p_input_info.ship_method_code);
414: END IF;
415:
416: IF p_input_info.fob_code IS NOT NULL THEN
417: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_fob_code', p_input_info.fob_code);

Line 417: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_fob_code', p_input_info.fob_code);

413: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_method_code', p_input_info.ship_method_code);
414: END IF;
415:
416: IF p_input_info.fob_code IS NOT NULL THEN
417: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_fob_code', p_input_info.fob_code);
418: END IF;
419:
420: IF p_input_info.freight_terms_code IS NOT NULL THEN
421: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_freight_terms_code', p_input_info.freight_terms_code);

Line 421: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_freight_terms_code', p_input_info.freight_terms_code);

417: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_fob_code', p_input_info.fob_code);
418: END IF;
419:
420: IF p_input_info.freight_terms_code IS NOT NULL THEN
421: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_freight_terms_code', p_input_info.freight_terms_code);
422: END IF;
423:
424: IF p_input_info.pickup_date_lo IS NOT NULL THEN
425: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_pickup_date_lo', l_pickup_date_lo);

Line 425: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_pickup_date_lo', l_pickup_date_lo);

421: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_freight_terms_code', p_input_info.freight_terms_code);
422: END IF;
423:
424: IF p_input_info.pickup_date_lo IS NOT NULL THEN
425: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_pickup_date_lo', l_pickup_date_lo);
426: END IF;
427:
428: IF p_input_info.pickup_date_hi IS NOT NULL THEN
429: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_pickup_date_hi', l_pickup_date_hi);

Line 429: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_pickup_date_hi', l_pickup_date_hi);

425: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_pickup_date_lo', l_pickup_date_lo);
426: END IF;
427:
428: IF p_input_info.pickup_date_hi IS NOT NULL THEN
429: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_pickup_date_hi', l_pickup_date_hi);
430: END IF;
431:
432: IF p_input_info.dropoff_date_lo IS NOT NULL THEN
433: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_dropoff_date_lo', l_dropoff_date_lo);

Line 433: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_dropoff_date_lo', l_dropoff_date_lo);

429: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_pickup_date_hi', l_pickup_date_hi);
430: END IF;
431:
432: IF p_input_info.dropoff_date_lo IS NOT NULL THEN
433: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_dropoff_date_lo', l_dropoff_date_lo);
434: END IF;
435:
436: IF p_input_info.dropoff_date_hi IS NOT NULL THEN
437: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_dropoff_date_hi', l_dropoff_date_hi);

Line 437: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_dropoff_date_hi', l_dropoff_date_hi);

433: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_dropoff_date_lo', l_dropoff_date_lo);
434: END IF;
435:
436: IF p_input_info.dropoff_date_hi IS NOT NULL THEN
437: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_dropoff_date_hi', l_dropoff_date_hi);
438: END IF;
439:
440: v_ignore := DBMS_SQL.Execute(v_CursorID);
441:

Line 440: v_ignore := DBMS_SQL.Execute(v_CursorID);

436: IF p_input_info.dropoff_date_hi IS NOT NULL THEN
437: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_dropoff_date_hi', l_dropoff_date_hi);
438: END IF;
439:
440: v_ignore := DBMS_SQL.Execute(v_CursorID);
441:
442: LOOP
443: IF DBMS_SQL.Fetch_Rows(v_cursorID) = 0 THEN
444: DBMS_SQL.Close_Cursor(v_cursorID);

Line 443: IF DBMS_SQL.Fetch_Rows(v_cursorID) = 0 THEN

439:
440: v_ignore := DBMS_SQL.Execute(v_CursorID);
441:
442: LOOP
443: IF DBMS_SQL.Fetch_Rows(v_cursorID) = 0 THEN
444: DBMS_SQL.Close_Cursor(v_cursorID);
445: EXIT;
446: ELSE
447: DBMS_SQL.Column_Value(v_CursorID, 1, v_delivery_id);

Line 444: DBMS_SQL.Close_Cursor(v_cursorID);

440: v_ignore := DBMS_SQL.Execute(v_CursorID);
441:
442: LOOP
443: IF DBMS_SQL.Fetch_Rows(v_cursorID) = 0 THEN
444: DBMS_SQL.Close_Cursor(v_cursorID);
445: EXIT;
446: ELSE
447: DBMS_SQL.Column_Value(v_CursorID, 1, v_delivery_id);
448: DBMS_SQL.Column_Value(v_CursorID, 2, v_organization_id);

Line 447: DBMS_SQL.Column_Value(v_CursorID, 1, v_delivery_id);

443: IF DBMS_SQL.Fetch_Rows(v_cursorID) = 0 THEN
444: DBMS_SQL.Close_Cursor(v_cursorID);
445: EXIT;
446: ELSE
447: DBMS_SQL.Column_Value(v_CursorID, 1, v_delivery_id);
448: DBMS_SQL.Column_Value(v_CursorID, 2, v_organization_id);
449: DBMS_SQL.Column_Value(v_CursorID, 3, v_initial_pickup_location_id);
450: x_selected_del_tab(x_selected_del_tab.count+1).delivery_id := v_delivery_id;
451: x_selected_del_tab(x_selected_del_tab.count).organization_id := v_organization_id;

Line 448: DBMS_SQL.Column_Value(v_CursorID, 2, v_organization_id);

444: DBMS_SQL.Close_Cursor(v_cursorID);
445: EXIT;
446: ELSE
447: DBMS_SQL.Column_Value(v_CursorID, 1, v_delivery_id);
448: DBMS_SQL.Column_Value(v_CursorID, 2, v_organization_id);
449: DBMS_SQL.Column_Value(v_CursorID, 3, v_initial_pickup_location_id);
450: x_selected_del_tab(x_selected_del_tab.count+1).delivery_id := v_delivery_id;
451: x_selected_del_tab(x_selected_del_tab.count).organization_id := v_organization_id;
452: x_selected_del_tab(x_selected_del_tab.count).initial_pickup_location_id := v_initial_pickup_location_id;

Line 449: DBMS_SQL.Column_Value(v_CursorID, 3, v_initial_pickup_location_id);

445: EXIT;
446: ELSE
447: DBMS_SQL.Column_Value(v_CursorID, 1, v_delivery_id);
448: DBMS_SQL.Column_Value(v_CursorID, 2, v_organization_id);
449: DBMS_SQL.Column_Value(v_CursorID, 3, v_initial_pickup_location_id);
450: x_selected_del_tab(x_selected_del_tab.count+1).delivery_id := v_delivery_id;
451: x_selected_del_tab(x_selected_del_tab.count).organization_id := v_organization_id;
452: x_selected_del_tab(x_selected_del_tab.count).initial_pickup_location_id := v_initial_pickup_location_id;
453:

Line 2928: v_delivery_detail_id_tbl DBMS_SQL.NUMBER_TABLE;

2924: l_debug_on BOOLEAN;
2925: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Select_Delivery_Lines';
2926:
2927: --Perf bug 5218515
2928: v_delivery_detail_id_tbl DBMS_SQL.NUMBER_TABLE;
2929: l_fetch_count NUMBER := 1000;
2930: l_start_index NUMBER := 1;
2931: l_records_fetched NUMBER := 0;
2932: --

Line 3214: v_CursorID := DBMS_SQL.Open_Cursor;

3210: WSH_DEBUG_SV.logmsg(l_module_name,'========================');
3211: END IF;
3212:
3213: -- open cursor
3214: v_CursorID := DBMS_SQL.Open_Cursor;
3215:
3216: -- parse cursor
3217: DBMS_SQL.Parse(v_CursorID, l_sc_FINAL, DBMS_SQL.v7 );
3218:

Line 3217: DBMS_SQL.Parse(v_CursorID, l_sc_FINAL, DBMS_SQL.v7 );

3213: -- open cursor
3214: v_CursorID := DBMS_SQL.Open_Cursor;
3215:
3216: -- parse cursor
3217: DBMS_SQL.Parse(v_CursorID, l_sc_FINAL, DBMS_SQL.v7 );
3218:
3219:
3220: -- define column
3221: --Perf bug 5218515

Line 3222: DBMS_SQL.Define_Array(v_CursorID, 1, v_delivery_detail_id_tbl ,l_fetch_count ,l_start_index);

3218:
3219:
3220: -- define column
3221: --Perf bug 5218515
3222: DBMS_SQL.Define_Array(v_CursorID, 1, v_delivery_detail_id_tbl ,l_fetch_count ,l_start_index);
3223:
3224: --
3225: -- Bug 5624475 and ECO 5676263
3226: IF p_select_criteria.delivery_lines_status IN ('K', 'S') THEN

Line 3240: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_released_status', l_line_status); -- Bug 5624475 and ECO 5676263

3236: END IF;
3237: --
3238: IF p_select_criteria.delivery_lines_status IS NOT NULL AND
3239: p_select_criteria.delivery_lines_status <> 'ALL' THEN
3240: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_released_status', l_line_status); -- Bug 5624475 and ECO 5676263
3241: END IF;
3242:
3243: -- bind the variables for organization id
3244: IF p_select_criteria.organization_id IS NOT NULL THEN

Line 3245: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_organization_id', p_select_criteria.organization_id);

3241: END IF;
3242:
3243: -- bind the variables for organization id
3244: IF p_select_criteria.organization_id IS NOT NULL THEN
3245: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_organization_id', p_select_criteria.organization_id);
3246: END IF;
3247:
3248: IF p_select_criteria.scheduled_ship_date_lo IS NOT NULL THEN
3249: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_scheduled_ship_date_lo', l_scheduled_ship_date_lo);

Line 3249: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_scheduled_ship_date_lo', l_scheduled_ship_date_lo);

3245: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_organization_id', p_select_criteria.organization_id);
3246: END IF;
3247:
3248: IF p_select_criteria.scheduled_ship_date_lo IS NOT NULL THEN
3249: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_scheduled_ship_date_lo', l_scheduled_ship_date_lo);
3250: END IF;
3251:
3252: IF p_select_criteria.scheduled_ship_date_hi IS NOT NULL THEN
3253: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_scheduled_ship_date_hi', l_scheduled_ship_date_hi);

Line 3253: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_scheduled_ship_date_hi', l_scheduled_ship_date_hi);

3249: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_scheduled_ship_date_lo', l_scheduled_ship_date_lo);
3250: END IF;
3251:
3252: IF p_select_criteria.scheduled_ship_date_hi IS NOT NULL THEN
3253: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_scheduled_ship_date_hi', l_scheduled_ship_date_hi);
3254: END IF;
3255:
3256: IF p_select_criteria.source_code IS NOT NULL
3257: AND p_select_criteria.source_code <> 'ALL' THEN

Line 3258: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_source_code', p_select_criteria.source_code);

3254: END IF;
3255:
3256: IF p_select_criteria.source_code IS NOT NULL
3257: AND p_select_criteria.source_code <> 'ALL' THEN
3258: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_source_code', p_select_criteria.source_code);
3259: END IF;
3260:
3261: IF p_select_criteria.ship_to_loc_id IS NOT NULL THEN
3262: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_to_loc_id', p_select_criteria.ship_to_loc_id);

Line 3262: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_to_loc_id', p_select_criteria.ship_to_loc_id);

3258: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_source_code', p_select_criteria.source_code);
3259: END IF;
3260:
3261: IF p_select_criteria.ship_to_loc_id IS NOT NULL THEN
3262: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_to_loc_id', p_select_criteria.ship_to_loc_id);
3263: END IF;
3264:
3265: IF p_select_criteria.customer_id IS NOT NULL THEN
3266: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_customer_id', to_number(SubStr(p_select_criteria.customer_id,3))); -- RTV changes

Line 3266: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_customer_id', to_number(SubStr(p_select_criteria.customer_id,3))); -- RTV changes

3262: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_to_loc_id', p_select_criteria.ship_to_loc_id);
3263: END IF;
3264:
3265: IF p_select_criteria.customer_id IS NOT NULL THEN
3266: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_customer_id', to_number(SubStr(p_select_criteria.customer_id,3))); -- RTV changes
3267: END IF;
3268:
3269: IF p_select_criteria.ship_method_code IS NOT NULL THEN
3270: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_method_code', p_select_criteria.ship_method_code);

Line 3270: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_method_code', p_select_criteria.ship_method_code);

3266: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_customer_id', to_number(SubStr(p_select_criteria.customer_id,3))); -- RTV changes
3267: END IF;
3268:
3269: IF p_select_criteria.ship_method_code IS NOT NULL THEN
3270: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_method_code', p_select_criteria.ship_method_code);
3271: END IF;
3272:
3273: -- LSP PROJECT : begin
3274: IF p_select_criteria.client_id IS NOT NULL THEN

Line 3275: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_client_id', p_select_criteria.client_id);

3271: END IF;
3272:
3273: -- LSP PROJECT : begin
3274: IF p_select_criteria.client_id IS NOT NULL THEN
3275: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_client_id', p_select_criteria.client_id);
3276: END IF;
3277: -- LSP PROJECT : end
3278:
3279: -- execute the cursor

Line 3280: v_ignore := DBMS_SQL.Execute(v_CursorID);

3276: END IF;
3277: -- LSP PROJECT : end
3278:
3279: -- execute the cursor
3280: v_ignore := DBMS_SQL.Execute(v_CursorID);
3281:
3282: -- fetching the rows in bulk.
3283: --Perf bug 5218515
3284: Loop

Line 3285: l_records_fetched := dbms_sql.fetch_rows(v_CursorID) ;

3281:
3282: -- fetching the rows in bulk.
3283: --Perf bug 5218515
3284: Loop
3285: l_records_fetched := dbms_sql.fetch_rows(v_CursorID) ;
3286: dbms_sql.column_value(v_CursorID,1,v_delivery_detail_id_tbl);
3287: IF l_debug_on THEN
3288: WSH_DEBUG_SV.logmsg(l_module_name,' Records Fetched in this pass '|| l_records_fetched);
3289: WSH_DEBUG_SV.logmsg(l_module_name,' l_fetch_count '|| l_fetch_count);

Line 3286: dbms_sql.column_value(v_CursorID,1,v_delivery_detail_id_tbl);

3282: -- fetching the rows in bulk.
3283: --Perf bug 5218515
3284: Loop
3285: l_records_fetched := dbms_sql.fetch_rows(v_CursorID) ;
3286: dbms_sql.column_value(v_CursorID,1,v_delivery_detail_id_tbl);
3287: IF l_debug_on THEN
3288: WSH_DEBUG_SV.logmsg(l_module_name,' Records Fetched in this pass '|| l_records_fetched);
3289: WSH_DEBUG_SV.logmsg(l_module_name,' l_fetch_count '|| l_fetch_count);
3290: WSH_DEBUG_SV.logmsg(l_module_name,' Record count in v_delivery_detail_id_tbl '||

Line 3311: DBMS_SQL.Close_Cursor(v_cursorID);

3307: If l_debug_on THEN
3308: WSH_DEBUG_SV.logmsg(l_module_name,' Before closing cursor = '||v_cursorID );
3309: End If;
3310:
3311: DBMS_SQL.Close_Cursor(v_cursorID);
3312:
3313: If l_debug_on THEN
3314: WSH_DEBUG_SV.logmsg(l_module_name,' After closing cursor = '||v_cursorID );
3315: End If;

Line 3330: DBMS_SQL.Close_Cursor(v_cursorID);

3326:
3327: WHEN others THEN
3328: -- if the cursor is still open then close the cursor
3329: IF v_cursorID <> 0 THEN
3330: DBMS_SQL.Close_Cursor(v_cursorID);
3331: END IF;
3332: wsh_util_core.default_handler('WSH_BATCH_PROCESS.Select_Deliveries');
3333: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3334: IF l_debug_on THEN