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

Line 265: l_sqlCursor := DBMS_SQL.Open_Cursor;

261:
262: l_sql_stmt := l_sql_stmt || ' ORDER BY H.header_id';
263: FND_FILE.PUT_LINE(FND_FILE.LOG,'Sql built = '|| l_sql_stmt);
264:
265: l_sqlCursor := DBMS_SQL.Open_Cursor;
266:
267: DBMS_SQL.PARSE(l_sqlCursor, l_sql_stmt, DBMS_SQL.NATIVE);
268:
269: IF p_order_num_low IS NOT NULL THEN

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

263: FND_FILE.PUT_LINE(FND_FILE.LOG,'Sql built = '|| l_sql_stmt);
264:
265: l_sqlCursor := DBMS_SQL.Open_Cursor;
266:
267: DBMS_SQL.PARSE(l_sqlCursor, l_sql_stmt, DBMS_SQL.NATIVE);
268:
269: IF p_order_num_low IS NOT NULL THEN
270: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p1',p_order_num_low);
271: END IF;

Line 270: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p1',p_order_num_low);

266:
267: DBMS_SQL.PARSE(l_sqlCursor, l_sql_stmt, DBMS_SQL.NATIVE);
268:
269: IF p_order_num_low IS NOT NULL THEN
270: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p1',p_order_num_low);
271: END IF;
272: IF p_order_num_high IS NOT NULL THEN
273: dbms_sql.bind_variable(l_sqlCursor,':p2',p_order_num_high);
274: END IF;

Line 273: dbms_sql.bind_variable(l_sqlCursor,':p2',p_order_num_high);

269: IF p_order_num_low IS NOT NULL THEN
270: DBMS_SQL.BIND_VARIABLE(l_sqlCursor,':p1',p_order_num_low);
271: END IF;
272: IF p_order_num_high IS NOT NULL THEN
273: dbms_sql.bind_variable(l_sqlCursor,':p2',p_order_num_high);
274: END IF;
275: IF p_customer IS NOT NULL THEN
276: dbms_sql.bind_variable(l_sqlCursor,':p3',p_customer);
277: END IF;

Line 276: dbms_sql.bind_variable(l_sqlCursor,':p3',p_customer);

272: IF p_order_num_high IS NOT NULL THEN
273: dbms_sql.bind_variable(l_sqlCursor,':p2',p_order_num_high);
274: END IF;
275: IF p_customer IS NOT NULL THEN
276: dbms_sql.bind_variable(l_sqlCursor,':p3',p_customer);
277: END IF;
278: IF p_customer_po_num IS NOT NULL THEN
279: dbms_sql.bind_variable(l_sqlCursor,':p4',p_customer_po_num);
280: END IF;

Line 279: dbms_sql.bind_variable(l_sqlCursor,':p4',p_customer_po_num);

275: IF p_customer IS NOT NULL THEN
276: dbms_sql.bind_variable(l_sqlCursor,':p3',p_customer);
277: END IF;
278: IF p_customer_po_num IS NOT NULL THEN
279: dbms_sql.bind_variable(l_sqlCursor,':p4',p_customer_po_num);
280: END IF;
281: IF p_order_type IS NOT NULL THEN
282: dbms_sql.bind_variable(l_sqlCursor,':p5',p_order_type);
283: END IF;

Line 282: dbms_sql.bind_variable(l_sqlCursor,':p5',p_order_type);

278: IF p_customer_po_num IS NOT NULL THEN
279: dbms_sql.bind_variable(l_sqlCursor,':p4',p_customer_po_num);
280: END IF;
281: IF p_order_type IS NOT NULL THEN
282: dbms_sql.bind_variable(l_sqlCursor,':p5',p_order_type);
283: END IF;
284: IF p_warehouse IS NOT NULL THEN
285: dbms_sql.bind_variable(l_sqlCursor,':p6',p_warehouse);
286: END IF;

Line 285: dbms_sql.bind_variable(l_sqlCursor,':p6',p_warehouse);

281: IF p_order_type IS NOT NULL THEN
282: dbms_sql.bind_variable(l_sqlCursor,':p5',p_order_type);
283: END IF;
284: IF p_warehouse IS NOT NULL THEN
285: dbms_sql.bind_variable(l_sqlCursor,':p6',p_warehouse);
286: END IF;
287: IF p_ship_to_location IS NOT NULL THEN
288: dbms_sql.bind_variable(l_sqlCursor,':p7',p_ship_to_location);
289: END IF;

Line 288: dbms_sql.bind_variable(l_sqlCursor,':p7',p_ship_to_location);

284: IF p_warehouse IS NOT NULL THEN
285: dbms_sql.bind_variable(l_sqlCursor,':p6',p_warehouse);
286: END IF;
287: IF p_ship_to_location IS NOT NULL THEN
288: dbms_sql.bind_variable(l_sqlCursor,':p7',p_ship_to_location);
289: END IF;
290: IF p_inventory_item_id IS NOT NULL THEN
291: dbms_sql.bind_variable(l_sqlCursor,':p8',p_inventory_item_id);
292: END IF;

Line 291: dbms_sql.bind_variable(l_sqlCursor,':p8',p_inventory_item_id);

287: IF p_ship_to_location IS NOT NULL THEN
288: dbms_sql.bind_variable(l_sqlCursor,':p7',p_ship_to_location);
289: END IF;
290: IF p_inventory_item_id IS NOT NULL THEN
291: dbms_sql.bind_variable(l_sqlCursor,':p8',p_inventory_item_id);
292: END IF;
293: IF l_schedule_date_low IS NOT NULL THEN
294: dbms_sql.bind_variable(l_sqlCursor,':p9',l_schedule_date_low);
295: END IF;

Line 294: dbms_sql.bind_variable(l_sqlCursor,':p9',l_schedule_date_low);

290: IF p_inventory_item_id IS NOT NULL THEN
291: dbms_sql.bind_variable(l_sqlCursor,':p8',p_inventory_item_id);
292: END IF;
293: IF l_schedule_date_low IS NOT NULL THEN
294: dbms_sql.bind_variable(l_sqlCursor,':p9',l_schedule_date_low);
295: END IF;
296: IF l_schedule_date_high IS NOT NULL THEN
297: dbms_sql.bind_variable(l_sqlCursor,':p10',l_schedule_date_high);
298: END IF;

Line 297: dbms_sql.bind_variable(l_sqlCursor,':p10',l_schedule_date_high);

293: IF l_schedule_date_low IS NOT NULL THEN
294: dbms_sql.bind_variable(l_sqlCursor,':p9',l_schedule_date_low);
295: END IF;
296: IF l_schedule_date_high IS NOT NULL THEN
297: dbms_sql.bind_variable(l_sqlCursor,':p10',l_schedule_date_high);
298: END IF;
299: IF l_ordered_date_low IS NOT NULL THEN
300: dbms_sql.bind_variable(l_sqlCursor,':p11',l_ordered_date_low);
301: END IF;

Line 300: dbms_sql.bind_variable(l_sqlCursor,':p11',l_ordered_date_low);

296: IF l_schedule_date_high IS NOT NULL THEN
297: dbms_sql.bind_variable(l_sqlCursor,':p10',l_schedule_date_high);
298: END IF;
299: IF l_ordered_date_low IS NOT NULL THEN
300: dbms_sql.bind_variable(l_sqlCursor,':p11',l_ordered_date_low);
301: END IF;
302: IF l_ordered_date_high IS NOT NULL THEN
303: dbms_sql.bind_variable(l_sqlCursor,':p12',l_ordered_date_high);
304: END IF;

Line 303: dbms_sql.bind_variable(l_sqlCursor,':p12',l_ordered_date_high);

299: IF l_ordered_date_low IS NOT NULL THEN
300: dbms_sql.bind_variable(l_sqlCursor,':p11',l_ordered_date_low);
301: END IF;
302: IF l_ordered_date_high IS NOT NULL THEN
303: dbms_sql.bind_variable(l_sqlCursor,':p12',l_ordered_date_high);
304: END IF;
305: IF p_org_id IS NOT NULL THEN
306: dbms_sql.bind_variable(l_sqlCursor,':p13',p_org_id);
307: END IF;

Line 306: dbms_sql.bind_variable(l_sqlCursor,':p13',p_org_id);

302: IF l_ordered_date_high IS NOT NULL THEN
303: dbms_sql.bind_variable(l_sqlCursor,':p12',l_ordered_date_high);
304: END IF;
305: IF p_org_id IS NOT NULL THEN
306: dbms_sql.bind_variable(l_sqlCursor,':p13',p_org_id);
307: END IF;
308:
309: DBMS_SQL.DEFINE_COLUMN (l_sqlCursor,1,l_line_id);
310: DBMS_SQL.DEFINE_COLUMN (l_sqlCursor,2,l_org_id);

Line 309: DBMS_SQL.DEFINE_COLUMN (l_sqlCursor,1,l_line_id);

305: IF p_org_id IS NOT NULL THEN
306: dbms_sql.bind_variable(l_sqlCursor,':p13',p_org_id);
307: END IF;
308:
309: DBMS_SQL.DEFINE_COLUMN (l_sqlCursor,1,l_line_id);
310: DBMS_SQL.DEFINE_COLUMN (l_sqlCursor,2,l_org_id);
311: l_dummy := DBMS_SQL.execute(l_sqlCursor);
312:
313: LOOP

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

306: dbms_sql.bind_variable(l_sqlCursor,':p13',p_org_id);
307: END IF;
308:
309: DBMS_SQL.DEFINE_COLUMN (l_sqlCursor,1,l_line_id);
310: DBMS_SQL.DEFINE_COLUMN (l_sqlCursor,2,l_org_id);
311: l_dummy := DBMS_SQL.execute(l_sqlCursor);
312:
313: LOOP
314:

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

307: END IF;
308:
309: DBMS_SQL.DEFINE_COLUMN (l_sqlCursor,1,l_line_id);
310: DBMS_SQL.DEFINE_COLUMN (l_sqlCursor,2,l_org_id);
311: l_dummy := DBMS_SQL.execute(l_sqlCursor);
312:
313: LOOP
314:
315: IF DBMS_SQL.FETCH_ROWS(l_sqlCursor) = 0 THEN

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

311: l_dummy := DBMS_SQL.execute(l_sqlCursor);
312:
313: LOOP
314:
315: IF DBMS_SQL.FETCH_ROWS(l_sqlCursor) = 0 THEN
316: EXIT;
317: END IF;
318:
319: DBMS_SQL.COLUMN_VALUE(l_sqlCursor,1,l_line_id);

Line 319: DBMS_SQL.COLUMN_VALUE(l_sqlCursor,1,l_line_id);

315: IF DBMS_SQL.FETCH_ROWS(l_sqlCursor) = 0 THEN
316: EXIT;
317: END IF;
318:
319: DBMS_SQL.COLUMN_VALUE(l_sqlCursor,1,l_line_id);
320: DBMS_SQL.COLUMN_VALUE(l_sqlCursor,2,l_org_id);
321:
322: /*
323: FOR c_lines IN C_GET_LINES(

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

316: EXIT;
317: END IF;
318:
319: DBMS_SQL.COLUMN_VALUE(l_sqlCursor,1,l_line_id);
320: DBMS_SQL.COLUMN_VALUE(l_sqlCursor,2,l_org_id);
321:
322: /*
323: FOR c_lines IN C_GET_LINES(
324: p_order_num_low,

Line 373: DBMS_SQL.CLOSE_CURSOR(l_sqlCursor); -- bug 4632747

369: END LOOP;
370: -- END IF;
371: END LOOP;
372:
373: DBMS_SQL.CLOSE_CURSOR(l_sqlCursor); -- bug 4632747
374:
375: FND_FILE.PUT_LINE(FND_FILE.LOG,'Exiting EC Screening Program..');
376:
377: