[Home] [Help]
PACKAGE: APPS.IEM_PARAMETERS_PVT
Source
1 PACKAGE IEM_PARAMETERS_PVT AUTHID CURRENT_USER as
2 /* $Header: iemvpars.pls 115.4 2002/12/04 01:23:00 chtang noship $ */
3
4 -- Start of Comments
5 -- API name : select_profile
6 -- Type : Private
7 -- Function : This procedure retrieve FND profile
8 -- Pre-reqs : None.
9 -- Parameters :
10 -- IN
11 -- p_api_version_number IN NUMBER Required
12 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
13 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
14 -- p_profile_name IN VARCHAR2,
15 -- x_profile_value OUT VARCHAR2,
16 -- OUT
17 -- x_return_status OUT VARCHAR2
18 -- x_msg_count OUT NUMBER
19 -- x_msg_data OUT VARCHAR2
20 --
21 -- Version : 1.0
22 -- Notes :
23 --
24 -- End of comments
25 -- **********************************************************
26 PROCEDURE select_profile (p_api_version_number IN NUMBER,
27 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
28 p_commit IN VARCHAR2 := FND_API.G_FALSE,
29 p_profile_name IN VARCHAR2,
30 x_profile_value OUT NOCOPY VARCHAR2,
31 x_return_status OUT NOCOPY VARCHAR2,
32 x_msg_count OUT NOCOPY NUMBER,
33 x_msg_data OUT NOCOPY VARCHAR2
34 ) ;
35
36 -- Start of Comments
37 -- API name : update_profile
38 -- Type : Private
39 -- Function : This procedure updates FND profile
40 -- Pre-reqs : None.
41 -- Parameters :
42 -- IN
43 -- p_api_version_number IN NUMBER Required
44 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
45 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
46 -- p_profile_name IN VARCHAR2,
47 -- p_profile_value IN VARCHAR2,
48 -- OUT
49 -- x_return_status OUT VARCHAR2
50 -- x_msg_count OUT NUMBER
51 -- x_msg_data OUT VARCHAR2
52 --
53 -- Version : 1.0
54 -- Notes :
55 --
56 -- End of comments
57 -- **********************************************************
58
59 PROCEDURE update_profile (p_api_version_number IN NUMBER,
60 p_init_msg_list IN VARCHAR2,
61 p_commit IN VARCHAR2,
62 p_profile_name IN VARCHAR2,
63 p_profile_value IN VARCHAR2,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2
67 ) ;
68
69 PROCEDURE update_profile_wrap (p_api_version_number IN NUMBER,
70 p_init_msg_list IN VARCHAR2,
71 p_commit IN VARCHAR2,
72 p_profile_name_tbl IN jtf_varchar2_Table_100,
73 p_profile_value_tbl IN jtf_varchar2_Table_100,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2
77 );
78
79 END IEM_PARAMETERS_PVT ;