1: Package Body PQH_RULE_ATTRIBUTES_API as
2: /* $Header: pqrlaapi.pkb 115.0 2003/01/26 01:52:15 rpasapul noship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: pqrlaapi.pkb 115.0 2003/01/26 01:52:15 rpasapul noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'PQH_RULE_ATTRIBUTES_API.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< Insert_Rule_Attribute >------------------------|
10: -- ----------------------------------------------------------------------------
20: -- Declare cursors and local variables
21: --
22:
23: l_proc varchar2(72) := g_package||'Insert_Rule_Attribute';
24: l_object_Version_Number PQH_RULE_ATTRIBUTES.OBJECT_VERSION_NUMBER%TYPE;
25: L_Effective_Date Date;
26: l_rule_attribute_id PQH_RULE_ATTRIBUTES.RULE_ATTRIBUTE_ID%TYPE;
27:
28:
22:
23: l_proc varchar2(72) := g_package||'Insert_Rule_Attribute';
24: l_object_Version_Number PQH_RULE_ATTRIBUTES.OBJECT_VERSION_NUMBER%TYPE;
25: L_Effective_Date Date;
26: l_rule_attribute_id PQH_RULE_ATTRIBUTES.RULE_ATTRIBUTE_ID%TYPE;
27:
28:
29: begin
30: hr_utility.set_location('Entering:'|| l_proc, 10);
36: --
37: -- Call Before Process User Hook
38: --
39: begin
40: PQH_RULE_ATTRIBUTES_BK1.Insert_Rule_Attribute_b
41: (p_rule_set_id => p_rule_set_id
42: ,p_attribute_code => p_attribute_code
43: ,p_operation_code => p_operation_code
44: ,p_attribute_value => p_attribute_value
49:
50: exception
51: when hr_api.cannot_find_prog_unit then
52: hr_api.cannot_find_prog_unit_error
53: (p_module_name => 'PQH_RULE_ATTRIBUTES_API.Insert_Rule_Attribute'
54: ,p_hook_type => 'BP'
55: );
56: end;
57: --
71: --
72: -- Call After Process User Hook
73: --
74: begin
75: PQH_RULE_ATTRIBUTES_BK1.Insert_Rule_Attribute_a
76: (p_rule_set_id => p_rule_set_id
77: ,p_attribute_code => p_attribute_code
78: ,p_operation_code => p_operation_code
79: ,p_attribute_value => p_attribute_value
82:
83: exception
84: when hr_api.cannot_find_prog_unit then
85: hr_api.cannot_find_prog_unit_error
86: (p_module_name => 'PQH_RULE_ATTRIBUTES_API.Insert_Rule_Attribute'
87: ,p_hook_type => 'AP'
88: );
89: end;
90: --
142: ,p_attribute_value in varchar2 default hr_api.g_varchar2
143: ) Is
144:
145: l_proc varchar2(72) := g_package||'Update_Rule_Attribute';
146: l_object_Version_Number PQH_RULE_ATTRIBUTES.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;
147:
148: Begin
149: hr_utility.set_location('Entering:'|| l_proc, 10);
150: --
155: -- Call Before Process User Hook
156: --
157: begin
158:
159: PQH_RULE_ATTRIBUTES_BK2.Update_Rule_Attribute_b
160: (p_rule_attribute_id => p_rule_attribute_id
161: ,p_object_version_number => p_object_version_number
162: ,p_rule_set_id => p_rule_set_id
163: ,p_attribute_code => p_attribute_code
187: -- Call After Process User Hook
188: --
189: begin
190:
191: PQH_RULE_ATTRIBUTES_BK2.Update_Rule_Attribute_a
192: (p_rule_attribute_id => p_rule_attribute_id
193: ,p_object_version_number => p_object_version_number
194: ,p_rule_set_id => p_rule_set_id
195: ,p_attribute_code => p_attribute_code
263: --
264: -- Call Before Process User Hook
265: --
266: begin
267: PQH_RULE_ATTRIBUTES_BK3.Delete_Rule_Attribute_b
268: (p_rule_attribute_id => p_rule_attribute_id
269: ,p_object_version_number => p_object_version_number
270: );
271: exception
286: -- Call After Process User Hook
287: --
288: begin
289:
290: PQH_RULE_ATTRIBUTES_BK3.Delete_Rule_Attribute_a
291: (
292: p_rule_attribute_id => p_rule_attribute_id
293: ,p_object_version_number => p_object_version_number
294: );
330: hr_utility.set_location(' Leaving:'||l_proc, 90);
331: raise;
332: end delete_Rule_Attribute;
333:
334: end PQH_RULE_ATTRIBUTES_API;