eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PA_FIN_PLAN_PUB dependencies on PA_RESOURCE_ASGN_CURR

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

1454: i NUMBER;
1455: l_wp_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
1456:
1457: -- IPM Arch Enhancement - Bug 4865563
1458: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS; --This variable will be used to call pa_resource_asgn_curr maintenance api
1459: l_debug_level5 NUMBER:=5;
1460:
1461: -- start of changes for bug 2779637
1462: /*

Line 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

2034: l_derv_rates_missing_amts_flag VARCHAR2(1);
2035:
2036: --IPM Architechture Enhancement Bug 4865563
2037: l_src_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
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();

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

8468: RAISE;
8469: END Refresh_res_list_assignment;
8470:
8471: /* bug 4865563: Added the following procedure which accepts a
8472: * budget version id and inserts records in the new IPM table PA_RESOURCE_ASGN_CURR
8473: * for the resource assignments which do not have budget lines and hence
8474: * not taken care by the new plannig transaction level entiy maintenance API.
8475: * These resource assignments are inserted with default currency as applicable.
8476: *

Line 8505: FROM pa_resource_asgn_curr rac

8501: SELECT ra.resource_assignment_id
8502: FROM pa_resource_assignments ra
8503: WHERE ra.budget_version_id = p_budget_version_id
8504: AND NOT EXISTS (SELECT 'X'
8505: FROM pa_resource_asgn_curr rac
8506: WHERE rac.resource_assignment_id = ra.resource_assignment_id
8507: AND rac.budget_version_id = ra.budget_version_id);
8508:
8509: --Bug 8223977

Line 8516: FROM pa_resource_asgn_curr prac,

8512: SELECT prac.resource_assignment_id,
8513: prac.txn_raw_cost_rate_override,
8514: prac.txn_burden_cost_rate_override,
8515: prac.txn_bill_rate_override
8516: FROM pa_resource_asgn_curr prac,
8517: pa_resource_asgn_curr_tmp pract
8518: WHERE prac.resource_assignment_id = pract.resource_assignment_id
8519: and prac.budget_version_id = pract.budget_version_id;
8520:

Line 8517: pa_resource_asgn_curr_tmp pract

8513: prac.txn_raw_cost_rate_override,
8514: prac.txn_burden_cost_rate_override,
8515: prac.txn_bill_rate_override
8516: FROM pa_resource_asgn_curr prac,
8517: pa_resource_asgn_curr_tmp pract
8518: WHERE prac.resource_assignment_id = pract.resource_assignment_id
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();

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

8530: l_agreement_id pa_budget_versions.agreement_id%TYPE;
8531: l_app_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
8532:
8533: -- IPM Arch Enhancement - Bug 4865563
8534: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS; --This variable will be used to call pa_resource_asgn_curr maintenance api
8535: l_debug_level5 NUMBER:=5;
8536:
8537: --Bug 8223977
8538: l_res_assignment_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 8703: DELETE pa_resource_asgn_curr_tmp;

8699: pa_debug.g_err_stage := 'l_def_txn_curr_code: ' || l_def_txn_curr_code;
8700: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
8701: END IF;
8702:
8703: DELETE pa_resource_asgn_curr_tmp;
8704: /* bulk insert the left over resource assignments into the new table with default txn currency
8705: * derived above */
8706: FORALL k IN l_def_plan_txn_ra_id_tbl.FIRST .. l_def_plan_txn_ra_id_tbl.LAST
8707: INSERT INTO pa_resource_asgn_curr_tmp

Line 8707: INSERT INTO pa_resource_asgn_curr_tmp

8703: DELETE pa_resource_asgn_curr_tmp;
8704: /* bulk insert the left over resource assignments into the new table with default txn currency
8705: * derived above */
8706: FORALL k IN l_def_plan_txn_ra_id_tbl.FIRST .. l_def_plan_txn_ra_id_tbl.LAST
8707: INSERT INTO pa_resource_asgn_curr_tmp
8708: (RA_TXN_ID,
8709: BUDGET_VERSION_ID,
8710: RESOURCE_ASSIGNMENT_ID,
8711: TXN_CURRENCY_CODE,

Line 8714: (pa_resource_asgn_curr_s.nextval,

8710: RESOURCE_ASSIGNMENT_ID,
8711: TXN_CURRENCY_CODE,
8712: expenditure_type)
8713: VALUES
8714: (pa_resource_asgn_curr_s.nextval,
8715: p_budget_version_id,
8716: l_def_plan_txn_ra_id_tbl(k),
8717: /*l_def_txn_curr_code); */
8718: nvl(l_curr_code_temp_tbl(k),l_def_txn_curr_code), /* janani */

Line 8721: -- The overriden rates present in pa_resource_asgn_curr should be retained.

8717: /*l_def_txn_curr_code); */
8718: nvl(l_curr_code_temp_tbl(k),l_def_txn_curr_code), /* janani */
8719: l_expenditure_type_tbl(k));
8720: --Start Bug 8223977
8721: -- The overriden rates present in pa_resource_asgn_curr should be retained.
8722: -- when resource is added using add row option .Updating the same in tmp table.
8723: OPEN rate_update_cur;
8724: FETCH rate_update_cur
8725: BULK COLLECT INTO

Line 8734: UPDATE pa_resource_asgn_curr_tmp

8730: CLOSE rate_update_cur;
8731:
8732: IF l_res_assignment_id_tbl.COUNT > 0 THEN
8733: FORALL i in l_res_assignment_id_tbl.FIRST .. l_res_assignment_id_tbl.LAST
8734: UPDATE pa_resource_asgn_curr_tmp
8735: SET txn_raw_cost_rate_override = l_raw_cost_rate_ovr_tbl(i),
8736: txn_burden_cost_rate_override = l_burd_cost_rate_ovr_tbl(i),
8737: txn_bill_rate_override = l_bill_rate_ovr_tbl(i)
8738: WHERE resource_assignment_id = l_res_assignment_id_tbl(i);