The following lines contain the word 'select', 'insert', 'update' or 'delete':
Reset the variable lv_debit and lv_credit to NULL in the procedure insert_rg_others.
Added the code to populate the gl_interface table for the SH CESS accounting and added conditions
to verify that Cenvat / Cess / SH Cess Accounts are not NULL.
06-Oct-2012 14259917 By anupgupt
Description - GL - LINE DRILLDOWN NOT WORKING FOR SOME IL TRANSACTIONS
Fix - Made chagnes for GL drilldown and View accounting options to work for RG Fund Transfer transactions.
*/
PROCEDURE balance_transfer (
p_organization_id NUMBER,
p_to_organization_id NUMBER,
p_location_id NUMBER,
p_to_location_id NUMBER,
p_register VARCHAR2,
p_amount NUMBER,
p_cess_amount NUMBER,/*Bug 5989740 bduvarag*/
p_sh_cess_amount NUMBER,
p_process_flag OUT NOCOPY VARCHAR2,
p_process_message OUT NOCOPY VARCHAR2,
p_transfer_id NUMBER DEFAULT NULL -- for bug 14259917 by anupgupt
) IS
/* Added by Ramananda for bug#4407165 */
lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_transfer_pkg.balance_transfer';
select nvl(rg23a_balance,0), nvl(rg23c_balance,0), nvl(pla_balance,0)
from JAI_CMN_RG_BALANCES
where organization_id = p_organization_id
and location_id = p_location_id;
SELECT NVL(SUM(balance),0) balance
FROM JAI_CMN_RG_OTH_BALANCES a,
JAI_CMN_INVENTORY_ORGS b
WHERE a.org_unit_id = b.org_unit_id
AND b.organization_id = p_organization_id
AND b.location_id = p_location_id
AND a.register_type = p_register_type
AND a.tax_type in (jai_constants.tax_type_exc_edu_cess,jai_constants.tax_type_cvd_edu_cess)
AND a.tax_type = NVL(p_tax_type,a.tax_type);
SELECT NVL(SUM(balance),0) balance
FROM JAI_CMN_RG_OTH_BALANCES a,
JAI_CMN_INVENTORY_ORGS b
WHERE a.org_unit_id = b.org_unit_id
AND b.organization_id = p_organization_id
AND b.location_id = p_location_id
AND a.register_type = p_register_type
AND a.tax_type in (jai_constants.tax_type_sh_exc_edu_cess,jai_constants.tax_type_sh_cvd_edu_cess)
AND a.tax_type = NVL(p_tax_type,a.tax_type);
select count(1)
from JAI_CMN_RG_BALANCES
where organization_id = p_to_organization_id
and location_id = p_to_location_id;
SELECT nvl(closing_balance,0)
FROM JAI_CMN_RG_23AC_II_TRXS
WHERE organization_id = p_org_id
AND location_id = p_location_id
AND slno = p_serial_no
AND register_type = p_register_type
AND fin_year = p_fin_year;
SELECT nvl(max(slno),0)
FROM JAI_CMN_RG_23AC_II_TRXS
WHERE organization_id = p_org_id
and location_id = p_location_id
and fin_year = p_fin_year
and register_type = p_register_type;
Select max(fin_year) fin_year
From JAI_CMN_FIN_YEARS
Where organization_id = p_org_id and
NVL(fin_active_flag,'N') = 'Y';
Select max(fin_year) fin_year
From JAI_CMN_RG_23AC_II_TRXS
Where organization_id = p_org_id
and location_id = p_location_id
and register_type = p_register;
Select max(fin_year) fin_year
From JAI_CMN_RG_PLA_TRXS
Where organization_id = p_org_id
and location_id = p_location_id;
SELECT nvl(max(slno),0)
FROM JAI_CMN_RG_PLA_TRXS
WHERE organization_id = p_org_id
and location_id = p_location_id
and fin_year = p_fin_year;
SELECT nvl(closing_balance,0)
FROM JAI_CMN_RG_PLA_TRXS
WHERE organization_id = p_org_id
AND location_id = p_location_id
AND slno = p_previous_serial_no
AND fin_year = p_fin_year;
SELECT currency_code
FROM JAI_CMN_RG_BALANCES_v
WHERE organization_id = p_Organization_ID and Location_ID = p_Location_ID;
SELECT MODVAT_RM_ACCOUNT_ID
FROM JAI_CMN_INVENTORY_ORGS
WHERE organization_id = p_orgid
AND location_id = p_locid;
SELECT MODVAT_CG_ACCOUNT_ID
FROM JAI_CMN_INVENTORY_ORGS
WHERE organization_id = p_orgid
AND location_id = p_locid;
SELECT MODVAT_PLA_ACCOUNT_ID
FROM JAI_CMN_INVENTORY_ORGS
WHERE organization_id = p_orgid
AND location_id = p_locid;
SELECT
decode( p_regtyp,
'A', EXCISE_EDU_CESS_RM_ACCOUNT,
'C', EXCISE_EDU_CESS_CG_ACCOUNT
) cess_account_id,
--added by JMEENA for BUG#7260552
decode( p_regtyp,
'A', SH_CESS_RM_ACCOUNT,
'C', SH_CESS_CG_ACCOUNT_ID
) sh_cess_account_id
FROM
JAI_CMN_INVENTORY_ORGS
WHERE organization_id = p_orgid
AND location_id = p_locid;
PROCEDURE insert_rg_others( p_organization_id IN JAI_CMN_INVENTORY_ORGS.organization_id%TYPE,
p_location_id IN JAI_CMN_INVENTORY_ORGS.location_id%TYPE,
p_register_type IN VARCHAR2,
p_source_register IN VARCHAR2,
p_excise_cess_amount IN NUMBER,
p_sh_exc_cess_amount IN NUMBER, /*Bug 5989740 bduvarag*/
p_sh_cvd_cess_amount IN NUMBER, /*Bug 5989740 bduvarag*/
p_cvd_cess_amount IN NUMBER,
p_transfer_from_to IN VARCHAR2,
p_register_id IN NUMBER,
p_fin_year IN NUMBER)
IS
/* Added by Ramananda for bug#4407165 */
lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_transfer_pkg.insert_rg_others';
select max(slno) slno
from JAI_CMN_RG_PLA_TRXS a
where organization_id = p_organization_id
and location_id = p_location_id
and fin_year = p_fin_year
and register_id < 0
and exists (select '1'
from JAI_CMN_RG_OTHERS
where source_type = 2 --2 is for PLA
and source_register_id = a.register_id
and tax_type = c_tax_type);
Select NVL(a.closing_balance,0) closing_balance
from JAI_CMN_RG_OTHERS a,
JAI_CMN_RG_PLA_TRXS b
Where a.source_type = 2 --2 is for PLA
AND b.register_id = a.source_register_id
AND b.organization_id = p_organization_id
and b.location_id = p_location_id
and a.tax_type = c_tax_type
and b.slno = c_slno
and b.fin_year = p_fin_year;
Select nvl(a.closing_balance,0) closing_balance
from JAI_CMN_RG_OTHERS a
Where a.source_type = 2 --2 is for PLA
and a.tax_type = c_tax_type /*Bug 5141459 bduvarag*/
AND a.source_register_id = (SELECT b.register_id
FROM JAI_CMN_RG_PLA_TRXS b
WHERE b.slno =(
SELECT MAX(JIP.slno)
FROM JAI_CMN_RG_PLA_TRXS JIP
WHERE JIP.organization_id = p_organization_id
AND JIP.location_id = p_location_id
AND JIP.fin_year = p_fin_year
AND JIP.register_id > 0
AND EXISTS (SELECT '1'
FROM JAI_CMN_RG_OTHERS
WHERE source_type = 2
AND source_register_id = JIP.register_id
AND source_register = p_source_register
AND tax_type = c_tax_type)
)
AND b.organization_id = p_organization_id
AND b.location_id = p_location_id
AND b.fin_year = p_fin_year
);
select max(slno) slno
from JAI_CMN_RG_23AC_II_TRXS a
where organization_id = p_organization_id
and location_id = p_location_id
and fin_year = p_fin_year
AND register_type = c_register_type
and register_id < 0
and exists (select '1'
from JAI_CMN_RG_OTHERS
where source_type = 1 --1 is for RG23
and source_register_id = a.register_id
and source_register = c_source_register
and tax_type = c_tax_type);
Select NVL(a.closing_balance,0) closing_balance
from JAI_CMN_RG_OTHERS a,
JAI_CMN_RG_23AC_II_TRXS b
Where a.source_type = 1 --1 is for RG23
AND b.register_id = a.source_register_id
AND b.organization_id = p_organization_id
and b.location_id = p_location_id
and a.tax_type = c_tax_type
and b.slno = c_slno
and b.fin_year = p_fin_year
and b.register_type = c_register_type
AND a.source_register = c_source_register;
Select nvl(a.closing_balance,0) closing_balance
from JAI_CMN_RG_OTHERS a
Where a.source_type = 1 --1 is for RG23
and a.tax_type = c_tax_type
and a.source_register = c_source_register/*Bug 5141459 bduvarag*/
AND a.source_register_id = (SELECT register_id
FROM JAI_CMN_RG_23AC_II_TRXS b
WHERE b.slno =(
SELECT MAX(JIRP.slno)
FROM JAI_CMN_RG_23AC_II_TRXS JIRP
WHERE JIRP.organization_id = p_organization_id
AND JIRP.location_id = p_location_id
AND JIRP.fin_year = p_fin_year
AND JIRP.register_type = p_register_type
AND EXISTS (SELECT '1'
FROM JAI_CMN_RG_OTHERS
WHERE source_type = 2
AND source_register_id = JIRP.register_id
AND source_register = p_source_register
AND tax_type = c_tax_type
)
)
AND b.organization_id = p_organization_id
AND b.location_id = p_location_id
AND b.fin_year = p_fin_year
AND b.register_type = p_register_type
);
SELECT nvl(a.closing_balance,0) closing_balance
FROM JAI_CMN_RG_OTHERS a
WHERE a.source_type = 2 --2 is for JAI_CMN_RG_PLA_TRXS
AND a.source_register = c_source_register
AND a.tax_type = c_tax_type
AND abs(a.source_register_id) = (SELECT max(abs(c.source_register_id))
FROM JAI_CMN_RG_PLA_TRXS b,
JAI_CMN_RG_OTHERS c
WHERE b.register_id = c.source_register_id
AND b.organization_id = c_organization_id
AND b.location_id = c_location_id
AND c.tax_type = c_tax_type
AND c.source_type = 2 --2 is for JAI_CMN_RG_PLA_TRXS
AND c.source_register = c_source_register);
SELECT nvl(a.closing_balance,0) closing_balance
FROM JAI_CMN_RG_OTHERS a
WHERE a.source_type = 1 --1 is for JAI_CMN_RG_23AC_II_TRXS
AND a.source_register = c_source_register
AND a.tax_type = c_tax_type
AND abs(a.source_register_id) = (SELECT max(abs(c.source_register_id))
FROM JAI_CMN_RG_23AC_II_TRXS b,
JAI_CMN_RG_OTHERS c
WHERE b.register_id = c.source_register_id
AND b.organization_id = c_organization_id
AND b.location_id = c_location_id
AND b.register_type = c_register_type
AND c.tax_type = c_tax_type
AND c.source_type = 1 --1 is for JAI_CMN_RG_23AC_II_TRXS
AND c.source_register = c_source_register);*/
INSERT INTO JAI_CMN_RG_OTHERS
(RG_OTHER_ID,
SOURCE_TYPE,
SOURCE_REGISTER,
SOURCE_REGISTER_ID,
TAX_TYPE,
DEBIT,
CREDIT,
OPENING_BALANCE,
CLOSING_BALANCE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE)
VALUES
(JAI_CMN_RG_OTHERS_S.nextval,
v_source_type,
p_source_register,
p_register_id,
v_tax_type,
lv_debit,
lv_credit,
v_cess_opening_balance,
v_cess_closing_balance,
uid,
sysdate,
uid,
sysdate);
p_process_message := 'error in insert_rg_others proc ' ||sqlerrm;/*Bug 5989740 bduvarag*/
END insert_rg_others;
/* Following two Inserts will insert excise amount data into gl_interface table */
jai_cmn_gl_pkg.create_gl_entry
(p_org_id,
lv_currency,
p_excise_debit, /* rallamse bug#4404994 reversed p_excise_debit and p_excise_credit */
p_excise_credit, --null
p_account_id,
'Register India',
'Register India',
to_number(fnd_profile.value('USER_ID')),
NULL,
NULL,
NULL,
NULL,
p_v_reference10,
p_v_reference23,
p_v_reference24,
p_v_reference25,
--p_v_reference26
p_v_reference26||':account', -- for bug 14259917 by anupgupt
p_v_reference1 --Added by nprashar for bug # 13824043
);
select organization_code into p_org_code from
org_organization_definitions where organization_id = p_organization_id;
select organization_code into p_org_code_to from
org_organization_definitions where organization_id = p_to_organization_id;
RAISE_APPLICATION_ERROR(-20120, 'Select a Register');
UPDATE JAI_CMN_RG_BALANCES
SET pla_balance = v_pla_bal,
rg23a_balance = v_rg23a_bal,
rg23c_balance = v_rg23c_bal
WHERE organization_id = p_organization_id
and location_id = p_location_id;
UPDATE JAI_CMN_RG_BALANCES
SET pla_balance = v_to_pla_bal,
rg23a_balance = v_to_rg23a_bal,
rg23c_balance = v_to_rg23c_bal
where organization_id = p_to_organization_id
and location_id = p_to_location_id;
INSERT INTO JAI_CMN_RG_23AC_II_TRXS(
REGISTER_ID, FIN_YEAR, SLNO, TRANSACTION_SOURCE_NUM, INVENTORY_ITEM_ID, ORGANIZATION_ID,
RECEIPT_REF, RECEIPT_DATE, RANGE_NO, DIVISION_NO, CR_BASIC_ED, CR_ADDITIONAL_ED, CR_OTHER_ED,
DR_BASIC_ED, DR_ADDITIONAL_ED, DR_OTHER_ED, EXCISE_INVOICE_NO, EXCISE_INVOICE_DATE,
REGISTER_TYPE, REMARKS, VENDOR_ID, VENDOR_SITE_ID, CUSTOMER_ID, CUSTOMER_SITE_ID,
LOCATION_ID, TRANSACTION_DATE, OPENING_BALANCE, CLOSING_BALANCE, CHARGE_ACCOUNT_ID,
REGISTER_ID_PART_I, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
LAST_UPDATE_LOGIN, POSTED_FLAG, MASTER_FLAG, REFERENCE_NUM,
other_tax_debit --Added by Sanjikum for cess for Bug #4136939
) VALUES (
JAI_CMN_RG_23AC_II_TRXS_S.nextval, v_fin_year, v_slno, v_src_transaction_id, -1, p_organization_id,
null, null, null, null, null, null, null,
p_amount, null, null, null, null,
v_register, v_remarks, null, null, null, null,
p_location_id, SYSDATE, v_opening_balance, v_closing_balance, null,
null, SYSDATE, v_user_id, SYSDATE, v_user_id, v_login_id, null, null,lv_reference_num,--rchandan for bug#4428980
p_cess_amount+ nvl(p_sh_cess_amount,0) --Added by Sanjikum for cess for Bug #4136939 --Added + nvl(p_sh_cess_amount,0) by JMEENA for bug#7260552
) RETURNING register_id INTO v_from_register_id;
jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Data inserted into JAI_CMN_RG_23AC_II_TRXS');
jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Calling procedure insert_rg_others for A and C');
insert_rg_others( p_organization_id => p_organization_id,
p_location_id => p_location_id,
p_register_type => v_register,
p_source_register => v_source_register,
p_excise_cess_amount => v_excise_cess_amount,
p_sh_exc_cess_amount => v_sh_excise_cess_amount,/*Bug 5989740 bduvarag*/
p_sh_cvd_cess_amount => v_sh_cvd_cess_amount, /*Bug 5989740 bduvarag*/
p_cvd_cess_amount => v_cvd_cess_amount,
p_transfer_from_to => 'FROM',
p_register_id => v_from_register_id,
p_fin_year => v_fin_year);
INSERT INTO JAI_CMN_RG_PLA_TRXS(
REGISTER_ID, FIN_YEAR, SLNO, TR6_CHALLAN_NO, TR6_CHALLAN_DATE, CR_BASIC_ED, CR_ADDITIONAL_ED,
CR_OTHER_ED, TRANSACTION_SOURCE_NUM, REF_DOCUMENT_ID, REF_DOCUMENT_DATE, DR_INVOICE_NO, DR_INVOICE_DATE,
DR_BASIC_ED, DR_ADDITIONAL_ED, DR_OTHER_ED, ORGANIZATION_ID, LOCATION_ID, BANK_BRANCH_ID,
ENTRY_DATE, INVENTORY_ITEM_ID, VENDOR_CUST_FLAG, VENDOR_ID, VENDOR_SITE_ID, RANGE_NO,
DIVISION_NO, EXCISE_INVOICE_NO, REMARKS, TRANSACTION_DATE, OPENING_BALANCE, CLOSING_BALANCE,
CHARGE_ACCOUNT_ID, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
LAST_UPDATE_LOGIN, POSTED_FLAG, MASTER_FLAG, BASIC_OPENING_BALANCE, BASIC_CLOSING_BALANCE,
ADDITIONAL_OPENING_BALANCE, ADDITIONAL_CLOSING_BALANCE, OTHER_OPENING_BALANCE, OTHER_CLOSING_BALANCE,
OTHER_TAX_DEBIT --Added by Sanjikum for cess for Bug #4136939
) VALUES (
JAI_CMN_RG_PLA_TRXS_S1.nextval, v_fin_year, v_slno, null, null, null, null,
--null, v_src_transaction_id, null, null, null, null,
null, p_transfer_id, null, null, null, null, -- for bug 14259917 by anupgupt
p_amount, null, null, p_organization_id, p_location_id, null,
SYSDATE, null, null, null, null, null,
null, null, v_remarks, trunc(SYSDATE), v_opening_balance, v_closing_balance,
null, SYSDATE, v_user_id, SYSDATE, v_user_id,
v_login_id, null, null, null, null,
null, null, null, null,
p_cess_amount + nvl(p_sh_cess_amount,0)/*Bug 5989740 bduvarag*/--Added by Sanjikum for cess for Bug #4136939
) RETURNING register_id INTO v_from_register_id;
jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Calling procedure insert_rg_others for PLA ');
insert_rg_others( p_organization_id => p_organization_id,
p_location_id => p_location_id,
p_register_type => 'PLA',
p_source_register => v_source_register,
p_excise_cess_amount => v_excise_cess_amount,
p_sh_exc_cess_amount => v_sh_excise_cess_amount,/*Bug 5989740 bduvarag*/
p_sh_cvd_cess_amount => v_sh_cvd_cess_amount, /*Bug 5989740 bduvarag*/
p_cvd_cess_amount => v_cvd_cess_amount,
p_transfer_from_to => 'FROM',
p_register_id => v_from_register_id,
p_fin_year => v_fin_year);
INSERT INTO JAI_CMN_RG_23AC_II_TRXS(
REGISTER_ID, FIN_YEAR, SLNO, TRANSACTION_SOURCE_NUM, INVENTORY_ITEM_ID, ORGANIZATION_ID,
RECEIPT_REF, RECEIPT_DATE, RANGE_NO, DIVISION_NO, CR_BASIC_ED, CR_ADDITIONAL_ED, CR_OTHER_ED,
DR_BASIC_ED, DR_ADDITIONAL_ED, DR_OTHER_ED, EXCISE_INVOICE_NO, EXCISE_INVOICE_DATE,
REGISTER_TYPE, REMARKS, VENDOR_ID, VENDOR_SITE_ID, CUSTOMER_ID, CUSTOMER_SITE_ID,
LOCATION_ID, TRANSACTION_DATE, OPENING_BALANCE, CLOSING_BALANCE, CHARGE_ACCOUNT_ID,
REGISTER_ID_PART_I, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
LAST_UPDATE_LOGIN, POSTED_FLAG, MASTER_FLAG, REFERENCE_NUM,
OTHER_TAX_CREDIT --Added by Sanjikum for cess for Bug #4136939
) VALUES (
JAI_CMN_RG_23AC_II_TRXS_S.nextval, v_to_fin_year, v_to_slno, v_to_transaction_id, -1, p_to_organization_id,
v_from_register_id, null, null, null, p_amount, null, null,
null, null, null, null, null,
v_register, v_remarks, null, null, null, null,
p_to_location_id, SYSDATE, v_to_opening_balance, v_to_closing_balance, null,
null, SYSDATE, v_user_id, SYSDATE, v_user_id, v_login_id, null, null, lv_reference_num,--rchandan for bug#4428980
p_cess_amount + nvl(p_sh_cess_amount,0)/*Bug 5989740 bduvarag*/--Added by Sanjikum for cess for Bug #4136939
) RETURNING register_id INTO v_to_register_id;
UPDATE JAI_CMN_RG_23AC_II_TRXS
SET RECEIPT_REF = v_to_register_id
WHERE register_id = v_from_register_id;
jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Calling procedure insert_rg_others for A and C');
insert_rg_others( p_organization_id => p_to_organization_id,
p_location_id => p_to_location_id,
p_register_type => v_register,
p_source_register => v_source_register,
p_excise_cess_amount => v_excise_cess_amount,
p_cvd_cess_amount => v_cvd_cess_amount,
p_sh_exc_cess_amount => v_sh_excise_cess_amount, /*Bug 5989740 bduvarag*/
p_sh_cvd_cess_amount => v_sh_cvd_cess_amount, /*Bug 5989740 bduvarag*/
p_transfer_from_to => 'TO',
p_register_id => v_to_register_id,
p_fin_year => v_fin_year);
INSERT INTO JAI_CMN_RG_PLA_TRXS(
REGISTER_ID, FIN_YEAR, SLNO, TR6_CHALLAN_NO, TR6_CHALLAN_DATE, CR_BASIC_ED, CR_ADDITIONAL_ED,
CR_OTHER_ED, TRANSACTION_SOURCE_NUM, REF_DOCUMENT_ID, REF_DOCUMENT_DATE, DR_INVOICE_NO, DR_INVOICE_DATE,
DR_BASIC_ED, DR_ADDITIONAL_ED, DR_OTHER_ED, ORGANIZATION_ID, LOCATION_ID, BANK_BRANCH_ID,
ENTRY_DATE, INVENTORY_ITEM_ID, VENDOR_CUST_FLAG, VENDOR_ID, VENDOR_SITE_ID, RANGE_NO,
DIVISION_NO, EXCISE_INVOICE_NO, REMARKS, TRANSACTION_DATE, OPENING_BALANCE, CLOSING_BALANCE,
CHARGE_ACCOUNT_ID, CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
LAST_UPDATE_LOGIN, POSTED_FLAG, MASTER_FLAG, BASIC_OPENING_BALANCE, BASIC_CLOSING_BALANCE,
ADDITIONAL_OPENING_BALANCE, ADDITIONAL_CLOSING_BALANCE, OTHER_OPENING_BALANCE, OTHER_CLOSING_BALANCE,
OTHER_TAX_CREDIT --Added by Sanjikum for cess for Bug #4136939
) VALUES (
JAI_CMN_RG_PLA_TRXS_S1.nextval, v_to_fin_year, v_to_slno, null, null, p_amount, null,
null, v_to_transaction_id, v_from_register_id, null, null, null,
null, null, null, p_to_organization_id, p_to_location_id, null,
SYSDATE, null, null, null, null, null,
null, null, v_remarks, trunc(SYSDATE), v_to_opening_balance, v_to_closing_balance,
null, SYSDATE, v_user_id, SYSDATE, v_user_id,
v_login_id, null, null, null, null,
null, null, null, null,
p_cess_amount + nvl(p_sh_cess_amount,0)/*Bug 5989740 bduvarag*/--Added by Sanjikum for cess for Bug #4136939
) RETURNING register_id INTO v_to_register_id;
UPDATE JAI_CMN_RG_PLA_TRXS
SET ref_document_id = v_to_register_id
WHERE register_id = v_from_register_id;
jai_cmn_utils_pkg.write_fnd_log_msg('rg_transfer','Calling procedure insert_rg_others for PLA ');
insert_rg_others( p_organization_id => p_to_organization_id,
p_location_id => p_to_location_id,
p_register_type => 'PLA',
p_source_register => v_source_register,
p_excise_cess_amount => v_excise_cess_amount,
p_cvd_cess_amount => v_cvd_cess_amount,
p_sh_exc_cess_amount => v_sh_excise_cess_amount, /*Bug 5989740 bduvarag*/
p_sh_cvd_cess_amount => v_sh_cvd_cess_amount, /*Bug 5989740 bduvarag*/
p_transfer_from_to => 'TO',
p_register_id => v_to_register_id,
p_fin_year => v_fin_year);