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.

APPS.ECE_UTILITIES dependencies on ECE_LOOKUP_VALUES

Line 209: from ece_lookup_values

205:
206:
207: cursor test_output_level(xTrans VARCHAR2, xLevel VARCHAR2) is
208: select lookup_type
209: from ece_lookup_values
210: where lookup_type = 'OUTPUT_LEVEL_'||xTrans
211: and lookup_code = xLevel;
212:
213: x_width NUMBER;

Line 255: ece_lookup_values with lookup_type=DOCUMENT

251:
252:
253: /*****************************************************
254: Verify that the transaction code is defined in
255: ece_lookup_values with lookup_type=DOCUMENT
256: *****************************************************/
257: begin
258: select lookup_code
259: into xTemp

Line 260: from ece_lookup_values

256: *****************************************************/
257: begin
258: select lookup_code
259: into xTemp
260: from ece_lookup_values
261: where lookup_type = 'DOCUMENT'
262: and lookup_code = cTransaction_code;
263:
264: EXCEPTION

Line 267: x_msg := 'SEED: Document '||cTransaction_code||' not defined in ece_lookup_values';

263:
264: EXCEPTION
265: when NO_DATA_FOUND then
266: bErrors_found := TRUE;
267: x_msg := 'SEED: Document '||cTransaction_code||' not defined in ece_lookup_values';
268:
269: if bInsertErrors then
270: insert into ece_output (run_id,line_id,text)
271: values (iRun_id,

Line 280: ece_lookup_values with lookup_type=xxx:DOCUMENT_TYPE

276:
277:
278: /*****************************************************
279: Verify that the document types are defined in
280: ece_lookup_values with lookup_type=xxx:DOCUMENT_TYPE
281: *****************************************************/
282: begin
283: select lookup_code
284: into xTemp

Line 285: from ece_lookup_values

281: *****************************************************/
282: begin
283: select lookup_code
284: into xTemp
285: from ece_lookup_values
286: where lookup_type = cTransaction_code||':DOCUMENT_TYPE';
287:
288:
289: EXCEPTION

Line 293: x_msg := 'SEED: Document types for '||cTransaction_code||' not defined in ece_lookup_values';

289: EXCEPTION
290: when NO_DATA_FOUND then
291: bErrors_found := TRUE;
292: if bInsertErrors then
293: x_msg := 'SEED: Document types for '||cTransaction_code||' not defined in ece_lookup_values';
294: insert into ece_output (run_id,line_id,text)
295: values (iRun_id,
296: ece_output_lines_s.nextval,
297: x_msg);

Line 312: lookup records in ece_lookup_values.

308:
309: /******************************************************
310: First verify that all of the output levels defined
311: in the ece_interface_tables table have corresponding
312: lookup records in ece_lookup_values.
313: ******************************************************/
314: OPEN c_int_table;
315: LOOP
316: FETCH c_int_table into eit_rec;

Line 335: x_msg := 'SEED: Output level not defined in ECE_LOOKUP_VALUES: '||eit_rec.output_level;

331: EXCEPTION
332: WHEN no_output_level then
333: bErrors_found := TRUE;
334: if bInsertErrors then
335: x_msg := 'SEED: Output level not defined in ECE_LOOKUP_VALUES: '||eit_rec.output_level;
336: insert into ece_output (run_id,line_id,text)
337: values (iRun_id,
338: ece_output_lines_s.nextval,
339: x_msg);

Line 1002: UPDATE ece_lookup_values

998: WHERE transaction_type = p_transaction;
999: END IF;
1000:
1001: xProgress := 'UTILB-10-1080';
1002: UPDATE ece_lookup_values
1003: SET enabled_flag = new_status
1004: WHERE lookup_type = 'DOCUMENT' AND
1005: lookup_code = p_transaction;
1006: