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_GEN_003 dependencies on IGS_EN_STDNT_PS_ATT

Line 19: pkg_course_cd igs_en_stdnt_ps_att.course_cd%TYPE;

15: /*-------------------------------------------------------------------------------------------------------------
16: Following package variable keeps the enrp_get_enr_cat function parameters values.
17: -------------------------------------------------------------------------------------------------------------*/
18: pkg_person_id igs_pe_person.person_id%TYPE;
19: pkg_course_cd igs_en_stdnt_ps_att.course_cd%TYPE;
20: pkg_cal_type igs_ca_inst.cal_type%TYPE;
21: pkg_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
22: pkg_session_enrolment_cat igs_as_sc_atmpt_enr.enrolment_cat%TYPE;
23: pkg_enrol_cal_type igs_ca_inst.cal_type%TYPE;

Line 28: pkg_course_att_status igs_en_stdnt_ps_att.course_attempt_status%TYPE;

24: pkg_enrol_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
25: pkg_commencement_type VARCHAR2(20);
26: pkg_enroll_catg VARCHAR2(200);
27: pkg_enr_categories VARCHAR2(200);
28: pkg_course_att_status igs_en_stdnt_ps_att.course_attempt_status%TYPE;
29: -------------------------------------------------------------------------------------------------------------
30:
31: Function Enrp_Get_Dflt_Dr(
32: p_description OUT NOCOPY VARCHAR2 )

Line 232: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

228: v_first_time BOOLEAN;
229: v_set_cal BOOLEAN;
230: v_crs_commencement_type VARCHAR2(10);
231: v_commencement_type VARCHAR2(10);
232: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
233: v_enrolment_cat IGS_PS_TYPE.enrolment_cat%TYPE;
234: l_position NUMBER;
235: v_course_att_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
236:

Line 235: v_course_att_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

231: v_commencement_type VARCHAR2(10);
232: v_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
233: v_enrolment_cat IGS_PS_TYPE.enrolment_cat%TYPE;
234: l_position NUMBER;
235: v_course_att_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
236:
237: CURSOR c_sca(
238: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
239: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS

Line 238: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

234: l_position NUMBER;
235: v_course_att_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
236:
237: CURSOR c_sca(
238: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
239: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
240: SELECT person_id,
241: course_cd,
242: version_number,

Line 239: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS

235: v_course_att_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
236:
237: CURSOR c_sca(
238: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
239: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
240: SELECT person_id,
241: course_cd,
242: version_number,
243: course_attempt_status,

Line 245: FROM IGS_EN_STDNT_PS_ATT

241: course_cd,
242: version_number,
243: course_attempt_status,
244: student_confirmed_ind
245: FROM IGS_EN_STDNT_PS_ATT
246: WHERE ((cp_course_cd IS NULL AND person_id = cp_person_id) OR
247: (cp_course_cd IS NOT NULL AND course_cd = cp_course_cd AND
248: person_id = cp_person_id));
249: CURSOR c_scae_ci(

Line 250: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

246: WHERE ((cp_course_cd IS NULL AND person_id = cp_person_id) OR
247: (cp_course_cd IS NOT NULL AND course_cd = cp_course_cd AND
248: person_id = cp_person_id));
249: CURSOR c_scae_ci(
250: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
251: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
252: SELECT IGS_AS_SC_ATMPT_ENR.enrolment_cat,
253: IGS_AS_SC_ATMPT_ENR.cal_type,
254: IGS_AS_SC_ATMPT_ENR.ci_sequence_number,

Line 251: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS

247: (cp_course_cd IS NOT NULL AND course_cd = cp_course_cd AND
248: person_id = cp_person_id));
249: CURSOR c_scae_ci(
250: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
251: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
252: SELECT IGS_AS_SC_ATMPT_ENR.enrolment_cat,
253: IGS_AS_SC_ATMPT_ENR.cal_type,
254: IGS_AS_SC_ATMPT_ENR.ci_sequence_number,
255: IGS_CA_INST.start_dt,

Line 279: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

275:
276: --To get the enrollment category at the program level if the enrollment category is NULL
277: -- as a part of self service setup DLD build enh bug#2043044
278: CURSOR c_pst(
279: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
280: cp_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS
281: SELECT ENROLMENT_CAT
282: FROM IGS_PS_TYPE pt,
283: IGS_PS_VER pv

Line 280: cp_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS

276: --To get the enrollment category at the program level if the enrollment category is NULL
277: -- as a part of self service setup DLD build enh bug#2043044
278: CURSOR c_pst(
279: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
280: cp_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS
281: SELECT ENROLMENT_CAT
282: FROM IGS_PS_TYPE pt,
283: IGS_PS_VER pv
284: WHERE pv.course_cd = p_course_cd AND

Line 288: CURSOR c_scas( cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

284: WHERE pv.course_cd = p_course_cd AND
285: pv.course_type = pt.course_type AND
286: pv.version_number = cp_version_number ;
287:
288: CURSOR c_scas( cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
289: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
290: SELECT course_attempt_status
291: FROM IGS_EN_STDNT_PS_ATT
292: WHERE PERSON_ID = cp_person_id

Line 289: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS

285: pv.course_type = pt.course_type AND
286: pv.version_number = cp_version_number ;
287:
288: CURSOR c_scas( cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
289: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
290: SELECT course_attempt_status
291: FROM IGS_EN_STDNT_PS_ATT
292: WHERE PERSON_ID = cp_person_id
293: AND COURSE_CD = cp_course_cd;

Line 291: FROM IGS_EN_STDNT_PS_ATT

287:
288: CURSOR c_scas( cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
289: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
290: SELECT course_attempt_status
291: FROM IGS_EN_STDNT_PS_ATT
292: WHERE PERSON_ID = cp_person_id
293: AND COURSE_CD = cp_course_cd;
294:
295: BEGIN

Line 704: FROM IGS_EN_STDNT_PS_ATT

700: RETURN VARCHAR2 AS
701:
702: CURSOR stu_period_c IS
703: SELECT COURSE_ATTEMPT_STATUS
704: FROM IGS_EN_STDNT_PS_ATT
705: WHERE PERSON_ID=perid;
706:
707: BEGIN
708: FOR person_cursor IN stu_period_c LOOP

Line 756: CURSOR c_espa(cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

752:
753:
754:
755:
756: CURSOR c_espa(cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
757: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE) IS
758: Select version_number
759: FROM IGS_EN_STDNT_PS_ATT
760: WHERE course_cd = cp_course_cd AND

Line 757: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE) IS

753:
754:
755:
756: CURSOR c_espa(cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
757: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE) IS
758: Select version_number
759: FROM IGS_EN_STDNT_PS_ATT
760: WHERE course_cd = cp_course_cd AND
761: person_id = cp_person_id;

Line 759: FROM IGS_EN_STDNT_PS_ATT

755:
756: CURSOR c_espa(cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
757: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE) IS
758: Select version_number
759: FROM IGS_EN_STDNT_PS_ATT
760: WHERE course_cd = cp_course_cd AND
761: person_id = cp_person_id;
762: lv_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
763: CURSOR c_pst(cp_course_cd IGS_PS_VER.course_cd%TYPE,

Line 762: lv_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

758: Select version_number
759: FROM IGS_EN_STDNT_PS_ATT
760: WHERE course_cd = cp_course_cd AND
761: person_id = cp_person_id;
762: lv_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
763: CURSOR c_pst(cp_course_cd IGS_PS_VER.course_cd%TYPE,
764: cp_version_number IGS_PS_VER.version_number%TYPE) IS
765: Select award_course_ind
766: FROM IGS_PS_TYPE pt,

Line 781: CURSOR c_apai(cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,

777: WHERE teach_cal_type = cp_teach_cal_type AND
778: teach_ci_sequence_number = cp_teach_ci_seq_num
779: ORDER BY load_start_dt desc ;
780: lv_cttl_rec c_cttl%ROWTYPE;
781: CURSOR c_apai(cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
782: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE) IS
783: SELECT count(ai.person_id) cnt
784: FROM IGS_AD_PS_APPL_INST ai,
785: IGS_AD_OFR_RESP_STAT ar

Line 782: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE) IS

778: teach_ci_sequence_number = cp_teach_ci_seq_num
779: ORDER BY load_start_dt desc ;
780: lv_cttl_rec c_cttl%ROWTYPE;
781: CURSOR c_apai(cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
782: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE) IS
783: SELECT count(ai.person_id) cnt
784: FROM IGS_AD_PS_APPL_INST ai,
785: IGS_AD_OFR_RESP_STAT ar
786: WHERE ai.adm_offer_resp_status = ar.adm_offer_resp_status AND

Line 792: CURSOR c_psd(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE) IS

788: ai.person_id = cp_person_id AND
789: ai.course_cd = cp_course_cd ;
790: lv_apai_rec c_apai%ROWTYPE;
791: --Cursor to get the row values for updating roe values
792: CURSOR c_psd(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE) IS
793: SELECT rowid,
794: person_id,
795: effective_start_date,
796: effective_end_date,