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_23AC_II_TRXS

Line 457: lv_register_type JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE;

453: lv_remarks JAI_CMN_RG_PLA_TRXS.REMARKS%TYPE;
454: lv_statement_id VARCHAR2(5);
455: lv_process_status VARCHAR2(2);
456: lv_process_message VARCHAR2(2000);
457: lv_register_type JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE;
458: ln_reg_dr NUMBER ;
459: ln_reg_cr NUMBER ;
460: lv_upd_opening_bal_dr NUMBER ;
461: lv_upd_opening_bal_cr NUMBER ;

Line 666: FROM JAI_CMN_RG_23AC_II_TRXS

662: dr_other_ed,
663: other_tax_credit,
664: other_tax_debit,
665: remarks
666: FROM JAI_CMN_RG_23AC_II_TRXS
667: WHERE organization_id = pr_tax.organization_id
668: AND location_id = pr_tax.location_id
669: AND inventory_item_id = pr_tax.inventory_item_id
670: AND receipt_ref = pr_tax.transaction_id

Line 1023: lv_reference_num JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE;

1019: lv_cenvat_accounting_type VARCHAR2(10);
1020: lv_register_entry_type VARCHAR2(10);
1021: lv_cgin_code VARCHAR2(100);
1022:
1023: lv_reference_num JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE;
1024:
1025: -- amount related variables
1026: ln_curr_conv_rate NUMBER;
1027: ln_excise_amount NUMBER;

Line 1195: During Cenvat Claim, while Inserting the Record into JAI_CMN_RG_23AC_II_TRXS, the Transaction date is inserted as Transaction Date of

1191: 6. 15/04/2005 Sanjikum for Bug #4293421, File Version 116.0(115.7)
1192:
1193: Problem
1194: -------
1195: During Cenvat Claim, while Inserting the Record into JAI_CMN_RG_23AC_II_TRXS, the Transaction date is inserted as Transaction Date of
1196: the JAI_RCV_TRANSACTIONS.transaction_date. It should be the date on which claim is being made.
1197:
1198: Fix
1199: ---

Line 1241: For Receiving Transactions: In case of CGIN Claim a value needs to be passed for JAI_CMN_RG_23AC_II_TRXS.REFERENCE_NUM column

1237: IN60105D2 + 3496408
1238: IN60106 + 3940588 + 4146708/4239736 + 4103161 + 4346453
1239:
1240: /* IMPORTANT NOTE:
1241: For Receiving Transactions: In case of CGIN Claim a value needs to be passed for JAI_CMN_RG_23AC_II_TRXS.REFERENCE_NUM column
1242: that will be used for Duplicate Checking.
1243: Incase of RECEIVE transaction value passed for 1st 50% Claim is '1st Claim'. During 2nd 50% Claim '2nd Claim' is passed
1244: If 2nd Claim is happening from RTV transaction then TRANSACTION_ID of RECEIVE is passed as the value towards REFERENCE_NUM
1245: In all Other transactions value passed for REFERENCE_NUM column is NULL

Line 1735: -- 2nd Claim onwards. -- Helpful to identify the duplicate entry in JAI_CMN_RG_23AC_II_TRXS. if the line is 100% Claimed, then we should not pass another entry

1731: IF lv_transaction_type = 'RECEIVE' AND lv_cgin_code IS NOT NULL THEN
1732: -- 1st Claim
1733: IF nvl(p_cenvat_claimed_ptg, 0) = 0 THEN
1734: lv_reference_num := CGIN_FIRST_CLAIM;
1735: -- 2nd Claim onwards. -- Helpful to identify the duplicate entry in JAI_CMN_RG_23AC_II_TRXS. if the line is 100% Claimed, then we should not pass another entry
1736: ELSE -- IF p_cenvat_claimed_ptg = 50 THEN
1737: lv_reference_num := CGIN_SECOND_CLAIM;
1738: END IF;
1739: ELSE

Line 2923: ln_register_id JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE;

2919: r_rtv_trx c_trx%ROWTYPE;/*vkaranam for bug#4767479*/
2920: ln_reference_num NUMBER ;/*vkaranam for bug#4767479*/
2921: lv_exc_flag VARCHAR2 (1);/*vkaranam for bug#4767479*/
2922:
2923: ln_register_id JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE;
2924: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2925: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2926: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2927: lv_excise_invoice_no JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE;

Line 2927: lv_excise_invoice_no JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE;

2923: ln_register_id JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE;
2924: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2925: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2926: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2927: lv_excise_invoice_no JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE;
2928: ld_excise_invoice_date JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE;
2929: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2930: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
2931: r_parent_base_trx c_base_trx%ROWTYPE;

Line 2928: ld_excise_invoice_date JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE;

2924: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2925: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2926: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2927: lv_excise_invoice_no JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE;
2928: ld_excise_invoice_date JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE;
2929: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2930: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
2931: r_parent_base_trx c_base_trx%ROWTYPE;
2932:

Line 2933: ln_cr_basic JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE;

2929: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2930: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
2931: r_parent_base_trx c_base_trx%ROWTYPE;
2932:
2933: ln_cr_basic JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE;
2934: ln_cr_addl JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE;
2935: ln_cr_other JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE;
2936: ln_dr_basic JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE;
2937: ln_dr_addl JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE;

Line 2934: ln_cr_addl JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE;

2930: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
2931: r_parent_base_trx c_base_trx%ROWTYPE;
2932:
2933: ln_cr_basic JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE;
2934: ln_cr_addl JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE;
2935: ln_cr_other JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE;
2936: ln_dr_basic JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE;
2937: ln_dr_addl JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE;
2938: ln_dr_other JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE;

Line 2935: ln_cr_other JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE;

2931: r_parent_base_trx c_base_trx%ROWTYPE;
2932:
2933: ln_cr_basic JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE;
2934: ln_cr_addl JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE;
2935: ln_cr_other JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE;
2936: ln_dr_basic JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE;
2937: ln_dr_addl JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE;
2938: ln_dr_other JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE;
2939:

Line 2936: ln_dr_basic JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE;

2932:
2933: ln_cr_basic JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE;
2934: ln_cr_addl JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE;
2935: ln_cr_other JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE;
2936: ln_dr_basic JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE;
2937: ln_dr_addl JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE;
2938: ln_dr_other JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE;
2939:
2940: -- Date 04/06/2007 by sacsethi for bug 5228046

Line 2937: ln_dr_addl JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE;

2933: ln_cr_basic JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE;
2934: ln_cr_addl JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE;
2935: ln_cr_other JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE;
2936: ln_dr_basic JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE;
2937: ln_dr_addl JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE;
2938: ln_dr_other JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE;
2939:
2940: -- Date 04/06/2007 by sacsethi for bug 5228046
2941: ln_cr_addl_cvd JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE;

Line 2938: ln_dr_other JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE;

2934: ln_cr_addl JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE;
2935: ln_cr_other JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE;
2936: ln_dr_basic JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE;
2937: ln_dr_addl JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE;
2938: ln_dr_other JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE;
2939:
2940: -- Date 04/06/2007 by sacsethi for bug 5228046
2941: ln_cr_addl_cvd JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE;
2942: ln_dr_addl_cvd JAI_CMN_RG_23AC_II_TRXS.dr_additional_cvd%TYPE;

Line 2941: ln_cr_addl_cvd JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE;

2937: ln_dr_addl JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE;
2938: ln_dr_other JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE;
2939:
2940: -- Date 04/06/2007 by sacsethi for bug 5228046
2941: ln_cr_addl_cvd JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE;
2942: ln_dr_addl_cvd JAI_CMN_RG_23AC_II_TRXS.dr_additional_cvd%TYPE;
2943:
2944:
2945: lv_statement_id VARCHAR2(5);

Line 2942: ln_dr_addl_cvd JAI_CMN_RG_23AC_II_TRXS.dr_additional_cvd%TYPE;

2938: ln_dr_other JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE;
2939:
2940: -- Date 04/06/2007 by sacsethi for bug 5228046
2941: ln_cr_addl_cvd JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE;
2942: ln_dr_addl_cvd JAI_CMN_RG_23AC_II_TRXS.dr_additional_cvd%TYPE;
2943:
2944:
2945: lv_statement_id VARCHAR2(5);
2946: ln_other_tax_credit NUMBER;

Line 2948: lv_register_type JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE;

2944:
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;

Line 4903: FROM JAI_CMN_RG_23AC_II_TRXS;

4899: lv_include_cenvat_in_cost VARCHAR2(5);
4900:
4901: CURSOR c_rg23_part_ii_chk(cp_transaction_id IN NUMBER) IS
4902: SELECT count(1)
4903: FROM JAI_CMN_RG_23AC_II_TRXS;
4904:
4905: lv_statement_id VARCHAR2(5);
4906:
4907: r_jai_receipt_line c_jai_receipt_line%ROWTYPE; -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.

Line 6249: lv_reference_num JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE;

6245: ln_excise_sh_cess_rate NUMBER;
6246: ln_excise_sh_cess_accnt_id gl_code_combinations.code_combination_id%TYPE;
6247: --added by csahoo for bug#6078460, end
6248: lv_cenvat_register_type VARCHAR2(30);
6249: lv_reference_num JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE;
6250: lv_simulate_flag VARCHAR2(1);
6251:
6252: ln_part_ii_register_id NUMBER(15);
6253: lv_register_entry_type VARCHAR2(15);

Line 6387: lv_reference_name := 'JAI_CMN_RG_23AC_II_TRXS';

6383: lv_statement_id := '6';
6384: IF pv_process_status IN ('E', 'X') THEN
6385: GOTO end_of_procedure;
6386: END IF;
6387: lv_reference_name := 'JAI_CMN_RG_23AC_II_TRXS';
6388: ln_reference_id := ln_part_ii_register_id;
6389: elsif lv_cenvat_register_type = jai_constants.register_type_pla THEN
6390: lv_statement_id := '7';
6391: pv_codepath := jai_general_pkg.plot_codepath(17.1, pv_codepath);