APPS.PSP_PAYTRN dependencies on PSP_SUB_LINE_REASONS_PKG

Line 3164: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

3160: X_MODE => 'R' );
3161: hr_utility.trace(' Crossed Insert rec into sub lines');
3162:
3163: l_rowid := NULL;
3164: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
3165: X_ROWID => l_rowid,
3166: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3167: X_REASON_CODE => 'SALARY_CHANGE',
3168: X_PARENT_LINE_ID => l_sub_line_id,

Line 3235: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

3231: X_MODE => 'R' );
3232: ----hr_utility.trace(' Sub line ' || to_char(l_sub_line_id));
3233: ----hr_utility.trace(' Crossed Insert rec into sub lines 2');
3234: l_rowid := NULL;
3235: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
3236: X_ROWID => l_rowid,
3237: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3238: X_REASON_CODE => 'SALARY_CHANGE',
3239: X_PARENT_LINE_ID => l_sub_line_id,

Line 3316: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

3312: x_attribute10 => NULL,
3313: X_MODE => 'R' );
3314: ----dbms_output.PUT_LINE('After Insert rec into sub lines 3');
3315: l_rowid := NULL;
3316: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
3317: X_ROWID => l_rowid,
3318: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3319: X_REASON_CODE => 'NO_SALARY_CHANGE',
3320: X_PARENT_LINE_ID => l_sub_line_id,

Line 3391: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

3387: x_attribute9 => NULL,
3388: x_attribute10 => NULL,
3389: X_MODE => 'R' );
3390: l_rowid := NULL;
3391: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
3392: X_ROWID => l_rowid,
3393: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3394: X_REASON_CODE => 'NO_SALARY_CHANGE',
3395: X_PARENT_LINE_ID => l_sub_line_id,

Line 3639: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

3635: x_attribute9 => NULL,
3636: x_attribute10 => NULL,
3637: X_MODE => 'R');
3638: l_rowid := NULL;
3639: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
3640: X_ROWID => l_rowid,
3641: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3642: X_REASON_CODE => 'ASSG_STATUS_CHANGE',
3643: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 3688: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

3684: x_attribute9 => NULL,
3685: x_attribute10 => NULL,
3686: X_MODE => 'R');
3687: l_rowid := NULL;
3688: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
3689: X_ROWID => l_rowid,
3690: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3691: X_REASON_CODE => 'ASSG_STATUS_CHANGE',
3692: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 3744: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

3740: x_attribute9 => NULL,
3741: x_attribute10 => NULL,
3742: X_MODE => 'R');
3743: l_rowid := NULL;
3744: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
3745: X_ROWID => l_rowid,
3746: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3747: X_REASON_CODE => 'ASSG_STATUS_CHANGE',
3748: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 3808: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

3804: x_attribute9 => NULL,
3805: x_attribute10 => NULL,
3806: X_MODE => 'R');
3807: l_rowid := NULL;
3808: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
3809: X_ROWID => l_rowid,
3810: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3811: X_REASON_CODE => 'ASSG_STATUS_CHANGE',
3812: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 3878: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

3874: x_attribute9 => NULL,
3875: x_attribute10 => NULL,
3876: X_MODE => 'R');
3877: l_rowid := NULL;
3878: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
3879: X_ROWID => l_rowid,
3880: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3881: X_REASON_CODE => 'ASSG_STATUS_CHANGE',
3882: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 3926: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

3922: x_attribute9 => NULL,
3923: x_attribute10 => NULL,
3924: X_MODE => 'R');
3925: l_rowid := NULL;
3926: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
3927: X_ROWID => l_rowid,
3928: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
3929: X_REASON_CODE => 'ASSG_STATUS_CHANGE',
3930: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 3990: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

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

Line 4062: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

4058: x_attribute9 => NULL,
4059: x_attribute10 => NULL,
4060: X_MODE => 'R');
4061: l_rowid := NULL;
4062: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
4063: X_ROWID => l_rowid,
4064: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4065: X_REASON_CODE => 'ASSG_STATUS_CHANGE',
4066: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 4111: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

4107: x_attribute9 => NULL,
4108: x_attribute10 => NULL,
4109: X_MODE => 'R');
4110: l_rowid := NULL;
4111: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
4112: X_ROWID => l_rowid,
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,

Line 4166: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

4162: x_attribute9 => NULL,
4163: x_attribute10 => NULL,
4164: X_MODE => 'R');
4165: l_rowid := NULL;
4166: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
4167: X_ROWID => l_rowid,
4168: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4169: X_REASON_CODE => 'ASSG_STATUS_CHANGE',
4170: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 4229: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

4225: x_attribute9 => NULL,
4226: x_attribute10 => NULL,
4227: X_MODE => 'R');
4228: l_rowid := NULL;
4229: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
4230: X_ROWID => l_rowid,
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,

Line 4356: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

4352: x_attribute9 => NULL,
4353: x_attribute10 => NULL,
4354: X_MODE => 'R');
4355: l_rowid := NULL;
4356: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
4357: X_ROWID => l_rowid,
4358: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4359: X_REASON_CODE => 'EMP_BEGIN_DATE',
4360: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 4403: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

4399: x_attribute9 => NULL,
4400: x_attribute10 => NULL,
4401: X_MODE => 'R');
4402: l_rowid := NULL;
4403: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
4404: X_ROWID => l_rowid,
4405: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4406: X_REASON_CODE => 'EMP_BEGIN_DATE',
4407: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 4469: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

4465: x_attribute9 => NULL,
4466: x_attribute10 => NULL,
4467: X_MODE => 'R');
4468: l_rowid := NULL;
4469: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
4470: X_ROWID => l_rowid,
4471: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4472: X_REASON_CODE => 'EMP_END_DATE',
4473: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 4516: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

4512: x_attribute9 => NULL,
4513: x_attribute10 => NULL,
4514: X_MODE => 'R');
4515: l_rowid := NULL;
4516: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
4517: X_ROWID => l_rowid,
4518: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4519: X_REASON_CODE => 'EMP_END_DATE',
4520: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 4702: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

4698: x_attribute9 => NULL,
4699: x_attribute10 => NULL,
4700: X_MODE => 'R');
4701: l_rowid := NULL;
4702: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
4703: X_ROWID => l_rowid,
4704: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4705: X_REASON_CODE => 'ORG_CHANGE',
4706: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 4766: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

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

Line 4839: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

4835: x_attribute9 => NULL,
4836: x_attribute10 => NULL,
4837: X_MODE => 'R');
4838: l_rowid := NULL;
4839: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
4840: X_ROWID => l_rowid,
4841: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4842: X_REASON_CODE => 'ORG_CHANGE',
4843: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 4903: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

4899: x_attribute9 => NULL,
4900: x_attribute10 => NULL,
4901: X_MODE => 'R');
4902: l_rowid := NULL;
4903: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
4904: X_ROWID => l_rowid,
4905: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4906: X_REASON_CODE => 'ORG_CHANGE',
4907: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 4973: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

4969: x_attribute9 => NULL,
4970: x_attribute10 => NULL,
4971: X_MODE => 'R');
4972: l_rowid := NULL;
4973: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
4974: X_ROWID => l_rowid,
4975: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
4976: X_REASON_CODE => 'ORG_CHANGE',
4977: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 5037: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

5033: x_attribute9 => NULL,
5034: x_attribute10 => NULL,
5035: X_MODE => 'R');
5036: l_rowid := NULL;
5037: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
5038: X_ROWID => l_rowid,
5039: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5040: X_REASON_CODE => 'ORG_CHANGE',
5041: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 5101: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

5097: x_attribute9 => NULL,
5098: x_attribute10 => NULL,
5099: X_MODE => 'R');
5100: l_rowid := NULL;
5101: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
5102: X_ROWID => l_rowid,
5103: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5104: X_REASON_CODE => 'ORG_CHANGE',
5105: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 5287: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

5283: x_attribute9 => NULL,
5284: x_attribute10 => NULL,
5285: X_MODE => 'R');
5286: l_rowid := NULL;
5287: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
5288: X_ROWID => l_rowid,
5289: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5290: X_REASON_CODE => 'JOB_CHANGE',
5291: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 5351: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

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

Line 5424: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

5420: x_attribute9 => NULL,
5421: x_attribute10 => NULL,
5422: X_MODE => 'R');
5423: l_rowid := NULL;
5424: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
5425: X_ROWID => l_rowid,
5426: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5427: X_REASON_CODE => 'JOB_CHANGE',
5428: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 5488: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

5484: x_attribute9 => NULL,
5485: x_attribute10 => NULL,
5486: X_MODE => 'R');
5487: l_rowid := NULL;
5488: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
5489: X_ROWID => l_rowid,
5490: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5491: X_REASON_CODE => 'JOB_CHANGE',
5492: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 5558: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

5554: x_attribute9 => NULL,
5555: x_attribute10 => NULL,
5556: X_MODE => 'R');
5557: l_rowid := NULL;
5558: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
5559: X_ROWID => l_rowid,
5560: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5561: X_REASON_CODE => 'JOB_CHANGE',
5562: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 5622: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

5618: x_attribute9 => NULL,
5619: x_attribute10 => NULL,
5620: X_MODE => 'R');
5621: l_rowid := NULL;
5622: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
5623: X_ROWID => l_rowid,
5624: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5625: X_REASON_CODE => 'JOB_CHANGE',
5626: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 5686: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

5682: x_attribute9 => NULL,
5683: x_attribute10 => NULL,
5684: X_MODE => 'R');
5685: l_rowid := NULL;
5686: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
5687: X_ROWID => l_rowid,
5688: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5689: X_REASON_CODE => 'JOB_CHANGE',
5690: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 5877: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

5873: x_attribute9 => NULL,
5874: x_attribute10 => NULL,
5875: X_MODE => 'R');
5876: l_rowid := NULL;
5877: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
5878: X_ROWID => l_rowid,
5879: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
5880: X_REASON_CODE => 'POSITION_CHANGE',
5881: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 5941: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

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

Line 6014: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

6010: x_attribute9 => NULL,
6011: x_attribute10 => NULL,
6012: X_MODE => 'R');
6013: l_rowid := NULL;
6014: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
6015: X_ROWID => l_rowid,
6016: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6017: X_REASON_CODE => 'POSITION_CHANGE',
6018: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 6078: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

6074: x_attribute9 => NULL,
6075: x_attribute10 => NULL,
6076: X_MODE => 'R');
6077: l_rowid := NULL;
6078: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
6079: X_ROWID => l_rowid,
6080: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6081: X_REASON_CODE => 'POSITION_CHANGE',
6082: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 6148: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

6144: x_attribute9 => NULL,
6145: x_attribute10 => NULL,
6146: X_MODE => 'R');
6147: l_rowid := NULL;
6148: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
6149: X_ROWID => l_rowid,
6150: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6151: X_REASON_CODE => 'POSITION_CHANGE',
6152: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 6212: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

6208: x_attribute9 => NULL,
6209: x_attribute10 => NULL,
6210: X_MODE => 'R');
6211: l_rowid := NULL;
6212: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
6213: X_ROWID => l_rowid,
6214: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6215: X_REASON_CODE => 'POSITION_CHANGE',
6216: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 6276: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

6272: x_attribute9 => NULL,
6273: x_attribute10 => NULL,
6274: X_MODE => 'R');
6275: l_rowid := NULL;
6276: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
6277: X_ROWID => l_rowid,
6278: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6279: X_REASON_CODE => 'POSITION_CHANGE',
6280: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 6468: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

6464: x_attribute9 => NULL,
6465: x_attribute10 => NULL,
6466: X_MODE => 'R');
6467: l_rowid := NULL;
6468: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
6469: X_ROWID => l_rowid,
6470: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6471: X_REASON_CODE => 'GRADE_CHANGE',
6472: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 6532: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

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

Line 6605: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

6601: x_attribute9 => NULL,
6602: x_attribute10 => NULL,
6603: X_MODE => 'R');
6604: l_rowid := NULL;
6605: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
6606: X_ROWID => l_rowid,
6607: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6608: X_REASON_CODE => 'GRADE_CHANGE',
6609: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 6669: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

6665: x_attribute9 => NULL,
6666: x_attribute10 => NULL,
6667: X_MODE => 'R');
6668: l_rowid := NULL;
6669: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
6670: X_ROWID => l_rowid,
6671: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6672: X_REASON_CODE => 'GRADE_CHANGE',
6673: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 6739: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

6735: x_attribute9 => NULL,
6736: x_attribute10 => NULL,
6737: X_MODE => 'R');
6738: l_rowid := NULL;
6739: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
6740: X_ROWID => l_rowid,
6741: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6742: X_REASON_CODE => 'GRADE_CHANGE',
6743: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 6803: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

6799: x_attribute9 => NULL,
6800: x_attribute10 => NULL,
6801: X_MODE => 'R');
6802: l_rowid := NULL;
6803: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
6804: X_ROWID => l_rowid,
6805: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6806: X_REASON_CODE => 'GRADE_CHANGE',
6807: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 6867: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

6863: x_attribute9 => NULL,
6864: x_attribute10 => NULL,
6865: X_MODE => 'R');
6866: l_rowid := NULL;
6867: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
6868: X_ROWID => l_rowid,
6869: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
6870: X_REASON_CODE => 'GRADE_CHANGE',
6871: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 7063: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

7059: x_attribute9 => NULL,
7060: x_attribute10 => NULL,
7061: X_MODE => 'R');
7062: l_rowid := NULL;
7063: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
7064: X_ROWID => l_rowid,
7065: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7066: X_REASON_CODE => 'PEOPLE_GROUP_CHANGE',
7067: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 7127: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

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

Line 7200: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

7196: x_attribute9 => NULL,
7197: x_attribute10 => NULL,
7198: X_MODE => 'R');
7199: l_rowid := NULL;
7200: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
7201: X_ROWID => l_rowid,
7202: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7203: X_REASON_CODE => 'PEOPLE_GROUP_CHANGE',
7204: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 7264: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

7260: x_attribute9 => NULL,
7261: x_attribute10 => NULL,
7262: X_MODE => 'R');
7263: l_rowid := NULL;
7264: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
7265: X_ROWID => l_rowid,
7266: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7267: X_REASON_CODE => 'PPGROUP_CHANGE',
7268: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 7334: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

7330: x_attribute9 => NULL,
7331: x_attribute10 => NULL,
7332: X_MODE => 'R');
7333: l_rowid := NULL;
7334: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
7335: X_ROWID => l_rowid,
7336: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7337: X_REASON_CODE => 'PEOPLE_GROUP_CHANGE',
7338: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 7398: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

7394: x_attribute9 => NULL,
7395: x_attribute10 => NULL,
7396: X_MODE => 'R');
7397: l_rowid := NULL;
7398: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
7399: X_ROWID => l_rowid,
7400: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7401: X_REASON_CODE => 'PEOPLE_GROUP_CHANGE',
7402: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 7462: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

7458: x_attribute9 => NULL,
7459: x_attribute10 => NULL,
7460: X_MODE => 'R');
7461: l_rowid := NULL;
7462: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
7463: X_ROWID => l_rowid,
7464: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7465: X_REASON_CODE => 'PEOPLE_GROUP_CHANGE',
7466: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 7742: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

7738: x_attribute9 => NULL,
7739: x_attribute10 => NULL,
7740: X_MODE => 'R');
7741: l_rowid := NULL;
7742: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
7743: X_ROWID => l_rowid,
7744: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7745: X_REASON_CODE => 'FTE_CHANGE',
7746: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 7806: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

7802: x_attribute9 => NULL,
7803: x_attribute10 => NULL,
7804: X_MODE => 'R');
7805: l_rowid := NULL;
7806: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
7807: X_ROWID => l_rowid,
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,

Line 7877: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

7873: x_attribute9 => NULL,
7874: x_attribute10 => NULL,
7875: X_MODE => 'R');
7876: l_rowid := NULL;
7877: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
7878: X_ROWID => l_rowid,
7879: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7880: X_REASON_CODE => 'FTE_CHANGE',
7881: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 7941: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

7937: x_attribute9 => NULL,
7938: x_attribute10 => NULL,
7939: X_MODE => 'R');
7940: l_rowid := NULL;
7941: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
7942: X_ROWID => l_rowid,
7943: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
7944: X_REASON_CODE => 'FTE_CHANGE',
7945: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 8011: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

8007: x_attribute9 => NULL,
8008: x_attribute10 => NULL,
8009: X_MODE => 'R');
8010: l_rowid := NULL;
8011: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
8012: X_ROWID => l_rowid,
8013: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8014: X_REASON_CODE => 'FTE_CHANGE',
8015: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 8075: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

8071: x_attribute9 => NULL,
8072: x_attribute10 => NULL,
8073: X_MODE => 'R');
8074: l_rowid := NULL;
8075: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
8076: X_ROWID => l_rowid,
8077: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8078: X_REASON_CODE => 'FTE_CHANGE',
8079: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 8139: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

8135: x_attribute9 => NULL,
8136: x_attribute10 => NULL,
8137: X_MODE => 'R');
8138: l_rowid := NULL;
8139: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
8140: X_ROWID => l_rowid,
8141: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8142: X_REASON_CODE => 'FTE_CHANGE',
8143: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 8345: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

8341: x_attribute9 => NULL,
8342: x_attribute10 => NULL,
8343: X_MODE => 'R');
8344: l_rowid := NULL;
8345: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
8346: X_ROWID => l_rowid,
8347: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8348: X_REASON_CODE => 'FTE_CHANGE',
8349: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 8409: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

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

Line 8482: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

8478: x_attribute9 => NULL,
8479: x_attribute10 => NULL,
8480: X_MODE => 'R');
8481: l_rowid := NULL;
8482: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
8483: X_ROWID => l_rowid,
8484: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8485: X_REASON_CODE => 'FTE_CHANGE',
8486: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 8546: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

8542: x_attribute9 => NULL,
8543: x_attribute10 => NULL,
8544: X_MODE => 'R');
8545: l_rowid := NULL;
8546: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
8547: X_ROWID => l_rowid,
8548: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8549: X_REASON_CODE => 'FTE_CHANGE',
8550: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 8616: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

8612: x_attribute9 => NULL,
8613: x_attribute10 => NULL,
8614: X_MODE => 'R');
8615: l_rowid := NULL;
8616: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
8617: X_ROWID => l_rowid,
8618: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8619: X_REASON_CODE => 'FTE_CHANGE',
8620: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 8680: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

8676: x_attribute9 => NULL,
8677: x_attribute10 => NULL,
8678: X_MODE => 'R');
8679: l_rowid := NULL;
8680: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
8681: X_ROWID => l_rowid,
8682: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8683: X_REASON_CODE => 'FTE_CHANGE',
8684: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 8744: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

8740: x_attribute9 => NULL,
8741: x_attribute10 => NULL,
8742: X_MODE => 'R');
8743: l_rowid := NULL;
8744: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
8745: X_ROWID => l_rowid,
8746: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8747: X_REASON_CODE => 'FTE_CHANGE',
8748: X_PARENT_LINE_ID => g_sublines_rec.payroll_sub_line_id,

Line 8981: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (

8977: X_MODE => 'R' );
8978:
8979: --Inserting into PSP_SUB_LINES_REASONS
8980: l_rowid := NULL;
8981: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW (
8982: X_ROWID => l_rowid,
8983: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
8984: X_REASON_CODE => x_reason,
8985: X_PARENT_LINE_ID => l_sub_line_id,

Line 9165: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW

9161: X_MODE => 'R' );
9162:
9163: l_rowid := NULL;
9164:
9165: PSP_SUB_LINE_REASONS_PKG.INSERT_ROW
9166: (X_ROWID => l_rowid,
9167: X_PAYROLL_SUB_LINE_ID => l_sub_line_id,
9168: X_REASON_CODE => 'SALARY_CHANGE',
9169: X_PARENT_LINE_ID => l_sub_line_id,