APPS.PSP_PAYTRN dependencies on PSP_SUB_LINE_REASONS_PKG

Line 3090: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

3086: X_MODE => 'R' );
3087: hr_utility.trace(' Crossed Insert rec into sub lines');
3088:
3089: l_rowid := NULL;
3090: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
3091: X_ROWID => l_rowid,
3092: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3093: X_REASON_CODE => 'SALARY_CHANGE',
3094: X_PARENT_LINE_ID => l_sub_line_id,

Line 3161: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

3157: X_MODE => 'R' );
3158: ----hr_utility.trace(' Sub line ' || to_char(l_sub_line_id));
3159: ----hr_utility.trace(' Crossed Insert rec into sub lines 2');
3160: l_rowid := NULL;
3161: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
3162: X_ROWID => l_rowid,
3163: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3164: X_REASON_CODE => 'SALARY_CHANGE',
3165: X_PARENT_LINE_ID => l_sub_line_id,

Line 3242: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

3238: x_attribute10 => NULL,
3239: X_MODE => 'R' );
3240: ----dbms_output.PUT_LINE('After Insert rec into sub lines 3');
3241: l_rowid := NULL;
3242: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
3243: X_ROWID => l_rowid,
3244: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3245: X_REASON_CODE => 'NO_SALARY_CHANGE',
3246: X_PARENT_LINE_ID => l_sub_line_id,

Line 3317: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

3313: x_attribute9 => NULL,
3314: x_attribute10 => NULL,
3315: X_MODE => 'R' );
3316: l_rowid := NULL;
3317: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
3318: X_ROWID => l_rowid,
3319: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3320: X_REASON_CODE => 'NO_SALARY_CHANGE',
3321: X_PARENT_LINE_ID => l_sub_line_id,

Line 3565: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

3561: x_attribute9 => NULL,
3562: x_attribute10 => NULL,
3563: X_MODE => 'R');
3564: l_rowid := NULL;
3565: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
3566: X_ROWID => l_rowid,
3567: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3568: X_REASON_CODE => 'ASSG_STATUS_CHANGE',
3569: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 3614: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

3610: x_attribute9 => NULL,
3611: x_attribute10 => NULL,
3612: X_MODE => 'R');
3613: l_rowid := NULL;
3614: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
3615: X_ROWID => l_rowid,
3616: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3617: X_REASON_CODE => 'ASSG_STATUS_CHANGE',
3618: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 3670: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

3666: x_attribute9 => NULL,
3667: x_attribute10 => NULL,
3668: X_MODE => 'R');
3669: l_rowid := NULL;
3670: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
3671: X_ROWID => l_rowid,
3672: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3673: X_REASON_CODE => 'ASSG_STATUS_CHANGE',
3674: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 3734: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

3730: x_attribute9 => NULL,
3731: x_attribute10 => NULL,
3732: X_MODE => 'R');
3733: l_rowid := NULL;
3734: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
3735: X_ROWID => l_rowid,
3736: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3737: X_REASON_CODE => 'ASSG_STATUS_CHANGE',
3738: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 3804: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

3800: x_attribute9 => NULL,
3801: x_attribute10 => NULL,
3802: X_MODE => 'R');
3803: l_rowid := NULL;
3804: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
3805: X_ROWID => l_rowid,
3806: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3807: X_REASON_CODE => 'ASSG_STATUS_CHANGE',
3808: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 3852: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

3848: x_attribute9 => NULL,
3849: x_attribute10 => NULL,
3850: X_MODE => 'R');
3851: l_rowid := NULL;
3852: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
3853: X_ROWID => l_rowid,
3854: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3855: X_REASON_CODE => 'ASSG_STATUS_CHANGE',
3856: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 3916: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

3912: x_attribute9 => NULL,
3913: x_attribute10 => NULL,
3914: X_MODE => 'R');
3915: l_rowid := NULL;
3916: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
3917: X_ROWID => l_rowid,
3918: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3919: X_REASON_CODE => 'ASSG_STATUS_CHANGE',
3920: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 3988: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

3984: x_attribute9 => NULL,
3985: x_attribute10 => NULL,
3986: X_MODE => 'R');
3987: l_rowid := NULL;
3988: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
3989: X_ROWID => l_rowid,
3990: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3991: X_REASON_CODE => 'ASSG_STATUS_CHANGE',
3992: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 4037: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

4033: x_attribute9 => NULL,
4034: x_attribute10 => NULL,
4035: X_MODE => 'R');
4036: l_rowid := NULL;
4037: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
4038: X_ROWID => l_rowid,
4039: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4040: X_REASON_CODE => 'ASSG_STATUS_CHANGE',
4041: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 4092: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

4088: x_attribute9 => NULL,
4089: x_attribute10 => NULL,
4090: X_MODE => 'R');
4091: l_rowid := NULL;
4092: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
4093: X_ROWID => l_rowid,
4094: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4095: X_REASON_CODE => 'ASSG_STATUS_CHANGE',
4096: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 4155: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

4151: x_attribute9 => NULL,
4152: x_attribute10 => NULL,
4153: X_MODE => 'R');
4154: l_rowid := NULL;
4155: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
4156: X_ROWID => l_rowid,
4157: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4158: X_REASON_CODE => 'ASSG_STATUS_CHANGE',
4159: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 4282: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

4278: x_attribute9 => NULL,
4279: x_attribute10 => NULL,
4280: X_MODE => 'R');
4281: l_rowid := NULL;
4282: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
4283: X_ROWID => l_rowid,
4284: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4285: X_REASON_CODE => 'EMP_BEGIN_DATE',
4286: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 4329: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

4325: x_attribute9 => NULL,
4326: x_attribute10 => NULL,
4327: X_MODE => 'R');
4328: l_rowid := NULL;
4329: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
4330: X_ROWID => l_rowid,
4331: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4332: X_REASON_CODE => 'EMP_BEGIN_DATE',
4333: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 4395: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

4391: x_attribute9 => NULL,
4392: x_attribute10 => NULL,
4393: X_MODE => 'R');
4394: l_rowid := NULL;
4395: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
4396: X_ROWID => l_rowid,
4397: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4398: X_REASON_CODE => 'EMP_END_DATE',
4399: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 4442: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

4438: x_attribute9 => NULL,
4439: x_attribute10 => NULL,
4440: X_MODE => 'R');
4441: l_rowid := NULL;
4442: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
4443: X_ROWID => l_rowid,
4444: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4445: X_REASON_CODE => 'EMP_END_DATE',
4446: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 4628: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

4624: x_attribute9 => NULL,
4625: x_attribute10 => NULL,
4626: X_MODE => 'R');
4627: l_rowid := NULL;
4628: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
4629: X_ROWID => l_rowid,
4630: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4631: X_REASON_CODE => 'ORG_CHANGE',
4632: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 4692: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

4688: x_attribute9 => NULL,
4689: x_attribute10 => NULL,
4690: X_MODE => 'R');
4691: l_rowid := NULL;
4692: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
4693: X_ROWID => l_rowid,
4694: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4695: X_REASON_CODE => 'ORG_CHANGE',
4696: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 4765: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

4761: x_attribute9 => NULL,
4762: x_attribute10 => NULL,
4763: X_MODE => 'R');
4764: l_rowid := NULL;
4765: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
4766: X_ROWID => l_rowid,
4767: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4768: X_REASON_CODE => 'ORG_CHANGE',
4769: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 4829: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

4825: x_attribute9 => NULL,
4826: x_attribute10 => NULL,
4827: X_MODE => 'R');
4828: l_rowid := NULL;
4829: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
4830: X_ROWID => l_rowid,
4831: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4832: X_REASON_CODE => 'ORG_CHANGE',
4833: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 4899: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

4895: x_attribute9 => NULL,
4896: x_attribute10 => NULL,
4897: X_MODE => 'R');
4898: l_rowid := NULL;
4899: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
4900: X_ROWID => l_rowid,
4901: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4902: X_REASON_CODE => 'ORG_CHANGE',
4903: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 4963: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

4959: x_attribute9 => NULL,
4960: x_attribute10 => NULL,
4961: X_MODE => 'R');
4962: l_rowid := NULL;
4963: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
4964: X_ROWID => l_rowid,
4965: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4966: X_REASON_CODE => 'ORG_CHANGE',
4967: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 5027: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

5023: x_attribute9 => NULL,
5024: x_attribute10 => NULL,
5025: X_MODE => 'R');
5026: l_rowid := NULL;
5027: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
5028: X_ROWID => l_rowid,
5029: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5030: X_REASON_CODE => 'ORG_CHANGE',
5031: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 5213: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

5209: x_attribute9 => NULL,
5210: x_attribute10 => NULL,
5211: X_MODE => 'R');
5212: l_rowid := NULL;
5213: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
5214: X_ROWID => l_rowid,
5215: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5216: X_REASON_CODE => 'JOB_CHANGE',
5217: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 5277: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

