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_EEO4_PKG dependencies on FND_FILE

Line 285: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

281: ELSIF p_function_code = 150 THEN
282: l_xml_string := convert_into_xml('G_FUN_15_CHECK_VAL','true','D');
283: END IF;
284:
285: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
286: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
287: END check_function;
288:
289: -- Added Bug# 5415136

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

282: l_xml_string := convert_into_xml('G_FUN_15_CHECK_VAL','true','D');
283: END IF;
284:
285: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
286: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
287: END check_function;
288:
289: -- Added Bug# 5415136
290: /*****************************************************************************

Line 342: --fnd_file.put_line(fnd_file.log, p_text);

338: PROCEDURE write_to_concurrent_out (p_text VARCHAR2) IS
339: --
340: BEGIN
341: -- Write to the concurrent request log
342: --fnd_file.put_line(fnd_file.log, p_text);
343: -- Write to the concurrent request out
344: fnd_file.put_line(fnd_file.OUTPUT, p_text);
345:
346: END write_to_concurrent_out;

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

340: BEGIN
341: -- Write to the concurrent request log
342: --fnd_file.put_line(fnd_file.log, p_text);
343: -- Write to the concurrent request out
344: fnd_file.put_line(fnd_file.OUTPUT, p_text);
345:
346: END write_to_concurrent_out;
347:
348: PROCEDURE generate_sql(p_job_codes IN VARCHAR2 , p_dynamic_where IN VARCHAR2) IS

Line 359: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_nh_sql: '|| g_nh_sql);

355: -- ||' AND ass.employment_category in (''FR'')'
356: ||' AND ass.employment_category in ('|| g_fp_regulars ||')'
357: || g_group_order_by;
358:
359: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_nh_sql: '|| g_nh_sql);
360:
361: g_ft_emp_sql := 'SELECT hl.lookup_code job_category_code,
362: hl.meaning job_category_name,'
363: ||g_select_clause || g_from_where_clause|| g_ft_effective_dates

Line 371: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ft_emp_sql: '|| g_ft_emp_sql);

367: -- ||' AND ass.employment_category in (''FR'')'
368: ||' AND ass.employment_category in ('|| g_fp_regulars ||')'
369: || g_group_order_by;
370:
371: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ft_emp_sql: '|| g_ft_emp_sql);
372:
373: g_oft_sql := 'SELECT hl.lookup_code job_category_code,
374: hl.meaning job_category_name,'
375: ||g_select_clause||g_from_where_clause||g_ft_effective_dates

Line 382: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_oft_sql: '|| g_oft_sql);

378: -- ||' AND ass.employment_category NOT IN (''FR'')'
379: ||' AND ass.employment_category NOT IN ('|| g_fp_regulars ||')'
380: ||g_group_order_by;
381:
382: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_oft_sql: '|| g_oft_sql);
383:
384:
385: /* Commented for bug#11736960 starts
386: --Bug# 5593259

Line 396: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_tmr_nh_sql: '|| g_tmr_nh_sql);

392: -- ||' AND ass.employment_category in (''FR'')'
393: ||' AND ass.employment_category in ('||g_fp_regulars ||')'
394: || g_group_order_by;
395:
396: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_tmr_nh_sql: '|| g_tmr_nh_sql);
397:
398: g_tmr_ft_emp_sql := 'SELECT hl.lookup_code job_category_code,
399: hl.meaning job_category_name,'
400: || g_tmraces_select_clause || g_tmraces_where_clause|| g_ft_effective_dates

Line 408: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_tmr_ft_emp_sql: '|| g_tmr_ft_emp_sql);

404: -- ||' AND ass.employment_category in (''FR'')'
405: ||' AND ass.employment_category in ('|| g_fp_regulars ||')'
406: || g_group_order_by;
407:
408: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_tmr_ft_emp_sql: '|| g_tmr_ft_emp_sql);
409:
410: g_tmr_oft_sql := 'SELECT hl.lookup_code job_category_code,
411: hl.meaning job_category_name,'
412: || g_tmraces_select_clause || g_tmraces_where_clause ||g_ft_effective_dates

Line 419: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_tmr_oft_sql: '|| g_tmr_oft_sql);

415: -- ||' AND ass.employment_category NOT IN (''FR'')'
416: ||' AND ass.employment_category NOT IN ('|| g_fp_regulars ||')'
417: ||g_group_order_by;
418:
419: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_tmr_oft_sql: '|| g_tmr_oft_sql);
420: Commented for bug#11736960 ends */
421:
422: END generate_sql;
423:

Line 686: FND_FILE.PUT_LINE(FND_FILE.LOG,'G_FP_REGULARS: '||g_fp_regulars);

682: -- #13610922 changes start
683: -- Employement categories would be custom defined so building the query text
684: -- after the custom Full Time regulars status are fetched
685: --
686: FND_FILE.PUT_LINE(FND_FILE.LOG,'G_FP_REGULARS: '||g_fp_regulars);
687: -- added l_eeo4_ethnic for bug 14034810
688: l_query_text := 'select count(1) l_ft_emp_count ' || g_from_where_clause|| l_eeo4_ethnic
689: || g_ft_effective_dates || ' AND ass.employment_category in ('||g_fp_regulars||')';
690: --#13610922 changes end

Line 700: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_ft_emp_count: ' || l_ft_emp_count);

696: rows_processed := dbms_sql.EXECUTE(source_cursor);
697:
698: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
699: dbms_sql.column_value(source_cursor, 1, l_ft_emp_count);
700: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_ft_emp_count: ' || l_ft_emp_count);
701:
702: END IF;
703:
704: dbms_sql.close_cursor(source_cursor);

Line 708: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_query_text: '||l_query_text);

704: dbms_sql.close_cursor(source_cursor);
705: --added l_eeo4_ethnic for bug 14034810
706: l_query_text := 'Select job.job_information7 l_function_code,
707: count(1) l_function_count ' || g_from_where_clause || l_eeo4_ethnic || g_ft_effective_dates || ' group by job.job_information7 ';
708: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_query_text: '||l_query_text);
709: source_cursor := dbms_sql.open_cursor;
710: dbms_sql.parse(source_cursor,l_query_text,2);
711: dbms_sql.define_column_char(source_cursor,1,l_function_code,30);
712: dbms_sql.define_column(source_cursor,2,l_function_count);

Line 734: --FND_FILE.PUT_LINE(FND_FILE.LOG,' i AM IN IF (l_ft_emp_count >= p_full_time_emp_count AND l_row_count <= 14)');

730: b) Populate second_order_func_table for the rest
731: */
732:
733: IF (l_ft_emp_count >= p_full_time_emp_count AND l_row_count <= 14) THEN
734: --FND_FILE.PUT_LINE(FND_FILE.LOG,' i AM IN IF (l_ft_emp_count >= p_full_time_emp_count AND l_row_count <= 14)');
735: g_dynamic_where := g_dynamic_where || ',' || l_function_code;
736:
737: -- Commented the folowing to fix the bug# 5410130
738: /*

Line 751: --FND_FILE.PUT_LINE(FND_FILE.LOG,' i AM IN ELSIF (l_ft_emp_count >= p_full_time_emp_count AND l_row_count > 14) THEN');

747:
748: -- Commented the folowing to fix the bug# 5410130
749: /*
750: ELSIF (l_ft_emp_count >= p_full_time_emp_count AND l_row_count > 14) THEN
751: --FND_FILE.PUT_LINE(FND_FILE.LOG,' i AM IN ELSIF (l_ft_emp_count >= p_full_time_emp_count AND l_row_count > 14) THEN');
752: l_fo_funct_counter := l_fo_funct_counter + 1;
753: first_order_func_table(l_fo_funct_counter).job_function := l_function_code;
754: first_order_func_table(l_fo_funct_counter).description := l_function_desc;
755: */

Line 764: --FND_FILE.PUT_LINE(FND_FILE.LOG,' i AM IN IF (l_ft_emp_count < p_full_time_emp_count AND l_function_count >= p_emp_count_for_function) THEN ');

