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 2616: hr_utility.trace('Form2 starts Here !!!');

2612: fetch cur_legislation_info
2613: into v_leg_info;
2614: close cur_legislation_info;
2615:
2616: hr_utility.trace('Form2 starts Here !!!');
2617:
2618: for naic in cur_naic loop
2619:
2620: v_tot_number_emp := naic.tot_number_emp;

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

2627: for x in 1..2 loop
2628:
2629: for i in cur_min_max(x) loop
2630:
2631: hr_utility.trace('Form2: cur_min_max');
2632:
2633: v_max_salary := nvl(to_number(i.max_salary),0);
2634: v_min_salary := nvl(to_number(i.min_salary),0);
2635: v_meaning := i.meaning;

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

2636: v_employment_category := i.employment_category;
2637: v_cma_province := i.cma_province;
2638:
2639:
2640: hr_utility.trace('Form2: v_cma_province: ' || v_cma_province);
2641: hr_utility.trace('Form2: v_employment_category: ' || v_employment_category);
2642: hr_utility.trace('Form2: v_meaning: ' || v_meaning);
2643:
2644: open cur_meaning(x);

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

2637: v_cma_province := i.cma_province;
2638:
2639:
2640: hr_utility.trace('Form2: v_cma_province: ' || v_cma_province);
2641: hr_utility.trace('Form2: v_employment_category: ' || v_employment_category);
2642: hr_utility.trace('Form2: v_meaning: ' || v_meaning);
2643:
2644: open cur_meaning(x);
2645: fetch cur_meaning into v_meaning1;

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

2638:
2639:
2640: hr_utility.trace('Form2: v_cma_province: ' || v_cma_province);
2641: hr_utility.trace('Form2: v_employment_category: ' || v_employment_category);
2642: hr_utility.trace('Form2: v_meaning: ' || v_meaning);
2643:
2644: open cur_meaning(x);
2645: fetch cur_meaning into v_meaning1;
2646: close cur_meaning;

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

3656: emp_cat varchar2(2);
3657:
3658: begin
3659:
3660: hr_utility.trace('Form3 starts here !!!!!');
3661:
3662: for naic in cur_naic loop
3663:
3664: v_naic_code := naic.naic_code;

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

3779: v_fr_max_range := 9999999;
3780:
3781: end if;
3782:
3783: hr_utility.trace('v_min_range = '||to_char(v_min_range));
3784: hr_utility.trace('v_max_range = '||to_char(v_max_range));
3785: hr_utility.trace('cur_count_total = ');
3786:
3787: for l in cur_count_total(i,x) loop

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

3780:
3781: end if;
3782:
3783: hr_utility.trace('v_min_range = '||to_char(v_min_range));
3784: hr_utility.trace('v_max_range = '||to_char(v_max_range));
3785: hr_utility.trace('cur_count_total = ');
3786:
3787: for l in cur_count_total(i,x) loop
3788:

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

3781: end if;
3782:
3783: hr_utility.trace('v_min_range = '||to_char(v_min_range));
3784: hr_utility.trace('v_max_range = '||to_char(v_max_range));
3785: hr_utility.trace('cur_count_total = ');
3786:
3787: for l in cur_count_total(i,x) loop
3788:
3789: v_count := l.count_total;

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

3790: v_sex := l.sex;
3791: v_employment_category := l.employment_category;
3792: v_cma_province := l.cma_province;
3793:
3794: hr_utility.trace('v_count = ' || to_char(v_count));
3795: hr_utility.trace('v_sex = '|| v_sex);
3796: hr_utility.trace('v_employment_category = ' || v_employment_category);
3797: hr_utility.trace('v_cma_province = '|| v_cma_province );
3798:

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

3791: v_employment_category := l.employment_category;
3792: v_cma_province := l.cma_province;
3793:
3794: hr_utility.trace('v_count = ' || to_char(v_count));
3795: hr_utility.trace('v_sex = '|| v_sex);
3796: hr_utility.trace('v_employment_category = ' || v_employment_category);
3797: hr_utility.trace('v_cma_province = '|| v_cma_province );
3798:
3799: open cur_meaning(i);

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

3792: v_cma_province := l.cma_province;
3793:
3794: hr_utility.trace('v_count = ' || to_char(v_count));
3795: hr_utility.trace('v_sex = '|| v_sex);
3796: hr_utility.trace('v_employment_category = ' || v_employment_category);
3797: hr_utility.trace('v_cma_province = '|| v_cma_province );
3798:
3799: open cur_meaning(i);
3800: fetch cur_meaning into v_meaning;

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

3793:
3794: hr_utility.trace('v_count = ' || to_char(v_count));
3795: hr_utility.trace('v_sex = '|| v_sex);
3796: hr_utility.trace('v_employment_category = ' || v_employment_category);
3797: hr_utility.trace('v_cma_province = '|| v_cma_province );
3798:
3799: open cur_meaning(i);
3800: fetch cur_meaning into v_meaning;
3801: close cur_meaning;

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

3808: (ltrim(rtrim(prev_naic_code)) <> ltrim(rtrim(v_naic_code))) or
3809: (prev_x <> x)
3810: ) then
3811:
3812: hr_utility.trace('v_meaning = '|| v_meaning );
3813:
3814: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
3815:
3816: insert into per_ca_ee_report_lines

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

3914: ---------------------------------
3915: -- Updation designated Group --
3916: ---------------------------------
3917:
3918: hr_utility.trace('Form3: v_fr_min_range: ' || to_char(v_fr_min_range));
3919: hr_utility.trace('Form3: v_fr_max_range: ' || to_char(v_fr_max_range));
3920:
3921: for k in 1..3 loop
3922:

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

3915: -- Updation designated Group --
3916: ---------------------------------
3917:
3918: hr_utility.trace('Form3: v_fr_min_range: ' || to_char(v_fr_min_range));
3919: hr_utility.trace('Form3: v_fr_max_range: ' || to_char(v_fr_max_range));
3920:
3921: for k in 1..3 loop
3922:
3923: for l in cur_count(i,x,k) loop

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

3921: for k in 1..3 loop
3922:
3923: for l in cur_count(i,x,k) loop
3924:
3925: hr_utility.trace('Form3: Updation Designated Group');
3926:
3927: v_cma_province := l.cma_province;
3928: v_employment_category := l.employment_category;
3929:

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

3926:
3927: v_cma_province := l.cma_province;
3928: v_employment_category := l.employment_category;
3929:
3930: hr_utility.trace('Form3: v_meaning: ' || v_meaning);
3931: hr_utility.trace('Form3: v_cma_province: ' || v_cma_province);
3932: hr_utility.trace('Form3: v_employment_category: '
3933: || v_employment_category);
3934: hr_utility.trace('Form3: v_fr_min_range: ' || to_char(v_fr_min_range));

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

3927: v_cma_province := l.cma_province;
3928: v_employment_category := l.employment_category;
3929:
3930: hr_utility.trace('Form3: v_meaning: ' || v_meaning);
3931: hr_utility.trace('Form3: v_cma_province: ' || v_cma_province);
3932: hr_utility.trace('Form3: v_employment_category: '
3933: || v_employment_category);
3934: hr_utility.trace('Form3: v_fr_min_range: ' || to_char(v_fr_min_range));
3935: hr_utility.trace('Form3: v_fr_max_range: ' || to_char(v_fr_max_range));

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

3928: v_employment_category := l.employment_category;
3929:
3930: hr_utility.trace('Form3: v_meaning: ' || v_meaning);
3931: hr_utility.trace('Form3: v_cma_province: ' || v_cma_province);
3932: hr_utility.trace('Form3: v_employment_category: '
3933: || v_employment_category);
3934: hr_utility.trace('Form3: v_fr_min_range: ' || to_char(v_fr_min_range));
3935: hr_utility.trace('Form3: v_fr_max_range: ' || to_char(v_fr_max_range));
3936:

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

3930: hr_utility.trace('Form3: v_meaning: ' || v_meaning);
3931: hr_utility.trace('Form3: v_cma_province: ' || v_cma_province);
3932: hr_utility.trace('Form3: v_employment_category: '
3933: || v_employment_category);
3934: hr_utility.trace('Form3: v_fr_min_range: ' || to_char(v_fr_min_range));
3935: hr_utility.trace('Form3: v_fr_max_range: ' || to_char(v_fr_max_range));
3936:
3937: open cur_meaning(i);
3938: fetch cur_meaning into v_meaning;

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

