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.JAI_AR_IMPORT_SYNC_PKG dependencies on JAI_RGM_TRX_RECORDS

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

2292: AND ot.NAME = pr_new.INTERFACE_HEADER_ATTRIBUTE2;
2293:
2294:
2295: CURSOR cur_get_man_ar_inv_taxes
2296: ( cp_source IN jai_rgm_trx_records.source%TYPE,
2297: cp_source_trx_type IN jai_rgm_trx_records.source_trx_type%TYPE,
2298: cp_source_table_name IN jai_rgm_trx_records.source_table_name%TYPE,
2299: cp_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE,
2300: cp_organization_id IN JAI_AR_TRXS.organization_id%TYPE,

Line 2297: cp_source_trx_type IN jai_rgm_trx_records.source_trx_type%TYPE,

2293:
2294:
2295: CURSOR cur_get_man_ar_inv_taxes
2296: ( cp_source IN jai_rgm_trx_records.source%TYPE,
2297: cp_source_trx_type IN jai_rgm_trx_records.source_trx_type%TYPE,
2298: cp_source_table_name IN jai_rgm_trx_records.source_table_name%TYPE,
2299: cp_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE,
2300: cp_organization_id IN JAI_AR_TRXS.organization_id%TYPE,
2301: cp_loc_id IN JAI_AR_TRXS.location_id%TYPE

Line 2298: cp_source_table_name IN jai_rgm_trx_records.source_table_name%TYPE,

2294:
2295: CURSOR cur_get_man_ar_inv_taxes
2296: ( cp_source IN jai_rgm_trx_records.source%TYPE,
2297: cp_source_trx_type IN jai_rgm_trx_records.source_trx_type%TYPE,
2298: cp_source_table_name IN jai_rgm_trx_records.source_table_name%TYPE,
2299: cp_customer_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE,
2300: cp_organization_id IN JAI_AR_TRXS.organization_id%TYPE,
2301: cp_loc_id IN JAI_AR_TRXS.location_id%TYPE
2302: )

Line 2336: jai_rgm_trx_records jrtr

2332: jtc.tax_type = jrttv.tax_type AND
2333: NOT EXISTS ( SELECT
2334: 1
2335: FROM
2336: jai_rgm_trx_records jrtr
2337: WHERE
2338: jrtr.source = cp_source AND
2339: jrtr.source_trx_type = cp_source_trx_type AND
2340: jrtr.organization_id = cp_organization_id AND

Line 2348: ln_repository_id JAI_RGM_TRX_RECORDS.REPOSITORY_ID%TYPE ;

2344: jrtr.source_document_id = jcttl.customer_trx_line_id AND
2345: jrtr.reference_id = jcttl.tax_id
2346: ) ;
2347:
2348: ln_repository_id JAI_RGM_TRX_RECORDS.REPOSITORY_ID%TYPE ;
2349: ln_liab_acct_ccid GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
2350: ln_intliab_acct_ccid GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
2351: ln_charge_ac_id GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
2352: ln_balancing_ac_id GL_CODE_COMBINATIONS.code_combination_id%TYPE ;

Line 2353: ln_debit_amount JAI_RGM_TRX_RECORDS.DEBIT_AMOUNT%TYPE ;

2349: ln_liab_acct_ccid GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
2350: ln_intliab_acct_ccid GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
2351: ln_charge_ac_id GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
2352: ln_balancing_ac_id GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
2353: ln_debit_amount JAI_RGM_TRX_RECORDS.DEBIT_AMOUNT%TYPE ;
2354: ln_credit_amount JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE ;
2355: lc_account_name VARCHAR2(50);
2356:
2357:

Line 2354: ln_credit_amount JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE ;

2350: ln_intliab_acct_ccid GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
2351: ln_charge_ac_id GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
2352: ln_balancing_ac_id GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
2353: ln_debit_amount JAI_RGM_TRX_RECORDS.DEBIT_AMOUNT%TYPE ;
2354: ln_credit_amount JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE ;
2355: lc_account_name VARCHAR2(50);
2356:
2357:
2358: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_CM_VAT_REPO()';