760: a) Populate first_order_func_table, if the function has more than 100 employees
761: b) Populate second_order_func_table for all functions
762: */
763: IF (l_ft_emp_count < p_full_time_emp_count AND l_function_count >= p_emp_count_for_function) THEN
764: --FND_FILE.PUT_LINE(FND_FILE.LOG,' i AM IN IF (l_ft_emp_count < p_full_time_emp_count AND l_function_count >= p_emp_count_for_function) THEN ');
765: g_dynamic_where := g_dynamic_where || ',' || l_function_code;
766: -- Commented the folowing to fix the bug# 5397638
767: /*
768: l_fo_funct_counter := l_fo_funct_counter + 1;

Line 776: --FND_FILE.PUT_LINE(FND_FILE.LOG,' i AM IN ELSIF (l_ft_emp_count < p_full_time_emp_count AND l_function_count < p_emp_count_for_function) THEN');

772: l_so_funct_counter := l_so_funct_counter + 1;
773: second_order_func_table(l_so_funct_counter).job_function := l_function_code;
774: second_order_func_table(l_so_funct_counter).description := l_function_desc;
775: ELSIF (l_ft_emp_count < p_full_time_emp_count AND l_function_count < p_emp_count_for_function) THEN
776: --FND_FILE.PUT_LINE(FND_FILE.LOG,' i AM IN ELSIF (l_ft_emp_count < p_full_time_emp_count AND l_function_count < p_emp_count_for_function) THEN');
777: l_fo_funct_counter := l_fo_funct_counter + 1;
778: first_order_func_table(l_fo_funct_counter).job_function := l_function_code;
779: first_order_func_table(l_fo_funct_counter).description := l_function_desc;
780: END IF;

Line 809: --FND_FILE.PUT_LINE(FND_FILE.LOG,' I am in FOR i IN 1 .. first_order_func_table.count LOOP');

805: FOR i IN 1 .. first_order_func_table.count LOOP -- For Each Function
806: l_function := first_order_func_table(i).job_function;
807: l_function_desc := first_order_func_table(i).description;
808: IF l_function <> l_current_function THEN
809: --FND_FILE.PUT_LINE(FND_FILE.LOG,' I am in FOR i IN 1 .. first_order_func_table.count LOOP');
810: l_current_function := l_function;
811:
812: IF g_job_code = '''X''' THEN
813: g_job_code := ''''|| l_current_function ||'''';

Line 822: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_job_code: '||g_job_code);

818: END IF;
819: END IF;
820: END LOOP; -- For Each Function
821:
822: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_job_code: '||g_job_code);
823: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_func_desc: '||g_func_desc);
824:
825: g_for_all_emp := 'T';
826:

Line 823: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_func_desc: '||g_func_desc);

819: END IF;
820: END LOOP; -- For Each Function
821:
822: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_job_code: '||g_job_code);
823: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_func_desc: '||g_func_desc);
824:
825: g_for_all_emp := 'T';
826:
827: -- Bug# 5410130

Line 830: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_nh_sql : '|| g_nh_sql);

826:
827: -- Bug# 5410130
828: --IF g_job_code <> '''X''' THEN
829: --generate_sql(g_job_code);
830: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_nh_sql : '|| g_nh_sql);
831: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ft_emp_sql : ' || g_ft_emp_sql);
832: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_oft_sql : ' || g_oft_sql);
833: populate_ft_emp_data(g_job_code);
834: populate_oft_emp_data(g_job_code);

Line 831: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ft_emp_sql : ' || g_ft_emp_sql);

827: -- Bug# 5410130
828: --IF g_job_code <> '''X''' THEN
829: --generate_sql(g_job_code);
830: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_nh_sql : '|| g_nh_sql);
831: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ft_emp_sql : ' || g_ft_emp_sql);
832: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_oft_sql : ' || g_oft_sql);
833: populate_ft_emp_data(g_job_code);
834: populate_oft_emp_data(g_job_code);
835: populate_nh_emp_data(g_job_code);

Line 832: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_oft_sql : ' || g_oft_sql);

828: --IF g_job_code <> '''X''' THEN
829: --generate_sql(g_job_code);
830: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_nh_sql : '|| g_nh_sql);
831: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ft_emp_sql : ' || g_ft_emp_sql);
832: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_oft_sql : ' || g_oft_sql);
833: populate_ft_emp_data(g_job_code);
834: populate_oft_emp_data(g_job_code);
835: populate_nh_emp_data(g_job_code);
836: --END IF;

Line 841: --FND_FILE.PUT_LINE(FND_FILE.LOG,'FOR i IN 1 .. second_order_func_table.count LOOP');

837:
838: g_for_all_emp := 'F';
839:
840: FOR i IN 1 .. second_order_func_table.count LOOP
841: --FND_FILE.PUT_LINE(FND_FILE.LOG,'FOR i IN 1 .. second_order_func_table.count LOOP');
842: l_function := second_order_func_table(i).job_function;
843: l_function_desc := second_order_func_table(i).description;
844: IF l_function <> l_current_function THEN
845: l_current_function := l_function;

Line 848: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_nh_sql : '|| g_nh_sql);

844: IF l_function <> l_current_function THEN
845: l_current_function := l_function;
846: l_funct_counter := l_funct_counter + 1;
847: --generate_sql(l_current_function);
848: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_nh_sql : '|| g_nh_sql);
849: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ft_emp_sql : ' || g_ft_emp_sql);
850: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_oft_sql : ' || g_oft_sql);
851: populate_ft_emp_data(l_current_function);
852: populate_oft_emp_data(l_current_function);

Line 849: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ft_emp_sql : ' || g_ft_emp_sql);

845: l_current_function := l_function;
846: l_funct_counter := l_funct_counter + 1;
847: --generate_sql(l_current_function);
848: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_nh_sql : '|| g_nh_sql);
849: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ft_emp_sql : ' || g_ft_emp_sql);
850: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_oft_sql : ' || g_oft_sql);
851: populate_ft_emp_data(l_current_function);
852: populate_oft_emp_data(l_current_function);
853: populate_nh_emp_data(l_current_function);

Line 850: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_oft_sql : ' || g_oft_sql);

846: l_funct_counter := l_funct_counter + 1;
847: --generate_sql(l_current_function);
848: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_nh_sql : '|| g_nh_sql);
849: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_ft_emp_sql : ' || g_ft_emp_sql);
850: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_oft_sql : ' || g_oft_sql);
851: populate_ft_emp_data(l_current_function);
852: populate_oft_emp_data(l_current_function);
853: populate_nh_emp_data(l_current_function);
854: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_function : '||l_function ||' inserted into func_table');

Line 854: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_function : '||l_function ||' inserted into func_table');

850: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_oft_sql : ' || g_oft_sql);
851: populate_ft_emp_data(l_current_function);
852: populate_oft_emp_data(l_current_function);
853: populate_nh_emp_data(l_current_function);
854: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_function : '||l_function ||' inserted into func_table');
855: END IF;
856: END LOOP; -- end of second_order_func_table */
857:
858: -- Show the functions data whose data should be displayed first

