APPS.AR_MRC_ENGINE2 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 24

 |   p_event_mode          IN     event to preform on MRC tables (INSERT/UPDATE)
 |   p_table_name          IN     Base Table Name.
 |   p_key_value           IN     primary key value (USED IN SINGLE MODE)
 |   p_row_info            IN     AR_DISTRIBTIONS%ROWTYPE
 |   p_mode                IN     SINGLE or BATCH MODE
 |   p_key_value_list      IN     Used in Batch Mode (list of values)
 |
 |  KNOWN ISSUES:
 |
 |  NOTES:   DELETES TO THIS TABLES WILL NOT BE PROCESSED IN THIS MODULE
 |           THEY ARE HANDLED THE SAME FOR ALL TABLES AND WILL BE PROCESSED
 |           IN THE ORIGINAL AR_MRC_ENGINE
 |
 |  MODIFICATION HISTORY
 |  Date        Author                  Description of Change
 |  04/25/02    Debbie Sue Jancis  	Created
 *============================================================================*/
PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');

Line: 165

 |                 This procedure will be called by auto receipts to insert
 |                 records into MRC tables using BULK processing
 |
 |  CALLS PROCEDURES / FUNCTIONS
 |
 |  ar_mc_info.rec_mrc_bulk_process    (MRC bulk processing API
 |                                      called from Auto Receipts
 |                                      for ar_cash_Receipts,
 |                                      ar_cash_Receipt_history,
 |                                      and ar_payment_schedules inserts)
 |  PARAMETERS
 |     p_prog_name           IN   VARCHAR   (AUTOREC)
 |     p_request_id          IN   VARCHAR2
 |     p_batch_id            IN   VARCHAR2
 |     p_confirmed_flag      IN   VARCHAR2
 |     p_history_status      IN   VARCHAR2
 |
 |  KNOWN ISSUES:
 |
 |  NOTES:
 |  MODIFICATION HISTORY
 |  Date        Author                  Description of Change
 |  07/24/02    Debbie Sue Jancis       Created
 *============================================================================*/
PROCEDURE  mrc_bulk_process(
                   p_prog_name        IN VARCHAR2,
                   p_created_from     IN VARCHAR2,
                   p_request_id       IN VARCHAR2,
                   p_batch_id         IN VARCHAR2,
                   p_confirmed_flag   IN VARCHAR2,
                   p_history_status   IN VARCHAR2)
IS

BEGIN
--{BUG#4301323
NULL;