APPS.OTA_ADMIN_ACCESS_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 14

Select  category_usage_id
From ota_act_cat_inclusions
Where activity_version_id=p_activity_version_id
And primary_flag='Y';

Line: 20

Select  category_usage_id
From ota_cert_cat_inclusions
Where certification_id=p_object_id
And primary_flag='Y';

Line: 26

Select  category_usage_id
From ota_lp_cat_inclusions
Where learning_path_id=p_object_id
And primary_flag='Y';

Line: 32

Select  object_id
From ota_frm_obj_inclusions
Where forum_id=p_object_id
And primary_flag='Y';

Line: 38

Select  object_id
From ota_chat_obj_inclusions
Where chat_id=p_object_id
And primary_flag='Y';

Line: 44

Select  activity_version_id
From ota_events
where event_id=p_object_id;

Line: 49

Select  activity_version_id
From ota_offerings
where offering_id=p_object_id;

Line: 150

Select user_group_id
from ota_lo_folders
where folder_id=p_object_id;

Line: 155

select user_group_id
from
ota_lo_folders lof,
ota_learning_objects lo
where
lo.learning_object_id=p_object_id
and lo.folder_id=lof.folder_id;

Line: 374

Select  parent_cat_usage_id
From ota_category_usages
Where category_usage_id=p_category_id;

Line: 435

function disable_select(p_object_type in varchar2,
                                           p_object_id in NUMBER,
                                           p_dest_object_type in varchar2,
                                           p_dest_object_id in NUMBER,
                                           p_action in varchar2 default 'Copy' ) return varchar2 is
l_destAdminGrpId number;

Line: 482

end disable_select;

Line: 518

Select  parent_folder_id
From ota_lo_folders
Where folder_id=p_folder_id;

Line: 586

function disable_content_obj_select(p_object_type in varchar2,
                                           p_object_id in NUMBER,
                                           p_dest_obj_type in varchar2,
                                           p_dest_obj_id in NUMBER
                                           ) return varchar2 is
l_destAdminGrpId number;

Line: 616

end disable_content_obj_select;

Line: 718

  Select folder_id
  from ota_question_banks
  where question_bank_id=p_qbank_id;

Line: 826

    SELECT count(*)
    FROM   ota_offerings
    WHERE  learning_object_id = p_learning_object_id
    and admin_can_access_object('O',offering_id)='Y';

Line: 847

  select object_type,object_id
  from ota_chat_obj_inclusions
  where chat_id=p_chat_id
  and primary_flag='Y';

Line: 876

  select object_type,object_id
  from ota_chat_obj_inclusions
  where chat_id=p_forum_id
    and primary_flag='Y';*/

Line: 882

  select object_type,object_id
  from ota_frm_obj_inclusions
  where forum_id=p_forum_id
    and primary_flag='Y';