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_CCI_BUS dependencies on OTA_CERT_CAT_INCLUSIONS

Line 34: , ota_cert_cat_inclusions cci

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_cert_cat_inclusions cci
35: , ota_category_usages ctu
36: where ctu.category_usage_id = p_category_usage_id
37: and cci.category_usage_id = ctu.category_usage_id
38: and cci.certification_id = p_certification_id

Line 115: , ota_cert_cat_inclusions cci

111: --
112: cursor csr_leg_code is
113: select pbg.legislation_code
114: from per_business_groups_perf pbg
115: , ota_cert_cat_inclusions cci
116: , ota_category_usages ctu
117: where ctu.category_usage_id = p_category_usage_id
118: and cci.category_usage_id = ctu.category_usage_id
119: and cci.certification_id = p_certification_id

Line 276: ,p_descflex_name => 'OTA_CERT_CAT_INCLUSIONS'

272: -- b) During insert.
273: --
274: hr_dflex_utility.ins_or_upd_descflex_attribs
275: (p_appl_short_name => 'OTA'
276: ,p_descflex_name => 'OTA_CERT_CAT_INCLUSIONS'
277: ,p_attribute_category => p_rec.attribute_category
278: ,p_attribute1_name => 'ATTRIBUTE1'
279: ,p_attribute1_value => p_rec.attribute1
280: ,p_attribute2_name => 'ATTRIBUTE2'

Line 522: l_start_date ota_cert_cat_inclusions.start_date_active%TYPE;

518: l_start_date_changed boolean := ota_general.value_changed(ota_cci_shd.g_old_rec.start_date_active
519: ,p_rec.start_date_active);
520: l_end_date_changed boolean := ota_general.value_changed(ota_cci_shd.g_old_rec.end_date_active
521: ,p_rec.end_date_active );
522: l_start_date ota_cert_cat_inclusions.start_date_active%TYPE;
523: l_end_date ota_cert_cat_inclusions.end_date_active%TYPE;
524: --
525: --
526: Begin

Line 523: l_end_date ota_cert_cat_inclusions.end_date_active%TYPE;

519: ,p_rec.start_date_active);
520: l_end_date_changed boolean := ota_general.value_changed(ota_cci_shd.g_old_rec.end_date_active
521: ,p_rec.end_date_active );
522: l_start_date ota_cert_cat_inclusions.start_date_active%TYPE;
523: l_end_date ota_cert_cat_inclusions.end_date_active%TYPE;
524: --
525: --
526: Begin
527: hr_utility.set_location('Entering:'||l_proc, 5);

Line 608: from OTA_CERT_CAT_inclusions cci

604: v_proc varchar2(72) := g_package||'check_multiple_primary_ctgr';
605: v_exists varchar2(1);
606: cursor sel_multiple_primary is
607: select 'Y'
608: from OTA_CERT_CAT_inclusions cci
609: where cci.certification_id = p_certification_id
610: and cci.primary_flag = 'Y';
611: --
612: Begin

Line 632: p_associated_column1 => 'OTA_CERT_CAT_INCLUSIONS.PRIMARY_FLAG')

628: Exception
629: WHEN app_exception.application_exception THEN
630:
631: IF hr_multi_message.exception_add(
632: p_associated_column1 => 'OTA_CERT_CAT_INCLUSIONS.PRIMARY_FLAG')
633:
634: THEN
635:
636: hr_utility.set_location(' Leaving:'||v_proc, 22);

Line 661: from OTA_CERT_CAT_inclusions cci

657: v_proc varchar2(72) := g_package||'check_if_primary_category';
658: v_exists varchar2(1);
659: cursor sel_primary_category is
660: select 'Y'
661: from OTA_CERT_CAT_inclusions cci
662: where cci.certification_id = p_certification_id
663: and cci.category_usage_id = p_category_usage_id
664: and cci.primary_flag = 'Y';
665: --

Line 685: p_associated_column1 => 'OTA_CERT_CAT_INCLUSIONS.PRIMARY_FLAG')

681: Exception
682: WHEN app_exception.application_exception THEN
683:
684: IF hr_multi_message.exception_add(
685: p_associated_column1 => 'OTA_CERT_CAT_INCLUSIONS.PRIMARY_FLAG')
686:
687: THEN
688:
689: hr_utility.set_location(' Leaving:'||v_proc, 22);

Line 725: p_associated_column1 => 'OTA_CERT_CAT_INCLUSIONS.START_DATE_ACTIVE'

721: Exception
722: WHEN app_exception.application_exception THEN
723:
724: IF hr_multi_message.exception_add(
725: p_associated_column1 => 'OTA_CERT_CAT_INCLUSIONS.START_DATE_ACTIVE'
726: ,p_associated_column2 => 'OTA_CERT_CAT_INCLUSIONS.END_DATE_ACTIVE')
727: THEN
728:
729: hr_utility.set_location(' Leaving:'||v_proc, 22);

Line 726: ,p_associated_column2 => 'OTA_CERT_CAT_INCLUSIONS.END_DATE_ACTIVE')

722: WHEN app_exception.application_exception THEN
723:
724: IF hr_multi_message.exception_add(
725: p_associated_column1 => 'OTA_CERT_CAT_INCLUSIONS.START_DATE_ACTIVE'
726: ,p_associated_column2 => 'OTA_CERT_CAT_INCLUSIONS.END_DATE_ACTIVE')
727: THEN
728:
729: hr_utility.set_location(' Leaving:'||v_proc, 22);
730: RAISE;

Line 759: from OTA_CERT_CAT_inclusions cci

755: v_proc varchar2(72) := g_package||'check_unique_key';
756: --
757: cursor sel_unique_key is
758: select 'Y'
759: from OTA_CERT_CAT_inclusions cci
760: where cci.certification_id = p_certification_id
761: and cci.category_usage_id = p_category_usage_id;
762: --
763: Begin

Line 782: p_associated_column1 => 'OTA_CERT_CAT_INCLUSIONS.certification_id',

778: Exception
779: WHEN app_exception.application_exception THEN
780:
781: IF hr_multi_message.exception_add(
782: p_associated_column1 => 'OTA_CERT_CAT_INCLUSIONS.certification_id',
783: p_associated_column2 => 'OTA_CERT_CAT_INCLUSIONS.CATEGORY_USAGE_ID')
784: THEN
785: hr_utility.set_location(' Leaving:'||v_proc, 22);
786: RAISE;

Line 783: p_associated_column2 => 'OTA_CERT_CAT_INCLUSIONS.CATEGORY_USAGE_ID')

779: WHEN app_exception.application_exception THEN
780:
781: IF hr_multi_message.exception_add(
782: p_associated_column1 => 'OTA_CERT_CAT_INCLUSIONS.certification_id',
783: p_associated_column2 => 'OTA_CERT_CAT_INCLUSIONS.CATEGORY_USAGE_ID')
784: THEN
785: hr_utility.set_location(' Leaving:'||v_proc, 22);
786: RAISE;
787:

Line 840: p_associated_column1 => 'OTA_CERT_CAT_INCLUSIONS.START_DATE_ACTIVE'

836: Exception
837: WHEN app_exception.application_exception THEN
838:
839: IF hr_multi_message.exception_add(
840: p_associated_column1 => 'OTA_CERT_CAT_INCLUSIONS.START_DATE_ACTIVE'
841: ,p_associated_column2 => 'OTA_CERT_CAT_INCLUSIONS.END_DATE_ACTIVE')
842: THEN
843:
844: hr_utility.set_location(' Leaving:'||v_proc, 22);

Line 841: ,p_associated_column2 => 'OTA_CERT_CAT_INCLUSIONS.END_DATE_ACTIVE')

837: WHEN app_exception.application_exception THEN
838:
839: IF hr_multi_message.exception_add(
840: p_associated_column1 => 'OTA_CERT_CAT_INCLUSIONS.START_DATE_ACTIVE'
841: ,p_associated_column2 => 'OTA_CERT_CAT_INCLUSIONS.END_DATE_ACTIVE')
842: THEN
843:
844: hr_utility.set_location(' Leaving:'||v_proc, 22);
845: RAISE;