362: || Purpose : Handles the INSERT DML logic for the table.
363: || Known limitations, enhancements or remarks :
364: || Change History :
365: || Who When What
366: || smvk 13-Feb-2002 Call to igs_ge_gen_003.get_org_id
367: || w.r.t. SWCR006
368: || (reverse chronological order - newest change first)
369: */
370: CURSOR c IS
404: before_dml(
405: p_action => 'INSERT',
406: x_rowid => x_rowid,
407: x_hesa_st_spau_id => x_hesa_st_spau_id,
408: x_org_id => igs_ge_gen_003.get_org_id,
409: x_person_id => x_person_id,
410: x_course_cd => x_course_cd,
411: x_version_number => x_version_number,
412: x_qualification_level => x_qualification_level,
547: || Purpose : Handles the UPDATE DML logic for the table.
548: || Known limitations, enhancements or remarks :
549: || Change History :
550: || Who When What
551: || smvk 13-Feb-2002 Call to igs_ge_gen_003.get_org_id
552: || w.r.t. SWCR006
553: || (reverse chronological order - newest change first)
554: */
555: x_last_update_date DATE ;
580: before_dml(
581: p_action => 'UPDATE',
582: x_rowid => x_rowid,
583: x_hesa_st_spau_id => x_hesa_st_spau_id,
584: x_org_id => igs_ge_gen_003.get_org_id,
585: x_person_id => x_person_id,
586: x_course_cd => x_course_cd,
587: x_version_number => x_version_number,
588: x_qualification_level => x_qualification_level,