DBA Data[Home] [Help]

APPS.AR_BILLS_CREATION_PUB dependencies on ARP_PS_PKG

Line 546: arp_ps_pkg.lock_p(l_ps_rec.payment_schedule_id);

542:
543: IF (l_trh_rec.status not in (C_INCOMPLETE, C_PENDING_ACCEPTANCE, C_CANCELLED))
544: THEN
545: AR_BILLS_CREATION_LIB_PVT.Get_Payment_Schedule_Id (p_customer_trx_id, l_ps_rec.payment_schedule_id);
546: arp_ps_pkg.lock_p(l_ps_rec.payment_schedule_id);
547: arp_ps_pkg.set_to_dummy (l_ps_rec);
548: l_ps_rec.due_date := l_trx_rec.term_due_date;
549: arp_ps_pkg.update_p (l_ps_rec, l_ps_rec.payment_schedule_id);
550: END IF;

Line 547: arp_ps_pkg.set_to_dummy (l_ps_rec);

543: IF (l_trh_rec.status not in (C_INCOMPLETE, C_PENDING_ACCEPTANCE, C_CANCELLED))
544: THEN
545: AR_BILLS_CREATION_LIB_PVT.Get_Payment_Schedule_Id (p_customer_trx_id, l_ps_rec.payment_schedule_id);
546: arp_ps_pkg.lock_p(l_ps_rec.payment_schedule_id);
547: arp_ps_pkg.set_to_dummy (l_ps_rec);
548: l_ps_rec.due_date := l_trx_rec.term_due_date;
549: arp_ps_pkg.update_p (l_ps_rec, l_ps_rec.payment_schedule_id);
550: END IF;
551: ELSE

Line 549: arp_ps_pkg.update_p (l_ps_rec, l_ps_rec.payment_schedule_id);

545: AR_BILLS_CREATION_LIB_PVT.Get_Payment_Schedule_Id (p_customer_trx_id, l_ps_rec.payment_schedule_id);
546: arp_ps_pkg.lock_p(l_ps_rec.payment_schedule_id);
547: arp_ps_pkg.set_to_dummy (l_ps_rec);
548: l_ps_rec.due_date := l_trx_rec.term_due_date;
549: arp_ps_pkg.update_p (l_ps_rec, l_ps_rec.payment_schedule_id);
550: END IF;
551: ELSE
552: ARP_PROC_TRANSACTION_HISTORY.update_transaction_history (l_trh_rec,
553: l_trh_rec.transaction_history_id);

Line 564: arp_ps_pkg.lock_p(l_ps_rec.payment_schedule_id);

560:
561: IF (l_trh_rec.status not in (C_INCOMPLETE, C_PENDING_ACCEPTANCE, C_CANCELLED))
562: THEN
563: AR_BILLS_CREATION_LIB_PVT.Get_Payment_Schedule_Id (p_customer_trx_id, l_ps_rec.payment_schedule_id);
564: arp_ps_pkg.lock_p(l_ps_rec.payment_schedule_id);
565: arp_ps_pkg.set_to_dummy (l_ps_rec);
566: l_ps_rec.cust_trx_type_id := l_trx_rec.cust_trx_type_id ;
567: l_ps_rec.due_date := l_trx_rec.term_due_date ;
568: l_ps_rec.gl_date := l_trh_rec.gl_date ;

Line 565: arp_ps_pkg.set_to_dummy (l_ps_rec);

561: IF (l_trh_rec.status not in (C_INCOMPLETE, C_PENDING_ACCEPTANCE, C_CANCELLED))
562: THEN
563: AR_BILLS_CREATION_LIB_PVT.Get_Payment_Schedule_Id (p_customer_trx_id, l_ps_rec.payment_schedule_id);
564: arp_ps_pkg.lock_p(l_ps_rec.payment_schedule_id);
565: arp_ps_pkg.set_to_dummy (l_ps_rec);
566: l_ps_rec.cust_trx_type_id := l_trx_rec.cust_trx_type_id ;
567: l_ps_rec.due_date := l_trx_rec.term_due_date ;
568: l_ps_rec.gl_date := l_trh_rec.gl_date ;
569: l_ps_rec.customer_site_use_id := l_trx_rec.drawee_site_use_id ;

Line 571: arp_ps_pkg.update_p (l_ps_rec, l_ps_rec.payment_schedule_id);

567: l_ps_rec.due_date := l_trx_rec.term_due_date ;
568: l_ps_rec.gl_date := l_trh_rec.gl_date ;
569: l_ps_rec.customer_site_use_id := l_trx_rec.drawee_site_use_id ;
570: l_ps_rec.trx_date := l_trx_rec.trx_date ;
571: arp_ps_pkg.update_p (l_ps_rec, l_ps_rec.payment_schedule_id);
572: END IF;
573:
574:
575:

Line 1206: arp_ps_pkg.fetch_p (p_br_ref_payment_schedule_id, l_ps_rec);

1202:
1203:
1204: -- Fetch the payment schedule information of the exchanged transaction
1205:
1206: arp_ps_pkg.fetch_p (p_br_ref_payment_schedule_id, l_ps_rec);
1207:
1208: -- Fetch the exchanged transaction information
1209:
1210: ARP_CT_PKG.fetch_p (l_trx_rec, l_ps_rec.customer_trx_id);

Line 1531: arp_ps_pkg.fetch_p (l_trl_rec.br_ref_payment_schedule_id, l_ps_rec);

1527:
1528:
1529: -- Fetch the payment schedule information of the exchanged transaction
1530:
1531: arp_ps_pkg.fetch_p (l_trl_rec.br_ref_payment_schedule_id, l_ps_rec);
1532:
1533:
1534: -- Fetch the exchanged transaction information
1535: