APPS.PQP_GB_PSI_SALARY_HISTORY dependencies on PQP_UTILITIES

Line 12: g_nested_level NUMBER(5) := pqp_utilities.g_nested_level;

8: -- Exceptions
9: hr_application_error exception;
10: pragma exception_init (hr_application_error, -20001);
11:
12: g_nested_level NUMBER(5) := pqp_utilities.g_nested_level;
13: -- ----------------------------------------------------------------------------
14: -- |--------------------------------< debug >---------------------------------|
15: -- ----------------------------------------------------------------------------
16:

Line 25: pqp_utilities.DEBUG (

21: --
22: BEGIN
23: --
24: IF g_debug THEN
25: pqp_utilities.DEBUG (
26: p_trace_message => p_trace_message
27: ,p_trace_location => p_trace_location
28: );
29: END IF;

Line 46: IF pqp_utilities.g_nested_level = 0 THEN

42: IS
43: BEGIN
44: --
45: IF g_debug THEN
46: IF pqp_utilities.g_nested_level = 0 THEN
47: hr_utility.trace_on(NULL, 'REQID'); -- Pipe name REQIDnnnnn
48: END IF;
49: pqp_utilities.debug_enter (
50: p_proc_name => p_proc_name

Line 49: pqp_utilities.debug_enter (

45: IF g_debug THEN
46: IF pqp_utilities.g_nested_level = 0 THEN
47: hr_utility.trace_on(NULL, 'REQID'); -- Pipe name REQIDnnnnn
48: END IF;
49: pqp_utilities.debug_enter (
50: p_proc_name => p_proc_name
51: ,p_trace_on => p_trace_on
52: );
53: END IF;

Line 70: pqp_utilities.debug_exit (

66: IS
67: BEGIN
68: --
69: IF g_debug THEN
70: pqp_utilities.debug_exit (
71: p_proc_name => p_proc_name
72: ,p_trace_off => p_trace_off
73: );
74:

Line 75: IF pqp_utilities.g_nested_level = 0 THEN

71: p_proc_name => p_proc_name
72: ,p_trace_off => p_trace_off
73: );
74:
75: IF pqp_utilities.g_nested_level = 0 THEN
76: hr_utility.trace_off;
77: END IF;
78: END IF;
79: --

Line 93: pqp_utilities.debug_others (

89: PROCEDURE debug_others (p_proc_name IN VARCHAR2, p_proc_step IN NUMBER)
90: IS
91: BEGIN
92: --
93: pqp_utilities.debug_others (
94: p_proc_name => p_proc_name
95: ,p_proc_step => p_proc_step
96: );
97: --

Line 119: l_config_values PQP_UTILITIES.t_config_values;

115: IS
116: c_seeded_basic_sal_rate_name CONSTANT VARCHAR2(80) := 'PenServer Pensionable Salary';
117: c_seeded_basic_sal_rate_code CONSTANT VARCHAR2(80) := 'PEN_SALARY';
118: l_basic_sal_rate_code VARCHAR2(80);
119: l_config_values PQP_UTILITIES.t_config_values;
120: l_proc varchar2(72) := g_package||'.set_salary_rate_name';
121: l_itr NUMBER;
122: BEGIN
123: debug_enter(l_proc);

Line 156: l_config_values PQP_UTILITIES.t_config_values;

152: -- ----------------------------------------------------------------------------
153: PROCEDURE set_unigrade_config_values
154: IS
155: l_proc varchar2(72) := g_package||'.set_unigrade_config_values';
156: l_config_values PQP_UTILITIES.t_config_values;
157: l_error NUMBER;
158: BEGIN
159: debug_enter(l_proc);
160: PQP_UTILITIES.get_config_type_values(

Line 160: PQP_UTILITIES.get_config_type_values(

156: l_config_values PQP_UTILITIES.t_config_values;
157: l_error NUMBER;
158: BEGIN
159: debug_enter(l_proc);
160: PQP_UTILITIES.get_config_type_values(
161: p_configuration_type => 'PQP_GB_PENSERVER_UNIGRD_MAP'
162: ,p_business_group_id => g_business_group_id
163: ,p_legislation_code => g_legislation_code
164: ,p_tab_config_values => l_config_values

Line 881: pqp_utilities.get_kflex_value

877: IF l_people_group_id IS NULL THEN
878: -- Raise warning
879: debug('People Group flexfield details not attached',40);
880: ELSE
881: pqp_utilities.get_kflex_value
882: (p_entity_name => 'PAY_PEOPLE_GROUPS'
883: ,p_key_column_name => 'PEOPLE_GROUP_ID'
884: ,p_key_column_value => l_people_group_id
885: ,p_segment_column_name => g_people_group_column