APPS.OZF_COPY_OFFER_PVT dependencies on AMS_ACT_ACCESS_DENORM

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

2102: ,'N'
2103: ,'Y');
2104: -- end create access for owner
2105:
2106: -- create access in ams_act_access_denorm for new offer owner
2107: INSERT INTO ams_act_access_denorm
2108: (access_denorm_id
2109: ,object_type
2110: ,object_id

Line 2107: INSERT INTO ams_act_access_denorm

2103: ,'Y');
2104: -- end create access for owner
2105:
2106: -- create access in ams_act_access_denorm for new offer owner
2107: INSERT INTO ams_act_access_denorm
2108: (access_denorm_id
2109: ,object_type
2110: ,object_id
2111: ,resource_id

Line 2121: (ams_act_access_denorm_s.NEXTVAL

2117: ,last_update_login
2118: ,last_updated_by
2119: ,created_by)
2120: VALUES
2121: (ams_act_access_denorm_s.NEXTVAL
2122: ,'OFFR'
2123: ,l_offer_rec.qp_list_header_id
2124: ,l_offer_rec.owner_id
2125: ,'Y'

Line 2133: -- end create access in ams_act_access_denorm

2129: ,SYSDATE
2130: ,FND_GLOBAL.conc_login_id
2131: ,FND_GLOBAL.user_id
2132: ,FND_GLOBAL.user_id);
2133: -- end create access in ams_act_access_denorm
2134:
2135: -- create access for default team
2136: l_default_team := FND_PROFILE.value('OZF_DEFAULT_OFFER_TEAM');
2137: