DBA Data[Home] [Help]

APPS.PAY_COSTING_SUMMARY_REP_PKG dependencies on FND_FILE

Line 51: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

47: lv_end_date VARCHAR2(20) := to_char(p_end_date,'DD-MON-YYYY'); --Bug 3305391
48:
49: BEGIN
50: IF p_output_file_type ='HTML' THEN
51: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
52: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
53: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
54: IF p_payroll_name IS NULL THEN
55: lv_payroll_name:=' ';

Line 52: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

48:
49: BEGIN
50: IF p_output_file_type ='HTML' THEN
51: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
52: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
53: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
54: IF p_payroll_name IS NULL THEN
55: lv_payroll_name:=' ';
56: ELSE lv_payroll_name:= p_payroll_name;

Line 53: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

49: BEGIN
50: IF p_output_file_type ='HTML' THEN
51: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
52: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
53: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
54: IF p_payroll_name IS NULL THEN
55: lv_payroll_name:=' ';
56: ELSE lv_payroll_name:= p_payroll_name;
57: END IF;

Line 81: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(

77: ELSE lv_sort_order2:=p_sort_order2;
78: END IF;
79: END IF;
80: hr_utility.set_location(gv_package_name || '.formated_title_page.',10);
81: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(
82: p_input_string=>'Business Group: '
83: ,p_output_file_type=>p_output_file_type
84: ,p_bold=>'N')||
85: pay_us_payroll_utils.formated_data_string(

Line 91: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

87: ,p_output_file_type=>p_output_file_type
88: ,p_bold=>'N'));
89:
90: IF p_output_file_type ='HTML' THEN
91: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
92: END IF;
93:
94: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(
95: p_input_string=>'Costing Effective Date Begin: '

Line 94: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(

90: IF p_output_file_type ='HTML' THEN
91: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
92: END IF;
93:
94: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(
95: p_input_string=>'Costing Effective Date Begin: '
96: ,p_output_file_type=>p_output_file_type
97: ,p_bold=>'N')||
98: pay_us_payroll_utils.formated_data_string(

Line 105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

101: ,p_bold=>'N'));
102:
103:
104: IF p_output_file_type ='HTML' THEN
105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
106: END IF;
107:
108: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(
109: p_input_string=>'Costing Effective Date End: '

Line 108: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(

104: IF p_output_file_type ='HTML' THEN
105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
106: END IF;
107:
108: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(
109: p_input_string=>'Costing Effective Date End: '
110: ,p_output_file_type=>p_output_file_type
111: ,p_bold=>'N')||
112: pay_us_payroll_utils.formated_data_string(

Line 119: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

115: ,p_bold=>'N'));
116:
117:
118: IF p_output_file_type ='HTML' THEN
119: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
120: END IF;
121:
122: IF p_costing IS NOT NULL THEN
123: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(

Line 123: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(

119: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
120: END IF;
121:
122: IF p_costing IS NOT NULL THEN
123: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(
124: p_input_string=>'Costing Process: '
125: ,p_output_file_type=>p_output_file_type
126: ,p_bold=>'N')||
127: pay_us_payroll_utils.formated_data_string(

Line 132: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(

128: p_input_string=>lv_start_date ||'('||p_costing||')'
129: ,p_output_file_type=>p_output_file_type
130: ,p_bold=>'N'));
131: ELSE
132: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(
133: p_input_string=>'Costing Process: '
134: ,p_output_file_type=>p_output_file_type
135: ,p_bold=>'N'));
136: END IF;

Line 141: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

137:
138:
139:
140: IF p_output_file_type ='HTML' THEN
141: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
142: END IF;
143:
144: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(
145: p_input_string=>'Payroll Name: '

Line 144: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(

140: IF p_output_file_type ='HTML' THEN
141: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
142: END IF;
143:
144: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(
145: p_input_string=>'Payroll Name: '
146: ,p_output_file_type=>p_output_file_type
147: ,p_bold=>'N')||
148: pay_us_payroll_utils.formated_data_string(

Line 155: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

151: ,p_bold=>'N'));
152:
153:
154: IF p_output_file_type ='HTML' THEN
155: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
156: END IF;
157:
158: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(
159: p_input_string=>'Consolidation Set: '

Line 158: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(

154: IF p_output_file_type ='HTML' THEN
155: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
156: END IF;
157:
158: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(
159: p_input_string=>'Consolidation Set: '
160: ,p_output_file_type=>p_output_file_type
161: ,p_bold=>'N')||
162: pay_us_payroll_utils.formated_data_string(

Line 169: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

165: ,p_bold=>'N'));
166:
167:
168: IF p_output_file_type ='HTML' THEN
169: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
170: END IF;
171:
172: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(
173: p_input_string=>'GRE: '

Line 172: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(

168: IF p_output_file_type ='HTML' THEN
169: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
170: END IF;
171:
172: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(
173: p_input_string=>'GRE: '
174: ,p_output_file_type=>p_output_file_type
175: ,p_bold=>'N')||
176: pay_us_payroll_utils.formated_data_string(

Line 183: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

179: ,p_bold=>'N'));
180:
181:
182: IF p_output_file_type ='HTML' THEN
183: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
184: END IF;
185:
186: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(
187: p_input_string=>'Include Accruals: '

Line 186: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(

182: IF p_output_file_type ='HTML' THEN
183: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
184: END IF;
185:
186: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(
187: p_input_string=>'Include Accruals: '
188: ,p_output_file_type=>p_output_file_type
189: ,p_bold=>'N')||
190: pay_us_payroll_utils.formated_data_string(

Line 197: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

193: ,p_bold=>'N'));
194:
195:
196: IF p_output_file_type ='HTML' THEN
197: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
198: END IF;
199:
200: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(
201: p_input_string=>'Sort Option One: '

Line 200: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(

196: IF p_output_file_type ='HTML' THEN
197: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
198: END IF;
199:
200: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(
201: p_input_string=>'Sort Option One: '
202: ,p_output_file_type=>p_output_file_type
203: ,p_bold=>'N')||
204: pay_us_payroll_utils.formated_data_string(

Line 211: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

207: ,p_bold=>'N'));
208:
209:
210: IF p_output_file_type ='HTML' THEN
211: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
212: END IF;
213:
214: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(
215: p_input_string=>'Sort Option Two: '

Line 214: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(

210: IF p_output_file_type ='HTML' THEN
211: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
212: END IF;
213:
214: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_data_string(
215: p_input_string=>'Sort Option Two: '
216: ,p_output_file_type=>p_output_file_type
217: ,p_bold=>'N')||
218: pay_us_payroll_utils.formated_data_string(

Line 225: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '


');

221: ,p_bold=>'N'));
222:
223:
224: IF p_output_file_type ='HTML' THEN
225: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
226: END IF;
227: hr_utility.set_location(gv_package_name || '.formated_title_page.',20);
228:
229: END formated_title_page;

Line 1247: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_header_string(

1243: END IF;
1244: CLOSE c_costing_flex_id;
1245: lv_header_label:=lv_header_label||lv_header_label2;
1246:
1247: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_header_string(
1248: gv_title
1249: ,p_output_file_type
1250: ));
1251: OPEN c_get_organization_name(p_business_group_id);

Line 1310: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

1306: ** the body and table before printing the header info, otherwISe
1307: ** just print the header information.
1308: ****************************************************************/
1309: IF p_output_file_type ='HTML' THEN
1310: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1311: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1312: END IF;
1313:
1314: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label);

Line 1311: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

1307: ** just print the header information.
1308: ****************************************************************/
1309: IF p_output_file_type ='HTML' THEN
1310: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1311: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1312: END IF;
1313:
1314: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label);
1315:

Line 1314: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label);

1310: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1311: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1312: END IF;
1313:
1314: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label);
1315:
1316: IF p_output_file_type ='HTML' THEN
1317: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1318: END IF;

Line 1317: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

1313:
1314: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label);
1315:
1316: IF p_output_file_type ='HTML' THEN
1317: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1318: END IF;
1319:
1320: OPEN c_get_session_id;
1321: FETCH c_get_session_id into lv_session_id;

Line 1675: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

1671: IF p_output_file_type ='HTML' THEN
1672: lv_data_row := '

' || lv_data_row || '' ;
1673: END IF;
1674:
1675: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1676:
1677: /*****************************************************************
1678: ** initialize Data varaibles
1679: *****************************************************************/

Line 1686: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

1682: lv_data_row2 := null;
1683:
1684: END LOOP;
1685: IF p_output_file_type='HTML' THEN
1686: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1687: END IF;
1688: CLOSE c_asg_costing_details;
1689:
1690: /*display totals by sort order 1*/

Line 1701: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_header_string(

1697: gv_title2:='Costing Summary Report - Payroll Totals';
1698: lv_total_heading:= 'GRE Totals';
1699: END IF;
1700:
1701: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_header_string(
1702: gv_title1
1703: ,p_output_file_type
1704: ));
1705: IF p_output_file_type ='HTML' THEN

Line 1707: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

1703: ,p_output_file_type
1704: ));
1705: IF p_output_file_type ='HTML' THEN
1706:
1707: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1708: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1709: END IF;
1710:
1711: formated_totals_header(p_sort_order1,p_output_file_type,lv_header_label1,lv_header_label2);

Line 1708: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

1704: ));
1705: IF p_output_file_type ='HTML' THEN
1706:
1707: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1708: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1709: END IF;
1710:
1711: formated_totals_header(p_sort_order1,p_output_file_type,lv_header_label1,lv_header_label2);
1712: lv_header_label1:=lv_header_label1 || lv_cost_flex_header;

