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.RA_LL_RCV_GROUPS_PKG SQL Statements

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

Line: 4


PROCEDURE Delete_Row (
    X_GROUP_ID  				 IN				 NUMBER,
    X_CUSTOMER_TRX_ID  				 IN				 NUMBER,
    X_CASH_RECEIPT_ID				 IN				 NUMBER
) IS
BEGIN

    DELETE AR_ACTIVITY_DETAILS
    WHERE  1 = 1
    AND CASH_RECEIPT_ID = X_CASH_RECEIPT_ID
    AND GROUP_ID = X_GROUP_ID
    AND NVL(CURRENT_ACTIVITY_FLAG, 'Y') = 'Y' -- BUG 7241111
    AND CUSTOMER_TRX_LINE_ID = (select customer_trx_line_id
                                from ra_customer_trx
                                where customer_trx_id = X_CUSTOMER_TRX_ID);

Line: 26


END Delete_Row;

Line: 28


PROCEDURE Insert_lintax_Rows (
    X_GROUP_ID          IN NUMBER,
    X_CASH_RECEIPT_ID   IN NUMBER,
    X_CUSTOMER_TRX_ID   IN NUMBER,
    X_lin               in number,
    x_tax               in number                ,
    X_lin_dsc           in number,
    x_tax_dsc           in number                ,
    x_CREATED_BY_MODULE in varchar2
    -- Oct 04 added two param below
    ,x_inv_to_rct_rate  in number default 1
    ,x_rct_curr_code    in varchar2 default arpcurr.FunctionalCurrency
) IS

cursor c_lintax
is
    select to_char(line.line_number) apply_to,
    line.customer_trx_line_id LINE_ID,
    -- No nvl needed in the foll amounts since arp_process_det_pkg.initialization
    -- would have updated the values to not-nulls
    line.source_data_key4 GROUP_ID ,
    line.amount_due_remaining line_rem,
    line.amount_due_original line_orig,
    tax.amount_due_remaining tax_rem,
    tax.amount_due_original tax_orig
  from ra_customer_trx_lines line,
  (select link_to_cust_trx_line_id,
          line_type,
          sum(nvl(amount_due_original,0)) amount_due_original,
          sum(nvl(amount_due_remaining,0)) amount_due_remaining
   from ra_customer_trx_lines
   where   nvl(line_type,'TAX') =  'TAX'
   group by link_to_cust_trx_line_id,
          line_type
  ) tax
  where line.line_type = 'LINE'
    and line.source_data_key4 = x_group_id
    and   line.customer_trx_line_id = tax.link_to_cust_trx_line_id (+)
    and line.customer_trx_id = x_customer_trx_id;

Line: 103


    select count(*) ,
    sum(nvl(line.amount_due_remaining,0)),
    sum(nvl(tax.amount_due_remaining,0)),
    sum(nvl(line.amount_due_original,0)),
    sum(nvl(tax.amount_due_original,0))
    into line_count,
         all_linrem_tot, all_taxrem_tot,
         all_linorig_tot, all_taxorig_tot
    from ra_customer_trx_lines line,
    (select link_to_cust_trx_line_id,
          line_type,
          sum(nvl(amount_due_original,0)) amount_due_original,
          sum(nvl(amount_due_remaining,0)) amount_due_remaining
     from ra_customer_trx_lines
     where nvl(line_type,'TAX') =  'TAX'
     group by link_to_cust_trx_line_id,
          line_type
    ) tax
    where line.customer_trx_id = x_customer_trx_id
    and line.line_type = 'LINE'
    and line.source_data_key4 = x_group_id
    and   line.customer_trx_line_id = tax.link_to_cust_trx_line_id (+)
    ;

Line: 129


                          'RA_LL_RCV_GROUPS_PKG.INSERT_ROW', 1);

Line: 199


                          'RA_LL_RCV_GROUPS_PKG.INSERT_ROW', 1);

Line: 201


    Select ar_Activity_details_s.nextval
     INTO l_line_id
     FROM DUAL;

Line: 205


    INSERT INTO AR_ACTIVITY_DETAILS (
        LINE_ID,
        APPLY_TO,
        customer_trx_line_id,
        CASH_RECEIPT_ID,
        GROUP_ID,
        AMOUNT,
        allocated_receipt_amount,
        TAX,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATE_LOGIN,
        LAST_UPDATE_DATE,
        LAST_UPDATED_BY,
        OBJECT_VERSION_NUMBER,
        CREATED_BY_MODULE,
        SOURCE_TABLE,
        line_discount,
        tax_discount,
	CURRENT_ACTIVITY_FLAG
    )

    VALUES (
        l_line_id,
        lintax_row.apply_to,
        lintax_row.line_id,
        DECODE(X_CASH_RECEIPT_ID, FND_API.G_MISS_NUM, NULL , X_CASH_RECEIPT_ID),
        DECODE(X_GROUP_ID, FND_API.G_MISS_NUM, NULL , X_GROUP_ID),
        arpcurr.currRound(nvl(line_2b_applied ,0)),
        arp_util.currRound(nvl(cross_currency_2b_applied,0), x_rct_curr_code ),
        arpcurr.currRound(nvl(tax_2b_applied ,0)),
        NVL(FND_GLOBAL.user_id,-1),
        SYSDATE,
        decode(FND_GLOBAL.conc_login_id,null,FND_GLOBAL.login_id,-1,
               FND_GLOBAL.login_id,FND_GLOBAL.conc_login_id),
        SYSDATE,
        NVL(FND_GLOBAL.user_id,-1),
        0, -- Object Version Number is zero when the insert is at the group level
        x_created_by_module,
        'RA',
        lindsc_2b_applied,
        taxdsc_2b_applied,
	'Y'
        );

Line: 258


END Insert_lintax_Rows;

Line: 271


PROCEDURE Insert_Row (
    X_ROWID			 IN OUT NOCOPY ROWID,
    X_CASH_RECEIPT_ID		 IN NUMBER,
    X_GROUP_ID     		 IN NUMBER,
    X_CUSTOMER_TRX_ID            IN NUMBER,
    X_line_only                  IN NUMBER,
    x_tax_only                   IN NUMBER,
    X_lin_dsc                in        number,
    x_tax_dsc             in number                ,
    x_CREATED_BY_MODULE          IN VARCHAR2
    -- Oct 04 added two param below
    ,x_inv_to_rct_rate in number default 1
    ,x_rct_curr_code in varchar2 default arpcurr.FunctionalCurrency
) IS
begin
        --insert_lintax_rows ( x_cash_receipt_id, x_customer_Trx_id, x_line_only, x_tax_only,
        --                x_lin_dsc, x_tax_dsc, x_created_by_module
        --                ,x_inv_to_rct_rate,x_rct_curr_code);

Line: 290


         Insert_lintax_Rows (
            X_CASH_RECEIPT_ID => X_CASH_RECEIPT_ID,
            X_GROUP_ID     	=> X_GROUP_ID,
            X_CUSTOMER_TRX_ID  =>    X_CUSTOMER_TRX_ID,
            x_lin               => x_line_only,
            x_tax                => x_tax_only,
            x_lin_dsc           => x_lin_dsc,
            x_tax_dsc           => x_tax_dsc,
            x_Created_By_Module => 'AR'
            -- Oct 04, 2005 Two params added below
            ,x_inv_to_rct_rate => x_inv_to_rct_rate
            ,x_rct_curr_code       => x_rct_curr_code);

Line: 306


PROCEDURE Update_Row (
    X_ROWID	         IN OUT NOCOPY  ROWID,
    X_CASH_RECEIPT_ID   IN NUMBER,
    X_GROUP_ID          IN NUMBER,
    X_CUSTOMER_TRX_ID   IN NUMBER,
    X_line_only         in number,
    x_tax_only          in number                ,
    X_lin_dsc                in        number,
    x_tax_dsc             in number                ,
    x_CREATED_BY_MODULE in varchar2
    -- Oct 04 added two param below
    ,x_inv_to_rct_rate  in number default 1
    ,x_rct_curr_code    in varchar2 := arpcurr.FunctionalCurrency
) IS
  p_rowid rowid;

Line: 322


  delete_Row (x_group_id => x_group_id,
            x_customer_trx_id => x_customer_trx_id,
            x_cash_receipt_id => x_cash_receipt_id);

Line: 325


  insert_Row (
    x_rowid => p_ROWID				   				 ,
    X_CASH_RECEIPT_ID => X_CASH_RECEIPT_ID			 				 ,
    X_GROUP_ID => X_GROUP_ID     				 				 ,
    X_CUSTOMER_TRX_ID => X_CUSTOMER_TRX_ID,
    X_line_only => X_line_only,
    x_tax_only => x_tax_only,
    X_lin_dsc => X_lin_dsc,
    x_tax_dsc => x_tax_dsc,
    x_created_by_module => x_created_by_module
            -- Oct 04, 2005 Two params added below
            ,x_inv_to_rct_rate =>x_inv_to_rct_rate
            ,x_rct_curr_code       =>x_rct_curr_code
);

Line: 340


END Update_Row;

Line: 344


PROCEDURE Select_Row (
    X_APPLY_TO     				 IN OUT NOCOPY				 VARCHAR2,
    X_TAX_BALANCE  				 IN OUT NOCOPY				 NUMBER,
    X_CUSTOMER_TRX_LINE_ID				 IN OUT NOCOPY				 NUMBER,
    X_COMMENTS     				 IN OUT NOCOPY				 VARCHAR2,
    X_TAX          				 IN OUT NOCOPY				 NUMBER,
    X_CASH_RECEIPT_ID				 IN OUT NOCOPY				 NUMBER,
    X_ATTRIBUTE_CATEGORY				 IN OUT NOCOPY				 VARCHAR2,
    X_ALLOCATED_RECEIPT_AMOUNT				 IN OUT NOCOPY				 NUMBER,
    X_GROUP_ID     				 IN OUT NOCOPY				 NUMBER,
    X_TAX_DISCOUNT 				 IN OUT NOCOPY				 NUMBER,
    X_AMOUNT       				 IN OUT NOCOPY				 NUMBER,
    X_LINE_DISCOUNT				 IN OUT NOCOPY				 NUMBER,
    X_ATTRIBUTE9   				 IN OUT NOCOPY				 VARCHAR2,
    X_ATTRIBUTE8   				 IN OUT NOCOPY				 VARCHAR2,
    X_ATTRIBUTE7   				 IN OUT NOCOPY				 VARCHAR2,
    X_ATTRIBUTE6   				 IN OUT NOCOPY				 VARCHAR2,
    X_ATTRIBUTE5   				 IN OUT NOCOPY				 VARCHAR2,
    X_ATTRIBUTE4   				 IN OUT NOCOPY				 VARCHAR2,
    X_ATTRIBUTE3   				 IN OUT NOCOPY				 VARCHAR2,
    X_ATTRIBUTE2   				 IN OUT NOCOPY				 VARCHAR2,
    X_ATTRIBUTE1   				 IN OUT NOCOPY				 VARCHAR2,
    X_LINE_BALANCE 				 IN OUT NOCOPY				 NUMBER,
    X_ATTRIBUTE15  				 IN OUT NOCOPY				 VARCHAR2,
    X_ATTRIBUTE14  				 IN OUT NOCOPY				 VARCHAR2,
    X_ATTRIBUTE13  				 IN OUT NOCOPY				 VARCHAR2,
    X_ATTRIBUTE12  				 IN OUT NOCOPY				 VARCHAR2,
    X_ATTRIBUTE11  				 IN OUT NOCOPY				 VARCHAR2,
    X_ATTRIBUTE10  				 IN OUT NOCOPY				 VARCHAR2
) IS


BEGIN

    SELECT
        NVL( APPLY_TO,FND_API.G_MISS_CHAR ),
        NVL( TAX_BALANCE,FND_API.G_MISS_NUM ),
        NVL( CUSTOMER_TRX_LINE_ID,FND_API.G_MISS_NUM ),
        NVL( COMMENTS,FND_API.G_MISS_CHAR ),
        NVL( TAX,FND_API.G_MISS_NUM ),
        NVL( CASH_RECEIPT_ID,FND_API.G_MISS_NUM ),
        NVL( ATTRIBUTE_CATEGORY,FND_API.G_MISS_CHAR ),
        NVL( ALLOCATED_RECEIPT_AMOUNT,FND_API.G_MISS_NUM ),
        NVL( GROUP_ID,FND_API.G_MISS_NUM ),
        NVL( TAX_DISCOUNT,FND_API.G_MISS_NUM ),
        NVL( AMOUNT,FND_API.G_MISS_NUM ),
        NVL( LINE_DISCOUNT,FND_API.G_MISS_NUM ),
        NVL( ATTRIBUTE9,FND_API.G_MISS_CHAR ),
        NVL( ATTRIBUTE8,FND_API.G_MISS_CHAR ),
        NVL( ATTRIBUTE7,FND_API.G_MISS_CHAR ),
        NVL( ATTRIBUTE6,FND_API.G_MISS_CHAR ),
        NVL( ATTRIBUTE5,FND_API.G_MISS_CHAR ),
        NVL( ATTRIBUTE4,FND_API.G_MISS_CHAR ),
        NVL( ATTRIBUTE3,FND_API.G_MISS_CHAR ),
        NVL( ATTRIBUTE2,FND_API.G_MISS_CHAR ),
        NVL( ATTRIBUTE1,FND_API.G_MISS_CHAR ),
        NVL( LINE_BALANCE,FND_API.G_MISS_NUM ),
        NVL( ATTRIBUTE15,FND_API.G_MISS_CHAR ),
        NVL( ATTRIBUTE14,FND_API.G_MISS_CHAR ),
        NVL( ATTRIBUTE13,FND_API.G_MISS_CHAR ),
        NVL( ATTRIBUTE12,FND_API.G_MISS_CHAR ),
        NVL( ATTRIBUTE11,FND_API.G_MISS_CHAR ),
        NVL( ATTRIBUTE10,FND_API.G_MISS_CHAR )
        INTO
        X_APPLY_TO,
        X_TAX_BALANCE,
        X_CUSTOMER_TRX_LINE_ID,
        X_COMMENTS,
        X_TAX,
        X_CASH_RECEIPT_ID,
        X_ATTRIBUTE_CATEGORY,
        X_ALLOCATED_RECEIPT_AMOUNT,
        X_GROUP_ID,
        X_TAX_DISCOUNT,
        X_AMOUNT,
        X_LINE_DISCOUNT,
        X_ATTRIBUTE9,
        X_ATTRIBUTE8,
        X_ATTRIBUTE7,
        X_ATTRIBUTE6,
        X_ATTRIBUTE5,
        X_ATTRIBUTE4,
        X_ATTRIBUTE3,
        X_ATTRIBUTE2,
        X_ATTRIBUTE1,
        X_LINE_BALANCE,
        X_ATTRIBUTE15,
        X_ATTRIBUTE14,
        X_ATTRIBUTE13,
        X_ATTRIBUTE12,
        X_ATTRIBUTE11,
        X_ATTRIBUTE10
        FROM AR_ACTIVITY_DETAILS
    WHERE  1 = 1  AND CASH_RECEIPT_ID = X_CASH_RECEIPT_ID
         AND NVL(CURRENT_ACTIVITY_FLAG, 'Y') = 'Y' -- BUG 7241111
 AND CUSTOMER_TRX_LINE_ID = X_CUSTOMER_TRX_LINE_ID
;

Line: 450


END Select_Row;