eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMF_VALIDATIONS_PVT dependencies on MTL_UNITS_OF_MEASURE

Line 3130: --| on mtl_units_of_measure |

3126: --| Validates UOM |
3127: --| |
3128: --| DESCRIPTION |
3129: --| This function validates that the UOM codes exists |
3130: --| on mtl_units_of_measure |
3131: --| |
3132: --| PARAMETERS |
3133: --| P_usgae_uom IN mtl_units_of_measure.uom_code%TYPE - UOM code |
3134: --| |

Line 3133: --| P_usgae_uom IN mtl_units_of_measure.uom_code%TYPE - UOM code |

3129: --| This function validates that the UOM codes exists |
3130: --| on mtl_units_of_measure |
3131: --| |
3132: --| PARAMETERS |
3133: --| P_usgae_uom IN mtl_units_of_measure.uom_code%TYPE - UOM code |
3134: --| |
3135: --| RETURNS |
3136: --| TRUE - If UOM code is valid value |
3137: --| FALSE - If UOM codeis an invalid value |

Line 3147: P_usgae_uom IN mtl_units_of_measure.uom_code%TYPE

3143: -- Func end of comments
3144:
3145: FUNCTION Validate_Usage_Uom
3146: (
3147: P_usgae_uom IN mtl_units_of_measure.uom_code%TYPE
3148: ) RETURN BOOLEAN
3149: IS
3150:
3151: CURSOR Cur_uom IS

Line 3153: FROM mtl_units_of_measure

3149: IS
3150:
3151: CURSOR Cur_uom IS
3152: SELECT uom_code
3153: FROM mtl_units_of_measure
3154: WHERE uom_code = P_usgae_uom;
3155:
3156: l_usgae_uom mtl_units_of_measure.uom_code%TYPE ;
3157:

Line 3156: l_usgae_uom mtl_units_of_measure.uom_code%TYPE ;

3152: SELECT uom_code
3153: FROM mtl_units_of_measure
3154: WHERE uom_code = P_usgae_uom;
3155:
3156: l_usgae_uom mtl_units_of_measure.uom_code%TYPE ;
3157:
3158: BEGIN
3159:
3160: OPEN Cur_uom;

Line 3186: --| on mtl_units_of_measure for the item's class |

3182: --| Validates UOM |
3183: --| |
3184: --| DESCRIPTION |
3185: --| This function validates that the UOM codes exists |
3186: --| on mtl_units_of_measure for the item's class |
3187: --| |
3188: --| PARAMETERS |
3189: --| P_usgae_uom IN mtl_units_of_measure.uom_code%TYPE - UOM code |
3190: --| |

Line 3189: --| P_usgae_uom IN mtl_units_of_measure.uom_code%TYPE - UOM code |

3185: --| This function validates that the UOM codes exists |
3186: --| on mtl_units_of_measure for the item's class |
3187: --| |
3188: --| PARAMETERS |
3189: --| P_usgae_uom IN mtl_units_of_measure.uom_code%TYPE - UOM code |
3190: --| |
3191: --| RETURNS |
3192: --| TRUE - If UOM code is valid value |
3193: --| FALSE - If UOM codeis an invalid value |

Line 3203: P_uom_code IN mtl_units_of_measure.uom_code%TYPE,

3199: -- Func end of comments
3200:
3201: FUNCTION Validate_same_class_Uom
3202: (
3203: P_uom_code IN mtl_units_of_measure.uom_code%TYPE,
3204: p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE,
3205: p_organization_id IN mtl_system_items_b.organization_id%TYPE
3206: ) RETURN BOOLEAN
3207: IS

Line 3213: mtl_units_of_measure b,

3209: CURSOR Cur_uom
3210: IS
3211: SELECT c.uom_code
3212: FROM mtl_system_items_b a,
3213: mtl_units_of_measure b,
3214: mtl_units_of_measure c
3215: WHERE a.inventory_item_id = p_inventory_item_id
3216: AND a.organization_id = p_organization_id
3217: AND a.primary_uom_code = b.uom_code

Line 3214: mtl_units_of_measure c

