APPS.PA_FIN_PLAN_PUB dependencies on PA_RESOURCE_ASGN_CURR

Line 1442: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS; --This variable will be used to call pa_resource_asgn_curr maintenance api

1438: i NUMBER;
1439: l_wp_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
1440:
1441: -- IPM Arch Enhancement - Bug 4865563
1442: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS; --This variable will be used to call pa_resource_asgn_curr maintenance api
1443: l_debug_level5 NUMBER:=5;
1444:
1445: -- start of changes for bug 2779637
1446: /*

Line 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

2018: l_derv_rates_missing_amts_flag VARCHAR2(1);
2019:
2020: --IPM Architechture Enhancement Bug 4865563
2021: l_src_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
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();

Line 8452: * budget version id and inserts records in the new IPM table PA_RESOURCE_ASGN_CURR

8448: RAISE;
8449: END Refresh_res_list_assignment;
8450:
8451: /* bug 4865563: Added the following procedure which accepts a
8452: * budget version id and inserts records in the new IPM table PA_RESOURCE_ASGN_CURR
8453: * for the resource assignments which do not have budget lines and hence
8454: * not taken care by the new plannig transaction level entiy maintenance API.
8455: * These resource assignments are inserted with default currency as applicable.
8456: *

Line 8484: FROM pa_resource_asgn_curr rac

8480: SELECT ra.resource_assignment_id
8481: FROM pa_resource_assignments ra
8482: WHERE ra.budget_version_id = p_budget_version_id
8483: AND NOT EXISTS (SELECT 'X'
8484: FROM pa_resource_asgn_curr rac
8485: WHERE rac.resource_assignment_id = ra.resource_assignment_id
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();

Line 8501: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS; --This variable will be used to call pa_resource_asgn_curr maintenance api

8497: l_agreement_id pa_budget_versions.agreement_id%TYPE;
8498: l_app_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
8499:
8500: -- IPM Arch Enhancement - Bug 4865563
8501: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS; --This variable will be used to call pa_resource_asgn_curr maintenance api
8502: l_debug_level5 NUMBER:=5;
8503:
8504: BEGIN
8505: x_msg_count := 0;

Line 8662: DELETE pa_resource_asgn_curr_tmp;

8658: pa_debug.g_err_stage := 'l_def_txn_curr_code: ' || l_def_txn_curr_code;
8659: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
8660: END IF;
8661:
8662: DELETE pa_resource_asgn_curr_tmp;
8663: /* bulk insert the left over resource assignments into the new table with default txn currency
8664: * derived above */
8665: FORALL k IN l_def_plan_txn_ra_id_tbl.FIRST .. l_def_plan_txn_ra_id_tbl.LAST
8666: INSERT INTO pa_resource_asgn_curr_tmp

Line 8666: INSERT INTO pa_resource_asgn_curr_tmp

8662: DELETE pa_resource_asgn_curr_tmp;
8663: /* bulk insert the left over resource assignments into the new table with default txn currency
8664: * derived above */
8665: FORALL k IN l_def_plan_txn_ra_id_tbl.FIRST .. l_def_plan_txn_ra_id_tbl.LAST
8666: INSERT INTO pa_resource_asgn_curr_tmp
8667: (RA_TXN_ID,
8668: BUDGET_VERSION_ID,
8669: RESOURCE_ASSIGNMENT_ID,
8670: TXN_CURRENCY_CODE)

Line 8672: (pa_resource_asgn_curr_s.nextval,

8668: BUDGET_VERSION_ID,
8669: RESOURCE_ASSIGNMENT_ID,
8670: TXN_CURRENCY_CODE)
8671: VALUES
8672: (pa_resource_asgn_curr_s.nextval,
8673: p_budget_version_id,
8674: l_def_plan_txn_ra_id_tbl(k),
8675: /*l_def_txn_curr_code); */
8676: nvl(l_curr_code_temp_tbl(k),l_def_txn_curr_code)); /* janani */