APPS.OTA_OFF_BUS dependencies on OTA_CATEGORY_USAGES

Line 400: ota_category_usages ctu

396: select
397: ctu.start_date_active,
398: ctu.end_date_active
399: from
400: ota_category_usages ctu
401: where
402: ctu.category_usage_id = p_delivery_mode_id;
403: --
404: -- Variables for API Boolean parameters

Line 938: (p_delivery_mode_id in ota_category_usages.category_usage_id%TYPE

934: -- |----------------------< chk_dm_online_flag >-------------------------------|
935: -- ----------------------------------------------------------------------------
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: --

Line 951: ota_category_usages ctu

947: CURSOR cur_dm_online_flag is
948: select
949: ctu.online_flag
950: from
951: ota_category_usages ctu
952: where
953: ctu.category_usage_id = p_delivery_mode_id;
954: --
955: -- Variables for API Boolean parameters

Line 957: v_online_flag ota_category_usages.online_flag%TYPE;

953: ctu.category_usage_id = p_delivery_mode_id;
954: --
955: -- Variables for API Boolean parameters
956: l_proc varchar2(72) := g_package ||'chk_dm_online_flag';
957: v_online_flag ota_category_usages.online_flag%TYPE;
958: l_iln_rco_id varchar2(50);
959:
960: Begin
961: hr_utility.set_location(' Entering:' || l_proc,10);

Line 1161: ota_category_usages dm

1157: CURSOR Cur_Inventory_Course is
1158: select
1159: 'found'
1160: From
1161: ota_category_usages dm
1162: where
1163: dm.category_usage_id = p_delivery_mode_id
1164: and (dm.online_flag <> 'N' or dm.synchronous_flag <> 'Y')
1165: and exists