APPS.PQH_TEMPLATES_API dependencies on PQH_TEMPLATES

Line 1: Package Body pqh_TEMPLATES_api as

1: Package Body pqh_TEMPLATES_api as
2: /* $Header: pqtemapi.pkb 115.11 2002/12/03 20:43:42 rpasapul noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqtemapi.pkb 115.11 2002/12/03 20:43:42 rpasapul noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_TEMPLATES_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_GENERIC_TEMPLATE >----------------------|
10: -- ----------------------------------------------------------------------------

Line 32: l_template_id pqh_templates.template_id%TYPE;

28: ) is
29: --
30: -- Declare cursors and local variables
31: --
32: l_template_id pqh_templates.template_id%TYPE;
33: l_proc varchar2(72) := g_package||'create_GENERIC_TEMPLATE';
34: l_object_version_number pqh_templates.object_version_number%TYPE;
35: --
36: begin

Line 34: l_object_version_number pqh_templates.object_version_number%TYPE;

30: -- Declare cursors and local variables
31: --
32: l_template_id pqh_templates.template_id%TYPE;
33: l_proc varchar2(72) := g_package||'create_GENERIC_TEMPLATE';
34: l_object_version_number pqh_templates.object_version_number%TYPE;
35: --
36: begin
37: --
38: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 52: PQH_TEMPLATES_BK1.create_GENERIC_TEMPLATE_b

48: begin
49: --
50: -- Start of API User Hook for the before hook of create_GENERIC_TEMPLATE
51: --
52: PQH_TEMPLATES_BK1.create_GENERIC_TEMPLATE_b
53: (
54: p_template_name => p_template_name
55: ,p_short_name => p_short_name
56: ,p_attribute_only_flag => p_attribute_only_flag

Line 108: PQH_TEMPLATES_BK1.create_GENERIC_TEMPLATE_a

104: begin
105: --
106: -- Start of API User Hook for the after hook of create_GENERIC_TEMPLATE
107: --
108: PQH_TEMPLATES_BK1.create_GENERIC_TEMPLATE_a
109: (
110: p_template_name => p_template_name
111: ,p_short_name => p_short_name
112: ,p_template_id => l_template_id

Line 202: l_object_version_number pqh_templates.object_version_number%TYPE;

198: --
199: -- Declare cursors and local variables
200: --
201: l_proc varchar2(72) := g_package||'update_GENERIC_TEMPLATE';
202: l_object_version_number pqh_templates.object_version_number%TYPE;
203: --
204: begin
205: --
206: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 222: pqh_TEMPLATES_bk2.update_GENERIC_TEMPLATE_b

218: begin
219: --
220: -- Start of API User Hook for the before hook of update_GENERIC_TEMPLATE
221: --
222: pqh_TEMPLATES_bk2.update_GENERIC_TEMPLATE_b
223: (
224: p_template_name => p_template_name
225: ,p_short_name => p_short_name
226: ,p_template_id => p_template_id

Line 277: pqh_TEMPLATES_bk2.update_GENERIC_TEMPLATE_a

273: begin
274: --
275: -- Start of API User Hook for the after hook of update_GENERIC_TEMPLATE
276: --
277: pqh_TEMPLATES_bk2.update_GENERIC_TEMPLATE_a
278: (
279: p_template_name => p_template_name
280: ,p_short_name => p_short_name
281: ,p_template_id => p_template_id

Line 356: l_object_version_number pqh_templates.object_version_number%TYPE;

352: --
353: -- Declare cursors and local variables
354: --
355: l_proc varchar2(72) := g_package||'delete_GENERIC_TEMPLATE';
356: l_object_version_number pqh_templates.object_version_number%TYPE;
357: --
358: begin
359: --
360: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 377: pqh_TEMPLATES_bk3.delete_GENERIC_TEMPLATE_b

373: begin
374: --
375: -- Start of API User Hook for the before hook of delete_GENERIC_TEMPLATE
376: --
377: pqh_TEMPLATES_bk3.delete_GENERIC_TEMPLATE_b
378: (
379: p_template_id => p_template_id
380: ,p_object_version_number => p_object_version_number
381: ,p_effective_date => trunc(p_effective_date)

Line 422: pqh_TEMPLATES_bk3.delete_GENERIC_TEMPLATE_a

418: begin
419: --
420: -- Start of API User Hook for the after hook of delete_GENERIC_TEMPLATE
421: --
422: pqh_TEMPLATES_bk3.delete_GENERIC_TEMPLATE_a
423: (
424: p_template_id => p_template_id
425: ,p_object_version_number => l_object_version_number
426: ,p_effective_date => trunc(p_effective_date)

Line 504: end pqh_TEMPLATES_api;

500: end lck;
501: --
502: **/
503: --
504: end pqh_TEMPLATES_api;