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.

[Home] [Help]

APPS.IGS_PR_GEN_002 dependencies on IGS_CA_INST

Line 75: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,

71: FUNCTION prgp_get_sua_gpa_val(
72: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
73: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
74: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
75: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
76: p_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
77: p_best_worst IN VARCHAR2 ,
78: p_recommended_ind IN VARCHAR2,
79: p_uoo_id IN NUMBER)

Line 76: p_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,

72: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
73: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
74: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
75: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
76: p_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
77: p_best_worst IN VARCHAR2 ,
78: p_recommended_ind IN VARCHAR2,
79: p_uoo_id IN NUMBER)
80: RETURN IGS_AS_GRD_SCH_GRADE.gpa_val%TYPE AS

Line 319: IGS_CA_INST ci1

315: SELECT ci1.cal_type,
316: ci1.sequence_number
317: FROM IGS_CA_TYPE cat,
318: IGS_CA_STAT cs,
319: IGS_CA_INST ci1
320: WHERE cat.cal_type = ci1.cal_type AND
321: cat.s_cal_cat = cst_progress AND
322: cs.cal_status = ci1.cal_status AND
323: cs.s_cal_status = cst_active AND

Line 332: FROM IGS_CA_INST ci2

328: ci1.cal_type)
329: = 'Y' AND
330: ci1.start_dt <
331: (SELECT ci2.start_dt
332: FROM IGS_CA_INST ci2
333: WHERE ci2.cal_type = p_prg_cal_type AND
334: ci2.sequence_number = p_prg_sequence_number)
335: ORDER BY ci1.start_dt DESC;
336: BEGIN

Line 432: p_prg_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,

428: -- kdande; 22-Apr-2003; Bug# 2829262
429: -- Added p_uoo_id parameter to the FUNCTION prgp_get_sua_prg_prd
430: --
431: FUNCTION prgp_get_sua_prg_prd(
432: p_prg_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
433: p_prg_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
434: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
435: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
436: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,

Line 433: p_prg_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,

429: -- Added p_uoo_id parameter to the FUNCTION prgp_get_sua_prg_prd
430: --
431: FUNCTION prgp_get_sua_prg_prd(
432: p_prg_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
433: p_prg_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
434: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
435: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
436: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
437: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,

Line 437: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,

433: p_prg_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
434: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
435: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
436: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
437: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
438: p_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
439: p_details_ind IN VARCHAR2 ,
440: p_unit_attempt_status IN VARCHAR2 ,
441: p_discontinued_dt IN DATE,

Line 438: p_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,

434: p_person_id IN IGS_EN_SU_ATTEMPT_ALL.person_id%TYPE ,
435: p_course_cd IN IGS_EN_SU_ATTEMPT_ALL.course_cd%TYPE ,
436: p_unit_cd IN IGS_EN_SU_ATTEMPT_ALL.unit_cd%TYPE ,
437: p_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
438: p_ci_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE ,
439: p_details_ind IN VARCHAR2 ,
440: p_unit_attempt_status IN VARCHAR2 ,
441: p_discontinued_dt IN DATE,
442: p_uoo_id IN NUMBER)

Line 468: v_prev_prg_cal_type IGS_CA_INST.cal_type%TYPE;

464: v_gs_version_number IGS_AS_GRD_SCH_GRADE.version_number%TYPE;
465: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
466: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
467: v_origin_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
468: v_prev_prg_cal_type IGS_CA_INST.cal_type%TYPE;
469: v_prev_prg_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
470: v_previous_cutoff_dt IGS_CA_DA_INST.absolute_val%TYPE;
471: v_cutoff_dt IGS_CA_DA_INST.absolute_val%TYPE;
472: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;

Line 469: v_prev_prg_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;

465: v_grade IGS_AS_GRD_SCH_GRADE.grade%TYPE;
466: v_mark IGS_AS_SU_STMPTOUT.mark%TYPE;
467: v_origin_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE;
468: v_prev_prg_cal_type IGS_CA_INST.cal_type%TYPE;
469: v_prev_prg_ci_sequence_number IGS_CA_INST.sequence_number%TYPE;
470: v_previous_cutoff_dt IGS_CA_DA_INST.absolute_val%TYPE;
471: v_cutoff_dt IGS_CA_DA_INST.absolute_val%TYPE;
472: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
473: v_dummy VARCHAR2(1);

Line 476: FROM IGS_CA_INST_REL cir

472: v_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
473: v_dummy VARCHAR2(1);
474: CURSOR c_cir IS
475: SELECT 'X'
476: FROM IGS_CA_INST_REL cir
477: WHERE cir.sub_cal_type = p_cal_type AND
478: cir.sub_ci_sequence_number = p_ci_sequence_number AND
479: cir.sup_cal_type = p_prg_cal_type AND
480: cir.sup_ci_sequence_number = p_prg_ci_sequence_number;

Line 501: FROM IGS_CA_INST ci1,

497: CURSOR c_ci_cir_ct_cs1 (
498: cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS
499: SELECT cir.sup_cal_type,
500: cir.sup_ci_sequence_number
501: FROM IGS_CA_INST ci1,
502: IGS_CA_INST_REL cir,
503: IGS_CA_TYPE ct,
504: IGS_CA_STAT cs
505: WHERE cir.sub_cal_type = p_cal_type AND

Line 502: IGS_CA_INST_REL cir,

498: cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS
499: SELECT cir.sup_cal_type,
500: cir.sup_ci_sequence_number
501: FROM IGS_CA_INST ci1,
502: IGS_CA_INST_REL cir,
503: IGS_CA_TYPE ct,
504: IGS_CA_STAT cs
505: WHERE cir.sub_cal_type = p_cal_type AND
506: cir.sub_ci_sequence_number = p_ci_sequence_number AND

Line 520: FROM IGS_CA_INST ci2

516: p_prg_cal_type,
517: cir.sup_cal_type) = 'Y' AND
518: ci1.start_dt <
519: (SELECT ci2.start_dt
520: FROM IGS_CA_INST ci2
521: WHERE ci2.cal_type = p_prg_cal_type AND
522: ci2.sequence_number = p_prg_ci_sequence_number)
523: ORDER BY ci1.start_dt DESC;
524: CURSOR c_ci_cir_ct_cs2 (

Line 527: FROM IGS_CA_INST ci1,

523: ORDER BY ci1.start_dt DESC;
524: CURSOR c_ci_cir_ct_cs2 (
525: cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS
526: SELECT 'X'
527: FROM IGS_CA_INST ci1,
528: IGS_CA_INST_REL cir,
529: IGS_CA_TYPE ct,
530: IGS_CA_STAT cs
531: WHERE cir.sub_cal_type = p_cal_type AND

Line 528: IGS_CA_INST_REL cir,

524: CURSOR c_ci_cir_ct_cs2 (
525: cp_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE) IS
526: SELECT 'X'
527: FROM IGS_CA_INST ci1,
528: IGS_CA_INST_REL cir,
529: IGS_CA_TYPE ct,
530: IGS_CA_STAT cs
531: WHERE cir.sub_cal_type = p_cal_type AND
532: cir.sub_ci_sequence_number = p_ci_sequence_number AND

Line 546: FROM IGS_CA_INST ci2

542: p_prg_cal_type,
543: cir.sup_cal_type) = 'Y' AND
544: ci1.start_dt >
545: (SELECT ci2.start_dt
546: FROM IGS_CA_INST ci2
547: WHERE ci2.cal_type = p_prg_cal_type AND
548: ci2.sequence_number = p_prg_ci_sequence_number);
549: BEGIN
550: -- Check calendar relationship between progression and teaching calendar