1 PACKAGE CS_SR_Preferred_Lang_PVT AS
2 /* $Header: csvprls.pls 120.0 2006/03/23 11:26:08 spusegao noship $ */
3
4
5 --------------------------------------------------------------------------
6 -- Start of comments
7 -- Record Type : Preferred_Language_Rec_Type
8 -- Description : Holds the Preferred Language attributes
9 -- Fields :
10 --
11 -- End of preferred_language_rec_type comments
12 --------------------------------------------------------------
13 TYPE preferred_language_rec_type IS RECORD (
14 ROW_ID VARCHAR2(64),
15 PREF_LANG_ID NUMBER,
16 LANGUAGE_CODE VARCHAR2(4),
17 START_DATE_ACTIVE DATE,
18 END_DATE_ACTIVE DATE,
19 OBJECT_VERSION_NUMBER NUMBER,
20 LAST_UPDATE_DATE DATE,
21 LAST_UPDATED_BY NUMBER,
22 CREATION_DATE DATE,
23 CREATED_BY NUMBER,
24 LAST_UPDATE_LOGIN NUMBER,
25 ATTRIBUTE1 VARCHAR2(150),
26 ATTRIBUTE2 VARCHAR2(150),
27 ATTRIBUTE3 VARCHAR2(150),
28 ATTRIBUTE4 VARCHAR2(150),
29 ATTRIBUTE5 VARCHAR2(150),
30 ATTRIBUTE6 VARCHAR2(150),
31 ATTRIBUTE7 VARCHAR2(150),
32 ATTRIBUTE8 VARCHAR2(150),
33 ATTRIBUTE9 VARCHAR2(150),
34 ATTRIBUTE10 VARCHAR2(150),
35 ATTRIBUTE11 VARCHAR2(150),
36 ATTRIBUTE12 VARCHAR2(150),
37 ATTRIBUTE13 VARCHAR2(150),
38 ATTRIBUTE14 VARCHAR2(150),
39 ATTRIBUTE15 VARCHAR2(150),
40 ATTRIBUTE_CATEGORY VARCHAR2(150),
41 INITIALIZE_FLAG VARCHAR2(1)
42 );
43
44
45 --This declaration is for the internal user hooks
46 user_hooks_rec preferred_language_rec_type;
47
48
49
50 PROCEDURE initialize_rec(
51 p_preferred_lang_record IN OUT NOCOPY preferred_language_rec_type
52 );
53
54
55
56
57 --------------------------------------------------------------------------
58 -- Start of comments
59 -- API name : Create_Preferred_Language
60 -- Type : Private
61 -- Function : Creates language preference rows in CS_SR_PREFERRED_LANG
62 -- Pre-reqs : None.
63 --
64 -- Standard IN Parameters:
65 -- p_api_version IN NUMBER Required
66 -- p_init_msg_list IN VARCHAR2 Optional
67 -- Default = FND_API.G_FALSE
68 -- p_commit IN VARCHAR2 Optional
69 -- Default = FND_API.G_FALSE
70 -- p_validation_level IN NUMBER Optional
71 -- Default = FND_API.G_VALID_LEVEL_FULL
72 --
73 -- Standard OUT Parameters:
74 -- x_return_status OUT VARCHAR2(1)
75 -- x_msg_count OUT NUMBER
76 -- x_msg_data OUT VARCHAR2(2000)
77 --
78 -- IN Parameters:
79 -- p_resp_appl_id IN NUMBER Optional
80 -- p_resp_id IN NUMBER Optional
81 -- p_user_id IN NUMBER Required
82 -- Application user identifier
83 -- Valid user from fnd_user
84 -- p_login_id IN NUMBER Optional
85 -- Identifier of login session
86 -- p_org_id IN NUMBER Optional
87 -- Operating unit identifier
88 --
89 -- p_preferred_language_rec IN preferred_language_rec_type Required
90 --
91 -- End of comments
92 --------------------------------------------------------------------------
93
94
95
96
97 PROCEDURE Create_Preferred_Language(
98 p_api_version IN NUMBER,
99 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
100 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
101 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_count OUT NOCOPY NUMBER,
104 x_msg_data OUT NOCOPY VARCHAR2,
105 p_resp_appl_id IN NUMBER DEFAULT NULL,
106 p_resp_id IN NUMBER DEFAULT NULL,
107 p_user_id IN NUMBER,
108 p_login_id IN NUMBER DEFAULT NULL,
109 p_preferred_language_rec IN preferred_language_rec_type
110 );
111
112
113 --------------------------------------------------------------------------
114 -- Start of comments
115 -- API name : Update_Preferred_Language
116 -- Type : Private
117 -- Function : Updates a preferred language row in CS_SR_PREFERRED_LANG
118 -- Pre-reqs : None.
119 -- Parameters :
120 -- IN :
121 -- p_api_version IN NUMBER Required
122 -- p_init_msg_list IN VARCHAR2 Optional
123 -- Default = FND_API.G_FALSE
124 -- p_commit IN VARCHAR2 Optional
125 -- Default = FND_API.G_FALSE
126 -- p_validation_level IN NUMBER Optional
127 -- Default = FND_API.G_VALID_LEVEL_FULL
128 -- p_pref_lang_id IN NUMBER Required
129 -- p_object_version_number IN NUMBER Required for Web-Apps
130 -- p_resp_appl_id IN NUMBER Optional
131 -- p_resp_id IN NUMBER Optional
132 -- p_user_id IN NUMBER Required
133 -- p_login_id IN NUMBER Optional
134 -- p_last_updated_by IN NUMBER Required
135 -- p_last_update_login IN NUMBER Optional
136 -- Default = NULL
137 -- p_last_update_date IN DATE Required
138 -- p_preferred_language_rec IN preferred_language_rec_type Required
139
140
141 -- OUT :
142 -- x_return_status OUT VARCHAR2(1) Required
143 -- x_msg_count OUT NUMBER Required
144 -- x_msg_data OUT VARCHAR2(2000) Required
145 --
146 -- Version : Current version 1.0
147 --
148 -- Notes:
149 --
150 -- End of comments
151 --------------------------------------------------------------------------
152
153
154
155
156 PROCEDURE Update_Preferred_Language
157 ( p_api_version IN NUMBER,
158 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
159 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
160 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2,
164 p_pref_lang_id IN NUMBER,
165 p_object_version_number IN NUMBER,
166 p_resp_appl_id IN NUMBER DEFAULT NULL,
167 p_resp_id IN NUMBER DEFAULT NULL,
168 p_user_id IN NUMBER,
169 p_login_id IN NUMBER DEFAULT NULL,
170 p_last_updated_by IN NUMBER,
171 p_last_update_login IN NUMBER DEFAULT NULL,
172 p_last_update_date IN DATE,
173 p_preferred_language_rec IN preferred_language_rec_type
174 );
175
176
177
178 -- Lock row procedure
179 -- This is used to lock a row in the Preferred Language form
180
181 PROCEDURE LOCK_ROW(
182 p_PREF_LANG_ID IN NUMBER,
183 p_OBJECT_VERSION_NUMBER IN NUMBER,
184 p_preferred_language_rec IN preferred_language_rec_type
185 );
186
187 -- -------------------------------------------------------------------
188 -- Validate_Desc_Flex
189 -- -------------------------------------------------------------------
190
191 PROCEDURE Validate_Desc_Flex
192 ( p_api_name IN VARCHAR2,
193 p_application_short_name IN VARCHAR2,
194 p_desc_flex_name IN VARCHAR2,
195 p_desc_segment1 IN VARCHAR2,
196 p_desc_segment2 IN VARCHAR2,
197 p_desc_segment3 IN VARCHAR2,
198 p_desc_segment4 IN VARCHAR2,
199 p_desc_segment5 IN VARCHAR2,
200 p_desc_segment6 IN VARCHAR2,
201 p_desc_segment7 IN VARCHAR2,
202 p_desc_segment8 IN VARCHAR2,
203 p_desc_segment9 IN VARCHAR2,
204 p_desc_segment10 IN VARCHAR2,
205 p_desc_segment11 IN VARCHAR2,
206 p_desc_segment12 IN VARCHAR2,
207 p_desc_segment13 IN VARCHAR2,
208 p_desc_segment14 IN VARCHAR2,
209 p_desc_segment15 IN VARCHAR2,
210 p_desc_context IN VARCHAR2,
211 p_resp_appl_id IN NUMBER := NULL,
212 p_resp_id IN NUMBER := NULL,
213 p_return_status OUT NOCOPY VARCHAR2
214 );
215
216 END CS_SR_Preferred_Lang_PVT;