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_CA_EMP_EQUITY_PKG dependencies on FND_GLOBAL

Line 759: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province ||fnd_global.local_chr(9)

755: end if;
756: end if;
757: if l_flag = 'Y' then
758: if l_employment_category in ('01','02') then
759: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province ||fnd_global.local_chr(9)
760: ||l_noc_code||fnd_global.local_chr(9)||l_naics_no||fnd_global.local_chr(9)||l_employment_category
761: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||l_gender||fnd_global.local_chr(9)||l_last_name
762: ||fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)||l_salary||fnd_global.local_chr(9)
763: ||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor||fnd_global.local_chr(9)||l_desg_disab

Line 760: ||l_noc_code||fnd_global.local_chr(9)||l_naics_no||fnd_global.local_chr(9)||l_employment_category

756: end if;
757: if l_flag = 'Y' then
758: if l_employment_category in ('01','02') then
759: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province ||fnd_global.local_chr(9)
760: ||l_noc_code||fnd_global.local_chr(9)||l_naics_no||fnd_global.local_chr(9)||l_employment_category
761: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||l_gender||fnd_global.local_chr(9)||l_last_name
762: ||fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)||l_salary||fnd_global.local_chr(9)
763: ||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor||fnd_global.local_chr(9)||l_desg_disab
764: ||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')||fnd_global.local_chr(9)

Line 761: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||l_gender||fnd_global.local_chr(9)||l_last_name

757: if l_flag = 'Y' then
758: if l_employment_category in ('01','02') then
759: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province ||fnd_global.local_chr(9)
760: ||l_noc_code||fnd_global.local_chr(9)||l_naics_no||fnd_global.local_chr(9)||l_employment_category
761: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||l_gender||fnd_global.local_chr(9)||l_last_name
762: ||fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)||l_salary||fnd_global.local_chr(9)
763: ||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor||fnd_global.local_chr(9)||l_desg_disab
764: ||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')||fnd_global.local_chr(9)
765: ||to_char(l_term_date,'YYYY/MM/DD')||fnd_global.local_chr(9)||fnd_global.local_chr(9)

Line 762: ||fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)||l_salary||fnd_global.local_chr(9)

758: if l_employment_category in ('01','02') then
759: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province ||fnd_global.local_chr(9)
760: ||l_noc_code||fnd_global.local_chr(9)||l_naics_no||fnd_global.local_chr(9)||l_employment_category
761: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||l_gender||fnd_global.local_chr(9)||l_last_name
762: ||fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)||l_salary||fnd_global.local_chr(9)
763: ||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor||fnd_global.local_chr(9)||l_desg_disab
764: ||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')||fnd_global.local_chr(9)
765: ||to_char(l_term_date,'YYYY/MM/DD')||fnd_global.local_chr(9)||fnd_global.local_chr(9)
766: ||fnd_global.local_chr(9)||fnd_global.local_chr(9);

Line 763: ||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor||fnd_global.local_chr(9)||l_desg_disab

759: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province ||fnd_global.local_chr(9)
760: ||l_noc_code||fnd_global.local_chr(9)||l_naics_no||fnd_global.local_chr(9)||l_employment_category
761: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||l_gender||fnd_global.local_chr(9)||l_last_name
762: ||fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)||l_salary||fnd_global.local_chr(9)
763: ||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor||fnd_global.local_chr(9)||l_desg_disab
764: ||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')||fnd_global.local_chr(9)
765: ||to_char(l_term_date,'YYYY/MM/DD')||fnd_global.local_chr(9)||fnd_global.local_chr(9)
766: ||fnd_global.local_chr(9)||fnd_global.local_chr(9);
767: else

Line 764: ||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')||fnd_global.local_chr(9)

760: ||l_noc_code||fnd_global.local_chr(9)||l_naics_no||fnd_global.local_chr(9)||l_employment_category
761: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||l_gender||fnd_global.local_chr(9)||l_last_name
762: ||fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)||l_salary||fnd_global.local_chr(9)
763: ||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor||fnd_global.local_chr(9)||l_desg_disab
764: ||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')||fnd_global.local_chr(9)
765: ||to_char(l_term_date,'YYYY/MM/DD')||fnd_global.local_chr(9)||fnd_global.local_chr(9)
766: ||fnd_global.local_chr(9)||fnd_global.local_chr(9);
767: else
768:

