1 PACKAGE WIP_EAM_GENEALOGY_PVT AUTHID CURRENT_USER AS
2 /* $Header: WIPVEGNS.pls 120.0.12010000.2 2008/12/23 10:17:31 smrsharm ship $*/
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 Procedure Get_LocatorControl_Code(
57 p_org IN NUMBER,
58 p_subinv IN VARCHAR2,
59 p_item_id IN NUMBER,
60 p_action IN NUMBER,
61 x_locator_ctrl OUT NOCOPY NUMBER,
62 x_error_flag OUT NOCOPY NUMBER, -- returns 0 if no error ,1 if any error .
63 x_error_mssg OUT NOCOPY VARCHAR2) ;
64
65 Function Dynamic_Entry_Not_Allowed(
66 p_restrict_flag IN NUMBER,
67 p_neg_flag IN NUMBER,
68 p_action IN NUMBER) return Boolean ;
69
70
71 END WIP_EAM_GENEALOGY_PVT;