APPS.IEM_PARAMETERS_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 157: select count(*) into l_count from jtf_rs_resource_extns where resource_number=p_profile_value;

153:
154: if (p_profile_value is null) then
155: l_resource_id := '';
156: else
157: select count(*) into l_count from jtf_rs_resource_extns where resource_number=p_profile_value;
158: if l_count = 0 then
159: raise INVALID_DEFAULT_RESOURCE_NUM;
160: end if;
161:

Line 164: select resource_id into l_resource_id from jtf_rs_resource_extns where resource_number=p_profile_value;

160: end if;
161:
162: -- Convert resource number into resource id
163: -- resource_id and resource_number is a 1 to 1 relationship
164: select resource_id into l_resource_id from jtf_rs_resource_extns where resource_number=p_profile_value;
165:
166: if SQL%ROWCOUNT <> 1 then
167: raise PROFILE_NOT_UPDATED;
168: end if;