APPS.IBY_EVAL_AR_FACTORS_PKG dependencies on IBY_MAPPINGS

Line 277: ** stored in iby_mappings and return the appropriate risk score.

273: ** Purpose: Evaluates the risk associated with CreditRating Code risk factor.
274: ** The accountnumber will be passed into this routine
275: ** Based on the account number get the associated creditrating code
276: ** and compare the creditrating code with the creditratingcode mapping
277: ** stored in iby_mappings and return the appropriate risk score.
278: */
279:
280: Procedure eval_CreditRatingCode(i_accountnumber in varchar2,
281: i_payeeid in varchar2,

Line 302: ** Get the mapping creditrating_code from iby_mappings table

298: a.status = 'A' and
299: p.site_use_id is null and
300: a.cust_account_id = p.cust_account_id;
301: /*
302: ** Get the mapping creditrating_code from iby_mappings table
303: */
304: cursor c_get_mapping_code_value(ci_creditratingcode in varchar2, ci_payeeid in varchar2) is
305: select m.value
306: from iby_mappings m

Line 306: from iby_mappings m

302: ** Get the mapping creditrating_code from iby_mappings table
303: */
304: cursor c_get_mapping_code_value(ci_creditratingcode in varchar2, ci_payeeid in varchar2) is
305: select m.value
306: from iby_mappings m
307: where m.mapping_code = ci_creditratingcode and
308: m.mapping_type = 'CREDIT_CODE_TYPE' and
309: ((payeeid is null and ci_payeeid is null) or (m.payeeid = ci_payeeid));
310: begin

Line 345: from iby_mappings

341: ** creditrating codes.
342: ** if not then set payeeid to null
343: */
344: select count(1) into l_cnt
345: from iby_mappings
346: where mapping_type = 'CREDIT_CODE_TYPE'
347: and payeeid = i_payeeid;
348:
349: if (l_cnt = 0) then

Line 369: ** get the riskscore value associated with the riskscore from iby_mappings

365: if (c_get_mapping_code_value%notfound) then
366: o_risk_score := 0;
367: else
368: /*
369: ** get the riskscore value associated with the riskscore from iby_mappings
370: */
371: o_risk_score := iby_risk_scores_pkg.getscore(i_payeeid,l_risk_score_code);
372: end if;
373: close c_get_mapping_code_value;

Line 384: ** stored in iby_mappings and return the appropriate risk score.

380: ** Purpose: Evaluates the risk associated with Risk Code risk factor.
381: ** The accountnumber will be passed into this routine
382: ** Based on the account number get the associated risk code
383: ** and compare the riskcode with the riskcode mapping
384: ** stored in iby_mappings and return the appropriate risk score.
385: */
386:
387: procedure eval_RiskCode(i_accountnumber in varchar2,
388: i_payeeid in varchar2,

Line 409: ** Get the mapping risk_code from iby_mappings table

405: a.status = 'A' and
406: p.site_use_id is null and
407: a.cust_account_id = p.cust_account_id;
408: /*
409: ** Get the mapping risk_code from iby_mappings table
410: */
411: cursor c_get_mapping_code_value(ci_riskcode in varchar2, ci_payeeid in varchar2) is
412: select m.value
413: from iby_mappings m

Line 413: from iby_mappings m

409: ** Get the mapping risk_code from iby_mappings table
410: */
411: cursor c_get_mapping_code_value(ci_riskcode in varchar2, ci_payeeid in varchar2) is
412: select m.value
413: from iby_mappings m
414: where m.mapping_code = ci_riskcode and
415: m.mapping_type = 'RISK_CODE_TYPE' and
416: ((m.payeeid is null and ci_payeeid is null) or (m.payeeid = ci_payeeid));
417:

Line 453: from iby_mappings

449: ** for RISKcodes.
450: ** if not the set payeeid to null.
451: */
452: select count(1) into l_cnt
453: from iby_mappings
454: where mapping_type = 'RISK_CODE_TYPE'
455: and payeeid = i_payeeid;
456:
457: if (l_cnt = 0) then

Line 472: ** get the riskscore value associated with the riskscore from iby_mappings

468: if (c_get_mapping_code_value%notfound) then
469: o_risk_score := 0;
470: else
471: /*
472: ** get the riskscore value associated with the riskscore from iby_mappings
473: */
474: o_risk_score := iby_risk_scores_pkg.getscore(i_payeeid, l_riskscore_code);
475: end if;
476: