APPS.IGS_RE_THS_EXAM_TYPE_PKG dependencies on IGS_RE_THS_EXAM_TYPE

Line 1: package body IGS_RE_THS_EXAM_TYPE_PKG as

1: package body IGS_RE_THS_EXAM_TYPE_PKG as
2: /* $Header: IGSRI20B.pls 115.3 2002/11/29 03:36:59 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RE_THS_EXAM_TYPE%RowType;

Line 5: old_references IGS_RE_THS_EXAM_TYPE%RowType;

1: package body IGS_RE_THS_EXAM_TYPE_PKG as
2: /* $Header: IGSRI20B.pls 115.3 2002/11/29 03:36:59 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RE_THS_EXAM_TYPE%RowType;
6: new_references IGS_RE_THS_EXAM_TYPE%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_RE_THS_EXAM_TYPE%RowType;

2: /* $Header: IGSRI20B.pls 115.3 2002/11/29 03:36:59 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_RE_THS_EXAM_TYPE%RowType;
6: new_references IGS_RE_THS_EXAM_TYPE%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 23: FROM IGS_RE_THS_EXAM_TYPE

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

Line 95: IGS_RE_THESIS_EXAM_PKG.GET_FK_IGS_RE_THS_EXAM_TYPE (

91:
92: PROCEDURE Check_Child_Existance AS
93: BEGIN
94:
95: IGS_RE_THESIS_EXAM_PKG.GET_FK_IGS_RE_THS_EXAM_TYPE (
96: old_references.thesis_exam_type
97: );
98:
99: END Check_Child_Existance;

Line 108: FROM IGS_RE_THS_EXAM_TYPE

104: AS
105:
106: CURSOR cur_rowid IS
107: SELECT rowid
108: FROM IGS_RE_THS_EXAM_TYPE
109: WHERE thesis_exam_type = x_thesis_exam_type
110: FOR UPDATE NOWAIT;
111:
112: lv_rowid cur_rowid%RowType;

Line 197: cursor C is select ROWID from IGS_RE_THS_EXAM_TYPE

193: X_DESCRIPTION in VARCHAR2,
194: X_CLOSED_IND in VARCHAR2,
195: X_MODE in VARCHAR2 default 'R'
196: ) as
197: cursor C is select ROWID from IGS_RE_THS_EXAM_TYPE
198: where THESIS_EXAM_TYPE = X_THESIS_EXAM_TYPE;
199: X_LAST_UPDATE_DATE DATE;
200: X_LAST_UPDATED_BY NUMBER;
201: X_LAST_UPDATE_LOGIN NUMBER;

Line 235: insert into IGS_RE_THS_EXAM_TYPE (

231: x_last_update_date => X_LAST_UPDATE_DATE,
232: x_last_update_login => X_LAST_UPDATE_LOGIN
233: );
234:
235: insert into IGS_RE_THS_EXAM_TYPE (
236: THESIS_EXAM_TYPE,
237: DESCRIPTION,
238: CLOSED_IND,
239: CREATION_DATE,

Line 274: from IGS_RE_THS_EXAM_TYPE

270: ) as
271: cursor c1 is select
272: DESCRIPTION,
273: CLOSED_IND
274: from IGS_RE_THS_EXAM_TYPE
275: where ROWID = X_ROWID
276: for update nowait;
277: tlinfo c1%rowtype;
278:

Line 344: update IGS_RE_THS_EXAM_TYPE set

340: x_last_update_date => X_LAST_UPDATE_DATE,
341: x_last_update_login => X_LAST_UPDATE_LOGIN
342: );
343:
344: update IGS_RE_THS_EXAM_TYPE set
345: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
346: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
347: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
348: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 365: cursor c1 is select rowid from IGS_RE_THS_EXAM_TYPE

361: X_DESCRIPTION in VARCHAR2,
362: X_CLOSED_IND in VARCHAR2,
363: X_MODE in VARCHAR2 default 'R'
364: ) as
365: cursor c1 is select rowid from IGS_RE_THS_EXAM_TYPE
366: where THESIS_EXAM_TYPE = X_THESIS_EXAM_TYPE
367: ;
368: begin
369: open c1;

Line 400: delete from IGS_RE_THS_EXAM_TYPE

396: p_action => 'DELETE',
397: x_rowid => X_ROWID
398: );
399:
400: delete from IGS_RE_THS_EXAM_TYPE
401: where ROWID = X_ROWID;
402: if (sql%notfound) then
403: raise no_data_found;
404: end if;

Line 408: end IGS_RE_THS_EXAM_TYPE_PKG;

404: end if;
405:
406: end DELETE_ROW;
407:
408: end IGS_RE_THS_EXAM_TYPE_PKG;