');
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: *****************************************************************/