APPS.GMF_VALIDATIONS_PVT dependencies on MTL_LOT_NUMBERS

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

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

Line 2781: p_lot_number IN mtl_lot_numbers.lot_number%TYPE,

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

Line 2795: FROM mtl_lot_numbers

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

Line 2804: l_lot_number mtl_lot_numbers.lot_number%TYPE;

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