APPS.IGS_PR_GEN_004 dependencies on IGS_PR_STDNT_PR_CK

Line 90: FROM IGS_PR_STDNT_PR_CK spc

86: cs.CAL_STATUS = ci.CAL_STATUS AND
87: cs.s_CAL_STATUS = cst_active AND
88: EXISTS
89: (SELECT 'X'
90: FROM IGS_PR_STDNT_PR_CK spc
91: WHERE spc.person_id = p_person_id AND
92: spc.course_cd = p_course_cd AND
93: spc.prg_cal_type = cir.sup_cal_type AND
94: spc.prg_ci_sequence_number = cir.sup_ci_sequence_number)

Line 2932: 'FROM igs_pr_stdnt_pr_ck spc ' ||

2928: --
2929: stmt_str := stmt_str ||
2930: 'AND NOT EXISTS ( ' ||
2931: 'SELECT 1 ' ||
2932: 'FROM igs_pr_stdnt_pr_ck spc ' ||
2933: 'WHERE sca.person_id = spc.person_id ' ||
2934: 'AND sca.course_cd = spc.course_cd ' ||
2935: 'AND spc.prg_cal_type = ''' || p_ci_cal_type || ''' ' ||
2936: 'AND spc.prg_ci_sequence_number = ' || NVL (p_ci_sequence_number, 0) || ') ' ||

Line 3195: FROM IGS_PR_STDNT_PR_CK spc

3191: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
3192: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
3193: SELECT spc.prg_cal_type,
3194: spc.prg_ci_sequence_number
3195: FROM IGS_PR_STDNT_PR_CK spc
3196: WHERE spc.person_id = cp_person_id AND
3197: spc.course_cd = cp_course_cd;
3198: CURSOR c_spc2 (
3199: cp_cal_type IGS_CA_INST.cal_type%TYPE,

Line 3205: FROM IGS_PR_STDNT_PR_CK spc,

3201: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
3202: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
3203: SELECT spc.prg_cal_type,
3204: spc.prg_ci_sequence_number
3205: FROM IGS_PR_STDNT_PR_CK spc,
3206: IGS_CA_INST ci1
3207: WHERE spc.person_id = cp_person_id AND
3208: spc.course_cd = cp_course_cd AND
3209: ci1.cal_type = spc.prg_cal_type AND

Line 5235: /*INSERT INTO IGS_PR_STDNT_PR_CK (

5231: v_rules_altered := TRUE;
5232: END IF;
5233: v_sprc_insert_count := v_sprc_insert_count + 1;
5234: IF v_sprc_insert_count = 1 THEN
5235: /*INSERT INTO IGS_PR_STDNT_PR_CK (
5236: person_id,
5237: course_cd,
5238: prg_cal_type,
5239: prg_ci_sequence_number,

Line 5266: IGS_PR_STDNT_PR_CK_PKG.INSERT_ROW (

5262: BEGIN
5263: OPEN c_decode;
5264: FETCH c_decode INTO v_decode_val2;
5265: CLOSE c_decode;
5266: IGS_PR_STDNT_PR_CK_PKG.INSERT_ROW (
5267: X_ROWID =>LV_ROWID,
5268: X_PERSON_ID =>p_person_id,
5269: X_COURSE_CD =>p_course_cd,
5270: X_PRG_CAL_TYPE =>p_prg_cal_type,