[Home] [Help]
298: sysdate,
299: 1,
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:
1163: -- sequence number from ben_dm_migrations_s.
1164: --
1165: SELECT ben_dm_migrations_s.nextval
1166: INTO l_migration_id
1167: FROM dual;
1168:
1169: INSERT INTO ben_dm_migrations
1170: (migration_id
1171: ,migration_name
1212: Commit;
1213:
1214: select fnd_global.conc_request_id
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);
1302: -- sequence number from ben_dm_migrations_s.
1303: --
1304: SELECT ben_dm_migrations_s.nextval
1305: INTO l_migration_id
1306: FROM dual;
1307:
1308: INSERT INTO ben_dm_migrations
1309: (migration_id
1310: ,migration_name
1351: Commit;
1352:
1353: select fnd_global.conc_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);
1422: l_migration_id := p_restart_migration_id;
1423:
1424: select fnd_global.conc_request_id
1425: into 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