DBA Data[Home] [Help]

APPS.AR_MRC_ENGINE3 SQL Statements

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

Line: 9

 |  PUBLIC PROCEDURE  Insert_ra_rec_cash
 |
 |  DESCRIPTION:
 |                This procedure will be called from ARP_PROC_RCT_UTIL
 |                to process the mrc data for insert.
 |
 |  CALLS PROCEDURES / FUNCTIONS (local to this package body)
 |
 |  PARAMETERS
 |      p_rec_app_id            IN NUMBER,
 |      p_rec_app_record        IN ar_receivable_applications%ROWTYPE
 |      p_cash_receipt_id       IN ar_cash_receipts.cash_receipt_id%TYPE
 |      p_amount                IN ar_cash_receipts.amount%TYPE
 |      p_payment_schedule_id   IN ar_payment_schedules.payment_schedule_id%TYPE
 |
 |  KNOWN ISSUES:
 |
 |  NOTES:
 |
 |  MODIFICATION HISTORY
 |  Date        Author                  Description of Change
 |  09/03/02    Debbie Sue Jancis  	Created
 *============================================================================*/
PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
Line: 34

PROCEDURE insert_ra_rec_cash(
        p_rec_app_id            IN NUMBER,
        p_rec_app_record        IN ar_receivable_applications%ROWTYPE,
        p_cash_receipt_id       IN ar_cash_receipts.cash_receipt_id%TYPE,
        p_amount                IN ar_cash_receipts.amount%TYPE,
        p_payment_schedule_id   IN ar_payment_schedules.payment_schedule_id%TYPE
                        ) IS
BEGIN
NULL;
Line: 96

END insert_ra_rec_cash;
Line: 103

 |                to process the mrc data for insert.
 |
 |  CALLS PROCEDURES / FUNCTIONS (local to this package body)
 |
 |  PARAMETERS
 |      p_rec_app_id            IN NUMBER,
 |      p_rec_unapp_id          IN NUMBER,
 |
 |  KNOWN ISSUES:
 |
 |  NOTES:
 |
 |  MODIFICATION HISTORY
 |  Date        Author                  Description of Change
 |  09/03/02    Debbie Sue Jancis  	Created
 *============================================================================*/
PROCEDURE create_matching_unapp_records(
        p_rec_app_id            IN NUMBER,
        p_rec_unapp_id          IN NUMBER
                        ) IS
BEGIN
NULL;
Line: 180

 |                to process the mrc data for insert.
 |
 |  CALLS PROCEDURES / FUNCTIONS (local to this package body)
 |
 |  PARAMETERS
 |      p_receipt_ps_id         IN NUMBER  - Receipt PS id
 |      p_invoice_ps_id         IN NUMBER  - Invoice PS id
 |      p_amount_applied        IN NUMBER
 |      p_amount_applied_from   IN NUMBER
 |      p_invoice_currency_code IN VARCHAR2
 |      p_receipt_currency_code IN VARCHAR2
 |      p_rec_ra_rec            IN receivable apps rowtype
 |      p_inv_ra_rec            IN receivable apps rowtype
 |
 |  KNOWN ISSUES:
 |
 |  NOTES:
 |
 |  MODIFICATION HISTORY
 |  Date        Author                  Description of Change
 |  09/04/02    Debbie Sue Jancis       Created
 *============================================================================*/
PROCEDURE receipt_application(
   p_receipt_ps_id      IN ar_payment_schedules.payment_schedule_id%TYPE,
   p_invoice_ps_id      IN ar_payment_schedules.payment_schedule_id%TYPE,
   p_amount_applied     IN ar_receivable_applications.amount_applied%TYPE,
   p_amount_applied_from IN ar_receivable_applications.amount_applied_from%TYPE,
   p_invoice_currency_code IN ar_payment_schedules.invoice_currency_code%TYPE,
   p_receipt_currency_code IN ar_cash_receipts.currency_code%TYPE,
   p_rec_ra_rec         IN ar_receivable_applications %ROWTYPE,
   p_inv_ra_rec         IN ar_receivable_applications %ROWTYPE
                        ) IS
BEGIN
NULL;
Line: 280

 |                to process the mrc data for insert.
 |
 |  CALLS PROCEDURES / FUNCTIONS (local to this package body)
 |
 |  PARAMETERS
 |      p_cm_ps_id         IN NUMBER  - credit memo PS id
 |      p_invoice_ps_id    IN NUMBER  - Invoice PS id
 |      p_inv_ra_rec       IN receivable apps rowtype
 |      p_ra_id            IN NUMBER receivable_application_id
 |  KNOWN ISSUES:
 |
 |  NOTES:
 |
 |
 |  MODIFICATION HISTORY
 |  Date        Author                  Description of Change
 |  09/04/02    Debbie Sue Jancis       Created
 *============================================================================*/
PROCEDURE cm_application(
   p_cm_ps_id       IN ar_payment_schedules.payment_schedule_id%TYPE,
   p_invoice_ps_id  IN ar_payment_schedules.payment_schedule_id%TYPE,
   p_inv_ra_rec     IN ar_receivable_applications %ROWTYPE,
   p_ra_id          IN NUMBER
                 ) IS

l_ra_rec  ar_receivable_applications%ROWTYPE;
Line: 373

 |                to process the mrc data for insert.
 |
 |  CALLS PROCEDURES / FUNCTIONS (local to this package body)
 |
 |  PARAMETERS
 |      p_receipt_ps_id    IN NUMBER  - receipt PS id
 |      p_amount_applied   IN NUMBER
 |      p_acc_ra_rec       IN receivables apps rowtype
 |      p_unapp_rec_app_id IN NUMBER
 |
 |  KNOWN ISSUES:
 |
 |  NOTES:
 |
 |
 |  MODIFICATION HISTORY
 |  Date        Author                  Description of Change
 |  09/04/02    Debbie Sue Jancis       Created
 *============================================================================*/
PROCEDURE on_account_receipts(
   p_receipt_ps_id       IN ar_payment_schedules.payment_schedule_id%TYPE,
   p_amount_applied      IN ar_receivable_applications.amount_applied%TYPE,
   p_acc_ra_rec          IN ar_receivable_applications %ROWTYPE,
   p_unapp_rec_app_id    IN NUMBER
                 ) IS
BEGIN
NULL;
Line: 457

 |                to process the mrc data for insert.
 |
 |  CALLS PROCEDURES / FUNCTIONS (local to this package body)
 |
 |  PARAMETERS
 |      p_receipt_ps_id    IN NUMBER  - receipt PS id
 |      p_amount_applied   IN NUMBER
 |      p_otheracc_ra_rec  IN receivables apps rowtype
 |      p_unapp_rec_app_id IN NUMBER
 |
 |  KNOWN ISSUES:
 |
 |  NOTES:
 |
 |
 |  MODIFICATION HISTORY
 |  Date        Author                  Description of Change
 |  09/04/02    Debbie Sue Jancis       Created
 *============================================================================*/
PROCEDURE other_account_application(
   p_receipt_ps_id       IN ar_payment_schedules.payment_schedule_id%TYPE,
   p_amount_applied      IN ar_receivable_applications.amount_applied%TYPE,
   p_otheracc_ra_rec     IN ar_receivable_applications %ROWTYPE,
   p_unapp_rec_app_id    IN NUMBER
                 ) IS
BEGIN
NULL;
Line: 537

 |  PUBLIC PROCEDURE  reversal_insert_oppos_ra_recs
 |
 |  DESCRIPTION:
 |                This procedure will be called from ARP_PROCESS_APPLICATION
 |                and ARP_RATE_ADJUSTMENTS
 |                to process the mrc data for insert.
 |
 |  CALLS PROCEDURES / FUNCTIONS (local to this package body)
 |
 |  PARAMETERS
 |      p_ra_rec           IN receivables apps rowtype
 |      p_orig_rec_app_id  IN NUMBER
 |      p_new_rec_app_id   IN NUMBER
 |
 |  KNOWN ISSUES:
 |
 |  NOTES:
 |
 |
 |  MODIFICATION HISTORY
 |  Date        Author                  Description of Change
 |  09/04/02    Debbie Sue Jancis       Created
 *============================================================================*/
