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_EN_GEN_012 dependencies on IGS_PE_PERSENC_EFFCT

Line 88: SELECT ROWID, IGS_PE_PERSENC_EFFCT.*

84: cp_person_id IGS_PE_PERS_ENCUMB.person_id%TYPE,
85: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
86: cp_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
87: cp_expiry_dt IGS_PE_PERS_ENCUMB.expiry_dt%TYPE) IS
88: SELECT ROWID, IGS_PE_PERSENC_EFFCT.*
89: FROM IGS_PE_PERSENC_EFFCT
90: WHERE person_id = cp_person_id AND
91: encumbrance_type = cp_encumbrance_type AND
92: pen_start_dt = cp_start_dt AND

Line 89: FROM IGS_PE_PERSENC_EFFCT

85: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
86: cp_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
87: cp_expiry_dt IGS_PE_PERS_ENCUMB.expiry_dt%TYPE) IS
88: SELECT ROWID, IGS_PE_PERSENC_EFFCT.*
89: FROM IGS_PE_PERSENC_EFFCT
90: WHERE person_id = cp_person_id AND
91: encumbrance_type = cp_encumbrance_type AND
92: pen_start_dt = cp_start_dt AND
93: (expiry_dt IS NULL OR

Line 95: FOR UPDATE OF IGS_PE_PERSENC_EFFCT.person_id NOWAIT;

91: encumbrance_type = cp_encumbrance_type AND
92: pen_start_dt = cp_start_dt AND
93: (expiry_dt IS NULL OR
94: expiry_dt > cp_expiry_dt)
95: FOR UPDATE OF IGS_PE_PERSENC_EFFCT.person_id NOWAIT;
96:
97:
98: CURSOR c_psn_crs_grp_excl (
99: cp_person_id IGS_PE_PERS_ENCUMB.person_id%TYPE,

Line 105: IGS_PE_PERSENC_EFFCT PEE

101: cp_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
102: cp_expiry_dt IGS_PE_PERS_ENCUMB.expiry_dt%TYPE) IS
103: SELECT PCGE.ROWID, PCGE.*
104: FROM IGS_PE_CRS_GRP_EXCL PCGE,
105: IGS_PE_PERSENC_EFFCT PEE
106: WHERE PCGE.person_id = cp_person_id AND
107: PCGE.encumbrance_type = cp_encumbrance_type AND
108: PCGE.pen_start_dt = cp_start_dt AND
109: PCGE.s_encmb_effect_type = PEE.s_encmb_effect_type AND

Line 123: IGS_PE_PERSENC_EFFCT PEE

119: cp_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
120: cp_expiry_dt IGS_PE_PERS_ENCUMB.expiry_dt%TYPE) IS
121: SELECT PCE.ROWID, PCE.*
122: FROM IGS_PE_COURSE_EXCL PCE,
123: IGS_PE_PERSENC_EFFCT PEE
124: WHERE PCE.person_id = cp_person_id AND
125: PCE.encumbrance_type = cp_encumbrance_type AND
126: PCE.pen_start_dt = cp_start_dt AND
127: PCE.s_encmb_effect_type = PEE.s_encmb_effect_type AND

Line 142: IGS_PE_PERSENC_EFFCT PEE

138: cp_expiry_dt IGS_PE_PERS_ENCUMB.expiry_dt%TYPE) IS
139: SELECT PUE.ROWID,
140: PUE.*
141: FROM IGS_PE_PERS_UNT_EXCL PUE,
142: IGS_PE_PERSENC_EFFCT PEE
143: WHERE PUE.person_id = cp_person_id AND
144: PUE.encumbrance_type = cp_encumbrance_type AND
145: PUE.pen_start_dt = cp_start_dt AND
146: PUE.s_encmb_effect_type = PEE.s_encmb_effect_type AND

Line 161: IGS_PE_PERSENC_EFFCT PEE

157: cp_expiry_dt IGS_PE_PERS_ENCUMB.expiry_dt%TYPE) IS
158: SELECT PUR.ROWID,
159: PUR.*
160: FROM IGS_PE_UNT_REQUIRMNT PUR,
161: IGS_PE_PERSENC_EFFCT PEE
162: WHERE PUR.person_id = cp_person_id AND
163: PUR.encumbrance_type = cp_encumbrance_type AND
164: PUR.pen_start_dt = cp_start_dt AND
165: PUR.s_encmb_effect_type = PEE.s_encmb_effect_type AND

Line 179: IGS_PE_PERSENC_EFFCT PEE

175: cp_expiry_dt IGS_PE_PERS_ENCUMB.expiry_dt%TYPE) IS
176: SELECT fun.ROWID,
177: fun.*
178: FROM IGS_PE_FUND_EXCL fun,
179: IGS_PE_PERSENC_EFFCT PEE
180: WHERE fun.person_id = cp_person_id AND
181: fun.encumbrance_type = cp_encumbrance_type AND
182: fun.pen_start_dt = cp_start_dt AND
183: fun.s_encmb_effect_type = PEE.s_encmb_effect_type AND

Line 202: -- for each IGS_PE_PERSENC_EFFCT record returned,

198: FOR v_psn_encmb_eff_rec IN c_psn_encmb_eff(p_person_id,
199: p_encumbrance_type,
200: p_start_dt,
201: p_expiry_dt) LOOP
202: -- for each IGS_PE_PERSENC_EFFCT record returned,
203: -- update the expiry_dt
204:
205:
206: IF (v_psn_encmb_eff_rec.pee_start_dt > p_expiry_dt) THEN

Line 208: Igs_Pe_Persenc_Effct_Pkg.UPDATE_ROW(

204:
205:
206: IF (v_psn_encmb_eff_rec.pee_start_dt > p_expiry_dt) THEN
207:
208: Igs_Pe_Persenc_Effct_Pkg.UPDATE_ROW(
209: X_ROWID => v_psn_encmb_eff_rec.ROWID ,
210: X_PERSON_ID => v_psn_encmb_eff_rec.PERSON_ID ,
211: X_ENCUMBRANCE_TYPE => v_psn_encmb_eff_rec.ENCUMBRANCE_TYPE ,
212: X_PEN_START_DT => v_psn_encmb_eff_rec.PEN_START_DT ,

Line 226: Igs_Pe_Persenc_Effct_Pkg.UPDATE_ROW(

222:
223:
224: ELSE
225:
226: Igs_Pe_Persenc_Effct_Pkg.UPDATE_ROW(
227: X_ROWID => v_psn_encmb_eff_rec.ROWID ,
228: X_PERSON_ID => v_psn_encmb_eff_rec.PERSON_ID ,
229: X_ENCUMBRANCE_TYPE => v_psn_encmb_eff_rec.ENCUMBRANCE_TYPE ,
230: X_PEN_START_DT => v_psn_encmb_eff_rec.PEN_START_DT ,