197: */
198:
199: /* Replaced Update by AR's table Handler. Bug # 2249731 */
200:
201: arp_ps_pkg.fetch_p(:new.payment_schedule_id, l_ps_rec);
202: arp_ps_pkg.lock_p(:new.payment_schedule_id);
203: l_ps_rec.global_attribute11 := NULL;
204: arp_ps_pkg.update_p(l_ps_rec, :new.payment_schedule_id);
205:
198:
199: /* Replaced Update by AR's table Handler. Bug # 2249731 */
200:
201: arp_ps_pkg.fetch_p(:new.payment_schedule_id, l_ps_rec);
202: arp_ps_pkg.lock_p(:new.payment_schedule_id);
203: l_ps_rec.global_attribute11 := NULL;
204: arp_ps_pkg.update_p(l_ps_rec, :new.payment_schedule_id);
205:
206: SELECT count(*)
200:
201: arp_ps_pkg.fetch_p(:new.payment_schedule_id, l_ps_rec);
202: arp_ps_pkg.lock_p(:new.payment_schedule_id);
203: l_ps_rec.global_attribute11 := NULL;
204: arp_ps_pkg.update_p(l_ps_rec, :new.payment_schedule_id);
205:
206: SELECT count(*)
207: INTO X_document_count
208: FROM jl_br_ar_collection_docs