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 234: hr_utility.set_location('Entering ' || l_proc, 10);

230: l_proc constant varchar2(60) := g_package || 'reset_high_low_lists';
231:
232: begin
233:
234: hr_utility.set_location('Entering ' || l_proc, 10);
235:
236: g_high1 := 0;
237: g_high2 := 0;
238: g_high3 := 0;

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

327: l_proc constant varchar2(60) := g_package || 'get_highest_and_lowest';
328:
329: begin
330:
331: hr_utility.set_location('Entering ' || l_proc, 10);
332: hr_utility.set_location('p_value ' || to_char(p_value), 20);
333:
334: -- Ignore the value if it is zero
335: if p_value <> 0 then

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

328:
329: begin
330:
331: hr_utility.set_location('Entering ' || l_proc, 10);
332: hr_utility.set_location('p_value ' || to_char(p_value), 20);
333:
334: -- Ignore the value if it is zero
335: if p_value <> 0 then
336:

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

382: end if;
383:
384: end if;
385:
386: hr_utility.set_location('g_high1 ' || to_char(g_high1), 40);
387: hr_utility.set_location('g_high2 ' || to_char(g_high2), 50);
388: hr_utility.set_location('g_high3 ' || to_char(g_high3), 60);
389: hr_utility.set_location('g_high4 ' || to_char(g_high4), 70);
390: hr_utility.set_location('g_high5 ' || to_char(g_high5), 80);

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

383:
384: end if;
385:
386: hr_utility.set_location('g_high1 ' || to_char(g_high1), 40);
387: hr_utility.set_location('g_high2 ' || to_char(g_high2), 50);
388: hr_utility.set_location('g_high3 ' || to_char(g_high3), 60);
389: hr_utility.set_location('g_high4 ' || to_char(g_high4), 70);
390: hr_utility.set_location('g_high5 ' || to_char(g_high5), 80);
391:

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

384: end if;
385:
386: hr_utility.set_location('g_high1 ' || to_char(g_high1), 40);
387: hr_utility.set_location('g_high2 ' || to_char(g_high2), 50);
388: hr_utility.set_location('g_high3 ' || to_char(g_high3), 60);
389: hr_utility.set_location('g_high4 ' || to_char(g_high4), 70);
390: hr_utility.set_location('g_high5 ' || to_char(g_high5), 80);
391:
392: -- Determine whether the value belongs in the lowest list

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

385:
386: hr_utility.set_location('g_high1 ' || to_char(g_high1), 40);
387: hr_utility.set_location('g_high2 ' || to_char(g_high2), 50);
388: hr_utility.set_location('g_high3 ' || to_char(g_high3), 60);
389: hr_utility.set_location('g_high4 ' || to_char(g_high4), 70);
390: hr_utility.set_location('g_high5 ' || to_char(g_high5), 80);
391:
392: -- Determine whether the value belongs in the lowest list
393: if p_value < g_low5 then

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

386: hr_utility.set_location('g_high1 ' || to_char(g_high1), 40);
387: hr_utility.set_location('g_high2 ' || to_char(g_high2), 50);
388: hr_utility.set_location('g_high3 ' || to_char(g_high3), 60);
389: hr_utility.set_location('g_high4 ' || to_char(g_high4), 70);
390: hr_utility.set_location('g_high5 ' || to_char(g_high5), 80);
391:
392: -- Determine whether the value belongs in the lowest list
393: if p_value < g_low5 then
394:

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

437: end if;
438:
439: end if;
440:
441: hr_utility.set_location('g_low1 ' || to_char(g_low1), 90);
442: hr_utility.set_location('g_low2 ' || to_char(g_low2), 100);
443: hr_utility.set_location('g_low3 ' || to_char(g_low3), 110);
444: hr_utility.set_location('g_low4 ' || to_char(g_low4), 120);
445: hr_utility.set_location('g_low5 ' || to_char(g_low5), 130);

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

438:
439: end if;
440:
441: hr_utility.set_location('g_low1 ' || to_char(g_low1), 90);
442: hr_utility.set_location('g_low2 ' || to_char(g_low2), 100);
443: hr_utility.set_location('g_low3 ' || to_char(g_low3), 110);
444: hr_utility.set_location('g_low4 ' || to_char(g_low4), 120);
445: hr_utility.set_location('g_low5 ' || to_char(g_low5), 130);
446:

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

439: end if;
440:
441: hr_utility.set_location('g_low1 ' || to_char(g_low1), 90);
442: hr_utility.set_location('g_low2 ' || to_char(g_low2), 100);
443: hr_utility.set_location('g_low3 ' || to_char(g_low3), 110);
444: hr_utility.set_location('g_low4 ' || to_char(g_low4), 120);
445: hr_utility.set_location('g_low5 ' || to_char(g_low5), 130);
446:
447: end if; -- Zero check

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

440:
441: hr_utility.set_location('g_low1 ' || to_char(g_low1), 90);
442: hr_utility.set_location('g_low2 ' || to_char(g_low2), 100);
443: hr_utility.set_location('g_low3 ' || to_char(g_low3), 110);
444: hr_utility.set_location('g_low4 ' || to_char(g_low4), 120);
445: hr_utility.set_location('g_low5 ' || to_char(g_low5), 130);
446:
447: end if; -- Zero check
448:

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

441: hr_utility.set_location('g_low1 ' || to_char(g_low1), 90);
442: hr_utility.set_location('g_low2 ' || to_char(g_low2), 100);
443: hr_utility.set_location('g_low3 ' || to_char(g_low3), 110);
444: hr_utility.set_location('g_low4 ' || to_char(g_low4), 120);
445: hr_utility.set_location('g_low5 ' || to_char(g_low5), 130);
446:
447: end if; -- Zero check
448:
449: end get_highest_and_lowest;

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

554: l_proc constant varchar2(60) := g_package || 'reset_tables';
555:
556: begin
557:
558: -- hr_utility.trace_on(null, 'T');
559: hr_utility.set_location('Entering ' || l_proc, 10);
560:
561: g_assignments_table.delete;
562: g_all_high_avg := -9999;

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

555:
556: begin
557:
558: -- hr_utility.trace_on(null, 'T');
559: hr_utility.set_location('Entering ' || l_proc, 10);
560:
561: g_assignments_table.delete;
562: g_all_high_avg := -9999;
563: g_all_low_avg := -9999;

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

589: l_proc constant varchar2(60) := g_package || 'get_avg_5_highest_salary';
590:
591: begin
592:
593: hr_utility.set_location('Entering ' || l_proc, 10);
594:
595: -- The index is calculted by multiplying the legal entity id by 100 and then adding the lookup code
596: -- This should always give a unique value, since the lookup code is less than 100
597: begin

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

596: -- This should always give a unique value, since the lookup code is less than 100
597: begin
598:
599: l_index := p_legal_entity_id * 100 + p_lookup_code;
600: hr_utility.set_location('LEV/CAT INDEX ' || l_index, 25);
601:
602: exception
603: when others then
604: 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 618: hr_utility.set_location('Step ' || l_proc, 20);

614:
615: -- Check whether the averages for the current occupational level already exist.
616: if not g_lev_averages_table.exists(l_index) then
617:
618: hr_utility.set_location('Step ' || l_proc, 20);
619: l_avg_5_highest_salary := get_avg_5_lowest_salary
620: (
621: p_report_date => p_report_date,
622: p_business_group_id => p_business_group_id,

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

632:
633: -- Check whether the averages for the current occupational category already exist.
634: if not g_cat_averages_table.exists(l_index) then
635:
636: hr_utility.set_location('Step ' || l_proc, 23);
637: l_avg_5_highest_salary := get_avg_5_lowest_salary
638: (
639: p_report_date => p_report_date,
640: p_business_group_id => p_business_group_id,

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

650:
651: -- Check whether the averages already exist.
652: if g_all_high_avg = -9999 then
653:
654: hr_utility.set_location('Step ' || l_proc, 24);
655: l_avg_5_highest_salary := get_avg_5_lowest_salary
656: (
657: p_report_date => p_report_date,
658: p_business_group_id => p_business_group_id,

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

666: end if;
667:
668: end if;
669:
670: hr_utility.set_location('Lookup Code ' || p_lookup_code, 25);
671:
672: -- Check Occupational Type
673: if p_occupational_type = 'LEV' then
674:

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

672: -- Check Occupational Type
673: if p_occupational_type = 'LEV' then
674:
675: l_avg_5_highest_salary := g_lev_averages_table(l_index).high;
676: hr_utility.set_location('LEV ' || to_char(l_avg_5_highest_salary), 30);
677:
678: elsif p_occupational_type = 'CAT' then
679:
680: l_avg_5_highest_salary := g_cat_averages_table(l_index).high;

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

677:
678: elsif p_occupational_type = 'CAT' then
679:
680: l_avg_5_highest_salary := g_cat_averages_table(l_index).high;
681: hr_utility.set_location('CAT ' || to_char(l_avg_5_highest_salary), 40);
682:
683: -- Average 5 highest salaries for all employees, irrespective of category or levels
684: -- elsif p_occupational_type not in ('CAT','LEV')
685: elsif p_occupational_type is null then

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

684: -- elsif p_occupational_type not in ('CAT','LEV')
685: elsif p_occupational_type is null then
686:
687: l_avg_5_highest_salary := g_all_high_avg;
688: hr_utility.set_location('TOTAL ' || to_char(l_avg_5_highest_salary), 50);
689:
690: end if;
691:
692: hr_utility.set_location('Exiting ' || l_proc, 60);

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

688: hr_utility.set_location('TOTAL ' || to_char(l_avg_5_highest_salary), 50);
689:
690: end if;
691:
692: hr_utility.set_location('Exiting ' || l_proc, 60);
693: return l_avg_5_highest_salary;
694:
695: end get_avg_5_highest_salary;
696:

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

748: l_race per_all_people_f.per_information4%type; -- Bug 4413678
749:
750: begin
751:
752: hr_utility.set_location('Entering ' || l_proc, 10);
753:
754: -- Determine whether we need to populate the cache tables
755: -- Note: No check is made for the validity of the table data, since it is assumed that the
756: -- reset_tables procedure was called before this procedure.

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

755: -- Note: No check is made for the validity of the table data, since it is assumed that the
756: -- reset_tables procedure was called before this procedure.
757: if g_assignments_table.count = 0 then
758:
759: hr_utility.set_location('Setup assignments cache', 20);
760: g_assignments_table.delete;
761:
762: if p_salary_method = 'BAL' then
763:

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

813:
814: -- Loop through the assignments cursor and populate the assignments table
815: for l_assignment in c_assignments loop
816:
817: hr_utility.set_location('ASG ' || l_assignment.assignment_id, 21);
818:
819: -- Bug 4413678: Begin
820: Select per_information4
821: into l_race

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

831: g_assignments_table(l_assignment.assignment_id).legal_entity_id := l_assignment.aei_information7;
832: g_assignments_table(l_assignment.assignment_id).occupational_level := l_assignment.occupational_level;
833: g_assignments_table(l_assignment.assignment_id).occupational_category := l_assignment.occupational_category;
834:
835: hr_utility.set_location('LEGENT ' || l_assignment.aei_information7, 22);
836:
837: -- Check for a new payroll_id and cache the new payroll details in the payrolls table
838: if l_assignment.payroll_id <> l_old_payroll_id then
839:

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

905: l_old_payroll_id := l_assignment.payroll_id;
906:
907: end if;
908:
909: hr_utility.set_location('REP_START ' || to_char(l_report_start, 'DD\MM\YYYY'), 22);
910: hr_utility.set_location('REP_END ' || to_char(l_report_end, 'DD\MM\YYYY'), 23);
911: hr_utility.set_location('FREQ ' || l_period_frequency, 24);
912:
913: if p_salary_method = 'BAL' then

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

906:
907: end if;
908:
909: hr_utility.set_location('REP_START ' || to_char(l_report_start, 'DD\MM\YYYY'), 22);
910: hr_utility.set_location('REP_END ' || to_char(l_report_end, 'DD\MM\YYYY'), 23);
911: hr_utility.set_location('FREQ ' || l_period_frequency, 24);
912:
913: if p_salary_method = 'BAL' then
914:

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

907: end if;
908:
909: hr_utility.set_location('REP_START ' || to_char(l_report_start, 'DD\MM\YYYY'), 22);
910: hr_utility.set_location('REP_END ' || to_char(l_report_end, 'DD\MM\YYYY'), 23);
911: hr_utility.set_location('FREQ ' || l_period_frequency, 24);
912:
913: if p_salary_method = 'BAL' then
914:
915: -- Get the amount of days the assignment status was Active Assignment

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

919: p_report_start => l_report_start,
920: p_report_end => l_report_end
921: );
922:
923: hr_utility.set_location('ACT_DAYS ' || l_active_days, 25);
924:
925: -- Get the Employment Equitable Income
926: begin
927:

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

981: l_ee_annual_income := 0;
982:
983: end;
984:
985: hr_utility.set_location('EE_INC ' || l_ee_income, 26);
986: hr_utility.set_location('EE_ANN ' || l_ee_annual_income, 27);
987: hr_utility.set_location('STminEND ' || (l_report_end - l_report_start + 1), 28);
988:
989: -- Calculate the annual income = annualize normal income + annual income

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

982:
983: end;
984:
985: hr_utility.set_location('EE_INC ' || l_ee_income, 26);
986: hr_utility.set_location('EE_ANN ' || l_ee_annual_income, 27);
987: hr_utility.set_location('STminEND ' || (l_report_end - l_report_start + 1), 28);
988:
989: -- Calculate the annual income = annualize normal income + annual income
990: g_assignments_table(l_assignment.assignment_id).annual_income :=

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

983: end;
984:
985: hr_utility.set_location('EE_INC ' || l_ee_income, 26);
986: hr_utility.set_location('EE_ANN ' || l_ee_annual_income, 27);
987: hr_utility.set_location('STminEND ' || (l_report_end - l_report_start + 1), 28);
988:
989: -- Calculate the annual income = annualize normal income + annual income
990: g_assignments_table(l_assignment.assignment_id).annual_income :=
991: (

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

991: (
992: (l_report_end - l_report_start + 1) / l_active_days * l_ee_income
993: ) + l_ee_annual_income;
994:
995: hr_utility.set_location('ANSWER ' || g_assignments_table(l_assignment.assignment_id).annual_income, 29);
996:
997: elsif p_salary_method = 'SAL' then
998:
999: -- Get the annual salary basis for the current period

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

1053: -- This should always give a unique value, since the lookup code is less than 100
1054: begin
1055:
1056: l_index := p_legal_entity_id * 100 + p_lookup_code;
1057: hr_utility.set_location('LEV/CAT INDEX ' || l_index, 25);
1058:
1059: exception
1060: when others then
1061: 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 1067: hr_utility.set_location('LEV cache check' || p_lookup_code, 30);

1063: end;
1064:
1065: if p_occupational_type = 'LEV' then
1066:
1067: hr_utility.set_location('LEV cache check' || p_lookup_code, 30);
1068:
1069: -- Check whether the averages for the current occupational level already exist.
1070: if not g_lev_averages_table.exists(l_index) then
1071:

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

1068:
1069: -- Check whether the averages for the current occupational level already exist.
1070: if not g_lev_averages_table.exists(l_index) then
1071:
1072: hr_utility.set_location('LEV cache' || p_lookup_code, 40);
1073: reset_high_low_lists;
1074:
1075: -- Loop through assignments cache table to look for current occupational level
1076: l_rowind := g_assignments_table.first;

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

1107: end if;
1108:
1109: elsif p_occupational_type = 'CAT' then
1110:
1111: hr_utility.set_location('CAT cache check' || p_lookup_code, 50);
1112:
1113: -- Check whether the averages for the current occupational category already exist.
1114: if not g_cat_averages_table.exists(l_index) then
1115:

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

1112:
1113: -- Check whether the averages for the current occupational category already exist.
1114: if not g_cat_averages_table.exists(l_index) then
1115:
1116: hr_utility.set_location('CAT cache' || p_lookup_code, 60);
1117: reset_high_low_lists;
1118:
1119: -- Loop through assignments cache table to look for current occupational category
1120: l_rowind := g_assignments_table.first;

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

1152:
1153: -- elsif p_occupational_type not in ('CAT', 'LEV')
1154: elsif p_occupational_type is null then
1155:
1156: hr_utility.set_location('TOTAL cache check', 50);
1157:
1158: -- Check whether the averages already exist.
1159: if g_all_high_avg = -9999 then
1160:

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

1157:
1158: -- Check whether the averages already exist.
1159: if g_all_high_avg = -9999 then
1160:
1161: hr_utility.set_location('TOTAL cache', 60);
1162: reset_high_low_lists;
1163:
1164: -- Loop through assignments cache table to look for current occupational category
1165: l_rowind := g_assignments_table.first;

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

1370: l_name hr_lookups.meaning%type;
1371: l_sql varchar2(32767);
1372: begin
1373:
1374: hr_utility.set_location('p_job_id '||p_job_id , 30);
1375: hr_utility.set_location('p_grade_id '||p_grade_id , 30);
1376: hr_utility.set_location('p_position_id '||p_position_id , 30);
1377:
1378: if p_flex = 'Job' then

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

1371: l_sql varchar2(32767);
1372: begin
1373:
1374: hr_utility.set_location('p_job_id '||p_job_id , 30);
1375: hr_utility.set_location('p_grade_id '||p_grade_id , 30);
1376: hr_utility.set_location('p_position_id '||p_position_id , 30);
1377:
1378: if p_flex = 'Job' then
1379: begin

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

1372: begin
1373:
1374: hr_utility.set_location('p_job_id '||p_job_id , 30);
1375: hr_utility.set_location('p_grade_id '||p_grade_id , 30);
1376: hr_utility.set_location('p_position_id '||p_position_id , 30);
1377:
1378: if p_flex = 'Job' then
1379: begin
1380:

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

1378: if p_flex = 'Job' then
1379: begin
1380:
1381: if p_job_id is not null then
1382: -- hr_utility.set_location('Security_grp_Id :' || fnd_global.lookup_security_group('ZA_WSP_OCCUPATIONAL_CATEGORIES',3),30);
1383: 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 = '
1384: || to_char(p_job_id)
1385: || ' and pjd.job_definition_id = pj.job_definition_id '
1386: || ' and flv1.lookup_type = '||'''ZA_WSP_OCCUPATIONAL_CATEGORIES'''

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

1508:
1509: begin
1510: -- Added 08-Jan-2008
1511: l_indicator := 0;
1512: hr_utility.set_location('p_type '||p_type,20);
1513: hr_utility.set_location('p_flex '||p_flex,20);
1514: hr_utility.set_location('p_segment'||p_segment,20);
1515: IF p_type = 'CAT' then
1516: Select COUNT(*)

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

1509: begin
1510: -- Added 08-Jan-2008
1511: l_indicator := 0;
1512: hr_utility.set_location('p_type '||p_type,20);
1513: hr_utility.set_location('p_flex '||p_flex,20);
1514: hr_utility.set_location('p_segment'||p_segment,20);
1515: IF p_type = 'CAT' then
1516: Select COUNT(*)
1517: INTO l_indicator

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

1510: -- Added 08-Jan-2008
1511: l_indicator := 0;
1512: hr_utility.set_location('p_type '||p_type,20);
1513: hr_utility.set_location('p_flex '||p_flex,20);
1514: hr_utility.set_location('p_segment'||p_segment,20);
1515: IF p_type = 'CAT' then
1516: Select COUNT(*)
1517: INTO l_indicator
1518: FROM hr_lookups

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

1518: FROM hr_lookups
1519: WHERE lookup_type = 'ZA_WSP_OCCUPATIONAL_CATEGORIES';
1520: END IF ;
1521:
1522: hr_utility.set_location('l_indicator'||l_indicator, 20);
1523:
1524: IF l_indicator > 0 THEN
1525: l_name := get_occupational_cat_data
1526: (

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

1631: l_user_row_id_func pay_user_rows_f.user_row_id%type;
1632: l_temp varchar2(9);
1633:
1634: begin
1635: -- hr_utility.trace_on(null,'PERZAEER');
1636:
1637: select user_table_id
1638: into l_user_table_id
1639: from pay_user_tables

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

1640: where user_table_name = 'ZA_OCCUPATIONAL_TYPES'
1641: and business_group_id is null
1642: and legislation_code = 'ZA';
1643:
1644: hr_utility.set_location('l_user_table_id'||l_user_table_id, 10);
1645:
1646: select user_column_id
1647: into l_user_column_id_flex
1648: from pay_user_columns

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

1683: and user_column_id = l_user_column_id_seg
1684: and business_group_id = p_business_group_id
1685: and p_report_date between effective_start_date and effective_end_date;
1686:
1687: hr_utility.set_location('l_user_row_id_cat'||l_user_row_id_cat, 10);
1688: hr_utility.set_location('g_cat_flex'||g_cat_flex, 10);
1689: hr_utility.set_location('g_cat_segment'||g_cat_segment, 10);
1690:
1691: end if;

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

1684: and business_group_id = p_business_group_id
1685: and p_report_date between effective_start_date and effective_end_date;
1686:
1687: hr_utility.set_location('l_user_row_id_cat'||l_user_row_id_cat, 10);
1688: hr_utility.set_location('g_cat_flex'||g_cat_flex, 10);
1689: hr_utility.set_location('g_cat_segment'||g_cat_segment, 10);
1690:
1691: end if;
1692:

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

1685: and p_report_date between effective_start_date and effective_end_date;
1686:
1687: hr_utility.set_location('l_user_row_id_cat'||l_user_row_id_cat, 10);
1688: hr_utility.set_location('g_cat_flex'||g_cat_flex, 10);
1689: hr_utility.set_location('g_cat_segment'||g_cat_segment, 10);
1690:
1691: end if;
1692:
1693: select user_row_id

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

1737: and user_column_id = l_user_column_id_seg
1738: and business_group_id = p_business_group_id
1739: and p_report_date between effective_start_date and effective_end_date;
1740:
1741: hr_utility.set_location('l_user_table_id'||l_user_table_id, 10);
1742: hr_utility.set_location('l_user_column_id_flex'||l_user_column_id_flex, 10);
1743: hr_utility.set_location('l_user_column_id_seg'||l_user_column_id_seg, 10);
1744: hr_utility.set_location('l_user_row_id_lev'||l_user_row_id_lev, 10);
1745: hr_utility.set_location('l_user_row_id_func'||l_user_row_id_func, 10);

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

1738: and business_group_id = p_business_group_id
1739: and p_report_date between effective_start_date and effective_end_date;
1740:
1741: hr_utility.set_location('l_user_table_id'||l_user_table_id, 10);
1742: hr_utility.set_location('l_user_column_id_flex'||l_user_column_id_flex, 10);
1743: hr_utility.set_location('l_user_column_id_seg'||l_user_column_id_seg, 10);
1744: hr_utility.set_location('l_user_row_id_lev'||l_user_row_id_lev, 10);
1745: hr_utility.set_location('l_user_row_id_func'||l_user_row_id_func, 10);
1746: hr_utility.set_location('g_lev_flex'||g_lev_flex, 10);

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

1739: and p_report_date between effective_start_date and effective_end_date;
1740:
1741: hr_utility.set_location('l_user_table_id'||l_user_table_id, 10);
1742: hr_utility.set_location('l_user_column_id_flex'||l_user_column_id_flex, 10);
1743: hr_utility.set_location('l_user_column_id_seg'||l_user_column_id_seg, 10);
1744: hr_utility.set_location('l_user_row_id_lev'||l_user_row_id_lev, 10);
1745: hr_utility.set_location('l_user_row_id_func'||l_user_row_id_func, 10);
1746: hr_utility.set_location('g_lev_flex'||g_lev_flex, 10);
1747: hr_utility.set_location('g_Func_flex'||g_Func_flex, 10);

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

1740:
1741: hr_utility.set_location('l_user_table_id'||l_user_table_id, 10);
1742: hr_utility.set_location('l_user_column_id_flex'||l_user_column_id_flex, 10);
1743: hr_utility.set_location('l_user_column_id_seg'||l_user_column_id_seg, 10);
1744: hr_utility.set_location('l_user_row_id_lev'||l_user_row_id_lev, 10);
1745: hr_utility.set_location('l_user_row_id_func'||l_user_row_id_func, 10);
1746: hr_utility.set_location('g_lev_flex'||g_lev_flex, 10);
1747: hr_utility.set_location('g_Func_flex'||g_Func_flex, 10);
1748: hr_utility.set_location('g_lev_segment'||g_lev_segment, 10);

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

1741: hr_utility.set_location('l_user_table_id'||l_user_table_id, 10);
1742: hr_utility.set_location('l_user_column_id_flex'||l_user_column_id_flex, 10);
1743: hr_utility.set_location('l_user_column_id_seg'||l_user_column_id_seg, 10);
1744: hr_utility.set_location('l_user_row_id_lev'||l_user_row_id_lev, 10);
1745: hr_utility.set_location('l_user_row_id_func'||l_user_row_id_func, 10);
1746: hr_utility.set_location('g_lev_flex'||g_lev_flex, 10);
1747: hr_utility.set_location('g_Func_flex'||g_Func_flex, 10);
1748: hr_utility.set_location('g_lev_segment'||g_lev_segment, 10);
1749: hr_utility.set_location('g_Func_segment'||g_Func_segment, 10);

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

1742: hr_utility.set_location('l_user_column_id_flex'||l_user_column_id_flex, 10);
1743: hr_utility.set_location('l_user_column_id_seg'||l_user_column_id_seg, 10);
1744: hr_utility.set_location('l_user_row_id_lev'||l_user_row_id_lev, 10);
1745: hr_utility.set_location('l_user_row_id_func'||l_user_row_id_func, 10);
1746: hr_utility.set_location('g_lev_flex'||g_lev_flex, 10);
1747: hr_utility.set_location('g_Func_flex'||g_Func_flex, 10);
1748: hr_utility.set_location('g_lev_segment'||g_lev_segment, 10);
1749: hr_utility.set_location('g_Func_segment'||g_Func_segment, 10);
1750: -- Verify the validity of the segments

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

1743: hr_utility.set_location('l_user_column_id_seg'||l_user_column_id_seg, 10);
1744: hr_utility.set_location('l_user_row_id_lev'||l_user_row_id_lev, 10);
1745: hr_utility.set_location('l_user_row_id_func'||l_user_row_id_func, 10);
1746: hr_utility.set_location('g_lev_flex'||g_lev_flex, 10);
1747: hr_utility.set_location('g_Func_flex'||g_Func_flex, 10);
1748: hr_utility.set_location('g_lev_segment'||g_lev_segment, 10);
1749: hr_utility.set_location('g_Func_segment'||g_Func_segment, 10);
1750: -- Verify the validity of the segments
1751: begin

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

1744: hr_utility.set_location('l_user_row_id_lev'||l_user_row_id_lev, 10);
1745: hr_utility.set_location('l_user_row_id_func'||l_user_row_id_func, 10);
1746: hr_utility.set_location('g_lev_flex'||g_lev_flex, 10);
1747: hr_utility.set_location('g_Func_flex'||g_Func_flex, 10);
1748: hr_utility.set_location('g_lev_segment'||g_lev_segment, 10);
1749: hr_utility.set_location('g_Func_segment'||g_Func_segment, 10);
1750: -- Verify the validity of the segments
1751: begin
1752:

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

1745: hr_utility.set_location('l_user_row_id_func'||l_user_row_id_func, 10);
1746: hr_utility.set_location('g_lev_flex'||g_lev_flex, 10);
1747: hr_utility.set_location('g_Func_flex'||g_Func_flex, 10);
1748: hr_utility.set_location('g_lev_segment'||g_lev_segment, 10);
1749: hr_utility.set_location('g_Func_segment'||g_Func_segment, 10);
1750: -- Verify the validity of the segments
1751: begin
1752:
1753: l_temp := substr(g_lev_segment, 8);

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

4277: begin
4278:
4279: l_cat_index := p_legal_entity_id *100 + nvl(p_occupational_category_id,0);
4280: l_lev_index := p_legal_entity_id *100 + nvl(p_occupational_level_id,0);
4281: hr_utility.set_location('l_cat_index ' || l_cat_index, 25);
4282: hr_utility.set_location('l_lev_index ' || l_lev_index, 25);
4283:
4284: exception
4285: when others then

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

4278:
4279: l_cat_index := p_legal_entity_id *100 + nvl(p_occupational_category_id,0);
4280: l_lev_index := p_legal_entity_id *100 + nvl(p_occupational_level_id,0);
4281: hr_utility.set_location('l_cat_index ' || l_cat_index, 25);
4282: hr_utility.set_location('l_lev_index ' || l_lev_index, 25);
4283:
4284: exception
4285: when others then
4286: 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 4703: --hr_utility.trace_on(null,'ZAEID');

4699: l_era_balance_type_id pay_balance_types.balance_type_id%type;
4700:
4701:
4702: begin
4703: --hr_utility.trace_on(null,'ZAEID');
4704: reset_tables;
4705: hr_utility.set_location('Entering ' || l_proc, 10);
4706:
4707: -- Determine whether we need to populate the cache tables

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

4701:
4702: begin
4703: --hr_utility.trace_on(null,'ZAEID');
4704: reset_tables;
4705: hr_utility.set_location('Entering ' || l_proc, 10);
4706:
4707: -- Determine whether we need to populate the cache tables
4708: -- Note: No check is made for the validity of the table data, since it is assumed that the
4709: -- reset_tables procedure was called before this procedure.

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

4708: -- Note: No check is made for the validity of the table data, since it is assumed that the
4709: -- reset_tables procedure was called before this procedure.
4710: if g_assignments_table.count = 0 then
4711:
4712: hr_utility.set_location('Setup assignments cache', 20);
4713: g_assignments_table.delete;
4714:
4715: if p_salary_method = 'BAL' then
4716:

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

4782:
4783: -- Loop through the assignments cursor and populate the assignments table
4784: for l_assignment in c_assignments loop
4785:
4786: hr_utility.set_location('ASG ' || l_assignment.assignment_id, 21);
4787:
4788: -- Bug 4413678: Begin
4789: Select per_information4, papf.sex
4790: into l_race, l_sex

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

4803: g_assignments_table(l_assignment.assignment_id).occupational_category_ID := l_assignment.occupational_category_id;
4804: g_assignments_table(l_assignment.assignment_id).occupational_level_id := l_assignment.occupational_level_id;
4805: g_assignments_table(l_assignment.assignment_id).race := l_race;
4806: g_assignments_table(l_assignment.assignment_id).sex := l_sex;
4807: hr_utility.set_location('LEGENT ' || l_assignment.aei_information7, 22);
4808:
4809: -- Check for a new payroll_id and cache the new payroll details in the payrolls table
4810: if l_assignment.payroll_id <> l_old_payroll_id then
4811:

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

4881: l_old_payroll_id := l_assignment.payroll_id;
4882:
4883: end if;
4884:
4885: -- hr_utility.set_location('REP_START ' || to_char(l_report_start, 'DD\MM\YYYY'), 22);
4886: -- hr_utility.set_location('REP_END ' || to_char(l_report_end, 'DD\MM\YYYY'), 23);
4887: -- hr_utility.set_location('FREQ ' || l_period_frequency, 24);
4888:
4889: if p_salary_method = 'BAL' then

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

4882:
4883: end if;
4884:
4885: -- hr_utility.set_location('REP_START ' || to_char(l_report_start, 'DD\MM\YYYY'), 22);
4886: -- hr_utility.set_location('REP_END ' || to_char(l_report_end, 'DD\MM\YYYY'), 23);
4887: -- hr_utility.set_location('FREQ ' || l_period_frequency, 24);
4888:
4889: if p_salary_method = 'BAL' then
4890:

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

4883: end if;
4884:
4885: -- hr_utility.set_location('REP_START ' || to_char(l_report_start, 'DD\MM\YYYY'), 22);
4886: -- hr_utility.set_location('REP_END ' || to_char(l_report_end, 'DD\MM\YYYY'), 23);
4887: -- hr_utility.set_location('FREQ ' || l_period_frequency, 24);
4888:
4889: if p_salary_method = 'BAL' then
4890:
4891: /* Bug 8911880

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

4896: p_report_start => l_report_start,
4897: p_report_end => l_report_end
4898: );
4899:
4900: hr_utility.set_location('ACT_DAYS ' || l_active_days, 25);
4901: */
4902:
4903: -- Get the Employment Equitable Income
4904: begin

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

5030:
5031: end;
5032:
5033:
5034: hr_utility.set_location('EE_INC ' || l_ee_income, 26);
5035: hr_utility.set_location('EE_ANN ' || l_ee_annual_income, 27);
5036: hr_utility.set_location('ER_INC ' || l_er_income, 26);
5037: hr_utility.set_location('ER_ANN ' || l_er_annual_income, 27);
5038:

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

5031: end;
5032:
5033:
5034: hr_utility.set_location('EE_INC ' || l_ee_income, 26);
5035: hr_utility.set_location('EE_ANN ' || l_ee_annual_income, 27);
5036: hr_utility.set_location('ER_INC ' || l_er_income, 26);
5037: hr_utility.set_location('ER_ANN ' || l_er_annual_income, 27);
5038:
5039: -- hr_utility.set_location('STminEND ' || (l_report_end - l_report_start + 1), 28);

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

5032:
5033:
5034: hr_utility.set_location('EE_INC ' || l_ee_income, 26);
5035: hr_utility.set_location('EE_ANN ' || l_ee_annual_income, 27);
5036: hr_utility.set_location('ER_INC ' || l_er_income, 26);
5037: hr_utility.set_location('ER_ANN ' || l_er_annual_income, 27);
5038:
5039: -- hr_utility.set_location('STminEND ' || (l_report_end - l_report_start + 1), 28);
5040:

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

5033:
5034: hr_utility.set_location('EE_INC ' || l_ee_income, 26);
5035: hr_utility.set_location('EE_ANN ' || l_ee_annual_income, 27);
5036: hr_utility.set_location('ER_INC ' || l_er_income, 26);
5037: hr_utility.set_location('ER_ANN ' || l_er_annual_income, 27);
5038:
5039: -- hr_utility.set_location('STminEND ' || (l_report_end - l_report_start + 1), 28);
5040:
5041: -- Calculate the annual income = annualize normal income + annual income

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

5035: hr_utility.set_location('EE_ANN ' || l_ee_annual_income, 27);
5036: hr_utility.set_location('ER_INC ' || l_er_income, 26);
5037: hr_utility.set_location('ER_ANN ' || l_er_annual_income, 27);
5038:
5039: -- hr_utility.set_location('STminEND ' || (l_report_end - l_report_start + 1), 28);
5040:
5041: -- Calculate the annual income = annualize normal income + annual income
5042: g_assignments_table(l_assignment.assignment_id).annual_income :=
5043: l_ee_income + l_er_income + l_ee_annual_income + l_er_annual_income;

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

5041: -- Calculate the annual income = annualize normal income + annual income
5042: g_assignments_table(l_assignment.assignment_id).annual_income :=
5043: l_ee_income + l_er_income + l_ee_annual_income + l_er_annual_income;
5044:
5045: hr_utility.set_location('ANSWER ' || g_assignments_table(l_assignment.assignment_id).annual_income, 29);
5046:
5047: elsif p_salary_method = 'SAL' then
5048:
5049: -- Get the annual salary basis for the current period

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

5106: -- The index is calculted by multiplying the legal entity id by 100 and then adding the lookup code
5107: -- This should always give a unique value, since the lookup code is less than 100
5108: -- Start of adding for Employment Equity Report Enhancement Inserting values in table.
5109: l_rowind := g_assignments_table.first;
5110: hr_utility.set_location ('l_rowind :=' || l_rowind, 20);
5111: loop
5112: exit when l_rowind is null;
5113:
5114: hr_utility.set_location ('g_assignments_table(l_rowind).legal_entity_id' ||g_assignments_table(l_rowind).legal_entity_id, 20);

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

5110: hr_utility.set_location ('l_rowind :=' || l_rowind, 20);
5111: loop
5112: exit when l_rowind is null;
5113:
5114: hr_utility.set_location ('g_assignments_table(l_rowind).legal_entity_id' ||g_assignments_table(l_rowind).legal_entity_id, 20);
5115: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).occupational_level, 20);
5116: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).occupational_category, 20);
5117: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).race, 20);
5118: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).sex, 20);

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

5111: loop
5112: exit when l_rowind is null;
5113:
5114: hr_utility.set_location ('g_assignments_table(l_rowind).legal_entity_id' ||g_assignments_table(l_rowind).legal_entity_id, 20);
5115: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).occupational_level, 20);
5116: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).occupational_category, 20);
5117: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).race, 20);
5118: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).sex, 20);
5119: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).annual_income, 20);

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

5112: exit when l_rowind is null;
5113:
5114: hr_utility.set_location ('g_assignments_table(l_rowind).legal_entity_id' ||g_assignments_table(l_rowind).legal_entity_id, 20);
5115: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).occupational_level, 20);
5116: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).occupational_category, 20);
5117: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).race, 20);
5118: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).sex, 20);
5119: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).annual_income, 20);
5120:

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

5113:
5114: hr_utility.set_location ('g_assignments_table(l_rowind).legal_entity_id' ||g_assignments_table(l_rowind).legal_entity_id, 20);
5115: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).occupational_level, 20);
5116: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).occupational_category, 20);
5117: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).race, 20);
5118: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).sex, 20);
5119: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).annual_income, 20);
5120:
5121: cat_lev_data( g_assignments_table(l_rowind).legal_entity_id

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

5114: hr_utility.set_location ('g_assignments_table(l_rowind).legal_entity_id' ||g_assignments_table(l_rowind).legal_entity_id, 20);
5115: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).occupational_level, 20);
5116: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).occupational_category, 20);
5117: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).race, 20);
5118: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).sex, 20);
5119: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).annual_income, 20);
5120:
5121: cat_lev_data( g_assignments_table(l_rowind).legal_entity_id
5122: , g_assignments_table(l_rowind).occupational_level

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

5115: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).occupational_level, 20);
5116: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).occupational_category, 20);
5117: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).race, 20);
5118: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).sex, 20);
5119: hr_utility.set_location ('l_rowind :=' || g_assignments_table(l_rowind).annual_income, 20);
5120:
5121: cat_lev_data( g_assignments_table(l_rowind).legal_entity_id
5122: , g_assignments_table(l_rowind).occupational_level
5123: , g_assignments_table(l_rowind).occupational_category

Line 5314: --hr_utility.trace_off;

5310: Where haou.organization_id = g_lev_Enc_Diff_table(l_rowind).legal_entity_id;
5311:
5312: l_rowind := g_lev_Enc_Diff_table.next(l_rowind);
5313: END loop;
5314: --hr_utility.trace_off;
5315:
5316: -- Inserts non-associated occupational categories with zero values for no of employees
5317: insert into per_za_employment_equity
5318: (

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

5544: l_proc constant varchar2(60) := g_package || 'reset_new_tables';
5545:
5546: begin
5547:
5548: -- hr_utility.trace_on(null, 'T');
5549: g_new_assignments_table.delete;
5550: g_all_high_avg := -9999;
5551: g_all_low_avg := -9999;
5552: g_cat_averages_table.delete;

Line 5597: hr_utility.set_location('Entered ins_g_Enc_Diff_table',10);

5593: ) is
5594:
5595: begin
5596:
5597: hr_utility.set_location('Entered ins_g_Enc_Diff_table',10);
5598:
5599: --Occupational levels
5600: IF p_table.EXISTS(p_lev_index) then
5601: p_table(p_lev_index).mi_inc := p_table(p_lev_index).mi_inc + p_mi_inc ;

Line 5664: hr_utility.set_location('Entered cat_lev_data',25);

5660: l_lev_index pls_integer ;
5661: begin
5662:
5663: begin
5664: hr_utility.set_location('Entered cat_lev_data',25);
5665: l_cat_index := p_legal_entity_id *100 + nvl(p_occupational_category_id,0);
5666: l_lev_index := p_legal_entity_id *100 + nvl(p_occupational_level_id,0);
5667: hr_utility.set_location('l_cat_index ' || l_cat_index, 25);
5668: hr_utility.set_location('l_lev_index ' || l_lev_index, 25);

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

5663: begin
5664: hr_utility.set_location('Entered cat_lev_data',25);
5665: l_cat_index := p_legal_entity_id *100 + nvl(p_occupational_category_id,0);
5666: l_lev_index := p_legal_entity_id *100 + nvl(p_occupational_level_id,0);
5667: hr_utility.set_location('l_cat_index ' || l_cat_index, 25);
5668: hr_utility.set_location('l_lev_index ' || l_lev_index, 25);
5669:
5670:
5671: exception

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

5664: hr_utility.set_location('Entered cat_lev_data',25);
5665: l_cat_index := p_legal_entity_id *100 + nvl(p_occupational_category_id,0);
5666: l_lev_index := p_legal_entity_id *100 + nvl(p_occupational_level_id,0);
5667: hr_utility.set_location('l_cat_index ' || l_cat_index, 25);
5668: hr_utility.set_location('l_lev_index ' || l_lev_index, 25);
5669:
5670:
5671: exception
5672: when others then

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

6093: l_type varchar2(5);
6094:
6095:
6096: begin
6097: --hr_utility.trace_on(null,'ZAEID');
6098: reset_new_tables;
6099: hr_utility.set_location('Entering ' || l_proc, 10);
6100:
6101: -- Determine whether we need to populate the cache tables

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

6095:
6096: begin
6097: --hr_utility.trace_on(null,'ZAEID');
6098: reset_new_tables;
6099: hr_utility.set_location('Entering ' || l_proc, 10);
6100:
6101: -- Determine whether we need to populate the cache tables
6102: -- Note: No check is made for the validity of the table data, since it is assumed that the
6103: -- reset_tables procedure was called before this procedure.

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

6102: -- Note: No check is made for the validity of the table data, since it is assumed that the
6103: -- reset_tables procedure was called before this procedure.
6104: if g_new_assignments_table.count = 0 then
6105:
6106: hr_utility.set_location('Setup assignments cache', 20);
6107: g_new_assignments_table.delete;
6108:
6109: if p_salary_method = 'BAL' then
6110:

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

6176:
6177: -- Loop through the assignments cursor and populate the assignments table
6178: for l_assignment in c_assignments loop
6179:
6180: hr_utility.set_location('ASG ' || l_assignment.assignment_id, 21);
6181:
6182: -- Bug 4413678: Begin
6183: --Added for Year 2009
6184: --If date of naturalization is on or after 27-APR-94 , then foreign national

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

6208: g_new_assignments_table(l_assignment.assignment_id).sex := l_sex;
6209: g_new_assignments_table(l_assignment.assignment_id).foreigner := l_type;
6210: g_new_assignments_table(l_assignment.assignment_id).employment_type := l_assignment.employment_type;
6211:
6212: hr_utility.set_location('LEGENT ' || l_assignment.aei_information7, 22);
6213:
6214: -- Check for a new payroll_id and cache the new payroll details in the payrolls table
6215: if l_assignment.payroll_id <> l_old_payroll_id then
6216:

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

6286: l_old_payroll_id := l_assignment.payroll_id;
6287:
6288: end if;
6289:
6290: -- hr_utility.set_location('REP_START ' || to_char(l_report_start, 'DD\MM\YYYY'), 22);
6291: -- hr_utility.set_location('REP_END ' || to_char(l_report_end, 'DD\MM\YYYY'), 23);
6292: -- hr_utility.set_location('FREQ ' || l_period_frequency, 24);
6293:
6294: if p_salary_method = 'BAL' then

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

6287:
6288: end if;
6289:
6290: -- hr_utility.set_location('REP_START ' || to_char(l_report_start, 'DD\MM\YYYY'), 22);
6291: -- hr_utility.set_location('REP_END ' || to_char(l_report_end, 'DD\MM\YYYY'), 23);
6292: -- hr_utility.set_location('FREQ ' || l_period_frequency, 24);
6293:
6294: if p_salary_method = 'BAL' then
6295:

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

6288: end if;
6289:
6290: -- hr_utility.set_location('REP_START ' || to_char(l_report_start, 'DD\MM\YYYY'), 22);
6291: -- hr_utility.set_location('REP_END ' || to_char(l_report_end, 'DD\MM\YYYY'), 23);
6292: -- hr_utility.set_location('FREQ ' || l_period_frequency, 24);
6293:
6294: if p_salary_method = 'BAL' then
6295:
6296: /* Bug 8911880

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

6301: p_report_start => l_report_start,
6302: p_report_end => l_report_end
6303: );
6304:
6305: hr_utility.set_location('ACT_DAYS ' || l_active_days, 25);
6306: */
6307:
6308: -- Get the Employment Equitable Income
6309: begin

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

6435:
6436: end;
6437:
6438:
6439: hr_utility.set_location('EE_INC ' || l_ee_income, 26);
6440: hr_utility.set_location('EE_ANN ' || l_ee_annual_income, 27);
6441: hr_utility.set_location('ER_INC ' || l_er_income, 26);
6442: hr_utility.set_location('ER_ANN ' || l_er_annual_income, 27);
6443:

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

6436: end;
6437:
6438:
6439: hr_utility.set_location('EE_INC ' || l_ee_income, 26);
6440: hr_utility.set_location('EE_ANN ' || l_ee_annual_income, 27);
6441: hr_utility.set_location('ER_INC ' || l_er_income, 26);
6442: hr_utility.set_location('ER_ANN ' || l_er_annual_income, 27);
6443:
6444: -- hr_utility.set_location('STminEND ' || (l_report_end - l_report_start + 1), 28);

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

6437:
6438:
6439: hr_utility.set_location('EE_INC ' || l_ee_income, 26);
6440: hr_utility.set_location('EE_ANN ' || l_ee_annual_income, 27);
6441: hr_utility.set_location('ER_INC ' || l_er_income, 26);
6442: hr_utility.set_location('ER_ANN ' || l_er_annual_income, 27);
6443:
6444: -- hr_utility.set_location('STminEND ' || (l_report_end - l_report_start + 1), 28);
6445:

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

6438:
6439: hr_utility.set_location('EE_INC ' || l_ee_income, 26);
6440: hr_utility.set_location('EE_ANN ' || l_ee_annual_income, 27);
6441: hr_utility.set_location('ER_INC ' || l_er_income, 26);
6442: hr_utility.set_location('ER_ANN ' || l_er_annual_income, 27);
6443:
6444: -- hr_utility.set_location('STminEND ' || (l_report_end - l_report_start + 1), 28);
6445:
6446: -- Calculate the annual income = annualize normal income + annual income

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

6440: hr_utility.set_location('EE_ANN ' || l_ee_annual_income, 27);
6441: hr_utility.set_location('ER_INC ' || l_er_income, 26);
6442: hr_utility.set_location('ER_ANN ' || l_er_annual_income, 27);
6443:
6444: -- hr_utility.set_location('STminEND ' || (l_report_end - l_report_start + 1), 28);
6445:
6446: -- Calculate the annual income = annualize normal income + annual income
6447: g_new_assignments_table(l_assignment.assignment_id).annual_income :=
6448: l_ee_income + l_er_income + l_ee_annual_income + l_er_annual_income;

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

6446: -- Calculate the annual income = annualize normal income + annual income
6447: g_new_assignments_table(l_assignment.assignment_id).annual_income :=
6448: l_ee_income + l_er_income + l_ee_annual_income + l_er_annual_income;
6449:
6450: hr_utility.set_location('ANSWER ' || g_new_assignments_table(l_assignment.assignment_id).annual_income, 29);
6451:
6452: elsif p_salary_method = 'SAL' then
6453:
6454: -- Get the annual salary basis for the current period

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

6522: -- The index is calculted by multiplying the legal entity id by 100 and then adding the lookup code
6523: -- This should always give a unique value, since the lookup code is less than 100
6524: -- Start of adding for Employment Equity Report Enhancement Inserting values in table.
6525: l_rowind := g_new_assignments_table.first;
6526: hr_utility.set_location ('l_rowind :=' || l_rowind, 20);
6527: loop
6528: exit when l_rowind is null;
6529:
6530: hr_utility.set_location ('g_new_assignments_table(l_rowind).legal_entity_id' ||g_new_assignments_table(l_rowind).legal_entity_id, 20);

Line 6530: hr_utility.set_location ('g_new_assignments_table(l_rowind).legal_entity_id' ||g_new_assignments_table(l_rowind).legal_entity_id, 20);

6526: hr_utility.set_location ('l_rowind :=' || l_rowind, 20);
6527: loop
6528: exit when l_rowind is null;
6529:
6530: hr_utility.set_location ('g_new_assignments_table(l_rowind).legal_entity_id' ||g_new_assignments_table(l_rowind).legal_entity_id, 20);
6531: hr_utility.set_location ('occupational_level :=' || g_new_assignments_table(l_rowind).occupational_level, 20);
6532: hr_utility.set_location ('occupational_category :=' || g_new_assignments_table(l_rowind).occupational_category, 20);
6533: hr_utility.set_location ('race :=' || g_new_assignments_table(l_rowind).race, 20);
6534: hr_utility.set_location ('sex :=' || g_new_assignments_table(l_rowind).sex, 20);

Line 6531: hr_utility.set_location ('occupational_level :=' || g_new_assignments_table(l_rowind).occupational_level, 20);

6527: loop
6528: exit when l_rowind is null;
6529:
6530: hr_utility.set_location ('g_new_assignments_table(l_rowind).legal_entity_id' ||g_new_assignments_table(l_rowind).legal_entity_id, 20);
6531: hr_utility.set_location ('occupational_level :=' || g_new_assignments_table(l_rowind).occupational_level, 20);
6532: hr_utility.set_location ('occupational_category :=' || g_new_assignments_table(l_rowind).occupational_category, 20);
6533: hr_utility.set_location ('race :=' || g_new_assignments_table(l_rowind).race, 20);
6534: hr_utility.set_location ('sex :=' || g_new_assignments_table(l_rowind).sex, 20);
6535: hr_utility.set_location ('employment_type :=' || g_new_assignments_table(l_rowind).employment_type, 20);

Line 6532: hr_utility.set_location ('occupational_category :=' || g_new_assignments_table(l_rowind).occupational_category, 20);

6528: exit when l_rowind is null;
6529:
6530: hr_utility.set_location ('g_new_assignments_table(l_rowind).legal_entity_id' ||g_new_assignments_table(l_rowind).legal_entity_id, 20);
6531: hr_utility.set_location ('occupational_level :=' || g_new_assignments_table(l_rowind).occupational_level, 20);
6532: hr_utility.set_location ('occupational_category :=' || g_new_assignments_table(l_rowind).occupational_category, 20);
6533: hr_utility.set_location ('race :=' || g_new_assignments_table(l_rowind).race, 20);
6534: hr_utility.set_location ('sex :=' || g_new_assignments_table(l_rowind).sex, 20);
6535: hr_utility.set_location ('employment_type :=' || g_new_assignments_table(l_rowind).employment_type, 20);
6536: hr_utility.set_location ('foreigner :=' || g_new_assignments_table(l_rowind).foreigner, 20);

Line 6533: hr_utility.set_location ('race :=' || g_new_assignments_table(l_rowind).race, 20);

6529:
6530: hr_utility.set_location ('g_new_assignments_table(l_rowind).legal_entity_id' ||g_new_assignments_table(l_rowind).legal_entity_id, 20);
6531: hr_utility.set_location ('occupational_level :=' || g_new_assignments_table(l_rowind).occupational_level, 20);
6532: hr_utility.set_location ('occupational_category :=' || g_new_assignments_table(l_rowind).occupational_category, 20);
6533: hr_utility.set_location ('race :=' || g_new_assignments_table(l_rowind).race, 20);
6534: hr_utility.set_location ('sex :=' || g_new_assignments_table(l_rowind).sex, 20);
6535: hr_utility.set_location ('employment_type :=' || g_new_assignments_table(l_rowind).employment_type, 20);
6536: hr_utility.set_location ('foreigner :=' || g_new_assignments_table(l_rowind).foreigner, 20);
6537: hr_utility.set_location ('assignment_id :=' || l_rowind, 20);

Line 6534: hr_utility.set_location ('sex :=' || g_new_assignments_table(l_rowind).sex, 20);

6530: hr_utility.set_location ('g_new_assignments_table(l_rowind).legal_entity_id' ||g_new_assignments_table(l_rowind).legal_entity_id, 20);
6531: hr_utility.set_location ('occupational_level :=' || g_new_assignments_table(l_rowind).occupational_level, 20);
6532: hr_utility.set_location ('occupational_category :=' || g_new_assignments_table(l_rowind).occupational_category, 20);
6533: hr_utility.set_location ('race :=' || g_new_assignments_table(l_rowind).race, 20);
6534: hr_utility.set_location ('sex :=' || g_new_assignments_table(l_rowind).sex, 20);
6535: hr_utility.set_location ('employment_type :=' || g_new_assignments_table(l_rowind).employment_type, 20);
6536: hr_utility.set_location ('foreigner :=' || g_new_assignments_table(l_rowind).foreigner, 20);
6537: hr_utility.set_location ('assignment_id :=' || l_rowind, 20);
6538:

Line 6535: hr_utility.set_location ('employment_type :=' || g_new_assignments_table(l_rowind).employment_type, 20);

6531: hr_utility.set_location ('occupational_level :=' || g_new_assignments_table(l_rowind).occupational_level, 20);
6532: hr_utility.set_location ('occupational_category :=' || g_new_assignments_table(l_rowind).occupational_category, 20);
6533: hr_utility.set_location ('race :=' || g_new_assignments_table(l_rowind).race, 20);
6534: hr_utility.set_location ('sex :=' || g_new_assignments_table(l_rowind).sex, 20);
6535: hr_utility.set_location ('employment_type :=' || g_new_assignments_table(l_rowind).employment_type, 20);
6536: hr_utility.set_location ('foreigner :=' || g_new_assignments_table(l_rowind).foreigner, 20);
6537: hr_utility.set_location ('assignment_id :=' || l_rowind, 20);
6538:
6539: if g_new_assignments_table(l_rowind).employment_type='Permanent' then

Line 6536: hr_utility.set_location ('foreigner :=' || g_new_assignments_table(l_rowind).foreigner, 20);

6532: hr_utility.set_location ('occupational_category :=' || g_new_assignments_table(l_rowind).occupational_category, 20);
6533: hr_utility.set_location ('race :=' || g_new_assignments_table(l_rowind).race, 20);
6534: hr_utility.set_location ('sex :=' || g_new_assignments_table(l_rowind).sex, 20);
6535: hr_utility.set_location ('employment_type :=' || g_new_assignments_table(l_rowind).employment_type, 20);
6536: hr_utility.set_location ('foreigner :=' || g_new_assignments_table(l_rowind).foreigner, 20);
6537: hr_utility.set_location ('assignment_id :=' || l_rowind, 20);
6538:
6539: if g_new_assignments_table(l_rowind).employment_type='Permanent' then
6540: if g_new_assignments_table(l_rowind).foreigner is null then

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

6533: hr_utility.set_location ('race :=' || g_new_assignments_table(l_rowind).race, 20);
6534: hr_utility.set_location ('sex :=' || g_new_assignments_table(l_rowind).sex, 20);
6535: hr_utility.set_location ('employment_type :=' || g_new_assignments_table(l_rowind).employment_type, 20);
6536: hr_utility.set_location ('foreigner :=' || g_new_assignments_table(l_rowind).foreigner, 20);
6537: hr_utility.set_location ('assignment_id :=' || l_rowind, 20);
6538:
6539: if g_new_assignments_table(l_rowind).employment_type='Permanent' then
6540: if g_new_assignments_table(l_rowind).foreigner is null then
6541: --Permanent non foreigner

Line 6542: hr_utility.set_location('Populating permanent non foreigner',25);

6538:
6539: if g_new_assignments_table(l_rowind).employment_type='Permanent' then
6540: if g_new_assignments_table(l_rowind).foreigner is null then
6541: --Permanent non foreigner
6542: hr_utility.set_location('Populating permanent non foreigner',25);
6543: cat_lev_data( g_new_assignments_table(l_rowind).legal_entity_id
6544: , g_new_assignments_table(l_rowind).occupational_level
6545: , g_new_assignments_table(l_rowind).occupational_category
6546: , g_new_assignments_table(l_rowind).race

Line 6555: hr_utility.set_location('Populating permanent foreigner',25);

6551: , g_lev_Enc_Diff_table
6552: );
6553: else
6554: --Permanent foreigner
6555: hr_utility.set_location('Populating permanent foreigner',25);
6556: cat_lev_data( g_new_assignments_table(l_rowind).legal_entity_id
6557: , g_new_assignments_table(l_rowind).occupational_level
6558: , g_new_assignments_table(l_rowind).occupational_category
6559: , g_new_assignments_table(l_rowind).race

Line 6570: hr_utility.set_location('Populating non permanent non foreigner',25);

6566: end if;
6567: else --Non permanent
6568: if g_new_assignments_table(l_rowind).foreigner is null then
6569: --Non Permanent non foreigner
6570: hr_utility.set_location('Populating non permanent non foreigner',25);
6571: cat_lev_data( g_new_assignments_table(l_rowind).legal_entity_id
6572: , g_new_assignments_table(l_rowind).occupational_level
6573: , g_new_assignments_table(l_rowind).occupational_category
6574: , g_new_assignments_table(l_rowind).race

Line 6583: hr_utility.set_location('Populating non permanent foreigner',25);

6579: , g_lev_Enc_Diff_table_T
6580: );
6581: else
6582: --Non Permanent foreigner
6583: hr_utility.set_location('Populating non permanent foreigner',25);
6584: cat_lev_data( g_new_assignments_table(l_rowind).legal_entity_id
6585: , g_new_assignments_table(l_rowind).occupational_level
6586: , g_new_assignments_table(l_rowind).occupational_category
6587: , g_new_assignments_table(l_rowind).race

Line 6965: --hr_utility.trace_off;

6961: Where haou.organization_id = g_lev_Enc_Diff_table_TF(l_rowind).legal_entity_id;
6962:
6963: l_rowind := g_lev_Enc_Diff_table_TF.next(l_rowind);
6964: END loop;
6965: --hr_utility.trace_off;
6966:
6967:
6968: -- inserting 0 values for the no of employees
6969: insert into per_za_employment_equity