[Home] [Help]
9:
10: -- ------------------------- controller_init ------------------------
11: -- Description: Various initialization processes are undertaken:
12: -- a) ensuring that data for the migration exists in ben_dm_migrations
13: -- b) entries in ben_dm_migration_requests are marked as inactive
14: -- c) r_migration_data is seeded with information about the migration
15: -- d) the migration count is incremented
16: -- e) the validity of the migration is checked
17: -- f) the migration status is set to started
74: WHERE (migration_id = p_migration_id);
75:
76: CURSOR csr_migration_request IS
77: SELECT MAX(creation_date)
78: FROM ben_dm_migration_requests
79: WHERE (migration_id = p_migration_id);
80:
81:
82: --
118: OPEN csr_migration_request;
119: FETCH csr_migration_request INTO l_migration_date;
120: CLOSE csr_migration_request;
121:
122: UPDATE ben_dm_migration_requests
123: SET enabled_flag = 'N'
124: WHERE ((migration_id = p_migration_id)
125: AND (creation_date <> l_migration_date));
126:
230: END getTableSchema;
231:
232: -- ------------------------- insert_request ------------------------
233: -- Description: Inserts the details of a concurrent manager request into
234: -- the table ben_dm_migration_requests.
235: --
236: --
237: -- Input Parameters
238: -- p_phase - phase code
274: ')(p_phase_id - ' || p_phase_id ||
275: ')(p_phase_item_id - ' || p_phase_item_id || ')', 10);
276:
277:
278: INSERT INTO ben_dm_migration_requests (migration_request_id,
279: migration_id,
280: phase_id,
281: phase_item_id,
282: request_id,
286: last_update_date,
287: last_update_login,
288: creation_date,
289: created_by)
290: SELECT ben_dm_migration_requests_s.nextval,
291: p_migration_id,
292: nvl(p_phase_id,-1),
293: nvl(p_phase_item_id,-1),
294: p_request_id,
300: sysdate,
301: 1
302: FROM sys.dual
303: WHERE NOT EXISTS
304: (SELECT NULL FROM ben_dm_migration_requests
305: WHERE request_id = p_request_id);
306:
307: COMMIT;
308:
305: WHERE request_id = p_request_id);
306:
307: COMMIT;
308:
309: ben_dm_utility.message('INFO','Inserted into ben_dm_migration_requests', 15);
310: ben_dm_utility.message('SUMM','Inserted into ben_dm_migration_requests', 20);
311: ben_dm_utility.message('ROUT','exit:ben_dm_master.insert_request', 25);
312: ben_dm_utility.message('PARA','(none)', 30);
313:
306:
307: COMMIT;
308:
309: ben_dm_utility.message('INFO','Inserted into ben_dm_migration_requests', 15);
310: ben_dm_utility.message('SUMM','Inserted into ben_dm_migration_requests', 20);
311: ben_dm_utility.message('ROUT','exit:ben_dm_master.insert_request', 25);
312: ben_dm_utility.message('PARA','(none)', 30);
313:
314: -- error handling
494: argument7 => l_argument7,
495: argument8 => l_argument8);
496:
497:
498: -- update table ben_dm_migration_requests
499: insert_request(p_phase => p_current_phase,
500: p_request_id => l_request_id,
501: p_master_slave => 'S',
502: p_migration_id => r_migration_data.migration_id,
573:
574: CURSOR csr_requests(p_migration_id number,
575: p_phase_id number) IS
576: SELECT request_id
577: FROM ben_dm_migration_requests
578: WHERE migration_id = p_migration_id
579: AND phase_id = p_phase_id
580: AND master_slave = 'S'
581: AND enabled_flag = 'Y';
1215: into l_request_id
1216: from dual;
1217:
1218: IF l_request_id = 0 THEN
1219: ben_dm_utility.message('INFO','Problem with Inserting into BEN_DM_MIGRATION_REQUESTS', 15);
1220: ben_dm_utility.message('SUMM','Problem with Inserting into BEN_DM_MIGRATION_REQUESTS', 20);
1221: ELSE
1222: --
1223: -- The request submission was successful - insert
1216: from dual;
1217:
1218: IF l_request_id = 0 THEN
1219: ben_dm_utility.message('INFO','Problem with Inserting into BEN_DM_MIGRATION_REQUESTS', 15);
1220: ben_dm_utility.message('SUMM','Problem with Inserting into BEN_DM_MIGRATION_REQUESTS', 20);
1221: ELSE
1222: --
1223: -- The request submission was successful - insert
1224: -- a row into ben_dm_migration_requests so that
1220: ben_dm_utility.message('SUMM','Problem with Inserting into BEN_DM_MIGRATION_REQUESTS', 20);
1221: ELSE
1222: --
1223: -- The request submission was successful - insert
1224: -- a row into ben_dm_migration_requests so that
1225: -- the user can view the logfile later on.
1226: --
1227: INSERT INTO ben_dm_migration_requests
1228: (migration_request_id
1223: -- The request submission was successful - insert
1224: -- a row into ben_dm_migration_requests so that
1225: -- the user can view the logfile later on.
1226: --
1227: INSERT INTO ben_dm_migration_requests
1228: (migration_request_id
1229: ,phase_id
1230: ,phase_item_id
1231: ,migration_id
1238: ,created_by
1239: ,creation_date
1240: )
1241: VALUES
1242: (ben_dm_migration_requests_s.nextval
1243: ,-1
1244: ,-1
1245: ,l_migration_id
1246: ,l_request_id
1354: into l_request_id
1355: from dual;
1356:
1357: IF l_request_id = 0 THEN
1358: ben_dm_utility.message('INFO','Problem with Inserting into BEN_DM_MIGRATION_REQUESTS', 15);
1359: ben_dm_utility.message('SUMM','Problem with Inserting into BEN_DM_MIGRATION_REQUESTS', 20);
1360: ELSE
1361: --
1362: -- The request submission was successful - insert
1355: from dual;
1356:
1357: IF l_request_id = 0 THEN
1358: ben_dm_utility.message('INFO','Problem with Inserting into BEN_DM_MIGRATION_REQUESTS', 15);
1359: ben_dm_utility.message('SUMM','Problem with Inserting into BEN_DM_MIGRATION_REQUESTS', 20);
1360: ELSE
1361: --
1362: -- The request submission was successful - insert
1363: -- a row into ben_dm_migration_requests so that
1359: ben_dm_utility.message('SUMM','Problem with Inserting into BEN_DM_MIGRATION_REQUESTS', 20);
1360: ELSE
1361: --
1362: -- The request submission was successful - insert
1363: -- a row into ben_dm_migration_requests so that
1364: -- the user can view the logfile later on.
1365: --
1366: INSERT INTO ben_dm_migration_requests
1367: (migration_request_id
1362: -- The request submission was successful - insert
1363: -- a row into ben_dm_migration_requests so that
1364: -- the user can view the logfile later on.
1365: --
1366: INSERT INTO ben_dm_migration_requests
1367: (migration_request_id
1368: ,phase_id
1369: ,phase_item_id
1370: ,migration_id
1377: ,created_by
1378: ,creation_date
1379: )
1380: VALUES
1381: (ben_dm_migration_requests_s.nextval
1382: ,-1
1383: ,-1
1384: ,l_migration_id
1385: ,l_request_id
1426: from dual;
1427:
1428: if l_request_data IS NULL THEN
1429: -- The request submission was successful - insert
1430: -- a row into ben_dm_migration_requests so that
1431: -- the user can view the logfile later on.
1432: --
1433: INSERT INTO ben_dm_migration_requests
1434: (migration_request_id
1429: -- The request submission was successful - insert
1430: -- a row into ben_dm_migration_requests so that
1431: -- the user can view the logfile later on.
1432: --
1433: INSERT INTO ben_dm_migration_requests
1434: (migration_request_id
1435: ,phase_id
1436: ,phase_item_id
1437: ,migration_id
1444: ,created_by
1445: ,creation_date
1446: )
1447: VALUES
1448: (ben_dm_migration_requests_s.nextval
1449: ,-1
1450: ,-1
1451: ,l_migration_id
1452: ,l_request_id
1467: ben_dm_utility.message_init;
1468:
1469: select migration_id
1470: into l_migration_id
1471: from ben_dm_migration_requests
1472: where request_id = fnd_global.conc_request_id;
1473:
1474: ben_dm_utility.message('INFO','l_migration_id : '||l_migration_id, 15);
1475: ben_dm_utility.message('SUMM','l_migration_id : '||l_migration_id, 15);