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.HR_FULL_SYNC_MESSAGES dependencies on FND_GLOBAL

Line 194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_cntry_code||fnd_global.local_chr(400)||p_state_code

190: loop
191: fetch fet_state_sync into p_cntry_code,p_state_code,p_state_desc,p_enabled_flag;
192: exit when fet_state_sync%notfound;
193:
194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_cntry_code||fnd_global.local_chr(400)||p_state_code
195: ||fnd_global.local_chr(400)||p_state_desc||fnd_global.local_chr(400)||p_enabled_flag);
196: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
197: end loop;
198: close fet_state_sync;

Line 195: ||fnd_global.local_chr(400)||p_state_desc||fnd_global.local_chr(400)||p_enabled_flag);

191: fetch fet_state_sync into p_cntry_code,p_state_code,p_state_desc,p_enabled_flag;
192: exit when fet_state_sync%notfound;
193:
194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_cntry_code||fnd_global.local_chr(400)||p_state_code
195: ||fnd_global.local_chr(400)||p_state_desc||fnd_global.local_chr(400)||p_enabled_flag);
196: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
197: end loop;
198: close fet_state_sync;
199:

Line 260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_cntry_code||fnd_global.local_chr(400)||p_cntry_desc||fnd_global.local_chr(400)

256: open fet_cntry_fsync;
257: loop
258: fetch fet_cntry_fsync into p_cntry_code,p_cntry_desc,p_cntry_code,p_obsolete_flag;
259: exit when fet_cntry_fsync%notfound;
260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_cntry_code||fnd_global.local_chr(400)||p_cntry_desc||fnd_global.local_chr(400)
261: ||p_cntry_code||fnd_global.local_chr(400)||p_obsolete_flag);
262: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
263: end loop;
264: close fet_cntry_fsync;

Line 261: ||p_cntry_code||fnd_global.local_chr(400)||p_obsolete_flag);

257: loop
258: fetch fet_cntry_fsync into p_cntry_code,p_cntry_desc,p_cntry_code,p_obsolete_flag;
259: exit when fet_cntry_fsync%notfound;
260: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_cntry_code||fnd_global.local_chr(400)||p_cntry_desc||fnd_global.local_chr(400)
261: ||p_cntry_code||fnd_global.local_chr(400)||p_obsolete_flag);
262: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
263: end loop;
264: close fet_cntry_fsync;
265:

Line 386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_bg_id||fnd_global.local_chr(400)||p_loc_id||

382: p_town_or_city,p_region_1,p_region_2,p_region_3,p_postal_code,p_tel_no_1,p_tel_no_2 ,
383: p_tel_no_3,p_loc_info_13, p_loc_info_14,p_loc_info_15,p_loc_info_16,p_loc_info_17,p_loc_info_18,
384: p_loc_info_19,p_loc_info_20;
385: exit when fet_loc_sync%notfound;
386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_bg_id||fnd_global.local_chr(400)||p_loc_id||
387: fnd_global.local_chr(400)||p_active_date||
388: fnd_global.local_chr(400)||p_effecive_status||fnd_global.local_chr(400)||
389: p_loc_code||fnd_global.local_chr(400)|| p_loc_desc||fnd_global.local_chr(400)||'ADDRESS_START'||
390: fnd_global.local_chr(400)||p_loc_style ||fnd_global.local_chr(400)|| p_add_line_1||

Line 387: fnd_global.local_chr(400)||p_active_date||

383: p_tel_no_3,p_loc_info_13, p_loc_info_14,p_loc_info_15,p_loc_info_16,p_loc_info_17,p_loc_info_18,
384: p_loc_info_19,p_loc_info_20;
385: exit when fet_loc_sync%notfound;
386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_bg_id||fnd_global.local_chr(400)||p_loc_id||
387: fnd_global.local_chr(400)||p_active_date||
388: fnd_global.local_chr(400)||p_effecive_status||fnd_global.local_chr(400)||
389: p_loc_code||fnd_global.local_chr(400)|| p_loc_desc||fnd_global.local_chr(400)||'ADDRESS_START'||
390: fnd_global.local_chr(400)||p_loc_style ||fnd_global.local_chr(400)|| p_add_line_1||
391: fnd_global.local_chr(400)|| p_add_line_2||fnd_global.local_chr(400)|| p_add_line_3||

Line 388: fnd_global.local_chr(400)||p_effecive_status||fnd_global.local_chr(400)||

384: p_loc_info_19,p_loc_info_20;
385: exit when fet_loc_sync%notfound;
386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_bg_id||fnd_global.local_chr(400)||p_loc_id||
387: fnd_global.local_chr(400)||p_active_date||
388: fnd_global.local_chr(400)||p_effecive_status||fnd_global.local_chr(400)||
389: p_loc_code||fnd_global.local_chr(400)|| p_loc_desc||fnd_global.local_chr(400)||'ADDRESS_START'||
390: fnd_global.local_chr(400)||p_loc_style ||fnd_global.local_chr(400)|| p_add_line_1||
391: fnd_global.local_chr(400)|| p_add_line_2||fnd_global.local_chr(400)|| p_add_line_3||
392: fnd_global.local_chr(400)||p_town_or_city||fnd_global.local_chr(400)||p_country||

Line 389: p_loc_code||fnd_global.local_chr(400)|| p_loc_desc||fnd_global.local_chr(400)||'ADDRESS_START'||

385: exit when fet_loc_sync%notfound;
386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_bg_id||fnd_global.local_chr(400)||p_loc_id||
387: fnd_global.local_chr(400)||p_active_date||
388: fnd_global.local_chr(400)||p_effecive_status||fnd_global.local_chr(400)||
389: p_loc_code||fnd_global.local_chr(400)|| p_loc_desc||fnd_global.local_chr(400)||'ADDRESS_START'||
390: fnd_global.local_chr(400)||p_loc_style ||fnd_global.local_chr(400)|| p_add_line_1||
391: fnd_global.local_chr(400)|| p_add_line_2||fnd_global.local_chr(400)|| p_add_line_3||
392: fnd_global.local_chr(400)||p_town_or_city||fnd_global.local_chr(400)||p_country||
393: fnd_global.local_chr(400)||p_postal_code||fnd_global.local_chr(400)||p_region_1||

Line 390: fnd_global.local_chr(400)||p_loc_style ||fnd_global.local_chr(400)|| p_add_line_1||

386: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_bg_id||fnd_global.local_chr(400)||p_loc_id||
387: fnd_global.local_chr(400)||p_active_date||
388: fnd_global.local_chr(400)||p_effecive_status||fnd_global.local_chr(400)||
389: p_loc_code||fnd_global.local_chr(400)|| p_loc_desc||fnd_global.local_chr(400)||'ADDRESS_START'||
390: fnd_global.local_chr(400)||p_loc_style ||fnd_global.local_chr(400)|| p_add_line_1||
391: fnd_global.local_chr(400)|| p_add_line_2||fnd_global.local_chr(400)|| p_add_line_3||
392: fnd_global.local_chr(400)||p_town_or_city||fnd_global.local_chr(400)||p_country||
393: fnd_global.local_chr(400)||p_postal_code||fnd_global.local_chr(400)||p_region_1||
394: fnd_global.local_chr(400)||p_region_2||fnd_global.local_chr(400)||p_region_3||

Line 391: fnd_global.local_chr(400)|| p_add_line_2||fnd_global.local_chr(400)|| p_add_line_3||

