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

Line 9: l_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;

5: old_references IGS_EN_SU_ATTEMPT_ALL%ROWTYPE;
6: new_references IGS_EN_SU_ATTEMPT_ALL%ROWTYPE;
7: l_old_cp NUMBER(10);
8: l_new_cp NUMBER(10);
9: l_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
10: l_load_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
11:
12: -- Cursor to update the enrollment actual column
13: -- The field enrollment_actual needs to be updated by 1

Line 10: l_load_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE;

6: new_references IGS_EN_SU_ATTEMPT_ALL%ROWTYPE;
7: l_old_cp NUMBER(10);
8: l_new_cp NUMBER(10);
9: l_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
10: l_load_seq_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
11:
12: -- Cursor to update the enrollment actual column
13: -- The field enrollment_actual needs to be updated by 1
14: -- if the unit attempt is successful.

Line 397: CURSOR cur_load(cp_teach_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

393:
394: CURSOR c_unit_opt (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
395: SELECT 1 FROM igs_ps_unit_ofr_opt
396: WHERE uoo_id = cp_uoo_id FOR UPDATE;
397: CURSOR cur_load(cp_teach_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
398: cp_teach_ci_sequence_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
399: SELECT load_cal_type, load_ci_sequence_number FROM igs_ca_teach_to_load_v
400: WHERE teach_cal_type = cp_teach_cal_type
401: AND teach_ci_sequence_number = cp_teach_ci_sequence_num

Line 398: cp_teach_ci_sequence_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS

394: CURSOR c_unit_opt (cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE) IS
395: SELECT 1 FROM igs_ps_unit_ofr_opt
396: WHERE uoo_id = cp_uoo_id FOR UPDATE;
397: CURSOR cur_load(cp_teach_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
398: cp_teach_ci_sequence_num IGS_CA_INST.SEQUENCE_NUMBER%TYPE) IS
399: SELECT load_cal_type, load_ci_sequence_number FROM igs_ca_teach_to_load_v
400: WHERE teach_cal_type = cp_teach_cal_type
401: AND teach_ci_sequence_number = cp_teach_ci_sequence_num
402: ORDER BY load_start_dt ASC;

Line 1272: l_load_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;

1268: ) AS
1269: v_sequence_number NUMBER;
1270: l_special_fee NUMBER;
1271: l_apply_spl_fee BOOLEAN;
1272: l_load_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1273: l_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1274:
1275: CURSOR cur_special_fee IS
1276: SELECT count(*)

Line 1273: l_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;

1269: v_sequence_number NUMBER;
1270: l_special_fee NUMBER;
1271: l_apply_spl_fee BOOLEAN;
1272: l_load_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1273: l_load_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1274:
1275: CURSOR cur_special_fee IS
1276: SELECT count(*)
1277: FROM IGS_PS_USEC_SP_FEES

Line 1550: ELSIF NOT IGS_CA_INST_PKG.Get_UK_For_Validation (

1546: (new_references.ci_sequence_number IS NULL) OR
1547: (new_references.ci_start_dt IS NULL) OR
1548: (new_references.ci_end_dt IS NULL))) THEN
1549: NULL;
1550: ELSIF NOT IGS_CA_INST_PKG.Get_UK_For_Validation (
1551: new_references.cal_type,
1552: new_references.ci_sequence_number,
1553: new_references.ci_start_dt,
1554: new_references.ci_end_dt ) THEN

Line 1780: PROCEDURE GET_UFK_IGS_CA_INST (

1776: RETURN (FALSE);
1777: END IF;
1778: END Get_PK_For_Validation;
1779:
1780: PROCEDURE GET_UFK_IGS_CA_INST (
1781: x_cal_type IN VARCHAR2,
1782: x_sequence_number IN NUMBER,
1783: x_start_dt IN DATE,
1784: x_end_dt IN DATE

Line 1805: END GET_UFK_IGS_CA_INST;

1801: APP_EXCEPTION.RAISE_EXCEPTION;
1802: RETURN;
1803: END IF;
1804: CLOSE cur_rowid;
1805: END GET_UFK_IGS_CA_INST;
1806:
1807: PROCEDURE GET_FK_IGS_AD_LOCATION (
1808: x_location_cd IN VARCHAR2
1809: ) AS

Line 2517: IGS_CA_INST_REL cir

2513: CURSOR c_teach_to_load(cp_acad_cal_type VARCHAR2) IS
2514: SELECT ttl.load_cal_type, ttl.load_ci_sequence_number
2515: FROM IGS_CA_TEACH_TO_LOAD_V ttl,
2516: IGS_EN_STDNT_PS_ATT spa,
2517: IGS_CA_INST_REL cir
2518: WHERE ttl.teach_cal_type= new_references.cal_type
2519: AND ttl.teach_ci_sequence_number = new_references.ci_sequence_number
2520: AND spa.person_id = new_references.person_id
2521: AND spa.course_cd = new_references.course_cd

Line 2553: cp_term_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

2549: rec_sca c_sca%ROWTYPE;
2550: l_message_name VARCHAR2(200);
2551:
2552: CURSOR c_other_key_recs ( cp_person_id IGS_EN_SPA_TERMS.PERSON_ID%TYPE,
2553: cp_term_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2554: cp_term_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE,
2555: cp_program_cd IGS_PS_VER.COURSE_CD%TYPE,
2556: cp_acad_cal_type IGS_EN_SPA_TERMS.ACAD_CAL_TYPE%TYPE) IS
2557: SELECT 'X'

Line 2554: cp_term_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE,

2550: l_message_name VARCHAR2(200);
2551:
2552: CURSOR c_other_key_recs ( cp_person_id IGS_EN_SPA_TERMS.PERSON_ID%TYPE,
2553: cp_term_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2554: cp_term_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE,
2555: cp_program_cd IGS_PS_VER.COURSE_CD%TYPE,
2556: cp_acad_cal_type IGS_EN_SPA_TERMS.ACAD_CAL_TYPE%TYPE) IS
2557: SELECT 'X'
2558: FROM IGS_EN_SPA_TERMS