APPS.PQH_ATL_UPD dependencies on PQH_ATTRIBUTES

Line 56: -- Update the pqh_attributes_tl Row

52: Begin
53: hr_utility.set_location('Entering:'||l_proc, 5);
54: --
55: --
56: -- Update the pqh_attributes_tl Row
57: --
58: update pqh_attributes_tl
59: set
60: attribute_id = p_rec.attribute_id,

Line 58: update pqh_attributes_tl

54: --
55: --
56: -- Update the pqh_attributes_tl Row
57: --
58: update pqh_attributes_tl
59: set
60: attribute_id = p_rec.attribute_id,
61: attribute_name = p_rec.attribute_name,
62: language = p_rec.language,

Line 189: (p_module_name => 'pqh_attributes_tl'

185: --
186: when hr_api.cannot_find_prog_unit then
187: --
188: hr_api.cannot_find_prog_unit_error
189: (p_module_name => 'pqh_attributes_tl'
190: ,p_hook_type => 'AU');
191: --
192: end;
193: --

Line 361: from pqh_attributes_tl atl

357: p_attribute_name in varchar2 ) is
358: --
359: cursor csr_upd_langs is
360: select atl.language
361: from pqh_attributes_tl atl
362: where atl.attribute_id = p_attribute_id
363: AND p_language_code in (atl.language,atl.source_lang);
364: --
365: l_proc varchar2(72) := g_package||'upd_tl';

Line 399: from pqh_attributes

395:
396: --
397: cursor csr_attribute_id(p_column_name IN VARCHAR2, p_table_id IN NUMBER, p_legislation_code in varchar2) is
398: select attribute_id
399: from pqh_attributes
400: where key_column_name = p_att_col_name
401: and nvl(legislation_code,'$$$') = nvl(p_legislation_code,'$$$')
402: and nvl(master_table_route_id,-1) = nvl(p_table_id, -1);
403: --

Line 446: update pqh_attributes_tl

442: X_LAST_UPDATE_DATE := sysdate;
443: X_LAST_UPDATE_LOGIN := 0;
444: X_LAST_UPDATED_BY := fnd_load_util.owner_id(p_owner);
445:
446: update pqh_attributes_tl
447: set attribute_name = p_attribute_name ,
448: last_update_date = X_LAST_UPDATE_DATE,
449: last_updated_by = X_LAST_UPDATED_BY,
450: last_update_login = X_LAST_UPDATE_LOGIN,