DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_TAX_DIST_PKG dependencies on JAI_CMN_RG_OTHERS

Line 3035: p_debit_amt IN JAI_CMN_RG_OTHERS.DEBIT%TYPE ,

3031: p_transaction_type IN VARCHAR2 ,
3032: p_transaction_source IN VARCHAR2 ,
3033: p_called_from IN VARCHAR2 ,
3034: p_simulate_flag IN VARCHAR2 ,
3035: p_debit_amt IN JAI_CMN_RG_OTHERS.DEBIT%TYPE ,
3036: p_credit_amt IN JAI_CMN_RG_OTHERS.CREDIT%TYPE ,
3037: p_sh_cess_debit_amt IN JAI_CMN_RG_OTHERS.DEBIT%TYPE,--Added by kunkumar for bug#6127194
3038: p_sh_cess_credit_amt IN JAI_CMN_RG_OTHERS.CREDIT%TYPE,--Added by kunkumar for bug#6127194
3039: p_inventory_item_id IN JAI_CMN_RG_23AC_II_TRXS.INVENTORY_ITEM_ID%TYPE ,

Line 3036: p_credit_amt IN JAI_CMN_RG_OTHERS.CREDIT%TYPE ,

3032: p_transaction_source IN VARCHAR2 ,
3033: p_called_from IN VARCHAR2 ,
3034: p_simulate_flag IN VARCHAR2 ,
3035: p_debit_amt IN JAI_CMN_RG_OTHERS.DEBIT%TYPE ,
3036: p_credit_amt IN JAI_CMN_RG_OTHERS.CREDIT%TYPE ,
3037: p_sh_cess_debit_amt IN JAI_CMN_RG_OTHERS.DEBIT%TYPE,--Added by kunkumar for bug#6127194
3038: p_sh_cess_credit_amt IN JAI_CMN_RG_OTHERS.CREDIT%TYPE,--Added by kunkumar for bug#6127194
3039: p_inventory_item_id IN JAI_CMN_RG_23AC_II_TRXS.INVENTORY_ITEM_ID%TYPE ,
3040: p_receipt_id IN JAI_CMN_RG_23AC_II_TRXS.RECEIPT_REF%TYPE Default NULL ,

Line 3037: p_sh_cess_debit_amt IN JAI_CMN_RG_OTHERS.DEBIT%TYPE,--Added by kunkumar for bug#6127194

3033: p_called_from IN VARCHAR2 ,
3034: p_simulate_flag IN VARCHAR2 ,
3035: p_debit_amt IN JAI_CMN_RG_OTHERS.DEBIT%TYPE ,
3036: p_credit_amt IN JAI_CMN_RG_OTHERS.CREDIT%TYPE ,
3037: p_sh_cess_debit_amt IN JAI_CMN_RG_OTHERS.DEBIT%TYPE,--Added by kunkumar for bug#6127194
3038: p_sh_cess_credit_amt IN JAI_CMN_RG_OTHERS.CREDIT%TYPE,--Added by kunkumar for bug#6127194
3039: p_inventory_item_id IN JAI_CMN_RG_23AC_II_TRXS.INVENTORY_ITEM_ID%TYPE ,
3040: p_receipt_id IN JAI_CMN_RG_23AC_II_TRXS.RECEIPT_REF%TYPE Default NULL ,
3041: p_receipt_date IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE Default NULL ,

Line 3038: p_sh_cess_credit_amt IN JAI_CMN_RG_OTHERS.CREDIT%TYPE,--Added by kunkumar for bug#6127194

3034: p_simulate_flag IN VARCHAR2 ,
3035: p_debit_amt IN JAI_CMN_RG_OTHERS.DEBIT%TYPE ,
3036: p_credit_amt IN JAI_CMN_RG_OTHERS.CREDIT%TYPE ,
3037: p_sh_cess_debit_amt IN JAI_CMN_RG_OTHERS.DEBIT%TYPE,--Added by kunkumar for bug#6127194
3038: p_sh_cess_credit_amt IN JAI_CMN_RG_OTHERS.CREDIT%TYPE,--Added by kunkumar for bug#6127194
3039: p_inventory_item_id IN JAI_CMN_RG_23AC_II_TRXS.INVENTORY_ITEM_ID%TYPE ,
3040: p_receipt_id IN JAI_CMN_RG_23AC_II_TRXS.RECEIPT_REF%TYPE Default NULL ,
3041: p_receipt_date IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE Default NULL ,
3042: p_excise_invoice_date IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE Default NULL ,

Line 3063: ln_source_type JAI_CMN_RG_OTHERS.SOURCE_TYPE%TYPE ;

3059: --Added by kunkumar for bug#6127194, Start
3060: ln_register_id NUMBER ;
3061: ln_transfer_Dest_id NUMBER ;
3062: ln_cess_amount NUMBER ;
3063: ln_source_type JAI_CMN_RG_OTHERS.SOURCE_TYPE%TYPE ;
3064: lv_source_register JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE ;
3065: lv_register_type VARCHAR2(10);
3066: --End, Added by kunkumar
3067:

Line 3064: lv_source_register JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE ;

3060: ln_register_id NUMBER ;
3061: ln_transfer_Dest_id NUMBER ;
3062: ln_cess_amount NUMBER ;
3063: ln_source_type JAI_CMN_RG_OTHERS.SOURCE_TYPE%TYPE ;
3064: lv_source_register JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE ;
3065: lv_register_type VARCHAR2(10);
3066: --End, Added by kunkumar
3067:
3068: BEGIN

Line 3184: jai_cmn_rg_others_pkg.insert_row( p_source_type => ln_source_type ,

3180: IF nvl(p_credit_amt,0) <> 0 OR
3181: nvl(p_debit_amt,0) <> 0
3182: THEN
3183:
3184: jai_cmn_rg_others_pkg.insert_row( p_source_type => ln_source_type ,
3185: p_source_name => lv_source_register ,
3186: p_source_id => ln_register_id ,
3187: p_tax_type => 'EXCISE_EDUCATION_CESS' ,
3188: debit_amt => p_debit_amt ,

Line 3205: jai_cmn_rg_others_pkg.insert_row( p_source_type => ln_source_type ,

3201: IF nvl(p_sh_cess_debit_amt,0) <> 0 OR
3202: nvl(p_sh_cess_credit_amt,0) <> 0
3203: THEN
3204:
3205: jai_cmn_rg_others_pkg.insert_row( p_source_type => ln_source_type ,
3206: p_source_name => lv_source_register ,
3207: p_source_id => ln_register_id ,
3208: p_tax_type => 'EXCISE_SH_EDU_CESS' ,
3209: debit_amt => p_sh_cess_debit_amt ,