DBA Data[Home] [Help]

APPS.EAM_COMMON_UTILITIES_PVT dependencies on EAM_LINEAR_LOCATIONS

Line 2892: Basically it verify's whether the passed linear_id exists in EAM_LINEAR_LOCATIONS

2888: END get_available_quant;
2889:
2890: /* Bug # 3698307
2891: validate_linear_id is added for Linear Asset Management project
2892: Basically it verify's whether the passed linear_id exists in EAM_LINEAR_LOCATIONS
2893: table or not.
2894: */
2895:
2896: FUNCTION validate_linear_id(p_eam_linear_id IN NUMBER)

Line 2901: SELECT count(*) INTO l_count FROM eam_linear_locations

2897: RETURN BOOLEAN IS
2898: l_count NUMBER;
2899: BEGIN
2900:
2901: SELECT count(*) INTO l_count FROM eam_linear_locations
2902: WHERE eam_linear_id = p_eam_linear_id;
2903:
2904: IF (l_count > 0) THEN
2905: RETURN true;