APPS.IGS_PS_UNIT_VER_NOTE_PKG dependencies on IGS_PS_UNIT_VER_NOTE

Line 1: package body IGS_PS_UNIT_VER_NOTE_PKG as

1: package body IGS_PS_UNIT_VER_NOTE_PKG as
2: /* $Header: IGSPI94B.pls 115.3 2002/11/29 02:42:57 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_PS_UNIT_VER_NOTE%RowType;
5: new_references IGS_PS_UNIT_VER_NOTE%RowType;

Line 4: old_references IGS_PS_UNIT_VER_NOTE%RowType;

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

Line 5: new_references IGS_PS_UNIT_VER_NOTE%RowType;

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

Line 23: FROM IGS_PS_UNIT_VER_NOTE

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

Line 151: FROM IGS_PS_UNIT_VER_NOTE

147: ) RETURN BOOLEAN AS
148:
149: CURSOR cur_rowid IS
150: SELECT rowid
151: FROM IGS_PS_UNIT_VER_NOTE
152: WHERE unit_cd = x_unit_cd
153: AND version_number = x_version_number
154: AND reference_number = x_reference_number
155: FOR UPDATE NOWAIT;

Line 179: FROM IGS_PS_UNIT_VER_NOTE

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

Line 205: FROM IGS_PS_UNIT_VER_NOTE

201: ) AS
202:
203: CURSOR cur_rowid IS
204: SELECT rowid
205: FROM IGS_PS_UNIT_VER_NOTE
206: WHERE reference_number = x_reference_number ;
207:
208: lv_rowid cur_rowid%RowType;
209:

Line 232: FROM IGS_PS_UNIT_VER_NOTE

228: ) AS
229:
230: CURSOR cur_rowid IS
231: SELECT rowid
232: FROM IGS_PS_UNIT_VER_NOTE
233: WHERE unit_cd = x_unit_cd
234: AND version_number = x_version_number ;
235:
236: lv_rowid cur_rowid%RowType;

Line 333: cursor C is select ROWID from IGS_PS_UNIT_VER_NOTE

329: X_VERSION_NUMBER in NUMBER,
330: X_CRS_NOTE_TYPE in VARCHAR2,
331: X_MODE in VARCHAR2 default 'R'
332: ) AS
333: cursor C is select ROWID from IGS_PS_UNIT_VER_NOTE
334: where UNIT_CD = X_UNIT_CD
335: and REFERENCE_NUMBER = X_REFERENCE_NUMBER
336: and VERSION_NUMBER = X_VERSION_NUMBER;
337: X_LAST_UPDATE_DATE DATE;

Line 374: insert into IGS_PS_UNIT_VER_NOTE (

370: x_last_updated_by => X_LAST_UPDATED_BY,
371: x_last_update_login => X_LAST_UPDATE_LOGIN
372: );
373:
374: insert into IGS_PS_UNIT_VER_NOTE (
375: UNIT_CD,
376: VERSION_NUMBER,
377: REFERENCE_NUMBER,
378: CRS_NOTE_TYPE,

Line 419: from IGS_PS_UNIT_VER_NOTE

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

Line 489: update IGS_PS_UNIT_VER_NOTE set

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

Line 513: cursor c1 is select rowid from IGS_PS_UNIT_VER_NOTE

509: X_VERSION_NUMBER in NUMBER,
510: X_CRS_NOTE_TYPE in VARCHAR2,
511: X_MODE in VARCHAR2 default 'R'
512: ) AS
513: cursor c1 is select rowid from IGS_PS_UNIT_VER_NOTE
514: where UNIT_CD = X_UNIT_CD
515: and REFERENCE_NUMBER = X_REFERENCE_NUMBER
516: and VERSION_NUMBER = X_VERSION_NUMBER
517: ;

Line 550: delete from IGS_PS_UNIT_VER_NOTE

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

Line 562: end IGS_PS_UNIT_VER_NOTE_PKG;

558: );
559:
560: end DELETE_ROW;
561:
562: end IGS_PS_UNIT_VER_NOTE_PKG;