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_SS_FACULTY_PKG dependencies on IGS_AS_SU_STMPTOUT

Line 57: | knaraset 09-May-03 modified this procedure to add parameter uoo_id which is used in cursors c_suao_chkand c_IGS_AS_SU_STMPTOUT,

53: p_uoo_id IN igs_en_su_attempt.uoo_id%TYPE
54: ) IS
55: /*
56: | Who When What
57: | knaraset 09-May-03 modified this procedure to add parameter uoo_id which is used in cursors c_suao_chkand c_IGS_AS_SU_STMPTOUT,
58: | also passed the uoo_id in TBH calls of IGS_AS_SU_STMPTOUT_PKG, as part of MUS build bug 2829262
59: |
60: |
61: */

Line 58: | also passed the uoo_id in TBH calls of IGS_AS_SU_STMPTOUT_PKG, as part of MUS build bug 2829262

54: ) IS
55: /*
56: | Who When What
57: | knaraset 09-May-03 modified this procedure to add parameter uoo_id which is used in cursors c_suao_chkand c_IGS_AS_SU_STMPTOUT,
58: | also passed the uoo_id in TBH calls of IGS_AS_SU_STMPTOUT_PKG, as part of MUS build bug 2829262
59: |
60: |
61: */
62: CURSOR c_suao_chk (cp_person_id IGS_AS_SU_STMPTOUT.person_id%TYPE,

Line 62: CURSOR c_suao_chk (cp_person_id IGS_AS_SU_STMPTOUT.person_id%TYPE,

58: | also passed the uoo_id in TBH calls of IGS_AS_SU_STMPTOUT_PKG, as part of MUS build bug 2829262
59: |
60: |
61: */
62: CURSOR c_suao_chk (cp_person_id IGS_AS_SU_STMPTOUT.person_id%TYPE,
63: cp_course_cd IGS_AS_SU_STMPTOUT.course_cd%TYPE,
64: cp_uoo_id IGS_AS_SU_STMPTOUT.uoo_id%TYPE) IS
65: SELECT finalised_outcome_ind,
66: mark,

Line 63: cp_course_cd IGS_AS_SU_STMPTOUT.course_cd%TYPE,

59: |
60: |
61: */
62: CURSOR c_suao_chk (cp_person_id IGS_AS_SU_STMPTOUT.person_id%TYPE,
63: cp_course_cd IGS_AS_SU_STMPTOUT.course_cd%TYPE,
64: cp_uoo_id IGS_AS_SU_STMPTOUT.uoo_id%TYPE) IS
65: SELECT finalised_outcome_ind,
66: mark,
67: grade,

Line 64: cp_uoo_id IGS_AS_SU_STMPTOUT.uoo_id%TYPE) IS

60: |
61: */
62: CURSOR c_suao_chk (cp_person_id IGS_AS_SU_STMPTOUT.person_id%TYPE,
63: cp_course_cd IGS_AS_SU_STMPTOUT.course_cd%TYPE,
64: cp_uoo_id IGS_AS_SU_STMPTOUT.uoo_id%TYPE) IS
65: SELECT finalised_outcome_ind,
66: mark,
67: grade,
68: grading_schema_cd,

Line 72: FROM IGS_AS_SU_STMPTOUT

68: grading_schema_cd,
69: version_number,
70: outcome_dt,
71: number_times_keyed
72: FROM IGS_AS_SU_STMPTOUT
73: WHERE person_id = cp_person_id
74: AND course_cd = cp_course_cd
75: AND uoo_id = cp_uoo_id
76: ORDER BY outcome_dt ASC;

Line 87: CURSOR c_IGS_AS_SU_STMPTOUT (cp_person_id IGS_AS_SU_STMPTOUT.person_id%TYPE,

83: WHERE cal_type = cp_cal_type
84: AND sequence_number = cp_sequence_number;
85:
86:
87: CURSOR c_IGS_AS_SU_STMPTOUT (cp_person_id IGS_AS_SU_STMPTOUT.person_id%TYPE,
88: cp_course_cd IGS_AS_SU_STMPTOUT.course_cd%TYPE,
89: cp_uoo_id IGS_AS_SU_STMPTOUT.uoo_id%TYPE,
90: cp_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE) IS
91: SELECT ROWID,

Line 88: cp_course_cd IGS_AS_SU_STMPTOUT.course_cd%TYPE,

84: AND sequence_number = cp_sequence_number;
85:
86:
87: CURSOR c_IGS_AS_SU_STMPTOUT (cp_person_id IGS_AS_SU_STMPTOUT.person_id%TYPE,
88: cp_course_cd IGS_AS_SU_STMPTOUT.course_cd%TYPE,
89: cp_uoo_id IGS_AS_SU_STMPTOUT.uoo_id%TYPE,
90: cp_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE) IS
91: SELECT ROWID,
92: IGS_AS_SU_STMPTOUT.*

Line 89: cp_uoo_id IGS_AS_SU_STMPTOUT.uoo_id%TYPE,

85:
86:
87: CURSOR c_IGS_AS_SU_STMPTOUT (cp_person_id IGS_AS_SU_STMPTOUT.person_id%TYPE,
88: cp_course_cd IGS_AS_SU_STMPTOUT.course_cd%TYPE,
89: cp_uoo_id IGS_AS_SU_STMPTOUT.uoo_id%TYPE,
90: cp_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE) IS
91: SELECT ROWID,
92: IGS_AS_SU_STMPTOUT.*
93: FROM IGS_AS_SU_STMPTOUT

Line 90: cp_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE) IS

86:
87: CURSOR c_IGS_AS_SU_STMPTOUT (cp_person_id IGS_AS_SU_STMPTOUT.person_id%TYPE,
88: cp_course_cd IGS_AS_SU_STMPTOUT.course_cd%TYPE,
89: cp_uoo_id IGS_AS_SU_STMPTOUT.uoo_id%TYPE,
90: cp_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE) IS
91: SELECT ROWID,
92: IGS_AS_SU_STMPTOUT.*
93: FROM IGS_AS_SU_STMPTOUT
94: WHERE person_id = cp_person_id

Line 92: IGS_AS_SU_STMPTOUT.*

88: cp_course_cd IGS_AS_SU_STMPTOUT.course_cd%TYPE,
89: cp_uoo_id IGS_AS_SU_STMPTOUT.uoo_id%TYPE,
90: cp_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE) IS
91: SELECT ROWID,
92: IGS_AS_SU_STMPTOUT.*
93: FROM IGS_AS_SU_STMPTOUT
94: WHERE person_id = cp_person_id
95: AND course_cd = cp_course_cd
96: AND uoo_id = cp_uoo_id

Line 93: FROM IGS_AS_SU_STMPTOUT

89: cp_uoo_id IGS_AS_SU_STMPTOUT.uoo_id%TYPE,
90: cp_outcome_dt IGS_AS_SU_STMPTOUT.outcome_dt%TYPE) IS
91: SELECT ROWID,
92: IGS_AS_SU_STMPTOUT.*
93: FROM IGS_AS_SU_STMPTOUT
94: WHERE person_id = cp_person_id
95: AND course_cd = cp_course_cd
96: AND uoo_id = cp_uoo_id
97: AND outcome_dt = cp_outcome_dt;

Line 102: v_stmptout_rec c_IGS_AS_SU_STMPTOUT%ROWTYPE;

98:
99:
100: v_ci_rec c_ci%ROWTYPE;
101: v_suao1_rec c_suao_chk%ROWTYPE;
102: v_stmptout_rec c_IGS_AS_SU_STMPTOUT%ROWTYPE;
103: v_records_found BOOLEAN;
104: l_rowid VARCHAR2(25);
105: lv_rowid VARCHAR2(25);
106:

Line 118: OPEN c_IGS_AS_SU_STMPTOUT(

114: END LOOP;
115:
116: IF v_records_found AND v_suao1_rec.finalised_outcome_ind = 'N' THEN
117:
118: OPEN c_IGS_AS_SU_STMPTOUT(
119: p_person_id,
120: p_course_cd,
121: p_uoo_id,
122: v_suao1_rec.outcome_dt);

Line 124: FETCH c_IGS_AS_SU_STMPTOUT INTO v_stmptout_rec;

120: p_course_cd,
121: p_uoo_id,
122: v_suao1_rec.outcome_dt);
123:
124: FETCH c_IGS_AS_SU_STMPTOUT INTO v_stmptout_rec;
125:
126: IGS_AS_SU_STMPTOUT_PKG.UPDATE_ROW (
127: X_ROWID => v_stmptout_rec.rowid ,
128: X_MODE => 'R',

Line 126: IGS_AS_SU_STMPTOUT_PKG.UPDATE_ROW (

122: v_suao1_rec.outcome_dt);
123:
124: FETCH c_IGS_AS_SU_STMPTOUT INTO v_stmptout_rec;
125:
126: IGS_AS_SU_STMPTOUT_PKG.UPDATE_ROW (
127: X_ROWID => v_stmptout_rec.rowid ,
128: X_MODE => 'R',
129: x_person_id => v_stmptout_rec.person_id,
130: x_course_cd => v_stmptout_rec.course_cd,

Line 183: CLOSE c_IGS_AS_SU_STMPTOUT;

179: x_comments => v_stmptout_rec.comments,
180: x_grading_period_cd => v_stmptout_rec.grading_period_cd
181: );
182:
183: CLOSE c_IGS_AS_SU_STMPTOUT;
184:
185: ELSE
186: -- get the start/end dates from the calendar instance.
187: OPEN c_ci(p_cal_type, p_ci_sequence_number);

Line 191: -- Add a new IGS_AS_SU_STMPTOUT record.

187: OPEN c_ci(p_cal_type, p_ci_sequence_number);
188: FETCH c_ci INTO v_ci_rec;
189: CLOSE c_ci;
190:
191: -- Add a new IGS_AS_SU_STMPTOUT record.
192: IGS_AS_SU_STMPTOUT_pkg.INSERT_ROW(
193: x_rowid => l_rowid,
194: x_mode => 'R',
195: x_person_id => p_person_id,

Line 192: IGS_AS_SU_STMPTOUT_pkg.INSERT_ROW(

188: FETCH c_ci INTO v_ci_rec;
189: CLOSE c_ci;
190:
191: -- Add a new IGS_AS_SU_STMPTOUT record.
192: IGS_AS_SU_STMPTOUT_pkg.INSERT_ROW(
193: x_rowid => l_rowid,
194: x_mode => 'R',
195: x_person_id => p_person_id,
196: x_course_cd => p_course_cd,