APPS.IGS_PS_UNIT_LEVEL_PKG dependencies on IGS_PS_UNIT_LEVEL_ALL

Line 6: old_references IGS_PS_UNIT_LEVEL_ALL%RowType;

2: /* $Header: IGSPI81B.pls 115.9 2003/10/16 08:30:32 nalkumar ship $ */
3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_PS_UNIT_LEVEL_ALL%RowType;
7: new_references IGS_PS_UNIT_LEVEL_ALL%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,

Line 7: new_references IGS_PS_UNIT_LEVEL_ALL%RowType;

3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_PS_UNIT_LEVEL_ALL%RowType;
7: new_references IGS_PS_UNIT_LEVEL_ALL%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,
11: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 26: FROM IGS_PS_UNIT_LEVEL_ALL

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

Line 112: FROM IGS_PS_UNIT_LEVEL_ALL

108: ) RETURN BOOLEAN AS
109:
110: CURSOR cur_rowid IS
111: SELECT rowid
112: FROM IGS_PS_UNIT_LEVEL_ALL
113: WHERE unit_level = x_unit_level;
114:
115: lv_rowid cur_rowid%RowType;
116:

Line 207: cursor C is select ROWID from IGS_PS_UNIT_LEVEL_ALL

203: X_CLOSED_IND in VARCHAR2,
204: X_MODE in VARCHAR2 default 'R',
205: X_ORG_ID in NUMBER
206: ) AS
207: cursor C is select ROWID from IGS_PS_UNIT_LEVEL_ALL
208: where UNIT_LEVEL = X_UNIT_LEVEL;
209: X_LAST_UPDATE_DATE DATE;
210: X_LAST_UPDATED_BY NUMBER;
211: X_LAST_UPDATE_LOGIN NUMBER;

Line 247: insert into IGS_PS_UNIT_LEVEL_ALL (

243: x_last_update_login => X_LAST_UPDATE_LOGIN,
244: x_org_id => igs_ge_gen_003.get_org_id
245: );
246:
247: insert into IGS_PS_UNIT_LEVEL_ALL (
248: UNIT_LEVEL,
249: DESCRIPTION,
250: WAM_WEIGHTING,
251: CLOSED_IND,

Line 298: from IGS_PS_UNIT_LEVEL_ALL

294: DESCRIPTION,
295: WAM_WEIGHTING,
296: CLOSED_IND
297:
298: from IGS_PS_UNIT_LEVEL_ALL
299: where ROWID = X_ROWID
300: for update nowait;
301: tlinfo c1%rowtype;
302:

Line 377: update IGS_PS_UNIT_LEVEL_ALL set

373: x_last_updated_by => X_LAST_UPDATED_BY,
374: x_last_update_login => X_LAST_UPDATE_LOGIN
375:
376: );
377: update IGS_PS_UNIT_LEVEL_ALL set
378: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
379: WAM_WEIGHTING = NEW_REFERENCES.WAM_WEIGHTING,
380: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
381: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 404: cursor c1 is select rowid from IGS_PS_UNIT_LEVEL_ALL

400: X_CLOSED_IND in VARCHAR2,
401: X_MODE in VARCHAR2 default 'R',
402: X_ORG_ID in NUMBER
403: ) AS
404: cursor c1 is select rowid from IGS_PS_UNIT_LEVEL_ALL
405: where UNIT_LEVEL = X_UNIT_LEVEL
406: ;
407: begin
408: open c1;