DBA Data[Home] [Help]

APPS.CCT_LKUP_PUB dependencies on IEO_STRING_VARR

Line 15: x_lov_data OUT NOCOPY IEO_STRING_VARR, -- list of lov_data returned.

11: p_server_id IN NUMBER , -- server id
12: p_server_parameter_id IN NUMBER , -- server parameter id
13: p_env_lang IN VARCHAR2 , -- language
14: x_lov_count OUT NOCOPY NUMBER , -- number of lov_data returned
15: x_lov_data OUT NOCOPY IEO_STRING_VARR, -- list of lov_data returned.
16: x_return_status OUT NOCOPY VARCHAR2,
17: x_msg_count OUT NOCOPY NUMBER,
18: x_msg_data OUT NOCOPY VARCHAR2
19: )

Line 25: l_lov_meaning IEO_STRING_VARR;

21: l_api_name CONSTANT VARCHAR2(30) := 'GET_TRUE_FALSE_LOV';
22: l_api_version CONSTANT NUMBER := 1.0;
23: x_err_num NUMBER;
24: x_err_msg VARCHAR2(256);
25: l_lov_meaning IEO_STRING_VARR;
26: l_lov_code IEO_STRING_VARR;
27: i number;
28: j number;
29:

Line 26: l_lov_code IEO_STRING_VARR;

22: l_api_version CONSTANT NUMBER := 1.0;
23: x_err_num NUMBER;
24: x_err_msg VARCHAR2(256);
25: l_lov_meaning IEO_STRING_VARR;
26: l_lov_code IEO_STRING_VARR;
27: i number;
28: j number;
29:
30: BEGIN

Line 41: x_lov_data := IEO_STRING_VARR();

37: x_msg_count := 0;
38: x_msg_data := null;
39:
40: x_lov_count := 0;
41: x_lov_data := IEO_STRING_VARR();
42: l_lov_meaning := IEO_STRING_VARR();
43: l_lov_code := IEO_STRING_VARR();
44:
45: -- API body

Line 42: l_lov_meaning := IEO_STRING_VARR();

38: x_msg_data := null;
39:
40: x_lov_count := 0;
41: x_lov_data := IEO_STRING_VARR();
42: l_lov_meaning := IEO_STRING_VARR();
43: l_lov_code := IEO_STRING_VARR();
44:
45: -- API body
46:

Line 43: l_lov_code := IEO_STRING_VARR();

39:
40: x_lov_count := 0;
41: x_lov_data := IEO_STRING_VARR();
42: l_lov_meaning := IEO_STRING_VARR();
43: l_lov_code := IEO_STRING_VARR();
44:
45: -- API body
46:
47: SELECT lv.MEANING, lv.lookup_code BULK COLLECT INTO l_lov_meaning, l_lov_code FROM FND_LOOKUP_VALUES LV

Line 97: x_lov_data OUT NOCOPY IEO_STRING_VARR, -- list of lov_data returned.

93: p_server_id IN NUMBER , -- server id
94: p_server_parameter_id IN NUMBER , -- server parameter id
95: p_env_lang IN VARCHAR2 , -- language
96: x_lov_count OUT NOCOPY NUMBER , -- number of lov_data returned
97: x_lov_data OUT NOCOPY IEO_STRING_VARR, -- list of lov_data returned.
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
100: x_msg_data OUT NOCOPY VARCHAR2
101:

Line 120: x_lov_data := IEO_STRING_VARR();

116: x_msg_count := 0;
117: x_msg_data := null;
118: -- API body
119: x_lov_count := 0;
120: x_lov_data := IEO_STRING_VARR();
121:
122:
123:
124: FOR i IN 1..15 LOOP

Line 156: x_lov_data OUT NOCOPY IEO_STRING_VARR, -- list of lov_data returned.

152: p_server_id IN NUMBER , -- server id
153: p_server_parameter_id IN NUMBER , -- server parameter id
154: p_env_lang IN VARCHAR2 , -- language
155: x_lov_count OUT NOCOPY NUMBER , -- number of lov_data returned
156: x_lov_data OUT NOCOPY IEO_STRING_VARR, -- list of lov_data returned.
157: x_return_status OUT NOCOPY VARCHAR2,
158: x_msg_count OUT NOCOPY NUMBER,
159: x_msg_data OUT NOCOPY VARCHAR2
160:

Line 168: l_lov_meaning IEO_STRING_VARR;

164: l_api_name CONSTANT VARCHAR2(30) := 'GET_TRACE_LOV';
165: l_api_version CONSTANT NUMBER := 1.0;
166: x_err_num NUMBER;
167: x_err_msg VARCHAR2(256);
168: l_lov_meaning IEO_STRING_VARR;
169: l_lov_code IEO_STRING_VARR;
170: i number;
171: j number;
172: BEGIN

Line 169: l_lov_code IEO_STRING_VARR;

165: l_api_version CONSTANT NUMBER := 1.0;
166: x_err_num NUMBER;
167: x_err_msg VARCHAR2(256);
168: l_lov_meaning IEO_STRING_VARR;
169: l_lov_code IEO_STRING_VARR;
170: i number;
171: j number;
172: BEGIN
173: -- Standard Start of API savepoint

