APPS.IGS_HE_IMPORT_DATA dependencies on IGS_AD_API_INT

Line 178: l_api_start_dt igs_ad_api_int.start_dt%TYPE;

174:
175: l_interface_api_id NUMBER ;
176: l_created_by CONSTANT NUMBER := FND_GLOBAL.USER_ID;
177: l_last_updated_by CONSTANT NUMBER := FND_GLOBAL.LOGIN_ID;
178: l_api_start_dt igs_ad_api_int.start_dt%TYPE;
179: l_insert_record BOOLEAN;
180:
181: -- sjlaport HEFD350 Process 4
182: -- Select the latest alternate person id details for the specified person

Line 211: INSERT INTO igs_ad_api_int(status,

207: ELSE
208:
209: -- No records exist with for person being imported
210: -- so create this id directly
211: INSERT INTO igs_ad_api_int(status,
212: org_id,
213: person_id_type,
214: alternate_id,
215: start_dt,

Line 229: igs_ad_api_int_s.NEXTVAL,

225: p_alt_person_type,
226: p_alt_pers_id,
227: TRUNC(SYSDATE),
228: NULL,
229: igs_ad_api_int_s.NEXTVAL,
230: p_interface_id,
231: l_created_by,
232: SYSDATE,
233: l_last_updated_by,

Line 274: INSERT INTO igs_ad_api_int(status,

270: log_error('E39', p_interface_hesa_id, p_alt_person_type || ' ' || p_alt_pers_id);
271: ELSE
272:
273: -- Close existing record
274: INSERT INTO igs_ad_api_int(status,
275: org_id,
276: person_id_type,
277: alternate_id,
278: start_dt,

Line 292: igs_ad_api_int_s.NEXTVAL,

288: p_alt_person_type,
289: c_pe_alt_pers_rec.api_person_id,
290: NVL(c_pe_alt_pers_rec.start_dt , Trunc(SYSDATE - 1) ),
291: Trunc(SYSDATE - 1),
292: igs_ad_api_int_s.NEXTVAL,
293: p_interface_id,
294: l_created_by,
295: SYSDATE,
296: l_last_updated_by,

Line 327: INSERT INTO igs_ad_api_int(status,

323: IF l_insert_record THEN
324:
325: -- Create a new record based on the interface record
326: -- starting from SYSDATE
327: INSERT INTO igs_ad_api_int(status,
328: org_id,
329: person_id_type,
330: alternate_id,
331: start_dt,

Line 345: igs_ad_api_int_s.NEXTVAL,

341: p_alt_person_type,
342: p_alt_pers_id,
343: TRUNC(SYSDATE),
344: NULL,
345: igs_ad_api_int_s.NEXTVAL,
346: p_interface_id,
347: l_created_by,
348: SYSDATE,
349: l_last_updated_by,

Line 420: INSERT INTO igs_ad_api_int(status,

416:
417: IF l_insert_record THEN
418:
419: -- Create record from specified start date
420: INSERT INTO igs_ad_api_int(status,
421: org_id,
422: person_id_type,
423: alternate_id,
424: start_dt,

Line 438: igs_ad_api_int_s.NEXTVAL,

434: p_alt_person_type,
435: p_alt_pers_id,
436: l_api_start_dt,
437: NULL,
438: igs_ad_api_int_s.NEXTVAL,
439: p_interface_id,
440: l_created_by,
441: SYSDATE,
442: l_last_updated_by,