DBA Data[Home] [Help]

APPS.CZ_MODEL_MIGRATION_PVT dependencies on CZ_PERSISTENT_REC_IDS

Line 174: UPDATE CZ_PERSISTENT_REC_IDS SET max_persistent_rec_id = max_persistent_rec_id + 1

170: x_new_record_id IN OUT NOCOPY NUMBER
171: ) IS
172: PRAGMA AUTONOMOUS_TRANSACTION;
173: BEGIN
174: UPDATE CZ_PERSISTENT_REC_IDS SET max_persistent_rec_id = max_persistent_rec_id + 1
175: WHERE devl_project_id= (select devl_project_id from cz_devl_projects
176: where deleted_flag = '0' and devl_project_id=p_model_id
177: AND post_migr_change_flag <> 'L') and deleted_flag=0
178: --If no record returned, the value of the variable will not change.