[Home] [Help]
138: -- code added by sriram to check up if the line created corresponds to an so line or a return line
139:
140: cursor c_check_so_line is
141: select 1
142: from JAI_OM_OE_SO_LINES
143: where line_id = to_number(pr_old.interface_line_attribute6);
144:
145: cursor c_check_rma_line is
146: select 1
1046: WHERE line_id = TO_NUMBER(v_interface_line_attribute6);
1047:
1048: CURSOR JA_SO_LINES_RECORD_CHECK IS
1049: SELECT 1
1050: FROM JAI_OM_OE_SO_LINES
1051: WHERE line_id = TO_NUMBER(v_interface_line_attribute6);
1052:
1053: CURSOR JA_SO_LINES_TAX_RECORD_CHECK IS
1054: SELECT DISTINCT 1
1051: WHERE line_id = TO_NUMBER(v_interface_line_attribute6);
1052:
1053: CURSOR JA_SO_LINES_TAX_RECORD_CHECK IS
1054: SELECT DISTINCT 1
1055: FROM JAI_OM_OE_SO_TAXES A, JAI_OM_OE_SO_LINES b
1056: WHERE A.line_id = TO_NUMBER(v_interface_line_attribute6)
1057: AND A.line_id = b.line_id;
1058:
1059: -- Date 23/02/2006 by sacsethi for bug 5228046
1063: A.func_tax_amount,
1064: A.precedence_1, A.precedence_2, A.precedence_3, A.precedence_4, A.precedence_5,
1065: A.precedence_6, A.precedence_7, A.precedence_8, A.precedence_9, A.precedence_10,
1066: c.tax_type
1067: FROM JAI_OM_OE_SO_TAXES A, JAI_OM_OE_SO_LINES b, JAI_CMN_TAXES_ALL c
1068: WHERE A.line_id = b.line_id
1069: AND b.line_id = TO_NUMBER(v_interface_line_attribute6)
1070: AND A.tax_id = c.tax_id
1071: and c.tax_type <> lc_modvat_tax/*Bug 4881426 bduvarag*/
1073:
1074: CURSOR ja_so_lines_info IS
1075: SELECT tax_category_id, tax_amount, assessable_value, excise_exempt_type,excise_exempt_refno, excise_exempt_date,
1076: vat_exemption_flag, vat_exemption_type, vat_exemption_date, vat_exemption_refno, vat_assessable_value -- added, Harshita for bug#4245062
1077: FROM JAI_OM_OE_SO_LINES
1078: WHERE line_id = to_number(v_interface_line_attribute6);
1079: -- Bug 3357587
1080: CURSOR C_JA_SO_LINES_ASSESSABLE_VAL IS
1081: SELECT assessable_value, service_type_code -- service_type_code added by csahoo for bug#5879769
1078: WHERE line_id = to_number(v_interface_line_attribute6);
1079: -- Bug 3357587
1080: CURSOR C_JA_SO_LINES_ASSESSABLE_VAL IS
1081: SELECT assessable_value, service_type_code -- service_type_code added by csahoo for bug#5879769
1082: from JAI_OM_OE_SO_LINES
1083: WHERE line_id = TO_NUMBER(v_interface_line_attribute6);
1084: /* bug 5243532. Added by Lakshmi Gopalsami
1085: Removed the reference to cursor set_of_books_cur
1086: as the SOB will never be null in base table.
1368: and item_type_code = cp_item_code; /*'CONFIG'; Ramananda for removal of SQL LITERALs */
1369:
1370: CURSOR c_get_om_lines(v_ato_line_id Varchar2) is
1371: SELECT *
1372: FROM JAI_OM_OE_SO_LINES
1373: WHERE line_id = v_ato_line_id;
1374:
1375: cursor c_so_picking_data (v_ato_line_id Varchar2) is
1376: SELECT excise_invoice_no , register , preprinted_excise_inv_no , ar3_form_no ,ar3_form_date
1815: unit_code , -- Date 26-feb-2006 added by sacsethi for bug 5631784
1816: inventory_item_id , -- Date 26-feb-2006 added by sacsethi for bug 5631784
1817: quantity , -- Date 26-feb-2006 added by sacsethi for bug 5631784
1818: service_type_code -- Added by csahoo, Bug 5879769
1819: FROM JAI_OM_OE_SO_LINES
1820: WHERE line_id = TO_NUMBER(v_interface_line_attribute6);
1821:
1822: cursor c_get_amounts is
1823: select sum(tax_amount) tax_amt , sum(line_amount) line_amt
2515:
2516: Fix Details:-
2517: Added a if clause in the code. Placed the return statement between the if clause.
2518: So the modified functionality is that is a line does not have any taxes in shpiing tables and also does not have
2519: any taxes in JAI_OM_OE_SO_TAXES table then check whether a line exists in JAI_OM_OE_SO_LINES table only.
2520: IF yes then do not retunr, if not found then return.
2521: Also added a nvl clause in the cursor c_cust_trx_tax_line_amt. so that a value of zero would be returned
2522: even if the where clause failed to fetch a record.
2523: This would take care that tax amount would be inserted as 0 and total amount would also be computed properly
2531: 20 2004/02/16 RBASKER - Bug 3357587, Version 618.2
2532: When SO UOM is different from that of the primary UOM,
2533: JAI_AR_TRX_LINES is updated with wrong assessable value
2534: Added a cursor C_JA_SO_LINES_ASSESSABLE_VAL to fetch the correct assessable_value
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
2571: bug# 4146708 creates the objects
2572:
2573: 26. 17-Mar-2005 hjujjuru - bug #4245062 File version 115.6
2574: The columns vat_exemption_flag, vat_exemption_type, vat_exemption_date, vat_exemption_refno,
2575: and vat_assessable_value have been added in JAI_OM_OE_SO_LINES, JAI_OM_WSH_LINES_ALL
2576: and JAI_AR_TRX_LINES.
2577: Additional fields vat_invoice_no and vat_invoice_date have been added into JAI_OM_WSH_LINES_ALL
2578: and JAI_AR_TRXS.
2579: The trigger has been updated to ensure that any data flowing into JAI_AR_TRX_LINES and
2576: and JAI_AR_TRX_LINES.
2577: Additional fields vat_invoice_no and vat_invoice_date have been added into JAI_OM_WSH_LINES_ALL
2578: and JAI_AR_TRXS.
2579: The trigger has been updated to ensure that any data flowing into JAI_AR_TRX_LINES and
2580: JAI_AR_TRXS also includes the Vat information that comes down from either JAI_OM_OE_SO_LINES
2581: or JAI_OM_WSH_LINES_ALL .
2582:
2583: Base bug - #4245089
2584:
3820: IF v_register_code = 'BOND_REG' THEN
3821: v_tax_amount := v_bond_tax_amt / v_qty;
3822: END IF;
3823: -- Bug 3357587
3824: -- To pick assessable_value from JAI_OM_OE_SO_LINES instead of JAI_OM_WSH_LINES_ALL
3825: OPEN C_JA_SO_LINES_ASSESSABLE_VAL;
3826: FETCH C_JA_SO_LINES_ASSESSABLE_VAL into v_assessable_value,v_service_type;/*5879769..csahoo*/
3827: CLOSE C_JA_SO_LINES_ASSESSABLE_VAL;
3828:
3915: /*
3916: Update done by aiyer for the bug #3328871
3917: If taxes do not exist in JAI_OM_WSH_LINE_TAXES and JAI_OM_OE_SO_TAXES then control
3918: would come here.
3919: Code should return only in case of an RMA i.e return only when a line does not exist in JAI_OM_OE_SO_LINES table
3920: for the given line_id.
3921: */
3922: DECLARE
3923: CURSOR c_so_lines_exists
3922: DECLARE
3923: CURSOR c_so_lines_exists
3924: IS
3925: SELECT 1
3926: FROM JAI_OM_OE_SO_LINES
3927: WHERE line_id = pr_new.interface_line_attribute6;
3928: lv_exists VARCHAR2(1);
3929: BEGIN
3930: pv_return_code := jai_constants.successful ;
3932: FETCH c_so_lines_exists INTO lv_exists;
3933: IF c_so_lines_exists%NOTFOUND THEN
3934: CLOSE c_so_lines_exists;
3935: fnd_file.put_line(FND_FILE.LOG,
3936: 'no lines in jai_om_oe_so_lines -return');
3937: return;
3938: END IF;
3939: CLOSE c_so_lines_exists;
3940: END ;
5076:
5077: uptake of the vat assessable value has been done in this trigger.
5078: A call to the jai_general_pkg.JA_IN_VAT_ASSESSABLE_VALUE has been made passing the parameters
5079: to get the vat assessable value to the tax calculation routines and update the vat assessable
5080: value in the JAI_OM_OE_SO_LINES table.
5081:
5082: This vat assessable value is sent as an additional parameter to the various procedures
5083: such as jai_om_tax_pkg.recalculate_oe_taxes , jai_cmn_tax_defaultation_pkg.ja_in_calc_prec_taxes
5084:
6022:
6023: uptake of the vat assessable value has been done in this trigger.
6024: A call to the jai_general_pkg.JA_IN_VAT_ASSESSABLE_VALUE has been made passing the parameters
6025: to get the vat assessable value to the tax calculation routines and update the vat assessable
6026: value in the JAI_OM_OE_SO_LINES table.
6027:
6028: This vat assessable value is sent as an additional parameter to the various procedures
6029: such as jai_om_tax_pkg.recalculate_oe_taxes , jai_cmn_tax_defaultation_pkg.ja_in_calc_prec_taxes
6030: