DBA Data[Home] [Help]

APPS.AR_ADJUSTAPI_PUB dependencies on AR_PAYMENT_SCHEDULES

Line 68: l_ps_rec ar_payment_schedules%rowtype;

64: p_validation_status IN OUT NOCOPY varchar2
65: ) IS
66:
67: l_return_status varchar2(1);
68: l_ps_rec ar_payment_schedules%rowtype;
69: BEGIN
70:
71: IF PG_DEBUG in ('Y', 'C') THEN
72: arp_util.debug('Validate_Adj_Insert()+' , G_MSG_HIGH);

Line 352: l_ps_rec ar_payment_schedules%rowtype;

348: p_old_adj_rec IN ar_adjustments%rowtype,
349: p_validation_status IN OUT NOCOPY varchar2
350: ) IS
351:
352: l_ps_rec ar_payment_schedules%rowtype;
353: l_approved_flag varchar2(1);
354: l_temp_adj_rec ar_adjustments%rowtype;
355:
356: BEGIN

Line 410: FROM ar_payment_schedules

406: BEGIN
407:
408: SELECT *
409: INTO l_ps_rec
410: FROM ar_payment_schedules
411: WHERE payment_schedule_id = p_old_adj_rec.payment_schedule_id;
412:
413: EXCEPTION
414: WHEN NO_DATA_FOUND THEN

Line 569: l_ps_rec ar_payment_schedules%rowtype;

565: p_reversal_date IN OUT NOCOPY date,
566: p_validation_status IN OUT NOCOPY varchar2
567: ) IS
568:
569: l_ps_rec ar_payment_schedules%rowtype;
570:
571: BEGIN
572:
573: IF PG_DEBUG in ('Y', 'C') THEN

Line 619: FROM ar_payment_schedules

615: BEGIN
616:
617: SELECT *
618: INTO l_ps_rec
619: FROM ar_payment_schedules
620: WHERE payment_schedule_id = p_old_adj_rec.payment_schedule_id;
621:
622: EXCEPTION
623: WHEN NO_DATA_FOUND THEN

Line 709: l_ps_rec ar_payment_schedules%rowtype;

705: p_old_adj_rec IN ar_adjustments%rowtype,
706: p_validation_status IN OUT NOCOPY varchar2
707: ) IS
708:
709: l_ps_rec ar_payment_schedules%rowtype;
710: l_approved_flag varchar2(1);
711: l_temp_adj_rec ar_adjustments%rowtype;
712:
713: BEGIN

Line 777: FROM ar_payment_schedules

773: BEGIN
774:
775: SELECT *
776: INTO l_ps_rec
777: FROM ar_payment_schedules
778: WHERE payment_schedule_id = p_old_adj_rec.payment_schedule_id;
779:
780: EXCEPTION
781: WHEN NO_DATA_FOUND THEN