APPS.PJI_FM_PLAN_EXTR dependencies on PJI_FM_EXTR_PLN_LOG

Line 213: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLN_LOG', 'NORMAL',null);

209: begin
210:
211: pji_utils.write2log('Entering PJI_FM_PLAN_EXTR.CLEANUP_LOG',TRUE, 3);
212:
213: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLN_LOG', 'NORMAL',null);
214:
215: pji_utils.write2log('Completed PJI_FM_PLAN_EXTR.CLEANUP_LOG',TRUE, 3);
216:
217: end cleanup_log;

Line 1901: Insert /*+ APPEND */ into PJI_FM_EXTR_PLN_LOG

1897: return;
1898: end if;
1899:
1900:
1901: Insert /*+ APPEND */ into PJI_FM_EXTR_PLN_LOG
1902: (PROJECT_ID
1903: ,PROJECT_ORG_ID
1904: ,PLAN_TYPE_CODE
1905: ,BUDGET_VERSION_ID

Line 2191: PJI_FM_EXTR_PLN_LOG log

2187: to_number(null))) curr_forecast_labor_hrs
2188: from
2189: PJI_FM_EXTR_PLNVER1 vers,
2190: PJI_FM_EXTR_PLAN tmp,
2191: PJI_FM_EXTR_PLN_LOG log
2192: where
2193: tmp.WORKER_ID = p_worker_id and
2194: tmp.LINE_TYPE <> 'F1' and
2195: vers.WORKER_ID = p_worker_id and

Line 2352: PJI_FM_EXTR_PLN_LOG log

2348: from
2349: PJI_PJI_PROJ_BATCH_MAP map,
2350: PJI_FM_EXTR_PLNVER1 bvs,
2351: PJI_FM_EXTR_PLAN tmp,
2352: PJI_FM_EXTR_PLN_LOG log
2353: where
2354: map.worker_id = p_worker_id
2355: and map.project_id = bvs.project_id
2356: and bvs.worker_id = p_worker_id