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_PJI_PROJ_BATCH_MAP

Line 284: pji_pji_proj_batch_map bat

280: , NULL class_id
281: , bat.extraction_type extraction_type
282: , evt.operation_type log_operation_type
283: FROM
284: pji_pji_proj_batch_map bat
285: , pa_pji_proj_events_log evt
286: WHERE 1=1
287: AND evt.event_type = 'Classifications'
288: AND evt.event_object = to_char(bat.project_id) /* Added for bug 7517578 */

Line 330: , pji_pji_proj_batch_map bat

326: , bat.extraction_type extraction_type
327: , NULL log_operation_type
328: FROM
329: pa_project_classes prj
330: , pji_pji_proj_batch_map bat
331: , pji_class_codes cls
332: WHERE 1=1
333: AND bat.extraction_type <> 'I'
334: AND bat.project_id = prj.project_id

Line 357: pji_pji_proj_batch_map bat

353: , cls.class_id class_id
354: , bat.extraction_type extraction_type
355: , NULL log_operation_type
356: FROM
357: pji_pji_proj_batch_map bat
358: , pa_project_classes prj
359: , pji_class_codes cls
360: WHERE 1=1
361: AND l_extraction_type = 'INCREMENTAL'

Line 393: , pji_pji_proj_batch_map bat

389: , bat.extraction_type extraction_type
390: , NULL log_operation_type
391: FROM
392: pji_project_classes cls
393: , pji_pji_proj_batch_map bat
394: WHERE 1=1
395: AND l_extraction_type <> 'FULL'
396: AND bat.project_id = cls.project_id
397: AND bat.worker_id = p_worker_id

Line 431: pji_pji_proj_batch_map bat,

427: , NULL log_operation_type
428: FROM
429: pa_project_types_all pt,
430: pa_projects_all prj,
431: pji_pji_proj_batch_map bat,
432: pji_class_codes cls
433: WHERE
434: prj.project_id = bat.project_id
435: AND pt.project_type_class_code IS NOT NULL -- bug 3082170

Line 467: , pji_pji_proj_batch_map bat

463: , bat.extraction_type extraction_type
464: , NULL log_operation_type
465: FROM
466: pji_project_classes cls
467: , pji_pji_proj_batch_map bat
468: WHERE
469: l_extraction_type = 'PARTIAL'
470: AND cls.project_id = bat.project_id
471: AND bat.worker_id = p_worker_id

Line 598: from pji_pji_proj_batch_map

594:
595: delete pa_pji_proj_events_log
596: where event_type = 'Classifications' and
597: event_object in (select to_char(project_id) /* to_char added for bug 7517578 */
598: from pji_pji_proj_batch_map
599: where worker_id = p_worker_id);
600:
601: Pji_Utils.write2log('Deleted ' || SQL%ROWCOUNT || ' record(s) from PA_PJI_PROJ_EVENTS_LOG',TRUE,2);
602: