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_PENSION_FUNCTIONS dependencies on PQP_UTILITIES

Line 648: pqp_utilities.debug(' p_business_group_id is ' || p_business_group_id );

644: l_debug := hr_utility.debug_enabled;
645:
646:
647: IF l_debug THEN
648: pqp_utilities.debug(' p_business_group_id is ' || p_business_group_id );
649: pqp_utilities.debug(' p_date_earned is ' || p_date_earned );
650: pqp_utilities.debug(' p_assignment_id is ' || p_assignment_id );
651: pqp_utilities.debug(' p_amount is ' || p_amount );
652: pqp_utilities.debug(' p_payroll_period is ' || p_payroll_period );

Line 649: pqp_utilities.debug(' p_date_earned is ' || p_date_earned );

645:
646:
647: IF l_debug THEN
648: pqp_utilities.debug(' p_business_group_id is ' || p_business_group_id );
649: pqp_utilities.debug(' p_date_earned is ' || p_date_earned );
650: pqp_utilities.debug(' p_assignment_id is ' || p_assignment_id );
651: pqp_utilities.debug(' p_amount is ' || p_amount );
652: pqp_utilities.debug(' p_payroll_period is ' || p_payroll_period );
653: pqp_utilities.debug(' l_payroll_period is ' || l_payroll_period );

Line 650: pqp_utilities.debug(' p_assignment_id is ' || p_assignment_id );

646:
647: IF l_debug THEN
648: pqp_utilities.debug(' p_business_group_id is ' || p_business_group_id );
649: pqp_utilities.debug(' p_date_earned is ' || p_date_earned );
650: pqp_utilities.debug(' p_assignment_id is ' || p_assignment_id );
651: pqp_utilities.debug(' p_amount is ' || p_amount );
652: pqp_utilities.debug(' p_payroll_period is ' || p_payroll_period );
653: pqp_utilities.debug(' l_payroll_period is ' || l_payroll_period );
654: pqp_utilities.debug(' p_work_pattern is ' || p_work_pattern );

Line 651: pqp_utilities.debug(' p_amount is ' || p_amount );

647: IF l_debug THEN
648: pqp_utilities.debug(' p_business_group_id is ' || p_business_group_id );
649: pqp_utilities.debug(' p_date_earned is ' || p_date_earned );
650: pqp_utilities.debug(' p_assignment_id is ' || p_assignment_id );
651: pqp_utilities.debug(' p_amount is ' || p_amount );
652: pqp_utilities.debug(' p_payroll_period is ' || p_payroll_period );
653: pqp_utilities.debug(' l_payroll_period is ' || l_payroll_period );
654: pqp_utilities.debug(' p_work_pattern is ' || p_work_pattern );
655: pqp_utilities.debug(' p_conversion_rule is ' || p_conversion_rule );

Line 652: pqp_utilities.debug(' p_payroll_period is ' || p_payroll_period );

648: pqp_utilities.debug(' p_business_group_id is ' || p_business_group_id );
649: pqp_utilities.debug(' p_date_earned is ' || p_date_earned );
650: pqp_utilities.debug(' p_assignment_id is ' || p_assignment_id );
651: pqp_utilities.debug(' p_amount is ' || p_amount );
652: pqp_utilities.debug(' p_payroll_period is ' || p_payroll_period );
653: pqp_utilities.debug(' l_payroll_period is ' || l_payroll_period );
654: pqp_utilities.debug(' p_work_pattern is ' || p_work_pattern );
655: pqp_utilities.debug(' p_conversion_rule is ' || p_conversion_rule );
656: pqp_utilities.debug(' p_prorated_amount is ' || p_prorated_amount );

Line 653: pqp_utilities.debug(' l_payroll_period is ' || l_payroll_period );

649: pqp_utilities.debug(' p_date_earned is ' || p_date_earned );
650: pqp_utilities.debug(' p_assignment_id is ' || p_assignment_id );
651: pqp_utilities.debug(' p_amount is ' || p_amount );
652: pqp_utilities.debug(' p_payroll_period is ' || p_payroll_period );
653: pqp_utilities.debug(' l_payroll_period is ' || l_payroll_period );
654: pqp_utilities.debug(' p_work_pattern is ' || p_work_pattern );
655: pqp_utilities.debug(' p_conversion_rule is ' || p_conversion_rule );
656: pqp_utilities.debug(' p_prorated_amount is ' || p_prorated_amount );
657: pqp_utilities.debug(' p_error_message is ' || p_error_message );

Line 654: pqp_utilities.debug(' p_work_pattern is ' || p_work_pattern );

650: pqp_utilities.debug(' p_assignment_id is ' || p_assignment_id );
651: pqp_utilities.debug(' p_amount is ' || p_amount );
652: pqp_utilities.debug(' p_payroll_period is ' || p_payroll_period );
653: pqp_utilities.debug(' l_payroll_period is ' || l_payroll_period );
654: pqp_utilities.debug(' p_work_pattern is ' || p_work_pattern );
655: pqp_utilities.debug(' p_conversion_rule is ' || p_conversion_rule );
656: pqp_utilities.debug(' p_prorated_amount is ' || p_prorated_amount );
657: pqp_utilities.debug(' p_error_message is ' || p_error_message );
658: pqp_utilities.debug(' p_payroll_period_prorate is ' || p_payroll_period_prorate);

Line 655: pqp_utilities.debug(' p_conversion_rule is ' || p_conversion_rule );

651: pqp_utilities.debug(' p_amount is ' || p_amount );
652: pqp_utilities.debug(' p_payroll_period is ' || p_payroll_period );
653: pqp_utilities.debug(' l_payroll_period is ' || l_payroll_period );
654: pqp_utilities.debug(' p_work_pattern is ' || p_work_pattern );
655: pqp_utilities.debug(' p_conversion_rule is ' || p_conversion_rule );
656: pqp_utilities.debug(' p_prorated_amount is ' || p_prorated_amount );
657: pqp_utilities.debug(' p_error_message is ' || p_error_message );
658: pqp_utilities.debug(' p_payroll_period_prorate is ' || p_payroll_period_prorate);
659: END IF;

Line 656: pqp_utilities.debug(' p_prorated_amount is ' || p_prorated_amount );

652: pqp_utilities.debug(' p_payroll_period is ' || p_payroll_period );
653: pqp_utilities.debug(' l_payroll_period is ' || l_payroll_period );
654: pqp_utilities.debug(' p_work_pattern is ' || p_work_pattern );
655: pqp_utilities.debug(' p_conversion_rule is ' || p_conversion_rule );
656: pqp_utilities.debug(' p_prorated_amount is ' || p_prorated_amount );
657: pqp_utilities.debug(' p_error_message is ' || p_error_message );
658: pqp_utilities.debug(' p_payroll_period_prorate is ' || p_payroll_period_prorate);
659: END IF;
660:

Line 657: pqp_utilities.debug(' p_error_message is ' || p_error_message );

653: pqp_utilities.debug(' l_payroll_period is ' || l_payroll_period );
654: pqp_utilities.debug(' p_work_pattern is ' || p_work_pattern );
655: pqp_utilities.debug(' p_conversion_rule is ' || p_conversion_rule );
656: pqp_utilities.debug(' p_prorated_amount is ' || p_prorated_amount );
657: pqp_utilities.debug(' p_error_message is ' || p_error_message );
658: pqp_utilities.debug(' p_payroll_period_prorate is ' || p_payroll_period_prorate);
659: END IF;
660:
661:

