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_002 dependencies on IGS_PE_PERS_ENCUMB

Line 23: P_ENCUMBRANCE_TYPE IN igs_pe_pers_encumb.encumbrance_type%TYPE,

19: || (reverse chronological order - newest change first)
20: */
21:
22: (P_PERSON_ID IN hz_parties.party_id%TYPE,
23: P_ENCUMBRANCE_TYPE IN igs_pe_pers_encumb.encumbrance_type%TYPE,
24: P_START_DT IN Date,
25: P_END_DT IN Date,
26: P_AUTHORISING_PERSON_ID IN hz_parties.party_id%TYPE,
27: P_COMMENTS IN igs_pe_pers_encumb.comments%TYPE,

Line 27: P_COMMENTS IN igs_pe_pers_encumb.comments%TYPE,

23: P_ENCUMBRANCE_TYPE IN igs_pe_pers_encumb.encumbrance_type%TYPE,
24: P_START_DT IN Date,
25: P_END_DT IN Date,
26: P_AUTHORISING_PERSON_ID IN hz_parties.party_id%TYPE,
27: P_COMMENTS IN igs_pe_pers_encumb.comments%TYPE,
28: P_SPO_COURSE_CD IN igs_pe_pers_encumb.spo_course_cd%TYPE,
29: P_SPO_SEQUENCE_NUMBER IN igs_pe_pers_encumb.spo_sequence_number%TYPE,
30: P_CAL_TYPE IN igs_pe_pers_encumb.cal_type%TYPE,
31: P_SEQUENCE_NUMBER IN igs_pe_pers_encumb.sequence_number%TYPE,

Line 28: P_SPO_COURSE_CD IN igs_pe_pers_encumb.spo_course_cd%TYPE,

24: P_START_DT IN Date,
25: P_END_DT IN Date,
26: P_AUTHORISING_PERSON_ID IN hz_parties.party_id%TYPE,
27: P_COMMENTS IN igs_pe_pers_encumb.comments%TYPE,
28: P_SPO_COURSE_CD IN igs_pe_pers_encumb.spo_course_cd%TYPE,
29: P_SPO_SEQUENCE_NUMBER IN igs_pe_pers_encumb.spo_sequence_number%TYPE,
30: P_CAL_TYPE IN igs_pe_pers_encumb.cal_type%TYPE,
31: P_SEQUENCE_NUMBER IN igs_pe_pers_encumb.sequence_number%TYPE,
32: P_AUTH_RESP_ID IN igs_pe_pers_encumb.auth_resp_id%TYPE,

Line 29: P_SPO_SEQUENCE_NUMBER IN igs_pe_pers_encumb.spo_sequence_number%TYPE,

25: P_END_DT IN Date,
26: P_AUTHORISING_PERSON_ID IN hz_parties.party_id%TYPE,
27: P_COMMENTS IN igs_pe_pers_encumb.comments%TYPE,
28: P_SPO_COURSE_CD IN igs_pe_pers_encumb.spo_course_cd%TYPE,
29: P_SPO_SEQUENCE_NUMBER IN igs_pe_pers_encumb.spo_sequence_number%TYPE,
30: P_CAL_TYPE IN igs_pe_pers_encumb.cal_type%TYPE,
31: P_SEQUENCE_NUMBER IN igs_pe_pers_encumb.sequence_number%TYPE,
32: P_AUTH_RESP_ID IN igs_pe_pers_encumb.auth_resp_id%TYPE,
33: P_EXTERNAL_REFERENCE IN igs_pe_pers_encumb.external_reference%TYPE,

Line 30: P_CAL_TYPE IN igs_pe_pers_encumb.cal_type%TYPE,

26: P_AUTHORISING_PERSON_ID IN hz_parties.party_id%TYPE,
27: P_COMMENTS IN igs_pe_pers_encumb.comments%TYPE,
28: P_SPO_COURSE_CD IN igs_pe_pers_encumb.spo_course_cd%TYPE,
29: P_SPO_SEQUENCE_NUMBER IN igs_pe_pers_encumb.spo_sequence_number%TYPE,
30: P_CAL_TYPE IN igs_pe_pers_encumb.cal_type%TYPE,
31: P_SEQUENCE_NUMBER IN igs_pe_pers_encumb.sequence_number%TYPE,
32: P_AUTH_RESP_ID IN igs_pe_pers_encumb.auth_resp_id%TYPE,
33: P_EXTERNAL_REFERENCE IN igs_pe_pers_encumb.external_reference%TYPE,
34: P_MESSAGE_NAME OUT NOCOPY varchar2,

Line 31: P_SEQUENCE_NUMBER IN igs_pe_pers_encumb.sequence_number%TYPE,

27: P_COMMENTS IN igs_pe_pers_encumb.comments%TYPE,
28: P_SPO_COURSE_CD IN igs_pe_pers_encumb.spo_course_cd%TYPE,
29: P_SPO_SEQUENCE_NUMBER IN igs_pe_pers_encumb.spo_sequence_number%TYPE,
30: P_CAL_TYPE IN igs_pe_pers_encumb.cal_type%TYPE,
31: P_SEQUENCE_NUMBER IN igs_pe_pers_encumb.sequence_number%TYPE,
32: P_AUTH_RESP_ID IN igs_pe_pers_encumb.auth_resp_id%TYPE,
33: P_EXTERNAL_REFERENCE IN igs_pe_pers_encumb.external_reference%TYPE,
34: P_MESSAGE_NAME OUT NOCOPY varchar2,
35: P_MESSAGE_STRING OUT NOCOPY Varchar2

Line 32: P_AUTH_RESP_ID IN igs_pe_pers_encumb.auth_resp_id%TYPE,

28: P_SPO_COURSE_CD IN igs_pe_pers_encumb.spo_course_cd%TYPE,
29: P_SPO_SEQUENCE_NUMBER IN igs_pe_pers_encumb.spo_sequence_number%TYPE,
30: P_CAL_TYPE IN igs_pe_pers_encumb.cal_type%TYPE,
31: P_SEQUENCE_NUMBER IN igs_pe_pers_encumb.sequence_number%TYPE,
32: P_AUTH_RESP_ID IN igs_pe_pers_encumb.auth_resp_id%TYPE,
33: P_EXTERNAL_REFERENCE IN igs_pe_pers_encumb.external_reference%TYPE,
34: P_MESSAGE_NAME OUT NOCOPY varchar2,
35: P_MESSAGE_STRING OUT NOCOPY Varchar2
36: ) IS

Line 33: P_EXTERNAL_REFERENCE IN igs_pe_pers_encumb.external_reference%TYPE,

29: P_SPO_SEQUENCE_NUMBER IN igs_pe_pers_encumb.spo_sequence_number%TYPE,
30: P_CAL_TYPE IN igs_pe_pers_encumb.cal_type%TYPE,
31: P_SEQUENCE_NUMBER IN igs_pe_pers_encumb.sequence_number%TYPE,
32: P_AUTH_RESP_ID IN igs_pe_pers_encumb.auth_resp_id%TYPE,
33: P_EXTERNAL_REFERENCE IN igs_pe_pers_encumb.external_reference%TYPE,
34: P_MESSAGE_NAME OUT NOCOPY varchar2,
35: P_MESSAGE_STRING OUT NOCOPY Varchar2
36: ) IS
37:

Line 56: igs_pe_pers_encumb_pkg.insert_row

52: SAVEPOINT hold_insert;
53:
54: -- issue a savepoint and start the insertion directly.
55:
56: igs_pe_pers_encumb_pkg.insert_row
57: (
58: x_mode => 'R' ,
59: x_rowid => l_rowid ,
60: x_person_id => p_person_id ,

Line 240: -- change view IGS_PE_PERS_ENCUMB from igs_pe_pers_pen_encumb_v

236: encumbrance_type = cp_encumbrance_type AND
237: s_encumbrance_cat = 'ADMIN';
238:
239: -- check whether release hold should be called or apply hold should be called
240: -- change view IGS_PE_PERS_ENCUMB from igs_pe_pers_pen_encumb_v
241: CURSOR c_hold_alrdy_exst(cp_person_id igs_pe_person_base_v.person_id%TYPE,
242: cp_encumbrance_type igs_pe_pers_encumb_v.encumbrance_type%TYPE,
243: cp_start_dt DATE) IS
244: SELECT

Line 242: cp_encumbrance_type igs_pe_pers_encumb_v.encumbrance_type%TYPE,

238:
239: -- check whether release hold should be called or apply hold should be called
240: -- change view IGS_PE_PERS_ENCUMB from igs_pe_pers_pen_encumb_v
241: CURSOR c_hold_alrdy_exst(cp_person_id igs_pe_person_base_v.person_id%TYPE,
242: cp_encumbrance_type igs_pe_pers_encumb_v.encumbrance_type%TYPE,
243: cp_start_dt DATE) IS
244: SELECT
245: expiry_dt
246: FROM

Line 247: IGS_PE_PERS_ENCUMB

243: cp_start_dt DATE) IS
244: SELECT
245: expiry_dt
246: FROM
247: IGS_PE_PERS_ENCUMB
248: WHERE
249: person_id = cp_person_id AND
250: encumbrance_type = cp_encumbrance_type AND
251: start_dt = cp_start_dt;

