[Home] [Help]
2038: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS; --This variable will be used to call pa_resource_asgn_curr maintenance api
2039: l_src_version_type VARCHAR2(15);
2040: l_target_version_type VARCHAR2(15);
2041: l_ra_id_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2042: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type := system.pa_varchar2_15_tbl_type();
2043: l_txn_raw_cost_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2044: l_txn_burden_cost_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2045: l_txn_bill_rate_ovd_tbl SYSTEM.pa_num_tbl_type := system.pa_num_tbl_type();
2046: l_debug_level5 NUMBER:=5;
8481: PROCEDURE create_default_plan_txn_rec
8482: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
8483: p_calling_module IN VARCHAR2,
8484: p_ra_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(), /* 7161809 */
8485: p_curr_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE(), /* 7161809 */
8486: p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE(), /* Enc */
8487: x_return_status OUT NOCOPY VARCHAR2,
8488: x_msg_count OUT NOCOPY NUMBER,
8489: x_msg_data OUT NOCOPY VARCHAR2)
8519: and prac.budget_version_id = pract.budget_version_id;
8520:
8521: l_def_plan_txn_ra_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
8522: l_def_txn_curr_code pa_budget_lines.txn_currency_code%TYPE;
8523: l_curr_code_temp_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE(); /* 7161809 */
8524: l_expenditure_type_tbl SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE(); /* EnC */
8525: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;
8526: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;
8527: l_pfunc_curr_code pa_projects_all.projfunc_currency_code%TYPE;