DBA Data[Home] [Help]

APPS.PQP_ABSVAL_PKG dependencies on PQP_UTILITIES

Line 77: pqp_utilities.debug(p_trace_message,p_trace_location);

73: ,p_trace_location IN NUMBER DEFAULT NULL
74: )
75: IS
76: BEGIN
77: pqp_utilities.debug(p_trace_message,p_trace_location);
78: END debug;
79: --
80: --
81: --

Line 86: pqp_utilities.debug(fnd_number.number_to_canonical(p_trace_number));

82: PROCEDURE debug
83: (p_trace_number IN NUMBER )
84: IS
85: BEGIN
86: pqp_utilities.debug(fnd_number.number_to_canonical(p_trace_number));
87: END debug;
88: --
89: --
90: --

Line 95: pqp_utilities.debug(fnd_date.date_to_canonical(p_trace_date));

91: PROCEDURE debug
92: (p_trace_date IN DATE )
93: IS
94: BEGIN
95: pqp_utilities.debug(fnd_date.date_to_canonical(p_trace_date));
96: END debug;
97: --
98: --
99: --

Line 107: pqp_utilities.debug_enter(p_proc_name,p_trace_on);

103: )
104: IS
105: -- l_trace_options VARCHAR2(200);
106: BEGIN
107: pqp_utilities.debug_enter(p_proc_name,p_trace_on);
108: END debug_enter;
109: --
110: --
111: --

Line 118: pqp_utilities.debug_exit(p_proc_name,p_trace_off);

114: ,p_trace_off IN VARCHAR2 DEFAULT NULL
115: )
116: IS
117: BEGIN
118: pqp_utilities.debug_exit(p_proc_name,p_trace_off);
119: END debug_exit;
120: --
121: --
122: --

Line 129: pqp_utilities.check_error_code(p_error_code, p_message);

125: ,p_message IN VARCHAR2
126: )
127: IS
128: BEGIN
129: pqp_utilities.check_error_code(p_error_code, p_message);
130: END check_error_code;
131: --
132: --
133: --

Line 703: pqp_utilities.debug_others

699: EXCEPTION
700: WHEN OTHERS THEN
701:
702: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
703: pqp_utilities.debug_others
704: (l_proc_name
705: ,l_proc_step
706: );
707: IF g_debug THEN

Line 807: pqp_utilities.debug_others

803: EXCEPTION
804: WHEN OTHERS THEN
805:
806: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
807: pqp_utilities.debug_others
808: (l_proc_name
809: ,l_proc_step
810: );
811: IF g_debug THEN

Line 1000: pqp_utilities.debug_others

996: EXCEPTION
997: WHEN OTHERS THEN
998:
999: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1000: pqp_utilities.debug_others
1001: (l_proc_name
1002: ,l_proc_step
1003: );
1004: IF g_debug THEN

Line 1062: pqp_utilities.debug_others

1058: EXCEPTION
1059: WHEN OTHERS THEN
1060:
1061: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1062: pqp_utilities.debug_others
1063: (l_proc_name
1064: ,l_proc_step
1065: );
1066: IF g_debug THEN

Line 1135: PQP_UTILITIES.pqp_get_config_value

1131: debug(l_proc_name, 12);
1132: END IF;
1133:
1134: g_log_duration_summary :=
1135: PQP_UTILITIES.pqp_get_config_value
1136: ( p_business_group_id => p_business_group_id
1137: ,p_legislation_code => 'GB'
1138: ,p_column_name => 'PCV_INFORMATION10'
1139: ,p_information_category => 'PQP_GB_OSP_OMP_CONFIG'

Line 2666: PQP_UTILITIES.pqp_get_config_value

2662: -- set the global as per that for further processing
2663: -- in the procedure get_absences_taken
2664:
2665: g_deduct_absence_for :=
2666: PQP_UTILITIES.pqp_get_config_value
2667: ( p_business_group_id => p_business_group_id
2668: ,p_legislation_code => 'GB'
2669: ,p_column_name => 'PCV_INFORMATION9'
2670: ,p_information_category => 'PQP_GB_OSP_OMP_CONFIG'

Line 3278: pqp_utilities.round_value_up_down

3274: IF p_is_full_timer IS NOT NULL THEN
3275:
3276: IF p_is_full_timer THEN
3277: p_entitlements_remaining(i).entitlement :=
3278: pqp_utilities.round_value_up_down
3279: ( p_value_to_round => p_entitlements_remaining(i).entitlement
3280: ,p_base_value => g_ft_rounding_precision
3281: ,p_rounding_type => g_ft_entitl_rounding_type
3282: ) ;

Line 3285: pqp_utilities.round_value_up_down

3281: ,p_rounding_type => g_ft_entitl_rounding_type
3282: ) ;
3283: ELSE
3284: p_entitlements_remaining(i).entitlement :=
3285: pqp_utilities.round_value_up_down
3286: ( p_value_to_round => p_entitlements_remaining(i).entitlement
3287: ,p_base_value => g_pt_rounding_precision
3288: ,p_rounding_type => g_pt_entitl_rounding_type
3289: ) ;

Line 3632: PQP_UTILITIES.pqp_get_config_value(

3628: l_effective_minpay_end_day := NULL;
3629:
3630: -- Set value for open ended absence no pay days
3631: l_open_ended_no_pay_days :=
3632: PQP_UTILITIES.pqp_get_config_value(
3633: p_business_group_id => p_business_group_id
3634: ,p_legislation_code => 'GB'
3635: ,p_column_name => 'PCV_INFORMATION8'
3636: ,p_information_category => 'PQP_GB_OSP_OMP_CONFIG'

Line 5046: PQP_UTILITIES.pqp_get_config_value(

5042: END IF;
5043:
5044: -- Set value for open ended absence no pay days
5045: l_open_ended_no_pay_days :=
5046: PQP_UTILITIES.pqp_get_config_value(
5047: p_business_group_id => p_business_group_id
5048: ,p_legislation_code => 'GB'
5049: ,p_column_name => 'PCV_INFORMATION8'
5050: ,p_information_category => 'PQP_GB_OSP_OMP_CONFIG'

Line 5415: PQP_UTILITIES.pqp_get_config_value

5411: debug(l_proc_name, 12);
5412: END IF;
5413:
5414: g_log_duration_summary :=
5415: PQP_UTILITIES.pqp_get_config_value
5416: ( p_business_group_id => p_business_group_id
5417: ,p_legislation_code => 'GB'
5418: ,p_column_name => 'PCV_INFORMATION10'
5419: ,p_information_category => 'PQP_GB_OSP_OMP_CONFIG'

Line 5740: PQP_UTILITIES.pqp_get_config_value

5736: -- get_absences_taken is direct from it , unlike thru
5737: -- the get_absences_taken_to_date.
5738:
5739: g_deduct_absence_for :=
5740: PQP_UTILITIES.pqp_get_config_value
5741: ( p_business_group_id => p_business_group_id
5742: ,p_legislation_code => 'GB'
5743: ,p_column_name => 'PCV_INFORMATION9'
5744: ,p_information_category => 'PQP_GB_OSP_OMP_CONFIG'

Line 6090: pqp_utilities.pqp_gb_get_table_value

6086:
6087: IF l_contract_type IS NOT NULL THEN
6088:
6089: l_error_code :=
6090: pqp_utilities.pqp_gb_get_table_value
6091: ( p_business_group_id => p_business_group_id
6092: ,p_effective_date => p_effective_date
6093: ,p_table_name => 'PQP_CONTRACT_TYPES'
6094: ,p_column_name => 'Full Time Work Pattern'

Line 6566: pqp_utilities.debug_others

6562:
6563: EXCEPTION
6564: WHEN OTHERS THEN
6565: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
6566: pqp_utilities.debug_others
6567: (l_proc_name
6568: ,l_proc_step
6569: );
6570: IF g_debug THEN

Line 6743: pqp_utilities.debug_others

6739:
6740: EXCEPTION
6741: WHEN OTHERS THEN
6742: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
6743: pqp_utilities.debug_others
6744: (l_proc_name
6745: ,l_proc_step
6746: );
6747: IF g_debug THEN

Line 6783: p_entitlements(i).entitlement := pqp_utilities.round_value_up_down

6779: p_entitlements(i).entitlement := (p_entitlements(i).entitlement
6780: * p_current_factor)/p_ft_factor ;
6781:
6782: /* IF p_current_factor>=p_ft_factor THEN
6783: p_entitlements(i).entitlement := pqp_utilities.round_value_up_down
6784: (
6785: p_value_to_round => p_entitlements(i).entitlement
6786: ,p_base_value => 0.5
6787: ,p_rounding_type => 'UPPER'

Line 6790: p_entitlements(i).entitlement := pqp_utilities.round_value_up_down

6786: ,p_base_value => 0.5
6787: ,p_rounding_type => 'UPPER'
6788: ) ;
6789: ELSE
6790: p_entitlements(i).entitlement := pqp_utilities.round_value_up_down
6791: (
6792: p_value_to_round => p_entitlements(i).entitlement
6793: ,p_base_value => 0.5
6794: ,p_rounding_type => 'LOWER'

Line 6812: pqp_utilities.debug_others

6808: EXCEPTION
6809: WHEN OTHERS THEN
6810: p_entitlements := l_entitlements_nc ;
6811: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
6812: pqp_utilities.debug_others
6813: (l_proc_name
6814: ,l_proc_step
6815: );
6816: IF g_debug THEN