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 486: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

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

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

581: --OE_DEBUG_PUB.Add(substr(l_stmt,1,length(l_stmt)),1);
582: IF g_debug <= gme_debug.g_log_procedure THEN
583: gme_debug.put_line(substr(l_stmt,1,length(l_stmt)),1);
584: END IF;
585: DBMS_SQL.PARSE(l_cursor_id,l_stmt,DBMS_SQL.NATIVE);
586:
587: FND_FILE.Put_Line(FND_FILE.LOG, 'GME parse done now');
588: IF g_debug <= gme_debug.g_log_procedure THEN
589: gme_debug.put_line('PARSE done ');

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

590: gme_debug.put_line('Start processing bind variables ');
591: END IF;
592: -- ================= BIND VARIABLES ======================
593: IF p_org_id IS NOT NULL THEN
594: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':org_id',p_org_id);
595: END IF;
596: IF p_line_id IS NOT NULL THEN
597: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':line_id',p_line_id);
598: END IF;

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

593: IF p_org_id IS NOT NULL THEN
594: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':org_id',p_org_id);
595: END IF;
596: IF p_line_id IS NOT NULL THEN
597: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':line_id',p_line_id);
598: END IF;
599: IF p_order_number_low IS NOT NULL THEN
600: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_low',p_order_number_low);
601: END IF;

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

596: IF p_line_id IS NOT NULL THEN
597: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':line_id',p_line_id);
598: END IF;
599: IF p_order_number_low IS NOT NULL THEN
600: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_low',p_order_number_low);
601: END IF;
602: IF p_order_number_high IS NOT NULL THEN
603: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_high',p_order_number_high);
604: END IF;

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

599: IF p_order_number_low IS NOT NULL THEN
600: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_low',p_order_number_low);
601: END IF;
602: IF p_order_number_high IS NOT NULL THEN
603: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_high',p_order_number_high);
604: END IF;
605: IF p_customer_id IS NOT NULL THEN
606: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':customer_id',p_customer_id);
607: END IF;

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

602: IF p_order_number_high IS NOT NULL THEN
603: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_high',p_order_number_high);
604: END IF;
605: IF p_customer_id IS NOT NULL THEN
606: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':customer_id',p_customer_id);
607: END IF;
608: IF p_order_type IS NOT NULL THEN
609: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_type',p_order_type);
610: END IF;

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

605: IF p_customer_id IS NOT NULL THEN
606: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':customer_id',p_customer_id);
607: END IF;
608: IF p_order_type IS NOT NULL THEN
609: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_type',p_order_type);
610: END IF;
611: IF l_ordered_date_low IS NOT NULL THEN
612: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':ordered_date_low',l_ordered_date_low);
613: END IF;

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

608: IF p_order_type IS NOT NULL THEN
609: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_type',p_order_type);
610: END IF;
611: IF l_ordered_date_low IS NOT NULL THEN
612: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':ordered_date_low',l_ordered_date_low);
613: END IF;
614: IF l_ordered_date_high IS NOT NULL THEN
615: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':ordered_date_high',l_ordered_date_high);
616: END IF;

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

611: IF l_ordered_date_low IS NOT NULL THEN
612: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':ordered_date_low',l_ordered_date_low);
613: END IF;
614: IF l_ordered_date_high IS NOT NULL THEN
615: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':ordered_date_high',l_ordered_date_high);
616: END IF;
617: IF p_line_type_id IS NOT NULL THEN
618: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':line_type_id',p_line_type_id);
619: END IF;

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

614: IF l_ordered_date_high IS NOT NULL THEN
615: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':ordered_date_high',l_ordered_date_high);
616: END IF;
617: IF p_line_type_id IS NOT NULL THEN
618: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':line_type_id',p_line_type_id);
619: END IF;
620: IF p_warehouse IS NOT NULL THEN
621: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':warehouse',p_warehouse);
622: END IF;

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

617: IF p_line_type_id IS NOT NULL THEN
618: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':line_type_id',p_line_type_id);
619: END IF;
620: IF p_warehouse IS NOT NULL THEN
621: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':warehouse',p_warehouse);
622: END IF;
623: IF l_request_date_low IS NOT NULL THEN
624: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_date_low',l_request_date_low);
625: END IF;

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

620: IF p_warehouse IS NOT NULL THEN
621: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':warehouse',p_warehouse);
622: END IF;
623: IF l_request_date_low IS NOT NULL THEN
624: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_date_low',l_request_date_low);
625: END IF;
626: IF l_request_date_high IS NOT NULL THEN
627: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_date_high',l_request_date_high);
628: END IF;

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

623: IF l_request_date_low IS NOT NULL THEN
624: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_date_low',l_request_date_low);
625: END IF;
626: IF l_request_date_high IS NOT NULL THEN
627: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_date_high',l_request_date_high);
628: END IF;
629: IF l_schedule_ship_date_low IS NOT NULL THEN
630: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_ship_date_low',l_schedule_ship_date_low);
631: END IF;

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

626: IF l_request_date_high IS NOT NULL THEN
627: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_date_high',l_request_date_high);
628: END IF;
629: IF l_schedule_ship_date_low IS NOT NULL THEN
630: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_ship_date_low',l_schedule_ship_date_low);
631: END IF;
632: IF l_schedule_ship_date_high IS NOT NULL THEN
633: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_ship_date_high',l_schedule_ship_date_high);
634: END IF;

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

629: IF l_schedule_ship_date_low IS NOT NULL THEN
630: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_ship_date_low',l_schedule_ship_date_low);
631: END IF;
632: IF l_schedule_ship_date_high IS NOT NULL THEN
633: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_ship_date_high',l_schedule_ship_date_high);
634: END IF;
635: IF l_schedule_arrival_date_low IS NOT NULL THEN
636: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_arrival_date_low',l_schedule_arrival_date_low);
637: END IF;

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

632: IF l_schedule_ship_date_high IS NOT NULL THEN
633: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_ship_date_high',l_schedule_ship_date_high);
634: END IF;
635: IF l_schedule_arrival_date_low IS NOT NULL THEN
636: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_arrival_date_low',l_schedule_arrival_date_low);
637: END IF;
638: IF l_schedule_arrival_date_high IS NOT NULL THEN
639: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_arrival_date_high',l_schedule_arrival_date_high);
640: END IF;

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

635: IF l_schedule_arrival_date_low IS NOT NULL THEN
636: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_arrival_date_low',l_schedule_arrival_date_low);
637: END IF;
638: IF l_schedule_arrival_date_high IS NOT NULL THEN
639: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_arrival_date_high',l_schedule_arrival_date_high);
640: END IF;
641: IF p_inventory_item_id IS NOT NULL THEN
642: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':inventory_item_id',p_inventory_item_id);
643: END IF;

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

638: IF l_schedule_arrival_date_high IS NOT NULL THEN
639: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_arrival_date_high',l_schedule_arrival_date_high);
640: END IF;
641: IF p_inventory_item_id IS NOT NULL THEN
642: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':inventory_item_id',p_inventory_item_id);
643: END IF;
644: IF p_demand_class_code IS NOT NULL THEN
645: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':demand_class_code',p_demand_class_code);
646: END IF;

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

641: IF p_inventory_item_id IS NOT NULL THEN
642: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':inventory_item_id',p_inventory_item_id);
643: END IF;
644: IF p_demand_class_code IS NOT NULL THEN
645: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':demand_class_code',p_demand_class_code);
646: END IF;
647: IF p_planning_priority IS NOT NULL THEN
648: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':planning_priority',p_planning_priority);
649: END IF;

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

644: IF p_demand_class_code IS NOT NULL THEN
645: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':demand_class_code',p_demand_class_code);
646: END IF;
647: IF p_planning_priority IS NOT NULL THEN
648: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':planning_priority',p_planning_priority);
649: END IF;
650: --R12.MOAC
651: IF g_debug <= gme_debug.g_log_procedure THEN
652: gme_debug.put_line('bind variables done');

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

653: gme_debug.put_line('start output variables ');
654: END IF;
655:
656: -- ================= OUTPUT VARIABLES ======================
657: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_line_id);
658:
659: -- ================= EXECUTE ==========================
660: IF g_debug <= gme_debug.g_log_procedure THEN
661: gme_debug.put_line(substr(l_stmt,1,length(l_stmt)),1);

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

661: gme_debug.put_line(substr(l_stmt,1,length(l_stmt)),1);
662: END IF;
663: FND_FILE.Put_Line(FND_FILE.LOG, 'EXECUTE data retrieval ');
664:
665: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);
666:
667: -- ================= PROCESS ORDER LINES ==================
668: IF g_debug <= gme_debug.g_log_procedure THEN
669: gme_debug.put_line('Start looping through rows here');

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

668: IF g_debug <= gme_debug.g_log_procedure THEN
669: gme_debug.put_line('Start looping through rows here');
670: END IF;
671: LOOP
672: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
673: FND_FILE.Put_Line(FND_FILE.LOG, 'Zero order line rows to process so exit');
674: EXIT;
675: END IF;
676: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_line_id);

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

672: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
673: FND_FILE.Put_Line(FND_FILE.LOG, 'Zero order line rows to process so exit');
674: EXIT;
675: END IF;
676: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_line_id);
677:
678: FND_FILE.Put_Line(FND_FILE.LOG, '***** Processing Line id '|| l_line_id||' *****');
679: l_return_status := FND_API.G_RET_STS_SUCCESS;
680: OE_LINE_UTIL.Lock_Row

Line 756: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

752:
753: <>
754: NULL;
755: END LOOP; -- End of lines_cur
756: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
757:
758: FND_FILE.Put_Line(FND_FILE.LOG, 'End of processing for OPM Make to Order');
759: COMMIT;
760: