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_KI_INTEGRATIONS_API dependencies on HR_API

Line 14: ,p_language_code in varchar2 default hr_api.userenv_lang

10: -- ----------------------------------------------------------------------------
11: --
12: procedure create_integration
13: (p_validate in boolean default false
14: ,p_language_code in varchar2 default hr_api.userenv_lang
15: ,p_integration_key in varchar2
16: ,p_party_type in varchar2 default null
17: ,p_party_name in varchar2 default null
18: ,p_party_site_name in varchar2 default null

Line 77: hr_api.validate_language_code(p_language_code => l_language_code);

73: --
74: --l_in_out_parameter := p_in_out_parameter;
75: l_language_code := p_language_code;
76:
77: hr_api.validate_language_code(p_language_code => l_language_code);
78:
79: --
80: -- Call Before Process User Hook
81: --

Line 127: when hr_api.cannot_find_prog_unit then

123: ,p_field_name9 => p_field_name9
124: ,p_field_value9 => p_field_value9
125: );
126: exception
127: when hr_api.cannot_find_prog_unit then
128: hr_api.cannot_find_prog_unit_error
129: (p_module_name => 'create_integration'
130: ,p_hook_type => 'BP'
131: );

Line 128: hr_api.cannot_find_prog_unit_error

124: ,p_field_value9 => p_field_value9
125: );
126: exception
127: when hr_api.cannot_find_prog_unit then
128: hr_api.cannot_find_prog_unit_error
129: (p_module_name => 'create_integration'
130: ,p_hook_type => 'BP'
131: );
132: end;

Line 241: when hr_api.cannot_find_prog_unit then

237: ,p_ext_application_id => p_ext_application_id
238: ,p_object_version_number => l_object_version_number
239: );
240: exception
241: when hr_api.cannot_find_prog_unit then
242: hr_api.cannot_find_prog_unit_error
243: (p_module_name => 'create_integration'
244: ,p_hook_type => 'AP'
245: );

Line 242: hr_api.cannot_find_prog_unit_error

238: ,p_object_version_number => l_object_version_number
239: );
240: exception
241: when hr_api.cannot_find_prog_unit then
242: hr_api.cannot_find_prog_unit_error
243: (p_module_name => 'create_integration'
244: ,p_hook_type => 'AP'
245: );
246: end;

Line 251: raise hr_api.validate_enabled;

247: --
248: -- When in validation only mode raise the Validate_Enabled exception
249: --
250: if p_validate then
251: raise hr_api.validate_enabled;
252: end if;
253: --
254: -- Set all IN OUT and OUT parameters with out values
255: --

Line 262: when hr_api.validate_enabled then

258:
259: --
260: hr_utility.set_location(' Leaving:'||l_proc, 70);
261: exception
262: when hr_api.validate_enabled then
263: --
264: -- As the Validate_Enabled exception has been raised
265: -- we must rollback to the savepoint
266: --

Line 442: when hr_api.cannot_find_prog_unit then

438: p_integration_id => p_integration_id
439: ,p_object_version_number => p_object_version_number
440: );
441: exception
442: when hr_api.cannot_find_prog_unit then
443: hr_api.cannot_find_prog_unit_error
444: (p_module_name => 'validate_integration'
445: ,p_hook_type => 'BP'
446: );

Line 443: hr_api.cannot_find_prog_unit_error

439: ,p_object_version_number => p_object_version_number
440: );
441: exception
442: when hr_api.cannot_find_prog_unit then
443: hr_api.cannot_find_prog_unit_error
444: (p_module_name => 'validate_integration'
445: ,p_hook_type => 'BP'
446: );
447: end;

Line 649: when hr_api.cannot_find_prog_unit then

645: ,p_ext_application_id => l_ext_application_id
646: ,p_object_version_number => p_object_version_number
647: );
648: exception
649: when hr_api.cannot_find_prog_unit then
650: hr_api.cannot_find_prog_unit_error
651: (p_module_name => 'validate_integration'
652: ,p_hook_type => 'AP'
653: );

Line 650: hr_api.cannot_find_prog_unit_error

646: ,p_object_version_number => p_object_version_number
647: );
648: exception
649: when hr_api.cannot_find_prog_unit then
650: hr_api.cannot_find_prog_unit_error
651: (p_module_name => 'validate_integration'
652: ,p_hook_type => 'AP'
653: );
654: end;

Line 659: raise hr_api.validate_enabled;

655: --
656: -- When in validation only mode raise the Validate_Enabled exception
657: --
658: if p_validate then
659: raise hr_api.validate_enabled;
660: end if;
661: --
662: -- Set all IN OUT and OUT parameters with out values
663: --

Line 668: when hr_api.validate_enabled then

664: -- p_object_version_number := l_object_version_number;
665: --
666: hr_utility.set_location(' Leaving:'||l_proc, 90);
667: exception
668: when hr_api.validate_enabled then
669: --
670: -- As the Validate_Enabled exception has been raised
671: -- we must rollback to the savepoint
672: --

Line 706: ,p_language_code in varchar2 default hr_api.userenv_lang

702: -- ----------------------------------------------------------------------------
703:
704: procedure UPDATE_INTEGRATION
705: (p_validate in boolean default false
706: ,p_language_code in varchar2 default hr_api.userenv_lang
707: ,p_integration_id in number
708: ,p_source_type in varchar2
709: ,p_target_type in varchar2
710: ,p_party_type in varchar2 default hr_api.g_varchar2

Line 710: ,p_party_type in varchar2 default hr_api.g_varchar2

706: ,p_language_code in varchar2 default hr_api.userenv_lang
707: ,p_integration_id in number
708: ,p_source_type in varchar2
709: ,p_target_type in varchar2
710: ,p_party_type in varchar2 default hr_api.g_varchar2
711: ,p_party_name in varchar2 default hr_api.g_varchar2
712: ,p_party_site_name in varchar2 default hr_api.g_varchar2
713: ,p_transaction_type in varchar2 default hr_api.g_varchar2
714: ,p_transaction_subtype in varchar2 default hr_api.g_varchar2

Line 711: ,p_party_name in varchar2 default hr_api.g_varchar2

707: ,p_integration_id in number
708: ,p_source_type in varchar2
709: ,p_target_type in varchar2
710: ,p_party_type in varchar2 default hr_api.g_varchar2
711: ,p_party_name in varchar2 default hr_api.g_varchar2
712: ,p_party_site_name in varchar2 default hr_api.g_varchar2
713: ,p_transaction_type in varchar2 default hr_api.g_varchar2
714: ,p_transaction_subtype in varchar2 default hr_api.g_varchar2
715: ,p_standard_code in varchar2 default hr_api.g_varchar2

Line 712: ,p_party_site_name in varchar2 default hr_api.g_varchar2

708: ,p_source_type in varchar2
709: ,p_target_type in varchar2
710: ,p_party_type in varchar2 default hr_api.g_varchar2
711: ,p_party_name in varchar2 default hr_api.g_varchar2
712: ,p_party_site_name in varchar2 default hr_api.g_varchar2
713: ,p_transaction_type in varchar2 default hr_api.g_varchar2
714: ,p_transaction_subtype in varchar2 default hr_api.g_varchar2
715: ,p_standard_code in varchar2 default hr_api.g_varchar2
716: ,p_ext_trans_type in varchar2 default hr_api.g_varchar2

Line 713: ,p_transaction_type in varchar2 default hr_api.g_varchar2

709: ,p_target_type in varchar2
710: ,p_party_type in varchar2 default hr_api.g_varchar2
711: ,p_party_name in varchar2 default hr_api.g_varchar2
712: ,p_party_site_name in varchar2 default hr_api.g_varchar2
713: ,p_transaction_type in varchar2 default hr_api.g_varchar2
714: ,p_transaction_subtype in varchar2 default hr_api.g_varchar2
715: ,p_standard_code in varchar2 default hr_api.g_varchar2
716: ,p_ext_trans_type in varchar2 default hr_api.g_varchar2
717: ,p_ext_trans_subtype in varchar2 default hr_api.g_varchar2

Line 714: ,p_transaction_subtype in varchar2 default hr_api.g_varchar2

710: ,p_party_type in varchar2 default hr_api.g_varchar2
711: ,p_party_name in varchar2 default hr_api.g_varchar2
712: ,p_party_site_name in varchar2 default hr_api.g_varchar2
713: ,p_transaction_type in varchar2 default hr_api.g_varchar2
714: ,p_transaction_subtype in varchar2 default hr_api.g_varchar2
715: ,p_standard_code in varchar2 default hr_api.g_varchar2
716: ,p_ext_trans_type in varchar2 default hr_api.g_varchar2
717: ,p_ext_trans_subtype in varchar2 default hr_api.g_varchar2
718: ,p_trans_direction in varchar2 default hr_api.g_varchar2

Line 715: ,p_standard_code in varchar2 default hr_api.g_varchar2

711: ,p_party_name in varchar2 default hr_api.g_varchar2
712: ,p_party_site_name in varchar2 default hr_api.g_varchar2
713: ,p_transaction_type in varchar2 default hr_api.g_varchar2
714: ,p_transaction_subtype in varchar2 default hr_api.g_varchar2
715: ,p_standard_code in varchar2 default hr_api.g_varchar2
716: ,p_ext_trans_type in varchar2 default hr_api.g_varchar2
717: ,p_ext_trans_subtype in varchar2 default hr_api.g_varchar2
718: ,p_trans_direction in varchar2 default hr_api.g_varchar2
719: ,p_url in varchar2 default hr_api.g_varchar2

Line 716: ,p_ext_trans_type in varchar2 default hr_api.g_varchar2

712: ,p_party_site_name in varchar2 default hr_api.g_varchar2
713: ,p_transaction_type in varchar2 default hr_api.g_varchar2
714: ,p_transaction_subtype in varchar2 default hr_api.g_varchar2
715: ,p_standard_code in varchar2 default hr_api.g_varchar2
716: ,p_ext_trans_type in varchar2 default hr_api.g_varchar2
717: ,p_ext_trans_subtype in varchar2 default hr_api.g_varchar2
718: ,p_trans_direction in varchar2 default hr_api.g_varchar2
719: ,p_url in varchar2 default hr_api.g_varchar2
720: ,p_partner_name in varchar2 default hr_api.g_varchar2

Line 717: ,p_ext_trans_subtype in varchar2 default hr_api.g_varchar2

713: ,p_transaction_type in varchar2 default hr_api.g_varchar2
714: ,p_transaction_subtype in varchar2 default hr_api.g_varchar2
715: ,p_standard_code in varchar2 default hr_api.g_varchar2
716: ,p_ext_trans_type in varchar2 default hr_api.g_varchar2
717: ,p_ext_trans_subtype in varchar2 default hr_api.g_varchar2
718: ,p_trans_direction in varchar2 default hr_api.g_varchar2
719: ,p_url in varchar2 default hr_api.g_varchar2
720: ,p_partner_name in varchar2 default hr_api.g_varchar2
721: ,p_service_name in varchar2 default hr_api.g_varchar2

Line 718: ,p_trans_direction in varchar2 default hr_api.g_varchar2

714: ,p_transaction_subtype in varchar2 default hr_api.g_varchar2
715: ,p_standard_code in varchar2 default hr_api.g_varchar2
716: ,p_ext_trans_type in varchar2 default hr_api.g_varchar2
717: ,p_ext_trans_subtype in varchar2 default hr_api.g_varchar2
718: ,p_trans_direction in varchar2 default hr_api.g_varchar2
719: ,p_url in varchar2 default hr_api.g_varchar2
720: ,p_partner_name in varchar2 default hr_api.g_varchar2
721: ,p_service_name in varchar2 default hr_api.g_varchar2
722: ,p_application_name in varchar2 default hr_api.g_varchar2

Line 719: ,p_url in varchar2 default hr_api.g_varchar2

715: ,p_standard_code in varchar2 default hr_api.g_varchar2
716: ,p_ext_trans_type in varchar2 default hr_api.g_varchar2
717: ,p_ext_trans_subtype in varchar2 default hr_api.g_varchar2
718: ,p_trans_direction in varchar2 default hr_api.g_varchar2
719: ,p_url in varchar2 default hr_api.g_varchar2
720: ,p_partner_name in varchar2 default hr_api.g_varchar2
721: ,p_service_name in varchar2 default hr_api.g_varchar2
722: ,p_application_name in varchar2 default hr_api.g_varchar2
723: ,p_application_type in varchar2 default hr_api.g_varchar2

Line 720: ,p_partner_name in varchar2 default hr_api.g_varchar2

716: ,p_ext_trans_type in varchar2 default hr_api.g_varchar2
717: ,p_ext_trans_subtype in varchar2 default hr_api.g_varchar2
718: ,p_trans_direction in varchar2 default hr_api.g_varchar2
719: ,p_url in varchar2 default hr_api.g_varchar2
720: ,p_partner_name in varchar2 default hr_api.g_varchar2
721: ,p_service_name in varchar2 default hr_api.g_varchar2
722: ,p_application_name in varchar2 default hr_api.g_varchar2
723: ,p_application_type in varchar2 default hr_api.g_varchar2
724: ,p_application_url in varchar2 default hr_api.g_varchar2

Line 721: ,p_service_name in varchar2 default hr_api.g_varchar2

717: ,p_ext_trans_subtype in varchar2 default hr_api.g_varchar2
718: ,p_trans_direction in varchar2 default hr_api.g_varchar2
719: ,p_url in varchar2 default hr_api.g_varchar2
720: ,p_partner_name in varchar2 default hr_api.g_varchar2
721: ,p_service_name in varchar2 default hr_api.g_varchar2
722: ,p_application_name in varchar2 default hr_api.g_varchar2
723: ,p_application_type in varchar2 default hr_api.g_varchar2
724: ,p_application_url in varchar2 default hr_api.g_varchar2
725: ,p_logout_url in varchar2 default hr_api.g_varchar2

Line 722: ,p_application_name in varchar2 default hr_api.g_varchar2

718: ,p_trans_direction in varchar2 default hr_api.g_varchar2
719: ,p_url in varchar2 default hr_api.g_varchar2
720: ,p_partner_name in varchar2 default hr_api.g_varchar2
721: ,p_service_name in varchar2 default hr_api.g_varchar2
722: ,p_application_name in varchar2 default hr_api.g_varchar2
723: ,p_application_type in varchar2 default hr_api.g_varchar2
724: ,p_application_url in varchar2 default hr_api.g_varchar2
725: ,p_logout_url in varchar2 default hr_api.g_varchar2
726: ,p_user_field in varchar2 default hr_api.g_varchar2

Line 723: ,p_application_type in varchar2 default hr_api.g_varchar2

719: ,p_url in varchar2 default hr_api.g_varchar2
720: ,p_partner_name in varchar2 default hr_api.g_varchar2
721: ,p_service_name in varchar2 default hr_api.g_varchar2
722: ,p_application_name in varchar2 default hr_api.g_varchar2
723: ,p_application_type in varchar2 default hr_api.g_varchar2
724: ,p_application_url in varchar2 default hr_api.g_varchar2
725: ,p_logout_url in varchar2 default hr_api.g_varchar2
726: ,p_user_field in varchar2 default hr_api.g_varchar2
727: ,p_password_field in varchar2 default hr_api.g_varchar2

Line 724: ,p_application_url in varchar2 default hr_api.g_varchar2

720: ,p_partner_name in varchar2 default hr_api.g_varchar2
721: ,p_service_name in varchar2 default hr_api.g_varchar2
722: ,p_application_name in varchar2 default hr_api.g_varchar2
723: ,p_application_type in varchar2 default hr_api.g_varchar2
724: ,p_application_url in varchar2 default hr_api.g_varchar2
725: ,p_logout_url in varchar2 default hr_api.g_varchar2
726: ,p_user_field in varchar2 default hr_api.g_varchar2
727: ,p_password_field in varchar2 default hr_api.g_varchar2
728: ,p_authentication_needed in varchar2 default hr_api.g_varchar2

Line 725: ,p_logout_url in varchar2 default hr_api.g_varchar2

721: ,p_service_name in varchar2 default hr_api.g_varchar2
722: ,p_application_name in varchar2 default hr_api.g_varchar2
723: ,p_application_type in varchar2 default hr_api.g_varchar2
724: ,p_application_url in varchar2 default hr_api.g_varchar2
725: ,p_logout_url in varchar2 default hr_api.g_varchar2
726: ,p_user_field in varchar2 default hr_api.g_varchar2
727: ,p_password_field in varchar2 default hr_api.g_varchar2
728: ,p_authentication_needed in varchar2 default hr_api.g_varchar2
729: ,p_field_name1 in varchar2 default hr_api.g_varchar2

Line 726: ,p_user_field in varchar2 default hr_api.g_varchar2

722: ,p_application_name in varchar2 default hr_api.g_varchar2
723: ,p_application_type in varchar2 default hr_api.g_varchar2
724: ,p_application_url in varchar2 default hr_api.g_varchar2
725: ,p_logout_url in varchar2 default hr_api.g_varchar2
726: ,p_user_field in varchar2 default hr_api.g_varchar2
727: ,p_password_field in varchar2 default hr_api.g_varchar2
728: ,p_authentication_needed in varchar2 default hr_api.g_varchar2
729: ,p_field_name1 in varchar2 default hr_api.g_varchar2
730: ,p_field_value1 in varchar2 default hr_api.g_varchar2

Line 727: ,p_password_field in varchar2 default hr_api.g_varchar2

723: ,p_application_type in varchar2 default hr_api.g_varchar2
724: ,p_application_url in varchar2 default hr_api.g_varchar2
725: ,p_logout_url in varchar2 default hr_api.g_varchar2
726: ,p_user_field in varchar2 default hr_api.g_varchar2
727: ,p_password_field in varchar2 default hr_api.g_varchar2
728: ,p_authentication_needed in varchar2 default hr_api.g_varchar2
729: ,p_field_name1 in varchar2 default hr_api.g_varchar2
730: ,p_field_value1 in varchar2 default hr_api.g_varchar2
731: ,p_field_name2 in varchar2 default hr_api.g_varchar2

Line 728: ,p_authentication_needed in varchar2 default hr_api.g_varchar2

724: ,p_application_url in varchar2 default hr_api.g_varchar2
725: ,p_logout_url in varchar2 default hr_api.g_varchar2
726: ,p_user_field in varchar2 default hr_api.g_varchar2
727: ,p_password_field in varchar2 default hr_api.g_varchar2
728: ,p_authentication_needed in varchar2 default hr_api.g_varchar2
729: ,p_field_name1 in varchar2 default hr_api.g_varchar2
730: ,p_field_value1 in varchar2 default hr_api.g_varchar2
731: ,p_field_name2 in varchar2 default hr_api.g_varchar2
732: ,p_field_value2 in varchar2 default hr_api.g_varchar2

Line 729: ,p_field_name1 in varchar2 default hr_api.g_varchar2

725: ,p_logout_url in varchar2 default hr_api.g_varchar2
726: ,p_user_field in varchar2 default hr_api.g_varchar2
727: ,p_password_field in varchar2 default hr_api.g_varchar2
728: ,p_authentication_needed in varchar2 default hr_api.g_varchar2
729: ,p_field_name1 in varchar2 default hr_api.g_varchar2
730: ,p_field_value1 in varchar2 default hr_api.g_varchar2
731: ,p_field_name2 in varchar2 default hr_api.g_varchar2
732: ,p_field_value2 in varchar2 default hr_api.g_varchar2
733: ,p_field_name3 in varchar2 default hr_api.g_varchar2

Line 730: ,p_field_value1 in varchar2 default hr_api.g_varchar2

726: ,p_user_field in varchar2 default hr_api.g_varchar2
727: ,p_password_field in varchar2 default hr_api.g_varchar2
728: ,p_authentication_needed in varchar2 default hr_api.g_varchar2
729: ,p_field_name1 in varchar2 default hr_api.g_varchar2
730: ,p_field_value1 in varchar2 default hr_api.g_varchar2
731: ,p_field_name2 in varchar2 default hr_api.g_varchar2
732: ,p_field_value2 in varchar2 default hr_api.g_varchar2
733: ,p_field_name3 in varchar2 default hr_api.g_varchar2
734: ,p_field_value3 in varchar2 default hr_api.g_varchar2

Line 731: ,p_field_name2 in varchar2 default hr_api.g_varchar2

727: ,p_password_field in varchar2 default hr_api.g_varchar2
728: ,p_authentication_needed in varchar2 default hr_api.g_varchar2
729: ,p_field_name1 in varchar2 default hr_api.g_varchar2
730: ,p_field_value1 in varchar2 default hr_api.g_varchar2
731: ,p_field_name2 in varchar2 default hr_api.g_varchar2
732: ,p_field_value2 in varchar2 default hr_api.g_varchar2
733: ,p_field_name3 in varchar2 default hr_api.g_varchar2
734: ,p_field_value3 in varchar2 default hr_api.g_varchar2
735: ,p_field_name4 in varchar2 default hr_api.g_varchar2

Line 732: ,p_field_value2 in varchar2 default hr_api.g_varchar2

728: ,p_authentication_needed in varchar2 default hr_api.g_varchar2
729: ,p_field_name1 in varchar2 default hr_api.g_varchar2
730: ,p_field_value1 in varchar2 default hr_api.g_varchar2
731: ,p_field_name2 in varchar2 default hr_api.g_varchar2
732: ,p_field_value2 in varchar2 default hr_api.g_varchar2
733: ,p_field_name3 in varchar2 default hr_api.g_varchar2
734: ,p_field_value3 in varchar2 default hr_api.g_varchar2
735: ,p_field_name4 in varchar2 default hr_api.g_varchar2
736: ,p_field_value4 in varchar2 default hr_api.g_varchar2

Line 733: ,p_field_name3 in varchar2 default hr_api.g_varchar2

729: ,p_field_name1 in varchar2 default hr_api.g_varchar2
730: ,p_field_value1 in varchar2 default hr_api.g_varchar2
731: ,p_field_name2 in varchar2 default hr_api.g_varchar2
732: ,p_field_value2 in varchar2 default hr_api.g_varchar2
733: ,p_field_name3 in varchar2 default hr_api.g_varchar2
734: ,p_field_value3 in varchar2 default hr_api.g_varchar2
735: ,p_field_name4 in varchar2 default hr_api.g_varchar2
736: ,p_field_value4 in varchar2 default hr_api.g_varchar2
737: ,p_field_name5 in varchar2 default hr_api.g_varchar2

Line 734: ,p_field_value3 in varchar2 default hr_api.g_varchar2

730: ,p_field_value1 in varchar2 default hr_api.g_varchar2
731: ,p_field_name2 in varchar2 default hr_api.g_varchar2
732: ,p_field_value2 in varchar2 default hr_api.g_varchar2
733: ,p_field_name3 in varchar2 default hr_api.g_varchar2
734: ,p_field_value3 in varchar2 default hr_api.g_varchar2
735: ,p_field_name4 in varchar2 default hr_api.g_varchar2
736: ,p_field_value4 in varchar2 default hr_api.g_varchar2
737: ,p_field_name5 in varchar2 default hr_api.g_varchar2
738: ,p_field_value5 in varchar2 default hr_api.g_varchar2

Line 735: ,p_field_name4 in varchar2 default hr_api.g_varchar2

731: ,p_field_name2 in varchar2 default hr_api.g_varchar2
732: ,p_field_value2 in varchar2 default hr_api.g_varchar2
733: ,p_field_name3 in varchar2 default hr_api.g_varchar2
734: ,p_field_value3 in varchar2 default hr_api.g_varchar2
735: ,p_field_name4 in varchar2 default hr_api.g_varchar2
736: ,p_field_value4 in varchar2 default hr_api.g_varchar2
737: ,p_field_name5 in varchar2 default hr_api.g_varchar2
738: ,p_field_value5 in varchar2 default hr_api.g_varchar2
739: ,p_field_name6 in varchar2 default hr_api.g_varchar2

Line 736: ,p_field_value4 in varchar2 default hr_api.g_varchar2

732: ,p_field_value2 in varchar2 default hr_api.g_varchar2
733: ,p_field_name3 in varchar2 default hr_api.g_varchar2
734: ,p_field_value3 in varchar2 default hr_api.g_varchar2
735: ,p_field_name4 in varchar2 default hr_api.g_varchar2
736: ,p_field_value4 in varchar2 default hr_api.g_varchar2
737: ,p_field_name5 in varchar2 default hr_api.g_varchar2
738: ,p_field_value5 in varchar2 default hr_api.g_varchar2
739: ,p_field_name6 in varchar2 default hr_api.g_varchar2
740: ,p_field_value6 in varchar2 default hr_api.g_varchar2

Line 737: ,p_field_name5 in varchar2 default hr_api.g_varchar2

733: ,p_field_name3 in varchar2 default hr_api.g_varchar2
734: ,p_field_value3 in varchar2 default hr_api.g_varchar2
735: ,p_field_name4 in varchar2 default hr_api.g_varchar2
736: ,p_field_value4 in varchar2 default hr_api.g_varchar2
737: ,p_field_name5 in varchar2 default hr_api.g_varchar2
738: ,p_field_value5 in varchar2 default hr_api.g_varchar2
739: ,p_field_name6 in varchar2 default hr_api.g_varchar2
740: ,p_field_value6 in varchar2 default hr_api.g_varchar2
741: ,p_field_name7 in varchar2 default hr_api.g_varchar2

Line 738: ,p_field_value5 in varchar2 default hr_api.g_varchar2

734: ,p_field_value3 in varchar2 default hr_api.g_varchar2
735: ,p_field_name4 in varchar2 default hr_api.g_varchar2
736: ,p_field_value4 in varchar2 default hr_api.g_varchar2
737: ,p_field_name5 in varchar2 default hr_api.g_varchar2
738: ,p_field_value5 in varchar2 default hr_api.g_varchar2
739: ,p_field_name6 in varchar2 default hr_api.g_varchar2
740: ,p_field_value6 in varchar2 default hr_api.g_varchar2
741: ,p_field_name7 in varchar2 default hr_api.g_varchar2
742: ,p_field_value7 in varchar2 default hr_api.g_varchar2

Line 739: ,p_field_name6 in varchar2 default hr_api.g_varchar2

735: ,p_field_name4 in varchar2 default hr_api.g_varchar2
736: ,p_field_value4 in varchar2 default hr_api.g_varchar2
737: ,p_field_name5 in varchar2 default hr_api.g_varchar2
738: ,p_field_value5 in varchar2 default hr_api.g_varchar2
739: ,p_field_name6 in varchar2 default hr_api.g_varchar2
740: ,p_field_value6 in varchar2 default hr_api.g_varchar2
741: ,p_field_name7 in varchar2 default hr_api.g_varchar2
742: ,p_field_value7 in varchar2 default hr_api.g_varchar2
743: ,p_field_name8 in varchar2 default hr_api.g_varchar2

Line 740: ,p_field_value6 in varchar2 default hr_api.g_varchar2

736: ,p_field_value4 in varchar2 default hr_api.g_varchar2
737: ,p_field_name5 in varchar2 default hr_api.g_varchar2
738: ,p_field_value5 in varchar2 default hr_api.g_varchar2
739: ,p_field_name6 in varchar2 default hr_api.g_varchar2
740: ,p_field_value6 in varchar2 default hr_api.g_varchar2
741: ,p_field_name7 in varchar2 default hr_api.g_varchar2
742: ,p_field_value7 in varchar2 default hr_api.g_varchar2
743: ,p_field_name8 in varchar2 default hr_api.g_varchar2
744: ,p_field_value8 in varchar2 default hr_api.g_varchar2

Line 741: ,p_field_name7 in varchar2 default hr_api.g_varchar2

737: ,p_field_name5 in varchar2 default hr_api.g_varchar2
738: ,p_field_value5 in varchar2 default hr_api.g_varchar2
739: ,p_field_name6 in varchar2 default hr_api.g_varchar2
740: ,p_field_value6 in varchar2 default hr_api.g_varchar2
741: ,p_field_name7 in varchar2 default hr_api.g_varchar2
742: ,p_field_value7 in varchar2 default hr_api.g_varchar2
743: ,p_field_name8 in varchar2 default hr_api.g_varchar2
744: ,p_field_value8 in varchar2 default hr_api.g_varchar2
745: ,p_field_name9 in varchar2 default hr_api.g_varchar2

Line 742: ,p_field_value7 in varchar2 default hr_api.g_varchar2

738: ,p_field_value5 in varchar2 default hr_api.g_varchar2
739: ,p_field_name6 in varchar2 default hr_api.g_varchar2
740: ,p_field_value6 in varchar2 default hr_api.g_varchar2
741: ,p_field_name7 in varchar2 default hr_api.g_varchar2
742: ,p_field_value7 in varchar2 default hr_api.g_varchar2
743: ,p_field_name8 in varchar2 default hr_api.g_varchar2
744: ,p_field_value8 in varchar2 default hr_api.g_varchar2
745: ,p_field_name9 in varchar2 default hr_api.g_varchar2
746: ,p_field_value9 in varchar2 default hr_api.g_varchar2

Line 743: ,p_field_name8 in varchar2 default hr_api.g_varchar2

739: ,p_field_name6 in varchar2 default hr_api.g_varchar2
740: ,p_field_value6 in varchar2 default hr_api.g_varchar2
741: ,p_field_name7 in varchar2 default hr_api.g_varchar2
742: ,p_field_value7 in varchar2 default hr_api.g_varchar2
743: ,p_field_name8 in varchar2 default hr_api.g_varchar2
744: ,p_field_value8 in varchar2 default hr_api.g_varchar2
745: ,p_field_name9 in varchar2 default hr_api.g_varchar2
746: ,p_field_value9 in varchar2 default hr_api.g_varchar2
747: ,p_object_version_number in out nocopy number

Line 744: ,p_field_value8 in varchar2 default hr_api.g_varchar2

740: ,p_field_value6 in varchar2 default hr_api.g_varchar2
741: ,p_field_name7 in varchar2 default hr_api.g_varchar2
742: ,p_field_value7 in varchar2 default hr_api.g_varchar2
743: ,p_field_name8 in varchar2 default hr_api.g_varchar2
744: ,p_field_value8 in varchar2 default hr_api.g_varchar2
745: ,p_field_name9 in varchar2 default hr_api.g_varchar2
746: ,p_field_value9 in varchar2 default hr_api.g_varchar2
747: ,p_object_version_number in out nocopy number
748:

Line 745: ,p_field_name9 in varchar2 default hr_api.g_varchar2

741: ,p_field_name7 in varchar2 default hr_api.g_varchar2
742: ,p_field_value7 in varchar2 default hr_api.g_varchar2
743: ,p_field_name8 in varchar2 default hr_api.g_varchar2
744: ,p_field_value8 in varchar2 default hr_api.g_varchar2
745: ,p_field_name9 in varchar2 default hr_api.g_varchar2
746: ,p_field_value9 in varchar2 default hr_api.g_varchar2
747: ,p_object_version_number in out nocopy number
748:
749: ) is

