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_REF_TEMPLATES_API dependencies on PQH_REF_TEMPLATES

Line 1: Package Body pqh_REF_TEMPLATES_api as

1: Package Body pqh_REF_TEMPLATES_api as
2: /* $Header: pqrftapi.pkb 115.5 2002/12/06 18:07:37 rpasapul noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqrftapi.pkb 115.5 2002/12/06 18:07:37 rpasapul noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_REF_TEMPLATES_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_REF_TEMPLATE >----------------------|
10: -- ----------------------------------------------------------------------------

Line 24: l_ref_template_id pqh_ref_templates.ref_template_id%TYPE;

20: ) is
21: --
22: -- Declare cursors and local variables
23: --
24: l_ref_template_id pqh_ref_templates.ref_template_id%TYPE;
25: l_proc varchar2(72) := g_package||'create_REF_TEMPLATE';
26: l_object_version_number pqh_ref_templates.object_version_number%TYPE;
27: --
28: begin

Line 26: l_object_version_number pqh_ref_templates.object_version_number%TYPE;

22: -- Declare cursors and local variables
23: --
24: l_ref_template_id pqh_ref_templates.ref_template_id%TYPE;
25: l_proc varchar2(72) := g_package||'create_REF_TEMPLATE';
26: l_object_version_number pqh_ref_templates.object_version_number%TYPE;
27: --
28: begin
29: --
30: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 44: pqh_REF_TEMPLATES_bk1.create_REF_TEMPLATE_b

40: begin
41: --
42: -- Start of API User Hook for the before hook of create_REF_TEMPLATE
43: --
44: pqh_REF_TEMPLATES_bk1.create_REF_TEMPLATE_b
45: (
46: p_base_template_id => p_base_template_id
47: ,p_parent_template_id => p_parent_template_id
48: ,p_reference_type_cd => p_reference_type_cd

Line 77: pqh_REF_TEMPLATES_bk1.create_REF_TEMPLATE_a

73: begin
74: --
75: -- Start of API User Hook for the after hook of create_REF_TEMPLATE
76: --
77: pqh_REF_TEMPLATES_bk1.create_REF_TEMPLATE_a
78: (
79: p_ref_template_id => l_ref_template_id
80: ,p_base_template_id => p_base_template_id
81: ,p_parent_template_id => p_parent_template_id

Line 156: l_object_version_number pqh_ref_templates.object_version_number%TYPE;

152: --
153: -- Declare cursors and local variables
154: --
155: l_proc varchar2(72) := g_package||'update_REF_TEMPLATE';
156: l_object_version_number pqh_ref_templates.object_version_number%TYPE;
157: --
158: begin
159: --
160: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 176: pqh_REF_TEMPLATES_bk2.update_REF_TEMPLATE_b

172: begin
173: --
174: -- Start of API User Hook for the before hook of update_REF_TEMPLATE
175: --
176: pqh_REF_TEMPLATES_bk2.update_REF_TEMPLATE_b
177: (
178: p_ref_template_id => p_ref_template_id
179: ,p_base_template_id => p_base_template_id
180: ,p_parent_template_id => p_parent_template_id

Line 212: pqh_REF_TEMPLATES_bk2.update_REF_TEMPLATE_a

208: begin
209: --
210: -- Start of API User Hook for the after hook of update_REF_TEMPLATE
211: --
212: pqh_REF_TEMPLATES_bk2.update_REF_TEMPLATE_a
213: (
214: p_ref_template_id => p_ref_template_id
215: ,p_base_template_id => p_base_template_id
216: ,p_parent_template_id => p_parent_template_id

Line 285: l_object_version_number pqh_ref_templates.object_version_number%TYPE;

281: --
282: -- Declare cursors and local variables
283: --
284: l_proc varchar2(72) := g_package||'delete_REF_TEMPLATE';
285: l_object_version_number pqh_ref_templates.object_version_number%TYPE;
286: --
287: begin
288: --
289: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 306: pqh_REF_TEMPLATES_bk3.delete_REF_TEMPLATE_b

302: begin
303: --
304: -- Start of API User Hook for the before hook of delete_REF_TEMPLATE
305: --
306: pqh_REF_TEMPLATES_bk3.delete_REF_TEMPLATE_b
307: (
308: p_ref_template_id => p_ref_template_id
309: ,p_object_version_number => p_object_version_number
310: ,p_effective_date => trunc(p_effective_date)

Line 336: pqh_REF_TEMPLATES_bk3.delete_REF_TEMPLATE_a

332: begin
333: --
334: -- Start of API User Hook for the after hook of delete_REF_TEMPLATE
335: --
336: pqh_REF_TEMPLATES_bk3.delete_REF_TEMPLATE_a
337: (
338: p_ref_template_id => p_ref_template_id
339: ,p_object_version_number => l_object_version_number
340: ,p_effective_date => trunc(p_effective_date)

Line 416: end pqh_REF_TEMPLATES_api;

412: hr_utility.set_location(' Leaving:'||l_proc, 70);
413: --
414: end lck;
415: --
416: end pqh_REF_TEMPLATES_api;