DBA Data[Home] [Help]

PACKAGE: APPS.EAM_WOLCOSTING_PUB

Source


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;