APPS.ARP_REVERSE_RECEIPT dependencies on AR_BATCHES

Line 75: PROCEDURE modify_update_bat_rec( p_bat_id IN ar_batches.batch_id%TYPE,

71: p_cr_id IN ar_payment_schedules.cash_receipt_id%TYPE,
72: p_reversal_gl_date IN DATE,
73: p_reversal_date IN DATE );
74: --
75: PROCEDURE modify_update_bat_rec( p_bat_id IN ar_batches.batch_id%TYPE,
76: p_cr_amount IN ar_cash_receipts.amount%TYPE,
77: p_status IN VARCHAR2 );
78: --
79: PROCEDURE validate_dm_reversal_args(

Line 160: l_batches_rec ar_batches%ROWTYPE;

156: --
157: l_cr_rec ar_cash_receipts%ROWTYPE;
158: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
159: l_crh_rec ar_cash_receipt_history%ROWTYPE;
160: l_batches_rec ar_batches%ROWTYPE;
161: l_mcd_rec ar_misc_cash_distributions%ROWTYPE;
162: /*CCR-add cursor for receipt method pkt */
163:
164: --

Line 178: l_batch_id ar_batches.batch_id%TYPE;

174: l_actual_date_closed DATE;
175:
176: v_credit_card BOOLEAN; --CCRR pkt
177:
178: l_batch_id ar_batches.batch_id%TYPE;
179: ln_bal_due_remaining NUMBER; /* placeholder for bug 584303 */
180: l_return_status VARCHAR2(1);
181: l_msg_count NUMBER;
182: l_msg_data VARCHAR2(2000);

Line 1378: | Prepare for updation into AR_BATCHES table |

1374: | PROCEDURE |
1375: | modify_update_bat_rec |
1376: | |
1377: | DESCRIPTION |
1378: | Prepare for updation into AR_BATCHES table |
1379: | |
1380: | SCOPE - PRIVATE |
1381: | |
1382: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |

Line 1383: | arp_cr_batches_pkg.fetch_p - Fetch a row from AR_BATCHES row |

1379: | |
1380: | SCOPE - PRIVATE |
1381: | |
1382: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
1383: | arp_cr_batches_pkg.fetch_p - Fetch a row from AR_BATCHES row |
1384: | arp_cr_batches_pkg.update_p - Update a row in AR_BATCHES row |
1385: | |
1386: | ARGUMENTS : IN: |
1387: | p_bat_id - AR_BATCHES batch id |

Line 1384: | arp_cr_batches_pkg.update_p - Update a row in AR_BATCHES row |

1380: | SCOPE - PRIVATE |
1381: | |
1382: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
1383: | arp_cr_batches_pkg.fetch_p - Fetch a row from AR_BATCHES row |
1384: | arp_cr_batches_pkg.update_p - Update a row in AR_BATCHES row |
1385: | |
1386: | ARGUMENTS : IN: |
1387: | p_bat_id - AR_BATCHES batch id |
1388: | p_cr_amount - Cash receipt amount |

Line 1387: | p_bat_id - AR_BATCHES batch id |

1383: | arp_cr_batches_pkg.fetch_p - Fetch a row from AR_BATCHES row |
1384: | arp_cr_batches_pkg.update_p - Update a row in AR_BATCHES row |
1385: | |
1386: | ARGUMENTS : IN: |
1387: | p_bat_id - AR_BATCHES batch id |
1388: | p_cr_amount - Cash receipt amount |
1389: | p_status - Reversal category of receipt |
1390: | OUT: |
1391: | |

Line 1400: | ar_batches . |

1396: | MODIFICATION HISTORY - Created by Ganesh Vaidee - 04/25/95 |
1397: | |
1398: | 30-SEP-96 Shiv Ragunat Bug 398344, Commented Out NOCOPY Updation of |
1399: | Control_Count And Control_Amount in |
1400: | ar_batches . |
1401: | By definition - These 2 columns will no |
1402: | longer will be updated. |
1403: +===========================================================================*/
1404: PROCEDURE modify_update_bat_rec( p_bat_id IN ar_batches.batch_id%TYPE,

Line 1404: PROCEDURE modify_update_bat_rec( p_bat_id IN ar_batches.batch_id%TYPE,

1400: | ar_batches . |
1401: | By definition - These 2 columns will no |
1402: | longer will be updated. |
1403: +===========================================================================*/
1404: PROCEDURE modify_update_bat_rec( p_bat_id IN ar_batches.batch_id%TYPE,
1405: p_cr_amount IN ar_cash_receipts.amount%TYPE,
1406: p_status IN VARCHAR2 ) IS
1407: l_bat_rec ar_batches%ROWTYPE;
1408: l_status ar_batches.status%TYPE;

Line 1407: l_bat_rec ar_batches%ROWTYPE;

1403: +===========================================================================*/
1404: PROCEDURE modify_update_bat_rec( p_bat_id IN ar_batches.batch_id%TYPE,
1405: p_cr_amount IN ar_cash_receipts.amount%TYPE,
1406: p_status IN VARCHAR2 ) IS
1407: l_bat_rec ar_batches%ROWTYPE;
1408: l_status ar_batches.status%TYPE;
1409: BEGIN
1410: --
1411: IF PG_DEBUG in ('Y', 'C') THEN

Line 1408: l_status ar_batches.status%TYPE;

1404: PROCEDURE modify_update_bat_rec( p_bat_id IN ar_batches.batch_id%TYPE,
1405: p_cr_amount IN ar_cash_receipts.amount%TYPE,
1406: p_status IN VARCHAR2 ) IS
1407: l_bat_rec ar_batches%ROWTYPE;
1408: l_status ar_batches.status%TYPE;
1409: BEGIN
1410: --
1411: IF PG_DEBUG in ('Y', 'C') THEN
1412: arp_standard.debug( 'arp_reverse_receipt.modify_update_bat_rec() +');

Line 1422: FROM ar_batches

1418: --
1419: BEGIN
1420: SELECT *
1421: INTO l_bat_rec
1422: FROM ar_batches
1423: WHERE batch_id = p_bat_id;
1424: --
1425: EXCEPTION
1426: WHEN NO_DATA_FOUND THEN