APPS.PER_US_EEO4_PKG dependencies on DBMS_SQL

Line 692: source_cursor := dbms_sql.open_cursor;

688: l_query_text := 'select count(1) l_ft_emp_count ' || g_from_where_clause|| l_eeo4_ethnic
689: || g_ft_effective_dates || ' AND ass.employment_category in ('||g_fp_regulars||')';
690: --#13610922 changes end
691:
692: source_cursor := dbms_sql.open_cursor;
693: dbms_sql.parse(source_cursor,l_query_text,1);
694: dbms_sql.define_column(source_cursor,1,l_ft_emp_count);
695:
696: rows_processed := dbms_sql.EXECUTE(source_cursor);

Line 693: dbms_sql.parse(source_cursor,l_query_text,1);

689: || g_ft_effective_dates || ' AND ass.employment_category in ('||g_fp_regulars||')';
690: --#13610922 changes end
691:
692: source_cursor := dbms_sql.open_cursor;
693: dbms_sql.parse(source_cursor,l_query_text,1);
694: dbms_sql.define_column(source_cursor,1,l_ft_emp_count);
695:
696: rows_processed := dbms_sql.EXECUTE(source_cursor);
697:

Line 694: dbms_sql.define_column(source_cursor,1,l_ft_emp_count);

690: --#13610922 changes end
691:
692: source_cursor := dbms_sql.open_cursor;
693: dbms_sql.parse(source_cursor,l_query_text,1);
694: dbms_sql.define_column(source_cursor,1,l_ft_emp_count);
695:
696: rows_processed := dbms_sql.EXECUTE(source_cursor);
697:
698: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN

Line 696: rows_processed := dbms_sql.EXECUTE(source_cursor);

692: source_cursor := dbms_sql.open_cursor;
693: dbms_sql.parse(source_cursor,l_query_text,1);
694: dbms_sql.define_column(source_cursor,1,l_ft_emp_count);
695:
696: rows_processed := dbms_sql.EXECUTE(source_cursor);
697:
698: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
699: dbms_sql.column_value(source_cursor, 1, l_ft_emp_count);
700: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_ft_emp_count: ' || l_ft_emp_count);

Line 698: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN

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

Line 699: dbms_sql.column_value(source_cursor, 1, l_ft_emp_count);

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

Line 704: dbms_sql.close_cursor(source_cursor);

700: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_ft_emp_count: ' || l_ft_emp_count);
701:
702: END IF;
703:
704: dbms_sql.close_cursor(source_cursor);
705: --added l_eeo4_ethnic for bug 14034810
706: l_query_text := 'Select job.job_information7 l_function_code,
707: count(1) l_function_count ' || g_from_where_clause || l_eeo4_ethnic || g_ft_effective_dates || ' group by job.job_information7 ';
708: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_query_text: '||l_query_text);

Line 709: source_cursor := dbms_sql.open_cursor;

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

Line 710: dbms_sql.parse(source_cursor,l_query_text,2);

706: l_query_text := 'Select job.job_information7 l_function_code,
707: count(1) l_function_count ' || g_from_where_clause || l_eeo4_ethnic || g_ft_effective_dates || ' group by job.job_information7 ';
708: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_query_text: '||l_query_text);
709: source_cursor := dbms_sql.open_cursor;
710: dbms_sql.parse(source_cursor,l_query_text,2);
711: dbms_sql.define_column_char(source_cursor,1,l_function_code,30);
712: dbms_sql.define_column(source_cursor,2,l_function_count);
713: rows_processed := dbms_sql.EXECUTE(source_cursor);
714:

Line 711: dbms_sql.define_column_char(source_cursor,1,l_function_code,30);

707: count(1) l_function_count ' || g_from_where_clause || l_eeo4_ethnic || g_ft_effective_dates || ' group by job.job_information7 ';
708: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_query_text: '||l_query_text);
709: source_cursor := dbms_sql.open_cursor;
710: dbms_sql.parse(source_cursor,l_query_text,2);
711: dbms_sql.define_column_char(source_cursor,1,l_function_code,30);
712: dbms_sql.define_column(source_cursor,2,l_function_count);
713: rows_processed := dbms_sql.EXECUTE(source_cursor);
714:
715: LOOP

Line 712: dbms_sql.define_column(source_cursor,2,l_function_count);

708: --FND_FILE.PUT_LINE(FND_FILE.LOG,'l_query_text: '||l_query_text);
709: source_cursor := dbms_sql.open_cursor;
710: dbms_sql.parse(source_cursor,l_query_text,2);
711: dbms_sql.define_column_char(source_cursor,1,l_function_code,30);
712: dbms_sql.define_column(source_cursor,2,l_function_count);
713: rows_processed := dbms_sql.EXECUTE(source_cursor);
714:
715: LOOP
716: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN

Line 713: rows_processed := dbms_sql.EXECUTE(source_cursor);

709: source_cursor := dbms_sql.open_cursor;
710: dbms_sql.parse(source_cursor,l_query_text,2);
711: dbms_sql.define_column_char(source_cursor,1,l_function_code,30);
712: dbms_sql.define_column(source_cursor,2,l_function_count);
713: rows_processed := dbms_sql.EXECUTE(source_cursor);
714:
715: LOOP
716: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
717: dbms_sql.column_value_char(source_cursor,1,l_function_code);

Line 716: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN

712: dbms_sql.define_column(source_cursor,2,l_function_count);
713: rows_processed := dbms_sql.EXECUTE(source_cursor);
714:
715: LOOP
716: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
717: dbms_sql.column_value_char(source_cursor,1,l_function_code);
718: dbms_sql.column_value(source_cursor,2,l_function_count);
719: l_function_code := RTRIM(l_function_code);
720:

Line 717: dbms_sql.column_value_char(source_cursor,1,l_function_code);

713: rows_processed := dbms_sql.EXECUTE(source_cursor);
714:
715: LOOP
716: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
717: dbms_sql.column_value_char(source_cursor,1,l_function_code);
718: dbms_sql.column_value(source_cursor,2,l_function_count);
719: l_function_code := RTRIM(l_function_code);
720:
721: -- Fetch the function description

Line 718: dbms_sql.column_value(source_cursor,2,l_function_count);

714:
715: LOOP
716: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
717: dbms_sql.column_value_char(source_cursor,1,l_function_code);
718: dbms_sql.column_value(source_cursor,2,l_function_count);
719: l_function_code := RTRIM(l_function_code);
720:
721: -- Fetch the function description
722: IF l_function_code IS NOT NULL THEN

Line 789: dbms_sql.close_cursor(source_cursor);

785: EXIT;
786: END IF;
787: END LOOP;
788:
789: dbms_sql.close_cursor(source_cursor);
790:
791: -- Bug# 5437076
792: IF l_fo_funct_counter = 0 AND l_so_funct_counter = 0 THEN
793: l_fo_funct_counter := l_fo_funct_counter + 1;

Line 1275: source_cursor := dbms_sql.open_cursor;

1271: g_end_salary := 99900;
1272: g_salary_range := '70.0 PLUS';
1273: END CASE;
1274:
1275: source_cursor := dbms_sql.open_cursor;
1276:
1277: -- Bug# 5414756
1278: IF J = 8 THEN
1279: g_dynamic_where := ' AND round(NVL(ppp.proposed_salary_n * ppb.pay_annualization_factor,0)) >= 70000 ';

Line 1287: dbms_sql.parse(source_cursor,g_ft_emp_sql,2);

1283:
1284: generate_sql(p_function_code, g_dynamic_where);
1285:
1286:
1287: dbms_sql.parse(source_cursor,g_ft_emp_sql,2);
1288: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1289: --dbms_sql.BIND_VARIABLE(source_cursor,':2',g_start_salary);
1290: --dbms_sql.BIND_VARIABLE(source_cursor,':3',g_end_salary);
1291:

Line 1288: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);

1284: generate_sql(p_function_code, g_dynamic_where);
1285:
1286:
1287: dbms_sql.parse(source_cursor,g_ft_emp_sql,2);
1288: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1289: --dbms_sql.BIND_VARIABLE(source_cursor,':2',g_start_salary);
1290: --dbms_sql.BIND_VARIABLE(source_cursor,':3',g_end_salary);
1291:
1292: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);

Line 1289: --dbms_sql.BIND_VARIABLE(source_cursor,':2',g_start_salary);

1285:
1286:
1287: dbms_sql.parse(source_cursor,g_ft_emp_sql,2);
1288: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1289: --dbms_sql.BIND_VARIABLE(source_cursor,':2',g_start_salary);
1290: --dbms_sql.BIND_VARIABLE(source_cursor,':3',g_end_salary);
1291:
1292: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1293: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);

Line 1290: --dbms_sql.BIND_VARIABLE(source_cursor,':3',g_end_salary);

1286:
1287: dbms_sql.parse(source_cursor,g_ft_emp_sql,2);
1288: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1289: --dbms_sql.BIND_VARIABLE(source_cursor,':2',g_start_salary);
1290: --dbms_sql.BIND_VARIABLE(source_cursor,':3',g_end_salary);
1291:
1292: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1293: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1294: --Bug# 6200441

Line 1292: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);

1288: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1289: --dbms_sql.BIND_VARIABLE(source_cursor,':2',g_start_salary);
1290: --dbms_sql.BIND_VARIABLE(source_cursor,':3',g_end_salary);
1291:
1292: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1293: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1294: --Bug# 6200441
1295: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1296: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);

Line 1293: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);

1289: --dbms_sql.BIND_VARIABLE(source_cursor,':2',g_start_salary);
1290: --dbms_sql.BIND_VARIABLE(source_cursor,':3',g_end_salary);
1291:
1292: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1293: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1294: --Bug# 6200441
1295: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1296: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1297: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);

Line 1295: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);

1291:
1292: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1293: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1294: --Bug# 6200441
1295: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1296: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1297: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1298: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1299: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);

Line 1296: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);

1292: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1293: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1294: --Bug# 6200441
1295: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1296: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1297: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1298: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1299: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1300: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);

Line 1297: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);

1293: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1294: --Bug# 6200441
1295: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1296: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1297: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1298: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1299: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1300: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1301: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);

Line 1298: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);

1294: --Bug# 6200441
1295: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1296: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1297: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1298: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1299: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1300: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1301: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1302: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);

Line 1299: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);

1295: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1296: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1297: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1298: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1299: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1300: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1301: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1302: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1303: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);

Line 1300: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);

1296: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1297: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1298: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1299: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1300: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1301: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1302: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1303: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1304: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);

Line 1301: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);

1297: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1298: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1299: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1300: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1301: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1302: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1303: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1304: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1305: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);

Line 1302: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);

1298: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1299: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1300: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1301: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1302: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1303: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1304: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1305: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1306:

Line 1303: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);

1299: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1300: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1301: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1302: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1303: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1304: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1305: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1306:
1307: rows_processed := dbms_sql.EXECUTE(source_cursor);

Line 1304: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);

1300: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1301: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1302: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1303: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1304: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1305: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1306:
1307: rows_processed := dbms_sql.EXECUTE(source_cursor);
1308:

Line 1305: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);

1301: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1302: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1303: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1304: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1305: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1306:
1307: rows_processed := dbms_sql.EXECUTE(source_cursor);
1308:
1309: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN

Line 1307: rows_processed := dbms_sql.EXECUTE(source_cursor);

1303: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1304: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1305: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1306:
1307: rows_processed := dbms_sql.EXECUTE(source_cursor);
1308:
1309: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1310:
1311: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);

Line 1309: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN

1305: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1306:
1307: rows_processed := dbms_sql.EXECUTE(source_cursor);
1308:
1309: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1310:
1311: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1312: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1313: --Bug# 6200441

Line 1311: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);

1307: rows_processed := dbms_sql.EXECUTE(source_cursor);
1308:
1309: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1310:
1311: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1312: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1313: --Bug# 6200441
1314: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1315: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);

Line 1312: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);

1308:
1309: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1310:
1311: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1312: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1313: --Bug# 6200441
1314: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1315: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1316: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);

Line 1314: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);

1310:
1311: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1312: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1313: --Bug# 6200441
1314: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1315: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1316: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1317: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1318: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);

Line 1315: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);

1311: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1312: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1313: --Bug# 6200441
1314: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1315: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1316: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1317: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1318: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1319: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);

Line 1316: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);

1312: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1313: --Bug# 6200441
1314: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1315: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1316: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1317: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1318: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1319: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1320: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);

Line 1317: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);

1313: --Bug# 6200441
1314: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1315: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1316: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1317: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1318: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1319: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1320: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1321: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);

Line 1318: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);

1314: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1315: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1316: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1317: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1318: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1319: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1320: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1321: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1322: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);

Line 1319: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);

1315: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1316: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1317: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1318: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1319: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1320: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1321: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1322: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1323: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);

Line 1320: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);

1316: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1317: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1318: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1319: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1320: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1321: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1322: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1323: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1324: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);

Line 1321: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);

1317: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1318: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1319: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1320: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1321: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1322: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1323: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1324: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);
1325:

Line 1322: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);

1318: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1319: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1320: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1321: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1322: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1323: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1324: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);
1325:
1326: l_counter1 := l_counter1 + 1;

Line 1323: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);

1319: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1320: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1321: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1322: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1323: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1324: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);
1325:
1326: l_counter1 := l_counter1 + 1;
1327:

Line 1324: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);

1320: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1321: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1322: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1323: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1324: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);
1325:
1326: l_counter1 := l_counter1 + 1;
1327:
1328: IF g_for_all_emp = 'T' THEN

Line 1381: dbms_sql.close_cursor(source_cursor); -- Closing the cursor

1377: ft_emp_table(l_counter1).no_cons_hfemale_emps := 0;
1378: ft_emp_table(l_counter1).no_cons_afemale_emps := 0;
1379: ft_emp_table(l_counter1).no_cons_ifemale_emps := 0;
1380: END IF;
1381: dbms_sql.close_cursor(source_cursor); -- Closing the cursor
1382:
1383: -- Bug# 5593259
1384: /* For Two or more races:
1385: If the employee's ethnic code is 'Two or more races',

Line 1390: source_cursor := dbms_sql.open_cursor;

1386: select pei_information5 from per_people_extra_info table
1387: */
1388:
1389: /* Commented for bug#11736960 starts
1390: source_cursor := dbms_sql.open_cursor;
1391: dbms_sql.parse(source_cursor,g_tmr_ft_emp_sql,2);
1392: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1393:
1394: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);

Line 1391: dbms_sql.parse(source_cursor,g_tmr_ft_emp_sql,2);

1387: */
1388:
1389: /* Commented for bug#11736960 starts
1390: source_cursor := dbms_sql.open_cursor;
1391: dbms_sql.parse(source_cursor,g_tmr_ft_emp_sql,2);
1392: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1393:
1394: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1395: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);

Line 1392: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);

1388:
1389: /* Commented for bug#11736960 starts
1390: source_cursor := dbms_sql.open_cursor;
1391: dbms_sql.parse(source_cursor,g_tmr_ft_emp_sql,2);
1392: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1393:
1394: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1395: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1396: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);

Line 1394: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);

1390: source_cursor := dbms_sql.open_cursor;
1391: dbms_sql.parse(source_cursor,g_tmr_ft_emp_sql,2);
1392: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1393:
1394: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1395: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1396: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1397: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1398: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);

Line 1395: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);

1391: dbms_sql.parse(source_cursor,g_tmr_ft_emp_sql,2);
1392: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1393:
1394: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1395: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1396: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1397: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1398: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1399: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);

Line 1396: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);

1392: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1393:
1394: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1395: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1396: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1397: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1398: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1399: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1400: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);

Line 1397: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);

1393:
1394: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1395: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1396: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1397: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1398: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1399: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1400: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1401: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);

Line 1398: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);

1394: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1395: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1396: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1397: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1398: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1399: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1400: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1401: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1402: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);

Line 1399: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);

1395: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1396: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1397: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1398: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1399: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1400: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1401: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1402: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1403: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);

Line 1400: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);

1396: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1397: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1398: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1399: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1400: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1401: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1402: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1403: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1404: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);

Line 1401: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);

1397: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1398: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1399: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1400: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1401: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1402: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1403: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1404: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1405: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);

Line 1402: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);

1398: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1399: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1400: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1401: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1402: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1403: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1404: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1405: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1406:

Line 1403: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);

1399: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1400: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1401: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1402: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1403: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1404: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1405: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1406:
1407: rows_processed := dbms_sql.EXECUTE(source_cursor);

Line 1404: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);

1400: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1401: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1402: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1403: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1404: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1405: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1406:
1407: rows_processed := dbms_sql.EXECUTE(source_cursor);
1408:

Line 1405: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);

1401: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1402: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1403: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1404: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1405: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1406:
1407: rows_processed := dbms_sql.EXECUTE(source_cursor);
1408:
1409: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN

Line 1407: rows_processed := dbms_sql.EXECUTE(source_cursor);

1403: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1404: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1405: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1406:
1407: rows_processed := dbms_sql.EXECUTE(source_cursor);
1408:
1409: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1410:
1411: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);

Line 1409: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN

1405: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1406:
1407: rows_processed := dbms_sql.EXECUTE(source_cursor);
1408:
1409: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1410:
1411: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1412: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1413: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);

Line 1411: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);

1407: rows_processed := dbms_sql.EXECUTE(source_cursor);
1408:
1409: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1410:
1411: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1412: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1413: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1414: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1415: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);

Line 1412: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);

1408:
1409: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1410:
1411: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1412: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1413: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1414: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1415: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1416: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);

Line 1413: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);

1409: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1410:
1411: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1412: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1413: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1414: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1415: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1416: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1417: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);

Line 1414: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);

1410:
1411: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1412: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1413: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1414: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1415: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1416: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1417: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1418: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);

Line 1415: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);

1411: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1412: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1413: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1414: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1415: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1416: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1417: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1418: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1419: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);

Line 1416: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);

1412: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1413: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1414: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1415: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1416: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1417: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1418: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1419: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1420: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);

Line 1417: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);

1413: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1414: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1415: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1416: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1417: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1418: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1419: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1420: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1421: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);

Line 1418: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);

1414: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1415: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1416: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1417: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1418: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1419: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1420: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1421: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1422: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);

Line 1419: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);

1415: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1416: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1417: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1418: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1419: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1420: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1421: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1422: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);
1423:

Line 1420: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);

1416: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1417: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1418: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1419: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1420: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1421: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1422: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);
1423:
1424: ft_emp_table(l_counter1).no_cons_wmale_emps := ft_emp_table(l_counter1).no_cons_wmale_emps +

Line 1421: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);

1417: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1418: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1419: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1420: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1421: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1422: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);
1423:
1424: ft_emp_table(l_counter1).no_cons_wmale_emps := ft_emp_table(l_counter1).no_cons_wmale_emps +
1425: ltrim(rtrim(l_no_tmr_wmale_emps));

Line 1422: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);

1418: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1419: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1420: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1421: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1422: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);
1423:
1424: ft_emp_table(l_counter1).no_cons_wmale_emps := ft_emp_table(l_counter1).no_cons_wmale_emps +
1425: ltrim(rtrim(l_no_tmr_wmale_emps));
1426: ft_emp_table(l_counter1).no_cons_bmale_emps := ft_emp_table(l_counter1).no_cons_bmale_emps +

Line 1459: dbms_sql.close_cursor(source_cursor); -- Closing the cursor

1455: ltrim(rtrim(l_no_tmr_ifemale_emps));
1456:
1457: END IF;
1458:
1459: dbms_sql.close_cursor(source_cursor); -- Closing the cursor
1460: Commented for bug#11736960 ends */
1461:
1462: END LOOP; -- for each salary range
1463: END LOOP; -- for each job category

Line 1513: source_cursor := dbms_sql.open_cursor;

1509:
1510: g_lookup_code := i.lookup_code;
1511: g_meaning := i.meaning;
1512:
1513: source_cursor := dbms_sql.open_cursor;
1514: dbms_sql.parse(source_cursor,g_oft_sql,2);
1515: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1516:
1517: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);

Line 1514: dbms_sql.parse(source_cursor,g_oft_sql,2);

1510: g_lookup_code := i.lookup_code;
1511: g_meaning := i.meaning;
1512:
1513: source_cursor := dbms_sql.open_cursor;
1514: dbms_sql.parse(source_cursor,g_oft_sql,2);
1515: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1516:
1517: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1518: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);

Line 1515: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);

1511: g_meaning := i.meaning;
1512:
1513: source_cursor := dbms_sql.open_cursor;
1514: dbms_sql.parse(source_cursor,g_oft_sql,2);
1515: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1516:
1517: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1518: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1519: -- Bug# 6200441

Line 1517: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);

1513: source_cursor := dbms_sql.open_cursor;
1514: dbms_sql.parse(source_cursor,g_oft_sql,2);
1515: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1516:
1517: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1518: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1519: -- Bug# 6200441
1520: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1521: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);

Line 1518: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);

1514: dbms_sql.parse(source_cursor,g_oft_sql,2);
1515: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1516:
1517: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1518: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1519: -- Bug# 6200441
1520: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1521: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1522: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);

Line 1520: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);

1516:
1517: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1518: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1519: -- Bug# 6200441
1520: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1521: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1522: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1523: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1524: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);

Line 1521: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);

1517: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1518: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1519: -- Bug# 6200441
1520: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1521: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1522: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1523: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1524: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1525: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);

Line 1522: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);

1518: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1519: -- Bug# 6200441
1520: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1521: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1522: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1523: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1524: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1525: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1526: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);

Line 1523: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);

1519: -- Bug# 6200441
1520: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1521: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1522: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1523: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1524: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1525: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1526: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1527: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);

Line 1524: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);

1520: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1521: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1522: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1523: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1524: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1525: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1526: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1527: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1528: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);

Line 1525: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);

1521: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1522: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1523: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1524: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1525: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1526: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1527: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1528: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1529: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);

Line 1526: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);

1522: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1523: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1524: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1525: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1526: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1527: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1528: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1529: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1530: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);

Line 1527: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);

1523: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1524: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1525: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1526: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1527: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1528: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1529: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1530: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1531:

Line 1528: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);

1524: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1525: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1526: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1527: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1528: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1529: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1530: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1531:
1532: rows_processed := dbms_sql.EXECUTE(source_cursor);

Line 1529: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);

1525: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1526: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1527: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1528: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1529: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1530: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1531:
1532: rows_processed := dbms_sql.EXECUTE(source_cursor);
1533:

Line 1530: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);

1526: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1527: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1528: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1529: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1530: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1531:
1532: rows_processed := dbms_sql.EXECUTE(source_cursor);
1533:
1534: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN

Line 1532: rows_processed := dbms_sql.EXECUTE(source_cursor);