5273: x_attribute9 => NULL,
5274: x_attribute10 => NULL,
5275: X_MODE => 'R');
5276: l_rowid := NULL;
5277: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
5278: X_ROWID => l_rowid,
5279: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5280: X_REASON_CODE => 'JOB_CHANGE',
5281: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 5350: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

5346: x_attribute9 => NULL,
5347: x_attribute10 => NULL,
5348: X_MODE => 'R');
5349: l_rowid := NULL;
5350: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
5351: X_ROWID => l_rowid,
5352: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5353: X_REASON_CODE => 'JOB_CHANGE',
5354: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 5414: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

5410: x_attribute9 => NULL,
5411: x_attribute10 => NULL,
5412: X_MODE => 'R');
5413: l_rowid := NULL;
5414: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
5415: X_ROWID => l_rowid,
5416: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5417: X_REASON_CODE => 'JOB_CHANGE',
5418: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 5484: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

5480: x_attribute9 => NULL,
5481: x_attribute10 => NULL,
5482: X_MODE => 'R');
5483: l_rowid := NULL;
5484: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
5485: X_ROWID => l_rowid,
5486: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5487: X_REASON_CODE => 'JOB_CHANGE',
5488: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 5548: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

5544: x_attribute9 => NULL,
5545: x_attribute10 => NULL,
5546: X_MODE => 'R');
5547: l_rowid := NULL;
5548: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
5549: X_ROWID => l_rowid,
5550: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5551: X_REASON_CODE => 'JOB_CHANGE',
5552: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 5612: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

5608: x_attribute9 => NULL,
5609: x_attribute10 => NULL,
5610: X_MODE => 'R');
5611: l_rowid := NULL;
5612: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
5613: X_ROWID => l_rowid,
5614: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5615: X_REASON_CODE => 'JOB_CHANGE',
5616: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 5803: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

5799: x_attribute9 => NULL,
5800: x_attribute10 => NULL,
5801: X_MODE => 'R');
5802: l_rowid := NULL;
5803: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
5804: X_ROWID => l_rowid,
5805: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5806: X_REASON_CODE => 'POSITION_CHANGE',
5807: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 5867: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

5863: x_attribute9 => NULL,
5864: x_attribute10 => NULL,
5865: X_MODE => 'R');
5866: l_rowid := NULL;
5867: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
5868: X_ROWID => l_rowid,
5869: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5870: X_REASON_CODE => 'POSITION_CHANGE',
5871: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 5940: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

5936: x_attribute9 => NULL,
5937: x_attribute10 => NULL,
5938: X_MODE => 'R');
5939: l_rowid := NULL;
5940: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
5941: X_ROWID => l_rowid,
5942: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5943: X_REASON_CODE => 'POSITION_CHANGE',
5944: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 6004: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

6000: x_attribute9 => NULL,
6001: x_attribute10 => NULL,
6002: X_MODE => 'R');
6003: l_rowid := NULL;
6004: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
6005: X_ROWID => l_rowid,
6006: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6007: X_REASON_CODE => 'POSITION_CHANGE',
6008: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 6074: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

6070: x_attribute9 => NULL,
6071: x_attribute10 => NULL,
6072: X_MODE => 'R');
6073: l_rowid := NULL;
6074: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
6075: X_ROWID => l_rowid,
6076: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6077: X_REASON_CODE => 'POSITION_CHANGE',
6078: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 6138: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

6134: x_attribute9 => NULL,
6135: x_attribute10 => NULL,
6136: X_MODE => 'R');
6137: l_rowid := NULL;
6138: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
6139: X_ROWID => l_rowid,
6140: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6141: X_REASON_CODE => 'POSITION_CHANGE',
6142: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 6202: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

6198: x_attribute9 => NULL,
6199: x_attribute10 => NULL,
6200: X_MODE => 'R');
6201: l_rowid := NULL;
6202: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
6203: X_ROWID => l_rowid,
6204: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6205: X_REASON_CODE => 'POSITION_CHANGE',
6206: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 6394: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

6390: x_attribute9 => NULL,
6391: x_attribute10 => NULL,
6392: X_MODE => 'R');
6393: l_rowid := NULL;
6394: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
6395: X_ROWID => l_rowid,
6396: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6397: X_REASON_CODE => 'GRADE_CHANGE',
6398: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 6458: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

