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 2441: FROM JAI_CMN_RG_23AC_I_TRXS

2437: WHERE inventory_item_id = p_inventory_item_id AND
2438: organization_id = p_org_id;
2439: CURSOR serial_no_cur IS
2440: SELECT NVL(MAX(slno),0) , NVL(MAX(slno),0) + 1
2441: FROM JAI_CMN_RG_23AC_I_TRXS
2442: WHERE organization_id = p_org_id AND
2443: location_id = p_location_id AND
2444: inventory_item_id = p_inventory_item_id AND
2445: fin_year = p_fin_year AND

Line 2449: FROM JAI_CMN_RG_23AC_I_TRXS

2445: fin_year = p_fin_year AND
2446: register_type = p_register_type;
2447: CURSOR opening_balance_qty_cur(p_previous_serial_no IN NUMBER) IS
2448: SELECT NVL(opening_balance_qty,0), NVL(closing_balance_qty,0)
2449: FROM JAI_CMN_RG_23AC_I_TRXS
2450: WHERE slno = p_previous_serial_no AND
2451: organization_id = p_org_id AND
2452: location_id = p_location_id AND
2453: register_type = p_register_type AND

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

2513: v_basic_ed := '';
2514: v_additional_ed := '';
2515: v_other_ed := '';
2516: END IF;
2517: INSERT INTO JAI_CMN_RG_23AC_I_TRXS (register_id, fin_year, slno, inventory_item_id, organization_id,
2518: location_id, TRANSACTION_SOURCE_NUM, transaction_type, transaction_date,
2519: customer_id, customer_site_id, range_no, division_no,
2520: SALES_INVOICE_NO, sales_invoice_quantity, sales_invoice_date,
2521: EXCISE_INVOICE_NO, excise_invoice_date, register_type,

Line 2526: 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*/

2522: transaction_uom_code, primary_uom_code, basic_ed, additional_ed,
2523: other_ed, opening_balance_qty, closing_balance_qty,
2524: creation_date,created_by,last_update_login,
2525: last_update_date,last_updated_by)
2526: 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*/
2527: p_location_id, p_transaction_id, p_transaction_type, TRUNC(p_transaction_date),
2528: p_customer_id,p_customer_site_id,v_range_no,v_division_no,
2529: p_excise_invoice_id, round(v_excise_quantity,5), p_excise_invoice_date,
2530: p_header_id, p_sales_invoice_date, p_register_type,

Line 4839: select fin_year,max(slno) from JAI_CMN_RG_23AC_I_TRXS

4835: p_register_type in varchar2,
4836: p_slno out NOCOPY number) return number
4837: is
4838: Cursor c_yearslno is
4839: select fin_year,max(slno) from JAI_CMN_RG_23AC_I_TRXS
4840: where organization_id = p_organization_id
4841: and location_id = p_location_id
4842: and inventory_item_id = p_inventory_item_id
4843: and register_type = p_register_type

Line 4849: from JAI_CMN_RG_23AC_I_TRXS

4845: order by fin_year desc;
4846:
4847: Cursor c_fetchbalance(cp_balyear number,cp_slno number) is
4848: select NVL(closing_balance_qty, 0) closing_balance_qty
4849: from JAI_CMN_RG_23AC_I_TRXS
4850: where organization_id = p_organization_id
4851: and location_id = p_location_id
4852: and inventory_item_id = p_inventory_item_id
4853: and register_type = p_register_type