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.

[Home] [Help]

APPS.JAI_RCV_EXCISE_PROCESSING_PKG dependencies on JAI_CMN_RG_I_TRXS

Line 933: FROM JAI_CMN_RG_I_TRXS

929:
930: CURSOR cur_rg1_register_id
931: IS
932: SELECT register_id
933: FROM JAI_CMN_RG_I_TRXS
934: WHERE TRANSACTION_SOURCE_NUM = 18
935: AND register_id > 0 /*This check excludes master org records*/
936: AND ref_doc_no = p_transaction_id;
937:

Line 1340: UPDATE JAI_CMN_RG_I_TRXS

1336: OPEN cur_rg1_register_id;
1337: FETCH cur_rg1_register_id INTO ln_part_i_register_id;
1338: CLOSE cur_rg1_register_id;
1339:
1340: UPDATE JAI_CMN_RG_I_TRXS
1341: SET basic_ed = r_tax.basic_excise,
1342: additional_ed = r_tax.addl_excise + r_tax.cvd,
1343: other_ed = r_tax.other_excise,
1344: excise_duty_amount = r_tax.basic_excise + r_tax.addl_excise + r_tax.cvd + r_tax.other_excise,

Line 1850: ln_register_id JAI_CMN_RG_I_TRXS.register_id%TYPE;

1846:
1847: r_trx c_trx%ROWTYPE;
1848: r_base_trx c_base_trx%ROWTYPE;
1849:
1850: ln_register_id JAI_CMN_RG_I_TRXS.register_id%TYPE;
1851: lv_slno JAI_CMN_RG_I_TRXS.slno%TYPE;
1852: lv_range JAI_CMN_RG_I_TRXS.range_no%TYPE;
1853: lv_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
1854: ln_excise_duty_rate JAI_CMN_RG_I_TRXS.excise_duty_rate%TYPE;

Line 1851: lv_slno JAI_CMN_RG_I_TRXS.slno%TYPE;

1847: r_trx c_trx%ROWTYPE;
1848: r_base_trx c_base_trx%ROWTYPE;
1849:
1850: ln_register_id JAI_CMN_RG_I_TRXS.register_id%TYPE;
1851: lv_slno JAI_CMN_RG_I_TRXS.slno%TYPE;
1852: lv_range JAI_CMN_RG_I_TRXS.range_no%TYPE;
1853: lv_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
1854: ln_excise_duty_rate JAI_CMN_RG_I_TRXS.excise_duty_rate%TYPE;
1855: lv_excise_invoice_no JAI_CMN_RG_I_TRXS.excise_invoice_number%TYPE;

Line 1852: lv_range JAI_CMN_RG_I_TRXS.range_no%TYPE;

1848: r_base_trx c_base_trx%ROWTYPE;
1849:
1850: ln_register_id JAI_CMN_RG_I_TRXS.register_id%TYPE;
1851: lv_slno JAI_CMN_RG_I_TRXS.slno%TYPE;
1852: lv_range JAI_CMN_RG_I_TRXS.range_no%TYPE;
1853: lv_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
1854: ln_excise_duty_rate JAI_CMN_RG_I_TRXS.excise_duty_rate%TYPE;
1855: lv_excise_invoice_no JAI_CMN_RG_I_TRXS.excise_invoice_number%TYPE;
1856: ld_excise_invoice_date JAI_CMN_RG_I_TRXS.excise_invoice_date%TYPE;

Line 1853: lv_division JAI_CMN_RG_I_TRXS.division_no%TYPE;

1849:
1850: ln_register_id JAI_CMN_RG_I_TRXS.register_id%TYPE;
1851: lv_slno JAI_CMN_RG_I_TRXS.slno%TYPE;
1852: lv_range JAI_CMN_RG_I_TRXS.range_no%TYPE;
1853: lv_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
1854: ln_excise_duty_rate JAI_CMN_RG_I_TRXS.excise_duty_rate%TYPE;
1855: lv_excise_invoice_no JAI_CMN_RG_I_TRXS.excise_invoice_number%TYPE;
1856: ld_excise_invoice_date JAI_CMN_RG_I_TRXS.excise_invoice_date%TYPE;
1857: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;

Line 1854: ln_excise_duty_rate JAI_CMN_RG_I_TRXS.excise_duty_rate%TYPE;

1850: ln_register_id JAI_CMN_RG_I_TRXS.register_id%TYPE;
1851: lv_slno JAI_CMN_RG_I_TRXS.slno%TYPE;
1852: lv_range JAI_CMN_RG_I_TRXS.range_no%TYPE;
1853: lv_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
1854: ln_excise_duty_rate JAI_CMN_RG_I_TRXS.excise_duty_rate%TYPE;
1855: lv_excise_invoice_no JAI_CMN_RG_I_TRXS.excise_invoice_number%TYPE;
1856: ld_excise_invoice_date JAI_CMN_RG_I_TRXS.excise_invoice_date%TYPE;
1857: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
1858: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;

Line 1855: lv_excise_invoice_no JAI_CMN_RG_I_TRXS.excise_invoice_number%TYPE;

1851: lv_slno JAI_CMN_RG_I_TRXS.slno%TYPE;
1852: lv_range JAI_CMN_RG_I_TRXS.range_no%TYPE;
1853: lv_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
1854: ln_excise_duty_rate JAI_CMN_RG_I_TRXS.excise_duty_rate%TYPE;
1855: lv_excise_invoice_no JAI_CMN_RG_I_TRXS.excise_invoice_number%TYPE;
1856: ld_excise_invoice_date JAI_CMN_RG_I_TRXS.excise_invoice_date%TYPE;
1857: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
1858: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
1859: r_parent_base_trx c_base_trx%ROWTYPE;

Line 1856: ld_excise_invoice_date JAI_CMN_RG_I_TRXS.excise_invoice_date%TYPE;

1852: lv_range JAI_CMN_RG_I_TRXS.range_no%TYPE;
1853: lv_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
1854: ln_excise_duty_rate JAI_CMN_RG_I_TRXS.excise_duty_rate%TYPE;
1855: lv_excise_invoice_no JAI_CMN_RG_I_TRXS.excise_invoice_number%TYPE;
1856: ld_excise_invoice_date JAI_CMN_RG_I_TRXS.excise_invoice_date%TYPE;
1857: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
1858: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
1859: r_parent_base_trx c_base_trx%ROWTYPE;
1860:

Line 1868: lv_transaction_type JAI_CMN_RG_I_TRXS.transaction_type%TYPE;

1864: ln_other_ed NUMBER;
1865: ln_excise_duty_amount NUMBER;
1866:
1867:
1868: lv_transaction_type JAI_CMN_RG_I_TRXS.transaction_type%TYPE;
1869:
1870: ln_quantity NUMBER;
1871: ln_vendor_id NUMBER(15);
1872: ln_vendor_site_id NUMBER(15);

Line 1988: jai_cmn_rg_i_trxs_pkg.create_rg1_entry(

1984: end if;
1985:
1986: lv_statement_id := '9';
1987: p_codepath := jai_general_pkg.plot_codepath(8, p_codepath); /* 8 */
1988: jai_cmn_rg_i_trxs_pkg.create_rg1_entry(
1989: p_register_id => p_register_id,
1990: p_register_id_part_ii => null,
1991: p_fin_year => jai_general_pkg.get_fin_year(p_organization_id => r_trx.organization_id),
1992: p_slno => lv_slno,

Line 4472: UPDATE JAI_CMN_RG_I_TRXS

4468:
4469: ELSIF p_quantity_register = 'RG1' THEN
4470: lv_statement_id := '4';
4471: p_codepath := jai_general_pkg.plot_codepath(4, p_codepath); /* 4 */
4472: UPDATE JAI_CMN_RG_I_TRXS
4473: SET
4474: register_id_part_ii = p_payment_register_id,
4475: charge_account_id = p_charge_account_id,
4476: payment_register = p_payment_register