APPS.PQP_GB_PSI_EARNINGS_HISTORY dependencies on PQP_UTILITIES

Line 14: pqp_utilities.DEBUG(

10: --
11: BEGIN
12: --
13:
14: pqp_utilities.DEBUG(
15: p_trace_message => p_trace_message
16: ,p_trace_location => p_trace_location
17: );
18: --

Line 32: IF pqp_utilities.g_nested_level = 0

28: PROCEDURE debug_enter(p_proc_name IN VARCHAR2, p_trace_on IN VARCHAR2)
29: IS
30: BEGIN
31: --
32: IF pqp_utilities.g_nested_level = 0
33: THEN
34: hr_utility.trace_on(NULL, 'REQID'); -- Pipe name REQIDnnnnn
35: END IF;
36:

Line 41: pqp_utilities.debug_enter(p_proc_name => p_proc_name

37: -- g_nested_level := g_nested_level + 1;
38: -- debug('Entering: ' || NVL(p_proc_name, g_proc_name)
39: -- ,g_nested_level * 100);
40:
41: pqp_utilities.debug_enter(p_proc_name => p_proc_name
42: ,p_trace_on => p_trace_on);
43: --
44: END debug_enter;
45:

Line 63: pqp_utilities.debug_exit(p_proc_name => p_proc_name

59: -- -g_nested_level * 100
60: -- );
61: -- g_nested_level := g_nested_level
62: -- - 1;
63: pqp_utilities.debug_exit(p_proc_name => p_proc_name
64: ,p_trace_off => p_trace_off);
65:
66: -- debug enter sets trace ON when g_trace = 'Y' and nested level = 0
67: -- so we must turn it off for the same condition

Line 69: IF pqp_utilities.g_nested_level = 0

65:
66: -- debug enter sets trace ON when g_trace = 'Y' and nested level = 0
67: -- so we must turn it off for the same condition
68: -- Also turn off tracing when the override flag of p_trace_off has been passed as Y
69: IF pqp_utilities.g_nested_level = 0
70: THEN
71: hr_utility.trace_off;
72: END IF; -- (g_nested_level = 0
73:

Line 87: pqp_utilities.debug_others(p_proc_name => p_proc_name

83: PROCEDURE debug_others(p_proc_name IN VARCHAR2, p_proc_step IN NUMBER)
84: IS
85: BEGIN
86: --
87: pqp_utilities.debug_others(p_proc_name => p_proc_name
88: ,p_proc_step => p_proc_step);
89: --
90: END debug_others;
91:

Line 1553: l_tab_config_values pqp_utilities.t_config_values;

1549: l_proc_name VARCHAR2(80)
1550: := g_proc_name || 'fetch_process_defn_cv';
1551: l_proc_step PLS_INTEGER;
1552: l_configuration_type pqp_configuration_types.configuration_type%TYPE;
1553: l_tab_config_values pqp_utilities.t_config_values;
1554: i NUMBER;
1555: --
1556: BEGIN
1557: --

Line 1574: pqp_utilities.get_config_type_values(

1570: DEBUG('p_business_group_id: ' || p_business_group_id);
1571: END IF;
1572:
1573: l_configuration_type := 'PQP_GB_PENSERVER_DEFINITION';
1574: pqp_utilities.get_config_type_values(
1575: p_configuration_type => l_configuration_type
1576: ,p_business_group_id => p_business_group_id
1577: ,p_legislation_code => g_legislation_code
1578: ,p_tab_config_values => l_tab_config_values

Line 1643: ,p_tab_pen_sch_map_cv OUT NOCOPY pqp_utilities.t_config_values

1639: -- |----------------------------< fetch_pension_scheme_map_cv >---------------|
1640: -- ----------------------------------------------------------------------------
1641: PROCEDURE fetch_pension_scheme_map_cv(
1642: p_business_group_id IN NUMBER
1643: ,p_tab_pen_sch_map_cv OUT NOCOPY pqp_utilities.t_config_values
1644: )
1645: IS
1646: --
1647: l_proc_name VARCHAR2(80)

Line 1652: l_tab_config_values pqp_utilities.t_config_values;

1648: := g_proc_name || 'fetch_pension_scheme_map_cv';
1649: l_proc_step PLS_INTEGER;
1650: l_element_type_id NUMBER;
1651: l_configuration_type pqp_configuration_types.configuration_type%TYPE;
1652: l_tab_config_values pqp_utilities.t_config_values;
1653: i NUMBER;
1654: --
1655: BEGIN
1656: --

Line 1678: pqp_utilities.get_config_type_values(

1674: l_configuration_type := 'PQP_GB_PENSERV_SCHEME_MAP_INFO';
1675:
1676: IF pqp_gb_psi_functions.g_pension_scheme_mapping.COUNT = 0
1677: THEN
1678: pqp_utilities.get_config_type_values(
1679: p_configuration_type => l_configuration_type
1680: ,p_business_group_id => p_business_group_id
1681: ,p_legislation_code => g_legislation_code
1682: ,p_tab_config_values => l_tab_config_values

Line 1970: ,p_tab_pen_sch_map_cv IN pqp_utilities.t_config_values

1966: FUNCTION get_pen_scheme_memb(
1967: p_assignment_id IN NUMBER
1968: ,p_effective_start_date IN DATE
1969: ,p_effective_end_date IN DATE
1970: ,p_tab_pen_sch_map_cv IN pqp_utilities.t_config_values
1971: ,p_rec_ele_ent_details OUT NOCOPY r_ele_ent_details
1972: )
1973: RETURN VARCHAR2
1974: IS

Line 2675: l_tab_config_values pqp_utilities.t_config_values;

2671: l_proc_step PLS_INTEGER;
2672: l_input_value_name pay_input_values_f.NAME%TYPE;
2673: l_input_value_id NUMBER;
2674: l_element_type_id NUMBER;
2675: l_tab_config_values pqp_utilities.t_config_values;
2676: i NUMBER;
2677: l_error_code NUMBER;
2678: l_error_message VARCHAR2(2400);
2679: l_year VARCHAR2(10);

Line 2956: pqp_utilities.pqp_get_element_type_id(

2952: DEBUG(l_proc_name, l_proc_step);
2953: END IF;
2954:
2955: g_ni_ele_type_id :=
2956: pqp_utilities.pqp_get_element_type_id(
2957: p_business_group_id => NULL -- look for seeded
2958: ,p_legislation_code => g_legislation_code
2959: ,p_effective_date => g_effective_date
2960: ,p_element_type_name => 'NI'