APPS.PA_PLANNING_TRANSACTION_UTILS dependencies on PJI_FM_EXTR_PLAN_LINES

Line 531: --This procedure populates the tmp table PJI_FM_EXTR_PLAN_LINES and calls the API

527: END IF;
528: RAISE;
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

Line 658: pa_debug.g_err_stage:='Emptying the PJI_FM_EXTR_PLAN_LINES ';

654: END IF;
655:
656:
657: IF l_debug_mode = 'Y' THEN
658: pa_debug.g_err_stage:='Emptying the PJI_FM_EXTR_PLAN_LINES ';
659: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
660: END IF;
661:
662: --Getting the project id to call the function PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID

Line 675: pa_debug.g_err_stage:='Source is PJI_FM_EXTR_PLAN_LINES. Populating the tmp table';

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';
676: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
677: END IF;
678:
679: INSERT INTO PJI_FM_EXTR_PLAN_LINES

Line 679: INSERT INTO PJI_FM_EXTR_PLAN_LINES

675: pa_debug.g_err_stage:='Source is PJI_FM_EXTR_PLAN_LINES. Populating the tmp table';
676: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
677: END IF;
678:
679: INSERT INTO PJI_FM_EXTR_PLAN_LINES
680: ( PROJECT_ID
681: ,PROJECT_ORG_ID
682: ,PROJECT_ELEMENT_ID
683: ,STRUCT_VER_ID

Line 780: INSERT INTO PJI_FM_EXTR_PLAN_LINES

776: pa_debug.g_err_stage:='Selectiong from PA_FP_RA_MAP_TMP ';
777: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
778: END IF;
779:
780: INSERT INTO PJI_FM_EXTR_PLAN_LINES
781: ( PROJECT_ID
782: ,PROJECT_ORG_ID
783: ,PROJECT_ELEMENT_ID
784: ,STRUCT_VER_ID

Line 875: INSERT INTO PJI_FM_EXTR_PLAN_LINES

871: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
872: END IF;
873:
874: FORALL i IN p_resource_assignment_id_tbl.FIRST..p_resource_assignment_id_tbl.LAST
875: INSERT INTO PJI_FM_EXTR_PLAN_LINES
876: ( PROJECT_ID
877: ,PROJECT_ORG_ID
878: ,PROJECT_ELEMENT_ID
879: ,STRUCT_VER_ID

Line 965: INSERT INTO PJI_FM_EXTR_PLAN_LINES

961: pa_debug.g_err_stage:='p_budget_version is ' || p_budget_version_id;
962: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
963: END IF;
964:
965: INSERT INTO PJI_FM_EXTR_PLAN_LINES
966: ( PROJECT_ID
967: ,PROJECT_ORG_ID
968: ,PROJECT_ELEMENT_ID
969: ,STRUCT_VER_ID