DBA Data[Home] [Help]

APPS.PA_FP_WP_GEN_BUDGET_AMT_PUB dependencies on PA_FP_RES_ASSIGNMENTS_TMP

Line 67: l_source_context pa_fp_res_assignments_tmp.source_context%TYPE :='RESOURCE_ASSIGNMENT';

63: l_rollup_required_flag VARCHAR2(1);
64: l_raTxn_rollup_api_call_flag VARCHAR2(1); -- Added for IPM new entity ER
65:
66: /* Local PL/SQL table used for calling Calculate API */
67: l_source_context pa_fp_res_assignments_tmp.source_context%TYPE :='RESOURCE_ASSIGNMENT';
68: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
69: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
70: l_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
71: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();

Line 3425: l_source_context pa_fp_res_assignments_tmp.source_context%TYPE;

3421: l_rollup_required_flag VARCHAR2(1);
3422: l_raTxn_rollup_api_call_flag VARCHAR2(1); -- Added for IPM new entity ER
3423:
3424: /* Additional Calculate API parameters added for Bug 4686742 */
3425: l_source_context pa_fp_res_assignments_tmp.source_context%TYPE;
3426: l_cal_tgt_res_asg_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
3427: l_cal_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
3428: l_cal_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
3429: l_cal_end_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();