APPS.IGS_PS_GOVT_TYPE_PKG dependencies on IGS_PS_GOVT_TYPE

Line 1: package body IGS_PS_GOVT_TYPE_PKG as

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

Line 4: old_references IGS_PS_GOVT_TYPE%RowType;

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

Line 5: new_references IGS_PS_GOVT_TYPE%RowType;

1: package body IGS_PS_GOVT_TYPE_PKG as
2: /* $Header: IGSPI58B.pls 115.3 2002/11/29 02:32:14 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_GOVT_TYPE%RowType;
5: new_references IGS_PS_GOVT_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_TYPE

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

Line 117: IGS_PS_TYPE_PKG.GET_FK_IGS_PS_GOVT_TYPE (

113:
114: PROCEDURE Check_Child_Existance AS
115: BEGIN
116:
117: IGS_PS_TYPE_PKG.GET_FK_IGS_PS_GOVT_TYPE (
118: old_references.govt_course_type
119: );
120:
121: END Check_Child_Existance;

Line 129: FROM IGS_PS_GOVT_TYPE

125: ) RETURN BOOLEAN AS
126:
127: CURSOR cur_rowid IS
128: SELECT rowid
129: FROM IGS_PS_GOVT_TYPE
130: WHERE govt_course_type = x_govt_course_type
131: FOR UPDATE NOWAIT;
132:
133: lv_rowid cur_rowid%RowType;

Line 227: cursor C is select ROWID from IGS_PS_GOVT_TYPE

223: X_DESCRIPTION in VARCHAR2,
224: X_CLOSED_IND in VARCHAR2,
225: X_MODE in VARCHAR2 default 'R'
226: ) as
227: cursor C is select ROWID from IGS_PS_GOVT_TYPE
228: where GOVT_COURSE_TYPE = X_GOVT_COURSE_TYPE;
229: X_LAST_UPDATE_DATE DATE;
230: X_LAST_UPDATED_BY NUMBER;
231: X_LAST_UPDATE_LOGIN NUMBER;

Line 263: insert into IGS_PS_GOVT_TYPE (

259: x_last_updated_by => X_LAST_UPDATED_BY,
260: x_last_update_login => X_LAST_UPDATE_LOGIN
261: );
262:
263: insert into IGS_PS_GOVT_TYPE (
264: GOVT_COURSE_TYPE,
265: DESCRIPTION,
266: CLOSED_IND,
267: CREATION_DATE,

Line 305: from IGS_PS_GOVT_TYPE

301: ) as
302: cursor c1 is select
303: DESCRIPTION,
304: CLOSED_IND
305: from IGS_PS_GOVT_TYPE
306: where ROWID = X_ROWID for update nowait;
307: tlinfo c1%rowtype;
308:
309: begin

Line 374: update IGS_PS_GOVT_TYPE set

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

Line 398: cursor c1 is select rowid from IGS_PS_GOVT_TYPE

394: X_DESCRIPTION in VARCHAR2,
395: X_CLOSED_IND in VARCHAR2,
396: X_MODE in VARCHAR2 default 'R'
397: ) as
398: cursor c1 is select rowid from IGS_PS_GOVT_TYPE
399: where GOVT_COURSE_TYPE = X_GOVT_COURSE_TYPE
400: ;
401: begin
402: open c1;

Line 430: delete from IGS_PS_GOVT_TYPE

426: begin
427: Before_DML( p_action => 'DELETE',
428: x_rowid => X_ROWID
429: );
430: delete from IGS_PS_GOVT_TYPE
431: where ROWID = X_ROWID;
432: if (sql%notfound) then
433: raise no_data_found;
434: end if;

Line 441: end IGS_PS_GOVT_TYPE_PKG;

437: x_rowid => X_ROWID
438: );
439: end DELETE_ROW;
440:
441: end IGS_PS_GOVT_TYPE_PKG;