APPS.IGS_AS_INC_GRD_CPROF_PKG dependencies on IGS_AS_INC_GRD_CPROF

Line 1: PACKAGE BODY igs_as_inc_grd_cprof_pkg AS

1: PACKAGE BODY igs_as_inc_grd_cprof_pkg AS
2: /* $Header: IGSDI56B.pls 115.6 2002/11/28 23:24:49 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_inc_grd_cprof%ROWTYPE;

Line 5: old_references igs_as_inc_grd_cprof%ROWTYPE;

1: PACKAGE BODY igs_as_inc_grd_cprof_pkg AS
2: /* $Header: IGSDI56B.pls 115.6 2002/11/28 23:24:49 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_inc_grd_cprof%ROWTYPE;
6: new_references igs_as_inc_grd_cprof%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_as_inc_grd_cprof%ROWTYPE;

2: /* $Header: IGSDI56B.pls 115.6 2002/11/28 23:24:49 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_inc_grd_cprof%ROWTYPE;
6: new_references igs_as_inc_grd_cprof%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 40: FROM IGS_AS_INC_GRD_CPROF

36: */
37:
38: CURSOR cur_old_ref_values IS
39: SELECT *
40: FROM IGS_AS_INC_GRD_CPROF
41: WHERE rowid = x_rowid;
42:
43: BEGIN
44:

Line 203: FROM igs_as_inc_grd_cprof

199: || (reverse chronological order - newest change first)
200: */
201: CURSOR cur_rowid IS
202: SELECT rowid
203: FROM igs_as_inc_grd_cprof
204: WHERE inc_grd_cprof_id = x_inc_grd_cprof_id
205: FOR UPDATE NOWAIT;
206:
207: lv_rowid cur_rowid%RowType;

Line 241: FROM igs_as_inc_grd_cprof

237: || (reverse chronological order - newest change first)
238: */
239: CURSOR cur_rowid IS
240: SELECT rowid
241: FROM igs_as_inc_grd_cprof
242: WHERE version_number = x_version_number
243: AND grading_schema_cd = x_grading_schema_cd
244: AND org_unit_cd = x_org_unit_cd
245: AND incomplete_grade = x_incomplete_grade

Line 281: FROM igs_as_inc_grd_cprof

277: || (reverse chronological order - newest change first)
278: */
279: CURSOR cur_rowid IS
280: SELECT rowid
281: FROM igs_as_inc_grd_cprof
282: WHERE ((default_grade = x_grade) AND
283: (grading_schema_cd = x_grading_schema_cd) AND
284: (version_number = x_version_number))
285: OR ((grading_schema_cd = x_grading_schema_cd) AND

Line 321: FROM igs_as_inc_grd_cprof

317: || (reverse chronological order - newest change first)
318: */
319: CURSOR cur_rowid IS
320: SELECT rowid
321: FROM igs_as_inc_grd_cprof
322: WHERE ((comp_after_dt_alias = x_dt_alias));
323:
324: lv_rowid cur_rowid%RowType;
325:

Line 357: FROM igs_as_inc_grd_cprof

353: || (reverse chronological order - newest change first)
354: */
355: CURSOR cur_rowid IS
356: SELECT rowid
357: FROM igs_as_inc_grd_cprof
358: WHERE ((grading_schema_cd = x_grading_schema_cd) AND
359: (version_number = x_version_number));
360:
361: lv_rowid cur_rowid%RowType;

Line 492: FROM igs_as_inc_grd_cprof

488: || (reverse chronological order - newest change first)
489: */
490: CURSOR c IS
491: SELECT rowid
492: FROM igs_as_inc_grd_cprof
493: WHERE inc_grd_cprof_id = x_inc_grd_cprof_id;
494:
495: x_last_update_date DATE;
496: x_last_updated_by NUMBER;

Line 520: SELECT igs_as_inc_grd_cprof_s.NEXTVAL

516: igs_ge_msg_stack.add;
517: app_exception.raise_exception;
518: END IF;
519:
520: SELECT igs_as_inc_grd_cprof_s.NEXTVAL
521: INTO x_inc_grd_cprof_id
522: FROM dual;
523:
524: before_dml(

Line 545: INSERT INTO igs_as_inc_grd_cprof (

541: x_last_updated_by => x_last_updated_by,
542: x_last_update_login => x_last_update_login
543: );
544:
545: INSERT INTO igs_as_inc_grd_cprof (
546: inc_grd_cprof_id,
547: grading_schema_cd,
548: version_number,
549: org_unit_cd,

Line 627: FROM igs_as_inc_grd_cprof

623: comp_after_dt_alias,
624: default_grade,
625: default_mark,
626: instructor_update_ind
627: FROM igs_as_inc_grd_cprof
628: WHERE rowid = x_rowid
629: FOR UPDATE NOWAIT;
630:
631: tlinfo c1%ROWTYPE;

Line 740: UPDATE igs_as_inc_grd_cprof

736: x_last_updated_by => x_last_updated_by,
737: x_last_update_login => x_last_update_login
738: );
739:
740: UPDATE igs_as_inc_grd_cprof
741: SET
742: grading_schema_cd = new_references.grading_schema_cd,
743: version_number = new_references.version_number,
744: org_unit_cd = new_references.org_unit_cd,

Line 790: FROM igs_as_inc_grd_cprof

786: || (reverse chronological order - newest change first)
787: */
788: CURSOR c1 IS
789: SELECT rowid
790: FROM igs_as_inc_grd_cprof
791: WHERE inc_grd_cprof_id = x_inc_grd_cprof_id;
792:
793: BEGIN
794:

Line 857: DELETE FROM igs_as_inc_grd_cprof

853: p_action => 'DELETE',
854: x_rowid => x_rowid
855: );
856:
857: DELETE FROM igs_as_inc_grd_cprof
858: WHERE rowid = x_rowid;
859:
860: IF (SQL%NOTFOUND) THEN
861: RAISE NO_DATA_FOUND;

Line 867: END igs_as_inc_grd_cprof_pkg;

863:
864: END delete_row;
865:
866:
867: END igs_as_inc_grd_cprof_pkg;