APPS.PQP_GB_PSI_SCH dependencies on PQP_UTILITIES

Line 12: pqp_utilities.DEBUG( p_trace_message => p_trace_message ,p_trace_location => p_trace_location );

8: --
9: BEGIN
10: --
11: if g_debug then
12: pqp_utilities.DEBUG( p_trace_message => p_trace_message ,p_trace_location => p_trace_location );
13: end if;
14: --
15: END DEBUG;
16: -- This procedure is used for debug purposes

Line 29: IF pqp_utilities.g_nested_level = 0 THEN

25: IS
26: BEGIN
27: --
28: if g_debug then
29: IF pqp_utilities.g_nested_level = 0 THEN
30: hr_utility.trace_on(NULL, 'REQID'); -- Pipe name REQIDnnnnn
31: END IF;
32: -- g_nested_level := g_nested_level + 1;
33: -- debug('Entering: ' || NVL(p_proc_name, g_proc_name)

Line 35: pqp_utilities.debug_enter(p_proc_name => p_proc_name ,p_trace_on => p_trace_on);

31: END IF;
32: -- g_nested_level := g_nested_level + 1;
33: -- debug('Entering: ' || NVL(p_proc_name, g_proc_name)
34: -- ,g_nested_level * 100);
35: pqp_utilities.debug_enter(p_proc_name => p_proc_name ,p_trace_on => p_trace_on);
36: --
37: end if;
38: END debug_enter;
39: -- This procedure is used for debug purposes

Line 58: pqp_utilities.debug_exit(p_proc_name => p_proc_name ,p_trace_off => p_trace_off);

54: -- -g_nested_level * 100
55: -- );
56: -- g_nested_level := g_nested_level
57: -- - 1;
58: pqp_utilities.debug_exit(p_proc_name => p_proc_name ,p_trace_off => p_trace_off);
59: -- debug enter sets trace ON when g_trace = 'Y' and nested level = 0
60: -- so we must turn it off for the same condition
61: -- Also turn off tracing when the override flag of p_trace_off has been
62: -- passed as Y

Line 63: IF pqp_utilities.g_nested_level = 0 THEN

59: -- debug enter sets trace ON when g_trace = 'Y' and nested level = 0
60: -- so we must turn it off for the same condition
61: -- Also turn off tracing when the override flag of p_trace_off has been
62: -- passed as Y
63: IF pqp_utilities.g_nested_level = 0 THEN
64: hr_utility.trace_off;
65: END IF; -- (g_nested_level = 0
66: end if;
67: --

Line 81: pqp_utilities.debug_others(p_proc_name => p_proc_name ,p_proc_step => p_proc_step);

77: IS
78: BEGIN
79: --
80: if g_debug then
81: pqp_utilities.debug_others(p_proc_name => p_proc_name ,p_proc_step => p_proc_step);
82: end if;
83: --
84: END debug_others;
85: -- This procedure is used for clear cache

Line 200: p_tab_pen_sch_map_cv OUT NOCOPY pqp_utilities.t_config_values )

196: -- |----------------------------< fetch_pension_scheme_map_cv >------------------------------|
197: -- ----------------------------------------------------------------------------
198: PROCEDURE fetch_pension_scheme_map_cv(
199: p_business_group_id IN NUMBER ,
200: p_tab_pen_sch_map_cv OUT NOCOPY pqp_utilities.t_config_values )
201: IS
202: --
203: l_proc_name VARCHAR2(80) := g_proc_name || 'fetch_pension_scheme_map_cv';
204: l_proc_step PLS_INTEGER;

Line 207: l_tab_config_values pqp_utilities.t_config_values;

203: l_proc_name VARCHAR2(80) := g_proc_name || 'fetch_pension_scheme_map_cv';
204: l_proc_step PLS_INTEGER;
205: l_element_type_id NUMBER;
206: l_configuration_type pqp_configuration_types.configuration_type%TYPE;
207: l_tab_config_values pqp_utilities.t_config_values;
208: i NUMBER;
209: --
210: BEGIN
211: --

Line 226: pqp_utilities.get_config_type_values( p_configuration_type => l_configuration_type ,p_business_group_id => p_business_group_id ,p_legislation_code => g_legislation_code ,p_tab_config_values => l_tab_config_values );

222: DEBUG('p_business_group_id: ' || p_business_group_id);
223: END IF;
224: l_configuration_type := 'PQP_GB_PENSERV_SCHEME_MAP_INFO';
225: IF pqp_gb_psi_functions.g_pension_scheme_mapping.COUNT = 0 THEN
226: pqp_utilities.get_config_type_values( p_configuration_type => l_configuration_type ,p_business_group_id => p_business_group_id ,p_legislation_code => g_legislation_code ,p_tab_config_values => l_tab_config_values );
227: ELSE -- get it from cached collection
228: l_tab_config_values := pqp_gb_psi_functions.g_pension_scheme_mapping;
229: END IF;
230: IF g_debug THEN

Line 279: p_tab_pen_sch_map_cv IN pqp_utilities.t_config_values ,

275: -- ----------------------------------------------------------------------------
276: FUNCTION get_pen_scheme_memb(
277: p_assignment_id IN NUMBER ,
278: p_effective_date IN DATE ,
279: p_tab_pen_sch_map_cv IN pqp_utilities.t_config_values ,
280: p_rec_ele_ent_details OUT NOCOPY r_ele_ent_details )
281: RETURN VARCHAR2
282: IS
283: --