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.OTA_ACI_BUS dependencies on OTA_ACT_CAT_INCLUSIONS

Line 34: , ota_act_cat_inclusions aci

30: cursor csr_sec_grp is
31: select pbg.security_group_id,
32: pbg.legislation_code
33: from per_business_groups_perf pbg
34: , ota_act_cat_inclusions aci
35: , ota_category_usages ctu
36: where aci.activity_version_id = p_activity_version_id
37: and aci.category_usage_id = p_category_usage_id
38: and pbg.business_group_id = ctu.business_group_id

Line 115: , ota_act_cat_inclusions aci

111: --
112: cursor csr_leg_code is
113: select pbg.legislation_code
114: from per_business_groups_perf pbg
115: , ota_act_cat_inclusions aci
116: , ota_category_usages ctu
117: where aci.activity_version_id = p_activity_version_id
118: and aci.category_usage_id = p_category_usage_id
119: and pbg.business_group_id = ctu.business_group_id

Line 279: ,p_descflex_name => 'OTA_ACT_CAT_INCLUSIONS'

275: -- b) During insert.
276: --
277: hr_dflex_utility.ins_or_upd_descflex_attribs
278: (p_appl_short_name => 'OTA'
279: ,p_descflex_name => 'OTA_ACT_CAT_INCLUSIONS'
280: ,p_attribute_category => p_rec.aci_information_category
281: ,p_attribute1_name => 'ACI_INFORMATION1'
282: ,p_attribute1_value => p_rec.aci_information1
283: ,p_attribute2_name => 'ACI_INFORMATION2'

Line 518: from ota_act_cat_inclusions aci

514: v_proc varchar2(72) := g_package||'check_multiple_primary_ctgr';
515: v_exists varchar2(1);
516: cursor sel_multiple_primary is
517: select 'Y'
518: from ota_act_cat_inclusions aci
519: where aci.activity_version_id = p_activity_version_id
520: and aci.primary_flag = 'Y';
521: --
522: Begin

Line 559: from ota_act_cat_inclusions aci

555: v_proc varchar2(72) := g_package||'check_if_primary_category';
556: v_exists varchar2(1);
557: cursor sel_primary_category is
558: select 'Y'
559: from ota_act_cat_inclusions aci
560: where aci.activity_version_id = p_activity_version_id
561: and aci.category_usage_id = p_category_usage_id
562: and aci.primary_flag = 'Y';
563: --

Line 583: p_associated_column1 => 'OTA_ACT_CAT_INCLUSIONS.PRIMARY_FLAG')

579: Exception
580: WHEN app_exception.application_exception THEN
581:
582: IF hr_multi_message.exception_add(
583: p_associated_column1 => 'OTA_ACT_CAT_INCLUSIONS.PRIMARY_FLAG')
584:
585: THEN
586:
587: hr_utility.set_location(' Leaving:'||v_proc, 22);

Line 622: p_associated_column1 => 'OTA_ACT_CAT_INCLUSIONS.START_DATE_ACTIVE'

618: Exception
619: WHEN app_exception.application_exception THEN
620:
621: IF hr_multi_message.exception_add(
622: p_associated_column1 => 'OTA_ACT_CAT_INCLUSIONS.START_DATE_ACTIVE'
623: ,p_associated_column2 => 'OTA_ACT_CAT_INCLUSIONS.END_DATE_ACTIVE')
624: THEN
625:
626: hr_utility.set_location(' Leaving:'||v_proc, 22);

Line 623: ,p_associated_column2 => 'OTA_ACT_CAT_INCLUSIONS.END_DATE_ACTIVE')

619: WHEN app_exception.application_exception THEN
620:
621: IF hr_multi_message.exception_add(
622: p_associated_column1 => 'OTA_ACT_CAT_INCLUSIONS.START_DATE_ACTIVE'
623: ,p_associated_column2 => 'OTA_ACT_CAT_INCLUSIONS.END_DATE_ACTIVE')
624: THEN
625:
626: hr_utility.set_location(' Leaving:'||v_proc, 22);
627: RAISE;

