APPS.PER_US_EEO4A_PKG dependencies on DBMS_SQL

Line 434: source_cursor := dbms_sql.open_cursor;

430: g_end_salary := 99900;
431: g_salary_range := '70.0 PLUS';
432: END CASE;
433:
434: source_cursor := dbms_sql.open_cursor;
435:
436: IF J = 8 THEN
437: g_dynamic_where := ' AND round(NVL(ppp.proposed_salary_n * ppb.pay_annualization_factor,0)) >= 70000 ';
438: ELSE

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

440: END IF;
441:
442: generate_sql(p_function_code, g_dynamic_where);
443:
444: dbms_sql.parse(source_cursor,g_ft_emp_sql,2);
445: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
446:
447: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
448: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);

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

441:
442: generate_sql(p_function_code, g_dynamic_where);
443:
444: dbms_sql.parse(source_cursor,g_ft_emp_sql,2);
445: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
446:
447: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
448: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
449:

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

443:
444: dbms_sql.parse(source_cursor,g_ft_emp_sql,2);
445: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
446:
447: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
448: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
449:
450: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
451: dbms_sql.define_column(source_cursor,4,l_no_cons_hmale_emps);

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

444: dbms_sql.parse(source_cursor,g_ft_emp_sql,2);
445: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
446:
447: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
448: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
449:
450: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
451: dbms_sql.define_column(source_cursor,4,l_no_cons_hmale_emps);
452: dbms_sql.define_column(source_cursor,5,l_no_cons_cmale_emps);

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

446:
447: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
448: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
449:
450: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
451: dbms_sql.define_column(source_cursor,4,l_no_cons_hmale_emps);
452: dbms_sql.define_column(source_cursor,5,l_no_cons_cmale_emps);
453: dbms_sql.define_column(source_cursor,6,l_no_cons_fmale_emps);
454: dbms_sql.define_column(source_cursor,7,l_no_cons_jmale_emps);

Line 451: dbms_sql.define_column(source_cursor,4,l_no_cons_hmale_emps);

447: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
448: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
449:
450: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
451: dbms_sql.define_column(source_cursor,4,l_no_cons_hmale_emps);
452: dbms_sql.define_column(source_cursor,5,l_no_cons_cmale_emps);
453: dbms_sql.define_column(source_cursor,6,l_no_cons_fmale_emps);
454: dbms_sql.define_column(source_cursor,7,l_no_cons_jmale_emps);
455: dbms_sql.define_column(source_cursor,8,l_no_cons_omale_emps);

Line 452: dbms_sql.define_column(source_cursor,5,l_no_cons_cmale_emps);

448: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
449:
450: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
451: dbms_sql.define_column(source_cursor,4,l_no_cons_hmale_emps);
452: dbms_sql.define_column(source_cursor,5,l_no_cons_cmale_emps);
453: dbms_sql.define_column(source_cursor,6,l_no_cons_fmale_emps);
454: dbms_sql.define_column(source_cursor,7,l_no_cons_jmale_emps);
455: dbms_sql.define_column(source_cursor,8,l_no_cons_omale_emps);
456: dbms_sql.define_column(source_cursor,9,l_no_cons_wfemale_emps);

Line 453: dbms_sql.define_column(source_cursor,6,l_no_cons_fmale_emps);

449:
450: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
451: dbms_sql.define_column(source_cursor,4,l_no_cons_hmale_emps);
452: dbms_sql.define_column(source_cursor,5,l_no_cons_cmale_emps);
453: dbms_sql.define_column(source_cursor,6,l_no_cons_fmale_emps);
454: dbms_sql.define_column(source_cursor,7,l_no_cons_jmale_emps);
455: dbms_sql.define_column(source_cursor,8,l_no_cons_omale_emps);
456: dbms_sql.define_column(source_cursor,9,l_no_cons_wfemale_emps);
457: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);

Line 454: dbms_sql.define_column(source_cursor,7,l_no_cons_jmale_emps);

450: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
451: dbms_sql.define_column(source_cursor,4,l_no_cons_hmale_emps);
452: dbms_sql.define_column(source_cursor,5,l_no_cons_cmale_emps);
453: dbms_sql.define_column(source_cursor,6,l_no_cons_fmale_emps);
454: dbms_sql.define_column(source_cursor,7,l_no_cons_jmale_emps);
455: dbms_sql.define_column(source_cursor,8,l_no_cons_omale_emps);
456: dbms_sql.define_column(source_cursor,9,l_no_cons_wfemale_emps);
457: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
458: dbms_sql.define_column(source_cursor,11,l_no_cons_cfemale_emps);

Line 455: dbms_sql.define_column(source_cursor,8,l_no_cons_omale_emps);

451: dbms_sql.define_column(source_cursor,4,l_no_cons_hmale_emps);
452: dbms_sql.define_column(source_cursor,5,l_no_cons_cmale_emps);
453: dbms_sql.define_column(source_cursor,6,l_no_cons_fmale_emps);
454: dbms_sql.define_column(source_cursor,7,l_no_cons_jmale_emps);
455: dbms_sql.define_column(source_cursor,8,l_no_cons_omale_emps);
456: dbms_sql.define_column(source_cursor,9,l_no_cons_wfemale_emps);
457: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
458: dbms_sql.define_column(source_cursor,11,l_no_cons_cfemale_emps);
459: dbms_sql.define_column(source_cursor,12,l_no_cons_ffemale_emps);

Line 456: dbms_sql.define_column(source_cursor,9,l_no_cons_wfemale_emps);

452: dbms_sql.define_column(source_cursor,5,l_no_cons_cmale_emps);
453: dbms_sql.define_column(source_cursor,6,l_no_cons_fmale_emps);
454: dbms_sql.define_column(source_cursor,7,l_no_cons_jmale_emps);
455: dbms_sql.define_column(source_cursor,8,l_no_cons_omale_emps);
456: dbms_sql.define_column(source_cursor,9,l_no_cons_wfemale_emps);
457: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
458: dbms_sql.define_column(source_cursor,11,l_no_cons_cfemale_emps);
459: dbms_sql.define_column(source_cursor,12,l_no_cons_ffemale_emps);
460: dbms_sql.define_column(source_cursor,13,l_no_cons_jfemale_emps);

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

453: dbms_sql.define_column(source_cursor,6,l_no_cons_fmale_emps);
454: dbms_sql.define_column(source_cursor,7,l_no_cons_jmale_emps);
455: dbms_sql.define_column(source_cursor,8,l_no_cons_omale_emps);
456: dbms_sql.define_column(source_cursor,9,l_no_cons_wfemale_emps);
457: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
458: dbms_sql.define_column(source_cursor,11,l_no_cons_cfemale_emps);
459: dbms_sql.define_column(source_cursor,12,l_no_cons_ffemale_emps);
460: dbms_sql.define_column(source_cursor,13,l_no_cons_jfemale_emps);
461: dbms_sql.define_column(source_cursor,14,l_no_cons_ofemale_emps);

Line 458: dbms_sql.define_column(source_cursor,11,l_no_cons_cfemale_emps);

454: dbms_sql.define_column(source_cursor,7,l_no_cons_jmale_emps);
455: dbms_sql.define_column(source_cursor,8,l_no_cons_omale_emps);
456: dbms_sql.define_column(source_cursor,9,l_no_cons_wfemale_emps);
457: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
458: dbms_sql.define_column(source_cursor,11,l_no_cons_cfemale_emps);
459: dbms_sql.define_column(source_cursor,12,l_no_cons_ffemale_emps);
460: dbms_sql.define_column(source_cursor,13,l_no_cons_jfemale_emps);
461: dbms_sql.define_column(source_cursor,14,l_no_cons_ofemale_emps);
462:

Line 459: dbms_sql.define_column(source_cursor,12,l_no_cons_ffemale_emps);

455: dbms_sql.define_column(source_cursor,8,l_no_cons_omale_emps);
456: dbms_sql.define_column(source_cursor,9,l_no_cons_wfemale_emps);
457: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
458: dbms_sql.define_column(source_cursor,11,l_no_cons_cfemale_emps);
459: dbms_sql.define_column(source_cursor,12,l_no_cons_ffemale_emps);
460: dbms_sql.define_column(source_cursor,13,l_no_cons_jfemale_emps);
461: dbms_sql.define_column(source_cursor,14,l_no_cons_ofemale_emps);
462:
463: rows_processed := dbms_sql.EXECUTE(source_cursor);

