APPS.IBY_FORMULA_PKG SQL Statements

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

Line: 14

        SELECT risk_formula_id, formula_name, description, implicit_flag
        FROM iby_risk_formulas
        WHERE payeeid = ci_payeeid
        order by creation_date;

Line: 65

    SELECT IBY_RISK_FORMULAS_S.NEXTVAL
    FROM DUAL;

Line: 69

    SELECT risk_factor_id
    FROM iby_risk_factors
    WHERE risk_factor_code = ci_factor_name;

Line: 83

        SELECT count(*) INTO i
        FROM iby_risk_formulas
        WHERE formula_name = i_name
          AND payeeid = i_payeeid;

Line: 130

            INSERT INTO iby_risk_formula_item
                (risk_factor_id, risk_formula_id,
                 weight,object_version_number,
                 last_update_date, last_updated_by,
                 creation_date, created_by)
            VALUES ( l_factor_id, l_formula_id,
                 i_factors(i).weight, 1,
                 sysdate, fnd_global.user_id,
                 sysdate, fnd_global.user_id);

Line: 147

        INSERT INTO iby_risk_formulas
               ( risk_formula_id, formula_name, description,
                implicit_flag, payeeid,object_version_number,
                last_update_date, last_updated_by,
                creation_date, created_by)
        VALUES ( l_formula_id, i_name, i_description,
                i_flag, i_payeeId, 1,
                sysdate, fnd_global.user_id,
                sysdate, fnd_global.user_id);

Line: 175

    SELECT risk_factor_id
    FROM iby_risk_factors
    WHERE risk_factor_code = ci_factor_name;

Line: 193

        SELECT count(*) INTO i
        FROM iby_risk_formulas
        WHERE formula_name = i_name
        and risk_formula_id <> i_id
        and payeeid  =  ( SELECT payeeid
                          FROM iby_risk_formulas
                          WHERE risk_formula_id = i_id );

Line: 213

           DELETE iby_risk_formula_item
           WHERE risk_formula_id = i_id;

Line: 237

            INSERT INTO iby_risk_formula_item
                (risk_factor_id, risk_formula_id, weight, object_version_number,
                last_update_date, last_updated_by, creation_date, created_by)
            VALUES ( l_factor_id, i_id, i_factors(i).weight, 1,
                sysdate, fnd_global.user_id, sysdate, fnd_global.user_id);

Line: 250

        UPDATE iby_risk_formulas
           SET formula_name = i_name,
               description = i_description,
               implicit_flag = i_flag,
               last_update_date = sysdate,
               last_updated_by = fnd_global.user_id
           WHERE risk_formula_id = i_id;

Line: 268

    ** Name : deleteFormula
    ** Purpose : deletes the formula corresponding to the formulaId
    **           from the database.
    */
    PROCEDURE deleteFOrmula( i_id in integer)
    IS
    BEGIN

        -- delete the FAcotr items from the iby_risk_formula_item.
        DELETE iby_risk_formula_item
        WHERE risk_formula_id = i_id;

Line: 281

        DELETE iby_risk_formulas
        WHERE risk_formula_id = i_id;

Line: 290

    END deleteFormula;

Line: 306

        SELECT formula_name, description, implicit_flag
        FROM iby_risk_formulas
        WHERE risk_formula_id = ci_risk_formula_id;

Line: 311

        SELECT risk_factor_code, weight
        FROM iby_risk_factors irf, iby_risk_formula_item irft
        WHERE irft.risk_formula_id = i_formulaId
          AND irf.risk_factor_id = irft.risk_factor_id;