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

Line 488: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

484: MO_GLOBAL.set_policy_context(p_access_mode => 'S', p_org_id => p_org_id);
485: END IF;
486: -- Moac End
487:
488: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
489: -- Start constructing retrieval syntax
490: IF g_debug <= gme_debug.g_log_procedure THEN
491: gme_debug.put_line('Start building retrieval syntax');
492: END IF;

Line 596: DBMS_SQL.PARSE(l_cursor_id,l_stmt,DBMS_SQL.NATIVE);

592: --OE_DEBUG_PUB.Add(substr(l_stmt,1,length(l_stmt)),1);
593: IF g_debug <= gme_debug.g_log_procedure THEN
594: gme_debug.put_line(substr(l_stmt,1,length(l_stmt)),1);
595: END IF;
596: DBMS_SQL.PARSE(l_cursor_id,l_stmt,DBMS_SQL.NATIVE);
597:
598: FND_FILE.Put_Line(FND_FILE.LOG, ' Query Built = '||
599: l_stmt );
600:

Line 608: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':org_id',p_org_id);

604: gme_debug.put_line('Start processing bind variables ');
605: END IF;
606: -- ================= BIND VARIABLES ======================
607: IF p_org_id IS NOT NULL THEN
608: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':org_id',p_org_id);
609: END IF;
610: IF p_line_id IS NOT NULL THEN
611: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':line_id',p_line_id);
612: END IF;

Line 611: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':line_id',p_line_id);

607: IF p_org_id IS NOT NULL THEN
608: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':org_id',p_org_id);
609: END IF;
610: IF p_line_id IS NOT NULL THEN
611: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':line_id',p_line_id);
612: END IF;
613: IF p_order_number_low IS NOT NULL THEN
614: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_low',p_order_number_low);
615: END IF;

Line 614: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_low',p_order_number_low);

610: IF p_line_id IS NOT NULL THEN
611: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':line_id',p_line_id);
612: END IF;
613: IF p_order_number_low IS NOT NULL THEN
614: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_low',p_order_number_low);
615: END IF;
616: IF p_order_number_high IS NOT NULL THEN
617: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_high',p_order_number_high);
618: END IF;

Line 617: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_high',p_order_number_high);

613: IF p_order_number_low IS NOT NULL THEN
614: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_low',p_order_number_low);
615: END IF;
616: IF p_order_number_high IS NOT NULL THEN
617: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_high',p_order_number_high);
618: END IF;
619: IF p_customer_id IS NOT NULL THEN
620: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':customer_id',p_customer_id);
621: END IF;

Line 620: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':customer_id',p_customer_id);

616: IF p_order_number_high IS NOT NULL THEN
617: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_high',p_order_number_high);
618: END IF;
619: IF p_customer_id IS NOT NULL THEN
620: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':customer_id',p_customer_id);
621: END IF;
622: IF p_order_type IS NOT NULL THEN
623: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_type',p_order_type);
624: END IF;

Line 623: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_type',p_order_type);

619: IF p_customer_id IS NOT NULL THEN
620: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':customer_id',p_customer_id);
621: END IF;
622: IF p_order_type IS NOT NULL THEN
623: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_type',p_order_type);
624: END IF;
625: IF l_ordered_date_low IS NOT NULL THEN
626: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':ordered_date_low',l_ordered_date_low);
627: END IF;

Line 626: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':ordered_date_low',l_ordered_date_low);

622: IF p_order_type IS NOT NULL THEN
623: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_type',p_order_type);
624: END IF;
625: IF l_ordered_date_low IS NOT NULL THEN
626: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':ordered_date_low',l_ordered_date_low);
627: END IF;
628: IF l_ordered_date_high IS NOT NULL THEN
629: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':ordered_date_high',l_ordered_date_high);
630: END IF;

Line 629: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':ordered_date_high',l_ordered_date_high);

625: IF l_ordered_date_low IS NOT NULL THEN
626: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':ordered_date_low',l_ordered_date_low);
627: END IF;
628: IF l_ordered_date_high IS NOT NULL THEN
629: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':ordered_date_high',l_ordered_date_high);
630: END IF;
631: IF p_line_type_id IS NOT NULL THEN
632: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':line_type_id',p_line_type_id);
633: END IF;

Line 632: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':line_type_id',p_line_type_id);

628: IF l_ordered_date_high IS NOT NULL THEN
629: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':ordered_date_high',l_ordered_date_high);
630: END IF;
631: IF p_line_type_id IS NOT NULL THEN
632: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':line_type_id',p_line_type_id);
633: END IF;
634: IF p_warehouse IS NOT NULL THEN
635: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':warehouse',p_warehouse);
636: END IF;

Line 635: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':warehouse',p_warehouse);

631: IF p_line_type_id IS NOT NULL THEN
632: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':line_type_id',p_line_type_id);
633: END IF;
634: IF p_warehouse IS NOT NULL THEN
635: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':warehouse',p_warehouse);
636: END IF;
637: IF l_request_date_low IS NOT NULL THEN
638: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_date_low',l_request_date_low);
639: END IF;

Line 638: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_date_low',l_request_date_low);

634: IF p_warehouse IS NOT NULL THEN
635: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':warehouse',p_warehouse);
636: END IF;
637: IF l_request_date_low IS NOT NULL THEN
638: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_date_low',l_request_date_low);
639: END IF;
640: IF l_request_date_high IS NOT NULL THEN
641: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_date_high',l_request_date_high);
642: END IF;

Line 641: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_date_high',l_request_date_high);

637: IF l_request_date_low IS NOT NULL THEN
638: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_date_low',l_request_date_low);
639: END IF;
640: IF l_request_date_high IS NOT NULL THEN
641: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_date_high',l_request_date_high);
642: END IF;
643: IF l_schedule_ship_date_low IS NOT NULL THEN
644: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_ship_date_low',l_schedule_ship_date_low);
645: END IF;

Line 644: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_ship_date_low',l_schedule_ship_date_low);

640: IF l_request_date_high IS NOT NULL THEN
641: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_date_high',l_request_date_high);
642: END IF;
643: IF l_schedule_ship_date_low IS NOT NULL THEN
644: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_ship_date_low',l_schedule_ship_date_low);
645: END IF;
646: IF l_schedule_ship_date_high IS NOT NULL THEN
647: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_ship_date_high',l_schedule_ship_date_high);
648: END IF;

Line 647: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_ship_date_high',l_schedule_ship_date_high);

643: IF l_schedule_ship_date_low IS NOT NULL THEN
644: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_ship_date_low',l_schedule_ship_date_low);
645: END IF;
646: IF l_schedule_ship_date_high IS NOT NULL THEN
647: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_ship_date_high',l_schedule_ship_date_high);
648: END IF;
649: IF l_schedule_arrival_date_low IS NOT NULL THEN
650: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_arrival_date_low',l_schedule_arrival_date_low);
651: END IF;

Line 650: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_arrival_date_low',l_schedule_arrival_date_low);

646: IF l_schedule_ship_date_high IS NOT NULL THEN
647: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_ship_date_high',l_schedule_ship_date_high);
648: END IF;
649: IF l_schedule_arrival_date_low IS NOT NULL THEN
650: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_arrival_date_low',l_schedule_arrival_date_low);
651: END IF;
652: IF l_schedule_arrival_date_high IS NOT NULL THEN
653: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_arrival_date_high',l_schedule_arrival_date_high);
654: END IF;

Line 653: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_arrival_date_high',l_schedule_arrival_date_high);

649: IF l_schedule_arrival_date_low IS NOT NULL THEN
650: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_arrival_date_low',l_schedule_arrival_date_low);
651: END IF;
652: IF l_schedule_arrival_date_high IS NOT NULL THEN
653: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_arrival_date_high',l_schedule_arrival_date_high);
654: END IF;
655: IF p_inventory_item_id IS NOT NULL THEN
656: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':inventory_item_id',p_inventory_item_id);
657: END IF;

Line 656: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':inventory_item_id',p_inventory_item_id);

652: IF l_schedule_arrival_date_high IS NOT NULL THEN
653: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_arrival_date_high',l_schedule_arrival_date_high);
654: END IF;
655: IF p_inventory_item_id IS NOT NULL THEN
656: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':inventory_item_id',p_inventory_item_id);
657: END IF;
658: IF p_demand_class_code IS NOT NULL THEN
659: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':demand_class_code',p_demand_class_code);
660: END IF;

Line 659: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':demand_class_code',p_demand_class_code);

655: IF p_inventory_item_id IS NOT NULL THEN
656: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':inventory_item_id',p_inventory_item_id);
657: END IF;
658: IF p_demand_class_code IS NOT NULL THEN
659: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':demand_class_code',p_demand_class_code);
660: END IF;
661: IF p_planning_priority IS NOT NULL THEN
662: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':planning_priority',p_planning_priority);
663: END IF;

Line 662: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':planning_priority',p_planning_priority);

658: IF p_demand_class_code IS NOT NULL THEN
659: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':demand_class_code',p_demand_class_code);
660: END IF;
661: IF p_planning_priority IS NOT NULL THEN
662: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':planning_priority',p_planning_priority);
663: END IF;
664: --R12.MOAC
665: IF g_debug <= gme_debug.g_log_procedure THEN
666: gme_debug.put_line('bind variables done');

Line 671: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_line_id);

667: gme_debug.put_line('start output variables ');
668: END IF;
669:
670: -- ================= OUTPUT VARIABLES ======================
671: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_line_id);
672:
673: -- ================= EXECUTE ==========================
674: IF g_debug <= gme_debug.g_log_procedure THEN
675: gme_debug.put_line(substr(l_stmt,1,length(l_stmt)),1);

Line 679: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);

675: gme_debug.put_line(substr(l_stmt,1,length(l_stmt)),1);
676: END IF;
677: FND_FILE.Put_Line(FND_FILE.LOG, 'EXECUTE data retrieval ');
678:
679: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);
680:
681: -- ================= PROCESS ORDER LINES ==================
682: IF g_debug <= gme_debug.g_log_procedure THEN
683: gme_debug.put_line('Start looping through rows here');

Line 688: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN

684: END IF;
685: LOOP
686:
687:
688: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
689: FND_FILE.Put_Line(FND_FILE.LOG, 'Zero order line rows to process so exit');
690: EXIT;
691: END IF;
692: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_line_id);

Line 692: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_line_id);

688: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
689: FND_FILE.Put_Line(FND_FILE.LOG, 'Zero order line rows to process so exit');
690: EXIT;
691: END IF;
692: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_line_id);
693:
694: FND_FILE.Put_Line(FND_FILE.LOG, '***** Processing Line id '|| l_line_id||' *****');
695: l_return_status := FND_API.G_RET_STS_SUCCESS;
696: OE_LINE_UTIL.Lock_Row

Line 774: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

770:
771: <>
772: NULL;
773: END LOOP; -- End of lines_cur
774: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
775:
776: FND_FILE.Put_Line(FND_FILE.LOG, 'End of processing for OPM Make to Order');
777: COMMIT;
778: