558:
559: -- Fetch the list of employment categories
560: pqh_employment_category.fetch_empl_categories(p_business_group_id, l_fr, l_ft, l_pr, l_pt);
561:
562: source_cursor := dbms_sql.open_cursor;
563: dbms_sql.parse(source_cursor,l_query_text,1);
564: dbms_sql.define_column(source_cursor,1,l_ft_emp_count);
565:
566: rows_processed := dbms_sql.EXECUTE(source_cursor);
559: -- Fetch the list of employment categories
560: pqh_employment_category.fetch_empl_categories(p_business_group_id, l_fr, l_ft, l_pr, l_pt);
561:
562: source_cursor := dbms_sql.open_cursor;
563: dbms_sql.parse(source_cursor,l_query_text,1);
564: dbms_sql.define_column(source_cursor,1,l_ft_emp_count);
565:
566: rows_processed := dbms_sql.EXECUTE(source_cursor);
567:
560: pqh_employment_category.fetch_empl_categories(p_business_group_id, l_fr, l_ft, l_pr, l_pt);
561:
562: source_cursor := dbms_sql.open_cursor;
563: dbms_sql.parse(source_cursor,l_query_text,1);
564: dbms_sql.define_column(source_cursor,1,l_ft_emp_count);
565:
566: rows_processed := dbms_sql.EXECUTE(source_cursor);
567:
568: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
562: source_cursor := dbms_sql.open_cursor;
563: dbms_sql.parse(source_cursor,l_query_text,1);
564: dbms_sql.define_column(source_cursor,1,l_ft_emp_count);
565:
566: rows_processed := dbms_sql.EXECUTE(source_cursor);
567:
568: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
569: dbms_sql.column_value(source_cursor, 1, l_ft_emp_count);
570: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_ft_emp_count: ' || l_ft_emp_count);
564: dbms_sql.define_column(source_cursor,1,l_ft_emp_count);
565:
566: rows_processed := dbms_sql.EXECUTE(source_cursor);
567:
568: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
569: dbms_sql.column_value(source_cursor, 1, l_ft_emp_count);
570: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_ft_emp_count: ' || l_ft_emp_count);
571:
572: END IF;
565:
566: rows_processed := dbms_sql.EXECUTE(source_cursor);
567:
568: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
569: dbms_sql.column_value(source_cursor, 1, l_ft_emp_count);
570: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_ft_emp_count: ' || l_ft_emp_count);
571:
572: END IF;
573:
570: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_ft_emp_count: ' || l_ft_emp_count);
571:
572: END IF;
573:
574: dbms_sql.close_cursor(source_cursor);
575:
576: l_query_text := 'Select job.job_information7 l_function_code,
577: count(1) l_function_count ' || g_from_where_clause || g_ft_effective_dates || ' group by job.job_information7 ';
578: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_query_text: '||l_query_text);
575:
576: l_query_text := 'Select job.job_information7 l_function_code,
577: count(1) l_function_count ' || g_from_where_clause || g_ft_effective_dates || ' group by job.job_information7 ';
578: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_query_text: '||l_query_text);
579: source_cursor := dbms_sql.open_cursor;
580: dbms_sql.parse(source_cursor,l_query_text,2);
581: dbms_sql.define_column_char(source_cursor,1,l_function_code,30);
582: dbms_sql.define_column(source_cursor,2,l_function_count);
583: rows_processed := dbms_sql.EXECUTE(source_cursor);
576: l_query_text := 'Select job.job_information7 l_function_code,
577: count(1) l_function_count ' || g_from_where_clause || g_ft_effective_dates || ' group by job.job_information7 ';
578: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_query_text: '||l_query_text);
579: source_cursor := dbms_sql.open_cursor;
580: dbms_sql.parse(source_cursor,l_query_text,2);
581: dbms_sql.define_column_char(source_cursor,1,l_function_code,30);
582: dbms_sql.define_column(source_cursor,2,l_function_count);
583: rows_processed := dbms_sql.EXECUTE(source_cursor);
584:
577: count(1) l_function_count ' || g_from_where_clause || g_ft_effective_dates || ' group by job.job_information7 ';
578: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_query_text: '||l_query_text);
579: source_cursor := dbms_sql.open_cursor;
580: dbms_sql.parse(source_cursor,l_query_text,2);
581: dbms_sql.define_column_char(source_cursor,1,l_function_code,30);
582: dbms_sql.define_column(source_cursor,2,l_function_count);
583: rows_processed := dbms_sql.EXECUTE(source_cursor);
584:
585: LOOP
578: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_query_text: '||l_query_text);
579: source_cursor := dbms_sql.open_cursor;
580: dbms_sql.parse(source_cursor,l_query_text,2);
581: dbms_sql.define_column_char(source_cursor,1,l_function_code,30);
582: dbms_sql.define_column(source_cursor,2,l_function_count);
583: rows_processed := dbms_sql.EXECUTE(source_cursor);
584:
585: LOOP
586: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
579: source_cursor := dbms_sql.open_cursor;
580: dbms_sql.parse(source_cursor,l_query_text,2);
581: dbms_sql.define_column_char(source_cursor,1,l_function_code,30);
582: dbms_sql.define_column(source_cursor,2,l_function_count);
583: rows_processed := dbms_sql.EXECUTE(source_cursor);
584:
585: LOOP
586: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
587: dbms_sql.column_value_char(source_cursor,1,l_function_code);
582: dbms_sql.define_column(source_cursor,2,l_function_count);
583: rows_processed := dbms_sql.EXECUTE(source_cursor);
584:
585: LOOP
586: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
587: dbms_sql.column_value_char(source_cursor,1,l_function_code);
588: dbms_sql.column_value(source_cursor,2,l_function_count);
589: l_function_code := RTRIM(l_function_code);
590:
583: rows_processed := dbms_sql.EXECUTE(source_cursor);
584:
585: LOOP
586: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
587: dbms_sql.column_value_char(source_cursor,1,l_function_code);
588: dbms_sql.column_value(source_cursor,2,l_function_count);
589: l_function_code := RTRIM(l_function_code);
590:
591: -- Fetch the function description
584:
585: LOOP
586: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
587: dbms_sql.column_value_char(source_cursor,1,l_function_code);
588: dbms_sql.column_value(source_cursor,2,l_function_count);
589: l_function_code := RTRIM(l_function_code);
590:
591: -- Fetch the function description
592: IF l_function_code IS NOT NULL THEN
655: EXIT;
656: END IF;
657: END LOOP;
658:
659: dbms_sql.close_cursor(source_cursor);
660:
661: -- Bug# 5437076
662: IF l_fo_funct_counter = 0 AND l_so_funct_counter = 0 THEN
663: l_fo_funct_counter := l_fo_funct_counter + 1;
1112: g_end_salary := 99900;
1113: g_salary_range := '70.0 PLUS';
1114: END CASE;
1115:
1116: source_cursor := dbms_sql.open_cursor;
1117:
1118: -- Bug# 5414756
1119: IF J = 8 THEN
1120: g_dynamic_where := ' AND round(NVL(ppp.proposed_salary_n * ppb.pay_annualization_factor,0)) >= 70000 ';
1124:
1125: generate_sql(p_function_code, g_dynamic_where);
1126:
1127:
1128: dbms_sql.parse(source_cursor,g_ft_emp_sql,2);
1129: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1130: --dbms_sql.BIND_VARIABLE(source_cursor,':2',g_start_salary);
1131: --dbms_sql.BIND_VARIABLE(source_cursor,':3',g_end_salary);
1132:
1125: generate_sql(p_function_code, g_dynamic_where);
1126:
1127:
1128: dbms_sql.parse(source_cursor,g_ft_emp_sql,2);
1129: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1130: --dbms_sql.BIND_VARIABLE(source_cursor,':2',g_start_salary);
1131: --dbms_sql.BIND_VARIABLE(source_cursor,':3',g_end_salary);
1132:
1133: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1126:
1127:
1128: dbms_sql.parse(source_cursor,g_ft_emp_sql,2);
1129: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1130: --dbms_sql.BIND_VARIABLE(source_cursor,':2',g_start_salary);
1131: --dbms_sql.BIND_VARIABLE(source_cursor,':3',g_end_salary);
1132:
1133: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1134: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1127:
1128: dbms_sql.parse(source_cursor,g_ft_emp_sql,2);
1129: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1130: --dbms_sql.BIND_VARIABLE(source_cursor,':2',g_start_salary);
1131: --dbms_sql.BIND_VARIABLE(source_cursor,':3',g_end_salary);
1132:
1133: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1134: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1135: --Bug# 6200441
1129: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1130: --dbms_sql.BIND_VARIABLE(source_cursor,':2',g_start_salary);
1131: --dbms_sql.BIND_VARIABLE(source_cursor,':3',g_end_salary);
1132:
1133: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1134: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1135: --Bug# 6200441
1136: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1137: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1130: --dbms_sql.BIND_VARIABLE(source_cursor,':2',g_start_salary);
1131: --dbms_sql.BIND_VARIABLE(source_cursor,':3',g_end_salary);
1132:
1133: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1134: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1135: --Bug# 6200441
1136: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1137: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1138: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1132:
1133: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1134: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1135: --Bug# 6200441
1136: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1137: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1138: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1139: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1140: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1133: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1134: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1135: --Bug# 6200441
1136: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1137: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1138: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1139: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1140: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1141: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1134: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1135: --Bug# 6200441
1136: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1137: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1138: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1139: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1140: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1141: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1142: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1135: --Bug# 6200441
1136: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1137: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1138: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1139: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1140: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1141: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1142: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1143: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1136: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1137: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1138: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1139: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1140: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1141: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1142: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1143: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1144: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1137: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1138: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1139: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1140: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1141: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1142: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1143: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1144: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1145: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1138: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1139: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1140: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1141: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1142: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1143: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1144: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1145: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1146: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1139: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1140: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1141: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1142: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1143: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1144: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1145: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1146: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1147:
1140: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1141: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1142: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1143: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1144: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1145: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1146: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1147:
1148: rows_processed := dbms_sql.EXECUTE(source_cursor);
1141: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1142: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1143: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1144: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1145: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1146: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1147:
1148: rows_processed := dbms_sql.EXECUTE(source_cursor);
1149:
1142: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1143: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1144: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1145: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1146: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1147:
1148: rows_processed := dbms_sql.EXECUTE(source_cursor);
1149:
1150: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1144: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1145: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1146: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1147:
1148: rows_processed := dbms_sql.EXECUTE(source_cursor);
1149:
1150: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1151:
1152: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1146: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1147:
1148: rows_processed := dbms_sql.EXECUTE(source_cursor);
1149:
1150: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1151:
1152: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1153: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1154: --Bug# 6200441
1148: rows_processed := dbms_sql.EXECUTE(source_cursor);
1149:
1150: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1151:
1152: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1153: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1154: --Bug# 6200441
1155: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1156: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1149:
1150: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1151:
1152: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1153: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1154: --Bug# 6200441
1155: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1156: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1157: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1151:
1152: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1153: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1154: --Bug# 6200441
1155: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1156: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1157: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1158: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1159: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1152: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1153: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1154: --Bug# 6200441
1155: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1156: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1157: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1158: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1159: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1160: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1153: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1154: --Bug# 6200441
1155: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1156: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1157: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1158: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1159: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1160: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1161: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1154: --Bug# 6200441
1155: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1156: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1157: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1158: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1159: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1160: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1161: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1162: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1155: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1156: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1157: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1158: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1159: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1160: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1161: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1162: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1163: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1156: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1157: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1158: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1159: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1160: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1161: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1162: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1163: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1164: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1157: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1158: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1159: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1160: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1161: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1162: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1163: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1164: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1165: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);
1158: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1159: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1160: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1161: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1162: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1163: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1164: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1165: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);
1166:
1159: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1160: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1161: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1162: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1163: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1164: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1165: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);
1166:
1167: l_counter1 := l_counter1 + 1;
1160: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1161: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1162: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1163: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1164: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1165: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);
1166:
1167: l_counter1 := l_counter1 + 1;
1168:
1161: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1162: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1163: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1164: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1165: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);
1166:
1167: l_counter1 := l_counter1 + 1;
1168:
1169: IF g_for_all_emp = 'T' THEN
1218: ft_emp_table(l_counter1).no_cons_hfemale_emps := 0;
1219: ft_emp_table(l_counter1).no_cons_afemale_emps := 0;
1220: ft_emp_table(l_counter1).no_cons_ifemale_emps := 0;
1221: END IF;
1222: dbms_sql.close_cursor(source_cursor); -- Closing the cursor
1223:
1224: -- Bug# 5593259
1225: /* For Two or more races:
1226: If the employee's ethnic code is 'Two or more races',
1226: If the employee's ethnic code is 'Two or more races',
1227: select pei_information5 from per_people_extra_info table
1228: */
1229:
1230: source_cursor := dbms_sql.open_cursor;
1231: dbms_sql.parse(source_cursor,g_tmr_ft_emp_sql,2);
1232: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1233:
1234: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1227: select pei_information5 from per_people_extra_info table
1228: */
1229:
1230: source_cursor := dbms_sql.open_cursor;
1231: dbms_sql.parse(source_cursor,g_tmr_ft_emp_sql,2);
1232: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1233:
1234: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1235: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1228: */
1229:
1230: source_cursor := dbms_sql.open_cursor;
1231: dbms_sql.parse(source_cursor,g_tmr_ft_emp_sql,2);
1232: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1233:
1234: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1235: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1236: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1230: source_cursor := dbms_sql.open_cursor;
1231: dbms_sql.parse(source_cursor,g_tmr_ft_emp_sql,2);
1232: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1233:
1234: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1235: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1236: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1237: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1238: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1231: dbms_sql.parse(source_cursor,g_tmr_ft_emp_sql,2);
1232: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1233:
1234: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1235: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1236: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1237: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1238: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1239: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1232: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1233:
1234: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1235: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1236: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1237: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1238: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1239: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1240: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1233:
1234: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1235: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1236: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1237: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1238: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1239: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1240: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1241: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1234: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1235: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1236: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1237: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1238: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1239: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1240: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1241: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1242: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1235: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1236: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1237: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1238: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1239: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1240: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1241: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1242: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1243: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1236: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1237: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1238: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1239: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1240: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1241: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1242: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1243: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1244: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1237: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1238: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1239: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1240: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1241: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1242: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1243: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1244: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1245: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1238: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1239: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1240: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1241: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1242: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1243: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1244: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1245: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1246:
1239: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1240: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1241: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1242: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1243: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1244: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1245: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1246:
1247: rows_processed := dbms_sql.EXECUTE(source_cursor);
1240: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1241: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1242: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1243: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1244: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1245: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1246:
1247: rows_processed := dbms_sql.EXECUTE(source_cursor);
1248:
1241: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1242: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1243: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1244: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1245: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1246:
1247: rows_processed := dbms_sql.EXECUTE(source_cursor);
1248:
1249: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1243: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1244: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1245: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1246:
1247: rows_processed := dbms_sql.EXECUTE(source_cursor);
1248:
1249: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1250:
1251: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1245: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1246:
1247: rows_processed := dbms_sql.EXECUTE(source_cursor);
1248:
1249: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1250:
1251: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1252: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1253: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1247: rows_processed := dbms_sql.EXECUTE(source_cursor);
1248:
1249: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1250:
1251: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1252: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1253: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1254: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1255: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1248:
1249: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1250:
1251: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1252: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1253: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1254: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1255: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1256: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1249: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1250:
1251: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1252: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1253: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1254: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1255: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1256: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1257: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1250:
1251: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1252: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1253: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1254: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1255: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1256: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1257: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1258: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1251: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1252: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1253: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1254: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1255: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1256: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1257: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1258: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1259: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1252: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1253: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1254: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1255: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1256: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1257: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1258: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1259: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1260: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1253: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1254: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1255: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1256: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1257: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1258: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1259: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1260: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1261: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1254: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1255: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1256: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1257: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1258: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1259: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1260: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1261: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1262: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);
1255: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1256: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1257: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1258: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1259: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1260: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1261: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1262: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);
1263:
1256: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1257: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1258: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1259: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1260: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1261: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1262: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);
1263:
1264: ft_emp_table(l_counter1).no_cons_wmale_emps := ft_emp_table(l_counter1).no_cons_wmale_emps +
1257: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1258: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1259: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1260: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1261: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1262: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);
1263:
1264: ft_emp_table(l_counter1).no_cons_wmale_emps := ft_emp_table(l_counter1).no_cons_wmale_emps +
1265: ltrim(rtrim(l_no_tmr_wmale_emps));
1258: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1259: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1260: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1261: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1262: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);
1263:
1264: ft_emp_table(l_counter1).no_cons_wmale_emps := ft_emp_table(l_counter1).no_cons_wmale_emps +
1265: ltrim(rtrim(l_no_tmr_wmale_emps));
1266: ft_emp_table(l_counter1).no_cons_bmale_emps := ft_emp_table(l_counter1).no_cons_bmale_emps +
1295: ltrim(rtrim(l_no_tmr_ifemale_emps));
1296:
1297: END IF;
1298:
1299: dbms_sql.close_cursor(source_cursor); -- Closing the cursor
1300:
1301: END LOOP; -- for each salary range
1302: END LOOP; -- for each job category
1303: END populate_ft_emp_data; -- End of the procedure populate_ft_emp_data
1346:
1347: g_lookup_code := i.lookup_code;
1348: g_meaning := i.meaning;
1349:
1350: source_cursor := dbms_sql.open_cursor;
1351: dbms_sql.parse(source_cursor,g_oft_sql,2);
1352: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1353:
1354: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1347: g_lookup_code := i.lookup_code;
1348: g_meaning := i.meaning;
1349:
1350: source_cursor := dbms_sql.open_cursor;
1351: dbms_sql.parse(source_cursor,g_oft_sql,2);
1352: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1353:
1354: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1355: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1348: g_meaning := i.meaning;
1349:
1350: source_cursor := dbms_sql.open_cursor;
1351: dbms_sql.parse(source_cursor,g_oft_sql,2);
1352: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1353:
1354: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1355: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1356: -- Bug# 6200441
1350: source_cursor := dbms_sql.open_cursor;
1351: dbms_sql.parse(source_cursor,g_oft_sql,2);
1352: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1353:
1354: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1355: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1356: -- Bug# 6200441
1357: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1358: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1351: dbms_sql.parse(source_cursor,g_oft_sql,2);
1352: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1353:
1354: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1355: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1356: -- Bug# 6200441
1357: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1358: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1359: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1353:
1354: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1355: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1356: -- Bug# 6200441
1357: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1358: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1359: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1360: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1361: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1354: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1355: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1356: -- Bug# 6200441
1357: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1358: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1359: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1360: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1361: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1362: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1355: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1356: -- Bug# 6200441
1357: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1358: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1359: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1360: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1361: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1362: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1363: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1356: -- Bug# 6200441
1357: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1358: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1359: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1360: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1361: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1362: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1363: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1364: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1357: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1358: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1359: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1360: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1361: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1362: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1363: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1364: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1365: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1358: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1359: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1360: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1361: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1362: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1363: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1364: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1365: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1366: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1359: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1360: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1361: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1362: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1363: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1364: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1365: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1366: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1367: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1360: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1361: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1362: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1363: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1364: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1365: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1366: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1367: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1368:
1361: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1362: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1363: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1364: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1365: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1366: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1367: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1368:
1369: rows_processed := dbms_sql.EXECUTE(source_cursor);
1362: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1363: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1364: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1365: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1366: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1367: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1368:
1369: rows_processed := dbms_sql.EXECUTE(source_cursor);
1370:
1363: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1364: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1365: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1366: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1367: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1368:
1369: rows_processed := dbms_sql.EXECUTE(source_cursor);
1370:
1371: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1365: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1366: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1367: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1368:
1369: rows_processed := dbms_sql.EXECUTE(source_cursor);
1370:
1371: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1372:
1373: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1367: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1368:
1369: rows_processed := dbms_sql.EXECUTE(source_cursor);
1370:
1371: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1372:
1373: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1374: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1375: -- Bug# 6200441
1369: rows_processed := dbms_sql.EXECUTE(source_cursor);
1370:
1371: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1372:
1373: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1374: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1375: -- Bug# 6200441
1376: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1377: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1370:
1371: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1372:
1373: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1374: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1375: -- Bug# 6200441
1376: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1377: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1378: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1372:
1373: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1374: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1375: -- Bug# 6200441
1376: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1377: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1378: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1379: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1380: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1373: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1374: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1375: -- Bug# 6200441
1376: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1377: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1378: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1379: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1380: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1381: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1374: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1375: -- Bug# 6200441
1376: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1377: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1378: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1379: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1380: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1381: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1382: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1375: -- Bug# 6200441
1376: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1377: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1378: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1379: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1380: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1381: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1382: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1383: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1376: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1377: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1378: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1379: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1380: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1381: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1382: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1383: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1384: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1377: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1378: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1379: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1380: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1381: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1382: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1383: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1384: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1385: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1378: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1379: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1380: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1381: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1382: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1383: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1384: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1385: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1386: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);
1379: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1380: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1381: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1382: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1383: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1384: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1385: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1386: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);
1387:
1380: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1381: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1382: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1383: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1384: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1385: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1386: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);
1387:
1388: l_counter2 := l_counter2 + 1;
1381: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1382: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1383: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1384: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1385: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1386: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);
1387:
1388: l_counter2 := l_counter2 + 1;
1389:
1382: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1383: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1384: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1385: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1386: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);
1387:
1388: l_counter2 := l_counter2 + 1;
1389:
1390: IF g_for_all_emp = 'T' THEN
1437: other_ft_emp_table(l_counter2).no_cons_hfemale_emps := 0;
1438: other_ft_emp_table(l_counter2).no_cons_afemale_emps := 0;
1439: other_ft_emp_table(l_counter2).no_cons_ifemale_emps := 0;
1440: END IF;
1441: dbms_sql.close_cursor(source_cursor); -- Close the cursor
1442:
1443: -- Bug# 5593259
1444: /* For Two or more races:
1445: If the employee's ethnic code is 'Two or more races',
1445: If the employee's ethnic code is 'Two or more races',
1446: select pei_information5 from per_people_extra_info table
1447: */
1448:
1449: source_cursor := dbms_sql.open_cursor;
1450: dbms_sql.parse(source_cursor,g_tmr_oft_sql,2);
1451: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1452:
1453: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1446: select pei_information5 from per_people_extra_info table
1447: */
1448:
1449: source_cursor := dbms_sql.open_cursor;
1450: dbms_sql.parse(source_cursor,g_tmr_oft_sql,2);
1451: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1452:
1453: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1454: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1447: */
1448:
1449: source_cursor := dbms_sql.open_cursor;
1450: dbms_sql.parse(source_cursor,g_tmr_oft_sql,2);
1451: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1452:
1453: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1454: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1455: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1449: source_cursor := dbms_sql.open_cursor;
1450: dbms_sql.parse(source_cursor,g_tmr_oft_sql,2);
1451: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1452:
1453: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1454: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1455: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1456: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1457: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1450: dbms_sql.parse(source_cursor,g_tmr_oft_sql,2);
1451: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1452:
1453: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1454: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1455: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1456: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1457: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1458: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1451: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1452:
1453: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1454: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1455: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1456: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1457: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1458: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1459: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1452:
1453: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1454: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1455: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1456: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1457: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1458: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1459: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1460: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1453: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1454: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1455: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1456: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1457: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1458: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1459: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1460: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1461: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1454: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1455: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1456: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1457: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1458: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1459: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1460: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1461: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1462: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1455: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1456: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1457: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1458: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1459: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1460: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1461: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1462: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1463: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1456: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1457: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1458: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1459: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1460: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1461: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1462: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1463: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1464: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1457: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1458: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1459: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1460: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1461: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1462: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1463: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1464: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1465:
1458: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1459: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1460: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1461: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1462: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1463: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1464: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1465:
1466: rows_processed := dbms_sql.EXECUTE(source_cursor);
1459: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1460: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1461: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1462: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1463: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1464: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1465:
1466: rows_processed := dbms_sql.EXECUTE(source_cursor);
1467:
1460: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1461: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1462: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1463: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1464: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1465:
1466: rows_processed := dbms_sql.EXECUTE(source_cursor);
1467:
1468: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1462: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1463: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1464: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1465:
1466: rows_processed := dbms_sql.EXECUTE(source_cursor);
1467:
1468: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1469:
1470: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1464: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1465:
1466: rows_processed := dbms_sql.EXECUTE(source_cursor);
1467:
1468: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1469:
1470: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1471: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1472: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1466: rows_processed := dbms_sql.EXECUTE(source_cursor);
1467:
1468: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1469:
1470: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1471: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1472: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1473: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1474: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1467:
1468: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1469:
1470: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1471: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1472: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1473: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1474: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1475: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1468: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1469:
1470: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1471: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1472: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1473: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1474: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1475: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1476: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1469:
1470: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1471: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1472: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1473: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1474: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1475: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1476: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1477: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1470: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1471: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1472: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1473: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1474: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1475: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1476: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1477: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1478: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1471: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1472: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1473: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1474: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1475: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1476: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1477: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1478: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1479: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1472: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1473: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1474: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1475: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1476: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1477: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1478: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1479: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1480: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1473: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1474: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1475: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1476: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1477: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1478: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1479: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1480: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1481: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);
1474: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1475: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1476: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1477: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1478: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1479: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1480: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1481: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);
1482:
1475: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1476: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1477: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1478: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1479: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1480: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1481: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);
1482:
1483: other_ft_emp_table(l_counter2).no_cons_wmale_emps := other_ft_emp_table(l_counter2).no_cons_wmale_emps +
1476: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1477: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1478: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1479: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1480: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1481: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);
1482:
1483: other_ft_emp_table(l_counter2).no_cons_wmale_emps := other_ft_emp_table(l_counter2).no_cons_wmale_emps +
1484: ltrim(rtrim(l_no_tmr_wmale_emps));
1477: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1478: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1479: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1480: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1481: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);
1482:
1483: other_ft_emp_table(l_counter2).no_cons_wmale_emps := other_ft_emp_table(l_counter2).no_cons_wmale_emps +
1484: ltrim(rtrim(l_no_tmr_wmale_emps));
1485: other_ft_emp_table(l_counter2).no_cons_bmale_emps := other_ft_emp_table(l_counter2).no_cons_bmale_emps +
1514: ltrim(rtrim(l_no_tmr_ifemale_emps));
1515:
1516: END IF;
1517:
1518: dbms_sql.close_cursor(source_cursor); -- Closing the cursor
1519:
1520: END LOOP; -- for each job category
1521: END;
1522:
1564:
1565: g_lookup_code := i.lookup_code;
1566: g_meaning := i.meaning;
1567:
1568: source_cursor := dbms_sql.open_cursor;
1569:
1570: dbms_sql.parse(source_cursor,g_nh_sql,2);
1571: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1572:
1566: g_meaning := i.meaning;
1567:
1568: source_cursor := dbms_sql.open_cursor;
1569:
1570: dbms_sql.parse(source_cursor,g_nh_sql,2);
1571: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1572:
1573: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1574: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1567:
1568: source_cursor := dbms_sql.open_cursor;
1569:
1570: dbms_sql.parse(source_cursor,g_nh_sql,2);
1571: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1572:
1573: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1574: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1575: -- Bug# 6200441
1569:
1570: dbms_sql.parse(source_cursor,g_nh_sql,2);
1571: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1572:
1573: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1574: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1575: -- Bug# 6200441
1576: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1577: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1570: dbms_sql.parse(source_cursor,g_nh_sql,2);
1571: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1572:
1573: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1574: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1575: -- Bug# 6200441
1576: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1577: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1578: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1572:
1573: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1574: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1575: -- Bug# 6200441
1576: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1577: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1578: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1579: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1580: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1573: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1574: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1575: -- Bug# 6200441
1576: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1577: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1578: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1579: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1580: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1581: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1574: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1575: -- Bug# 6200441
1576: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1577: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1578: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1579: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1580: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1581: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1582: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1575: -- Bug# 6200441
1576: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1577: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1578: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1579: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1580: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1581: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1582: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1583: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1576: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1577: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1578: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1579: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1580: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1581: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1582: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1583: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1584: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1577: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1578: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1579: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1580: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1581: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1582: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1583: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1584: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1585: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1578: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1579: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1580: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1581: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1582: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1583: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1584: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1585: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1586: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1579: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1580: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1581: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1582: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1583: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1584: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1585: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1586: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1587:
1580: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1581: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1582: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1583: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1584: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1585: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1586: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1587:
1588: rows_processed := dbms_sql.EXECUTE(source_cursor);
1581: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1582: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1583: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1584: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1585: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1586: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1587:
1588: rows_processed := dbms_sql.EXECUTE(source_cursor);
1589:
1582: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1583: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1584: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1585: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1586: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1587:
1588: rows_processed := dbms_sql.EXECUTE(source_cursor);
1589:
1590: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1584: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1585: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1586: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1587:
1588: rows_processed := dbms_sql.EXECUTE(source_cursor);
1589:
1590: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1591:
1592: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1586: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1587:
1588: rows_processed := dbms_sql.EXECUTE(source_cursor);
1589:
1590: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1591:
1592: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1593: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1594: -- Bug# 6200441
1588: rows_processed := dbms_sql.EXECUTE(source_cursor);
1589:
1590: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1591:
1592: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1593: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1594: -- Bug# 6200441
1595: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1596: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1589:
1590: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1591:
1592: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1593: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1594: -- Bug# 6200441
1595: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1596: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1597: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1591:
1592: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1593: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1594: -- Bug# 6200441
1595: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1596: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1597: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1598: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1599: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1592: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1593: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1594: -- Bug# 6200441
1595: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1596: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1597: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1598: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1599: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1600: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1593: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1594: -- Bug# 6200441
1595: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1596: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1597: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1598: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1599: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1600: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1601: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1594: -- Bug# 6200441
1595: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1596: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1597: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1598: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1599: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1600: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1601: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1602: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1595: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1596: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1597: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1598: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1599: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1600: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1601: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1602: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1603: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1596: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1597: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1598: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1599: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1600: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1601: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1602: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1603: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1604: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1597: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1598: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1599: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1600: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1601: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1602: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1603: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1604: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1605: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);
1598: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1599: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1600: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1601: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1602: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1603: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1604: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1605: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);
1606:
1599: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1600: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1601: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1602: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1603: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1604: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1605: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);
1606:
1607: l_counter3 := l_counter3 + 1;
1600: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1601: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1602: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1603: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1604: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1605: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);
1606:
1607: l_counter3 := l_counter3 + 1;
1608:
1601: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1602: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1603: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1604: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1605: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);
1606:
1607: l_counter3 := l_counter3 + 1;
1608:
1609: IF g_for_all_emp = 'T' THEN
1656: new_hire_table(l_counter3).no_cons_hfemale_emps := 0;
1657: new_hire_table(l_counter3).no_cons_afemale_emps := 0;
1658: new_hire_table(l_counter3).no_cons_ifemale_emps := 0;
1659: END IF;
1660: dbms_sql.close_cursor(source_cursor); -- Close the cursor
1661:
1662: -- Bug# 5593259
1663: /* For Two or more races:
1664: If the employee's ethnic code is 'Two or more races',
1664: If the employee's ethnic code is 'Two or more races',
1665: select pei_information5 from per_people_extra_info table
1666: */
1667:
1668: source_cursor := dbms_sql.open_cursor;
1669: dbms_sql.parse(source_cursor,g_tmr_nh_sql,2);
1670: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1671:
1672: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1665: select pei_information5 from per_people_extra_info table
1666: */
1667:
1668: source_cursor := dbms_sql.open_cursor;
1669: dbms_sql.parse(source_cursor,g_tmr_nh_sql,2);
1670: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1671:
1672: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1673: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1666: */
1667:
1668: source_cursor := dbms_sql.open_cursor;
1669: dbms_sql.parse(source_cursor,g_tmr_nh_sql,2);
1670: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1671:
1672: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1673: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1674: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1668: source_cursor := dbms_sql.open_cursor;
1669: dbms_sql.parse(source_cursor,g_tmr_nh_sql,2);
1670: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1671:
1672: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1673: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1674: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1675: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1676: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1669: dbms_sql.parse(source_cursor,g_tmr_nh_sql,2);
1670: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1671:
1672: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1673: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1674: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1675: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1676: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1677: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1670: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1671:
1672: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1673: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1674: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1675: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1676: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1677: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1678: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1671:
1672: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1673: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1674: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1675: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1676: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1677: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1678: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1679: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1672: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1673: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1674: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1675: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1676: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1677: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1678: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1679: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1680: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1673: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1674: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1675: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1676: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1677: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1678: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1679: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1680: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1681: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1674: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1675: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1676: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1677: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1678: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1679: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1680: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1681: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1682: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1675: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1676: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1677: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1678: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1679: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1680: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1681: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1682: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1683: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1676: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1677: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1678: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1679: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1680: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1681: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1682: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1683: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1684:
1677: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1678: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1679: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1680: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1681: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1682: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1683: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1684:
1685: rows_processed := dbms_sql.EXECUTE(source_cursor);
1678: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1679: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1680: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1681: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1682: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1683: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1684:
1685: rows_processed := dbms_sql.EXECUTE(source_cursor);
1686:
1679: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1680: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1681: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1682: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1683: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1684:
1685: rows_processed := dbms_sql.EXECUTE(source_cursor);
1686:
1687: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1681: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1682: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1683: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1684:
1685: rows_processed := dbms_sql.EXECUTE(source_cursor);
1686:
1687: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1688:
1689: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1683: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1684:
1685: rows_processed := dbms_sql.EXECUTE(source_cursor);
1686:
1687: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1688:
1689: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1690: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1691: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1685: rows_processed := dbms_sql.EXECUTE(source_cursor);
1686:
1687: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1688:
1689: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1690: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1691: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1692: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1693: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1686:
1687: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1688:
1689: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1690: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1691: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1692: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1693: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1694: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1687: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1688:
1689: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1690: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1691: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1692: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1693: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1694: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1695: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1688:
1689: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1690: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1691: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1692: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1693: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1694: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1695: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1696: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1689: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1690: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1691: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1692: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1693: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1694: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1695: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1696: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1697: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1690: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1691: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1692: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1693: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1694: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1695: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1696: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1697: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1698: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1691: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1692: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1693: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1694: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1695: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1696: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1697: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1698: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1699: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1692: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1693: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1694: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1695: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1696: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1697: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1698: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1699: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1700: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);
1693: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1694: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1695: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1696: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1697: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1698: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1699: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1700: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);
1701:
1694: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1695: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1696: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1697: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1698: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1699: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1700: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);
1701:
1702: new_hire_table(l_counter3).no_cons_wmale_emps := new_hire_table(l_counter3).no_cons_wmale_emps +
1695: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1696: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1697: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1698: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1699: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1700: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);
1701:
1702: new_hire_table(l_counter3).no_cons_wmale_emps := new_hire_table(l_counter3).no_cons_wmale_emps +
1703: ltrim(rtrim(l_no_tmr_wmale_emps));
1696: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1697: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1698: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1699: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1700: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);
1701:
1702: new_hire_table(l_counter3).no_cons_wmale_emps := new_hire_table(l_counter3).no_cons_wmale_emps +
1703: ltrim(rtrim(l_no_tmr_wmale_emps));
1704: new_hire_table(l_counter3).no_cons_bmale_emps := new_hire_table(l_counter3).no_cons_bmale_emps +
1733: ltrim(rtrim(l_no_tmr_ifemale_emps));
1734:
1735: END IF;
1736:
1737: dbms_sql.close_cursor(source_cursor); -- Closing the cursor
1738:
1739: END LOOP; -- End of get_eeo4_lookup_details
1740:
1741: END populate_nh_emp_data; -- End of populate_oft_emp_data