[Home] [Help]
157: -- code added by sriram to check up if the line created corresponds to an so line or a return line
158:
159: cursor c_check_so_line is
160: select 1
161: from JAI_OM_OE_SO_LINES
162: where line_id = to_number(pr_old.interface_line_attribute6);
163:
164: cursor c_check_rma_line is
165: select 1
1115: WHERE line_id = TO_NUMBER(v_interface_line_attribute6);*/
1116:
1117: CURSOR JA_SO_LINES_RECORD_CHECK IS
1118: SELECT 1
1119: FROM JAI_OM_OE_SO_LINES
1120: WHERE line_id = TO_NUMBER(v_interface_line_attribute6);
1121:
1122: CURSOR JA_SO_LINES_TAX_RECORD_CHECK IS
1123: SELECT DISTINCT 1
1120: WHERE line_id = TO_NUMBER(v_interface_line_attribute6);
1121:
1122: CURSOR JA_SO_LINES_TAX_RECORD_CHECK IS
1123: SELECT DISTINCT 1
1124: FROM JAI_OM_OE_SO_TAXES A, JAI_OM_OE_SO_LINES b
1125: WHERE A.line_id = TO_NUMBER(v_interface_line_attribute6)
1126: AND A.line_id = b.line_id;
1127:
1128: -- Date 23/02/2006 by sacsethi for bug 5228046
1132: A.func_tax_amount,
1133: A.precedence_1, A.precedence_2, A.precedence_3, A.precedence_4, A.precedence_5,
1134: A.precedence_6, A.precedence_7, A.precedence_8, A.precedence_9, A.precedence_10,
1135: c.tax_type
1136: FROM JAI_OM_OE_SO_TAXES A, JAI_OM_OE_SO_LINES b, JAI_CMN_TAXES_ALL c
1137: WHERE A.line_id = b.line_id
1138: AND b.line_id = TO_NUMBER(v_interface_line_attribute6)
1139: AND A.tax_id = c.tax_id
1140: and c.tax_type <> lc_modvat_tax/*Bug 4881426 bduvarag*/
1144: SELECT tax_category_id, tax_amount, assessable_value, excise_exempt_type,excise_exempt_refno, excise_exempt_date,
1145: vat_exemption_flag, vat_exemption_type, vat_exemption_date, vat_exemption_refno, vat_assessable_value -- added, Harshita for bug#4245062
1146: ,service_type_code --Added by JMEENA for bug#8466638
1147: -- ,gst_assessable_value--Added by Xiao Lv for bug 10091373 16470035
1148: FROM JAI_OM_OE_SO_LINES
1149: WHERE line_id = to_number(v_interface_line_attribute6);
1150: -- Bug 3357587
1151: CURSOR C_JA_SO_LINES_ASSESSABLE_VAL IS
1152: SELECT assessable_value, service_type_code -- service_type_code added by csahoo for bug#5879769
1149: WHERE line_id = to_number(v_interface_line_attribute6);
1150: -- Bug 3357587
1151: CURSOR C_JA_SO_LINES_ASSESSABLE_VAL IS
1152: SELECT assessable_value, service_type_code -- service_type_code added by csahoo for bug#5879769
1153: from JAI_OM_OE_SO_LINES
1154: WHERE line_id = TO_NUMBER(v_interface_line_attribute6);
1155: /* bug 5243532. Added by Lakshmi Gopalsami
1156: Removed the reference to cursor set_of_books_cur
1157: as the SOB will never be null in base table.
1453: and item_type_code = cp_item_code; /*'CONFIG'; Ramananda for removal of SQL LITERALs */
1454:
1455: CURSOR c_get_om_lines(v_ato_line_id Varchar2) is
1456: SELECT *
1457: FROM JAI_OM_OE_SO_LINES
1458: WHERE line_id = v_ato_line_id;
1459:
1460: cursor c_so_picking_data (v_ato_line_id Varchar2) is
1461: SELECT excise_invoice_no , register , preprinted_excise_inv_no , ar3_form_no ,ar3_form_date
2025: unit_code , -- Date 26-feb-2006 added by sacsethi for bug 5631784
2026: inventory_item_id , -- Date 26-feb-2006 added by sacsethi for bug 5631784
2027: quantity , -- Date 26-feb-2006 added by sacsethi for bug 5631784
2028: service_type_code -- Added by csahoo, Bug 5879769
2029: FROM JAI_OM_OE_SO_LINES
2030: WHERE line_id = TO_NUMBER(v_interface_line_attribute6);
2031:
2032: cursor c_get_amounts is
2033: select sum(tax_amount) tax_amt , sum(line_amount) line_amt
2725:
2726: Fix Details:-
2727: Added a if clause in the code. Placed the return statement between the if clause.
2728: So the modified functionality is that is a line does not have any taxes in shpiing tables and also does not have
2729: any taxes in JAI_OM_OE_SO_TAXES table then check whether a line exists in JAI_OM_OE_SO_LINES table only.
2730: IF yes then do not retunr, if not found then return.
2731: Also added a nvl clause in the cursor c_cust_trx_tax_line_amt. so that a value of zero would be returned
2732: even if the where clause failed to fetch a record.
2733: This would take care that tax amount would be inserted as 0 and total amount would also be computed properly
2741: 20 2004/02/16 RBASKER - Bug 3357587, Version 618.2
2742: When SO UOM is different from that of the primary UOM,
2743: JAI_AR_TRX_LINES is updated with wrong assessable value
2744: Added a cursor C_JA_SO_LINES_ASSESSABLE_VAL to fetch the correct assessable_value
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
2781: bug# 4146708 creates the objects
2782:
2783: 26. 17-Mar-2005 hjujjuru - bug #4245062 File version 115.6
2784: The columns vat_exemption_flag, vat_exemption_type, vat_exemption_date, vat_exemption_refno,
2785: and vat_assessable_value have been added in JAI_OM_OE_SO_LINES, JAI_OM_WSH_LINES_ALL
2786: and JAI_AR_TRX_LINES.
2787: Additional fields vat_invoice_no and vat_invoice_date have been added into JAI_OM_WSH_LINES_ALL
2788: and JAI_AR_TRXS.
2789: The trigger has been updated to ensure that any data flowing into JAI_AR_TRX_LINES and
2786: and JAI_AR_TRX_LINES.
2787: Additional fields vat_invoice_no and vat_invoice_date have been added into JAI_OM_WSH_LINES_ALL
2788: and JAI_AR_TRXS.
2789: The trigger has been updated to ensure that any data flowing into JAI_AR_TRX_LINES and
2790: JAI_AR_TRXS also includes the Vat information that comes down from either JAI_OM_OE_SO_LINES
2791: or JAI_OM_WSH_LINES_ALL .
2792:
2793: Base bug - #4245089
2794:
4114: IF v_register_code = 'BOND_REG' THEN
4115: v_tax_amount := v_bond_tax_amt / v_qty;
4116: END IF;
4117: -- Bug 3357587
4118: -- To pick assessable_value from JAI_OM_OE_SO_LINES instead of JAI_OM_WSH_LINES_ALL
4119: OPEN C_JA_SO_LINES_ASSESSABLE_VAL;
4120: FETCH C_JA_SO_LINES_ASSESSABLE_VAL into v_assessable_value,v_service_type;/*5879769..csahoo*/
4121: CLOSE C_JA_SO_LINES_ASSESSABLE_VAL;
4122:
4221: /*
4222: Update done by aiyer for the bug #3328871
4223: If taxes do not exist in JAI_OM_WSH_LINE_TAXES and JAI_OM_OE_SO_TAXES then control
4224: would come here.
4225: 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
4226: for the given line_id.
4227: */
4228: DECLARE
4229: CURSOR c_so_lines_exists
4228: DECLARE
4229: CURSOR c_so_lines_exists
4230: IS
4231: SELECT 1
4232: FROM JAI_OM_OE_SO_LINES
4233: WHERE line_id = pr_new.interface_line_attribute6;
4234: lv_exists VARCHAR2(1);
4235: BEGIN
4236: pv_return_code := jai_constants.successful ;
4238: FETCH c_so_lines_exists INTO lv_exists;
4239: IF c_so_lines_exists%NOTFOUND THEN
4240: CLOSE c_so_lines_exists;
4241: fnd_file.put_line(FND_FILE.LOG,
4242: 'no lines in jai_om_oe_so_lines -return');
4243: return;
4244: END IF;
4245: CLOSE c_so_lines_exists;
4246: END ;
6457:
6458: uptake of the vat assessable value has been done in this trigger.
6459: A call to the jai_general_pkg.JA_IN_VAT_ASSESSABLE_VALUE has been made passing the parameters
6460: to get the vat assessable value to the tax calculation routines and update the vat assessable
6461: value in the JAI_OM_OE_SO_LINES table.
6462:
6463: This vat assessable value is sent as an additional parameter to the various procedures
6464: such as jai_om_tax_pkg.recalculate_oe_taxes , jai_cmn_tax_defaultation_pkg.ja_in_calc_prec_taxes
6465:
7481:
7482: uptake of the vat assessable value has been done in this trigger.
7483: A call to the jai_general_pkg.JA_IN_VAT_ASSESSABLE_VALUE has been made passing the parameters
7484: to get the vat assessable value to the tax calculation routines and update the vat assessable
7485: value in the JAI_OM_OE_SO_LINES table.
7486:
7487: This vat assessable value is sent as an additional parameter to the various procedures
7488: such as jai_om_tax_pkg.recalculate_oe_taxes , jai_cmn_tax_defaultation_pkg.ja_in_calc_prec_taxes
7489: