APPS.HR_KI_INTEGRATIONS_API dependencies on HR_KI_EXT_APPLICATIONS

Line 764: hr_ki_ext_applications ext

760: cursor csr_extid is
761: select inte.ext_application_id,ext.external_application_id
762: from
763: hr_ki_integrations inte,
764: hr_ki_ext_applications ext
765: where inte.integration_id=p_integration_id
766: and inte.ext_application_id=ext.ext_application_id;
767:
768: cursor csr_getsso_info is

Line 908: --hr_ki_integrations and hr_ki_ext_applications table

904: end if;
905: if (p_source_type = 'SSO') then
906: --make sure that ext_application_id is valid
907: --and it exists for the integration_id passed in
908: --hr_ki_integrations and hr_ki_ext_applications table
909: open csr_extid;
910: fetch csr_extid into l_ext_application_id,l_extid;
911: if (csr_extid%notfound) then
912: close csr_extid;

Line 1026: -- from hr_ki_ext_applications

1022:
1023: --SSO to URL or SSO to ECX type
1024:
1025: --delete the application from SSO and then
1026: -- from hr_ki_ext_applications
1027:
1028: hr_eap_del.delete_sso_details(p_sso_id => l_extid);
1029:
1030:

Line 1336: hr_ki_ext_applications ext

1332: l_proc varchar2(72) := g_package||'delete_integration';
1333: cursor csr_extid is
1334: select ext.external_application_id,ext.ext_application_id from
1335: hr_ki_integrations inte,
1336: hr_ki_ext_applications ext
1337: where inte.integration_id=p_integration_id
1338: and inte.ext_application_id=ext.ext_application_id;
1339:
1340: l_extid varchar2(80);

Line 1388: -- from hr_ki_ext_applications

1384: end if;
1385: close csr_extid;
1386:
1387: --delete the application from SSO and then
1388: -- from hr_ki_ext_applications
1389:
1390: hr_eap_del.delete_sso_details(p_sso_id => l_extid);
1391:
1392: end if;