APPS.PA_FP_UPGRADE_PKG dependencies on PA_RESOURCE_ASSIGNMENTS

Line 15: pa_resource_assignments.resource_assignment_id%TYPE INDEX BY BINARY_INTEGER;

11: TYPE bud_typ_code_tbl IS TABLE OF
12: pa_budget_versions.budget_type_code%TYPE INDEX BY BINARY_INTEGER;
13:
14: TYPE ra_id_tbl_type IS TABLE OF
15: pa_resource_assignments.resource_assignment_id%TYPE INDEX BY BINARY_INTEGER;
16:
17: TYPE rtx_ra_id_tbl_type IS TABLE OF
18: pa_resource_asgn_curr.resource_assignment_id%TYPE INDEX BY BINARY_INTEGER;
19:

Line 2296: UPDATE PA_RESOURCE_ASSIGNMENTS

2292: pa_debug.g_err_stage := 'Updating resource assignments '||l_budget_ver_tbl(j);
2293: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
2294: END IF;
2295:
2296: UPDATE PA_RESOURCE_ASSIGNMENTS
2297: SET resource_assignment_type = PA_FP_CONSTANTS_PKG.G_USER_ENTERED
2298: WHERE budget_version_id = l_budget_ver_tbl(j);
2299:
2300: --Populate txn currency buckets from the project functional currency buckets of budget lines

Line 2489: ,pa_resource_assignments ra

2485: ,l_upg_txn_burdened_cost_tbl
2486: ,l_upg_txn_revenue_tbl
2487: ,l_upg_rate_based_flag_tbl
2488: FROM pa_budget_lines bl
2489: ,pa_resource_assignments ra
2490: WHERE bl.resource_assignment_id=ra.resource_assignment_id
2491: AND bl.budget_version_id=l_budget_ver_tbl(m)
2492: ORDER BY bl.resource_assignment_id ,bl.quantity NULLS FIRST;
2493:

Line 2539: UPDATE PA_RESOURCE_ASSIGNMENTS ra

2535: END IF;
2536:
2537: FORALL j IN 1..l_upg_non_rb_ra_id_tbl.COUNT
2538:
2539: UPDATE PA_RESOURCE_ASSIGNMENTS ra
2540: SET ra.rate_based_flag = 'N'
2541: ,ra.unit_of_measure = 'DOLLARS'
2542: WHERE ra.resource_assignment_id = l_upg_non_rb_ra_id_tbl(j);
2543:

Line 3807: l_prev_non_rb_ra_id pa_resource_assignments.resource_assignment_id%TYPE;

3803: l_debug_mode VARCHAR2(30);
3804: l_module_name VARCHAR2(200) := 'PAFPUPGB.Apply_Calculate_FPM_Rules';
3805:
3806: --Stores previous non rate based resource assignment id
3807: l_prev_non_rb_ra_id pa_resource_assignments.resource_assignment_id%TYPE;
3808:
3809: --Processing will be done in the following local variables
3810: l_quantity_tab SYSTEM.pa_num_tbl_type;
3811: l_txn_raw_cost_tab SYSTEM.pa_num_tbl_type;

Line 4529: -- We try to lock the records in pa_resource_asgn_curr,pa_resource_assignments

4525:
4526: IF l_process_flag = 'Y' THEN /* 5084161 */
4527:
4528: -- Now we have a budget version id and we will try to lock these
4529: -- We try to lock the records in pa_resource_asgn_curr,pa_resource_assignments
4530: -- as well to avoid the partial processing.
4531: -- Imagine the case where the ra records are processed and now we fail
4532: -- to obtain a lock on budget versions record. In order to avoid this
4533: -- we obtain locks on all the records in all the table and then we will

Line 4575: FROM pa_resource_assignments ra

4571: END IF;
4572:
4573:
4574: SELECT ra.resource_assignment_id BULK COLLECT INTO l_ra_id_tbl
4575: FROM pa_resource_assignments ra
4576: WHERE ra.budget_version_id = l_bv_id
4577: FOR UPDATE OF ra.resource_assignment_id NOWAIT;
4578:
4579: IF p_pa_debug_mode = 'Y' THEN