APPS.AR_ADJUST_PUB dependencies on AR_PAYMENT_SCHEDULES

Line 82: l_ps_rec ar_payment_schedules%rowtype;

78: p_llca_from_call IN varchar2 DEFAULT 'N'
79: ) IS
80:
81: l_return_status varchar2(1);
82: l_ps_rec ar_payment_schedules%rowtype;
83: l_prorated_tax NUMBER;
84: l_prorated_amt NUMBER;
85: l_error_num NUMBER;
86:

Line 563: l_ps_rec ar_payment_schedules%rowtype;

559: p_chk_approval_limits IN varchar2,
560: p_validation_status IN OUT NOCOPY varchar2
561: ) IS
562:
563: l_ps_rec ar_payment_schedules%rowtype;
564: l_approved_flag varchar2(1);
565: l_temp_adj_rec ar_adjustments%rowtype;
566: l_return_status varchar2(1);
567: l_cash_receipt_id ar_receivable_applications.cash_receipt_id%TYPE;

Line 658: FROM ar_payment_schedules

654: BEGIN
655:
656: SELECT *
657: INTO l_ps_rec
658: FROM ar_payment_schedules
659: WHERE payment_schedule_id = p_old_adj_rec.payment_schedule_id;
660:
661: EXCEPTION
662: WHEN NO_DATA_FOUND THEN

Line 909: l_ps_rec ar_payment_schedules%rowtype;

905: p_reversal_date IN OUT NOCOPY date,
906: p_validation_status IN OUT NOCOPY varchar2
907: ) IS
908:
909: l_ps_rec ar_payment_schedules%rowtype;
910: l_return_status varchar2(1);
911:
912: BEGIN
913:

Line 958: FROM ar_payment_schedules

954: BEGIN
955:
956: SELECT *
957: INTO l_ps_rec
958: FROM ar_payment_schedules
959: WHERE payment_schedule_id = p_old_adj_rec.payment_schedule_id;
960:
961: EXCEPTION
962: WHEN NO_DATA_FOUND THEN

Line 1053: l_ps_rec ar_payment_schedules%rowtype;

1049: p_chk_approval_limits IN varchar2,
1050: p_validation_status IN OUT NOCOPY varchar2
1051: ) IS
1052:
1053: l_ps_rec ar_payment_schedules%rowtype;
1054: l_approved_flag varchar2(1);
1055: l_temp_adj_rec ar_adjustments%rowtype;
1056: l_return_status varchar2(1);
1057:

Line 1122: FROM ar_payment_schedules

1118: BEGIN
1119:
1120: SELECT *
1121: INTO l_ps_rec
1122: FROM ar_payment_schedules
1123: WHERE payment_schedule_id = p_old_adj_rec.payment_schedule_id;
1124:
1125: EXCEPTION
1126: WHEN NO_DATA_FOUND THEN

Line 1481: from ar_payment_schedules

1477:
1478:
1479: /* Multiple Installment transaction not allowed at line-level */
1480: select count(*) into ll_installment
1481: from ar_payment_schedules
1482: where class in ('INV','DM')
1483: and customer_trx_id = p_adj_rec.customer_trx_id;
1484:
1485: IF nvl(ll_installment,0) > 1

Line 1643: l_app_ps_rec ar_payment_schedules%rowtype;

1639: l_hsec VARCHAR2(10);
1640: l_status number;
1641:
1642: l_inp_adj_rec ar_adjustments%rowtype;
1643: l_app_ps_rec ar_payment_schedules%rowtype;
1644:
1645: o_adjustment_number ar_adjustments.adjustment_number%type;
1646: o_adjustment_id ar_adjustments.adjustment_id%type;
1647: l_return_status varchar2(1);

Line 2145: l_app_ps_rec ar_payment_schedules%rowtype;

2141: l_hsec VARCHAR2(10);
2142: l_status number;
2143:
2144: l_inp_adj_rec ar_adjustments%rowtype;
2145: l_app_ps_rec ar_payment_schedules%rowtype;
2146:
2147: o_adjustment_number ar_adjustments.adjustment_number%type;
2148: o_adjustment_id ar_adjustments.adjustment_id%type;
2149: l_return_status varchar2(1);