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

Line 455: c:= dbms_sql.open_cursor;

451: IF g_debug=1 THEN
452: debug('The l_sql finally constructed ','MATCH_RATE_TRX_RECORDS');
453: END IF;
454:
455: c:= dbms_sql.open_cursor;
456:
457: IF g_debug=1 THEN
458: debug('Opened the cursor for Binding ','MATCH_RATE_TRX_RECORDS');
459: END IF;

Line 461: DBMS_SQL.parse(c, l_sql, DBMS_SQL.native);

457: IF g_debug=1 THEN
458: debug('Opened the cursor for Binding ','MATCH_RATE_TRX_RECORDS');
459: END IF;
460:
461: DBMS_SQL.parse(c, l_sql, DBMS_SQL.native);
462:
463:
464: IF g_debug=1 THEN
465: debug('Starting Binding the variables ','MATCH_RATE_TRX_RECORDS');

Line 468: DBMS_SQL.bind_variable(c, 'l_max_id', l_max_id);

464: IF g_debug=1 THEN
465: debug('Starting Binding the variables ','MATCH_RATE_TRX_RECORDS');
466: END IF;
467:
468: DBMS_SQL.bind_variable(c, 'l_max_id', l_max_id);
469:
470: DBMS_SQL.bind_variable(c, 'els_data_id', l_els_data.els_data_id);
471:
472: DBMS_SQL.bind_variable(c, 'source_zone', l_els_data.source_zone_id);

Line 470: DBMS_SQL.bind_variable(c, 'els_data_id', l_els_data.els_data_id);

466: END IF;
467:
468: DBMS_SQL.bind_variable(c, 'l_max_id', l_max_id);
469:
470: DBMS_SQL.bind_variable(c, 'els_data_id', l_els_data.els_data_id);
471:
472: DBMS_SQL.bind_variable(c, 'source_zone', l_els_data.source_zone_id);
473:
474: DBMS_SQL.bind_variable(c, 'destination_zone', l_els_data.destination_zone_id);

Line 472: DBMS_SQL.bind_variable(c, 'source_zone', l_els_data.source_zone_id);

468: DBMS_SQL.bind_variable(c, 'l_max_id', l_max_id);
469:
470: DBMS_SQL.bind_variable(c, 'els_data_id', l_els_data.els_data_id);
471:
472: DBMS_SQL.bind_variable(c, 'source_zone', l_els_data.source_zone_id);
473:
474: DBMS_SQL.bind_variable(c, 'destination_zone', l_els_data.destination_zone_id);
475:
476: DBMS_SQL.bind_variable(c, 'item_category', l_els_data.item_category_id);

Line 474: DBMS_SQL.bind_variable(c, 'destination_zone', l_els_data.destination_zone_id);

470: DBMS_SQL.bind_variable(c, 'els_data_id', l_els_data.els_data_id);
471:
472: DBMS_SQL.bind_variable(c, 'source_zone', l_els_data.source_zone_id);
473:
474: DBMS_SQL.bind_variable(c, 'destination_zone', l_els_data.destination_zone_id);
475:
476: DBMS_SQL.bind_variable(c, 'item_category', l_els_data.item_category_id);
477:
478: DBMS_SQL.bind_variable(c, 'travel_time_threshold', l_els_data.travel_time_threshold);

Line 476: DBMS_SQL.bind_variable(c, 'item_category', l_els_data.item_category_id);

472: DBMS_SQL.bind_variable(c, 'source_zone', l_els_data.source_zone_id);
473:
474: DBMS_SQL.bind_variable(c, 'destination_zone', l_els_data.destination_zone_id);
475:
476: DBMS_SQL.bind_variable(c, 'item_category', l_els_data.item_category_id);
477:
478: DBMS_SQL.bind_variable(c, 'travel_time_threshold', l_els_data.travel_time_threshold);
479:
480: DBMS_SQL.bind_variable(c, 'org_id', p_org_id);

Line 478: DBMS_SQL.bind_variable(c, 'travel_time_threshold', l_els_data.travel_time_threshold);

474: DBMS_SQL.bind_variable(c, 'destination_zone', l_els_data.destination_zone_id);
475:
476: DBMS_SQL.bind_variable(c, 'item_category', l_els_data.item_category_id);
477:
478: DBMS_SQL.bind_variable(c, 'travel_time_threshold', l_els_data.travel_time_threshold);
479:
480: DBMS_SQL.bind_variable(c, 'org_id', p_org_id);
481:
482: DBMS_SQL.bind_variable(c, 'expected_trx_time', l_els_data.expected_txn_time);

