APPS.IGS_GR_TESTAMUR_TYPE_PKG dependencies on IGS_GR_TESTAMUR_TYPE

Line 1: package body IGS_GR_TESTAMUR_TYPE_PKG as

1: package body IGS_GR_TESTAMUR_TYPE_PKG as
2: /* $Header: IGSGI18B.pls 115.6 2003/05/19 04:46:03 ijeddy ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GR_TESTAMUR_TYPE%RowType;
5: new_references IGS_GR_TESTAMUR_TYPE%RowType;

Line 4: old_references IGS_GR_TESTAMUR_TYPE%RowType;

1: package body IGS_GR_TESTAMUR_TYPE_PKG as
2: /* $Header: IGSGI18B.pls 115.6 2003/05/19 04:46:03 ijeddy ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GR_TESTAMUR_TYPE%RowType;
5: new_references IGS_GR_TESTAMUR_TYPE%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_GR_TESTAMUR_TYPE%RowType;

1: package body IGS_GR_TESTAMUR_TYPE_PKG as
2: /* $Header: IGSGI18B.pls 115.6 2003/05/19 04:46:03 ijeddy ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GR_TESTAMUR_TYPE%RowType;
5: new_references IGS_GR_TESTAMUR_TYPE%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 23: FROM IGS_GR_TESTAMUR_TYPE

19: ) AS
20:
21: CURSOR cur_old_ref_values IS
22: SELECT *
23: FROM IGS_GR_TESTAMUR_TYPE
24: WHERE rowid = x_rowid;
25:
26: BEGIN
27:

Line 63: -- ON IGS_GR_TESTAMUR_TYPE

59:
60: -- Trigger description :-
61: -- "OSS_TST".trg_tt_br_iu
62: -- BEFORE INSERT OR UPDATE
63: -- ON IGS_GR_TESTAMUR_TYPE
64: -- FOR EACH ROW
65:
66: PROCEDURE BeforeRowInsertUpdate1(
67: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 101: IGS_PS_AWD_PKG.GET_FK_IGS_GR_TESTAMUR_TYPE (

97:
98: PROCEDURE Check_Child_Existance AS
99: BEGIN
100:
101: IGS_PS_AWD_PKG.GET_FK_IGS_GR_TESTAMUR_TYPE (
102: old_references.testamur_type
103: );
104:
105: END Check_Child_Existance;

Line 113: FROM IGS_GR_TESTAMUR_TYPE

109: ) RETURN BOOLEAN AS
110:
111: CURSOR cur_rowid IS
112: SELECT rowid
113: FROM IGS_GR_TESTAMUR_TYPE
114: WHERE testamur_type = x_testamur_type
115: FOR UPDATE NOWAIT;
116:
117: lv_rowid cur_rowid%RowType;

Line 183: FROM IGS_GR_TESTAMUR_TYPE

179: ) AS
180:
181: CURSOR cur_rowid IS
182: SELECT rowid
183: FROM IGS_GR_TESTAMUR_TYPE
184: WHERE correspondence_type = x_correspondence_type ;
185:
186: lv_rowid cur_rowid%RowType;
187:

Line 281: cursor C is select ROWID from IGS_GR_TESTAMUR_TYPE

277: X_CORRESPONDENCE_TYPE in VARCHAR2,
278: X_CLOSED_IND in VARCHAR2,
279: X_MODE in VARCHAR2 default 'R'
280: ) AS
281: cursor C is select ROWID from IGS_GR_TESTAMUR_TYPE
282: where TESTAMUR_TYPE = X_TESTAMUR_TYPE;
283: X_LAST_UPDATE_DATE DATE;
284: X_LAST_UPDATED_BY NUMBER;
285: X_LAST_UPDATE_LOGIN NUMBER;

Line 319: insert into IGS_GR_TESTAMUR_TYPE (

315: x_last_updated_by => X_LAST_UPDATED_BY,
316: x_last_update_login => X_LAST_UPDATE_LOGIN
317: );
318:
319: insert into IGS_GR_TESTAMUR_TYPE (
320: TESTAMUR_TYPE,
321: DESCRIPTION,
322: CORRESPONDENCE_TYPE,
323: CLOSED_IND,

Line 362: from IGS_GR_TESTAMUR_TYPE

358: cursor c1 is select
359: DESCRIPTION,
360: CORRESPONDENCE_TYPE,
361: CLOSED_IND
362: from IGS_GR_TESTAMUR_TYPE
363: where ROWID = X_ROWID for update nowait;
364: tlinfo c1%rowtype;
365:
366: begin

Line 433: update IGS_GR_TESTAMUR_TYPE set

429: x_last_updated_by => X_LAST_UPDATED_BY,
430: x_last_update_login => X_LAST_UPDATE_LOGIN
431: );
432:
433: update IGS_GR_TESTAMUR_TYPE set
434: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
435: CORRESPONDENCE_TYPE = NEW_REFERENCES.CORRESPONDENCE_TYPE,
436: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
437: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 456: cursor c1 is select rowid from IGS_GR_TESTAMUR_TYPE

452: X_CORRESPONDENCE_TYPE in VARCHAR2,
453: X_CLOSED_IND in VARCHAR2,
454: X_MODE in VARCHAR2 default 'R'
455: ) AS
456: cursor c1 is select rowid from IGS_GR_TESTAMUR_TYPE
457: where TESTAMUR_TYPE = X_TESTAMUR_TYPE
458: ;
459:
460: begin

Line 494: delete from IGS_GR_TESTAMUR_TYPE

490: p_action => 'DELETE',
491: x_rowid => X_ROWID
492: );
493:
494: delete from IGS_GR_TESTAMUR_TYPE
495: where ROWID = X_ROWID;
496: if (sql%notfound) then
497: raise no_data_found;
498: end if;

Line 502: end IGS_GR_TESTAMUR_TYPE_PKG;

498: end if;
499:
500: end DELETE_ROW;
501:
502: end IGS_GR_TESTAMUR_TYPE_PKG;