APPS.IGS_PE_GEN_001 dependencies on FND_USER

Line 154: (p_fnd_user_id IN fnd_user.user_id%TYPE,

150: RETURN '';
151: END get_person_encumb;
152:
153: PROCEDURE get_hold_auth
154: (p_fnd_user_id IN fnd_user.user_id%TYPE,
155: p_person_id OUT NOCOPY hz_parties.party_id%TYPE,
156: p_person_number OUT NOCOPY hz_parties.party_number%TYPE,
157: p_person_name OUT NOCOPY hz_person_profiles.person_name%TYPE,
158: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE

Line 172: FROM fnd_user

168: */
169: -- Cursor to find the Person ID of the user logged in
170: CURSOR person_cur IS
171: SELECT person_party_id
172: FROM fnd_user
173: WHERE user_id = p_fnd_user_id AND
174: SYSDATE between start_date AND NVL(end_date,SYSDATE);
175:
176: -- Cursor to find the full name of the user logged in

Line 173: WHERE user_id = p_fnd_user_id AND

169: -- Cursor to find the Person ID of the user logged in
170: CURSOR person_cur IS
171: SELECT person_party_id
172: FROM fnd_user
173: WHERE user_id = p_fnd_user_id AND
174: SYSDATE between start_date AND NVL(end_date,SYSDATE);
175:
176: -- Cursor to find the full name of the user logged in
177: CURSOR person_name_cur(cp_person_id hz_parties.party_id%TYPE) IS

Line 222: p_fnd_user_id IN fnd_user.user_id%TYPE,

218:
219:
220: PROCEDURE validate_hold_resp
221: (p_resp_id IN fnd_responsibility.responsibility_id%TYPE,
222: p_fnd_user_id IN fnd_user.user_id%TYPE,
223: p_person_id IN hz_parties.party_id%TYPE,
224: p_encumbrance_type IN igs_pe_pers_encumb.encumbrance_type%TYPE,
225: p_start_dt IN igs_pe_pers_encumb.start_dt%TYPE,
226: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE

Line 265: get_hold_auth(p_fnd_user_id,

261: --when processing for a batch of persons the validation should not happen for each record.
262: --instead the validation should be done at the beginning. Hance the value of the variable
263: --igs_pe_gen_001.g_hold_validation should be 'N' for batch processing.
264:
265: get_hold_auth(p_fnd_user_id,
266: l_person_id,
267: l_person_number,
268: l_person_name,
269: l_message_name);

Line 302: p_fnd_user_id IN fnd_user.user_id%TYPE,

298: END validate_hold_resp;
299:
300: PROCEDURE release_hold
301: (p_resp_id IN fnd_responsibility.responsibility_id%TYPE,
302: p_fnd_user_id IN fnd_user.user_id%TYPE,
303: p_person_id IN hz_parties.party_id%TYPE,
304: p_encumbrance_type IN igs_pe_pers_encumb.encumbrance_type%TYPE,
305: p_start_dt IN igs_pe_pers_encumb.start_dt%TYPE,
306: p_expiry_dt IN igs_pe_pers_encumb.expiry_dt%TYPE,

Line 349: IF p_resp_id IS NULL OR p_fnd_user_id IS NULL OR p_person_id IS NULL OR p_encumbrance_type IS NULL OR p_start_dt IS NULL

345: IGS_GE_MSG_STACK.ADD;
346: APP_EXCEPTION.RAISE_EXCEPTION;
347: END IF;
348: ELSE
349: IF p_resp_id IS NULL OR p_fnd_user_id IS NULL OR p_person_id IS NULL OR p_encumbrance_type IS NULL OR p_start_dt IS NULL
350: OR ( p_expiry_dt IS NULL AND p_comments IS NULL ) THEN
351: p_message_name := 'IGS_AD_INVALID_PARAM_COMB';
352: FND_MESSAGE.SET_NAME('IGS','IGS_AD_INVALID_PARAM_COMB');
353: IGS_GE_MSG_STACK.ADD;

Line 386: p_fnd_user_id => p_fnd_user_id,

382: IF p_override_resp = 'N' THEN
383:
384: igs_pe_gen_001.validate_hold_resp
385: (p_resp_id => p_resp_id,
386: p_fnd_user_id => p_fnd_user_id,
387: p_person_id => p_person_id,
388: p_encumbrance_type => p_encumbrance_type,
389: p_start_dt => p_start_dt,
390: p_message_name => l_message_name);