eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PS_UNIT_INT_LVL_PKG dependencies on IGS_PS_UNIT_INT_LVL

Line 1: package body IGS_PS_UNIT_INT_LVL_PKG as

1: package body IGS_PS_UNIT_INT_LVL_PKG as
2: /* $Header: IGSPI79B.pls 115.5 2002/11/29 02:38:23 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_UNIT_INT_LVL%RowType;

Line 5: old_references IGS_PS_UNIT_INT_LVL%RowType;

1: package body IGS_PS_UNIT_INT_LVL_PKG as
2: /* $Header: IGSPI79B.pls 115.5 2002/11/29 02:38:23 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_UNIT_INT_LVL%RowType;
6: new_references IGS_PS_UNIT_INT_LVL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_UNIT_INT_LVL%RowType;

2: /* $Header: IGSPI79B.pls 115.5 2002/11/29 02:38:23 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_UNIT_INT_LVL%RowType;
6: new_references IGS_PS_UNIT_INT_LVL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 24: FROM IGS_PS_UNIT_INT_LVL

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

Line 67: v_description IGS_PS_UNIT_INT_LVL.description%TYPE DEFAULT NULL;

63: p_inserting IN BOOLEAN DEFAULT FALSE,
64: p_updating IN BOOLEAN DEFAULT FALSE,
65: p_deleting IN BOOLEAN DEFAULT FALSE
66: ) AS
67: v_description IGS_PS_UNIT_INT_LVL.description%TYPE DEFAULT NULL;
68: v_weftsu_factor IGS_PS_UNIT_INT_LVL.weftsu_factor%TYPE DEFAULT NULL;
69: v_closed_ind IGS_PS_UNIT_INT_LVL.closed_ind%TYPE DEFAULT NULL;
70:
71: x_rowid VARCHAR2(25);

Line 68: v_weftsu_factor IGS_PS_UNIT_INT_LVL.weftsu_factor%TYPE DEFAULT NULL;

64: p_updating IN BOOLEAN DEFAULT FALSE,
65: p_deleting IN BOOLEAN DEFAULT FALSE
66: ) AS
67: v_description IGS_PS_UNIT_INT_LVL.description%TYPE DEFAULT NULL;
68: v_weftsu_factor IGS_PS_UNIT_INT_LVL.weftsu_factor%TYPE DEFAULT NULL;
69: v_closed_ind IGS_PS_UNIT_INT_LVL.closed_ind%TYPE DEFAULT NULL;
70:
71: x_rowid VARCHAR2(25);
72: l_org_id NUMBER(15);

Line 69: v_closed_ind IGS_PS_UNIT_INT_LVL.closed_ind%TYPE DEFAULT NULL;

65: p_deleting IN BOOLEAN DEFAULT FALSE
66: ) AS
67: v_description IGS_PS_UNIT_INT_LVL.description%TYPE DEFAULT NULL;
68: v_weftsu_factor IGS_PS_UNIT_INT_LVL.weftsu_factor%TYPE DEFAULT NULL;
69: v_closed_ind IGS_PS_UNIT_INT_LVL.closed_ind%TYPE DEFAULT NULL;
70:
71: x_rowid VARCHAR2(25);
72: l_org_id NUMBER(15);
73: CURSOR SPUIH_CUR IS

Line 115: -- Delete IGS_PS_UNT_INLV_HIST records if the IGS_PS_UNIT_INT_LVL

111:
112: END IF;
113: END IF;
114: IF p_deleting THEN
115: -- Delete IGS_PS_UNT_INLV_HIST records if the IGS_PS_UNIT_INT_LVL
116: -- is deleted.
117: BEGIN
118: FOR SPUIH_Rec IN SPUIH_CUR
119: Loop

Line 175: IGS_AD_SBMAO_FN_UITT_PKG.GET_FK_IGS_PS_UNIT_INT_LVL (

171:
172: PROCEDURE Check_Child_Existance AS
173: BEGIN
174:
175: IGS_AD_SBMAO_FN_UITT_PKG.GET_FK_IGS_PS_UNIT_INT_LVL (
176: old_references.unit_int_course_level_cd
177: );
178:
179: IGS_PS_UNIT_VER_PKG.GET_FK_IGS_PS_UNIT_INT_LVL (

Line 179: IGS_PS_UNIT_VER_PKG.GET_FK_IGS_PS_UNIT_INT_LVL (

175: IGS_AD_SBMAO_FN_UITT_PKG.GET_FK_IGS_PS_UNIT_INT_LVL (
176: old_references.unit_int_course_level_cd
177: );
178:
179: IGS_PS_UNIT_VER_PKG.GET_FK_IGS_PS_UNIT_INT_LVL (
180: old_references.unit_int_course_level_cd
181: );
182:
183: END Check_Child_Existance;

Line 191: FROM IGS_PS_UNIT_INT_LVL

187: ) RETURN BOOLEAN AS
188:
189: CURSOR cur_rowid IS
190: SELECT rowid
191: FROM IGS_PS_UNIT_INT_LVL
192: WHERE unit_int_course_level_cd = x_unit_int_course_level_cd
193: FOR UPDATE NOWAIT;
194:
195: lv_rowid cur_rowid%RowType;

Line 290: cursor C is select ROWID from IGS_PS_UNIT_INT_LVL

286: X_WEFTSU_FACTOR in NUMBER,
287: X_CLOSED_IND in VARCHAR2,
288: X_MODE in VARCHAR2 default 'R'
289: ) AS
290: cursor C is select ROWID from IGS_PS_UNIT_INT_LVL
291: where UNIT_INT_COURSE_LEVEL_CD = X_UNIT_INT_COURSE_LEVEL_CD;
292: X_LAST_UPDATE_DATE DATE;
293: X_LAST_UPDATED_BY NUMBER;
294: X_LAST_UPDATE_LOGIN NUMBER;

Line 329: insert into IGS_PS_UNIT_INT_LVL (

325: x_last_updated_by => X_LAST_UPDATED_BY,
326: x_last_update_login => X_LAST_UPDATE_LOGIN
327: );
328:
329: insert into IGS_PS_UNIT_INT_LVL (
330: UNIT_INT_COURSE_LEVEL_CD,
331: DESCRIPTION,
332: WEFTSU_FACTOR,
333: CLOSED_IND,

Line 376: from IGS_PS_UNIT_INT_LVL

372: cursor c1 is select
373: DESCRIPTION,
374: WEFTSU_FACTOR,
375: CLOSED_IND
376: from IGS_PS_UNIT_INT_LVL
377: where ROWID = X_ROWID
378: for update nowait;
379: tlinfo c1%rowtype;
380:

Line 451: update IGS_PS_UNIT_INT_LVL set

447: x_last_updated_by => X_LAST_UPDATED_BY,
448: x_last_update_login => X_LAST_UPDATE_LOGIN
449: );
450:
451: update IGS_PS_UNIT_INT_LVL set
452: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
453: WEFTSU_FACTOR = NEW_REFERENCES.WEFTSU_FACTOR,
454: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
455: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 478: cursor c1 is select rowid from IGS_PS_UNIT_INT_LVL

474: X_WEFTSU_FACTOR in NUMBER,
475: X_CLOSED_IND in VARCHAR2,
476: X_MODE in VARCHAR2 default 'R'
477: ) AS
478: cursor c1 is select rowid from IGS_PS_UNIT_INT_LVL
479: where UNIT_INT_COURSE_LEVEL_CD = X_UNIT_INT_COURSE_LEVEL_CD
480: ;
481: begin
482: open c1;

Line 513: delete from IGS_PS_UNIT_INT_LVL

509: Before_DML (
510: p_action => 'DELETE',
511: x_rowid => X_ROWID
512: );
513: delete from IGS_PS_UNIT_INT_LVL
514: where ROWID = X_ROWID;
515: if (sql%notfound) then
516: raise no_data_found;
517: end if;

Line 525: end IGS_PS_UNIT_INT_LVL_PKG;

521: );
522:
523: end DELETE_ROW;
524:
525: end IGS_PS_UNIT_INT_LVL_PKG;