7: -- Purpose
8: --
9: -- History
10: -- MAY-17-2002 julou modified. See bug 2380113
11: -- 1. changed G_USER_ID to FND_GLOBAL.user_id
12: -- 2. changed G_LOGIN_ID to FND_GLOBAL.conc_login_id
13: -- 3. removed created_by and creation_date from update api
14: -- 17-Oct-2002 RSSHARMA added last_recal_date and buyer_name
15: -- last_recal_date is inserted as sysdate (when created)
8: --
9: -- History
10: -- MAY-17-2002 julou modified. See bug 2380113
11: -- 1. changed G_USER_ID to FND_GLOBAL.user_id
12: -- 2. changed G_LOGIN_ID to FND_GLOBAL.conc_login_id
13: -- 3. removed created_by and creation_date from update api
14: -- 17-Oct-2002 RSSHARMA added last_recal_date and buyer_name
15: -- last_recal_date is inserted as sysdate (when created)
16: -- 18-Oct-2002 RSSHARMA Fixed issue where the complete rec was called
201: -- =========================================================================
202: -- Validate Environment
203: -- =========================================================================
204:
205: IF FND_GLOBAL.User_Id IS NULL
206: THEN
207: OZF_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
208: RAISE FND_API.G_EXC_ERROR;
209: END IF;
244: p_wf_item_key => l_offers_rec.wf_item_key,
245: p_customer_reference => l_offers_rec.customer_reference,
246: p_buying_group_contact_id => l_offers_rec.buying_group_contact_id,
247: p_last_update_date => SYSDATE,
248: p_last_updated_by => FND_GLOBAL.user_id,
249: p_creation_date => SYSDATE,
250: p_created_by => FND_GLOBAL.user_id,
251: p_last_update_login => FND_GLOBAL.conc_login_id,
252: px_object_version_number => l_object_version_number,
246: p_buying_group_contact_id => l_offers_rec.buying_group_contact_id,
247: p_last_update_date => SYSDATE,
248: p_last_updated_by => FND_GLOBAL.user_id,
249: p_creation_date => SYSDATE,
250: p_created_by => FND_GLOBAL.user_id,
251: p_last_update_login => FND_GLOBAL.conc_login_id,
252: px_object_version_number => l_object_version_number,
253: p_perf_date_from => l_offers_rec.perf_date_from,
254: p_perf_date_to => l_offers_rec.perf_date_to,
247: p_last_update_date => SYSDATE,
248: p_last_updated_by => FND_GLOBAL.user_id,
249: p_creation_date => SYSDATE,
250: p_created_by => FND_GLOBAL.user_id,
251: p_last_update_login => FND_GLOBAL.conc_login_id,
252: px_object_version_number => l_object_version_number,
253: p_perf_date_from => l_offers_rec.perf_date_from,
254: p_perf_date_to => l_offers_rec.perf_date_to,
255: p_status_code => l_offers_rec.status_code,
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
821: l_is_admin := AMS_Access_PVT.Check_Admin_Access(ozf_utility_pvt.get_resource_id(FND_GLOBAL.user_id));
822:
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,
874: p_wf_item_key => l_offers_rec.wf_item_key,
875: p_customer_reference => l_offers_rec.customer_reference,
876: p_buying_group_contact_id => l_offers_rec.buying_group_contact_id,
877: p_last_update_date => SYSDATE,
878: p_last_updated_by => FND_GLOBAL.user_id,
879: p_last_update_login => FND_GLOBAL.conc_login_id,
880: p_object_version_number => l_offers_rec.object_version_number,
881: p_perf_date_from => l_offers_rec.perf_date_from,
882: p_perf_date_to => l_offers_rec.perf_date_to,
875: p_customer_reference => l_offers_rec.customer_reference,
876: p_buying_group_contact_id => l_offers_rec.buying_group_contact_id,
877: p_last_update_date => SYSDATE,
878: p_last_updated_by => FND_GLOBAL.user_id,
879: p_last_update_login => FND_GLOBAL.conc_login_id,
880: p_object_version_number => l_offers_rec.object_version_number,
881: p_perf_date_from => l_offers_rec.perf_date_from,
882: p_perf_date_to => l_offers_rec.perf_date_to,
883: p_status_code => l_offers_rec.status_code,