DBA Data[Home] [Help]

APPS.JAI_CMN_RG_I_TRXS_PKG dependencies on MTL_UNITS_OF_MEASURE

Line 18: v_primary_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;

14:
15: /* Added by Ramananda for bug#4407165 */
16: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_i_trxs_pkg.validate_rg1_balances';
17:
18: v_primary_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
19: v_transaction_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
20: CURSOR c_item_primary_uom(p_organization_id NUMBER, p_inventory_item_id NUMBER) IS
21: SELECT primary_uom_code
22: FROM mtl_system_items

Line 19: v_transaction_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;

15: /* Added by Ramananda for bug#4407165 */
16: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_i_trxs_pkg.validate_rg1_balances';
17:
18: v_primary_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
19: v_transaction_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
20: CURSOR c_item_primary_uom(p_organization_id NUMBER, p_inventory_item_id NUMBER) IS
21: SELECT primary_uom_code
22: FROM mtl_system_items
23: WHERE organization_id = p_organization_id

Line 276: v_primary_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;

272: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rg_i_trxs_pkg.create_rg1_entry';
273:
274: vMaxSlno NUMBER;
275: v_transaction_id JAI_CMN_RG_I_TRXS.TRANSACTION_SOURCE_NUM%TYPE;
276: v_primary_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
277: v_transaction_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
278: vTransToPrimaryUOMConv NUMBER;
279:
280: CURSOR c_item_primary_uom(p_organization_id NUMBER, p_inventory_item_id NUMBER) IS

Line 277: v_transaction_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;

273:
274: vMaxSlno NUMBER;
275: v_transaction_id JAI_CMN_RG_I_TRXS.TRANSACTION_SOURCE_NUM%TYPE;
276: v_primary_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
277: v_transaction_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
278: vTransToPrimaryUOMConv NUMBER;
279:
280: CURSOR c_item_primary_uom(p_organization_id NUMBER, p_inventory_item_id NUMBER) IS
281: SELECT primary_uom_code