APPS.IGS_PS_DEGREES_PKG dependencies on IGS_PS_DEGREES

Line 1: PACKAGE BODY igs_ps_degrees_pkg AS

1: PACKAGE BODY igs_ps_degrees_pkg AS
2: /* $Header: IGSPI1IB.pls 120.0 2005/06/02 03:51:59 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_degrees%RowType;
5: new_references igs_ps_degrees%RowType;

Line 4: old_references igs_ps_degrees%RowType;

1: PACKAGE BODY igs_ps_degrees_pkg AS
2: /* $Header: IGSPI1IB.pls 120.0 2005/06/02 03:51:59 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_degrees%RowType;
5: new_references igs_ps_degrees%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references igs_ps_degrees%RowType;

1: PACKAGE BODY igs_ps_degrees_pkg AS
2: /* $Header: IGSPI1IB.pls 120.0 2005/06/02 03:51:59 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references igs_ps_degrees%RowType;
5: new_references igs_ps_degrees%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 34: FROM IGS_PS_DEGREES

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

Line 152: Igs_Ps_Faclty_Degrs_Pkg.Get_FK_Igs_Ps_Degrees (

148: ***************************************************************/
149:
150: BEGIN
151:
152: Igs_Ps_Faclty_Degrs_Pkg.Get_FK_Igs_Ps_Degrees (
153: old_references.degree_cd
154: );
155:
156: END Check_Child_Existance;

Line 175: FROM igs_ps_degrees

171: ***************************************************************/
172:
173: CURSOR cur_rowid IS
174: SELECT rowid
175: FROM igs_ps_degrees
176: WHERE degree_cd = x_degree_cd
177: FOR UPDATE NOWAIT;
178:
179: lv_rowid cur_rowid%RowType;

Line 324: cursor C is select ROWID from IGS_PS_DEGREES

320:
321: (reverse chronological order - newest change first)
322: ***************************************************************/
323:
324: cursor C is select ROWID from IGS_PS_DEGREES
325: where DEGREE_CD= X_DEGREE_CD
326: ;
327: X_LAST_UPDATE_DATE DATE ;
328: X_LAST_UPDATED_BY NUMBER ;

Line 364: insert into IGS_PS_DEGREES (

360: x_created_by=>X_LAST_UPDATED_BY,
361: x_last_update_date=>X_LAST_UPDATE_DATE,
362: x_last_updated_by=>X_LAST_UPDATED_BY,
363: x_last_update_login=>X_LAST_UPDATE_LOGIN);
364: insert into IGS_PS_DEGREES (
365: DEGREE_CD
366: ,DESCRIPTION
367: ,PROGRAM_TYPE
368: ,CLOSED_IND

Line 417: from IGS_PS_DEGREES

413: cursor c1 is select
414: DESCRIPTION
415: , PROGRAM_TYPE
416: , CLOSED_IND
417: from IGS_PS_DEGREES
418: where ROWID = X_ROWID
419: for update nowait;
420: tlinfo c1%rowtype;
421: begin

Line 499: update IGS_PS_DEGREES set

495: x_created_by=>X_LAST_UPDATED_BY,
496: x_last_update_date=>X_LAST_UPDATE_DATE,
497: x_last_updated_by=>X_LAST_UPDATED_BY,
498: x_last_update_login=>X_LAST_UPDATE_LOGIN);
499: update IGS_PS_DEGREES set
500: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
501: PROGRAM_TYPE = NEW_REFERENCES.PROGRAM_TYPE,
502: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
503: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 535: cursor c1 is select ROWID from IGS_PS_DEGREES

531:
532: (reverse chronological order - newest change first)
533: ***************************************************************/
534:
535: cursor c1 is select ROWID from IGS_PS_DEGREES
536: where DEGREE_CD= X_DEGREE_CD
537: ;
538: begin
539: open c1;

Line 580: delete from IGS_PS_DEGREES

576: Before_DML (
577: p_action => 'DELETE',
578: x_rowid => X_ROWID
579: );
580: delete from IGS_PS_DEGREES
581: where ROWID = X_ROWID;
582: if (sql%notfound) then
583: raise no_data_found;
584: end if;

Line 590: END igs_ps_degrees_pkg;

586: p_action => 'DELETE',
587: x_rowid => X_ROWID
588: );
589: end DELETE_ROW;
590: END igs_ps_degrees_pkg;