APPS.ENG_ATTACHMENT_IMPLEMENTATION dependencies on UTL_FILE

Line 8: g_debug_file UTL_FILE.FILE_TYPE ;

4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) :=
6: 'ENG_ATTACHMENT_IMPLEMENTATION' ;
7: -- For Debug
8: g_debug_file UTL_FILE.FILE_TYPE ;
9: g_debug_flag BOOLEAN := FALSE ; -- For TEST : FALSE ;
10: g_output_dir VARCHAR2(80) := NULL ;
11: g_debug_filename VARCHAR2(30) := 'eng.chgmt.attachment.log' ;
12: g_debug_errmesg VARCHAR2(240);

Line 46: l_utl_file_dir VARCHAR2(2000);

42: , p_file_name IN VARCHAR2 := NULL
43: )
44: IS
45: l_found NUMBER := 0;
46: l_utl_file_dir VARCHAR2(2000);
47:
48: BEGIN
49:
50: IF p_output_dir IS NOT NULL THEN

Line 67: INTO l_utl_file_dir

63:
64: END IF;
65:
66: select value
67: INTO l_utl_file_dir
68: FROM v$parameter
69: WHERE name = 'utl_file_dir';
70:
71: l_found := INSTR(l_utl_file_dir, g_output_dir);

Line 69: WHERE name = 'utl_file_dir';

65:
66: select value
67: INTO l_utl_file_dir
68: FROM v$parameter
69: WHERE name = 'utl_file_dir';
70:
71: l_found := INSTR(l_utl_file_dir, g_output_dir);
72:
73: IF l_found = 0

Line 71: l_found := INSTR(l_utl_file_dir, g_output_dir);

67: INTO l_utl_file_dir
68: FROM v$parameter
69: WHERE name = 'utl_file_dir';
70:
71: l_found := INSTR(l_utl_file_dir, g_output_dir);
72:
73: IF l_found = 0
74: THEN
75: RETURN;

Line 78: g_debug_file := utl_file.fopen( g_output_dir

74: THEN
75: RETURN;
76: END IF;
77:
78: g_debug_file := utl_file.fopen( g_output_dir
79: , g_debug_filename
80: , 'w');
81: g_debug_flag := TRUE ;
82:

Line 94: IF utl_file.is_open(g_debug_file)

90: -- Close Debug_Session
91: Procedure Close_Debug_Session
92: IS
93: BEGIN
94: IF utl_file.is_open(g_debug_file)
95: THEN
96: utl_file.fclose(g_debug_file);
97: END IF ;
98:

Line 96: utl_file.fclose(g_debug_file);

92: IS
93: BEGIN
94: IF utl_file.is_open(g_debug_file)
95: THEN
96: utl_file.fclose(g_debug_file);
97: END IF ;
98:
99: EXCEPTION
100: WHEN OTHERS THEN

Line 112: IF utl_file.is_open(g_debug_file)

108: ( p_debug_message IN VARCHAR2 )
109: IS
110: BEGIN
111:
112: IF utl_file.is_open(g_debug_file)
113: THEN
114: utl_file.put_line(g_debug_file, p_debug_message);
115: END IF ;
116:

Line 114: utl_file.put_line(g_debug_file, p_debug_message);

110: BEGIN
111:
112: IF utl_file.is_open(g_debug_file)
113: THEN
114: utl_file.put_line(g_debug_file, p_debug_message);
115: END IF ;
116:
117: EXCEPTION
118: WHEN OTHERS THEN