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 326: v_CursorID := DBMS_SQL.Open_Cursor;

322: -- i := i + WSH_UTIL_CORE.G_MAX_LENGTH;
323: END LOOP;
324: END IF;
325:
326: v_CursorID := DBMS_SQL.Open_Cursor;
327:
328: DBMS_SQL.Parse(v_CursorID, l_sc_FINAL, DBMS_SQL.v7 );
329:
330: DBMS_SQL.Define_Column(v_CursorID, 1, v_delivery_id);

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

324: END IF;
325:
326: v_CursorID := DBMS_SQL.Open_Cursor;
327:
328: DBMS_SQL.Parse(v_CursorID, l_sc_FINAL, DBMS_SQL.v7 );
329:
330: DBMS_SQL.Define_Column(v_CursorID, 1, v_delivery_id);
331: DBMS_SQL.Define_Column(v_CursorID, 2, v_organization_id);
332: DBMS_SQL.Define_Column(v_CursorID, 3, v_initial_pickup_location_id);

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

326: v_CursorID := DBMS_SQL.Open_Cursor;
327:
328: DBMS_SQL.Parse(v_CursorID, l_sc_FINAL, DBMS_SQL.v7 );
329:
330: DBMS_SQL.Define_Column(v_CursorID, 1, v_delivery_id);
331: DBMS_SQL.Define_Column(v_CursorID, 2, v_organization_id);
332: DBMS_SQL.Define_Column(v_CursorID, 3, v_initial_pickup_location_id);
333:
334: IF p_input_info.organization_id IS NOT NULL THEN

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

327:
328: DBMS_SQL.Parse(v_CursorID, l_sc_FINAL, DBMS_SQL.v7 );
329:
330: DBMS_SQL.Define_Column(v_CursorID, 1, v_delivery_id);
331: DBMS_SQL.Define_Column(v_CursorID, 2, v_organization_id);
332: DBMS_SQL.Define_Column(v_CursorID, 3, v_initial_pickup_location_id);
333:
334: IF p_input_info.organization_id IS NOT NULL THEN
335: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_organization_id', p_input_info.organization_id);

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

328: DBMS_SQL.Parse(v_CursorID, l_sc_FINAL, DBMS_SQL.v7 );
329:
330: DBMS_SQL.Define_Column(v_CursorID, 1, v_delivery_id);
331: DBMS_SQL.Define_Column(v_CursorID, 2, v_organization_id);
332: DBMS_SQL.Define_Column(v_CursorID, 3, v_initial_pickup_location_id);
333:
334: IF p_input_info.organization_id IS NOT NULL THEN
335: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_organization_id', p_input_info.organization_id);
336: END IF;

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

331: DBMS_SQL.Define_Column(v_CursorID, 2, v_organization_id);
332: DBMS_SQL.Define_Column(v_CursorID, 3, v_initial_pickup_location_id);
333:
334: IF p_input_info.organization_id IS NOT NULL THEN
335: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_organization_id', p_input_info.organization_id);
336: END IF;
337:
338: IF p_input_info.pr_batch_id IS NOT NULL THEN
339: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_pr_batch_id', p_input_info.pr_batch_id);

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

335: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_organization_id', p_input_info.organization_id);
336: END IF;
337:
338: IF p_input_info.pr_batch_id IS NOT NULL THEN
339: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_pr_batch_id', p_input_info.pr_batch_id);
340: END IF;
341:
342: IF p_input_info.ap_batch_id IS NOT NULL THEN
343: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ap_batch_id', p_input_info.ap_batch_id);

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

339: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_pr_batch_id', p_input_info.pr_batch_id);
340: END IF;
341:
342: IF p_input_info.ap_batch_id IS NOT NULL THEN
343: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ap_batch_id', p_input_info.ap_batch_id);
344: END IF;
345:
346: IF p_input_info.delivery_name_lo IS NOT NULL THEN
347: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_delivery_name_lo', p_input_info.delivery_name_lo);

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

343: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ap_batch_id', p_input_info.ap_batch_id);
344: END IF;
345:
346: IF p_input_info.delivery_name_lo IS NOT NULL THEN
347: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_delivery_name_lo', p_input_info.delivery_name_lo);
348: END IF;
349:
350: IF p_input_info.delivery_name_hi IS NOT NULL THEN
351: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_delivery_name_hi', p_input_info.delivery_name_hi);

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

