DBA Data[Home] [Help]

APPS.PQH_RATE_FACTOR_ON_ELMNTS_API dependencies on PQH_RATE_FACTOR_ON_ELMNTS

Line 1: Package Body PQH_RATE_FACTOR_ON_ELMNTS_API as

1: Package Body PQH_RATE_FACTOR_ON_ELMNTS_API as
2: /* $Header: pqrfeapi.pkb 120.0 2005/10/06 14:53:54 srajakum noship $ */
3: --
4: -- Package Variables
5: --

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

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

Line 29: l_rate_factor_on_elmnt_id PQH_RATE_FACTOR_ON_ELMNTS.rate_factor_on_elmnt_id%TYPE;

25: --
26: -- Declare cursors and local variables
27: --
28: l_effective_date date;
29: l_rate_factor_on_elmnt_id PQH_RATE_FACTOR_ON_ELMNTS.rate_factor_on_elmnt_id%TYPE;
30: l_object_version_number PQH_RATE_FACTOR_ON_ELMNTS.object_version_number%TYPE;
31: l_proc varchar2(72) := g_package||'create_rate_factor_on_elmnt';
32: begin
33: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 30: l_object_version_number PQH_RATE_FACTOR_ON_ELMNTS.object_version_number%TYPE;

26: -- Declare cursors and local variables
27: --
28: l_effective_date date;
29: l_rate_factor_on_elmnt_id PQH_RATE_FACTOR_ON_ELMNTS.rate_factor_on_elmnt_id%TYPE;
30: l_object_version_number PQH_RATE_FACTOR_ON_ELMNTS.object_version_number%TYPE;
31: l_proc varchar2(72) := g_package||'create_rate_factor_on_elmnt';
32: begin
33: hr_utility.set_location('Entering:'|| l_proc, 10);
34: --

Line 68: PQH_RATE_FACTOR_ON_ELMNTS_BK1.create_rate_factor_on_elmnt_b

64: );
65:
66: */
67:
68: PQH_RATE_FACTOR_ON_ELMNTS_BK1.create_rate_factor_on_elmnt_b
69: (p_effective_date => l_effective_date
70: ,p_criteria_rate_element_id => p_criteria_rate_element_id
71: ,p_criteria_rate_factor_id => p_criteria_rate_factor_id
72: ,p_rate_factor_val_record_tbl => p_rate_factor_val_record_tbl

Line 136: PQH_RATE_FACTOR_ON_ELMNTS_BK1.create_rate_factor_on_elmnt_a

132: */
133:
134:
135: begin
136: PQH_RATE_FACTOR_ON_ELMNTS_BK1.create_rate_factor_on_elmnt_a
137: (
138: p_effective_date => l_effective_date
139: ,p_criteria_rate_element_id => p_criteria_rate_element_id
140: ,p_criteria_rate_factor_id => p_criteria_rate_factor_id

Line 224: l_object_version_number PQH_RATE_FACTOR_ON_ELMNTS.object_version_number%TYPE;

220: -- Declare cursors and local variables
221: --
222: l_effective_date date;
223: l_proc varchar2(72) := g_package||'update_rate_factor_on_elmnt';
224: l_object_version_number PQH_RATE_FACTOR_ON_ELMNTS.object_version_number%TYPE;
225: begin
226: hr_utility.set_location('Entering:'|| l_proc, 10);
227: --
228: -- Issue a savepoint

Line 261: PQH_RATE_FACTOR_ON_ELMNTS_BK2.update_rate_factor_on_elmnt_b

257: );
258: */
259:
260: begin
261: PQH_RATE_FACTOR_ON_ELMNTS_BK2.update_rate_factor_on_elmnt_b
262: ( p_effective_date => l_effective_date
263: ,p_criteria_rate_element_id => p_criteria_rate_element_id
264: ,p_criteria_rate_factor_id => p_criteria_rate_factor_id
265: ,p_rate_factor_val_record_tbl => p_rate_factor_val_record_tbl

Line 304: PQH_RATE_FACTOR_ON_ELMNTS_BK2.update_rate_factor_on_elmnt_a

300: --
301: -- Call After Process User Hook
302: --
303: begin
304: PQH_RATE_FACTOR_ON_ELMNTS_BK2.update_rate_factor_on_elmnt_a
305: ( p_effective_date => l_effective_date
306: ,p_criteria_rate_element_id => p_criteria_rate_element_id
307: ,p_criteria_rate_factor_id => p_criteria_rate_factor_id
308: ,p_rate_factor_val_record_tbl => p_rate_factor_val_record_tbl

Line 399: PQH_RATE_FACTOR_ON_ELMNTS_BK3.delete_rate_factor_on_elmnt_b

395: --
396: -- Call Before Process User Hook
397: --
398: begin
399: PQH_RATE_FACTOR_ON_ELMNTS_BK3.delete_rate_factor_on_elmnt_b
400: ( p_effective_date => l_effective_date
401: ,p_rate_factor_on_elmnt_id => p_rate_factor_on_elmnt_id
402: ,p_object_version_number => p_object_version_number
403: );

Line 431: PQH_RATE_FACTOR_ON_ELMNTS_BK3.delete_rate_factor_on_elmnt_a

427: --
428: -- Call After Process User Hook
429: --
430: begin
431: PQH_RATE_FACTOR_ON_ELMNTS_BK3.delete_rate_factor_on_elmnt_a
432: (p_effective_date => l_effective_date
433: ,p_rate_factor_on_elmnt_id => p_rate_factor_on_elmnt_id
434: ,p_object_version_number => p_object_version_number
435: );

Line 481: end PQH_RATE_FACTOR_ON_ELMNTS_API;

477: raise;
478: end delete_rate_factor_on_elmnt;
479: --
480: --
481: end PQH_RATE_FACTOR_ON_ELMNTS_API;