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_STDNT_PS_ATT_PKG dependencies on IGS_CA_INST

Line 2075: ELSIF NOT Igs_Ca_Inst_Pkg.Get_PK_For_Validation (

2071: (old_references.CATALOG_SEQ_NUM = new_references.CATALOG_SEQ_NUM)) OR
2072: ((new_references.CATALOG_CAL_TYPE IS NULL) OR
2073: (new_references.CATALOG_SEQ_NUM IS NULL))) THEN
2074: NULL;
2075: ELSIF NOT Igs_Ca_Inst_Pkg.Get_PK_For_Validation (
2076: new_references.CATALOG_CAL_TYPE,
2077: new_references.CATALOG_SEQ_NUM
2078: ) THEN
2079: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');

Line 2632: PROCEDURE GET_FK_IGS_CA_INST (

2628: CLOSE cur_rowid;
2629: END GET_FK_IGS_PR_CLASS_STD;
2630:
2631:
2632: PROCEDURE GET_FK_IGS_CA_INST (
2633: X_CATALOG_CAL_TYPE IN VARCHAR2,
2634: X_CATALOG_SEQ_NUM IN NUMBER
2635: ) AS
2636: CURSOR cur_rowid IS

Line 2654: END GET_FK_IGS_CA_INST;

2650: App_Exception.Raise_Exception;
2651: RETURN;
2652: END IF;
2653: CLOSE cur_rowid;
2654: END GET_FK_IGS_CA_INST;
2655:
2656:
2657: PROCEDURE Before_DML (
2658: p_action IN VARCHAR2,

Line 3071: l_spa_term_cal_type igs_ca_inst.cal_type%TYPE;

3067:
3068: l_prog_type igs_ps_ver.course_type%TYPE;
3069: l_old_key_prg igs_ps_ver.course_cd%TYPE := NULL;
3070: l_old_prim_prog_cd igs_ps_ver.course_cd%TYPE;
3071: l_spa_term_cal_type igs_ca_inst.cal_type%TYPE;
3072: l_spa_term_sequence_number igs_ca_inst.sequence_number%TYPE;
3073: l_flag BOOLEAN;
3074: --bmerugu added for build 319 dummy variable to call del_sua_for_reopen
3075: l_delflag BOOLEAN;

Line 3072: l_spa_term_sequence_number igs_ca_inst.sequence_number%TYPE;

3068: l_prog_type igs_ps_ver.course_type%TYPE;
3069: l_old_key_prg igs_ps_ver.course_cd%TYPE := NULL;
3070: l_old_prim_prog_cd igs_ps_ver.course_cd%TYPE;
3071: l_spa_term_cal_type igs_ca_inst.cal_type%TYPE;
3072: l_spa_term_sequence_number igs_ca_inst.sequence_number%TYPE;
3073: l_flag BOOLEAN;
3074: --bmerugu added for build 319 dummy variable to call del_sua_for_reopen
3075: l_delflag BOOLEAN;
3076: BEGIN

Line 4773: FROM igs_ca_inst ci,

4769: CURSOR cur_get_effective_term(cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
4770: cp_program_cd igs_en_stdnt_ps_att.course_cd%TYPE,
4771: cp_prg_completion_dt igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE) IS
4772: SELECT ci.cal_type, ci.sequence_number
4773: FROM igs_ca_inst ci,
4774: igs_ca_inst_rel cir,
4775: igs_ca_type ct,
4776: igs_en_stdnt_ps_att sca,
4777: igs_ca_stat cs

Line 4774: igs_ca_inst_rel cir,

4770: cp_program_cd igs_en_stdnt_ps_att.course_cd%TYPE,
4771: cp_prg_completion_dt igs_en_stdnt_ps_att.course_rqrmnts_complete_dt%TYPE) IS
4772: SELECT ci.cal_type, ci.sequence_number
4773: FROM igs_ca_inst ci,
4774: igs_ca_inst_rel cir,
4775: igs_ca_type ct,
4776: igs_en_stdnt_ps_att sca,
4777: igs_ca_stat cs
4778: WHERE sca.person_id = cp_person_id AND

Line 4793: l_term_cal_type igs_ca_inst.cal_type%TYPE;

4789:
4790: l_message_name VARCHAR2(100);
4791: l_create_update_term BOOLEAN;
4792: l_prg_completion_date igs_en_stdnt_ps_att_all.course_rqrmnts_complete_dt%TYPE;
4793: l_term_cal_type igs_ca_inst.cal_type%TYPE;
4794: l_term_ci_seq_num igs_ca_inst.sequence_number%TYPE;
4795:
4796: BEGIN
4797:

Line 4794: l_term_ci_seq_num igs_ca_inst.sequence_number%TYPE;

4790: l_message_name VARCHAR2(100);
4791: l_create_update_term BOOLEAN;
4792: l_prg_completion_date igs_en_stdnt_ps_att_all.course_rqrmnts_complete_dt%TYPE;
4793: l_term_cal_type igs_ca_inst.cal_type%TYPE;
4794: l_term_ci_seq_num igs_ca_inst.sequence_number%TYPE;
4795:
4796: BEGIN
4797:
4798: -- If the system is in program model or the program attempt is primary.