APPS.IBY_FACTOR_PKG dependencies on IBY_IRF_PMT_FREQUENCY

Line 1316: update iby_irf_pmt_frequency

1312:
1313: -- update the FreqOfPurchase information. If payeeid is not null
1314: -- and payeeid does not have configured information then
1315: -- insert the configuration information.
1316: update iby_irf_pmt_frequency
1317: set duration = i_duration,
1318: duration_type = i_durationType,
1319: frequency = i_frequency,
1320: last_update_date = sysdate,

Line 1328: insert into iby_irf_pmt_frequency ( duration, duration_type,

1324:
1325: -- if no data configured.
1326: if ( SQL%ROWCOUNT = 0 ) then
1327: -- insert the data.
1328: insert into iby_irf_pmt_frequency ( duration, duration_type,
1329: frequency, payeeid, object_version_number,
1330: last_update_date, last_updated_by, creation_date, created_by)
1331: values ( i_duration, i_durationType, i_frequency, i_payeeid,1,
1332: sysdate, fnd_global.user_id, sysdate, fnd_global.user_id);

Line 1381: from iby_irf_pmt_frequency

1377:
1378:
1379: cursor c_pmt_freq(ci_payeeid varchar2) is
1380: select duration, duration_type, frequency
1381: from iby_irf_pmt_frequency
1382: where (( payeeid is null and ci_payeeid is null ) or
1383: ( payeeid = ci_payeeid));
1384:
1385: cursor c_pmt_freq_count(ci_payeeid varchar2) is

Line 1387: from iby_irf_pmt_frequency

1383: ( payeeid = ci_payeeid));
1384:
1385: cursor c_pmt_freq_count(ci_payeeid varchar2) is
1386: select count(*)
1387: from iby_irf_pmt_frequency
1388: where payeeid = ci_payeeid;
1389:
1390: begin
1391: