APPS.IBY_FACTOR_PKG dependencies on IBY_IRF_TRXN_AMT_LIMIT

Line 373: update iby_irf_trxn_amt_limit

369:
370: -- update the transaction amount table.
371: -- this will be successful either payeeid is
372: -- null or the payeeid was configured some information.
373: update iby_irf_trxn_amt_limit
374: set duration = i_duration,
375: duration_type = i_durationType,
376: amount = i_amount,
377: last_update_date = sysdate,

Line 387: insert into iby_irf_trxn_amt_limit

383: -- this happens when save is called first time for certain
384: -- payeeid.
385: if ( SQL%ROWCOUNT = 0 ) then
386: -- insert the information.
387: insert into iby_irf_trxn_amt_limit
388: ( duration, duration_type, amount,
389: payeeid, object_version_number,
390: last_update_date, last_updated_by, creation_date, created_by)
391: values (i_duration, i_durationType, i_amount,

Line 443: from iby_irf_trxn_amt_limit

439:
440:
441: cursor c_trxn_amount_limit(ci_payeeid varchar2) is
442: select duration, duration_type, amount
443: from iby_irf_trxn_amt_limit
444: where (( payeeid is null and ci_payeeid is null ) or
445: ( payeeid = ci_payeeid));
446:
447: cursor c_trxn_amount_count(ci_payeeid varchar2) is

Line 449: from iby_irf_trxn_amt_limit

445: ( payeeid = ci_payeeid));
446:
447: cursor c_trxn_amount_count(ci_payeeid varchar2) is
448: select count(*)
449: from iby_irf_trxn_amt_limit
450: where payeeid = ci_payeeid;
451:
452: begin
453: