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.

[Home] [Help]

APPS.PER_CA_EE_EXTRACT_PKG dependencies on HR_UTILITY

Line 360: hr_utility.trace('Function check_gre_without_naic starte Here !!!!!');

356: j number := 1;
357:
358: begin
359:
360: hr_utility.trace('Function check_gre_without_naic starte Here !!!!!');
361:
362: for i in cur_gre_without_naic loop
363:
364: p_gre_name(j) := i.gre_name;

Line 842: --hr_utility.trace_on(1,'pg');

838: hoi.org_information8 = p_naic;
839:
840: begin
841:
842: --hr_utility.trace_on(1,'pg');
843:
844: open cur_org_info;
845: fetch cur_org_info into
846: v_name,

Line 1014: hr_utility.trace('Form1: Employment Category: ' || i.employment_category);

1010:
1011:
1012: elsif i.employment_category = 'PT' then
1013:
1014: hr_utility.trace('Form1: Employment Category: ' || i.employment_category);
1015:
1016: update per_ca_ee_report_lines set
1017: segment15 = i.count_category
1018: where request_id = p_request_id and

Line 1549: hr_utility.trace('Form2n starts Here !!!!!!!');

1545:
1546: if ( ( v_max_naic_flag = 'Y' ) OR
1547: (to_number(v_tot_number_emp) >= to_number(v_leg_info)) ) then
1548:
1549: hr_utility.trace('Form2n starts Here !!!!!!!');
1550:
1551: for i in cur_min_max loop
1552:
1553: v_max_salary := nvl(to_number(i.max_salary),0);

Line 1558: hr_utility.trace('Form2: v_max_salary: ' || to_char(v_max_salary));

1554: v_min_salary := nvl(to_number(i.min_salary),0);
1555: v_meaning := i.meaning;
1556: v_employment_category := i.employment_category;
1557:
1558: hr_utility.trace('Form2: v_max_salary: ' || to_char(v_max_salary));
1559: hr_utility.trace('Form2: v_min_salary: ' || to_char(v_min_salary));
1560: hr_utility.trace('Form2: v_meaning: ' || v_meaning);
1561: hr_utility.trace('Form2: v_employment_category: '||v_employment_category);
1562:

Line 1559: hr_utility.trace('Form2: v_min_salary: ' || to_char(v_min_salary));

1555: v_meaning := i.meaning;
1556: v_employment_category := i.employment_category;
1557:
1558: hr_utility.trace('Form2: v_max_salary: ' || to_char(v_max_salary));
1559: hr_utility.trace('Form2: v_min_salary: ' || to_char(v_min_salary));
1560: hr_utility.trace('Form2: v_meaning: ' || v_meaning);
1561: hr_utility.trace('Form2: v_employment_category: '||v_employment_category);
1562:
1563: -- To check the salary range in the predefined

Line 1560: hr_utility.trace('Form2: v_meaning: ' || v_meaning);

1556: v_employment_category := i.employment_category;
1557:
1558: hr_utility.trace('Form2: v_max_salary: ' || to_char(v_max_salary));
1559: hr_utility.trace('Form2: v_min_salary: ' || to_char(v_min_salary));
1560: hr_utility.trace('Form2: v_meaning: ' || v_meaning);
1561: hr_utility.trace('Form2: v_employment_category: '||v_employment_category);
1562:
1563: -- To check the salary range in the predefined
1564: -- salary ranges

Line 1561: hr_utility.trace('Form2: v_employment_category: '||v_employment_category);

1557:
1558: hr_utility.trace('Form2: v_max_salary: ' || to_char(v_max_salary));
1559: hr_utility.trace('Form2: v_min_salary: ' || to_char(v_min_salary));
1560: hr_utility.trace('Form2: v_meaning: ' || v_meaning);
1561: hr_utility.trace('Form2: v_employment_category: '||v_employment_category);
1562:
1563: -- To check the salary range in the predefined
1564: -- salary ranges
1565:

Line 1793: hr_utility.trace('Form2: v_q1_min: ' ||to_char(v_q1_min));

1789:
1790: v_q4_min := v_q3_max + 1;
1791: v_q4_max := v_q4_min + v_range -1;
1792:
1793: hr_utility.trace('Form2: v_q1_min: ' ||to_char(v_q1_min));
1794: hr_utility.trace('Form2: v_q1_max: ' ||to_char(v_q1_max));
1795: hr_utility.trace('Form2: v_q2_min: ' ||to_char(v_q2_min));
1796: hr_utility.trace('Form2: v_q2_max: ' ||to_char(v_q2_max));
1797: hr_utility.trace('Form2: v_q3_min: ' ||to_char(v_q3_min));

Line 1794: hr_utility.trace('Form2: v_q1_max: ' ||to_char(v_q1_max));

1790: v_q4_min := v_q3_max + 1;
1791: v_q4_max := v_q4_min + v_range -1;
1792:
1793: hr_utility.trace('Form2: v_q1_min: ' ||to_char(v_q1_min));
1794: hr_utility.trace('Form2: v_q1_max: ' ||to_char(v_q1_max));
1795: hr_utility.trace('Form2: v_q2_min: ' ||to_char(v_q2_min));
1796: hr_utility.trace('Form2: v_q2_max: ' ||to_char(v_q2_max));
1797: hr_utility.trace('Form2: v_q3_min: ' ||to_char(v_q3_min));
1798: hr_utility.trace('Form2: v_q3_max: ' ||to_char(v_q3_max));

Line 1795: hr_utility.trace('Form2: v_q2_min: ' ||to_char(v_q2_min));

1791: v_q4_max := v_q4_min + v_range -1;
1792:
1793: hr_utility.trace('Form2: v_q1_min: ' ||to_char(v_q1_min));
1794: hr_utility.trace('Form2: v_q1_max: ' ||to_char(v_q1_max));
1795: hr_utility.trace('Form2: v_q2_min: ' ||to_char(v_q2_min));
1796: hr_utility.trace('Form2: v_q2_max: ' ||to_char(v_q2_max));
1797: hr_utility.trace('Form2: v_q3_min: ' ||to_char(v_q3_min));
1798: hr_utility.trace('Form2: v_q3_max: ' ||to_char(v_q3_max));
1799: hr_utility.trace('Form2: v_q4_min: ' ||to_char(v_q4_min));

