DBA Data[Home] [Help]

APPS.PA_FIN_PLAN_PUB dependencies on PA_FP_RA_MAP_TMP

Line 2331: --pa_fp_ra_map_tmp.

2327: /* END IF; Commented for bug 2706430 */
2328: END IF;
2329:
2330: --Calling copy_resource_assignments to insert records in pa_resource_assignments using
2331: --pa_fp_ra_map_tmp.
2332:
2333:
2334: --If the calling module is Financial Planning then its not required to go thru te route of
2335: --create_res_Task_maps as copy_resource_assignments would take care of the mapping logic too

Line 2424: --and store them in pa_fp_ra_map_tmp table

2420: --and target resource assignments. After that resource assignments and budget lines should be copied.
2421: ELSIF p_calling_module = PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_ORG_FORECAST THEN
2422:
2423: --Calling create_res_task_maps api to generate new resource_assignment_ids
2424: --and store them in pa_fp_ra_map_tmp table
2425:
2426:
2427: IF P_PA_DEBUG_MODE = 'Y' THEN
2428: pa_debug.g_err_stage := 'Calling create_res_task_maps';

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

4557: loop
4558: fetch l_ra_csr into l_ra_rec;
4559: exit when l_ra_csr%NOTFOUND;
4560:
4561: --Fetch corresponding target resource assignment id from pa_fp_ra_map_tmp
4562:
4563: select target_res_assignment_id
4564: into l_resource_assignment_id
4565: from pa_fp_ra_map_tmp

Line 4565: from pa_fp_ra_map_tmp

4561: --Fetch corresponding target resource assignment id from pa_fp_ra_map_tmp
4562:
4563: select target_res_assignment_id
4564: into l_resource_assignment_id
4565: from pa_fp_ra_map_tmp
4566: where source_res_assignment_id = l_ra_rec.resource_assignment_id;
4567:
4568: /* PA_FP_ADJ_ELEMENTS: Insert new row for all existing rows with the same budget_version_id */
4569: open l_ae_csr;