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.IBY_FORMULA_PKG dependencies on IBY_RISK_FORMULA_ITEM

Line 128: -- insert the record into iby_risk_formula_item;

124: END IF;
125:
126: CLOSE c_factor_id;
127:
128: -- insert the record into iby_risk_formula_item;
129:
130: INSERT INTO iby_risk_formula_item
131: (risk_factor_id, risk_formula_id,
132: weight,object_version_number,

Line 130: INSERT INTO iby_risk_formula_item

126: CLOSE c_factor_id;
127:
128: -- insert the record into iby_risk_formula_item;
129:
130: INSERT INTO iby_risk_formula_item
131: (risk_factor_id, risk_formula_id,
132: weight,object_version_number,
133: last_update_date, last_updated_by,
134: creation_date, created_by)

Line 213: DELETE iby_risk_formula_item

209: END IF;
210:
211: -- Delete Existing Factors.
212:
213: DELETE iby_risk_formula_item
214: WHERE risk_formula_id = i_id;
215:
216: -- Insert new Factors.
217:

Line 235: -- insert the record into iby_risk_formula_item;

231: END IF;
232:
233: CLOSE c_factor_id;
234:
235: -- insert the record into iby_risk_formula_item;
236:
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)

Line 237: INSERT INTO iby_risk_formula_item

233: CLOSE c_factor_id;
234:
235: -- insert the record into iby_risk_formula_item;
236:
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);

Line 276: -- delete the FAcotr items from the iby_risk_formula_item.

272: PROCEDURE deleteFOrmula( i_id in integer)
273: IS
274: BEGIN
275:
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

Line 277: DELETE iby_risk_formula_item

273: IS
274: BEGIN
275:
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

Line 310: CURSOR c_factor(ci_factorid iby_risk_formula_item.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
312: FROM iby_risk_factors irf, iby_risk_formula_item irft
313: WHERE irft.risk_formula_id = i_formulaId
314: AND irf.risk_factor_id = irft.risk_factor_id;

Line 312: FROM iby_risk_factors irf, iby_risk_formula_item irft

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
312: FROM iby_risk_factors irf, iby_risk_formula_item irft
313: WHERE irft.risk_formula_id = i_formulaId
314: AND irf.risk_factor_id = irft.risk_factor_id;
315:
316: l_cnt integer;