APPS.IGS_AS_GPC_PROGRAMS_PKG dependencies on IGS_AS_GPC_PROGRAMS

Line 1: PACKAGE BODY igs_as_gpc_programs_pkg AS

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

Line 5: old_references igs_as_gpc_programs%ROWTYPE;

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

Line 6: new_references igs_as_gpc_programs%ROWTYPE;

2: /* $Header: IGSDI53B.pls 115.6 2002/11/28 23:24:01 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references igs_as_gpc_programs%ROWTYPE;
6: new_references igs_as_gpc_programs%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_PROGRAMS

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

Line 153: FROM igs_as_gpc_programs

149: || (reverse chronological order - newest change first)
150: */
151: CURSOR cur_rowid IS
152: SELECT rowid
153: FROM igs_as_gpc_programs
154: WHERE gpc_program_id = x_gpc_program_id
155: FOR UPDATE NOWAIT;
156:
157: lv_rowid cur_rowid%RowType;

Line 190: FROM igs_as_gpc_programs

186: || (reverse chronological order - newest change first)
187: */
188: CURSOR cur_rowid IS
189: SELECT rowid
190: FROM igs_as_gpc_programs
191: WHERE grading_period_cd = x_grading_period_cd
192: AND course_cd = x_course_cd
193: AND course_version_number = x_course_version_number
194: AND ((l_rowid IS NULL) OR (rowid <> l_rowid));

Line 228: FROM igs_as_gpc_programs

224: || (reverse chronological order - newest change first)
225: */
226: CURSOR cur_rowid IS
227: SELECT rowid
228: FROM igs_as_gpc_programs
229: WHERE ((course_cd = x_course_cd) AND
230: (course_version_number = x_version_number));
231:
232: lv_rowid cur_rowid%RowType;

Line 257: igs_as_gpc_programs

253:
254: CURSOR cur_rowid IS
255: SELECT rowid
256: FROM
257: igs_as_gpc_programs
258: WHERE
259: grading_period_cd = x_grading_period_cd ;
260:
261: lv_rowid cur_rowid%RowType ;

Line 375: FROM igs_as_gpc_programs

371: || (reverse chronological order - newest change first)
372: */
373: CURSOR c IS
374: SELECT rowid
375: FROM igs_as_gpc_programs
376: WHERE gpc_program_id = x_gpc_program_id;
377:
378: x_last_update_date DATE;
379: x_last_updated_by NUMBER;

Line 403: SELECT igs_as_gpc_programs_s.NEXTVAL

399: igs_ge_msg_stack.add;
400: app_exception.raise_exception;
401: END IF;
402:
403: SELECT igs_as_gpc_programs_s.NEXTVAL
404: INTO x_gpc_program_id
405: FROM dual;
406:
407: before_dml(

Line 421: INSERT INTO igs_as_gpc_programs (

417: x_last_updated_by => x_last_updated_by,
418: x_last_update_login => x_last_update_login
419: );
420:
421: INSERT INTO igs_as_gpc_programs (
422: gpc_program_id,
423: grading_period_cd,
424: course_cd,
425: course_version_number,

Line 475: FROM igs_as_gpc_programs

471: SELECT
472: grading_period_cd,
473: course_cd,
474: course_version_number
475: FROM igs_as_gpc_programs
476: WHERE rowid = x_rowid
477: FOR UPDATE NOWAIT;
478:
479: tlinfo c1%ROWTYPE;

Line 567: UPDATE igs_as_gpc_programs

563: x_last_updated_by => x_last_updated_by,
564: x_last_update_login => x_last_update_login
565: );
566:
567: UPDATE igs_as_gpc_programs
568: SET
569: grading_period_cd = new_references.grading_period_cd,
570: course_cd = new_references.course_cd,
571: course_version_number = new_references.course_version_number,

Line 603: FROM igs_as_gpc_programs

599: || (reverse chronological order - newest change first)
600: */
601: CURSOR c1 IS
602: SELECT rowid
603: FROM igs_as_gpc_programs
604: WHERE gpc_program_id = x_gpc_program_id;
605:
606: BEGIN
607:

Line 656: DELETE FROM igs_as_gpc_programs

652: p_action => 'DELETE',
653: x_rowid => x_rowid
654: );
655:
656: DELETE FROM igs_as_gpc_programs
657: WHERE rowid = x_rowid;
658:
659: IF (SQL%NOTFOUND) THEN
660: RAISE NO_DATA_FOUND;

Line 666: END igs_as_gpc_programs_pkg;

662:
663: END delete_row;
664:
665:
666: END igs_as_gpc_programs_pkg;