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 329: insert into pqh_template_attributes

325: where template_attribute_id = l_template_attribute_id;
326: --
327: Else
328: --
329: insert into pqh_template_attributes
330: (
331: required_flag
332: ,view_flag
333: ,edit_flag

Line 346: ,pqh_template_attributes_s.nextval

342: (
343: p_copied_attributes(cnt).reqd_flag
344: ,l_view_flag
345: ,l_edit_flag
346: ,pqh_template_attributes_s.nextval
347: ,p_copied_attributes(cnt).attribute_id
348: ,p_template_id
349: ,1
350: ,L_LAST_UPDATE_DATE, L_LAST_UPDATED_BY,