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 10850: pqp_utilities.pqp_gb_get_table_value_id(

10846: debug('l_column_name:'||l_get_lookup_info.meaning);
10847: END IF ;
10848:
10849: l_retval :=
10850: pqp_utilities.pqp_gb_get_table_value_id(
10851: p_business_group_id => p_business_group_id
10852: ,p_effective_date => p_effective_date
10853: ,p_table_id => p_entitlement_table_id
10854: ,p_column_name => l_get_lookup_info.meaning

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

11108: );
11109:
11110:
11111: IF l_ret_num <> 0 THEN
11112: pqp_utilities.check_error_code(l_ret_num, l_err);
11113: END IF;
11114:
11115: l_proc_step := 20;
11116:

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

11131: ,p_error_msg => l_err
11132: );
11133:
11134: IF l_ret_num <> 0 THEN
11135: pqp_utilities.check_error_code(l_ret_num, l_err);
11136: END IF;
11137:
11138: l_proc_step := 30;
11139:

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

11157: );
11158:
11159:
11160: IF l_ret_num <> 0 THEN
11161: pqp_utilities.check_error_code(l_ret_num, l_err);
11162: END IF;
11163:
11164: l_proc_step := 35;
11165:

Line 11210: pqp_utilities.debug_others

11206:
11207: EXCEPTION
11208: WHEN OTHERS THEN
11209: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
11210: pqp_utilities.debug_others
11211: (l_proc_name
11212: ,l_proc_step
11213: );
11214: IF g_debug THEN

Line 11630: PQP_UTILITIES.pqp_get_config_value(

11626: END IF;
11627:
11628:
11629: l_abs_precision :=
11630: PQP_UTILITIES.pqp_get_config_value(
11631: p_business_group_id => p_business_group_id
11632: ,p_legislation_code => 'GB'
11633: ,p_column_name => 'PCV_INFORMATION7'
11634: ,p_information_category => 'PQP_GB_OSP_OMP_CONFIG'

Line 11757: p_band1_remaining := pqp_utilities.round_value_up_down

11753:
11754:
11755: --Round Absence remaining figures
11756:
11757: p_band1_remaining := pqp_utilities.round_value_up_down
11758: (p_value_to_round => p_band1_remaining
11759: ,p_base_value => g_abs_rounding_precision
11760: ,p_rounding_type => g_abs_rounding_type
11761: ) ;

Line 11763: p_band2_remaining := pqp_utilities.round_value_up_down

11759: ,p_base_value => g_abs_rounding_precision
11760: ,p_rounding_type => g_abs_rounding_type
11761: ) ;
11762:
11763: p_band2_remaining := pqp_utilities.round_value_up_down
11764: (p_value_to_round => p_band2_remaining
11765: ,p_base_value => g_abs_rounding_precision
11766: ,p_rounding_type => g_abs_rounding_type
11767: ) ;

Line 11770: p_band3_remaining := pqp_utilities.round_value_up_down

11766: ,p_rounding_type => g_abs_rounding_type
11767: ) ;
11768:
11769:
11770: p_band3_remaining := pqp_utilities.round_value_up_down
11771: (p_value_to_round => p_band3_remaining
11772: ,p_base_value => g_abs_rounding_precision
11773: ,p_rounding_type => g_abs_rounding_type
11774: ) ;

Line 11776: p_band4_remaining := pqp_utilities.round_value_up_down

11772: ,p_base_value => g_abs_rounding_precision
11773: ,p_rounding_type => g_abs_rounding_type
11774: ) ;
11775:
11776: p_band4_remaining := pqp_utilities.round_value_up_down
11777: (p_value_to_round => p_band4_remaining
11778: ,p_base_value => g_abs_rounding_precision
11779: ,p_rounding_type => g_abs_rounding_type
11780: ) ;

Line 11788: p_band1_ent_used := pqp_utilities.round_value_up_down

11784: END IF;
11785:
11786: --Round Absence Used One year figures
11787:
11788: p_band1_ent_used := pqp_utilities.round_value_up_down
11789: (p_value_to_round => p_band1_ent_used
11790: ,p_base_value => g_abs_rounding_precision
11791: ,p_rounding_type => g_abs_rounding_type
11792: ) ;

Line 11794: p_band2_ent_used := pqp_utilities.round_value_up_down

11790: ,p_base_value => g_abs_rounding_precision
11791: ,p_rounding_type => g_abs_rounding_type
11792: ) ;
11793:
11794: p_band2_ent_used := pqp_utilities.round_value_up_down
11795: (p_value_to_round => p_band2_ent_used
11796: ,p_base_value => g_abs_rounding_precision
11797: ,p_rounding_type => g_abs_rounding_type
11798: ) ;

Line 11801: p_band3_ent_used := pqp_utilities.round_value_up_down

11797: ,p_rounding_type => g_abs_rounding_type
11798: ) ;
11799:
11800:
11801: p_band3_ent_used := pqp_utilities.round_value_up_down
11802: (p_value_to_round => p_band3_ent_used
11803: ,p_base_value => g_abs_rounding_precision
11804: ,p_rounding_type => g_abs_rounding_type
11805: ) ;

Line 11807: p_band4_ent_used := pqp_utilities.round_value_up_down

11803: ,p_base_value => g_abs_rounding_precision
11804: ,p_rounding_type => g_abs_rounding_type
11805: ) ;
11806:
11807: p_band4_ent_used := pqp_utilities.round_value_up_down
11808: (p_value_to_round => p_band4_ent_used
11809: ,p_base_value => g_abs_rounding_precision
11810: ,p_rounding_type => g_abs_rounding_type
11811: ) ;

Line 11813: p_noband_ent_used := pqp_utilities.round_value_up_down

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

Line 11828: p_band1_4year_ent_used := pqp_utilities.round_value_up_down

11824: IF g_debug THEN
11825: debug(l_proc_name,65);
11826: END IF;
11827:
11828: p_band1_4year_ent_used := pqp_utilities.round_value_up_down
11829: (p_value_to_round => p_band1_4year_ent_used
11830: ,p_base_value => g_abs_rounding_precision
11831: ,p_rounding_type => g_abs_rounding_type
11832: ) ;

Line 11834: p_band2_4year_ent_used := pqp_utilities.round_value_up_down

11830: ,p_base_value => g_abs_rounding_precision
11831: ,p_rounding_type => g_abs_rounding_type
11832: ) ;
11833:
11834: p_band2_4year_ent_used := pqp_utilities.round_value_up_down
11835: (p_value_to_round => p_band2_4year_ent_used
11836: ,p_base_value => g_abs_rounding_precision
11837: ,p_rounding_type => g_abs_rounding_type
11838: ) ;

Line 11841: p_band3_4year_ent_used := pqp_utilities.round_value_up_down

11837: ,p_rounding_type => g_abs_rounding_type
11838: ) ;
11839:
11840:
11841: p_band3_4year_ent_used := pqp_utilities.round_value_up_down
11842: (p_value_to_round => p_band3_4year_ent_used
11843: ,p_base_value => g_abs_rounding_precision
11844: ,p_rounding_type => g_abs_rounding_type
11845: ) ;

Line 11847: p_band4_4year_ent_used := pqp_utilities.round_value_up_down

11843: ,p_base_value => g_abs_rounding_precision
11844: ,p_rounding_type => g_abs_rounding_type
11845: ) ;
11846:
11847: p_band4_4year_ent_used := pqp_utilities.round_value_up_down
11848: (p_value_to_round => p_band4_4year_ent_used
11849: ,p_base_value => g_abs_rounding_precision
11850: ,p_rounding_type => g_abs_rounding_type
11851: ) ;

Line 11852: p_noband_4year_ent_used := pqp_utilities.round_value_up_down

11848: (p_value_to_round => p_band4_4year_ent_used
11849: ,p_base_value => g_abs_rounding_precision
11850: ,p_rounding_type => g_abs_rounding_type
11851: ) ;
11852: p_noband_4year_ent_used := pqp_utilities.round_value_up_down
11853: (p_value_to_round => p_noband_4year_ent_used
11854: ,p_base_value => g_abs_rounding_precision
11855: ,p_rounding_type => g_abs_rounding_type
11856: ) ;