DBA Data[Home] [Help]

APPS.EAM_COMMON_UTILITIES_PVT dependencies on EAM_LINEAR_LOCATIONS

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

2769:
2770:
2771: /* Bug # 3698307
2772: validate_linear_id is added for Linear Asset Management project
2773: Basically it verify's whether the passed linear_id exists in EAM_LINEAR_LOCATIONS
2774: table or not.
2775: */
2776:
2777: FUNCTION validate_linear_id(p_eam_linear_id IN NUMBER)

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

2778: RETURN BOOLEAN IS
2779: l_count NUMBER;
2780: BEGIN
2781:
2782: SELECT count(*) INTO l_count FROM eam_linear_locations
2783: WHERE eam_linear_id = p_eam_linear_id;
2784:
2785: IF (l_count > 0) THEN
2786: RETURN true;