eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_US_EEO4A_PKG dependencies on FND_FILE

Line 336: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

332: ELSIF p_function_code = 150 THEN
333: l_xml_string := convert_into_xml('G_FUN_15_CHECK_VAL','true','D');
334: END IF;
335:
336: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
337: END check_function;
338:
339: /**procedure to generate_sql**/
340: PROCEDURE generate_sql(p_job_codes IN VARCHAR2 , p_dynamic_where IN VARCHAR2) IS

Line 842: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

838: PROCEDURE generate_header_xml_data IS
839: BEGIN
840:
841: l_xml_string := ' ';
842: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
843:
844: END generate_header_xml_data;
845:
846: /** procedure to generate the footer xml data **/

Line 872: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

868:
869:
870: ';
871:
872: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
873:
874: END generate_footer_xml_data;
875:
876: /** procedure to generate jurisdiction and certifying officer xml data**/

Line 936: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

932: END LOOP;
933:
934: l_xml_string := l_xml_string || '';
935:
936: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
937:
938: /**get jurisdiction details **/
939: l_xml_string := '';
940:

Line 957: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

953: END LOOP;
954:
955: l_xml_string := l_xml_string || '';
956:
957: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
958:
959: END generate_juris_cert_xml_data;
960:
961: /**Procedure to generate full time employees table xml data**/

Line 1005: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

1001: l_xml_string := '';
1002: l_xml_string := l_xml_string || convert_into_xml('EMPLOYEE_SALARY_EMPLOYMENT_CAT','1. FULL-TIME EMPLOYEES (Temporary employees are not included)','D');
1003: l_xml_string := l_xml_string || '';
1004:
1005: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1006:
1007: FOR i IN get_eeo4_lookup_details LOOP --for each job category
1008:
1009: l_lookup_code := i.lookup_code;

Line 1044: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

1040: l_xml_string := l_xml_string || convert_into_xml('FUNCTION_NUMBERS',g_function_numbers,'D');
1041: END IF;
1042:
1043: l_xml_string := l_xml_string || '';
1044: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1045: END IF;
1046:
1047: l_xml_string := '';
1048:

Line 1084: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

1080: l_xml_string := l_xml_string || convert_into_xml('NO_CONS_OFEMALE_EMPS',ft_emp_table(counter).no_cons_ofemale_emps,'D');
1081:
1082: l_xml_string := l_xml_string || '';
1083:
1084: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1085:
1086: g_line_number := g_line_number + 1 ;-- Increment the line number
1087:
1088: END IF;

Line 1094: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

1090: END LOOP; --END OF FOR EACH SALARY RANGE
1091:
1092: l_xml_string := '';
1093:
1094: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1095: END LOOP;--End for each job category
1096:
1097: l_xml_string := '';
1098: l_xml_string := l_xml_string || convert_into_xml('CF_TOTAL_TITLE',g_line_number||'. TOTAL FULL-TIME (LINES 1-64)','D');

Line 1116: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

1112:
1113: l_xml_string := l_xml_string || convert_into_xml('CS_TOTAL_CATEGORY_EMPS', l_cs_total_category_emps,'D');
1114: l_xml_string := l_xml_string || '';
1115:
1116: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1117:
1118: END generate_ft_xml_data;
1119:
1120: /**Procedure to generate the Other than full time employees table data **/

Line 1152: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

1148: l_xml_string := '';
1149: l_xml_string := l_xml_string || convert_into_xml('EMPLOYEE_SALARY_EMPLOYMENT_CAT','2. OTHER THAN FULL-TIME EMPLOYEES (Including temporary employees)','D');
1150: l_xml_string := l_xml_string || '';
1151:
1152: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1153:
1154: FOR counter in 1 .. other_ft_emp_table.count LOOP -- Fetch from other_ft_emp_table
1155: IF (ltrim(rtrim(other_ft_emp_table(counter).job_function)) = ltrim(rtrim(l_function_code)))
1156: THEN

Line 1196: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

1192: l_xml_string := l_xml_string || convert_into_xml('NO_CONS_OFEMALE_EMPS',other_ft_emp_table(counter).no_cons_ofemale_emps,'D');
1193:
1194: l_xml_string := l_xml_string || '';
1195:
1196: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1197:
1198: g_line_number := g_line_number + 1;--increment the line number
1199: END IF;
1200: END LOOP;--end of fetch from other_ft_emp_table

Line 1223: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

1219: l_xml_string := l_xml_string || convert_into_xml('CS_TOTAL_CATEGORY_EMPS', l_cs_total_category_emps,'D');
1220:
1221: l_xml_string := l_xml_string || '';
1222:
1223: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1224:
1225: END generate_oft_xml_data;
1226:
1227: /**procedure to generate new hire employee xml data**/

Line 1260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

1256: l_xml_string := '';
1257: l_xml_string := l_xml_string || convert_into_xml('EMPLOYEE_SALARY_EMPLOYMENT_CAT','3. NEW HIRES DURING FISCAL YEAR - Permanent full time only JULY 1 - JUNE 30','D');
1258: l_xml_string := l_xml_string || '';
1259:
1260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1261:
1262: FOR counter in 1 .. new_hire_table.count LOOP -- Fetch from new_hire_table
1263: IF (ltrim(rtrim(new_hire_table(counter).job_function)) = ltrim(rtrim(l_function_code)))
1264: THEN

Line 1305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

1301: l_xml_string := l_xml_string || convert_into_xml('NO_CONS_OFEMALE_EMPS',new_hire_table(counter).no_cons_ofemale_emps,'D');
1302:
1303: l_xml_string := l_xml_string || '';
1304:
1305: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1306:
1307: g_line_number := g_line_number + 1; --increment the line number
1308:
1309: END IF;

Line 1333: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

1329: l_xml_string := l_xml_string || convert_into_xml('CS_TOTAL_CATEGORY_EMPS', l_cs_total_category_emps,'D');
1330:
1331: l_xml_string := l_xml_string || '';
1332:
1333: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1334:
1335: END generate_nh_xml_data;
1336:
1337: /** procedure to create the xml for all 3 categories of employees **/

Line 1344: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

1340: l_xml_string := '';
1341: l_xml_string := l_xml_string || g_function_numbers;
1342: l_xml_string := l_xml_string || '';
1343:
1344: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1345:
1346: g_line_number := g_line_number + 1; -- increment the line number
1347:
1348: -- Genarate full time employees xml data

Line 1365: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

1361: l_xml_string := ' '
1362: || convert_into_xml('CF_SET_FUNCTION_DESC',g_func_desc,'D')
1363: || '';
1364:
1365: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1366:
1367: END create_xml;
1368:
1369: /** Procedure to create the report **/

Line 1380: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

1376: BEGIN
1377: IF report_type = 1
1378: THEN
1379: l_xml_string := '';
1380: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1381:
1382: g_function_numbers := '''X''';
1383:
1384: FOR i IN 1 .. first_order_func_table.count

Line 1406: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

1402:
1403: l_xml_string := convert_into_xml('CONTROL_NUMBER',g_control_number,'D');
1404: l_xml_string := l_xml_string || convert_into_xml('FUNCTION_NUMBERS',g_function_numbers,'D');
1405:
1406: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1407:
1408: FOR i IN 1 .. first_order_func_table.count
1409: LOOP
1410: l_current_function := first_order_func_table(i).job_function;

Line 1420: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

1416: END LOOP;
1417:
1418: l_xml_string := '';
1419:
1420: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1421:
1422: g_line_number := 0;
1423:
1424: g_for_all_emp := 'T';

Line 1430: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

1426: g_for_all_emp := 'F';
1427:
1428: l_xml_string := '';
1429:
1430: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1431:
1432: ELSIF report_type = 2
1433: THEN
1434: FOR i IN 1 .. second_order_func_table.count LOOP -- For Each Function

Line 1442: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

1438: g_function_numbers := get_function_number(l_current_function);
1439:
1440: l_xml_string := '';
1441:
1442: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1443:
1444: generate_juris_cert_xml_data();
1445:
1446: l_xml_string := convert_into_xml('CONTROL_NUMBER',g_control_number,'D');

Line 1449: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

1445:
1446: l_xml_string := convert_into_xml('CONTROL_NUMBER',g_control_number,'D');
1447: l_xml_string := l_xml_string || convert_into_xml('FUNCTION_NUMBERS',g_function_numbers,'D');
1448:
1449: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1450:
1451: check_function(to_number(l_current_function));
1452:
1453: l_xml_string := '';

Line 1455: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

1451: check_function(to_number(l_current_function));
1452:
1453: l_xml_string := '';
1454:
1455: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1456:
1457: g_line_number := 0;
1458:
1459: g_for_all_emp := 'F';

Line 1464: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

1460: create_xml(l_current_function);
1461:
1462: l_xml_string := '';
1463:
1464: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1465: END LOOP;--For each Function
1466: END IF;
1467: END create_report;
1468:

Line 1796: fnd_file.put_line(fnd_file.OUTPUT, p_text);

1792: /** Procedure to write to concurrent output**/
1793: PROCEDURE write_to_concurrent_out (p_text VARCHAR2) IS
1794: BEGIN
1795:
1796: fnd_file.put_line(fnd_file.OUTPUT, p_text);
1797:
1798: END write_to_concurrent_out;
1799:
1800: END PER_US_EEO4A_PKG;