eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PAYROLL_API dependencies on HR_API

Line 140: When HR_Api.Object_Locked then

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

Line 285: When HR_Api.Object_Locked then

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

Line 610: l_legislation_code := hr_api.return_legislation_code(l_business_group_id);

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

Line 615: hr_api.validate_bus_grp_id

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:

Line 863: when hr_api.cannot_find_prog_unit then

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: );

Line 864: hr_api.cannot_find_prog_unit_error

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;

Line 1410: when hr_api.cannot_find_prog_unit then

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: );

Line 1411: hr_api.cannot_find_prog_unit_error

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

Line 1420: raise hr_api.validate_enabled;

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.

Line 1488: when hr_api.validate_enabled then

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;

Line 1549: p_payroll_name in varchar2 default hr_api.g_varchar2,

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,

Line 1550: p_number_of_years 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,

Line 1551: p_default_payment_method_id 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,

Line 1552: p_consolidation_set_id in number default hr_api.g_number,

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,

Line 1553: p_cost_alloc_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,

Line 1554: p_susp_account_keyflex_id_in in number default hr_api.g_number,

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,

Line 1555: p_negative_pay_allowed_flag 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,

Line 1556: p_soft_coding_keyflex_id_in 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,
1560: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 1557: p_comments 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,

Line 1558: p_attribute_category 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,

Line 1559: p_attribute1 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,

Line 1560: p_attribute2 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,

Line 1561: p_attribute3 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,

Line 1562: p_attribute4 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,

Line 1563: p_attribute5 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,

Line 1564: p_attribute6 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,

Line 1565: p_attribute7 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,

Line 1566: p_attribute8 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,

Line 1567: p_attribute9 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,

Line 1568: p_attribute10 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,

Line 1569: p_attribute11 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,

Line 1570: p_attribute12 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,

Line 1571: p_attribute13 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,

Line 1572: p_attribute14 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,

Line 1573: p_attribute15 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,

Line 1574: p_attribute16 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,

Line 1575: p_attribute17 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,

Line 1576: p_attribute18 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,

Line 1577: p_attribute19 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,

Line 1578: p_attribute20 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,

Line 1579: p_arrears_flag 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,

Line 1580: p_multi_assignments_flag 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,

Line 1581: p_prl_information1 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,

Line 1582: p_prl_information2 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,

Line 1583: p_prl_information3 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,

Line 1584: p_prl_information4 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,

Line 1585: p_prl_information5 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,

Line 1586: p_prl_information6 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,

Line 1587: p_prl_information7 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,

Line 1588: p_prl_information8 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,

Line 1589: p_prl_information9 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,

Line 1590: p_prl_information10 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,

Line 1591: p_prl_information11 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,

Line 1592: p_prl_information12 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,

Line 1593: p_prl_information13 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,

Line 1594: p_prl_information14 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,

Line 1595: p_prl_information15 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,

Line 1596: p_prl_information16 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,

Line 1597: p_prl_information17 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,

Line 1598: p_prl_information18 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,

Line 1599: p_prl_information19 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,

Line 1600: p_prl_information20 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,

Line 1601: p_prl_information21 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,

Line 1602: p_prl_information22 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,

Line 1603: p_prl_information23 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,

Line 1604: p_prl_information24 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,

Line 1605: p_prl_information25 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,

Line 1606: p_prl_information26 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,

Line 1607: p_prl_information27 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:

Line 1608: p_prl_information28 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:
1612: p_cost_segment1 in varchar2 default hr_api.g_varchar2,

Line 1609: p_prl_information29 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,

Line 1610: p_prl_information30 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,

Line 1612: p_cost_segment1 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,

Line 1613: p_cost_segment2 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,

Line 1614: p_cost_segment3 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,

Line 1615: p_cost_segment4 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,

Line 1616: p_cost_segment5 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,

Line 1617: p_cost_segment6 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,

Line 1618: p_cost_segment7 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,

Line 1619: p_cost_segment8 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,

Line 1620: p_cost_segment9 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,

Line 1621: p_cost_segment10 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,

Line 1622: p_cost_segment11 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,

Line 1623: p_cost_segment12 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,

Line 1624: p_cost_segment13 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,

Line 1625: p_cost_segment14 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,

