APPS.GMF_VALIDATIONS_PVT dependencies on MTL_LOT_NUMBERS

Line 2768: * p_lot_number in mtl_lot_numbers.lot_number%TYPE *

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 *
2771: * TRUE - If Lot Exists *
2772: * FALSE - If Lot Doesnt Exist *

Line 2779: p_lot_number IN mtl_lot_numbers.lot_number%TYPE,

2775: * 20-Oct-2005 Anand Thiyagarajan - Created *
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

Line 2793: FROM mtl_lot_numbers

2789:
2790: CURSOR Cur_lot_number
2791: IS
2792: SELECT lot_number
2793: FROM mtl_lot_numbers
2794: WHERE inventory_item_id = p_inventory_item_id
2795: AND organization_id = p_organization_id
2796: AND lot_number = p_lot_number;
2797:

Line 2802: l_lot_number mtl_lot_numbers.lot_number%TYPE;

2798: /******************
2799: * Local Variables *
2800: ******************/
2801:
2802: l_lot_number mtl_lot_numbers.lot_number%TYPE;
2803:
2804: BEGIN
2805: OPEN Cur_lot_number;
2806: FETCH Cur_lot_number INTO l_lot_number;