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

Line 201: , p_hdr_file_handle IN OUT NOCOPY utl_file.file_type

197: FUNCTION open_export_files( p_bg_id IN NUMBER
198: , p_bg_name IN VARCHAR2
199: , p_hdr_file IN OUT NOCOPY VARCHAR2
200: , p_dat_file IN OUT NOCOPY VARCHAR2
201: , p_hdr_file_handle IN OUT NOCOPY utl_file.file_type
202: , p_dat_file_handle IN OUT NOCOPY utl_file.file_type
203: ) RETURN NUMBER IS
204:
205: -- Local variables

Line 202: , p_dat_file_handle IN OUT NOCOPY utl_file.file_type

198: , p_bg_name IN VARCHAR2
199: , p_hdr_file IN OUT NOCOPY VARCHAR2
200: , p_dat_file IN OUT NOCOPY VARCHAR2
201: , p_hdr_file_handle IN OUT NOCOPY utl_file.file_type
202: , p_dat_file_handle IN OUT NOCOPY utl_file.file_type
203: ) RETURN NUMBER IS
204:
205: -- Local variables
206: l_proc VARCHAR2(50) := g_package||'.open_export_files';

Line 208: l_hdr_file_handle utl_file.file_type;

204:
205: -- Local variables
206: l_proc VARCHAR2(50) := g_package||'.open_export_files';
207: l_retcode NUMBER := 0;
208: l_hdr_file_handle utl_file.file_type;
209: l_dat_file_handle utl_file.file_type;
210:
211: -- Local exceptions
212: e_invalid_dir EXCEPTION;

Line 209: l_dat_file_handle utl_file.file_type;

205: -- Local variables
206: l_proc VARCHAR2(50) := g_package||'.open_export_files';
207: l_retcode NUMBER := 0;
208: l_hdr_file_handle utl_file.file_type;
209: l_dat_file_handle utl_file.file_type;
210:
211: -- Local exceptions
212: e_invalid_dir EXCEPTION;
213:

Line 235: l_hdr_file_handle := utl_file.fopen( g_export_dir

231:
232: -- Open export header file
233: BEGIN
234: hr_utility.set_location(l_proc, 20);
235: l_hdr_file_handle := utl_file.fopen( g_export_dir
236: , p_hdr_file
237: , 'w'
238: );
239: hr_utility.set_location(l_proc, 30);

Line 240: l_dat_file_handle := utl_file.fopen( g_export_dir

236: , p_hdr_file
237: , 'w'
238: );
239: hr_utility.set_location(l_proc, 30);
240: l_dat_file_handle := utl_file.fopen( g_export_dir
241: , p_dat_file
242: , 'w'
243: );
244: hr_utility.set_location(l_proc, 40);

Line 279: FUNCTION close_export_files( p_hdr_file_handle IN utl_file.file_type

275:
276: --
277: -- Close export header and data files.
278: --
279: FUNCTION close_export_files( p_hdr_file_handle IN utl_file.file_type
280: , p_dat_file_handle IN utl_file.file_type
281: ) RETURN NUMBER IS
282:
283: -- Local variables

Line 280: , p_dat_file_handle IN utl_file.file_type

276: --
277: -- Close export header and data files.
278: --
279: FUNCTION close_export_files( p_hdr_file_handle IN utl_file.file_type
280: , p_dat_file_handle IN utl_file.file_type
281: ) RETURN NUMBER IS
282:
283: -- Local variables
284: l_proc VARCHAR2(50) := g_package||'.close_export_files';

Line 286: l_hdr_file_handle utl_file.file_type;

282:
283: -- Local variables
284: l_proc VARCHAR2(50) := g_package||'.close_export_files';
285: l_retcode NUMBER := 0;
286: l_hdr_file_handle utl_file.file_type;
287: l_dat_file_handle utl_file.file_type;
288:
289: BEGIN
290:

Line 287: l_dat_file_handle utl_file.file_type;

283: -- Local variables
284: l_proc VARCHAR2(50) := g_package||'.close_export_files';
285: l_retcode NUMBER := 0;
286: l_hdr_file_handle utl_file.file_type;
287: l_dat_file_handle utl_file.file_type;
288:
289: BEGIN
290:
291: hr_utility.set_location('Entering: '|| l_proc, 10);

Line 296: utl_file.fclose(l_hdr_file_handle);

292:
293: l_hdr_file_handle := p_hdr_file_handle;
294: l_dat_file_handle := p_dat_file_handle;
295: hr_utility.set_location(l_proc, 20);
296: utl_file.fclose(l_hdr_file_handle);
297: hr_utility.set_location(l_proc, 30);
298: utl_file.fclose(l_dat_file_handle);
299:
300: hr_utility.set_location('Leaving: '|| l_proc, 40);

Line 298: utl_file.fclose(l_dat_file_handle);

294: l_dat_file_handle := p_dat_file_handle;
295: hr_utility.set_location(l_proc, 20);
296: utl_file.fclose(l_hdr_file_handle);
297: hr_utility.set_location(l_proc, 30);
298: utl_file.fclose(l_dat_file_handle);
299:
300: hr_utility.set_location('Leaving: '|| l_proc, 40);
301:
302: RETURN l_retcode;

Line 3002: FUNCTION write_hdr_file( p_hdr_file_handle IN utl_file.file_type

2998:
2999: --
3000: -- Write header file
3001: --
3002: FUNCTION write_hdr_file( p_hdr_file_handle IN utl_file.file_type
3003: , p_bg_name IN VARCHAR2
3004: , p_dat_file IN VARCHAR2
3005: ) RETURN NUMBER IS
3006:

Line 3017: utl_file.put_line( p_hdr_file_handle

3013:
3014: hr_utility.set_location('Entering: '|| l_proc, 10);
3015:
3016: -- Write header file header
3017: utl_file.put_line( p_hdr_file_handle
3018: , 'Header'||l_tab||'Start');
3019: utl_file.put_line( p_hdr_file_handle
3020: , 'Batch Name'||l_tab||SUBSTR(p_bg_name||'-'||TO_CHAR(SYSDATE,'YYYY/MM/DD'),1,70));
3021: utl_file.put_line( p_hdr_file_handle

Line 3019: utl_file.put_line( p_hdr_file_handle

3015:
3016: -- Write header file header
3017: utl_file.put_line( p_hdr_file_handle
3018: , 'Header'||l_tab||'Start');
3019: utl_file.put_line( p_hdr_file_handle
3020: , 'Batch Name'||l_tab||SUBSTR(p_bg_name||'-'||TO_CHAR(SYSDATE,'YYYY/MM/DD'),1,70));
3021: utl_file.put_line( p_hdr_file_handle
3022: , 'Date'||l_tab||TO_CHAR(SYSDATE,'YYYY/MM/DD'));
3023: utl_file.put_line( p_hdr_file_handle

Line 3021: utl_file.put_line( p_hdr_file_handle

3017: utl_file.put_line( p_hdr_file_handle
3018: , 'Header'||l_tab||'Start');
3019: utl_file.put_line( p_hdr_file_handle
3020: , 'Batch Name'||l_tab||SUBSTR(p_bg_name||'-'||TO_CHAR(SYSDATE,'YYYY/MM/DD'),1,70));
3021: utl_file.put_line( p_hdr_file_handle
3022: , 'Date'||l_tab||TO_CHAR(SYSDATE,'YYYY/MM/DD'));
3023: utl_file.put_line( p_hdr_file_handle
3024: , 'Version'||l_tab||'1.0');
3025: utl_file.put_line( p_hdr_file_handle

Line 3023: utl_file.put_line( p_hdr_file_handle

3019: utl_file.put_line( p_hdr_file_handle
3020: , 'Batch Name'||l_tab||SUBSTR(p_bg_name||'-'||TO_CHAR(SYSDATE,'YYYY/MM/DD'),1,70));
3021: utl_file.put_line( p_hdr_file_handle
3022: , 'Date'||l_tab||TO_CHAR(SYSDATE,'YYYY/MM/DD'));
3023: utl_file.put_line( p_hdr_file_handle
3024: , 'Version'||l_tab||'1.0');
3025: utl_file.put_line( p_hdr_file_handle
3026: , 'Date Format'||l_tab||'YYYY/MM/DD');
3027: utl_file.put_line( p_hdr_file_handle

Line 3025: utl_file.put_line( p_hdr_file_handle

3021: utl_file.put_line( p_hdr_file_handle
3022: , 'Date'||l_tab||TO_CHAR(SYSDATE,'YYYY/MM/DD'));
3023: utl_file.put_line( p_hdr_file_handle
3024: , 'Version'||l_tab||'1.0');
3025: utl_file.put_line( p_hdr_file_handle
3026: , 'Date Format'||l_tab||'YYYY/MM/DD');
3027: utl_file.put_line( p_hdr_file_handle
3028: , 'Number Format'||l_tab||'999999999999999');
3029: utl_file.put_line( p_hdr_file_handle

Line 3027: utl_file.put_line( p_hdr_file_handle

3023: utl_file.put_line( p_hdr_file_handle
3024: , 'Version'||l_tab||'1.0');
3025: utl_file.put_line( p_hdr_file_handle
3026: , 'Date Format'||l_tab||'YYYY/MM/DD');
3027: utl_file.put_line( p_hdr_file_handle
3028: , 'Number Format'||l_tab||'999999999999999');
3029: utl_file.put_line( p_hdr_file_handle
3030: , 'Header'||l_tab||'End');
3031:

Line 3029: utl_file.put_line( p_hdr_file_handle

3025: utl_file.put_line( p_hdr_file_handle
3026: , 'Date Format'||l_tab||'YYYY/MM/DD');
3027: utl_file.put_line( p_hdr_file_handle
3028: , 'Number Format'||l_tab||'999999999999999');
3029: utl_file.put_line( p_hdr_file_handle
3030: , 'Header'||l_tab||'End');
3031:
3032: hr_utility.set_location(l_proc, 20);
3033:

Line 3035: utl_file.put_line( p_hdr_file_handle

3031:
3032: hr_utility.set_location(l_proc, 20);
3033:
3034: -- Write header file data
3035: utl_file.put_line( p_hdr_file_handle
3036: , 'Files'||l_tab||'Start');
3037: utl_file.put_line( p_hdr_file_handle
3038: , 'create_company_cost_center'||l_tab||p_dat_file);
3039: utl_file.put_line( p_hdr_file_handle

Line 3037: utl_file.put_line( p_hdr_file_handle

3033:
3034: -- Write header file data
3035: utl_file.put_line( p_hdr_file_handle
3036: , 'Files'||l_tab||'Start');
3037: utl_file.put_line( p_hdr_file_handle
3038: , 'create_company_cost_center'||l_tab||p_dat_file);
3039: utl_file.put_line( p_hdr_file_handle
3040: , 'Files'||l_tab||'End');
3041:

Line 3039: utl_file.put_line( p_hdr_file_handle

3035: utl_file.put_line( p_hdr_file_handle
3036: , 'Files'||l_tab||'Start');
3037: utl_file.put_line( p_hdr_file_handle
3038: , 'create_company_cost_center'||l_tab||p_dat_file);
3039: utl_file.put_line( p_hdr_file_handle
3040: , 'Files'||l_tab||'End');
3041:
3042: hr_utility.set_location('Leaving: '|| l_proc, 30);
3043:

Line 3060: FUNCTION write_dat_file( p_dat_file_handle IN utl_file.file_type

3056:
3057: --
3058: -- Write data file
3059: --
3060: FUNCTION write_dat_file( p_dat_file_handle IN utl_file.file_type
3061: ) RETURN NUMBER IS
3062:
3063: -- Local variables
3064: l_proc VARCHAR2(50) := g_package||'.write_dat_file';

Line 3085: utl_file.put_line( p_dat_file_handle

3081:
3082: hr_utility.set_location('Entering: '|| l_proc, 10);
3083:
3084: -- Write data file header
3085: utl_file.put_line( p_dat_file_handle
3086: , 'Descriptor'||l_tab||'Start');
3087: utl_file.put_line( p_dat_file_handle
3088: , 'API'||l_tab||'create_company_cost_center');
3089: utl_file.put_line( p_dat_file_handle

Line 3087: utl_file.put_line( p_dat_file_handle

3083:
3084: -- Write data file header
3085: utl_file.put_line( p_dat_file_handle
3086: , 'Descriptor'||l_tab||'Start');
3087: utl_file.put_line( p_dat_file_handle
3088: , 'API'||l_tab||'create_company_cost_center');
3089: utl_file.put_line( p_dat_file_handle
3090: , 'Title'||l_tab||'create company cost center');
3091: utl_file.put_line( p_dat_file_handle

Line 3089: utl_file.put_line( p_dat_file_handle

3085: utl_file.put_line( p_dat_file_handle
3086: , 'Descriptor'||l_tab||'Start');
3087: utl_file.put_line( p_dat_file_handle
3088: , 'API'||l_tab||'create_company_cost_center');
3089: utl_file.put_line( p_dat_file_handle
3090: , 'Title'||l_tab||'create company cost center');
3091: utl_file.put_line( p_dat_file_handle
3092: , 'Process Order'||l_tab||'10');
3093: utl_file.put_line( p_dat_file_handle

Line 3091: utl_file.put_line( p_dat_file_handle

3087: utl_file.put_line( p_dat_file_handle
3088: , 'API'||l_tab||'create_company_cost_center');
3089: utl_file.put_line( p_dat_file_handle
3090: , 'Title'||l_tab||'create company cost center');
3091: utl_file.put_line( p_dat_file_handle
3092: , 'Process Order'||l_tab||'10');
3093: utl_file.put_line( p_dat_file_handle
3094: , 'Descriptor'||l_tab||'End');
3095:

Line 3093: utl_file.put_line( p_dat_file_handle

3089: utl_file.put_line( p_dat_file_handle
3090: , 'Title'||l_tab||'create company cost center');
3091: utl_file.put_line( p_dat_file_handle
3092: , 'Process Order'||l_tab||'10');
3093: utl_file.put_line( p_dat_file_handle
3094: , 'Descriptor'||l_tab||'End');
3095:
3096: hr_utility.set_location(l_proc, 20);
3097:

Line 3099: utl_file.put_line( p_dat_file_handle

3095:
3096: hr_utility.set_location(l_proc, 20);
3097:
3098: -- Write data file data titles
3099: utl_file.put_line( p_dat_file_handle
3100: , 'Data'||l_tab||'Start');
3101: utl_file.put_line( p_dat_file_handle
3102: , 'ID' ||l_tab||
3103: 'organization_name' ||l_tab||

Line 3101: utl_file.put_line( p_dat_file_handle

3097:
3098: -- Write data file data titles
3099: utl_file.put_line( p_dat_file_handle
3100: , 'Data'||l_tab||'Start');
3101: utl_file.put_line( p_dat_file_handle
3102: , 'ID' ||l_tab||
3103: 'organization_name' ||l_tab||
3104: 'costcenter_id' ||l_tab||
3105: 'costcenter_name' ||l_tab||

Line 3140: utl_file.put_line( p_dat_file_handle

3136: EXIT WHEN c_list%NOTFOUND;
3137:
3138: l_dat_rec_count := l_dat_rec_count + 1;
3139:
3140: utl_file.put_line( p_dat_file_handle
3141: , l_dat_rec_count ||l_tab|| -- Data Record Id
3142: l_org_name ||l_tab|| -- Org Name
3143: l_cc ||l_tab|| -- Cost Center Code
3144: l_cc_desc ||l_tab|| -- Cost Center Name

Line 3155: utl_file.put_line( p_dat_file_handle

3151: );
3152: END LOOP;
3153: CLOSE c_list;
3154:
3155: utl_file.put_line( p_dat_file_handle
3156: , 'Data'||l_tab||'End');
3157:
3158: writelog('Spooled '||l_dat_rec_count||' data records to data file','Y');
3159:

Line 3190: l_hdr_file_handle utl_file.file_type;

3186: l_proc VARCHAR2(50) := g_package||'.spool_to_file';
3187: l_retcode NUMBER := 0;
3188: l_hdr_file VARCHAR2(80) := NULL;
3189: l_dat_file VARCHAR2(80) := NULL;
3190: l_hdr_file_handle utl_file.file_type;
3191: l_dat_file_handle utl_file.file_type;
3192:
3193: BEGIN
3194:

Line 3191: l_dat_file_handle utl_file.file_type;

3187: l_retcode NUMBER := 0;
3188: l_hdr_file VARCHAR2(80) := NULL;
3189: l_dat_file VARCHAR2(80) := NULL;
3190: l_hdr_file_handle utl_file.file_type;
3191: l_dat_file_handle utl_file.file_type;
3192:
3193: BEGIN
3194:
3195: hr_utility.set_location('Entering: '|| l_proc, 10);