APPS.OTA_TDB_API_INS2 SQL Statements

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

Line: 228

  select ocu.online_flag , off.Learning_object_id from ota_category_usages ocu,
    ota_offerings off , ota_events oev
    where ocu.category_usage_id = off.delivery_mode_id
    and off.offering_id = oev.parent_offering_id
    and oev.event_id = p_event_id;

Line: 236

  Select fr.forum_id, fr.business_group_id from
  ota_forums_b fr,
  ota_frm_obj_inclusions foi
  where fr.forum_id = foi.forum_id
  and foi.object_type = 'E'
  and foi.object_id = p_event_id
  and fr.auto_notification_flag = 'Y';

Line: 527

         ota_trng_plan_comp_ss.update_tpc_enroll_status_chg(p_event_id  => p_event_id,
                                                     p_person_id => p_delegate_person_id,
						    -- Added for Bug#3479186
						     p_contact_id => p_delegate_contact_id,
                                                     p_learning_path_ids => l_learning_path_ids);

Line: 534

  ota_lrng_path_member_util.update_lme_enroll_status_chg(p_event_id          => p_event_id,
                                                         p_person_id         => p_delegate_person_id,
                                                         p_contact_id        => p_delegate_contact_id,
                                                         p_lp_enrollment_ids => l_lp_enrollment_ids);

Line: 540

  ota_cme_util.update_cme_status(p_event_id          => p_event_id,
                                 p_person_id         => p_delegate_person_id,
                                 p_contact_id        => p_delegate_contact_id,
                                 p_cert_prd_enrollment_ids => l_cert_prd_enrollment_ids);

Line: 545

         select Type into l_type from ota_booking_status_types where booking_status_type_id=p_booking_status_type_id;

Line: 565

        ota_competence_ss.create_wf_process(p_process 	=>'OTA_COMPETENCE_UPDATE_JSP_PRC',
            p_itemtype 		=>'HRSSA',
            p_person_id 	=> p_delegate_person_id,
            p_eventid       =>p_event_id,
            p_learningpath_ids => null,
            p_itemkey    =>l_item_key);

Line: 575

       /* ota_competence_ss.create_wf_process(p_process 	=>'OTA_COMPETENCE_UPDATE_JSP_PRC',
            p_itemtype 		=>'HRSSA',
            p_person_id 	=> p_delegate_person_id,
            p_eventid       =>p_event_id,
            p_learningpath_ids => null,
            p_itemkey    =>l_item_key);*/