DBA Data[Home] [Help]

APPS.HR_HRHD_INITIAL_LOAD dependencies on HR_HRHD_INITIAL_LOAD

Line 1: PACKAGE BODY HR_HRHD_INITIAL_LOAD as

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:

Line 1094: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||

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:

Line 1095: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||

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

Line 1145: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||

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:

Line 1146: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||

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;

Line 1206: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||

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

Line 1207: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||

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:

Line 1256: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||

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;

Line 1257: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||

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;

Line 1312: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||

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;

Line 1313: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||

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;

Line 1368: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||

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;

Line 1369: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||

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;

Line 1424: hr_hrhd_initial_load.hr_hrhd_encrypt(p_person_id)||fnd_global.local_chr(400)||

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:

Line 1425: hr_hrhd_initial_load.hr_hrhd_encrypt(p_business_group_id)||

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;

Line 1486: HR_HRHD_INITIAL_LOAD.HR_LOCATION_INITIAL_LOAD(ERRBUF,RETCODE,p_no_of_files);

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:

Line 1489: HR_HRHD_INITIAL_LOAD.HR_JOBCODE_INITIAL_LOAD(ERRBUF,RETCODE,p_no_of_files);

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:

Line 1492: HR_HRHD_INITIAL_LOAD.HR_ORGANIZATION_INITIAL_LOAD(ERRBUF,RETCODE,p_no_of_files);

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:

Line 1495: HR_HRHD_INITIAL_LOAD.HR_WORKFORCE_INITIAL_LOAD(ERRBUF,RETCODE,p_no_of_files);

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;

Line 1498: HR_HRHD_INITIAL_LOAD.HR_PERSON_INITIAL_LOAD(ERRBUF,RETCODE,p_no_of_files);

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:

Line 1534: end HR_HRHD_INITIAL_LOAD;

1530:
1531: END;
1532:
1533:
1534: end HR_HRHD_INITIAL_LOAD;
1535: