APPS.IGS_GE_SPL_REQ_PKG dependencies on IGS_GE_SPL_REQ

Line 1: package body IGS_GE_SPL_REQ_PKG as

1: package body IGS_GE_SPL_REQ_PKG as
2: /* $Header: IGSMI06B.pls 115.3 2002/11/29 01:10:20 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GE_SPL_REQ%RowType;
5: new_references IGS_GE_SPL_REQ%RowType;

Line 4: old_references IGS_GE_SPL_REQ%RowType;

1: package body IGS_GE_SPL_REQ_PKG as
2: /* $Header: IGSMI06B.pls 115.3 2002/11/29 01:10:20 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GE_SPL_REQ%RowType;
5: new_references IGS_GE_SPL_REQ%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_GE_SPL_REQ%RowType;

1: package body IGS_GE_SPL_REQ_PKG as
2: /* $Header: IGSMI06B.pls 115.3 2002/11/29 01:10:20 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GE_SPL_REQ%RowType;
5: new_references IGS_GE_SPL_REQ%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 23: FROM IGS_GE_SPL_REQ

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

Line 94: IGS_PS_STDNT_SPL_REQ_PKG.GET_FK_IGS_GE_SPL_REQ (

90:
91: PROCEDURE Check_Child_Existance as
92: BEGIN
93:
94: IGS_PS_STDNT_SPL_REQ_PKG.GET_FK_IGS_GE_SPL_REQ (
95: old_references.special_requirement_cd
96: );
97:
98: END Check_Child_Existance;

Line 106: FROM IGS_GE_SPL_REQ

102: ) RETURN BOOLEAN as
103:
104: CURSOR cur_rowid IS
105: SELECT rowid
106: FROM IGS_GE_SPL_REQ
107: WHERE special_requirement_cd = x_special_requirement_cd
108: FOR UPDATE NOWAIT;
109:
110: lv_rowid cur_rowid%RowType;

Line 216: cursor C is select ROWID from IGS_GE_SPL_REQ

212: X_CLOSED_IND in VARCHAR2,
213: X_COMMENTS in VARCHAR2,
214: X_MODE in VARCHAR2 default 'R'
215: ) as
216: cursor C is select ROWID from IGS_GE_SPL_REQ
217: where SPECIAL_REQUIREMENT_CD = X_SPECIAL_REQUIREMENT_CD;
218: X_LAST_UPDATE_DATE DATE;
219: X_LAST_UPDATED_BY NUMBER;
220: X_LAST_UPDATE_LOGIN NUMBER;

Line 254: insert into IGS_GE_SPL_REQ (

250: x_last_update_date => X_LAST_UPDATE_DATE,
251: x_last_update_login => X_LAST_UPDATE_LOGIN
252: );
253:
254: insert into IGS_GE_SPL_REQ (
255: SPECIAL_REQUIREMENT_CD,
256: DESCRIPTION,
257: CLOSED_IND,
258: COMMENTS,

Line 300: from IGS_GE_SPL_REQ

296: cursor c1 is select
297: DESCRIPTION,
298: CLOSED_IND,
299: COMMENTS
300: from IGS_GE_SPL_REQ
301: where ROWID = X_ROWID
302: for update nowait;
303: tlinfo c1%rowtype;
304:

Line 375: update IGS_GE_SPL_REQ set

371: x_last_updated_by => X_LAST_UPDATED_BY,
372: x_last_update_date => X_LAST_UPDATE_DATE,
373: x_last_update_login => X_LAST_UPDATE_LOGIN
374: );
375: update IGS_GE_SPL_REQ set
376: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
377: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
378: COMMENTS = NEW_REFERENCES.COMMENTS,
379: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 401: cursor c1 is select rowid from IGS_GE_SPL_REQ

397: X_CLOSED_IND in VARCHAR2,
398: X_COMMENTS in VARCHAR2,
399: X_MODE in VARCHAR2 default 'R'
400: ) as
401: cursor c1 is select rowid from IGS_GE_SPL_REQ
402: where SPECIAL_REQUIREMENT_CD = X_SPECIAL_REQUIREMENT_CD
403: ;
404:
405: begin

Line 437: delete from IGS_GE_SPL_REQ

433: Before_DML (
434: p_action => 'DELETE',
435: x_rowid => X_ROWID
436: );
437: delete from IGS_GE_SPL_REQ
438: where ROWID = X_ROWID;
439: if (sql%notfound) then
440: raise no_data_found;
441: end if;

Line 449: end IGS_GE_SPL_REQ_PKG;

445: );
446:
447: end DELETE_ROW;
448:
449: end IGS_GE_SPL_REQ_PKG;