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_RCTLA_TRIGGER_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 2072: , cp_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type

2068: lv_process_flag VARCHAR2(2);
2069: lv_process_message VARCHAR2(1996);
2070: ln_reg_id number;
2071: cursor c_chk_rgm_tax_exists ( cp_regime_code JAI_RGM_DEFINITIONS.regime_code%type
2072: , cp_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type
2073: )
2074: is
2075: select count(1)
2076: from jai_regime_tax_types_v jrttv

Line 2749: field in the ra_customer_trx_lines_all table is not null then , localization taxes are not retreived

2745: from JAI_OM_OE_SO_LINES instead of JAI_OM_WSH_LINES_ALL table.
2746:
2747: 21. 2004/05/05 ssumaith - bug# 3607101 - Version 619.1
2748: When autoinvoice import program imports an invoice from customer software and if interface_line_attribute11
2749: field in the ra_customer_trx_lines_all table is not null then , localization taxes are not retreived
2750: into the AR invoice.
2751: This issue has been resolved by adding a context based check that interface_line_attribute11 field cannot be
2752: null for Order Entry as the source of the invoice for taxes to be imported , and other wise if the context is not
2753: Order Entry then the localisation taxes will be populated into the Invoice from shipment.

Line 4803: , cp_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type

4799: lv_process_message VARCHAR2(1996);
4800: ln_reg_id number;
4801: ln_threshold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type;
4802: cursor c_chk_rgm_tax_exists ( cp_regime_code JAI_RGM_DEFINITIONS.regime_code%type
4803: , cp_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type
4804: )
4805: is
4806: select count(1)
4807: from jai_regime_tax_types_v jrttv

Line 5377: field in the ra_customer_trx_lines_all table is not null then , localization taxes are not retreived

5373:
5374: 8. 2004/06/09 ssumaith - bug# 3680721 File Version 115.1
5375:
5376: When autoinvoice import program imports a crdit memo from custom software and if interface_line_attribute11
5377: field in the ra_customer_trx_lines_all table is not null then , localization taxes are not retreived
5378: into the AR invoice.
5379:
5380: This issue has been resolved by adding a context based check that interface_line_attribute11 field cannot be
5381: null for Order Entry as the source of the invoice for taxes to be imported , and other wise if the context is not

Line 6426: /* This Trigger fires , when you insert a record in RA_CUSTOMER_TRX_LINES_ALL */

6422: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type ;
6423: lv_add_err JAI_CMN_ERRORS_T.additional_error_mesg%type ;
6424: BEGIN
6425: pv_return_code := jai_constants.successful ;
6426: /* This Trigger fires , when you insert a record in RA_CUSTOMER_TRX_LINES_ALL */
6427:
6428: /*------------------------------------------------------------------------------------------
6429: FILENAME: JA_IN_AR_LINES_INSERT_TRG.sql
6430: CHANGE HISTORY:

Line 7827: ( r_new in ra_customer_trx_lines_all%rowtype

7823: END ARU_T2 ;
7824:
7825: /* following procedure added by cbabu for bug#6012570 (5876390) */
7826: procedure import_projects_taxes
7827: ( r_new in ra_customer_trx_lines_all%rowtype
7828: , r_old in ra_customer_trx_lines_all%rowtype
7829: , pv_action in varchar2
7830: , pv_err_msg OUT NOCOPY varchar2
7831: , pv_err_flg OUT NOCOPY varchar2

Line 7828: , r_old in ra_customer_trx_lines_all%rowtype

7824:
7825: /* following procedure added by cbabu for bug#6012570 (5876390) */
7826: procedure import_projects_taxes
7827: ( r_new in ra_customer_trx_lines_all%rowtype
7828: , r_old in ra_customer_trx_lines_all%rowtype
7829: , pv_action in varchar2
7830: , pv_err_msg OUT NOCOPY varchar2
7831: , pv_err_flg OUT NOCOPY varchar2
7832: )

Line 7909: ln_line_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type;

7905:
7906: r_jai_pa_draft_inv_line c_jai_pa_draft_inv_line%rowtype;
7907:
7908:
7909: ln_line_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type;
7910:
7911: ln_project_id pa_draft_invoices_all.project_id%type;
7912: ln_draft_invoice_num pa_draft_invoices_all.draft_invoice_num%type;
7913: ln_line_num pa_draft_invoice_items.line_num%type;