eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_RCV_EXCISE_PROCESSING_PKG dependencies on JAI_CMN_RG_OTHERS

Line 808: UPDATE JAI_CMN_RG_OTHERS

804:
805: ln_ex_cess_diff := nvl(ln_other_tax_credit,0) -
806: nvl(ln_other_tax_debit,0);
807:
808: UPDATE JAI_CMN_RG_OTHERS
809: SET credit = credit + ln_other_tax_credit,
810: debit = debit + ln_other_tax_debit,
811: opening_balance = opening_balance,
812: closing_balance = closing_balance + ln_ex_cess_diff

Line 836: UPDATE JAI_CMN_RG_OTHERS

832:
833: ln_cvd_cess_diff := nvl(ln_other_tax_credit,0) -
834: nvl(ln_other_tax_debit,0);
835:
836: UPDATE JAI_CMN_RG_OTHERS
837: SET credit = credit + ln_other_tax_credit,
838: debit = debit + ln_other_tax_debit,
839: opening_balance = opening_balance,
840: closing_balance = closing_balance + ln_cvd_cess_diff

Line 863: UPDATE JAI_CMN_RG_OTHERS

859:
860: ln_ex_sh_cess_diff := nvl(ln_other_tax_credit,0) -
861: nvl(ln_other_tax_debit,0);
862:
863: UPDATE JAI_CMN_RG_OTHERS
864: SET credit = credit + ln_other_tax_credit,
865: debit = debit + ln_other_tax_debit,
866: opening_balance = opening_balance,
867: closing_balance = closing_balance + ln_ex_sh_cess_diff

Line 890: UPDATE JAI_CMN_RG_OTHERS

886:
887: ln_cvd_sh_cess_diff := nvl(ln_other_tax_credit,0) -
888: nvl(ln_other_tax_debit,0);
889:
890: UPDATE JAI_CMN_RG_OTHERS
891: SET credit = credit + ln_other_tax_credit,
892: debit = debit + ln_other_tax_debit,
893: opening_balance = opening_balance,
894: closing_balance = closing_balance + ln_cvd_sh_cess_diff

Line 1158: - other_cenvat_rg_recording : Inserts a record into JAI_CMN_RG_OTHERS table with the parameters passed to the call

1154: that passes cenvat accounting and register entries. this change is made from an extensible perspective of breakup
1155: - added the following procedures
1156: - get_vendor_changed_dtls : Retuns the changed excise vendor details as OUT Parameters
1157: - post_cenvat_processor : Updates JAI_RCV_CENVAT_CLAIMS, JAI_RCV_LINES tables with claim details
1158: - other_cenvat_rg_recording : Inserts a record into JAI_CMN_RG_OTHERS table with the parameters passed to the call
1159: - added the parameters p_process_special_reason and qty in PROCESS_TRANSACTION. These are used incase the accounting
1160: and rg entries should consider these values for TAX_BREAUP instead of main transaction values.
1161: These parameters are mainly added for RECEIPTS DEPLUG to support second Claim functionality of CGIN items
1162: - COMMENTED the code related to AUTO Claim of 2nd 50% of RECEIVE transaction to the tune of RETURN TO VENDOR

Line 2949: lv_source_register JAI_CMN_RG_OTHERS.source_register%TYPE;

2945: lv_statement_id VARCHAR2(5);
2946: ln_other_tax_credit NUMBER;
2947: ln_other_tax_debit NUMBER;
2948: lv_register_type JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE;
2949: lv_source_register JAI_CMN_RG_OTHERS.source_register%TYPE;
2950:
2951: --start additions for bug#9854329
2952: lv_cr_rvrsl_flag jai_cmn_inventory_orgs.CENVAT_CR_REVRSL_FLAG%TYPE;
2953: cursor get_rev_flag(cp_organization_id in number,cp_location_id in number)

Line 5580: INSERT INTO JAI_CMN_RG_OTHERS(

5576: ELSIF p_source_register = jai_constants.reg_receipt_cenvat THEN
5577: ln_source_type := jai_constants.reg_receipt_cenvat_code;
5578: END IF;
5579:
5580: INSERT INTO JAI_CMN_RG_OTHERS(
5581: rg_other_id, source_type, source_register,
5582: source_register_id, tax_type, credit, debit,
5583: created_by, creation_date, last_updated_by, last_update_date
5584: ) VALUES (

Line 5585: JAI_CMN_RG_OTHERS_S.nextval, ln_source_type, p_source_register,

5581: rg_other_id, source_type, source_register,
5582: source_register_id, tax_type, credit, debit,
5583: created_by, creation_date, last_updated_by, last_update_date
5584: ) VALUES (
5585: JAI_CMN_RG_OTHERS_S.nextval, ln_source_type, p_source_register,
5586: p_source_register_id, p_tax_type, p_credit, p_debit,
5587: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate
5588: );
5589: EXCEPTION

Line 5927: jai_cmn_rg_others_pkg.check_balances(

5923: ELSE
5924: ln_trx_amount := nvl(pr_tax.excise_edu_cess,0) + nvl(pr_tax.cvd_edu_cess,0);
5925: END IF;
5926: --added for bug#9854329, end
5927: jai_cmn_rg_others_pkg.check_balances(
5928: p_organization_id => p_organization_id ,
5929: p_location_id => p_location_id,
5930: p_register_type => lv_cess_pref1_register,
5931: -- p_trx_amount => pr_tax.excise_edu_cess + pr_tax.cvd_edu_cess,

Line 5960: jai_cmn_rg_others_pkg.check_sh_balances(

5956: ELSE
5957: ln_trx_amount := nvl(pr_tax.sh_exc_edu_cess,0) + nvl(pr_tax.sh_cvd_edu_cess,0);
5958: END IF;
5959: --added for bug#9854329, end
5960: jai_cmn_rg_others_pkg.check_sh_balances(
5961: p_organization_id => p_organization_id ,
5962: p_location_id => p_location_id,
5963: p_register_type => lv_cess_pref1_register,
5964: -- p_trx_amount => nvl(pr_tax.sh_exc_edu_cess,0) + nvl(pr_tax.sh_cvd_edu_cess,0),

Line 6048: jai_cmn_rg_others_pkg.check_balances(

6044: ELSE
6045: ln_trx_amount := nvl(pr_tax.excise_edu_cess,0) + nvl(pr_tax.cvd_edu_cess,0);
6046: END IF;
6047: --added for bug#9854329, end
6048: jai_cmn_rg_others_pkg.check_balances(
6049: p_organization_id => p_organization_id ,
6050: p_location_id => p_location_id,
6051: p_register_type => lv_cess_pref2_register,
6052: -- p_trx_amount => pr_tax.excise_edu_cess + pr_tax.cvd_edu_cess,

Line 6084: jai_cmn_rg_others_pkg.check_sh_balances(

6080: ELSE
6081: ln_trx_amount := nvl(pr_tax.sh_exc_edu_cess,0) + nvl(pr_tax.sh_cvd_edu_cess,0);
6082: END IF;
6083: --added for bug#9854329, end
6084: jai_cmn_rg_others_pkg.check_sh_balances(
6085: p_organization_id => p_organization_id ,
6086: p_location_id => p_location_id,
6087: p_register_type => lv_cess_pref2_register,
6088: -- p_trx_amount => nvl(pr_tax.sh_exc_edu_cess,0) + nvl(pr_tax.sh_cvd_edu_cess,0),