1: PACKAGE BODY ben_dm_master AS
2: /* $Header: benfdmdmas.pkb 120.0 2006/05/04 04:47:39 nkkrishn noship $ */
3:
4:
5: g_delimiter varchar2(1) := fnd_global.local_chr(01);
6: g_data_file_name varchar2(30) := 'out_file.dat';
7: g_transfer_file_name varchar2(30) := 'transfer_file.dat';
8: /*-------------------------- PRIVATE ROUTINES ----------------------------*/
9:
1200: ,'NS'
1201: ,NULL
1202: ,SYSDATE
1203: ,0
1204: ,fnd_global.user_id
1205: ,SYSDATE
1206: ,fnd_global.user_id
1207: ,SYSDATE
1208: ,fnd_global.user_id
1202: ,SYSDATE
1203: ,0
1204: ,fnd_global.user_id
1205: ,SYSDATE
1206: ,fnd_global.user_id
1207: ,SYSDATE
1208: ,fnd_global.user_id
1209: ,'S'
1210: );
1204: ,fnd_global.user_id
1205: ,SYSDATE
1206: ,fnd_global.user_id
1207: ,SYSDATE
1208: ,fnd_global.user_id
1209: ,'S'
1210: );
1211:
1212: Commit;
1210: );
1211:
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
1246: ,l_request_id
1247: ,'M'
1248: ,'Y'
1249: ,SYSDATE
1250: ,fnd_global.user_id
1251: ,fnd_global.login_id
1252: ,fnd_global.user_id
1253: ,SYSDATE
1254: );
1247: ,'M'
1248: ,'Y'
1249: ,SYSDATE
1250: ,fnd_global.user_id
1251: ,fnd_global.login_id
1252: ,fnd_global.user_id
1253: ,SYSDATE
1254: );
1255:
1248: ,'Y'
1249: ,SYSDATE
1250: ,fnd_global.user_id
1251: ,fnd_global.login_id
1252: ,fnd_global.user_id
1253: ,SYSDATE
1254: );
1255:
1256: END IF;
1339: ,'NS'
1340: ,NULL
1341: ,SYSDATE
1342: ,0
1343: ,fnd_global.user_id
1344: ,SYSDATE
1345: ,fnd_global.user_id
1346: ,SYSDATE
1347: ,fnd_global.user_id
1341: ,SYSDATE
1342: ,0
1343: ,fnd_global.user_id
1344: ,SYSDATE
1345: ,fnd_global.user_id
1346: ,SYSDATE
1347: ,fnd_global.user_id
1348: ,'D'
1349: );
1343: ,fnd_global.user_id
1344: ,SYSDATE
1345: ,fnd_global.user_id
1346: ,SYSDATE
1347: ,fnd_global.user_id
1348: ,'D'
1349: );
1350:
1351: Commit;
1349: );
1350:
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
1385: ,l_request_id
1386: ,'M'
1387: ,'Y'
1388: ,SYSDATE
1389: ,fnd_global.user_id
1390: ,fnd_global.login_id
1391: ,fnd_global.user_id
1392: ,SYSDATE
1393: );
1386: ,'M'
1387: ,'Y'
1388: ,SYSDATE
1389: ,fnd_global.user_id
1390: ,fnd_global.login_id
1391: ,fnd_global.user_id
1392: ,SYSDATE
1393: );
1394:
1387: ,'Y'
1388: ,SYSDATE
1389: ,fnd_global.user_id
1390: ,fnd_global.login_id
1391: ,fnd_global.user_id
1392: ,SYSDATE
1393: );
1394:
1395: END IF;
1420: ben_dm_utility.message('SUMM','Re Start Migration ID : '||p_restart_migration_id, 20);
1421:
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
1452: ,l_request_id
1453: ,'M'
1454: ,'Y'
1455: ,SYSDATE
1456: ,fnd_global.user_id
1457: ,fnd_global.login_id
1458: ,fnd_global.user_id
1459: ,SYSDATE
1460: );
1453: ,'M'
1454: ,'Y'
1455: ,SYSDATE
1456: ,fnd_global.user_id
1457: ,fnd_global.login_id
1458: ,fnd_global.user_id
1459: ,SYSDATE
1460: );
1461: commit;
1454: ,'Y'
1455: ,SYSDATE
1456: ,fnd_global.user_id
1457: ,fnd_global.login_id
1458: ,fnd_global.user_id
1459: ,SYSDATE
1460: );
1461: commit;
1462: end if;
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);
1476: