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_STOCH_PARAMS

Line 919: --modified to read from ftp_tp_proc_stoch_params from earlier ftp_tp_process_rule

915: remain_term_flag FTP_TP_PROCESS_RULE.CALC_MODE_CODE%TYPE;
916: magic_val varchar2(2000);
917: begin
918: get_obj_def(obj_id, effective_date, process_info);
919: --modified to read from ftp_tp_proc_stoch_params from earlier ftp_tp_process_rule
920:
921: select calc_mode_code into remain_term_flag from ftp_tp_proc_stoch_params
922: where object_definition_id = process_info.obj_id and job_id = jobid;
923: -- this allows us more flexibility later, if we want we can

Line 921: select calc_mode_code into remain_term_flag from ftp_tp_proc_stoch_params

917: begin
918: get_obj_def(obj_id, effective_date, process_info);
919: --modified to read from ftp_tp_proc_stoch_params from earlier ftp_tp_process_rule
920:
921: select calc_mode_code into remain_term_flag from ftp_tp_proc_stoch_params
922: where object_definition_id = process_info.obj_id and job_id = jobid;
923: -- this allows us more flexibility later, if we want we can
924: -- vary these by having the process record them or using
925: -- some other mechanism.

Line 1182: select filter_object_id into l_condition_id from ftp_tp_proc_stoch_params where

1178: p_token1 => 'OUT_DS',
1179: p_value1 => l_output_ds
1180: );*/
1181: BEGIN
1182: select filter_object_id into l_condition_id from ftp_tp_proc_stoch_params where
1183: object_definition_id = process_info.obj_id and job_id = p_job_id;
1184: EXCEPTION
1185: when others then
1186: -- when no condition id, still fine

Line 1575: trate_prop_flg ftp_tp_proc_stoch_params.trans_rate_propagate_flg%TYPE;

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;
1576: trate_calc_flg ftp_tp_proc_stoch_params.trans_rate_calc_flg%TYPE;
1577: ocost_prop_flg ftp_tp_proc_stoch_params.option_cost_propagate_flg%TYPE;
1578: ocost_calc_flg ftp_tp_proc_stoch_params.option_cost_calc_flg%TYPE;
1579:

Line 1576: trate_calc_flg ftp_tp_proc_stoch_params.trans_rate_calc_flg%TYPE;

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;
1576: trate_calc_flg ftp_tp_proc_stoch_params.trans_rate_calc_flg%TYPE;
1577: ocost_prop_flg ftp_tp_proc_stoch_params.option_cost_propagate_flg%TYPE;
1578: ocost_calc_flg ftp_tp_proc_stoch_params.option_cost_calc_flg%TYPE;
1579:
1580: -- tdasgupt : Added for R12 Enhancements

Line 1577: ocost_prop_flg ftp_tp_proc_stoch_params.option_cost_propagate_flg%TYPE;

1573:
1574: -- set up the flags
1575: trate_prop_flg ftp_tp_proc_stoch_params.trans_rate_propagate_flg%TYPE;
1576: trate_calc_flg ftp_tp_proc_stoch_params.trans_rate_calc_flg%TYPE;
1577: ocost_prop_flg ftp_tp_proc_stoch_params.option_cost_propagate_flg%TYPE;
1578: ocost_calc_flg ftp_tp_proc_stoch_params.option_cost_calc_flg%TYPE;
1579:
1580: -- tdasgupt : Added for R12 Enhancements
1581: l_adj_calc_flag ftp_tp_proc_stoch_params.adj_calc_flg%TYPE;

Line 1578: ocost_calc_flg ftp_tp_proc_stoch_params.option_cost_calc_flg%TYPE;

1574: -- set up the flags
1575: trate_prop_flg ftp_tp_proc_stoch_params.trans_rate_propagate_flg%TYPE;
1576: trate_calc_flg ftp_tp_proc_stoch_params.trans_rate_calc_flg%TYPE;
1577: ocost_prop_flg ftp_tp_proc_stoch_params.option_cost_propagate_flg%TYPE;
1578: ocost_calc_flg ftp_tp_proc_stoch_params.option_cost_calc_flg%TYPE;
1579:
1580: -- tdasgupt : Added for R12 Enhancements
1581: l_adj_calc_flag ftp_tp_proc_stoch_params.adj_calc_flg%TYPE;
1582: calcmode_flg ftp_tp_proc_stoch_params.calc_mode_code%TYPE;

Line 1581: l_adj_calc_flag ftp_tp_proc_stoch_params.adj_calc_flg%TYPE;

1577: ocost_prop_flg ftp_tp_proc_stoch_params.option_cost_propagate_flg%TYPE;
1578: ocost_calc_flg ftp_tp_proc_stoch_params.option_cost_calc_flg%TYPE;
1579:
1580: -- tdasgupt : Added for R12 Enhancements
1581: l_adj_calc_flag ftp_tp_proc_stoch_params.adj_calc_flg%TYPE;
1582: calcmode_flg ftp_tp_proc_stoch_params.calc_mode_code%TYPE;
1583: pos number;
1584: len number ;
1585: len2 number := 5;

Line 1582: calcmode_flg ftp_tp_proc_stoch_params.calc_mode_code%TYPE;

1578: ocost_calc_flg ftp_tp_proc_stoch_params.option_cost_calc_flg%TYPE;
1579:
1580: -- tdasgupt : Added for R12 Enhancements
1581: l_adj_calc_flag ftp_tp_proc_stoch_params.adj_calc_flg%TYPE;
1582: calcmode_flg ftp_tp_proc_stoch_params.calc_mode_code%TYPE;
1583: pos number;
1584: len number ;
1585: len2 number := 5;
1586: modify_valid_table_list varchar2(3000);

Line 1620: select filter_object_id into l_condition_id from ftp_tp_proc_stoch_params where

1616: x_datasets => l_input_ds
1617: );
1618:
1619: BEGIN
1620: select filter_object_id into l_condition_id from ftp_tp_proc_stoch_params where
1621: object_definition_id = process_info.obj_id and job_id = p_job_id;
1622: EXCEPTION
1623: when others then
1624: -- when no condition id, still fine

Line 1772: from ftp_tp_proc_stoch_params

1768: select trans_rate_propagate_flg,trans_rate_calc_flg,
1769: option_cost_propagate_flg,option_cost_calc_flg,calc_mode_code,adj_calc_flg
1770: into trate_prop_flg,trate_calc_flg,ocost_prop_flg,ocost_calc_flg,
1771: calcmode_flg,l_adj_calc_flag
1772: from ftp_tp_proc_stoch_params
1773: where object_definition_id = process_info.obj_id and job_id = p_job_id;
1774:
1775: FOR j IN 1..g_alt_rate_obj.COUNT
1776: LOOP

Line 2251: from ftp_tp_proc_stoch_params where object_definition_id = process_info.obj_id

2247: x_exec_lock_exists := 'F';
2248:
2249: /*--Get the migrate option
2250: select trans_rate_migrate_flg,option_cost_migrate_flg into l_trate_migr,l_ocost_migr
2251: from ftp_tp_proc_stoch_params where object_definition_id = process_info.obj_id
2252: and job_id = p_job_id;
2253:
2254: IF (l_trate_migr = 1 OR l_ocost_migr = 1) THEN
2255: l_migrate_flg := TRUE;