eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_AR_RECEIVABLE_APPLICATIONS dependencies on AR_PAYMENT_SCHEDULES

Line 50: x_org_id ar_payment_schedules.org_id%TYPE;

46: x_rec_date_char VARCHAR2(10);
47: x_rec_workdate_char VARCHAR2(10);
48: x_rec_workdate DATE;
49: x_check_date_return_code NUMBER(1);
50: x_org_id ar_payment_schedules.org_id%TYPE;
51:
52:
53: BEGIN
54:

Line 108: ar_payment_schedules arps,

104: hz_cust_acct_sites ad,
105: hz_party_sites pty,
106: ra_customer_trx ract,
107: hz_cust_site_uses rasu,
108: ar_payment_schedules arps,
109: jl_br_ar_collection_docs dc
110: WHERE dc.payment_schedule_id = x_payment_schedule_id
111: AND arps.payment_schedule_id = dc.payment_schedule_id
112: AND ract.customer_trx_id = arps.customer_trx_id

Line 122: ar_payment_schedules arps,

118: SELECT distinct nvl(arrma.floating,0)
119: INTO x_floating
120: FROM ar_receipt_methods arrm,
121: ar_system_parameters arsp,
122: ar_payment_schedules arps,
123: jl_br_ar_collection_docs dc,
124: jl_br_ar_rec_met_accts_ext arrma
125: WHERE dc.payment_schedule_id = x_payment_schedule_id
126: AND arps.payment_schedule_id = dc.payment_schedule_id

Line 322: FROM ar_payment_schedules

318: BEGIN
319: x_return := 0;
320: SELECT amount_due_original, amount_due_remaining
321: INTO x_amount_due_original, x_amount_due_remaining
322: FROM ar_payment_schedules
323: WHERE payment_schedule_id = x_payment_schedule_id;
324: EXCEPTION
325: WHEN NO_DATA_FOUND THEN x_return := -1;
326: END get_ps_parameters;

Line 852: x_org_id ar_payment_schedules.org_id%TYPE;

848: x_trx_type_idm NUMBER;
849: x_batch_source_idm NUMBER;
850: x_receipt_method_idm NUMBER;
851: x_exit_status NUMBER;
852: x_org_id ar_payment_schedules.org_id%TYPE;
853: errcode NUMBER;
854: l_ps_rec ar_payment_schedules%ROWTYPE;
855:
856: BEGIN

Line 854: l_ps_rec ar_payment_schedules%ROWTYPE;

850: x_receipt_method_idm NUMBER;
851: x_exit_status NUMBER;
852: x_org_id ar_payment_schedules.org_id%TYPE;
853: errcode NUMBER;
854: l_ps_rec ar_payment_schedules%ROWTYPE;
855:
856: BEGIN
857:
858: IF PG_DEBUG in ('Y', 'C') THEN

Line 875: FROM ar_payment_schedules

871: /* Bug 2374054 : Multiorg changes */
872: BEGIN
873: SELECT org_id
874: INTO x_org_id
875: FROM ar_payment_schedules
876: WHERE payment_schedule_id = p_applied_payment_schedule_id;
877: EXCEPTION
878: WHEN OTHERS THEN
879: IF PG_DEBUG in ('Y', 'C') THEN

Line 962: FROM ar_payment_schedules

958: SELECT amount_due_remaining,
959: global_attribute7
960: INTO x_amount_due_remaining,
961: p_global_attribute11
962: FROM ar_payment_schedules
963: WHERE payment_schedule_id = p_applied_payment_schedule_id;
964:
965: EXCEPTION
966: WHEN OTHERS THEN

Line 1097: /* UPDATE ar_payment_schedules

1093: END IF;
1094:
1095: ELSIF p_apply_before_after = 'AFTER' THEN
1096:
1097: /* UPDATE ar_payment_schedules
1098: SET global_attribute1 = p_global_attribute1,
1099: global_attribute2 = p_global_attribute2,
1100: global_attribute3 = p_global_attribute3,
1101: global_attribute4 = p_global_attribute4,

Line 1149: l_ps_rec ar_payment_schedules%ROWTYPE;

1145: x_int_writeoff_reason VARCHAR2(30);
1146: x_payment_date VARCHAR2(30);
1147: x_writeoff_date VARCHAR2(80);
1148: x_error_code NUMBER;
1149: l_ps_rec ar_payment_schedules%ROWTYPE;
1150:
1151: BEGIN
1152:
1153: IF PG_DEBUG in ('Y', 'C') THEN

Line 1190: /* UPDATE ar_payment_schedules

1186: x_error_code);
1187:
1188: IF x_error_code = 0 then
1189:
1190: /* UPDATE ar_payment_schedules
1191: SET global_attribute1 = x_main_amnt_rec,
1192: global_attribute2 = x_base_int_calc,
1193: global_attribute3 = x_calculated_interest,
1194: global_attribute4 = x_received_interest,

Line 1253: l_ps_rec ar_payment_schedules%ROWTYPE;

1249: x_writeoff_date VARCHAR2(30);
1250:
1251: x_error_code NUMBER;
1252: x_interest_reversal BOOLEAN;
1253: l_ps_rec ar_payment_schedules%ROWTYPE;
1254:
1255: BEGIN
1256:
1257: IF PG_DEBUG in ('Y', 'C') THEN

Line 1295: /* UPDATE ar_payment_schedules

1291: x_writeoff_date,
1292: x_error_code);
1293:
1294: IF x_error_code = 0 then
1295: /* UPDATE ar_payment_schedules
1296: SET global_attribute1 = x_main_amnt_rec,
1297: global_attribute2 = x_base_int_calc,
1298: global_attribute3 = x_calculated_interest,
1299: global_attribute4 = x_received_interest,

Line 1577: l_ps_rec ar_payment_schedules%ROWTYPE;

1573: x_return varchar2(1);
1574: l_error_code NUMBER;
1575: l_error_msg VARCHAR2(2000);
1576: l_error_token VARCHAR2(100);
1577: l_ps_rec ar_payment_schedules%ROWTYPE;
1578: l_payment_action VARCHAR2(100);
1579: l_calendar_name VARCHAR2(100);
1580: l_pay_sch_id NUMBER;
1581: l_cash_rec_id NUMBER;

Line 1673: ar_payment_schedules arps

1669: l_amount_due_remaining,
1670: l_cust_trx_id,
1671: l_payment_amount
1672: FROM ra_customer_trx ract,
1673: ar_payment_schedules arps
1674: WHERE arps.payment_schedule_id = rint.applied_payment_schedule_id
1675: AND ract.customer_trx_id = arps.customer_trx_id;
1676:
1677: fnd_file.put_line(fnd_file.log,'calc int'||rint.global_attribute1);