APPS.IGS_PS_GOVT_SPL_TYPE_PKG dependencies on IGS_PS_GOVT_SPL_TYPE

Line 1: package body IGS_PS_GOVT_SPL_TYPE_PKG as

1: package body IGS_PS_GOVT_SPL_TYPE_PKG as
2: /* $Header: IGSPI60B.pls 115.3 2002/11/29 02:32:48 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_GOVT_SPL_TYPE%RowType;
5: new_references IGS_PS_GOVT_SPL_TYPE%RowType;

Line 4: old_references IGS_PS_GOVT_SPL_TYPE%RowType;

1: package body IGS_PS_GOVT_SPL_TYPE_PKG as
2: /* $Header: IGSPI60B.pls 115.3 2002/11/29 02:32:48 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_GOVT_SPL_TYPE%RowType;
5: new_references IGS_PS_GOVT_SPL_TYPE%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_PS_GOVT_SPL_TYPE%RowType;

1: package body IGS_PS_GOVT_SPL_TYPE_PKG as
2: /* $Header: IGSPI60B.pls 115.3 2002/11/29 02:32:48 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_GOVT_SPL_TYPE%RowType;
5: new_references IGS_PS_GOVT_SPL_TYPE%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 22: FROM IGS_PS_GOVT_SPL_TYPE

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

Line 97: IGS_PS_VER_PKG.GET_FK_IGS_PS_GOVT_SPL_TYPE (

93:
94: PROCEDURE Check_Child_Existance AS
95: BEGIN
96:
97: IGS_PS_VER_PKG.GET_FK_IGS_PS_GOVT_SPL_TYPE (
98: old_references.govt_special_course_type
99: );
100:
101: END Check_Child_Existance;

Line 109: FROM IGS_PS_GOVT_SPL_TYPE

105: ) RETURN BOOLEAN AS
106:
107: CURSOR cur_rowid IS
108: SELECT rowid
109: FROM IGS_PS_GOVT_SPL_TYPE
110: WHERE govt_special_course_type = x_govt_special_course_type
111: FOR UPDATE NOWAIT;
112:
113: lv_rowid cur_rowid%RowType;

Line 211: cursor C is select ROWID from IGS_PS_GOVT_SPL_TYPE

207: X_DESCRIPTION in VARCHAR2,
208: X_CLOSED_IND in VARCHAR2,
209: X_MODE in VARCHAR2 default 'R'
210: ) as
211: cursor C is select ROWID from IGS_PS_GOVT_SPL_TYPE
212: where GOVT_SPECIAL_COURSE_TYPE = X_GOVT_SPECIAL_COURSE_TYPE;
213: X_LAST_UPDATE_DATE DATE;
214: X_LAST_UPDATED_BY NUMBER;
215: X_LAST_UPDATE_LOGIN NUMBER;

Line 248: insert into IGS_PS_GOVT_SPL_TYPE (

244: x_last_updated_by => X_LAST_UPDATED_BY,
245: x_last_update_login => X_LAST_UPDATE_LOGIN
246: );
247:
248: insert into IGS_PS_GOVT_SPL_TYPE (
249: GOVT_SPECIAL_COURSE_TYPE,
250: DESCRIPTION,
251: CLOSED_IND,
252: CREATION_DATE,

Line 291: from IGS_PS_GOVT_SPL_TYPE

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

Line 361: update IGS_PS_GOVT_SPL_TYPE set

357: x_last_updated_by => X_LAST_UPDATED_BY,
358: x_last_update_login => X_LAST_UPDATE_LOGIN
359: );
360:
361: update IGS_PS_GOVT_SPL_TYPE set
362: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
363: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
364: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
365: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 386: cursor c1 is select rowid from IGS_PS_GOVT_SPL_TYPE

382: X_DESCRIPTION in VARCHAR2,
383: X_CLOSED_IND in VARCHAR2,
384: X_MODE in VARCHAR2 default 'R'
385: ) as
386: cursor c1 is select rowid from IGS_PS_GOVT_SPL_TYPE
387: where GOVT_SPECIAL_COURSE_TYPE = X_GOVT_SPECIAL_COURSE_TYPE
388: ;
389: begin
390: open c1;

Line 418: delete from IGS_PS_GOVT_SPL_TYPE

414: begin
415: Before_DML( p_action => 'DELETE',
416: x_rowid => X_ROWID
417: );
418: delete from IGS_PS_GOVT_SPL_TYPE
419: where ROWID = X_ROWID;
420: if (sql%notfound) then
421: raise no_data_found;
422: end if;

Line 430: end IGS_PS_GOVT_SPL_TYPE_PKG;

426: );
427:
428: end DELETE_ROW;
429:
430: end IGS_PS_GOVT_SPL_TYPE_PKG;