APPS.JAI_OM_RG_PKG dependencies on JAI_CMN_RG_23AC_I_TRXS

Line 22: Sequence JAI_CMN_RG_23AC_I_TXNS_S is replaced by JAI_CMN_RG_23AC_I_TRXS_S

18: 06-Jul-2005 Ramananda for bug#4477004. File Version: 116.4
19: GL Sources and GL Categories got changed. Refer bug for the details
20:
21: 14-Jul-2005 rchandan for bug#4487676. File Version 117.2
22: Sequence JAI_CMN_RG_23AC_I_TXNS_S is replaced by JAI_CMN_RG_23AC_I_TRXS_S
23:
24: 28/07/2005 Changes in JA_IN_ACCOUNTING_ENTRIES Procedure
25: Ramananda for Bug#4516577, Version 120.2
26:

Line 2282: FROM JAI_CMN_RG_23AC_I_TRXS

2278: WHERE inventory_item_id = p_inventory_item_id AND
2279: organization_id = p_org_id;
2280: CURSOR serial_no_cur IS
2281: SELECT NVL(MAX(slno),0) , NVL(MAX(slno),0) + 1
2282: FROM JAI_CMN_RG_23AC_I_TRXS
2283: WHERE organization_id = p_org_id AND
2284: location_id = p_location_id AND
2285: inventory_item_id = p_inventory_item_id AND
2286: fin_year = p_fin_year AND

Line 2290: FROM JAI_CMN_RG_23AC_I_TRXS

2286: fin_year = p_fin_year AND
2287: register_type = p_register_type;
2288: CURSOR opening_balance_qty_cur(p_previous_serial_no IN NUMBER) IS
2289: SELECT NVL(opening_balance_qty,0), NVL(closing_balance_qty,0)
2290: FROM JAI_CMN_RG_23AC_I_TRXS
2291: WHERE slno = p_previous_serial_no AND
2292: organization_id = p_org_id AND
2293: location_id = p_location_id AND
2294: register_type = p_register_type AND

Line 2352: INSERT INTO JAI_CMN_RG_23AC_I_TRXS (register_id, fin_year, slno, inventory_item_id, organization_id,

2348: v_basic_ed := '';
2349: v_additional_ed := '';
2350: v_other_ed := '';
2351: END IF;
2352: INSERT INTO JAI_CMN_RG_23AC_I_TRXS (register_id, fin_year, slno, inventory_item_id, organization_id,
2353: location_id, TRANSACTION_SOURCE_NUM, transaction_type, transaction_date,
2354: customer_id, customer_site_id, range_no, division_no,
2355: SALES_INVOICE_NO, sales_invoice_quantity, sales_invoice_date,
2356: EXCISE_INVOICE_NO, excise_invoice_date, register_type,

Line 2361: VALUES(JAI_CMN_RG_23AC_I_TRXS_S.NEXTVAL, p_fin_year, v_serial_no, p_inventory_item_id, p_org_id,/*rchandan for bug#4487676*/

2357: transaction_uom_code, primary_uom_code, basic_ed, additional_ed,
2358: other_ed, opening_balance_qty, closing_balance_qty,
2359: creation_date,created_by,last_update_login,
2360: last_update_date,last_updated_by)
2361: VALUES(JAI_CMN_RG_23AC_I_TRXS_S.NEXTVAL, p_fin_year, v_serial_no, p_inventory_item_id, p_org_id,/*rchandan for bug#4487676*/
2362: p_location_id, p_transaction_id, p_transaction_type, TRUNC(p_transaction_date),
2363: p_customer_id,p_customer_site_id,v_range_no,v_division_no,
2364: p_excise_invoice_id, v_excise_quantity, p_excise_invoice_date,
2365: p_header_id, p_sales_invoice_date, p_register_type,