DBA Data[Home] [Help]

APPS.HR_OPT_BUS dependencies on HR_KI_OPTIONS

Line 171: (p_associated_column1 => 'HR_KI_OPTIONS.OPTION_TYPE_ID'

167: hr_utility.set_location(' Leaving:'||l_proc,30);
168: exception
169: when app_exception.application_exception then
170: if hr_multi_message.exception_add
171: (p_associated_column1 => 'HR_KI_OPTIONS.OPTION_TYPE_ID'
172: )then
173: hr_utility.set_location(' Leaving:'||l_proc, 40);
174: raise;
175: end if;

Line 234: (p_associated_column1 => 'HR_KI_OPTIONS.OPTION_LEVEL'

230:
231: exception
232: when app_exception.application_exception then
233: if hr_multi_message.exception_add
234: (p_associated_column1 => 'HR_KI_OPTIONS.OPTION_LEVEL'
235: )then
236: hr_utility.set_location(' Leaving:'||l_proc, 30);
237: raise;
238: end if;

Line 320: (p_check_column1 => 'HR_KI_OPTIONS.OPTION_LEVEL'

316: -- Multiple Message List does not already contain an errors
317: -- associated with the OPTION_LEVEL column.
318: --
319: if hr_multi_message.no_exclusive_error
320: (p_check_column1 => 'HR_KI_OPTIONS.OPTION_LEVEL'
321: ,p_associated_column1 => 'HR_KI_OPTIONS.OPTION_LEVEL'
322: ) then
323:
324:

Line 321: ,p_associated_column1 => 'HR_KI_OPTIONS.OPTION_LEVEL'

317: -- associated with the OPTION_LEVEL column.
318: --
319: if hr_multi_message.no_exclusive_error
320: (p_check_column1 => 'HR_KI_OPTIONS.OPTION_LEVEL'
321: ,p_associated_column1 => 'HR_KI_OPTIONS.OPTION_LEVEL'
322: ) then
323:
324:
325: --check if level is NOT SITE

Line 493: (p_associated_column1 => 'HR_KI_OPTIONS.ENCRYPTED'

489:
490: exception
491: when app_exception.application_exception then
492: if hr_multi_message.exception_add
493: (p_associated_column1 => 'HR_KI_OPTIONS.ENCRYPTED'
494: )then
495: hr_utility.set_location(' Leaving:'||l_proc, 30);
496: raise;
497: end if;

Line 567: (p_associated_column1 => 'HR_KI_OPTIONS.INTEGRATION_ID'

563: hr_utility.set_location(' Leaving:'||l_proc,40);
564: exception
565: when app_exception.application_exception then
566: if hr_multi_message.exception_add
567: (p_associated_column1 => 'HR_KI_OPTIONS.INTEGRATION_ID'
568: )then
569: hr_utility.set_location(' Leaving:'||l_proc, 50);
570: raise;
571: end if;

Line 615: from hr_ki_options

611: l_found varchar2(1);
612:
613: cursor csr_int_options is
614: select null
615: from hr_ki_options
616: where (option_type_id = p_option_type_id
617: and integration_id = p_integration_id
618: and option_level=p_option_level)
619: and (option_level_id=p_option_level_id

Line 631: (p_check_column1 => 'HR_KI_OPTIONS.OPTION_TYPE_ID'

627: -- associated with the OPTION_TYPE_ID,INTEGRATION_ID,OPTION_LEVEL
628: -- OPTION_LEVEL_ID columns.
629: --
630: if hr_multi_message.no_exclusive_error
631: (p_check_column1 => 'HR_KI_OPTIONS.OPTION_TYPE_ID'
632: ,p_associated_column1 => 'HR_KI_OPTIONS.OPTION_TYPE_ID'
633: ,p_check_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'
634: ,p_associated_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'
635: ,p_check_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'

Line 632: ,p_associated_column1 => 'HR_KI_OPTIONS.OPTION_TYPE_ID'

628: -- OPTION_LEVEL_ID columns.
629: --
630: if hr_multi_message.no_exclusive_error
631: (p_check_column1 => 'HR_KI_OPTIONS.OPTION_TYPE_ID'
632: ,p_associated_column1 => 'HR_KI_OPTIONS.OPTION_TYPE_ID'
633: ,p_check_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'
634: ,p_associated_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'
635: ,p_check_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'
636: ,p_associated_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'

Line 633: ,p_check_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'

629: --
630: if hr_multi_message.no_exclusive_error
631: (p_check_column1 => 'HR_KI_OPTIONS.OPTION_TYPE_ID'
632: ,p_associated_column1 => 'HR_KI_OPTIONS.OPTION_TYPE_ID'
633: ,p_check_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'
634: ,p_associated_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'
635: ,p_check_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'
636: ,p_associated_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'
637: ,p_check_column4 => 'HR_KI_OPTIONS.OPTION_LEVEL_ID'

Line 634: ,p_associated_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'

630: if hr_multi_message.no_exclusive_error
631: (p_check_column1 => 'HR_KI_OPTIONS.OPTION_TYPE_ID'
632: ,p_associated_column1 => 'HR_KI_OPTIONS.OPTION_TYPE_ID'
633: ,p_check_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'
634: ,p_associated_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'
635: ,p_check_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'
636: ,p_associated_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'
637: ,p_check_column4 => 'HR_KI_OPTIONS.OPTION_LEVEL_ID'
638: ,p_associated_column4 => 'HR_KI_OPTIONS.OPTION_LEVEL_ID'

Line 635: ,p_check_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'

631: (p_check_column1 => 'HR_KI_OPTIONS.OPTION_TYPE_ID'
632: ,p_associated_column1 => 'HR_KI_OPTIONS.OPTION_TYPE_ID'
633: ,p_check_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'
634: ,p_associated_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'
635: ,p_check_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'
636: ,p_associated_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'
637: ,p_check_column4 => 'HR_KI_OPTIONS.OPTION_LEVEL_ID'
638: ,p_associated_column4 => 'HR_KI_OPTIONS.OPTION_LEVEL_ID'
639: ) then

Line 636: ,p_associated_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'

632: ,p_associated_column1 => 'HR_KI_OPTIONS.OPTION_TYPE_ID'
633: ,p_check_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'
634: ,p_associated_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'
635: ,p_check_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'
636: ,p_associated_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'
637: ,p_check_column4 => 'HR_KI_OPTIONS.OPTION_LEVEL_ID'
638: ,p_associated_column4 => 'HR_KI_OPTIONS.OPTION_LEVEL_ID'
639: ) then
640:

Line 637: ,p_check_column4 => 'HR_KI_OPTIONS.OPTION_LEVEL_ID'

633: ,p_check_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'
634: ,p_associated_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'
635: ,p_check_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'
636: ,p_associated_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'
637: ,p_check_column4 => 'HR_KI_OPTIONS.OPTION_LEVEL_ID'
638: ,p_associated_column4 => 'HR_KI_OPTIONS.OPTION_LEVEL_ID'
639: ) then
640:
641: open csr_int_options;

Line 638: ,p_associated_column4 => 'HR_KI_OPTIONS.OPTION_LEVEL_ID'

634: ,p_associated_column2 => 'HR_KI_OPTIONS.INTEGRATION_ID'
635: ,p_check_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'
636: ,p_associated_column3 => 'HR_KI_OPTIONS.OPTION_LEVEL'
637: ,p_check_column4 => 'HR_KI_OPTIONS.OPTION_LEVEL_ID'
638: ,p_associated_column4 => 'HR_KI_OPTIONS.OPTION_LEVEL_ID'
639: ) then
640:
641: open csr_int_options;
642: fetch csr_int_options into l_found;