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 385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_bg_id||fnd_global.local_chr(400)||p_loc_id||

381: p_town_or_city,p_region_1,p_region_2,p_region_3,p_postal_code,p_tel_no_1,p_tel_no_2 ,
382: 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,
383: p_loc_info_19,p_loc_info_20;
384: exit when fet_loc_sync%notfound;
385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_bg_id||fnd_global.local_chr(400)||p_loc_id||
386: fnd_global.local_chr(400)||p_active_date||
387: fnd_global.local_chr(400)||p_effecive_status||fnd_global.local_chr(400)||
388: p_loc_code||fnd_global.local_chr(400)|| p_loc_desc||fnd_global.local_chr(400)||'ADDRESS_START'||
389: fnd_global.local_chr(400)||p_loc_style ||fnd_global.local_chr(400)|| p_add_line_1||

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

382: 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,
383: p_loc_info_19,p_loc_info_20;
384: exit when fet_loc_sync%notfound;
385: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_bg_id||fnd_global.local_chr(400)||p_loc_id||
386: fnd_global.local_chr(400)||p_active_date||
387: fnd_global.local_chr(400)||p_effecive_status||fnd_global.local_chr(400)||
388: p_loc_code||fnd_global.local_chr(400)|| p_loc_desc||fnd_global.local_chr(400)||'ADDRESS_START'||
389: fnd_global.local_chr(400)||p_loc_style ||fnd_global.local_chr(400)|| p_add_line_1||
390: fnd_global.local_chr(400)|| p_add_line_2||fnd_global.local_chr(400)|| p_add_line_3||

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 400: fnd_global.local_chr(400));

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

Line 597: 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

593: L_POSTAL_CODE, L_EMAIL_ADDRESS, L_PHONE_TYPE
594: ,L_PHONE_NUMBER,L_NATIONALITY ,L_NATIONAL_IDENTIFIER ;
595:
596: exit when csr_person_data%notfound;
597: 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
598: ||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
599: ||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
600: ||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
601: ||fnd_global.local_chr(400)||L_SUFFIX||fnd_global.local_chr(400)||L_TITLE||fnd_global.local_chr(400)||L_LAST_NAME

Line 598: ||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

594: ,L_PHONE_NUMBER,L_NATIONALITY ,L_NATIONAL_IDENTIFIER ;
595:
596: exit when csr_person_data%notfound;
597: 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
598: ||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
599: ||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
600: ||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
601: ||fnd_global.local_chr(400)||L_SUFFIX||fnd_global.local_chr(400)||L_TITLE||fnd_global.local_chr(400)||L_LAST_NAME
602: ||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 599: ||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

595:
596: exit when csr_person_data%notfound;
597: 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
598: ||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
599: ||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
600: ||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
601: ||fnd_global.local_chr(400)||L_SUFFIX||fnd_global.local_chr(400)||L_TITLE||fnd_global.local_chr(400)||L_LAST_NAME
602: ||fnd_global.local_chr(400)||L_FIRST_NAME||fnd_global.local_chr(400)||L_MIDDLE_NAMES||fnd_global.local_chr(400)||L_ADDRESS_TYPE
603: ||fnd_global.local_chr(400)||L_DATE_FROM||fnd_global.local_chr(400)||L_COUNTRY||fnd_global.local_chr(400)||L_ADDRESS_LINE1

Line 600: ||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

596: exit when csr_person_data%notfound;
597: 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
598: ||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
599: ||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
600: ||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
601: ||fnd_global.local_chr(400)||L_SUFFIX||fnd_global.local_chr(400)||L_TITLE||fnd_global.local_chr(400)||L_LAST_NAME
602: ||fnd_global.local_chr(400)||L_FIRST_NAME||fnd_global.local_chr(400)||L_MIDDLE_NAMES||fnd_global.local_chr(400)||L_ADDRESS_TYPE
603: ||fnd_global.local_chr(400)||L_DATE_FROM||fnd_global.local_chr(400)||L_COUNTRY||fnd_global.local_chr(400)||L_ADDRESS_LINE1
604: ||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 601: ||fnd_global.local_chr(400)||L_SUFFIX||fnd_global.local_chr(400)||L_TITLE||fnd_global.local_chr(400)||L_LAST_NAME

597: 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
598: ||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
599: ||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
600: ||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
601: ||fnd_global.local_chr(400)||L_SUFFIX||fnd_global.local_chr(400)||L_TITLE||fnd_global.local_chr(400)||L_LAST_NAME
602: ||fnd_global.local_chr(400)||L_FIRST_NAME||fnd_global.local_chr(400)||L_MIDDLE_NAMES||fnd_global.local_chr(400)||L_ADDRESS_TYPE
603: ||fnd_global.local_chr(400)||L_DATE_FROM||fnd_global.local_chr(400)||L_COUNTRY||fnd_global.local_chr(400)||L_ADDRESS_LINE1
604: ||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
605: ||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 602: ||fnd_global.local_chr(400)||L_FIRST_NAME||fnd_global.local_chr(400)||L_MIDDLE_NAMES||fnd_global.local_chr(400)||L_ADDRESS_TYPE

598: ||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
599: ||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
600: ||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
601: ||fnd_global.local_chr(400)||L_SUFFIX||fnd_global.local_chr(400)||L_TITLE||fnd_global.local_chr(400)||L_LAST_NAME
602: ||fnd_global.local_chr(400)||L_FIRST_NAME||fnd_global.local_chr(400)||L_MIDDLE_NAMES||fnd_global.local_chr(400)||L_ADDRESS_TYPE
603: ||fnd_global.local_chr(400)||L_DATE_FROM||fnd_global.local_chr(400)||L_COUNTRY||fnd_global.local_chr(400)||L_ADDRESS_LINE1
604: ||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
605: ||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
606: ||fnd_global.local_chr(400)||L_PHONE_NUMBER||fnd_global.local_chr(400)||L_NATIONALITY||fnd_global.local_chr(400)||L_NATIONAL_IDENTIFIER

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

599: ||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
600: ||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
601: ||fnd_global.local_chr(400)||L_SUFFIX||fnd_global.local_chr(400)||L_TITLE||fnd_global.local_chr(400)||L_LAST_NAME
602: ||fnd_global.local_chr(400)||L_FIRST_NAME||fnd_global.local_chr(400)||L_MIDDLE_NAMES||fnd_global.local_chr(400)||L_ADDRESS_TYPE
603: ||fnd_global.local_chr(400)||L_DATE_FROM||fnd_global.local_chr(400)||L_COUNTRY||fnd_global.local_chr(400)||L_ADDRESS_LINE1
604: ||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
605: ||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
606: ||fnd_global.local_chr(400)||L_PHONE_NUMBER||fnd_global.local_chr(400)||L_NATIONALITY||fnd_global.local_chr(400)||L_NATIONAL_IDENTIFIER
607: );

Line 604: ||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

600: ||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
601: ||fnd_global.local_chr(400)||L_SUFFIX||fnd_global.local_chr(400)||L_TITLE||fnd_global.local_chr(400)||L_LAST_NAME
602: ||fnd_global.local_chr(400)||L_FIRST_NAME||fnd_global.local_chr(400)||L_MIDDLE_NAMES||fnd_global.local_chr(400)||L_ADDRESS_TYPE
603: ||fnd_global.local_chr(400)||L_DATE_FROM||fnd_global.local_chr(400)||L_COUNTRY||fnd_global.local_chr(400)||L_ADDRESS_LINE1
604: ||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
605: ||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
606: ||fnd_global.local_chr(400)||L_PHONE_NUMBER||fnd_global.local_chr(400)||L_NATIONALITY||fnd_global.local_chr(400)||L_NATIONAL_IDENTIFIER
607: );
608: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

Line 605: ||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

601: ||fnd_global.local_chr(400)||L_SUFFIX||fnd_global.local_chr(400)||L_TITLE||fnd_global.local_chr(400)||L_LAST_NAME
602: ||fnd_global.local_chr(400)||L_FIRST_NAME||fnd_global.local_chr(400)||L_MIDDLE_NAMES||fnd_global.local_chr(400)||L_ADDRESS_TYPE
603: ||fnd_global.local_chr(400)||L_DATE_FROM||fnd_global.local_chr(400)||L_COUNTRY||fnd_global.local_chr(400)||L_ADDRESS_LINE1
604: ||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
605: ||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
606: ||fnd_global.local_chr(400)||L_PHONE_NUMBER||fnd_global.local_chr(400)||L_NATIONALITY||fnd_global.local_chr(400)||L_NATIONAL_IDENTIFIER
607: );
608: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
609: end loop;

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

602: ||fnd_global.local_chr(400)||L_FIRST_NAME||fnd_global.local_chr(400)||L_MIDDLE_NAMES||fnd_global.local_chr(400)||L_ADDRESS_TYPE
603: ||fnd_global.local_chr(400)||L_DATE_FROM||fnd_global.local_chr(400)||L_COUNTRY||fnd_global.local_chr(400)||L_ADDRESS_LINE1
604: ||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
605: ||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
606: ||fnd_global.local_chr(400)||L_PHONE_NUMBER||fnd_global.local_chr(400)||L_NATIONALITY||fnd_global.local_chr(400)||L_NATIONAL_IDENTIFIER
607: );
608: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
609: end loop;
610: close csr_person_data;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 933: 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||

929: loop
930: 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;
931: exit when fet_org_fsync%notfound;
932:
933: 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||
934: fnd_global.local_chr(400)||
935: p_eff_status||fnd_global.local_chr(400)||p_bg_name||fnd_global.local_chr(400)||
936: p_loc_id||fnd_global.local_chr(400)||p_person_id||fnd_global.local_chr(400)||p_full_name);
937: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

Line 934: fnd_global.local_chr(400)||

930: 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;
931: exit when fet_org_fsync%notfound;
932:
933: 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||
934: fnd_global.local_chr(400)||
935: p_eff_status||fnd_global.local_chr(400)||p_bg_name||fnd_global.local_chr(400)||
936: p_loc_id||fnd_global.local_chr(400)||p_person_id||fnd_global.local_chr(400)||p_full_name);
937: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
938: end loop;

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

931: exit when fet_org_fsync%notfound;
932:
933: 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||
934: fnd_global.local_chr(400)||
935: p_eff_status||fnd_global.local_chr(400)||p_bg_name||fnd_global.local_chr(400)||
936: p_loc_id||fnd_global.local_chr(400)||p_person_id||fnd_global.local_chr(400)||p_full_name);
937: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
938: end loop;
939: close fet_org_fsync;

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

932:
933: 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||
934: fnd_global.local_chr(400)||
935: p_eff_status||fnd_global.local_chr(400)||p_bg_name||fnd_global.local_chr(400)||
936: p_loc_id||fnd_global.local_chr(400)||p_person_id||fnd_global.local_chr(400)||p_full_name);
937: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
938: end loop;
939: close fet_org_fsync;
940:

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

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

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

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

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

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

Line 1083: 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);

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