1: PACKAGE BODY HR_HRHD_INITIAL_LOAD as
2: /* $Header: perhdfsyn.pkb 120.4.12020000.3 2013/02/22 15:20:38 pathota ship $ */
3:
4: p_effective_date DATE default sysdate;
5:
1090: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1091: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1092: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1093: p_national_id_label||fnd_global.local_chr(400)||
1094: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1095: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1096: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1097:
1098:
1091: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1092: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1093: p_national_id_label||fnd_global.local_chr(400)||
1094: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1095: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1096: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1097:
1098:
1099: else
1141: fnd_global.local_chr(400)||
1142: fnd_global.local_chr(400)||
1143: fnd_global.local_chr(400)||
1144: p_national_id_label||fnd_global.local_chr(400)||
1145: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1146: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1147: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1148:
1149:
1142: fnd_global.local_chr(400)||
1143: fnd_global.local_chr(400)||
1144: p_national_id_label||fnd_global.local_chr(400)||
1145: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1146: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1147: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1148:
1149:
1150: end if;
1202: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1203: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1204: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1205: p_national_id_label||fnd_global.local_chr(400)||
1206: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1207: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1208: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1209:
1210: else
1203: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1204: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1205: p_national_id_label||fnd_global.local_chr(400)||
1206: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1207: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1208: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1209:
1210: else
1211:
1252: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1253: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1254: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1255: p_national_id_label||fnd_global.local_chr(400)||
1256: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1257: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1258: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1259: end if;
1260: end loop;
1253: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1254: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1255: p_national_id_label||fnd_global.local_chr(400)||
1256: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1257: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1258: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1259: end if;
1260: end loop;
1261: end if;
1308: p_phn_type(k).p_phn_date_to||fnd_global.local_chr(400)||
1309: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1310: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1311: p_national_id_label||fnd_global.local_chr(400)||
1312: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1313: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1314: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1315:
1316: end loop;
1309: p_phn_type(k).p_phone_type ||fnd_global.local_chr(400)||
1310: p_phn_type(k).p_phone_no||fnd_global.local_chr(400)||
1311: p_national_id_label||fnd_global.local_chr(400)||
1312: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1313: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1314: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1315:
1316: end loop;
1317: end if;
1364: fnd_global.local_chr(400)||
1365: fnd_global.local_chr(400)||
1366: fnd_global.local_chr(400)||
1367: p_national_id_label||fnd_global.local_chr(400)||
1368: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1369: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1370: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1371:
1372: end loop;
1365: fnd_global.local_chr(400)||
1366: fnd_global.local_chr(400)||
1367: p_national_id_label||fnd_global.local_chr(400)||
1368: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1369: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1370: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1371:
1372: end loop;
1373: end if;
1420: fnd_global.local_chr(400)||
1421: fnd_global.local_chr(400)||
1422: fnd_global.local_chr(400)||
1423: p_national_id_label||fnd_global.local_chr(400)||
1424: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1425: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1426: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1427:
1428:
1421: fnd_global.local_chr(400)||
1422: fnd_global.local_chr(400)||
1423: p_national_id_label||fnd_global.local_chr(400)||
1424: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||
1425: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||
1426: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1427:
1428:
1429: end if;
1482: is
1483: begin
1484:
1485: if p_process_name = 'LOCATION_FULL_SYNCH' then
1486: HR_HRHD_INITIAL_LOAD.HR_LOCATION_INITIAL_LOAD(ERRBUF,RETCODE,p_no_of_files);
1487:
1488: elsif p_process_name = 'JOBCODE_FULL_SYNCH' then
1489: HR_HRHD_INITIAL_LOAD.HR_JOBCODE_INITIAL_LOAD(ERRBUF,RETCODE,p_no_of_files);
1490:
1485: if p_process_name = 'LOCATION_FULL_SYNCH' then
1486: HR_HRHD_INITIAL_LOAD.HR_LOCATION_INITIAL_LOAD(ERRBUF,RETCODE,p_no_of_files);
1487:
1488: elsif p_process_name = 'JOBCODE_FULL_SYNCH' then
1489: HR_HRHD_INITIAL_LOAD.HR_JOBCODE_INITIAL_LOAD(ERRBUF,RETCODE,p_no_of_files);
1490:
1491: elsif p_process_name = 'ORGANIZATION_FULL_SYNCH' then
1492: HR_HRHD_INITIAL_LOAD.HR_ORGANIZATION_INITIAL_LOAD(ERRBUF,RETCODE,p_no_of_files);
1493:
1488: elsif p_process_name = 'JOBCODE_FULL_SYNCH' then
1489: HR_HRHD_INITIAL_LOAD.HR_JOBCODE_INITIAL_LOAD(ERRBUF,RETCODE,p_no_of_files);
1490:
1491: elsif p_process_name = 'ORGANIZATION_FULL_SYNCH' then
1492: HR_HRHD_INITIAL_LOAD.HR_ORGANIZATION_INITIAL_LOAD(ERRBUF,RETCODE,p_no_of_files);
1493:
1494: elsif p_process_name = 'WORKFORCE_FULL_SYNCH' then
1495: HR_HRHD_INITIAL_LOAD.HR_WORKFORCE_INITIAL_LOAD(ERRBUF,RETCODE,p_no_of_files);
1496:
1491: elsif p_process_name = 'ORGANIZATION_FULL_SYNCH' then
1492: HR_HRHD_INITIAL_LOAD.HR_ORGANIZATION_INITIAL_LOAD(ERRBUF,RETCODE,p_no_of_files);
1493:
1494: elsif p_process_name = 'WORKFORCE_FULL_SYNCH' then
1495: HR_HRHD_INITIAL_LOAD.HR_WORKFORCE_INITIAL_LOAD(ERRBUF,RETCODE,p_no_of_files);
1496:
1497: elsif p_process_name = 'PERSON_FULL_SYNCH' then
1498: HR_HRHD_INITIAL_LOAD.HR_PERSON_INITIAL_LOAD(ERRBUF,RETCODE,p_no_of_files);
1499: end if;
1494: elsif p_process_name = 'WORKFORCE_FULL_SYNCH' then
1495: HR_HRHD_INITIAL_LOAD.HR_WORKFORCE_INITIAL_LOAD(ERRBUF,RETCODE,p_no_of_files);
1496:
1497: elsif p_process_name = 'PERSON_FULL_SYNCH' then
1498: HR_HRHD_INITIAL_LOAD.HR_PERSON_INITIAL_LOAD(ERRBUF,RETCODE,p_no_of_files);
1499: end if;
1500: end HR_INITIAL_LOAD;
1501: /*Common Procedure called from concurrent program ends*/
1502:
1530:
1531: END;
1532:
1533:
1534: end HR_HRHD_INITIAL_LOAD;
1535: