');
1241: ** the body and table before printing the header info, otherwISe
1242: ** just print the header information.
1243: ****************************************************************/
1244: IF p_output_file_type ='HTML' THEN
1245: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1246: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1247: END IF;
1248:
1249: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label);
Line 1246: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1242: ** just print the header information.
1243: ****************************************************************/
1244: IF p_output_file_type ='HTML' THEN
1245: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1246: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1247: END IF;
1248:
1249: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label);
1250:
Line 1249: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label);
1245: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1246: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1247: END IF;
1248:
1249: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label);
1250:
1251: IF p_output_file_type ='HTML' THEN
1252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1253: END IF;
Line 1252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1248:
1249: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label);
1250:
1251: IF p_output_file_type ='HTML' THEN
1252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1253: END IF;
1254:
1255: OPEN c_get_session_id;
1256: FETCH c_get_session_id into lv_session_id;
Line 1580: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1576: IF p_output_file_type ='HTML' THEN
1577: lv_data_row := '
' || lv_data_row || '
' ;
1578: END IF;
1579:
1580: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1581:
1582: /*****************************************************************
1583: ** initialize Data varaibles
1584: *****************************************************************/
Line 1591: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1587: lv_data_row2 := null;
1588:
1589: END LOOP;
1590: IF p_output_file_type='HTML' THEN
1591: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1592: END IF;
1593: CLOSE c_asg_costing_details;
1594:
1595: /*display totals by sort order 1*/
Line 1606: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_header_string(
1602: gv_title2:='Costing Summary Report - Payroll Totals';
1603: lv_total_heading:= 'GRE Totals';
1604: END IF;
1605:
1606: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_header_string(
1607: gv_title1
1608: ,p_output_file_type
1609: ));
1610: IF p_output_file_type ='HTML' THEN
Line 1612: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1608: ,p_output_file_type
1609: ));
1610: IF p_output_file_type ='HTML' THEN
1611:
1612: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1613: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1614: END IF;
1615:
1616: formated_totals_header(p_sort_order1,p_output_file_type,lv_header_label1,lv_header_label2);
Line 1613: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1609: ));
1610: IF p_output_file_type ='HTML' THEN
1611:
1612: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1613: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1614: END IF;
1615:
1616: formated_totals_header(p_sort_order1,p_output_file_type,lv_header_label1,lv_header_label2);
1617: lv_header_label1:=lv_header_label1 || lv_cost_flex_header;
Line 1622: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label2);
1618: lv_header_label2:=lv_header_label1 || lv_header_label2;
1619:
1620: hr_utility.set_location(gv_package_name || '.costing_summary', 90);
1621:
1622: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label2);
1623:
1624:
1625: OPEN c_costing_summary_rpt_details (lv_session_id
1626: ,p_business_group_id
Line 1762: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1758: IF p_output_file_type ='HTML' THEN
1759: lv_data_row := '
' || lv_data_row || '
' ;
1760: END IF;
1761:
1762: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1763:
1764: /*****************************************************************
1765: ** initialize Data varaibles
1766: *****************************************************************/
Line 1774: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1770:
1771: END LOOP;
1772: CLOSE c_costing_summary_rpt_details;
1773: IF p_output_file_type='HTML' THEN
1774: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1775: END IF;
1776:
1777: /*Display GRE/Payroll Totals*/
1778:
Line 1780: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
' || lv_total_heading || '');
1776:
1777: /*Display GRE/Payroll Totals*/
1778:
1779: IF p_output_file_type='HTML' THEN
1780: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
' || lv_total_heading || '');
1781: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1782: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1783: ELSE
1784: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, pay_us_payroll_utils.formated_data_string(
Line 1781: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1777: /*Display GRE/Payroll Totals*/
1778:
1779: IF p_output_file_type='HTML' THEN
1780: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
' || lv_total_heading || '');
1781: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1782: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1783: ELSE
1784: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, pay_us_payroll_utils.formated_data_string(
1785: p_input_string=>lv_total_heading
Line 1782: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1778:
1779: IF p_output_file_type='HTML' THEN
1780: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
' || lv_total_heading || '');
1781: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1782: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1783: ELSE
1784: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, pay_us_payroll_utils.formated_data_string(
1785: p_input_string=>lv_total_heading
1786: ,p_output_file_type=>p_output_file_type
Line 1784: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, pay_us_payroll_utils.formated_data_string(
1780: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
' || lv_total_heading || '');
1781: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1782: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1783: ELSE
1784: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, pay_us_payroll_utils.formated_data_string(
1785: p_input_string=>lv_total_heading
1786: ,p_output_file_type=>p_output_file_type
1787: ,p_bold=>'N'));
1788: END IF;
Line 1794: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label);
1790:
1791: formated_cons_totals_header1(p_sort_order1,p_output_file_type,lv_header_label);
1792: hr_utility.set_location(gv_package_name || '.costing_summary', 110);
1793:
1794: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label);
1795:
1796: OPEN c_get_gre_or_payroll_totals (lv_session_id
1797: ,p_business_group_id
1798: ,'CSR'
Line 1825: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1821: IF p_output_file_type ='HTML' THEN
1822: lv_data_row := '
' || lv_data_row || '
' ;
1823: END IF;
1824:
1825: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1826:
1827: /*****************************************************************
1828: ** initialize Data varaibles
1829: *****************************************************************/
Line 1837: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1833: END LOOP;
1834: CLOSE c_get_gre_or_payroll_totals;
1835:
1836: IF p_output_file_type='HTML' THEN
1837: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1838: END IF;
1839:
1840: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_header_string(
1841: 'Costing Summary Report - Grand Totals'
Line 1840: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_header_string(
1836: IF p_output_file_type='HTML' THEN
1837: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1838: END IF;
1839:
1840: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_header_string(
1841: 'Costing Summary Report - Grand Totals'
1842: ,p_output_file_type
1843: ));
1844: IF p_output_file_type ='HTML' THEN
Line 1846: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1842: ,p_output_file_type
1843: ));
1844: IF p_output_file_type ='HTML' THEN
1845:
1846: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1847: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1848: END IF;
1849:
1850: formated_grand_totals_header(p_output_file_type,lv_header_label1);
Line 1847: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1843: ));
1844: IF p_output_file_type ='HTML' THEN
1845:
1846: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1847: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1848: END IF;
1849:
1850: formated_grand_totals_header(p_output_file_type,lv_header_label1);
1851: lv_header_label1:=lv_cost_flex_header || lv_header_label1;
Line 1852: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label1);
1848: END IF;
1849:
1850: formated_grand_totals_header(p_output_file_type,lv_header_label1);
1851: lv_header_label1:=lv_cost_flex_header || lv_header_label1;
1852: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label1);
1853:
1854:
1855: OPEN c_costing_grand_totals (lv_session_id
1856: ,p_business_group_id
Line 1988: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1984: IF p_output_file_type ='HTML' THEN
1985: lv_data_row := '
' || lv_data_row || '
' ;
1986: END IF;
1987:
1988: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1989:
1990: /*****************************************************************
1991: ** initialize Data varaibles
1992: *****************************************************************/
Line 1999: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1995: lv_data_row2 := null;
1996: END LOOP;
1997: CLOSE c_costing_grand_totals;
1998: IF p_output_file_type='HTML' THEN
1999: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
2000: END IF;
2001:
2002: /* display report totals*/
2003: IF p_output_file_type='HTML' THEN
Line 2004: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
' || 'Report Totals' || '');
2000: END IF;
2001:
2002: /* display report totals*/
2003: IF p_output_file_type='HTML' THEN
2004: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
' || 'Report Totals' || '');
2005: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2006: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2007: ELSE
2008: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, pay_us_payroll_utils.formated_data_string(
Line 2005: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
2001:
2002: /* display report totals*/
2003: IF p_output_file_type='HTML' THEN
2004: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
' || 'Report Totals' || '');
2005: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2006: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2007: ELSE
2008: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, pay_us_payroll_utils.formated_data_string(
2009: p_input_string=>'Report Totals'
Line 2006: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2002: /* display report totals*/
2003: IF p_output_file_type='HTML' THEN
2004: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
' || 'Report Totals' || '');
2005: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2006: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2007: ELSE
2008: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, pay_us_payroll_utils.formated_data_string(
2009: p_input_string=>'Report Totals'
2010: ,p_output_file_type=>p_output_file_type
Line 2008: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, pay_us_payroll_utils.formated_data_string(
2004: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
' || 'Report Totals' || '');
2005: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2006: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2007: ELSE
2008: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, pay_us_payroll_utils.formated_data_string(
2009: p_input_string=>'Report Totals'
2010: ,p_output_file_type=>p_output_file_type
2011: ,p_bold=>'N'));
2012: END IF;
Line 2017: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label);
2013:
2014: formated_cons_totals_header2(p_output_file_type,lv_header_label);
2015: hr_utility.set_location(gv_package_name || '.costing_summary', 140);
2016:
2017: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label);
2018:
2019:
2020: OPEN c_get_report_totals(lv_session_id,p_business_group_id,'CSR');
2021: LOOP
Line 2044: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
2040: IF p_output_file_type ='HTML' THEN
2041: lv_data_row := '
' || lv_data_row || '
' ;
2042: END IF;
2043:
2044: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
2045:
2046: /****************************************************************
2047: ** initialize Data varaibles
2048: *****************************************************************/