APPS.IGS_RE_SPRVSR_TYPE_PKG dependencies on IGS_RE_SPRVSR_TYPE

Line 1: package body IGS_RE_SPRVSR_TYPE_PKG as

1: package body IGS_RE_SPRVSR_TYPE_PKG as
2: /* $Header: IGSRI14B.pls 115.3 2002/11/29 03:35:09 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RE_SPRVSR_TYPE%RowType;

Line 5: old_references IGS_RE_SPRVSR_TYPE%RowType;

1: package body IGS_RE_SPRVSR_TYPE_PKG as
2: /* $Header: IGSRI14B.pls 115.3 2002/11/29 03:35:09 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RE_SPRVSR_TYPE%RowType;
6: new_references IGS_RE_SPRVSR_TYPE%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_RE_SPRVSR_TYPE%RowType;

2: /* $Header: IGSRI14B.pls 115.3 2002/11/29 03:35:09 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RE_SPRVSR_TYPE%RowType;
6: new_references IGS_RE_SPRVSR_TYPE%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 24: FROM IGS_RE_SPRVSR_TYPE

20: ) AS
21:
22: CURSOR cur_old_ref_values IS
23: SELECT *
24: FROM IGS_RE_SPRVSR_TYPE
25: WHERE rowid = x_rowid;
26:
27: BEGIN
28:

Line 106: IGS_RE_SPRVSR_PKG.GET_FK_IGS_RE_SPRVSR_TYPE (

102:
103: PROCEDURE Check_Child_Existance AS
104: BEGIN
105:
106: IGS_RE_SPRVSR_PKG.GET_FK_IGS_RE_SPRVSR_TYPE (
107: old_references.research_supervisor_type
108: );
109:
110: END Check_Child_Existance;

Line 120: FROM IGS_RE_SPRVSR_TYPE

116: AS
117:
118: CURSOR cur_rowid is
119: SELECT rowid
120: FROM IGS_RE_SPRVSR_TYPE
121: WHERE research_supervisor_type = x_research_supervisor_type
122: FOR UPDATE NOWAIT;
123:
124: lv_rowid cur_rowid%RowType;

Line 209: cursor C is select ROWID from IGS_RE_SPRVSR_TYPE

205: X_PRINCIPAL_SUPERVISOR_IND in VARCHAR2,
206: X_CLOSED_IND in VARCHAR2,
207: X_MODE in VARCHAR2 default 'R'
208: ) as
209: cursor C is select ROWID from IGS_RE_SPRVSR_TYPE
210: where RESEARCH_SUPERVISOR_TYPE = X_RESEARCH_SUPERVISOR_TYPE;
211: X_LAST_UPDATE_DATE DATE;
212: X_LAST_UPDATED_BY NUMBER;
213: X_LAST_UPDATE_LOGIN NUMBER;

Line 248: insert into IGS_RE_SPRVSR_TYPE (

244: x_last_update_date => X_LAST_UPDATE_DATE,
245: x_last_update_login => X_LAST_UPDATE_LOGIN
246: );
247:
248: insert into IGS_RE_SPRVSR_TYPE (
249: RESEARCH_SUPERVISOR_TYPE,
250: DESCRIPTION,
251: PRINCIPAL_SUPERVISOR_IND,
252: CLOSED_IND,

Line 291: from IGS_RE_SPRVSR_TYPE

287: cursor c1 is select
288: DESCRIPTION,
289: PRINCIPAL_SUPERVISOR_IND,
290: CLOSED_IND
291: from IGS_RE_SPRVSR_TYPE
292: where ROWID = X_ROWID
293: for update nowait;
294: tlinfo c1%rowtype;
295:

Line 364: update IGS_RE_SPRVSR_TYPE set

360: x_last_update_date => X_LAST_UPDATE_DATE,
361: x_last_update_login => X_LAST_UPDATE_LOGIN
362: );
363:
364: update IGS_RE_SPRVSR_TYPE set
365: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
366: PRINCIPAL_SUPERVISOR_IND = NEW_REFERENCES.PRINCIPAL_SUPERVISOR_IND,
367: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
368: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 387: cursor c1 is select rowid from IGS_RE_SPRVSR_TYPE

383: X_PRINCIPAL_SUPERVISOR_IND in VARCHAR2,
384: X_CLOSED_IND in VARCHAR2,
385: X_MODE in VARCHAR2 default 'R'
386: ) as
387: cursor c1 is select rowid from IGS_RE_SPRVSR_TYPE
388: where RESEARCH_SUPERVISOR_TYPE = X_RESEARCH_SUPERVISOR_TYPE
389: ;
390:
391: begin

Line 425: delete from IGS_RE_SPRVSR_TYPE

421: p_action => 'DELETE',
422: x_rowid => X_ROWID
423: );
424:
425: delete from IGS_RE_SPRVSR_TYPE
426: where ROWID = X_ROWID;
427: if (sql%notfound) then
428: raise no_data_found;
429: end if;

Line 433: end IGS_RE_SPRVSR_TYPE_PKG;

429: end if;
430:
431: end DELETE_ROW;
432:
433: end IGS_RE_SPRVSR_TYPE_PKG;