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_LCI_BUS dependencies on OTA_LP_CAT_INCLUSIONS

Line 35: , ota_lp_cat_inclusions lci

31: select pbg.security_group_id,
32: pbg.legislation_code
33: from per_business_groups_perf pbg
34: , ota_category_usages ctu
35: , ota_lp_cat_inclusions lci
36: where ctu.category_usage_id = p_category_usage_id
37: and lci.category_usage_id = ctu.category_usage_id
38: and lci.learning_path_id = p_learning_path_id
39: and pbg.business_group_id = ctu.business_group_id;

Line 117: ,ota_lp_cat_inclusions lci

113: cursor csr_leg_code is
114: select pbg.legislation_code
115: from per_business_groups_perf pbg
116: ,ota_category_usages ctu
117: ,ota_lp_cat_inclusions lci
118: where ctu.category_usage_id = p_category_usage_id
119: and lci.category_usage_id = ctu.category_usage_id
120: and lci.learning_path_id = p_learning_path_id
121: and pbg.business_group_id = ctu.business_group_id;

Line 277: ,p_descflex_name => 'OTA_LP_CAT_INCLUSIONS'

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

Line 523: l_start_date ota_lp_cat_inclusions.start_date_active%TYPE;

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

Line 524: l_end_date ota_lp_cat_inclusions.end_date_active%TYPE;

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

Line 615: from OTA_LP_CAT_inclusions lci

611: v_proc varchar2(72) := g_package||'check_multiple_primary_ctgr';
612: v_exists varchar2(1);
613: cursor sel_multiple_primary is
614: select 'Y'
615: from OTA_LP_CAT_inclusions lci
616: where lci.learning_path_id = p_learning_path_id
617: and lci.primary_flag = 'Y';
618: --
619: Begin

Line 639: p_associated_column1 => 'OTA_LP_CAT_INCLUSIONS.PRIMARY_FLAG')

635: Exception
636: WHEN app_exception.application_exception THEN
637:
638: IF hr_multi_message.exception_add(
639: p_associated_column1 => 'OTA_LP_CAT_INCLUSIONS.PRIMARY_FLAG')
640:
641: THEN
642:
643: hr_utility.set_location(' Leaving:'||v_proc, 22);

Line 669: from OTA_LP_CAT_inclusions lci

665: v_proc varchar2(72) := g_package||'check_if_primary_category';
666: v_exists varchar2(1);
667: cursor sel_primary_category is
668: select 'Y'
669: from OTA_LP_CAT_inclusions lci
670: where lci.learning_path_id = p_learning_path_id
671: and lci.category_usage_id = p_category_usage_id
672: and lci.primary_flag = 'Y';
673: --

Line 693: p_associated_column1 => 'OTA_LP_CAT_INCLUSIONS.PRIMARY_FLAG')

689: Exception
690: WHEN app_exception.application_exception THEN
691:
692: IF hr_multi_message.exception_add(
693: p_associated_column1 => 'OTA_LP_CAT_INCLUSIONS.PRIMARY_FLAG')
694:
695: THEN
696:
697: hr_utility.set_location(' Leaving:'||v_proc, 22);

Line 732: p_associated_column1 => 'OTA_LP_CAT_INCLUSIONS.START_DATE_ACTIVE'

728: Exception
729: WHEN app_exception.application_exception THEN
730:
731: IF hr_multi_message.exception_add(
732: p_associated_column1 => 'OTA_LP_CAT_INCLUSIONS.START_DATE_ACTIVE'
733: ,p_associated_column2 => 'OTA_LP_CAT_INCLUSIONS.END_DATE_ACTIVE')
734: THEN
735:
736: hr_utility.set_location(' Leaving:'||v_proc, 22);

Line 733: ,p_associated_column2 => 'OTA_LP_CAT_INCLUSIONS.END_DATE_ACTIVE')

729: WHEN app_exception.application_exception THEN
730:
731: IF hr_multi_message.exception_add(
732: p_associated_column1 => 'OTA_LP_CAT_INCLUSIONS.START_DATE_ACTIVE'
733: ,p_associated_column2 => 'OTA_LP_CAT_INCLUSIONS.END_DATE_ACTIVE')
734: THEN
735:
736: hr_utility.set_location(' Leaving:'||v_proc, 22);
737: RAISE;

Line 765: from OTA_LP_CAT_inclusions lci

761: v_proc varchar2(72) := g_package||'check_unique_key';
762: --
763: cursor sel_unique_key is
764: select 'Y'
765: from OTA_LP_CAT_inclusions lci
766: where lci.learning_path_id = p_learning_path_id
767: and lci.category_usage_id = p_category_usage_id;
768: --
769: Begin

Line 788: p_associated_column1 => 'OTA_LP_CAT_INCLUSIONS.learning_path_id',

784: Exception
785: WHEN app_exception.application_exception THEN
786:
787: IF hr_multi_message.exception_add(
788: p_associated_column1 => 'OTA_LP_CAT_INCLUSIONS.learning_path_id',
789: p_associated_column2 => 'OTA_LP_CAT_INCLUSIONS.CATEGORY_USAGE_ID')
790: THEN
791: hr_utility.set_location(' Leaving:'||v_proc, 22);
792: RAISE;

Line 789: p_associated_column2 => 'OTA_LP_CAT_INCLUSIONS.CATEGORY_USAGE_ID')

785: WHEN app_exception.application_exception THEN
786:
787: IF hr_multi_message.exception_add(
788: p_associated_column1 => 'OTA_LP_CAT_INCLUSIONS.learning_path_id',
789: p_associated_column2 => 'OTA_LP_CAT_INCLUSIONS.CATEGORY_USAGE_ID')
790: THEN
791: hr_utility.set_location(' Leaving:'||v_proc, 22);
792: RAISE;
793:

Line 846: p_associated_column1 => 'OTA_LP_CAT_INCLUSIONS.START_DATE_ACTIVE'

842: Exception
843: WHEN app_exception.application_exception THEN
844:
845: IF hr_multi_message.exception_add(
846: p_associated_column1 => 'OTA_LP_CAT_INCLUSIONS.START_DATE_ACTIVE'
847: ,p_associated_column2 => 'OTA_LP_CAT_INCLUSIONS.END_DATE_ACTIVE')
848: THEN
849:
850: hr_utility.set_location(' Leaving:'||v_proc, 22);

Line 847: ,p_associated_column2 => 'OTA_LP_CAT_INCLUSIONS.END_DATE_ACTIVE')

843: WHEN app_exception.application_exception THEN
844:
845: IF hr_multi_message.exception_add(
846: p_associated_column1 => 'OTA_LP_CAT_INCLUSIONS.START_DATE_ACTIVE'
847: ,p_associated_column2 => 'OTA_LP_CAT_INCLUSIONS.END_DATE_ACTIVE')
848: THEN
849:
850: hr_utility.set_location(' Leaving:'||v_proc, 22);
851: RAISE;