[Home] [Help]
PACKAGE BODY: APPS.OKC_ROLE_SOURCE_PVT
Source
1 PACKAGE BODY OKC_ROLE_SOURCE_PVT AS
2 /* $Header: OKCCRSCB.pls 120.0 2005/05/26 09:40:35 appldev noship $ */
3
4 l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
6 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ROLE_SOURCES_PVT';
7
8 -- Start of comments
9 --
10 -- Procedure Name : create_role_source
11 -- Description :
12 -- Business Rules :
13 -- Parameters :
14 -- Version : 1.0
15 -- End of comments
16 procedure create_role_source(p_api_version IN NUMBER,
17 p_init_msg_list IN VARCHAR2 ,
18 x_return_status OUT NOCOPY VARCHAR2,
19 x_msg_count OUT NOCOPY NUMBER,
20 x_msg_data OUT NOCOPY VARCHAR2,
21 p_rscv_rec IN rscv_rec_type,
22 x_rscv_rec OUT NOCOPY rscv_rec_type) is
23 begin
24 okc_rsc_pvt.insert_row(p_api_version => p_api_version,
25 p_init_msg_list => p_init_msg_list,
26 x_msg_count => x_msg_count,
27 x_msg_data => x_msg_data,
28 x_return_status => x_return_status,
29 p_rscv_rec => p_rscv_rec,
30 x_rscv_rec => x_rscv_rec);
31 end create_role_source;
32
33 -- Start of comments
34 --
35 -- Procedure Name : update_role_source
36 -- Description :
37 -- Business Rules :
38 -- Parameters :
39 -- Version : 1.0
40 -- End of comments
41 procedure update_role_source(p_api_version IN NUMBER,
42 p_init_msg_list IN VARCHAR2 ,
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 p_rscv_rec IN rscv_rec_type,
47 x_rscv_rec OUT NOCOPY rscv_rec_type) is
48 begin
49 okc_rsc_pvt.update_row(p_api_version => p_api_version,
50 p_init_msg_list => p_init_msg_list,
51 x_msg_count => x_msg_count,
52 x_msg_data => x_msg_data,
53 x_return_status => x_return_status,
54 p_rscv_rec => p_rscv_rec,
55 x_rscv_rec => x_rscv_rec);
56 end update_role_source;
57
58 -- Start of comments
59 --
60 -- Procedure Name : lock_role_source
61 -- Description :
62 -- Business Rules :
63 -- Parameters :
64 -- Version : 1.0
65 -- End of comments
66 procedure lock_role_source(p_api_version IN NUMBER,
67 p_init_msg_list IN VARCHAR2 ,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_msg_count OUT NOCOPY NUMBER,
70 x_msg_data OUT NOCOPY VARCHAR2,
71 p_rscv_rec IN rscv_rec_type) is
72 begin
73 okc_rsc_pvt.lock_row(p_api_version => p_api_version,
74 p_init_msg_list => p_init_msg_list,
75 x_msg_count => x_msg_count,
76 x_msg_data => x_msg_data,
77 x_return_status => x_return_status,
78 p_rscv_rec => p_rscv_rec);
79 end lock_role_source;
80
81 -- Start of comments
82 --
83 -- Procedure Name : validate_role_source
84 -- Description :
85 -- Business Rules :
86 -- Parameters :
87 -- Version : 1.0
88 -- End of comments
89 procedure validate_role_source(p_api_version IN NUMBER,
90 p_init_msg_list IN VARCHAR2 ,
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_msg_count OUT NOCOPY NUMBER,
93 x_msg_data OUT NOCOPY VARCHAR2,
94 p_rscv_rec IN rscv_rec_type) is
95 begin
96 okc_rsc_pvt.validate_row(p_api_version => p_api_version,
97 p_init_msg_list => p_init_msg_list,
98 x_msg_count => x_msg_count,
99 x_msg_data => x_msg_data,
100 x_return_status => x_return_status,
101 p_rscv_rec => p_rscv_rec);
102 end validate_role_source;
103
104 -- Start of comments
105 --
106 -- Procedure Name : create_contact_source
107 -- Description :
108 -- Business Rules :
109 -- Parameters :
110 -- Version : 1.0
111 -- End of comments
112 procedure create_contact_source(p_api_version IN NUMBER,
113 p_init_msg_list IN VARCHAR2 ,
114 x_return_status OUT NOCOPY VARCHAR2,
115 x_msg_count OUT NOCOPY NUMBER,
116 x_msg_data OUT NOCOPY VARCHAR2,
117 p_csov_rec IN csov_rec_type,
118 x_csov_rec OUT NOCOPY csov_rec_type) is
119 begin
120 okc_cso_pvt.insert_row(p_api_version => p_api_version,
121 p_init_msg_list => p_init_msg_list,
122 x_msg_count => x_msg_count,
123 x_msg_data => x_msg_data,
124 x_return_status => x_return_status,
125 p_csov_rec => p_csov_rec,
126 x_csov_rec => x_csov_rec);
127 end create_contact_source;
128
129 -- Start of comments
130 --
131 -- Procedure Name : update_contact_source
132 -- Description :
133 -- Business Rules :
134 -- Parameters :
135 -- Version : 1.0
136 -- End of comments
137 procedure update_contact_source(p_api_version IN NUMBER,
138 p_init_msg_list IN VARCHAR2 ,
139 x_return_status OUT NOCOPY VARCHAR2,
140 x_msg_count OUT NOCOPY NUMBER,
141 x_msg_data OUT NOCOPY VARCHAR2,
142 p_csov_rec IN csov_rec_type,
143 x_csov_rec OUT NOCOPY csov_rec_type) is
144 begin
145 okc_cso_pvt.update_row(p_api_version => p_api_version,
146 p_init_msg_list => p_init_msg_list,
147 x_msg_count => x_msg_count,
148 x_msg_data => x_msg_data,
149 x_return_status => x_return_status,
150 p_csov_rec => p_csov_rec,
151 x_csov_rec => x_csov_rec);
152 end update_contact_source;
153
154 -- Start of comments
155 --
156 -- Procedure Name : lock_contact_source
157 -- Description :
158 -- Business Rules :
159 -- Parameters :
160 -- Version : 1.0
161 -- End of comments
162 procedure lock_contact_source(p_api_version IN NUMBER,
163 p_init_msg_list IN VARCHAR2 ,
164 x_return_status OUT NOCOPY VARCHAR2,
165 x_msg_count OUT NOCOPY NUMBER,
166 x_msg_data OUT NOCOPY VARCHAR2,
167 p_csov_rec IN csov_rec_type) is
168 begin
169 okc_cso_pvt.lock_row(p_api_version => p_api_version,
170 p_init_msg_list => p_init_msg_list,
171 x_msg_count => x_msg_count,
172 x_msg_data => x_msg_data,
173 x_return_status => x_return_status,
174 p_csov_rec => p_csov_rec);
175 end lock_contact_source;
176
177 -- Start of comments
178 --
179 -- Procedure Name : validate_contact_source
180 -- Description :
181 -- Business Rules :
182 -- Parameters :
183 -- Version : 1.0
184 -- End of comments
185 procedure validate_contact_source(p_api_version IN NUMBER,
186 p_init_msg_list IN VARCHAR2 ,
187 x_return_status OUT NOCOPY VARCHAR2,
188 x_msg_count OUT NOCOPY NUMBER,
189 x_msg_data OUT NOCOPY VARCHAR2,
190 p_csov_rec IN csov_rec_type) is
191 begin
192 okc_cso_pvt.validate_row(p_api_version => p_api_version,
193 p_init_msg_list => p_init_msg_list,
194 x_msg_count => x_msg_count,
195 x_msg_data => x_msg_data,
196 x_return_status => x_return_status,
197 p_csov_rec => p_csov_rec);
198 end validate_contact_source;
199
200 END OKC_ROLE_SOURCE_PVT;