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_LOCATION_PROFILES

Line 140: HZ_LOCATION_PROFILES_PKG.Insert_Row (

136: IF(l_location_profile_rec.validation_sst_flag = 'N') THEN
137: l_end_date := sysdate;
138: END IF;
139:
140: HZ_LOCATION_PROFILES_PKG.Insert_Row (
141: x_location_profile_id => l_location_profile_rec.location_profile_id
142: ,x_location_id => l_location_profile_rec.location_id
143: ,x_actual_content_source => l_location_profile_rec.actual_content_source
144: ,x_effective_start_date => l_start_date

Line 235: FROM hz_location_profiles

231: -- check if there exist profile record for the location from the same content source
232: -- Fix for bug 5189929 - Added .001 to sysdate while looking for active records
233: CURSOR is_profile_exist(l_location_id NUMBER, l_content_source VARCHAR2) IS
234: SELECT 'X'
235: FROM hz_location_profiles
236: WHERE location_id = l_location_id
237: AND actual_content_source = l_content_source
238: AND sysdate+.001 between effective_start_date and nvl(effective_end_date, sysdate)
239: AND rownum = 1;

Line 251: from hz_location_profiles

247: AND validation_status_code IS NOT NULL;
248:
249: cursor c_all_active_loc_profiles(c_location_id NUMBER, c_location_profile_id NUMBER) is
250: select location_profile_id, rowid, object_version_number
251: from hz_location_profiles
252: where sysdate between effective_start_date and nvl(effective_end_date, sysdate)
253: and location_id = c_location_id
254: and location_profile_id <> c_location_profile_id;
255:

Line 313: FROM hz_location_profiles

309:
310: -- Fix for bug 5189929 - Added .001 to sysdate while looking for active records
311: SELECT rowid, object_version_number, validation_sst_flag
312: INTO l_rowid, l_object_version_number, l_orig_sst_flag
313: FROM hz_location_profiles
314: WHERE location_id = l_location_profile_rec.location_id
315: AND actual_content_source = l_location_profile_rec.actual_content_source
316: AND sysdate+.001 between effective_start_date and nvl(effective_end_date,sysdate)
317: AND rownum = 1

Line 329: HZ_LOCATION_PROFILES_PKG.Update_Row(

325: ELSIF(x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
327: END IF;
328:
329: HZ_LOCATION_PROFILES_PKG.Update_Row(
330: x_rowid => l_rowid
331: ,x_location_profile_id => NULL
332: ,x_location_id => NULL
333: ,x_actual_content_source => NULL

Line 367: FROM hz_location_profiles

363: -- if N: update existing location profiles
364: -- Fix for bug 5189929 - Added .001 to sysdate while looking for active records
365: SELECT rowid, object_version_number, validation_sst_flag
366: INTO l_rowid, l_object_version_number, l_orig_sst_flag
367: FROM hz_location_profiles
368: WHERE location_id = l_location_profile_rec.location_id
369: AND actual_content_source = l_location_profile_rec.actual_content_source
370: AND sysdate+.001 between effective_start_date and nvl(effective_end_date,sysdate)
371: AND rownum = 1

Line 380: HZ_LOCATION_PROFILES_PKG.Update_Row(

376: -- otherwise, don't update existing profile record and then just
377: -- insert new location profile record. In this case, validation_sst_flag
378: -- is always 'N'.
379: IF(l_validation_sst_flag = 'Y') OR (l_orig_sst_flag = 'N') THEN
380: HZ_LOCATION_PROFILES_PKG.Update_Row(
381: x_rowid => l_rowid
382: ,x_location_profile_id => NULL
383: ,x_location_id => NULL
384: ,x_actual_content_source => NULL

Line 410: HZ_LOCATION_PROFILES_PKG.Insert_Row (

406: -- when passing NULL, it means that caller does not want to update the
407: -- value
408: set_profile_rec_type(l_location_profile_rec);
409:
410: HZ_LOCATION_PROFILES_PKG.Insert_Row (
411: x_location_profile_id => l_location_profile_rec.location_profile_id
412: ,x_location_id => l_location_profile_rec.location_id
413: ,x_actual_content_source => l_location_profile_rec.actual_content_source
414: ,x_effective_start_date => sysdate

Line 456: HZ_LOCATION_PROFILES_PKG.Insert_Row (

452: l_startdate := sysdate;
453: l_enddate := l_end_date;
454: end if;
455:
456: HZ_LOCATION_PROFILES_PKG.Insert_Row (
457: x_location_profile_id => l_location_profile_rec.location_profile_id
458: ,x_location_id => l_location_profile_rec.location_id
459: ,x_actual_content_source => l_location_profile_rec.actual_content_source
460: ,x_effective_start_date => l_startdate

Line 496: UPDATE HZ_LOCATION_PROFILES

492: validation_status_code = l_location_profile_rec.validation_status_code
493: WHERE location_id = l_location_profile_rec.location_id;
494:
495: BEGIN
496: UPDATE HZ_LOCATION_PROFILES
497: SET validation_sst_flag = 'N'
498: WHERE validation_sst_flag = 'Y'
499: AND sysdate between effective_start_date and nvl(effective_end_date, sysdate)
500: /* SSM SST Integration and Extension

Line 527: HZ_LOCATION_PROFILES_PKG.Update_Row(

523: END IF;
524:
525: IF (l_enddate_other_active = 'Y') then
526: for l_all_active_loc_profiles in c_all_active_loc_profiles(l_location_profile_rec.location_id,l_location_profile_rec.location_profile_id) loop
527: HZ_LOCATION_PROFILES_PKG.Update_Row(
528: x_rowid => l_all_active_loc_profiles.rowid
529: ,x_location_profile_id => l_all_active_loc_profiles.location_profile_id
530: ,x_location_id => NULL
531: ,x_actual_content_source => NULL

Line 685: FROM HZ_LOCATION_PROFILES

681: l_dummy VARCHAR2(1);
682:
683: CURSOR is_profile_exist(l_location_profile_id NUMBER) IS
684: SELECT 'X'
685: FROM HZ_LOCATION_PROFILES
686: WHERE location_profile_id = l_location_profile_id;
687:
688: BEGIN
689:

Line 698: UPDATE hz_location_profiles

694: CLOSE is_profile_exist;
695:
696: IF(l_dummy IS NOT NULL) THEN
697: BEGIN
698: UPDATE hz_location_profiles
699: SET effective_end_date = sysdate
700: WHERE location_profile_id = p_location_profile_id;
701: EXCEPTION
702: WHEN OTHERS THEN

Line 734: -- and HZ_LOCATION_PROFILES.validation_status_code

730: END set_effective_end_date;
731:
732: --
733: -- This procedure will update both HZ_LOCATIONS.validation_status_code
734: -- and HZ_LOCATION_PROFILES.validation_status_code
735: -- This procedure should not be invoked along. It should be called
736: -- after creating or updating location. It is required for those
737: -- content source which is NOT USER_ENTERED.
738: -- The reason is that when creating/updating location, there is no

Line 759: FROM HZ_LOCATION_PROFILES

755: l_dummy VARCHAR2(1);
756:
757: CURSOR is_profile_exist(l_location_profile_id NUMBER) IS
758: SELECT 'X'
759: FROM HZ_LOCATION_PROFILES
760: WHERE location_profile_id = l_location_profile_id;
761:
762: BEGIN
763:

Line 772: UPDATE hz_location_profiles

768: CLOSE is_profile_exist;
769:
770: IF(l_dummy IS NOT NULL) THEN
771: BEGIN
772: UPDATE hz_location_profiles
773: SET validation_status_code = p_validation_status_code
774: WHERE location_profile_id = p_location_profile_id;
775:
776: UPDATE hz_locations

Line 780: FROM HZ_LOCATION_PROFILES

776: UPDATE hz_locations
777: SET validation_status_code = p_validation_status_code
778: WHERE location_id =
779: ( SELECT location_id
780: FROM HZ_LOCATION_PROFILES
781: WHERE location_profile_id = p_location_profile_id);
782: EXCEPTION
783: WHEN OTHERS THEN
784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;