Line 460: dbms_sql.define_column(source_cursor,13,l_no_cons_jfemale_emps);

456: dbms_sql.define_column(source_cursor,9,l_no_cons_wfemale_emps);
457: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
458: dbms_sql.define_column(source_cursor,11,l_no_cons_cfemale_emps);
459: dbms_sql.define_column(source_cursor,12,l_no_cons_ffemale_emps);
460: dbms_sql.define_column(source_cursor,13,l_no_cons_jfemale_emps);
461: dbms_sql.define_column(source_cursor,14,l_no_cons_ofemale_emps);
462:
463: rows_processed := dbms_sql.EXECUTE(source_cursor);
464:

Line 461: dbms_sql.define_column(source_cursor,14,l_no_cons_ofemale_emps);

457: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
458: dbms_sql.define_column(source_cursor,11,l_no_cons_cfemale_emps);
459: dbms_sql.define_column(source_cursor,12,l_no_cons_ffemale_emps);
460: dbms_sql.define_column(source_cursor,13,l_no_cons_jfemale_emps);
461: dbms_sql.define_column(source_cursor,14,l_no_cons_ofemale_emps);
462:
463: rows_processed := dbms_sql.EXECUTE(source_cursor);
464:
465: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN

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

459: dbms_sql.define_column(source_cursor,12,l_no_cons_ffemale_emps);
460: dbms_sql.define_column(source_cursor,13,l_no_cons_jfemale_emps);
461: dbms_sql.define_column(source_cursor,14,l_no_cons_ofemale_emps);
462:
463: rows_processed := dbms_sql.EXECUTE(source_cursor);
464:
465: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
466: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
467: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);

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

461: dbms_sql.define_column(source_cursor,14,l_no_cons_ofemale_emps);
462:
463: rows_processed := dbms_sql.EXECUTE(source_cursor);
464:
465: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
466: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
467: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
468:
469: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);

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

462:
463: rows_processed := dbms_sql.EXECUTE(source_cursor);
464:
465: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
466: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
467: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
468:
469: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
470: dbms_sql.column_value(source_cursor,4,l_no_cons_hmale_emps);

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

463: rows_processed := dbms_sql.EXECUTE(source_cursor);
464:
465: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
466: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
467: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
468:
469: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
470: dbms_sql.column_value(source_cursor,4,l_no_cons_hmale_emps);
471: dbms_sql.column_value(source_cursor,5,l_no_cons_cmale_emps);

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

465: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
466: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
467: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
468:
469: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
470: dbms_sql.column_value(source_cursor,4,l_no_cons_hmale_emps);
471: dbms_sql.column_value(source_cursor,5,l_no_cons_cmale_emps);
472: dbms_sql.column_value(source_cursor,6,l_no_cons_fmale_emps);
473: dbms_sql.column_value(source_cursor,7,l_no_cons_jmale_emps);

Line 470: dbms_sql.column_value(source_cursor,4,l_no_cons_hmale_emps);

466: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
467: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
468:
469: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
470: dbms_sql.column_value(source_cursor,4,l_no_cons_hmale_emps);
471: dbms_sql.column_value(source_cursor,5,l_no_cons_cmale_emps);
472: dbms_sql.column_value(source_cursor,6,l_no_cons_fmale_emps);
473: dbms_sql.column_value(source_cursor,7,l_no_cons_jmale_emps);
474: dbms_sql.column_value(source_cursor,8,l_no_cons_omale_emps);

Line 471: dbms_sql.column_value(source_cursor,5,l_no_cons_cmale_emps);

467: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
468:
469: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
470: dbms_sql.column_value(source_cursor,4,l_no_cons_hmale_emps);
471: dbms_sql.column_value(source_cursor,5,l_no_cons_cmale_emps);
472: dbms_sql.column_value(source_cursor,6,l_no_cons_fmale_emps);
473: dbms_sql.column_value(source_cursor,7,l_no_cons_jmale_emps);
474: dbms_sql.column_value(source_cursor,8,l_no_cons_omale_emps);
475: dbms_sql.column_value(source_cursor,9,l_no_cons_wfemale_emps);

Line 472: dbms_sql.column_value(source_cursor,6,l_no_cons_fmale_emps);

468:
469: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
470: dbms_sql.column_value(source_cursor,4,l_no_cons_hmale_emps);
471: dbms_sql.column_value(source_cursor,5,l_no_cons_cmale_emps);
472: dbms_sql.column_value(source_cursor,6,l_no_cons_fmale_emps);
473: dbms_sql.column_value(source_cursor,7,l_no_cons_jmale_emps);
474: dbms_sql.column_value(source_cursor,8,l_no_cons_omale_emps);
475: dbms_sql.column_value(source_cursor,9,l_no_cons_wfemale_emps);
476: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);

Line 473: dbms_sql.column_value(source_cursor,7,l_no_cons_jmale_emps);

469: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
470: dbms_sql.column_value(source_cursor,4,l_no_cons_hmale_emps);
471: dbms_sql.column_value(source_cursor,5,l_no_cons_cmale_emps);
472: dbms_sql.column_value(source_cursor,6,l_no_cons_fmale_emps);
473: dbms_sql.column_value(source_cursor,7,l_no_cons_jmale_emps);
474: dbms_sql.column_value(source_cursor,8,l_no_cons_omale_emps);
475: dbms_sql.column_value(source_cursor,9,l_no_cons_wfemale_emps);
476: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
477: dbms_sql.column_value(source_cursor,11,l_no_cons_cfemale_emps);

Line 474: dbms_sql.column_value(source_cursor,8,l_no_cons_omale_emps);

470: dbms_sql.column_value(source_cursor,4,l_no_cons_hmale_emps);
471: dbms_sql.column_value(source_cursor,5,l_no_cons_cmale_emps);
472: dbms_sql.column_value(source_cursor,6,l_no_cons_fmale_emps);
473: dbms_sql.column_value(source_cursor,7,l_no_cons_jmale_emps);
474: dbms_sql.column_value(source_cursor,8,l_no_cons_omale_emps);
475: dbms_sql.column_value(source_cursor,9,l_no_cons_wfemale_emps);
476: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
477: dbms_sql.column_value(source_cursor,11,l_no_cons_cfemale_emps);
478: dbms_sql.column_value(source_cursor,12,l_no_cons_ffemale_emps);

Line 475: dbms_sql.column_value(source_cursor,9,l_no_cons_wfemale_emps);

471: dbms_sql.column_value(source_cursor,5,l_no_cons_cmale_emps);
472: dbms_sql.column_value(source_cursor,6,l_no_cons_fmale_emps);
473: dbms_sql.column_value(source_cursor,7,l_no_cons_jmale_emps);
474: dbms_sql.column_value(source_cursor,8,l_no_cons_omale_emps);
475: dbms_sql.column_value(source_cursor,9,l_no_cons_wfemale_emps);
476: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
477: dbms_sql.column_value(source_cursor,11,l_no_cons_cfemale_emps);
478: dbms_sql.column_value(source_cursor,12,l_no_cons_ffemale_emps);
479: dbms_sql.column_value(source_cursor,13,l_no_cons_jfemale_emps);

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

472: dbms_sql.column_value(source_cursor,6,l_no_cons_fmale_emps);
473: dbms_sql.column_value(source_cursor,7,l_no_cons_jmale_emps);
474: dbms_sql.column_value(source_cursor,8,l_no_cons_omale_emps);
475: dbms_sql.column_value(source_cursor,9,l_no_cons_wfemale_emps);
476: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
477: dbms_sql.column_value(source_cursor,11,l_no_cons_cfemale_emps);
478: dbms_sql.column_value(source_cursor,12,l_no_cons_ffemale_emps);
479: dbms_sql.column_value(source_cursor,13,l_no_cons_jfemale_emps);
480: dbms_sql.column_value(source_cursor,14,l_no_cons_ofemale_emps);

Line 477: dbms_sql.column_value(source_cursor,11,l_no_cons_cfemale_emps);

