136: end if;
137: --
138: hr_utility.set_location('Leaving:'|| l_proc, 30);
139: Exception
140: When HR_Api.Object_Locked then
141: --
142: -- This autonomous transaction was unable to lock the row.
143: -- It can be assumed that another transaction has locked the
144: -- row and is performing the update. Hence the error can
281: end if;
282: --
283: hr_utility.set_location('Leaving:'|| l_proc, 30);
284: Exception
285: When HR_Api.Object_Locked then
286: --
287: -- This autonomous transaction was unable to lock the row.
288: -- It can be assumed that another transaction has locked the
289: -- row and is performing the update. Hence the error can
606:
607: --
608: --Get the Legislation code.
609: --
610: l_legislation_code := hr_api.return_legislation_code(l_business_group_id);
611:
612: --
613: -- Validate the business group and set the CLIENT_INFO.
614: --
611:
612: --
613: -- Validate the business group and set the CLIENT_INFO.
614: --
615: hr_api.validate_bus_grp_id
616: (p_business_group_id => l_business_group_id
617: ,p_associated_column1 => 'PAY_ALL_PAYROLLS_F'
618: || '.BUSINESS_GROUP_ID');
619:
859: ,p_workload_shifting_level => p_workload_shifting_level
860: ,p_payslip_view_date_offset => p_payslip_view_date_offset
861: );
862: exception
863: when hr_api.cannot_find_prog_unit then
864: hr_api.cannot_find_prog_unit_error
865: (p_module_name => 'create_payroll'
866: ,p_hook_type => 'BP'
867: );
860: ,p_payslip_view_date_offset => p_payslip_view_date_offset
861: );
862: exception
863: when hr_api.cannot_find_prog_unit then
864: hr_api.cannot_find_prog_unit_error
865: (p_module_name => 'create_payroll'
866: ,p_hook_type => 'BP'
867: );
868: end;
1406: ,p_opm_effective_end_date => l_effective_end_date
1407: ,p_comment_id => p_comment_id
1408: );
1409: exception
1410: when hr_api.cannot_find_prog_unit then
1411: hr_api.cannot_find_prog_unit_error
1412: (p_module_name => 'create_payroll'
1413: ,p_hook_type => 'AP'
1414: );
1407: ,p_comment_id => p_comment_id
1408: );
1409: exception
1410: when hr_api.cannot_find_prog_unit then
1411: hr_api.cannot_find_prog_unit_error
1412: (p_module_name => 'create_payroll'
1413: ,p_hook_type => 'AP'
1414: );
1415: --
1416: end;
1417:
1418: if(p_validate) then
1419: --
1420: raise hr_api.validate_enabled;
1421: --
1422: end if;
1423: --
1424: -- Create time periods for the created payroll.
1484: --
1485: hr_utility.set_location(' Leaving:'||l_proc, 70);
1486: --
1487: exception
1488: when hr_api.validate_enabled then
1489: --
1490: --Must remove all work done by this procedure.
1491: --
1492: rollback to create_payroll;
1545: (
1546: p_validate in boolean default false,
1547: p_effective_date in date,
1548: p_datetrack_mode in varchar2,
1549: p_payroll_name in varchar2 default hr_api.g_varchar2,
1550: p_number_of_years in number default hr_api.g_number,
1551: p_default_payment_method_id in number default hr_api.g_number,
1552: p_consolidation_set_id in number default hr_api.g_number,
1553: p_cost_alloc_keyflex_id_in in number default hr_api.g_number,
1546: p_validate in boolean default false,
1547: p_effective_date in date,
1548: p_datetrack_mode in varchar2,
1549: p_payroll_name in varchar2 default hr_api.g_varchar2,
1550: p_number_of_years in number default hr_api.g_number,
1551: p_default_payment_method_id in number default hr_api.g_number,
1552: p_consolidation_set_id in number default hr_api.g_number,
1553: p_cost_alloc_keyflex_id_in in number default hr_api.g_number,
1554: p_susp_account_keyflex_id_in in number default hr_api.g_number,
1547: p_effective_date in date,
1548: p_datetrack_mode in varchar2,
1549: p_payroll_name in varchar2 default hr_api.g_varchar2,
1550: p_number_of_years in number default hr_api.g_number,
1551: p_default_payment_method_id in number default hr_api.g_number,
1552: p_consolidation_set_id in number default hr_api.g_number,
1553: p_cost_alloc_keyflex_id_in in number default hr_api.g_number,
1554: p_susp_account_keyflex_id_in in number default hr_api.g_number,
1555: p_negative_pay_allowed_flag in varchar2 default hr_api.g_varchar2,
1548: p_datetrack_mode in varchar2,
1549: p_payroll_name in varchar2 default hr_api.g_varchar2,
1550: p_number_of_years in number default hr_api.g_number,
1551: p_default_payment_method_id in number default hr_api.g_number,
1552: p_consolidation_set_id in number default hr_api.g_number,
1553: p_cost_alloc_keyflex_id_in in number default hr_api.g_number,
1554: p_susp_account_keyflex_id_in in number default hr_api.g_number,
1555: p_negative_pay_allowed_flag in varchar2 default hr_api.g_varchar2,
1556: p_soft_coding_keyflex_id_in in number default hr_api.g_number,
1549: p_payroll_name in varchar2 default hr_api.g_varchar2,
1550: p_number_of_years in number default hr_api.g_number,
1551: p_default_payment_method_id in number default hr_api.g_number,
1552: p_consolidation_set_id in number default hr_api.g_number,
1553: p_cost_alloc_keyflex_id_in in number default hr_api.g_number,
1554: p_susp_account_keyflex_id_in in number default hr_api.g_number,
1555: p_negative_pay_allowed_flag in varchar2 default hr_api.g_varchar2,
1556: p_soft_coding_keyflex_id_in in number default hr_api.g_number,
1557: p_comments in varchar2 default hr_api.g_varchar2,
1550: p_number_of_years in number default hr_api.g_number,
1551: p_default_payment_method_id in number default hr_api.g_number,
1552: p_consolidation_set_id in number default hr_api.g_number,
1553: p_cost_alloc_keyflex_id_in in number default hr_api.g_number,
1554: p_susp_account_keyflex_id_in in number default hr_api.g_number,
1555: p_negative_pay_allowed_flag in varchar2 default hr_api.g_varchar2,
1556: p_soft_coding_keyflex_id_in in number default hr_api.g_number,
1557: p_comments in varchar2 default hr_api.g_varchar2,
1558: p_attribute_category in varchar2 default hr_api.g_varchar2,
1551: p_default_payment_method_id in number default hr_api.g_number,
1552: p_consolidation_set_id in number default hr_api.g_number,
1553: p_cost_alloc_keyflex_id_in in number default hr_api.g_number,
1554: p_susp_account_keyflex_id_in in number default hr_api.g_number,
1555: p_negative_pay_allowed_flag in varchar2 default hr_api.g_varchar2,
1556: p_soft_coding_keyflex_id_in in number default hr_api.g_number,
1557: p_comments in varchar2 default hr_api.g_varchar2,
1558: p_attribute_category in varchar2 default hr_api.g_varchar2,
1559: p_attribute1 in varchar2 default hr_api.g_varchar2,
1552: p_consolidation_set_id in number default hr_api.g_number,
1553: p_cost_alloc_keyflex_id_in in number default hr_api.g_number,
1554: p_susp_account_keyflex_id_in in number default hr_api.g_number,
1555: p_negative_pay_allowed_flag in varchar2 default hr_api.g_varchar2,
1556: p_soft_coding_keyflex_id_in in number default hr_api.g_number,
1557: p_comments in varchar2 default hr_api.g_varchar2,
1558: p_attribute_category in varchar2 default hr_api.g_varchar2,
1559: p_attribute1 in varchar2 default hr_api.g_varchar2,
1560: p_attribute2 in varchar2 default hr_api.g_varchar2,
1553: p_cost_alloc_keyflex_id_in in number default hr_api.g_number,
1554: p_susp_account_keyflex_id_in in number default hr_api.g_number,
1555: p_negative_pay_allowed_flag in varchar2 default hr_api.g_varchar2,
1556: p_soft_coding_keyflex_id_in in number default hr_api.g_number,
1557: p_comments in varchar2 default hr_api.g_varchar2,
1558: p_attribute_category in varchar2 default hr_api.g_varchar2,
1559: p_attribute1 in varchar2 default hr_api.g_varchar2,
1560: p_attribute2 in varchar2 default hr_api.g_varchar2,
1561: p_attribute3 in varchar2 default hr_api.g_varchar2,
1554: p_susp_account_keyflex_id_in in number default hr_api.g_number,
1555: p_negative_pay_allowed_flag in varchar2 default hr_api.g_varchar2,
1556: p_soft_coding_keyflex_id_in in number default hr_api.g_number,
1557: p_comments in varchar2 default hr_api.g_varchar2,
1558: p_attribute_category in varchar2 default hr_api.g_varchar2,
1559: p_attribute1 in varchar2 default hr_api.g_varchar2,
1560: p_attribute2 in varchar2 default hr_api.g_varchar2,
1561: p_attribute3 in varchar2 default hr_api.g_varchar2,
1562: p_attribute4 in varchar2 default hr_api.g_varchar2,
1555: p_negative_pay_allowed_flag in varchar2 default hr_api.g_varchar2,
1556: p_soft_coding_keyflex_id_in in number default hr_api.g_number,
1557: p_comments in varchar2 default hr_api.g_varchar2,
1558: p_attribute_category in varchar2 default hr_api.g_varchar2,
1559: p_attribute1 in varchar2 default hr_api.g_varchar2,
1560: p_attribute2 in varchar2 default hr_api.g_varchar2,
1561: p_attribute3 in varchar2 default hr_api.g_varchar2,
1562: p_attribute4 in varchar2 default hr_api.g_varchar2,
1563: p_attribute5 in varchar2 default hr_api.g_varchar2,
1556: p_soft_coding_keyflex_id_in in number default hr_api.g_number,
1557: p_comments in varchar2 default hr_api.g_varchar2,
1558: p_attribute_category in varchar2 default hr_api.g_varchar2,
1559: p_attribute1 in varchar2 default hr_api.g_varchar2,
1560: p_attribute2 in varchar2 default hr_api.g_varchar2,
1561: p_attribute3 in varchar2 default hr_api.g_varchar2,
1562: p_attribute4 in varchar2 default hr_api.g_varchar2,
1563: p_attribute5 in varchar2 default hr_api.g_varchar2,
1564: p_attribute6 in varchar2 default hr_api.g_varchar2,
1557: p_comments in varchar2 default hr_api.g_varchar2,
1558: p_attribute_category in varchar2 default hr_api.g_varchar2,
1559: p_attribute1 in varchar2 default hr_api.g_varchar2,
1560: p_attribute2 in varchar2 default hr_api.g_varchar2,
1561: p_attribute3 in varchar2 default hr_api.g_varchar2,
1562: p_attribute4 in varchar2 default hr_api.g_varchar2,
1563: p_attribute5 in varchar2 default hr_api.g_varchar2,
1564: p_attribute6 in varchar2 default hr_api.g_varchar2,
1565: p_attribute7 in varchar2 default hr_api.g_varchar2,
1558: p_attribute_category in varchar2 default hr_api.g_varchar2,
1559: p_attribute1 in varchar2 default hr_api.g_varchar2,
1560: p_attribute2 in varchar2 default hr_api.g_varchar2,
1561: p_attribute3 in varchar2 default hr_api.g_varchar2,
1562: p_attribute4 in varchar2 default hr_api.g_varchar2,
1563: p_attribute5 in varchar2 default hr_api.g_varchar2,
1564: p_attribute6 in varchar2 default hr_api.g_varchar2,
1565: p_attribute7 in varchar2 default hr_api.g_varchar2,
1566: p_attribute8 in varchar2 default hr_api.g_varchar2,
1559: p_attribute1 in varchar2 default hr_api.g_varchar2,
1560: p_attribute2 in varchar2 default hr_api.g_varchar2,
1561: p_attribute3 in varchar2 default hr_api.g_varchar2,
1562: p_attribute4 in varchar2 default hr_api.g_varchar2,
1563: p_attribute5 in varchar2 default hr_api.g_varchar2,
1564: p_attribute6 in varchar2 default hr_api.g_varchar2,
1565: p_attribute7 in varchar2 default hr_api.g_varchar2,
1566: p_attribute8 in varchar2 default hr_api.g_varchar2,
1567: p_attribute9 in varchar2 default hr_api.g_varchar2,
1560: p_attribute2 in varchar2 default hr_api.g_varchar2,
1561: p_attribute3 in varchar2 default hr_api.g_varchar2,
1562: p_attribute4 in varchar2 default hr_api.g_varchar2,
1563: p_attribute5 in varchar2 default hr_api.g_varchar2,
1564: p_attribute6 in varchar2 default hr_api.g_varchar2,
1565: p_attribute7 in varchar2 default hr_api.g_varchar2,
1566: p_attribute8 in varchar2 default hr_api.g_varchar2,
1567: p_attribute9 in varchar2 default hr_api.g_varchar2,
1568: p_attribute10 in varchar2 default hr_api.g_varchar2,
1561: p_attribute3 in varchar2 default hr_api.g_varchar2,
1562: p_attribute4 in varchar2 default hr_api.g_varchar2,
1563: p_attribute5 in varchar2 default hr_api.g_varchar2,
1564: p_attribute6 in varchar2 default hr_api.g_varchar2,
1565: p_attribute7 in varchar2 default hr_api.g_varchar2,
1566: p_attribute8 in varchar2 default hr_api.g_varchar2,
1567: p_attribute9 in varchar2 default hr_api.g_varchar2,
1568: p_attribute10 in varchar2 default hr_api.g_varchar2,
1569: p_attribute11 in varchar2 default hr_api.g_varchar2,
1562: p_attribute4 in varchar2 default hr_api.g_varchar2,
1563: p_attribute5 in varchar2 default hr_api.g_varchar2,
1564: p_attribute6 in varchar2 default hr_api.g_varchar2,
1565: p_attribute7 in varchar2 default hr_api.g_varchar2,
1566: p_attribute8 in varchar2 default hr_api.g_varchar2,
1567: p_attribute9 in varchar2 default hr_api.g_varchar2,
1568: p_attribute10 in varchar2 default hr_api.g_varchar2,
1569: p_attribute11 in varchar2 default hr_api.g_varchar2,
1570: p_attribute12 in varchar2 default hr_api.g_varchar2,
1563: p_attribute5 in varchar2 default hr_api.g_varchar2,
1564: p_attribute6 in varchar2 default hr_api.g_varchar2,
1565: p_attribute7 in varchar2 default hr_api.g_varchar2,
1566: p_attribute8 in varchar2 default hr_api.g_varchar2,
1567: p_attribute9 in varchar2 default hr_api.g_varchar2,
1568: p_attribute10 in varchar2 default hr_api.g_varchar2,
1569: p_attribute11 in varchar2 default hr_api.g_varchar2,
1570: p_attribute12 in varchar2 default hr_api.g_varchar2,
1571: p_attribute13 in varchar2 default hr_api.g_varchar2,
1564: p_attribute6 in varchar2 default hr_api.g_varchar2,
1565: p_attribute7 in varchar2 default hr_api.g_varchar2,
1566: p_attribute8 in varchar2 default hr_api.g_varchar2,
1567: p_attribute9 in varchar2 default hr_api.g_varchar2,
1568: p_attribute10 in varchar2 default hr_api.g_varchar2,
1569: p_attribute11 in varchar2 default hr_api.g_varchar2,
1570: p_attribute12 in varchar2 default hr_api.g_varchar2,
1571: p_attribute13 in varchar2 default hr_api.g_varchar2,
1572: p_attribute14 in varchar2 default hr_api.g_varchar2,
1565: p_attribute7 in varchar2 default hr_api.g_varchar2,
1566: p_attribute8 in varchar2 default hr_api.g_varchar2,
1567: p_attribute9 in varchar2 default hr_api.g_varchar2,
1568: p_attribute10 in varchar2 default hr_api.g_varchar2,
1569: p_attribute11 in varchar2 default hr_api.g_varchar2,
1570: p_attribute12 in varchar2 default hr_api.g_varchar2,
1571: p_attribute13 in varchar2 default hr_api.g_varchar2,
1572: p_attribute14 in varchar2 default hr_api.g_varchar2,
1573: p_attribute15 in varchar2 default hr_api.g_varchar2,
1566: p_attribute8 in varchar2 default hr_api.g_varchar2,
1567: p_attribute9 in varchar2 default hr_api.g_varchar2,
1568: p_attribute10 in varchar2 default hr_api.g_varchar2,
1569: p_attribute11 in varchar2 default hr_api.g_varchar2,
1570: p_attribute12 in varchar2 default hr_api.g_varchar2,
1571: p_attribute13 in varchar2 default hr_api.g_varchar2,
1572: p_attribute14 in varchar2 default hr_api.g_varchar2,
1573: p_attribute15 in varchar2 default hr_api.g_varchar2,
1574: p_attribute16 in varchar2 default hr_api.g_varchar2,
1567: p_attribute9 in varchar2 default hr_api.g_varchar2,
1568: p_attribute10 in varchar2 default hr_api.g_varchar2,
1569: p_attribute11 in varchar2 default hr_api.g_varchar2,
1570: p_attribute12 in varchar2 default hr_api.g_varchar2,
1571: p_attribute13 in varchar2 default hr_api.g_varchar2,
1572: p_attribute14 in varchar2 default hr_api.g_varchar2,
1573: p_attribute15 in varchar2 default hr_api.g_varchar2,
1574: p_attribute16 in varchar2 default hr_api.g_varchar2,
1575: p_attribute17 in varchar2 default hr_api.g_varchar2,
1568: p_attribute10 in varchar2 default hr_api.g_varchar2,
1569: p_attribute11 in varchar2 default hr_api.g_varchar2,
1570: p_attribute12 in varchar2 default hr_api.g_varchar2,
1571: p_attribute13 in varchar2 default hr_api.g_varchar2,
1572: p_attribute14 in varchar2 default hr_api.g_varchar2,
1573: p_attribute15 in varchar2 default hr_api.g_varchar2,
1574: p_attribute16 in varchar2 default hr_api.g_varchar2,
1575: p_attribute17 in varchar2 default hr_api.g_varchar2,
1576: p_attribute18 in varchar2 default hr_api.g_varchar2,
1569: p_attribute11 in varchar2 default hr_api.g_varchar2,
1570: p_attribute12 in varchar2 default hr_api.g_varchar2,
1571: p_attribute13 in varchar2 default hr_api.g_varchar2,
1572: p_attribute14 in varchar2 default hr_api.g_varchar2,
1573: p_attribute15 in varchar2 default hr_api.g_varchar2,
1574: p_attribute16 in varchar2 default hr_api.g_varchar2,
1575: p_attribute17 in varchar2 default hr_api.g_varchar2,
1576: p_attribute18 in varchar2 default hr_api.g_varchar2,
1577: p_attribute19 in varchar2 default hr_api.g_varchar2,
1570: p_attribute12 in varchar2 default hr_api.g_varchar2,
1571: p_attribute13 in varchar2 default hr_api.g_varchar2,
1572: p_attribute14 in varchar2 default hr_api.g_varchar2,
1573: p_attribute15 in varchar2 default hr_api.g_varchar2,
1574: p_attribute16 in varchar2 default hr_api.g_varchar2,
1575: p_attribute17 in varchar2 default hr_api.g_varchar2,
1576: p_attribute18 in varchar2 default hr_api.g_varchar2,
1577: p_attribute19 in varchar2 default hr_api.g_varchar2,
1578: p_attribute20 in varchar2 default hr_api.g_varchar2,
1571: p_attribute13 in varchar2 default hr_api.g_varchar2,
1572: p_attribute14 in varchar2 default hr_api.g_varchar2,
1573: p_attribute15 in varchar2 default hr_api.g_varchar2,
1574: p_attribute16 in varchar2 default hr_api.g_varchar2,
1575: p_attribute17 in varchar2 default hr_api.g_varchar2,
1576: p_attribute18 in varchar2 default hr_api.g_varchar2,
1577: p_attribute19 in varchar2 default hr_api.g_varchar2,
1578: p_attribute20 in varchar2 default hr_api.g_varchar2,
1579: p_arrears_flag in varchar2 default hr_api.g_varchar2,
1572: p_attribute14 in varchar2 default hr_api.g_varchar2,
1573: p_attribute15 in varchar2 default hr_api.g_varchar2,
1574: p_attribute16 in varchar2 default hr_api.g_varchar2,
1575: p_attribute17 in varchar2 default hr_api.g_varchar2,
1576: p_attribute18 in varchar2 default hr_api.g_varchar2,
1577: p_attribute19 in varchar2 default hr_api.g_varchar2,
1578: p_attribute20 in varchar2 default hr_api.g_varchar2,
1579: p_arrears_flag in varchar2 default hr_api.g_varchar2,
1580: p_multi_assignments_flag in varchar2 default hr_api.g_varchar2,
1573: p_attribute15 in varchar2 default hr_api.g_varchar2,
1574: p_attribute16 in varchar2 default hr_api.g_varchar2,
1575: p_attribute17 in varchar2 default hr_api.g_varchar2,
1576: p_attribute18 in varchar2 default hr_api.g_varchar2,
1577: p_attribute19 in varchar2 default hr_api.g_varchar2,
1578: p_attribute20 in varchar2 default hr_api.g_varchar2,
1579: p_arrears_flag in varchar2 default hr_api.g_varchar2,
1580: p_multi_assignments_flag in varchar2 default hr_api.g_varchar2,
1581: p_prl_information1 in varchar2 default hr_api.g_varchar2,
1574: p_attribute16 in varchar2 default hr_api.g_varchar2,
1575: p_attribute17 in varchar2 default hr_api.g_varchar2,
1576: p_attribute18 in varchar2 default hr_api.g_varchar2,
1577: p_attribute19 in varchar2 default hr_api.g_varchar2,
1578: p_attribute20 in varchar2 default hr_api.g_varchar2,
1579: p_arrears_flag in varchar2 default hr_api.g_varchar2,
1580: p_multi_assignments_flag in varchar2 default hr_api.g_varchar2,
1581: p_prl_information1 in varchar2 default hr_api.g_varchar2,
1582: p_prl_information2 in varchar2 default hr_api.g_varchar2,
1575: p_attribute17 in varchar2 default hr_api.g_varchar2,
1576: p_attribute18 in varchar2 default hr_api.g_varchar2,
1577: p_attribute19 in varchar2 default hr_api.g_varchar2,
1578: p_attribute20 in varchar2 default hr_api.g_varchar2,
1579: p_arrears_flag in varchar2 default hr_api.g_varchar2,
1580: p_multi_assignments_flag in varchar2 default hr_api.g_varchar2,
1581: p_prl_information1 in varchar2 default hr_api.g_varchar2,
1582: p_prl_information2 in varchar2 default hr_api.g_varchar2,
1583: p_prl_information3 in varchar2 default hr_api.g_varchar2,
1576: p_attribute18 in varchar2 default hr_api.g_varchar2,
1577: p_attribute19 in varchar2 default hr_api.g_varchar2,
1578: p_attribute20 in varchar2 default hr_api.g_varchar2,
1579: p_arrears_flag in varchar2 default hr_api.g_varchar2,
1580: p_multi_assignments_flag in varchar2 default hr_api.g_varchar2,
1581: p_prl_information1 in varchar2 default hr_api.g_varchar2,
1582: p_prl_information2 in varchar2 default hr_api.g_varchar2,
1583: p_prl_information3 in varchar2 default hr_api.g_varchar2,
1584: p_prl_information4 in varchar2 default hr_api.g_varchar2,
1577: p_attribute19 in varchar2 default hr_api.g_varchar2,
1578: p_attribute20 in varchar2 default hr_api.g_varchar2,
1579: p_arrears_flag in varchar2 default hr_api.g_varchar2,
1580: p_multi_assignments_flag in varchar2 default hr_api.g_varchar2,
1581: p_prl_information1 in varchar2 default hr_api.g_varchar2,
1582: p_prl_information2 in varchar2 default hr_api.g_varchar2,
1583: p_prl_information3 in varchar2 default hr_api.g_varchar2,
1584: p_prl_information4 in varchar2 default hr_api.g_varchar2,
1585: p_prl_information5 in varchar2 default hr_api.g_varchar2,
1578: p_attribute20 in varchar2 default hr_api.g_varchar2,
1579: p_arrears_flag in varchar2 default hr_api.g_varchar2,
1580: p_multi_assignments_flag in varchar2 default hr_api.g_varchar2,
1581: p_prl_information1 in varchar2 default hr_api.g_varchar2,
1582: p_prl_information2 in varchar2 default hr_api.g_varchar2,
1583: p_prl_information3 in varchar2 default hr_api.g_varchar2,
1584: p_prl_information4 in varchar2 default hr_api.g_varchar2,
1585: p_prl_information5 in varchar2 default hr_api.g_varchar2,
1586: p_prl_information6 in varchar2 default hr_api.g_varchar2,
1579: p_arrears_flag in varchar2 default hr_api.g_varchar2,
1580: p_multi_assignments_flag in varchar2 default hr_api.g_varchar2,
1581: p_prl_information1 in varchar2 default hr_api.g_varchar2,
1582: p_prl_information2 in varchar2 default hr_api.g_varchar2,
1583: p_prl_information3 in varchar2 default hr_api.g_varchar2,
1584: p_prl_information4 in varchar2 default hr_api.g_varchar2,
1585: p_prl_information5 in varchar2 default hr_api.g_varchar2,
1586: p_prl_information6 in varchar2 default hr_api.g_varchar2,
1587: p_prl_information7 in varchar2 default hr_api.g_varchar2,
1580: p_multi_assignments_flag in varchar2 default hr_api.g_varchar2,
1581: p_prl_information1 in varchar2 default hr_api.g_varchar2,
1582: p_prl_information2 in varchar2 default hr_api.g_varchar2,
1583: p_prl_information3 in varchar2 default hr_api.g_varchar2,
1584: p_prl_information4 in varchar2 default hr_api.g_varchar2,
1585: p_prl_information5 in varchar2 default hr_api.g_varchar2,
1586: p_prl_information6 in varchar2 default hr_api.g_varchar2,
1587: p_prl_information7 in varchar2 default hr_api.g_varchar2,
1588: p_prl_information8 in varchar2 default hr_api.g_varchar2,
1581: p_prl_information1 in varchar2 default hr_api.g_varchar2,
1582: p_prl_information2 in varchar2 default hr_api.g_varchar2,
1583: p_prl_information3 in varchar2 default hr_api.g_varchar2,
1584: p_prl_information4 in varchar2 default hr_api.g_varchar2,
1585: p_prl_information5 in varchar2 default hr_api.g_varchar2,
1586: p_prl_information6 in varchar2 default hr_api.g_varchar2,
1587: p_prl_information7 in varchar2 default hr_api.g_varchar2,
1588: p_prl_information8 in varchar2 default hr_api.g_varchar2,
1589: p_prl_information9 in varchar2 default hr_api.g_varchar2,
1582: p_prl_information2 in varchar2 default hr_api.g_varchar2,
1583: p_prl_information3 in varchar2 default hr_api.g_varchar2,
1584: p_prl_information4 in varchar2 default hr_api.g_varchar2,
1585: p_prl_information5 in varchar2 default hr_api.g_varchar2,
1586: p_prl_information6 in varchar2 default hr_api.g_varchar2,
1587: p_prl_information7 in varchar2 default hr_api.g_varchar2,
1588: p_prl_information8 in varchar2 default hr_api.g_varchar2,
1589: p_prl_information9 in varchar2 default hr_api.g_varchar2,
1590: p_prl_information10 in varchar2 default hr_api.g_varchar2,
1583: p_prl_information3 in varchar2 default hr_api.g_varchar2,
1584: p_prl_information4 in varchar2 default hr_api.g_varchar2,
1585: p_prl_information5 in varchar2 default hr_api.g_varchar2,
1586: p_prl_information6 in varchar2 default hr_api.g_varchar2,
1587: p_prl_information7 in varchar2 default hr_api.g_varchar2,
1588: p_prl_information8 in varchar2 default hr_api.g_varchar2,
1589: p_prl_information9 in varchar2 default hr_api.g_varchar2,
1590: p_prl_information10 in varchar2 default hr_api.g_varchar2,
1591: p_prl_information11 in varchar2 default hr_api.g_varchar2,
1584: p_prl_information4 in varchar2 default hr_api.g_varchar2,
1585: p_prl_information5 in varchar2 default hr_api.g_varchar2,
1586: p_prl_information6 in varchar2 default hr_api.g_varchar2,
1587: p_prl_information7 in varchar2 default hr_api.g_varchar2,
1588: p_prl_information8 in varchar2 default hr_api.g_varchar2,
1589: p_prl_information9 in varchar2 default hr_api.g_varchar2,
1590: p_prl_information10 in varchar2 default hr_api.g_varchar2,
1591: p_prl_information11 in varchar2 default hr_api.g_varchar2,
1592: p_prl_information12 in varchar2 default hr_api.g_varchar2,
1585: p_prl_information5 in varchar2 default hr_api.g_varchar2,
1586: p_prl_information6 in varchar2 default hr_api.g_varchar2,
1587: p_prl_information7 in varchar2 default hr_api.g_varchar2,
1588: p_prl_information8 in varchar2 default hr_api.g_varchar2,
1589: p_prl_information9 in varchar2 default hr_api.g_varchar2,
1590: p_prl_information10 in varchar2 default hr_api.g_varchar2,
1591: p_prl_information11 in varchar2 default hr_api.g_varchar2,
1592: p_prl_information12 in varchar2 default hr_api.g_varchar2,
1593: p_prl_information13 in varchar2 default hr_api.g_varchar2,
1586: p_prl_information6 in varchar2 default hr_api.g_varchar2,
1587: p_prl_information7 in varchar2 default hr_api.g_varchar2,
1588: p_prl_information8 in varchar2 default hr_api.g_varchar2,
1589: p_prl_information9 in varchar2 default hr_api.g_varchar2,
1590: p_prl_information10 in varchar2 default hr_api.g_varchar2,
1591: p_prl_information11 in varchar2 default hr_api.g_varchar2,
1592: p_prl_information12 in varchar2 default hr_api.g_varchar2,
1593: p_prl_information13 in varchar2 default hr_api.g_varchar2,
1594: p_prl_information14 in varchar2 default hr_api.g_varchar2,
1587: p_prl_information7 in varchar2 default hr_api.g_varchar2,
1588: p_prl_information8 in varchar2 default hr_api.g_varchar2,
1589: p_prl_information9 in varchar2 default hr_api.g_varchar2,
1590: p_prl_information10 in varchar2 default hr_api.g_varchar2,
1591: p_prl_information11 in varchar2 default hr_api.g_varchar2,
1592: p_prl_information12 in varchar2 default hr_api.g_varchar2,
1593: p_prl_information13 in varchar2 default hr_api.g_varchar2,
1594: p_prl_information14 in varchar2 default hr_api.g_varchar2,
1595: p_prl_information15 in varchar2 default hr_api.g_varchar2,
1588: p_prl_information8 in varchar2 default hr_api.g_varchar2,
1589: p_prl_information9 in varchar2 default hr_api.g_varchar2,
1590: p_prl_information10 in varchar2 default hr_api.g_varchar2,
1591: p_prl_information11 in varchar2 default hr_api.g_varchar2,
1592: p_prl_information12 in varchar2 default hr_api.g_varchar2,
1593: p_prl_information13 in varchar2 default hr_api.g_varchar2,
1594: p_prl_information14 in varchar2 default hr_api.g_varchar2,
1595: p_prl_information15 in varchar2 default hr_api.g_varchar2,
1596: p_prl_information16 in varchar2 default hr_api.g_varchar2,
1589: p_prl_information9 in varchar2 default hr_api.g_varchar2,
1590: p_prl_information10 in varchar2 default hr_api.g_varchar2,
1591: p_prl_information11 in varchar2 default hr_api.g_varchar2,
1592: p_prl_information12 in varchar2 default hr_api.g_varchar2,
1593: p_prl_information13 in varchar2 default hr_api.g_varchar2,
1594: p_prl_information14 in varchar2 default hr_api.g_varchar2,
1595: p_prl_information15 in varchar2 default hr_api.g_varchar2,
1596: p_prl_information16 in varchar2 default hr_api.g_varchar2,
1597: p_prl_information17 in varchar2 default hr_api.g_varchar2,
1590: p_prl_information10 in varchar2 default hr_api.g_varchar2,
1591: p_prl_information11 in varchar2 default hr_api.g_varchar2,
1592: p_prl_information12 in varchar2 default hr_api.g_varchar2,
1593: p_prl_information13 in varchar2 default hr_api.g_varchar2,
1594: p_prl_information14 in varchar2 default hr_api.g_varchar2,
1595: p_prl_information15 in varchar2 default hr_api.g_varchar2,
1596: p_prl_information16 in varchar2 default hr_api.g_varchar2,
1597: p_prl_information17 in varchar2 default hr_api.g_varchar2,
1598: p_prl_information18 in varchar2 default hr_api.g_varchar2,
1591: p_prl_information11 in varchar2 default hr_api.g_varchar2,
1592: p_prl_information12 in varchar2 default hr_api.g_varchar2,
1593: p_prl_information13 in varchar2 default hr_api.g_varchar2,
1594: p_prl_information14 in varchar2 default hr_api.g_varchar2,
1595: p_prl_information15 in varchar2 default hr_api.g_varchar2,
1596: p_prl_information16 in varchar2 default hr_api.g_varchar2,
1597: p_prl_information17 in varchar2 default hr_api.g_varchar2,
1598: p_prl_information18 in varchar2 default hr_api.g_varchar2,
1599: p_prl_information19 in varchar2 default hr_api.g_varchar2,
1592: p_prl_information12 in varchar2 default hr_api.g_varchar2,
1593: p_prl_information13 in varchar2 default hr_api.g_varchar2,
1594: p_prl_information14 in varchar2 default hr_api.g_varchar2,
1595: p_prl_information15 in varchar2 default hr_api.g_varchar2,
1596: p_prl_information16 in varchar2 default hr_api.g_varchar2,
1597: p_prl_information17 in varchar2 default hr_api.g_varchar2,
1598: p_prl_information18 in varchar2 default hr_api.g_varchar2,
1599: p_prl_information19 in varchar2 default hr_api.g_varchar2,
1600: p_prl_information20 in varchar2 default hr_api.g_varchar2,
1593: p_prl_information13 in varchar2 default hr_api.g_varchar2,
1594: p_prl_information14 in varchar2 default hr_api.g_varchar2,
1595: p_prl_information15 in varchar2 default hr_api.g_varchar2,
1596: p_prl_information16 in varchar2 default hr_api.g_varchar2,
1597: p_prl_information17 in varchar2 default hr_api.g_varchar2,
1598: p_prl_information18 in varchar2 default hr_api.g_varchar2,
1599: p_prl_information19 in varchar2 default hr_api.g_varchar2,
1600: p_prl_information20 in varchar2 default hr_api.g_varchar2,
1601: p_prl_information21 in varchar2 default hr_api.g_varchar2,
1594: p_prl_information14 in varchar2 default hr_api.g_varchar2,
1595: p_prl_information15 in varchar2 default hr_api.g_varchar2,
1596: p_prl_information16 in varchar2 default hr_api.g_varchar2,
1597: p_prl_information17 in varchar2 default hr_api.g_varchar2,
1598: p_prl_information18 in varchar2 default hr_api.g_varchar2,
1599: p_prl_information19 in varchar2 default hr_api.g_varchar2,
1600: p_prl_information20 in varchar2 default hr_api.g_varchar2,
1601: p_prl_information21 in varchar2 default hr_api.g_varchar2,
1602: p_prl_information22 in varchar2 default hr_api.g_varchar2,
1595: p_prl_information15 in varchar2 default hr_api.g_varchar2,
1596: p_prl_information16 in varchar2 default hr_api.g_varchar2,
1597: p_prl_information17 in varchar2 default hr_api.g_varchar2,
1598: p_prl_information18 in varchar2 default hr_api.g_varchar2,
1599: p_prl_information19 in varchar2 default hr_api.g_varchar2,
1600: p_prl_information20 in varchar2 default hr_api.g_varchar2,
1601: p_prl_information21 in varchar2 default hr_api.g_varchar2,
1602: p_prl_information22 in varchar2 default hr_api.g_varchar2,
1603: p_prl_information23 in varchar2 default hr_api.g_varchar2,
1596: p_prl_information16 in varchar2 default hr_api.g_varchar2,
1597: p_prl_information17 in varchar2 default hr_api.g_varchar2,
1598: p_prl_information18 in varchar2 default hr_api.g_varchar2,
1599: p_prl_information19 in varchar2 default hr_api.g_varchar2,
1600: p_prl_information20 in varchar2 default hr_api.g_varchar2,
1601: p_prl_information21 in varchar2 default hr_api.g_varchar2,
1602: p_prl_information22 in varchar2 default hr_api.g_varchar2,
1603: p_prl_information23 in varchar2 default hr_api.g_varchar2,
1604: p_prl_information24 in varchar2 default hr_api.g_varchar2,
1597: p_prl_information17 in varchar2 default hr_api.g_varchar2,
1598: p_prl_information18 in varchar2 default hr_api.g_varchar2,
1599: p_prl_information19 in varchar2 default hr_api.g_varchar2,
1600: p_prl_information20 in varchar2 default hr_api.g_varchar2,
1601: p_prl_information21 in varchar2 default hr_api.g_varchar2,
1602: p_prl_information22 in varchar2 default hr_api.g_varchar2,
1603: p_prl_information23 in varchar2 default hr_api.g_varchar2,
1604: p_prl_information24 in varchar2 default hr_api.g_varchar2,
1605: p_prl_information25 in varchar2 default hr_api.g_varchar2,
1598: p_prl_information18 in varchar2 default hr_api.g_varchar2,
1599: p_prl_information19 in varchar2 default hr_api.g_varchar2,
1600: p_prl_information20 in varchar2 default hr_api.g_varchar2,
1601: p_prl_information21 in varchar2 default hr_api.g_varchar2,
1602: p_prl_information22 in varchar2 default hr_api.g_varchar2,
1603: p_prl_information23 in varchar2 default hr_api.g_varchar2,
1604: p_prl_information24 in varchar2 default hr_api.g_varchar2,
1605: p_prl_information25 in varchar2 default hr_api.g_varchar2,
1606: p_prl_information26 in varchar2 default hr_api.g_varchar2,
1599: p_prl_information19 in varchar2 default hr_api.g_varchar2,
1600: p_prl_information20 in varchar2 default hr_api.g_varchar2,
1601: p_prl_information21 in varchar2 default hr_api.g_varchar2,
1602: p_prl_information22 in varchar2 default hr_api.g_varchar2,
1603: p_prl_information23 in varchar2 default hr_api.g_varchar2,
1604: p_prl_information24 in varchar2 default hr_api.g_varchar2,
1605: p_prl_information25 in varchar2 default hr_api.g_varchar2,
1606: p_prl_information26 in varchar2 default hr_api.g_varchar2,
1607: p_prl_information27 in varchar2 default hr_api.g_varchar2,
1600: p_prl_information20 in varchar2 default hr_api.g_varchar2,
1601: p_prl_information21 in varchar2 default hr_api.g_varchar2,
1602: p_prl_information22 in varchar2 default hr_api.g_varchar2,
1603: p_prl_information23 in varchar2 default hr_api.g_varchar2,
1604: p_prl_information24 in varchar2 default hr_api.g_varchar2,
1605: p_prl_information25 in varchar2 default hr_api.g_varchar2,
1606: p_prl_information26 in varchar2 default hr_api.g_varchar2,
1607: p_prl_information27 in varchar2 default hr_api.g_varchar2,
1608: p_prl_information28 in varchar2 default hr_api.g_varchar2,
1601: p_prl_information21 in varchar2 default hr_api.g_varchar2,
1602: p_prl_information22 in varchar2 default hr_api.g_varchar2,
1603: p_prl_information23 in varchar2 default hr_api.g_varchar2,
1604: p_prl_information24 in varchar2 default hr_api.g_varchar2,
1605: p_prl_information25 in varchar2 default hr_api.g_varchar2,
1606: p_prl_information26 in varchar2 default hr_api.g_varchar2,
1607: p_prl_information27 in varchar2 default hr_api.g_varchar2,
1608: p_prl_information28 in varchar2 default hr_api.g_varchar2,
1609: p_prl_information29 in varchar2 default hr_api.g_varchar2,
1602: p_prl_information22 in varchar2 default hr_api.g_varchar2,
1603: p_prl_information23 in varchar2 default hr_api.g_varchar2,
1604: p_prl_information24 in varchar2 default hr_api.g_varchar2,
1605: p_prl_information25 in varchar2 default hr_api.g_varchar2,
1606: p_prl_information26 in varchar2 default hr_api.g_varchar2,
1607: p_prl_information27 in varchar2 default hr_api.g_varchar2,
1608: p_prl_information28 in varchar2 default hr_api.g_varchar2,
1609: p_prl_information29 in varchar2 default hr_api.g_varchar2,
1610: p_prl_information30 in varchar2 default hr_api.g_varchar2,
1603: p_prl_information23 in varchar2 default hr_api.g_varchar2,
1604: p_prl_information24 in varchar2 default hr_api.g_varchar2,
1605: p_prl_information25 in varchar2 default hr_api.g_varchar2,
1606: p_prl_information26 in varchar2 default hr_api.g_varchar2,
1607: p_prl_information27 in varchar2 default hr_api.g_varchar2,
1608: p_prl_information28 in varchar2 default hr_api.g_varchar2,
1609: p_prl_information29 in varchar2 default hr_api.g_varchar2,
1610: p_prl_information30 in varchar2 default hr_api.g_varchar2,
1611:
1604: p_prl_information24 in varchar2 default hr_api.g_varchar2,
1605: p_prl_information25 in varchar2 default hr_api.g_varchar2,
1606: p_prl_information26 in varchar2 default hr_api.g_varchar2,
1607: p_prl_information27 in varchar2 default hr_api.g_varchar2,
1608: p_prl_information28 in varchar2 default hr_api.g_varchar2,
1609: p_prl_information29 in varchar2 default hr_api.g_varchar2,
1610: p_prl_information30 in varchar2 default hr_api.g_varchar2,
1611:
1612: p_cost_segment1 in varchar2 default hr_api.g_varchar2,
1605: p_prl_information25 in varchar2 default hr_api.g_varchar2,
1606: p_prl_information26 in varchar2 default hr_api.g_varchar2,
1607: p_prl_information27 in varchar2 default hr_api.g_varchar2,
1608: p_prl_information28 in varchar2 default hr_api.g_varchar2,
1609: p_prl_information29 in varchar2 default hr_api.g_varchar2,
1610: p_prl_information30 in varchar2 default hr_api.g_varchar2,
1611:
1612: p_cost_segment1 in varchar2 default hr_api.g_varchar2,
1613: p_cost_segment2 in varchar2 default hr_api.g_varchar2,
1606: p_prl_information26 in varchar2 default hr_api.g_varchar2,
1607: p_prl_information27 in varchar2 default hr_api.g_varchar2,
1608: p_prl_information28 in varchar2 default hr_api.g_varchar2,
1609: p_prl_information29 in varchar2 default hr_api.g_varchar2,
1610: p_prl_information30 in varchar2 default hr_api.g_varchar2,
1611:
1612: p_cost_segment1 in varchar2 default hr_api.g_varchar2,
1613: p_cost_segment2 in varchar2 default hr_api.g_varchar2,
1614: p_cost_segment3 in varchar2 default hr_api.g_varchar2,
1608: p_prl_information28 in varchar2 default hr_api.g_varchar2,
1609: p_prl_information29 in varchar2 default hr_api.g_varchar2,
1610: p_prl_information30 in varchar2 default hr_api.g_varchar2,
1611:
1612: p_cost_segment1 in varchar2 default hr_api.g_varchar2,
1613: p_cost_segment2 in varchar2 default hr_api.g_varchar2,
1614: p_cost_segment3 in varchar2 default hr_api.g_varchar2,
1615: p_cost_segment4 in varchar2 default hr_api.g_varchar2,
1616: p_cost_segment5 in varchar2 default hr_api.g_varchar2,
1609: p_prl_information29 in varchar2 default hr_api.g_varchar2,
1610: p_prl_information30 in varchar2 default hr_api.g_varchar2,
1611:
1612: p_cost_segment1 in varchar2 default hr_api.g_varchar2,
1613: p_cost_segment2 in varchar2 default hr_api.g_varchar2,
1614: p_cost_segment3 in varchar2 default hr_api.g_varchar2,
1615: p_cost_segment4 in varchar2 default hr_api.g_varchar2,
1616: p_cost_segment5 in varchar2 default hr_api.g_varchar2,
1617: p_cost_segment6 in varchar2 default hr_api.g_varchar2,
1610: p_prl_information30 in varchar2 default hr_api.g_varchar2,
1611:
1612: p_cost_segment1 in varchar2 default hr_api.g_varchar2,
1613: p_cost_segment2 in varchar2 default hr_api.g_varchar2,
1614: p_cost_segment3 in varchar2 default hr_api.g_varchar2,
1615: p_cost_segment4 in varchar2 default hr_api.g_varchar2,
1616: p_cost_segment5 in varchar2 default hr_api.g_varchar2,
1617: p_cost_segment6 in varchar2 default hr_api.g_varchar2,
1618: p_cost_segment7 in varchar2 default hr_api.g_varchar2,
1611:
1612: p_cost_segment1 in varchar2 default hr_api.g_varchar2,
1613: p_cost_segment2 in varchar2 default hr_api.g_varchar2,
1614: p_cost_segment3 in varchar2 default hr_api.g_varchar2,
1615: p_cost_segment4 in varchar2 default hr_api.g_varchar2,
1616: p_cost_segment5 in varchar2 default hr_api.g_varchar2,
1617: p_cost_segment6 in varchar2 default hr_api.g_varchar2,
1618: p_cost_segment7 in varchar2 default hr_api.g_varchar2,
1619: p_cost_segment8 in varchar2 default hr_api.g_varchar2,
1612: p_cost_segment1 in varchar2 default hr_api.g_varchar2,
1613: p_cost_segment2 in varchar2 default hr_api.g_varchar2,
1614: p_cost_segment3 in varchar2 default hr_api.g_varchar2,
1615: p_cost_segment4 in varchar2 default hr_api.g_varchar2,
1616: p_cost_segment5 in varchar2 default hr_api.g_varchar2,
1617: p_cost_segment6 in varchar2 default hr_api.g_varchar2,
1618: p_cost_segment7 in varchar2 default hr_api.g_varchar2,
1619: p_cost_segment8 in varchar2 default hr_api.g_varchar2,
1620: p_cost_segment9 in varchar2 default hr_api.g_varchar2,
1613: p_cost_segment2 in varchar2 default hr_api.g_varchar2,
1614: p_cost_segment3 in varchar2 default hr_api.g_varchar2,
1615: p_cost_segment4 in varchar2 default hr_api.g_varchar2,
1616: p_cost_segment5 in varchar2 default hr_api.g_varchar2,
1617: p_cost_segment6 in varchar2 default hr_api.g_varchar2,
1618: p_cost_segment7 in varchar2 default hr_api.g_varchar2,
1619: p_cost_segment8 in varchar2 default hr_api.g_varchar2,
1620: p_cost_segment9 in varchar2 default hr_api.g_varchar2,
1621: p_cost_segment10 in varchar2 default hr_api.g_varchar2,
1614: p_cost_segment3 in varchar2 default hr_api.g_varchar2,
1615: p_cost_segment4 in varchar2 default hr_api.g_varchar2,
1616: p_cost_segment5 in varchar2 default hr_api.g_varchar2,
1617: p_cost_segment6 in varchar2 default hr_api.g_varchar2,
1618: p_cost_segment7 in varchar2 default hr_api.g_varchar2,
1619: p_cost_segment8 in varchar2 default hr_api.g_varchar2,
1620: p_cost_segment9 in varchar2 default hr_api.g_varchar2,
1621: p_cost_segment10 in varchar2 default hr_api.g_varchar2,
1622: p_cost_segment11 in varchar2 default hr_api.g_varchar2,
1615: p_cost_segment4 in varchar2 default hr_api.g_varchar2,
1616: p_cost_segment5 in varchar2 default hr_api.g_varchar2,
1617: p_cost_segment6 in varchar2 default hr_api.g_varchar2,
1618: p_cost_segment7 in varchar2 default hr_api.g_varchar2,
1619: p_cost_segment8 in varchar2 default hr_api.g_varchar2,
1620: p_cost_segment9 in varchar2 default hr_api.g_varchar2,
1621: p_cost_segment10 in varchar2 default hr_api.g_varchar2,
1622: p_cost_segment11 in varchar2 default hr_api.g_varchar2,
1623: p_cost_segment12 in varchar2 default hr_api.g_varchar2,
1616: p_cost_segment5 in varchar2 default hr_api.g_varchar2,
1617: p_cost_segment6 in varchar2 default hr_api.g_varchar2,
1618: p_cost_segment7 in varchar2 default hr_api.g_varchar2,
1619: p_cost_segment8 in varchar2 default hr_api.g_varchar2,
1620: p_cost_segment9 in varchar2 default hr_api.g_varchar2,
1621: p_cost_segment10 in varchar2 default hr_api.g_varchar2,
1622: p_cost_segment11 in varchar2 default hr_api.g_varchar2,
1623: p_cost_segment12 in varchar2 default hr_api.g_varchar2,
1624: p_cost_segment13 in varchar2 default hr_api.g_varchar2,
1617: p_cost_segment6 in varchar2 default hr_api.g_varchar2,
1618: p_cost_segment7 in varchar2 default hr_api.g_varchar2,
1619: p_cost_segment8 in varchar2 default hr_api.g_varchar2,
1620: p_cost_segment9 in varchar2 default hr_api.g_varchar2,
1621: p_cost_segment10 in varchar2 default hr_api.g_varchar2,
1622: p_cost_segment11 in varchar2 default hr_api.g_varchar2,
1623: p_cost_segment12 in varchar2 default hr_api.g_varchar2,
1624: p_cost_segment13 in varchar2 default hr_api.g_varchar2,
1625: p_cost_segment14 in varchar2 default hr_api.g_varchar2,
1618: p_cost_segment7 in varchar2 default hr_api.g_varchar2,
1619: p_cost_segment8 in varchar2 default hr_api.g_varchar2,
1620: p_cost_segment9 in varchar2 default hr_api.g_varchar2,
1621: p_cost_segment10 in varchar2 default hr_api.g_varchar2,
1622: p_cost_segment11 in varchar2 default hr_api.g_varchar2,
1623: p_cost_segment12 in varchar2 default hr_api.g_varchar2,
1624: p_cost_segment13 in varchar2 default hr_api.g_varchar2,
1625: p_cost_segment14 in varchar2 default hr_api.g_varchar2,
1626: p_cost_segment15 in varchar2 default hr_api.g_varchar2,
1619: p_cost_segment8 in varchar2 default hr_api.g_varchar2,
1620: p_cost_segment9 in varchar2 default hr_api.g_varchar2,
1621: p_cost_segment10 in varchar2 default hr_api.g_varchar2,
1622: p_cost_segment11 in varchar2 default hr_api.g_varchar2,
1623: p_cost_segment12 in varchar2 default hr_api.g_varchar2,
1624: p_cost_segment13 in varchar2 default hr_api.g_varchar2,
1625: p_cost_segment14 in varchar2 default hr_api.g_varchar2,
1626: p_cost_segment15 in varchar2 default hr_api.g_varchar2,
1627: p_cost_segment16 in varchar2 default hr_api.g_varchar2,
1620: p_cost_segment9 in varchar2 default hr_api.g_varchar2,
1621: p_cost_segment10 in varchar2 default hr_api.g_varchar2,
1622: p_cost_segment11 in varchar2 default hr_api.g_varchar2,
1623: p_cost_segment12 in varchar2 default hr_api.g_varchar2,
1624: p_cost_segment13 in varchar2 default hr_api.g_varchar2,
1625: p_cost_segment14 in varchar2 default hr_api.g_varchar2,
1626: p_cost_segment15 in varchar2 default hr_api.g_varchar2,
1627: p_cost_segment16 in varchar2 default hr_api.g_varchar2,
1628: p_cost_segment17 in varchar2 default hr_api.g_varchar2,
1621: p_cost_segment10 in varchar2 default hr_api.g_varchar2,
1622: p_cost_segment11 in varchar2 default hr_api.g_varchar2,
1623: p_cost_segment12 in varchar2 default hr_api.g_varchar2,
1624: p_cost_segment13 in varchar2 default hr_api.g_varchar2,
1625: p_cost_segment14 in varchar2 default hr_api.g_varchar2,
1626: p_cost_segment15 in varchar2 default hr_api.g_varchar2,
1627: p_cost_segment16 in varchar2 default hr_api.g_varchar2,
1628: p_cost_segment17 in varchar2 default hr_api.g_varchar2,
1629: p_cost_segment18 in varchar2 default hr_api.g_varchar2,
1622: p_cost_segment11 in varchar2 default hr_api.g_varchar2,
1623: p_cost_segment12 in varchar2 default hr_api.g_varchar2,
1624: p_cost_segment13 in varchar2 default hr_api.g_varchar2,
1625: p_cost_segment14 in varchar2 default hr_api.g_varchar2,
1626: p_cost_segment15 in varchar2 default hr_api.g_varchar2,
1627: p_cost_segment16 in varchar2 default hr_api.g_varchar2,
1628: p_cost_segment17 in varchar2 default hr_api.g_varchar2,
1629: p_cost_segment18 in varchar2 default hr_api.g_varchar2,
1630: p_cost_segment19 in varchar2 default hr_api.g_varchar2,
1623: p_cost_segment12 in varchar2 default hr_api.g_varchar2,
1624: p_cost_segment13 in varchar2 default hr_api.g_varchar2,
1625: p_cost_segment14 in varchar2 default hr_api.g_varchar2,
1626: p_cost_segment15 in varchar2 default hr_api.g_varchar2,
1627: p_cost_segment16 in varchar2 default hr_api.g_varchar2,
1628: p_cost_segment17 in varchar2 default hr_api.g_varchar2,
1629: p_cost_segment18 in varchar2 default hr_api.g_varchar2,
1630: p_cost_segment19 in varchar2 default hr_api.g_varchar2,
1631: p_cost_segment20 in varchar2 default hr_api.g_varchar2,
1624: p_cost_segment13 in varchar2 default hr_api.g_varchar2,
1625: p_cost_segment14 in varchar2 default hr_api.g_varchar2,
1626: p_cost_segment15 in varchar2 default hr_api.g_varchar2,
1627: p_cost_segment16 in varchar2 default hr_api.g_varchar2,
1628: p_cost_segment17 in varchar2 default hr_api.g_varchar2,
1629: p_cost_segment18 in varchar2 default hr_api.g_varchar2,
1630: p_cost_segment19 in varchar2 default hr_api.g_varchar2,
1631: p_cost_segment20 in varchar2 default hr_api.g_varchar2,
1632: p_cost_segment21 in varchar2 default hr_api.g_varchar2,
1625: p_cost_segment14 in varchar2 default hr_api.g_varchar2,
1626: p_cost_segment15 in varchar2 default hr_api.g_varchar2,
1627: p_cost_segment16 in varchar2 default hr_api.g_varchar2,
1628: p_cost_segment17 in varchar2 default hr_api.g_varchar2,
1629: p_cost_segment18 in varchar2 default hr_api.g_varchar2,
1630: p_cost_segment19 in varchar2 default hr_api.g_varchar2,
1631: p_cost_segment20 in varchar2 default hr_api.g_varchar2,
1632: p_cost_segment21 in varchar2 default hr_api.g_varchar2,
1633: p_cost_segment22 in varchar2 default hr_api.g_varchar2,
1626: p_cost_segment15 in varchar2 default hr_api.g_varchar2,
1627: p_cost_segment16 in varchar2 default hr_api.g_varchar2,
1628: p_cost_segment17 in varchar2 default hr_api.g_varchar2,
1629: p_cost_segment18 in varchar2 default hr_api.g_varchar2,
1630: p_cost_segment19 in varchar2 default hr_api.g_varchar2,
1631: p_cost_segment20 in varchar2 default hr_api.g_varchar2,
1632: p_cost_segment21 in varchar2 default hr_api.g_varchar2,
1633: p_cost_segment22 in varchar2 default hr_api.g_varchar2,
1634: p_cost_segment23 in varchar2 default hr_api.g_varchar2,
1627: p_cost_segment16 in varchar2 default hr_api.g_varchar2,
1628: p_cost_segment17 in varchar2 default hr_api.g_varchar2,
1629: p_cost_segment18 in varchar2 default hr_api.g_varchar2,
1630: p_cost_segment19 in varchar2 default hr_api.g_varchar2,
1631: p_cost_segment20 in varchar2 default hr_api.g_varchar2,
1632: p_cost_segment21 in varchar2 default hr_api.g_varchar2,
1633: p_cost_segment22 in varchar2 default hr_api.g_varchar2,
1634: p_cost_segment23 in varchar2 default hr_api.g_varchar2,
1635: p_cost_segment24 in varchar2 default hr_api.g_varchar2,
1628: p_cost_segment17 in varchar2 default hr_api.g_varchar2,
1629: p_cost_segment18 in varchar2 default hr_api.g_varchar2,
1630: p_cost_segment19 in varchar2 default hr_api.g_varchar2,
1631: p_cost_segment20 in varchar2 default hr_api.g_varchar2,
1632: p_cost_segment21 in varchar2 default hr_api.g_varchar2,
1633: p_cost_segment22 in varchar2 default hr_api.g_varchar2,
1634: p_cost_segment23 in varchar2 default hr_api.g_varchar2,
1635: p_cost_segment24 in varchar2 default hr_api.g_varchar2,
1636: p_cost_segment25 in varchar2 default hr_api.g_varchar2,
1629: p_cost_segment18 in varchar2 default hr_api.g_varchar2,
1630: p_cost_segment19 in varchar2 default hr_api.g_varchar2,
1631: p_cost_segment20 in varchar2 default hr_api.g_varchar2,
1632: p_cost_segment21 in varchar2 default hr_api.g_varchar2,
1633: p_cost_segment22 in varchar2 default hr_api.g_varchar2,
1634: p_cost_segment23 in varchar2 default hr_api.g_varchar2,
1635: p_cost_segment24 in varchar2 default hr_api.g_varchar2,
1636: p_cost_segment25 in varchar2 default hr_api.g_varchar2,
1637: p_cost_segment26 in varchar2 default hr_api.g_varchar2,
1630: p_cost_segment19 in varchar2 default hr_api.g_varchar2,
1631: p_cost_segment20 in varchar2 default hr_api.g_varchar2,
1632: p_cost_segment21 in varchar2 default hr_api.g_varchar2,
1633: p_cost_segment22 in varchar2 default hr_api.g_varchar2,
1634: p_cost_segment23 in varchar2 default hr_api.g_varchar2,
1635: p_cost_segment24 in varchar2 default hr_api.g_varchar2,
1636: p_cost_segment25 in varchar2 default hr_api.g_varchar2,
1637: p_cost_segment26 in varchar2 default hr_api.g_varchar2,
1638: p_cost_segment27 in varchar2 default hr_api.g_varchar2,
1631: p_cost_segment20 in varchar2 default hr_api.g_varchar2,
1632: p_cost_segment21 in varchar2 default hr_api.g_varchar2,
1633: p_cost_segment22 in varchar2 default hr_api.g_varchar2,
1634: p_cost_segment23 in varchar2 default hr_api.g_varchar2,
1635: p_cost_segment24 in varchar2 default hr_api.g_varchar2,
1636: p_cost_segment25 in varchar2 default hr_api.g_varchar2,
1637: p_cost_segment26 in varchar2 default hr_api.g_varchar2,
1638: p_cost_segment27 in varchar2 default hr_api.g_varchar2,
1639: p_cost_segment28 in varchar2 default hr_api.g_varchar2,
1632: p_cost_segment21 in varchar2 default hr_api.g_varchar2,
1633: p_cost_segment22 in varchar2 default hr_api.g_varchar2,
1634: p_cost_segment23 in varchar2 default hr_api.g_varchar2,
1635: p_cost_segment24 in varchar2 default hr_api.g_varchar2,
1636: p_cost_segment25 in varchar2 default hr_api.g_varchar2,
1637: p_cost_segment26 in varchar2 default hr_api.g_varchar2,
1638: p_cost_segment27 in varchar2 default hr_api.g_varchar2,
1639: p_cost_segment28 in varchar2 default hr_api.g_varchar2,
1640: p_cost_segment29 in varchar2 default hr_api.g_varchar2,
1633: p_cost_segment22 in varchar2 default hr_api.g_varchar2,
1634: p_cost_segment23 in varchar2 default hr_api.g_varchar2,
1635: p_cost_segment24 in varchar2 default hr_api.g_varchar2,
1636: p_cost_segment25 in varchar2 default hr_api.g_varchar2,
1637: p_cost_segment26 in varchar2 default hr_api.g_varchar2,
1638: p_cost_segment27 in varchar2 default hr_api.g_varchar2,
1639: p_cost_segment28 in varchar2 default hr_api.g_varchar2,
1640: p_cost_segment29 in varchar2 default hr_api.g_varchar2,
1641: p_cost_segment30 in varchar2 default hr_api.g_varchar2,
1634: p_cost_segment23 in varchar2 default hr_api.g_varchar2,
1635: p_cost_segment24 in varchar2 default hr_api.g_varchar2,
1636: p_cost_segment25 in varchar2 default hr_api.g_varchar2,
1637: p_cost_segment26 in varchar2 default hr_api.g_varchar2,
1638: p_cost_segment27 in varchar2 default hr_api.g_varchar2,
1639: p_cost_segment28 in varchar2 default hr_api.g_varchar2,
1640: p_cost_segment29 in varchar2 default hr_api.g_varchar2,
1641: p_cost_segment30 in varchar2 default hr_api.g_varchar2,
1642: p_cost_concat_segments_in in varchar2 default hr_api.g_varchar2,
1635: p_cost_segment24 in varchar2 default hr_api.g_varchar2,
1636: p_cost_segment25 in varchar2 default hr_api.g_varchar2,
1637: p_cost_segment26 in varchar2 default hr_api.g_varchar2,
1638: p_cost_segment27 in varchar2 default hr_api.g_varchar2,
1639: p_cost_segment28 in varchar2 default hr_api.g_varchar2,
1640: p_cost_segment29 in varchar2 default hr_api.g_varchar2,
1641: p_cost_segment30 in varchar2 default hr_api.g_varchar2,
1642: p_cost_concat_segments_in in varchar2 default hr_api.g_varchar2,
1643:
1636: p_cost_segment25 in varchar2 default hr_api.g_varchar2,
1637: p_cost_segment26 in varchar2 default hr_api.g_varchar2,
1638: p_cost_segment27 in varchar2 default hr_api.g_varchar2,
1639: p_cost_segment28 in varchar2 default hr_api.g_varchar2,
1640: p_cost_segment29 in varchar2 default hr_api.g_varchar2,
1641: p_cost_segment30 in varchar2 default hr_api.g_varchar2,
1642: p_cost_concat_segments_in in varchar2 default hr_api.g_varchar2,
1643:
1644: p_susp_segment1 in varchar2 default hr_api.g_varchar2,
1637: p_cost_segment26 in varchar2 default hr_api.g_varchar2,
1638: p_cost_segment27 in varchar2 default hr_api.g_varchar2,
1639: p_cost_segment28 in varchar2 default hr_api.g_varchar2,
1640: p_cost_segment29 in varchar2 default hr_api.g_varchar2,
1641: p_cost_segment30 in varchar2 default hr_api.g_varchar2,
1642: p_cost_concat_segments_in in varchar2 default hr_api.g_varchar2,
1643:
1644: p_susp_segment1 in varchar2 default hr_api.g_varchar2,
1645: p_susp_segment2 in varchar2 default hr_api.g_varchar2,
1638: p_cost_segment27 in varchar2 default hr_api.g_varchar2,
1639: p_cost_segment28 in varchar2 default hr_api.g_varchar2,
1640: p_cost_segment29 in varchar2 default hr_api.g_varchar2,
1641: p_cost_segment30 in varchar2 default hr_api.g_varchar2,
1642: p_cost_concat_segments_in in varchar2 default hr_api.g_varchar2,
1643:
1644: p_susp_segment1 in varchar2 default hr_api.g_varchar2,
1645: p_susp_segment2 in varchar2 default hr_api.g_varchar2,
1646: p_susp_segment3 in varchar2 default hr_api.g_varchar2,
1640: p_cost_segment29 in varchar2 default hr_api.g_varchar2,
1641: p_cost_segment30 in varchar2 default hr_api.g_varchar2,
1642: p_cost_concat_segments_in in varchar2 default hr_api.g_varchar2,
1643:
1644: p_susp_segment1 in varchar2 default hr_api.g_varchar2,
1645: p_susp_segment2 in varchar2 default hr_api.g_varchar2,
1646: p_susp_segment3 in varchar2 default hr_api.g_varchar2,
1647: p_susp_segment4 in varchar2 default hr_api.g_varchar2,
1648: p_susp_segment5 in varchar2 default hr_api.g_varchar2,
1641: p_cost_segment30 in varchar2 default hr_api.g_varchar2,
1642: p_cost_concat_segments_in in varchar2 default hr_api.g_varchar2,
1643:
1644: p_susp_segment1 in varchar2 default hr_api.g_varchar2,
1645: p_susp_segment2 in varchar2 default hr_api.g_varchar2,
1646: p_susp_segment3 in varchar2 default hr_api.g_varchar2,
1647: p_susp_segment4 in varchar2 default hr_api.g_varchar2,
1648: p_susp_segment5 in varchar2 default hr_api.g_varchar2,
1649: p_susp_segment6 in varchar2 default hr_api.g_varchar2,
1642: p_cost_concat_segments_in in varchar2 default hr_api.g_varchar2,
1643:
1644: p_susp_segment1 in varchar2 default hr_api.g_varchar2,
1645: p_susp_segment2 in varchar2 default hr_api.g_varchar2,
1646: p_susp_segment3 in varchar2 default hr_api.g_varchar2,
1647: p_susp_segment4 in varchar2 default hr_api.g_varchar2,
1648: p_susp_segment5 in varchar2 default hr_api.g_varchar2,
1649: p_susp_segment6 in varchar2 default hr_api.g_varchar2,
1650: p_susp_segment7 in varchar2 default hr_api.g_varchar2,
1643:
1644: p_susp_segment1 in varchar2 default hr_api.g_varchar2,
1645: p_susp_segment2 in varchar2 default hr_api.g_varchar2,
1646: p_susp_segment3 in varchar2 default hr_api.g_varchar2,
1647: p_susp_segment4 in varchar2 default hr_api.g_varchar2,
1648: p_susp_segment5 in varchar2 default hr_api.g_varchar2,
1649: p_susp_segment6 in varchar2 default hr_api.g_varchar2,
1650: p_susp_segment7 in varchar2 default hr_api.g_varchar2,
1651: p_susp_segment8 in varchar2 default hr_api.g_varchar2,
1644: p_susp_segment1 in varchar2 default hr_api.g_varchar2,
1645: p_susp_segment2 in varchar2 default hr_api.g_varchar2,
1646: p_susp_segment3 in varchar2 default hr_api.g_varchar2,
1647: p_susp_segment4 in varchar2 default hr_api.g_varchar2,
1648: p_susp_segment5 in varchar2 default hr_api.g_varchar2,
1649: p_susp_segment6 in varchar2 default hr_api.g_varchar2,
1650: p_susp_segment7 in varchar2 default hr_api.g_varchar2,
1651: p_susp_segment8 in varchar2 default hr_api.g_varchar2,
1652: p_susp_segment9 in varchar2 default hr_api.g_varchar2,
1645: p_susp_segment2 in varchar2 default hr_api.g_varchar2,
1646: p_susp_segment3 in varchar2 default hr_api.g_varchar2,
1647: p_susp_segment4 in varchar2 default hr_api.g_varchar2,
1648: p_susp_segment5 in varchar2 default hr_api.g_varchar2,
1649: p_susp_segment6 in varchar2 default hr_api.g_varchar2,
1650: p_susp_segment7 in varchar2 default hr_api.g_varchar2,
1651: p_susp_segment8 in varchar2 default hr_api.g_varchar2,
1652: p_susp_segment9 in varchar2 default hr_api.g_varchar2,
1653: p_susp_segment10 in varchar2 default hr_api.g_varchar2,
1646: p_susp_segment3 in varchar2 default hr_api.g_varchar2,
1647: p_susp_segment4 in varchar2 default hr_api.g_varchar2,
1648: p_susp_segment5 in varchar2 default hr_api.g_varchar2,
1649: p_susp_segment6 in varchar2 default hr_api.g_varchar2,
1650: p_susp_segment7 in varchar2 default hr_api.g_varchar2,
1651: p_susp_segment8 in varchar2 default hr_api.g_varchar2,
1652: p_susp_segment9 in varchar2 default hr_api.g_varchar2,
1653: p_susp_segment10 in varchar2 default hr_api.g_varchar2,
1654: p_susp_segment11 in varchar2 default hr_api.g_varchar2,
1647: p_susp_segment4 in varchar2 default hr_api.g_varchar2,
1648: p_susp_segment5 in varchar2 default hr_api.g_varchar2,
1649: p_susp_segment6 in varchar2 default hr_api.g_varchar2,
1650: p_susp_segment7 in varchar2 default hr_api.g_varchar2,
1651: p_susp_segment8 in varchar2 default hr_api.g_varchar2,
1652: p_susp_segment9 in varchar2 default hr_api.g_varchar2,
1653: p_susp_segment10 in varchar2 default hr_api.g_varchar2,
1654: p_susp_segment11 in varchar2 default hr_api.g_varchar2,
1655: p_susp_segment12 in varchar2 default hr_api.g_varchar2,
1648: p_susp_segment5 in varchar2 default hr_api.g_varchar2,
1649: p_susp_segment6 in varchar2 default hr_api.g_varchar2,
1650: p_susp_segment7 in varchar2 default hr_api.g_varchar2,
1651: p_susp_segment8 in varchar2 default hr_api.g_varchar2,
1652: p_susp_segment9 in varchar2 default hr_api.g_varchar2,
1653: p_susp_segment10 in varchar2 default hr_api.g_varchar2,
1654: p_susp_segment11 in varchar2 default hr_api.g_varchar2,
1655: p_susp_segment12 in varchar2 default hr_api.g_varchar2,
1656: p_susp_segment13 in varchar2 default hr_api.g_varchar2,
1649: p_susp_segment6 in varchar2 default hr_api.g_varchar2,
1650: p_susp_segment7 in varchar2 default hr_api.g_varchar2,
1651: p_susp_segment8 in varchar2 default hr_api.g_varchar2,
1652: p_susp_segment9 in varchar2 default hr_api.g_varchar2,
1653: p_susp_segment10 in varchar2 default hr_api.g_varchar2,
1654: p_susp_segment11 in varchar2 default hr_api.g_varchar2,
1655: p_susp_segment12 in varchar2 default hr_api.g_varchar2,
1656: p_susp_segment13 in varchar2 default hr_api.g_varchar2,
1657: p_susp_segment14 in varchar2 default hr_api.g_varchar2,
1650: p_susp_segment7 in varchar2 default hr_api.g_varchar2,
1651: p_susp_segment8 in varchar2 default hr_api.g_varchar2,
1652: p_susp_segment9 in varchar2 default hr_api.g_varchar2,
1653: p_susp_segment10 in varchar2 default hr_api.g_varchar2,
1654: p_susp_segment11 in varchar2 default hr_api.g_varchar2,
1655: p_susp_segment12 in varchar2 default hr_api.g_varchar2,
1656: p_susp_segment13 in varchar2 default hr_api.g_varchar2,
1657: p_susp_segment14 in varchar2 default hr_api.g_varchar2,
1658: p_susp_segment15 in varchar2 default hr_api.g_varchar2,
1651: p_susp_segment8 in varchar2 default hr_api.g_varchar2,
1652: p_susp_segment9 in varchar2 default hr_api.g_varchar2,
1653: p_susp_segment10 in varchar2 default hr_api.g_varchar2,
1654: p_susp_segment11 in varchar2 default hr_api.g_varchar2,
1655: p_susp_segment12 in varchar2 default hr_api.g_varchar2,
1656: p_susp_segment13 in varchar2 default hr_api.g_varchar2,
1657: p_susp_segment14 in varchar2 default hr_api.g_varchar2,
1658: p_susp_segment15 in varchar2 default hr_api.g_varchar2,
1659: p_susp_segment16 in varchar2 default hr_api.g_varchar2,
1652: p_susp_segment9 in varchar2 default hr_api.g_varchar2,
1653: p_susp_segment10 in varchar2 default hr_api.g_varchar2,
1654: p_susp_segment11 in varchar2 default hr_api.g_varchar2,
1655: p_susp_segment12 in varchar2 default hr_api.g_varchar2,
1656: p_susp_segment13 in varchar2 default hr_api.g_varchar2,
1657: p_susp_segment14 in varchar2 default hr_api.g_varchar2,
1658: p_susp_segment15 in varchar2 default hr_api.g_varchar2,
1659: p_susp_segment16 in varchar2 default hr_api.g_varchar2,
1660: p_susp_segment17 in varchar2 default hr_api.g_varchar2,
1653: p_susp_segment10 in varchar2 default hr_api.g_varchar2,
1654: p_susp_segment11 in varchar2 default hr_api.g_varchar2,
1655: p_susp_segment12 in varchar2 default hr_api.g_varchar2,
1656: p_susp_segment13 in varchar2 default hr_api.g_varchar2,
1657: p_susp_segment14 in varchar2 default hr_api.g_varchar2,
1658: p_susp_segment15 in varchar2 default hr_api.g_varchar2,
1659: p_susp_segment16 in varchar2 default hr_api.g_varchar2,
1660: p_susp_segment17 in varchar2 default hr_api.g_varchar2,
1661: p_susp_segment18 in varchar2 default hr_api.g_varchar2,
1654: p_susp_segment11 in varchar2 default hr_api.g_varchar2,
1655: p_susp_segment12 in varchar2 default hr_api.g_varchar2,
1656: p_susp_segment13 in varchar2 default hr_api.g_varchar2,
1657: p_susp_segment14 in varchar2 default hr_api.g_varchar2,
1658: p_susp_segment15 in varchar2 default hr_api.g_varchar2,
1659: p_susp_segment16 in varchar2 default hr_api.g_varchar2,
1660: p_susp_segment17 in varchar2 default hr_api.g_varchar2,
1661: p_susp_segment18 in varchar2 default hr_api.g_varchar2,
1662: p_susp_segment19 in varchar2 default hr_api.g_varchar2,
1655: p_susp_segment12 in varchar2 default hr_api.g_varchar2,
1656: p_susp_segment13 in varchar2 default hr_api.g_varchar2,
1657: p_susp_segment14 in varchar2 default hr_api.g_varchar2,
1658: p_susp_segment15 in varchar2 default hr_api.g_varchar2,
1659: p_susp_segment16 in varchar2 default hr_api.g_varchar2,
1660: p_susp_segment17 in varchar2 default hr_api.g_varchar2,
1661: p_susp_segment18 in varchar2 default hr_api.g_varchar2,
1662: p_susp_segment19 in varchar2 default hr_api.g_varchar2,
1663: p_susp_segment20 in varchar2 default hr_api.g_varchar2,
1656: p_susp_segment13 in varchar2 default hr_api.g_varchar2,
1657: p_susp_segment14 in varchar2 default hr_api.g_varchar2,
1658: p_susp_segment15 in varchar2 default hr_api.g_varchar2,
1659: p_susp_segment16 in varchar2 default hr_api.g_varchar2,
1660: p_susp_segment17 in varchar2 default hr_api.g_varchar2,
1661: p_susp_segment18 in varchar2 default hr_api.g_varchar2,
1662: p_susp_segment19 in varchar2 default hr_api.g_varchar2,
1663: p_susp_segment20 in varchar2 default hr_api.g_varchar2,
1664: p_susp_segment21 in varchar2 default hr_api.g_varchar2,
1657: p_susp_segment14 in varchar2 default hr_api.g_varchar2,
1658: p_susp_segment15 in varchar2 default hr_api.g_varchar2,
1659: p_susp_segment16 in varchar2 default hr_api.g_varchar2,
1660: p_susp_segment17 in varchar2 default hr_api.g_varchar2,
1661: p_susp_segment18 in varchar2 default hr_api.g_varchar2,
1662: p_susp_segment19 in varchar2 default hr_api.g_varchar2,
1663: p_susp_segment20 in varchar2 default hr_api.g_varchar2,
1664: p_susp_segment21 in varchar2 default hr_api.g_varchar2,
1665: p_susp_segment22 in varchar2 default hr_api.g_varchar2,
1658: p_susp_segment15 in varchar2 default hr_api.g_varchar2,
1659: p_susp_segment16 in varchar2 default hr_api.g_varchar2,
1660: p_susp_segment17 in varchar2 default hr_api.g_varchar2,
1661: p_susp_segment18 in varchar2 default hr_api.g_varchar2,
1662: p_susp_segment19 in varchar2 default hr_api.g_varchar2,
1663: p_susp_segment20 in varchar2 default hr_api.g_varchar2,
1664: p_susp_segment21 in varchar2 default hr_api.g_varchar2,
1665: p_susp_segment22 in varchar2 default hr_api.g_varchar2,
1666: p_susp_segment23 in varchar2 default hr_api.g_varchar2,
1659: p_susp_segment16 in varchar2 default hr_api.g_varchar2,
1660: p_susp_segment17 in varchar2 default hr_api.g_varchar2,
1661: p_susp_segment18 in varchar2 default hr_api.g_varchar2,
1662: p_susp_segment19 in varchar2 default hr_api.g_varchar2,
1663: p_susp_segment20 in varchar2 default hr_api.g_varchar2,
1664: p_susp_segment21 in varchar2 default hr_api.g_varchar2,
1665: p_susp_segment22 in varchar2 default hr_api.g_varchar2,
1666: p_susp_segment23 in varchar2 default hr_api.g_varchar2,
1667: p_susp_segment24 in varchar2 default hr_api.g_varchar2,
1660: p_susp_segment17 in varchar2 default hr_api.g_varchar2,
1661: p_susp_segment18 in varchar2 default hr_api.g_varchar2,
1662: p_susp_segment19 in varchar2 default hr_api.g_varchar2,
1663: p_susp_segment20 in varchar2 default hr_api.g_varchar2,
1664: p_susp_segment21 in varchar2 default hr_api.g_varchar2,
1665: p_susp_segment22 in varchar2 default hr_api.g_varchar2,
1666: p_susp_segment23 in varchar2 default hr_api.g_varchar2,
1667: p_susp_segment24 in varchar2 default hr_api.g_varchar2,
1668: p_susp_segment25 in varchar2 default hr_api.g_varchar2,
1661: p_susp_segment18 in varchar2 default hr_api.g_varchar2,
1662: p_susp_segment19 in varchar2 default hr_api.g_varchar2,
1663: p_susp_segment20 in varchar2 default hr_api.g_varchar2,
1664: p_susp_segment21 in varchar2 default hr_api.g_varchar2,
1665: p_susp_segment22 in varchar2 default hr_api.g_varchar2,
1666: p_susp_segment23 in varchar2 default hr_api.g_varchar2,
1667: p_susp_segment24 in varchar2 default hr_api.g_varchar2,
1668: p_susp_segment25 in varchar2 default hr_api.g_varchar2,
1669: p_susp_segment26 in varchar2 default hr_api.g_varchar2,
1662: p_susp_segment19 in varchar2 default hr_api.g_varchar2,
1663: p_susp_segment20 in varchar2 default hr_api.g_varchar2,
1664: p_susp_segment21 in varchar2 default hr_api.g_varchar2,
1665: p_susp_segment22 in varchar2 default hr_api.g_varchar2,
1666: p_susp_segment23 in varchar2 default hr_api.g_varchar2,
1667: p_susp_segment24 in varchar2 default hr_api.g_varchar2,
1668: p_susp_segment25 in varchar2 default hr_api.g_varchar2,
1669: p_susp_segment26 in varchar2 default hr_api.g_varchar2,
1670: p_susp_segment27 in varchar2 default hr_api.g_varchar2,
1663: p_susp_segment20 in varchar2 default hr_api.g_varchar2,
1664: p_susp_segment21 in varchar2 default hr_api.g_varchar2,
1665: p_susp_segment22 in varchar2 default hr_api.g_varchar2,
1666: p_susp_segment23 in varchar2 default hr_api.g_varchar2,
1667: p_susp_segment24 in varchar2 default hr_api.g_varchar2,
1668: p_susp_segment25 in varchar2 default hr_api.g_varchar2,
1669: p_susp_segment26 in varchar2 default hr_api.g_varchar2,
1670: p_susp_segment27 in varchar2 default hr_api.g_varchar2,
1671: p_susp_segment28 in varchar2 default hr_api.g_varchar2,
1664: p_susp_segment21 in varchar2 default hr_api.g_varchar2,
1665: p_susp_segment22 in varchar2 default hr_api.g_varchar2,
1666: p_susp_segment23 in varchar2 default hr_api.g_varchar2,
1667: p_susp_segment24 in varchar2 default hr_api.g_varchar2,
1668: p_susp_segment25 in varchar2 default hr_api.g_varchar2,
1669: p_susp_segment26 in varchar2 default hr_api.g_varchar2,
1670: p_susp_segment27 in varchar2 default hr_api.g_varchar2,
1671: p_susp_segment28 in varchar2 default hr_api.g_varchar2,
1672: p_susp_segment29 in varchar2 default hr_api.g_varchar2,
1665: p_susp_segment22 in varchar2 default hr_api.g_varchar2,
1666: p_susp_segment23 in varchar2 default hr_api.g_varchar2,
1667: p_susp_segment24 in varchar2 default hr_api.g_varchar2,
1668: p_susp_segment25 in varchar2 default hr_api.g_varchar2,
1669: p_susp_segment26 in varchar2 default hr_api.g_varchar2,
1670: p_susp_segment27 in varchar2 default hr_api.g_varchar2,
1671: p_susp_segment28 in varchar2 default hr_api.g_varchar2,
1672: p_susp_segment29 in varchar2 default hr_api.g_varchar2,
1673: p_susp_segment30 in varchar2 default hr_api.g_varchar2,
1666: p_susp_segment23 in varchar2 default hr_api.g_varchar2,
1667: p_susp_segment24 in varchar2 default hr_api.g_varchar2,
1668: p_susp_segment25 in varchar2 default hr_api.g_varchar2,
1669: p_susp_segment26 in varchar2 default hr_api.g_varchar2,
1670: p_susp_segment27 in varchar2 default hr_api.g_varchar2,
1671: p_susp_segment28 in varchar2 default hr_api.g_varchar2,
1672: p_susp_segment29 in varchar2 default hr_api.g_varchar2,
1673: p_susp_segment30 in varchar2 default hr_api.g_varchar2,
1674: p_susp_concat_segments_in in varchar2 default hr_api.g_varchar2,
1667: p_susp_segment24 in varchar2 default hr_api.g_varchar2,
1668: p_susp_segment25 in varchar2 default hr_api.g_varchar2,
1669: p_susp_segment26 in varchar2 default hr_api.g_varchar2,
1670: p_susp_segment27 in varchar2 default hr_api.g_varchar2,
1671: p_susp_segment28 in varchar2 default hr_api.g_varchar2,
1672: p_susp_segment29 in varchar2 default hr_api.g_varchar2,
1673: p_susp_segment30 in varchar2 default hr_api.g_varchar2,
1674: p_susp_concat_segments_in in varchar2 default hr_api.g_varchar2,
1675:
1668: p_susp_segment25 in varchar2 default hr_api.g_varchar2,
1669: p_susp_segment26 in varchar2 default hr_api.g_varchar2,
1670: p_susp_segment27 in varchar2 default hr_api.g_varchar2,
1671: p_susp_segment28 in varchar2 default hr_api.g_varchar2,
1672: p_susp_segment29 in varchar2 default hr_api.g_varchar2,
1673: p_susp_segment30 in varchar2 default hr_api.g_varchar2,
1674: p_susp_concat_segments_in in varchar2 default hr_api.g_varchar2,
1675:
1676: p_scl_segment1 in varchar2 default hr_api.g_varchar2,
1669: p_susp_segment26 in varchar2 default hr_api.g_varchar2,
1670: p_susp_segment27 in varchar2 default hr_api.g_varchar2,
1671: p_susp_segment28 in varchar2 default hr_api.g_varchar2,
1672: p_susp_segment29 in varchar2 default hr_api.g_varchar2,
1673: p_susp_segment30 in varchar2 default hr_api.g_varchar2,
1674: p_susp_concat_segments_in in varchar2 default hr_api.g_varchar2,
1675:
1676: p_scl_segment1 in varchar2 default hr_api.g_varchar2,
1677: p_scl_segment2 in varchar2 default hr_api.g_varchar2,
1670: p_susp_segment27 in varchar2 default hr_api.g_varchar2,
1671: p_susp_segment28 in varchar2 default hr_api.g_varchar2,
1672: p_susp_segment29 in varchar2 default hr_api.g_varchar2,
1673: p_susp_segment30 in varchar2 default hr_api.g_varchar2,
1674: p_susp_concat_segments_in in varchar2 default hr_api.g_varchar2,
1675:
1676: p_scl_segment1 in varchar2 default hr_api.g_varchar2,
1677: p_scl_segment2 in varchar2 default hr_api.g_varchar2,
1678: p_scl_segment3 in varchar2 default hr_api.g_varchar2,
1672: p_susp_segment29 in varchar2 default hr_api.g_varchar2,
1673: p_susp_segment30 in varchar2 default hr_api.g_varchar2,
1674: p_susp_concat_segments_in in varchar2 default hr_api.g_varchar2,
1675:
1676: p_scl_segment1 in varchar2 default hr_api.g_varchar2,
1677: p_scl_segment2 in varchar2 default hr_api.g_varchar2,
1678: p_scl_segment3 in varchar2 default hr_api.g_varchar2,
1679: p_scl_segment4 in varchar2 default hr_api.g_varchar2,
1680: p_scl_segment5 in varchar2 default hr_api.g_varchar2,
1673: p_susp_segment30 in varchar2 default hr_api.g_varchar2,
1674: p_susp_concat_segments_in in varchar2 default hr_api.g_varchar2,
1675:
1676: p_scl_segment1 in varchar2 default hr_api.g_varchar2,
1677: p_scl_segment2 in varchar2 default hr_api.g_varchar2,
1678: p_scl_segment3 in varchar2 default hr_api.g_varchar2,
1679: p_scl_segment4 in varchar2 default hr_api.g_varchar2,
1680: p_scl_segment5 in varchar2 default hr_api.g_varchar2,
1681: p_scl_segment6 in varchar2 default hr_api.g_varchar2,
1674: p_susp_concat_segments_in in varchar2 default hr_api.g_varchar2,
1675:
1676: p_scl_segment1 in varchar2 default hr_api.g_varchar2,
1677: p_scl_segment2 in varchar2 default hr_api.g_varchar2,
1678: p_scl_segment3 in varchar2 default hr_api.g_varchar2,
1679: p_scl_segment4 in varchar2 default hr_api.g_varchar2,
1680: p_scl_segment5 in varchar2 default hr_api.g_varchar2,
1681: p_scl_segment6 in varchar2 default hr_api.g_varchar2,
1682: p_scl_segment7 in varchar2 default hr_api.g_varchar2,
1675:
1676: p_scl_segment1 in varchar2 default hr_api.g_varchar2,
1677: p_scl_segment2 in varchar2 default hr_api.g_varchar2,
1678: p_scl_segment3 in varchar2 default hr_api.g_varchar2,
1679: p_scl_segment4 in varchar2 default hr_api.g_varchar2,
1680: p_scl_segment5 in varchar2 default hr_api.g_varchar2,
1681: p_scl_segment6 in varchar2 default hr_api.g_varchar2,
1682: p_scl_segment7 in varchar2 default hr_api.g_varchar2,
1683: p_scl_segment8 in varchar2 default hr_api.g_varchar2,
1676: p_scl_segment1 in varchar2 default hr_api.g_varchar2,
1677: p_scl_segment2 in varchar2 default hr_api.g_varchar2,
1678: p_scl_segment3 in varchar2 default hr_api.g_varchar2,
1679: p_scl_segment4 in varchar2 default hr_api.g_varchar2,
1680: p_scl_segment5 in varchar2 default hr_api.g_varchar2,
1681: p_scl_segment6 in varchar2 default hr_api.g_varchar2,
1682: p_scl_segment7 in varchar2 default hr_api.g_varchar2,
1683: p_scl_segment8 in varchar2 default hr_api.g_varchar2,
1684: p_scl_segment9 in varchar2 default hr_api.g_varchar2,
1677: p_scl_segment2 in varchar2 default hr_api.g_varchar2,
1678: p_scl_segment3 in varchar2 default hr_api.g_varchar2,
1679: p_scl_segment4 in varchar2 default hr_api.g_varchar2,
1680: p_scl_segment5 in varchar2 default hr_api.g_varchar2,
1681: p_scl_segment6 in varchar2 default hr_api.g_varchar2,
1682: p_scl_segment7 in varchar2 default hr_api.g_varchar2,
1683: p_scl_segment8 in varchar2 default hr_api.g_varchar2,
1684: p_scl_segment9 in varchar2 default hr_api.g_varchar2,
1685: p_scl_segment10 in varchar2 default hr_api.g_varchar2,
1678: p_scl_segment3 in varchar2 default hr_api.g_varchar2,
1679: p_scl_segment4 in varchar2 default hr_api.g_varchar2,
1680: p_scl_segment5 in varchar2 default hr_api.g_varchar2,
1681: p_scl_segment6 in varchar2 default hr_api.g_varchar2,
1682: p_scl_segment7 in varchar2 default hr_api.g_varchar2,
1683: p_scl_segment8 in varchar2 default hr_api.g_varchar2,
1684: p_scl_segment9 in varchar2 default hr_api.g_varchar2,
1685: p_scl_segment10 in varchar2 default hr_api.g_varchar2,
1686: p_scl_segment11 in varchar2 default hr_api.g_varchar2,
1679: p_scl_segment4 in varchar2 default hr_api.g_varchar2,
1680: p_scl_segment5 in varchar2 default hr_api.g_varchar2,
1681: p_scl_segment6 in varchar2 default hr_api.g_varchar2,
1682: p_scl_segment7 in varchar2 default hr_api.g_varchar2,
1683: p_scl_segment8 in varchar2 default hr_api.g_varchar2,
1684: p_scl_segment9 in varchar2 default hr_api.g_varchar2,
1685: p_scl_segment10 in varchar2 default hr_api.g_varchar2,
1686: p_scl_segment11 in varchar2 default hr_api.g_varchar2,
1687: p_scl_segment12 in varchar2 default hr_api.g_varchar2,
1680: p_scl_segment5 in varchar2 default hr_api.g_varchar2,
1681: p_scl_segment6 in varchar2 default hr_api.g_varchar2,
1682: p_scl_segment7 in varchar2 default hr_api.g_varchar2,
1683: p_scl_segment8 in varchar2 default hr_api.g_varchar2,
1684: p_scl_segment9 in varchar2 default hr_api.g_varchar2,
1685: p_scl_segment10 in varchar2 default hr_api.g_varchar2,
1686: p_scl_segment11 in varchar2 default hr_api.g_varchar2,
1687: p_scl_segment12 in varchar2 default hr_api.g_varchar2,
1688: p_scl_segment13 in varchar2 default hr_api.g_varchar2,
1681: p_scl_segment6 in varchar2 default hr_api.g_varchar2,
1682: p_scl_segment7 in varchar2 default hr_api.g_varchar2,
1683: p_scl_segment8 in varchar2 default hr_api.g_varchar2,
1684: p_scl_segment9 in varchar2 default hr_api.g_varchar2,
1685: p_scl_segment10 in varchar2 default hr_api.g_varchar2,
1686: p_scl_segment11 in varchar2 default hr_api.g_varchar2,
1687: p_scl_segment12 in varchar2 default hr_api.g_varchar2,
1688: p_scl_segment13 in varchar2 default hr_api.g_varchar2,
1689: p_scl_segment14 in varchar2 default hr_api.g_varchar2,
1682: p_scl_segment7 in varchar2 default hr_api.g_varchar2,
1683: p_scl_segment8 in varchar2 default hr_api.g_varchar2,
1684: p_scl_segment9 in varchar2 default hr_api.g_varchar2,
1685: p_scl_segment10 in varchar2 default hr_api.g_varchar2,
1686: p_scl_segment11 in varchar2 default hr_api.g_varchar2,
1687: p_scl_segment12 in varchar2 default hr_api.g_varchar2,
1688: p_scl_segment13 in varchar2 default hr_api.g_varchar2,
1689: p_scl_segment14 in varchar2 default hr_api.g_varchar2,
1690: p_scl_segment15 in varchar2 default hr_api.g_varchar2,
1683: p_scl_segment8 in varchar2 default hr_api.g_varchar2,
1684: p_scl_segment9 in varchar2 default hr_api.g_varchar2,
1685: p_scl_segment10 in varchar2 default hr_api.g_varchar2,
1686: p_scl_segment11 in varchar2 default hr_api.g_varchar2,
1687: p_scl_segment12 in varchar2 default hr_api.g_varchar2,
1688: p_scl_segment13 in varchar2 default hr_api.g_varchar2,
1689: p_scl_segment14 in varchar2 default hr_api.g_varchar2,
1690: p_scl_segment15 in varchar2 default hr_api.g_varchar2,
1691: p_scl_segment16 in varchar2 default hr_api.g_varchar2,
1684: p_scl_segment9 in varchar2 default hr_api.g_varchar2,
1685: p_scl_segment10 in varchar2 default hr_api.g_varchar2,
1686: p_scl_segment11 in varchar2 default hr_api.g_varchar2,
1687: p_scl_segment12 in varchar2 default hr_api.g_varchar2,
1688: p_scl_segment13 in varchar2 default hr_api.g_varchar2,
1689: p_scl_segment14 in varchar2 default hr_api.g_varchar2,
1690: p_scl_segment15 in varchar2 default hr_api.g_varchar2,
1691: p_scl_segment16 in varchar2 default hr_api.g_varchar2,
1692: p_scl_segment17 in varchar2 default hr_api.g_varchar2,
1685: p_scl_segment10 in varchar2 default hr_api.g_varchar2,
1686: p_scl_segment11 in varchar2 default hr_api.g_varchar2,
1687: p_scl_segment12 in varchar2 default hr_api.g_varchar2,
1688: p_scl_segment13 in varchar2 default hr_api.g_varchar2,
1689: p_scl_segment14 in varchar2 default hr_api.g_varchar2,
1690: p_scl_segment15 in varchar2 default hr_api.g_varchar2,
1691: p_scl_segment16 in varchar2 default hr_api.g_varchar2,
1692: p_scl_segment17 in varchar2 default hr_api.g_varchar2,
1693: p_scl_segment18 in varchar2 default hr_api.g_varchar2,
1686: p_scl_segment11 in varchar2 default hr_api.g_varchar2,
1687: p_scl_segment12 in varchar2 default hr_api.g_varchar2,
1688: p_scl_segment13 in varchar2 default hr_api.g_varchar2,
1689: p_scl_segment14 in varchar2 default hr_api.g_varchar2,
1690: p_scl_segment15 in varchar2 default hr_api.g_varchar2,
1691: p_scl_segment16 in varchar2 default hr_api.g_varchar2,
1692: p_scl_segment17 in varchar2 default hr_api.g_varchar2,
1693: p_scl_segment18 in varchar2 default hr_api.g_varchar2,
1694: p_scl_segment19 in varchar2 default hr_api.g_varchar2,
1687: p_scl_segment12 in varchar2 default hr_api.g_varchar2,
1688: p_scl_segment13 in varchar2 default hr_api.g_varchar2,
1689: p_scl_segment14 in varchar2 default hr_api.g_varchar2,
1690: p_scl_segment15 in varchar2 default hr_api.g_varchar2,
1691: p_scl_segment16 in varchar2 default hr_api.g_varchar2,
1692: p_scl_segment17 in varchar2 default hr_api.g_varchar2,
1693: p_scl_segment18 in varchar2 default hr_api.g_varchar2,
1694: p_scl_segment19 in varchar2 default hr_api.g_varchar2,
1695: p_scl_segment20 in varchar2 default hr_api.g_varchar2,
1688: p_scl_segment13 in varchar2 default hr_api.g_varchar2,
1689: p_scl_segment14 in varchar2 default hr_api.g_varchar2,
1690: p_scl_segment15 in varchar2 default hr_api.g_varchar2,
1691: p_scl_segment16 in varchar2 default hr_api.g_varchar2,
1692: p_scl_segment17 in varchar2 default hr_api.g_varchar2,
1693: p_scl_segment18 in varchar2 default hr_api.g_varchar2,
1694: p_scl_segment19 in varchar2 default hr_api.g_varchar2,
1695: p_scl_segment20 in varchar2 default hr_api.g_varchar2,
1696: p_scl_segment21 in varchar2 default hr_api.g_varchar2,
1689: p_scl_segment14 in varchar2 default hr_api.g_varchar2,
1690: p_scl_segment15 in varchar2 default hr_api.g_varchar2,
1691: p_scl_segment16 in varchar2 default hr_api.g_varchar2,
1692: p_scl_segment17 in varchar2 default hr_api.g_varchar2,
1693: p_scl_segment18 in varchar2 default hr_api.g_varchar2,
1694: p_scl_segment19 in varchar2 default hr_api.g_varchar2,
1695: p_scl_segment20 in varchar2 default hr_api.g_varchar2,
1696: p_scl_segment21 in varchar2 default hr_api.g_varchar2,
1697: p_scl_segment22 in varchar2 default hr_api.g_varchar2,
1690: p_scl_segment15 in varchar2 default hr_api.g_varchar2,
1691: p_scl_segment16 in varchar2 default hr_api.g_varchar2,
1692: p_scl_segment17 in varchar2 default hr_api.g_varchar2,
1693: p_scl_segment18 in varchar2 default hr_api.g_varchar2,
1694: p_scl_segment19 in varchar2 default hr_api.g_varchar2,
1695: p_scl_segment20 in varchar2 default hr_api.g_varchar2,
1696: p_scl_segment21 in varchar2 default hr_api.g_varchar2,
1697: p_scl_segment22 in varchar2 default hr_api.g_varchar2,
1698: p_scl_segment23 in varchar2 default hr_api.g_varchar2,
1691: p_scl_segment16 in varchar2 default hr_api.g_varchar2,
1692: p_scl_segment17 in varchar2 default hr_api.g_varchar2,
1693: p_scl_segment18 in varchar2 default hr_api.g_varchar2,
1694: p_scl_segment19 in varchar2 default hr_api.g_varchar2,
1695: p_scl_segment20 in varchar2 default hr_api.g_varchar2,
1696: p_scl_segment21 in varchar2 default hr_api.g_varchar2,
1697: p_scl_segment22 in varchar2 default hr_api.g_varchar2,
1698: p_scl_segment23 in varchar2 default hr_api.g_varchar2,
1699: p_scl_segment24 in varchar2 default hr_api.g_varchar2,
1692: p_scl_segment17 in varchar2 default hr_api.g_varchar2,
1693: p_scl_segment18 in varchar2 default hr_api.g_varchar2,
1694: p_scl_segment19 in varchar2 default hr_api.g_varchar2,
1695: p_scl_segment20 in varchar2 default hr_api.g_varchar2,
1696: p_scl_segment21 in varchar2 default hr_api.g_varchar2,
1697: p_scl_segment22 in varchar2 default hr_api.g_varchar2,
1698: p_scl_segment23 in varchar2 default hr_api.g_varchar2,
1699: p_scl_segment24 in varchar2 default hr_api.g_varchar2,
1700: p_scl_segment25 in varchar2 default hr_api.g_varchar2,
1693: p_scl_segment18 in varchar2 default hr_api.g_varchar2,
1694: p_scl_segment19 in varchar2 default hr_api.g_varchar2,
1695: p_scl_segment20 in varchar2 default hr_api.g_varchar2,
1696: p_scl_segment21 in varchar2 default hr_api.g_varchar2,
1697: p_scl_segment22 in varchar2 default hr_api.g_varchar2,
1698: p_scl_segment23 in varchar2 default hr_api.g_varchar2,
1699: p_scl_segment24 in varchar2 default hr_api.g_varchar2,
1700: p_scl_segment25 in varchar2 default hr_api.g_varchar2,
1701: p_scl_segment26 in varchar2 default hr_api.g_varchar2,
1694: p_scl_segment19 in varchar2 default hr_api.g_varchar2,
1695: p_scl_segment20 in varchar2 default hr_api.g_varchar2,
1696: p_scl_segment21 in varchar2 default hr_api.g_varchar2,
1697: p_scl_segment22 in varchar2 default hr_api.g_varchar2,
1698: p_scl_segment23 in varchar2 default hr_api.g_varchar2,
1699: p_scl_segment24 in varchar2 default hr_api.g_varchar2,
1700: p_scl_segment25 in varchar2 default hr_api.g_varchar2,
1701: p_scl_segment26 in varchar2 default hr_api.g_varchar2,
1702: p_scl_segment27 in varchar2 default hr_api.g_varchar2,
1695: p_scl_segment20 in varchar2 default hr_api.g_varchar2,
1696: p_scl_segment21 in varchar2 default hr_api.g_varchar2,
1697: p_scl_segment22 in varchar2 default hr_api.g_varchar2,
1698: p_scl_segment23 in varchar2 default hr_api.g_varchar2,
1699: p_scl_segment24 in varchar2 default hr_api.g_varchar2,
1700: p_scl_segment25 in varchar2 default hr_api.g_varchar2,
1701: p_scl_segment26 in varchar2 default hr_api.g_varchar2,
1702: p_scl_segment27 in varchar2 default hr_api.g_varchar2,
1703: p_scl_segment28 in varchar2 default hr_api.g_varchar2,
1696: p_scl_segment21 in varchar2 default hr_api.g_varchar2,
1697: p_scl_segment22 in varchar2 default hr_api.g_varchar2,
1698: p_scl_segment23 in varchar2 default hr_api.g_varchar2,
1699: p_scl_segment24 in varchar2 default hr_api.g_varchar2,
1700: p_scl_segment25 in varchar2 default hr_api.g_varchar2,
1701: p_scl_segment26 in varchar2 default hr_api.g_varchar2,
1702: p_scl_segment27 in varchar2 default hr_api.g_varchar2,
1703: p_scl_segment28 in varchar2 default hr_api.g_varchar2,
1704: p_scl_segment29 in varchar2 default hr_api.g_varchar2,
1697: p_scl_segment22 in varchar2 default hr_api.g_varchar2,
1698: p_scl_segment23 in varchar2 default hr_api.g_varchar2,
1699: p_scl_segment24 in varchar2 default hr_api.g_varchar2,
1700: p_scl_segment25 in varchar2 default hr_api.g_varchar2,
1701: p_scl_segment26 in varchar2 default hr_api.g_varchar2,
1702: p_scl_segment27 in varchar2 default hr_api.g_varchar2,
1703: p_scl_segment28 in varchar2 default hr_api.g_varchar2,
1704: p_scl_segment29 in varchar2 default hr_api.g_varchar2,
1705: p_scl_segment30 in varchar2 default hr_api.g_varchar2,
1698: p_scl_segment23 in varchar2 default hr_api.g_varchar2,
1699: p_scl_segment24 in varchar2 default hr_api.g_varchar2,
1700: p_scl_segment25 in varchar2 default hr_api.g_varchar2,
1701: p_scl_segment26 in varchar2 default hr_api.g_varchar2,
1702: p_scl_segment27 in varchar2 default hr_api.g_varchar2,
1703: p_scl_segment28 in varchar2 default hr_api.g_varchar2,
1704: p_scl_segment29 in varchar2 default hr_api.g_varchar2,
1705: p_scl_segment30 in varchar2 default hr_api.g_varchar2,
1706: p_scl_concat_segments_in in varchar2 default hr_api.g_varchar2,
1699: p_scl_segment24 in varchar2 default hr_api.g_varchar2,
1700: p_scl_segment25 in varchar2 default hr_api.g_varchar2,
1701: p_scl_segment26 in varchar2 default hr_api.g_varchar2,
1702: p_scl_segment27 in varchar2 default hr_api.g_varchar2,
1703: p_scl_segment28 in varchar2 default hr_api.g_varchar2,
1704: p_scl_segment29 in varchar2 default hr_api.g_varchar2,
1705: p_scl_segment30 in varchar2 default hr_api.g_varchar2,
1706: p_scl_concat_segments_in in varchar2 default hr_api.g_varchar2,
1707:
1700: p_scl_segment25 in varchar2 default hr_api.g_varchar2,
1701: p_scl_segment26 in varchar2 default hr_api.g_varchar2,
1702: p_scl_segment27 in varchar2 default hr_api.g_varchar2,
1703: p_scl_segment28 in varchar2 default hr_api.g_varchar2,
1704: p_scl_segment29 in varchar2 default hr_api.g_varchar2,
1705: p_scl_segment30 in varchar2 default hr_api.g_varchar2,
1706: p_scl_concat_segments_in in varchar2 default hr_api.g_varchar2,
1707:
1708: p_workload_shifting_level in varchar2 default hr_api.g_varchar2,
1701: p_scl_segment26 in varchar2 default hr_api.g_varchar2,
1702: p_scl_segment27 in varchar2 default hr_api.g_varchar2,
1703: p_scl_segment28 in varchar2 default hr_api.g_varchar2,
1704: p_scl_segment29 in varchar2 default hr_api.g_varchar2,
1705: p_scl_segment30 in varchar2 default hr_api.g_varchar2,
1706: p_scl_concat_segments_in in varchar2 default hr_api.g_varchar2,
1707:
1708: p_workload_shifting_level in varchar2 default hr_api.g_varchar2,
1709: p_payslip_view_date_offset in number default hr_api.g_number,
1702: p_scl_segment27 in varchar2 default hr_api.g_varchar2,
1703: p_scl_segment28 in varchar2 default hr_api.g_varchar2,
1704: p_scl_segment29 in varchar2 default hr_api.g_varchar2,
1705: p_scl_segment30 in varchar2 default hr_api.g_varchar2,
1706: p_scl_concat_segments_in in varchar2 default hr_api.g_varchar2,
1707:
1708: p_workload_shifting_level in varchar2 default hr_api.g_varchar2,
1709: p_payslip_view_date_offset in number default hr_api.g_number,
1710:
1704: p_scl_segment29 in varchar2 default hr_api.g_varchar2,
1705: p_scl_segment30 in varchar2 default hr_api.g_varchar2,
1706: p_scl_concat_segments_in in varchar2 default hr_api.g_varchar2,
1707:
1708: p_workload_shifting_level in varchar2 default hr_api.g_varchar2,
1709: p_payslip_view_date_offset in number default hr_api.g_number,
1710:
1711: p_payroll_id in out nocopy number,
1712: p_object_version_number in out nocopy number,
1705: p_scl_segment30 in varchar2 default hr_api.g_varchar2,
1706: p_scl_concat_segments_in in varchar2 default hr_api.g_varchar2,
1707:
1708: p_workload_shifting_level in varchar2 default hr_api.g_varchar2,
1709: p_payslip_view_date_offset in number default hr_api.g_number,
1710:
1711: p_payroll_id in out nocopy number,
1712: p_object_version_number in out nocopy number,
1713:
1736: l_cost_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
1737: l_susp_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
1738: l_scl_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
1739: l_business_group_id pay_all_payrolls_f.business_group_id%TYPE;
1740: l_prl_information_category pay_all_payrolls_f.prl_information_category%TYPE := hr_api.g_varchar2;
1741: l_legislation_code varchar2(150);
1742:
1743: l_cost_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;
1744: l_susp_concat_segments PAY_COST_ALLOCATION_KEYFLEX.concatenated_segments%TYPE ;
1866:
1867: --
1868: --Get the Business Group id from the payroll id.
1869: --
1870: if(p_consolidation_set_id = hr_api.g_number) then
1871: --
1872: open csr_get_bg_grp(l_payroll_id);
1873: fetch csr_get_bg_grp into l_business_group_id;
1874: close csr_get_bg_grp;
1879:
1880: --
1881: --Get the Legislation code.
1882: --
1883: l_legislation_code := hr_api.return_legislation_code(l_business_group_id);
1884:
1885: --
1886: -- Validate the business group id.
1887: --
1884:
1885: --
1886: -- Validate the business group id.
1887: --
1888: hr_api.validate_bus_grp_id
1889: (p_business_group_id => L_business_group_id
1890: ,p_associated_column1 => 'PAY_ALL_PAYROLLS_F'
1891: || '.BUSINESS_GROUP_ID');
1892:
1896: --Checking whether the specified cost allocation kff ID is there.
1897: --If it is not there, it will raise an error.
1898: --
1899: if (( p_cost_alloc_keyflex_id_in is not null )
1900: and (p_cost_alloc_keyflex_id_in <> hr_api.g_number)) then
1901: --
1902: open csr_cost_alloc_exists(p_cost_alloc_keyflex_id_in);
1903: fetch csr_cost_alloc_exists into l_dummy;
1904: if (csr_cost_alloc_exists%NOTFOUND) then
1917: --Checking whether the specified suspence account kff ID is there.
1918: --If it is not there, it will raise an error.
1919: --
1920: if((p_susp_account_keyflex_id_in is not null)
1921: and (p_susp_account_keyflex_id_in <> hr_api.g_number)) then
1922: open csr_cost_alloc_exists(p_susp_account_keyflex_id_in);
1923: fetch csr_cost_alloc_exists into l_dummy;
1924: if (csr_cost_alloc_exists%NOTFOUND) then
1925: --
1938: --Checking whether the specified soft coding kff ID is there.
1939: --If it is not there, it will raise an error.
1940: --
1941: if((p_soft_coding_keyflex_id_in is not null)
1942: and (p_soft_coding_keyflex_id_in <>hr_api.g_number))then
1943: --
1944: open csr_soft_coding_exists(p_soft_coding_keyflex_id_in);
1945: fetch csr_soft_coding_exists into l_dummy;
1946: if (csr_soft_coding_exists%NOTFOUND) then
2129:
2130: );
2131:
2132: exception
2133: when hr_api.cannot_find_prog_unit then
2134: hr_api.cannot_find_prog_unit_error
2135: (p_module_name => 'update_payroll'
2136: ,p_hook_type => 'BP');
2137: --
2130: );
2131:
2132: exception
2133: when hr_api.cannot_find_prog_unit then
2134: hr_api.cannot_find_prog_unit_error
2135: (p_module_name => 'update_payroll'
2136: ,p_hook_type => 'BP');
2137: --
2138: end;
2136: ,p_hook_type => 'BP');
2137: --
2138: end;
2139:
2140: if (p_cost_alloc_keyflex_id_in = hr_api.g_number) and
2141: (p_cost_segment1 <> hr_api.g_varchar2 or p_cost_segment2 <> hr_api.g_varchar2 or
2142: p_cost_segment3 <> hr_api.g_varchar2 or p_cost_segment4 <> hr_api.g_varchar2 or
2143: p_cost_segment5 <> hr_api.g_varchar2 or p_cost_segment6 <> hr_api.g_varchar2 or
2144: p_cost_segment7 <> hr_api.g_varchar2 or p_cost_segment8 <> hr_api.g_varchar2 or
2137: --
2138: end;
2139:
2140: if (p_cost_alloc_keyflex_id_in = hr_api.g_number) and
2141: (p_cost_segment1 <> hr_api.g_varchar2 or p_cost_segment2 <> hr_api.g_varchar2 or
2142: p_cost_segment3 <> hr_api.g_varchar2 or p_cost_segment4 <> hr_api.g_varchar2 or
2143: p_cost_segment5 <> hr_api.g_varchar2 or p_cost_segment6 <> hr_api.g_varchar2 or
2144: p_cost_segment7 <> hr_api.g_varchar2 or p_cost_segment8 <> hr_api.g_varchar2 or
2145: p_cost_segment9 <> hr_api.g_varchar2 or p_cost_segment10 <> hr_api.g_varchar2 or
2138: end;
2139:
2140: if (p_cost_alloc_keyflex_id_in = hr_api.g_number) and
2141: (p_cost_segment1 <> hr_api.g_varchar2 or p_cost_segment2 <> hr_api.g_varchar2 or
2142: p_cost_segment3 <> hr_api.g_varchar2 or p_cost_segment4 <> hr_api.g_varchar2 or
2143: p_cost_segment5 <> hr_api.g_varchar2 or p_cost_segment6 <> hr_api.g_varchar2 or
2144: p_cost_segment7 <> hr_api.g_varchar2 or p_cost_segment8 <> hr_api.g_varchar2 or
2145: p_cost_segment9 <> hr_api.g_varchar2 or p_cost_segment10 <> hr_api.g_varchar2 or
2146: p_cost_segment11 <> hr_api.g_varchar2 or p_cost_segment12 <> hr_api.g_varchar2 or
2139:
2140: if (p_cost_alloc_keyflex_id_in = hr_api.g_number) and
2141: (p_cost_segment1 <> hr_api.g_varchar2 or p_cost_segment2 <> hr_api.g_varchar2 or
2142: p_cost_segment3 <> hr_api.g_varchar2 or p_cost_segment4 <> hr_api.g_varchar2 or
2143: p_cost_segment5 <> hr_api.g_varchar2 or p_cost_segment6 <> hr_api.g_varchar2 or
2144: p_cost_segment7 <> hr_api.g_varchar2 or p_cost_segment8 <> hr_api.g_varchar2 or
2145: p_cost_segment9 <> hr_api.g_varchar2 or p_cost_segment10 <> hr_api.g_varchar2 or
2146: p_cost_segment11 <> hr_api.g_varchar2 or p_cost_segment12 <> hr_api.g_varchar2 or
2147: p_cost_segment13 <> hr_api.g_varchar2 or p_cost_segment14 <> hr_api.g_varchar2 or
2140: if (p_cost_alloc_keyflex_id_in = hr_api.g_number) and
2141: (p_cost_segment1 <> hr_api.g_varchar2 or p_cost_segment2 <> hr_api.g_varchar2 or
2142: p_cost_segment3 <> hr_api.g_varchar2 or p_cost_segment4 <> hr_api.g_varchar2 or
2143: p_cost_segment5 <> hr_api.g_varchar2 or p_cost_segment6 <> hr_api.g_varchar2 or
2144: p_cost_segment7 <> hr_api.g_varchar2 or p_cost_segment8 <> hr_api.g_varchar2 or
2145: p_cost_segment9 <> hr_api.g_varchar2 or p_cost_segment10 <> hr_api.g_varchar2 or
2146: p_cost_segment11 <> hr_api.g_varchar2 or p_cost_segment12 <> hr_api.g_varchar2 or
2147: p_cost_segment13 <> hr_api.g_varchar2 or p_cost_segment14 <> hr_api.g_varchar2 or
2148: p_cost_segment15 <> hr_api.g_varchar2 or p_cost_segment16 <> hr_api.g_varchar2 or
2141: (p_cost_segment1 <> hr_api.g_varchar2 or p_cost_segment2 <> hr_api.g_varchar2 or
2142: p_cost_segment3 <> hr_api.g_varchar2 or p_cost_segment4 <> hr_api.g_varchar2 or
2143: p_cost_segment5 <> hr_api.g_varchar2 or p_cost_segment6 <> hr_api.g_varchar2 or
2144: p_cost_segment7 <> hr_api.g_varchar2 or p_cost_segment8 <> hr_api.g_varchar2 or
2145: p_cost_segment9 <> hr_api.g_varchar2 or p_cost_segment10 <> hr_api.g_varchar2 or
2146: p_cost_segment11 <> hr_api.g_varchar2 or p_cost_segment12 <> hr_api.g_varchar2 or
2147: p_cost_segment13 <> hr_api.g_varchar2 or p_cost_segment14 <> hr_api.g_varchar2 or
2148: p_cost_segment15 <> hr_api.g_varchar2 or p_cost_segment16 <> hr_api.g_varchar2 or
2149: p_cost_segment17 <> hr_api.g_varchar2 or p_cost_segment18 <> hr_api.g_varchar2 or
2142: p_cost_segment3 <> hr_api.g_varchar2 or p_cost_segment4 <> hr_api.g_varchar2 or
2143: p_cost_segment5 <> hr_api.g_varchar2 or p_cost_segment6 <> hr_api.g_varchar2 or
2144: p_cost_segment7 <> hr_api.g_varchar2 or p_cost_segment8 <> hr_api.g_varchar2 or
2145: p_cost_segment9 <> hr_api.g_varchar2 or p_cost_segment10 <> hr_api.g_varchar2 or
2146: p_cost_segment11 <> hr_api.g_varchar2 or p_cost_segment12 <> hr_api.g_varchar2 or
2147: p_cost_segment13 <> hr_api.g_varchar2 or p_cost_segment14 <> hr_api.g_varchar2 or
2148: p_cost_segment15 <> hr_api.g_varchar2 or p_cost_segment16 <> hr_api.g_varchar2 or
2149: p_cost_segment17 <> hr_api.g_varchar2 or p_cost_segment18 <> hr_api.g_varchar2 or
2150: p_cost_segment19 <> hr_api.g_varchar2 or p_cost_segment20 <> hr_api.g_varchar2 or
2143: p_cost_segment5 <> hr_api.g_varchar2 or p_cost_segment6 <> hr_api.g_varchar2 or
2144: p_cost_segment7 <> hr_api.g_varchar2 or p_cost_segment8 <> hr_api.g_varchar2 or
2145: p_cost_segment9 <> hr_api.g_varchar2 or p_cost_segment10 <> hr_api.g_varchar2 or
2146: p_cost_segment11 <> hr_api.g_varchar2 or p_cost_segment12 <> hr_api.g_varchar2 or
2147: p_cost_segment13 <> hr_api.g_varchar2 or p_cost_segment14 <> hr_api.g_varchar2 or
2148: p_cost_segment15 <> hr_api.g_varchar2 or p_cost_segment16 <> hr_api.g_varchar2 or
2149: p_cost_segment17 <> hr_api.g_varchar2 or p_cost_segment18 <> hr_api.g_varchar2 or
2150: p_cost_segment19 <> hr_api.g_varchar2 or p_cost_segment20 <> hr_api.g_varchar2 or
2151: p_cost_segment21 <> hr_api.g_varchar2 or p_cost_segment22 <> hr_api.g_varchar2 or
2144: p_cost_segment7 <> hr_api.g_varchar2 or p_cost_segment8 <> hr_api.g_varchar2 or
2145: p_cost_segment9 <> hr_api.g_varchar2 or p_cost_segment10 <> hr_api.g_varchar2 or
2146: p_cost_segment11 <> hr_api.g_varchar2 or p_cost_segment12 <> hr_api.g_varchar2 or
2147: p_cost_segment13 <> hr_api.g_varchar2 or p_cost_segment14 <> hr_api.g_varchar2 or
2148: p_cost_segment15 <> hr_api.g_varchar2 or p_cost_segment16 <> hr_api.g_varchar2 or
2149: p_cost_segment17 <> hr_api.g_varchar2 or p_cost_segment18 <> hr_api.g_varchar2 or
2150: p_cost_segment19 <> hr_api.g_varchar2 or p_cost_segment20 <> hr_api.g_varchar2 or
2151: p_cost_segment21 <> hr_api.g_varchar2 or p_cost_segment22 <> hr_api.g_varchar2 or
2152: p_cost_segment23 <> hr_api.g_varchar2 or p_cost_segment24 <> hr_api.g_varchar2 or
2145: p_cost_segment9 <> hr_api.g_varchar2 or p_cost_segment10 <> hr_api.g_varchar2 or
2146: p_cost_segment11 <> hr_api.g_varchar2 or p_cost_segment12 <> hr_api.g_varchar2 or
2147: p_cost_segment13 <> hr_api.g_varchar2 or p_cost_segment14 <> hr_api.g_varchar2 or
2148: p_cost_segment15 <> hr_api.g_varchar2 or p_cost_segment16 <> hr_api.g_varchar2 or
2149: p_cost_segment17 <> hr_api.g_varchar2 or p_cost_segment18 <> hr_api.g_varchar2 or
2150: p_cost_segment19 <> hr_api.g_varchar2 or p_cost_segment20 <> hr_api.g_varchar2 or
2151: p_cost_segment21 <> hr_api.g_varchar2 or p_cost_segment22 <> hr_api.g_varchar2 or
2152: p_cost_segment23 <> hr_api.g_varchar2 or p_cost_segment24 <> hr_api.g_varchar2 or
2153: p_cost_segment25 <> hr_api.g_varchar2 or p_cost_segment26 <> hr_api.g_varchar2 or
2146: p_cost_segment11 <> hr_api.g_varchar2 or p_cost_segment12 <> hr_api.g_varchar2 or
2147: p_cost_segment13 <> hr_api.g_varchar2 or p_cost_segment14 <> hr_api.g_varchar2 or
2148: p_cost_segment15 <> hr_api.g_varchar2 or p_cost_segment16 <> hr_api.g_varchar2 or
2149: p_cost_segment17 <> hr_api.g_varchar2 or p_cost_segment18 <> hr_api.g_varchar2 or
2150: p_cost_segment19 <> hr_api.g_varchar2 or p_cost_segment20 <> hr_api.g_varchar2 or
2151: p_cost_segment21 <> hr_api.g_varchar2 or p_cost_segment22 <> hr_api.g_varchar2 or
2152: p_cost_segment23 <> hr_api.g_varchar2 or p_cost_segment24 <> hr_api.g_varchar2 or
2153: p_cost_segment25 <> hr_api.g_varchar2 or p_cost_segment26 <> hr_api.g_varchar2 or
2154: p_cost_segment27 <> hr_api.g_varchar2 or p_cost_segment28 <> hr_api.g_varchar2 or
2147: p_cost_segment13 <> hr_api.g_varchar2 or p_cost_segment14 <> hr_api.g_varchar2 or
2148: p_cost_segment15 <> hr_api.g_varchar2 or p_cost_segment16 <> hr_api.g_varchar2 or
2149: p_cost_segment17 <> hr_api.g_varchar2 or p_cost_segment18 <> hr_api.g_varchar2 or
2150: p_cost_segment19 <> hr_api.g_varchar2 or p_cost_segment20 <> hr_api.g_varchar2 or
2151: p_cost_segment21 <> hr_api.g_varchar2 or p_cost_segment22 <> hr_api.g_varchar2 or
2152: p_cost_segment23 <> hr_api.g_varchar2 or p_cost_segment24 <> hr_api.g_varchar2 or
2153: p_cost_segment25 <> hr_api.g_varchar2 or p_cost_segment26 <> hr_api.g_varchar2 or
2154: p_cost_segment27 <> hr_api.g_varchar2 or p_cost_segment28 <> hr_api.g_varchar2 or
2155: p_cost_segment29 <> hr_api.g_varchar2 or p_cost_segment30 <> hr_api.g_varchar2 or
2148: p_cost_segment15 <> hr_api.g_varchar2 or p_cost_segment16 <> hr_api.g_varchar2 or
2149: p_cost_segment17 <> hr_api.g_varchar2 or p_cost_segment18 <> hr_api.g_varchar2 or
2150: p_cost_segment19 <> hr_api.g_varchar2 or p_cost_segment20 <> hr_api.g_varchar2 or
2151: p_cost_segment21 <> hr_api.g_varchar2 or p_cost_segment22 <> hr_api.g_varchar2 or
2152: p_cost_segment23 <> hr_api.g_varchar2 or p_cost_segment24 <> hr_api.g_varchar2 or
2153: p_cost_segment25 <> hr_api.g_varchar2 or p_cost_segment26 <> hr_api.g_varchar2 or
2154: p_cost_segment27 <> hr_api.g_varchar2 or p_cost_segment28 <> hr_api.g_varchar2 or
2155: p_cost_segment29 <> hr_api.g_varchar2 or p_cost_segment30 <> hr_api.g_varchar2 or
2156: p_cost_concat_segments_in <> hr_api.g_varchar2)
2149: p_cost_segment17 <> hr_api.g_varchar2 or p_cost_segment18 <> hr_api.g_varchar2 or
2150: p_cost_segment19 <> hr_api.g_varchar2 or p_cost_segment20 <> hr_api.g_varchar2 or
2151: p_cost_segment21 <> hr_api.g_varchar2 or p_cost_segment22 <> hr_api.g_varchar2 or
2152: p_cost_segment23 <> hr_api.g_varchar2 or p_cost_segment24 <> hr_api.g_varchar2 or
2153: p_cost_segment25 <> hr_api.g_varchar2 or p_cost_segment26 <> hr_api.g_varchar2 or
2154: p_cost_segment27 <> hr_api.g_varchar2 or p_cost_segment28 <> hr_api.g_varchar2 or
2155: p_cost_segment29 <> hr_api.g_varchar2 or p_cost_segment30 <> hr_api.g_varchar2 or
2156: p_cost_concat_segments_in <> hr_api.g_varchar2)
2157: then
2150: p_cost_segment19 <> hr_api.g_varchar2 or p_cost_segment20 <> hr_api.g_varchar2 or
2151: p_cost_segment21 <> hr_api.g_varchar2 or p_cost_segment22 <> hr_api.g_varchar2 or
2152: p_cost_segment23 <> hr_api.g_varchar2 or p_cost_segment24 <> hr_api.g_varchar2 or
2153: p_cost_segment25 <> hr_api.g_varchar2 or p_cost_segment26 <> hr_api.g_varchar2 or
2154: p_cost_segment27 <> hr_api.g_varchar2 or p_cost_segment28 <> hr_api.g_varchar2 or
2155: p_cost_segment29 <> hr_api.g_varchar2 or p_cost_segment30 <> hr_api.g_varchar2 or
2156: p_cost_concat_segments_in <> hr_api.g_varchar2)
2157: then
2158: --
2151: p_cost_segment21 <> hr_api.g_varchar2 or p_cost_segment22 <> hr_api.g_varchar2 or
2152: p_cost_segment23 <> hr_api.g_varchar2 or p_cost_segment24 <> hr_api.g_varchar2 or
2153: p_cost_segment25 <> hr_api.g_varchar2 or p_cost_segment26 <> hr_api.g_varchar2 or
2154: p_cost_segment27 <> hr_api.g_varchar2 or p_cost_segment28 <> hr_api.g_varchar2 or
2155: p_cost_segment29 <> hr_api.g_varchar2 or p_cost_segment30 <> hr_api.g_varchar2 or
2156: p_cost_concat_segments_in <> hr_api.g_varchar2)
2157: then
2158: --
2159: --
2152: p_cost_segment23 <> hr_api.g_varchar2 or p_cost_segment24 <> hr_api.g_varchar2 or
2153: p_cost_segment25 <> hr_api.g_varchar2 or p_cost_segment26 <> hr_api.g_varchar2 or
2154: p_cost_segment27 <> hr_api.g_varchar2 or p_cost_segment28 <> hr_api.g_varchar2 or
2155: p_cost_segment29 <> hr_api.g_varchar2 or p_cost_segment30 <> hr_api.g_varchar2 or
2156: p_cost_concat_segments_in <> hr_api.g_varchar2)
2157: then
2158: --
2159: --
2160: --Retrieve the COSTING keyflex ID and structure identifier.
2224: p_cost_alloc_keyflex_id_out := l_cost_allocation_keyflex_id;
2225: --
2226: end if;
2227:
2228: if (p_susp_account_keyflex_id_in = hr_api.g_number) and
2229: (p_susp_segment1 <> hr_api.g_varchar2 or p_susp_segment2 <> hr_api.g_varchar2 or
2230: p_susp_segment3 <> hr_api.g_varchar2 or p_susp_segment4 <> hr_api.g_varchar2 or
2231: p_susp_segment5 <> hr_api.g_varchar2 or p_susp_segment6 <> hr_api.g_varchar2 or
2232: p_susp_segment7 <> hr_api.g_varchar2 or p_susp_segment8 <> hr_api.g_varchar2 or
2225: --
2226: end if;
2227:
2228: if (p_susp_account_keyflex_id_in = hr_api.g_number) and
2229: (p_susp_segment1 <> hr_api.g_varchar2 or p_susp_segment2 <> hr_api.g_varchar2 or
2230: p_susp_segment3 <> hr_api.g_varchar2 or p_susp_segment4 <> hr_api.g_varchar2 or
2231: p_susp_segment5 <> hr_api.g_varchar2 or p_susp_segment6 <> hr_api.g_varchar2 or
2232: p_susp_segment7 <> hr_api.g_varchar2 or p_susp_segment8 <> hr_api.g_varchar2 or
2233: p_susp_segment9 <> hr_api.g_varchar2 or p_susp_segment10 <> hr_api.g_varchar2 or
2226: end if;
2227:
2228: if (p_susp_account_keyflex_id_in = hr_api.g_number) and
2229: (p_susp_segment1 <> hr_api.g_varchar2 or p_susp_segment2 <> hr_api.g_varchar2 or
2230: p_susp_segment3 <> hr_api.g_varchar2 or p_susp_segment4 <> hr_api.g_varchar2 or
2231: p_susp_segment5 <> hr_api.g_varchar2 or p_susp_segment6 <> hr_api.g_varchar2 or
2232: p_susp_segment7 <> hr_api.g_varchar2 or p_susp_segment8 <> hr_api.g_varchar2 or
2233: p_susp_segment9 <> hr_api.g_varchar2 or p_susp_segment10 <> hr_api.g_varchar2 or
2234: p_susp_segment11 <> hr_api.g_varchar2 or p_susp_segment12 <> hr_api.g_varchar2 or
2227:
2228: if (p_susp_account_keyflex_id_in = hr_api.g_number) and
2229: (p_susp_segment1 <> hr_api.g_varchar2 or p_susp_segment2 <> hr_api.g_varchar2 or
2230: p_susp_segment3 <> hr_api.g_varchar2 or p_susp_segment4 <> hr_api.g_varchar2 or
2231: p_susp_segment5 <> hr_api.g_varchar2 or p_susp_segment6 <> hr_api.g_varchar2 or
2232: p_susp_segment7 <> hr_api.g_varchar2 or p_susp_segment8 <> hr_api.g_varchar2 or
2233: p_susp_segment9 <> hr_api.g_varchar2 or p_susp_segment10 <> hr_api.g_varchar2 or
2234: p_susp_segment11 <> hr_api.g_varchar2 or p_susp_segment12 <> hr_api.g_varchar2 or
2235: p_susp_segment13 <> hr_api.g_varchar2 or p_susp_segment14 <> hr_api.g_varchar2 or
2228: if (p_susp_account_keyflex_id_in = hr_api.g_number) and
2229: (p_susp_segment1 <> hr_api.g_varchar2 or p_susp_segment2 <> hr_api.g_varchar2 or
2230: p_susp_segment3 <> hr_api.g_varchar2 or p_susp_segment4 <> hr_api.g_varchar2 or
2231: p_susp_segment5 <> hr_api.g_varchar2 or p_susp_segment6 <> hr_api.g_varchar2 or
2232: p_susp_segment7 <> hr_api.g_varchar2 or p_susp_segment8 <> hr_api.g_varchar2 or
2233: p_susp_segment9 <> hr_api.g_varchar2 or p_susp_segment10 <> hr_api.g_varchar2 or
2234: p_susp_segment11 <> hr_api.g_varchar2 or p_susp_segment12 <> hr_api.g_varchar2 or
2235: p_susp_segment13 <> hr_api.g_varchar2 or p_susp_segment14 <> hr_api.g_varchar2 or
2236: p_susp_segment15 <> hr_api.g_varchar2 or p_susp_segment16 <> hr_api.g_varchar2 or
2229: (p_susp_segment1 <> hr_api.g_varchar2 or p_susp_segment2 <> hr_api.g_varchar2 or
2230: p_susp_segment3 <> hr_api.g_varchar2 or p_susp_segment4 <> hr_api.g_varchar2 or
2231: p_susp_segment5 <> hr_api.g_varchar2 or p_susp_segment6 <> hr_api.g_varchar2 or
2232: p_susp_segment7 <> hr_api.g_varchar2 or p_susp_segment8 <> hr_api.g_varchar2 or
2233: p_susp_segment9 <> hr_api.g_varchar2 or p_susp_segment10 <> hr_api.g_varchar2 or
2234: p_susp_segment11 <> hr_api.g_varchar2 or p_susp_segment12 <> hr_api.g_varchar2 or
2235: p_susp_segment13 <> hr_api.g_varchar2 or p_susp_segment14 <> hr_api.g_varchar2 or
2236: p_susp_segment15 <> hr_api.g_varchar2 or p_susp_segment16 <> hr_api.g_varchar2 or
2237: p_susp_segment17 <> hr_api.g_varchar2 or p_susp_segment18 <> hr_api.g_varchar2 or
2230: p_susp_segment3 <> hr_api.g_varchar2 or p_susp_segment4 <> hr_api.g_varchar2 or
2231: p_susp_segment5 <> hr_api.g_varchar2 or p_susp_segment6 <> hr_api.g_varchar2 or
2232: p_susp_segment7 <> hr_api.g_varchar2 or p_susp_segment8 <> hr_api.g_varchar2 or
2233: p_susp_segment9 <> hr_api.g_varchar2 or p_susp_segment10 <> hr_api.g_varchar2 or
2234: p_susp_segment11 <> hr_api.g_varchar2 or p_susp_segment12 <> hr_api.g_varchar2 or
2235: p_susp_segment13 <> hr_api.g_varchar2 or p_susp_segment14 <> hr_api.g_varchar2 or
2236: p_susp_segment15 <> hr_api.g_varchar2 or p_susp_segment16 <> hr_api.g_varchar2 or
2237: p_susp_segment17 <> hr_api.g_varchar2 or p_susp_segment18 <> hr_api.g_varchar2 or
2238: p_susp_segment19 <> hr_api.g_varchar2 or p_susp_segment20 <> hr_api.g_varchar2 or
2231: p_susp_segment5 <> hr_api.g_varchar2 or p_susp_segment6 <> hr_api.g_varchar2 or
2232: p_susp_segment7 <> hr_api.g_varchar2 or p_susp_segment8 <> hr_api.g_varchar2 or
2233: p_susp_segment9 <> hr_api.g_varchar2 or p_susp_segment10 <> hr_api.g_varchar2 or
2234: p_susp_segment11 <> hr_api.g_varchar2 or p_susp_segment12 <> hr_api.g_varchar2 or
2235: p_susp_segment13 <> hr_api.g_varchar2 or p_susp_segment14 <> hr_api.g_varchar2 or
2236: p_susp_segment15 <> hr_api.g_varchar2 or p_susp_segment16 <> hr_api.g_varchar2 or
2237: p_susp_segment17 <> hr_api.g_varchar2 or p_susp_segment18 <> hr_api.g_varchar2 or
2238: p_susp_segment19 <> hr_api.g_varchar2 or p_susp_segment20 <> hr_api.g_varchar2 or
2239: p_susp_segment21 <> hr_api.g_varchar2 or p_susp_segment22 <> hr_api.g_varchar2 or
2232: p_susp_segment7 <> hr_api.g_varchar2 or p_susp_segment8 <> hr_api.g_varchar2 or
2233: p_susp_segment9 <> hr_api.g_varchar2 or p_susp_segment10 <> hr_api.g_varchar2 or
2234: p_susp_segment11 <> hr_api.g_varchar2 or p_susp_segment12 <> hr_api.g_varchar2 or
2235: p_susp_segment13 <> hr_api.g_varchar2 or p_susp_segment14 <> hr_api.g_varchar2 or
2236: p_susp_segment15 <> hr_api.g_varchar2 or p_susp_segment16 <> hr_api.g_varchar2 or
2237: p_susp_segment17 <> hr_api.g_varchar2 or p_susp_segment18 <> hr_api.g_varchar2 or
2238: p_susp_segment19 <> hr_api.g_varchar2 or p_susp_segment20 <> hr_api.g_varchar2 or
2239: p_susp_segment21 <> hr_api.g_varchar2 or p_susp_segment22 <> hr_api.g_varchar2 or
2240: p_susp_segment23 <> hr_api.g_varchar2 or p_susp_segment24 <> hr_api.g_varchar2 or
2233: p_susp_segment9 <> hr_api.g_varchar2 or p_susp_segment10 <> hr_api.g_varchar2 or
2234: p_susp_segment11 <> hr_api.g_varchar2 or p_susp_segment12 <> hr_api.g_varchar2 or
2235: p_susp_segment13 <> hr_api.g_varchar2 or p_susp_segment14 <> hr_api.g_varchar2 or
2236: p_susp_segment15 <> hr_api.g_varchar2 or p_susp_segment16 <> hr_api.g_varchar2 or
2237: p_susp_segment17 <> hr_api.g_varchar2 or p_susp_segment18 <> hr_api.g_varchar2 or
2238: p_susp_segment19 <> hr_api.g_varchar2 or p_susp_segment20 <> hr_api.g_varchar2 or
2239: p_susp_segment21 <> hr_api.g_varchar2 or p_susp_segment22 <> hr_api.g_varchar2 or
2240: p_susp_segment23 <> hr_api.g_varchar2 or p_susp_segment24 <> hr_api.g_varchar2 or
2241: p_susp_segment25 <> hr_api.g_varchar2 or p_susp_segment26 <> hr_api.g_varchar2 or
2234: p_susp_segment11 <> hr_api.g_varchar2 or p_susp_segment12 <> hr_api.g_varchar2 or
2235: p_susp_segment13 <> hr_api.g_varchar2 or p_susp_segment14 <> hr_api.g_varchar2 or
2236: p_susp_segment15 <> hr_api.g_varchar2 or p_susp_segment16 <> hr_api.g_varchar2 or
2237: p_susp_segment17 <> hr_api.g_varchar2 or p_susp_segment18 <> hr_api.g_varchar2 or
2238: p_susp_segment19 <> hr_api.g_varchar2 or p_susp_segment20 <> hr_api.g_varchar2 or
2239: p_susp_segment21 <> hr_api.g_varchar2 or p_susp_segment22 <> hr_api.g_varchar2 or
2240: p_susp_segment23 <> hr_api.g_varchar2 or p_susp_segment24 <> hr_api.g_varchar2 or
2241: p_susp_segment25 <> hr_api.g_varchar2 or p_susp_segment26 <> hr_api.g_varchar2 or
2242: p_susp_segment27 <> hr_api.g_varchar2 or p_susp_segment28 <> hr_api.g_varchar2 or
2235: p_susp_segment13 <> hr_api.g_varchar2 or p_susp_segment14 <> hr_api.g_varchar2 or
2236: p_susp_segment15 <> hr_api.g_varchar2 or p_susp_segment16 <> hr_api.g_varchar2 or
2237: p_susp_segment17 <> hr_api.g_varchar2 or p_susp_segment18 <> hr_api.g_varchar2 or
2238: p_susp_segment19 <> hr_api.g_varchar2 or p_susp_segment20 <> hr_api.g_varchar2 or
2239: p_susp_segment21 <> hr_api.g_varchar2 or p_susp_segment22 <> hr_api.g_varchar2 or
2240: p_susp_segment23 <> hr_api.g_varchar2 or p_susp_segment24 <> hr_api.g_varchar2 or
2241: p_susp_segment25 <> hr_api.g_varchar2 or p_susp_segment26 <> hr_api.g_varchar2 or
2242: p_susp_segment27 <> hr_api.g_varchar2 or p_susp_segment28 <> hr_api.g_varchar2 or
2243: p_susp_segment29 <> hr_api.g_varchar2 or p_susp_segment30 <> hr_api.g_varchar2 or
2236: p_susp_segment15 <> hr_api.g_varchar2 or p_susp_segment16 <> hr_api.g_varchar2 or
2237: p_susp_segment17 <> hr_api.g_varchar2 or p_susp_segment18 <> hr_api.g_varchar2 or
2238: p_susp_segment19 <> hr_api.g_varchar2 or p_susp_segment20 <> hr_api.g_varchar2 or
2239: p_susp_segment21 <> hr_api.g_varchar2 or p_susp_segment22 <> hr_api.g_varchar2 or
2240: p_susp_segment23 <> hr_api.g_varchar2 or p_susp_segment24 <> hr_api.g_varchar2 or
2241: p_susp_segment25 <> hr_api.g_varchar2 or p_susp_segment26 <> hr_api.g_varchar2 or
2242: p_susp_segment27 <> hr_api.g_varchar2 or p_susp_segment28 <> hr_api.g_varchar2 or
2243: p_susp_segment29 <> hr_api.g_varchar2 or p_susp_segment30 <> hr_api.g_varchar2 or
2244: p_susp_concat_segments_in <> hr_api.g_varchar2)
2237: p_susp_segment17 <> hr_api.g_varchar2 or p_susp_segment18 <> hr_api.g_varchar2 or
2238: p_susp_segment19 <> hr_api.g_varchar2 or p_susp_segment20 <> hr_api.g_varchar2 or
2239: p_susp_segment21 <> hr_api.g_varchar2 or p_susp_segment22 <> hr_api.g_varchar2 or
2240: p_susp_segment23 <> hr_api.g_varchar2 or p_susp_segment24 <> hr_api.g_varchar2 or
2241: p_susp_segment25 <> hr_api.g_varchar2 or p_susp_segment26 <> hr_api.g_varchar2 or
2242: p_susp_segment27 <> hr_api.g_varchar2 or p_susp_segment28 <> hr_api.g_varchar2 or
2243: p_susp_segment29 <> hr_api.g_varchar2 or p_susp_segment30 <> hr_api.g_varchar2 or
2244: p_susp_concat_segments_in <> hr_api.g_varchar2)
2245: then
2238: p_susp_segment19 <> hr_api.g_varchar2 or p_susp_segment20 <> hr_api.g_varchar2 or
2239: p_susp_segment21 <> hr_api.g_varchar2 or p_susp_segment22 <> hr_api.g_varchar2 or
2240: p_susp_segment23 <> hr_api.g_varchar2 or p_susp_segment24 <> hr_api.g_varchar2 or
2241: p_susp_segment25 <> hr_api.g_varchar2 or p_susp_segment26 <> hr_api.g_varchar2 or
2242: p_susp_segment27 <> hr_api.g_varchar2 or p_susp_segment28 <> hr_api.g_varchar2 or
2243: p_susp_segment29 <> hr_api.g_varchar2 or p_susp_segment30 <> hr_api.g_varchar2 or
2244: p_susp_concat_segments_in <> hr_api.g_varchar2)
2245: then
2246: --
2239: p_susp_segment21 <> hr_api.g_varchar2 or p_susp_segment22 <> hr_api.g_varchar2 or
2240: p_susp_segment23 <> hr_api.g_varchar2 or p_susp_segment24 <> hr_api.g_varchar2 or
2241: p_susp_segment25 <> hr_api.g_varchar2 or p_susp_segment26 <> hr_api.g_varchar2 or
2242: p_susp_segment27 <> hr_api.g_varchar2 or p_susp_segment28 <> hr_api.g_varchar2 or
2243: p_susp_segment29 <> hr_api.g_varchar2 or p_susp_segment30 <> hr_api.g_varchar2 or
2244: p_susp_concat_segments_in <> hr_api.g_varchar2)
2245: then
2246: --
2247: --
2240: p_susp_segment23 <> hr_api.g_varchar2 or p_susp_segment24 <> hr_api.g_varchar2 or
2241: p_susp_segment25 <> hr_api.g_varchar2 or p_susp_segment26 <> hr_api.g_varchar2 or
2242: p_susp_segment27 <> hr_api.g_varchar2 or p_susp_segment28 <> hr_api.g_varchar2 or
2243: p_susp_segment29 <> hr_api.g_varchar2 or p_susp_segment30 <> hr_api.g_varchar2 or
2244: p_susp_concat_segments_in <> hr_api.g_varchar2)
2245: then
2246: --
2247: --
2248: --Retrieve the suspense account keyflex ID and structure identifier.
2311:
2312: --
2313: end if;
2314:
2315: if (p_soft_coding_keyflex_id_in = hr_api.g_number) and
2316: (p_scl_segment1 <> hr_api.g_varchar2 or p_scl_segment2 <> hr_api.g_varchar2 or
2317: p_scl_segment3 <> hr_api.g_varchar2 or p_scl_segment4 <> hr_api.g_varchar2 or
2318: p_scl_segment5 <> hr_api.g_varchar2 or p_scl_segment6 <> hr_api.g_varchar2 or
2319: p_scl_segment7 <> hr_api.g_varchar2 or p_scl_segment8 <> hr_api.g_varchar2 or
2312: --
2313: end if;
2314:
2315: if (p_soft_coding_keyflex_id_in = hr_api.g_number) and
2316: (p_scl_segment1 <> hr_api.g_varchar2 or p_scl_segment2 <> hr_api.g_varchar2 or
2317: p_scl_segment3 <> hr_api.g_varchar2 or p_scl_segment4 <> hr_api.g_varchar2 or
2318: p_scl_segment5 <> hr_api.g_varchar2 or p_scl_segment6 <> hr_api.g_varchar2 or
2319: p_scl_segment7 <> hr_api.g_varchar2 or p_scl_segment8 <> hr_api.g_varchar2 or
2320: p_scl_segment9 <> hr_api.g_varchar2 or p_scl_segment10 <> hr_api.g_varchar2 or
2313: end if;
2314:
2315: if (p_soft_coding_keyflex_id_in = hr_api.g_number) and
2316: (p_scl_segment1 <> hr_api.g_varchar2 or p_scl_segment2 <> hr_api.g_varchar2 or
2317: p_scl_segment3 <> hr_api.g_varchar2 or p_scl_segment4 <> hr_api.g_varchar2 or
2318: p_scl_segment5 <> hr_api.g_varchar2 or p_scl_segment6 <> hr_api.g_varchar2 or
2319: p_scl_segment7 <> hr_api.g_varchar2 or p_scl_segment8 <> hr_api.g_varchar2 or
2320: p_scl_segment9 <> hr_api.g_varchar2 or p_scl_segment10 <> hr_api.g_varchar2 or
2321: p_scl_segment11 <> hr_api.g_varchar2 or p_scl_segment12 <> hr_api.g_varchar2 or
2314:
2315: if (p_soft_coding_keyflex_id_in = hr_api.g_number) and
2316: (p_scl_segment1 <> hr_api.g_varchar2 or p_scl_segment2 <> hr_api.g_varchar2 or
2317: p_scl_segment3 <> hr_api.g_varchar2 or p_scl_segment4 <> hr_api.g_varchar2 or
2318: p_scl_segment5 <> hr_api.g_varchar2 or p_scl_segment6 <> hr_api.g_varchar2 or
2319: p_scl_segment7 <> hr_api.g_varchar2 or p_scl_segment8 <> hr_api.g_varchar2 or
2320: p_scl_segment9 <> hr_api.g_varchar2 or p_scl_segment10 <> hr_api.g_varchar2 or
2321: p_scl_segment11 <> hr_api.g_varchar2 or p_scl_segment12 <> hr_api.g_varchar2 or
2322: p_scl_segment13 <> hr_api.g_varchar2 or p_scl_segment14 <> hr_api.g_varchar2 or
2315: if (p_soft_coding_keyflex_id_in = hr_api.g_number) and
2316: (p_scl_segment1 <> hr_api.g_varchar2 or p_scl_segment2 <> hr_api.g_varchar2 or
2317: p_scl_segment3 <> hr_api.g_varchar2 or p_scl_segment4 <> hr_api.g_varchar2 or
2318: p_scl_segment5 <> hr_api.g_varchar2 or p_scl_segment6 <> hr_api.g_varchar2 or
2319: p_scl_segment7 <> hr_api.g_varchar2 or p_scl_segment8 <> hr_api.g_varchar2 or
2320: p_scl_segment9 <> hr_api.g_varchar2 or p_scl_segment10 <> hr_api.g_varchar2 or
2321: p_scl_segment11 <> hr_api.g_varchar2 or p_scl_segment12 <> hr_api.g_varchar2 or
2322: p_scl_segment13 <> hr_api.g_varchar2 or p_scl_segment14 <> hr_api.g_varchar2 or
2323: p_scl_segment15 <> hr_api.g_varchar2 or p_scl_segment16 <> hr_api.g_varchar2 or
2316: (p_scl_segment1 <> hr_api.g_varchar2 or p_scl_segment2 <> hr_api.g_varchar2 or
2317: p_scl_segment3 <> hr_api.g_varchar2 or p_scl_segment4 <> hr_api.g_varchar2 or
2318: p_scl_segment5 <> hr_api.g_varchar2 or p_scl_segment6 <> hr_api.g_varchar2 or
2319: p_scl_segment7 <> hr_api.g_varchar2 or p_scl_segment8 <> hr_api.g_varchar2 or
2320: p_scl_segment9 <> hr_api.g_varchar2 or p_scl_segment10 <> hr_api.g_varchar2 or
2321: p_scl_segment11 <> hr_api.g_varchar2 or p_scl_segment12 <> hr_api.g_varchar2 or
2322: p_scl_segment13 <> hr_api.g_varchar2 or p_scl_segment14 <> hr_api.g_varchar2 or
2323: p_scl_segment15 <> hr_api.g_varchar2 or p_scl_segment16 <> hr_api.g_varchar2 or
2324: p_scl_segment17 <> hr_api.g_varchar2 or p_scl_segment18 <> hr_api.g_varchar2 or
2317: p_scl_segment3 <> hr_api.g_varchar2 or p_scl_segment4 <> hr_api.g_varchar2 or
2318: p_scl_segment5 <> hr_api.g_varchar2 or p_scl_segment6 <> hr_api.g_varchar2 or
2319: p_scl_segment7 <> hr_api.g_varchar2 or p_scl_segment8 <> hr_api.g_varchar2 or
2320: p_scl_segment9 <> hr_api.g_varchar2 or p_scl_segment10 <> hr_api.g_varchar2 or
2321: p_scl_segment11 <> hr_api.g_varchar2 or p_scl_segment12 <> hr_api.g_varchar2 or
2322: p_scl_segment13 <> hr_api.g_varchar2 or p_scl_segment14 <> hr_api.g_varchar2 or
2323: p_scl_segment15 <> hr_api.g_varchar2 or p_scl_segment16 <> hr_api.g_varchar2 or
2324: p_scl_segment17 <> hr_api.g_varchar2 or p_scl_segment18 <> hr_api.g_varchar2 or
2325: p_scl_segment19 <> hr_api.g_varchar2 or p_scl_segment20 <> hr_api.g_varchar2 or
2318: p_scl_segment5 <> hr_api.g_varchar2 or p_scl_segment6 <> hr_api.g_varchar2 or
2319: p_scl_segment7 <> hr_api.g_varchar2 or p_scl_segment8 <> hr_api.g_varchar2 or
2320: p_scl_segment9 <> hr_api.g_varchar2 or p_scl_segment10 <> hr_api.g_varchar2 or
2321: p_scl_segment11 <> hr_api.g_varchar2 or p_scl_segment12 <> hr_api.g_varchar2 or
2322: p_scl_segment13 <> hr_api.g_varchar2 or p_scl_segment14 <> hr_api.g_varchar2 or
2323: p_scl_segment15 <> hr_api.g_varchar2 or p_scl_segment16 <> hr_api.g_varchar2 or
2324: p_scl_segment17 <> hr_api.g_varchar2 or p_scl_segment18 <> hr_api.g_varchar2 or
2325: p_scl_segment19 <> hr_api.g_varchar2 or p_scl_segment20 <> hr_api.g_varchar2 or
2326: p_scl_segment21 <> hr_api.g_varchar2 or p_scl_segment22 <> hr_api.g_varchar2 or
2319: p_scl_segment7 <> hr_api.g_varchar2 or p_scl_segment8 <> hr_api.g_varchar2 or
2320: p_scl_segment9 <> hr_api.g_varchar2 or p_scl_segment10 <> hr_api.g_varchar2 or
2321: p_scl_segment11 <> hr_api.g_varchar2 or p_scl_segment12 <> hr_api.g_varchar2 or
2322: p_scl_segment13 <> hr_api.g_varchar2 or p_scl_segment14 <> hr_api.g_varchar2 or
2323: p_scl_segment15 <> hr_api.g_varchar2 or p_scl_segment16 <> hr_api.g_varchar2 or
2324: p_scl_segment17 <> hr_api.g_varchar2 or p_scl_segment18 <> hr_api.g_varchar2 or
2325: p_scl_segment19 <> hr_api.g_varchar2 or p_scl_segment20 <> hr_api.g_varchar2 or
2326: p_scl_segment21 <> hr_api.g_varchar2 or p_scl_segment22 <> hr_api.g_varchar2 or
2327: p_scl_segment23 <> hr_api.g_varchar2 or p_scl_segment24 <> hr_api.g_varchar2 or
2320: p_scl_segment9 <> hr_api.g_varchar2 or p_scl_segment10 <> hr_api.g_varchar2 or
2321: p_scl_segment11 <> hr_api.g_varchar2 or p_scl_segment12 <> hr_api.g_varchar2 or
2322: p_scl_segment13 <> hr_api.g_varchar2 or p_scl_segment14 <> hr_api.g_varchar2 or
2323: p_scl_segment15 <> hr_api.g_varchar2 or p_scl_segment16 <> hr_api.g_varchar2 or
2324: p_scl_segment17 <> hr_api.g_varchar2 or p_scl_segment18 <> hr_api.g_varchar2 or
2325: p_scl_segment19 <> hr_api.g_varchar2 or p_scl_segment20 <> hr_api.g_varchar2 or
2326: p_scl_segment21 <> hr_api.g_varchar2 or p_scl_segment22 <> hr_api.g_varchar2 or
2327: p_scl_segment23 <> hr_api.g_varchar2 or p_scl_segment24 <> hr_api.g_varchar2 or
2328: p_scl_segment25 <> hr_api.g_varchar2 or p_scl_segment26 <> hr_api.g_varchar2 or
2321: p_scl_segment11 <> hr_api.g_varchar2 or p_scl_segment12 <> hr_api.g_varchar2 or
2322: p_scl_segment13 <> hr_api.g_varchar2 or p_scl_segment14 <> hr_api.g_varchar2 or
2323: p_scl_segment15 <> hr_api.g_varchar2 or p_scl_segment16 <> hr_api.g_varchar2 or
2324: p_scl_segment17 <> hr_api.g_varchar2 or p_scl_segment18 <> hr_api.g_varchar2 or
2325: p_scl_segment19 <> hr_api.g_varchar2 or p_scl_segment20 <> hr_api.g_varchar2 or
2326: p_scl_segment21 <> hr_api.g_varchar2 or p_scl_segment22 <> hr_api.g_varchar2 or
2327: p_scl_segment23 <> hr_api.g_varchar2 or p_scl_segment24 <> hr_api.g_varchar2 or
2328: p_scl_segment25 <> hr_api.g_varchar2 or p_scl_segment26 <> hr_api.g_varchar2 or
2329: p_scl_segment27 <> hr_api.g_varchar2 or p_scl_segment28 <> hr_api.g_varchar2 or
2322: p_scl_segment13 <> hr_api.g_varchar2 or p_scl_segment14 <> hr_api.g_varchar2 or
2323: p_scl_segment15 <> hr_api.g_varchar2 or p_scl_segment16 <> hr_api.g_varchar2 or
2324: p_scl_segment17 <> hr_api.g_varchar2 or p_scl_segment18 <> hr_api.g_varchar2 or
2325: p_scl_segment19 <> hr_api.g_varchar2 or p_scl_segment20 <> hr_api.g_varchar2 or
2326: p_scl_segment21 <> hr_api.g_varchar2 or p_scl_segment22 <> hr_api.g_varchar2 or
2327: p_scl_segment23 <> hr_api.g_varchar2 or p_scl_segment24 <> hr_api.g_varchar2 or
2328: p_scl_segment25 <> hr_api.g_varchar2 or p_scl_segment26 <> hr_api.g_varchar2 or
2329: p_scl_segment27 <> hr_api.g_varchar2 or p_scl_segment28 <> hr_api.g_varchar2 or
2330: p_scl_segment29 <> hr_api.g_varchar2 or p_scl_segment30 <> hr_api.g_varchar2 or
2323: p_scl_segment15 <> hr_api.g_varchar2 or p_scl_segment16 <> hr_api.g_varchar2 or
2324: p_scl_segment17 <> hr_api.g_varchar2 or p_scl_segment18 <> hr_api.g_varchar2 or
2325: p_scl_segment19 <> hr_api.g_varchar2 or p_scl_segment20 <> hr_api.g_varchar2 or
2326: p_scl_segment21 <> hr_api.g_varchar2 or p_scl_segment22 <> hr_api.g_varchar2 or
2327: p_scl_segment23 <> hr_api.g_varchar2 or p_scl_segment24 <> hr_api.g_varchar2 or
2328: p_scl_segment25 <> hr_api.g_varchar2 or p_scl_segment26 <> hr_api.g_varchar2 or
2329: p_scl_segment27 <> hr_api.g_varchar2 or p_scl_segment28 <> hr_api.g_varchar2 or
2330: p_scl_segment29 <> hr_api.g_varchar2 or p_scl_segment30 <> hr_api.g_varchar2 or
2331: p_scl_concat_segments_in <> hr_api.g_varchar2)
2324: p_scl_segment17 <> hr_api.g_varchar2 or p_scl_segment18 <> hr_api.g_varchar2 or
2325: p_scl_segment19 <> hr_api.g_varchar2 or p_scl_segment20 <> hr_api.g_varchar2 or
2326: p_scl_segment21 <> hr_api.g_varchar2 or p_scl_segment22 <> hr_api.g_varchar2 or
2327: p_scl_segment23 <> hr_api.g_varchar2 or p_scl_segment24 <> hr_api.g_varchar2 or
2328: p_scl_segment25 <> hr_api.g_varchar2 or p_scl_segment26 <> hr_api.g_varchar2 or
2329: p_scl_segment27 <> hr_api.g_varchar2 or p_scl_segment28 <> hr_api.g_varchar2 or
2330: p_scl_segment29 <> hr_api.g_varchar2 or p_scl_segment30 <> hr_api.g_varchar2 or
2331: p_scl_concat_segments_in <> hr_api.g_varchar2)
2332: then
2325: p_scl_segment19 <> hr_api.g_varchar2 or p_scl_segment20 <> hr_api.g_varchar2 or
2326: p_scl_segment21 <> hr_api.g_varchar2 or p_scl_segment22 <> hr_api.g_varchar2 or
2327: p_scl_segment23 <> hr_api.g_varchar2 or p_scl_segment24 <> hr_api.g_varchar2 or
2328: p_scl_segment25 <> hr_api.g_varchar2 or p_scl_segment26 <> hr_api.g_varchar2 or
2329: p_scl_segment27 <> hr_api.g_varchar2 or p_scl_segment28 <> hr_api.g_varchar2 or
2330: p_scl_segment29 <> hr_api.g_varchar2 or p_scl_segment30 <> hr_api.g_varchar2 or
2331: p_scl_concat_segments_in <> hr_api.g_varchar2)
2332: then
2333: --
2326: p_scl_segment21 <> hr_api.g_varchar2 or p_scl_segment22 <> hr_api.g_varchar2 or
2327: p_scl_segment23 <> hr_api.g_varchar2 or p_scl_segment24 <> hr_api.g_varchar2 or
2328: p_scl_segment25 <> hr_api.g_varchar2 or p_scl_segment26 <> hr_api.g_varchar2 or
2329: p_scl_segment27 <> hr_api.g_varchar2 or p_scl_segment28 <> hr_api.g_varchar2 or
2330: p_scl_segment29 <> hr_api.g_varchar2 or p_scl_segment30 <> hr_api.g_varchar2 or
2331: p_scl_concat_segments_in <> hr_api.g_varchar2)
2332: then
2333: --
2334: --
2327: p_scl_segment23 <> hr_api.g_varchar2 or p_scl_segment24 <> hr_api.g_varchar2 or
2328: p_scl_segment25 <> hr_api.g_varchar2 or p_scl_segment26 <> hr_api.g_varchar2 or
2329: p_scl_segment27 <> hr_api.g_varchar2 or p_scl_segment28 <> hr_api.g_varchar2 or
2330: p_scl_segment29 <> hr_api.g_varchar2 or p_scl_segment30 <> hr_api.g_varchar2 or
2331: p_scl_concat_segments_in <> hr_api.g_varchar2)
2332: then
2333: --
2334: --
2335: --Retrieve the soft account keyflex ID and structure identifier.
2400: p_soft_coding_keyflex_id_out := l_soft_coding_keyflex_id;
2401:
2402: --
2403: end if;
2404: if ((p_prl_information1 <> hr_api.g_varchar2) or (p_prl_information2 <> hr_api.g_varchar2) or
2405: (p_prl_information3 <> hr_api.g_varchar2) or (p_prl_information4 <> hr_api.g_varchar2) or
2406: (p_prl_information5 <> hr_api.g_varchar2) or (p_prl_information6 <> hr_api.g_varchar2) or
2407: (p_prl_information7 <> hr_api.g_varchar2) or (p_prl_information8 <> hr_api.g_varchar2) or
2408: (p_prl_information9 <> hr_api.g_varchar2) or (p_prl_information10 <> hr_api.g_varchar2) or
2401:
2402: --
2403: end if;
2404: if ((p_prl_information1 <> hr_api.g_varchar2) or (p_prl_information2 <> hr_api.g_varchar2) or
2405: (p_prl_information3 <> hr_api.g_varchar2) or (p_prl_information4 <> hr_api.g_varchar2) or
2406: (p_prl_information5 <> hr_api.g_varchar2) or (p_prl_information6 <> hr_api.g_varchar2) or
2407: (p_prl_information7 <> hr_api.g_varchar2) or (p_prl_information8 <> hr_api.g_varchar2) or
2408: (p_prl_information9 <> hr_api.g_varchar2) or (p_prl_information10 <> hr_api.g_varchar2) or
2409: (p_prl_information11 <> hr_api.g_varchar2) or (p_prl_information12 <> hr_api.g_varchar2) or
2402: --
2403: end if;
2404: if ((p_prl_information1 <> hr_api.g_varchar2) or (p_prl_information2 <> hr_api.g_varchar2) or
2405: (p_prl_information3 <> hr_api.g_varchar2) or (p_prl_information4 <> hr_api.g_varchar2) or
2406: (p_prl_information5 <> hr_api.g_varchar2) or (p_prl_information6 <> hr_api.g_varchar2) or
2407: (p_prl_information7 <> hr_api.g_varchar2) or (p_prl_information8 <> hr_api.g_varchar2) or
2408: (p_prl_information9 <> hr_api.g_varchar2) or (p_prl_information10 <> hr_api.g_varchar2) or
2409: (p_prl_information11 <> hr_api.g_varchar2) or (p_prl_information12 <> hr_api.g_varchar2) or
2410: (p_prl_information13 <> hr_api.g_varchar2) or (p_prl_information14 <> hr_api.g_varchar2) or
2403: end if;
2404: if ((p_prl_information1 <> hr_api.g_varchar2) or (p_prl_information2 <> hr_api.g_varchar2) or
2405: (p_prl_information3 <> hr_api.g_varchar2) or (p_prl_information4 <> hr_api.g_varchar2) or
2406: (p_prl_information5 <> hr_api.g_varchar2) or (p_prl_information6 <> hr_api.g_varchar2) or
2407: (p_prl_information7 <> hr_api.g_varchar2) or (p_prl_information8 <> hr_api.g_varchar2) or
2408: (p_prl_information9 <> hr_api.g_varchar2) or (p_prl_information10 <> hr_api.g_varchar2) or
2409: (p_prl_information11 <> hr_api.g_varchar2) or (p_prl_information12 <> hr_api.g_varchar2) or
2410: (p_prl_information13 <> hr_api.g_varchar2) or (p_prl_information14 <> hr_api.g_varchar2) or
2411: (p_prl_information15 <> hr_api.g_varchar2) or (p_prl_information16 <> hr_api.g_varchar2) or
2404: if ((p_prl_information1 <> hr_api.g_varchar2) or (p_prl_information2 <> hr_api.g_varchar2) or
2405: (p_prl_information3 <> hr_api.g_varchar2) or (p_prl_information4 <> hr_api.g_varchar2) or
2406: (p_prl_information5 <> hr_api.g_varchar2) or (p_prl_information6 <> hr_api.g_varchar2) or
2407: (p_prl_information7 <> hr_api.g_varchar2) or (p_prl_information8 <> hr_api.g_varchar2) or
2408: (p_prl_information9 <> hr_api.g_varchar2) or (p_prl_information10 <> hr_api.g_varchar2) or
2409: (p_prl_information11 <> hr_api.g_varchar2) or (p_prl_information12 <> hr_api.g_varchar2) or
2410: (p_prl_information13 <> hr_api.g_varchar2) or (p_prl_information14 <> hr_api.g_varchar2) or
2411: (p_prl_information15 <> hr_api.g_varchar2) or (p_prl_information16 <> hr_api.g_varchar2) or
2412: (p_prl_information17 <> hr_api.g_varchar2) or (p_prl_information18 <> hr_api.g_varchar2) or
2405: (p_prl_information3 <> hr_api.g_varchar2) or (p_prl_information4 <> hr_api.g_varchar2) or
2406: (p_prl_information5 <> hr_api.g_varchar2) or (p_prl_information6 <> hr_api.g_varchar2) or
2407: (p_prl_information7 <> hr_api.g_varchar2) or (p_prl_information8 <> hr_api.g_varchar2) or
2408: (p_prl_information9 <> hr_api.g_varchar2) or (p_prl_information10 <> hr_api.g_varchar2) or
2409: (p_prl_information11 <> hr_api.g_varchar2) or (p_prl_information12 <> hr_api.g_varchar2) or
2410: (p_prl_information13 <> hr_api.g_varchar2) or (p_prl_information14 <> hr_api.g_varchar2) or
2411: (p_prl_information15 <> hr_api.g_varchar2) or (p_prl_information16 <> hr_api.g_varchar2) or
2412: (p_prl_information17 <> hr_api.g_varchar2) or (p_prl_information18 <> hr_api.g_varchar2) or
2413: (p_prl_information19 <> hr_api.g_varchar2) or (p_prl_information20 <> hr_api.g_varchar2) or
2406: (p_prl_information5 <> hr_api.g_varchar2) or (p_prl_information6 <> hr_api.g_varchar2) or
2407: (p_prl_information7 <> hr_api.g_varchar2) or (p_prl_information8 <> hr_api.g_varchar2) or
2408: (p_prl_information9 <> hr_api.g_varchar2) or (p_prl_information10 <> hr_api.g_varchar2) or
2409: (p_prl_information11 <> hr_api.g_varchar2) or (p_prl_information12 <> hr_api.g_varchar2) or
2410: (p_prl_information13 <> hr_api.g_varchar2) or (p_prl_information14 <> hr_api.g_varchar2) or
2411: (p_prl_information15 <> hr_api.g_varchar2) or (p_prl_information16 <> hr_api.g_varchar2) or
2412: (p_prl_information17 <> hr_api.g_varchar2) or (p_prl_information18 <> hr_api.g_varchar2) or
2413: (p_prl_information19 <> hr_api.g_varchar2) or (p_prl_information20 <> hr_api.g_varchar2) or
2414: (p_prl_information21 <> hr_api.g_varchar2) or (p_prl_information22 <> hr_api.g_varchar2) or
2407: (p_prl_information7 <> hr_api.g_varchar2) or (p_prl_information8 <> hr_api.g_varchar2) or
2408: (p_prl_information9 <> hr_api.g_varchar2) or (p_prl_information10 <> hr_api.g_varchar2) or
2409: (p_prl_information11 <> hr_api.g_varchar2) or (p_prl_information12 <> hr_api.g_varchar2) or
2410: (p_prl_information13 <> hr_api.g_varchar2) or (p_prl_information14 <> hr_api.g_varchar2) or
2411: (p_prl_information15 <> hr_api.g_varchar2) or (p_prl_information16 <> hr_api.g_varchar2) or
2412: (p_prl_information17 <> hr_api.g_varchar2) or (p_prl_information18 <> hr_api.g_varchar2) or
2413: (p_prl_information19 <> hr_api.g_varchar2) or (p_prl_information20 <> hr_api.g_varchar2) or
2414: (p_prl_information21 <> hr_api.g_varchar2) or (p_prl_information22 <> hr_api.g_varchar2) or
2415: (p_prl_information23 <> hr_api.g_varchar2) or (p_prl_information24 <> hr_api.g_varchar2) or
2408: (p_prl_information9 <> hr_api.g_varchar2) or (p_prl_information10 <> hr_api.g_varchar2) or
2409: (p_prl_information11 <> hr_api.g_varchar2) or (p_prl_information12 <> hr_api.g_varchar2) or
2410: (p_prl_information13 <> hr_api.g_varchar2) or (p_prl_information14 <> hr_api.g_varchar2) or
2411: (p_prl_information15 <> hr_api.g_varchar2) or (p_prl_information16 <> hr_api.g_varchar2) or
2412: (p_prl_information17 <> hr_api.g_varchar2) or (p_prl_information18 <> hr_api.g_varchar2) or
2413: (p_prl_information19 <> hr_api.g_varchar2) or (p_prl_information20 <> hr_api.g_varchar2) or
2414: (p_prl_information21 <> hr_api.g_varchar2) or (p_prl_information22 <> hr_api.g_varchar2) or
2415: (p_prl_information23 <> hr_api.g_varchar2) or (p_prl_information24 <> hr_api.g_varchar2) or
2416: (p_prl_information25 <> hr_api.g_varchar2) or (p_prl_information26 <> hr_api.g_varchar2) or
2409: (p_prl_information11 <> hr_api.g_varchar2) or (p_prl_information12 <> hr_api.g_varchar2) or
2410: (p_prl_information13 <> hr_api.g_varchar2) or (p_prl_information14 <> hr_api.g_varchar2) or
2411: (p_prl_information15 <> hr_api.g_varchar2) or (p_prl_information16 <> hr_api.g_varchar2) or
2412: (p_prl_information17 <> hr_api.g_varchar2) or (p_prl_information18 <> hr_api.g_varchar2) or
2413: (p_prl_information19 <> hr_api.g_varchar2) or (p_prl_information20 <> hr_api.g_varchar2) or
2414: (p_prl_information21 <> hr_api.g_varchar2) or (p_prl_information22 <> hr_api.g_varchar2) or
2415: (p_prl_information23 <> hr_api.g_varchar2) or (p_prl_information24 <> hr_api.g_varchar2) or
2416: (p_prl_information25 <> hr_api.g_varchar2) or (p_prl_information26 <> hr_api.g_varchar2) or
2417: (p_prl_information27 <> hr_api.g_varchar2) or (p_prl_information28 <> hr_api.g_varchar2) or
2410: (p_prl_information13 <> hr_api.g_varchar2) or (p_prl_information14 <> hr_api.g_varchar2) or
2411: (p_prl_information15 <> hr_api.g_varchar2) or (p_prl_information16 <> hr_api.g_varchar2) or
2412: (p_prl_information17 <> hr_api.g_varchar2) or (p_prl_information18 <> hr_api.g_varchar2) or
2413: (p_prl_information19 <> hr_api.g_varchar2) or (p_prl_information20 <> hr_api.g_varchar2) or
2414: (p_prl_information21 <> hr_api.g_varchar2) or (p_prl_information22 <> hr_api.g_varchar2) or
2415: (p_prl_information23 <> hr_api.g_varchar2) or (p_prl_information24 <> hr_api.g_varchar2) or
2416: (p_prl_information25 <> hr_api.g_varchar2) or (p_prl_information26 <> hr_api.g_varchar2) or
2417: (p_prl_information27 <> hr_api.g_varchar2) or (p_prl_information28 <> hr_api.g_varchar2) or
2418: (p_prl_information29 <> hr_api.g_varchar2) or (p_prl_information30 <> hr_api.g_varchar2)) then
2411: (p_prl_information15 <> hr_api.g_varchar2) or (p_prl_information16 <> hr_api.g_varchar2) or
2412: (p_prl_information17 <> hr_api.g_varchar2) or (p_prl_information18 <> hr_api.g_varchar2) or
2413: (p_prl_information19 <> hr_api.g_varchar2) or (p_prl_information20 <> hr_api.g_varchar2) or
2414: (p_prl_information21 <> hr_api.g_varchar2) or (p_prl_information22 <> hr_api.g_varchar2) or
2415: (p_prl_information23 <> hr_api.g_varchar2) or (p_prl_information24 <> hr_api.g_varchar2) or
2416: (p_prl_information25 <> hr_api.g_varchar2) or (p_prl_information26 <> hr_api.g_varchar2) or
2417: (p_prl_information27 <> hr_api.g_varchar2) or (p_prl_information28 <> hr_api.g_varchar2) or
2418: (p_prl_information29 <> hr_api.g_varchar2) or (p_prl_information30 <> hr_api.g_varchar2)) then
2419: --
2412: (p_prl_information17 <> hr_api.g_varchar2) or (p_prl_information18 <> hr_api.g_varchar2) or
2413: (p_prl_information19 <> hr_api.g_varchar2) or (p_prl_information20 <> hr_api.g_varchar2) or
2414: (p_prl_information21 <> hr_api.g_varchar2) or (p_prl_information22 <> hr_api.g_varchar2) or
2415: (p_prl_information23 <> hr_api.g_varchar2) or (p_prl_information24 <> hr_api.g_varchar2) or
2416: (p_prl_information25 <> hr_api.g_varchar2) or (p_prl_information26 <> hr_api.g_varchar2) or
2417: (p_prl_information27 <> hr_api.g_varchar2) or (p_prl_information28 <> hr_api.g_varchar2) or
2418: (p_prl_information29 <> hr_api.g_varchar2) or (p_prl_information30 <> hr_api.g_varchar2)) then
2419: --
2420: l_prl_information_category := l_legislation_code;
2413: (p_prl_information19 <> hr_api.g_varchar2) or (p_prl_information20 <> hr_api.g_varchar2) or
2414: (p_prl_information21 <> hr_api.g_varchar2) or (p_prl_information22 <> hr_api.g_varchar2) or
2415: (p_prl_information23 <> hr_api.g_varchar2) or (p_prl_information24 <> hr_api.g_varchar2) or
2416: (p_prl_information25 <> hr_api.g_varchar2) or (p_prl_information26 <> hr_api.g_varchar2) or
2417: (p_prl_information27 <> hr_api.g_varchar2) or (p_prl_information28 <> hr_api.g_varchar2) or
2418: (p_prl_information29 <> hr_api.g_varchar2) or (p_prl_information30 <> hr_api.g_varchar2)) then
2419: --
2420: l_prl_information_category := l_legislation_code;
2421: --
2414: (p_prl_information21 <> hr_api.g_varchar2) or (p_prl_information22 <> hr_api.g_varchar2) or
2415: (p_prl_information23 <> hr_api.g_varchar2) or (p_prl_information24 <> hr_api.g_varchar2) or
2416: (p_prl_information25 <> hr_api.g_varchar2) or (p_prl_information26 <> hr_api.g_varchar2) or
2417: (p_prl_information27 <> hr_api.g_varchar2) or (p_prl_information28 <> hr_api.g_varchar2) or
2418: (p_prl_information29 <> hr_api.g_varchar2) or (p_prl_information30 <> hr_api.g_varchar2)) then
2419: --
2420: l_prl_information_category := l_legislation_code;
2421: --
2422: end if;
2689:
2690: );
2691:
2692: exception
2693: when hr_api.cannot_find_prog_unit then
2694: hr_api.cannot_find_prog_unit_error
2695: (p_module_name => 'update_payroll'
2696: ,p_hook_type => 'AP'
2697: );
2690: );
2691:
2692: exception
2693: when hr_api.cannot_find_prog_unit then
2694: hr_api.cannot_find_prog_unit_error
2695: (p_module_name => 'update_payroll'
2696: ,p_hook_type => 'AP'
2697: );
2698: --
2699: end;
2700:
2701: if(p_validate) then
2702: --
2703: raise hr_api.validate_enabled;
2704: --
2705: end if;
2706: --
2707: -- Set all IN OUT and OUT parameters with out values
2715: --
2716: --If the user doesn't specify any id then to return to the user
2717: --need to query from the table
2718: --
2719: if ((p_cost_alloc_keyflex_id_in = hr_api.g_number) and (l_cost_flag = false)) then
2720: --
2721: open csr_get_costKFF;
2722: fetch csr_get_costKFF into p_cost_alloc_keyflex_id_out;
2723: close csr_get_costKFF;
2723: close csr_get_costKFF;
2724: --
2725: end if;
2726: --
2727: if ((p_susp_account_keyflex_id_in = hr_api.g_number) and (l_susp_flag = false))then
2728: --
2729: open csr_get_suspenseKFF;
2730: fetch csr_get_suspenseKFF into p_susp_account_keyflex_id_out;
2731: close csr_get_suspenseKFF;
2731: close csr_get_suspenseKFF;
2732: --
2733: end if;
2734: --
2735: if ((p_soft_coding_keyflex_id_in = hr_api.g_number) and (l_soft_flag = false))then
2736: --
2737: open csr_get_softKFF;
2738: fetch csr_get_softKFF into p_soft_coding_keyflex_id_out;
2739: close csr_get_softKFF;
2741: end if;
2742: --
2743: hr_utility.set_location(' Leaving:'||l_proc, 70);
2744: exception
2745: when hr_api.validate_enabled then
2746: --
2747: -- Must remove all work done by this procedure.
2748: --
2749: rollback to update_payroll;
2821: ,p_payroll_id => p_payroll_id
2822: ,p_object_version_number => l_object_version_number
2823: );
2824: exception
2825: when hr_api.cannot_find_prog_unit then
2826: hr_api.cannot_find_prog_unit_error
2827: (p_module_name => 'delete_payroll'
2828: ,p_hook_type => 'BP'
2829: );
2822: ,p_object_version_number => l_object_version_number
2823: );
2824: exception
2825: when hr_api.cannot_find_prog_unit then
2826: hr_api.cannot_find_prog_unit_error
2827: (p_module_name => 'delete_payroll'
2828: ,p_hook_type => 'BP'
2829: );
2830: --
2848: ,p_effective_start_date => l_effective_start_date
2849: ,p_effective_end_date => l_effective_end_date
2850: );
2851: exception
2852: when hr_api.cannot_find_prog_unit then
2853: hr_api.cannot_find_prog_unit_error
2854: (p_module_name => 'delete_payroll'
2855: ,p_hook_type => 'AP'
2856: );
2849: ,p_effective_end_date => l_effective_end_date
2850: );
2851: exception
2852: when hr_api.cannot_find_prog_unit then
2853: hr_api.cannot_find_prog_unit_error
2854: (p_module_name => 'delete_payroll'
2855: ,p_hook_type => 'AP'
2856: );
2857: --
2859: --
2860: -- When in validation only mode raise the Validate_Enabled exception
2861: --
2862: if p_validate then
2863: raise hr_api.validate_enabled;
2864: end if;
2865: --
2866:
2867: --populate the out parameters.
2871:
2872: hr_utility.set_location(' Leaving:'||l_proc, 70);
2873:
2874: exception
2875: when hr_api.validate_enabled then
2876: --
2877: -- Must remove all work done by this procedure.
2878: --
2879: rollback to delete_payroll;
3019: --Get the business group id from the consolidation set id.
3020: pay_pay_bus.chk_consolidation_set_id(p_consolidation_set_id,l_business_group_id);
3021:
3022: --Get the Legislation code.
3023: l_legislation_code := hr_api.return_legislation_code(l_business_group_id);
3024: if(l_legislation_code <> p_prl_information_category) then
3025: fnd_message.set_name('PAY', 'PAY_33275_INFOCATEGORY_INVALID');
3026: fnd_message.raise_error;
3027: end if;
3148: p_effective_date in date,
3149: p_datetrack_mode in varchar2,
3150: p_payroll_id in out nocopy number,
3151: p_object_version_number in out nocopy number,
3152: p_payroll_name in varchar2 default hr_api.g_varchar2,
3153: p_number_of_years in number default hr_api.g_number,
3154: p_default_payment_method_id in number default hr_api.g_number,
3155: p_consolidation_set_id in number default hr_api.g_number,
3156: p_cost_allocation_keyflex_id in number default hr_api.g_number,
3149: p_datetrack_mode in varchar2,
3150: p_payroll_id in out nocopy number,
3151: p_object_version_number in out nocopy number,
3152: p_payroll_name in varchar2 default hr_api.g_varchar2,
3153: p_number_of_years in number default hr_api.g_number,
3154: p_default_payment_method_id in number default hr_api.g_number,
3155: p_consolidation_set_id in number default hr_api.g_number,
3156: p_cost_allocation_keyflex_id in number default hr_api.g_number,
3157: p_suspense_account_keyflex_id in number default hr_api.g_number,
3150: p_payroll_id in out nocopy number,
3151: p_object_version_number in out nocopy number,
3152: p_payroll_name in varchar2 default hr_api.g_varchar2,
3153: p_number_of_years in number default hr_api.g_number,
3154: p_default_payment_method_id in number default hr_api.g_number,
3155: p_consolidation_set_id in number default hr_api.g_number,
3156: p_cost_allocation_keyflex_id in number default hr_api.g_number,
3157: p_suspense_account_keyflex_id in number default hr_api.g_number,
3158: p_negative_pay_allowed_flag in varchar2 default hr_api.g_varchar2,
3151: p_object_version_number in out nocopy number,
3152: p_payroll_name in varchar2 default hr_api.g_varchar2,
3153: p_number_of_years in number default hr_api.g_number,
3154: p_default_payment_method_id in number default hr_api.g_number,
3155: p_consolidation_set_id in number default hr_api.g_number,
3156: p_cost_allocation_keyflex_id in number default hr_api.g_number,
3157: p_suspense_account_keyflex_id in number default hr_api.g_number,
3158: p_negative_pay_allowed_flag in varchar2 default hr_api.g_varchar2,
3159: p_soft_coding_keyflex_id in number default hr_api.g_number,
3152: p_payroll_name in varchar2 default hr_api.g_varchar2,
3153: p_number_of_years in number default hr_api.g_number,
3154: p_default_payment_method_id in number default hr_api.g_number,
3155: p_consolidation_set_id in number default hr_api.g_number,
3156: p_cost_allocation_keyflex_id in number default hr_api.g_number,
3157: p_suspense_account_keyflex_id in number default hr_api.g_number,
3158: p_negative_pay_allowed_flag in varchar2 default hr_api.g_varchar2,
3159: p_soft_coding_keyflex_id in number default hr_api.g_number,
3160: p_comments in varchar2 default hr_api.g_varchar2,
3153: p_number_of_years in number default hr_api.g_number,
3154: p_default_payment_method_id in number default hr_api.g_number,
3155: p_consolidation_set_id in number default hr_api.g_number,
3156: p_cost_allocation_keyflex_id in number default hr_api.g_number,
3157: p_suspense_account_keyflex_id in number default hr_api.g_number,
3158: p_negative_pay_allowed_flag in varchar2 default hr_api.g_varchar2,
3159: p_soft_coding_keyflex_id in number default hr_api.g_number,
3160: p_comments in varchar2 default hr_api.g_varchar2,
3161: p_attribute_category in varchar2 default hr_api.g_varchar2,
3154: p_default_payment_method_id in number default hr_api.g_number,
3155: p_consolidation_set_id in number default hr_api.g_number,
3156: p_cost_allocation_keyflex_id in number default hr_api.g_number,
3157: p_suspense_account_keyflex_id in number default hr_api.g_number,
3158: p_negative_pay_allowed_flag in varchar2 default hr_api.g_varchar2,
3159: p_soft_coding_keyflex_id in number default hr_api.g_number,
3160: p_comments in varchar2 default hr_api.g_varchar2,
3161: p_attribute_category in varchar2 default hr_api.g_varchar2,
3162: p_attribute1 in varchar2 default hr_api.g_varchar2,
3155: p_consolidation_set_id in number default hr_api.g_number,
3156: p_cost_allocation_keyflex_id in number default hr_api.g_number,
3157: p_suspense_account_keyflex_id in number default hr_api.g_number,
3158: p_negative_pay_allowed_flag in varchar2 default hr_api.g_varchar2,
3159: p_soft_coding_keyflex_id in number default hr_api.g_number,
3160: p_comments in varchar2 default hr_api.g_varchar2,
3161: p_attribute_category in varchar2 default hr_api.g_varchar2,
3162: p_attribute1 in varchar2 default hr_api.g_varchar2,
3163: p_attribute2 in varchar2 default hr_api.g_varchar2,
3156: p_cost_allocation_keyflex_id in number default hr_api.g_number,
3157: p_suspense_account_keyflex_id in number default hr_api.g_number,
3158: p_negative_pay_allowed_flag in varchar2 default hr_api.g_varchar2,
3159: p_soft_coding_keyflex_id in number default hr_api.g_number,
3160: p_comments in varchar2 default hr_api.g_varchar2,
3161: p_attribute_category in varchar2 default hr_api.g_varchar2,
3162: p_attribute1 in varchar2 default hr_api.g_varchar2,
3163: p_attribute2 in varchar2 default hr_api.g_varchar2,
3164: p_attribute3 in varchar2 default hr_api.g_varchar2,
3157: p_suspense_account_keyflex_id in number default hr_api.g_number,
3158: p_negative_pay_allowed_flag in varchar2 default hr_api.g_varchar2,
3159: p_soft_coding_keyflex_id in number default hr_api.g_number,
3160: p_comments in varchar2 default hr_api.g_varchar2,
3161: p_attribute_category in varchar2 default hr_api.g_varchar2,
3162: p_attribute1 in varchar2 default hr_api.g_varchar2,
3163: p_attribute2 in varchar2 default hr_api.g_varchar2,
3164: p_attribute3 in varchar2 default hr_api.g_varchar2,
3165: p_attribute4 in varchar2 default hr_api.g_varchar2,
3158: p_negative_pay_allowed_flag in varchar2 default hr_api.g_varchar2,
3159: p_soft_coding_keyflex_id in number default hr_api.g_number,
3160: p_comments in varchar2 default hr_api.g_varchar2,
3161: p_attribute_category in varchar2 default hr_api.g_varchar2,
3162: p_attribute1 in varchar2 default hr_api.g_varchar2,
3163: p_attribute2 in varchar2 default hr_api.g_varchar2,
3164: p_attribute3 in varchar2 default hr_api.g_varchar2,
3165: p_attribute4 in varchar2 default hr_api.g_varchar2,
3166: p_attribute5 in varchar2 default hr_api.g_varchar2,
3159: p_soft_coding_keyflex_id in number default hr_api.g_number,
3160: p_comments in varchar2 default hr_api.g_varchar2,
3161: p_attribute_category in varchar2 default hr_api.g_varchar2,
3162: p_attribute1 in varchar2 default hr_api.g_varchar2,
3163: p_attribute2 in varchar2 default hr_api.g_varchar2,
3164: p_attribute3 in varchar2 default hr_api.g_varchar2,
3165: p_attribute4 in varchar2 default hr_api.g_varchar2,
3166: p_attribute5 in varchar2 default hr_api.g_varchar2,
3167: p_attribute6 in varchar2 default hr_api.g_varchar2,
3160: p_comments in varchar2 default hr_api.g_varchar2,
3161: p_attribute_category in varchar2 default hr_api.g_varchar2,
3162: p_attribute1 in varchar2 default hr_api.g_varchar2,
3163: p_attribute2 in varchar2 default hr_api.g_varchar2,
3164: p_attribute3 in varchar2 default hr_api.g_varchar2,
3165: p_attribute4 in varchar2 default hr_api.g_varchar2,
3166: p_attribute5 in varchar2 default hr_api.g_varchar2,
3167: p_attribute6 in varchar2 default hr_api.g_varchar2,
3168: p_attribute7 in varchar2 default hr_api.g_varchar2,
3161: p_attribute_category in varchar2 default hr_api.g_varchar2,
3162: p_attribute1 in varchar2 default hr_api.g_varchar2,
3163: p_attribute2 in varchar2 default hr_api.g_varchar2,
3164: p_attribute3 in varchar2 default hr_api.g_varchar2,
3165: p_attribute4 in varchar2 default hr_api.g_varchar2,
3166: p_attribute5 in varchar2 default hr_api.g_varchar2,
3167: p_attribute6 in varchar2 default hr_api.g_varchar2,
3168: p_attribute7 in varchar2 default hr_api.g_varchar2,
3169: p_attribute8 in varchar2 default hr_api.g_varchar2,
3162: p_attribute1 in varchar2 default hr_api.g_varchar2,
3163: p_attribute2 in varchar2 default hr_api.g_varchar2,
3164: p_attribute3 in varchar2 default hr_api.g_varchar2,
3165: p_attribute4 in varchar2 default hr_api.g_varchar2,
3166: p_attribute5 in varchar2 default hr_api.g_varchar2,
3167: p_attribute6 in varchar2 default hr_api.g_varchar2,
3168: p_attribute7 in varchar2 default hr_api.g_varchar2,
3169: p_attribute8 in varchar2 default hr_api.g_varchar2,
3170: p_attribute9 in varchar2 default hr_api.g_varchar2,
3163: p_attribute2 in varchar2 default hr_api.g_varchar2,
3164: p_attribute3 in varchar2 default hr_api.g_varchar2,
3165: p_attribute4 in varchar2 default hr_api.g_varchar2,
3166: p_attribute5 in varchar2 default hr_api.g_varchar2,
3167: p_attribute6 in varchar2 default hr_api.g_varchar2,
3168: p_attribute7 in varchar2 default hr_api.g_varchar2,
3169: p_attribute8 in varchar2 default hr_api.g_varchar2,
3170: p_attribute9 in varchar2 default hr_api.g_varchar2,
3171: p_attribute10 in varchar2 default hr_api.g_varchar2,
3164: p_attribute3 in varchar2 default hr_api.g_varchar2,
3165: p_attribute4 in varchar2 default hr_api.g_varchar2,
3166: p_attribute5 in varchar2 default hr_api.g_varchar2,
3167: p_attribute6 in varchar2 default hr_api.g_varchar2,
3168: p_attribute7 in varchar2 default hr_api.g_varchar2,
3169: p_attribute8 in varchar2 default hr_api.g_varchar2,
3170: p_attribute9 in varchar2 default hr_api.g_varchar2,
3171: p_attribute10 in varchar2 default hr_api.g_varchar2,
3172: p_attribute11 in varchar2 default hr_api.g_varchar2,
3165: p_attribute4 in varchar2 default hr_api.g_varchar2,
3166: p_attribute5 in varchar2 default hr_api.g_varchar2,
3167: p_attribute6 in varchar2 default hr_api.g_varchar2,
3168: p_attribute7 in varchar2 default hr_api.g_varchar2,
3169: p_attribute8 in varchar2 default hr_api.g_varchar2,
3170: p_attribute9 in varchar2 default hr_api.g_varchar2,
3171: p_attribute10 in varchar2 default hr_api.g_varchar2,
3172: p_attribute11 in varchar2 default hr_api.g_varchar2,
3173: p_attribute12 in varchar2 default hr_api.g_varchar2,
3166: p_attribute5 in varchar2 default hr_api.g_varchar2,
3167: p_attribute6 in varchar2 default hr_api.g_varchar2,
3168: p_attribute7 in varchar2 default hr_api.g_varchar2,
3169: p_attribute8 in varchar2 default hr_api.g_varchar2,
3170: p_attribute9 in varchar2 default hr_api.g_varchar2,
3171: p_attribute10 in varchar2 default hr_api.g_varchar2,
3172: p_attribute11 in varchar2 default hr_api.g_varchar2,
3173: p_attribute12 in varchar2 default hr_api.g_varchar2,
3174: p_attribute13 in varchar2 default hr_api.g_varchar2,
3167: p_attribute6 in varchar2 default hr_api.g_varchar2,
3168: p_attribute7 in varchar2 default hr_api.g_varchar2,
3169: p_attribute8 in varchar2 default hr_api.g_varchar2,
3170: p_attribute9 in varchar2 default hr_api.g_varchar2,
3171: p_attribute10 in varchar2 default hr_api.g_varchar2,
3172: p_attribute11 in varchar2 default hr_api.g_varchar2,
3173: p_attribute12 in varchar2 default hr_api.g_varchar2,
3174: p_attribute13 in varchar2 default hr_api.g_varchar2,
3175: p_attribute14 in varchar2 default hr_api.g_varchar2,
3168: p_attribute7 in varchar2 default hr_api.g_varchar2,
3169: p_attribute8 in varchar2 default hr_api.g_varchar2,
3170: p_attribute9 in varchar2 default hr_api.g_varchar2,
3171: p_attribute10 in varchar2 default hr_api.g_varchar2,
3172: p_attribute11 in varchar2 default hr_api.g_varchar2,
3173: p_attribute12 in varchar2 default hr_api.g_varchar2,
3174: p_attribute13 in varchar2 default hr_api.g_varchar2,
3175: p_attribute14 in varchar2 default hr_api.g_varchar2,
3176: p_attribute15 in varchar2 default hr_api.g_varchar2,
3169: p_attribute8 in varchar2 default hr_api.g_varchar2,
3170: p_attribute9 in varchar2 default hr_api.g_varchar2,
3171: p_attribute10 in varchar2 default hr_api.g_varchar2,
3172: p_attribute11 in varchar2 default hr_api.g_varchar2,
3173: p_attribute12 in varchar2 default hr_api.g_varchar2,
3174: p_attribute13 in varchar2 default hr_api.g_varchar2,
3175: p_attribute14 in varchar2 default hr_api.g_varchar2,
3176: p_attribute15 in varchar2 default hr_api.g_varchar2,
3177: p_attribute16 in varchar2 default hr_api.g_varchar2,
3170: p_attribute9 in varchar2 default hr_api.g_varchar2,
3171: p_attribute10 in varchar2 default hr_api.g_varchar2,
3172: p_attribute11 in varchar2 default hr_api.g_varchar2,
3173: p_attribute12 in varchar2 default hr_api.g_varchar2,
3174: p_attribute13 in varchar2 default hr_api.g_varchar2,
3175: p_attribute14 in varchar2 default hr_api.g_varchar2,
3176: p_attribute15 in varchar2 default hr_api.g_varchar2,
3177: p_attribute16 in varchar2 default hr_api.g_varchar2,
3178: p_attribute17 in varchar2 default hr_api.g_varchar2,
3171: p_attribute10 in varchar2 default hr_api.g_varchar2,
3172: p_attribute11 in varchar2 default hr_api.g_varchar2,
3173: p_attribute12 in varchar2 default hr_api.g_varchar2,
3174: p_attribute13 in varchar2 default hr_api.g_varchar2,
3175: p_attribute14 in varchar2 default hr_api.g_varchar2,
3176: p_attribute15 in varchar2 default hr_api.g_varchar2,
3177: p_attribute16 in varchar2 default hr_api.g_varchar2,
3178: p_attribute17 in varchar2 default hr_api.g_varchar2,
3179: p_attribute18 in varchar2 default hr_api.g_varchar2,
3172: p_attribute11 in varchar2 default hr_api.g_varchar2,
3173: p_attribute12 in varchar2 default hr_api.g_varchar2,
3174: p_attribute13 in varchar2 default hr_api.g_varchar2,
3175: p_attribute14 in varchar2 default hr_api.g_varchar2,
3176: p_attribute15 in varchar2 default hr_api.g_varchar2,
3177: p_attribute16 in varchar2 default hr_api.g_varchar2,
3178: p_attribute17 in varchar2 default hr_api.g_varchar2,
3179: p_attribute18 in varchar2 default hr_api.g_varchar2,
3180: p_attribute19 in varchar2 default hr_api.g_varchar2,
3173: p_attribute12 in varchar2 default hr_api.g_varchar2,
3174: p_attribute13 in varchar2 default hr_api.g_varchar2,
3175: p_attribute14 in varchar2 default hr_api.g_varchar2,
3176: p_attribute15 in varchar2 default hr_api.g_varchar2,
3177: p_attribute16 in varchar2 default hr_api.g_varchar2,
3178: p_attribute17 in varchar2 default hr_api.g_varchar2,
3179: p_attribute18 in varchar2 default hr_api.g_varchar2,
3180: p_attribute19 in varchar2 default hr_api.g_varchar2,
3181: p_attribute20 in varchar2 default hr_api.g_varchar2,
3174: p_attribute13 in varchar2 default hr_api.g_varchar2,
3175: p_attribute14 in varchar2 default hr_api.g_varchar2,
3176: p_attribute15 in varchar2 default hr_api.g_varchar2,
3177: p_attribute16 in varchar2 default hr_api.g_varchar2,
3178: p_attribute17 in varchar2 default hr_api.g_varchar2,
3179: p_attribute18 in varchar2 default hr_api.g_varchar2,
3180: p_attribute19 in varchar2 default hr_api.g_varchar2,
3181: p_attribute20 in varchar2 default hr_api.g_varchar2,
3182: p_arrears_flag in varchar2 default hr_api.g_varchar2,
3175: p_attribute14 in varchar2 default hr_api.g_varchar2,
3176: p_attribute15 in varchar2 default hr_api.g_varchar2,
3177: p_attribute16 in varchar2 default hr_api.g_varchar2,
3178: p_attribute17 in varchar2 default hr_api.g_varchar2,
3179: p_attribute18 in varchar2 default hr_api.g_varchar2,
3180: p_attribute19 in varchar2 default hr_api.g_varchar2,
3181: p_attribute20 in varchar2 default hr_api.g_varchar2,
3182: p_arrears_flag in varchar2 default hr_api.g_varchar2,
3183: p_multi_assignments_flag in varchar2 default hr_api.g_varchar2,
3176: p_attribute15 in varchar2 default hr_api.g_varchar2,
3177: p_attribute16 in varchar2 default hr_api.g_varchar2,
3178: p_attribute17 in varchar2 default hr_api.g_varchar2,
3179: p_attribute18 in varchar2 default hr_api.g_varchar2,
3180: p_attribute19 in varchar2 default hr_api.g_varchar2,
3181: p_attribute20 in varchar2 default hr_api.g_varchar2,
3182: p_arrears_flag in varchar2 default hr_api.g_varchar2,
3183: p_multi_assignments_flag in varchar2 default hr_api.g_varchar2,
3184: p_prl_information_category in varchar2 default hr_api.g_varchar2,
3177: p_attribute16 in varchar2 default hr_api.g_varchar2,
3178: p_attribute17 in varchar2 default hr_api.g_varchar2,
3179: p_attribute18 in varchar2 default hr_api.g_varchar2,
3180: p_attribute19 in varchar2 default hr_api.g_varchar2,
3181: p_attribute20 in varchar2 default hr_api.g_varchar2,
3182: p_arrears_flag in varchar2 default hr_api.g_varchar2,
3183: p_multi_assignments_flag in varchar2 default hr_api.g_varchar2,
3184: p_prl_information_category in varchar2 default hr_api.g_varchar2,
3185: p_prl_information1 in varchar2 default hr_api.g_varchar2,
3178: p_attribute17 in varchar2 default hr_api.g_varchar2,
3179: p_attribute18 in varchar2 default hr_api.g_varchar2,
3180: p_attribute19 in varchar2 default hr_api.g_varchar2,
3181: p_attribute20 in varchar2 default hr_api.g_varchar2,
3182: p_arrears_flag in varchar2 default hr_api.g_varchar2,
3183: p_multi_assignments_flag in varchar2 default hr_api.g_varchar2,
3184: p_prl_information_category in varchar2 default hr_api.g_varchar2,
3185: p_prl_information1 in varchar2 default hr_api.g_varchar2,
3186: p_prl_information2 in varchar2 default hr_api.g_varchar2,
3179: p_attribute18 in varchar2 default hr_api.g_varchar2,
3180: p_attribute19 in varchar2 default hr_api.g_varchar2,
3181: p_attribute20 in varchar2 default hr_api.g_varchar2,
3182: p_arrears_flag in varchar2 default hr_api.g_varchar2,
3183: p_multi_assignments_flag in varchar2 default hr_api.g_varchar2,
3184: p_prl_information_category in varchar2 default hr_api.g_varchar2,
3185: p_prl_information1 in varchar2 default hr_api.g_varchar2,
3186: p_prl_information2 in varchar2 default hr_api.g_varchar2,
3187: p_prl_information3 in varchar2 default hr_api.g_varchar2,
3180: p_attribute19 in varchar2 default hr_api.g_varchar2,
3181: p_attribute20 in varchar2 default hr_api.g_varchar2,
3182: p_arrears_flag in varchar2 default hr_api.g_varchar2,
3183: p_multi_assignments_flag in varchar2 default hr_api.g_varchar2,
3184: p_prl_information_category in varchar2 default hr_api.g_varchar2,
3185: p_prl_information1 in varchar2 default hr_api.g_varchar2,
3186: p_prl_information2 in varchar2 default hr_api.g_varchar2,
3187: p_prl_information3 in varchar2 default hr_api.g_varchar2,
3188: p_prl_information4 in varchar2 default hr_api.g_varchar2,
3181: p_attribute20 in varchar2 default hr_api.g_varchar2,
3182: p_arrears_flag in varchar2 default hr_api.g_varchar2,
3183: p_multi_assignments_flag in varchar2 default hr_api.g_varchar2,
3184: p_prl_information_category in varchar2 default hr_api.g_varchar2,
3185: p_prl_information1 in varchar2 default hr_api.g_varchar2,
3186: p_prl_information2 in varchar2 default hr_api.g_varchar2,
3187: p_prl_information3 in varchar2 default hr_api.g_varchar2,
3188: p_prl_information4 in varchar2 default hr_api.g_varchar2,
3189: p_prl_information5 in varchar2 default hr_api.g_varchar2,
3182: p_arrears_flag in varchar2 default hr_api.g_varchar2,
3183: p_multi_assignments_flag in varchar2 default hr_api.g_varchar2,
3184: p_prl_information_category in varchar2 default hr_api.g_varchar2,
3185: p_prl_information1 in varchar2 default hr_api.g_varchar2,
3186: p_prl_information2 in varchar2 default hr_api.g_varchar2,
3187: p_prl_information3 in varchar2 default hr_api.g_varchar2,
3188: p_prl_information4 in varchar2 default hr_api.g_varchar2,
3189: p_prl_information5 in varchar2 default hr_api.g_varchar2,
3190: p_prl_information6 in varchar2 default hr_api.g_varchar2,
3183: p_multi_assignments_flag in varchar2 default hr_api.g_varchar2,
3184: p_prl_information_category in varchar2 default hr_api.g_varchar2,
3185: p_prl_information1 in varchar2 default hr_api.g_varchar2,
3186: p_prl_information2 in varchar2 default hr_api.g_varchar2,
3187: p_prl_information3 in varchar2 default hr_api.g_varchar2,
3188: p_prl_information4 in varchar2 default hr_api.g_varchar2,
3189: p_prl_information5 in varchar2 default hr_api.g_varchar2,
3190: p_prl_information6 in varchar2 default hr_api.g_varchar2,
3191: p_prl_information7 in varchar2 default hr_api.g_varchar2,
3184: p_prl_information_category in varchar2 default hr_api.g_varchar2,
3185: p_prl_information1 in varchar2 default hr_api.g_varchar2,
3186: p_prl_information2 in varchar2 default hr_api.g_varchar2,
3187: p_prl_information3 in varchar2 default hr_api.g_varchar2,
3188: p_prl_information4 in varchar2 default hr_api.g_varchar2,
3189: p_prl_information5 in varchar2 default hr_api.g_varchar2,
3190: p_prl_information6 in varchar2 default hr_api.g_varchar2,
3191: p_prl_information7 in varchar2 default hr_api.g_varchar2,
3192: p_prl_information8 in varchar2 default hr_api.g_varchar2,
3185: p_prl_information1 in varchar2 default hr_api.g_varchar2,
3186: p_prl_information2 in varchar2 default hr_api.g_varchar2,
3187: p_prl_information3 in varchar2 default hr_api.g_varchar2,
3188: p_prl_information4 in varchar2 default hr_api.g_varchar2,
3189: p_prl_information5 in varchar2 default hr_api.g_varchar2,
3190: p_prl_information6 in varchar2 default hr_api.g_varchar2,
3191: p_prl_information7 in varchar2 default hr_api.g_varchar2,
3192: p_prl_information8 in varchar2 default hr_api.g_varchar2,
3193: p_prl_information9 in varchar2 default hr_api.g_varchar2,
3186: p_prl_information2 in varchar2 default hr_api.g_varchar2,
3187: p_prl_information3 in varchar2 default hr_api.g_varchar2,
3188: p_prl_information4 in varchar2 default hr_api.g_varchar2,
3189: p_prl_information5 in varchar2 default hr_api.g_varchar2,
3190: p_prl_information6 in varchar2 default hr_api.g_varchar2,
3191: p_prl_information7 in varchar2 default hr_api.g_varchar2,
3192: p_prl_information8 in varchar2 default hr_api.g_varchar2,
3193: p_prl_information9 in varchar2 default hr_api.g_varchar2,
3194: p_prl_information10 in varchar2 default hr_api.g_varchar2,
3187: p_prl_information3 in varchar2 default hr_api.g_varchar2,
3188: p_prl_information4 in varchar2 default hr_api.g_varchar2,
3189: p_prl_information5 in varchar2 default hr_api.g_varchar2,
3190: p_prl_information6 in varchar2 default hr_api.g_varchar2,
3191: p_prl_information7 in varchar2 default hr_api.g_varchar2,
3192: p_prl_information8 in varchar2 default hr_api.g_varchar2,
3193: p_prl_information9 in varchar2 default hr_api.g_varchar2,
3194: p_prl_information10 in varchar2 default hr_api.g_varchar2,
3195: p_prl_information11 in varchar2 default hr_api.g_varchar2,
3188: p_prl_information4 in varchar2 default hr_api.g_varchar2,
3189: p_prl_information5 in varchar2 default hr_api.g_varchar2,
3190: p_prl_information6 in varchar2 default hr_api.g_varchar2,
3191: p_prl_information7 in varchar2 default hr_api.g_varchar2,
3192: p_prl_information8 in varchar2 default hr_api.g_varchar2,
3193: p_prl_information9 in varchar2 default hr_api.g_varchar2,
3194: p_prl_information10 in varchar2 default hr_api.g_varchar2,
3195: p_prl_information11 in varchar2 default hr_api.g_varchar2,
3196: p_prl_information12 in varchar2 default hr_api.g_varchar2,
3189: p_prl_information5 in varchar2 default hr_api.g_varchar2,
3190: p_prl_information6 in varchar2 default hr_api.g_varchar2,
3191: p_prl_information7 in varchar2 default hr_api.g_varchar2,
3192: p_prl_information8 in varchar2 default hr_api.g_varchar2,
3193: p_prl_information9 in varchar2 default hr_api.g_varchar2,
3194: p_prl_information10 in varchar2 default hr_api.g_varchar2,
3195: p_prl_information11 in varchar2 default hr_api.g_varchar2,
3196: p_prl_information12 in varchar2 default hr_api.g_varchar2,
3197: p_prl_information13 in varchar2 default hr_api.g_varchar2,
3190: p_prl_information6 in varchar2 default hr_api.g_varchar2,
3191: p_prl_information7 in varchar2 default hr_api.g_varchar2,
3192: p_prl_information8 in varchar2 default hr_api.g_varchar2,
3193: p_prl_information9 in varchar2 default hr_api.g_varchar2,
3194: p_prl_information10 in varchar2 default hr_api.g_varchar2,
3195: p_prl_information11 in varchar2 default hr_api.g_varchar2,
3196: p_prl_information12 in varchar2 default hr_api.g_varchar2,
3197: p_prl_information13 in varchar2 default hr_api.g_varchar2,
3198: p_prl_information14 in varchar2 default hr_api.g_varchar2,
3191: p_prl_information7 in varchar2 default hr_api.g_varchar2,
3192: p_prl_information8 in varchar2 default hr_api.g_varchar2,
3193: p_prl_information9 in varchar2 default hr_api.g_varchar2,
3194: p_prl_information10 in varchar2 default hr_api.g_varchar2,
3195: p_prl_information11 in varchar2 default hr_api.g_varchar2,
3196: p_prl_information12 in varchar2 default hr_api.g_varchar2,
3197: p_prl_information13 in varchar2 default hr_api.g_varchar2,
3198: p_prl_information14 in varchar2 default hr_api.g_varchar2,
3199: p_prl_information15 in varchar2 default hr_api.g_varchar2,
3192: p_prl_information8 in varchar2 default hr_api.g_varchar2,
3193: p_prl_information9 in varchar2 default hr_api.g_varchar2,
3194: p_prl_information10 in varchar2 default hr_api.g_varchar2,
3195: p_prl_information11 in varchar2 default hr_api.g_varchar2,
3196: p_prl_information12 in varchar2 default hr_api.g_varchar2,
3197: p_prl_information13 in varchar2 default hr_api.g_varchar2,
3198: p_prl_information14 in varchar2 default hr_api.g_varchar2,
3199: p_prl_information15 in varchar2 default hr_api.g_varchar2,
3200: p_prl_information16 in varchar2 default hr_api.g_varchar2,
3193: p_prl_information9 in varchar2 default hr_api.g_varchar2,
3194: p_prl_information10 in varchar2 default hr_api.g_varchar2,
3195: p_prl_information11 in varchar2 default hr_api.g_varchar2,
3196: p_prl_information12 in varchar2 default hr_api.g_varchar2,
3197: p_prl_information13 in varchar2 default hr_api.g_varchar2,
3198: p_prl_information14 in varchar2 default hr_api.g_varchar2,
3199: p_prl_information15 in varchar2 default hr_api.g_varchar2,
3200: p_prl_information16 in varchar2 default hr_api.g_varchar2,
3201: p_prl_information17 in varchar2 default hr_api.g_varchar2,
3194: p_prl_information10 in varchar2 default hr_api.g_varchar2,
3195: p_prl_information11 in varchar2 default hr_api.g_varchar2,
3196: p_prl_information12 in varchar2 default hr_api.g_varchar2,
3197: p_prl_information13 in varchar2 default hr_api.g_varchar2,
3198: p_prl_information14 in varchar2 default hr_api.g_varchar2,
3199: p_prl_information15 in varchar2 default hr_api.g_varchar2,
3200: p_prl_information16 in varchar2 default hr_api.g_varchar2,
3201: p_prl_information17 in varchar2 default hr_api.g_varchar2,
3202: p_prl_information18 in varchar2 default hr_api.g_varchar2,
3195: p_prl_information11 in varchar2 default hr_api.g_varchar2,
3196: p_prl_information12 in varchar2 default hr_api.g_varchar2,
3197: p_prl_information13 in varchar2 default hr_api.g_varchar2,
3198: p_prl_information14 in varchar2 default hr_api.g_varchar2,
3199: p_prl_information15 in varchar2 default hr_api.g_varchar2,
3200: p_prl_information16 in varchar2 default hr_api.g_varchar2,
3201: p_prl_information17 in varchar2 default hr_api.g_varchar2,
3202: p_prl_information18 in varchar2 default hr_api.g_varchar2,
3203: p_prl_information19 in varchar2 default hr_api.g_varchar2,
3196: p_prl_information12 in varchar2 default hr_api.g_varchar2,
3197: p_prl_information13 in varchar2 default hr_api.g_varchar2,
3198: p_prl_information14 in varchar2 default hr_api.g_varchar2,
3199: p_prl_information15 in varchar2 default hr_api.g_varchar2,
3200: p_prl_information16 in varchar2 default hr_api.g_varchar2,
3201: p_prl_information17 in varchar2 default hr_api.g_varchar2,
3202: p_prl_information18 in varchar2 default hr_api.g_varchar2,
3203: p_prl_information19 in varchar2 default hr_api.g_varchar2,
3204: p_prl_information20 in varchar2 default hr_api.g_varchar2,
3197: p_prl_information13 in varchar2 default hr_api.g_varchar2,
3198: p_prl_information14 in varchar2 default hr_api.g_varchar2,
3199: p_prl_information15 in varchar2 default hr_api.g_varchar2,
3200: p_prl_information16 in varchar2 default hr_api.g_varchar2,
3201: p_prl_information17 in varchar2 default hr_api.g_varchar2,
3202: p_prl_information18 in varchar2 default hr_api.g_varchar2,
3203: p_prl_information19 in varchar2 default hr_api.g_varchar2,
3204: p_prl_information20 in varchar2 default hr_api.g_varchar2,
3205: p_prl_information21 in varchar2 default hr_api.g_varchar2,
3198: p_prl_information14 in varchar2 default hr_api.g_varchar2,
3199: p_prl_information15 in varchar2 default hr_api.g_varchar2,
3200: p_prl_information16 in varchar2 default hr_api.g_varchar2,
3201: p_prl_information17 in varchar2 default hr_api.g_varchar2,
3202: p_prl_information18 in varchar2 default hr_api.g_varchar2,
3203: p_prl_information19 in varchar2 default hr_api.g_varchar2,
3204: p_prl_information20 in varchar2 default hr_api.g_varchar2,
3205: p_prl_information21 in varchar2 default hr_api.g_varchar2,
3206: p_prl_information22 in varchar2 default hr_api.g_varchar2,
3199: p_prl_information15 in varchar2 default hr_api.g_varchar2,
3200: p_prl_information16 in varchar2 default hr_api.g_varchar2,
3201: p_prl_information17 in varchar2 default hr_api.g_varchar2,
3202: p_prl_information18 in varchar2 default hr_api.g_varchar2,
3203: p_prl_information19 in varchar2 default hr_api.g_varchar2,
3204: p_prl_information20 in varchar2 default hr_api.g_varchar2,
3205: p_prl_information21 in varchar2 default hr_api.g_varchar2,
3206: p_prl_information22 in varchar2 default hr_api.g_varchar2,
3207: p_prl_information23 in varchar2 default hr_api.g_varchar2,
3200: p_prl_information16 in varchar2 default hr_api.g_varchar2,
3201: p_prl_information17 in varchar2 default hr_api.g_varchar2,
3202: p_prl_information18 in varchar2 default hr_api.g_varchar2,
3203: p_prl_information19 in varchar2 default hr_api.g_varchar2,
3204: p_prl_information20 in varchar2 default hr_api.g_varchar2,
3205: p_prl_information21 in varchar2 default hr_api.g_varchar2,
3206: p_prl_information22 in varchar2 default hr_api.g_varchar2,
3207: p_prl_information23 in varchar2 default hr_api.g_varchar2,
3208: p_prl_information24 in varchar2 default hr_api.g_varchar2,
3201: p_prl_information17 in varchar2 default hr_api.g_varchar2,
3202: p_prl_information18 in varchar2 default hr_api.g_varchar2,
3203: p_prl_information19 in varchar2 default hr_api.g_varchar2,
3204: p_prl_information20 in varchar2 default hr_api.g_varchar2,
3205: p_prl_information21 in varchar2 default hr_api.g_varchar2,
3206: p_prl_information22 in varchar2 default hr_api.g_varchar2,
3207: p_prl_information23 in varchar2 default hr_api.g_varchar2,
3208: p_prl_information24 in varchar2 default hr_api.g_varchar2,
3209: p_prl_information25 in varchar2 default hr_api.g_varchar2,
3202: p_prl_information18 in varchar2 default hr_api.g_varchar2,
3203: p_prl_information19 in varchar2 default hr_api.g_varchar2,
3204: p_prl_information20 in varchar2 default hr_api.g_varchar2,
3205: p_prl_information21 in varchar2 default hr_api.g_varchar2,
3206: p_prl_information22 in varchar2 default hr_api.g_varchar2,
3207: p_prl_information23 in varchar2 default hr_api.g_varchar2,
3208: p_prl_information24 in varchar2 default hr_api.g_varchar2,
3209: p_prl_information25 in varchar2 default hr_api.g_varchar2,
3210: p_prl_information26 in varchar2 default hr_api.g_varchar2,
3203: p_prl_information19 in varchar2 default hr_api.g_varchar2,
3204: p_prl_information20 in varchar2 default hr_api.g_varchar2,
3205: p_prl_information21 in varchar2 default hr_api.g_varchar2,
3206: p_prl_information22 in varchar2 default hr_api.g_varchar2,
3207: p_prl_information23 in varchar2 default hr_api.g_varchar2,
3208: p_prl_information24 in varchar2 default hr_api.g_varchar2,
3209: p_prl_information25 in varchar2 default hr_api.g_varchar2,
3210: p_prl_information26 in varchar2 default hr_api.g_varchar2,
3211: p_prl_information27 in varchar2 default hr_api.g_varchar2,
3204: p_prl_information20 in varchar2 default hr_api.g_varchar2,
3205: p_prl_information21 in varchar2 default hr_api.g_varchar2,
3206: p_prl_information22 in varchar2 default hr_api.g_varchar2,
3207: p_prl_information23 in varchar2 default hr_api.g_varchar2,
3208: p_prl_information24 in varchar2 default hr_api.g_varchar2,
3209: p_prl_information25 in varchar2 default hr_api.g_varchar2,
3210: p_prl_information26 in varchar2 default hr_api.g_varchar2,
3211: p_prl_information27 in varchar2 default hr_api.g_varchar2,
3212: p_prl_information28 in varchar2 default hr_api.g_varchar2,
3205: p_prl_information21 in varchar2 default hr_api.g_varchar2,
3206: p_prl_information22 in varchar2 default hr_api.g_varchar2,
3207: p_prl_information23 in varchar2 default hr_api.g_varchar2,
3208: p_prl_information24 in varchar2 default hr_api.g_varchar2,
3209: p_prl_information25 in varchar2 default hr_api.g_varchar2,
3210: p_prl_information26 in varchar2 default hr_api.g_varchar2,
3211: p_prl_information27 in varchar2 default hr_api.g_varchar2,
3212: p_prl_information28 in varchar2 default hr_api.g_varchar2,
3213: p_prl_information29 in varchar2 default hr_api.g_varchar2,
3206: p_prl_information22 in varchar2 default hr_api.g_varchar2,
3207: p_prl_information23 in varchar2 default hr_api.g_varchar2,
3208: p_prl_information24 in varchar2 default hr_api.g_varchar2,
3209: p_prl_information25 in varchar2 default hr_api.g_varchar2,
3210: p_prl_information26 in varchar2 default hr_api.g_varchar2,
3211: p_prl_information27 in varchar2 default hr_api.g_varchar2,
3212: p_prl_information28 in varchar2 default hr_api.g_varchar2,
3213: p_prl_information29 in varchar2 default hr_api.g_varchar2,
3214: p_prl_information30 in varchar2 default hr_api.g_varchar2,
3207: p_prl_information23 in varchar2 default hr_api.g_varchar2,
3208: p_prl_information24 in varchar2 default hr_api.g_varchar2,
3209: p_prl_information25 in varchar2 default hr_api.g_varchar2,
3210: p_prl_information26 in varchar2 default hr_api.g_varchar2,
3211: p_prl_information27 in varchar2 default hr_api.g_varchar2,
3212: p_prl_information28 in varchar2 default hr_api.g_varchar2,
3213: p_prl_information29 in varchar2 default hr_api.g_varchar2,
3214: p_prl_information30 in varchar2 default hr_api.g_varchar2,
3215: p_prl_effective_start_date out nocopy date,
3208: p_prl_information24 in varchar2 default hr_api.g_varchar2,
3209: p_prl_information25 in varchar2 default hr_api.g_varchar2,
3210: p_prl_information26 in varchar2 default hr_api.g_varchar2,
3211: p_prl_information27 in varchar2 default hr_api.g_varchar2,
3212: p_prl_information28 in varchar2 default hr_api.g_varchar2,
3213: p_prl_information29 in varchar2 default hr_api.g_varchar2,
3214: p_prl_information30 in varchar2 default hr_api.g_varchar2,
3215: p_prl_effective_start_date out nocopy date,
3216: p_prl_effective_end_date out nocopy date,
3209: p_prl_information25 in varchar2 default hr_api.g_varchar2,
3210: p_prl_information26 in varchar2 default hr_api.g_varchar2,
3211: p_prl_information27 in varchar2 default hr_api.g_varchar2,
3212: p_prl_information28 in varchar2 default hr_api.g_varchar2,
3213: p_prl_information29 in varchar2 default hr_api.g_varchar2,
3214: p_prl_information30 in varchar2 default hr_api.g_varchar2,
3215: p_prl_effective_start_date out nocopy date,
3216: p_prl_effective_end_date out nocopy date,
3217: p_comment_id out nocopy number
3210: p_prl_information26 in varchar2 default hr_api.g_varchar2,
3211: p_prl_information27 in varchar2 default hr_api.g_varchar2,
3212: p_prl_information28 in varchar2 default hr_api.g_varchar2,
3213: p_prl_information29 in varchar2 default hr_api.g_varchar2,
3214: p_prl_information30 in varchar2 default hr_api.g_varchar2,
3215: p_prl_effective_start_date out nocopy date,
3216: p_prl_effective_end_date out nocopy date,
3217: p_comment_id out nocopy number
3218: ) is
3244: --
3245: hr_utility.set_location('Entering:'||l_proc, 5);
3246: hr_utility.trace('p_effective_date : '||to_char(p_effective_date));
3247: --Get the business group id from the payroll id.
3248: if (p_consolidation_set_id = hr_api.g_number) then
3249: open csr_get_BG;
3250: fetch csr_get_BG into l_business_group_id;
3251: if (csr_get_BG % NOTFOUND) then
3252: close csr_get_BG;
3258: pay_pay_bus.chk_consolidation_set_id(p_consolidation_set_id, l_business_group_id);
3259: end if;
3260:
3261: --Get the Legislation code.
3262: l_legislation_code := hr_api.return_legislation_code(l_business_group_id);
3263:
3264: if(l_legislation_code <> p_prl_information_category and
3265: p_prl_information_category <> hr_api.g_varchar2) then
3266: fnd_message.set_name('PAY', 'PAY_33275_INFOCATEGORY_INVALID');
3261: --Get the Legislation code.
3262: l_legislation_code := hr_api.return_legislation_code(l_business_group_id);
3263:
3264: if(l_legislation_code <> p_prl_information_category and
3265: p_prl_information_category <> hr_api.g_varchar2) then
3266: fnd_message.set_name('PAY', 'PAY_33275_INFOCATEGORY_INVALID');
3267: fnd_message.raise_error;
3268: end if;
3269: