APPS.FTP_TP_PKG dependencies on FTP_TP_PROCESS_RULE

Line 142: from ftp_tp_process_rule

138:
139: -- Now get the transfer price and prepayment object -d
140: select transfer_price_object_id, prepay_object_id
141: into tp_obj_id, pp_obj_id
142: from ftp_tp_process_rule
143: where object_definition_id = process_info.obj_id;
144:
145: -- Get the local value combo of the tp_object_id;
146: select local_vs_combo_id into combo_id

Line 599: from ftp_tp_process_rule

595: adj_obj_id number; -- adj object/object_def
596: begin
597: select transfer_price_object_id, prepay_object_id, adjustment_object_id
598: into tp_obj_id, pp_obj_id, adj_obj_id
599: from ftp_tp_process_rule
600: where object_definition_id = proc_def_id;
601:
602: -- convert object ids to obj_def_id
603: --get Transfer Price obj def if used for this rule

Line 915: remain_term_flag FTP_TP_PROCESS_RULE.CALC_MODE_CODE%TYPE;

911: LAST_OBJID_COL out nocopy varchar2,
912: LAST_REQID_COL out nocopy varchar2
913: ) is
914: process_info OBJ_INFO_TYPE;
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

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 2481: rate_output_rule_obj_id FTP_TP_PROCESS_RULE.ALT_RATE_OP_OBJECT_ID%TYPE;

2477: is
2478: process_info OBJ_INFO_TYPE;
2479:
2480: indx NUMBER;
2481: rate_output_rule_obj_id FTP_TP_PROCESS_RULE.ALT_RATE_OP_OBJECT_ID%TYPE;
2482: adj_object_id FTP_TP_PROCESS_RULE.adjustment_object_id%TYPE;
2483: adj_type_code ftp_adjustment_rule.adjustment_type_code%TYPE;
2484: ecoloss_meth_count NUMBER;
2485: TYPE varchar_std_type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;

Line 2482: adj_object_id FTP_TP_PROCESS_RULE.adjustment_object_id%TYPE;

2478: process_info OBJ_INFO_TYPE;
2479:
2480: indx NUMBER;
2481: rate_output_rule_obj_id FTP_TP_PROCESS_RULE.ALT_RATE_OP_OBJECT_ID%TYPE;
2482: adj_object_id FTP_TP_PROCESS_RULE.adjustment_object_id%TYPE;
2483: adj_type_code ftp_adjustment_rule.adjustment_type_code%TYPE;
2484: ecoloss_meth_count NUMBER;
2485: TYPE varchar_std_type IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
2486: rate_map_info OBJ_INFO_TYPE;

Line 2509: from ftp_tp_process_rule

2505: -- From TP Process Rule Info to chk if new Alternate Rate Output Mapping
2506: -- Rule,Adjustment Rule exists or not.
2507: select ALT_RATE_OP_OBJECT_ID,adjustment_object_id
2508: into rate_output_rule_obj_id,adj_object_id
2509: from ftp_tp_process_rule
2510: where object_definition_id = process_info.obj_id ;
2511:
2512: IF ( adj_object_id IS NOT NULL ) THEN
2513: -- For rate_output_rule get detail info