eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PE_GEN_001 dependencies on IGS_PE_PERS_ENCUMB

Line 224: p_encumbrance_type IN igs_pe_pers_encumb.encumbrance_type%TYPE,

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
227: ) IS
228: /*

Line 225: p_start_dt IN igs_pe_pers_encumb.start_dt%TYPE,

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
227: ) IS
228: /*
229: || Created By : pkpatel

Line 243: FROM igs_pe_pers_encumb

239: || (reverse chronological order - newest change first)
240: */
241: CURSOR hold_cur IS
242: SELECT auth_resp_id
243: FROM igs_pe_pers_encumb
244: WHERE person_id = p_person_id AND
245: encumbrance_type = p_encumbrance_type AND
246: start_dt = p_start_dt;
247:

Line 304: p_encumbrance_type IN igs_pe_pers_encumb.encumbrance_type%TYPE,

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,
307: p_override_resp IN VARCHAR2,
308: p_comments IN igs_pe_pers_encumb.comments%TYPE,

Line 305: p_start_dt IN igs_pe_pers_encumb.start_dt%TYPE,

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,
307: p_override_resp IN VARCHAR2,
308: p_comments IN igs_pe_pers_encumb.comments%TYPE,
309: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE

Line 306: p_expiry_dt IN igs_pe_pers_encumb.expiry_dt%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,
307: p_override_resp IN VARCHAR2,
308: p_comments IN igs_pe_pers_encumb.comments%TYPE,
309: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE
310: ) IS

Line 308: p_comments IN igs_pe_pers_encumb.comments%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,
307: p_override_resp IN VARCHAR2,
308: p_comments IN igs_pe_pers_encumb.comments%TYPE,
309: p_message_name OUT NOCOPY fnd_new_messages.message_name%TYPE
310: ) IS
311: /*
312: || Created By : pkpatel

Line 326: || Replaced the message IGS_PE_NOT_REL_HOLD with IGS_PE_CANT_REL_HOLD,IGS_PE_PERS_ENCUMB_NOTEXIST

322: || pkpatel 5-FEB-2003 Bug 2683186
323: || Passed proper value to the out parameter p_message_name
324: || ssawhney 17-feb-2003 Bug 2758856 - external holds new validations
325: || pkpatel 8-APR-2003 Bug 2804863
326: || Replaced the message IGS_PE_NOT_REL_HOLD with IGS_PE_CANT_REL_HOLD,IGS_PE_PERS_ENCUMB_NOTEXIST
327: */
328:
329: CURSOR hold_cur IS
330: SELECT ROWID,pen.*

Line 331: FROM igs_pe_pers_encumb pen

327: */
328:
329: CURSOR hold_cur IS
330: SELECT ROWID,pen.*
331: FROM igs_pe_pers_encumb pen
332: WHERE pen.person_id = p_person_id AND
333: pen.encumbrance_type = p_encumbrance_type AND
334: pen.start_dt = p_start_dt;
335:

Line 363: p_message_name := 'IGS_PE_PERS_ENCUMB_NOTEXIST';

359: OPEN hold_cur;
360: FETCH hold_cur INTO hold_rec;
361: IF hold_cur%NOTFOUND THEN
362: CLOSE hold_cur;
363: p_message_name := 'IGS_PE_PERS_ENCUMB_NOTEXIST';
364: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PERS_ENCUMB_NOTEXIST');
365: IGS_GE_MSG_STACK.ADD;
366: APP_EXCEPTION.RAISE_EXCEPTION;
367: ELSE

Line 364: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PERS_ENCUMB_NOTEXIST');

360: FETCH hold_cur INTO hold_rec;
361: IF hold_cur%NOTFOUND THEN
362: CLOSE hold_cur;
363: p_message_name := 'IGS_PE_PERS_ENCUMB_NOTEXIST';
364: FND_MESSAGE.SET_NAME('IGS','IGS_PE_PERS_ENCUMB_NOTEXIST');
365: IGS_GE_MSG_STACK.ADD;
366: APP_EXCEPTION.RAISE_EXCEPTION;
367: ELSE
368: -- if cursor found, and external hold is NOT NULL then raise error

Line 401: igs_pe_pers_encumb_pkg.update_row(

397: END IF;
398: END IF;
399:
400:
401: igs_pe_pers_encumb_pkg.update_row(
402: x_rowid => hold_rec.rowid ,
403: x_person_id => hold_rec.person_id,
404: x_encumbrance_type => hold_rec.encumbrance_type ,
405: x_start_dt => hold_rec.start_dt,

Line 616: FROM IGS_PE_PERS_ENCUMB

612: CURSOR c_prsn_encumb_cnt
613: (cp_person_id IN hz_parties.party_id%TYPE,
614: cp_sysdate DATE) IS
615: SELECT count(*)
616: FROM IGS_PE_PERS_ENCUMB
617: WHERE person_id = cp_person_id AND
618: (cp_sysdate BETWEEN start_dt AND (expiry_dt - 1) OR
619: (expiry_dt IS NULL AND start_dt <= cp_sysdate));
620: