APPS.IGS_AS_APPR_GRD_SCH_PKG dependencies on IGS_AS_APPR_GRD_SCH

Line 1: PACKAGE BODY igs_as_appr_grd_sch_pkg AS

1: PACKAGE BODY igs_as_appr_grd_sch_pkg AS
2: /* $Header: IGSDI58B.pls 115.4 2002/11/28 23:25:25 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_appr_grd_sch%ROWTYPE;

Line 5: old_references igs_as_appr_grd_sch%ROWTYPE;

1: PACKAGE BODY igs_as_appr_grd_sch_pkg AS
2: /* $Header: IGSDI58B.pls 115.4 2002/11/28 23:25:25 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_appr_grd_sch%ROWTYPE;
6: new_references igs_as_appr_grd_sch%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_as_appr_grd_sch%ROWTYPE;

2: /* $Header: IGSDI58B.pls 115.4 2002/11/28 23:25:25 nsidana noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_appr_grd_sch%ROWTYPE;
6: new_references igs_as_appr_grd_sch%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 36: FROM igs_as_appr_grd_sch

32: */
33:
34: CURSOR cur_old_ref_values IS
35: SELECT *
36: FROM igs_as_appr_grd_sch
37: WHERE rowid = x_rowid;
38:
39: BEGIN
40:

Line 213: FROM igs_as_appr_grd_sch

209: || (reverse chronological order - newest change first)
210: */
211: CURSOR cur_rowid IS
212: SELECT rowid
213: FROM igs_as_appr_grd_sch
214: WHERE assessment_type = x_assessment_type
215: AND grading_schema_cd = x_grading_schema_cd
216: AND gs_version_number = x_gs_version_number
217: AND unit_cd = x_unit_cd

Line 252: FROM igs_as_appr_grd_sch

248: || (reverse chronological order - newest change first)
249: */
250: CURSOR cur_rowid IS
251: SELECT rowid
252: FROM igs_as_appr_grd_sch
253: WHERE ((assessment_type = x_assessment_type));
254:
255: lv_rowid cur_rowid%RowType;
256:

Line 288: FROM igs_as_appr_grd_sch

284: || (reverse chronological order - newest change first)
285: */
286: CURSOR cur_rowid IS
287: SELECT rowid
288: FROM igs_as_appr_grd_sch
289: WHERE ((unit_cd = x_unit_cd) AND
290: (version_number = x_version_number));
291:
292: lv_rowid cur_rowid%RowType;

Line 325: FROM igs_as_appr_grd_sch

321: || (reverse chronological order - newest change first)
322: */
323: CURSOR cur_rowid IS
324: SELECT rowid
325: FROM igs_as_appr_grd_sch
326: WHERE ((grading_schema_cd = x_grading_schema_cd) AND
327: (gs_version_number = x_version_number));
328:
329: lv_rowid cur_rowid%RowType;

Line 454: FROM igs_as_appr_grd_sch

450: || (reverse chronological order - newest change first)
451: */
452: CURSOR c IS
453: SELECT rowid
454: FROM igs_as_appr_grd_sch
455: WHERE assessment_type = x_assessment_type
456: AND grading_schema_cd = x_grading_schema_cd
457: AND gs_version_number = x_gs_version_number
458: AND unit_cd = x_unit_cd

Line 503: INSERT INTO igs_as_appr_grd_sch (

499: x_last_updated_by => x_last_updated_by,
500: x_last_update_login => x_last_update_login
501: );
502:
503: INSERT INTO igs_as_appr_grd_sch (
504: unit_cd,
505: version_number,
506: assessment_type,
507: grading_schema_cd,

Line 565: FROM igs_as_appr_grd_sch

561: CURSOR c1 IS
562: SELECT
563: default_ind,
564: closed_ind
565: FROM igs_as_appr_grd_sch
566: WHERE rowid = x_rowid
567: FOR UPDATE NOWAIT;
568:
569: tlinfo c1%ROWTYPE;

Line 662: UPDATE igs_as_appr_grd_sch

658: x_last_updated_by => x_last_updated_by,
659: x_last_update_login => x_last_update_login
660: );
661:
662: UPDATE igs_as_appr_grd_sch
663: SET
664: default_ind = new_references.default_ind,
665: closed_ind = new_references.closed_ind,
666: last_update_date = x_last_update_date,

Line 700: FROM igs_as_appr_grd_sch

696: || (reverse chronological order - newest change first)
697: */
698: CURSOR c1 IS
699: SELECT rowid
700: FROM igs_as_appr_grd_sch
701: WHERE assessment_type = x_assessment_type
702: AND grading_schema_cd = x_grading_schema_cd
703: AND gs_version_number = x_gs_version_number
704: AND unit_cd = x_unit_cd

Line 763: DELETE FROM igs_as_appr_grd_sch

759: p_action => 'DELETE',
760: x_rowid => x_rowid
761: );
762:
763: DELETE FROM igs_as_appr_grd_sch
764: WHERE rowid = x_rowid;
765:
766: IF (SQL%NOTFOUND) THEN
767: RAISE NO_DATA_FOUND;

Line 773: END igs_as_appr_grd_sch_pkg;

769:
770: END delete_row;
771:
772:
773: END igs_as_appr_grd_sch_pkg;