APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on FND_GLOBAL

Line 503: last_updated_by = Fnd_Global.user_id,

499:
500: -- update existing record
501: UPDATE igs_pe_alt_pers_id
502: SET end_dt = l_end_dt,
503: last_updated_by = Fnd_Global.user_id,
504: last_update_date = Sysdate,
505: last_update_login = Fnd_Global.login_id
506: WHERE pe_person_id = p_person_id
507: AND api_person_id = l_stdnt_id

Line 505: last_update_login = Fnd_Global.login_id

501: UPDATE igs_pe_alt_pers_id
502: SET end_dt = l_end_dt,
503: last_updated_by = Fnd_Global.user_id,
504: last_update_date = Sysdate,
505: last_update_login = Fnd_Global.login_id
506: WHERE pe_person_id = p_person_id
507: AND api_person_id = l_stdnt_id
508: AND person_id_type = 'HUSID'
509: AND start_dt = l_start_dt;

Line 539: Fnd_Global.user_id,

535: l_stdnt_id,
536: 'HUSID',
537: l_start_dt ,
538: l_end_dt ,
539: Fnd_Global.user_id,
540: Sysdate,
541: Fnd_Global.user_id,
542: Sysdate,
543: Fnd_Global.login_id);

Line 541: Fnd_Global.user_id,

537: l_start_dt ,
538: l_end_dt ,
539: Fnd_Global.user_id,
540: Sysdate,
541: Fnd_Global.user_id,
542: Sysdate,
543: Fnd_Global.login_id);
544:
545: END IF;

Line 543: Fnd_Global.login_id);

539: Fnd_Global.user_id,
540: Sysdate,
541: Fnd_Global.user_id,
542: Sysdate,
543: Fnd_Global.login_id);
544:
545: END IF;
546:
547: IF l_cre_lat_husid THEN

Line 560: last_updated_by = Fnd_Global.user_id,

556:
557: -- update existing record
558: UPDATE igs_pe_alt_pers_id
559: SET end_dt = NULL,
560: last_updated_by = Fnd_Global.user_id,
561: last_update_date = Sysdate,
562: last_update_login = Fnd_Global.login_id
563: WHERE pe_person_id = p_person_id
564: AND api_person_id = l_stdnt_id

Line 562: last_update_login = Fnd_Global.login_id

558: UPDATE igs_pe_alt_pers_id
559: SET end_dt = NULL,
560: last_updated_by = Fnd_Global.user_id,
561: last_update_date = Sysdate,
562: last_update_login = Fnd_Global.login_id
563: WHERE pe_person_id = p_person_id
564: AND api_person_id = l_stdnt_id
565: AND person_id_type = 'HUSID'
566: AND start_dt = c_husid_rec.end_dt + 1;

Line 596: Fnd_Global.user_id,

592: l_stdnt_id,
593: 'HUSID',
594: c_husid_rec.end_dt + 1 ,
595: NULL ,
596: Fnd_Global.user_id,
597: Sysdate,
598: Fnd_Global.user_id,
599: Sysdate,
600: Fnd_Global.login_id);

Line 598: Fnd_Global.user_id,

594: c_husid_rec.end_dt + 1 ,
595: NULL ,
596: Fnd_Global.user_id,
597: Sysdate,
598: Fnd_Global.user_id,
599: Sysdate,
600: Fnd_Global.login_id);
601:
602: END IF;

Line 600: Fnd_Global.login_id);

596: Fnd_Global.user_id,
597: Sysdate,
598: Fnd_Global.user_id,
599: Sysdate,
600: Fnd_Global.login_id);
601:
602: END IF;
603:
604: END IF ;