APPS.ARP_DISCOUNTS_API dependencies on AR_PAYMENT_SCHEDULES

Line 36: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

32:
33: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
34: /*Bug 5223829 introduced new parameter for iReceivables*/
35: PROCEDURE get_discount (
36: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
37: p_apply_date IN DATE,
38: p_in_applied_amount IN NUMBER,
39: p_grace_days_flag IN VARCHAR2,
40: p_out_discount OUT NOCOPY NUMBER,

Line 45: p_ps_rec ar_payment_schedules%ROWTYPE;

41: p_out_rem_amt_rcpt OUT NOCOPY NUMBER,
42: p_out_rem_amt_inv OUT NOCOPY NUMBER,
43: P_called_from IN VARCHAR2) IS
44:
45: p_ps_rec ar_payment_schedules%ROWTYPE;
46: p_disc_rec arp_calculate_discount.discount_record_type;
47:
48: l_grace_days NUMBER;
49: l_customer_id NUMBER;

Line 68: l_amt_in_dispute ar_payment_schedules.amount_in_dispute%TYPE; /*Bug 5223829*/

64: l_out_amt_to_apply NUMBER;
65: l_cash_receipt_id NUMBER;
66: l_site_level_profile BOOLEAN; -- Bug 3866488
67: l_amt_due_rem NUMBER; /*Bug 5223829*/
68: l_amt_in_dispute ar_payment_schedules.amount_in_dispute%TYPE; /*Bug 5223829*/
69:
70: BEGIN
71: IF PG_DEBUG in ('Y', 'C') THEN
72: arp_standard.debug( 'arp_discounts_api.get_discount() +');

Line 88: FROM ar_payment_schedules

84: -- available for the Customer.
85: BEGIN
86: SELECT customer_id, customer_site_use_id
87: INTO l_customer_id, l_site_use_id
88: FROM ar_payment_schedules
89: WHERE payment_schedule_id = p_ps_id;
90:
91: EXCEPTION
92: WHEN NO_DATA_FOUND THEN

Line 279: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,

275: | |
276: +===========================================================================*/
277:
278: PROCEDURE get_max_discount (
279: p_ps_id IN ar_payment_schedules.payment_schedule_id%TYPE,
280: p_apply_date IN DATE,
281: p_grace_days_flag IN VARCHAR2,
282: p_out_discount OUT NOCOPY NUMBER,
283: p_out_applied_amt OUT NOCOPY NUMBER) IS

Line 285: p_ps_rec ar_payment_schedules%ROWTYPE;

281: p_grace_days_flag IN VARCHAR2,
282: p_out_discount OUT NOCOPY NUMBER,
283: p_out_applied_amt OUT NOCOPY NUMBER) IS
284:
285: p_ps_rec ar_payment_schedules%ROWTYPE;
286: p_disc_rec arp_calculate_discount.discount_record_type;
287:
288: p_mode NUMBER;
289: l_customer_id NUMBER;

Line 310: FROM ar_payment_schedules

306: -- available for the Customer.
307: BEGIN
308: SELECT customer_id, customer_site_use_id
309: INTO l_customer_id, l_site_use_id
310: FROM ar_payment_schedules
311: WHERE payment_schedule_id = p_ps_id;
312:
313: EXCEPTION
314: WHEN NO_DATA_FOUND THEN