APPS.IBY_FACTOR_PKG dependencies on IBY_IRF_TIMEOF_PURCHASE

Line 212: delete from iby_irf_timeof_purchase

208: -- loop through the list of ranges passed and update
209: -- the database.
210:
211: -- delete all the ranges
212: delete from iby_irf_timeof_purchase
213: where ( ( payeeid = i_payeeid ) or
214: ( i_payeeid is null and payeeid is null ) );
215:
216: while ( i <= i_count ) loop

Line 226: insert into iby_irf_timeof_purchase

222: l_score := i_timeRanges(i).score;
223: i := i+1;
224:
225: -- insert the ranges into database based on the sequence.
226: insert into iby_irf_timeof_purchase
227: ( duration_from ,duration_to, score, seq,
228: payeeid , object_version_number,
229: last_update_date, last_updated_by, creation_date, created_by)
230: values ( l_lowerLimit, l_upperLimit, l_score, l_seq,

Line 285: from iby_irf_timeof_purchase

281:
282:
283: cursor c_load_ranges(ci_payeeid VARCHAR2) is
284: select duration_from, duration_to, seq, score
285: from iby_irf_timeof_purchase
286: where (( payeeid is null and ci_payeeid is null ) or
287: ( payeeid = ci_payeeid))
288: order by seq;
289:

Line 292: from iby_irf_timeof_purchase

288: order by seq;
289:
290: cursor c_ranges_count(ci_payeeid VARCHAR2) is
291: select count(*)
292: from iby_irf_timeof_purchase
293: where payeeid = ci_payeeid;
294:
295: begin
296: