APPS.HZ_LOCATION_PROFILE_PVT dependencies on HZ_LOCATION_PROFILES_PKG

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 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 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 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