DBA Data[Home] [Help]

APPS.GMF_VALIDATIONS_PVT dependencies on CM_ADJS_DTL

Line 3253: --| p_adjust_uom IN cm_adjs_dtl.adjust_qty_um%TYPE, |

3249: --| This function validates that the UOM conversion exists |
3250: --| |
3251: --| |
3252: --| PARAMETERS |
3253: --| p_adjust_uom IN cm_adjs_dtl.adjust_qty_um%TYPE, |
3254: --| p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE, |
3255: --| p_organization_id IN mtl_system_items_b.organization_id%TYPE, |
3256: --| p_adjust_qty IN cm_adjs_dtl.adjust_qty%TYPE |
3257: --| |

Line 3256: --| p_adjust_qty IN cm_adjs_dtl.adjust_qty%TYPE |

3252: --| PARAMETERS |
3253: --| p_adjust_uom IN cm_adjs_dtl.adjust_qty_um%TYPE, |
3254: --| p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE, |
3255: --| p_organization_id IN mtl_system_items_b.organization_id%TYPE, |
3256: --| p_adjust_qty IN cm_adjs_dtl.adjust_qty%TYPE |
3257: --| |
3258: --| RETURNS |
3259: --| TRUE - If UOM code is valid one |
3260: --| FALSE - If UOM code is an invalid one |

Line 3269: p_adjust_uom IN cm_adjs_dtl.adjust_qty_um%TYPE,

3265: --+==========================================================================+
3266: -- Func end of comments
3267: FUNCTION Validate_Uom_Conv
3268: (
3269: p_adjust_uom IN cm_adjs_dtl.adjust_qty_um%TYPE,
3270: p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE,
3271: p_organization_id IN mtl_system_items_b.organization_id%TYPE,
3272: p_adjust_qty IN cm_adjs_dtl.adjust_qty%TYPE
3273: ) RETURN BOOLEAN

Line 3272: p_adjust_qty IN cm_adjs_dtl.adjust_qty%TYPE

3268: (
3269: p_adjust_uom IN cm_adjs_dtl.adjust_qty_um%TYPE,
3270: p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE,
3271: p_organization_id IN mtl_system_items_b.organization_id%TYPE,
3272: p_adjust_qty IN cm_adjs_dtl.adjust_qty%TYPE
3273: ) RETURN BOOLEAN
3274: IS
3275:
3276: l_primary_uom_code mtl_system_items_b.primary_uom_code%TYPE;

Line 3277: l_conv_qty cm_adjs_dtl.adjust_qty%TYPE;

3273: ) RETURN BOOLEAN
3274: IS
3275:
3276: l_primary_uom_code mtl_system_items_b.primary_uom_code%TYPE;
3277: l_conv_qty cm_adjs_dtl.adjust_qty%TYPE;
3278:
3279: BEGIN
3280:
3281: SELECT a.primary_uom_code