APPS.EAM_ASSET_AREAS_PUB dependencies on MTL_EAM_LOCATIONS

Line 65: FROM MTL_EAM_LOCATIONS

61: is
62: l_count number;
63: BEGIN
64: SELECT count(*) INTO l_count
65: FROM MTL_EAM_LOCATIONS
66: WHERE location_codes = p_location_codes
67: and creation_organization_id = p_organization_id;
68:
69: if l_count > 0

Line 128: FROM MTL_EAM_LOCATIONS

124: is
125: l_count number;
126: BEGIN
127: SELECT COUNT(*) INTO l_count
128: FROM MTL_EAM_LOCATIONS
129: WHERE LOCATION_CODES = P_LOCATION_CODES AND
130: CREATION_ORGANIZATION_ID = P_CREATION_ORGANIZATION_ID;
131:
132: if l_count = 0

Line 240: INSERT INTO MTL_EAM_LOCATIONS

236: end if;
237:
238: VALIDATE_ROW_EXISTS(P_LOCATION_CODES, P_CREATION_ORGANIZATION_ID , TRUE);
239:
240: INSERT INTO MTL_EAM_LOCATIONS
241: (
242: LOCATION_ID,
243: LOCATION_CODES,
244: START_DATE ,

Line 399: FROM MTL_EAM_LOCATIONS

395: -- Bug # 3518888 : To check if location id exist for given org.
396: --VALIDATE_ROW_EXISTS(P_LOCATION_CODES, P_CREATION_ORGANIZATION_ID , FALSE);
397:
398: SELECT COUNT(*) INTO l_count
399: FROM MTL_EAM_LOCATIONS
400: WHERE CREATION_ORGANIZATION_ID = P_CREATION_ORGANIZATION_ID
401: AND LOCATION_ID = P_LOCATION_ID;
402:
403: IF(l_count = 0) THEN

Line 409: FROM MTL_EAM_LOCATIONS

405: END IF;
406:
407: -- To check if new location_code does not exist for other record.
408: SELECT COUNT(*) INTO l_count
409: FROM MTL_EAM_LOCATIONS
410: WHERE CREATION_ORGANIZATION_ID = P_CREATION_ORGANIZATION_ID
411: AND LOCATION_ID <> P_LOCATION_ID
412: AND LOCATION_CODES = P_LOCATION_CODES;
413:

Line 418: UPDATE MTL_EAM_LOCATIONS

414: IF(l_count > 0) THEN
415: RAISE_ERROR('EAM_AA_DUP_LOCATION_CODE');
416: END IF;
417:
418: UPDATE MTL_EAM_LOCATIONS
419: SET
420: LOCATION_CODES = P_LOCATION_CODES ,
421: START_DATE = P_START_DATE ,
422: END_DATE = P_END_DATE ,