[Home] [Help]
391: 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
392: exactly matches the jai_om_wsh_lines_all.delivery_detail_id and jai_ar_trxs.customer_trx_id the tracking of the source
393: becomes very difficult hence to have a clear demarcation between WSh and AR sources hence the source field has been added.
394:
395: Added 2 new parametes p_cess_amt and p_source to jai_om_rg_pkg.ja_in_rg_i_entry package.
396: This has been populated from this and jai_om_wsh_pkg.process_delivery procedure.
397:
398: A migration script has been provided to migrate the value for cess and source.
399:
398: A migration script has been provided to migrate the value for cess and source.
399:
400: Dependency due to this bug:-
401: 1. Datamodel change in table JAI_CMN_RG_I_TRXS, added the cess_amt and source fields
402: 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
403: 3. Modified the trigger jai_jar_t_aru_t1
404: 4. Procedure jai_om_wsh_pkg.process_delivery
405: 5. Report JAICMNRG1.rdf
406: 6. Created a migration script to populate cess_amt and source for Shipment and Receivable transactions.
411:
412: For a manual AR invoice with more than one line, the cess amount was being hit for the whole of the
413: invoice amount for each of the lines.
414:
415: Code changes are done in the package jai_om_rg_pkg as well this trigger.
416:
417: Code changes done in the package include calculating the cess amount for the current customer trx line id.
418:
419: Code changes done in the trigger include sending the customer trx line id when pla is hit . This is inline
428: Issue : Excise amount not hitting bond register in functional currency.
429: Fix : Excise and cess amounts would hit bond register in functional currency.
430: Changes are done in three objects.
431:
432: 1. Package jai_om_rg_pkg. - Added a parameter to the ja_in_register_txn_entry called p_currency_rate
433: It holds the currency conversion rate which would be multiplied by the transaction amts to
434: get the functional amounts.
435:
436: 2. Package jai_jar_t.plb - In the call to the ja_in_register_txn_entry procedure
440: the change is being reflected in the JAI_AR_TRXS table.
441:
442: Future Dependency due to this Bug
443: ------------------------
444: YES - A new parameter is added to the procedure - ja_in_register_txn_entry in the package jai_om_rg_pkg.
445: It has a technical dependency on jai_om_rg_pkg and Package jai_jar_t.plb.
446: It has functional dependency on jai_ract_trg.plb
447:
448:
441:
442: Future Dependency due to this Bug
443: ------------------------
444: YES - A new parameter is added to the procedure - ja_in_register_txn_entry in the package jai_om_rg_pkg.
445: It has a technical dependency on jai_om_rg_pkg and Package jai_jar_t.plb.
446: It has functional dependency on jai_ract_trg.plb
447:
448:
449: 18. 16-April-2007 ssawant for bug 5989740 ,File version 120.3
722: /*
723: || Start of bug 4566054
724: ||Code added by aiyer for the bug 4566054
725: ||The cess amount is also being maintained in jai_cmn_rg_i_trxs table at a delivery_detail_level
726: ||hence calculate the cess and pass it to the procedure jai_om_rg_pkg.ja_in_rg_i_entry with source as 'WSH'
727: */
728:
729: OPEN cur_get_trx_cess_amt(l_rec.line_id) ;
730: FETCH cur_get_trx_cess_amt INTO ln_trx_totcess_amt;
753: --Added by Xiao for Open Interface ER bug#11683927.
754: --Only for 'External' event, register should not be updated.
755: IF nvl(ln_external_flag, 0) = 0 THEN --Add nvl by Xiao for bug#11936390
756:
757: jai_om_rg_pkg.ja_in_rg_I_entry(
758:
759: p_fin_year => v_fin_year ,
760: p_org_id => v_org_id ,
761: p_location_id => v_loc_id ,
802:
803: --Added IF condition by Xiao for Open Interface ER bug#11683927.
804: --Only for 'External' event, register should not be updated.
805: IF nvl(ln_external_flag, 0)= 0 THEN --Add nvl by Xiao for bug#11936390
806: jai_om_rg_pkg.ja_in_rg23_part_I_entry(v_reg_type, v_fin_year, v_org_id,
807: v_loc_id,
808: l_rec.inventory_item_id, 33, SYSDATE, 'I',
809: l_rec.quantity_invoiced, l_rec.unit_code, l_rec.excise_invoice_no,
810: l_rec.excise_invoice_date, v_basic_ed, v_additional_ed,
861: END IF;
862: --2001/03/26 Manohar Mishra , added new parameter V_REG_CODE as below.
863: vsqlstmt := '23';
864: IF nvl(ln_external_flag, 0)= 0 THEN --Added by zhiwei for Bug#12537533 on 20110510
865: jai_om_rg_pkg.ja_in_rg23_part_II_entry(v_reg_code,v_reg_type, v_fin_year, v_org_id,
866: v_loc_id,
867: l_rec.inventory_item_id, 33, SYSDATE, v_part_i_register_id,
868: l_rec.excise_invoice_no, l_rec.excise_invoice_date ,
869: round(v_basic_ed), -- Vijay 2001/10/19
884: vsqlstmt := '24';
885: ELSIF l_rec.payment_register IN ('PLA') THEN
886: vsqlstmt := '25';
887: IF nvl(ln_external_flag, 0)= 0 THEN --Added by zhiwei for Bug#12537533 on 20110510
888: jai_om_rg_pkg.ja_in_pla_entry(v_org_id,
889: v_loc_id,
890: l_rec.inventory_item_id,
891: v_fin_year,
892: 33,
918:
919: --Added by Xiao for Open Interface ER bug#11683927 on 03-Mar-2011, begin
920: ------------------------------------------------------------------------------------
921: --For only for 'External' event, the program should only generate accounting.
922: --Accounting generation is invoked only in porcedure jai_om_rg_pkg.ja_in_pla_entry, and procedure
923: --jai_om_rg_pkg.ja_in_rg23_part_II_entry, so after the call for these two procedures,
924: --program returns, and RG register will not be updated.
925: IF ln_external_flag > 0 THEN
926: lv_ship_status := 'CLOSED' ;
919: --Added by Xiao for Open Interface ER bug#11683927 on 03-Mar-2011, begin
920: ------------------------------------------------------------------------------------
921: --For only for 'External' event, the program should only generate accounting.
922: --Accounting generation is invoked only in porcedure jai_om_rg_pkg.ja_in_pla_entry, and procedure
923: --jai_om_rg_pkg.ja_in_rg23_part_II_entry, so after the call for these two procedures,
924: --program returns, and RG register will not be updated.
925: IF ln_external_flag > 0 THEN
926: lv_ship_status := 'CLOSED' ;
927: UPDATE JAI_CMN_MATCH_RECEIPTS
971:
972: end if; -- 3496577
973: IF v_reg_code IN ('BOND_REG','23D_EXPORT_WITHOUT_EXCISE') THEN
974: vsqlstmt := '27';
975: jai_om_rg_pkg.ja_in_register_txn_entry(
976: v_org_id,
977: v_loc_id,
978: l_rec.excise_invoice_no,
979: 'BOND SALES',
1031: THEN
1032: v_oth_receipt_id := match_rec.receipt_id;
1033: END IF;
1034: vsqlstmt := '29';
1035: jai_om_rg_pkg.ja_in_rg23d_entry(
1036: v_register_id,
1037: v_org_id, v_loc_id,
1038: v_fin_year, 'I', l_rec.inventory_item_id,
1039: l_rec.customer_trx_line_id, l_rec.unit_code, l_rec.unit_code,