133: last_update_date, last_updated_by,
134: creation_date, created_by)
135: VALUES ( l_factor_id, l_formula_id,
136: i_factors(i).weight, 1,
137: sysdate, fnd_global.user_id,
138: sysdate, fnd_global.user_id);
139:
140: -- decrement index.
141: i := i - 1;
134: creation_date, created_by)
135: VALUES ( l_factor_id, l_formula_id,
136: i_factors(i).weight, 1,
137: sysdate, fnd_global.user_id,
138: sysdate, fnd_global.user_id);
139:
140: -- decrement index.
141: i := i - 1;
142:
150: last_update_date, last_updated_by,
151: creation_date, created_by)
152: VALUES ( l_formula_id, i_name, i_description,
153: i_flag, i_payeeId, 1,
154: sysdate, fnd_global.user_id,
155: sysdate, fnd_global.user_id);
156: -- commit the changes
157: commit;
158:
151: creation_date, created_by)
152: VALUES ( l_formula_id, i_name, i_description,
153: i_flag, i_payeeId, 1,
154: sysdate, fnd_global.user_id,
155: sysdate, fnd_global.user_id);
156: -- commit the changes
157: commit;
158:
159: END createFormula;
237: INSERT INTO iby_risk_formula_item
238: (risk_factor_id, risk_formula_id, weight, object_version_number,
239: last_update_date, last_updated_by, creation_date, created_by)
240: VALUES ( l_factor_id, i_id, i_factors(i).weight, 1,
241: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id);
242:
243: -- decrement index.
244: i := i - 1;
245:
251: SET formula_name = i_name,
252: description = i_description,
253: implicit_flag = i_flag,
254: last_update_date = sysdate,
255: last_updated_by = fnd_global.user_id
256: WHERE risk_formula_id = i_id;
257:
258: -- if no of rows updated is zero then raise an exception.
259: