DBA Data[Home] [Help]

APPS.PJI_REP_UTIL dependencies on PA_PJI_PROJ_EVENTS_LOG_S

Line 95: SELECT 'STRUCT_CHANGE',pa_pji_proj_events_log_s.NEXTVAL,'-99','X','X',SYSDATE,

91: FORALL l_i IN p_wbs_version_id_tbl.FIRST..p_wbs_version_id_tbl.LAST
92: INSERT INTO pa_pji_proj_events_log
93: (event_type,event_id, event_object, operation_type, status, last_update_date
94: , last_updated_by, creation_date, created_by, last_update_login, attribute1, attribute2)
95: SELECT 'STRUCT_CHANGE',pa_pji_proj_events_log_s.NEXTVAL,'-99','X','X',SYSDATE,
96: Fnd_Global.USER_ID,SYSDATE,Fnd_Global.USER_ID,Fnd_Global.LOGIN_ID,p_wbs_version_id_tbl(l_i),'N'
97: FROM dual WHERE exists (
98: SELECT ppa.project_id from PA_PROJECTS_ALL ppa, PA_PROJ_ELEM_VER_STRUCTURE ppevs WHERE
99: ppa.project_id = ppevs.project_id AND

Line 110: 'STRUCT_CHANGE',pa_pji_proj_events_log_s.NEXTVAL,'-99','X','X',SYSDATE,

106: INSERT INTO pa_pji_proj_events_log
107: (event_type,event_id, event_object, operation_type, status, last_update_date
108: , last_updated_by, creation_date, created_by, last_update_login, attribute1, attribute2)
109: SELECT
110: 'STRUCT_CHANGE',pa_pji_proj_events_log_s.NEXTVAL,'-99','X','X',SYSDATE,
111: Fnd_Global.USER_ID,SYSDATE,Fnd_Global.USER_ID,Fnd_Global.LOGIN_ID,sup_id,'Y'
112: FROM
113: (
114: select /*+ ordered