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 831: 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)

827: end if;
828: end if;
829: if l_flag = 'Y' then
830: if l_employment_category in ('01','02','04') then
831: 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)
832: ||l_noc_code||fnd_global.local_chr(9)||l_naics_no||fnd_global.local_chr(9)||l_employment_category
833: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||l_gender||fnd_global.local_chr(9)
834: --commented for bug 10287946
835: --||l_last_name||fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)

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

828: end if;
829: if l_flag = 'Y' then
830: if l_employment_category in ('01','02','04') then
831: 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)
832: ||l_noc_code||fnd_global.local_chr(9)||l_naics_no||fnd_global.local_chr(9)||l_employment_category
833: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||l_gender||fnd_global.local_chr(9)
834: --commented for bug 10287946
835: --||l_last_name||fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)
836: ||l_salary||fnd_global.local_chr(9)

Line 833: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||l_gender||fnd_global.local_chr(9)

829: if l_flag = 'Y' then
830: if l_employment_category in ('01','02','04') then
831: 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)
832: ||l_noc_code||fnd_global.local_chr(9)||l_naics_no||fnd_global.local_chr(9)||l_employment_category
833: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||l_gender||fnd_global.local_chr(9)
834: --commented for bug 10287946
835: --||l_last_name||fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)
836: ||l_salary||fnd_global.local_chr(9)
837: ||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor||fnd_global.local_chr(9)||l_desg_disab

Line 835: --||l_last_name||fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)

831: 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)
832: ||l_noc_code||fnd_global.local_chr(9)||l_naics_no||fnd_global.local_chr(9)||l_employment_category
833: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||l_gender||fnd_global.local_chr(9)
834: --commented for bug 10287946
835: --||l_last_name||fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)
836: ||l_salary||fnd_global.local_chr(9)
837: ||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor||fnd_global.local_chr(9)||l_desg_disab
838: ||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')||fnd_global.local_chr(9)
839: ||to_char(l_term_date,'YYYY/MM/DD')||fnd_global.local_chr(9)||fnd_global.local_chr(9)

Line 836: ||l_salary||fnd_global.local_chr(9)

832: ||l_noc_code||fnd_global.local_chr(9)||l_naics_no||fnd_global.local_chr(9)||l_employment_category
833: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||l_gender||fnd_global.local_chr(9)
834: --commented for bug 10287946
835: --||l_last_name||fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)
836: ||l_salary||fnd_global.local_chr(9)
837: ||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor||fnd_global.local_chr(9)||l_desg_disab
838: ||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')||fnd_global.local_chr(9)
839: ||to_char(l_term_date,'YYYY/MM/DD')||fnd_global.local_chr(9)||fnd_global.local_chr(9)
840: ||fnd_global.local_chr(9)||fnd_global.local_chr(9);

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

833: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||l_gender||fnd_global.local_chr(9)
834: --commented for bug 10287946
835: --||l_last_name||fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)
836: ||l_salary||fnd_global.local_chr(9)
837: ||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor||fnd_global.local_chr(9)||l_desg_disab
838: ||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')||fnd_global.local_chr(9)
839: ||to_char(l_term_date,'YYYY/MM/DD')||fnd_global.local_chr(9)||fnd_global.local_chr(9)
840: ||fnd_global.local_chr(9)||fnd_global.local_chr(9);
841: --commented for bug 10287946

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

834: --commented for bug 10287946
835: --||l_last_name||fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)
836: ||l_salary||fnd_global.local_chr(9)
837: ||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor||fnd_global.local_chr(9)||l_desg_disab
838: ||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')||fnd_global.local_chr(9)
839: ||to_char(l_term_date,'YYYY/MM/DD')||fnd_global.local_chr(9)||fnd_global.local_chr(9)
840: ||fnd_global.local_chr(9)||fnd_global.local_chr(9);
841: --commented for bug 10287946
842: /* else

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

835: --||l_last_name||fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)
836: ||l_salary||fnd_global.local_chr(9)
837: ||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor||fnd_global.local_chr(9)||l_desg_disab
838: ||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')||fnd_global.local_chr(9)
839: ||to_char(l_term_date,'YYYY/MM/DD')||fnd_global.local_chr(9)||fnd_global.local_chr(9)
840: ||fnd_global.local_chr(9)||fnd_global.local_chr(9);
841: --commented for bug 10287946
842: /* else
843: if l_tmp_cnt > 0 then

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

836: ||l_salary||fnd_global.local_chr(9)
837: ||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor||fnd_global.local_chr(9)||l_desg_disab
838: ||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')||fnd_global.local_chr(9)
839: ||to_char(l_term_date,'YYYY/MM/DD')||fnd_global.local_chr(9)||fnd_global.local_chr(9)
840: ||fnd_global.local_chr(9)||fnd_global.local_chr(9);
841: --commented for bug 10287946
842: /* else
843: if l_tmp_cnt > 0 then
844: hr_utility.trace('Employee '||l_emp_no||' has l_tmp_cnt');

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

842: /* else
843: if l_tmp_cnt > 0 then
844: hr_utility.trace('Employee '||l_emp_no||' has l_tmp_cnt');
845: hr_utility.trace('l_employment_category '||l_employment_category);
846: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province
847: ||fnd_global.local_chr(9)||l_noc_code||fnd_global.local_chr(9)||l_naics_no||fnd_global.local_chr(9)
848: ||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)
849: ||l_gender||fnd_global.local_chr(9)
850: --commented for bug 10287946

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

843: if l_tmp_cnt > 0 then
844: hr_utility.trace('Employee '||l_emp_no||' has l_tmp_cnt');
845: hr_utility.trace('l_employment_category '||l_employment_category);
846: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province
847: ||fnd_global.local_chr(9)||l_noc_code||fnd_global.local_chr(9)||l_naics_no||fnd_global.local_chr(9)
848: ||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)
849: ||l_gender||fnd_global.local_chr(9)
850: --commented for bug 10287946
851: --||l_last_name || fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)

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

844: hr_utility.trace('Employee '||l_emp_no||' has l_tmp_cnt');
845: hr_utility.trace('l_employment_category '||l_employment_category);
846: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province
847: ||fnd_global.local_chr(9)||l_noc_code||fnd_global.local_chr(9)||l_naics_no||fnd_global.local_chr(9)
848: ||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)
849: ||l_gender||fnd_global.local_chr(9)
850: --commented for bug 10287946
851: --||l_last_name || fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)
852: ||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor

Line 849: ||l_gender||fnd_global.local_chr(9)

845: hr_utility.trace('l_employment_category '||l_employment_category);
846: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province
847: ||fnd_global.local_chr(9)||l_noc_code||fnd_global.local_chr(9)||l_naics_no||fnd_global.local_chr(9)
848: ||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)
849: ||l_gender||fnd_global.local_chr(9)
850: --commented for bug 10287946
851: --||l_last_name || fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)
852: ||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor
853: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')

Line 851: --||l_last_name || fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)

847: ||fnd_global.local_chr(9)||l_noc_code||fnd_global.local_chr(9)||l_naics_no||fnd_global.local_chr(9)
848: ||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)
849: ||l_gender||fnd_global.local_chr(9)
850: --commented for bug 10287946
851: --||l_last_name || fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)
852: ||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor
853: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')
854: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)
855: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||to_char(l_tmp_cnt,'09');*/

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

848: ||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)
849: ||l_gender||fnd_global.local_chr(9)
850: --commented for bug 10287946
851: --||l_last_name || fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)
852: ||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor
853: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')
854: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)
855: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||to_char(l_tmp_cnt,'09');*/
856: else

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

849: ||l_gender||fnd_global.local_chr(9)
850: --commented for bug 10287946
851: --||l_last_name || fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)
852: ||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor
853: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')
854: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)
855: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||to_char(l_tmp_cnt,'09');*/
856: else
857: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province

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

850: --commented for bug 10287946
851: --||l_last_name || fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)
852: ||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor
853: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')
854: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)
855: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||to_char(l_tmp_cnt,'09');*/
856: else
857: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province
858: ||fnd_global.local_chr(9)||l_noc_code||fnd_global.local_chr(9)||l_naics_no

Line 855: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||to_char(l_tmp_cnt,'09');*/

851: --||l_last_name || fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)
852: ||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor
853: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')
854: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)
855: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||to_char(l_tmp_cnt,'09');*/
856: else
857: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province
858: ||fnd_global.local_chr(9)||l_noc_code||fnd_global.local_chr(9)||l_naics_no
859: ||fnd_global.local_chr(9)||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)

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

853: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)||to_char(l_hire_date,'YYYY/MM/DD')
854: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)
855: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||to_char(l_tmp_cnt,'09');*/
856: else
857: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province
858: ||fnd_global.local_chr(9)||l_noc_code||fnd_global.local_chr(9)||l_naics_no
859: ||fnd_global.local_chr(9)||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)
860: ||l_gender||fnd_global.local_chr(9)
861: --commented for bug 10287946

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

854: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)
855: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||to_char(l_tmp_cnt,'09');*/
856: else
857: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province
858: ||fnd_global.local_chr(9)||l_noc_code||fnd_global.local_chr(9)||l_naics_no
859: ||fnd_global.local_chr(9)||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)
860: ||l_gender||fnd_global.local_chr(9)
861: --commented for bug 10287946
862: --||l_last_name || fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)

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

855: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||to_char(l_tmp_cnt,'09');*/
856: else
857: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province
858: ||fnd_global.local_chr(9)||l_noc_code||fnd_global.local_chr(9)||l_naics_no
859: ||fnd_global.local_chr(9)||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)
860: ||l_gender||fnd_global.local_chr(9)
861: --commented for bug 10287946
862: --||l_last_name || fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)
863: ||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor

Line 860: ||l_gender||fnd_global.local_chr(9)

856: else
857: l_output_txt := l_emp_no|| fnd_global.local_chr(9)||l_cma_code||fnd_global.local_chr(9)||l_province
858: ||fnd_global.local_chr(9)||l_noc_code||fnd_global.local_chr(9)||l_naics_no
859: ||fnd_global.local_chr(9)||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)
860: ||l_gender||fnd_global.local_chr(9)
861: --commented for bug 10287946
862: --||l_last_name || fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)
863: ||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor
864: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)

Line 862: --||l_last_name || fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)

858: ||fnd_global.local_chr(9)||l_noc_code||fnd_global.local_chr(9)||l_naics_no
859: ||fnd_global.local_chr(9)||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)
860: ||l_gender||fnd_global.local_chr(9)
861: --commented for bug 10287946
862: --||l_last_name || fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)
863: ||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor
864: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)
865: --||to_char(l_hire_date,'YYYY/MM/DD')||fnd_global.local_chr(9)
866: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)

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

859: ||fnd_global.local_chr(9)||l_employment_category||fnd_global.local_chr(9)||fnd_global.local_chr(9)
860: ||l_gender||fnd_global.local_chr(9)
861: --commented for bug 10287946
862: --||l_last_name || fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)
863: ||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor
864: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)
865: --||to_char(l_hire_date,'YYYY/MM/DD')||fnd_global.local_chr(9)
866: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)
867: ||fnd_global.local_chr(9)||fnd_global.local_chr(9);

Line 864: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)

860: ||l_gender||fnd_global.local_chr(9)
861: --commented for bug 10287946
862: --||l_last_name || fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)
863: ||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor
864: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)
865: --||to_char(l_hire_date,'YYYY/MM/DD')||fnd_global.local_chr(9)
866: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)
867: ||fnd_global.local_chr(9)||fnd_global.local_chr(9);
868: -- end if;

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

861: --commented for bug 10287946
862: --||l_last_name || fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)
863: ||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor
864: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)
865: --||to_char(l_hire_date,'YYYY/MM/DD')||fnd_global.local_chr(9)
866: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)
867: ||fnd_global.local_chr(9)||fnd_global.local_chr(9);
868: -- end if;
869: end if;

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

862: --||l_last_name || fnd_global.local_chr(9)||l_first_name||fnd_global.local_chr(9)
863: ||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor
864: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)
865: --||to_char(l_hire_date,'YYYY/MM/DD')||fnd_global.local_chr(9)
866: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)
867: ||fnd_global.local_chr(9)||fnd_global.local_chr(9);
868: -- end if;
869: end if;
870:

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

863: ||l_salary||fnd_global.local_chr(9)||l_desg_abor||fnd_global.local_chr(9)||l_desg_vminor
864: ||fnd_global.local_chr(9)||l_desg_disab||fnd_global.local_chr(9)
865: --||to_char(l_hire_date,'YYYY/MM/DD')||fnd_global.local_chr(9)
866: ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||fnd_global.local_chr(9)
867: ||fnd_global.local_chr(9)||fnd_global.local_chr(9);
868: -- end if;
869: end if;
870:
871: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_output_txt);

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

993: l_promo_cnt := 1;
994: else
995: l_promo_cnt := l_promo_cnt + 1;
996: end if;
997: l_output := l_emp_no ||fnd_global.local_chr(9)||l_promo_cnt || fnd_global.local_chr(9) || l_promo_dt;
998: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_output);
999: l_prev_emp := l_emp_no;
1000: end loop;
1001: /* Deleteing the promotion records from per_ca_ee_report_lines table */

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

1056: l_term_cnt := 1; -- bug 10287946
1057: end if;
1058: --if l_term_cnt > 0 then
1059: if l_end_dt > l_term_dt then
1060: l_output := l_emp_no ||fnd_global.local_chr(9)||l_term_cnt||fnd_global.local_chr(9)||l_start_dt
1061: ||fnd_global.local_chr(9)||l_end_dt||fnd_global.local_chr(9)||l_term_dt;
1062: else
1063: l_output := l_emp_no ||fnd_global.local_chr(9)||l_term_cnt||fnd_global.local_chr(9)
1064: ||l_start_dt||fnd_global.local_chr(9)||l_end_dt;

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

1057: end if;
1058: --if l_term_cnt > 0 then
1059: if l_end_dt > l_term_dt then
1060: l_output := l_emp_no ||fnd_global.local_chr(9)||l_term_cnt||fnd_global.local_chr(9)||l_start_dt
1061: ||fnd_global.local_chr(9)||l_end_dt||fnd_global.local_chr(9)||l_term_dt;
1062: else
1063: l_output := l_emp_no ||fnd_global.local_chr(9)||l_term_cnt||fnd_global.local_chr(9)
1064: ||l_start_dt||fnd_global.local_chr(9)||l_end_dt;
1065: end if;

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

1059: if l_end_dt > l_term_dt then
1060: l_output := l_emp_no ||fnd_global.local_chr(9)||l_term_cnt||fnd_global.local_chr(9)||l_start_dt
1061: ||fnd_global.local_chr(9)||l_end_dt||fnd_global.local_chr(9)||l_term_dt;
1062: else
1063: l_output := l_emp_no ||fnd_global.local_chr(9)||l_term_cnt||fnd_global.local_chr(9)
1064: ||l_start_dt||fnd_global.local_chr(9)||l_end_dt;
1065: end if;
1066: -- commented for bug 10287946
1067: /*else

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

1060: l_output := l_emp_no ||fnd_global.local_chr(9)||l_term_cnt||fnd_global.local_chr(9)||l_start_dt
1061: ||fnd_global.local_chr(9)||l_end_dt||fnd_global.local_chr(9)||l_term_dt;
1062: else
1063: l_output := l_emp_no ||fnd_global.local_chr(9)||l_term_cnt||fnd_global.local_chr(9)
1064: ||l_start_dt||fnd_global.local_chr(9)||l_end_dt;
1065: end if;
1066: -- commented for bug 10287946
1067: /*else
1068: l_output := l_emp_no ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||l_start_dt||fnd_global.local_chr(9)

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

1064: ||l_start_dt||fnd_global.local_chr(9)||l_end_dt;
1065: end if;
1066: -- commented for bug 10287946
1067: /*else
1068: l_output := l_emp_no ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||l_start_dt||fnd_global.local_chr(9)
1069: ||l_end_dt||fnd_global.local_chr(9)||l_term_dt;
1070: end if;*/
1071: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_output);
1072: l_prev_emp := l_emp_no;

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

1065: end if;
1066: -- commented for bug 10287946
1067: /*else
1068: l_output := l_emp_no ||fnd_global.local_chr(9)||fnd_global.local_chr(9)||l_start_dt||fnd_global.local_chr(9)
1069: ||l_end_dt||fnd_global.local_chr(9)||l_term_dt;
1070: end if;*/
1071: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_output);
1072: l_prev_emp := l_emp_no;
1073: end loop;

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

1132: hr_utility.trace('The value of Employee number is '||l_emp_no);
1133: l_output := 'Following information are missing for Employee :'||l_emp_no;
1134: if l_prov is not null then
1135: l_count := l_count + 1;
1136: l_output := l_output ||fnd_global.local_chr(9)||l_count||')'|| l_prov;
1137: l_flag := 'Y';
1138: end if;
1139:
1140: if l_naic is not null then

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

1138: end if;
1139:
1140: if l_naic is not null then
1141: l_count := l_count + 1;
1142: l_output := l_output ||fnd_global.local_chr(9)||l_count||')'|| l_naic;
1143: l_flag := 'Y';
1144: end if;
1145:
1146: if l_cma is not null then

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

1144: end if;
1145:
1146: if l_cma is not null then
1147: l_count := l_count + 1;
1148: l_output := l_output ||fnd_global.local_chr(9)||l_count||')'|| l_cma;
1149: l_flag :='Y';
1150: end if;
1151:
1152: if l_emp_catg is not null then

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

1150: end if;
1151:
1152: if l_emp_catg is not null then
1153: l_count := l_count + 1;
1154: l_output := l_output || fnd_global.local_chr(9)||l_count||')'||l_emp_catg;
1155: l_flag :='Y';
1156: end if;
1157:
1158: if l_sal is not null then

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

1156: end if;
1157:
1158: if l_sal is not null then
1159: l_count := l_count + 1;
1160: l_output := l_output ||fnd_global.local_chr(9)||l_count||')'|| l_sal;
1161: l_flag :='Y';
1162: end if;
1163: if l_noc is not null then
1164: l_count := l_count + 1;

Line 1165: l_output := l_output ||fnd_global.local_chr(9)||l_count||')'|| l_noc;

1161: l_flag :='Y';
1162: end if;
1163: if l_noc is not null then
1164: l_count := l_count + 1;
1165: l_output := l_output ||fnd_global.local_chr(9)||l_count||')'|| l_noc;
1166: l_flag :='Y';
1167: end if;
1168:
1169: if l_flag = 'Y' then