APPS.JAI_MTL_TRXS_PKG dependencies on JAI_CMN_RG_OTHERS_PKG

Line 778: stmt_name := 'Calling jai_cmn_rg_others_pkg.insert_row for Cess of RG23D';

774: -- rchandan for bug#6487364 start
775:
776: IF NVL(ln_cess_amount,0) <> 0 then
777:
778: stmt_name := 'Calling jai_cmn_rg_others_pkg.insert_row for Cess of RG23D';
779:
780: jai_cmn_rg_others_pkg.insert_row(p_source_type => 3,
781: p_source_name => 'RG23D',
782: p_source_id => l_register_id,

Line 780: jai_cmn_rg_others_pkg.insert_row(p_source_type => 3,

776: IF NVL(ln_cess_amount,0) <> 0 then
777:
778: stmt_name := 'Calling jai_cmn_rg_others_pkg.insert_row for Cess of RG23D';
779:
780: jai_cmn_rg_others_pkg.insert_row(p_source_type => 3,
781: p_source_name => 'RG23D',
782: p_source_id => l_register_id,
783: p_tax_type => jai_constants.tax_type_exc_edu_cess,
784: debit_amt => NULL,

Line 796: stmt_name := 'Calling jai_cmn_rg_others_pkg.insert_row for SH Cess of RG23D';

792:
793: END IF;
794: IF NVL(ln_other_sh_cess,0) <> 0 then
795:
796: stmt_name := 'Calling jai_cmn_rg_others_pkg.insert_row for SH Cess of RG23D';
797:
798: jai_cmn_rg_others_pkg.insert_row(p_source_type => 3,
799: p_source_name => 'RG23D',
800: p_source_id => l_register_id,

Line 798: jai_cmn_rg_others_pkg.insert_row(p_source_type => 3,

794: IF NVL(ln_other_sh_cess,0) <> 0 then
795:
796: stmt_name := 'Calling jai_cmn_rg_others_pkg.insert_row for SH Cess of RG23D';
797:
798: jai_cmn_rg_others_pkg.insert_row(p_source_type => 3,
799: p_source_name => 'RG23D',
800: p_source_id => l_register_id,
801: p_tax_type => jai_constants.tax_type_sh_exc_edu_cess,
802: debit_amt => NULL,

Line 878: stmt_name := 'Calling jai_cmn_rg_others_pkg.insert_row';

874: SELECT JAI_CMN_RG_23AC_I_TRXSI_S.CURRVAL INTO v_register_id FROM dual;
875: END;
876: *//*commented the above by vkaranam for bug #5907436*/
877: BEGIN
878: stmt_name := 'Calling jai_cmn_rg_others_pkg.insert_row';
879: if l_register_type='A' THEN
880: lv_source_name:='RG23A_P2';
881: elsif l_register_type='C' THEN
882: lv_source_name:='RG23C_P2';

Line 884: jai_cmn_rg_others_pkg.insert_row(

880: lv_source_name:='RG23A_P2';
881: elsif l_register_type='C' THEN
882: lv_source_name:='RG23C_P2';
883: end if;
884: jai_cmn_rg_others_pkg.insert_row(
885: P_SOURCE_TYPE => 1 ,
886: P_SOURCE_NAME => lv_source_name ,
887: P_SOURCE_ID => l_register_id_ii ,
888: P_TAX_TYPE => 'EXCISE_EDUCATION_CESS' ,

Line 901: stmt_name := 'Calling jai_cmn_rg_others_pkg.insert_row';

897: /*added the following for shcess by vkaranam for bug #5907436*/
898: --start 5907436
899: IF nvl(ln_other_sh_cess,0)<>0 THEN
900: BEGIN
901: stmt_name := 'Calling jai_cmn_rg_others_pkg.insert_row';
902: if l_register_type='A' THEN
903: lv_source_name:='RG23A_P2';
904: elsif l_register_type='C' THEN
905: lv_source_name:='RG23C_P2';

Line 907: jai_cmn_rg_others_pkg.insert_row(

903: lv_source_name:='RG23A_P2';
904: elsif l_register_type='C' THEN
905: lv_source_name:='RG23C_P2';
906: end if;
907: jai_cmn_rg_others_pkg.insert_row(
908: P_SOURCE_TYPE => 1 ,
909: P_SOURCE_NAME => lv_source_name ,
910: P_SOURCE_ID => l_register_id_ii ,
911: P_TAX_TYPE => jai_constants.tax_type_sh_exc_edu_cess ,

Line 4152: jai_cmn_rg_others_pkg.insert_row

4148:
4149:
4150: IF ln_cvd_cess_amt IS NOT NULL THEN
4151:
4152: jai_cmn_rg_others_pkg.insert_row
4153: (
4154: P_SOURCE_TYPE => 1,
4155: P_SOURCE_NAME => 'RG23C_P2',
4156: P_SOURCE_ID => ln_register_id,

Line 4167: jai_cmn_rg_others_pkg.insert_row

4163:
4164: END IF;
4165:
4166: IF ln_excise_cess_amt IS NOT NULL THEN
4167: jai_cmn_rg_others_pkg.insert_row
4168: (
4169: P_SOURCE_TYPE => 1,
4170: P_SOURCE_NAME => 'RG23C_P2',
4171: P_SOURCE_ID => ln_register_id,

Line 4182: jai_cmn_rg_others_pkg.insert_row

4178: END IF;
4179: --start additions for bug#10607819
4180: IF ln_cvd_sh_cess_amt IS NOT NULL THEN
4181:
4182: jai_cmn_rg_others_pkg.insert_row
4183: (
4184: P_SOURCE_TYPE => 1,
4185: P_SOURCE_NAME => 'RG23C_P2',
4186: P_SOURCE_ID => ln_register_id,

Line 4197: jai_cmn_rg_others_pkg.insert_row

4193:
4194: END IF;
4195:
4196: IF ln_excise_sh_cess_amt IS NOT NULL THEN
4197: jai_cmn_rg_others_pkg.insert_row
4198: (
4199: P_SOURCE_TYPE => 1,
4200: P_SOURCE_NAME => 'RG23C_P2',
4201: P_SOURCE_ID => ln_register_id,