APPS.IGS_AS_GPC_UNIT_SETS_PKG dependencies on IGS_AS_GPC_UNIT_SETS

Line 1: PACKAGE BODY igs_as_gpc_unit_sets_pkg AS

1: PACKAGE BODY igs_as_gpc_unit_sets_pkg AS
2: /* $Header: IGSDI54B.pls 115.7 2002/11/28 23:24:16 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_gpc_unit_sets%ROWTYPE;

Line 5: old_references igs_as_gpc_unit_sets%ROWTYPE;

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

Line 6: new_references igs_as_gpc_unit_sets%ROWTYPE;

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

Line 33: FROM IGS_AS_GPC_UNIT_SETS

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

Line 143: FROM igs_as_gpc_unit_sets

139: || (reverse chronological order - newest change first)
140: */
141: CURSOR cur_rowid IS
142: SELECT rowid
143: FROM igs_as_gpc_unit_sets
144: WHERE gpc_unit_set_id = x_gpc_unit_set_id
145: FOR UPDATE NOWAIT;
146:
147: lv_rowid cur_rowid%RowType;

Line 180: FROM igs_as_gpc_unit_sets

176: || (reverse chronological order - newest change first)
177: */
178: CURSOR cur_rowid IS
179: SELECT rowid
180: FROM igs_as_gpc_unit_sets
181: WHERE unit_set_cd = x_unit_set_cd
182: AND grading_period_cd = x_grading_period_cd
183: AND unit_set_version_number = x_unit_set_version_number
184: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 218: FROM igs_as_gpc_unit_sets

214: || (reverse chronological order - newest change first)
215: */
216: CURSOR cur_rowid IS
217: SELECT rowid
218: FROM igs_as_gpc_unit_sets
219: WHERE ((unit_set_cd = x_unit_set_cd) AND
220: (unit_set_version_number = x_version_number));
221:
222: lv_rowid cur_rowid%RowType;

Line 332: FROM igs_as_gpc_unit_sets

328: || (reverse chronological order - newest change first)
329: */
330: CURSOR c IS
331: SELECT rowid
332: FROM igs_as_gpc_unit_sets
333: WHERE gpc_unit_set_id = x_gpc_unit_set_id;
334:
335: x_last_update_date DATE;
336: x_last_updated_by NUMBER;

Line 360: SELECT igs_as_gpc_unit_sets_s.NEXTVAL

356: igs_ge_msg_stack.add;
357: app_exception.raise_exception;
358: END IF;
359:
360: SELECT igs_as_gpc_unit_sets_s.NEXTVAL
361: INTO x_gpc_unit_set_id
362: FROM dual;
363:
364: before_dml(

Line 378: INSERT INTO igs_as_gpc_unit_sets (

374: x_last_updated_by => x_last_updated_by,
375: x_last_update_login => x_last_update_login
376: );
377:
378: INSERT INTO igs_as_gpc_unit_sets (
379: gpc_unit_set_id,
380: grading_period_cd,
381: unit_set_cd,
382: unit_set_version_number,

Line 432: FROM igs_as_gpc_unit_sets

428: SELECT
429: grading_period_cd,
430: unit_set_cd,
431: unit_set_version_number
432: FROM igs_as_gpc_unit_sets
433: WHERE rowid = x_rowid
434: FOR UPDATE NOWAIT;
435:
436: tlinfo c1%ROWTYPE;

Line 524: UPDATE igs_as_gpc_unit_sets

520: x_last_updated_by => x_last_updated_by,
521: x_last_update_login => x_last_update_login
522: );
523:
524: UPDATE igs_as_gpc_unit_sets
525: SET
526: grading_period_cd = new_references.grading_period_cd,
527: unit_set_cd = new_references.unit_set_cd,
528: unit_set_version_number = new_references.unit_set_version_number,

Line 560: FROM igs_as_gpc_unit_sets

556: || (reverse chronological order - newest change first)
557: */
558: CURSOR c1 IS
559: SELECT rowid
560: FROM igs_as_gpc_unit_sets
561: WHERE gpc_unit_set_id = x_gpc_unit_set_id;
562:
563: BEGIN
564:

Line 613: DELETE FROM igs_as_gpc_unit_sets

609: p_action => 'DELETE',
610: x_rowid => x_rowid
611: );
612:
613: DELETE FROM igs_as_gpc_unit_sets
614: WHERE rowid = x_rowid;
615:
616: IF (SQL%NOTFOUND) THEN
617: RAISE NO_DATA_FOUND;

Line 623: END igs_as_gpc_unit_sets_pkg;

619:
620: END delete_row;
621:
622:
623: END igs_as_gpc_unit_sets_pkg;