473: dbms_sql.column_value(source_cursor,7,l_no_cons_jmale_emps);
474: dbms_sql.column_value(source_cursor,8,l_no_cons_omale_emps);
475: dbms_sql.column_value(source_cursor,9,l_no_cons_wfemale_emps);
476: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
477: dbms_sql.column_value(source_cursor,11,l_no_cons_cfemale_emps);
478: dbms_sql.column_value(source_cursor,12,l_no_cons_ffemale_emps);
479: dbms_sql.column_value(source_cursor,13,l_no_cons_jfemale_emps);
480: dbms_sql.column_value(source_cursor,14,l_no_cons_ofemale_emps);
481:

Line 478: dbms_sql.column_value(source_cursor,12,l_no_cons_ffemale_emps);

474: dbms_sql.column_value(source_cursor,8,l_no_cons_omale_emps);
475: dbms_sql.column_value(source_cursor,9,l_no_cons_wfemale_emps);
476: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
477: dbms_sql.column_value(source_cursor,11,l_no_cons_cfemale_emps);
478: dbms_sql.column_value(source_cursor,12,l_no_cons_ffemale_emps);
479: dbms_sql.column_value(source_cursor,13,l_no_cons_jfemale_emps);
480: dbms_sql.column_value(source_cursor,14,l_no_cons_ofemale_emps);
481:
482:

Line 479: dbms_sql.column_value(source_cursor,13,l_no_cons_jfemale_emps);

475: dbms_sql.column_value(source_cursor,9,l_no_cons_wfemale_emps);
476: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
477: dbms_sql.column_value(source_cursor,11,l_no_cons_cfemale_emps);
478: dbms_sql.column_value(source_cursor,12,l_no_cons_ffemale_emps);
479: dbms_sql.column_value(source_cursor,13,l_no_cons_jfemale_emps);
480: dbms_sql.column_value(source_cursor,14,l_no_cons_ofemale_emps);
481:
482:
483: l_counter1 := l_counter1 + 1;

Line 480: dbms_sql.column_value(source_cursor,14,l_no_cons_ofemale_emps);

476: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
477: dbms_sql.column_value(source_cursor,11,l_no_cons_cfemale_emps);
478: dbms_sql.column_value(source_cursor,12,l_no_cons_ffemale_emps);
479: dbms_sql.column_value(source_cursor,13,l_no_cons_jfemale_emps);
480: dbms_sql.column_value(source_cursor,14,l_no_cons_ofemale_emps);
481:
482:
483: l_counter1 := l_counter1 + 1;
484:

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

541: ft_emp_table(l_counter1).no_cons_ffemale_emps := 0;
542: ft_emp_table(l_counter1).no_cons_jfemale_emps := 0;
543: ft_emp_table(l_counter1).no_cons_ofemale_emps := 0;
544: END IF;
545: dbms_sql.close_cursor(source_cursor); -- Closing the cursor
546: END LOOP; -- for each salary range
547: END LOOP; -- for each job category
548:
549: END populate_ft_emp_data;

Line 585: source_cursor := dbms_sql.open_cursor;

581:
582: g_meaning := i.meaning;
583: g_lookup_code := i.lookup_code;
584:
585: source_cursor := dbms_sql.open_cursor;
586:
587: dbms_sql.parse(source_cursor,g_oft_sql,2);
588: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
589:

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

583: g_lookup_code := i.lookup_code;
584:
585: source_cursor := dbms_sql.open_cursor;
586:
587: dbms_sql.parse(source_cursor,g_oft_sql,2);
588: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
589:
590: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
591: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);

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

584:
585: source_cursor := dbms_sql.open_cursor;
586:
587: dbms_sql.parse(source_cursor,g_oft_sql,2);
588: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
589:
590: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
591: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
592:

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

586:
587: dbms_sql.parse(source_cursor,g_oft_sql,2);
588: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
589:
590: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
591: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
592:
593: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
594: dbms_sql.define_column(source_cursor,4,l_no_cons_hmale_emps);

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

587: dbms_sql.parse(source_cursor,g_oft_sql,2);
588: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
589:
590: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
591: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
592:
593: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
594: dbms_sql.define_column(source_cursor,4,l_no_cons_hmale_emps);
595: dbms_sql.define_column(source_cursor,5,l_no_cons_cmale_emps);

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

589:
590: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
591: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
592:
593: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
594: dbms_sql.define_column(source_cursor,4,l_no_cons_hmale_emps);
595: dbms_sql.define_column(source_cursor,5,l_no_cons_cmale_emps);
596: dbms_sql.define_column(source_cursor,6,l_no_cons_fmale_emps);
597: dbms_sql.define_column(source_cursor,7,l_no_cons_jmale_emps);

Line 594: dbms_sql.define_column(source_cursor,4,l_no_cons_hmale_emps);

590: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
591: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
592:
593: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
594: dbms_sql.define_column(source_cursor,4,l_no_cons_hmale_emps);
595: dbms_sql.define_column(source_cursor,5,l_no_cons_cmale_emps);
596: dbms_sql.define_column(source_cursor,6,l_no_cons_fmale_emps);
597: dbms_sql.define_column(source_cursor,7,l_no_cons_jmale_emps);
598: dbms_sql.define_column(source_cursor,8,l_no_cons_omale_emps);

Line 595: dbms_sql.define_column(source_cursor,5,l_no_cons_cmale_emps);

591: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
592:
593: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
594: dbms_sql.define_column(source_cursor,4,l_no_cons_hmale_emps);
595: dbms_sql.define_column(source_cursor,5,l_no_cons_cmale_emps);
596: dbms_sql.define_column(source_cursor,6,l_no_cons_fmale_emps);
597: dbms_sql.define_column(source_cursor,7,l_no_cons_jmale_emps);
598: dbms_sql.define_column(source_cursor,8,l_no_cons_omale_emps);
599: dbms_sql.define_column(source_cursor,9,l_no_cons_wfemale_emps);

Line 596: dbms_sql.define_column(source_cursor,6,l_no_cons_fmale_emps);

592:
593: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
594: dbms_sql.define_column(source_cursor,4,l_no_cons_hmale_emps);
595: dbms_sql.define_column(source_cursor,5,l_no_cons_cmale_emps);
596: dbms_sql.define_column(source_cursor,6,l_no_cons_fmale_emps);
597: dbms_sql.define_column(source_cursor,7,l_no_cons_jmale_emps);
598: dbms_sql.define_column(source_cursor,8,l_no_cons_omale_emps);
599: dbms_sql.define_column(source_cursor,9,l_no_cons_wfemale_emps);
600: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);

Line 597: dbms_sql.define_column(source_cursor,7,l_no_cons_jmale_emps);

593: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
594: dbms_sql.define_column(source_cursor,4,l_no_cons_hmale_emps);
595: dbms_sql.define_column(source_cursor,5,l_no_cons_cmale_emps);
596: dbms_sql.define_column(source_cursor,6,l_no_cons_fmale_emps);
597: dbms_sql.define_column(source_cursor,7,l_no_cons_jmale_emps);
598: dbms_sql.define_column(source_cursor,8,l_no_cons_omale_emps);
599: dbms_sql.define_column(source_cursor,9,l_no_cons_wfemale_emps);
600: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
601: dbms_sql.define_column(source_cursor,11,l_no_cons_cfemale_emps);

Line 598: dbms_sql.define_column(source_cursor,8,l_no_cons_omale_emps);

594: dbms_sql.define_column(source_cursor,4,l_no_cons_hmale_emps);
595: dbms_sql.define_column(source_cursor,5,l_no_cons_cmale_emps);
596: dbms_sql.define_column(source_cursor,6,l_no_cons_fmale_emps);
597: dbms_sql.define_column(source_cursor,7,l_no_cons_jmale_emps);
598: dbms_sql.define_column(source_cursor,8,l_no_cons_omale_emps);
599: dbms_sql.define_column(source_cursor,9,l_no_cons_wfemale_emps);
600: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
601: dbms_sql.define_column(source_cursor,11,l_no_cons_cfemale_emps);
602: dbms_sql.define_column(source_cursor,12,l_no_cons_ffemale_emps);

Line 599: dbms_sql.define_column(source_cursor,9,l_no_cons_wfemale_emps);

