APPS.IGS_AS_ASSESSOR_TYPE_PKG dependencies on IGS_AS_ASSESSOR_TYPE

Line 1: package body IGS_AS_ASSESSOR_TYPE_PKG as

1: package body IGS_AS_ASSESSOR_TYPE_PKG as
2: /* $Header: IGSDI39B.pls 115.7 2003/05/19 04:43:21 ijeddy ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_ASSESSOR_TYPE%RowType;

Line 5: old_references IGS_AS_ASSESSOR_TYPE%RowType;

1: package body IGS_AS_ASSESSOR_TYPE_PKG as
2: /* $Header: IGSDI39B.pls 115.7 2003/05/19 04:43:21 ijeddy ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_ASSESSOR_TYPE%RowType;
6: new_references IGS_AS_ASSESSOR_TYPE%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_AS_ASSESSOR_TYPE%RowType;

2: /* $Header: IGSDI39B.pls 115.7 2003/05/19 04:43:21 ijeddy ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_ASSESSOR_TYPE%RowType;
6: new_references IGS_AS_ASSESSOR_TYPE%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 24: FROM IGS_AS_ASSESSOR_TYPE

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

Line 66: IGS_AS_ITEM_ASSESSOR_PKG.GET_FK_IGS_AS_ASSESSOR_TYPE (

62:
63: PROCEDURE Check_Child_Existance as
64: BEGIN
65:
66: IGS_AS_ITEM_ASSESSOR_PKG.GET_FK_IGS_AS_ASSESSOR_TYPE (
67: old_references.ass_assessor_type
68: );
69:
70: END Check_Child_Existance;

Line 77: FROM IGS_AS_ASSESSOR_TYPE

73: x_ass_assessor_type IN VARCHAR2
74: ) RETURN BOOLEAN AS
75: CURSOR cur_rowid IS
76: SELECT rowid
77: FROM IGS_AS_ASSESSOR_TYPE
78: WHERE ass_assessor_type = x_ass_assessor_type
79: FOR UPDATE NOWAIT;
80:
81: lv_rowid cur_rowid%RowType;

Line 223: cursor C is select ROWID from IGS_AS_ASSESSOR_TYPE

219: X_DFLT_IND in VARCHAR2,
220: X_CLOSED_IND in VARCHAR2,
221: X_MODE in VARCHAR2 default 'R'
222: ) as
223: cursor C is select ROWID from IGS_AS_ASSESSOR_TYPE
224: where ASS_ASSESSOR_TYPE = X_ASS_ASSESSOR_TYPE;
225: X_LAST_UPDATE_DATE DATE;
226: X_LAST_UPDATED_BY NUMBER;
227: X_LAST_UPDATE_LOGIN NUMBER;

Line 260: insert into IGS_AS_ASSESSOR_TYPE (

256: x_last_update_date=>X_LAST_UPDATE_DATE,
257: x_last_updated_by=>X_LAST_UPDATED_BY,
258: x_last_update_login=>X_LAST_UPDATE_LOGIN
259: );
260: insert into IGS_AS_ASSESSOR_TYPE (
261: ASS_ASSESSOR_TYPE,
262: DESCRIPTION,
263: DFLT_IND,
264: CLOSED_IND,

Line 304: from IGS_AS_ASSESSOR_TYPE

300: cursor c1 is select
301: DESCRIPTION,
302: DFLT_IND,
303: CLOSED_IND
304: from IGS_AS_ASSESSOR_TYPE
305: where ROWID = X_ROWID for update nowait;
306: tlinfo c1%rowtype;
307:
308: begin

Line 376: update IGS_AS_ASSESSOR_TYPE set

372: x_last_update_date=>X_LAST_UPDATE_DATE,
373: x_last_updated_by=>X_LAST_UPDATED_BY,
374: x_last_update_login=>X_LAST_UPDATE_LOGIN
375: );
376: update IGS_AS_ASSESSOR_TYPE set
377: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
378: DFLT_IND = NEW_REFERENCES.DFLT_IND,
379: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
380: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 400: cursor c1 is select rowid from IGS_AS_ASSESSOR_TYPE

396: X_DFLT_IND in VARCHAR2,
397: X_CLOSED_IND in VARCHAR2,
398: X_MODE in VARCHAR2 default 'R'
399: ) as
400: cursor c1 is select rowid from IGS_AS_ASSESSOR_TYPE
401: where ASS_ASSESSOR_TYPE = X_ASS_ASSESSOR_TYPE
402: ;
403: begin
404: open c1;

Line 435: delete from IGS_AS_ASSESSOR_TYPE

431: p_action => 'DELETE',
432: x_rowid => X_ROWID
433: );
434:
435: delete from IGS_AS_ASSESSOR_TYPE
436: where ROWID = X_ROWID;
437: if (sql%notfound) then
438: raise no_data_found;
439: end if;

Line 444: end IGS_AS_ASSESSOR_TYPE_PKG;

440:
441:
442: end DELETE_ROW;
443:
444: end IGS_AS_ASSESSOR_TYPE_PKG;