[Home] [Help]
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
100: ppevs.ELEMENT_VERSION_ID = p_wbs_version_id_tbl(l_i) AND
101: ppa.template_flag <> 'Y'
3426:
3427: SELECT
3428: NVL(TO_NUMBER(DECODE(SUBSTR(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTR(USERENV('CLIENT_INFO'),1,10))),-99)
3429: INTO l_env_org
3430: FROM dual;
3431:
3432: SELECT org_id
3433: INTO l_project_org
3434: FROM pa_projects_all
5152: -- Reset flag values.
5153: l_exists := 'N';
5154: BEGIN
5155: SELECT 'Y'
5156: INTO l_exists FROM dual
5157: WHERE EXISTS ( SELECT 1
5158: FROM pji_rollup_level_status rst
5159: WHERE rst.rbs_version_id = p_rbs_version_id
5160: AND rst.plan_version_id = l_plan_version_id_tbl(i)