APPS.HR_DM_MASTER dependencies on HR_DM_MIGRATION_REQUESTS

Line 10: -- b) entries in hr_dm_migration_requests are marked as inactive

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
14: -- f) the migration status is set to started

Line 69: FROM hr_dm_migration_requests

65: WHERE (migration_id = p_migration_id);
66:
67: CURSOR csr_migration_request IS
68: SELECT MAX(creation_date)
69: FROM hr_dm_migration_requests
70: WHERE (migration_id = p_migration_id);
71:
72:
73: CURSOR csr_database IS

Line 114: UPDATE hr_dm_migration_requests

110: OPEN csr_migration_request;
111: FETCH csr_migration_request INTO l_migration_date;
112: CLOSE csr_migration_request;
113:
114: UPDATE hr_dm_migration_requests
115: SET enabled_flag = 'N'
116: WHERE ((migration_id = p_migration_id)
117: AND (creation_date <> l_migration_date));
118:

Line 209: -- the table hr_dm_migration_requests.

205: --
206:
207: -- ------------------------- insert_request ------------------------
208: -- Description: Inserts the details of a concurrent manager request into
209: -- the table hr_dm_migration_requests.
210: --
211: --
212: -- Input Parameters
213: -- p_phase - phase code

Line 253: INSERT INTO hr_dm_migration_requests (migration_request_id,

249: ')(p_phase_id - ' || p_phase_id ||
250: ')(p_phase_item_id - ' || p_phase_item_id || ')', 10);
251:
252:
253: INSERT INTO hr_dm_migration_requests (migration_request_id,
254: migration_id,
255: phase_id,
256: phase_item_id,
257: request_id,

Line 265: SELECT hr_dm_migration_requests_s.nextval,

261: last_update_date,
262: last_update_login,
263: creation_date,
264: created_by)
265: SELECT hr_dm_migration_requests_s.nextval,
266: p_migration_id,
267: p_phase_id,
268: p_phase_item_id,
269: p_request_id,

Line 279: (SELECT NULL FROM hr_dm_migration_requests

275: sysdate,
276: 1
277: FROM sys.dual
278: WHERE NOT EXISTS
279: (SELECT NULL FROM hr_dm_migration_requests
280: WHERE request_id = p_request_id);
281:
282: COMMIT;
283:

Line 284: hr_dm_utility.message('INFO','Inserted into hr_dm_migration_requests', 15);

280: WHERE request_id = p_request_id);
281:
282: COMMIT;
283:
284: hr_dm_utility.message('INFO','Inserted into hr_dm_migration_requests', 15);
285: hr_dm_utility.message('SUMM','Inserted into hr_dm_migration_requests', 20);
286: hr_dm_utility.message('ROUT','exit:hr_dm_master.insert_request', 25);
287: hr_dm_utility.message('PARA','(none)', 30);
288:

Line 285: hr_dm_utility.message('SUMM','Inserted into hr_dm_migration_requests', 20);

281:
282: COMMIT;
283:
284: hr_dm_utility.message('INFO','Inserted into hr_dm_migration_requests', 15);
285: hr_dm_utility.message('SUMM','Inserted into hr_dm_migration_requests', 20);
286: hr_dm_utility.message('ROUT','exit:hr_dm_master.insert_request', 25);
287: hr_dm_utility.message('PARA','(none)', 30);
288:
289: -- error handling

Line 387: -- update table hr_dm_migration_requests

383: TO_CHAR(r_migration_data.last_migration_date),
384: argument4 => TO_CHAR(l_counter));
385:
386:
387: -- update table hr_dm_migration_requests
388: insert_request(p_phase => p_current_phase,
389: p_request_id => l_request_id,
390: p_master_slave => 'S',
391: p_migration_id => r_migration_data.migration_id,

Line 467: FROM hr_dm_migration_requests

463: l_phase_id NUMBER;
464:
465: CURSOR csr_requests IS
466: SELECT request_id
467: FROM hr_dm_migration_requests
468: WHERE ((phase_id = l_phase_id)
469: AND (master_slave = 'S')
470: AND (enabled_flag = 'Y'));
471: