APPS.EAM_COMMON_UTILITIES_PVT dependencies on MTL_EAM_LOCATIONS

Line 1162: -- Validates eam location id in mtl_eam_locations table.

1158: return false;
1159: end if;
1160: end;
1161:
1162: -- Validates eam location id in mtl_eam_locations table.
1163: FUNCTION validate_eam_location_id
1164: (
1165: p_location_id in number
1166: ) return boolean

Line 1171: from mtl_eam_locations

1167: is
1168: l_count number;
1169: begin
1170: select count(*) into l_count
1171: from mtl_eam_locations
1172: where location_id=p_location_id;
1173:
1174: if (l_count>0) then
1175: return true;

Line 1195: from mtl_eam_locations

1191: is
1192: l_count number;
1193: begin
1194: select count(*) into l_count
1195: from mtl_eam_locations
1196: where organization_id=p_organization_id
1197: and location_id=p_location_id
1198: and (END_DATE >= SYSDATE OR END_DATE IS NULL);
1199:

Line 3747: mtl_eam_locations el

3743: IS
3744: CURSOR get_area IS
3745: SELECT el.location_codes
3746: FROM eam_org_maint_defaults eomd,
3747: mtl_eam_locations el
3748: WHERE eomd.area_id = el.location_id
3749: AND eomd.object_type = 50
3750: AND eomd.object_id = p_instance_id
3751: AND eomd.organization_id = p_maint_org_id;

Line 3753: l_area_code MTL_EAM_LOCATIONS.LOCATION_CODES%TYPE;

3749: AND eomd.object_type = 50
3750: AND eomd.object_id = p_instance_id
3751: AND eomd.organization_id = p_maint_org_id;
3752:
3753: l_area_code MTL_EAM_LOCATIONS.LOCATION_CODES%TYPE;
3754: BEGIN
3755: OPEN get_area;
3756: FETCH get_area INTO l_area_code;
3757: CLOSE get_area;