DBA Data[Home] [Help]

APPS.JAI_JRG_23AC2_TRIGGER_PKG dependencies on JAI_CMN_UTILS_PKG

Line 131: 115.1 3964409 1. jai_cmn_utils_pkg.sql 115.0 Sanjikum 27/10/2004

127: 4. ja_in_rg23_part_i_bi_trg.sql 616.1 added 3 new fields in form JAINMVAT.fmb and
128: 5. JAINMVAT.fmb 616.4 2 new triggers - ja_in_pla_bi_trg.sql and
129: 6. JAF23A_1.rdf 616.1 ja_in_rg23_part_i_bi_trg.sql. All present in patch 3025626.
130:
131: 115.1 3964409 1. jai_cmn_utils_pkg.sql 115.0 Sanjikum 27/10/2004
132: 2. ja_in_create_3964409_apps.sql 115.0
133: 3. ja_in_create_3964409_ja.sql 115.0
134: 4. ja_in_datafix_po_3964409.sql 115.0
135: 5. ja_in_pla_bi_trg.sql 115.0

Line 144: jai_cmn_utils_pkg.update_rg_slno(

140: 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)
141: - 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);
142:
143: IF pr_new.transaction_source_num IS NOT NULL THEN /*Bug 5141459 bduvarag*/
144: jai_cmn_utils_pkg.update_rg_slno(
145: pn_organization_id => pr_new.organization_id,
146: pn_location_id => pr_new.location_id,
147: pv_register_type => pr_new.register_type,
148: pn_fin_year => pr_new.fin_year,