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 STANDARD

Line 242: CURSOR is_standardized(l_location_id NUMBER) IS

238: AND sysdate+.001 between effective_start_date and nvl(effective_end_date, sysdate)
239: AND rownum = 1;
240:
241: -- check if the current location record has been validated
242: CURSOR is_standardized(l_location_id NUMBER) IS
243: SELECT 'X'
244: FROM hz_locations
245: WHERE location_id = l_location_id
246: AND date_validated IS NOT NULL

Line 279: OPEN is_standardized(l_location_profile_rec.location_id);

275:
276: l_end_date := NVL(p_location_profile_rec.effective_end_date,to_date('4712.12.31 00:01','YYYY.MM.DD HH24:MI'));
277: l_enddate_other_active := 'N';
278:
279: OPEN is_standardized(l_location_profile_rec.location_id);
280: FETCH is_standardized INTO l_dummy;
281: CLOSE is_standardized;
282:
283: -- location has been validated before and profile is set to 'N'

Line 280: FETCH is_standardized INTO l_dummy;

276: l_end_date := NVL(p_location_profile_rec.effective_end_date,to_date('4712.12.31 00:01','YYYY.MM.DD HH24:MI'));
277: l_enddate_other_active := 'N';
278:
279: OPEN is_standardized(l_location_profile_rec.location_id);
280: FETCH is_standardized INTO l_dummy;
281: CLOSE is_standardized;
282:
283: -- location has been validated before and profile is set to 'N'
284: -- only if validation_sst_flag is not passed

Line 281: CLOSE is_standardized;

277: l_enddate_other_active := 'N';
278:
279: OPEN is_standardized(l_location_profile_rec.location_id);
280: FETCH is_standardized INTO l_dummy;
281: CLOSE is_standardized;
282:
283: -- location has been validated before and profile is set to 'N'
284: -- only if validation_sst_flag is not passed
285: IF(l_location_profile_rec.validation_sst_flag IS NULL) THEN

Line 488: -- if update standardized is ok, then update HZ_LOCATIONS, otherwise do nothing

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
491: SET date_validated = sysdate,
492: validation_status_code = l_location_profile_rec.validation_status_code