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

Line 2435: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

2431: MO_GLOBAL.set_policy_context(p_access_mode => 'S', p_org_id => p_org_id);
2432: END IF;
2433: -- Moac End
2434:
2435: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
2436: IF p_reserve_run_type ='CREATE_RESERVATION' THEN --Pack J
2437: l_stmt := 'SELECT Line_id FROM OE_Reservation_Sets_V rset WHERE '||
2438: 'rset.reservation_set_name=:reservation_set_name';
2439:

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

2564: END IF;
2565:
2566: -- OE_DEBUG_PUB.Add(substr(l_stmt,1,length(l_stmt)),1);
2567:
2568: DBMS_SQL.PARSE(l_cursor_id,l_stmt,DBMS_SQL.NATIVE);
2569:
2570: -- Bind variables
2571: -- 4287740
2572: IF p_reserve_run_type <> 'CREATE_RESERVATION' OR p_reserve_run_type IS NULL THEN

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

2572: IF p_reserve_run_type <> 'CREATE_RESERVATION' OR p_reserve_run_type IS NULL THEN
2573:
2574: -- Moac start
2575: IF p_org_id IS NOT NULL THEN
2576: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':org_id',p_org_id);
2577: END IF;
2578: -- Moac end
2579:
2580: IF p_order_number_low IS NOT NULL THEN

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

2577: END IF;
2578: -- Moac end
2579:
2580: IF p_order_number_low IS NOT NULL THEN
2581: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_low',p_order_number_low);
2582: END IF;
2583: IF p_order_number_high IS NOT NULL THEN
2584: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_high',p_order_number_high);
2585: END IF;

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

2580: IF p_order_number_low IS NOT NULL THEN
2581: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_low',p_order_number_low);
2582: END IF;
2583: IF p_order_number_high IS NOT NULL THEN
2584: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_high',p_order_number_high);
2585: END IF;
2586: IF p_customer_id IS NOT NULL THEN
2587: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':customer_id',p_customer_id);
2588: END IF;

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

2583: IF p_order_number_high IS NOT NULL THEN
2584: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_high',p_order_number_high);
2585: END IF;
2586: IF p_customer_id IS NOT NULL THEN
2587: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':customer_id',p_customer_id);
2588: END IF;
2589: IF p_order_type IS NOT NULL THEN
2590: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_type',p_order_type);
2591: END IF;

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

2586: IF p_customer_id IS NOT NULL THEN
2587: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':customer_id',p_customer_id);
2588: END IF;
2589: IF p_order_type IS NOT NULL THEN
2590: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_type',p_order_type);
2591: END IF;
2592: IF l_ordered_date_low IS NOT NULL THEN
2593: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':ordered_date_low',l_ordered_date_low);
2594: END IF;

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

2589: IF p_order_type IS NOT NULL THEN
2590: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_type',p_order_type);
2591: END IF;
2592: IF l_ordered_date_low IS NOT NULL THEN
2593: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':ordered_date_low',l_ordered_date_low);
2594: END IF;
2595: IF l_ordered_date_high IS NOT NULL THEN
2596: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':ordered_date_high',l_ordered_date_high);
2597: END IF;

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

2592: IF l_ordered_date_low IS NOT NULL THEN
2593: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':ordered_date_low',l_ordered_date_low);
2594: END IF;
2595: IF l_ordered_date_high IS NOT NULL THEN
2596: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':ordered_date_high',l_ordered_date_high);
2597: END IF;
2598: IF p_line_type_id IS NOT NULL THEN
2599: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':line_type_id',p_line_type_id);
2600: END IF;

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

2595: IF l_ordered_date_high IS NOT NULL THEN
2596: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':ordered_date_high',l_ordered_date_high);
2597: END IF;
2598: IF p_line_type_id IS NOT NULL THEN
2599: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':line_type_id',p_line_type_id);
2600: END IF;
2601: IF p_warehouse IS NOT NULL THEN
2602: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':warehouse',p_warehouse);
2603: END IF;

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

2598: IF p_line_type_id IS NOT NULL THEN
2599: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':line_type_id',p_line_type_id);
2600: END IF;
2601: IF p_warehouse IS NOT NULL THEN
2602: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':warehouse',p_warehouse);
2603: END IF;
2604: IF l_request_date_low IS NOT NULL THEN
2605: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_date_low',l_request_date_low);
2606: END IF;

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

2601: IF p_warehouse IS NOT NULL THEN
2602: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':warehouse',p_warehouse);
2603: END IF;
2604: IF l_request_date_low IS NOT NULL THEN
2605: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_date_low',l_request_date_low);
2606: END IF;
2607: IF l_request_date_high IS NOT NULL THEN
2608: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_date_high',l_request_date_high);
2609: END IF;

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

2604: IF l_request_date_low IS NOT NULL THEN
2605: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_date_low',l_request_date_low);
2606: END IF;
2607: IF l_request_date_high IS NOT NULL THEN
2608: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_date_high',l_request_date_high);
2609: END IF;
2610: IF l_schedule_ship_date_low IS NOT NULL THEN
2611: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_ship_date_low',l_schedule_ship_date_low);
2612: END IF;

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

2607: IF l_request_date_high IS NOT NULL THEN
2608: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_date_high',l_request_date_high);
2609: END IF;
2610: IF l_schedule_ship_date_low IS NOT NULL THEN
2611: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_ship_date_low',l_schedule_ship_date_low);
2612: END IF;
2613: IF l_schedule_ship_date_high IS NOT NULL THEN
2614: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_ship_date_high',l_schedule_ship_date_high);
2615: END IF;

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

