APPS.PA_FP_PJI_INTG_PKG dependencies on PJI_FM_EXTR_PLAN_LINES

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

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

Line 291: INSERT INTO PJI_FM_EXTR_PLAN_LINES

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

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

1034: IF l_rep_res_assignment_id_tab.COUNT > 0 Then --{
1035: l_num_rows_inserted := 0;
1036: l_stage := 80;
1037: If g_debug_flag = 'Y' Then
1038: print_msg(l_stage||': Inserting records into PJI_FM_EXTR_PLAN_LINES tmp table');
1039: End If;
1040: FORALL i IN l_rep_res_assignment_id_tab.FIRST .. l_rep_res_assignment_id_tab.LAST
1041: INSERT INTO PJI_FM_EXTR_PLAN_LINES
1042: ( PROJECT_ID

Line 1041: INSERT INTO PJI_FM_EXTR_PLAN_LINES

1037: If g_debug_flag = 'Y' Then
1038: print_msg(l_stage||': Inserting records into PJI_FM_EXTR_PLAN_LINES tmp table');
1039: End If;
1040: FORALL i IN l_rep_res_assignment_id_tab.FIRST .. l_rep_res_assignment_id_tab.LAST
1041: INSERT INTO PJI_FM_EXTR_PLAN_LINES
1042: ( PROJECT_ID
1043: ,PROJECT_ORG_ID
1044: ,PROJECT_ELEMENT_ID
1045: ,STRUCT_VER_ID

Line 1151: from PJI_FM_EXTR_PLAN_LINES pj

1147: ,sum(pj.ACT_QUANTITY) ACT_QUANTITY
1148: ,sum(pj.ACT_TXN_RAW_COST) ACT_TXN_RAW_COST
1149: ,sum(pj.ACT_TXN_BURDENED_COST) ACT_TXN_BURDENED_COST
1150: ,sum(pj.ACT_TXN_REVENUE) ACT_TXN_REVENUE
1151: from PJI_FM_EXTR_PLAN_LINES pj
1152: where pj.plan_version_id = p_budget_version_id
1153: Group by pj.RBS_VERSION_ID
1154: ,pj.RBS_ELEMENT_ID
1155: ,pj.TXN_CURRENCY_CODE