595: dbms_sql.define_column(source_cursor,5,l_no_cons_cmale_emps);
596: dbms_sql.define_column(source_cursor,6,l_no_cons_fmale_emps);
597: dbms_sql.define_column(source_cursor,7,l_no_cons_jmale_emps);
598: dbms_sql.define_column(source_cursor,8,l_no_cons_omale_emps);
599: dbms_sql.define_column(source_cursor,9,l_no_cons_wfemale_emps);
600: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
601: dbms_sql.define_column(source_cursor,11,l_no_cons_cfemale_emps);
602: dbms_sql.define_column(source_cursor,12,l_no_cons_ffemale_emps);
603: dbms_sql.define_column(source_cursor,13,l_no_cons_jfemale_emps);

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

596: dbms_sql.define_column(source_cursor,6,l_no_cons_fmale_emps);
597: dbms_sql.define_column(source_cursor,7,l_no_cons_jmale_emps);
598: dbms_sql.define_column(source_cursor,8,l_no_cons_omale_emps);
599: dbms_sql.define_column(source_cursor,9,l_no_cons_wfemale_emps);
600: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
601: dbms_sql.define_column(source_cursor,11,l_no_cons_cfemale_emps);
602: dbms_sql.define_column(source_cursor,12,l_no_cons_ffemale_emps);
603: dbms_sql.define_column(source_cursor,13,l_no_cons_jfemale_emps);
604: dbms_sql.define_column(source_cursor,14,l_no_cons_ofemale_emps);

Line 601: dbms_sql.define_column(source_cursor,11,l_no_cons_cfemale_emps);

597: dbms_sql.define_column(source_cursor,7,l_no_cons_jmale_emps);
598: dbms_sql.define_column(source_cursor,8,l_no_cons_omale_emps);
599: dbms_sql.define_column(source_cursor,9,l_no_cons_wfemale_emps);
600: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
601: dbms_sql.define_column(source_cursor,11,l_no_cons_cfemale_emps);
602: dbms_sql.define_column(source_cursor,12,l_no_cons_ffemale_emps);
603: dbms_sql.define_column(source_cursor,13,l_no_cons_jfemale_emps);
604: dbms_sql.define_column(source_cursor,14,l_no_cons_ofemale_emps);
605:

Line 602: dbms_sql.define_column(source_cursor,12,l_no_cons_ffemale_emps);

598: dbms_sql.define_column(source_cursor,8,l_no_cons_omale_emps);
599: dbms_sql.define_column(source_cursor,9,l_no_cons_wfemale_emps);
600: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
601: dbms_sql.define_column(source_cursor,11,l_no_cons_cfemale_emps);
602: dbms_sql.define_column(source_cursor,12,l_no_cons_ffemale_emps);
603: dbms_sql.define_column(source_cursor,13,l_no_cons_jfemale_emps);
604: dbms_sql.define_column(source_cursor,14,l_no_cons_ofemale_emps);
605:
606: rows_processed := dbms_sql.EXECUTE(source_cursor);

Line 603: dbms_sql.define_column(source_cursor,13,l_no_cons_jfemale_emps);

599: dbms_sql.define_column(source_cursor,9,l_no_cons_wfemale_emps);
600: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
601: dbms_sql.define_column(source_cursor,11,l_no_cons_cfemale_emps);
602: dbms_sql.define_column(source_cursor,12,l_no_cons_ffemale_emps);
603: dbms_sql.define_column(source_cursor,13,l_no_cons_jfemale_emps);
604: dbms_sql.define_column(source_cursor,14,l_no_cons_ofemale_emps);
605:
606: rows_processed := dbms_sql.EXECUTE(source_cursor);
607:

Line 604: dbms_sql.define_column(source_cursor,14,l_no_cons_ofemale_emps);

600: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
601: dbms_sql.define_column(source_cursor,11,l_no_cons_cfemale_emps);
602: dbms_sql.define_column(source_cursor,12,l_no_cons_ffemale_emps);
603: dbms_sql.define_column(source_cursor,13,l_no_cons_jfemale_emps);
604: dbms_sql.define_column(source_cursor,14,l_no_cons_ofemale_emps);
605:
606: rows_processed := dbms_sql.EXECUTE(source_cursor);
607:
608: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN

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

602: dbms_sql.define_column(source_cursor,12,l_no_cons_ffemale_emps);
603: dbms_sql.define_column(source_cursor,13,l_no_cons_jfemale_emps);
604: dbms_sql.define_column(source_cursor,14,l_no_cons_ofemale_emps);
605:
606: rows_processed := dbms_sql.EXECUTE(source_cursor);
607:
608: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
609:
610: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);

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

604: dbms_sql.define_column(source_cursor,14,l_no_cons_ofemale_emps);
605:
606: rows_processed := dbms_sql.EXECUTE(source_cursor);
607:
608: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
609:
610: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
611: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
612:

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

606: rows_processed := dbms_sql.EXECUTE(source_cursor);
607:
608: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
609:
610: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
611: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
612:
613: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
614: dbms_sql.column_value(source_cursor,4,l_no_cons_hmale_emps);

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

607:
608: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
609:
610: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
611: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
612:
613: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
614: dbms_sql.column_value(source_cursor,4,l_no_cons_hmale_emps);
615: dbms_sql.column_value(source_cursor,5,l_no_cons_cmale_emps);

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

609:
610: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
611: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
612:
613: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
614: dbms_sql.column_value(source_cursor,4,l_no_cons_hmale_emps);
615: dbms_sql.column_value(source_cursor,5,l_no_cons_cmale_emps);
616: dbms_sql.column_value(source_cursor,6,l_no_cons_fmale_emps);
617: dbms_sql.column_value(source_cursor,7,l_no_cons_jmale_emps);

Line 614: dbms_sql.column_value(source_cursor,4,l_no_cons_hmale_emps);

610: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
611: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
612:
613: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
614: dbms_sql.column_value(source_cursor,4,l_no_cons_hmale_emps);
615: dbms_sql.column_value(source_cursor,5,l_no_cons_cmale_emps);
616: dbms_sql.column_value(source_cursor,6,l_no_cons_fmale_emps);
617: dbms_sql.column_value(source_cursor,7,l_no_cons_jmale_emps);
618: dbms_sql.column_value(source_cursor,8,l_no_cons_omale_emps);

Line 615: dbms_sql.column_value(source_cursor,5,l_no_cons_cmale_emps);

611: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
612:
613: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
614: dbms_sql.column_value(source_cursor,4,l_no_cons_hmale_emps);
615: dbms_sql.column_value(source_cursor,5,l_no_cons_cmale_emps);
616: dbms_sql.column_value(source_cursor,6,l_no_cons_fmale_emps);
617: dbms_sql.column_value(source_cursor,7,l_no_cons_jmale_emps);
618: dbms_sql.column_value(source_cursor,8,l_no_cons_omale_emps);
619: dbms_sql.column_value(source_cursor,9,l_no_cons_wfemale_emps);

Line 616: dbms_sql.column_value(source_cursor,6,l_no_cons_fmale_emps);

612:
613: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
614: dbms_sql.column_value(source_cursor,4,l_no_cons_hmale_emps);
615: dbms_sql.column_value(source_cursor,5,l_no_cons_cmale_emps);
616: dbms_sql.column_value(source_cursor,6,l_no_cons_fmale_emps);
617: dbms_sql.column_value(source_cursor,7,l_no_cons_jmale_emps);
618: dbms_sql.column_value(source_cursor,8,l_no_cons_omale_emps);
619: dbms_sql.column_value(source_cursor,9,l_no_cons_wfemale_emps);
620: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);

Line 617: dbms_sql.column_value(source_cursor,7,l_no_cons_jmale_emps);

613: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
614: dbms_sql.column_value(source_cursor,4,l_no_cons_hmale_emps);
615: dbms_sql.column_value(source_cursor,5,l_no_cons_cmale_emps);
616: dbms_sql.column_value(source_cursor,6,l_no_cons_fmale_emps);
617: dbms_sql.column_value(source_cursor,7,l_no_cons_jmale_emps);
618: dbms_sql.column_value(source_cursor,8,l_no_cons_omale_emps);
619: dbms_sql.column_value(source_cursor,9,l_no_cons_wfemale_emps);
620: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
621: dbms_sql.column_value(source_cursor,11,l_no_cons_cfemale_emps);

Line 618: dbms_sql.column_value(source_cursor,8,l_no_cons_omale_emps);

614: dbms_sql.column_value(source_cursor,4,l_no_cons_hmale_emps);
615: dbms_sql.column_value(source_cursor,5,l_no_cons_cmale_emps);
616: dbms_sql.column_value(source_cursor,6,l_no_cons_fmale_emps);
617: dbms_sql.column_value(source_cursor,7,l_no_cons_jmale_emps);
618: dbms_sql.column_value(source_cursor,8,l_no_cons_omale_emps);
619: dbms_sql.column_value(source_cursor,9,l_no_cons_wfemale_emps);
620: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
621: dbms_sql.column_value(source_cursor,11,l_no_cons_cfemale_emps);
622: dbms_sql.column_value(source_cursor,12,l_no_cons_ffemale_emps);

Line 619: dbms_sql.column_value(source_cursor,9,l_no_cons_wfemale_emps);

615: dbms_sql.column_value(source_cursor,5,l_no_cons_cmale_emps);
616: dbms_sql.column_value(source_cursor,6,l_no_cons_fmale_emps);
617: dbms_sql.column_value(source_cursor,7,l_no_cons_jmale_emps);
618: dbms_sql.column_value(source_cursor,8,l_no_cons_omale_emps);
619: dbms_sql.column_value(source_cursor,9,l_no_cons_wfemale_emps);
620: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
621: dbms_sql.column_value(source_cursor,11,l_no_cons_cfemale_emps);
622: dbms_sql.column_value(source_cursor,12,l_no_cons_ffemale_emps);
623: dbms_sql.column_value(source_cursor,13,l_no_cons_jfemale_emps);

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

616: dbms_sql.column_value(source_cursor,6,l_no_cons_fmale_emps);
617: dbms_sql.column_value(source_cursor,7,l_no_cons_jmale_emps);
618: dbms_sql.column_value(source_cursor,8,l_no_cons_omale_emps);
619: dbms_sql.column_value(source_cursor,9,l_no_cons_wfemale_emps);
620: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
621: dbms_sql.column_value(source_cursor,11,l_no_cons_cfemale_emps);
622: dbms_sql.column_value(source_cursor,12,l_no_cons_ffemale_emps);
623: dbms_sql.column_value(source_cursor,13,l_no_cons_jfemale_emps);
624: dbms_sql.column_value(source_cursor,14,l_no_cons_ofemale_emps);

Line 621: dbms_sql.column_value(source_cursor,11,l_no_cons_cfemale_emps);

617: dbms_sql.column_value(source_cursor,7,l_no_cons_jmale_emps);
618: dbms_sql.column_value(source_cursor,8,l_no_cons_omale_emps);
619: dbms_sql.column_value(source_cursor,9,l_no_cons_wfemale_emps);
620: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
621: dbms_sql.column_value(source_cursor,11,l_no_cons_cfemale_emps);
622: dbms_sql.column_value(source_cursor,12,l_no_cons_ffemale_emps);
623: dbms_sql.column_value(source_cursor,13,l_no_cons_jfemale_emps);
624: dbms_sql.column_value(source_cursor,14,l_no_cons_ofemale_emps);
625:

Line 622: dbms_sql.column_value(source_cursor,12,l_no_cons_ffemale_emps);

618: dbms_sql.column_value(source_cursor,8,l_no_cons_omale_emps);
619: dbms_sql.column_value(source_cursor,9,l_no_cons_wfemale_emps);
620: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
621: dbms_sql.column_value(source_cursor,11,l_no_cons_cfemale_emps);
622: dbms_sql.column_value(source_cursor,12,l_no_cons_ffemale_emps);
623: dbms_sql.column_value(source_cursor,13,l_no_cons_jfemale_emps);
624: dbms_sql.column_value(source_cursor,14,l_no_cons_ofemale_emps);
625:
626: l_counter2 := l_counter2 + 1;

Line 623: dbms_sql.column_value(source_cursor,13,l_no_cons_jfemale_emps);

619: dbms_sql.column_value(source_cursor,9,l_no_cons_wfemale_emps);
620: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
621: dbms_sql.column_value(source_cursor,11,l_no_cons_cfemale_emps);
622: dbms_sql.column_value(source_cursor,12,l_no_cons_ffemale_emps);
623: dbms_sql.column_value(source_cursor,13,l_no_cons_jfemale_emps);
624: dbms_sql.column_value(source_cursor,14,l_no_cons_ofemale_emps);
625:
626: l_counter2 := l_counter2 + 1;
627:

Line 624: dbms_sql.column_value(source_cursor,14,l_no_cons_ofemale_emps);

620: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
621: dbms_sql.column_value(source_cursor,11,l_no_cons_cfemale_emps);
622: dbms_sql.column_value(source_cursor,12,l_no_cons_ffemale_emps);
623: dbms_sql.column_value(source_cursor,13,l_no_cons_jfemale_emps);
624: dbms_sql.column_value(source_cursor,14,l_no_cons_ofemale_emps);
625:
626: l_counter2 := l_counter2 + 1;
627:
628: IF g_for_all_emp = 'T' THEN

Line 690: dbms_sql.close_cursor(source_cursor);

686: other_ft_emp_table(l_counter2).no_cons_ofemale_emps := 0;
687:
688: END IF;
689:
690: dbms_sql.close_cursor(source_cursor);
691:
692: END LOOP;--FOR EACH JOB CATEGORY
693:
694: END populate_oft_emp_data;

Line 732: source_cursor := dbms_sql.open_cursor;

728:
729: g_lookup_code := i.lookup_code;
730: g_meaning := i.meaning;
731:
732: source_cursor := dbms_sql.open_cursor;
733:
734: dbms_sql.parse(source_cursor,g_nh_sql,2);
735: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
736:

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

730: g_meaning := i.meaning;
731:
732: source_cursor := dbms_sql.open_cursor;
733:
734: dbms_sql.parse(source_cursor,g_nh_sql,2);
735: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
736:
737: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
738: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);

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

731:
732: source_cursor := dbms_sql.open_cursor;
733:
734: dbms_sql.parse(source_cursor,g_nh_sql,2);
735: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
736:
737: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
738: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
739:

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

733:
734: dbms_sql.parse(source_cursor,g_nh_sql,2);
735: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
736:
737: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
738: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
739:
740: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
741: dbms_sql.define_column(source_cursor,4,l_no_cons_hmale_emps);

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

734: dbms_sql.parse(source_cursor,g_nh_sql,2);
735: dbms_sql.BIND_VARIABLE(source_cursor,':1',g_lookup_code);
736:
737: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
738: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
739:
740: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
741: dbms_sql.define_column(source_cursor,4,l_no_cons_hmale_emps);
742: dbms_sql.define_column(source_cursor,5,l_no_cons_cmale_emps);

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

736:
737: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
738: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
739:
740: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
741: dbms_sql.define_column(source_cursor,4,l_no_cons_hmale_emps);
742: dbms_sql.define_column(source_cursor,5,l_no_cons_cmale_emps);
743: dbms_sql.define_column(source_cursor,6,l_no_cons_fmale_emps);
744: dbms_sql.define_column(source_cursor,7,l_no_cons_jmale_emps);

Line 741: dbms_sql.define_column(source_cursor,4,l_no_cons_hmale_emps);

737: dbms_sql.define_column_char(source_cursor,1,l_job_category_code,4000);
738: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
739:
740: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
741: dbms_sql.define_column(source_cursor,4,l_no_cons_hmale_emps);
742: dbms_sql.define_column(source_cursor,5,l_no_cons_cmale_emps);
743: dbms_sql.define_column(source_cursor,6,l_no_cons_fmale_emps);
744: dbms_sql.define_column(source_cursor,7,l_no_cons_jmale_emps);
745: dbms_sql.define_column(source_cursor,8,l_no_cons_omale_emps);

Line 742: dbms_sql.define_column(source_cursor,5,l_no_cons_cmale_emps);

738: dbms_sql.define_column_char(source_cursor,2,l_job_category_name,4000);
739:
740: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
741: dbms_sql.define_column(source_cursor,4,l_no_cons_hmale_emps);
742: dbms_sql.define_column(source_cursor,5,l_no_cons_cmale_emps);
743: dbms_sql.define_column(source_cursor,6,l_no_cons_fmale_emps);
744: dbms_sql.define_column(source_cursor,7,l_no_cons_jmale_emps);
745: dbms_sql.define_column(source_cursor,8,l_no_cons_omale_emps);
746: dbms_sql.define_column(source_cursor,9,l_no_cons_wfemale_emps);

