[Home] [Help]
1858: lv_process_flag VARCHAR2(2);
1859: lv_process_message VARCHAR2(1996);
1860: ln_reg_id number;
1861: cursor c_chk_rgm_tax_exists ( cp_regime_code JAI_RGM_DEFINITIONS.regime_code%type
1862: , cp_cust_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type
1863: )
1864: is
1865: select count(1)
1866: from jai_regime_tax_types_v jrttv
2535: from JAI_OM_OE_SO_LINES instead of JAI_OM_WSH_LINES_ALL table.
2536:
2537: 21. 2004/05/05 ssumaith - bug# 3607101 - Version 619.1
2538: When autoinvoice import program imports an invoice from customer software and if interface_line_attribute11
2539: field in the ra_customer_trx_lines_all table is not null then , localization taxes are not retreived
2540: into the AR invoice.
2541: This issue has been resolved by adding a context based check that interface_line_attribute11 field cannot be
2542: null for Order Entry as the source of the invoice for taxes to be imported , and other wise if the context is not
2543: Order Entry then the localisation taxes will be populated into the Invoice from shipment.
4419:
4420: 8. 2004/06/09 ssumaith - bug# 3680721 File Version 115.1
4421:
4422: When autoinvoice import program imports a crdit memo from custom software and if interface_line_attribute11
4423: field in the ra_customer_trx_lines_all table is not null then , localization taxes are not retreived
4424: into the AR invoice.
4425:
4426: This issue has been resolved by adding a context based check that interface_line_attribute11 field cannot be
4427: null for Order Entry as the source of the invoice for taxes to be imported , and other wise if the context is not
5041: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type ;
5042: lv_add_err JAI_CMN_ERRORS_T.additional_error_mesg%type ;
5043: BEGIN
5044: pv_return_code := jai_constants.successful ;
5045: /* This Trigger fires , when you insert a record in RA_CUSTOMER_TRX_LINES_ALL */
5046:
5047: /*------------------------------------------------------------------------------------------
5048: FILENAME: JA_IN_AR_LINES_INSERT_TRG.sql
5049: CHANGE HISTORY:
6326: END ARU_T2 ;
6327:
6328: /* following procedure added by cbabu for bug#6012570 (5876390) */
6329: procedure import_projects_taxes
6330: ( r_new in ra_customer_trx_lines_all%rowtype
6331: , r_old in ra_customer_trx_lines_all%rowtype
6332: , pv_action in varchar2
6333: , pv_err_msg OUT NOCOPY varchar2
6334: , pv_err_flg OUT NOCOPY varchar2
6327:
6328: /* following procedure added by cbabu for bug#6012570 (5876390) */
6329: procedure import_projects_taxes
6330: ( r_new in ra_customer_trx_lines_all%rowtype
6331: , r_old in ra_customer_trx_lines_all%rowtype
6332: , pv_action in varchar2
6333: , pv_err_msg OUT NOCOPY varchar2
6334: , pv_err_flg OUT NOCOPY varchar2
6335: )
6408:
6409: r_jai_pa_draft_inv_line c_jai_pa_draft_inv_line%rowtype;
6410:
6411:
6412: ln_line_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type;
6413:
6414: ln_project_id pa_draft_invoices_all.project_id%type;
6415: ln_draft_invoice_num pa_draft_invoices_all.draft_invoice_num%type;
6416: ln_line_num pa_draft_invoice_items.line_num%type;