PROCEDURE reversal_insert_oppos_ra_recs(
   p_ra_rec              IN ar_receivable_applications %ROWTYPE,
   p_orig_rec_app_id     IN NUMBER,
   p_new_rec_app_id      IN NUMBER
                 ) IS
BEGIN
NULL;
Line: 615

 END reversal_insert_oppos_ra_recs;
Line: 622

 |                to process the mrc data for insert.
 |
 |  CALLS PROCEDURES / FUNCTIONS (local to this package body)
 |
 |  PARAMETERS
 |      p_orig_app_id  IN NUMBER
 |      p_new_app_id   IN NUMBER
 |
 |  KNOWN ISSUES:
 |
 |  NOTES:
 |
 |
 |  MODIFICATION HISTORY
 |  Date        Author                  Description of Change
 |  09/04/02    Debbie Sue Jancis       Created
 *============================================================================*/
PROCEDURE reverse_ra_recs(
   p_orig_app_id     IN NUMBER,
   p_new_app_id      IN NUMBER
                 ) IS
BEGIN
NULL;
Line: 695

 |  PUBLIC PROCEDURE  confirm_ra_rec_update
 |
 |  DESCRIPTION:
 |                This procedure will be called from ARP_CONFIRMATION
 |                to process the mrc data for update.
 |
 |  CALLS PROCEDURES / FUNCTIONS (local to this package body)
 |
 |  PARAMETERS
 |      p_rec_app_id   IN NUMBER
 |
 |  KNOWN ISSUES:
 |
 |  NOTES:
 |
 |
 |  MODIFICATION HISTORY
 |  Date        Author                  Description of Change
 |  09/04/02    Debbie Sue Jancis       Created
 *============================================================================*/
PROCEDURE confirm_ra_rec_update(
   p_rec_app_id      IN NUMBER
                 ) IS
BEGIN
NULL;
Line: 764

 END confirm_ra_rec_update;
Line: 767

 |  PUBLIC PROCEDURE  update_cm_application
 |
 |  DESCRIPTION:
 |                This procedure will be called from PRO*C files in the
 |		  /src/paysched directory (araups.lpc and araupds.lpc)
 |                to process the mrc data for update.
 |
 |  CALLS PROCEDURES / FUNCTIONS (local to this package body)
 |
 |  PARAMETERS
 |      p_rec_app_id      IN NUMBER
 |      p_app_ps_id       IN NUMBER,
 |      p_ct_id           IN NUMBER,
 |      p_amount_applied  IN NUMBER
 |
 |  KNOWN ISSUES:
 |
 |  NOTES:
 |
 |
 |  MODIFICATION HISTORY
 |  Date        Author                  Description of Change
 |  09/04/02    Debbie Sue Jancis       Created
 *============================================================================*/
PROCEDURE update_cm_application(
   p_rec_app_id      IN NUMBER,
   p_app_ps_id       IN NUMBER,
   p_ct_id           IN NUMBER,
   p_amount_applied  IN NUMBER
                 ) IS
BEGIN
NULL;
Line: 849

 END update_cm_application;
Line: 852

 |  PUBLIC PROCEDURE  update_ra_rec_quickcash
 |
 |  DESCRIPTION:
 |                This procedure will be called from PRO*C files in the
 |                /src/cash directory
 |                to process the mrc data for update.
 |
 |  CALLS PROCEDURES / FUNCTIONS (local to this package body)
 |
 |  PARAMETERS
 |      p_rec_app_id      IN NUMBER
 |      p_cash_receipt_id IN NUMBER,
 |      p_amount_applied  IN NUMBER
 |
 |  KNOWN ISSUES:
 |
 |  NOTES:
 |
 |
 |  MODIFICATION HISTORY
 |  Date        Author                  Description of Change
 |  09/04/02    Debbie Sue Jancis       Created
 *============================================================================*/
PROCEDURE update_ra_rec_quickcash(
   p_rec_app_id      IN NUMBER,
   p_cash_receipt_id IN NUMBER,
   p_amount_applied  IN NUMBER
                 ) IS
BEGIN
NULL;
Line: 929

 END update_ra_rec_quickcash;
Line: 932

 |  PUBLIC PROCEDURE  insert_ra_rec_quickcash
 |
 |  DESCRIPTION:
 |                This procedure will be called from PRO*C files in the
 |                /src/cash directory
 |                to process the mrc data for insert.
 |
 |  CALLS PROCEDURES / FUNCTIONS (local to this package body)
 |
 |  PARAMETERS
 |      p_rec_app_id      IN NUMBER
 |
 |  KNOWN ISSUES:
 |
 |  NOTES:
 |
 |
 |  MODIFICATION HISTORY
 |  Date        Author                  Description of Change
 |  09/04/02    Debbie Sue Jancis       Created
 *============================================================================*/
PROCEDURE insert_ra_rec_quickcash(
   p_rec_app_id      IN NUMBER
                 ) IS
BEGIN
NULL;
Line: 1001

 END insert_ra_rec_quickcash;
Line: 1004

 |  PUBLIC PROCEDURE  update_selected_transaction
 |
 |  DESCRIPTION:
 |                This procedure will be called from
 |                ARP_PROCESS_APPLICATION(ARCEAPPB.pls)
 |                to process the mrc data for insert.
 |
 |  CALLS PROCEDURES / FUNCTIONS (local to this package body)
 |
 |  PARAMETERS
 |      pn_amount_applied IN NUMBER
 |      p_app_ra_rec      IN ar_receivable_applications%ROWTYPE
 |      p_unapp_ra_rec    IN ar_receivable_applications%ROWTYPE
 |
 |  KNOWN ISSUES:
 |
 |  NOTES:
 |
 |
 |  MODIFICATION HISTORY
 |  Date        Author                  Description of Change
 |  09/09/02    Debbie Sue Jancis       Created
 *============================================================================*/
PROCEDURE update_selected_transaction(
   pn_amount_applied   IN NUMBER,
   p_app_ra_rec        IN ar_receivable_applications%ROWTYPE,
   p_unapp_ra_rec      IN ar_receivable_applications%ROWTYPE
                 ) IS
BEGIN
NULL;
Line: 1078

 END update_selected_transaction;
Line: 1086

 |                to process the mrc data for insert.
 |
 |  CALLS PROCEDURES / FUNCTIONS (local to this package body)
 |
 |  PARAMETERS
 |      p_receipt_ps_id       IN ar_payment_schedules.payment_schedule_id%TYPE
 |      p_amount_applied      IN NUMBER
 |      p_application_ref_id  IN NUMBER
 |      p_misc_ref_id         IN NUMBER
 |      p_application_ps_id   IN NUMBER
 |      p_activity_ra_rec     IN ar_receivable_applications%ROWTYPE
 |      p_unapp_ra_rec        IN ar_receivable_applications%ROWTYPE
 |
 |  KNOWN ISSUES:
 |
 |  NOTES:
 |
 |
 |  MODIFICATION HISTORY
 |  Date        Author                  Description of Change
 |  09/09/02    Debbie Sue Jancis       Created
 *============================================================================*/
PROCEDURE activity_application(
        p_receipt_ps_id       IN ar_payment_schedules.payment_schedule_id%TYPE,
        p_amount_applied      IN NUMBER,
        p_application_ref_id  IN NUMBER,
        p_misc_ref_id         IN NUMBER,
        p_application_ps_id   IN NUMBER,
        p_activity_ra_rec     IN ar_receivable_applications%ROWTYPE,
        p_unapp_ra_rec        IN ar_receivable_applications%ROWTYPE
                 ) IS
BEGIN
NULL;
Line: 1174

 |  PUBLIC PROCEDURE  rate_adj_insert_rec
 |
 |  DESCRIPTION:
 |                This procedure will be called from
 |                ARP_RATE_ADJUSTMENT
 |                to process the mrc data for insert.
 |
 |  CALLS PROCEDURES / FUNCTIONS (local to this package body)
 |
 |  PARAMETERS
 |        p_app_ra_rec          IN AR_RECEIVABLE_APPLICATIONS%ROWTYPE
 |        p_unapp_ra_rec        IN AR_RECEIVABLE_APPLICATIONS%ROWTYPE
 |        p_rec_orig_app_id     IN NUMBER
 |        p_rec_app_id          IN NUMBER
 |        p_rec_unapp_id        IN NUMBER
 |        p_amt_due_remaining   IN NUMBER
 |
 |
 |  KNOWN ISSUES:
 |
 |  NOTES:
 |
 |  MODIFICATION HISTORY
 |  Date        Author                  Description of Change
 |  09/09/02    Debbie Sue Jancis       Created
 *============================================================================*/
PROCEDURE rate_adj_insert_rec (
          p_app_ra_rec          IN AR_RECEIVABLE_APPLICATIONS%ROWTYPE,
          p_unapp_ra_rec        IN AR_RECEIVABLE_APPLICATIONS%ROWTYPE,
          p_rec_orig_app_id     IN NUMBER,
          p_rec_app_id          IN NUMBER,
          p_rec_unapp_id        IN NUMBER,
          p_amt_due_remaining   IN NUMBER)  IS
BEGIN
NULL;
Line: 1259

 END rate_adj_insert_rec;
Line: 1267

 |                to process the mrc data for insert.
 |
 |  CALLS PROCEDURES / FUNCTIONS (local to this package body)
 |
 |  PARAMETERS
 |        p_rec_record          IN arp_confirmation.new_con_data
 |
 |
 |  KNOWN ISSUES:
 |
 |  NOTES:
 |
 |
 |  MODIFICATION HISTORY
 |  Date        Author                  Description of Change
 |  09/16/02    Debbie Sue Jancis       Created
 *============================================================================*/
PROCEDURE confirm_ra_rec_create(
          p_rec_record      IN ARP_CONFIRMATION.NEW_CON_DATA
                               )  IS
BEGIN
NULL;
Line: 1326

 |  PUBLIC PROCEDURE  update_ra_rec_cash_diff
 |
 |  DESCRIPTION:
 |                This procedure will be called from
 |                ARP_PROC_RECEIPTS1
 |                to process the mrc data for receivable applications
 |                this was created for bug 2576372.
 |
 |  CALLS PROCEDURES / FUNCTIONS (local to this package body)
 |
 |  PARAMETERS
 |        p_rec_app_id          IN NUMBER,
 |        p_cash_Receipt_id     IN ar_cash_Receipts.cash_Receipt_id%type
 |        p_diff_amount         IN ar_cash_Receipts.amount%TYPE
 |        p_old_rcpt_amount     IN ar_cash_Receipts.amount%TYPE
 |        p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE
 |
 |
 |  KNOWN ISSUES:
 |
 |  NOTES:
 |
 |
 |  MODIFICATION HISTORY
 |  Date        Author                  Description of Change
 |  09/20/02    Debbie Sue Jancis       Created
 *============================================================================*/
PROCEDURE update_ra_rec_cash_diff(
       p_rec_app_id          IN NUMBER,
       p_cash_receipt_id     IN ar_cash_receipts.cash_receipt_id%TYPE,
       p_diff_amount         IN ar_cash_receipts.amount%TYPE,
       p_old_rcpt_amount     IN ar_cash_receipts.amount%TYPE,
       p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE
                                 ) IS
BEGIN
NULL;
Line: 1408

END update_ra_rec_cash_diff;