APPS.IGS_PR_GEN_004 dependencies on IGS_PR_STDNT_PR_PS

Line 532: FROM IGS_PR_STDNT_PR_PS spc

528: IGS_PR_OU_TYPE pot
529: WHERE
530: (EXISTS (
531: SELECT 'X'
532: FROM IGS_PR_STDNT_PR_PS spc
533: WHERE spc.person_id = cp_person_id AND
534: spc.course_cd = cp_course_cd AND
535: spc.spo_sequence_number = cp_sequence_number AND
536: spc.course_cd = cp_course_cd

Line 555: FROM IGS_PR_STDNT_PR_PS spc

551: cst_expulsion) AND
552: spo.applied_dt IS NOT NULL AND
553: (EXISTS (
554: SELECT 'X'
555: FROM IGS_PR_STDNT_PR_PS spc
556: WHERE spc.person_id = spo.person_id AND
557: spc.course_cd = spo.course_cd AND
558: spc.spo_sequence_number = spo.sequence_number AND
559: spc.course_cd = cp_course_cd

Line 597: FROM IGS_PR_STDNT_PR_PS spc

593: cst_lapsed,
594: cst_intermit) AND
595: (EXISTS (
596: SELECT 'X'
597: FROM IGS_PR_STDNT_PR_PS spc
598: WHERE spc.person_id = cp_spo_person_id AND
599: spc.spo_course_cd = cp_spo_course_cd AND
600: spc.spo_sequence_number = cp_spo_sequence_number AND
601: spc.course_cd = sca.course_cd) OR

Line 3878: IGS_PR_STDNT_PR_PS_PKG.INSERT_ROW (

3874: v_poc_rec_found := TRUE;
3875: DECLARE
3876: LV_ROWID VARCHAR2(25);
3877: BEGIN
3878: IGS_PR_STDNT_PR_PS_PKG.INSERT_ROW (
3879: X_ROWID =>LV_ROWID,
3880: X_PERSON_ID =>p_person_id,
3881: X_SPO_COURSE_CD => p_course_cd,
3882: X_SPO_SEQUENCE_NUMBER => v_spo_sequence_number,

Line 3899: IGS_PR_STDNT_PR_PS_PKG.INSERT_ROW (

3895: -- the enrolled course
3896: DECLARE
3897: LV_ROWID VARCHAR2(25);
3898: BEGIN
3899: IGS_PR_STDNT_PR_PS_PKG.INSERT_ROW (
3900: X_ROWID =>LV_ROWID,
3901: X_PERSON_ID =>p_person_id,
3902: X_SPO_COURSE_CD => p_course_cd,
3903: X_SPO_SEQUENCE_NUMBER => v_spo_sequence_number,

Line 4340: cp_sequence_number IGS_PR_STDNT_PR_PS.spo_sequence_number%TYPE) IS

4336: cst_approved) AND
4337: NVL(spo.expiry_dt,igs_ge_date.igsdate('9999/01/01')) > TRUNC(SYSDATE)
4338: FOR UPDATE NOWAIT;
4339: CURSOR c_spc (
4340: cp_sequence_number IGS_PR_STDNT_PR_PS.spo_sequence_number%TYPE) IS
4341: SELECT spc.ROWID
4342: FROM IGS_PR_STDNT_PR_PS spc
4343: WHERE spc.person_id = p_person_id AND
4344: spc.spo_course_cd = p_course_cd AND

Line 4342: FROM IGS_PR_STDNT_PR_PS spc

4338: FOR UPDATE NOWAIT;
4339: CURSOR c_spc (
4340: cp_sequence_number IGS_PR_STDNT_PR_PS.spo_sequence_number%TYPE) IS
4341: SELECT spc.ROWID
4342: FROM IGS_PR_STDNT_PR_PS spc
4343: WHERE spc.person_id = p_person_id AND
4344: spc.spo_course_cd = p_course_cd AND
4345: spc.spo_sequence_number = cp_sequence_number
4346: FOR UPDATE NOWAIT;

Line 4473: -- Delete from IGS_PR_STDNT_PR_PS

4469: BEGIN
4470: FOR v_spo_rec IN c_spo LOOP
4471: v_progression_outcome_type := v_spo_rec.progression_outcome_type;
4472: IF v_spo_rec.decision_status = cst_pending THEN
4473: -- Delete from IGS_PR_STDNT_PR_PS
4474: BEGIN
4475: FOR v_spc_rec IN c_spc (v_spo_rec.sequence_number) LOOP
4476: IGS_PR_STDNT_PR_PS_PKG.DELETE_ROW(
4477: v_spc_rec.ROWID

Line 4476: IGS_PR_STDNT_PR_PS_PKG.DELETE_ROW(

4472: IF v_spo_rec.decision_status = cst_pending THEN
4473: -- Delete from IGS_PR_STDNT_PR_PS
4474: BEGIN
4475: FOR v_spc_rec IN c_spc (v_spo_rec.sequence_number) LOOP
4476: IGS_PR_STDNT_PR_PS_PKG.DELETE_ROW(
4477: v_spc_rec.ROWID
4478: );
4479: END LOOP;
4480: EXCEPTION

Line 6390: FROM IGS_PR_STDNT_PR_PS spc

6386: (
6387: pot.s_progression_outcome_type IN (cst_probation,cst_manual) OR
6388: EXISTS (
6389: SELECT 'X'
6390: FROM IGS_PR_STDNT_PR_PS spc
6391: WHERE spo.person_id = spc.person_id AND
6392: spo.course_cd = spc.spo_course_cd AND
6393: spo.sequence_number = spc.spo_sequence_number AND
6394: spc.course_cd = sca.course_cd) OR

Line 6465: FROM IGS_PR_STDNT_PR_PS spc

6461: (
6462: pot.s_progression_outcome_type IN (cst_probation,cst_manual) OR
6463: EXISTS (
6464: SELECT 'X'
6465: FROM IGS_PR_STDNT_PR_PS spc
6466: WHERE spo.person_id = spc.person_id AND
6467: spo.course_cd = spc.spo_course_cd AND
6468: spo.sequence_number = spc.spo_sequence_number AND
6469: spc.course_cd = sca.course_cd) OR