Line 256: cp_encumbrance_type igs_pe_pers_encumb_v.encumbrance_type%TYPE,

252:
253: -- check for mismatch of external ref passed
254: -- remove reference to the view.
255: CURSOR c_external_hold_exst(cp_person_id igs_pe_person_base_v.person_id%TYPE,
256: cp_encumbrance_type igs_pe_pers_encumb_v.encumbrance_type%TYPE,
257: cp_start_dt DATE,
258: cp_external_reference igs_pe_pers_encumb_v.external_reference%TYPE) IS
259: SELECT
260: 'X'

Line 258: cp_external_reference igs_pe_pers_encumb_v.external_reference%TYPE) IS

254: -- remove reference to the view.
255: CURSOR c_external_hold_exst(cp_person_id igs_pe_person_base_v.person_id%TYPE,
256: cp_encumbrance_type igs_pe_pers_encumb_v.encumbrance_type%TYPE,
257: cp_start_dt DATE,
258: cp_external_reference igs_pe_pers_encumb_v.external_reference%TYPE) IS
259: SELECT
260: 'X'
261: FROM
262: igs_pe_pers_encumb

Line 262: igs_pe_pers_encumb

258: cp_external_reference igs_pe_pers_encumb_v.external_reference%TYPE) IS
259: SELECT
260: 'X'
261: FROM
262: igs_pe_pers_encumb
263: WHERE
264: person_id = cp_person_id AND
265: encumbrance_type = cp_encumbrance_type AND
266: start_dt = cp_start_dt AND

Line 270: CURSOR c_hold_eff(cp_hold_type igs_pe_pers_encumb_v.encumbrance_type%TYPE) IS

266: start_dt = cp_start_dt AND
267: external_reference = cp_external_reference;
268:
269: -- cursor to check if the hold has an effect of SUS_COURSE.
270: CURSOR c_hold_eff(cp_hold_type igs_pe_pers_encumb_v.encumbrance_type%TYPE) IS
271: SELECT 'X'
272: FROM igs_fi_enc_dflt_eft
273: WHERE encumbrance_type = cp_hold_type AND
274: s_encmb_effect_type = 'SUS_COURSE';

Line 282: l_hold_type igs_pe_pers_encumb.encumbrance_type%TYPE;

278: l_exist_exp_dt DATE;
279: l_exist VARCHAR2(1);
280: ln_msg_index NUMBER;
281: l_person_number VARCHAR2(30);
282: l_hold_type igs_pe_pers_encumb.encumbrance_type%TYPE;
283: l_start_dt VARCHAR2(30);
284: l_d_start_dt DATE := NULL;
285:
286: l_expiry_date VARCHAR2(30);

Line 289: l_external_ref igs_pe_pers_encumb.external_reference%TYPE;

285:
286: l_expiry_date VARCHAR2(30);
287: l_d_expiry_date DATE := NULL;
288:
289: l_external_ref igs_pe_pers_encumb.external_reference%TYPE;
290: l_admin fnd_user.user_name%TYPE;
291: l_person_name igs_pe_person_base_v.full_name%TYPE;
292:
293: