[Home] [Help]
1: PACKAGE BODY jai_om_rg_pkg AS
2: /* $Header: jai_om_rg.plb 120.20.12010000.4 2008/11/20 06:40:12 mbremkum ship $ */
3:
4:
5: /*----------------------------------------------------------------------------------------
146:
147: Fix :
148:
149: Made the following changes
150: a) in the jai_om_rg_pkg, when the insert into the JAI_OM_OE_BOND_TRXS table happens through the ja_in_register_txn_entry procedure , insert of excise invoice number into picking header id has been removed.
151: Instead the picking_line_id is stamped with the delivery_id / customer_trx_line_id in case of OM / AR respectively.
152:
153: 34. 14-May-2008 Changes by nprashar for bug # 6710747.
154: Issue:INTER-ORGANIZATION TRANSFER WITH EXCISE TAXES FAILS
175:
176: ----------------------------------------------------------------------------------------------------------------------------------------------------
177: Current Version Current Bug Dependent Files Version Author Date Remarks
178: Of File On Bug/Patchset Dependent On
179: jai_om_rg_pkg.plb
180: ----------------------------------------------------------------------------------------------------------------------------------------------------
181: 120.4 4765347 JAIITMCL.fmb 120.9 Aiyer 02-DEC-2005
182: jai_om_wsh.plb 120.5 Aiyer 02-DEC-2005
183: ---------------------------------------------------------------------------------------------------------------------------------------------------- */
280: v_sh_cess_amount number;/*Bug 5989740 bduvarag*/
281: v_cess_paid_payable JAI_CMN_INVENTORY_ORGS.cess_paid_payable_account_id%type;
282: v_org_id JAI_OM_WSH_LINES_ALL.org_id%type;
283: ln_sh_Cess_paid_payable JAI_CMN_INVENTORY_ORGS.cess_paid_payable_account_id%type;/*Bug 5989740 bduvarag*/
284: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_cess_entries';
285:
286: /*
287: The procedure assumes that it will be called from the ja_in_accounting_entries procedure only when
288: it is an ISO order ie the comparison is to be done in ja_in_accounting _entries_procedure
569: CREATED BY : ssumaith
570: CREATED DATE : 11-JAN-2005
571: ENHANCEMENT BUG : 4136981
572: PURPOSE : To calculate cess amount in case of an AR transaction.
573: CALLED FROM : jai_om_rg_pkg.ja_in_rg23_part_ii_entry , jai_om_rg_pkg.pla_emtry , jai_om_rg_pkg.ja_in23d_entry
574:
575: **********************************************************************/
576: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_cess_acctg_entries';
577: begin
572: PURPOSE : To calculate cess amount in case of an AR transaction.
573: CALLED FROM : jai_om_rg_pkg.ja_in_rg23_part_ii_entry , jai_om_rg_pkg.pla_emtry , jai_om_rg_pkg.ja_in23d_entry
574:
575: **********************************************************************/
576: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_cess_acctg_entries';
577: begin
578:
579: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Before calling gl_interface for credit entry for CESS' );
580:
647: CREATED BY : ssumaith
648: CREATED DATE : 11-JAN-2005
649: ENHANCEMENT BUG : 4136981
650: PURPOSE : To calculate cess amount in case of an OM transaction.
651: CALLED FROM : jai_om_rg_pkg.ja_in_rg23_part_ii_entry , jai_om_rg_pkg.pla_emtry , jai_om_rg_pkg.ja_in23d_entry
652:
653: **********************************************************************/
654: is /* Added the having clause to the following cursor - ssumaith bug#4185392
655: This was done because if there is no cess amount, there is no need to call the insert row procedure
793: CREATED BY : ssumaith
794: CREATED DATE : 11-JAN-2005
795: ENHANCEMENT BUG : 4136981
796: PURPOSE : To calculate cess amount in case of an AR transaction.
797: CALLED FROM : jai_om_rg_pkg.ja_in_rg23_part_ii_entry , jai_om_rg_pkg.pla_emtry , jai_om_rg_pkg.ja_in23d_entry
798: ====================================================================================
799: Change History
800: ====================================================================================
801: 1. 23-Aug-2005 Aiyer - Bug# 4541303 (Forward porting for the 11.5 bug 4538315) 120.4
801: 1. 23-Aug-2005 Aiyer - Bug# 4541303 (Forward porting for the 11.5 bug 4538315) 120.4
802: For a manual AR invoice with more than one line, the cess amount was being hit for the whole of the
803: invoice amount for each of the lines.
804:
805: Code changes are done in the package jai_om_rg_pkg as well this trigger.
806:
807: Code changes done in the package include calculating the cess amount for the current customer trx line id.
808:
809: Code changes done in the trigger include sending the customer trx line id when pla is hit . This is inline
834:
835: lv_process_flag varchar2(2);
836: lv_process_msg varchar2(1000);
837: ln_Cess_amount number := 0;
838: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_ar_cess_register_entries';
839:
840: begin
841:
842: For tax_type_rec in c_tax_type_rec
888: CREATED BY : ssumaith
889: CREATED DATE : 11-JAN-2005
890: ENHANCEMENT BUG : 4136981
891: PURPOSE : To paass register and accounting entries for education cess
892: CALLED FROM : jai_om_rg_pkg.ja_in_rg23_part_ii_entry , jai_om_rg_pkg.pla_emtry , jai_om_rg_pkg.ja_in23d_entry
893:
894: **********************************************************************/
895: IS
896: cursor c_delivery_details is
908: ln_Cess_amount number;
909: ln_inv_orgn_id number;
910: ln_header_id number;
911: lv_source_name varchar2(20);
912: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_cess_register_entries';
913:
914: begin
915:
916: open c_delivery_details;
1151: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
1152: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
1153: ln_dest_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
1154: ln_dest_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
1155: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_accounting_entries';
1156:
1157:
1158: -- get the delivery details
1159: CURSOR c_get_delivery_details IS
1810: FROM JAI_INV_ITM_SETUPS -- Commneted mtl_system_items by Brathod for Bug# 4299606 (DFF Elimination)
1811: WHERE inventory_item_id=p_inventory_item_id
1812: AND organization_id = p_org_id;
1813:
1814: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_rg_I_entry';
1815:
1816: /*------------------------------------------------------------------------------------------
1817: FILENAME: jai_om_rg_pkg.sql
1818: CHANGE HISTORY:
1813:
1814: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_rg_I_entry';
1815:
1816: /*------------------------------------------------------------------------------------------
1817: FILENAME: jai_om_rg_pkg.sql
1818: CHANGE HISTORY:
1819: ------------------------------------------------------------------------------------------
1820: 1. 2002/07/03 Nagaraj.s - For Enh#2415656.
1821: The changes were done only in ja_in_pla_entry procedure.
1951: 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
1952: exactly matches the jai_om_wsh_lines_all.delivery_detail_id and jai_ar_trxs.customer_trx_id the tracking of the source
1953: becomes very difficult hence to have a clear demarcation between WSh and AR sources hence the source field has been added.
1954:
1955: Added 2 new parametes p_cess_amt and p_source to jai_om_rg_pkg.ja_in_rg_i_entry package.
1956: This has been populated from this and jai_om_wsh_pkg.process_delivery procedure.
1957:
1958: A migration script has been provided to migrate the value for cess and source.
1959:
1958: A migration script has been provided to migrate the value for cess and source.
1959:
1960: Dependency due to this bug:-
1961: 1. Datamodel change in table JAI_CMN_RG_I_TRXS, added the cess_amt and source fields
1962: 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
1963: 3. Modified the trigger jai_jar_t_aru_t1
1964: 4. Procedure jai_om_wsh_pkg.process_delivery
1965: 5. Report JAICMNRG1.rdf
1966: 6. Created a migration script to populate cess_amt and source for Shipment and Receivable transactions.
1971: Issue : Excise amount not hitting bond register in functional currency.
1972: Fix : Excise and cess amounts would hit bond register in functional currency.
1973: Changes are done in three objects.
1974:
1975: 1. Package jai_om_rg_pkg. - Added a parameter to the ja_in_register_txn_entry called p_currency_rate
1976: It holds the currency conversion rate which would be multiplied by the transaction amts to
1977: get the functional amounts.
1978:
1979: 2. Package jai_jar_t.plb - In the call to the ja_in_register_txn_entry procedure
1983: the change is being reflected in the JAI_AR_TRXS table.
1984:
1985: Future Dependency due to this Bug
1986: ------------------------
1987: YES - A new parameter is added to the procedure - ja_in_register_txn_entry in the package jai_om_rg_pkg.
1988: It has a technical dependency on jai_om_rg_pkg and Package jai_jar_t.plb.
1989: It has functional dependency on jai_ract_trg.plb
1990:
1991:
1984:
1985: Future Dependency due to this Bug
1986: ------------------------
1987: YES - A new parameter is added to the procedure - ja_in_register_txn_entry in the package jai_om_rg_pkg.
1988: It has a technical dependency on jai_om_rg_pkg and Package jai_jar_t.plb.
1989: It has functional dependency on jai_ract_trg.plb
1990:
1991:
1992: 19. 09/10/2007 ssumaith - bug#6487667 - File version - 120.19
2002:
2003: ----------------------------------------------------------------------------------------------------------------------------------------------------
2004: Current Version Current Bug Dependent Files Version Author Date Remarks
2005: Of File On Bug/Patchset Dependent On
2006: jai_om_rg_pkg.sql
2007: ------------------------------------------------------------------------------------------------------------------------------------------------
2008: 616.2 3021588 IN60104D1 + ssumaith 22/08/2003 Bond Register Enhancement
2009: 2801751 +
2010: 2769440
2300: WHERE customer_id = p_customer_id
2301: AND address_id = (SELECT cust_acct_site_id -- address_id
2302: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for BUg# 4434287
2303: WHERE A.site_use_id = p_customer_site_id);
2304: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_rg23_part_I_entry';
2305: BEGIN
2306:
2307: v_basic_ed := p_basic_ed; --Ramananda for File.Sql.35
2308: v_additional_ed := p_additional_ed; --Ramananda for File.Sql.35
2492: location_id = p_location_id;
2493:
2494: ln_register_id number;
2495:
2496: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_rg23_part_II_entry';
2497:
2498: BEGIN
2499:
2500:
2930: dual;
2931:
2932: ln_register_id JAI_CMN_RG_PLA_TRXS.REGISTER_ID%TYPE;
2933:
2934: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_pla_entry';
2935:
2936: BEGIN
2937: fnd_file.put_line(fnd_file.log, '1 Start of procedure jai_om_rg_pkg.ja_in_pla_entry');
2938: OPEN RANGE_DIVISION_CUR;
2933:
2934: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_pla_entry';
2935:
2936: BEGIN
2937: fnd_file.put_line(fnd_file.log, '1 Start of procedure jai_om_rg_pkg.ja_in_pla_entry');
2938: OPEN RANGE_DIVISION_CUR;
2939: FETCH RANGE_DIVISION_CUR INTO v_range_no,v_division_no;
2940: CLOSE RANGE_DIVISION_CUR;
2941:
3574: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
3575: ln_dest_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
3576: ln_dest_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
3577:
3578: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_rg23d_entry';
3579:
3580:
3581:
3582:
4061: ln_sh_Cess_Ctr number;/*Bug 5989740 bduvarag*/
4062:
4063: ln_customer_Trx_id number;
4064:
4065: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_register_txn_entry';
4066:
4067: BEGIN
4068:
4069: if p_order_flag = 'Y' then
4334: END ja_in_register_txn_entry;
4335: /***************************** JA_IN_REGISTER_TXN_ENTRY *************************************************************/
4336:
4337:
4338: END jai_om_rg_pkg;