APPS.IGS_EN_SPA_AWD_AIM_PKG dependencies on IGS_EN_SPAA_HIST

Line 102: igs_en_spaa_hist_pkg.insert_row (

98: NVL(new_references.award_mark, 99999) <> NVL(old_references.award_mark, 99999) OR
99: NVL(new_references.award_grade, 'NULL') <> NVL(old_references.award_grade,'NULL') OR
100: NVL(new_references.grading_schema_cd, 'NULL') <> NVL(old_references.grading_schema_cd, 'NULL') OR
101: NVL(new_references.gs_version_number, 999) <> NVL(old_references.gs_version_number, 999) ) THEN
102: igs_en_spaa_hist_pkg.insert_row (
103: x_rowid => l_rowid,
104: x_person_id => old_references.person_id,
105: x_course_cd => old_references.course_cd,
106: x_award_cd => old_references.award_cd,

Line 126: igs_en_spaa_hist spaah

122: l_rowid VARCHAR2(25);
123: CURSOR cur_spaah IS
124: SELECT spaah.rowid
125: FROM igs_en_spa_awd_aim spaa,
126: igs_en_spaa_hist spaah
127: WHERE spaa.rowid = p_rowid AND
128: spaa.person_id = spaah.person_id AND
129: spaa.course_cd = spaah.course_cd AND
130: spaa.award_cd = spaah.award_cd;

Line 133: igs_en_spaa_hist_pkg.delete_row(x_rowid => cur_spaah_rec.rowid);

129: spaa.course_cd = spaah.course_cd AND
130: spaa.award_cd = spaah.award_cd;
131: BEGIN
132: FOR cur_spaah_rec IN cur_spaah LOOP
133: igs_en_spaa_hist_pkg.delete_row(x_rowid => cur_spaah_rec.rowid);
134: END LOOP;
135: END del_spaa_hist;
136:
137: -- anilk, 01-Oct-2003, Program Completion Validation build