APPS.GMF_VALIDATIONS_PVT dependencies on MTL_SYSTEM_ITEMS_B

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

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

Line 2655: p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE,

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

Line 2668: FROM mtl_system_items_b

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

Line 2676: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;

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

Line 2737: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;

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

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

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

Line 2780: p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE,

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

Line 3202: p_inventory_item_id IN mtl_system_items_b.inventory_item_id%TYPE,

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

Line 3203: p_organization_id IN mtl_system_items_b.organization_id%TYPE

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
3206:
3207: CURSOR Cur_uom

Line 3210: FROM mtl_system_items_b a,

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