APPS.JTF_IH_IEC_PVT SQL Statements

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

Line: 44

  l_ao_update_pending_perf  VARCHAR2(1);

Line: 54

   l_ao_update_pending_perf  := 'Y';

Line: 65

      SELECT JTF_IH_MEDIA_ITEMS_S1.NextVal into l_media_id FROM dual;

Line: 68

      INSERT INTO jtf_ih_media_items
      (
         CREATED_BY,
         CREATION_DATE,
         LAST_UPDATED_BY,
         LAST_UPDATE_DATE,
         LAST_UPDATE_LOGIN,
         MEDIA_ID,
         DURATION,
         DIRECTION,
         --END_DATE_TIME,
         SOURCE_ITEM_CREATE_DATE_TIME,
         SOURCE_ITEM_ID,
         START_DATE_TIME,
         SOURCE_ID,
         MEDIA_ITEM_TYPE,
         MEDIA_ITEM_REF,
         MEDIA_DATA,
         MEDIA_ABANDON_FLAG,
         MEDIA_TRANSFERRED_FLAG,
         ACTIVE,
         SERVER_GROUP_ID,
         DNIS,
         ANI,
         CLASSIFICATION,
         -- Enh# 3491849
         AO_UPDATE_PENDING,
         SOFT_CLOSED
      )
      VALUES
      (
         l_user_id,
         Sysdate,
         l_user_id,
         Sysdate,
         l_login_id,
         l_media_id,
         l_duration_perf,
         l_direction_perf,
         --Sysdate,
         NULL,
         NULL,
         Sysdate,
         NULL,
         l_media_item_type_perf,
         NULL,
         NULL,
         NULL,
         NULL,
         l_active_perf,
         NULL,
         NULL,
         NULL,
         NULL,
         l_ao_update_pending_perf,
         l_soft_closed_perf
      );

Line: 131

   l_media_id_stmt := 'Select ';

Line: 156

      raise_application_error( -20000, 'Error Inserting Media Item. - Get IDS Failed',TRUE);

Line: 182

   l_ao_update_pending VARCHAR2(1);

Line: 192

   l_ao_update_pending_perf VARCHAR2(1);

Line: 197

   l_ao_update_pending_perf := 'N';

Line: 205

   SELECT ao_update_pending, soft_closed, start_date_time, end_date_time
     INTO l_ao_update_pending, l_soft_closed, l_start_date_time, l_end_date_time
   FROM JTF_IH_MEDIA_ITEMS WHERE Media_Id = p_Media_id;

Line: 234

   UPDATE jtf_ih_media_items SET ao_update_pending = l_ao_update_pending_perf
      WHERE Media_ID = p_Media_id;

Line: 255

      JTF_IH_PUB.update_mediaitem(
         p_api_version => 1.0,
         p_init_msg_list => FND_API.G_TRUE,
         p_commit => l_Commit,
         p_resp_appl_id => fnd_global.resp_appl_id,
         p_resp_id => fnd_global.resp_id,
         p_user_id => fnd_global.user_id,
         p_login_id => fnd_global.login_id,
         x_return_status => x_return_status,
         x_msg_count => x_msg_count,
         x_msg_data => x_msg_data,
         p_media_rec => p_Media
      );