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.HR_PERSONAL_PAY_METHOD_API dependencies on HR_API

Line 72: hr_api.mandatory_arg_error

68: --
69: -- Check that p_assignment_id and p_effective_date are not null as they
70: -- are used by the cursor to validate the business group.
71: --
72: hr_api.mandatory_arg_error
73: (p_api_name => l_proc,
74: p_argument => 'assignment_id',
75: p_argument_value => p_assignment_id);
76: --

Line 77: hr_api.mandatory_arg_error

73: (p_api_name => l_proc,
74: p_argument => 'assignment_id',
75: p_argument_value => p_assignment_id);
76: --
77: hr_api.mandatory_arg_error
78: (p_api_name => l_proc,
79: p_argument => 'effective_date',
80: p_argument_value => p_effective_date);
81: --

Line 726: hr_api.mandatory_arg_error

722: --
723: -- Check that p_assignment_id and p_effective_date are not null as they
724: -- are used by the cursor to derive the business group.
725: --
726: hr_api.mandatory_arg_error
727: (p_api_name => l_proc,
728: p_argument => 'assignment_id',
729: p_argument_value => p_assignment_id
730: );

Line 732: hr_api.mandatory_arg_error

728: p_argument => 'assignment_id',
729: p_argument_value => p_assignment_id
730: );
731: --
732: hr_api.mandatory_arg_error
733: (p_api_name => l_proc
734: ,p_argument => 'org_payment_method_id'
735: ,p_argument_value => p_org_payment_method_id
736: );

Line 738: hr_api.mandatory_arg_error

734: ,p_argument => 'org_payment_method_id'
735: ,p_argument_value => p_org_payment_method_id
736: );
737: --
738: hr_api.mandatory_arg_error
739: (p_api_name => l_proc,
740: p_argument => 'effective_date',
741: p_argument_value => p_effective_date);
742: if g_debug then

Line 847: when hr_api.cannot_find_prog_unit then

843: ,p_ppm_information29 => p_ppm_information29
844: ,p_ppm_information30 => p_ppm_information30
845: );
846: exception
847: when hr_api.cannot_find_prog_unit then
848: hr_api.cannot_find_prog_unit_error
849: (p_module_name => 'CREATE_PERSONAL_PAY_METHOD'
850: ,p_hook_type => 'BP'
851: );

Line 848: hr_api.cannot_find_prog_unit_error

844: ,p_ppm_information30 => p_ppm_information30
845: );
846: exception
847: when hr_api.cannot_find_prog_unit then
848: hr_api.cannot_find_prog_unit_error
849: (p_module_name => 'CREATE_PERSONAL_PAY_METHOD'
850: ,p_hook_type => 'BP'
851: );
852: --

Line 1036: ,p_prenote_date => hr_api.g_date

1032: ,p_validate => l_validate
1033: --
1034: -- Special p_prenote_date value after bug2307154 changes.
1035: --
1036: ,p_prenote_date => hr_api.g_date
1037: );
1038: end if;
1039: --
1040: if g_debug then

Line 1243: when hr_api.cannot_find_prog_unit then

1239: ,p_ppm_information29 => p_ppm_information29
1240: ,p_ppm_information30 => p_ppm_information30
1241: );
1242: exception
1243: when hr_api.cannot_find_prog_unit then
1244: hr_api.cannot_find_prog_unit_error
1245: (p_module_name => 'CREATE_PERSONAL_PAY_METHOD'
1246: ,p_hook_type => 'AP'
1247: );

Line 1244: hr_api.cannot_find_prog_unit_error

1240: ,p_ppm_information30 => p_ppm_information30
1241: );
1242: exception
1243: when hr_api.cannot_find_prog_unit then
1244: hr_api.cannot_find_prog_unit_error
1245: (p_module_name => 'CREATE_PERSONAL_PAY_METHOD'
1246: ,p_hook_type => 'AP'
1247: );
1248: --

Line 1256: raise hr_api.validate_enabled;

1252: --
1253: -- When in validation only mode raise the Validate_Enabled exception
1254: --
1255: if p_validate then
1256: raise hr_api.validate_enabled;
1257: end if;
1258: --
1259: -- Set remaining output arguments
1260: --

Line 1272: when hr_api.validate_enabled then

1268: if g_debug then
1269: hr_utility.set_location(' Leaving:'||l_proc, 80);
1270: end if;
1271: exception
1272: when hr_api.validate_enabled then
1273: --
1274: -- As the Validate_Enabled exception has been raised
1275: -- we must rollback to the savepoint
1276: --

Line 1803: ,p_amount in number default hr_api.g_number

1799: ,p_effective_date in date
1800: ,p_datetrack_update_mode in varchar2
1801: ,p_personal_payment_method_id in number
1802: ,p_object_version_number in out nocopy number
1803: ,p_amount in number default hr_api.g_number
1804: ,p_comments in varchar2 default hr_api.g_varchar2
1805: ,p_percentage in number default hr_api.g_number
1806: ,p_priority in number default hr_api.g_number
1807: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 1804: ,p_comments in varchar2 default hr_api.g_varchar2

1800: ,p_datetrack_update_mode in varchar2
1801: ,p_personal_payment_method_id in number
1802: ,p_object_version_number in out nocopy number
1803: ,p_amount in number default hr_api.g_number
1804: ,p_comments in varchar2 default hr_api.g_varchar2
1805: ,p_percentage in number default hr_api.g_number
1806: ,p_priority in number default hr_api.g_number
1807: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1808: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 1805: ,p_percentage in number default hr_api.g_number

1801: ,p_personal_payment_method_id in number
1802: ,p_object_version_number in out nocopy number
1803: ,p_amount in number default hr_api.g_number
1804: ,p_comments in varchar2 default hr_api.g_varchar2
1805: ,p_percentage in number default hr_api.g_number
1806: ,p_priority in number default hr_api.g_number
1807: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1808: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1809: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 1806: ,p_priority in number default hr_api.g_number

1802: ,p_object_version_number in out nocopy number
1803: ,p_amount in number default hr_api.g_number
1804: ,p_comments in varchar2 default hr_api.g_varchar2
1805: ,p_percentage in number default hr_api.g_number
1806: ,p_priority in number default hr_api.g_number
1807: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1808: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1809: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1810: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 1807: ,p_attribute_category in varchar2 default hr_api.g_varchar2

1803: ,p_amount in number default hr_api.g_number
1804: ,p_comments in varchar2 default hr_api.g_varchar2
1805: ,p_percentage in number default hr_api.g_number
1806: ,p_priority in number default hr_api.g_number
1807: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1808: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1809: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1810: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1811: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 1808: ,p_attribute1 in varchar2 default hr_api.g_varchar2

1804: ,p_comments in varchar2 default hr_api.g_varchar2
1805: ,p_percentage in number default hr_api.g_number
1806: ,p_priority in number default hr_api.g_number
1807: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1808: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1809: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1810: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1811: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1812: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 1809: ,p_attribute2 in varchar2 default hr_api.g_varchar2

1805: ,p_percentage in number default hr_api.g_number
1806: ,p_priority in number default hr_api.g_number
1807: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1808: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1809: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1810: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1811: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1812: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1813: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 1810: ,p_attribute3 in varchar2 default hr_api.g_varchar2

1806: ,p_priority in number default hr_api.g_number
1807: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1808: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1809: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1810: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1811: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1812: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1813: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1814: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 1811: ,p_attribute4 in varchar2 default hr_api.g_varchar2

1807: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1808: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1809: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1810: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1811: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1812: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1813: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1814: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1815: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 1812: ,p_attribute5 in varchar2 default hr_api.g_varchar2

1808: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1809: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1810: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1811: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1812: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1813: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1814: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1815: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1816: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 1813: ,p_attribute6 in varchar2 default hr_api.g_varchar2

1809: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1810: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1811: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1812: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1813: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1814: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1815: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1816: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1817: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 1814: ,p_attribute7 in varchar2 default hr_api.g_varchar2

1810: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1811: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1812: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1813: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1814: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1815: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1816: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1817: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1818: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 1815: ,p_attribute8 in varchar2 default hr_api.g_varchar2

1811: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1812: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1813: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1814: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1815: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1816: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1817: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1818: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1819: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 1816: ,p_attribute9 in varchar2 default hr_api.g_varchar2

1812: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1813: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1814: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1815: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1816: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1817: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1818: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1819: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1820: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 1817: ,p_attribute10 in varchar2 default hr_api.g_varchar2

1813: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1814: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1815: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1816: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1817: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1818: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1819: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1820: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1821: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 1818: ,p_attribute11 in varchar2 default hr_api.g_varchar2

1814: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1815: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1816: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1817: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1818: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1819: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1820: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1821: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1822: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 1819: ,p_attribute12 in varchar2 default hr_api.g_varchar2

1815: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1816: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1817: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1818: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1819: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1820: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1821: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1822: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1823: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 1820: ,p_attribute13 in varchar2 default hr_api.g_varchar2

1816: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1817: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1818: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1819: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1820: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1821: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1822: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1823: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1824: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 1821: ,p_attribute14 in varchar2 default hr_api.g_varchar2

1817: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1818: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1819: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1820: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1821: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1822: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1823: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1824: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1825: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 1822: ,p_attribute15 in varchar2 default hr_api.g_varchar2

1818: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1819: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1820: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1821: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1822: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1823: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1824: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1825: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1826: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 1823: ,p_attribute16 in varchar2 default hr_api.g_varchar2

1819: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1820: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1821: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1822: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1823: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1824: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1825: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1826: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1827: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 1824: ,p_attribute17 in varchar2 default hr_api.g_varchar2

1820: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1821: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1822: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1823: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1824: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1825: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1826: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1827: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1828: ,p_territory_code in varchar2 default hr_api.g_varchar2

Line 1825: ,p_attribute18 in varchar2 default hr_api.g_varchar2

1821: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1822: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1823: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1824: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1825: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1826: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1827: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1828: ,p_territory_code in varchar2 default hr_api.g_varchar2
1829: ,p_segment1 in varchar2 default hr_api.g_varchar2

Line 1826: ,p_attribute19 in varchar2 default hr_api.g_varchar2

1822: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1823: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1824: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1825: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1826: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1827: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1828: ,p_territory_code in varchar2 default hr_api.g_varchar2
1829: ,p_segment1 in varchar2 default hr_api.g_varchar2
1830: ,p_segment2 in varchar2 default hr_api.g_varchar2

Line 1827: ,p_attribute20 in varchar2 default hr_api.g_varchar2

1823: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1824: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1825: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1826: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1827: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1828: ,p_territory_code in varchar2 default hr_api.g_varchar2
1829: ,p_segment1 in varchar2 default hr_api.g_varchar2
1830: ,p_segment2 in varchar2 default hr_api.g_varchar2
1831: ,p_segment3 in varchar2 default hr_api.g_varchar2

Line 1828: ,p_territory_code in varchar2 default hr_api.g_varchar2

1824: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1825: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1826: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1827: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1828: ,p_territory_code in varchar2 default hr_api.g_varchar2
1829: ,p_segment1 in varchar2 default hr_api.g_varchar2
1830: ,p_segment2 in varchar2 default hr_api.g_varchar2
1831: ,p_segment3 in varchar2 default hr_api.g_varchar2
1832: ,p_segment4 in varchar2 default hr_api.g_varchar2

Line 1829: ,p_segment1 in varchar2 default hr_api.g_varchar2

1825: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1826: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1827: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1828: ,p_territory_code in varchar2 default hr_api.g_varchar2
1829: ,p_segment1 in varchar2 default hr_api.g_varchar2
1830: ,p_segment2 in varchar2 default hr_api.g_varchar2
1831: ,p_segment3 in varchar2 default hr_api.g_varchar2
1832: ,p_segment4 in varchar2 default hr_api.g_varchar2
1833: ,p_segment5 in varchar2 default hr_api.g_varchar2

Line 1830: ,p_segment2 in varchar2 default hr_api.g_varchar2

1826: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1827: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1828: ,p_territory_code in varchar2 default hr_api.g_varchar2
1829: ,p_segment1 in varchar2 default hr_api.g_varchar2
1830: ,p_segment2 in varchar2 default hr_api.g_varchar2
1831: ,p_segment3 in varchar2 default hr_api.g_varchar2
1832: ,p_segment4 in varchar2 default hr_api.g_varchar2
1833: ,p_segment5 in varchar2 default hr_api.g_varchar2
1834: ,p_segment6 in varchar2 default hr_api.g_varchar2

Line 1831: ,p_segment3 in varchar2 default hr_api.g_varchar2

1827: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1828: ,p_territory_code in varchar2 default hr_api.g_varchar2
1829: ,p_segment1 in varchar2 default hr_api.g_varchar2
1830: ,p_segment2 in varchar2 default hr_api.g_varchar2
1831: ,p_segment3 in varchar2 default hr_api.g_varchar2
1832: ,p_segment4 in varchar2 default hr_api.g_varchar2
1833: ,p_segment5 in varchar2 default hr_api.g_varchar2
1834: ,p_segment6 in varchar2 default hr_api.g_varchar2
1835: ,p_segment7 in varchar2 default hr_api.g_varchar2

Line 1832: ,p_segment4 in varchar2 default hr_api.g_varchar2

1828: ,p_territory_code in varchar2 default hr_api.g_varchar2
1829: ,p_segment1 in varchar2 default hr_api.g_varchar2
1830: ,p_segment2 in varchar2 default hr_api.g_varchar2
1831: ,p_segment3 in varchar2 default hr_api.g_varchar2
1832: ,p_segment4 in varchar2 default hr_api.g_varchar2
1833: ,p_segment5 in varchar2 default hr_api.g_varchar2
1834: ,p_segment6 in varchar2 default hr_api.g_varchar2
1835: ,p_segment7 in varchar2 default hr_api.g_varchar2
1836: ,p_segment8 in varchar2 default hr_api.g_varchar2

Line 1833: ,p_segment5 in varchar2 default hr_api.g_varchar2

1829: ,p_segment1 in varchar2 default hr_api.g_varchar2
1830: ,p_segment2 in varchar2 default hr_api.g_varchar2
1831: ,p_segment3 in varchar2 default hr_api.g_varchar2
1832: ,p_segment4 in varchar2 default hr_api.g_varchar2
1833: ,p_segment5 in varchar2 default hr_api.g_varchar2
1834: ,p_segment6 in varchar2 default hr_api.g_varchar2
1835: ,p_segment7 in varchar2 default hr_api.g_varchar2
1836: ,p_segment8 in varchar2 default hr_api.g_varchar2
1837: ,p_segment9 in varchar2 default hr_api.g_varchar2

Line 1834: ,p_segment6 in varchar2 default hr_api.g_varchar2

1830: ,p_segment2 in varchar2 default hr_api.g_varchar2
1831: ,p_segment3 in varchar2 default hr_api.g_varchar2
1832: ,p_segment4 in varchar2 default hr_api.g_varchar2
1833: ,p_segment5 in varchar2 default hr_api.g_varchar2
1834: ,p_segment6 in varchar2 default hr_api.g_varchar2
1835: ,p_segment7 in varchar2 default hr_api.g_varchar2
1836: ,p_segment8 in varchar2 default hr_api.g_varchar2
1837: ,p_segment9 in varchar2 default hr_api.g_varchar2
1838: ,p_segment10 in varchar2 default hr_api.g_varchar2

Line 1835: ,p_segment7 in varchar2 default hr_api.g_varchar2

1831: ,p_segment3 in varchar2 default hr_api.g_varchar2
1832: ,p_segment4 in varchar2 default hr_api.g_varchar2
1833: ,p_segment5 in varchar2 default hr_api.g_varchar2
1834: ,p_segment6 in varchar2 default hr_api.g_varchar2
1835: ,p_segment7 in varchar2 default hr_api.g_varchar2
1836: ,p_segment8 in varchar2 default hr_api.g_varchar2
1837: ,p_segment9 in varchar2 default hr_api.g_varchar2
1838: ,p_segment10 in varchar2 default hr_api.g_varchar2
1839: ,p_segment11 in varchar2 default hr_api.g_varchar2

Line 1836: ,p_segment8 in varchar2 default hr_api.g_varchar2

1832: ,p_segment4 in varchar2 default hr_api.g_varchar2
1833: ,p_segment5 in varchar2 default hr_api.g_varchar2
1834: ,p_segment6 in varchar2 default hr_api.g_varchar2
1835: ,p_segment7 in varchar2 default hr_api.g_varchar2
1836: ,p_segment8 in varchar2 default hr_api.g_varchar2
1837: ,p_segment9 in varchar2 default hr_api.g_varchar2
1838: ,p_segment10 in varchar2 default hr_api.g_varchar2
1839: ,p_segment11 in varchar2 default hr_api.g_varchar2
1840: ,p_segment12 in varchar2 default hr_api.g_varchar2

Line 1837: ,p_segment9 in varchar2 default hr_api.g_varchar2

1833: ,p_segment5 in varchar2 default hr_api.g_varchar2
1834: ,p_segment6 in varchar2 default hr_api.g_varchar2
1835: ,p_segment7 in varchar2 default hr_api.g_varchar2
1836: ,p_segment8 in varchar2 default hr_api.g_varchar2
1837: ,p_segment9 in varchar2 default hr_api.g_varchar2
1838: ,p_segment10 in varchar2 default hr_api.g_varchar2
1839: ,p_segment11 in varchar2 default hr_api.g_varchar2
1840: ,p_segment12 in varchar2 default hr_api.g_varchar2
1841: ,p_segment13 in varchar2 default hr_api.g_varchar2

Line 1838: ,p_segment10 in varchar2 default hr_api.g_varchar2

1834: ,p_segment6 in varchar2 default hr_api.g_varchar2
1835: ,p_segment7 in varchar2 default hr_api.g_varchar2
1836: ,p_segment8 in varchar2 default hr_api.g_varchar2
1837: ,p_segment9 in varchar2 default hr_api.g_varchar2
1838: ,p_segment10 in varchar2 default hr_api.g_varchar2
1839: ,p_segment11 in varchar2 default hr_api.g_varchar2
1840: ,p_segment12 in varchar2 default hr_api.g_varchar2
1841: ,p_segment13 in varchar2 default hr_api.g_varchar2
1842: ,p_segment14 in varchar2 default hr_api.g_varchar2

Line 1839: ,p_segment11 in varchar2 default hr_api.g_varchar2

1835: ,p_segment7 in varchar2 default hr_api.g_varchar2
1836: ,p_segment8 in varchar2 default hr_api.g_varchar2
1837: ,p_segment9 in varchar2 default hr_api.g_varchar2
1838: ,p_segment10 in varchar2 default hr_api.g_varchar2
1839: ,p_segment11 in varchar2 default hr_api.g_varchar2
1840: ,p_segment12 in varchar2 default hr_api.g_varchar2
1841: ,p_segment13 in varchar2 default hr_api.g_varchar2
1842: ,p_segment14 in varchar2 default hr_api.g_varchar2
1843: ,p_segment15 in varchar2 default hr_api.g_varchar2

Line 1840: ,p_segment12 in varchar2 default hr_api.g_varchar2

1836: ,p_segment8 in varchar2 default hr_api.g_varchar2
1837: ,p_segment9 in varchar2 default hr_api.g_varchar2
1838: ,p_segment10 in varchar2 default hr_api.g_varchar2
1839: ,p_segment11 in varchar2 default hr_api.g_varchar2
1840: ,p_segment12 in varchar2 default hr_api.g_varchar2
1841: ,p_segment13 in varchar2 default hr_api.g_varchar2
1842: ,p_segment14 in varchar2 default hr_api.g_varchar2
1843: ,p_segment15 in varchar2 default hr_api.g_varchar2
1844: ,p_segment16 in varchar2 default hr_api.g_varchar2

Line 1841: ,p_segment13 in varchar2 default hr_api.g_varchar2

1837: ,p_segment9 in varchar2 default hr_api.g_varchar2
1838: ,p_segment10 in varchar2 default hr_api.g_varchar2
1839: ,p_segment11 in varchar2 default hr_api.g_varchar2
1840: ,p_segment12 in varchar2 default hr_api.g_varchar2
1841: ,p_segment13 in varchar2 default hr_api.g_varchar2
1842: ,p_segment14 in varchar2 default hr_api.g_varchar2
1843: ,p_segment15 in varchar2 default hr_api.g_varchar2
1844: ,p_segment16 in varchar2 default hr_api.g_varchar2
1845: ,p_segment17 in varchar2 default hr_api.g_varchar2

Line 1842: ,p_segment14 in varchar2 default hr_api.g_varchar2

1838: ,p_segment10 in varchar2 default hr_api.g_varchar2
1839: ,p_segment11 in varchar2 default hr_api.g_varchar2
1840: ,p_segment12 in varchar2 default hr_api.g_varchar2
1841: ,p_segment13 in varchar2 default hr_api.g_varchar2
1842: ,p_segment14 in varchar2 default hr_api.g_varchar2
1843: ,p_segment15 in varchar2 default hr_api.g_varchar2
1844: ,p_segment16 in varchar2 default hr_api.g_varchar2
1845: ,p_segment17 in varchar2 default hr_api.g_varchar2
1846: ,p_segment18 in varchar2 default hr_api.g_varchar2

Line 1843: ,p_segment15 in varchar2 default hr_api.g_varchar2

1839: ,p_segment11 in varchar2 default hr_api.g_varchar2
1840: ,p_segment12 in varchar2 default hr_api.g_varchar2
1841: ,p_segment13 in varchar2 default hr_api.g_varchar2
1842: ,p_segment14 in varchar2 default hr_api.g_varchar2
1843: ,p_segment15 in varchar2 default hr_api.g_varchar2
1844: ,p_segment16 in varchar2 default hr_api.g_varchar2
1845: ,p_segment17 in varchar2 default hr_api.g_varchar2
1846: ,p_segment18 in varchar2 default hr_api.g_varchar2
1847: ,p_segment19 in varchar2 default hr_api.g_varchar2

Line 1844: ,p_segment16 in varchar2 default hr_api.g_varchar2

1840: ,p_segment12 in varchar2 default hr_api.g_varchar2
1841: ,p_segment13 in varchar2 default hr_api.g_varchar2
1842: ,p_segment14 in varchar2 default hr_api.g_varchar2
1843: ,p_segment15 in varchar2 default hr_api.g_varchar2
1844: ,p_segment16 in varchar2 default hr_api.g_varchar2
1845: ,p_segment17 in varchar2 default hr_api.g_varchar2
1846: ,p_segment18 in varchar2 default hr_api.g_varchar2
1847: ,p_segment19 in varchar2 default hr_api.g_varchar2
1848: ,p_segment20 in varchar2 default hr_api.g_varchar2

Line 1845: ,p_segment17 in varchar2 default hr_api.g_varchar2

1841: ,p_segment13 in varchar2 default hr_api.g_varchar2
1842: ,p_segment14 in varchar2 default hr_api.g_varchar2
1843: ,p_segment15 in varchar2 default hr_api.g_varchar2
1844: ,p_segment16 in varchar2 default hr_api.g_varchar2
1845: ,p_segment17 in varchar2 default hr_api.g_varchar2
1846: ,p_segment18 in varchar2 default hr_api.g_varchar2
1847: ,p_segment19 in varchar2 default hr_api.g_varchar2
1848: ,p_segment20 in varchar2 default hr_api.g_varchar2
1849: ,p_segment21 in varchar2 default hr_api.g_varchar2

Line 1846: ,p_segment18 in varchar2 default hr_api.g_varchar2

1842: ,p_segment14 in varchar2 default hr_api.g_varchar2
1843: ,p_segment15 in varchar2 default hr_api.g_varchar2
1844: ,p_segment16 in varchar2 default hr_api.g_varchar2
1845: ,p_segment17 in varchar2 default hr_api.g_varchar2
1846: ,p_segment18 in varchar2 default hr_api.g_varchar2
1847: ,p_segment19 in varchar2 default hr_api.g_varchar2
1848: ,p_segment20 in varchar2 default hr_api.g_varchar2
1849: ,p_segment21 in varchar2 default hr_api.g_varchar2
1850: ,p_segment22 in varchar2 default hr_api.g_varchar2

Line 1847: ,p_segment19 in varchar2 default hr_api.g_varchar2

1843: ,p_segment15 in varchar2 default hr_api.g_varchar2
1844: ,p_segment16 in varchar2 default hr_api.g_varchar2
1845: ,p_segment17 in varchar2 default hr_api.g_varchar2
1846: ,p_segment18 in varchar2 default hr_api.g_varchar2
1847: ,p_segment19 in varchar2 default hr_api.g_varchar2
1848: ,p_segment20 in varchar2 default hr_api.g_varchar2
1849: ,p_segment21 in varchar2 default hr_api.g_varchar2
1850: ,p_segment22 in varchar2 default hr_api.g_varchar2
1851: ,p_segment23 in varchar2 default hr_api.g_varchar2

Line 1848: ,p_segment20 in varchar2 default hr_api.g_varchar2

1844: ,p_segment16 in varchar2 default hr_api.g_varchar2
1845: ,p_segment17 in varchar2 default hr_api.g_varchar2
1846: ,p_segment18 in varchar2 default hr_api.g_varchar2
1847: ,p_segment19 in varchar2 default hr_api.g_varchar2
1848: ,p_segment20 in varchar2 default hr_api.g_varchar2
1849: ,p_segment21 in varchar2 default hr_api.g_varchar2
1850: ,p_segment22 in varchar2 default hr_api.g_varchar2
1851: ,p_segment23 in varchar2 default hr_api.g_varchar2
1852: ,p_segment24 in varchar2 default hr_api.g_varchar2

Line 1849: ,p_segment21 in varchar2 default hr_api.g_varchar2

1845: ,p_segment17 in varchar2 default hr_api.g_varchar2
1846: ,p_segment18 in varchar2 default hr_api.g_varchar2
1847: ,p_segment19 in varchar2 default hr_api.g_varchar2
1848: ,p_segment20 in varchar2 default hr_api.g_varchar2
1849: ,p_segment21 in varchar2 default hr_api.g_varchar2
1850: ,p_segment22 in varchar2 default hr_api.g_varchar2
1851: ,p_segment23 in varchar2 default hr_api.g_varchar2
1852: ,p_segment24 in varchar2 default hr_api.g_varchar2
1853: ,p_segment25 in varchar2 default hr_api.g_varchar2

Line 1850: ,p_segment22 in varchar2 default hr_api.g_varchar2

1846: ,p_segment18 in varchar2 default hr_api.g_varchar2
1847: ,p_segment19 in varchar2 default hr_api.g_varchar2
1848: ,p_segment20 in varchar2 default hr_api.g_varchar2
1849: ,p_segment21 in varchar2 default hr_api.g_varchar2
1850: ,p_segment22 in varchar2 default hr_api.g_varchar2
1851: ,p_segment23 in varchar2 default hr_api.g_varchar2
1852: ,p_segment24 in varchar2 default hr_api.g_varchar2
1853: ,p_segment25 in varchar2 default hr_api.g_varchar2
1854: ,p_segment26 in varchar2 default hr_api.g_varchar2

Line 1851: ,p_segment23 in varchar2 default hr_api.g_varchar2

1847: ,p_segment19 in varchar2 default hr_api.g_varchar2
1848: ,p_segment20 in varchar2 default hr_api.g_varchar2
1849: ,p_segment21 in varchar2 default hr_api.g_varchar2
1850: ,p_segment22 in varchar2 default hr_api.g_varchar2
1851: ,p_segment23 in varchar2 default hr_api.g_varchar2
1852: ,p_segment24 in varchar2 default hr_api.g_varchar2
1853: ,p_segment25 in varchar2 default hr_api.g_varchar2
1854: ,p_segment26 in varchar2 default hr_api.g_varchar2
1855: ,p_segment27 in varchar2 default hr_api.g_varchar2

Line 1852: ,p_segment24 in varchar2 default hr_api.g_varchar2

1848: ,p_segment20 in varchar2 default hr_api.g_varchar2
1849: ,p_segment21 in varchar2 default hr_api.g_varchar2
1850: ,p_segment22 in varchar2 default hr_api.g_varchar2
1851: ,p_segment23 in varchar2 default hr_api.g_varchar2
1852: ,p_segment24 in varchar2 default hr_api.g_varchar2
1853: ,p_segment25 in varchar2 default hr_api.g_varchar2
1854: ,p_segment26 in varchar2 default hr_api.g_varchar2
1855: ,p_segment27 in varchar2 default hr_api.g_varchar2
1856: ,p_segment28 in varchar2 default hr_api.g_varchar2

Line 1853: ,p_segment25 in varchar2 default hr_api.g_varchar2

1849: ,p_segment21 in varchar2 default hr_api.g_varchar2
1850: ,p_segment22 in varchar2 default hr_api.g_varchar2
1851: ,p_segment23 in varchar2 default hr_api.g_varchar2
1852: ,p_segment24 in varchar2 default hr_api.g_varchar2
1853: ,p_segment25 in varchar2 default hr_api.g_varchar2
1854: ,p_segment26 in varchar2 default hr_api.g_varchar2
1855: ,p_segment27 in varchar2 default hr_api.g_varchar2
1856: ,p_segment28 in varchar2 default hr_api.g_varchar2
1857: ,p_segment29 in varchar2 default hr_api.g_varchar2

Line 1854: ,p_segment26 in varchar2 default hr_api.g_varchar2

1850: ,p_segment22 in varchar2 default hr_api.g_varchar2
1851: ,p_segment23 in varchar2 default hr_api.g_varchar2
1852: ,p_segment24 in varchar2 default hr_api.g_varchar2
1853: ,p_segment25 in varchar2 default hr_api.g_varchar2
1854: ,p_segment26 in varchar2 default hr_api.g_varchar2
1855: ,p_segment27 in varchar2 default hr_api.g_varchar2
1856: ,p_segment28 in varchar2 default hr_api.g_varchar2
1857: ,p_segment29 in varchar2 default hr_api.g_varchar2
1858: ,p_segment30 in varchar2 default hr_api.g_varchar2

Line 1855: ,p_segment27 in varchar2 default hr_api.g_varchar2

1851: ,p_segment23 in varchar2 default hr_api.g_varchar2
1852: ,p_segment24 in varchar2 default hr_api.g_varchar2
1853: ,p_segment25 in varchar2 default hr_api.g_varchar2
1854: ,p_segment26 in varchar2 default hr_api.g_varchar2
1855: ,p_segment27 in varchar2 default hr_api.g_varchar2
1856: ,p_segment28 in varchar2 default hr_api.g_varchar2
1857: ,p_segment29 in varchar2 default hr_api.g_varchar2
1858: ,p_segment30 in varchar2 default hr_api.g_varchar2
1859: /** sbilling **/

Line 1856: ,p_segment28 in varchar2 default hr_api.g_varchar2

1852: ,p_segment24 in varchar2 default hr_api.g_varchar2
1853: ,p_segment25 in varchar2 default hr_api.g_varchar2
1854: ,p_segment26 in varchar2 default hr_api.g_varchar2
1855: ,p_segment27 in varchar2 default hr_api.g_varchar2
1856: ,p_segment28 in varchar2 default hr_api.g_varchar2
1857: ,p_segment29 in varchar2 default hr_api.g_varchar2
1858: ,p_segment30 in varchar2 default hr_api.g_varchar2
1859: /** sbilling **/
1860: ,p_concat_segments in varchar2 default null

Line 1857: ,p_segment29 in varchar2 default hr_api.g_varchar2

1853: ,p_segment25 in varchar2 default hr_api.g_varchar2
1854: ,p_segment26 in varchar2 default hr_api.g_varchar2
1855: ,p_segment27 in varchar2 default hr_api.g_varchar2
1856: ,p_segment28 in varchar2 default hr_api.g_varchar2
1857: ,p_segment29 in varchar2 default hr_api.g_varchar2
1858: ,p_segment30 in varchar2 default hr_api.g_varchar2
1859: /** sbilling **/
1860: ,p_concat_segments in varchar2 default null
1861: ,p_payee_type in varchar2 default hr_api.g_varchar2

Line 1858: ,p_segment30 in varchar2 default hr_api.g_varchar2

1854: ,p_segment26 in varchar2 default hr_api.g_varchar2
1855: ,p_segment27 in varchar2 default hr_api.g_varchar2
1856: ,p_segment28 in varchar2 default hr_api.g_varchar2
1857: ,p_segment29 in varchar2 default hr_api.g_varchar2
1858: ,p_segment30 in varchar2 default hr_api.g_varchar2
1859: /** sbilling **/
1860: ,p_concat_segments in varchar2 default null
1861: ,p_payee_type in varchar2 default hr_api.g_varchar2
1862: ,p_payee_id in number default hr_api.g_number

Line 1861: ,p_payee_type in varchar2 default hr_api.g_varchar2

1857: ,p_segment29 in varchar2 default hr_api.g_varchar2
1858: ,p_segment30 in varchar2 default hr_api.g_varchar2
1859: /** sbilling **/
1860: ,p_concat_segments in varchar2 default null
1861: ,p_payee_type in varchar2 default hr_api.g_varchar2
1862: ,p_payee_id in number default hr_api.g_number
1863: ,p_ppm_information_category in varchar2 default hr_api.g_varchar2 --Bug 6439573
1864: ,p_ppm_information1 in varchar2 default hr_api.g_varchar2
1865: ,p_ppm_information2 in varchar2 default hr_api.g_varchar2

Line 1862: ,p_payee_id in number default hr_api.g_number

1858: ,p_segment30 in varchar2 default hr_api.g_varchar2
1859: /** sbilling **/
1860: ,p_concat_segments in varchar2 default null
1861: ,p_payee_type in varchar2 default hr_api.g_varchar2
1862: ,p_payee_id in number default hr_api.g_number
1863: ,p_ppm_information_category in varchar2 default hr_api.g_varchar2 --Bug 6439573
1864: ,p_ppm_information1 in varchar2 default hr_api.g_varchar2
1865: ,p_ppm_information2 in varchar2 default hr_api.g_varchar2
1866: ,p_ppm_information3 in varchar2 default hr_api.g_varchar2

Line 1863: ,p_ppm_information_category in varchar2 default hr_api.g_varchar2 --Bug 6439573

1859: /** sbilling **/
1860: ,p_concat_segments in varchar2 default null
1861: ,p_payee_type in varchar2 default hr_api.g_varchar2
1862: ,p_payee_id in number default hr_api.g_number
1863: ,p_ppm_information_category in varchar2 default hr_api.g_varchar2 --Bug 6439573
1864: ,p_ppm_information1 in varchar2 default hr_api.g_varchar2
1865: ,p_ppm_information2 in varchar2 default hr_api.g_varchar2
1866: ,p_ppm_information3 in varchar2 default hr_api.g_varchar2
1867: ,p_ppm_information4 in varchar2 default hr_api.g_varchar2

Line 1864: ,p_ppm_information1 in varchar2 default hr_api.g_varchar2

1860: ,p_concat_segments in varchar2 default null
1861: ,p_payee_type in varchar2 default hr_api.g_varchar2
1862: ,p_payee_id in number default hr_api.g_number
1863: ,p_ppm_information_category in varchar2 default hr_api.g_varchar2 --Bug 6439573
1864: ,p_ppm_information1 in varchar2 default hr_api.g_varchar2
1865: ,p_ppm_information2 in varchar2 default hr_api.g_varchar2
1866: ,p_ppm_information3 in varchar2 default hr_api.g_varchar2
1867: ,p_ppm_information4 in varchar2 default hr_api.g_varchar2
1868: ,p_ppm_information5 in varchar2 default hr_api.g_varchar2

Line 1865: ,p_ppm_information2 in varchar2 default hr_api.g_varchar2

1861: ,p_payee_type in varchar2 default hr_api.g_varchar2
1862: ,p_payee_id in number default hr_api.g_number
1863: ,p_ppm_information_category in varchar2 default hr_api.g_varchar2 --Bug 6439573
1864: ,p_ppm_information1 in varchar2 default hr_api.g_varchar2
1865: ,p_ppm_information2 in varchar2 default hr_api.g_varchar2
1866: ,p_ppm_information3 in varchar2 default hr_api.g_varchar2
1867: ,p_ppm_information4 in varchar2 default hr_api.g_varchar2
1868: ,p_ppm_information5 in varchar2 default hr_api.g_varchar2
1869: ,p_ppm_information6 in varchar2 default hr_api.g_varchar2

Line 1866: ,p_ppm_information3 in varchar2 default hr_api.g_varchar2

1862: ,p_payee_id in number default hr_api.g_number
1863: ,p_ppm_information_category in varchar2 default hr_api.g_varchar2 --Bug 6439573
1864: ,p_ppm_information1 in varchar2 default hr_api.g_varchar2
1865: ,p_ppm_information2 in varchar2 default hr_api.g_varchar2
1866: ,p_ppm_information3 in varchar2 default hr_api.g_varchar2
1867: ,p_ppm_information4 in varchar2 default hr_api.g_varchar2
1868: ,p_ppm_information5 in varchar2 default hr_api.g_varchar2
1869: ,p_ppm_information6 in varchar2 default hr_api.g_varchar2
1870: ,p_ppm_information7 in varchar2 default hr_api.g_varchar2

Line 1867: ,p_ppm_information4 in varchar2 default hr_api.g_varchar2

1863: ,p_ppm_information_category in varchar2 default hr_api.g_varchar2 --Bug 6439573
1864: ,p_ppm_information1 in varchar2 default hr_api.g_varchar2
1865: ,p_ppm_information2 in varchar2 default hr_api.g_varchar2
1866: ,p_ppm_information3 in varchar2 default hr_api.g_varchar2
1867: ,p_ppm_information4 in varchar2 default hr_api.g_varchar2
1868: ,p_ppm_information5 in varchar2 default hr_api.g_varchar2
1869: ,p_ppm_information6 in varchar2 default hr_api.g_varchar2
1870: ,p_ppm_information7 in varchar2 default hr_api.g_varchar2
1871: ,p_ppm_information8 in varchar2 default hr_api.g_varchar2

Line 1868: ,p_ppm_information5 in varchar2 default hr_api.g_varchar2

1864: ,p_ppm_information1 in varchar2 default hr_api.g_varchar2
1865: ,p_ppm_information2 in varchar2 default hr_api.g_varchar2
1866: ,p_ppm_information3 in varchar2 default hr_api.g_varchar2
1867: ,p_ppm_information4 in varchar2 default hr_api.g_varchar2
1868: ,p_ppm_information5 in varchar2 default hr_api.g_varchar2
1869: ,p_ppm_information6 in varchar2 default hr_api.g_varchar2
1870: ,p_ppm_information7 in varchar2 default hr_api.g_varchar2
1871: ,p_ppm_information8 in varchar2 default hr_api.g_varchar2
1872: ,p_ppm_information9 in varchar2 default hr_api.g_varchar2

Line 1869: ,p_ppm_information6 in varchar2 default hr_api.g_varchar2

1865: ,p_ppm_information2 in varchar2 default hr_api.g_varchar2
1866: ,p_ppm_information3 in varchar2 default hr_api.g_varchar2
1867: ,p_ppm_information4 in varchar2 default hr_api.g_varchar2
1868: ,p_ppm_information5 in varchar2 default hr_api.g_varchar2
1869: ,p_ppm_information6 in varchar2 default hr_api.g_varchar2
1870: ,p_ppm_information7 in varchar2 default hr_api.g_varchar2
1871: ,p_ppm_information8 in varchar2 default hr_api.g_varchar2
1872: ,p_ppm_information9 in varchar2 default hr_api.g_varchar2
1873: ,p_ppm_information10 in varchar2 default hr_api.g_varchar2

Line 1870: ,p_ppm_information7 in varchar2 default hr_api.g_varchar2

1866: ,p_ppm_information3 in varchar2 default hr_api.g_varchar2
1867: ,p_ppm_information4 in varchar2 default hr_api.g_varchar2
1868: ,p_ppm_information5 in varchar2 default hr_api.g_varchar2
1869: ,p_ppm_information6 in varchar2 default hr_api.g_varchar2
1870: ,p_ppm_information7 in varchar2 default hr_api.g_varchar2
1871: ,p_ppm_information8 in varchar2 default hr_api.g_varchar2
1872: ,p_ppm_information9 in varchar2 default hr_api.g_varchar2
1873: ,p_ppm_information10 in varchar2 default hr_api.g_varchar2
1874: ,p_ppm_information11 in varchar2 default hr_api.g_varchar2

Line 1871: ,p_ppm_information8 in varchar2 default hr_api.g_varchar2

1867: ,p_ppm_information4 in varchar2 default hr_api.g_varchar2
1868: ,p_ppm_information5 in varchar2 default hr_api.g_varchar2
1869: ,p_ppm_information6 in varchar2 default hr_api.g_varchar2
1870: ,p_ppm_information7 in varchar2 default hr_api.g_varchar2
1871: ,p_ppm_information8 in varchar2 default hr_api.g_varchar2
1872: ,p_ppm_information9 in varchar2 default hr_api.g_varchar2
1873: ,p_ppm_information10 in varchar2 default hr_api.g_varchar2
1874: ,p_ppm_information11 in varchar2 default hr_api.g_varchar2
1875: ,p_ppm_information12 in varchar2 default hr_api.g_varchar2

Line 1872: ,p_ppm_information9 in varchar2 default hr_api.g_varchar2

1868: ,p_ppm_information5 in varchar2 default hr_api.g_varchar2
1869: ,p_ppm_information6 in varchar2 default hr_api.g_varchar2
1870: ,p_ppm_information7 in varchar2 default hr_api.g_varchar2
1871: ,p_ppm_information8 in varchar2 default hr_api.g_varchar2
1872: ,p_ppm_information9 in varchar2 default hr_api.g_varchar2
1873: ,p_ppm_information10 in varchar2 default hr_api.g_varchar2
1874: ,p_ppm_information11 in varchar2 default hr_api.g_varchar2
1875: ,p_ppm_information12 in varchar2 default hr_api.g_varchar2
1876: ,p_ppm_information13 in varchar2 default hr_api.g_varchar2

Line 1873: ,p_ppm_information10 in varchar2 default hr_api.g_varchar2

1869: ,p_ppm_information6 in varchar2 default hr_api.g_varchar2
1870: ,p_ppm_information7 in varchar2 default hr_api.g_varchar2
1871: ,p_ppm_information8 in varchar2 default hr_api.g_varchar2
1872: ,p_ppm_information9 in varchar2 default hr_api.g_varchar2
1873: ,p_ppm_information10 in varchar2 default hr_api.g_varchar2
1874: ,p_ppm_information11 in varchar2 default hr_api.g_varchar2
1875: ,p_ppm_information12 in varchar2 default hr_api.g_varchar2
1876: ,p_ppm_information13 in varchar2 default hr_api.g_varchar2
1877: ,p_ppm_information14 in varchar2 default hr_api.g_varchar2

Line 1874: ,p_ppm_information11 in varchar2 default hr_api.g_varchar2

1870: ,p_ppm_information7 in varchar2 default hr_api.g_varchar2
1871: ,p_ppm_information8 in varchar2 default hr_api.g_varchar2
1872: ,p_ppm_information9 in varchar2 default hr_api.g_varchar2
1873: ,p_ppm_information10 in varchar2 default hr_api.g_varchar2
1874: ,p_ppm_information11 in varchar2 default hr_api.g_varchar2
1875: ,p_ppm_information12 in varchar2 default hr_api.g_varchar2
1876: ,p_ppm_information13 in varchar2 default hr_api.g_varchar2
1877: ,p_ppm_information14 in varchar2 default hr_api.g_varchar2
1878: ,p_ppm_information15 in varchar2 default hr_api.g_varchar2

Line 1875: ,p_ppm_information12 in varchar2 default hr_api.g_varchar2

1871: ,p_ppm_information8 in varchar2 default hr_api.g_varchar2
1872: ,p_ppm_information9 in varchar2 default hr_api.g_varchar2
1873: ,p_ppm_information10 in varchar2 default hr_api.g_varchar2
1874: ,p_ppm_information11 in varchar2 default hr_api.g_varchar2
1875: ,p_ppm_information12 in varchar2 default hr_api.g_varchar2
1876: ,p_ppm_information13 in varchar2 default hr_api.g_varchar2
1877: ,p_ppm_information14 in varchar2 default hr_api.g_varchar2
1878: ,p_ppm_information15 in varchar2 default hr_api.g_varchar2
1879: ,p_ppm_information16 in varchar2 default hr_api.g_varchar2

Line 1876: ,p_ppm_information13 in varchar2 default hr_api.g_varchar2

1872: ,p_ppm_information9 in varchar2 default hr_api.g_varchar2
1873: ,p_ppm_information10 in varchar2 default hr_api.g_varchar2
1874: ,p_ppm_information11 in varchar2 default hr_api.g_varchar2
1875: ,p_ppm_information12 in varchar2 default hr_api.g_varchar2
1876: ,p_ppm_information13 in varchar2 default hr_api.g_varchar2
1877: ,p_ppm_information14 in varchar2 default hr_api.g_varchar2
1878: ,p_ppm_information15 in varchar2 default hr_api.g_varchar2
1879: ,p_ppm_information16 in varchar2 default hr_api.g_varchar2
1880: ,p_ppm_information17 in varchar2 default hr_api.g_varchar2

Line 1877: ,p_ppm_information14 in varchar2 default hr_api.g_varchar2

1873: ,p_ppm_information10 in varchar2 default hr_api.g_varchar2
1874: ,p_ppm_information11 in varchar2 default hr_api.g_varchar2
1875: ,p_ppm_information12 in varchar2 default hr_api.g_varchar2
1876: ,p_ppm_information13 in varchar2 default hr_api.g_varchar2
1877: ,p_ppm_information14 in varchar2 default hr_api.g_varchar2
1878: ,p_ppm_information15 in varchar2 default hr_api.g_varchar2
1879: ,p_ppm_information16 in varchar2 default hr_api.g_varchar2
1880: ,p_ppm_information17 in varchar2 default hr_api.g_varchar2
1881: ,p_ppm_information18 in varchar2 default hr_api.g_varchar2

Line 1878: ,p_ppm_information15 in varchar2 default hr_api.g_varchar2

1874: ,p_ppm_information11 in varchar2 default hr_api.g_varchar2
1875: ,p_ppm_information12 in varchar2 default hr_api.g_varchar2
1876: ,p_ppm_information13 in varchar2 default hr_api.g_varchar2
1877: ,p_ppm_information14 in varchar2 default hr_api.g_varchar2
1878: ,p_ppm_information15 in varchar2 default hr_api.g_varchar2
1879: ,p_ppm_information16 in varchar2 default hr_api.g_varchar2
1880: ,p_ppm_information17 in varchar2 default hr_api.g_varchar2
1881: ,p_ppm_information18 in varchar2 default hr_api.g_varchar2
1882: ,p_ppm_information19 in varchar2 default hr_api.g_varchar2

Line 1879: ,p_ppm_information16 in varchar2 default hr_api.g_varchar2

1875: ,p_ppm_information12 in varchar2 default hr_api.g_varchar2
1876: ,p_ppm_information13 in varchar2 default hr_api.g_varchar2
1877: ,p_ppm_information14 in varchar2 default hr_api.g_varchar2
1878: ,p_ppm_information15 in varchar2 default hr_api.g_varchar2
1879: ,p_ppm_information16 in varchar2 default hr_api.g_varchar2
1880: ,p_ppm_information17 in varchar2 default hr_api.g_varchar2
1881: ,p_ppm_information18 in varchar2 default hr_api.g_varchar2
1882: ,p_ppm_information19 in varchar2 default hr_api.g_varchar2
1883: ,p_ppm_information20 in varchar2 default hr_api.g_varchar2

Line 1880: ,p_ppm_information17 in varchar2 default hr_api.g_varchar2

1876: ,p_ppm_information13 in varchar2 default hr_api.g_varchar2
1877: ,p_ppm_information14 in varchar2 default hr_api.g_varchar2
1878: ,p_ppm_information15 in varchar2 default hr_api.g_varchar2
1879: ,p_ppm_information16 in varchar2 default hr_api.g_varchar2
1880: ,p_ppm_information17 in varchar2 default hr_api.g_varchar2
1881: ,p_ppm_information18 in varchar2 default hr_api.g_varchar2
1882: ,p_ppm_information19 in varchar2 default hr_api.g_varchar2
1883: ,p_ppm_information20 in varchar2 default hr_api.g_varchar2
1884: ,p_ppm_information21 in varchar2 default hr_api.g_varchar2

Line 1881: ,p_ppm_information18 in varchar2 default hr_api.g_varchar2

1877: ,p_ppm_information14 in varchar2 default hr_api.g_varchar2
1878: ,p_ppm_information15 in varchar2 default hr_api.g_varchar2
1879: ,p_ppm_information16 in varchar2 default hr_api.g_varchar2
1880: ,p_ppm_information17 in varchar2 default hr_api.g_varchar2
1881: ,p_ppm_information18 in varchar2 default hr_api.g_varchar2
1882: ,p_ppm_information19 in varchar2 default hr_api.g_varchar2
1883: ,p_ppm_information20 in varchar2 default hr_api.g_varchar2
1884: ,p_ppm_information21 in varchar2 default hr_api.g_varchar2
1885: ,p_ppm_information22 in varchar2 default hr_api.g_varchar2

Line 1882: ,p_ppm_information19 in varchar2 default hr_api.g_varchar2

1878: ,p_ppm_information15 in varchar2 default hr_api.g_varchar2
1879: ,p_ppm_information16 in varchar2 default hr_api.g_varchar2
1880: ,p_ppm_information17 in varchar2 default hr_api.g_varchar2
1881: ,p_ppm_information18 in varchar2 default hr_api.g_varchar2
1882: ,p_ppm_information19 in varchar2 default hr_api.g_varchar2
1883: ,p_ppm_information20 in varchar2 default hr_api.g_varchar2
1884: ,p_ppm_information21 in varchar2 default hr_api.g_varchar2
1885: ,p_ppm_information22 in varchar2 default hr_api.g_varchar2
1886: ,p_ppm_information23 in varchar2 default hr_api.g_varchar2

Line 1883: ,p_ppm_information20 in varchar2 default hr_api.g_varchar2

1879: ,p_ppm_information16 in varchar2 default hr_api.g_varchar2
1880: ,p_ppm_information17 in varchar2 default hr_api.g_varchar2
1881: ,p_ppm_information18 in varchar2 default hr_api.g_varchar2
1882: ,p_ppm_information19 in varchar2 default hr_api.g_varchar2
1883: ,p_ppm_information20 in varchar2 default hr_api.g_varchar2
1884: ,p_ppm_information21 in varchar2 default hr_api.g_varchar2
1885: ,p_ppm_information22 in varchar2 default hr_api.g_varchar2
1886: ,p_ppm_information23 in varchar2 default hr_api.g_varchar2
1887: ,p_ppm_information24 in varchar2 default hr_api.g_varchar2

Line 1884: ,p_ppm_information21 in varchar2 default hr_api.g_varchar2

1880: ,p_ppm_information17 in varchar2 default hr_api.g_varchar2
1881: ,p_ppm_information18 in varchar2 default hr_api.g_varchar2
1882: ,p_ppm_information19 in varchar2 default hr_api.g_varchar2
1883: ,p_ppm_information20 in varchar2 default hr_api.g_varchar2
1884: ,p_ppm_information21 in varchar2 default hr_api.g_varchar2
1885: ,p_ppm_information22 in varchar2 default hr_api.g_varchar2
1886: ,p_ppm_information23 in varchar2 default hr_api.g_varchar2
1887: ,p_ppm_information24 in varchar2 default hr_api.g_varchar2
1888: ,p_ppm_information25 in varchar2 default hr_api.g_varchar2

Line 1885: ,p_ppm_information22 in varchar2 default hr_api.g_varchar2

1881: ,p_ppm_information18 in varchar2 default hr_api.g_varchar2
1882: ,p_ppm_information19 in varchar2 default hr_api.g_varchar2
1883: ,p_ppm_information20 in varchar2 default hr_api.g_varchar2
1884: ,p_ppm_information21 in varchar2 default hr_api.g_varchar2
1885: ,p_ppm_information22 in varchar2 default hr_api.g_varchar2
1886: ,p_ppm_information23 in varchar2 default hr_api.g_varchar2
1887: ,p_ppm_information24 in varchar2 default hr_api.g_varchar2
1888: ,p_ppm_information25 in varchar2 default hr_api.g_varchar2
1889: ,p_ppm_information26 in varchar2 default hr_api.g_varchar2

Line 1886: ,p_ppm_information23 in varchar2 default hr_api.g_varchar2

1882: ,p_ppm_information19 in varchar2 default hr_api.g_varchar2
1883: ,p_ppm_information20 in varchar2 default hr_api.g_varchar2
1884: ,p_ppm_information21 in varchar2 default hr_api.g_varchar2
1885: ,p_ppm_information22 in varchar2 default hr_api.g_varchar2
1886: ,p_ppm_information23 in varchar2 default hr_api.g_varchar2
1887: ,p_ppm_information24 in varchar2 default hr_api.g_varchar2
1888: ,p_ppm_information25 in varchar2 default hr_api.g_varchar2
1889: ,p_ppm_information26 in varchar2 default hr_api.g_varchar2
1890: ,p_ppm_information27 in varchar2 default hr_api.g_varchar2

Line 1887: ,p_ppm_information24 in varchar2 default hr_api.g_varchar2

1883: ,p_ppm_information20 in varchar2 default hr_api.g_varchar2
1884: ,p_ppm_information21 in varchar2 default hr_api.g_varchar2
1885: ,p_ppm_information22 in varchar2 default hr_api.g_varchar2
1886: ,p_ppm_information23 in varchar2 default hr_api.g_varchar2
1887: ,p_ppm_information24 in varchar2 default hr_api.g_varchar2
1888: ,p_ppm_information25 in varchar2 default hr_api.g_varchar2
1889: ,p_ppm_information26 in varchar2 default hr_api.g_varchar2
1890: ,p_ppm_information27 in varchar2 default hr_api.g_varchar2
1891: ,p_ppm_information28 in varchar2 default hr_api.g_varchar2

Line 1888: ,p_ppm_information25 in varchar2 default hr_api.g_varchar2

1884: ,p_ppm_information21 in varchar2 default hr_api.g_varchar2
1885: ,p_ppm_information22 in varchar2 default hr_api.g_varchar2
1886: ,p_ppm_information23 in varchar2 default hr_api.g_varchar2
1887: ,p_ppm_information24 in varchar2 default hr_api.g_varchar2
1888: ,p_ppm_information25 in varchar2 default hr_api.g_varchar2
1889: ,p_ppm_information26 in varchar2 default hr_api.g_varchar2
1890: ,p_ppm_information27 in varchar2 default hr_api.g_varchar2
1891: ,p_ppm_information28 in varchar2 default hr_api.g_varchar2
1892: ,p_ppm_information29 in varchar2 default hr_api.g_varchar2

Line 1889: ,p_ppm_information26 in varchar2 default hr_api.g_varchar2

1885: ,p_ppm_information22 in varchar2 default hr_api.g_varchar2
1886: ,p_ppm_information23 in varchar2 default hr_api.g_varchar2
1887: ,p_ppm_information24 in varchar2 default hr_api.g_varchar2
1888: ,p_ppm_information25 in varchar2 default hr_api.g_varchar2
1889: ,p_ppm_information26 in varchar2 default hr_api.g_varchar2
1890: ,p_ppm_information27 in varchar2 default hr_api.g_varchar2
1891: ,p_ppm_information28 in varchar2 default hr_api.g_varchar2
1892: ,p_ppm_information29 in varchar2 default hr_api.g_varchar2
1893: ,p_ppm_information30 in varchar2 default hr_api.g_varchar2

Line 1890: ,p_ppm_information27 in varchar2 default hr_api.g_varchar2

1886: ,p_ppm_information23 in varchar2 default hr_api.g_varchar2
1887: ,p_ppm_information24 in varchar2 default hr_api.g_varchar2
1888: ,p_ppm_information25 in varchar2 default hr_api.g_varchar2
1889: ,p_ppm_information26 in varchar2 default hr_api.g_varchar2
1890: ,p_ppm_information27 in varchar2 default hr_api.g_varchar2
1891: ,p_ppm_information28 in varchar2 default hr_api.g_varchar2
1892: ,p_ppm_information29 in varchar2 default hr_api.g_varchar2
1893: ,p_ppm_information30 in varchar2 default hr_api.g_varchar2
1894: ,p_comment_id out nocopy number

Line 1891: ,p_ppm_information28 in varchar2 default hr_api.g_varchar2

1887: ,p_ppm_information24 in varchar2 default hr_api.g_varchar2
1888: ,p_ppm_information25 in varchar2 default hr_api.g_varchar2
1889: ,p_ppm_information26 in varchar2 default hr_api.g_varchar2
1890: ,p_ppm_information27 in varchar2 default hr_api.g_varchar2
1891: ,p_ppm_information28 in varchar2 default hr_api.g_varchar2
1892: ,p_ppm_information29 in varchar2 default hr_api.g_varchar2
1893: ,p_ppm_information30 in varchar2 default hr_api.g_varchar2
1894: ,p_comment_id out nocopy number
1895: ,p_external_account_id out nocopy number

Line 1892: ,p_ppm_information29 in varchar2 default hr_api.g_varchar2

1888: ,p_ppm_information25 in varchar2 default hr_api.g_varchar2
1889: ,p_ppm_information26 in varchar2 default hr_api.g_varchar2
1890: ,p_ppm_information27 in varchar2 default hr_api.g_varchar2
1891: ,p_ppm_information28 in varchar2 default hr_api.g_varchar2
1892: ,p_ppm_information29 in varchar2 default hr_api.g_varchar2
1893: ,p_ppm_information30 in varchar2 default hr_api.g_varchar2
1894: ,p_comment_id out nocopy number
1895: ,p_external_account_id out nocopy number
1896: ,p_effective_start_date out nocopy date

Line 1893: ,p_ppm_information30 in varchar2 default hr_api.g_varchar2

1889: ,p_ppm_information26 in varchar2 default hr_api.g_varchar2
1890: ,p_ppm_information27 in varchar2 default hr_api.g_varchar2
1891: ,p_ppm_information28 in varchar2 default hr_api.g_varchar2
1892: ,p_ppm_information29 in varchar2 default hr_api.g_varchar2
1893: ,p_ppm_information30 in varchar2 default hr_api.g_varchar2
1894: ,p_comment_id out nocopy number
1895: ,p_external_account_id out nocopy number
1896: ,p_effective_start_date out nocopy date
1897: ,p_effective_end_date out nocopy date

Line 1989: hr_api.mandatory_arg_error

1985: --
1986: -- Check that p_personal_payment_method_id and p_effective_date are not null
1987: -- as they are used by the cursor to derive the business group.
1988: --
1989: hr_api.mandatory_arg_error
1990: (p_api_name => l_proc,
1991: p_argument => 'personal_payment_method_id',
1992: p_argument_value => p_personal_payment_method_id);
1993:

Line 1994: hr_api.mandatory_arg_error

1990: (p_api_name => l_proc,
1991: p_argument => 'personal_payment_method_id',
1992: p_argument_value => p_personal_payment_method_id);
1993:
1994: hr_api.mandatory_arg_error
1995: (p_api_name => l_proc,
1996: p_argument => 'effective_date',
1997: p_argument_value => p_effective_date);
1998: --

Line 2105: when hr_api.cannot_find_prog_unit then

2101: ,p_ppm_information29 => p_ppm_information29
2102: ,p_ppm_information30 => p_ppm_information30
2103: );
2104: exception
2105: when hr_api.cannot_find_prog_unit then
2106: hr_api.cannot_find_prog_unit_error
2107: (p_module_name => 'UPDATE_PERSONAL_PAY_METHOD'
2108: ,p_hook_type => 'BP'
2109: );

Line 2106: hr_api.cannot_find_prog_unit_error

2102: ,p_ppm_information30 => p_ppm_information30
2103: );
2104: exception
2105: when hr_api.cannot_find_prog_unit then
2106: hr_api.cannot_find_prog_unit_error
2107: (p_module_name => 'UPDATE_PERSONAL_PAY_METHOD'
2108: ,p_hook_type => 'BP'
2109: );
2110: --

Line 2160: (nvl(p_segment1, hr_api.g_varchar2) <> hr_api.g_varchar2 or

2156: fetch csr_chk_pay_type into l_category;
2157: close csr_chk_pay_type;
2158: --
2159: if l_category <> 'MT'and
2160: (nvl(p_segment1, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2161: nvl(p_segment2, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2162: nvl(p_segment3, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2163: nvl(p_segment4, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2164: nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2 or

Line 2161: nvl(p_segment2, hr_api.g_varchar2) <> hr_api.g_varchar2 or

2157: close csr_chk_pay_type;
2158: --
2159: if l_category <> 'MT'and
2160: (nvl(p_segment1, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2161: nvl(p_segment2, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2162: nvl(p_segment3, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2163: nvl(p_segment4, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2164: nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2165: nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2 or

Line 2162: nvl(p_segment3, hr_api.g_varchar2) <> hr_api.g_varchar2 or

2158: --
2159: if l_category <> 'MT'and
2160: (nvl(p_segment1, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2161: nvl(p_segment2, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2162: nvl(p_segment3, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2163: nvl(p_segment4, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2164: nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2165: nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2166: nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2 or

Line 2163: nvl(p_segment4, hr_api.g_varchar2) <> hr_api.g_varchar2 or

2159: if l_category <> 'MT'and
2160: (nvl(p_segment1, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2161: nvl(p_segment2, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2162: nvl(p_segment3, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2163: nvl(p_segment4, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2164: nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2165: nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2166: nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2167: nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2 or

Line 2164: nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2 or

2160: (nvl(p_segment1, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2161: nvl(p_segment2, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2162: nvl(p_segment3, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2163: nvl(p_segment4, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2164: nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2165: nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2166: nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2167: nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2168: nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2 or

Line 2165: nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2 or

2161: nvl(p_segment2, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2162: nvl(p_segment3, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2163: nvl(p_segment4, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2164: nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2165: nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2166: nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2167: nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2168: nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2169: nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2 or

Line 2166: nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2 or

2162: nvl(p_segment3, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2163: nvl(p_segment4, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2164: nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2165: nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2166: nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2167: nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2168: nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2169: nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2170: nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2 or

Line 2167: nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2 or

2163: nvl(p_segment4, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2164: nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2165: nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2166: nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2167: nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2168: nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2169: nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2170: nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2171: nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2 or

Line 2168: nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2 or

2164: nvl(p_segment5, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2165: nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2166: nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2167: nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2168: nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2169: nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2170: nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2171: nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2172: nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2 or

Line 2169: nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2 or

2165: nvl(p_segment6, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2166: nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2167: nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2168: nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2169: nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2170: nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2171: nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2172: nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2173: nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2 or

Line 2170: nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2 or

2166: nvl(p_segment7, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2167: nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2168: nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2169: nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2170: nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2171: nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2172: nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2173: nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2174: nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2 or

Line 2171: nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2 or

2167: nvl(p_segment8, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2168: nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2169: nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2170: nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2171: nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2172: nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2173: nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2174: nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2175: nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2 or

Line 2172: nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2 or

2168: nvl(p_segment9, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2169: nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2170: nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2171: nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2172: nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2173: nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2174: nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2175: nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2176: nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2 or

Line 2173: nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2 or

2169: nvl(p_segment10, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2170: nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2171: nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2172: nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2173: nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2174: nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2175: nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2176: nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2177: nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2 or

Line 2174: nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2 or

2170: nvl(p_segment11, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2171: nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2172: nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2173: nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2174: nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2175: nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2176: nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2177: nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2178: nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2 or

Line 2175: nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2 or

2171: nvl(p_segment12, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2172: nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2173: nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2174: nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2175: nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2176: nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2177: nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2178: nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2179: nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2 or

Line 2176: nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2 or

2172: nvl(p_segment13, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2173: nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2174: nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2175: nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2176: nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2177: nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2178: nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2179: nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2180: nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2 or

Line 2177: nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2 or

2173: nvl(p_segment14, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2174: nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2175: nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2176: nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2177: nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2178: nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2179: nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2180: nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2181: nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2 or

Line 2178: nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2 or

2174: nvl(p_segment15, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2175: nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2176: nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2177: nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2178: nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2179: nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2180: nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2181: nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2182: nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2 or

Line 2179: nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2 or

2175: nvl(p_segment16, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2176: nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2177: nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2178: nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2179: nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2180: nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2181: nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2182: nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2183: nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2 or

Line 2180: nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2 or

2176: nvl(p_segment17, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2177: nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2178: nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2179: nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2180: nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2181: nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2182: nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2183: nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2184: nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2 or

Line 2181: nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2 or

2177: nvl(p_segment18, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2178: nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2179: nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2180: nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2181: nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2182: nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2183: nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2184: nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2185: nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2 or

Line 2182: nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2 or

2178: nvl(p_segment19, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2179: nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2180: nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2181: nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2182: nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2183: nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2184: nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2185: nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2186: nvl(p_segment27, hr_api.g_varchar2) <> hr_api.g_varchar2 or

Line 2183: nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2 or

2179: nvl(p_segment20, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2180: nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2181: nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2182: nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2183: nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2184: nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2185: nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2186: nvl(p_segment27, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2187: nvl(p_segment28, hr_api.g_varchar2) <> hr_api.g_varchar2 or

Line 2184: nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2 or

2180: nvl(p_segment21, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2181: nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2182: nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2183: nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2184: nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2185: nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2186: nvl(p_segment27, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2187: nvl(p_segment28, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2188: nvl(p_segment29, hr_api.g_varchar2) <> hr_api.g_varchar2 or

Line 2185: nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2 or

2181: nvl(p_segment22, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2182: nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2183: nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2184: nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2185: nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2186: nvl(p_segment27, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2187: nvl(p_segment28, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2188: nvl(p_segment29, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2189: nvl(p_segment30, hr_api.g_varchar2) <> hr_api.g_varchar2) then

Line 2186: nvl(p_segment27, hr_api.g_varchar2) <> hr_api.g_varchar2 or

2182: nvl(p_segment23, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2183: nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2184: nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2185: nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2186: nvl(p_segment27, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2187: nvl(p_segment28, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2188: nvl(p_segment29, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2189: nvl(p_segment30, hr_api.g_varchar2) <> hr_api.g_varchar2) then
2190: --

Line 2187: nvl(p_segment28, hr_api.g_varchar2) <> hr_api.g_varchar2 or

2183: nvl(p_segment24, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2184: nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2185: nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2186: nvl(p_segment27, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2187: nvl(p_segment28, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2188: nvl(p_segment29, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2189: nvl(p_segment30, hr_api.g_varchar2) <> hr_api.g_varchar2) then
2190: --
2191: -- Raise Error

Line 2188: nvl(p_segment29, hr_api.g_varchar2) <> hr_api.g_varchar2 or

2184: nvl(p_segment25, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2185: nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2186: nvl(p_segment27, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2187: nvl(p_segment28, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2188: nvl(p_segment29, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2189: nvl(p_segment30, hr_api.g_varchar2) <> hr_api.g_varchar2) then
2190: --
2191: -- Raise Error
2192: --

Line 2189: nvl(p_segment30, hr_api.g_varchar2) <> hr_api.g_varchar2) then

2185: nvl(p_segment26, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2186: nvl(p_segment27, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2187: nvl(p_segment28, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2188: nvl(p_segment29, hr_api.g_varchar2) <> hr_api.g_varchar2 or
2189: nvl(p_segment30, hr_api.g_varchar2) <> hr_api.g_varchar2) then
2190: --
2191: -- Raise Error
2192: --
2193: hr_utility.set_message(801, 'HR_51377_PPM_NON_MAG_TAPE_SEGM');

Line 2202: -- Bug #3829284. When territory code is defaulted with hr_api.g_varchar2

2198: -- Call table handler pay_exa_upd to control the processing of the external
2199: -- account combination keyflex.
2200: --
2201:
2202: -- Bug #3829284. When territory code is defaulted with hr_api.g_varchar2
2203: -- pass the derived territory code.
2204:
2205: l_exa_territory_code := p_territory_code;
2206:

Line 2207: if p_territory_code = hr_api.g_varchar2 then

2203: -- pass the derived territory code.
2204:
2205: l_exa_territory_code := p_territory_code;
2206:
2207: if p_territory_code = hr_api.g_varchar2 then
2208:
2209: l_exa_territory_code := l_territory_code;
2210:
2211: end if;

Line 2254: ,p_prenote_date => hr_api.g_date

2250: ,p_validate => l_validate
2251: --
2252: -- Special p_prenote_date value after bug2307154 changes.
2253: --
2254: ,p_prenote_date => hr_api.g_date
2255: );
2256: end if;
2257: --
2258: -- Bug 3940935. Derive PPM_INFORMATION_CATEGORY.

Line 2260: l_ppm_information_category := hr_api.g_varchar2;

2256: end if;
2257: --
2258: -- Bug 3940935. Derive PPM_INFORMATION_CATEGORY.
2259: --
2260: l_ppm_information_category := hr_api.g_varchar2;
2261:
2262: if ((p_ppm_information1 <> hr_api.g_varchar2 or
2263: p_ppm_information2 <> hr_api.g_varchar2 or
2264: p_ppm_information3 <> hr_api.g_varchar2 or

Line 2262: if ((p_ppm_information1 <> hr_api.g_varchar2 or

2258: -- Bug 3940935. Derive PPM_INFORMATION_CATEGORY.
2259: --
2260: l_ppm_information_category := hr_api.g_varchar2;
2261:
2262: if ((p_ppm_information1 <> hr_api.g_varchar2 or
2263: p_ppm_information2 <> hr_api.g_varchar2 or
2264: p_ppm_information3 <> hr_api.g_varchar2 or
2265: p_ppm_information4 <> hr_api.g_varchar2 or
2266: p_ppm_information5 <> hr_api.g_varchar2 or

Line 2263: p_ppm_information2 <> hr_api.g_varchar2 or

2259: --
2260: l_ppm_information_category := hr_api.g_varchar2;
2261:
2262: if ((p_ppm_information1 <> hr_api.g_varchar2 or
2263: p_ppm_information2 <> hr_api.g_varchar2 or
2264: p_ppm_information3 <> hr_api.g_varchar2 or
2265: p_ppm_information4 <> hr_api.g_varchar2 or
2266: p_ppm_information5 <> hr_api.g_varchar2 or
2267: p_ppm_information6 <> hr_api.g_varchar2 or

Line 2264: p_ppm_information3 <> hr_api.g_varchar2 or

2260: l_ppm_information_category := hr_api.g_varchar2;
2261:
2262: if ((p_ppm_information1 <> hr_api.g_varchar2 or
2263: p_ppm_information2 <> hr_api.g_varchar2 or
2264: p_ppm_information3 <> hr_api.g_varchar2 or
2265: p_ppm_information4 <> hr_api.g_varchar2 or
2266: p_ppm_information5 <> hr_api.g_varchar2 or
2267: p_ppm_information6 <> hr_api.g_varchar2 or
2268: p_ppm_information7 <> hr_api.g_varchar2 or

Line 2265: p_ppm_information4 <> hr_api.g_varchar2 or

2261:
2262: if ((p_ppm_information1 <> hr_api.g_varchar2 or
2263: p_ppm_information2 <> hr_api.g_varchar2 or
2264: p_ppm_information3 <> hr_api.g_varchar2 or
2265: p_ppm_information4 <> hr_api.g_varchar2 or
2266: p_ppm_information5 <> hr_api.g_varchar2 or
2267: p_ppm_information6 <> hr_api.g_varchar2 or
2268: p_ppm_information7 <> hr_api.g_varchar2 or
2269: p_ppm_information8 <> hr_api.g_varchar2 or

Line 2266: p_ppm_information5 <> hr_api.g_varchar2 or

2262: if ((p_ppm_information1 <> hr_api.g_varchar2 or
2263: p_ppm_information2 <> hr_api.g_varchar2 or
2264: p_ppm_information3 <> hr_api.g_varchar2 or
2265: p_ppm_information4 <> hr_api.g_varchar2 or
2266: p_ppm_information5 <> hr_api.g_varchar2 or
2267: p_ppm_information6 <> hr_api.g_varchar2 or
2268: p_ppm_information7 <> hr_api.g_varchar2 or
2269: p_ppm_information8 <> hr_api.g_varchar2 or
2270: p_ppm_information9 <> hr_api.g_varchar2 or

Line 2267: p_ppm_information6 <> hr_api.g_varchar2 or

2263: p_ppm_information2 <> hr_api.g_varchar2 or
2264: p_ppm_information3 <> hr_api.g_varchar2 or
2265: p_ppm_information4 <> hr_api.g_varchar2 or
2266: p_ppm_information5 <> hr_api.g_varchar2 or
2267: p_ppm_information6 <> hr_api.g_varchar2 or
2268: p_ppm_information7 <> hr_api.g_varchar2 or
2269: p_ppm_information8 <> hr_api.g_varchar2 or
2270: p_ppm_information9 <> hr_api.g_varchar2 or
2271: p_ppm_information10 <> hr_api.g_varchar2 or

Line 2268: p_ppm_information7 <> hr_api.g_varchar2 or

2264: p_ppm_information3 <> hr_api.g_varchar2 or
2265: p_ppm_information4 <> hr_api.g_varchar2 or
2266: p_ppm_information5 <> hr_api.g_varchar2 or
2267: p_ppm_information6 <> hr_api.g_varchar2 or
2268: p_ppm_information7 <> hr_api.g_varchar2 or
2269: p_ppm_information8 <> hr_api.g_varchar2 or
2270: p_ppm_information9 <> hr_api.g_varchar2 or
2271: p_ppm_information10 <> hr_api.g_varchar2 or
2272: p_ppm_information11 <> hr_api.g_varchar2 or

Line 2269: p_ppm_information8 <> hr_api.g_varchar2 or

2265: p_ppm_information4 <> hr_api.g_varchar2 or
2266: p_ppm_information5 <> hr_api.g_varchar2 or
2267: p_ppm_information6 <> hr_api.g_varchar2 or
2268: p_ppm_information7 <> hr_api.g_varchar2 or
2269: p_ppm_information8 <> hr_api.g_varchar2 or
2270: p_ppm_information9 <> hr_api.g_varchar2 or
2271: p_ppm_information10 <> hr_api.g_varchar2 or
2272: p_ppm_information11 <> hr_api.g_varchar2 or
2273: p_ppm_information12 <> hr_api.g_varchar2 or

Line 2270: p_ppm_information9 <> hr_api.g_varchar2 or

2266: p_ppm_information5 <> hr_api.g_varchar2 or
2267: p_ppm_information6 <> hr_api.g_varchar2 or
2268: p_ppm_information7 <> hr_api.g_varchar2 or
2269: p_ppm_information8 <> hr_api.g_varchar2 or
2270: p_ppm_information9 <> hr_api.g_varchar2 or
2271: p_ppm_information10 <> hr_api.g_varchar2 or
2272: p_ppm_information11 <> hr_api.g_varchar2 or
2273: p_ppm_information12 <> hr_api.g_varchar2 or
2274: p_ppm_information13 <> hr_api.g_varchar2 or

Line 2271: p_ppm_information10 <> hr_api.g_varchar2 or

2267: p_ppm_information6 <> hr_api.g_varchar2 or
2268: p_ppm_information7 <> hr_api.g_varchar2 or
2269: p_ppm_information8 <> hr_api.g_varchar2 or
2270: p_ppm_information9 <> hr_api.g_varchar2 or
2271: p_ppm_information10 <> hr_api.g_varchar2 or
2272: p_ppm_information11 <> hr_api.g_varchar2 or
2273: p_ppm_information12 <> hr_api.g_varchar2 or
2274: p_ppm_information13 <> hr_api.g_varchar2 or
2275: p_ppm_information14 <> hr_api.g_varchar2 or

Line 2272: p_ppm_information11 <> hr_api.g_varchar2 or

2268: p_ppm_information7 <> hr_api.g_varchar2 or
2269: p_ppm_information8 <> hr_api.g_varchar2 or
2270: p_ppm_information9 <> hr_api.g_varchar2 or
2271: p_ppm_information10 <> hr_api.g_varchar2 or
2272: p_ppm_information11 <> hr_api.g_varchar2 or
2273: p_ppm_information12 <> hr_api.g_varchar2 or
2274: p_ppm_information13 <> hr_api.g_varchar2 or
2275: p_ppm_information14 <> hr_api.g_varchar2 or
2276: p_ppm_information15 <> hr_api.g_varchar2 or

Line 2273: p_ppm_information12 <> hr_api.g_varchar2 or

2269: p_ppm_information8 <> hr_api.g_varchar2 or
2270: p_ppm_information9 <> hr_api.g_varchar2 or
2271: p_ppm_information10 <> hr_api.g_varchar2 or
2272: p_ppm_information11 <> hr_api.g_varchar2 or
2273: p_ppm_information12 <> hr_api.g_varchar2 or
2274: p_ppm_information13 <> hr_api.g_varchar2 or
2275: p_ppm_information14 <> hr_api.g_varchar2 or
2276: p_ppm_information15 <> hr_api.g_varchar2 or
2277: p_ppm_information16 <> hr_api.g_varchar2 or

Line 2274: p_ppm_information13 <> hr_api.g_varchar2 or

2270: p_ppm_information9 <> hr_api.g_varchar2 or
2271: p_ppm_information10 <> hr_api.g_varchar2 or
2272: p_ppm_information11 <> hr_api.g_varchar2 or
2273: p_ppm_information12 <> hr_api.g_varchar2 or
2274: p_ppm_information13 <> hr_api.g_varchar2 or
2275: p_ppm_information14 <> hr_api.g_varchar2 or
2276: p_ppm_information15 <> hr_api.g_varchar2 or
2277: p_ppm_information16 <> hr_api.g_varchar2 or
2278: p_ppm_information17 <> hr_api.g_varchar2 or

Line 2275: p_ppm_information14 <> hr_api.g_varchar2 or

2271: p_ppm_information10 <> hr_api.g_varchar2 or
2272: p_ppm_information11 <> hr_api.g_varchar2 or
2273: p_ppm_information12 <> hr_api.g_varchar2 or
2274: p_ppm_information13 <> hr_api.g_varchar2 or
2275: p_ppm_information14 <> hr_api.g_varchar2 or
2276: p_ppm_information15 <> hr_api.g_varchar2 or
2277: p_ppm_information16 <> hr_api.g_varchar2 or
2278: p_ppm_information17 <> hr_api.g_varchar2 or
2279: p_ppm_information18 <> hr_api.g_varchar2 or

Line 2276: p_ppm_information15 <> hr_api.g_varchar2 or

2272: p_ppm_information11 <> hr_api.g_varchar2 or
2273: p_ppm_information12 <> hr_api.g_varchar2 or
2274: p_ppm_information13 <> hr_api.g_varchar2 or
2275: p_ppm_information14 <> hr_api.g_varchar2 or
2276: p_ppm_information15 <> hr_api.g_varchar2 or
2277: p_ppm_information16 <> hr_api.g_varchar2 or
2278: p_ppm_information17 <> hr_api.g_varchar2 or
2279: p_ppm_information18 <> hr_api.g_varchar2 or
2280: p_ppm_information19 <> hr_api.g_varchar2 or

Line 2277: p_ppm_information16 <> hr_api.g_varchar2 or

2273: p_ppm_information12 <> hr_api.g_varchar2 or
2274: p_ppm_information13 <> hr_api.g_varchar2 or
2275: p_ppm_information14 <> hr_api.g_varchar2 or
2276: p_ppm_information15 <> hr_api.g_varchar2 or
2277: p_ppm_information16 <> hr_api.g_varchar2 or
2278: p_ppm_information17 <> hr_api.g_varchar2 or
2279: p_ppm_information18 <> hr_api.g_varchar2 or
2280: p_ppm_information19 <> hr_api.g_varchar2 or
2281: p_ppm_information20 <> hr_api.g_varchar2 or

Line 2278: p_ppm_information17 <> hr_api.g_varchar2 or

2274: p_ppm_information13 <> hr_api.g_varchar2 or
2275: p_ppm_information14 <> hr_api.g_varchar2 or
2276: p_ppm_information15 <> hr_api.g_varchar2 or
2277: p_ppm_information16 <> hr_api.g_varchar2 or
2278: p_ppm_information17 <> hr_api.g_varchar2 or
2279: p_ppm_information18 <> hr_api.g_varchar2 or
2280: p_ppm_information19 <> hr_api.g_varchar2 or
2281: p_ppm_information20 <> hr_api.g_varchar2 or
2282: p_ppm_information21 <> hr_api.g_varchar2 or

Line 2279: p_ppm_information18 <> hr_api.g_varchar2 or

2275: p_ppm_information14 <> hr_api.g_varchar2 or
2276: p_ppm_information15 <> hr_api.g_varchar2 or
2277: p_ppm_information16 <> hr_api.g_varchar2 or
2278: p_ppm_information17 <> hr_api.g_varchar2 or
2279: p_ppm_information18 <> hr_api.g_varchar2 or
2280: p_ppm_information19 <> hr_api.g_varchar2 or
2281: p_ppm_information20 <> hr_api.g_varchar2 or
2282: p_ppm_information21 <> hr_api.g_varchar2 or
2283: p_ppm_information22 <> hr_api.g_varchar2 or

Line 2280: p_ppm_information19 <> hr_api.g_varchar2 or

2276: p_ppm_information15 <> hr_api.g_varchar2 or
2277: p_ppm_information16 <> hr_api.g_varchar2 or
2278: p_ppm_information17 <> hr_api.g_varchar2 or
2279: p_ppm_information18 <> hr_api.g_varchar2 or
2280: p_ppm_information19 <> hr_api.g_varchar2 or
2281: p_ppm_information20 <> hr_api.g_varchar2 or
2282: p_ppm_information21 <> hr_api.g_varchar2 or
2283: p_ppm_information22 <> hr_api.g_varchar2 or
2284: p_ppm_information23 <> hr_api.g_varchar2 or

Line 2281: p_ppm_information20 <> hr_api.g_varchar2 or

2277: p_ppm_information16 <> hr_api.g_varchar2 or
2278: p_ppm_information17 <> hr_api.g_varchar2 or
2279: p_ppm_information18 <> hr_api.g_varchar2 or
2280: p_ppm_information19 <> hr_api.g_varchar2 or
2281: p_ppm_information20 <> hr_api.g_varchar2 or
2282: p_ppm_information21 <> hr_api.g_varchar2 or
2283: p_ppm_information22 <> hr_api.g_varchar2 or
2284: p_ppm_information23 <> hr_api.g_varchar2 or
2285: p_ppm_information24 <> hr_api.g_varchar2 or

Line 2282: p_ppm_information21 <> hr_api.g_varchar2 or

2278: p_ppm_information17 <> hr_api.g_varchar2 or
2279: p_ppm_information18 <> hr_api.g_varchar2 or
2280: p_ppm_information19 <> hr_api.g_varchar2 or
2281: p_ppm_information20 <> hr_api.g_varchar2 or
2282: p_ppm_information21 <> hr_api.g_varchar2 or
2283: p_ppm_information22 <> hr_api.g_varchar2 or
2284: p_ppm_information23 <> hr_api.g_varchar2 or
2285: p_ppm_information24 <> hr_api.g_varchar2 or
2286: p_ppm_information25 <> hr_api.g_varchar2 or

Line 2283: p_ppm_information22 <> hr_api.g_varchar2 or

2279: p_ppm_information18 <> hr_api.g_varchar2 or
2280: p_ppm_information19 <> hr_api.g_varchar2 or
2281: p_ppm_information20 <> hr_api.g_varchar2 or
2282: p_ppm_information21 <> hr_api.g_varchar2 or
2283: p_ppm_information22 <> hr_api.g_varchar2 or
2284: p_ppm_information23 <> hr_api.g_varchar2 or
2285: p_ppm_information24 <> hr_api.g_varchar2 or
2286: p_ppm_information25 <> hr_api.g_varchar2 or
2287: p_ppm_information26 <> hr_api.g_varchar2 or

Line 2284: p_ppm_information23 <> hr_api.g_varchar2 or

2280: p_ppm_information19 <> hr_api.g_varchar2 or
2281: p_ppm_information20 <> hr_api.g_varchar2 or
2282: p_ppm_information21 <> hr_api.g_varchar2 or
2283: p_ppm_information22 <> hr_api.g_varchar2 or
2284: p_ppm_information23 <> hr_api.g_varchar2 or
2285: p_ppm_information24 <> hr_api.g_varchar2 or
2286: p_ppm_information25 <> hr_api.g_varchar2 or
2287: p_ppm_information26 <> hr_api.g_varchar2 or
2288: p_ppm_information27 <> hr_api.g_varchar2 or

Line 2285: p_ppm_information24 <> hr_api.g_varchar2 or

2281: p_ppm_information20 <> hr_api.g_varchar2 or
2282: p_ppm_information21 <> hr_api.g_varchar2 or
2283: p_ppm_information22 <> hr_api.g_varchar2 or
2284: p_ppm_information23 <> hr_api.g_varchar2 or
2285: p_ppm_information24 <> hr_api.g_varchar2 or
2286: p_ppm_information25 <> hr_api.g_varchar2 or
2287: p_ppm_information26 <> hr_api.g_varchar2 or
2288: p_ppm_information27 <> hr_api.g_varchar2 or
2289: p_ppm_information28 <> hr_api.g_varchar2 or

Line 2286: p_ppm_information25 <> hr_api.g_varchar2 or

2282: p_ppm_information21 <> hr_api.g_varchar2 or
2283: p_ppm_information22 <> hr_api.g_varchar2 or
2284: p_ppm_information23 <> hr_api.g_varchar2 or
2285: p_ppm_information24 <> hr_api.g_varchar2 or
2286: p_ppm_information25 <> hr_api.g_varchar2 or
2287: p_ppm_information26 <> hr_api.g_varchar2 or
2288: p_ppm_information27 <> hr_api.g_varchar2 or
2289: p_ppm_information28 <> hr_api.g_varchar2 or
2290: p_ppm_information29 <> hr_api.g_varchar2 or

Line 2287: p_ppm_information26 <> hr_api.g_varchar2 or

2283: p_ppm_information22 <> hr_api.g_varchar2 or
2284: p_ppm_information23 <> hr_api.g_varchar2 or
2285: p_ppm_information24 <> hr_api.g_varchar2 or
2286: p_ppm_information25 <> hr_api.g_varchar2 or
2287: p_ppm_information26 <> hr_api.g_varchar2 or
2288: p_ppm_information27 <> hr_api.g_varchar2 or
2289: p_ppm_information28 <> hr_api.g_varchar2 or
2290: p_ppm_information29 <> hr_api.g_varchar2 or
2291: p_ppm_information30 <> hr_api.g_varchar2 ) and

Line 2288: p_ppm_information27 <> hr_api.g_varchar2 or

2284: p_ppm_information23 <> hr_api.g_varchar2 or
2285: p_ppm_information24 <> hr_api.g_varchar2 or
2286: p_ppm_information25 <> hr_api.g_varchar2 or
2287: p_ppm_information26 <> hr_api.g_varchar2 or
2288: p_ppm_information27 <> hr_api.g_varchar2 or
2289: p_ppm_information28 <> hr_api.g_varchar2 or
2290: p_ppm_information29 <> hr_api.g_varchar2 or
2291: p_ppm_information30 <> hr_api.g_varchar2 ) and
2292: p_ppm_information_category = hr_api.g_varchar2 )then --6439573

Line 2289: p_ppm_information28 <> hr_api.g_varchar2 or

2285: p_ppm_information24 <> hr_api.g_varchar2 or
2286: p_ppm_information25 <> hr_api.g_varchar2 or
2287: p_ppm_information26 <> hr_api.g_varchar2 or
2288: p_ppm_information27 <> hr_api.g_varchar2 or
2289: p_ppm_information28 <> hr_api.g_varchar2 or
2290: p_ppm_information29 <> hr_api.g_varchar2 or
2291: p_ppm_information30 <> hr_api.g_varchar2 ) and
2292: p_ppm_information_category = hr_api.g_varchar2 )then --6439573
2293:

Line 2290: p_ppm_information29 <> hr_api.g_varchar2 or

2286: p_ppm_information25 <> hr_api.g_varchar2 or
2287: p_ppm_information26 <> hr_api.g_varchar2 or
2288: p_ppm_information27 <> hr_api.g_varchar2 or
2289: p_ppm_information28 <> hr_api.g_varchar2 or
2290: p_ppm_information29 <> hr_api.g_varchar2 or
2291: p_ppm_information30 <> hr_api.g_varchar2 ) and
2292: p_ppm_information_category = hr_api.g_varchar2 )then --6439573
2293:
2294: open csr_ppm_info_category ( p_personal_payment_method_id => p_personal_payment_method_id

Line 2291: p_ppm_information30 <> hr_api.g_varchar2 ) and

2287: p_ppm_information26 <> hr_api.g_varchar2 or
2288: p_ppm_information27 <> hr_api.g_varchar2 or
2289: p_ppm_information28 <> hr_api.g_varchar2 or
2290: p_ppm_information29 <> hr_api.g_varchar2 or
2291: p_ppm_information30 <> hr_api.g_varchar2 ) and
2292: p_ppm_information_category = hr_api.g_varchar2 )then --6439573
2293:
2294: open csr_ppm_info_category ( p_personal_payment_method_id => p_personal_payment_method_id
2295: ,p_effective_date => p_effective_date );

Line 2292: p_ppm_information_category = hr_api.g_varchar2 )then --6439573

2288: p_ppm_information27 <> hr_api.g_varchar2 or
2289: p_ppm_information28 <> hr_api.g_varchar2 or
2290: p_ppm_information29 <> hr_api.g_varchar2 or
2291: p_ppm_information30 <> hr_api.g_varchar2 ) and
2292: p_ppm_information_category = hr_api.g_varchar2 )then --6439573
2293:
2294: open csr_ppm_info_category ( p_personal_payment_method_id => p_personal_payment_method_id
2295: ,p_effective_date => p_effective_date );
2296:

Line 2306: elsif p_ppm_information_category <> hr_api.g_varchar2 then

2302: fnd_message.raise_error;
2303: end if;
2304: close csr_ppm_info_category;
2305: /* Bug 6439573 ppm_info_category is not null, then assigned to the local one */
2306: elsif p_ppm_information_category <> hr_api.g_varchar2 then
2307: l_ppm_information_category := p_ppm_information_category;
2308: end if;
2309: --
2310: if g_debug then

Line 2509: when hr_api.cannot_find_prog_unit then

2505: ,p_ppm_information29 => p_ppm_information29
2506: ,p_ppm_information30 => p_ppm_information30
2507: );
2508: exception
2509: when hr_api.cannot_find_prog_unit then
2510: hr_api.cannot_find_prog_unit_error
2511: (p_module_name => 'UPDATE_PERSONAL_PAY_METHOD'
2512: ,p_hook_type => 'AP'
2513: );

Line 2510: hr_api.cannot_find_prog_unit_error

2506: ,p_ppm_information30 => p_ppm_information30
2507: );
2508: exception
2509: when hr_api.cannot_find_prog_unit then
2510: hr_api.cannot_find_prog_unit_error
2511: (p_module_name => 'UPDATE_PERSONAL_PAY_METHOD'
2512: ,p_hook_type => 'AP'
2513: );
2514: --

Line 2522: raise hr_api.validate_enabled;

2518: --
2519: -- When in validation only mode raise the Validate_Enabled exception
2520: --
2521: if p_validate then
2522: raise hr_api.validate_enabled;
2523: end if;
2524: --
2525: -- Set remaining output arguments
2526: --

Line 2537: when hr_api.validate_enabled then

2533: hr_utility.set_location(' Leaving:'||l_proc, 10);
2534: end if;
2535: --
2536: exception
2537: when hr_api.validate_enabled then
2538: --
2539: -- As the Validate_Enabled exception has been raised
2540: -- we must rollback to the savepoint
2541: --

Line 2585: ,p_account_name in varchar2 default hr_api.g_varchar2

2581: ,p_effective_date in date
2582: ,p_datetrack_update_mode in varchar2
2583: ,p_personal_payment_method_id in number
2584: ,p_object_version_number in out nocopy number
2585: ,p_account_name in varchar2 default hr_api.g_varchar2
2586: ,p_account_number in varchar2 default hr_api.g_varchar2
2587: ,p_sort_code in varchar2 default hr_api.g_varchar2
2588: ,p_bank_name in varchar2 default hr_api.g_varchar2
2589: ,p_account_type in varchar2 default hr_api.g_varchar2

Line 2586: ,p_account_number in varchar2 default hr_api.g_varchar2

2582: ,p_datetrack_update_mode in varchar2
2583: ,p_personal_payment_method_id in number
2584: ,p_object_version_number in out nocopy number
2585: ,p_account_name in varchar2 default hr_api.g_varchar2
2586: ,p_account_number in varchar2 default hr_api.g_varchar2
2587: ,p_sort_code in varchar2 default hr_api.g_varchar2
2588: ,p_bank_name in varchar2 default hr_api.g_varchar2
2589: ,p_account_type in varchar2 default hr_api.g_varchar2
2590: ,p_bank_branch in varchar2 default hr_api.g_varchar2

Line 2587: ,p_sort_code in varchar2 default hr_api.g_varchar2

2583: ,p_personal_payment_method_id in number
2584: ,p_object_version_number in out nocopy number
2585: ,p_account_name in varchar2 default hr_api.g_varchar2
2586: ,p_account_number in varchar2 default hr_api.g_varchar2
2587: ,p_sort_code in varchar2 default hr_api.g_varchar2
2588: ,p_bank_name in varchar2 default hr_api.g_varchar2
2589: ,p_account_type in varchar2 default hr_api.g_varchar2
2590: ,p_bank_branch in varchar2 default hr_api.g_varchar2
2591: ,p_bank_branch_location in varchar2 default hr_api.g_varchar2

Line 2588: ,p_bank_name in varchar2 default hr_api.g_varchar2

2584: ,p_object_version_number in out nocopy number
2585: ,p_account_name in varchar2 default hr_api.g_varchar2
2586: ,p_account_number in varchar2 default hr_api.g_varchar2
2587: ,p_sort_code in varchar2 default hr_api.g_varchar2
2588: ,p_bank_name in varchar2 default hr_api.g_varchar2
2589: ,p_account_type in varchar2 default hr_api.g_varchar2
2590: ,p_bank_branch in varchar2 default hr_api.g_varchar2
2591: ,p_bank_branch_location in varchar2 default hr_api.g_varchar2
2592: ,p_bldg_society_account_number in varchar2 default hr_api.g_varchar2

Line 2589: ,p_account_type in varchar2 default hr_api.g_varchar2

2585: ,p_account_name in varchar2 default hr_api.g_varchar2
2586: ,p_account_number in varchar2 default hr_api.g_varchar2
2587: ,p_sort_code in varchar2 default hr_api.g_varchar2
2588: ,p_bank_name in varchar2 default hr_api.g_varchar2
2589: ,p_account_type in varchar2 default hr_api.g_varchar2
2590: ,p_bank_branch in varchar2 default hr_api.g_varchar2
2591: ,p_bank_branch_location in varchar2 default hr_api.g_varchar2
2592: ,p_bldg_society_account_number in varchar2 default hr_api.g_varchar2
2593: ,p_amount in number default hr_api.g_number

Line 2590: ,p_bank_branch in varchar2 default hr_api.g_varchar2

2586: ,p_account_number in varchar2 default hr_api.g_varchar2
2587: ,p_sort_code in varchar2 default hr_api.g_varchar2
2588: ,p_bank_name in varchar2 default hr_api.g_varchar2
2589: ,p_account_type in varchar2 default hr_api.g_varchar2
2590: ,p_bank_branch in varchar2 default hr_api.g_varchar2
2591: ,p_bank_branch_location in varchar2 default hr_api.g_varchar2
2592: ,p_bldg_society_account_number in varchar2 default hr_api.g_varchar2
2593: ,p_amount in number default hr_api.g_number
2594: ,p_comments in varchar2 default hr_api.g_varchar2

Line 2591: ,p_bank_branch_location in varchar2 default hr_api.g_varchar2

2587: ,p_sort_code in varchar2 default hr_api.g_varchar2
2588: ,p_bank_name in varchar2 default hr_api.g_varchar2
2589: ,p_account_type in varchar2 default hr_api.g_varchar2
2590: ,p_bank_branch in varchar2 default hr_api.g_varchar2
2591: ,p_bank_branch_location in varchar2 default hr_api.g_varchar2
2592: ,p_bldg_society_account_number in varchar2 default hr_api.g_varchar2
2593: ,p_amount in number default hr_api.g_number
2594: ,p_comments in varchar2 default hr_api.g_varchar2
2595: ,p_percentage in number default hr_api.g_number

Line 2592: ,p_bldg_society_account_number in varchar2 default hr_api.g_varchar2

2588: ,p_bank_name in varchar2 default hr_api.g_varchar2
2589: ,p_account_type in varchar2 default hr_api.g_varchar2
2590: ,p_bank_branch in varchar2 default hr_api.g_varchar2
2591: ,p_bank_branch_location in varchar2 default hr_api.g_varchar2
2592: ,p_bldg_society_account_number in varchar2 default hr_api.g_varchar2
2593: ,p_amount in number default hr_api.g_number
2594: ,p_comments in varchar2 default hr_api.g_varchar2
2595: ,p_percentage in number default hr_api.g_number
2596: ,p_priority in number default hr_api.g_number

Line 2593: ,p_amount in number default hr_api.g_number

2589: ,p_account_type in varchar2 default hr_api.g_varchar2
2590: ,p_bank_branch in varchar2 default hr_api.g_varchar2
2591: ,p_bank_branch_location in varchar2 default hr_api.g_varchar2
2592: ,p_bldg_society_account_number in varchar2 default hr_api.g_varchar2
2593: ,p_amount in number default hr_api.g_number
2594: ,p_comments in varchar2 default hr_api.g_varchar2
2595: ,p_percentage in number default hr_api.g_number
2596: ,p_priority in number default hr_api.g_number
2597: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 2594: ,p_comments in varchar2 default hr_api.g_varchar2

2590: ,p_bank_branch in varchar2 default hr_api.g_varchar2
2591: ,p_bank_branch_location in varchar2 default hr_api.g_varchar2
2592: ,p_bldg_society_account_number in varchar2 default hr_api.g_varchar2
2593: ,p_amount in number default hr_api.g_number
2594: ,p_comments in varchar2 default hr_api.g_varchar2
2595: ,p_percentage in number default hr_api.g_number
2596: ,p_priority in number default hr_api.g_number
2597: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2598: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 2595: ,p_percentage in number default hr_api.g_number

2591: ,p_bank_branch_location in varchar2 default hr_api.g_varchar2
2592: ,p_bldg_society_account_number in varchar2 default hr_api.g_varchar2
2593: ,p_amount in number default hr_api.g_number
2594: ,p_comments in varchar2 default hr_api.g_varchar2
2595: ,p_percentage in number default hr_api.g_number
2596: ,p_priority in number default hr_api.g_number
2597: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2598: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2599: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 2596: ,p_priority in number default hr_api.g_number

2592: ,p_bldg_society_account_number in varchar2 default hr_api.g_varchar2
2593: ,p_amount in number default hr_api.g_number
2594: ,p_comments in varchar2 default hr_api.g_varchar2
2595: ,p_percentage in number default hr_api.g_number
2596: ,p_priority in number default hr_api.g_number
2597: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2598: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2599: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2600: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 2597: ,p_attribute_category in varchar2 default hr_api.g_varchar2

2593: ,p_amount in number default hr_api.g_number
2594: ,p_comments in varchar2 default hr_api.g_varchar2
2595: ,p_percentage in number default hr_api.g_number
2596: ,p_priority in number default hr_api.g_number
2597: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2598: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2599: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2600: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2601: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 2598: ,p_attribute1 in varchar2 default hr_api.g_varchar2

2594: ,p_comments in varchar2 default hr_api.g_varchar2
2595: ,p_percentage in number default hr_api.g_number
2596: ,p_priority in number default hr_api.g_number
2597: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2598: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2599: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2600: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2601: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2602: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 2599: ,p_attribute2 in varchar2 default hr_api.g_varchar2

2595: ,p_percentage in number default hr_api.g_number
2596: ,p_priority in number default hr_api.g_number
2597: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2598: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2599: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2600: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2601: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2602: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2603: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 2600: ,p_attribute3 in varchar2 default hr_api.g_varchar2

2596: ,p_priority in number default hr_api.g_number
2597: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2598: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2599: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2600: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2601: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2602: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2603: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2604: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 2601: ,p_attribute4 in varchar2 default hr_api.g_varchar2

2597: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2598: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2599: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2600: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2601: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2602: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2603: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2604: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2605: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 2602: ,p_attribute5 in varchar2 default hr_api.g_varchar2

2598: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2599: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2600: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2601: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2602: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2603: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2604: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2605: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2606: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 2603: ,p_attribute6 in varchar2 default hr_api.g_varchar2

2599: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2600: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2601: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2602: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2603: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2604: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2605: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2606: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2607: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 2604: ,p_attribute7 in varchar2 default hr_api.g_varchar2

2600: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2601: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2602: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2603: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2604: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2605: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2606: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2607: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2608: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 2605: ,p_attribute8 in varchar2 default hr_api.g_varchar2

2601: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2602: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2603: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2604: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2605: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2606: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2607: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2608: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2609: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 2606: ,p_attribute9 in varchar2 default hr_api.g_varchar2

2602: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2603: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2604: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2605: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2606: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2607: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2608: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2609: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2610: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 2607: ,p_attribute10 in varchar2 default hr_api.g_varchar2

2603: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2604: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2605: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2606: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2607: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2608: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2609: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2610: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2611: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 2608: ,p_attribute11 in varchar2 default hr_api.g_varchar2

2604: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2605: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2606: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2607: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2608: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2609: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2610: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2611: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2612: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 2609: ,p_attribute12 in varchar2 default hr_api.g_varchar2

2605: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2606: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2607: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2608: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2609: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2610: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2611: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2612: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2613: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 2610: ,p_attribute13 in varchar2 default hr_api.g_varchar2

2606: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2607: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2608: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2609: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2610: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2611: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2612: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2613: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2614: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 2611: ,p_attribute14 in varchar2 default hr_api.g_varchar2

2607: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2608: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2609: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2610: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2611: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2612: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2613: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2614: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2615: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 2612: ,p_attribute15 in varchar2 default hr_api.g_varchar2

2608: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2609: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2610: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2611: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2612: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2613: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2614: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2615: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2616: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 2613: ,p_attribute16 in varchar2 default hr_api.g_varchar2

2609: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2610: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2611: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2612: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2613: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2614: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2615: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2616: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2617: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 2614: ,p_attribute17 in varchar2 default hr_api.g_varchar2

2610: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2611: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2612: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2613: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2614: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2615: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2616: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2617: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2618: ,p_payee_type in varchar2 default hr_api.g_varchar2

Line 2615: ,p_attribute18 in varchar2 default hr_api.g_varchar2

2611: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2612: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2613: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2614: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2615: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2616: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2617: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2618: ,p_payee_type in varchar2 default hr_api.g_varchar2
2619: ,p_payee_id in number default hr_api.g_number

Line 2616: ,p_attribute19 in varchar2 default hr_api.g_varchar2

2612: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2613: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2614: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2615: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2616: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2617: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2618: ,p_payee_type in varchar2 default hr_api.g_varchar2
2619: ,p_payee_id in number default hr_api.g_number
2620: ,p_territory_code in varchar2 default hr_api.g_varchar2

Line 2617: ,p_attribute20 in varchar2 default hr_api.g_varchar2

2613: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2614: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2615: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2616: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2617: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2618: ,p_payee_type in varchar2 default hr_api.g_varchar2
2619: ,p_payee_id in number default hr_api.g_number
2620: ,p_territory_code in varchar2 default hr_api.g_varchar2
2621: ,p_comment_id out nocopy number

Line 2618: ,p_payee_type in varchar2 default hr_api.g_varchar2

2614: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2615: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2616: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2617: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2618: ,p_payee_type in varchar2 default hr_api.g_varchar2
2619: ,p_payee_id in number default hr_api.g_number
2620: ,p_territory_code in varchar2 default hr_api.g_varchar2
2621: ,p_comment_id out nocopy number
2622: ,p_external_account_id out nocopy number

Line 2619: ,p_payee_id in number default hr_api.g_number

2615: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2616: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2617: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2618: ,p_payee_type in varchar2 default hr_api.g_varchar2
2619: ,p_payee_id in number default hr_api.g_number
2620: ,p_territory_code in varchar2 default hr_api.g_varchar2
2621: ,p_comment_id out nocopy number
2622: ,p_external_account_id out nocopy number
2623: ,p_effective_start_date out nocopy date

Line 2620: ,p_territory_code in varchar2 default hr_api.g_varchar2

2616: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2617: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2618: ,p_payee_type in varchar2 default hr_api.g_varchar2
2619: ,p_payee_id in number default hr_api.g_number
2620: ,p_territory_code in varchar2 default hr_api.g_varchar2
2621: ,p_comment_id out nocopy number
2622: ,p_external_account_id out nocopy number
2623: ,p_effective_start_date out nocopy date
2624: ,p_effective_end_date out nocopy date

Line 2759: ,p_account_name in varchar2 default hr_api.g_varchar2

2755: ,p_effective_date in date
2756: ,p_datetrack_update_mode in varchar2
2757: ,p_personal_payment_method_id in number
2758: ,p_object_version_number in out nocopy number
2759: ,p_account_name in varchar2 default hr_api.g_varchar2
2760: ,p_account_number in varchar2 default hr_api.g_varchar2
2761: ,p_transit_code in varchar2 default hr_api.g_varchar2
2762: ,p_bank_name in varchar2 default hr_api.g_varchar2
2763: ,p_account_type in varchar2 default hr_api.g_varchar2

Line 2760: ,p_account_number in varchar2 default hr_api.g_varchar2

2756: ,p_datetrack_update_mode in varchar2
2757: ,p_personal_payment_method_id in number
2758: ,p_object_version_number in out nocopy number
2759: ,p_account_name in varchar2 default hr_api.g_varchar2
2760: ,p_account_number in varchar2 default hr_api.g_varchar2
2761: ,p_transit_code in varchar2 default hr_api.g_varchar2
2762: ,p_bank_name in varchar2 default hr_api.g_varchar2
2763: ,p_account_type in varchar2 default hr_api.g_varchar2
2764: ,p_bank_branch in varchar2 default hr_api.g_varchar2

Line 2761: ,p_transit_code in varchar2 default hr_api.g_varchar2

2757: ,p_personal_payment_method_id in number
2758: ,p_object_version_number in out nocopy number
2759: ,p_account_name in varchar2 default hr_api.g_varchar2
2760: ,p_account_number in varchar2 default hr_api.g_varchar2
2761: ,p_transit_code in varchar2 default hr_api.g_varchar2
2762: ,p_bank_name in varchar2 default hr_api.g_varchar2
2763: ,p_account_type in varchar2 default hr_api.g_varchar2
2764: ,p_bank_branch in varchar2 default hr_api.g_varchar2
2765: ,p_amount in number default hr_api.g_number

Line 2762: ,p_bank_name in varchar2 default hr_api.g_varchar2

2758: ,p_object_version_number in out nocopy number
2759: ,p_account_name in varchar2 default hr_api.g_varchar2
2760: ,p_account_number in varchar2 default hr_api.g_varchar2
2761: ,p_transit_code in varchar2 default hr_api.g_varchar2
2762: ,p_bank_name in varchar2 default hr_api.g_varchar2
2763: ,p_account_type in varchar2 default hr_api.g_varchar2
2764: ,p_bank_branch in varchar2 default hr_api.g_varchar2
2765: ,p_amount in number default hr_api.g_number
2766: ,p_comments in varchar2 default hr_api.g_varchar2

Line 2763: ,p_account_type in varchar2 default hr_api.g_varchar2

2759: ,p_account_name in varchar2 default hr_api.g_varchar2
2760: ,p_account_number in varchar2 default hr_api.g_varchar2
2761: ,p_transit_code in varchar2 default hr_api.g_varchar2
2762: ,p_bank_name in varchar2 default hr_api.g_varchar2
2763: ,p_account_type in varchar2 default hr_api.g_varchar2
2764: ,p_bank_branch in varchar2 default hr_api.g_varchar2
2765: ,p_amount in number default hr_api.g_number
2766: ,p_comments in varchar2 default hr_api.g_varchar2
2767: ,p_percentage in number default hr_api.g_number

Line 2764: ,p_bank_branch in varchar2 default hr_api.g_varchar2

2760: ,p_account_number in varchar2 default hr_api.g_varchar2
2761: ,p_transit_code in varchar2 default hr_api.g_varchar2
2762: ,p_bank_name in varchar2 default hr_api.g_varchar2
2763: ,p_account_type in varchar2 default hr_api.g_varchar2
2764: ,p_bank_branch in varchar2 default hr_api.g_varchar2
2765: ,p_amount in number default hr_api.g_number
2766: ,p_comments in varchar2 default hr_api.g_varchar2
2767: ,p_percentage in number default hr_api.g_number
2768: ,p_priority in number default hr_api.g_number

Line 2765: ,p_amount in number default hr_api.g_number

2761: ,p_transit_code in varchar2 default hr_api.g_varchar2
2762: ,p_bank_name in varchar2 default hr_api.g_varchar2
2763: ,p_account_type in varchar2 default hr_api.g_varchar2
2764: ,p_bank_branch in varchar2 default hr_api.g_varchar2
2765: ,p_amount in number default hr_api.g_number
2766: ,p_comments in varchar2 default hr_api.g_varchar2
2767: ,p_percentage in number default hr_api.g_number
2768: ,p_priority in number default hr_api.g_number
2769: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 2766: ,p_comments in varchar2 default hr_api.g_varchar2

2762: ,p_bank_name in varchar2 default hr_api.g_varchar2
2763: ,p_account_type in varchar2 default hr_api.g_varchar2
2764: ,p_bank_branch in varchar2 default hr_api.g_varchar2
2765: ,p_amount in number default hr_api.g_number
2766: ,p_comments in varchar2 default hr_api.g_varchar2
2767: ,p_percentage in number default hr_api.g_number
2768: ,p_priority in number default hr_api.g_number
2769: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2770: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 2767: ,p_percentage in number default hr_api.g_number

2763: ,p_account_type in varchar2 default hr_api.g_varchar2
2764: ,p_bank_branch in varchar2 default hr_api.g_varchar2
2765: ,p_amount in number default hr_api.g_number
2766: ,p_comments in varchar2 default hr_api.g_varchar2
2767: ,p_percentage in number default hr_api.g_number
2768: ,p_priority in number default hr_api.g_number
2769: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2770: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2771: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 2768: ,p_priority in number default hr_api.g_number

2764: ,p_bank_branch in varchar2 default hr_api.g_varchar2
2765: ,p_amount in number default hr_api.g_number
2766: ,p_comments in varchar2 default hr_api.g_varchar2
2767: ,p_percentage in number default hr_api.g_number
2768: ,p_priority in number default hr_api.g_number
2769: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2770: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2771: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2772: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 2769: ,p_attribute_category in varchar2 default hr_api.g_varchar2

2765: ,p_amount in number default hr_api.g_number
2766: ,p_comments in varchar2 default hr_api.g_varchar2
2767: ,p_percentage in number default hr_api.g_number
2768: ,p_priority in number default hr_api.g_number
2769: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2770: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2771: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2772: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2773: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 2770: ,p_attribute1 in varchar2 default hr_api.g_varchar2

2766: ,p_comments in varchar2 default hr_api.g_varchar2
2767: ,p_percentage in number default hr_api.g_number
2768: ,p_priority in number default hr_api.g_number
2769: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2770: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2771: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2772: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2773: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2774: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 2771: ,p_attribute2 in varchar2 default hr_api.g_varchar2

2767: ,p_percentage in number default hr_api.g_number
2768: ,p_priority in number default hr_api.g_number
2769: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2770: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2771: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2772: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2773: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2774: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2775: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 2772: ,p_attribute3 in varchar2 default hr_api.g_varchar2

2768: ,p_priority in number default hr_api.g_number
2769: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2770: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2771: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2772: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2773: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2774: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2775: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2776: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 2773: ,p_attribute4 in varchar2 default hr_api.g_varchar2

2769: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2770: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2771: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2772: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2773: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2774: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2775: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2776: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2777: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 2774: ,p_attribute5 in varchar2 default hr_api.g_varchar2

2770: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2771: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2772: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2773: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2774: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2775: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2776: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2777: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2778: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 2775: ,p_attribute6 in varchar2 default hr_api.g_varchar2

2771: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2772: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2773: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2774: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2775: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2776: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2777: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2778: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2779: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 2776: ,p_attribute7 in varchar2 default hr_api.g_varchar2

2772: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2773: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2774: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2775: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2776: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2777: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2778: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2779: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2780: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 2777: ,p_attribute8 in varchar2 default hr_api.g_varchar2

2773: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2774: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2775: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2776: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2777: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2778: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2779: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2780: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2781: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 2778: ,p_attribute9 in varchar2 default hr_api.g_varchar2

2774: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2775: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2776: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2777: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2778: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2779: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2780: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2781: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2782: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 2779: ,p_attribute10 in varchar2 default hr_api.g_varchar2

2775: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2776: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2777: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2778: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2779: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2780: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2781: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2782: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2783: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 2780: ,p_attribute11 in varchar2 default hr_api.g_varchar2

2776: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2777: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2778: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2779: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2780: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2781: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2782: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2783: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2784: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 2781: ,p_attribute12 in varchar2 default hr_api.g_varchar2

2777: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2778: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2779: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2780: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2781: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2782: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2783: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2784: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2785: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 2782: ,p_attribute13 in varchar2 default hr_api.g_varchar2

2778: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2779: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2780: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2781: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2782: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2783: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2784: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2785: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2786: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 2783: ,p_attribute14 in varchar2 default hr_api.g_varchar2

2779: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2780: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2781: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2782: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2783: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2784: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2785: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2786: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2787: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 2784: ,p_attribute15 in varchar2 default hr_api.g_varchar2

2780: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2781: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2782: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2783: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2784: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2785: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2786: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2787: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2788: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 2785: ,p_attribute16 in varchar2 default hr_api.g_varchar2

2781: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2782: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2783: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2784: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2785: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2786: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2787: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2788: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2789: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 2786: ,p_attribute17 in varchar2 default hr_api.g_varchar2

2782: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2783: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2784: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2785: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2786: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2787: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2788: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2789: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2790: ,p_payee_type in varchar2 default hr_api.g_varchar2

Line 2787: ,p_attribute18 in varchar2 default hr_api.g_varchar2

2783: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2784: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2785: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2786: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2787: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2788: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2789: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2790: ,p_payee_type in varchar2 default hr_api.g_varchar2
2791: ,p_payee_id in number default hr_api.g_number

Line 2788: ,p_attribute19 in varchar2 default hr_api.g_varchar2

2784: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2785: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2786: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2787: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2788: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2789: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2790: ,p_payee_type in varchar2 default hr_api.g_varchar2
2791: ,p_payee_id in number default hr_api.g_number
2792: ,p_prenote_date in date default hr_api.g_date

Line 2789: ,p_attribute20 in varchar2 default hr_api.g_varchar2

2785: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2786: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2787: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2788: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2789: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2790: ,p_payee_type in varchar2 default hr_api.g_varchar2
2791: ,p_payee_id in number default hr_api.g_number
2792: ,p_prenote_date in date default hr_api.g_date
2793: ,p_territory_code in varchar2 default hr_api.g_varchar2

Line 2790: ,p_payee_type in varchar2 default hr_api.g_varchar2

2786: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2787: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2788: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2789: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2790: ,p_payee_type in varchar2 default hr_api.g_varchar2
2791: ,p_payee_id in number default hr_api.g_number
2792: ,p_prenote_date in date default hr_api.g_date
2793: ,p_territory_code in varchar2 default hr_api.g_varchar2
2794: ,p_comment_id out nocopy number

Line 2791: ,p_payee_id in number default hr_api.g_number

2787: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2788: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2789: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2790: ,p_payee_type in varchar2 default hr_api.g_varchar2
2791: ,p_payee_id in number default hr_api.g_number
2792: ,p_prenote_date in date default hr_api.g_date
2793: ,p_territory_code in varchar2 default hr_api.g_varchar2
2794: ,p_comment_id out nocopy number
2795: ,p_external_account_id out nocopy number

Line 2792: ,p_prenote_date in date default hr_api.g_date

2788: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2789: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2790: ,p_payee_type in varchar2 default hr_api.g_varchar2
2791: ,p_payee_id in number default hr_api.g_number
2792: ,p_prenote_date in date default hr_api.g_date
2793: ,p_territory_code in varchar2 default hr_api.g_varchar2
2794: ,p_comment_id out nocopy number
2795: ,p_external_account_id out nocopy number
2796: ,p_effective_start_date out nocopy date

Line 2793: ,p_territory_code in varchar2 default hr_api.g_varchar2

2789: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2790: ,p_payee_type in varchar2 default hr_api.g_varchar2
2791: ,p_payee_id in number default hr_api.g_number
2792: ,p_prenote_date in date default hr_api.g_date
2793: ,p_territory_code in varchar2 default hr_api.g_varchar2
2794: ,p_comment_id out nocopy number
2795: ,p_external_account_id out nocopy number
2796: ,p_effective_start_date out nocopy date
2797: ,p_effective_end_date out nocopy date

Line 2873: if nvl(p_prenote_date, hr_api.g_date+1) <> hr_api.g_date and p_external_account_id is not null then

2869: );
2870: --
2871: -- Update prenote date if external account is generated.
2872: --
2873: if nvl(p_prenote_date, hr_api.g_date+1) <> hr_api.g_date and p_external_account_id is not null then
2874: --
2875: upd_prenote_date
2876: (p_personal_payment_method_id => p_personal_payment_method_id
2877: ,p_external_account_id => p_external_account_id

Line 2898: ,p_account_name in varchar2 default hr_api.g_varchar2

2894: ,p_effective_date in date
2895: ,p_datetrack_update_mode in varchar2
2896: ,p_personal_payment_method_id in number
2897: ,p_object_version_number in out nocopy number
2898: ,p_account_name in varchar2 default hr_api.g_varchar2
2899: ,p_account_number in varchar2 default hr_api.g_varchar2
2900: ,p_transit_code in varchar2 default hr_api.g_varchar2
2901: ,p_bank_number in varchar2 default hr_api.g_varchar2
2902: ,p_bank_name in varchar2 default hr_api.g_varchar2

Line 2899: ,p_account_number in varchar2 default hr_api.g_varchar2

2895: ,p_datetrack_update_mode in varchar2
2896: ,p_personal_payment_method_id in number
2897: ,p_object_version_number in out nocopy number
2898: ,p_account_name in varchar2 default hr_api.g_varchar2
2899: ,p_account_number in varchar2 default hr_api.g_varchar2
2900: ,p_transit_code in varchar2 default hr_api.g_varchar2
2901: ,p_bank_number in varchar2 default hr_api.g_varchar2
2902: ,p_bank_name in varchar2 default hr_api.g_varchar2
2903: ,p_account_type in varchar2 default hr_api.g_varchar2

Line 2900: ,p_transit_code in varchar2 default hr_api.g_varchar2

2896: ,p_personal_payment_method_id in number
2897: ,p_object_version_number in out nocopy number
2898: ,p_account_name in varchar2 default hr_api.g_varchar2
2899: ,p_account_number in varchar2 default hr_api.g_varchar2
2900: ,p_transit_code in varchar2 default hr_api.g_varchar2
2901: ,p_bank_number in varchar2 default hr_api.g_varchar2
2902: ,p_bank_name in varchar2 default hr_api.g_varchar2
2903: ,p_account_type in varchar2 default hr_api.g_varchar2
2904: ,p_bank_branch in varchar2 default hr_api.g_varchar2

Line 2901: ,p_bank_number in varchar2 default hr_api.g_varchar2

2897: ,p_object_version_number in out nocopy number
2898: ,p_account_name in varchar2 default hr_api.g_varchar2
2899: ,p_account_number in varchar2 default hr_api.g_varchar2
2900: ,p_transit_code in varchar2 default hr_api.g_varchar2
2901: ,p_bank_number in varchar2 default hr_api.g_varchar2
2902: ,p_bank_name in varchar2 default hr_api.g_varchar2
2903: ,p_account_type in varchar2 default hr_api.g_varchar2
2904: ,p_bank_branch in varchar2 default hr_api.g_varchar2
2905: ,p_amount in number default hr_api.g_number

Line 2902: ,p_bank_name in varchar2 default hr_api.g_varchar2

2898: ,p_account_name in varchar2 default hr_api.g_varchar2
2899: ,p_account_number in varchar2 default hr_api.g_varchar2
2900: ,p_transit_code in varchar2 default hr_api.g_varchar2
2901: ,p_bank_number in varchar2 default hr_api.g_varchar2
2902: ,p_bank_name in varchar2 default hr_api.g_varchar2
2903: ,p_account_type in varchar2 default hr_api.g_varchar2
2904: ,p_bank_branch in varchar2 default hr_api.g_varchar2
2905: ,p_amount in number default hr_api.g_number
2906: ,p_comments in varchar2 default hr_api.g_varchar2

Line 2903: ,p_account_type in varchar2 default hr_api.g_varchar2

2899: ,p_account_number in varchar2 default hr_api.g_varchar2
2900: ,p_transit_code in varchar2 default hr_api.g_varchar2
2901: ,p_bank_number in varchar2 default hr_api.g_varchar2
2902: ,p_bank_name in varchar2 default hr_api.g_varchar2
2903: ,p_account_type in varchar2 default hr_api.g_varchar2
2904: ,p_bank_branch in varchar2 default hr_api.g_varchar2
2905: ,p_amount in number default hr_api.g_number
2906: ,p_comments in varchar2 default hr_api.g_varchar2
2907: ,p_percentage in number default hr_api.g_number

Line 2904: ,p_bank_branch in varchar2 default hr_api.g_varchar2

2900: ,p_transit_code in varchar2 default hr_api.g_varchar2
2901: ,p_bank_number in varchar2 default hr_api.g_varchar2
2902: ,p_bank_name in varchar2 default hr_api.g_varchar2
2903: ,p_account_type in varchar2 default hr_api.g_varchar2
2904: ,p_bank_branch in varchar2 default hr_api.g_varchar2
2905: ,p_amount in number default hr_api.g_number
2906: ,p_comments in varchar2 default hr_api.g_varchar2
2907: ,p_percentage in number default hr_api.g_number
2908: ,p_priority in number default hr_api.g_number

Line 2905: ,p_amount in number default hr_api.g_number

2901: ,p_bank_number in varchar2 default hr_api.g_varchar2
2902: ,p_bank_name in varchar2 default hr_api.g_varchar2
2903: ,p_account_type in varchar2 default hr_api.g_varchar2
2904: ,p_bank_branch in varchar2 default hr_api.g_varchar2
2905: ,p_amount in number default hr_api.g_number
2906: ,p_comments in varchar2 default hr_api.g_varchar2
2907: ,p_percentage in number default hr_api.g_number
2908: ,p_priority in number default hr_api.g_number
2909: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 2906: ,p_comments in varchar2 default hr_api.g_varchar2

2902: ,p_bank_name in varchar2 default hr_api.g_varchar2
2903: ,p_account_type in varchar2 default hr_api.g_varchar2
2904: ,p_bank_branch in varchar2 default hr_api.g_varchar2
2905: ,p_amount in number default hr_api.g_number
2906: ,p_comments in varchar2 default hr_api.g_varchar2
2907: ,p_percentage in number default hr_api.g_number
2908: ,p_priority in number default hr_api.g_number
2909: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2910: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 2907: ,p_percentage in number default hr_api.g_number

2903: ,p_account_type in varchar2 default hr_api.g_varchar2
2904: ,p_bank_branch in varchar2 default hr_api.g_varchar2
2905: ,p_amount in number default hr_api.g_number
2906: ,p_comments in varchar2 default hr_api.g_varchar2
2907: ,p_percentage in number default hr_api.g_number
2908: ,p_priority in number default hr_api.g_number
2909: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2910: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2911: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 2908: ,p_priority in number default hr_api.g_number

2904: ,p_bank_branch in varchar2 default hr_api.g_varchar2
2905: ,p_amount in number default hr_api.g_number
2906: ,p_comments in varchar2 default hr_api.g_varchar2
2907: ,p_percentage in number default hr_api.g_number
2908: ,p_priority in number default hr_api.g_number
2909: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2910: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2911: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2912: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 2909: ,p_attribute_category in varchar2 default hr_api.g_varchar2

2905: ,p_amount in number default hr_api.g_number
2906: ,p_comments in varchar2 default hr_api.g_varchar2
2907: ,p_percentage in number default hr_api.g_number
2908: ,p_priority in number default hr_api.g_number
2909: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2910: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2911: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2912: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2913: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 2910: ,p_attribute1 in varchar2 default hr_api.g_varchar2

2906: ,p_comments in varchar2 default hr_api.g_varchar2
2907: ,p_percentage in number default hr_api.g_number
2908: ,p_priority in number default hr_api.g_number
2909: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2910: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2911: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2912: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2913: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2914: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 2911: ,p_attribute2 in varchar2 default hr_api.g_varchar2

2907: ,p_percentage in number default hr_api.g_number
2908: ,p_priority in number default hr_api.g_number
2909: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2910: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2911: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2912: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2913: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2914: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2915: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 2912: ,p_attribute3 in varchar2 default hr_api.g_varchar2

2908: ,p_priority in number default hr_api.g_number
2909: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2910: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2911: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2912: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2913: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2914: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2915: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2916: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 2913: ,p_attribute4 in varchar2 default hr_api.g_varchar2

2909: ,p_attribute_category in varchar2 default hr_api.g_varchar2
2910: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2911: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2912: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2913: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2914: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2915: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2916: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2917: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 2914: ,p_attribute5 in varchar2 default hr_api.g_varchar2

2910: ,p_attribute1 in varchar2 default hr_api.g_varchar2
2911: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2912: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2913: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2914: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2915: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2916: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2917: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2918: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 2915: ,p_attribute6 in varchar2 default hr_api.g_varchar2

2911: ,p_attribute2 in varchar2 default hr_api.g_varchar2
2912: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2913: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2914: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2915: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2916: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2917: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2918: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2919: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 2916: ,p_attribute7 in varchar2 default hr_api.g_varchar2

2912: ,p_attribute3 in varchar2 default hr_api.g_varchar2
2913: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2914: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2915: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2916: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2917: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2918: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2919: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2920: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 2917: ,p_attribute8 in varchar2 default hr_api.g_varchar2

2913: ,p_attribute4 in varchar2 default hr_api.g_varchar2
2914: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2915: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2916: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2917: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2918: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2919: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2920: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2921: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 2918: ,p_attribute9 in varchar2 default hr_api.g_varchar2

2914: ,p_attribute5 in varchar2 default hr_api.g_varchar2
2915: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2916: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2917: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2918: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2919: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2920: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2921: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2922: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 2919: ,p_attribute10 in varchar2 default hr_api.g_varchar2

2915: ,p_attribute6 in varchar2 default hr_api.g_varchar2
2916: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2917: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2918: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2919: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2920: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2921: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2922: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2923: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 2920: ,p_attribute11 in varchar2 default hr_api.g_varchar2

2916: ,p_attribute7 in varchar2 default hr_api.g_varchar2
2917: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2918: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2919: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2920: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2921: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2922: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2923: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2924: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 2921: ,p_attribute12 in varchar2 default hr_api.g_varchar2

2917: ,p_attribute8 in varchar2 default hr_api.g_varchar2
2918: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2919: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2920: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2921: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2922: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2923: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2924: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2925: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 2922: ,p_attribute13 in varchar2 default hr_api.g_varchar2

2918: ,p_attribute9 in varchar2 default hr_api.g_varchar2
2919: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2920: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2921: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2922: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2923: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2924: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2925: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2926: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 2923: ,p_attribute14 in varchar2 default hr_api.g_varchar2

2919: ,p_attribute10 in varchar2 default hr_api.g_varchar2
2920: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2921: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2922: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2923: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2924: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2925: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2926: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2927: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 2924: ,p_attribute15 in varchar2 default hr_api.g_varchar2

2920: ,p_attribute11 in varchar2 default hr_api.g_varchar2
2921: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2922: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2923: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2924: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2925: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2926: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2927: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2928: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 2925: ,p_attribute16 in varchar2 default hr_api.g_varchar2

2921: ,p_attribute12 in varchar2 default hr_api.g_varchar2
2922: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2923: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2924: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2925: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2926: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2927: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2928: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2929: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 2926: ,p_attribute17 in varchar2 default hr_api.g_varchar2

2922: ,p_attribute13 in varchar2 default hr_api.g_varchar2
2923: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2924: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2925: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2926: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2927: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2928: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2929: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2930: ,p_payee_type in varchar2 default hr_api.g_varchar2

Line 2927: ,p_attribute18 in varchar2 default hr_api.g_varchar2

2923: ,p_attribute14 in varchar2 default hr_api.g_varchar2
2924: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2925: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2926: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2927: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2928: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2929: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2930: ,p_payee_type in varchar2 default hr_api.g_varchar2
2931: ,p_payee_id in number default hr_api.g_number

Line 2928: ,p_attribute19 in varchar2 default hr_api.g_varchar2

2924: ,p_attribute15 in varchar2 default hr_api.g_varchar2
2925: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2926: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2927: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2928: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2929: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2930: ,p_payee_type in varchar2 default hr_api.g_varchar2
2931: ,p_payee_id in number default hr_api.g_number
2932: ,p_territory_code in varchar2 default hr_api.g_varchar2

Line 2929: ,p_attribute20 in varchar2 default hr_api.g_varchar2

2925: ,p_attribute16 in varchar2 default hr_api.g_varchar2
2926: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2927: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2928: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2929: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2930: ,p_payee_type in varchar2 default hr_api.g_varchar2
2931: ,p_payee_id in number default hr_api.g_number
2932: ,p_territory_code in varchar2 default hr_api.g_varchar2
2933: ,p_comment_id out nocopy number

Line 2930: ,p_payee_type in varchar2 default hr_api.g_varchar2

2926: ,p_attribute17 in varchar2 default hr_api.g_varchar2
2927: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2928: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2929: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2930: ,p_payee_type in varchar2 default hr_api.g_varchar2
2931: ,p_payee_id in number default hr_api.g_number
2932: ,p_territory_code in varchar2 default hr_api.g_varchar2
2933: ,p_comment_id out nocopy number
2934: ,p_external_account_id out nocopy number

Line 2931: ,p_payee_id in number default hr_api.g_number

2927: ,p_attribute18 in varchar2 default hr_api.g_varchar2
2928: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2929: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2930: ,p_payee_type in varchar2 default hr_api.g_varchar2
2931: ,p_payee_id in number default hr_api.g_number
2932: ,p_territory_code in varchar2 default hr_api.g_varchar2
2933: ,p_comment_id out nocopy number
2934: ,p_external_account_id out nocopy number
2935: ,p_effective_start_date out nocopy date

Line 2932: ,p_territory_code in varchar2 default hr_api.g_varchar2

2928: ,p_attribute19 in varchar2 default hr_api.g_varchar2
2929: ,p_attribute20 in varchar2 default hr_api.g_varchar2
2930: ,p_payee_type in varchar2 default hr_api.g_varchar2
2931: ,p_payee_id in number default hr_api.g_number
2932: ,p_territory_code in varchar2 default hr_api.g_varchar2
2933: ,p_comment_id out nocopy number
2934: ,p_external_account_id out nocopy number
2935: ,p_effective_start_date out nocopy date
2936: ,p_effective_end_date out nocopy date

Line 3069: raise hr_api.validate_enabled;

3065: --
3066: -- When in validation only mode raise the Validate_Enabled exception
3067: --
3068: if p_validate then
3069: raise hr_api.validate_enabled;
3070: end if;
3071: --
3072: if g_debug then
3073: hr_utility.set_location(' Leaving:'||l_proc, 8);

Line 3076: when hr_api.validate_enabled then

3072: if g_debug then
3073: hr_utility.set_location(' Leaving:'||l_proc, 8);
3074: end if;
3075: exception
3076: when hr_api.validate_enabled then
3077: --
3078: -- As the Validate_Enabled exception has been raised
3079: -- we must rollback to the savepoint
3080: --