15:
16: /* Added by Ramananda for bug#4407165 */
17: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_i_trxs_pkg.validate_rg1_balances';
18:
19: v_primary_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
20: v_transaction_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
21: CURSOR c_item_primary_uom(p_organization_id NUMBER, p_inventory_item_id NUMBER) IS
22: SELECT primary_uom_code
23: FROM mtl_system_items
16: /* Added by Ramananda for bug#4407165 */
17: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_i_trxs_pkg.validate_rg1_balances';
18:
19: v_primary_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
20: v_transaction_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
21: CURSOR c_item_primary_uom(p_organization_id NUMBER, p_inventory_item_id NUMBER) IS
22: SELECT primary_uom_code
23: FROM mtl_system_items
24: WHERE organization_id = p_organization_id
314: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_i_trxs_pkg.create_rg1_entry';
315:
316: vMaxSlno NUMBER;
317: v_transaction_id JAI_CMN_RG_I_TRXS.TRANSACTION_SOURCE_NUM%TYPE;
318: v_primary_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
319: v_transaction_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
320: vTransToPrimaryUOMConv NUMBER;
321:
322: CURSOR c_item_primary_uom(p_organization_id NUMBER, p_inventory_item_id NUMBER) IS
315:
316: vMaxSlno NUMBER;
317: v_transaction_id JAI_CMN_RG_I_TRXS.TRANSACTION_SOURCE_NUM%TYPE;
318: v_primary_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
319: v_transaction_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
320: vTransToPrimaryUOMConv NUMBER;
321:
322: CURSOR c_item_primary_uom(p_organization_id NUMBER, p_inventory_item_id NUMBER) IS
323: SELECT primary_uom_code