APPS.PQH_ROLE_TEMPLATES_API dependencies on PQH_ROLE_TEMPLATES

Line 1: Package Body PQH_ROLE_TEMPLATES_api as

1: Package Body PQH_ROLE_TEMPLATES_api as
2: /* $Header: pqrtmapi.pkb 115.5 2002/12/06 23:48:09 rpasapul noship $ */
3: --
4: -- Package Variables
5: --

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

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

Line 25: l_role_template_id pqh_role_templates.role_template_id%TYPE;

21: ) is
22: --
23: -- Declare cursors and local variables
24: --
25: l_role_template_id pqh_role_templates.role_template_id%TYPE;
26: l_proc varchar2(72) := g_package||'create_role_template';
27: l_object_version_number pqh_role_templates.object_version_number%TYPE;
28: --
29: begin

Line 27: l_object_version_number pqh_role_templates.object_version_number%TYPE;

23: -- Declare cursors and local variables
24: --
25: l_role_template_id pqh_role_templates.role_template_id%TYPE;
26: l_proc varchar2(72) := g_package||'create_role_template';
27: l_object_version_number pqh_role_templates.object_version_number%TYPE;
28: --
29: begin
30: --
31: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 45: PQH_ROLE_TEMPLATES_bk1.create_role_template_b

41: begin
42: --
43: -- Start of API User Hook for the before hook of create_role_template
44: --
45: PQH_ROLE_TEMPLATES_bk1.create_role_template_b
46: (
47: p_role_id => p_role_id
48: ,p_transaction_category_id => p_transaction_category_id
49: ,p_template_id => p_template_id

Line 80: PQH_ROLE_TEMPLATES_bk1.create_role_template_a

76: begin
77: --
78: -- Start of API User Hook for the after hook of create_role_template
79: --
80: PQH_ROLE_TEMPLATES_bk1.create_role_template_a
81: (
82: p_role_template_id => l_role_template_id
83: ,p_role_id => p_role_id
84: ,p_transaction_category_id => p_transaction_category_id

Line 161: l_object_version_number pqh_role_templates.object_version_number%TYPE;

157: --
158: -- Declare cursors and local variables
159: --
160: l_proc varchar2(72) := g_package||'update_role_template';
161: l_object_version_number pqh_role_templates.object_version_number%TYPE;
162: p_transaction_category_id number(15) := hr_api.g_number;
163: --
164: begin
165: --

Line 182: PQH_ROLE_TEMPLATES_bk2.update_role_template_b

178: begin
179: --
180: -- Start of API User Hook for the before hook of update_role_template
181: --
182: PQH_ROLE_TEMPLATES_bk2.update_role_template_b
183: (
184: p_role_template_id => p_role_template_id
185: ,p_role_id => p_role_id
186: ,p_transaction_category_id => p_transaction_category_id

Line 217: PQH_ROLE_TEMPLATES_bk2.update_role_template_a

213: begin
214: --
215: -- Start of API User Hook for the after hook of update_role_template
216: --
217: PQH_ROLE_TEMPLATES_bk2.update_role_template_a
218: (
219: p_role_template_id => p_role_template_id
220: ,p_role_id => p_role_id
221: ,p_transaction_category_id => p_transaction_category_id

Line 290: l_object_version_number pqh_role_templates.object_version_number%TYPE;

286: --
287: -- Declare cursors and local variables
288: --
289: l_proc varchar2(72) := g_package||'delete_role_template';
290: l_object_version_number pqh_role_templates.object_version_number%TYPE;
291: --
292: begin
293: --
294: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 311: PQH_ROLE_TEMPLATES_bk3.delete_role_template_b

307: begin
308: --
309: -- Start of API User Hook for the before hook of delete_role_template
310: --
311: PQH_ROLE_TEMPLATES_bk3.delete_role_template_b
312: (
313: p_role_template_id => p_role_template_id
314: ,p_object_version_number => p_object_version_number
315: ,p_effective_date => trunc(p_effective_date)

Line 339: PQH_ROLE_TEMPLATES_bk3.delete_role_template_a

335: begin
336: --
337: -- Start of API User Hook for the after hook of delete_role_template
338: --
339: PQH_ROLE_TEMPLATES_bk3.delete_role_template_a
340: (
341: p_role_template_id => p_role_template_id
342: ,p_object_version_number => l_object_version_number
343: ,p_effective_date => trunc(p_effective_date)

Line 418: end PQH_ROLE_TEMPLATES_api;

414: hr_utility.set_location(' Leaving:'||l_proc, 70);
415: --
416: end lck;
417: --
418: end PQH_ROLE_TEMPLATES_api;