DBA Data[Home] [Help]

APPS.IGS_PE_PERS_ENCUMB_PKG dependencies on IGS_PE_GEN_001

Line 100: PKPATEL 8-APR-2003 Bug No: 2804863, Added the check with igs_pe_gen_001.g_hold_validation for calling

96: Change History
97:
98: Bug ID : 2000408
99: who when what
100: PKPATEL 8-APR-2003 Bug No: 2804863, Added the check with igs_pe_gen_001.g_hold_validation for calling
101: igs_pe_gen_001.get_hold_auth
102: Added system_type_rec.s_encumbrance_cat = 'ACADEMIC' check to validate staff and person ID.
103: vkarthik 16-Jul-2004 Added validation on hold start date and hold expiry date as part of Bug 3771317
104: ------------------------------------------------------------------*/

Line 101: igs_pe_gen_001.get_hold_auth

97:
98: Bug ID : 2000408
99: who when what
100: PKPATEL 8-APR-2003 Bug No: 2804863, Added the check with igs_pe_gen_001.g_hold_validation for calling
101: igs_pe_gen_001.get_hold_auth
102: Added system_type_rec.s_encumbrance_cat = 'ACADEMIC' check to validate staff and person ID.
103: vkarthik 16-Jul-2004 Added validation on hold start date and hold expiry date as part of Bug 3771317
104: ------------------------------------------------------------------*/
105: CURSOR cur_hold_ovr IS

Line 173: IF igs_pe_gen_001.g_hold_validation = 'Y' THEN

169:
170: --KUMMA, 2758856, Added the condititon to check for the external_reference also.
171: IF system_type_rec.s_encumbrance_cat = 'ADMIN' AND new_references.external_reference IS NULL THEN
172:
173: IF igs_pe_gen_001.g_hold_validation = 'Y' THEN
174:
175: igs_pe_gen_001.get_hold_auth(l_fnd_user_id,
176: l_person_id,
177: l_person_number,

Line 175: igs_pe_gen_001.get_hold_auth(l_fnd_user_id,

171: IF system_type_rec.s_encumbrance_cat = 'ADMIN' AND new_references.external_reference IS NULL THEN
172:
173: IF igs_pe_gen_001.g_hold_validation = 'Y' THEN
174:
175: igs_pe_gen_001.get_hold_auth(l_fnd_user_id,
176: l_person_id,
177: l_person_number,
178: l_person_name,
179: v_message_name);

Line 249: -- Validation is done only for ACADEMIC holds. ADMIN hold this validation is done in the igs_pe_gen_001.get_hold_auth procedure.

245: END IF;
246:
247: -- Validate Encumbrance Authorising IGS_PE_PERSON Id.
248: -- Validate that the authorising person_id is valid and is a staff member.
249: -- Validation is done only for ACADEMIC holds. ADMIN hold this validation is done in the igs_pe_gen_001.get_hold_auth procedure.
250: IF system_type_rec.s_encumbrance_cat = 'ACADEMIC' AND
251: (new_references.authorising_person_id IS NOT NULL) AND
252: (p_inserting OR
253: ( p_updating AND (new_references.authorising_person_id <> NVL(old_references.authorising_person_id,-1))))