[Home] [Help]
95: order by 1;
96:
97: CURSOR old_line_amount_cur IS
98: SELECT line_amount ,tax_amount --added tax_amount for bug#7539258
99: FROM JAI_AR_TRX_LINES
100: WHERE CUSTOMER_TRX_ID = v_customer_trx_id AND
101: CUSTOMER_TRX_LINE_ID = v_customer_trx_line_id;
102:
103: CURSOR ONCE_COMPLETE_FLAG_CUR IS
256: AND
257: LINK_TO_CUST_TRX_LINE_ID = v_customer_trx_line_id;
258:
259:
260: DELETE JAI_AR_TRX_LINES
261: WHERE CUSTOMER_TRX_ID = v_customer_trx_id AND
262: CUSTOMER_TRX_LINE_ID = v_customer_trx_line_id;
263: /* Added an exception block by Ramananda for bug#4570303 */
264: EXCEPTION
331: WHERE CUSTOMER_TRX_LINE_ID = v_prev_customer_trx_line_id;
332:
333: Cursor localization_line_info IS
334: Select assessable_value, tax_category_id, service_type_code --service_type_code added by csahoo for bug#5879769
335: From JAI_AR_TRX_LINES
336: Where customer_trx_line_id = v_prev_customer_trx_line_id;
337:
338:
339: -- Date 23/02/2006 by sacsethi for bug 5228046
480: Open localization_line_info;
481: Fetch localization_line_info into v_tax_category_id, v_price_list, lv_service_type_code; -- lv_service_type_code added by csahoo for bug#5879769
482: Close localization_line_info;
483:
484: INSERT INTO JAI_AR_TRX_LINES
485: (customer_trx_line_id,
486: line_number,
487: customer_trx_id,
488: description,
596: Set total_amount = nvl(total_amount,0) + nvl(pr_new.extended_amount,0),
597: tax_amount = nvl(tax_amount,0) + nvl(pr_new.extended_amount,0)
598: Where Customer_Trx_Id = v_header_id;
599: END IF;
600: Update JAI_AR_TRX_LINES
601: Set total_amount = nvl(total_amount,0) + nvl(pr_new.extended_amount,0),
602: tax_amount = nvl(tax_amount,0) + nvl(pr_new.extended_amount,0)
603: Where Customer_Trx_Id = v_header_id
604: and Customer_Trx_Line_Id = v_link_to_cust_id;
681: v_so_tax_amount NUMBER;
682: vsqlerrm VARCHAR2(240);
683: v_qty NUMBER; -- added by sriram
684: -- added, Harshita for bug#4245062
685: lv_vat_exemption_flag JAI_AR_TRX_LINES.vat_exemption_flag%TYPE ;
686: lv_vat_exemption_type JAI_AR_TRX_LINES.vat_exemption_type%TYPE ;
687: lv_vat_exemption_date JAI_AR_TRX_LINES.vat_exemption_date%TYPE ;
688: lv_vat_exemption_refno JAI_AR_TRX_LINES.vat_exemption_refno%TYPE ;
689: ln_vat_assessable_value JAI_AR_TRX_LINES.vat_assessable_value%TYPE ;
682: vsqlerrm VARCHAR2(240);
683: v_qty NUMBER; -- added by sriram
684: -- added, Harshita for bug#4245062
685: lv_vat_exemption_flag JAI_AR_TRX_LINES.vat_exemption_flag%TYPE ;
686: lv_vat_exemption_type JAI_AR_TRX_LINES.vat_exemption_type%TYPE ;
687: lv_vat_exemption_date JAI_AR_TRX_LINES.vat_exemption_date%TYPE ;
688: lv_vat_exemption_refno JAI_AR_TRX_LINES.vat_exemption_refno%TYPE ;
689: ln_vat_assessable_value JAI_AR_TRX_LINES.vat_assessable_value%TYPE ;
690: ln_vat_invoice_no JAI_AR_TRXS.vat_invoice_no %TYPE ;
683: v_qty NUMBER; -- added by sriram
684: -- added, Harshita for bug#4245062
685: lv_vat_exemption_flag JAI_AR_TRX_LINES.vat_exemption_flag%TYPE ;
686: lv_vat_exemption_type JAI_AR_TRX_LINES.vat_exemption_type%TYPE ;
687: lv_vat_exemption_date JAI_AR_TRX_LINES.vat_exemption_date%TYPE ;
688: lv_vat_exemption_refno JAI_AR_TRX_LINES.vat_exemption_refno%TYPE ;
689: ln_vat_assessable_value JAI_AR_TRX_LINES.vat_assessable_value%TYPE ;
690: ln_vat_invoice_no JAI_AR_TRXS.vat_invoice_no %TYPE ;
691: ln_vat_invoice_date JAI_AR_TRXS.vat_invoice_date%TYPE;
684: -- added, Harshita for bug#4245062
685: lv_vat_exemption_flag JAI_AR_TRX_LINES.vat_exemption_flag%TYPE ;
686: lv_vat_exemption_type JAI_AR_TRX_LINES.vat_exemption_type%TYPE ;
687: lv_vat_exemption_date JAI_AR_TRX_LINES.vat_exemption_date%TYPE ;
688: lv_vat_exemption_refno JAI_AR_TRX_LINES.vat_exemption_refno%TYPE ;
689: ln_vat_assessable_value JAI_AR_TRX_LINES.vat_assessable_value%TYPE ;
690: ln_vat_invoice_no JAI_AR_TRXS.vat_invoice_no %TYPE ;
691: ln_vat_invoice_date JAI_AR_TRXS.vat_invoice_date%TYPE;
692: -- ended, Harshita for bug#4245062
685: lv_vat_exemption_flag JAI_AR_TRX_LINES.vat_exemption_flag%TYPE ;
686: lv_vat_exemption_type JAI_AR_TRX_LINES.vat_exemption_type%TYPE ;
687: lv_vat_exemption_date JAI_AR_TRX_LINES.vat_exemption_date%TYPE ;
688: lv_vat_exemption_refno JAI_AR_TRX_LINES.vat_exemption_refno%TYPE ;
689: ln_vat_assessable_value JAI_AR_TRX_LINES.vat_assessable_value%TYPE ;
690: ln_vat_invoice_no JAI_AR_TRXS.vat_invoice_no %TYPE ;
691: ln_vat_invoice_date JAI_AR_TRXS.vat_invoice_date%TYPE;
692: -- ended, Harshita for bug#4245062
693:
1088:
1089: --ADDED TO CHECK DUPLICATE ENTRY FOR LINES 01-DEC-99 GAURAV.
1090: CURSOR DUPLICATE_LINES_CUR IS
1091: SELECT 1
1092: FROM JAI_AR_TRX_LINES
1093: WHERE customer_trx_LINE_id = v_customer_trx_line_id;
1094:
1095: CURSOR OLD_CUSTOMER_TRX_ID_CUR IS
1096: SELECT Customer_Trx_Id
1093: WHERE customer_trx_LINE_id = v_customer_trx_line_id;
1094:
1095: CURSOR OLD_CUSTOMER_TRX_ID_CUR IS
1096: SELECT Customer_Trx_Id
1097: FROM JAI_AR_TRX_LINES
1098: WHERE customer_trx_LINE_id = v_customer_trx_line_id;
1099: CURSOR DUPLICATE_TAX_LINES_CUR(v_tax_id NUMBER) IS
1100: SELECT 1
1101: FROM JAI_AR_TRX_TAX_LINES
1291: v_ato_line_amount Number;
1292: v_ato_tax_amount Number;
1293: v_ato_total_amount Number;
1294: -- v_ar3_form_no Number;
1295: v_ar3_form_no JAI_AR_TRX_LINES.ar3_form_no%TYPE; -- Vijay shankar for Bug # 3181892
1296: v_ar3_form_date Date;
1297:
1298: /*
1299: start additions by sriram - bug# 3607101
1595: NVL(r_add.SHIP_TO_SITE_USE_ID, r_add.BILL_TO_SITE_USE_ID),'C');
1596:
1597: for so_line_rec in c_get_om_lines(v_config_line_id)
1598: Loop
1599: Insert into JAI_AR_TRX_LINES
1600: (
1601: customer_trx_line_id ,
1602: customer_trx_id ,
1603: line_number ,
1670: );
1671:
1672: FND_FILE.PUT_LINE(FND_FILE.LOG,' Cursor . c_get_om_lines ');
1673: FND_FILE.PUT_LINE(FND_FILE.LOG,
1674: ' Inserted jai_ar_trx_lines for TRX LINE ID: '||v_customer_trx_line_id);
1675: FND_FILE.PUT_LINE(FND_FILE.LOG,' Trx id: ' || v_header_id);
1676:
1677: v_ato_line_amount := so_line_rec.line_amount;
1678: v_ato_tax_amount := NVL(v_ato_tax_amount,0) + NVL(v_tax_amount,0);
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
1824: from JAI_AR_TRX_LINES
1825: where customer_trx_id = pr_new.customer_trx_id;
1826:
1827: cursor c_default_location(CP_ORGANIZATION_ID number) is
1828: select DEFAULT_LOCATION_BILL_ONLY
2032: ' After insert into JAI_AR_TRXS - Bill only invoice');
2033: end if;
2034:
2035: /*
2036: insert into the JAI_AR_TRX_TAX_LINES table and then insert into the JAI_AR_TRX_LINES table.
2037: pr_new.interface_line_attribute6 = order_line_id
2038: pr_new.interface_line_context = 'ORDER ENTRY'
2039: */
2040:
2306: /*added by csahoo for bug#6498072, end*/
2307:
2308: /*moved the following code here for bug# 6498072*/
2309:
2310: INSERT INTO JAI_AR_TRX_LINES (
2311: customer_trx_line_id ,
2312: line_number ,
2313: customer_trx_id ,
2314: description ,
2445: 9. 2002/04/22 SRIRAM For Bug # 2316589 . The JAI_AR_TRXS table was updated with
2446: wrong values . Instead a new update has been written using a different value to
2447: update tax amounts correctly.
2448: 10 2002/06/26 SRIRAM For Bug # 2398198 . Tax Lines were inserted multiple times in the
2449: JAI_AR_TRX_TAX_LINES , JAI_AR_TRX_LINES tables when discounts
2450: exist and tax amounts were updated doubly in JAI_AR_TRXS table, which have been
2451: solved in this bug.
2452: 11. 2002/08/17 SRIRAM .Fopr Bug # 2518534 . When there is a change in UOM in the
2453: Sales order screen , the taxes in the localization screen are not
2468: For a Invoice line imported from OM , the interface_line_attribute11 will have a value 0 or Null ,
2469: whereas for a discount line , the interface_line_attribute11 will have a value which maps to the price_adjustment_id.
2470:
2471: 13. 2003/02/07 Vijay Shankar - Bug # 2779990 - Version is 615.4
2472: When bond transaction invoice is created, then tax_amounts populated in JAI_AR_TRXS and JAI_AR_TRX_LINES is wrong.
2473: this is rectified by writing a new cursor name c_tax_amount
2474:
2475: 14. 2003/03/17 Sriram LMW ATO Issue - Bug #2806274 Version 615.5
2476: Created an internal procedure Process_Taxes_for_ATO_Order to pull taxes from OM to Ar for ATO Orders.
2476: Created an internal procedure Process_Taxes_for_ATO_Order to pull taxes from OM to Ar for ATO Orders.
2477: The idea was to import the taxes for the 'Model' Item based on the config item.
2478:
2479: 15. 2003/06/26 Sriram - Bug # 3000550 version 616.1
2480: Tax amounts were not calculated correctly , in the JAI_AR_TRXS and JAI_AR_TRX_LINES
2481: table.This was observed when there was a split done during shipment.
2482: Data was correct in the JAI_AR_TRX_TAX_LINES table , but incorrect in the JAI_AR_TRX_LINES
2483: and JAI_AR_TRXS table.
2484: This has been fixed in this bug
2478:
2479: 15. 2003/06/26 Sriram - Bug # 3000550 version 616.1
2480: Tax amounts were not calculated correctly , in the JAI_AR_TRXS and JAI_AR_TRX_LINES
2481: table.This was observed when there was a split done during shipment.
2482: Data was correct in the JAI_AR_TRX_TAX_LINES table , but incorrect in the JAI_AR_TRX_LINES
2483: and JAI_AR_TRXS table.
2484: This has been fixed in this bug
2485:
2486: 16. 2003/08/22 Sriram - Bug # 3021588 version 616.2
2498: This is causing the unique constraint violation error. This has been resolved by making a change to ensure that
2499: entries in the ST forms table needs to go only if the St form Type is not null and tax type is 'Sales Tax' or 'CST'.
2500:
2501: 18 2003/10/10 Vijay shankar - Bug # 3181892, Version 616.4
2502: AR3 form number and date values are not populated into JAI_AR_TRX_LINES table which is resolved with this fix
2503:
2504: 19 2003/12/30 Aiyer - Bug #3328871, Version 618.1
2505:
2506: Issue: -
2505:
2506: Issue: -
2507: Create an order such that it does not have any associated taxes.
2508: Ship this order and run the auto invoice program.
2509: It is found that no records are inserted in the table JAI_AR_TRX_LINES.
2510:
2511: Solution: -
2512: This was happening because the code was assuming that a line cannot exist without any taxes.
2513: So in such a case the control was made to return back without inserting a line in JAI_AR_TRX_LINES
2509: It is found that no records are inserted in the table JAI_AR_TRX_LINES.
2510:
2511: Solution: -
2512: This was happening because the code was assuming that a line cannot exist without any taxes.
2513: So in such a case the control was made to return back without inserting a line in JAI_AR_TRX_LINES
2514: table.
2515:
2516: Fix Details:-
2517: Added a if clause in the code. Placed the return statement between the if clause.
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
2524: in table JAI_AR_TRX_LINES.
2525: This issue was reported thorugh the bug 3344492.
2526: Also indented the whole code and added additional comments wereever necessary.
2527: Removed the commented code wherever applicable.
2528:
2529: Dependency Introduced Due To This Bug:-
2530: None
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
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
2580: JAI_AR_TRXS also includes the Vat information that comes down from either JAI_OM_OE_SO_LINES
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
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
2640: Multipled p_quantity to the assesible value in the call to the procedure jai_rgm_thhold_proc_pkg.default_thhold_taxes
2641:
2642: 36. 18-OCT-2007 CSahoo for bug#6498072, File Version 120.22
2643: Added the cursor get_ar_tax_amount to get the total tax amount from JAI_AR_TRX_TAX_LINES table.
2644: Moved the code for Inserting into JAI_AR_TRX_LINES and updating the table JAI_AR_TRXS to the end in the procedure
2645: process_bill_only_invoice
2646:
2647: 37 11-Nov-2008 JMEENA for bug#6498345( FP 6492966 )
2648: Issue: AR Autoinvoice completes in Error: ORA-20130: ORGANIZATION CANNOT BE NULL
3146:
3147: v_service_type:=get_service_type( NVL(r_add.SHIP_TO_CUSTOMER_ID ,r_add.BILL_TO_CUSTOMER_ID) ,
3148: NVL(r_add.SHIP_TO_SITE_USE_ID, r_add.BILL_TO_SITE_USE_ID),'C');
3149:
3150: INSERT INTO JAI_AR_TRX_LINES (
3151: customer_trx_line_id ,
3152: line_number ,
3153: customer_trx_id ,
3154: description ,
3375: END LOOP;
3376: END IF;
3377: END IF;
3378:
3379: UPDATE JAI_AR_TRX_LINES
3380: SET payment_register = v_reg_type,
3381: excise_invoice_no = v_exc_invoice_no,
3382: excise_invoice_date = trunc(sysdate)
3383: WHERE
3967: ELSE
3968: v_calc_tax_amount := 0;
3969: END IF;
3970:
3971: INSERT INTO JAI_AR_TRX_LINES (
3972: customer_trx_line_id ,
3973: line_number ,
3974: customer_trx_id ,
3975: description ,
4049: --DELETE JAI_AR_TRX_INS_LINES_T
4050: --WHERE customer_trx_line_id = v_customer_trx_line_id;
4051:
4052: IF v_old_customer_trx_id <> v_header_id THEN
4053: UPDATE JAI_AR_TRX_LINES
4054: SET customer_trx_id = v_header_id
4055: WHERE customer_trx_line_id = v_customer_trx_line_id;
4056: DELETE JAI_AR_TRXS
4057: WHERE customer_trx_id = v_old_customer_trx_id;
4209: v_line_count NUMBER := 0; -- added on 14-jun-01 by subbu
4210: ln_legal_entity_id NUMBER ; /* rallamse bug#4448789 */
4211: v_service_type VARCHAR2(30); -- added by csahoo for bug#5879769
4212:
4213: -- cusrsor added to check duplication in JAI_AR_TRX_LINES for avoiding
4214: -- unique constraint violation
4215:
4216: CURSOR DUPLICATE_LINES_CUR IS
4217: SELECT 1
4214: -- unique constraint violation
4215:
4216: CURSOR DUPLICATE_LINES_CUR IS
4217: SELECT 1
4218: FROM JAI_AR_TRX_LINES
4219: WHERE customer_trx_LINE_id = v_customer_trx_line_id;
4220:
4221: CURSOR OLD_CUSTOMER_TRX_ID_CUR IS
4222: SELECT Customer_Trx_Id
4219: WHERE customer_trx_LINE_id = v_customer_trx_line_id;
4220:
4221: CURSOR OLD_CUSTOMER_TRX_ID_CUR IS
4222: SELECT Customer_Trx_Id
4223: FROM JAI_AR_TRX_LINES
4224: WHERE customer_trx_LINE_id = v_customer_trx_line_id;
4225:
4226: CURSOR CREATED_FROM_CUR IS
4227: SELECT created_from, trx_number, batch_source_id, set_of_books_id, primary_salesrep_id,
4453: The legal_entity_id is derived from CREATED_FROM_CUR cursor based on ra_customer_trx_all.
4454:
4455: 14. 24-Aug-2005 Ramananda for bug #4567935 (115 bug 4404898, 4395450). File version 120.2
4456: Issue:-
4457: 1. The following type of taxes should not be inserted into JAI_AR_TRX_LINES when Order type is BOND register:-
4458: 'EXCISE', 'OTHER EXCISE', 'CVD_EDUCATION_CESS', 'EXCISE_EDUCATION_CESS'
4459:
4460: 2. Trigger currently processing Credit memo invoices with interface line context as LEGACY.This needs to be stopped
4461:
4459:
4460: 2. Trigger currently processing Credit memo invoices with interface line context as LEGACY.This needs to be stopped
4461:
4462: Fix:-
4463: 1. Before a insert in the table JAI_AR_TRX_LINES, added a IF statement to bypass the insert into JAI_AR_TRX_LINES if
4464: the register code is 'BOND_REG' and any of the above stated taxes are present.
4465: 2. Added the check to RETURN from the trigger if interface line context = 'LEGACY'
4466:
4467: Dependency due to this bug :-
4758: v_tax_amount :=0;
4759: END IF;
4760:
4761:
4762: INSERT INTO JAI_AR_TRX_LINES
4763: (customer_trx_line_id,
4764: line_number,
4765: customer_trx_id,
4766: description,
4811: DELETE JAI_AR_TRX_INS_LINES_T
4812: WHERE Customer_Trx_Line_Id = v_customer_trx_line_id;
4813:
4814: IF v_old_customer_trx_id <> v_header_id THEN
4815: UPDATE JAI_AR_TRX_LINES
4816: SET Customer_Trx_Id = v_header_id
4817: WHERE Customer_Trx_Line_Id = v_customer_trx_line_id;
4818:
4819: DELETE JAI_AR_TRXS
5017: WHERE customer_trx_id = v_header_id;
5018:
5019: CURSOR old_line_amount_cur IS
5020: SELECT line_amount
5021: FROM JAI_AR_TRX_LINES
5022: WHERE CUSTOMER_TRX_ID = pr_old.CUSTOMER_TRX_ID
5023: AND CUSTOMER_TRX_LINE_ID = pr_old.CUSTOMER_TRX_LINE_ID;
5024:
5025: CURSOR gl_date_cur IS
5034: Where a.cust_trx_type_id = b.cust_trx_type_id
5035: And b.customer_trx_id = v_header_id
5036: And NVL(a.org_id,0) = NVL(pr_new.org_id,0);
5037:
5038: ln_vat_assessable_value JAI_AR_TRX_LINES.VAT_ASSESSABLE_VALUE%TYPE;
5039:
5040: /* Added by Ramananda as a part of removal of SQL LITERALs , start */
5041: lv_appl_src JAI_CMN_ERRORS_T.APPLICATION_SOURCE%type ;
5042: lv_add_err JAI_CMN_ERRORS_T.additional_error_mesg%type ;
5230:
5231: DELETE JAI_AR_TRX_TAX_LINES
5232: WHERE LINK_TO_CUST_TRX_LINE_ID = pr_old.CUSTOMER_TRX_LINE_ID;
5233:
5234: DELETE JAI_AR_TRX_LINES
5235: WHERE CUSTOMER_TRX_ID = pr_old.CUSTOMER_TRX_ID
5236: AND CUSTOMER_TRX_LINE_ID = pr_old.CUSTOMER_TRX_LINE_ID;
5237: END IF;
5238:
5439:
5440: Open Gl_Date_Cur;
5441: Fetch Gl_Date_Cur Into v_gl_date;
5442: Close Gl_Date_Cur;
5443: INSERT INTO JAI_AR_TRX_LINES(
5444: customer_trx_line_id,
5445: line_number,
5446: customer_trx_id,
5447: description,
5822: last_updated_by = v_last_updated_by,
5823: last_update_login = v_last_update_login
5824: WHERE customer_trx_id = v_header_id;
5825:
5826: UPDATE JAI_AR_TRX_LINES
5827: SET description = pr_new.description,
5828: inventory_item_id = pr_new.inventory_item_id,
5829: unit_code = pr_new.uom_code,
5830: quantity = pr_new.quantity_credited,
5982: Removed the reference to cursor set_of_books_cur
5983: as the SOB will never be null in base table.
5984: */
5985:
5986: ln_vat_assessable_value JAI_AR_TRX_LINES.VAT_ASSESSABLE_VALUE%TYPE;
5987: ld_trx_date DATE;
5988:
5989: BEGIN
5990: pv_return_code := jai_constants.successful ;
6063:
6064: 11. 18-Nov-2008 JMEENA for bug#6414523
6065: Issue: When selling price is changed, Excise Assessable Value should be updated correctly
6066: Reason: Excise Assessable value is derived but not updated in the table ja_in_ra_customer_trx_lines
6067: Fix: Modifed procedure ARU_T2. Added column assessable_value in the update statement of table JAI_AR_TRX_LINES.
6068:
6069: Future Dependencies For the release Of this Object:-
6070: (Please add a row in the section below only if your bug introduces a dependency due to spec change/ A new call to a object/
6071: A datamodel change )
6298: last_updated_by = v_last_updated_by,
6299: last_update_login = v_last_update_login
6300: WHERE customer_trx_id = v_header_id;
6301:
6302: UPDATE JAI_AR_TRX_LINES
6303: SET description = pr_new.description,
6304: inventory_item_id = pr_new.inventory_item_id,
6305: unit_code = pr_new.uom_code,
6306: quantity = v_new_quantity,
6350: AND b.customer_trx_id = r_new.customer_trx_id
6351: AND NVL(A.org_id,0) = NVL(r_new.org_id,0);
6352:
6353: r_trx_type c_transaction_type%rowtype; --Bug 6369471
6354: ln_quantity jai_ar_trx_lines.quantity%type; -- Bug 6369471
6355:
6356:
6357: cursor c_ra_customer_trx is
6358: select trx_number, trx_date, batch_source_id, set_of_books_id
6370: r_jai_ra_customer_trx c_jai_ra_customer_trx%rowtype;
6371:
6372: cursor c_jai_ra_customer_trx_line is
6373: select customer_trx_line_id
6374: from jai_ar_trx_lines
6375: where customer_trx_line_id = r_new.customer_trx_line_id;
6376: r_jai_ra_customer_trx_line c_jai_ra_customer_trx_line%rowtype;
6377:
6378: cursor c_get_project_id(cp_project_code in varchar2) is
6588: ln_line_tax_amt := nvl(ln_line_tax_amt,0) + ln_tax_amount;
6589:
6590: end loop;
6591:
6592: /* insert into jai_ar_trx_lines */
6593: open c_jai_ra_customer_trx_line;
6594: fetch c_jai_ra_customer_trx_line into r_jai_ra_customer_trx_line;
6595: close c_jai_ra_customer_trx_line;
6596:
6594: fetch c_jai_ra_customer_trx_line into r_jai_ra_customer_trx_line;
6595: close c_jai_ra_customer_trx_line;
6596:
6597: if r_jai_ra_customer_trx_line.customer_trx_line_id is null then
6598: INSERT INTO jai_ar_trx_lines (
6599: customer_trx_line_id ,
6600: line_number ,
6601: customer_trx_id ,
6602: description ,