APPS.AMS_ACCESS_PVT dependencies on AMS_ACCESS_DENORM_PVT

Line 209: ams_access_denorm_pvt.insert_resource (

205: l_access_rec.admin_flag := 'Y';
206: END IF;
207: IF l_access_rec.arc_user_or_role_type = 'USER' THEN
208:
209: ams_access_denorm_pvt.insert_resource (
210: p_resource_id => l_access_rec.user_or_role_id,
211: p_object_id => l_access_rec.act_access_to_object_id,
212: p_object_type => l_access_rec.arc_act_access_to_object,
213: p_edit_metrics => l_access_rec.admin_flag,

Line 317: ams_access_denorm_pvt.insert_resource (

313: and arc_user_or_role_type = 'USER');
314:
315: IF l_access_rec.arc_user_or_role_type = 'USER' THEN
316:
317: ams_access_denorm_pvt.insert_resource (
318: p_resource_id => l_access_rec.user_or_role_id,
319: p_object_id => l_schedule_rec.schedule_id,
320: p_object_type => 'CSCH',
321: p_edit_metrics => nvl(l_access_rec.admin_flag,'N'),

Line 576: ams_access_denorm_pvt.delete_resource (

572: END IF;
573: RAISE FND_API.g_exc_error;
574: END IF;
575:
576: ams_access_denorm_pvt.delete_resource (
577: p_resource_id => l_role_id,
578: p_object_id => l_schedule_rec.schedule_id,
579: p_object_type => 'CSCH',
580: p_edit_metrics => l_admin_flag,

Line 602: ams_access_denorm_pvt.delete_resource (

598: CLOSE c_access_camp_schedules;
599: END IF;
600: -- end change. for schedules. 09/12/01
601:
602: ams_access_denorm_pvt.delete_resource (
603: p_resource_id => l_role_id,
604: p_object_id => l_object_id,
605: p_object_type => l_object_type,
606: p_edit_metrics => l_admin_flag,

Line 1090: ams_access_denorm_pvt.update_resource (

1086: END IF;
1087: RAISE FND_API.g_exc_error;
1088: END IF;
1089:
1090: ams_access_denorm_pvt.update_resource (
1091: p_resource_id => l_access_rec.user_or_role_id,
1092: p_object_id => l_schedule_rec.schedule_id,
1093: p_object_type => 'CSCH',
1094: p_edit_metrics => l_access_rec.admin_flag,

Line 1120: ams_access_denorm_pvt.update_resource (

1116: /* end change for schedule level access */
1117:
1118: IF l_access_rec.arc_user_or_role_type = 'USER' THEN
1119: IF l_access_rec.owner_flag <> 'Y' OR l_access_rec.owner_flag IS NULL THEN
1120: ams_access_denorm_pvt.update_resource (
1121: p_resource_id => l_access_rec.user_or_role_id,
1122: p_object_id => l_access_rec.act_access_to_object_id,
1123: p_object_type => l_access_rec.arc_act_access_to_object,
1124: p_edit_metrics => l_access_rec.admin_flag,

Line 1144: ams_access_denorm_pvt.delete_resource (

1140: END IF;
1141:
1142: ELSIF l_access_rec.owner_flag = 'Y' THEN
1143:
1144: ams_access_denorm_pvt.delete_resource (
1145: p_resource_id => l_access_rec.user_or_role_id,
1146: p_object_id => l_access_rec.act_access_to_object_id,
1147: p_object_type => l_access_rec.arc_act_access_to_object,
1148: p_edit_metrics => l_access_rec.admin_flag,

Line 1166: ams_access_denorm_pvt.insert_resource (

1162: FND_MSG_PUB.add;
1163: RAISE FND_API.g_exc_unexpected_error;
1164: END IF;
1165:
1166: ams_access_denorm_pvt.insert_resource (
1167: p_resource_id => l_access_rec.user_or_role_id,
1168: p_object_id => l_access_rec.act_access_to_object_id,
1169: p_object_type => l_access_rec.arc_act_access_to_object,
1170: p_edit_metrics => l_access_rec.admin_flag,

Line 1360: ams_access_denorm_pvt.delete_resource (

1356: RAISE FND_API.g_exc_error;
1357: END IF;
1358: -- END IF;
1359:
1360: ams_access_denorm_pvt.delete_resource (
1361: p_resource_id => p_old_resource_id,
1362: p_object_id => p_object_id,
1363: p_object_type => p_object_type,
1364: p_edit_metrics => 'Y',

Line 1382: ams_access_denorm_pvt.insert_resource (

1378: FND_MSG_PUB.add;
1379: RAISE FND_API.g_exc_unexpected_error;
1380: END IF;
1381:
1382: ams_access_denorm_pvt.insert_resource (
1383: p_resource_id => p_resource_id,
1384: p_object_id => p_object_id,
1385: p_object_type => p_object_type,
1386: p_edit_metrics => 'Y',