Line 480: DBMS_SQL.bind_variable(c, 'org_id', p_org_id);

476: DBMS_SQL.bind_variable(c, 'item_category', l_els_data.item_category_id);
477:
478: DBMS_SQL.bind_variable(c, 'travel_time_threshold', l_els_data.travel_time_threshold);
479:
480: DBMS_SQL.bind_variable(c, 'org_id', p_org_id);
481:
482: DBMS_SQL.bind_variable(c, 'expected_trx_time', l_els_data.expected_txn_time);
483:
484: DBMS_SQL.bind_variable(c, 'expected_travel_time', l_els_data.expected_travel_time);

Line 482: DBMS_SQL.bind_variable(c, 'expected_trx_time', l_els_data.expected_txn_time);

478: DBMS_SQL.bind_variable(c, 'travel_time_threshold', l_els_data.travel_time_threshold);
479:
480: DBMS_SQL.bind_variable(c, 'org_id', p_org_id);
481:
482: DBMS_SQL.bind_variable(c, 'expected_trx_time', l_els_data.expected_txn_time);
483:
484: DBMS_SQL.bind_variable(c, 'expected_travel_time', l_els_data.expected_travel_time);
485:
486: DBMS_SQL.bind_variable(c, 'expected_idle_time', l_els_data.expected_idle_time);

Line 484: DBMS_SQL.bind_variable(c, 'expected_travel_time', l_els_data.expected_travel_time);

480: DBMS_SQL.bind_variable(c, 'org_id', p_org_id);
481:
482: DBMS_SQL.bind_variable(c, 'expected_trx_time', l_els_data.expected_txn_time);
483:
484: DBMS_SQL.bind_variable(c, 'expected_travel_time', l_els_data.expected_travel_time);
485:
486: DBMS_SQL.bind_variable(c, 'expected_idle_time', l_els_data.expected_idle_time);
487:
488: IF l_els_data.organization_id IS NOT NULL

Line 486: DBMS_SQL.bind_variable(c, 'expected_idle_time', l_els_data.expected_idle_time);

482: DBMS_SQL.bind_variable(c, 'expected_trx_time', l_els_data.expected_txn_time);
483:
484: DBMS_SQL.bind_variable(c, 'expected_travel_time', l_els_data.expected_travel_time);
485:
486: DBMS_SQL.bind_variable(c, 'expected_idle_time', l_els_data.expected_idle_time);
487:
488: IF l_els_data.organization_id IS NOT NULL
489: THEN
490: DBMS_SQL.bind_variable(c, 'organization_id', l_els_data.organization_id);

Line 490: DBMS_SQL.bind_variable(c, 'organization_id', l_els_data.organization_id);

486: DBMS_SQL.bind_variable(c, 'expected_idle_time', l_els_data.expected_idle_time);
487:
488: IF l_els_data.organization_id IS NOT NULL
489: THEN
490: DBMS_SQL.bind_variable(c, 'organization_id', l_els_data.organization_id);
491: END IF;
492:
493: IF l_els_data.activity_id IS NOT NULL
494: THEN

Line 495: DBMS_SQL.bind_variable(c, 'activity_id', l_els_data.activity_id);

491: END IF;
492:
493: IF l_els_data.activity_id IS NOT NULL
494: THEN
495: DBMS_SQL.bind_variable(c, 'activity_id', l_els_data.activity_id);
496: END IF;
497:
498: IF l_els_data.activity_detail_id IS NOT NULL
499: THEN

Line 500: DBMS_SQL.bind_variable(c, 'activity_detail_id', l_els_data.activity_detail_id);

496: END IF;
497:
498: IF l_els_data.activity_detail_id IS NOT NULL
499: THEN
500: DBMS_SQL.bind_variable(c, 'activity_detail_id', l_els_data.activity_detail_id);
501: END IF;
502:
503: IF l_els_data.operation_id IS NOT NULL
504: THEN

Line 505: DBMS_SQL.bind_variable(c, 'operation_id', l_els_data.operation_id);

501: END IF;
502:
503: IF l_els_data.operation_id IS NOT NULL
504: THEN
505: DBMS_SQL.bind_variable(c, 'operation_id', l_els_data.operation_id);
506: END IF;
507:
508: IF l_els_data.equipment_id IS NOT NULL
509: THEN

Line 510: DBMS_SQL.bind_variable(c, 'equipment_id', l_els_data.equipment_id);

506: END IF;
507:
508: IF l_els_data.equipment_id IS NOT NULL
509: THEN
510: DBMS_SQL.bind_variable(c, 'equipment_id', l_els_data.equipment_id);
511: END IF;
512:
513: IF l_els_data.source_zone_id IS NOT NULL
514: THEN

Line 515: DBMS_SQL.bind_variable(c, 'source_zone_id', l_els_data.source_zone_id);

511: END IF;
512:
513: IF l_els_data.source_zone_id IS NOT NULL
514: THEN
515: DBMS_SQL.bind_variable(c, 'source_zone_id', l_els_data.source_zone_id);
516: END IF;
517:
518: IF l_els_data.source_subinventory IS NOT NULL
519: THEN

Line 520: DBMS_SQL.bind_variable(c, 'source_subinventory', l_els_data.source_subinventory);

516: END IF;
517:
518: IF l_els_data.source_subinventory IS NOT NULL
519: THEN
520: DBMS_SQL.bind_variable(c, 'source_subinventory', l_els_data.source_subinventory);
521: END IF;
522:
523: IF l_els_data.destination_zone_id IS NOT NULL
524: THEN

Line 525: DBMS_SQL.bind_variable(c, 'destination_zone_id', l_els_data.destination_zone_id);

521: END IF;
522:
523: IF l_els_data.destination_zone_id IS NOT NULL
524: THEN
525: DBMS_SQL.bind_variable(c, 'destination_zone_id', l_els_data.destination_zone_id);
526: END IF;
527:
528: IF l_els_data.destination_subinventory IS NOT NULL
529: THEN

Line 530: DBMS_SQL.bind_variable(c, 'destination_subinventory', l_els_data.destination_subinventory);

526: END IF;
527:
528: IF l_els_data.destination_subinventory IS NOT NULL
529: THEN
530: DBMS_SQL.bind_variable(c, 'destination_subinventory', l_els_data.destination_subinventory);
531: END IF;
532:
533: IF l_els_data.labor_txn_source_id IS NOT NULL
534: THEN

Line 535: DBMS_SQL.bind_variable(c, 'labor_txn_source_id', l_els_data.labor_txn_source_id);

531: END IF;
532:
533: IF l_els_data.labor_txn_source_id IS NOT NULL
534: THEN
535: DBMS_SQL.bind_variable(c, 'labor_txn_source_id', l_els_data.labor_txn_source_id);
536: END IF;
537:
538: IF l_els_data.transaction_uom IS NOT NULL
539: THEN

Line 540: DBMS_SQL.bind_variable(c, 'transaction_uom', l_els_data.transaction_uom);

536: END IF;
537:
538: IF l_els_data.transaction_uom IS NOT NULL
539: THEN
540: DBMS_SQL.bind_variable(c, 'transaction_uom', l_els_data.transaction_uom);
541: END IF;
542:
543: IF l_els_data.from_quantity IS NOT NULL
544: THEN

Line 545: DBMS_SQL.bind_variable(c, 'from_quantity', l_els_data.from_quantity);

541: END IF;
542:
543: IF l_els_data.from_quantity IS NOT NULL
544: THEN
545: DBMS_SQL.bind_variable(c, 'from_quantity', l_els_data.from_quantity);
546: END IF;
547:
548: IF l_els_data.to_quantity IS NOT NULL
549: THEN

Line 550: DBMS_SQL.bind_variable(c, 'to_quantity', l_els_data.to_quantity);

546: END IF;
547:
548: IF l_els_data.to_quantity IS NOT NULL
549: THEN
550: DBMS_SQL.bind_variable(c, 'to_quantity', l_els_data.to_quantity);
551: END IF;
552:
553: IF l_els_data.item_category_id IS NOT NULL
554: THEN

Line 555: DBMS_SQL.bind_variable(c, 'item_category_id', l_els_data.item_category_id);

551: END IF;
552:
553: IF l_els_data.item_category_id IS NOT NULL
554: THEN
555: DBMS_SQL.bind_variable(c, 'item_category_id', l_els_data.item_category_id);
556: END IF;
557:
558: IF l_els_data.operation_plan_id IS NOT NULL
559: THEN

Line 560: DBMS_SQL.bind_variable(c, 'operation_plan_id', l_els_data.operation_plan_id);

556: END IF;
557:
558: IF l_els_data.operation_plan_id IS NOT NULL
559: THEN
560: DBMS_SQL.bind_variable(c, 'operation_plan_id', l_els_data.operation_plan_id);
561: END IF;
562:
563: IF l_els_data.group_id IS NOT NULL
564: THEN

Line 565: DBMS_SQL.bind_variable(c, 'group_id', l_els_data.group_id);

561: END IF;
562:
563: IF l_els_data.group_id IS NOT NULL
564: THEN
565: DBMS_SQL.bind_variable(c, 'group_id', l_els_data.group_id);
566: END IF;
567:
568: IF l_els_data.task_type_id IS NOT NULL
569: THEN

Line 570: DBMS_SQL.bind_variable(c, 'task_type_id', l_els_data.task_type_id);

566: END IF;
567:
568: IF l_els_data.task_type_id IS NOT NULL
569: THEN
570: DBMS_SQL.bind_variable(c, 'task_type_id', l_els_data.task_type_id);
571: END IF;
572:
573: IF l_els_data.task_method_id IS NOT NULL
574: THEN

Line 575: DBMS_SQL.bind_variable(c, 'task_method_id', l_els_data.task_method_id);

571: END IF;
572:
573: IF l_els_data.task_method_id IS NOT NULL
574: THEN
575: DBMS_SQL.bind_variable(c, 'task_method_id', l_els_data.task_method_id);
576: END IF;
577:
578: IF g_debug=1 THEN
579: debug('All variables bound '|| l_sql,'MATCH_RATE_TRX_RECORDS');

Line 582: l_update_count := DBMS_SQL.EXECUTE(c);

578: IF g_debug=1 THEN
579: debug('All variables bound '|| l_sql,'MATCH_RATE_TRX_RECORDS');
580: END IF;
581:
582: l_update_count := DBMS_SQL.EXECUTE(c);
583:
584: IF g_debug=1 THEN
585: debug('SQL executed Number of rows updated '|| l_update_count,'MATCH_RATE_TRX_RECORDS');
586: END IF;

Line 590: DBMS_SQL.close_cursor(c);

586: END IF;
587:
588: l_total := l_update_count + NVL(l_els_data.num_trx_matched,0);
589:
590: DBMS_SQL.close_cursor(c);
591:
592: --update the count with newly matched transactions
593:
594: UPDATE wms_els_individual_tasks_b

Line 785: c:= dbms_sql.open_cursor;

781: IF g_debug=1 THEN
782: debug('SQL clause built successfully '|| l_sql ,'MATCH_RATE_TRX_RECORDS');
783: END IF;
784:
785: c:= dbms_sql.open_cursor;
786:
787: DBMS_SQL.parse(c, l_sql, DBMS_SQL.native);
788:
789: IF g_debug=1 THEN

Line 787: DBMS_SQL.parse(c, l_sql, DBMS_SQL.native);

783: END IF;
784:
785: c:= dbms_sql.open_cursor;
786:
787: DBMS_SQL.parse(c, l_sql, DBMS_SQL.native);
788:
789: IF g_debug=1 THEN
790: debug('Start bining the variables '|| l_where_clause ,'MATCH_RATE_TRX_RECORDS');
791: END IF;

Line 793: DBMS_SQL.bind_variable(c, 'els_group_id', l_group_data.els_group_id);

789: IF g_debug=1 THEN
790: debug('Start bining the variables '|| l_where_clause ,'MATCH_RATE_TRX_RECORDS');
791: END IF;
792:
793: DBMS_SQL.bind_variable(c, 'els_group_id', l_group_data.els_group_id);
794:
795: IF l_group_data.organization_id IS NOT NULL
796: THEN
797: DBMS_SQL.bind_variable(c, 'organization_id', l_group_data.organization_id);

Line 797: DBMS_SQL.bind_variable(c, 'organization_id', l_group_data.organization_id);

793: DBMS_SQL.bind_variable(c, 'els_group_id', l_group_data.els_group_id);
794:
795: IF l_group_data.organization_id IS NOT NULL
796: THEN
797: DBMS_SQL.bind_variable(c, 'organization_id', l_group_data.organization_id);
798: END IF;
799:
800: IF l_group_data.activity_id IS NOT NULL
801: THEN

Line 802: DBMS_SQL.bind_variable(c, 'activity_id', l_group_data.activity_id);

798: END IF;
799:
800: IF l_group_data.activity_id IS NOT NULL
801: THEN
802: DBMS_SQL.bind_variable(c, 'activity_id', l_group_data.activity_id);
803: END IF;
804:
805: IF l_group_data.activity_detail_id IS NOT NULL
806: THEN

Line 807: DBMS_SQL.bind_variable(c, 'activity_detail_id', l_group_data.activity_detail_id);

803: END IF;
804:
805: IF l_group_data.activity_detail_id IS NOT NULL
806: THEN
807: DBMS_SQL.bind_variable(c, 'activity_detail_id', l_group_data.activity_detail_id);
808: END IF;
809:
810: IF l_group_data.operation_id IS NOT NULL
811: THEN

Line 812: DBMS_SQL.bind_variable(c, 'operation_id', l_group_data.operation_id);

808: END IF;
809:
810: IF l_group_data.operation_id IS NOT NULL
811: THEN
812: DBMS_SQL.bind_variable(c, 'operation_id', l_group_data.operation_id);
813: END IF;
814:
815: IF l_group_data.source_zone_id IS NOT NULL
816: THEN

Line 817: DBMS_SQL.bind_variable(c, 'source_zone_id', l_group_data.source_zone_id);

813: END IF;
814:
815: IF l_group_data.source_zone_id IS NOT NULL
816: THEN
817: DBMS_SQL.bind_variable(c, 'source_zone_id', l_group_data.source_zone_id);
818: END IF;
819:
820: IF l_group_data.source_subinventory IS NOT NULL
821: THEN

Line 822: DBMS_SQL.bind_variable(c, 'source_subinventory', l_group_data.source_subinventory);

818: END IF;
819:
820: IF l_group_data.source_subinventory IS NOT NULL
821: THEN
822: DBMS_SQL.bind_variable(c, 'source_subinventory', l_group_data.source_subinventory);
823: END IF;
824:
825: IF l_group_data.destination_zone_id IS NOT NULL
826: THEN

Line 827: DBMS_SQL.bind_variable(c, 'destination_zone_id', l_group_data.destination_zone_id);

823: END IF;
824:
825: IF l_group_data.destination_zone_id IS NOT NULL
826: THEN
827: DBMS_SQL.bind_variable(c, 'destination_zone_id', l_group_data.destination_zone_id);
828: END IF;
829:
830: IF l_group_data.destination_subinventory IS NOT NULL
831: THEN

Line 832: DBMS_SQL.bind_variable(c, 'destination_subinventory', l_group_data.destination_subinventory);

828: END IF;
829:
830: IF l_group_data.destination_subinventory IS NOT NULL
831: THEN
832: DBMS_SQL.bind_variable(c, 'destination_subinventory', l_group_data.destination_subinventory);
833: END IF;
834:
835: IF l_group_data.task_range_from IS NOT NULL
836: THEN

Line 837: DBMS_SQL.bind_variable(c, 'task_range_from', l_group_data.task_range_from);

833: END IF;
834:
835: IF l_group_data.task_range_from IS NOT NULL
836: THEN
837: DBMS_SQL.bind_variable(c, 'task_range_from', l_group_data.task_range_from);
838: END IF;
839:
840: IF l_group_data.task_range_to IS NOT NULL
841: THEN

Line 842: DBMS_SQL.bind_variable(c, 'task_range_to', l_group_data.task_range_to);

838: END IF;
839:
840: IF l_group_data.task_range_to IS NOT NULL
841: THEN
842: DBMS_SQL.bind_variable(c, 'task_range_to', l_group_data.task_range_to);
843: END IF;
844:
845: IF l_group_data.task_method_id IS NOT NULL
846: THEN

Line 847: DBMS_SQL.bind_variable(c, 'task_method_id', l_group_data.task_method_id);

843: END IF;
844:
845: IF l_group_data.task_method_id IS NOT NULL
846: THEN
847: DBMS_SQL.bind_variable(c, 'task_method_id', l_group_data.task_method_id);
848: END IF;
849:
850: IF g_debug=1 THEN
851: debug('All variables bound successfully','MATCH_RATE_TRX_RECORDS');

Line 854: l_update_count := DBMS_SQL.EXECUTE(c);

850: IF g_debug=1 THEN
851: debug('All variables bound successfully','MATCH_RATE_TRX_RECORDS');
852: END IF;
853:
854: l_update_count := DBMS_SQL.EXECUTE(c);
855:
856: IF g_debug=1 THEN
857: debug('SQL executed. Number of rows updated '|| l_update_count ,'MATCH_RATE_TRX_RECORDS');
858: END IF;

Line 860: DBMS_SQL.close_cursor(c);

856: IF g_debug=1 THEN
857: debug('SQL executed. Number of rows updated '|| l_update_count ,'MATCH_RATE_TRX_RECORDS');
858: END IF;
859:
860: DBMS_SQL.close_cursor(c);
861:
862: EXCEPTION
863: WHEN OTHERS THEN
864: