[Home] [Help]
1: PACKAGE BODY JAI_MTL_TRXS_PKG AS
2: /* $Header: jai_mtl_trxs_pkg.plb 120.29.12020000.2 2012/12/24 13:22:30 mmurtuza ship $ */
3:
4: /*----------------------------------------------------------------------------------------------------------------------
5: CHANGE HISTORY: FILENAME: jai_mtl_trxs_pkg.plb
1: PACKAGE BODY JAI_MTL_TRXS_PKG AS
2: /* $Header: jai_mtl_trxs_pkg.plb 120.29.12020000.2 2012/12/24 13:22:30 mmurtuza ship $ */
3:
4: /*----------------------------------------------------------------------------------------------------------------------
5: CHANGE HISTORY: FILENAME: jai_mtl_trxs_pkg.plb
6: S.No Date Author and Details
1: PACKAGE BODY JAI_MTL_TRXS_PKG AS
2: /* $Header: jai_mtl_trxs_pkg.plb 120.29.12020000.2 2012/12/24 13:22:30 mmurtuza ship $ */
3:
4: /*----------------------------------------------------------------------------------------------------------------------
5: CHANGE HISTORY: FILENAME: jai_mtl_trxs_pkg.plb
6: S.No Date Author and Details
7: ------------------------------------------------------------------------------------------------------------------------
8: 1 24-Jan-2007 rchandan for #2942973 for File Version 115.6 (INTER ORG Impl.)
9: The parameter p_receipt_num in claim_balance_cgvat was defined as NUMBER and
122: issue is happening with the delete_trx_autonomous (Pragma autonomous
123: transaction) procedure.
124:
125: The below stmt has been executed from (JAINVMTX.KEY-COMMIT)-->
126: jai_mtl_trxs_pkg. sync_trx_with_base (delete_trx) procedure.
127:
128: Delete JAI_MTL_TRXS WHERE TRANSACTION_HEADER_ID = :B2 AND TRANSACTION_TEMP_ID
129: = NVL(:B1 , TRANSACTION_TEMP_ID ) AND TRANSACTION_COMMIT_DATE IS NULL.
130:
156: TST1212.XB1.QA.INCLUSIVE TAX IS NOT RIGHT FOR INTER-ORG TRANSFER TRANSACTION
157: if the interorg transfer has the inclusive taxes and the assessable price list is not \
158: attached to the internal ct,then the taxes are calculated wrongly.
159: issue is with the assessable_value being rounded.
160: In package jai_mtl_trxs_pkg.default_taxes, the variable is defined as
161: following:
162:
163: ln_assessable_value number(15);
164: ln_vat_assessable_value number(15);
1115: p_process_message := lv_process_message;
1116: RETURN;
1117: END IF;
1118: begin
1119: jai_mtl_trxs_pkg.do_cenvat_Acctg(
1120: p_set_of_books_id => p_set_of_books_id ,
1121: p_transaction_temp_id =>p_transaction_temp_id ,
1122: p_je_source_name =>v_source_name ,
1123: p_je_category_name =>v_category_name,
3458: lv_source_name := 'Purchasing India';
3459: lv_category_name:='MMT';/*6504150*/
3460: lv_reference_10 :='India Local Standard Cost Entry For INTERORG_XFER and Organization_code= '|| lv_organization_code ;
3461: lv_reference_entry := 'India Localization Entry';
3462: lv_reference_23:='jai_mtl_trxs_pkg.std_cost_entry';
3463: lv_reference_24:='jai_mtl_trxs';
3464: lv_reference_26:='transaction_id';
3465: lv_currency_code :='INR';
3466:
4023: NULL,
4024: r_mtl_params.organization_code,
4025: lv_reference_10,
4026: 'India Localization Entry',
4027: 'jai_mtl_trxs_pkg.auto_claim',
4028: 'rcv_transactions',
4029: 'rcv_Transaction_id',
4030: r_Trx.transaction_id,
4031: r_trx.organization_id
4137: NULL,
4138: r_mtl_params.organization_code,
4139: lv_reference_10,
4140: 'India Localization Entry',
4141: 'jai_mtl_trxs_pkg.auto_claim',
4142: 'rcv_transactions',
4143: 'rcv_Transaction_id',
4144: r_Trx.transaction_id,
4145: r_trx.organization_id
4315: NULL,
4316: r_mtl_params.organization_code,
4317: lv_reference_10,
4318: 'India Localization Entry',
4319: 'jai_mtl_trxs_pkg.auto_claim',
4320: 'rcv_transactions',
4321: 'rcv_Transaction_id',
4322: r_Trx.transaction_id,
4323: r_trx.organization_id
4430: NULL,
4431: r_mtl_params.organization_code,
4432: lv_reference_10,
4433: 'India Localization Entry',
4434: 'jai_mtl_trxs_pkg.auto_claim',
4435: 'rcv_transactions',
4436: 'rcv_Transaction_id',
4437: r_Trx.transaction_id,
4438: r_trx.organization_id
4546: NULL,
4547: r_mtl_params.organization_code,
4548: lv_reference_10,
4549: 'India Localization Entry',
4550: 'jai_mtl_trxs_pkg.auto_claim',
4551: 'rcv_transactions',
4552: 'rcv_Transaction_id',
4553: r_Trx.transaction_id,
4554: r_trx.organization_id
4661: NULL,
4662: r_mtl_params.organization_code,
4663: lv_reference_10,
4664: 'India Localization Entry',
4665: 'jai_mtl_trxs_pkg.auto_claim',
4666: 'rcv_transactions',
4667: 'rcv_Transaction_id',
4668: r_Trx.transaction_id,
4669: r_trx.organization_id
5171: lv_account_nature := 'VAT CLAIM';
5172: lv_source_name := 'Purchasing';
5173: lv_category_name := 'Receiving India';
5174: lv_reference_10 := 'VAT claim accounting';
5175: lv_reference_23 := 'jai_mtl_trxs_pkg.process_vat_claim_acctg';
5176: lv_reference_24 := 'jai_rgm_trx_records';
5177: lv_reference_26 := 'repository_id';
5178: lv_currency_code := jai_constants.func_curr;
5179: ld_accounting_date := TRUNC(SYSDATE);