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 HZ_PARTIES

Line 119: FROM hz_parties p,

115: cursor cur_deceased_hold(cp_person_id NUMBER) is
116: SELECT DECODE(pp.date_of_death, NULL,NVL(pd.deceased_ind,'N'),'Y') deceased_flag,
117: igs_en_gen_003.enrp_get_encmbrd_ind(p.party_id) encumbered_ind,
118: p.status status
119: FROM hz_parties p,
120: igs_pe_hz_parties pd,
121: hz_person_profiles pp
122: WHERE p.party_id = pp.party_id AND
123: p.party_id = pd.party_id (+) AND

Line 120: igs_pe_hz_parties pd,

116: SELECT DECODE(pp.date_of_death, NULL,NVL(pd.deceased_ind,'N'),'Y') deceased_flag,
117: igs_en_gen_003.enrp_get_encmbrd_ind(p.party_id) encumbered_ind,
118: p.status status
119: FROM hz_parties p,
120: igs_pe_hz_parties pd,
121: hz_person_profiles pp
122: WHERE p.party_id = pp.party_id AND
123: p.party_id = pd.party_id (+) AND
124: sysdate between pp.effective_start_date AND

Line 155: p_person_id OUT NOCOPY hz_parties.party_id%TYPE,

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
159: ) IS

Line 156: p_person_number OUT NOCOPY hz_parties.party_number%TYPE,

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
159: ) IS
160: /*

Line 177: CURSOR person_name_cur(cp_person_id hz_parties.party_id%TYPE) IS

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
178: SELECT person_number,full_name
179: FROM igs_pe_person_base_v
180: WHERE person_id = cp_person_id;
181:

Line 223: p_person_id IN hz_parties.party_id%TYPE,

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

Line 250: l_person_id hz_parties.party_id%TYPE;

246: start_dt = p_start_dt;
247:
248: hold_rec hold_cur%ROWTYPE;
249:
250: l_person_id hz_parties.party_id%TYPE;
251: l_person_number hz_parties.party_number%TYPE;
252: l_person_name hz_person_profiles.person_name%TYPE;
253: l_message_name fnd_new_messages.message_name%TYPE;
254:

Line 251: l_person_number hz_parties.party_number%TYPE;

247:
248: hold_rec hold_cur%ROWTYPE;
249:
250: l_person_id hz_parties.party_id%TYPE;
251: l_person_number hz_parties.party_number%TYPE;
252: l_person_name hz_person_profiles.person_name%TYPE;
253: l_message_name fnd_new_messages.message_name%TYPE;
254:
255: BEGIN

Line 303: p_person_id IN hz_parties.party_id%TYPE,

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,
307: p_override_resp IN VARCHAR2,

Line 419: p_person_id hz_parties.party_id%TYPE,

415: -- There is no exception section for this. If any error occured then that will be handled in the the respective calling procedures
416: END release_hold;
417:
418: FUNCTION Get_Res_Status (
419: p_person_id hz_parties.party_id%TYPE,
420: p_residency_class igs_pe_res_dtls_all.residency_class_cd%TYPE,
421: p_cal_type igs_ca_inst.cal_type%TYPE,
422: p_sequence_number igs_ca_inst.sequence_number%TYPE
423: ) RETURN VARCHAR2 AS

Line 435: CURSOR c_residency ( cp_person_id hz_parties.party_id%TYPE,

431: || Who When What
432: || (reverse chronological order - newest change first)
433: || vskumar 25-May-2006 Xbuild3 performance fix. Replace c_gap_res cursor query.
434: */
435: CURSOR c_residency ( cp_person_id hz_parties.party_id%TYPE,
436: cp_residency_class igs_pe_res_dtls_all.residency_class_cd%TYPE,
437: cp_cal_type igs_ca_inst.cal_type%TYPE,
438: cp_sequence_number igs_ca_inst.sequence_number%TYPE
439: ) IS

Line 458: CURSOR c_gap_res ( cp_person_id hz_parties.party_id%TYPE,

454: cal.sequence_number = cp_sequence_number;
455: ca_rec c_ca%ROWTYPE;
456:
457:
458: CURSOR c_gap_res ( cp_person_id hz_parties.party_id%TYPE,
459: cp_residency_class igs_pe_res_dtls_all.residency_class_cd%TYPE,
460: cp_start_dt DATE) IS
461: SELECT res.residency_status_cd, ci.start_dt
462: FROM igs_pe_res_dtls_all res,IGS_CA_INST_ALL ci

Line 600: FUNCTION Get_Hold_Count (p_person_id IN hz_parties.party_id%TYPE )

596: END GET_SS_PRIVACY_LVL;
597:
598:
599:
600: FUNCTION Get_Hold_Count (p_person_id IN hz_parties.party_id%TYPE )
601: RETURN NUMBER AS
602: /*
603: || Created By : ssawhney
604: || Created On : 27-SEP-2002

Line 613: (cp_person_id IN hz_parties.party_id%TYPE,

609: -- future dated holds are NOT active as of sysdate.
610: -- and holds are not valid as on the expiry date...so we need the exp_dt -1 logic.
611:
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