APPS.IGS_PS_VER_NOTE_PKG dependencies on IGS_PS_VER_NOTE

Line 1: package body IGS_PS_VER_NOTE_PKG AS

1: package body IGS_PS_VER_NOTE_PKG AS
2: /* $Header: IGSPI44B.pls 115.3 2002/11/29 02:28:33 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_VER_NOTE%RowType;

Line 5: old_references IGS_PS_VER_NOTE%RowType;

1: package body IGS_PS_VER_NOTE_PKG AS
2: /* $Header: IGSPI44B.pls 115.3 2002/11/29 02:28:33 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_VER_NOTE%RowType;
6: new_references IGS_PS_VER_NOTE%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_VER_NOTE%RowType;

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

Line 24: FROM IGS_PS_VER_NOTE

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

Line 152: FROM IGS_PS_VER_NOTE

148: ) RETURN BOOLEAN AS
149:
150: CURSOR cur_rowid IS
151: SELECT rowid
152: FROM IGS_PS_VER_NOTE
153: WHERE course_cd = x_course_cd
154: AND version_number = x_version_number
155: AND reference_number = x_reference_number
156: FOR UPDATE NOWAIT;

Line 178: FROM IGS_PS_VER_NOTE

174: ) AS
175:
176: CURSOR cur_rowid IS
177: SELECT rowid
178: FROM IGS_PS_VER_NOTE
179: WHERE crs_note_type = x_crs_note_type ;
180:
181: lv_rowid cur_rowid%RowType;
182:

Line 205: FROM IGS_PS_VER_NOTE

201: ) AS
202:
203: CURSOR cur_rowid IS
204: SELECT rowid
205: FROM IGS_PS_VER_NOTE
206: WHERE course_cd = x_course_cd
207: AND version_number = x_version_number ;
208:
209: lv_rowid cur_rowid%RowType;

Line 232: FROM IGS_PS_VER_NOTE

228: ) AS
229:
230: CURSOR cur_rowid IS
231: SELECT rowid
232: FROM IGS_PS_VER_NOTE
233: WHERE reference_number = x_reference_number ;
234:
235: lv_rowid cur_rowid%RowType;
236:

Line 337: cursor C is select ROWID from IGS_PS_VER_NOTE

333: X_REFERENCE_NUMBER in NUMBER,
334: X_CRS_NOTE_TYPE in VARCHAR2,
335: X_MODE in VARCHAR2 default 'R'
336: ) AS
337: cursor C is select ROWID from IGS_PS_VER_NOTE
338: where COURSE_CD = X_COURSE_CD
339: and VERSION_NUMBER = X_VERSION_NUMBER
340: and REFERENCE_NUMBER = X_REFERENCE_NUMBER;
341: X_LAST_UPDATE_DATE DATE;

Line 376: insert into IGS_PS_VER_NOTE (

372: x_last_update_date => X_LAST_UPDATE_DATE,
373: x_last_updated_by => X_LAST_UPDATED_BY,
374: x_last_update_login => X_LAST_UPDATE_LOGIN
375: );
376: insert into IGS_PS_VER_NOTE (
377: COURSE_CD,
378: VERSION_NUMBER,
379: REFERENCE_NUMBER,
380: CRS_NOTE_TYPE,

Line 421: from IGS_PS_VER_NOTE

417: X_CRS_NOTE_TYPE in VARCHAR2
418: ) AS
419: cursor c1 is select
420: CRS_NOTE_TYPE
421: from IGS_PS_VER_NOTE
422: where ROWID = X_ROWID for update nowait;
423: tlinfo c1%rowtype;
424:
425: begin

Line 491: update IGS_PS_VER_NOTE set

487: x_last_update_date => X_LAST_UPDATE_DATE,
488: x_last_updated_by => X_LAST_UPDATED_BY,
489: x_last_update_login => X_LAST_UPDATE_LOGIN
490: );
491: update IGS_PS_VER_NOTE set
492: CRS_NOTE_TYPE = NEW_REFERENCES.CRS_NOTE_TYPE,
493: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
494: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
495: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 515: cursor c1 is select rowid from IGS_PS_VER_NOTE

511: X_REFERENCE_NUMBER in NUMBER,
512: X_CRS_NOTE_TYPE in VARCHAR2,
513: X_MODE in VARCHAR2 default 'R'
514: ) AS
515: cursor c1 is select rowid from IGS_PS_VER_NOTE
516: where COURSE_CD = X_COURSE_CD
517: and VERSION_NUMBER = X_VERSION_NUMBER
518: and REFERENCE_NUMBER = X_REFERENCE_NUMBER
519: ;

Line 551: delete from IGS_PS_VER_NOTE

547: begin
548: Before_DML( p_action => 'DELETE',
549: x_rowid => X_ROWID
550: );
551: delete from IGS_PS_VER_NOTE
552: where ROWID = X_ROWID;
553: if (sql%notfound) then
554: raise no_data_found;
555: end if;

Line 563: end IGS_PS_VER_NOTE_PKG;

559: );
560:
561: end DELETE_ROW;
562:
563: end IGS_PS_VER_NOTE_PKG;