APPS.IGF_AP_INST_APP SQL Statements

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

Line: 5

  PROCEDURE update_ToDo_status(p_base_id             igf_ap_fa_base_rec_all.base_id%TYPE,
                              p_application_code    igf_ap_appl_status_all.application_code%TYPE,
                              x_return_status       OUT NOCOPY VARCHAR2)
    IS
    ------------------------------------------------------------------
    --Created by  : upinjark, Oracle India
    --Date created: 04-Jul-2004
    --
    --Purpose:
    --
    --
    --Known limitations/enhancements and/or remarks:
    --
    --Change History:
    --Who         When            What
    -------------------------------------------------------------------

    --Cursor to fetch to do item
    CURSOR c_td_item (cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
             	      cp_application_code igf_ap_appl_status_all.application_code%TYPE)
                      IS
    SELECT tdmst.todo_number
      FROM igf_ap_td_item_inst_all tdinst, igf_ap_td_item_mst_all tdmst, Igf_ap_fa_base_rec_all baseRec
     WHERE tdmst.system_todo_type_code = 'INSTAPP'
       AND baseRec.ci_cal_type = tdmst.ci_cal_type
       AND baseRec.ci_sequence_number = tdmst.ci_sequence_number
       AND baseRec.base_id = tdinst.base_id
       AND tdmst.application_code = cp_application_code
       AND tdinst.item_sequence_number = tdmst.todo_number
       AND tdinst.base_id = cp_base_id;

Line: 51

        igf_ap_gen.update_td_status(
                                p_base_id                 => p_base_id ,
                                p_item_sequence_number    => l_td_item.todo_number ,
                                p_status                  => 'COM',
                                p_return_status           => l_todo_status
                                );

Line: 72

  END update_ToDo_status;

Line: 74

  PROCEDURE update_ToDo (p_base_id                igf_ap_fa_base_rec_all.base_id%TYPE,
                         p_application_code       igf_ap_appl_status_all.application_code%TYPE,
                         p_status              IN igf_ap_td_item_inst_all.status%TYPE,
                         x_return_status       OUT NOCOPY VARCHAR2)
    IS
    ------------------------------------------------------------------
    --Created by  : upinjark, Oracle India
    --Date created: 08-Aug-2004
    --
    --Purpose:
    --
    --
    --Known limitations/enhancements and/or remarks:
    --
    --Change History:
    --Who         When            What
    -------------------------------------------------------------------

    --Cursor to fetch to do item
    CURSOR c_td_item (cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
             	      cp_application_code igf_ap_appl_status_all.application_code%TYPE)
                      IS
    SELECT tdmst.todo_number
      FROM igf_ap_td_item_inst_all tdinst, igf_ap_td_item_mst_all tdmst, Igf_ap_fa_base_rec_all baseRec
     WHERE tdmst.system_todo_type_code = 'INSTAPP'
       AND baseRec.ci_cal_type = tdmst.ci_cal_type
       AND baseRec.ci_sequence_number = tdmst.ci_sequence_number
       AND baseRec.base_id = tdinst.base_id
       AND tdmst.application_code = cp_application_code
       AND tdinst.item_sequence_number = tdmst.todo_number
       AND tdinst.base_id = cp_base_id;

Line: 121

        igf_ap_gen.update_td_status(
                                    p_base_id                 => p_base_id ,
                                    p_item_sequence_number    => l_td_item.todo_number ,
                                    p_status                  => p_status,
                                    p_return_status           => l_todo_status
                                    );

Line: 142

  END update_ToDo;

Line: 146

  PROCEDURE update_app_status(p_base_id                   igf_ap_fa_base_rec_all.base_id%TYPE,
                              p_application_code          igf_ap_appl_status_all.application_code%TYPE,
                              p_application_status_code   igf_ap_appl_status_all.application_status_code%TYPE,
                              x_return_status             OUT NOCOPY VARCHAR2)
    IS
    ------------------------------------------------------------------
    --Created by  : upinjark, Oracle India
    --Date created: 04-Jul-2004
    --
    --Purpose:
    --
    --
    --Known limitations/enhancements and/or remarks:
    --
    --Change History:
    --Who         When            What
    -------------------------------------------------------------------

  -- cursor to get the row from application status table
  CURSOR c_appl_status (cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
                        cp_application_code igf_ap_appl_status_all.application_code%TYPE
                       ) IS
     SELECT rowid
       FROM IGF_AP_APPL_STATUS_ALL aps
      WHERE BASE_ID = cp_base_id
        AND APPLICATION_CODE = cp_application_code;

Line: 179

        fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_inst_app.update_app_status.debug','calling igf_ap_appl_status_all_pkg.update_row');

