APPS.PA_FP_UPGRADE_PKG dependencies on PA_RESOURCE_ASGN_CURR

Line 18: pa_resource_asgn_curr.resource_assignment_id%TYPE INDEX BY BINARY_INTEGER;

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:
20: l_budget_ver_tbl SYSTEM.PA_NUM_TBL_TYPE;
21: l_res_list_tbl res_list_tbl;
22: l_bud_typ_code_tbl bud_typ_code_tbl;

Line 2606: * ii. insert planning transaction records in the new entity pa_resource_asgn_curr

2602: END IF;
2603: */
2604: /* bug 4865563: IPM Changes. Calling APIs which take care of
2605: * i. update the display_quantity new column in pa_budget_lines
2606: * ii. insert planning transaction records in the new entity pa_resource_asgn_curr
2607: * with the appropriate records.
2608: */
2609: PA_BUDGET_LINES_UTILS.populate_display_qty
2610: (p_budget_version_id => l_budget_ver_tbl(m),

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 4564: FROM pa_resource_asgn_curr rtx

4560: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
4561: END IF;
4562:
4563: SELECT rtx.resource_assignment_id BULK COLLECT INTO l_rtx_ra_id_tbl
4564: FROM pa_resource_asgn_curr rtx
4565: WHERE rtx.budget_version_id = l_bv_id
4566: FOR UPDATE OF rtx.resource_assignment_id NOWAIT;
4567:
4568: IF p_pa_debug_mode = 'Y' THEN