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.AR_AUTOREC_API dependencies on AR_PAYMENT_SCHEDULES

Line 334: update ar_payment_schedules

330:
331: END IF;
332:
333:
334: update ar_payment_schedules
335: set selected_for_receipt_batch_id = o_batch_id
336: where payment_schedule_id in (select PAYMENT_SCHEDULE_ID from AR_RECEIPTS_GT);
337:
338: arp_standard.debug ( 'NO of PS rows updated = '|| to_char(SQL%ROWCOUNT));

Line 404: update ar_payment_schedules

400:
401: END IF;
402:
403:
404: update ar_payment_schedules
405: set selected_for_receipt_batch_id = o_batch_id
406: where payment_schedule_id in (select PAYMENT_SCHEDULE_ID from AR_RECEIPTS_GT);
407:
408: arp_standard.debug ( 'NO of PS rows updated = '|| to_char(SQL%ROWCOUNT));

Line 868: update AR_payment_schedules SET

864:
865: arp_standard.debug ( 'NO of Receipts updated CRH = '|| to_char(SQL%ROWCOUNT));
866:
867:
868: update AR_payment_schedules SET
869: created_by = l_created_by,
870: last_update_date = sysdate,
871: last_updated_by = l_created_by,
872: last_update_login = l_last_update_login,

Line 898: update ar_payment_schedules

894: select cash_receipt_id from
895: AR_RECEIPTS_GT);
896:
897: /* UPDATING INVOICE PS 7271561*/
898: update ar_payment_schedules
899: set selected_for_receipt_batch_id = NULL
900: where payment_schedule_id in (select PAYMENT_SCHEDULE_ID from AR_RECEIPTS_GT);
901:
902: IF l_rec_creation_rule_code = 'PER_INVOICE' AND

Line 909: ar_payment_schedules ps

905: receipt_number = nvl((
906: select ps.trx_number
907: from
908: ar_receivable_applications app,
909: ar_payment_schedules ps
910: where
911: app.cash_receipt_id = cr.cash_receipt_id
912: and ps.customer_trx_id = app.applied_customer_trx_id
913: and app.status = 'APP'

Line 1187: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,

1183: | 16-JUL-2005 bichatte Created |
1184: *=========================================================================*/
1185:
1186: PROCEDURE select_valid_invoices(
1187: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
1188: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
1189: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
1190: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
1191: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,

Line 1188: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,

1184: *=========================================================================*/
1185:
1186: PROCEDURE select_valid_invoices(
1187: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
1188: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
1189: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
1190: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
1191: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
1192: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,

Line 1189: p_due_date_l IN ar_payment_schedules.due_date%TYPE,

1185:
1186: PROCEDURE select_valid_invoices(
1187: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
1188: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
1189: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
1190: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
1191: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
1192: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
1193: p_doc_num_l IN ra_customer_trx.doc_sequence_value%TYPE,

Line 1190: p_due_date_h IN ar_payment_schedules.due_date%TYPE,

1186: PROCEDURE select_valid_invoices(
1187: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
1188: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
1189: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
1190: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
1191: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
1192: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
1193: p_doc_num_l IN ra_customer_trx.doc_sequence_value%TYPE,
1194: p_doc_num_h IN ra_customer_trx.doc_sequence_value%TYPE,

Line 1191: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,

1187: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
1188: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
1189: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
1190: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
1191: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
1192: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
1193: p_doc_num_l IN ra_customer_trx.doc_sequence_value%TYPE,
1194: p_doc_num_h IN ra_customer_trx.doc_sequence_value%TYPE,
1195: p_customer_number_l IN hz_cust_accounts.account_number%TYPE, --Bug6734688

Line 1192: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,

1188: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
1189: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
1190: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
1191: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
1192: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
1193: p_doc_num_l IN ra_customer_trx.doc_sequence_value%TYPE,
1194: p_doc_num_h IN ra_customer_trx.doc_sequence_value%TYPE,
1195: p_customer_number_l IN hz_cust_accounts.account_number%TYPE, --Bug6734688
1196: p_customer_number_h IN hz_cust_accounts.account_number%TYPE, --Bug6734688

Line 1202: p_payment_schedule_id OUT NOCOPY ar_payment_schedules.payment_schedule_id%TYPE,

1198: p_customer_name_h IN hz_parties.party_name%TYPE, --Bug6734688
1199: p_batch_id IN ar_batches.batch_id%TYPE,
1200: p_approve_only_flag IN VARCHAR2 ,--Bug5344405
1201: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
1202: p_payment_schedule_id OUT NOCOPY ar_payment_schedules.payment_schedule_id%TYPE,
1203: p_customer_trx_id OUT NOCOPY ar_payment_schedules.customer_trx_id%TYPE,
1204: p_cash_receipt_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
1205: p_paying_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,
1206: p_paying_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,

Line 1203: p_customer_trx_id OUT NOCOPY ar_payment_schedules.customer_trx_id%TYPE,

1199: p_batch_id IN ar_batches.batch_id%TYPE,
1200: p_approve_only_flag IN VARCHAR2 ,--Bug5344405
1201: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
1202: p_payment_schedule_id OUT NOCOPY ar_payment_schedules.payment_schedule_id%TYPE,
1203: p_customer_trx_id OUT NOCOPY ar_payment_schedules.customer_trx_id%TYPE,
1204: p_cash_receipt_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
1205: p_paying_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,
1206: p_paying_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
1207: p_payment_server_order_num OUT NOCOPY ra_customer_trx.payment_server_order_num%TYPE,

Line 1205: p_paying_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,

1201: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
1202: p_payment_schedule_id OUT NOCOPY ar_payment_schedules.payment_schedule_id%TYPE,
1203: p_customer_trx_id OUT NOCOPY ar_payment_schedules.customer_trx_id%TYPE,
1204: p_cash_receipt_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
1205: p_paying_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,
1206: p_paying_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
1207: p_payment_server_order_num OUT NOCOPY ra_customer_trx.payment_server_order_num%TYPE,
1208: p_due_date OUT NOCOPY ar_payment_schedules.due_date%TYPE,
1209: p_amount_due_remaining OUT NOCOPY ar_payment_schedules.amount_due_remaining%TYPE,

Line 1208: p_due_date OUT NOCOPY ar_payment_schedules.due_date%TYPE,

1204: p_cash_receipt_id OUT NOCOPY ar_cash_receipts.cash_receipt_id%TYPE,
1205: p_paying_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,
1206: p_paying_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
1207: p_payment_server_order_num OUT NOCOPY ra_customer_trx.payment_server_order_num%TYPE,
1208: p_due_date OUT NOCOPY ar_payment_schedules.due_date%TYPE,
1209: p_amount_due_remaining OUT NOCOPY ar_payment_schedules.amount_due_remaining%TYPE,
1210: p_cust_bank_account_id OUT NOCOPY ra_customer_trx.customer_bank_account_id%TYPE,
1211: p_cust_min_amt OUT NOCOPY hz_cust_profile_amts.auto_rec_min_receipt_amount%TYPE,
1212: p_payment_trxn_extension_id OUT NOCOPY ra_customer_trx.payment_trxn_extension_id%TYPE,

Line 1209: p_amount_due_remaining OUT NOCOPY ar_payment_schedules.amount_due_remaining%TYPE,

1205: p_paying_customer_id OUT NOCOPY ar_payment_schedules.customer_id%TYPE,
1206: p_paying_site_use_id OUT NOCOPY hz_cust_site_uses.site_use_id%TYPE,
1207: p_payment_server_order_num OUT NOCOPY ra_customer_trx.payment_server_order_num%TYPE,
1208: p_due_date OUT NOCOPY ar_payment_schedules.due_date%TYPE,
1209: p_amount_due_remaining OUT NOCOPY ar_payment_schedules.amount_due_remaining%TYPE,
1210: p_cust_bank_account_id OUT NOCOPY ra_customer_trx.customer_bank_account_id%TYPE,
1211: p_cust_min_amt OUT NOCOPY hz_cust_profile_amts.auto_rec_min_receipt_amount%TYPE,
1212: p_payment_trxn_extension_id OUT NOCOPY ra_customer_trx.payment_trxn_extension_id%TYPE,
1213: p_payment_channel_code OUT NOCOPY ar_receipt_methods.payment_channel_code%TYPE,

Line 1305: ar_payment_schedules ps,

1301: ra_customer_trx ct,
1302: iby_fndcpt_tx_extensions x,
1303: iby_pmt_instr_uses_all u,
1304: iby_fndcpt_pmt_chnnls_b p,
1305: ar_payment_schedules ps,
1306: ar_payment_schedules_all ps1 ';
1307: --Bug6734688
1308: IF p_customer_number_l IS NOT NULL OR p_customer_number_h IS NOT NULL
1309: OR p_customer_name_l IS NOT NULL OR p_customer_name_h IS NOT NULL THEN

Line 1306: ar_payment_schedules_all ps1 ';

1302: iby_fndcpt_tx_extensions x,
1303: iby_pmt_instr_uses_all u,
1304: iby_fndcpt_pmt_chnnls_b p,
1305: ar_payment_schedules ps,
1306: ar_payment_schedules_all ps1 ';
1307: --Bug6734688
1308: IF p_customer_number_l IS NOT NULL OR p_customer_number_h IS NOT NULL
1309: OR p_customer_name_l IS NOT NULL OR p_customer_name_h IS NOT NULL THEN
1310: l_sel_stmt := l_sel_stmt|| ', hz_cust_accounts cust_acct ';

Line 1670: from ar_payment_schedules ps,

1666: l_discount_taken_unearned,
1667: l_discount_taken_earned,
1668: l_trx_exchange_rate,
1669: l_allow_overappln_flag
1670: from ar_payment_schedules ps,
1671: ra_cust_trx_types ctt
1672: where ps.payment_schedule_id = l_applied_payment_schedule_id
1673: AND ps.cust_trx_type_id = ctt.cust_trx_type_id;
1674:

Line 1928: from ar_payment_schedules ps

1924: arp_standard.debug ('receipt_inherit_inv_num_flag : Y');
1925:
1926: update ar_receipts_gt arg
1927: set receipt_number = (select trx_number||decode(terms_sequence_number,1,'','-'||terms_sequence_number)
1928: from ar_payment_schedules ps
1929: where ps.payment_schedule_id = arg.payment_schedule_id
1930: and rownum = 1)
1931: where payment_schedule_id > 0;
1932:

Line 2008: Update ar_payment_schedules set selected_for_receipt_batch_id = null

2004: p_paying_customer_id =>R2.pay_cust_id,
2005: p_exception_code => l_err_code ,
2006: p_additional_message => l_err_code
2007: );
2008: Update ar_payment_schedules set selected_for_receipt_batch_id = null
2009: where payment_schedule_id in (select payment_schedule_id from ar_receipts_gt
2010: where receipt_number = R2.rec_num);
2011: Update ar_receipts_gt set payment_schedule_id = -99999 where receipt_number = R2.rec_num;
2012: END IF;

Line 2026: from ar_payment_schedules

2022: IF l_err_code <> 'ARZCAR_CUST_MIN_AMT' OR l_err_code IS NULL THEN -- Condition as per Bug:5346610
2023:
2024: select nvl(terms_sequence_number,1)
2025: into l_installment
2026: from ar_payment_schedules
2027: where payment_schedule_id = R2.payment_schedule_id;
2028:
2029:
2030: arp_standard.debug( 'l_installment = '|| l_installment);

Line 2069: Update ar_payment_schedules set selected_for_receipt_batch_id = null

2065: and payment_schedule_id = R2.payment_schedule_id;
2066: END IF;
2067: IF l_return_status <> 'S' THEN
2068: /*bug7117223 start*/
2069: Update ar_payment_schedules set selected_for_receipt_batch_id = null
2070: where payment_schedule_id in (select payment_schedule_id from ar_receipts_gt
2071: where receipt_number = R2.rec_num
2072: and customer_trx_id = R2.customer_trx_id
2073: and payment_schedule_id = R2.payment_schedule_id);

Line 2306: Update ar_payment_schedules set selected_for_receipt_batch_id = null

2302: p_additional_message => l_err_code
2303: );
2304: END LOOP;
2305: END;
2306: Update ar_payment_schedules set selected_for_receipt_batch_id = null
2307: where payment_schedule_id in (select payment_schedule_id from ar_receipts_gt
2308: where receipt_number = R1.rec_num);
2309: Update ar_receipts_gt set payment_schedule_id = -99999 where receipt_number = R1.rec_num;
2310: END IF;

Line 2367: Update ar_payment_schedules set selected_for_receipt_batch_id = null

2363: where receipt_number = R1.rec_num;
2364: END IF;
2365: IF l_return_status <> 'S' THEN
2366: /*bug7117223 start*/
2367: Update ar_payment_schedules set selected_for_receipt_batch_id = null
2368: where payment_schedule_id in (select payment_schedule_id from ar_receipts_gt
2369: where receipt_number = R1.rec_num);
2370: Update ar_receipts_gt set payment_schedule_id = -99999 where receipt_number = R1.rec_num;
2371: /*bug7117223 end*/

Line 2595: Update ar_payment_schedules set selected_for_receipt_batch_id = null

2591: );
2592: END LOOP;
2593: END;
2594:
2595: Update ar_payment_schedules set selected_for_receipt_batch_id = null
2596: where payment_schedule_id in (select payment_schedule_id from ar_receipts_gt
2597: where receipt_number = R3.rec_num);
2598: Update ar_receipts_gt set payment_schedule_id = -99999 where receipt_number = R3.rec_num;
2599: END IF;

Line 2657: Update ar_payment_schedules set selected_for_receipt_batch_id = null

2653: where receipt_number = R3.rec_num;
2654: END IF;
2655: IF l_return_status <> 'S' THEN
2656: /*bug7117223 start*/
2657: Update ar_payment_schedules set selected_for_receipt_batch_id = null
2658: where payment_schedule_id in (select payment_schedule_id from ar_receipts_gt
2659: where receipt_number = R3.rec_num);
2660: Update ar_receipts_gt set payment_schedule_id = -99999 where receipt_number = R3.rec_num;
2661: /*bug7117223 end*/

Line 2882: Update ar_payment_schedules set selected_for_receipt_batch_id = null

2878: );
2879: END LOOP;
2880: END;
2881:
2882: Update ar_payment_schedules set selected_for_receipt_batch_id = null
2883: where payment_schedule_id in (select payment_schedule_id from ar_receipts_gt
2884: where receipt_number = R4.rec_num);
2885: Update ar_receipts_gt set payment_schedule_id = -99999 where receipt_number = R4.rec_num;
2886: END IF;

Line 2947: Update ar_payment_schedules set selected_for_receipt_batch_id = null

2943: where receipt_number = R4.rec_num;
2944: END IF;
2945: IF l_return_status <> 'S' THEN
2946: /*bug7117223 start*/
2947: Update ar_payment_schedules set selected_for_receipt_batch_id = null
2948: where payment_schedule_id in (select payment_schedule_id from ar_receipts_gt
2949: where receipt_number = R4.rec_num);
2950: Update ar_receipts_gt set payment_schedule_id = -99999 where receipt_number = R4.rec_num;
2951: /*bug7117223 end*/

Line 3171: Update ar_payment_schedules set selected_for_receipt_batch_id = null

3167: p_additional_message => l_err_code
3168: );
3169: END LOOP;
3170: END;
3171: Update ar_payment_schedules set selected_for_receipt_batch_id = null
3172: where payment_schedule_id in (select payment_schedule_id from ar_receipts_gt
3173: where receipt_number = R5.rec_num);
3174: Update ar_receipts_gt set payment_schedule_id = -99999 where receipt_number = R5.rec_num;
3175: END IF;

Line 3234: Update ar_payment_schedules set selected_for_receipt_batch_id = null

3230: where receipt_number = R5.rec_num;
3231: END IF;
3232: IF l_return_status <> 'S' THEN
3233: /*bug7117223 start*/
3234: Update ar_payment_schedules set selected_for_receipt_batch_id = null
3235: where payment_schedule_id in (select payment_schedule_id from ar_receipts_gt
3236: where receipt_number = R5.rec_num);
3237: Update ar_receipts_gt set payment_schedule_id = -99999 where receipt_number = R5.rec_num;
3238: /*bug7117223 end*/

Line 3456: Update ar_payment_schedules set selected_for_receipt_batch_id = null

3452: p_additional_message => l_err_code
3453: );
3454: END LOOP;
3455: END;
3456: Update ar_payment_schedules set selected_for_receipt_batch_id = null
3457: where payment_schedule_id in (select payment_schedule_id from ar_receipts_gt
3458: where receipt_number = R6.rec_num);
3459: Update ar_receipts_gt set payment_schedule_id = -99999 where receipt_number = R6.rec_num;
3460: END IF;