Line: 187

    igf_ap_appl_status_pkg.update_row (
      x_rowid                                 => l_appl_status.rowid,
      x_base_id                                => p_base_id,
      x_application_code                       => p_application_code,
      x_application_status_code                => p_application_status_code
    );

Line: 203

  END update_app_status;

Line: 206

  PROCEDURE update_Ant_Data_For_All_Terms (p_base_id             igf_ap_fa_base_rec_all.base_id%TYPE,
                                           p_cal_type            igs_ca_inst_all.cal_type%TYPE,
                                           p_seq_number          igs_ca_inst_all.sequence_number%TYPE,
                                           p_ant_data_column     VARCHAR2,
                                           p_ant_data_value      VARCHAR2,
                                           x_return_status       OUT NOCOPY VARCHAR2,
                                           p_override_flag       VARCHAR2
                                           )
    IS
    ------------------------------------------------------------------
    --Created by  : upinjark, Oracle India
    --Date created: 04-Jul-2004
    --
    --Purpose:
    --
    --
    --Known limitations/enhancements and/or remarks:
    --
    --Change History:
    --Who         When            What
    -------------------------------------------------------------------

    -- cursor to fetch the terms withinn an award year
    CURSOR c_all_terms(cp_sup_cal_type igs_ca_inst_all.cal_type%TYPE,
                       cp_sup_seq_number igs_ca_inst_all.sequence_number%TYPE)
                       IS
    SELECT SUB_CAL_TYPE, SUB_CI_SEQUENCE_NUMBER
      FROM IGS_CA_INST_REL rel, IGS_CA_TYPE typ
     WHERE rel.SUP_CAL_TYPE = cp_sup_cal_type
       AND rel.SUP_CI_SEQUENCE_NUMBER = cp_sup_seq_number
       AND rel.sub_cal_type=typ.cal_type
       AND typ.s_cal_cat='LOAD';

Line: 247

    SELECT *
      FROM IGF_AP_FA_ANT_DATA
     WHERE BASE_ID = CP_BASE_ID
       AND LD_CAL_TYPE = cp_ld_cal_type
       AND LD_SEQUENCE_NUMBER = cp_ld_seq_number;

Line: 389

  END update_Ant_Data_For_All_Terms;

Line: 393

  PROCEDURE update_Ant_Data_a_Term(p_base_id             igf_ap_fa_base_rec_all.base_id%TYPE,
                                            p_ld_cal_type         igs_ca_inst_all.cal_type%TYPE,
                                            p_ld_seq_number       igs_ca_inst_all.sequence_number%TYPE,
                                            p_ant_data_column     VARCHAR2,
                                            p_ant_data_value      VARCHAR2,
                                            x_return_status       OUT NOCOPY VARCHAR2,
                                            p_override_flag       VARCHAR2
                                           )
    IS
    ------------------------------------------------------------------
    --Created by  : upinjark, Oracle India
    --Date created: 04-Jul-2004
    --
    --Purpose:
    --
    --
    --Known limitations/enhancements and/or remarks:
    --
    --Change History:
    --Who         When            What
    -------------------------------------------------------------------


      -- to fetch all the anticipated value for the given base_id and award year
        CURSOR c_get_ant_data(cp_base_id             igf_ap_fa_base_rec_all.base_id%TYPE,
                              cp_ld_cal_type            igs_ca_inst_all.cal_type%TYPE,
                              cp_ld_seq_number          igs_ca_inst_all.sequence_number%TYPE
                              )
                              IS
        SELECT *
          FROM IGF_AP_FA_ANT_DATA
         WHERE BASE_ID = CP_BASE_ID
           AND LD_CAL_TYPE = cp_ld_cal_type
           AND LD_SEQUENCE_NUMBER = cp_ld_seq_number;

Line: 555

  END update_Ant_Data_a_Term;

Line: 579

       SELECT hz.party_number
         FROM hz_parties hz,
              igf_ap_fa_base_rec_all fa
        WHERE fa.person_id = hz.party_id
          AND fa.base_id = cp_base_id;

Line: 591

        SELECT ca.alternate_code
          FROM igs_ca_inst_all ca,
               igf_ap_fa_base_rec_all fa
         WHERE fa.base_id = cp_base_id
           AND fa.ci_cal_type = ca.cal_type
           AND fa.ci_sequence_number = ca.sequence_number;

Line: 604

        SELECT APPLICATION_NAME
          FROM IGF_AP_APPL_SETUP_ALL
         WHERE APPLICATION_CODE = cp_application_code
           AND ROWNUM = 1;

Line: 631

      SELECT igs_pe_res_chg_s.nextval INTO l_seq_val FROM DUAL;