APPS.JAI_RCV_EXCISE_PROCESSING_PKG dependencies on JAI_CMN_RG_23AC_I_TRXS

Line 1072: FROM JAI_CMN_RG_23AC_I_TRXS

1068:
1069: CURSOR cur_rg23_1_register_id
1070: IS
1071: SELECT register_id
1072: FROM JAI_CMN_RG_23AC_I_TRXS
1073: WHERE TRANSACTION_SOURCE_NUM = 18
1074: AND register_id > 0 /*This check excludes master org records*/
1075: AND RECEIPT_REF = p_transaction_id;
1076: /*bgowrava for forward porting Bug#5756676 END*/

Line 1549: UPDATE JAI_CMN_RG_23AC_I_TRXS

1545: CLOSE cur_rg23_1_register_id;
1546:
1547: FND_FILE.put_line(FND_FILE.log, 'RG23 Part I Register Id:'||ln_part_i_register_id);
1548:
1549: UPDATE JAI_CMN_RG_23AC_I_TRXS
1550: SET basic_ed = r_tax.basic_excise,
1551: additional_ed = r_tax.addl_excise + r_tax.cvd,
1552: additional_cvd = r_tax.addl_cvd,
1553: other_ed = r_tax.other_excise,

Line 2285: ln_register_id JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE;

2281: r_trx c_trx%ROWTYPE;
2282: r_base_trx c_base_trx%ROWTYPE;
2283: r_po_header c_po_header%ROWTYPE;
2284:
2285: ln_register_id JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE;
2286: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2287: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2288: lv_excise_invoice_no JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE;
2289: ld_excise_invoice_date JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE;

Line 2288: lv_excise_invoice_no JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE;

2284:
2285: ln_register_id JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE;
2286: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2287: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2288: lv_excise_invoice_no JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE;
2289: ld_excise_invoice_date JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE;
2290: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2291: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2292: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;

Line 2289: ld_excise_invoice_date JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE;

2285: ln_register_id JAI_CMN_RG_23AC_I_TRXS.register_id%TYPE;
2286: ln_vendor_id RCV_TRANSACTIONS.vendor_id%TYPE;
2287: ln_vendor_site_id RCV_TRANSACTIONS.vendor_site_id%TYPE;
2288: lv_excise_invoice_no JAI_CMN_RG_23AC_I_TRXS.EXCISE_INVOICE_NO%TYPE;
2289: ld_excise_invoice_date JAI_CMN_RG_23AC_I_TRXS.excise_invoice_date%TYPE;
2290: lv_transaction_type RCV_TRANSACTIONS.transaction_type%TYPE;
2291: ln_customer_id RCV_TRANSACTIONS.customer_id%TYPE;
2292: ln_customer_site_id RCV_TRANSACTIONS.customer_site_id%TYPE;
2293: r_parent_base_trx c_base_trx%ROWTYPE;

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

2424: --added for bug#9854329,end
2425: ln_other_ed := pr_tax.other_excise * ln_entry_type;
2426:
2427: if lb_rg_debug then
2428: FND_FILE.put_line(FND_FILE.log,'Before call to jai_cmn_rg_23ac_i_trxs_pkg.insert_row');
2429: end if;
2430:
2431: lv_statement_id := '7';
2432: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */

Line 2433: jai_cmn_rg_23ac_i_trxs_pkg.insert_row(

2429: end if;
2430:
2431: lv_statement_id := '7';
2432: p_codepath := jai_general_pkg.plot_codepath(7, p_codepath); /* 7 */
2433: jai_cmn_rg_23ac_i_trxs_pkg.insert_row(
2434: p_register_id => p_register_id,
2435: p_inventory_item_id => r_trx.inventory_item_id,
2436: p_organization_id => r_trx.organization_id,
2437: p_quantity_received => ln_quantity,

Line 4823: jai_cmn_rg_23ac_i_trxs_pkg.update_payment_details(

4819:
4820: IF p_quantity_register IN ('RG23A', 'RG23C') THEN
4821: lv_statement_id := '2';
4822: p_codepath := jai_general_pkg.plot_codepath(2, p_codepath); /* 2 */
4823: jai_cmn_rg_23ac_i_trxs_pkg.update_payment_details(
4824: p_register_id => p_quantity_register_id,
4825: p_register_id_part_ii => p_payment_register_id,
4826: p_charge_account_id => p_charge_account_id
4827: );