APPS.EAM_ISOLATION_UTILITY_PVT dependencies on EAM_ISOLATIONS

Line 122: FROM EAM_ISOLATIONS iso

118: l_isolation_header_rec.ATTRIBUTE29 ,
119: l_isolation_header_rec.ATTRIBUTE30 ,
120: l_isolation_header_rec.CREATION_DATE ,
121: l_isolation_header_rec.CREATED_BY
122: FROM EAM_ISOLATIONS iso
123: WHERE iso.isolation_id = p_isolation_id
124: AND iso.organization_id = p_organization_id;
125: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_FOUND;
126: x_isolation_header_rec := l_isolation_header_rec;

Line 149: INTO EAM_ISOLATIONS

145: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
146: EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing Isolation record for ' || p_isolation_header_rec.ISOLATION_NAME);
147: END IF;
148: INSERT
149: INTO EAM_ISOLATIONS
150: (
151: ISOLATION_ID ,
152: ISOLATION_NAME ,
153: ISOLATION_TYPE ,

Line 271: UPDATE EAM_ISOLATIONS

267: IS
268: BEGIN
269: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Updating Isolation rec for ' || p_isolation_header_rec.ISOLATION_NAME);END IF;
270:
271: UPDATE EAM_ISOLATIONS
272: SET DESCRIPTION =p_isolation_header_rec.DESCRIPTION ,
273: EFFECTIVE_START_DATE =p_isolation_header_rec.EFFECTIVE_START_DATE ,
274: EFFECTIVE_END_DATE =p_isolation_header_rec.EFFECTIVE_END_DATE ,
275: PENDING_FLAG =p_isolation_header_rec.PENDING_FLAG ,

Line 393: UPDATE EAM_ISOLATIONS

389: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
390: EAM_ERROR_MESSAGE_PVT.Write_Debug('Update status in isolation table');
391: END IF;
392: BEGIN
393: UPDATE EAM_ISOLATIONS
394: SET STATUS_TYPE = l_to_status_type
395: WHERE ORGANIZATION_ID = l_organization_id
396: AND isolation_id = l_isolation_id;
397: EXCEPTION