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.FTP_TP_PKG dependencies on FTP_TP_PROC_TABLS_PARAMS

Line 1148: CURSOR l_cur_tables IS select table_name from ftp_tp_proc_tabls_params

1144: TYPE varchar_std_type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
1145: l_table_names varchar_std_type;
1146:
1147: -- cursor that retrieves the tables that should be used as source
1148: CURSOR l_cur_tables IS select table_name from ftp_tp_proc_tabls_params
1149: where object_definition_id = process_info.obj_id and job_id = p_job_id;
1150:
1151: BEGIN
1152: /*FEM_ENGINES_PKG.Put_Message(

Line 1571: CURSOR l_cur_tables IS select table_name from ftp_tp_proc_tabls_params

1567: /*TYPE number_std_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1568: l_input_ds number_std_type;*/
1569:
1570: -- cursor that retrieves the tables that should be used as source
1571: CURSOR l_cur_tables IS select table_name from ftp_tp_proc_tabls_params
1572: where object_definition_id = process_info.obj_id and job_id = p_job_id;
1573:
1574: -- set up the flags
1575: trate_prop_flg ftp_tp_proc_stoch_params.trans_rate_propagate_flg%TYPE;

Line 2228: CURSOR l_cur_tables IS select table_name from ftp_tp_proc_tabls_params

2224: l_created_by_req_tbl t_obj_id_tbl;
2225:
2226: -- Praveen Attaluri (Bug Fix)
2227: -- cursor that retrieves the tables that should be used as source
2228: CURSOR l_cur_tables IS select table_name from ftp_tp_proc_tabls_params
2229: where object_definition_id = process_info.obj_id and job_id = p_job_id;
2230:
2231: TYPE varchar_std_type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
2232: l_table_names varchar_std_type;

Line 2493: CURSOR l_cur_tables IS select table_name from ftp_tp_proc_tabls_params

2489: l_table_names varchar_std_type;
2490: cnt NUMBER;
2491:
2492: -- cursor that retrieves the tables that should be used as source
2493: CURSOR l_cur_tables IS select table_name from ftp_tp_proc_tabls_params
2494: where object_definition_id = process_info.obj_id and job_id = jobid;
2495:
2496: begin
2497:

Line 2634: FROM fem_tab_columns_v i, FTP_RATE_OUTPUT_MAPPING_RULE j, ftp_tp_proc_tabls_params k

2630: max(DECODE(HIST_STAT_SPREAD_COL_NAME, column_name, HIST_STAT_SPREAD_COL_NAME, NULL,NULL, -1)) as hist_stat_spr,
2631: max(DECODE(CUR_STAT_SPREAD_COL_NAME, column_name, CUR_STAT_SPREAD_COL_NAME, NULL,NULL, -1)) as cur_stat_spr,
2632: max(DECODE(ADJUSTMENT_AMOUNT_COL_NAME, column_name, ADJUSTMENT_AMOUNT_COL_NAME, NULL,NULL, -1)) as adj_amt,
2633: max(DECODE(CUR_OAS_COL_NAME, column_name, CUR_OAS_COL_NAME, NULL,NULL, -1)) as cur_option
2634: FROM fem_tab_columns_v i, FTP_RATE_OUTPUT_MAPPING_RULE j, ftp_tp_proc_tabls_params k
2635: WHERE i.table_name = j. FTP_ACCOUNT_TABLE_NAME
2636: AND j. FTP_ACCOUNT_TABLE_NAME = k.table_name
2637: AND job_id = jobid
2638: AND k.object_definition_id = process_info.obj_id