[Home] [Help]
355: l_line_id number(9) := 0;
356:
357: CURSOR get_difference_csr is
358: SELECT sum(pay_amount)
359: FROM psp_payroll_sub_lines
360: WHERE payroll_line_id = l_line_id;
361:
362: l_subline_sum NUMBER := 0; -- Corrected to NUMBER from NUMBER(22, 2) for bug fix 2916848
363:
1454: r_payroll_control_array.r_cr_amount(l_cur_rec) + g_pay_costs_rec.costed_value;
1455:
1456: END IF;
1457:
1458: -- write single sub-line in PSP_PAYROLL_SUB_LINES
1459:
1460: IF g_non_active_flag = 'Y' THEN
1461: l_reason := 'NON_ACTIVE_ASSIGNMENT';
1462: ELSIF g_hire_zero_work_days = 'Y' THEN
1579:
1580: END IF;
1581:
1582: -- If salary change happens during the payroll period
1583: -- write two sub-lines in PSP_PAYROLL_SUB_LINES
1584: -- table
1585: -- else
1586: -- write single sub-line in PSP_PAYROLL_SUB_LINES
1587: -- table
1582: -- If salary change happens during the payroll period
1583: -- write two sub-lines in PSP_PAYROLL_SUB_LINES
1584: -- table
1585: -- else
1586: -- write single sub-line in PSP_PAYROLL_SUB_LINES
1587: -- table
1588: -- end if;
1589:
1590: --- IF (l_proration_option = 'PSP' or g_pay_costs_rec.start_date is null ) THEN -- Introduced for bug fix 2916848
1758: end if;
1759: close get_difference_csr;
1760: -- Added daily rate not equal to 0 to where clause to fix bug no 89157
1761: if (NVL(to_number(g_pay_costs_rec.costed_value),0) - NVL(l_subline_sum,0)) <> 0 then
1762: update psp_payroll_sub_lines
1763: set pay_amount = pay_amount + (NVL(to_number(g_pay_costs_rec.costed_value),0) - NVL(l_subline_sum,0))
1764: where payroll_line_id = l_line_id and
1765: NVL(daily_rate,0) <> 0 and
1766: pay_amount <> 0 and --- rounding difference to nonzero amount .. 4670588
1855:
1856: FORALL k in 1 .. l_total_num_rec
1857: update psp_payroll_controls
1858: set sublines_dr_amount = ( select sum(pay_amount)
1859: from psp_payroll_sub_lines
1860: where payroll_line_id in (
1861: select payroll_line_id
1862: from psp_payroll_lines
1863: where payroll_control_id =
1863: where payroll_control_id =
1864: r_payroll_control_array.r_payroll_control_id(k)
1865: and dr_cr_flag = 'D')),
1866: sublines_cr_amount = ( select sum(pay_amount)
1867: from psp_payroll_sub_lines
1868: where payroll_line_id in (
1869: select payroll_line_id
1870: from psp_payroll_lines
1871: where payroll_control_id = r_payroll_control_array.r_payroll_control_id(k) and
3042: l_total_daily_rate := 0.00;
3043: else
3044: l_total_daily_rate := l_daily_rate + l_daily_balance;
3045: end if;
3046: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3047: FROM DUAL;
3048: ---hr_utility.trace(' Sub line ' || to_char(l_sub_line_id));
3049: hr_utility.trace(' inserting into Sublines -1');
3050: if l_total_daily_Rate > 0 then
3048: ---hr_utility.trace(' Sub line ' || to_char(l_sub_line_id));
3049: hr_utility.trace(' inserting into Sublines -1');
3050: if l_total_daily_Rate > 0 then
3051:
3052: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3053: X_ROWID => l_rowid,
3054: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3055: X_PAYROLL_LINE_ID => x_payroll_line_id,
3056: X_SUB_LINE_START_DATE => l_sub_line_start_date,
3115: l_balance_salary := round((l_daily_balance * l_work_days), g_precision) ; -- bug fix 3109943
3116: else
3117: l_balance_salary := 0.00;
3118: end if;
3119: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3120: FROM DUAL;
3121: ----hr_utility.trace(' Before Insert rec into sub lines 2');
3122: hr_utility.trace(' inserting into Sublines -2');
3123: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3119: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3120: FROM DUAL;
3121: ----hr_utility.trace(' Before Insert rec into sub lines 2');
3122: hr_utility.trace(' inserting into Sublines -2');
3123: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3124: X_ROWID => l_rowid,
3125: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3126: X_PAYROLL_LINE_ID => x_payroll_line_id,
3127: X_SUB_LINE_START_DATE => l_sub_line_start_date,
3191: ----hr_utility.trace(' Balance amount ' || to_char(g_payroll_line_rec.balance_amount));
3192:
3193: l_daily_rate := round((g_payroll_line_rec.pay_amount / g_no_of_person_work_days), g_ext_precision);
3194:
3195: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
3196: ----hr_utility.trace(' Before Insert rec into sub lines 3');
3197: ----hr_utility.trace(' Subline id ' || to_char(l_sub_line_id));
3198: ----hr_utility.trace(' line id ' || to_char(x_payroll_line_id) );
3199: ----hr_utility.trace(' line start date ' || to_char(l_sub_line_start_date,'YYYY/MM/DD HH24:MI:SS'));
3201: ----hr_utility.trace(' line end date ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3202: ----hr_utility.trace(' Daily rate ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3203: l_salary:=0;
3204: hr_utility.trace(' inserting into Sublines -3');
3205: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3206: X_ROWID => l_rowid,
3207: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3208: X_PAYROLL_LINE_ID => x_payroll_line_id,
3209: X_SUB_LINE_START_DATE => TRUNC(NVL(x_start_date,l_sub_line_start_date)),
3274: ----dbms_output.PUT_LINE('l_balance_salary ' || to_char(l_balance_salary));
3275: ----dbms_output.PUT_LINE('Daily rate ' || to_char(l_daily_rate+l_daily_balance));
3276: ----dbms_output.PUT_LINE('salary Used ' || to_char(l_salary));
3277:
3278: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3279: FROM DUAL;
3280: hr_utility.trace(' inserting into Sublines -5');
3281: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3282: X_ROWID => l_rowid,
3277:
3278: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3279: FROM DUAL;
3280: hr_utility.trace(' inserting into Sublines -5');
3281: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3282: X_ROWID => l_rowid,
3283: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3284: X_PAYROLL_LINE_ID => x_payroll_line_id,
3285: X_SUB_LINE_START_DATE => TRUNC(NVL(x_start_date,g_start_date)),
3366: l_end_date date;
3367:
3368: CURSOR get_sublines_csr IS
3369: SELECT *
3370: FROM psp_payroll_sub_lines
3371: WHERE payroll_line_id = x_payroll_line_id and
3372: l_start_date between sub_line_start_date and sub_line_end_date;
3373:
3374: g_sublines_rec get_sublines_csr%ROWTYPE;
3383: if get_asg_begin_date_csr%FOUND then
3384: open get_sublines_csr;
3385: fetch get_sublines_csr into g_sublines_rec;
3386: if get_sublines_csr%FOUND then
3387: UPDATE psp_payroll_sub_lines
3388: SET sub_line_start_date = trunc(l_start_date),
3389: reason_code = 'ASSG_BEGIN_DATE',
3390: assignment_begin_date = trunc(l_start_date)
3391: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
3401: l_start_date := trunc(l_end_date);
3402: open get_sublines_csr;
3403: fetch get_sublines_csr into g_sublines_rec;
3404: if get_sublines_csr%FOUND then
3405: UPDATE psp_payroll_sub_lines
3406: SET sub_line_end_date = trunc(l_start_date),
3407: reason_code = 'ASSG_END_DATE',
3408: assignment_end_date = trunc(l_start_date)
3409: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
3447: l_end_date date;
3448:
3449: CURSOR get_sublines_csr IS
3450: SELECT *
3451: FROM psp_payroll_sub_lines
3452: WHERE payroll_line_id = x_payroll_line_id and
3453: (l_start_date between sub_line_start_date and sub_line_end_date or
3454: l_end_date between sub_line_start_date and sub_line_end_date);
3455: -- or
3493: if (l_start_date <= g_sublines_rec.sub_line_start_date and
3494: l_end_date >= g_sublines_rec.sub_line_end_date)
3495: then
3496: ----dbms_output.put_line('Entered 1st if ..');
3497: UPDATE psp_payroll_sub_lines
3498: SET pay_amount = 0.00,
3499: daily_rate = 0.00,
3500: reason_code = 'ASSG_STATUS_CHANGE'
3501: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
3522: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / l_total_work_days)), g_precision);
3523: end if;
3524: -- ----dbms_output.put_line('Entered 3rd if ..');
3525:
3526: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3527: FROM DUAL;
3528: hr_utility.trace(' inserting into Sublines -6');
3529: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3530: X_ROWID => l_rowid,
3525:
3526: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3527: FROM DUAL;
3528: hr_utility.trace(' inserting into Sublines -6');
3529: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3530: X_ROWID => l_rowid,
3531: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3532: X_PAYROLL_LINE_ID => x_payroll_line_id,
3533: X_SUB_LINE_START_DATE => l_tmp_start_date,
3571: ----dbms_output.put_line('After creating sub line (1)..');
3572:
3573: l_tmp_start_date := trunc(l_start_date);
3574: l_tmp_end_date := trunc(g_sublines_rec.sub_line_end_date);
3575: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3576: FROM DUAL;
3577: hr_utility.trace(' inserting into Sublines -7');
3578: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3579: X_ROWID => l_rowid,
3574: l_tmp_end_date := trunc(g_sublines_rec.sub_line_end_date);
3575: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3576: FROM DUAL;
3577: hr_utility.trace(' inserting into Sublines -7');
3578: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3579: X_ROWID => l_rowid,
3580: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3581: X_PAYROLL_LINE_ID => x_payroll_line_id,
3582: X_SUB_LINE_START_DATE => l_tmp_start_date,
3617: X_REASON_CODE => 'ASSG_STATUS_CHANGE',
3618: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
3619: X_MODE => 'R') ;
3620: ----dbms_output.put_line('After creating sub line (2)..');
3621: DELETE psp_payroll_sub_lines
3622: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
3623: end;
3624: elsif (l_start_date = g_sublines_rec.sub_line_start_date and
3625: l_end_date < g_sublines_rec.sub_line_end_date) then
3627: ----dbms_output.put_line('Entered 3rd if..');
3628:
3629: l_tmp_start_date := trunc(g_sublines_rec.sub_line_start_date);
3630: l_tmp_end_date := trunc(l_end_date);
3631: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3632: FROM DUAL;
3633: hr_utility.trace(' inserting into Sublines -8');
3634: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3635: X_ROWID => l_rowid,
3630: l_tmp_end_date := trunc(l_end_date);
3631: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3632: FROM DUAL;
3633: hr_utility.trace(' inserting into Sublines -8');
3634: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3635: X_ROWID => l_rowid,
3636: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3637: X_PAYROLL_LINE_ID => x_payroll_line_id,
3638: X_SUB_LINE_START_DATE => l_tmp_start_date,
3691:
3692: if round(x_balance_amount,g_precision) <> 0.00 then
3693: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / l_total_work_days)), g_precision);
3694: end if;
3695: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3696: FROM DUAL;
3697: hr_utility.trace(' inserting into Sublines -10');
3698: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3699: X_ROWID => l_rowid,
3694: end if;
3695: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3696: FROM DUAL;
3697: hr_utility.trace(' inserting into Sublines -10');
3698: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3699: X_ROWID => l_rowid,
3700: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3701: X_PAYROLL_LINE_ID => x_payroll_line_id,
3702: X_SUB_LINE_START_DATE => l_tmp_start_date,
3737: X_REASON_CODE => 'ASSG_STATUS_CHANGE',
3738: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
3739: X_MODE => 'R');
3740: ----dbms_output.put_line('After creating sub line (2)..');
3741: DELETE psp_payroll_sub_lines
3742: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
3743: end;
3744: elsif (l_start_date > g_sublines_rec.sub_line_start_date and
3745: l_end_date < g_sublines_rec.sub_line_end_date) then
3761:
3762: if round(x_balance_amount,g_precision) <> 0.00 then
3763: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / l_total_work_days)), g_precision);
3764: end if;
3765: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3766: FROM DUAL;
3767: hr_utility.trace(' inserting into Sublines -12');
3768: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3769: X_ROWID => l_rowid,
3764: end if;
3765: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3766: FROM DUAL;
3767: hr_utility.trace(' inserting into Sublines -12');
3768: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3769: X_ROWID => l_rowid,
3770: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3771: X_PAYROLL_LINE_ID => x_payroll_line_id,
3772: X_SUB_LINE_START_DATE => l_tmp_start_date,
3809: X_MODE => 'R');
3810: ----dbms_output.put_line('After 1st Insert ..');
3811: l_tmp_start_date := trunc(l_start_date);
3812: l_tmp_end_date := trunc(l_end_date) ;
3813: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3814: FROM DUAL;
3815: hr_utility.trace(' inserting into Sublines -13');
3816: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3817: X_ROWID => l_rowid,
3812: l_tmp_end_date := trunc(l_end_date) ;
3813: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3814: FROM DUAL;
3815: hr_utility.trace(' inserting into Sublines -13');
3816: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3817: X_ROWID => l_rowid,
3818: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3819: X_PAYROLL_LINE_ID => x_payroll_line_id,
3820: X_SUB_LINE_START_DATE => l_tmp_start_date,
3873: if round(x_balance_amount,g_precision) <> 0.00 then
3874: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / l_total_work_days)), g_precision);
3875:
3876: end if;
3877: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3878: FROM DUAL;
3879: hr_utility.trace(' inserting into Sublines -14');
3880: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3881: X_ROWID => l_rowid,
3876: end if;
3877: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3878: FROM DUAL;
3879: hr_utility.trace(' inserting into Sublines -14');
3880: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3881: X_ROWID => l_rowid,
3882: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3883: X_PAYROLL_LINE_ID => x_payroll_line_id,
3884: X_SUB_LINE_START_DATE => l_tmp_start_date,
3920: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
3921: X_MODE => 'R');
3922: ----dbms_output.put_line('After 3rd Insert ..');
3923:
3924: DELETE psp_payroll_sub_lines
3925: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
3926: end;
3927: elsif (l_start_date = g_sublines_rec.sub_line_end_date and
3928: l_end_date > g_sublines_rec.sub_line_end_date) then
3945:
3946: if round(x_balance_amount,g_precision) <> 0.00 then
3947: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / l_total_work_days)), g_precision);
3948: end if;
3949: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3950: FROM DUAL;
3951: hr_utility.trace(' inserting into Sublines -15');
3952: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3953: X_ROWID => l_rowid,
3948: end if;
3949: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3950: FROM DUAL;
3951: hr_utility.trace(' inserting into Sublines -15');
3952: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3953: X_ROWID => l_rowid,
3954: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3955: X_PAYROLL_LINE_ID => x_payroll_line_id,
3956: X_SUB_LINE_START_DATE => l_tmp_start_date,
3994:
3995: l_tmp_start_date := trunc(g_sublines_rec.sub_line_end_date);
3996: l_tmp_end_date := trunc(g_sublines_rec.sub_line_end_date);
3997:
3998: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3999: FROM DUAL;
4000: hr_utility.trace(' inserting into Sublines -17');
4001: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4002: X_ROWID => l_rowid,
3997:
3998: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3999: FROM DUAL;
4000: hr_utility.trace(' inserting into Sublines -17');
4001: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4002: X_ROWID => l_rowid,
4003: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4004: X_PAYROLL_LINE_ID => x_payroll_line_id,
4005: X_SUB_LINE_START_DATE => l_tmp_start_date,
4039: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4040: X_REASON_CODE => 'ASSG_STATUS_CHANGE',
4041: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
4042: X_MODE => 'R');
4043: DELETE psp_payroll_sub_lines
4044: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
4045: end;
4046: elsif (l_start_date < g_sublines_rec.sub_line_start_date and
4047: l_end_date < g_sublines_rec.sub_line_end_date) then
4049: ----dbms_output.put_line('Entered 6th if ..');
4050: l_tmp_start_date := trunc(g_sublines_rec.sub_line_start_date);
4051: l_tmp_end_date := trunc(l_end_date);
4052:
4053: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4054: FROM DUAL;
4055: hr_utility.trace(' inserting into Sublines -19');
4056: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4057: X_ROWID => l_rowid,
4052:
4053: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4054: FROM DUAL;
4055: hr_utility.trace(' inserting into Sublines -19');
4056: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4057: X_ROWID => l_rowid,
4058: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4059: X_PAYROLL_LINE_ID => x_payroll_line_id,
4060: X_SUB_LINE_START_DATE => l_tmp_start_date,
4112:
4113: if round(x_balance_amount,g_precision) <> 0.00 then
4114: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / l_total_work_days)), g_precision);
4115: end if;
4116: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4117: FROM DUAL;
4118: hr_utility.trace(' inserting into Sublines -21');
4119: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4120: X_ROWID => l_rowid,
4115: end if;
4116: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4117: FROM DUAL;
4118: hr_utility.trace(' inserting into Sublines -21');
4119: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4120: X_ROWID => l_rowid,
4121: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4122: X_PAYROLL_LINE_ID => x_payroll_line_id,
4123: X_SUB_LINE_START_DATE => l_tmp_start_date,
4157: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4158: X_REASON_CODE => 'ASSG_STATUS_CHANGE',
4159: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
4160: X_MODE => 'R');
4161: DELETE psp_payroll_sub_lines
4162: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
4163: end;
4164: end if;
4165: end loop;
4211: l_tmp_date date;
4212:
4213: CURSOR get_sublines_csr IS
4214: SELECT *
4215: FROM psp_payroll_sub_lines
4216: WHERE payroll_line_id = x_payroll_line_id and
4217: l_tmp_date between sub_line_start_date and sub_line_end_date;
4218:
4219: g_sublines_rec get_sublines_csr%ROWTYPE;
4239: fetch get_sublines_csr into g_sublines_rec;
4240: EXIT WHEN get_sublines_csr%NOTFOUND;
4241: if l_date_start > g_sublines_rec.sub_line_start_date then
4242: l_tmp_end_date := trunc(l_date_start) - 1;
4243: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4244: FROM DUAL;
4245: hr_utility.trace(' inserting into Sublines -22');
4246: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4247: X_ROWID => l_rowid,
4242: l_tmp_end_date := trunc(l_date_start) - 1;
4243: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4244: FROM DUAL;
4245: hr_utility.trace(' inserting into Sublines -22');
4246: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4247: X_ROWID => l_rowid,
4248: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4249: X_PAYROLL_LINE_ID => x_payroll_line_id,
4250: X_SUB_LINE_START_DATE => g_sublines_rec.sub_line_start_date,
4286: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
4287: X_MODE => 'R');
4288:
4289: l_tmp_start_date := trunc(l_date_start);
4290: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4291: FROM DUAL;
4292: hr_utility.trace(' inserting into Sublines -25');
4293: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4294: X_ROWID => l_rowid,
4289: l_tmp_start_date := trunc(l_date_start);
4290: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4291: FROM DUAL;
4292: hr_utility.trace(' inserting into Sublines -25');
4293: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4294: X_ROWID => l_rowid,
4295: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4296: X_PAYROLL_LINE_ID => x_payroll_line_id,
4297: X_SUB_LINE_START_DATE => l_tmp_start_date,
4333: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
4334: X_MODE => 'R');
4335:
4336:
4337: DELETE psp_payroll_sub_lines
4338: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
4339: end if;
4340: END LOOP;
4341: close get_sublines_csr;
4352: fetch get_sublines_csr into g_sublines_rec;
4353: EXIT WHEN get_sublines_csr%NOTFOUND;
4354: if l_actual_termination_date < g_sublines_rec.sub_line_end_date then
4355: l_tmp_end_date := trunc(l_actual_termination_date) - 1;
4356: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4357: FROM DUAL;
4358: hr_utility.trace(' inserting into Sublines -28');
4359: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4360: X_ROWID => l_rowid,
4355: l_tmp_end_date := trunc(l_actual_termination_date) - 1;
4356: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4357: FROM DUAL;
4358: hr_utility.trace(' inserting into Sublines -28');
4359: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4360: X_ROWID => l_rowid,
4361: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4362: X_PAYROLL_LINE_ID => x_payroll_line_id,
4363: X_SUB_LINE_START_DATE => g_sublines_rec.sub_line_start_date,
4399: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
4400: X_MODE => 'R');
4401:
4402: l_tmp_start_date := trunc(l_actual_termination_date);
4403: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4404: FROM DUAL;
4405: hr_utility.trace(' inserting into Sublines -30');
4406: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4407: X_ROWID => l_rowid,
4402: l_tmp_start_date := trunc(l_actual_termination_date);
4403: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4404: FROM DUAL;
4405: hr_utility.trace(' inserting into Sublines -30');
4406: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4407: X_ROWID => l_rowid,
4408: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4409: X_PAYROLL_LINE_ID => x_payroll_line_id,
4410: X_SUB_LINE_START_DATE => l_tmp_start_date,
4446: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
4447: X_MODE => 'R');
4448:
4449:
4450: DELETE psp_payroll_sub_lines
4451: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
4452:
4453: end if;
4454: END LOOP;
4500: l_new_org_id number(9);
4501:
4502: CURSOR get_sublines_csr IS
4503: SELECT *
4504: FROM psp_payroll_sub_lines
4505: WHERE payroll_line_id = x_payroll_line_id and
4506: ((sub_line_start_date between l_current_start_date and l_current_end_date) or
4507: (sub_line_end_date between l_current_start_date and l_current_end_date) or
4508: (sub_line_start_date <= l_current_start_date and sub_line_end_date >= l_current_end_date))
4558: l_current_end_date > g_sublines_rec.sub_line_end_date) or
4559: (l_current_start_date < g_sublines_rec.sub_line_start_date and
4560: l_current_end_date > g_sublines_rec.sub_line_end_date)) then
4561: begin
4562: UPDATE psp_payroll_sub_lines
4563: set organization_id = l_new_org_id
4564: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
4565: end;
4566: elsif ((l_current_start_date > g_sublines_rec.sub_line_start_date and
4585: if round(x_balance_amount,g_precision) <> 0.00 then
4586: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
4587: end if;
4588:
4589: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4590: FROM DUAL;
4591: hr_utility.trace(' inserting into Sublines -32');
4592: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4593: X_ROWID => l_rowid,
4588:
4589: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4590: FROM DUAL;
4591: hr_utility.trace(' inserting into Sublines -32');
4592: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4593: X_ROWID => l_rowid,
4594: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4595: X_PAYROLL_LINE_ID => x_payroll_line_id,
4596: X_SUB_LINE_START_DATE => g_sublines_rec.sub_line_start_date,
4649: if round(x_balance_amount,g_precision) <> 0.00 then
4650: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
4651: end if;
4652:
4653: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4654: FROM DUAL;
4655: hr_utility.trace(' inserting into Sublines -33');
4656: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4657: X_ROWID => l_rowid,
4652:
4653: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4654: FROM DUAL;
4655: hr_utility.trace(' inserting into Sublines -33');
4656: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4657: X_ROWID => l_rowid,
4658: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4659: X_PAYROLL_LINE_ID => x_payroll_line_id,
4660: X_SUB_LINE_START_DATE => l_tmp_start_date,
4696: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
4697: X_MODE => 'R');
4698:
4699:
4700: DELETE psp_payroll_sub_lines
4701: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
4702: end;
4703: elsif ((l_current_start_date = g_sublines_rec.sub_line_start_date and
4704: l_current_end_date < g_sublines_rec.sub_line_end_date) or
4722: if round(x_balance_amount,g_precision) <> 0.00 then
4723: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
4724: end if;
4725:
4726: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4727: FROM DUAL;
4728: hr_utility.trace(' inserting into Sublines -34');
4729: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4730: X_ROWID => l_rowid,
4725:
4726: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4727: FROM DUAL;
4728: hr_utility.trace(' inserting into Sublines -34');
4729: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4730: X_ROWID => l_rowid,
4731: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4732: X_PAYROLL_LINE_ID => x_payroll_line_id,
4733: X_SUB_LINE_START_DATE => l_tmp_start_date,
4786: if round(x_balance_amount,g_precision) <> 0.00 then
4787: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
4788: end if;
4789:
4790: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4791: FROM DUAL;
4792: hr_utility.trace(' inserting into Sublines -35');
4793: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4794: X_ROWID => l_rowid,
4789:
4790: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4791: FROM DUAL;
4792: hr_utility.trace(' inserting into Sublines -35');
4793: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4794: X_ROWID => l_rowid,
4795: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4796: X_PAYROLL_LINE_ID => x_payroll_line_id,
4797: X_SUB_LINE_START_DATE => l_tmp_start_date,
4833: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
4834: X_MODE => 'R');
4835:
4836:
4837: DELETE psp_payroll_sub_lines
4838: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
4839: end;
4840: else
4841: begin
4856: if round(x_balance_amount,g_precision) <> 0.00 then
4857: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
4858: end if;
4859:
4860: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4861: FROM DUAL;
4862: hr_utility.trace(' inserting into Sublines -37');
4863: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4864: X_ROWID => l_rowid,
4859:
4860: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4861: FROM DUAL;
4862: hr_utility.trace(' inserting into Sublines -37');
4863: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4864: X_ROWID => l_rowid,
4865: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4866: X_PAYROLL_LINE_ID => x_payroll_line_id,
4867: X_SUB_LINE_START_DATE => l_tmp_start_date,
4920: if round(x_balance_amount,g_precision) <> 0.00 then
4921: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
4922: end if;
4923:
4924: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4925: FROM DUAL;
4926: hr_utility.trace(' inserting into Sublines -39');
4927: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4928: X_ROWID => l_rowid,
4923:
4924: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4925: FROM DUAL;
4926: hr_utility.trace(' inserting into Sublines -39');
4927: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4928: X_ROWID => l_rowid,
4929: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4930: X_PAYROLL_LINE_ID => x_payroll_line_id,
4931: X_SUB_LINE_START_DATE => l_tmp_start_date,
4984: if round(x_balance_amount,g_precision) <> 0.00 then
4985: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
4986: end if;
4987:
4988: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4989: FROM DUAL;
4990: hr_utility.trace(' inserting into Sublines -42');
4991: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4992: X_ROWID => l_rowid,
4987:
4988: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4989: FROM DUAL;
4990: hr_utility.trace(' inserting into Sublines -42');
4991: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4992: X_ROWID => l_rowid,
4993: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4994: X_PAYROLL_LINE_ID => x_payroll_line_id,
4995: X_SUB_LINE_START_DATE => l_tmp_start_date,
5031: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
5032: X_MODE => 'R');
5033:
5034:
5035: DELETE psp_payroll_sub_lines
5036: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
5037: end;
5038: end if;
5039: l_old_org_id := l_new_org_id;
5093: l_new_job_id number(9);
5094:
5095: CURSOR get_sublines_csr IS
5096: SELECT *
5097: FROM psp_payroll_sub_lines
5098: WHERE payroll_line_id = x_payroll_line_id and
5099: ((sub_line_start_date between l_current_start_date and l_current_end_date) or
5100: (sub_line_end_date between l_current_start_date and l_current_end_date) or
5101: (sub_line_start_date <= l_current_start_date and sub_line_end_date >= l_current_end_date))
5143: l_current_end_date > g_sublines_rec.sub_line_end_date) or
5144: (l_current_start_date < g_sublines_rec.sub_line_start_date and
5145: l_current_end_date > g_sublines_rec.sub_line_end_date)) then
5146: begin
5147: UPDATE psp_payroll_sub_lines
5148: set job_id = l_new_job_id
5149: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
5150: end;
5151: elsif ((l_current_start_date > g_sublines_rec.sub_line_start_date and
5170: if round(x_balance_amount,g_precision) <> 0.00 then
5171: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5172: end if;
5173:
5174: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5175: FROM DUAL;
5176: hr_utility.trace(' inserting into Sublines -52');
5177: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5178: X_ROWID => l_rowid,
5173:
5174: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5175: FROM DUAL;
5176: hr_utility.trace(' inserting into Sublines -52');
5177: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5178: X_ROWID => l_rowid,
5179: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5180: X_PAYROLL_LINE_ID => x_payroll_line_id,
5181: X_SUB_LINE_START_DATE => g_sublines_rec.sub_line_start_date,
5234: if round(x_balance_amount,g_precision) <> 0.00 then
5235: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5236: end if;
5237:
5238: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5239: FROM DUAL;
5240: hr_utility.trace(' inserting into Sublines -62');
5241: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5242: X_ROWID => l_rowid,
5237:
5238: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5239: FROM DUAL;
5240: hr_utility.trace(' inserting into Sublines -62');
5241: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5242: X_ROWID => l_rowid,
5243: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5244: X_PAYROLL_LINE_ID => x_payroll_line_id,
5245: X_SUB_LINE_START_DATE => l_tmp_start_date,
5281: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
5282: X_MODE => 'R' );
5283:
5284:
5285: DELETE psp_payroll_sub_lines
5286: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
5287: end;
5288: elsif ((l_current_start_date = g_sublines_rec.sub_line_start_date and
5289: l_current_end_date < g_sublines_rec.sub_line_end_date) or
5307: if round(x_balance_amount,g_precision) <> 0.00 then
5308: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5309: end if;
5310:
5311: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5312: FROM DUAL;
5313: hr_utility.trace(' inserting into Sublines -92');
5314: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5315: X_ROWID => l_rowid,
5310:
5311: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5312: FROM DUAL;
5313: hr_utility.trace(' inserting into Sublines -92');
5314: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5315: X_ROWID => l_rowid,
5316: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5317: X_PAYROLL_LINE_ID => x_payroll_line_id,
5318: X_SUB_LINE_START_DATE => l_tmp_start_date,
5371: if round(x_balance_amount,g_precision) <> 0.00 then
5372: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5373: end if;
5374:
5375: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5376: FROM DUAL;
5377: hr_utility.trace(' inserting into Sublines -102');
5378: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5379: X_ROWID => l_rowid,
5374:
5375: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5376: FROM DUAL;
5377: hr_utility.trace(' inserting into Sublines -102');
5378: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5379: X_ROWID => l_rowid,
5380: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5381: X_PAYROLL_LINE_ID => x_payroll_line_id,
5382: X_SUB_LINE_START_DATE => l_tmp_start_date,
5418: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
5419: X_MODE => 'R' );
5420:
5421:
5422: DELETE psp_payroll_sub_lines
5423: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
5424: end;
5425: else
5426: begin
5441: if round(x_balance_amount,g_precision) <> 0.00 then
5442: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5443: end if;
5444:
5445: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5446: FROM DUAL;
5447: hr_utility.trace(' inserting into Sublines -202');
5448: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5449: X_ROWID => l_rowid,
5444:
5445: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5446: FROM DUAL;
5447: hr_utility.trace(' inserting into Sublines -202');
5448: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5449: X_ROWID => l_rowid,
5450: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5451: X_PAYROLL_LINE_ID => x_payroll_line_id,
5452: X_SUB_LINE_START_DATE => l_tmp_start_date,
5505: if round(x_balance_amount,g_precision) <> 0.00 then
5506: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5507: end if;
5508:
5509: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5510: FROM DUAL;
5511: hr_utility.trace(' inserting into Sublines -302');
5512: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5513: X_ROWID => l_rowid,
5508:
5509: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5510: FROM DUAL;
5511: hr_utility.trace(' inserting into Sublines -302');
5512: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5513: X_ROWID => l_rowid,
5514: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5515: X_PAYROLL_LINE_ID => x_payroll_line_id,
5516: X_SUB_LINE_START_DATE => l_tmp_start_date,
5569: if round(x_balance_amount,g_precision) <> 0.00 then
5570: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5571: end if;
5572:
5573: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5574: FROM DUAL;
5575: hr_utility.trace(' inserting into Sublines -402');
5576: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5577: X_ROWID => l_rowid,
5572:
5573: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5574: FROM DUAL;
5575: hr_utility.trace(' inserting into Sublines -402');
5576: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5577: X_ROWID => l_rowid,
5578: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5579: X_PAYROLL_LINE_ID => x_payroll_line_id,
5580: X_SUB_LINE_START_DATE => l_tmp_start_date,
5616: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
5617: X_MODE => 'R');
5618:
5619:
5620: DELETE psp_payroll_sub_lines
5621: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
5622: end;
5623: end if;
5624: l_old_job_id := l_new_job_id;
5683: l_new_position_id number(15); -- Bug 2231410 : Increased the lenght of position_id column from 9 to 15
5684:
5685: CURSOR get_sublines_csr IS
5686: SELECT *
5687: FROM psp_payroll_sub_lines
5688: WHERE payroll_line_id = x_payroll_line_id and
5689: ((sub_line_start_date between l_current_start_date and l_current_end_date) or
5690: (sub_line_end_date between l_current_start_date and l_current_end_date) or
5691: (sub_line_start_date <= l_current_start_date and sub_line_end_date >= l_current_end_date))
5733: l_current_end_date > g_sublines_rec.sub_line_end_date) or
5734: (l_current_start_date < g_sublines_rec.sub_line_start_date and
5735: l_current_end_date > g_sublines_rec.sub_line_end_date)) then
5736: begin
5737: UPDATE psp_payroll_sub_lines
5738: set position_id = l_new_position_id
5739: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
5740: end;
5741: elsif ((l_current_start_date > g_sublines_rec.sub_line_start_date and
5760: if round(x_balance_amount,g_precision) <> 0.00 then
5761: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5762: end if;
5763:
5764: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5765: FROM DUAL;
5766: hr_utility.trace(' inserting into Sublines -502');
5767: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5768: X_ROWID => l_rowid,
5763:
5764: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5765: FROM DUAL;
5766: hr_utility.trace(' inserting into Sublines -502');
5767: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5768: X_ROWID => l_rowid,
5769: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5770: X_PAYROLL_LINE_ID => x_payroll_line_id,
5771: X_SUB_LINE_START_DATE => g_sublines_rec.sub_line_start_date,
5824: if round(x_balance_amount,g_precision) <> 0.00 then
5825: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5826: end if;
5827:
5828: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5829: FROM DUAL;
5830: hr_utility.trace(' inserting into Sublines -502');
5831: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5832: X_ROWID => l_rowid,
5827:
5828: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5829: FROM DUAL;
5830: hr_utility.trace(' inserting into Sublines -502');
5831: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5832: X_ROWID => l_rowid,
5833: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5834: X_PAYROLL_LINE_ID => x_payroll_line_id,
5835: X_SUB_LINE_START_DATE => l_tmp_start_date,
5871: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
5872: X_MODE => 'R');
5873:
5874:
5875: DELETE psp_payroll_sub_lines
5876: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
5877: end;
5878: elsif ((l_current_start_date = g_sublines_rec.sub_line_start_date and
5879: l_current_end_date < g_sublines_rec.sub_line_end_date) or
5897: if round(x_balance_amount,g_precision) <> 0.00 then
5898: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5899: end if;
5900:
5901: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5902: FROM DUAL;
5903: hr_utility.trace(' inserting into Sublines -702');
5904: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5905: X_ROWID => l_rowid,
5900:
5901: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5902: FROM DUAL;
5903: hr_utility.trace(' inserting into Sublines -702');
5904: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5905: X_ROWID => l_rowid,
5906: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5907: X_PAYROLL_LINE_ID => x_payroll_line_id,
5908: X_SUB_LINE_START_DATE => l_tmp_start_date,
5961: if round(x_balance_amount,g_precision) <> 0.00 then
5962: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5963: end if;
5964:
5965: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5966: FROM DUAL;
5967: hr_utility.trace(' inserting into Sublines -802');
5968: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5969: X_ROWID => l_rowid,
5964:
5965: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5966: FROM DUAL;
5967: hr_utility.trace(' inserting into Sublines -802');
5968: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5969: X_ROWID => l_rowid,
5970: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5971: X_PAYROLL_LINE_ID => x_payroll_line_id,
5972: X_SUB_LINE_START_DATE => l_tmp_start_date,
6008: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
6009: X_MODE => 'R' );
6010:
6011:
6012: DELETE psp_payroll_sub_lines
6013: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
6014: end;
6015: else
6016: begin
6031: if round(x_balance_amount,g_precision) <> 0.00 then
6032: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6033: end if;
6034:
6035: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6036: FROM DUAL;
6037: hr_utility.trace(' inserting into Sublines -902');
6038: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6039: X_ROWID => l_rowid,
6034:
6035: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6036: FROM DUAL;
6037: hr_utility.trace(' inserting into Sublines -902');
6038: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6039: X_ROWID => l_rowid,
6040: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6041: X_PAYROLL_LINE_ID => x_payroll_line_id,
6042: X_SUB_LINE_START_DATE => l_tmp_start_date,
6095: if round(x_balance_amount,g_precision) <> 0.00 then
6096: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)),g_precision);
6097: end if;
6098:
6099: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6100: FROM DUAL;
6101: hr_utility.trace(' inserting into Sublines -802');
6102: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6103: X_ROWID => l_rowid,
6098:
6099: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6100: FROM DUAL;
6101: hr_utility.trace(' inserting into Sublines -802');
6102: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6103: X_ROWID => l_rowid,
6104: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6105: X_PAYROLL_LINE_ID => x_payroll_line_id,
6106: X_SUB_LINE_START_DATE => l_tmp_start_date,
6159: if round(x_balance_amount,g_precision) <> 0.00 then
6160: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6161: end if;
6162:
6163: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6164: FROM DUAL;
6165: hr_utility.trace(' inserting into Sublines -1002');
6166: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6167: X_ROWID => l_rowid,
6162:
6163: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6164: FROM DUAL;
6165: hr_utility.trace(' inserting into Sublines -1002');
6166: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6167: X_ROWID => l_rowid,
6168: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6169: X_PAYROLL_LINE_ID => x_payroll_line_id,
6170: X_SUB_LINE_START_DATE => l_tmp_start_date,
6206: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
6207: X_MODE => 'R');
6208:
6209:
6210: DELETE psp_payroll_sub_lines
6211: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
6212: end;
6213: end if;
6214: l_old_position_id := l_new_position_id;
6276: l_new_grade_id number(9);
6277:
6278: CURSOR get_sublines_csr IS
6279: SELECT *
6280: FROM psp_payroll_sub_lines
6281: WHERE payroll_line_id = x_payroll_line_id and
6282: ((sub_line_start_date between l_current_start_date and l_current_end_date) or
6283: (sub_line_end_date between l_current_start_date and l_current_end_date) or
6284: (sub_line_start_date <= l_current_start_date and sub_line_end_date >= l_current_end_date))
6324: l_current_end_date > g_sublines_rec.sub_line_end_date) or
6325: (l_current_start_date < g_sublines_rec.sub_line_start_date and
6326: l_current_end_date > g_sublines_rec.sub_line_end_date)) then
6327: begin
6328: UPDATE psp_payroll_sub_lines
6329: set grade_id = l_new_grade_id
6330: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
6331: end;
6332: elsif ((l_current_start_date > g_sublines_rec.sub_line_start_date and
6351: if round(x_balance_amount,g_precision) <> 0.00 then
6352: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6353: end if;
6354:
6355: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6356: FROM DUAL;
6357: hr_utility.trace(' inserting into Sublines -2002');
6358: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6359: X_ROWID => l_rowid,
6354:
6355: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6356: FROM DUAL;
6357: hr_utility.trace(' inserting into Sublines -2002');
6358: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6359: X_ROWID => l_rowid,
6360: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6361: X_PAYROLL_LINE_ID => x_payroll_line_id,
6362: X_SUB_LINE_START_DATE => g_sublines_rec.sub_line_start_date,
6415: if round(x_balance_amount,g_precision) <> 0.00 then
6416: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6417: end if;
6418:
6419: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6420: FROM DUAL;
6421: hr_utility.trace(' inserting into Sublines -3002');
6422: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6423: X_ROWID => l_rowid,
6418:
6419: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6420: FROM DUAL;
6421: hr_utility.trace(' inserting into Sublines -3002');
6422: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6423: X_ROWID => l_rowid,
6424: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6425: X_PAYROLL_LINE_ID => x_payroll_line_id,
6426: X_SUB_LINE_START_DATE => l_tmp_start_date,
6462: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
6463: X_MODE => 'R');
6464:
6465:
6466: DELETE psp_payroll_sub_lines
6467: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
6468: end;
6469: elsif ((l_current_start_date = g_sublines_rec.sub_line_start_date and
6470: l_current_end_date < g_sublines_rec.sub_line_end_date) or
6488: if round(x_balance_amount, g_precision) <> 0.00 then
6489: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6490: end if;
6491:
6492: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6493: FROM DUAL;
6494: hr_utility.trace(' inserting into Sublines -4002');
6495: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6496: X_ROWID => l_rowid,
6491:
6492: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6493: FROM DUAL;
6494: hr_utility.trace(' inserting into Sublines -4002');
6495: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6496: X_ROWID => l_rowid,
6497: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6498: X_PAYROLL_LINE_ID => x_payroll_line_id,
6499: X_SUB_LINE_START_DATE => l_tmp_start_date,
6552: if round(x_balance_amount, g_precision) <> 0.00 then
6553: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6554: end if;
6555:
6556: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6557: FROM DUAL;
6558: hr_utility.trace(' inserting into Sublines -5002');
6559: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6560: X_ROWID => l_rowid,
6555:
6556: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6557: FROM DUAL;
6558: hr_utility.trace(' inserting into Sublines -5002');
6559: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6560: X_ROWID => l_rowid,
6561: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6562: X_PAYROLL_LINE_ID => x_payroll_line_id,
6563: X_SUB_LINE_START_DATE => l_tmp_start_date,
6599: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
6600: X_MODE => 'R' );
6601:
6602:
6603: DELETE psp_payroll_sub_lines
6604: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
6605: end;
6606: else
6607: begin
6622: if round(x_balance_amount, g_precision) <> 0.00 then
6623: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6624: end if;
6625:
6626: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6627: FROM DUAL;
6628: hr_utility.trace(' inserting into Sublines -6002');
6629: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6630: X_ROWID => l_rowid,
6625:
6626: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6627: FROM DUAL;
6628: hr_utility.trace(' inserting into Sublines -6002');
6629: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6630: X_ROWID => l_rowid,
6631: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6632: X_PAYROLL_LINE_ID => x_payroll_line_id,
6633: X_SUB_LINE_START_DATE => l_tmp_start_date,
6686: if round(x_balance_amount, g_precision) <> 0.00 then
6687: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6688: end if;
6689:
6690: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6691: FROM DUAL;
6692: hr_utility.trace(' inserting into Sublines -7002');
6693: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6694: X_ROWID => l_rowid,
6689:
6690: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6691: FROM DUAL;
6692: hr_utility.trace(' inserting into Sublines -7002');
6693: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6694: X_ROWID => l_rowid,
6695: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6696: X_PAYROLL_LINE_ID => x_payroll_line_id,
6697: X_SUB_LINE_START_DATE => l_tmp_start_date,
6750: if round(x_balance_amount, g_precision) <> 0.00 then
6751: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6752: end if;
6753:
6754: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6755: FROM DUAL;
6756: hr_utility.trace(' inserting into Sublines -8002');
6757: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6758: X_ROWID => l_rowid,
6753:
6754: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6755: FROM DUAL;
6756: hr_utility.trace(' inserting into Sublines -8002');
6757: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6758: X_ROWID => l_rowid,
6759: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6760: X_PAYROLL_LINE_ID => x_payroll_line_id,
6761: X_SUB_LINE_START_DATE => l_tmp_start_date,
6797: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
6798: X_MODE => 'R');
6799:
6800:
6801: DELETE psp_payroll_sub_lines
6802: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
6803: end;
6804: end if;
6805: l_old_grade_id := l_new_grade_id;
6871: l_new_ppgroup_id number(9);
6872:
6873: CURSOR get_sublines_csr IS
6874: SELECT *
6875: FROM psp_payroll_sub_lines
6876: WHERE payroll_line_id = x_payroll_line_id and
6877: ((sub_line_start_date between l_current_start_date and l_current_end_date) or
6878: (sub_line_end_date between l_current_start_date and l_current_end_date) or
6879: (sub_line_start_date <= l_current_start_date and sub_line_end_date >= l_current_end_date))
6919: l_current_end_date > g_sublines_rec.sub_line_end_date) or
6920: (l_current_start_date < g_sublines_rec.sub_line_start_date and
6921: l_current_end_date > g_sublines_rec.sub_line_end_date)) then
6922: begin
6923: UPDATE psp_payroll_sub_lines
6924: set people_group_id = l_new_ppgroup_id
6925: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
6926: end;
6927: elsif ((l_current_start_date > g_sublines_rec.sub_line_start_date and
6946: if round(x_balance_amount, g_precision) <> 0.00 then
6947: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6948: end if;
6949:
6950: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6951: FROM DUAL;
6952: hr_utility.trace(' inserting into Sublines -9002');
6953: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6954: X_ROWID => l_rowid,
6949:
6950: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6951: FROM DUAL;
6952: hr_utility.trace(' inserting into Sublines -9002');
6953: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6954: X_ROWID => l_rowid,
6955: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6956: X_PAYROLL_LINE_ID => x_payroll_line_id,
6957: X_SUB_LINE_START_DATE => g_sublines_rec.sub_line_start_date,
7010: if round(x_balance_amount, g_precision) <> 0.00 then
7011: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7012: end if;
7013:
7014: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7015: FROM DUAL;
7016: hr_utility.trace(' inserting into Sublines -2Y');
7017: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7018: X_ROWID => l_rowid,
7013:
7014: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7015: FROM DUAL;
7016: hr_utility.trace(' inserting into Sublines -2Y');
7017: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7018: X_ROWID => l_rowid,
7019: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7020: X_PAYROLL_LINE_ID => x_payroll_line_id,
7021: X_SUB_LINE_START_DATE => l_tmp_start_date,
7057: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
7058: X_MODE => 'R');
7059:
7060:
7061: DELETE psp_payroll_sub_lines
7062: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
7063: end;
7064: elsif ((l_current_start_date = g_sublines_rec.sub_line_start_date and
7065: l_current_end_date < g_sublines_rec.sub_line_end_date) or
7083: if round(x_balance_amount, g_precision) <> 0.00 then
7084: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7085: end if;
7086:
7087: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7088: FROM DUAL;
7089: hr_utility.trace(' inserting into Sublines -2OX');
7090: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7091: X_ROWID => l_rowid,
7086:
7087: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7088: FROM DUAL;
7089: hr_utility.trace(' inserting into Sublines -2OX');
7090: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7091: X_ROWID => l_rowid,
7092: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7093: X_PAYROLL_LINE_ID => x_payroll_line_id,
7094: X_SUB_LINE_START_DATE => l_tmp_start_date,
7147: if round(x_balance_amount, g_precision) <> 0.00 then
7148: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7149: end if;
7150:
7151: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7152: FROM DUAL;
7153: hr_utility.trace(' inserting into Sublines -2LXL');
7154: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7155: X_ROWID => l_rowid,
7150:
7151: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7152: FROM DUAL;
7153: hr_utility.trace(' inserting into Sublines -2LXL');
7154: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7155: X_ROWID => l_rowid,
7156: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7157: X_PAYROLL_LINE_ID => x_payroll_line_id,
7158: X_SUB_LINE_START_DATE => l_tmp_start_date,
7194: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
7195: X_MODE => 'R' );
7196:
7197:
7198: DELETE psp_payroll_sub_lines
7199: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
7200: end;
7201: else
7202: begin
7217: if round(x_balance_amount, g_precision) <> 0.00 then
7218: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7219: end if;
7220:
7221: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7222: FROM DUAL;
7223: hr_utility.trace(' inserting into Sublines -2UIORA');
7224: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7225: X_ROWID => l_rowid,
7220:
7221: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7222: FROM DUAL;
7223: hr_utility.trace(' inserting into Sublines -2UIORA');
7224: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7225: X_ROWID => l_rowid,
7226: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7227: X_PAYROLL_LINE_ID => x_payroll_line_id,
7228: X_SUB_LINE_START_DATE => l_tmp_start_date,
7281: if round(x_balance_amount, g_precision) <> 0.00 then
7282: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7283: end if;
7284:
7285: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7286: FROM DUAL;
7287: hr_utility.trace(' inserting into Sublines -2JADF');
7288: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7289: X_ROWID => l_rowid,
7284:
7285: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7286: FROM DUAL;
7287: hr_utility.trace(' inserting into Sublines -2JADF');
7288: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7289: X_ROWID => l_rowid,
7290: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7291: X_PAYROLL_LINE_ID => x_payroll_line_id,
7292: X_SUB_LINE_START_DATE => l_tmp_start_date,
7345: if round(x_balance_amount, g_precision) <> 0.00 then
7346: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7347: end if;
7348:
7349: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7350: FROM DUAL;
7351: hr_utility.trace(' inserting into Sublines -299ek');
7352: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7353: X_ROWID => l_rowid,
7348:
7349: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7350: FROM DUAL;
7351: hr_utility.trace(' inserting into Sublines -299ek');
7352: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7353: X_ROWID => l_rowid,
7354: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7355: X_PAYROLL_LINE_ID => x_payroll_line_id,
7356: X_SUB_LINE_START_DATE => l_tmp_start_date,
7392: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
7393: X_MODE => 'R');
7394:
7395:
7396: DELETE psp_payroll_sub_lines
7397: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
7398: end;
7399: end if;
7400: l_old_ppgroup_id := l_new_ppgroup_id;
7444: l_new_fte number(22,2);
7445:
7446: CURSOR get_sublines_csr IS
7447: SELECT *
7448: FROM psp_payroll_sub_lines
7449: WHERE payroll_line_id = x_payroll_line_id and
7450: ((sub_line_start_date between l_current_start_date and l_current_end_date) or
7451: (sub_line_end_date between l_current_start_date and l_current_end_date) or
7452: (sub_line_start_date <= l_current_start_date and sub_line_end_date >= l_current_end_date))
7598: l_current_end_date > g_sublines_rec.sub_line_end_date) or
7599: (l_current_start_date < g_sublines_rec.sub_line_start_date and
7600: l_current_end_date > g_sublines_rec.sub_line_end_date)) then
7601: begin
7602: UPDATE psp_payroll_sub_lines
7603: set fte = l_new_fte
7604: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
7605: end;
7606: elsif ((l_current_start_date > g_sublines_rec.sub_line_start_date and
7625: if round(x_balance_amount, g_precision) <> 0.00 then
7626: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7627: end if;
7628:
7629: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7630: FROM DUAL;
7631: hr_utility.trace(' inserting into Sublines -2kdfd');
7632: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7633: X_ROWID => l_rowid,
7628:
7629: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7630: FROM DUAL;
7631: hr_utility.trace(' inserting into Sublines -2kdfd');
7632: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7633: X_ROWID => l_rowid,
7634: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7635: X_PAYROLL_LINE_ID => x_payroll_line_id,
7636: X_SUB_LINE_START_DATE => g_sublines_rec.sub_line_start_date,
7689: if round(x_balance_amount, g_precision) <> 0.00 then
7690: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7691: end if;
7692:
7693: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7694: FROM DUAL;
7695: hr_utility.trace(' inserting into Sublines -2LKJL:JL');
7696: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7697: X_ROWID => l_rowid,
7692:
7693: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7694: FROM DUAL;
7695: hr_utility.trace(' inserting into Sublines -2LKJL:JL');
7696: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7697: X_ROWID => l_rowid,
7698: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7699: X_PAYROLL_LINE_ID => x_payroll_line_id,
7700: X_SUB_LINE_START_DATE => l_tmp_start_date,
7734: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7735: X_REASON_CODE => 'FTE_CHANGE',
7736: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
7737: X_MODE => 'R');
7738: DELETE psp_payroll_sub_lines
7739: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
7740: end;
7741: elsif ((l_current_start_date = g_sublines_rec.sub_line_start_date and
7742: l_current_end_date < g_sublines_rec.sub_line_end_date) or
7760: if round(x_balance_amount, g_precision) <> 0.00 then
7761: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7762: end if;
7763:
7764: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7765: FROM DUAL;
7766: hr_utility.trace(' inserting into Sublines -2UUUUUUAA');
7767: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7768: X_ROWID => l_rowid,
7763:
7764: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7765: FROM DUAL;
7766: hr_utility.trace(' inserting into Sublines -2UUUUUUAA');
7767: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7768: X_ROWID => l_rowid,
7769: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7770: X_PAYROLL_LINE_ID => x_payroll_line_id,
7771: X_SUB_LINE_START_DATE => l_tmp_start_date,
7827:
7828: SELECT PSP_PAYROLL_LINES_S.NEXTVAL into l_sub_line_id
7829: FROM DUAL;
7830: hr_utility.trace(' inserting into Sublines -2KKKKK');
7831: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7832: X_ROWID => l_rowid,
7833: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7834: X_PAYROLL_LINE_ID => x_payroll_line_id,
7835: X_SUB_LINE_START_DATE => l_tmp_start_date,
7871: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
7872: X_MODE => 'R');
7873:
7874:
7875: DELETE psp_payroll_sub_lines
7876: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
7877: end;
7878: else
7879: begin
7894: if round(x_balance_amount, g_precision) <> 0.00 then
7895: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7896: end if;
7897:
7898: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7899: FROM DUAL;
7900: hr_utility.trace(' inserting into Sublines -2OOOPP888');
7901: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7902: X_ROWID => l_rowid,
7897:
7898: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7899: FROM DUAL;
7900: hr_utility.trace(' inserting into Sublines -2OOOPP888');
7901: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7902: X_ROWID => l_rowid,
7903: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7904: X_PAYROLL_LINE_ID => x_payroll_line_id,
7905: X_SUB_LINE_START_DATE => l_tmp_start_date,
7958: if round(x_balance_amount, g_precision) <> 0.00 then
7959: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7960: end if;
7961:
7962: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7963: FROM DUAL;
7964: hr_utility.trace(' inserting into Sublines -27777MMMN');
7965: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7966: X_ROWID => l_rowid,
7961:
7962: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7963: FROM DUAL;
7964: hr_utility.trace(' inserting into Sublines -27777MMMN');
7965: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7966: X_ROWID => l_rowid,
7967: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7968: X_PAYROLL_LINE_ID => x_payroll_line_id,
7969: X_SUB_LINE_START_DATE => l_tmp_start_date,
8022: if round(x_balance_amount, g_precision) <> 0.00 then
8023: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8024: end if;
8025:
8026: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8027: FROM DUAL;
8028: hr_utility.trace(' inserting into Sublines -2EEEERRSS');
8029: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8030: X_ROWID => l_rowid,
8025:
8026: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8027: FROM DUAL;
8028: hr_utility.trace(' inserting into Sublines -2EEEERRSS');
8029: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8030: X_ROWID => l_rowid,
8031: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8032: X_PAYROLL_LINE_ID => x_payroll_line_id,
8033: X_SUB_LINE_START_DATE => l_tmp_start_date,
8069: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
8070: X_MODE => 'R');
8071:
8072:
8073: DELETE psp_payroll_sub_lines
8074: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
8075: end;
8076: end if;
8077: l_old_fte := l_new_fte;
8142: l_new_value per_assignment_budget_values_f.value%type;
8143:
8144: CURSOR get_sublines_csr IS
8145: SELECT *
8146: FROM psp_payroll_sub_lines
8147: WHERE payroll_line_id = x_payroll_line_id and
8148: ((sub_line_start_date between l_current_start_date and l_current_end_date) or
8149: (sub_line_end_date between l_current_start_date and l_current_end_date) or
8150: (sub_line_start_date >= l_current_start_date and sub_line_end_date >= l_current_end_date))
8201: l_current_end_date > g_sublines_rec.sub_line_end_date) or
8202: (l_current_start_date < g_sublines_rec.sub_line_start_date and
8203: l_current_end_date > g_sublines_rec.sub_line_end_date)) then
8204: begin
8205: UPDATE psp_payroll_sub_lines
8206: set fte = l_new_value
8207: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
8208: end;
8209: elsif ((l_current_start_date > g_sublines_rec.sub_line_start_date and
8228: if round(x_balance_amount, g_precision) <> 0.00 then
8229: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8230: end if;
8231:
8232: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8233: FROM DUAL;
8234: hr_utility.trace(' inserting into Sublines -2WWWEEERR');
8235: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8236: X_ROWID => l_rowid,
8231:
8232: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8233: FROM DUAL;
8234: hr_utility.trace(' inserting into Sublines -2WWWEEERR');
8235: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8236: X_ROWID => l_rowid,
8237: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8238: X_PAYROLL_LINE_ID => x_payroll_line_id,
8239: X_SUB_LINE_START_DATE => g_sublines_rec.sub_line_start_date,
8292: if round(x_balance_amount, g_precision) <> 0.00 then
8293: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8294: end if;
8295:
8296: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8297: FROM DUAL;
8298: hr_utility.trace(' inserting into Sublines -29999*****888');
8299: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8300: X_ROWID => l_rowid,
8295:
8296: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8297: FROM DUAL;
8298: hr_utility.trace(' inserting into Sublines -29999*****888');
8299: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8300: X_ROWID => l_rowid,
8301: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8302: X_PAYROLL_LINE_ID => x_payroll_line_id,
8303: X_SUB_LINE_START_DATE => l_tmp_start_date,
8339: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
8340: X_MODE => 'R');
8341:
8342:
8343: DELETE psp_payroll_sub_lines
8344: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
8345: end;
8346: elsif ((l_current_start_date = g_sublines_rec.sub_line_start_date and
8347: l_current_end_date < g_sublines_rec.sub_line_end_date) or
8365: if round(x_balance_amount, g_precision) <> 0.00 then
8366: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8367: end if;
8368:
8369: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8370: FROM DUAL;
8371: hr_utility.trace(' inserting into Sublines -2DDDDDD');
8372: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8373: X_ROWID => l_rowid,
8368:
8369: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8370: FROM DUAL;
8371: hr_utility.trace(' inserting into Sublines -2DDDDDD');
8372: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8373: X_ROWID => l_rowid,
8374: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8375: X_PAYROLL_LINE_ID => x_payroll_line_id,
8376: X_SUB_LINE_START_DATE => l_tmp_start_date,
8429: if round(x_balance_amount, g_precision) <> 0.00 then
8430: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8431: end if;
8432:
8433: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8434: FROM DUAL;
8435: hr_utility.trace(' inserting into Sublines -2UKOSO');
8436: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8437: X_ROWID => l_rowid,
8432:
8433: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8434: FROM DUAL;
8435: hr_utility.trace(' inserting into Sublines -2UKOSO');
8436: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8437: X_ROWID => l_rowid,
8438: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8439: X_PAYROLL_LINE_ID => x_payroll_line_id,
8440: X_SUB_LINE_START_DATE => l_tmp_start_date,
8476: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
8477: X_MODE => 'R' );
8478:
8479:
8480: DELETE psp_payroll_sub_lines
8481: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
8482: end;
8483: else
8484: begin
8499: if round(x_balance_amount,g_precision) <> 0.00 then
8500: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8501: end if;
8502:
8503: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8504: FROM DUAL;
8505: hr_utility.trace(' inserting into Sublines -2JYUPA');
8506: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8507: X_ROWID => l_rowid,
8502:
8503: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8504: FROM DUAL;
8505: hr_utility.trace(' inserting into Sublines -2JYUPA');
8506: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8507: X_ROWID => l_rowid,
8508: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8509: X_PAYROLL_LINE_ID => x_payroll_line_id,
8510: X_SUB_LINE_START_DATE => l_tmp_start_date,
8563: if round(x_balance_amount, g_precision) <> 0.00 then
8564: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8565: end if;
8566:
8567: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8568: FROM DUAL;
8569: hr_utility.trace(' inserting into Sublines -2NBMM');
8570: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8571: X_ROWID => l_rowid,
8566:
8567: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8568: FROM DUAL;
8569: hr_utility.trace(' inserting into Sublines -2NBMM');
8570: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8571: X_ROWID => l_rowid,
8572: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8573: X_PAYROLL_LINE_ID => x_payroll_line_id,
8574: X_SUB_LINE_START_DATE => l_tmp_start_date,
8627: if round(x_balance_amount,g_precision) <> 0.00 then
8628: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8629: end if;
8630:
8631: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8632: FROM DUAL;
8633: hr_utility.trace(' inserting into Sublines -2TOPP');
8634: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8635: X_ROWID => l_rowid,
8630:
8631: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8632: FROM DUAL;
8633: hr_utility.trace(' inserting into Sublines -2TOPP');
8634: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8635: X_ROWID => l_rowid,
8636: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8637: X_PAYROLL_LINE_ID => x_payroll_line_id,
8638: X_SUB_LINE_START_DATE => l_tmp_start_date,
8674: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
8675: X_MODE => 'R');
8676:
8677:
8678: DELETE psp_payroll_sub_lines
8679: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
8680: end;
8681: end if;
8682: l_old_value := l_new_value;
8823:
8824: Who When What
8825: lveerubh 15-SEP-2001 Creating the procedure
8826: This procedure inserts a single line
8827: into psp_payroll_lines and psp_payroll_sub_lines
8828: with sub line start date and sub line end date
8829: as date earned
8830: amakrish 01-Apr-2008 Changed the sub line start date and sub line end date
8831: to be least of date earned or payroll period end date
8863: psp_payroll_lines
8864: where payroll_line_id = x_payroll_line_id));
8865:
8866: -- Inserting into PSP_SUB_LINES
8867: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
8868: hr_utility.trace(' inserting into Sublines -2UISISI');
8869: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8870: X_ROWID => l_rowid,
8871: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8865:
8866: -- Inserting into PSP_SUB_LINES
8867: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
8868: hr_utility.trace(' inserting into Sublines -2UISISI');
8869: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8870: X_ROWID => l_rowid,
8871: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8872: X_PAYROLL_LINE_ID => x_payroll_line_id,
8873: X_SUB_LINE_START_DATE => least(trunc(g_payroll_line_rec.effective_Date), trunc(l_tp_end_date)), /*Bug 6886237*/
9046: l_final_salary := round((l_total_salary + l_balance_amount), g_precision);
9047: hr_utility.trace(' l_finally_salary 2= '||l_final_salary);
9048: END IF;
9049:
9050: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
9051:
9052: hr_utility.trace(' inserting into Sublines -2LLLLLLLALALAL');
9053: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW
9054: (X_ROWID => l_rowid,
9049:
9050: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
9051:
9052: hr_utility.trace(' inserting into Sublines -2LLLLLLLALALAL');
9053: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW
9054: (X_ROWID => l_rowid,
9055: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
9056: X_PAYROLL_LINE_ID => p_payroll_line_id,
9057: X_SUB_LINE_START_DATE => l_start_date,