APPS.IGS_RE_SPRVSR_LGCY_PUB SQL Statements

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

Line: 87

           FND_MSG_PUB.DELETE_MSG (l_msg_count);

Line: 105

          FND_MSG_PUB.DELETE_MSG (l_msg_count);

Line: 121

           FND_MSG_PUB.DELETE_MSG (l_msg_count);

Line: 136

           FND_MSG_PUB.DELETE_MSG (l_msg_count);

Line: 176

    SELECT sequence_number
    FROM   igs_re_sprvsr
    WHERE  person_id = l_person_id
    AND    ca_person_id = l_ca_person_id
    AND    ca_sequence_number = l_ca_sequence_number;

Line: 184

    SELECT  replaced_sequence_number
    FROM    igs_re_sprvsr
    WHERE   replaced_person_id = l_repl_person_id;

Line: 189

    SELECT 'x'
    FROM igs_re_sprvsr rsup, igs_pe_person_base_v pdv
    WHERE rsup.ca_person_id = p_ca_person_id
    AND rsup.ca_sequence_number = p_ca_sequence_number
    AND rsup.person_id = p_person_id
    AND rsup.sequence_number = l_sequence_number
    AND (rsup.end_dt IS NULL OR rsup.end_dt > p_sprvsr_dtls_rec.start_dt)
    AND rsup.person_id = pdv.person_id;

Line: 199

    SELECT 'X'
    FROM igs_or_unit
    WHERE org_unit_cd = cp_org_unit_cd;

Line: 334

         curr_stat := 'SELECT ''x'' FROM igs_or_unit WHERE org_unit_cd = :1 '||l_where_clause;

Line: 407

    SELECT sequence_number, start_dt
    FROM   igs_re_sprvsr
    WHERE  person_id = l_person_id
    AND    ca_person_id = l_ca_person_id
    AND    ca_sequence_number = l_ca_sequence_number;

Line: 474

  Purpose         : This procedure imports the legacy data inot OSS tables. Before inserting it
                    validates the input parameters, checks for Data Integrity Constraints and
                    business validations.
  Known limitations,enhancements,remarks:
  Change History
  Who           When         What
  Nalin Kumar   28-Jan-2003  Modified create_sprvsr.c_repl_person_dtls cursor to fetch sequence_number by comparing person_id;

Line: 486

    SELECT igs_re_sprvsr_seq_num_s.nextval
    FROM dual;

Line: 490

    SELECT sequence_number
    FROM igs_re_sprvsr
    WHERE person_id = l_repl_person_id;

Line: 508

  l_last_update_date            DATE;

Line: 510

  l_last_updated_by             NUMBER;

Line: 511

  l_last_update_login           NUMBER;

Line: 628

       l_last_update_date := SYSDATE;

Line: 629

       l_last_updated_by := FND_GLOBAL.USER_ID;

Line: 630

       l_last_update_login :=FND_GLOBAL.LOGIN_ID;

Line: 636

       IF l_last_updated_by IS NULL THEN
          l_last_updated_by := -1;

Line: 640

       IF l_last_update_login IS NULL THEN
          l_last_update_login := -1;

Line: 651

         INSERT INTO igs_re_sprvsr (
            ca_person_id,
            ca_sequence_number,
            person_id,
            sequence_number,
            start_dt,
            end_dt,
            research_supervisor_type,
            supervisor_profession,
            supervision_percentage,
            funding_percentage,
            org_unit_cd,
            ou_start_dt,
            replaced_person_id,
            replaced_sequence_number,
            comments,
            created_by,
            creation_date,
            last_updated_by,
            last_update_date,
            last_update_login )
         VALUES (
            l_ca_person_id,
            l_ca_sequence_number,
            l_person_id,
            l_sequence_number,
            p_sprvsr_dtls_rec.start_dt,
            p_sprvsr_dtls_rec.end_dt,
            p_sprvsr_dtls_rec.research_supervisor_type,
            p_sprvsr_dtls_rec.supervisor_profession,
            p_sprvsr_dtls_rec.supervision_percentage,
            p_sprvsr_dtls_rec.funding_percentage,
            p_sprvsr_dtls_rec.org_unit_cd,
            l_ou_start_dt,
            l_replaced_person_id,
            l_replaced_sequence_number,
            p_sprvsr_dtls_rec.comments,
            l_created_by,
            l_creation_date,
            l_last_updated_by,
            l_last_update_date,
            l_last_update_login
          );