APPS.IGS_GE_GEN_003 SQL Statements

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

Line: 31

        SELECT  pe.person_id,
            pe.staff_member_ind
        FROM    IGS_PE_PERSON pe
        WHERE   pe.oracle_username = cp_oracle_username;

Line: 74

    IGS_GE_S_LOG_PKG.INSERT_ROW(
        x_rowid => l_rowid ,
        x_s_log_type => p_s_log_type,
        x_creation_dt =>v_creation_dt,
        x_key =>p_key,
        x_mode => 'R' );

Line: 110

    SELECT IGS_GE_S_ERROR_LOG_SEQ_NUM_S.nextval INTO L_VAL
    FROM DUAL;

Line: 113

    IGS_GE_S_LOG_ENTRY_PKG.INSERT_ROW(
        x_rowid => l_rowid ,
        x_s_log_type => p_s_log_type,
        x_creation_dt => p_creation_dt,
        x_sequence_number => L_VAL,
        x_key => p_key,
        x_message_name => p_s_message_name,
        x_text => p_text,
        x_mode => 'R');

Line: 159

        SELECT  sequence_number
        FROM    IGS_PE_STD_TODO
        WHERE   person_id       = cp_person_id AND
            s_student_todo_type     = cp_s_student_todo_type AND
            logical_delete_dt   IS NULL AND
            (todo_dt        IS NULL OR
            todo_dt         <= cp_todo_dt);

Line: 167

            SELECT IGS_PE_STD_TODO_SEQ_NUM_S.nextval
            FROM DUAL;

Line: 195

    IGS_PE_STD_TODO_PKG.INSERT_ROW (
        x_rowid => l_rowid ,
        X_person_id =>p_person_id,
        x_s_student_todo_type => p_s_student_todo_type,
        x_sequence_number => v_sequence_num,
        x_todo_dt => p_todo_dt,
        x_logical_delete_dt => NULL ,
        x_mode => 'R');

Line: 232

    v_update_log    BOOLEAN := FALSE;

Line: 235

        SELECT  rowid, SLE.*
        FROM    IGS_GE_S_LOG_ENTRY  sle
        WHERE   sle.s_log_type  = p_s_log_type AND
            sle.creation_dt = p_creation_dt AND
            sle.key     = p_sle_key
        FOR UPDATE OF sle.text NOWAIT;

Line: 255

        IGS_GE_S_LOG_ENTRY_pkg.update_row(
            X_ROWID => v_sle_rec.rowid,
            X_S_LOG_TYPE => v_sle_rec.s_log_type ,
            X_CREATION_DT => v_sle_rec.creation_dt ,
            X_SEQUENCE_NUMBER =>v_sle_rec.sequence_number,
            X_KEY => v_sle_rec.key ,
            X_MESSAGE_NAME => v_sle_rec.message_name,
            X_TEXT => TO_CHAR(TO_NUMBER(v_sle_rec.text) + p_count),
            X_MODE => 'R'
            );

Line: 265

        v_update_log :=TRUE;

Line: 267

    IF v_new_log OR NOT v_update_log THEN
        v_total_count := p_count;

Line: 335

        SELECT  *
        FROM    IGS_PE_STD_TODO_REF
        WHERE   person_id = p_person_id AND
            s_student_todo_type = p_s_student_todo_type AND
            sequence_number = p_sequence_number AND
            reference_number = p_reference_number
        FOR UPDATE
        NOWAIT;

Line: 344

        SELECT  'x'
        FROM    dual
        WHERE   EXISTS (
                SELECT  person_id
                FROM    IGS_PE_STD_TODO_REF
                WHERE   person_id = p_person_id                     AND
                        s_student_todo_type = p_s_student_todo_type AND
                        sequence_number = p_sequence_number         AND
                        logical_delete_dt IS NULL
                );

Line: 356

    SELECT IGS_PE_STD_TODO_REF.* , ROWID
    FROM IGS_PE_STD_TODO_REF
    WHERE   person_id = p_person_id                         AND
            s_student_todo_type = p_s_student_todo_type     AND
            sequence_number = p_sequence_number             AND
            reference_number = p_reference_number;

Line: 373

    IGS_PE_STD_TODO_REF_PKG.UPDATE_ROW(
        X_ROWID => SI_RE_REC.ROWID,
        X_PERSON_ID => SI_RE_REC.PERSON_ID,
        X_S_STUDENT_TODO_TYPE => SI_RE_REC.S_STUDENT_TODO_TYPE,
        X_SEQUENCE_NUMBER => SI_RE_REC.SEQUENCE_NUMBER,
        X_REFERENCE_NUMBER => SI_RE_REC.REFERENCE_NUMBER,
        X_CAL_TYPE => SI_RE_REC.CAL_TYPE,
        X_CI_SEQUENCE_NUMBER => SI_RE_REC.CI_SEQUENCE_NUMBER,
        X_COURSE_CD => SI_RE_REC.COURSE_CD,
        X_UNIT_CD=> SI_RE_REC.UNIT_CD,
        X_OTHER_REFERENCE=> SI_RE_REC.OTHER_REFERENCE,
        X_LOGICAL_DELETE_DT=> SYSDATE,
        X_MODE=> 'R',
        X_UOO_ID => SI_RE_REC.UOO_ID
        );

