APPS.IGS_AS_EXM_MTRL_TYPE_PKG dependencies on IGS_AS_EXM_MTRL_TYPE

Line 1: package body IGS_AS_EXM_MTRL_TYPE_PKG as

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

Line 5: old_references IGS_AS_EXM_MTRL_TYPE%RowType;

1: package body IGS_AS_EXM_MTRL_TYPE_PKG as
2: /* $Header: IGSDI43B.pls 115.7 2003/05/19 04:43:37 ijeddy ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_EXM_MTRL_TYPE%RowType;
6: new_references IGS_AS_EXM_MTRL_TYPE%RowType;
7:
8:
9: PROCEDURE Set_Column_Values (

Line 6: new_references IGS_AS_EXM_MTRL_TYPE%RowType;

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

Line 25: FROM IGS_AS_EXM_MTRL_TYPE

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

Line 67: IGS_AS_ITM_EXAM_MTRL_PKG.GET_FK_IGS_AS_EXM_MTRL_TYPE (

63:
64: PROCEDURE Check_Child_Existance as
65: BEGIN
66:
67: IGS_AS_ITM_EXAM_MTRL_PKG.GET_FK_IGS_AS_EXM_MTRL_TYPE (
68: OLD_references.exam_material_type
69: );
70:
71: END Check_Child_Existance;

Line 78: FROM IGS_AS_EXM_MTRL_TYPE

74: x_exam_material_type IN VARCHAR2
75: ) RETURN BOOLEAN AS
76: CURSOR cur_rowid IS
77: SELECT rowid
78: FROM IGS_AS_EXM_MTRL_TYPE
79: WHERE exam_material_type = x_exam_material_type
80: FOR UPDATE NOWAIT;
81:
82: lv_rowid cur_rowid%RowType;

Line 221: cursor C is select ROWID from IGS_AS_EXM_MTRL_TYPE

217: X_CLOSED_IND in VARCHAR2,
218: X_COMMENTS in VARCHAR2,
219: X_MODE in VARCHAR2 default 'R'
220: ) as
221: cursor C is select ROWID from IGS_AS_EXM_MTRL_TYPE
222: where EXAM_MATERIAL_TYPE = X_EXAM_MATERIAL_TYPE;
223: X_LAST_UPDATE_DATE DATE;
224: X_LAST_UPDATED_BY NUMBER;
225: X_LAST_UPDATE_LOGIN NUMBER;

Line 259: insert into IGS_AS_EXM_MTRL_TYPE (

255: x_last_updated_by=>X_LAST_UPDATED_BY,
256: x_last_update_login=>X_LAST_UPDATE_LOGIN
257: );
258:
259: insert into IGS_AS_EXM_MTRL_TYPE (
260: EXAM_MATERIAL_TYPE,
261: DESCRIPTION,
262: CLOSED_IND,
263: COMMENTS,

Line 301: from IGS_AS_EXM_MTRL_TYPE

297: cursor c1 is select
298: DESCRIPTION,
299: CLOSED_IND,
300: COMMENTS
301: from IGS_AS_EXM_MTRL_TYPE
302: where ROWID = X_ROWID for update nowait;
303: tlinfo c1%rowtype;
304:
305: begin

Line 376: update IGS_AS_EXM_MTRL_TYPE set

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

Line 399: cursor c1 is select rowid from IGS_AS_EXM_MTRL_TYPE

395: X_CLOSED_IND in VARCHAR2,
396: X_COMMENTS in VARCHAR2,
397: X_MODE in VARCHAR2 default 'R'
398: ) as
399: cursor c1 is select rowid from IGS_AS_EXM_MTRL_TYPE
400: where EXAM_MATERIAL_TYPE = X_EXAM_MATERIAL_TYPE
401: ;
402: begin
403: open c1;

Line 433: delete from IGS_AS_EXM_MTRL_TYPE

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

Line 441: end IGS_AS_EXM_MTRL_TYPE_PKG;

437: end if;
438:
439: end DELETE_ROW;
440:
441: end IGS_AS_EXM_MTRL_TYPE_PKG;