APPS.AMS_ACCESS_PVT dependencies on AMS_ACT_ACCESS_S

Line 58: SELECT ams_act_access_s.NEXTVAL

54:
55: --End:Fix for Bug#10192372
56:
57: CURSOR c_access_seq IS
58: SELECT ams_act_access_s.NEXTVAL
59: FROM DUAL;
60:
61: CURSOR c_access_count(l_access_id IN NUMBER) IS
62: SELECT COUNT(*)

Line 1302: UPDATE ams_act_access SET

1298: END IF;
1299:
1300:
1301:
1302: UPDATE ams_act_access SET
1303: last_update_date = SYSDATE,
1304: last_updated_by = FND_GLOBAL.user_id,
1305: last_update_login = FND_GLOBAL.conc_login_id,
1306: object_version_number = l_access_rec.object_version_number + 1,

Line 1338: UPDATE ams_act_access SET

1334: 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,'CSCH');
1335: FETCH c_get_key_id INTO l_key_id;
1336: CLOSE c_get_key_id;
1337:
1338: UPDATE ams_act_access SET
1339: last_update_date = SYSDATE,
1340: last_updated_by = FND_GLOBAL.user_id,
1341: last_update_login = FND_GLOBAL.conc_login_id,
1342: object_version_number = object_version_number + 1,

Line 1409: UPDATE ams_act_access SET

1405: CLOSE c_get_key_id;
1406:
1407:
1408:
1409: UPDATE ams_act_access SET
1410: last_update_date = SYSDATE,
1411: last_updated_by = FND_GLOBAL.user_id,
1412: last_update_login = FND_GLOBAL.conc_login_id,
1413: object_version_number = object_version_number + 1,

Line 1678: UPDATE ams_act_access SET

1674: );
1675: -- end of code added by julou
1676: END IF; -- added by sveerave on 06-jun-2002
1677: -- ELSE -- update owner to new resource
1678: UPDATE ams_act_access SET
1679: last_update_date = SYSDATE,
1680: last_updated_by = FND_GLOBAL.user_id,
1681: last_update_login = FND_GLOBAL.conc_login_id,
1682: object_version_number = object_version_number + 1,