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_EN_HESA_PKG dependencies on IGS_HE_ST_SPA

Line 17: -- in IGS_HE_ST_SPA_ALL table as a part of bug 2636897

13: -- and IGS_HE_EN_SUSA table
14: --smaddali 14-may-2002 added new parameter p_old_sequence_number and
15: -- renamed p_sequence_number to p_new_sequence_number in procedure hesa_susa_enr for bug#2350629
16: --Bayadav 22-OCT-2002 Included four new columns qual_aim_subj1,qual_aim_subj2,qual_aim_subj3,qual_aim_proportion
17: -- in IGS_HE_ST_SPA_ALL table as a part of bug 2636897
18: --Bayadav 22-OCT-2002 Included one new column type_of_year and corresponding validation |
19: -- in IGS_HE_EN_SUSA table as a part of bug 2636897 |
20: --knaraset 14-Nov-2002 Added the functions validate_program_aim,val_sub_qual_proportion,
21: -- val_highest_qual_entry,get_unit_set_cat,check_teach_inst,check_grading_sch_grade

Line 31: --jbaber 16-Jan-2006 Updated igs_he_st_spa_all_pkg call to include exclud_flag column for HE305

27: -- HECR008-Alphsnumeric student instance number Bug 2893557
28: --gmahesa 13-Nov-2003 Bug No: 3227107 address changes, Modified gc_addr_rec cursor to select records with active status.
29: --smaddali 08-Jan-2004 Bug#3291399 , modified procedure hesa_susa_enr for modifying logic for copying fields
30: --jbaber 24-Nov-2004 Bug No: 3949136. Modified hesa_stats_enr procedure to prevent enrollment HESA data from being overwritten
31: --jbaber 16-Jan-2006 Updated igs_he_st_spa_all_pkg call to include exclud_flag column for HE305
32: --------------------------------------------------------------------
33:
34: PROCEDURE hesa_stats_enr(
35: p_person_id IN NUMBER,

Line 107: FROM igs_he_st_spa

103: created_by,
104: last_update_date,
105: last_updated_by,
106: last_update_login
107: FROM igs_he_st_spa
108: WHERE person_id = p_person_id
109: AND course_cd = p_course_cd
110: AND version_number = p_crv_version_number;
111:

Line 161: FROM igs_he_st_spa

157:
158:
159: CURSOR gc_upd_stats_rec IS
160: SELECT ROWID
161: FROM igs_he_st_spa
162: WHERE person_id = p_person_id
163: AND course_cd = p_course_cd
164: AND version_number = p_crv_version_number;
165:

Line 167: CURSOR cur_std_inst_num(cp_person_id igs_he_st_spa.person_id%TYPE) IS

163: AND course_cd = p_course_cd
164: AND version_number = p_crv_version_number;
165:
166: -- Get the all instance numbers for the student
167: CURSOR cur_std_inst_num(cp_person_id igs_he_st_spa.person_id%TYPE) IS
168: SELECT student_inst_number
169: FROM igs_he_st_spa
170: WHERE person_id = cp_person_id;
171:

Line 169: FROM igs_he_st_spa

165:
166: -- Get the all instance numbers for the student
167: CURSOR cur_std_inst_num(cp_person_id igs_he_st_spa.person_id%TYPE) IS
168: SELECT student_inst_number
169: FROM igs_he_st_spa
170: WHERE person_id = cp_person_id;
171:
172: l_std_inst_num NUMBER;
173:

Line 174: --Procedure inserts into IGS_HE_ST_SPA_ALL table

170: WHERE person_id = cp_person_id;
171:
172: l_std_inst_num NUMBER;
173:
174: --Procedure inserts into IGS_HE_ST_SPA_ALL table
175:
176: PROCEDURE cr_he_st_spa_rec ( p_person_id igs_he_st_spa.person_id%TYPE,
177: p_course_cd igs_he_st_spa.course_cd%TYPE,
178: p_crv_version_number igs_he_st_spa.version_number%TYPE) IS

Line 176: PROCEDURE cr_he_st_spa_rec ( p_person_id igs_he_st_spa.person_id%TYPE,

172: l_std_inst_num NUMBER;
173:
174: --Procedure inserts into IGS_HE_ST_SPA_ALL table
175:
176: PROCEDURE cr_he_st_spa_rec ( p_person_id igs_he_st_spa.person_id%TYPE,
177: p_course_cd igs_he_st_spa.course_cd%TYPE,
178: p_crv_version_number igs_he_st_spa.version_number%TYPE) IS
179:
180: BEGIN

Line 177: p_course_cd igs_he_st_spa.course_cd%TYPE,

173:
174: --Procedure inserts into IGS_HE_ST_SPA_ALL table
175:
176: PROCEDURE cr_he_st_spa_rec ( p_person_id igs_he_st_spa.person_id%TYPE,
177: p_course_cd igs_he_st_spa.course_cd%TYPE,
178: p_crv_version_number igs_he_st_spa.version_number%TYPE) IS
179:
180: BEGIN
181:

Line 178: p_crv_version_number igs_he_st_spa.version_number%TYPE) IS

174: --Procedure inserts into IGS_HE_ST_SPA_ALL table
175:
176: PROCEDURE cr_he_st_spa_rec ( p_person_id igs_he_st_spa.person_id%TYPE,
177: p_course_cd igs_he_st_spa.course_cd%TYPE,
178: p_crv_version_number igs_he_st_spa.version_number%TYPE) IS
179:
180: BEGIN
181:
182: DECLARE

Line 184: v_stat_seq_num igs_he_st_spa.hesa_st_spa_id%TYPE;

180: BEGIN
181:
182: DECLARE
183:
184: v_stat_seq_num igs_he_st_spa.hesa_st_spa_id%TYPE;
185:
186: CURSOR c_stat_seq_num IS
187: SELECT igs_he_st_spa_all_s.NEXTVAL
188: FROM dual;

Line 187: SELECT igs_he_st_spa_all_s.NEXTVAL

183:
184: v_stat_seq_num igs_he_st_spa.hesa_st_spa_id%TYPE;
185:
186: CURSOR c_stat_seq_num IS
187: SELECT igs_he_st_spa_all_s.NEXTVAL
188: FROM dual;
189:
190: x_rowid VARCHAR2(250);
191: l_org_id NUMBER(15);

Line 226: igs_he_st_spa_all_pkg.insert_row(

222: END ;
223: END LOOP;
224:
225: --Create a reocrd in hesa student program attempt table
226: igs_he_st_spa_all_pkg.insert_row(
227: x_rowid =>x_rowid,
228: x_org_id =>l_org_id,
229: x_hesa_st_spa_id =>v_stat_seq_num,
230: x_person_id =>p_person_id,