Line 743: dbms_sql.define_column(source_cursor,6,l_no_cons_fmale_emps);

739:
740: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
741: dbms_sql.define_column(source_cursor,4,l_no_cons_hmale_emps);
742: dbms_sql.define_column(source_cursor,5,l_no_cons_cmale_emps);
743: dbms_sql.define_column(source_cursor,6,l_no_cons_fmale_emps);
744: dbms_sql.define_column(source_cursor,7,l_no_cons_jmale_emps);
745: dbms_sql.define_column(source_cursor,8,l_no_cons_omale_emps);
746: dbms_sql.define_column(source_cursor,9,l_no_cons_wfemale_emps);
747: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);

Line 744: dbms_sql.define_column(source_cursor,7,l_no_cons_jmale_emps);

740: dbms_sql.define_column(source_cursor,3,l_no_cons_wmale_emps);
741: dbms_sql.define_column(source_cursor,4,l_no_cons_hmale_emps);
742: dbms_sql.define_column(source_cursor,5,l_no_cons_cmale_emps);
743: dbms_sql.define_column(source_cursor,6,l_no_cons_fmale_emps);
744: dbms_sql.define_column(source_cursor,7,l_no_cons_jmale_emps);
745: dbms_sql.define_column(source_cursor,8,l_no_cons_omale_emps);
746: dbms_sql.define_column(source_cursor,9,l_no_cons_wfemale_emps);
747: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
748: dbms_sql.define_column(source_cursor,11,l_no_cons_cfemale_emps);

Line 745: dbms_sql.define_column(source_cursor,8,l_no_cons_omale_emps);

741: dbms_sql.define_column(source_cursor,4,l_no_cons_hmale_emps);
742: dbms_sql.define_column(source_cursor,5,l_no_cons_cmale_emps);
743: dbms_sql.define_column(source_cursor,6,l_no_cons_fmale_emps);
744: dbms_sql.define_column(source_cursor,7,l_no_cons_jmale_emps);
745: dbms_sql.define_column(source_cursor,8,l_no_cons_omale_emps);
746: dbms_sql.define_column(source_cursor,9,l_no_cons_wfemale_emps);
747: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
748: dbms_sql.define_column(source_cursor,11,l_no_cons_cfemale_emps);
749: dbms_sql.define_column(source_cursor,12,l_no_cons_ffemale_emps);

Line 746: dbms_sql.define_column(source_cursor,9,l_no_cons_wfemale_emps);

742: dbms_sql.define_column(source_cursor,5,l_no_cons_cmale_emps);
743: dbms_sql.define_column(source_cursor,6,l_no_cons_fmale_emps);
744: dbms_sql.define_column(source_cursor,7,l_no_cons_jmale_emps);
745: dbms_sql.define_column(source_cursor,8,l_no_cons_omale_emps);
746: dbms_sql.define_column(source_cursor,9,l_no_cons_wfemale_emps);
747: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
748: dbms_sql.define_column(source_cursor,11,l_no_cons_cfemale_emps);
749: dbms_sql.define_column(source_cursor,12,l_no_cons_ffemale_emps);
750: dbms_sql.define_column(source_cursor,13,l_no_cons_jfemale_emps);

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

743: dbms_sql.define_column(source_cursor,6,l_no_cons_fmale_emps);
744: dbms_sql.define_column(source_cursor,7,l_no_cons_jmale_emps);
745: dbms_sql.define_column(source_cursor,8,l_no_cons_omale_emps);
746: dbms_sql.define_column(source_cursor,9,l_no_cons_wfemale_emps);
747: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
748: dbms_sql.define_column(source_cursor,11,l_no_cons_cfemale_emps);
749: dbms_sql.define_column(source_cursor,12,l_no_cons_ffemale_emps);
750: dbms_sql.define_column(source_cursor,13,l_no_cons_jfemale_emps);
751: dbms_sql.define_column(source_cursor,14,l_no_cons_ofemale_emps);

Line 748: dbms_sql.define_column(source_cursor,11,l_no_cons_cfemale_emps);

744: dbms_sql.define_column(source_cursor,7,l_no_cons_jmale_emps);
745: dbms_sql.define_column(source_cursor,8,l_no_cons_omale_emps);
746: dbms_sql.define_column(source_cursor,9,l_no_cons_wfemale_emps);
747: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
748: dbms_sql.define_column(source_cursor,11,l_no_cons_cfemale_emps);
749: dbms_sql.define_column(source_cursor,12,l_no_cons_ffemale_emps);
750: dbms_sql.define_column(source_cursor,13,l_no_cons_jfemale_emps);
751: dbms_sql.define_column(source_cursor,14,l_no_cons_ofemale_emps);
752:

Line 749: dbms_sql.define_column(source_cursor,12,l_no_cons_ffemale_emps);

745: dbms_sql.define_column(source_cursor,8,l_no_cons_omale_emps);
746: dbms_sql.define_column(source_cursor,9,l_no_cons_wfemale_emps);
747: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
748: dbms_sql.define_column(source_cursor,11,l_no_cons_cfemale_emps);
749: dbms_sql.define_column(source_cursor,12,l_no_cons_ffemale_emps);
750: dbms_sql.define_column(source_cursor,13,l_no_cons_jfemale_emps);
751: dbms_sql.define_column(source_cursor,14,l_no_cons_ofemale_emps);
752:
753: rows_processed := dbms_sql.EXECUTE(source_cursor);

Line 750: dbms_sql.define_column(source_cursor,13,l_no_cons_jfemale_emps);

746: dbms_sql.define_column(source_cursor,9,l_no_cons_wfemale_emps);
747: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
748: dbms_sql.define_column(source_cursor,11,l_no_cons_cfemale_emps);
749: dbms_sql.define_column(source_cursor,12,l_no_cons_ffemale_emps);
750: dbms_sql.define_column(source_cursor,13,l_no_cons_jfemale_emps);
751: dbms_sql.define_column(source_cursor,14,l_no_cons_ofemale_emps);
752:
753: rows_processed := dbms_sql.EXECUTE(source_cursor);
754:

Line 751: dbms_sql.define_column(source_cursor,14,l_no_cons_ofemale_emps);

747: dbms_sql.define_column(source_cursor,10,l_no_cons_hfemale_emps);
748: dbms_sql.define_column(source_cursor,11,l_no_cons_cfemale_emps);
749: dbms_sql.define_column(source_cursor,12,l_no_cons_ffemale_emps);
750: dbms_sql.define_column(source_cursor,13,l_no_cons_jfemale_emps);
751: dbms_sql.define_column(source_cursor,14,l_no_cons_ofemale_emps);
752:
753: rows_processed := dbms_sql.EXECUTE(source_cursor);
754:
755: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN

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

749: dbms_sql.define_column(source_cursor,12,l_no_cons_ffemale_emps);
750: dbms_sql.define_column(source_cursor,13,l_no_cons_jfemale_emps);
751: dbms_sql.define_column(source_cursor,14,l_no_cons_ofemale_emps);
752:
753: rows_processed := dbms_sql.EXECUTE(source_cursor);
754:
755: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
756:
757: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);

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

751: dbms_sql.define_column(source_cursor,14,l_no_cons_ofemale_emps);
752:
753: rows_processed := dbms_sql.EXECUTE(source_cursor);
754:
755: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
756:
757: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
758: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
759:

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

753: rows_processed := dbms_sql.EXECUTE(source_cursor);
754:
755: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
756:
757: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
758: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
759:
760: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
761: dbms_sql.column_value(source_cursor,4,l_no_cons_hmale_emps);

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

754:
755: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
756:
757: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
758: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
759:
760: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
761: dbms_sql.column_value(source_cursor,4,l_no_cons_hmale_emps);
762: dbms_sql.column_value(source_cursor,5,l_no_cons_cmale_emps);

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

756:
757: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
758: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
759:
760: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
761: dbms_sql.column_value(source_cursor,4,l_no_cons_hmale_emps);
762: dbms_sql.column_value(source_cursor,5,l_no_cons_cmale_emps);
763: dbms_sql.column_value(source_cursor,6,l_no_cons_fmale_emps);
764: dbms_sql.column_value(source_cursor,7,l_no_cons_jmale_emps);