Line 1796: hr_utility.trace('Form2: v_q2_max: ' ||to_char(v_q2_max));

1792:
1793: hr_utility.trace('Form2: v_q1_min: ' ||to_char(v_q1_min));
1794: hr_utility.trace('Form2: v_q1_max: ' ||to_char(v_q1_max));
1795: hr_utility.trace('Form2: v_q2_min: ' ||to_char(v_q2_min));
1796: hr_utility.trace('Form2: v_q2_max: ' ||to_char(v_q2_max));
1797: hr_utility.trace('Form2: v_q3_min: ' ||to_char(v_q3_min));
1798: hr_utility.trace('Form2: v_q3_max: ' ||to_char(v_q3_max));
1799: hr_utility.trace('Form2: v_q4_min: ' ||to_char(v_q4_min));
1800: hr_utility.trace('Form2: v_q4_max: ' ||to_char(v_q4_max));

Line 1797: hr_utility.trace('Form2: v_q3_min: ' ||to_char(v_q3_min));

1793: hr_utility.trace('Form2: v_q1_min: ' ||to_char(v_q1_min));
1794: hr_utility.trace('Form2: v_q1_max: ' ||to_char(v_q1_max));
1795: hr_utility.trace('Form2: v_q2_min: ' ||to_char(v_q2_min));
1796: hr_utility.trace('Form2: v_q2_max: ' ||to_char(v_q2_max));
1797: hr_utility.trace('Form2: v_q3_min: ' ||to_char(v_q3_min));
1798: hr_utility.trace('Form2: v_q3_max: ' ||to_char(v_q3_max));
1799: hr_utility.trace('Form2: v_q4_min: ' ||to_char(v_q4_min));
1800: hr_utility.trace('Form2: v_q4_max: ' ||to_char(v_q4_max));
1801:

Line 1798: hr_utility.trace('Form2: v_q3_max: ' ||to_char(v_q3_max));

1794: hr_utility.trace('Form2: v_q1_max: ' ||to_char(v_q1_max));
1795: hr_utility.trace('Form2: v_q2_min: ' ||to_char(v_q2_min));
1796: hr_utility.trace('Form2: v_q2_max: ' ||to_char(v_q2_max));
1797: hr_utility.trace('Form2: v_q3_min: ' ||to_char(v_q3_min));
1798: hr_utility.trace('Form2: v_q3_max: ' ||to_char(v_q3_max));
1799: hr_utility.trace('Form2: v_q4_min: ' ||to_char(v_q4_min));
1800: hr_utility.trace('Form2: v_q4_max: ' ||to_char(v_q4_max));
1801:
1802: for j in 1..4 loop

Line 1799: hr_utility.trace('Form2: v_q4_min: ' ||to_char(v_q4_min));

1795: hr_utility.trace('Form2: v_q2_min: ' ||to_char(v_q2_min));
1796: hr_utility.trace('Form2: v_q2_max: ' ||to_char(v_q2_max));
1797: hr_utility.trace('Form2: v_q3_min: ' ||to_char(v_q3_min));
1798: hr_utility.trace('Form2: v_q3_max: ' ||to_char(v_q3_max));
1799: hr_utility.trace('Form2: v_q4_min: ' ||to_char(v_q4_min));
1800: hr_utility.trace('Form2: v_q4_max: ' ||to_char(v_q4_max));
1801:
1802: for j in 1..4 loop
1803:

Line 1800: hr_utility.trace('Form2: v_q4_max: ' ||to_char(v_q4_max));

1796: hr_utility.trace('Form2: v_q2_max: ' ||to_char(v_q2_max));
1797: hr_utility.trace('Form2: v_q3_min: ' ||to_char(v_q3_min));
1798: hr_utility.trace('Form2: v_q3_max: ' ||to_char(v_q3_max));
1799: hr_utility.trace('Form2: v_q4_min: ' ||to_char(v_q4_min));
1800: hr_utility.trace('Form2: v_q4_max: ' ||to_char(v_q4_max));
1801:
1802: for j in 1..4 loop
1803:
1804: j_flag := 'F';

Line 1811: hr_utility.trace('Form2n: '

1807:
1808: v_count := l.count_total;
1809: v_sex := l.sex;
1810:
1811: hr_utility.trace('Form2n: '
1812: ||'EEOG ' || v_meaning
1813: ||'j = ' || to_char(j)
1814: ||'v_count = ' || to_char(v_count)
1815: ||'v_emp_cat = '|| v_employment_category

Line 1827: hr_utility.trace('If .....');

1823: ) then
1824:
1825: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
1826:
1827: hr_utility.trace('If .....');
1828:
1829: insert into per_ca_ee_report_lines
1830: ( request_id,
1831: line_number,

Line 1880: hr_utility.trace('else prev_employment_category ' || prev_employment_category);

1876: j_flag := 'T';
1877:
1878: else
1879:
1880: hr_utility.trace('else prev_employment_category ' || prev_employment_category);
1881:
1882: if prev_employment_category = v_employment_category and
1883: prev_naic_code = v_naic_code and
1884: prev_meaning = v_meaning and

Line 1887: hr_utility.trace('Inside ........');

1883: prev_naic_code = v_naic_code and
1884: prev_meaning = v_meaning and
1885: prev_sex <> v_sex then
1886:
1887: hr_utility.trace('Inside ........');
1888: if v_sex = 'M' then
1889:
1890: hr_utility.trace('Update Male');
1891:

Line 1890: hr_utility.trace('Update Male');

1886:
1887: hr_utility.trace('Inside ........');
1888: if v_sex = 'M' then
1889:
1890: hr_utility.trace('Update Male');
1891:
1892: update per_ca_ee_report_lines set
1893: segment6=segment6 + nvl(v_count,0),
1894: segment8=nvl(v_count,0)

Line 1902: hr_utility.trace('Update Female');

1898: segment21 = v_naic_code;
1899:
1900: elsif v_sex = 'F' then
1901:
1902: hr_utility.trace('Update Female');
1903:
1904: update per_ca_ee_report_lines set
1905: segment6=segment6 + nvl(v_count,0),
1906: segment7=nvl(v_count,0)

Line 1984: hr_utility.trace('Form2n: Before updation of designated Group');

1980: ---------------------------------
1981: -- Updation designated Group --
1982: ---------------------------------
1983:
1984: hr_utility.trace('Form2n: Before updation of designated Group');
1985: hr_utility.trace('Form2n: Before updation of desig Grp: v_meaning: '
1986: || v_meaning);
1987:
1988: for j in 1..4 loop

Line 1985: hr_utility.trace('Form2n: Before updation of desig Grp: v_meaning: '

1981: -- Updation designated Group --
1982: ---------------------------------
1983:
1984: hr_utility.trace('Form2n: Before updation of designated Group');
1985: hr_utility.trace('Form2n: Before updation of desig Grp: v_meaning: '
1986: || v_meaning);
1987:
1988: for j in 1..4 loop
1989:

Line 1994: hr_utility.trace('Form2n: Updation of designated Group');

1990: for k in 1..3 loop
1991:
1992: for l in cur_count(j,k) loop
1993:
1994: hr_utility.trace('Form2n: Updation of designated Group');
1995:
1996: if k = 1 then
1997:
1998: if l.sex = 'F' then

Line 2604: hr_utility.trace('Form2 starts Here !!!');

2600: fetch cur_legislation_info
2601: into v_leg_info;
2602: close cur_legislation_info;
2603:
2604: hr_utility.trace('Form2 starts Here !!!');
2605:
2606: for naic in cur_naic loop
2607:
2608: v_tot_number_emp := naic.tot_number_emp;

Line 2619: hr_utility.trace('Form2: cur_min_max');

2615: for x in 1..2 loop
2616:
2617: for i in cur_min_max(x) loop
2618:
2619: hr_utility.trace('Form2: cur_min_max');
2620:
2621: v_max_salary := nvl(to_number(i.max_salary),0);
2622: v_min_salary := nvl(to_number(i.min_salary),0);
2623: v_meaning := i.meaning;

Line 2628: hr_utility.trace('Form2: v_cma_province: ' || v_cma_province);

2624: v_employment_category := i.employment_category;
2625: v_cma_province := i.cma_province;
2626:
2627:
2628: hr_utility.trace('Form2: v_cma_province: ' || v_cma_province);
2629: hr_utility.trace('Form2: v_employment_category: ' || v_employment_category);
2630: hr_utility.trace('Form2: v_meaning: ' || v_meaning);
2631:
2632: open cur_meaning(x);

Line 2629: hr_utility.trace('Form2: v_employment_category: ' || v_employment_category);

2625: v_cma_province := i.cma_province;
2626:
2627:
2628: hr_utility.trace('Form2: v_cma_province: ' || v_cma_province);
2629: hr_utility.trace('Form2: v_employment_category: ' || v_employment_category);
2630: hr_utility.trace('Form2: v_meaning: ' || v_meaning);
2631:
2632: open cur_meaning(x);
2633: fetch cur_meaning into v_meaning1;

Line 2630: hr_utility.trace('Form2: v_meaning: ' || v_meaning);

2626:
2627:
2628: hr_utility.trace('Form2: v_cma_province: ' || v_cma_province);
2629: hr_utility.trace('Form2: v_employment_category: ' || v_employment_category);
2630: hr_utility.trace('Form2: v_meaning: ' || v_meaning);
2631:
2632: open cur_meaning(x);
2633: fetch cur_meaning into v_meaning1;
2634: close cur_meaning;

Line 3648: hr_utility.trace('Form3 starts here !!!!!');

3644: emp_cat varchar2(2);
3645:
3646: begin
3647:
3648: hr_utility.trace('Form3 starts here !!!!!');
3649:
3650: for naic in cur_naic loop
3651:
3652: v_naic_code := naic.naic_code;

Line 3771: hr_utility.trace('v_min_range = '||to_char(v_min_range));

3767: v_fr_max_range := 9999999;
3768:
3769: end if;
3770:
3771: hr_utility.trace('v_min_range = '||to_char(v_min_range));
3772: hr_utility.trace('v_max_range = '||to_char(v_max_range));
3773: hr_utility.trace('cur_count_total = ');
3774:
3775: for l in cur_count_total(i,x) loop

Line 3772: hr_utility.trace('v_max_range = '||to_char(v_max_range));

3768:
3769: end if;
3770:
3771: hr_utility.trace('v_min_range = '||to_char(v_min_range));
3772: hr_utility.trace('v_max_range = '||to_char(v_max_range));
3773: hr_utility.trace('cur_count_total = ');
3774:
3775: for l in cur_count_total(i,x) loop
3776:

Line 3773: hr_utility.trace('cur_count_total = ');

3769: end if;
3770:
3771: hr_utility.trace('v_min_range = '||to_char(v_min_range));
3772: hr_utility.trace('v_max_range = '||to_char(v_max_range));
3773: hr_utility.trace('cur_count_total = ');
3774:
3775: for l in cur_count_total(i,x) loop
3776:
3777: v_count := l.count_total;

Line 3782: hr_utility.trace('v_count = ' || to_char(v_count));

3778: v_sex := l.sex;
3779: v_employment_category := l.employment_category;
3780: v_cma_province := l.cma_province;
3781:
3782: hr_utility.trace('v_count = ' || to_char(v_count));
3783: hr_utility.trace('v_sex = '|| v_sex);
3784: hr_utility.trace('v_employment_category = ' || v_employment_category);
3785: hr_utility.trace('v_cma_province = '|| v_cma_province );
3786:

Line 3783: hr_utility.trace('v_sex = '|| v_sex);

3779: v_employment_category := l.employment_category;
3780: v_cma_province := l.cma_province;
3781:
3782: hr_utility.trace('v_count = ' || to_char(v_count));
3783: hr_utility.trace('v_sex = '|| v_sex);
3784: hr_utility.trace('v_employment_category = ' || v_employment_category);
3785: hr_utility.trace('v_cma_province = '|| v_cma_province );
3786:
3787: open cur_meaning(i);

Line 3784: hr_utility.trace('v_employment_category = ' || v_employment_category);

3780: v_cma_province := l.cma_province;
3781:
3782: hr_utility.trace('v_count = ' || to_char(v_count));
3783: hr_utility.trace('v_sex = '|| v_sex);
3784: hr_utility.trace('v_employment_category = ' || v_employment_category);
3785: hr_utility.trace('v_cma_province = '|| v_cma_province );
3786:
3787: open cur_meaning(i);
3788: fetch cur_meaning into v_meaning;

Line 3785: hr_utility.trace('v_cma_province = '|| v_cma_province );

3781:
3782: hr_utility.trace('v_count = ' || to_char(v_count));
3783: hr_utility.trace('v_sex = '|| v_sex);
3784: hr_utility.trace('v_employment_category = ' || v_employment_category);
3785: hr_utility.trace('v_cma_province = '|| v_cma_province );
3786:
3787: open cur_meaning(i);
3788: fetch cur_meaning into v_meaning;
3789: close cur_meaning;

Line 3800: hr_utility.trace('v_meaning = '|| v_meaning );

3796: (ltrim(rtrim(prev_naic_code)) <> ltrim(rtrim(v_naic_code))) or
3797: (prev_x <> x)
3798: ) then
3799:
3800: hr_utility.trace('v_meaning = '|| v_meaning );
3801:
3802: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
3803:
3804: insert into per_ca_ee_report_lines

Line 3906: hr_utility.trace('Form3: v_fr_min_range: ' || to_char(v_fr_min_range));

3902: ---------------------------------
3903: -- Updation designated Group --
3904: ---------------------------------
3905:
3906: hr_utility.trace('Form3: v_fr_min_range: ' || to_char(v_fr_min_range));
3907: hr_utility.trace('Form3: v_fr_max_range: ' || to_char(v_fr_max_range));
3908:
3909: for k in 1..3 loop
3910:

Line 3907: hr_utility.trace('Form3: v_fr_max_range: ' || to_char(v_fr_max_range));

3903: -- Updation designated Group --
3904: ---------------------------------
3905:
3906: hr_utility.trace('Form3: v_fr_min_range: ' || to_char(v_fr_min_range));
3907: hr_utility.trace('Form3: v_fr_max_range: ' || to_char(v_fr_max_range));
3908:
3909: for k in 1..3 loop
3910:
3911: for l in cur_count(i,x,k) loop

Line 3913: hr_utility.trace('Form3: Updation Designated Group');

3909: for k in 1..3 loop
3910:
3911: for l in cur_count(i,x,k) loop
3912:
3913: hr_utility.trace('Form3: Updation Designated Group');
3914:
3915: v_cma_province := l.cma_province;
3916: v_employment_category := l.employment_category;
3917:

Line 3918: hr_utility.trace('Form3: v_meaning: ' || v_meaning);

3914:
3915: v_cma_province := l.cma_province;
3916: v_employment_category := l.employment_category;
3917:
3918: hr_utility.trace('Form3: v_meaning: ' || v_meaning);
3919: hr_utility.trace('Form3: v_cma_province: ' || v_cma_province);
3920: hr_utility.trace('Form3: v_employment_category: '
3921: || v_employment_category);
3922: hr_utility.trace('Form3: v_fr_min_range: ' || to_char(v_fr_min_range));

Line 3919: hr_utility.trace('Form3: v_cma_province: ' || v_cma_province);

3915: v_cma_province := l.cma_province;
3916: v_employment_category := l.employment_category;
3917:
3918: hr_utility.trace('Form3: v_meaning: ' || v_meaning);
3919: hr_utility.trace('Form3: v_cma_province: ' || v_cma_province);
3920: hr_utility.trace('Form3: v_employment_category: '
3921: || v_employment_category);
3922: hr_utility.trace('Form3: v_fr_min_range: ' || to_char(v_fr_min_range));
3923: hr_utility.trace('Form3: v_fr_max_range: ' || to_char(v_fr_max_range));

Line 3920: hr_utility.trace('Form3: v_employment_category: '

3916: v_employment_category := l.employment_category;
3917:
3918: hr_utility.trace('Form3: v_meaning: ' || v_meaning);
3919: hr_utility.trace('Form3: v_cma_province: ' || v_cma_province);
3920: hr_utility.trace('Form3: v_employment_category: '
3921: || v_employment_category);
3922: hr_utility.trace('Form3: v_fr_min_range: ' || to_char(v_fr_min_range));
3923: hr_utility.trace('Form3: v_fr_max_range: ' || to_char(v_fr_max_range));
3924:

Line 3922: hr_utility.trace('Form3: v_fr_min_range: ' || to_char(v_fr_min_range));

3918: hr_utility.trace('Form3: v_meaning: ' || v_meaning);
3919: hr_utility.trace('Form3: v_cma_province: ' || v_cma_province);
3920: hr_utility.trace('Form3: v_employment_category: '
3921: || v_employment_category);
3922: hr_utility.trace('Form3: v_fr_min_range: ' || to_char(v_fr_min_range));
3923: hr_utility.trace('Form3: v_fr_max_range: ' || to_char(v_fr_max_range));
3924:
3925: open cur_meaning(i);
3926: fetch cur_meaning into v_meaning;

Line 3923: hr_utility.trace('Form3: v_fr_max_range: ' || to_char(v_fr_max_range));

3919: hr_utility.trace('Form3: v_cma_province: ' || v_cma_province);
3920: hr_utility.trace('Form3: v_employment_category: '
3921: || v_employment_category);
3922: hr_utility.trace('Form3: v_fr_min_range: ' || to_char(v_fr_min_range));
3923: hr_utility.trace('Form3: v_fr_max_range: ' || to_char(v_fr_max_range));
3924:
3925: open cur_meaning(i);
3926: fetch cur_meaning into v_meaning;
3927: close cur_meaning;

Line 3931: hr_utility.trace('Form3: Updation Designated Grp: k = 1. ');

3927: close cur_meaning;
3928:
3929: if k = 1 then
3930:
3931: hr_utility.trace('Form3: Updation Designated Grp: k = 1. ');
3932: if l.sex = 'F' then
3933:
3934: update per_ca_ee_report_lines set
3935: segment8=nvl(segment8,0) + nvl(l.count,0),

Line 3970: hr_utility.trace('Form3: Updation Designated Grp: k = 2. ');

3966: end if;
3967:
3968: elsif k = 2 then
3969:
3970: hr_utility.trace('Form3: Updation Designated Grp: k = 2. ');
3971:
3972: if l.sex = 'F' then
3973:
3974: update per_ca_ee_report_lines set

Line 4010: hr_utility.trace('Form3: Updation Designated Grp: k = 3. ');

4006: end if;
4007:
4008: elsif k = 3 then
4009:
4010: hr_utility.trace('Form3: Updation Designated Grp: k = 3. ');
4011:
4012: if l.sex = 'F' then
4013:
4014: hr_utility.trace('Form3: Updation Designated Grp: k = 3. F ');

Line 4014: hr_utility.trace('Form3: Updation Designated Grp: k = 3. F ');

4010: hr_utility.trace('Form3: Updation Designated Grp: k = 3. ');
4011:
4012: if l.sex = 'F' then
4013:
4014: hr_utility.trace('Form3: Updation Designated Grp: k = 3. F ');
4015:
4016: update per_ca_ee_report_lines set
4017: segment14=nvl(segment14,0) + nvl(l.count,0),
4018: segment16=nvl(l.count,0)

Line 4033: hr_utility.trace('Form3: Updation Designated Grp: k = 3. M ');

4029: segment21 = v_naic_code;
4030:
4031: else
4032:
4033: hr_utility.trace('Form3: Updation Designated Grp: k = 3. M ');
4034: --hr_utility.trace('Form3: v_meaning: ' || v_meaning);
4035: --hr_utility.trace('Form3: v_cma_province: ' || v_cma_province);
4036: --hr_utility.trace('Form3: v_employment_category: '
4037: -- || v_employment_category);

Line 4034: --hr_utility.trace('Form3: v_meaning: ' || v_meaning);

4030:
4031: else
4032:
4033: hr_utility.trace('Form3: Updation Designated Grp: k = 3. M ');
4034: --hr_utility.trace('Form3: v_meaning: ' || v_meaning);
4035: --hr_utility.trace('Form3: v_cma_province: ' || v_cma_province);
4036: --hr_utility.trace('Form3: v_employment_category: '
4037: -- || v_employment_category);
4038: --hr_utility.trace('Form3: v_fr_min_range: ' || to_char(v_fr_min_range));

Line 4035: --hr_utility.trace('Form3: v_cma_province: ' || v_cma_province);

4031: else
4032:
4033: hr_utility.trace('Form3: Updation Designated Grp: k = 3. M ');
4034: --hr_utility.trace('Form3: v_meaning: ' || v_meaning);
4035: --hr_utility.trace('Form3: v_cma_province: ' || v_cma_province);
4036: --hr_utility.trace('Form3: v_employment_category: '
4037: -- || v_employment_category);
4038: --hr_utility.trace('Form3: v_fr_min_range: ' || to_char(v_fr_min_range));
4039: --hr_utility.trace('Form3: v_fr_max_range: ' || to_char(v_fr_max_range));

Line 4036: --hr_utility.trace('Form3: v_employment_category: '

4032:
4033: hr_utility.trace('Form3: Updation Designated Grp: k = 3. M ');
4034: --hr_utility.trace('Form3: v_meaning: ' || v_meaning);
4035: --hr_utility.trace('Form3: v_cma_province: ' || v_cma_province);
4036: --hr_utility.trace('Form3: v_employment_category: '
4037: -- || v_employment_category);
4038: --hr_utility.trace('Form3: v_fr_min_range: ' || to_char(v_fr_min_range));
4039: --hr_utility.trace('Form3: v_fr_max_range: ' || to_char(v_fr_max_range));
4040:

Line 4038: --hr_utility.trace('Form3: v_fr_min_range: ' || to_char(v_fr_min_range));

4034: --hr_utility.trace('Form3: v_meaning: ' || v_meaning);
4035: --hr_utility.trace('Form3: v_cma_province: ' || v_cma_province);
4036: --hr_utility.trace('Form3: v_employment_category: '
4037: -- || v_employment_category);
4038: --hr_utility.trace('Form3: v_fr_min_range: ' || to_char(v_fr_min_range));
4039: --hr_utility.trace('Form3: v_fr_max_range: ' || to_char(v_fr_max_range));
4040:
4041: update per_ca_ee_report_lines set
4042: segment14=nvl(segment14,0) + nvl(l.count,0),

Line 4039: --hr_utility.trace('Form3: v_fr_max_range: ' || to_char(v_fr_max_range));

4035: --hr_utility.trace('Form3: v_cma_province: ' || v_cma_province);
4036: --hr_utility.trace('Form3: v_employment_category: '
4037: -- || v_employment_category);
4038: --hr_utility.trace('Form3: v_fr_min_range: ' || to_char(v_fr_min_range));
4039: --hr_utility.trace('Form3: v_fr_max_range: ' || to_char(v_fr_max_range));
4040:
4041: update per_ca_ee_report_lines set
4042: segment14=nvl(segment14,0) + nvl(l.count,0),
4043: segment15=nvl(l.count,0)

Line 4258: hr_utility.trace('Form3: cur_count_national. ');

4254: end loop;
4255:
4256: for count_national in cur_count_national loop
4257:
4258: hr_utility.trace('Form3: cur_count_national. ');
4259:
4260: insert into per_ca_ee_report_lines
4261: (request_id,
4262: line_number,

Line 4769: hr_utility.trace('Form4 starts Here !!!!!!');

4765: group by segment3,segment4;
4766:
4767: begin
4768:
4769: hr_utility.trace('Form4 starts Here !!!!!!');
4770:
4771: for naic in cur_naic loop
4772:
4773: v_naic_code := naic.naic_code;

Line 4775: hr_utility.trace('Form4: v_naic = ' || v_naic_code );

4771: for naic in cur_naic loop
4772:
4773: v_naic_code := naic.naic_code;
4774:
4775: hr_utility.trace('Form4: v_naic = ' || v_naic_code );
4776:
4777: for j in cur_hired_total
4778: loop
4779:

Line 4786: hr_utility.trace('Form4: v_meaning = ' || v_meaning );

4782: v_employment_category := j.employment_category;
4783: v_sex := j.sex;
4784: v_province := j.province;
4785:
4786: hr_utility.trace('Form4: v_meaning = ' || v_meaning );
4787:
4788: open cur_meaning;
4789: fetch cur_meaning into v_province_name;
4790: close cur_meaning;

Line 4986: hr_utility.trace('Form4: cur_eeog: v_eeog' || v_meaning);

4982: for i in cur_eeog loop
4983:
4984: v_meaning := i.meaning;
4985:
4986: hr_utility.trace('Form4: cur_eeog: v_eeog' || v_meaning);
4987:
4988: for emp_cat in 1..3 loop
4989:
4990: for x in cur_notfound(emp_cat) loop

Line 5043: hr_utility.trace('Form4: End of loop cur_naic');

5039:
5040: end loop;
5041:
5042:
5043: hr_utility.trace('Form4: End of loop cur_naic');
5044:
5045: for count_national in cur_count_national loop
5046:
5047: hr_utility.trace('Form4: cur_count_national. ');

Line 5047: hr_utility.trace('Form4: cur_count_national. ');

5043: hr_utility.trace('Form4: End of loop cur_naic');
5044:
5045: for count_national in cur_count_national loop
5046:
5047: hr_utility.trace('Form4: cur_count_national. ');
5048:
5049: insert into per_ca_ee_report_lines
5050: (request_id,
5051: line_number,

Line 6129: hr_utility.trace('Form5: v_naic = ' || v_naic_code );

6125: for naic in cur_naic loop
6126:
6127: v_naic_code := naic.naic_code;
6128:
6129: hr_utility.trace('Form5: v_naic = ' || v_naic_code );
6130:
6131: for j in cur_promoted_total
6132: loop
6133: v_count := j.count_total;

Line 6361: hr_utility.trace('Form5: cur_eeog: v_eeog' || v_meaning);

6357: for i in cur_eeog loop
6358:
6359: v_meaning := i.meaning;
6360:
6361: hr_utility.trace('Form5: cur_eeog: v_eeog' || v_meaning);
6362:
6363: for emp_cat in 1..3 loop
6364:
6365: for x in cur_notfound(emp_cat) loop

Line 6423: hr_utility.trace('Form5P: cur_total_promotions');

6419: prev_naic_code := 'te';
6420:
6421: for i in cur_total_promotions loop
6422:
6423: hr_utility.trace('Form5P: cur_total_promotions');
6424:
6425: v_count := i.count_total;
6426: v_employment_category := i.employment_category;
6427: v_sex := i.sex;

Line 6434: hr_utility.trace('Form5P: prev_province_name: ' || prev_province_name);

6430: open cur_meaning;
6431: fetch cur_meaning into v_province_name;
6432: close cur_meaning;
6433:
6434: hr_utility.trace('Form5P: prev_province_name: ' || prev_province_name);
6435: hr_utility.trace('Form5P: v_province_name: ' || v_province_name);
6436: hr_utility.trace('Form5P: prev_naic_code: ' || prev_naic_code);
6437: hr_utility.trace('Form5P: v_naic_code: ' || v_naic_code);
6438: hr_utility.trace('Form5P: prev_emp_category: ' || prev_employment_category);

Line 6435: hr_utility.trace('Form5P: v_province_name: ' || v_province_name);

6431: fetch cur_meaning into v_province_name;
6432: close cur_meaning;
6433:
6434: hr_utility.trace('Form5P: prev_province_name: ' || prev_province_name);
6435: hr_utility.trace('Form5P: v_province_name: ' || v_province_name);
6436: hr_utility.trace('Form5P: prev_naic_code: ' || prev_naic_code);
6437: hr_utility.trace('Form5P: v_naic_code: ' || v_naic_code);
6438: hr_utility.trace('Form5P: prev_emp_category: ' || prev_employment_category);
6439: hr_utility.trace('Form5P: v_emp_category: ' || v_employment_category);

Line 6436: hr_utility.trace('Form5P: prev_naic_code: ' || prev_naic_code);

6432: close cur_meaning;
6433:
6434: hr_utility.trace('Form5P: prev_province_name: ' || prev_province_name);
6435: hr_utility.trace('Form5P: v_province_name: ' || v_province_name);
6436: hr_utility.trace('Form5P: prev_naic_code: ' || prev_naic_code);
6437: hr_utility.trace('Form5P: v_naic_code: ' || v_naic_code);
6438: hr_utility.trace('Form5P: prev_emp_category: ' || prev_employment_category);
6439: hr_utility.trace('Form5P: v_emp_category: ' || v_employment_category);
6440:

Line 6437: hr_utility.trace('Form5P: v_naic_code: ' || v_naic_code);

6433:
6434: hr_utility.trace('Form5P: prev_province_name: ' || prev_province_name);
6435: hr_utility.trace('Form5P: v_province_name: ' || v_province_name);
6436: hr_utility.trace('Form5P: prev_naic_code: ' || prev_naic_code);
6437: hr_utility.trace('Form5P: v_naic_code: ' || v_naic_code);
6438: hr_utility.trace('Form5P: prev_emp_category: ' || prev_employment_category);
6439: hr_utility.trace('Form5P: v_emp_category: ' || v_employment_category);
6440:
6441: if ((ltrim(rtrim(v_province_name))

Line 6438: hr_utility.trace('Form5P: prev_emp_category: ' || prev_employment_category);

6434: hr_utility.trace('Form5P: prev_province_name: ' || prev_province_name);
6435: hr_utility.trace('Form5P: v_province_name: ' || v_province_name);
6436: hr_utility.trace('Form5P: prev_naic_code: ' || prev_naic_code);
6437: hr_utility.trace('Form5P: v_naic_code: ' || v_naic_code);
6438: hr_utility.trace('Form5P: prev_emp_category: ' || prev_employment_category);
6439: hr_utility.trace('Form5P: v_emp_category: ' || v_employment_category);
6440:
6441: if ((ltrim(rtrim(v_province_name))
6442: <>ltrim(rtrim(prev_province_name))) or

Line 6439: hr_utility.trace('Form5P: v_emp_category: ' || v_employment_category);

6435: hr_utility.trace('Form5P: v_province_name: ' || v_province_name);
6436: hr_utility.trace('Form5P: prev_naic_code: ' || prev_naic_code);
6437: hr_utility.trace('Form5P: v_naic_code: ' || v_naic_code);
6438: hr_utility.trace('Form5P: prev_emp_category: ' || prev_employment_category);
6439: hr_utility.trace('Form5P: v_emp_category: ' || v_employment_category);
6440:
6441: if ((ltrim(rtrim(v_province_name))
6442: <>ltrim(rtrim(prev_province_name))) or
6443: (ltrim(rtrim(prev_naic_code)) <> ltrim(rtrim(v_naic_code))) or

Line 6447: hr_utility.trace('Form5P: cur_total_promotions : Inside If');

6443: (ltrim(rtrim(prev_naic_code)) <> ltrim(rtrim(v_naic_code))) or
6444: (ltrim(rtrim(prev_employment_category)) <>
6445: ltrim(rtrim(v_employment_category)))) then
6446:
6447: hr_utility.trace('Form5P: cur_total_promotions : Inside If');
6448: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
6449:
6450: insert into per_ca_ee_report_lines
6451: (request_id,

Line 6737: hr_utility.trace('Form5: cur_count_national. ');

6733: end loop;
6734:
6735: for count_national in cur_count_national loop
6736:
6737: hr_utility.trace('Form5: cur_count_national. ');
6738:
6739: insert into per_ca_ee_report_lines
6740: (request_id,
6741: line_number,

Line 7348: hr_utility.trace('Form5: v_naic = ' || v_naic_code );

7344: for naic in cur_naic loop
7345:
7346: v_naic_code := naic.naic_code;
7347:
7348: hr_utility.trace('Form5: v_naic = ' || v_naic_code );
7349:
7350: for i in 0..3 loop
7351:
7352: for j in cur_promoted_total(i)

Line 7569: hr_utility.trace('Form5: cur_eeog: v_eeog' || v_meaning);

7565: for i in cur_eeog loop
7566:
7567: v_meaning := i.meaning;
7568:
7569: hr_utility.trace('Form5: cur_eeog: v_eeog' || v_meaning);
7570:
7571: for emp_cat in 1..3 loop
7572:
7573: for x in cur_notfound(emp_cat) loop

Line 7633: hr_utility.trace('Form5P: cur_total_promotions');

7629: for i in 0..3 loop
7630:
7631: for j in cur_total_promotions(i) loop
7632:
7633: hr_utility.trace('Form5P: cur_total_promotions');
7634:
7635: v_count := j.promotion_total;
7636: v_employment_category := j.employment_category;
7637: v_sex := j.sex;

Line 7648: hr_utility.trace('Form5P: prev_province_name: ' || prev_province_name);

7644: if v_count <> 0 then -- Only process when promotions exist
7645:
7646: if i = 0 then
7647:
7648: hr_utility.trace('Form5P: prev_province_name: ' || prev_province_name);
7649: hr_utility.trace('Form5P: v_province_name: ' || v_province_name);
7650: hr_utility.trace('Form5P: prev_naic_code: ' || prev_naic_code);
7651: hr_utility.trace('Form5P: v_naic_code: ' || v_naic_code);
7652: hr_utility.trace('Form5P: prev_emp_category: ' || prev_employment_category);

Line 7649: hr_utility.trace('Form5P: v_province_name: ' || v_province_name);

7645:
7646: if i = 0 then
7647:
7648: hr_utility.trace('Form5P: prev_province_name: ' || prev_province_name);
7649: hr_utility.trace('Form5P: v_province_name: ' || v_province_name);
7650: hr_utility.trace('Form5P: prev_naic_code: ' || prev_naic_code);
7651: hr_utility.trace('Form5P: v_naic_code: ' || v_naic_code);
7652: hr_utility.trace('Form5P: prev_emp_category: ' || prev_employment_category);
7653: hr_utility.trace('Form5P: v_emp_category: ' || v_employment_category);

Line 7650: hr_utility.trace('Form5P: prev_naic_code: ' || prev_naic_code);

7646: if i = 0 then
7647:
7648: hr_utility.trace('Form5P: prev_province_name: ' || prev_province_name);
7649: hr_utility.trace('Form5P: v_province_name: ' || v_province_name);
7650: hr_utility.trace('Form5P: prev_naic_code: ' || prev_naic_code);
7651: hr_utility.trace('Form5P: v_naic_code: ' || v_naic_code);
7652: hr_utility.trace('Form5P: prev_emp_category: ' || prev_employment_category);
7653: hr_utility.trace('Form5P: v_emp_category: ' || v_employment_category);
7654:

Line 7651: hr_utility.trace('Form5P: v_naic_code: ' || v_naic_code);

7647:
7648: hr_utility.trace('Form5P: prev_province_name: ' || prev_province_name);
7649: hr_utility.trace('Form5P: v_province_name: ' || v_province_name);
7650: hr_utility.trace('Form5P: prev_naic_code: ' || prev_naic_code);
7651: hr_utility.trace('Form5P: v_naic_code: ' || v_naic_code);
7652: hr_utility.trace('Form5P: prev_emp_category: ' || prev_employment_category);
7653: hr_utility.trace('Form5P: v_emp_category: ' || v_employment_category);
7654:
7655: if ((ltrim(rtrim(v_province_name))

Line 7652: hr_utility.trace('Form5P: prev_emp_category: ' || prev_employment_category);

7648: hr_utility.trace('Form5P: prev_province_name: ' || prev_province_name);
7649: hr_utility.trace('Form5P: v_province_name: ' || v_province_name);
7650: hr_utility.trace('Form5P: prev_naic_code: ' || prev_naic_code);
7651: hr_utility.trace('Form5P: v_naic_code: ' || v_naic_code);
7652: hr_utility.trace('Form5P: prev_emp_category: ' || prev_employment_category);
7653: hr_utility.trace('Form5P: v_emp_category: ' || v_employment_category);
7654:
7655: if ((ltrim(rtrim(v_province_name))
7656: <>ltrim(rtrim(prev_province_name))) or

Line 7653: hr_utility.trace('Form5P: v_emp_category: ' || v_employment_category);

7649: hr_utility.trace('Form5P: v_province_name: ' || v_province_name);
7650: hr_utility.trace('Form5P: prev_naic_code: ' || prev_naic_code);
7651: hr_utility.trace('Form5P: v_naic_code: ' || v_naic_code);
7652: hr_utility.trace('Form5P: prev_emp_category: ' || prev_employment_category);
7653: hr_utility.trace('Form5P: v_emp_category: ' || v_employment_category);
7654:
7655: if ((ltrim(rtrim(v_province_name))
7656: <>ltrim(rtrim(prev_province_name))) or
7657: (ltrim(rtrim(prev_naic_code)) <> ltrim(rtrim(v_naic_code))) or

Line 7661: hr_utility.trace('Form5P: cur_total_promotions : Inside If');

7657: (ltrim(rtrim(prev_naic_code)) <> ltrim(rtrim(v_naic_code))) or
7658: (ltrim(rtrim(prev_employment_category)) <>
7659: ltrim(rtrim(v_employment_category)))) then
7660:
7661: hr_utility.trace('Form5P: cur_total_promotions : Inside If');
7662: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
7663:
7664: insert into per_ca_ee_report_lines
7665: (request_id,

Line 7934: hr_utility.trace('Form5: cur_count_national. ');

7930: end loop;
7931:
7932: for count_national in cur_count_national loop
7933:
7934: hr_utility.trace('Form5: cur_count_national. ');
7935:
7936: insert into per_ca_ee_report_lines
7937: (request_id,
7938: line_number,

Line 8401: hr_utility.trace('Form6 starts Here !!!!!!');

8397: group by segment3,segment4;
8398:
8399: begin
8400:
8401: hr_utility.trace('Form6 starts Here !!!!!!');
8402:
8403: for naic in cur_naic loop
8404:
8405: v_naic_code := naic.naic_code;

Line 8407: hr_utility.trace('Form6: v_naic = ' || v_naic_code );

8403: for naic in cur_naic loop
8404:
8405: v_naic_code := naic.naic_code;
8406:
8407: hr_utility.trace('Form6: v_naic = ' || v_naic_code );
8408:
8409: for j in cur_terminated_total
8410: loop
8411:

Line 8651: hr_utility.trace('Form6: cur_eeog: v_eeog' || v_meaning);

8647: for i in cur_eeog loop
8648:
8649: v_meaning := i.meaning;
8650:
8651: hr_utility.trace('Form6: cur_eeog: v_eeog' || v_meaning);
8652:
8653: for emp_cat in 1..3 loop
8654:
8655: for x in cur_notfound(emp_cat) loop

Line 8657: hr_utility.trace('Form6: cur_notfound' );

8653: for emp_cat in 1..3 loop
8654:
8655: for x in cur_notfound(emp_cat) loop
8656:
8657: hr_utility.trace('Form6: cur_notfound' );
8658:
8659: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
8660:
8661: insert into per_ca_ee_report_lines

Line 8711: hr_utility.trace('Form6: cur_count_national. ');

8707: end loop; -- End loop cur_eeog
8708:
8709: for count_national in cur_count_national loop
8710:
8711: hr_utility.trace('Form6: cur_count_national. ');
8712:
8713: insert into per_ca_ee_report_lines
8714: (request_id,
8715: line_number,

Line 8847: hr_utility.trace('Function update_rec starts here !!!!');

8843: segment21 = v_not_max_naic;
8844:
8845: begin
8846:
8847: hr_utility.trace('Function update_rec starts here !!!!');
8848:
8849: open cur_temp_count;
8850: fetch cur_temp_count
8851: into v_tot_fr,

Line 8897: hr_utility.trace('UPDATE_REC: v_max_naic_code: ' || v_max_naic_code);

8893: into v_max_naic_code,
8894: v_max_naic_count;
8895: close cur_max_naic;
8896:
8897: hr_utility.trace('UPDATE_REC: v_max_naic_code: ' || v_max_naic_code);
8898:
8899: for naic in cur_less_than_max_naic loop
8900:
8901: v_not_max_naic := naic.naic_code;

Line 8903: hr_utility.trace('UPDATE_REC: v_not_max_naic: ' || v_not_max_naic);

8899: for naic in cur_less_than_max_naic loop
8900:
8901: v_not_max_naic := naic.naic_code;
8902:
8903: hr_utility.trace('UPDATE_REC: v_not_max_naic: ' || v_not_max_naic);
8904:
8905: for i in cur_not_max_naic_data loop
8906:
8907: hr_utility.trace('UPDATE_REC: Form3 - 6' );

Line 8907: hr_utility.trace('UPDATE_REC: Form3 - 6' );

8903: hr_utility.trace('UPDATE_REC: v_not_max_naic: ' || v_not_max_naic);
8904:
8905: for i in cur_not_max_naic_data loop
8906:
8907: hr_utility.trace('UPDATE_REC: Form3 - 6' );
8908:
8909: update per_ca_ee_report_lines
8910: set
8911: segment4 = segment4 + i.segment4,

Line 8931: hr_utility.trace('UPDATE_REC: Form3 - 6 End' );

8927: segment2 = i.segment2 and
8928: segment3 = i.segment3 and
8929: segment21 = v_max_naic_code;
8930:
8931: hr_utility.trace('UPDATE_REC: Form3 - 6 End' );
8932:
8933: end loop; -- End loop cur_not_max_naic_data
8934:
8935: delete from per_ca_ee_report_lines