APPS.IGS_EN_NOTE_TYPE_PKG dependencies on IGS_EN_NOTE_TYPE_ALL

Line 4: old_references IGS_EN_NOTE_TYPE_ALL%RowType;

1: package body IGS_EN_NOTE_TYPE_PKG AS
2: /* $Header: IGSEI21B.pls 120.1 2005/09/08 14:24:25 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_EN_NOTE_TYPE_ALL%RowType;
5: new_references IGS_EN_NOTE_TYPE_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_EN_NOTE_TYPE_ALL%RowType;

1: package body IGS_EN_NOTE_TYPE_PKG AS
2: /* $Header: IGSEI21B.pls 120.1 2005/09/08 14:24:25 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_EN_NOTE_TYPE_ALL%RowType;
5: new_references IGS_EN_NOTE_TYPE_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 23: FROM IGS_EN_NOTE_TYPE_ALL

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

Line 126: FROM IGS_EN_NOTE_TYPE_ALL

122: ) RETURN BOOLEAN AS
123:
124: CURSOR cur_rowid IS
125: SELECT rowid
126: FROM IGS_EN_NOTE_TYPE_ALL
127: WHERE enr_note_type = x_enr_note_type
128: FOR UPDATE NOWAIT;
129:
130: lv_rowid cur_rowid%RowType;

Line 152: FROM IGS_EN_NOTE_TYPE_ALL

148: ) AS
149:
150: CURSOR cur_rowid IS
151: SELECT rowid
152: FROM IGS_EN_NOTE_TYPE_ALL
153: WHERE s_enr_note_type = x_s_enr_note_type ;
154:
155: lv_rowid cur_rowid%RowType;
156:

Line 264: cursor C is select ROWID from IGS_EN_NOTE_TYPE_ALL

260: X_S_ENR_NOTE_TYPE in VARCHAR2,
261: X_MODE in VARCHAR2 default 'R',
262: x_org_id IN NUMBER
263: ) AS
264: cursor C is select ROWID from IGS_EN_NOTE_TYPE_ALL
265: where ENR_NOTE_TYPE = X_ENR_NOTE_TYPE;
266: X_LAST_UPDATE_DATE DATE;
267: X_LAST_UPDATED_BY NUMBER;
268: X_LAST_UPDATE_LOGIN NUMBER;

Line 299: insert into IGS_EN_NOTE_TYPE_ALL (

295: x_last_updated_by => X_LAST_UPDATED_BY,
296: x_last_update_login => X_LAST_UPDATE_LOGIN,
297: x_org_id => igs_ge_gen_003.get_org_id
298: );
299: insert into IGS_EN_NOTE_TYPE_ALL (
300: ENR_NOTE_TYPE,
301: DESCRIPTION,
302: S_ENR_NOTE_TYPE,
303: CREATION_DATE,

Line 344: from IGS_EN_NOTE_TYPE_ALL

340: ) AS
341: cursor c1 is select
342: DESCRIPTION,
343: S_ENR_NOTE_TYPE
344: from IGS_EN_NOTE_TYPE_ALL
345: where ROWID = X_ROWID for update nowait;
346: tlinfo c1%rowtype;
347:
348: begin

Line 413: update IGS_EN_NOTE_TYPE_ALL set

409: x_last_update_date => X_LAST_UPDATE_DATE,
410: x_last_updated_by => X_LAST_UPDATED_BY,
411: x_last_update_login => X_LAST_UPDATE_LOGIN
412: );
413: update IGS_EN_NOTE_TYPE_ALL set
414: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
415: S_ENR_NOTE_TYPE = NEW_REFERENCES.S_ENR_NOTE_TYPE,
416: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
417: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 437: cursor c1 is select rowid from IGS_EN_NOTE_TYPE_ALL

433: X_S_ENR_NOTE_TYPE in VARCHAR2,
434: X_MODE in VARCHAR2 default 'R',
435: x_org_id IN NUMBER
436: ) AS
437: cursor c1 is select rowid from IGS_EN_NOTE_TYPE_ALL
438: where ENR_NOTE_TYPE = X_ENR_NOTE_TYPE
439: ;
440:
441: begin

Line 471: delete from IGS_EN_NOTE_TYPE_ALL

467: Before_DML (
468: p_action => 'DELETE',
469: x_rowid => X_ROWID
470: );
471: delete from IGS_EN_NOTE_TYPE_ALL
472: where ROWID = X_ROWID;
473: if (sql%notfound) then
474: raise no_data_found;
475: end if;