APPS.AMS_IBA_PL_SITES_PVT dependencies on AMS_IBA_PL_SITES_VL

Line 64: FROM AMS_IBA_PL_SITES_VL

60: l_site_name_count NUMBER;
61:
62: CURSOR c_site_name(c_site_id IN NUMBER, c_site_name IN VARCHAR2) IS
63: SELECT COUNT(*)
64: FROM AMS_IBA_PL_SITES_VL
65: where site_id = c_site_id
66: and name = c_site_name;
67: BEGIN
68: x_return_status := FND_API.g_ret_sts_success;

Line 948: 'ams_iba_pl_sites_vl'

944: end if;
945:
946: -- Checking if the site name passed is unique
947: l_site_name_flag := ams_utility_pvt.check_uniqueness(
948: 'ams_iba_pl_sites_vl'
949: , 'name = ''' || p_iba_pl_sites_rec.name ||''''
950: );
951: if l_site_name_flag = fnd_api.g_false then
952: ams_uTILITY_pvt.error_Message(p_message_name => 'AMS_PLCE_SITE_NAME_DUP');

Line 959: 'ams_iba_pl_sites_vl'

955: end if;
956:
957: -- Checking if the site ref code passed is unique
958: l_site_ref_code_flag := ams_utility_pvt.check_uniqueness(
959: 'ams_iba_pl_sites_vl'
960: , 'site_ref_code = ''' || p_iba_pl_sites_rec.site_ref_code ||''''
961: );
962: if l_site_ref_code_flag = fnd_api.g_false then
963: ams_utility_pvt.error_Message(p_message_name => 'AMS_PLCE_DUP_SITE_REF');

Line 973: 'ams_iba_pl_sites_vl'

969: --If Validation_mode is update, check uniqueness of site name, site_ref_code
970: if p_validation_mode = JTF_PLSQL_API.g_update then
971: -- Checking if the site name passed is unique
972: l_site_name_flag := ams_utility_pvt.check_uniqueness(
973: 'ams_iba_pl_sites_vl'
974: , 'name = ''' || p_iba_pl_sites_rec.name ||''' and site_id <> ' || p_iba_pl_sites_rec.site_id
975: );
976: IF (AMS_DEBUG_HIGH_ON) THEN
977:

Line 988: 'ams_iba_pl_sites_vl'

984: end if;
985:
986: -- Checking if the site ref code passed is unique
987: l_site_ref_code_flag := ams_utility_pvt.check_uniqueness(
988: 'ams_iba_pl_sites_vl'
989: , 'site_ref_code = ''' || p_iba_pl_sites_rec.site_ref_code ||''' and site_id <> ' || p_iba_pl_sites_rec.site_id
990: );
991: if l_site_ref_code_flag = fnd_api.g_false then
992: ams_utility_pvt.error_Message(p_message_name => 'AMS_PLCE_DUP_SITE_REF');