APPS.IGS_GE_MEASUREMENT_PKG dependencies on IGS_GE_MEASUREMENT

Line 1: package body IGS_GE_MEASUREMENT_PKG as

1: package body IGS_GE_MEASUREMENT_PKG as
2: /* $Header: IGSMI02B.pls 115.3 2002/11/29 01:09:30 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_GE_MEASUREMENT%RowType;

Line 5: old_references IGS_GE_MEASUREMENT%RowType;

1: package body IGS_GE_MEASUREMENT_PKG as
2: /* $Header: IGSMI02B.pls 115.3 2002/11/29 01:09:30 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_GE_MEASUREMENT%RowType;
6: new_references IGS_GE_MEASUREMENT%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_GE_MEASUREMENT%RowType;

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

Line 24: FROM IGS_GE_MEASUREMENT

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

Line 104: IGS_GR_AWD_CRMN_PKG.GET_FK_IGS_GE_MEASUREMENT (

100:
101: PROCEDURE Check_Child_Existance as
102: BEGIN
103:
104: IGS_GR_AWD_CRMN_PKG.GET_FK_IGS_GE_MEASUREMENT (
105: old_references.measurement_cd
106: );
107:
108: END Check_Child_Existance;

Line 116: FROM IGS_GE_MEASUREMENT

112: ) RETURN BOOLEAN as
113:
114: CURSOR cur_rowid IS
115: SELECT rowid
116: FROM IGS_GE_MEASUREMENT
117: WHERE measurement_cd = x_measurement_cd
118: FOR UPDATE NOWAIT;
119:
120: lv_rowid cur_rowid%RowType;

Line 227: cursor C is select ROWID from IGS_GE_MEASUREMENT

223: X_MEASUREMENT_TYPE in VARCHAR2,
224: X_CLOSED_IND in VARCHAR2,
225: X_MODE in VARCHAR2 default 'R'
226: ) as
227: cursor C is select ROWID from IGS_GE_MEASUREMENT
228: where MEASUREMENT_CD = X_MEASUREMENT_CD;
229: X_LAST_UPDATE_DATE DATE;
230: X_LAST_UPDATED_BY NUMBER;
231: X_LAST_UPDATE_LOGIN NUMBER;

Line 266: insert into IGS_GE_MEASUREMENT (

262: x_last_update_date => X_LAST_UPDATE_DATE,
263: x_last_update_login => X_LAST_UPDATE_LOGIN
264: );
265:
266: insert into IGS_GE_MEASUREMENT (
267: MEASUREMENT_CD,
268: DESCRIPTION,
269: MEASUREMENT_TYPE,
270: CLOSED_IND,

Line 313: from IGS_GE_MEASUREMENT

309: cursor c1 is select
310: DESCRIPTION,
311: MEASUREMENT_TYPE,
312: CLOSED_IND
313: from IGS_GE_MEASUREMENT
314: where ROWID = X_ROWID
315: for update nowait;
316: tlinfo c1%rowtype;
317:

Line 388: update IGS_GE_MEASUREMENT set

384: x_last_update_date => X_LAST_UPDATE_DATE,
385: x_last_update_login => X_LAST_UPDATE_LOGIN
386: );
387:
388: update IGS_GE_MEASUREMENT set
389: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
390: MEASUREMENT_TYPE = NEW_REFERENCES.MEASUREMENT_TYPE,
391: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
392: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 416: cursor c1 is select rowid from IGS_GE_MEASUREMENT

412: X_MEASUREMENT_TYPE in VARCHAR2,
413: X_CLOSED_IND in VARCHAR2,
414: X_MODE in VARCHAR2 default 'R'
415: ) as
416: cursor c1 is select rowid from IGS_GE_MEASUREMENT
417: where MEASUREMENT_CD = X_MEASUREMENT_CD
418: ;
419:
420: begin

Line 453: delete from IGS_GE_MEASUREMENT

449: p_action => 'DELETE',
450: x_rowid => X_ROWID
451: );
452:
453: delete from IGS_GE_MEASUREMENT
454: where ROWID = X_ROWID;
455: if (sql%notfound) then
456: raise no_data_found;
457: end if;

Line 464: end IGS_GE_MEASUREMENT_PKG;

460: x_rowid => X_ROWID
461: );
462: end DELETE_ROW;
463:
464: end IGS_GE_MEASUREMENT_PKG;