DBA Data[Home] [Help]

APPS.PAY_JP_SPR_EFILE_PKG dependencies on UTL_FILE

Line 339: file_out utl_file.file_type);

335: g_body_tbl t_body_tbl;
336: --
337: type t_file_rec is record(
338: file_name varchar2(80),
339: file_out utl_file.file_type);
340: type t_file_tbl is table of t_file_rec index by binary_integer;
341: g_file_tbl t_file_tbl;
342: --
343: type t_summary_rec is record(

Line 2363: l_file_out utl_file.file_type;

2359: l_where_clause varchar2(32767);
2360: l_order_by_clause varchar2(255);
2361: --
2362: l_file_name varchar2(80);
2363: l_file_out utl_file.file_type;
2364: l_file_cnt number;
2365: l_file_over_start number;
2366: --
2367: l_data_tbl t_data_tbl;

Line 3299: -- file open cannot be done here because of utl_file open file max 50

3295: hr_utility.set_location(l_proc,60);
3296: hr_utility.trace('g_file_tbl.count : '||to_char(g_file_tbl.count));
3297: end if;
3298: --
3299: -- file open cannot be done here because of utl_file open file max 50
3300: --
3301: if g_debug
3302: and g_detail_debug = 'Y' then
3303: --

Line 4337: l_file_out utl_file.file_type;

4333: l_mag_assignment_action_id number;
4334: --
4335: l_file_ind number;
4336: l_file_name varchar2(80);
4337: l_file_out utl_file.file_type;
4338: l_file_assact varchar2(32767);
4339: l_address varchar2(500);
4340: --
4341:

Line 4868: l_file_out utl_file.file_type;

4864: l_proc varchar2(80) := c_package||'gen_file';
4865: --
4866: l_ass_cnt number := 0;
4867: --
4868: l_file_out utl_file.file_type;
4869: l_open_file_tbl t_number_tbl;
4870: l_open_file_ind number;
4871: l_found boolean := false;
4872: --