eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_PJ_PROJ_CLASS_EXTR dependencies on PJI_PJ_PROJ_CLASS_EXTR

Line 1: PACKAGE BODY Pji_Pj_Proj_Class_Extr AS

1: PACKAGE BODY Pji_Pj_Proj_Class_Extr AS
2: /* $Header: PJISF10B.pls 120.3.12010000.2 2008/10/28 23:16:36 arbandyo ship $ */
3:
4: -- variables ------------------------------------
5:

Line 38: Pji_Utils.write2log('Entering PJI_PJ_PROJ_CLASS_EXTR.EXTR_CLASS_CODES_PVT',TRUE,2);

34: -- have detected dangling classification records. In order to serialize
35: -- access to classification dimension tables we use LOCK TABLE statement
36: -- below.
37:
38: Pji_Utils.write2log('Entering PJI_PJ_PROJ_CLASS_EXTR.EXTR_CLASS_CODES_PVT',TRUE,2);
39:
40: LOCK TABLE pji_class_categories IN EXCLUSIVE MODE;
41:
42: Pji_Utils.write2log('Locked table PJI_CLASS_CATEGORIES in exclusive mode',TRUE,2);

Line 190: Pji_Utils.write2log('Completed PJI_PJ_PROJ_CLASS_EXTR.EXTR_CLASS_CODES_PVT',TRUE,2);

186: -- be called from other program units so that we do
187: -- not want to commit in the middle of somebody else's
188: -- transaction.
189:
190: Pji_Utils.write2log('Completed PJI_PJ_PROJ_CLASS_EXTR.EXTR_CLASS_CODES_PVT',TRUE,2);
191:
192: END;
193:
194:

Line 229: 'PJI_PJ_PROJ_CLASS_EXTR.EXTR_PROJECT_CLASSES(p_worker_id);')) THEN

225:
226: l_process := g_process || TO_CHAR(g_worker_id);
227:
228: IF (NOT Pji_Process_Util.NEED_TO_RUN_STEP(l_process,
229: 'PJI_PJ_PROJ_CLASS_EXTR.EXTR_PROJECT_CLASSES(p_worker_id);')) THEN
230: RETURN;
231: END IF;
232:
233: l_extraction_type := Pji_Process_Util.Get_Process_Parameter

Line 246: Pji_Utils.write2log('Entering PJI_PJ_PROJ_CLASS_EXTR.EXTR_PROJECT_CLASSES',TRUE,2);

242: -- If extraction type is incremental (or partial) then we extract
243: -- records from PA_PROJECT_CLASSES that have corresponding log
244: -- records plus log records themselves with reverse sign.
245:
246: Pji_Utils.write2log('Entering PJI_PJ_PROJ_CLASS_EXTR.EXTR_PROJECT_CLASSES',TRUE,2);
247:
248: /*
249: ** Extract all the change records from event log
250: ** to pji_pj_extr_prjcls to create a snapshot of

Line 666: Pji_Process_Util.REGISTER_STEP_COMPLETION(l_process,'PJI_PJ_PROJ_CLASS_EXTR.EXTR_PROJECT_CLASSES(p_worker_id);');

662:
663: Pji_Utils.write2log('Merged ' || SQL%ROWCOUNT ||
664: ' record(s) into pji_project_classes',TRUE,2);
665:
666: Pji_Process_Util.REGISTER_STEP_COMPLETION(l_process,'PJI_PJ_PROJ_CLASS_EXTR.EXTR_PROJECT_CLASSES(p_worker_id);');
667:
668: -- truncate intermediate tables no longer required
669: l_schema := Pji_Utils.GET_PJI_SCHEMA_NAME;
670: --Pji_Process_Util.TRUNC_INT_TABLE( l_schema , 'PJI_PJ_EXTR_PRJCLS' , 'NORMAL',NULL);

Line 674: Pji_Utils.write2log('Completed PJI_PJ_PROJ_CLASS_EXTR.EXTR_PROJECT_CLASSES',TRUE,2);

670: --Pji_Process_Util.TRUNC_INT_TABLE( l_schema , 'PJI_PJ_EXTR_PRJCLS' , 'NORMAL',NULL);
671:
672: COMMIT;
673:
674: Pji_Utils.write2log('Completed PJI_PJ_PROJ_CLASS_EXTR.EXTR_PROJECT_CLASSES',TRUE,2);
675:
676: END extr_project_classes;
677:
678: -- ------------------------------------------------

Line 692: -- 'PJI_PJ_PROJ_CLASS_EXTR.CLEANUP(p_worker_id);')) then

688: g_worker_id := p_worker_id;
689: l_process := g_process || TO_CHAR(g_worker_id);
690:
691: -- if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process,
692: -- 'PJI_PJ_PROJ_CLASS_EXTR.CLEANUP(p_worker_id);')) then
693: -- return;
694: -- end if;
695:
696:

Line 697: Pji_Utils.write2log('Entering PJI_PJ_PROJ_CLASS_EXTR.TRUNCATE_INTERIM_TABLES',TRUE,2);

693: -- return;
694: -- end if;
695:
696:
697: Pji_Utils.write2log('Entering PJI_PJ_PROJ_CLASS_EXTR.TRUNCATE_INTERIM_TABLES',TRUE,2);
698:
699: l_pji_schema := Pji_Utils.get_pji_schema_name;
700:
701: Pji_Process_Util.TRUNC_INT_TABLE( l_pji_schema , 'PJI_PJ_EXTR_PRJCLS', 'NORMAL',NULL);

Line 703: -- PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,'PJI_PJ_PROJ_CLASS_EXTR.CLEANUP(p_worker_id)');

699: l_pji_schema := Pji_Utils.get_pji_schema_name;
700:
701: Pji_Process_Util.TRUNC_INT_TABLE( l_pji_schema , 'PJI_PJ_EXTR_PRJCLS', 'NORMAL',NULL);
702:
703: -- PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,'PJI_PJ_PROJ_CLASS_EXTR.CLEANUP(p_worker_id)');
704:
705: COMMIT;
706:
707: Pji_Utils.write2log('Completed PJI_PJ_PROJ_CLASS_EXTR.TRUNCATE_INTERIM_TABLES',TRUE,2);

Line 707: Pji_Utils.write2log('Completed PJI_PJ_PROJ_CLASS_EXTR.TRUNCATE_INTERIM_TABLES',TRUE,2);

703: -- PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process,'PJI_PJ_PROJ_CLASS_EXTR.CLEANUP(p_worker_id)');
704:
705: COMMIT;
706:
707: Pji_Utils.write2log('Completed PJI_PJ_PROJ_CLASS_EXTR.TRUNCATE_INTERIM_TABLES',TRUE,2);
708:
709: END;
710:
711: END Pji_Pj_Proj_Class_Extr;

Line 711: END Pji_Pj_Proj_Class_Extr;

707: Pji_Utils.write2log('Completed PJI_PJ_PROJ_CLASS_EXTR.TRUNCATE_INTERIM_TABLES',TRUE,2);
708:
709: END;
710:
711: END Pji_Pj_Proj_Class_Extr;