DBA Data[Home] [Help]

APPS.PER_MX_SSAFFL_EXTRACT_PKG dependencies on HR_UTILITY

Line 74: hr_utility.set_location(gv_package_name || '.formated_data_string', 10);

70: lv_bold varchar2(1);
71: BEGIN
72: lv_bold :='N' ;
73:
74: hr_utility.set_location(gv_package_name || '.formated_data_string', 10);
75: if g_output_file_type = 'CSV' then
76: hr_utility.set_location(gv_package_name || '.formated_data_string', 20);
77: lv_format := gc_csv_data_delimiter || p_input_string ||
78: gc_csv_data_delimiter || gc_csv_delimiter;

Line 76: hr_utility.set_location(gv_package_name || '.formated_data_string', 20);

72: lv_bold :='N' ;
73:
74: hr_utility.set_location(gv_package_name || '.formated_data_string', 10);
75: if g_output_file_type = 'CSV' then
76: hr_utility.set_location(gv_package_name || '.formated_data_string', 20);
77: lv_format := gc_csv_data_delimiter || p_input_string ||
78: gc_csv_data_delimiter || gc_csv_delimiter;
79: elsif g_output_file_type = 'HTML' then
80: if p_input_string is null then

Line 81: hr_utility.set_location(gv_package_name || '.formated_data_string', 30);

77: lv_format := gc_csv_data_delimiter || p_input_string ||
78: gc_csv_data_delimiter || gc_csv_delimiter;
79: elsif g_output_file_type = 'HTML' then
80: if p_input_string is null then
81: hr_utility.set_location(gv_package_name || '.formated_data_string', 30);
82: lv_format := gv_html_start_data || '\ ' || gv_html_end_data;
83: else
84: if lv_bold = 'Y' then
85: hr_utility.set_location(gv_package_name || '.formated_data_string', 40);

Line 85: hr_utility.set_location(gv_package_name || '.formated_data_string', 40);

81: hr_utility.set_location(gv_package_name || '.formated_data_string', 30);
82: lv_format := gv_html_start_data || '\ ' || gv_html_end_data;
83: else
84: if lv_bold = 'Y' then
85: hr_utility.set_location(gv_package_name || '.formated_data_string', 40);
86: lv_format := gv_html_start_data || ' ' || p_input_string
87: || '' || gv_html_end_data;
88: else
89: hr_utility.set_location(gv_package_name || '.formated_data_string', 50);

Line 89: hr_utility.set_location(gv_package_name || '.formated_data_string', 50);

85: hr_utility.set_location(gv_package_name || '.formated_data_string', 40);
86: lv_format := gv_html_start_data || ' ' || p_input_string
87: || '' || gv_html_end_data;
88: else
89: hr_utility.set_location(gv_package_name || '.formated_data_string', 50);
90: lv_format := gv_html_start_data || p_input_string || gv_html_end_data;
91: end if;
92: end if;
93: end if;

Line 95: hr_utility.set_location(gv_package_name || '.formated_data_string', 60);

91: end if;
92: end if;
93: end if;
94:
95: hr_utility.set_location(gv_package_name || '.formated_data_string', 60);
96: return lv_format;
97:
98: END formated_data_string;
99:

Line 112: hr_utility.set_location(gv_package_name || '.formated_header_string', 10);

108:
109: lv_format varchar2(1000);
110:
111: BEGIN
112: hr_utility.set_location(gv_package_name || '.formated_header_string', 10);
113: if g_output_file_type = 'CSV' then
114: hr_utility.set_location(gv_package_name || '.formated_header_string', 20);
115: lv_format := p_input_string;
116: elsif g_output_file_type = 'HTML' then

Line 114: hr_utility.set_location(gv_package_name || '.formated_header_string', 20);

110:
111: BEGIN
112: hr_utility.set_location(gv_package_name || '.formated_header_string', 10);
113: if g_output_file_type = 'CSV' then
114: hr_utility.set_location(gv_package_name || '.formated_header_string', 20);
115: lv_format := p_input_string;
116: elsif g_output_file_type = 'HTML' then
117: hr_utility.set_location(gv_package_name || '.formated_header_string', 30);
118: lv_format := '

' || p_input_string ||

Line 117: hr_utility.set_location(gv_package_name || '.formated_header_string', 30);

113: if g_output_file_type = 'CSV' then
114: hr_utility.set_location(gv_package_name || '.formated_header_string', 20);
115: lv_format := p_input_string;
116: elsif g_output_file_type = 'HTML' then
117: hr_utility.set_location(gv_package_name || '.formated_header_string', 30);
118: lv_format := '

' || p_input_string ||
119: '

';
120: end if;
121:

Line 122: hr_utility.set_location(gv_package_name || '.formated_header_string', 40);

118: lv_format := '

' || p_input_string ||
119: '

';
120: end if;
121:
122: hr_utility.set_location(gv_package_name || '.formated_header_string', 40);
123: return lv_format;
124:
125: END formated_header_string;
126:

Line 231: hr_utility.set_location(gv_package_name || '.ssaffl_extract', 10);

227:
228:
229: lv_data_row := null ;
230:
231: hr_utility.set_location(gv_package_name || '.ssaffl_extract', 10);
232:
233: if p_affl_type = 'HIRES' then
234: lv_title1 := 'Soical Security Hire/Rehire Affiliation Transactions' ;
235: elsif p_affl_type ='SEPARATIONS' then

Line 251: hr_utility.set_location(gv_package_name || '.ssaffl_extract', 20);

247: */
248:
249:
250: if p_affl_type='HIRES' then
251: hr_utility.set_location(gv_package_name || '.ssaffl_extract', 20);
252: open c_HIRE_details(p_tax_unit_id );
253: loop
254: fetch c_HIRE_details into lv_data_row;
255: if c_HIRE_details%notfound then

Line 256: hr_utility.set_location(gv_package_name || '.ssaffl_extract', 100);

252: open c_HIRE_details(p_tax_unit_id );
253: loop
254: fetch c_HIRE_details into lv_data_row;
255: if c_HIRE_details%notfound then
256: hr_utility.set_location(gv_package_name || '.ssaffl_extract', 100);
257: exit;
258: end if;
259: if g_output_file_type ='HTML' then
260: lv_data_row := '' || lv_data_row || '' ;

Line 278: hr_utility.set_location(gv_package_name || '.ssaffl_extract', 30);

274:
275:
276: elsif p_affl_type='SEPARATIONS' then
277:
278: hr_utility.set_location(gv_package_name || '.ssaffl_extract', 30);
279: open c_SEP_details(p_tax_unit_id );
280: loop
281: fetch c_sep_details into lv_data_row ;
282: if c_sep_details%notfound then

Line 283: hr_utility.set_location(gv_package_name || '.ssaffl_extract', 100);

279: open c_SEP_details(p_tax_unit_id );
280: loop
281: fetch c_sep_details into lv_data_row ;
282: if c_sep_details%notfound then
283: hr_utility.set_location(gv_package_name || '.ssaffl_extract', 100);
284: exit;
285: end if;
286: if g_output_file_type ='HTML' then
287: lv_data_row := '' || lv_data_row || '' ;

Line 302: hr_utility.set_location(gv_package_name || '.ssaffl_extract', 40);

298: and action_information_category = 'MX SS SEPARATION DETAILS'
299: and action_information22 ='A' ;
300:
301: end if;
302: hr_utility.set_location(gv_package_name || '.ssaffl_extract', 40);
303:
304: if p_output_file_type ='HTML' then
305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
306: end if;

Line 312: --hr_utility.trace_on(null, 'ELE');

308:
309: END ssaffl_extract;
310:
311: --begin
312: --hr_utility.trace_on(null, 'ELE');
313: end per_mx_ssaffl_extract_pkg;