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.PSP_PAYTRN dependencies on PSP_PAYROLL_SUB_LINES

Line 361: FROM psp_payroll_sub_lines

357: l_line_id number(9) := 0;
358:
359: CURSOR get_difference_csr is
360: SELECT sum(pay_amount)
361: FROM psp_payroll_sub_lines
362: WHERE payroll_line_id = l_line_id;
363:
364: l_subline_sum NUMBER := 0; -- Corrected to NUMBER from NUMBER(22, 2) for bug fix 2916848
365:

Line 1519: -- write single sub-line in PSP_PAYROLL_SUB_LINES

1515: END IF;
1516:
1517: hr_utility.trace('-pass 40');
1518:
1519: -- write single sub-line in PSP_PAYROLL_SUB_LINES
1520:
1521: IF g_non_active_flag = 'Y' THEN
1522: l_reason := 'NON_ACTIVE_ASSIGNMENT';
1523: ELSIF g_hire_zero_work_days = 'Y' THEN

Line 1645: -- write two sub-lines in PSP_PAYROLL_SUB_LINES

1641:
1642: END IF;
1643:
1644: -- If salary change happens during the payroll period
1645: -- write two sub-lines in PSP_PAYROLL_SUB_LINES
1646: -- table
1647: -- else
1648: -- write single sub-line in PSP_PAYROLL_SUB_LINES
1649: -- table

Line 1648: -- write single sub-line in PSP_PAYROLL_SUB_LINES

1644: -- If salary change happens during the payroll period
1645: -- write two sub-lines in PSP_PAYROLL_SUB_LINES
1646: -- table
1647: -- else
1648: -- write single sub-line in PSP_PAYROLL_SUB_LINES
1649: -- table
1650: -- end if;
1651:
1652: --- IF (l_proration_option = 'PSP' or g_pay_costs_rec.start_date is null ) THEN -- Introduced for bug fix 2916848

Line 1824: update psp_payroll_sub_lines

1820: end if;
1821: close get_difference_csr;
1822: -- Added daily rate not equal to 0 to where clause to fix bug no 89157
1823: if (NVL(to_number(g_pay_costs_rec.costed_value),0) - NVL(l_subline_sum,0)) <> 0 then
1824: update psp_payroll_sub_lines
1825: set pay_amount = pay_amount + (NVL(to_number(g_pay_costs_rec.costed_value),0) - NVL(l_subline_sum,0))
1826: where payroll_line_id = l_line_id and
1827: NVL(daily_rate,0) <> 0 and
1828: pay_amount <> 0 and --- rounding difference to nonzero amount .. 4670588

Line 1933: from psp_payroll_sub_lines

1929:
1930: FORALL k in 1 .. l_total_num_rec
1931: update psp_payroll_controls
1932: set sublines_dr_amount = ( select sum(pay_amount)
1933: from psp_payroll_sub_lines
1934: where payroll_line_id in (
1935: select payroll_line_id
1936: from psp_payroll_lines
1937: where payroll_control_id =

Line 1941: from psp_payroll_sub_lines

1937: where payroll_control_id =
1938: r_payroll_control_array.r_payroll_control_id(k)
1939: and dr_cr_flag = 'D')),
1940: sublines_cr_amount = ( select sum(pay_amount)
1941: from psp_payroll_sub_lines
1942: where payroll_line_id in (
1943: select payroll_line_id
1944: from psp_payroll_lines
1945: where payroll_control_id = r_payroll_control_array.r_payroll_control_id(k) and

Line 3120: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

3116: l_total_daily_rate := 0.00;
3117: else
3118: l_total_daily_rate := l_daily_rate + l_daily_balance;
3119: end if;
3120: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3121: FROM DUAL;
3122: ---hr_utility.trace(' Sub line ' || to_char(l_sub_line_id));
3123: hr_utility.trace(' inserting into Sublines -1');
3124: if l_total_daily_Rate > 0 then

Line 3126: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

3122: ---hr_utility.trace(' Sub line ' || to_char(l_sub_line_id));
3123: hr_utility.trace(' inserting into Sublines -1');
3124: if l_total_daily_Rate > 0 then
3125:
3126: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3127: X_ROWID => l_rowid,
3128: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3129: X_PAYROLL_LINE_ID => x_payroll_line_id,
3130: X_SUB_LINE_START_DATE => l_sub_line_start_date,

Line 3193: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

3189: l_balance_salary := round((l_daily_balance * l_work_days), g_precision) ; -- bug fix 3109943
3190: else
3191: l_balance_salary := 0.00;
3192: end if;
3193: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3194: FROM DUAL;
3195: ----hr_utility.trace(' Before Insert rec into sub lines 2');
3196: hr_utility.trace(' inserting into Sublines -2');
3197: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

Line 3197: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

3193: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3194: FROM DUAL;
3195: ----hr_utility.trace(' Before Insert rec into sub lines 2');
3196: hr_utility.trace(' inserting into Sublines -2');
3197: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3198: X_ROWID => l_rowid,
3199: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3200: X_PAYROLL_LINE_ID => x_payroll_line_id,
3201: X_SUB_LINE_START_DATE => l_sub_line_start_date,

Line 3269: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;

3265: ----hr_utility.trace(' Balance amount ' || to_char(g_payroll_line_rec.balance_amount));
3266:
3267: l_daily_rate := round((g_payroll_line_rec.pay_amount / g_no_of_person_work_days), g_ext_precision);
3268:
3269: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
3270: ----hr_utility.trace(' Before Insert rec into sub lines 3');
3271: ----hr_utility.trace(' Subline id ' || to_char(l_sub_line_id));
3272: ----hr_utility.trace(' line id ' || to_char(x_payroll_line_id) );
3273: ----hr_utility.trace(' line start date ' || to_char(l_sub_line_start_date,'YYYY/MM/DD HH24:MI:SS'));

Line 3279: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

3275: ----hr_utility.trace(' line end date ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3276: ----hr_utility.trace(' Daily rate ' || to_char(g_end_date,'YYYY/MM/DD HH24:MI:SS'));
3277: l_salary:=0;
3278: hr_utility.trace(' inserting into Sublines -3');
3279: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3280: X_ROWID => l_rowid,
3281: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3282: X_PAYROLL_LINE_ID => x_payroll_line_id,
3283: X_SUB_LINE_START_DATE => TRUNC(NVL(x_start_date,l_sub_line_start_date)),

Line 3352: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

3348: ----dbms_output.PUT_LINE('l_balance_salary ' || to_char(l_balance_salary));
3349: ----dbms_output.PUT_LINE('Daily rate ' || to_char(l_daily_rate+l_daily_balance));
3350: ----dbms_output.PUT_LINE('salary Used ' || to_char(l_salary));
3351:
3352: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3353: FROM DUAL;
3354: hr_utility.trace(' inserting into Sublines -5');
3355: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3356: X_ROWID => l_rowid,

Line 3355: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

3351:
3352: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3353: FROM DUAL;
3354: hr_utility.trace(' inserting into Sublines -5');
3355: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3356: X_ROWID => l_rowid,
3357: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3358: X_PAYROLL_LINE_ID => x_payroll_line_id,
3359: X_SUB_LINE_START_DATE => TRUNC(NVL(x_start_date,g_start_date)),

Line 3444: FROM psp_payroll_sub_lines

3440: l_end_date date;
3441:
3442: CURSOR get_sublines_csr IS
3443: SELECT *
3444: FROM psp_payroll_sub_lines
3445: WHERE payroll_line_id = x_payroll_line_id and
3446: l_start_date between sub_line_start_date and sub_line_end_date;
3447:
3448: g_sublines_rec get_sublines_csr%ROWTYPE;

Line 3461: UPDATE psp_payroll_sub_lines

3457: if get_asg_begin_date_csr%FOUND then
3458: open get_sublines_csr;
3459: fetch get_sublines_csr into g_sublines_rec;
3460: if get_sublines_csr%FOUND then
3461: UPDATE psp_payroll_sub_lines
3462: SET sub_line_start_date = trunc(l_start_date),
3463: reason_code = 'ASSG_BEGIN_DATE',
3464: assignment_begin_date = trunc(l_start_date)
3465: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line 3479: UPDATE psp_payroll_sub_lines

3475: l_start_date := trunc(l_end_date);
3476: open get_sublines_csr;
3477: fetch get_sublines_csr into g_sublines_rec;
3478: if get_sublines_csr%FOUND then
3479: UPDATE psp_payroll_sub_lines
3480: SET sub_line_end_date = trunc(l_start_date),
3481: reason_code = 'ASSG_END_DATE',
3482: assignment_end_date = trunc(l_start_date)
3483: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line 3525: FROM psp_payroll_sub_lines

3521: l_end_date date;
3522:
3523: CURSOR get_sublines_csr IS
3524: SELECT *
3525: FROM psp_payroll_sub_lines
3526: WHERE payroll_line_id = x_payroll_line_id and
3527: (l_start_date between sub_line_start_date and sub_line_end_date or
3528: l_end_date between sub_line_start_date and sub_line_end_date);
3529: -- or

Line 3571: UPDATE psp_payroll_sub_lines

3567: if (l_start_date <= g_sublines_rec.sub_line_start_date and
3568: l_end_date >= g_sublines_rec.sub_line_end_date)
3569: then
3570: ----dbms_output.put_line('Entered 1st if ..');
3571: UPDATE psp_payroll_sub_lines
3572: SET pay_amount = 0.00,
3573: daily_rate = 0.00,
3574: reason_code = 'ASSG_STATUS_CHANGE'
3575: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;

Line 3600: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

3596: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / l_total_work_days)), g_precision);
3597: end if;
3598: -- ----dbms_output.put_line('Entered 3rd if ..');
3599:
3600: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3601: FROM DUAL;
3602: hr_utility.trace(' inserting into Sublines -6');
3603: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3604: X_ROWID => l_rowid,

Line 3603: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

3599:
3600: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3601: FROM DUAL;
3602: hr_utility.trace(' inserting into Sublines -6');
3603: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3604: X_ROWID => l_rowid,
3605: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3606: X_PAYROLL_LINE_ID => x_payroll_line_id,
3607: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 3649: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

3645: ----dbms_output.put_line('After creating sub line (1)..');
3646:
3647: l_tmp_start_date := trunc(l_start_date);
3648: l_tmp_end_date := trunc(g_sublines_rec.sub_line_end_date);
3649: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3650: FROM DUAL;
3651: hr_utility.trace(' inserting into Sublines -7');
3652: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3653: X_ROWID => l_rowid,

Line 3652: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

3648: l_tmp_end_date := trunc(g_sublines_rec.sub_line_end_date);
3649: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3650: FROM DUAL;
3651: hr_utility.trace(' inserting into Sublines -7');
3652: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3653: X_ROWID => l_rowid,
3654: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3655: X_PAYROLL_LINE_ID => x_payroll_line_id,
3656: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 3695: DELETE psp_payroll_sub_lines

3691: X_REASON_CODE => 'ASSG_STATUS_CHANGE',
3692: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
3693: X_MODE => 'R') ;
3694: ----dbms_output.put_line('After creating sub line (2)..');
3695: DELETE psp_payroll_sub_lines
3696: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
3697: end;
3698: elsif (l_start_date = g_sublines_rec.sub_line_start_date and
3699: l_end_date < g_sublines_rec.sub_line_end_date) then

Line 3705: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

3701: ----dbms_output.put_line('Entered 3rd if..');
3702:
3703: l_tmp_start_date := trunc(g_sublines_rec.sub_line_start_date);
3704: l_tmp_end_date := trunc(l_end_date);
3705: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3706: FROM DUAL;
3707: hr_utility.trace(' inserting into Sublines -8');
3708: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3709: X_ROWID => l_rowid,

Line 3708: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

3704: l_tmp_end_date := trunc(l_end_date);
3705: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3706: FROM DUAL;
3707: hr_utility.trace(' inserting into Sublines -8');
3708: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3709: X_ROWID => l_rowid,
3710: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3711: X_PAYROLL_LINE_ID => x_payroll_line_id,
3712: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 3769: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

3765:
3766: if round(x_balance_amount,g_precision) <> 0.00 then
3767: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / l_total_work_days)), g_precision);
3768: end if;
3769: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3770: FROM DUAL;
3771: hr_utility.trace(' inserting into Sublines -10');
3772: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3773: X_ROWID => l_rowid,

Line 3772: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

3768: end if;
3769: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3770: FROM DUAL;
3771: hr_utility.trace(' inserting into Sublines -10');
3772: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3773: X_ROWID => l_rowid,
3774: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3775: X_PAYROLL_LINE_ID => x_payroll_line_id,
3776: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 3815: DELETE psp_payroll_sub_lines

3811: X_REASON_CODE => 'ASSG_STATUS_CHANGE',
3812: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
3813: X_MODE => 'R');
3814: ----dbms_output.put_line('After creating sub line (2)..');
3815: DELETE psp_payroll_sub_lines
3816: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
3817: end;
3818: elsif (l_start_date > g_sublines_rec.sub_line_start_date and
3819: l_end_date < g_sublines_rec.sub_line_end_date) then

Line 3839: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

3835:
3836: if round(x_balance_amount,g_precision) <> 0.00 then
3837: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / l_total_work_days)), g_precision);
3838: end if;
3839: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3840: FROM DUAL;
3841: hr_utility.trace(' inserting into Sublines -12');
3842: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3843: X_ROWID => l_rowid,

Line 3842: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

3838: end if;
3839: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3840: FROM DUAL;
3841: hr_utility.trace(' inserting into Sublines -12');
3842: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3843: X_ROWID => l_rowid,
3844: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3845: X_PAYROLL_LINE_ID => x_payroll_line_id,
3846: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 3887: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

3883: X_MODE => 'R');
3884: ----dbms_output.put_line('After 1st Insert ..');
3885: l_tmp_start_date := trunc(l_start_date);
3886: l_tmp_end_date := trunc(l_end_date) ;
3887: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3888: FROM DUAL;
3889: hr_utility.trace(' inserting into Sublines -13');
3890: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3891: X_ROWID => l_rowid,

Line 3890: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

3886: l_tmp_end_date := trunc(l_end_date) ;
3887: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3888: FROM DUAL;
3889: hr_utility.trace(' inserting into Sublines -13');
3890: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3891: X_ROWID => l_rowid,
3892: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3893: X_PAYROLL_LINE_ID => x_payroll_line_id,
3894: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 3951: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

3947: if round(x_balance_amount,g_precision) <> 0.00 then
3948: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / l_total_work_days)), g_precision);
3949:
3950: end if;
3951: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3952: FROM DUAL;
3953: hr_utility.trace(' inserting into Sublines -14');
3954: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3955: X_ROWID => l_rowid,

Line 3954: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

3950: end if;
3951: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
3952: FROM DUAL;
3953: hr_utility.trace(' inserting into Sublines -14');
3954: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
3955: X_ROWID => l_rowid,
3956: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3957: X_PAYROLL_LINE_ID => x_payroll_line_id,
3958: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 3998: DELETE psp_payroll_sub_lines

3994: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
3995: X_MODE => 'R');
3996: ----dbms_output.put_line('After 3rd Insert ..');
3997:
3998: DELETE psp_payroll_sub_lines
3999: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
4000: end;
4001: elsif (l_start_date = g_sublines_rec.sub_line_end_date and
4002: l_end_date > g_sublines_rec.sub_line_end_date) then

Line 4023: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

4019:
4020: if round(x_balance_amount,g_precision) <> 0.00 then
4021: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / l_total_work_days)), g_precision);
4022: end if;
4023: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4024: FROM DUAL;
4025: hr_utility.trace(' inserting into Sublines -15');
4026: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4027: X_ROWID => l_rowid,

Line 4026: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

4022: end if;
4023: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4024: FROM DUAL;
4025: hr_utility.trace(' inserting into Sublines -15');
4026: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4027: X_ROWID => l_rowid,
4028: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4029: X_PAYROLL_LINE_ID => x_payroll_line_id,
4030: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 4072: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

4068:
4069: l_tmp_start_date := trunc(g_sublines_rec.sub_line_end_date);
4070: l_tmp_end_date := trunc(g_sublines_rec.sub_line_end_date);
4071:
4072: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4073: FROM DUAL;
4074: hr_utility.trace(' inserting into Sublines -17');
4075: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4076: X_ROWID => l_rowid,

Line 4075: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

4071:
4072: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4073: FROM DUAL;
4074: hr_utility.trace(' inserting into Sublines -17');
4075: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4076: X_ROWID => l_rowid,
4077: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4078: X_PAYROLL_LINE_ID => x_payroll_line_id,
4079: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 4117: DELETE psp_payroll_sub_lines

4113: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4114: X_REASON_CODE => 'ASSG_STATUS_CHANGE',
4115: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
4116: X_MODE => 'R');
4117: DELETE psp_payroll_sub_lines
4118: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
4119: end;
4120: elsif (l_start_date < g_sublines_rec.sub_line_start_date and
4121: l_end_date < g_sublines_rec.sub_line_end_date) then

Line 4127: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

4123: ----dbms_output.put_line('Entered 6th if ..');
4124: l_tmp_start_date := trunc(g_sublines_rec.sub_line_start_date);
4125: l_tmp_end_date := trunc(l_end_date);
4126:
4127: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4128: FROM DUAL;
4129: hr_utility.trace(' inserting into Sublines -19');
4130: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4131: X_ROWID => l_rowid,

Line 4130: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

4126:
4127: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4128: FROM DUAL;
4129: hr_utility.trace(' inserting into Sublines -19');
4130: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4131: X_ROWID => l_rowid,
4132: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4133: X_PAYROLL_LINE_ID => x_payroll_line_id,
4134: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 4190: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

4186:
4187: if round(x_balance_amount,g_precision) <> 0.00 then
4188: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / l_total_work_days)), g_precision);
4189: end if;
4190: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4191: FROM DUAL;
4192: hr_utility.trace(' inserting into Sublines -21');
4193: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4194: X_ROWID => l_rowid,

Line 4193: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

4189: end if;
4190: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4191: FROM DUAL;
4192: hr_utility.trace(' inserting into Sublines -21');
4193: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4194: X_ROWID => l_rowid,
4195: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4196: X_PAYROLL_LINE_ID => x_payroll_line_id,
4197: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 4235: DELETE psp_payroll_sub_lines

4231: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4232: X_REASON_CODE => 'ASSG_STATUS_CHANGE',
4233: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
4234: X_MODE => 'R');
4235: DELETE psp_payroll_sub_lines
4236: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
4237: end;
4238: end if;
4239: end loop;

Line 4289: FROM psp_payroll_sub_lines

4285: l_tmp_date date;
4286:
4287: CURSOR get_sublines_csr IS
4288: SELECT *
4289: FROM psp_payroll_sub_lines
4290: WHERE payroll_line_id = x_payroll_line_id and
4291: l_tmp_date between sub_line_start_date and sub_line_end_date;
4292:
4293: g_sublines_rec get_sublines_csr%ROWTYPE;

Line 4317: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

4313: fetch get_sublines_csr into g_sublines_rec;
4314: EXIT WHEN get_sublines_csr%NOTFOUND;
4315: if l_date_start > g_sublines_rec.sub_line_start_date then
4316: l_tmp_end_date := trunc(l_date_start) - 1;
4317: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4318: FROM DUAL;
4319: hr_utility.trace(' inserting into Sublines -22');
4320: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4321: X_ROWID => l_rowid,

Line 4320: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

4316: l_tmp_end_date := trunc(l_date_start) - 1;
4317: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4318: FROM DUAL;
4319: hr_utility.trace(' inserting into Sublines -22');
4320: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4321: X_ROWID => l_rowid,
4322: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4323: X_PAYROLL_LINE_ID => x_payroll_line_id,
4324: X_SUB_LINE_START_DATE => g_sublines_rec.sub_line_start_date,

Line 4364: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

4360: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
4361: X_MODE => 'R');
4362:
4363: l_tmp_start_date := trunc(l_date_start);
4364: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4365: FROM DUAL;
4366: hr_utility.trace(' inserting into Sublines -25');
4367: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4368: X_ROWID => l_rowid,

Line 4367: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

4363: l_tmp_start_date := trunc(l_date_start);
4364: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4365: FROM DUAL;
4366: hr_utility.trace(' inserting into Sublines -25');
4367: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4368: X_ROWID => l_rowid,
4369: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4370: X_PAYROLL_LINE_ID => x_payroll_line_id,
4371: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 4411: DELETE psp_payroll_sub_lines

4407: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
4408: X_MODE => 'R');
4409:
4410:
4411: DELETE psp_payroll_sub_lines
4412: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
4413: end if;
4414: END LOOP;
4415: close get_sublines_csr;

Line 4430: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

4426: fetch get_sublines_csr into g_sublines_rec;
4427: EXIT WHEN get_sublines_csr%NOTFOUND;
4428: if l_actual_termination_date < g_sublines_rec.sub_line_end_date then
4429: l_tmp_end_date := trunc(l_actual_termination_date) - 1;
4430: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4431: FROM DUAL;
4432: hr_utility.trace(' inserting into Sublines -28');
4433: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4434: X_ROWID => l_rowid,

Line 4433: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

4429: l_tmp_end_date := trunc(l_actual_termination_date) - 1;
4430: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4431: FROM DUAL;
4432: hr_utility.trace(' inserting into Sublines -28');
4433: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4434: X_ROWID => l_rowid,
4435: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4436: X_PAYROLL_LINE_ID => x_payroll_line_id,
4437: X_SUB_LINE_START_DATE => g_sublines_rec.sub_line_start_date,

Line 4477: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

4473: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
4474: X_MODE => 'R');
4475:
4476: l_tmp_start_date := trunc(l_actual_termination_date);
4477: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4478: FROM DUAL;
4479: hr_utility.trace(' inserting into Sublines -30');
4480: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4481: X_ROWID => l_rowid,

Line 4480: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

4476: l_tmp_start_date := trunc(l_actual_termination_date);
4477: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4478: FROM DUAL;
4479: hr_utility.trace(' inserting into Sublines -30');
4480: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4481: X_ROWID => l_rowid,
4482: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4483: X_PAYROLL_LINE_ID => x_payroll_line_id,
4484: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 4524: DELETE psp_payroll_sub_lines

4520: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
4521: X_MODE => 'R');
4522:
4523:
4524: DELETE psp_payroll_sub_lines
4525: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
4526:
4527: end if;
4528: END LOOP;

Line 4578: FROM psp_payroll_sub_lines

4574: l_new_org_id number(9);
4575:
4576: CURSOR get_sublines_csr IS
4577: SELECT *
4578: FROM psp_payroll_sub_lines
4579: WHERE payroll_line_id = x_payroll_line_id and
4580: ((sub_line_start_date between l_current_start_date and l_current_end_date) or
4581: (sub_line_end_date between l_current_start_date and l_current_end_date) or
4582: (sub_line_start_date <= l_current_start_date and sub_line_end_date >= l_current_end_date))

Line 4636: UPDATE psp_payroll_sub_lines

4632: l_current_end_date > g_sublines_rec.sub_line_end_date) or
4633: (l_current_start_date < g_sublines_rec.sub_line_start_date and
4634: l_current_end_date > g_sublines_rec.sub_line_end_date)) then
4635: begin
4636: UPDATE psp_payroll_sub_lines
4637: set organization_id = l_new_org_id
4638: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
4639: end;
4640: elsif ((l_current_start_date > g_sublines_rec.sub_line_start_date and

Line 4663: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

4659: if round(x_balance_amount,g_precision) <> 0.00 then
4660: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
4661: end if;
4662:
4663: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4664: FROM DUAL;
4665: hr_utility.trace(' inserting into Sublines -32');
4666: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4667: X_ROWID => l_rowid,

Line 4666: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

4662:
4663: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4664: FROM DUAL;
4665: hr_utility.trace(' inserting into Sublines -32');
4666: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4667: X_ROWID => l_rowid,
4668: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4669: X_PAYROLL_LINE_ID => x_payroll_line_id,
4670: X_SUB_LINE_START_DATE => g_sublines_rec.sub_line_start_date,

Line 4727: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

4723: if round(x_balance_amount,g_precision) <> 0.00 then
4724: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
4725: end if;
4726:
4727: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4728: FROM DUAL;
4729: hr_utility.trace(' inserting into Sublines -33');
4730: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4731: X_ROWID => l_rowid,

Line 4730: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

4726:
4727: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4728: FROM DUAL;
4729: hr_utility.trace(' inserting into Sublines -33');
4730: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4731: X_ROWID => l_rowid,
4732: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4733: X_PAYROLL_LINE_ID => x_payroll_line_id,
4734: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 4774: DELETE psp_payroll_sub_lines

4770: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
4771: X_MODE => 'R');
4772:
4773:
4774: DELETE psp_payroll_sub_lines
4775: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
4776: end;
4777: elsif ((l_current_start_date = g_sublines_rec.sub_line_start_date and
4778: l_current_end_date < g_sublines_rec.sub_line_end_date) or

Line 4800: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

4796: if round(x_balance_amount,g_precision) <> 0.00 then
4797: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
4798: end if;
4799:
4800: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4801: FROM DUAL;
4802: hr_utility.trace(' inserting into Sublines -34');
4803: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4804: X_ROWID => l_rowid,

Line 4803: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

4799:
4800: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4801: FROM DUAL;
4802: hr_utility.trace(' inserting into Sublines -34');
4803: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4804: X_ROWID => l_rowid,
4805: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4806: X_PAYROLL_LINE_ID => x_payroll_line_id,
4807: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 4864: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

4860: if round(x_balance_amount,g_precision) <> 0.00 then
4861: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
4862: end if;
4863:
4864: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4865: FROM DUAL;
4866: hr_utility.trace(' inserting into Sublines -35');
4867: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4868: X_ROWID => l_rowid,

Line 4867: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

4863:
4864: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4865: FROM DUAL;
4866: hr_utility.trace(' inserting into Sublines -35');
4867: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4868: X_ROWID => l_rowid,
4869: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4870: X_PAYROLL_LINE_ID => x_payroll_line_id,
4871: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 4911: DELETE psp_payroll_sub_lines

4907: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
4908: X_MODE => 'R');
4909:
4910:
4911: DELETE psp_payroll_sub_lines
4912: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
4913: end;
4914: else
4915: begin

Line 4934: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

4930: if round(x_balance_amount,g_precision) <> 0.00 then
4931: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
4932: end if;
4933:
4934: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4935: FROM DUAL;
4936: hr_utility.trace(' inserting into Sublines -37');
4937: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4938: X_ROWID => l_rowid,

Line 4937: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

4933:
4934: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4935: FROM DUAL;
4936: hr_utility.trace(' inserting into Sublines -37');
4937: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
4938: X_ROWID => l_rowid,
4939: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4940: X_PAYROLL_LINE_ID => x_payroll_line_id,
4941: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 4998: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

4994: if round(x_balance_amount,g_precision) <> 0.00 then
4995: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
4996: end if;
4997:
4998: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4999: FROM DUAL;
5000: hr_utility.trace(' inserting into Sublines -39');
5001: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5002: X_ROWID => l_rowid,

Line 5001: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

4997:
4998: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
4999: FROM DUAL;
5000: hr_utility.trace(' inserting into Sublines -39');
5001: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5002: X_ROWID => l_rowid,
5003: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5004: X_PAYROLL_LINE_ID => x_payroll_line_id,
5005: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 5062: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

5058: if round(x_balance_amount,g_precision) <> 0.00 then
5059: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5060: end if;
5061:
5062: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5063: FROM DUAL;
5064: hr_utility.trace(' inserting into Sublines -42');
5065: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5066: X_ROWID => l_rowid,

Line 5065: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

5061:
5062: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5063: FROM DUAL;
5064: hr_utility.trace(' inserting into Sublines -42');
5065: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5066: X_ROWID => l_rowid,
5067: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5068: X_PAYROLL_LINE_ID => x_payroll_line_id,
5069: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 5109: DELETE psp_payroll_sub_lines

5105: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
5106: X_MODE => 'R');
5107:
5108:
5109: DELETE psp_payroll_sub_lines
5110: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
5111: end;
5112: end if;
5113: l_old_org_id := l_new_org_id;

Line 5171: FROM psp_payroll_sub_lines

5167: l_new_job_id number(9);
5168:
5169: CURSOR get_sublines_csr IS
5170: SELECT *
5171: FROM psp_payroll_sub_lines
5172: WHERE payroll_line_id = x_payroll_line_id and
5173: ((sub_line_start_date between l_current_start_date and l_current_end_date) or
5174: (sub_line_end_date between l_current_start_date and l_current_end_date) or
5175: (sub_line_start_date <= l_current_start_date and sub_line_end_date >= l_current_end_date))

Line 5221: UPDATE psp_payroll_sub_lines

5217: l_current_end_date > g_sublines_rec.sub_line_end_date) or
5218: (l_current_start_date < g_sublines_rec.sub_line_start_date and
5219: l_current_end_date > g_sublines_rec.sub_line_end_date)) then
5220: begin
5221: UPDATE psp_payroll_sub_lines
5222: set job_id = l_new_job_id
5223: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
5224: end;
5225: elsif ((l_current_start_date > g_sublines_rec.sub_line_start_date and

Line 5248: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

5244: if round(x_balance_amount,g_precision) <> 0.00 then
5245: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5246: end if;
5247:
5248: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5249: FROM DUAL;
5250: hr_utility.trace(' inserting into Sublines -52');
5251: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5252: X_ROWID => l_rowid,

Line 5251: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

5247:
5248: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5249: FROM DUAL;
5250: hr_utility.trace(' inserting into Sublines -52');
5251: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5252: X_ROWID => l_rowid,
5253: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5254: X_PAYROLL_LINE_ID => x_payroll_line_id,
5255: X_SUB_LINE_START_DATE => g_sublines_rec.sub_line_start_date,

Line 5312: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

5308: if round(x_balance_amount,g_precision) <> 0.00 then
5309: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5310: end if;
5311:
5312: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5313: FROM DUAL;
5314: hr_utility.trace(' inserting into Sublines -62');
5315: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5316: X_ROWID => l_rowid,

Line 5315: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

5311:
5312: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5313: FROM DUAL;
5314: hr_utility.trace(' inserting into Sublines -62');
5315: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5316: X_ROWID => l_rowid,
5317: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5318: X_PAYROLL_LINE_ID => x_payroll_line_id,
5319: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 5359: DELETE psp_payroll_sub_lines

5355: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
5356: X_MODE => 'R' );
5357:
5358:
5359: DELETE psp_payroll_sub_lines
5360: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
5361: end;
5362: elsif ((l_current_start_date = g_sublines_rec.sub_line_start_date and
5363: l_current_end_date < g_sublines_rec.sub_line_end_date) or

Line 5385: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

5381: if round(x_balance_amount,g_precision) <> 0.00 then
5382: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5383: end if;
5384:
5385: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5386: FROM DUAL;
5387: hr_utility.trace(' inserting into Sublines -92');
5388: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5389: X_ROWID => l_rowid,

Line 5388: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

5384:
5385: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5386: FROM DUAL;
5387: hr_utility.trace(' inserting into Sublines -92');
5388: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5389: X_ROWID => l_rowid,
5390: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5391: X_PAYROLL_LINE_ID => x_payroll_line_id,
5392: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 5449: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

5445: if round(x_balance_amount,g_precision) <> 0.00 then
5446: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5447: end if;
5448:
5449: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5450: FROM DUAL;
5451: hr_utility.trace(' inserting into Sublines -102');
5452: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5453: X_ROWID => l_rowid,

Line 5452: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

5448:
5449: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5450: FROM DUAL;
5451: hr_utility.trace(' inserting into Sublines -102');
5452: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5453: X_ROWID => l_rowid,
5454: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5455: X_PAYROLL_LINE_ID => x_payroll_line_id,
5456: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 5496: DELETE psp_payroll_sub_lines

5492: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
5493: X_MODE => 'R' );
5494:
5495:
5496: DELETE psp_payroll_sub_lines
5497: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
5498: end;
5499: else
5500: begin

Line 5519: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

5515: if round(x_balance_amount,g_precision) <> 0.00 then
5516: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5517: end if;
5518:
5519: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5520: FROM DUAL;
5521: hr_utility.trace(' inserting into Sublines -202');
5522: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5523: X_ROWID => l_rowid,

Line 5522: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

5518:
5519: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5520: FROM DUAL;
5521: hr_utility.trace(' inserting into Sublines -202');
5522: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5523: X_ROWID => l_rowid,
5524: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5525: X_PAYROLL_LINE_ID => x_payroll_line_id,
5526: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 5583: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

5579: if round(x_balance_amount,g_precision) <> 0.00 then
5580: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5581: end if;
5582:
5583: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5584: FROM DUAL;
5585: hr_utility.trace(' inserting into Sublines -302');
5586: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5587: X_ROWID => l_rowid,

Line 5586: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

5582:
5583: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5584: FROM DUAL;
5585: hr_utility.trace(' inserting into Sublines -302');
5586: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5587: X_ROWID => l_rowid,
5588: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5589: X_PAYROLL_LINE_ID => x_payroll_line_id,
5590: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 5647: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

5643: if round(x_balance_amount,g_precision) <> 0.00 then
5644: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5645: end if;
5646:
5647: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5648: FROM DUAL;
5649: hr_utility.trace(' inserting into Sublines -402');
5650: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5651: X_ROWID => l_rowid,

Line 5650: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

5646:
5647: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5648: FROM DUAL;
5649: hr_utility.trace(' inserting into Sublines -402');
5650: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5651: X_ROWID => l_rowid,
5652: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5653: X_PAYROLL_LINE_ID => x_payroll_line_id,
5654: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 5694: DELETE psp_payroll_sub_lines

5690: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
5691: X_MODE => 'R');
5692:
5693:
5694: DELETE psp_payroll_sub_lines
5695: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
5696: end;
5697: end if;
5698: l_old_job_id := l_new_job_id;

Line 5761: FROM psp_payroll_sub_lines

5757: l_new_position_id number(15); -- Bug 2231410 : Increased the lenght of position_id column from 9 to 15
5758:
5759: CURSOR get_sublines_csr IS
5760: SELECT *
5761: FROM psp_payroll_sub_lines
5762: WHERE payroll_line_id = x_payroll_line_id and
5763: ((sub_line_start_date between l_current_start_date and l_current_end_date) or
5764: (sub_line_end_date between l_current_start_date and l_current_end_date) or
5765: (sub_line_start_date <= l_current_start_date and sub_line_end_date >= l_current_end_date))

Line 5811: UPDATE psp_payroll_sub_lines

5807: l_current_end_date > g_sublines_rec.sub_line_end_date) or
5808: (l_current_start_date < g_sublines_rec.sub_line_start_date and
5809: l_current_end_date > g_sublines_rec.sub_line_end_date)) then
5810: begin
5811: UPDATE psp_payroll_sub_lines
5812: set position_id = l_new_position_id
5813: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
5814: end;
5815: elsif ((l_current_start_date > g_sublines_rec.sub_line_start_date and

Line 5838: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

5834: if round(x_balance_amount,g_precision) <> 0.00 then
5835: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5836: end if;
5837:
5838: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5839: FROM DUAL;
5840: hr_utility.trace(' inserting into Sublines -502');
5841: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5842: X_ROWID => l_rowid,

Line 5841: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

5837:
5838: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5839: FROM DUAL;
5840: hr_utility.trace(' inserting into Sublines -502');
5841: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5842: X_ROWID => l_rowid,
5843: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5844: X_PAYROLL_LINE_ID => x_payroll_line_id,
5845: X_SUB_LINE_START_DATE => g_sublines_rec.sub_line_start_date,

Line 5902: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

5898: if round(x_balance_amount,g_precision) <> 0.00 then
5899: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5900: end if;
5901:
5902: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5903: FROM DUAL;
5904: hr_utility.trace(' inserting into Sublines -502');
5905: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5906: X_ROWID => l_rowid,

Line 5905: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

5901:
5902: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5903: FROM DUAL;
5904: hr_utility.trace(' inserting into Sublines -502');
5905: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5906: X_ROWID => l_rowid,
5907: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5908: X_PAYROLL_LINE_ID => x_payroll_line_id,
5909: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 5949: DELETE psp_payroll_sub_lines

5945: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
5946: X_MODE => 'R');
5947:
5948:
5949: DELETE psp_payroll_sub_lines
5950: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
5951: end;
5952: elsif ((l_current_start_date = g_sublines_rec.sub_line_start_date and
5953: l_current_end_date < g_sublines_rec.sub_line_end_date) or

Line 5975: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

5971: if round(x_balance_amount,g_precision) <> 0.00 then
5972: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
5973: end if;
5974:
5975: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5976: FROM DUAL;
5977: hr_utility.trace(' inserting into Sublines -702');
5978: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5979: X_ROWID => l_rowid,

Line 5978: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

5974:
5975: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
5976: FROM DUAL;
5977: hr_utility.trace(' inserting into Sublines -702');
5978: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
5979: X_ROWID => l_rowid,
5980: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5981: X_PAYROLL_LINE_ID => x_payroll_line_id,
5982: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 6039: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

6035: if round(x_balance_amount,g_precision) <> 0.00 then
6036: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6037: end if;
6038:
6039: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6040: FROM DUAL;
6041: hr_utility.trace(' inserting into Sublines -802');
6042: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6043: X_ROWID => l_rowid,

Line 6042: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

6038:
6039: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6040: FROM DUAL;
6041: hr_utility.trace(' inserting into Sublines -802');
6042: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6043: X_ROWID => l_rowid,
6044: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6045: X_PAYROLL_LINE_ID => x_payroll_line_id,
6046: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 6086: DELETE psp_payroll_sub_lines

6082: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
6083: X_MODE => 'R' );
6084:
6085:
6086: DELETE psp_payroll_sub_lines
6087: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
6088: end;
6089: else
6090: begin

Line 6109: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

6105: if round(x_balance_amount,g_precision) <> 0.00 then
6106: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6107: end if;
6108:
6109: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6110: FROM DUAL;
6111: hr_utility.trace(' inserting into Sublines -902');
6112: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6113: X_ROWID => l_rowid,

Line 6112: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

6108:
6109: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6110: FROM DUAL;
6111: hr_utility.trace(' inserting into Sublines -902');
6112: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6113: X_ROWID => l_rowid,
6114: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6115: X_PAYROLL_LINE_ID => x_payroll_line_id,
6116: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 6173: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

6169: if round(x_balance_amount,g_precision) <> 0.00 then
6170: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)),g_precision);
6171: end if;
6172:
6173: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6174: FROM DUAL;
6175: hr_utility.trace(' inserting into Sublines -802');
6176: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6177: X_ROWID => l_rowid,

Line 6176: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

6172:
6173: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6174: FROM DUAL;
6175: hr_utility.trace(' inserting into Sublines -802');
6176: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6177: X_ROWID => l_rowid,
6178: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6179: X_PAYROLL_LINE_ID => x_payroll_line_id,
6180: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 6237: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

6233: if round(x_balance_amount,g_precision) <> 0.00 then
6234: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6235: end if;
6236:
6237: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6238: FROM DUAL;
6239: hr_utility.trace(' inserting into Sublines -1002');
6240: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6241: X_ROWID => l_rowid,

Line 6240: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

6236:
6237: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6238: FROM DUAL;
6239: hr_utility.trace(' inserting into Sublines -1002');
6240: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6241: X_ROWID => l_rowid,
6242: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6243: X_PAYROLL_LINE_ID => x_payroll_line_id,
6244: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 6284: DELETE psp_payroll_sub_lines

6280: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
6281: X_MODE => 'R');
6282:
6283:
6284: DELETE psp_payroll_sub_lines
6285: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
6286: end;
6287: end if;
6288: l_old_position_id := l_new_position_id;

Line 6354: FROM psp_payroll_sub_lines

6350: l_new_grade_id number(9);
6351:
6352: CURSOR get_sublines_csr IS
6353: SELECT *
6354: FROM psp_payroll_sub_lines
6355: WHERE payroll_line_id = x_payroll_line_id and
6356: ((sub_line_start_date between l_current_start_date and l_current_end_date) or
6357: (sub_line_end_date between l_current_start_date and l_current_end_date) or
6358: (sub_line_start_date <= l_current_start_date and sub_line_end_date >= l_current_end_date))

Line 6402: UPDATE psp_payroll_sub_lines

6398: l_current_end_date > g_sublines_rec.sub_line_end_date) or
6399: (l_current_start_date < g_sublines_rec.sub_line_start_date and
6400: l_current_end_date > g_sublines_rec.sub_line_end_date)) then
6401: begin
6402: UPDATE psp_payroll_sub_lines
6403: set grade_id = l_new_grade_id
6404: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
6405: end;
6406: elsif ((l_current_start_date > g_sublines_rec.sub_line_start_date and

Line 6429: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

6425: if round(x_balance_amount,g_precision) <> 0.00 then
6426: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6427: end if;
6428:
6429: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6430: FROM DUAL;
6431: hr_utility.trace(' inserting into Sublines -2002');
6432: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6433: X_ROWID => l_rowid,

Line 6432: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

6428:
6429: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6430: FROM DUAL;
6431: hr_utility.trace(' inserting into Sublines -2002');
6432: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6433: X_ROWID => l_rowid,
6434: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6435: X_PAYROLL_LINE_ID => x_payroll_line_id,
6436: X_SUB_LINE_START_DATE => g_sublines_rec.sub_line_start_date,

Line 6493: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

6489: if round(x_balance_amount,g_precision) <> 0.00 then
6490: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6491: end if;
6492:
6493: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6494: FROM DUAL;
6495: hr_utility.trace(' inserting into Sublines -3002');
6496: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6497: X_ROWID => l_rowid,

Line 6496: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

6492:
6493: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6494: FROM DUAL;
6495: hr_utility.trace(' inserting into Sublines -3002');
6496: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6497: X_ROWID => l_rowid,
6498: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6499: X_PAYROLL_LINE_ID => x_payroll_line_id,
6500: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 6540: DELETE psp_payroll_sub_lines

6536: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
6537: X_MODE => 'R');
6538:
6539:
6540: DELETE psp_payroll_sub_lines
6541: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
6542: end;
6543: elsif ((l_current_start_date = g_sublines_rec.sub_line_start_date and
6544: l_current_end_date < g_sublines_rec.sub_line_end_date) or

Line 6566: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

6562: if round(x_balance_amount, g_precision) <> 0.00 then
6563: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6564: end if;
6565:
6566: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6567: FROM DUAL;
6568: hr_utility.trace(' inserting into Sublines -4002');
6569: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6570: X_ROWID => l_rowid,

Line 6569: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

6565:
6566: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6567: FROM DUAL;
6568: hr_utility.trace(' inserting into Sublines -4002');
6569: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6570: X_ROWID => l_rowid,
6571: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6572: X_PAYROLL_LINE_ID => x_payroll_line_id,
6573: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 6630: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

6626: if round(x_balance_amount, g_precision) <> 0.00 then
6627: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6628: end if;
6629:
6630: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6631: FROM DUAL;
6632: hr_utility.trace(' inserting into Sublines -5002');
6633: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6634: X_ROWID => l_rowid,

Line 6633: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

6629:
6630: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6631: FROM DUAL;
6632: hr_utility.trace(' inserting into Sublines -5002');
6633: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6634: X_ROWID => l_rowid,
6635: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6636: X_PAYROLL_LINE_ID => x_payroll_line_id,
6637: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 6677: DELETE psp_payroll_sub_lines

6673: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
6674: X_MODE => 'R' );
6675:
6676:
6677: DELETE psp_payroll_sub_lines
6678: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
6679: end;
6680: else
6681: begin

Line 6700: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

6696: if round(x_balance_amount, g_precision) <> 0.00 then
6697: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6698: end if;
6699:
6700: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6701: FROM DUAL;
6702: hr_utility.trace(' inserting into Sublines -6002');
6703: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6704: X_ROWID => l_rowid,

Line 6703: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

6699:
6700: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6701: FROM DUAL;
6702: hr_utility.trace(' inserting into Sublines -6002');
6703: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6704: X_ROWID => l_rowid,
6705: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6706: X_PAYROLL_LINE_ID => x_payroll_line_id,
6707: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 6764: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

6760: if round(x_balance_amount, g_precision) <> 0.00 then
6761: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6762: end if;
6763:
6764: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6765: FROM DUAL;
6766: hr_utility.trace(' inserting into Sublines -7002');
6767: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6768: X_ROWID => l_rowid,

Line 6767: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

6763:
6764: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6765: FROM DUAL;
6766: hr_utility.trace(' inserting into Sublines -7002');
6767: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6768: X_ROWID => l_rowid,
6769: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6770: X_PAYROLL_LINE_ID => x_payroll_line_id,
6771: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 6828: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

6824: if round(x_balance_amount, g_precision) <> 0.00 then
6825: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
6826: end if;
6827:
6828: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6829: FROM DUAL;
6830: hr_utility.trace(' inserting into Sublines -8002');
6831: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6832: X_ROWID => l_rowid,

Line 6831: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

6827:
6828: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
6829: FROM DUAL;
6830: hr_utility.trace(' inserting into Sublines -8002');
6831: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
6832: X_ROWID => l_rowid,
6833: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6834: X_PAYROLL_LINE_ID => x_payroll_line_id,
6835: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 6875: DELETE psp_payroll_sub_lines

6871: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
6872: X_MODE => 'R');
6873:
6874:
6875: DELETE psp_payroll_sub_lines
6876: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
6877: end;
6878: end if;
6879: l_old_grade_id := l_new_grade_id;

Line 6949: FROM psp_payroll_sub_lines

6945: l_new_ppgroup_id number(9);
6946:
6947: CURSOR get_sublines_csr IS
6948: SELECT *
6949: FROM psp_payroll_sub_lines
6950: WHERE payroll_line_id = x_payroll_line_id and
6951: ((sub_line_start_date between l_current_start_date and l_current_end_date) or
6952: (sub_line_end_date between l_current_start_date and l_current_end_date) or
6953: (sub_line_start_date <= l_current_start_date and sub_line_end_date >= l_current_end_date))

Line 6997: UPDATE psp_payroll_sub_lines

6993: l_current_end_date > g_sublines_rec.sub_line_end_date) or
6994: (l_current_start_date < g_sublines_rec.sub_line_start_date and
6995: l_current_end_date > g_sublines_rec.sub_line_end_date)) then
6996: begin
6997: UPDATE psp_payroll_sub_lines
6998: set people_group_id = l_new_ppgroup_id
6999: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
7000: end;
7001: elsif ((l_current_start_date > g_sublines_rec.sub_line_start_date and

Line 7024: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

7020: if round(x_balance_amount, g_precision) <> 0.00 then
7021: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7022: end if;
7023:
7024: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7025: FROM DUAL;
7026: hr_utility.trace(' inserting into Sublines -9002');
7027: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7028: X_ROWID => l_rowid,

Line 7027: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

7023:
7024: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7025: FROM DUAL;
7026: hr_utility.trace(' inserting into Sublines -9002');
7027: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7028: X_ROWID => l_rowid,
7029: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7030: X_PAYROLL_LINE_ID => x_payroll_line_id,
7031: X_SUB_LINE_START_DATE => g_sublines_rec.sub_line_start_date,

Line 7088: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

7084: if round(x_balance_amount, g_precision) <> 0.00 then
7085: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7086: end if;
7087:
7088: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7089: FROM DUAL;
7090: hr_utility.trace(' inserting into Sublines -2Y');
7091: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7092: X_ROWID => l_rowid,

Line 7091: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

7087:
7088: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7089: FROM DUAL;
7090: hr_utility.trace(' inserting into Sublines -2Y');
7091: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7092: X_ROWID => l_rowid,
7093: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7094: X_PAYROLL_LINE_ID => x_payroll_line_id,
7095: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 7135: DELETE psp_payroll_sub_lines

7131: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
7132: X_MODE => 'R');
7133:
7134:
7135: DELETE psp_payroll_sub_lines
7136: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
7137: end;
7138: elsif ((l_current_start_date = g_sublines_rec.sub_line_start_date and
7139: l_current_end_date < g_sublines_rec.sub_line_end_date) or

Line 7161: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

7157: if round(x_balance_amount, g_precision) <> 0.00 then
7158: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7159: end if;
7160:
7161: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7162: FROM DUAL;
7163: hr_utility.trace(' inserting into Sublines -2OX');
7164: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7165: X_ROWID => l_rowid,

Line 7164: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

7160:
7161: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7162: FROM DUAL;
7163: hr_utility.trace(' inserting into Sublines -2OX');
7164: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7165: X_ROWID => l_rowid,
7166: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7167: X_PAYROLL_LINE_ID => x_payroll_line_id,
7168: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 7225: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

7221: if round(x_balance_amount, g_precision) <> 0.00 then
7222: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7223: end if;
7224:
7225: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7226: FROM DUAL;
7227: hr_utility.trace(' inserting into Sublines -2LXL');
7228: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7229: X_ROWID => l_rowid,

Line 7228: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

7224:
7225: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7226: FROM DUAL;
7227: hr_utility.trace(' inserting into Sublines -2LXL');
7228: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7229: X_ROWID => l_rowid,
7230: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7231: X_PAYROLL_LINE_ID => x_payroll_line_id,
7232: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 7272: DELETE psp_payroll_sub_lines

7268: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
7269: X_MODE => 'R' );
7270:
7271:
7272: DELETE psp_payroll_sub_lines
7273: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
7274: end;
7275: else
7276: begin

Line 7295: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

7291: if round(x_balance_amount, g_precision) <> 0.00 then
7292: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7293: end if;
7294:
7295: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7296: FROM DUAL;
7297: hr_utility.trace(' inserting into Sublines -2UIORA');
7298: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7299: X_ROWID => l_rowid,

Line 7298: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

7294:
7295: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7296: FROM DUAL;
7297: hr_utility.trace(' inserting into Sublines -2UIORA');
7298: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7299: X_ROWID => l_rowid,
7300: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7301: X_PAYROLL_LINE_ID => x_payroll_line_id,
7302: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 7359: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

7355: if round(x_balance_amount, g_precision) <> 0.00 then
7356: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7357: end if;
7358:
7359: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7360: FROM DUAL;
7361: hr_utility.trace(' inserting into Sublines -2JADF');
7362: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7363: X_ROWID => l_rowid,

Line 7362: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

7358:
7359: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7360: FROM DUAL;
7361: hr_utility.trace(' inserting into Sublines -2JADF');
7362: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7363: X_ROWID => l_rowid,
7364: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7365: X_PAYROLL_LINE_ID => x_payroll_line_id,
7366: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 7423: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

7419: if round(x_balance_amount, g_precision) <> 0.00 then
7420: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7421: end if;
7422:
7423: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7424: FROM DUAL;
7425: hr_utility.trace(' inserting into Sublines -299ek');
7426: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7427: X_ROWID => l_rowid,

Line 7426: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

7422:
7423: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7424: FROM DUAL;
7425: hr_utility.trace(' inserting into Sublines -299ek');
7426: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7427: X_ROWID => l_rowid,
7428: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7429: X_PAYROLL_LINE_ID => x_payroll_line_id,
7430: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 7470: DELETE psp_payroll_sub_lines

7466: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
7467: X_MODE => 'R');
7468:
7469:
7470: DELETE psp_payroll_sub_lines
7471: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
7472: end;
7473: end if;
7474: l_old_ppgroup_id := l_new_ppgroup_id;

Line 7522: FROM psp_payroll_sub_lines

7518: l_new_fte number(22,2);
7519:
7520: CURSOR get_sublines_csr IS
7521: SELECT *
7522: FROM psp_payroll_sub_lines
7523: WHERE payroll_line_id = x_payroll_line_id and
7524: ((sub_line_start_date between l_current_start_date and l_current_end_date) or
7525: (sub_line_end_date between l_current_start_date and l_current_end_date) or
7526: (sub_line_start_date <= l_current_start_date and sub_line_end_date >= l_current_end_date))

Line 7676: UPDATE psp_payroll_sub_lines

7672: l_current_end_date > g_sublines_rec.sub_line_end_date) or
7673: (l_current_start_date < g_sublines_rec.sub_line_start_date and
7674: l_current_end_date > g_sublines_rec.sub_line_end_date)) then
7675: begin
7676: UPDATE psp_payroll_sub_lines
7677: set fte = l_new_fte
7678: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
7679: end;
7680: elsif ((l_current_start_date > g_sublines_rec.sub_line_start_date and

Line 7703: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

7699: if round(x_balance_amount, g_precision) <> 0.00 then
7700: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7701: end if;
7702:
7703: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7704: FROM DUAL;
7705: hr_utility.trace(' inserting into Sublines -2kdfd');
7706: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7707: X_ROWID => l_rowid,

Line 7706: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

7702:
7703: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7704: FROM DUAL;
7705: hr_utility.trace(' inserting into Sublines -2kdfd');
7706: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7707: X_ROWID => l_rowid,
7708: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7709: X_PAYROLL_LINE_ID => x_payroll_line_id,
7710: X_SUB_LINE_START_DATE => g_sublines_rec.sub_line_start_date,

Line 7767: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

7763: if round(x_balance_amount, g_precision) <> 0.00 then
7764: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7765: end if;
7766:
7767: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7768: FROM DUAL;
7769: hr_utility.trace(' inserting into Sublines -2LKJL:JL');
7770: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7771: X_ROWID => l_rowid,

Line 7770: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

7766:
7767: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7768: FROM DUAL;
7769: hr_utility.trace(' inserting into Sublines -2LKJL:JL');
7770: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7771: X_ROWID => l_rowid,
7772: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7773: X_PAYROLL_LINE_ID => x_payroll_line_id,
7774: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 7812: DELETE psp_payroll_sub_lines

7808: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7809: X_REASON_CODE => 'FTE_CHANGE',
7810: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
7811: X_MODE => 'R');
7812: DELETE psp_payroll_sub_lines
7813: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
7814: end;
7815: elsif ((l_current_start_date = g_sublines_rec.sub_line_start_date and
7816: l_current_end_date < g_sublines_rec.sub_line_end_date) or

Line 7838: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

7834: if round(x_balance_amount, g_precision) <> 0.00 then
7835: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7836: end if;
7837:
7838: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7839: FROM DUAL;
7840: hr_utility.trace(' inserting into Sublines -2UUUUUUAA');
7841: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7842: X_ROWID => l_rowid,

Line 7841: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

7837:
7838: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7839: FROM DUAL;
7840: hr_utility.trace(' inserting into Sublines -2UUUUUUAA');
7841: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7842: X_ROWID => l_rowid,
7843: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7844: X_PAYROLL_LINE_ID => x_payroll_line_id,
7845: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 7905: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

7901:
7902: SELECT PSP_PAYROLL_LINES_S.NEXTVAL into l_sub_line_id
7903: FROM DUAL;
7904: hr_utility.trace(' inserting into Sublines -2KKKKK');
7905: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7906: X_ROWID => l_rowid,
7907: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7908: X_PAYROLL_LINE_ID => x_payroll_line_id,
7909: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 7949: DELETE psp_payroll_sub_lines

7945: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
7946: X_MODE => 'R');
7947:
7948:
7949: DELETE psp_payroll_sub_lines
7950: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
7951: end;
7952: else
7953: begin

Line 7972: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

7968: if round(x_balance_amount, g_precision) <> 0.00 then
7969: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
7970: end if;
7971:
7972: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7973: FROM DUAL;
7974: hr_utility.trace(' inserting into Sublines -2OOOPP888');
7975: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7976: X_ROWID => l_rowid,

Line 7975: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

7971:
7972: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
7973: FROM DUAL;
7974: hr_utility.trace(' inserting into Sublines -2OOOPP888');
7975: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
7976: X_ROWID => l_rowid,
7977: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7978: X_PAYROLL_LINE_ID => x_payroll_line_id,
7979: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 8036: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

8032: if round(x_balance_amount, g_precision) <> 0.00 then
8033: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8034: end if;
8035:
8036: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8037: FROM DUAL;
8038: hr_utility.trace(' inserting into Sublines -27777MMMN');
8039: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8040: X_ROWID => l_rowid,

Line 8039: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

8035:
8036: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8037: FROM DUAL;
8038: hr_utility.trace(' inserting into Sublines -27777MMMN');
8039: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8040: X_ROWID => l_rowid,
8041: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8042: X_PAYROLL_LINE_ID => x_payroll_line_id,
8043: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 8100: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

8096: if round(x_balance_amount, g_precision) <> 0.00 then
8097: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8098: end if;
8099:
8100: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8101: FROM DUAL;
8102: hr_utility.trace(' inserting into Sublines -2EEEERRSS');
8103: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8104: X_ROWID => l_rowid,

Line 8103: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

8099:
8100: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8101: FROM DUAL;
8102: hr_utility.trace(' inserting into Sublines -2EEEERRSS');
8103: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8104: X_ROWID => l_rowid,
8105: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8106: X_PAYROLL_LINE_ID => x_payroll_line_id,
8107: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 8147: DELETE psp_payroll_sub_lines

8143: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
8144: X_MODE => 'R');
8145:
8146:
8147: DELETE psp_payroll_sub_lines
8148: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
8149: end;
8150: end if;
8151: l_old_fte := l_new_fte;

Line 8220: FROM psp_payroll_sub_lines

8216: l_new_value per_assignment_budget_values_f.value%type;
8217:
8218: CURSOR get_sublines_csr IS
8219: SELECT *
8220: FROM psp_payroll_sub_lines
8221: WHERE payroll_line_id = x_payroll_line_id and
8222: ((sub_line_start_date between l_current_start_date and l_current_end_date) or
8223: (sub_line_end_date between l_current_start_date and l_current_end_date) or
8224: (sub_line_start_date >= l_current_start_date and sub_line_end_date >= l_current_end_date))

Line 8279: UPDATE psp_payroll_sub_lines

8275: l_current_end_date > g_sublines_rec.sub_line_end_date) or
8276: (l_current_start_date < g_sublines_rec.sub_line_start_date and
8277: l_current_end_date > g_sublines_rec.sub_line_end_date)) then
8278: begin
8279: UPDATE psp_payroll_sub_lines
8280: set fte = l_new_value
8281: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
8282: end;
8283: elsif ((l_current_start_date > g_sublines_rec.sub_line_start_date and

Line 8306: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

8302: if round(x_balance_amount, g_precision) <> 0.00 then
8303: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8304: end if;
8305:
8306: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8307: FROM DUAL;
8308: hr_utility.trace(' inserting into Sublines -2WWWEEERR');
8309: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8310: X_ROWID => l_rowid,

Line 8309: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

8305:
8306: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8307: FROM DUAL;
8308: hr_utility.trace(' inserting into Sublines -2WWWEEERR');
8309: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8310: X_ROWID => l_rowid,
8311: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8312: X_PAYROLL_LINE_ID => x_payroll_line_id,
8313: X_SUB_LINE_START_DATE => g_sublines_rec.sub_line_start_date,

Line 8370: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

8366: if round(x_balance_amount, g_precision) <> 0.00 then
8367: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8368: end if;
8369:
8370: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8371: FROM DUAL;
8372: hr_utility.trace(' inserting into Sublines -29999*****888');
8373: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8374: X_ROWID => l_rowid,

Line 8373: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

8369:
8370: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8371: FROM DUAL;
8372: hr_utility.trace(' inserting into Sublines -29999*****888');
8373: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8374: X_ROWID => l_rowid,
8375: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8376: X_PAYROLL_LINE_ID => x_payroll_line_id,
8377: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 8417: DELETE psp_payroll_sub_lines

8413: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
8414: X_MODE => 'R');
8415:
8416:
8417: DELETE psp_payroll_sub_lines
8418: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
8419: end;
8420: elsif ((l_current_start_date = g_sublines_rec.sub_line_start_date and
8421: l_current_end_date < g_sublines_rec.sub_line_end_date) or

Line 8443: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

8439: if round(x_balance_amount, g_precision) <> 0.00 then
8440: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8441: end if;
8442:
8443: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8444: FROM DUAL;
8445: hr_utility.trace(' inserting into Sublines -2DDDDDD');
8446: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8447: X_ROWID => l_rowid,

Line 8446: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

8442:
8443: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8444: FROM DUAL;
8445: hr_utility.trace(' inserting into Sublines -2DDDDDD');
8446: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8447: X_ROWID => l_rowid,
8448: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8449: X_PAYROLL_LINE_ID => x_payroll_line_id,
8450: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 8507: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

8503: if round(x_balance_amount, g_precision) <> 0.00 then
8504: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8505: end if;
8506:
8507: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8508: FROM DUAL;
8509: hr_utility.trace(' inserting into Sublines -2UKOSO');
8510: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8511: X_ROWID => l_rowid,

Line 8510: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

8506:
8507: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8508: FROM DUAL;
8509: hr_utility.trace(' inserting into Sublines -2UKOSO');
8510: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8511: X_ROWID => l_rowid,
8512: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8513: X_PAYROLL_LINE_ID => x_payroll_line_id,
8514: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 8554: DELETE psp_payroll_sub_lines

8550: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
8551: X_MODE => 'R' );
8552:
8553:
8554: DELETE psp_payroll_sub_lines
8555: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
8556: end;
8557: else
8558: begin

Line 8577: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

8573: if round(x_balance_amount,g_precision) <> 0.00 then
8574: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8575: end if;
8576:
8577: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8578: FROM DUAL;
8579: hr_utility.trace(' inserting into Sublines -2JYUPA');
8580: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8581: X_ROWID => l_rowid,

Line 8580: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

8576:
8577: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8578: FROM DUAL;
8579: hr_utility.trace(' inserting into Sublines -2JYUPA');
8580: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8581: X_ROWID => l_rowid,
8582: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8583: X_PAYROLL_LINE_ID => x_payroll_line_id,
8584: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 8641: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

8637: if round(x_balance_amount, g_precision) <> 0.00 then
8638: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8639: end if;
8640:
8641: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8642: FROM DUAL;
8643: hr_utility.trace(' inserting into Sublines -2NBMM');
8644: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8645: X_ROWID => l_rowid,

Line 8644: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

8640:
8641: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8642: FROM DUAL;
8643: hr_utility.trace(' inserting into Sublines -2NBMM');
8644: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8645: X_ROWID => l_rowid,
8646: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8647: X_PAYROLL_LINE_ID => x_payroll_line_id,
8648: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 8705: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id

8701: if round(x_balance_amount,g_precision) <> 0.00 then
8702: l_amount := l_amount + round((x_balance_amount * (l_no_of_days / g_no_of_person_work_days)), g_precision);
8703: end if;
8704:
8705: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8706: FROM DUAL;
8707: hr_utility.trace(' inserting into Sublines -2TOPP');
8708: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8709: X_ROWID => l_rowid,

Line 8708: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

8704:
8705: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id
8706: FROM DUAL;
8707: hr_utility.trace(' inserting into Sublines -2TOPP');
8708: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8709: X_ROWID => l_rowid,
8710: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8711: X_PAYROLL_LINE_ID => x_payroll_line_id,
8712: X_SUB_LINE_START_DATE => l_tmp_start_date,

Line 8752: DELETE psp_payroll_sub_lines

8748: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,
8749: X_MODE => 'R');
8750:
8751:
8752: DELETE psp_payroll_sub_lines
8753: WHERE payroll_sub_line_id = g_sublines_rec.payroll_sub_line_id;
8754: end;
8755: end if;
8756: l_old_value := l_new_value;

Line 8901: into psp_payroll_lines and psp_payroll_sub_lines

8897:
8898: Who When What
8899: lveerubh 15-SEP-2001 Creating the procedure
8900: This procedure inserts a single line
8901: into psp_payroll_lines and psp_payroll_sub_lines
8902: with sub line start date and sub line end date
8903: as date earned
8904: amakrish 01-Apr-2008 Changed the sub line start date and sub line end date
8905: to be least of date earned or payroll period end date

Line 8941: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;

8937: psp_payroll_lines
8938: where payroll_line_id = x_payroll_line_id));
8939:
8940: -- Inserting into PSP_SUB_LINES
8941: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
8942: hr_utility.trace(' inserting into Sublines -2UISISI');
8943: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8944: X_ROWID => l_rowid,
8945: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,

Line 8943: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

8939:
8940: -- Inserting into PSP_SUB_LINES
8941: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
8942: hr_utility.trace(' inserting into Sublines -2UISISI');
8943: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (
8944: X_ROWID => l_rowid,
8945: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8946: X_PAYROLL_LINE_ID => x_payroll_line_id,
8947: X_SUB_LINE_START_DATE => least(trunc(g_payroll_line_rec.effective_Date), trunc(l_tp_end_date)), /*Bug 6886237*/

Line 9124: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;

9120: l_final_salary := round((l_total_salary + l_balance_amount), g_precision);
9121: hr_utility.trace(' l_finally_salary 2= '||l_final_salary);
9122: END IF;
9123:
9124: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
9125:
9126: hr_utility.trace(' inserting into Sublines -2LLLLLLLALALAL');
9127: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW
9128: (X_ROWID => l_rowid,

Line 9127: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW

9123:
9124: SELECT PSP_PAYROLL_SUB_LINES_S.NEXTVAL into l_sub_line_id FROM DUAL;
9125:
9126: hr_utility.trace(' inserting into Sublines -2LLLLLLLALALAL');
9127: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW
9128: (X_ROWID => l_rowid,
9129: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
9130: X_PAYROLL_LINE_ID => p_payroll_line_id,
9131: X_SUB_LINE_START_DATE => l_start_date,