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_OFF_BUS dependencies on OTA_OFFERINGS

Line 31: , ota_offerings off

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , ota_offerings off
32: where off.offering_id = p_offering_id
33: and pbg.business_group_id = off.business_group_id;
34: --
35: -- Declare local variables

Line 101: , ota_offerings off

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , ota_offerings off
102: where off.offering_id = p_offering_id
103: and pbg.business_group_id = off.business_group_id;
104: --
105: -- Declare local variables

Line 278: ,p_descflex_name => 'OTA_OFFERINGS'

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

Line 438: (p_associated_column1 => 'OTA_OFFERINGS.START_DATE'

434: hr_utility.set_location(' Leaving:' || l_proc,10);
435: Exception
436: when app_exception.application_exception then
437: IF hr_multi_message.exception_add
438: (p_associated_column1 => 'OTA_OFFERINGS.START_DATE'
439: ,p_associated_column2 => 'OTA_OFFERINGS.END_DATE'
440: ) THEN
441: hr_utility.set_location(' Leaving:'|| l_proc,20);
442: raise;

Line 439: ,p_associated_column2 => 'OTA_OFFERINGS.END_DATE'

435: Exception
436: when app_exception.application_exception then
437: IF hr_multi_message.exception_add
438: (p_associated_column1 => 'OTA_OFFERINGS.START_DATE'
439: ,p_associated_column2 => 'OTA_OFFERINGS.END_DATE'
440: ) THEN
441: hr_utility.set_location(' Leaving:'|| l_proc,20);
442: raise;
443: END IF;

Line 527: p_associated_column1 => 'OTA_OFFERINGS.START_DATE',

523: Exception
524: WHEN app_exception.application_exception THEN
525:
526: IF hr_multi_message.exception_add(
527: p_associated_column1 => 'OTA_OFFERINGS.START_DATE',
528: p_associated_column2 => 'OTA_OFFERINGS.END_DATE')
529: THEN
530:
531: --hr_utility.set_location(' Leaving:'||v_proc, 22);

Line 528: p_associated_column2 => 'OTA_OFFERINGS.END_DATE')

524: WHEN app_exception.application_exception THEN
525:
526: IF hr_multi_message.exception_add(
527: p_associated_column1 => 'OTA_OFFERINGS.START_DATE',
528: p_associated_column2 => 'OTA_OFFERINGS.END_DATE')
529: THEN
530:
531: --hr_utility.set_location(' Leaving:'||v_proc, 22);
532: RAISE;

Line 607: p_associated_column1 => 'OTA_OFFERINGS.START_DATE',

603: Exception
604: WHEN app_exception.application_exception THEN
605:
606: IF hr_multi_message.exception_add(
607: p_associated_column1 => 'OTA_OFFERINGS.START_DATE',
608: p_associated_column2 => 'OTA_OFFERINGS.END_DATE')
609: THEN
610:
611: --hr_utility.set_location(' Leaving:'||v_proc, 22);

Line 608: p_associated_column2 => 'OTA_OFFERINGS.END_DATE')

604: WHEN app_exception.application_exception THEN
605:
606: IF hr_multi_message.exception_add(
607: p_associated_column1 => 'OTA_OFFERINGS.START_DATE',
608: p_associated_column2 => 'OTA_OFFERINGS.END_DATE')
609: THEN
610:
611: --hr_utility.set_location(' Leaving:'||v_proc, 22);
612: RAISE;

Line 671: (p_associated_column1 => 'OTA_OFFERINGS.COMPETENCY_UPDATE_LEVEL') THEN

667:
668: WHEN app_exception.application_exception THEN
669:
670: IF hr_multi_message.exception_add
671: (p_associated_column1 => 'OTA_OFFERINGS.COMPETENCY_UPDATE_LEVEL') THEN
672:
673: hr_utility.set_location(' Leaving:'||l_proc, 42);
674: RAISE;
675: END IF;

Line 723: p_associated_column1 => 'OTA_OFFERINGS.BUSINESS_GROUP_ID',

719: Exception
720: WHEN app_exception.application_exception THEN
721:
722: IF hr_multi_message.exception_add(
723: p_associated_column1 => 'OTA_OFFERINGS.BUSINESS_GROUP_ID',
724: p_associated_column2 => 'OTA_OFFERINGS.DELIVERY_MODE_ID')
725: THEN
726:
727: --hr_utility.set_location(' Leaving:'||v_proc, 22);

Line 724: p_associated_column2 => 'OTA_OFFERINGS.DELIVERY_MODE_ID')

720: WHEN app_exception.application_exception THEN
721:
722: IF hr_multi_message.exception_add(
723: p_associated_column1 => 'OTA_OFFERINGS.BUSINESS_GROUP_ID',
724: p_associated_column2 => 'OTA_OFFERINGS.DELIVERY_MODE_ID')
725: THEN
726:
727: --hr_utility.set_location(' Leaving:'||v_proc, 22);
728: RAISE;

Line 758: SELECT 1 FROM OTA_OFFERINGS_VL OFF

754: := G_PACKAGE || 'UNIQUE_OFFERING_TITLE';
755: W_TITLE_IS_UNIQUE boolean;
756: --
757: cursor C1 is
758: SELECT 1 FROM OTA_OFFERINGS_VL OFF
759: WHERE OFF.NAME = P_NAME
760: AND OFF.ACTIVITY_VERSION_ID = P_ACTIVITY_VERSION_ID
761: AND OFF.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
762: AND ( OFF.OFFERING_ID <> P_OFFERING_ID or P_OFFERING_ID IS NULL ) ;

Line 802: Procedure check_is_test_selected (p_offering_id IN ota_offerings.offering_id%TYPE,

798: -- Added for Bug 3486188. This procedure throws an error if the show toolbar flag
799: -- or the Exit button for a test learning object is set to No.
800: --
801: --
802: Procedure check_is_test_selected (p_offering_id IN ota_offerings.offering_id%TYPE,
803: p_learning_object_id IN ota_offerings.learning_object_id%TYPE,
804: p_player_toolbar_flag IN ota_offerings.player_toolbar_flag%TYPE,
805: p_player_toolbar_bitset IN ota_offerings.player_toolbar_bitset%TYPE)
806: Is

Line 803: p_learning_object_id IN ota_offerings.learning_object_id%TYPE,

799: -- or the Exit button for a test learning object is set to No.
800: --
801: --
802: Procedure check_is_test_selected (p_offering_id IN ota_offerings.offering_id%TYPE,
803: p_learning_object_id IN ota_offerings.learning_object_id%TYPE,
804: p_player_toolbar_flag IN ota_offerings.player_toolbar_flag%TYPE,
805: p_player_toolbar_bitset IN ota_offerings.player_toolbar_bitset%TYPE)
806: Is
807: l_proc varchar2(72) := g_package||'check_is_test_selected';

Line 804: p_player_toolbar_flag IN ota_offerings.player_toolbar_flag%TYPE,

800: --
801: --
802: Procedure check_is_test_selected (p_offering_id IN ota_offerings.offering_id%TYPE,
803: p_learning_object_id IN ota_offerings.learning_object_id%TYPE,
804: p_player_toolbar_flag IN ota_offerings.player_toolbar_flag%TYPE,
805: p_player_toolbar_bitset IN ota_offerings.player_toolbar_bitset%TYPE)
806: Is
807: l_proc varchar2(72) := g_package||'check_is_test_selected';
808:

Line 805: p_player_toolbar_bitset IN ota_offerings.player_toolbar_bitset%TYPE)

801: --
802: Procedure check_is_test_selected (p_offering_id IN ota_offerings.offering_id%TYPE,
803: p_learning_object_id IN ota_offerings.learning_object_id%TYPE,
804: p_player_toolbar_flag IN ota_offerings.player_toolbar_flag%TYPE,
805: p_player_toolbar_bitset IN ota_offerings.player_toolbar_bitset%TYPE)
806: Is
807: l_proc varchar2(72) := g_package||'check_is_test_selected';
808:
809: CURSOR c_is_test

Line 844: p_associated_column1 => 'OTA_OFFERINGS.PLAYER_TOOLBAR_FLAG',

840: Exception
841: WHEN app_exception.application_exception THEN
842:
843: IF hr_multi_message.exception_add(
844: p_associated_column1 => 'OTA_OFFERINGS.PLAYER_TOOLBAR_FLAG',
845: p_associated_column2 => 'OTA_OFFERINGS.PLAYER_TOOLBAR_BITSET')
846: THEN
847:
848: hr_utility.set_location(' Leaving:'||l_proc, 22);

Line 845: p_associated_column2 => 'OTA_OFFERINGS.PLAYER_TOOLBAR_BITSET')

841: WHEN app_exception.application_exception THEN
842:
843: IF hr_multi_message.exception_add(
844: p_associated_column1 => 'OTA_OFFERINGS.PLAYER_TOOLBAR_FLAG',
845: p_associated_column2 => 'OTA_OFFERINGS.PLAYER_TOOLBAR_BITSET')
846: THEN
847:
848: hr_utility.set_location(' Leaving:'||l_proc, 22);
849: RAISE;

Line 923: p_associated_column1 => 'OTA_OFFERINGS.OWNER_ID')

919: Exception
920: WHEN app_exception.application_exception THEN
921:
922: IF hr_multi_message.exception_add(
923: p_associated_column1 => 'OTA_OFFERINGS.OWNER_ID')
924: THEN
925:
926: --hr_utility.set_location(' Leaving:'||v_proc, 22);
927: RAISE;

Line 940: ,p_activity_version_id in ota_offerings.activity_version_id%TYPE

936: --
937: Procedure chk_dm_online_flag
938: (p_delivery_mode_id in ota_category_usages.category_usage_id%TYPE
939: ,p_learning_object_id in ota_learning_objects.learning_object_id%TYPE
940: ,p_activity_version_id in ota_offerings.activity_version_id%TYPE
941: ) is
942: --
943: -- Declare cursors and local variables
944: --

Line 984: (p_associated_column1 => 'OTA_OFFERINGS.LEARNING_OBJECT_ID'

980: hr_utility.set_location(' Leaving:' || l_proc,10);
981: Exception
982: when app_exception.application_exception then
983: IF hr_multi_message.exception_add
984: (p_associated_column1 => 'OTA_OFFERINGS.LEARNING_OBJECT_ID'
985: ) THEN
986: hr_utility.set_location(' Leaving:'|| l_proc,20);
987: raise;
988: END IF;

Line 1035: p_associated_column1 => 'OTA_OFFERINGS.MAXIMUM_ATTENDEES'

1031: Exception
1032: WHEN app_exception.application_exception THEN
1033:
1034: IF hr_multi_message.exception_add(
1035: p_associated_column1 => 'OTA_OFFERINGS.MAXIMUM_ATTENDEES'
1036: ,p_associated_column2 => 'OTA_OFFERINGS.MAXIMUM_INTERNAL_ATTENDEES'
1037: ,p_associated_column3 => 'OTA_OFFERINGS.MINIMUM_ATTENDEES')
1038: THEN
1039:

Line 1036: ,p_associated_column2 => 'OTA_OFFERINGS.MAXIMUM_INTERNAL_ATTENDEES'

1032: WHEN app_exception.application_exception THEN
1033:
1034: IF hr_multi_message.exception_add(
1035: p_associated_column1 => 'OTA_OFFERINGS.MAXIMUM_ATTENDEES'
1036: ,p_associated_column2 => 'OTA_OFFERINGS.MAXIMUM_INTERNAL_ATTENDEES'
1037: ,p_associated_column3 => 'OTA_OFFERINGS.MINIMUM_ATTENDEES')
1038: THEN
1039:
1040: --hr_utility.set_location(' Leaving:'||v_proc, 22);

Line 1037: ,p_associated_column3 => 'OTA_OFFERINGS.MINIMUM_ATTENDEES')

1033:
1034: IF hr_multi_message.exception_add(
1035: p_associated_column1 => 'OTA_OFFERINGS.MAXIMUM_ATTENDEES'
1036: ,p_associated_column2 => 'OTA_OFFERINGS.MAXIMUM_INTERNAL_ATTENDEES'
1037: ,p_associated_column3 => 'OTA_OFFERINGS.MINIMUM_ATTENDEES')
1038: THEN
1039:
1040: --hr_utility.set_location(' Leaving:'||v_proc, 22);
1041: RAISE;

Line 1065: p_associated_column1 => 'OTA_OFFERINGS.DURATION'

1061: Exception
1062: WHEN app_exception.application_exception THEN
1063:
1064: IF hr_multi_message.exception_add(
1065: p_associated_column1 => 'OTA_OFFERINGS.DURATION'
1066: ,p_associated_column2 => 'OTA_OFFERINGS.DURATION_UNITS')
1067: THEN
1068:
1069: --hr_utility.set_location(' Leaving:'||v_proc, 22);

Line 1066: ,p_associated_column2 => 'OTA_OFFERINGS.DURATION_UNITS')

1062: WHEN app_exception.application_exception THEN
1063:
1064: IF hr_multi_message.exception_add(
1065: p_associated_column1 => 'OTA_OFFERINGS.DURATION'
1066: ,p_associated_column2 => 'OTA_OFFERINGS.DURATION_UNITS')
1067: THEN
1068:
1069: --hr_utility.set_location(' Leaving:'||v_proc, 22);
1070: RAISE;

Line 1106: p_associated_column1 => 'OTA_OFFERINGS.ACTUAL_COST'

1102: Exception
1103: WHEN app_exception.application_exception THEN
1104:
1105: IF hr_multi_message.exception_add(
1106: p_associated_column1 => 'OTA_OFFERINGS.ACTUAL_COST'
1107: ,p_associated_column2 => 'OTA_OFFERINGS.BUDGET_COST'
1108: ,p_associated_column3 => 'OTA_OFFERINGS.STANDARD_PRICE')
1109: THEN
1110:

Line 1107: ,p_associated_column2 => 'OTA_OFFERINGS.BUDGET_COST'

1103: WHEN app_exception.application_exception THEN
1104:
1105: IF hr_multi_message.exception_add(
1106: p_associated_column1 => 'OTA_OFFERINGS.ACTUAL_COST'
1107: ,p_associated_column2 => 'OTA_OFFERINGS.BUDGET_COST'
1108: ,p_associated_column3 => 'OTA_OFFERINGS.STANDARD_PRICE')
1109: THEN
1110:
1111: --hr_utility.set_location(' Leaving:'||v_proc, 22);

Line 1108: ,p_associated_column3 => 'OTA_OFFERINGS.STANDARD_PRICE')

1104:
1105: IF hr_multi_message.exception_add(
1106: p_associated_column1 => 'OTA_OFFERINGS.ACTUAL_COST'
1107: ,p_associated_column2 => 'OTA_OFFERINGS.BUDGET_COST'
1108: ,p_associated_column3 => 'OTA_OFFERINGS.STANDARD_PRICE')
1109: THEN
1110:
1111: --hr_utility.set_location(' Leaving:'||v_proc, 22);
1112: RAISE;

Line 1136: (p_associated_column1 => 'OTA_OFFERINGS.VENDOR_ID'

1132: --
1133: exception
1134: when app_exception.application_exception then
1135: if hr_multi_message.exception_add
1136: (p_associated_column1 => 'OTA_OFFERINGS.VENDOR_ID'
1137: ) then
1138: hr_utility.set_location(' Leaving:'|| v_proc,70);
1139: raise;
1140: end if;

Line 1148: (p_delivery_mode_id in ota_offerings.delivery_mode_id%TYPE

1144: -- ----------------------------------------------------------------------------
1145: -- |-----------------------< Chk_Inventory_Course >---------------------------|
1146: -- ----------------------------------------------------------------------------
1147: Procedure Chk_Inventory_Course
1148: (p_delivery_mode_id in ota_offerings.delivery_mode_id%TYPE
1149: ,p_activity_version_id in ota_offerings.activity_version_id%TYPE
1150: ) is
1151: --
1152: -- Declare cursors and local variables

Line 1149: ,p_activity_version_id in ota_offerings.activity_version_id%TYPE

1145: -- |-----------------------< Chk_Inventory_Course >---------------------------|
1146: -- ----------------------------------------------------------------------------
1147: Procedure Chk_Inventory_Course
1148: (p_delivery_mode_id in ota_offerings.delivery_mode_id%TYPE
1149: ,p_activity_version_id in ota_offerings.activity_version_id%TYPE
1150: ) is
1151: --
1152: -- Declare cursors and local variables
1153: --

Line 1197: (p_associated_column1 => 'OTA_OFFERINGS.DELIVERY_MODE_ID'

1193: Exception
1194: When app_exception.application_exception Then
1195: --
1196: If hr_multi_message.exception_add
1197: (p_associated_column1 => 'OTA_OFFERINGS.DELIVERY_MODE_ID'
1198: ) Then
1199: --
1200: hr_utility.set_location(' Leaving:'|| l_proc,20);
1201: raise;