Line 1717: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label2);

1713: lv_header_label2:=lv_header_label1 || lv_header_label2;
1714:
1715: hr_utility.set_location(gv_package_name || '.costing_summary', 90);
1716:
1717: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label2);
1718:
1719:
1720: OPEN c_costing_summary_rpt_details (lv_session_id
1721: ,p_business_group_id

Line 1857: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

1853: IF p_output_file_type ='HTML' THEN
1854: lv_data_row := '

' || lv_data_row || '' ;
1855: END IF;
1856:
1857: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1858:
1859: /*****************************************************************
1860: ** initialize Data varaibles
1861: *****************************************************************/

Line 1869: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

1865:
1866: END LOOP;
1867: CLOSE c_costing_summary_rpt_details;
1868: IF p_output_file_type='HTML' THEN
1869: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1870: END IF;
1871:
1872: /*Display GRE/Payroll Totals*/
1873:

Line 1875: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
' || lv_total_heading || '

');

1871:
1872: /*Display GRE/Payroll Totals*/
1873:
1874: IF p_output_file_type='HTML' THEN
1875: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

' || lv_total_heading || '

');
1876: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1877: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1878: ELSE
1879: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, pay_us_payroll_utils.formated_data_string(

Line 1876: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

1872: /*Display GRE/Payroll Totals*/
1873:
1874: IF p_output_file_type='HTML' THEN
1875: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

' || lv_total_heading || '

');
1876: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1877: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1878: ELSE
1879: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, pay_us_payroll_utils.formated_data_string(
1880: p_input_string=>lv_total_heading

Line 1877: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

1873:
1874: IF p_output_file_type='HTML' THEN
1875: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

' || lv_total_heading || '

');
1876: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1877: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1878: ELSE
1879: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, pay_us_payroll_utils.formated_data_string(
1880: p_input_string=>lv_total_heading
1881: ,p_output_file_type=>p_output_file_type

Line 1879: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, pay_us_payroll_utils.formated_data_string(

1875: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

' || lv_total_heading || '

');
1876: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1877: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1878: ELSE
1879: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, pay_us_payroll_utils.formated_data_string(
1880: p_input_string=>lv_total_heading
1881: ,p_output_file_type=>p_output_file_type
1882: ,p_bold=>'N'));
1883: END IF;

Line 1889: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label);

1885:
1886: formated_cons_totals_header1(p_sort_order1,p_output_file_type,lv_header_label);
1887: hr_utility.set_location(gv_package_name || '.costing_summary', 110);
1888:
1889: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label);
1890:
1891: OPEN c_get_gre_or_payroll_totals (lv_session_id
1892: ,p_business_group_id
1893: ,'CSR'

Line 1920: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

1916: IF p_output_file_type ='HTML' THEN
1917: lv_data_row := '

' || lv_data_row || '' ;
1918: END IF;
1919:
1920: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1921:
1922: /*****************************************************************
1923: ** initialize Data varaibles
1924: *****************************************************************/

Line 1932: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

1928: END LOOP;
1929: CLOSE c_get_gre_or_payroll_totals;
1930:
1931: IF p_output_file_type='HTML' THEN
1932: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1933: END IF;
1934:
1935: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_header_string(
1936: 'Costing Summary Report - Grand Totals'

Line 1935: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_header_string(

1931: IF p_output_file_type='HTML' THEN
1932: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1933: END IF;
1934:
1935: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_header_string(
1936: 'Costing Summary Report - Grand Totals'
1937: ,p_output_file_type
1938: ));
1939: IF p_output_file_type ='HTML' THEN

Line 1941: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

1937: ,p_output_file_type
1938: ));
1939: IF p_output_file_type ='HTML' THEN
1940:
1941: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1942: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1943: END IF;
1944:
1945: formated_grand_totals_header(p_output_file_type,lv_header_label1);

Line 1942: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

1938: ));
1939: IF p_output_file_type ='HTML' THEN
1940:
1941: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1942: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1943: END IF;
1944:
1945: formated_grand_totals_header(p_output_file_type,lv_header_label1);
1946: lv_header_label1:=lv_cost_flex_header || lv_header_label1;