Line 1626: p_cost_segment15 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,

Line 1627: p_cost_segment16 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,

Line 1628: p_cost_segment17 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,

Line 1629: p_cost_segment18 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,

Line 1630: p_cost_segment19 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,

Line 1631: p_cost_segment20 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,

Line 1632: p_cost_segment21 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,

Line 1633: p_cost_segment22 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,

Line 1634: p_cost_segment23 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,

Line 1635: p_cost_segment24 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,

Line 1636: p_cost_segment25 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,

Line 1637: p_cost_segment26 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,

Line 1638: p_cost_segment27 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,

Line 1639: p_cost_segment28 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:

Line 1640: p_cost_segment29 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:
1644: p_susp_segment1 in varchar2 default hr_api.g_varchar2,

Line 1641: p_cost_segment30 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,

Line 1642: p_cost_concat_segments_in 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,

Line 1644: p_susp_segment1 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,

Line 1645: p_susp_segment2 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,

Line 1646: p_susp_segment3 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,

Line 1647: p_susp_segment4 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,

Line 1648: p_susp_segment5 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,

Line 1649: p_susp_segment6 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,

Line 1650: p_susp_segment7 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,

Line 1651: p_susp_segment8 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,

Line 1652: p_susp_segment9 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,

Line 1653: p_susp_segment10 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,

Line 1654: p_susp_segment11 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,

Line 1655: p_susp_segment12 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,

Line 1656: p_susp_segment13 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,

Line 1657: p_susp_segment14 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,

Line 1658: p_susp_segment15 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,

Line 1659: p_susp_segment16 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,

Line 1660: p_susp_segment17 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,

Line 1661: p_susp_segment18 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,

Line 1662: p_susp_segment19 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,

Line 1663: p_susp_segment20 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,

Line 1664: p_susp_segment21 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,

Line 1665: p_susp_segment22 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,

Line 1666: p_susp_segment23 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,

Line 1667: p_susp_segment24 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,

Line 1668: p_susp_segment25 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,

Line 1669: p_susp_segment26 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,

Line 1670: p_susp_segment27 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,

Line 1671: p_susp_segment28 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:

Line 1672: p_susp_segment29 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:
1676: p_scl_segment1 in varchar2 default hr_api.g_varchar2,

Line 1673: p_susp_segment30 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,

Line 1674: p_susp_concat_segments_in 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,

Line 1676: p_scl_segment1 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,

Line 1677: p_scl_segment2 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,

Line 1678: p_scl_segment3 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,

Line 1679: p_scl_segment4 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,

Line 1680: p_scl_segment5 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,

Line 1681: p_scl_segment6 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,

Line 1682: p_scl_segment7 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,

Line 1683: p_scl_segment8 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,

Line 1684: p_scl_segment9 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,

Line 1685: p_scl_segment10 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,

Line 1686: p_scl_segment11 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,

Line 1687: p_scl_segment12 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,

Line 1688: p_scl_segment13 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,

Line 1689: p_scl_segment14 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,

Line 1690: p_scl_segment15 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,

Line 1691: p_scl_segment16 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,

Line 1692: p_scl_segment17 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,

Line 1693: p_scl_segment18 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,

Line 1694: p_scl_segment19 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,

Line 1695: p_scl_segment20 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,

Line 1696: p_scl_segment21 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,

Line 1697: p_scl_segment22 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,

Line 1698: p_scl_segment23 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,

Line 1699: p_scl_segment24 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,

Line 1700: p_scl_segment25 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,

Line 1701: p_scl_segment26 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,

Line 1702: p_scl_segment27 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,

Line 1703: p_scl_segment28 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:

Line 1704: p_scl_segment29 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:
1708: p_workload_shifting_level in varchar2 default hr_api.g_varchar2,

Line 1705: p_scl_segment30 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,

Line 1706: p_scl_concat_segments_in 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,
1710:

Line 1708: p_workload_shifting_level 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:
1711: p_payroll_id in out nocopy number,
1712: p_object_version_number in out nocopy number,

Line 1709: p_payslip_view_date_offset in number default hr_api.g_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:

Line 1740: l_prl_information_category pay_all_payrolls_f.prl_information_category%TYPE := hr_api.g_varchar2;

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 ;

Line 1870: if(p_consolidation_set_id = hr_api.g_number) then

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;

Line 1883: l_legislation_code := hr_api.return_legislation_code(l_business_group_id);

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

Line 1888: hr_api.validate_bus_grp_id

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:

Line 1900: and (p_cost_alloc_keyflex_id_in <> hr_api.g_number)) then

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

Line 1921: and (p_susp_account_keyflex_id_in <> hr_api.g_number)) 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: --

Line 1942: and (p_soft_coding_keyflex_id_in <>hr_api.g_number))then

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

Line 2133: when hr_api.cannot_find_prog_unit 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: --

Line 2134: hr_api.cannot_find_prog_unit_error

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;

Line 2140: if (p_cost_alloc_keyflex_id_in = hr_api.g_number) and

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

Line 2141: (p_cost_segment1 <> hr_api.g_varchar2 or p_cost_segment2 <> 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

Line 2142: p_cost_segment3 <> hr_api.g_varchar2 or p_cost_segment4 <> 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

Line 2143: p_cost_segment5 <> hr_api.g_varchar2 or p_cost_segment6 <> 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

Line 2144: p_cost_segment7 <> hr_api.g_varchar2 or p_cost_segment8 <> 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

Line 2145: p_cost_segment9 <> hr_api.g_varchar2 or p_cost_segment10 <> 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

Line 2146: p_cost_segment11 <> hr_api.g_varchar2 or p_cost_segment12 <> 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

Line 2147: p_cost_segment13 <> hr_api.g_varchar2 or p_cost_segment14 <> 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

Line 2148: p_cost_segment15 <> hr_api.g_varchar2 or p_cost_segment16 <> 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

Line 2149: p_cost_segment17 <> hr_api.g_varchar2 or p_cost_segment18 <> 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

Line 2150: p_cost_segment19 <> hr_api.g_varchar2 or p_cost_segment20 <> 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

Line 2151: p_cost_segment21 <> hr_api.g_varchar2 or p_cost_segment22 <> 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

Line 2152: p_cost_segment23 <> hr_api.g_varchar2 or p_cost_segment24 <> 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)

Line 2153: p_cost_segment25 <> hr_api.g_varchar2 or p_cost_segment26 <> 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)
2157: then

Line 2154: p_cost_segment27 <> hr_api.g_varchar2 or p_cost_segment28 <> 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
2158: --

Line 2155: p_cost_segment29 <> hr_api.g_varchar2 or p_cost_segment30 <> 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: --
2159: --

Line 2156: p_cost_concat_segments_in <> hr_api.g_varchar2)

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.

Line 2228: if (p_susp_account_keyflex_id_in = hr_api.g_number) and

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

Line 2229: (p_susp_segment1 <> hr_api.g_varchar2 or p_susp_segment2 <> 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

Line 2230: p_susp_segment3 <> hr_api.g_varchar2 or p_susp_segment4 <> 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

Line 2231: p_susp_segment5 <> hr_api.g_varchar2 or p_susp_segment6 <> 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

Line 2232: p_susp_segment7 <> hr_api.g_varchar2 or p_susp_segment8 <> 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

Line 2233: p_susp_segment9 <> hr_api.g_varchar2 or p_susp_segment10 <> 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

Line 2234: p_susp_segment11 <> hr_api.g_varchar2 or p_susp_segment12 <> 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

Line 2235: p_susp_segment13 <> hr_api.g_varchar2 or p_susp_segment14 <> 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

Line 2236: p_susp_segment15 <> hr_api.g_varchar2 or p_susp_segment16 <> 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

Line 2237: p_susp_segment17 <> hr_api.g_varchar2 or p_susp_segment18 <> 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

Line 2238: p_susp_segment19 <> hr_api.g_varchar2 or p_susp_segment20 <> 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

Line 2239: p_susp_segment21 <> hr_api.g_varchar2 or p_susp_segment22 <> 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

Line 2240: p_susp_segment23 <> hr_api.g_varchar2 or p_susp_segment24 <> 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)

Line 2241: p_susp_segment25 <> hr_api.g_varchar2 or p_susp_segment26 <> 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)
2245: then

Line 2242: p_susp_segment27 <> hr_api.g_varchar2 or p_susp_segment28 <> 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
2246: --

Line 2243: p_susp_segment29 <> hr_api.g_varchar2 or p_susp_segment30 <> 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: --
2247: --

Line 2244: p_susp_concat_segments_in <> hr_api.g_varchar2)

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.

Line 2315: if (p_soft_coding_keyflex_id_in = hr_api.g_number) and

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

Line 2316: (p_scl_segment1 <> hr_api.g_varchar2 or p_scl_segment2 <> 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

Line 2317: p_scl_segment3 <> hr_api.g_varchar2 or p_scl_segment4 <> 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

Line 2318: p_scl_segment5 <> hr_api.g_varchar2 or p_scl_segment6 <> 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

Line 2319: p_scl_segment7 <> hr_api.g_varchar2 or p_scl_segment8 <> 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

Line 2320: p_scl_segment9 <> hr_api.g_varchar2 or p_scl_segment10 <> 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

Line 2321: p_scl_segment11 <> hr_api.g_varchar2 or p_scl_segment12 <> 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

Line 2322: p_scl_segment13 <> hr_api.g_varchar2 or p_scl_segment14 <> 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

Line 2323: p_scl_segment15 <> hr_api.g_varchar2 or p_scl_segment16 <> 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

Line 2324: p_scl_segment17 <> hr_api.g_varchar2 or p_scl_segment18 <> 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

Line 2325: p_scl_segment19 <> hr_api.g_varchar2 or p_scl_segment20 <> 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

Line 2326: p_scl_segment21 <> hr_api.g_varchar2 or p_scl_segment22 <> 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

Line 2327: p_scl_segment23 <> hr_api.g_varchar2 or p_scl_segment24 <> 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)

Line 2328: p_scl_segment25 <> hr_api.g_varchar2 or p_scl_segment26 <> 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)
2332: then

Line 2329: p_scl_segment27 <> hr_api.g_varchar2 or p_scl_segment28 <> 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
2333: --

Line 2330: p_scl_segment29 <> hr_api.g_varchar2 or p_scl_segment30 <> 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: --
2334: --

Line 2331: p_scl_concat_segments_in <> hr_api.g_varchar2)

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.

Line 2404: if ((p_prl_information1 <> hr_api.g_varchar2) or (p_prl_information2 <> hr_api.g_varchar2) or

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

Line 2405: (p_prl_information3 <> hr_api.g_varchar2) or (p_prl_information4 <> 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

Line 2406: (p_prl_information5 <> hr_api.g_varchar2) or (p_prl_information6 <> 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

Line 2407: (p_prl_information7 <> hr_api.g_varchar2) or (p_prl_information8 <> 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

Line 2408: (p_prl_information9 <> hr_api.g_varchar2) or (p_prl_information10 <> 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

Line 2409: (p_prl_information11 <> hr_api.g_varchar2) or (p_prl_information12 <> 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

Line 2410: (p_prl_information13 <> hr_api.g_varchar2) or (p_prl_information14 <> 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

Line 2411: (p_prl_information15 <> hr_api.g_varchar2) or (p_prl_information16 <> 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

Line 2412: (p_prl_information17 <> hr_api.g_varchar2) or (p_prl_information18 <> 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

Line 2413: (p_prl_information19 <> hr_api.g_varchar2) or (p_prl_information20 <> 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

Line 2414: (p_prl_information21 <> hr_api.g_varchar2) or (p_prl_information22 <> 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

Line 2415: (p_prl_information23 <> hr_api.g_varchar2) or (p_prl_information24 <> 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
2419: --

Line 2416: (p_prl_information25 <> hr_api.g_varchar2) or (p_prl_information26 <> 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: --
2420: l_prl_information_category := l_legislation_code;

Line 2417: (p_prl_information27 <> hr_api.g_varchar2) or (p_prl_information28 <> 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;
2421: --

Line 2418: (p_prl_information29 <> hr_api.g_varchar2) or (p_prl_information30 <> hr_api.g_varchar2)) then

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;

Line 2693: when hr_api.cannot_find_prog_unit then

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: );

Line 2694: hr_api.cannot_find_prog_unit_error

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

Line 2703: raise hr_api.validate_enabled;

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

Line 2719: if ((p_cost_alloc_keyflex_id_in = hr_api.g_number) and (l_cost_flag = false)) then

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;

Line 2727: if ((p_susp_account_keyflex_id_in = hr_api.g_number) and (l_susp_flag = false))then

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;

Line 2735: if ((p_soft_coding_keyflex_id_in = hr_api.g_number) and (l_soft_flag = false))then

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;

Line 2745: when hr_api.validate_enabled then

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;

Line 2825: when hr_api.cannot_find_prog_unit then

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: );

Line 2826: hr_api.cannot_find_prog_unit_error

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

Line 2852: when hr_api.cannot_find_prog_unit then

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: );

Line 2853: hr_api.cannot_find_prog_unit_error

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

Line 2863: raise hr_api.validate_enabled;

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.

Line 2875: when hr_api.validate_enabled then

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;

Line 3023: l_legislation_code := hr_api.return_legislation_code(l_business_group_id);

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;

Line 3152: p_payroll_name in varchar2 default hr_api.g_varchar2,

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,

Line 3153: p_number_of_years 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,

Line 3154: p_default_payment_method_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,

Line 3155: p_consolidation_set_id in number default hr_api.g_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,
3159: p_soft_coding_keyflex_id in number default hr_api.g_number,

Line 3156: p_cost_allocation_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,

Line 3157: p_suspense_account_keyflex_id in number default hr_api.g_number,

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,

Line 3158: p_negative_pay_allowed_flag 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,

Line 3159: p_soft_coding_keyflex_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,
3163: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 3160: p_comments 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,

Line 3161: p_attribute_category 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,

Line 3162: p_attribute1 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,

Line 3163: p_attribute2 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,

Line 3164: p_attribute3 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,

Line 3165: p_attribute4 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,

Line 3166: p_attribute5 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,

Line 3167: p_attribute6 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,

Line 3168: p_attribute7 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,

Line 3169: p_attribute8 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,

Line 3170: p_attribute9 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,

Line 3171: p_attribute10 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,

Line 3172: p_attribute11 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,

Line 3173: p_attribute12 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,

Line 3174: p_attribute13 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,

Line 3175: p_attribute14 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,

Line 3176: p_attribute15 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,

Line 3177: p_attribute16 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,

Line 3178: p_attribute17 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,

Line 3179: p_attribute18 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,

Line 3180: p_attribute19 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,

Line 3181: p_attribute20 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,

Line 3182: p_arrears_flag 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,

Line 3183: p_multi_assignments_flag 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,

Line 3184: p_prl_information_category 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,

Line 3185: p_prl_information1 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,

Line 3186: p_prl_information2 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,

Line 3187: p_prl_information3 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,

Line 3188: p_prl_information4 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,

Line 3189: p_prl_information5 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,

Line 3190: p_prl_information6 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,

Line 3191: p_prl_information7 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,

Line 3192: p_prl_information8 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,

Line 3193: p_prl_information9 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,

Line 3194: p_prl_information10 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,

Line 3195: p_prl_information11 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,

Line 3196: p_prl_information12 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,

Line 3197: p_prl_information13 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,

Line 3198: p_prl_information14 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,

Line 3199: p_prl_information15 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,

Line 3200: p_prl_information16 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,

Line 3201: p_prl_information17 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,

Line 3202: p_prl_information18 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,

Line 3203: p_prl_information19 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,

Line 3204: p_prl_information20 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,

Line 3205: p_prl_information21 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,

Line 3206: p_prl_information22 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,

Line 3207: p_prl_information23 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,

Line 3208: p_prl_information24 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,

Line 3209: p_prl_information25 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,

Line 3210: p_prl_information26 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,

Line 3211: p_prl_information27 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,

Line 3212: p_prl_information28 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,
3216: p_prl_effective_end_date out nocopy date,

Line 3213: p_prl_information29 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,
3217: p_comment_id out nocopy number

Line 3214: p_prl_information30 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
3218: ) is

Line 3248: if (p_consolidation_set_id = hr_api.g_number) then

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;

Line 3262: l_legislation_code := hr_api.return_legislation_code(l_business_group_id);

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');

Line 3265: p_prl_information_category <> hr_api.g_varchar2) then

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: