The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
vendor_changed_flag ,
vendor_id ,
vendor_site_id
FROM
JAI_RCV_CENVAT_CLAIMS
WHERE
transaction_id in
(
SELECT
transaction_id
FROM
rcv_transactions
WHERE
transaction_type = cp_transaction_type /* 'RECEIVE' --Ramananda for removal of SQL LITERALs */
START WITH
transaction_id = pr_new.receipt_ref
CONNECT BY PRIOR
parent_transaction_id = transaction_id
);
2. In the Begin Block, added the call to ja_in_rg_util.update_rg_slno
3. Added an If condition, similar to the Trigger when condition and moved all existing
Code in it
Future Dependencies For the release Of this Object:-
(Please add a row in the section below only if your bug introduces a dependency due to spec change/ A new call to a object/
A datamodel change )
----------------------------------------------------------------------------------------------------------------------------------------------------
Current Version Current Bug Dependent Files Version Author Date Remarks
Of File On Bug/Patchset Dependent On
ja_in_rg23_part_ii_bi_trg.sql
----------------------------------------------------------------------------------------------------------------------------------------------------
616.1 3025626 IN60104D1+3025626 1. ja_3025626_alter.sql 616.1 Aiyer 21/07/2003 Enhancement, Introduced data
2. JAI_RCV_CLAIM_MODVAT_V.sql 616.1 model changes in table JAI_RCV_CENVAT_CLAIMS,
3. ja_in_pla_bi_trg.sql 616.1 alterations in view JAI_RCV_CLAIM_MODVAT_V,
4. ja_in_rg23_part_i_bi_trg.sql 616.1 added 3 new fields in form JAINMVAT.fmb and
5. JAINMVAT.fmb 616.4 2 new triggers - ja_in_pla_bi_trg.sql and
6. JAF23A_1.rdf 616.1 ja_in_rg23_part_i_bi_trg.sql. All present in patch 3025626.
115.1 3964409 1. jai_cmn_utils_pkg.sql 115.0 Sanjikum 27/10/2004
2. ja_in_create_3964409_apps.sql 115.0
3. ja_in_create_3964409_ja.sql 115.0
4. ja_in_datafix_po_3964409.sql 115.0
5. ja_in_pla_bi_trg.sql 115.0
**********************************************************************************************************************************************************************/
--Start added by Sanjikum for Bug #3964409
/*additional CVD fields included in formula for bug 7637074*/
ln_txn_amt := NVL(pr_new.cr_basic_ed,0) + NVL(pr_new.cr_additional_ed,0) + NVL(pr_new.cr_other_ed,0) + NVL(pr_new.cr_additional_cvd,0)
- NVL(pr_new.dr_basic_ed,0) - NVL(pr_new.dr_additional_ed,0) - NVL(pr_new.dr_other_ed,0) - NVL(pr_new.dr_additional_cvd,0);
jai_cmn_utils_pkg.update_rg_slno(
pn_organization_id => pr_new.organization_id,
pn_location_id => pr_new.location_id,
pv_register_type => pr_new.register_type,
pn_fin_year => pr_new.fin_year,
pn_txn_amt => ln_txn_amt,
pn_slno => ln_slno,
pn_opening_balance => ln_opening_balance,
pn_closing_balance => ln_closing_balance
);