DBA Data[Home] [Help]

APPS.PA_PLANNING_TRANSACTION_UTILS dependencies on PA_RBS_PLANS_OUT_TMP

Line 533: -- 1. PA_RBS_PLANS_OUT_TMP (This is the tmp table which contains the mapped rbs elemend ids ). The PJI API will

529:
530: END get_default_planning_dates;
531: --This procedure populates the tmp table PJI_FM_EXTR_PLAN_LINES and calls the API
532: --PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE . The valid values for p_source are
533: -- 1. PA_RBS_PLANS_OUT_TMP (This is the tmp table which contains the mapped rbs elemend ids ). The PJI API will
534: -- be called for the rbs element ids availabe in the PA_RBS_PLANS_OUT_TMP, if the new rbs element id is different
535: -- from the already existing rbs element id in pa_resource_assignments. If the rbs element id is different then
536: ---------1.Reporting lines API will be called with negative amounts for the budget lines with
537: -- start_date <= etc_start_date with old rbs element id. The same API will be called for the same set of

Line 534: -- be called for the rbs element ids availabe in the PA_RBS_PLANS_OUT_TMP, if the new rbs element id is different

530: END get_default_planning_dates;
531: --This procedure populates the tmp table PJI_FM_EXTR_PLAN_LINES and calls the API
532: --PJI_FM_XBS_ACCUM_MAINT.PLAN_UPDATE . The valid values for p_source are
533: -- 1. PA_RBS_PLANS_OUT_TMP (This is the tmp table which contains the mapped rbs elemend ids ). The PJI API will
534: -- be called for the rbs element ids availabe in the PA_RBS_PLANS_OUT_TMP, if the new rbs element id is different
535: -- from the already existing rbs element id in pa_resource_assignments. If the rbs element id is different then
536: ---------1.Reporting lines API will be called with negative amounts for the budget lines with
537: -- start_date <= etc_start_date with old rbs element id. The same API will be called for the same set of
538: -- budget lines with +ve amounts and new rbs element id again.

Line 671: IF p_source = 'PA_RBS_PLANS_OUT_TMP' OR

667: l_fin_structure_ver_id := PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(l_project_id);
668:
669:
670:
671: IF p_source = 'PA_RBS_PLANS_OUT_TMP' OR
672: p_source = 'PROCESS_RES_CHG_DERV_CALC_PRMS'THEN
673:
674: IF l_debug_mode = 'Y' THEN
675: pa_debug.g_err_stage:='Source is PJI_FM_EXTR_PLAN_LINES. Populating the tmp table';

Line 743: ,pa_rbs_plans_out_tmp tmp

739: FROM pa_projects_all p
740: ,pa_resource_assignments pra
741: ,pa_budget_versions pbv
742: ,pa_proj_fp_options pfo
743: ,pa_rbs_plans_out_tmp tmp
744: ,pa_budget_lines pbl
745: ,(SELECT 'OLD' as rbs_elem_id
746: FROM DUAL
747: UNION ALL