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_SHD dependencies on PQH_TEMPLATE_ATTRIBUTES

Line 243: From pqh_template_attributes

239: p_owner in varchar2 default null) is
240: --
241: Cursor csr_tem_attr(p_attribute_id in number) is
242: Select template_attribute_id,object_version_number
243: From pqh_template_attributes
244: Where template_id = p_template_id
245: and attribute_id = p_attribute_id
246: FOR UPDATE ;
247: --

Line 258: l_template_attribute_id pqh_template_attributes.template_attribute_id%type;

254: and tem.template_id = p_template_id
255: and tct.transaction_category_id = tem.transaction_category_id
256: and nvl(tct.select_flag,'N')='Y';
257: --
258: l_template_attribute_id pqh_template_attributes.template_attribute_id%type;
259: l_ovn pqh_template_attributes.object_version_number%type;
260: l_view_flag pqh_template_attributes.view_flag%type;
261: l_edit_flag pqh_template_attributes.edit_flag%type;
262: --

Line 259: l_ovn pqh_template_attributes.object_version_number%type;

255: and tct.transaction_category_id = tem.transaction_category_id
256: and nvl(tct.select_flag,'N')='Y';
257: --
258: l_template_attribute_id pqh_template_attributes.template_attribute_id%type;
259: l_ovn pqh_template_attributes.object_version_number%type;
260: l_view_flag pqh_template_attributes.view_flag%type;
261: l_edit_flag pqh_template_attributes.edit_flag%type;
262: --
263: l_dummy varchar2(30);

Line 260: l_view_flag pqh_template_attributes.view_flag%type;

256: and nvl(tct.select_flag,'N')='Y';
257: --
258: l_template_attribute_id pqh_template_attributes.template_attribute_id%type;
259: l_ovn pqh_template_attributes.object_version_number%type;
260: l_view_flag pqh_template_attributes.view_flag%type;
261: l_edit_flag pqh_template_attributes.edit_flag%type;
262: --
263: l_dummy varchar2(30);
264: --

Line 261: l_edit_flag pqh_template_attributes.edit_flag%type;

257: --
258: l_template_attribute_id pqh_template_attributes.template_attribute_id%type;
259: l_ovn pqh_template_attributes.object_version_number%type;
260: l_view_flag pqh_template_attributes.view_flag%type;
261: l_edit_flag pqh_template_attributes.edit_flag%type;
262: --
263: l_dummy varchar2(30);
264: --
265: l_proc varchar2(72) := g_package||'create_update_copied_attribute';

Line 268: l_created_by pqh_template_attributes.created_by%TYPE;

264: --
265: l_proc varchar2(72) := g_package||'create_update_copied_attribute';
266: --
267: --
268: l_created_by pqh_template_attributes.created_by%TYPE;
269: l_last_updated_by pqh_template_attributes.last_updated_by%TYPE;
270: l_creation_date pqh_template_attributes.creation_date%TYPE;
271: l_last_update_date pqh_template_attributes.last_update_date%TYPE;
272: l_last_update_login pqh_template_attributes.last_update_login%TYPE;

Line 269: l_last_updated_by pqh_template_attributes.last_updated_by%TYPE;

265: l_proc varchar2(72) := g_package||'create_update_copied_attribute';
266: --
267: --
268: l_created_by pqh_template_attributes.created_by%TYPE;
269: l_last_updated_by pqh_template_attributes.last_updated_by%TYPE;
270: l_creation_date pqh_template_attributes.creation_date%TYPE;
271: l_last_update_date pqh_template_attributes.last_update_date%TYPE;
272: l_last_update_login pqh_template_attributes.last_update_login%TYPE;
273: --

Line 270: l_creation_date pqh_template_attributes.creation_date%TYPE;

266: --
267: --
268: l_created_by pqh_template_attributes.created_by%TYPE;
269: l_last_updated_by pqh_template_attributes.last_updated_by%TYPE;
270: l_creation_date pqh_template_attributes.creation_date%TYPE;
271: l_last_update_date pqh_template_attributes.last_update_date%TYPE;
272: l_last_update_login pqh_template_attributes.last_update_login%TYPE;
273: --
274: begin

Line 271: l_last_update_date pqh_template_attributes.last_update_date%TYPE;

267: --
268: l_created_by pqh_template_attributes.created_by%TYPE;
269: l_last_updated_by pqh_template_attributes.last_updated_by%TYPE;
270: l_creation_date pqh_template_attributes.creation_date%TYPE;
271: l_last_update_date pqh_template_attributes.last_update_date%TYPE;
272: l_last_update_login pqh_template_attributes.last_update_login%TYPE;
273: --
274: begin
275: --

Line 272: l_last_update_login pqh_template_attributes.last_update_login%TYPE;

268: l_created_by pqh_template_attributes.created_by%TYPE;
269: l_last_updated_by pqh_template_attributes.last_updated_by%TYPE;
270: l_creation_date pqh_template_attributes.creation_date%TYPE;
271: l_last_update_date pqh_template_attributes.last_update_date%TYPE;
272: l_last_update_login pqh_template_attributes.last_update_login%TYPE;
273: --
274: begin
275: --
276: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 317: update pqh_template_attributes

313: Fetch csr_tem_attr into l_template_attribute_id,l_ovn;
314: --
315: If csr_tem_attr%found then
316: --
317: update pqh_template_attributes
318: set
319: required_flag = p_copied_attributes(cnt).reqd_flag
320: ,view_flag = l_view_flag
321: ,edit_flag = l_edit_flag

Line 334: p_entity_name=>'PQH_TEMPLATE_ATTRIBUTES',

330: -- Added the following code as a part of Zero Downtime Patching Project.
331: -- Code Starts Here.
332: --
333: PER_RIC_PKG.chk_integrity(
334: p_entity_name=>'PQH_TEMPLATE_ATTRIBUTES',
335: p_ref_entity_info=>
336: PER_RIC_PKG.ref_entity_tbl(
337: PER_RIC_PKG.ref_info_rec('PQH_ATTRIBUTES',PER_RIC_PKG.column_info_tbl(
338: PER_RIC_PKG.col_info_rec('ATTRIBUTE_ID',NULL,p_copied_attributes(cnt).attribute_id, NULL))),

Line 346: insert into pqh_template_attributes

342: --
343: -- Code Ends Here
344: --
345:
346: insert into pqh_template_attributes
347: (
348: required_flag
349: ,view_flag
350: ,edit_flag

Line 363: ,pqh_template_attributes_s.nextval

359: (
360: p_copied_attributes(cnt).reqd_flag
361: ,l_view_flag
362: ,l_edit_flag
363: ,pqh_template_attributes_s.nextval
364: ,p_copied_attributes(cnt).attribute_id
365: ,p_template_id
366: ,1
367: ,L_LAST_UPDATE_DATE, L_LAST_UPDATED_BY,