347: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_delivery_name_lo', p_input_info.delivery_name_lo);
348: END IF;
349:
350: IF p_input_info.delivery_name_hi IS NOT NULL THEN
351: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_delivery_name_hi', p_input_info.delivery_name_hi);
352: END IF;
353:
354:
355: IF p_input_info.bol_number_lo IS NOT NULL THEN

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

352: END IF;
353:
354:
355: IF p_input_info.bol_number_lo IS NOT NULL THEN
356: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_bol_number_lo', p_input_info.bol_number_lo) ;
357: END IF;
358:
359: IF p_input_info.bol_number_hi IS NOT NULL THEN
360: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_bol_number_hi', p_input_info.bol_number_hi);

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

356: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_bol_number_lo', p_input_info.bol_number_lo) ;
357: END IF;
358:
359: IF p_input_info.bol_number_hi IS NOT NULL THEN
360: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_bol_number_hi', p_input_info.bol_number_hi);
361: END IF;
362:
363:
364: IF p_input_info.planned_flag IS NOT NULL THEN

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

361: END IF;
362:
363:
364: IF p_input_info.planned_flag IS NOT NULL THEN
365: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_planned_flag', p_input_info.planned_flag);
366: END IF;
367:
368: IF p_input_info.ship_from_loc_id IS NOT NULL THEN
369: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_from_loc_id', p_input_info.ship_from_loc_id);

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

365: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_planned_flag', p_input_info.planned_flag);
366: END IF;
367:
368: IF p_input_info.ship_from_loc_id IS NOT NULL THEN
369: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_from_loc_id', p_input_info.ship_from_loc_id);
370: END IF;
371:
372: IF p_input_info.ship_to_loc_id IS NOT NULL THEN
373: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_to_loc_id', p_input_info.ship_to_loc_id);

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

369: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_from_loc_id', p_input_info.ship_from_loc_id);
370: END IF;
371:
372: IF p_input_info.ship_to_loc_id IS NOT NULL THEN
373: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_to_loc_id', p_input_info.ship_to_loc_id);
374: END IF;
375:
376: IF p_input_info.intmed_ship_to_loc_id IS NOT NULL THEN
377: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_intmed_ship_to_loc_id', p_input_info.intmed_ship_to_loc_id);

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

373: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_to_loc_id', p_input_info.ship_to_loc_id);
374: END IF;
375:
376: IF p_input_info.intmed_ship_to_loc_id IS NOT NULL THEN
377: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_intmed_ship_to_loc_id', p_input_info.intmed_ship_to_loc_id);
378: END IF;
379:
380: IF p_input_info.pooled_ship_to_loc_id IS NOT NULL THEN
381: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_pooled_ship_to_loc_id', p_input_info.pooled_ship_to_loc_id);

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

377: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_intmed_ship_to_loc_id', p_input_info.intmed_ship_to_loc_id);
378: END IF;
379:
380: IF p_input_info.pooled_ship_to_loc_id IS NOT NULL THEN
381: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_pooled_ship_to_loc_id', p_input_info.pooled_ship_to_loc_id);
382: END IF;
383:
384: IF p_input_info.customer_id IS NOT NULL THEN
385: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_customer_id', p_input_info.customer_id);

Line 385: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_customer_id', p_input_info.customer_id);

381: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_pooled_ship_to_loc_id', p_input_info.pooled_ship_to_loc_id);
382: END IF;
383:
384: IF p_input_info.customer_id IS NOT NULL THEN
385: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_customer_id', p_input_info.customer_id);
386: END IF;
387:
388: IF p_input_info.ship_method_code IS NOT NULL THEN
389: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_method_code', p_input_info.ship_method_code);

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

385: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_customer_id', p_input_info.customer_id);
386: END IF;
387:
388: IF p_input_info.ship_method_code IS NOT NULL THEN
389: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_method_code', p_input_info.ship_method_code);
390: END IF;
391:
392: IF p_input_info.fob_code IS NOT NULL THEN
393: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_fob_code', p_input_info.fob_code);

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

389: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_method_code', p_input_info.ship_method_code);
390: END IF;
391:
392: IF p_input_info.fob_code IS NOT NULL THEN
393: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_fob_code', p_input_info.fob_code);
394: END IF;
395:
396: IF p_input_info.freight_terms_code IS NOT NULL THEN
397: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_freight_terms_code', p_input_info.freight_terms_code);

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

393: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_fob_code', p_input_info.fob_code);
394: END IF;
395:
396: IF p_input_info.freight_terms_code IS NOT NULL THEN
397: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_freight_terms_code', p_input_info.freight_terms_code);
398: END IF;
399:
400: IF p_input_info.pickup_date_lo IS NOT NULL THEN
401: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_pickup_date_lo', l_pickup_date_lo);

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

397: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_freight_terms_code', p_input_info.freight_terms_code);
398: END IF;
399:
400: IF p_input_info.pickup_date_lo IS NOT NULL THEN
401: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_pickup_date_lo', l_pickup_date_lo);
402: END IF;
403:
404: IF p_input_info.pickup_date_hi IS NOT NULL THEN
405: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_pickup_date_hi', l_pickup_date_hi);

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

401: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_pickup_date_lo', l_pickup_date_lo);
402: END IF;
403:
404: IF p_input_info.pickup_date_hi IS NOT NULL THEN
405: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_pickup_date_hi', l_pickup_date_hi);
406: END IF;
407:
408: IF p_input_info.dropoff_date_lo IS NOT NULL THEN
409: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_dropoff_date_lo', l_dropoff_date_lo);

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

405: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_pickup_date_hi', l_pickup_date_hi);
406: END IF;
407:
408: IF p_input_info.dropoff_date_lo IS NOT NULL THEN
409: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_dropoff_date_lo', l_dropoff_date_lo);
410: END IF;
411:
412: IF p_input_info.dropoff_date_hi IS NOT NULL THEN
413: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_dropoff_date_hi', l_dropoff_date_hi);

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

409: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_dropoff_date_lo', l_dropoff_date_lo);
410: END IF;
411:
412: IF p_input_info.dropoff_date_hi IS NOT NULL THEN
413: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_dropoff_date_hi', l_dropoff_date_hi);
414: END IF;
415:
416: v_ignore := DBMS_SQL.Execute(v_CursorID);
417:

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

412: IF p_input_info.dropoff_date_hi IS NOT NULL THEN
413: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_dropoff_date_hi', l_dropoff_date_hi);
414: END IF;
415:
416: v_ignore := DBMS_SQL.Execute(v_CursorID);
417:
418: LOOP
419: IF DBMS_SQL.Fetch_Rows(v_cursorID) = 0 THEN
420: DBMS_SQL.Close_Cursor(v_cursorID);

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

415:
416: v_ignore := DBMS_SQL.Execute(v_CursorID);
417:
418: LOOP
419: IF DBMS_SQL.Fetch_Rows(v_cursorID) = 0 THEN
420: DBMS_SQL.Close_Cursor(v_cursorID);
421: EXIT;
422: ELSE
423: DBMS_SQL.Column_Value(v_CursorID, 1, v_delivery_id);

Line 420: DBMS_SQL.Close_Cursor(v_cursorID);

416: v_ignore := DBMS_SQL.Execute(v_CursorID);
417:
418: LOOP
419: IF DBMS_SQL.Fetch_Rows(v_cursorID) = 0 THEN
420: DBMS_SQL.Close_Cursor(v_cursorID);
421: EXIT;
422: ELSE
423: DBMS_SQL.Column_Value(v_CursorID, 1, v_delivery_id);
424: DBMS_SQL.Column_Value(v_CursorID, 2, v_organization_id);

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

419: IF DBMS_SQL.Fetch_Rows(v_cursorID) = 0 THEN
420: DBMS_SQL.Close_Cursor(v_cursorID);
421: EXIT;
422: ELSE
423: DBMS_SQL.Column_Value(v_CursorID, 1, v_delivery_id);
424: DBMS_SQL.Column_Value(v_CursorID, 2, v_organization_id);
425: DBMS_SQL.Column_Value(v_CursorID, 3, v_initial_pickup_location_id);
426: x_selected_del_tab(x_selected_del_tab.count+1).delivery_id := v_delivery_id;
427: x_selected_del_tab(x_selected_del_tab.count).organization_id := v_organization_id;

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

420: DBMS_SQL.Close_Cursor(v_cursorID);
421: EXIT;
422: ELSE
423: DBMS_SQL.Column_Value(v_CursorID, 1, v_delivery_id);
424: DBMS_SQL.Column_Value(v_CursorID, 2, v_organization_id);
425: DBMS_SQL.Column_Value(v_CursorID, 3, v_initial_pickup_location_id);
426: x_selected_del_tab(x_selected_del_tab.count+1).delivery_id := v_delivery_id;
427: x_selected_del_tab(x_selected_del_tab.count).organization_id := v_organization_id;
428: x_selected_del_tab(x_selected_del_tab.count).initial_pickup_location_id := v_initial_pickup_location_id;

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

421: EXIT;
422: ELSE
423: DBMS_SQL.Column_Value(v_CursorID, 1, v_delivery_id);
424: DBMS_SQL.Column_Value(v_CursorID, 2, v_organization_id);
425: DBMS_SQL.Column_Value(v_CursorID, 3, v_initial_pickup_location_id);
426: x_selected_del_tab(x_selected_del_tab.count+1).delivery_id := v_delivery_id;
427: x_selected_del_tab(x_selected_del_tab.count).organization_id := v_organization_id;
428: x_selected_del_tab(x_selected_del_tab.count).initial_pickup_location_id := v_initial_pickup_location_id;
429:

Line 2889: v_delivery_detail_id_tbl DBMS_SQL.NUMBER_TABLE;

2885: l_debug_on BOOLEAN;
2886: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Select_Delivery_Lines';
2887:
2888: --Perf bug 5218515
2889: v_delivery_detail_id_tbl DBMS_SQL.NUMBER_TABLE;
2890: l_fetch_count NUMBER := 1000;
2891: l_start_index NUMBER := 1;
2892: l_records_fetched NUMBER := 0;
2893: --

Line 3130: v_CursorID := DBMS_SQL.Open_Cursor;

3126: WSH_DEBUG_SV.logmsg(l_module_name,'========================');
3127: END IF;
3128:
3129: -- open cursor
3130: v_CursorID := DBMS_SQL.Open_Cursor;
3131:
3132: -- parse cursor
3133: DBMS_SQL.Parse(v_CursorID, l_sc_FINAL, DBMS_SQL.v7 );
3134:

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

3129: -- open cursor
3130: v_CursorID := DBMS_SQL.Open_Cursor;
3131:
3132: -- parse cursor
3133: DBMS_SQL.Parse(v_CursorID, l_sc_FINAL, DBMS_SQL.v7 );
3134:
3135:
3136: -- define column
3137: --Perf bug 5218515

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

3134:
3135:
3136: -- define column
3137: --Perf bug 5218515
3138: DBMS_SQL.Define_Array(v_CursorID, 1, v_delivery_detail_id_tbl ,l_fetch_count ,l_start_index);
3139:
3140: --
3141: -- Bug 5624475 and ECO 5676263
3142: IF p_select_criteria.delivery_lines_status IN ('K', 'S') THEN

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

3152: END IF;
3153: --
3154: IF p_select_criteria.delivery_lines_status IS NOT NULL AND
3155: p_select_criteria.delivery_lines_status <> 'ALL' THEN
3156: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_released_status', l_line_status); -- Bug 5624475 and ECO 5676263
3157: END IF;
3158:
3159: -- bind the variables for organization id
3160: IF p_select_criteria.organization_id IS NOT NULL THEN

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

3157: END IF;
3158:
3159: -- bind the variables for organization id
3160: IF p_select_criteria.organization_id IS NOT NULL THEN
3161: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_organization_id', p_select_criteria.organization_id);
3162: END IF;
3163:
3164: IF p_select_criteria.scheduled_ship_date_lo IS NOT NULL THEN
3165: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_scheduled_ship_date_lo', l_scheduled_ship_date_lo);

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

3161: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_organization_id', p_select_criteria.organization_id);
3162: END IF;
3163:
3164: IF p_select_criteria.scheduled_ship_date_lo IS NOT NULL THEN
3165: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_scheduled_ship_date_lo', l_scheduled_ship_date_lo);
3166: END IF;
3167:
3168: IF p_select_criteria.scheduled_ship_date_hi IS NOT NULL THEN
3169: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_scheduled_ship_date_hi', l_scheduled_ship_date_hi);

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

3165: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_scheduled_ship_date_lo', l_scheduled_ship_date_lo);
3166: END IF;
3167:
3168: IF p_select_criteria.scheduled_ship_date_hi IS NOT NULL THEN
3169: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_scheduled_ship_date_hi', l_scheduled_ship_date_hi);
3170: END IF;
3171:
3172: IF p_select_criteria.source_code IS NOT NULL
3173: AND p_select_criteria.source_code <> 'BOTH' THEN

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

3170: END IF;
3171:
3172: IF p_select_criteria.source_code IS NOT NULL
3173: AND p_select_criteria.source_code <> 'BOTH' THEN
3174: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_source_code', p_select_criteria.source_code);
3175: END IF;
3176:
3177: IF p_select_criteria.ship_to_loc_id IS NOT NULL THEN
3178: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_to_loc_id', p_select_criteria.ship_to_loc_id);

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

3174: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_source_code', p_select_criteria.source_code);
3175: END IF;
3176:
3177: IF p_select_criteria.ship_to_loc_id IS NOT NULL THEN
3178: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_to_loc_id', p_select_criteria.ship_to_loc_id);
3179: END IF;
3180:
3181: IF p_select_criteria.customer_id IS NOT NULL THEN
3182: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_customer_id', p_select_criteria.customer_id);

Line 3182: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_customer_id', p_select_criteria.customer_id);

3178: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_to_loc_id', p_select_criteria.ship_to_loc_id);
3179: END IF;
3180:
3181: IF p_select_criteria.customer_id IS NOT NULL THEN
3182: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_customer_id', p_select_criteria.customer_id);
3183: END IF;
3184:
3185: IF p_select_criteria.ship_method_code IS NOT NULL THEN
3186: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_method_code', p_select_criteria.ship_method_code);

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

3182: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_customer_id', p_select_criteria.customer_id);
3183: END IF;
3184:
3185: IF p_select_criteria.ship_method_code IS NOT NULL THEN
3186: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_method_code', p_select_criteria.ship_method_code);
3187: END IF;
3188:
3189: -- execute the cursor
3190: v_ignore := DBMS_SQL.Execute(v_CursorID);

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

3186: DBMS_SQL.BIND_VARIABLE(v_CursorID,':x_ship_method_code', p_select_criteria.ship_method_code);
3187: END IF;
3188:
3189: -- execute the cursor
3190: v_ignore := DBMS_SQL.Execute(v_CursorID);
3191:
3192: -- fetching the rows in bulk.
3193: --Perf bug 5218515
3194: Loop

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

3191:
3192: -- fetching the rows in bulk.
3193: --Perf bug 5218515
3194: Loop
3195: l_records_fetched := dbms_sql.fetch_rows(v_CursorID) ;
3196: dbms_sql.column_value(v_CursorID,1,v_delivery_detail_id_tbl);
3197: IF l_debug_on THEN
3198: WSH_DEBUG_SV.logmsg(l_module_name,' Records Fetched in this pass '|| l_records_fetched);
3199: WSH_DEBUG_SV.logmsg(l_module_name,' l_fetch_count '|| l_fetch_count);

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

3192: -- fetching the rows in bulk.
3193: --Perf bug 5218515
3194: Loop
3195: l_records_fetched := dbms_sql.fetch_rows(v_CursorID) ;
3196: dbms_sql.column_value(v_CursorID,1,v_delivery_detail_id_tbl);
3197: IF l_debug_on THEN
3198: WSH_DEBUG_SV.logmsg(l_module_name,' Records Fetched in this pass '|| l_records_fetched);
3199: WSH_DEBUG_SV.logmsg(l_module_name,' l_fetch_count '|| l_fetch_count);
3200: WSH_DEBUG_SV.logmsg(l_module_name,' Record count in v_delivery_detail_id_tbl '||

Line 3221: DBMS_SQL.Close_Cursor(v_cursorID);

3217: If l_debug_on THEN
3218: WSH_DEBUG_SV.logmsg(l_module_name,' Before closing cursor = '||v_cursorID );
3219: End If;
3220:
3221: DBMS_SQL.Close_Cursor(v_cursorID);
3222:
3223: If l_debug_on THEN
3224: WSH_DEBUG_SV.logmsg(l_module_name,' After closing cursor = '||v_cursorID );
3225: End If;

Line 3240: DBMS_SQL.Close_Cursor(v_cursorID);

3236:
3237: WHEN others THEN
3238: -- if the cursor is still open then close the cursor
3239: IF v_cursorID <> 0 THEN
3240: DBMS_SQL.Close_Cursor(v_cursorID);
3241: END IF;
3242: wsh_util_core.default_handler('WSH_BATCH_PROCESS.Select_Deliveries');
3243: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3244: IF l_debug_on THEN