APPS.OZF_COPY_OFFER_PVT dependencies on AMS_ACT_ACCESS

Line 1751: FROM ams_act_access

1747:
1748: --nepanda added cursor for Bug 10385923
1749: CURSOR c_edit_metrics_detail(p_user_or_role_id NUMBER) IS
1750: SELECT admin_flag
1751: FROM ams_act_access
1752: WHERE act_access_to_object_id = p_source_object_id
1753: AND user_or_role_id = p_user_or_role_id;
1754:
1755: --rvkondur Bug#12403402

Line 2066: INSERT INTO ams_act_access

2062: );
2063:
2064:
2065: -- create access for new offer owner
2066: INSERT INTO ams_act_access
2067: (activity_access_id
2068: ,last_update_date
2069: ,last_updated_by
2070: ,creation_date

Line 2086: (ams_act_access_s.NEXTVAL

2082: ,security_group_id
2083: ,delete_flag
2084: ,owner_flag)
2085: VALUES
2086: (ams_act_access_s.NEXTVAL
2087: ,SYSDATE
2088: ,FND_GLOBAL.user_id
2089: ,SYSDATE
2090: ,FND_GLOBAL.user_id

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:

Line 2145: INSERT INTO ams_act_access

2141: OPEN c_edit_metrics_detail(l_default_team);
2142: FETCH c_edit_metrics_detail INTO l_admin_flag;
2143: CLOSE c_edit_metrics_detail;
2144:
2145: INSERT INTO ams_act_access
2146: (activity_access_id
2147: ,last_update_date
2148: ,last_updated_by
2149: ,creation_date

Line 2165: (ams_act_access_s.NEXTVAL

2161: ,security_group_id
2162: ,delete_flag
2163: ,owner_flag)
2164: VALUES
2165: (ams_act_access_s.NEXTVAL
2166: ,SYSDATE
2167: ,FND_GLOBAL.user_id
2168: ,SYSDATE
2169: ,FND_GLOBAL.user_id