eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_TAT_BUS dependencies on PQH_TEMPLATE_ATTRIBUTES

Line 56: pqh_tat_shd.constraint_error('PQH_TEMPLATE_ATTRIBUTES_PK');

52: <> pqh_tat_shd.g_old_rec.template_attribute_id) then
53: --
54: -- raise error as PK has changed
55: --
56: pqh_tat_shd.constraint_error('PQH_TEMPLATE_ATTRIBUTES_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: pqh_tat_shd.constraint_error('PQH_TEMPLATE_ATTRIBUTES_PK');

62: if p_template_attribute_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: pqh_tat_shd.constraint_error('PQH_TEMPLATE_ATTRIBUTES_PK');
67: --
68: end if;
69: --
70: end if;

Line 141: pqh_tat_shd.constraint_error('PQH_TEMPLATE_ATTRIBUTES_FK2');

137: --
138: -- raise error as FK does not relate to PK in pqh_templates
139: -- table.
140: --
141: pqh_tat_shd.constraint_error('PQH_TEMPLATE_ATTRIBUTES_FK2');
142: --
143: end if;
144: --
145: close c1;

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 232: pqh_tat_shd.constraint_error('PQH_TEMPLATE_ATTRIBUTES_FK1');

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: --
234: end if;
235: --
236: close c1;

Line 897: l_mode_flag pqh_template_attributes.view_flag%type;

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';
901: --

Line 898: l_reqd_flag pqh_template_attributes.required_flag%type;

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';
901: --
902: Begin