Line 658: pqp_utilities.debug(' p_payroll_period_prorate is ' || p_payroll_period_prorate);

654: pqp_utilities.debug(' p_work_pattern is ' || p_work_pattern );
655: pqp_utilities.debug(' p_conversion_rule is ' || p_conversion_rule );
656: pqp_utilities.debug(' p_prorated_amount is ' || p_prorated_amount );
657: pqp_utilities.debug(' p_error_message is ' || p_error_message );
658: pqp_utilities.debug(' p_payroll_period_prorate is ' || p_payroll_period_prorate);
659: END IF;
660:
661:
662: --IF ( l_payroll_period LIKE '%Calendar Month' --12578980

Line 929: pqp_utilities.debug(' l_pay_prorate_period '|| l_pay_prorate_period, 4);

925:
926: END IF;
927:
928: IF l_debug THEN
929: pqp_utilities.debug(' l_pay_prorate_period '|| l_pay_prorate_period, 4);
930: pqp_utilities.debug(' l_pay_period ' || l_pay_period, 5);
931: pqp_utilities.debug(' l_ret_val ' || l_ret_val, 5);
932: END IF;
933:

Line 930: pqp_utilities.debug(' l_pay_period ' || l_pay_period, 5);

926: END IF;
927:
928: IF l_debug THEN
929: pqp_utilities.debug(' l_pay_prorate_period '|| l_pay_prorate_period, 4);
930: pqp_utilities.debug(' l_pay_period ' || l_pay_period, 5);
931: pqp_utilities.debug(' l_ret_val ' || l_ret_val, 5);
932: END IF;
933:
934: -- IF the pay period is not the same as the proration period

Line 931: pqp_utilities.debug(' l_ret_val ' || l_ret_val, 5);

927:
928: IF l_debug THEN
929: pqp_utilities.debug(' l_pay_prorate_period '|| l_pay_prorate_period, 4);
930: pqp_utilities.debug(' l_pay_period ' || l_pay_period, 5);
931: pqp_utilities.debug(' l_ret_val ' || l_ret_val, 5);
932: END IF;
933:
934: -- IF the pay period is not the same as the proration period
935: -- then no calculation to be done.

Line 948: pqp_utilities.debug(' l_pay_start_dt is '|| l_pay_start_dt , 60);

944: AND l_pay_end_dt IS NOT NULL)THEN
945: CLOSE c_get_start_end_date;
946:
947: IF l_debug THEN
948: pqp_utilities.debug(' l_pay_start_dt is '|| l_pay_start_dt , 60);
949: pqp_utilities.debug(' l_pay_end_dt is '|| l_pay_end_dt , 70);
950: END IF;
951: /*12578980 Closing open cursor - encountered 'cursor already open' while testing*/
952: ELSE

Line 949: pqp_utilities.debug(' l_pay_end_dt is '|| l_pay_end_dt , 70);

945: CLOSE c_get_start_end_date;
946:
947: IF l_debug THEN
948: pqp_utilities.debug(' l_pay_start_dt is '|| l_pay_start_dt , 60);
949: pqp_utilities.debug(' l_pay_end_dt is '|| l_pay_end_dt , 70);
950: END IF;
951: /*12578980 Closing open cursor - encountered 'cursor already open' while testing*/
952: ELSE
953: CLOSE c_get_start_end_date;

Line 969: pqp_utilities.debug(' l_payroll_days is '|| l_payroll_days , 80);

965: CLOSE c_no_of_days;
966: END IF;
967:
968: IF l_debug THEN
969: pqp_utilities.debug(' l_payroll_days is '|| l_payroll_days , 80);
970: END IF;
971:
972: -- 0 corresponds to Average working days
973: IF p_conversion_rule = '0' THEN

Line 984: pqp_utilities.debug(' l_ass_start_dt is '|| l_ass_start_dt , 91);

980: IF (c_get_assign_start_date%FOUND
981: AND l_ass_start_dt IS NOT NULL)THEN
982: CLOSE c_get_assign_start_date;
983: IF l_debug THEN
984: pqp_utilities.debug(' l_ass_start_dt is '|| l_ass_start_dt , 91);
985: pqp_utilities.debug(' l_term_date is '|| l_term_date , 91);
986: END IF;
987: ELSE
988: CLOSE c_get_assign_start_date;

Line 985: pqp_utilities.debug(' l_term_date is '|| l_term_date , 91);

981: AND l_ass_start_dt IS NOT NULL)THEN
982: CLOSE c_get_assign_start_date;
983: IF l_debug THEN
984: pqp_utilities.debug(' l_ass_start_dt is '|| l_ass_start_dt , 91);
985: pqp_utilities.debug(' l_term_date is '|| l_term_date , 91);
986: END IF;
987: ELSE
988: CLOSE c_get_assign_start_date;
989: p_prorated_amount := 0;

Line 1010: pqp_utilities.debug(' l_next_term_date is '|| l_next_term_date , 92);

1006: IF (c_get_asg_end_date%FOUND)THEN
1007: CLOSE c_get_asg_end_date;
1008: l_term_date := l_next_term_date;
1009: IF l_debug THEN
1010: pqp_utilities.debug(' l_next_term_date is '|| l_next_term_date , 92);
1011: END IF;
1012: ELSE
1013: CLOSE c_get_asg_end_date;
1014: END IF; -- assignment end date found

Line 1018: pqp_utilities.debug(' l_term_date is '|| l_term_date , 91);

1014: END IF; -- assignment end date found
1015: END IF;-- term date is not null
1016:
1017: IF l_debug THEN
1018: pqp_utilities.debug(' l_term_date is '|| l_term_date , 91);
1019: END IF;
1020:
1021: /* -- get termination date
1022: OPEN c_get_ass_term_date(p_assignment_id,l_pay_start_dt,l_pay_end_dt);

Line 1027: pqp_utilities.debug(' l_term_date is '|| l_term_date , 101);

1023: FETCH c_get_ass_term_date into l_term_date;
1024: IF (c_get_ass_term_date%FOUND AND l_term_date IS NOT NULL)THEN
1025: CLOSE c_get_ass_term_date;
1026: IF l_debug THEN
1027: pqp_utilities.debug(' l_term_date is '|| l_term_date , 101);
1028: END IF;
1029: ELSE
1030: CLOSE c_get_ass_term_date;
1031: END IF;-- get termination dt

Line 1041: pqp_utilities.debug(' l_actual_work_days is '|| l_actual_work_days , 105);

1037: FETCH c_no_of_days into l_days;
1038: IF (c_no_of_days%FOUND AND l_days IS NOT NULL)THEN
1039: CLOSE c_no_of_days;
1040: l_actual_work_days := l_days;
1041: pqp_utilities.debug(' l_actual_work_days is '|| l_actual_work_days , 105);
1042: ELSE
1043: CLOSE c_no_of_days;
1044: END IF;
1045: ELSE

Line 1051: pqp_utilities.debug(' l_actual_work_days is '|| l_actual_work_days , 106);

1047: FETCH c_no_of_days into l_days;
1048: IF (c_no_of_days%FOUND AND l_days IS NOT NULL)THEN
1049: CLOSE c_no_of_days;
1050: l_actual_work_days := l_days;
1051: pqp_utilities.debug(' l_actual_work_days is '|| l_actual_work_days , 106);
1052: pqp_utilities.debug(' l_days is '|| l_days , 107);
1053: ELSE
1054: CLOSE c_no_of_days;
1055: END IF;

Line 1052: pqp_utilities.debug(' l_days is '|| l_days , 107);

1048: IF (c_no_of_days%FOUND AND l_days IS NOT NULL)THEN
1049: CLOSE c_no_of_days;
1050: l_actual_work_days := l_days;
1051: pqp_utilities.debug(' l_actual_work_days is '|| l_actual_work_days , 106);
1052: pqp_utilities.debug(' l_days is '|| l_days , 107);
1053: ELSE
1054: CLOSE c_no_of_days;
1055: END IF;
1056: END IF;

Line 1082: pqp_utilities.debug(' l_average_days_divisor is '|| l_average_days_divisor , 151);

1078: l_pay_end_dt := l_term_date;
1079: END IF;
1080:
1081: IF l_debug THEN
1082: pqp_utilities.debug(' l_average_days_divisor is '|| l_average_days_divisor , 151);
1083: pqp_utilities.debug(' l_payroll_days is '|| l_payroll_days , 161);
1084: pqp_utilities.debug(' l_actual_work_days is '|| l_actual_work_days , 171);
1085: pqp_utilities.debug(' l_pay_start_dt is '|| l_pay_start_dt , 173);
1086: pqp_utilities.debug(' l_pay_end_dt is '|| l_pay_end_dt , 176);

Line 1083: pqp_utilities.debug(' l_payroll_days is '|| l_payroll_days , 161);

1079: END IF;
1080:
1081: IF l_debug THEN
1082: pqp_utilities.debug(' l_average_days_divisor is '|| l_average_days_divisor , 151);
1083: pqp_utilities.debug(' l_payroll_days is '|| l_payroll_days , 161);
1084: pqp_utilities.debug(' l_actual_work_days is '|| l_actual_work_days , 171);
1085: pqp_utilities.debug(' l_pay_start_dt is '|| l_pay_start_dt , 173);
1086: pqp_utilities.debug(' l_pay_end_dt is '|| l_pay_end_dt , 176);
1087: END IF;

Line 1084: pqp_utilities.debug(' l_actual_work_days is '|| l_actual_work_days , 171);

1080:
1081: IF l_debug THEN
1082: pqp_utilities.debug(' l_average_days_divisor is '|| l_average_days_divisor , 151);
1083: pqp_utilities.debug(' l_payroll_days is '|| l_payroll_days , 161);
1084: pqp_utilities.debug(' l_actual_work_days is '|| l_actual_work_days , 171);
1085: pqp_utilities.debug(' l_pay_start_dt is '|| l_pay_start_dt , 173);
1086: pqp_utilities.debug(' l_pay_end_dt is '|| l_pay_end_dt , 176);
1087: END IF;
1088:

Line 1085: pqp_utilities.debug(' l_pay_start_dt is '|| l_pay_start_dt , 173);

1081: IF l_debug THEN
1082: pqp_utilities.debug(' l_average_days_divisor is '|| l_average_days_divisor , 151);
1083: pqp_utilities.debug(' l_payroll_days is '|| l_payroll_days , 161);
1084: pqp_utilities.debug(' l_actual_work_days is '|| l_actual_work_days , 171);
1085: pqp_utilities.debug(' l_pay_start_dt is '|| l_pay_start_dt , 173);
1086: pqp_utilities.debug(' l_pay_end_dt is '|| l_pay_end_dt , 176);
1087: END IF;
1088:
1089: -- assignment level overrides

Line 1086: pqp_utilities.debug(' l_pay_end_dt is '|| l_pay_end_dt , 176);

1082: pqp_utilities.debug(' l_average_days_divisor is '|| l_average_days_divisor , 151);
1083: pqp_utilities.debug(' l_payroll_days is '|| l_payroll_days , 161);
1084: pqp_utilities.debug(' l_actual_work_days is '|| l_actual_work_days , 171);
1085: pqp_utilities.debug(' l_pay_start_dt is '|| l_pay_start_dt , 173);
1086: pqp_utilities.debug(' l_pay_end_dt is '|| l_pay_end_dt , 176);
1087: END IF;
1088:
1089: -- assignment level overrides
1090: OPEN c_get_avg_si_assignment(p_assignment_id);

Line 1098: pqp_utilities.debug(' c_get_avg_si_assignment found ', 4);

1094: AND l_override_method IS NOT NULL)THEN
1095: CLOSE c_get_avg_si_assignment;
1096:
1097: IF l_debug THEN
1098: pqp_utilities.debug(' c_get_avg_si_assignment found ', 4);
1099: pqp_utilities.debug(' l_override_method ' || l_override_method, 5);
1100: pqp_utilities.debug(' l_overridden_avgsi_assignment ' || l_overridden_avgsi_assignment ,6);
1101: END IF;
1102:

Line 1099: pqp_utilities.debug(' l_override_method ' || l_override_method, 5);

1095: CLOSE c_get_avg_si_assignment;
1096:
1097: IF l_debug THEN
1098: pqp_utilities.debug(' c_get_avg_si_assignment found ', 4);
1099: pqp_utilities.debug(' l_override_method ' || l_override_method, 5);
1100: pqp_utilities.debug(' l_overridden_avgsi_assignment ' || l_overridden_avgsi_assignment ,6);
1101: END IF;
1102:
1103: IF (l_override_method = 0) THEN --'Manual Entry'

Line 1100: pqp_utilities.debug(' l_overridden_avgsi_assignment ' || l_overridden_avgsi_assignment ,6);

1096:
1097: IF l_debug THEN
1098: pqp_utilities.debug(' c_get_avg_si_assignment found ', 4);
1099: pqp_utilities.debug(' l_override_method ' || l_override_method, 5);
1100: pqp_utilities.debug(' l_overridden_avgsi_assignment ' || l_overridden_avgsi_assignment ,6);
1101: END IF;
1102:
1103: IF (l_override_method = 0) THEN --'Manual Entry'
1104: l_average_days_multiplier := l_overridden_avgsi_assignment;

Line 1144: pqp_utilities.debug(' l_max_si_method ' || l_max_si_method, 5);

1140: l_average_days_multiplier :=
1141: l_max_si_days * l_overridden_avgsi_assignment/100;
1142:
1143: IF l_debug THEN
1144: pqp_utilities.debug(' l_max_si_method ' || l_max_si_method, 5);
1145: pqp_utilities.debug(' l_max_si_days ' || l_max_si_days ,6);
1146: END IF;
1147: END IF;
1148:

Line 1145: pqp_utilities.debug(' l_max_si_days ' || l_max_si_days ,6);

1141: l_max_si_days * l_overridden_avgsi_assignment/100;
1142:
1143: IF l_debug THEN
1144: pqp_utilities.debug(' l_max_si_method ' || l_max_si_method, 5);
1145: pqp_utilities.debug(' l_max_si_days ' || l_max_si_days ,6);
1146: END IF;
1147: END IF;
1148:
1149: END IF;

Line 1152: pqp_utilities.debug(' l_average_days_multiplier found '|| l_average_days_multiplier,7);

1148:
1149: END IF;
1150:
1151: IF l_debug THEN
1152: pqp_utilities.debug(' l_average_days_multiplier found '|| l_average_days_multiplier,7);
1153: END IF;
1154:
1155: ELSIF (c_get_avg_si_assignment%FOUND
1156: AND

Line 1180: pqp_utilities.debug(' c_get_avg_si_assignment not found ', 4);

1176: l_average_days_multiplier := (l_average_days_multiplier/l_payroll_days * l_actual_work_days);
1177: END IF;
1178:
1179: IF l_debug THEN
1180: pqp_utilities.debug(' c_get_avg_si_assignment not found ', 4);
1181: END IF;
1182: END IF;-- check for override at assignment level.
1183:
1184:

Line 1200: pqp_utilities.debug(' l_pay_start_dt is '|| l_pay_start_dt , 60);

1196: AND l_pay_end_dt IS NOT NULL)THEN
1197: CLOSE c_get_start_end_date;
1198:
1199: IF l_debug THEN
1200: pqp_utilities.debug(' l_pay_start_dt is '|| l_pay_start_dt , 60);
1201: pqp_utilities.debug(' l_pay_end_dt is '|| l_pay_end_dt , 70);
1202: END IF;
1203:
1204:

Line 1201: pqp_utilities.debug(' l_pay_end_dt is '|| l_pay_end_dt , 70);

1197: CLOSE c_get_start_end_date;
1198:
1199: IF l_debug THEN
1200: pqp_utilities.debug(' l_pay_start_dt is '|| l_pay_start_dt , 60);
1201: pqp_utilities.debug(' l_pay_end_dt is '|| l_pay_end_dt , 70);
1202: END IF;
1203:
1204:
1205: -- get average days in the payroll

Line 1217: pqp_utilities.debug(' l_payroll_days is '|| l_payroll_days , 80);

1213: CLOSE c_no_of_days;
1214: END IF;
1215:
1216: IF l_debug THEN
1217: pqp_utilities.debug(' l_payroll_days is '|| l_payroll_days , 80);
1218: END IF;
1219:
1220: -- check if the assignment has started in this payroll period.
1221: OPEN c_get_assign_start_date(p_assignment_id,l_pay_start_dt,l_pay_end_dt);

Line 1227: pqp_utilities.debug(' l_ass_start_dt is '|| l_ass_start_dt , 92);

1223: IF (c_get_assign_start_date%FOUND
1224: AND l_ass_start_dt IS NOT NULL)THEN
1225: CLOSE c_get_assign_start_date;
1226: IF l_debug THEN
1227: pqp_utilities.debug(' l_ass_start_dt is '|| l_ass_start_dt , 92);
1228: END IF;
1229: ELSE
1230: CLOSE c_get_assign_start_date;
1231: p_prorated_amount := 0;

Line 1250: pqp_utilities.debug(' l_next_term_date is '|| l_next_term_date , 92);

1246: IF (c_get_asg_end_date%FOUND)THEN
1247: CLOSE c_get_asg_end_date;
1248: l_term_date := l_next_term_date;
1249: IF l_debug THEN
1250: pqp_utilities.debug(' l_next_term_date is '|| l_next_term_date , 92);
1251: END IF;
1252: ELSE
1253: CLOSE c_get_asg_end_date;
1254: END IF; -- assignment end date found

Line 1258: pqp_utilities.debug(' l_term_date is '|| l_term_date , 91);

1254: END IF; -- assignment end date found
1255: END IF;-- term date is not null
1256:
1257: IF l_debug THEN
1258: pqp_utilities.debug(' l_term_date is '|| l_term_date , 91);
1259: END IF;
1260:
1261: /* -- get termination date
1262: OPEN c_get_ass_term_date(p_assignment_id,l_pay_start_dt,l_pay_end_dt);

Line 1267: pqp_utilities.debug(' l_term_date is '|| l_term_date , 102);

1263: FETCH c_get_ass_term_date into l_term_date;
1264: IF (c_get_ass_term_date%FOUND AND l_term_date IS NOT NULL)THEN
1265: CLOSE c_get_ass_term_date;
1266: IF l_debug THEN
1267: pqp_utilities.debug(' l_term_date is '|| l_term_date , 102);
1268: END IF;
1269: ELSE
1270: CLOSE c_get_ass_term_date;
1271: END IF;-- get termination dt

Line 1284: pqp_utilities.debug(' l_actual_work_days 1 is '|| l_actual_work_days , 105);

1280: FETCH c_no_of_days into l_days;
1281: IF (c_no_of_days%FOUND AND l_days IS NOT NULL)THEN
1282: CLOSE c_no_of_days;
1283: l_actual_work_days := l_days;
1284: pqp_utilities.debug(' l_actual_work_days 1 is '|| l_actual_work_days , 105);
1285: ELSE
1286: CLOSE c_no_of_days;
1287: END IF;
1288: ELSE

Line 1294: pqp_utilities.debug(' l_actual_work_days 0 is '|| l_actual_work_days , 105);

1290: FETCH c_no_of_days into l_days;
1291: IF (c_no_of_days%FOUND AND l_days IS NOT NULL)THEN
1292: CLOSE c_no_of_days;
1293: l_actual_work_days := l_days;
1294: pqp_utilities.debug(' l_actual_work_days 0 is '|| l_actual_work_days , 105);
1295: pqp_utilities.debug(' l_days 0 is '|| l_days , 105);
1296: ELSE
1297: CLOSE c_no_of_days;
1298: END IF;

Line 1295: pqp_utilities.debug(' l_days 0 is '|| l_days , 105);

1291: IF (c_no_of_days%FOUND AND l_days IS NOT NULL)THEN
1292: CLOSE c_no_of_days;
1293: l_actual_work_days := l_days;
1294: pqp_utilities.debug(' l_actual_work_days 0 is '|| l_actual_work_days , 105);
1295: pqp_utilities.debug(' l_days 0 is '|| l_days , 105);
1296: ELSE
1297: CLOSE c_no_of_days;
1298: END IF;
1299: END IF;

Line 1325: pqp_utilities.debug(' l_average_days_divisor is '|| l_average_days_divisor , 150);

1321: l_pay_end_dt := l_term_date;
1322: END IF;
1323:
1324: IF l_debug THEN
1325: pqp_utilities.debug(' l_average_days_divisor is '|| l_average_days_divisor , 150);
1326: pqp_utilities.debug(' l_payroll_days is '|| l_payroll_days , 160);
1327: pqp_utilities.debug(' l_actual_work_days is '|| l_actual_work_days , 170);
1328: pqp_utilities.debug(' l_pay_start_dt is '|| l_pay_start_dt , 172);
1329: pqp_utilities.debug(' l_pay_end_dt is '|| l_pay_end_dt , 175);

Line 1326: pqp_utilities.debug(' l_payroll_days is '|| l_payroll_days , 160);

1322: END IF;
1323:
1324: IF l_debug THEN
1325: pqp_utilities.debug(' l_average_days_divisor is '|| l_average_days_divisor , 150);
1326: pqp_utilities.debug(' l_payroll_days is '|| l_payroll_days , 160);
1327: pqp_utilities.debug(' l_actual_work_days is '|| l_actual_work_days , 170);
1328: pqp_utilities.debug(' l_pay_start_dt is '|| l_pay_start_dt , 172);
1329: pqp_utilities.debug(' l_pay_end_dt is '|| l_pay_end_dt , 175);
1330: END IF;

Line 1327: pqp_utilities.debug(' l_actual_work_days is '|| l_actual_work_days , 170);

1323:
1324: IF l_debug THEN
1325: pqp_utilities.debug(' l_average_days_divisor is '|| l_average_days_divisor , 150);
1326: pqp_utilities.debug(' l_payroll_days is '|| l_payroll_days , 160);
1327: pqp_utilities.debug(' l_actual_work_days is '|| l_actual_work_days , 170);
1328: pqp_utilities.debug(' l_pay_start_dt is '|| l_pay_start_dt , 172);
1329: pqp_utilities.debug(' l_pay_end_dt is '|| l_pay_end_dt , 175);
1330: END IF;
1331:

Line 1328: pqp_utilities.debug(' l_pay_start_dt is '|| l_pay_start_dt , 172);

1324: IF l_debug THEN
1325: pqp_utilities.debug(' l_average_days_divisor is '|| l_average_days_divisor , 150);
1326: pqp_utilities.debug(' l_payroll_days is '|| l_payroll_days , 160);
1327: pqp_utilities.debug(' l_actual_work_days is '|| l_actual_work_days , 170);
1328: pqp_utilities.debug(' l_pay_start_dt is '|| l_pay_start_dt , 172);
1329: pqp_utilities.debug(' l_pay_end_dt is '|| l_pay_end_dt , 175);
1330: END IF;
1331:
1332: -- assignment level overrides

Line 1329: pqp_utilities.debug(' l_pay_end_dt is '|| l_pay_end_dt , 175);

1325: pqp_utilities.debug(' l_average_days_divisor is '|| l_average_days_divisor , 150);
1326: pqp_utilities.debug(' l_payroll_days is '|| l_payroll_days , 160);
1327: pqp_utilities.debug(' l_actual_work_days is '|| l_actual_work_days , 170);
1328: pqp_utilities.debug(' l_pay_start_dt is '|| l_pay_start_dt , 172);
1329: pqp_utilities.debug(' l_pay_end_dt is '|| l_pay_end_dt , 175);
1330: END IF;
1331:
1332: -- assignment level overrides
1333: OPEN c_get_avg_si_assignment(p_assignment_id);

Line 1341: pqp_utilities.debug(' c_get_avg_si_assignment found ', 4);

1337: AND l_override_method IS NOT NULL)THEN
1338: CLOSE c_get_avg_si_assignment;
1339:
1340: IF l_debug THEN
1341: pqp_utilities.debug(' c_get_avg_si_assignment found ', 4);
1342: pqp_utilities.debug(' l_override_method ' || l_override_method, 5);
1343: pqp_utilities.debug(' l_overridden_avgsi_assignment ' || l_overridden_avgsi_assignment ,6);
1344: END IF;
1345:

Line 1342: pqp_utilities.debug(' l_override_method ' || l_override_method, 5);

1338: CLOSE c_get_avg_si_assignment;
1339:
1340: IF l_debug THEN
1341: pqp_utilities.debug(' c_get_avg_si_assignment found ', 4);
1342: pqp_utilities.debug(' l_override_method ' || l_override_method, 5);
1343: pqp_utilities.debug(' l_overridden_avgsi_assignment ' || l_overridden_avgsi_assignment ,6);
1344: END IF;
1345:
1346: IF (l_override_method = 0) THEN --'Manual Entry'

Line 1343: pqp_utilities.debug(' l_overridden_avgsi_assignment ' || l_overridden_avgsi_assignment ,6);

1339:
1340: IF l_debug THEN
1341: pqp_utilities.debug(' c_get_avg_si_assignment found ', 4);
1342: pqp_utilities.debug(' l_override_method ' || l_override_method, 5);
1343: pqp_utilities.debug(' l_overridden_avgsi_assignment ' || l_overridden_avgsi_assignment ,6);
1344: END IF;
1345:
1346: IF (l_override_method = 0) THEN --'Manual Entry'
1347: l_average_days_multiplier := l_overridden_avgsi_assignment;

Line 1389: pqp_utilities.debug(' l_max_si_method ' || l_max_si_method, 5);

1385: l_max_si_days * l_overridden_avgsi_assignment/100;
1386:
1387:
1388: IF l_debug THEN
1389: pqp_utilities.debug(' l_max_si_method ' || l_max_si_method, 5);
1390: pqp_utilities.debug(' l_max_si_days ' || l_max_si_days ,6);
1391: END IF;
1392:
1393: END IF;

Line 1390: pqp_utilities.debug(' l_max_si_days ' || l_max_si_days ,6);

1386:
1387:
1388: IF l_debug THEN
1389: pqp_utilities.debug(' l_max_si_method ' || l_max_si_method, 5);
1390: pqp_utilities.debug(' l_max_si_days ' || l_max_si_days ,6);
1391: END IF;
1392:
1393: END IF;
1394: END IF;

Line 1397: pqp_utilities.debug(' l_average_days_multiplier found '|| l_average_days_multiplier,7);

1393: END IF;
1394: END IF;
1395:
1396: IF l_debug THEN
1397: pqp_utilities.debug(' l_average_days_multiplier found '|| l_average_days_multiplier,7);
1398: END IF;
1399:
1400: ELSIF (c_get_avg_si_assignment%FOUND
1401: AND

Line 1422: pqp_utilities.debug(' l_average_days_multiplier found '|| l_average_days_multiplier,7);

1418: CLOSE c_get_avg_si_assignment;
1419: END IF;-- check for override at assignment level.
1420:
1421: IF l_debug THEN
1422: pqp_utilities.debug(' l_average_days_multiplier found '|| l_average_days_multiplier,7);
1423: END IF;
1424:
1425: IF(bFlagAvgDays= true) THEN
1426:

Line 1434: pqp_utilities.debug(' l_work_pattern is '|| l_work_pattern , 190);

1430: IF c_get_work_pattern%FOUND AND l_work_pattern IS NOT NULL THEN
1431: CLOSE c_get_work_pattern;
1432:
1433: IF l_debug THEN
1434: pqp_utilities.debug(' l_work_pattern is '|| l_work_pattern , 190);
1435: END IF;
1436:
1437: l_working_work_pattern_days := pay_nl_si_pkg.Get_Working_Work_Pattern_days(p_assignment_id) ;
1438: l_total_work_pattern_days := pay_nl_si_pkg.Get_Total_Work_Pattern_days(p_assignment_id) ;

Line 1441: pqp_utilities.debug(' l_working_work_pattern_days is '|| l_working_work_pattern_days , 200);

1437: l_working_work_pattern_days := pay_nl_si_pkg.Get_Working_Work_Pattern_days(p_assignment_id) ;
1438: l_total_work_pattern_days := pay_nl_si_pkg.Get_Total_Work_Pattern_days(p_assignment_id) ;
1439:
1440: IF l_debug THEN
1441: pqp_utilities.debug(' l_working_work_pattern_days is '|| l_working_work_pattern_days , 200);
1442: pqp_utilities.debug(' l_total_work_pattern_days is '|| l_total_work_pattern_days , 210);
1443: END IF;
1444:
1445: -- si factor = working pattern days/total work days * average period days.

Line 1442: pqp_utilities.debug(' l_total_work_pattern_days is '|| l_total_work_pattern_days , 210);

1438: l_total_work_pattern_days := pay_nl_si_pkg.Get_Total_Work_Pattern_days(p_assignment_id) ;
1439:
1440: IF l_debug THEN
1441: pqp_utilities.debug(' l_working_work_pattern_days is '|| l_working_work_pattern_days , 200);
1442: pqp_utilities.debug(' l_total_work_pattern_days is '|| l_total_work_pattern_days , 210);
1443: END IF;
1444:
1445: -- si factor = working pattern days/total work days * average period days.
1446:

Line 1475: pqp_utilities.debug(' p_error_message is '|| p_error_message , 230);

1471:
1472: END IF;
1473:
1474: IF l_debug THEN
1475: pqp_utilities.debug(' p_error_message is '|| p_error_message , 230);
1476: END IF;
1477:
1478: IF (l_ret_val = 0 ) THEN
1479: IF(l_total_work_pattern_days <> 0) THEN

Line 1482: pqp_utilities.debug(' l_average_period_days is '|| l_average_period_days , 215);

1478: IF (l_ret_val = 0 ) THEN
1479: IF(l_total_work_pattern_days <> 0) THEN
1480:
1481: IF l_debug THEN
1482: pqp_utilities.debug(' l_average_period_days is '|| l_average_period_days , 215);
1483: END IF;
1484: l_average_ws_si_days := l_working_work_pattern_days/l_total_work_pattern_days * l_average_period_days;
1485:
1486: IF l_debug THEN

Line 1487: pqp_utilities.debug(' l_average_ws_si_days is '|| l_average_ws_si_days , 220);

1483: END IF;
1484: l_average_ws_si_days := l_working_work_pattern_days/l_total_work_pattern_days * l_average_period_days;
1485:
1486: IF l_debug THEN
1487: pqp_utilities.debug(' l_average_ws_si_days is '|| l_average_ws_si_days , 220);
1488: END IF;
1489:
1490: --prorate the average_ws_si_days value for actual days worked
1491: IF (l_payroll_days <> 0 and l_actual_work_days <> -99) THEN

Line 1496: pqp_utilities.debug(' l_average_ws_si_days is '|| l_average_ws_si_days , 225);

1492: l_average_ws_si_days := (l_average_ws_si_days/l_payroll_days * l_actual_work_days);
1493: END IF;
1494:
1495: IF l_debug THEN
1496: pqp_utilities.debug(' l_average_ws_si_days is '|| l_average_ws_si_days , 225);
1497: END IF;
1498:
1499: -- get non si days
1500: l_non_si_days := pay_nl_si_pkg.Get_Non_SI_Days(p_assignment_id,l_pay_start_dt,l_pay_end_dt);

Line 1503: pqp_utilities.debug(' l_non_si_days is '|| l_non_si_days , 230);

1499: -- get non si days
1500: l_non_si_days := pay_nl_si_pkg.Get_Non_SI_Days(p_assignment_id,l_pay_start_dt,l_pay_end_dt);
1501:
1502: IF l_debug THEN
1503: pqp_utilities.debug(' l_non_si_days is '|| l_non_si_days , 230);
1504: END IF;
1505:
1506: -- avg. work schedule si days = avg. work schedule si days - non si days
1507: l_average_ws_si_days := l_average_ws_si_days - l_non_si_days;

Line 1559: pqp_utilities.debug(' c_get_max_si_values not found ', 4);

1555: (c_get_max_si_values%FOUND AND l_overridden_realsi_assignment IS NULL ))THEN
1556: CLOSE c_get_max_si_values;
1557:
1558: IF l_debug THEN
1559: pqp_utilities.debug(' c_get_max_si_values not found ', 4);
1560: END IF;
1561:
1562: OPEN c_get_start_end_date(p_assignment_id,p_date_earned);
1563: FETCH c_get_start_end_date into l_pay_start_dt,l_pay_end_dt;

Line 1568: pqp_utilities.debug(' l_pay_start_dt is '|| l_pay_start_dt , 10);

1564: IF c_get_start_end_date%FOUND THEN
1565: CLOSE c_get_start_end_date;
1566:
1567: IF l_debug THEN
1568: pqp_utilities.debug(' l_pay_start_dt is '|| l_pay_start_dt , 10);
1569: pqp_utilities.debug(' l_pay_end_dt is '|| l_pay_end_dt , 15);
1570: END IF;
1571:
1572: -- check if the assignment has started in this payroll period.

Line 1569: pqp_utilities.debug(' l_pay_end_dt is '|| l_pay_end_dt , 15);

1565: CLOSE c_get_start_end_date;
1566:
1567: IF l_debug THEN
1568: pqp_utilities.debug(' l_pay_start_dt is '|| l_pay_start_dt , 10);
1569: pqp_utilities.debug(' l_pay_end_dt is '|| l_pay_end_dt , 15);
1570: END IF;
1571:
1572: -- check if the assignment has started in this payroll period.
1573: OPEN c_get_assign_start_date(p_assignment_id,l_pay_start_dt,l_pay_end_dt);

Line 1579: pqp_utilities.debug(' l_ass_start_dt is '|| l_ass_start_dt , 20);

1575: IF (c_get_assign_start_date%FOUND AND l_ass_start_dt IS NOT NULL)THEN
1576: CLOSE c_get_assign_start_date;
1577: l_ret_val := 0;
1578: IF l_debug THEN
1579: pqp_utilities.debug(' l_ass_start_dt is '|| l_ass_start_dt , 20);
1580: END IF;
1581: ELSE
1582: CLOSE c_get_assign_start_date;
1583: --p_error_message := 'Error: Unable to find the assignment start date for the person ';

Line 1602: pqp_utilities.debug(' l_next_term_date is '|| l_next_term_date , 92);

1598: IF (c_get_asg_end_date%FOUND)THEN
1599: CLOSE c_get_asg_end_date;
1600: l_term_date := l_next_term_date;
1601: IF l_debug THEN
1602: pqp_utilities.debug(' l_next_term_date is '|| l_next_term_date , 92);
1603: END IF;
1604: ELSE
1605: CLOSE c_get_asg_end_date;
1606: END IF; -- assignment end date found

Line 1610: pqp_utilities.debug(' l_term_date is '|| l_term_date , 91);

1606: END IF; -- assignment end date found
1607: END IF;-- term date is not null
1608:
1609: IF l_debug THEN
1610: pqp_utilities.debug(' l_term_date is '|| l_term_date , 91);
1611: END IF;
1612: /* -- get termination date
1613: OPEN c_get_ass_term_date(p_assignment_id,l_pay_start_dt,l_pay_end_dt);
1614: FETCH c_get_ass_term_date into l_term_date;

Line 1619: pqp_utilities.debug(' l_term_date is '|| l_term_date , 30);

1615: IF (c_get_ass_term_date%FOUND AND l_term_date IS NOT NULL)THEN
1616: CLOSE c_get_ass_term_date;
1617:
1618: IF l_debug THEN
1619: pqp_utilities.debug(' l_term_date is '|| l_term_date , 30);
1620: END IF;
1621: ELSE
1622: CLOSE c_get_ass_term_date;
1623: END IF;-- term date check

Line 1629: pqp_utilities.debug(' l_ret_val is '|| l_ret_val , 31);

1625:
1626:
1627:
1628: IF l_debug THEN
1629: pqp_utilities.debug(' l_ret_val is '|| l_ret_val , 31);
1630: END IF;
1631:
1632: IF (l_ret_val = 0 )THEN
1633: IF(l_ass_start_dt IS NOT NULL AND l_ass_start_dt > l_pay_start_dt) THEN

Line 1642: pqp_utilities.debug(' l_pay_start_dt is '|| l_pay_start_dt , 32);

1638: l_pay_end_dt := l_term_date;
1639: END IF;
1640:
1641: IF l_debug THEN
1642: pqp_utilities.debug(' l_pay_start_dt is '|| l_pay_start_dt , 32);
1643: pqp_utilities.debug(' l_pay_end_dt is '|| l_pay_end_dt , 33);
1644: END IF;
1645:
1646: -- check if employee is attached to a work pattern.

Line 1643: pqp_utilities.debug(' l_pay_end_dt is '|| l_pay_end_dt , 33);

1639: END IF;
1640:
1641: IF l_debug THEN
1642: pqp_utilities.debug(' l_pay_start_dt is '|| l_pay_start_dt , 32);
1643: pqp_utilities.debug(' l_pay_end_dt is '|| l_pay_end_dt , 33);
1644: END IF;
1645:
1646: -- check if employee is attached to a work pattern.
1647: OPEN c_get_work_pattern(p_assignment_id,p_date_earned);

Line 1653: pqp_utilities.debug(' l_work_pattern is '|| l_work_pattern , 40);

1649: IF (c_get_work_pattern%FOUND AND l_work_pattern IS NOT NULL)THEN
1650: CLOSE c_get_work_pattern;
1651:
1652: IF l_debug THEN
1653: pqp_utilities.debug(' l_work_pattern is '|| l_work_pattern , 40);
1654: END IF;
1655:
1656: l_working_work_pattern_days := pqp_schedule_calculation_pkg.get_days_worked
1657: ( p_assignment_id => p_assignment_id

Line 1667: pqp_utilities.debug(' l_working_work_pattern_days is '|| l_working_work_pattern_days , 50);

1663: ,p_override_wp => l_work_pattern
1664: );
1665:
1666: IF l_debug THEN
1667: pqp_utilities.debug(' l_working_work_pattern_days is '|| l_working_work_pattern_days , 50);
1668: END IF;
1669:
1670: IF (l_max_si_method = 0 ) THEN -- 1 indicates 'Payroll Period' 0 indicates Weeks worked.
1671: l_max_si_days := pay_nl_si_pkg.Get_Max_SI_Days(p_assignment_id,l_pay_start_dt,l_pay_end_dt);

Line 1677: pqp_utilities.debug(' l_max_si_days is '|| l_max_si_days , 60);

1673: l_max_si_days := pay_nl_si_pkg.Get_Week_Days(l_pay_start_dt,l_pay_end_dt);
1674: END IF;
1675:
1676: IF l_debug THEN
1677: pqp_utilities.debug(' l_max_si_days is '|| l_max_si_days , 60);
1678: END IF;
1679:
1680: l_non_si_days := pay_nl_si_pkg.Get_Non_SI_Days(p_assignment_id,l_pay_start_dt,l_pay_end_dt);
1681:

Line 1683: pqp_utilities.debug(' l_non_si_days is '|| l_non_si_days , 70);

1679:
1680: l_non_si_days := pay_nl_si_pkg.Get_Non_SI_Days(p_assignment_id,l_pay_start_dt,l_pay_end_dt);
1681:
1682: IF l_debug THEN
1683: pqp_utilities.debug(' l_non_si_days is '|| l_non_si_days , 70);
1684: END IF;
1685:
1686: IF (l_working_work_pattern_days > l_max_si_days ) THEN
1687: l_real_si_days := l_max_si_days;

Line 1693: pqp_utilities.debug(' l_real_si_days is '|| l_real_si_days , 80);

1689: l_real_si_days := l_working_work_pattern_days;
1690: END IF;
1691:
1692: IF l_debug THEN
1693: pqp_utilities.debug(' l_real_si_days is '|| l_real_si_days , 80);
1694: END IF;
1695:
1696: l_real_si_days := l_real_si_days - l_non_si_days;
1697:

Line 1721: pqp_utilities.debug(' l_overridden_realsi_assignment ' || l_overridden_realsi_assignment, 90);

1717: ELSE
1718: CLOSE c_get_max_si_values;
1719: l_average_days_multiplier := l_overridden_realsi_assignment;
1720: IF l_debug THEN
1721: pqp_utilities.debug(' l_overridden_realsi_assignment ' || l_overridden_realsi_assignment, 90);
1722: END IF;
1723: END IF;-- check for max si days
1724: END IF; -- ret val is zero.
1725:

Line 1739: pqp_utilities.debug(' l_ass_start_dt is '|| l_ass_start_dt , 91);

1735: IF (c_get_assign_start_date%FOUND
1736: AND l_ass_start_dt IS NOT NULL)THEN
1737: CLOSE c_get_assign_start_date;
1738: IF l_debug THEN
1739: pqp_utilities.debug(' l_ass_start_dt is '|| l_ass_start_dt , 91);
1740: pqp_utilities.debug(' l_term_date is '|| l_term_date , 91);
1741: END IF;
1742: ELSE
1743: CLOSE c_get_assign_start_date;

Line 1740: pqp_utilities.debug(' l_term_date is '|| l_term_date , 91);

1736: AND l_ass_start_dt IS NOT NULL)THEN
1737: CLOSE c_get_assign_start_date;
1738: IF l_debug THEN
1739: pqp_utilities.debug(' l_ass_start_dt is '|| l_ass_start_dt , 91);
1740: pqp_utilities.debug(' l_term_date is '|| l_term_date , 91);
1741: END IF;
1742: ELSE
1743: CLOSE c_get_assign_start_date;
1744: p_prorated_amount := 0;

Line 1765: pqp_utilities.debug(' l_next_term_date is '|| l_next_term_date , 92);

1761: IF (c_get_asg_end_date%FOUND)THEN
1762: CLOSE c_get_asg_end_date;
1763: l_term_date := l_next_term_date;
1764: IF l_debug THEN
1765: pqp_utilities.debug(' l_next_term_date is '|| l_next_term_date , 92);
1766: END IF;
1767: ELSE
1768: CLOSE c_get_asg_end_date;
1769: END IF; -- assignment end date found

Line 1773: pqp_utilities.debug(' l_term_date is '|| l_term_date , 91);

1769: END IF; -- assignment end date found
1770: END IF;-- term date is not null
1771:
1772: IF l_debug THEN
1773: pqp_utilities.debug(' l_term_date is '|| l_term_date , 91);
1774: END IF;
1775:
1776: /* -- get termination date
1777: OPEN c_get_ass_term_date(p_assignment_id,l_pay_start_dt,l_pay_end_dt);

Line 1782: pqp_utilities.debug(' l_term_date is '|| l_term_date , 101);

1778: FETCH c_get_ass_term_date into l_term_date;
1779: IF (c_get_ass_term_date%FOUND AND l_term_date IS NOT NULL)THEN
1780: CLOSE c_get_ass_term_date;
1781: IF l_debug THEN
1782: pqp_utilities.debug(' l_term_date is '|| l_term_date , 101);
1783: END IF;
1784: ELSE
1785: CLOSE c_get_ass_term_date;
1786: END IF;-- get termination dt

Line 1796: pqp_utilities.debug(' l_actual_work_days is '|| l_actual_work_days , 105);

1792: FETCH c_no_of_days into l_days;
1793: IF (c_no_of_days%FOUND AND l_days IS NOT NULL)THEN
1794: CLOSE c_no_of_days;
1795: l_actual_work_days := l_days;
1796: pqp_utilities.debug(' l_actual_work_days is '|| l_actual_work_days , 105);
1797: ELSE
1798: CLOSE c_no_of_days;
1799: END IF;
1800: ELSE

Line 1806: pqp_utilities.debug(' l_actual_work_days is '|| l_actual_work_days , 106);

1802: FETCH c_no_of_days into l_days;
1803: IF (c_no_of_days%FOUND AND l_days IS NOT NULL)THEN
1804: CLOSE c_no_of_days;
1805: l_actual_work_days := l_days;
1806: pqp_utilities.debug(' l_actual_work_days is '|| l_actual_work_days , 106);
1807: pqp_utilities.debug(' l_days is '|| l_days , 107);
1808: ELSE
1809: CLOSE c_no_of_days;
1810: END IF;

Line 1807: pqp_utilities.debug(' l_days is '|| l_days , 107);

1803: IF (c_no_of_days%FOUND AND l_days IS NOT NULL)THEN
1804: CLOSE c_no_of_days;
1805: l_actual_work_days := l_days;
1806: pqp_utilities.debug(' l_actual_work_days is '|| l_actual_work_days , 106);
1807: pqp_utilities.debug(' l_days is '|| l_days , 107);
1808: ELSE
1809: CLOSE c_no_of_days;
1810: END IF;
1811: END IF;

Line 1837: pqp_utilities.debug(' l_average_days_divisor is '|| l_average_days_divisor , 151);

1833: l_pay_end_dt := l_term_date;
1834: END IF;
1835:
1836: IF l_debug THEN
1837: pqp_utilities.debug(' l_average_days_divisor is '|| l_average_days_divisor , 151);
1838: pqp_utilities.debug(' l_payroll_days is '|| l_payroll_days , 161);
1839: pqp_utilities.debug(' l_actual_work_days is '|| l_actual_work_days , 171);
1840: pqp_utilities.debug(' l_pay_start_dt is '|| l_pay_start_dt , 173);
1841: pqp_utilities.debug(' l_pay_end_dt is '|| l_pay_end_dt , 176);

Line 1838: pqp_utilities.debug(' l_payroll_days is '|| l_payroll_days , 161);

1834: END IF;
1835:
1836: IF l_debug THEN
1837: pqp_utilities.debug(' l_average_days_divisor is '|| l_average_days_divisor , 151);
1838: pqp_utilities.debug(' l_payroll_days is '|| l_payroll_days , 161);
1839: pqp_utilities.debug(' l_actual_work_days is '|| l_actual_work_days , 171);
1840: pqp_utilities.debug(' l_pay_start_dt is '|| l_pay_start_dt , 173);
1841: pqp_utilities.debug(' l_pay_end_dt is '|| l_pay_end_dt , 176);
1842: END IF;

Line 1839: pqp_utilities.debug(' l_actual_work_days is '|| l_actual_work_days , 171);

1835:
1836: IF l_debug THEN
1837: pqp_utilities.debug(' l_average_days_divisor is '|| l_average_days_divisor , 151);
1838: pqp_utilities.debug(' l_payroll_days is '|| l_payroll_days , 161);
1839: pqp_utilities.debug(' l_actual_work_days is '|| l_actual_work_days , 171);
1840: pqp_utilities.debug(' l_pay_start_dt is '|| l_pay_start_dt , 173);
1841: pqp_utilities.debug(' l_pay_end_dt is '|| l_pay_end_dt , 176);
1842: END IF;
1843:

Line 1840: pqp_utilities.debug(' l_pay_start_dt is '|| l_pay_start_dt , 173);

1836: IF l_debug THEN
1837: pqp_utilities.debug(' l_average_days_divisor is '|| l_average_days_divisor , 151);
1838: pqp_utilities.debug(' l_payroll_days is '|| l_payroll_days , 161);
1839: pqp_utilities.debug(' l_actual_work_days is '|| l_actual_work_days , 171);
1840: pqp_utilities.debug(' l_pay_start_dt is '|| l_pay_start_dt , 173);
1841: pqp_utilities.debug(' l_pay_end_dt is '|| l_pay_end_dt , 176);
1842: END IF;
1843:
1844: l_average_days_multiplier := l_periods_per_yr;

Line 1841: pqp_utilities.debug(' l_pay_end_dt is '|| l_pay_end_dt , 176);

1837: pqp_utilities.debug(' l_average_days_divisor is '|| l_average_days_divisor , 151);
1838: pqp_utilities.debug(' l_payroll_days is '|| l_payroll_days , 161);
1839: pqp_utilities.debug(' l_actual_work_days is '|| l_actual_work_days , 171);
1840: pqp_utilities.debug(' l_pay_start_dt is '|| l_pay_start_dt , 173);
1841: pqp_utilities.debug(' l_pay_end_dt is '|| l_pay_end_dt , 176);
1842: END IF;
1843:
1844: l_average_days_multiplier := l_periods_per_yr;
1845:

Line 1868: pqp_utilities.debug(' l_average_days_multiplier is '|| l_average_days_multiplier , 250);

1864:
1865: IF l_ret_val = 0 THEN
1866:
1867: IF l_debug THEN
1868: pqp_utilities.debug(' l_average_days_multiplier is '|| l_average_days_multiplier , 250);
1869: pqp_utilities.debug(' l_average_days_divisor is '|| l_average_days_divisor , 260);
1870: END IF;
1871:
1872: p_prorated_amount := (p_amount/l_average_days_divisor) * l_average_days_multiplier;

Line 1869: pqp_utilities.debug(' l_average_days_divisor is '|| l_average_days_divisor , 260);

1865: IF l_ret_val = 0 THEN
1866:
1867: IF l_debug THEN
1868: pqp_utilities.debug(' l_average_days_multiplier is '|| l_average_days_multiplier , 250);
1869: pqp_utilities.debug(' l_average_days_divisor is '|| l_average_days_divisor , 260);
1870: END IF;
1871:
1872: p_prorated_amount := (p_amount/l_average_days_divisor) * l_average_days_multiplier;
1873: p_prorated_amount := ROUND(p_prorated_amount,2);

Line 1876: pqp_utilities.debug(' p_prorated_amount is '|| p_prorated_amount , 300);

1872: p_prorated_amount := (p_amount/l_average_days_divisor) * l_average_days_multiplier;
1873: p_prorated_amount := ROUND(p_prorated_amount,2);
1874:
1875: IF l_debug THEN
1876: pqp_utilities.debug(' p_prorated_amount is '|| p_prorated_amount , 300);
1877: END IF;
1878:
1879: END IF;
1880: