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

Line 306: l_sqlCursor := DBMS_SQL.Open_Cursor;

302: End IF;
303: -- Moac End
304:
305: oe_debug_pub.add (l_sql_stmt,1);
306: l_sqlCursor := DBMS_SQL.Open_Cursor;
307:
308: DBMS_SQL.PARSE(l_sqlCursor, l_sql_stmt, DBMS_SQL.NATIVE);
309:
310: -- Moac Start

Line 308: DBMS_SQL.PARSE(l_sqlCursor, l_sql_stmt, DBMS_SQL.NATIVE);

304:
305: oe_debug_pub.add (l_sql_stmt,1);
306: l_sqlCursor := DBMS_SQL.Open_Cursor;
307:
308: DBMS_SQL.PARSE(l_sqlCursor, l_sql_stmt, DBMS_SQL.NATIVE);
309:
310: -- Moac Start
311: IF p_org_id IS NOT NULL THEN
312: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':bindvar_org_id',p_org_id);

Line 312: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':bindvar_org_id',p_org_id);

308: DBMS_SQL.PARSE(l_sqlCursor, l_sql_stmt, DBMS_SQL.NATIVE);
309:
310: -- Moac Start
311: IF p_org_id IS NOT NULL THEN
312: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':bindvar_org_id',p_org_id);
313: END IF;
314: -- Moac End
315:
316: IF p_order_number_low IS NOT NULL THEN

Line 317: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p1',p_order_number_low);

313: END IF;
314: -- Moac End
315:
316: IF p_order_number_low IS NOT NULL THEN
317: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p1',p_order_number_low);
318: END IF;
319: IF p_order_number_high is not null THEN
320: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p2',p_order_number_high);
321: END IF;

Line 320: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p2',p_order_number_high);

316: IF p_order_number_low IS NOT NULL THEN
317: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p1',p_order_number_low);
318: END IF;
319: IF p_order_number_high is not null THEN
320: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p2',p_order_number_high);
321: END IF;
322: IF p_customer_id is not null THEN
323: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p3',p_customer_id);
324: END IF;

Line 323: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p3',p_customer_id);

319: IF p_order_number_high is not null THEN
320: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p2',p_order_number_high);
321: END IF;
322: IF p_customer_id is not null THEN
323: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p3',p_customer_id);
324: END IF;
325: IF p_order_type is not null THEN
326: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p4',p_order_type);
327: END IF;

Line 326: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p4',p_order_type);

322: IF p_customer_id is not null THEN
323: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p3',p_customer_id);
324: END IF;
325: IF p_order_type is not null THEN
326: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p4',p_order_type);
327: END IF;
328: IF p_line_type_id is not null THEN
329: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p5',p_line_type_id);
330: END IF;

Line 329: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p5',p_line_type_id);

325: IF p_order_type is not null THEN
326: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p4',p_order_type);
327: END IF;
328: IF p_line_type_id is not null THEN
329: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p5',p_line_type_id);
330: END IF;
331: IF p_warehouse is not null THEN
332: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p6',p_warehouse);
333: END IF;

Line 332: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p6',p_warehouse);

328: IF p_line_type_id is not null THEN
329: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p5',p_line_type_id);
330: END IF;
331: IF p_warehouse is not null THEN
332: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p6',p_warehouse);
333: END IF;
334: IF p_inventory_item_id is not null THEN
335: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p7',p_inventory_item_id);
336: END IF;

Line 335: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p7',p_inventory_item_id);

331: IF p_warehouse is not null THEN
332: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p6',p_warehouse);
333: END IF;
334: IF p_inventory_item_id is not null THEN
335: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p7',p_inventory_item_id);
336: END IF;
337: IF p_request_date_low is not null THEN
338: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p8',l_request_date_low);
339: END IF;

Line 338: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p8',l_request_date_low);

334: IF p_inventory_item_id is not null THEN
335: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p7',p_inventory_item_id);
336: END IF;
337: IF p_request_date_low is not null THEN
338: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p8',l_request_date_low);
339: END IF;
340: IF p_request_date_high is not null THEN
341: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p9',l_request_date_high);
342: END IF;

Line 341: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p9',l_request_date_high);

337: IF p_request_date_low is not null THEN
338: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p8',l_request_date_low);
339: END IF;
340: IF p_request_date_high is not null THEN
341: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p9',l_request_date_high);
342: END IF;
343: IF p_schedule_ship_date_low is not null THEN
344: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p10',l_schedule_ship_date_low);
345: END IF;

Line 344: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p10',l_schedule_ship_date_low);

340: IF p_request_date_high is not null THEN
341: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p9',l_request_date_high);
342: END IF;
343: IF p_schedule_ship_date_low is not null THEN
344: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p10',l_schedule_ship_date_low);
345: END IF;
346: IF p_schedule_ship_date_high is not null THEN
347: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p11',l_schedule_ship_date_high);
348: END IF;

Line 347: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p11',l_schedule_ship_date_high);

343: IF p_schedule_ship_date_low is not null THEN
344: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p10',l_schedule_ship_date_low);
345: END IF;
346: IF p_schedule_ship_date_high is not null THEN
347: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p11',l_schedule_ship_date_high);
348: END IF;
349: IF p_schedule_arrival_date_low is not null THEN
350: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p12',l_schedule_arrival_date_low);
351: END IF;

Line 350: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p12',l_schedule_arrival_date_low);

346: IF p_schedule_ship_date_high is not null THEN
347: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p11',l_schedule_ship_date_high);
348: END IF;
349: IF p_schedule_arrival_date_low is not null THEN
350: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p12',l_schedule_arrival_date_low);
351: END IF;
352: IF p_schedule_arrival_date_high is not null THEN
353: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p13',l_schedule_arrival_date_high);
354: END IF;

Line 353: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p13',l_schedule_arrival_date_high);

349: IF p_schedule_arrival_date_low is not null THEN
350: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p12',l_schedule_arrival_date_low);
351: END IF;
352: IF p_schedule_arrival_date_high is not null THEN
353: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p13',l_schedule_arrival_date_high);
354: END IF;
355: IF p_ordered_date_low is not null THEN
356: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p14',l_ordered_date_low);
357: END IF;

Line 356: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p14',l_ordered_date_low);

352: IF p_schedule_arrival_date_high is not null THEN
353: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p13',l_schedule_arrival_date_high);
354: END IF;
355: IF p_ordered_date_low is not null THEN
356: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p14',l_ordered_date_low);
357: END IF;
358: IF p_ordered_date_high is not null THEN
359: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p15',l_ordered_date_high);
360: END IF;

Line 359: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p15',l_ordered_date_high);

355: IF p_ordered_date_low is not null THEN
356: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p14',l_ordered_date_low);
357: END IF;
358: IF p_ordered_date_high is not null THEN
359: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p15',l_ordered_date_high);
360: END IF;
361: IF p_demand_class_code is not null THEN
362: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p16',p_demand_class_code);
363: END IF;

Line 362: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p16',p_demand_class_code);

358: IF p_ordered_date_high is not null THEN
359: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p15',l_ordered_date_high);
360: END IF;
361: IF p_demand_class_code is not null THEN
362: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p16',p_demand_class_code);
363: END IF;
364: IF p_planning_priority is not null THEN
365: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p17',p_planning_priority);
366: END IF;

Line 365: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p17',p_planning_priority);

361: IF p_demand_class_code is not null THEN
362: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p16',p_demand_class_code);
363: END IF;
364: IF p_planning_priority is not null THEN
365: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p17',p_planning_priority);
366: END IF;
367: IF p_shipment_priority is not null THEN
368: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p18',p_shipment_priority);
369: END IF;

Line 368: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p18',p_shipment_priority);

364: IF p_planning_priority is not null THEN
365: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p17',p_planning_priority);
366: END IF;
367: IF p_shipment_priority is not null THEN
368: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p18',p_shipment_priority);
369: END IF;
370:
371: DBMS_SQL.DEFINE_COLUMN (l_sqlCursor,1,v_line_id);
372: DBMS_SQL.DEFINE_COLUMN (l_sqlCursor,2,l_org_id);

Line 371: DBMS_SQL.DEFINE_COLUMN (l_sqlCursor,1,v_line_id);

367: IF p_shipment_priority is not null THEN
368: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p18',p_shipment_priority);
369: END IF;
370:
371: DBMS_SQL.DEFINE_COLUMN (l_sqlCursor,1,v_line_id);
372: DBMS_SQL.DEFINE_COLUMN (l_sqlCursor,2,l_org_id);
373:
374: l_dummy := DBMS_SQL.execute(l_sqlCursor);
375:

Line 372: DBMS_SQL.DEFINE_COLUMN (l_sqlCursor,2,l_org_id);

368: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p18',p_shipment_priority);
369: END IF;
370:
371: DBMS_SQL.DEFINE_COLUMN (l_sqlCursor,1,v_line_id);
372: DBMS_SQL.DEFINE_COLUMN (l_sqlCursor,2,l_org_id);
373:
374: l_dummy := DBMS_SQL.execute(l_sqlCursor);
375:
376: LOOP

Line 374: l_dummy := DBMS_SQL.execute(l_sqlCursor);

370:
371: DBMS_SQL.DEFINE_COLUMN (l_sqlCursor,1,v_line_id);
372: DBMS_SQL.DEFINE_COLUMN (l_sqlCursor,2,l_org_id);
373:
374: l_dummy := DBMS_SQL.execute(l_sqlCursor);
375:
376: LOOP
377:
378: IF DBMS_SQL.FETCH_ROWS(l_sqlCursor) = 0 THEN

Line 378: IF DBMS_SQL.FETCH_ROWS(l_sqlCursor) = 0 THEN

374: l_dummy := DBMS_SQL.execute(l_sqlCursor);
375:
376: LOOP
377:
378: IF DBMS_SQL.FETCH_ROWS(l_sqlCursor) = 0 THEN
379: EXIT;
380: END IF;
381:
382: DBMS_SQL.COLUMN_VALUE(l_sqlCursor,1,v_line_id);

Line 382: DBMS_SQL.COLUMN_VALUE(l_sqlCursor,1,v_line_id);

378: IF DBMS_SQL.FETCH_ROWS(l_sqlCursor) = 0 THEN
379: EXIT;
380: END IF;
381:
382: DBMS_SQL.COLUMN_VALUE(l_sqlCursor,1,v_line_id);
383: DBMS_SQL.COLUMN_VALUE(l_sqlCursor,2,l_org_id);
384:
385: IF Firm_Eligible(p_line_id => v_line_id) THEN
386:

Line 383: DBMS_SQL.COLUMN_VALUE(l_sqlCursor,2,l_org_id);

379: EXIT;
380: END IF;
381:
382: DBMS_SQL.COLUMN_VALUE(l_sqlCursor,1,v_line_id);
383: DBMS_SQL.COLUMN_VALUE(l_sqlCursor,2,l_org_id);
384:
385: IF Firm_Eligible(p_line_id => v_line_id) THEN
386:
387: fnd_file.put_line(FND_FILE.LOG, '***** Processing Line id '||

Line 422: DBMS_SQL.CLOSE_CURSOR(l_sqlCursor);

418: END IF;
419:
420: END LOOP;
421:
422: DBMS_SQL.CLOSE_CURSOR(l_sqlCursor);
423:
424: END IF; -- Main
425:
426: END IF;