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 1428: l_tab_config_values pqp_utilities.t_config_values;

1424: l_proc_name VARCHAR2(80)
1425: := g_proc_name || 'fetch_process_defn_cv';
1426: l_proc_step PLS_INTEGER;
1427: l_configuration_type pqp_configuration_types.configuration_type%TYPE;
1428: l_tab_config_values pqp_utilities.t_config_values;
1429: i NUMBER;
1430: --
1431: BEGIN
1432: --

Line 1449: pqp_utilities.get_config_type_values(

1445: DEBUG('p_business_group_id: ' || p_business_group_id);
1446: END IF;
1447:
1448: l_configuration_type := 'PQP_GB_PENSERVER_DEFINITION';
1449: pqp_utilities.get_config_type_values(
1450: p_configuration_type => l_configuration_type
1451: ,p_business_group_id => p_business_group_id
1452: ,p_legislation_code => g_legislation_code
1453: ,p_tab_config_values => l_tab_config_values

Line 1518: ,p_tab_pen_sch_map_cv OUT NOCOPY pqp_utilities.t_config_values

1514: -- |----------------------------< fetch_pension_scheme_map_cv >---------------|
1515: -- ----------------------------------------------------------------------------
1516: PROCEDURE fetch_pension_scheme_map_cv(
1517: p_business_group_id IN NUMBER
1518: ,p_tab_pen_sch_map_cv OUT NOCOPY pqp_utilities.t_config_values
1519: )
1520: IS
1521: --
1522: l_proc_name VARCHAR2(80)

Line 1527: l_tab_config_values pqp_utilities.t_config_values;

1523: := g_proc_name || 'fetch_pension_scheme_map_cv';
1524: l_proc_step PLS_INTEGER;
1525: l_element_type_id NUMBER;
1526: l_configuration_type pqp_configuration_types.configuration_type%TYPE;
1527: l_tab_config_values pqp_utilities.t_config_values;
1528: i NUMBER;
1529: --
1530: BEGIN
1531: --

Line 1553: pqp_utilities.get_config_type_values(

1549: l_configuration_type := 'PQP_GB_PENSERV_SCHEME_MAP_INFO';
1550:
1551: IF pqp_gb_psi_functions.g_pension_scheme_mapping.COUNT = 0
1552: THEN
1553: pqp_utilities.get_config_type_values(
1554: p_configuration_type => l_configuration_type
1555: ,p_business_group_id => p_business_group_id
1556: ,p_legislation_code => g_legislation_code
1557: ,p_tab_config_values => l_tab_config_values

Line 1845: ,p_tab_pen_sch_map_cv IN pqp_utilities.t_config_values

1841: FUNCTION get_pen_scheme_memb(
1842: p_assignment_id IN NUMBER
1843: ,p_effective_start_date IN DATE
1844: ,p_effective_end_date IN DATE
1845: ,p_tab_pen_sch_map_cv IN pqp_utilities.t_config_values
1846: ,p_rec_ele_ent_details OUT NOCOPY r_ele_ent_details
1847: )
1848: RETURN VARCHAR2
1849: IS

Line 2519: l_tab_config_values pqp_utilities.t_config_values;

2515: l_proc_step PLS_INTEGER;
2516: l_input_value_name pay_input_values_f.NAME%TYPE;
2517: l_input_value_id NUMBER;
2518: l_element_type_id NUMBER;
2519: l_tab_config_values pqp_utilities.t_config_values;
2520: i NUMBER;
2521: l_error_code NUMBER;
2522: l_error_message VARCHAR2(2400);
2523: l_year VARCHAR2(10);

Line 2800: pqp_utilities.pqp_get_element_type_id(

2796: DEBUG(l_proc_name, l_proc_step);
2797: END IF;
2798:
2799: g_ni_ele_type_id :=
2800: pqp_utilities.pqp_get_element_type_id(
2801: p_business_group_id => NULL -- look for seeded
2802: ,p_legislation_code => g_legislation_code
2803: ,p_effective_date => g_effective_date
2804: ,p_element_type_name => 'NI'