APPS.JAI_RCV_EXCISE_PROCESSING_PKG dependencies on JAI_CMN_RG_23AC_I_TRXS

Line 941: FROM JAI_CMN_RG_23AC_I_TRXS

937:
938: CURSOR cur_rg23_1_register_id
939: IS
940: SELECT register_id
941: FROM JAI_CMN_RG_23AC_I_TRXS
942: WHERE TRANSACTION_SOURCE_NUM = 18
943: AND register_id > 0 /*This check excludes master org records*/
944: AND RECEIPT_REF = p_transaction_id;
945: /*bgowrava for forward porting Bug#5756676 END*/

Line 1390: UPDATE JAI_CMN_RG_23AC_I_TRXS

1386: CLOSE cur_rg23_1_register_id;
1387:
1388: FND_FILE.put_line(FND_FILE.log, 'RG23 Part I Register Id:'||ln_part_i_register_id);
1389:
1390: UPDATE JAI_CMN_RG_23AC_I_TRXS
1391: SET basic_ed = r_tax.basic_excise,
1392: additional_ed = r_tax.addl_excise + r_tax.cvd,
1393: additional_cvd = r_tax.addl_cvd,
1394: other_ed = r_tax.other_excise,

Line 2076: ln_register_id JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE;

2072: r_trx c_trx%ROWTYPE;
2073: r_base_trx c_base_trx%ROWTYPE;
2074: r_po_header c_po_header%ROWTYPE;
2075:
2076: ln_register_id JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE;
2077: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2078: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2079: lv_excise_invoice_no JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE;
2080: ld_excise_invoice_date JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE;

Line 2079: lv_excise_invoice_no JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE;

2075:
2076: ln_register_id JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE;
2077: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2078: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2079: lv_excise_invoice_no JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE;
2080: ld_excise_invoice_date JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE;
2081: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2082: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2083: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;

Line 2080: ld_excise_invoice_date JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE;

2076: ln_register_id JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE;
2077: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2078: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2079: lv_excise_invoice_no JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE;
2080: ld_excise_invoice_date JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE;
2081: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2082: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2083: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
2084: r_parent_base_trx c_base_trx%ROWTYPE;

Line 2194: FND_FILE.put_line(FND_FILE.log,'Before call to jai_cmn_rg_23ac_i_trxs_pkg.insert_row');

2190: ln_additional_cvd := pr_tax.addl_cvd * ln_entry_type; -- Date 06/04/2007 by sacsethi for bug 6109941
2191: ln_other_ed := pr_tax.other_excise * ln_entry_type;
2192:
2193: if lb_rg_debug then
2194: FND_FILE.put_line(FND_FILE.log,'Before call to jai_cmn_rg_23ac_i_trxs_pkg.insert_row');
2195: end if;
2196:
2197: lv_statement_id := '7';
2198: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */

Line 2199: jai_cmn_rg_23ac_i_trxs_pkg.insert_row(

2195: end if;
2196:
2197: lv_statement_id := '7';
2198: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
2199: jai_cmn_rg_23ac_i_trxs_pkg.insert_row(
2200: p_register_id => p_register_id,
2201: p_inventory_item_id => r_trx.inventory_item_id,
2202: p_organization_id => r_trx.organization_id,
2203: p_quantity_received => ln_quantity,

Line 4455: jai_cmn_rg_23ac_i_trxs_pkg.update_payment_details(

4451:
4452: IF p_quantity_register IN ('RG23A', 'RG23C') THEN
4453: lv_statement_id := '2';
4454: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
4455: jai_cmn_rg_23ac_i_trxs_pkg.update_payment_details(
4456: p_register_id => p_quantity_register_id,
4457: p_register_id_part_ii => p_payment_register_id,
4458: p_charge_account_id => p_charge_account_id
4459: );