APPS.PQP_GB_PSI_STH_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 47: IF pqp_utilities.g_nested_level = 0 THEN

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

Line 50: pqp_utilities.debug_enter (

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

Line 72: pqp_utilities.debug_exit (

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

Line 77: IF pqp_utilities.g_nested_level = 0 THEN

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

Line 95: pqp_utilities.debug_others (

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

Line 314: -- this cursor is split into two as in pqp_utilities.entries.effected

310: AND pes.element_type_id = pet.element_type_id
311: AND pet.element_type_id = piv.element_type_id (+)
312: ORDER BY ELEMENT_NAME;*/
313: -- not using the above cursor after perf fix
314: -- this cursor is split into two as in pqp_utilities.entries.effected
315: -- and made as a new procedure get_element_type_details
316:
317: BEGIN
318: debug_enter(l_proc);

Line 602: l_config_values PQP_UTILITIES.t_config_values;

598: -- ----------------------------------------------------------------------------
599: PROCEDURE get_adj_hrs_conf_values
600: IS
601: l_proc varchar2(72) := g_package||'.get_adj_hrs_conf_values';
602: l_config_values PQP_UTILITIES.t_config_values;
603: BEGIN
604: debug_enter(l_proc);
605: -- fetch the adj hrs source configuration values
606: PQP_UTILITIES.get_config_type_values(

Line 606: PQP_UTILITIES.get_config_type_values(

602: l_config_values PQP_UTILITIES.t_config_values;
603: BEGIN
604: debug_enter(l_proc);
605: -- fetch the adj hrs source configuration values
606: PQP_UTILITIES.get_config_type_values(
607: p_configuration_type => 'PQP_GB_PENSERVER_STH_ADJHR_MAP'
608: ,p_business_group_id => g_business_group_id
609: ,p_legislation_code => g_legislation_code
610: ,p_tab_config_values => l_config_values

Line 1694: g_adjusted_hours := pqp_utilities.round_value_up_down

1690: debug('g_adjusted_hours before rounding: '||g_adjusted_hours);
1691: -- g_adjusted_hours := round(g_adjusted_hours,2);
1692: -- Bug fix 5152505
1693: -- adjusted hours is rounded off to the nearest quarter.
1694: g_adjusted_hours := pqp_utilities.round_value_up_down
1695: (p_value_to_round => g_adjusted_hours
1696: ,p_base_value => 0.25
1697: ,p_rounding_type => 'NEAREST'
1698: );