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 326: lv_register_type JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE;

322: lv_remarks JAI_CMN_RG_PLA_TRXS.REMARKS%TYPE;
323: lv_statement_id VARCHAR2(5);
324: lv_process_status VARCHAR2(2);
325: lv_process_message VARCHAR2(2000);
326: lv_register_type JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE;
327: ln_reg_dr NUMBER ;
328: ln_reg_cr NUMBER ;
329: lv_upd_opening_bal_dr NUMBER ;
330: lv_upd_opening_bal_cr NUMBER ;

Line 535: FROM JAI_CMN_RG_23AC_II_TRXS

531: dr_other_ed,
532: other_tax_credit,
533: other_tax_debit,
534: remarks
535: FROM JAI_CMN_RG_23AC_II_TRXS
536: WHERE organization_id = pr_tax.organization_id
537: AND location_id = pr_tax.location_id
538: AND inventory_item_id = pr_tax.inventory_item_id
539: AND receipt_ref = pr_tax.transaction_id

Line 892: lv_reference_num JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE;

888: lv_cenvat_accounting_type VARCHAR2(10);
889: lv_register_entry_type VARCHAR2(10);
890: lv_cgin_code VARCHAR2(100);
891:
892: lv_reference_num JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE;
893:
894: -- amount related variables
895: ln_curr_conv_rate NUMBER;
896: ln_excise_amount NUMBER;

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

1044: 6. 15/04/2005 Sanjikum for Bug #4293421, File Version 116.0(115.7)
1045:
1046: Problem
1047: -------
1048: During Cenvat Claim, while Inserting the Record into JAI_CMN_RG_23AC_II_TRXS, the Transaction date is inserted as Transaction Date of
1049: the JAI_RCV_TRANSACTIONS.transaction_date. It should be the date on which claim is being made.
1050:
1051: Fix
1052: ---

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

1090: IN60105D2 + 3496408
1091: IN60106 + 3940588 + 4146708/4239736 + 4103161 + 4346453
1092:
1093: /* IMPORTANT NOTE:
1094: For Receiving Transactions: In case of CGIN Claim a value needs to be passed for JAI_CMN_RG_23AC_II_TRXS.REFERENCE_NUM column
1095: that will be used for Duplicate Checking.
1096: Incase of RECEIVE transaction value passed for 1st 50% Claim is '1st Claim'. During 2nd 50% Claim '2nd Claim' is passed
1097: If 2nd Claim is happening from RTV transaction then TRANSACTION_ID of RECEIVE is passed as the value towards REFERENCE_NUM
1098: In all Other transactions value passed for REFERENCE_NUM column is NULL

Line 1575: -- 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

1571: IF lv_transaction_type = 'RECEIVE' AND lv_cgin_code IS NOT NULL THEN
1572: -- 1st Claim
1573: IF nvl(p_cenvat_claimed_ptg, 0) = 0 THEN
1574: lv_reference_num := CGIN_FIRST_CLAIM;
1575: -- 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
1576: ELSE -- IF p_cenvat_claimed_ptg = 50 THEN
1577: lv_reference_num := CGIN_SECOND_CLAIM;
1578: END IF;
1579: ELSE

Line 2685: ln_register_id JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE;

2681: r_trx c_trx%ROWTYPE;
2682: r_base_trx c_base_trx%ROWTYPE;
2683: r_parent_trx c_trx%ROWTYPE;
2684:
2685: ln_register_id JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE;
2686: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2687: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2688: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2689: lv_excise_invoice_no JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE;

Line 2689: lv_excise_invoice_no JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE;

2685: ln_register_id JAI_CMN_RG_23AC_II_TRXS.register_id%TYPE;
2686: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2687: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2688: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2689: lv_excise_invoice_no JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE;
2690: ld_excise_invoice_date JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE;
2691: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2692: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
2693: r_parent_base_trx c_base_trx%ROWTYPE;

Line 2690: ld_excise_invoice_date JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE;

2686: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2687: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2688: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2689: lv_excise_invoice_no JAI_CMN_RG_23AC_II_TRXS.excise_invoice_no%TYPE;
2690: ld_excise_invoice_date JAI_CMN_RG_23AC_II_TRXS.excise_invoice_date%TYPE;
2691: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2692: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
2693: r_parent_base_trx c_base_trx%ROWTYPE;
2694:

Line 2695: ln_cr_basic JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE;

2691: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2692: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
2693: r_parent_base_trx c_base_trx%ROWTYPE;
2694:
2695: ln_cr_basic JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE;
2696: ln_cr_addl JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE;
2697: ln_cr_other JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE;
2698: ln_dr_basic JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE;
2699: ln_dr_addl JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE;

Line 2696: ln_cr_addl JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE;

2692: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
2693: r_parent_base_trx c_base_trx%ROWTYPE;
2694:
2695: ln_cr_basic JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE;
2696: ln_cr_addl JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE;
2697: ln_cr_other JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE;
2698: ln_dr_basic JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE;
2699: ln_dr_addl JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE;
2700: ln_dr_other JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE;

Line 2697: ln_cr_other JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE;

2693: r_parent_base_trx c_base_trx%ROWTYPE;
2694:
2695: ln_cr_basic JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE;
2696: ln_cr_addl JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE;
2697: ln_cr_other JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE;
2698: ln_dr_basic JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE;
2699: ln_dr_addl JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE;
2700: ln_dr_other JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE;
2701:

Line 2698: ln_dr_basic JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE;

2694:
2695: ln_cr_basic JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE;
2696: ln_cr_addl JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE;
2697: ln_cr_other JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE;
2698: ln_dr_basic JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE;
2699: ln_dr_addl JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE;
2700: ln_dr_other JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE;
2701:
2702: -- Date 04/06/2007 by sacsethi for bug 5228046

Line 2699: ln_dr_addl JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE;

2695: ln_cr_basic JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE;
2696: ln_cr_addl JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE;
2697: ln_cr_other JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE;
2698: ln_dr_basic JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE;
2699: ln_dr_addl JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE;
2700: ln_dr_other JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE;
2701:
2702: -- Date 04/06/2007 by sacsethi for bug 5228046
2703: ln_cr_addl_cvd JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE;

Line 2700: ln_dr_other JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE;

2696: ln_cr_addl JAI_CMN_RG_23AC_II_TRXS.cr_additional_ed%TYPE;
2697: ln_cr_other JAI_CMN_RG_23AC_II_TRXS.cr_other_ed%TYPE;
2698: ln_dr_basic JAI_CMN_RG_23AC_II_TRXS.dr_basic_ed%TYPE;
2699: ln_dr_addl JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE;
2700: ln_dr_other JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE;
2701:
2702: -- Date 04/06/2007 by sacsethi for bug 5228046
2703: ln_cr_addl_cvd JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE;
2704: ln_dr_addl_cvd JAI_CMN_RG_23AC_II_TRXS.dr_additional_cvd%TYPE;

Line 2703: ln_cr_addl_cvd JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE;

2699: ln_dr_addl JAI_CMN_RG_23AC_II_TRXS.dr_additional_ed%TYPE;
2700: ln_dr_other JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE;
2701:
2702: -- Date 04/06/2007 by sacsethi for bug 5228046
2703: ln_cr_addl_cvd JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE;
2704: ln_dr_addl_cvd JAI_CMN_RG_23AC_II_TRXS.dr_additional_cvd%TYPE;
2705:
2706:
2707: lv_statement_id VARCHAR2(5);

Line 2704: ln_dr_addl_cvd JAI_CMN_RG_23AC_II_TRXS.dr_additional_cvd%TYPE;

2700: ln_dr_other JAI_CMN_RG_23AC_II_TRXS.dr_other_ed%TYPE;
2701:
2702: -- Date 04/06/2007 by sacsethi for bug 5228046
2703: ln_cr_addl_cvd JAI_CMN_RG_23AC_II_TRXS.cr_additional_cvd%TYPE;
2704: ln_dr_addl_cvd JAI_CMN_RG_23AC_II_TRXS.dr_additional_cvd%TYPE;
2705:
2706:
2707: lv_statement_id VARCHAR2(5);
2708: ln_other_tax_credit NUMBER;

Line 2710: lv_register_type JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE;

2706:
2707: lv_statement_id VARCHAR2(5);
2708: ln_other_tax_credit NUMBER;
2709: ln_other_tax_debit NUMBER;
2710: lv_register_type JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE;
2711: lv_source_register JAI_CMN_RG_OTHERS.source_register%TYPE;
2712:
2713: BEGIN
2714:

Line 4535: FROM JAI_CMN_RG_23AC_II_TRXS;

4531: lv_include_cenvat_in_cost VARCHAR2(5);
4532:
4533: CURSOR c_rg23_part_ii_chk(cp_transaction_id IN NUMBER) IS
4534: SELECT count(1)
4535: FROM JAI_CMN_RG_23AC_II_TRXS;
4536:
4537: lv_statement_id VARCHAR2(5);
4538:
4539: r_jai_receipt_line c_jai_receipt_line%ROWTYPE; -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.

Line 5663: lv_reference_num JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE;

5659: ln_excise_sh_cess_rate NUMBER;
5660: ln_excise_sh_cess_accnt_id gl_code_combinations.code_combination_id%TYPE;
5661: --added by csahoo for bug#6078460, end
5662: lv_cenvat_register_type VARCHAR2(30);
5663: lv_reference_num JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE;
5664: lv_simulate_flag VARCHAR2(1);
5665:
5666: ln_part_ii_register_id NUMBER(15);
5667: lv_register_entry_type VARCHAR2(15);

Line 5800: lv_reference_name := 'JAI_CMN_RG_23AC_II_TRXS';

5796: lv_statement_id := '6';
5797: IF pv_process_status IN ('E', 'X') THEN
5798: GOTO end_of_procedure;
5799: END IF;
5800: lv_reference_name := 'JAI_CMN_RG_23AC_II_TRXS';
5801: ln_reference_id := ln_part_ii_register_id;
5802: elsif lv_cenvat_register_type = jai_constants.register_type_pla THEN
5803: lv_statement_id := '7';
5804: pv_codepath := jai_general_pkg.plot_codepath(17.1, pv_codepath);