387: fnd_global.local_chr(400)||p_active_date||
388: fnd_global.local_chr(400)||p_effecive_status||fnd_global.local_chr(400)||
389: p_loc_code||fnd_global.local_chr(400)|| p_loc_desc||fnd_global.local_chr(400)||'ADDRESS_START'||
390: fnd_global.local_chr(400)||p_loc_style ||fnd_global.local_chr(400)|| p_add_line_1||
391: fnd_global.local_chr(400)|| p_add_line_2||fnd_global.local_chr(400)|| p_add_line_3||
392: fnd_global.local_chr(400)||p_town_or_city||fnd_global.local_chr(400)||p_country||
393: fnd_global.local_chr(400)||p_postal_code||fnd_global.local_chr(400)||p_region_1||
394: fnd_global.local_chr(400)||p_region_2||fnd_global.local_chr(400)||p_region_3||
395: fnd_global.local_chr(400)||p_tel_no_1||fnd_global.local_chr(400)||p_tel_no_2 ||

Line 392: fnd_global.local_chr(400)||p_town_or_city||fnd_global.local_chr(400)||p_country||

388: fnd_global.local_chr(400)||p_effecive_status||fnd_global.local_chr(400)||
389: p_loc_code||fnd_global.local_chr(400)|| p_loc_desc||fnd_global.local_chr(400)||'ADDRESS_START'||
390: fnd_global.local_chr(400)||p_loc_style ||fnd_global.local_chr(400)|| p_add_line_1||
391: fnd_global.local_chr(400)|| p_add_line_2||fnd_global.local_chr(400)|| p_add_line_3||
392: fnd_global.local_chr(400)||p_town_or_city||fnd_global.local_chr(400)||p_country||
393: fnd_global.local_chr(400)||p_postal_code||fnd_global.local_chr(400)||p_region_1||
394: fnd_global.local_chr(400)||p_region_2||fnd_global.local_chr(400)||p_region_3||
395: fnd_global.local_chr(400)||p_tel_no_1||fnd_global.local_chr(400)||p_tel_no_2 ||
396: fnd_global.local_chr(400)||p_tel_no_3||fnd_global.local_chr(400)||p_loc_info_13||

Line 393: fnd_global.local_chr(400)||p_postal_code||fnd_global.local_chr(400)||p_region_1||

389: p_loc_code||fnd_global.local_chr(400)|| p_loc_desc||fnd_global.local_chr(400)||'ADDRESS_START'||
390: fnd_global.local_chr(400)||p_loc_style ||fnd_global.local_chr(400)|| p_add_line_1||
391: fnd_global.local_chr(400)|| p_add_line_2||fnd_global.local_chr(400)|| p_add_line_3||
392: fnd_global.local_chr(400)||p_town_or_city||fnd_global.local_chr(400)||p_country||
393: fnd_global.local_chr(400)||p_postal_code||fnd_global.local_chr(400)||p_region_1||
394: fnd_global.local_chr(400)||p_region_2||fnd_global.local_chr(400)||p_region_3||
395: fnd_global.local_chr(400)||p_tel_no_1||fnd_global.local_chr(400)||p_tel_no_2 ||
396: fnd_global.local_chr(400)||p_tel_no_3||fnd_global.local_chr(400)||p_loc_info_13||
397: fnd_global.local_chr(400)|| p_loc_info_14||fnd_global.local_chr(400)||p_loc_info_15||

Line 394: fnd_global.local_chr(400)||p_region_2||fnd_global.local_chr(400)||p_region_3||

390: fnd_global.local_chr(400)||p_loc_style ||fnd_global.local_chr(400)|| p_add_line_1||
391: fnd_global.local_chr(400)|| p_add_line_2||fnd_global.local_chr(400)|| p_add_line_3||
392: fnd_global.local_chr(400)||p_town_or_city||fnd_global.local_chr(400)||p_country||
393: fnd_global.local_chr(400)||p_postal_code||fnd_global.local_chr(400)||p_region_1||
394: fnd_global.local_chr(400)||p_region_2||fnd_global.local_chr(400)||p_region_3||
395: fnd_global.local_chr(400)||p_tel_no_1||fnd_global.local_chr(400)||p_tel_no_2 ||
396: fnd_global.local_chr(400)||p_tel_no_3||fnd_global.local_chr(400)||p_loc_info_13||
397: fnd_global.local_chr(400)|| p_loc_info_14||fnd_global.local_chr(400)||p_loc_info_15||
398: fnd_global.local_chr(400)||p_loc_info_16||fnd_global.local_chr(400)||p_loc_info_17||

Line 395: fnd_global.local_chr(400)||p_tel_no_1||fnd_global.local_chr(400)||p_tel_no_2 ||

391: fnd_global.local_chr(400)|| p_add_line_2||fnd_global.local_chr(400)|| p_add_line_3||
392: fnd_global.local_chr(400)||p_town_or_city||fnd_global.local_chr(400)||p_country||
393: fnd_global.local_chr(400)||p_postal_code||fnd_global.local_chr(400)||p_region_1||
394: fnd_global.local_chr(400)||p_region_2||fnd_global.local_chr(400)||p_region_3||
395: fnd_global.local_chr(400)||p_tel_no_1||fnd_global.local_chr(400)||p_tel_no_2 ||
396: fnd_global.local_chr(400)||p_tel_no_3||fnd_global.local_chr(400)||p_loc_info_13||
397: fnd_global.local_chr(400)|| p_loc_info_14||fnd_global.local_chr(400)||p_loc_info_15||
398: fnd_global.local_chr(400)||p_loc_info_16||fnd_global.local_chr(400)||p_loc_info_17||
399: fnd_global.local_chr(400)||p_loc_info_18||fnd_global.local_chr(400)||

Line 396: fnd_global.local_chr(400)||p_tel_no_3||fnd_global.local_chr(400)||p_loc_info_13||

392: fnd_global.local_chr(400)||p_town_or_city||fnd_global.local_chr(400)||p_country||
393: fnd_global.local_chr(400)||p_postal_code||fnd_global.local_chr(400)||p_region_1||
394: fnd_global.local_chr(400)||p_region_2||fnd_global.local_chr(400)||p_region_3||
395: fnd_global.local_chr(400)||p_tel_no_1||fnd_global.local_chr(400)||p_tel_no_2 ||
396: fnd_global.local_chr(400)||p_tel_no_3||fnd_global.local_chr(400)||p_loc_info_13||
397: fnd_global.local_chr(400)|| p_loc_info_14||fnd_global.local_chr(400)||p_loc_info_15||
398: fnd_global.local_chr(400)||p_loc_info_16||fnd_global.local_chr(400)||p_loc_info_17||
399: fnd_global.local_chr(400)||p_loc_info_18||fnd_global.local_chr(400)||
400: p_loc_info_19||fnd_global.local_chr(400)||p_loc_info_20||fnd_global.local_chr(400)||'ADDRESS_END'||

Line 397: fnd_global.local_chr(400)|| p_loc_info_14||fnd_global.local_chr(400)||p_loc_info_15||

393: fnd_global.local_chr(400)||p_postal_code||fnd_global.local_chr(400)||p_region_1||
394: fnd_global.local_chr(400)||p_region_2||fnd_global.local_chr(400)||p_region_3||
395: fnd_global.local_chr(400)||p_tel_no_1||fnd_global.local_chr(400)||p_tel_no_2 ||
396: fnd_global.local_chr(400)||p_tel_no_3||fnd_global.local_chr(400)||p_loc_info_13||
397: fnd_global.local_chr(400)|| p_loc_info_14||fnd_global.local_chr(400)||p_loc_info_15||
398: fnd_global.local_chr(400)||p_loc_info_16||fnd_global.local_chr(400)||p_loc_info_17||
399: fnd_global.local_chr(400)||p_loc_info_18||fnd_global.local_chr(400)||
400: p_loc_info_19||fnd_global.local_chr(400)||p_loc_info_20||fnd_global.local_chr(400)||'ADDRESS_END'||
401: fnd_global.local_chr(400));

Line 398: fnd_global.local_chr(400)||p_loc_info_16||fnd_global.local_chr(400)||p_loc_info_17||

394: fnd_global.local_chr(400)||p_region_2||fnd_global.local_chr(400)||p_region_3||
395: fnd_global.local_chr(400)||p_tel_no_1||fnd_global.local_chr(400)||p_tel_no_2 ||
396: fnd_global.local_chr(400)||p_tel_no_3||fnd_global.local_chr(400)||p_loc_info_13||
397: fnd_global.local_chr(400)|| p_loc_info_14||fnd_global.local_chr(400)||p_loc_info_15||
398: fnd_global.local_chr(400)||p_loc_info_16||fnd_global.local_chr(400)||p_loc_info_17||
399: fnd_global.local_chr(400)||p_loc_info_18||fnd_global.local_chr(400)||
400: p_loc_info_19||fnd_global.local_chr(400)||p_loc_info_20||fnd_global.local_chr(400)||'ADDRESS_END'||
401: fnd_global.local_chr(400));
402: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

Line 399: fnd_global.local_chr(400)||p_loc_info_18||fnd_global.local_chr(400)||

395: fnd_global.local_chr(400)||p_tel_no_1||fnd_global.local_chr(400)||p_tel_no_2 ||
396: fnd_global.local_chr(400)||p_tel_no_3||fnd_global.local_chr(400)||p_loc_info_13||
397: fnd_global.local_chr(400)|| p_loc_info_14||fnd_global.local_chr(400)||p_loc_info_15||
398: fnd_global.local_chr(400)||p_loc_info_16||fnd_global.local_chr(400)||p_loc_info_17||
399: fnd_global.local_chr(400)||p_loc_info_18||fnd_global.local_chr(400)||
400: p_loc_info_19||fnd_global.local_chr(400)||p_loc_info_20||fnd_global.local_chr(400)||'ADDRESS_END'||
401: fnd_global.local_chr(400));
402: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
403: end loop;

Line 400: p_loc_info_19||fnd_global.local_chr(400)||p_loc_info_20||fnd_global.local_chr(400)||'ADDRESS_END'||

396: fnd_global.local_chr(400)||p_tel_no_3||fnd_global.local_chr(400)||p_loc_info_13||
397: fnd_global.local_chr(400)|| p_loc_info_14||fnd_global.local_chr(400)||p_loc_info_15||
398: fnd_global.local_chr(400)||p_loc_info_16||fnd_global.local_chr(400)||p_loc_info_17||
399: fnd_global.local_chr(400)||p_loc_info_18||fnd_global.local_chr(400)||
400: p_loc_info_19||fnd_global.local_chr(400)||p_loc_info_20||fnd_global.local_chr(400)||'ADDRESS_END'||
401: fnd_global.local_chr(400));
402: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
403: end loop;
404: close fet_loc_sync;

Line 401: fnd_global.local_chr(400));

397: fnd_global.local_chr(400)|| p_loc_info_14||fnd_global.local_chr(400)||p_loc_info_15||
398: fnd_global.local_chr(400)||p_loc_info_16||fnd_global.local_chr(400)||p_loc_info_17||
399: fnd_global.local_chr(400)||p_loc_info_18||fnd_global.local_chr(400)||
400: p_loc_info_19||fnd_global.local_chr(400)||p_loc_info_20||fnd_global.local_chr(400)||'ADDRESS_END'||
401: fnd_global.local_chr(400));
402: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
403: end loop;
404: close fet_loc_sync;
405:

Line 598: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,L_EMPLOYEE_NUMBER||fnd_global.local_chr(400)||L_USER_PERSON_TYPE||fnd_global.local_chr(400)||L_DATE_OF_BIRTH

594: L_POSTAL_CODE, L_EMAIL_ADDRESS, L_PHONE_TYPE
595: ,L_PHONE_NUMBER,L_NATIONALITY ,L_NATIONAL_IDENTIFIER ;
596:
597: exit when csr_person_data%notfound;
598: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,L_EMPLOYEE_NUMBER||fnd_global.local_chr(400)||L_USER_PERSON_TYPE||fnd_global.local_chr(400)||L_DATE_OF_BIRTH
599: ||fnd_global.local_chr(400)||L_TOWN_OF_BIRTH||fnd_global.local_chr(400)||L_COUNTRY_OF_BIRTH||fnd_global.local_chr(400)||L_DATE_OF_DEATH
600: ||fnd_global.local_chr(400)||L_ORIGINAL_DATE_OF_HIRE||fnd_global.local_chr(400)||L_EFFECTIVE_START_DATE||fnd_global.local_chr(400)||L_SEX
601: ||fnd_global.local_chr(400)||L_MARITAL_STATUS||fnd_global.local_chr(400)||L_FULL_NAME||fnd_global.local_chr(400)||L_PRE_NAME_ADJUNCT
602: ||fnd_global.local_chr(400)||L_SUFFIX||fnd_global.local_chr(400)||L_TITLE||fnd_global.local_chr(400)||L_LAST_NAME

Line 599: ||fnd_global.local_chr(400)||L_TOWN_OF_BIRTH||fnd_global.local_chr(400)||L_COUNTRY_OF_BIRTH||fnd_global.local_chr(400)||L_DATE_OF_DEATH

595: ,L_PHONE_NUMBER,L_NATIONALITY ,L_NATIONAL_IDENTIFIER ;
596:
597: exit when csr_person_data%notfound;
598: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,L_EMPLOYEE_NUMBER||fnd_global.local_chr(400)||L_USER_PERSON_TYPE||fnd_global.local_chr(400)||L_DATE_OF_BIRTH
599: ||fnd_global.local_chr(400)||L_TOWN_OF_BIRTH||fnd_global.local_chr(400)||L_COUNTRY_OF_BIRTH||fnd_global.local_chr(400)||L_DATE_OF_DEATH
600: ||fnd_global.local_chr(400)||L_ORIGINAL_DATE_OF_HIRE||fnd_global.local_chr(400)||L_EFFECTIVE_START_DATE||fnd_global.local_chr(400)||L_SEX
601: ||fnd_global.local_chr(400)||L_MARITAL_STATUS||fnd_global.local_chr(400)||L_FULL_NAME||fnd_global.local_chr(400)||L_PRE_NAME_ADJUNCT
602: ||fnd_global.local_chr(400)||L_SUFFIX||fnd_global.local_chr(400)||L_TITLE||fnd_global.local_chr(400)||L_LAST_NAME
603: ||fnd_global.local_chr(400)||L_FIRST_NAME||fnd_global.local_chr(400)||L_MIDDLE_NAMES||fnd_global.local_chr(400)||L_ADDRESS_TYPE

Line 600: ||fnd_global.local_chr(400)||L_ORIGINAL_DATE_OF_HIRE||fnd_global.local_chr(400)||L_EFFECTIVE_START_DATE||fnd_global.local_chr(400)||L_SEX

