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_23D_TRXS

Line 22: jai_cmn_rg_23d_trxs_pkg.insert_row

18: (1) Removed CVD from additional amount. This is
19: accidentally added to additional excise. This is
20: done in PROCEDURE rg23_d_entry.
21: (2) Rounded p_rate_per_unit to 4 decimal places in
22: jai_cmn_rg_23d_trxs_pkg.insert_row
23:
24: 27-Jul-2005 4516678 Added by Lakshmi Gopalsami Version 120.3
25: Issue :
26: a.Whenever a user creates a receipt for a CGIN or

Line 2527: FROM JAI_CMN_RG_23D_TRXS

2523: WHERE rel.rma_line_id = cp_oe_order_line_id;
2524:
2525: CURSOR c_parent_register_id(cp_receipt_id IN NUMBER, cp_transaction_id IN NUMBER) IS
2526: SELECT register_id
2527: FROM JAI_CMN_RG_23D_TRXS
2528: WHERE receipt_ref = cp_receipt_id
2529: ANd transaction_source_num = cp_transaction_id;
2530:
2531: CURSOR c_tax_rate(cp_shipment_line_id IN NUMBER) IS

Line 2547: ln_register_id JAI_CMN_RG_23D_TRXS.register_id%TYPE;

2543:
2544: r_trx c_trx%ROWTYPE;
2545: r_base_trx c_base_trx%ROWTYPE;
2546:
2547: ln_register_id JAI_CMN_RG_23D_TRXS.register_id%TYPE;
2548: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2549: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2550: lv_excise_invoice_no JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE;
2551: ld_excise_invoice_date JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE;

Line 2550: lv_excise_invoice_no JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE;

2546:
2547: ln_register_id JAI_CMN_RG_23D_TRXS.register_id%TYPE;
2548: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2549: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2550: lv_excise_invoice_no JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE;
2551: ld_excise_invoice_date JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE;
2552: ln_excise_duty_rate JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE;
2553: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2554: lv_transaction_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;

Line 2551: ld_excise_invoice_date JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE;

2547: ln_register_id JAI_CMN_RG_23D_TRXS.register_id%TYPE;
2548: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2549: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2550: lv_excise_invoice_no JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE;
2551: ld_excise_invoice_date JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE;
2552: ln_excise_duty_rate JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE;
2553: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2554: lv_transaction_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
2555: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;

Line 2552: ln_excise_duty_rate JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE;

2548: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2549: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2550: lv_excise_invoice_no JAI_CMN_RG_23D_TRXS.comm_invoice_no%TYPE;
2551: ld_excise_invoice_date JAI_CMN_RG_23D_TRXS.comm_invoice_date%TYPE;
2552: ln_excise_duty_rate JAI_CMN_RG_23D_TRXS.excise_duty_rate%TYPE;
2553: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2554: lv_transaction_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
2555: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2556: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;

Line 2569: ln_ancestor_reg_id JAI_CMN_RG_23D_TRXS.register_id%TYPE;

2565: ln_duty_amount NUMBER;
2566: ln_quantity_received NUMBER;
2567: ln_qty_to_adjust NUMBER;
2568:
2569: ln_ancestor_reg_id JAI_CMN_RG_23D_TRXS.register_id%TYPE;
2570: ln_ancestor_trxn_id RCV_TRANSACTIONS.transaction_id%TYPE;
2571:
2572: lv_statement_id VARCHAR2(5);
2573:

Line 2693: FND_FILE.put_line(FND_FILE.log,'Calling jai_cmn_rg_23d_trxs_pkg.insert_row');

2689: ln_qty_to_adjust := 0;
2690: END IF;
2691:
2692: if lb_rg_debug then
2693: FND_FILE.put_line(FND_FILE.log,'Calling jai_cmn_rg_23d_trxs_pkg.insert_row');
2694: end if;
2695:
2696: lv_statement_id := '6';
2697: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */

Line 2698: jai_cmn_rg_23d_trxs_pkg.insert_row(

2694: end if;
2695:
2696: lv_statement_id := '6';
2697: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
2698: jai_cmn_rg_23d_trxs_pkg.insert_row(
2699: p_register_id => p_register_id,
2700: p_organization_id => r_trx.organization_id,
2701: p_location_id => r_trx.location_id,
2702: p_transaction_type => lv_transaction_type,

Line 2876: FND_FILE.put_line(FND_FILE.log,'Calling jai_cmn_rg_23d_trxs_pkg.update_qty_to_adjust');

2872: FETCH c_parent_register_id INTO ln_ancestor_reg_id;
2873: CLOSE c_parent_register_id;
2874:
2875: if lb_rg_debug then
2876: FND_FILE.put_line(FND_FILE.log,'Calling jai_cmn_rg_23d_trxs_pkg.update_qty_to_adjust');
2877: end if;
2878:
2879: lv_statement_id := '9';
2880: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath); /* 11 */

Line 2881: jai_cmn_rg_23d_trxs_pkg.update_qty_to_adjust(

2877: end if;
2878:
2879: lv_statement_id := '9';
2880: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath); /* 11 */
2881: jai_cmn_rg_23d_trxs_pkg.update_qty_to_adjust(
2882: p_register_id => ln_ancestor_reg_id,
2883: p_quantity => ln_quantity_received ,
2884: p_simulate_flag => p_simulate_flag,
2885: p_process_status => p_process_status,

Line 4832: jai_cmn_rg_23d_trxs_pkg.update_payment_details(

4828:
4829: ELSIF p_quantity_register = 'RG23D' THEN
4830: lv_statement_id := '3';
4831: p_codepath := jai_general_pkg.plot_codepath(3, p_codepath); /* 3 */
4832: jai_cmn_rg_23d_trxs_pkg.update_payment_details(
4833: p_register_id => p_quantity_register_id,
4834: p_charge_account_id => p_charge_account_id
4835: );
4836: