eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_LOCATION_PROFILE_PVT dependencies on HZ_UTILITY_V2PUB

Line 170: HZ_UTILITY_V2PUB.is_purchased_content_source(l_location_profile_rec.actual_content_source) = 'Y' )

166: -- Changed the hard coded value of DNB and instead will check if the content source is of type 'PURCHASED'.
167:
168: --IF(NOT(l_location_profile_rec.actual_content_source in ('USER_ENTERED','DNB'))) THEN
169: IF(NOT(l_location_profile_rec.actual_content_source = 'USER_ENTERED' OR
170: HZ_UTILITY_V2PUB.is_purchased_content_source(l_location_profile_rec.actual_content_source) = 'Y' )
171: ) THEN
172: UPDATE HZ_LOCATIONS
173: SET date_validated = sysdate
174: , validation_status_code = l_location_profile_rec.validation_status_code

Line 175: , last_update_date = hz_utility_v2pub.last_update_date

171: ) THEN
172: UPDATE HZ_LOCATIONS
173: SET date_validated = sysdate
174: , validation_status_code = l_location_profile_rec.validation_status_code
175: , last_update_date = hz_utility_v2pub.last_update_date
176: , last_updated_by = hz_utility_v2pub.last_updated_by
177: , last_update_login = hz_utility_v2pub.last_update_login
178: WHERE location_id = l_location_profile_rec.location_id;
179: END IF;

Line 176: , last_updated_by = hz_utility_v2pub.last_updated_by

172: UPDATE HZ_LOCATIONS
173: SET date_validated = sysdate
174: , validation_status_code = l_location_profile_rec.validation_status_code
175: , last_update_date = hz_utility_v2pub.last_update_date
176: , last_updated_by = hz_utility_v2pub.last_updated_by
177: , last_update_login = hz_utility_v2pub.last_update_login
178: WHERE location_id = l_location_profile_rec.location_id;
179: END IF;
180:

Line 177: , last_update_login = hz_utility_v2pub.last_update_login

173: SET date_validated = sysdate
174: , validation_status_code = l_location_profile_rec.validation_status_code
175: , last_update_date = hz_utility_v2pub.last_update_date
176: , last_updated_by = hz_utility_v2pub.last_updated_by
177: , last_update_login = hz_utility_v2pub.last_update_login
178: WHERE location_id = l_location_profile_rec.location_id;
179: END IF;
180:
181: EXCEPTION

Line 486: HZ_UTILITY_V2PUB.is_purchased_content_source(l_location_profile_rec.actual_content_source)= 'Y' )

482: -- Instead of hard-coding, check if source system is of type PURCHASED.
483:
484: --IF(NOT(l_location_profile_rec.actual_content_source in ('USER_ENTERED','DNB'))) THEN
485: IF (NOT(l_location_profile_rec.actual_content_source = 'USER_ENTERED' OR
486: HZ_UTILITY_V2PUB.is_purchased_content_source(l_location_profile_rec.actual_content_source)= 'Y' )
487: )THEN
488: -- if update standardized is ok, then update HZ_LOCATIONS, otherwise do nothing
489: IF(l_validation_sst_flag = 'Y') THEN
490: UPDATE HZ_LOCATIONS

Line 508: AND HZ_UTILITY_V2PUB.is_purchased_content_source(actual_content_source) = 'N'

504: AND actual_content_source <> l_location_profile_rec.actual_content_source
505: AND actual_content_source not in ('USER_ENTERED','DNB');*/
506:
507: AND actual_content_source NOT IN ( l_location_profile_rec.actual_content_source, 'USER_ENTERED')
508: AND HZ_UTILITY_V2PUB.is_purchased_content_source(actual_content_source) = 'N'
509: AND location_id = l_location_profile_rec.location_id;
510:
511: EXCEPTION
512: WHEN NO_DATA_FOUND THEN