566: || Purpose : Handles the INSERT DML logic for the table.
567: || Known limitations, enhancements or remarks :
568: || Change History :
569: || Who When What
570: || smvk 13-Feb-2002 Call to igs_ge_gen_003.get_org_id
571: || w.r.t. SWCR006
572: || (reverse chronological order - newest change first)
573: */
574: CURSOR c IS
608: before_dml(
609: p_action => 'INSERT',
610: x_rowid => x_rowid,
611: x_hesa_poous_ou_id => x_hesa_poous_ou_id,
612: x_org_id => igs_ge_gen_003.get_org_id,
613: x_course_cd => x_course_cd,
614: x_crv_version_number => x_crv_version_number,
615: x_cal_type => x_cal_type,
616: x_location_cd => x_location_cd,
779: || Purpose : Handles the UPDATE DML logic for the table.
780: || Known limitations, enhancements or remarks :
781: || Change History :
782: || Who When What
783: || smvk 13-Feb-2002 Call to igs_ge_gen_003.get_org_id
784: || w.r.t. SWCR 006
785: || (reverse chronological order - newest change first)
786: */
787: x_last_update_date DATE ;
812: before_dml(
813: p_action => 'UPDATE',
814: x_rowid => x_rowid,
815: x_hesa_poous_ou_id => x_hesa_poous_ou_id,
816: x_org_id => igs_ge_gen_003.get_org_id,
817: x_course_cd => x_course_cd,
818: x_crv_version_number => x_crv_version_number,
819: x_cal_type => x_cal_type,
820: x_location_cd => x_location_cd,