APPS.IGS_PE_GEN_002 dependencies on FND_USER

Line 203: || ssaleem 13-Apr-2005 Bug 4293911 Fnd User customer Id replaced with person

199: || ssawhney Incorrect check while cheking for SUSPENSION effect.
200: || BUG : 2832973. message stack initialzied and record already exists added
201: || check for 'IGS_EN_ENCMBR_HAS_SPECIFIED' also added explicity
202: || kumma 11-MAR-2003 2841566, Removed the close c_user statement from the else clause when the p_admin is null
203: || ssaleem 13-Apr-2005 Bug 4293911 Fnd User customer Id replaced with person
204: || party id
205: */
206:
207:

Line 209: -- fnd user check cursor.

205: */
206:
207:
208:
209: -- fnd user check cursor.
210: CURSOR c_user (cp_user fnd_user.user_name%TYPE) IS
211: SELECT
212: 'X'
213: FROM

Line 210: CURSOR c_user (cp_user fnd_user.user_name%TYPE) IS

206:
207:
208:
209: -- fnd user check cursor.
210: CURSOR c_user (cp_user fnd_user.user_name%TYPE) IS
211: SELECT
212: 'X'
213: FROM
214: fnd_user

Line 214: fnd_user

210: CURSOR c_user (cp_user fnd_user.user_name%TYPE) IS
211: SELECT
212: 'X'
213: FROM
214: fnd_user
215: WHERE
216: user_name = cp_user AND
217: email_address IS NOT NULL AND
218: person_party_id IS NOT NULL;

Line 290: l_admin fnd_user.user_name%TYPE;

286: l_expiry_date VARCHAR2(30);
287: l_d_expiry_date DATE := NULL;
288:
289: l_external_ref igs_pe_pers_encumb.external_reference%TYPE;
290: l_admin fnd_user.user_name%TYPE;
291: l_person_name igs_pe_person_base_v.full_name%TYPE;
292:
293:
294: l_student_rec c_student_chk%ROWTYPE;

Line 756: p_fnd_user_id => NULL,

752:
753: igs_pe_gen_001.release_hold
754: (
755: p_resp_id => NULL,
756: p_fnd_user_id => NULL,
757: p_person_id => l_student_rec.person_id,
758: p_encumbrance_type => l_hold_type,
759: p_start_dt => igs_ge_date.igsdate(igs_ge_date.igschar(l_start_dt)),
760: p_expiry_dt => igs_ge_date.igsdate(igs_ge_date.igschar(l_expiry_date)),