Line 183: x_lov_data := IEO_STRING_VARR();

179: x_msg_count := 0;
180: x_msg_data := null;
181:
182: x_lov_count := 0;
183: x_lov_data := IEO_STRING_VARR();
184: l_lov_meaning := IEO_STRING_VARR();
185: l_lov_code := IEO_STRING_VARR();
186:
187: -- API body

Line 184: l_lov_meaning := IEO_STRING_VARR();

180: x_msg_data := null;
181:
182: x_lov_count := 0;
183: x_lov_data := IEO_STRING_VARR();
184: l_lov_meaning := IEO_STRING_VARR();
185: l_lov_code := IEO_STRING_VARR();
186:
187: -- API body
188:

Line 185: l_lov_code := IEO_STRING_VARR();

181:
182: x_lov_count := 0;
183: x_lov_data := IEO_STRING_VARR();
184: l_lov_meaning := IEO_STRING_VARR();
185: l_lov_code := IEO_STRING_VARR();
186:
187: -- API body
188:
189: SELECT MEANING, lookup_code BULK COLLECT INTO l_lov_meaning, l_lov_code FROM FND_LOOKUP_VALUES LV

Line 235: x_lov_data OUT NOCOPY IEO_STRING_VARR, -- list of lov_data returned.

231: p_server_id IN NUMBER , -- server id
232: p_server_parameter_id IN NUMBER , -- server parameter id
233: p_env_lang IN VARCHAR2 , -- language
234: x_lov_count OUT NOCOPY NUMBER , -- number of lov_data returned
235: x_lov_data OUT NOCOPY IEO_STRING_VARR, -- list of lov_data returned.
236: x_return_status OUT NOCOPY VARCHAR2,
237: x_msg_count OUT NOCOPY NUMBER,
238: x_msg_data OUT NOCOPY VARCHAR2
239:

Line 247: l_lov_meaning IEO_STRING_VARR;

243: l_api_name CONSTANT VARCHAR2(30) := 'GET_TEST_TYPE_LOV';
244: l_api_version CONSTANT NUMBER := 1.0;
245: x_err_num NUMBER;
246: x_err_msg VARCHAR2(256);
247: l_lov_meaning IEO_STRING_VARR;
248: l_lov_code IEO_STRING_VARR;
249: i number;
250: j number;
251: BEGIN

Line 248: l_lov_code IEO_STRING_VARR;

244: l_api_version CONSTANT NUMBER := 1.0;
245: x_err_num NUMBER;
246: x_err_msg VARCHAR2(256);
247: l_lov_meaning IEO_STRING_VARR;
248: l_lov_code IEO_STRING_VARR;
249: i number;
250: j number;
251: BEGIN
252: -- Standard Start of API savepoint

Line 262: x_lov_data := IEO_STRING_VARR();

258: x_msg_count := 0;
259: x_msg_data := null;
260:
261: x_lov_count := 0;
262: x_lov_data := IEO_STRING_VARR();
263: l_lov_meaning := IEO_STRING_VARR();
264: l_lov_code := IEO_STRING_VARR();
265:
266: -- API body

Line 263: l_lov_meaning := IEO_STRING_VARR();

259: x_msg_data := null;
260:
261: x_lov_count := 0;
262: x_lov_data := IEO_STRING_VARR();
263: l_lov_meaning := IEO_STRING_VARR();
264: l_lov_code := IEO_STRING_VARR();
265:
266: -- API body
267:

Line 264: l_lov_code := IEO_STRING_VARR();

260:
261: x_lov_count := 0;
262: x_lov_data := IEO_STRING_VARR();
263: l_lov_meaning := IEO_STRING_VARR();
264: l_lov_code := IEO_STRING_VARR();
265:
266: -- API body
267:
268: SELECT MEANING, lookup_code BULK COLLECT INTO l_lov_meaning, l_lov_code FROM FND_LOOKUP_VALUES LV

Line 315: x_lov_data OUT NOCOPY IEO_STRING_VARR, -- list of lov_data returned.

311: p_server_id IN NUMBER , -- server id
312: p_server_parameter_id IN NUMBER , -- server parameter id
313: p_env_lang IN VARCHAR2 , -- language
314: x_lov_count OUT NOCOPY NUMBER , -- number of lov_data returned
315: x_lov_data OUT NOCOPY IEO_STRING_VARR, -- list of lov_data returned.
316: x_return_status OUT NOCOPY VARCHAR2,
317: x_msg_count OUT NOCOPY NUMBER,
318: x_msg_data OUT NOCOPY VARCHAR2
319:

Line 370: x_lov_data OUT NOCOPY IEO_STRING_VARR, -- list of lov_data returned.

366: p_server_id IN NUMBER , -- server id
367: p_server_parameter_id IN NUMBER , -- server parameter id
368: p_env_lang IN VARCHAR2 , -- language
369: x_lov_count OUT NOCOPY NUMBER , -- number of lov_data returned
370: x_lov_data OUT NOCOPY IEO_STRING_VARR, -- list of lov_data returned.
371: x_return_status OUT NOCOPY VARCHAR2,
372: x_msg_count OUT NOCOPY NUMBER,
373: x_msg_data OUT NOCOPY VARCHAR2
374: