1 PACKAGE eam_wolcosting_pub AUTHID CURRENT_USER AS
2 /* $Header: EAMWWOHS.pls 115.4 2004/04/02 03:44:07 samjain noship $ */
3 -- Start of comments
4 -- API name : insert_into_snapshot_pub
5 -- Type : Private.
6 -- Function : Insert the hierarchy into the CST_EAM_HIERARCHY_SNAPSHOT table.
7 -- Pre-reqs : None.
8 -- Parameters :
9 -- IN p_api_version IN NUMBER
10 -- p_init_msg_list VARCHAR2:= FND_API.G_FALSE
11 -- p_commit VARCHAR2:= FND_API.G_FALSE
12 -- p_validation_level NUMBER:= FND_API.G_VALID_LEVEL_FULL
13 -- p_wip_entity_id NUMBER
14 -- p_object_type NUMBER
15 -- p_parent_object_type NUMBER
16 -- p_org_id NUMBER
17 -- p_relationship_type NUMBER := 3
18 -- OUT x_group_id NOCOPY NUMBER,
19 -- x_return_status NOCOPY VARCHAR2
20 -- x_msg_count NOCOPY NUMBER
21 -- x_msg_data NOCOPY VARCHAR2
22 -- Notes : None
23 --
24 -- End of comments
25 --Bug3544656: Added a parameter to pass the relationship type
26 PROCEDURE insert_into_snapshot_pub(
27 p_api_version IN NUMBER ,
28 p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
29 p_commit IN VARCHAR2:= FND_API.G_FALSE ,
30 p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
31 p_wip_entity_id IN NUMBER,
32 p_object_type IN NUMBER,
33 p_parent_object_type IN NUMBER,
34 x_group_id OUT NOCOPY NUMBER,
35 x_return_status OUT NOCOPY VARCHAR2 ,
36 x_msg_count OUT NOCOPY NUMBER ,
37 x_msg_data OUT NOCOPY VARCHAR2 ,
38 p_org_id IN NUMBER ,
39 p_relationship_type IN NUMBER := 3
40 );
41
42 END eam_wolcosting_pub;