Line 740: p_associated_column1 => 'OTA_ACT_CAT_INCLUSIONS.START_DATE_ACTIVE'

736: Exception
737: WHEN app_exception.application_exception THEN
738:
739: IF hr_multi_message.exception_add(
740: p_associated_column1 => 'OTA_ACT_CAT_INCLUSIONS.START_DATE_ACTIVE'
741: ,p_associated_column2 => 'OTA_ACT_CAT_INCLUSIONS.END_DATE_ACTIVE')
742: THEN
743:
744: hr_utility.set_location(' Leaving:'||v_proc, 22);

Line 741: ,p_associated_column2 => 'OTA_ACT_CAT_INCLUSIONS.END_DATE_ACTIVE')

737: WHEN app_exception.application_exception THEN
738:
739: IF hr_multi_message.exception_add(
740: p_associated_column1 => 'OTA_ACT_CAT_INCLUSIONS.START_DATE_ACTIVE'
741: ,p_associated_column2 => 'OTA_ACT_CAT_INCLUSIONS.END_DATE_ACTIVE')
742: THEN
743:
744: hr_utility.set_location(' Leaving:'||v_proc, 22);
745: RAISE;

Line 860: p_associated_column1 => 'OTA_ACT_CAT_INCLUSIONS.START_DATE_ACTIVE'

856: Exception
857: WHEN app_exception.application_exception THEN
858:
859: IF hr_multi_message.exception_add(
860: p_associated_column1 => 'OTA_ACT_CAT_INCLUSIONS.START_DATE_ACTIVE'
861: ,p_associated_column2 => 'OTA_ACT_CAT_INCLUSIONS.END_DATE_ACTIVE')
862: THEN
863:
864: hr_utility.set_location(' Leaving:'||v_proc, 22);

Line 861: ,p_associated_column2 => 'OTA_ACT_CAT_INCLUSIONS.END_DATE_ACTIVE')

857: WHEN app_exception.application_exception THEN
858:
859: IF hr_multi_message.exception_add(
860: p_associated_column1 => 'OTA_ACT_CAT_INCLUSIONS.START_DATE_ACTIVE'
861: ,p_associated_column2 => 'OTA_ACT_CAT_INCLUSIONS.END_DATE_ACTIVE')
862: THEN
863:
864: hr_utility.set_location(' Leaving:'||v_proc, 22);
865: RAISE;

Line 893: from ota_act_cat_inclusions aci

889: v_proc varchar2(72) := g_package||'check_unique_key';
890: --
891: cursor sel_unique_key is
892: select 'Y'
893: from ota_act_cat_inclusions aci
894: where aci.activity_version_id = p_activity_version_id
895: and aci.category_usage_id = p_category_usage_id;
896: --
897: Begin

Line 916: p_associated_column1 => 'OTA_ACT_CAT_INCLUSIONS.ACTIVITY_VERSION_ID',

912: Exception
913: WHEN app_exception.application_exception THEN
914:
915: IF hr_multi_message.exception_add(
916: p_associated_column1 => 'OTA_ACT_CAT_INCLUSIONS.ACTIVITY_VERSION_ID',
917: p_associated_column2 => 'OTA_ACT_CAT_INCLUSIONS.CATEGORY_USAGE_ID')
918: THEN
919: hr_utility.set_location(' Leaving:'||v_proc, 22);
920: RAISE;

Line 917: p_associated_column2 => 'OTA_ACT_CAT_INCLUSIONS.CATEGORY_USAGE_ID')

913: WHEN app_exception.application_exception THEN
914:
915: IF hr_multi_message.exception_add(
916: p_associated_column1 => 'OTA_ACT_CAT_INCLUSIONS.ACTIVITY_VERSION_ID',
917: p_associated_column2 => 'OTA_ACT_CAT_INCLUSIONS.CATEGORY_USAGE_ID')
918: THEN
919: hr_utility.set_location(' Leaving:'||v_proc, 22);
920: RAISE;
921: