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