APPS.IGS_AS_GEN_004 dependencies on IGS_AS_INS_GRD_ENTRY

Line 207: v_get_record igs_as_ins_grd_entry%ROWTYPE;

203: v_return INTEGER;
204: v_cursor_handle INTEGER;
205: v_student_seq NUMBER DEFAULT 1;
206: v_parse_command VARCHAR2 (1000);
207: v_get_record igs_as_ins_grd_entry%ROWTYPE;
208: v_initials igs_pe_person.given_names%TYPE;
209: v_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE;
210: v_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
211: v_unit_mode igs_as_unit_class.unit_mode%TYPE;

Line 212: CURSOR c_chk_keying_time (cp_keying_time DATE, cp_keying_who igs_as_ins_grd_entry.keying_who%TYPE) IS

208: v_initials igs_pe_person.given_names%TYPE;
209: v_location_cd igs_ps_unit_ofr_opt.location_cd%TYPE;
210: v_unit_class igs_ps_unit_ofr_opt.unit_class%TYPE;
211: v_unit_mode igs_as_unit_class.unit_mode%TYPE;
212: CURSOR c_chk_keying_time (cp_keying_time DATE, cp_keying_who igs_as_ins_grd_entry.keying_who%TYPE) IS
213: SELECT 'x'
214: FROM DUAL
215: WHERE EXISTS ( SELECT *
216: FROM igs_as_ins_grd_entry iaige

Line 216: FROM igs_as_ins_grd_entry iaige

212: CURSOR c_chk_keying_time (cp_keying_time DATE, cp_keying_who igs_as_ins_grd_entry.keying_who%TYPE) IS
213: SELECT 'x'
214: FROM DUAL
215: WHERE EXISTS ( SELECT *
216: FROM igs_as_ins_grd_entry iaige
217: WHERE iaige.keying_time = cp_keying_time
218: AND iaige.keying_who = cp_keying_who);
219: CURSOR c_chk_mark_sheets (cp_mark_sheet igs_as_mark_sheet.sheet_number%TYPE) IS
220: SELECT 'x'

Line 273: -- Copy records from IGS_AS_MSHT_SU_ATMPT to the IGS_AS_INS_GRD_ENTRY table

269: CLOSE c_chk_keying_time;
270: END LOOP;
271: IF p_sheet_number IS NOT NULL THEN
272: -- The routine should copy the records from the nominated mark sheet
273: -- Copy records from IGS_AS_MSHT_SU_ATMPT to the IGS_AS_INS_GRD_ENTRY table
274: -- where the sheet_number matches p_sheet_number
275: FOR c_grd_entry_tmp_rec IN c_grd_entry_tmp LOOP
276: igs_as_ins_grd_entry_pkg.insert_row (
277: x_mode => 'R',

Line 276: igs_as_ins_grd_entry_pkg.insert_row (

272: -- The routine should copy the records from the nominated mark sheet
273: -- Copy records from IGS_AS_MSHT_SU_ATMPT to the IGS_AS_INS_GRD_ENTRY table
274: -- where the sheet_number matches p_sheet_number
275: FOR c_grd_entry_tmp_rec IN c_grd_entry_tmp LOOP
276: igs_as_ins_grd_entry_pkg.insert_row (
277: x_mode => 'R',
278: x_rowid => l_rowid,
279: x_keying_who => c_grd_entry_tmp_rec.p_keying_who,
280: x_keying_time => c_grd_entry_tmp_rec.v_keying_time,

Line 495: igs_as_ins_grd_entry_pkg.insert_row (

491: l_version_number;
492: IF c_id_no_ind%NOTFOUND THEN
493: EXIT;
494: END IF;
495: igs_as_ins_grd_entry_pkg.insert_row (
496: x_mode => 'R',
497: x_rowid => l_rowid,
498: x_keying_who => p_keying_who,
499: x_keying_time => v_keying_time,

Line 534: igs_as_ins_grd_entry_pkg.insert_row (

530: l_version_number;
531: IF c_id_with_ind%NOTFOUND THEN
532: EXIT;
533: END IF;
534: igs_as_ins_grd_entry_pkg.insert_row (
535: x_mode => 'R',
536: x_rowid => l_rowid,
537: x_keying_who => p_keying_who,
538: x_keying_time => v_keying_time,

Line 582: igs_as_ins_grd_entry_pkg.insert_row (

578: l_version_number;
579: IF c_surname_no_ind%NOTFOUND THEN
580: EXIT;
581: END IF;
582: igs_as_ins_grd_entry_pkg.insert_row (
583: x_mode => 'R',
584: x_rowid => l_rowid,
585: x_keying_who => p_keying_who,
586: x_keying_time => v_keying_time,

Line 628: igs_as_ins_grd_entry_pkg.insert_row (

624: l_version_number;
625: IF c_surname_with_ind%NOTFOUND THEN
626: EXIT;
627: END IF;
628: igs_as_ins_grd_entry_pkg.insert_row (
629: x_mode => 'R',
630: x_rowid => l_rowid,
631: x_keying_who => p_keying_who,
632: x_keying_time => v_keying_time,