The following lines contain the word 'select', 'insert', 'update' or 'delete':
select null from ecx_tp_headers_v h,ecx_tp_details_v d
where h.tp_header_id=d.tp_header_id
and h.party_type=cur_party_type
and h.party_name=cur_party_name
and h.party_site_name=cur_party_site_name
and d.transaction_type=cur_transaction_type
and d.transaction_subtype=cur_transaction_subtype
and d.standard_code=cur_standard_code
and d.ext_type=cur_ext_trans_type
and d.ext_subtype=cur_ext_trans_subtype
and d.transaction_direction=cur_trans_direction;
select
SYNCHED
,PARTY_TYPE
,PARTY_NAME
,PARTY_SITE_NAME
,TRANSACTION_TYPE
,TRANSACTION_SUBTYPE
,STANDARD_CODE
,EXT_TRANS_TYPE
,EXT_TRANS_SUBTYPE
,TRANS_DIRECTION
,URL
,EXT_APPLICATION_ID
,APPLICATION_NAME
,APPLICATION_TYPE
,APPLICATION_URL
,LOGOUT_URL
,USER_FIELD
,PASSWORD_FIELD
,AUTHENTICATION_NEEDED
,FIELD_NAME1
,FIELD_VALUE1
,FIELD_NAME2
,FIELD_VALUE2
,FIELD_NAME3
,FIELD_VALUE3
,FIELD_NAME4
,FIELD_VALUE4
,FIELD_NAME5
,FIELD_VALUE5
,FIELD_NAME6
,FIELD_VALUE6
,FIELD_NAME7
,FIELD_VALUE7
,FIELD_NAME8
,FIELD_VALUE8
,FIELD_NAME9
,FIELD_VALUE9
from hr_ki_integrations
where integration_id = p_integration_id
and object_version_number = p_object_version_number;
HR_KI_INTEGRATIONS_API.update_integration
(
p_source_type => 'SSO'
,p_target_type => 'SSO'
,p_integration_id => p_integration_id
,p_application_name => l_app_code
,p_application_type => l_apptype
,p_application_url => l_appurl
,p_logout_url => l_logout_url
,p_user_field => l_userfld
,p_password_field => l_pwdfld
,p_authentication_needed => l_authused
,p_field_name1 => l_fname1
,p_field_value1 => l_fval1
,p_field_name2 => l_fname2
,p_field_value2 => l_fval2
,p_field_name3 => l_fname3
,p_field_value3 => l_fval3
,p_field_name4 => l_fname4
,p_field_value4 => l_fval4
,p_field_name5 => l_fname5
,p_field_value5 => l_fval5
,p_field_name6 => l_fname6
,p_field_value6 => l_fval6
,p_field_name7 => l_fname7
,p_field_value7 => l_fval7
,p_field_name8 => l_fname8
,p_field_value8 => l_fval8
,p_field_name9 => l_fname9
,p_field_value9 => l_fval9
,p_object_version_number => p_object_version_number
);
hr_utility.set_location('ECX Update integrations:'|| l_proc, 70);
procedure UPDATE_INTEGRATION
(p_validate in boolean default false
,p_language_code in varchar2 default hr_api.userenv_lang
,p_integration_id in number
,p_source_type in varchar2
,p_target_type in varchar2
,p_party_type in varchar2 default hr_api.g_varchar2
,p_party_name in varchar2 default hr_api.g_varchar2
,p_party_site_name in varchar2 default hr_api.g_varchar2
,p_transaction_type in varchar2 default hr_api.g_varchar2
,p_transaction_subtype in varchar2 default hr_api.g_varchar2
,p_standard_code in varchar2 default hr_api.g_varchar2
,p_ext_trans_type in varchar2 default hr_api.g_varchar2
,p_ext_trans_subtype in varchar2 default hr_api.g_varchar2
,p_trans_direction in varchar2 default hr_api.g_varchar2
,p_url in varchar2 default hr_api.g_varchar2
,p_partner_name in varchar2 default hr_api.g_varchar2
,p_service_name in varchar2 default hr_api.g_varchar2
,p_application_name in varchar2 default hr_api.g_varchar2
,p_application_type in varchar2 default hr_api.g_varchar2
,p_application_url in varchar2 default hr_api.g_varchar2
,p_logout_url in varchar2 default hr_api.g_varchar2
,p_user_field in varchar2 default hr_api.g_varchar2
,p_password_field in varchar2 default hr_api.g_varchar2
,p_authentication_needed in varchar2 default hr_api.g_varchar2
,p_field_name1 in varchar2 default hr_api.g_varchar2
,p_field_value1 in varchar2 default hr_api.g_varchar2
,p_field_name2 in varchar2 default hr_api.g_varchar2
,p_field_value2 in varchar2 default hr_api.g_varchar2
,p_field_name3 in varchar2 default hr_api.g_varchar2
,p_field_value3 in varchar2 default hr_api.g_varchar2
,p_field_name4 in varchar2 default hr_api.g_varchar2
,p_field_value4 in varchar2 default hr_api.g_varchar2
,p_field_name5 in varchar2 default hr_api.g_varchar2
,p_field_value5 in varchar2 default hr_api.g_varchar2
,p_field_name6 in varchar2 default hr_api.g_varchar2
,p_field_value6 in varchar2 default hr_api.g_varchar2
,p_field_name7 in varchar2 default hr_api.g_varchar2
,p_field_value7 in varchar2 default hr_api.g_varchar2
,p_field_name8 in varchar2 default hr_api.g_varchar2
,p_field_value8 in varchar2 default hr_api.g_varchar2
,p_field_name9 in varchar2 default hr_api.g_varchar2
,p_field_value9 in varchar2 default hr_api.g_varchar2
,p_object_version_number in out nocopy number
) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'UPDATE_INTEGRATION';
select inte.ext_application_id,ext.external_application_id
from
hr_ki_integrations inte,
hr_ki_ext_applications ext
where inte.integration_id=p_integration_id
and inte.ext_application_id=ext.ext_application_id;
select APPLICATION_NAME,APPLICATION_TYPE,APPLICATION_URL
,LOGOUT_URL,USER_FIELD,PASSWORD_FIELD,AUTHENTICATION_NEEDED,
FIELD_NAME1,FIELD_VALUE1,FIELD_NAME2,FIELD_VALUE2,FIELD_NAME3,
FIELD_VALUE3,FIELD_NAME4,FIELD_VALUE4,FIELD_NAME5,FIELD_VALUE5,
FIELD_NAME6,FIELD_VALUE6,FIELD_NAME7,FIELD_VALUE7,FIELD_NAME8,
FIELD_VALUE8,FIELD_NAME9 ,FIELD_VALUE9
from
hr_ki_integrations
where integration_id=p_integration_id;
savepoint UPDATE_INTEGRATION;
hr_ki_integrations_bk2.UPDATE_INTEGRATION_b
(
p_language_code => l_language_code
,p_source_type => p_source_type
,p_target_type => p_target_type
,p_party_type => p_party_type
,p_party_name => p_party_name
,p_party_site_name => p_party_site_name
,p_transaction_type => p_transaction_type
,p_transaction_subtype => p_transaction_subtype
,p_standard_code => p_standard_code
,p_ext_trans_type => p_ext_trans_type
,p_ext_trans_subtype => p_ext_trans_subtype
,p_trans_direction => p_trans_direction
,p_url => p_url
,p_partner_name => p_partner_name
,p_service_name => p_service_name
,p_application_name => p_application_name
,p_application_type => p_application_type
,p_application_url => p_application_url
,p_logout_url => p_logout_url
,p_user_field => p_user_field
,p_password_field => p_password_field
,p_authentication_needed => p_authentication_needed
,p_field_name1 => p_field_name1
,p_field_value1 => p_field_value1
,p_field_name2 => p_field_name2
,p_field_value2 => p_field_value2
,p_field_name3 => p_field_name3
,p_field_value3 => p_field_value3
,p_field_name4 => p_field_name4
,p_field_value4 => p_field_value4
,p_field_name5 => p_field_name5
,p_field_value5 => p_field_value5
,p_field_name6 => p_field_name6
,p_field_value6 => p_field_value6
,p_field_name7 => p_field_name7
,p_field_value7 => p_field_value7
,p_field_name8 => p_field_name8
,p_field_value8 => p_field_value8
,p_field_name9 => p_field_name9
,p_field_value9 => p_field_value9
,p_integration_id => p_integration_id
,p_object_version_number => p_object_version_number
);
(p_module_name => 'UPDATE_INTEGRATION'
,p_hook_type => 'BP'
);
hr_eap_upd.update_sso_details(
p_ext_application_id => l_ext_application_id
,p_app_code => l_app_code
,p_apptype => l_apptype
,p_appurl => l_appurl
,p_logout_url => l_logout_url
,p_userfld => l_userfld
,p_pwdfld => l_pwdfld
,p_authused => l_authused
,p_fname1 => l_fname1
,p_fval1 => l_fval1
,p_fname2 => l_fname2
,p_fval2 => l_fval2
,p_fname3 => l_fname3
,p_fval3 => l_fval3
,p_fname4 => l_fname4
,p_fval4 => l_fval4
,p_fname5 => l_fname5
,p_fval5 => l_fval5
,p_fname6 => l_fname6
,p_fval6 => l_fval6
,p_fname7 => l_fname7
,p_fval7 => l_fval7
,p_fname8 => l_fname8
,p_fval8 => l_fval8
,p_fname9 => l_fname9
,p_fval9 => l_fval9);
hr_eap_del.delete_sso_details(p_sso_id => l_extid);
hr_ki_integrations_bk2.update_integration_a
(
p_language_code => l_language_code
,p_source_type => p_source_type
,p_target_type => p_target_type
,p_party_type => p_party_type
,p_party_name => p_party_name
,p_party_site_name => p_party_site_name
,p_transaction_type => p_transaction_type
,p_transaction_subtype => p_transaction_subtype
,p_standard_code => p_standard_code
,p_ext_trans_type => p_ext_trans_type
,p_ext_trans_subtype => p_ext_trans_subtype
,p_trans_direction => p_trans_direction
,p_url => p_url
,p_partner_name => p_partner_name
,p_service_name => p_service_name
,p_application_name => p_application_name
,p_application_type => p_application_type
,p_application_url => p_application_url
,p_logout_url => p_logout_url
,p_user_field => p_user_field
,p_password_field => p_password_field
,p_authentication_needed => p_authentication_needed
,p_field_name1 => p_field_name1
,p_field_value1 => p_field_value1
,p_field_name2 => p_field_name2
,p_field_value2 => p_field_value2
,p_field_name3 => p_field_name3
,p_field_value3 => p_field_value3
,p_field_name4 => p_field_name4
,p_field_value4 => p_field_value4
,p_field_name5 => p_field_name5
,p_field_value5 => p_field_value5
,p_field_name6 => p_field_name6
,p_field_value6 => p_field_value6
,p_field_name7 => p_field_name7
,p_field_value7 => p_field_value7
,p_field_name8 => p_field_name8
,p_field_value8 => p_field_value8
,p_field_name9 => p_field_name9
,p_field_value9 => p_field_value9
,p_integration_id => p_integration_id
,p_ext_application_id => l_ext_application_id
,p_object_version_number => p_object_version_number
);
(p_module_name => 'UPDATE_INTEGRATION'
,p_hook_type => 'AP'
);
rollback to UPDATE_INTEGRATION;
rollback to UPDATE_INTEGRATION;
end UPDATE_INTEGRATION;
procedure delete_integration
(
P_VALIDATE in boolean default false
,P_SSO_ENABLED in boolean default false
,P_INTEGRATION_ID in number
,P_OBJECT_VERSION_NUMBER in number
) is
--
-- Declare cursors and local variables
--
l_proc varchar2(72) := g_package||'delete_integration';
select ext.external_application_id,ext.ext_application_id from
hr_ki_integrations inte,
hr_ki_ext_applications ext
where inte.integration_id=p_integration_id
and inte.ext_application_id=ext.ext_application_id;
savepoint delete_integration;
hr_ki_integrations_bk3.delete_integration_b
(
p_sso_enabled => p_sso_enabled
,p_integration_id => p_integration_id
,p_object_version_number => p_object_version_number
);
(p_module_name => 'delete_integration'
,p_hook_type => 'BP'
);
hr_eap_del.delete_sso_details(p_sso_id => l_extid);
hr_ki_integrations_bk3.delete_integration_a
(
p_sso_enabled => p_sso_enabled
,p_integration_id => p_integration_id
,p_object_version_number => p_object_version_number
);
(p_module_name => 'delete_integration'
,p_hook_type => 'AP'
);
rollback to delete_integration;
rollback to delete_integration;
end delete_integration;