eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PR_PROUT_LGCY_PUB SQL Statements

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

Line: 95


      SELECT   sequence_number
      FROM     igs_pr_stdnt_pr_ou_all
      WHERE    person_id = p_person_id
      AND      progression_outcome_type = p_lgcy_prout_rec.progression_outcome_type
      AND      course_cd = p_lgcy_prout_rec.program_cd
      AND      prg_cal_type = p_prg_cal_type
      AND      prg_ci_sequence_number = p_prg_sequence_number;

Line: 104


      SELECT   s_encmb_effect_type, s_progression_outcome_type
      FROM     igs_fi_enc_dflt_eft dft,
               igs_pr_ou_type ou
      WHERE    dft.encumbrance_type = ou.encumbrance_type
      AND      ou.progression_outcome_type = p_lgcy_prout_rec.progression_outcome_type;

Line: 178


      SELECT   igs_pr_spo_seq_num_s.NEXTVAL
      INTO     p_outcome_sequence_number
      FROM     dual
      WHERE    ROWNUM = 1;

Line: 322


          FND_MSG_PUB.Delete_Msg (FND_MSG_PUB.Count_Msg);

Line: 340


          FND_MSG_PUB.Delete_Msg (FND_MSG_PUB.Count_Msg);

Line: 358


          FND_MSG_PUB.Delete_Msg (FND_MSG_PUB.Count_Msg);

Line: 376


          FND_MSG_PUB.Delete_Msg (FND_MSG_PUB.Count_Msg);

Line: 394


          FND_MSG_PUB.Delete_Msg (FND_MSG_PUB.Count_Msg);

Line: 412


          FND_MSG_PUB.Delete_Msg (FND_MSG_PUB.Count_Msg);

Line: 437


      SELECT   course_attempt_status
      FROM     igs_en_stdnt_ps_att sca
      WHERE    person_id = p_person_id
      AND      course_cd = p_lgcy_prout_rec.program_cd
      AND      course_attempt_status = 'UNCONFIRM';

Line: 444


      SELECT   s_progression_outcome_type
      FROM     igs_pr_ou_type pot
      WHERE    pot.progression_outcome_type = p_lgcy_prout_rec.progression_outcome_type;

Line: 868


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

Line: 871


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

Line: 1057


      SELECT   'Y'
      FROM     igs_en_unit_set us,
               igs_en_unit_set_stat uss
      WHERE    us.unit_set_cd = p_lgcy_prout_rec.unit_set_cd
      AND      us.version_number = p_lgcy_prout_rec.us_version_number
      AND      us.unit_set_status = uss.unit_set_status
      AND      uss.s_unit_set_status <> 'PLANNED';

Line: 1182


          FND_MSG_PUB.Delete_Msg (FND_MSG_PUB.Count_Msg);

Line: 1300


      SELECT   s_award_type
      FROM     igs_ps_awd
      WHERE    award_cd = p_lgcy_prout_rec.award_cd;

Line: 1305


      SELECT   positive_outcome_ind
      FROM     igs_pr_ou_type
      WHERE    progression_outcome_type = p_lgcy_prout_rec.progression_outcome_type;

Line: 1506


      igs_pr_stdnt_pr_ou_pkg.insert_row (
        x_rowid                         => l_rowid,
        x_person_id                     => l_person_id,
        x_course_cd                     => p_lgcy_prout_rec.program_cd,
        x_sequence_number               => l_outcome_sequence_number,
        x_prg_cal_type                  => l_prg_cal_type,
        x_prg_ci_sequence_number        => l_prg_sequence_number,
        x_rule_check_dt                 => NULL,
        x_progression_rule_cat          => NULL,
        x_pra_sequence_number           => NULL,
        x_pro_sequence_number           => NULL,
        x_progression_outcome_type      => p_lgcy_prout_rec.progression_outcome_type,
        x_duration                      => p_lgcy_prout_rec.duration,
        x_duration_type                 => p_lgcy_prout_rec.duration_type,
        x_decision_status               => p_lgcy_prout_rec.decision_status,
        x_decision_dt                   => p_lgcy_prout_rec.decision_dt,
        x_decision_org_unit_cd          => p_lgcy_prout_rec.decision_org_unit_cd,
        x_decision_ou_start_dt          => l_org_start_dt,
        x_applied_dt                    => NULL,
        x_show_cause_expiry_dt          => p_lgcy_prout_rec.show_cause_expiry_dt,
        x_show_cause_dt                 => p_lgcy_prout_rec.show_cause_dt,
        x_show_cause_outcome_dt         => p_lgcy_prout_rec.show_cause_outcome_dt,
        x_show_cause_outcome_type       => p_lgcy_prout_rec.show_cause_outcome_type,
        x_appeal_expiry_dt              => p_lgcy_prout_rec.appeal_expiry_dt,
        x_appeal_dt                     => p_lgcy_prout_rec.appeal_dt,
        x_appeal_outcome_dt             => p_lgcy_prout_rec.appeal_outcome_dt,
        x_appeal_outcome_type           => p_lgcy_prout_rec.appeal_outcome_type,
        x_encmb_course_group_cd         => p_lgcy_prout_rec.encmb_program_group_cd,
        x_restricted_enrolment_cp       => p_lgcy_prout_rec.restricted_enrolment_cp,
        x_restricted_attendance_type    => p_lgcy_prout_rec.restricted_attendance_type,
        x_comments                      => p_lgcy_prout_rec.comments,
        x_show_cause_comments           => p_lgcy_prout_rec.show_cause_comments,
        x_appeal_comments               => p_lgcy_prout_rec.appeal_comments,
        x_expiry_dt                     => p_lgcy_prout_rec.expiry_dt,
        x_pro_pra_sequence_number       => NULL,
        x_mode                          => 'R',
        x_org_id                        => igs_ge_gen_003.get_org_id
      );

Line: 1580


        igs_pr_stdnt_pr_ps_pkg.insert_row (
          x_rowid                             => l_rowid,
          x_person_id                         => l_person_id,
          x_spo_course_cd                     => p_lgcy_prout_rec.spo_program_cd,
          x_spo_sequence_number               => l_outcome_sequence_number,
          x_course_cd                         => p_lgcy_prout_rec.program_cd,
          x_mode                              => 'R'
        );

Line: 1619


      igs_pr_sdt_pr_unt_st_pkg.insert_row (
        x_rowid                             => l_rowid,
        x_person_id                         => l_person_id,
        x_course_cd                         => p_lgcy_prout_rec.program_cd,
        x_spo_sequence_number               => l_outcome_sequence_number,
        x_unit_set_cd                       => p_lgcy_prout_rec.unit_set_cd,
        x_version_number                    => p_lgcy_prout_rec.us_version_number,
        x_mode                              => 'R'
      );

Line: 1661


        igs_pr_stdnt_pr_unit_pkg.insert_row (
          x_rowid                             => l_rowid,
          x_person_id                         => l_person_id,
          x_course_cd                         => p_lgcy_prout_rec.program_cd,
          x_spo_sequence_number               => l_outcome_sequence_number,
          x_unit_cd                           => p_lgcy_prout_rec.unit_cd,
          x_s_unit_type                       => p_lgcy_prout_rec.s_unit_type,
          x_mode                              => 'R'
        );

Line: 1698


      igs_pr_stdnt_pr_awd_pkg.insert_row (
        x_rowid                             => l_rowid,
        x_person_id                         => l_person_id,
        x_course_cd                         => p_lgcy_prout_rec.program_cd,
        x_spo_sequence_number               => l_outcome_sequence_number,
        x_award_cd                          => p_lgcy_prout_rec.award_cd,
        x_mode                              => 'R'
      );

Line: 1725


      igs_pr_stdnt_pr_fnd_pkg.insert_row (
        x_rowid                             => l_rowid,
        x_person_id                         => l_person_id,
        x_course_cd                         => p_lgcy_prout_rec.program_cd,
        x_spo_sequence_number               => l_outcome_sequence_number,
        x_fund_code                         => p_lgcy_prout_rec.fund_code,
        x_mode                              => 'R'
      );