516: --End of fix for Bug 4003683
517:
518: PROCEDURE insert_range_serial
519: (p_api_version IN NUMBER,
520: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
521: p_commit IN VARCHAR2 := FND_API.G_FALSE,
522: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
523: p_inventory_item_id IN NUMBER,
524: p_organization_id IN NUMBER,
517:
518: PROCEDURE insert_range_serial
519: (p_api_version IN NUMBER,
520: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
521: p_commit IN VARCHAR2 := FND_API.G_FALSE,
522: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
523: p_inventory_item_id IN NUMBER,
524: p_organization_id IN NUMBER,
525: p_from_serial_number IN VARCHAR2,
518: PROCEDURE insert_range_serial
519: (p_api_version IN NUMBER,
520: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
521: p_commit IN VARCHAR2 := FND_API.G_FALSE,
522: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
523: p_inventory_item_id IN NUMBER,
524: p_organization_id IN NUMBER,
525: p_from_serial_number IN VARCHAR2,
526: p_to_serial_number IN VARCHAR2,
547: -- This api updates the current_status for a range of serials
548:
549: PROCEDURE update_serial_status
550: (p_api_version IN NUMBER,
551: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
552: p_commit IN VARCHAR2 := FND_API.G_FALSE,
553: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
554: p_inventory_item_id IN NUMBER,
555: p_organization_id IN NUMBER,
548:
549: PROCEDURE update_serial_status
550: (p_api_version IN NUMBER,
551: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
552: p_commit IN VARCHAR2 := FND_API.G_FALSE,
553: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
554: p_inventory_item_id IN NUMBER,
555: p_organization_id IN NUMBER,
556: p_from_serial_number IN VARCHAR2,
549: PROCEDURE update_serial_status
550: (p_api_version IN NUMBER,
551: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
552: p_commit IN VARCHAR2 := FND_API.G_FALSE,
553: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
554: p_inventory_item_id IN NUMBER,
555: p_organization_id IN NUMBER,
556: p_from_serial_number IN VARCHAR2,
557: p_to_serial_number IN VARCHAR2,
580: -- transaction exception rollback
581:
582: PROCEDURE insert_dynamic_lot
583: (p_api_version IN NUMBER,
584: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
585: p_commit IN VARCHAR2 := FND_API.G_FALSE,
586: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
587: p_inventory_item_id IN NUMBER,
588: p_organization_id IN NUMBER,
581:
582: PROCEDURE insert_dynamic_lot
583: (p_api_version IN NUMBER,
584: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
585: p_commit IN VARCHAR2 := FND_API.G_FALSE,
586: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
587: p_inventory_item_id IN NUMBER,
588: p_organization_id IN NUMBER,
589: p_lot_number IN VARCHAR2,
582: PROCEDURE insert_dynamic_lot
583: (p_api_version IN NUMBER,
584: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
585: p_commit IN VARCHAR2 := FND_API.G_FALSE,
586: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
587: p_inventory_item_id IN NUMBER,
588: p_organization_id IN NUMBER,
589: p_lot_number IN VARCHAR2,
590: p_expiration_date IN OUT NOCOPY DATE,
602: );
603:
604: PROCEDURE process_lot
605: (p_api_version IN NUMBER,
606: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
607: p_commit IN VARCHAR2 := FND_API.G_FALSE,
608: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
609: p_inventory_item_id IN NUMBER,
610: p_organization_id IN NUMBER,
603:
604: PROCEDURE process_lot
605: (p_api_version IN NUMBER,
606: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
607: p_commit IN VARCHAR2 := FND_API.G_FALSE,
608: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
609: p_inventory_item_id IN NUMBER,
610: p_organization_id IN NUMBER,
611: p_lot_number IN VARCHAR2,
604: PROCEDURE process_lot
605: (p_api_version IN NUMBER,
606: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
607: p_commit IN VARCHAR2 := FND_API.G_FALSE,
608: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
609: p_inventory_item_id IN NUMBER,
610: p_organization_id IN NUMBER,
611: p_lot_number IN VARCHAR2,
612: p_expiration_date IN OUT NOCOPY DATE,
716:
717: -- MANEESH - BEGIN CHANGES - FOR CROSS REFERENCE ITEM CREATION
718:
719: PROCEDURE create_cross_reference(p_api_version IN NUMBER,
720: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
721: p_commit IN VARCHAR2 := fnd_api.g_false,
722: p_organization_id IN NUMBER,
723: p_inventory_item_id IN NUMBER,
724: p_cross_reference IN VARCHAR2,
717: -- MANEESH - BEGIN CHANGES - FOR CROSS REFERENCE ITEM CREATION
718:
719: PROCEDURE create_cross_reference(p_api_version IN NUMBER,
720: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
721: p_commit IN VARCHAR2 := fnd_api.g_false,
722: p_organization_id IN NUMBER,
723: p_inventory_item_id IN NUMBER,
724: p_cross_reference IN VARCHAR2,
725: p_cross_reference_type IN VARCHAR2,