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_AS_GEN_006 dependencies on IGS_CA_INST

Line 142: p_assess_cal_type igs_ca_inst.cal_type%TYPE;

138: --added by lkaki--
139: p_audit_grade IN VARCHAR2 DEFAULT NULL
140: ) IS
141: --
142: p_assess_cal_type igs_ca_inst.cal_type%TYPE;
143: p_assess_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
144: p_teach_cal_type igs_ca_inst.cal_type%TYPE;
145: p_teach_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
146: p_org_unit_cd igs_or_unit.org_unit_cd%TYPE;

Line 143: p_assess_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

139: p_audit_grade IN VARCHAR2 DEFAULT NULL
140: ) IS
141: --
142: p_assess_cal_type igs_ca_inst.cal_type%TYPE;
143: p_assess_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
144: p_teach_cal_type igs_ca_inst.cal_type%TYPE;
145: p_teach_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
146: p_org_unit_cd igs_or_unit.org_unit_cd%TYPE;
147: p_unit_cd igs_ps_unit.unit_cd%TYPE;

Line 144: p_teach_cal_type igs_ca_inst.cal_type%TYPE;

140: ) IS
141: --
142: p_assess_cal_type igs_ca_inst.cal_type%TYPE;
143: p_assess_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
144: p_teach_cal_type igs_ca_inst.cal_type%TYPE;
145: p_teach_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
146: p_org_unit_cd igs_or_unit.org_unit_cd%TYPE;
147: p_unit_cd igs_ps_unit.unit_cd%TYPE;
148: p_location_cd igs_ad_location.location_cd%TYPE;

Line 145: p_teach_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

141: --
142: p_assess_cal_type igs_ca_inst.cal_type%TYPE;
143: p_assess_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
144: p_teach_cal_type igs_ca_inst.cal_type%TYPE;
145: p_teach_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
146: p_org_unit_cd igs_or_unit.org_unit_cd%TYPE;
147: p_unit_cd igs_ps_unit.unit_cd%TYPE;
148: p_location_cd igs_ad_location.location_cd%TYPE;
149: p_unit_mode igs_as_unit_mode.unit_mode%TYPE;

Line 261: cp_assess_cal_type igs_ca_inst.cal_type%TYPE,

257: -- Get all the Student Unit Attempts that do not have any Unit Attempt Outcome
258: -- and match the criteria passed thru parameters
259: --
260: CURSOR c_stu_unit_atmpt (
261: cp_assess_cal_type igs_ca_inst.cal_type%TYPE,
262: cp_assess_sequence_number igs_ca_inst.sequence_number%TYPE,
263: cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
264: cp_teach_sequence_number igs_ca_inst.sequence_number%TYPE,
265: cp_org_unit_cd igs_or_unit.org_unit_cd%TYPE,

Line 262: cp_assess_sequence_number igs_ca_inst.sequence_number%TYPE,

258: -- and match the criteria passed thru parameters
259: --
260: CURSOR c_stu_unit_atmpt (
261: cp_assess_cal_type igs_ca_inst.cal_type%TYPE,
262: cp_assess_sequence_number igs_ca_inst.sequence_number%TYPE,
263: cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
264: cp_teach_sequence_number igs_ca_inst.sequence_number%TYPE,
265: cp_org_unit_cd igs_or_unit.org_unit_cd%TYPE,
266: cp_unit_cd igs_ps_unit.unit_cd%TYPE,

Line 263: cp_teach_cal_type igs_ca_inst.cal_type%TYPE,

259: --
260: CURSOR c_stu_unit_atmpt (
261: cp_assess_cal_type igs_ca_inst.cal_type%TYPE,
262: cp_assess_sequence_number igs_ca_inst.sequence_number%TYPE,
263: cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
264: cp_teach_sequence_number igs_ca_inst.sequence_number%TYPE,
265: cp_org_unit_cd igs_or_unit.org_unit_cd%TYPE,
266: cp_unit_cd igs_ps_unit.unit_cd%TYPE,
267: cp_location_cd igs_ad_location.location_cd%TYPE,

Line 264: cp_teach_sequence_number igs_ca_inst.sequence_number%TYPE,

260: CURSOR c_stu_unit_atmpt (
261: cp_assess_cal_type igs_ca_inst.cal_type%TYPE,
262: cp_assess_sequence_number igs_ca_inst.sequence_number%TYPE,
263: cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
264: cp_teach_sequence_number igs_ca_inst.sequence_number%TYPE,
265: cp_org_unit_cd igs_or_unit.org_unit_cd%TYPE,
266: cp_unit_cd igs_ps_unit.unit_cd%TYPE,
267: cp_location_cd igs_ad_location.location_cd%TYPE,
268: cp_unit_mode igs_as_unit_class.unit_mode%TYPE,

Line 291: FROM igs_ca_inst_rel

287: igs_as_unit_class_all uc
288: WHERE ((cp_assess_cal_type IS NOT NULL
289: AND EXISTS (
290: SELECT 'x'
291: FROM igs_ca_inst_rel
292: WHERE sub_cal_type = sua.cal_type
293: AND sub_ci_sequence_number = sua.ci_sequence_number
294: AND sup_cal_type = cp_assess_cal_type
295: AND sup_ci_sequence_number = cp_assess_sequence_number)

Line 1004: p_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE;

1000: p_reprdc IN VARCHAR2 DEFAULT 'N',
1001: p_org_id IN NUMBER
1002: )
1003: IS
1004: p_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1005: p_acad_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1006: p_teach_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1007: p_teach_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1008: p_course_cd IGS_PS_COURSE.COURSE_CD%TYPE;

Line 1005: p_acad_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;

1001: p_org_id IN NUMBER
1002: )
1003: IS
1004: p_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1005: p_acad_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1006: p_teach_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1007: p_teach_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1008: p_course_cd IGS_PS_COURSE.COURSE_CD%TYPE;
1009: p_unit_cd IGS_PS_UNIT.UNIT_CD%TYPE;

Line 1006: p_teach_cal_type IGS_CA_INST.CAL_TYPE%TYPE;

1002: )
1003: IS
1004: p_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1005: p_acad_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1006: p_teach_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1007: p_teach_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1008: p_course_cd IGS_PS_COURSE.COURSE_CD%TYPE;
1009: p_unit_cd IGS_PS_UNIT.UNIT_CD%TYPE;
1010: p_location_cd IGS_AD_LOCATION.LOCATION_CD%TYPE;

Line 1007: p_teach_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;

1003: IS
1004: p_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1005: p_acad_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1006: p_teach_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
1007: p_teach_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
1008: p_course_cd IGS_PS_COURSE.COURSE_CD%TYPE;
1009: p_unit_cd IGS_PS_UNIT.UNIT_CD%TYPE;
1010: p_location_cd IGS_AD_LOCATION.LOCATION_CD%TYPE;
1011: p_unit_class IGS_AS_UNIT_CLASS.UNIT_CLASS%TYPE;

Line 1122: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

1118: -- 5. Correspondence Outcome References of 'COVERSHEET' should not exist for the person , unit ,course
1119: -- and assessment
1120:
1121: CURSOR c_enrolled_students (
1122: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1123: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
1124: cp_teach_cal_type IGS_EN_SU_ATTEMPT.CAL_TYPE%TYPE,
1125: cp_teach_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1126: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,

Line 1123: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,

1119: -- and assessment
1120:
1121: CURSOR c_enrolled_students (
1122: cp_acad_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1123: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
1124: cp_teach_cal_type IGS_EN_SU_ATTEMPT.CAL_TYPE%TYPE,
1125: cp_teach_ci_sequence_number IGS_EN_SU_ATTEMPT.ci_sequence_number%TYPE,
1126: cp_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE,
1127: cp_unit_cd IGS_EN_SU_ATTEMPT.unit_cd%TYPE,

Line 1707: cp_ass_cal_type IGS_CA_INST.CAL_TYPE%TYPE,

1703: SELECT userenv('SESSIONID')
1704: FROM dual;
1705: -- Cursor to select teaching periods under the assessment period.
1706: CURSOR c_teach_perd (
1707: cp_ass_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1708: cp_ass_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1709: SELECT ci2.CAL_TYPE,
1710: ci2.sequence_number
1711: FROM IGS_CA_INST ci,

Line 1708: cp_ass_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

1704: FROM dual;
1705: -- Cursor to select teaching periods under the assessment period.
1706: CURSOR c_teach_perd (
1707: cp_ass_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1708: cp_ass_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1709: SELECT ci2.CAL_TYPE,
1710: ci2.sequence_number
1711: FROM IGS_CA_INST ci,
1712: IGS_CA_INST ci2,

Line 1711: FROM IGS_CA_INST ci,

1707: cp_ass_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
1708: cp_ass_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1709: SELECT ci2.CAL_TYPE,
1710: ci2.sequence_number
1711: FROM IGS_CA_INST ci,
1712: IGS_CA_INST ci2,
1713: IGS_CA_TYPE ct,
1714: IGS_CA_TYPE ct2
1715: WHERE ci.CAL_TYPE = cp_ass_cal_type AND

Line 1712: IGS_CA_INST ci2,

1708: cp_ass_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
1709: SELECT ci2.CAL_TYPE,
1710: ci2.sequence_number
1711: FROM IGS_CA_INST ci,
1712: IGS_CA_INST ci2,
1713: IGS_CA_TYPE ct,
1714: IGS_CA_TYPE ct2
1715: WHERE ci.CAL_TYPE = cp_ass_cal_type AND
1716: ci.sequence_number = cp_ass_sequence_number AND

Line 1964: p_exam_cal_type igs_ca_inst.cal_type%type;

1960: p_exam_cal in VARCHAR2,
1961: p_org_id in NUMBER
1962: )
1963: IS
1964: p_exam_cal_type igs_ca_inst.cal_type%type;
1965: p_exam_ci_sequence_number igs_ca_inst.sequence_number%type;
1966:
1967: BEGIN -- assp_ins_dflt_evsa_a
1968: -- Default the IGS_AS_EXMVNU_SESAVL records for all venues within an

Line 1965: p_exam_ci_sequence_number igs_ca_inst.sequence_number%type;

1961: p_org_id in NUMBER
1962: )
1963: IS
1964: p_exam_cal_type igs_ca_inst.cal_type%type;
1965: p_exam_ci_sequence_number igs_ca_inst.sequence_number%type;
1966:
1967: BEGIN -- assp_ins_dflt_evsa_a
1968: -- Default the IGS_AS_EXMVNU_SESAVL records for all venues within an
1969: -- examination period.