DBA Data[Home] [Help]

APPS.JAI_CMN_RG_I_TRXS_PKG dependencies on MTL_UNITS_OF_MEASURE

Line 19: v_primary_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;

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

Line 20: v_transaction_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;

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

Line 318: v_primary_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;

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

Line 319: v_transaction_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;

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