DBA Data[Home] [Help]

APPS.PQH_RULE_SETS_API dependencies on PQH_RULE_SETS

Line 1: Package Body pqh_RULE_SETS_api as

1: Package Body pqh_RULE_SETS_api as
2: /* $Header: pqrstapi.pkb 120.0 2005/05/29 02:38:40 appldev noship $ */
3:
4: --
5: -- Package Variables

Line 7: g_package varchar2(33) := ' pqh_RULE_SETS_api.';

3:
4: --
5: -- Package Variables
6: --
7: g_package varchar2(33) := ' pqh_RULE_SETS_api.';
8: --
9: -- ----------------------------------------------------------------------------
10: -- |------------------------< create_RULE_SET >----------------------|
11: -- ----------------------------------------------------------------------------

Line 36: l_rule_set_id pqh_rule_sets.rule_set_id%TYPE;

32: ) is
33: --
34: -- Declare cursors and local variables
35: --
36: l_rule_set_id pqh_rule_sets.rule_set_id%TYPE;
37: l_proc varchar2(72) := g_package||'create_RULE_SET';
38: l_object_version_number pqh_rule_sets.object_version_number%TYPE;
39: --
40: begin

Line 38: l_object_version_number pqh_rule_sets.object_version_number%TYPE;

34: -- Declare cursors and local variables
35: --
36: l_rule_set_id pqh_rule_sets.rule_set_id%TYPE;
37: l_proc varchar2(72) := g_package||'create_RULE_SET';
38: l_object_version_number pqh_rule_sets.object_version_number%TYPE;
39: --
40: begin
41: --
42: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 56: pqh_RULE_SETS_bk1.create_RULE_SET_b

52: begin
53: --
54: -- Start of API User Hook for the before hook of create_RULE_SET
55: --
56: pqh_RULE_SETS_bk1.create_RULE_SET_b
57: (
58: p_business_group_id => p_business_group_id
59: ,p_rule_set_name => p_rule_set_name
60: ,p_description => p_description

Line 118: pqh_RULE_SETS_bk1.create_RULE_SET_a

114: begin
115: --
116: -- Start of API User Hook for the after hook of create_RULE_SET
117: --
118: pqh_RULE_SETS_bk1.create_RULE_SET_a
119: (
120: p_business_group_id => p_business_group_id
121: ,p_rule_set_id => l_rule_set_id
122: ,p_rule_set_name => p_rule_set_name

Line 218: l_object_version_number pqh_rule_sets.object_version_number%TYPE;

214: --
215: -- Declare cursors and local variables
216: --
217: l_proc varchar2(72) := g_package||'update_RULE_SET';
218: l_object_version_number pqh_rule_sets.object_version_number%TYPE;
219: --
220: begin
221: --
222: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 240: pqh_RULE_SETS_bk2.update_RULE_SET_b

236: begin
237: --
238: -- Start of API User Hook for the before hook of update_RULE_SET
239: --
240: pqh_RULE_SETS_bk2.update_RULE_SET_b
241: (
242: p_business_group_id => p_business_group_id
243: ,p_rule_set_id => p_rule_set_id
244: ,p_rule_set_name => p_rule_set_name

Line 303: pqh_RULE_SETS_bk2.update_RULE_SET_a

299: begin
300: --
301: -- Start of API User Hook for the after hook of update_RULE_SET
302: --
303: pqh_RULE_SETS_bk2.update_RULE_SET_a
304: (
305: p_business_group_id => p_business_group_id
306: ,p_rule_set_id => p_rule_set_id
307: ,p_rule_set_name => p_rule_set_name

Line 389: l_object_version_number pqh_rule_sets.object_version_number%TYPE;

385: --
386: -- Declare cursors and local variables
387: --
388: l_proc varchar2(72) := g_package||'delete_RULE_SET';
389: l_object_version_number pqh_rule_sets.object_version_number%TYPE;
390: --
391: --Declare cursor for pqh_rule_attributes.
392: --
393: cursor c1 is

Line 416: pqh_RULE_SETS_bk3.delete_RULE_SET_b

412: begin
413: --
414: -- Start of API User Hook for the before hook of delete_RULE_SET
415: --
416: pqh_RULE_SETS_bk3.delete_RULE_SET_b
417: (
418: p_rule_set_id => p_rule_set_id
419: ,p_object_version_number => p_object_version_number
420: ,p_effective_date => trunc(p_effective_date)

Line 464: pqh_RULE_SETS_bk3.delete_RULE_SET_a

460: begin
461: --
462: -- Start of API User Hook for the after hook of delete_RULE_SET
463: --
464: pqh_RULE_SETS_bk3.delete_RULE_SET_a
465: (
466: p_rule_set_id => p_rule_set_id
467: ,p_object_version_number => l_object_version_number
468: ,p_effective_date => trunc(p_effective_date)

Line 543: end pqh_RULE_SETS_api;

539: hr_utility.set_location(' Leaving:'||l_proc, 70);
540: --
541: end lck;
542: --
543: end pqh_RULE_SETS_api;