APPS.IGS_GR_HONOURS_LEVEL_PKG dependencies on IGS_GR_HONOURS_LEVEL_ALL

Line 4: old_references IGS_GR_HONOURS_LEVEL_ALL%RowType;

1: package body IGS_GR_HONOURS_LEVEL_PKG as
2: /* $Header: IGSGI14B.pls 115.9 2003/02/24 12:08:53 anilk ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GR_HONOURS_LEVEL_ALL%RowType;
5: new_references IGS_GR_HONOURS_LEVEL_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_GR_HONOURS_LEVEL_ALL%RowType;

1: package body IGS_GR_HONOURS_LEVEL_PKG as
2: /* $Header: IGSGI14B.pls 115.9 2003/02/24 12:08:53 anilk ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GR_HONOURS_LEVEL_ALL%RowType;
5: new_references IGS_GR_HONOURS_LEVEL_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 ,

Line 25: FROM IGS_GR_HONOURS_LEVEL_ALL

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

Line 67: -- ON IGS_GR_HONOURS_LEVEL_ALL

63:
64: -- Trigger description :-
65: -- "OSS_TST".trg_hl_br_iu
66: -- BEFORE INSERT OR UPDATE
67: -- ON IGS_GR_HONOURS_LEVEL_ALL
68: -- FOR EACH ROW
69:
70: PROCEDURE BeforeRowInsertUpdate1(
71: p_inserting IN BOOLEAN,

Line 176: FROM IGS_GR_HONOURS_LEVEL_ALL

172: ) RETURN BOOLEAN AS
173:
174: CURSOR cur_rowid IS
175: SELECT rowid
176: FROM IGS_GR_HONOURS_LEVEL_ALL
177: WHERE honours_level = x_honours_level;
178:
179: lv_rowid cur_rowid%RowType;
180:

Line 201: FROM IGS_GR_HONOURS_LEVEL_ALL

197: ) AS
198:
199: CURSOR cur_rowid IS
200: SELECT rowid
201: FROM IGS_GR_HONOURS_LEVEL_ALL
202: WHERE govt_honours_level = x_govt_honours_level ;
203:
204: lv_rowid cur_rowid%RowType;
205:

Line 309: cursor C is select ROWID from IGS_GR_HONOURS_LEVEL_ALL

305: X_CLOSED_IND in VARCHAR2,
306: X_MODE in VARCHAR2 ,
307: X_ORG_ID in NUMBER
308: ) AS
309: cursor C is select ROWID from IGS_GR_HONOURS_LEVEL_ALL
310: where HONOURS_LEVEL = X_HONOURS_LEVEL;
311: X_LAST_UPDATE_DATE DATE;
312: X_LAST_UPDATED_BY NUMBER;
313: X_LAST_UPDATE_LOGIN NUMBER;

Line 349: insert into IGS_GR_HONOURS_LEVEL_ALL (

345: x_last_update_login => X_LAST_UPDATE_LOGIN,
346: x_org_id => igs_ge_gen_003.get_org_id
347: );
348:
349: insert into IGS_GR_HONOURS_LEVEL_ALL (
350: HONOURS_LEVEL,
351: DESCRIPTION,
352: GOVT_HONOURS_LEVEL,
353: RANK,

Line 398: from IGS_GR_HONOURS_LEVEL_ALL

394: DESCRIPTION,
395: GOVT_HONOURS_LEVEL,
396: RANK,
397: CLOSED_IND
398: from IGS_GR_HONOURS_LEVEL_ALL
399: where ROWID = X_ROWID for update nowait;
400: tlinfo c1%rowtype;
401:
402: begin

Line 475: update IGS_GR_HONOURS_LEVEL_ALL set

471: x_last_updated_by => X_LAST_UPDATED_BY,
472: x_last_update_login => X_LAST_UPDATE_LOGIN
473: );
474:
475: update IGS_GR_HONOURS_LEVEL_ALL set
476: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
477: GOVT_HONOURS_LEVEL = NEW_REFERENCES.GOVT_HONOURS_LEVEL,
478: RANK = NEW_REFERENCES.RANK,
479: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,

Line 501: cursor c1 is select rowid from IGS_GR_HONOURS_LEVEL_ALL

497: X_CLOSED_IND in VARCHAR2,
498: X_MODE in VARCHAR2 ,
499: X_ORG_ID in NUMBER
500: ) AS
501: cursor c1 is select rowid from IGS_GR_HONOURS_LEVEL_ALL
502: where HONOURS_LEVEL = X_HONOURS_LEVEL
503: ;
504:
505: begin