APPS.HZ_TAX_ASSIGNMENT_V2PUB dependencies on HZ_LOCATIONS

Line 175: FROM HZ_LOCATIONS WHERE LOCATION_ID = p_location_id;

171: ATTRIBUTE7,
172: ATTRIBUTE8,
173: ATTRIBUTE9,
174: ATTRIBUTE10
175: FROM HZ_LOCATIONS WHERE LOCATION_ID = p_location_id;
176:
177:
178: BEGIN
179:

Line 273: * additional updates to HZ_LOCATIONS.

269: * o Passed address1 to address4 to update_profile_pvt
270: * o Moved the call to update_location_pvt to outside
271: * the loop.
272: * o Updated the db_* variables to prevent unnecessary
273: * additional updates to HZ_LOCATIONS.
274: *
275: +===========================================================================**/
276: -- Removed following parameters since it id not used in the procedure
277: -- x_loc_id, p_created_by_module, p_application_id, x_org_id

Line 322: FROM HZ_LOCATIONS WHERE LOCATION_ID = p_location_id;

318: ATTRIBUTE7,
319: ATTRIBUTE8,
320: ATTRIBUTE9,
321: ATTRIBUTE10
322: FROM HZ_LOCATIONS WHERE LOCATION_ID = p_location_id;
323:
324: l_message_count NUMBER;
325: l_message_count_new NUMBER;
326: BEGIN

Line 342: FROM HZ_LOCATIONS

338:
339: BEGIN
340: SELECT DATE_VALIDATED, VALIDATION_STATUS_CODE
341: INTO l_date_validated, l_validation_status_code
342: FROM HZ_LOCATIONS
343: WHERE LOCATION_ID = p_location_id;
344: EXCEPTION
345: WHEN NO_DATA_FOUND THEN
346: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');

Line 347: FND_MESSAGE.SET_TOKEN('RECORD', 'hz_locations');

343: WHERE LOCATION_ID = p_location_id;
344: EXCEPTION
345: WHEN NO_DATA_FOUND THEN
346: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
347: FND_MESSAGE.SET_TOKEN('RECORD', 'hz_locations');
348: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_location_id));
349: FND_MSG_PUB.ADD;
350: x_return_status := FND_API.G_RET_STS_ERROR;
351: END;

Line 398: p_locTbl => 'HZ_LOCATIONS',

394: IF l_loc_assg_exists = 'Y' OR p_do_addr_val = 'Y' THEN
395:
396: HZ_GNR_PKG.delete_gnr(
397: p_locId => p_location_id,
398: p_locTbl => 'HZ_LOCATIONS',
399: x_status => x_return_status);
400:
401: HZ_GNR_PKG.validateLoc(
402: P_LOCATION_ID => l_c_loc.LOCATION_ID,

Line 434: p_location_table_name => 'HZ_LOCATIONS',

430: -- process_gnr will process the GNR and return success even if there is an error
431: -- in the validation.
432: l_message_count := fnd_msg_pub.count_msg();
433: HZ_GNR_PUB.process_gnr (
434: p_location_table_name => 'HZ_LOCATIONS',
435: p_location_id => p_location_id,
436: p_call_type => 'U',
437: p_init_msg_list => 'F',
438: x_return_status => x_return_status,