Line: 441

  SELECT 1 FROM IGS_PE_STD_TODO_REF WHERE
  PERSON_ID=P_PERSON_ID AND
  S_STUDENT_TODO_TYPE=P_S_STUDENT_TODO_TYPE AND
  SEQUENCE_NUMBER=P_SEQUENCE_NUMBER AND
  ((CAL_TYPE = P_CAL_TYPE AND CAL_TYPE IS NOT NULL AND P_CAL_TYPE IS NOT NULL) OR (CAL_TYPE IS NULL AND P_CAL_TYPE IS NULL)) AND
  ((CI_SEQUENCE_NUMBER= P_CI_SEQUENCE_NUMBER AND CI_SEQUENCE_NUMBER IS NOT NULL AND P_CI_SEQUENCE_NUMBER IS NOT NULL) OR (CI_SEQUENCE_NUMBER IS NULL AND P_CI_SEQUENCE_NUMBER IS NULL)) AND
  ((COURSE_CD= P_COURSE_CD AND COURSE_CD IS NOT NULL AND P_COURSE_CD IS NOT NULL) OR (COURSE_CD IS NULL AND P_COURSE_CD IS NULL)) AND
  ((UNIT_CD = P_UNIT_CD AND UNIT_CD IS NOT NULL AND P_UNIT_CD IS NOT NULL) OR (UNIT_CD IS NULL AND P_UNIT_CD IS NULL)) AND
  ((UOO_ID = P_UOO_ID AND UOO_ID IS NOT NULL AND P_UOO_ID IS NOT NULL) OR (UOO_ID IS NULL AND P_UOO_ID IS NULL)) AND
  ((OTHER_REFERENCE = P_OTHER_REFERENCE AND OTHER_REFERENCE IS NOT NULL AND P_OTHER_REFERENCE IS NOT NULL) OR (OTHER_REFERENCE IS NULL AND P_OTHER_REFERENCE IS NULL)) AND
  LOGICAL_DELETE_DT IS NULL;

Line: 462

    SELECT IGS_PE_STD_TODO_REF_RF_NUM_S.NEXTVAL INTO l_reference_number
                        FROM DUAL;

Line: 465

    IGS_PE_STD_TODO_REF_PKG.INSERT_ROW (
        x_rowid => l_rowid ,
        X_person_id =>p_person_id,
        x_s_student_todo_type => p_s_student_todo_type,
        x_sequence_number => p_sequence_number,
                x_reference_number => l_reference_number,
                x_cal_type  => p_cal_type,
                x_ci_sequence_number=>p_ci_sequence_number,
                x_course_cd => p_course_cd,
                x_unit_cd => p_unit_cd,
                x_other_reference => p_other_reference,
        x_logical_delete_dt => NULL ,
        x_mode => 'R',
        x_uoo_id => p_uoo_id);

Line: 480

/* INSERT INTO student_todo_ref (

    person_id,

    s_student_todo_type,

    sequence_number,

    reference_number,

    cal_type,

    ci_sequence_number,

    course_cd,

    unit_cd,

    other_reference)

 VALUES(

  p_person_id,

  p_s_student_todo_type,

  p_sequence_number,

  str_sequence_number.nextval,

  p_cal_type,

  p_ci_sequence_number,

  p_course_cd,

  p_unit_cd,

  p_other_reference);*/

Line: 534

   SELECT
   NVL ( TO_NUMBER ( DECODE ( SUBSTRB ( USERENV ('CLIENT_INFO'
                                                ), 1, 1
                                      ), ' ', NULL,  SUBSTRB (USERENV ('CLIENT_INFO'),1,10)
                             )
                   ), NULL
       )
 FROM dual;

Line: 595

SELECT person_id
FROM igs_pe_person_base_v
WHERE person_number = p_person_number
AND 1 = (SELECT COUNT(*)
         FROM igs_pe_person_base_v
         WHERE person_number = p_person_number);

Line: 646

SELECT version_number
FROM igs_en_stdnt_ps_att
WHERE person_id = p_person_id
AND course_cd = p_program_cd;

Line: 711

SELECT count(*)
FROM igs_ca_inst
WHERE alternate_code = p_alternate_cd;

Line: 718

SELECT cal_type,sequence_number,start_dt,end_dt
FROM igs_ca_inst
WHERE alternate_code = p_alternate_cd;

Line: 759

	fnd_dsql.add_text('SELECT ci.cal_type,ci.sequence_number,ci.start_dt,ci.end_dt FROM igs_ca_inst_all ci, igs_ca_type ct WHERE alternate_code =');

Line: 869

SELECT us_version_number,sequence_number
FROM igs_as_su_setatmpt
WHERE person_id = p_person_id
AND course_cd = p_program_cd
AND unit_set_cd = p_unit_set_cd
AND 1 = (SELECT COUNT(*)
         FROM igs_as_su_setatmpt
         WHERE person_id = p_person_id
         AND course_cd = p_program_cd
     AND unit_set_cd = p_unit_set_cd);