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 3128: --| on mtl_units_of_measure |

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

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

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

Line 3145: P_usgae_uom IN mtl_units_of_measure.uom_code%TYPE

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

Line 3151: FROM mtl_units_of_measure

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

Line 3154: l_usgae_uom mtl_units_of_measure.uom_code%TYPE ;

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

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

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

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

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

Line 3201: P_uom_code IN mtl_units_of_measure.uom_code%TYPE,

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

Line 3211: mtl_units_of_measure b,

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

Line 3212: mtl_units_of_measure c

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

Line 3219: l_uom_code mtl_units_of_measure.uom_code%TYPE;

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

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

3245: --| DESCRIPTION |
3246: --| This procedure returns the UOM class for the UOM code |
3247: --| |
3248: --| PARAMETERS |
3249: --| p_usage_uom IN mtl_units_of_measure.uom_code%TYPE UOM Code |
3250: --| p_usage_uom_class OUT mtl_units_of_measure.uom_class%TYPE |
3251: --| |
3252: --| RETURNS |
3253: --| Return UOM class |

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

3246: --| This procedure returns the UOM class for the UOM code |
3247: --| |
3248: --| PARAMETERS |
3249: --| p_usage_uom IN mtl_units_of_measure.uom_code%TYPE UOM Code |
3250: --| p_usage_uom_class OUT mtl_units_of_measure.uom_class%TYPE |
3251: --| |
3252: --| RETURNS |
3253: --| Return UOM class |
3254: --| |

Line 3262: p_usage_uom IN mtl_units_of_measure.uom_code%TYPE,

3258: --+==========================================================================+
3259: -- Procedure end of comments
3260:
3261: PROCEDURE validate_usage_uom (
3262: p_usage_uom IN mtl_units_of_measure.uom_code%TYPE,
3263: p_usage_uom_class OUT NOCOPY mtl_units_of_measure.uom_class%TYPE
3264: ) IS
3265:
3266: CURSOR cur_uom IS

Line 3263: p_usage_uom_class OUT NOCOPY mtl_units_of_measure.uom_class%TYPE

3259: -- Procedure end of comments
3260:
3261: PROCEDURE validate_usage_uom (
3262: p_usage_uom IN mtl_units_of_measure.uom_code%TYPE,
3263: p_usage_uom_class OUT NOCOPY mtl_units_of_measure.uom_class%TYPE
3264: ) IS
3265:
3266: CURSOR cur_uom IS
3267: SELECT uom_class

Line 3268: FROM mtl_units_of_measure

3264: ) IS
3265:
3266: CURSOR cur_uom IS
3267: SELECT uom_class
3268: FROM mtl_units_of_measure
3269: WHERE uom_code = p_usage_uom;
3270:
3271: BEGIN
3272: OPEN cur_uom;

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

3283: PROCEDURE Validate_Resource
3284: (
3285: p_Resources IN cr_rsrc_mst.Resources%TYPE
3286: , x_resource_uom OUT NOCOPY cr_rsrc_mst.std_usage_uom%TYPE
3287: , x_resource_uom_class OUT NOCOPY mtl_units_of_measure.uom_class%TYPE
3288: )
3289: IS
3290: CURSOR Cur_resources
3291: IS

Line 3295: mtl_units_of_measure uom, cr_rsrc_mst rm

3291: IS
3292: SELECT
3293: rm.std_usage_uom, uom.uom_class
3294: FROM
3295: mtl_units_of_measure uom, cr_rsrc_mst rm
3296: WHERE
3297: rm.resources = p_Resources
3298: AND uom.uom_code = rm.std_usage_uom
3299: AND rm.delete_mark = 0;