2610: IF l_schedule_ship_date_low IS NOT NULL THEN
2611: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_ship_date_low',l_schedule_ship_date_low);
2612: END IF;
2613: IF l_schedule_ship_date_high IS NOT NULL THEN
2614: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_ship_date_high',l_schedule_ship_date_high);
2615: END IF;
2616: IF l_schedule_arrival_date_low IS NOT NULL THEN
2617: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_arrival_date_low',l_schedule_arrival_date_low);
2618: END IF;

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

2613: IF l_schedule_ship_date_high IS NOT NULL THEN
2614: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_ship_date_high',l_schedule_ship_date_high);
2615: END IF;
2616: IF l_schedule_arrival_date_low IS NOT NULL THEN
2617: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_arrival_date_low',l_schedule_arrival_date_low);
2618: END IF;
2619: IF l_schedule_arrival_date_high IS NOT NULL THEN
2620: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_arrival_date_high',l_schedule_arrival_date_high);
2621: END IF;

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

2616: IF l_schedule_arrival_date_low IS NOT NULL THEN
2617: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_arrival_date_low',l_schedule_arrival_date_low);
2618: END IF;
2619: IF l_schedule_arrival_date_high IS NOT NULL THEN
2620: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_arrival_date_high',l_schedule_arrival_date_high);
2621: END IF;
2622: IF p_inventory_item_id IS NOT NULL THEN
2623: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':inventory_item_id',p_inventory_item_id);
2624: END IF;

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

2619: IF l_schedule_arrival_date_high IS NOT NULL THEN
2620: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_arrival_date_high',l_schedule_arrival_date_high);
2621: END IF;
2622: IF p_inventory_item_id IS NOT NULL THEN
2623: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':inventory_item_id',p_inventory_item_id);
2624: END IF;
2625: IF p_demand_class_code IS NOT NULL THEN
2626: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':demand_class_code',p_demand_class_code);
2627: END IF;

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

2622: IF p_inventory_item_id IS NOT NULL THEN
2623: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':inventory_item_id',p_inventory_item_id);
2624: END IF;
2625: IF p_demand_class_code IS NOT NULL THEN
2626: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':demand_class_code',p_demand_class_code);
2627: END IF;
2628: IF p_planning_priority IS NOT NULL THEN
2629: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':planning_priority',p_planning_priority);
2630: END IF;

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

2625: IF p_demand_class_code IS NOT NULL THEN
2626: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':demand_class_code',p_demand_class_code);
2627: END IF;
2628: IF p_planning_priority IS NOT NULL THEN
2629: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':planning_priority',p_planning_priority);
2630: END IF;
2631: IF p_shipment_priority IS NOT NULL THEN
2632: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':shipment_priority',p_shipment_priority);
2633: END IF;

Line 2632: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':shipment_priority',p_shipment_priority);

2628: IF p_planning_priority IS NOT NULL THEN
2629: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':planning_priority',p_planning_priority);
2630: END IF;
2631: IF p_shipment_priority IS NOT NULL THEN
2632: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':shipment_priority',p_shipment_priority);
2633: END IF;
2634: --R12.MOAC
2635: IF p_selected_ids IS NOT NULL THEN
2636: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':set_id',p_selected_ids);

Line 2636: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':set_id',p_selected_ids);

2632: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':shipment_priority',p_shipment_priority);
2633: END IF;
2634: --R12.MOAC
2635: IF p_selected_ids IS NOT NULL THEN
2636: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':set_id',p_selected_ids);
2637: END IF;
2638: ELSIF p_reserve_run_type ='CREATE_RESERVATION'
2639: AND p_reserve_set_name IS NOT NULL THEN --Pack J
2640: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':reservation_set_name',p_reserve_set_name);

Line 2640: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':reservation_set_name',p_reserve_set_name);

2636: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':set_id',p_selected_ids);
2637: END IF;
2638: ELSIF p_reserve_run_type ='CREATE_RESERVATION'
2639: AND p_reserve_set_name IS NOT NULL THEN --Pack J
2640: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':reservation_set_name',p_reserve_set_name);
2641: END IF;
2642:
2643: -- Define the output variables
2644: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_line_id);

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

2640: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':reservation_set_name',p_reserve_set_name);
2641: END IF;
2642:
2643: -- Define the output variables
2644: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_line_id);
2645:
2646: -- OE_DEBUG_PUB.Add(length(l_stmt));
2647: IF l_debug_level > 0 THEN
2648: OE_DEBUG_PUB.Add(substr(l_stmt,1,length(l_stmt)),1);

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

2646: -- OE_DEBUG_PUB.Add(length(l_stmt));
2647: IF l_debug_level > 0 THEN
2648: OE_DEBUG_PUB.Add(substr(l_stmt,1,length(l_stmt)),1);
2649: END IF;
2650: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);
2651:
2652: -- OPEN l_ref_cur_lines FOR l_stmt;
2653: LOOP
2654: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN

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

2650: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);
2651:
2652: -- OPEN l_ref_cur_lines FOR l_stmt;
2653: LOOP
2654: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
2655: EXIT;
2656: END IF;
2657: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_line_id);
2658:

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

2653: LOOP
2654: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
2655: EXIT;
2656: END IF;
2657: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_line_id);
2658:
2659: FND_FILE.Put_Line(FND_FILE.LOG, ' ');
2660: FND_FILE.Put_Line(FND_FILE.LOG, '***** Processing Line id '||
2661: l_Line_id||' *****');

Line 2811: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

2807:
2808: END IF; -- End of Lock Row
2809:
2810: END LOOP; -- End of lines_cur
2811: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
2812:
2813: --3710133
2814: --4287740 Added Not null check for reservation mode
2815: IF p_reservation_mode IS NOT NULL AND l_rsv_tbl.count = 0