596:
597: exit when csr_person_data%notfound;
598: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,L_EMPLOYEE_NUMBER||fnd_global.local_chr(400)||L_USER_PERSON_TYPE||fnd_global.local_chr(400)||L_DATE_OF_BIRTH
599: ||fnd_global.local_chr(400)||L_TOWN_OF_BIRTH||fnd_global.local_chr(400)||L_COUNTRY_OF_BIRTH||fnd_global.local_chr(400)||L_DATE_OF_DEATH
600: ||fnd_global.local_chr(400)||L_ORIGINAL_DATE_OF_HIRE||fnd_global.local_chr(400)||L_EFFECTIVE_START_DATE||fnd_global.local_chr(400)||L_SEX
601: ||fnd_global.local_chr(400)||L_MARITAL_STATUS||fnd_global.local_chr(400)||L_FULL_NAME||fnd_global.local_chr(400)||L_PRE_NAME_ADJUNCT
602: ||fnd_global.local_chr(400)||L_SUFFIX||fnd_global.local_chr(400)||L_TITLE||fnd_global.local_chr(400)||L_LAST_NAME
603: ||fnd_global.local_chr(400)||L_FIRST_NAME||fnd_global.local_chr(400)||L_MIDDLE_NAMES||fnd_global.local_chr(400)||L_ADDRESS_TYPE
604: ||fnd_global.local_chr(400)||L_DATE_FROM||fnd_global.local_chr(400)||L_COUNTRY||fnd_global.local_chr(400)||L_ADDRESS_LINE1

Line 601: ||fnd_global.local_chr(400)||L_MARITAL_STATUS||fnd_global.local_chr(400)||L_FULL_NAME||fnd_global.local_chr(400)||L_PRE_NAME_ADJUNCT

597: exit when csr_person_data%notfound;
598: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,L_EMPLOYEE_NUMBER||fnd_global.local_chr(400)||L_USER_PERSON_TYPE||fnd_global.local_chr(400)||L_DATE_OF_BIRTH
599: ||fnd_global.local_chr(400)||L_TOWN_OF_BIRTH||fnd_global.local_chr(400)||L_COUNTRY_OF_BIRTH||fnd_global.local_chr(400)||L_DATE_OF_DEATH
600: ||fnd_global.local_chr(400)||L_ORIGINAL_DATE_OF_HIRE||fnd_global.local_chr(400)||L_EFFECTIVE_START_DATE||fnd_global.local_chr(400)||L_SEX
601: ||fnd_global.local_chr(400)||L_MARITAL_STATUS||fnd_global.local_chr(400)||L_FULL_NAME||fnd_global.local_chr(400)||L_PRE_NAME_ADJUNCT
602: ||fnd_global.local_chr(400)||L_SUFFIX||fnd_global.local_chr(400)||L_TITLE||fnd_global.local_chr(400)||L_LAST_NAME
603: ||fnd_global.local_chr(400)||L_FIRST_NAME||fnd_global.local_chr(400)||L_MIDDLE_NAMES||fnd_global.local_chr(400)||L_ADDRESS_TYPE
604: ||fnd_global.local_chr(400)||L_DATE_FROM||fnd_global.local_chr(400)||L_COUNTRY||fnd_global.local_chr(400)||L_ADDRESS_LINE1
605: ||fnd_global.local_chr(400)||L_ADDRESS_LINE2||fnd_global.local_chr(400)||L_ADDRESS_LINE3||fnd_global.local_chr(400)||L_TOWN_OR_CITY

Line 602: ||fnd_global.local_chr(400)||L_SUFFIX||fnd_global.local_chr(400)||L_TITLE||fnd_global.local_chr(400)||L_LAST_NAME

598: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,L_EMPLOYEE_NUMBER||fnd_global.local_chr(400)||L_USER_PERSON_TYPE||fnd_global.local_chr(400)||L_DATE_OF_BIRTH
599: ||fnd_global.local_chr(400)||L_TOWN_OF_BIRTH||fnd_global.local_chr(400)||L_COUNTRY_OF_BIRTH||fnd_global.local_chr(400)||L_DATE_OF_DEATH
600: ||fnd_global.local_chr(400)||L_ORIGINAL_DATE_OF_HIRE||fnd_global.local_chr(400)||L_EFFECTIVE_START_DATE||fnd_global.local_chr(400)||L_SEX
601: ||fnd_global.local_chr(400)||L_MARITAL_STATUS||fnd_global.local_chr(400)||L_FULL_NAME||fnd_global.local_chr(400)||L_PRE_NAME_ADJUNCT
602: ||fnd_global.local_chr(400)||L_SUFFIX||fnd_global.local_chr(400)||L_TITLE||fnd_global.local_chr(400)||L_LAST_NAME
603: ||fnd_global.local_chr(400)||L_FIRST_NAME||fnd_global.local_chr(400)||L_MIDDLE_NAMES||fnd_global.local_chr(400)||L_ADDRESS_TYPE
604: ||fnd_global.local_chr(400)||L_DATE_FROM||fnd_global.local_chr(400)||L_COUNTRY||fnd_global.local_chr(400)||L_ADDRESS_LINE1
605: ||fnd_global.local_chr(400)||L_ADDRESS_LINE2||fnd_global.local_chr(400)||L_ADDRESS_LINE3||fnd_global.local_chr(400)||L_TOWN_OR_CITY
606: ||fnd_global.local_chr(400)||L_TELEPHONE_NUMBER_1||fnd_global.local_chr(400)||L_REGION_1||fnd_global.local_chr(400)||L_REGION_2

Line 603: ||fnd_global.local_chr(400)||L_FIRST_NAME||fnd_global.local_chr(400)||L_MIDDLE_NAMES||fnd_global.local_chr(400)||L_ADDRESS_TYPE

599: ||fnd_global.local_chr(400)||L_TOWN_OF_BIRTH||fnd_global.local_chr(400)||L_COUNTRY_OF_BIRTH||fnd_global.local_chr(400)||L_DATE_OF_DEATH
600: ||fnd_global.local_chr(400)||L_ORIGINAL_DATE_OF_HIRE||fnd_global.local_chr(400)||L_EFFECTIVE_START_DATE||fnd_global.local_chr(400)||L_SEX
601: ||fnd_global.local_chr(400)||L_MARITAL_STATUS||fnd_global.local_chr(400)||L_FULL_NAME||fnd_global.local_chr(400)||L_PRE_NAME_ADJUNCT
602: ||fnd_global.local_chr(400)||L_SUFFIX||fnd_global.local_chr(400)||L_TITLE||fnd_global.local_chr(400)||L_LAST_NAME
603: ||fnd_global.local_chr(400)||L_FIRST_NAME||fnd_global.local_chr(400)||L_MIDDLE_NAMES||fnd_global.local_chr(400)||L_ADDRESS_TYPE
604: ||fnd_global.local_chr(400)||L_DATE_FROM||fnd_global.local_chr(400)||L_COUNTRY||fnd_global.local_chr(400)||L_ADDRESS_LINE1
605: ||fnd_global.local_chr(400)||L_ADDRESS_LINE2||fnd_global.local_chr(400)||L_ADDRESS_LINE3||fnd_global.local_chr(400)||L_TOWN_OR_CITY
606: ||fnd_global.local_chr(400)||L_TELEPHONE_NUMBER_1||fnd_global.local_chr(400)||L_REGION_1||fnd_global.local_chr(400)||L_REGION_2
607: ||fnd_global.local_chr(400)||L_PHONE_NUMBER||fnd_global.local_chr(400)||L_NATIONALITY||fnd_global.local_chr(400)||L_NATIONAL_IDENTIFIER

Line 604: ||fnd_global.local_chr(400)||L_DATE_FROM||fnd_global.local_chr(400)||L_COUNTRY||fnd_global.local_chr(400)||L_ADDRESS_LINE1

600: ||fnd_global.local_chr(400)||L_ORIGINAL_DATE_OF_HIRE||fnd_global.local_chr(400)||L_EFFECTIVE_START_DATE||fnd_global.local_chr(400)||L_SEX
601: ||fnd_global.local_chr(400)||L_MARITAL_STATUS||fnd_global.local_chr(400)||L_FULL_NAME||fnd_global.local_chr(400)||L_PRE_NAME_ADJUNCT
602: ||fnd_global.local_chr(400)||L_SUFFIX||fnd_global.local_chr(400)||L_TITLE||fnd_global.local_chr(400)||L_LAST_NAME
603: ||fnd_global.local_chr(400)||L_FIRST_NAME||fnd_global.local_chr(400)||L_MIDDLE_NAMES||fnd_global.local_chr(400)||L_ADDRESS_TYPE
604: ||fnd_global.local_chr(400)||L_DATE_FROM||fnd_global.local_chr(400)||L_COUNTRY||fnd_global.local_chr(400)||L_ADDRESS_LINE1
605: ||fnd_global.local_chr(400)||L_ADDRESS_LINE2||fnd_global.local_chr(400)||L_ADDRESS_LINE3||fnd_global.local_chr(400)||L_TOWN_OR_CITY
606: ||fnd_global.local_chr(400)||L_TELEPHONE_NUMBER_1||fnd_global.local_chr(400)||L_REGION_1||fnd_global.local_chr(400)||L_REGION_2
607: ||fnd_global.local_chr(400)||L_PHONE_NUMBER||fnd_global.local_chr(400)||L_NATIONALITY||fnd_global.local_chr(400)||L_NATIONAL_IDENTIFIER
608: );

Line 605: ||fnd_global.local_chr(400)||L_ADDRESS_LINE2||fnd_global.local_chr(400)||L_ADDRESS_LINE3||fnd_global.local_chr(400)||L_TOWN_OR_CITY

601: ||fnd_global.local_chr(400)||L_MARITAL_STATUS||fnd_global.local_chr(400)||L_FULL_NAME||fnd_global.local_chr(400)||L_PRE_NAME_ADJUNCT
602: ||fnd_global.local_chr(400)||L_SUFFIX||fnd_global.local_chr(400)||L_TITLE||fnd_global.local_chr(400)||L_LAST_NAME
603: ||fnd_global.local_chr(400)||L_FIRST_NAME||fnd_global.local_chr(400)||L_MIDDLE_NAMES||fnd_global.local_chr(400)||L_ADDRESS_TYPE
604: ||fnd_global.local_chr(400)||L_DATE_FROM||fnd_global.local_chr(400)||L_COUNTRY||fnd_global.local_chr(400)||L_ADDRESS_LINE1
605: ||fnd_global.local_chr(400)||L_ADDRESS_LINE2||fnd_global.local_chr(400)||L_ADDRESS_LINE3||fnd_global.local_chr(400)||L_TOWN_OR_CITY
606: ||fnd_global.local_chr(400)||L_TELEPHONE_NUMBER_1||fnd_global.local_chr(400)||L_REGION_1||fnd_global.local_chr(400)||L_REGION_2
607: ||fnd_global.local_chr(400)||L_PHONE_NUMBER||fnd_global.local_chr(400)||L_NATIONALITY||fnd_global.local_chr(400)||L_NATIONAL_IDENTIFIER
608: );
609: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

Line 606: ||fnd_global.local_chr(400)||L_TELEPHONE_NUMBER_1||fnd_global.local_chr(400)||L_REGION_1||fnd_global.local_chr(400)||L_REGION_2

602: ||fnd_global.local_chr(400)||L_SUFFIX||fnd_global.local_chr(400)||L_TITLE||fnd_global.local_chr(400)||L_LAST_NAME
603: ||fnd_global.local_chr(400)||L_FIRST_NAME||fnd_global.local_chr(400)||L_MIDDLE_NAMES||fnd_global.local_chr(400)||L_ADDRESS_TYPE
604: ||fnd_global.local_chr(400)||L_DATE_FROM||fnd_global.local_chr(400)||L_COUNTRY||fnd_global.local_chr(400)||L_ADDRESS_LINE1
605: ||fnd_global.local_chr(400)||L_ADDRESS_LINE2||fnd_global.local_chr(400)||L_ADDRESS_LINE3||fnd_global.local_chr(400)||L_TOWN_OR_CITY
606: ||fnd_global.local_chr(400)||L_TELEPHONE_NUMBER_1||fnd_global.local_chr(400)||L_REGION_1||fnd_global.local_chr(400)||L_REGION_2
607: ||fnd_global.local_chr(400)||L_PHONE_NUMBER||fnd_global.local_chr(400)||L_NATIONALITY||fnd_global.local_chr(400)||L_NATIONAL_IDENTIFIER
608: );
609: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
610: end loop;

Line 607: ||fnd_global.local_chr(400)||L_PHONE_NUMBER||fnd_global.local_chr(400)||L_NATIONALITY||fnd_global.local_chr(400)||L_NATIONAL_IDENTIFIER

603: ||fnd_global.local_chr(400)||L_FIRST_NAME||fnd_global.local_chr(400)||L_MIDDLE_NAMES||fnd_global.local_chr(400)||L_ADDRESS_TYPE
604: ||fnd_global.local_chr(400)||L_DATE_FROM||fnd_global.local_chr(400)||L_COUNTRY||fnd_global.local_chr(400)||L_ADDRESS_LINE1
605: ||fnd_global.local_chr(400)||L_ADDRESS_LINE2||fnd_global.local_chr(400)||L_ADDRESS_LINE3||fnd_global.local_chr(400)||L_TOWN_OR_CITY
606: ||fnd_global.local_chr(400)||L_TELEPHONE_NUMBER_1||fnd_global.local_chr(400)||L_REGION_1||fnd_global.local_chr(400)||L_REGION_2
607: ||fnd_global.local_chr(400)||L_PHONE_NUMBER||fnd_global.local_chr(400)||L_NATIONALITY||fnd_global.local_chr(400)||L_NATIONAL_IDENTIFIER
608: );
609: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
610: end loop;
611: close csr_person_data;

Line 703: Jobcodefulltype.SETID(I)||fnd_global.local_chr(400)||

699:
700: FOR I IN 1 .. p_cnt Loop
701:
702: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
703: Jobcodefulltype.SETID(I)||fnd_global.local_chr(400)||
704: Jobcodefulltype.JOBCODE(I)||fnd_global.local_chr(400)||
705: Jobcodefulltype.EFFDT(I)||fnd_global.local_chr(400)||
706: Jobcodefulltype.EFF_STATUS(I)||fnd_global.local_chr(400)||
707: Jobcodefulltype.DESCR(I)

Line 704: Jobcodefulltype.JOBCODE(I)||fnd_global.local_chr(400)||

700: FOR I IN 1 .. p_cnt Loop
701:
702: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
703: Jobcodefulltype.SETID(I)||fnd_global.local_chr(400)||
704: Jobcodefulltype.JOBCODE(I)||fnd_global.local_chr(400)||
705: Jobcodefulltype.EFFDT(I)||fnd_global.local_chr(400)||
706: Jobcodefulltype.EFF_STATUS(I)||fnd_global.local_chr(400)||
707: Jobcodefulltype.DESCR(I)
708: );

Line 705: Jobcodefulltype.EFFDT(I)||fnd_global.local_chr(400)||

701:
702: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
703: Jobcodefulltype.SETID(I)||fnd_global.local_chr(400)||
704: Jobcodefulltype.JOBCODE(I)||fnd_global.local_chr(400)||
705: Jobcodefulltype.EFFDT(I)||fnd_global.local_chr(400)||
706: Jobcodefulltype.EFF_STATUS(I)||fnd_global.local_chr(400)||
707: Jobcodefulltype.DESCR(I)
708: );
709: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

Line 706: Jobcodefulltype.EFF_STATUS(I)||fnd_global.local_chr(400)||

702: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
703: Jobcodefulltype.SETID(I)||fnd_global.local_chr(400)||
704: Jobcodefulltype.JOBCODE(I)||fnd_global.local_chr(400)||
705: Jobcodefulltype.EFFDT(I)||fnd_global.local_chr(400)||
706: Jobcodefulltype.EFF_STATUS(I)||fnd_global.local_chr(400)||
707: Jobcodefulltype.DESCR(I)
708: );
709: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
710: END Loop;

Line 828: WorkForceFullType.EMPLID(I)||fnd_global.local_chr(400)||

824:
825: FOR I IN 1 .. p_cnt Loop
826:
827: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
828: WorkForceFullType.EMPLID(I)||fnd_global.local_chr(400)||
829: WorkForceFullType.EMPL_RCD(I)||fnd_global.local_chr(400)||
830: WorkForceFullType.ORIG_HIRE_DT(I)||fnd_global.local_chr(400)||
831: WorkForceFullType.PROBATION_DT(I)||fnd_global.local_chr(400)||
832: WorkForceFullType.EFFDT(I)||fnd_global.local_chr(400)||

Line 829: WorkForceFullType.EMPL_RCD(I)||fnd_global.local_chr(400)||

825: FOR I IN 1 .. p_cnt Loop
826:
827: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
828: WorkForceFullType.EMPLID(I)||fnd_global.local_chr(400)||
829: WorkForceFullType.EMPL_RCD(I)||fnd_global.local_chr(400)||
830: WorkForceFullType.ORIG_HIRE_DT(I)||fnd_global.local_chr(400)||
831: WorkForceFullType.PROBATION_DT(I)||fnd_global.local_chr(400)||
832: WorkForceFullType.EFFDT(I)||fnd_global.local_chr(400)||
833: WorkForceFullType.BUSINESS_UNIT(I)||fnd_global.local_chr(400)||

Line 830: WorkForceFullType.ORIG_HIRE_DT(I)||fnd_global.local_chr(400)||

826:
827: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
828: WorkForceFullType.EMPLID(I)||fnd_global.local_chr(400)||
829: WorkForceFullType.EMPL_RCD(I)||fnd_global.local_chr(400)||
830: WorkForceFullType.ORIG_HIRE_DT(I)||fnd_global.local_chr(400)||
831: WorkForceFullType.PROBATION_DT(I)||fnd_global.local_chr(400)||
832: WorkForceFullType.EFFDT(I)||fnd_global.local_chr(400)||
833: WorkForceFullType.BUSINESS_UNIT(I)||fnd_global.local_chr(400)||
834: WorkForceFullType.JOBCODE(I)||fnd_global.local_chr(400)||

Line 831: WorkForceFullType.PROBATION_DT(I)||fnd_global.local_chr(400)||

827: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
828: WorkForceFullType.EMPLID(I)||fnd_global.local_chr(400)||
829: WorkForceFullType.EMPL_RCD(I)||fnd_global.local_chr(400)||
830: WorkForceFullType.ORIG_HIRE_DT(I)||fnd_global.local_chr(400)||
831: WorkForceFullType.PROBATION_DT(I)||fnd_global.local_chr(400)||
832: WorkForceFullType.EFFDT(I)||fnd_global.local_chr(400)||
833: WorkForceFullType.BUSINESS_UNIT(I)||fnd_global.local_chr(400)||
834: WorkForceFullType.JOBCODE(I)||fnd_global.local_chr(400)||
835: WorkForceFullType.EMPL_STATUS(I)||fnd_global.local_chr(400)||

Line 832: WorkForceFullType.EFFDT(I)||fnd_global.local_chr(400)||

828: WorkForceFullType.EMPLID(I)||fnd_global.local_chr(400)||
829: WorkForceFullType.EMPL_RCD(I)||fnd_global.local_chr(400)||
830: WorkForceFullType.ORIG_HIRE_DT(I)||fnd_global.local_chr(400)||
831: WorkForceFullType.PROBATION_DT(I)||fnd_global.local_chr(400)||
832: WorkForceFullType.EFFDT(I)||fnd_global.local_chr(400)||
833: WorkForceFullType.BUSINESS_UNIT(I)||fnd_global.local_chr(400)||
834: WorkForceFullType.JOBCODE(I)||fnd_global.local_chr(400)||
835: WorkForceFullType.EMPL_STATUS(I)||fnd_global.local_chr(400)||
836: WorkForceFullType.LOCATION(I)||fnd_global.local_chr(400)||

Line 833: WorkForceFullType.BUSINESS_UNIT(I)||fnd_global.local_chr(400)||

829: WorkForceFullType.EMPL_RCD(I)||fnd_global.local_chr(400)||
830: WorkForceFullType.ORIG_HIRE_DT(I)||fnd_global.local_chr(400)||
831: WorkForceFullType.PROBATION_DT(I)||fnd_global.local_chr(400)||
832: WorkForceFullType.EFFDT(I)||fnd_global.local_chr(400)||
833: WorkForceFullType.BUSINESS_UNIT(I)||fnd_global.local_chr(400)||
834: WorkForceFullType.JOBCODE(I)||fnd_global.local_chr(400)||
835: WorkForceFullType.EMPL_STATUS(I)||fnd_global.local_chr(400)||
836: WorkForceFullType.LOCATION(I)||fnd_global.local_chr(400)||
837: WorkForceFullType.FULL_PART_TIME(I)||fnd_global.local_chr(400)||

Line 834: WorkForceFullType.JOBCODE(I)||fnd_global.local_chr(400)||

830: WorkForceFullType.ORIG_HIRE_DT(I)||fnd_global.local_chr(400)||
831: WorkForceFullType.PROBATION_DT(I)||fnd_global.local_chr(400)||
832: WorkForceFullType.EFFDT(I)||fnd_global.local_chr(400)||
833: WorkForceFullType.BUSINESS_UNIT(I)||fnd_global.local_chr(400)||
834: WorkForceFullType.JOBCODE(I)||fnd_global.local_chr(400)||
835: WorkForceFullType.EMPL_STATUS(I)||fnd_global.local_chr(400)||
836: WorkForceFullType.LOCATION(I)||fnd_global.local_chr(400)||
837: WorkForceFullType.FULL_PART_TIME(I)||fnd_global.local_chr(400)||
838: WorkForceFullType.COMPANY(I)||fnd_global.local_chr(400)||

Line 835: WorkForceFullType.EMPL_STATUS(I)||fnd_global.local_chr(400)||

831: WorkForceFullType.PROBATION_DT(I)||fnd_global.local_chr(400)||
832: WorkForceFullType.EFFDT(I)||fnd_global.local_chr(400)||
833: WorkForceFullType.BUSINESS_UNIT(I)||fnd_global.local_chr(400)||
834: WorkForceFullType.JOBCODE(I)||fnd_global.local_chr(400)||
835: WorkForceFullType.EMPL_STATUS(I)||fnd_global.local_chr(400)||
836: WorkForceFullType.LOCATION(I)||fnd_global.local_chr(400)||
837: WorkForceFullType.FULL_PART_TIME(I)||fnd_global.local_chr(400)||
838: WorkForceFullType.COMPANY(I)||fnd_global.local_chr(400)||
839: WorkForceFullType.STD_HOURS(I)||fnd_global.local_chr(400)||

Line 836: WorkForceFullType.LOCATION(I)||fnd_global.local_chr(400)||

832: WorkForceFullType.EFFDT(I)||fnd_global.local_chr(400)||
833: WorkForceFullType.BUSINESS_UNIT(I)||fnd_global.local_chr(400)||
834: WorkForceFullType.JOBCODE(I)||fnd_global.local_chr(400)||
835: WorkForceFullType.EMPL_STATUS(I)||fnd_global.local_chr(400)||
836: WorkForceFullType.LOCATION(I)||fnd_global.local_chr(400)||
837: WorkForceFullType.FULL_PART_TIME(I)||fnd_global.local_chr(400)||
838: WorkForceFullType.COMPANY(I)||fnd_global.local_chr(400)||
839: WorkForceFullType.STD_HOURS(I)||fnd_global.local_chr(400)||
840: WorkForceFullType.STD_HRS_FREQUENCY(I)||fnd_global.local_chr(400)||

Line 837: WorkForceFullType.FULL_PART_TIME(I)||fnd_global.local_chr(400)||

833: WorkForceFullType.BUSINESS_UNIT(I)||fnd_global.local_chr(400)||
834: WorkForceFullType.JOBCODE(I)||fnd_global.local_chr(400)||
835: WorkForceFullType.EMPL_STATUS(I)||fnd_global.local_chr(400)||
836: WorkForceFullType.LOCATION(I)||fnd_global.local_chr(400)||
837: WorkForceFullType.FULL_PART_TIME(I)||fnd_global.local_chr(400)||
838: WorkForceFullType.COMPANY(I)||fnd_global.local_chr(400)||
839: WorkForceFullType.STD_HOURS(I)||fnd_global.local_chr(400)||
840: WorkForceFullType.STD_HRS_FREQUENCY(I)||fnd_global.local_chr(400)||
841: WorkForceFullType.GRADE(I)||fnd_global.local_chr(400)||

Line 838: WorkForceFullType.COMPANY(I)||fnd_global.local_chr(400)||

834: WorkForceFullType.JOBCODE(I)||fnd_global.local_chr(400)||
835: WorkForceFullType.EMPL_STATUS(I)||fnd_global.local_chr(400)||
836: WorkForceFullType.LOCATION(I)||fnd_global.local_chr(400)||
837: WorkForceFullType.FULL_PART_TIME(I)||fnd_global.local_chr(400)||
838: WorkForceFullType.COMPANY(I)||fnd_global.local_chr(400)||
839: WorkForceFullType.STD_HOURS(I)||fnd_global.local_chr(400)||
840: WorkForceFullType.STD_HRS_FREQUENCY(I)||fnd_global.local_chr(400)||
841: WorkForceFullType.GRADE(I)||fnd_global.local_chr(400)||
842: WorkForceFullType.SUPERVISOR_ID(I)||fnd_global.local_chr(400)||

Line 839: WorkForceFullType.STD_HOURS(I)||fnd_global.local_chr(400)||

835: WorkForceFullType.EMPL_STATUS(I)||fnd_global.local_chr(400)||
836: WorkForceFullType.LOCATION(I)||fnd_global.local_chr(400)||
837: WorkForceFullType.FULL_PART_TIME(I)||fnd_global.local_chr(400)||
838: WorkForceFullType.COMPANY(I)||fnd_global.local_chr(400)||
839: WorkForceFullType.STD_HOURS(I)||fnd_global.local_chr(400)||
840: WorkForceFullType.STD_HRS_FREQUENCY(I)||fnd_global.local_chr(400)||
841: WorkForceFullType.GRADE(I)||fnd_global.local_chr(400)||
842: WorkForceFullType.SUPERVISOR_ID(I)||fnd_global.local_chr(400)||
843: WorkForceFullType.ASGN_START_DT(I)||fnd_global.local_chr(400)||

Line 840: WorkForceFullType.STD_HRS_FREQUENCY(I)||fnd_global.local_chr(400)||

836: WorkForceFullType.LOCATION(I)||fnd_global.local_chr(400)||
837: WorkForceFullType.FULL_PART_TIME(I)||fnd_global.local_chr(400)||
838: WorkForceFullType.COMPANY(I)||fnd_global.local_chr(400)||
839: WorkForceFullType.STD_HOURS(I)||fnd_global.local_chr(400)||
840: WorkForceFullType.STD_HRS_FREQUENCY(I)||fnd_global.local_chr(400)||
841: WorkForceFullType.GRADE(I)||fnd_global.local_chr(400)||
842: WorkForceFullType.SUPERVISOR_ID(I)||fnd_global.local_chr(400)||
843: WorkForceFullType.ASGN_START_DT(I)||fnd_global.local_chr(400)||
844: WorkForceFullType.ASGN_END_DT(I)||fnd_global.local_chr(400)||

Line 841: WorkForceFullType.GRADE(I)||fnd_global.local_chr(400)||

837: WorkForceFullType.FULL_PART_TIME(I)||fnd_global.local_chr(400)||
838: WorkForceFullType.COMPANY(I)||fnd_global.local_chr(400)||
839: WorkForceFullType.STD_HOURS(I)||fnd_global.local_chr(400)||
840: WorkForceFullType.STD_HRS_FREQUENCY(I)||fnd_global.local_chr(400)||
841: WorkForceFullType.GRADE(I)||fnd_global.local_chr(400)||
842: WorkForceFullType.SUPERVISOR_ID(I)||fnd_global.local_chr(400)||
843: WorkForceFullType.ASGN_START_DT(I)||fnd_global.local_chr(400)||
844: WorkForceFullType.ASGN_END_DT(I)||fnd_global.local_chr(400)||
845: WorkForceFullType.STEP(I)||fnd_global.local_chr(400)||

Line 842: WorkForceFullType.SUPERVISOR_ID(I)||fnd_global.local_chr(400)||

838: WorkForceFullType.COMPANY(I)||fnd_global.local_chr(400)||
839: WorkForceFullType.STD_HOURS(I)||fnd_global.local_chr(400)||
840: WorkForceFullType.STD_HRS_FREQUENCY(I)||fnd_global.local_chr(400)||
841: WorkForceFullType.GRADE(I)||fnd_global.local_chr(400)||
842: WorkForceFullType.SUPERVISOR_ID(I)||fnd_global.local_chr(400)||
843: WorkForceFullType.ASGN_START_DT(I)||fnd_global.local_chr(400)||
844: WorkForceFullType.ASGN_END_DT(I)||fnd_global.local_chr(400)||
845: WorkForceFullType.STEP(I)||fnd_global.local_chr(400)||
846: WorkForceFullType.TERMINATION_DT(I)||fnd_global.local_chr(400)||

Line 843: WorkForceFullType.ASGN_START_DT(I)||fnd_global.local_chr(400)||

839: WorkForceFullType.STD_HOURS(I)||fnd_global.local_chr(400)||
840: WorkForceFullType.STD_HRS_FREQUENCY(I)||fnd_global.local_chr(400)||
841: WorkForceFullType.GRADE(I)||fnd_global.local_chr(400)||
842: WorkForceFullType.SUPERVISOR_ID(I)||fnd_global.local_chr(400)||
843: WorkForceFullType.ASGN_START_DT(I)||fnd_global.local_chr(400)||
844: WorkForceFullType.ASGN_END_DT(I)||fnd_global.local_chr(400)||
845: WorkForceFullType.STEP(I)||fnd_global.local_chr(400)||
846: WorkForceFullType.TERMINATION_DT(I)||fnd_global.local_chr(400)||
847: WorkForceFullType.LAST_DATE_WORKED(I)

