APPS.HR_H2PI_PERSON_UPLOAD dependencies on FND_GLOBAL

Line 621: 'BEGIN '||fnd_global.local_chr(10)||

617:
618: hr_utility.set_location(l_proc, 40);
619: l_date_char := TO_CHAR(v_per_det.eff_date, 'YYYY/MM/DD');
620: l_sql_parse :=
621: 'BEGIN '||fnd_global.local_chr(10)||
622: 'hr_h2pi_person_upload.'||
623: v_per_det.fn_name||'('||l_from_client_id||','||fnd_global.local_chr(10)||
624: v_per_det.id||','||fnd_global.local_chr(10)||
625: 'TO_DATE('||''''||l_date_char||''''||

Line 623: v_per_det.fn_name||'('||l_from_client_id||','||fnd_global.local_chr(10)||

619: l_date_char := TO_CHAR(v_per_det.eff_date, 'YYYY/MM/DD');
620: l_sql_parse :=
621: 'BEGIN '||fnd_global.local_chr(10)||
622: 'hr_h2pi_person_upload.'||
623: v_per_det.fn_name||'('||l_from_client_id||','||fnd_global.local_chr(10)||
624: v_per_det.id||','||fnd_global.local_chr(10)||
625: 'TO_DATE('||''''||l_date_char||''''||
626: ','||''''||'YYYY/MM/DD'||''''||'));'||fnd_global.local_chr(10)||
627: 'END;';

Line 624: v_per_det.id||','||fnd_global.local_chr(10)||

620: l_sql_parse :=
621: 'BEGIN '||fnd_global.local_chr(10)||
622: 'hr_h2pi_person_upload.'||
623: v_per_det.fn_name||'('||l_from_client_id||','||fnd_global.local_chr(10)||
624: v_per_det.id||','||fnd_global.local_chr(10)||
625: 'TO_DATE('||''''||l_date_char||''''||
626: ','||''''||'YYYY/MM/DD'||''''||'));'||fnd_global.local_chr(10)||
627: 'END;';
628:

Line 626: ','||''''||'YYYY/MM/DD'||''''||'));'||fnd_global.local_chr(10)||

622: 'hr_h2pi_person_upload.'||
623: v_per_det.fn_name||'('||l_from_client_id||','||fnd_global.local_chr(10)||
624: v_per_det.id||','||fnd_global.local_chr(10)||
625: 'TO_DATE('||''''||l_date_char||''''||
626: ','||''''||'YYYY/MM/DD'||''''||'));'||fnd_global.local_chr(10)||
627: 'END;';
628:
629: hr_utility.trace(l_sql_parse);
630: l_csr_handle := dbms_sql.open_cursor;