APPS.AR_TRX_GLOBAL_PROCESS_SALESCR SQL Statements

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

Line: 6

PROCEDURE INSERT_ROW (
        p_trx_salescredits_tbl         IN      AR_INVOICE_API_PUB.trx_salescredits_tbl_type,
        x_errmsg                    OUT NOCOPY  VARCHAR2,
        x_return_status             OUT NOCOPY  VARCHAR2
 ) IS

        RecExist            NUMBER;

Line: 17

        ar_invoice_utils.debug ('AR_TRX_GLOBAL_PROCESS_SALESCR.INSERT_ROW (+)');

Line: 33

        INSERT INTO ar_trx_salescredits_gt (
            trx_salescredit_id,
            trx_line_id,
            LAST_UPDATE_DATE,
            LAST_UPDATED_BY,
            CREATION_DATE,
            CREATED_BY,
            LAST_UPDATE_LOGIN,
            SALESREP_ID,
            SALESREP_NUM,
            SALES_CREDIT_TYPE_NAME,
            SALES_CREDIT_TYPE_ID,
            REVENUE_AMOUNT_SPLIT,
            REVENUE_PERCENT_SPLIT,
            NON_REVENUE_AMOUNT_SPLIT,
            NON_REVENUE_PERCENT_SPLIT,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            ORG_ID)
             VALUES (
            p_trx_salescredits_tbl(i).trx_salescredit_id,
            p_trx_salescredits_tbl(i).trx_line_id,
            sysdate, -- LAST_UPDATE_DATE,
            fnd_global.user_id, -- last_updated_by
            sysdate, --CREATION_DATE,
            fnd_global.user_id,-- CREATED_BY,
            fnd_global.login_id, --LAST_UPDATE_LOGIN,
            p_trx_salescredits_tbl(i).SALESREP_ID,
            p_trx_salescredits_tbl(i).SALESREP_NUMBER,
            p_trx_salescredits_tbl(i).SALES_CREDIT_TYPE_NAME,
            p_trx_salescredits_tbl(i).SALES_CREDIT_TYPE_ID,
            -- revenue
            DECODE(p_trx_salescredits_tbl(i).sales_credit_type_id, 1,
              p_trx_salescredits_tbl(i).salescredit_amount_split, NULL),
            DECODE(p_trx_salescredits_tbl(i).sales_credit_type_id, 1,
              p_trx_salescredits_tbl(i).salescredit_percent_split, NULL),
            -- non revenue
            DECODE(p_trx_salescredits_tbl(i).sales_credit_type_id, 2,
              p_trx_salescredits_tbl(i).salescredit_amount_split, NULL),
            DECODE(p_trx_salescredits_tbl(i).sales_credit_type_id, 2,
              p_trx_salescredits_tbl(i).salescredit_percent_split, NULL),
            p_trx_salescredits_tbl(i).ATTRIBUTE_CATEGORY,
            p_trx_salescredits_tbl(i).ATTRIBUTE1,
            p_trx_salescredits_tbl(i).ATTRIBUTE2,
            p_trx_salescredits_tbl(i).ATTRIBUTE3,
            p_trx_salescredits_tbl(i).ATTRIBUTE4,
            p_trx_salescredits_tbl(i).ATTRIBUTE5,
            p_trx_salescredits_tbl(i).ATTRIBUTE6,
            p_trx_salescredits_tbl(i).ATTRIBUTE7,
            p_trx_salescredits_tbl(i).ATTRIBUTE8,
            p_trx_salescredits_tbl(i).ATTRIBUTE9,
            p_trx_salescredits_tbl(i).ATTRIBUTE10,
            p_trx_salescredits_tbl(i).ATTRIBUTE11,
            p_trx_salescredits_tbl(i).ATTRIBUTE12,
            p_trx_salescredits_tbl(i).ATTRIBUTE13,
            p_trx_salescredits_tbl(i).ATTRIBUTE14,
            p_trx_salescredits_tbl(i).ATTRIBUTE15,
            arp_standard.sysparm.org_id);

Line: 111

        ar_invoice_utils.debug ('AR_TRX_GLOBAL_PROCESS_SALESCR.INSERT_ROW (-)');

Line: 115

                x_errmsg := 'Error in AR_TRX_GLOBAL_PROCESS_SALESCR.INSERT_ROW '||sqlerrm;

Line: 118

END INSERT_ROW;