Line 885: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

881:
882: -- Show the functions data whose data should be displayed first
883: l_xml_string := '';
884:
885: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
886: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
887: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Calling create_xml for the function: '||g_job_code||' with description: '||g_func_desc);
888:
889: -- Bug# 5415136

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

882: -- Show the functions data whose data should be displayed first
883: l_xml_string := '';
884:
885: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
886: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
887: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Calling create_xml for the function: '||g_job_code||' with description: '||g_func_desc);
888:
889: -- Bug# 5415136
890: g_function_numbers := '''X''';

Line 887: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Calling create_xml for the function: '||g_job_code||' with description: '||g_func_desc);

883: l_xml_string := '';
884:
885: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
886: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
887: --FND_FILE.PUT_LINE(FND_FILE.LOG,' Calling create_xml for the function: '||g_job_code||' with description: '||g_func_desc);
888:
889: -- Bug# 5415136
890: g_function_numbers := '''X''';
891:

Line 892: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_function_numbers: ' || g_function_numbers);

888:
889: -- Bug# 5415136
890: g_function_numbers := '''X''';
891:
892: --FND_FILE.PUT_LINE(FND_FILE.LOG,'g_function_numbers: ' || g_function_numbers);
893:
894: FOR i IN 1 .. first_order_func_table.count LOOP
895:
896: l_current_function := first_order_func_table(i).job_function;

Line 914: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

910:
911: l_xml_string := convert_into_xml('CONTROL_NUMBER',g_control_number,'D');
912: l_xml_string := l_xml_string || convert_into_xml('FUNCTION_NUMBERS',g_function_numbers,'D');
913:
914: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
915: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
916:
917:
918: -- Bug# 5409988

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

911: l_xml_string := convert_into_xml('CONTROL_NUMBER',g_control_number,'D');
912: l_xml_string := l_xml_string || convert_into_xml('FUNCTION_NUMBERS',g_function_numbers,'D');
913:
914: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
915: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
916:
917:
918: -- Bug# 5409988
919: FOR i IN 1 .. first_order_func_table.count LOOP

Line 927: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

923: END IF;
924: END LOOP;
925:
926: l_xml_string := '';
927: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
928: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
929:
930: -- Bug# 5410233.
931: g_line_number := 0;

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

924: END LOOP;
925:
926: l_xml_string := '';
927: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
928: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
929:
930: -- Bug# 5410233.
931: g_line_number := 0;
932:

Line 939: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

935: g_for_all_emp := 'F';
936:
937: l_xml_string := '';
938:
939: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
940: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
941:
942: ELSIF report_type = 2 THEN
943:

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

936:
937: l_xml_string := '';
938:
939: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
940: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
941:
942: ELSIF report_type = 2 THEN
943:
944: -- Show the functions data whose data should be displayed later

Line 955: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

951: -- Bug# 5415136
952: g_function_numbers := get_function_number(l_current_function);
953:
954: l_xml_string := '';
955: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
956: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
957: generate_juris_cert_xml_data();
958:
959: -- Bug# 5415136

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

952: g_function_numbers := get_function_number(l_current_function);
953:
954: l_xml_string := '';
955: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
956: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
957: generate_juris_cert_xml_data();
958:
959: -- Bug# 5415136
960: l_xml_string := convert_into_xml('CONTROL_NUMBER',g_control_number,'D');

Line 963: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

959: -- Bug# 5415136
960: l_xml_string := convert_into_xml('CONTROL_NUMBER',g_control_number,'D');
961: l_xml_string := l_xml_string || convert_into_xml('FUNCTION_NUMBERS',g_function_numbers,'D');
962:
963: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
964: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
965:
966: -- Bug# 5409988
967: check_function(to_number(l_current_function));

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

960: l_xml_string := convert_into_xml('CONTROL_NUMBER',g_control_number,'D');
961: l_xml_string := l_xml_string || convert_into_xml('FUNCTION_NUMBERS',g_function_numbers,'D');
962:
963: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
964: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
965:
966: -- Bug# 5409988
967: check_function(to_number(l_current_function));
968:

Line 970: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

966: -- Bug# 5409988
967: check_function(to_number(l_current_function));
968:
969: l_xml_string := '';
970: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
971: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
972:
973: -- Bug# 5410233.
974: g_line_number := 0;

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

967: check_function(to_number(l_current_function));
968:
969: l_xml_string := '';
970: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
971: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
972:
973: -- Bug# 5410233.
974: g_line_number := 0;
975:

Line 981: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

977: create_xml(l_current_function);
978:
979: l_xml_string := '';
980:
981: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
982: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
983: END LOOP; -- For Each Function
984: END IF;
985:

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

978:
979: l_xml_string := '';
980:
981: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
982: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
983: END LOOP; -- For Each Function
984: END IF;
985:
986: END create_report;

Line 994: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

990: BEGIN
991:
992: l_xml_string := ' ';
993:
994: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
995: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
996:
997: END generate_header_xml_data;
998:

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

991:
992: l_xml_string := ' ';
993:
994: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
995: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
996:
997: END generate_header_xml_data;
998:
999: PROCEDURE generate_footer_xml_data IS

