APPS.OTA_TIMEZONE_UPGRADE SQL Statements

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

Line: 28

  SELECT timezone_code
  FROM hr_locations
  WHERE location_id = loc_id;

Line: 54

  SELECT fpi.status
  FROM fnd_product_installations fpi
  WHERE fpi.application_id = ota_application_id;

Line: 88

    SELECT location_id,
      training_center_id
    INTO l_location_id,
      l_trng_center_id
    FROM ota_suppliable_resources
    WHERE supplied_resource_id = l_supplied_resource_id;

Line: 114

  SELECT 1
  FROM ota_event_associations
  WHERE event_id = p_event_id;

Line: 131

    UPDATE ota_events
    SET book_independent_flag = nvl(book_independent_flag,   'N'),
      secure_event_flag = nvl(secure_event_flag,   'N'),
      maximum_internal_attendees = decode(price_basis,   'C',   0,   'O',   0,   maximum_internal_attendees),
      timezone = decode(offering_id,   NULL,   timezone,   ota_classic_upgrade.get_apps_timezone(timezone))
    WHERE event_id = p_event_id;

Line: 155

      UPDATE ota_events
      SET public_event_flag = v_pblc_evt_flg
      WHERE event_id = p_event_id;

Line: 181

    SELECT message_text
    FROM fnd_new_messages
    WHERE message_name = TRIM(SUBSTR(msg_name,   instr(msg_name,   ':',   1,   1) + 1,
    			 (decode(instr(msg_name,   ':',   1,   2),   0,   LENGTH(msg_name),
			 instr(msg_name,   ':',   1,   2) -1) -instr(msg_name,   ':'))))
     AND language_code = userenv('LANG');

Line: 209

    SELECT resbkng.supplied_resource_id
    FROM ota_resource_bookings resbkng
    WHERE resbkng.event_id = p_event_id
     AND resbkng.primary_venue_flag = 'Y';

Line: 235

    SELECT loc.timezone_code
    FROM ota_suppliable_resources res,
      hr_locations loc
    WHERE supplied_resource_id = p_pri_ven
     AND res.location_id = loc.location_id;

Line: 262

    SELECT loc.timezone_code

    FROM hr_locations loc,
      hr_all_organization_units org
    WHERE loc.location_id = org.location_id
     AND org.organization_id = trg_cen_id;

Line: 319

        UPDATE ota_resource_bookings
        SET timezone_code = p_time_zone
        WHERE resource_booking_id = p_res_bkng_id
         AND object_version_number = p_obj_ver_number
         AND timezone_code IS NULL;

Line: 346

    SELECT event_id
    FROM ota_events
    WHERE event_id = p_event_id OR parent_event_id = p_event_id
     AND timezone IS NULL;

Line: 352

    SELECT resource_booking_id,
      object_version_number
    FROM ota_resource_bookings
    WHERE event_id = p_event_id
     AND timezone_code IS NULL;

Line: 364

        UPDATE ota_events
        SET timezone = p_time_zone -- * WHERE event_id = event_sess_row.event_id
        WHERE(event_id = p_event_id OR parent_event_id = p_event_id)
         AND timezone IS NULL -- Added for bug#5110735
        AND event_type IN('SCHEDULED',   'SESSION',   'SELFPACED','DEVELOPMENT','PROGRAMME');

Line: 394

      UPDATE ota_resource_bookings
      SET timezone_code = p_time_zone
      WHERE event_id in (SELECT event_id
                        FROM ota_events
                        WHERE event_id = p_event_id OR parent_event_id = p_event_id)
       AND timezone_code IS NULL;

Line: 407

    SELECT resource_booking_id,
      object_version_number
    FROM ota_resource_bookings
    WHERE forum_id IN
      (SELECT forum_id
       FROM ota_frm_obj_inclusions
       WHERE object_type = 'E'
       AND object_id = p_event_id)
    AND timezone_code IS NULL;

Line: 427

      UPDATE ota_resource_bookings
      SET timezone_code = p_time_zone
      WHERE forum_id IN
        (SELECT forum_id
         FROM ota_frm_obj_inclusions
         WHERE object_type = 'E'
         AND object_id = p_event_id)
      AND timezone_code IS NULL;

Line: 440

    SELECT chat_id
    FROM ota_chat_obj_inclusions
    WHERE object_id = p_event_id
     AND primary_flag = 'Y'
     AND object_type = 'E';

Line: 447

    SELECT resource_booking_id,
      object_version_number
    FROM ota_resource_bookings
    WHERE chat_id = p_chat_id
     AND timezone_code IS NULL;

Line: 459

          UPDATE ota_chats_b
          SET timezone_code = p_time_zone
          WHERE chat_id = chats_row.chat_id
           AND timezone_code IS NULL;

Line: 489

        UPDATE ota_resource_bookings
        SET timezone_code = p_time_zone
        WHERE chat_id = chats_row.chat_id
         AND timezone_code IS NULL;

Line: 500

    SELECT chat_id
    FROM ota_chat_obj_inclusions
    WHERE primary_flag = 'Y'
     AND object_type = 'C';

Line: 506

    SELECT resource_booking_id,
      object_version_number
    FROM ota_resource_bookings
    WHERE chat_id = p_chat_id
     AND timezone_code IS NULL;

Line: 533

            UPDATE ota_chats_b
            SET timezone_code = l_time_zone
            WHERE chat_id = cat_chat_bkng_row.chat_id
             AND timezone_code IS NULL;

Line: 564

          UPDATE ota_resource_bookings
          SET timezone_code = l_time_zone
          WHERE chat_id = cat_chat_bkng_row.chat_id
           AND timezone_code IS NULL;

Line: 592

    SELECT resource_booking_id,
      object_version_number
    FROM ota_resource_bookings
    WHERE forum_id IN
      (SELECT forum_id
       FROM ota_frm_obj_inclusions
       WHERE primary_flag = 'Y'
       AND object_type = 'C')
    AND timezone_code IS NULL;

Line: 628

        UPDATE ota_resource_bookings
        SET timezone_code = l_time_zone
        WHERE forum_id IN
          (SELECT forum_id
           FROM ota_frm_obj_inclusions
           WHERE primary_flag = 'Y'
           AND object_type = 'C')
        AND timezone_code IS NULL;

Line: 659

    SELECT event_id,
      location_id,
      training_center_id,
      timezone,
      event_type,
      public_event_flag
    FROM ota_events;

Line: 752

    SELECT supplied_resource_id
    FROM ota_resource_bookings
    WHERE event_id IS NULL
     AND forum_id IS NULL
     AND chat_id IS NULL
     AND timezone_code IS NULL
    GROUP BY supplied_resource_id;

Line: 761

    SELECT resource_booking_id,
      object_version_number
    FROM ota_resource_bookings
    WHERE supplied_resource_id = p_res_id
     AND timezone_code IS NULL;

Line: 816

        UPDATE ota_resource_bookings
        SET timezone_code = l_time_zone
        WHERE supplied_resource_id = ind_res_bookings_row.supplied_resource_id
         AND timezone_code IS NULL;

Line: 848

     SELECT trb.supplied_resource_id,
     trb.chat_id,
     trb.forum_id,
     trb.required_date_from,
     trb.required_date_to,
     trb.required_end_time,
     trb.required_start_time,
     trb.resource_booking_id,
     trb.timezone_code,
     trb.book_entire_period_flag,
     res.resource_type
     FROM ota_resource_bookings trb,ota_suppliable_resources res
     WHERE trb.status = 'C'
     and res.resource_type in ('T','V')
     and trb.required_date_to >=(trunc(sysdate)-14)
     and trb.supplied_resource_id=res.supplied_resource_id
    order by resource_booking_id;

Line: 869

      SELECT MAX(upgrade_id)
      INTO l_upgrade_id
      FROM ota_upgrade_log
      WHERE upgrade_name = l_upgrade_name;