APPS.IGS_GR_APRV_STAT_PKG dependencies on IGS_GR_APRV_STAT

Line 1: package body IGS_GR_APRV_STAT_PKG as

1: package body IGS_GR_APRV_STAT_PKG as
2: /* $Header: IGSGI01B.pls 115.7 2003/05/16 12:32:05 kdande ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_GR_APRV_STAT%RowType;

Line 5: old_references IGS_GR_APRV_STAT%RowType;

1: package body IGS_GR_APRV_STAT_PKG as
2: /* $Header: IGSGI01B.pls 115.7 2003/05/16 12:32:05 kdande ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_GR_APRV_STAT%RowType;
6: new_references IGS_GR_APRV_STAT%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_GR_APRV_STAT%RowType;

2: /* $Header: IGSGI01B.pls 115.7 2003/05/16 12:32:05 kdande ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_GR_APRV_STAT%RowType;
6: new_references IGS_GR_APRV_STAT%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 24: FROM IGS_GR_APRV_STAT

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

Line 65: IGS_GR_GRADUAND_PKG.GET_FK_IGS_GR_APRV_STAT (

61:
62: PROCEDURE Check_Child_Existance AS
63: BEGIN
64:
65: IGS_GR_GRADUAND_PKG.GET_FK_IGS_GR_APRV_STAT (
66: old_references.graduand_appr_status
67: );
68:
69: END Check_Child_Existance;

Line 77: FROM IGS_GR_APRV_STAT

73: ) RETURN BOOLEAN AS
74:
75: CURSOR cur_rowid IS
76: SELECT rowid
77: FROM IGS_GR_APRV_STAT
78: WHERE graduand_appr_status = x_graduand_appr_status
79: ;
80:
81: lv_rowid cur_rowid%RowType;

Line 174: cursor C is select ROWID from IGS_GR_APRV_STAT

170: X_S_GRADUAND_APPR_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_GR_APRV_STAT
175: where GRADUAND_APPR_STATUS = X_GRADUAND_APPR_STATUS;
176: X_LAST_UPDATE_DATE DATE;
177: X_LAST_UPDATED_BY NUMBER;
178: X_LAST_UPDATE_LOGIN NUMBER;

Line 213: insert into IGS_GR_APRV_STAT (

209: x_last_updated_by => X_LAST_UPDATED_BY,
210: x_last_update_login => X_LAST_UPDATE_LOGIN
211: );
212:
213: insert into IGS_GR_APRV_STAT (
214: GRADUAND_APPR_STATUS,
215: DESCRIPTION,
216: S_GRADUAND_APPR_STATUS,
217: CLOSED_IND,

Line 256: from IGS_GR_APRV_STAT

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

Line 328: update IGS_GR_APRV_STAT set

324: x_last_updated_by => X_LAST_UPDATED_BY,
325: x_last_update_login => X_LAST_UPDATE_LOGIN
326: );
327:
328: update IGS_GR_APRV_STAT set
329: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
330: S_GRADUAND_APPR_STATUS = NEW_REFERENCES.S_GRADUAND_APPR_STATUS,
331: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
332: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 351: cursor c1 is select rowid from IGS_GR_APRV_STAT

347: X_S_GRADUAND_APPR_STATUS in VARCHAR2,
348: X_CLOSED_IND in VARCHAR2,
349: X_MODE in VARCHAR2 default 'R'
350: ) AS
351: cursor c1 is select rowid from IGS_GR_APRV_STAT
352: where GRADUAND_APPR_STATUS = X_GRADUAND_APPR_STATUS
353: ;
354:
355: begin

Line 423: end IGS_GR_APRV_STAT_PKG;

419:
420:
421: END Check_Constraints;
422:
423: end IGS_GR_APRV_STAT_PKG;