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

Line 13: || sarakshi 16-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG in function IGS_PR_UPD_SCA_STATUS

9: || Change History : ||
10: || Who When What ||
11: || (reverse chronological order - newest change first) ||
12: ||==============================================================================||
13: || sarakshi 16-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG in function IGS_PR_UPD_SCA_STATUS
14: || ssawhney 17-feb-2003 Bug : 2758856 : Added the parameter x_external_reference
15: || in the call to IGS_PE_PERS_ENCUMB_PKG.UPDATE_ROW
16: ||
17: || NALKUMAR 19-NOV-2002 Bug NO: 2658550 ||

Line 148: FROM IGS_EN_STDNT_PS_ATT sca,

144: CURSOR c_crv_cow IS
145: SELECT crv.course_type,
146: cow.org_unit_cd,
147: cow.ou_start_dt
148: FROM IGS_EN_STDNT_PS_ATT sca,
149: IGS_PS_VER crv,
150: IGS_PS_OWN cow
151: WHERE sca.person_id = p_person_id AND
152: sca.course_cd = p_course_cd AND

Line 269: IGS_EN_STDNT_PS_ATT sca

265: ci.start_dt,
266: sca.version_number
267: FROM IGS_PR_STDNT_PR_OU spo,
268: IGS_CA_INST ci,
269: IGS_EN_STDNT_PS_ATT sca
270: WHERE spo.person_id = p_person_id AND
271: spo.course_cd = p_course_cd AND
272: spo.sequence_number = p_sequence_number AND
273: ci.cal_type = spo.prg_cal_type AND

Line 280: cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,

276: sca.course_cd = spo.course_cd;
277: v_spo_rec c_spo_ci_sca%ROWTYPE;
278: CURSOR c_ci_ct_cs (
279: cp_prg_start_dt IGS_CA_INST.start_dt%TYPE,
280: cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
281: cp_spo_duration_type IGS_PR_STDNT_PR_OU.duration_type%TYPE,
282: cp_spo_prg_cal_type IGS_PR_STDNT_PR_OU.prg_cal_type%TYPE) IS
283: SELECT ci.cal_type,
284: ci.sequence_number

Line 2291: v_course_version IGS_EN_STDNT_PS_ATT.version_number%TYPE;

2287: -- the current status, will update with the new status. Locking is considered.
2288: DECLARE
2289: e_resource_busy EXCEPTION;
2290: PRAGMA EXCEPTION_INIT (e_resource_busy, -54);
2291: v_course_version IGS_EN_STDNT_PS_ATT.version_number%TYPE;
2292: v_progression_status IGS_EN_STDNT_PS_ATT.progression_status%TYPE;
2293: v_current_progression_status IGS_EN_STDNT_PS_ATT.progression_status%TYPE;
2294: v_dummy VARCHAR2(1);
2295: CURSOR c_sca_upd IS

Line 2292: v_progression_status IGS_EN_STDNT_PS_ATT.progression_status%TYPE;

2288: DECLARE
2289: e_resource_busy EXCEPTION;
2290: PRAGMA EXCEPTION_INIT (e_resource_busy, -54);
2291: v_course_version IGS_EN_STDNT_PS_ATT.version_number%TYPE;
2292: v_progression_status IGS_EN_STDNT_PS_ATT.progression_status%TYPE;
2293: v_current_progression_status IGS_EN_STDNT_PS_ATT.progression_status%TYPE;
2294: v_dummy VARCHAR2(1);
2295: CURSOR c_sca_upd IS
2296: SELECT sca.*, sca.ROWID

Line 2293: v_current_progression_status IGS_EN_STDNT_PS_ATT.progression_status%TYPE;

2289: e_resource_busy EXCEPTION;
2290: PRAGMA EXCEPTION_INIT (e_resource_busy, -54);
2291: v_course_version IGS_EN_STDNT_PS_ATT.version_number%TYPE;
2292: v_progression_status IGS_EN_STDNT_PS_ATT.progression_status%TYPE;
2293: v_current_progression_status IGS_EN_STDNT_PS_ATT.progression_status%TYPE;
2294: v_dummy VARCHAR2(1);
2295: CURSOR c_sca_upd IS
2296: SELECT sca.*, sca.ROWID
2297: FROM IGS_EN_STDNT_PS_ATT sca

Line 2297: FROM IGS_EN_STDNT_PS_ATT sca

2293: v_current_progression_status IGS_EN_STDNT_PS_ATT.progression_status%TYPE;
2294: v_dummy VARCHAR2(1);
2295: CURSOR c_sca_upd IS
2296: SELECT sca.*, sca.ROWID
2297: FROM IGS_EN_STDNT_PS_ATT sca
2298: WHERE sca.person_id = p_person_id AND
2299: sca.course_cd = p_course_cd
2300: FOR UPDATE NOWAIT;
2301:

Line 2306: FROM IGS_EN_STDNT_PS_ATT sca

2302: v_sca_upd_rec c_sca_upd%ROWTYPE;
2303: CURSOR c_sca IS
2304: SELECT sca.version_number,
2305: sca.progression_status
2306: FROM IGS_EN_STDNT_PS_ATT sca
2307: WHERE sca.person_id = p_person_id AND
2308: sca.course_cd = p_course_cd;
2309:
2310: CURSOR c_person(cp_party_id Number) IS

Line 2353: IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(

2349: BEGIN
2350: OPEN c_sca_upd;
2351: FETCH c_sca_upd INTO v_sca_upd_rec;
2352: IF c_sca_upd%FOUND THEN
2353: IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(
2354: X_ROWID => v_sca_upd_rec.ROWID,
2355: X_PERSON_ID => v_sca_upd_rec.PERSON_ID,
2356: X_COURSE_CD => v_sca_upd_rec.COURSE_CD,
2357: X_ADVANCED_STANDING_IND => v_sca_upd_rec.ADVANCED_STANDING_IND,

Line 5026: p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,

5022: App_Exception.Raise_Exception;
5023: END igs_pr_get_spo_expiry;
5024:
5025: FUNCTION get_antcp_compl_dt(
5026: p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
5027: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE
5028: )
5029: RETURN DATE
5030: IS

Line 5027: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE

5023: END igs_pr_get_spo_expiry;
5024:
5025: FUNCTION get_antcp_compl_dt(
5026: p_person_id igs_en_stdnt_ps_att_all.person_id%TYPE,
5027: p_course_cd igs_en_stdnt_ps_att_all.course_cd%TYPE
5028: )
5029: RETURN DATE
5030: IS
5031: -- function to get enrollment estimated completion date