APPS.IEM_PARAMETERS_PVT dependencies on HZ_PARTIES

Line 128: select count(*) into l_count from hz_parties where party_number=p_profile_value;

124:
125: -- Validate Default Customer number if the profile name is IEM_DEFAULT_CUSTOMER_NUMBER
126: if UPPER(p_profile_name) = 'IEM_DEFAULT_CUSTOMER_NUMBER' then
127:
128: select count(*) into l_count from hz_parties where party_number=p_profile_value;
129: if l_count = 0 then
130: raise INVALID_DEFAULT_CUSTOMER_NUM;
131: end if;
132:

Line 135: select party_id into l_party_id from hz_parties where party_number=p_profile_value;

131: end if;
132:
133: -- Convert customer number into customer id
134: -- party_id and party_number is a 1 to 1 relationship
135: select party_id into l_party_id from hz_parties where party_number=p_profile_value;
136:
137: if SQL%ROWCOUNT <> 1 then
138: raise PROFILE_NOT_UPDATED;
139: end if;

Line 141: /* select party_type into l_party_type from hz_parties where party_number=p_profile_value;

137: if SQL%ROWCOUNT <> 1 then
138: raise PROFILE_NOT_UPDATED;
139: end if;
140:
141: /* select party_type into l_party_type from hz_parties where party_number=p_profile_value;
142: if l_party_type <> 'PERSON' and l_party_type <> 'PARTY_RELATIONSHIP' then
143: raise INVALID_DEFAULT_CUSTOMER_NUM;
144: end if;
145: */