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

Line 354: l_query_handle := DBMS_SQL.open_cursor;

350: IF l_debug = 1 THEN
351: debug('l_tasks_query ' || l_tasks_query,'query_inbound');
352: END IF;
353:
354: l_query_handle := DBMS_SQL.open_cursor;
355: DBMS_SQL.parse(l_query_handle, l_tasks_query, DBMS_SQL.native);
356:
357: /* set the bind variables now */
358: IF l_debug = 1 THEN

Line 355: DBMS_SQL.parse(l_query_handle, l_tasks_query, DBMS_SQL.native);

351: debug('l_tasks_query ' || l_tasks_query,'query_inbound');
352: END IF;
353:
354: l_query_handle := DBMS_SQL.open_cursor;
355: DBMS_SQL.parse(l_query_handle, l_tasks_query, DBMS_SQL.native);
356:
357: /* set the bind variables now */
358: IF l_debug = 1 THEN
359: debug('setting the bind_variables ','query_inbound');

Line 365: dbms_sql.bind_variable(l_query_handle, 'org_id', wms_plan_tasks_pvt.g_organization_id);

361: IF wms_plan_tasks_pvt.g_organization_id IS NOT NULL THEN
362: IF l_debug = 1 THEN
363: debug('wms_plan_tasks_pvt.g_organization_id is not null ','query_inbound');
364: END IF;
365: dbms_sql.bind_variable(l_query_handle, 'org_id', wms_plan_tasks_pvt.g_organization_id);
366: END IF;
367:
368: IF wms_plan_tasks_pvt.g_subinventory_code IS NOT NULL THEN
369: IF l_debug = 1 THEN

Line 372: dbms_sql.bind_variable(l_query_handle, 'sub_code', wms_plan_tasks_pvt.g_subinventory_code);

368: IF wms_plan_tasks_pvt.g_subinventory_code IS NOT NULL THEN
369: IF l_debug = 1 THEN
370: debug('wms_plan_tasks_pvt.g_subinventory_code is not null ','query_inbound');
371: END IF;
372: dbms_sql.bind_variable(l_query_handle, 'sub_code', wms_plan_tasks_pvt.g_subinventory_code);
373: END IF;
374:
375: IF wms_plan_tasks_pvt.g_locator_id IS NOT NULL THEN
376: IF l_debug = 1 THEN

Line 379: dbms_sql.bind_variable(l_query_handle, 'loc_id', wms_plan_tasks_pvt.g_locator_id);

375: IF wms_plan_tasks_pvt.g_locator_id IS NOT NULL THEN
376: IF l_debug = 1 THEN
377: debug('wms_plan_tasks_pvt.g_locator_id is not null ','query_inbound');
378: END IF;
379: dbms_sql.bind_variable(l_query_handle, 'loc_id', wms_plan_tasks_pvt.g_locator_id);
380: END IF;
381:
382: IF wms_plan_tasks_pvt.g_to_subinventory_code IS NOT NULL THEN
383: IF l_debug = 1 THEN

Line 386: dbms_sql.bind_variable(l_query_handle, 'to_sub_code', wms_plan_tasks_pvt.g_to_subinventory_code );

382: IF wms_plan_tasks_pvt.g_to_subinventory_code IS NOT NULL THEN
383: IF l_debug = 1 THEN
384: debug('wms_plan_tasks_pvt.g_to_subinventory_code is not null ','query_inbound');
385: END IF;
386: dbms_sql.bind_variable(l_query_handle, 'to_sub_code', wms_plan_tasks_pvt.g_to_subinventory_code );
387: END IF;
388:
389: IF wms_plan_tasks_pvt.g_to_locator_id IS NOT NULL THEN
390: IF l_debug = 1 THEN

Line 393: dbms_sql.bind_variable(l_query_handle, 'to_loc_id', wms_plan_tasks_pvt.g_to_locator_id );

389: IF wms_plan_tasks_pvt.g_to_locator_id IS NOT NULL THEN
390: IF l_debug = 1 THEN
391: debug('wms_plan_tasks_pvt.g_to_locator_id is not null ','query_inbound');
392: END IF;
393: dbms_sql.bind_variable(l_query_handle, 'to_loc_id', wms_plan_tasks_pvt.g_to_locator_id );
394: END IF;
395:
396: IF wms_plan_tasks_pvt.g_category_set_id IS NOT NULL THEN
397: IF l_debug = 1 THEN

Line 400: dbms_sql.bind_variable(l_query_handle, 'category_set_id', wms_plan_tasks_pvt.g_category_set_id );

396: IF wms_plan_tasks_pvt.g_category_set_id IS NOT NULL THEN
397: IF l_debug = 1 THEN
398: debug('wms_plan_tasks_pvt.g_category_set_id is not null ','query_inbound');
399: END IF;
400: dbms_sql.bind_variable(l_query_handle, 'category_set_id', wms_plan_tasks_pvt.g_category_set_id );
401: END IF;
402:
403: IF wms_plan_tasks_pvt.g_item_category_id IS NOT NULL THEN
404: IF l_debug = 1 THEN

Line 407: dbms_sql.bind_variable(l_query_handle, 'item_category_id', wms_plan_tasks_pvt.g_item_category_id );

403: IF wms_plan_tasks_pvt.g_item_category_id IS NOT NULL THEN
404: IF l_debug = 1 THEN
405: debug('wms_plan_tasks_pvt.g_item_category_id is not null ','query_inbound');
406: END IF;
407: dbms_sql.bind_variable(l_query_handle, 'item_category_id', wms_plan_tasks_pvt.g_item_category_id );
408: END IF;
409:
410: IF wms_plan_tasks_pvt.g_inventory_item_id IS NOT NULL THEN
411: IF l_debug = 1 THEN

Line 414: dbms_sql.bind_variable(l_query_handle, 'item_id', wms_plan_tasks_pvt.g_inventory_item_id );

410: IF wms_plan_tasks_pvt.g_inventory_item_id IS NOT NULL THEN
411: IF l_debug = 1 THEN
412: debug('wms_plan_tasks_pvt.g_inventory_item_id is not null ','query_inbound');
413: END IF;
414: dbms_sql.bind_variable(l_query_handle, 'item_id', wms_plan_tasks_pvt.g_inventory_item_id );
415: END IF;
416:
417: IF wms_plan_tasks_pvt.g_person_id IS NOT NULL THEN
418: IF l_debug = 1 THEN

Line 421: dbms_sql.bind_variable(l_query_handle, 'person_id', wms_plan_tasks_pvt.g_person_id);

417: IF wms_plan_tasks_pvt.g_person_id IS NOT NULL THEN
418: IF l_debug = 1 THEN
419: debug('wms_plan_tasks_pvt.g_person_id is not null ','query_inbound');
420: END IF;
421: dbms_sql.bind_variable(l_query_handle, 'person_id', wms_plan_tasks_pvt.g_person_id);
422: END IF;
423:
424: IF wms_plan_tasks_pvt.g_person_resource_id IS NOT NULL THEN
425: IF l_debug = 1 THEN

Line 428: dbms_sql.bind_variable(l_query_handle, 'person_resource_id', wms_plan_tasks_pvt.g_person_resource_id);

424: IF wms_plan_tasks_pvt.g_person_resource_id IS NOT NULL THEN
425: IF l_debug = 1 THEN
426: debug('wms_plan_tasks_pvt.g_person_resource_id is not null ','query_inbound');
427: END IF;
428: dbms_sql.bind_variable(l_query_handle, 'person_resource_id', wms_plan_tasks_pvt.g_person_resource_id);
429: END IF;
430:
431: IF wms_plan_tasks_pvt.g_equipment_type_id IS NOT NULL THEN
432: IF l_debug = 1 THEN

Line 435: dbms_sql.bind_variable(l_query_handle, 'equipment_type_id', wms_plan_tasks_pvt.g_equipment_type_id);

431: IF wms_plan_tasks_pvt.g_equipment_type_id IS NOT NULL THEN
432: IF l_debug = 1 THEN
433: debug('wms_plan_tasks_pvt.g_equipment_type_id is not null ','query_inbound');
434: END IF;
435: dbms_sql.bind_variable(l_query_handle, 'equipment_type_id', wms_plan_tasks_pvt.g_equipment_type_id);
436: END IF;
437:
438: IF wms_plan_tasks_pvt.g_machine_resource_id IS NOT NULL THEN
439: IF l_debug = 1 THEN

Line 442: dbms_sql.bind_variable(l_query_handle, 'machine_resource_id', wms_plan_tasks_pvt.g_machine_resource_id);

438: IF wms_plan_tasks_pvt.g_machine_resource_id IS NOT NULL THEN
439: IF l_debug = 1 THEN
440: debug('wms_plan_tasks_pvt.g_machine_resource_id is not null ','query_inbound');
441: END IF;
442: dbms_sql.bind_variable(l_query_handle, 'machine_resource_id', wms_plan_tasks_pvt.g_machine_resource_id);
443: END IF;
444:
445: IF wms_plan_tasks_pvt.g_machine_instance IS NOT NULL THEN
446: IF l_debug = 1 THEN

Line 449: dbms_sql.bind_variable(l_query_handle, 'machine_instance', wms_plan_tasks_pvt.g_machine_instance);

445: IF wms_plan_tasks_pvt.g_machine_instance IS NOT NULL THEN
446: IF l_debug = 1 THEN
447: debug('wms_plan_tasks_pvt.g_machine_instance is not null ','query_inbound');
448: END IF;
449: dbms_sql.bind_variable(l_query_handle, 'machine_instance', wms_plan_tasks_pvt.g_machine_instance);
450: END IF;
451:
452: IF wms_plan_tasks_pvt.g_from_creation_date IS NOT NULL THEN
453: IF l_debug = 1 THEN

Line 456: dbms_sql.bind_variable(l_query_handle, 'from_creation_date', wms_plan_tasks_pvt.g_from_creation_date);

452: IF wms_plan_tasks_pvt.g_from_creation_date IS NOT NULL THEN
453: IF l_debug = 1 THEN
454: debug('wms_plan_tasks_pvt.g_from_creation_date is not null ','query_inbound');
455: END IF;
456: dbms_sql.bind_variable(l_query_handle, 'from_creation_date', wms_plan_tasks_pvt.g_from_creation_date);
457: END IF;
458:
459: IF wms_plan_tasks_pvt.g_to_creation_date IS NOT NULL THEN
460: IF l_debug = 1 THEN

Line 463: dbms_sql.bind_variable(l_query_handle, 'to_creation_date', wms_plan_tasks_pvt.g_to_creation_date);

459: IF wms_plan_tasks_pvt.g_to_creation_date IS NOT NULL THEN
460: IF l_debug = 1 THEN
461: debug('wms_plan_tasks_pvt.g_to_creation_date is not null ','query_inbound');
462: END IF;
463: dbms_sql.bind_variable(l_query_handle, 'to_creation_date', wms_plan_tasks_pvt.g_to_creation_date);
464: END IF;
465:
466: IF wms_plan_tasks_pvt.g_from_task_quantity IS NOT NULL THEN
467: IF l_debug = 1 THEN

Line 470: dbms_sql.bind_variable(l_query_handle, 'from_task_quantity', wms_plan_tasks_pvt.g_from_task_quantity );

466: IF wms_plan_tasks_pvt.g_from_task_quantity IS NOT NULL THEN
467: IF l_debug = 1 THEN
468: debug('wms_plan_tasks_pvt.g_from_task_quantity is not null ','query_inbound');
469: END IF;
470: dbms_sql.bind_variable(l_query_handle, 'from_task_quantity', wms_plan_tasks_pvt.g_from_task_quantity );
471: END IF;
472:
473: IF wms_plan_tasks_pvt.g_to_task_quantity IS NOT NULL THEN
474: IF l_debug = 1 THEN

Line 477: dbms_sql.bind_variable(l_query_handle, 'to_task_quantity', wms_plan_tasks_pvt.g_to_task_quantity );

473: IF wms_plan_tasks_pvt.g_to_task_quantity IS NOT NULL THEN
474: IF l_debug = 1 THEN
475: debug('wms_plan_tasks_pvt.g_to_task_quantity is not null ','query_inbound');
476: END IF;
477: dbms_sql.bind_variable(l_query_handle, 'to_task_quantity', wms_plan_tasks_pvt.g_to_task_quantity );
478: END IF;
479:
480: IF wms_plan_tasks_pvt.g_from_requisition_header_id IS NOT NULL THEN
481: IF l_debug = 1 THEN

Line 484: dbms_sql.bind_variable(l_query_handle, 'from_requisition_header_id', wms_plan_tasks_pvt.g_from_requisition_header_id );

480: IF wms_plan_tasks_pvt.g_from_requisition_header_id IS NOT NULL THEN
481: IF l_debug = 1 THEN
482: debug('wms_plan_tasks_pvt.g_from_requisition_header_id is not null ','query_inbound');
483: END IF;
484: dbms_sql.bind_variable(l_query_handle, 'from_requisition_header_id', wms_plan_tasks_pvt.g_from_requisition_header_id );
485: END IF;
486:
487: IF wms_plan_tasks_pvt.g_to_requisition_header_id IS NOT NULL THEN
488: IF l_debug = 1 THEN

Line 491: dbms_sql.bind_variable(l_query_handle, 'to_requisition_header_id', wms_plan_tasks_pvt.g_to_requisition_header_id );

487: IF wms_plan_tasks_pvt.g_to_requisition_header_id IS NOT NULL THEN
488: IF l_debug = 1 THEN
489: debug('wms_plan_tasks_pvt.g_to_requisition_header_id is not null ','query_inbound');
490: END IF;
491: dbms_sql.bind_variable(l_query_handle, 'to_requisition_header_id', wms_plan_tasks_pvt.g_to_requisition_header_id );
492: END IF;
493:
494: IF wms_plan_tasks_pvt.g_from_shipment_number IS NOT NULL THEN
495: IF l_debug = 1 THEN

Line 499: dbms_sql.bind_variable(l_query_handle, 'from_shipment_number', wms_plan_tasks_pvt.g_from_shipment_number );

495: IF l_debug = 1 THEN
496: debug('wms_plan_tasks_pvt.g_from_shipment_number is not null ','query_inbound');
497: END IF;
498: -- Bug #3746810. Modified the bin var g_from_shipment_number to from_shipment_number
499: dbms_sql.bind_variable(l_query_handle, 'from_shipment_number', wms_plan_tasks_pvt.g_from_shipment_number );
500: END IF;
501:
502: IF wms_plan_tasks_pvt.g_to_shipment_number IS NOT NULL THEN
503: IF l_debug = 1 THEN

Line 506: dbms_sql.bind_variable(l_query_handle, 'to_shipment_number', wms_plan_tasks_pvt.g_to_shipment_number );

502: IF wms_plan_tasks_pvt.g_to_shipment_number IS NOT NULL THEN
503: IF l_debug = 1 THEN
504: debug('wms_plan_tasks_pvt.g_to_shipment_number is not null ','query_inbound');
505: END IF;
506: dbms_sql.bind_variable(l_query_handle, 'to_shipment_number', wms_plan_tasks_pvt.g_to_shipment_number );
507: END IF;
508:
509: IF wms_plan_tasks_pvt.g_from_po_header_id IS NOT NULL THEN
510: IF l_debug = 1 THEN

Line 513: dbms_sql.bind_variable(l_query_handle, 'from_po_header_id', wms_plan_tasks_pvt.g_from_po_header_id );

509: IF wms_plan_tasks_pvt.g_from_po_header_id IS NOT NULL THEN
510: IF l_debug = 1 THEN
511: debug('wms_plan_tasks_pvt.g_from_po_header_id is not null ' || wms_plan_tasks_pvt.g_from_po_header_id,'query_inbound');
512: END IF;
513: dbms_sql.bind_variable(l_query_handle, 'from_po_header_id', wms_plan_tasks_pvt.g_from_po_header_id );
514: END IF;
515:
516: IF wms_plan_tasks_pvt.g_to_po_header_id IS NOT NULL THEN
517: IF l_debug = 1 THEN

Line 520: dbms_sql.bind_variable(l_query_handle, 'to_po_header_id', wms_plan_tasks_pvt.g_to_po_header_id );

516: IF wms_plan_tasks_pvt.g_to_po_header_id IS NOT NULL THEN
517: IF l_debug = 1 THEN
518: debug('wms_plan_tasks_pvt.g_to_po_header_id is not null ' || wms_plan_tasks_pvt.g_to_po_header_id,'query_inbound');
519: END IF;
520: dbms_sql.bind_variable(l_query_handle, 'to_po_header_id', wms_plan_tasks_pvt.g_to_po_header_id );
521: END IF;
522:
523: IF wms_plan_tasks_pvt.g_from_rma_header_id IS NOT NULL THEN
524: IF l_debug = 1 THEN

Line 527: dbms_sql.bind_variable(l_query_handle, 'from_rma_header_id', wms_plan_tasks_pvt.g_from_rma_header_id );

523: IF wms_plan_tasks_pvt.g_from_rma_header_id IS NOT NULL THEN
524: IF l_debug = 1 THEN
525: debug('wms_plan_tasks_pvt.g_from_rma_header_id is not null ','query_inbound');
526: END IF;
527: dbms_sql.bind_variable(l_query_handle, 'from_rma_header_id', wms_plan_tasks_pvt.g_from_rma_header_id );
528: END IF;
529:
530: IF wms_plan_tasks_pvt.g_to_rma_header_id IS NOT NULL THEN
531: IF l_debug = 1 THEN

Line 534: dbms_sql.bind_variable(l_query_handle, 'to_rma_header_id', wms_plan_tasks_pvt.g_to_rma_header_id );

530: IF wms_plan_tasks_pvt.g_to_rma_header_id IS NOT NULL THEN
531: IF l_debug = 1 THEN
532: debug('wms_plan_tasks_pvt.g_to_rma_header_id is not null ','query_inbound');
533: END IF;
534: dbms_sql.bind_variable(l_query_handle, 'to_rma_header_id', wms_plan_tasks_pvt.g_to_rma_header_id );
535: END IF;
536:
537: IF wms_plan_tasks_pvt.g_op_plan_id IS NOT NULL THEN
538: IF l_debug = 1 THEN

Line 541: dbms_sql.bind_variable(l_query_handle, 'op_plan_id', wms_plan_tasks_pvt.g_op_plan_id );

537: IF wms_plan_tasks_pvt.g_op_plan_id IS NOT NULL THEN
538: IF l_debug = 1 THEN
539: debug('wms_plan_tasks_pvt.g_op_plan_id IS NOT NULL ','query_inbound');
540: END IF;
541: dbms_sql.bind_variable(l_query_handle, 'op_plan_id', wms_plan_tasks_pvt.g_op_plan_id );
542: END IF;
543:
544: IF wms_plan_tasks_pvt.g_include_crossdock THEN
545:

Line 573: DBMS_SQL.bind_variable (l_query_handle, 'source_type_id', 8);

569:
570:
571: IF wms_plan_tasks_pvt.g_include_internal_orders AND NOT wms_plan_tasks_pvt.g_include_sales_orders
572: THEN
573: DBMS_SQL.bind_variable (l_query_handle, 'source_type_id', 8);
574: ELSIF NOT wms_plan_tasks_pvt.g_include_internal_orders AND wms_plan_tasks_pvt.g_include_sales_orders
575: THEN
576: DBMS_SQL.bind_variable (l_query_handle, 'source_type_id', 2);
577: END IF;

Line 576: DBMS_SQL.bind_variable (l_query_handle, 'source_type_id', 2);

572: THEN
573: DBMS_SQL.bind_variable (l_query_handle, 'source_type_id', 8);
574: ELSIF NOT wms_plan_tasks_pvt.g_include_internal_orders AND wms_plan_tasks_pvt.g_include_sales_orders
575: THEN
576: DBMS_SQL.bind_variable (l_query_handle, 'source_type_id', 2);
577: END IF;
578:
579: /*added if else for 3455109 since we are changing the query also need to change binds if its for completed task*/
580: IF NOT g_is_completed_task THEN -- Non Completed tasks

