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_I_TRXS

Line 1064: FROM JAI_CMN_RG_I_TRXS

1060:
1061: CURSOR cur_rg1_register_id
1062: IS
1063: SELECT register_id
1064: FROM JAI_CMN_RG_I_TRXS
1065: WHERE TRANSACTION_SOURCE_NUM = 18
1066: AND register_id > 0 /*This check excludes master org records*/
1067: AND ref_doc_no = to_char(p_transaction_id);--added for bug#9478222
1068:

Line 1499: UPDATE JAI_CMN_RG_I_TRXS

1495: OPEN cur_rg1_register_id;
1496: FETCH cur_rg1_register_id INTO ln_part_i_register_id;
1497: CLOSE cur_rg1_register_id;
1498:
1499: UPDATE JAI_CMN_RG_I_TRXS
1500: SET basic_ed = r_tax.basic_excise,
1501: additional_ed = r_tax.addl_excise + r_tax.cvd,
1502: other_ed = r_tax.other_excise,
1503: excise_duty_amount = r_tax.basic_excise + r_tax.addl_excise + r_tax.cvd + r_tax.other_excise,

Line 2028: ln_register_id JAI_CMN_RG_I_TRXS.register_id%TYPE;

2024:
2025: r_trx c_trx%ROWTYPE;
2026: r_base_trx c_base_trx%ROWTYPE;
2027:
2028: ln_register_id JAI_CMN_RG_I_TRXS.register_id%TYPE;
2029: lv_slno JAI_CMN_RG_I_TRXS.slno%TYPE;
2030: lv_range JAI_CMN_RG_I_TRXS.range_no%TYPE;
2031: lv_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
2032: ln_excise_duty_rate JAI_CMN_RG_I_TRXS.excise_duty_rate%TYPE;

Line 2029: lv_slno JAI_CMN_RG_I_TRXS.slno%TYPE;

2025: r_trx c_trx%ROWTYPE;
2026: r_base_trx c_base_trx%ROWTYPE;
2027:
2028: ln_register_id JAI_CMN_RG_I_TRXS.register_id%TYPE;
2029: lv_slno JAI_CMN_RG_I_TRXS.slno%TYPE;
2030: lv_range JAI_CMN_RG_I_TRXS.range_no%TYPE;
2031: lv_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
2032: ln_excise_duty_rate JAI_CMN_RG_I_TRXS.excise_duty_rate%TYPE;
2033: lv_excise_invoice_no JAI_CMN_RG_I_TRXS.excise_invoice_number%TYPE;

Line 2030: lv_range JAI_CMN_RG_I_TRXS.range_no%TYPE;

2026: r_base_trx c_base_trx%ROWTYPE;
2027:
2028: ln_register_id JAI_CMN_RG_I_TRXS.register_id%TYPE;
2029: lv_slno JAI_CMN_RG_I_TRXS.slno%TYPE;
2030: lv_range JAI_CMN_RG_I_TRXS.range_no%TYPE;
2031: lv_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
2032: ln_excise_duty_rate JAI_CMN_RG_I_TRXS.excise_duty_rate%TYPE;
2033: lv_excise_invoice_no JAI_CMN_RG_I_TRXS.excise_invoice_number%TYPE;
2034: ld_excise_invoice_date JAI_CMN_RG_I_TRXS.excise_invoice_date%TYPE;

Line 2031: lv_division JAI_CMN_RG_I_TRXS.division_no%TYPE;

2027:
2028: ln_register_id JAI_CMN_RG_I_TRXS.register_id%TYPE;
2029: lv_slno JAI_CMN_RG_I_TRXS.slno%TYPE;
2030: lv_range JAI_CMN_RG_I_TRXS.range_no%TYPE;
2031: lv_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
2032: ln_excise_duty_rate JAI_CMN_RG_I_TRXS.excise_duty_rate%TYPE;
2033: lv_excise_invoice_no JAI_CMN_RG_I_TRXS.excise_invoice_number%TYPE;
2034: ld_excise_invoice_date JAI_CMN_RG_I_TRXS.excise_invoice_date%TYPE;
2035: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;

Line 2032: ln_excise_duty_rate JAI_CMN_RG_I_TRXS.excise_duty_rate%TYPE;

2028: ln_register_id JAI_CMN_RG_I_TRXS.register_id%TYPE;
2029: lv_slno JAI_CMN_RG_I_TRXS.slno%TYPE;
2030: lv_range JAI_CMN_RG_I_TRXS.range_no%TYPE;
2031: lv_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
2032: ln_excise_duty_rate JAI_CMN_RG_I_TRXS.excise_duty_rate%TYPE;
2033: lv_excise_invoice_no JAI_CMN_RG_I_TRXS.excise_invoice_number%TYPE;
2034: ld_excise_invoice_date JAI_CMN_RG_I_TRXS.excise_invoice_date%TYPE;
2035: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2036: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;

Line 2033: lv_excise_invoice_no JAI_CMN_RG_I_TRXS.excise_invoice_number%TYPE;

2029: lv_slno JAI_CMN_RG_I_TRXS.slno%TYPE;
2030: lv_range JAI_CMN_RG_I_TRXS.range_no%TYPE;
2031: lv_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
2032: ln_excise_duty_rate JAI_CMN_RG_I_TRXS.excise_duty_rate%TYPE;
2033: lv_excise_invoice_no JAI_CMN_RG_I_TRXS.excise_invoice_number%TYPE;
2034: ld_excise_invoice_date JAI_CMN_RG_I_TRXS.excise_invoice_date%TYPE;
2035: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2036: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
2037: r_parent_base_trx c_base_trx%ROWTYPE;

Line 2034: ld_excise_invoice_date JAI_CMN_RG_I_TRXS.excise_invoice_date%TYPE;

2030: lv_range JAI_CMN_RG_I_TRXS.range_no%TYPE;
2031: lv_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
2032: ln_excise_duty_rate JAI_CMN_RG_I_TRXS.excise_duty_rate%TYPE;
2033: lv_excise_invoice_no JAI_CMN_RG_I_TRXS.excise_invoice_number%TYPE;
2034: ld_excise_invoice_date JAI_CMN_RG_I_TRXS.excise_invoice_date%TYPE;
2035: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2036: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
2037: r_parent_base_trx c_base_trx%ROWTYPE;
2038:

Line 2046: lv_transaction_type JAI_CMN_RG_I_TRXS.transaction_type%TYPE;

2042: ln_other_ed NUMBER;
2043: ln_excise_duty_amount NUMBER;
2044:
2045:
2046: lv_transaction_type JAI_CMN_RG_I_TRXS.transaction_type%TYPE;
2047:
2048: ln_quantity NUMBER;
2049: ln_vendor_id NUMBER(15);
2050: ln_vendor_site_id NUMBER(15);

Line 2197: jai_cmn_rg_i_trxs_pkg.create_rg1_entry(

2193: end if;
2194:
2195: lv_statement_id := '9';
2196: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
2197: jai_cmn_rg_i_trxs_pkg.create_rg1_entry(
2198: p_register_id => p_register_id,
2199: p_register_id_part_ii => null,
2200: p_fin_year => jai_general_pkg.get_fin_year(p_organization_id => r_trx.organization_id),
2201: p_slno => lv_slno,

Line 4840: UPDATE JAI_CMN_RG_I_TRXS

4836:
4837: ELSIF p_quantity_register = 'RG1' THEN
4838: lv_statement_id := '4';
4839: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */
4840: UPDATE JAI_CMN_RG_I_TRXS
4841: SET
4842: register_id_part_ii = p_payment_register_id,
4843: charge_account_id = p_charge_account_id,
4844: payment_register = p_payment_register