[Home] [Help]
365: For shipment and Ar receivable transaction currently the transaction_id is 33 and in some cases where the jai_cmn_rg_i_trxs.ref_doc_id
366: exactly matches the jai_om_wsh_lines_all.delivery_detail_id and jai_ar_trxs.customer_trx_id the tracking of the source
367: becomes very difficult hence to have a clear demarcation between WSh and AR sources hence the source field has been added.
368:
369: Added 2 new parametes p_cess_amt and p_source to jai_om_rg_pkg.ja_in_rg_i_entry package.
370: This has been populated from this and jai_om_wsh_pkg.process_delivery procedure.
371:
372: A migration script has been provided to migrate the value for cess and source.
373:
372: A migration script has been provided to migrate the value for cess and source.
373:
374: Dependency due to this bug:-
375: 1. Datamodel change in table JAI_CMN_RG_I_TRXS, added the cess_amt and source fields
376: 2. Added two new parameters in jai_om_rg_pkg.ja_in_rg_i_entry procedure to insert data into JAI_CMN_RG_I_TRXS table
377: 3. Modified the trigger jai_jar_t_aru_t1
378: 4. Procedure jai_om_wsh_pkg.process_delivery
379: 5. Report JAICMNRG1.rdf
380: 6. Created a migration script to populate cess_amt and source for Shipment and Receivable transactions.
385:
386: For a manual AR invoice with more than one line, the cess amount was being hit for the whole of the
387: invoice amount for each of the lines.
388:
389: Code changes are done in the package jai_om_rg_pkg as well this trigger.
390:
391: Code changes done in the package include calculating the cess amount for the current customer trx line id.
392:
393: Code changes done in the trigger include sending the customer trx line id when pla is hit . This is inline
402: Issue : Excise amount not hitting bond register in functional currency.
403: Fix : Excise and cess amounts would hit bond register in functional currency.
404: Changes are done in three objects.
405:
406: 1. Package jai_om_rg_pkg. - Added a parameter to the ja_in_register_txn_entry called p_currency_rate
407: It holds the currency conversion rate which would be multiplied by the transaction amts to
408: get the functional amounts.
409:
410: 2. Package jai_jar_t.plb - In the call to the ja_in_register_txn_entry procedure
414: the change is being reflected in the JAI_AR_TRXS table.
415:
416: Future Dependency due to this Bug
417: ------------------------
418: YES - A new parameter is added to the procedure - ja_in_register_txn_entry in the package jai_om_rg_pkg.
419: It has a technical dependency on jai_om_rg_pkg and Package jai_jar_t.plb.
420: It has functional dependency on jai_ract_trg.plb
421:
422:
415:
416: Future Dependency due to this Bug
417: ------------------------
418: YES - A new parameter is added to the procedure - ja_in_register_txn_entry in the package jai_om_rg_pkg.
419: It has a technical dependency on jai_om_rg_pkg and Package jai_jar_t.plb.
420: It has functional dependency on jai_ract_trg.plb
421:
422:
423: 18. 16-April-2007 ssawant for bug 5989740 ,File version 120.3
647: /*
648: || Start of bug 4566054
649: ||Code added by aiyer for the bug 4566054
650: ||The cess amount is also being maintained in jai_cmn_rg_i_trxs table at a delivery_detail_level
651: ||hence calculate the cess and pass it to the procedure jai_om_rg_pkg.ja_in_rg_i_entry with source as 'WSH'
652: */
653:
654: OPEN cur_get_trx_cess_amt(l_rec.line_id) ;
655: FETCH cur_get_trx_cess_amt INTO ln_trx_totcess_amt;
674: ELSIF l_rec.payment_register = 'PLA' THEN
675: v_payment_register := 'PLA';
676: END IF;
677: vsqlstmt := '19';
678: jai_om_rg_pkg.ja_in_rg_I_entry(
679:
680: p_fin_year => v_fin_year ,
681: p_org_id => v_org_id ,
682: p_location_id => v_loc_id ,
718: v_reg_type := 'A';
719: END IF;
720: IF v_item_class IN ('RMIN','RMEX','CGIN','CGEX') THEN
721: vsqlstmt := '21';
722: jai_om_rg_pkg.ja_in_rg23_part_I_entry(v_reg_type, v_fin_year, v_org_id,
723: v_loc_id,
724: l_rec.inventory_item_id, 33, SYSDATE, 'I',
725: l_rec.quantity_invoiced, l_rec.unit_code, l_rec.excise_invoice_no,
726: l_rec.excise_invoice_date, v_basic_ed, v_additional_ed,
775: v_remarks := 'Against Modvat Recovery'||'-'||l_rec.EXCISE_EXEMPT_TYPE;
776: END IF;
777: --2001/03/26 Manohar Mishra , added new parameter V_REG_CODE as below.
778: vsqlstmt := '23';
779: jai_om_rg_pkg.ja_in_rg23_part_II_entry(v_reg_code,v_reg_type, v_fin_year, v_org_id,
780: v_loc_id,
781: l_rec.inventory_item_id, 33, SYSDATE, v_part_i_register_id,
782: l_rec.excise_invoice_no, l_rec.excise_invoice_date ,
783: round(v_basic_ed), -- Vijay 2001/10/19
796: );
797: vsqlstmt := '24';
798: ELSIF l_rec.payment_register IN ('PLA') THEN
799: vsqlstmt := '25';
800: jai_om_rg_pkg.ja_in_pla_entry(v_org_id,
801: v_loc_id,
802: l_rec.inventory_item_id,
803: v_fin_year,
804: 33,
865:
866: end if; -- 3496577
867: IF v_reg_code IN ('BOND_REG','23D_EXPORT_WITHOUT_EXCISE') THEN
868: vsqlstmt := '27';
869: jai_om_rg_pkg.ja_in_register_txn_entry(
870: v_org_id,
871: v_loc_id,
872: l_rec.excise_invoice_no,
873: 'BOND SALES',
925: THEN
926: v_oth_receipt_id := match_rec.receipt_id;
927: END IF;
928: vsqlstmt := '29';
929: jai_om_rg_pkg.ja_in_rg23d_entry(
930: v_register_id,
931: v_org_id, v_loc_id,
932: v_fin_year, 'I', l_rec.inventory_item_id,
933: l_rec.customer_trx_line_id, l_rec.unit_code, l_rec.unit_code,