APPS.CS_SR_WF_DUP_CHK_PVT SQL Statements

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

Line: 17

          SELECT  sr_creation_channel
            FROM  cs_incidents_all_b
            WHERE incident_id = l_incident_id;

Line: 53

    PROCEDURE Check_SR_Updated
    (
        itemtype    VARCHAR2,
        itemkey     VARCHAR2,
        actid       NUMBER,
        funmode     VARCHAR2,
        result      OUT NOCOPY VARCHAR2
    )
    IS
       l_incident_id             number;

Line: 69

       SELECT  creation_date, last_update_date, object_version_number
         FROM  cs_incidents_all_b
        WHERE incident_id = l_incident_id;

Line: 128

      WF_CORE.Context('CS_SR_WF_DUP_CHK_PVT', 'Check_last_updated', itemtype, itemkey, actid, funmode);

Line: 131

   END Check_SR_Updated;

Line: 148

       SELECT  creation_date, last_update_date
         FROM  cs_incidents_all_b
        WHERE incident_id = l_incident_id;

Line: 172

      WF_CORE.Context('CS_SR_WF_DUP_CHK_PVT', 'Check_last_updated', itemtype, itemkey, actid, funmode);

Line: 214

        SELECT incident_id, incident_number, customer_id, inventory_item_id, customer_product_id,
               current_serial_number, item_serial_number,
               incident_type_id, incident_location_id,
               incident_Address, incident_city, incident_state, incident_country, incident_postal_code
          FROM cs_incidents_all_b
         WHERE incident_id = l_incident_id;

Line: 224

        SELECT conf.sr_dup_check_flag
          FROM cug_sr_type_dup_chk_info conf, cs_incidents_all_b inc
         WHERE conf.incident_type_id = inc.incident_type_id
           AND inc.incident_id = l_incident_id;

Line: 230

        SELECT incident_id, sr_attribute_code, sr_attribute_value
          FROM cug_incidnt_attr_vals_vl
         WHERE incident_id = l_incident_id;

Line: 430

      l_login_id                jtf_notes_b.last_update_login%TYPE;

Line: 431

      l_user_id                 jtf_notes_b.last_updated_by%TYPE;

Line: 435

      select * from cs_incidents_all_b
       where incident_id = l_incident_id;

Line: 440

      SELECT sr_attribute_code, sr_attribute_value
        FROM cug_incidnt_attr_vals_vl
       WHERE incident_id = l_incident_id;

Line: 447

      SELECT object_version_number
      FROM jtf_tasks_b
      WHERE source_object_id = l_incident_id
      and source_object_type_code = 'SR';

Line: 601

            l_sr_rec.last_update_channel         := l_rec.last_update_channel;

Line: 629

            l_sr_rec.last_update_program_code    := l_rec.last_update_program_code;

Line: 775

            l_sr_rec2.last_update_channel         := l_rec.last_update_channel;

Line: 803

            l_sr_rec2.last_update_program_code    := l_rec.last_update_program_code;

Line: 928

               p_last_update_date   => sysdate,
               p_last_updated_by    => l_user_id,
               p_creation_date      => sysdate,
               p_created_by         => l_user_id,
               p_last_update_login  => l_login_id,
               p_source_object_id   => l_incident_id,
               p_source_object_code => 'SR',
               p_notes              => l_err,
               p_notes_detail       => l_err,
               p_note_type          => l_note_type,
               p_note_status        => 'P',
               x_jtf_note_id        => l_note_id
            );

Line: 989

      SELECT emp.source_id incident_owner_id
        FROM cs_incidents_all_vl inc ,jtf_rs_resource_extns emp
       WHERE inc.INCIDENT_OWNER_ID = emp.resource_id AND
             incident_id = l_incident_id;

Line: 997

      SELECT  emp.source_id incident_owner_id
        FROM  cug_sr_type_dup_chk_info maps, cs_incidents_all_b sr, jtf_rs_resource_extns emp
       WHERE maps.incident_type_id = sr.incident_type_id
         AND maps.resource_id = emp.resource_id
         AND sr.incident_id = l_incident_id;

Line: 1134

      SELECT  incident_owner_id
        FROM  cs_incidents_all_b inc
       WHERE incident_id = l_incident_id;