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.OE_GENERATE dependencies on UTL_FILE

Line 215: g_results_file UTL_FILE.file_type;

211: g_gen_pkg_tbl gen_pkg_tbl_type;
212:
213: -- Global results file handlers.
214:
215: g_results_file UTL_FILE.file_type;
216:
217: -- Prototypes.
218:
219: PROCEDURE API_Parameters

Line 220: ( p_file IN UTL_FILE.file_type

216:
217: -- Prototypes.
218:
219: PROCEDURE API_Parameters
220: ( p_file IN UTL_FILE.file_type
221: , p_product IN VARCHAR2
222: , p_object IN VARCHAR2
223: , p_name IN VARCHAR2
224: , p_type IN VARCHAR2

Line 230: ( p_file IN UTL_FILE.file_type

226: , p_lock_api IN BOOLEAN := FALSE
227: );
228:
229: PROCEDURE API_Header
230: ( p_file IN UTL_FILE.file_type
231: , p_name IN VARCHAR2
232: , p_type IN VARCHAR2
233: );
234:

Line 236: ( p_file IN UTL_FILE.file_type

232: , p_type IN VARCHAR2
233: );
234:
235: PROCEDURE Pkg_Header
236: ( p_file IN UTL_FILE.file_type
237: , p_filename IN VARCHAR2
238: , p_pkg_name IN VARCHAR2
239: , p_pkg_type IN VARCHAR2
240: );

Line 243: ( p_file IN UTL_FILE.file_type

239: , p_pkg_type IN VARCHAR2
240: );
241:
242: PROCEDURE Pkg_End
243: ( p_file IN UTL_FILE.file_type
244: , p_pkg_name IN VARCHAR2
245: , p_pkg_type IN VARCHAR2
246: , p_filename IN VARCHAR2 := NULL
247: );

Line 256: ( p_file IN UTL_FILE.file_type

252: , p_pkg_type IN VARCHAR2
253: );
254:
255: PROCEDURE Parameter
256: ( p_file IN UTL_FILE.file_type
257: , p_param IN VARCHAR2
258: , p_mode IN VARCHAR2 := 'IN'
259: , p_type IN VARCHAR2 := G_TYPE_NUMBER
260: , p_level IN NUMBER := 1

Line 266: ( p_file IN UTL_FILE.file_type

262: , p_first IN BOOLEAN := FALSE
263: );
264:
265: PROCEDURE Element
266: ( p_file IN UTL_FILE.file_type
267: , p_element IN VARCHAR2
268: , p_type IN VARCHAR2 := G_TYPE_NUMBER
269: , p_level IN NUMBER := 1
270: , p_rpad IN NUMBER := 30

Line 275: ( p_file IN UTL_FILE.file_type

271: , p_first IN BOOLEAN := FALSE
272: );
273:
274: PROCEDURE Variable
275: ( p_file IN UTL_FILE.file_type
276: , p_var IN VARCHAR2
277: , p_type IN VARCHAR2
278: , p_level IN NUMBER := 1
279: , p_rpad IN NUMBER := 30

Line 283: ( p_file IN UTL_FILE.file_type

279: , p_rpad IN NUMBER := 30
280: );
281:
282: PROCEDURE Assign
283: ( p_file IN UTL_FILE.file_type
284: , p_left IN VARCHAR2
285: , p_right IN VARCHAR2
286: , p_level IN NUMBER := 1
287: , p_rpad IN NUMBER := 30

Line 291: ( p_file IN UTL_FILE.file_type

287: , p_rpad IN NUMBER := 30
288: );
289:
290: PROCEDURE Check_Status
291: ( p_file IN UTL_FILE.file_type
292: , p_variable IN VARCHAR2
293: , p_level IN NUMBER := 1
294: );
295:

Line 297: ( p_file IN UTL_FILE.file_type

293: , p_level IN NUMBER := 1
294: );
295:
296: PROCEDURE Call_Param
297: ( p_file IN UTL_FILE.file_type
298: , p_param IN VARCHAR2
299: , p_val IN VARCHAR2
300: , p_level IN NUMBER := 1
301: , p_rpad IN NUMBER := 30

Line 306: ( p_file IN UTL_FILE.file_type

302: , p_first IN BOOLEAN := FALSE
303: );
304:
305: PROCEDURE End_Call
306: ( p_file IN UTL_FILE.file_type
307: , p_level IN NUMBER := 1
308: );
309:
310: PROCEDURE Get_Msg

Line 311: ( p_file IN UTL_FILE.file_type

307: , p_level IN NUMBER := 1
308: );
309:
310: PROCEDURE Get_Msg
311: ( p_file IN UTL_FILE.file_type
312: , p_level IN NUMBER := 1
313: );
314:
315: PROCEDURE Comment

Line 316: ( p_file IN UTL_FILE.file_type

312: , p_level IN NUMBER := 1
313: );
314:
315: PROCEDURE Comment
316: ( p_file IN UTL_FILE.file_type
317: , p_comment IN VARCHAR2
318: , p_level IN NUMBER := 1
319: , p_line_before IN BOOLEAN := TRUE
320: , p_line_after IN BOOLEAN := TRUE

Line 324: ( p_file IN UTL_FILE.file_type

320: , p_line_after IN BOOLEAN := TRUE
321: );
322:
323: PROCEDURE Text
324: ( p_file IN UTL_FILE.file_type
325: , p_string IN VARCHAR2
326: , p_level IN NUMBER := 1
327: );
328:

Line 330: ( p_file IN UTL_FILE.file_type

326: , p_level IN NUMBER := 1
327: );
328:
329: PROCEDURE Msg
330: ( p_file IN UTL_FILE.file_type
331: , p_product IN VARCHAR2
332: , p_name IN VARCHAR2
333: , p_level IN NUMBER := 2
334: , p_tk1 IN VARCHAR2 := NULL

Line 353: ( p_file IN UTL_FILE.file_type

349: , p_tk5_is_text IN BOOLEAN := TRUE
350: );
351:
352: PROCEDURE Error_Msg
353: ( p_file IN UTL_FILE.file_type
354: , p_product IN VARCHAR2
355: , p_name IN VARCHAR2
356: , p_level IN NUMBER := 2
357: , p_tk1 IN VARCHAR2 := NULL

Line 375: ( p_file IN UTL_FILE.file_type

371: , p_tk5_is_text IN BOOLEAN := TRUE
372: );
373:
374: PROCEDURE Exc_Msg
375: ( p_file IN UTL_FILE.file_type
376: , p_procedure IN VARCHAR2
377: , p_error IN VARCHAR2 := NULL
378: , p_level IN NUMBER := 2
379: , p_text IN BOOLEAN := FALSE

Line 383: ( p_file IN UTL_FILE.file_type

379: , p_text IN BOOLEAN := FALSE
380: );
381:
382: PROCEDURE Std_Exc_Handler
383: ( p_file IN UTL_FILE.file_type
384: , p_name IN VARCHAR2 := NULL
385: , p_savepoint IN VARCHAR2 := NULL
386: );
387:

Line 389: ( p_file IN UTL_FILE.file_type

385: , p_savepoint IN VARCHAR2 := NULL
386: );
387:
388: PROCEDURE Others_Exc
389: ( p_file IN UTL_FILE.file_type
390: , p_name IN VARCHAR2 := NULL
391: , p_level IN NUMBER := 0
392: , p_raise_exc IN BOOLEAN := TRUE
393: );

Line 396: ( p_file IN UTL_FILE.file_type

392: , p_raise_exc IN BOOLEAN := TRUE
393: );
394:
395: PROCEDURE Client_Exception
396: ( p_file IN UTL_FILE.file_type
397: , p_name IN VARCHAR2 := NULL
398: , p_level IN NUMBER := 0
399: );
400:

Line 402: ( p_file IN UTL_FILE.file_type

398: , p_level IN NUMBER := 0
399: );
400:
401: PROCEDURE Comp_Check
402: ( p_file IN UTL_FILE.file_type
403: );
404:
405: PROCEDURE API_Local_Vars
406: ( p_file IN UTL_FILE.file_type

Line 406: ( p_file IN UTL_FILE.file_type

402: ( p_file IN UTL_FILE.file_type
403: );
404:
405: PROCEDURE API_Local_Vars
406: ( p_file IN UTL_FILE.file_type
407: , p_entity_tbl IN Entity_Tbl_Type
408: , p_pkg IN VARCHAR2
409: );
410:

Line 412: ( p_file IN UTL_FILE.file_type

408: , p_pkg IN VARCHAR2
409: );
410:
411: PROCEDURE API_Out_Vars
412: ( p_file IN UTL_FILE.file_type
413: , p_entity_tbl IN Entity_Tbl_Type
414: , p_pkg IN VARCHAR2
415: , p_level IN NUMBER := 1
416: );

Line 419: ( p_file IN UTL_FILE.file_type

415: , p_level IN NUMBER := 1
416: );
417:
418: PROCEDURE API_Out_Param
419: ( p_file IN UTL_FILE.file_type
420: , p_entity_tbl IN Entity_Tbl_Type
421: , p_level IN NUMBER := 1
422: , p_entity_prefix IN VARCHAR2 := 'l_'
423: , p_type IN VARCHAR2 := G_API_TYPE_PVT

Line 427: ( p_file IN UTL_FILE.file_type

423: , p_type IN VARCHAR2 := G_API_TYPE_PVT
424: );
425:
426: PROCEDURE API_In_Param
427: ( p_file IN UTL_FILE.file_type
428: , p_entity_tbl IN Entity_Tbl_Type
429: , p_level IN NUMBER := 1
430: , p_entity_prefix IN VARCHAR2 := 'l_'
431: , p_old_param IN BOOLEAN := TRUE

Line 457: ( p_file IN UTL_FILE.file_type

453: )
454: RETURN BOOLEAN;
455:
456: PROCEDURE Start_Gen
457: ( p_file IN UTL_FILE.file_type
458: , p_text IN VARCHAR2
459: );
460:
461: PROCEDURE End_Gen

Line 462: ( p_file IN UTL_FILE.file_type

458: , p_text IN VARCHAR2
459: );
460:
461: PROCEDURE End_Gen
462: ( p_file IN UTL_FILE.file_type
463: , p_text IN VARCHAR2
464: );
465:
466: PROCEDURE Load_File

Line 467: ( p_file IN UTL_FILE.file_type

463: , p_text IN VARCHAR2
464: );
465:
466: PROCEDURE Load_File
467: ( p_file IN UTL_FILE.file_type
468: );
469:
470: PROCEDURE Load_PK_Attr_Tbl;
471: PROCEDURE Load_Flex_Tables;

Line 477: ( p_file IN UTL_FILE.file_type

473: ( p_flex_name IN VARCHAR2
474: );
475:
476: PROCEDURE Parameter_PK
477: ( p_file IN UTL_FILE.file_type
478: , p_mode IN VARCHAR2 := 'IN'
479: , p_level IN NUMBER := 0
480: , p_rpad IN NUMBER := 30
481: , p_first IN BOOLEAN := FALSE

Line 496: ( p_file IN UTL_FILE.file_type

492: G_MISS_ATTR_TBL
493: );
494:
495: PROCEDURE Call_Param_PK
496: ( p_file IN UTL_FILE.file_type
497: , p_param IN VARCHAR2 := NULL
498: , p_val IN VARCHAR2 := NULL
499: , p_level IN NUMBER := 1
500: , p_rpad IN NUMBER := 30

Line 505: ( p_file IN UTL_FILE.file_type

501: , p_first IN BOOLEAN := FALSE
502: );
503:
504: PROCEDURE Add_Savepoint
505: ( p_file IN UTL_FILE.file_type
506: , p_name IN VARCHAR2
507: , p_level IN NUMBER := 1
508: );
509:

Line 511: ( p_file IN UTL_FILE.file_type

507: , p_level IN NUMBER := 1
508: );
509:
510: PROCEDURE Add_Rollback
511: ( p_file IN UTL_FILE.file_type
512: , p_name IN VARCHAR2
513: , p_level IN NUMBER := 1
514: );
515:

Line 521: ( p_file IN UTL_FILE.file_type

517: ( p_entity_name IN VARCHAR2
518: );
519:
520: PROCEDURE End_If
521: ( p_file IN UTL_FILE.file_type
522: , p_level IN NUMBER := 1
523: );
524:
525: PROCEDURE Add_Then

Line 526: ( p_file IN UTL_FILE.file_type

522: , p_level IN NUMBER := 1
523: );
524:
525: PROCEDURE Add_Then
526: ( p_file IN UTL_FILE.file_type
527: , p_level IN NUMBER := 1
528: );
529:
530: PROCEDURE Add_Is

Line 531: ( p_file IN UTL_FILE.file_type

527: , p_level IN NUMBER := 1
528: );
529:
530: PROCEDURE Add_Is
531: ( p_file IN UTL_FILE.file_type
532: , p_level IN NUMBER := 0
533: );
534:
535: PROCEDURE Add_Begin

Line 536: ( p_file IN UTL_FILE.file_type

532: , p_level IN NUMBER := 0
533: );
534:
535: PROCEDURE Add_Begin
536: ( p_file IN UTL_FILE.file_type
537: , p_level IN NUMBER := 0
538: );
539:
540: PROCEDURE Add_Else

Line 541: ( p_file IN UTL_FILE.file_type

537: , p_level IN NUMBER := 0
538: );
539:
540: PROCEDURE Add_Else
541: ( p_file IN UTL_FILE.file_type
542: , p_level IN NUMBER := 1
543: );
544:
545: PROCEDURE End_Loop

Line 546: ( p_file IN UTL_FILE.file_type

542: , p_level IN NUMBER := 1
543: );
544:
545: PROCEDURE End_Loop
546: ( p_file IN UTL_FILE.file_type
547: , p_level IN NUMBER := 1
548: );
549:
550: FUNCTION Get_Name_In

Line 557: ( p_file IN UTL_FILE.file_type

553: )
554: RETURN VARCHAR2;
555:
556: PROCEDURE Add_Copy
557: ( p_file IN UTL_FILE.file_type
558: , p_source IN VARCHAR2
559: , p_dest IN VARCHAR2
560: , p_type IN VARCHAR2 := G_TYPE_CHAR
561: , p_level IN NUMBER := 1

Line 565: ( p_file IN UTL_FILE.file_type

561: , p_level IN NUMBER := 1
562: );
563:
564: PROCEDURE IDL_Comment
565: ( p_file IN UTL_FILE.file_type
566: , p_comment IN VARCHAR2
567: , p_level IN NUMBER := 1
568: , p_line_before IN BOOLEAN := TRUE
569: , p_line_after IN BOOLEAN := TRUE

Line 573: ( p_file IN UTL_FILE.file_type

569: , p_line_after IN BOOLEAN := TRUE
570: );
571:
572: PROCEDURE IDL_Header
573: ( p_file IN UTL_FILE.file_type
574: , p_filename IN VARCHAR2
575: , p_object_name IN VARCHAR2
576: );
577:

Line 591: ( p_file IN UTL_FILE.file_type

587: )
588: RETURN Attribute_Tbl_Type;
589:
590: PROCEDURE IDL_Parameter
591: ( p_file IN UTL_FILE.file_type
592: , p_param IN VARCHAR2
593: , p_mode IN VARCHAR2 := 'in'
594: , p_type IN VARCHAR2
595: , p_level IN NUMBER := 1

Line 604: ( p_file IN UTL_FILE.file_type

600: ( p_attr_code IN VARCHAR2
601: ) RETURN Attribute_Tbl_Type;
602:
603: PROCEDURE Get_Api_Parameters
604: ( p_file IN UTL_FILE.file_type
605: , p_product IN VARCHAR2
606: , p_object IN VARCHAR2
607: , p_name IN VARCHAR2
608: , p_type IN VARCHAR2 := G_API_TYPE_PVT

Line 613: ( p_file IN UTL_FILE.file_type

609: , p_entity_tbl IN Entity_Tbl_Type
610: );
611:
612: PROCEDURE Null_Or_Missing
613: ( p_file IN UTL_FILE.file_type
614: , p_attribute IN attribute_rec_type
615: , p_prefix_text IN VARCHAR2 := NULL
616: , p_not IN BOOLEAN := TRUE
617: , p_and IN BOOLEAN := TRUE