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_ZA_EMPLOYMENT_EQUITY_PKG dependencies on HR_UTILITY

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

183: l_proc constant varchar2(60) := g_package || 'reset_high_low_lists';
184:
185: begin
186:
187: hr_utility.set_location('Entering ' || l_proc, 10);
188:
189: g_high1 := 0;
190: g_high2 := 0;
191: g_high3 := 0;

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

280: l_proc constant varchar2(60) := g_package || 'get_highest_and_lowest';
281:
282: begin
283:
284: hr_utility.set_location('Entering ' || l_proc, 10);
285: hr_utility.set_location('p_value ' || to_char(p_value), 20);
286:
287: -- Ignore the value if it is zero
288: if p_value <> 0 then

Line 285: hr_utility.set_location('p_value ' || to_char(p_value), 20);

281:
282: begin
283:
284: hr_utility.set_location('Entering ' || l_proc, 10);
285: hr_utility.set_location('p_value ' || to_char(p_value), 20);
286:
287: -- Ignore the value if it is zero
288: if p_value <> 0 then
289:

Line 339: hr_utility.set_location('g_high1 ' || to_char(g_high1), 40);

335: end if;
336:
337: end if;
338:
339: hr_utility.set_location('g_high1 ' || to_char(g_high1), 40);
340: hr_utility.set_location('g_high2 ' || to_char(g_high2), 50);
341: hr_utility.set_location('g_high3 ' || to_char(g_high3), 60);
342: hr_utility.set_location('g_high4 ' || to_char(g_high4), 70);
343: hr_utility.set_location('g_high5 ' || to_char(g_high5), 80);

Line 340: hr_utility.set_location('g_high2 ' || to_char(g_high2), 50);

336:
337: end if;
338:
339: hr_utility.set_location('g_high1 ' || to_char(g_high1), 40);
340: hr_utility.set_location('g_high2 ' || to_char(g_high2), 50);
341: hr_utility.set_location('g_high3 ' || to_char(g_high3), 60);
342: hr_utility.set_location('g_high4 ' || to_char(g_high4), 70);
343: hr_utility.set_location('g_high5 ' || to_char(g_high5), 80);
344:

Line 341: hr_utility.set_location('g_high3 ' || to_char(g_high3), 60);

337: end if;
338:
339: hr_utility.set_location('g_high1 ' || to_char(g_high1), 40);
340: hr_utility.set_location('g_high2 ' || to_char(g_high2), 50);
341: hr_utility.set_location('g_high3 ' || to_char(g_high3), 60);
342: hr_utility.set_location('g_high4 ' || to_char(g_high4), 70);
343: hr_utility.set_location('g_high5 ' || to_char(g_high5), 80);
344:
345: -- Determine whether the value belongs in the lowest list

Line 342: hr_utility.set_location('g_high4 ' || to_char(g_high4), 70);

338:
339: hr_utility.set_location('g_high1 ' || to_char(g_high1), 40);
340: hr_utility.set_location('g_high2 ' || to_char(g_high2), 50);
341: hr_utility.set_location('g_high3 ' || to_char(g_high3), 60);
342: hr_utility.set_location('g_high4 ' || to_char(g_high4), 70);
343: hr_utility.set_location('g_high5 ' || to_char(g_high5), 80);
344:
345: -- Determine whether the value belongs in the lowest list
346: if p_value < g_low5 then

Line 343: hr_utility.set_location('g_high5 ' || to_char(g_high5), 80);

339: hr_utility.set_location('g_high1 ' || to_char(g_high1), 40);
340: hr_utility.set_location('g_high2 ' || to_char(g_high2), 50);
341: hr_utility.set_location('g_high3 ' || to_char(g_high3), 60);
342: hr_utility.set_location('g_high4 ' || to_char(g_high4), 70);
343: hr_utility.set_location('g_high5 ' || to_char(g_high5), 80);
344:
345: -- Determine whether the value belongs in the lowest list
346: if p_value < g_low5 then
347:

Line 394: hr_utility.set_location('g_low1 ' || to_char(g_low1), 90);

390: end if;
391:
392: end if;
393:
394: hr_utility.set_location('g_low1 ' || to_char(g_low1), 90);
395: hr_utility.set_location('g_low2 ' || to_char(g_low2), 100);
396: hr_utility.set_location('g_low3 ' || to_char(g_low3), 110);
397: hr_utility.set_location('g_low4 ' || to_char(g_low4), 120);
398: hr_utility.set_location('g_low5 ' || to_char(g_low5), 130);

Line 395: hr_utility.set_location('g_low2 ' || to_char(g_low2), 100);

391:
392: end if;
393:
394: hr_utility.set_location('g_low1 ' || to_char(g_low1), 90);
395: hr_utility.set_location('g_low2 ' || to_char(g_low2), 100);
396: hr_utility.set_location('g_low3 ' || to_char(g_low3), 110);
397: hr_utility.set_location('g_low4 ' || to_char(g_low4), 120);
398: hr_utility.set_location('g_low5 ' || to_char(g_low5), 130);
399:

Line 396: hr_utility.set_location('g_low3 ' || to_char(g_low3), 110);

392: end if;
393:
394: hr_utility.set_location('g_low1 ' || to_char(g_low1), 90);
395: hr_utility.set_location('g_low2 ' || to_char(g_low2), 100);
396: hr_utility.set_location('g_low3 ' || to_char(g_low3), 110);
397: hr_utility.set_location('g_low4 ' || to_char(g_low4), 120);
398: hr_utility.set_location('g_low5 ' || to_char(g_low5), 130);
399:
400: end if; -- Zero check

Line 397: hr_utility.set_location('g_low4 ' || to_char(g_low4), 120);

393:
394: hr_utility.set_location('g_low1 ' || to_char(g_low1), 90);
395: hr_utility.set_location('g_low2 ' || to_char(g_low2), 100);
396: hr_utility.set_location('g_low3 ' || to_char(g_low3), 110);
397: hr_utility.set_location('g_low4 ' || to_char(g_low4), 120);
398: hr_utility.set_location('g_low5 ' || to_char(g_low5), 130);
399:
400: end if; -- Zero check
401:

Line 398: hr_utility.set_location('g_low5 ' || to_char(g_low5), 130);

394: hr_utility.set_location('g_low1 ' || to_char(g_low1), 90);
395: hr_utility.set_location('g_low2 ' || to_char(g_low2), 100);
396: hr_utility.set_location('g_low3 ' || to_char(g_low3), 110);
397: hr_utility.set_location('g_low4 ' || to_char(g_low4), 120);
398: hr_utility.set_location('g_low5 ' || to_char(g_low5), 130);
399:
400: end if; -- Zero check
401:
402: end get_highest_and_lowest;

Line 511: -- hr_utility.trace_on(null, 'T');

507: l_proc constant varchar2(60) := g_package || 'reset_tables';
508:
509: begin
510:
511: -- hr_utility.trace_on(null, 'T');
512: hr_utility.set_location('Entering ' || l_proc, 10);
513:
514: g_assignments_table.delete;
515: g_all_high_avg := -9999;

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

508:
509: begin
510:
511: -- hr_utility.trace_on(null, 'T');
512: hr_utility.set_location('Entering ' || l_proc, 10);
513:
514: g_assignments_table.delete;
515: g_all_high_avg := -9999;
516: g_all_low_avg := -9999;

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

542: l_proc constant varchar2(60) := g_package || 'get_avg_5_highest_salary';
543:
544: begin
545:
546: hr_utility.set_location('Entering ' || l_proc, 10);
547:
548: -- The index is calculted by multiplying the legal entity id by 100 and then adding the lookup code
549: -- This should always give a unique value, since the lookup code is less than 100
550: begin

Line 553: hr_utility.set_location('LEV/CAT INDEX ' || l_index, 25);

549: -- This should always give a unique value, since the lookup code is less than 100
550: begin
551:
552: l_index := p_legal_entity_id * 100 + p_lookup_code;
553: hr_utility.set_location('LEV/CAT INDEX ' || l_index, 25);
554:
555: exception
556: when others then
557: raise_application_error(-20006, 'The lookup code in the ZA_EMP_EQ_OCCUPATIONAL_LEV and ZA_EMP_EQ_OCCUPATIONAL_CAT lookups must be numeric.');

Line 571: hr_utility.set_location('Step ' || l_proc, 20);

567:
568: -- Check whether the averages for the current occupational level already exist.
569: if not g_lev_averages_table.exists(l_index) then
570:
571: hr_utility.set_location('Step ' || l_proc, 20);
572: l_avg_5_highest_salary := get_avg_5_lowest_salary
573: (
574: p_report_date => p_report_date,
575: p_business_group_id => p_business_group_id,

Line 589: hr_utility.set_location('Step ' || l_proc, 23);

585:
586: -- Check whether the averages for the current occupational category already exist.
587: if not g_cat_averages_table.exists(l_index) then
588:
589: hr_utility.set_location('Step ' || l_proc, 23);
590: l_avg_5_highest_salary := get_avg_5_lowest_salary
591: (
592: p_report_date => p_report_date,
593: p_business_group_id => p_business_group_id,

Line 607: hr_utility.set_location('Step ' || l_proc, 24);

603:
604: -- Check whether the averages already exist.
605: if g_all_high_avg = -9999 then
606:
607: hr_utility.set_location('Step ' || l_proc, 24);
608: l_avg_5_highest_salary := get_avg_5_lowest_salary
609: (
610: p_report_date => p_report_date,
611: p_business_group_id => p_business_group_id,

Line 623: hr_utility.set_location('Lookup Code ' || p_lookup_code, 25);

619: end if;
620:
621: end if;
622:
623: hr_utility.set_location('Lookup Code ' || p_lookup_code, 25);
624:
625: -- Check Occupational Type
626: if p_occupational_type = 'LEV' then
627:

Line 629: hr_utility.set_location('LEV ' || to_char(l_avg_5_highest_salary), 30);

625: -- Check Occupational Type
626: if p_occupational_type = 'LEV' then
627:
628: l_avg_5_highest_salary := g_lev_averages_table(l_index).high;
629: hr_utility.set_location('LEV ' || to_char(l_avg_5_highest_salary), 30);
630:
631: elsif p_occupational_type = 'CAT' then
632:
633: l_avg_5_highest_salary := g_cat_averages_table(l_index).high;

Line 634: hr_utility.set_location('CAT ' || to_char(l_avg_5_highest_salary), 40);

630:
631: elsif p_occupational_type = 'CAT' then
632:
633: l_avg_5_highest_salary := g_cat_averages_table(l_index).high;
634: hr_utility.set_location('CAT ' || to_char(l_avg_5_highest_salary), 40);
635:
636: -- Average 5 highest salaries for all employees, irrespective of category or levels
637: -- elsif p_occupational_type not in ('CAT','LEV')
638: elsif p_occupational_type is null then

Line 641: hr_utility.set_location('TOTAL ' || to_char(l_avg_5_highest_salary), 50);

637: -- elsif p_occupational_type not in ('CAT','LEV')
638: elsif p_occupational_type is null then
639:
640: l_avg_5_highest_salary := g_all_high_avg;
641: hr_utility.set_location('TOTAL ' || to_char(l_avg_5_highest_salary), 50);
642:
643: end if;
644:
645: hr_utility.set_location('Exiting ' || l_proc, 60);

Line 645: hr_utility.set_location('Exiting ' || l_proc, 60);

641: hr_utility.set_location('TOTAL ' || to_char(l_avg_5_highest_salary), 50);
642:
643: end if;
644:
645: hr_utility.set_location('Exiting ' || l_proc, 60);
646: return l_avg_5_highest_salary;
647:
648: end get_avg_5_highest_salary;
649:

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

701: l_race per_all_people_f.per_information4%type; -- Bug 4413678
702:
703: begin
704:
705: hr_utility.set_location('Entering ' || l_proc, 10);
706:
707: -- Determine whether we need to populate the cache tables
708: -- Note: No check is made for the validity of the table data, since it is assumed that the
709: -- reset_tables procedure was called before this procedure.

Line 712: hr_utility.set_location('Setup assignments cache', 20);

708: -- Note: No check is made for the validity of the table data, since it is assumed that the
709: -- reset_tables procedure was called before this procedure.
710: if g_assignments_table.count = 0 then
711:
712: hr_utility.set_location('Setup assignments cache', 20);
713: g_assignments_table.delete;
714:
715: if p_salary_method = 'BAL' then
716:

Line 770: hr_utility.set_location('ASG ' || l_assignment.assignment_id, 21);

766:
767: -- Loop through the assignments cursor and populate the assignments table
768: for l_assignment in c_assignments loop
769:
770: hr_utility.set_location('ASG ' || l_assignment.assignment_id, 21);
771:
772: -- Bug 4413678: Begin
773: Select per_information4
774: into l_race

Line 788: hr_utility.set_location('LEGENT ' || l_assignment.aei_information7, 22);

784: g_assignments_table(l_assignment.assignment_id).legal_entity_id := l_assignment.aei_information7;
785: g_assignments_table(l_assignment.assignment_id).occupational_level := l_assignment.occupational_level;
786: g_assignments_table(l_assignment.assignment_id).occupational_category := l_assignment.occupational_category;
787:
788: hr_utility.set_location('LEGENT ' || l_assignment.aei_information7, 22);
789:
790: -- Check for a new payroll_id and cache the new payroll details in the payrolls table
791: if l_assignment.payroll_id <> l_old_payroll_id then
792:

Line 862: hr_utility.set_location('REP_START ' || to_char(l_report_start, 'DD\MM\YYYY'), 22);

858: l_old_payroll_id := l_assignment.payroll_id;
859:
860: end if;
861:
862: hr_utility.set_location('REP_START ' || to_char(l_report_start, 'DD\MM\YYYY'), 22);
863: hr_utility.set_location('REP_END ' || to_char(l_report_end, 'DD\MM\YYYY'), 23);
864: hr_utility.set_location('FREQ ' || l_period_frequency, 24);
865:
866: if p_salary_method = 'BAL' then

Line 863: hr_utility.set_location('REP_END ' || to_char(l_report_end, 'DD\MM\YYYY'), 23);

859:
860: end if;
861:
862: hr_utility.set_location('REP_START ' || to_char(l_report_start, 'DD\MM\YYYY'), 22);
863: hr_utility.set_location('REP_END ' || to_char(l_report_end, 'DD\MM\YYYY'), 23);
864: hr_utility.set_location('FREQ ' || l_period_frequency, 24);
865:
866: if p_salary_method = 'BAL' then
867:

Line 864: hr_utility.set_location('FREQ ' || l_period_frequency, 24);

860: end if;
861:
862: hr_utility.set_location('REP_START ' || to_char(l_report_start, 'DD\MM\YYYY'), 22);
863: hr_utility.set_location('REP_END ' || to_char(l_report_end, 'DD\MM\YYYY'), 23);
864: hr_utility.set_location('FREQ ' || l_period_frequency, 24);
865:
866: if p_salary_method = 'BAL' then
867:
868: -- Get the amount of days the assignment status was Active Assignment

Line 876: hr_utility.set_location('ACT_DAYS ' || l_active_days, 25);

872: p_report_start => l_report_start,
873: p_report_end => l_report_end
874: );
875:
876: hr_utility.set_location('ACT_DAYS ' || l_active_days, 25);
877:
878: -- Get the Employment Equitable Income
879: begin
880:

Line 938: hr_utility.set_location('EE_INC ' || l_ee_income, 26);

934: l_ee_annual_income := 0;
935:
936: end;
937:
938: hr_utility.set_location('EE_INC ' || l_ee_income, 26);
939: hr_utility.set_location('EE_ANN ' || l_ee_annual_income, 27);
940: hr_utility.set_location('STminEND ' || (l_report_end - l_report_start + 1), 28);
941:
942: -- Calculate the annual income = annualize normal income + annual income

Line 939: hr_utility.set_location('EE_ANN ' || l_ee_annual_income, 27);

935:
936: end;
937:
938: hr_utility.set_location('EE_INC ' || l_ee_income, 26);
939: hr_utility.set_location('EE_ANN ' || l_ee_annual_income, 27);
940: hr_utility.set_location('STminEND ' || (l_report_end - l_report_start + 1), 28);
941:
942: -- Calculate the annual income = annualize normal income + annual income
943: g_assignments_table(l_assignment.assignment_id).annual_income :=

Line 940: hr_utility.set_location('STminEND ' || (l_report_end - l_report_start + 1), 28);

936: end;
937:
938: hr_utility.set_location('EE_INC ' || l_ee_income, 26);
939: hr_utility.set_location('EE_ANN ' || l_ee_annual_income, 27);
940: hr_utility.set_location('STminEND ' || (l_report_end - l_report_start + 1), 28);
941:
942: -- Calculate the annual income = annualize normal income + annual income
943: g_assignments_table(l_assignment.assignment_id).annual_income :=
944: (

Line 948: hr_utility.set_location('ANSWER ' || g_assignments_table(l_assignment.assignment_id).annual_income, 29);

944: (
945: (l_report_end - l_report_start + 1) / l_active_days * l_ee_income
946: ) + l_ee_annual_income;
947:
948: hr_utility.set_location('ANSWER ' || g_assignments_table(l_assignment.assignment_id).annual_income, 29);
949:
950: elsif p_salary_method = 'SAL' then
951:
952: -- Get the annual salary basis for the current period

Line 1010: hr_utility.set_location('LEV/CAT INDEX ' || l_index, 25);

1006: -- This should always give a unique value, since the lookup code is less than 100
1007: begin
1008:
1009: l_index := p_legal_entity_id * 100 + p_lookup_code;
1010: hr_utility.set_location('LEV/CAT INDEX ' || l_index, 25);
1011:
1012: exception
1013: when others then
1014: raise_application_error(-20006, 'The lookup code in the ZA_EMP_EQ_OCCUPATIONAL_LEV and ZA_EMP_EQ_OCCUPATIONAL_CAT lookups must be numeric.');

Line 1020: hr_utility.set_location('LEV cache check' || p_lookup_code, 30);

1016: end;
1017:
1018: if p_occupational_type = 'LEV' then
1019:
1020: hr_utility.set_location('LEV cache check' || p_lookup_code, 30);
1021:
1022: -- Check whether the averages for the current occupational level already exist.
1023: if not g_lev_averages_table.exists(l_index) then
1024:

Line 1025: hr_utility.set_location('LEV cache' || p_lookup_code, 40);

1021:
1022: -- Check whether the averages for the current occupational level already exist.
1023: if not g_lev_averages_table.exists(l_index) then
1024:
1025: hr_utility.set_location('LEV cache' || p_lookup_code, 40);
1026: reset_high_low_lists;
1027:
1028: -- Loop through assignments cache table to look for current occupational level
1029: l_rowind := g_assignments_table.first;

Line 1064: hr_utility.set_location('CAT cache check' || p_lookup_code, 50);

1060: end if;
1061:
1062: elsif p_occupational_type = 'CAT' then
1063:
1064: hr_utility.set_location('CAT cache check' || p_lookup_code, 50);
1065:
1066: -- Check whether the averages for the current occupational category already exist.
1067: if not g_cat_averages_table.exists(l_index) then
1068:

Line 1069: hr_utility.set_location('CAT cache' || p_lookup_code, 60);

1065:
1066: -- Check whether the averages for the current occupational category already exist.
1067: if not g_cat_averages_table.exists(l_index) then
1068:
1069: hr_utility.set_location('CAT cache' || p_lookup_code, 60);
1070: reset_high_low_lists;
1071:
1072: -- Loop through assignments cache table to look for current occupational category
1073: l_rowind := g_assignments_table.first;

Line 1109: hr_utility.set_location('TOTAL cache check', 50);

1105:
1106: -- elsif p_occupational_type not in ('CAT', 'LEV')
1107: elsif p_occupational_type is null then
1108:
1109: hr_utility.set_location('TOTAL cache check', 50);
1110:
1111: -- Check whether the averages already exist.
1112: if g_all_high_avg = -9999 then
1113:

Line 1114: hr_utility.set_location('TOTAL cache', 60);

1110:
1111: -- Check whether the averages already exist.
1112: if g_all_high_avg = -9999 then
1113:
1114: hr_utility.set_location('TOTAL cache', 60);
1115: reset_high_low_lists;
1116:
1117: -- Loop through assignments cache table to look for current occupational category
1118: l_rowind := g_assignments_table.first;

Line 1326: hr_utility.set_location('p_job_id '||p_job_id , 30);

1322: l_name hr_lookups.meaning%type;
1323: l_sql varchar2(32767);
1324: begin
1325:
1326: hr_utility.set_location('p_job_id '||p_job_id , 30);
1327: hr_utility.set_location('p_grade_id '||p_grade_id , 30);
1328: hr_utility.set_location('p_position_id '||p_position_id , 30);
1329:
1330: if p_flex = 'Job' then

Line 1327: hr_utility.set_location('p_grade_id '||p_grade_id , 30);

1323: l_sql varchar2(32767);
1324: begin
1325:
1326: hr_utility.set_location('p_job_id '||p_job_id , 30);
1327: hr_utility.set_location('p_grade_id '||p_grade_id , 30);
1328: hr_utility.set_location('p_position_id '||p_position_id , 30);
1329:
1330: if p_flex = 'Job' then
1331: begin

Line 1328: hr_utility.set_location('p_position_id '||p_position_id , 30);

1324: begin
1325:
1326: hr_utility.set_location('p_job_id '||p_job_id , 30);
1327: hr_utility.set_location('p_grade_id '||p_grade_id , 30);
1328: hr_utility.set_location('p_position_id '||p_position_id , 30);
1329:
1330: if p_flex = 'Job' then
1331: begin
1332:

Line 1334: -- hr_utility.set_location('Security_grp_Id :' || fnd_global.lookup_security_group('ZA_WSP_OCCUPATIONAL_CATEGORIES',3),30);

1330: if p_flex = 'Job' then
1331: begin
1332:
1333: if p_job_id is not null then
1334: -- hr_utility.set_location('Security_grp_Id :' || fnd_global.lookup_security_group('ZA_WSP_OCCUPATIONAL_CATEGORIES',3),30);
1335: l_sql := 'select decode(flv1.attribute1,null,flv1.meaning, flv2.meaning) from fnd_lookup_values flv1, fnd_lookup_values flv2, per_job_definitions pjd, per_jobs pj where pj.job_id = '
1336: || to_char(p_job_id)
1337: || ' and pjd.job_definition_id = pj.job_definition_id '
1338: || ' and flv1.lookup_type = '||'''ZA_WSP_OCCUPATIONAL_CATEGORIES'''

Line 1464: hr_utility.set_location('p_type '||p_type,20);

1460:
1461: begin
1462: -- Added 08-Jan-2008
1463: l_indicator := 0;
1464: hr_utility.set_location('p_type '||p_type,20);
1465: hr_utility.set_location('p_flex '||p_flex,20);
1466: hr_utility.set_location('p_segment'||p_segment,20);
1467: IF p_type = 'CAT' then
1468: Select COUNT(*)

Line 1465: hr_utility.set_location('p_flex '||p_flex,20);

1461: begin
1462: -- Added 08-Jan-2008
1463: l_indicator := 0;
1464: hr_utility.set_location('p_type '||p_type,20);
1465: hr_utility.set_location('p_flex '||p_flex,20);
1466: hr_utility.set_location('p_segment'||p_segment,20);
1467: IF p_type = 'CAT' then
1468: Select COUNT(*)
1469: INTO l_indicator

Line 1466: hr_utility.set_location('p_segment'||p_segment,20);

1462: -- Added 08-Jan-2008
1463: l_indicator := 0;
1464: hr_utility.set_location('p_type '||p_type,20);
1465: hr_utility.set_location('p_flex '||p_flex,20);
1466: hr_utility.set_location('p_segment'||p_segment,20);
1467: IF p_type = 'CAT' then
1468: Select COUNT(*)
1469: INTO l_indicator
1470: FROM hr_lookups

Line 1474: hr_utility.set_location('l_indicator'||l_indicator, 20);

1470: FROM hr_lookups
1471: WHERE lookup_type = 'ZA_WSP_OCCUPATIONAL_CATEGORIES';
1472: END IF ;
1473:
1474: hr_utility.set_location('l_indicator'||l_indicator, 20);
1475:
1476: IF l_indicator > 0 THEN
1477: l_name := get_occupational_cat_data
1478: (

Line 1586: -- hr_utility.trace_on(null,'PERZAEER');

1582: l_user_row_id_func pay_user_rows_f.user_row_id%type;
1583: l_temp varchar2(9);
1584:
1585: begin
1586: -- hr_utility.trace_on(null,'PERZAEER');
1587:
1588: select user_table_id
1589: into l_user_table_id
1590: from pay_user_tables

Line 1595: hr_utility.set_location('l_user_table_id'||l_user_table_id, 10);

1591: where user_table_name = 'ZA_OCCUPATIONAL_TYPES'
1592: and business_group_id is null
1593: and legislation_code = 'ZA';
1594:
1595: hr_utility.set_location('l_user_table_id'||l_user_table_id, 10);
1596:
1597: select user_column_id
1598: into l_user_column_id_flex
1599: from pay_user_columns

Line 1683: hr_utility.set_location('l_user_table_id'||l_user_table_id, 10);

1679: and user_column_id = l_user_column_id_seg
1680: and business_group_id = p_business_group_id
1681: and p_report_date between effective_start_date and effective_end_date;
1682:
1683: hr_utility.set_location('l_user_table_id'||l_user_table_id, 10);
1684: hr_utility.set_location('l_user_column_id_flex'||l_user_column_id_flex, 10);
1685: hr_utility.set_location('l_user_column_id_seg'||l_user_column_id_seg, 10);
1686: hr_utility.set_location('l_user_row_id_cat'||l_user_row_id_cat, 10);
1687: hr_utility.set_location('l_user_row_id_lev'||l_user_row_id_lev, 10);

Line 1684: hr_utility.set_location('l_user_column_id_flex'||l_user_column_id_flex, 10);

1680: and business_group_id = p_business_group_id
1681: and p_report_date between effective_start_date and effective_end_date;
1682:
1683: hr_utility.set_location('l_user_table_id'||l_user_table_id, 10);
1684: hr_utility.set_location('l_user_column_id_flex'||l_user_column_id_flex, 10);
1685: hr_utility.set_location('l_user_column_id_seg'||l_user_column_id_seg, 10);
1686: hr_utility.set_location('l_user_row_id_cat'||l_user_row_id_cat, 10);
1687: hr_utility.set_location('l_user_row_id_lev'||l_user_row_id_lev, 10);
1688: hr_utility.set_location('l_user_row_id_func'||l_user_row_id_func, 10);

Line 1685: hr_utility.set_location('l_user_column_id_seg'||l_user_column_id_seg, 10);

1681: and p_report_date between effective_start_date and effective_end_date;
1682:
1683: hr_utility.set_location('l_user_table_id'||l_user_table_id, 10);
1684: hr_utility.set_location('l_user_column_id_flex'||l_user_column_id_flex, 10);
1685: hr_utility.set_location('l_user_column_id_seg'||l_user_column_id_seg, 10);
1686: hr_utility.set_location('l_user_row_id_cat'||l_user_row_id_cat, 10);
1687: hr_utility.set_location('l_user_row_id_lev'||l_user_row_id_lev, 10);
1688: hr_utility.set_location('l_user_row_id_func'||l_user_row_id_func, 10);
1689: hr_utility.set_location('g_cat_flex'||g_cat_flex, 10);

Line 1686: hr_utility.set_location('l_user_row_id_cat'||l_user_row_id_cat, 10);

1682:
1683: hr_utility.set_location('l_user_table_id'||l_user_table_id, 10);
1684: hr_utility.set_location('l_user_column_id_flex'||l_user_column_id_flex, 10);
1685: hr_utility.set_location('l_user_column_id_seg'||l_user_column_id_seg, 10);
1686: hr_utility.set_location('l_user_row_id_cat'||l_user_row_id_cat, 10);
1687: hr_utility.set_location('l_user_row_id_lev'||l_user_row_id_lev, 10);
1688: hr_utility.set_location('l_user_row_id_func'||l_user_row_id_func, 10);
1689: hr_utility.set_location('g_cat_flex'||g_cat_flex, 10);
1690: hr_utility.set_location('g_lev_flex'||g_lev_flex, 10);

Line 1687: hr_utility.set_location('l_user_row_id_lev'||l_user_row_id_lev, 10);

1683: hr_utility.set_location('l_user_table_id'||l_user_table_id, 10);
1684: hr_utility.set_location('l_user_column_id_flex'||l_user_column_id_flex, 10);
1685: hr_utility.set_location('l_user_column_id_seg'||l_user_column_id_seg, 10);
1686: hr_utility.set_location('l_user_row_id_cat'||l_user_row_id_cat, 10);
1687: hr_utility.set_location('l_user_row_id_lev'||l_user_row_id_lev, 10);
1688: hr_utility.set_location('l_user_row_id_func'||l_user_row_id_func, 10);
1689: hr_utility.set_location('g_cat_flex'||g_cat_flex, 10);
1690: hr_utility.set_location('g_lev_flex'||g_lev_flex, 10);
1691: hr_utility.set_location('g_Func_flex'||g_Func_flex, 10);

Line 1688: hr_utility.set_location('l_user_row_id_func'||l_user_row_id_func, 10);

1684: hr_utility.set_location('l_user_column_id_flex'||l_user_column_id_flex, 10);
1685: hr_utility.set_location('l_user_column_id_seg'||l_user_column_id_seg, 10);
1686: hr_utility.set_location('l_user_row_id_cat'||l_user_row_id_cat, 10);
1687: hr_utility.set_location('l_user_row_id_lev'||l_user_row_id_lev, 10);
1688: hr_utility.set_location('l_user_row_id_func'||l_user_row_id_func, 10);
1689: hr_utility.set_location('g_cat_flex'||g_cat_flex, 10);
1690: hr_utility.set_location('g_lev_flex'||g_lev_flex, 10);
1691: hr_utility.set_location('g_Func_flex'||g_Func_flex, 10);
1692: hr_utility.set_location('g_lev_segment'||g_lev_segment, 10);

Line 1689: hr_utility.set_location('g_cat_flex'||g_cat_flex, 10);

1685: hr_utility.set_location('l_user_column_id_seg'||l_user_column_id_seg, 10);
1686: hr_utility.set_location('l_user_row_id_cat'||l_user_row_id_cat, 10);
1687: hr_utility.set_location('l_user_row_id_lev'||l_user_row_id_lev, 10);
1688: hr_utility.set_location('l_user_row_id_func'||l_user_row_id_func, 10);
1689: hr_utility.set_location('g_cat_flex'||g_cat_flex, 10);
1690: hr_utility.set_location('g_lev_flex'||g_lev_flex, 10);
1691: hr_utility.set_location('g_Func_flex'||g_Func_flex, 10);
1692: hr_utility.set_location('g_lev_segment'||g_lev_segment, 10);
1693: hr_utility.set_location('g_cat_segment'||g_cat_segment, 10);

Line 1690: hr_utility.set_location('g_lev_flex'||g_lev_flex, 10);

1686: hr_utility.set_location('l_user_row_id_cat'||l_user_row_id_cat, 10);
1687: hr_utility.set_location('l_user_row_id_lev'||l_user_row_id_lev, 10);
1688: hr_utility.set_location('l_user_row_id_func'||l_user_row_id_func, 10);
1689: hr_utility.set_location('g_cat_flex'||g_cat_flex, 10);
1690: hr_utility.set_location('g_lev_flex'||g_lev_flex, 10);
1691: hr_utility.set_location('g_Func_flex'||g_Func_flex, 10);
1692: hr_utility.set_location('g_lev_segment'||g_lev_segment, 10);
1693: hr_utility.set_location('g_cat_segment'||g_cat_segment, 10);
1694: hr_utility.set_location('g_Func_segment'||g_Func_segment, 10);

Line 1691: hr_utility.set_location('g_Func_flex'||g_Func_flex, 10);

1687: hr_utility.set_location('l_user_row_id_lev'||l_user_row_id_lev, 10);
1688: hr_utility.set_location('l_user_row_id_func'||l_user_row_id_func, 10);
1689: hr_utility.set_location('g_cat_flex'||g_cat_flex, 10);
1690: hr_utility.set_location('g_lev_flex'||g_lev_flex, 10);
1691: hr_utility.set_location('g_Func_flex'||g_Func_flex, 10);
1692: hr_utility.set_location('g_lev_segment'||g_lev_segment, 10);
1693: hr_utility.set_location('g_cat_segment'||g_cat_segment, 10);
1694: hr_utility.set_location('g_Func_segment'||g_Func_segment, 10);
1695: -- Verify the validity of the segments

Line 1692: hr_utility.set_location('g_lev_segment'||g_lev_segment, 10);

1688: hr_utility.set_location('l_user_row_id_func'||l_user_row_id_func, 10);
1689: hr_utility.set_location('g_cat_flex'||g_cat_flex, 10);
1690: hr_utility.set_location('g_lev_flex'||g_lev_flex, 10);
1691: hr_utility.set_location('g_Func_flex'||g_Func_flex, 10);
1692: hr_utility.set_location('g_lev_segment'||g_lev_segment, 10);
1693: hr_utility.set_location('g_cat_segment'||g_cat_segment, 10);
1694: hr_utility.set_location('g_Func_segment'||g_Func_segment, 10);
1695: -- Verify the validity of the segments
1696: begin

Line 1693: hr_utility.set_location('g_cat_segment'||g_cat_segment, 10);

1689: hr_utility.set_location('g_cat_flex'||g_cat_flex, 10);
1690: hr_utility.set_location('g_lev_flex'||g_lev_flex, 10);
1691: hr_utility.set_location('g_Func_flex'||g_Func_flex, 10);
1692: hr_utility.set_location('g_lev_segment'||g_lev_segment, 10);
1693: hr_utility.set_location('g_cat_segment'||g_cat_segment, 10);
1694: hr_utility.set_location('g_Func_segment'||g_Func_segment, 10);
1695: -- Verify the validity of the segments
1696: begin
1697:

Line 1694: hr_utility.set_location('g_Func_segment'||g_Func_segment, 10);

1690: hr_utility.set_location('g_lev_flex'||g_lev_flex, 10);
1691: hr_utility.set_location('g_Func_flex'||g_Func_flex, 10);
1692: hr_utility.set_location('g_lev_segment'||g_lev_segment, 10);
1693: hr_utility.set_location('g_cat_segment'||g_cat_segment, 10);
1694: hr_utility.set_location('g_Func_segment'||g_Func_segment, 10);
1695: -- Verify the validity of the segments
1696: begin
1697:
1698: l_temp := substr(g_lev_segment, 8);

Line 4221: hr_utility.set_location('l_cat_index ' || l_cat_index, 25);

4217: begin
4218:
4219: l_cat_index := p_legal_entity_id *100 + nvl(p_occupational_category_id,0);
4220: l_lev_index := p_legal_entity_id *100 + nvl(p_occupational_level_id,0);
4221: hr_utility.set_location('l_cat_index ' || l_cat_index, 25);
4222: hr_utility.set_location('l_lev_index ' || l_lev_index, 25);
4223:
4224: exception
4225: when others then

Line 4222: hr_utility.set_location('l_lev_index ' || l_lev_index, 25);

4218:
4219: l_cat_index := p_legal_entity_id *100 + nvl(p_occupational_category_id,0);
4220: l_lev_index := p_legal_entity_id *100 + nvl(p_occupational_level_id,0);
4221: hr_utility.set_location('l_cat_index ' || l_cat_index, 25);
4222: hr_utility.set_location('l_lev_index ' || l_lev_index, 25);
4223:
4224: exception
4225: when others then
4226: raise_application_error(-20006, 'The lookup code in the ZA_EMP_EQ_OCCUPATIONAL_LEV and ZA_EMP_EQ_OCCUPATIONAL_CAT lookups must be numeric.');

Line 4581: --hr_utility.trace_on(null,'ZAEID');

4577: l_era_balance_type_id pay_balance_types.balance_type_id%type;
4578:
4579:
4580: begin
4581: --hr_utility.trace_on(null,'ZAEID');
4582: reset_tables;
4583: hr_utility.set_location('Entering ' || l_proc, 10);
4584:
4585: -- Determine whether we need to populate the cache tables

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

4579:
4580: begin
4581: --hr_utility.trace_on(null,'ZAEID');
4582: reset_tables;
4583: hr_utility.set_location('Entering ' || l_proc, 10);
4584:
4585: -- Determine whether we need to populate the cache tables
4586: -- Note: No check is made for the validity of the table data, since it is assumed that the
4587: -- reset_tables procedure was called before this procedure.

Line 4590: hr_utility.set_location('Setup assignments cache', 20);

4586: -- Note: No check is made for the validity of the table data, since it is assumed that the
4587: -- reset_tables procedure was called before this procedure.
4588: if g_assignments_table.count = 0 then
4589:
4590: hr_utility.set_location('Setup assignments cache', 20);
4591: g_assignments_table.delete;
4592:
4593: if p_salary_method = 'BAL' then
4594:

Line 4664: hr_utility.set_location('ASG ' || l_assignment.assignment_id, 21);

4660:
4661: -- Loop through the assignments cursor and populate the assignments table
4662: for l_assignment in c_assignments loop
4663:
4664: hr_utility.set_location('ASG ' || l_assignment.assignment_id, 21);
4665:
4666: -- Bug 4413678: Begin
4667: Select per_information4, papf.sex
4668: into l_race, l_sex

Line 4685: hr_utility.set_location('LEGENT ' || l_assignment.aei_information7, 22);

4681: g_assignments_table(l_assignment.assignment_id).occupational_category_ID := l_assignment.occupational_category_id;
4682: g_assignments_table(l_assignment.assignment_id).occupational_level_id := l_assignment.occupational_level_id;
4683: g_assignments_table(l_assignment.assignment_id).race := l_race;
4684: g_assignments_table(l_assignment.assignment_id).sex := l_sex;
4685: hr_utility.set_location('LEGENT ' || l_assignment.aei_information7, 22);
4686:
4687: -- Check for a new payroll_id and cache the new payroll details in the payrolls table
4688: if l_assignment.payroll_id <> l_old_payroll_id then
4689:

Line 4759: hr_utility.set_location('REP_START ' || to_char(l_report_start, 'DD\MM\YYYY'), 22);

4755: l_old_payroll_id := l_assignment.payroll_id;
4756:
4757: end if;
4758:
4759: hr_utility.set_location('REP_START ' || to_char(l_report_start, 'DD\MM\YYYY'), 22);
4760: hr_utility.set_location('REP_END ' || to_char(l_report_end, 'DD\MM\YYYY'), 23);
4761: hr_utility.set_location('FREQ ' || l_period_frequency, 24);
4762:
4763: if p_salary_method = 'BAL' then

Line 4760: hr_utility.set_location('REP_END ' || to_char(l_report_end, 'DD\MM\YYYY'), 23);

4756:
4757: end if;
4758:
4759: hr_utility.set_location('REP_START ' || to_char(l_report_start, 'DD\MM\YYYY'), 22);
4760: hr_utility.set_location('REP_END ' || to_char(l_report_end, 'DD\MM\YYYY'), 23);
4761: hr_utility.set_location('FREQ ' || l_period_frequency, 24);
4762:
4763: if p_salary_method = 'BAL' then
4764:

Line 4761: hr_utility.set_location('FREQ ' || l_period_frequency, 24);

4757: end if;
4758:
4759: hr_utility.set_location('REP_START ' || to_char(l_report_start, 'DD\MM\YYYY'), 22);
4760: hr_utility.set_location('REP_END ' || to_char(l_report_end, 'DD\MM\YYYY'), 23);
4761: hr_utility.set_location('FREQ ' || l_period_frequency, 24);
4762:
4763: if p_salary_method = 'BAL' then
4764:
4765: -- Get the amount of days the assignment status was Active Assignment

Line 4773: hr_utility.set_location('ACT_DAYS ' || l_active_days, 25);

4769: p_report_start => l_report_start,
4770: p_report_end => l_report_end
4771: );
4772:
4773: hr_utility.set_location('ACT_DAYS ' || l_active_days, 25);
4774:
4775: -- Get the Employment Equitable Income
4776: begin
4777:

Line 4898: hr_utility.set_location('EE_INC ' || l_ee_income, 26);

4894:
4895: end;
4896:
4897:
4898: hr_utility.set_location('EE_INC ' || l_ee_income, 26);
4899: hr_utility.set_location('EE_ANN ' || l_ee_annual_income, 27);
4900: hr_utility.set_location('ER_INC ' || l_er_income, 26);
4901: hr_utility.set_location('ER_ANN ' || l_er_annual_income, 27);
4902:

Line 4899: hr_utility.set_location('EE_ANN ' || l_ee_annual_income, 27);

4895: end;
4896:
4897:
4898: hr_utility.set_location('EE_INC ' || l_ee_income, 26);
4899: hr_utility.set_location('EE_ANN ' || l_ee_annual_income, 27);
4900: hr_utility.set_location('ER_INC ' || l_er_income, 26);
4901: hr_utility.set_location('ER_ANN ' || l_er_annual_income, 27);
4902:
4903: hr_utility.set_location('STminEND ' || (l_report_end - l_report_start + 1), 28);

Line 4900: hr_utility.set_location('ER_INC ' || l_er_income, 26);

4896:
4897:
4898: hr_utility.set_location('EE_INC ' || l_ee_income, 26);
4899: hr_utility.set_location('EE_ANN ' || l_ee_annual_income, 27);
4900: hr_utility.set_location('ER_INC ' || l_er_income, 26);
4901: hr_utility.set_location('ER_ANN ' || l_er_annual_income, 27);
4902:
4903: hr_utility.set_location('STminEND ' || (l_report_end - l_report_start + 1), 28);
4904:

Line 4901: hr_utility.set_location('ER_ANN ' || l_er_annual_income, 27);

4897:
4898: hr_utility.set_location('EE_INC ' || l_ee_income, 26);
4899: hr_utility.set_location('EE_ANN ' || l_ee_annual_income, 27);
4900: hr_utility.set_location('ER_INC ' || l_er_income, 26);
4901: hr_utility.set_location('ER_ANN ' || l_er_annual_income, 27);
4902:
4903: hr_utility.set_location('STminEND ' || (l_report_end - l_report_start + 1), 28);
4904:
4905: -- Calculate the annual income = annualize normal income + annual income

Line 4903: hr_utility.set_location('STminEND ' || (l_report_end - l_report_start + 1), 28);

4899: hr_utility.set_location('EE_ANN ' || l_ee_annual_income, 27);
4900: hr_utility.set_location('ER_INC ' || l_er_income, 26);
4901: hr_utility.set_location('ER_ANN ' || l_er_annual_income, 27);
4902:
4903: hr_utility.set_location('STminEND ' || (l_report_end - l_report_start + 1), 28);
4904:
4905: -- Calculate the annual income = annualize normal income + annual income
4906: g_assignments_table(l_assignment.assignment_id).annual_income :=
4907: (

Line 4912: hr_utility.set_location('ANSWER ' || g_assignments_table(l_assignment.assignment_id).annual_income, 29);

4908: ((l_report_end - l_report_start + 1) / l_active_days * l_ee_income) +
4909: ((l_report_end - l_report_start + 1) / l_active_days * l_er_income)
4910: ) + l_ee_annual_income + l_er_annual_income;
4911:
4912: hr_utility.set_location('ANSWER ' || g_assignments_table(l_assignment.assignment_id).annual_income, 29);
4913:
4914: elsif p_salary_method = 'SAL' then
4915:
4916: -- Get the annual salary basis for the current period

Line 4973: hr_utility.set_location ('l_rowind :=' || l_rowind, 20);

4969: -- The index is calculted by multiplying the legal entity id by 100 and then adding the lookup code
4970: -- This should always give a unique value, since the lookup code is less than 100
4971: -- Start of adding for Employment Equity Report Enhancement Inserting values in table.
4972: l_rowind := g_assignments_table.first;
4973: hr_utility.set_location ('l_rowind :=' || l_rowind, 20);
4974: loop
4975: exit when l_rowind is null;
4976:
4977: hr_utility.set_location ('g_assignments_table(l_rowind).legal_entity_id' ||g_assignments_table(l_rowind).legal_entity_id, 20);

Line 4977: hr_utility.set_location ('g_assignments_table(l_rowind).legal_entity_id' ||g_assignments_table(l_rowind).legal_entity_id, 20);

4973: hr_utility.set_location ('l_rowind :=' || l_rowind, 20);
4974: loop
4975: exit when l_rowind is null;
4976:
4977: hr_utility.set_location ('g_assignments_table(l_rowind).legal_entity_id' ||g_assignments_table(l_rowind).legal_entity_id, 20);
4978: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).occupational_level, 20);
4979: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).occupational_category, 20);
4980: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).race, 20);
4981: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).sex, 20);

Line 4978: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).occupational_level, 20);

4974: loop
4975: exit when l_rowind is null;
4976:
4977: hr_utility.set_location ('g_assignments_table(l_rowind).legal_entity_id' ||g_assignments_table(l_rowind).legal_entity_id, 20);
4978: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).occupational_level, 20);
4979: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).occupational_category, 20);
4980: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).race, 20);
4981: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).sex, 20);
4982: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).annual_income, 20);

Line 4979: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).occupational_category, 20);

4975: exit when l_rowind is null;
4976:
4977: hr_utility.set_location ('g_assignments_table(l_rowind).legal_entity_id' ||g_assignments_table(l_rowind).legal_entity_id, 20);
4978: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).occupational_level, 20);
4979: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).occupational_category, 20);
4980: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).race, 20);
4981: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).sex, 20);
4982: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).annual_income, 20);
4983:

Line 4980: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).race, 20);

4976:
4977: hr_utility.set_location ('g_assignments_table(l_rowind).legal_entity_id' ||g_assignments_table(l_rowind).legal_entity_id, 20);
4978: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).occupational_level, 20);
4979: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).occupational_category, 20);
4980: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).race, 20);
4981: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).sex, 20);
4982: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).annual_income, 20);
4983:
4984: cat_lev_data( g_assignments_table(l_rowind).legal_entity_id

Line 4981: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).sex, 20);

4977: hr_utility.set_location ('g_assignments_table(l_rowind).legal_entity_id' ||g_assignments_table(l_rowind).legal_entity_id, 20);
4978: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).occupational_level, 20);
4979: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).occupational_category, 20);
4980: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).race, 20);
4981: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).sex, 20);
4982: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).annual_income, 20);
4983:
4984: cat_lev_data( g_assignments_table(l_rowind).legal_entity_id
4985: , g_assignments_table(l_rowind).occupational_level

Line 4982: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).annual_income, 20);

4978: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).occupational_level, 20);
4979: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).occupational_category, 20);
4980: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).race, 20);
4981: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).sex, 20);
4982: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).annual_income, 20);
4983:
4984: cat_lev_data( g_assignments_table(l_rowind).legal_entity_id
4985: , g_assignments_table(l_rowind).occupational_level
4986: , g_assignments_table(l_rowind).occupational_category

Line 5177: --hr_utility.trace_off;

5173: Where haou.organization_id = g_lev_Enc_Diff_table(l_rowind).legal_entity_id;
5174:
5175: l_rowind := g_lev_Enc_Diff_table.next(l_rowind);
5176: END loop;
5177: --hr_utility.trace_off;
5178:
5179: -- Inserts non-associated occupational categories with zero values for no of employees
5180: insert into per_za_employment_equity
5181: (