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_SET_REM_HOLDS dependencies on IGS_PE_PERS_ENCUMB_V

Line 98: p_hold_type IN igs_pe_pers_encumb_v.encumbrance_type%TYPE ,

94: END log_messages ;
95:
96: PROCEDURE set_prsid_grp_holds ( errbuf OUT NOCOPY VARCHAR2 ,
97: retcode OUT NOCOPY NUMBER ,
98: p_hold_type IN igs_pe_pers_encumb_v.encumbrance_type%TYPE ,
99: p_pid_group IN igs_pe_persid_group_v.group_id%TYPE ,
100: p_start_dt IN VARCHAR2 ,
101: p_term IN VARCHAR2 ,
102: p_org_id IN NUMBER

Line 346: p_hold_type IN igs_pe_pers_encumb_v.encumbrance_type%TYPE ,

342:
343:
344: PROCEDURE rel_prsid_grp_holds ( errbuf OUT NOCOPY VARCHAR2 ,
345: retcode OUT NOCOPY NUMBER ,
346: p_hold_type IN igs_pe_pers_encumb_v.encumbrance_type%TYPE ,
347: p_pid_group IN igs_pe_persid_group_v.group_id%TYPE ,
348: p_start_dt IN VARCHAR2 ,
349: p_expiry_dt IN VARCHAR2 ,
350: p_term IN VARCHAR2 ,

Line 397: CURSOR c_igs_pe_pers_encumb(cp_person_id igs_pe_pers_encumb_v.person_id%TYPE ,

393: l_person_name hz_person_profiles.person_name%TYPE;
394:
395:
396: -- cursor selects row_id from igs_pe_pers_encumb table based on person id and hold type
397: CURSOR c_igs_pe_pers_encumb(cp_person_id igs_pe_pers_encumb_v.person_id%TYPE ,
398: cp_hold_type igs_pe_pers_encumb_v.encumbrance_type%TYPE ,
399: cp_start_dt igs_pe_pers_encumb_v.start_dt%TYPE) IS
400: SELECT *
401: FROM IGS_PE_PERS_ENCUMB

Line 398: cp_hold_type igs_pe_pers_encumb_v.encumbrance_type%TYPE ,

394:
395:
396: -- cursor selects row_id from igs_pe_pers_encumb table based on person id and hold type
397: CURSOR c_igs_pe_pers_encumb(cp_person_id igs_pe_pers_encumb_v.person_id%TYPE ,
398: cp_hold_type igs_pe_pers_encumb_v.encumbrance_type%TYPE ,
399: cp_start_dt igs_pe_pers_encumb_v.start_dt%TYPE) IS
400: SELECT *
401: FROM IGS_PE_PERS_ENCUMB
402: WHERE person_id = cp_person_id

Line 399: cp_start_dt igs_pe_pers_encumb_v.start_dt%TYPE) IS

395:
396: -- cursor selects row_id from igs_pe_pers_encumb table based on person id and hold type
397: CURSOR c_igs_pe_pers_encumb(cp_person_id igs_pe_pers_encumb_v.person_id%TYPE ,
398: cp_hold_type igs_pe_pers_encumb_v.encumbrance_type%TYPE ,
399: cp_start_dt igs_pe_pers_encumb_v.start_dt%TYPE) IS
400: SELECT *
401: FROM IGS_PE_PERS_ENCUMB
402: WHERE person_id = cp_person_id
403: AND encumbrance_type = cp_hold_type