DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_TAX_DIST_PKG dependencies on JAI_CMN_RG_OTHERS

Line 2062: p_debit_amt IN JAI_CMN_RG_OTHERS.DEBIT%TYPE ,

2058: p_transaction_type IN VARCHAR2 ,
2059: p_transaction_source IN VARCHAR2 ,
2060: p_called_from IN VARCHAR2 ,
2061: p_simulate_flag IN VARCHAR2 ,
2062: p_debit_amt IN JAI_CMN_RG_OTHERS.DEBIT%TYPE ,
2063: p_credit_amt IN JAI_CMN_RG_OTHERS.CREDIT%TYPE ,
2064: p_sh_cess_debit_amt IN JAI_CMN_RG_OTHERS.DEBIT%TYPE,--Added by kunkumar for bug#6127194
2065: p_sh_cess_credit_amt IN JAI_CMN_RG_OTHERS.CREDIT%TYPE,--Added by kunkumar for bug#6127194
2066: p_inventory_item_id IN JAI_CMN_RG_23AC_II_TRXS.INVENTORY_ITEM_ID%TYPE ,

Line 2063: p_credit_amt IN JAI_CMN_RG_OTHERS.CREDIT%TYPE ,

2059: p_transaction_source IN VARCHAR2 ,
2060: p_called_from IN VARCHAR2 ,
2061: p_simulate_flag IN VARCHAR2 ,
2062: p_debit_amt IN JAI_CMN_RG_OTHERS.DEBIT%TYPE ,
2063: p_credit_amt IN JAI_CMN_RG_OTHERS.CREDIT%TYPE ,
2064: p_sh_cess_debit_amt IN JAI_CMN_RG_OTHERS.DEBIT%TYPE,--Added by kunkumar for bug#6127194
2065: p_sh_cess_credit_amt IN JAI_CMN_RG_OTHERS.CREDIT%TYPE,--Added by kunkumar for bug#6127194
2066: p_inventory_item_id IN JAI_CMN_RG_23AC_II_TRXS.INVENTORY_ITEM_ID%TYPE ,
2067: p_receipt_id IN JAI_CMN_RG_23AC_II_TRXS.RECEIPT_REF%TYPE Default NULL ,

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

2060: p_called_from IN VARCHAR2 ,
2061: p_simulate_flag IN VARCHAR2 ,
2062: p_debit_amt IN JAI_CMN_RG_OTHERS.DEBIT%TYPE ,
2063: p_credit_amt IN JAI_CMN_RG_OTHERS.CREDIT%TYPE ,
2064: p_sh_cess_debit_amt IN JAI_CMN_RG_OTHERS.DEBIT%TYPE,--Added by kunkumar for bug#6127194
2065: p_sh_cess_credit_amt IN JAI_CMN_RG_OTHERS.CREDIT%TYPE,--Added by kunkumar for bug#6127194
2066: p_inventory_item_id IN JAI_CMN_RG_23AC_II_TRXS.INVENTORY_ITEM_ID%TYPE ,
2067: p_receipt_id IN JAI_CMN_RG_23AC_II_TRXS.RECEIPT_REF%TYPE Default NULL ,
2068: p_receipt_date IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE Default NULL ,

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

2061: p_simulate_flag IN VARCHAR2 ,
2062: p_debit_amt IN JAI_CMN_RG_OTHERS.DEBIT%TYPE ,
2063: p_credit_amt IN JAI_CMN_RG_OTHERS.CREDIT%TYPE ,
2064: p_sh_cess_debit_amt IN JAI_CMN_RG_OTHERS.DEBIT%TYPE,--Added by kunkumar for bug#6127194
2065: p_sh_cess_credit_amt IN JAI_CMN_RG_OTHERS.CREDIT%TYPE,--Added by kunkumar for bug#6127194
2066: p_inventory_item_id IN JAI_CMN_RG_23AC_II_TRXS.INVENTORY_ITEM_ID%TYPE ,
2067: p_receipt_id IN JAI_CMN_RG_23AC_II_TRXS.RECEIPT_REF%TYPE Default NULL ,
2068: p_receipt_date IN JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE Default NULL ,
2069: p_excise_invoice_date IN JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE Default NULL ,

Line 2090: ln_source_type JAI_CMN_RG_OTHERS.SOURCE_TYPE%TYPE ;

2086: --Added by kunkumar for bug#6127194, Start
2087: ln_register_id NUMBER ;
2088: ln_transfer_Dest_id NUMBER ;
2089: ln_cess_amount NUMBER ;
2090: ln_source_type JAI_CMN_RG_OTHERS.SOURCE_TYPE%TYPE ;
2091: lv_source_register JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE ;
2092: --End, Added by kunkumar
2093: BEGIN
2094: --Added the body of the procedure by kunkumar for bug#6127194

Line 2091: lv_source_register JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE ;

2087: ln_register_id NUMBER ;
2088: ln_transfer_Dest_id NUMBER ;
2089: ln_cess_amount NUMBER ;
2090: ln_source_type JAI_CMN_RG_OTHERS.SOURCE_TYPE%TYPE ;
2091: lv_source_register JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE ;
2092: --End, Added by kunkumar
2093: BEGIN
2094: --Added the body of the procedure by kunkumar for bug#6127194
2095: /*

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

2190: IF nvl(p_credit_amt,0) <> 0 OR
2191: nvl(p_debit_amt,0) <> 0
2192: THEN
2193:
2194: jai_cmn_rg_others_pkg.insert_row( p_source_type => ln_source_type ,
2195: p_source_name => lv_source_register ,
2196: p_source_id => ln_register_id ,
2197: p_tax_type => 'EXCISE_EDUCATION_CESS' ,
2198: debit_amt => p_debit_amt ,

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

2211: IF nvl(p_sh_cess_debit_amt,0) <> 0 OR
2212: nvl(p_sh_cess_credit_amt,0) <> 0
2213: THEN
2214:
2215: jai_cmn_rg_others_pkg.insert_row( p_source_type => ln_source_type ,
2216: p_source_name => lv_source_register ,
2217: p_source_id => ln_register_id ,
2218: p_tax_type => 'EXCISE_SH_EDU_CESS' ,
2219: debit_amt => p_sh_cess_debit_amt ,