Line 3506: Update ar_payment_schedules set selected_for_receipt_batch_id = null

3502: where receipt_number = R6.rec_num;
3503: END IF;
3504: IF l_return_status <> 'S' THEN
3505: /*bug7117223 start*/
3506: Update ar_payment_schedules set selected_for_receipt_batch_id = null
3507: where payment_schedule_id in (select payment_schedule_id from ar_receipts_gt
3508: where receipt_number = R6.rec_num);
3509: Update ar_receipts_gt set payment_schedule_id = -99999 where receipt_number = R6.rec_num;
3510: /*bug7117223 end*/

Line 3721: Update ar_payment_schedules set selected_for_receipt_batch_id = null

3717: p_additional_message => l_err_code
3718: );
3719: END LOOP;
3720: END;
3721: Update ar_payment_schedules set selected_for_receipt_batch_id = null
3722: where payment_schedule_id in (select payment_schedule_id from ar_receipts_gt
3723: where receipt_number = R7.rec_num);
3724: Update ar_receipts_gt set payment_schedule_id = -99999 where receipt_number = R7.rec_num;
3725: END IF;

Line 3771: Update ar_payment_schedules set selected_for_receipt_batch_id = null

3767: where receipt_number = R7.rec_num;
3768: END IF;
3769: IF l_return_status <> 'S' THEN
3770: /*bug7117223 start*/
3771: Update ar_payment_schedules set selected_for_receipt_batch_id = null
3772: where payment_schedule_id in (select payment_schedule_id from ar_receipts_gt
3773: where receipt_number = R7.rec_num);
3774: Update ar_receipts_gt set payment_schedule_id = -99999 where receipt_number = R7.rec_num;
3775: /*bug7117223 end*/

