DBA Data[Home] [Help]

APPS.WSH_DELIVERY_VALIDATIONS dependencies on INV_VALIDATE

Line 2862: l_org INV_VALIDATE.org;

2858:
2859: l_prefix VARCHAR2(10);
2860: l_result BOOLEAN;
2861: l_valid_serial_range NUMBER;
2862: l_org INV_VALIDATE.org;
2863: l_item INV_VALIDATE.item;
2864: l_lot INV_VALIDATE.lot;
2865: l_locator INV_VALIDATE.locator;
2866: l_sub INV_VALIDATE.sub;

Line 2863: l_item INV_VALIDATE.item;

2859: l_prefix VARCHAR2(10);
2860: l_result BOOLEAN;
2861: l_valid_serial_range NUMBER;
2862: l_org INV_VALIDATE.org;
2863: l_item INV_VALIDATE.item;
2864: l_lot INV_VALIDATE.lot;
2865: l_locator INV_VALIDATE.locator;
2866: l_sub INV_VALIDATE.sub;
2867:

Line 2864: l_lot INV_VALIDATE.lot;

2860: l_result BOOLEAN;
2861: l_valid_serial_range NUMBER;
2862: l_org INV_VALIDATE.org;
2863: l_item INV_VALIDATE.item;
2864: l_lot INV_VALIDATE.lot;
2865: l_locator INV_VALIDATE.locator;
2866: l_sub INV_VALIDATE.sub;
2867:
2868: p_fm_serial INV_VALIDATE.SERIAL_NUMBER_TBL;

Line 2865: l_locator INV_VALIDATE.locator;

2861: l_valid_serial_range NUMBER;
2862: l_org INV_VALIDATE.org;
2863: l_item INV_VALIDATE.item;
2864: l_lot INV_VALIDATE.lot;
2865: l_locator INV_VALIDATE.locator;
2866: l_sub INV_VALIDATE.sub;
2867:
2868: p_fm_serial INV_VALIDATE.SERIAL_NUMBER_TBL;
2869: p_to_serial INV_VALIDATE.SERIAL_NUMBER_TBL;

Line 2866: l_sub INV_VALIDATE.sub;

2862: l_org INV_VALIDATE.org;
2863: l_item INV_VALIDATE.item;
2864: l_lot INV_VALIDATE.lot;
2865: l_locator INV_VALIDATE.locator;
2866: l_sub INV_VALIDATE.sub;
2867:
2868: p_fm_serial INV_VALIDATE.SERIAL_NUMBER_TBL;
2869: p_to_serial INV_VALIDATE.SERIAL_NUMBER_TBL;
2870: x_errored_serials INV_VALIDATE.SERIAL_NUMBER_TBL;

Line 2868: p_fm_serial INV_VALIDATE.SERIAL_NUMBER_TBL;

2864: l_lot INV_VALIDATE.lot;
2865: l_locator INV_VALIDATE.locator;
2866: l_sub INV_VALIDATE.sub;
2867:
2868: p_fm_serial INV_VALIDATE.SERIAL_NUMBER_TBL;
2869: p_to_serial INV_VALIDATE.SERIAL_NUMBER_TBL;
2870: x_errored_serials INV_VALIDATE.SERIAL_NUMBER_TBL;
2871:
2872: /************************MATERIAL STATUS CONTROL ********/

Line 2869: p_to_serial INV_VALIDATE.SERIAL_NUMBER_TBL;

2865: l_locator INV_VALIDATE.locator;
2866: l_sub INV_VALIDATE.sub;
2867:
2868: p_fm_serial INV_VALIDATE.SERIAL_NUMBER_TBL;
2869: p_to_serial INV_VALIDATE.SERIAL_NUMBER_TBL;
2870: x_errored_serials INV_VALIDATE.SERIAL_NUMBER_TBL;
2871:
2872: /************************MATERIAL STATUS CONTROL ********/
2873:

Line 2870: x_errored_serials INV_VALIDATE.SERIAL_NUMBER_TBL;

2866: l_sub INV_VALIDATE.sub;
2867:
2868: p_fm_serial INV_VALIDATE.SERIAL_NUMBER_TBL;
2869: p_to_serial INV_VALIDATE.SERIAL_NUMBER_TBL;
2870: x_errored_serials INV_VALIDATE.SERIAL_NUMBER_TBL;
2871:
2872: /************************MATERIAL STATUS CONTROL ********/
2873:
2874: -- 11728970: Cursor to Get the LPN -id

Line 3193: l_valid_serial_range := INV_VALIDATE.validate_serial_range(

3189: l_sub.secondary_inventory_name := l_line_inv_rec.subinventory;
3190: l_lot.lot_number := l_line_inv_rec.lot_number;
3191: l_locator.inventory_location_id := l_line_inv_rec.locator_id;
3192:
3193: l_valid_serial_range := INV_VALIDATE.validate_serial_range(
3194: p_fm_serial => p_fm_serial,
3195: p_to_serial => p_to_serial,
3196: p_org => l_org,
3197: p_item => l_item ,

Line 3222: WSH_DELIVERY_DETAILS_INV.Validate_Serial( p_serial_number => l_line_inv_rec.serial_number,

3218: return;
3219: END IF;
3220:
3221: ELSE
3222: WSH_DELIVERY_DETAILS_INV.Validate_Serial( p_serial_number => l_line_inv_rec.serial_number,
3223: p_lot_number => l_line_inv_rec.lot_number,
3224: p_organization_id => l_line_inv_rec.organization_id ,
3225: p_inventory_item_id => l_line_inv_rec.inventory_item_id ,
3226: p_subinventory => l_line_inv_rec.subinventory ,