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_INT_BUS dependencies on HR_KI_INTEGRATIONS

Line 107: from hr_ki_integrations

103: l_proc varchar2(72) := g_package || 'CHK_INTEGRATION_KEY';
104: l_key varchar2(1) ;
105: cursor csr_name is
106: select null
107: from hr_ki_integrations
108: where integration_key = p_integration_key;
109: --
110: Begin
111: hr_utility.set_location('Entering:'||l_proc,10);

Line 136: (p_associated_column1 => 'HR_KI_INTEGRATIONS.INTEGRATION_KEY'

132: hr_utility.set_location(' Leaving:'||l_proc,30);
133: exception
134: when app_exception.application_exception then
135: if hr_multi_message.exception_add
136: (p_associated_column1 => 'HR_KI_INTEGRATIONS.INTEGRATION_KEY'
137: )then
138: hr_utility.set_location(' Leaving:'||l_proc, 40);
139: raise;
140: end if;

Line 190: (p_associated_column1 => 'HR_KI_INTEGRATIONS.SYNCHED'

186: hr_utility.set_location(' Leaving:'||l_proc,30);
187: exception
188: when app_exception.application_exception then
189: if hr_multi_message.exception_add
190: (p_associated_column1 => 'HR_KI_INTEGRATIONS.SYNCHED'
191: )then
192: hr_utility.set_location(' Leaving:'||l_proc, 40);
193: raise;
194: end if;

Line 262: (p_associated_column1 => 'HR_KI_INTEGRATIONS.SYNCHED'

258: hr_utility.set_location(' Leaving:'||l_proc,30);
259: exception
260: when app_exception.application_exception then
261: if hr_multi_message.exception_add
262: (p_associated_column1 => 'HR_KI_INTEGRATIONS.SYNCHED'
263: )then
264: hr_utility.set_location(' Leaving:'||l_proc, 40);
265: raise;
266: end if;

Line 326: from hr_ki_integrations

322: l_key_sso_upd varchar2(1) ;
323:
324: cursor csr_sso is
325: select null
326: from hr_ki_integrations
327: where
328: application_name=p_application_name
329: and application_type=p_application_type
330: and application_url=p_application_url

Line 338: from hr_ki_integrations

334: and authentication_needed=p_authentication_needed;
335:
336: cursor csr_sso_upd is
337: select null
338: from hr_ki_integrations
339: where
340: application_name=p_application_name
341: and application_type=p_application_type
342: and application_url=p_application_url

Line 357: (p_check_column1 => 'HR_KI_INTEGRATIONS.EXT_APPLICATION_ID'

353: -- Multiple Message List does not already contain an errors
354: -- associated with the party_name
355: --
356: if hr_multi_message.no_exclusive_error
357: (p_check_column1 => 'HR_KI_INTEGRATIONS.EXT_APPLICATION_ID'
358: ,p_associated_column1 => 'HR_KI_INTEGRATIONS.EXT_APPLICATION_ID'
359: ) then
360:
361:

Line 358: ,p_associated_column1 => 'HR_KI_INTEGRATIONS.EXT_APPLICATION_ID'

354: -- associated with the party_name
355: --
356: if hr_multi_message.no_exclusive_error
357: (p_check_column1 => 'HR_KI_INTEGRATIONS.EXT_APPLICATION_ID'
358: ,p_associated_column1 => 'HR_KI_INTEGRATIONS.EXT_APPLICATION_ID'
359: ) then
360:
361:
362: --For insert mode ext_application_id must be null

Line 410: --Check if SSO combination already exists in the hr_ki_integrations table.

406: )then
407:
408: hr_utility.set_location('Validating combination'||l_proc,30);
409: --
410: --Check if SSO combination already exists in the hr_ki_integrations table.
411: --
412: if(p_insert ='insert') then
413: open csr_sso;
414: fetch csr_sso into l_key_sso;

Line 440: (p_associated_column1 => 'HR_KI_INTEGRATIONS.EXT_APPLICATION_ID'

436:
437: exception
438: when app_exception.application_exception then
439: if hr_multi_message.exception_add
440: (p_associated_column1 => 'HR_KI_INTEGRATIONS.EXT_APPLICATION_ID'
441: )then
442: hr_utility.set_location(' Leaving:'||l_proc, 40);
443: raise;
444: end if;

Line 454: -- hr_ki_ext_applications and it is not duplicated in hr_ki_integrations

450: -- {Start Of Comments}
451: --
452: -- Description:
453: -- This procedure ensures external application id is present in
454: -- hr_ki_ext_applications and it is not duplicated in hr_ki_integrations
455: -- table.
456: -- If earlier procedure is used for update validation then error will be
457: -- thrown even if id is unique and not null as earlier query
458: -- does not have addtional p_ext_application_id condition in the cursor.

Line 490: from hr_ki_integrations

486: from hr_ki_ext_applications
487: where ext_application_id = p_ext_application_id;
488: cursor csr_app is
489: select null
490: from hr_ki_integrations
491: where ext_application_id = p_ext_application_id
492: and integration_id<>p_integration_id;
493: --
494: Begin

Line 500: (p_check_column1 => 'HR_KI_INTEGRATIONS.EXT_APPLICATION_ID'

496: --
497: -- Check value has been passed
498: --
499: if hr_multi_message.no_exclusive_error
500: (p_check_column1 => 'HR_KI_INTEGRATIONS.EXT_APPLICATION_ID'
501: ,p_associated_column1 => 'HR_KI_INTEGRATIONS.EXT_APPLICATION_ID'
502: ) then
503:
504: if p_ext_application_id is not null then

Line 501: ,p_associated_column1 => 'HR_KI_INTEGRATIONS.EXT_APPLICATION_ID'

497: -- Check value has been passed
498: --
499: if hr_multi_message.no_exclusive_error
500: (p_check_column1 => 'HR_KI_INTEGRATIONS.EXT_APPLICATION_ID'
501: ,p_associated_column1 => 'HR_KI_INTEGRATIONS.EXT_APPLICATION_ID'
502: ) then
503:
504: if p_ext_application_id is not null then
505:

Line 519: --hr_ki_integrations table

515: end if;
516: close csr_name;
517:
518: --Now check if ext_application_id is already present in the
519: --hr_ki_integrations table
520:
521: hr_utility.set_location('Validating ID in Integrations table:'||l_proc,30);
522: open csr_app;
523: fetch csr_app into l_key_app;

Line 539: (p_associated_column1 => 'HR_KI_INTEGRATIONS.EXT_APPLICATION_ID'

535: hr_utility.set_location(' Leaving:'||l_proc,30);
536: exception
537: when app_exception.application_exception then
538: if hr_multi_message.exception_add
539: (p_associated_column1 => 'HR_KI_INTEGRATIONS.EXT_APPLICATION_ID'
540: )then
541: hr_utility.set_location(' Leaving:'||l_proc, 40);
542: raise;
543: end if;

Line 602: from hr_ki_integrations

598: l_key_ecx_upd varchar2(1) ;
599:
600: cursor csr_ecx is
601: select null
602: from hr_ki_integrations
603: where party_type=p_party_type
604: and party_name=p_party_name
605: and party_site_name=p_party_site_name
606: and transaction_type=p_transaction_type

Line 615: from hr_ki_integrations

611: and trans_direction=p_trans_direction;
612:
613: cursor csr_ecx_upd is
614: select null
615: from hr_ki_integrations
616: where party_type=p_party_type
617: and party_name=p_party_name
618: and party_site_name=p_party_site_name
619: and transaction_type=p_transaction_type

Line 635: (p_check_column1 => 'HR_KI_INTEGRATIONS.PARTY_NAME'

631: -- Multiple Message List does not already contain an errors
632: -- associated with the party_name
633: --
634: if hr_multi_message.no_exclusive_error
635: (p_check_column1 => 'HR_KI_INTEGRATIONS.PARTY_NAME'
636: ,p_associated_column1 => 'HR_KI_INTEGRATIONS.PARTY_NAME'
637: ) then
638:
639: --If any ofthe ECX parameters are not null then validate ECX details

Line 636: ,p_associated_column1 => 'HR_KI_INTEGRATIONS.PARTY_NAME'

632: -- associated with the party_name
633: --
634: if hr_multi_message.no_exclusive_error
635: (p_check_column1 => 'HR_KI_INTEGRATIONS.PARTY_NAME'
636: ,p_associated_column1 => 'HR_KI_INTEGRATIONS.PARTY_NAME'
637: ) then
638:
639: --If any ofthe ECX parameters are not null then validate ECX details
640: if ( p_party_type is not null

Line 679: --Check if ECX combination already exists in the hr_ki_integrations table.

675: and p_trans_direction is not null )then
676:
677: hr_utility.set_location('Validating combination'||l_proc,30);
678: --
679: --Check if ECX combination already exists in the hr_ki_integrations table.
680: --
681: --For insert use csr_ecx cursor since integration_id will be null
682: --For update use csr_ecx_upd cursor
683: if p_integration_id is null then

Line 710: (p_associated_column1 => 'HR_KI_INTEGRATIONS.PARTY_NAME'

706:
707: exception
708: when app_exception.application_exception then
709: if hr_multi_message.exception_add
710: (p_associated_column1 => 'HR_KI_INTEGRATIONS.PARTY_NAME'
711: )then
712: hr_utility.set_location(' Leaving:'||l_proc, 40);
713: raise;
714: end if;

Line 915: (p_associated_column1 => 'HR_KI_INTEGRATIONS.URL'

911:
912: exception
913: when app_exception.application_exception then
914: if hr_multi_message.exception_add
915: (p_associated_column1 => 'HR_KI_INTEGRATIONS.URL'
916: ,p_associated_column2 => 'HR_KI_INTEGRATIONS.EXT_APPLICATION_ID'
917: ,p_associated_column3 => 'HR_KI_INTEGRATIONS.PARTY_NAME'
918: )then
919: hr_utility.set_location(' Leaving:'||l_proc, 50);

Line 916: ,p_associated_column2 => 'HR_KI_INTEGRATIONS.EXT_APPLICATION_ID'

912: exception
913: when app_exception.application_exception then
914: if hr_multi_message.exception_add
915: (p_associated_column1 => 'HR_KI_INTEGRATIONS.URL'
916: ,p_associated_column2 => 'HR_KI_INTEGRATIONS.EXT_APPLICATION_ID'
917: ,p_associated_column3 => 'HR_KI_INTEGRATIONS.PARTY_NAME'
918: )then
919: hr_utility.set_location(' Leaving:'||l_proc, 50);
920: raise;

Line 917: ,p_associated_column3 => 'HR_KI_INTEGRATIONS.PARTY_NAME'

913: when app_exception.application_exception then
914: if hr_multi_message.exception_add
915: (p_associated_column1 => 'HR_KI_INTEGRATIONS.URL'
916: ,p_associated_column2 => 'HR_KI_INTEGRATIONS.EXT_APPLICATION_ID'
917: ,p_associated_column3 => 'HR_KI_INTEGRATIONS.PARTY_NAME'
918: )then
919: hr_utility.set_location(' Leaving:'||l_proc, 50);
920: raise;
921: end if;

Line 932: -- rows for a record in hr_ki_integrations. The tables that contain child

928: -- {Start Of Comments}
929: --
930: -- Description:
931: -- This procedure ensures that a delete occurs only if there are no child
932: -- rows for a record in hr_ki_integrations. The tables that contain child
933: -- rows are hr_ki_integrations_tl,hr_ki_topic_integrations,hr_ki_options.
934: -- Pre Conditions:
935: -- g_rec has been populated with details of the values
936: -- from the ins or the upd procedures

Line 933: -- rows are hr_ki_integrations_tl,hr_ki_topic_integrations,hr_ki_options.

929: --
930: -- Description:
931: -- This procedure ensures that a delete occurs only if there are no child
932: -- rows for a record in hr_ki_integrations. The tables that contain child
933: -- rows are hr_ki_integrations_tl,hr_ki_topic_integrations,hr_ki_options.
934: -- Pre Conditions:
935: -- g_rec has been populated with details of the values
936: -- from the ins or the upd procedures
937: --

Line 977: from hr_ki_integrations_tl

973: where integration_id = p_integration_id;
974:
975: cursor csr_maintenance_tl is
976: select null
977: from hr_ki_integrations_tl
978: where integration_id = p_integration_id;
979:
980: cursor csr_maintenance_extapp is
981: select null from hr_ki_integrations inte,hr_ki_ext_applications ext

Line 981: select null from hr_ki_integrations inte,hr_ki_ext_applications ext

977: from hr_ki_integrations_tl
978: where integration_id = p_integration_id;
979:
980: cursor csr_maintenance_extapp is
981: select null from hr_ki_integrations inte,hr_ki_ext_applications ext
982: where inte.integration_id=p_integration_id
983: and inte.ext_application_id=ext.ext_application_id;
984:
985: --

Line 1035: (p_associated_column1 => 'HR_KI_INTEGRATIONS.integration_id'

1031: hr_utility.set_location(' Leaving:'|| l_proc, 40);
1032: exception
1033: when app_exception.application_exception then
1034: if hr_multi_message.exception_add
1035: (p_associated_column1 => 'HR_KI_INTEGRATIONS.integration_id'
1036: ) then
1037: hr_utility.set_location(' Leaving:'|| l_proc, 50);
1038: raise;
1039: end if;