3931: hr_utility.trace('Form3: v_cma_province: ' || v_cma_province);
3932: hr_utility.trace('Form3: v_employment_category: '
3933: || v_employment_category);
3934: hr_utility.trace('Form3: v_fr_min_range: ' || to_char(v_fr_min_range));
3935: hr_utility.trace('Form3: v_fr_max_range: ' || to_char(v_fr_max_range));
3936:
3937: open cur_meaning(i);
3938: fetch cur_meaning into v_meaning;
3939: close cur_meaning;

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

3939: close cur_meaning;
3940:
3941: if k = 1 then
3942:
3943: hr_utility.trace('Form3: Updation Designated Grp: k = 1. ');
3944: if l.sex = 'F' then
3945:
3946: update per_ca_ee_report_lines set
3947: segment8=nvl(segment8,0) + nvl(l.count,0),

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

3978: end if;
3979:
3980: elsif k = 2 then
3981:
3982: hr_utility.trace('Form3: Updation Designated Grp: k = 2. ');
3983:
3984: if l.sex = 'F' then
3985:
3986: update per_ca_ee_report_lines set

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

4018: end if;
4019:
4020: elsif k = 3 then
4021:
4022: hr_utility.trace('Form3: Updation Designated Grp: k = 3. ');
4023:
4024: if l.sex = 'F' then
4025:
4026: hr_utility.trace('Form3: Updation Designated Grp: k = 3. F ');

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

4022: hr_utility.trace('Form3: Updation Designated Grp: k = 3. ');
4023:
4024: if l.sex = 'F' then
4025:
4026: hr_utility.trace('Form3: Updation Designated Grp: k = 3. F ');
4027:
4028: update per_ca_ee_report_lines set
4029: segment14=nvl(segment14,0) + nvl(l.count,0),
4030: segment16=nvl(l.count,0)

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

4041: segment21 = v_naic_code;
4042:
4043: else
4044:
4045: hr_utility.trace('Form3: Updation Designated Grp: k = 3. M ');
4046: --hr_utility.trace('Form3: v_meaning: ' || v_meaning);
4047: --hr_utility.trace('Form3: v_cma_province: ' || v_cma_province);
4048: --hr_utility.trace('Form3: v_employment_category: '
4049: -- || v_employment_category);

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

4042:
4043: else
4044:
4045: hr_utility.trace('Form3: Updation Designated Grp: k = 3. M ');
4046: --hr_utility.trace('Form3: v_meaning: ' || v_meaning);
4047: --hr_utility.trace('Form3: v_cma_province: ' || v_cma_province);
4048: --hr_utility.trace('Form3: v_employment_category: '
4049: -- || v_employment_category);
4050: --hr_utility.trace('Form3: v_fr_min_range: ' || to_char(v_fr_min_range));

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

4043: else
4044:
4045: hr_utility.trace('Form3: Updation Designated Grp: k = 3. M ');
4046: --hr_utility.trace('Form3: v_meaning: ' || v_meaning);
4047: --hr_utility.trace('Form3: v_cma_province: ' || v_cma_province);
4048: --hr_utility.trace('Form3: v_employment_category: '
4049: -- || v_employment_category);
4050: --hr_utility.trace('Form3: v_fr_min_range: ' || to_char(v_fr_min_range));
4051: --hr_utility.trace('Form3: v_fr_max_range: ' || to_char(v_fr_max_range));

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

4044:
4045: hr_utility.trace('Form3: Updation Designated Grp: k = 3. M ');
4046: --hr_utility.trace('Form3: v_meaning: ' || v_meaning);
4047: --hr_utility.trace('Form3: v_cma_province: ' || v_cma_province);
4048: --hr_utility.trace('Form3: v_employment_category: '
4049: -- || v_employment_category);
4050: --hr_utility.trace('Form3: v_fr_min_range: ' || to_char(v_fr_min_range));
4051: --hr_utility.trace('Form3: v_fr_max_range: ' || to_char(v_fr_max_range));
4052:

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

4046: --hr_utility.trace('Form3: v_meaning: ' || v_meaning);
4047: --hr_utility.trace('Form3: v_cma_province: ' || v_cma_province);
4048: --hr_utility.trace('Form3: v_employment_category: '
4049: -- || v_employment_category);
4050: --hr_utility.trace('Form3: v_fr_min_range: ' || to_char(v_fr_min_range));
4051: --hr_utility.trace('Form3: v_fr_max_range: ' || to_char(v_fr_max_range));
4052:
4053: update per_ca_ee_report_lines set
4054: segment14=nvl(segment14,0) + nvl(l.count,0),

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

4047: --hr_utility.trace('Form3: v_cma_province: ' || v_cma_province);
4048: --hr_utility.trace('Form3: v_employment_category: '
4049: -- || v_employment_category);
4050: --hr_utility.trace('Form3: v_fr_min_range: ' || to_char(v_fr_min_range));
4051: --hr_utility.trace('Form3: v_fr_max_range: ' || to_char(v_fr_max_range));
4052:
4053: update per_ca_ee_report_lines set
4054: segment14=nvl(segment14,0) + nvl(l.count,0),
4055: segment15=nvl(l.count,0)

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

4266: end loop;
4267:
4268: for count_national in cur_count_national loop
4269:
4270: hr_utility.trace('Form3: cur_count_national. ');
4271:
4272: insert into per_ca_ee_report_lines
4273: (request_id,
4274: line_number,

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

4811: group by segment3,segment4;
4812:
4813: begin
4814:
4815: hr_utility.trace('Form4 starts Here !!!!!!');
4816:
4817: for naic in cur_naic loop
4818:
4819: v_naic_code := naic.naic_code;

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

4817: for naic in cur_naic loop
4818:
4819: v_naic_code := naic.naic_code;
4820:
4821: hr_utility.trace('Form4: v_naic = ' || v_naic_code );
4822:
4823: for j in cur_hired_total
4824: loop
4825:

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

4828: v_employment_category := j.employment_category;
4829: v_sex := j.sex;
4830: v_province := j.province;
4831:
4832: hr_utility.trace('Form4: v_meaning = ' || v_meaning );
4833:
4834: open cur_meaning;
4835: fetch cur_meaning into v_province_name;
4836: close cur_meaning;

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

5028: for i in cur_eeog loop
5029:
5030: v_meaning := i.meaning;
5031:
5032: hr_utility.trace('Form4: cur_eeog: v_eeog' || v_meaning);
5033:
5034: for emp_cat in 1..3 loop
5035:
5036: for x in cur_notfound(emp_cat) loop

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

5085:
5086: end loop;
5087:
5088:
5089: hr_utility.trace('Form4: End of loop cur_naic');
5090:
5091: for count_national in cur_count_national loop
5092:
5093: hr_utility.trace('Form4: cur_count_national. ');

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

5089: hr_utility.trace('Form4: End of loop cur_naic');
5090:
5091: for count_national in cur_count_national loop
5092:
5093: hr_utility.trace('Form4: cur_count_national. ');
5094:
5095: insert into per_ca_ee_report_lines
5096: (request_id,
5097: line_number,

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

6171: for naic in cur_naic loop
6172:
6173: v_naic_code := naic.naic_code;
6174:
6175: hr_utility.trace('Form5: v_naic = ' || v_naic_code );
6176:
6177: for j in cur_promoted_total
6178: loop
6179: v_count := j.count_total;

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

6403: for i in cur_eeog loop
6404:
6405: v_meaning := i.meaning;
6406:
6407: hr_utility.trace('Form5: cur_eeog: v_eeog' || v_meaning);
6408:
6409: for emp_cat in 1..3 loop
6410:
6411: for x in cur_notfound(emp_cat) loop

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

6465: prev_naic_code := 'te';
6466:
6467: for i in cur_total_promotions loop
6468:
6469: hr_utility.trace('Form5P: cur_total_promotions');
6470:
6471: v_count := i.count_total;
6472: v_employment_category := i.employment_category;
6473: v_sex := i.sex;

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

6476: open cur_meaning;
6477: fetch cur_meaning into v_province_name;
6478: close cur_meaning;
6479:
6480: hr_utility.trace('Form5P: prev_province_name: ' || prev_province_name);
6481: hr_utility.trace('Form5P: v_province_name: ' || v_province_name);
6482: hr_utility.trace('Form5P: prev_naic_code: ' || prev_naic_code);
6483: hr_utility.trace('Form5P: v_naic_code: ' || v_naic_code);
6484: hr_utility.trace('Form5P: prev_emp_category: ' || prev_employment_category);

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

6477: fetch cur_meaning into v_province_name;
6478: close cur_meaning;
6479:
6480: hr_utility.trace('Form5P: prev_province_name: ' || prev_province_name);
6481: hr_utility.trace('Form5P: v_province_name: ' || v_province_name);
6482: hr_utility.trace('Form5P: prev_naic_code: ' || prev_naic_code);
6483: hr_utility.trace('Form5P: v_naic_code: ' || v_naic_code);
6484: hr_utility.trace('Form5P: prev_emp_category: ' || prev_employment_category);
6485: hr_utility.trace('Form5P: v_emp_category: ' || v_employment_category);

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

6478: close cur_meaning;
6479:
6480: hr_utility.trace('Form5P: prev_province_name: ' || prev_province_name);
6481: hr_utility.trace('Form5P: v_province_name: ' || v_province_name);
6482: hr_utility.trace('Form5P: prev_naic_code: ' || prev_naic_code);
6483: hr_utility.trace('Form5P: v_naic_code: ' || v_naic_code);
6484: hr_utility.trace('Form5P: prev_emp_category: ' || prev_employment_category);
6485: hr_utility.trace('Form5P: v_emp_category: ' || v_employment_category);
6486:

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

6479:
6480: hr_utility.trace('Form5P: prev_province_name: ' || prev_province_name);
6481: hr_utility.trace('Form5P: v_province_name: ' || v_province_name);
6482: hr_utility.trace('Form5P: prev_naic_code: ' || prev_naic_code);
6483: hr_utility.trace('Form5P: v_naic_code: ' || v_naic_code);
6484: hr_utility.trace('Form5P: prev_emp_category: ' || prev_employment_category);
6485: hr_utility.trace('Form5P: v_emp_category: ' || v_employment_category);
6486:
6487: if ((ltrim(rtrim(v_province_name))

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

6480: hr_utility.trace('Form5P: prev_province_name: ' || prev_province_name);
6481: hr_utility.trace('Form5P: v_province_name: ' || v_province_name);
6482: hr_utility.trace('Form5P: prev_naic_code: ' || prev_naic_code);
6483: hr_utility.trace('Form5P: v_naic_code: ' || v_naic_code);
6484: hr_utility.trace('Form5P: prev_emp_category: ' || prev_employment_category);
6485: hr_utility.trace('Form5P: v_emp_category: ' || v_employment_category);
6486:
6487: if ((ltrim(rtrim(v_province_name))
6488: <>ltrim(rtrim(prev_province_name))) or

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

6481: hr_utility.trace('Form5P: v_province_name: ' || v_province_name);
6482: hr_utility.trace('Form5P: prev_naic_code: ' || prev_naic_code);
6483: hr_utility.trace('Form5P: v_naic_code: ' || v_naic_code);
6484: hr_utility.trace('Form5P: prev_emp_category: ' || prev_employment_category);
6485: hr_utility.trace('Form5P: v_emp_category: ' || v_employment_category);
6486:
6487: if ((ltrim(rtrim(v_province_name))
6488: <>ltrim(rtrim(prev_province_name))) or
6489: (ltrim(rtrim(prev_naic_code)) <> ltrim(rtrim(v_naic_code))) or

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

6489: (ltrim(rtrim(prev_naic_code)) <> ltrim(rtrim(v_naic_code))) or
6490: (ltrim(rtrim(prev_employment_category)) <>
6491: ltrim(rtrim(v_employment_category)))) then
6492:
6493: hr_utility.trace('Form5P: cur_total_promotions : Inside If');
6494: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
6495:
6496: insert into per_ca_ee_report_lines
6497: (request_id,

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

6779: end loop;
6780:
6781: for count_national in cur_count_national loop
6782:
6783: hr_utility.trace('Form5: cur_count_national. ');
6784:
6785: insert into per_ca_ee_report_lines
6786: (request_id,
6787: line_number,

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

7390: for naic in cur_naic loop
7391:
7392: v_naic_code := naic.naic_code;
7393:
7394: hr_utility.trace('Form5: v_naic = ' || v_naic_code );
7395:
7396: for i in 0..3 loop
7397:
7398: for j in cur_promoted_total(i)

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

7611: for i in cur_eeog loop
7612:
7613: v_meaning := i.meaning;
7614:
7615: hr_utility.trace('Form5: cur_eeog: v_eeog' || v_meaning);
7616:
7617: for emp_cat in 1..3 loop
7618:
7619: for x in cur_notfound(emp_cat) loop

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

7675: for i in 0..3 loop
7676:
7677: for j in cur_total_promotions(i) loop
7678:
7679: hr_utility.trace('Form5P: cur_total_promotions');
7680:
7681: v_count := j.promotion_total;
7682: v_employment_category := j.employment_category;
7683: v_sex := j.sex;

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

7690: if v_count <> 0 then -- Only process when promotions exist
7691:
7692: if i = 0 then
7693:
7694: hr_utility.trace('Form5P: prev_province_name: ' || prev_province_name);
7695: hr_utility.trace('Form5P: v_province_name: ' || v_province_name);
7696: hr_utility.trace('Form5P: prev_naic_code: ' || prev_naic_code);
7697: hr_utility.trace('Form5P: v_naic_code: ' || v_naic_code);
7698: hr_utility.trace('Form5P: prev_emp_category: ' || prev_employment_category);

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

7691:
7692: if i = 0 then
7693:
7694: hr_utility.trace('Form5P: prev_province_name: ' || prev_province_name);
7695: hr_utility.trace('Form5P: v_province_name: ' || v_province_name);
7696: hr_utility.trace('Form5P: prev_naic_code: ' || prev_naic_code);
7697: hr_utility.trace('Form5P: v_naic_code: ' || v_naic_code);
7698: hr_utility.trace('Form5P: prev_emp_category: ' || prev_employment_category);
7699: hr_utility.trace('Form5P: v_emp_category: ' || v_employment_category);

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

7692: if i = 0 then
7693:
7694: hr_utility.trace('Form5P: prev_province_name: ' || prev_province_name);
7695: hr_utility.trace('Form5P: v_province_name: ' || v_province_name);
7696: hr_utility.trace('Form5P: prev_naic_code: ' || prev_naic_code);
7697: hr_utility.trace('Form5P: v_naic_code: ' || v_naic_code);
7698: hr_utility.trace('Form5P: prev_emp_category: ' || prev_employment_category);
7699: hr_utility.trace('Form5P: v_emp_category: ' || v_employment_category);
7700:

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

7693:
7694: hr_utility.trace('Form5P: prev_province_name: ' || prev_province_name);
7695: hr_utility.trace('Form5P: v_province_name: ' || v_province_name);
7696: hr_utility.trace('Form5P: prev_naic_code: ' || prev_naic_code);
7697: hr_utility.trace('Form5P: v_naic_code: ' || v_naic_code);
7698: hr_utility.trace('Form5P: prev_emp_category: ' || prev_employment_category);
7699: hr_utility.trace('Form5P: v_emp_category: ' || v_employment_category);
7700:
7701: if ((ltrim(rtrim(v_province_name))

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

7694: hr_utility.trace('Form5P: prev_province_name: ' || prev_province_name);
7695: hr_utility.trace('Form5P: v_province_name: ' || v_province_name);
7696: hr_utility.trace('Form5P: prev_naic_code: ' || prev_naic_code);
7697: hr_utility.trace('Form5P: v_naic_code: ' || v_naic_code);
7698: hr_utility.trace('Form5P: prev_emp_category: ' || prev_employment_category);
7699: hr_utility.trace('Form5P: v_emp_category: ' || v_employment_category);
7700:
7701: if ((ltrim(rtrim(v_province_name))
7702: <>ltrim(rtrim(prev_province_name))) or

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

7695: hr_utility.trace('Form5P: v_province_name: ' || v_province_name);
7696: hr_utility.trace('Form5P: prev_naic_code: ' || prev_naic_code);
7697: hr_utility.trace('Form5P: v_naic_code: ' || v_naic_code);
7698: hr_utility.trace('Form5P: prev_emp_category: ' || prev_employment_category);
7699: hr_utility.trace('Form5P: v_emp_category: ' || v_employment_category);
7700:
7701: if ((ltrim(rtrim(v_province_name))
7702: <>ltrim(rtrim(prev_province_name))) or
7703: (ltrim(rtrim(prev_naic_code)) <> ltrim(rtrim(v_naic_code))) or

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

7703: (ltrim(rtrim(prev_naic_code)) <> ltrim(rtrim(v_naic_code))) or
7704: (ltrim(rtrim(prev_employment_category)) <>
7705: ltrim(rtrim(v_employment_category)))) then
7706:
7707: hr_utility.trace('Form5P: cur_total_promotions : Inside If');
7708: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
7709:
7710: insert into per_ca_ee_report_lines
7711: (request_id,

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

7976: end loop;
7977:
7978: for count_national in cur_count_national loop
7979:
7980: hr_utility.trace('Form5: cur_count_national. ');
7981:
7982: insert into per_ca_ee_report_lines
7983: (request_id,
7984: line_number,

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

8443: group by segment3,segment4;
8444:
8445: begin
8446:
8447: hr_utility.trace('Form6 starts Here !!!!!!');
8448:
8449: for naic in cur_naic loop
8450:
8451: v_naic_code := naic.naic_code;

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

8449: for naic in cur_naic loop
8450:
8451: v_naic_code := naic.naic_code;
8452:
8453: hr_utility.trace('Form6: v_naic = ' || v_naic_code );
8454:
8455: for j in cur_terminated_total
8456: loop
8457:

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

8693: for i in cur_eeog loop
8694:
8695: v_meaning := i.meaning;
8696:
8697: hr_utility.trace('Form6: cur_eeog: v_eeog' || v_meaning);
8698:
8699: for emp_cat in 1..3 loop
8700:
8701: for x in cur_notfound(emp_cat) loop

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

8699: for emp_cat in 1..3 loop
8700:
8701: for x in cur_notfound(emp_cat) loop
8702:
8703: hr_utility.trace('Form6: cur_notfound' );
8704:
8705: per_ca_ee_extract_pkg.k := per_ca_ee_extract_pkg.k + 1;
8706:
8707: insert into per_ca_ee_report_lines

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

8753: end loop; -- End loop cur_eeog
8754:
8755: for count_national in cur_count_national loop
8756:
8757: hr_utility.trace('Form6: cur_count_national. ');
8758:
8759: insert into per_ca_ee_report_lines
8760: (request_id,
8761: line_number,

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

8889: segment21 = v_not_max_naic;
8890:
8891: begin
8892:
8893: hr_utility.trace('Function update_rec starts here !!!!');
8894:
8895: open cur_temp_count;
8896: fetch cur_temp_count
8897: into v_tot_fr,

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

8939: into v_max_naic_code,
8940: v_max_naic_count;
8941: close cur_max_naic;
8942:
8943: hr_utility.trace('UPDATE_REC: v_max_naic_code: ' || v_max_naic_code);
8944:
8945: for naic in cur_less_than_max_naic loop
8946:
8947: v_not_max_naic := naic.naic_code;

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

8945: for naic in cur_less_than_max_naic loop
8946:
8947: v_not_max_naic := naic.naic_code;
8948:
8949: hr_utility.trace('UPDATE_REC: v_not_max_naic: ' || v_not_max_naic);
8950:
8951: for i in cur_not_max_naic_data loop
8952:
8953: hr_utility.trace('UPDATE_REC: Form3 - 6' );

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

8949: hr_utility.trace('UPDATE_REC: v_not_max_naic: ' || v_not_max_naic);
8950:
8951: for i in cur_not_max_naic_data loop
8952:
8953: hr_utility.trace('UPDATE_REC: Form3 - 6' );
8954:
8955: update per_ca_ee_report_lines
8956: set
8957: segment4 = segment4 + i.segment4,

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

8973: segment2 = i.segment2 and
8974: segment3 = i.segment3 and
8975: segment21 = v_max_naic_code;
8976:
8977: hr_utility.trace('UPDATE_REC: Form3 - 6 End' );
8978:
8979: end loop; -- End loop cur_not_max_naic_data
8980:
8981: delete from per_ca_ee_report_lines