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_PKG

Line 3052: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 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,

Line 3205: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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)),

Line 3281: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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)),

Line 3529: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 3578: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 3634: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 3698: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 3768: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 3816: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 3880: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 3952: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 4001: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 4056: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 4119: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 4246: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 4293: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 4359: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 4406: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 4592: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 4656: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 4729: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 4793: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 4863: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 4927: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 4991: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 5177: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 5241: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 5314: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 5378: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 5448: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 5512: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 5576: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 5767: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 5831: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 5904: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 5968: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 6038: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 6102: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 6166: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 6358: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 6422: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 6495: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 6559: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 6629: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 6693: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 6757: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 6953: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 7017: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 7090: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 7154: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 7224: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 7288: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 7352: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 7632: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 7696: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 7767: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 7831: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 7901: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 7965: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 8029: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 8235: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 8299: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 8372: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 8436: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 8506: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 8570: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 8634: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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,

Line 8869: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW (

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*/

Line 9053: PSP_PAYROLL_SUB_LINES_PKG.INSERT_ROW

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,