APPS.PA_FP_PJI_INTG_PKG dependencies on PJI_FM_EXTR_PLAN_LINES

Line 288: * Bug fix:3803569 --DELETE FROM PJI_FM_EXTR_PLAN_LINES;

284: l_num_rows_inserted := 0;
285: /* since this is not a tmp table, deleteing will delete all the
286: * pending transactions inserted from other sessions
287: * so commenting out the code
288: * Bug fix:3803569 --DELETE FROM PJI_FM_EXTR_PLAN_LINES;
289: */
290:
291: l_stage := 80;
292: INSERT INTO PJI_FM_EXTR_PLAN_LINES

Line 292: INSERT INTO PJI_FM_EXTR_PLAN_LINES

288: * Bug fix:3803569 --DELETE FROM PJI_FM_EXTR_PLAN_LINES;
289: */
290:
291: l_stage := 80;
292: INSERT INTO PJI_FM_EXTR_PLAN_LINES
293: ( PROJECT_ID
294: ,PROJECT_ORG_ID
295: ,PROJECT_ELEMENT_ID
296: ,STRUCT_VER_ID

Line 1048: print_msg(l_stage||': Inserting records into PJI_FM_EXTR_PLAN_LINES tmp table');

1044: IF l_rep_res_assignment_id_tab.COUNT > 0 Then --{
1045: l_num_rows_inserted := 0;
1046: l_stage := 80;
1047: If g_debug_flag = 'Y' Then
1048: print_msg(l_stage||': Inserting records into PJI_FM_EXTR_PLAN_LINES tmp table');
1049: End If;
1050: FORALL i IN l_rep_res_assignment_id_tab.FIRST .. l_rep_res_assignment_id_tab.LAST
1051: INSERT INTO PJI_FM_EXTR_PLAN_LINES
1052: ( PROJECT_ID

Line 1051: INSERT INTO PJI_FM_EXTR_PLAN_LINES

1047: If g_debug_flag = 'Y' Then
1048: print_msg(l_stage||': Inserting records into PJI_FM_EXTR_PLAN_LINES tmp table');
1049: End If;
1050: FORALL i IN l_rep_res_assignment_id_tab.FIRST .. l_rep_res_assignment_id_tab.LAST
1051: INSERT INTO PJI_FM_EXTR_PLAN_LINES
1052: ( PROJECT_ID
1053: ,PROJECT_ORG_ID
1054: ,PROJECT_ELEMENT_ID
1055: ,STRUCT_VER_ID

Line 1163: from PJI_FM_EXTR_PLAN_LINES pj

1159: ,sum(pj.ACT_QUANTITY) ACT_QUANTITY
1160: ,sum(pj.ACT_TXN_RAW_COST) ACT_TXN_RAW_COST
1161: ,sum(pj.ACT_TXN_BURDENED_COST) ACT_TXN_BURDENED_COST
1162: ,sum(pj.ACT_TXN_REVENUE) ACT_TXN_REVENUE
1163: from PJI_FM_EXTR_PLAN_LINES pj
1164: where pj.plan_version_id = p_budget_version_id
1165: Group by pj.RBS_VERSION_ID
1166: ,pj.RBS_ELEMENT_ID
1167: ,pj.TXN_CURRENCY_CODE