APPS.JL_AR_RECEIVABLE_APPLICATIONS dependencies on AR_PAYMENT_SCHEDULES

Line 208: FROM ar_payment_schedules

204: BEGIN
205: x_return := 0;
206: SELECT amount_due_original, amount_due_remaining
207: INTO x_amount_due_original, x_amount_due_remaining
208: FROM ar_payment_schedules
209: WHERE payment_schedule_id = x_payment_schedule_id;
210: EXCEPTION
211: WHEN NO_DATA_FOUND THEN x_return := -1;
212: END get_ps_parameters;

Line 738: x_org_id ar_payment_schedules.org_id%TYPE;

734: x_trx_type_idm NUMBER;
735: x_batch_source_idm NUMBER;
736: x_receipt_method_idm NUMBER;
737: x_exit_status NUMBER;
738: x_org_id ar_payment_schedules.org_id%TYPE;
739: errcode NUMBER;
740: l_ps_rec ar_payment_schedules%ROWTYPE;
741:
742: BEGIN

Line 740: l_ps_rec ar_payment_schedules%ROWTYPE;

736: x_receipt_method_idm NUMBER;
737: x_exit_status NUMBER;
738: x_org_id ar_payment_schedules.org_id%TYPE;
739: errcode NUMBER;
740: l_ps_rec ar_payment_schedules%ROWTYPE;
741:
742: BEGIN
743:
744: IF PG_DEBUG in ('Y', 'C') THEN

Line 761: FROM ar_payment_schedules

757: /* Bug 2374054 : Multiorg changes */
758: BEGIN
759: SELECT org_id
760: INTO x_org_id
761: FROM ar_payment_schedules
762: WHERE payment_schedule_id = p_applied_payment_schedule_id;
763: EXCEPTION
764: WHEN OTHERS THEN
765: IF PG_DEBUG in ('Y', 'C') THEN

Line 848: FROM ar_payment_schedules

844: SELECT amount_due_remaining,
845: global_attribute7
846: INTO x_amount_due_remaining,
847: p_global_attribute11
848: FROM ar_payment_schedules
849: WHERE payment_schedule_id = p_applied_payment_schedule_id;
850:
851: EXCEPTION
852: WHEN OTHERS THEN

Line 983: /* UPDATE ar_payment_schedules

979: END IF;
980:
981: ELSIF p_apply_before_after = 'AFTER' THEN
982:
983: /* UPDATE ar_payment_schedules
984: SET global_attribute1 = p_global_attribute1,
985: global_attribute2 = p_global_attribute2,
986: global_attribute3 = p_global_attribute3,
987: global_attribute4 = p_global_attribute4,

Line 1035: l_ps_rec ar_payment_schedules%ROWTYPE;

1031: x_int_writeoff_reason VARCHAR2(30);
1032: x_payment_date VARCHAR2(30);
1033: x_writeoff_date VARCHAR2(80);
1034: x_error_code NUMBER;
1035: l_ps_rec ar_payment_schedules%ROWTYPE;
1036:
1037: BEGIN
1038:
1039: IF PG_DEBUG in ('Y', 'C') THEN

Line 1076: /* UPDATE ar_payment_schedules

1072: x_error_code);
1073:
1074: IF x_error_code = 0 then
1075:
1076: /* UPDATE ar_payment_schedules
1077: SET global_attribute1 = x_main_amnt_rec,
1078: global_attribute2 = x_base_int_calc,
1079: global_attribute3 = x_calculated_interest,
1080: global_attribute4 = x_received_interest,

Line 1139: l_ps_rec ar_payment_schedules%ROWTYPE;

1135: x_writeoff_date VARCHAR2(30);
1136:
1137: x_error_code NUMBER;
1138: x_interest_reversal BOOLEAN;
1139: l_ps_rec ar_payment_schedules%ROWTYPE;
1140:
1141: BEGIN
1142:
1143: IF PG_DEBUG in ('Y', 'C') THEN

Line 1181: /* UPDATE ar_payment_schedules

1177: x_writeoff_date,
1178: x_error_code);
1179:
1180: IF x_error_code = 0 then
1181: /* UPDATE ar_payment_schedules
1182: SET global_attribute1 = x_main_amnt_rec,
1183: global_attribute2 = x_base_int_calc,
1184: global_attribute3 = x_calculated_interest,
1185: global_attribute4 = x_received_interest,

Line 1463: l_ps_rec ar_payment_schedules%ROWTYPE;

1459: x_return varchar2(1);
1460: l_error_code NUMBER;
1461: l_error_msg VARCHAR2(2000);
1462: l_error_token VARCHAR2(100);
1463: l_ps_rec ar_payment_schedules%ROWTYPE;
1464: l_payment_action VARCHAR2(100);
1465: l_calendar_name VARCHAR2(100);
1466: l_pay_sch_id NUMBER;
1467: l_cash_rec_id NUMBER;

Line 1559: ar_payment_schedules arps

1555: l_amount_due_remaining,
1556: l_cust_trx_id,
1557: l_payment_amount
1558: FROM ra_customer_trx ract,
1559: ar_payment_schedules arps
1560: WHERE arps.payment_schedule_id = rint.applied_payment_schedule_id
1561: AND ract.customer_trx_id = arps.customer_trx_id;
1562:
1563: fnd_file.put_line(fnd_file.log,'calc int'||rint.global_attribute1);