484: --End of fix for Bug 4003683
485:
486: PROCEDURE insert_range_serial
487: (p_api_version IN NUMBER,
488: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
489: p_commit IN VARCHAR2 := FND_API.G_FALSE,
490: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
491: p_inventory_item_id IN NUMBER,
492: p_organization_id IN NUMBER,
485:
486: PROCEDURE insert_range_serial
487: (p_api_version IN NUMBER,
488: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
489: p_commit IN VARCHAR2 := FND_API.G_FALSE,
490: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
491: p_inventory_item_id IN NUMBER,
492: p_organization_id IN NUMBER,
493: p_from_serial_number IN VARCHAR2,
486: PROCEDURE insert_range_serial
487: (p_api_version IN NUMBER,
488: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
489: p_commit IN VARCHAR2 := FND_API.G_FALSE,
490: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
491: p_inventory_item_id IN NUMBER,
492: p_organization_id IN NUMBER,
493: p_from_serial_number IN VARCHAR2,
494: p_to_serial_number IN VARCHAR2,
515: -- This api updates the current_status for a range of serials
516:
517: PROCEDURE update_serial_status
518: (p_api_version IN NUMBER,
519: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
520: p_commit IN VARCHAR2 := FND_API.G_FALSE,
521: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
522: p_inventory_item_id IN NUMBER,
523: p_organization_id IN NUMBER,
516:
517: PROCEDURE update_serial_status
518: (p_api_version IN NUMBER,
519: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
520: p_commit IN VARCHAR2 := FND_API.G_FALSE,
521: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
522: p_inventory_item_id IN NUMBER,
523: p_organization_id IN NUMBER,
524: p_from_serial_number IN VARCHAR2,
517: PROCEDURE update_serial_status
518: (p_api_version IN NUMBER,
519: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
520: p_commit IN VARCHAR2 := FND_API.G_FALSE,
521: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
522: p_inventory_item_id IN NUMBER,
523: p_organization_id IN NUMBER,
524: p_from_serial_number IN VARCHAR2,
525: p_to_serial_number IN VARCHAR2,
548: -- transaction exception rollback
549:
550: PROCEDURE insert_dynamic_lot
551: (p_api_version IN NUMBER,
552: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
553: p_commit IN VARCHAR2 := FND_API.G_FALSE,
554: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
555: p_inventory_item_id IN NUMBER,
556: p_organization_id IN NUMBER,
549:
550: PROCEDURE insert_dynamic_lot
551: (p_api_version IN NUMBER,
552: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
553: p_commit IN VARCHAR2 := FND_API.G_FALSE,
554: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
555: p_inventory_item_id IN NUMBER,
556: p_organization_id IN NUMBER,
557: p_lot_number IN VARCHAR2,
550: PROCEDURE insert_dynamic_lot
551: (p_api_version IN NUMBER,
552: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
553: p_commit IN VARCHAR2 := FND_API.G_FALSE,
554: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
555: p_inventory_item_id IN NUMBER,
556: p_organization_id IN NUMBER,
557: p_lot_number IN VARCHAR2,
558: p_expiration_date IN OUT NOCOPY DATE,
567: x_msg_data OUT NOCOPY VARCHAR2);
568:
569: PROCEDURE process_lot
570: (p_api_version IN NUMBER,
571: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
572: p_commit IN VARCHAR2 := FND_API.G_FALSE,
573: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
574: p_inventory_item_id IN NUMBER,
575: p_organization_id IN NUMBER,
568:
569: PROCEDURE process_lot
570: (p_api_version IN NUMBER,
571: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
572: p_commit IN VARCHAR2 := FND_API.G_FALSE,
573: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
574: p_inventory_item_id IN NUMBER,
575: p_organization_id IN NUMBER,
576: p_lot_number IN VARCHAR2,
569: PROCEDURE process_lot
570: (p_api_version IN NUMBER,
571: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
572: p_commit IN VARCHAR2 := FND_API.G_FALSE,
573: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
574: p_inventory_item_id IN NUMBER,
575: p_organization_id IN NUMBER,
576: p_lot_number IN VARCHAR2,
577: p_expiration_date IN OUT NOCOPY DATE,
679:
680: -- MANEESH - BEGIN CHANGES - FOR CROSS REFERENCE ITEM CREATION
681:
682: PROCEDURE create_cross_reference(p_api_version IN NUMBER,
683: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
684: p_commit IN VARCHAR2 := fnd_api.g_false,
685: p_organization_id IN NUMBER,
686: p_inventory_item_id IN NUMBER,
687: p_cross_reference IN VARCHAR2,
680: -- MANEESH - BEGIN CHANGES - FOR CROSS REFERENCE ITEM CREATION
681:
682: PROCEDURE create_cross_reference(p_api_version IN NUMBER,
683: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
684: p_commit IN VARCHAR2 := fnd_api.g_false,
685: p_organization_id IN NUMBER,
686: p_inventory_item_id IN NUMBER,
687: p_cross_reference IN VARCHAR2,
688: p_cross_reference_type IN VARCHAR2,