Line 1022: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

1018: || '
1019:
1020:
1021: ';
1022: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
1023: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1024:
1025: END generate_footer_xml_data;
1026:

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

1019:
1020:
1021: ';
1022: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
1023: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1024:
1025: END generate_footer_xml_data;
1026:
1027: PROCEDURE generate_juris_cert_xml_data IS

Line 1104: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

1100: END LOOP;
1101:
1102: l_xml_string := l_xml_string || '';
1103:
1104: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
1105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1106:
1107:
1108: l_xml_string := '';

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

1101:
1102: l_xml_string := l_xml_string || '';
1103:
1104: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
1105: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1106:
1107:
1108: l_xml_string := '';
1109:

Line 1127: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

1123: END LOOP;
1124:
1125: l_xml_string := l_xml_string || '';
1126:
1127: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
1128: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1129:
1130: END generate_juris_cert_xml_data;
1131:

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

1124:
1125: l_xml_string := l_xml_string || '';
1126:
1127: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
1128: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1129:
1130: END generate_juris_cert_xml_data;
1131:
1132:

Line 1142: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

1138: -- Replaced p_current_function with g_function_numbers.
1139: l_xml_string := l_xml_string || g_function_numbers;
1140: l_xml_string := l_xml_string || '';
1141:
1142: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
1143: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1144:
1145: g_line_number := g_line_number + 1;
1146:

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

1139: l_xml_string := l_xml_string || g_function_numbers;
1140: l_xml_string := l_xml_string || '';
1141:
1142: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
1143: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1144:
1145: g_line_number := g_line_number + 1;
1146:
1147: -- Genarate full time emp xml data

Line 1163: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

1159:
1160: l_xml_string := ' '
1161: || convert_into_xml('CF_SET_FUNCTION_DESC',g_func_desc,'D')
1162: || '';
1163: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
1164: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1165: END create_xml;
1166:
1167:

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

1160: l_xml_string := ' '
1161: || convert_into_xml('CF_SET_FUNCTION_DESC',g_func_desc,'D')
1162: || '';
1163: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
1164: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1165: END create_xml;
1166:
1167:
1168: -- This method populates ft_emp_table

Line 1728: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_function in populate_nh_emp_data: ' || l_function_code);

1724:
1725: BEGIN
1726:
1727: l_function_code := p_function_code;
1728: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_function in populate_nh_emp_data: ' || l_function_code);
1729:
1730: FOR i IN get_eeo4_lookup_details LOOP -- for each job category
1731:
1732: g_lookup_code := i.lookup_code;

Line 1963: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

1959: l_xml_string := '';
1960: l_xml_string := l_xml_string || convert_into_xml('EMPLOYEE_SALARY_EMPLOYMENT_CAT','1. FULL-TIME EMPLOYEES (Temporary employees are not included)','D');
1961: l_xml_string := l_xml_string || '';
1962:
1963: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
1964: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1965:
1966: FOR i IN get_eeo4_lookup_details LOOP -- for each job category
1967:

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

1960: l_xml_string := l_xml_string || convert_into_xml('EMPLOYEE_SALARY_EMPLOYMENT_CAT','1. FULL-TIME EMPLOYEES (Temporary employees are not included)','D');
1961: l_xml_string := l_xml_string || '';
1962:
1963: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
1964: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
1965:
1966: FOR i IN get_eeo4_lookup_details LOOP -- for each job category
1967:
1968: l_lookup_code := i.lookup_code;

Line 2011: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

2007: END IF;
2008:
2009: l_xml_string := l_xml_string || '';
2010:
2011: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
2012: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
2013:
2014: END IF;
2015:

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

2008:
2009: l_xml_string := l_xml_string || '';
2010:
2011: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
2012: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
2013:
2014: END IF;
2015:
2016:

Line 2046: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

2042: l_xml_string := l_xml_string || convert_into_xml('NO_CONS_IFEMALE_EMPS',ft_emp_table(counter).no_cons_ifemale_emps,'D');
2043:
2044: l_xml_string := l_xml_string || '';
2045:
2046: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
2047: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
2048: -- Increment the line number
2049: g_line_number := g_line_number + 1 ;
2050: END IF; -- End of qualifying condition

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

2043:
2044: l_xml_string := l_xml_string || '';
2045:
2046: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
2047: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
2048: -- Increment the line number
2049: g_line_number := g_line_number + 1 ;
2050: END IF; -- End of qualifying condition
2051: END LOOP; -- End of Fetch from ft_emp_table

Line 2054: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

2050: END IF; -- End of qualifying condition
2051: END LOOP; -- End of Fetch from ft_emp_table
2052: END LOOP; -- End of for each salary range
2053: l_xml_string := '';
2054: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
2055: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
2056: END LOOP; -- for each job category
2057:
2058: l_xml_string := '';

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

2051: END LOOP; -- End of Fetch from ft_emp_table
2052: END LOOP; -- End of for each salary range
2053: l_xml_string := '';
2054: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
2055: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
2056: END LOOP; -- for each job category
2057:
2058: l_xml_string := '';
2059: l_xml_string := l_xml_string || convert_into_xml('CF_TOTAL_TITLE',g_line_number||'. TOTAL FULL-TIME (LINES 1-64)','D');

Line 2073: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

2069: l_xml_string := l_xml_string || convert_into_xml('CS_NO_IFEMALE_EMPS', l_cs_no_ifemale_emps,'D');
2070: l_xml_string := l_xml_string || convert_into_xml('CS_TOTAL_CATEGORY_EMPS', l_cs_total_category_emps,'D');
2071: l_xml_string := l_xml_string || '';
2072:
2073: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
2074: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
2075: END;
2076:
2077: PROCEDURE generate_oft_xml_data(p_function_code VARCHAR2) IS

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

2070: l_xml_string := l_xml_string || convert_into_xml('CS_TOTAL_CATEGORY_EMPS', l_cs_total_category_emps,'D');
2071: l_xml_string := l_xml_string || '';
2072:
2073: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
2074: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
2075: END;
2076:
2077: PROCEDURE generate_oft_xml_data(p_function_code VARCHAR2) IS
2078:

Line 2117: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

2113: -- 2. OTHER THAN FULL-TIME EMPLOYEES (Including temporary employees)
2114: l_xml_string := '';
2115: l_xml_string := l_xml_string || convert_into_xml('EMPLOYEE_SALARY_EMPLOYMENT_CAT','2. OTHER THAN FULL-TIME EMPLOYEES (Including temporary employees)','D');
2116: l_xml_string := l_xml_string || '';
2117: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
2118: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
2119:
2120:
2121: FOR counter in 1 .. other_ft_emp_table.count LOOP -- Fetch from other_ft_emp_table

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

2114: l_xml_string := '';
2115: l_xml_string := l_xml_string || convert_into_xml('EMPLOYEE_SALARY_EMPLOYMENT_CAT','2. OTHER THAN FULL-TIME EMPLOYEES (Including temporary employees)','D');
2116: l_xml_string := l_xml_string || '';
2117: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
2118: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
2119:
2120:
2121: FOR counter in 1 .. other_ft_emp_table.count LOOP -- Fetch from other_ft_emp_table
2122:

Line 2156: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

2152: l_xml_string := l_xml_string || convert_into_xml('NO_CONS_HFEMALE_EMPS',other_ft_emp_table(counter).no_cons_hfemale_emps,'D');
2153: l_xml_string := l_xml_string || convert_into_xml('NO_CONS_AFEMALE_EMPS',other_ft_emp_table(counter).no_cons_afemale_emps,'D');
2154: l_xml_string := l_xml_string || convert_into_xml('NO_CONS_IFEMALE_EMPS',other_ft_emp_table(counter).no_cons_ifemale_emps,'D');
2155: l_xml_string := l_xml_string || '';
2156: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
2157: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
2158: g_line_number := g_line_number + 1;
2159: END IF;
2160: END LOOP; -- Fetch other than full emp table

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

2153: l_xml_string := l_xml_string || convert_into_xml('NO_CONS_AFEMALE_EMPS',other_ft_emp_table(counter).no_cons_afemale_emps,'D');
2154: l_xml_string := l_xml_string || convert_into_xml('NO_CONS_IFEMALE_EMPS',other_ft_emp_table(counter).no_cons_ifemale_emps,'D');
2155: l_xml_string := l_xml_string || '';
2156: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
2157: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
2158: g_line_number := g_line_number + 1;
2159: END IF;
2160: END LOOP; -- Fetch other than full emp table
2161:

Line 2177: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

2173: l_xml_string := l_xml_string || convert_into_xml('CS_NO_AFEMALE_EMPS', l_cs_no_afemale_emps,'D');
2174: l_xml_string := l_xml_string || convert_into_xml('CS_NO_IFEMALE_EMPS', l_cs_no_ifemale_emps,'D');
2175: l_xml_string := l_xml_string || convert_into_xml('CS_TOTAL_CATEGORY_EMPS', l_cs_total_category_emps,'D');
2176: l_xml_string := l_xml_string || '';
2177: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
2178: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
2179: END;
2180:
2181: PROCEDURE generate_nh_xml_data(p_function_code IN VARCHAR2) IS

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

2174: l_xml_string := l_xml_string || convert_into_xml('CS_NO_IFEMALE_EMPS', l_cs_no_ifemale_emps,'D');
2175: l_xml_string := l_xml_string || convert_into_xml('CS_TOTAL_CATEGORY_EMPS', l_cs_total_category_emps,'D');
2176: l_xml_string := l_xml_string || '';
2177: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
2178: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
2179: END;
2180:
2181: PROCEDURE generate_nh_xml_data(p_function_code IN VARCHAR2) IS
2182:

Line 2222: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

2218:
2219: l_xml_string := '';
2220: 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');
2221: l_xml_string := l_xml_string || '';
2222: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
2223: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
2224:
2225: FOR counter in 1 .. new_hire_table.count LOOP -- Fetch from other_ft_emp_table
2226:

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

2219: l_xml_string := '';
2220: 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');
2221: l_xml_string := l_xml_string || '';
2222: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
2223: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
2224:
2225: FOR counter in 1 .. new_hire_table.count LOOP -- Fetch from other_ft_emp_table
2226:
2227:

Line 2260: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

2256: l_xml_string := l_xml_string || convert_into_xml('NO_CONS_AFEMALE_EMPS',new_hire_table(counter).no_cons_afemale_emps,'D');
2257: l_xml_string := l_xml_string || convert_into_xml('NO_CONS_IFEMALE_EMPS',new_hire_table(counter).no_cons_ifemale_emps,'D');
2258: l_xml_string := l_xml_string || '';
2259:
2260: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
2261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
2262:
2263: g_line_number := g_line_number + 1;
2264: END IF;

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

2257: l_xml_string := l_xml_string || convert_into_xml('NO_CONS_IFEMALE_EMPS',new_hire_table(counter).no_cons_ifemale_emps,'D');
2258: l_xml_string := l_xml_string || '';
2259:
2260: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
2261: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
2262:
2263: g_line_number := g_line_number + 1;
2264: END IF;
2265: END LOOP; -- End of Fetch from other_ft_emp_table

Line 2282: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

2278: l_xml_string := l_xml_string || convert_into_xml('CS_NO_IFEMALE_EMPS', l_cs_no_ifemale_emps,'D');
2279: l_xml_string := l_xml_string || convert_into_xml('CS_TOTAL_CATEGORY_EMPS', l_cs_total_category_emps,'D');
2280: l_xml_string := l_xml_string || '';
2281:
2282: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
2283: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
2284:
2285: END;
2286: END PER_US_EEO4_PKG;

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

2279: l_xml_string := l_xml_string || convert_into_xml('CS_TOTAL_CATEGORY_EMPS', l_cs_total_category_emps,'D');
2280: l_xml_string := l_xml_string || '';
2281:
2282: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
2283: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
2284:
2285: END;
2286: END PER_US_EEO4_PKG;
2287: