DBA Data[Home] [Help]

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 659: pa_debug.g_err_stage:='Emptying the PJI_FM_EXTR_PLAN_LINES ';

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

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

672: IF p_source = 'PA_RBS_PLANS_OUT_TMP' OR
673: p_source = 'PROCESS_RES_CHG_DERV_CALC_PRMS'THEN
674:
675: IF l_debug_mode = 'Y' THEN
676: pa_debug.g_err_stage:='Source is PJI_FM_EXTR_PLAN_LINES. Populating the tmp table';
677: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
678: END IF;
679:
680: INSERT INTO PJI_FM_EXTR_PLAN_LINES

Line 680: INSERT INTO PJI_FM_EXTR_PLAN_LINES

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

Line 783: INSERT INTO PJI_FM_EXTR_PLAN_LINES

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

Line 913: INSERT INTO PJI_FM_EXTR_PLAN_LINES

909: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
910: END IF;
911:
912: FORALL i IN p_resource_assignment_id_tbl.FIRST..p_resource_assignment_id_tbl.LAST
913: INSERT INTO PJI_FM_EXTR_PLAN_LINES
914: ( PROJECT_ID
915: ,PROJECT_ORG_ID
916: ,PROJECT_ELEMENT_ID
917: ,STRUCT_VER_ID

Line 1006: INSERT INTO PJI_FM_EXTR_PLAN_LINES

1002: pa_debug.g_err_stage:='p_budget_version is ' || p_budget_version_id;
1003: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
1004: END IF;
1005:
1006: INSERT INTO PJI_FM_EXTR_PLAN_LINES
1007: ( PROJECT_ID
1008: ,PROJECT_ORG_ID
1009: ,PROJECT_ELEMENT_ID
1010: ,STRUCT_VER_ID

Line 1095: --delete from DEBUG_PJI_FM_EXTR_PLAN_LINES;

1091:
1092: END IF;
1093:
1094:
1095: --delete from DEBUG_PJI_FM_EXTR_PLAN_LINES;
1096: /*
1097: DEBUG_NS('Before insert = ' || l_rows_inserted);
1098: insert into DEBUG_PJI_FM_EXTR_PLAN_LINES (select * from PJI_FM_EXTR_PLAN_LINES) ;
1099: commit;

Line 1098: insert into DEBUG_PJI_FM_EXTR_PLAN_LINES (select * from PJI_FM_EXTR_PLAN_LINES) ;

1094:
1095: --delete from DEBUG_PJI_FM_EXTR_PLAN_LINES;
1096: /*
1097: DEBUG_NS('Before insert = ' || l_rows_inserted);
1098: insert into DEBUG_PJI_FM_EXTR_PLAN_LINES (select * from PJI_FM_EXTR_PLAN_LINES) ;
1099: commit;
1100: DEBUG_NS('After insert = ' || l_rows_inserted);
1101: */
1102: