[Home] [Help]
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,
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
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
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
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
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