APPS.PQH_RT_MATRIX_NODE_VALUES_API dependencies on PQH_RT_MATRIX_NODE_VALUES

Line 1: Package Body PQH_RT_MATRIX_NODE_VALUES_API as

1: Package Body PQH_RT_MATRIX_NODE_VALUES_API as
2: /* $Header: pqrmvapi.pkb 120.3 2005/07/13 04:53:01 srenukun noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqrmvapi.pkb 120.3 2005/07/13 04:53:01 srenukun noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'PQH_RT_MATRIX_NODE_VALUES_API.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |-------------------------------------------------|
10: -- ----------------------------------------------------------------------------

Line 39: l_node_value_id PQH_RT_MATRIX_NODE_VALUES.node_value_id%TYPE;

35: --
36: -- Declare cursors and local variables
37: --
38: l_effective_date date;
39: l_node_value_id PQH_RT_MATRIX_NODE_VALUES.node_value_id%TYPE;
40: l_object_version_number PQH_RT_MATRIX_NODE_VALUES.object_version_number%TYPE;
41: l_proc varchar2(72) := g_package||'create_rate_matrix_node';
42: begin
43: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 40: l_object_version_number PQH_RT_MATRIX_NODE_VALUES.object_version_number%TYPE;

36: -- Declare cursors and local variables
37: --
38: l_effective_date date;
39: l_node_value_id PQH_RT_MATRIX_NODE_VALUES.node_value_id%TYPE;
40: l_object_version_number PQH_RT_MATRIX_NODE_VALUES.object_version_number%TYPE;
41: l_proc varchar2(72) := g_package||'create_rate_matrix_node';
42: begin
43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --

Line 61: PQH_RT_MATRIX_NODE_VALUES_BK1.create_rt_matrix_node_value_b

57: --
58: -- Call Before Process User Hook
59: --
60: begin
61: PQH_RT_MATRIX_NODE_VALUES_BK1.create_rt_matrix_node_value_b
62: (p_effective_date => l_effective_date
63: ,p_RATE_MATRIX_NODE_ID => p_rate_matrix_node_id
64: ,p_SHORT_CODE => p_short_code
65: ,p_CHAR_VALUE1 => p_char_value1

Line 122: PQH_RT_MATRIX_NODE_VALUES_BK1.create_rt_matrix_node_value_a

118: --
119: -- Call After Process User Hook
120: --
121: begin
122: PQH_RT_MATRIX_NODE_VALUES_BK1.create_rt_matrix_node_value_a
123: (p_effective_date => p_effective_date
124: ,p_NODE_VALUE_ID =>l_node_value_id
125: ,p_RATE_MATRIX_NODE_ID => p_rate_matrix_node_id
126: ,p_SHORT_CODE => p_short_code

Line 225: l_object_version_number PQH_RT_MATRIX_NODE_VALUES.object_version_number%TYPE;

221: is
222: --
223: -- Declare cursors and local variables
224: --
225: l_object_version_number PQH_RT_MATRIX_NODE_VALUES.object_version_number%TYPE;
226: l_effective_date date;
227: l_proc varchar2(72) := g_package||'update_rt_matrix_node_value';
228: begin
229: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 248: PQH_RT_MATRIX_NODE_VALUES_BK2.update_rt_matrix_node_value_b

244: --
245: -- Call Before Process User Hook
246: --
247: begin
248: PQH_RT_MATRIX_NODE_VALUES_BK2.update_rt_matrix_node_value_b
249: (p_effective_date => l_effective_date
250: ,p_NODE_VALUE_ID =>p_node_value_id
251: ,p_RATE_MATRIX_NODE_ID => p_rate_matrix_node_id
252: ,p_SHORT_CODE => p_short_code

Line 312: PQH_RT_MATRIX_NODE_VALUES_BK2.update_rt_matrix_node_value_a

308: --
309: -- Call After Process User Hook
310: --
311: begin
312: PQH_RT_MATRIX_NODE_VALUES_BK2.update_rt_matrix_node_value_a
313: (p_effective_date => l_effective_date
314: ,p_NODE_VALUE_ID =>p_node_value_id
315: ,p_RATE_MATRIX_NODE_ID => p_rate_matrix_node_id
316: ,p_SHORT_CODE => p_short_code

Line 415: PQH_RT_MATRIX_NODE_VALUES_BK3.delete_rt_matrix_node_value_b

411: --
412: -- Call Before Process User Hook
413: --
414: begin
415: PQH_RT_MATRIX_NODE_VALUES_BK3.delete_rt_matrix_node_value_b
416: (p_effective_date => l_effective_date
417: ,p_NODE_value_ID => p_node_value_id
418: ,p_object_version_number => p_object_version_number
419: );

Line 447: PQH_RT_MATRIX_NODE_VALUES_BK3.delete_rt_matrix_node_value_a

443: --
444: -- Call After Process User Hook
445: --
446: begin
447: PQH_RT_MATRIX_NODE_VALUES_BK3.delete_rt_matrix_node_value_a
448: (p_effective_date => l_effective_date
449: ,p_NODE_value_ID => p_node_value_id
450: ,p_object_version_number => p_object_version_number
451: );

Line 497: end PQH_RT_MATRIX_NODE_VALUES_API;

493: hr_utility.set_location(' Leaving:'||l_proc, 90);
494: raise;
495: end delete_rt_matrix_node_value;
496: --
497: end PQH_RT_MATRIX_NODE_VALUES_API;