APPS.PJI_PJI_EXTRACTION_UTILS dependencies on PJI_EXTRACTION_UTIL

Line 1: PACKAGE BODY PJI_PJI_EXTRACTION_UTILS as

1: PACKAGE BODY PJI_PJI_EXTRACTION_UTILS as
2: /* $Header: PJIUT07B.pls 120.3 2007/01/25 00:45:54 degupta ship $ */
3:
4: -- -------------------------------------
5: -- procedure UPDATE_PJI_EXTR_SCOPE

Line 119: PJI_EXTRACTION_UTIL.POPULATE_ORG_EXTR_INFO;

115: procedure POPULATE_ORG_EXTR_INFO is
116:
117: begin
118:
119: PJI_EXTRACTION_UTIL.POPULATE_ORG_EXTR_INFO;
120:
121: end POPULATE_ORG_EXTR_INFO;
122:
123:

Line 131: PJI_EXTRACTION_UTIL.UPDATE_ORG_EXTR_INFO;

127: procedure UPDATE_ORG_EXTR_INFO is
128:
129: begin
130:
131: PJI_EXTRACTION_UTIL.UPDATE_ORG_EXTR_INFO;
132:
133: end UPDATE_ORG_EXTR_INFO;
134:
135:

Line 203: PJI_PJI_EXTRACTION_UTILS.UPDATE_PJI_ORG_HRCHY;

199: */
200:
201: if (p_refresh_mview_lookups = 'Y') then
202: PJI_PJ_PROJ_CLASS_EXTR.EXTR_CLASS_CODES;
203: PJI_PJI_EXTRACTION_UTILS.UPDATE_PJI_ORG_HRCHY;
204: end if;
205:
206: commit; -- we need to end any transactions before altering parallel DML
207:

Line 234: PJI_UTILS.write2log('PJI_PJI_EXTRACTION_UTILS.mview_refresh '||sqlerrm);

230: retcode := 0;
231: exception when others then
232: retcode := 2;
233: errbuf := sqlerrm;
234: PJI_UTILS.write2log('PJI_PJI_EXTRACTION_UTILS.mview_refresh '||sqlerrm);
235: PJI_UTILS.write2out('PJI_PJI_EXTRACTION_UTILS.mview_refresh '||sqlerrm);
236: raise;
237: end MVIEW_REFRESH;
238:

Line 235: PJI_UTILS.write2out('PJI_PJI_EXTRACTION_UTILS.mview_refresh '||sqlerrm);

231: exception when others then
232: retcode := 2;
233: errbuf := sqlerrm;
234: PJI_UTILS.write2log('PJI_PJI_EXTRACTION_UTILS.mview_refresh '||sqlerrm);
235: PJI_UTILS.write2out('PJI_PJI_EXTRACTION_UTILS.mview_refresh '||sqlerrm);
236: raise;
237: end MVIEW_REFRESH;
238:
239:

Line 496: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(p_process, 'PJI_PJI_EXTRACTION_UTILS.UPDATE_PJI_RM_WORK_TYPE_INFO(p_process);')) then

492: l_event_id number;
493:
494: begin
495:
496: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(p_process, 'PJI_PJI_EXTRACTION_UTILS.UPDATE_PJI_RM_WORK_TYPE_INFO(p_process);')) then
497: return;
498: end if;
499:
500: select count(*)

Line 771: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(p_process, 'PJI_PJI_EXTRACTION_UTILS.UPDATE_PJI_RM_WORK_TYPE_INFO(p_process);');

767: where wt.RECORD_TYPE = 'CHANGE_OLD');
768:
769: pji_utils.write2log(sql%rowcount || ' rows inserted :3.');
770:
771: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(p_process, 'PJI_PJI_EXTRACTION_UTILS.UPDATE_PJI_RM_WORK_TYPE_INFO(p_process);');
772:
773: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(PJI_UTILS.GET_PJI_SCHEMA_NAME, 'PJI_RM_WORK_TYPE_ROWID', 'NORMAL', null);
774:
775: commit;

Line 918: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(p_process, 'PJI_PJI_EXTRACTION_UTILS.UPDATE_RESOURCE_DATA(p_process);')) then

914: l_extraction_type varchar2(30);
915:
916: begin
917:
918: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(p_process, 'PJI_PJI_EXTRACTION_UTILS.UPDATE_RESOURCE_DATA(p_process);')) then
919: return;
920: end if;
921:
922: select count(*)

Line 1131: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(p_process, 'PJI_PJI_EXTRACTION_UTILS.UPDATE_RESOURCE_DATA(p_process);');

1127: );
1128:
1129: pji_utils.write2log(sql%rowcount || ' rows inserted.');
1130:
1131: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(p_process, 'PJI_PJI_EXTRACTION_UTILS.UPDATE_RESOURCE_DATA(p_process);');
1132:
1133: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(PJI_UTILS.GET_PJI_SCHEMA_NAME, 'PJI_ROWID_RESOURCES_DENORM', 'NORMAL', null);
1134:
1135: commit;

Line 1288: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(errbuf, retcode, 'All', 'C', 'N');

1284: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_RM_RES_BATCH_MAP', 'NORMAL', null);
1285:
1286: retcode := 0;
1287:
1288: PJI_PJI_EXTRACTION_UTILS.MVIEW_REFRESH(errbuf, retcode, 'All', 'C', 'N');
1289:
1290: update PJI_SYSTEM_CONFIG_HIST
1291: set END_DATE = sysdate,
1292: COMPLETION_TEXT = 'Normal completion'

Line 1317: end PJI_PJI_EXTRACTION_UTILS;

1313:
1314: end TRUNCATE_PJI_TABLES;
1315:
1316:
1317: end PJI_PJI_EXTRACTION_UTILS;