eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.EC_CODE_CONVERSION_PVT

Source


1 PACKAGE EC_Code_Conversion_PVT AS
2 -- $Header: ECVXREFS.pls 120.3 2005/09/30 07:10:37 arsriniv ship $
3 /*#
4  * This package contains routines to perform code conversion between internal and external codes
5  * @rep:scope internal
6  * @rep:product EC
7  * @rep:lifecycle active
8  * @rep:displayname Code Conversion
9  * @rep:compatibility S
10  * @rep:category BUSINESS_ENTITY EC_CODE_CONVERSION
11  */
12 
13 --  Global constants holding the package and file names to be used by
14 --  messaging routines in the case of an unexpected error.
15 
16 G_PKG_NAME	CONSTANT VARCHAR2(30) := 'EC_Code_Conversion_PVT';
17 G_FILE_NAME	CONSTANT VARCHAR2(12) := 'ECVXREFB.pls';
18 
19 G_XREF_NOT_FOUND	CONSTANT VARCHAR2(1) := 'X';
20 
21 -- Start of Comments
22 --	API name 	: Convert_from_int_to_ext
23 --	Type		: Private.
24 --	Function	: Perform value lookup to convert internal value
25 --			  to external value(s)
26 --	Pre-reqs	: None.
27 --	Paramaeters	:
28 --	IN		:	p_api_version_number	IN NUMBER		Required
29 --				p_init_msg_list		IN VARCHAR2 		Optional
30 --					Default = FND_API.G_FALSE
31 --				p_simulate		IN VARCHAR2		Optional
32 --					Default = FND_API.G_FALSE
33 --				p_commit	    	IN VARCHAR2		Optional
34 --					Default = FND_API.G_FALSE
35 --				p_validation_level	IN NUMBER		Optional
36 --					Default = FND_API.G_VALID_LEVEL_FULL
37 --				p_Category     		IN VARCHAR2		Required
38 --				p_Key1			IN VARCHAR2		Optional
39 --					Default = NULL
40 --				p_Key2			IN VARCHAR2		Optional
41 --					Default = NULL
42 --				p_Key3			IN VARCHAR2		Optional
43 --					Default = NULL
44 --				p_Key4			IN VARCHAR2		Optional
45 --					Default = NULL
46 --				p_Key5			IN VARCHAR2		Optional
47 --					Default = NULL
48 --				p_Int_val		IN VARCHAR2		Required
49 
50 --
51 --	OUT		:	p_return_status		OUT VARCHAR2(1)
52 --				p_msg_count		OUT NUMBER
53 --				p_msg_data		OUT VARCHAR2(2000)
54 --				p_Ext_val1		OUT VARCHAR2
55 --				p_Ext_val2		OUT VARCHAR2
56 --				p_Ext_val3		OUT VARCHAR2
57 --				p_Ext_val4		OUT VARCHAR2
58 --				p_Ext_val5		OUT VARCHAR2
59 --				.
60 --	Version	: Current version	1.0
61 --		  Initial version 	1.0
62 --
63 --	Notes		: Note text
64 --
65 --
66 --	API name 	: Convert_from_ext_to_int
67 --	Type		: Private.
68 --	Function	: Perform value lookup to convert external value(s)
69 --			  to internal value
70 --	Pre-reqs	: None.
71 --	Paramaeters	:
72 --	IN		:	p_api_version_number	IN NUMBER		Required
73 --				p_init_msg_list		IN VARCHAR2 		Optional
74 --					Default = FND_API.G_FALSE
75 --				p_simulate		IN VARCHAR2		Optional
76 --					Default = FND_API.G_FALSE
77 --				p_commit	    	IN VARCHAR2		Optional
78 --					Default = FND_API.G_FALSE
79 --				p_validation_level	IN NUMBER		Optional
80 --					Default = FND_API.G_VALID_LEVEL_FULL
81 --				p_Category     		IN VARCHAR2		Required
82 --				p_Key1			IN VARCHAR2		Optional
83 --					Default = NULL
84 --				p_Key2			IN VARCHAR2		Optional
85 --					Default = NULL
86 --				p_Key3			IN VARCHAR2		Optional
87 --					Default = NULL
88 --				p_Key4			IN VARCHAR2		Optional
89 --					Default = NULL
90 --				p_Key5			IN VARCHAR2		Optional
91 --					Default = NULL
92 --				p_Ext_val1		IN VARCHAR2		Required
93 --				p_Ext_val2		IN VARCHAR2		Optional
94 --					Default = NULL
95 --				p_Ext_val3		IN VARCHAR2		Optional
96 --					Default = NULL
97 --				p_Ext_val4		IN VARCHAR2		Optional
98 --					Default = NULL
99 --				p_Ext_val5		IN VARCHAR2		Optional
100 --					Default = NULL
101 --
102 --	OUT		:	p_return_status		OUT VARCHAR2(1)
103 --				p_msg_count		OUT NUMBER
104 --				p_msg_data		OUT VARCHAR2(2000)
105 --				p_Int_val		OUT VARCHAR2
106 --				.
107 --	Version	: Current version	1.0
108 --		  Initial version 	1.0
109 --
110 --	Notes		: Note text
111 --
112 --
113 -- End Of Comments
114 
115 /*#
116  * Used  to convert internal value to external values
117  * @param p_api_version_number API Version Number
118  * @param p_init_msg_list  Initialize Message List?
119  * @param p_simulate      Simulate
120  * @param p_commit        Commit
121  * @param p_validation_level  Validation Level
122  * @param p_return_status Return Status
123  * @param p_msg_count  Message Count
124  * @param p_msg_data   Message Data
125  * @param p_Category Code Category Name
126  * @param p_Key1 Value of Key Column 1
127  * @param p_Key2 Value of Key Column 2
128  * @param p_Key3 Value of Key Column 3
129  * @param p_Key4 Value of Key Column 4
130  * @param p_Key5 value of Key Column 5
131  * @param p_Int_val Internal Value
132  * @param p_Ext_val1 External Value 1
133  * @param p_Ext_val2 External Value 2
134  * @param p_Ext_val3 External Value 3
135  * @param p_Ext_val4 External Value 4
136  * @param p_Ext_val5 External Value 5
137  * @rep:scope internal
138  * @rep:lifecycle active
139  * @rep:displayname Internal to External Code Conversion
140  * @rep:compatibility S
141  */
142 
143 PROCEDURE Convert_from_int_to_ext
144 (  p_api_version_number		IN	NUMBER,
145    p_init_msg_list		IN	VARCHAR2 := FND_API.G_FALSE,
146    p_simulate			IN	VARCHAR2 := FND_API.G_FALSE,
147    p_commit			IN	VARCHAR2 := FND_API.G_FALSE,
148    p_validation_level		IN	NUMBER   := FND_API.G_VALID_LEVEL_FULL,
149    p_return_status		OUT NOCOPY	VARCHAR2,
150    p_msg_count			OUT NOCOPY	NUMBER,
151    p_msg_data			OUT NOCOPY	VARCHAR2,
152    p_Category     		IN	VARCHAR2,
153    p_Key1			IN	VARCHAR2 := NULL,
154    p_Key2			IN	VARCHAR2 := NULL,
155    p_Key3			IN	VARCHAR2 := NULL,
156    p_Key4			IN	VARCHAR2 := NULL,
157    p_Key5			IN	VARCHAR2 := NULL,
158    p_Int_val			IN	VARCHAR2,
159    p_Ext_val1			OUT NOCOPY	VARCHAR2,
160    p_Ext_val2			OUT NOCOPY	VARCHAR2,
161    p_Ext_val3			OUT NOCOPY	VARCHAR2,
162    p_Ext_val4			OUT NOCOPY	VARCHAR2,
163    p_Ext_val5			OUT NOCOPY	VARCHAR2
164 );
165 
166 /*#
167  * Used  to convert external values to internal value
168  * @param p_api_version_number API version number
169  * @param p_init_msg_list  Initialize Message List?
170  * @param p_simulate       Simulate
171  * @param p_commit         Commit
172  * @param p_validation_level Validation Level
173  * @param p_return_status Return Status
174  * @param p_msg_count     Message Count
175  * @param p_msg_data      Message Data
176  * @param p_Category Code Category Name
177  * @param p_Key1 Value of Key Column 1
178  * @param p_Key2 Value of Key Column 2
179  * @param p_Key3 Value of Key Column 3
180  * @param p_Key4 Value of Key Column 4
181  * @param p_Key5 value of Key Column 5
182  * @param p_Ext_val1 External Value 1
183  * @param p_Ext_val2 External Value 2
184  * @param p_Ext_val3 External Value 3
185  * @param p_Ext_val4 External Value 4
186  * @param p_Ext_val5 External Value 5
187  * @param p_Int_val Internal Value
188  * @rep:scope internal
189  * @rep:lifecycle active
190  * @rep:displayname External to Internal Code Conversion
191  * @rep:compatibility S
192  */
193 
194 PROCEDURE Convert_from_ext_to_int
195 (  p_api_version_number		IN	NUMBER,
196    p_init_msg_list		IN	VARCHAR2 := FND_API.G_FALSE,
197    p_simulate			IN	VARCHAR2 := FND_API.G_FALSE,
198    p_commit			IN	VARCHAR2 := FND_API.G_FALSE,
199    p_validation_level		IN	NUMBER   := FND_API.G_VALID_LEVEL_FULL,
200    p_return_status		OUT NOCOPY	VARCHAR2,
201    p_msg_count			OUT NOCOPY	NUMBER,
202    p_msg_data			OUT NOCOPY	VARCHAR2,
203    p_Category     		IN	VARCHAR2,
204    p_Key1			IN	VARCHAR2 := NULL,
205    p_Key2			IN	VARCHAR2 := NULL,
206    p_Key3			IN	VARCHAR2 := NULL,
207    p_Key4			IN	VARCHAR2 := NULL,
208    p_Key5			IN	VARCHAR2 := NULL,
209    p_Ext_val1			IN	VARCHAR2,
210    p_Ext_val2			IN	VARCHAR2 := NULL,
211    p_Ext_val3			IN	VARCHAR2 := NULL,
212    p_Ext_val4			IN	VARCHAR2 := NULL,
213    p_Ext_val5			IN	VARCHAR2 := NULL,
214    p_Int_val			OUT NOCOPY	VARCHAR2
215 );
216 
217 PROCEDURE populate_plsql_tbl_with_extval(
218 	p_api_version_number	IN	NUMBER,
219 	p_init_msg_list		IN	VARCHAR2 := FND_API.G_FALSE,
220 	p_simulate		IN	VARCHAR2 := FND_API.G_FALSE,
221 	p_commit		IN			VARCHAR2 := FND_API.G_FALSE,
222 	p_validation_level	IN			NUMBER   := FND_API.G_VALID_LEVEL_FULL,
223 	p_return_status		OUT NOCOPY		VARCHAR2,
224 	p_msg_count		OUT NOCOPY		NUMBER,
225 	p_msg_data		OUT NOCOPY		VARCHAR2,
226 	p_key_tbl		IN			ece_flatfile_pvt.Interface_tbl_type,
227 	p_tbl			IN OUT NOCOPY  ece_flatfile_pvt.Interface_tbl_type);
228 
229 PROCEDURE populate_plsql_tbl_with_extval(
230 	p_api_version_number	IN	NUMBER,
231 	p_init_msg_list		IN	VARCHAR2 := FND_API.G_FALSE,
232 	p_simulate		IN	VARCHAR2 := FND_API.G_FALSE,
233 	p_commit		IN	VARCHAR2 := FND_API.G_FALSE,
234 	p_validation_level	IN	NUMBER   := FND_API.G_VALID_LEVEL_FULL,
235 	p_return_status		OUT NOCOPY	VARCHAR2,
236 	p_msg_count		OUT NOCOPY	NUMBER,
237 	p_msg_data		OUT NOCOPY	VARCHAR2,
238 	p_tbl			IN OUT	NOCOPY		ec_utils.mapping_tbl,
239 	p_level			IN			number
240 	);
241 
242 
243 PROCEDURE populate_plsql_tbl_with_intval(
244 	p_api_version_number	IN	NUMBER,
245 	p_init_msg_list		IN	VARCHAR2	:= FND_API.G_FALSE,
246 	p_simulate		IN	VARCHAR2	:= FND_API.G_FALSE,
247 	p_commit		IN	VARCHAR2	:= FND_API.G_FALSE,
248 	p_validation_level	IN	NUMBER	:= FND_API.G_VALID_LEVEL_FULL,
249 	p_return_status		OUT NOCOPY	VARCHAR2,
250 	p_msg_count		OUT NOCOPY	NUMBER,
251 	p_msg_data		OUT NOCOPY	VARCHAR2,
252 	p_key_tbl		IN OUT NOCOPY	ece_flatfile_pvt.Interface_tbl_type,
253 	p_apps_tbl		IN OUT NOCOPY	ece_flatfile_pvt.Interface_tbl_type);
254 
255 PROCEDURE populate_plsql_tbl_with_intval
256 	(
257 	p_api_version_number	IN	NUMBER,
258 	p_init_msg_list		IN	VARCHAR2	:= FND_API.G_FALSE,
259 	p_simulate		IN	VARCHAR2	:= FND_API.G_FALSE,
260 	p_commit		IN	VARCHAR2	:= FND_API.G_FALSE,
261 	p_validation_level	IN	NUMBER	:= FND_API.G_VALID_LEVEL_FULL,
262 	p_return_status		OUT NOCOPY	VARCHAR2,
263 	p_msg_count		OUT NOCOPY	NUMBER,
264 	p_msg_data		OUT NOCOPY	VARCHAR2,
265 	p_apps_tbl		IN OUT NOCOPY		ec_utils.mapping_tbl,
266 	p_level			IN			NUMBER
267 	);
268 END;
269