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

Line 1: Package Body pqh_TEMPLATE_ATTRIBUTES_api as

1: Package Body pqh_TEMPLATE_ATTRIBUTES_api as
2: /* $Header: pqtatapi.pkb 115.10 2002/12/06 23:48:33 rpasapul noship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' pqh_TEMPLATE_ATTRIBUTES_api.';

2: /* $Header: pqtatapi.pkb 115.10 2002/12/06 23:48:33 rpasapul noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_TEMPLATE_ATTRIBUTES_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: --|------------------------< create_TEMPLATE_ATTRIBUTE >----------------------|
10: -- ----------------------------------------------------------------------------

Line 26: l_template_attribute_id pqh_template_attributes.template_attribute_id%TYPE;

22: ) is
23: --
24: -- Declare cursors and local variables
25: --
26: l_template_attribute_id pqh_template_attributes.template_attribute_id%TYPE;
27: l_proc varchar2(72) := g_package||'create_TEMPLATE_ATTRIBUTE';
28: l_object_version_number pqh_template_attributes.object_version_number%TYPE;
29: --
30: begin

Line 28: l_object_version_number pqh_template_attributes.object_version_number%TYPE;

24: -- Declare cursors and local variables
25: --
26: l_template_attribute_id pqh_template_attributes.template_attribute_id%TYPE;
27: l_proc varchar2(72) := g_package||'create_TEMPLATE_ATTRIBUTE';
28: l_object_version_number pqh_template_attributes.object_version_number%TYPE;
29: --
30: begin
31: --
32: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 46: pqh_TEMPLATE_ATTRIBUTES_bk1.create_TEMPLATE_ATTRIBUTE_b

42: begin
43: --
44: -- Start of API User Hook for the before hook of create_TEMPLATE_ATTRIBUTE
45: --
46: pqh_TEMPLATE_ATTRIBUTES_bk1.create_TEMPLATE_ATTRIBUTE_b
47: (
48: p_required_flag => p_required_flag
49: ,p_view_flag => p_view_flag
50: ,p_edit_flag => p_edit_flag

Line 83: pqh_TEMPLATE_ATTRIBUTES_bk1.create_TEMPLATE_ATTRIBUTE_a

79: begin
80: --
81: -- Start of API User Hook for the after hook of create_TEMPLATE_ATTRIBUTE
82: --
83: pqh_TEMPLATE_ATTRIBUTES_bk1.create_TEMPLATE_ATTRIBUTE_a
84: (
85: p_required_flag => p_required_flag
86: ,p_view_flag => p_view_flag
87: ,p_edit_flag => p_edit_flag

Line 164: l_object_version_number pqh_template_attributes.object_version_number%TYPE;

160: --
161: -- Declare cursors and local variables
162: --
163: l_proc varchar2(72) := g_package||'update_TEMPLATE_ATTRIBUTE';
164: l_object_version_number pqh_template_attributes.object_version_number%TYPE;
165: --
166: begin
167: --
168: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 184: pqh_TEMPLATE_ATTRIBUTES_bk2.update_TEMPLATE_ATTRIBUTE_b

180: begin
181: --
182: -- Start of API User Hook for the before hook of update_TEMPLATE_ATTRIBUTE
183: --
184: pqh_TEMPLATE_ATTRIBUTES_bk2.update_TEMPLATE_ATTRIBUTE_b
185: (
186: p_required_flag => p_required_flag
187: ,p_view_flag => p_view_flag
188: ,p_edit_flag => p_edit_flag

Line 222: pqh_TEMPLATE_ATTRIBUTES_bk2.update_TEMPLATE_ATTRIBUTE_a

218: begin
219: --
220: -- Start of API User Hook for the after hook of update_TEMPLATE_ATTRIBUTE
221: --
222: pqh_TEMPLATE_ATTRIBUTES_bk2.update_TEMPLATE_ATTRIBUTE_a
223: (
224: p_required_flag => p_required_flag
225: ,p_view_flag => p_view_flag
226: ,p_edit_flag => p_edit_flag

Line 295: l_object_version_number pqh_template_attributes.object_version_number%TYPE;

291: --
292: -- Declare cursors and local variables
293: --
294: l_proc varchar2(72) := g_package||'delete_TEMPLATE_ATTRIBUTE';
295: l_object_version_number pqh_template_attributes.object_version_number%TYPE;
296: --
297: begin
298: --
299: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 316: pqh_TEMPLATE_ATTRIBUTES_bk3.delete_TEMPLATE_ATTRIBUTE_b

312: begin
313: --
314: -- Start of API User Hook for the before hook of delete_TEMPLATE_ATTRIBUTE
315: --
316: pqh_TEMPLATE_ATTRIBUTES_bk3.delete_TEMPLATE_ATTRIBUTE_b
317: (
318: p_template_attribute_id => p_template_attribute_id
319: ,p_object_version_number => p_object_version_number
320: ,p_effective_date => trunc(p_effective_date)

Line 344: pqh_TEMPLATE_ATTRIBUTES_bk3.delete_TEMPLATE_ATTRIBUTE_a

340: begin
341: --
342: -- Start of API User Hook for the after hook of delete_TEMPLATE_ATTRIBUTE
343: --
344: pqh_TEMPLATE_ATTRIBUTES_bk3.delete_TEMPLATE_ATTRIBUTE_a
345: (
346: p_template_attribute_id => p_template_attribute_id
347: ,p_object_version_number => l_object_version_number
348: ,p_effective_date => trunc(p_effective_date)

Line 436: From pqh_template_attributes

432: ) is
433: --
434: Cursor csr_tem_attr(p_attribute_id in number) is
435: Select template_attribute_id,object_version_number
436: From pqh_template_attributes
437: Where template_id = p_template_id
438: and attribute_id = p_attribute_id
439: FOR UPDATE ;
440: --

Line 451: l_template_attribute_id pqh_template_attributes.template_attribute_id%type;

447: and tem.template_id = p_template_id
448: and tct.transaction_category_id = tem.transaction_category_id
449: and nvl(tct.select_flag,'N')='Y';
450: --
451: l_template_attribute_id pqh_template_attributes.template_attribute_id%type;
452: l_ovn pqh_template_attributes.object_version_number%type;
453: l_view_flag pqh_template_attributes.view_flag%type;
454: l_edit_flag pqh_template_attributes.edit_flag%type;
455: --

Line 452: l_ovn pqh_template_attributes.object_version_number%type;

448: and tct.transaction_category_id = tem.transaction_category_id
449: and nvl(tct.select_flag,'N')='Y';
450: --
451: l_template_attribute_id pqh_template_attributes.template_attribute_id%type;
452: l_ovn pqh_template_attributes.object_version_number%type;
453: l_view_flag pqh_template_attributes.view_flag%type;
454: l_edit_flag pqh_template_attributes.edit_flag%type;
455: --
456: l_dummy varchar2(30);

Line 453: l_view_flag pqh_template_attributes.view_flag%type;

449: and nvl(tct.select_flag,'N')='Y';
450: --
451: l_template_attribute_id pqh_template_attributes.template_attribute_id%type;
452: l_ovn pqh_template_attributes.object_version_number%type;
453: l_view_flag pqh_template_attributes.view_flag%type;
454: l_edit_flag pqh_template_attributes.edit_flag%type;
455: --
456: l_dummy varchar2(30);
457: --

Line 454: l_edit_flag pqh_template_attributes.edit_flag%type;

450: --
451: l_template_attribute_id pqh_template_attributes.template_attribute_id%type;
452: l_ovn pqh_template_attributes.object_version_number%type;
453: l_view_flag pqh_template_attributes.view_flag%type;
454: l_edit_flag pqh_template_attributes.edit_flag%type;
455: --
456: l_dummy varchar2(30);
457: --
458: l_proc varchar2(72) := g_package||'create_update_copied_attribute';

Line 487: pqh_TEMPLATE_ATTRIBUTES_api.update_TEMPLATE_ATTRIBUTE

483: Fetch csr_tem_attr into l_template_attribute_id,l_ovn;
484: --
485: If csr_tem_attr%found then
486: --
487: pqh_TEMPLATE_ATTRIBUTES_api.update_TEMPLATE_ATTRIBUTE
488: (p_validate => false
489: ,p_required_flag => p_copied_attributes(cnt).reqd_flag
490: ,p_view_flag => l_view_flag
491: ,p_edit_flag => l_edit_flag

Line 500: pqh_TEMPLATE_ATTRIBUTES_api.create_TEMPLATE_ATTRIBUTE

496: ,p_effective_date => sysdate);
497: --
498: Else
499: --
500: pqh_TEMPLATE_ATTRIBUTES_api.create_TEMPLATE_ATTRIBUTE
501: (p_validate => false
502: ,p_required_flag => p_copied_attributes(cnt).reqd_flag
503: ,p_view_flag => l_view_flag
504: ,p_edit_flag => l_edit_flag

Line 526: end pqh_TEMPLATE_ATTRIBUTES_api;

522: --
523: end create_update_copied_attribute;
524: --
525: --
526: end pqh_TEMPLATE_ATTRIBUTES_api;