1: Package Body HR_KI_INTEGRATIONS_API as
2: /* $Header: hrintapi.pkb 115.1 2004/01/28 23:31:04 vkarandi noship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: hrintapi.pkb 115.1 2004/01/28 23:31:04 vkarandi noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'HR_KI_INTEGRATIONS_API';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |--------------------------< CREATE_INTEGRATION >--------------------------|
10: -- ----------------------------------------------------------------------------
79: --
80: -- Call Before Process User Hook
81: --
82: begin
83: hr_ki_integrations_bk1.create_integration_b
84: (
85: p_language_code => l_language_code
86: ,p_integration_key => p_integration_key
87: ,p_party_type => p_party_type
191: --
192: -- Call After Process User Hook
193: --
194: begin
195: hr_ki_integrations_bk1.create_integration_a
196: (
197: p_language_code => l_language_code
198: ,p_integration_key => p_integration_key
199: ,p_party_type => p_party_type
371: ,FIELD_VALUE8
372: ,FIELD_NAME9
373: ,FIELD_VALUE9
374:
375: from hr_ki_integrations
376: where integration_id = p_integration_id
377: and object_version_number = p_object_version_number;
378:
379: l_synched varchar2(1);
432: --
433: -- Call Before Process User Hook
434: --
435: begin
436: hr_ki_integrations_bk4.validate_integration_b
437: (
438: p_integration_id => p_integration_id
439: ,p_object_version_number => p_object_version_number
440: );
560: and l_logout_url is not null and l_userfld is not null and
561: l_pwdfld is not null and l_authused is not null
562: ) then
563:
564: HR_KI_INTEGRATIONS_API.update_integration
565: (
566: p_source_type => 'SSO'
567: ,p_target_type => 'SSO'
568: ,p_integration_id => p_integration_id
638: --
639: -- Call After Process User Hook
640: --
641: begin
642: hr_ki_integrations_bk4.validate_integration_a
643: (
644: p_integration_id => p_integration_id
645: ,p_ext_application_id => l_ext_application_id
646: ,p_object_version_number => p_object_version_number
759:
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:
772: FIELD_VALUE3,FIELD_NAME4,FIELD_VALUE4,FIELD_NAME5,FIELD_VALUE5,
773: FIELD_NAME6,FIELD_VALUE6,FIELD_NAME7,FIELD_VALUE7,FIELD_NAME8,
774: FIELD_VALUE8,FIELD_NAME9 ,FIELD_VALUE9
775: from
776: hr_ki_integrations
777: where integration_id=p_integration_id;
778:
779:
780: l_extid varchar2(80);
838: --
839: -- Call Before Process User Hook
840: --
841: begin
842: hr_ki_integrations_bk2.UPDATE_INTEGRATION_b
843: (
844: p_language_code => l_language_code
845: ,p_source_type => p_source_type
846: ,p_target_type => p_target_type
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;
1213: --
1214: -- Call After Process User Hook
1215: --
1216: begin
1217: hr_ki_integrations_bk2.update_integration_a
1218: (
1219: p_language_code => l_language_code
1220: ,p_source_type => p_source_type
1221: ,p_target_type => p_target_type
1331: --
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:
1353:
1354: -- Call Before Process User Hook
1355: --
1356: begin
1357: hr_ki_integrations_bk3.delete_integration_b
1358: (
1359: p_sso_enabled => p_sso_enabled
1360: ,p_integration_id => p_integration_id
1361: ,p_object_version_number => p_object_version_number
1412: --
1413: -- Call After Process User Hook
1414: --
1415: begin
1416: hr_ki_integrations_bk3.delete_integration_a
1417: (
1418: p_sso_enabled => p_sso_enabled
1419: ,p_integration_id => p_integration_id
1420: ,p_object_version_number => p_object_version_number
1463: --
1464: hr_utility.set_location(' Leaving:'||l_proc, 90);
1465: raise;
1466: end delete_integration;
1467: end HR_KI_INTEGRATIONS_API;