APPS.IGS_OR_INST_STAT_PKG dependencies on IGS_OR_INST_STAT

Line 1: package body IGS_OR_INST_STAT_PKG AS

1: package body IGS_OR_INST_STAT_PKG AS
2: /* $Header: IGSOI05B.pls 120.0 2005/06/01 23:09:01 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_OR_INST_STAT%RowType;

Line 5: old_references IGS_OR_INST_STAT%RowType;

1: package body IGS_OR_INST_STAT_PKG AS
2: /* $Header: IGSOI05B.pls 120.0 2005/06/01 23:09:01 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_OR_INST_STAT%RowType;
6: new_references IGS_OR_INST_STAT%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_OR_INST_STAT%RowType;

2: /* $Header: IGSOI05B.pls 120.0 2005/06/01 23:09:01 appldev noship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_OR_INST_STAT%RowType;
6: new_references IGS_OR_INST_STAT%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 23: FROM IGS_OR_INST_STAT

19: x_last_update_login IN NUMBER DEFAULT NULL
20: ) AS
21: CURSOR cur_old_ref_values IS
22: SELECT *
23: FROM IGS_OR_INST_STAT
24: WHERE rowid = x_rowid;
25: BEGIN
26: l_rowid := x_rowid;
27: -- Code for setting the Old and New Reference Values.

Line 58: IGS_OR_INSTITUTION_PKG.GET_FK_IGS_OR_INST_STAT (

54: END Set_Column_Values;
55:
56: PROCEDURE Check_Child_Existance AS
57: BEGIN
58: IGS_OR_INSTITUTION_PKG.GET_FK_IGS_OR_INST_STAT (
59: old_references.institution_status
60: );
61: END Check_Child_Existance;
62:

Line 68: FROM IGS_OR_INST_STAT

64: x_institution_status IN VARCHAR2
65: )RETURN BOOLEAN AS
66: CURSOR cur_rowid IS
67: SELECT rowid
68: FROM IGS_OR_INST_STAT
69: WHERE institution_status = x_institution_status
70: FOR UPDATE NOWAIT;
71: lv_rowid cur_rowid%RowType;
72: BEGIN

Line 174: cursor C is select ROWID from IGS_OR_INST_STAT

170: X_S_INSTITUTION_STATUS in VARCHAR2,
171: X_CLOSED_IND in VARCHAR2,
172: X_MODE in VARCHAR2 default 'R'
173: ) AS
174: cursor C is select ROWID from IGS_OR_INST_STAT
175: where INSTITUTION_STATUS = X_INSTITUTION_STATUS;
176: X_LAST_UPDATE_DATE DATE;
177: X_LAST_UPDATED_BY NUMBER;
178: X_LAST_UPDATE_LOGIN NUMBER;

Line 210: insert into IGS_OR_INST_STAT (

206: x_last_update_date=>X_LAST_UPDATE_DATE,
207: x_last_updated_by=>X_LAST_UPDATED_BY,
208: x_last_update_login=>X_LAST_UPDATE_LOGIN
209: );
210: insert into IGS_OR_INST_STAT (
211: INSTITUTION_STATUS,
212: DESCRIPTION,
213: S_INSTITUTION_STATUS,
214: CLOSED_IND,

Line 255: from IGS_OR_INST_STAT

251: cursor c1 is select
252: DESCRIPTION,
253: S_INSTITUTION_STATUS,
254: CLOSED_IND
255: from IGS_OR_INST_STAT
256: where ROWID = X_ROWID
257: for update nowait ;
258: tlinfo c1%rowtype;
259: begin

Line 323: update IGS_OR_INST_STAT set

319: x_last_update_date=>X_LAST_UPDATE_DATE,
320: x_last_updated_by=>X_LAST_UPDATED_BY,
321: x_last_update_login=>X_LAST_UPDATE_LOGIN
322: );
323: update IGS_OR_INST_STAT set
324: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
325: S_INSTITUTION_STATUS = NEW_REFERENCES.S_INSTITUTION_STATUS,
326: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
327: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 348: cursor c1 is select rowid from IGS_OR_INST_STAT

344: X_S_INSTITUTION_STATUS in VARCHAR2,
345: X_CLOSED_IND in VARCHAR2,
346: X_MODE in VARCHAR2 default 'R'
347: ) AS
348: cursor c1 is select rowid from IGS_OR_INST_STAT
349: where INSTITUTION_STATUS = X_INSTITUTION_STATUS
350: ;
351: begin
352: open c1;

Line 383: delete from IGS_OR_INST_STAT

379: Before_DML(
380: p_action=>'DELETE',
381: x_rowid=>X_ROWID
382: );
383: delete from IGS_OR_INST_STAT
384: where ROWID = X_ROWID ;
385: if (sql%notfound) then
386: raise no_data_found;
387: end if;

Line 440: end IGS_OR_INST_STAT_PKG;

436: App_Exception.Raise_Exception ;
437: END IF;
438: END IF ;
439: end Check_Constraints ;
440: end IGS_OR_INST_STAT_PKG;