APPS.IGS_AS_GPC_ACA_STNDG_PKG dependencies on IGS_AS_GPC_ACA_STNDG

Line 1: PACKAGE BODY igs_as_gpc_aca_stndg_pkg AS

1: PACKAGE BODY igs_as_gpc_aca_stndg_pkg AS
2: /* $Header: IGSDI52B.pls 115.5 2002/11/28 23:23:44 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_gpc_aca_stndg%ROWTYPE;

Line 5: old_references igs_as_gpc_aca_stndg%ROWTYPE;

1: PACKAGE BODY igs_as_gpc_aca_stndg_pkg AS
2: /* $Header: IGSDI52B.pls 115.5 2002/11/28 23:23:44 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_gpc_aca_stndg%ROWTYPE;
6: new_references igs_as_gpc_aca_stndg%ROWTYPE;
7:
8: PROCEDURE set_column_values (
9: p_action IN VARCHAR2,

Line 6: new_references igs_as_gpc_aca_stndg%ROWTYPE;

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

Line 32: FROM IGS_AS_GPC_ACA_STNDG

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

Line 111: FROM igs_as_gpc_aca_stndg

107: || (reverse chronological order - newest change first)
108: */
109: CURSOR cur_rowid IS
110: SELECT rowid
111: FROM igs_as_gpc_aca_stndg
112: WHERE gpc_aca_stndg_id = x_gpc_aca_stndg_id
113: FOR UPDATE NOWAIT;
114:
115: lv_rowid cur_rowid%RowType;

Line 147: FROM igs_as_gpc_aca_stndg

143: || (reverse chronological order - newest change first)
144: */
145: CURSOR cur_rowid IS
146: SELECT rowid
147: FROM igs_as_gpc_aca_stndg
148: WHERE grading_period_cd = x_grading_period_cd
149: AND progression_status = x_progression_status
150: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));
151:

Line 190: igs_as_gpc_aca_stndg

186:
187: CURSOR cur_rowid IS
188: SELECT rowid
189: FROM
190: igs_as_gpc_aca_stndg
191: WHERE
192: grading_period_cd = x_grading_period_cd ;
193:
194: lv_rowid cur_rowid%RowType ;

Line 308: FROM igs_as_gpc_aca_stndg

304: || (reverse chronological order - newest change first)
305: */
306: CURSOR c IS
307: SELECT rowid
308: FROM igs_as_gpc_aca_stndg
309: WHERE gpc_aca_stndg_id = x_gpc_aca_stndg_id;
310:
311: x_last_update_date DATE;
312: x_last_updated_by NUMBER;

Line 336: SELECT igs_as_gpc_aca_stndg_s.NEXTVAL

332: igs_ge_msg_stack.add;
333: app_exception.raise_exception;
334: END IF;
335:
336: SELECT igs_as_gpc_aca_stndg_s.NEXTVAL
337: INTO x_gpc_aca_stndg_id
338: FROM dual;
339:
340: before_dml(

Line 353: INSERT INTO igs_as_gpc_aca_stndg (

349: x_last_updated_by => x_last_updated_by,
350: x_last_update_login => x_last_update_login
351: );
352:
353: INSERT INTO igs_as_gpc_aca_stndg (
354: gpc_aca_stndg_id,
355: grading_period_cd,
356: progression_status,
357: creation_date,

Line 403: FROM igs_as_gpc_aca_stndg

399: CURSOR c1 IS
400: SELECT
401: grading_period_cd,
402: progression_status
403: FROM igs_as_gpc_aca_stndg
404: WHERE rowid = x_rowid
405: FOR UPDATE NOWAIT;
406:
407: tlinfo c1%ROWTYPE;

Line 492: UPDATE igs_as_gpc_aca_stndg

488: x_last_updated_by => x_last_updated_by,
489: x_last_update_login => x_last_update_login
490: );
491:
492: UPDATE igs_as_gpc_aca_stndg
493: SET
494: grading_period_cd = new_references.grading_period_cd,
495: progression_status = new_references.progression_status,
496: last_update_date = x_last_update_date,

Line 526: FROM igs_as_gpc_aca_stndg

522: || (reverse chronological order - newest change first)
523: */
524: CURSOR c1 IS
525: SELECT rowid
526: FROM igs_as_gpc_aca_stndg
527: WHERE gpc_aca_stndg_id = x_gpc_aca_stndg_id;
528:
529: BEGIN
530:

Line 577: DELETE FROM igs_as_gpc_aca_stndg

573: p_action => 'DELETE',
574: x_rowid => x_rowid
575: );
576:
577: DELETE FROM igs_as_gpc_aca_stndg
578: WHERE rowid = x_rowid;
579:
580: IF (SQL%NOTFOUND) THEN
581: RAISE NO_DATA_FOUND;

Line 587: END igs_as_gpc_aca_stndg_pkg;

583:
584: END delete_row;
585:
586:
587: END igs_as_gpc_aca_stndg_pkg;