Line 844: WorkForceFullType.ASGN_END_DT(I)||fnd_global.local_chr(400)||

840: WorkForceFullType.STD_HRS_FREQUENCY(I)||fnd_global.local_chr(400)||
841: WorkForceFullType.GRADE(I)||fnd_global.local_chr(400)||
842: WorkForceFullType.SUPERVISOR_ID(I)||fnd_global.local_chr(400)||
843: WorkForceFullType.ASGN_START_DT(I)||fnd_global.local_chr(400)||
844: WorkForceFullType.ASGN_END_DT(I)||fnd_global.local_chr(400)||
845: WorkForceFullType.STEP(I)||fnd_global.local_chr(400)||
846: WorkForceFullType.TERMINATION_DT(I)||fnd_global.local_chr(400)||
847: WorkForceFullType.LAST_DATE_WORKED(I)
848: );

Line 845: WorkForceFullType.STEP(I)||fnd_global.local_chr(400)||

841: WorkForceFullType.GRADE(I)||fnd_global.local_chr(400)||
842: WorkForceFullType.SUPERVISOR_ID(I)||fnd_global.local_chr(400)||
843: WorkForceFullType.ASGN_START_DT(I)||fnd_global.local_chr(400)||
844: WorkForceFullType.ASGN_END_DT(I)||fnd_global.local_chr(400)||
845: WorkForceFullType.STEP(I)||fnd_global.local_chr(400)||
846: WorkForceFullType.TERMINATION_DT(I)||fnd_global.local_chr(400)||
847: WorkForceFullType.LAST_DATE_WORKED(I)
848: );
849:

Line 846: WorkForceFullType.TERMINATION_DT(I)||fnd_global.local_chr(400)||

842: WorkForceFullType.SUPERVISOR_ID(I)||fnd_global.local_chr(400)||
843: WorkForceFullType.ASGN_START_DT(I)||fnd_global.local_chr(400)||
844: WorkForceFullType.ASGN_END_DT(I)||fnd_global.local_chr(400)||
845: WorkForceFullType.STEP(I)||fnd_global.local_chr(400)||
846: WorkForceFullType.TERMINATION_DT(I)||fnd_global.local_chr(400)||
847: WorkForceFullType.LAST_DATE_WORKED(I)
848: );
849:
850: FND_FILE.NEW_LINE(FND_FILE.output, 1);

Line 934: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_bg_id||fnd_global.local_chr(400)||p_dept_id||fnd_global.local_chr(400)||p_eff_date||

930: loop
931: fetch fet_org_fsync into p_bg_id,p_dept_id,p_eff_date,p_eff_status,p_bg_name,p_loc_id,p_person_id,p_full_name;
932: exit when fet_org_fsync%notfound;
933:
934: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_bg_id||fnd_global.local_chr(400)||p_dept_id||fnd_global.local_chr(400)||p_eff_date||
935: fnd_global.local_chr(400)||
936: p_eff_status||fnd_global.local_chr(400)||p_bg_name||fnd_global.local_chr(400)||
937: p_loc_id||fnd_global.local_chr(400)||p_person_id||fnd_global.local_chr(400)||p_full_name);
938: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

Line 935: fnd_global.local_chr(400)||

931: fetch fet_org_fsync into p_bg_id,p_dept_id,p_eff_date,p_eff_status,p_bg_name,p_loc_id,p_person_id,p_full_name;
932: exit when fet_org_fsync%notfound;
933:
934: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_bg_id||fnd_global.local_chr(400)||p_dept_id||fnd_global.local_chr(400)||p_eff_date||
935: fnd_global.local_chr(400)||
936: p_eff_status||fnd_global.local_chr(400)||p_bg_name||fnd_global.local_chr(400)||
937: p_loc_id||fnd_global.local_chr(400)||p_person_id||fnd_global.local_chr(400)||p_full_name);
938: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
939: end loop;

Line 936: p_eff_status||fnd_global.local_chr(400)||p_bg_name||fnd_global.local_chr(400)||

932: exit when fet_org_fsync%notfound;
933:
934: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_bg_id||fnd_global.local_chr(400)||p_dept_id||fnd_global.local_chr(400)||p_eff_date||
935: fnd_global.local_chr(400)||
936: p_eff_status||fnd_global.local_chr(400)||p_bg_name||fnd_global.local_chr(400)||
937: p_loc_id||fnd_global.local_chr(400)||p_person_id||fnd_global.local_chr(400)||p_full_name);
938: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
939: end loop;
940: close fet_org_fsync;

Line 937: p_loc_id||fnd_global.local_chr(400)||p_person_id||fnd_global.local_chr(400)||p_full_name);

933:
934: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_bg_id||fnd_global.local_chr(400)||p_dept_id||fnd_global.local_chr(400)||p_eff_date||
935: fnd_global.local_chr(400)||
936: p_eff_status||fnd_global.local_chr(400)||p_bg_name||fnd_global.local_chr(400)||
937: p_loc_id||fnd_global.local_chr(400)||p_person_id||fnd_global.local_chr(400)||p_full_name);
938: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
939: end loop;
940: close fet_org_fsync;
941:

Line 1008: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_bg_id||fnd_global.local_chr(400)||p_bg_name||fnd_global.local_chr(400)||

1004: open fet_bg_fsync;
1005: loop
1006: fetch fet_bg_fsync into p_bg_id,p_bg_name,p_eff_date,p_eff_status;
1007: exit when fet_bg_fsync%notfound;
1008: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_bg_id||fnd_global.local_chr(400)||p_bg_name||fnd_global.local_chr(400)||
1009: p_eff_date||fnd_global.local_chr(400)||p_eff_status);
1010: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1011: end loop;
1012: close fet_bg_fsync;

Line 1009: p_eff_date||fnd_global.local_chr(400)||p_eff_status);

1005: loop
1006: fetch fet_bg_fsync into p_bg_id,p_bg_name,p_eff_date,p_eff_status;
1007: exit when fet_bg_fsync%notfound;
1008: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_bg_id||fnd_global.local_chr(400)||p_bg_name||fnd_global.local_chr(400)||
1009: p_eff_date||fnd_global.local_chr(400)||p_eff_status);
1010: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1011: end loop;
1012: close fet_bg_fsync;
1013:

Line 1083: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_pyrl_id||fnd_global.local_chr(400)||

1079: loop
1080:
1081: fetch fet_pyrl_fsync into p_pyrl_id,p_pyrl_name,p_bg_id,p_eff_date,p_eff_status;
1082: exit when fet_pyrl_fsync%notfound;
1083: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_pyrl_id||fnd_global.local_chr(400)||
1084: p_pyrl_name||fnd_global.local_chr(400)||p_bg_id||fnd_global.local_chr(400)||p_eff_date||fnd_global.local_chr(400)||p_eff_status);
1085: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1086: end loop;
1087: close fet_pyrl_fsync;

Line 1084: p_pyrl_name||fnd_global.local_chr(400)||p_bg_id||fnd_global.local_chr(400)||p_eff_date||fnd_global.local_chr(400)||p_eff_status);

1080:
1081: fetch fet_pyrl_fsync into p_pyrl_id,p_pyrl_name,p_bg_id,p_eff_date,p_eff_status;
1082: exit when fet_pyrl_fsync%notfound;
1083: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_pyrl_id||fnd_global.local_chr(400)||
1084: p_pyrl_name||fnd_global.local_chr(400)||p_bg_id||fnd_global.local_chr(400)||p_eff_date||fnd_global.local_chr(400)||p_eff_status);
1085: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
1086: end loop;
1087: close fet_pyrl_fsync;
1088: