APPS.IGS_AS_UNIT_CLASS_PKG dependencies on IGS_AS_UNIT_CLASS_ALL

Line 5: old_references IGS_AS_UNIT_CLASS_ALL%RowType;

1: package body IGS_AS_UNIT_CLASS_PKG as
2: /* $Header: IGSDI34B.pls 120.0 2005/07/05 12:10:42 appldev noship $ */
3: --
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_UNIT_CLASS_ALL%RowType;
6: new_references IGS_AS_UNIT_CLASS_ALL%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 6: new_references IGS_AS_UNIT_CLASS_ALL%RowType;

2: /* $Header: IGSDI34B.pls 120.0 2005/07/05 12:10:42 appldev noship $ */
3: --
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_UNIT_CLASS_ALL%RowType;
6: new_references IGS_AS_UNIT_CLASS_ALL%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,
10: x_org_id IN NUMBER DEFAULT NULL,

Line 26: FROM IGS_AS_UNIT_CLASS_ALL

22: x_last_update_login IN NUMBER DEFAULT NULL
23: ) as
24: CURSOR cur_old_ref_values IS
25: SELECT *
26: FROM IGS_AS_UNIT_CLASS_ALL
27: WHERE rowid = x_rowid;
28: BEGIN
29: l_rowid := x_rowid;
30: -- Code for setting the Old and New Reference Values.

Line 182: FROM IGS_AS_UNIT_CLASS_ALL

178: x_unit_class IN VARCHAR2
179: ) RETURN BOOLEAN AS
180: CURSOR cur_rowid IS
181: SELECT rowid
182: FROM IGS_AS_UNIT_CLASS_ALL
183: WHERE unit_class= x_unit_class;
184: lv_rowid cur_rowid%RowType;
185: BEGIN
186: Open cur_rowid;

Line 201: FROM IGS_AS_UNIT_CLASS_ALL

197: x_unit_mode IN VARCHAR2
198: ) as
199: CURSOR cur_rowid IS
200: SELECT rowid
201: FROM IGS_AS_UNIT_CLASS_ALL
202: WHERE unit_mode= x_unit_mode ;
203: lv_rowid cur_rowid%RowType;
204: BEGIN
205: Open cur_rowid;

Line 294: cursor C is select ROWID from IGS_AS_UNIT_CLASS_ALL

290: X_END_TIME in DATE,
291: X_CLOSED_IND in VARCHAR2,
292: X_MODE in VARCHAR2 default 'R'
293: ) as
294: cursor C is select ROWID from IGS_AS_UNIT_CLASS_ALL
295: where UNIT_CLASS = X_UNIT_CLASS;
296: X_LAST_UPDATE_DATE DATE;
297: X_LAST_UPDATED_BY NUMBER;
298: X_LAST_UPDATE_LOGIN NUMBER;

Line 337: insert into IGS_AS_UNIT_CLASS_ALL (

333: x_last_updated_by=>X_LAST_UPDATED_BY,
334: x_last_update_login=>X_LAST_UPDATE_LOGIN
335: );
336: --
337: insert into IGS_AS_UNIT_CLASS_ALL (
338: ORG_ID,
339: UNIT_CLASS,
340: UNIT_MODE,
341: DESCRIPTION,

Line 393: from IGS_AS_UNIT_CLASS_ALL

389: DAY_OF_WEEK,
390: START_TIME,
391: END_TIME,
392: CLOSED_IND
393: from IGS_AS_UNIT_CLASS_ALL
394: where ROWID = X_ROWID for update nowait;
395: tlinfo c1%rowtype;
396: begin
397: open c1;

Line 479: update IGS_AS_UNIT_CLASS_ALL set

475: x_last_updated_by=>X_LAST_UPDATED_BY,
476: x_last_update_login=>X_LAST_UPDATE_LOGIN
477: );
478: --
479: update IGS_AS_UNIT_CLASS_ALL set
480: UNIT_MODE = NEW_REFERENCES.UNIT_MODE,
481: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
482: DAY_OF_WEEK = NEW_REFERENCES.DAY_OF_WEEK,
483: START_TIME = NEW_REFERENCES.START_TIME,

Line 508: cursor c1 is select rowid from IGS_AS_UNIT_CLASS_ALL

504: X_END_TIME in DATE,
505: X_CLOSED_IND in VARCHAR2,
506: X_MODE in VARCHAR2 default 'R'
507: ) as
508: cursor c1 is select rowid from IGS_AS_UNIT_CLASS_ALL
509: where UNIT_CLASS = X_UNIT_CLASS
510: ;
511: begin
512: open c1;