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_RFT_BUS dependencies on PQH_TEMPLATES

Line 109: l_enable_flag pqh_templates.enable_flag%type;

105: --
106: l_proc varchar2(72) := g_package||'chk_base_template_id';
107: l_api_updating boolean;
108: l_dummy varchar2(1);
109: l_enable_flag pqh_templates.enable_flag%type;
110: l_attribute_only_flag pqh_templates.attribute_only_flag%type;
111: l_freeze_status_cd pqh_templates.freeze_status_cd%type;
112: --
113: cursor c1 is

Line 110: l_attribute_only_flag pqh_templates.attribute_only_flag%type;

106: l_proc varchar2(72) := g_package||'chk_base_template_id';
107: l_api_updating boolean;
108: l_dummy varchar2(1);
109: l_enable_flag pqh_templates.enable_flag%type;
110: l_attribute_only_flag pqh_templates.attribute_only_flag%type;
111: l_freeze_status_cd pqh_templates.freeze_status_cd%type;
112: --
113: cursor c1 is
114: select nvl(enable_flag,hr_api.g_varchar2),

Line 111: l_freeze_status_cd pqh_templates.freeze_status_cd%type;

107: l_api_updating boolean;
108: l_dummy varchar2(1);
109: l_enable_flag pqh_templates.enable_flag%type;
110: l_attribute_only_flag pqh_templates.attribute_only_flag%type;
111: l_freeze_status_cd pqh_templates.freeze_status_cd%type;
112: --
113: cursor c1 is
114: select nvl(enable_flag,hr_api.g_varchar2),
115: nvl(attribute_only_flag,hr_api.g_varchar2),

Line 117: from pqh_templates a

113: cursor c1 is
114: select nvl(enable_flag,hr_api.g_varchar2),
115: nvl(attribute_only_flag,hr_api.g_varchar2),
116: nvl(freeze_status_cd ,hr_api.g_varchar2)
117: from pqh_templates a
118: where a.template_id = p_base_template_id;
119: --
120: Begin
121: --

Line 134: -- check if base_template_id value exists in pqh_templates table

130: <> nvl(pqh_rft_shd.g_old_rec.base_template_id,hr_api.g_number)
131: or not l_api_updating) then
132:
133: --
134: -- check if base_template_id value exists in pqh_templates table
135: --
136: open c1;
137: --
138: fetch c1 into l_enable_flag,l_attribute_only_flag,l_freeze_status_cd;

Line 144: -- raise error as FK does not relate to PK in pqh_templates

140: if c1%notfound then
141: --
142: close c1;
143: --
144: -- raise error as FK does not relate to PK in pqh_templates
145: -- table.
146: --
147: pqh_rft_shd.constraint_error('PQH_REF_TEMPLATES_FK2');
148: --

Line 211: l_freeze_status_cd pqh_templates.freeze_status_cd%type;

207: --
208: l_proc varchar2(72) := g_package||'chk_parent_template_id';
209: l_api_updating boolean;
210: l_dummy varchar2(1);
211: l_freeze_status_cd pqh_templates.freeze_status_cd%type;
212: l_attribute_only_flag pqh_templates.attribute_only_flag%type;
213: --
214: cursor c1 is
215: select nvl(freeze_status_cd,hr_api.g_varchar2) ,

Line 212: l_attribute_only_flag pqh_templates.attribute_only_flag%type;

208: l_proc varchar2(72) := g_package||'chk_parent_template_id';
209: l_api_updating boolean;
210: l_dummy varchar2(1);
211: l_freeze_status_cd pqh_templates.freeze_status_cd%type;
212: l_attribute_only_flag pqh_templates.attribute_only_flag%type;
213: --
214: cursor c1 is
215: select nvl(freeze_status_cd,hr_api.g_varchar2) ,
216: nvl(attribute_only_flag,hr_api.g_varchar2)

Line 217: from pqh_templates a

213: --
214: cursor c1 is
215: select nvl(freeze_status_cd,hr_api.g_varchar2) ,
216: nvl(attribute_only_flag,hr_api.g_varchar2)
217: from pqh_templates a
218: where a.template_id = p_parent_template_id;
219: --
220: Begin
221: --

Line 234: -- check if parent_template_id value exists in pqh_templates table

230: <> nvl(pqh_rft_shd.g_old_rec.parent_template_id,hr_api.g_number)
231: or not l_api_updating) and
232: p_parent_template_id is not null then
233: --
234: -- check if parent_template_id value exists in pqh_templates table
235: --
236: open c1;
237: --
238: fetch c1 into l_freeze_status_cd,l_attribute_only_flag;

Line 243: -- raise error as FK does not relate to PK in pqh_templates

239: if c1%notfound then
240: --
241: close c1;
242: --
243: -- raise error as FK does not relate to PK in pqh_templates
244: -- table.
245: --
246: pqh_rft_shd.constraint_error('PQH_REF_TEMPLATES_FK1');
247: --

Line 288: from pqh_templates_vl

284: l_parent_template_name varchar2(100);
285: --
286: cursor c1(p_template_id number) is
287: select legislation_code, template_name
288: from pqh_templates_vl
289: where template_id = p_template_id;
290: --
291: Begin
292: --

Line 437: l_parent_tct pqh_templates.transaction_category_id%type;

433: --
434: l_proc varchar2(72) := g_package||'chk_rft_tct';
435: l_api_updating boolean;
436: l_dummy varchar2(1);
437: l_parent_tct pqh_templates.transaction_category_id%type;
438: l_base_tct pqh_templates.transaction_category_id%type;
439: --
440: cursor c1 is
441: select transaction_category_id

Line 438: l_base_tct pqh_templates.transaction_category_id%type;

434: l_proc varchar2(72) := g_package||'chk_rft_tct';
435: l_api_updating boolean;
436: l_dummy varchar2(1);
437: l_parent_tct pqh_templates.transaction_category_id%type;
438: l_base_tct pqh_templates.transaction_category_id%type;
439: --
440: cursor c1 is
441: select transaction_category_id
442: from pqh_templates a

Line 442: from pqh_templates a

438: l_base_tct pqh_templates.transaction_category_id%type;
439: --
440: cursor c1 is
441: select transaction_category_id
442: from pqh_templates a
443: where a.template_id = p_parent_template_id;
444:
445: cursor c2 is
446: select transaction_category_id

Line 447: from pqh_templates a

443: where a.template_id = p_parent_template_id;
444:
445: cursor c2 is
446: select transaction_category_id
447: from pqh_templates a
448: where a.template_id = p_base_template_id;
449: Begin
450: --
451: hr_utility.set_location('Entering:'||l_proc,5);