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

APPS.PER_EEO_MAG_REPORT dependencies on HR_UTILITY

Line 391: RAISE hr_utility.hr_error;

387: ||'nav=Organization/Description/Parent Entity/Others ');
388: fnd_file.put_line
389: (which => fnd_file.log,
390: buff => '==================================');
391: RAISE hr_utility.hr_error;
392: END IF;
393: END; --Local1
394:
395: IF UPPER(SUBSTR(l_org_rec.title_cert_off_22,1,3)) = UPPER('THE') THEN

Line 444: hr_utility.set_location('Entering..' || l_proc,10);

440: l_consol_unit_address_6 VARCHAR2(3000);
441:
442: BEGIN
443:
444: hr_utility.set_location('Entering..' || l_proc,10);
445: hr_utility.trace('l_consol_rec.unit_number_3 : ' || l_consol_rec.unit_number_3);
446: hr_utility.trace('l_consol_rec.unit_name_4 : ' || l_consol_rec.unit_name_4);
447: hr_utility.trace('l_consol_rec.unit_address_5: ' || l_consol_rec.unit_address_req_5);
448:

Line 445: hr_utility.trace('l_consol_rec.unit_number_3 : ' || l_consol_rec.unit_number_3);

441:
442: BEGIN
443:
444: hr_utility.set_location('Entering..' || l_proc,10);
445: hr_utility.trace('l_consol_rec.unit_number_3 : ' || l_consol_rec.unit_number_3);
446: hr_utility.trace('l_consol_rec.unit_name_4 : ' || l_consol_rec.unit_name_4);
447: hr_utility.trace('l_consol_rec.unit_address_5: ' || l_consol_rec.unit_address_req_5);
448:
449: IF l_org_rec.form_type = 'M' THEN

Line 446: hr_utility.trace('l_consol_rec.unit_name_4 : ' || l_consol_rec.unit_name_4);

442: BEGIN
443:
444: hr_utility.set_location('Entering..' || l_proc,10);
445: hr_utility.trace('l_consol_rec.unit_number_3 : ' || l_consol_rec.unit_number_3);
446: hr_utility.trace('l_consol_rec.unit_name_4 : ' || l_consol_rec.unit_name_4);
447: hr_utility.trace('l_consol_rec.unit_address_5: ' || l_consol_rec.unit_address_req_5);
448:
449: IF l_org_rec.form_type = 'M' THEN
450:

Line 447: hr_utility.trace('l_consol_rec.unit_address_5: ' || l_consol_rec.unit_address_req_5);

443:
444: hr_utility.set_location('Entering..' || l_proc,10);
445: hr_utility.trace('l_consol_rec.unit_number_3 : ' || l_consol_rec.unit_number_3);
446: hr_utility.trace('l_consol_rec.unit_name_4 : ' || l_consol_rec.unit_name_4);
447: hr_utility.trace('l_consol_rec.unit_address_5: ' || l_consol_rec.unit_address_req_5);
448:
449: IF l_org_rec.form_type = 'M' THEN
450:
451: IF l_consol_rec.unit_name_4 IS NULL THEN

Line 653: hr_utility.trace('l_consol_unit_name_4 :'||l_consol_unit_name_4);

649: l_consol_unit_address_6 := substr(
650: translate(l_consol_rec.unit_address_6,'`;"|\-+=_#$%^&*@!~:<>?/()[]{},',' '),1,25);
651:
652:
653: hr_utility.trace('l_consol_unit_name_4 :'||l_consol_unit_name_4);
654: hr_utility.trace('l_consol_unit_address_5 : '||l_consol_unit_address_5);
655: hr_utility.trace('l_consol_unit_address_6 : '||l_consol_unit_address_6);
656:
657: l_string :=

Line 654: hr_utility.trace('l_consol_unit_address_5 : '||l_consol_unit_address_5);

650: translate(l_consol_rec.unit_address_6,'`;"|\-+=_#$%^&*@!~:<>?/()[]{},',' '),1,25);
651:
652:
653: hr_utility.trace('l_consol_unit_name_4 :'||l_consol_unit_name_4);
654: hr_utility.trace('l_consol_unit_address_5 : '||l_consol_unit_address_5);
655: hr_utility.trace('l_consol_unit_address_6 : '||l_consol_unit_address_6);
656:
657: l_string :=
658: -- 1

Line 655: hr_utility.trace('l_consol_unit_address_6 : '||l_consol_unit_address_6);

651:
652:
653: hr_utility.trace('l_consol_unit_name_4 :'||l_consol_unit_name_4);
654: hr_utility.trace('l_consol_unit_address_5 : '||l_consol_unit_address_5);
655: hr_utility.trace('l_consol_unit_address_6 : '||l_consol_unit_address_6);
656:
657: l_string :=
658: -- 1
659: nvl(lpad(l_org_rec.company_number_1,7,0),(lpad(' ',7,' ')))

Line 913: hr_utility.set_location('Leaving..' || l_proc,100);

909: (which => fnd_file.output,
910: buff => l_string);
911:
912: END IF; -- l_org_rec.form_type = 'M'
913: hr_utility.set_location('Leaving..' || l_proc,100);
914: END write_consolidated_record;
915:
916:
917:

Line 928: hr_utility.set_location('Entering..' || l_proc,10);

924: l_estab_unit_address_6 VARCHAR2(3000);
925:
926: BEGIN
927:
928: hr_utility.set_location('Entering..' || l_proc,10);
929: hr_utility.trace('l_estab_rec.unit_number_3 : '||l_estab_rec.unit_number_3);
930: hr_utility.trace('l_estab_rec.unit_name_4 : '||l_estab_rec.unit_name_4);
931: hr_utility.trace('l_estab_rec.unit_address_5: '||l_estab_rec.unit_address_req_5);
932:

Line 929: hr_utility.trace('l_estab_rec.unit_number_3 : '||l_estab_rec.unit_number_3);

925:
926: BEGIN
927:
928: hr_utility.set_location('Entering..' || l_proc,10);
929: hr_utility.trace('l_estab_rec.unit_number_3 : '||l_estab_rec.unit_number_3);
930: hr_utility.trace('l_estab_rec.unit_name_4 : '||l_estab_rec.unit_name_4);
931: hr_utility.trace('l_estab_rec.unit_address_5: '||l_estab_rec.unit_address_req_5);
932:
933: /* fnd_file.put_line

Line 930: hr_utility.trace('l_estab_rec.unit_name_4 : '||l_estab_rec.unit_name_4);

926: BEGIN
927:
928: hr_utility.set_location('Entering..' || l_proc,10);
929: hr_utility.trace('l_estab_rec.unit_number_3 : '||l_estab_rec.unit_number_3);
930: hr_utility.trace('l_estab_rec.unit_name_4 : '||l_estab_rec.unit_name_4);
931: hr_utility.trace('l_estab_rec.unit_address_5: '||l_estab_rec.unit_address_req_5);
932:
933: /* fnd_file.put_line
934: (which => fnd_file.log,

Line 931: hr_utility.trace('l_estab_rec.unit_address_5: '||l_estab_rec.unit_address_req_5);

927:
928: hr_utility.set_location('Entering..' || l_proc,10);
929: hr_utility.trace('l_estab_rec.unit_number_3 : '||l_estab_rec.unit_number_3);
930: hr_utility.trace('l_estab_rec.unit_name_4 : '||l_estab_rec.unit_name_4);
931: hr_utility.trace('l_estab_rec.unit_address_5: '||l_estab_rec.unit_address_req_5);
932:
933: /* fnd_file.put_line
934: (which => fnd_file.log,
935: buff => ' ');

Line 949: hr_utility.trace('l_org_rec.form_type : ' || l_org_rec.form_type);

945: */
946: --
947: -- Set Status
948: --
949: hr_utility.trace('l_org_rec.form_type : ' || l_org_rec.form_type);
950: IF l_org_rec.form_type = 'S' THEN
951:
952: IF l_estab_rec.reported_last_year_11 = '2' THEN
953: hr_utility.set_location(l_proc,15);

Line 953: hr_utility.set_location(l_proc,15);

949: hr_utility.trace('l_org_rec.form_type : ' || l_org_rec.form_type);
950: IF l_org_rec.form_type = 'S' THEN
951:
952: IF l_estab_rec.reported_last_year_11 = '2' THEN
953: hr_utility.set_location(l_proc,15);
954: l_org_rec.l_status_code_2 := '9';
955: ELSE
956: hr_utility.set_location(l_proc,16);
957: l_org_rec.l_status_code_2 := '1';

Line 956: hr_utility.set_location(l_proc,16);

952: IF l_estab_rec.reported_last_year_11 = '2' THEN
953: hr_utility.set_location(l_proc,15);
954: l_org_rec.l_status_code_2 := '9';
955: ELSE
956: hr_utility.set_location(l_proc,16);
957: l_org_rec.l_status_code_2 := '1';
958: END IF;
959:
960: ELSE --l_org_rec.form_type = 'S'

Line 967: hr_utility.set_location(l_proc,30);

963: IF l_estab_rec.reported_last_year_11 = '2' AND l_estab_rec.max_count = 'Y' THEN
964:
965: IF l_estab_rec.hq = 'Y' THEN
966: l_org_rec.l_status_code_2 := '3';
967: hr_utility.set_location(l_proc,30);
968: -- BUG4494412
969: l_consol_rec.unit_number_3 := l_estab_rec.unit_number_3;
970: l_consol_rec.unit_name_4 := l_estab_rec.unit_name_4;
971: l_consol_rec.unit_address_req_5 := l_estab_rec.unit_address_req_5;

Line 986: hr_utility.set_location(l_proc,20);

982: l_consol_rec.apprentices_emp_19 := l_estab_rec.apprentices_emp_19;
983: l_consol_rec.sic_20 := l_estab_rec.sic_20;
984: l_consol_rec.naics_21 := l_estab_rec.naics_21;
985: ELSE
986: hr_utility.set_location(l_proc,20);
987: l_org_rec.l_status_code_2 := '9';
988: END IF;
989:
990: ELSIF l_estab_rec.hq = 'Y'

Line 993: hr_utility.set_location(l_proc,40);

989:
990: ELSIF l_estab_rec.hq = 'Y'
991: AND l_estab_rec.reported_last_year_11 = '1' THEN
992:
993: hr_utility.set_location(l_proc,40);
994: l_org_rec.l_status_code_2 := '3';
995: -- BUG4494412
996: l_consol_rec.unit_number_3 := l_estab_rec.unit_number_3;
997: l_consol_rec.unit_name_4 := l_estab_rec.unit_name_4;

Line 1019: hr_utility.set_location(l_proc,50);

1015: AND l_estab_rec.max_count = 'Y'
1016: AND l_estab_rec.reported_last_year_11 = '1'
1017: THEN
1018:
1019: hr_utility.set_location(l_proc,50);
1020: l_org_rec.l_status_code_2 := '4';
1021: --
1022: -- not HQ AND less than 50 emps over at location
1023: ELSIF l_estab_rec.hq = 'N' AND l_estab_rec.max_count = 'N'

Line 1026: hr_utility.set_location(l_proc,60);

1022: -- not HQ AND less than 50 emps over at location
1023: ELSIF l_estab_rec.hq = 'N' AND l_estab_rec.max_count = 'N'
1024: THEN
1025:
1026: hr_utility.set_location(l_proc,60);
1027: l_org_rec.l_status_code_2 := '8';
1028: --
1029: -- not HQ AND under 50 emps at location
1030: /*

Line 1038: hr_utility.trace('l_org_rec.l_status_code_2 : ' || l_org_rec.l_status_code_2);

1034: */
1035: -- END IF;
1036:
1037: END IF; --l_estab_rec.reported_last_year_11 = '2'
1038: hr_utility.trace('l_org_rec.l_status_code_2 : ' || l_org_rec.l_status_code_2);
1039: hr_utility.trace('l_estab_rec.unit_number_3 : ' || l_estab_rec.unit_number_3);
1040:
1041: IF l_estab_rec.hq = 'Y' THEN
1042: l_org_rec.l_status_code_2 := '3';

Line 1039: hr_utility.trace('l_estab_rec.unit_number_3 : ' || l_estab_rec.unit_number_3);

1035: -- END IF;
1036:
1037: END IF; --l_estab_rec.reported_last_year_11 = '2'
1038: hr_utility.trace('l_org_rec.l_status_code_2 : ' || l_org_rec.l_status_code_2);
1039: hr_utility.trace('l_estab_rec.unit_number_3 : ' || l_estab_rec.unit_number_3);
1040:
1041: IF l_estab_rec.hq = 'Y' THEN
1042: l_org_rec.l_status_code_2 := '3';
1043: END IF;

Line 1114: hr_utility.set_location(l_proc,70);

1110: -- Set totals
1111: --
1112: -- grand total for column a (Hispanic or latino male)
1113: --
1114: hr_utility.set_location(l_proc,70);
1115: l_estab_rec.a_10_grand_total := nvl(l_estab_rec.a_1_hl_male,0)+
1116: nvl(l_estab_rec.a_2_hl_male,0)+
1117: nvl(l_estab_rec.a_3_hl_male,0)+
1118: nvl(l_estab_rec.a_4_hl_male,0)+

Line 1126: hr_utility.trace('l_estab_rec.a_10_grand_total : '||l_estab_rec.a_10_grand_total);

1122: nvl(l_estab_rec.a_8_hl_male,0)+
1123: nvl(l_estab_rec.a_9_hl_male,0)+
1124: nvl(l_estab_rec.a_10_hl_male,0);
1125: --
1126: hr_utility.trace('l_estab_rec.a_10_grand_total : '||l_estab_rec.a_10_grand_total);
1127: l_consol_rec.a_10_grand_total := (l_consol_rec.a_10_grand_total +
1128: l_estab_rec.a_10_grand_total);
1129: hr_utility.trace('l_consol_rec.a_10_grand_total : '||l_consol_rec.a_10_grand_total);
1130: /*

Line 1129: hr_utility.trace('l_consol_rec.a_10_grand_total : '||l_consol_rec.a_10_grand_total);

1125: --
1126: hr_utility.trace('l_estab_rec.a_10_grand_total : '||l_estab_rec.a_10_grand_total);
1127: l_consol_rec.a_10_grand_total := (l_consol_rec.a_10_grand_total +
1128: l_estab_rec.a_10_grand_total);
1129: hr_utility.trace('l_consol_rec.a_10_grand_total : '||l_consol_rec.a_10_grand_total);
1130: /*
1131: g_message_text := 'grand total for estab rep column a '
1132: ||'(total males AND females) ';
1133: fnd_file.put_line

Line 1424: hr_utility.trace('l_estab_unit_name_4 :'||l_estab_unit_name_4);

1420: translate(l_estab_rec.unit_address_6,'`;"|\-+=_#$%^&*@!~:<>?/()[]{},',' '),1,25);
1421:
1422:
1423:
1424: hr_utility.trace('l_estab_unit_name_4 :'||l_estab_unit_name_4);
1425: hr_utility.trace('l_estab_unit_address_5 : '||l_estab_unit_address_5);
1426: hr_utility.trace('l_estab_unit_address_6 : '||l_estab_unit_address_6);
1427:
1428: l_string :=

Line 1425: hr_utility.trace('l_estab_unit_address_5 : '||l_estab_unit_address_5);

1421:
1422:
1423:
1424: hr_utility.trace('l_estab_unit_name_4 :'||l_estab_unit_name_4);
1425: hr_utility.trace('l_estab_unit_address_5 : '||l_estab_unit_address_5);
1426: hr_utility.trace('l_estab_unit_address_6 : '||l_estab_unit_address_6);
1427:
1428: l_string :=
1429: -- 1

Line 1426: hr_utility.trace('l_estab_unit_address_6 : '||l_estab_unit_address_6);

1422:
1423:
1424: hr_utility.trace('l_estab_unit_name_4 :'||l_estab_unit_name_4);
1425: hr_utility.trace('l_estab_unit_address_5 : '||l_estab_unit_address_5);
1426: hr_utility.trace('l_estab_unit_address_6 : '||l_estab_unit_address_6);
1427:
1428: l_string :=
1429: -- 1
1430: nvl(lpad(l_org_rec.company_number_1,7,0),(lpad(' ',7,' ')))

Line 1874: hr_utility.set_location('Leaving..' || l_proc,100);

1870: --
1871: fnd_file.put_line
1872: (which => fnd_file.output,
1873: buff => l_string);
1874: hr_utility.set_location('Leaving..' || l_proc,100);
1875:
1876: END write_establishment_record;
1877:
1878:

Line 2026: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'3',1)) c_hlfemale,

2022:
2023: CURSOR c_female_details IS
2024: SELECT
2025: /* Added for fix of fix of #12616269 */
2026: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'3',1)) c_hlfemale,
2027: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'1',1)) c_wfemale,
2028: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bfemale,
2029: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hfemale,
2030: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_afemale,

Line 2027: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'1',1)) c_wfemale,

2023: CURSOR c_female_details IS
2024: SELECT
2025: /* Added for fix of fix of #12616269 */
2026: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'3',1)) c_hlfemale,
2027: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'1',1)) c_wfemale,
2028: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bfemale,
2029: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hfemale,
2030: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_afemale,
2031: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'6',1)) c_ifemale,

Line 2028: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bfemale,

2024: SELECT
2025: /* Added for fix of fix of #12616269 */
2026: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'3',1)) c_hlfemale,
2027: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'1',1)) c_wfemale,
2028: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bfemale,
2029: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hfemale,
2030: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_afemale,
2031: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'6',1)) c_ifemale,
2032: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'13',1)) c_tmracesfemale,

Line 2029: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hfemale,

2025: /* Added for fix of fix of #12616269 */
2026: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'3',1)) c_hlfemale,
2027: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'1',1)) c_wfemale,
2028: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bfemale,
2029: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hfemale,
2030: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_afemale,
2031: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'6',1)) c_ifemale,
2032: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'13',1)) c_tmracesfemale,
2033: /* Added for fix of fix of #12616269 */

Line 2030: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_afemale,

2026: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'3',1)) c_hlfemale,
2027: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'1',1)) c_wfemale,
2028: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bfemale,
2029: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hfemale,
2030: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_afemale,
2031: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'6',1)) c_ifemale,
2032: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'13',1)) c_tmracesfemale,
2033: /* Added for fix of fix of #12616269 */
2034: /* Commented for fix of #12616269

Line 2031: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'6',1)) c_ifemale,

2027: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'1',1)) c_wfemale,
2028: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bfemale,
2029: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hfemale,
2030: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_afemale,
2031: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'6',1)) c_ifemale,
2032: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'13',1)) c_tmracesfemale,
2033: /* Added for fix of fix of #12616269 */
2034: /* Commented for fix of #12616269
2035: COUNT(DECODE(peo.per_information1,'3',1)) c_hlfemale,

Line 2032: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'13',1)) c_tmracesfemale,

2028: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bfemale,
2029: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hfemale,
2030: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_afemale,
2031: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'6',1)) c_ifemale,
2032: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'13',1)) c_tmracesfemale,
2033: /* Added for fix of fix of #12616269 */
2034: /* Commented for fix of #12616269
2035: COUNT(DECODE(peo.per_information1,'3',1)) c_hlfemale,
2036: COUNT(DECODE(peo.per_information1,'1',1)) c_wfemale,

Line 2131: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'3',1)) c_hlmale,

2127:
2128: CURSOR c_male_details IS
2129: SELECT
2130: /* Added for fix of fix of #12616269 */
2131: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'3',1)) c_hlmale,
2132: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'1',1)) c_wmale,
2133: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bmale,
2134: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hmale,
2135: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_amale,

Line 2132: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'1',1)) c_wmale,

2128: CURSOR c_male_details IS
2129: SELECT
2130: /* Added for fix of fix of #12616269 */
2131: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'3',1)) c_hlmale,
2132: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'1',1)) c_wmale,
2133: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bmale,
2134: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hmale,
2135: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_amale,
2136: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'6',1)) c_imale,

Line 2133: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bmale,

2129: SELECT
2130: /* Added for fix of fix of #12616269 */
2131: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'3',1)) c_hlmale,
2132: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'1',1)) c_wmale,
2133: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bmale,
2134: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hmale,
2135: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_amale,
2136: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'6',1)) c_imale,
2137: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'13',1)) c_tmracesmale,

Line 2134: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hmale,

2130: /* Added for fix of fix of #12616269 */
2131: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'3',1)) c_hlmale,
2132: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'1',1)) c_wmale,
2133: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bmale,
2134: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hmale,
2135: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_amale,
2136: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'6',1)) c_imale,
2137: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'13',1)) c_tmracesmale,
2138: /* Added for fix of fix of #12616269 */

Line 2135: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_amale,

2131: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'3',1)) c_hlmale,
2132: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'1',1)) c_wmale,
2133: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bmale,
2134: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hmale,
2135: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_amale,
2136: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'6',1)) c_imale,
2137: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'13',1)) c_tmracesmale,
2138: /* Added for fix of fix of #12616269 */
2139: /* Commented for fix of #12616269

Line 2136: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'6',1)) c_imale,

2132: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'1',1)) c_wmale,
2133: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bmale,
2134: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hmale,
2135: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_amale,
2136: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'6',1)) c_imale,
2137: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'13',1)) c_tmracesmale,
2138: /* Added for fix of fix of #12616269 */
2139: /* Commented for fix of #12616269
2140: COUNT(DECODE(peo.per_information1,'3',1)) c_hlmale,

Line 2137: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'13',1)) c_tmracesmale,

2133: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'2',1)) c_bmale,
2134: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'5',1)) c_hmale,
2135: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'4',1)) c_amale,
2136: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'6',1)) c_imale,
2137: COUNT(DECODE(per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id),'13',1)) c_tmracesmale,
2138: /* Added for fix of fix of #12616269 */
2139: /* Commented for fix of #12616269
2140: COUNT(DECODE(peo.per_information1,'3',1)) c_hlmale,
2141: COUNT(DECODE(peo.per_information1,'1',1)) c_wmale,

Line 2243: -- Modified to add function call per_us_hr_utility_pkg.derive_alien_ethnic_origin instead of peo.per_information1

2239: per_jobs_vl job,
2240: hr_lookups hrl,
2241: per_gen_hierarchy_nodes pgn_est
2242: WHERE peo.person_id = ass.person_id
2243: -- Modified to add function call per_us_hr_utility_pkg.derive_alien_ethnic_origin instead of peo.per_information1
2244: -- AND peo.per_information1 IN ('1','2','3','4','5','6','13') --BUG4410003
2245: AND per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id) IN ('1','2','3','4','5','6','13')
2246: AND peo.per_information_category = 'US'
2247: AND job.job_information_category = 'US'

Line 2245: AND per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id) IN ('1','2','3','4','5','6','13')

2241: per_gen_hierarchy_nodes pgn_est
2242: WHERE peo.person_id = ass.person_id
2243: -- Modified to add function call per_us_hr_utility_pkg.derive_alien_ethnic_origin instead of peo.per_information1
2244: -- AND peo.per_information1 IN ('1','2','3','4','5','6','13') --BUG4410003
2245: AND per_us_hr_utility_pkg.derive_alien_ethnic_origin(peo.person_id) IN ('1','2','3','4','5','6','13')
2246: AND peo.per_information_category = 'US'
2247: AND job.job_information_category = 'US'
2248: AND p_start_date <= nvl(job.date_to,p_start_date)
2249: AND p_end_date >= job.date_from

Line 2834: RAISE hr_utility.hr_error;

2830: buff => ' ');
2831: fnd_file.put_line
2832: (which => fnd_file.log,
2833: buff => '======================================================');
2834: RAISE hr_utility.hr_error;
2835: ELSIF
2836: (l_c_estab_details.city_7 IS NULL OR
2837: l_c_estab_details.state_8 IS NULL OR
2838: l_c_estab_details.zip_code_9 IS NULL OR

Line 2861: RAISE hr_utility.hr_error;

2857: ||l_c_estab_details.unit_name_4);
2858: fnd_file.put_line
2859: (which => fnd_file.log,
2860: buff => '==================================');
2861: RAISE hr_utility.hr_error;
2862: END IF;
2863: END; -- unit name AND address are required.
2864:
2865:

Line 2883: RAISE hr_utility.hr_error;

2879: (which => fnd_file.log,
2880: buff => 'Please change the "Reporting Name " IN location/extra '
2881: ||'info/eeo1 specific information for unit/establishment ');
2882:
2883: RAISE hr_utility.hr_error;
2884: END IF;
2885:
2886: -- do not let unit name start with 'The'
2887:

Line 2905: RAISE hr_utility.hr_error;

2901: THEN
2902: fnd_file.put_line
2903: (which => fnd_file.log,
2904: buff => 'The unit address of '||l_c_estab_details.unit_name_4||' must be a minimum of four (4) positions.');
2905: RAISE hr_utility.hr_error;
2906: END IF;
2907:
2908: --unit_address_req_5 must begin with a number or 'PO BOX'
2909:

Line 2917: RAISE hr_utility.hr_error;

2913: THEN
2914: fnd_file.put_line
2915: (which => fnd_file.log,
2916: buff => 'The street address of '||l_c_estab_details.unit_name_4||' must begin with a number or "PO BOX"');
2917: RAISE hr_utility.hr_error;
2918: END IF;
2919:
2920: --
2921: BEGIN--Local1

Line 2992: RAISE hr_utility.hr_error;

2988: buff => ' ');
2989: fnd_file.put_line
2990: (which => fnd_file.log,
2991: buff => '*==================================================*');
2992: RAISE hr_utility.hr_error;
2993: END IF; --(l_c_estab_details.naics_21 IS NULL AND l_org_rec.naics_21 IS NULL)
2994:
2995: IF (l_org_rec.title_cert_off_22 IS NULL OR
2996: l_org_rec.name_cert_off_23 IS NULL OR

Line 3038: RAISE hr_utility.hr_error;

3034: buff => ' ');
3035: fnd_file.put_line
3036: (which => fnd_file.log,
3037: buff => '==================================');
3038: RAISE hr_utility.hr_error;
3039: END IF;--l_org_rec.title_cert_off_22 IS NULL
3040:
3041: END IF;--l_org_rec.c2_affiliated_14 = 1
3042:

Line 3077: hr_utility.set_location(l_proc,10);

3073: ELSE
3074: l_estab_rec.max_count := 'N';
3075: END IF;
3076:
3077: hr_utility.set_location(l_proc,10);
3078: hr_utility.trace('p_hierarchy_version_id : ' || p_hierarchy_version_id);
3079:
3080: /* OPEN c_mf_details;
3081: LOOP

Line 3078: hr_utility.trace('p_hierarchy_version_id : ' || p_hierarchy_version_id);

3074: l_estab_rec.max_count := 'N';
3075: END IF;
3076:
3077: hr_utility.set_location(l_proc,10);
3078: hr_utility.trace('p_hierarchy_version_id : ' || p_hierarchy_version_id);
3079:
3080: /* OPEN c_mf_details;
3081: LOOP
3082: FETCH c_mf_details INTO l_c_mf_details;

Line 3085: hr_utility.trace('l_hierarchy_node_id : ' || l_hierarchy_node_id);

3081: LOOP
3082: FETCH c_mf_details INTO l_c_mf_details;
3083: EXIT WHEN c_mf_details%NOTFOUND;
3084:
3085: hr_utility.trace('l_hierarchy_node_id : ' || l_hierarchy_node_id);
3086:
3087: IF l_c_mf_details.lookup_code = '1' THEN
3088: --
3089: -- count First/Mid Level Officials and Managers

Line 3167: hr_utility.set_location(l_proc,20);

3163: END LOOP;
3164:
3165: CLOSE c_mf_details; */
3166:
3167: hr_utility.set_location(l_proc,20);
3168: OPEN c_female_details;
3169: LOOP
3170: FETCH c_female_details INTO l_c_female_details;
3171: EXIT WHEN c_female_details%NOTFOUND;

Line 3196: hr_utility.trace('l_estab_rec.b_1_hl_female : ' || l_estab_rec.b_1_hl_female);

3192: l_estab_rec.l_1_aspac_fem +
3193: l_estab_rec.m_1_ameri_fem +
3194: l_estab_rec.n_1_tmraces_female;
3195:
3196: hr_utility.trace('l_estab_rec.b_1_hl_female : ' || l_estab_rec.b_1_hl_female);
3197: hr_utility.trace('l_estab_rec.i_1_white_fem : ' || l_estab_rec.i_1_white_fem);
3198: hr_utility.trace('l_estab_rec.j_1_black_fem : ' || l_estab_rec.j_1_black_fem);
3199: hr_utility.trace('l_estab_rec.k_1_latin_fem : ' || l_estab_rec.k_1_latin_fem);
3200: hr_utility.trace('l_estab_rec.l_1_aspac_fem : ' || l_estab_rec.l_1_aspac_fem);

Line 3197: hr_utility.trace('l_estab_rec.i_1_white_fem : ' || l_estab_rec.i_1_white_fem);

3193: l_estab_rec.m_1_ameri_fem +
3194: l_estab_rec.n_1_tmraces_female;
3195:
3196: hr_utility.trace('l_estab_rec.b_1_hl_female : ' || l_estab_rec.b_1_hl_female);
3197: hr_utility.trace('l_estab_rec.i_1_white_fem : ' || l_estab_rec.i_1_white_fem);
3198: hr_utility.trace('l_estab_rec.j_1_black_fem : ' || l_estab_rec.j_1_black_fem);
3199: hr_utility.trace('l_estab_rec.k_1_latin_fem : ' || l_estab_rec.k_1_latin_fem);
3200: hr_utility.trace('l_estab_rec.l_1_aspac_fem : ' || l_estab_rec.l_1_aspac_fem);
3201: hr_utility.trace('l_estab_rec.m_1_ameri_fem : ' || l_estab_rec.m_1_ameri_fem);

Line 3198: hr_utility.trace('l_estab_rec.j_1_black_fem : ' || l_estab_rec.j_1_black_fem);

3194: l_estab_rec.n_1_tmraces_female;
3195:
3196: hr_utility.trace('l_estab_rec.b_1_hl_female : ' || l_estab_rec.b_1_hl_female);
3197: hr_utility.trace('l_estab_rec.i_1_white_fem : ' || l_estab_rec.i_1_white_fem);
3198: hr_utility.trace('l_estab_rec.j_1_black_fem : ' || l_estab_rec.j_1_black_fem);
3199: hr_utility.trace('l_estab_rec.k_1_latin_fem : ' || l_estab_rec.k_1_latin_fem);
3200: hr_utility.trace('l_estab_rec.l_1_aspac_fem : ' || l_estab_rec.l_1_aspac_fem);
3201: hr_utility.trace('l_estab_rec.m_1_ameri_fem : ' || l_estab_rec.m_1_ameri_fem);
3202: hr_utility.trace('l_estab_rec.n_1_tmraces_female : ' || l_estab_rec.n_1_tmraces_female);

Line 3199: hr_utility.trace('l_estab_rec.k_1_latin_fem : ' || l_estab_rec.k_1_latin_fem);

3195:
3196: hr_utility.trace('l_estab_rec.b_1_hl_female : ' || l_estab_rec.b_1_hl_female);
3197: hr_utility.trace('l_estab_rec.i_1_white_fem : ' || l_estab_rec.i_1_white_fem);
3198: hr_utility.trace('l_estab_rec.j_1_black_fem : ' || l_estab_rec.j_1_black_fem);
3199: hr_utility.trace('l_estab_rec.k_1_latin_fem : ' || l_estab_rec.k_1_latin_fem);
3200: hr_utility.trace('l_estab_rec.l_1_aspac_fem : ' || l_estab_rec.l_1_aspac_fem);
3201: hr_utility.trace('l_estab_rec.m_1_ameri_fem : ' || l_estab_rec.m_1_ameri_fem);
3202: hr_utility.trace('l_estab_rec.n_1_tmraces_female : ' || l_estab_rec.n_1_tmraces_female);
3203:

Line 3200: hr_utility.trace('l_estab_rec.l_1_aspac_fem : ' || l_estab_rec.l_1_aspac_fem);

3196: hr_utility.trace('l_estab_rec.b_1_hl_female : ' || l_estab_rec.b_1_hl_female);
3197: hr_utility.trace('l_estab_rec.i_1_white_fem : ' || l_estab_rec.i_1_white_fem);
3198: hr_utility.trace('l_estab_rec.j_1_black_fem : ' || l_estab_rec.j_1_black_fem);
3199: hr_utility.trace('l_estab_rec.k_1_latin_fem : ' || l_estab_rec.k_1_latin_fem);
3200: hr_utility.trace('l_estab_rec.l_1_aspac_fem : ' || l_estab_rec.l_1_aspac_fem);
3201: hr_utility.trace('l_estab_rec.m_1_ameri_fem : ' || l_estab_rec.m_1_ameri_fem);
3202: hr_utility.trace('l_estab_rec.n_1_tmraces_female : ' || l_estab_rec.n_1_tmraces_female);
3203:
3204: -- IF Hawaii

Line 3201: hr_utility.trace('l_estab_rec.m_1_ameri_fem : ' || l_estab_rec.m_1_ameri_fem);

