DBA Data[Home] [Help]

PACKAGE: APPS.EAM_REBUILD_GENEALOGY

Source


1 PACKAGE EAM_REBUILD_GENEALOGY AUTHID CURRENT_USER AS
2 /* $Header: EAMRBGNS.pls 115.3 2002/11/20 19:28:17 aan noship $*/
3 
4 PROCEDURE create_rebuild_genealogy(
5      p_api_version                   IN  NUMBER
6  ,   p_init_msg_list	             IN  VARCHAR2 := FND_API.G_FALSE
7  ,   p_commit		                 IN  VARCHAR2 := FND_API.G_FALSE
8  ,   p_validation_level	             IN  NUMBER   := FND_API.G_VALID_LEVEL_FULL
9  ,   p_subinventory                  IN  VARCHAR2 := NULL
10  ,   p_locator_id		     IN NUMBER  := NULL
11  ,   p_object_id                     IN  number := null
12  ,   p_serial_number                 IN  VARCHAR2 := NULL
13  ,   p_organization_id                        IN  NUMBER := NULL
14  ,   p_inventory_item_id               IN NUMBER := NULL
15  ,   p_parent_object_id	             IN  NUMBER   := NULL
16  ,   p_parent_serial_number          IN  VARCHAR2 := NULL
17  ,   p_parent_inventory_item_id	     IN  NUMBER   := NULL
18  ,   p_parent_organization_id		         IN  NUMBER   := NULL
19  ,   p_start_date_active             IN  DATE     := sysdate
20  ,   p_end_date_active               IN  DATE     := NULL
21  ,   x_msg_count                     OUT NOCOPY NUMBER
22  ,   x_msg_data                      OUT NOCOPY VARCHAR2
23  ,   x_return_status                 OUT NOCOPY VARCHAR2);
24 
25   PROCEDURE update_rebuild_genealogy(
26      p_api_version                   IN  NUMBER
27  ,   p_init_msg_list                 IN  VARCHAR2 := FND_API.G_FALSE
28  ,   p_commit                        IN  VARCHAR2 := FND_API.G_FALSE
29  ,   p_validation_level              IN  NUMBER   := FND_API.G_VALID_LEVEL_FULL
30  ,   p_object_type                   IN  NUMBER
31  ,   p_object_id                     IN  NUMBER   := NULL
32  ,   p_serial_number                 IN  VARCHAR2 := NULL
33  ,   p_inventory_item_id             IN  NUMBER   := NULL
34  ,   p_organization_id                        IN  NUMBER   := NULL
35  ,   p_subinventory                  IN VARCHAR2  := NULL
36  ,   p_locator_id		     IN NUMBER  := NULL
37  ,   p_genealogy_origin              IN  NUMBER   := NULL
38  ,   p_genealogy_type                IN  NUMBER   := NULL
39  ,   p_end_date_active               IN  DATE     := NULL
40  ,   x_return_status                 OUT NOCOPY VARCHAR2
41  ,   x_msg_count                     OUT NOCOPY NUMBER
42  ,   x_msg_data                      OUT NOCOPY VARCHAR2);
43 
44  end eam_rebuild_genealogy;
45 
46