Line 3987: Update ar_payment_schedules set selected_for_receipt_batch_id = null

3983: p_additional_message => l_err_code
3984: );
3985: END LOOP;
3986: END;
3987: Update ar_payment_schedules set selected_for_receipt_batch_id = null
3988: where payment_schedule_id in (select payment_schedule_id from ar_receipts_gt
3989: where receipt_number = R8.rec_num);
3990: Update ar_receipts_gt set payment_schedule_id = -99999 where receipt_number = R8.rec_num;
3991: END IF;

Line 4036: Update ar_payment_schedules set selected_for_receipt_batch_id = null

4032: where receipt_number = R8.rec_num;
4033: END IF;
4034: IF l_return_status <> 'S' THEN
4035: /*bug7117223 start*/
4036: Update ar_payment_schedules set selected_for_receipt_batch_id = null
4037: where payment_schedule_id in (select payment_schedule_id from ar_receipts_gt
4038: where receipt_number = R8.rec_num);
4039: Update ar_receipts_gt set payment_schedule_id = -99999 where receipt_number = R8.rec_num;
4040: /*bug7117223 end*/

Line 4139: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,

4135: PROCEDURE insert_exceptions(
4136: p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL,
4137: p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,
4138: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
4139: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
4140: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
4141: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,
4142: p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
4143: p_cust_min_rec_amount IN NUMBER DEFAULT NULL,

Line 4142: p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,

4138: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
4139: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
4140: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
4141: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,
4142: p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
4143: p_cust_min_rec_amount IN NUMBER DEFAULT NULL,
4144: p_bank_min_rec_amount IN NUMBER DEFAULT NULL,
4145: p_exception_code IN VARCHAR2,
4146: p_additional_message IN VARCHAR2

Line 4559: from ar_payment_schedules ps,

4555: nvl(ps.terms_sequence_number,1) inst_num,
4556: ps.customer_trx_id trx_id,
4557: r.receipt_number rec_num,
4558: r.cash_receipt_id rec_id
4559: from ar_payment_schedules ps,
4560: ra_customer_trx trx,
4561: ar_receipts_gt r
4562: where trx.customer_trx_id = ps.customer_trx_id
4563: and trx.cc_error_flag = 'Y'

Line 4747: update ar_payment_schedules

4743: END;
4744: /* End of delete XLA events code */
4745:
4746:
4747: update ar_payment_schedules
4748: set selected_for_receipt_batch_id = null,
4749: gl_date_closed = TO_DATE('4712/12/31', 'YYYY/MM/DD'),
4750: status = 'OP'
4751: where payment_schedule_id in (

Line 4753: from ar_payment_schedules ps,

4749: gl_date_closed = TO_DATE('4712/12/31', 'YYYY/MM/DD'),
4750: status = 'OP'
4751: where payment_schedule_id in (
4752: select ps.payment_schedule_id
4753: from ar_payment_schedules ps,
4754: ra_customer_trx trx
4755: where trx.customer_trx_id = ps.customer_trx_id
4756: and trx.cc_error_flag = 'Y'
4757: and trx.request_id = l_request_id);

Line 4763: delete from ar_payment_schedules

4759: IF PG_DEBUG in ('Y','C') THEN
4760: arp_standard.debug ( ' rows updated PS = ' || SQL%ROWCOUNT );
4761: END IF;
4762:
4763: delete from ar_payment_schedules
4764: where cash_receipt_id in (select distinct cash_receipt_id
4765: from ar_autorec_exceptions
4766: where request_id = l_request_id);
4767: