APPS.IBY_FORMULA_PKG dependencies on IBY_RISK_FORMULAS

Line 13: CURSOR c_formulas(ci_payeeid iby_risk_formulas.payeeid%TYPE) is

9: PROCEDURE getPayeeFormulas( i_payeeid IN VARCHAR2,
10: o_RiskFormula out nocopy formula_table)
11: IS
12:
13: CURSOR c_formulas(ci_payeeid iby_risk_formulas.payeeid%TYPE) is
14: SELECT risk_formula_id, formula_name, description, implicit_flag
15: FROM iby_risk_formulas
16: WHERE payeeid = ci_payeeid
17: order by creation_date;

Line 15: FROM iby_risk_formulas

11: IS
12:
13: CURSOR c_formulas(ci_payeeid iby_risk_formulas.payeeid%TYPE) is
14: SELECT risk_formula_id, formula_name, description, implicit_flag
15: FROM iby_risk_formulas
16: WHERE payeeid = ci_payeeid
17: order by creation_date;
18:
19: l_count INTEGER;

Line 65: SELECT IBY_RISK_FORMULAS_S.NEXTVAL

61: o_id out nocopy integer)
62: IS
63:
64: CURSOR c_formula_id is
65: SELECT IBY_RISK_FORMULAS_S.NEXTVAL
66: FROM DUAL;
67:
68: CURSOR c_factor_id( ci_factor_name VARCHAR2) is
69: SELECT risk_factor_id

Line 84: FROM iby_risk_formulas

80: ** Check if this Formula Name already exists with that Payee
81: ** or not. if exists, then raise an exception.
82: */
83: SELECT count(*) INTO i
84: FROM iby_risk_formulas
85: WHERE formula_name = i_name
86: AND payeeid = i_payeeid;
87:
88: IF ( i <> 0 ) then

Line 147: INSERT INTO iby_risk_formulas

143: END LOOP;
144:
145: -- make entry in the formulas table once all the factors are
146: -- inserted.
147: INSERT INTO iby_risk_formulas
148: ( risk_formula_id, formula_name, description,
149: implicit_flag, payeeid,object_version_number,
150: last_update_date, last_updated_by,
151: creation_date, created_by)

Line 194: FROM iby_risk_formulas

190: ** payee id corresponding to it is same as the one associated
191: ** with the formula id.
192: */
193: SELECT count(*) INTO i
194: FROM iby_risk_formulas
195: WHERE formula_name = i_name
196: and risk_formula_id <> i_id
197: and payeeid = ( SELECT payeeid
198: FROM iby_risk_formulas

Line 198: FROM iby_risk_formulas

194: FROM iby_risk_formulas
195: WHERE formula_name = i_name
196: and risk_formula_id <> i_id
197: and payeeid = ( SELECT payeeid
198: FROM iby_risk_formulas
199: WHERE risk_formula_id = i_id );
200:
201: /*
202: ** if count is not zero, that means already some

Line 250: UPDATE iby_risk_formulas

246: END LOOP;
247:
248: -- update the formula information.
249:
250: UPDATE iby_risk_formulas
251: SET formula_name = i_name,
252: description = i_description,
253: implicit_flag = i_flag,
254: last_update_date = sysdate,

Line 280: -- delete the Formula entry from iby_risk_formulas

276: -- delete the FAcotr items from the iby_risk_formula_item.
277: DELETE iby_risk_formula_item
278: WHERE risk_formula_id = i_id;
279:
280: -- delete the Formula entry from iby_risk_formulas
281: DELETE iby_risk_formulas
282: WHERE risk_formula_id = i_id;
283:
284: if ( SQL%ROWCOUNT = 0 ) then

Line 281: DELETE iby_risk_formulas

277: DELETE iby_risk_formula_item
278: WHERE risk_formula_id = i_id;
279:
280: -- delete the Formula entry from iby_risk_formulas
281: DELETE iby_risk_formulas
282: WHERE risk_formula_id = i_id;
283:
284: if ( SQL%ROWCOUNT = 0 ) then
285: raise_application_error(-20000, 'IBY_204225#');

Line 305: CURSOR c_formulas(ci_risk_formula_id iby_risk_formulas.risk_formula_id%TYPE) is

301: o_flag out nocopy integer,
302: o_Factors out nocopy factor_table)
303: IS
304:
305: CURSOR c_formulas(ci_risk_formula_id iby_risk_formulas.risk_formula_id%TYPE) is
306: SELECT formula_name, description, implicit_flag
307: FROM iby_risk_formulas
308: WHERE risk_formula_id = ci_risk_formula_id;
309:

Line 307: FROM iby_risk_formulas

303: IS
304:
305: CURSOR c_formulas(ci_risk_formula_id iby_risk_formulas.risk_formula_id%TYPE) is
306: SELECT formula_name, description, implicit_flag
307: FROM iby_risk_formulas
308: WHERE risk_formula_id = ci_risk_formula_id;
309:
310: CURSOR c_factor(ci_factorid iby_risk_formula_item.risk_formula_id%type) IS
311: SELECT risk_factor_code, weight