3197: hr_utility.trace('l_estab_rec.i_1_white_fem : ' || l_estab_rec.i_1_white_fem);
3198: hr_utility.trace('l_estab_rec.j_1_black_fem : ' || l_estab_rec.j_1_black_fem);
3199: hr_utility.trace('l_estab_rec.k_1_latin_fem : ' || l_estab_rec.k_1_latin_fem);
3200: hr_utility.trace('l_estab_rec.l_1_aspac_fem : ' || l_estab_rec.l_1_aspac_fem);
3201: hr_utility.trace('l_estab_rec.m_1_ameri_fem : ' || l_estab_rec.m_1_ameri_fem);
3202: hr_utility.trace('l_estab_rec.n_1_tmraces_female : ' || l_estab_rec.n_1_tmraces_female);
3203:
3204: -- IF Hawaii
3205: /* IF l_estab_rec.state_8 = 'HI' THEN

Line 3202: hr_utility.trace('l_estab_rec.n_1_tmraces_female : ' || l_estab_rec.n_1_tmraces_female);

3198: hr_utility.trace('l_estab_rec.j_1_black_fem : ' || l_estab_rec.j_1_black_fem);
3199: hr_utility.trace('l_estab_rec.k_1_latin_fem : ' || l_estab_rec.k_1_latin_fem);
3200: hr_utility.trace('l_estab_rec.l_1_aspac_fem : ' || l_estab_rec.l_1_aspac_fem);
3201: hr_utility.trace('l_estab_rec.m_1_ameri_fem : ' || l_estab_rec.m_1_ameri_fem);
3202: hr_utility.trace('l_estab_rec.n_1_tmraces_female : ' || l_estab_rec.n_1_tmraces_female);
3203:
3204: -- IF Hawaii
3205: /* IF l_estab_rec.state_8 = 'HI' THEN
3206: l_estab_rec.i_1_white_fem := (l_estab_rec.b_1_hl_female+

Line 3257: hr_utility.trace('l_estab_rec.b_2_hl_female : ' || l_estab_rec.b_2_hl_female);

3253: l_estab_rec.l_2_aspac_fem +
3254: l_estab_rec.m_2_ameri_fem +
3255: l_estab_rec.n_2_tmraces_female;
3256:
3257: hr_utility.trace('l_estab_rec.b_2_hl_female : ' || l_estab_rec.b_2_hl_female);
3258: hr_utility.trace('l_estab_rec.i_2_white_fem : ' || l_estab_rec.i_2_white_fem);
3259: hr_utility.trace('l_estab_rec.j_2_black_fem : ' || l_estab_rec.j_2_black_fem);
3260: hr_utility.trace('l_estab_rec.k_2_latin_fem : ' || l_estab_rec.k_2_latin_fem);
3261: hr_utility.trace('l_estab_rec.l_2_aspac_fem : ' || l_estab_rec.l_2_aspac_fem);

Line 3258: hr_utility.trace('l_estab_rec.i_2_white_fem : ' || l_estab_rec.i_2_white_fem);

3254: l_estab_rec.m_2_ameri_fem +
3255: l_estab_rec.n_2_tmraces_female;
3256:
3257: hr_utility.trace('l_estab_rec.b_2_hl_female : ' || l_estab_rec.b_2_hl_female);
3258: hr_utility.trace('l_estab_rec.i_2_white_fem : ' || l_estab_rec.i_2_white_fem);
3259: hr_utility.trace('l_estab_rec.j_2_black_fem : ' || l_estab_rec.j_2_black_fem);
3260: hr_utility.trace('l_estab_rec.k_2_latin_fem : ' || l_estab_rec.k_2_latin_fem);
3261: hr_utility.trace('l_estab_rec.l_2_aspac_fem : ' || l_estab_rec.l_2_aspac_fem);
3262: hr_utility.trace('l_estab_rec.m_2_ameri_fem : ' || l_estab_rec.m_2_ameri_fem);

Line 3259: hr_utility.trace('l_estab_rec.j_2_black_fem : ' || l_estab_rec.j_2_black_fem);

3255: l_estab_rec.n_2_tmraces_female;
3256:
3257: hr_utility.trace('l_estab_rec.b_2_hl_female : ' || l_estab_rec.b_2_hl_female);
3258: hr_utility.trace('l_estab_rec.i_2_white_fem : ' || l_estab_rec.i_2_white_fem);
3259: hr_utility.trace('l_estab_rec.j_2_black_fem : ' || l_estab_rec.j_2_black_fem);
3260: hr_utility.trace('l_estab_rec.k_2_latin_fem : ' || l_estab_rec.k_2_latin_fem);
3261: hr_utility.trace('l_estab_rec.l_2_aspac_fem : ' || l_estab_rec.l_2_aspac_fem);
3262: hr_utility.trace('l_estab_rec.m_2_ameri_fem : ' || l_estab_rec.m_2_ameri_fem);
3263: hr_utility.trace('l_estab_rec.n_2_tmraces_female : ' || l_estab_rec.n_2_tmraces_female);

Line 3260: hr_utility.trace('l_estab_rec.k_2_latin_fem : ' || l_estab_rec.k_2_latin_fem);

3256:
3257: hr_utility.trace('l_estab_rec.b_2_hl_female : ' || l_estab_rec.b_2_hl_female);
3258: hr_utility.trace('l_estab_rec.i_2_white_fem : ' || l_estab_rec.i_2_white_fem);
3259: hr_utility.trace('l_estab_rec.j_2_black_fem : ' || l_estab_rec.j_2_black_fem);
3260: hr_utility.trace('l_estab_rec.k_2_latin_fem : ' || l_estab_rec.k_2_latin_fem);
3261: hr_utility.trace('l_estab_rec.l_2_aspac_fem : ' || l_estab_rec.l_2_aspac_fem);
3262: hr_utility.trace('l_estab_rec.m_2_ameri_fem : ' || l_estab_rec.m_2_ameri_fem);
3263: hr_utility.trace('l_estab_rec.n_2_tmraces_female : ' || l_estab_rec.n_2_tmraces_female);
3264:

Line 3261: hr_utility.trace('l_estab_rec.l_2_aspac_fem : ' || l_estab_rec.l_2_aspac_fem);

3257: hr_utility.trace('l_estab_rec.b_2_hl_female : ' || l_estab_rec.b_2_hl_female);
3258: hr_utility.trace('l_estab_rec.i_2_white_fem : ' || l_estab_rec.i_2_white_fem);
3259: hr_utility.trace('l_estab_rec.j_2_black_fem : ' || l_estab_rec.j_2_black_fem);
3260: hr_utility.trace('l_estab_rec.k_2_latin_fem : ' || l_estab_rec.k_2_latin_fem);
3261: hr_utility.trace('l_estab_rec.l_2_aspac_fem : ' || l_estab_rec.l_2_aspac_fem);
3262: hr_utility.trace('l_estab_rec.m_2_ameri_fem : ' || l_estab_rec.m_2_ameri_fem);
3263: hr_utility.trace('l_estab_rec.n_2_tmraces_female : ' || l_estab_rec.n_2_tmraces_female);
3264:
3265: -- IF Hawaii

Line 3262: hr_utility.trace('l_estab_rec.m_2_ameri_fem : ' || l_estab_rec.m_2_ameri_fem);

3258: hr_utility.trace('l_estab_rec.i_2_white_fem : ' || l_estab_rec.i_2_white_fem);
3259: hr_utility.trace('l_estab_rec.j_2_black_fem : ' || l_estab_rec.j_2_black_fem);
3260: hr_utility.trace('l_estab_rec.k_2_latin_fem : ' || l_estab_rec.k_2_latin_fem);
3261: hr_utility.trace('l_estab_rec.l_2_aspac_fem : ' || l_estab_rec.l_2_aspac_fem);
3262: hr_utility.trace('l_estab_rec.m_2_ameri_fem : ' || l_estab_rec.m_2_ameri_fem);
3263: hr_utility.trace('l_estab_rec.n_2_tmraces_female : ' || l_estab_rec.n_2_tmraces_female);
3264:
3265: -- IF Hawaii
3266: /* IF l_estab_rec.state_8 = 'HI' THEN

Line 3263: hr_utility.trace('l_estab_rec.n_2_tmraces_female : ' || l_estab_rec.n_2_tmraces_female);

3259: hr_utility.trace('l_estab_rec.j_2_black_fem : ' || l_estab_rec.j_2_black_fem);
3260: hr_utility.trace('l_estab_rec.k_2_latin_fem : ' || l_estab_rec.k_2_latin_fem);
3261: hr_utility.trace('l_estab_rec.l_2_aspac_fem : ' || l_estab_rec.l_2_aspac_fem);
3262: hr_utility.trace('l_estab_rec.m_2_ameri_fem : ' || l_estab_rec.m_2_ameri_fem);
3263: hr_utility.trace('l_estab_rec.n_2_tmraces_female : ' || l_estab_rec.n_2_tmraces_female);
3264:
3265: -- IF Hawaii
3266: /* IF l_estab_rec.state_8 = 'HI' THEN
3267: l_estab_rec.i_2_white_fem := (l_estab_rec.b_2_hl_female +

Line 3318: hr_utility.trace('l_estab_rec.b_3_hl_female : ' || l_estab_rec.b_3_hl_female);

3314: l_estab_rec.l_3_aspac_fem +
3315: l_estab_rec.m_3_ameri_fem +
3316: l_estab_rec.n_3_tmraces_female;
3317:
3318: hr_utility.trace('l_estab_rec.b_3_hl_female : ' || l_estab_rec.b_3_hl_female);
3319: hr_utility.trace('l_estab_rec.i_3_white_fem : ' || l_estab_rec.i_3_white_fem);
3320: hr_utility.trace('l_estab_rec.j_3_black_fem : ' || l_estab_rec.j_3_black_fem);
3321: hr_utility.trace('l_estab_rec.k_3_latin_fem : ' || l_estab_rec.k_3_latin_fem);
3322: hr_utility.trace('l_estab_rec.l_3_aspac_fem : ' || l_estab_rec.l_3_aspac_fem);

Line 3319: hr_utility.trace('l_estab_rec.i_3_white_fem : ' || l_estab_rec.i_3_white_fem);

3315: l_estab_rec.m_3_ameri_fem +
3316: l_estab_rec.n_3_tmraces_female;
3317:
3318: hr_utility.trace('l_estab_rec.b_3_hl_female : ' || l_estab_rec.b_3_hl_female);
3319: hr_utility.trace('l_estab_rec.i_3_white_fem : ' || l_estab_rec.i_3_white_fem);
3320: hr_utility.trace('l_estab_rec.j_3_black_fem : ' || l_estab_rec.j_3_black_fem);
3321: hr_utility.trace('l_estab_rec.k_3_latin_fem : ' || l_estab_rec.k_3_latin_fem);
3322: hr_utility.trace('l_estab_rec.l_3_aspac_fem : ' || l_estab_rec.l_3_aspac_fem);
3323: hr_utility.trace('l_estab_rec.m_3_ameri_fem : ' || l_estab_rec.m_3_ameri_fem);

Line 3320: hr_utility.trace('l_estab_rec.j_3_black_fem : ' || l_estab_rec.j_3_black_fem);

3316: l_estab_rec.n_3_tmraces_female;
3317:
3318: hr_utility.trace('l_estab_rec.b_3_hl_female : ' || l_estab_rec.b_3_hl_female);
3319: hr_utility.trace('l_estab_rec.i_3_white_fem : ' || l_estab_rec.i_3_white_fem);
3320: hr_utility.trace('l_estab_rec.j_3_black_fem : ' || l_estab_rec.j_3_black_fem);
3321: hr_utility.trace('l_estab_rec.k_3_latin_fem : ' || l_estab_rec.k_3_latin_fem);
3322: hr_utility.trace('l_estab_rec.l_3_aspac_fem : ' || l_estab_rec.l_3_aspac_fem);
3323: hr_utility.trace('l_estab_rec.m_3_ameri_fem : ' || l_estab_rec.m_3_ameri_fem);
3324: hr_utility.trace('l_estab_rec.n_3_tmraces_female : ' || l_estab_rec.n_3_tmraces_female);

Line 3321: hr_utility.trace('l_estab_rec.k_3_latin_fem : ' || l_estab_rec.k_3_latin_fem);

3317:
3318: hr_utility.trace('l_estab_rec.b_3_hl_female : ' || l_estab_rec.b_3_hl_female);
3319: hr_utility.trace('l_estab_rec.i_3_white_fem : ' || l_estab_rec.i_3_white_fem);
3320: hr_utility.trace('l_estab_rec.j_3_black_fem : ' || l_estab_rec.j_3_black_fem);
3321: hr_utility.trace('l_estab_rec.k_3_latin_fem : ' || l_estab_rec.k_3_latin_fem);
3322: hr_utility.trace('l_estab_rec.l_3_aspac_fem : ' || l_estab_rec.l_3_aspac_fem);
3323: hr_utility.trace('l_estab_rec.m_3_ameri_fem : ' || l_estab_rec.m_3_ameri_fem);
3324: hr_utility.trace('l_estab_rec.n_3_tmraces_female : ' || l_estab_rec.n_3_tmraces_female);
3325:

Line 3322: hr_utility.trace('l_estab_rec.l_3_aspac_fem : ' || l_estab_rec.l_3_aspac_fem);

3318: hr_utility.trace('l_estab_rec.b_3_hl_female : ' || l_estab_rec.b_3_hl_female);
3319: hr_utility.trace('l_estab_rec.i_3_white_fem : ' || l_estab_rec.i_3_white_fem);
3320: hr_utility.trace('l_estab_rec.j_3_black_fem : ' || l_estab_rec.j_3_black_fem);
3321: hr_utility.trace('l_estab_rec.k_3_latin_fem : ' || l_estab_rec.k_3_latin_fem);
3322: hr_utility.trace('l_estab_rec.l_3_aspac_fem : ' || l_estab_rec.l_3_aspac_fem);
3323: hr_utility.trace('l_estab_rec.m_3_ameri_fem : ' || l_estab_rec.m_3_ameri_fem);
3324: hr_utility.trace('l_estab_rec.n_3_tmraces_female : ' || l_estab_rec.n_3_tmraces_female);
3325:
3326: -- IF Hawaii

Line 3323: hr_utility.trace('l_estab_rec.m_3_ameri_fem : ' || l_estab_rec.m_3_ameri_fem);

3319: hr_utility.trace('l_estab_rec.i_3_white_fem : ' || l_estab_rec.i_3_white_fem);
3320: hr_utility.trace('l_estab_rec.j_3_black_fem : ' || l_estab_rec.j_3_black_fem);
3321: hr_utility.trace('l_estab_rec.k_3_latin_fem : ' || l_estab_rec.k_3_latin_fem);
3322: hr_utility.trace('l_estab_rec.l_3_aspac_fem : ' || l_estab_rec.l_3_aspac_fem);
3323: hr_utility.trace('l_estab_rec.m_3_ameri_fem : ' || l_estab_rec.m_3_ameri_fem);
3324: hr_utility.trace('l_estab_rec.n_3_tmraces_female : ' || l_estab_rec.n_3_tmraces_female);
3325:
3326: -- IF Hawaii
3327: /* IF l_estab_rec.state_8 = 'HI' THEN

Line 3324: hr_utility.trace('l_estab_rec.n_3_tmraces_female : ' || l_estab_rec.n_3_tmraces_female);

3320: hr_utility.trace('l_estab_rec.j_3_black_fem : ' || l_estab_rec.j_3_black_fem);
3321: hr_utility.trace('l_estab_rec.k_3_latin_fem : ' || l_estab_rec.k_3_latin_fem);
3322: hr_utility.trace('l_estab_rec.l_3_aspac_fem : ' || l_estab_rec.l_3_aspac_fem);
3323: hr_utility.trace('l_estab_rec.m_3_ameri_fem : ' || l_estab_rec.m_3_ameri_fem);
3324: hr_utility.trace('l_estab_rec.n_3_tmraces_female : ' || l_estab_rec.n_3_tmraces_female);
3325:
3326: -- IF Hawaii
3327: /* IF l_estab_rec.state_8 = 'HI' THEN
3328: l_estab_rec.i_3_white_fem := (l_estab_rec.b_3_hl_female +

Line 3379: hr_utility.trace('l_estab_rec.b_4_hl_female : ' || l_estab_rec.b_4_hl_female);

3375: l_estab_rec.l_4_aspac_fem +
3376: l_estab_rec.m_4_ameri_fem +
3377: l_estab_rec.n_4_tmraces_female;
3378:
3379: hr_utility.trace('l_estab_rec.b_4_hl_female : ' || l_estab_rec.b_4_hl_female);
3380: hr_utility.trace('l_estab_rec.i_4_white_fem : ' || l_estab_rec.i_4_white_fem);
3381: hr_utility.trace('l_estab_rec.j_4_black_fem : ' || l_estab_rec.j_4_black_fem);
3382: hr_utility.trace('l_estab_rec.k_4_latin_fem : ' || l_estab_rec.k_4_latin_fem);
3383: hr_utility.trace('l_estab_rec.l_4_aspac_fem : ' || l_estab_rec.l_4_aspac_fem);

Line 3380: hr_utility.trace('l_estab_rec.i_4_white_fem : ' || l_estab_rec.i_4_white_fem);

3376: l_estab_rec.m_4_ameri_fem +
3377: l_estab_rec.n_4_tmraces_female;
3378:
3379: hr_utility.trace('l_estab_rec.b_4_hl_female : ' || l_estab_rec.b_4_hl_female);
3380: hr_utility.trace('l_estab_rec.i_4_white_fem : ' || l_estab_rec.i_4_white_fem);
3381: hr_utility.trace('l_estab_rec.j_4_black_fem : ' || l_estab_rec.j_4_black_fem);
3382: hr_utility.trace('l_estab_rec.k_4_latin_fem : ' || l_estab_rec.k_4_latin_fem);
3383: hr_utility.trace('l_estab_rec.l_4_aspac_fem : ' || l_estab_rec.l_4_aspac_fem);
3384: hr_utility.trace('l_estab_rec.m_4_ameri_fem : ' || l_estab_rec.m_4_ameri_fem);

Line 3381: hr_utility.trace('l_estab_rec.j_4_black_fem : ' || l_estab_rec.j_4_black_fem);

3377: l_estab_rec.n_4_tmraces_female;
3378:
3379: hr_utility.trace('l_estab_rec.b_4_hl_female : ' || l_estab_rec.b_4_hl_female);
3380: hr_utility.trace('l_estab_rec.i_4_white_fem : ' || l_estab_rec.i_4_white_fem);
3381: hr_utility.trace('l_estab_rec.j_4_black_fem : ' || l_estab_rec.j_4_black_fem);
3382: hr_utility.trace('l_estab_rec.k_4_latin_fem : ' || l_estab_rec.k_4_latin_fem);
3383: hr_utility.trace('l_estab_rec.l_4_aspac_fem : ' || l_estab_rec.l_4_aspac_fem);
3384: hr_utility.trace('l_estab_rec.m_4_ameri_fem : ' || l_estab_rec.m_4_ameri_fem);
3385: hr_utility.trace('l_estab_rec.n_4_tmraces_female : ' || l_estab_rec.n_4_tmraces_female);

Line 3382: hr_utility.trace('l_estab_rec.k_4_latin_fem : ' || l_estab_rec.k_4_latin_fem);

3378:
3379: hr_utility.trace('l_estab_rec.b_4_hl_female : ' || l_estab_rec.b_4_hl_female);
3380: hr_utility.trace('l_estab_rec.i_4_white_fem : ' || l_estab_rec.i_4_white_fem);
3381: hr_utility.trace('l_estab_rec.j_4_black_fem : ' || l_estab_rec.j_4_black_fem);
3382: hr_utility.trace('l_estab_rec.k_4_latin_fem : ' || l_estab_rec.k_4_latin_fem);
3383: hr_utility.trace('l_estab_rec.l_4_aspac_fem : ' || l_estab_rec.l_4_aspac_fem);
3384: hr_utility.trace('l_estab_rec.m_4_ameri_fem : ' || l_estab_rec.m_4_ameri_fem);
3385: hr_utility.trace('l_estab_rec.n_4_tmraces_female : ' || l_estab_rec.n_4_tmraces_female);
3386:

Line 3383: hr_utility.trace('l_estab_rec.l_4_aspac_fem : ' || l_estab_rec.l_4_aspac_fem);

3379: hr_utility.trace('l_estab_rec.b_4_hl_female : ' || l_estab_rec.b_4_hl_female);
3380: hr_utility.trace('l_estab_rec.i_4_white_fem : ' || l_estab_rec.i_4_white_fem);
3381: hr_utility.trace('l_estab_rec.j_4_black_fem : ' || l_estab_rec.j_4_black_fem);
3382: hr_utility.trace('l_estab_rec.k_4_latin_fem : ' || l_estab_rec.k_4_latin_fem);
3383: hr_utility.trace('l_estab_rec.l_4_aspac_fem : ' || l_estab_rec.l_4_aspac_fem);
3384: hr_utility.trace('l_estab_rec.m_4_ameri_fem : ' || l_estab_rec.m_4_ameri_fem);
3385: hr_utility.trace('l_estab_rec.n_4_tmraces_female : ' || l_estab_rec.n_4_tmraces_female);
3386:
3387: -- IF Hawaii

Line 3384: hr_utility.trace('l_estab_rec.m_4_ameri_fem : ' || l_estab_rec.m_4_ameri_fem);

3380: hr_utility.trace('l_estab_rec.i_4_white_fem : ' || l_estab_rec.i_4_white_fem);
3381: hr_utility.trace('l_estab_rec.j_4_black_fem : ' || l_estab_rec.j_4_black_fem);
3382: hr_utility.trace('l_estab_rec.k_4_latin_fem : ' || l_estab_rec.k_4_latin_fem);
3383: hr_utility.trace('l_estab_rec.l_4_aspac_fem : ' || l_estab_rec.l_4_aspac_fem);
3384: hr_utility.trace('l_estab_rec.m_4_ameri_fem : ' || l_estab_rec.m_4_ameri_fem);
3385: hr_utility.trace('l_estab_rec.n_4_tmraces_female : ' || l_estab_rec.n_4_tmraces_female);
3386:
3387: -- IF Hawaii
3388: /* IF l_estab_rec.state_8 = 'HI' THEN

Line 3385: hr_utility.trace('l_estab_rec.n_4_tmraces_female : ' || l_estab_rec.n_4_tmraces_female);

3381: hr_utility.trace('l_estab_rec.j_4_black_fem : ' || l_estab_rec.j_4_black_fem);
3382: hr_utility.trace('l_estab_rec.k_4_latin_fem : ' || l_estab_rec.k_4_latin_fem);
3383: hr_utility.trace('l_estab_rec.l_4_aspac_fem : ' || l_estab_rec.l_4_aspac_fem);
3384: hr_utility.trace('l_estab_rec.m_4_ameri_fem : ' || l_estab_rec.m_4_ameri_fem);
3385: hr_utility.trace('l_estab_rec.n_4_tmraces_female : ' || l_estab_rec.n_4_tmraces_female);
3386:
3387: -- IF Hawaii
3388: /* IF l_estab_rec.state_8 = 'HI' THEN
3389: l_estab_rec.i_4_white_fem := (l_estab_rec.b_4_hl_female +

Line 3439: hr_utility.trace('l_estab_rec.b_5_hl_female : ' || l_estab_rec.b_5_hl_female);

3435: l_estab_rec.l_5_aspac_fem +
3436: l_estab_rec.m_5_ameri_fem +
3437: l_estab_rec.n_5_tmraces_female;
3438:
3439: hr_utility.trace('l_estab_rec.b_5_hl_female : ' || l_estab_rec.b_5_hl_female);
3440: hr_utility.trace('l_estab_rec.i_5_white_fem : ' || l_estab_rec.i_5_white_fem);
3441: hr_utility.trace('l_estab_rec.j_5_black_fem : ' || l_estab_rec.j_5_black_fem);
3442: hr_utility.trace('l_estab_rec.k_5_latin_fem : ' || l_estab_rec.k_5_latin_fem);
3443: hr_utility.trace('l_estab_rec.l_5_aspac_fem : ' || l_estab_rec.l_5_aspac_fem);

Line 3440: hr_utility.trace('l_estab_rec.i_5_white_fem : ' || l_estab_rec.i_5_white_fem);

3436: l_estab_rec.m_5_ameri_fem +
3437: l_estab_rec.n_5_tmraces_female;
3438:
3439: hr_utility.trace('l_estab_rec.b_5_hl_female : ' || l_estab_rec.b_5_hl_female);
3440: hr_utility.trace('l_estab_rec.i_5_white_fem : ' || l_estab_rec.i_5_white_fem);
3441: hr_utility.trace('l_estab_rec.j_5_black_fem : ' || l_estab_rec.j_5_black_fem);
3442: hr_utility.trace('l_estab_rec.k_5_latin_fem : ' || l_estab_rec.k_5_latin_fem);
3443: hr_utility.trace('l_estab_rec.l_5_aspac_fem : ' || l_estab_rec.l_5_aspac_fem);
3444: hr_utility.trace('l_estab_rec.m_5_ameri_fem : ' || l_estab_rec.m_5_ameri_fem);

Line 3441: hr_utility.trace('l_estab_rec.j_5_black_fem : ' || l_estab_rec.j_5_black_fem);

3437: l_estab_rec.n_5_tmraces_female;
3438:
3439: hr_utility.trace('l_estab_rec.b_5_hl_female : ' || l_estab_rec.b_5_hl_female);
3440: hr_utility.trace('l_estab_rec.i_5_white_fem : ' || l_estab_rec.i_5_white_fem);
3441: hr_utility.trace('l_estab_rec.j_5_black_fem : ' || l_estab_rec.j_5_black_fem);
3442: hr_utility.trace('l_estab_rec.k_5_latin_fem : ' || l_estab_rec.k_5_latin_fem);
3443: hr_utility.trace('l_estab_rec.l_5_aspac_fem : ' || l_estab_rec.l_5_aspac_fem);
3444: hr_utility.trace('l_estab_rec.m_5_ameri_fem : ' || l_estab_rec.m_5_ameri_fem);
3445: hr_utility.trace('l_estab_rec.n_5_tmraces_female : ' || l_estab_rec.n_5_tmraces_female);

Line 3442: hr_utility.trace('l_estab_rec.k_5_latin_fem : ' || l_estab_rec.k_5_latin_fem);

3438:
3439: hr_utility.trace('l_estab_rec.b_5_hl_female : ' || l_estab_rec.b_5_hl_female);
3440: hr_utility.trace('l_estab_rec.i_5_white_fem : ' || l_estab_rec.i_5_white_fem);
3441: hr_utility.trace('l_estab_rec.j_5_black_fem : ' || l_estab_rec.j_5_black_fem);
3442: hr_utility.trace('l_estab_rec.k_5_latin_fem : ' || l_estab_rec.k_5_latin_fem);
3443: hr_utility.trace('l_estab_rec.l_5_aspac_fem : ' || l_estab_rec.l_5_aspac_fem);
3444: hr_utility.trace('l_estab_rec.m_5_ameri_fem : ' || l_estab_rec.m_5_ameri_fem);
3445: hr_utility.trace('l_estab_rec.n_5_tmraces_female : ' || l_estab_rec.n_5_tmraces_female);
3446:

Line 3443: hr_utility.trace('l_estab_rec.l_5_aspac_fem : ' || l_estab_rec.l_5_aspac_fem);

3439: hr_utility.trace('l_estab_rec.b_5_hl_female : ' || l_estab_rec.b_5_hl_female);
3440: hr_utility.trace('l_estab_rec.i_5_white_fem : ' || l_estab_rec.i_5_white_fem);
3441: hr_utility.trace('l_estab_rec.j_5_black_fem : ' || l_estab_rec.j_5_black_fem);
3442: hr_utility.trace('l_estab_rec.k_5_latin_fem : ' || l_estab_rec.k_5_latin_fem);
3443: hr_utility.trace('l_estab_rec.l_5_aspac_fem : ' || l_estab_rec.l_5_aspac_fem);
3444: hr_utility.trace('l_estab_rec.m_5_ameri_fem : ' || l_estab_rec.m_5_ameri_fem);
3445: hr_utility.trace('l_estab_rec.n_5_tmraces_female : ' || l_estab_rec.n_5_tmraces_female);
3446:
3447: -- IF Hawaii

Line 3444: hr_utility.trace('l_estab_rec.m_5_ameri_fem : ' || l_estab_rec.m_5_ameri_fem);

3440: hr_utility.trace('l_estab_rec.i_5_white_fem : ' || l_estab_rec.i_5_white_fem);
3441: hr_utility.trace('l_estab_rec.j_5_black_fem : ' || l_estab_rec.j_5_black_fem);
3442: hr_utility.trace('l_estab_rec.k_5_latin_fem : ' || l_estab_rec.k_5_latin_fem);
3443: hr_utility.trace('l_estab_rec.l_5_aspac_fem : ' || l_estab_rec.l_5_aspac_fem);
3444: hr_utility.trace('l_estab_rec.m_5_ameri_fem : ' || l_estab_rec.m_5_ameri_fem);
3445: hr_utility.trace('l_estab_rec.n_5_tmraces_female : ' || l_estab_rec.n_5_tmraces_female);
3446:
3447: -- IF Hawaii
3448: /* IF l_estab_rec.state_8 = 'HI' THEN

Line 3445: hr_utility.trace('l_estab_rec.n_5_tmraces_female : ' || l_estab_rec.n_5_tmraces_female);

3441: hr_utility.trace('l_estab_rec.j_5_black_fem : ' || l_estab_rec.j_5_black_fem);
3442: hr_utility.trace('l_estab_rec.k_5_latin_fem : ' || l_estab_rec.k_5_latin_fem);
3443: hr_utility.trace('l_estab_rec.l_5_aspac_fem : ' || l_estab_rec.l_5_aspac_fem);
3444: hr_utility.trace('l_estab_rec.m_5_ameri_fem : ' || l_estab_rec.m_5_ameri_fem);
3445: hr_utility.trace('l_estab_rec.n_5_tmraces_female : ' || l_estab_rec.n_5_tmraces_female);
3446:
3447: -- IF Hawaii
3448: /* IF l_estab_rec.state_8 = 'HI' THEN
3449: l_estab_rec.i_5_white_fem := (l_estab_rec.b_5_hl_female +

Line 3500: hr_utility.trace('l_estab_rec.b_6_hl_female : ' || l_estab_rec.b_6_hl_female);

3496: l_estab_rec.l_6_aspac_fem +
3497: l_estab_rec.m_6_ameri_fem +
3498: l_estab_rec.n_6_tmraces_female;
3499:
3500: hr_utility.trace('l_estab_rec.b_6_hl_female : ' || l_estab_rec.b_6_hl_female);
3501: hr_utility.trace('l_estab_rec.i_6_white_fem : ' || l_estab_rec.i_6_white_fem);
3502: hr_utility.trace('l_estab_rec.j_6_black_fem : ' || l_estab_rec.j_6_black_fem);
3503: hr_utility.trace('l_estab_rec.k_6_latin_fem : ' || l_estab_rec.k_6_latin_fem);
3504: hr_utility.trace('l_estab_rec.l_6_aspac_fem : ' || l_estab_rec.l_6_aspac_fem);

Line 3501: hr_utility.trace('l_estab_rec.i_6_white_fem : ' || l_estab_rec.i_6_white_fem);

3497: l_estab_rec.m_6_ameri_fem +
3498: l_estab_rec.n_6_tmraces_female;
3499:
3500: hr_utility.trace('l_estab_rec.b_6_hl_female : ' || l_estab_rec.b_6_hl_female);
3501: hr_utility.trace('l_estab_rec.i_6_white_fem : ' || l_estab_rec.i_6_white_fem);
3502: hr_utility.trace('l_estab_rec.j_6_black_fem : ' || l_estab_rec.j_6_black_fem);
3503: hr_utility.trace('l_estab_rec.k_6_latin_fem : ' || l_estab_rec.k_6_latin_fem);
3504: hr_utility.trace('l_estab_rec.l_6_aspac_fem : ' || l_estab_rec.l_6_aspac_fem);
3505: hr_utility.trace('l_estab_rec.m_6_ameri_fem : ' || l_estab_rec.m_6_ameri_fem);

Line 3502: hr_utility.trace('l_estab_rec.j_6_black_fem : ' || l_estab_rec.j_6_black_fem);

3498: l_estab_rec.n_6_tmraces_female;
3499:
3500: hr_utility.trace('l_estab_rec.b_6_hl_female : ' || l_estab_rec.b_6_hl_female);
3501: hr_utility.trace('l_estab_rec.i_6_white_fem : ' || l_estab_rec.i_6_white_fem);
3502: hr_utility.trace('l_estab_rec.j_6_black_fem : ' || l_estab_rec.j_6_black_fem);
3503: hr_utility.trace('l_estab_rec.k_6_latin_fem : ' || l_estab_rec.k_6_latin_fem);
3504: hr_utility.trace('l_estab_rec.l_6_aspac_fem : ' || l_estab_rec.l_6_aspac_fem);
3505: hr_utility.trace('l_estab_rec.m_6_ameri_fem : ' || l_estab_rec.m_6_ameri_fem);
3506: hr_utility.trace('l_estab_rec.n_6_tmraces_female : ' || l_estab_rec.n_6_tmraces_female);

Line 3503: hr_utility.trace('l_estab_rec.k_6_latin_fem : ' || l_estab_rec.k_6_latin_fem);

3499:
3500: hr_utility.trace('l_estab_rec.b_6_hl_female : ' || l_estab_rec.b_6_hl_female);
3501: hr_utility.trace('l_estab_rec.i_6_white_fem : ' || l_estab_rec.i_6_white_fem);
3502: hr_utility.trace('l_estab_rec.j_6_black_fem : ' || l_estab_rec.j_6_black_fem);
3503: hr_utility.trace('l_estab_rec.k_6_latin_fem : ' || l_estab_rec.k_6_latin_fem);
3504: hr_utility.trace('l_estab_rec.l_6_aspac_fem : ' || l_estab_rec.l_6_aspac_fem);
3505: hr_utility.trace('l_estab_rec.m_6_ameri_fem : ' || l_estab_rec.m_6_ameri_fem);
3506: hr_utility.trace('l_estab_rec.n_6_tmraces_female : ' || l_estab_rec.n_6_tmraces_female);
3507:

Line 3504: hr_utility.trace('l_estab_rec.l_6_aspac_fem : ' || l_estab_rec.l_6_aspac_fem);

3500: hr_utility.trace('l_estab_rec.b_6_hl_female : ' || l_estab_rec.b_6_hl_female);
3501: hr_utility.trace('l_estab_rec.i_6_white_fem : ' || l_estab_rec.i_6_white_fem);
3502: hr_utility.trace('l_estab_rec.j_6_black_fem : ' || l_estab_rec.j_6_black_fem);
3503: hr_utility.trace('l_estab_rec.k_6_latin_fem : ' || l_estab_rec.k_6_latin_fem);
3504: hr_utility.trace('l_estab_rec.l_6_aspac_fem : ' || l_estab_rec.l_6_aspac_fem);
3505: hr_utility.trace('l_estab_rec.m_6_ameri_fem : ' || l_estab_rec.m_6_ameri_fem);
3506: hr_utility.trace('l_estab_rec.n_6_tmraces_female : ' || l_estab_rec.n_6_tmraces_female);
3507:
3508: -- IF Hawaii

Line 3505: hr_utility.trace('l_estab_rec.m_6_ameri_fem : ' || l_estab_rec.m_6_ameri_fem);

3501: hr_utility.trace('l_estab_rec.i_6_white_fem : ' || l_estab_rec.i_6_white_fem);
3502: hr_utility.trace('l_estab_rec.j_6_black_fem : ' || l_estab_rec.j_6_black_fem);
3503: hr_utility.trace('l_estab_rec.k_6_latin_fem : ' || l_estab_rec.k_6_latin_fem);
3504: hr_utility.trace('l_estab_rec.l_6_aspac_fem : ' || l_estab_rec.l_6_aspac_fem);
3505: hr_utility.trace('l_estab_rec.m_6_ameri_fem : ' || l_estab_rec.m_6_ameri_fem);
3506: hr_utility.trace('l_estab_rec.n_6_tmraces_female : ' || l_estab_rec.n_6_tmraces_female);
3507:
3508: -- IF Hawaii
3509: /* IF l_estab_rec.state_8 = 'HI' THEN

Line 3506: hr_utility.trace('l_estab_rec.n_6_tmraces_female : ' || l_estab_rec.n_6_tmraces_female);

3502: hr_utility.trace('l_estab_rec.j_6_black_fem : ' || l_estab_rec.j_6_black_fem);
3503: hr_utility.trace('l_estab_rec.k_6_latin_fem : ' || l_estab_rec.k_6_latin_fem);
3504: hr_utility.trace('l_estab_rec.l_6_aspac_fem : ' || l_estab_rec.l_6_aspac_fem);
3505: hr_utility.trace('l_estab_rec.m_6_ameri_fem : ' || l_estab_rec.m_6_ameri_fem);
3506: hr_utility.trace('l_estab_rec.n_6_tmraces_female : ' || l_estab_rec.n_6_tmraces_female);
3507:
3508: -- IF Hawaii
3509: /* IF l_estab_rec.state_8 = 'HI' THEN
3510: l_estab_rec.i_6_white_fem := (l_estab_rec.b_6_hl_female +

Line 3561: hr_utility.trace('l_estab_rec.b_7_hl_female : ' || l_estab_rec.b_7_hl_female);

3557: l_estab_rec.l_7_aspac_fem +
3558: l_estab_rec.m_7_ameri_fem +
3559: l_estab_rec.n_7_tmraces_female;
3560:
3561: hr_utility.trace('l_estab_rec.b_7_hl_female : ' || l_estab_rec.b_7_hl_female);
3562: hr_utility.trace('l_estab_rec.i_7_white_fem : ' || l_estab_rec.i_7_white_fem);
3563: hr_utility.trace('l_estab_rec.j_7_black_fem : ' || l_estab_rec.j_7_black_fem);
3564: hr_utility.trace('l_estab_rec.k_7_latin_fem : ' || l_estab_rec.k_7_latin_fem);
3565: hr_utility.trace('l_estab_rec.l_7_aspac_fem : ' || l_estab_rec.l_7_aspac_fem);

Line 3562: hr_utility.trace('l_estab_rec.i_7_white_fem : ' || l_estab_rec.i_7_white_fem);

3558: l_estab_rec.m_7_ameri_fem +
3559: l_estab_rec.n_7_tmraces_female;
3560:
3561: hr_utility.trace('l_estab_rec.b_7_hl_female : ' || l_estab_rec.b_7_hl_female);
3562: hr_utility.trace('l_estab_rec.i_7_white_fem : ' || l_estab_rec.i_7_white_fem);
3563: hr_utility.trace('l_estab_rec.j_7_black_fem : ' || l_estab_rec.j_7_black_fem);
3564: hr_utility.trace('l_estab_rec.k_7_latin_fem : ' || l_estab_rec.k_7_latin_fem);
3565: hr_utility.trace('l_estab_rec.l_7_aspac_fem : ' || l_estab_rec.l_7_aspac_fem);
3566: hr_utility.trace('l_estab_rec.m_7_ameri_fem : ' || l_estab_rec.m_7_ameri_fem);

Line 3563: hr_utility.trace('l_estab_rec.j_7_black_fem : ' || l_estab_rec.j_7_black_fem);

3559: l_estab_rec.n_7_tmraces_female;
3560:
3561: hr_utility.trace('l_estab_rec.b_7_hl_female : ' || l_estab_rec.b_7_hl_female);
3562: hr_utility.trace('l_estab_rec.i_7_white_fem : ' || l_estab_rec.i_7_white_fem);
3563: hr_utility.trace('l_estab_rec.j_7_black_fem : ' || l_estab_rec.j_7_black_fem);
3564: hr_utility.trace('l_estab_rec.k_7_latin_fem : ' || l_estab_rec.k_7_latin_fem);
3565: hr_utility.trace('l_estab_rec.l_7_aspac_fem : ' || l_estab_rec.l_7_aspac_fem);
3566: hr_utility.trace('l_estab_rec.m_7_ameri_fem : ' || l_estab_rec.m_7_ameri_fem);
3567: hr_utility.trace('l_estab_rec.n_7_tmraces_female : ' || l_estab_rec.n_7_tmraces_female);

Line 3564: hr_utility.trace('l_estab_rec.k_7_latin_fem : ' || l_estab_rec.k_7_latin_fem);

3560:
3561: hr_utility.trace('l_estab_rec.b_7_hl_female : ' || l_estab_rec.b_7_hl_female);
3562: hr_utility.trace('l_estab_rec.i_7_white_fem : ' || l_estab_rec.i_7_white_fem);
3563: hr_utility.trace('l_estab_rec.j_7_black_fem : ' || l_estab_rec.j_7_black_fem);
3564: hr_utility.trace('l_estab_rec.k_7_latin_fem : ' || l_estab_rec.k_7_latin_fem);
3565: hr_utility.trace('l_estab_rec.l_7_aspac_fem : ' || l_estab_rec.l_7_aspac_fem);
3566: hr_utility.trace('l_estab_rec.m_7_ameri_fem : ' || l_estab_rec.m_7_ameri_fem);
3567: hr_utility.trace('l_estab_rec.n_7_tmraces_female : ' || l_estab_rec.n_7_tmraces_female);
3568:

Line 3565: hr_utility.trace('l_estab_rec.l_7_aspac_fem : ' || l_estab_rec.l_7_aspac_fem);

3561: hr_utility.trace('l_estab_rec.b_7_hl_female : ' || l_estab_rec.b_7_hl_female);
3562: hr_utility.trace('l_estab_rec.i_7_white_fem : ' || l_estab_rec.i_7_white_fem);
3563: hr_utility.trace('l_estab_rec.j_7_black_fem : ' || l_estab_rec.j_7_black_fem);
3564: hr_utility.trace('l_estab_rec.k_7_latin_fem : ' || l_estab_rec.k_7_latin_fem);
3565: hr_utility.trace('l_estab_rec.l_7_aspac_fem : ' || l_estab_rec.l_7_aspac_fem);
3566: hr_utility.trace('l_estab_rec.m_7_ameri_fem : ' || l_estab_rec.m_7_ameri_fem);
3567: hr_utility.trace('l_estab_rec.n_7_tmraces_female : ' || l_estab_rec.n_7_tmraces_female);
3568:
3569: -- IF Hawaii

Line 3566: hr_utility.trace('l_estab_rec.m_7_ameri_fem : ' || l_estab_rec.m_7_ameri_fem);

3562: hr_utility.trace('l_estab_rec.i_7_white_fem : ' || l_estab_rec.i_7_white_fem);
3563: hr_utility.trace('l_estab_rec.j_7_black_fem : ' || l_estab_rec.j_7_black_fem);
3564: hr_utility.trace('l_estab_rec.k_7_latin_fem : ' || l_estab_rec.k_7_latin_fem);
3565: hr_utility.trace('l_estab_rec.l_7_aspac_fem : ' || l_estab_rec.l_7_aspac_fem);
3566: hr_utility.trace('l_estab_rec.m_7_ameri_fem : ' || l_estab_rec.m_7_ameri_fem);
3567: hr_utility.trace('l_estab_rec.n_7_tmraces_female : ' || l_estab_rec.n_7_tmraces_female);
3568:
3569: -- IF Hawaii
3570: /* IF l_estab_rec.state_8 = 'HI' THEN

Line 3567: hr_utility.trace('l_estab_rec.n_7_tmraces_female : ' || l_estab_rec.n_7_tmraces_female);

3563: hr_utility.trace('l_estab_rec.j_7_black_fem : ' || l_estab_rec.j_7_black_fem);
3564: hr_utility.trace('l_estab_rec.k_7_latin_fem : ' || l_estab_rec.k_7_latin_fem);
3565: hr_utility.trace('l_estab_rec.l_7_aspac_fem : ' || l_estab_rec.l_7_aspac_fem);
3566: hr_utility.trace('l_estab_rec.m_7_ameri_fem : ' || l_estab_rec.m_7_ameri_fem);
3567: hr_utility.trace('l_estab_rec.n_7_tmraces_female : ' || l_estab_rec.n_7_tmraces_female);
3568:
3569: -- IF Hawaii
3570: /* IF l_estab_rec.state_8 = 'HI' THEN
3571: l_estab_rec.i_7_white_fem := ( l_estab_rec.b_7_hl_female +

Line 3622: hr_utility.trace('l_estab_rec.b_8_hl_female : ' || l_estab_rec.b_8_hl_female);

3618: l_estab_rec.l_8_aspac_fem +
3619: l_estab_rec.m_8_ameri_fem +
3620: l_estab_rec.n_8_tmraces_female;
3621:
3622: hr_utility.trace('l_estab_rec.b_8_hl_female : ' || l_estab_rec.b_8_hl_female);
3623: hr_utility.trace('l_estab_rec.i_8_white_fem : ' || l_estab_rec.i_8_white_fem);
3624: hr_utility.trace('l_estab_rec.j_8_black_fem : ' || l_estab_rec.j_8_black_fem);
3625: hr_utility.trace('l_estab_rec.k_8_latin_fem : ' || l_estab_rec.k_8_latin_fem);
3626: hr_utility.trace('l_estab_rec.l_8_aspac_fem : ' || l_estab_rec.l_8_aspac_fem);

Line 3623: hr_utility.trace('l_estab_rec.i_8_white_fem : ' || l_estab_rec.i_8_white_fem);

3619: l_estab_rec.m_8_ameri_fem +
3620: l_estab_rec.n_8_tmraces_female;
3621:
3622: hr_utility.trace('l_estab_rec.b_8_hl_female : ' || l_estab_rec.b_8_hl_female);
3623: hr_utility.trace('l_estab_rec.i_8_white_fem : ' || l_estab_rec.i_8_white_fem);
3624: hr_utility.trace('l_estab_rec.j_8_black_fem : ' || l_estab_rec.j_8_black_fem);
3625: hr_utility.trace('l_estab_rec.k_8_latin_fem : ' || l_estab_rec.k_8_latin_fem);
3626: hr_utility.trace('l_estab_rec.l_8_aspac_fem : ' || l_estab_rec.l_8_aspac_fem);
3627: hr_utility.trace('l_estab_rec.m_8_ameri_fem : ' || l_estab_rec.m_8_ameri_fem);

Line 3624: hr_utility.trace('l_estab_rec.j_8_black_fem : ' || l_estab_rec.j_8_black_fem);

3620: l_estab_rec.n_8_tmraces_female;
3621:
3622: hr_utility.trace('l_estab_rec.b_8_hl_female : ' || l_estab_rec.b_8_hl_female);
3623: hr_utility.trace('l_estab_rec.i_8_white_fem : ' || l_estab_rec.i_8_white_fem);
3624: hr_utility.trace('l_estab_rec.j_8_black_fem : ' || l_estab_rec.j_8_black_fem);
3625: hr_utility.trace('l_estab_rec.k_8_latin_fem : ' || l_estab_rec.k_8_latin_fem);
3626: hr_utility.trace('l_estab_rec.l_8_aspac_fem : ' || l_estab_rec.l_8_aspac_fem);
3627: hr_utility.trace('l_estab_rec.m_8_ameri_fem : ' || l_estab_rec.m_8_ameri_fem);
3628: hr_utility.trace('l_estab_rec.n_8_tmraces_female : ' || l_estab_rec.n_8_tmraces_female);

Line 3625: hr_utility.trace('l_estab_rec.k_8_latin_fem : ' || l_estab_rec.k_8_latin_fem);

3621:
3622: hr_utility.trace('l_estab_rec.b_8_hl_female : ' || l_estab_rec.b_8_hl_female);
3623: hr_utility.trace('l_estab_rec.i_8_white_fem : ' || l_estab_rec.i_8_white_fem);
3624: hr_utility.trace('l_estab_rec.j_8_black_fem : ' || l_estab_rec.j_8_black_fem);
3625: hr_utility.trace('l_estab_rec.k_8_latin_fem : ' || l_estab_rec.k_8_latin_fem);
3626: hr_utility.trace('l_estab_rec.l_8_aspac_fem : ' || l_estab_rec.l_8_aspac_fem);
3627: hr_utility.trace('l_estab_rec.m_8_ameri_fem : ' || l_estab_rec.m_8_ameri_fem);
3628: hr_utility.trace('l_estab_rec.n_8_tmraces_female : ' || l_estab_rec.n_8_tmraces_female);
3629:

Line 3626: hr_utility.trace('l_estab_rec.l_8_aspac_fem : ' || l_estab_rec.l_8_aspac_fem);

3622: hr_utility.trace('l_estab_rec.b_8_hl_female : ' || l_estab_rec.b_8_hl_female);
3623: hr_utility.trace('l_estab_rec.i_8_white_fem : ' || l_estab_rec.i_8_white_fem);
3624: hr_utility.trace('l_estab_rec.j_8_black_fem : ' || l_estab_rec.j_8_black_fem);
3625: hr_utility.trace('l_estab_rec.k_8_latin_fem : ' || l_estab_rec.k_8_latin_fem);
3626: hr_utility.trace('l_estab_rec.l_8_aspac_fem : ' || l_estab_rec.l_8_aspac_fem);
3627: hr_utility.trace('l_estab_rec.m_8_ameri_fem : ' || l_estab_rec.m_8_ameri_fem);
3628: hr_utility.trace('l_estab_rec.n_8_tmraces_female : ' || l_estab_rec.n_8_tmraces_female);
3629:
3630: -- IF Hawaii

Line 3627: hr_utility.trace('l_estab_rec.m_8_ameri_fem : ' || l_estab_rec.m_8_ameri_fem);

3623: hr_utility.trace('l_estab_rec.i_8_white_fem : ' || l_estab_rec.i_8_white_fem);
3624: hr_utility.trace('l_estab_rec.j_8_black_fem : ' || l_estab_rec.j_8_black_fem);
3625: hr_utility.trace('l_estab_rec.k_8_latin_fem : ' || l_estab_rec.k_8_latin_fem);
3626: hr_utility.trace('l_estab_rec.l_8_aspac_fem : ' || l_estab_rec.l_8_aspac_fem);
3627: hr_utility.trace('l_estab_rec.m_8_ameri_fem : ' || l_estab_rec.m_8_ameri_fem);
3628: hr_utility.trace('l_estab_rec.n_8_tmraces_female : ' || l_estab_rec.n_8_tmraces_female);
3629:
3630: -- IF Hawaii
3631: /* IF l_estab_rec.state_8 = 'HI' THEN

Line 3628: hr_utility.trace('l_estab_rec.n_8_tmraces_female : ' || l_estab_rec.n_8_tmraces_female);

3624: hr_utility.trace('l_estab_rec.j_8_black_fem : ' || l_estab_rec.j_8_black_fem);
3625: hr_utility.trace('l_estab_rec.k_8_latin_fem : ' || l_estab_rec.k_8_latin_fem);
3626: hr_utility.trace('l_estab_rec.l_8_aspac_fem : ' || l_estab_rec.l_8_aspac_fem);
3627: hr_utility.trace('l_estab_rec.m_8_ameri_fem : ' || l_estab_rec.m_8_ameri_fem);
3628: hr_utility.trace('l_estab_rec.n_8_tmraces_female : ' || l_estab_rec.n_8_tmraces_female);
3629:
3630: -- IF Hawaii
3631: /* IF l_estab_rec.state_8 = 'HI' THEN
3632: l_estab_rec.i_8_white_fem := (l_estab_rec.b_8_hl_female +

Line 3683: hr_utility.trace('l_estab_rec.b_9_hl_female : ' || l_estab_rec.b_9_hl_female);

3679: l_estab_rec.l_9_aspac_fem +
3680: l_estab_rec.m_9_ameri_fem +
3681: l_estab_rec.n_9_tmraces_female;
3682:
3683: hr_utility.trace('l_estab_rec.b_9_hl_female : ' || l_estab_rec.b_9_hl_female);
3684: hr_utility.trace('l_estab_rec.i_9_white_fem : ' || l_estab_rec.i_9_white_fem);
3685: hr_utility.trace('l_estab_rec.j_9_black_fem : ' || l_estab_rec.j_9_black_fem);
3686: hr_utility.trace('l_estab_rec.k_9_latin_fem : ' || l_estab_rec.k_9_latin_fem);
3687: hr_utility.trace('l_estab_rec.l_9_aspac_fem : ' || l_estab_rec.l_9_aspac_fem);

Line 3684: hr_utility.trace('l_estab_rec.i_9_white_fem : ' || l_estab_rec.i_9_white_fem);

3680: l_estab_rec.m_9_ameri_fem +
3681: l_estab_rec.n_9_tmraces_female;
3682:
3683: hr_utility.trace('l_estab_rec.b_9_hl_female : ' || l_estab_rec.b_9_hl_female);
3684: hr_utility.trace('l_estab_rec.i_9_white_fem : ' || l_estab_rec.i_9_white_fem);
3685: hr_utility.trace('l_estab_rec.j_9_black_fem : ' || l_estab_rec.j_9_black_fem);
3686: hr_utility.trace('l_estab_rec.k_9_latin_fem : ' || l_estab_rec.k_9_latin_fem);
3687: hr_utility.trace('l_estab_rec.l_9_aspac_fem : ' || l_estab_rec.l_9_aspac_fem);
3688: hr_utility.trace('l_estab_rec.m_9_ameri_fem : ' || l_estab_rec.m_9_ameri_fem);

Line 3685: hr_utility.trace('l_estab_rec.j_9_black_fem : ' || l_estab_rec.j_9_black_fem);

3681: l_estab_rec.n_9_tmraces_female;
3682:
3683: hr_utility.trace('l_estab_rec.b_9_hl_female : ' || l_estab_rec.b_9_hl_female);
3684: hr_utility.trace('l_estab_rec.i_9_white_fem : ' || l_estab_rec.i_9_white_fem);
3685: hr_utility.trace('l_estab_rec.j_9_black_fem : ' || l_estab_rec.j_9_black_fem);
3686: hr_utility.trace('l_estab_rec.k_9_latin_fem : ' || l_estab_rec.k_9_latin_fem);
3687: hr_utility.trace('l_estab_rec.l_9_aspac_fem : ' || l_estab_rec.l_9_aspac_fem);
3688: hr_utility.trace('l_estab_rec.m_9_ameri_fem : ' || l_estab_rec.m_9_ameri_fem);
3689: hr_utility.trace('l_estab_rec.n_9_tmraces_female : ' || l_estab_rec.n_9_tmraces_female);

Line 3686: hr_utility.trace('l_estab_rec.k_9_latin_fem : ' || l_estab_rec.k_9_latin_fem);

3682:
3683: hr_utility.trace('l_estab_rec.b_9_hl_female : ' || l_estab_rec.b_9_hl_female);
3684: hr_utility.trace('l_estab_rec.i_9_white_fem : ' || l_estab_rec.i_9_white_fem);
3685: hr_utility.trace('l_estab_rec.j_9_black_fem : ' || l_estab_rec.j_9_black_fem);
3686: hr_utility.trace('l_estab_rec.k_9_latin_fem : ' || l_estab_rec.k_9_latin_fem);
3687: hr_utility.trace('l_estab_rec.l_9_aspac_fem : ' || l_estab_rec.l_9_aspac_fem);
3688: hr_utility.trace('l_estab_rec.m_9_ameri_fem : ' || l_estab_rec.m_9_ameri_fem);
3689: hr_utility.trace('l_estab_rec.n_9_tmraces_female : ' || l_estab_rec.n_9_tmraces_female);
3690:

Line 3687: hr_utility.trace('l_estab_rec.l_9_aspac_fem : ' || l_estab_rec.l_9_aspac_fem);

3683: hr_utility.trace('l_estab_rec.b_9_hl_female : ' || l_estab_rec.b_9_hl_female);
3684: hr_utility.trace('l_estab_rec.i_9_white_fem : ' || l_estab_rec.i_9_white_fem);
3685: hr_utility.trace('l_estab_rec.j_9_black_fem : ' || l_estab_rec.j_9_black_fem);
3686: hr_utility.trace('l_estab_rec.k_9_latin_fem : ' || l_estab_rec.k_9_latin_fem);
3687: hr_utility.trace('l_estab_rec.l_9_aspac_fem : ' || l_estab_rec.l_9_aspac_fem);
3688: hr_utility.trace('l_estab_rec.m_9_ameri_fem : ' || l_estab_rec.m_9_ameri_fem);
3689: hr_utility.trace('l_estab_rec.n_9_tmraces_female : ' || l_estab_rec.n_9_tmraces_female);
3690:
3691: -- IF Hawaii

Line 3688: hr_utility.trace('l_estab_rec.m_9_ameri_fem : ' || l_estab_rec.m_9_ameri_fem);

3684: hr_utility.trace('l_estab_rec.i_9_white_fem : ' || l_estab_rec.i_9_white_fem);
3685: hr_utility.trace('l_estab_rec.j_9_black_fem : ' || l_estab_rec.j_9_black_fem);
3686: hr_utility.trace('l_estab_rec.k_9_latin_fem : ' || l_estab_rec.k_9_latin_fem);
3687: hr_utility.trace('l_estab_rec.l_9_aspac_fem : ' || l_estab_rec.l_9_aspac_fem);
3688: hr_utility.trace('l_estab_rec.m_9_ameri_fem : ' || l_estab_rec.m_9_ameri_fem);
3689: hr_utility.trace('l_estab_rec.n_9_tmraces_female : ' || l_estab_rec.n_9_tmraces_female);
3690:
3691: -- IF Hawaii
3692: /* IF l_estab_rec.state_8 = 'HI' THEN

Line 3689: hr_utility.trace('l_estab_rec.n_9_tmraces_female : ' || l_estab_rec.n_9_tmraces_female);

3685: hr_utility.trace('l_estab_rec.j_9_black_fem : ' || l_estab_rec.j_9_black_fem);
3686: hr_utility.trace('l_estab_rec.k_9_latin_fem : ' || l_estab_rec.k_9_latin_fem);
3687: hr_utility.trace('l_estab_rec.l_9_aspac_fem : ' || l_estab_rec.l_9_aspac_fem);
3688: hr_utility.trace('l_estab_rec.m_9_ameri_fem : ' || l_estab_rec.m_9_ameri_fem);
3689: hr_utility.trace('l_estab_rec.n_9_tmraces_female : ' || l_estab_rec.n_9_tmraces_female);
3690:
3691: -- IF Hawaii
3692: /* IF l_estab_rec.state_8 = 'HI' THEN
3693: l_estab_rec.i_9_white_fem := (l_estab_rec.b_9_hl_female +

Line 3744: hr_utility.trace('l_estab_rec.b_10_hl_female : ' || l_estab_rec.b_10_hl_female);

3740: l_estab_rec.l_10_aspac_fem +
3741: l_estab_rec.m_10_ameri_fem +
3742: l_estab_rec.n_10_tmraces_female;
3743:
3744: hr_utility.trace('l_estab_rec.b_10_hl_female : ' || l_estab_rec.b_10_hl_female);
3745: hr_utility.trace('l_estab_rec.i_10_white_fem : ' || l_estab_rec.i_10_white_fem);
3746: hr_utility.trace('l_estab_rec.j_10_black_fem : ' || l_estab_rec.j_10_black_fem);
3747: hr_utility.trace('l_estab_rec.k_10_latin_fem : ' || l_estab_rec.k_10_latin_fem);
3748: hr_utility.trace('l_estab_rec.l_10_aspac_fem : ' || l_estab_rec.l_10_aspac_fem);

Line 3745: hr_utility.trace('l_estab_rec.i_10_white_fem : ' || l_estab_rec.i_10_white_fem);

3741: l_estab_rec.m_10_ameri_fem +
3742: l_estab_rec.n_10_tmraces_female;
3743:
3744: hr_utility.trace('l_estab_rec.b_10_hl_female : ' || l_estab_rec.b_10_hl_female);
3745: hr_utility.trace('l_estab_rec.i_10_white_fem : ' || l_estab_rec.i_10_white_fem);
3746: hr_utility.trace('l_estab_rec.j_10_black_fem : ' || l_estab_rec.j_10_black_fem);
3747: hr_utility.trace('l_estab_rec.k_10_latin_fem : ' || l_estab_rec.k_10_latin_fem);
3748: hr_utility.trace('l_estab_rec.l_10_aspac_fem : ' || l_estab_rec.l_10_aspac_fem);
3749: hr_utility.trace('l_estab_rec.m_10_ameri_fem : ' || l_estab_rec.m_10_ameri_fem);

Line 3746: hr_utility.trace('l_estab_rec.j_10_black_fem : ' || l_estab_rec.j_10_black_fem);

3742: l_estab_rec.n_10_tmraces_female;
3743:
3744: hr_utility.trace('l_estab_rec.b_10_hl_female : ' || l_estab_rec.b_10_hl_female);
3745: hr_utility.trace('l_estab_rec.i_10_white_fem : ' || l_estab_rec.i_10_white_fem);
3746: hr_utility.trace('l_estab_rec.j_10_black_fem : ' || l_estab_rec.j_10_black_fem);
3747: hr_utility.trace('l_estab_rec.k_10_latin_fem : ' || l_estab_rec.k_10_latin_fem);
3748: hr_utility.trace('l_estab_rec.l_10_aspac_fem : ' || l_estab_rec.l_10_aspac_fem);
3749: hr_utility.trace('l_estab_rec.m_10_ameri_fem : ' || l_estab_rec.m_10_ameri_fem);
3750: hr_utility.trace('l_estab_rec.n_10_tmraces_female : ' || l_estab_rec.n_10_tmraces_female);

Line 3747: hr_utility.trace('l_estab_rec.k_10_latin_fem : ' || l_estab_rec.k_10_latin_fem);

3743:
3744: hr_utility.trace('l_estab_rec.b_10_hl_female : ' || l_estab_rec.b_10_hl_female);
3745: hr_utility.trace('l_estab_rec.i_10_white_fem : ' || l_estab_rec.i_10_white_fem);
3746: hr_utility.trace('l_estab_rec.j_10_black_fem : ' || l_estab_rec.j_10_black_fem);
3747: hr_utility.trace('l_estab_rec.k_10_latin_fem : ' || l_estab_rec.k_10_latin_fem);
3748: hr_utility.trace('l_estab_rec.l_10_aspac_fem : ' || l_estab_rec.l_10_aspac_fem);
3749: hr_utility.trace('l_estab_rec.m_10_ameri_fem : ' || l_estab_rec.m_10_ameri_fem);
3750: hr_utility.trace('l_estab_rec.n_10_tmraces_female : ' || l_estab_rec.n_10_tmraces_female);
3751:

Line 3748: hr_utility.trace('l_estab_rec.l_10_aspac_fem : ' || l_estab_rec.l_10_aspac_fem);

3744: hr_utility.trace('l_estab_rec.b_10_hl_female : ' || l_estab_rec.b_10_hl_female);
3745: hr_utility.trace('l_estab_rec.i_10_white_fem : ' || l_estab_rec.i_10_white_fem);
3746: hr_utility.trace('l_estab_rec.j_10_black_fem : ' || l_estab_rec.j_10_black_fem);
3747: hr_utility.trace('l_estab_rec.k_10_latin_fem : ' || l_estab_rec.k_10_latin_fem);
3748: hr_utility.trace('l_estab_rec.l_10_aspac_fem : ' || l_estab_rec.l_10_aspac_fem);
3749: hr_utility.trace('l_estab_rec.m_10_ameri_fem : ' || l_estab_rec.m_10_ameri_fem);
3750: hr_utility.trace('l_estab_rec.n_10_tmraces_female : ' || l_estab_rec.n_10_tmraces_female);
3751:
3752: -- IF Hawaii

Line 3749: hr_utility.trace('l_estab_rec.m_10_ameri_fem : ' || l_estab_rec.m_10_ameri_fem);

3745: hr_utility.trace('l_estab_rec.i_10_white_fem : ' || l_estab_rec.i_10_white_fem);
3746: hr_utility.trace('l_estab_rec.j_10_black_fem : ' || l_estab_rec.j_10_black_fem);
3747: hr_utility.trace('l_estab_rec.k_10_latin_fem : ' || l_estab_rec.k_10_latin_fem);
3748: hr_utility.trace('l_estab_rec.l_10_aspac_fem : ' || l_estab_rec.l_10_aspac_fem);
3749: hr_utility.trace('l_estab_rec.m_10_ameri_fem : ' || l_estab_rec.m_10_ameri_fem);
3750: hr_utility.trace('l_estab_rec.n_10_tmraces_female : ' || l_estab_rec.n_10_tmraces_female);
3751:
3752: -- IF Hawaii
3753: /* IF l_estab_rec.state_8 = 'HI' THEN

Line 3750: hr_utility.trace('l_estab_rec.n_10_tmraces_female : ' || l_estab_rec.n_10_tmraces_female);

3746: hr_utility.trace('l_estab_rec.j_10_black_fem : ' || l_estab_rec.j_10_black_fem);
3747: hr_utility.trace('l_estab_rec.k_10_latin_fem : ' || l_estab_rec.k_10_latin_fem);
3748: hr_utility.trace('l_estab_rec.l_10_aspac_fem : ' || l_estab_rec.l_10_aspac_fem);
3749: hr_utility.trace('l_estab_rec.m_10_ameri_fem : ' || l_estab_rec.m_10_ameri_fem);
3750: hr_utility.trace('l_estab_rec.n_10_tmraces_female : ' || l_estab_rec.n_10_tmraces_female);
3751:
3752: -- IF Hawaii
3753: /* IF l_estab_rec.state_8 = 'HI' THEN
3754: l_estab_rec.i_10_white_fem := (l_estab_rec.b_10_hl_female +

Line 3790: hr_utility.set_location(l_proc,30);

3786: END LOOP;
3787:
3788: CLOSE c_female_details;
3789:
3790: hr_utility.set_location(l_proc,30);
3791: OPEN c_male_details;
3792: LOOP
3793: FETCH c_male_details INTO l_c_male_details;
3794: EXIT WHEN c_male_details%NOTFOUND;

Line 3817: hr_utility.trace('l_estab_rec.a_1_hl_male : ' || l_estab_rec.a_1_hl_male);

3813: l_estab_rec.f_1_aspac_male +
3814: l_estab_rec.g_1_ameri_male +
3815: l_estab_rec.h_1_tmraces_male;
3816:
3817: hr_utility.trace('l_estab_rec.a_1_hl_male : ' || l_estab_rec.a_1_hl_male);
3818: hr_utility.trace('l_estab_rec.c_1_white_male : ' || l_estab_rec.c_1_white_male);
3819: hr_utility.trace('l_estab_rec.d_1_black_male : ' || l_estab_rec.d_1_black_male);
3820: hr_utility.trace('l_estab_rec.e_1_latin_male : ' || l_estab_rec.e_1_latin_male);
3821: hr_utility.trace('l_estab_rec.f_1_aspac_male : ' || l_estab_rec.f_1_aspac_male);

Line 3818: hr_utility.trace('l_estab_rec.c_1_white_male : ' || l_estab_rec.c_1_white_male);

3814: l_estab_rec.g_1_ameri_male +
3815: l_estab_rec.h_1_tmraces_male;
3816:
3817: hr_utility.trace('l_estab_rec.a_1_hl_male : ' || l_estab_rec.a_1_hl_male);
3818: hr_utility.trace('l_estab_rec.c_1_white_male : ' || l_estab_rec.c_1_white_male);
3819: hr_utility.trace('l_estab_rec.d_1_black_male : ' || l_estab_rec.d_1_black_male);
3820: hr_utility.trace('l_estab_rec.e_1_latin_male : ' || l_estab_rec.e_1_latin_male);
3821: hr_utility.trace('l_estab_rec.f_1_aspac_male : ' || l_estab_rec.f_1_aspac_male);
3822: hr_utility.trace('l_estab_rec.g_1_ameri_male : ' || l_estab_rec.g_1_ameri_male);

Line 3819: hr_utility.trace('l_estab_rec.d_1_black_male : ' || l_estab_rec.d_1_black_male);

3815: l_estab_rec.h_1_tmraces_male;
3816:
3817: hr_utility.trace('l_estab_rec.a_1_hl_male : ' || l_estab_rec.a_1_hl_male);
3818: hr_utility.trace('l_estab_rec.c_1_white_male : ' || l_estab_rec.c_1_white_male);
3819: hr_utility.trace('l_estab_rec.d_1_black_male : ' || l_estab_rec.d_1_black_male);
3820: hr_utility.trace('l_estab_rec.e_1_latin_male : ' || l_estab_rec.e_1_latin_male);
3821: hr_utility.trace('l_estab_rec.f_1_aspac_male : ' || l_estab_rec.f_1_aspac_male);
3822: hr_utility.trace('l_estab_rec.g_1_ameri_male : ' || l_estab_rec.g_1_ameri_male);
3823: hr_utility.trace('l_estab_rec.h_1_tmraces_male : ' || l_estab_rec.h_1_tmraces_male);

Line 3820: hr_utility.trace('l_estab_rec.e_1_latin_male : ' || l_estab_rec.e_1_latin_male);

3816:
3817: hr_utility.trace('l_estab_rec.a_1_hl_male : ' || l_estab_rec.a_1_hl_male);
3818: hr_utility.trace('l_estab_rec.c_1_white_male : ' || l_estab_rec.c_1_white_male);
3819: hr_utility.trace('l_estab_rec.d_1_black_male : ' || l_estab_rec.d_1_black_male);
3820: hr_utility.trace('l_estab_rec.e_1_latin_male : ' || l_estab_rec.e_1_latin_male);
3821: hr_utility.trace('l_estab_rec.f_1_aspac_male : ' || l_estab_rec.f_1_aspac_male);
3822: hr_utility.trace('l_estab_rec.g_1_ameri_male : ' || l_estab_rec.g_1_ameri_male);
3823: hr_utility.trace('l_estab_rec.h_1_tmraces_male : ' || l_estab_rec.h_1_tmraces_male);
3824: hr_utility.trace('l_estab_rec.o_1_total_cat : ' || l_estab_rec.o_1_total_cat);

Line 3821: hr_utility.trace('l_estab_rec.f_1_aspac_male : ' || l_estab_rec.f_1_aspac_male);

3817: hr_utility.trace('l_estab_rec.a_1_hl_male : ' || l_estab_rec.a_1_hl_male);
3818: hr_utility.trace('l_estab_rec.c_1_white_male : ' || l_estab_rec.c_1_white_male);
3819: hr_utility.trace('l_estab_rec.d_1_black_male : ' || l_estab_rec.d_1_black_male);
3820: hr_utility.trace('l_estab_rec.e_1_latin_male : ' || l_estab_rec.e_1_latin_male);
3821: hr_utility.trace('l_estab_rec.f_1_aspac_male : ' || l_estab_rec.f_1_aspac_male);
3822: hr_utility.trace('l_estab_rec.g_1_ameri_male : ' || l_estab_rec.g_1_ameri_male);
3823: hr_utility.trace('l_estab_rec.h_1_tmraces_male : ' || l_estab_rec.h_1_tmraces_male);
3824: hr_utility.trace('l_estab_rec.o_1_total_cat : ' || l_estab_rec.o_1_total_cat);
3825:

Line 3822: hr_utility.trace('l_estab_rec.g_1_ameri_male : ' || l_estab_rec.g_1_ameri_male);

3818: hr_utility.trace('l_estab_rec.c_1_white_male : ' || l_estab_rec.c_1_white_male);
3819: hr_utility.trace('l_estab_rec.d_1_black_male : ' || l_estab_rec.d_1_black_male);
3820: hr_utility.trace('l_estab_rec.e_1_latin_male : ' || l_estab_rec.e_1_latin_male);
3821: hr_utility.trace('l_estab_rec.f_1_aspac_male : ' || l_estab_rec.f_1_aspac_male);
3822: hr_utility.trace('l_estab_rec.g_1_ameri_male : ' || l_estab_rec.g_1_ameri_male);
3823: hr_utility.trace('l_estab_rec.h_1_tmraces_male : ' || l_estab_rec.h_1_tmraces_male);
3824: hr_utility.trace('l_estab_rec.o_1_total_cat : ' || l_estab_rec.o_1_total_cat);
3825:
3826: -- IF Hawaii

Line 3823: hr_utility.trace('l_estab_rec.h_1_tmraces_male : ' || l_estab_rec.h_1_tmraces_male);

3819: hr_utility.trace('l_estab_rec.d_1_black_male : ' || l_estab_rec.d_1_black_male);
3820: hr_utility.trace('l_estab_rec.e_1_latin_male : ' || l_estab_rec.e_1_latin_male);
3821: hr_utility.trace('l_estab_rec.f_1_aspac_male : ' || l_estab_rec.f_1_aspac_male);
3822: hr_utility.trace('l_estab_rec.g_1_ameri_male : ' || l_estab_rec.g_1_ameri_male);
3823: hr_utility.trace('l_estab_rec.h_1_tmraces_male : ' || l_estab_rec.h_1_tmraces_male);
3824: hr_utility.trace('l_estab_rec.o_1_total_cat : ' || l_estab_rec.o_1_total_cat);
3825:
3826: -- IF Hawaii
3827: /* IF l_estab_rec.state_8 = 'HI' THEN

Line 3824: hr_utility.trace('l_estab_rec.o_1_total_cat : ' || l_estab_rec.o_1_total_cat);

3820: hr_utility.trace('l_estab_rec.e_1_latin_male : ' || l_estab_rec.e_1_latin_male);
3821: hr_utility.trace('l_estab_rec.f_1_aspac_male : ' || l_estab_rec.f_1_aspac_male);
3822: hr_utility.trace('l_estab_rec.g_1_ameri_male : ' || l_estab_rec.g_1_ameri_male);
3823: hr_utility.trace('l_estab_rec.h_1_tmraces_male : ' || l_estab_rec.h_1_tmraces_male);
3824: hr_utility.trace('l_estab_rec.o_1_total_cat : ' || l_estab_rec.o_1_total_cat);
3825:
3826: -- IF Hawaii
3827: /* IF l_estab_rec.state_8 = 'HI' THEN
3828: l_estab_rec.c_1_white_male := (l_estab_rec.a_1_hl_male +

Line 3880: hr_utility.trace('l_estab_rec.a_2_hl_male : ' || l_estab_rec.a_2_hl_male);

3876: l_estab_rec.f_2_aspac_male +
3877: l_estab_rec.g_2_ameri_male +
3878: l_estab_rec.h_2_tmraces_male;
3879:
3880: hr_utility.trace('l_estab_rec.a_2_hl_male : ' || l_estab_rec.a_2_hl_male);
3881: hr_utility.trace('l_estab_rec.c_2_white_male : ' || l_estab_rec.c_2_white_male);
3882: hr_utility.trace('l_estab_rec.d_2_black_male : ' || l_estab_rec.d_2_black_male);
3883: hr_utility.trace('l_estab_rec.e_2_latin_male : ' || l_estab_rec.e_2_latin_male);
3884: hr_utility.trace('l_estab_rec.f_2_aspac_male : ' || l_estab_rec.f_2_aspac_male);

Line 3881: hr_utility.trace('l_estab_rec.c_2_white_male : ' || l_estab_rec.c_2_white_male);

3877: l_estab_rec.g_2_ameri_male +
3878: l_estab_rec.h_2_tmraces_male;
3879:
3880: hr_utility.trace('l_estab_rec.a_2_hl_male : ' || l_estab_rec.a_2_hl_male);
3881: hr_utility.trace('l_estab_rec.c_2_white_male : ' || l_estab_rec.c_2_white_male);
3882: hr_utility.trace('l_estab_rec.d_2_black_male : ' || l_estab_rec.d_2_black_male);
3883: hr_utility.trace('l_estab_rec.e_2_latin_male : ' || l_estab_rec.e_2_latin_male);
3884: hr_utility.trace('l_estab_rec.f_2_aspac_male : ' || l_estab_rec.f_2_aspac_male);
3885: hr_utility.trace('l_estab_rec.g_2_ameri_male : ' || l_estab_rec.g_2_ameri_male);

Line 3882: hr_utility.trace('l_estab_rec.d_2_black_male : ' || l_estab_rec.d_2_black_male);

3878: l_estab_rec.h_2_tmraces_male;
3879:
3880: hr_utility.trace('l_estab_rec.a_2_hl_male : ' || l_estab_rec.a_2_hl_male);
3881: hr_utility.trace('l_estab_rec.c_2_white_male : ' || l_estab_rec.c_2_white_male);
3882: hr_utility.trace('l_estab_rec.d_2_black_male : ' || l_estab_rec.d_2_black_male);
3883: hr_utility.trace('l_estab_rec.e_2_latin_male : ' || l_estab_rec.e_2_latin_male);
3884: hr_utility.trace('l_estab_rec.f_2_aspac_male : ' || l_estab_rec.f_2_aspac_male);
3885: hr_utility.trace('l_estab_rec.g_2_ameri_male : ' || l_estab_rec.g_2_ameri_male);
3886: hr_utility.trace('l_estab_rec.h_2_tmraces_male : ' || l_estab_rec.h_2_tmraces_male);

Line 3883: hr_utility.trace('l_estab_rec.e_2_latin_male : ' || l_estab_rec.e_2_latin_male);

3879:
3880: hr_utility.trace('l_estab_rec.a_2_hl_male : ' || l_estab_rec.a_2_hl_male);
3881: hr_utility.trace('l_estab_rec.c_2_white_male : ' || l_estab_rec.c_2_white_male);
3882: hr_utility.trace('l_estab_rec.d_2_black_male : ' || l_estab_rec.d_2_black_male);
3883: hr_utility.trace('l_estab_rec.e_2_latin_male : ' || l_estab_rec.e_2_latin_male);
3884: hr_utility.trace('l_estab_rec.f_2_aspac_male : ' || l_estab_rec.f_2_aspac_male);
3885: hr_utility.trace('l_estab_rec.g_2_ameri_male : ' || l_estab_rec.g_2_ameri_male);
3886: hr_utility.trace('l_estab_rec.h_2_tmraces_male : ' || l_estab_rec.h_2_tmraces_male);
3887: hr_utility.trace('l_estab_rec.o_2_total_cat : ' || l_estab_rec.o_2_total_cat);

Line 3884: hr_utility.trace('l_estab_rec.f_2_aspac_male : ' || l_estab_rec.f_2_aspac_male);

3880: hr_utility.trace('l_estab_rec.a_2_hl_male : ' || l_estab_rec.a_2_hl_male);
3881: hr_utility.trace('l_estab_rec.c_2_white_male : ' || l_estab_rec.c_2_white_male);
3882: hr_utility.trace('l_estab_rec.d_2_black_male : ' || l_estab_rec.d_2_black_male);
3883: hr_utility.trace('l_estab_rec.e_2_latin_male : ' || l_estab_rec.e_2_latin_male);
3884: hr_utility.trace('l_estab_rec.f_2_aspac_male : ' || l_estab_rec.f_2_aspac_male);
3885: hr_utility.trace('l_estab_rec.g_2_ameri_male : ' || l_estab_rec.g_2_ameri_male);
3886: hr_utility.trace('l_estab_rec.h_2_tmraces_male : ' || l_estab_rec.h_2_tmraces_male);
3887: hr_utility.trace('l_estab_rec.o_2_total_cat : ' || l_estab_rec.o_2_total_cat);
3888:

Line 3885: hr_utility.trace('l_estab_rec.g_2_ameri_male : ' || l_estab_rec.g_2_ameri_male);

3881: hr_utility.trace('l_estab_rec.c_2_white_male : ' || l_estab_rec.c_2_white_male);
3882: hr_utility.trace('l_estab_rec.d_2_black_male : ' || l_estab_rec.d_2_black_male);
3883: hr_utility.trace('l_estab_rec.e_2_latin_male : ' || l_estab_rec.e_2_latin_male);
3884: hr_utility.trace('l_estab_rec.f_2_aspac_male : ' || l_estab_rec.f_2_aspac_male);
3885: hr_utility.trace('l_estab_rec.g_2_ameri_male : ' || l_estab_rec.g_2_ameri_male);
3886: hr_utility.trace('l_estab_rec.h_2_tmraces_male : ' || l_estab_rec.h_2_tmraces_male);
3887: hr_utility.trace('l_estab_rec.o_2_total_cat : ' || l_estab_rec.o_2_total_cat);
3888:
3889: -- IF Hawaii

Line 3886: hr_utility.trace('l_estab_rec.h_2_tmraces_male : ' || l_estab_rec.h_2_tmraces_male);

3882: hr_utility.trace('l_estab_rec.d_2_black_male : ' || l_estab_rec.d_2_black_male);
3883: hr_utility.trace('l_estab_rec.e_2_latin_male : ' || l_estab_rec.e_2_latin_male);
3884: hr_utility.trace('l_estab_rec.f_2_aspac_male : ' || l_estab_rec.f_2_aspac_male);
3885: hr_utility.trace('l_estab_rec.g_2_ameri_male : ' || l_estab_rec.g_2_ameri_male);
3886: hr_utility.trace('l_estab_rec.h_2_tmraces_male : ' || l_estab_rec.h_2_tmraces_male);
3887: hr_utility.trace('l_estab_rec.o_2_total_cat : ' || l_estab_rec.o_2_total_cat);
3888:
3889: -- IF Hawaii
3890: /* IF l_estab_rec.state_8 = 'HI' THEN

Line 3887: hr_utility.trace('l_estab_rec.o_2_total_cat : ' || l_estab_rec.o_2_total_cat);

3883: hr_utility.trace('l_estab_rec.e_2_latin_male : ' || l_estab_rec.e_2_latin_male);
3884: hr_utility.trace('l_estab_rec.f_2_aspac_male : ' || l_estab_rec.f_2_aspac_male);
3885: hr_utility.trace('l_estab_rec.g_2_ameri_male : ' || l_estab_rec.g_2_ameri_male);
3886: hr_utility.trace('l_estab_rec.h_2_tmraces_male : ' || l_estab_rec.h_2_tmraces_male);
3887: hr_utility.trace('l_estab_rec.o_2_total_cat : ' || l_estab_rec.o_2_total_cat);
3888:
3889: -- IF Hawaii
3890: /* IF l_estab_rec.state_8 = 'HI' THEN
3891: l_estab_rec.c_2_white_male := (l_estab_rec.a_2_hl_male +

Line 3943: hr_utility.trace('l_estab_rec.a_3_hl_male : ' || l_estab_rec.a_3_hl_male);

3939: l_estab_rec.f_3_aspac_male +
3940: l_estab_rec.g_3_ameri_male +
3941: l_estab_rec.h_3_tmraces_male;
3942:
3943: hr_utility.trace('l_estab_rec.a_3_hl_male : ' || l_estab_rec.a_3_hl_male);
3944: hr_utility.trace('l_estab_rec.c_3_white_male : ' || l_estab_rec.c_3_white_male);
3945: hr_utility.trace('l_estab_rec.d_3_black_male : ' || l_estab_rec.d_3_black_male);
3946: hr_utility.trace('l_estab_rec.e_3_latin_male : ' || l_estab_rec.e_3_latin_male);
3947: hr_utility.trace('l_estab_rec.f_3_aspac_male : ' || l_estab_rec.f_3_aspac_male);

Line 3944: hr_utility.trace('l_estab_rec.c_3_white_male : ' || l_estab_rec.c_3_white_male);

3940: l_estab_rec.g_3_ameri_male +
3941: l_estab_rec.h_3_tmraces_male;
3942:
3943: hr_utility.trace('l_estab_rec.a_3_hl_male : ' || l_estab_rec.a_3_hl_male);
3944: hr_utility.trace('l_estab_rec.c_3_white_male : ' || l_estab_rec.c_3_white_male);
3945: hr_utility.trace('l_estab_rec.d_3_black_male : ' || l_estab_rec.d_3_black_male);
3946: hr_utility.trace('l_estab_rec.e_3_latin_male : ' || l_estab_rec.e_3_latin_male);
3947: hr_utility.trace('l_estab_rec.f_3_aspac_male : ' || l_estab_rec.f_3_aspac_male);
3948: hr_utility.trace('l_estab_rec.g_3_ameri_male : ' || l_estab_rec.g_3_ameri_male);

Line 3945: hr_utility.trace('l_estab_rec.d_3_black_male : ' || l_estab_rec.d_3_black_male);

3941: l_estab_rec.h_3_tmraces_male;
3942:
3943: hr_utility.trace('l_estab_rec.a_3_hl_male : ' || l_estab_rec.a_3_hl_male);
3944: hr_utility.trace('l_estab_rec.c_3_white_male : ' || l_estab_rec.c_3_white_male);
3945: hr_utility.trace('l_estab_rec.d_3_black_male : ' || l_estab_rec.d_3_black_male);
3946: hr_utility.trace('l_estab_rec.e_3_latin_male : ' || l_estab_rec.e_3_latin_male);
3947: hr_utility.trace('l_estab_rec.f_3_aspac_male : ' || l_estab_rec.f_3_aspac_male);
3948: hr_utility.trace('l_estab_rec.g_3_ameri_male : ' || l_estab_rec.g_3_ameri_male);
3949: hr_utility.trace('l_estab_rec.h_3_tmraces_male : ' || l_estab_rec.h_3_tmraces_male);

Line 3946: hr_utility.trace('l_estab_rec.e_3_latin_male : ' || l_estab_rec.e_3_latin_male);

3942:
3943: hr_utility.trace('l_estab_rec.a_3_hl_male : ' || l_estab_rec.a_3_hl_male);
3944: hr_utility.trace('l_estab_rec.c_3_white_male : ' || l_estab_rec.c_3_white_male);
3945: hr_utility.trace('l_estab_rec.d_3_black_male : ' || l_estab_rec.d_3_black_male);
3946: hr_utility.trace('l_estab_rec.e_3_latin_male : ' || l_estab_rec.e_3_latin_male);
3947: hr_utility.trace('l_estab_rec.f_3_aspac_male : ' || l_estab_rec.f_3_aspac_male);
3948: hr_utility.trace('l_estab_rec.g_3_ameri_male : ' || l_estab_rec.g_3_ameri_male);
3949: hr_utility.trace('l_estab_rec.h_3_tmraces_male : ' || l_estab_rec.h_3_tmraces_male);
3950: hr_utility.trace('l_estab_rec.o_3_total_cat : ' || l_estab_rec.o_3_total_cat);

Line 3947: hr_utility.trace('l_estab_rec.f_3_aspac_male : ' || l_estab_rec.f_3_aspac_male);

3943: hr_utility.trace('l_estab_rec.a_3_hl_male : ' || l_estab_rec.a_3_hl_male);
3944: hr_utility.trace('l_estab_rec.c_3_white_male : ' || l_estab_rec.c_3_white_male);
3945: hr_utility.trace('l_estab_rec.d_3_black_male : ' || l_estab_rec.d_3_black_male);
3946: hr_utility.trace('l_estab_rec.e_3_latin_male : ' || l_estab_rec.e_3_latin_male);
3947: hr_utility.trace('l_estab_rec.f_3_aspac_male : ' || l_estab_rec.f_3_aspac_male);
3948: hr_utility.trace('l_estab_rec.g_3_ameri_male : ' || l_estab_rec.g_3_ameri_male);
3949: hr_utility.trace('l_estab_rec.h_3_tmraces_male : ' || l_estab_rec.h_3_tmraces_male);
3950: hr_utility.trace('l_estab_rec.o_3_total_cat : ' || l_estab_rec.o_3_total_cat);
3951:

Line 3948: hr_utility.trace('l_estab_rec.g_3_ameri_male : ' || l_estab_rec.g_3_ameri_male);

3944: hr_utility.trace('l_estab_rec.c_3_white_male : ' || l_estab_rec.c_3_white_male);
3945: hr_utility.trace('l_estab_rec.d_3_black_male : ' || l_estab_rec.d_3_black_male);
3946: hr_utility.trace('l_estab_rec.e_3_latin_male : ' || l_estab_rec.e_3_latin_male);
3947: hr_utility.trace('l_estab_rec.f_3_aspac_male : ' || l_estab_rec.f_3_aspac_male);
3948: hr_utility.trace('l_estab_rec.g_3_ameri_male : ' || l_estab_rec.g_3_ameri_male);
3949: hr_utility.trace('l_estab_rec.h_3_tmraces_male : ' || l_estab_rec.h_3_tmraces_male);
3950: hr_utility.trace('l_estab_rec.o_3_total_cat : ' || l_estab_rec.o_3_total_cat);
3951:
3952: -- IF Hawaii

Line 3949: hr_utility.trace('l_estab_rec.h_3_tmraces_male : ' || l_estab_rec.h_3_tmraces_male);

3945: hr_utility.trace('l_estab_rec.d_3_black_male : ' || l_estab_rec.d_3_black_male);
3946: hr_utility.trace('l_estab_rec.e_3_latin_male : ' || l_estab_rec.e_3_latin_male);
3947: hr_utility.trace('l_estab_rec.f_3_aspac_male : ' || l_estab_rec.f_3_aspac_male);
3948: hr_utility.trace('l_estab_rec.g_3_ameri_male : ' || l_estab_rec.g_3_ameri_male);
3949: hr_utility.trace('l_estab_rec.h_3_tmraces_male : ' || l_estab_rec.h_3_tmraces_male);
3950: hr_utility.trace('l_estab_rec.o_3_total_cat : ' || l_estab_rec.o_3_total_cat);
3951:
3952: -- IF Hawaii
3953: /* IF l_estab_rec.state_8 = 'HI' THEN

Line 3950: hr_utility.trace('l_estab_rec.o_3_total_cat : ' || l_estab_rec.o_3_total_cat);

3946: hr_utility.trace('l_estab_rec.e_3_latin_male : ' || l_estab_rec.e_3_latin_male);
3947: hr_utility.trace('l_estab_rec.f_3_aspac_male : ' || l_estab_rec.f_3_aspac_male);
3948: hr_utility.trace('l_estab_rec.g_3_ameri_male : ' || l_estab_rec.g_3_ameri_male);
3949: hr_utility.trace('l_estab_rec.h_3_tmraces_male : ' || l_estab_rec.h_3_tmraces_male);
3950: hr_utility.trace('l_estab_rec.o_3_total_cat : ' || l_estab_rec.o_3_total_cat);
3951:
3952: -- IF Hawaii
3953: /* IF l_estab_rec.state_8 = 'HI' THEN
3954: l_estab_rec.c_3_white_male := (l_estab_rec.a_3_hl_male +

Line 4006: hr_utility.trace('l_estab_rec.a_4_hl_male : ' || l_estab_rec.a_4_hl_male);

4002: l_estab_rec.f_4_aspac_male +
4003: l_estab_rec.g_4_ameri_male +
4004: l_estab_rec.h_4_tmraces_male;
4005:
4006: hr_utility.trace('l_estab_rec.a_4_hl_male : ' || l_estab_rec.a_4_hl_male);
4007: hr_utility.trace('l_estab_rec.c_4_white_male : ' || l_estab_rec.c_4_white_male);
4008: hr_utility.trace('l_estab_rec.d_4_black_male : ' || l_estab_rec.d_4_black_male);
4009: hr_utility.trace('l_estab_rec.e_4_latin_male : ' || l_estab_rec.e_4_latin_male);
4010: hr_utility.trace('l_estab_rec.f_4_aspac_male : ' || l_estab_rec.f_4_aspac_male);

Line 4007: hr_utility.trace('l_estab_rec.c_4_white_male : ' || l_estab_rec.c_4_white_male);

4003: l_estab_rec.g_4_ameri_male +
4004: l_estab_rec.h_4_tmraces_male;
4005:
4006: hr_utility.trace('l_estab_rec.a_4_hl_male : ' || l_estab_rec.a_4_hl_male);
4007: hr_utility.trace('l_estab_rec.c_4_white_male : ' || l_estab_rec.c_4_white_male);
4008: hr_utility.trace('l_estab_rec.d_4_black_male : ' || l_estab_rec.d_4_black_male);
4009: hr_utility.trace('l_estab_rec.e_4_latin_male : ' || l_estab_rec.e_4_latin_male);
4010: hr_utility.trace('l_estab_rec.f_4_aspac_male : ' || l_estab_rec.f_4_aspac_male);
4011: hr_utility.trace('l_estab_rec.g_4_ameri_male : ' || l_estab_rec.g_4_ameri_male);

Line 4008: hr_utility.trace('l_estab_rec.d_4_black_male : ' || l_estab_rec.d_4_black_male);

4004: l_estab_rec.h_4_tmraces_male;
4005:
4006: hr_utility.trace('l_estab_rec.a_4_hl_male : ' || l_estab_rec.a_4_hl_male);
4007: hr_utility.trace('l_estab_rec.c_4_white_male : ' || l_estab_rec.c_4_white_male);
4008: hr_utility.trace('l_estab_rec.d_4_black_male : ' || l_estab_rec.d_4_black_male);
4009: hr_utility.trace('l_estab_rec.e_4_latin_male : ' || l_estab_rec.e_4_latin_male);
4010: hr_utility.trace('l_estab_rec.f_4_aspac_male : ' || l_estab_rec.f_4_aspac_male);
4011: hr_utility.trace('l_estab_rec.g_4_ameri_male : ' || l_estab_rec.g_4_ameri_male);
4012: hr_utility.trace('l_estab_rec.h_4_tmraces_male : ' || l_estab_rec.h_4_tmraces_male);

Line 4009: hr_utility.trace('l_estab_rec.e_4_latin_male : ' || l_estab_rec.e_4_latin_male);

4005:
4006: hr_utility.trace('l_estab_rec.a_4_hl_male : ' || l_estab_rec.a_4_hl_male);
4007: hr_utility.trace('l_estab_rec.c_4_white_male : ' || l_estab_rec.c_4_white_male);
4008: hr_utility.trace('l_estab_rec.d_4_black_male : ' || l_estab_rec.d_4_black_male);
4009: hr_utility.trace('l_estab_rec.e_4_latin_male : ' || l_estab_rec.e_4_latin_male);
4010: hr_utility.trace('l_estab_rec.f_4_aspac_male : ' || l_estab_rec.f_4_aspac_male);
4011: hr_utility.trace('l_estab_rec.g_4_ameri_male : ' || l_estab_rec.g_4_ameri_male);
4012: hr_utility.trace('l_estab_rec.h_4_tmraces_male : ' || l_estab_rec.h_4_tmraces_male);
4013: hr_utility.trace('l_estab_rec.o_4_total_cat : ' || l_estab_rec.o_4_total_cat);

Line 4010: hr_utility.trace('l_estab_rec.f_4_aspac_male : ' || l_estab_rec.f_4_aspac_male);

4006: hr_utility.trace('l_estab_rec.a_4_hl_male : ' || l_estab_rec.a_4_hl_male);
4007: hr_utility.trace('l_estab_rec.c_4_white_male : ' || l_estab_rec.c_4_white_male);
4008: hr_utility.trace('l_estab_rec.d_4_black_male : ' || l_estab_rec.d_4_black_male);
4009: hr_utility.trace('l_estab_rec.e_4_latin_male : ' || l_estab_rec.e_4_latin_male);
4010: hr_utility.trace('l_estab_rec.f_4_aspac_male : ' || l_estab_rec.f_4_aspac_male);
4011: hr_utility.trace('l_estab_rec.g_4_ameri_male : ' || l_estab_rec.g_4_ameri_male);
4012: hr_utility.trace('l_estab_rec.h_4_tmraces_male : ' || l_estab_rec.h_4_tmraces_male);
4013: hr_utility.trace('l_estab_rec.o_4_total_cat : ' || l_estab_rec.o_4_total_cat);
4014:

Line 4011: hr_utility.trace('l_estab_rec.g_4_ameri_male : ' || l_estab_rec.g_4_ameri_male);

4007: hr_utility.trace('l_estab_rec.c_4_white_male : ' || l_estab_rec.c_4_white_male);
4008: hr_utility.trace('l_estab_rec.d_4_black_male : ' || l_estab_rec.d_4_black_male);
4009: hr_utility.trace('l_estab_rec.e_4_latin_male : ' || l_estab_rec.e_4_latin_male);
4010: hr_utility.trace('l_estab_rec.f_4_aspac_male : ' || l_estab_rec.f_4_aspac_male);
4011: hr_utility.trace('l_estab_rec.g_4_ameri_male : ' || l_estab_rec.g_4_ameri_male);
4012: hr_utility.trace('l_estab_rec.h_4_tmraces_male : ' || l_estab_rec.h_4_tmraces_male);
4013: hr_utility.trace('l_estab_rec.o_4_total_cat : ' || l_estab_rec.o_4_total_cat);
4014:
4015: -- IF Hawaii

Line 4012: hr_utility.trace('l_estab_rec.h_4_tmraces_male : ' || l_estab_rec.h_4_tmraces_male);

4008: hr_utility.trace('l_estab_rec.d_4_black_male : ' || l_estab_rec.d_4_black_male);
4009: hr_utility.trace('l_estab_rec.e_4_latin_male : ' || l_estab_rec.e_4_latin_male);
4010: hr_utility.trace('l_estab_rec.f_4_aspac_male : ' || l_estab_rec.f_4_aspac_male);
4011: hr_utility.trace('l_estab_rec.g_4_ameri_male : ' || l_estab_rec.g_4_ameri_male);
4012: hr_utility.trace('l_estab_rec.h_4_tmraces_male : ' || l_estab_rec.h_4_tmraces_male);
4013: hr_utility.trace('l_estab_rec.o_4_total_cat : ' || l_estab_rec.o_4_total_cat);
4014:
4015: -- IF Hawaii
4016: /* IF l_estab_rec.state_8 = 'HI' THEN

Line 4013: hr_utility.trace('l_estab_rec.o_4_total_cat : ' || l_estab_rec.o_4_total_cat);

4009: hr_utility.trace('l_estab_rec.e_4_latin_male : ' || l_estab_rec.e_4_latin_male);
4010: hr_utility.trace('l_estab_rec.f_4_aspac_male : ' || l_estab_rec.f_4_aspac_male);
4011: hr_utility.trace('l_estab_rec.g_4_ameri_male : ' || l_estab_rec.g_4_ameri_male);
4012: hr_utility.trace('l_estab_rec.h_4_tmraces_male : ' || l_estab_rec.h_4_tmraces_male);
4013: hr_utility.trace('l_estab_rec.o_4_total_cat : ' || l_estab_rec.o_4_total_cat);
4014:
4015: -- IF Hawaii
4016: /* IF l_estab_rec.state_8 = 'HI' THEN
4017: l_estab_rec.c_4_white_male := (l_estab_rec.a_4_hl_male +

Line 4069: hr_utility.trace('l_estab_rec.a_5_hl_male : ' || l_estab_rec.a_5_hl_male);

4065: l_estab_rec.f_5_aspac_male +
4066: l_estab_rec.g_5_ameri_male +
4067: l_estab_rec.h_5_tmraces_male;
4068:
4069: hr_utility.trace('l_estab_rec.a_5_hl_male : ' || l_estab_rec.a_5_hl_male);
4070: hr_utility.trace('l_estab_rec.c_5_white_male : ' || l_estab_rec.c_5_white_male);
4071: hr_utility.trace('l_estab_rec.d_5_black_male : ' || l_estab_rec.d_5_black_male);
4072: hr_utility.trace('l_estab_rec.e_5_latin_male : ' || l_estab_rec.e_5_latin_male);
4073: hr_utility.trace('l_estab_rec.f_5_aspac_male : ' || l_estab_rec.f_5_aspac_male);

Line 4070: hr_utility.trace('l_estab_rec.c_5_white_male : ' || l_estab_rec.c_5_white_male);

4066: l_estab_rec.g_5_ameri_male +
4067: l_estab_rec.h_5_tmraces_male;
4068:
4069: hr_utility.trace('l_estab_rec.a_5_hl_male : ' || l_estab_rec.a_5_hl_male);
4070: hr_utility.trace('l_estab_rec.c_5_white_male : ' || l_estab_rec.c_5_white_male);
4071: hr_utility.trace('l_estab_rec.d_5_black_male : ' || l_estab_rec.d_5_black_male);
4072: hr_utility.trace('l_estab_rec.e_5_latin_male : ' || l_estab_rec.e_5_latin_male);
4073: hr_utility.trace('l_estab_rec.f_5_aspac_male : ' || l_estab_rec.f_5_aspac_male);
4074: hr_utility.trace('l_estab_rec.g_5_ameri_male : ' || l_estab_rec.g_5_ameri_male);

Line 4071: hr_utility.trace('l_estab_rec.d_5_black_male : ' || l_estab_rec.d_5_black_male);

4067: l_estab_rec.h_5_tmraces_male;
4068:
4069: hr_utility.trace('l_estab_rec.a_5_hl_male : ' || l_estab_rec.a_5_hl_male);
4070: hr_utility.trace('l_estab_rec.c_5_white_male : ' || l_estab_rec.c_5_white_male);
4071: hr_utility.trace('l_estab_rec.d_5_black_male : ' || l_estab_rec.d_5_black_male);
4072: hr_utility.trace('l_estab_rec.e_5_latin_male : ' || l_estab_rec.e_5_latin_male);
4073: hr_utility.trace('l_estab_rec.f_5_aspac_male : ' || l_estab_rec.f_5_aspac_male);
4074: hr_utility.trace('l_estab_rec.g_5_ameri_male : ' || l_estab_rec.g_5_ameri_male);
4075: hr_utility.trace('l_estab_rec.h_5_tmraces_male : ' || l_estab_rec.h_5_tmraces_male);

Line 4072: hr_utility.trace('l_estab_rec.e_5_latin_male : ' || l_estab_rec.e_5_latin_male);

4068:
4069: hr_utility.trace('l_estab_rec.a_5_hl_male : ' || l_estab_rec.a_5_hl_male);
4070: hr_utility.trace('l_estab_rec.c_5_white_male : ' || l_estab_rec.c_5_white_male);
4071: hr_utility.trace('l_estab_rec.d_5_black_male : ' || l_estab_rec.d_5_black_male);
4072: hr_utility.trace('l_estab_rec.e_5_latin_male : ' || l_estab_rec.e_5_latin_male);
4073: hr_utility.trace('l_estab_rec.f_5_aspac_male : ' || l_estab_rec.f_5_aspac_male);
4074: hr_utility.trace('l_estab_rec.g_5_ameri_male : ' || l_estab_rec.g_5_ameri_male);
4075: hr_utility.trace('l_estab_rec.h_5_tmraces_male : ' || l_estab_rec.h_5_tmraces_male);
4076: hr_utility.trace('l_estab_rec.o_5_total_cat : ' || l_estab_rec.o_5_total_cat);

Line 4073: hr_utility.trace('l_estab_rec.f_5_aspac_male : ' || l_estab_rec.f_5_aspac_male);

4069: hr_utility.trace('l_estab_rec.a_5_hl_male : ' || l_estab_rec.a_5_hl_male);
4070: hr_utility.trace('l_estab_rec.c_5_white_male : ' || l_estab_rec.c_5_white_male);
4071: hr_utility.trace('l_estab_rec.d_5_black_male : ' || l_estab_rec.d_5_black_male);
4072: hr_utility.trace('l_estab_rec.e_5_latin_male : ' || l_estab_rec.e_5_latin_male);
4073: hr_utility.trace('l_estab_rec.f_5_aspac_male : ' || l_estab_rec.f_5_aspac_male);
4074: hr_utility.trace('l_estab_rec.g_5_ameri_male : ' || l_estab_rec.g_5_ameri_male);
4075: hr_utility.trace('l_estab_rec.h_5_tmraces_male : ' || l_estab_rec.h_5_tmraces_male);
4076: hr_utility.trace('l_estab_rec.o_5_total_cat : ' || l_estab_rec.o_5_total_cat);
4077:

Line 4074: hr_utility.trace('l_estab_rec.g_5_ameri_male : ' || l_estab_rec.g_5_ameri_male);

4070: hr_utility.trace('l_estab_rec.c_5_white_male : ' || l_estab_rec.c_5_white_male);
4071: hr_utility.trace('l_estab_rec.d_5_black_male : ' || l_estab_rec.d_5_black_male);
4072: hr_utility.trace('l_estab_rec.e_5_latin_male : ' || l_estab_rec.e_5_latin_male);
4073: hr_utility.trace('l_estab_rec.f_5_aspac_male : ' || l_estab_rec.f_5_aspac_male);
4074: hr_utility.trace('l_estab_rec.g_5_ameri_male : ' || l_estab_rec.g_5_ameri_male);
4075: hr_utility.trace('l_estab_rec.h_5_tmraces_male : ' || l_estab_rec.h_5_tmraces_male);
4076: hr_utility.trace('l_estab_rec.o_5_total_cat : ' || l_estab_rec.o_5_total_cat);
4077:
4078: -- IF Hawaii

Line 4075: hr_utility.trace('l_estab_rec.h_5_tmraces_male : ' || l_estab_rec.h_5_tmraces_male);

4071: hr_utility.trace('l_estab_rec.d_5_black_male : ' || l_estab_rec.d_5_black_male);
4072: hr_utility.trace('l_estab_rec.e_5_latin_male : ' || l_estab_rec.e_5_latin_male);
4073: hr_utility.trace('l_estab_rec.f_5_aspac_male : ' || l_estab_rec.f_5_aspac_male);
4074: hr_utility.trace('l_estab_rec.g_5_ameri_male : ' || l_estab_rec.g_5_ameri_male);
4075: hr_utility.trace('l_estab_rec.h_5_tmraces_male : ' || l_estab_rec.h_5_tmraces_male);
4076: hr_utility.trace('l_estab_rec.o_5_total_cat : ' || l_estab_rec.o_5_total_cat);
4077:
4078: -- IF Hawaii
4079: /* IF l_estab_rec.state_8 = 'HI' THEN

Line 4076: hr_utility.trace('l_estab_rec.o_5_total_cat : ' || l_estab_rec.o_5_total_cat);

4072: hr_utility.trace('l_estab_rec.e_5_latin_male : ' || l_estab_rec.e_5_latin_male);
4073: hr_utility.trace('l_estab_rec.f_5_aspac_male : ' || l_estab_rec.f_5_aspac_male);
4074: hr_utility.trace('l_estab_rec.g_5_ameri_male : ' || l_estab_rec.g_5_ameri_male);
4075: hr_utility.trace('l_estab_rec.h_5_tmraces_male : ' || l_estab_rec.h_5_tmraces_male);
4076: hr_utility.trace('l_estab_rec.o_5_total_cat : ' || l_estab_rec.o_5_total_cat);
4077:
4078: -- IF Hawaii
4079: /* IF l_estab_rec.state_8 = 'HI' THEN
4080: l_estab_rec.c_5_white_male := (l_estab_rec.a_5_hl_male +

Line 4132: hr_utility.trace('l_estab_rec.a_6_hl_male : ' || l_estab_rec.a_6_hl_male);

4128: l_estab_rec.f_6_aspac_male +
4129: l_estab_rec.g_6_ameri_male +
4130: l_estab_rec.h_6_tmraces_male;
4131:
4132: hr_utility.trace('l_estab_rec.a_6_hl_male : ' || l_estab_rec.a_6_hl_male);
4133: hr_utility.trace('l_estab_rec.c_6_white_male : ' || l_estab_rec.c_6_white_male);
4134: hr_utility.trace('l_estab_rec.d_6_black_male : ' || l_estab_rec.d_6_black_male);
4135: hr_utility.trace('l_estab_rec.e_6_latin_male : ' || l_estab_rec.e_6_latin_male);
4136: hr_utility.trace('l_estab_rec.f_6_aspac_male : ' || l_estab_rec.f_6_aspac_male);

Line 4133: hr_utility.trace('l_estab_rec.c_6_white_male : ' || l_estab_rec.c_6_white_male);

4129: l_estab_rec.g_6_ameri_male +
4130: l_estab_rec.h_6_tmraces_male;
4131:
4132: hr_utility.trace('l_estab_rec.a_6_hl_male : ' || l_estab_rec.a_6_hl_male);
4133: hr_utility.trace('l_estab_rec.c_6_white_male : ' || l_estab_rec.c_6_white_male);
4134: hr_utility.trace('l_estab_rec.d_6_black_male : ' || l_estab_rec.d_6_black_male);
4135: hr_utility.trace('l_estab_rec.e_6_latin_male : ' || l_estab_rec.e_6_latin_male);
4136: hr_utility.trace('l_estab_rec.f_6_aspac_male : ' || l_estab_rec.f_6_aspac_male);
4137: hr_utility.trace('l_estab_rec.g_6_ameri_male : ' || l_estab_rec.g_6_ameri_male);

Line 4134: hr_utility.trace('l_estab_rec.d_6_black_male : ' || l_estab_rec.d_6_black_male);

4130: l_estab_rec.h_6_tmraces_male;
4131:
4132: hr_utility.trace('l_estab_rec.a_6_hl_male : ' || l_estab_rec.a_6_hl_male);
4133: hr_utility.trace('l_estab_rec.c_6_white_male : ' || l_estab_rec.c_6_white_male);
4134: hr_utility.trace('l_estab_rec.d_6_black_male : ' || l_estab_rec.d_6_black_male);
4135: hr_utility.trace('l_estab_rec.e_6_latin_male : ' || l_estab_rec.e_6_latin_male);
4136: hr_utility.trace('l_estab_rec.f_6_aspac_male : ' || l_estab_rec.f_6_aspac_male);
4137: hr_utility.trace('l_estab_rec.g_6_ameri_male : ' || l_estab_rec.g_6_ameri_male);
4138: hr_utility.trace('l_estab_rec.h_6_tmraces_male : ' || l_estab_rec.h_6_tmraces_male);

Line 4135: hr_utility.trace('l_estab_rec.e_6_latin_male : ' || l_estab_rec.e_6_latin_male);

4131:
4132: hr_utility.trace('l_estab_rec.a_6_hl_male : ' || l_estab_rec.a_6_hl_male);
4133: hr_utility.trace('l_estab_rec.c_6_white_male : ' || l_estab_rec.c_6_white_male);
4134: hr_utility.trace('l_estab_rec.d_6_black_male : ' || l_estab_rec.d_6_black_male);
4135: hr_utility.trace('l_estab_rec.e_6_latin_male : ' || l_estab_rec.e_6_latin_male);
4136: hr_utility.trace('l_estab_rec.f_6_aspac_male : ' || l_estab_rec.f_6_aspac_male);
4137: hr_utility.trace('l_estab_rec.g_6_ameri_male : ' || l_estab_rec.g_6_ameri_male);
4138: hr_utility.trace('l_estab_rec.h_6_tmraces_male : ' || l_estab_rec.h_6_tmraces_male);
4139: hr_utility.trace('l_estab_rec.o_6_total_cat : ' || l_estab_rec.o_6_total_cat);

Line 4136: hr_utility.trace('l_estab_rec.f_6_aspac_male : ' || l_estab_rec.f_6_aspac_male);

4132: hr_utility.trace('l_estab_rec.a_6_hl_male : ' || l_estab_rec.a_6_hl_male);
4133: hr_utility.trace('l_estab_rec.c_6_white_male : ' || l_estab_rec.c_6_white_male);
4134: hr_utility.trace('l_estab_rec.d_6_black_male : ' || l_estab_rec.d_6_black_male);
4135: hr_utility.trace('l_estab_rec.e_6_latin_male : ' || l_estab_rec.e_6_latin_male);
4136: hr_utility.trace('l_estab_rec.f_6_aspac_male : ' || l_estab_rec.f_6_aspac_male);
4137: hr_utility.trace('l_estab_rec.g_6_ameri_male : ' || l_estab_rec.g_6_ameri_male);
4138: hr_utility.trace('l_estab_rec.h_6_tmraces_male : ' || l_estab_rec.h_6_tmraces_male);
4139: hr_utility.trace('l_estab_rec.o_6_total_cat : ' || l_estab_rec.o_6_total_cat);
4140:

Line 4137: hr_utility.trace('l_estab_rec.g_6_ameri_male : ' || l_estab_rec.g_6_ameri_male);

4133: hr_utility.trace('l_estab_rec.c_6_white_male : ' || l_estab_rec.c_6_white_male);
4134: hr_utility.trace('l_estab_rec.d_6_black_male : ' || l_estab_rec.d_6_black_male);
4135: hr_utility.trace('l_estab_rec.e_6_latin_male : ' || l_estab_rec.e_6_latin_male);
4136: hr_utility.trace('l_estab_rec.f_6_aspac_male : ' || l_estab_rec.f_6_aspac_male);
4137: hr_utility.trace('l_estab_rec.g_6_ameri_male : ' || l_estab_rec.g_6_ameri_male);
4138: hr_utility.trace('l_estab_rec.h_6_tmraces_male : ' || l_estab_rec.h_6_tmraces_male);
4139: hr_utility.trace('l_estab_rec.o_6_total_cat : ' || l_estab_rec.o_6_total_cat);
4140:
4141: -- IF Hawaii

Line 4138: hr_utility.trace('l_estab_rec.h_6_tmraces_male : ' || l_estab_rec.h_6_tmraces_male);

4134: hr_utility.trace('l_estab_rec.d_6_black_male : ' || l_estab_rec.d_6_black_male);
4135: hr_utility.trace('l_estab_rec.e_6_latin_male : ' || l_estab_rec.e_6_latin_male);
4136: hr_utility.trace('l_estab_rec.f_6_aspac_male : ' || l_estab_rec.f_6_aspac_male);
4137: hr_utility.trace('l_estab_rec.g_6_ameri_male : ' || l_estab_rec.g_6_ameri_male);
4138: hr_utility.trace('l_estab_rec.h_6_tmraces_male : ' || l_estab_rec.h_6_tmraces_male);
4139: hr_utility.trace('l_estab_rec.o_6_total_cat : ' || l_estab_rec.o_6_total_cat);
4140:
4141: -- IF Hawaii
4142: /* IF l_estab_rec.state_8 = 'HI' THEN

Line 4139: hr_utility.trace('l_estab_rec.o_6_total_cat : ' || l_estab_rec.o_6_total_cat);

4135: hr_utility.trace('l_estab_rec.e_6_latin_male : ' || l_estab_rec.e_6_latin_male);
4136: hr_utility.trace('l_estab_rec.f_6_aspac_male : ' || l_estab_rec.f_6_aspac_male);
4137: hr_utility.trace('l_estab_rec.g_6_ameri_male : ' || l_estab_rec.g_6_ameri_male);
4138: hr_utility.trace('l_estab_rec.h_6_tmraces_male : ' || l_estab_rec.h_6_tmraces_male);
4139: hr_utility.trace('l_estab_rec.o_6_total_cat : ' || l_estab_rec.o_6_total_cat);
4140:
4141: -- IF Hawaii
4142: /* IF l_estab_rec.state_8 = 'HI' THEN
4143: l_estab_rec.c_6_white_male := (l_estab_rec.a_6_hl_male +

Line 4195: hr_utility.trace('l_estab_rec.a_7_hl_male : ' || l_estab_rec.a_7_hl_male);

4191: l_estab_rec.f_7_aspac_male +
4192: l_estab_rec.g_7_ameri_male +
4193: l_estab_rec.h_7_tmraces_male;
4194:
4195: hr_utility.trace('l_estab_rec.a_7_hl_male : ' || l_estab_rec.a_7_hl_male);
4196: hr_utility.trace('l_estab_rec.c_7_white_male : ' || l_estab_rec.c_7_white_male);
4197: hr_utility.trace('l_estab_rec.d_7_black_male : ' || l_estab_rec.d_7_black_male);
4198: hr_utility.trace('l_estab_rec.e_7_latin_male : ' || l_estab_rec.e_7_latin_male);
4199: hr_utility.trace('l_estab_rec.f_7_aspac_male : ' || l_estab_rec.f_7_aspac_male);

Line 4196: hr_utility.trace('l_estab_rec.c_7_white_male : ' || l_estab_rec.c_7_white_male);

4192: l_estab_rec.g_7_ameri_male +
4193: l_estab_rec.h_7_tmraces_male;
4194:
4195: hr_utility.trace('l_estab_rec.a_7_hl_male : ' || l_estab_rec.a_7_hl_male);
4196: hr_utility.trace('l_estab_rec.c_7_white_male : ' || l_estab_rec.c_7_white_male);
4197: hr_utility.trace('l_estab_rec.d_7_black_male : ' || l_estab_rec.d_7_black_male);
4198: hr_utility.trace('l_estab_rec.e_7_latin_male : ' || l_estab_rec.e_7_latin_male);
4199: hr_utility.trace('l_estab_rec.f_7_aspac_male : ' || l_estab_rec.f_7_aspac_male);
4200: hr_utility.trace('l_estab_rec.g_7_ameri_male : ' || l_estab_rec.g_7_ameri_male);

Line 4197: hr_utility.trace('l_estab_rec.d_7_black_male : ' || l_estab_rec.d_7_black_male);

4193: l_estab_rec.h_7_tmraces_male;
4194:
4195: hr_utility.trace('l_estab_rec.a_7_hl_male : ' || l_estab_rec.a_7_hl_male);
4196: hr_utility.trace('l_estab_rec.c_7_white_male : ' || l_estab_rec.c_7_white_male);
4197: hr_utility.trace('l_estab_rec.d_7_black_male : ' || l_estab_rec.d_7_black_male);
4198: hr_utility.trace('l_estab_rec.e_7_latin_male : ' || l_estab_rec.e_7_latin_male);
4199: hr_utility.trace('l_estab_rec.f_7_aspac_male : ' || l_estab_rec.f_7_aspac_male);
4200: hr_utility.trace('l_estab_rec.g_7_ameri_male : ' || l_estab_rec.g_7_ameri_male);
4201: hr_utility.trace('l_estab_rec.h_7_tmraces_male : ' || l_estab_rec.h_7_tmraces_male);

Line 4198: hr_utility.trace('l_estab_rec.e_7_latin_male : ' || l_estab_rec.e_7_latin_male);

4194:
4195: hr_utility.trace('l_estab_rec.a_7_hl_male : ' || l_estab_rec.a_7_hl_male);
4196: hr_utility.trace('l_estab_rec.c_7_white_male : ' || l_estab_rec.c_7_white_male);
4197: hr_utility.trace('l_estab_rec.d_7_black_male : ' || l_estab_rec.d_7_black_male);
4198: hr_utility.trace('l_estab_rec.e_7_latin_male : ' || l_estab_rec.e_7_latin_male);
4199: hr_utility.trace('l_estab_rec.f_7_aspac_male : ' || l_estab_rec.f_7_aspac_male);
4200: hr_utility.trace('l_estab_rec.g_7_ameri_male : ' || l_estab_rec.g_7_ameri_male);
4201: hr_utility.trace('l_estab_rec.h_7_tmraces_male : ' || l_estab_rec.h_7_tmraces_male);
4202: hr_utility.trace('l_estab_rec.o_7_total_cat : ' || l_estab_rec.o_7_total_cat);

Line 4199: hr_utility.trace('l_estab_rec.f_7_aspac_male : ' || l_estab_rec.f_7_aspac_male);

4195: hr_utility.trace('l_estab_rec.a_7_hl_male : ' || l_estab_rec.a_7_hl_male);
4196: hr_utility.trace('l_estab_rec.c_7_white_male : ' || l_estab_rec.c_7_white_male);
4197: hr_utility.trace('l_estab_rec.d_7_black_male : ' || l_estab_rec.d_7_black_male);
4198: hr_utility.trace('l_estab_rec.e_7_latin_male : ' || l_estab_rec.e_7_latin_male);
4199: hr_utility.trace('l_estab_rec.f_7_aspac_male : ' || l_estab_rec.f_7_aspac_male);
4200: hr_utility.trace('l_estab_rec.g_7_ameri_male : ' || l_estab_rec.g_7_ameri_male);
4201: hr_utility.trace('l_estab_rec.h_7_tmraces_male : ' || l_estab_rec.h_7_tmraces_male);
4202: hr_utility.trace('l_estab_rec.o_7_total_cat : ' || l_estab_rec.o_7_total_cat);
4203:

Line 4200: hr_utility.trace('l_estab_rec.g_7_ameri_male : ' || l_estab_rec.g_7_ameri_male);

4196: hr_utility.trace('l_estab_rec.c_7_white_male : ' || l_estab_rec.c_7_white_male);
4197: hr_utility.trace('l_estab_rec.d_7_black_male : ' || l_estab_rec.d_7_black_male);
4198: hr_utility.trace('l_estab_rec.e_7_latin_male : ' || l_estab_rec.e_7_latin_male);
4199: hr_utility.trace('l_estab_rec.f_7_aspac_male : ' || l_estab_rec.f_7_aspac_male);
4200: hr_utility.trace('l_estab_rec.g_7_ameri_male : ' || l_estab_rec.g_7_ameri_male);
4201: hr_utility.trace('l_estab_rec.h_7_tmraces_male : ' || l_estab_rec.h_7_tmraces_male);
4202: hr_utility.trace('l_estab_rec.o_7_total_cat : ' || l_estab_rec.o_7_total_cat);
4203:
4204: -- IF Hawaii

Line 4201: hr_utility.trace('l_estab_rec.h_7_tmraces_male : ' || l_estab_rec.h_7_tmraces_male);

4197: hr_utility.trace('l_estab_rec.d_7_black_male : ' || l_estab_rec.d_7_black_male);
4198: hr_utility.trace('l_estab_rec.e_7_latin_male : ' || l_estab_rec.e_7_latin_male);
4199: hr_utility.trace('l_estab_rec.f_7_aspac_male : ' || l_estab_rec.f_7_aspac_male);
4200: hr_utility.trace('l_estab_rec.g_7_ameri_male : ' || l_estab_rec.g_7_ameri_male);
4201: hr_utility.trace('l_estab_rec.h_7_tmraces_male : ' || l_estab_rec.h_7_tmraces_male);
4202: hr_utility.trace('l_estab_rec.o_7_total_cat : ' || l_estab_rec.o_7_total_cat);
4203:
4204: -- IF Hawaii
4205: /* IF l_estab_rec.state_8 = 'HI' THEN

Line 4202: hr_utility.trace('l_estab_rec.o_7_total_cat : ' || l_estab_rec.o_7_total_cat);

4198: hr_utility.trace('l_estab_rec.e_7_latin_male : ' || l_estab_rec.e_7_latin_male);
4199: hr_utility.trace('l_estab_rec.f_7_aspac_male : ' || l_estab_rec.f_7_aspac_male);
4200: hr_utility.trace('l_estab_rec.g_7_ameri_male : ' || l_estab_rec.g_7_ameri_male);
4201: hr_utility.trace('l_estab_rec.h_7_tmraces_male : ' || l_estab_rec.h_7_tmraces_male);
4202: hr_utility.trace('l_estab_rec.o_7_total_cat : ' || l_estab_rec.o_7_total_cat);
4203:
4204: -- IF Hawaii
4205: /* IF l_estab_rec.state_8 = 'HI' THEN
4206: l_estab_rec.c_7_white_male := (l_estab_rec.a_7_hl_male +

Line 4258: hr_utility.trace('l_estab_rec.a_8_hl_male : ' || l_estab_rec.a_8_hl_male);

4254: l_estab_rec.f_8_aspac_male +
4255: l_estab_rec.g_8_ameri_male +
4256: l_estab_rec.h_8_tmraces_male;
4257:
4258: hr_utility.trace('l_estab_rec.a_8_hl_male : ' || l_estab_rec.a_8_hl_male);
4259: hr_utility.trace('l_estab_rec.c_8_white_male : ' || l_estab_rec.c_8_white_male);
4260: hr_utility.trace('l_estab_rec.d_8_black_male : ' || l_estab_rec.d_8_black_male);
4261: hr_utility.trace('l_estab_rec.e_8_latin_male : ' || l_estab_rec.e_8_latin_male);
4262: hr_utility.trace('l_estab_rec.f_8_aspac_male : ' || l_estab_rec.f_8_aspac_male);

Line 4259: hr_utility.trace('l_estab_rec.c_8_white_male : ' || l_estab_rec.c_8_white_male);

4255: l_estab_rec.g_8_ameri_male +
4256: l_estab_rec.h_8_tmraces_male;
4257:
4258: hr_utility.trace('l_estab_rec.a_8_hl_male : ' || l_estab_rec.a_8_hl_male);
4259: hr_utility.trace('l_estab_rec.c_8_white_male : ' || l_estab_rec.c_8_white_male);
4260: hr_utility.trace('l_estab_rec.d_8_black_male : ' || l_estab_rec.d_8_black_male);
4261: hr_utility.trace('l_estab_rec.e_8_latin_male : ' || l_estab_rec.e_8_latin_male);
4262: hr_utility.trace('l_estab_rec.f_8_aspac_male : ' || l_estab_rec.f_8_aspac_male);
4263: hr_utility.trace('l_estab_rec.g_8_ameri_male : ' || l_estab_rec.g_8_ameri_male);

Line 4260: hr_utility.trace('l_estab_rec.d_8_black_male : ' || l_estab_rec.d_8_black_male);

4256: l_estab_rec.h_8_tmraces_male;
4257:
4258: hr_utility.trace('l_estab_rec.a_8_hl_male : ' || l_estab_rec.a_8_hl_male);
4259: hr_utility.trace('l_estab_rec.c_8_white_male : ' || l_estab_rec.c_8_white_male);
4260: hr_utility.trace('l_estab_rec.d_8_black_male : ' || l_estab_rec.d_8_black_male);
4261: hr_utility.trace('l_estab_rec.e_8_latin_male : ' || l_estab_rec.e_8_latin_male);
4262: hr_utility.trace('l_estab_rec.f_8_aspac_male : ' || l_estab_rec.f_8_aspac_male);
4263: hr_utility.trace('l_estab_rec.g_8_ameri_male : ' || l_estab_rec.g_8_ameri_male);
4264: hr_utility.trace('l_estab_rec.h_8_tmraces_male : ' || l_estab_rec.h_8_tmraces_male);

Line 4261: hr_utility.trace('l_estab_rec.e_8_latin_male : ' || l_estab_rec.e_8_latin_male);

4257:
4258: hr_utility.trace('l_estab_rec.a_8_hl_male : ' || l_estab_rec.a_8_hl_male);
4259: hr_utility.trace('l_estab_rec.c_8_white_male : ' || l_estab_rec.c_8_white_male);
4260: hr_utility.trace('l_estab_rec.d_8_black_male : ' || l_estab_rec.d_8_black_male);
4261: hr_utility.trace('l_estab_rec.e_8_latin_male : ' || l_estab_rec.e_8_latin_male);
4262: hr_utility.trace('l_estab_rec.f_8_aspac_male : ' || l_estab_rec.f_8_aspac_male);
4263: hr_utility.trace('l_estab_rec.g_8_ameri_male : ' || l_estab_rec.g_8_ameri_male);
4264: hr_utility.trace('l_estab_rec.h_8_tmraces_male : ' || l_estab_rec.h_8_tmraces_male);
4265: hr_utility.trace('l_estab_rec.o_8_total_cat : ' || l_estab_rec.o_8_total_cat);

Line 4262: hr_utility.trace('l_estab_rec.f_8_aspac_male : ' || l_estab_rec.f_8_aspac_male);

4258: hr_utility.trace('l_estab_rec.a_8_hl_male : ' || l_estab_rec.a_8_hl_male);
4259: hr_utility.trace('l_estab_rec.c_8_white_male : ' || l_estab_rec.c_8_white_male);
4260: hr_utility.trace('l_estab_rec.d_8_black_male : ' || l_estab_rec.d_8_black_male);
4261: hr_utility.trace('l_estab_rec.e_8_latin_male : ' || l_estab_rec.e_8_latin_male);
4262: hr_utility.trace('l_estab_rec.f_8_aspac_male : ' || l_estab_rec.f_8_aspac_male);
4263: hr_utility.trace('l_estab_rec.g_8_ameri_male : ' || l_estab_rec.g_8_ameri_male);
4264: hr_utility.trace('l_estab_rec.h_8_tmraces_male : ' || l_estab_rec.h_8_tmraces_male);
4265: hr_utility.trace('l_estab_rec.o_8_total_cat : ' || l_estab_rec.o_8_total_cat);
4266:

Line 4263: hr_utility.trace('l_estab_rec.g_8_ameri_male : ' || l_estab_rec.g_8_ameri_male);

4259: hr_utility.trace('l_estab_rec.c_8_white_male : ' || l_estab_rec.c_8_white_male);
4260: hr_utility.trace('l_estab_rec.d_8_black_male : ' || l_estab_rec.d_8_black_male);
4261: hr_utility.trace('l_estab_rec.e_8_latin_male : ' || l_estab_rec.e_8_latin_male);
4262: hr_utility.trace('l_estab_rec.f_8_aspac_male : ' || l_estab_rec.f_8_aspac_male);
4263: hr_utility.trace('l_estab_rec.g_8_ameri_male : ' || l_estab_rec.g_8_ameri_male);
4264: hr_utility.trace('l_estab_rec.h_8_tmraces_male : ' || l_estab_rec.h_8_tmraces_male);
4265: hr_utility.trace('l_estab_rec.o_8_total_cat : ' || l_estab_rec.o_8_total_cat);
4266:
4267: -- IF Hawaii

Line 4264: hr_utility.trace('l_estab_rec.h_8_tmraces_male : ' || l_estab_rec.h_8_tmraces_male);

4260: hr_utility.trace('l_estab_rec.d_8_black_male : ' || l_estab_rec.d_8_black_male);
4261: hr_utility.trace('l_estab_rec.e_8_latin_male : ' || l_estab_rec.e_8_latin_male);
4262: hr_utility.trace('l_estab_rec.f_8_aspac_male : ' || l_estab_rec.f_8_aspac_male);
4263: hr_utility.trace('l_estab_rec.g_8_ameri_male : ' || l_estab_rec.g_8_ameri_male);
4264: hr_utility.trace('l_estab_rec.h_8_tmraces_male : ' || l_estab_rec.h_8_tmraces_male);
4265: hr_utility.trace('l_estab_rec.o_8_total_cat : ' || l_estab_rec.o_8_total_cat);
4266:
4267: -- IF Hawaii
4268: /* IF l_estab_rec.state_8 = 'HI' THEN

Line 4265: hr_utility.trace('l_estab_rec.o_8_total_cat : ' || l_estab_rec.o_8_total_cat);

4261: hr_utility.trace('l_estab_rec.e_8_latin_male : ' || l_estab_rec.e_8_latin_male);
4262: hr_utility.trace('l_estab_rec.f_8_aspac_male : ' || l_estab_rec.f_8_aspac_male);
4263: hr_utility.trace('l_estab_rec.g_8_ameri_male : ' || l_estab_rec.g_8_ameri_male);
4264: hr_utility.trace('l_estab_rec.h_8_tmraces_male : ' || l_estab_rec.h_8_tmraces_male);
4265: hr_utility.trace('l_estab_rec.o_8_total_cat : ' || l_estab_rec.o_8_total_cat);
4266:
4267: -- IF Hawaii
4268: /* IF l_estab_rec.state_8 = 'HI' THEN
4269: l_estab_rec.c_8_white_male := (l_estab_rec.a_8_hl_male +

Line 4320: hr_utility.trace('l_estab_rec.a_9_hl_male : ' || l_estab_rec.a_9_hl_male);

4316: l_estab_rec.f_9_aspac_male +
4317: l_estab_rec.g_9_ameri_male +
4318: l_estab_rec.h_9_tmraces_male;
4319:
4320: hr_utility.trace('l_estab_rec.a_9_hl_male : ' || l_estab_rec.a_9_hl_male);
4321: hr_utility.trace('l_estab_rec.c_9_white_male : ' || l_estab_rec.c_9_white_male);
4322: hr_utility.trace('l_estab_rec.d_9_black_male : ' || l_estab_rec.d_9_black_male);
4323: hr_utility.trace('l_estab_rec.e_9_latin_male : ' || l_estab_rec.e_9_latin_male);
4324: hr_utility.trace('l_estab_rec.f_9_aspac_male : ' || l_estab_rec.f_9_aspac_male);

Line 4321: hr_utility.trace('l_estab_rec.c_9_white_male : ' || l_estab_rec.c_9_white_male);

4317: l_estab_rec.g_9_ameri_male +
4318: l_estab_rec.h_9_tmraces_male;
4319:
4320: hr_utility.trace('l_estab_rec.a_9_hl_male : ' || l_estab_rec.a_9_hl_male);
4321: hr_utility.trace('l_estab_rec.c_9_white_male : ' || l_estab_rec.c_9_white_male);
4322: hr_utility.trace('l_estab_rec.d_9_black_male : ' || l_estab_rec.d_9_black_male);
4323: hr_utility.trace('l_estab_rec.e_9_latin_male : ' || l_estab_rec.e_9_latin_male);
4324: hr_utility.trace('l_estab_rec.f_9_aspac_male : ' || l_estab_rec.f_9_aspac_male);
4325: hr_utility.trace('l_estab_rec.g_9_ameri_male : ' || l_estab_rec.g_9_ameri_male);

Line 4322: hr_utility.trace('l_estab_rec.d_9_black_male : ' || l_estab_rec.d_9_black_male);

4318: l_estab_rec.h_9_tmraces_male;
4319:
4320: hr_utility.trace('l_estab_rec.a_9_hl_male : ' || l_estab_rec.a_9_hl_male);
4321: hr_utility.trace('l_estab_rec.c_9_white_male : ' || l_estab_rec.c_9_white_male);
4322: hr_utility.trace('l_estab_rec.d_9_black_male : ' || l_estab_rec.d_9_black_male);
4323: hr_utility.trace('l_estab_rec.e_9_latin_male : ' || l_estab_rec.e_9_latin_male);
4324: hr_utility.trace('l_estab_rec.f_9_aspac_male : ' || l_estab_rec.f_9_aspac_male);
4325: hr_utility.trace('l_estab_rec.g_9_ameri_male : ' || l_estab_rec.g_9_ameri_male);
4326: hr_utility.trace('l_estab_rec.h_9_tmraces_male : ' || l_estab_rec.h_9_tmraces_male);

Line 4323: hr_utility.trace('l_estab_rec.e_9_latin_male : ' || l_estab_rec.e_9_latin_male);

4319:
4320: hr_utility.trace('l_estab_rec.a_9_hl_male : ' || l_estab_rec.a_9_hl_male);
4321: hr_utility.trace('l_estab_rec.c_9_white_male : ' || l_estab_rec.c_9_white_male);
4322: hr_utility.trace('l_estab_rec.d_9_black_male : ' || l_estab_rec.d_9_black_male);
4323: hr_utility.trace('l_estab_rec.e_9_latin_male : ' || l_estab_rec.e_9_latin_male);
4324: hr_utility.trace('l_estab_rec.f_9_aspac_male : ' || l_estab_rec.f_9_aspac_male);
4325: hr_utility.trace('l_estab_rec.g_9_ameri_male : ' || l_estab_rec.g_9_ameri_male);
4326: hr_utility.trace('l_estab_rec.h_9_tmraces_male : ' || l_estab_rec.h_9_tmraces_male);
4327: hr_utility.trace('l_estab_rec.o_9_total_cat : ' || l_estab_rec.o_9_total_cat);

Line 4324: hr_utility.trace('l_estab_rec.f_9_aspac_male : ' || l_estab_rec.f_9_aspac_male);

4320: hr_utility.trace('l_estab_rec.a_9_hl_male : ' || l_estab_rec.a_9_hl_male);
4321: hr_utility.trace('l_estab_rec.c_9_white_male : ' || l_estab_rec.c_9_white_male);
4322: hr_utility.trace('l_estab_rec.d_9_black_male : ' || l_estab_rec.d_9_black_male);
4323: hr_utility.trace('l_estab_rec.e_9_latin_male : ' || l_estab_rec.e_9_latin_male);
4324: hr_utility.trace('l_estab_rec.f_9_aspac_male : ' || l_estab_rec.f_9_aspac_male);
4325: hr_utility.trace('l_estab_rec.g_9_ameri_male : ' || l_estab_rec.g_9_ameri_male);
4326: hr_utility.trace('l_estab_rec.h_9_tmraces_male : ' || l_estab_rec.h_9_tmraces_male);
4327: hr_utility.trace('l_estab_rec.o_9_total_cat : ' || l_estab_rec.o_9_total_cat);
4328:

Line 4325: hr_utility.trace('l_estab_rec.g_9_ameri_male : ' || l_estab_rec.g_9_ameri_male);

4321: hr_utility.trace('l_estab_rec.c_9_white_male : ' || l_estab_rec.c_9_white_male);
4322: hr_utility.trace('l_estab_rec.d_9_black_male : ' || l_estab_rec.d_9_black_male);
4323: hr_utility.trace('l_estab_rec.e_9_latin_male : ' || l_estab_rec.e_9_latin_male);
4324: hr_utility.trace('l_estab_rec.f_9_aspac_male : ' || l_estab_rec.f_9_aspac_male);
4325: hr_utility.trace('l_estab_rec.g_9_ameri_male : ' || l_estab_rec.g_9_ameri_male);
4326: hr_utility.trace('l_estab_rec.h_9_tmraces_male : ' || l_estab_rec.h_9_tmraces_male);
4327: hr_utility.trace('l_estab_rec.o_9_total_cat : ' || l_estab_rec.o_9_total_cat);
4328:
4329: -- IF Hawaii

Line 4326: hr_utility.trace('l_estab_rec.h_9_tmraces_male : ' || l_estab_rec.h_9_tmraces_male);

4322: hr_utility.trace('l_estab_rec.d_9_black_male : ' || l_estab_rec.d_9_black_male);
4323: hr_utility.trace('l_estab_rec.e_9_latin_male : ' || l_estab_rec.e_9_latin_male);
4324: hr_utility.trace('l_estab_rec.f_9_aspac_male : ' || l_estab_rec.f_9_aspac_male);
4325: hr_utility.trace('l_estab_rec.g_9_ameri_male : ' || l_estab_rec.g_9_ameri_male);
4326: hr_utility.trace('l_estab_rec.h_9_tmraces_male : ' || l_estab_rec.h_9_tmraces_male);
4327: hr_utility.trace('l_estab_rec.o_9_total_cat : ' || l_estab_rec.o_9_total_cat);
4328:
4329: -- IF Hawaii
4330: /* IF l_estab_rec.state_8 = 'HI' THEN

Line 4327: hr_utility.trace('l_estab_rec.o_9_total_cat : ' || l_estab_rec.o_9_total_cat);

4323: hr_utility.trace('l_estab_rec.e_9_latin_male : ' || l_estab_rec.e_9_latin_male);
4324: hr_utility.trace('l_estab_rec.f_9_aspac_male : ' || l_estab_rec.f_9_aspac_male);
4325: hr_utility.trace('l_estab_rec.g_9_ameri_male : ' || l_estab_rec.g_9_ameri_male);
4326: hr_utility.trace('l_estab_rec.h_9_tmraces_male : ' || l_estab_rec.h_9_tmraces_male);
4327: hr_utility.trace('l_estab_rec.o_9_total_cat : ' || l_estab_rec.o_9_total_cat);
4328:
4329: -- IF Hawaii
4330: /* IF l_estab_rec.state_8 = 'HI' THEN
4331: l_estab_rec.c_9_white_male := (l_estab_rec.a_9_hl_male +

Line 4382: hr_utility.trace('l_estab_rec.a_10_hl_male : ' || l_estab_rec.a_10_hl_male);

4378: l_estab_rec.f_10_aspac_male +
4379: l_estab_rec.g_10_ameri_male +
4380: l_estab_rec.h_10_tmraces_male;
4381:
4382: hr_utility.trace('l_estab_rec.a_10_hl_male : ' || l_estab_rec.a_10_hl_male);
4383: hr_utility.trace('l_estab_rec.c_10_white_male : ' || l_estab_rec.c_10_white_male);
4384: hr_utility.trace('l_estab_rec.d_10_black_male : ' || l_estab_rec.d_10_black_male);
4385: hr_utility.trace('l_estab_rec.e_10_latin_male : ' || l_estab_rec.e_10_latin_male);
4386: hr_utility.trace('l_estab_rec.f_10_aspac_male : ' || l_estab_rec.f_10_aspac_male);

Line 4383: hr_utility.trace('l_estab_rec.c_10_white_male : ' || l_estab_rec.c_10_white_male);

4379: l_estab_rec.g_10_ameri_male +
4380: l_estab_rec.h_10_tmraces_male;
4381:
4382: hr_utility.trace('l_estab_rec.a_10_hl_male : ' || l_estab_rec.a_10_hl_male);
4383: hr_utility.trace('l_estab_rec.c_10_white_male : ' || l_estab_rec.c_10_white_male);
4384: hr_utility.trace('l_estab_rec.d_10_black_male : ' || l_estab_rec.d_10_black_male);
4385: hr_utility.trace('l_estab_rec.e_10_latin_male : ' || l_estab_rec.e_10_latin_male);
4386: hr_utility.trace('l_estab_rec.f_10_aspac_male : ' || l_estab_rec.f_10_aspac_male);
4387: hr_utility.trace('l_estab_rec.g_10_ameri_male : ' || l_estab_rec.g_10_ameri_male);

Line 4384: hr_utility.trace('l_estab_rec.d_10_black_male : ' || l_estab_rec.d_10_black_male);

4380: l_estab_rec.h_10_tmraces_male;
4381:
4382: hr_utility.trace('l_estab_rec.a_10_hl_male : ' || l_estab_rec.a_10_hl_male);
4383: hr_utility.trace('l_estab_rec.c_10_white_male : ' || l_estab_rec.c_10_white_male);
4384: hr_utility.trace('l_estab_rec.d_10_black_male : ' || l_estab_rec.d_10_black_male);
4385: hr_utility.trace('l_estab_rec.e_10_latin_male : ' || l_estab_rec.e_10_latin_male);
4386: hr_utility.trace('l_estab_rec.f_10_aspac_male : ' || l_estab_rec.f_10_aspac_male);
4387: hr_utility.trace('l_estab_rec.g_10_ameri_male : ' || l_estab_rec.g_10_ameri_male);
4388: hr_utility.trace('l_estab_rec.h_10_tmraces_male : ' || l_estab_rec.h_10_tmraces_male);

Line 4385: hr_utility.trace('l_estab_rec.e_10_latin_male : ' || l_estab_rec.e_10_latin_male);

4381:
4382: hr_utility.trace('l_estab_rec.a_10_hl_male : ' || l_estab_rec.a_10_hl_male);
4383: hr_utility.trace('l_estab_rec.c_10_white_male : ' || l_estab_rec.c_10_white_male);
4384: hr_utility.trace('l_estab_rec.d_10_black_male : ' || l_estab_rec.d_10_black_male);
4385: hr_utility.trace('l_estab_rec.e_10_latin_male : ' || l_estab_rec.e_10_latin_male);
4386: hr_utility.trace('l_estab_rec.f_10_aspac_male : ' || l_estab_rec.f_10_aspac_male);
4387: hr_utility.trace('l_estab_rec.g_10_ameri_male : ' || l_estab_rec.g_10_ameri_male);
4388: hr_utility.trace('l_estab_rec.h_10_tmraces_male : ' || l_estab_rec.h_10_tmraces_male);
4389: hr_utility.trace('l_estab_rec.o_10_total_cat : ' || l_estab_rec.o_10_total_cat);

Line 4386: hr_utility.trace('l_estab_rec.f_10_aspac_male : ' || l_estab_rec.f_10_aspac_male);

4382: hr_utility.trace('l_estab_rec.a_10_hl_male : ' || l_estab_rec.a_10_hl_male);
4383: hr_utility.trace('l_estab_rec.c_10_white_male : ' || l_estab_rec.c_10_white_male);
4384: hr_utility.trace('l_estab_rec.d_10_black_male : ' || l_estab_rec.d_10_black_male);
4385: hr_utility.trace('l_estab_rec.e_10_latin_male : ' || l_estab_rec.e_10_latin_male);
4386: hr_utility.trace('l_estab_rec.f_10_aspac_male : ' || l_estab_rec.f_10_aspac_male);
4387: hr_utility.trace('l_estab_rec.g_10_ameri_male : ' || l_estab_rec.g_10_ameri_male);
4388: hr_utility.trace('l_estab_rec.h_10_tmraces_male : ' || l_estab_rec.h_10_tmraces_male);
4389: hr_utility.trace('l_estab_rec.o_10_total_cat : ' || l_estab_rec.o_10_total_cat);
4390:

Line 4387: hr_utility.trace('l_estab_rec.g_10_ameri_male : ' || l_estab_rec.g_10_ameri_male);

4383: hr_utility.trace('l_estab_rec.c_10_white_male : ' || l_estab_rec.c_10_white_male);
4384: hr_utility.trace('l_estab_rec.d_10_black_male : ' || l_estab_rec.d_10_black_male);
4385: hr_utility.trace('l_estab_rec.e_10_latin_male : ' || l_estab_rec.e_10_latin_male);
4386: hr_utility.trace('l_estab_rec.f_10_aspac_male : ' || l_estab_rec.f_10_aspac_male);
4387: hr_utility.trace('l_estab_rec.g_10_ameri_male : ' || l_estab_rec.g_10_ameri_male);
4388: hr_utility.trace('l_estab_rec.h_10_tmraces_male : ' || l_estab_rec.h_10_tmraces_male);
4389: hr_utility.trace('l_estab_rec.o_10_total_cat : ' || l_estab_rec.o_10_total_cat);
4390:
4391: -- IF Hawaii

Line 4388: hr_utility.trace('l_estab_rec.h_10_tmraces_male : ' || l_estab_rec.h_10_tmraces_male);

4384: hr_utility.trace('l_estab_rec.d_10_black_male : ' || l_estab_rec.d_10_black_male);
4385: hr_utility.trace('l_estab_rec.e_10_latin_male : ' || l_estab_rec.e_10_latin_male);
4386: hr_utility.trace('l_estab_rec.f_10_aspac_male : ' || l_estab_rec.f_10_aspac_male);
4387: hr_utility.trace('l_estab_rec.g_10_ameri_male : ' || l_estab_rec.g_10_ameri_male);
4388: hr_utility.trace('l_estab_rec.h_10_tmraces_male : ' || l_estab_rec.h_10_tmraces_male);
4389: hr_utility.trace('l_estab_rec.o_10_total_cat : ' || l_estab_rec.o_10_total_cat);
4390:
4391: -- IF Hawaii
4392: /* IF l_estab_rec.state_8 = 'HI' THEN

Line 4389: hr_utility.trace('l_estab_rec.o_10_total_cat : ' || l_estab_rec.o_10_total_cat);

4385: hr_utility.trace('l_estab_rec.e_10_latin_male : ' || l_estab_rec.e_10_latin_male);
4386: hr_utility.trace('l_estab_rec.f_10_aspac_male : ' || l_estab_rec.f_10_aspac_male);
4387: hr_utility.trace('l_estab_rec.g_10_ameri_male : ' || l_estab_rec.g_10_ameri_male);
4388: hr_utility.trace('l_estab_rec.h_10_tmraces_male : ' || l_estab_rec.h_10_tmraces_male);
4389: hr_utility.trace('l_estab_rec.o_10_total_cat : ' || l_estab_rec.o_10_total_cat);
4390:
4391: -- IF Hawaii
4392: /* IF l_estab_rec.state_8 = 'HI' THEN
4393: l_estab_rec.c_10_white_male := (l_estab_rec.a_10_hl_male +

Line 4428: hr_utility.set_location(l_proc,40);

4424: END LOOP;
4425:
4426: CLOSE c_male_details;
4427: /*
4428: hr_utility.set_location(l_proc,40);
4429: OPEN c_lastyears_details;
4430: LOOP
4431: FETCH c_lastyears_details INTO l_c_lastyears_details;
4432: EXIT WHEN c_lastyears_details%NOTFOUND;

Line 4498: hr_utility.set_location(l_proc,50);

4494: END loop;
4495:
4496: CLOSE c_lastyears_details; */
4497:
4498: hr_utility.set_location(l_proc,50);
4499:
4500: write_establishment_record;
4501:
4502:

Line 4518: hr_utility.set_location(l_proc,60);

4514: END LOOP; -- C_estab_details
4515:
4516: CLOSE c_estab_details;
4517: --
4518: hr_utility.set_location(l_proc,60);
4519:
4520: write_consolidated_record;
4521:
4522: IF p_report_mode = 'F'

Line 4531: hr_utility.set_location('Leaving..' ||l_proc,100);

4527: p_business_group_id => p_business_group_id,
4528: p_report_year => l_report_year);
4529: END IF;
4530:
4531: hr_utility.set_location('Leaving..' ||l_proc,100);
4532:
4533: END loop_through_establishments;
4534:
4535:

Line 4562: --hr_utility.trace_on(NULL,'ORACLE');

4558:
4559: l_count NUMBER;
4560:
4561: BEGIN
4562: --hr_utility.trace_on(NULL,'ORACLE');
4563: hr_utility.set_location('Entering..'||l_proc,10);
4564:
4565: g_message_text := 'EEO1 Entering...'||l_proc||' 10';
4566: fnd_file.put_line(which => fnd_file.log,buff => g_message_text);

Line 4563: hr_utility.set_location('Entering..'||l_proc,10);

4559: l_count NUMBER;
4560:
4561: BEGIN
4562: --hr_utility.trace_on(NULL,'ORACLE');
4563: hr_utility.set_location('Entering..'||l_proc,10);
4564:
4565: g_message_text := 'EEO1 Entering...'||l_proc||' 10';
4566: fnd_file.put_line(which => fnd_file.log,buff => g_message_text);
4567: