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_SPI_LGCY_PUB dependencies on IGS_EN_STDNT_PS_INTM

Line 56: igs_en_stdnt_ps_intm_pkg.check_constraints ('COURSE_CD', p_intermiss_rec.program_cd);

52: FND_MSG_PUB.ADD;
53: l_valid_params := FALSE;
54: ELSE
55: BEGIN
56: igs_en_stdnt_ps_intm_pkg.check_constraints ('COURSE_CD', p_intermiss_rec.program_cd);
57: EXCEPTION
58: WHEN OTHERS THEN
59: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,
60: p_data => l_msg_data);

Line 89: igs_en_stdnt_ps_intm_pkg.check_constraints ('VOLUNTARY_IND', p_intermiss_rec.voluntary_ind);

85:
86: -- Check whether voluntary_ind is having any other value other than 'Y'/'N'
87: IF p_intermiss_rec.voluntary_ind IS NOT NULL THEN
88: BEGIN
89: igs_en_stdnt_ps_intm_pkg.check_constraints ('VOLUNTARY_IND', p_intermiss_rec.voluntary_ind);
90: EXCEPTION
91: WHEN OTHERS THEN
92: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,
93: p_data => l_msg_data);

Line 114: igs_en_stdnt_ps_intm_pkg.check_constraints ('APPROVED', p_intermiss_rec.approved);

110:
111: -- Check whether approved field is having any other value other than 'Y'/'N'
112: IF p_intermiss_rec.approved IS NOT NULL THEN
113: BEGIN
114: igs_en_stdnt_ps_intm_pkg.check_constraints ('APPROVED', p_intermiss_rec.approved);
115: EXCEPTION
116: WHEN OTHERS THEN
117: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,
118: p_data => l_msg_data);

Line 192: p_person_id IN igs_en_stdnt_ps_intm.person_id%TYPE,

188:
189: END validate_parameter;
190:
191: FUNCTION validate_db_cons (
192: p_person_id IN igs_en_stdnt_ps_intm.person_id%TYPE,
193: p_intermiss_rec IN en_spi_rec_type
194: ) RETURN VARCHAR2 AS
195:
196: /**********************************************************************************************

Line 204: igs_en_stdnt_ps_intm_pkg.get_pk_for_validation.

200: Known limitations,enhancements,remarks:
201: Change History
202: Who When What
203: bdeviset 13-SEP-2004 Bug no 3885804.Added parameter logical_delete_date in the call
204: igs_en_stdnt_ps_intm_pkg.get_pk_for_validation.
205: ***********************************************************************************************/
206:
207: l_valid_db_constr BOOLEAN := TRUE;
208: l_logical_delete_date igs_en_stdnt_ps_intm.logical_delete_date%TYPE;

Line 208: l_logical_delete_date igs_en_stdnt_ps_intm.logical_delete_date%TYPE;

204: igs_en_stdnt_ps_intm_pkg.get_pk_for_validation.
205: ***********************************************************************************************/
206:
207: l_valid_db_constr BOOLEAN := TRUE;
208: l_logical_delete_date igs_en_stdnt_ps_intm.logical_delete_date%TYPE;
209:
210: BEGIN
211:
212: -- Check for primary Key validation. If validation fails, stop the processing and return back

Line 215: IF igs_en_stdnt_ps_intm_pkg.get_pk_for_validation ( p_person_id, p_intermiss_rec.program_cd, p_intermiss_rec.start_dt,l_logical_delete_date) THEN

211:
212: -- Check for primary Key validation. If validation fails, stop the processing and return back
213: -- to the calling procedure.
214: l_logical_delete_date := to_date('31-12-4712','DD-MM-YYYY');
215: IF igs_en_stdnt_ps_intm_pkg.get_pk_for_validation ( p_person_id, p_intermiss_rec.program_cd, p_intermiss_rec.start_dt,l_logical_delete_date) THEN
216: FND_MESSAGE.SET_NAME('IGS','IGS_EN_STU_INTM_EXISTS');
217: FND_MSG_PUB.ADD;
218: RETURN 'W';
219: END IF;

Line 258: p_person_id IN igs_en_stdnt_ps_intm.person_id%TYPE,

254: END validate_db_cons;
255:
256:
257: FUNCTION validate_stu_intm (
258: p_person_id IN igs_en_stdnt_ps_intm.person_id%TYPE,
259: p_intermiss_rec IN en_spi_rec_type,
260: p_approver_id IN igs_en_stdnt_ps_intm.approver_id%TYPE
261: ) RETURN BOOLEAN AS
262:

Line 260: p_approver_id IN igs_en_stdnt_ps_intm.approver_id%TYPE

256:
257: FUNCTION validate_stu_intm (
258: p_person_id IN igs_en_stdnt_ps_intm.person_id%TYPE,
259: p_intermiss_rec IN en_spi_rec_type,
260: p_approver_id IN igs_en_stdnt_ps_intm.approver_id%TYPE
261: ) RETURN BOOLEAN AS
262:
263: /**********************************************************************************************
264: Created By : pradhakr

Line 376: l_person_id igs_en_stdnt_ps_intm.person_id%TYPE;

372: Change History
373: Who When What
374: ***********************************************************************************************/
375:
376: l_person_id igs_en_stdnt_ps_intm.person_id%TYPE;
377: l_approver_person_id igs_en_stdnt_ps_intm.approver_id%TYPE;
378: p_course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE;
379: l_insert_flag BOOLEAN := TRUE;
380: l_ret_val VARCHAR2(1);

Line 377: l_approver_person_id igs_en_stdnt_ps_intm.approver_id%TYPE;

373: Who When What
374: ***********************************************************************************************/
375:
376: l_person_id igs_en_stdnt_ps_intm.person_id%TYPE;
377: l_approver_person_id igs_en_stdnt_ps_intm.approver_id%TYPE;
378: p_course_attempt_status igs_en_stdnt_ps_att_all.course_attempt_status%TYPE;
379: l_insert_flag BOOLEAN := TRUE;
380: l_ret_val VARCHAR2(1);
381: l_api_name CONSTANT VARCHAR2(30) := 'create_student_intm';

Line 383: l_creation_date igs_en_stdnt_ps_intm.creation_date%TYPE;

379: l_insert_flag BOOLEAN := TRUE;
380: l_ret_val VARCHAR2(1);
381: l_api_name CONSTANT VARCHAR2(30) := 'create_student_intm';
382: l_api_version CONSTANT NUMBER := 1.0;
383: l_creation_date igs_en_stdnt_ps_intm.creation_date%TYPE;
384: l_last_update_date igs_en_stdnt_ps_intm.last_update_date%TYPE;
385: l_created_by igs_en_stdnt_ps_intm.created_by%TYPE;
386: l_last_updated_by igs_en_stdnt_ps_intm.last_updated_by%TYPE;
387: l_last_update_login igs_en_stdnt_ps_intm.last_update_login%TYPE;

Line 384: l_last_update_date igs_en_stdnt_ps_intm.last_update_date%TYPE;

380: l_ret_val VARCHAR2(1);
381: l_api_name CONSTANT VARCHAR2(30) := 'create_student_intm';
382: l_api_version CONSTANT NUMBER := 1.0;
383: l_creation_date igs_en_stdnt_ps_intm.creation_date%TYPE;
384: l_last_update_date igs_en_stdnt_ps_intm.last_update_date%TYPE;
385: l_created_by igs_en_stdnt_ps_intm.created_by%TYPE;
386: l_last_updated_by igs_en_stdnt_ps_intm.last_updated_by%TYPE;
387: l_last_update_login igs_en_stdnt_ps_intm.last_update_login%TYPE;
388: l_institution_name igs_en_stdnt_ps_intm.institution_name%TYPE;

Line 385: l_created_by igs_en_stdnt_ps_intm.created_by%TYPE;

381: l_api_name CONSTANT VARCHAR2(30) := 'create_student_intm';
382: l_api_version CONSTANT NUMBER := 1.0;
383: l_creation_date igs_en_stdnt_ps_intm.creation_date%TYPE;
384: l_last_update_date igs_en_stdnt_ps_intm.last_update_date%TYPE;
385: l_created_by igs_en_stdnt_ps_intm.created_by%TYPE;
386: l_last_updated_by igs_en_stdnt_ps_intm.last_updated_by%TYPE;
387: l_last_update_login igs_en_stdnt_ps_intm.last_update_login%TYPE;
388: l_institution_name igs_en_stdnt_ps_intm.institution_name%TYPE;
389: l_max_credit_pts igs_en_stdnt_ps_intm.max_credit_pts%TYPE;

Line 386: l_last_updated_by igs_en_stdnt_ps_intm.last_updated_by%TYPE;

382: l_api_version CONSTANT NUMBER := 1.0;
383: l_creation_date igs_en_stdnt_ps_intm.creation_date%TYPE;
384: l_last_update_date igs_en_stdnt_ps_intm.last_update_date%TYPE;
385: l_created_by igs_en_stdnt_ps_intm.created_by%TYPE;
386: l_last_updated_by igs_en_stdnt_ps_intm.last_updated_by%TYPE;
387: l_last_update_login igs_en_stdnt_ps_intm.last_update_login%TYPE;
388: l_institution_name igs_en_stdnt_ps_intm.institution_name%TYPE;
389: l_max_credit_pts igs_en_stdnt_ps_intm.max_credit_pts%TYPE;
390: l_max_terms igs_en_stdnt_ps_intm.max_terms%TYPE;

Line 387: l_last_update_login igs_en_stdnt_ps_intm.last_update_login%TYPE;

383: l_creation_date igs_en_stdnt_ps_intm.creation_date%TYPE;
384: l_last_update_date igs_en_stdnt_ps_intm.last_update_date%TYPE;
385: l_created_by igs_en_stdnt_ps_intm.created_by%TYPE;
386: l_last_updated_by igs_en_stdnt_ps_intm.last_updated_by%TYPE;
387: l_last_update_login igs_en_stdnt_ps_intm.last_update_login%TYPE;
388: l_institution_name igs_en_stdnt_ps_intm.institution_name%TYPE;
389: l_max_credit_pts igs_en_stdnt_ps_intm.max_credit_pts%TYPE;
390: l_max_terms igs_en_stdnt_ps_intm.max_terms%TYPE;
391: l_anticipated_credit_points igs_en_stdnt_ps_intm.anticipated_credit_points%TYPE;

Line 388: l_institution_name igs_en_stdnt_ps_intm.institution_name%TYPE;

384: l_last_update_date igs_en_stdnt_ps_intm.last_update_date%TYPE;
385: l_created_by igs_en_stdnt_ps_intm.created_by%TYPE;
386: l_last_updated_by igs_en_stdnt_ps_intm.last_updated_by%TYPE;
387: l_last_update_login igs_en_stdnt_ps_intm.last_update_login%TYPE;
388: l_institution_name igs_en_stdnt_ps_intm.institution_name%TYPE;
389: l_max_credit_pts igs_en_stdnt_ps_intm.max_credit_pts%TYPE;
390: l_max_terms igs_en_stdnt_ps_intm.max_terms%TYPE;
391: l_anticipated_credit_points igs_en_stdnt_ps_intm.anticipated_credit_points%TYPE;
392: l_logical_delete_date igs_en_stdnt_ps_intm.logical_delete_date%TYPE;

Line 389: l_max_credit_pts igs_en_stdnt_ps_intm.max_credit_pts%TYPE;

385: l_created_by igs_en_stdnt_ps_intm.created_by%TYPE;
386: l_last_updated_by igs_en_stdnt_ps_intm.last_updated_by%TYPE;
387: l_last_update_login igs_en_stdnt_ps_intm.last_update_login%TYPE;
388: l_institution_name igs_en_stdnt_ps_intm.institution_name%TYPE;
389: l_max_credit_pts igs_en_stdnt_ps_intm.max_credit_pts%TYPE;
390: l_max_terms igs_en_stdnt_ps_intm.max_terms%TYPE;
391: l_anticipated_credit_points igs_en_stdnt_ps_intm.anticipated_credit_points%TYPE;
392: l_logical_delete_date igs_en_stdnt_ps_intm.logical_delete_date%TYPE;
393: l_cond_return_flag igs_en_stdnt_ps_intm.cond_return_flag%TYPE;