6454: x_attribute9 => NULL,
6455: x_attribute10 => NULL,
6456: X_MODE => 'R');
6457: l_rowid := NULL;
6458: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
6459: X_ROWID => l_rowid,
6460: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6461: X_REASON_CODE => 'GRADE_CHANGE',
6462: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 6531: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

6527: x_attribute9 => NULL,
6528: x_attribute10 => NULL,
6529: X_MODE => 'R');
6530: l_rowid := NULL;
6531: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
6532: X_ROWID => l_rowid,
6533: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6534: X_REASON_CODE => 'GRADE_CHANGE',
6535: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 6595: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

6591: x_attribute9 => NULL,
6592: x_attribute10 => NULL,
6593: X_MODE => 'R');
6594: l_rowid := NULL;
6595: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
6596: X_ROWID => l_rowid,
6597: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6598: X_REASON_CODE => 'GRADE_CHANGE',
6599: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 6665: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

6661: x_attribute9 => NULL,
6662: x_attribute10 => NULL,
6663: X_MODE => 'R');
6664: l_rowid := NULL;
6665: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
6666: X_ROWID => l_rowid,
6667: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6668: X_REASON_CODE => 'GRADE_CHANGE',
6669: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 6729: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

6725: x_attribute9 => NULL,
6726: x_attribute10 => NULL,
6727: X_MODE => 'R');
6728: l_rowid := NULL;
6729: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
6730: X_ROWID => l_rowid,
6731: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6732: X_REASON_CODE => 'GRADE_CHANGE',
6733: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 6793: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

6789: x_attribute9 => NULL,
6790: x_attribute10 => NULL,
6791: X_MODE => 'R');
6792: l_rowid := NULL;
6793: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
6794: X_ROWID => l_rowid,
6795: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6796: X_REASON_CODE => 'GRADE_CHANGE',
6797: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 6989: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

6985: x_attribute9 => NULL,
6986: x_attribute10 => NULL,
6987: X_MODE => 'R');
6988: l_rowid := NULL;
6989: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
6990: X_ROWID => l_rowid,
6991: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6992: X_REASON_CODE => 'PEOPLE_GROUP_CHANGE',
6993: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 7053: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

7049: x_attribute9 => NULL,
7050: x_attribute10 => NULL,
7051: X_MODE => 'R');
7052: l_rowid := NULL;
7053: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
7054: X_ROWID => l_rowid,
7055: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7056: X_REASON_CODE => 'PEOPLE_GROUP_CHANGE',
7057: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 7126: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

7122: x_attribute9 => NULL,
7123: x_attribute10 => NULL,
7124: X_MODE => 'R');
7125: l_rowid := NULL;
7126: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
7127: X_ROWID => l_rowid,
7128: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7129: X_REASON_CODE => 'PEOPLE_GROUP_CHANGE',
7130: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 7190: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

7186: x_attribute9 => NULL,
7187: x_attribute10 => NULL,
7188: X_MODE => 'R');
7189: l_rowid := NULL;
7190: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
7191: X_ROWID => l_rowid,
7192: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7193: X_REASON_CODE => 'PPGROUP_CHANGE',
7194: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 7260: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

7256: x_attribute9 => NULL,
7257: x_attribute10 => NULL,
7258: X_MODE => 'R');
7259: l_rowid := NULL;
7260: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
7261: X_ROWID => l_rowid,
7262: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7263: X_REASON_CODE => 'PEOPLE_GROUP_CHANGE',
7264: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 7324: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

7320: x_attribute9 => NULL,
7321: x_attribute10 => NULL,
7322: X_MODE => 'R');
7323: l_rowid := NULL;
7324: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
7325: X_ROWID => l_rowid,
7326: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7327: X_REASON_CODE => 'PEOPLE_GROUP_CHANGE',
7328: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 7388: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

7384: x_attribute9 => NULL,
7385: x_attribute10 => NULL,
7386: X_MODE => 'R');
7387: l_rowid := NULL;
7388: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
7389: X_ROWID => l_rowid,
7390: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7391: X_REASON_CODE => 'PEOPLE_GROUP_CHANGE',
7392: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 7668: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

7664: x_attribute9 => NULL,
7665: x_attribute10 => NULL,
7666: X_MODE => 'R');
7667: l_rowid := NULL;
7668: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
7669: X_ROWID => l_rowid,
7670: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7671: X_REASON_CODE => 'FTE_CHANGE',
7672: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 7732: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

7728: x_attribute9 => NULL,
7729: x_attribute10 => NULL,
7730: X_MODE => 'R');
7731: l_rowid := NULL;
7732: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
7733: X_ROWID => l_rowid,
7734: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7735: X_REASON_CODE => 'FTE_CHANGE',
7736: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 7803: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

7799: x_attribute9 => NULL,
7800: x_attribute10 => NULL,
7801: X_MODE => 'R');
7802: l_rowid := NULL;
7803: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
7804: X_ROWID => l_rowid,
7805: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7806: X_REASON_CODE => 'FTE_CHANGE',
7807: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 7867: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

7863: x_attribute9 => NULL,
7864: x_attribute10 => NULL,
7865: X_MODE => 'R');
7866: l_rowid := NULL;
7867: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
7868: X_ROWID => l_rowid,
7869: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7870: X_REASON_CODE => 'FTE_CHANGE',
7871: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 7937: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

7933: x_attribute9 => NULL,
7934: x_attribute10 => NULL,
7935: X_MODE => 'R');
7936: l_rowid := NULL;
7937: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
7938: X_ROWID => l_rowid,
7939: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7940: X_REASON_CODE => 'FTE_CHANGE',
7941: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 8001: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

7997: x_attribute9 => NULL,
7998: x_attribute10 => NULL,
7999: X_MODE => 'R');
8000: l_rowid := NULL;
8001: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
8002: X_ROWID => l_rowid,
8003: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8004: X_REASON_CODE => 'FTE_CHANGE',
8005: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 8065: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

8061: x_attribute9 => NULL,
8062: x_attribute10 => NULL,
8063: X_MODE => 'R');
8064: l_rowid := NULL;
8065: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
8066: X_ROWID => l_rowid,
8067: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8068: X_REASON_CODE => 'FTE_CHANGE',
8069: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 8271: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

8267: x_attribute9 => NULL,
8268: x_attribute10 => NULL,
8269: X_MODE => 'R');
8270: l_rowid := NULL;
8271: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
8272: X_ROWID => l_rowid,
8273: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8274: X_REASON_CODE => 'FTE_CHANGE',
8275: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 8335: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

8331: x_attribute9 => NULL,
8332: x_attribute10 => NULL,
8333: X_MODE => 'R');
8334: l_rowid := NULL;
8335: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
8336: X_ROWID => l_rowid,
8337: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8338: X_REASON_CODE => 'FTE_CHANGE',
8339: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 8408: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

8404: x_attribute9 => NULL,
8405: x_attribute10 => NULL,
8406: X_MODE => 'R');
8407: l_rowid := NULL;
8408: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
8409: X_ROWID => l_rowid,
8410: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8411: X_REASON_CODE => 'FTE_CHANGE',
8412: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 8472: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

8468: x_attribute9 => NULL,
8469: x_attribute10 => NULL,
8470: X_MODE => 'R');
8471: l_rowid := NULL;
8472: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
8473: X_ROWID => l_rowid,
8474: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8475: X_REASON_CODE => 'FTE_CHANGE',
8476: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 8542: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

8538: x_attribute9 => NULL,
8539: x_attribute10 => NULL,
8540: X_MODE => 'R');
8541: l_rowid := NULL;
8542: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
8543: X_ROWID => l_rowid,
8544: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8545: X_REASON_CODE => 'FTE_CHANGE',
8546: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 8606: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

8602: x_attribute9 => NULL,
8603: x_attribute10 => NULL,
8604: X_MODE => 'R');
8605: l_rowid := NULL;
8606: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
8607: X_ROWID => l_rowid,
8608: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8609: X_REASON_CODE => 'FTE_CHANGE',
8610: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 8670: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

8666: x_attribute9 => NULL,
8667: x_attribute10 => NULL,
8668: X_MODE => 'R');
8669: l_rowid := NULL;
8670: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
8671: X_ROWID => l_rowid,
8672: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8673: X_REASON_CODE => 'FTE_CHANGE',
8674: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 8907: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

8903: X_MODE => 'R' );
8904:
8905: --Inserting into PSP_SUB_LINES_REASONS
8906: l_rowid := NULL;
8907: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
8908: X_ROWID => l_rowid,
8909: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8910: X_REASON_CODE => x_reason,
8911: X_PARENT_LINE_ID => l_sub_line_id,

Line 9091: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW

9087: X_MODE => 'R' );
9088:
9089: l_rowid := NULL;
9090:
9091: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW
9092: (X_ROWID => l_rowid,
9093: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
9094: X_REASON_CODE => 'SALARY_CHANGE',
9095: X_PARENT_LINE_ID => l_sub_line_id,