APPS.PQH_CRITERIA_RATE_ELEMENTS_API dependencies on PQH_CRITERIA_RATE_ELEMENTS

Line 1: Package Body PQH_CRITERIA_RATE_ELEMENTS_API as

1: Package Body PQH_CRITERIA_RATE_ELEMENTS_API as
2: /* $Header: pqcreapi.pkb 120.0 2005/10/06 14:51:48 srajakum noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqcreapi.pkb 120.0 2005/10/06 14:51:48 srajakum noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'PQH_CRITERIA_RATE_ELEMENTS_API.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |-------------------------------------------------|
10: -- ----------------------------------------------------------------------------

Line 27: l_criteria_rate_element_id PQH_CRITERIA_RATE_ELEMENTS.criteria_rate_element_id%TYPE;

23: --
24: -- Declare cursors and local variables
25: --
26: l_effective_date date;
27: l_criteria_rate_element_id PQH_CRITERIA_RATE_ELEMENTS.criteria_rate_element_id%TYPE;
28: l_object_version_number PQH_CRITERIA_RATE_ELEMENTS.object_version_number%TYPE;
29: l_proc varchar2(72) := g_package||'create_criteria_rate_element';
30: begin
31: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 28: l_object_version_number PQH_CRITERIA_RATE_ELEMENTS.object_version_number%TYPE;

24: -- Declare cursors and local variables
25: --
26: l_effective_date date;
27: l_criteria_rate_element_id PQH_CRITERIA_RATE_ELEMENTS.criteria_rate_element_id%TYPE;
28: l_object_version_number PQH_CRITERIA_RATE_ELEMENTS.object_version_number%TYPE;
29: l_proc varchar2(72) := g_package||'create_criteria_rate_element';
30: begin
31: hr_utility.set_location('Entering:'|| l_proc, 10);
32: --

Line 65: PQH_CRITERIA_RATE_ELEMENTS_BK1.create_criteria_rate_element_b

61: --
62:
63: */
64:
65: PQH_CRITERIA_RATE_ELEMENTS_BK1.create_criteria_rate_element_b
66: (p_effective_date => l_effective_date
67: ,p_criteria_rate_defn_id => p_criteria_rate_defn_id
68: ,p_element_type_id => p_element_type_id
69: ,p_input_value_id => p_input_value_id

Line 122: PQH_CRITERIA_RATE_ELEMENTS_BK1.create_criteria_rate_element_a

118: */
119:
120:
121: begin
122: PQH_CRITERIA_RATE_ELEMENTS_BK1.create_criteria_rate_element_a
123: (p_effective_date => l_effective_date
124: ,p_criteria_rate_defn_id => p_criteria_rate_defn_id
125: ,p_element_type_id => p_element_type_id
126: ,p_input_value_id => p_input_value_id

Line 207: l_object_version_number PQH_CRITERIA_RATE_ELEMENTS.object_version_number%TYPE;

203: -- Declare cursors and local variables
204: --
205: l_effective_date date;
206: l_proc varchar2(72) := g_package||'update_criteria_rate_element';
207: l_object_version_number PQH_CRITERIA_RATE_ELEMENTS.object_version_number%TYPE;
208: begin
209: hr_utility.set_location('Entering:'|| l_proc, 10);
210: --
211: -- Issue a savepoint

Line 243: PQH_CRITERIA_RATE_ELEMENTS_BK2.update_criteria_rate_element_b

239: );
240: */
241:
242: begin
243: PQH_CRITERIA_RATE_ELEMENTS_BK2.update_criteria_rate_element_b
244: (p_effective_date => l_effective_date
245: ,p_criteria_rate_element_id => p_criteria_rate_element_id
246: ,p_criteria_rate_defn_id => p_criteria_rate_defn_id
247: ,p_element_type_id => p_element_type_id

Line 284: PQH_CRITERIA_RATE_ELEMENTS_BK2.update_criteria_rate_element_a

280: --
281: -- Call After Process User Hook
282: --
283: begin
284: PQH_CRITERIA_RATE_ELEMENTS_BK2.update_criteria_rate_element_a
285: (p_effective_date => l_effective_date
286: ,p_criteria_rate_element_id => p_criteria_rate_element_id
287: ,p_criteria_rate_defn_id => p_criteria_rate_defn_id
288: ,p_element_type_id => p_element_type_id

Line 378: PQH_CRITERIA_RATE_ELEMENTS_BK3.delete_criteria_rate_element_b

374: --
375: -- Call Before Process User Hook
376: --
377: begin
378: PQH_CRITERIA_RATE_ELEMENTS_BK3.delete_criteria_rate_element_b
379: (p_effective_date => l_effective_date
380: ,p_criteria_rate_element_id => p_criteria_rate_element_id
381: ,p_object_version_number => p_object_version_number
382: );

Line 410: PQH_CRITERIA_RATE_ELEMENTS_BK3.delete_criteria_rate_element_a

406: --
407: -- Call After Process User Hook
408: --
409: begin
410: PQH_CRITERIA_RATE_ELEMENTS_BK3.delete_criteria_rate_element_a
411: (p_effective_date => l_effective_date
412: ,p_criteria_rate_element_id => p_criteria_rate_element_id
413: ,p_object_version_number => p_object_version_number
414: );

Line 460: end PQH_CRITERIA_RATE_ELEMENTS_API;

456: raise;
457: end delete_criteria_rate_element;
458: --
459: --
460: end PQH_CRITERIA_RATE_ELEMENTS_API;