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_MATCH_TAX_PKG dependencies on RA_CUST_TRX_TYPES_ALL

Line 1186: --get the allow_overapplication_flag from ra_cust_trx_types_all for cust_trx_type_id

1182: Item_lines_already_accounted EXCEPTION; /* Ramanand for SLA Uptake */
1183: rounding_account_not_defined EXCEPTION;
1184: resource_busy EXCEPTION;
1185:
1186: --get the allow_overapplication_flag from ra_cust_trx_types_all for cust_trx_type_id
1187: CURSOR cur_trx_types( cp_cust_trx_type_id ra_cust_trx_types_all.cust_trx_type_id%TYPE)
1188: IS
1189: SELECT allow_overapplication_flag
1190: FROM ra_cust_trx_types_all

Line 1187: CURSOR cur_trx_types( cp_cust_trx_type_id ra_cust_trx_types_all.cust_trx_type_id%TYPE)

1183: rounding_account_not_defined EXCEPTION;
1184: resource_busy EXCEPTION;
1185:
1186: --get the allow_overapplication_flag from ra_cust_trx_types_all for cust_trx_type_id
1187: CURSOR cur_trx_types( cp_cust_trx_type_id ra_cust_trx_types_all.cust_trx_type_id%TYPE)
1188: IS
1189: SELECT allow_overapplication_flag
1190: FROM ra_cust_trx_types_all
1191: WHERE cust_trx_type_id = cp_cust_trx_type_id;

Line 1190: FROM ra_cust_trx_types_all

1186: --get the allow_overapplication_flag from ra_cust_trx_types_all for cust_trx_type_id
1187: CURSOR cur_trx_types( cp_cust_trx_type_id ra_cust_trx_types_all.cust_trx_type_id%TYPE)
1188: IS
1189: SELECT allow_overapplication_flag
1190: FROM ra_cust_trx_types_all
1191: WHERE cust_trx_type_id = cp_cust_trx_type_id;
1192:
1193: --get the data from ar_payment_schedules_all for customer_trx_id and payment_schedule_id
1194: CURSOR cur_payment_schedule(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%TYPE,

Line 1972: --get the allow_overapplication_flag from ra_cust_trx_types_all for cust_trx_type_id

1968: ln_inst_tax_amt_for_inv := ln_tax_amt_cms * ln_apportion_factor;
1969: ln_inst_frt_amt_for_inv := ln_frt_amt_cms * ln_apportion_factor;
1970:
1971:
1972: --get the allow_overapplication_flag from ra_cust_trx_types_all for cust_trx_type_id
1973: OPEN cur_trx_types(rec_inv_customer_trx.cust_trx_type_id);
1974: FETCH cur_trx_types INTO lv_allow_overappln_flag ;
1975: CLOSE cur_trx_types ;
1976:

Line 3479: ln_rec_account_id ra_cust_trx_types_all.gl_id_rec%TYPE;

3475: ln_cur_conversion_rate jai_ar_trxs.exchange_rate%TYPE;
3476: lv_currency_code jai_ar_trxs.invoice_currency_code%TYPE;
3477: ln_inv_org_id jai_ar_trxs.organization_id%TYPE;
3478: lv_inv_org_code mtl_parameters.organization_code%TYPE;
3479: ln_rec_account_id ra_cust_trx_types_all.gl_id_rec%TYPE;
3480: ln_set_of_books_id ra_cust_trx_line_gl_dist_all.set_of_books_id%TYPE;
3481: ld_gl_date ra_cust_trx_line_gl_dist_all.gl_date%TYPE;
3482: ln_tax_account_id NUMBER;
3483: ln_total_inclu_tax_amt NUMBER;

Line 3559: ra_cust_trx_types_all

3555: gl_id_rec
3556: INTO
3557: ln_rec_account_id
3558: FROM
3559: ra_cust_trx_types_all
3560: WHERE org_id = ln_org_id
3561: AND cust_trx_type_id = ln_cust_trx_type_id;
3562:
3563: EXCEPTION