DBA Data[Home] [Help]

APPS.WSH_DELIVERY_VALIDATIONS dependencies on INV_VALIDATE

Line 2822: l_org INV_VALIDATE.org;

2818:
2819: l_prefix VARCHAR2(10);
2820: l_result BOOLEAN;
2821: l_valid_serial_range NUMBER;
2822: l_org INV_VALIDATE.org;
2823: l_item INV_VALIDATE.item;
2824: l_lot INV_VALIDATE.lot;
2825: l_locator INV_VALIDATE.locator;
2826: l_sub INV_VALIDATE.sub;

Line 2823: l_item INV_VALIDATE.item;

2819: l_prefix VARCHAR2(10);
2820: l_result BOOLEAN;
2821: l_valid_serial_range NUMBER;
2822: l_org INV_VALIDATE.org;
2823: l_item INV_VALIDATE.item;
2824: l_lot INV_VALIDATE.lot;
2825: l_locator INV_VALIDATE.locator;
2826: l_sub INV_VALIDATE.sub;
2827:

Line 2824: l_lot INV_VALIDATE.lot;

2820: l_result BOOLEAN;
2821: l_valid_serial_range NUMBER;
2822: l_org INV_VALIDATE.org;
2823: l_item INV_VALIDATE.item;
2824: l_lot INV_VALIDATE.lot;
2825: l_locator INV_VALIDATE.locator;
2826: l_sub INV_VALIDATE.sub;
2827:
2828: p_fm_serial INV_VALIDATE.SERIAL_NUMBER_TBL;

Line 2825: l_locator INV_VALIDATE.locator;

2821: l_valid_serial_range NUMBER;
2822: l_org INV_VALIDATE.org;
2823: l_item INV_VALIDATE.item;
2824: l_lot INV_VALIDATE.lot;
2825: l_locator INV_VALIDATE.locator;
2826: l_sub INV_VALIDATE.sub;
2827:
2828: p_fm_serial INV_VALIDATE.SERIAL_NUMBER_TBL;
2829: p_to_serial INV_VALIDATE.SERIAL_NUMBER_TBL;

Line 2826: l_sub INV_VALIDATE.sub;

2822: l_org INV_VALIDATE.org;
2823: l_item INV_VALIDATE.item;
2824: l_lot INV_VALIDATE.lot;
2825: l_locator INV_VALIDATE.locator;
2826: l_sub INV_VALIDATE.sub;
2827:
2828: p_fm_serial INV_VALIDATE.SERIAL_NUMBER_TBL;
2829: p_to_serial INV_VALIDATE.SERIAL_NUMBER_TBL;
2830: x_errored_serials INV_VALIDATE.SERIAL_NUMBER_TBL;

Line 2828: p_fm_serial INV_VALIDATE.SERIAL_NUMBER_TBL;

2824: l_lot INV_VALIDATE.lot;
2825: l_locator INV_VALIDATE.locator;
2826: l_sub INV_VALIDATE.sub;
2827:
2828: p_fm_serial INV_VALIDATE.SERIAL_NUMBER_TBL;
2829: p_to_serial INV_VALIDATE.SERIAL_NUMBER_TBL;
2830: x_errored_serials INV_VALIDATE.SERIAL_NUMBER_TBL;
2831:
2832: /************************MATERIAL STATUS CONTROL ********/

Line 2829: p_to_serial INV_VALIDATE.SERIAL_NUMBER_TBL;

2825: l_locator INV_VALIDATE.locator;
2826: l_sub INV_VALIDATE.sub;
2827:
2828: p_fm_serial INV_VALIDATE.SERIAL_NUMBER_TBL;
2829: p_to_serial INV_VALIDATE.SERIAL_NUMBER_TBL;
2830: x_errored_serials INV_VALIDATE.SERIAL_NUMBER_TBL;
2831:
2832: /************************MATERIAL STATUS CONTROL ********/
2833:

Line 2830: x_errored_serials INV_VALIDATE.SERIAL_NUMBER_TBL;

2826: l_sub INV_VALIDATE.sub;
2827:
2828: p_fm_serial INV_VALIDATE.SERIAL_NUMBER_TBL;
2829: p_to_serial INV_VALIDATE.SERIAL_NUMBER_TBL;
2830: x_errored_serials INV_VALIDATE.SERIAL_NUMBER_TBL;
2831:
2832: /************************MATERIAL STATUS CONTROL ********/
2833:
2834: l_line_inv_rec wsh_delivery_details_inv.line_inv_info;

Line 3119: l_valid_serial_range := INV_VALIDATE.validate_serial_range(

3115: l_sub.secondary_inventory_name := l_line_inv_rec.subinventory;
3116: l_lot.lot_number := l_line_inv_rec.lot_number;
3117: l_locator.inventory_location_id := l_line_inv_rec.locator_id;
3118:
3119: l_valid_serial_range := INV_VALIDATE.validate_serial_range(
3120: p_fm_serial => p_fm_serial,
3121: p_to_serial => p_to_serial,
3122: p_org => l_org,
3123: p_item => l_item ,

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

3144: return;
3145: END IF;
3146:
3147: ELSE
3148: WSH_DELIVERY_DETAILS_INV.Validate_Serial( p_serial_number => l_line_inv_rec.serial_number,
3149: p_lot_number => l_line_inv_rec.lot_number,
3150: p_organization_id => l_line_inv_rec.organization_id ,
3151: p_inventory_item_id => l_line_inv_rec.inventory_item_id ,
3152: p_subinventory => l_line_inv_rec.subinventory ,