APPS.PJI_PJI_EXTRACTION_UTILS dependencies on PA_PJI_PROJ_EVENTS_LOG

Line 707: --the MAX(EVENT_ID) on the log table PA_PJI_PROJ_EVENTS_LOG

703: pji_utils.write2log(sql%rowcount || ' rows inserted.');
704:
705: --Only those work type changes which occured upto launch of summarization
706: --process will be handled in a given run. This is done by tracking
707: --the MAX(EVENT_ID) on the log table PA_PJI_PROJ_EVENTS_LOG
708: begin
709:
710: select max(event_id)
711: into l_event_id

Line 713: pa_pji_proj_events_log log

709:
710: select max(event_id)
711: into l_event_id
712: from
713: pa_pji_proj_events_log log
714: where
715: log.EVENT_TYPE = 'Work Types' and
716: log.OPERATION_TYPE = 'U';
717:

Line 730: pa_pji_proj_events_log log

726: --Only the first change is retained for a given worktype
727: --All subsequent changes are deleted below.
728: delete
729: from
730: pa_pji_proj_events_log log
731: where
732: log.EVENT_TYPE = 'Work Types' and
733: log.OPERATION_TYPE = 'U' and
734: log.EVENT_ID <= l_event_id and

Line 736: from pa_pji_proj_events_log log1

732: log.EVENT_TYPE = 'Work Types' and
733: log.OPERATION_TYPE = 'U' and
734: log.EVENT_ID <= l_event_id and
735: log.EVENT_ID > ( select min(log1.event_id)
736: from pa_pji_proj_events_log log1
737: where log1.event_object = log.EVENT_OBJECT
738: and log1.operation_type = 'U'
739: group by log1.event_object );
740:

Line 743: --populate CHANGE_OLD slice from PA_PJI_PROJ_EVENTS_LOG table

739: group by log1.event_object );
740:
741: pji_utils.write2log(sql%rowcount || ' rows deleted :2.');
742:
743: --populate CHANGE_OLD slice from PA_PJI_PROJ_EVENTS_LOG table
744: insert into PJI_RM_WORK_TYPE_INFO
745: (
746: WORK_TYPE_ID,
747: BILLABLE_CAPITALIZABLE_FLAG,

Line 770: from pa_pji_proj_events_log

766: sysdate,
767: -1,
768: sysdate,
769: -1
770: from pa_pji_proj_events_log
771: where
772: EVENT_ID <= l_event_id and
773: EVENT_TYPE = 'Work Types' and
774: OPERATION_TYPE = 'U';

Line 781: pa_pji_proj_events_log log

777:
778: --Cleanup log table for processed Worktype changes
779: delete
780: from
781: pa_pji_proj_events_log log
782: where
783: log.EVENT_ID <= l_event_id and
784: log.EVENT_TYPE = 'Work Types' and
785: log.OPERATION_TYPE = 'U';