APPS.AMS_ACCESS_PVT dependencies on AMS_ACCESS_DENORM_PVT

Line 234: ams_access_denorm_pvt.insert_resource (

230: l_access_rec.admin_flag := 'Y';
231: END IF;
232: IF l_access_rec.arc_user_or_role_type = 'USER' THEN
233:
234: ams_access_denorm_pvt.insert_resource (
235: p_resource_id => l_access_rec.user_or_role_id,
236: p_object_id => l_access_rec.act_access_to_object_id,
237: p_object_type => l_access_rec.arc_act_access_to_object,
238: p_edit_metrics => l_access_rec.admin_flag,

Line 342: ams_access_denorm_pvt.insert_resource (

338: and arc_user_or_role_type = 'USER');
339:
340: IF l_access_rec.arc_user_or_role_type = 'USER' THEN
341:
342: ams_access_denorm_pvt.insert_resource (
343: p_resource_id => l_access_rec.user_or_role_id,
344: p_object_id => l_schedule_rec.schedule_id,
345: p_object_type => 'CSCH',
346: p_edit_metrics => nvl(l_access_rec.admin_flag,'N'),

Line 447: ams_access_denorm_pvt.insert_resource (

443:
444:
445: IF l_access_rec.arc_user_or_role_type = 'USER' THEN
446:
447: ams_access_denorm_pvt.insert_resource (
448: p_resource_id => l_access_rec.user_or_role_id,
449: p_object_id => l_qp_list_header_id,
450: p_object_type => 'OFFR',
451: p_edit_metrics => nvl(l_access_rec.admin_flag,'N'),

Line 733: ams_access_denorm_pvt.delete_resource (

729: END IF;
730: RAISE FND_API.g_exc_error;
731: END IF;
732:
733: ams_access_denorm_pvt.delete_resource (
734: p_resource_id => l_role_id,
735: p_object_id => l_schedule_rec.schedule_id,
736: p_object_type => 'CSCH',
737: p_edit_metrics => l_admin_flag,

Line 781: ams_access_denorm_pvt.delete_resource (

777: END IF;
778: RAISE FND_API.g_exc_error;
779: END IF;
780:
781: ams_access_denorm_pvt.delete_resource (
782: p_resource_id => l_role_id,
783: p_object_id => l_qp_list_header_id,
784: p_object_type => 'OFFR',
785: p_edit_metrics => l_admin_flag,

Line 811: ams_access_denorm_pvt.delete_resource (

807:
808: END IF; --for l_object_type
809: -- end change. for schedules. 09/12/01
810:
811: ams_access_denorm_pvt.delete_resource (
812: p_resource_id => l_role_id,
813: p_object_id => l_object_id,
814: p_object_type => l_object_type,
815: p_edit_metrics => l_admin_flag,

Line 1361: ams_access_denorm_pvt.update_resource (

1357: END IF;
1358: RAISE FND_API.g_exc_error;
1359: END IF;
1360:
1361: ams_access_denorm_pvt.update_resource (
1362: p_resource_id => l_access_rec.user_or_role_id,
1363: p_object_id => l_schedule_rec.schedule_id,
1364: p_object_type => 'CSCH',
1365: p_edit_metrics => l_access_rec.admin_flag,

Line 1432: ams_access_denorm_pvt.update_resource (

1428: END IF;
1429: RAISE FND_API.g_exc_error;
1430: END IF;
1431:
1432: ams_access_denorm_pvt.update_resource (
1433: p_resource_id => l_access_rec.user_or_role_id,
1434: p_object_id => l_qp_list_header_id,
1435: p_object_type => 'OFFR',
1436: p_edit_metrics => l_access_rec.admin_flag,

Line 1463: ams_access_denorm_pvt.update_resource (

1459: /* end change for schedule level access */
1460:
1461: IF l_access_rec.arc_user_or_role_type = 'USER' THEN
1462: IF l_access_rec.owner_flag <> 'Y' OR l_access_rec.owner_flag IS NULL THEN
1463: ams_access_denorm_pvt.update_resource (
1464: p_resource_id => l_access_rec.user_or_role_id,
1465: p_object_id => l_access_rec.act_access_to_object_id,
1466: p_object_type => l_access_rec.arc_act_access_to_object,
1467: p_edit_metrics => l_access_rec.admin_flag,

Line 1487: ams_access_denorm_pvt.delete_resource (

1483: END IF;
1484:
1485: ELSIF l_access_rec.owner_flag = 'Y' THEN
1486:
1487: ams_access_denorm_pvt.delete_resource (
1488: p_resource_id => l_access_rec.user_or_role_id,
1489: p_object_id => l_access_rec.act_access_to_object_id,
1490: p_object_type => l_access_rec.arc_act_access_to_object,
1491: p_edit_metrics => l_access_rec.admin_flag,

Line 1509: ams_access_denorm_pvt.insert_resource (

1505: FND_MSG_PUB.add;
1506: RAISE FND_API.g_exc_unexpected_error;
1507: END IF;
1508:
1509: ams_access_denorm_pvt.insert_resource (
1510: p_resource_id => l_access_rec.user_or_role_id,
1511: p_object_id => l_access_rec.act_access_to_object_id,
1512: p_object_type => l_access_rec.arc_act_access_to_object,
1513: p_edit_metrics => l_access_rec.admin_flag,

Line 1703: ams_access_denorm_pvt.delete_resource (

1699: RAISE FND_API.g_exc_error;
1700: END IF;
1701: -- END IF;
1702:
1703: ams_access_denorm_pvt.delete_resource (
1704: p_resource_id => p_old_resource_id,
1705: p_object_id => p_object_id,
1706: p_object_type => p_object_type,
1707: p_edit_metrics => 'Y',

Line 1725: ams_access_denorm_pvt.insert_resource (

1721: FND_MSG_PUB.add;
1722: RAISE FND_API.g_exc_unexpected_error;
1723: END IF;
1724:
1725: ams_access_denorm_pvt.insert_resource (
1726: p_resource_id => p_resource_id,
1727: p_object_id => p_object_id,
1728: p_object_type => p_object_type,
1729: p_edit_metrics => 'Y',