APPS.JAI_MTL_TRXS_PKG dependencies on JAI_CMN_RG_OTHERS_PKG

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

651: -- rchandan for bug#6487364 start
652:
653: IF NVL(ln_cess_amount,0) <> 0 then
654:
655: stmt_name := 'Calling jai_cmn_rg_others_pkg.insert_row for Cess of RG23D';
656:
657: jai_cmn_rg_others_pkg.insert_row(p_source_type => 3,
658: p_source_name => 'RG23D',
659: p_source_id => l_register_id,

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

653: IF NVL(ln_cess_amount,0) <> 0 then
654:
655: stmt_name := 'Calling jai_cmn_rg_others_pkg.insert_row for Cess of RG23D';
656:
657: jai_cmn_rg_others_pkg.insert_row(p_source_type => 3,
658: p_source_name => 'RG23D',
659: p_source_id => l_register_id,
660: p_tax_type => jai_constants.tax_type_exc_edu_cess,
661: debit_amt => NULL,

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

669:
670: END IF;
671: IF NVL(ln_other_sh_cess,0) <> 0 then
672:
673: stmt_name := 'Calling jai_cmn_rg_others_pkg.insert_row for SH Cess of RG23D';
674:
675: jai_cmn_rg_others_pkg.insert_row(p_source_type => 3,
676: p_source_name => 'RG23D',
677: p_source_id => l_register_id,

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

671: IF NVL(ln_other_sh_cess,0) <> 0 then
672:
673: stmt_name := 'Calling jai_cmn_rg_others_pkg.insert_row for SH Cess of RG23D';
674:
675: jai_cmn_rg_others_pkg.insert_row(p_source_type => 3,
676: p_source_name => 'RG23D',
677: p_source_id => l_register_id,
678: p_tax_type => jai_constants.tax_type_sh_exc_edu_cess,
679: debit_amt => NULL,

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

751: SELECT JAI_CMN_RG_23AC_I_TRXSI_S.CURRVAL INTO v_register_id FROM dual;
752: END;
753: *//*commented the above by vkaranam for bug #5907436*/
754: BEGIN
755: stmt_name := 'Calling jai_cmn_rg_others_pkg.insert_row';
756: if l_register_type='A' THEN
757: lv_source_name:='RG23A_P2';
758: elsif l_register_type='C' THEN
759: lv_source_name:='RG23C_P2';

Line 761: jai_cmn_rg_others_pkg.insert_row(

757: lv_source_name:='RG23A_P2';
758: elsif l_register_type='C' THEN
759: lv_source_name:='RG23C_P2';
760: end if;
761: jai_cmn_rg_others_pkg.insert_row(
762: P_SOURCE_TYPE => 1 ,
763: P_SOURCE_NAME => lv_source_name ,
764: P_SOURCE_ID => l_register_id_ii ,
765: P_TAX_TYPE => 'EXCISE_EDUCATION_CESS' ,

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

774: /*added the following for shcess by vkaranam for bug #5907436*/
775: --start 5907436
776: IF nvl(ln_other_sh_cess,0)<>0 THEN
777: BEGIN
778: stmt_name := 'Calling jai_cmn_rg_others_pkg.insert_row';
779: if l_register_type='A' THEN
780: lv_source_name:='RG23A_P2';
781: elsif l_register_type='C' THEN
782: lv_source_name:='RG23C_P2';

Line 784: jai_cmn_rg_others_pkg.insert_row(

780: lv_source_name:='RG23A_P2';
781: elsif l_register_type='C' THEN
782: lv_source_name:='RG23C_P2';
783: end if;
784: jai_cmn_rg_others_pkg.insert_row(
785: P_SOURCE_TYPE => 1 ,
786: P_SOURCE_NAME => lv_source_name ,
787: P_SOURCE_ID => l_register_id_ii ,
788: P_TAX_TYPE => jai_constants.tax_type_sh_exc_edu_cess ,

Line 3975: jai_cmn_rg_others_pkg.insert_row

3971:
3972:
3973: IF ln_cvd_cess_amt IS NOT NULL THEN
3974:
3975: jai_cmn_rg_others_pkg.insert_row
3976: (
3977: P_SOURCE_TYPE => 1,
3978: P_SOURCE_NAME => 'RG23C_P2',
3979: P_SOURCE_ID => ln_register_id,

Line 3990: jai_cmn_rg_others_pkg.insert_row

3986:
3987: END IF;
3988:
3989: IF ln_excise_cess_amt IS NOT NULL THEN
3990: jai_cmn_rg_others_pkg.insert_row
3991: (
3992: P_SOURCE_TYPE => 1,
3993: P_SOURCE_NAME => 'RG23C_P2',
3994: P_SOURCE_ID => ln_register_id,