1 PACKAGE IEM_COMP_RT_STATS_PVT AUTHID CURRENT_USER as
2 /* $Header: iemvcrss.pls 115.3 2002/12/04 02:40:44 chtang noship $ */
3 -- Start of Comments
4 -- API name : create_item
5 -- Type : Private
6 -- Function : This procedure create a record in the table IEM_COMP_RT_STATS
7 -- Pre-reqs : None.
8 -- Parameters :
9 -- IN
10 -- p_api_version_number IN NUMBER Required
11 -- p_init_msg_list IN VARCHAR2
12 -- p_commit IN VARCHAR2
13 -- p_type IN VARCHAR2,
14 -- p_param IN VARCHAR2,
15 -- p_value IN VARCHAR2,
16 --
17 -- OUT
18 -- x_return_status OUT VARCHAR2
19 -- x_msg_count OUT NUMBER
20 -- x_msg_data OUT VARCHAR2
21 --
22 -- Version : 1.0
23 -- Notes :
24 --
25 -- End of comments
26 -- **********************************************************
27
28 PROCEDURE create_item (p_api_version_number IN NUMBER,
29 p_init_msg_list IN VARCHAR2,
30 p_commit IN VARCHAR2,
31 p_type IN VARCHAR2,
32 p_param IN VARCHAR2,
33 p_value IN VARCHAR2,
34 x_return_status OUT NOCOPY VARCHAR2,
35 x_msg_count OUT NOCOPY NUMBER,
36 x_msg_data OUT NOCOPY VARCHAR2
37 );
38
39 PROCEDURE update_item (p_api_version_number IN NUMBER,
40 p_init_msg_list IN VARCHAR2,
41 p_commit IN VARCHAR2,
42 p_comp_rt_stats_id IN NUMBER,
43 p_type IN VARCHAR2,
44 p_param IN VARCHAR2,
45 p_value IN VARCHAR2,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2
49 );
50
51 PROCEDURE delete_item (p_api_version_number IN NUMBER,
52 p_init_msg_list IN VARCHAR2,
53 p_commit IN VARCHAR2,
54 p_comp_rt_stats_id in number,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2
58 );
59
60 PROCEDURE delete_item_for_cache (p_api_version_number IN NUMBER,
61 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
62 p_commit IN VARCHAR2 := FND_API.G_FALSE,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2
66 );
67
68 END IEM_COMP_RT_STATS_PVT;