APPS.PQH_TAT_BUS dependencies on PQH_ATTRIBUTES

Line 190: l_enable_flag pqh_attributes.enable_flag%type;

186: p_object_version_number in number) is
187: --
188: l_api_updating boolean;
189: l_dummy varchar2(1);
190: l_enable_flag pqh_attributes.enable_flag%type;
191: l_attribute_name pqh_attributes_vl.attribute_name%type;
192: --
193: cursor c1 is
194: select nvl(enable_flag,'N')

Line 191: l_attribute_name pqh_attributes_vl.attribute_name%type;

187: --
188: l_api_updating boolean;
189: l_dummy varchar2(1);
190: l_enable_flag pqh_attributes.enable_flag%type;
191: l_attribute_name pqh_attributes_vl.attribute_name%type;
192: --
193: cursor c1 is
194: select nvl(enable_flag,'N')
195: from pqh_attributes a

Line 195: from pqh_attributes a

191: l_attribute_name pqh_attributes_vl.attribute_name%type;
192: --
193: cursor c1 is
194: select nvl(enable_flag,'N')
195: from pqh_attributes a
196: where a.attribute_id = p_attribute_id;
197: --
198: Cursor c2 is
199: select att.attribute_name

Line 200: from pqh_attributes_vl att,pqh_template_attributes tat

196: where a.attribute_id = p_attribute_id;
197: --
198: Cursor c2 is
199: select att.attribute_name
200: from pqh_attributes_vl att,pqh_template_attributes tat
201: where tat.attribute_id = p_attribute_id
202: and tat.template_id = p_template_id
203: and tat.attribute_id = att.attribute_id;
204: --

Line 220: -- check if attribute_id value exists in pqh_attributes table

216: and nvl(p_attribute_id,hr_api.g_number)
217: <> nvl(pqh_tat_shd.g_old_rec.attribute_id,hr_api.g_number)
218: or not l_api_updating) then
219: --
220: -- check if attribute_id value exists in pqh_attributes table
221: --
222: open c1;
223: --
224: fetch c1 into l_enable_flag;

Line 229: -- raise error as FK does not relate to PK in pqh_attributes

225: if c1%notfound then
226: --
227: close c1;
228: --
229: -- raise error as FK does not relate to PK in pqh_attributes
230: -- table.
231: --
232: pqh_tat_shd.constraint_error('PQH_TEMPLATE_ATTRIBUTES_FK1');
233: --

Line 314: from pqh_attributes att , pqh_txn_category_attributes tca

310: where a.template_id = p_template_id;
311: --
312: cursor c2 is
313: select nvl(tca.select_flag,'N')
314: from pqh_attributes att , pqh_txn_category_attributes tca
315: where att.attribute_id = p_attribute_id
316: AND att.attribute_id = tca.attribute_id
317: AND tca.transaction_category_id = l_tem_tct;
318: Begin

Line 384: from pqh_attributes_vl

380: where template_id = p_template_id;
381: --
382: cursor c_attribute_leg_code is
383: select legislation_code, attribute_name
384: from pqh_attributes_vl
385: where attribute_id = p_attribute_id;
386: --
387: Begin
388: --

Line 862: p_attribute_id in pqh_attributes.attribute_id%type,

858: --
859: --
860: --
861: Procedure fetch_attribute_name(
862: p_attribute_id in pqh_attributes.attribute_id%type,
863: p_attribute_name out nocopy pqh_attributes.attribute_name%type) is
864: --
865: Cursor csr_attr_name is
866: Select attribute_name

Line 863: p_attribute_name out nocopy pqh_attributes.attribute_name%type) is

859: --
860: --
861: Procedure fetch_attribute_name(
862: p_attribute_id in pqh_attributes.attribute_id%type,
863: p_attribute_name out nocopy pqh_attributes.attribute_name%type) is
864: --
865: Cursor csr_attr_name is
866: Select attribute_name
867: From pqh_attributes

Line 867: From pqh_attributes

863: p_attribute_name out nocopy pqh_attributes.attribute_name%type) is
864: --
865: Cursor csr_attr_name is
866: Select attribute_name
867: From pqh_attributes
868: Where attribute_id = p_attribute_id;
869: --
870: l_proc varchar2(72) := g_package||'fetch_attribute_name';
871: --

Line 896: l_attribute_name pqh_attributes.attribute_name%type;

892: Procedure populate_attribute_name(
893: p_attr_table in pqh_prvcalc.t_attid_priv,
894: p_attr_name_table out nocopy pqh_prvcalc.t_attname_priv) is
895: --
896: l_attribute_name pqh_attributes.attribute_name%type;
897: l_mode_flag pqh_template_attributes.view_flag%type;
898: l_reqd_flag pqh_template_attributes.required_flag%type;
899: --
900: l_proc varchar2(72) := g_package||'populate_attribute_name';