APPS.HR_DM_MASTER dependencies on HR_DM_MIGRATIONS

Line 9: -- a) ensuring that data for the migration exists in hr_dm_migrations

5: /*-------------------------- PRIVATE ROUTINES ----------------------------*/
6:
7: -- ------------------------- controller_init ------------------------
8: -- Description: Various initialization processes are undertaken:
9: -- a) ensuring that data for the migration exists in hr_dm_migrations
10: -- b) entries in hr_dm_migration_requests are marked as inactive
11: -- c) r_migration_data is seeded with information about the migration
12: -- d) the migration count is incremented
13: -- e) the validity of the migration is checked

Line 64: FROM hr_dm_migrations

60: SELECT MIGRATION_ID, UPPER(SOURCE_DATABASE_INSTANCE),
61: UPPER(DESTINATION_DATABASE_INSTANCE),
62: MIGRATION_TYPE, APPLICATION_ID, MIGRATION_COUNT, BUSINESS_GROUP_ID,
63: STATUS
64: FROM hr_dm_migrations
65: WHERE (migration_id = p_migration_id);
66:
67: CURSOR csr_migration_request IS
68: SELECT MAX(creation_date)

Line 99: -- raise error if no matching row in hr_dm_migrations

95: EXIT WHEN csr_migration%NOTFOUND;
96: END LOOP;
97: CLOSE csr_migration;
98:
99: -- raise error if no matching row in hr_dm_migrations
100: IF (l_migration_id IS NULL) THEN
101: l_fatal_error_message := 'No row identified in HR_DM_MIGRATIONS!';
102: RAISE e_fatal_error;
103: END IF;

Line 101: l_fatal_error_message := 'No row identified in HR_DM_MIGRATIONS!';

97: CLOSE csr_migration;
98:
99: -- raise error if no matching row in hr_dm_migrations
100: IF (l_migration_id IS NULL) THEN
101: l_fatal_error_message := 'No row identified in HR_DM_MIGRATIONS!';
102: RAISE e_fatal_error;
103: END IF;
104:
105:

Line 151: -- increment migration count in hr_dm_migrations (non-paused)

147: r_migration_data.last_migration_date :=
148: hr_dm_business.last_migration_date(
149: r_migration_data);
150:
151: -- increment migration count in hr_dm_migrations (non-paused)
152: IF (p_request_data IS NULL) THEN
153: UPDATE hr_dm_migrations
154: SET migration_count = l_migration_count+1
155: WHERE migration_id = p_migration_id;

Line 153: UPDATE hr_dm_migrations

149: r_migration_data);
150:
151: -- increment migration count in hr_dm_migrations (non-paused)
152: IF (p_request_data IS NULL) THEN
153: UPDATE hr_dm_migrations
154: SET migration_count = l_migration_count+1
155: WHERE migration_id = p_migration_id;
156: COMMIT;
157: END IF;

Line 1075: FROM hr_dm_migrations

1071: AND (phase_name = l_request_data));
1072:
1073: CURSOR csr_mig_status IS
1074: SELECT status
1075: FROM hr_dm_migrations
1076: WHERE migration_id = r_migration_data.migration_id;
1077:
1078:
1079: --

Line 1236: UPDATE hr_dm_migrations

1232: -- then mark the migration as Finished
1233:
1234: IF r_migration_data.migration_type = 'D'
1235: AND l_mig_status = 'C' THEN
1236: UPDATE hr_dm_migrations
1237: SET status = 'F'
1238: WHERE migration_id = r_migration_data.migration_id;
1239: COMMIT;
1240: END IF;