Line 1947: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label1);

1943: END IF;
1944:
1945: formated_grand_totals_header(p_output_file_type,lv_header_label1);
1946: lv_header_label1:=lv_cost_flex_header || lv_header_label1;
1947: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label1);
1948:
1949:
1950: OPEN c_costing_grand_totals (lv_session_id
1951: ,p_business_group_id

Line 2083: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

2079: IF p_output_file_type ='HTML' THEN
2080: lv_data_row := '

' || lv_data_row || '' ;
2081: END IF;
2082:
2083: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
2084:
2085: /*****************************************************************
2086: ** initialize Data varaibles
2087: *****************************************************************/

Line 2094: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

2090: lv_data_row2 := null;
2091: END LOOP;
2092: CLOSE c_costing_grand_totals;
2093: IF p_output_file_type='HTML' THEN
2094: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2095: END IF;
2096:
2097: /* display report totals*/
2098: IF p_output_file_type='HTML' THEN

Line 2099: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
' || 'Report Totals' || '

');

2095: END IF;
2096:
2097: /* display report totals*/
2098: IF p_output_file_type='HTML' THEN
2099: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

' || 'Report Totals' || '

');
2100: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2102: ELSE
2103: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, pay_us_payroll_utils.formated_data_string(

Line 2100: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

2096:
2097: /* display report totals*/
2098: IF p_output_file_type='HTML' THEN
2099: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

' || 'Report Totals' || '

');
2100: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
2101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2102: ELSE
2103: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, pay_us_payroll_utils.formated_data_string(
2104: p_input_string=>'Report Totals'

Line 2101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

2097: /* display report totals*/
2098: IF p_output_file_type='HTML' THEN
2099: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

' || 'Report Totals' || '

');
2100: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
2101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2102: ELSE
2103: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, pay_us_payroll_utils.formated_data_string(
2104: p_input_string=>'Report Totals'
2105: ,p_output_file_type=>p_output_file_type

Line 2103: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, pay_us_payroll_utils.formated_data_string(

2099: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

' || 'Report Totals' || '

');
2100: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
2101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2102: ELSE
2103: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, pay_us_payroll_utils.formated_data_string(
2104: p_input_string=>'Report Totals'
2105: ,p_output_file_type=>p_output_file_type
2106: ,p_bold=>'N'));
2107: END IF;

Line 2112: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label);

2108:
2109: formated_cons_totals_header2(p_output_file_type,lv_header_label);
2110: hr_utility.set_location(gv_package_name || '.costing_summary', 140);
2111:
2112: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label);
2113:
2114:
2115: OPEN c_get_report_totals(lv_session_id,p_business_group_id,'CSR');
2116: LOOP

Line 2139: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

2135: IF p_output_file_type ='HTML' THEN
2136: lv_data_row := '

' || lv_data_row || '' ;
2137: END IF;
2138:
2139: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
2140:
2141: /****************************************************************
2142: ** initialize Data varaibles
2143: *****************************************************************/