1: PACKAGE BODY igs_uc_cond_details_pkg AS
2: /* $Header: IGSXI13B.pls 115.7 2003/02/28 07:46:47 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_cond_details%ROWTYPE;
1: PACKAGE BODY igs_uc_cond_details_pkg AS
2: /* $Header: IGSXI13B.pls 115.7 2003/02/28 07:46:47 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_cond_details%ROWTYPE;
6: new_references igs_uc_cond_details%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
2: /* $Header: IGSXI13B.pls 115.7 2003/02/28 07:46:47 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_cond_details%ROWTYPE;
6: new_references igs_uc_cond_details%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 ,
33: */
34:
35: CURSOR cur_old_ref_values IS
36: SELECT *
37: FROM IGS_UC_COND_DETAILS
38: WHERE rowid = x_rowid;
39:
40: BEGIN
41:
135: || (reverse chronological order - newest change first)
136: */
137: CURSOR cur_rowid IS
138: SELECT rowid
139: FROM igs_uc_cond_details
140: WHERE condition_category = x_condition_category
141: AND condition_name = x_condition_name
142: AND condition_line = x_condition_line ;
143:
172: || (reverse chronological order - newest change first)
173: */
174: CURSOR cur_rowid IS
175: SELECT rowid
176: FROM igs_uc_cond_details
177: WHERE ((condition_category = x_condition_category) AND
178: (condition_name = x_condition_name));
179:
180: lv_rowid cur_rowid%RowType;
207: || (reverse chronological order - newest change first)
208: */
209: CURSOR cur_rowid IS
210: SELECT rowid
211: FROM igs_uc_cond_details
212: WHERE ((abbreviation = x_abbreviation));
213:
214: lv_rowid cur_rowid%RowType;
215:
330: || (reverse chronological order - newest change first)
331: */
332: CURSOR c IS
333: SELECT rowid
334: FROM igs_uc_cond_details
335: WHERE condition_category = x_condition_category
336: AND condition_name = x_condition_name
337: AND condition_line = x_condition_line;
338:
378: x_last_updated_by => x_last_updated_by,
379: x_last_update_login => x_last_update_login
380: );
381:
382: INSERT INTO igs_uc_cond_details (
383: condition_category,
384: condition_name,
385: condition_line,
386: abbreviation,
446: grade_mark,
447: points,
448: subject,
449: condition_text
450: FROM igs_uc_cond_details
451: WHERE rowid = x_rowid
452: FOR UPDATE NOWAIT;
453:
454: tlinfo c1%ROWTYPE;
548: x_last_updated_by => x_last_updated_by,
549: x_last_update_login => x_last_update_login
550: );
551:
552: UPDATE igs_uc_cond_details
553: SET
554: abbreviation = new_references.abbreviation,
555: grade_mark = new_references.grade_mark,
556: points = new_references.points,
590: || (reverse chronological order - newest change first)
591: */
592: CURSOR c1 IS
593: SELECT rowid
594: FROM igs_uc_cond_details
595: WHERE condition_category = x_condition_category
596: AND condition_name = x_condition_name
597: AND condition_line = x_condition_line;
598:
653: p_action => 'DELETE',
654: x_rowid => x_rowid
655: );
656:
657: DELETE FROM igs_uc_cond_details
658: WHERE rowid = x_rowid;
659:
660: IF (SQL%NOTFOUND) THEN
661: RAISE NO_DATA_FOUND;
663:
664: END delete_row;
665:
666:
667: END igs_uc_cond_details_pkg;