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 FLM_UTIL

Line 402: FLM_Util.init_bind;

398: l_filter := NULL;
399: l_cursor_insert := NULL;
400: l_cursor_cnt := NULL;
401:
402: FLM_Util.init_bind;
403:
404: IF (l_seq_task_type = FLM_CONSTANTS.SEQ_TASK_SO AND l_alternate_routing_flag = 'N') THEN
405: l_where := 'FROM FLM_SEQ_DEMAND_SALES_ORDERS_V MUOV WHERE '||
406: 'MUOV.ALTERNATE_ROUTING_DESIGNATOR IS NULL AND ';

Line 447: FLM_Util.add_bind(':l_line_id', l_line_id);

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);
450: FLM_Util.add_bind(':l_demand_end_date', l_demand_end_date);
451: FLM_Util.do_binds(l_cursor);

Line 448: FLM_Util.add_bind(':l_org_id', l_org_id);

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);
450: FLM_Util.add_bind(':l_demand_end_date', l_demand_end_date);
451: FLM_Util.do_binds(l_cursor);
452:

Line 449: FLM_Util.add_bind(':l_demand_start_date', l_demand_start_date);

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);
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);

Line 450: FLM_Util.add_bind(':l_demand_end_date', l_demand_end_date);

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);
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);

Line 451: FLM_Util.do_binds(l_cursor);

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);
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;

Line 497: FLM_Util.add_bind(':p_seq_task_id', p_seq_task_id);

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:
500: l_dummy := dbms_sql.execute(l_cursor);
501: dbms_sql.close_cursor(l_cursor);

Line 498: FLM_Util.do_binds(l_cursor);

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:
500: l_dummy := dbms_sql.execute(l_cursor);
501: dbms_sql.close_cursor(l_cursor);
502: l_debug_line := 70;

Line 949: flm_licensed := flm_util.Get_Install_Status();

945: IS
946: flm_licensed VARCHAR2(1) := 'N';
947: flmseq_enabled_prf_value VARCHAR2(1) := 'N';
948: BEGIN
949: flm_licensed := flm_util.Get_Install_Status();
950: flmseq_enabled_prf_value := flm_seq_ui.Get_FlmSeq_Enabled_Flag();
951:
952: IF flm_licensed = 'I' and flmseq_enabled_prf_value = 'Y'
953: THEN