Line 584: DBMS_SQL.bind_variable (l_query_handle,'from_sales_order_id',wms_plan_tasks_pvt.g_from_sales_order_id);

580: IF NOT g_is_completed_task THEN -- Non Completed tasks
581:
582: IF wms_plan_tasks_pvt.g_from_sales_order_id IS NOT NULL
583: THEN
584: DBMS_SQL.bind_variable (l_query_handle,'from_sales_order_id',wms_plan_tasks_pvt.g_from_sales_order_id);
585: END IF;
586:
587: IF wms_plan_tasks_pvt.g_to_sales_order_id IS NOT NULL
588: THEN

Line 589: DBMS_SQL.bind_variable (l_query_handle,'to_sales_order_id',wms_plan_tasks_pvt.g_to_sales_order_id);

585: END IF;
586:
587: IF wms_plan_tasks_pvt.g_to_sales_order_id IS NOT NULL
588: THEN
589: DBMS_SQL.bind_variable (l_query_handle,'to_sales_order_id',wms_plan_tasks_pvt.g_to_sales_order_id);
590: END IF;
591: ELSE --completed tasks
592: IF(l_is_range_so) then
593: IF wms_plan_tasks_pvt.g_from_sales_order_id IS NOT NULL THEN

Line 594: --3240261 dbms_sql.bind_variable(l_query_handle, 'from_sales_order_id', p_from_sales_order_id);

590: END IF;
591: ELSE --completed tasks
592: IF(l_is_range_so) then
593: IF wms_plan_tasks_pvt.g_from_sales_order_id IS NOT NULL THEN
594: --3240261 dbms_sql.bind_variable(l_query_handle, 'from_sales_order_id', p_from_sales_order_id);
595: dbms_sql.bind_variable(l_query_handle,'l_from_tonum_mso_seg1',l_from_tonum_mso_seg1);--added for 3455109
596: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg2',l_from_mso_seg2);--3455109
597: END IF;
598:

Line 595: dbms_sql.bind_variable(l_query_handle,'l_from_tonum_mso_seg1',l_from_tonum_mso_seg1);--added for 3455109

591: ELSE --completed tasks
592: IF(l_is_range_so) then
593: IF wms_plan_tasks_pvt.g_from_sales_order_id IS NOT NULL THEN
594: --3240261 dbms_sql.bind_variable(l_query_handle, 'from_sales_order_id', p_from_sales_order_id);
595: dbms_sql.bind_variable(l_query_handle,'l_from_tonum_mso_seg1',l_from_tonum_mso_seg1);--added for 3455109
596: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg2',l_from_mso_seg2);--3455109
597: END IF;
598:
599: IF wms_plan_tasks_pvt.g_to_sales_order_id IS NOT NULL THEN

Line 596: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg2',l_from_mso_seg2);--3455109

592: IF(l_is_range_so) then
593: IF wms_plan_tasks_pvt.g_from_sales_order_id IS NOT NULL THEN
594: --3240261 dbms_sql.bind_variable(l_query_handle, 'from_sales_order_id', p_from_sales_order_id);
595: dbms_sql.bind_variable(l_query_handle,'l_from_tonum_mso_seg1',l_from_tonum_mso_seg1);--added for 3455109
596: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg2',l_from_mso_seg2);--3455109
597: END IF;
598:
599: IF wms_plan_tasks_pvt.g_to_sales_order_id IS NOT NULL THEN
600: --3420261 dbms_sql.bind_variable(l_query_handle, 'to_sales_order_id', p_to_sales_order_id);

Line 600: --3420261 dbms_sql.bind_variable(l_query_handle, 'to_sales_order_id', p_to_sales_order_id);

596: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg2',l_from_mso_seg2);--3455109
597: END IF;
598:
599: IF wms_plan_tasks_pvt.g_to_sales_order_id IS NOT NULL THEN
600: --3420261 dbms_sql.bind_variable(l_query_handle, 'to_sales_order_id', p_to_sales_order_id);
601: dbms_sql.bind_variable(l_query_handle,'l_to_tonum_mso_seg1',l_to_tonum_mso_seg1);
602: dbms_sql.bind_variable(l_query_handle,'l_to_mso_seg2',l_to_mso_seg2);
603: END IF;
604: ELSE

Line 601: dbms_sql.bind_variable(l_query_handle,'l_to_tonum_mso_seg1',l_to_tonum_mso_seg1);

597: END IF;
598:
599: IF wms_plan_tasks_pvt.g_to_sales_order_id IS NOT NULL THEN
600: --3420261 dbms_sql.bind_variable(l_query_handle, 'to_sales_order_id', p_to_sales_order_id);
601: dbms_sql.bind_variable(l_query_handle,'l_to_tonum_mso_seg1',l_to_tonum_mso_seg1);
602: dbms_sql.bind_variable(l_query_handle,'l_to_mso_seg2',l_to_mso_seg2);
603: END IF;
604: ELSE
605: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg1',l_from_mso_seg1);

Line 602: dbms_sql.bind_variable(l_query_handle,'l_to_mso_seg2',l_to_mso_seg2);

598:
599: IF wms_plan_tasks_pvt.g_to_sales_order_id IS NOT NULL THEN
600: --3420261 dbms_sql.bind_variable(l_query_handle, 'to_sales_order_id', p_to_sales_order_id);
601: dbms_sql.bind_variable(l_query_handle,'l_to_tonum_mso_seg1',l_to_tonum_mso_seg1);
602: dbms_sql.bind_variable(l_query_handle,'l_to_mso_seg2',l_to_mso_seg2);
603: END IF;
604: ELSE
605: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg1',l_from_mso_seg1);
606: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg2',l_from_mso_seg2);

Line 605: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg1',l_from_mso_seg1);

601: dbms_sql.bind_variable(l_query_handle,'l_to_tonum_mso_seg1',l_to_tonum_mso_seg1);
602: dbms_sql.bind_variable(l_query_handle,'l_to_mso_seg2',l_to_mso_seg2);
603: END IF;
604: ELSE
605: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg1',l_from_mso_seg1);
606: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg2',l_from_mso_seg2);
607: END IF;--end of range or not range so
608:
609: END IF;--end of copleted or not completed task 3455109

Line 606: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg2',l_from_mso_seg2);

602: dbms_sql.bind_variable(l_query_handle,'l_to_mso_seg2',l_to_mso_seg2);
603: END IF;
604: ELSE
605: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg1',l_from_mso_seg1);
606: dbms_sql.bind_variable(l_query_handle,'l_from_mso_seg2',l_from_mso_seg2);
607: END IF;--end of range or not range so
608:
609: END IF;--end of copleted or not completed task 3455109
610:

Line 613: DBMS_SQL.bind_variable (l_query_handle,'from_pick_slip_number',wms_plan_tasks_pvt.g_from_pick_slip_number);

609: END IF;--end of copleted or not completed task 3455109
610:
611: IF wms_plan_tasks_pvt.g_from_pick_slip_number IS NOT NULL
612: THEN
613: DBMS_SQL.bind_variable (l_query_handle,'from_pick_slip_number',wms_plan_tasks_pvt.g_from_pick_slip_number);
614: END IF;
615:
616: IF wms_plan_tasks_pvt.g_to_pick_slip_number IS NOT NULL
617: THEN

Line 618: DBMS_SQL.bind_variable (l_query_handle,'to_pick_slip_number',wms_plan_tasks_pvt.g_to_pick_slip_number);

614: END IF;
615:
616: IF wms_plan_tasks_pvt.g_to_pick_slip_number IS NOT NULL
617: THEN
618: DBMS_SQL.bind_variable (l_query_handle,'to_pick_slip_number',wms_plan_tasks_pvt.g_to_pick_slip_number);
619: END IF;
620:
621: IF wms_plan_tasks_pvt.g_customer_id IS NOT NULL
622: THEN

Line 623: DBMS_SQL.bind_variable (l_query_handle,'customer_id',wms_plan_tasks_pvt.g_customer_id);

619: END IF;
620:
621: IF wms_plan_tasks_pvt.g_customer_id IS NOT NULL
622: THEN
623: DBMS_SQL.bind_variable (l_query_handle,'customer_id',wms_plan_tasks_pvt.g_customer_id);
624: END IF;
625:
626: IF wms_plan_tasks_pvt.g_customer_category IS NOT NULL
627: THEN

Line 628: DBMS_SQL.bind_variable (l_query_handle,'customer_category',wms_plan_tasks_pvt.g_customer_category);

624: END IF;
625:
626: IF wms_plan_tasks_pvt.g_customer_category IS NOT NULL
627: THEN
628: DBMS_SQL.bind_variable (l_query_handle,'customer_category',wms_plan_tasks_pvt.g_customer_category);
629: END IF;
630:
631: IF wms_plan_tasks_pvt.g_trip_id IS NOT NULL
632: THEN

Line 633: DBMS_SQL.bind_variable (l_query_handle, 'trip_id', wms_plan_tasks_pvt.g_trip_id);

629: END IF;
630:
631: IF wms_plan_tasks_pvt.g_trip_id IS NOT NULL
632: THEN
633: DBMS_SQL.bind_variable (l_query_handle, 'trip_id', wms_plan_tasks_pvt.g_trip_id);
634: END IF;
635:
636: IF wms_plan_tasks_pvt.g_delivery_id IS NOT NULL
637: THEN

Line 638: DBMS_SQL.bind_variable (l_query_handle,'delivery_id',wms_plan_tasks_pvt.g_delivery_id);

634: END IF;
635:
636: IF wms_plan_tasks_pvt.g_delivery_id IS NOT NULL
637: THEN
638: DBMS_SQL.bind_variable (l_query_handle,'delivery_id',wms_plan_tasks_pvt.g_delivery_id);
639: END IF;
640:
641: IF wms_plan_tasks_pvt.g_carrier_id IS NOT NULL
642: THEN

Line 643: DBMS_SQL.bind_variable (l_query_handle,'carrier_id',wms_plan_tasks_pvt.g_carrier_id);

639: END IF;
640:
641: IF wms_plan_tasks_pvt.g_carrier_id IS NOT NULL
642: THEN
643: DBMS_SQL.bind_variable (l_query_handle,'carrier_id',wms_plan_tasks_pvt.g_carrier_id);
644: END IF;
645:
646: IF wms_plan_tasks_pvt.g_ship_method IS NOT NULL
647: THEN

Line 648: DBMS_SQL.bind_variable (l_query_handle,'ship_method',wms_plan_tasks_pvt.g_ship_method);

644: END IF;
645:
646: IF wms_plan_tasks_pvt.g_ship_method IS NOT NULL
647: THEN
648: DBMS_SQL.bind_variable (l_query_handle,'ship_method',wms_plan_tasks_pvt.g_ship_method);
649: END IF;
650:
651: IF wms_plan_tasks_pvt.g_shipment_priority IS NOT NULL
652: THEN

Line 653: DBMS_SQL.bind_variable (l_query_handle,'shipment_priority',wms_plan_tasks_pvt.g_shipment_priority);

649: END IF;
650:
651: IF wms_plan_tasks_pvt.g_shipment_priority IS NOT NULL
652: THEN
653: DBMS_SQL.bind_variable (l_query_handle,'shipment_priority',wms_plan_tasks_pvt.g_shipment_priority);
654: END IF;
655:
656: IF wms_plan_tasks_pvt.g_from_shipment_date IS NOT NULL
657: THEN

Line 658: DBMS_SQL.bind_variable (l_query_handle,'from_shipment_date',wms_plan_tasks_pvt.g_from_shipment_date);

654: END IF;
655:
656: IF wms_plan_tasks_pvt.g_from_shipment_date IS NOT NULL
657: THEN
658: DBMS_SQL.bind_variable (l_query_handle,'from_shipment_date',wms_plan_tasks_pvt.g_from_shipment_date);
659: END IF;
660:
661: IF wms_plan_tasks_pvt.g_to_shipment_date IS NOT NULL
662: THEN

Line 663: DBMS_SQL.bind_variable (l_query_handle,'to_shipment_date',wms_plan_tasks_pvt.g_to_shipment_date);

659: END IF;
660:
661: IF wms_plan_tasks_pvt.g_to_shipment_date IS NOT NULL
662: THEN
663: DBMS_SQL.bind_variable (l_query_handle,'to_shipment_date',wms_plan_tasks_pvt.g_to_shipment_date);
664: END IF;
665: /*
666: IF wms_plan_tasks_pvt.g_time_till_shipment IS NOT NULL AND wms_plan_tasks_pvt.g_time_till_shipment_uom_code IS NOT NULL
667: THEN

Line 668: DBMS_SQL.bind_variable (l_query_handle,'p_time_till_shipment',wms_plan_tasks_pvt.g_time_till_shipment);

664: END IF;
665: /*
666: IF wms_plan_tasks_pvt.g_time_till_shipment IS NOT NULL AND wms_plan_tasks_pvt.g_time_till_shipment_uom_code IS NOT NULL
667: THEN
668: DBMS_SQL.bind_variable (l_query_handle,'p_time_till_shipment',wms_plan_tasks_pvt.g_time_till_shipment);
669: END IF;
670: */
671:
672: IF wms_plan_tasks_pvt.g_ship_to_state IS NOT NULL

Line 674: DBMS_SQL.bind_variable (l_query_handle,'ship_to_state',wms_plan_tasks_pvt.g_ship_to_state);

670: */
671:
672: IF wms_plan_tasks_pvt.g_ship_to_state IS NOT NULL
673: THEN
674: DBMS_SQL.bind_variable (l_query_handle,'ship_to_state',wms_plan_tasks_pvt.g_ship_to_state);
675: END IF;
676:
677: IF wms_plan_tasks_pvt.g_ship_to_country IS NOT NULL
678: THEN

Line 679: DBMS_SQL.bind_variable (l_query_handle,'ship_to_country',wms_plan_tasks_pvt.g_ship_to_country);

675: END IF;
676:
677: IF wms_plan_tasks_pvt.g_ship_to_country IS NOT NULL
678: THEN
679: DBMS_SQL.bind_variable (l_query_handle,'ship_to_country',wms_plan_tasks_pvt.g_ship_to_country);
680: END IF;
681:
682: IF wms_plan_tasks_pvt.g_ship_to_postal_code IS NOT NULL
683: THEN

Line 684: DBMS_SQL.bind_variable (l_query_handle,'ship_to_postal_code',wms_plan_tasks_pvt.g_ship_to_postal_code);

680: END IF;
681:
682: IF wms_plan_tasks_pvt.g_ship_to_postal_code IS NOT NULL
683: THEN
684: DBMS_SQL.bind_variable (l_query_handle,'ship_to_postal_code',wms_plan_tasks_pvt.g_ship_to_postal_code);
685: END IF;
686:
687: IF wms_plan_tasks_pvt.g_from_number_of_order_lines IS NOT NULL
688: THEN

Line 689: DBMS_SQL.bind_variable (l_query_handle,'from_number_of_order_lines',wms_plan_tasks_pvt.g_from_number_of_order_lines);

685: END IF;
686:
687: IF wms_plan_tasks_pvt.g_from_number_of_order_lines IS NOT NULL
688: THEN
689: DBMS_SQL.bind_variable (l_query_handle,'from_number_of_order_lines',wms_plan_tasks_pvt.g_from_number_of_order_lines);
690: END IF;
691:
692: IF wms_plan_tasks_pvt.g_to_number_of_order_lines IS NOT NULL
693: THEN

Line 694: DBMS_SQL.bind_variable (l_query_handle,'to_number_of_order_lines',wms_plan_tasks_pvt.g_to_number_of_order_lines);

690: END IF;
691:
692: IF wms_plan_tasks_pvt.g_to_number_of_order_lines IS NOT NULL
693: THEN
694: DBMS_SQL.bind_variable (l_query_handle,'to_number_of_order_lines',wms_plan_tasks_pvt.g_to_number_of_order_lines);
695: END IF;
696:
697: END IF;
698:

Line 704: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 1, l_wms_task_type);

700: IF l_debug = 1 THEN
701: debug('end setting the bind variables ','query_inbound');
702: END IF;
703: IF p_summary_mode = 1 THEN
704: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 1, l_wms_task_type);
705: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);
706: END IF;
707:
708: l_query_count := DBMS_SQL.EXECUTE(l_query_handle);

Line 705: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);

701: debug('end setting the bind variables ','query_inbound');
702: END IF;
703: IF p_summary_mode = 1 THEN
704: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 1, l_wms_task_type);
705: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);
706: END IF;
707:
708: l_query_count := DBMS_SQL.EXECUTE(l_query_handle);
709: IF p_summary_mode = 1 THEN

Line 708: l_query_count := DBMS_SQL.EXECUTE(l_query_handle);

704: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 1, l_wms_task_type);
705: DBMS_SQL.DEFINE_COLUMN(l_query_handle, 2, l_task_count);
706: END IF;
707:
708: l_query_count := DBMS_SQL.EXECUTE(l_query_handle);
709: IF p_summary_mode = 1 THEN
710: LOOP
711: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN
712: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);

Line 711: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN

707:
708: l_query_count := DBMS_SQL.EXECUTE(l_query_handle);
709: IF p_summary_mode = 1 THEN
710: LOOP
711: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN
712: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);
713: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);
714: IF l_debug = 1 THEN
715: debug(' l_wms_task_type : ' || l_wms_task_type, 'query_inbound');

Line 712: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);

708: l_query_count := DBMS_SQL.EXECUTE(l_query_handle);
709: IF p_summary_mode = 1 THEN
710: LOOP
711: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN
712: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);
713: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);
714: IF l_debug = 1 THEN
715: debug(' l_wms_task_type : ' || l_wms_task_type, 'query_inbound');
716: debug(' l_wms_task_count : ' || l_task_count, 'query_inbound');

Line 713: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);

709: IF p_summary_mode = 1 THEN
710: LOOP
711: IF DBMS_SQL.FETCH_ROWS(l_query_handle)>0 THEN
712: DBMS_SQL.COLUMN_VALUE(l_query_handle, 1, l_wms_task_type);
713: DBMS_SQL.COLUMN_VALUE(l_query_handle, 2, l_task_count);
714: IF l_debug = 1 THEN
715: debug(' l_wms_task_type : ' || l_wms_task_type, 'query_inbound');
716: debug(' l_wms_task_count : ' || l_task_count, 'query_inbound');
717: END IF;

Line 745: l_query_handle := DBMS_SQL.open_cursor;

741: l_plans_query := l_insert_str || l_plans_query_str;
742: IF l_debug = 1 THEN
743: debug('l_plans_query ' || l_plans_query,'query_inbound');
744: END IF;
745: l_query_handle := DBMS_SQL.open_cursor;
746: DBMS_SQL.parse(l_query_handle, l_plans_query, DBMS_SQL.native);
747:
748: /* Set the bind variables now */
749: IF wms_plan_tasks_pvt.g_organization_id IS NOT NULL THEN

Line 746: DBMS_SQL.parse(l_query_handle, l_plans_query, DBMS_SQL.native);

742: IF l_debug = 1 THEN
743: debug('l_plans_query ' || l_plans_query,'query_inbound');
744: END IF;
745: l_query_handle := DBMS_SQL.open_cursor;
746: DBMS_SQL.parse(l_query_handle, l_plans_query, DBMS_SQL.native);
747:
748: /* Set the bind variables now */
749: IF wms_plan_tasks_pvt.g_organization_id IS NOT NULL THEN
750: IF l_debug = 1 THEN

Line 753: dbms_sql.bind_variable(l_query_handle, 'org_id', wms_plan_tasks_pvt.g_organization_id);

749: IF wms_plan_tasks_pvt.g_organization_id IS NOT NULL THEN
750: IF l_debug = 1 THEN
751: debug('wms_plan_tasks_pvt.g_organization_id IS NOT NULL ','query_inbound');
752: END IF;
753: dbms_sql.bind_variable(l_query_handle, 'org_id', wms_plan_tasks_pvt.g_organization_id);
754: END IF;
755: IF wms_plan_tasks_pvt.g_subinventory_code IS NOT NULL THEN
756: IF l_debug = 1 THEN
757: debug('wms_plan_tasks_pvt.g_subinventory_code IS NOT NULL ','query_inbound');

Line 759: dbms_sql.bind_variable(l_query_handle, 'sub_code', wms_plan_tasks_pvt.g_subinventory_code);

755: IF wms_plan_tasks_pvt.g_subinventory_code IS NOT NULL THEN
756: IF l_debug = 1 THEN
757: debug('wms_plan_tasks_pvt.g_subinventory_code IS NOT NULL ','query_inbound');
758: END IF;
759: dbms_sql.bind_variable(l_query_handle, 'sub_code', wms_plan_tasks_pvt.g_subinventory_code);
760: END IF;
761: IF wms_plan_tasks_pvt.g_locator_id IS NOT NULL THEN
762: IF l_debug = 1 THEN
763: debug('wms_plan_tasks_pvt.g_locator_id IS NOT NULL ','query_inbound');

Line 765: dbms_sql.bind_variable(l_query_handle, 'loc_id', wms_plan_tasks_pvt.g_locator_id);

761: IF wms_plan_tasks_pvt.g_locator_id IS NOT NULL THEN
762: IF l_debug = 1 THEN
763: debug('wms_plan_tasks_pvt.g_locator_id IS NOT NULL ','query_inbound');
764: END IF;
765: dbms_sql.bind_variable(l_query_handle, 'loc_id', wms_plan_tasks_pvt.g_locator_id);
766: END IF;
767: IF wms_plan_tasks_pvt.g_to_subinventory_code IS NOT NULL THEN
768: IF l_debug = 1 THEN
769: debug('wms_plan_tasks_pvt.g_to_subinventory_code IS NOT NULL ','query_inbound');

Line 771: dbms_sql.bind_variable(l_query_handle, 'to_sub_code', wms_plan_tasks_pvt.g_to_subinventory_code );

767: IF wms_plan_tasks_pvt.g_to_subinventory_code IS NOT NULL THEN
768: IF l_debug = 1 THEN
769: debug('wms_plan_tasks_pvt.g_to_subinventory_code IS NOT NULL ','query_inbound');
770: END IF;
771: dbms_sql.bind_variable(l_query_handle, 'to_sub_code', wms_plan_tasks_pvt.g_to_subinventory_code );
772: END IF;
773: IF wms_plan_tasks_pvt.g_to_locator_id IS NOT NULL THEN
774: IF l_debug = 1 THEN
775: debug('wms_plan_tasks_pvt.g_to_locator_id IS NOT NULL ','query_inbound');

Line 777: dbms_sql.bind_variable(l_query_handle, 'to_loc_id', wms_plan_tasks_pvt.g_to_locator_id );

773: IF wms_plan_tasks_pvt.g_to_locator_id IS NOT NULL THEN
774: IF l_debug = 1 THEN
775: debug('wms_plan_tasks_pvt.g_to_locator_id IS NOT NULL ','query_inbound');
776: END IF;
777: dbms_sql.bind_variable(l_query_handle, 'to_loc_id', wms_plan_tasks_pvt.g_to_locator_id );
778: END IF;
779: IF wms_plan_tasks_pvt.g_inventory_item_id IS NOT NULL THEN
780: IF l_debug = 1 THEN
781: debug('wms_plan_tasks_pvt.g_inventory_item_id IS NOT NULL ','query_inbound');

Line 783: dbms_sql.bind_variable(l_query_handle, 'item_id', wms_plan_tasks_pvt.g_inventory_item_id );

779: IF wms_plan_tasks_pvt.g_inventory_item_id IS NOT NULL THEN
780: IF l_debug = 1 THEN
781: debug('wms_plan_tasks_pvt.g_inventory_item_id IS NOT NULL ','query_inbound');
782: END IF;
783: dbms_sql.bind_variable(l_query_handle, 'item_id', wms_plan_tasks_pvt.g_inventory_item_id );
784: END IF;
785: IF wms_plan_tasks_pvt.g_category_set_id IS NOT NULL THEN
786: IF l_debug = 1 THEN
787: debug('wms_plan_tasks_pvt.g_category_set_id IS NOT NULL ','query_inbound');

Line 789: dbms_sql.bind_variable(l_query_handle, 'category_set_id', wms_plan_tasks_pvt.g_category_set_id );

785: IF wms_plan_tasks_pvt.g_category_set_id IS NOT NULL THEN
786: IF l_debug = 1 THEN
787: debug('wms_plan_tasks_pvt.g_category_set_id IS NOT NULL ','query_inbound');
788: END IF;
789: dbms_sql.bind_variable(l_query_handle, 'category_set_id', wms_plan_tasks_pvt.g_category_set_id );
790: END IF;
791: IF wms_plan_tasks_pvt.g_item_category_id IS NOT NULL THEN
792: IF l_debug = 1 THEN
793: debug('wms_plan_tasks_pvt.g_item_category_id IS NOT NULL ','query_inbound');

Line 795: dbms_sql.bind_variable(l_query_handle, 'item_category_id', wms_plan_tasks_pvt.g_item_category_id );

791: IF wms_plan_tasks_pvt.g_item_category_id IS NOT NULL THEN
792: IF l_debug = 1 THEN
793: debug('wms_plan_tasks_pvt.g_item_category_id IS NOT NULL ','query_inbound');
794: END IF;
795: dbms_sql.bind_variable(l_query_handle, 'item_category_id', wms_plan_tasks_pvt.g_item_category_id );
796: END IF;
797: IF wms_plan_tasks_pvt.g_user_task_type_id IS NOT NULL THEN
798: IF l_debug = 1 THEN
799: debug('wms_plan_tasks_pvt.g_user_task_type_id IS NOT NULL ','query_inbound');

Line 801: dbms_sql.bind_variable(l_query_handle, 'user_task_type_id', wms_plan_tasks_pvt.g_user_task_type_id );

797: IF wms_plan_tasks_pvt.g_user_task_type_id IS NOT NULL THEN
798: IF l_debug = 1 THEN
799: debug('wms_plan_tasks_pvt.g_user_task_type_id IS NOT NULL ','query_inbound');
800: END IF;
801: dbms_sql.bind_variable(l_query_handle, 'user_task_type_id', wms_plan_tasks_pvt.g_user_task_type_id );
802: END IF;
803: IF wms_plan_tasks_pvt.g_from_task_quantity IS NOT NULL THEN
804: IF l_debug = 1 THEN
805: debug('wms_plan_tasks_pvt.g_from_task_quantity IS NOT NULL ','query_inbound');

Line 807: dbms_sql.bind_variable(l_query_handle, 'from_task_quantity', wms_plan_tasks_pvt.g_from_task_quantity );

803: IF wms_plan_tasks_pvt.g_from_task_quantity IS NOT NULL THEN
804: IF l_debug = 1 THEN
805: debug('wms_plan_tasks_pvt.g_from_task_quantity IS NOT NULL ','query_inbound');
806: END IF;
807: dbms_sql.bind_variable(l_query_handle, 'from_task_quantity', wms_plan_tasks_pvt.g_from_task_quantity );
808: END IF;
809: IF wms_plan_tasks_pvt.g_to_task_quantity IS NOT NULL THEN
810: IF l_debug = 1 THEN
811: debug('wms_plan_tasks_pvt.g_to_task_quantity IS NOT NULL ','query_inbound');

Line 813: dbms_sql.bind_variable(l_query_handle, 'to_task_quantity', wms_plan_tasks_pvt.g_to_task_quantity );

809: IF wms_plan_tasks_pvt.g_to_task_quantity IS NOT NULL THEN
810: IF l_debug = 1 THEN
811: debug('wms_plan_tasks_pvt.g_to_task_quantity IS NOT NULL ','query_inbound');
812: END IF;
813: dbms_sql.bind_variable(l_query_handle, 'to_task_quantity', wms_plan_tasks_pvt.g_to_task_quantity );
814: END IF;
815: IF wms_plan_tasks_pvt.g_from_task_priority IS NOT NULL THEN
816: IF l_debug = 1 THEN
817: debug('wms_plan_tasks_pvt.g_from_task_priority IS NOT NULL ','query_inbound');

Line 819: dbms_sql.bind_variable(l_query_handle, 'from_task_priority', wms_plan_tasks_pvt.g_from_task_priority );

815: IF wms_plan_tasks_pvt.g_from_task_priority IS NOT NULL THEN
816: IF l_debug = 1 THEN
817: debug('wms_plan_tasks_pvt.g_from_task_priority IS NOT NULL ','query_inbound');
818: END IF;
819: dbms_sql.bind_variable(l_query_handle, 'from_task_priority', wms_plan_tasks_pvt.g_from_task_priority );
820: END IF;
821:
822: IF wms_plan_tasks_pvt.g_to_task_priority IS NOT NULL THEN
823: IF l_debug = 1 THEN

Line 826: dbms_sql.bind_variable(l_query_handle, 'to_task_priority', wms_plan_tasks_pvt.g_to_task_priority );

822: IF wms_plan_tasks_pvt.g_to_task_priority IS NOT NULL THEN
823: IF l_debug = 1 THEN
824: debug('wms_plan_tasks_pvt.g_to_task_priority IS NOT NULL ','query_inbound');
825: END IF;
826: dbms_sql.bind_variable(l_query_handle, 'to_task_priority', wms_plan_tasks_pvt.g_to_task_priority );
827: END IF;
828: IF wms_plan_tasks_pvt.g_from_creation_date IS NOT NULL THEN
829: IF l_debug = 1 THEN
830: debug('wms_plan_tasks_pvt.g_from_creation_date IS NOT NULL ','query_inbound');

Line 832: dbms_sql.bind_variable(l_query_handle, 'from_creation_date', wms_plan_tasks_pvt.g_from_creation_date );

828: IF wms_plan_tasks_pvt.g_from_creation_date IS NOT NULL THEN
829: IF l_debug = 1 THEN
830: debug('wms_plan_tasks_pvt.g_from_creation_date IS NOT NULL ','query_inbound');
831: END IF;
832: dbms_sql.bind_variable(l_query_handle, 'from_creation_date', wms_plan_tasks_pvt.g_from_creation_date );
833: END IF;
834: IF wms_plan_tasks_pvt.g_to_creation_date IS NOT NULL THEN
835: IF l_debug = 1 THEN
836: debug('wms_plan_tasks_pvt.g_to_creation_date IS NOT NULL ','query_inbound');

Line 838: dbms_sql.bind_variable(l_query_handle, 'to_creation_date', wms_plan_tasks_pvt.g_to_creation_date );

834: IF wms_plan_tasks_pvt.g_to_creation_date IS NOT NULL THEN
835: IF l_debug = 1 THEN
836: debug('wms_plan_tasks_pvt.g_to_creation_date IS NOT NULL ','query_inbound');
837: END IF;
838: dbms_sql.bind_variable(l_query_handle, 'to_creation_date', wms_plan_tasks_pvt.g_to_creation_date );
839: END IF;
840: IF wms_plan_tasks_pvt.g_plan_type_id IS NOT NULL THEN
841: IF l_debug = 1 THEN
842: debug('wms_plan_tasks_pvt.g_plan_type_id IS NOT NULL ','query_inbound');

Line 844: dbms_sql.bind_variable(l_query_handle, 'plan_type_id', wms_plan_tasks_pvt.g_plan_type_id );

840: IF wms_plan_tasks_pvt.g_plan_type_id IS NOT NULL THEN
841: IF l_debug = 1 THEN
842: debug('wms_plan_tasks_pvt.g_plan_type_id IS NOT NULL ','query_inbound');
843: END IF;
844: dbms_sql.bind_variable(l_query_handle, 'plan_type_id', wms_plan_tasks_pvt.g_plan_type_id );
845: END IF;
846: IF wms_plan_tasks_pvt.g_op_plan_id IS NOT NULL THEN
847: IF l_debug = 1 THEN
848: debug('wms_plan_tasks_pvt.g_op_plan_id IS NOT NULL ','query_inbound');

Line 850: dbms_sql.bind_variable(l_query_handle, 'op_plan_id', wms_plan_tasks_pvt.g_op_plan_id );

846: IF wms_plan_tasks_pvt.g_op_plan_id IS NOT NULL THEN
847: IF l_debug = 1 THEN
848: debug('wms_plan_tasks_pvt.g_op_plan_id IS NOT NULL ','query_inbound');
849: END IF;
850: dbms_sql.bind_variable(l_query_handle, 'op_plan_id', wms_plan_tasks_pvt.g_op_plan_id );
851: END IF;
852: /* end setting the bind variables */
853: IF l_debug = 1 THEN
854: debug('end setting the bind variables for plans query','query_inbound');

Line 856: l_query_count := DBMS_SQL.EXECUTE(l_query_handle);

852: /* end setting the bind variables */
853: IF l_debug = 1 THEN
854: debug('end setting the bind variables for plans query','query_inbound');
855: END IF;
856: l_query_count := DBMS_SQL.EXECUTE(l_query_handle);
857: IF l_debug = 1 THEN
858: debug('l_query_count after executing the plans query ' || l_query_count ,'query_inbound');
859: END IF;
860: wms_plan_tasks_pvt.g_plans_tasks_record_count :=