Line 390: l_max_terms igs_en_stdnt_ps_intm.max_terms%TYPE;

386: l_last_updated_by igs_en_stdnt_ps_intm.last_updated_by%TYPE;
387: l_last_update_login igs_en_stdnt_ps_intm.last_update_login%TYPE;
388: l_institution_name igs_en_stdnt_ps_intm.institution_name%TYPE;
389: l_max_credit_pts igs_en_stdnt_ps_intm.max_credit_pts%TYPE;
390: l_max_terms igs_en_stdnt_ps_intm.max_terms%TYPE;
391: l_anticipated_credit_points igs_en_stdnt_ps_intm.anticipated_credit_points%TYPE;
392: l_logical_delete_date igs_en_stdnt_ps_intm.logical_delete_date%TYPE;
393: l_cond_return_flag igs_en_stdnt_ps_intm.cond_return_flag%TYPE;
394: BEGIN

Line 391: l_anticipated_credit_points igs_en_stdnt_ps_intm.anticipated_credit_points%TYPE;

387: l_last_update_login igs_en_stdnt_ps_intm.last_update_login%TYPE;
388: l_institution_name igs_en_stdnt_ps_intm.institution_name%TYPE;
389: l_max_credit_pts igs_en_stdnt_ps_intm.max_credit_pts%TYPE;
390: l_max_terms igs_en_stdnt_ps_intm.max_terms%TYPE;
391: l_anticipated_credit_points igs_en_stdnt_ps_intm.anticipated_credit_points%TYPE;
392: l_logical_delete_date igs_en_stdnt_ps_intm.logical_delete_date%TYPE;
393: l_cond_return_flag igs_en_stdnt_ps_intm.cond_return_flag%TYPE;
394: BEGIN
395:

Line 392: l_logical_delete_date igs_en_stdnt_ps_intm.logical_delete_date%TYPE;

388: l_institution_name igs_en_stdnt_ps_intm.institution_name%TYPE;
389: l_max_credit_pts igs_en_stdnt_ps_intm.max_credit_pts%TYPE;
390: l_max_terms igs_en_stdnt_ps_intm.max_terms%TYPE;
391: l_anticipated_credit_points igs_en_stdnt_ps_intm.anticipated_credit_points%TYPE;
392: l_logical_delete_date igs_en_stdnt_ps_intm.logical_delete_date%TYPE;
393: l_cond_return_flag igs_en_stdnt_ps_intm.cond_return_flag%TYPE;
394: BEGIN
395:
396: SAVEPOINT create_en_spi_pub;

Line 393: l_cond_return_flag igs_en_stdnt_ps_intm.cond_return_flag%TYPE;

389: l_max_credit_pts igs_en_stdnt_ps_intm.max_credit_pts%TYPE;
390: l_max_terms igs_en_stdnt_ps_intm.max_terms%TYPE;
391: l_anticipated_credit_points igs_en_stdnt_ps_intm.anticipated_credit_points%TYPE;
392: l_logical_delete_date igs_en_stdnt_ps_intm.logical_delete_date%TYPE;
393: l_cond_return_flag igs_en_stdnt_ps_intm.cond_return_flag%TYPE;
394: BEGIN
395:
396: SAVEPOINT create_en_spi_pub;
397:

Line 523: INSERT INTO igs_en_stdnt_ps_intm (

519: END IF;
520:
521: l_logical_delete_date := to_date('31-12-4712','DD-MM-YYYY');
522:
523: INSERT INTO igs_en_stdnt_ps_intm (
524: person_id,
525: course_cd,
526: start_dt,
527: logical_delete_date,