DBA Data[Home] [Help]

APPS.OZF_PROMOTIONAL_OFFERS_PVT dependencies on AMS_ACCESS_PVT

Line 102: l_access_rec AMS_access_PVT.access_rec_type;

98: l_status_code VARCHAR2(30);
99: l_status_id NUMBER;
100:
101: l_offers_Rec offers_rec_type := p_offers_rec;
102: l_access_rec AMS_access_PVT.access_rec_type;
103: l_access_id NUMBER;
104:
105: CURSOR c_get_start_end_date(l_list_header_id NUMBER) IS
106: SELECT start_date_active, end_date_active

Line 317: AMS_access_PVT.create_access(

313: l_access_rec.admin_flag := 'Y';
314: l_access_rec.owner_flag := 'Y';
315:
316: -- create access for the owner of the offer
317: AMS_access_PVT.create_access(
318: p_api_version => l_api_version_number,
319: p_init_msg_list => FND_API.g_false,
320: p_commit => FND_API.g_false,
321: p_validation_level => FND_API.g_valid_level_full,

Line 334: AMS_access_PVT.create_access(

330: l_access_rec.user_or_role_id := FND_PROFILE.value('OZF_DEFAULT_OFFER_TEAM');
331: IF l_access_rec.user_or_role_id IS NOT NULL THEN
332: l_access_rec.owner_flag := 'N';
333: l_access_rec.arc_user_or_role_type := 'GROUP';
334: AMS_access_PVT.create_access(
335: p_api_version => l_api_version_number,
336: p_init_msg_list => FND_API.g_false,
337: p_commit => FND_API.g_false,
338: p_validation_level => FND_API.g_valid_level_full,

Line 816: l_is_owner := AMS_access_PVT.check_owner(p_object_id => l_offers_rec.qp_list_header_id

812: x_complete_rec => l_offers_rec
813: );
814:
815: IF l_offers_rec.owner_id <> l_old_owner_id THEN
816: l_is_owner := AMS_access_PVT.check_owner(p_object_id => l_offers_rec.qp_list_header_id
817: ,p_object_type => 'OFFR'
818: ,p_user_or_role_id => ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id)
819: ,p_user_or_role_type => 'USER');
820: -- check if login user is super user

Line 821: l_is_admin := AMS_Access_PVT.Check_Admin_Access(ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id));

817: ,p_object_type => 'OFFR'
818: ,p_user_or_role_id => ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id)
819: ,p_user_or_role_type => 'USER');
820: -- check if login user is super user
821: l_is_admin := AMS_Access_PVT.Check_Admin_Access(ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id));
822:
823: IF l_is_owner = 'Y' OR l_is_admin THEN -- curent user is owner/admin, changing owner is allowed
824: AMS_access_PVT.update_object_owner(
825: p_api_version => l_api_version_number,

Line 824: AMS_access_PVT.update_object_owner(

820: -- check if login user is super user
821: l_is_admin := AMS_Access_PVT.Check_Admin_Access(ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id));
822:
823: IF l_is_owner = 'Y' OR l_is_admin THEN -- curent user is owner/admin, changing owner is allowed
824: AMS_access_PVT.update_object_owner(
825: p_api_version => l_api_version_number,
826: p_init_msg_list => FND_API.g_false,
827: p_commit => FND_API.g_false,
828: p_validation_level => FND_API.g_valid_level_full,