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_SYSTEM_ITEMS_B

Line 2645: * p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE*

2641: * DESCRIPTION *
2642: * This function validates that the Inventory Item Id exists *
2643: * *
2644: * PARAMETERS *
2645: * p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE*
2646: * p_organization_id IN mtl_organizations.organization_id%TYPE *
2647: * *
2648: * RETURNS *
2649: * TRUE - If Item Exists *

Line 2657: p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE,

2653: * 20-Oct-2005 Anand Thiyagarajan - Created *
2654: ***************************************************************************************/
2655: FUNCTION Validate_inventory_item_id
2656: (
2657: p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE,
2658: p_organization_id IN mtl_organizations.organization_id%TYPE
2659: )
2660: RETURN BOOLEAN
2661: IS

Line 2670: FROM mtl_system_items_b

2666:
2667: CURSOR Cur_item
2668: IS
2669: SELECT inventory_item_id
2670: FROM mtl_system_items_b
2671: WHERE inventory_item_id = p_inventory_item_id
2672: AND organization_id = p_organization_id;
2673:
2674: /******************

Line 2678: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;

2674: /******************
2675: * Local Variables *
2676: ******************/
2677:
2678: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
2679:
2680: BEGIN
2681: OPEN Cur_item;
2682: FETCH Cur_item INTO l_inventory_item_id;

Line 2739: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;

2735: /******************
2736: * Local Variables *
2737: ******************/
2738:
2739: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
2740:
2741: BEGIN
2742: OPEN Cur_item;
2743: FETCH Cur_item INTO l_inventory_item_id;

Line 2768: * p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE*

2764: * DESCRIPTION *
2765: * This function validates that the Lot Number exists *
2766: * *
2767: * PARAMETERS *
2768: * p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE*
2769: * p_organization_id IN mtl_organizations.organization_id%TYPE *
2770: * p_lot_number in mtl_lot_numbers.lot_number%TYPE *
2771: * *
2772: * RETURNS *

Line 2782: p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE,

2778: ***************************************************************************************/
2779: FUNCTION Validate_Lot_Number
2780: (
2781: p_lot_number IN mtl_lot_numbers.lot_number%TYPE,
2782: p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE,
2783: p_organization_id IN mtl_organizations.organization_id%TYPE
2784: )
2785: RETURN BOOLEAN
2786: IS

Line 3204: p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE,

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
3208:

Line 3205: p_organization_id IN mtl_system_items_b.organization_id%TYPE

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
3208:
3209: CURSOR Cur_uom

Line 3212: FROM mtl_system_items_b a,

3208:
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

Line 3254: --| p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE, |

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: --| |
3258: --| RETURNS |

Line 3255: --| p_organization_id IN mtl_system_items_b.organization_id%TYPE, |

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: --| |
3258: --| RETURNS |
3259: --| TRUE - If UOM code is valid one |

Line 3270: p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE,

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
3274: IS

Line 3271: p_organization_id IN mtl_system_items_b.organization_id%TYPE,

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
3274: IS
3275:

Line 3276: l_primary_uom_code mtl_system_items_b.primary_uom_code%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;
3277: l_conv_qty cm_adjs_dtl.adjust_qty%TYPE;
3278:
3279: BEGIN
3280:

Line 3283: FROM mtl_system_items_b a

3279: BEGIN
3280:
3281: SELECT a.primary_uom_code
3282: INTO l_primary_uom_code
3283: FROM mtl_system_items_b a
3284: WHERE a.inventory_item_id = p_inventory_item_id
3285: AND a.organization_id = p_organization_id;
3286:
3287: l_conv_qty := inv_convert.inv_um_convert(p_inventory_item_id,