APPS.HZ_DSS_VALIDATE_PKG dependencies on HZ_DSS_GROUPS_VL

Line 134: -- Return Y if the group name exists in hz_dss_groups_vl

130: -- exist_in_dss_groups_vl
131: --------------------------------------------
132:
133: FUNCTION exist_in_dss_groups_vl
134: -- Return Y if the group name exists in hz_dss_groups_vl
135: -- N otherwise
136: (p_dss_group_name VARCHAR2 )
137: RETURN VARCHAR2
138: IS

Line 142: FROM hz_dss_groups_vl

138: IS
139: CURSOR c0
140: IS
141: SELECT 'Y'
142: FROM hz_dss_groups_vl
143: WHERE dss_group_name = p_dss_group_name;
144: l_yn VARCHAR2(1);
145: result VARCHAR2(1);
146: BEGIN

Line 160: -- Return Y if the object name exists in hz_dss_groups_vl, for a row whose

156: END exist_in_dss_groups_vl ;
157:
158:
159: FUNCTION exist_in_dss_groups_vl
160: -- Return Y if the object name exists in hz_dss_groups_vl, for a row whose
161: -- primary key <> passed in primary key value
162: -- N otherwise
163: (p_dss_group_name VARCHAR2, p_dss_group_code VARCHAR2 )
164: RETURN VARCHAR2

Line 169: FROM hz_dss_groups_vl

165: IS
166: CURSOR c0
167: IS
168: SELECT 'Y'
169: FROM hz_dss_groups_vl
170: WHERE dss_group_name = p_dss_group_name
171: and dss_group_code <> p_dss_group_code ;
172: l_yn VARCHAR2(1);
173: result VARCHAR2(1);