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

2378: MO_GLOBAL.set_policy_context(p_access_mode => 'S', p_org_id => p_org_id);
2379: END IF;
2380: -- Moac End
2381:
2382: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
2383: IF p_reserve_run_type ='CREATE_RESERVATION' THEN --Pack J
2384: l_stmt := 'SELECT Line_id FROM OE_Reservation_Sets_V rset WHERE '||
2385: 'rset.reservation_set_name=:reservation_set_name';
2386:

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

2498: l_stmt := l_stmt || ' ORDER BY l.inventory_item_id,l.ship_from_org_id,l.subinventory';
2499: END IF;
2500: END IF;
2501: --OE_DEBUG_PUB.Add(substr(l_stmt,1,length(l_stmt)),1);
2502: DBMS_SQL.PARSE(l_cursor_id,l_stmt,DBMS_SQL.NATIVE);
2503:
2504: -- Bind variables
2505: -- 4287740
2506: IF p_reserve_run_type <> 'CREATE_RESERVATION' OR p_reserve_run_type IS NULL THEN

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

2506: IF p_reserve_run_type <> 'CREATE_RESERVATION' OR p_reserve_run_type IS NULL THEN
2507:
2508: -- Moac start
2509: IF p_org_id IS NOT NULL THEN
2510: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':org_id',p_org_id);
2511: END IF;
2512: -- Moac end
2513:
2514: IF p_order_number_low IS NOT NULL THEN

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

2511: END IF;
2512: -- Moac end
2513:
2514: IF p_order_number_low IS NOT NULL THEN
2515: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_low',p_order_number_low);
2516: END IF;
2517: IF p_order_number_high IS NOT NULL THEN
2518: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_high',p_order_number_high);
2519: END IF;

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

2514: IF p_order_number_low IS NOT NULL THEN
2515: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_low',p_order_number_low);
2516: END IF;
2517: IF p_order_number_high IS NOT NULL THEN
2518: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_high',p_order_number_high);
2519: END IF;
2520: IF p_customer_id IS NOT NULL THEN
2521: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':customer_id',p_customer_id);
2522: END IF;

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

2517: IF p_order_number_high IS NOT NULL THEN
2518: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_number_high',p_order_number_high);
2519: END IF;
2520: IF p_customer_id IS NOT NULL THEN
2521: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':customer_id',p_customer_id);
2522: END IF;
2523: IF p_order_type IS NOT NULL THEN
2524: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_type',p_order_type);
2525: END IF;

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

2520: IF p_customer_id IS NOT NULL THEN
2521: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':customer_id',p_customer_id);
2522: END IF;
2523: IF p_order_type IS NOT NULL THEN
2524: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_type',p_order_type);
2525: END IF;
2526: IF l_ordered_date_low IS NOT NULL THEN
2527: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':ordered_date_low',l_ordered_date_low);
2528: END IF;

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

2523: IF p_order_type IS NOT NULL THEN
2524: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':order_type',p_order_type);
2525: END IF;
2526: IF l_ordered_date_low IS NOT NULL THEN
2527: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':ordered_date_low',l_ordered_date_low);
2528: END IF;
2529: IF l_ordered_date_high IS NOT NULL THEN
2530: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':ordered_date_high',l_ordered_date_high);
2531: END IF;

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

2526: IF l_ordered_date_low IS NOT NULL THEN
2527: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':ordered_date_low',l_ordered_date_low);
2528: END IF;
2529: IF l_ordered_date_high IS NOT NULL THEN
2530: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':ordered_date_high',l_ordered_date_high);
2531: END IF;
2532: IF p_line_type_id IS NOT NULL THEN
2533: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':line_type_id',p_line_type_id);
2534: END IF;

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

2529: IF l_ordered_date_high IS NOT NULL THEN
2530: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':ordered_date_high',l_ordered_date_high);
2531: END IF;
2532: IF p_line_type_id IS NOT NULL THEN
2533: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':line_type_id',p_line_type_id);
2534: END IF;
2535: IF p_warehouse IS NOT NULL THEN
2536: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':warehouse',p_warehouse);
2537: END IF;

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

2532: IF p_line_type_id IS NOT NULL THEN
2533: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':line_type_id',p_line_type_id);
2534: END IF;
2535: IF p_warehouse IS NOT NULL THEN
2536: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':warehouse',p_warehouse);
2537: END IF;
2538: IF l_request_date_low IS NOT NULL THEN
2539: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_date_low',l_request_date_low);
2540: END IF;

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

2535: IF p_warehouse IS NOT NULL THEN
2536: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':warehouse',p_warehouse);
2537: END IF;
2538: IF l_request_date_low IS NOT NULL THEN
2539: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_date_low',l_request_date_low);
2540: END IF;
2541: IF l_request_date_high IS NOT NULL THEN
2542: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_date_high',l_request_date_high);
2543: END IF;

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

2538: IF l_request_date_low IS NOT NULL THEN
2539: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_date_low',l_request_date_low);
2540: END IF;
2541: IF l_request_date_high IS NOT NULL THEN
2542: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_date_high',l_request_date_high);
2543: END IF;
2544: IF l_schedule_ship_date_low IS NOT NULL THEN
2545: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_ship_date_low',l_schedule_ship_date_low);
2546: END IF;

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

2541: IF l_request_date_high IS NOT NULL THEN
2542: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':request_date_high',l_request_date_high);
2543: END IF;
2544: IF l_schedule_ship_date_low IS NOT NULL THEN
2545: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_ship_date_low',l_schedule_ship_date_low);
2546: END IF;
2547: IF l_schedule_ship_date_high IS NOT NULL THEN
2548: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_ship_date_high',l_schedule_ship_date_high);
2549: END IF;

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

2544: IF l_schedule_ship_date_low IS NOT NULL THEN
2545: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_ship_date_low',l_schedule_ship_date_low);
2546: END IF;
2547: IF l_schedule_ship_date_high IS NOT NULL THEN
2548: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_ship_date_high',l_schedule_ship_date_high);
2549: END IF;
2550: IF l_schedule_arrival_date_low IS NOT NULL THEN
2551: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_arrival_date_low',l_schedule_arrival_date_low);
2552: END IF;

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

2547: IF l_schedule_ship_date_high IS NOT NULL THEN
2548: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_ship_date_high',l_schedule_ship_date_high);
2549: END IF;
2550: IF l_schedule_arrival_date_low IS NOT NULL THEN
2551: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_arrival_date_low',l_schedule_arrival_date_low);
2552: END IF;
2553: IF l_schedule_arrival_date_high IS NOT NULL THEN
2554: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_arrival_date_high',l_schedule_arrival_date_high);
2555: END IF;

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

2550: IF l_schedule_arrival_date_low IS NOT NULL THEN
2551: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_arrival_date_low',l_schedule_arrival_date_low);
2552: END IF;
2553: IF l_schedule_arrival_date_high IS NOT NULL THEN
2554: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_arrival_date_high',l_schedule_arrival_date_high);
2555: END IF;
2556: IF p_inventory_item_id IS NOT NULL THEN
2557: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':inventory_item_id',p_inventory_item_id);
2558: END IF;

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

2553: IF l_schedule_arrival_date_high IS NOT NULL THEN
2554: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':schedule_arrival_date_high',l_schedule_arrival_date_high);
2555: END IF;
2556: IF p_inventory_item_id IS NOT NULL THEN
2557: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':inventory_item_id',p_inventory_item_id);
2558: END IF;
2559: IF p_demand_class_code IS NOT NULL THEN
2560: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':demand_class_code',p_demand_class_code);
2561: END IF;

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

2556: IF p_inventory_item_id IS NOT NULL THEN
2557: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':inventory_item_id',p_inventory_item_id);
2558: END IF;
2559: IF p_demand_class_code IS NOT NULL THEN
2560: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':demand_class_code',p_demand_class_code);
2561: END IF;
2562: IF p_planning_priority IS NOT NULL THEN
2563: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':planning_priority',p_planning_priority);
2564: END IF;

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

2559: IF p_demand_class_code IS NOT NULL THEN
2560: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':demand_class_code',p_demand_class_code);
2561: END IF;
2562: IF p_planning_priority IS NOT NULL THEN
2563: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':planning_priority',p_planning_priority);
2564: END IF;
2565: IF p_shipment_priority IS NOT NULL THEN
2566: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':shipment_priority',p_shipment_priority);
2567: END IF;

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

2562: IF p_planning_priority IS NOT NULL THEN
2563: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':planning_priority',p_planning_priority);
2564: END IF;
2565: IF p_shipment_priority IS NOT NULL THEN
2566: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':shipment_priority',p_shipment_priority);
2567: END IF;
2568: --R12.MOAC
2569: IF p_selected_ids IS NOT NULL THEN
2570: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':set_id',p_selected_ids);

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

2566: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':shipment_priority',p_shipment_priority);
2567: END IF;
2568: --R12.MOAC
2569: IF p_selected_ids IS NOT NULL THEN
2570: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':set_id',p_selected_ids);
2571: END IF;
2572: ELSIF p_reserve_run_type ='CREATE_RESERVATION'
2573: AND p_reserve_set_name IS NOT NULL THEN --Pack J
2574: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':reservation_set_name',p_reserve_set_name);

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

2570: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':set_id',p_selected_ids);
2571: END IF;
2572: ELSIF p_reserve_run_type ='CREATE_RESERVATION'
2573: AND p_reserve_set_name IS NOT NULL THEN --Pack J
2574: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':reservation_set_name',p_reserve_set_name);
2575: END IF;
2576:
2577: -- Define the output variables
2578: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_line_id);

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

2574: DBMS_SQL.BIND_VARIABLE(l_cursor_id,':reservation_set_name',p_reserve_set_name);
2575: END IF;
2576:
2577: -- Define the output variables
2578: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_line_id);
2579:
2580: -- OE_DEBUG_PUB.Add(length(l_stmt));
2581: IF l_debug_level > 0 THEN
2582: OE_DEBUG_PUB.Add(substr(l_stmt,1,length(l_stmt)),1);

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

2580: -- OE_DEBUG_PUB.Add(length(l_stmt));
2581: IF l_debug_level > 0 THEN
2582: OE_DEBUG_PUB.Add(substr(l_stmt,1,length(l_stmt)),1);
2583: END IF;
2584: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);
2585:
2586: -- OPEN l_ref_cur_lines FOR l_stmt;
2587: LOOP
2588: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN

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

2584: l_retval := DBMS_SQL.EXECUTE(l_cursor_id);
2585:
2586: -- OPEN l_ref_cur_lines FOR l_stmt;
2587: LOOP
2588: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
2589: EXIT;
2590: END IF;
2591: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_line_id);
2592:

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

2587: LOOP
2588: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
2589: EXIT;
2590: END IF;
2591: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_line_id);
2592:
2593: FND_FILE.Put_Line(FND_FILE.LOG, ' ');
2594: FND_FILE.Put_Line(FND_FILE.LOG, '***** Processing Line id '||
2595: l_Line_id||' *****');

Line 2736: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

2732:
2733: END IF; -- End of Lock Row
2734:
2735: END LOOP; -- End of lines_cur
2736: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
2737:
2738: --3710133
2739: --4287740 Added Not null check for reservation mode
2740: IF p_reservation_mode IS NOT NULL AND l_rsv_tbl.count = 0