APPS.AMS_ACCESS_PVT dependencies on AMS_ACT_ACCESS_S

Line 49: SELECT ams_act_access_s.NEXTVAL

45: l_access_rec access_rec_type := p_access_rec;
46: l_access_count NUMBER;
47:
48: CURSOR c_access_seq IS
49: SELECT ams_act_access_s.NEXTVAL
50: FROM DUAL;
51:
52: CURSOR c_access_count(l_access_id IN NUMBER) IS
53: SELECT COUNT(*)

Line 1031: UPDATE ams_act_access SET

1027:
1028: AMS_Utility_PVT.debug_message(l_full_name ||': update');
1029: END IF;
1030:
1031: UPDATE ams_act_access SET
1032: last_update_date = SYSDATE,
1033: last_updated_by = FND_GLOBAL.user_id,
1034: last_update_login = FND_GLOBAL.conc_login_id,
1035: object_version_number = l_access_rec.object_version_number + 1,

Line 1067: UPDATE ams_act_access SET

1063: OPEN c_get_key_id(l_schedule_rec.schedule_id, l_access_rec.arc_user_or_role_type, l_access_rec.user_or_role_id);
1064: FETCH c_get_key_id INTO l_key_id;
1065: CLOSE c_get_key_id;
1066:
1067: UPDATE ams_act_access SET
1068: last_update_date = SYSDATE,
1069: last_updated_by = FND_GLOBAL.user_id,
1070: last_update_login = FND_GLOBAL.conc_login_id,
1071: object_version_number = object_version_number + 1,

Line 1335: UPDATE ams_act_access SET

1331: );
1332: -- end of code added by julou
1333: END IF; -- added by sveerave on 06-jun-2002
1334: -- ELSE -- update owner to new resource
1335: UPDATE ams_act_access SET
1336: last_update_date = SYSDATE,
1337: last_updated_by = FND_GLOBAL.user_id,
1338: last_update_login = FND_GLOBAL.conc_login_id,
1339: object_version_number = object_version_number + 1,