APPS.IGS_RE_THESIS_RESULT_PKG dependencies on IGS_RE_THESIS_RESULT_ALL

Line 4: old_references IGS_RE_THESIS_RESULT_ALL%RowType;

1: package body IGS_RE_THESIS_RESULT_PKG as
2: /* $Header: IGSRI18B.pls 115.6 2002/11/29 03:36:27 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_RE_THESIS_RESULT_ALL%RowType;
5: new_references IGS_RE_THESIS_RESULT_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_RE_THESIS_RESULT_ALL%RowType;

1: package body IGS_RE_THESIS_RESULT_PKG as
2: /* $Header: IGSRI18B.pls 115.6 2002/11/29 03:36:27 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_RE_THESIS_RESULT_ALL%RowType;
5: new_references IGS_RE_THESIS_RESULT_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 25: FROM IGS_RE_THESIS_RESULT_ALL

21: ) AS
22:
23: CURSOR cur_old_ref_values IS
24: SELECT *
25: FROM IGS_RE_THESIS_RESULT_ALL
26: WHERE rowid = x_rowid;
27:
28: BEGIN
29:

Line 147: FROM IGS_RE_THESIS_RESULT_ALL

143: ) RETURN BOOLEAN AS
144:
145: CURSOR cur_rowid IS
146: SELECT rowid
147: FROM IGS_RE_THESIS_RESULT_ALL
148: WHERE thesis_result_cd = x_thesis_result_cd
149: FOR UPDATE NOWAIT;
150:
151: lv_rowid cur_rowid%RowType;

Line 172: FROM IGS_RE_THESIS_RESULT_ALL

168: ) AS
169:
170: CURSOR cur_rowid IS
171: SELECT rowid
172: FROM IGS_RE_THESIS_RESULT_ALL
173: WHERE s_thesis_result_cd = x_s_thesis_result_cd ;
174:
175: lv_rowid cur_rowid%RowType;
176:

Line 269: cursor C is select ROWID from IGS_RE_THESIS_RESULT_ALL

265: X_COMMENTS in VARCHAR2,
266: X_MODE in VARCHAR2 default 'R',
267: X_ORG_ID in NUMBER
268: ) as
269: cursor C is select ROWID from IGS_RE_THESIS_RESULT_ALL
270: where THESIS_RESULT_CD = X_THESIS_RESULT_CD;
271: X_LAST_UPDATE_DATE DATE;
272: X_LAST_UPDATED_BY NUMBER;
273: X_LAST_UPDATE_LOGIN NUMBER;

Line 309: insert into IGS_RE_THESIS_RESULT_ALL (

305: x_last_updated_by => X_LAST_UPDATED_BY,
306: x_last_update_date => X_LAST_UPDATE_DATE ,
307: x_org_id => igs_ge_gen_003.get_org_id );
308:
309: insert into IGS_RE_THESIS_RESULT_ALL (
310: THESIS_RESULT_CD,
311: DESCRIPTION,
312: S_THESIS_RESULT_CD,
313: CLOSED_IND,

Line 358: from IGS_RE_THESIS_RESULT_ALL

354: DESCRIPTION,
355: S_THESIS_RESULT_CD,
356: CLOSED_IND,
357: COMMENTS
358: from IGS_RE_THESIS_RESULT_ALL
359: where ROWID = X_ROWID
360: for update nowait;
361: tlinfo c1%rowtype;
362:

Line 436: update IGS_RE_THESIS_RESULT_ALL set

432: x_last_updated_by => X_LAST_UPDATED_BY,
433: x_last_update_date => X_LAST_UPDATE_DATE
434: );
435:
436: update IGS_RE_THESIS_RESULT_ALL set
437: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
438: S_THESIS_RESULT_CD = NEW_REFERENCES.S_THESIS_RESULT_CD,
439: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
440: COMMENTS = NEW_REFERENCES.COMMENTS,

Line 462: cursor c1 is select rowid from IGS_RE_THESIS_RESULT_ALL

458: X_COMMENTS in VARCHAR2,
459: X_MODE in VARCHAR2 default 'R',
460: X_ORG_ID in NUMBER
461: ) as
462: cursor c1 is select rowid from IGS_RE_THESIS_RESULT_ALL
463: where THESIS_RESULT_CD = X_THESIS_RESULT_CD
464: ;
465: begin
466: open c1;

Line 502: delete from IGS_RE_THESIS_RESULT_ALL

498: p_action => 'DELETE',
499: x_rowid => X_ROWID
500: );
501:
502: delete from IGS_RE_THESIS_RESULT_ALL
503: where ROWID = X_ROWID;
504: if (sql%notfound) then
505: raise no_data_found;
506: end if;