1528: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1529: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1530: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1531:
1532: rows_processed := dbms_sql.EXECUTE(source_cursor);
1533:
1534: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1535:
1536: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);

Line 1534: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN

1530: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1531:
1532: rows_processed := dbms_sql.EXECUTE(source_cursor);
1533:
1534: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1535:
1536: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1537: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1538: -- Bug# 6200441

Line 1536: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);

1532: rows_processed := dbms_sql.EXECUTE(source_cursor);
1533:
1534: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1535:
1536: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1537: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1538: -- Bug# 6200441
1539: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1540: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);

Line 1537: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);

1533:
1534: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1535:
1536: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1537: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1538: -- Bug# 6200441
1539: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1540: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1541: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);

Line 1539: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);

1535:
1536: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1537: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1538: -- Bug# 6200441
1539: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1540: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1541: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1542: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1543: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);

Line 1540: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);

1536: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1537: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1538: -- Bug# 6200441
1539: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1540: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1541: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1542: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1543: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1544: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);

Line 1541: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);

1537: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1538: -- Bug# 6200441
1539: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1540: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1541: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1542: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1543: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1544: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1545: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);

Line 1542: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);

1538: -- Bug# 6200441
1539: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1540: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1541: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1542: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1543: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1544: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1545: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1546: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);

Line 1543: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);

1539: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1540: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1541: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1542: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1543: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1544: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1545: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1546: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1547: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);

Line 1544: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);

1540: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1541: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1542: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1543: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1544: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1545: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1546: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1547: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1548: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);

Line 1545: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);

1541: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1542: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1543: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1544: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1545: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1546: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1547: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1548: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1549: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);

Line 1546: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);

1542: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1543: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1544: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1545: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1546: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1547: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1548: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1549: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);
1550:

Line 1547: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);

1543: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1544: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1545: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1546: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1547: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1548: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1549: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);
1550:
1551: l_counter2 := l_counter2 + 1;

Line 1548: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);

1544: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1545: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1546: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1547: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1548: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1549: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);
1550:
1551: l_counter2 := l_counter2 + 1;
1552:

Line 1549: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);

1545: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1546: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1547: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1548: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1549: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);
1550:
1551: l_counter2 := l_counter2 + 1;
1552:
1553: IF g_for_all_emp = 'T' THEN

Line 1604: dbms_sql.close_cursor(source_cursor); -- Close the cursor

1600: other_ft_emp_table(l_counter2).no_cons_hfemale_emps := 0;
1601: other_ft_emp_table(l_counter2).no_cons_afemale_emps := 0;
1602: other_ft_emp_table(l_counter2).no_cons_ifemale_emps := 0;
1603: END IF;
1604: dbms_sql.close_cursor(source_cursor); -- Close the cursor
1605:
1606: -- Bug# 5593259
1607: /* For Two or more races:
1608: If the employee's ethnic code is 'Two or more races',

Line 1613: source_cursor := dbms_sql.open_cursor;

1609: select pei_information5 from per_people_extra_info table
1610: */
1611:
1612: /* Commented for bug#11736960 starts
1613: source_cursor := dbms_sql.open_cursor;
1614: dbms_sql.parse(source_cursor,g_tmr_oft_sql,2);
1615: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1616:
1617: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);

Line 1614: dbms_sql.parse(source_cursor,g_tmr_oft_sql,2);

1610: */
1611:
1612: /* Commented for bug#11736960 starts
1613: source_cursor := dbms_sql.open_cursor;
1614: dbms_sql.parse(source_cursor,g_tmr_oft_sql,2);
1615: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1616:
1617: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1618: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);

Line 1615: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);

1611:
1612: /* Commented for bug#11736960 starts
1613: source_cursor := dbms_sql.open_cursor;
1614: dbms_sql.parse(source_cursor,g_tmr_oft_sql,2);
1615: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1616:
1617: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1618: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1619: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);

Line 1617: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);

1613: source_cursor := dbms_sql.open_cursor;
1614: dbms_sql.parse(source_cursor,g_tmr_oft_sql,2);
1615: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1616:
1617: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1618: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1619: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1620: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1621: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);

Line 1618: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);

1614: dbms_sql.parse(source_cursor,g_tmr_oft_sql,2);
1615: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1616:
1617: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1618: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1619: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1620: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1621: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1622: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);

Line 1619: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);

1615: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1616:
1617: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1618: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1619: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1620: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1621: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1622: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1623: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);

Line 1620: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);

1616:
1617: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1618: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1619: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1620: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1621: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1622: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1623: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1624: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);

Line 1621: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);

1617: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1618: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1619: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1620: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1621: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1622: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1623: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1624: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1625: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);

Line 1622: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);

1618: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1619: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1620: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1621: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1622: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1623: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1624: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1625: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1626: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);

Line 1623: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);

1619: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1620: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1621: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1622: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1623: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1624: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1625: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1626: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1627: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);

Line 1624: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);

1620: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1621: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1622: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1623: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1624: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1625: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1626: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1627: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1628: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);

Line 1625: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);

1621: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1622: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1623: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1624: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1625: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1626: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1627: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1628: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1629:

Line 1626: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);

1622: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1623: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1624: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1625: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1626: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1627: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1628: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1629:
1630: rows_processed := dbms_sql.EXECUTE(source_cursor);

Line 1627: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);

1623: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1624: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1625: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1626: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1627: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1628: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1629:
1630: rows_processed := dbms_sql.EXECUTE(source_cursor);
1631:

Line 1628: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);

1624: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1625: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1626: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1627: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1628: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1629:
1630: rows_processed := dbms_sql.EXECUTE(source_cursor);
1631:
1632: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN

Line 1630: rows_processed := dbms_sql.EXECUTE(source_cursor);

1626: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1627: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1628: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1629:
1630: rows_processed := dbms_sql.EXECUTE(source_cursor);
1631:
1632: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1633:
1634: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);

Line 1632: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN

1628: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1629:
1630: rows_processed := dbms_sql.EXECUTE(source_cursor);
1631:
1632: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1633:
1634: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1635: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1636: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);

Line 1634: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);

1630: rows_processed := dbms_sql.EXECUTE(source_cursor);
1631:
1632: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1633:
1634: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1635: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1636: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1637: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1638: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);

Line 1635: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);

1631:
1632: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1633:
1634: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1635: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1636: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1637: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1638: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1639: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);

Line 1636: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);

1632: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1633:
1634: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1635: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1636: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1637: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1638: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1639: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1640: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);

Line 1637: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);

1633:
1634: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1635: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1636: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1637: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1638: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1639: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1640: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1641: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);

Line 1638: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);

1634: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1635: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1636: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1637: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1638: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1639: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1640: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1641: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1642: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);

Line 1639: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);

1635: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1636: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1637: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1638: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1639: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1640: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1641: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1642: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1643: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);

Line 1640: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);

1636: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1637: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1638: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1639: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1640: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1641: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1642: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1643: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1644: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);

Line 1641: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);

1637: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1638: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1639: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1640: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1641: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1642: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1643: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1644: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1645: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);

Line 1642: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);

1638: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1639: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1640: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1641: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1642: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1643: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1644: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1645: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);
1646:

Line 1643: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);

1639: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1640: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1641: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1642: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1643: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1644: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1645: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);
1646:
1647: other_ft_emp_table(l_counter2).no_cons_wmale_emps := other_ft_emp_table(l_counter2).no_cons_wmale_emps +

Line 1644: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);

1640: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1641: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1642: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1643: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1644: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1645: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);
1646:
1647: other_ft_emp_table(l_counter2).no_cons_wmale_emps := other_ft_emp_table(l_counter2).no_cons_wmale_emps +
1648: ltrim(rtrim(l_no_tmr_wmale_emps));

Line 1645: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);

1641: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1642: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1643: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1644: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1645: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);
1646:
1647: other_ft_emp_table(l_counter2).no_cons_wmale_emps := other_ft_emp_table(l_counter2).no_cons_wmale_emps +
1648: ltrim(rtrim(l_no_tmr_wmale_emps));
1649: other_ft_emp_table(l_counter2).no_cons_bmale_emps := other_ft_emp_table(l_counter2).no_cons_bmale_emps +

Line 1682: dbms_sql.close_cursor(source_cursor); -- Closing the cursor

1678: ltrim(rtrim(l_no_tmr_ifemale_emps));
1679:
1680: END IF;
1681:
1682: dbms_sql.close_cursor(source_cursor); -- Closing the cursor
1683: Commented for bug#11736960 ends */
1684:
1685: END LOOP; -- for each job category
1686: END;

Line 1735: source_cursor := dbms_sql.open_cursor;

1731:
1732: g_lookup_code := i.lookup_code;
1733: g_meaning := i.meaning;
1734:
1735: source_cursor := dbms_sql.open_cursor;
1736:
1737: dbms_sql.parse(source_cursor,g_nh_sql,2);
1738: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1739:

Line 1737: dbms_sql.parse(source_cursor,g_nh_sql,2);

1733: g_meaning := i.meaning;
1734:
1735: source_cursor := dbms_sql.open_cursor;
1736:
1737: dbms_sql.parse(source_cursor,g_nh_sql,2);
1738: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1739:
1740: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1741: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);

Line 1738: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);

1734:
1735: source_cursor := dbms_sql.open_cursor;
1736:
1737: dbms_sql.parse(source_cursor,g_nh_sql,2);
1738: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1739:
1740: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1741: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1742: -- Bug# 6200441

Line 1740: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);

1736:
1737: dbms_sql.parse(source_cursor,g_nh_sql,2);
1738: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1739:
1740: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1741: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1742: -- Bug# 6200441
1743: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1744: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);

Line 1741: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);

1737: dbms_sql.parse(source_cursor,g_nh_sql,2);
1738: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1739:
1740: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1741: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1742: -- Bug# 6200441
1743: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1744: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1745: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);

Line 1743: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);

1739:
1740: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1741: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1742: -- Bug# 6200441
1743: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1744: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1745: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1746: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1747: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);

Line 1744: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);

1740: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1741: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1742: -- Bug# 6200441
1743: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1744: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1745: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1746: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1747: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1748: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);

Line 1745: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);

1741: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1742: -- Bug# 6200441
1743: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1744: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1745: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1746: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1747: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1748: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1749: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);

Line 1746: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);

1742: -- Bug# 6200441
1743: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1744: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1745: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1746: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1747: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1748: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1749: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1750: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);

Line 1747: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);

1743: --dbms_sql.define_column(source_cursor,3,l_cons_total_category_emps);
1744: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1745: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1746: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1747: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1748: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1749: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1750: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1751: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);

Line 1748: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);

1744: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
1745: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1746: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1747: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1748: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1749: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1750: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1751: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1752: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);

Line 1749: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);

1745: dbms_sql.define_column(source_cursor,4,l_no_cons_bmale_emps);
1746: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1747: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1748: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1749: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1750: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1751: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1752: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1753: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);

Line 1750: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);

1746: dbms_sql.define_column(source_cursor,5,l_no_cons_hmale_emps);
1747: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1748: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1749: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1750: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1751: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1752: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1753: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1754:

Line 1751: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);

1747: dbms_sql.define_column(source_cursor,6,l_no_cons_amale_emps);
1748: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1749: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1750: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1751: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1752: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1753: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1754:
1755: rows_processed := dbms_sql.EXECUTE(source_cursor);

Line 1752: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);

1748: dbms_sql.define_column(source_cursor,7,l_no_cons_imale_emps);
1749: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1750: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1751: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1752: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1753: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1754:
1755: rows_processed := dbms_sql.EXECUTE(source_cursor);
1756:

Line 1753: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);

1749: dbms_sql.define_column(source_cursor,8,l_no_cons_wfemale_emps);
1750: dbms_sql.define_column(source_cursor,9,l_no_cons_bfemale_emps);
1751: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1752: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1753: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1754:
1755: rows_processed := dbms_sql.EXECUTE(source_cursor);
1756:
1757: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN

Line 1755: rows_processed := dbms_sql.EXECUTE(source_cursor);

1751: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
1752: dbms_sql.define_column(source_cursor,11,l_no_cons_afemale_emps);
1753: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1754:
1755: rows_processed := dbms_sql.EXECUTE(source_cursor);
1756:
1757: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1758:
1759: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);

Line 1757: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN

1753: dbms_sql.define_column(source_cursor,12,l_no_cons_ifemale_emps);
1754:
1755: rows_processed := dbms_sql.EXECUTE(source_cursor);
1756:
1757: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1758:
1759: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1760: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1761: -- Bug# 6200441

Line 1759: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);

1755: rows_processed := dbms_sql.EXECUTE(source_cursor);
1756:
1757: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1758:
1759: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1760: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1761: -- Bug# 6200441
1762: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1763: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);

Line 1760: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);

1756:
1757: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1758:
1759: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1760: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1761: -- Bug# 6200441
1762: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1763: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1764: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);

Line 1762: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);

1758:
1759: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1760: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1761: -- Bug# 6200441
1762: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1763: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1764: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1765: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1766: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);

Line 1763: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);

1759: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1760: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1761: -- Bug# 6200441
1762: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1763: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1764: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1765: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1766: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1767: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);

Line 1764: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);

1760: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1761: -- Bug# 6200441
1762: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1763: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1764: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1765: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1766: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1767: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1768: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);

Line 1765: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);

1761: -- Bug# 6200441
1762: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1763: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1764: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1765: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1766: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1767: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1768: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1769: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);

Line 1766: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);

1762: --dbms_sql.column_value(source_cursor,3,l_cons_total_category_emps);
1763: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1764: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1765: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1766: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1767: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1768: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1769: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1770: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);

Line 1767: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);

1763: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
1764: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1765: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1766: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1767: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1768: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1769: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1770: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1771: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);

Line 1768: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);

1764: dbms_sql.column_value(source_cursor,4,l_no_cons_bmale_emps);
1765: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1766: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1767: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1768: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1769: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1770: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1771: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1772: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);

Line 1769: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);

1765: dbms_sql.column_value(source_cursor,5,l_no_cons_hmale_emps);
1766: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1767: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1768: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1769: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1770: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1771: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1772: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);
1773:

Line 1770: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);

1766: dbms_sql.column_value(source_cursor,6,l_no_cons_amale_emps);
1767: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1768: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1769: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1770: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1771: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1772: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);
1773:
1774: l_counter3 := l_counter3 + 1;

Line 1771: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);

1767: dbms_sql.column_value(source_cursor,7,l_no_cons_imale_emps);
1768: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1769: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1770: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1771: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1772: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);
1773:
1774: l_counter3 := l_counter3 + 1;
1775:

Line 1772: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);

1768: dbms_sql.column_value(source_cursor,8,l_no_cons_wfemale_emps);
1769: dbms_sql.column_value(source_cursor,9,l_no_cons_bfemale_emps);
1770: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
1771: dbms_sql.column_value(source_cursor,11,l_no_cons_afemale_emps);
1772: dbms_sql.column_value(source_cursor,12,l_no_cons_ifemale_emps);
1773:
1774: l_counter3 := l_counter3 + 1;
1775:
1776: IF g_for_all_emp = 'T' THEN

Line 1827: dbms_sql.close_cursor(source_cursor); -- Close the cursor

1823: new_hire_table(l_counter3).no_cons_hfemale_emps := 0;
1824: new_hire_table(l_counter3).no_cons_afemale_emps := 0;
1825: new_hire_table(l_counter3).no_cons_ifemale_emps := 0;
1826: END IF;
1827: dbms_sql.close_cursor(source_cursor); -- Close the cursor
1828:
1829: -- Bug# 5593259
1830: /* For Two or more races:
1831: If the employee's ethnic code is 'Two or more races',

Line 1836: source_cursor := dbms_sql.open_cursor;

1832: select pei_information5 from per_people_extra_info table
1833: */
1834:
1835: /* Commented for bug#11736960 starts
1836: source_cursor := dbms_sql.open_cursor;
1837: dbms_sql.parse(source_cursor,g_tmr_nh_sql,2);
1838: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1839:
1840: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);

Line 1837: dbms_sql.parse(source_cursor,g_tmr_nh_sql,2);

1833: */
1834:
1835: /* Commented for bug#11736960 starts
1836: source_cursor := dbms_sql.open_cursor;
1837: dbms_sql.parse(source_cursor,g_tmr_nh_sql,2);
1838: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1839:
1840: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1841: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);

Line 1838: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);

1834:
1835: /* Commented for bug#11736960 starts
1836: source_cursor := dbms_sql.open_cursor;
1837: dbms_sql.parse(source_cursor,g_tmr_nh_sql,2);
1838: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1839:
1840: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1841: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1842: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);

Line 1840: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);

1836: source_cursor := dbms_sql.open_cursor;
1837: dbms_sql.parse(source_cursor,g_tmr_nh_sql,2);
1838: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1839:
1840: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1841: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1842: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1843: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1844: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);

Line 1841: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);

1837: dbms_sql.parse(source_cursor,g_tmr_nh_sql,2);
1838: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1839:
1840: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1841: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1842: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1843: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1844: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1845: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);

Line 1842: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);

1838: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
1839:
1840: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1841: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1842: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1843: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1844: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1845: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1846: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);

Line 1843: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);

1839:
1840: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1841: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1842: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1843: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1844: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1845: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1846: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1847: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);

Line 1844: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);

1840: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
1841: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1842: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1843: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1844: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1845: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1846: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1847: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1848: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);

Line 1845: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);

1841: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
1842: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1843: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1844: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1845: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1846: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1847: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1848: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1849: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);

Line 1846: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);

1842: dbms_sql.define_column(source_cursor,3,l_no_tmr_wmale_emps);
1843: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1844: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1845: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1846: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1847: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1848: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1849: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1850: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);

Line 1847: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);

1843: dbms_sql.define_column(source_cursor,4,l_no_tmr_bmale_emps);
1844: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1845: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1846: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1847: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1848: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1849: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1850: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1851: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);

Line 1848: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);

1844: dbms_sql.define_column(source_cursor,5,l_no_tmr_hmale_emps);
1845: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1846: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1847: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1848: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1849: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1850: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1851: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1852:

Line 1849: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);

1845: dbms_sql.define_column(source_cursor,6,l_no_tmr_amale_emps);
1846: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1847: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1848: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1849: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1850: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1851: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1852:
1853: rows_processed := dbms_sql.EXECUTE(source_cursor);

Line 1850: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);

1846: dbms_sql.define_column(source_cursor,7,l_no_tmr_imale_emps);
1847: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1848: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1849: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1850: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1851: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1852:
1853: rows_processed := dbms_sql.EXECUTE(source_cursor);
1854:

Line 1851: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);

1847: dbms_sql.define_column(source_cursor,8,l_no_tmr_wfemale_emps);
1848: dbms_sql.define_column(source_cursor,9,l_no_tmr_bfemale_emps);
1849: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1850: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1851: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1852:
1853: rows_processed := dbms_sql.EXECUTE(source_cursor);
1854:
1855: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN

Line 1853: rows_processed := dbms_sql.EXECUTE(source_cursor);

1849: dbms_sql.define_column(source_cursor,10,l_no_tmr_hfemale_emps);
1850: dbms_sql.define_column(source_cursor,11,l_no_tmr_afemale_emps);
1851: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1852:
1853: rows_processed := dbms_sql.EXECUTE(source_cursor);
1854:
1855: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1856:
1857: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);

Line 1855: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN

1851: dbms_sql.define_column(source_cursor,12,l_no_tmr_ifemale_emps);
1852:
1853: rows_processed := dbms_sql.EXECUTE(source_cursor);
1854:
1855: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1856:
1857: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1858: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1859: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);

Line 1857: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);

1853: rows_processed := dbms_sql.EXECUTE(source_cursor);
1854:
1855: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1856:
1857: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1858: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1859: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1860: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1861: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);

Line 1858: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);

1854:
1855: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1856:
1857: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1858: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1859: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1860: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1861: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1862: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);

Line 1859: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);

1855: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1856:
1857: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1858: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1859: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1860: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1861: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1862: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1863: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);

Line 1860: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);

1856:
1857: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1858: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1859: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1860: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1861: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1862: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1863: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1864: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);

Line 1861: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);

1857: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
1858: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1859: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1860: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1861: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1862: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1863: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1864: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1865: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);

Line 1862: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);

1858: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
1859: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1860: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1861: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1862: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1863: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1864: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1865: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1866: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);

Line 1863: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);

1859: dbms_sql.column_value(source_cursor,3,l_no_tmr_wmale_emps);
1860: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1861: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1862: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1863: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1864: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1865: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1866: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1867: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);

Line 1864: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);

1860: dbms_sql.column_value(source_cursor,4,l_no_tmr_bmale_emps);
1861: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1862: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1863: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1864: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1865: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1866: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1867: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1868: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);

Line 1865: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);

1861: dbms_sql.column_value(source_cursor,5,l_no_tmr_hmale_emps);
1862: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1863: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1864: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1865: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1866: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1867: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1868: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);
1869:

Line 1866: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);

1862: dbms_sql.column_value(source_cursor,6,l_no_tmr_amale_emps);
1863: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1864: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1865: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1866: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1867: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1868: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);
1869:
1870: new_hire_table(l_counter3).no_cons_wmale_emps := new_hire_table(l_counter3).no_cons_wmale_emps +

Line 1867: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);

1863: dbms_sql.column_value(source_cursor,7,l_no_tmr_imale_emps);
1864: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1865: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1866: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1867: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1868: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);
1869:
1870: new_hire_table(l_counter3).no_cons_wmale_emps := new_hire_table(l_counter3).no_cons_wmale_emps +
1871: ltrim(rtrim(l_no_tmr_wmale_emps));

Line 1868: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);

1864: dbms_sql.column_value(source_cursor,8,l_no_tmr_wfemale_emps);
1865: dbms_sql.column_value(source_cursor,9,l_no_tmr_bfemale_emps);
1866: dbms_sql.column_value(source_cursor,10,l_no_tmr_hfemale_emps);
1867: dbms_sql.column_value(source_cursor,11,l_no_tmr_afemale_emps);
1868: dbms_sql.column_value(source_cursor,12,l_no_tmr_ifemale_emps);
1869:
1870: new_hire_table(l_counter3).no_cons_wmale_emps := new_hire_table(l_counter3).no_cons_wmale_emps +
1871: ltrim(rtrim(l_no_tmr_wmale_emps));
1872: new_hire_table(l_counter3).no_cons_bmale_emps := new_hire_table(l_counter3).no_cons_bmale_emps +

Line 1905: dbms_sql.close_cursor(source_cursor); -- Closing the cursor

1901: ltrim(rtrim(l_no_tmr_ifemale_emps));
1902:
1903: END IF;
1904:
1905: dbms_sql.close_cursor(source_cursor); -- Closing the cursor
1906: Commented for bug#11736960 ends */
1907:
1908: END LOOP; -- End of get_eeo4_lookup_details
1909: