APPS.PQP_GB_PSI_HRS_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 37: pqp_utilities.debug_enter(p_proc_name => p_proc_name

33: THEN
34: hr_utility.trace_on(NULL, 'REQID'); -- Pipe name REQIDnnnnn
35: END IF;
36:
37: pqp_utilities.debug_enter(p_proc_name => p_proc_name
38: ,p_trace_on => p_trace_on);
39: --
40: END debug_enter;
41:

Line 52: pqp_utilities.debug_exit(p_proc_name => p_proc_name

48: PROCEDURE debug_exit(p_proc_name IN VARCHAR2, p_trace_off IN VARCHAR2)
49: IS
50: BEGIN
51: --
52: pqp_utilities.debug_exit(p_proc_name => p_proc_name
53: ,p_trace_off => p_trace_off);
54:
55: -- debug enter sets trace ON when g_trace = 'Y' and nested level = 0
56: -- so we must turn it off for the same condition

Line 58: IF pqp_utilities.g_nested_level = 0

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

Line 76: pqp_utilities.debug_others(p_proc_name => p_proc_name

72: PROCEDURE debug_others(p_proc_name IN VARCHAR2, p_proc_step IN NUMBER)
73: IS
74: BEGIN
75: --
76: pqp_utilities.debug_others(p_proc_name => p_proc_name
77: ,p_proc_step => p_proc_step);
78: --
79: END debug_others;
80:

Line 477: l_tab_config_values pqp_utilities.t_config_values;

473: l_proc_step PLS_INTEGER;
474: l_input_value_name pay_input_values_f.NAME%TYPE;
475: l_input_value_id NUMBER;
476: l_element_type_id NUMBER;
477: l_tab_config_values pqp_utilities.t_config_values;
478: i NUMBER;
479: l_rec_asg_sts_dtls csr_get_asg_sts_dtls%ROWTYPE;
480: --
481: BEGIN

Line 844: l_return := pqp_utilities.pqp_gb_get_table_value

840: debug('l_rec_aat_dtls.effective_end_date: '||TO_CHAR(l_rec_aat_dtls.effective_end_date, 'DD/MON/YYYY'));
841: END IF;
842:
843: -- Get hours type
844: l_return := pqp_utilities.pqp_gb_get_table_value
845: (p_business_group_id => g_business_group_id
846: ,p_effective_date => g_effective_date
847: ,p_table_name => 'PQP_CONTRACT_TYPES'
848: ,p_column_name => 'Penserver P/T Hours Type'

Line 904: l_return := pqp_utilities.pqp_gb_get_table_value

900: debug('g_assignment_dtl.frequency: '|| g_assignment_dtl.frequency);
901: END IF;
902: -- Get period divisor value
903:
904: l_return := pqp_utilities.pqp_gb_get_table_value
905: (p_business_group_id => g_business_group_id
906: ,p_effective_date => g_effective_date
907: ,p_table_name => 'PQP_CONTRACT_TYPES'
908: ,p_column_name => 'Period Divisor'