APPS.BEN_DM_DATA_UTIL dependencies on FND_GLOBAL

Line 822: l_delimiter varchar2(1) := fnd_global.local_chr(01);

818: ) is
819: -- validtion migration
820:
821: l_text varchar2(32667);
822: l_delimiter varchar2(1) := fnd_global.local_chr(01);
823: l_table_name ben_dm_tables.table_name%type ;
824: l_proc varchar2(75) ;
825: l_dummy varchar2(1) ;
826: begin

Line 1375: ,last_updated_by = fnd_global.user_id

1371: ,surrogate_pk_column_name = p_surrogate_pk_column_name
1372: ,short_name = p_short_name
1373: ,sequence_name = p_sequence_name
1374: ,last_update_date = sysdate
1375: ,last_updated_by = fnd_global.user_id
1376: ,last_update_login = fnd_global.login_id
1377: where table_id = l_table_id ;
1378:
1379: else

Line 1376: ,last_update_login = fnd_global.login_id

1372: ,short_name = p_short_name
1373: ,sequence_name = p_sequence_name
1374: ,last_update_date = sysdate
1375: ,last_updated_by = fnd_global.user_id
1376: ,last_update_login = fnd_global.login_id
1377: where table_id = l_table_id ;
1378:
1379: else
1380: hr_utility.set_location(' Update :'||p_table_name, 10);

Line 1408: ,fnd_global.user_id

1404: ,p_surrogate_pk_column_name
1405: ,p_short_name
1406: ,p_sequence_name
1407: ,sysdate
1408: ,fnd_global.user_id
1409: ,fnd_global.login_id
1410: ,fnd_global.user_id
1411: ,sysdate
1412: ) ;

Line 1409: ,fnd_global.login_id

1405: ,p_short_name
1406: ,p_sequence_name
1407: ,sysdate
1408: ,fnd_global.user_id
1409: ,fnd_global.login_id
1410: ,fnd_global.user_id
1411: ,sysdate
1412: ) ;
1413: end if ;

Line 1410: ,fnd_global.user_id

1406: ,p_sequence_name
1407: ,sysdate
1408: ,fnd_global.user_id
1409: ,fnd_global.login_id
1410: ,fnd_global.user_id
1411: ,sysdate
1412: ) ;
1413: end if ;
1414: close c1 ;

Line 1470: ,last_updated_by = fnd_global.user_id

1466: hr_utility.set_location(' Insert :'||p_table_name, 10);
1467: update ben_dm_table_order
1468: set table_order = p_table_order
1469: ,last_update_date = sysdate
1470: ,last_updated_by = fnd_global.user_id
1471: ,last_update_login = fnd_global.login_id
1472: where table_order_id = l_table_order_id
1473: ;
1474: else

Line 1471: ,last_update_login = fnd_global.login_id

1467: update ben_dm_table_order
1468: set table_order = p_table_order
1469: ,last_update_date = sysdate
1470: ,last_updated_by = fnd_global.user_id
1471: ,last_update_login = fnd_global.login_id
1472: where table_order_id = l_table_order_id
1473: ;
1474: else
1475: hr_utility.set_location(' Update :'||p_table_name, 10);

Line 1490: ,fnd_global.user_id

1486: (ben_dm_table_order_s.nextval
1487: ,l_table_id
1488: ,p_table_order
1489: ,sysdate
1490: ,fnd_global.user_id
1491: ,fnd_global.login_id
1492: ,fnd_global.user_id
1493: ,sysdate
1494: );

Line 1491: ,fnd_global.login_id

1487: ,l_table_id
1488: ,p_table_order
1489: ,sysdate
1490: ,fnd_global.user_id
1491: ,fnd_global.login_id
1492: ,fnd_global.user_id
1493: ,sysdate
1494: );
1495: end if ;

Line 1492: ,fnd_global.user_id

1488: ,p_table_order
1489: ,sysdate
1490: ,fnd_global.user_id
1491: ,fnd_global.login_id
1492: ,fnd_global.user_id
1493: ,sysdate
1494: );
1495: end if ;
1496: close c2 ;

Line 1557: ,last_updated_by = fnd_global.user_id

1553: set parent_table_name = p_parent_table_name
1554: ,parent_column_name = p_parent_column_name
1555: ,parent_id_column_name = p_parent_id_column_name
1556: ,last_update_date = sysdate
1557: ,last_updated_by = fnd_global.user_id
1558: ,last_update_login = fnd_global.login_id
1559: where hierarchy_id = l_hierarchy_id
1560: ;
1561: else

Line 1558: ,last_update_login = fnd_global.login_id

1554: ,parent_column_name = p_parent_column_name
1555: ,parent_id_column_name = p_parent_id_column_name
1556: ,last_update_date = sysdate
1557: ,last_updated_by = fnd_global.user_id
1558: ,last_update_login = fnd_global.login_id
1559: where hierarchy_id = l_hierarchy_id
1560: ;
1561: else
1562: hr_utility.set_location(' Update :'||p_table_name, 10);

Line 1585: ,fnd_global.user_id

1581: ,p_parent_table_name
1582: ,p_parent_column_name
1583: ,p_parent_id_column_name
1584: ,sysdate
1585: ,fnd_global.user_id
1586: ,fnd_global.login_id
1587: ,fnd_global.user_id
1588: ,sysdate
1589: ) ;

Line 1586: ,fnd_global.login_id

1582: ,p_parent_column_name
1583: ,p_parent_id_column_name
1584: ,sysdate
1585: ,fnd_global.user_id
1586: ,fnd_global.login_id
1587: ,fnd_global.user_id
1588: ,sysdate
1589: ) ;
1590: end if ;

Line 1587: ,fnd_global.user_id

1583: ,p_parent_id_column_name
1584: ,sysdate
1585: ,fnd_global.user_id
1586: ,fnd_global.login_id
1587: ,fnd_global.user_id
1588: ,sysdate
1589: ) ;
1590: end if ;
1591: close c2 ;

Line 1665: ,fnd_global.user_id

1661: ,l_table_id
1662: ,p_column_name
1663: ,p_entity_result_column_name
1664: ,sysdate
1665: ,fnd_global.user_id
1666: ,fnd_global.login_id
1667: ,fnd_global.user_id
1668: ,sysdate
1669: ) ;

Line 1666: ,fnd_global.login_id

1662: ,p_column_name
1663: ,p_entity_result_column_name
1664: ,sysdate
1665: ,fnd_global.user_id
1666: ,fnd_global.login_id
1667: ,fnd_global.user_id
1668: ,sysdate
1669: ) ;
1670: end if ;

Line 1667: ,fnd_global.user_id

1663: ,p_entity_result_column_name
1664: ,sysdate
1665: ,fnd_global.user_id
1666: ,fnd_global.login_id
1667: ,fnd_global.user_id
1668: ,sysdate
1669: ) ;
1670: end if ;
1671: close c2 ;

Line 1730: ,fnd_global.user_id

1726: ,p_PREVIOUS_PHASE
1727: ,p_NEXT_PHASE
1728: ,p_DATABASE_LOCATION
1729: ,sysdate
1730: ,fnd_global.user_id
1731: ,fnd_global.login_id
1732: ,fnd_global.user_id
1733: ,sysdate
1734: ,p_SECURITY_GROUP_ID

Line 1731: ,fnd_global.login_id

1727: ,p_NEXT_PHASE
1728: ,p_DATABASE_LOCATION
1729: ,sysdate
1730: ,fnd_global.user_id
1731: ,fnd_global.login_id
1732: ,fnd_global.user_id
1733: ,sysdate
1734: ,p_SECURITY_GROUP_ID
1735: ) ;

Line 1732: ,fnd_global.user_id

1728: ,p_DATABASE_LOCATION
1729: ,sysdate
1730: ,fnd_global.user_id
1731: ,fnd_global.login_id
1732: ,fnd_global.user_id
1733: ,sysdate
1734: ,p_SECURITY_GROUP_ID
1735: ) ;
1736: