DBA Data[Home] [Help]

APPS.HZ_GNR_PUB dependencies on HZ_LOCATIONS

Line 46: FROM HZ_LOCATIONS WHERE LOCATION_ID = p_location_id;

42: ATTRIBUTE7,
43: ATTRIBUTE8,
44: ATTRIBUTE9,
45: ATTRIBUTE10
46: FROM HZ_LOCATIONS WHERE LOCATION_ID = p_location_id;
47:
48: BEGIN
49: -- initializing the retun value
50: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 65: ELSIF upper(p_location_table_name) = 'HZ_LOCATIONS' THEN

61: HZ_GNR_PKG.validateHrLoc(
62: P_LOCATION_ID => p_location_id,
63: X_STATUS => l_return_status);
64:
65: ELSIF upper(p_location_table_name) = 'HZ_LOCATIONS' THEN
66:
67: IF p_call_type = 'U' THEN
68: HZ_GNR_PKG.delete_gnr(
69: p_locId => p_location_id,

Line 208: FROM HZ_LOCATIONS WHERE LOCATION_ID = p_location_id;

204: ATTRIBUTE7,
205: ATTRIBUTE8,
206: ATTRIBUTE9,
207: ATTRIBUTE10
208: FROM HZ_LOCATIONS WHERE LOCATION_ID = p_location_id;
209:
210: BEGIN
211:
212: -- Fix for Bug 5262208 (07-JUN-2006 Nishant). Added new parameter p_create_gnr_record