eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_OM_RG_PKG dependencies on JAI_OM_RG_PKG

Line 1: PACKAGE BODY jai_om_rg_pkg AS

1: PACKAGE BODY jai_om_rg_pkg AS
2: /* $Header: jai_om_rg.plb 120.41.12020000.4 2013/03/25 07:14:34 mmurtuza ship $ */
3:
4:
5: /*----------------------------------------------------------------------------------------

Line 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.

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

Line 218: jai_om_rg_pkg.plb

214:
215: ----------------------------------------------------------------------------------------------------------------------------------------------------
216: Current Version Current Bug Dependent Files Version Author Date Remarks
217: Of File On Bug/Patchset Dependent On
218: jai_om_rg_pkg.plb
219: ----------------------------------------------------------------------------------------------------------------------------------------------------
220: 120.4 4765347 JAIITMCL.fmb 120.9 Aiyer 02-DEC-2005
221: jai_om_wsh.plb 120.5 Aiyer 02-DEC-2005
222: ---------------------------------------------------------------------------------------------------------------------------------------------------- */

Line 323: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_cess_entries';

319: v_sh_cess_amount number;/*Bug 5989740 bduvarag*/
320: v_cess_paid_payable JAI_CMN_INVENTORY_ORGS.cess_paid_payable_account_id%type;
321: v_org_id JAI_OM_WSH_LINES_ALL.org_id%type;
322: ln_sh_Cess_paid_payable JAI_CMN_INVENTORY_ORGS.cess_paid_payable_account_id%type;/*Bug 5989740 bduvarag*/
323: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_cess_entries';
324:
325: /*
326: The procedure assumes that it will be called from the ja_in_accounting_entries procedure only when
327: it is an ISO order ie the comparison is to be done in ja_in_accounting _entries_procedure

Line 613: 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

609: CREATED BY : ssumaith
610: CREATED DATE : 11-JAN-2005
611: ENHANCEMENT BUG : 4136981
612: PURPOSE : To calculate cess amount in case of an AR transaction.
613: 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
614:
615: **********************************************************************/
616: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_cess_acctg_entries';
617: begin

Line 616: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_cess_acctg_entries';

612: PURPOSE : To calculate cess amount in case of an AR transaction.
613: 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
614:
615: **********************************************************************/
616: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_cess_acctg_entries';
617: begin
618:
619: Fnd_File.PUT_LINE(Fnd_File.LOG, ' Before calling gl_interface for credit entry for CESS' );
620:

Line 691: 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

687: CREATED BY : ssumaith
688: CREATED DATE : 11-JAN-2005
689: ENHANCEMENT BUG : 4136981
690: PURPOSE : To calculate cess amount in case of an OM transaction.
691: 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
692:
693: **********************************************************************/
694: is /* Added the having clause to the following cursor - ssumaith bug#4185392
695: This was done because if there is no cess amount, there is no need to call the insert row procedure

Line 837: 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

833: CREATED BY : ssumaith
834: CREATED DATE : 11-JAN-2005
835: ENHANCEMENT BUG : 4136981
836: PURPOSE : To calculate cess amount in case of an AR transaction.
837: 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
838: ====================================================================================
839: Change History
840: ====================================================================================
841: 1. 23-Aug-2005 Aiyer - Bug# 4541303 (Forward porting for the 11.5 bug 4538315) 120.4

Line 845: Code changes are done in the package jai_om_rg_pkg as well this trigger.

841: 1. 23-Aug-2005 Aiyer - Bug# 4541303 (Forward porting for the 11.5 bug 4538315) 120.4
842: For a manual AR invoice with more than one line, the cess amount was being hit for the whole of the
843: invoice amount for each of the lines.
844:
845: Code changes are done in the package jai_om_rg_pkg as well this trigger.
846:
847: Code changes done in the package include calculating the cess amount for the current customer trx line id.
848:
849: Code changes done in the trigger include sending the customer trx line id when pla is hit . This is inline

Line 884: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_ar_cess_register_entries';

880:
881: lv_process_flag varchar2(2);
882: lv_process_msg varchar2(1000);
883: ln_Cess_amount number := 0;
884: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_ar_cess_register_entries';
885:
886: begin
887:
888: For tax_type_rec in c_tax_type_rec

Line 938: 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

934: CREATED BY : ssumaith
935: CREATED DATE : 11-JAN-2005
936: ENHANCEMENT BUG : 4136981
937: PURPOSE : To paass register and accounting entries for education cess
938: 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
939:
940: **********************************************************************/
941: IS
942: cursor c_delivery_details is

Line 958: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_cess_register_entries';

954: ln_Cess_amount number;
955: ln_inv_orgn_id number;
956: ln_header_id number;
957: lv_source_name varchar2(20);
958: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_cess_register_entries';
959:
960: begin
961:
962: open c_delivery_details;

Line 1201: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_accounting_entries';

1197: v_requisition_line_id PO_REQUISITION_LINES_ALL.REQUISITION_LINE_ID%TYPE;
1198: ln_src_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
1199: ln_dest_excise_23d_account JAI_CMN_INVENTORY_ORGS.EXCISE_23D_ACCOUNT%TYPE;
1200: ln_dest_excise_rcvble_account JAI_CMN_INVENTORY_ORGS.EXCISE_RCVBLE_ACCOUNT%TYPE;
1201: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_accounting_entries';
1202:
1203:
1204: -- get the delivery details
1205: CURSOR c_get_delivery_details IS

Line 1895: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_rg_I_entry';

1891: FROM JAI_INV_ITM_SETUPS -- Commneted mtl_system_items by Brathod for Bug# 4299606 (DFF Elimination)
1892: WHERE inventory_item_id=p_inventory_item_id
1893: AND organization_id = p_org_id;
1894:
1895: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_rg_I_entry';
1896:
1897: /*bug 9122545*/
1898: CURSOR c_org_addl_rg_flag (cp_organization_id jai_cmn_inventory_orgs.organization_id%type,
1899: cp_location_id jai_cmn_inventory_orgs.location_id%type)

Line 1910: FILENAME: jai_om_rg_pkg.sql

1906: lv_allow_negative_rg_flag jai_cmn_inventory_orgs.allow_negative_rg_flag%type;
1907: /*end bug 9122545*/
1908:
1909: /*------------------------------------------------------------------------------------------
1910: FILENAME: jai_om_rg_pkg.sql
1911: CHANGE HISTORY:
1912: ------------------------------------------------------------------------------------------
1913: 1. 2002/07/03 Nagaraj.s - For Enh#2415656.
1914: The changes were done only in ja_in_pla_entry procedure.

Line 2048: Added 2 new parametes p_cess_amt and p_source to jai_om_rg_pkg.ja_in_rg_i_entry package.

2044: 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
2045: exactly matches the jai_om_wsh_lines_all.delivery_detail_id and jai_ar_trxs.customer_trx_id the tracking of the source
2046: becomes very difficult hence to have a clear demarcation between WSh and AR sources hence the source field has been added.
2047:
2048: Added 2 new parametes p_cess_amt and p_source to jai_om_rg_pkg.ja_in_rg_i_entry package.
2049: This has been populated from this and jai_om_wsh_pkg.process_delivery procedure.
2050:
2051: A migration script has been provided to migrate the value for cess and source.
2052:

Line 2055: 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

2051: A migration script has been provided to migrate the value for cess and source.
2052:
2053: Dependency due to this bug:-
2054: 1. Datamodel change in table JAI_CMN_RG_I_TRXS, added the cess_amt and source fields
2055: 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
2056: 3. Modified the trigger jai_jar_t_aru_t1
2057: 4. Procedure jai_om_wsh_pkg.process_delivery
2058: 5. Report JAICMNRG1.rdf
2059: 6. Created a migration script to populate cess_amt and source for Shipment and Receivable transactions.

Line 2068: 1. Package jai_om_rg_pkg. - Added a parameter to the ja_in_register_txn_entry called p_currency_rate

2064: Issue : Excise amount not hitting bond register in functional currency.
2065: Fix : Excise and cess amounts would hit bond register in functional currency.
2066: Changes are done in three objects.
2067:
2068: 1. Package jai_om_rg_pkg. - Added a parameter to the ja_in_register_txn_entry called p_currency_rate
2069: It holds the currency conversion rate which would be multiplied by the transaction amts to
2070: get the functional amounts.
2071:
2072: 2. Package jai_jar_t.plb - In the call to the ja_in_register_txn_entry procedure

Line 2080: YES - A new parameter is added to the procedure - ja_in_register_txn_entry in the package jai_om_rg_pkg.

2076: the change is being reflected in the JAI_AR_TRXS table.
2077:
2078: Future Dependency due to this Bug
2079: ------------------------
2080: YES - A new parameter is added to the procedure - ja_in_register_txn_entry in the package jai_om_rg_pkg.
2081: It has a technical dependency on jai_om_rg_pkg and Package jai_jar_t.plb.
2082: It has functional dependency on jai_ract_trg.plb
2083:
2084:

Line 2081: It has a technical dependency on jai_om_rg_pkg and Package jai_jar_t.plb.

2077:
2078: Future Dependency due to this Bug
2079: ------------------------
2080: YES - A new parameter is added to the procedure - ja_in_register_txn_entry in the package jai_om_rg_pkg.
2081: It has a technical dependency on jai_om_rg_pkg and Package jai_jar_t.plb.
2082: It has functional dependency on jai_ract_trg.plb
2083:
2084:
2085: 19. 09/10/2007 ssumaith - bug#6487667 - File version - 120.19

Line 2102: jai_om_rg_pkg.sql

2098:
2099: ----------------------------------------------------------------------------------------------------------------------------------------------------
2100: Current Version Current Bug Dependent Files Version Author Date Remarks
2101: Of File On Bug/Patchset Dependent On
2102: jai_om_rg_pkg.sql
2103: ------------------------------------------------------------------------------------------------------------------------------------------------
2104: 616.2 3021588 IN60104D1 + ssumaith 22/08/2003 Bond Register Enhancement
2105: 2801751 +
2106: 2769440

Line 2463: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_rg23_part_I_entry';

2459: WHERE customer_id = p_customer_id
2460: AND address_id = (SELECT cust_acct_site_id -- address_id
2461: FROM hz_cust_site_uses_all A -- Removed ra_site_uses_all for BUg# 4434287
2462: WHERE A.site_use_id = p_customer_site_id);
2463: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_rg23_part_I_entry';
2464: BEGIN
2465:
2466: v_basic_ed := p_basic_ed; --Ramananda for File.Sql.35
2467: v_additional_ed := p_additional_ed; --Ramananda for File.Sql.35

Line 2662: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_rg23_part_II_entry';

2658:
2659:
2660: ln_register_id number;
2661:
2662: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_rg23_part_II_entry';
2663: --Added by Xiao for Open Interface ER bug#11683927 on 03-Mar-2011, begin
2664: --------------------------------------------------------------------------------------
2665: /*CURSOR get_external_flag_cur IS
2666: SELECT COUNT(lines.customer_trx_id)

Line 3166: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_pla_entry';

3162: dual;
3163:
3164: ln_register_id JAI_CMN_RG_PLA_TRXS.REGISTER_ID%TYPE;
3165:
3166: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_pla_entry';
3167: --Added by Xiao for Open Interface ER bug#11683927 on 03-Mar-2011, begin
3168: --------------------------------------------------------------------------------------
3169: /*CURSOR get_external_flag_cur IS
3170: SELECT COUNT(lines.customer_trx_id)

Line 3198: fnd_file.put_line(fnd_file.log, '1 Start of procedure jai_om_rg_pkg.ja_in_pla_entry');

3194: ln_external_flag NUMBER;*/--Comments by zhiwei for Bug#12537533
3195: --------------------------------------------------------------------------------------
3196: --Added by Xiao for Open Interface ER bug#11683927 on 03-Mar-2011, end
3197: BEGIN
3198: fnd_file.put_line(fnd_file.log, '1 Start of procedure jai_om_rg_pkg.ja_in_pla_entry');
3199: OPEN RANGE_DIVISION_CUR;
3200: FETCH RANGE_DIVISION_CUR INTO v_range_no,v_division_no;
3201: CLOSE RANGE_DIVISION_CUR;
3202:

Line 3884: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_rg23d_entry';

3880: ln_dest_credit_acc_cess_paid JAI_CMN_INVENTORY_ORGS.cess_paid_payable_account_id%TYPE;
3881: ln_dest_credit_acc_shcess_paid JAI_CMN_INVENTORY_ORGS.sh_cess_paid_payable_acct_id%TYPE;
3882: /*End additons by mmurtuza for bug 16022303*/
3883:
3884: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_rg23d_entry';
3885:
3886:
3887:
3888:

Line 4474: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_register_txn_entry';

4470: ln_sh_Cess_Ctr number;/*Bug 5989740 bduvarag*/
4471:
4472: ln_customer_Trx_id number;
4473:
4474: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_om_rg_pkg.ja_in_register_txn_entry';
4475: /* added by nkodakan for the bug 16014871 starts */
4476: ln_rma_line_id number;
4477: ln_rma_header_id number;
4478: ln_ref_header_id number;

Line 4886: END jai_om_rg_pkg;

4882: /***************************** ja_in_rg23i_balance *************************************************************/
4883:
4884: /*Bug 9550254 - End*/
4885:
4886: END jai_om_rg_pkg;