eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_OSP_FUNCTIONS dependencies on PQP_UTILITIES

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

103: ,p_trace_location IN NUMBER DEFAULT NULL
104: )
105: IS
106: BEGIN
107: pqp_utilities.debug(p_trace_message, p_trace_location);
108: END debug;
109:
110: --
111: --

Line 116: pqp_utilities.debug(p_trace_number);

112: --
113: PROCEDURE debug(p_trace_number IN NUMBER)
114: IS
115: BEGIN
116: pqp_utilities.debug(p_trace_number);
117: END debug;
118:
119: --
120: --

Line 125: pqp_utilities.debug(p_trace_date);

121: --
122: PROCEDURE debug(p_trace_date IN DATE)
123: IS
124: BEGIN
125: pqp_utilities.debug(p_trace_date);
126: END debug;
127:
128: --
129: --

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

133: ,p_trace_on IN VARCHAR2 DEFAULT NULL
134: )
135: IS
136: BEGIN
137: pqp_utilities.debug_enter(p_proc_name, p_trace_on);
138: END debug_enter;
139:
140: --
141: --

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

145: ,p_trace_off IN VARCHAR2 DEFAULT NULL
146: )
147: IS
148: BEGIN
149: pqp_utilities.debug_exit(p_proc_name, p_trace_off);
150: END debug_exit;
151:
152: --
153: --

Line 161: pqp_utilities.debug_others(p_proc_name, p_proc_step);

157: ,p_proc_step IN NUMBER DEFAULT NULL
158: )
159: IS
160: BEGIN
161: pqp_utilities.debug_others(p_proc_name, p_proc_step);
162: END debug_others;
163: --
164: --
165: --

Line 172: pqp_utilities.check_error_code(p_error_code, p_error_message);

168: ,p_error_message IN VARCHAR2
169: )
170: IS
171: BEGIN
172: pqp_utilities.check_error_code(p_error_code, p_error_message);
173: END;
174: --
175: --
176: --

Line 277: pqp_utilities.get_col_value(

273: debug('p_col_name:'||p_col_name);
274: END IF;
275:
276: l_val :=
277: pqp_utilities.get_col_value(
278: p_col_nam => p_col_name
279: ,p_key_val => p_absence_attendance_id
280: ,p_table => 'PER_ABSENCE_ATTENDANCES'
281: ,p_key_col => 'ABSENCE_ATTENDANCE_ID'

Line 342: pqp_utilities.pqp_get_concat_value(

338: THEN
339: --
340: debug(l_proc_name, 10);
341: l_val :=
342: pqp_utilities.pqp_get_concat_value(
343: p_key_col => 'ABSENCE_ATTENDANCE_ID'
344: ,p_key_val => p_absence_attendance_id
345: ,p_tab_name => 'PER_ABSENCE_ATTENDANCES'
346: ,p_view_name => 'PER_ABSENCE_ATTENDANCES_DFV'

Line 354: pqp_utilities.get_ddf_value(

350: ELSE
351: --
352: debug(l_proc_name, 20);
353: l_val :=
354: pqp_utilities.get_ddf_value(
355: p_flex_name => 'PER_ABS_DEVELOPER_DF'
356: ,p_flex_context => 'GB'
357: ,p_flex_field_title => p_segment_name
358: ,p_key_col => 'ABSENCE_ATTENDANCE_ID'

Line 444: pqp_utilities.pqp_get_concat_value(

440: THEN
441: --
442: debug(l_proc_name, 10);
443: l_val :=
444: pqp_utilities.pqp_get_concat_value(
445: p_key_col => 'ABSENCE_ATTENDANCE_ID'
446: ,p_key_val => p_absence_attendance_id
447: ,p_tab_name => 'PER_ABSENCE_ATTENDANCES'
448: ,p_view_name => 'PER_ABSENCE_ATTENDANCES_DFV'

Line 456: pqp_utilities.get_df_value(

452: ELSE
453: --
454: debug(l_proc_name, 10);
455: l_val :=
456: pqp_utilities.get_df_value(
457: p_flex_name => 'PER_ABSENCE_ATTENDANCES'
458: ,p_flex_context => NULL
459: ,p_flex_field_title => p_segment_name
460: ,p_key_col => 'ABSENCE_ATTENDANCE_ID'

Line 547: pqp_utilities.get_col_value(

543: --
544: --
545: debug(l_proc_name, 20);
546: l_val :=
547: pqp_utilities.get_col_value(
548: p_col_nam => p_col_name
549: ,p_key_val => l_medical_id
550: ,p_table => 'SSP_MEDICALS'
551: ,p_key_col => 'MEDICAL_ID'

Line 627: pqp_utilities.pqp_get_concat_value(

623: THEN
624: --
625: debug(l_proc_name, 20);
626: l_val :=
627: pqp_utilities.pqp_get_concat_value(
628: p_key_col => 'MEDICAL_ID'
629: ,p_key_val => l_medical_id
630: ,p_tab_name => 'SSP_MEDICALS'
631: ,p_view_name => 'SSP_MEDICALS_DFV'

Line 639: pqp_utilities.get_df_value(

635: ELSE
636: --
637: debug(l_proc_name, 30);
638: l_val :=
639: pqp_utilities.get_df_value(
640: p_flex_name => 'SSP_MEDICALS'
641: ,p_flex_context => NULL
642: ,p_flex_field_title => p_segment_name
643: ,p_key_col => 'MEDICAL_ID'

Line 730: pqp_utilities.get_col_value(

726: --
727: --
728: debug(l_proc_name, 20);
729: l_val :=
730: pqp_utilities.get_col_value(
731: p_col_nam => p_col_name
732: ,p_key_val => l_maternity_id
733: ,p_table => 'SSP_MATERNITIES'
734: ,p_key_col => 'MATERNITY_ID'

Line 811: pqp_utilities.pqp_get_concat_value(

807: THEN
808: --
809: debug(l_proc_name, 20);
810: l_val :=
811: pqp_utilities.pqp_get_concat_value(
812: p_key_col => 'MATERNITY_ID'
813: ,p_key_val => l_maternity_id
814: ,p_tab_name => 'SSP_MATERNITIES'
815: ,p_view_name => 'SSP_MATERNITIES_DFV'

Line 823: pqp_utilities.get_df_value(

819: ELSE
820: --
821: debug(l_proc_name, 30);
822: l_val :=
823: pqp_utilities.get_df_value(
824: p_flex_name => 'SSP_MATERNITIES'
825: ,p_flex_context => NULL
826: ,p_flex_field_title => p_segment_name
827: ,p_key_col => 'MATERNITY_ID'

Line 928: pqp_utilities.pqp_get_extra_element_info(

924: --
925:
926: debug(l_proc_name, 40);
927: l_retval :=
928: pqp_utilities.pqp_get_extra_element_info(
929: p_element_type_id => g_element_type_id
930: ,p_information_type => p_information_type
931: ,p_segment_name => p_segment_name
932: ,p_value => p_value

Line 1797: pqp_utilities.get_col_value(

1793: IF l_col_name LIKE '%NAME'
1794: THEN
1795: debug(l_proc_name, 60);
1796: l_val :=
1797: pqp_utilities.get_col_value(
1798: p_col_nam => 'FULL_NAME'
1799: ,p_key_val => l_person_det
1800: ,p_table => 'PER_PEOPLE_V'
1801: ,p_key_col => 'PERSON_ID'

Line 1809: pqp_utilities.get_col_value(

1805: );
1806: ELSE
1807: debug(l_proc_name, 70);
1808: l_val :=
1809: pqp_utilities.get_col_value(
1810: p_col_nam => 'EMPLOYEE_NUMBER'
1811: ,p_key_val => l_person_det
1812: ,p_table => 'PER_PEOPLE_V'
1813: ,p_key_col => 'PERSON_ID'

Line 2558: pqp_utilities.pqp_gb_get_table_value_id(

2554: l_column_name := l_column_name || p_omp_intend_to_return_to_work;
2555: END IF;
2556:
2557: l_retval :=
2558: pqp_utilities.pqp_gb_get_table_value_id(
2559: p_business_group_id => p_business_group_id
2560: ,p_effective_date => p_effective_date
2561: ,p_table_id => p_entitlement_table_id
2562: ,p_column_name => l_column_name

Line 2633: pqp_utilities.pqp_gb_get_table_value_id(

2629: l_proc_step := 85;
2630: debug(l_proc_name, l_proc_step+i/100);
2631:
2632: l_retval :=
2633: pqp_utilities.pqp_gb_get_table_value_id(
2634: p_business_group_id => p_business_group_id
2635: ,p_effective_date => p_effective_date
2636: ,p_table_id => p_entitlement_table_id
2637: ,p_column_name => l_column_name

Line 2759: pqp_utilities.pqp_gb_get_table_value_id(

2755: CLOSE csr_get_lookup_info;
2756:
2757: debug('p_level_of_entitlement:'||p_level_of_entitlement);
2758: l_retval :=
2759: pqp_utilities.pqp_gb_get_table_value_id(
2760: p_business_group_id => p_business_group_id
2761: ,p_effective_date => p_effective_date
2762: ,p_table_id => p_entitlement_table_id
2763: ,p_column_name => p_level_of_entitlement

Line 2801: pqp_utilities.pqp_gb_get_table_value_id(

2797: CLOSE csr_get_lookup_info;
2798: debug('p_level_of_entitlement:' || p_level_of_entitlement);
2799: debug(l_proc_name, 30);
2800: l_retval :=
2801: pqp_utilities.pqp_gb_get_table_value_id(
2802: p_business_group_id => p_business_group_id
2803: ,p_effective_date => p_effective_date
2804: ,p_table_id => p_entitlement_table_id
2805: ,p_column_name => p_level_of_entitlement

Line 3109: pqp_utilities.pqp_get_extra_element_info(

3105:
3106: -- determine plan id for this given element type id
3107:
3108: l_retval :=
3109: pqp_utilities.pqp_get_extra_element_info(
3110: p_element_type_id => p_element_type_id
3111: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
3112: ,p_segment_name => 'Plan Name'
3113: ,p_value => l_pl_id_txt

Line 3161: pqp_utilities.pqp_get_extra_element_info(

3157:
3158: -- Added for CS
3159:
3160: l_retval :=
3161: pqp_utilities.pqp_get_extra_element_info(
3162: p_element_type_id => p_element_type_id
3163: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
3164: ,p_segment_name => 'Scheme Calendar Type'
3165: ,p_value => l_scheme_type

Line 3185: pqp_utilities.pqp_get_extra_element_info(

3181: -- BAND2 = FLOOR(182 * 3 / 7) = 78
3182:
3183:
3184: l_retval :=
3185: pqp_utilities.pqp_get_extra_element_info(
3186: p_element_type_id => p_element_type_id
3187: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
3188: ,p_segment_name => 'Absence Default Work Pattern'
3189: ,p_value => l_default_work_pattern

Line 3195: pqp_utilities.pqp_get_extra_element_info(

3191: ,p_error_msg => p_error_msg
3192: );
3193:
3194: l_retval :=
3195: pqp_utilities.pqp_get_extra_element_info(
3196: p_element_type_id => p_element_type_id
3197: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
3198: ,p_segment_name => 'Enable Entitlement Proration'
3199: ,p_value => l_track_part_timers

Line 3204: pqp_utilities.pqp_get_extra_element_info(

3200: ,p_truncated_yes_no => l_truncated_yes_no
3201: ,p_error_msg => p_error_msg
3202: );
3203: l_retval :=
3204: pqp_utilities.pqp_get_extra_element_info(
3205: p_element_type_id => p_element_type_id
3206: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
3207: ,p_segment_name => 'Absence Schedule Work Pattern'
3208: ,p_value => l_absence_schedule_wp

Line 3214: pqp_utilities.pqp_get_extra_element_info(

3210: ,p_error_msg => p_error_msg
3211: );
3212:
3213: l_retval :=
3214: pqp_utilities.pqp_get_extra_element_info(
3215: p_element_type_id => p_element_type_id
3216: ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
3217: ,p_segment_name => 'Absence Days'
3218: ,p_value => l_entitlement_uom

Line 3248: -- pqp_utilities.pqp_get_extra_element_info(

3244:
3245: IF l_scheme_type = 'DUALROLLING' THEN
3246:
3247: -- l_retval :=
3248: -- pqp_utilities.pqp_get_extra_element_info(
3249: -- p_element_type_id => p_element_type_id
3250: -- ,p_information_type => 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
3251: -- ,p_segment_name => 'Absence Default Work Pattern'
3252: -- ,p_value => l_default_work_pattern

Line 3316: p_band1_entitlement := pqp_utilities.round_value_up_down

3312:
3313:
3314: -- Rounding off entitlements depending on wether a full timers or part timers
3315: /* IF l_is_full_timer THEN
3316: p_band1_entitlement := pqp_utilities.round_value_up_down
3317: (p_value_to_round => p_band1_entitlement
3318: ,p_base_value => g_ft_rounding_precision
3319: ,p_rounding_type => g_ft_entitl_rounding_type
3320: ) ;

Line 3322: p_band1_entitlement := pqp_utilities.round_value_up_down

3318: ,p_base_value => g_ft_rounding_precision
3319: ,p_rounding_type => g_ft_entitl_rounding_type
3320: ) ;
3321: ELSE
3322: p_band1_entitlement := pqp_utilities.round_value_up_down
3323: ( p_value_to_round => p_band1_entitlement
3324: ,p_base_value => g_pt_rounding_precision
3325: ,p_rounding_type => g_pt_entitl_rounding_type
3326: ) ;

Line 3347: p_band2_entitlement := pqp_utilities.round_value_up_down

3343:
3344:
3345: -- Rounding off entitlements depending on wether a full timers or part timers
3346: /* IF l_is_full_timer THEN
3347: p_band2_entitlement := pqp_utilities.round_value_up_down
3348: ( p_value_to_round => p_band2_entitlement
3349: ,p_base_value => g_ft_rounding_precision
3350: ,p_rounding_type => g_ft_entitl_rounding_type
3351: ) ;

Line 3353: p_band2_entitlement := pqp_utilities.round_value_up_down

3349: ,p_base_value => g_ft_rounding_precision
3350: ,p_rounding_type => g_ft_entitl_rounding_type
3351: ) ;
3352: ELSE
3353: p_band2_entitlement := pqp_utilities.round_value_up_down
3354: ( p_value_to_round => p_band2_entitlement
3355: ,p_base_value => g_pt_rounding_precision
3356: ,p_rounding_type => g_pt_entitl_rounding_type
3357: ) ;

Line 3379: p_band3_entitlement := pqp_utilities.round_value_up_down

3375: p_band3_percentage := l_entitlement_parameters(i).percentage;
3376:
3377: -- Rounding off entitlements depending on wether a full timers or part timers
3378: /* IF l_is_full_timer THEN
3379: p_band3_entitlement := pqp_utilities.round_value_up_down
3380: ( p_value_to_round => p_band3_entitlement
3381: ,p_base_value => g_ft_rounding_precision
3382: ,p_rounding_type => g_ft_entitl_rounding_type
3383: ) ;

Line 3385: p_band3_entitlement := pqp_utilities.round_value_up_down

3381: ,p_base_value => g_ft_rounding_precision
3382: ,p_rounding_type => g_ft_entitl_rounding_type
3383: ) ;
3384: ELSE
3385: p_band3_entitlement := pqp_utilities.round_value_up_down
3386: ( p_value_to_round => p_band3_entitlement
3387: ,p_base_value => g_pt_rounding_precision
3388: ,p_rounding_type => g_pt_entitl_rounding_type
3389: ) ;

Line 3409: p_band4_entitlement := pqp_utilities.round_value_up_down

3405: p_band4_percentage := l_entitlement_parameters(i).percentage;
3406:
3407: -- Rounding off entitlements depending on wether a full timers or part timers
3408: /* IF l_is_full_timer THEN
3409: p_band4_entitlement := pqp_utilities.round_value_up_down
3410: ( p_value_to_round => p_band4_entitlement
3411: ,p_base_value => g_ft_rounding_precision
3412: ,p_rounding_type => g_ft_entitl_rounding_type
3413: ) ;

Line 3415: p_band4_entitlement := pqp_utilities.round_value_up_down

3411: ,p_base_value => g_ft_rounding_precision
3412: ,p_rounding_type => g_ft_entitl_rounding_type
3413: ) ;
3414: ELSE
3415: p_band4_entitlement := pqp_utilities.round_value_up_down
3416: ( p_value_to_round => p_band4_entitlement
3417: ,p_base_value => g_pt_rounding_precision
3418: ,p_rounding_type => g_pt_entitl_rounding_type
3419: ) ;

Line 4138: pqp_utilities.pqp_get_extra_element_info(

4134:
4135: l_effective_date := NVL(p_override_effective_date, p_effective_date);
4136:
4137: l_retval :=
4138: pqp_utilities.pqp_get_extra_element_info(
4139: p_element_type_id => p_element_type_id
4140: ,p_information_type => 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
4141: ,p_segment_name => 'Plan Name'
4142: ,p_value => l_pl_id_txt

Line 4434: pqp_utilities.pqp_gb_get_table_value(

4430: debug('p_curr_date:'||fnd_date.date_to_canonical(p_curr_date));
4431:
4432: BEGIN
4433: l_retval :=
4434: pqp_utilities.pqp_gb_get_table_value(
4435: p_business_group_id => p_wp_dets.business_group_id
4436: ,p_effective_date => p_curr_date
4437: ,p_table_name => g_udt_name
4438: ,p_column_name => p_wp_dets.work_pattern

Line 5617: PQP_UTILITIES.pqp_get_config_value(

5613:
5614: l_proc_step := 20;
5615:
5616: l_abs_precision :=
5617: PQP_UTILITIES.pqp_get_config_value(
5618: p_business_group_id => p_business_group_id
5619: ,p_legislation_code => 'GB'
5620: ,p_column_name => 'PCV_INFORMATION7'
5621: ,p_information_category => 'PQP_GB_OSP_OMP_CONFIG'

Line 5777: l_retval :=pqp_utilities.round_value_up_down

5773: ELSE
5774: l_retval := g_absences_taken_to_date(i).duration ;
5775: END IF;
5776:
5777: l_retval :=pqp_utilities.round_value_up_down
5778: ( p_value_to_round => l_retval
5779: ,p_base_value => g_abs_rounding_precision
5780: ,p_rounding_type => g_abs_rounding_type
5781: ) ;

Line 5797: l_retval :=pqp_utilities.round_value_up_down

5793: ELSE
5794: l_retval := g_absences_taken_to_date(i).duration_in_hours;
5795: END IF;
5796:
5797: l_retval :=pqp_utilities.round_value_up_down
5798: ( p_value_to_round => l_retval
5799: ,p_base_value => g_abs_rounding_precision
5800: ,p_rounding_type => g_abs_rounding_type
5801: ) ;

Line 5876: l_retval :=pqp_utilities.round_value_up_down

5872: -- 4.4 for a PT = 4.5 or 4.6 = 5
5873: -- NVL is just to ensure that it wont fail if there is no
5874: -- DEFAULT work Pattern at Scheme level
5875:
5876: l_retval :=pqp_utilities.round_value_up_down
5877: ( p_value_to_round => l_retval
5878: ,p_base_value => g_abs_rounding_precision
5879: ,p_rounding_type => g_abs_rounding_type
5880: ) ;

Line 10822: pqp_utilities.pqp_gb_get_table_value_id(

10818: debug('l_column_name:'||l_get_lookup_info.meaning);
10819: END IF ;
10820:
10821: l_retval :=
10822: pqp_utilities.pqp_gb_get_table_value_id(
10823: p_business_group_id => p_business_group_id
10824: ,p_effective_date => p_effective_date
10825: ,p_table_id => p_entitlement_table_id
10826: ,p_column_name => l_get_lookup_info.meaning

Line 11084: pqp_utilities.check_error_code(l_ret_num, l_err);

11080: );
11081:
11082:
11083: IF l_ret_num <> 0 THEN
11084: pqp_utilities.check_error_code(l_ret_num, l_err);
11085: END IF;
11086:
11087: l_proc_step := 20;
11088:

Line 11107: pqp_utilities.check_error_code(l_ret_num, l_err);

11103: ,p_error_msg => l_err
11104: );
11105:
11106: IF l_ret_num <> 0 THEN
11107: pqp_utilities.check_error_code(l_ret_num, l_err);
11108: END IF;
11109:
11110: l_proc_step := 30;
11111:

Line 11133: pqp_utilities.check_error_code(l_ret_num, l_err);

11129: );
11130:
11131:
11132: IF l_ret_num <> 0 THEN
11133: pqp_utilities.check_error_code(l_ret_num, l_err);
11134: END IF;
11135:
11136: l_proc_step := 35;
11137:

Line 11182: pqp_utilities.debug_others

11178:
11179: EXCEPTION
11180: WHEN OTHERS THEN
11181: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
11182: pqp_utilities.debug_others
11183: (l_proc_name
11184: ,l_proc_step
11185: );
11186: IF g_debug THEN

Line 11601: PQP_UTILITIES.pqp_get_config_value(

11597: END IF;
11598:
11599:
11600: l_abs_precision :=
11601: PQP_UTILITIES.pqp_get_config_value(
11602: p_business_group_id => p_business_group_id
11603: ,p_legislation_code => 'GB'
11604: ,p_column_name => 'PCV_INFORMATION7'
11605: ,p_information_category => 'PQP_GB_OSP_OMP_CONFIG'

Line 11728: p_band1_remaining := pqp_utilities.round_value_up_down

11724:
11725:
11726: --Round Absence remaining figures
11727:
11728: p_band1_remaining := pqp_utilities.round_value_up_down
11729: (p_value_to_round => p_band1_remaining
11730: ,p_base_value => g_abs_rounding_precision
11731: ,p_rounding_type => g_abs_rounding_type
11732: ) ;

Line 11734: p_band2_remaining := pqp_utilities.round_value_up_down

11730: ,p_base_value => g_abs_rounding_precision
11731: ,p_rounding_type => g_abs_rounding_type
11732: ) ;
11733:
11734: p_band2_remaining := pqp_utilities.round_value_up_down
11735: (p_value_to_round => p_band2_remaining
11736: ,p_base_value => g_abs_rounding_precision
11737: ,p_rounding_type => g_abs_rounding_type
11738: ) ;

Line 11741: p_band3_remaining := pqp_utilities.round_value_up_down

11737: ,p_rounding_type => g_abs_rounding_type
11738: ) ;
11739:
11740:
11741: p_band3_remaining := pqp_utilities.round_value_up_down
11742: (p_value_to_round => p_band3_remaining
11743: ,p_base_value => g_abs_rounding_precision
11744: ,p_rounding_type => g_abs_rounding_type
11745: ) ;

Line 11747: p_band4_remaining := pqp_utilities.round_value_up_down

11743: ,p_base_value => g_abs_rounding_precision
11744: ,p_rounding_type => g_abs_rounding_type
11745: ) ;
11746:
11747: p_band4_remaining := pqp_utilities.round_value_up_down
11748: (p_value_to_round => p_band4_remaining
11749: ,p_base_value => g_abs_rounding_precision
11750: ,p_rounding_type => g_abs_rounding_type
11751: ) ;

Line 11759: p_band1_ent_used := pqp_utilities.round_value_up_down

11755: END IF;
11756:
11757: --Round Absence Used One year figures
11758:
11759: p_band1_ent_used := pqp_utilities.round_value_up_down
11760: (p_value_to_round => p_band1_ent_used
11761: ,p_base_value => g_abs_rounding_precision
11762: ,p_rounding_type => g_abs_rounding_type
11763: ) ;

Line 11765: p_band2_ent_used := pqp_utilities.round_value_up_down

11761: ,p_base_value => g_abs_rounding_precision
11762: ,p_rounding_type => g_abs_rounding_type
11763: ) ;
11764:
11765: p_band2_ent_used := pqp_utilities.round_value_up_down
11766: (p_value_to_round => p_band2_ent_used
11767: ,p_base_value => g_abs_rounding_precision
11768: ,p_rounding_type => g_abs_rounding_type
11769: ) ;

Line 11772: p_band3_ent_used := pqp_utilities.round_value_up_down

11768: ,p_rounding_type => g_abs_rounding_type
11769: ) ;
11770:
11771:
11772: p_band3_ent_used := pqp_utilities.round_value_up_down
11773: (p_value_to_round => p_band3_ent_used
11774: ,p_base_value => g_abs_rounding_precision
11775: ,p_rounding_type => g_abs_rounding_type
11776: ) ;

Line 11778: p_band4_ent_used := pqp_utilities.round_value_up_down

11774: ,p_base_value => g_abs_rounding_precision
11775: ,p_rounding_type => g_abs_rounding_type
11776: ) ;
11777:
11778: p_band4_ent_used := pqp_utilities.round_value_up_down
11779: (p_value_to_round => p_band4_ent_used
11780: ,p_base_value => g_abs_rounding_precision
11781: ,p_rounding_type => g_abs_rounding_type
11782: ) ;

Line 11784: p_noband_ent_used := pqp_utilities.round_value_up_down

11780: ,p_base_value => g_abs_rounding_precision
11781: ,p_rounding_type => g_abs_rounding_type
11782: ) ;
11783:
11784: p_noband_ent_used := pqp_utilities.round_value_up_down
11785: (p_value_to_round => p_noband_ent_used
11786: ,p_base_value => g_abs_rounding_precision
11787: ,p_rounding_type => g_abs_rounding_type
11788: ) ;

Line 11799: p_band1_4year_ent_used := pqp_utilities.round_value_up_down

11795: IF g_debug THEN
11796: debug(l_proc_name,65);
11797: END IF;
11798:
11799: p_band1_4year_ent_used := pqp_utilities.round_value_up_down
11800: (p_value_to_round => p_band1_4year_ent_used
11801: ,p_base_value => g_abs_rounding_precision
11802: ,p_rounding_type => g_abs_rounding_type
11803: ) ;

Line 11805: p_band2_4year_ent_used := pqp_utilities.round_value_up_down

11801: ,p_base_value => g_abs_rounding_precision
11802: ,p_rounding_type => g_abs_rounding_type
11803: ) ;
11804:
11805: p_band2_4year_ent_used := pqp_utilities.round_value_up_down
11806: (p_value_to_round => p_band2_4year_ent_used
11807: ,p_base_value => g_abs_rounding_precision
11808: ,p_rounding_type => g_abs_rounding_type
11809: ) ;

Line 11812: p_band3_4year_ent_used := pqp_utilities.round_value_up_down

11808: ,p_rounding_type => g_abs_rounding_type
11809: ) ;
11810:
11811:
11812: p_band3_4year_ent_used := pqp_utilities.round_value_up_down
11813: (p_value_to_round => p_band3_4year_ent_used
11814: ,p_base_value => g_abs_rounding_precision
11815: ,p_rounding_type => g_abs_rounding_type
11816: ) ;

Line 11818: p_band4_4year_ent_used := pqp_utilities.round_value_up_down

11814: ,p_base_value => g_abs_rounding_precision
11815: ,p_rounding_type => g_abs_rounding_type
11816: ) ;
11817:
11818: p_band4_4year_ent_used := pqp_utilities.round_value_up_down
11819: (p_value_to_round => p_band4_4year_ent_used
11820: ,p_base_value => g_abs_rounding_precision
11821: ,p_rounding_type => g_abs_rounding_type
11822: ) ;

Line 11823: p_noband_4year_ent_used := pqp_utilities.round_value_up_down

11819: (p_value_to_round => p_band4_4year_ent_used
11820: ,p_base_value => g_abs_rounding_precision
11821: ,p_rounding_type => g_abs_rounding_type
11822: ) ;
11823: p_noband_4year_ent_used := pqp_utilities.round_value_up_down
11824: (p_value_to_round => p_noband_4year_ent_used
11825: ,p_base_value => g_abs_rounding_precision
11826: ,p_rounding_type => g_abs_rounding_type
11827: ) ;