DBA Data[Home] [Help]

APPS.BEN_DM_MASTER dependencies on FND_GLOBAL

Line 5: g_delimiter varchar2(1) := fnd_global.local_chr(01);

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:

Line 1204: ,fnd_global.user_id

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

Line 1206: ,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: );

Line 1208: ,fnd_global.user_id

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;

Line 1214: select fnd_global.conc_request_id

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

Line 1250: ,fnd_global.user_id

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: );

Line 1251: ,fnd_global.login_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: );
1255:

Line 1252: ,fnd_global.user_id

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;

Line 1343: ,fnd_global.user_id

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

Line 1345: ,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: );

Line 1347: ,fnd_global.user_id

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;

Line 1353: select fnd_global.conc_request_id

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

Line 1389: ,fnd_global.user_id

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: );

Line 1390: ,fnd_global.login_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: );
1394:

Line 1391: ,fnd_global.user_id

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;

Line 1424: select fnd_global.conc_request_id

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

Line 1456: ,fnd_global.user_id

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: );

Line 1457: ,fnd_global.login_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: );
1461: commit;

Line 1458: ,fnd_global.user_id

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;

Line 1472: where request_id = fnd_global.conc_request_id;

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: