156: ,p_pay_basis_id => l_pay_basis_id
157: ,p_object_version_number => l_object_version_number
158: );
159: exception
160: when hr_api.cannot_find_prog_unit then
161: hr_api.cannot_find_prog_unit_error
162: (p_module_name => 'CREATE_SALARY_BASIS'
163: ,p_hook_type => 'BP'
164: );
157: ,p_object_version_number => l_object_version_number
158: );
159: exception
160: when hr_api.cannot_find_prog_unit then
161: hr_api.cannot_find_prog_unit_error
162: (p_module_name => 'CREATE_SALARY_BASIS'
163: ,p_hook_type => 'BP'
164: );
165: --
295: ,p_pay_basis_id => l_pay_basis_id
296: ,p_object_version_number => l_object_version_number
297: );
298: exception
299: when hr_api.cannot_find_prog_unit then
300: hr_api.cannot_find_prog_unit_error
301: (p_module_name => 'CREATE_SALARY_BASIS'
302: ,p_hook_type => 'AP'
303: );
296: ,p_object_version_number => l_object_version_number
297: );
298: exception
299: when hr_api.cannot_find_prog_unit then
300: hr_api.cannot_find_prog_unit_error
301: (p_module_name => 'CREATE_SALARY_BASIS'
302: ,p_hook_type => 'AP'
303: );
304: --
309: -- When in validation only mode raise the Validate_Enabled exception
310: --
311: if p_validate
312: then
313: raise hr_api.validate_enabled;
314: end if;
315: --
316: hr_utility.set_location(' Leaving:'||l_proc, 50);
317: --
323: hr_utility.set_location(' Leaving:'||l_proc, 60);
324: --
325: exception
326: --
327: when hr_api.validate_enabled then
328: --
329: -- As the Validate_Enabled exception has been raised
330: -- we must rollback to the savepoint
331: --
360: --
361: procedure update_salary_basis
362: (P_VALIDATE IN BOOLEAN default false
363: ,P_PAY_BASIS_ID IN NUMBER
364: ,P_INPUT_VALUE_ID IN NUMBER default hr_api.g_number
365: ,P_RATE_ID IN NUMBER default hr_api.g_number
366: ,P_NAME IN VARCHAR2 default hr_api.g_varchar2
367: ,P_PAY_BASIS IN VARCHAR2 default hr_api.g_varchar2
368: ,P_RATE_BASIS IN VARCHAR2 default hr_api.g_varchar2
361: procedure update_salary_basis
362: (P_VALIDATE IN BOOLEAN default false
363: ,P_PAY_BASIS_ID IN NUMBER
364: ,P_INPUT_VALUE_ID IN NUMBER default hr_api.g_number
365: ,P_RATE_ID IN NUMBER default hr_api.g_number
366: ,P_NAME IN VARCHAR2 default hr_api.g_varchar2
367: ,P_PAY_BASIS IN VARCHAR2 default hr_api.g_varchar2
368: ,P_RATE_BASIS IN VARCHAR2 default hr_api.g_varchar2
369: ,P_PAY_ANNUALIZATION_FACTOR IN NUMBER default hr_api.g_number
362: (P_VALIDATE IN BOOLEAN default false
363: ,P_PAY_BASIS_ID IN NUMBER
364: ,P_INPUT_VALUE_ID IN NUMBER default hr_api.g_number
365: ,P_RATE_ID IN NUMBER default hr_api.g_number
366: ,P_NAME IN VARCHAR2 default hr_api.g_varchar2
367: ,P_PAY_BASIS IN VARCHAR2 default hr_api.g_varchar2
368: ,P_RATE_BASIS IN VARCHAR2 default hr_api.g_varchar2
369: ,P_PAY_ANNUALIZATION_FACTOR IN NUMBER default hr_api.g_number
370: ,P_GRADE_ANNUALIZATION_FACTOR IN NUMBER default hr_api.g_number
363: ,P_PAY_BASIS_ID IN NUMBER
364: ,P_INPUT_VALUE_ID IN NUMBER default hr_api.g_number
365: ,P_RATE_ID IN NUMBER default hr_api.g_number
366: ,P_NAME IN VARCHAR2 default hr_api.g_varchar2
367: ,P_PAY_BASIS IN VARCHAR2 default hr_api.g_varchar2
368: ,P_RATE_BASIS IN VARCHAR2 default hr_api.g_varchar2
369: ,P_PAY_ANNUALIZATION_FACTOR IN NUMBER default hr_api.g_number
370: ,P_GRADE_ANNUALIZATION_FACTOR IN NUMBER default hr_api.g_number
371: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
364: ,P_INPUT_VALUE_ID IN NUMBER default hr_api.g_number
365: ,P_RATE_ID IN NUMBER default hr_api.g_number
366: ,P_NAME IN VARCHAR2 default hr_api.g_varchar2
367: ,P_PAY_BASIS IN VARCHAR2 default hr_api.g_varchar2
368: ,P_RATE_BASIS IN VARCHAR2 default hr_api.g_varchar2
369: ,P_PAY_ANNUALIZATION_FACTOR IN NUMBER default hr_api.g_number
370: ,P_GRADE_ANNUALIZATION_FACTOR IN NUMBER default hr_api.g_number
371: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
372: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
365: ,P_RATE_ID IN NUMBER default hr_api.g_number
366: ,P_NAME IN VARCHAR2 default hr_api.g_varchar2
367: ,P_PAY_BASIS IN VARCHAR2 default hr_api.g_varchar2
368: ,P_RATE_BASIS IN VARCHAR2 default hr_api.g_varchar2
369: ,P_PAY_ANNUALIZATION_FACTOR IN NUMBER default hr_api.g_number
370: ,P_GRADE_ANNUALIZATION_FACTOR IN NUMBER default hr_api.g_number
371: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
372: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
373: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
366: ,P_NAME IN VARCHAR2 default hr_api.g_varchar2
367: ,P_PAY_BASIS IN VARCHAR2 default hr_api.g_varchar2
368: ,P_RATE_BASIS IN VARCHAR2 default hr_api.g_varchar2
369: ,P_PAY_ANNUALIZATION_FACTOR IN NUMBER default hr_api.g_number
370: ,P_GRADE_ANNUALIZATION_FACTOR IN NUMBER default hr_api.g_number
371: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
372: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
373: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
374: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
367: ,P_PAY_BASIS IN VARCHAR2 default hr_api.g_varchar2
368: ,P_RATE_BASIS IN VARCHAR2 default hr_api.g_varchar2
369: ,P_PAY_ANNUALIZATION_FACTOR IN NUMBER default hr_api.g_number
370: ,P_GRADE_ANNUALIZATION_FACTOR IN NUMBER default hr_api.g_number
371: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
372: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
373: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
374: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
375: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
368: ,P_RATE_BASIS IN VARCHAR2 default hr_api.g_varchar2
369: ,P_PAY_ANNUALIZATION_FACTOR IN NUMBER default hr_api.g_number
370: ,P_GRADE_ANNUALIZATION_FACTOR IN NUMBER default hr_api.g_number
371: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
372: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
373: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
374: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
375: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
376: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
369: ,P_PAY_ANNUALIZATION_FACTOR IN NUMBER default hr_api.g_number
370: ,P_GRADE_ANNUALIZATION_FACTOR IN NUMBER default hr_api.g_number
371: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
372: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
373: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
374: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
375: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
376: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
377: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
370: ,P_GRADE_ANNUALIZATION_FACTOR IN NUMBER default hr_api.g_number
371: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
372: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
373: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
374: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
375: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
376: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
377: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
378: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
371: ,P_ATTRIBUTE_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
372: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
373: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
374: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
375: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
376: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
377: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
378: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
379: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
372: ,P_ATTRIBUTE1 IN VARCHAR2 default hr_api.g_varchar2
373: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
374: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
375: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
376: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
377: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
378: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
379: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
380: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
373: ,P_ATTRIBUTE2 IN VARCHAR2 default hr_api.g_varchar2
374: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
375: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
376: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
377: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
378: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
379: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
380: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
381: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
374: ,P_ATTRIBUTE3 IN VARCHAR2 default hr_api.g_varchar2
375: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
376: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
377: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
378: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
379: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
380: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
381: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
382: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
375: ,P_ATTRIBUTE4 IN VARCHAR2 default hr_api.g_varchar2
376: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
377: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
378: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
379: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
380: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
381: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
382: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
383: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
376: ,P_ATTRIBUTE5 IN VARCHAR2 default hr_api.g_varchar2
377: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
378: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
379: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
380: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
381: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
382: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
383: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
384: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
377: ,P_ATTRIBUTE6 IN VARCHAR2 default hr_api.g_varchar2
378: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
379: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
380: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
381: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
382: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
383: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
384: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
385: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
378: ,P_ATTRIBUTE7 IN VARCHAR2 default hr_api.g_varchar2
379: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
380: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
381: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
382: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
383: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
384: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
385: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
386: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
379: ,P_ATTRIBUTE8 IN VARCHAR2 default hr_api.g_varchar2
380: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
381: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
382: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
383: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
384: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
385: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
386: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
387: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
380: ,P_ATTRIBUTE9 IN VARCHAR2 default hr_api.g_varchar2
381: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
382: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
383: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
384: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
385: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
386: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
387: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
388: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
381: ,P_ATTRIBUTE10 IN VARCHAR2 default hr_api.g_varchar2
382: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
383: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
384: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
385: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
386: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
387: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
388: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
389: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
382: ,P_ATTRIBUTE11 IN VARCHAR2 default hr_api.g_varchar2
383: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
384: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
385: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
386: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
387: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
388: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
389: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
390: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
383: ,P_ATTRIBUTE12 IN VARCHAR2 default hr_api.g_varchar2
384: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
385: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
386: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
387: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
388: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
389: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
390: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
391: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
384: ,P_ATTRIBUTE13 IN VARCHAR2 default hr_api.g_varchar2
385: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
386: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
387: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
388: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
389: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
390: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
391: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
392: ,P_INFORMATION_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
385: ,P_ATTRIBUTE14 IN VARCHAR2 default hr_api.g_varchar2
386: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
387: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
388: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
389: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
390: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
391: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
392: ,P_INFORMATION_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
393: ,P_INFORMATION1 IN VARCHAR2 default hr_api.g_varchar2
386: ,P_ATTRIBUTE15 IN VARCHAR2 default hr_api.g_varchar2
387: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
388: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
389: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
390: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
391: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
392: ,P_INFORMATION_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
393: ,P_INFORMATION1 IN VARCHAR2 default hr_api.g_varchar2
394: ,P_INFORMATION2 IN VARCHAR2 default hr_api.g_varchar2
387: ,P_ATTRIBUTE16 IN VARCHAR2 default hr_api.g_varchar2
388: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
389: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
390: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
391: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
392: ,P_INFORMATION_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
393: ,P_INFORMATION1 IN VARCHAR2 default hr_api.g_varchar2
394: ,P_INFORMATION2 IN VARCHAR2 default hr_api.g_varchar2
395: ,P_INFORMATION3 IN VARCHAR2 default hr_api.g_varchar2
388: ,P_ATTRIBUTE17 IN VARCHAR2 default hr_api.g_varchar2
389: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
390: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
391: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
392: ,P_INFORMATION_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
393: ,P_INFORMATION1 IN VARCHAR2 default hr_api.g_varchar2
394: ,P_INFORMATION2 IN VARCHAR2 default hr_api.g_varchar2
395: ,P_INFORMATION3 IN VARCHAR2 default hr_api.g_varchar2
396: ,P_INFORMATION4 IN VARCHAR2 default hr_api.g_varchar2
389: ,P_ATTRIBUTE18 IN VARCHAR2 default hr_api.g_varchar2
390: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
391: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
392: ,P_INFORMATION_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
393: ,P_INFORMATION1 IN VARCHAR2 default hr_api.g_varchar2
394: ,P_INFORMATION2 IN VARCHAR2 default hr_api.g_varchar2
395: ,P_INFORMATION3 IN VARCHAR2 default hr_api.g_varchar2
396: ,P_INFORMATION4 IN VARCHAR2 default hr_api.g_varchar2
397: ,P_INFORMATION5 IN VARCHAR2 default hr_api.g_varchar2
390: ,P_ATTRIBUTE19 IN VARCHAR2 default hr_api.g_varchar2
391: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
392: ,P_INFORMATION_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
393: ,P_INFORMATION1 IN VARCHAR2 default hr_api.g_varchar2
394: ,P_INFORMATION2 IN VARCHAR2 default hr_api.g_varchar2
395: ,P_INFORMATION3 IN VARCHAR2 default hr_api.g_varchar2
396: ,P_INFORMATION4 IN VARCHAR2 default hr_api.g_varchar2
397: ,P_INFORMATION5 IN VARCHAR2 default hr_api.g_varchar2
398: ,P_INFORMATION6 IN VARCHAR2 default hr_api.g_varchar2
391: ,P_ATTRIBUTE20 IN VARCHAR2 default hr_api.g_varchar2
392: ,P_INFORMATION_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
393: ,P_INFORMATION1 IN VARCHAR2 default hr_api.g_varchar2
394: ,P_INFORMATION2 IN VARCHAR2 default hr_api.g_varchar2
395: ,P_INFORMATION3 IN VARCHAR2 default hr_api.g_varchar2
396: ,P_INFORMATION4 IN VARCHAR2 default hr_api.g_varchar2
397: ,P_INFORMATION5 IN VARCHAR2 default hr_api.g_varchar2
398: ,P_INFORMATION6 IN VARCHAR2 default hr_api.g_varchar2
399: ,P_INFORMATION7 IN VARCHAR2 default hr_api.g_varchar2
392: ,P_INFORMATION_CATEGORY IN VARCHAR2 default hr_api.g_varchar2
393: ,P_INFORMATION1 IN VARCHAR2 default hr_api.g_varchar2
394: ,P_INFORMATION2 IN VARCHAR2 default hr_api.g_varchar2
395: ,P_INFORMATION3 IN VARCHAR2 default hr_api.g_varchar2
396: ,P_INFORMATION4 IN VARCHAR2 default hr_api.g_varchar2
397: ,P_INFORMATION5 IN VARCHAR2 default hr_api.g_varchar2
398: ,P_INFORMATION6 IN VARCHAR2 default hr_api.g_varchar2
399: ,P_INFORMATION7 IN VARCHAR2 default hr_api.g_varchar2
400: ,P_INFORMATION8 IN VARCHAR2 default hr_api.g_varchar2
393: ,P_INFORMATION1 IN VARCHAR2 default hr_api.g_varchar2
394: ,P_INFORMATION2 IN VARCHAR2 default hr_api.g_varchar2
395: ,P_INFORMATION3 IN VARCHAR2 default hr_api.g_varchar2
396: ,P_INFORMATION4 IN VARCHAR2 default hr_api.g_varchar2
397: ,P_INFORMATION5 IN VARCHAR2 default hr_api.g_varchar2
398: ,P_INFORMATION6 IN VARCHAR2 default hr_api.g_varchar2
399: ,P_INFORMATION7 IN VARCHAR2 default hr_api.g_varchar2
400: ,P_INFORMATION8 IN VARCHAR2 default hr_api.g_varchar2
401: ,P_INFORMATION9 IN VARCHAR2 default hr_api.g_varchar2
394: ,P_INFORMATION2 IN VARCHAR2 default hr_api.g_varchar2
395: ,P_INFORMATION3 IN VARCHAR2 default hr_api.g_varchar2
396: ,P_INFORMATION4 IN VARCHAR2 default hr_api.g_varchar2
397: ,P_INFORMATION5 IN VARCHAR2 default hr_api.g_varchar2
398: ,P_INFORMATION6 IN VARCHAR2 default hr_api.g_varchar2
399: ,P_INFORMATION7 IN VARCHAR2 default hr_api.g_varchar2
400: ,P_INFORMATION8 IN VARCHAR2 default hr_api.g_varchar2
401: ,P_INFORMATION9 IN VARCHAR2 default hr_api.g_varchar2
402: ,P_INFORMATION10 IN VARCHAR2 default hr_api.g_varchar2
395: ,P_INFORMATION3 IN VARCHAR2 default hr_api.g_varchar2
396: ,P_INFORMATION4 IN VARCHAR2 default hr_api.g_varchar2
397: ,P_INFORMATION5 IN VARCHAR2 default hr_api.g_varchar2
398: ,P_INFORMATION6 IN VARCHAR2 default hr_api.g_varchar2
399: ,P_INFORMATION7 IN VARCHAR2 default hr_api.g_varchar2
400: ,P_INFORMATION8 IN VARCHAR2 default hr_api.g_varchar2
401: ,P_INFORMATION9 IN VARCHAR2 default hr_api.g_varchar2
402: ,P_INFORMATION10 IN VARCHAR2 default hr_api.g_varchar2
403: ,P_INFORMATION11 IN VARCHAR2 default hr_api.g_varchar2
396: ,P_INFORMATION4 IN VARCHAR2 default hr_api.g_varchar2
397: ,P_INFORMATION5 IN VARCHAR2 default hr_api.g_varchar2
398: ,P_INFORMATION6 IN VARCHAR2 default hr_api.g_varchar2
399: ,P_INFORMATION7 IN VARCHAR2 default hr_api.g_varchar2
400: ,P_INFORMATION8 IN VARCHAR2 default hr_api.g_varchar2
401: ,P_INFORMATION9 IN VARCHAR2 default hr_api.g_varchar2
402: ,P_INFORMATION10 IN VARCHAR2 default hr_api.g_varchar2
403: ,P_INFORMATION11 IN VARCHAR2 default hr_api.g_varchar2
404: ,P_INFORMATION12 IN VARCHAR2 default hr_api.g_varchar2
397: ,P_INFORMATION5 IN VARCHAR2 default hr_api.g_varchar2
398: ,P_INFORMATION6 IN VARCHAR2 default hr_api.g_varchar2
399: ,P_INFORMATION7 IN VARCHAR2 default hr_api.g_varchar2
400: ,P_INFORMATION8 IN VARCHAR2 default hr_api.g_varchar2
401: ,P_INFORMATION9 IN VARCHAR2 default hr_api.g_varchar2
402: ,P_INFORMATION10 IN VARCHAR2 default hr_api.g_varchar2
403: ,P_INFORMATION11 IN VARCHAR2 default hr_api.g_varchar2
404: ,P_INFORMATION12 IN VARCHAR2 default hr_api.g_varchar2
405: ,P_INFORMATION13 IN VARCHAR2 default hr_api.g_varchar2
398: ,P_INFORMATION6 IN VARCHAR2 default hr_api.g_varchar2
399: ,P_INFORMATION7 IN VARCHAR2 default hr_api.g_varchar2
400: ,P_INFORMATION8 IN VARCHAR2 default hr_api.g_varchar2
401: ,P_INFORMATION9 IN VARCHAR2 default hr_api.g_varchar2
402: ,P_INFORMATION10 IN VARCHAR2 default hr_api.g_varchar2
403: ,P_INFORMATION11 IN VARCHAR2 default hr_api.g_varchar2
404: ,P_INFORMATION12 IN VARCHAR2 default hr_api.g_varchar2
405: ,P_INFORMATION13 IN VARCHAR2 default hr_api.g_varchar2
406: ,P_INFORMATION14 IN VARCHAR2 default hr_api.g_varchar2
399: ,P_INFORMATION7 IN VARCHAR2 default hr_api.g_varchar2
400: ,P_INFORMATION8 IN VARCHAR2 default hr_api.g_varchar2
401: ,P_INFORMATION9 IN VARCHAR2 default hr_api.g_varchar2
402: ,P_INFORMATION10 IN VARCHAR2 default hr_api.g_varchar2
403: ,P_INFORMATION11 IN VARCHAR2 default hr_api.g_varchar2
404: ,P_INFORMATION12 IN VARCHAR2 default hr_api.g_varchar2
405: ,P_INFORMATION13 IN VARCHAR2 default hr_api.g_varchar2
406: ,P_INFORMATION14 IN VARCHAR2 default hr_api.g_varchar2
407: ,P_INFORMATION15 IN VARCHAR2 default hr_api.g_varchar2
400: ,P_INFORMATION8 IN VARCHAR2 default hr_api.g_varchar2
401: ,P_INFORMATION9 IN VARCHAR2 default hr_api.g_varchar2
402: ,P_INFORMATION10 IN VARCHAR2 default hr_api.g_varchar2
403: ,P_INFORMATION11 IN VARCHAR2 default hr_api.g_varchar2
404: ,P_INFORMATION12 IN VARCHAR2 default hr_api.g_varchar2
405: ,P_INFORMATION13 IN VARCHAR2 default hr_api.g_varchar2
406: ,P_INFORMATION14 IN VARCHAR2 default hr_api.g_varchar2
407: ,P_INFORMATION15 IN VARCHAR2 default hr_api.g_varchar2
408: ,P_INFORMATION16 IN VARCHAR2 default hr_api.g_varchar2
401: ,P_INFORMATION9 IN VARCHAR2 default hr_api.g_varchar2
402: ,P_INFORMATION10 IN VARCHAR2 default hr_api.g_varchar2
403: ,P_INFORMATION11 IN VARCHAR2 default hr_api.g_varchar2
404: ,P_INFORMATION12 IN VARCHAR2 default hr_api.g_varchar2
405: ,P_INFORMATION13 IN VARCHAR2 default hr_api.g_varchar2
406: ,P_INFORMATION14 IN VARCHAR2 default hr_api.g_varchar2
407: ,P_INFORMATION15 IN VARCHAR2 default hr_api.g_varchar2
408: ,P_INFORMATION16 IN VARCHAR2 default hr_api.g_varchar2
409: ,P_INFORMATION17 IN VARCHAR2 default hr_api.g_varchar2
402: ,P_INFORMATION10 IN VARCHAR2 default hr_api.g_varchar2
403: ,P_INFORMATION11 IN VARCHAR2 default hr_api.g_varchar2
404: ,P_INFORMATION12 IN VARCHAR2 default hr_api.g_varchar2
405: ,P_INFORMATION13 IN VARCHAR2 default hr_api.g_varchar2
406: ,P_INFORMATION14 IN VARCHAR2 default hr_api.g_varchar2
407: ,P_INFORMATION15 IN VARCHAR2 default hr_api.g_varchar2
408: ,P_INFORMATION16 IN VARCHAR2 default hr_api.g_varchar2
409: ,P_INFORMATION17 IN VARCHAR2 default hr_api.g_varchar2
410: ,P_INFORMATION18 IN VARCHAR2 default hr_api.g_varchar2
403: ,P_INFORMATION11 IN VARCHAR2 default hr_api.g_varchar2
404: ,P_INFORMATION12 IN VARCHAR2 default hr_api.g_varchar2
405: ,P_INFORMATION13 IN VARCHAR2 default hr_api.g_varchar2
406: ,P_INFORMATION14 IN VARCHAR2 default hr_api.g_varchar2
407: ,P_INFORMATION15 IN VARCHAR2 default hr_api.g_varchar2
408: ,P_INFORMATION16 IN VARCHAR2 default hr_api.g_varchar2
409: ,P_INFORMATION17 IN VARCHAR2 default hr_api.g_varchar2
410: ,P_INFORMATION18 IN VARCHAR2 default hr_api.g_varchar2
411: ,P_INFORMATION19 IN VARCHAR2 default hr_api.g_varchar2
404: ,P_INFORMATION12 IN VARCHAR2 default hr_api.g_varchar2
405: ,P_INFORMATION13 IN VARCHAR2 default hr_api.g_varchar2
406: ,P_INFORMATION14 IN VARCHAR2 default hr_api.g_varchar2
407: ,P_INFORMATION15 IN VARCHAR2 default hr_api.g_varchar2
408: ,P_INFORMATION16 IN VARCHAR2 default hr_api.g_varchar2
409: ,P_INFORMATION17 IN VARCHAR2 default hr_api.g_varchar2
410: ,P_INFORMATION18 IN VARCHAR2 default hr_api.g_varchar2
411: ,P_INFORMATION19 IN VARCHAR2 default hr_api.g_varchar2
412: ,P_INFORMATION20 IN VARCHAR2 default hr_api.g_varchar2
405: ,P_INFORMATION13 IN VARCHAR2 default hr_api.g_varchar2
406: ,P_INFORMATION14 IN VARCHAR2 default hr_api.g_varchar2
407: ,P_INFORMATION15 IN VARCHAR2 default hr_api.g_varchar2
408: ,P_INFORMATION16 IN VARCHAR2 default hr_api.g_varchar2
409: ,P_INFORMATION17 IN VARCHAR2 default hr_api.g_varchar2
410: ,P_INFORMATION18 IN VARCHAR2 default hr_api.g_varchar2
411: ,P_INFORMATION19 IN VARCHAR2 default hr_api.g_varchar2
412: ,P_INFORMATION20 IN VARCHAR2 default hr_api.g_varchar2
413: ,P_LAST_UPDATE_DATE IN DATE default hr_api.g_date
406: ,P_INFORMATION14 IN VARCHAR2 default hr_api.g_varchar2
407: ,P_INFORMATION15 IN VARCHAR2 default hr_api.g_varchar2
408: ,P_INFORMATION16 IN VARCHAR2 default hr_api.g_varchar2
409: ,P_INFORMATION17 IN VARCHAR2 default hr_api.g_varchar2
410: ,P_INFORMATION18 IN VARCHAR2 default hr_api.g_varchar2
411: ,P_INFORMATION19 IN VARCHAR2 default hr_api.g_varchar2
412: ,P_INFORMATION20 IN VARCHAR2 default hr_api.g_varchar2
413: ,P_LAST_UPDATE_DATE IN DATE default hr_api.g_date
414: ,P_LAST_UPDATED_BY IN NUMBER default hr_api.g_number
407: ,P_INFORMATION15 IN VARCHAR2 default hr_api.g_varchar2
408: ,P_INFORMATION16 IN VARCHAR2 default hr_api.g_varchar2
409: ,P_INFORMATION17 IN VARCHAR2 default hr_api.g_varchar2
410: ,P_INFORMATION18 IN VARCHAR2 default hr_api.g_varchar2
411: ,P_INFORMATION19 IN VARCHAR2 default hr_api.g_varchar2
412: ,P_INFORMATION20 IN VARCHAR2 default hr_api.g_varchar2
413: ,P_LAST_UPDATE_DATE IN DATE default hr_api.g_date
414: ,P_LAST_UPDATED_BY IN NUMBER default hr_api.g_number
415: ,P_LAST_UPDATE_LOGIN IN NUMBER default hr_api.g_number
408: ,P_INFORMATION16 IN VARCHAR2 default hr_api.g_varchar2
409: ,P_INFORMATION17 IN VARCHAR2 default hr_api.g_varchar2
410: ,P_INFORMATION18 IN VARCHAR2 default hr_api.g_varchar2
411: ,P_INFORMATION19 IN VARCHAR2 default hr_api.g_varchar2
412: ,P_INFORMATION20 IN VARCHAR2 default hr_api.g_varchar2
413: ,P_LAST_UPDATE_DATE IN DATE default hr_api.g_date
414: ,P_LAST_UPDATED_BY IN NUMBER default hr_api.g_number
415: ,P_LAST_UPDATE_LOGIN IN NUMBER default hr_api.g_number
416: ,P_CREATED_BY IN NUMBER default hr_api.g_number
409: ,P_INFORMATION17 IN VARCHAR2 default hr_api.g_varchar2
410: ,P_INFORMATION18 IN VARCHAR2 default hr_api.g_varchar2
411: ,P_INFORMATION19 IN VARCHAR2 default hr_api.g_varchar2
412: ,P_INFORMATION20 IN VARCHAR2 default hr_api.g_varchar2
413: ,P_LAST_UPDATE_DATE IN DATE default hr_api.g_date
414: ,P_LAST_UPDATED_BY IN NUMBER default hr_api.g_number
415: ,P_LAST_UPDATE_LOGIN IN NUMBER default hr_api.g_number
416: ,P_CREATED_BY IN NUMBER default hr_api.g_number
417: ,P_CREATION_DATE IN DATE default hr_api.g_date
410: ,P_INFORMATION18 IN VARCHAR2 default hr_api.g_varchar2
411: ,P_INFORMATION19 IN VARCHAR2 default hr_api.g_varchar2
412: ,P_INFORMATION20 IN VARCHAR2 default hr_api.g_varchar2
413: ,P_LAST_UPDATE_DATE IN DATE default hr_api.g_date
414: ,P_LAST_UPDATED_BY IN NUMBER default hr_api.g_number
415: ,P_LAST_UPDATE_LOGIN IN NUMBER default hr_api.g_number
416: ,P_CREATED_BY IN NUMBER default hr_api.g_number
417: ,P_CREATION_DATE IN DATE default hr_api.g_date
418: ,P_OBJECT_VERSION_NUMBER IN OUT nocopy NUMBER
411: ,P_INFORMATION19 IN VARCHAR2 default hr_api.g_varchar2
412: ,P_INFORMATION20 IN VARCHAR2 default hr_api.g_varchar2
413: ,P_LAST_UPDATE_DATE IN DATE default hr_api.g_date
414: ,P_LAST_UPDATED_BY IN NUMBER default hr_api.g_number
415: ,P_LAST_UPDATE_LOGIN IN NUMBER default hr_api.g_number
416: ,P_CREATED_BY IN NUMBER default hr_api.g_number
417: ,P_CREATION_DATE IN DATE default hr_api.g_date
418: ,P_OBJECT_VERSION_NUMBER IN OUT nocopy NUMBER
419: ) is
412: ,P_INFORMATION20 IN VARCHAR2 default hr_api.g_varchar2
413: ,P_LAST_UPDATE_DATE IN DATE default hr_api.g_date
414: ,P_LAST_UPDATED_BY IN NUMBER default hr_api.g_number
415: ,P_LAST_UPDATE_LOGIN IN NUMBER default hr_api.g_number
416: ,P_CREATED_BY IN NUMBER default hr_api.g_number
417: ,P_CREATION_DATE IN DATE default hr_api.g_date
418: ,P_OBJECT_VERSION_NUMBER IN OUT nocopy NUMBER
419: ) is
420: --
413: ,P_LAST_UPDATE_DATE IN DATE default hr_api.g_date
414: ,P_LAST_UPDATED_BY IN NUMBER default hr_api.g_number
415: ,P_LAST_UPDATE_LOGIN IN NUMBER default hr_api.g_number
416: ,P_CREATED_BY IN NUMBER default hr_api.g_number
417: ,P_CREATION_DATE IN DATE default hr_api.g_date
418: ,P_OBJECT_VERSION_NUMBER IN OUT nocopy NUMBER
419: ) is
420: --
421: -- Declare cursors and local variables
533: ,p_object_version_number => l_object_version_number
534: );
535: --
536: exception
537: when hr_api.cannot_find_prog_unit
538: then
539: hr_api.cannot_find_prog_unit_error
540: (p_module_name => 'UPDATE_SALARY_BASIS'
541: ,p_hook_type => 'BP'
535: --
536: exception
537: when hr_api.cannot_find_prog_unit
538: then
539: hr_api.cannot_find_prog_unit_error
540: (p_module_name => 'UPDATE_SALARY_BASIS'
541: ,p_hook_type => 'BP'
542: );
543: end; -- End of API User Hook for the before hook of salary_basis
671: ,p_object_version_number => l_object_version_number
672: );
673: --
674: exception
675: when hr_api.cannot_find_prog_unit then
676: hr_api.cannot_find_prog_unit_error
677: (p_module_name => 'UPDATE_SALARY_BASIS'
678: ,p_hook_type => 'AP'
679: );
672: );
673: --
674: exception
675: when hr_api.cannot_find_prog_unit then
676: hr_api.cannot_find_prog_unit_error
677: (p_module_name => 'UPDATE_SALARY_BASIS'
678: ,p_hook_type => 'AP'
679: );
680: end; -- End of API User Hook for the after hook of update_salary_basis
684: -- When in validation only mode raise the Validate_Enabled exception
685: --
686: if p_validate
687: then
688: raise hr_api.validate_enabled;
689: end if;
690: --
691: p_object_version_number := l_object_version_number;
692:
692:
693: --
694: hr_utility.set_location(' Leaving:'||l_proc, 100);
695: exception
696: when hr_api.validate_enabled then
697: --
698: -- As the Validate_Enabled exception has been raised
699: -- we must rollback to the savepoint
700: --
744: ,p_pay_basis_id => p_pay_basis_id
745: ,p_object_version_number => p_object_version_number
746: );
747: exception
748: when hr_api.cannot_find_prog_unit then
749: hr_api.cannot_find_prog_unit_error
750: (p_module_name => 'DELETE_SALARY_BASIS'
751: ,p_hook_type => 'BP'
752: );
745: ,p_object_version_number => p_object_version_number
746: );
747: exception
748: when hr_api.cannot_find_prog_unit then
749: hr_api.cannot_find_prog_unit_error
750: (p_module_name => 'DELETE_SALARY_BASIS'
751: ,p_hook_type => 'BP'
752: );
753: end;
766: (p_validate => p_validate
767: ,p_pay_basis_id => p_pay_basis_id
768: ,p_object_version_number => l_object_version_number);
769: exception
770: when hr_api.cannot_find_prog_unit then
771: hr_api.cannot_find_prog_unit_error
772: (p_module_name => 'DELETE_SALARY_BASIS'
773: ,p_hook_type => 'AP'
774: );
767: ,p_pay_basis_id => p_pay_basis_id
768: ,p_object_version_number => l_object_version_number);
769: exception
770: when hr_api.cannot_find_prog_unit then
771: hr_api.cannot_find_prog_unit_error
772: (p_module_name => 'DELETE_SALARY_BASIS'
773: ,p_hook_type => 'AP'
774: );
775: end;
776: --
777: -- When in validation only mode raise the Validate_Enabled exception
778: --
779: if p_validate then
780: raise hr_api.validate_enabled;
781: end if;
782: --
783: -- Set all output arguments
784: --
786: p_object_version_number := l_object_version_number;
787:
788: hr_utility.set_location(' Leaving:'||l_proc, 70);
789: exception
790: when hr_api.validate_enabled then
791: --
792: -- As the Validate_Enabled exception has been raised
793: -- we must rollback to the savepoint
794: --