DBA Data[Home] [Help]

APPS.PA_PROGRESS_PUB dependencies on PJI_FM_EXTR_PLAN_LINES

Line 10348: INSERT INTO PJI_FM_EXTR_PLAN_LINES (

10344: pa_debug.write(x_Module=>'PA_PROGRESS_PUB.PUSH_WORKPLAN_ACTUALS', x_Msg => 'l_etc_POU_raw_COST_this_period='||l_etc_POU_raw_COST_this_period, x_Log_Level=> 3);
10345: END IF;
10346:
10347:
10348: INSERT INTO PJI_FM_EXTR_PLAN_LINES (
10349: PROJECT_ID
10350: ,PROJECT_ORG_ID
10351: ,PROJECT_ELEMENT_ID
10352: ,STRUCT_VER_ID

Line 10428: p_error_text => SUBSTRB('INSERT INTO PJI_FM_EXTR_PLAN_LINES:'||SQLERRM,1,120));

10424: EXCEPTION
10425: WHEN OTHERS THEN
10426: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PROGRESS_PUB',
10427: p_procedure_name => 'push_workplan_actuals',
10428: p_error_text => SUBSTRB('INSERT INTO PJI_FM_EXTR_PLAN_LINES:'||SQLERRM,1,120));
10429: RAISE FND_API.G_EXC_ERROR;
10430: END;
10431:
10432: -- Bug 4186007 Begin

Line 18080: INSERT INTO PJI_FM_EXTR_PLAN_LINES(

18076: x_Log_Level=> 3);
18077: END IF;
18078:
18079: FORALL i IN 1..l_index_etc
18080: INSERT INTO PJI_FM_EXTR_PLAN_LINES(
18081: PROJECT_ID
18082: ,PROJECT_ORG_ID
18083: ,PROJECT_ELEMENT_ID
18084: ,STRUCT_VER_ID

Line 18255: DELETE PJI_FM_EXTR_PLAN_LINES where PROJECT_ID = proj_ids_tbl(l_index);

18251: if l_act_err_flag(l_index) = 1 then
18252: PJI_FM_XBS_ACCUM_UTILS.DELETE_FIN8 (p_project_id => proj_ids_tbl(l_index),
18253: p_err_flag => l_act_err_flag(l_index),
18254: p_err_msg => l_act_err_msg(l_index));
18255: DELETE PJI_FM_EXTR_PLAN_LINES where PROJECT_ID = proj_ids_tbl(l_index);
18256: DELETE PA_PROG_ACT_BY_PERIOD_TEMP where PROJECT_ID = proj_ids_tbl(l_index);
18257: else
18258: if (p_plan_res_level = 'Y') and l_get_summ_call_contxt in ('P', 'W') then
18259: PJI_FM_XBS_ACCUM_UTILS.DELETE_FIN8 (p_project_id => proj_ids_tbl(l_index),

Line 18338: DELETE PJI_FM_EXTR_PLAN_LINES where PROJECT_ID = proj_ids_tbl(l_index);

18334: if l_act_err_flag(l_index) = 1 then
18335: PJI_FM_XBS_ACCUM_UTILS.DELETE_FIN8 (p_project_id => proj_ids_tbl(l_index),
18336: p_err_flag => l_act_err_flag(l_index),
18337: p_err_msg => l_act_err_msg(l_index));
18338: DELETE PJI_FM_EXTR_PLAN_LINES where PROJECT_ID = proj_ids_tbl(l_index);
18339: DELETE PA_PROG_ACT_BY_PERIOD_TEMP where PROJECT_ID = proj_ids_tbl(l_index);
18340: PA_PROJECT_STRUCTURE_UTILS.SET_PROCESS_CODE(proj_ids_tbl(l_index),
18341: latest_wp_struct_ver_ids_tbl(l_index),
18342: 'PRE',

Line 20373: INSERT INTO PJI_FM_EXTR_PLAN_LINES(

20369: end loop;
20370: END IF;
20371:
20372: FORALL l_count IN 1..l_index
20373: INSERT INTO PJI_FM_EXTR_PLAN_LINES(
20374: PROJECT_ID
20375: ,PROJECT_ORG_ID
20376: ,PROJECT_ELEMENT_ID
20377: ,STRUCT_VER_ID