APPS.OZF_COPY_OFFER_PVT dependencies on AMS_ACT_ACCESS_DENORM

Line 2044: -- create access in ams_act_access_denorm for new offer owner

2040: ,'N'
2041: ,'Y');
2042: -- end create access for owner
2043:
2044: -- create access in ams_act_access_denorm for new offer owner
2045: INSERT INTO ams_act_access_denorm
2046: (access_denorm_id
2047: ,object_type
2048: ,object_id

Line 2045: INSERT INTO ams_act_access_denorm

2041: ,'Y');
2042: -- end create access for owner
2043:
2044: -- create access in ams_act_access_denorm for new offer owner
2045: INSERT INTO ams_act_access_denorm
2046: (access_denorm_id
2047: ,object_type
2048: ,object_id
2049: ,resource_id

Line 2059: (ams_act_access_denorm_s.NEXTVAL

2055: ,last_update_login
2056: ,last_updated_by
2057: ,created_by)
2058: VALUES
2059: (ams_act_access_denorm_s.NEXTVAL
2060: ,'OFFR'
2061: ,l_offer_rec.qp_list_header_id
2062: ,l_offer_rec.owner_id
2063: ,'Y'

Line 2071: -- end create access in ams_act_access_denorm

2067: ,SYSDATE
2068: ,FND_GLOBAL.conc_login_id
2069: ,FND_GLOBAL.user_id
2070: ,FND_GLOBAL.user_id);
2071: -- end create access in ams_act_access_denorm
2072:
2073: -- create access for default team
2074: l_default_team := FND_PROFILE.value('OZF_DEFAULT_OFFER_TEAM');
2075: IF l_default_team IS NOT NULL AND l_default_team <> FND_API.G_MISS_NUM THEN