Line 761: dbms_sql.column_value(source_cursor,4,l_no_cons_hmale_emps);

757: dbms_sql.column_value_char(source_cursor,1,l_job_category_code);
758: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
759:
760: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
761: dbms_sql.column_value(source_cursor,4,l_no_cons_hmale_emps);
762: dbms_sql.column_value(source_cursor,5,l_no_cons_cmale_emps);
763: dbms_sql.column_value(source_cursor,6,l_no_cons_fmale_emps);
764: dbms_sql.column_value(source_cursor,7,l_no_cons_jmale_emps);
765: dbms_sql.column_value(source_cursor,8,l_no_cons_omale_emps);

Line 762: dbms_sql.column_value(source_cursor,5,l_no_cons_cmale_emps);

758: dbms_sql.column_value_char(source_cursor,2,l_job_category_name);
759:
760: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
761: dbms_sql.column_value(source_cursor,4,l_no_cons_hmale_emps);
762: dbms_sql.column_value(source_cursor,5,l_no_cons_cmale_emps);
763: dbms_sql.column_value(source_cursor,6,l_no_cons_fmale_emps);
764: dbms_sql.column_value(source_cursor,7,l_no_cons_jmale_emps);
765: dbms_sql.column_value(source_cursor,8,l_no_cons_omale_emps);
766: dbms_sql.column_value(source_cursor,9,l_no_cons_wfemale_emps);

Line 763: dbms_sql.column_value(source_cursor,6,l_no_cons_fmale_emps);

759:
760: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
761: dbms_sql.column_value(source_cursor,4,l_no_cons_hmale_emps);
762: dbms_sql.column_value(source_cursor,5,l_no_cons_cmale_emps);
763: dbms_sql.column_value(source_cursor,6,l_no_cons_fmale_emps);
764: dbms_sql.column_value(source_cursor,7,l_no_cons_jmale_emps);
765: dbms_sql.column_value(source_cursor,8,l_no_cons_omale_emps);
766: dbms_sql.column_value(source_cursor,9,l_no_cons_wfemale_emps);
767: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);

Line 764: dbms_sql.column_value(source_cursor,7,l_no_cons_jmale_emps);

760: dbms_sql.column_value(source_cursor,3,l_no_cons_wmale_emps);
761: dbms_sql.column_value(source_cursor,4,l_no_cons_hmale_emps);
762: dbms_sql.column_value(source_cursor,5,l_no_cons_cmale_emps);
763: dbms_sql.column_value(source_cursor,6,l_no_cons_fmale_emps);
764: dbms_sql.column_value(source_cursor,7,l_no_cons_jmale_emps);
765: dbms_sql.column_value(source_cursor,8,l_no_cons_omale_emps);
766: dbms_sql.column_value(source_cursor,9,l_no_cons_wfemale_emps);
767: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
768: dbms_sql.column_value(source_cursor,11,l_no_cons_cfemale_emps);

Line 765: dbms_sql.column_value(source_cursor,8,l_no_cons_omale_emps);

761: dbms_sql.column_value(source_cursor,4,l_no_cons_hmale_emps);
762: dbms_sql.column_value(source_cursor,5,l_no_cons_cmale_emps);
763: dbms_sql.column_value(source_cursor,6,l_no_cons_fmale_emps);
764: dbms_sql.column_value(source_cursor,7,l_no_cons_jmale_emps);
765: dbms_sql.column_value(source_cursor,8,l_no_cons_omale_emps);
766: dbms_sql.column_value(source_cursor,9,l_no_cons_wfemale_emps);
767: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
768: dbms_sql.column_value(source_cursor,11,l_no_cons_cfemale_emps);
769: dbms_sql.column_value(source_cursor,12,l_no_cons_ffemale_emps);

Line 766: dbms_sql.column_value(source_cursor,9,l_no_cons_wfemale_emps);

762: dbms_sql.column_value(source_cursor,5,l_no_cons_cmale_emps);
763: dbms_sql.column_value(source_cursor,6,l_no_cons_fmale_emps);
764: dbms_sql.column_value(source_cursor,7,l_no_cons_jmale_emps);
765: dbms_sql.column_value(source_cursor,8,l_no_cons_omale_emps);
766: dbms_sql.column_value(source_cursor,9,l_no_cons_wfemale_emps);
767: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
768: dbms_sql.column_value(source_cursor,11,l_no_cons_cfemale_emps);
769: dbms_sql.column_value(source_cursor,12,l_no_cons_ffemale_emps);
770: dbms_sql.column_value(source_cursor,13,l_no_cons_jfemale_emps);

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

763: dbms_sql.column_value(source_cursor,6,l_no_cons_fmale_emps);
764: dbms_sql.column_value(source_cursor,7,l_no_cons_jmale_emps);
765: dbms_sql.column_value(source_cursor,8,l_no_cons_omale_emps);
766: dbms_sql.column_value(source_cursor,9,l_no_cons_wfemale_emps);
767: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
768: dbms_sql.column_value(source_cursor,11,l_no_cons_cfemale_emps);
769: dbms_sql.column_value(source_cursor,12,l_no_cons_ffemale_emps);
770: dbms_sql.column_value(source_cursor,13,l_no_cons_jfemale_emps);
771: dbms_sql.column_value(source_cursor,14,l_no_cons_ofemale_emps);

Line 768: dbms_sql.column_value(source_cursor,11,l_no_cons_cfemale_emps);

764: dbms_sql.column_value(source_cursor,7,l_no_cons_jmale_emps);
765: dbms_sql.column_value(source_cursor,8,l_no_cons_omale_emps);
766: dbms_sql.column_value(source_cursor,9,l_no_cons_wfemale_emps);
767: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
768: dbms_sql.column_value(source_cursor,11,l_no_cons_cfemale_emps);
769: dbms_sql.column_value(source_cursor,12,l_no_cons_ffemale_emps);
770: dbms_sql.column_value(source_cursor,13,l_no_cons_jfemale_emps);
771: dbms_sql.column_value(source_cursor,14,l_no_cons_ofemale_emps);
772:

Line 769: dbms_sql.column_value(source_cursor,12,l_no_cons_ffemale_emps);

765: dbms_sql.column_value(source_cursor,8,l_no_cons_omale_emps);
766: dbms_sql.column_value(source_cursor,9,l_no_cons_wfemale_emps);
767: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
768: dbms_sql.column_value(source_cursor,11,l_no_cons_cfemale_emps);
769: dbms_sql.column_value(source_cursor,12,l_no_cons_ffemale_emps);
770: dbms_sql.column_value(source_cursor,13,l_no_cons_jfemale_emps);
771: dbms_sql.column_value(source_cursor,14,l_no_cons_ofemale_emps);
772:
773: l_counter3 := l_counter3 + 1;

Line 770: dbms_sql.column_value(source_cursor,13,l_no_cons_jfemale_emps);

766: dbms_sql.column_value(source_cursor,9,l_no_cons_wfemale_emps);
767: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
768: dbms_sql.column_value(source_cursor,11,l_no_cons_cfemale_emps);
769: dbms_sql.column_value(source_cursor,12,l_no_cons_ffemale_emps);
770: dbms_sql.column_value(source_cursor,13,l_no_cons_jfemale_emps);
771: dbms_sql.column_value(source_cursor,14,l_no_cons_ofemale_emps);
772:
773: l_counter3 := l_counter3 + 1;
774:

Line 771: dbms_sql.column_value(source_cursor,14,l_no_cons_ofemale_emps);

767: dbms_sql.column_value(source_cursor,10,l_no_cons_hfemale_emps);
768: dbms_sql.column_value(source_cursor,11,l_no_cons_cfemale_emps);
769: dbms_sql.column_value(source_cursor,12,l_no_cons_ffemale_emps);
770: dbms_sql.column_value(source_cursor,13,l_no_cons_jfemale_emps);
771: dbms_sql.column_value(source_cursor,14,l_no_cons_ofemale_emps);
772:
773: l_counter3 := l_counter3 + 1;
774:
775: IF g_for_all_emp = 'T' THEN

Line 832: dbms_sql.close_cursor(source_cursor);

