DBA Data[Home] [Help]

PACKAGE: APPS.WIP_EAM_GENEALOGY_PVT

Source


1 PACKAGE WIP_EAM_GENEALOGY_PVT AUTHID CURRENT_USER AS
2 /* $Header: WIPVEGNS.pls 115.3 2003/01/23 22:55:53 hkarmach noship $*/
3 
4 /*--------------------------------------------------------------------------+
5  | This package contains the Genealogy specs for rebuilds. These APIs will  |
6  | be used to call the transaction API to do a miscellaneous transaction    |
7  | before calling the genealogy API                                         |
8  | History:                                                                 |
9  | July 10, 2000       hkarmach         Created package spec.               |
10  +--------------------------------------------------------------------------*/
11 
12 PROCEDURE create_eam_genealogy(
13                         p_api_version              IN  NUMBER,
14                         p_init_msg_list            IN  VARCHAR2 := FND_API.G_FALSE,
15                         p_commit                   IN  VARCHAR2 := FND_API.G_FALSE,
16                         p_validation_level         IN  NUMBER   := FND_API.G_VALID_LEVEL_FULL,
17                         p_subinventory             IN  VARCHAR2 := NULL,
18                         p_locator_id               IN  NUMBER   := NULL,
19                         p_object_id                IN  number   := null,
20                         p_serial_number            IN  VARCHAR2 := NULL,
21                         p_organization_id          IN  NUMBER   := NULL,
22                         p_inventory_item_id        IN  NUMBER   := NULL,
23                         p_parent_object_id         IN  NUMBER   := NULL,
24                         p_parent_serial_number     IN  VARCHAR2 := NULL,
25                         p_parent_inventory_item_id IN  NUMBER   := NULL,
26                         p_parent_organization_id   IN  NUMBER   := NULL,
27                         p_start_date_active        IN  DATE     := SYSDATE,
28                         p_end_date_active          IN  DATE     := NULL,
29 			p_origin_txn_id                 IN  NUMBER   := NULL,
30 			p_update_txn_id                 IN  NUMBER   := NULL,
31                         p_from_eam                 IN  VARCHAR2 := NULL,
32                         x_msg_count                OUT NOCOPY NUMBER,
33                         x_msg_data                 OUT NOCOPY VARCHAR2,
34                         x_return_status            OUT NOCOPY VARCHAR2);
35 
36 PROCEDURE update_eam_genealogy(
37                         p_api_version              IN  NUMBER,
38                         p_init_msg_list            IN  VARCHAR2 := FND_API.G_FALSE,
39                         p_commit                   IN  VARCHAR2 := FND_API.G_FALSE,
40                         p_validation_level         IN  NUMBER   := FND_API.G_VALID_LEVEL_FULL,
41                         p_object_type              IN  NUMBER,
42                         p_object_id                IN  NUMBER   := NULL,
43                         p_serial_number            IN  VARCHAR2 := NULL,
44                         p_inventory_item_id        IN  NUMBER   := NULL,
45                         p_organization_id          IN  NUMBER   := NULL,
46                         p_subinventory             IN  VARCHAR2 := NULL,
47                         p_locator_id               IN  NUMBER   := NULL,
48                         p_genealogy_origin         IN  NUMBER   := NULL,
49                         p_genealogy_type           IN  NUMBER   := NULL,
50                         p_end_date_active          IN  DATE     := NULL,
51                         p_from_eam                 IN  VARCHAR2 := NULL,
52                         x_return_status            OUT NOCOPY VARCHAR2,
53                         x_msg_count                OUT NOCOPY NUMBER,
54                         x_msg_data                 OUT NOCOPY VARCHAR2);
55 
56 END WIP_EAM_GENEALOGY_PVT;