APPS.IGS_UC_EXAM_SCORES_PKG dependencies on IGS_UC_EXAM_SCORES

Line 1: PACKAGE BODY igs_uc_exam_scores_pkg AS

1: PACKAGE BODY igs_uc_exam_scores_pkg AS
2: /* $Header: IGSXI18B.pls 115.7 2003/02/28 07:47:34 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_exam_scores%ROWTYPE;

Line 5: old_references igs_uc_exam_scores%ROWTYPE;

1: PACKAGE BODY igs_uc_exam_scores_pkg AS
2: /* $Header: IGSXI18B.pls 115.7 2003/02/28 07:47:34 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_exam_scores%ROWTYPE;
6: new_references igs_uc_exam_scores%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_uc_exam_scores%ROWTYPE;

2: /* $Header: IGSXI18B.pls 115.7 2003/02/28 07:47:34 bayadav noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_uc_exam_scores%ROWTYPE;
6: new_references igs_uc_exam_scores%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2,

Line 34: FROM IGS_UC_EXAM_SCORES

30: */
31:
32: CURSOR cur_old_ref_values IS
33: SELECT *
34: FROM IGS_UC_EXAM_SCORES
35: WHERE rowid = x_rowid;
36:
37: BEGIN
38:

Line 119: FROM igs_uc_exam_scores

115: || (reverse chronological order - newest change first)
116: */
117: CURSOR cur_rowid IS
118: SELECT rowid
119: FROM igs_uc_exam_scores
120: WHERE exam_scores_id = x_exam_scores_id ;
121:
122: lv_rowid cur_rowid%RowType;
123:

Line 154: FROM igs_uc_exam_scores

150: || (reverse chronological order - newest change first)
151: */
152: CURSOR cur_rowid IS
153: SELECT rowid
154: FROM igs_uc_exam_scores
155: WHERE ((exam_level = x_code) AND
156: (ref_code_type = x_code_type));
157:
158: lv_rowid cur_rowid%RowType;

Line 266: FROM igs_uc_exam_scores

262: || (reverse chronological order - newest change first)
263: */
264: CURSOR c IS
265: SELECT rowid
266: FROM igs_uc_exam_scores
267: WHERE exam_scores_id = x_exam_scores_id;
268:
269: x_last_update_date DATE;
270: x_last_updated_by NUMBER;

Line 294: SELECT igs_uc_exam_scores_s.NEXTVAL

290: igs_ge_msg_stack.add;
291: app_exception.raise_exception;
292: END IF;
293:
294: SELECT igs_uc_exam_scores_s.NEXTVAL
295: INTO x_exam_scores_id
296: FROM dual;
297:
298: before_dml(

Line 313: INSERT INTO igs_uc_exam_scores (

309: x_last_updated_by => x_last_updated_by,
310: x_last_update_login => x_last_update_login
311: );
312:
313: INSERT INTO igs_uc_exam_scores (
314: exam_scores_id,
315: ref_code_type,
316: exam_level,
317: points,

Line 371: FROM igs_uc_exam_scores

367: ref_code_type,
368: exam_level,
369: points,
370: grades
371: FROM igs_uc_exam_scores
372: WHERE rowid = x_rowid
373: FOR UPDATE NOWAIT;
374:
375: tlinfo c1%ROWTYPE;

Line 466: UPDATE igs_uc_exam_scores

462: x_last_updated_by => x_last_updated_by,
463: x_last_update_login => x_last_update_login
464: );
465:
466: UPDATE igs_uc_exam_scores
467: SET
468: ref_code_type = new_references.ref_code_type,
469: exam_level = new_references.exam_level,
470: points = new_references.points,

Line 504: FROM igs_uc_exam_scores

500: || (reverse chronological order - newest change first)
501: */
502: CURSOR c1 IS
503: SELECT rowid
504: FROM igs_uc_exam_scores
505: WHERE exam_scores_id = x_exam_scores_id;
506:
507: BEGIN
508:

Line 559: DELETE FROM igs_uc_exam_scores

555: p_action => 'DELETE',
556: x_rowid => x_rowid
557: );
558:
559: DELETE FROM igs_uc_exam_scores
560: WHERE rowid = x_rowid;
561:
562: IF (SQL%NOTFOUND) THEN
563: RAISE NO_DATA_FOUND;

Line 569: END igs_uc_exam_scores_pkg;

565:
566: END delete_row;
567:
568:
569: END igs_uc_exam_scores_pkg;