APPS.IGS_GR_GOVT_HNS_LVL_PKG dependencies on IGS_GR_GOVT_HNS_LVL

Line 1: package body IGS_GR_GOVT_HNS_LVL_PKG as

1: package body IGS_GR_GOVT_HNS_LVL_PKG as
2: /* $Header: IGSGI11B.pls 115.5 2003/05/19 04:44:51 ijeddy ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GR_GOVT_HNS_LVL%RowType;
5: new_references IGS_GR_GOVT_HNS_LVL%RowType;

Line 4: old_references IGS_GR_GOVT_HNS_LVL%RowType;

1: package body IGS_GR_GOVT_HNS_LVL_PKG as
2: /* $Header: IGSGI11B.pls 115.5 2003/05/19 04:44:51 ijeddy ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GR_GOVT_HNS_LVL%RowType;
5: new_references IGS_GR_GOVT_HNS_LVL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_GR_GOVT_HNS_LVL%RowType;

1: package body IGS_GR_GOVT_HNS_LVL_PKG as
2: /* $Header: IGSGI11B.pls 115.5 2003/05/19 04:44:51 ijeddy ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GR_GOVT_HNS_LVL%RowType;
5: new_references IGS_GR_GOVT_HNS_LVL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 22: FROM IGS_GR_GOVT_HNS_LVL

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

Line 62: -- ON IGS_GR_GOVT_HNS_LVL

58:
59: -- Trigger description :-
60: -- "OSS_TST".trg_ghl_br_iu
61: -- BEFORE UPDATE
62: -- ON IGS_GR_GOVT_HNS_LVL
63: -- FOR EACH ROW
64:
65: PROCEDURE BeforeRowUpdate1(
66: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 91: IGS_GR_HONOURS_LEVEL_PKG.GET_FK_IGS_GR_GOVT_HNS_LVL (

87:
88: PROCEDURE Check_Child_Existance AS
89: BEGIN
90:
91: IGS_GR_HONOURS_LEVEL_PKG.GET_FK_IGS_GR_GOVT_HNS_LVL (
92: old_references.govt_honours_level
93: );
94:
95: END Check_Child_Existance;

Line 103: FROM IGS_GR_GOVT_HNS_LVL

99: ) RETURN BOOLEAN AS
100:
101: CURSOR cur_rowid IS
102: SELECT rowid
103: FROM IGS_GR_GOVT_HNS_LVL
104: WHERE govt_honours_level = x_govt_honours_level
105: FOR UPDATE NOWAIT;
106:
107: lv_rowid cur_rowid%RowType;

Line 200: cursor C is select ROWID from IGS_GR_GOVT_HNS_LVL

196: X_DESCRIPTION in VARCHAR2,
197: X_CLOSED_IND in VARCHAR2,
198: X_MODE in VARCHAR2 default 'R'
199: ) AS
200: cursor C is select ROWID from IGS_GR_GOVT_HNS_LVL
201: where GOVT_HONOURS_LEVEL = X_GOVT_HONOURS_LEVEL;
202: X_LAST_UPDATE_DATE DATE;
203: X_LAST_UPDATED_BY NUMBER;
204: X_LAST_UPDATE_LOGIN NUMBER;

Line 238: insert into IGS_GR_GOVT_HNS_LVL (

234: x_last_updated_by => X_LAST_UPDATED_BY,
235: x_last_update_login => X_LAST_UPDATE_LOGIN
236: );
237:
238: insert into IGS_GR_GOVT_HNS_LVL (
239: GOVT_HONOURS_LEVEL,
240: DESCRIPTION,
241: CLOSED_IND,
242: CREATION_DATE,

Line 277: from IGS_GR_GOVT_HNS_LVL

273: ) AS
274: cursor c1 is select
275: DESCRIPTION,
276: CLOSED_IND
277: from IGS_GR_GOVT_HNS_LVL
278: where ROWID = X_ROWID for update nowait;
279: tlinfo c1%rowtype;
280:
281: begin

Line 346: update IGS_GR_GOVT_HNS_LVL set

342: x_last_updated_by => X_LAST_UPDATED_BY,
343: x_last_update_login => X_LAST_UPDATE_LOGIN
344: );
345:
346: update IGS_GR_GOVT_HNS_LVL set
347: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
348: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
349: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
350: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 367: cursor c1 is select rowid from IGS_GR_GOVT_HNS_LVL

363: X_DESCRIPTION in VARCHAR2,
364: X_CLOSED_IND in VARCHAR2,
365: X_MODE in VARCHAR2 default 'R'
366: ) AS
367: cursor c1 is select rowid from IGS_GR_GOVT_HNS_LVL
368: where GOVT_HONOURS_LEVEL = X_GOVT_HONOURS_LEVEL
369: ;
370:
371: begin

Line 403: delete from IGS_GR_GOVT_HNS_LVL

399: p_action => 'DELETE',
400: x_rowid => X_ROWID
401: );
402:
403: delete from IGS_GR_GOVT_HNS_LVL
404: where ROWID = X_ROWID;
405: if (sql%notfound) then
406: raise no_data_found;
407: end if;

Line 446: end IGS_GR_GOVT_HNS_LVL_PKG;

442: END IF ;
443:
444: END CHECK_CONSTRAINTS;
445:
446: end IGS_GR_GOVT_HNS_LVL_PKG;