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.ref_document_id
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
2. 08-Jun-2005 This Object is Modified to refer to New DB Entity names in place of Old
DB Entity as required for CASE COMPLAINCE. Version 116.1
3 . 13-Jun-2005 File Version: 116.3
Ramananda for bug#4428980. Removal of SQL LITERALs is done
4. 3-Mar-2007 bduvarag for bug#5141459,File version 120.2
Forward porting the changes done in 11i bug#4548378
5. 9-jul-2007 vkaranam for bug#5894216,File Version 120.3
Forward porting the changes done in 11i bug#5854331
(In Pla Duty Book Report, Education Cess Opening Balance Is Showing Wrongly)
6. 10-OCT-2010 vkaranam for bug#10188937
Issue:
wrong PLA slno for TR6 entry
Fix:
added OR pr_new.transaction_source_num=91 for bug#10188937 ,such that the trigger will not fire for
TR6 entry.
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_pla_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_rg23_part_i_bi_trg.sql 616.1 alterations in view JAI_RCV_CLAIM_MODVAT_V,
4. ja_in_rg23_part_ii_bi_trg.sql 616.1 added 3 new fields in form JAINMVAT.fmb and
5. JAINMVAT.fmb 616.4 2 new triggers - ja_in_rg23_part_i_bi_trg and
6. JAF23A_1.rdf 616.1 ja_in_rg23_part_ii_bi_trg. 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
**********************************************************************************************************************************************************************/
--Start added by Sanjikum for Bug #3964409
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.dr_basic_ed,0) - NVL(pr_new.dr_additional_ed,0) - NVL(pr_new.dr_other_ed,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 => 'PLA',
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
);