DBA Data[Home] [Help]

APPS.PQH_RATE_MATRIX_NODES_API dependencies on PQH_RATE_MATRIX_NODES

Line 1: Package Body PQH_RATE_MATRIX_NODES_API as

1: Package Body PQH_RATE_MATRIX_NODES_API as
2: /* $Header: pqrmnapi.pkb 120.1 2005/07/13 04:52:50 srenukun noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqrmnapi.pkb 120.1 2005/07/13 04:52:50 srenukun noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'PQH_RATE_MATRIX_NODES_API.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |-------------------------------------------------|
10: -- ----------------------------------------------------------------------------

Line 31: l_rate_matrix_node_id PQH_RATE_MATRIX_NODES.rate_matrix_node_id%TYPE;

27: --
28: -- Declare cursors and local variables
29: --
30: l_effective_date date;
31: l_rate_matrix_node_id PQH_RATE_MATRIX_NODES.rate_matrix_node_id%TYPE;
32: l_object_version_number PQH_RATE_MATRIX_NODES.object_version_number%TYPE;
33: l_proc varchar2(72) := g_package||'create_rate_matrix_node';
34: begin
35: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 32: l_object_version_number PQH_RATE_MATRIX_NODES.object_version_number%TYPE;

28: -- Declare cursors and local variables
29: --
30: l_effective_date date;
31: l_rate_matrix_node_id PQH_RATE_MATRIX_NODES.rate_matrix_node_id%TYPE;
32: l_object_version_number PQH_RATE_MATRIX_NODES.object_version_number%TYPE;
33: l_proc varchar2(72) := g_package||'create_rate_matrix_node';
34: begin
35: hr_utility.set_location('Entering:'|| l_proc, 10);
36: --

Line 53: PQH_RATE_MATRIX_NODES_BK1.create_rate_matrix_node_b

49: --
50: -- Call Before Process User Hook
51: --
52: begin
53: PQH_RATE_MATRIX_NODES_BK1.create_rate_matrix_node_b
54: (p_effective_date => l_effective_date
55: ,p_short_code => p_short_code
56: ,p_pl_id => p_pl_id
57: ,p_level_number => p_level_number

Line 100: PQH_RATE_MATRIX_NODES_BK1.create_rate_matrix_node_a

96: --
97: -- Call After Process User Hook
98: --
99: begin
100: PQH_RATE_MATRIX_NODES_BK1.create_rate_matrix_node_a
101: (p_effective_date => l_effective_date
102: ,p_rate_matrix_node_id =>l_rate_matrix_node_id
103: ,p_short_code => p_short_code
104: ,p_pl_id => p_pl_id

Line 190: l_object_version_number PQH_RATE_MATRIX_NODES.object_version_number%TYPE;

186: -- Declare cursors and local variables
187: --
188: l_effective_date date;
189: l_proc varchar2(72) := g_package||'update_rate_matrix_node';
190: l_object_version_number PQH_RATE_MATRIX_NODES.object_version_number%TYPE;
191: begin
192: hr_utility.set_location('Entering:'|| l_proc, 10);
193: --
194: -- Issue a savepoint

Line 211: PQH_RATE_MATRIX_NODES_BK2.update_rate_matrix_node_b

207: --
208: -- Call Before Process User Hook
209: --
210: begin
211: PQH_RATE_MATRIX_NODES_BK2.update_rate_matrix_node_b
212: (p_effective_date => l_effective_date
213: ,p_rate_matrix_node_id => p_rate_matrix_node_id
214: ,p_short_code => p_short_code
215: ,p_pl_id => p_pl_id

Line 259: PQH_RATE_MATRIX_NODES_BK2.update_rate_matrix_node_a

255: --
256: -- Call After Process User Hook
257: --
258: begin
259: PQH_RATE_MATRIX_NODES_BK2.update_rate_matrix_node_a
260: (p_effective_date => l_effective_date
261: ,p_rate_matrix_node_id => p_rate_matrix_node_id
262: ,p_short_code => p_short_code
263: ,p_pl_id => p_pl_id

Line 355: PQH_RATE_MATRIX_NODES_BK3.delete_rate_matrix_node_b

351: --
352: -- Call Before Process User Hook
353: --
354: begin
355: PQH_RATE_MATRIX_NODES_BK3.delete_rate_matrix_node_b
356: (p_effective_date => l_effective_date
357: ,p_rate_matrix_node_id => p_rate_matrix_node_id
358: ,p_object_version_number => p_object_version_number
359: );

Line 386: PQH_RATE_MATRIX_NODES_BK3.delete_rate_matrix_node_a

382: --
383: -- Call After Process User Hook
384: --
385: begin
386: PQH_RATE_MATRIX_NODES_BK3.delete_rate_matrix_node_a
387: (p_effective_date => l_effective_date
388: ,p_rate_matrix_node_id => p_rate_matrix_node_id
389: ,p_object_version_number => p_object_version_number
390: );

Line 436: end PQH_RATE_MATRIX_NODES_API;

432: raise;
433: end delete_rate_matrix_node;
434: --
435: --
436: end PQH_RATE_MATRIX_NODES_API;