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.

[Home] [Help]

APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on JAI_RGM_TRX_RECORDS

Line 4150: ( cp_source IN jai_rgm_trx_records.source%TYPE,

4146:
4147: --Added by Bo Li for Bug#9765108 on 09-JUL-2010 Begin
4148: -------------------------------------------------------------
4149: CURSOR cur_get_man_ar_inv_taxes
4150: ( cp_source IN jai_rgm_trx_records.source%TYPE,
4151: cp_source_trx_type IN jai_rgm_trx_records.source_trx_type%TYPE,
4152: cp_source_table_name IN jai_rgm_trx_records.source_table_name%TYPE,
4153: cp_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE,
4154: cp_organization_id IN JAI_AR_TRXS.organization_id%TYPE,

Line 4151: cp_source_trx_type IN jai_rgm_trx_records.source_trx_type%TYPE,

4147: --Added by Bo Li for Bug#9765108 on 09-JUL-2010 Begin
4148: -------------------------------------------------------------
4149: CURSOR cur_get_man_ar_inv_taxes
4150: ( cp_source IN jai_rgm_trx_records.source%TYPE,
4151: cp_source_trx_type IN jai_rgm_trx_records.source_trx_type%TYPE,
4152: cp_source_table_name IN jai_rgm_trx_records.source_table_name%TYPE,
4153: cp_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE,
4154: cp_organization_id IN JAI_AR_TRXS.organization_id%TYPE,
4155: cp_loc_id IN JAI_AR_TRXS.location_id%TYPE

Line 4152: cp_source_table_name IN jai_rgm_trx_records.source_table_name%TYPE,

4148: -------------------------------------------------------------
4149: CURSOR cur_get_man_ar_inv_taxes
4150: ( cp_source IN jai_rgm_trx_records.source%TYPE,
4151: cp_source_trx_type IN jai_rgm_trx_records.source_trx_type%TYPE,
4152: cp_source_table_name IN jai_rgm_trx_records.source_table_name%TYPE,
4153: cp_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE,
4154: cp_organization_id IN JAI_AR_TRXS.organization_id%TYPE,
4155: cp_loc_id IN JAI_AR_TRXS.location_id%TYPE
4156: )

Line 4190: jai_rgm_trx_records jrtr

4186: jtc.tax_type = jrttv.tax_type AND
4187: NOT EXISTS ( SELECT
4188: 1
4189: FROM
4190: jai_rgm_trx_records jrtr
4191: WHERE
4192: jrtr.source = cp_source AND
4193: jrtr.source_trx_type = cp_source_trx_type AND
4194: jrtr.organization_id = cp_organization_id AND

Line 4202: ln_repository_id JAI_RGM_TRX_RECORDS.REPOSITORY_ID%TYPE ;

4198: jrtr.source_document_id = jcttl.customer_trx_line_id AND
4199: jrtr.reference_id = jcttl.tax_id
4200: ) ;
4201:
4202: ln_repository_id JAI_RGM_TRX_RECORDS.REPOSITORY_ID%TYPE ;
4203: ln_liab_acct_ccid GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
4204: ln_intliab_acct_ccid GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
4205: ln_charge_ac_id GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
4206: ln_balancing_ac_id GL_CODE_COMBINATIONS.code_combination_id%TYPE ;

Line 4207: ln_debit_amount JAI_RGM_TRX_RECORDS.DEBIT_AMOUNT%TYPE ;

4203: ln_liab_acct_ccid GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
4204: ln_intliab_acct_ccid GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
4205: ln_charge_ac_id GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
4206: ln_balancing_ac_id GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
4207: ln_debit_amount JAI_RGM_TRX_RECORDS.DEBIT_AMOUNT%TYPE ;
4208: ln_credit_amount JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE ;
4209: lc_account_name VARCHAR2(50);
4210:
4211: ----------------------------------------------------------------------------------------------------

Line 4208: ln_credit_amount JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE ;

4204: ln_intliab_acct_ccid GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
4205: ln_charge_ac_id GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
4206: ln_balancing_ac_id GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
4207: ln_debit_amount JAI_RGM_TRX_RECORDS.DEBIT_AMOUNT%TYPE ;
4208: ln_credit_amount JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE ;
4209: lc_account_name VARCHAR2(50);
4210:
4211: ----------------------------------------------------------------------------------------------------
4212: --Added by Bo Li for Bug#9765108 on 09-JUL-2010 Begin