828: new_hire_table(l_counter3).no_cons_ffemale_emps := 0;
829: new_hire_table(l_counter3).no_cons_jfemale_emps := 0;
830: new_hire_table(l_counter3).no_cons_ofemale_emps := 0;
831: END IF;
832: dbms_sql.close_cursor(source_cursor);
833: END LOOP;--for each job category
834:
835: END populate_nh_emp_data;
836:

Line 1645: source_cursor := dbms_sql.open_cursor;

1641: -- added l_eeo4a_ethnic for bug 14034790
1642: l_query_text := 'select count(1) l_ft_emp_count ' || g_from_where_clause || l_eeo4a_ethnic
1643: || g_ft_effective_dates || ' AND ass.employment_category in ('||g_fp_regulars||')';
1644:
1645: source_cursor := dbms_sql.open_cursor;
1646: dbms_sql.parse(source_cursor,l_query_text,1);
1647: dbms_sql.define_column(source_cursor,1,l_ft_emp_count);
1648:
1649: rows_processed := dbms_sql.EXECUTE(source_cursor);

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

1642: l_query_text := 'select count(1) l_ft_emp_count ' || g_from_where_clause || l_eeo4a_ethnic
1643: || g_ft_effective_dates || ' AND ass.employment_category in ('||g_fp_regulars||')';
1644:
1645: source_cursor := dbms_sql.open_cursor;
1646: dbms_sql.parse(source_cursor,l_query_text,1);
1647: dbms_sql.define_column(source_cursor,1,l_ft_emp_count);
1648:
1649: rows_processed := dbms_sql.EXECUTE(source_cursor);
1650:

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

1643: || g_ft_effective_dates || ' AND ass.employment_category in ('||g_fp_regulars||')';
1644:
1645: source_cursor := dbms_sql.open_cursor;
1646: dbms_sql.parse(source_cursor,l_query_text,1);
1647: dbms_sql.define_column(source_cursor,1,l_ft_emp_count);
1648:
1649: rows_processed := dbms_sql.EXECUTE(source_cursor);
1650:
1651: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN

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

1645: source_cursor := dbms_sql.open_cursor;
1646: dbms_sql.parse(source_cursor,l_query_text,1);
1647: dbms_sql.define_column(source_cursor,1,l_ft_emp_count);
1648:
1649: rows_processed := dbms_sql.EXECUTE(source_cursor);
1650:
1651: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1652: dbms_sql.column_value(source_cursor,1,l_ft_emp_count); --FR employee count
1653: END IF;

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

1647: dbms_sql.define_column(source_cursor,1,l_ft_emp_count);
1648:
1649: rows_processed := dbms_sql.EXECUTE(source_cursor);
1650:
1651: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1652: dbms_sql.column_value(source_cursor,1,l_ft_emp_count); --FR employee count
1653: END IF;
1654:
1655: dbms_sql.close_cursor(source_cursor);

Line 1652: dbms_sql.column_value(source_cursor,1,l_ft_emp_count); --FR employee count

1648:
1649: rows_processed := dbms_sql.EXECUTE(source_cursor);
1650:
1651: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1652: dbms_sql.column_value(source_cursor,1,l_ft_emp_count); --FR employee count
1653: END IF;
1654:
1655: dbms_sql.close_cursor(source_cursor);
1656:

Line 1655: dbms_sql.close_cursor(source_cursor);

1651: IF dbms_sql.fetch_rows(source_cursor) > 0 THEN
1652: dbms_sql.column_value(source_cursor,1,l_ft_emp_count); --FR employee count
1653: END IF;
1654:
1655: dbms_sql.close_cursor(source_cursor);
1656:
1657: --count of no of employees in each FUNCTION category
1658: -- added l_eeo4a_ethnic for bug 14034790
1659: l_query_text := 'Select job.job_information7 l_function_code,

Line 1662: source_cursor := dbms_sql.open_cursor;

1658: -- added l_eeo4a_ethnic for bug 14034790
1659: l_query_text := 'Select job.job_information7 l_function_code,
1660: count(1) l_function_count ' || g_from_where_clause || l_eeo4a_ethnic || g_ft_effective_dates || ' group by job.job_information7 ';
1661:
1662: source_cursor := dbms_sql.open_cursor;
1663: dbms_sql.parse(source_cursor,l_query_text,2);
1664: dbms_sql.define_column_char(source_cursor,1,l_function_code,30);
1665: dbms_sql.define_column(source_cursor,2,l_function_count);
1666: rows_processed := dbms_sql.EXECUTE(source_cursor);

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

1659: l_query_text := 'Select job.job_information7 l_function_code,
1660: count(1) l_function_count ' || g_from_where_clause || l_eeo4a_ethnic || g_ft_effective_dates || ' group by job.job_information7 ';
1661:
1662: source_cursor := dbms_sql.open_cursor;
1663: dbms_sql.parse(source_cursor,l_query_text,2);
1664: dbms_sql.define_column_char(source_cursor,1,l_function_code,30);
1665: dbms_sql.define_column(source_cursor,2,l_function_count);
1666: rows_processed := dbms_sql.EXECUTE(source_cursor);
1667:

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

1660: count(1) l_function_count ' || g_from_where_clause || l_eeo4a_ethnic || g_ft_effective_dates || ' group by job.job_information7 ';
1661:
1662: source_cursor := dbms_sql.open_cursor;
1663: dbms_sql.parse(source_cursor,l_query_text,2);
1664: dbms_sql.define_column_char(source_cursor,1,l_function_code,30);
1665: dbms_sql.define_column(source_cursor,2,l_function_count);
1666: rows_processed := dbms_sql.EXECUTE(source_cursor);
1667:
1668: LOOP

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

1661:
1662: source_cursor := dbms_sql.open_cursor;
1663: dbms_sql.parse(source_cursor,l_query_text,2);
1664: dbms_sql.define_column_char(source_cursor,1,l_function_code,30);
1665: dbms_sql.define_column(source_cursor,2,l_function_count);
1666: rows_processed := dbms_sql.EXECUTE(source_cursor);
1667:
1668: LOOP
1669: IF dbms_sql.fetch_rows(source_cursor) > 0

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

1662: source_cursor := dbms_sql.open_cursor;
1663: dbms_sql.parse(source_cursor,l_query_text,2);
1664: dbms_sql.define_column_char(source_cursor,1,l_function_code,30);
1665: dbms_sql.define_column(source_cursor,2,l_function_count);
1666: rows_processed := dbms_sql.EXECUTE(source_cursor);
1667:
1668: LOOP
1669: IF dbms_sql.fetch_rows(source_cursor) > 0
1670: THEN

Line 1669: IF dbms_sql.fetch_rows(source_cursor) > 0

1665: dbms_sql.define_column(source_cursor,2,l_function_count);
1666: rows_processed := dbms_sql.EXECUTE(source_cursor);
1667:
1668: LOOP
1669: IF dbms_sql.fetch_rows(source_cursor) > 0
1670: THEN
1671:
1672: dbms_sql.column_value_char(source_cursor,1,l_function_code);
1673: dbms_sql.column_value(source_cursor,2,l_function_count);

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

1668: LOOP
1669: IF dbms_sql.fetch_rows(source_cursor) > 0
1670: THEN
1671:
1672: dbms_sql.column_value_char(source_cursor,1,l_function_code);
1673: dbms_sql.column_value(source_cursor,2,l_function_count);
1674: l_function_code := RTRIM(l_function_code);
1675:
1676: -- Fetch the function description

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

1669: IF dbms_sql.fetch_rows(source_cursor) > 0
1670: THEN
1671:
1672: dbms_sql.column_value_char(source_cursor,1,l_function_code);
1673: dbms_sql.column_value(source_cursor,2,l_function_count);
1674: l_function_code := RTRIM(l_function_code);
1675:
1676: -- Fetch the function description
1677: IF l_function_code IS NOT NULL

Line 1719: dbms_sql.close_cursor(source_cursor);

1715: EXIT;
1716: END IF; --END of if the fetch_rows>0
1717: END LOOP;--end of loop for fetching the function code and description
1718:
1719: dbms_sql.close_cursor(source_cursor);
1720:
1721: IF l_fo_funct_counter = 0 AND l_so_funct_counter = 0
1722: THEN
1723: l_fo_funct_counter := l_fo_funct_counter + 1;