3210: IS
3211: SELECT c.uom_code
3212: FROM mtl_system_items_b a,
3213: mtl_units_of_measure b,
3214: mtl_units_of_measure c
3215: WHERE a.inventory_item_id = p_inventory_item_id
3216: AND a.organization_id = p_organization_id
3217: AND a.primary_uom_code = b.uom_code
3218: AND b.uom_class = c.uom_class

Line 3221: l_uom_code mtl_units_of_measure.uom_code%TYPE;

3217: AND a.primary_uom_code = b.uom_code
3218: AND b.uom_class = c.uom_class
3219: AND c.uom_code= P_uom_code;
3220:
3221: l_uom_code mtl_units_of_measure.uom_code%TYPE;
3222: BEGIN
3223:
3224: OPEN Cur_uom;
3225: FETCH Cur_uom INTO l_uom_code;

Line 3321: --| p_usage_uom IN mtl_units_of_measure.uom_code%TYPE UOM Code |

3317: --| DESCRIPTION |
3318: --| This procedure returns the UOM class for the UOM code |
3319: --| |
3320: --| PARAMETERS |
3321: --| p_usage_uom IN mtl_units_of_measure.uom_code%TYPE UOM Code |
3322: --| p_usage_uom_class OUT mtl_units_of_measure.uom_class%TYPE |
3323: --| |
3324: --| RETURNS |
3325: --| Return UOM class |

Line 3322: --| p_usage_uom_class OUT mtl_units_of_measure.uom_class%TYPE |

3318: --| This procedure returns the UOM class for the UOM code |
3319: --| |
3320: --| PARAMETERS |
3321: --| p_usage_uom IN mtl_units_of_measure.uom_code%TYPE UOM Code |
3322: --| p_usage_uom_class OUT mtl_units_of_measure.uom_class%TYPE |
3323: --| |
3324: --| RETURNS |
3325: --| Return UOM class |
3326: --| |

Line 3334: p_usage_uom IN mtl_units_of_measure.uom_code%TYPE,

3330: --+==========================================================================+
3331: -- Procedure end of comments
3332:
3333: PROCEDURE validate_usage_uom (
3334: p_usage_uom IN mtl_units_of_measure.uom_code%TYPE,
3335: p_usage_uom_class OUT NOCOPY mtl_units_of_measure.uom_class%TYPE
3336: ) IS
3337:
3338: CURSOR cur_uom IS

Line 3335: p_usage_uom_class OUT NOCOPY mtl_units_of_measure.uom_class%TYPE

3331: -- Procedure end of comments
3332:
3333: PROCEDURE validate_usage_uom (
3334: p_usage_uom IN mtl_units_of_measure.uom_code%TYPE,
3335: p_usage_uom_class OUT NOCOPY mtl_units_of_measure.uom_class%TYPE
3336: ) IS
3337:
3338: CURSOR cur_uom IS
3339: SELECT uom_class

Line 3340: FROM mtl_units_of_measure

3336: ) IS
3337:
3338: CURSOR cur_uom IS
3339: SELECT uom_class
3340: FROM mtl_units_of_measure
3341: WHERE uom_code = p_usage_uom;
3342:
3343: BEGIN
3344: OPEN cur_uom;

Line 3359: , x_resource_uom_class OUT NOCOPY mtl_units_of_measure.uom_class%TYPE

3355: PROCEDURE Validate_Resource
3356: (
3357: p_Resources IN cr_rsrc_mst.Resources%TYPE
3358: , x_resource_uom OUT NOCOPY cr_rsrc_mst.std_usage_uom%TYPE
3359: , x_resource_uom_class OUT NOCOPY mtl_units_of_measure.uom_class%TYPE
3360: )
3361: IS
3362: CURSOR Cur_resources
3363: IS

Line 3367: mtl_units_of_measure uom, cr_rsrc_mst rm

3363: IS
3364: SELECT
3365: rm.std_usage_uom, uom.uom_class
3366: FROM
3367: mtl_units_of_measure uom, cr_rsrc_mst rm
3368: WHERE
3369: rm.resources = p_Resources
3370: AND uom.uom_code = rm.std_usage_uom
3371: AND rm.delete_mark = 0;