APPS.PQH_CRITERIA_RATE_FACTORS_API dependencies on PQH_CRITERIA_RATE_FACTORS

Line 1: Package Body PQH_CRITERIA_RATE_FACTORS_API as

1: Package Body PQH_CRITERIA_RATE_FACTORS_API as
2: /* $Header: pqcrfapi.pkb 120.0 2005/10/06 14:52:22 srajakum noship $ */
3: --
4: -- Package Variables
5: --

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

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

Line 27: l_criteria_rate_factor_id PQH_CRITERIA_RATE_FACTORS.criteria_rate_factor_id%TYPE;

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

Line 28: l_object_version_number PQH_CRITERIA_RATE_FACTORS.object_version_number%TYPE;

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

Line 64: PQH_CRITERIA_RATE_FACTORS_BK1.create_criteria_rate_factor_b

60: */
61:
62: -- CALL BY NAME
63:
64: PQH_CRITERIA_RATE_FACTORS_BK1.create_criteria_rate_factor_b
65: (p_effective_date => l_effective_date
66: ,p_criteria_rate_defn_id => p_criteria_rate_defn_id
67: ,p_parent_criteria_rate_defn_id => p_parent_criteria_rate_defn_id
68: ,p_parent_rate_matrix_id => p_parent_rate_matrix_id

Line 120: PQH_CRITERIA_RATE_FACTORS_BK1.create_criteria_rate_factor_a

116: */
117:
118:
119: begin
120: PQH_CRITERIA_RATE_FACTORS_BK1.create_criteria_rate_factor_a
121: (p_effective_date => l_effective_date
122: ,p_criteria_rate_defn_id => p_criteria_rate_defn_id
123: ,p_parent_criteria_rate_defn_id => p_parent_criteria_rate_defn_id
124: ,p_parent_rate_matrix_id => p_parent_rate_matrix_id

Line 205: l_object_version_number PQH_CRITERIA_RATE_FACTORS.object_version_number%TYPE;

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

Line 240: PQH_CRITERIA_RATE_FACTORS_BK2.update_criteria_rate_factor_b

236: );
237: */
238:
239: begin
240: PQH_CRITERIA_RATE_FACTORS_BK2.update_criteria_rate_factor_b
241: (p_effective_date => l_effective_date
242: ,p_criteria_rate_factor_id => p_criteria_rate_factor_id
243: ,p_criteria_rate_defn_id => p_criteria_rate_defn_id
244: ,p_parent_criteria_rate_defn_id => p_parent_criteria_rate_defn_id

Line 281: PQH_CRITERIA_RATE_FACTORS_BK2.update_criteria_rate_factor_a

277: --
278: -- Call After Process User Hook
279: --
280: begin
281: PQH_CRITERIA_RATE_FACTORS_BK2.update_criteria_rate_factor_a
282: (p_effective_date => l_effective_date
283: ,p_criteria_rate_factor_id => p_criteria_rate_factor_id
284: ,p_criteria_rate_defn_id => p_criteria_rate_defn_id
285: ,p_parent_criteria_rate_defn_id => p_parent_criteria_rate_defn_id

Line 375: PQH_CRITERIA_RATE_FACTORS_BK3.delete_criteria_rate_factor_b

371: --
372: -- Call Before Process User Hook
373: --
374: begin
375: PQH_CRITERIA_RATE_FACTORS_BK3.delete_criteria_rate_factor_b
376: (p_effective_date => l_effective_date
377: ,p_criteria_rate_factor_id => p_criteria_rate_factor_id
378: ,p_object_version_number => p_object_version_number
379: );

Line 407: PQH_CRITERIA_RATE_FACTORS_BK3.delete_criteria_rate_factor_a

403: --
404: -- Call After Process User Hook
405: --
406: begin
407: PQH_CRITERIA_RATE_FACTORS_BK3.delete_criteria_rate_factor_a
408: (p_effective_date => l_effective_date
409: ,p_criteria_rate_factor_id => p_criteria_rate_factor_id
410: ,p_object_version_number => p_object_version_number
411: );

Line 457: end PQH_CRITERIA_RATE_FACTORS_API;

453: raise;
454: end delete_criteria_rate_factor;
455: --
456: --
457: end PQH_CRITERIA_RATE_FACTORS_API;