APPS.BEN_DM_UTILITY dependencies on BEN_DM_MIGRATIONS

Line 472: -- Description: Updates the status of the migration in the ben_dm_migrations

468: -- update status procedures
469: -- start
470:
471: -- ------------------------- update_migrations ------------------------
472: -- Description: Updates the status of the migration in the ben_dm_migrations
473: -- table. If the status is to be set to C then all child entries in
474: -- ben_dm_phases are checked to ensure that they have completed.
475: --
476: --

Line 492: -- table is ben_dm_migrations

488:
489: --
490: PROCEDURE update_migrations (p_new_status IN VARCHAR2, p_id IN NUMBER) IS
491: --
492: -- table is ben_dm_migrations
493: -- parent of ben_dm_phases
494: -- child of (none)
495:
496: l_parent_table_id NUMBER(9);

Line 524: UPDATE ben_dm_migrations

520:
521: -- non-complete
522: IF (p_new_status IN('S', 'NS', 'E')) THEN
523: -- update the status for this row
524: UPDATE ben_dm_migrations
525: SET status = p_new_status,
526: migration_start_date = NVL(l_start_date, migration_start_date)
527: WHERE migration_id = p_id;
528: COMMIT;

Line 541: UPDATE ben_dm_migrations

537:
538: IF (csr_child_table_complete%NOTFOUND) THEN
539: -- update the status for this row since no child rows
540: -- are incomplete
541: UPDATE ben_dm_migrations
542: SET status = p_new_status,
543: migration_end_date = sysdate
544: WHERE migration_id = p_id;
545: COMMIT;

Line 673: -- child of ben_dm_migrations

669: PROCEDURE update_phases (p_new_status IN VARCHAR2, p_id IN NUMBER) IS
670: --
671: -- table is ben_dm_phases
672: -- parent of ben_dm_phase_items
673: -- child of ben_dm_migrations
674:
675: l_parent_table_id NUMBER(9);
676: l_complete VARCHAR2(30);
677: l_start_time DATE;