Line 765: ||to_char(l_term_date,'YYYY/MM/DD')||fnd_global.local_chr(9)||fnd_global.local_chr(9)

761: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||l_gender||fnd_global.local_chr(9)||l_last_name
762: ||fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)||l_salary||fnd_global.local_chr(9)
763: ||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor||fnd_global.local_chr(9)||l_desg_disab
764: ||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')||fnd_global.local_chr(9)
765: ||to_char(l_term_date,'YYYY/MM/DD')||fnd_global.local_chr(9)||fnd_global.local_chr(9)
766: ||fnd_global.local_chr(9)||fnd_global.local_chr(9);
767: else
768:
769: if l_tmp_cnt > 0 then

Line 766: ||fnd_global.local_chr(9)||fnd_global.local_chr(9);

762: ||fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)||l_salary||fnd_global.local_chr(9)
763: ||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor||fnd_global.local_chr(9)||l_desg_disab
764: ||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')||fnd_global.local_chr(9)
765: ||to_char(l_term_date,'YYYY/MM/DD')||fnd_global.local_chr(9)||fnd_global.local_chr(9)
766: ||fnd_global.local_chr(9)||fnd_global.local_chr(9);
767: else
768:
769: if l_tmp_cnt > 0 then
770: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province

Line 770: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province

766: ||fnd_global.local_chr(9)||fnd_global.local_chr(9);
767: else
768:
769: if l_tmp_cnt > 0 then
770: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province
771: ||fnd_global.local_chr(9)||l_noc_code||fnd_global.local_chr(9)||l_naics_no||fnd_global.local_chr(9)
772: ||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)
773: ||l_gender||fnd_global.local_chr(9)||l_last_name || fnd_global.local_chr(9)||l_first_name
774: ||fnd_global.local_chr(9)||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor

Line 771: ||fnd_global.local_chr(9)||l_noc_code||fnd_global.local_chr(9)||l_naics_no||fnd_global.local_chr(9)

767: else
768:
769: if l_tmp_cnt > 0 then
770: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province
771: ||fnd_global.local_chr(9)||l_noc_code||fnd_global.local_chr(9)||l_naics_no||fnd_global.local_chr(9)
772: ||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)
773: ||l_gender||fnd_global.local_chr(9)||l_last_name || fnd_global.local_chr(9)||l_first_name
774: ||fnd_global.local_chr(9)||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor
775: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')

Line 772: ||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)

768:
769: if l_tmp_cnt > 0 then
770: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province
771: ||fnd_global.local_chr(9)||l_noc_code||fnd_global.local_chr(9)||l_naics_no||fnd_global.local_chr(9)
772: ||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)
773: ||l_gender||fnd_global.local_chr(9)||l_last_name || fnd_global.local_chr(9)||l_first_name
774: ||fnd_global.local_chr(9)||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor
775: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')
776: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)

Line 773: ||l_gender||fnd_global.local_chr(9)||l_last_name || fnd_global.local_chr(9)||l_first_name

769: if l_tmp_cnt > 0 then
770: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province
771: ||fnd_global.local_chr(9)||l_noc_code||fnd_global.local_chr(9)||l_naics_no||fnd_global.local_chr(9)
772: ||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)
773: ||l_gender||fnd_global.local_chr(9)||l_last_name || fnd_global.local_chr(9)||l_first_name
774: ||fnd_global.local_chr(9)||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor
775: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')
776: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)
777: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||to_char(l_tmp_cnt,'09');

Line 774: ||fnd_global.local_chr(9)||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor

770: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province
771: ||fnd_global.local_chr(9)||l_noc_code||fnd_global.local_chr(9)||l_naics_no||fnd_global.local_chr(9)
772: ||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)
773: ||l_gender||fnd_global.local_chr(9)||l_last_name || fnd_global.local_chr(9)||l_first_name
774: ||fnd_global.local_chr(9)||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor
775: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')
776: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)
777: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||to_char(l_tmp_cnt,'09');
778: else

Line 775: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')

771: ||fnd_global.local_chr(9)||l_noc_code||fnd_global.local_chr(9)||l_naics_no||fnd_global.local_chr(9)
772: ||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)
773: ||l_gender||fnd_global.local_chr(9)||l_last_name || fnd_global.local_chr(9)||l_first_name
774: ||fnd_global.local_chr(9)||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor
775: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')
776: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)
777: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||to_char(l_tmp_cnt,'09');
778: else
779: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province

Line 776: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)

772: ||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)
773: ||l_gender||fnd_global.local_chr(9)||l_last_name || fnd_global.local_chr(9)||l_first_name
774: ||fnd_global.local_chr(9)||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor
775: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')
776: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)
777: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||to_char(l_tmp_cnt,'09');
778: else
779: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province
780: ||fnd_global.local_chr(9)||l_noc_code||fnd_global.local_chr(9)||l_naics_no

Line 777: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||to_char(l_tmp_cnt,'09');

773: ||l_gender||fnd_global.local_chr(9)||l_last_name || fnd_global.local_chr(9)||l_first_name
774: ||fnd_global.local_chr(9)||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor
775: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')
776: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)
777: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||to_char(l_tmp_cnt,'09');
778: else
779: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province
780: ||fnd_global.local_chr(9)||l_noc_code||fnd_global.local_chr(9)||l_naics_no
781: ||fnd_global.local_chr(9)||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)

Line 779: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province

775: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')
776: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)
777: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||to_char(l_tmp_cnt,'09');
778: else
779: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province
780: ||fnd_global.local_chr(9)||l_noc_code||fnd_global.local_chr(9)||l_naics_no
781: ||fnd_global.local_chr(9)||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)
782: ||l_gender||fnd_global.local_chr(9)||l_last_name || fnd_global.local_chr(9)||l_first_name
783: ||fnd_global.local_chr(9)||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor

Line 780: ||fnd_global.local_chr(9)||l_noc_code||fnd_global.local_chr(9)||l_naics_no

776: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)
777: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||to_char(l_tmp_cnt,'09');
778: else
779: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province
780: ||fnd_global.local_chr(9)||l_noc_code||fnd_global.local_chr(9)||l_naics_no
781: ||fnd_global.local_chr(9)||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)
782: ||l_gender||fnd_global.local_chr(9)||l_last_name || fnd_global.local_chr(9)||l_first_name
783: ||fnd_global.local_chr(9)||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor
784: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')

Line 781: ||fnd_global.local_chr(9)||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)

777: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||to_char(l_tmp_cnt,'09');
778: else
779: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province
780: ||fnd_global.local_chr(9)||l_noc_code||fnd_global.local_chr(9)||l_naics_no
781: ||fnd_global.local_chr(9)||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)
782: ||l_gender||fnd_global.local_chr(9)||l_last_name || fnd_global.local_chr(9)||l_first_name
783: ||fnd_global.local_chr(9)||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor
784: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')
785: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)

Line 782: ||l_gender||fnd_global.local_chr(9)||l_last_name || fnd_global.local_chr(9)||l_first_name

778: else
779: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province
780: ||fnd_global.local_chr(9)||l_noc_code||fnd_global.local_chr(9)||l_naics_no
781: ||fnd_global.local_chr(9)||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)
782: ||l_gender||fnd_global.local_chr(9)||l_last_name || fnd_global.local_chr(9)||l_first_name
783: ||fnd_global.local_chr(9)||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor
784: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')
785: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)
786: ||fnd_global.local_chr(9)||fnd_global.local_chr(9);

Line 783: ||fnd_global.local_chr(9)||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor

779: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province
780: ||fnd_global.local_chr(9)||l_noc_code||fnd_global.local_chr(9)||l_naics_no
781: ||fnd_global.local_chr(9)||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)
782: ||l_gender||fnd_global.local_chr(9)||l_last_name || fnd_global.local_chr(9)||l_first_name
783: ||fnd_global.local_chr(9)||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor
784: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')
785: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)
786: ||fnd_global.local_chr(9)||fnd_global.local_chr(9);
787: end if;

Line 784: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')

780: ||fnd_global.local_chr(9)||l_noc_code||fnd_global.local_chr(9)||l_naics_no
781: ||fnd_global.local_chr(9)||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)
782: ||l_gender||fnd_global.local_chr(9)||l_last_name || fnd_global.local_chr(9)||l_first_name
783: ||fnd_global.local_chr(9)||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor
784: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')
785: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)
786: ||fnd_global.local_chr(9)||fnd_global.local_chr(9);
787: end if;
788: end if;

Line 785: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)

781: ||fnd_global.local_chr(9)||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)
782: ||l_gender||fnd_global.local_chr(9)||l_last_name || fnd_global.local_chr(9)||l_first_name
783: ||fnd_global.local_chr(9)||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor
784: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')
785: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)
786: ||fnd_global.local_chr(9)||fnd_global.local_chr(9);
787: end if;
788: end if;
789:

Line 786: ||fnd_global.local_chr(9)||fnd_global.local_chr(9);

782: ||l_gender||fnd_global.local_chr(9)||l_last_name || fnd_global.local_chr(9)||l_first_name
783: ||fnd_global.local_chr(9)||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor
784: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')
785: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)
786: ||fnd_global.local_chr(9)||fnd_global.local_chr(9);
787: end if;
788: end if;
789:
790: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_output_txt);

Line 918: l_output := l_emp_no ||fnd_global.local_chr(9)||l_promo_cnt || fnd_global.local_chr(9) || l_promo_dt;

914: l_promo_cnt := 1;
915: else
916: l_promo_cnt := l_promo_cnt + 1;
917: end if;
918: l_output := l_emp_no ||fnd_global.local_chr(9)||l_promo_cnt || fnd_global.local_chr(9) || l_promo_dt;
919: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_output);
920: l_prev_emp := l_emp_no;
921: end loop;
922: /* Deleteing the promotion records from per_ca_ee_report_lines table */

Line 979: l_output := l_emp_no ||fnd_global.local_chr(9)||l_term_cnt||fnd_global.local_chr(9)||l_start_dt

975: l_term_cnt := 0;
976: end if;
977: if l_term_cnt > 0 then
978: if l_end_dt <> l_term_dt then
979: l_output := l_emp_no ||fnd_global.local_chr(9)||l_term_cnt||fnd_global.local_chr(9)||l_start_dt
980: ||fnd_global.local_chr(9)||l_end_dt||fnd_global.local_chr(9)||l_term_dt;
981: else
982: l_output := l_emp_no ||fnd_global.local_chr(9)||l_term_cnt||fnd_global.local_chr(9)
983: ||l_start_dt||fnd_global.local_chr(9)||l_end_dt;

Line 980: ||fnd_global.local_chr(9)||l_end_dt||fnd_global.local_chr(9)||l_term_dt;

976: end if;
977: if l_term_cnt > 0 then
978: if l_end_dt <> l_term_dt then
979: l_output := l_emp_no ||fnd_global.local_chr(9)||l_term_cnt||fnd_global.local_chr(9)||l_start_dt
980: ||fnd_global.local_chr(9)||l_end_dt||fnd_global.local_chr(9)||l_term_dt;
981: else
982: l_output := l_emp_no ||fnd_global.local_chr(9)||l_term_cnt||fnd_global.local_chr(9)
983: ||l_start_dt||fnd_global.local_chr(9)||l_end_dt;
984: end if;

Line 982: l_output := l_emp_no ||fnd_global.local_chr(9)||l_term_cnt||fnd_global.local_chr(9)

978: if l_end_dt <> l_term_dt then
979: l_output := l_emp_no ||fnd_global.local_chr(9)||l_term_cnt||fnd_global.local_chr(9)||l_start_dt
980: ||fnd_global.local_chr(9)||l_end_dt||fnd_global.local_chr(9)||l_term_dt;
981: else
982: l_output := l_emp_no ||fnd_global.local_chr(9)||l_term_cnt||fnd_global.local_chr(9)
983: ||l_start_dt||fnd_global.local_chr(9)||l_end_dt;
984: end if;
985: else
986: l_output := l_emp_no ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||l_start_dt||fnd_global.local_chr(9)

Line 983: ||l_start_dt||fnd_global.local_chr(9)||l_end_dt;

979: l_output := l_emp_no ||fnd_global.local_chr(9)||l_term_cnt||fnd_global.local_chr(9)||l_start_dt
980: ||fnd_global.local_chr(9)||l_end_dt||fnd_global.local_chr(9)||l_term_dt;
981: else
982: l_output := l_emp_no ||fnd_global.local_chr(9)||l_term_cnt||fnd_global.local_chr(9)
983: ||l_start_dt||fnd_global.local_chr(9)||l_end_dt;
984: end if;
985: else
986: l_output := l_emp_no ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||l_start_dt||fnd_global.local_chr(9)
987: ||l_end_dt||fnd_global.local_chr(9)||l_term_dt;

Line 986: l_output := l_emp_no ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||l_start_dt||fnd_global.local_chr(9)

982: l_output := l_emp_no ||fnd_global.local_chr(9)||l_term_cnt||fnd_global.local_chr(9)
983: ||l_start_dt||fnd_global.local_chr(9)||l_end_dt;
984: end if;
985: else
986: l_output := l_emp_no ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||l_start_dt||fnd_global.local_chr(9)
987: ||l_end_dt||fnd_global.local_chr(9)||l_term_dt;
988: end if;
989: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_output);
990: l_prev_emp := l_emp_no;

Line 987: ||l_end_dt||fnd_global.local_chr(9)||l_term_dt;

983: ||l_start_dt||fnd_global.local_chr(9)||l_end_dt;
984: end if;
985: else
986: l_output := l_emp_no ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||l_start_dt||fnd_global.local_chr(9)
987: ||l_end_dt||fnd_global.local_chr(9)||l_term_dt;
988: end if;
989: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_output);
990: l_prev_emp := l_emp_no;
991: end loop;

Line 1050: l_output := l_output ||fnd_global.local_chr(9)||l_count||')'|| l_prov;

1046: hr_utility.trace('The value of Employee number is '||l_emp_no);
1047: l_output := 'Following information are missing for Employee :'||l_emp_no;
1048: if l_prov is not null then
1049: l_count := l_count + 1;
1050: l_output := l_output ||fnd_global.local_chr(9)||l_count||')'|| l_prov;
1051: l_flag := 'Y';
1052: end if;
1053:
1054: if l_naic is not null then

Line 1056: l_output := l_output ||fnd_global.local_chr(9)||l_count||')'|| l_naic;

1052: end if;
1053:
1054: if l_naic is not null then
1055: l_count := l_count + 1;
1056: l_output := l_output ||fnd_global.local_chr(9)||l_count||')'|| l_naic;
1057: l_flag := 'Y';
1058: end if;
1059:
1060: if l_cma is not null then

Line 1062: l_output := l_output ||fnd_global.local_chr(9)||l_count||')'|| l_cma;

1058: end if;
1059:
1060: if l_cma is not null then
1061: l_count := l_count + 1;
1062: l_output := l_output ||fnd_global.local_chr(9)||l_count||')'|| l_cma;
1063: l_flag :='Y';
1064: end if;
1065:
1066: if l_emp_catg is not null then

Line 1068: l_output := l_output || fnd_global.local_chr(9)||l_count||')'||l_emp_catg;

1064: end if;
1065:
1066: if l_emp_catg is not null then
1067: l_count := l_count + 1;
1068: l_output := l_output || fnd_global.local_chr(9)||l_count||')'||l_emp_catg;
1069: end if;
1070:
1071: if l_sal is not null then
1072: l_count := l_count + 1;

Line 1073: l_output := l_output ||fnd_global.local_chr(9)||l_count||')'|| l_sal;

1069: end if;
1070:
1071: if l_sal is not null then
1072: l_count := l_count + 1;
1073: l_output := l_output ||fnd_global.local_chr(9)||l_count||')'|| l_sal;
1074: end if;
1075:
1076: if l_flag = 'Y' then
1077: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_output);