[Home] [Help]
10783: -- Bug 15928585
10784: -- Commenting this insert since after this PJI API is not called.
10785: -- This data is staying in the table and is getting used in the next user update to plan
10786: -- amounts and causing data corruption.
10787: /* INSERT INTO PJI_FM_EXTR_PLAN_LINES (
10788: PROJECT_ID
10789: ,PROJECT_ORG_ID
10790: ,PROJECT_ELEMENT_ID
10791: ,STRUCT_VER_ID
10866: EXCEPTION
10867: WHEN OTHERS THEN
10868: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
10869: p_procedure_name => 'push_workplan_actuals',
10870: p_error_text => SUBSTRB('INSERT INTO PJI_FM_EXTR_PLAN_LINES:'||SQLERRM,1,120));
10871: RAISE FND_API.G_EXC_ERROR;
10872: END;
10873:
10874: -- Bug 4186007 Begin
19517: -- as i was not getting set properly
19518:
19519: if ( etc_project_id.count > 0 ) then
19520: FORALL i IN ETC_PROJECT_ID.first..ETC_PROJECT_ID.last
19521: INSERT INTO PJI_FM_EXTR_PLAN_LINES(
19522: PROJECT_ID
19523: ,PROJECT_ORG_ID
19524: ,PROJECT_ELEMENT_ID
19525: ,STRUCT_VER_ID
19696: if l_act_err_flag(l_index) = 1 then
19697: PJI_FM_XBS_ACCUM_UTILS.DELETE_FIN8 (p_project_id => proj_ids_tbl(l_index),
19698: p_err_flag => l_act_err_flag(l_index),
19699: p_err_msg => l_act_err_msg(l_index));
19700: DELETE PJI_FM_EXTR_PLAN_LINES where PROJECT_ID = proj_ids_tbl(l_index);
19701: DELETE PA_PROG_ACT_BY_PERIOD_TEMP where PROJECT_ID = proj_ids_tbl(l_index);
19702: else
19703: if (p_plan_res_level = 'Y') and l_get_summ_call_contxt in ('P', 'W') then
19704: PJI_FM_XBS_ACCUM_UTILS.DELETE_FIN8 (p_project_id => proj_ids_tbl(l_index),
19779: if l_act_err_flag(l_index) = 1 then
19780: PJI_FM_XBS_ACCUM_UTILS.DELETE_FIN8 (p_project_id => proj_ids_tbl(l_index),
19781: p_err_flag => l_act_err_flag(l_index),
19782: p_err_msg => l_act_err_msg(l_index));
19783: DELETE PJI_FM_EXTR_PLAN_LINES where PROJECT_ID = proj_ids_tbl(l_index);
19784: DELETE PA_PROG_ACT_BY_PERIOD_TEMP where PROJECT_ID = proj_ids_tbl(l_index);
19785: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE(proj_ids_tbl(l_index),
19786: latest_wp_struct_ver_ids_tbl(l_index),
19787: 'PRE',
21832: end loop;
21833: END IF;
21834:
21835: FORALL l_count IN 1..l_index
21836: INSERT INTO PJI_FM_EXTR_PLAN_LINES(
21837: PROJECT_ID
21838: ,PROJECT_ORG_ID
21839: ,PROJECT_ELEMENT_ID
21840: ,STRUCT_VER_ID