Line 746: ,p_field_value9 in varchar2 default hr_api.g_varchar2

742: ,p_field_value7 in varchar2 default hr_api.g_varchar2
743: ,p_field_name8 in varchar2 default hr_api.g_varchar2
744: ,p_field_value8 in varchar2 default hr_api.g_varchar2
745: ,p_field_name9 in varchar2 default hr_api.g_varchar2
746: ,p_field_value9 in varchar2 default hr_api.g_varchar2
747: ,p_object_version_number in out nocopy number
748:
749: ) is
750: --

Line 836: hr_api.validate_language_code(p_language_code => l_language_code);

832: --
833: --l_in_out_parameter := p_in_out_parameter;
834: l_language_code:=p_language_code;
835:
836: hr_api.validate_language_code(p_language_code => l_language_code);
837:
838: --
839: -- Call Before Process User Hook
840: --

Line 888: when hr_api.cannot_find_prog_unit then

884: ,p_integration_id => p_integration_id
885: ,p_object_version_number => p_object_version_number
886: );
887: exception
888: when hr_api.cannot_find_prog_unit then
889: hr_api.cannot_find_prog_unit_error
890: (p_module_name => 'UPDATE_INTEGRATION'
891: ,p_hook_type => 'BP'
892: );

Line 889: hr_api.cannot_find_prog_unit_error

885: ,p_object_version_number => p_object_version_number
886: );
887: exception
888: when hr_api.cannot_find_prog_unit then
889: hr_api.cannot_find_prog_unit_error
890: (p_module_name => 'UPDATE_INTEGRATION'
891: ,p_hook_type => 'BP'
892: );
893: end;

Line 952: if(p_application_name <> hr_api.g_varchar2) then l_app_code := p_application_name;end if;

948: l_fval4,l_fname5,l_fval5,l_fname6,l_fval6,l_fname7,l_fval7,
949: l_fname8,l_fval8,l_fname9,l_fval9;
950: close csr_getsso_info;
951:
952: if(p_application_name <> hr_api.g_varchar2) then l_app_code := p_application_name;end if;
953: if(p_application_type <> hr_api.g_varchar2) then l_apptype := p_application_type;end if;
954: if(p_application_url <> hr_api.g_varchar2) then l_appurl := p_application_url;end if;
955: if(p_logout_url <> hr_api.g_varchar2) then l_logout_url := p_logout_url;end if;
956: if(p_user_field <> hr_api.g_varchar2) then l_userfld := p_user_field;end if;

Line 953: if(p_application_type <> hr_api.g_varchar2) then l_apptype := p_application_type;end if;

949: l_fname8,l_fval8,l_fname9,l_fval9;
950: close csr_getsso_info;
951:
952: if(p_application_name <> hr_api.g_varchar2) then l_app_code := p_application_name;end if;
953: if(p_application_type <> hr_api.g_varchar2) then l_apptype := p_application_type;end if;
954: if(p_application_url <> hr_api.g_varchar2) then l_appurl := p_application_url;end if;
955: if(p_logout_url <> hr_api.g_varchar2) then l_logout_url := p_logout_url;end if;
956: if(p_user_field <> hr_api.g_varchar2) then l_userfld := p_user_field;end if;
957: if(p_password_field <> hr_api.g_varchar2) then l_pwdfld := p_password_field;end if;

Line 954: if(p_application_url <> hr_api.g_varchar2) then l_appurl := p_application_url;end if;

950: close csr_getsso_info;
951:
952: if(p_application_name <> hr_api.g_varchar2) then l_app_code := p_application_name;end if;
953: if(p_application_type <> hr_api.g_varchar2) then l_apptype := p_application_type;end if;
954: if(p_application_url <> hr_api.g_varchar2) then l_appurl := p_application_url;end if;
955: if(p_logout_url <> hr_api.g_varchar2) then l_logout_url := p_logout_url;end if;
956: if(p_user_field <> hr_api.g_varchar2) then l_userfld := p_user_field;end if;
957: if(p_password_field <> hr_api.g_varchar2) then l_pwdfld := p_password_field;end if;
958: if(p_authentication_needed <> hr_api.g_varchar2) then l_authused := p_authentication_needed;end if;

Line 955: if(p_logout_url <> hr_api.g_varchar2) then l_logout_url := p_logout_url;end if;

951:
952: if(p_application_name <> hr_api.g_varchar2) then l_app_code := p_application_name;end if;
953: if(p_application_type <> hr_api.g_varchar2) then l_apptype := p_application_type;end if;
954: if(p_application_url <> hr_api.g_varchar2) then l_appurl := p_application_url;end if;
955: if(p_logout_url <> hr_api.g_varchar2) then l_logout_url := p_logout_url;end if;
956: if(p_user_field <> hr_api.g_varchar2) then l_userfld := p_user_field;end if;
957: if(p_password_field <> hr_api.g_varchar2) then l_pwdfld := p_password_field;end if;
958: if(p_authentication_needed <> hr_api.g_varchar2) then l_authused := p_authentication_needed;end if;
959: if(p_field_name1 <> hr_api.g_varchar2) then l_fname1 := p_field_name1;end if;

Line 956: if(p_user_field <> hr_api.g_varchar2) then l_userfld := p_user_field;end if;

952: if(p_application_name <> hr_api.g_varchar2) then l_app_code := p_application_name;end if;
953: if(p_application_type <> hr_api.g_varchar2) then l_apptype := p_application_type;end if;
954: if(p_application_url <> hr_api.g_varchar2) then l_appurl := p_application_url;end if;
955: if(p_logout_url <> hr_api.g_varchar2) then l_logout_url := p_logout_url;end if;
956: if(p_user_field <> hr_api.g_varchar2) then l_userfld := p_user_field;end if;
957: if(p_password_field <> hr_api.g_varchar2) then l_pwdfld := p_password_field;end if;
958: if(p_authentication_needed <> hr_api.g_varchar2) then l_authused := p_authentication_needed;end if;
959: if(p_field_name1 <> hr_api.g_varchar2) then l_fname1 := p_field_name1;end if;
960: if(p_field_value1 <> hr_api.g_varchar2) then l_fval1:=p_field_value1;end if;

Line 957: if(p_password_field <> hr_api.g_varchar2) then l_pwdfld := p_password_field;end if;

953: if(p_application_type <> hr_api.g_varchar2) then l_apptype := p_application_type;end if;
954: if(p_application_url <> hr_api.g_varchar2) then l_appurl := p_application_url;end if;
955: if(p_logout_url <> hr_api.g_varchar2) then l_logout_url := p_logout_url;end if;
956: if(p_user_field <> hr_api.g_varchar2) then l_userfld := p_user_field;end if;
957: if(p_password_field <> hr_api.g_varchar2) then l_pwdfld := p_password_field;end if;
958: if(p_authentication_needed <> hr_api.g_varchar2) then l_authused := p_authentication_needed;end if;
959: if(p_field_name1 <> hr_api.g_varchar2) then l_fname1 := p_field_name1;end if;
960: if(p_field_value1 <> hr_api.g_varchar2) then l_fval1:=p_field_value1;end if;
961: if(p_field_name2 <> hr_api.g_varchar2) then l_fname2:=p_field_name2;end if;

Line 958: if(p_authentication_needed <> hr_api.g_varchar2) then l_authused := p_authentication_needed;end if;

954: if(p_application_url <> hr_api.g_varchar2) then l_appurl := p_application_url;end if;
955: if(p_logout_url <> hr_api.g_varchar2) then l_logout_url := p_logout_url;end if;
956: if(p_user_field <> hr_api.g_varchar2) then l_userfld := p_user_field;end if;
957: if(p_password_field <> hr_api.g_varchar2) then l_pwdfld := p_password_field;end if;
958: if(p_authentication_needed <> hr_api.g_varchar2) then l_authused := p_authentication_needed;end if;
959: if(p_field_name1 <> hr_api.g_varchar2) then l_fname1 := p_field_name1;end if;
960: if(p_field_value1 <> hr_api.g_varchar2) then l_fval1:=p_field_value1;end if;
961: if(p_field_name2 <> hr_api.g_varchar2) then l_fname2:=p_field_name2;end if;
962: if(p_field_value2 <> hr_api.g_varchar2) then l_fval2:=p_field_value2;end if;

Line 959: if(p_field_name1 <> hr_api.g_varchar2) then l_fname1 := p_field_name1;end if;

955: if(p_logout_url <> hr_api.g_varchar2) then l_logout_url := p_logout_url;end if;
956: if(p_user_field <> hr_api.g_varchar2) then l_userfld := p_user_field;end if;
957: if(p_password_field <> hr_api.g_varchar2) then l_pwdfld := p_password_field;end if;
958: if(p_authentication_needed <> hr_api.g_varchar2) then l_authused := p_authentication_needed;end if;
959: if(p_field_name1 <> hr_api.g_varchar2) then l_fname1 := p_field_name1;end if;
960: if(p_field_value1 <> hr_api.g_varchar2) then l_fval1:=p_field_value1;end if;
961: if(p_field_name2 <> hr_api.g_varchar2) then l_fname2:=p_field_name2;end if;
962: if(p_field_value2 <> hr_api.g_varchar2) then l_fval2:=p_field_value2;end if;
963: if(p_field_name3 <> hr_api.g_varchar2) then l_fname3:=p_field_name3;end if;

Line 960: if(p_field_value1 <> hr_api.g_varchar2) then l_fval1:=p_field_value1;end if;

956: if(p_user_field <> hr_api.g_varchar2) then l_userfld := p_user_field;end if;
957: if(p_password_field <> hr_api.g_varchar2) then l_pwdfld := p_password_field;end if;
958: if(p_authentication_needed <> hr_api.g_varchar2) then l_authused := p_authentication_needed;end if;
959: if(p_field_name1 <> hr_api.g_varchar2) then l_fname1 := p_field_name1;end if;
960: if(p_field_value1 <> hr_api.g_varchar2) then l_fval1:=p_field_value1;end if;
961: if(p_field_name2 <> hr_api.g_varchar2) then l_fname2:=p_field_name2;end if;
962: if(p_field_value2 <> hr_api.g_varchar2) then l_fval2:=p_field_value2;end if;
963: if(p_field_name3 <> hr_api.g_varchar2) then l_fname3:=p_field_name3;end if;
964: if(p_field_value3 <> hr_api.g_varchar2) then l_fval3:=p_field_value3;end if;

Line 961: if(p_field_name2 <> hr_api.g_varchar2) then l_fname2:=p_field_name2;end if;

957: if(p_password_field <> hr_api.g_varchar2) then l_pwdfld := p_password_field;end if;
958: if(p_authentication_needed <> hr_api.g_varchar2) then l_authused := p_authentication_needed;end if;
959: if(p_field_name1 <> hr_api.g_varchar2) then l_fname1 := p_field_name1;end if;
960: if(p_field_value1 <> hr_api.g_varchar2) then l_fval1:=p_field_value1;end if;
961: if(p_field_name2 <> hr_api.g_varchar2) then l_fname2:=p_field_name2;end if;
962: if(p_field_value2 <> hr_api.g_varchar2) then l_fval2:=p_field_value2;end if;
963: if(p_field_name3 <> hr_api.g_varchar2) then l_fname3:=p_field_name3;end if;
964: if(p_field_value3 <> hr_api.g_varchar2) then l_fval3:=p_field_value3;end if;
965: if(p_field_name4 <> hr_api.g_varchar2) then l_fname4:=p_field_name4;end if;

Line 962: if(p_field_value2 <> hr_api.g_varchar2) then l_fval2:=p_field_value2;end if;

958: if(p_authentication_needed <> hr_api.g_varchar2) then l_authused := p_authentication_needed;end if;
959: if(p_field_name1 <> hr_api.g_varchar2) then l_fname1 := p_field_name1;end if;
960: if(p_field_value1 <> hr_api.g_varchar2) then l_fval1:=p_field_value1;end if;
961: if(p_field_name2 <> hr_api.g_varchar2) then l_fname2:=p_field_name2;end if;
962: if(p_field_value2 <> hr_api.g_varchar2) then l_fval2:=p_field_value2;end if;
963: if(p_field_name3 <> hr_api.g_varchar2) then l_fname3:=p_field_name3;end if;
964: if(p_field_value3 <> hr_api.g_varchar2) then l_fval3:=p_field_value3;end if;
965: if(p_field_name4 <> hr_api.g_varchar2) then l_fname4:=p_field_name4;end if;
966: if(p_field_value4 <> hr_api.g_varchar2) then l_fval4:=p_field_value4;end if;

Line 963: if(p_field_name3 <> hr_api.g_varchar2) then l_fname3:=p_field_name3;end if;

959: if(p_field_name1 <> hr_api.g_varchar2) then l_fname1 := p_field_name1;end if;
960: if(p_field_value1 <> hr_api.g_varchar2) then l_fval1:=p_field_value1;end if;
961: if(p_field_name2 <> hr_api.g_varchar2) then l_fname2:=p_field_name2;end if;
962: if(p_field_value2 <> hr_api.g_varchar2) then l_fval2:=p_field_value2;end if;
963: if(p_field_name3 <> hr_api.g_varchar2) then l_fname3:=p_field_name3;end if;
964: if(p_field_value3 <> hr_api.g_varchar2) then l_fval3:=p_field_value3;end if;
965: if(p_field_name4 <> hr_api.g_varchar2) then l_fname4:=p_field_name4;end if;
966: if(p_field_value4 <> hr_api.g_varchar2) then l_fval4:=p_field_value4;end if;
967: if(p_field_name5 <> hr_api.g_varchar2) then l_fname5:=p_field_name5;end if;

Line 964: if(p_field_value3 <> hr_api.g_varchar2) then l_fval3:=p_field_value3;end if;

960: if(p_field_value1 <> hr_api.g_varchar2) then l_fval1:=p_field_value1;end if;
961: if(p_field_name2 <> hr_api.g_varchar2) then l_fname2:=p_field_name2;end if;
962: if(p_field_value2 <> hr_api.g_varchar2) then l_fval2:=p_field_value2;end if;
963: if(p_field_name3 <> hr_api.g_varchar2) then l_fname3:=p_field_name3;end if;
964: if(p_field_value3 <> hr_api.g_varchar2) then l_fval3:=p_field_value3;end if;
965: if(p_field_name4 <> hr_api.g_varchar2) then l_fname4:=p_field_name4;end if;
966: if(p_field_value4 <> hr_api.g_varchar2) then l_fval4:=p_field_value4;end if;
967: if(p_field_name5 <> hr_api.g_varchar2) then l_fname5:=p_field_name5;end if;
968: if(p_field_value5 <> hr_api.g_varchar2) then l_fval5:=p_field_value5;end if;

Line 965: if(p_field_name4 <> hr_api.g_varchar2) then l_fname4:=p_field_name4;end if;

961: if(p_field_name2 <> hr_api.g_varchar2) then l_fname2:=p_field_name2;end if;
962: if(p_field_value2 <> hr_api.g_varchar2) then l_fval2:=p_field_value2;end if;
963: if(p_field_name3 <> hr_api.g_varchar2) then l_fname3:=p_field_name3;end if;
964: if(p_field_value3 <> hr_api.g_varchar2) then l_fval3:=p_field_value3;end if;
965: if(p_field_name4 <> hr_api.g_varchar2) then l_fname4:=p_field_name4;end if;
966: if(p_field_value4 <> hr_api.g_varchar2) then l_fval4:=p_field_value4;end if;
967: if(p_field_name5 <> hr_api.g_varchar2) then l_fname5:=p_field_name5;end if;
968: if(p_field_value5 <> hr_api.g_varchar2) then l_fval5:=p_field_value5;end if;
969: if(p_field_name6 <> hr_api.g_varchar2) then l_fname6:=p_field_name6;end if;

Line 966: if(p_field_value4 <> hr_api.g_varchar2) then l_fval4:=p_field_value4;end if;

962: if(p_field_value2 <> hr_api.g_varchar2) then l_fval2:=p_field_value2;end if;
963: if(p_field_name3 <> hr_api.g_varchar2) then l_fname3:=p_field_name3;end if;
964: if(p_field_value3 <> hr_api.g_varchar2) then l_fval3:=p_field_value3;end if;
965: if(p_field_name4 <> hr_api.g_varchar2) then l_fname4:=p_field_name4;end if;
966: if(p_field_value4 <> hr_api.g_varchar2) then l_fval4:=p_field_value4;end if;
967: if(p_field_name5 <> hr_api.g_varchar2) then l_fname5:=p_field_name5;end if;
968: if(p_field_value5 <> hr_api.g_varchar2) then l_fval5:=p_field_value5;end if;
969: if(p_field_name6 <> hr_api.g_varchar2) then l_fname6:=p_field_name6;end if;
970: if(p_field_value6 <> hr_api.g_varchar2) then l_fval6:=p_field_value6;end if;

Line 967: if(p_field_name5 <> hr_api.g_varchar2) then l_fname5:=p_field_name5;end if;

963: if(p_field_name3 <> hr_api.g_varchar2) then l_fname3:=p_field_name3;end if;
964: if(p_field_value3 <> hr_api.g_varchar2) then l_fval3:=p_field_value3;end if;
965: if(p_field_name4 <> hr_api.g_varchar2) then l_fname4:=p_field_name4;end if;
966: if(p_field_value4 <> hr_api.g_varchar2) then l_fval4:=p_field_value4;end if;
967: if(p_field_name5 <> hr_api.g_varchar2) then l_fname5:=p_field_name5;end if;
968: if(p_field_value5 <> hr_api.g_varchar2) then l_fval5:=p_field_value5;end if;
969: if(p_field_name6 <> hr_api.g_varchar2) then l_fname6:=p_field_name6;end if;
970: if(p_field_value6 <> hr_api.g_varchar2) then l_fval6:=p_field_value6;end if;
971: if(p_field_name7 <> hr_api.g_varchar2) then l_fname7:=p_field_name7;end if;

Line 968: if(p_field_value5 <> hr_api.g_varchar2) then l_fval5:=p_field_value5;end if;

964: if(p_field_value3 <> hr_api.g_varchar2) then l_fval3:=p_field_value3;end if;
965: if(p_field_name4 <> hr_api.g_varchar2) then l_fname4:=p_field_name4;end if;
966: if(p_field_value4 <> hr_api.g_varchar2) then l_fval4:=p_field_value4;end if;
967: if(p_field_name5 <> hr_api.g_varchar2) then l_fname5:=p_field_name5;end if;
968: if(p_field_value5 <> hr_api.g_varchar2) then l_fval5:=p_field_value5;end if;
969: if(p_field_name6 <> hr_api.g_varchar2) then l_fname6:=p_field_name6;end if;
970: if(p_field_value6 <> hr_api.g_varchar2) then l_fval6:=p_field_value6;end if;
971: if(p_field_name7 <> hr_api.g_varchar2) then l_fname7:=p_field_name7;end if;
972: if(p_field_value7 <> hr_api.g_varchar2) then l_fval7:=p_field_value7;end if;

Line 969: if(p_field_name6 <> hr_api.g_varchar2) then l_fname6:=p_field_name6;end if;

965: if(p_field_name4 <> hr_api.g_varchar2) then l_fname4:=p_field_name4;end if;
966: if(p_field_value4 <> hr_api.g_varchar2) then l_fval4:=p_field_value4;end if;
967: if(p_field_name5 <> hr_api.g_varchar2) then l_fname5:=p_field_name5;end if;
968: if(p_field_value5 <> hr_api.g_varchar2) then l_fval5:=p_field_value5;end if;
969: if(p_field_name6 <> hr_api.g_varchar2) then l_fname6:=p_field_name6;end if;
970: if(p_field_value6 <> hr_api.g_varchar2) then l_fval6:=p_field_value6;end if;
971: if(p_field_name7 <> hr_api.g_varchar2) then l_fname7:=p_field_name7;end if;
972: if(p_field_value7 <> hr_api.g_varchar2) then l_fval7:=p_field_value7;end if;
973: if(p_field_name8 <> hr_api.g_varchar2) then l_fname8:=p_field_name8;end if;

Line 970: if(p_field_value6 <> hr_api.g_varchar2) then l_fval6:=p_field_value6;end if;

966: if(p_field_value4 <> hr_api.g_varchar2) then l_fval4:=p_field_value4;end if;
967: if(p_field_name5 <> hr_api.g_varchar2) then l_fname5:=p_field_name5;end if;
968: if(p_field_value5 <> hr_api.g_varchar2) then l_fval5:=p_field_value5;end if;
969: if(p_field_name6 <> hr_api.g_varchar2) then l_fname6:=p_field_name6;end if;
970: if(p_field_value6 <> hr_api.g_varchar2) then l_fval6:=p_field_value6;end if;
971: if(p_field_name7 <> hr_api.g_varchar2) then l_fname7:=p_field_name7;end if;
972: if(p_field_value7 <> hr_api.g_varchar2) then l_fval7:=p_field_value7;end if;
973: if(p_field_name8 <> hr_api.g_varchar2) then l_fname8:=p_field_name8;end if;
974: if(p_field_value8 <> hr_api.g_varchar2) then l_fval8:=p_field_value8;end if;

Line 971: if(p_field_name7 <> hr_api.g_varchar2) then l_fname7:=p_field_name7;end if;

967: if(p_field_name5 <> hr_api.g_varchar2) then l_fname5:=p_field_name5;end if;
968: if(p_field_value5 <> hr_api.g_varchar2) then l_fval5:=p_field_value5;end if;
969: if(p_field_name6 <> hr_api.g_varchar2) then l_fname6:=p_field_name6;end if;
970: if(p_field_value6 <> hr_api.g_varchar2) then l_fval6:=p_field_value6;end if;
971: if(p_field_name7 <> hr_api.g_varchar2) then l_fname7:=p_field_name7;end if;
972: if(p_field_value7 <> hr_api.g_varchar2) then l_fval7:=p_field_value7;end if;
973: if(p_field_name8 <> hr_api.g_varchar2) then l_fname8:=p_field_name8;end if;
974: if(p_field_value8 <> hr_api.g_varchar2) then l_fval8:=p_field_value8;end if;
975: if(p_field_name9 <> hr_api.g_varchar2) then l_fname9:=p_field_name9;end if;

Line 972: if(p_field_value7 <> hr_api.g_varchar2) then l_fval7:=p_field_value7;end if;

968: if(p_field_value5 <> hr_api.g_varchar2) then l_fval5:=p_field_value5;end if;
969: if(p_field_name6 <> hr_api.g_varchar2) then l_fname6:=p_field_name6;end if;
970: if(p_field_value6 <> hr_api.g_varchar2) then l_fval6:=p_field_value6;end if;
971: if(p_field_name7 <> hr_api.g_varchar2) then l_fname7:=p_field_name7;end if;
972: if(p_field_value7 <> hr_api.g_varchar2) then l_fval7:=p_field_value7;end if;
973: if(p_field_name8 <> hr_api.g_varchar2) then l_fname8:=p_field_name8;end if;
974: if(p_field_value8 <> hr_api.g_varchar2) then l_fval8:=p_field_value8;end if;
975: if(p_field_name9 <> hr_api.g_varchar2) then l_fname9:=p_field_name9;end if;
976: if(p_field_value9 <> hr_api.g_varchar2) then l_fval9:=p_field_value9;end if;

Line 973: if(p_field_name8 <> hr_api.g_varchar2) then l_fname8:=p_field_name8;end if;

969: if(p_field_name6 <> hr_api.g_varchar2) then l_fname6:=p_field_name6;end if;
970: if(p_field_value6 <> hr_api.g_varchar2) then l_fval6:=p_field_value6;end if;
971: if(p_field_name7 <> hr_api.g_varchar2) then l_fname7:=p_field_name7;end if;
972: if(p_field_value7 <> hr_api.g_varchar2) then l_fval7:=p_field_value7;end if;
973: if(p_field_name8 <> hr_api.g_varchar2) then l_fname8:=p_field_name8;end if;
974: if(p_field_value8 <> hr_api.g_varchar2) then l_fval8:=p_field_value8;end if;
975: if(p_field_name9 <> hr_api.g_varchar2) then l_fname9:=p_field_name9;end if;
976: if(p_field_value9 <> hr_api.g_varchar2) then l_fval9:=p_field_value9;end if;
977:

Line 974: if(p_field_value8 <> hr_api.g_varchar2) then l_fval8:=p_field_value8;end if;

970: if(p_field_value6 <> hr_api.g_varchar2) then l_fval6:=p_field_value6;end if;
971: if(p_field_name7 <> hr_api.g_varchar2) then l_fname7:=p_field_name7;end if;
972: if(p_field_value7 <> hr_api.g_varchar2) then l_fval7:=p_field_value7;end if;
973: if(p_field_name8 <> hr_api.g_varchar2) then l_fname8:=p_field_name8;end if;
974: if(p_field_value8 <> hr_api.g_varchar2) then l_fval8:=p_field_value8;end if;
975: if(p_field_name9 <> hr_api.g_varchar2) then l_fname9:=p_field_name9;end if;
976: if(p_field_value9 <> hr_api.g_varchar2) then l_fval9:=p_field_value9;end if;
977:
978: else

Line 975: if(p_field_name9 <> hr_api.g_varchar2) then l_fname9:=p_field_name9;end if;

971: if(p_field_name7 <> hr_api.g_varchar2) then l_fname7:=p_field_name7;end if;
972: if(p_field_value7 <> hr_api.g_varchar2) then l_fval7:=p_field_value7;end if;
973: if(p_field_name8 <> hr_api.g_varchar2) then l_fname8:=p_field_name8;end if;
974: if(p_field_value8 <> hr_api.g_varchar2) then l_fval8:=p_field_value8;end if;
975: if(p_field_name9 <> hr_api.g_varchar2) then l_fname9:=p_field_name9;end if;
976: if(p_field_value9 <> hr_api.g_varchar2) then l_fval9:=p_field_value9;end if;
977:
978: else
979: if (p_application_name is null or p_application_name =hr_api.g_varchar2

Line 976: if(p_field_value9 <> hr_api.g_varchar2) then l_fval9:=p_field_value9;end if;

972: if(p_field_value7 <> hr_api.g_varchar2) then l_fval7:=p_field_value7;end if;
973: if(p_field_name8 <> hr_api.g_varchar2) then l_fname8:=p_field_name8;end if;
974: if(p_field_value8 <> hr_api.g_varchar2) then l_fval8:=p_field_value8;end if;
975: if(p_field_name9 <> hr_api.g_varchar2) then l_fname9:=p_field_name9;end if;
976: if(p_field_value9 <> hr_api.g_varchar2) then l_fval9:=p_field_value9;end if;
977:
978: else
979: if (p_application_name is null or p_application_name =hr_api.g_varchar2
980: or p_application_type is null or p_application_type =hr_api.g_varchar2

Line 979: if (p_application_name is null or p_application_name =hr_api.g_varchar2

975: if(p_field_name9 <> hr_api.g_varchar2) then l_fname9:=p_field_name9;end if;
976: if(p_field_value9 <> hr_api.g_varchar2) then l_fval9:=p_field_value9;end if;
977:
978: else
979: if (p_application_name is null or p_application_name =hr_api.g_varchar2
980: or p_application_type is null or p_application_type =hr_api.g_varchar2
981: or p_application_url is null or p_application_url =hr_api.g_varchar2
982: or p_logout_url is null or p_logout_url =hr_api.g_varchar2
983: or p_user_field is null or p_user_field =hr_api.g_varchar2

Line 980: or p_application_type is null or p_application_type =hr_api.g_varchar2

976: if(p_field_value9 <> hr_api.g_varchar2) then l_fval9:=p_field_value9;end if;
977:
978: else
979: if (p_application_name is null or p_application_name =hr_api.g_varchar2
980: or p_application_type is null or p_application_type =hr_api.g_varchar2
981: or p_application_url is null or p_application_url =hr_api.g_varchar2
982: or p_logout_url is null or p_logout_url =hr_api.g_varchar2
983: or p_user_field is null or p_user_field =hr_api.g_varchar2
984: or p_password_field is null or p_password_field =hr_api.g_varchar2

Line 981: or p_application_url is null or p_application_url =hr_api.g_varchar2

977:
978: else
979: if (p_application_name is null or p_application_name =hr_api.g_varchar2
980: or p_application_type is null or p_application_type =hr_api.g_varchar2
981: or p_application_url is null or p_application_url =hr_api.g_varchar2
982: or p_logout_url is null or p_logout_url =hr_api.g_varchar2
983: or p_user_field is null or p_user_field =hr_api.g_varchar2
984: or p_password_field is null or p_password_field =hr_api.g_varchar2
985: or p_authentication_needed is null or p_authentication_needed =hr_api.g_varchar2

Line 982: or p_logout_url is null or p_logout_url =hr_api.g_varchar2

978: else
979: if (p_application_name is null or p_application_name =hr_api.g_varchar2
980: or p_application_type is null or p_application_type =hr_api.g_varchar2
981: or p_application_url is null or p_application_url =hr_api.g_varchar2
982: or p_logout_url is null or p_logout_url =hr_api.g_varchar2
983: or p_user_field is null or p_user_field =hr_api.g_varchar2
984: or p_password_field is null or p_password_field =hr_api.g_varchar2
985: or p_authentication_needed is null or p_authentication_needed =hr_api.g_varchar2
986: ) then

Line 983: or p_user_field is null or p_user_field =hr_api.g_varchar2

979: if (p_application_name is null or p_application_name =hr_api.g_varchar2
980: or p_application_type is null or p_application_type =hr_api.g_varchar2
981: or p_application_url is null or p_application_url =hr_api.g_varchar2
982: or p_logout_url is null or p_logout_url =hr_api.g_varchar2
983: or p_user_field is null or p_user_field =hr_api.g_varchar2
984: or p_password_field is null or p_password_field =hr_api.g_varchar2
985: or p_authentication_needed is null or p_authentication_needed =hr_api.g_varchar2
986: ) then
987: fnd_message.set_name('PER','PER_0000_INT_API_SSO_INVAL');

Line 984: or p_password_field is null or p_password_field =hr_api.g_varchar2

980: or p_application_type is null or p_application_type =hr_api.g_varchar2
981: or p_application_url is null or p_application_url =hr_api.g_varchar2
982: or p_logout_url is null or p_logout_url =hr_api.g_varchar2
983: or p_user_field is null or p_user_field =hr_api.g_varchar2
984: or p_password_field is null or p_password_field =hr_api.g_varchar2
985: or p_authentication_needed is null or p_authentication_needed =hr_api.g_varchar2
986: ) then
987: fnd_message.set_name('PER','PER_0000_INT_API_SSO_INVAL');
988: fnd_message.raise_error;

Line 985: or p_authentication_needed is null or p_authentication_needed =hr_api.g_varchar2

981: or p_application_url is null or p_application_url =hr_api.g_varchar2
982: or p_logout_url is null or p_logout_url =hr_api.g_varchar2
983: or p_user_field is null or p_user_field =hr_api.g_varchar2
984: or p_password_field is null or p_password_field =hr_api.g_varchar2
985: or p_authentication_needed is null or p_authentication_needed =hr_api.g_varchar2
986: ) then
987: fnd_message.set_name('PER','PER_0000_INT_API_SSO_INVAL');
988: fnd_message.raise_error;
989: end if;

Line 1034: --otherwise they will be updated by hr_api.g_varchar2

1030:
1031: elsif (p_target_type = 'SSO') then
1032:
1033: --set all the default SSO values to null
1034: --otherwise they will be updated by hr_api.g_varchar2
1035: if (l_fname1 =hr_api.g_varchar2) then l_fname1:=null; end if;
1036: if (l_fval1 =hr_api.g_varchar2) then l_fval1 :=null; end if;
1037: if (l_fname2 =hr_api.g_varchar2) then l_fname2:=null; end if;
1038: if (l_fval2 =hr_api.g_varchar2) then l_fval2 :=null; end if;

Line 1035: if (l_fname1 =hr_api.g_varchar2) then l_fname1:=null; end if;

1031: elsif (p_target_type = 'SSO') then
1032:
1033: --set all the default SSO values to null
1034: --otherwise they will be updated by hr_api.g_varchar2
1035: if (l_fname1 =hr_api.g_varchar2) then l_fname1:=null; end if;
1036: if (l_fval1 =hr_api.g_varchar2) then l_fval1 :=null; end if;
1037: if (l_fname2 =hr_api.g_varchar2) then l_fname2:=null; end if;
1038: if (l_fval2 =hr_api.g_varchar2) then l_fval2 :=null; end if;
1039: if (l_fname3 =hr_api.g_varchar2) then l_fname3:=null; end if;

Line 1036: if (l_fval1 =hr_api.g_varchar2) then l_fval1 :=null; end if;

1032:
1033: --set all the default SSO values to null
1034: --otherwise they will be updated by hr_api.g_varchar2
1035: if (l_fname1 =hr_api.g_varchar2) then l_fname1:=null; end if;
1036: if (l_fval1 =hr_api.g_varchar2) then l_fval1 :=null; end if;
1037: if (l_fname2 =hr_api.g_varchar2) then l_fname2:=null; end if;
1038: if (l_fval2 =hr_api.g_varchar2) then l_fval2 :=null; end if;
1039: if (l_fname3 =hr_api.g_varchar2) then l_fname3:=null; end if;
1040: if (l_fval3 =hr_api.g_varchar2) then l_fval3 :=null; end if;

Line 1037: if (l_fname2 =hr_api.g_varchar2) then l_fname2:=null; end if;

1033: --set all the default SSO values to null
1034: --otherwise they will be updated by hr_api.g_varchar2
1035: if (l_fname1 =hr_api.g_varchar2) then l_fname1:=null; end if;
1036: if (l_fval1 =hr_api.g_varchar2) then l_fval1 :=null; end if;
1037: if (l_fname2 =hr_api.g_varchar2) then l_fname2:=null; end if;
1038: if (l_fval2 =hr_api.g_varchar2) then l_fval2 :=null; end if;
1039: if (l_fname3 =hr_api.g_varchar2) then l_fname3:=null; end if;
1040: if (l_fval3 =hr_api.g_varchar2) then l_fval3 :=null; end if;
1041: if (l_fname4 =hr_api.g_varchar2) then l_fname4:=null; end if;

Line 1038: if (l_fval2 =hr_api.g_varchar2) then l_fval2 :=null; end if;

1034: --otherwise they will be updated by hr_api.g_varchar2
1035: if (l_fname1 =hr_api.g_varchar2) then l_fname1:=null; end if;
1036: if (l_fval1 =hr_api.g_varchar2) then l_fval1 :=null; end if;
1037: if (l_fname2 =hr_api.g_varchar2) then l_fname2:=null; end if;
1038: if (l_fval2 =hr_api.g_varchar2) then l_fval2 :=null; end if;
1039: if (l_fname3 =hr_api.g_varchar2) then l_fname3:=null; end if;
1040: if (l_fval3 =hr_api.g_varchar2) then l_fval3 :=null; end if;
1041: if (l_fname4 =hr_api.g_varchar2) then l_fname4:=null; end if;
1042: if (l_fval4 =hr_api.g_varchar2) then l_fval4 :=null; end if;

Line 1039: if (l_fname3 =hr_api.g_varchar2) then l_fname3:=null; end if;

1035: if (l_fname1 =hr_api.g_varchar2) then l_fname1:=null; end if;
1036: if (l_fval1 =hr_api.g_varchar2) then l_fval1 :=null; end if;
1037: if (l_fname2 =hr_api.g_varchar2) then l_fname2:=null; end if;
1038: if (l_fval2 =hr_api.g_varchar2) then l_fval2 :=null; end if;
1039: if (l_fname3 =hr_api.g_varchar2) then l_fname3:=null; end if;
1040: if (l_fval3 =hr_api.g_varchar2) then l_fval3 :=null; end if;
1041: if (l_fname4 =hr_api.g_varchar2) then l_fname4:=null; end if;
1042: if (l_fval4 =hr_api.g_varchar2) then l_fval4 :=null; end if;
1043: if (l_fname5 =hr_api.g_varchar2) then l_fname5:=null; end if;

Line 1040: if (l_fval3 =hr_api.g_varchar2) then l_fval3 :=null; end if;

1036: if (l_fval1 =hr_api.g_varchar2) then l_fval1 :=null; end if;
1037: if (l_fname2 =hr_api.g_varchar2) then l_fname2:=null; end if;
1038: if (l_fval2 =hr_api.g_varchar2) then l_fval2 :=null; end if;
1039: if (l_fname3 =hr_api.g_varchar2) then l_fname3:=null; end if;
1040: if (l_fval3 =hr_api.g_varchar2) then l_fval3 :=null; end if;
1041: if (l_fname4 =hr_api.g_varchar2) then l_fname4:=null; end if;
1042: if (l_fval4 =hr_api.g_varchar2) then l_fval4 :=null; end if;
1043: if (l_fname5 =hr_api.g_varchar2) then l_fname5:=null; end if;
1044: if (l_fval5 =hr_api.g_varchar2) then l_fval5 :=null; end if;

Line 1041: if (l_fname4 =hr_api.g_varchar2) then l_fname4:=null; end if;

1037: if (l_fname2 =hr_api.g_varchar2) then l_fname2:=null; end if;
1038: if (l_fval2 =hr_api.g_varchar2) then l_fval2 :=null; end if;
1039: if (l_fname3 =hr_api.g_varchar2) then l_fname3:=null; end if;
1040: if (l_fval3 =hr_api.g_varchar2) then l_fval3 :=null; end if;
1041: if (l_fname4 =hr_api.g_varchar2) then l_fname4:=null; end if;
1042: if (l_fval4 =hr_api.g_varchar2) then l_fval4 :=null; end if;
1043: if (l_fname5 =hr_api.g_varchar2) then l_fname5:=null; end if;
1044: if (l_fval5 =hr_api.g_varchar2) then l_fval5 :=null; end if;
1045: if (l_fname6 =hr_api.g_varchar2) then l_fname6:=null; end if;

Line 1042: if (l_fval4 =hr_api.g_varchar2) then l_fval4 :=null; end if;

1038: if (l_fval2 =hr_api.g_varchar2) then l_fval2 :=null; end if;
1039: if (l_fname3 =hr_api.g_varchar2) then l_fname3:=null; end if;
1040: if (l_fval3 =hr_api.g_varchar2) then l_fval3 :=null; end if;
1041: if (l_fname4 =hr_api.g_varchar2) then l_fname4:=null; end if;
1042: if (l_fval4 =hr_api.g_varchar2) then l_fval4 :=null; end if;
1043: if (l_fname5 =hr_api.g_varchar2) then l_fname5:=null; end if;
1044: if (l_fval5 =hr_api.g_varchar2) then l_fval5 :=null; end if;
1045: if (l_fname6 =hr_api.g_varchar2) then l_fname6:=null; end if;
1046: if (l_fval6 =hr_api.g_varchar2) then l_fval6 :=null; end if;

Line 1043: if (l_fname5 =hr_api.g_varchar2) then l_fname5:=null; end if;

1039: if (l_fname3 =hr_api.g_varchar2) then l_fname3:=null; end if;
1040: if (l_fval3 =hr_api.g_varchar2) then l_fval3 :=null; end if;
1041: if (l_fname4 =hr_api.g_varchar2) then l_fname4:=null; end if;
1042: if (l_fval4 =hr_api.g_varchar2) then l_fval4 :=null; end if;
1043: if (l_fname5 =hr_api.g_varchar2) then l_fname5:=null; end if;
1044: if (l_fval5 =hr_api.g_varchar2) then l_fval5 :=null; end if;
1045: if (l_fname6 =hr_api.g_varchar2) then l_fname6:=null; end if;
1046: if (l_fval6 =hr_api.g_varchar2) then l_fval6 :=null; end if;
1047: if (l_fname7 =hr_api.g_varchar2) then l_fname7:=null; end if;

Line 1044: if (l_fval5 =hr_api.g_varchar2) then l_fval5 :=null; end if;

1040: if (l_fval3 =hr_api.g_varchar2) then l_fval3 :=null; end if;
1041: if (l_fname4 =hr_api.g_varchar2) then l_fname4:=null; end if;
1042: if (l_fval4 =hr_api.g_varchar2) then l_fval4 :=null; end if;
1043: if (l_fname5 =hr_api.g_varchar2) then l_fname5:=null; end if;
1044: if (l_fval5 =hr_api.g_varchar2) then l_fval5 :=null; end if;
1045: if (l_fname6 =hr_api.g_varchar2) then l_fname6:=null; end if;
1046: if (l_fval6 =hr_api.g_varchar2) then l_fval6 :=null; end if;
1047: if (l_fname7 =hr_api.g_varchar2) then l_fname7:=null; end if;
1048: if (l_fval7 =hr_api.g_varchar2) then l_fval7 :=null; end if;

Line 1045: if (l_fname6 =hr_api.g_varchar2) then l_fname6:=null; end if;

1041: if (l_fname4 =hr_api.g_varchar2) then l_fname4:=null; end if;
1042: if (l_fval4 =hr_api.g_varchar2) then l_fval4 :=null; end if;
1043: if (l_fname5 =hr_api.g_varchar2) then l_fname5:=null; end if;
1044: if (l_fval5 =hr_api.g_varchar2) then l_fval5 :=null; end if;
1045: if (l_fname6 =hr_api.g_varchar2) then l_fname6:=null; end if;
1046: if (l_fval6 =hr_api.g_varchar2) then l_fval6 :=null; end if;
1047: if (l_fname7 =hr_api.g_varchar2) then l_fname7:=null; end if;
1048: if (l_fval7 =hr_api.g_varchar2) then l_fval7 :=null; end if;
1049: if (l_fname8 =hr_api.g_varchar2) then l_fname8:=null; end if;

Line 1046: if (l_fval6 =hr_api.g_varchar2) then l_fval6 :=null; end if;

1042: if (l_fval4 =hr_api.g_varchar2) then l_fval4 :=null; end if;
1043: if (l_fname5 =hr_api.g_varchar2) then l_fname5:=null; end if;
1044: if (l_fval5 =hr_api.g_varchar2) then l_fval5 :=null; end if;
1045: if (l_fname6 =hr_api.g_varchar2) then l_fname6:=null; end if;
1046: if (l_fval6 =hr_api.g_varchar2) then l_fval6 :=null; end if;
1047: if (l_fname7 =hr_api.g_varchar2) then l_fname7:=null; end if;
1048: if (l_fval7 =hr_api.g_varchar2) then l_fval7 :=null; end if;
1049: if (l_fname8 =hr_api.g_varchar2) then l_fname8:=null; end if;
1050: if (l_fval8 =hr_api.g_varchar2) then l_fval8 :=null; end if;

Line 1047: if (l_fname7 =hr_api.g_varchar2) then l_fname7:=null; end if;

1043: if (l_fname5 =hr_api.g_varchar2) then l_fname5:=null; end if;
1044: if (l_fval5 =hr_api.g_varchar2) then l_fval5 :=null; end if;
1045: if (l_fname6 =hr_api.g_varchar2) then l_fname6:=null; end if;
1046: if (l_fval6 =hr_api.g_varchar2) then l_fval6 :=null; end if;
1047: if (l_fname7 =hr_api.g_varchar2) then l_fname7:=null; end if;
1048: if (l_fval7 =hr_api.g_varchar2) then l_fval7 :=null; end if;
1049: if (l_fname8 =hr_api.g_varchar2) then l_fname8:=null; end if;
1050: if (l_fval8 =hr_api.g_varchar2) then l_fval8 :=null; end if;
1051: if (l_fname9 =hr_api.g_varchar2) then l_fname9:=null; end if;

Line 1048: if (l_fval7 =hr_api.g_varchar2) then l_fval7 :=null; end if;

1044: if (l_fval5 =hr_api.g_varchar2) then l_fval5 :=null; end if;
1045: if (l_fname6 =hr_api.g_varchar2) then l_fname6:=null; end if;
1046: if (l_fval6 =hr_api.g_varchar2) then l_fval6 :=null; end if;
1047: if (l_fname7 =hr_api.g_varchar2) then l_fname7:=null; end if;
1048: if (l_fval7 =hr_api.g_varchar2) then l_fval7 :=null; end if;
1049: if (l_fname8 =hr_api.g_varchar2) then l_fname8:=null; end if;
1050: if (l_fval8 =hr_api.g_varchar2) then l_fval8 :=null; end if;
1051: if (l_fname9 =hr_api.g_varchar2) then l_fname9:=null; end if;
1052: if (l_fval9 =hr_api.g_varchar2) then l_fval9 :=null; end if;

Line 1049: if (l_fname8 =hr_api.g_varchar2) then l_fname8:=null; end if;

1045: if (l_fname6 =hr_api.g_varchar2) then l_fname6:=null; end if;
1046: if (l_fval6 =hr_api.g_varchar2) then l_fval6 :=null; end if;
1047: if (l_fname7 =hr_api.g_varchar2) then l_fname7:=null; end if;
1048: if (l_fval7 =hr_api.g_varchar2) then l_fval7 :=null; end if;
1049: if (l_fname8 =hr_api.g_varchar2) then l_fname8:=null; end if;
1050: if (l_fval8 =hr_api.g_varchar2) then l_fval8 :=null; end if;
1051: if (l_fname9 =hr_api.g_varchar2) then l_fname9:=null; end if;
1052: if (l_fval9 =hr_api.g_varchar2) then l_fval9 :=null; end if;
1053: begin

Line 1050: if (l_fval8 =hr_api.g_varchar2) then l_fval8 :=null; end if;

1046: if (l_fval6 =hr_api.g_varchar2) then l_fval6 :=null; end if;
1047: if (l_fname7 =hr_api.g_varchar2) then l_fname7:=null; end if;
1048: if (l_fval7 =hr_api.g_varchar2) then l_fval7 :=null; end if;
1049: if (l_fname8 =hr_api.g_varchar2) then l_fname8:=null; end if;
1050: if (l_fval8 =hr_api.g_varchar2) then l_fval8 :=null; end if;
1051: if (l_fname9 =hr_api.g_varchar2) then l_fname9:=null; end if;
1052: if (l_fval9 =hr_api.g_varchar2) then l_fval9 :=null; end if;
1053: begin
1054: hr_eap_ins.register(

Line 1051: if (l_fname9 =hr_api.g_varchar2) then l_fname9:=null; end if;

1047: if (l_fname7 =hr_api.g_varchar2) then l_fname7:=null; end if;
1048: if (l_fval7 =hr_api.g_varchar2) then l_fval7 :=null; end if;
1049: if (l_fname8 =hr_api.g_varchar2) then l_fname8:=null; end if;
1050: if (l_fval8 =hr_api.g_varchar2) then l_fval8 :=null; end if;
1051: if (l_fname9 =hr_api.g_varchar2) then l_fname9:=null; end if;
1052: if (l_fval9 =hr_api.g_varchar2) then l_fval9 :=null; end if;
1053: begin
1054: hr_eap_ins.register(
1055: p_app_code => p_application_name

Line 1052: if (l_fval9 =hr_api.g_varchar2) then l_fval9 :=null; end if;

1048: if (l_fval7 =hr_api.g_varchar2) then l_fval7 :=null; end if;
1049: if (l_fname8 =hr_api.g_varchar2) then l_fname8:=null; end if;
1050: if (l_fval8 =hr_api.g_varchar2) then l_fval8 :=null; end if;
1051: if (l_fname9 =hr_api.g_varchar2) then l_fname9:=null; end if;
1052: if (l_fval9 =hr_api.g_varchar2) then l_fval9 :=null; end if;
1053: begin
1054: hr_eap_ins.register(
1055: p_app_code => p_application_name
1056: ,p_apptype => p_application_type

Line 1264: when hr_api.cannot_find_prog_unit then

1260: ,p_ext_application_id => l_ext_application_id
1261: ,p_object_version_number => p_object_version_number
1262: );
1263: exception
1264: when hr_api.cannot_find_prog_unit then
1265: hr_api.cannot_find_prog_unit_error
1266: (p_module_name => 'UPDATE_INTEGRATION'
1267: ,p_hook_type => 'AP'
1268: );

Line 1265: hr_api.cannot_find_prog_unit_error

1261: ,p_object_version_number => p_object_version_number
1262: );
1263: exception
1264: when hr_api.cannot_find_prog_unit then
1265: hr_api.cannot_find_prog_unit_error
1266: (p_module_name => 'UPDATE_INTEGRATION'
1267: ,p_hook_type => 'AP'
1268: );
1269: end;

Line 1274: raise hr_api.validate_enabled;

1270: --
1271: -- When in validation only mode raise the Validate_Enabled exception
1272: --
1273: if p_validate then
1274: raise hr_api.validate_enabled;
1275: end if;
1276: --
1277: -- Set all IN OUT and OUT parameters with out values
1278: --

Line 1286: when hr_api.validate_enabled then

1282:
1283: --
1284: hr_utility.set_location(' Leaving:'||l_proc, 70);
1285: exception
1286: when hr_api.validate_enabled then
1287: --
1288: -- As the Validate_Enabled exception has been raised
1289: -- we must rollback to the savepoint
1290: --

Line 1365: when hr_api.cannot_find_prog_unit then

1361: ,p_object_version_number => p_object_version_number
1362:
1363: );
1364: exception
1365: when hr_api.cannot_find_prog_unit then
1366: hr_api.cannot_find_prog_unit_error
1367: (p_module_name => 'delete_integration'
1368: ,p_hook_type => 'BP'
1369: );

Line 1366: hr_api.cannot_find_prog_unit_error

1362:
1363: );
1364: exception
1365: when hr_api.cannot_find_prog_unit then
1366: hr_api.cannot_find_prog_unit_error
1367: (p_module_name => 'delete_integration'
1368: ,p_hook_type => 'BP'
1369: );
1370: end;

Line 1423: when hr_api.cannot_find_prog_unit then

1419: ,p_integration_id => p_integration_id
1420: ,p_object_version_number => p_object_version_number
1421: );
1422: exception
1423: when hr_api.cannot_find_prog_unit then
1424: hr_api.cannot_find_prog_unit_error
1425: (p_module_name => 'delete_integration'
1426: ,p_hook_type => 'AP'
1427: );

Line 1424: hr_api.cannot_find_prog_unit_error

1420: ,p_object_version_number => p_object_version_number
1421: );
1422: exception
1423: when hr_api.cannot_find_prog_unit then
1424: hr_api.cannot_find_prog_unit_error
1425: (p_module_name => 'delete_integration'
1426: ,p_hook_type => 'AP'
1427: );
1428: end;

Line 1433: raise hr_api.validate_enabled;

1429: --
1430: -- When in validation only mode raise the Validate_Enabled exception
1431: --
1432: if p_validate then
1433: raise hr_api.validate_enabled;
1434: end if;
1435: --
1436: -- Set all IN OUT and OUT parameters with out values
1437: --

Line 1442: when hr_api.validate_enabled then

1438:
1439: --
1440: hr_utility.set_location(' Leaving:'||l_proc, 70);
1441: exception
1442: when hr_api.validate_enabled then
1443: --
1444: -- As the Validate_Enabled exception has been raised
1445: -- we must rollback to the savepoint
1446: --