DBA Data[Home] [Help]

APPS.EAM_ISOLATION_VALIDATE_PVT dependencies on EAM_ISOLATIONS

Line 144: FROM EAM_ISOLATIONS

140: BEGIN
141: IF (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) THEN
142: SELECT COUNT(*)
143: INTO l_count
144: FROM EAM_ISOLATIONS
145: WHERE ISOLATION_ID = p_iso_header_rec.ISOLATION_ID
146: AND organization_id = p_iso_header_rec.organization_id;
147: IF(l_count > 0) THEN
148: raise fnd_api.g_exc_unexpected_error;

Line 173: FROM EAM_ISOLATIONS

169: BEGIN
170: IF (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE) THEN
171: SELECT COUNT(*)
172: INTO l_count
173: FROM EAM_ISOLATIONS
174: WHERE ISOLATION_ID = p_iso_header_rec.ISOLATION_ID
175: AND organization_id = p_iso_header_rec.organization_id;
176:
177: IF(l_count <> 1) THEN

Line 203: FROM EAM_ISOLATIONS

199: BEGIN
200: IF (p_iso_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE) THEN
201: SELECT COUNT(*)
202: INTO l_count
203: FROM EAM_ISOLATIONS
204: WHERE ISOLATION_NAME = p_iso_header_rec.ISOLATION_NAME
205: AND organization_id = p_iso_header_rec.organization_id;
206: IF(l_count > 0) THEN
207: raise fnd_api.g_exc_unexpected_error;