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

Line 444: l_cursor := dbms_sql.open_cursor;

440:
441: l_debug_line := 50;
442: -- Count the rows and quantity
443: l_cursor_cnt := 'SELECT COUNT(*), SUM(ORDER_QUANTITY) '||l_where;
444: l_cursor := dbms_sql.open_cursor;
445: dbms_sql.parse(l_cursor, l_cursor_cnt, dbms_sql.v7);
446:
447: FLM_Util.add_bind(':l_line_id', l_line_id);
448: FLM_Util.add_bind(':l_org_id', l_org_id);

Line 445: dbms_sql.parse(l_cursor, l_cursor_cnt, dbms_sql.v7);

441: l_debug_line := 50;
442: -- Count the rows and quantity
443: l_cursor_cnt := 'SELECT COUNT(*), SUM(ORDER_QUANTITY) '||l_where;
444: l_cursor := dbms_sql.open_cursor;
445: dbms_sql.parse(l_cursor, l_cursor_cnt, dbms_sql.v7);
446:
447: FLM_Util.add_bind(':l_line_id', l_line_id);
448: FLM_Util.add_bind(':l_org_id', l_org_id);
449: FLM_Util.add_bind(':l_demand_start_date', l_demand_start_date);

Line 453: dbms_sql.define_column(l_cursor, 1, l_count_rows);

449: FLM_Util.add_bind(':l_demand_start_date', l_demand_start_date);
450: FLM_Util.add_bind(':l_demand_end_date', l_demand_end_date);
451: FLM_Util.do_binds(l_cursor);
452:
453: dbms_sql.define_column(l_cursor, 1, l_count_rows);
454: dbms_sql.define_column(l_cursor, 2, l_quantity);
455: l_debug_line := 55;
456: l_dummy := dbms_sql.execute(l_cursor);
457: IF (dbms_sql.fetch_rows(l_cursor) > 0) THEN

Line 454: dbms_sql.define_column(l_cursor, 2, l_quantity);

450: FLM_Util.add_bind(':l_demand_end_date', l_demand_end_date);
451: FLM_Util.do_binds(l_cursor);
452:
453: dbms_sql.define_column(l_cursor, 1, l_count_rows);
454: dbms_sql.define_column(l_cursor, 2, l_quantity);
455: l_debug_line := 55;
456: l_dummy := dbms_sql.execute(l_cursor);
457: IF (dbms_sql.fetch_rows(l_cursor) > 0) THEN
458: dbms_sql.column_value(l_cursor,1, l_count_rows);

Line 456: l_dummy := dbms_sql.execute(l_cursor);

452:
453: dbms_sql.define_column(l_cursor, 1, l_count_rows);
454: dbms_sql.define_column(l_cursor, 2, l_quantity);
455: l_debug_line := 55;
456: l_dummy := dbms_sql.execute(l_cursor);
457: IF (dbms_sql.fetch_rows(l_cursor) > 0) THEN
458: dbms_sql.column_value(l_cursor,1, l_count_rows);
459: dbms_sql.column_value(l_cursor,2, l_quantity);
460: END IF;

Line 457: IF (dbms_sql.fetch_rows(l_cursor) > 0) THEN

453: dbms_sql.define_column(l_cursor, 1, l_count_rows);
454: dbms_sql.define_column(l_cursor, 2, l_quantity);
455: l_debug_line := 55;
456: l_dummy := dbms_sql.execute(l_cursor);
457: IF (dbms_sql.fetch_rows(l_cursor) > 0) THEN
458: dbms_sql.column_value(l_cursor,1, l_count_rows);
459: dbms_sql.column_value(l_cursor,2, l_quantity);
460: END IF;
461: dbms_sql.close_cursor(l_cursor);

Line 458: dbms_sql.column_value(l_cursor,1, l_count_rows);

454: dbms_sql.define_column(l_cursor, 2, l_quantity);
455: l_debug_line := 55;
456: l_dummy := dbms_sql.execute(l_cursor);
457: IF (dbms_sql.fetch_rows(l_cursor) > 0) THEN
458: dbms_sql.column_value(l_cursor,1, l_count_rows);
459: dbms_sql.column_value(l_cursor,2, l_quantity);
460: END IF;
461: dbms_sql.close_cursor(l_cursor);
462:

Line 459: dbms_sql.column_value(l_cursor,2, l_quantity);

455: l_debug_line := 55;
456: l_dummy := dbms_sql.execute(l_cursor);
457: IF (dbms_sql.fetch_rows(l_cursor) > 0) THEN
458: dbms_sql.column_value(l_cursor,1, l_count_rows);
459: dbms_sql.column_value(l_cursor,2, l_quantity);
460: END IF;
461: dbms_sql.close_cursor(l_cursor);
462:
463: IF (p_max_rows IS NOT NULL AND p_max_rows <> -1 AND l_count_rows > p_max_rows) THEN

Line 461: dbms_sql.close_cursor(l_cursor);

457: IF (dbms_sql.fetch_rows(l_cursor) > 0) THEN
458: dbms_sql.column_value(l_cursor,1, l_count_rows);
459: dbms_sql.column_value(l_cursor,2, l_quantity);
460: END IF;
461: dbms_sql.close_cursor(l_cursor);
462:
463: IF (p_max_rows IS NOT NULL AND p_max_rows <> -1 AND l_count_rows > p_max_rows) THEN
464: ROLLBACK TO flm_insert_demands;
465: x_return_status := FND_API.G_RET_STS_ERROR;

Line 494: l_cursor := dbms_sql.open_cursor;

490:
491: l_cursor_insert := l_cursor_insert || l_where;
492:
493: l_debug_line := 60;
494: l_cursor := dbms_sql.open_cursor;
495: dbms_sql.parse(l_cursor, l_cursor_insert, dbms_sql.v7);
496:
497: FLM_Util.add_bind(':p_seq_task_id', p_seq_task_id);
498: FLM_Util.do_binds(l_cursor);

Line 495: dbms_sql.parse(l_cursor, l_cursor_insert, dbms_sql.v7);

491: l_cursor_insert := l_cursor_insert || l_where;
492:
493: l_debug_line := 60;
494: l_cursor := dbms_sql.open_cursor;
495: dbms_sql.parse(l_cursor, l_cursor_insert, dbms_sql.v7);
496:
497: FLM_Util.add_bind(':p_seq_task_id', p_seq_task_id);
498: FLM_Util.do_binds(l_cursor);
499:

Line 500: l_dummy := dbms_sql.execute(l_cursor);

496:
497: FLM_Util.add_bind(':p_seq_task_id', p_seq_task_id);
498: FLM_Util.do_binds(l_cursor);
499:
500: l_dummy := dbms_sql.execute(l_cursor);
501: dbms_sql.close_cursor(l_cursor);
502: l_debug_line := 70;
503:
504: END IF;

Line 501: dbms_sql.close_cursor(l_cursor);

497: FLM_Util.add_bind(':p_seq_task_id', p_seq_task_id);
498: FLM_Util.do_binds(l_cursor);
499:
500: l_dummy := dbms_sql.execute(l_cursor);
501: dbms_sql.close_cursor(l_cursor);
502: l_debug_line := 70;
503:
504: END IF;
505: