APPS.EAM_CLEARANCE_VALIDATE_PVT dependencies on EAM_WORK_CLEARANCES

Line 143: FROM EAM_WORK_CLEARANCES

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

Line 175: FROM EAM_WORK_CLEARANCES

171: BEGIN
172: IF (p_work_clearance_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE) THEN
173: SELECT COUNT(*)
174: INTO l_count
175: FROM EAM_WORK_CLEARANCES
176: WHERE WORK_CLEARANCE_ID = p_work_clearance_header_rec.WORK_CLEARANCE_ID
177: AND organization_id = p_work_clearance_header_rec.organization_id;
178:
179: IF(l_count <> 1) THEN

Line 209: FROM EAM_WORK_CLEARANCES

205: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Clearance Name in create. . . '); END IF;
206:
207: SELECT COUNT(*)
208: INTO l_count
209: FROM EAM_WORK_CLEARANCES
210: WHERE work_clearance_name = p_work_clearance_header_rec.work_clearance_name
211: AND organization_id = p_work_clearance_header_rec.organization_id;
212: IF(l_count > 0) THEN
213: raise fnd_api.g_exc_unexpected_error;

Line 226: FROM EAM_WORK_CLEARANCES

222: IF EAM_PROCESS_WO_PVT.GET_DEBUG = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Clearance Name in Update '); END IF;
223:
224: SELECT WORK_CLEARANCE_ID
225: INTO l_work_clearance_id
226: FROM EAM_WORK_CLEARANCES
227: WHERE work_clearance_name = p_work_clearance_header_rec.work_clearance_name
228: AND organization_id = p_work_clearance_header_rec.organization_id;
229: EXCEPTION
230: WHEN others THEN