[Home] [Help]
2022: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS; --This variable will be used to call pa_resource_asgn_curr maintenance api
2023: l_src_version_type VARCHAR2(15);
2024: l_target_version_type VARCHAR2(15);
2025: l_ra_id_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2026: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
2027: l_txn_raw_cost_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2028: l_txn_burden_cost_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2029: l_txn_bill_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2030: l_debug_level5 NUMBER:=5;
8461: PROCEDURE create_default_plan_txn_rec
8462: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
8463: p_calling_module IN VARCHAR2,
8464: p_ra_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(), /* 7161809 */
8465: p_curr_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE(), /* 7161809 */
8466: x_return_status OUT NOCOPY VARCHAR2,
8467: x_msg_count OUT NOCOPY NUMBER,
8468: x_msg_data OUT NOCOPY VARCHAR2)
8469: IS
8486: AND rac.budget_version_id = ra.budget_version_id);
8487:
8488: l_def_plan_txn_ra_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
8489: l_def_txn_curr_code pa_budget_lines.txn_currency_code%TYPE;
8490: l_curr_code_temp_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE(); /* 7161809 */
8491:
8492: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;
8493: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;
8494: l_pfunc_curr_code pa_projects_all.projfunc_currency_code%TYPE;