DBA Data[Home] [Help]

APPS.WSH_MAP_LOCATION_REGION_PKG dependencies on FND_GLOBAL

Line 507: fnd_global.user_id,

503: l_region_type_tab(i),
504: l_parent_region_tab(i),
505: l_location_source_tab(i),
506: sysdate,
507: fnd_global.user_id,
508: sysdate,
509: fnd_global.user_id,
510: fnd_global.login_id
511: );

Line 509: fnd_global.user_id,

505: l_location_source_tab(i),
506: sysdate,
507: fnd_global.user_id,
508: sysdate,
509: fnd_global.user_id,
510: fnd_global.login_id
511: );
512:
513:

Line 510: fnd_global.login_id

506: sysdate,
507: fnd_global.user_id,
508: sysdate,
509: fnd_global.user_id,
510: fnd_global.login_id
511: );
512:
513:
514: IF l_debug_on THEN

Line 659: p_logging_entity_id => FND_GLOBAL.USER_ID,

655: x_exception_id => l_dummy_exception_id ,
656: p_logged_at_location_id => l_upd_loc_id_tab(i),
657: p_exception_location_id => l_upd_loc_id_tab(i),
658: p_logging_entity => 'SHIPPER',
659: p_logging_entity_id => FND_GLOBAL.USER_ID,
660: p_exception_name => 'WSH_LOCATION_REGIONS_2',
661: p_message => 'WSH_LOCATION_REGIONS_2_ERR'
662: );
663: END IF;

Line 1559: last_updated_by = fnd_global.user_id,

1555: IF (l_region_detail_tab(1).Exception_Type = 'N') THEN
1556:
1557: UPDATE wsh_region_locations
1558: SET exception_type = 'Y',
1559: last_updated_by = fnd_global.user_id,
1560: last_update_date = sysdate,
1561: last_update_login = fnd_global.login_id
1562: where location_id = p_location_id;
1563: END IF;

Line 1561: last_update_login = fnd_global.login_id

1557: UPDATE wsh_region_locations
1558: SET exception_type = 'Y',
1559: last_updated_by = fnd_global.user_id,
1560: last_update_date = sysdate,
1561: last_update_login = fnd_global.login_id
1562: where location_id = p_location_id;
1563: END IF;
1564: --
1565: ELSE

Line 1694: last_updated_by = fnd_global.user_id,

1690: UPDATE wsh_region_locations
1691: SET region_id = l_region_table(i).region_id,
1692: exception_type = 'N',
1693: parent_region_flag = l_parent_region,
1694: last_updated_by = fnd_global.user_id,
1695: last_update_date = sysdate,
1696: last_update_login = fnd_global.login_id
1697: WHERE location_id = p_location_id
1698: AND region_type = l_region_table(i).region_type;

Line 1696: last_update_login = fnd_global.login_id

1692: exception_type = 'N',
1693: parent_region_flag = l_parent_region,
1694: last_updated_by = fnd_global.user_id,
1695: last_update_date = sysdate,
1696: last_update_login = fnd_global.login_id
1697: WHERE location_id = p_location_id
1698: AND region_type = l_region_table(i).region_type;
1699:
1700: END IF; --}

Line 1816: last_updated_by = FND_GLOBAL.user_id,

1812: UPDATE wsh_region_locations
1813: SET exception_type = 'Y',
1814: --Added for bug 5125837
1815: last_update_date = sysdate,
1816: last_updated_by = FND_GLOBAL.user_id,
1817: last_update_login = FND_GLOBAL.login_id
1818: WHERE location_id = p_location_id
1819: and region_id in (select wrt.region_id from wsh_regions_tl wrt,
1820: wsh_regions wr

Line 1817: last_update_login = FND_GLOBAL.login_id

1813: SET exception_type = 'Y',
1814: --Added for bug 5125837
1815: last_update_date = sysdate,
1816: last_updated_by = FND_GLOBAL.user_id,
1817: last_update_login = FND_GLOBAL.login_id
1818: WHERE location_id = p_location_id
1819: and region_id in (select wrt.region_id from wsh_regions_tl wrt,
1820: wsh_regions wr
1821: where wrt.region_id = wr.region_id

Line 1836: p_logging_entity_id => FND_GLOBAL.USER_ID,

1832: x_exception_id => l_dummy_exception_id ,
1833: p_logged_at_location_id => p_location_id,
1834: p_exception_location_id => p_location_id,
1835: p_logging_entity => 'SHIPPER',
1836: p_logging_entity_id => FND_GLOBAL.USER_ID,
1837: p_exception_name => 'WSH_LOCATION_REGIONS_2',
1838: p_message => 'WSH_LOCATION_REGIONS_2_ERR'
1839: );
1840: END IF;

Line 1873: p_logging_entity_id => FND_GLOBAL.USER_ID,

1869: x_exception_id => l_dummy_exception_id ,
1870: p_logged_at_location_id => p_location_id,
1871: p_exception_location_id => p_location_id,
1872: p_logging_entity => 'SHIPPER',
1873: p_logging_entity_id => FND_GLOBAL.USER_ID,
1874: p_exception_name => 'WSH_LOCATION_REGIONS_1',
1875: p_message => 'WSH_LOCATION_REGIONS_1_ERR'
1876: );
1877: END IF;

Line 1971: fnd_global.user_id,

1967: p_region_type,
1968: p_parent_region,
1969: p_location_source,
1970: sysdate,
1971: fnd_global.user_id,
1972: sysdate,
1973: fnd_global.user_id,
1974: fnd_global.login_id
1975: );

Line 1973: fnd_global.user_id,

1969: p_location_source,
1970: sysdate,
1971: fnd_global.user_id,
1972: sysdate,
1973: fnd_global.user_id,
1974: fnd_global.login_id
1975: );
1976:
1977: EXCEPTION

Line 1974: fnd_global.login_id

1970: sysdate,
1971: fnd_global.user_id,
1972: sysdate,
1973: fnd_global.user_id,
1974: fnd_global.login_id
1975: );
1976:
1977: EXCEPTION
1978:

Line 2039: fnd_global.apps_initialize(l_user_id,l_resp_id,l_resp_appl_id,l_security_group_id);

2035: l_resp_id := p_event.getValueForParameter('RESP_ID');
2036: l_resp_appl_id := p_event.getValueForParameter('RESP_APPL_ID');
2037: l_security_group_id := p_event.getValueForParameter('SECURITY_GROUP_ID');
2038:
2039: fnd_global.apps_initialize(l_user_id,l_resp_id,l_resp_appl_id,l_security_group_id);
2040:
2041: --
2042: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2043: --