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 1575: last_updated_by = fnd_global.user_id,

1571: IF (l_region_detail_tab(1).Exception_Type = 'N') THEN
1572:
1573: UPDATE wsh_region_locations
1574: SET exception_type = 'Y',
1575: last_updated_by = fnd_global.user_id,
1576: last_update_date = sysdate,
1577: last_update_login = fnd_global.login_id
1578: where location_id = p_location_id;
1579: END IF;

Line 1577: last_update_login = fnd_global.login_id

1573: UPDATE wsh_region_locations
1574: SET exception_type = 'Y',
1575: last_updated_by = fnd_global.user_id,
1576: last_update_date = sysdate,
1577: last_update_login = fnd_global.login_id
1578: where location_id = p_location_id;
1579: END IF;
1580: --
1581: ELSE

Line 1710: last_updated_by = fnd_global.user_id,

1706: UPDATE wsh_region_locations
1707: SET region_id = l_region_table(i).region_id,
1708: exception_type = 'N',
1709: parent_region_flag = l_parent_region,
1710: last_updated_by = fnd_global.user_id,
1711: last_update_date = sysdate,
1712: last_update_login = fnd_global.login_id
1713: WHERE location_id = p_location_id
1714: AND region_type = l_region_table(i).region_type;

Line 1712: last_update_login = fnd_global.login_id

1708: exception_type = 'N',
1709: parent_region_flag = l_parent_region,
1710: last_updated_by = fnd_global.user_id,
1711: last_update_date = sysdate,
1712: last_update_login = fnd_global.login_id
1713: WHERE location_id = p_location_id
1714: AND region_type = l_region_table(i).region_type;
1715:
1716: END IF; --}

Line 1832: last_updated_by = FND_GLOBAL.user_id,

1828: UPDATE wsh_region_locations
1829: SET exception_type = 'Y',
1830: --Added for bug 5125837
1831: last_update_date = sysdate,
1832: last_updated_by = FND_GLOBAL.user_id,
1833: last_update_login = FND_GLOBAL.login_id
1834: WHERE location_id = p_location_id
1835: and region_id in (select wrt.region_id from wsh_regions_tl wrt,
1836: wsh_regions wr

Line 1833: last_update_login = FND_GLOBAL.login_id

1829: SET exception_type = 'Y',
1830: --Added for bug 5125837
1831: last_update_date = sysdate,
1832: last_updated_by = FND_GLOBAL.user_id,
1833: last_update_login = FND_GLOBAL.login_id
1834: WHERE location_id = p_location_id
1835: and region_id in (select wrt.region_id from wsh_regions_tl wrt,
1836: wsh_regions wr
1837: where wrt.region_id = wr.region_id

Line 1852: p_logging_entity_id => FND_GLOBAL.USER_ID,

1848: x_exception_id => l_dummy_exception_id ,
1849: p_logged_at_location_id => p_location_id,
1850: p_exception_location_id => p_location_id,
1851: p_logging_entity => 'SHIPPER',
1852: p_logging_entity_id => FND_GLOBAL.USER_ID,
1853: p_exception_name => 'WSH_LOCATION_REGIONS_2',
1854: p_message => 'WSH_LOCATION_REGIONS_2_ERR'
1855: );
1856: END IF;

Line 1889: p_logging_entity_id => FND_GLOBAL.USER_ID,

1885: x_exception_id => l_dummy_exception_id ,
1886: p_logged_at_location_id => p_location_id,
1887: p_exception_location_id => p_location_id,
1888: p_logging_entity => 'SHIPPER',
1889: p_logging_entity_id => FND_GLOBAL.USER_ID,
1890: p_exception_name => 'WSH_LOCATION_REGIONS_1',
1891: p_message => 'WSH_LOCATION_REGIONS_1_ERR'
1892: );
1893: END IF;

Line 1987: fnd_global.user_id,

1983: p_region_type,
1984: p_parent_region,
1985: p_location_source,
1986: sysdate,
1987: fnd_global.user_id,
1988: sysdate,
1989: fnd_global.user_id,
1990: fnd_global.login_id
1991: );

Line 1989: fnd_global.user_id,

1985: p_location_source,
1986: sysdate,
1987: fnd_global.user_id,
1988: sysdate,
1989: fnd_global.user_id,
1990: fnd_global.login_id
1991: );
1992:
1993: EXCEPTION

Line 1990: fnd_global.login_id

1986: sysdate,
1987: fnd_global.user_id,
1988: sysdate,
1989: fnd_global.user_id,
1990: fnd_global.login_id
1991: );
1992:
1993: EXCEPTION
1994:

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

2051: l_resp_id := p_event.getValueForParameter('RESP_ID');
2052: l_resp_appl_id := p_event.getValueForParameter('RESP_APPL_ID');
2053: l_security_group_id := p_event.getValueForParameter('SECURITY_GROUP_ID');
2054:
2055: fnd_global.apps_initialize(l_user_id,l_resp_id,l_resp_appl_id,l_security_group_id);
2056:
2057: --
2058: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2059: --