APPS.IGS_GR_STAT_PKG dependencies on IGS_GR_STAT

Line 1: package body IGS_GR_STAT_PKG as

1: package body IGS_GR_STAT_PKG as
2: /* $Header: IGSGI17B.pls 115.6 2003/05/19 04:45:39 ijeddy ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GR_STAT%RowType;
5: new_references IGS_GR_STAT%RowType;

Line 4: old_references IGS_GR_STAT%RowType;

1: package body IGS_GR_STAT_PKG as
2: /* $Header: IGSGI17B.pls 115.6 2003/05/19 04:45:39 ijeddy ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GR_STAT%RowType;
5: new_references IGS_GR_STAT%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_GR_STAT%RowType;

1: package body IGS_GR_STAT_PKG as
2: /* $Header: IGSGI17B.pls 115.6 2003/05/19 04:45:39 ijeddy ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GR_STAT%RowType;
5: new_references IGS_GR_STAT%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 23: FROM IGS_GR_STAT

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

Line 63: IGS_GR_GRADUAND_PKG.GET_FK_IGS_GR_STAT (

59:
60: PROCEDURE Check_Child_Existance AS
61: BEGIN
62:
63: IGS_GR_GRADUAND_PKG.GET_FK_IGS_GR_STAT (
64: old_references.graduand_status
65: );
66:
67: END Check_Child_Existance;

Line 75: FROM IGS_GR_STAT

71: ) RETURN BOOLEAN AS
72:
73: CURSOR cur_rowid IS
74: SELECT rowid
75: FROM IGS_GR_STAT
76: WHERE graduand_status = x_graduand_status ;
77:
78: lv_rowid cur_rowid%RowType;
79:

Line 215: cursor C is select ROWID from IGS_GR_STAT

211: X_S_GRADUAND_STATUS in VARCHAR2,
212: X_CLOSED_IND in VARCHAR2,
213: X_MODE in VARCHAR2 default 'R'
214: ) AS
215: cursor C is select ROWID from IGS_GR_STAT
216: where GRADUAND_STATUS = X_GRADUAND_STATUS;
217: X_LAST_UPDATE_DATE DATE;
218: X_LAST_UPDATED_BY NUMBER;
219: X_LAST_UPDATE_LOGIN NUMBER;

Line 253: insert into IGS_GR_STAT (

249: x_last_updated_by => X_LAST_UPDATED_BY,
250: x_last_update_login => X_LAST_UPDATE_LOGIN
251: );
252:
253: insert into IGS_GR_STAT (
254: GRADUAND_STATUS,
255: DESCRIPTION,
256: S_GRADUAND_STATUS,
257: CLOSED_IND,

Line 296: from IGS_GR_STAT

292: cursor c1 is select
293: DESCRIPTION,
294: S_GRADUAND_STATUS,
295: CLOSED_IND
296: from IGS_GR_STAT
297: where ROWID = X_ROWID for update nowait;
298: tlinfo c1%rowtype;
299:
300: begin

Line 367: update IGS_GR_STAT set

363: x_last_updated_by => X_LAST_UPDATED_BY,
364: x_last_update_login => X_LAST_UPDATE_LOGIN
365: );
366:
367: update IGS_GR_STAT set
368: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
369: S_GRADUAND_STATUS = NEW_REFERENCES.S_GRADUAND_STATUS,
370: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
371: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 390: cursor c1 is select rowid from IGS_GR_STAT

386: X_S_GRADUAND_STATUS in VARCHAR2,
387: X_CLOSED_IND in VARCHAR2,
388: X_MODE in VARCHAR2 default 'R'
389: ) AS
390: cursor c1 is select rowid from IGS_GR_STAT
391: where GRADUAND_STATUS = X_GRADUAND_STATUS
392: ;
393:
394: begin

Line 420: end IGS_GR_STAT_PKG;

416: end ADD_ROW;
417:
418: /* Removed the code for delete row For Locking Issus */
419:
420: end IGS_GR_STAT_PKG;