DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_PUB dependencies on PA_FP_RA_MAP_TMP

Line 2347: --pa_fp_ra_map_tmp.

2343: /* END IF; Commented for bug 2706430 */
2344: END IF;
2345:
2346: --Calling copy_resource_assignments to insert records in pa_resource_assignments using
2347: --pa_fp_ra_map_tmp.
2348:
2349:
2350: --If the calling module is Financial Planning then its not required to go thru te route of
2351: --create_res_Task_maps as copy_resource_assignments would take care of the mapping logic too

Line 2440: --and store them in pa_fp_ra_map_tmp table

2436: --and target resource assignments. After that resource assignments and budget lines should be copied.
2437: ELSIF p_calling_module = PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_ORG_FORECAST THEN
2438:
2439: --Calling create_res_task_maps api to generate new resource_assignment_ids
2440: --and store them in pa_fp_ra_map_tmp table
2441:
2442:
2443: IF P_PA_DEBUG_MODE = 'Y' THEN
2444: pa_debug.g_err_stage := 'Calling create_res_task_maps';

Line 4577: --Fetch corresponding target resource assignment id from pa_fp_ra_map_tmp

4573: loop
4574: fetch l_ra_csr into l_ra_rec;
4575: exit when l_ra_csr%NOTFOUND;
4576:
4577: --Fetch corresponding target resource assignment id from pa_fp_ra_map_tmp
4578:
4579: select target_res_assignment_id
4580: into l_resource_assignment_id
4581: from pa_fp_ra_map_tmp

Line 4581: from pa_fp_ra_map_tmp

4577: --Fetch corresponding target resource assignment id from pa_fp_ra_map_tmp
4578:
4579: select target_res_assignment_id
4580: into l_resource_assignment_id
4581: from pa_fp_ra_map_tmp
4582: where source_res_assignment_id = l_ra_rec.resource_assignment_id;
4583:
4584: /* PA_FP_ADJ_ELEMENTS: Insert new row for all existing rows with the same budget_version_id */
4585: open l_ae_csr;