APPS.IGS_PS_UNT_INLV_HIST_PKG dependencies on IGS_PS_UNT_INLV_HIST_ALL

Line 6: old_references IGS_PS_UNT_INLV_HIST_ALL%RowType;

2: /* $Header: IGSPI80B.pls 115.7 2002/11/29 02:38:39 nsidana ship $ */
3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_PS_UNT_INLV_HIST_ALL%RowType;
7: new_references IGS_PS_UNT_INLV_HIST_ALL%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,

Line 7: new_references IGS_PS_UNT_INLV_HIST_ALL%RowType;

3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_PS_UNT_INLV_HIST_ALL%RowType;
7: new_references IGS_PS_UNT_INLV_HIST_ALL%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,
11: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 29: FROM IGS_PS_UNT_INLV_HIST_ALL

25: ) AS
26:
27: CURSOR cur_old_ref_values IS
28: SELECT *
29: FROM IGS_PS_UNT_INLV_HIST_ALL
30: WHERE rowid = x_rowid;
31:
32: BEGIN
33:

Line 111: FROM IGS_PS_UNT_INLV_HIST_ALL

107: ) RETURN BOOLEAN AS
108:
109: CURSOR cur_rowid IS
110: SELECT rowid
111: FROM IGS_PS_UNT_INLV_HIST_ALL
112: WHERE unit_int_course_level_cd = x_unit_int_course_level_cd
113: AND hist_start_dt = x_hist_start_dt
114: FOR UPDATE NOWAIT;
115:

Line 220: cursor C is select ROWID from IGS_PS_UNT_INLV_HIST_ALL

216: X_CLOSED_IND in VARCHAR2,
217: X_MODE in VARCHAR2 default 'R',
218: X_ORG_ID in NUMBER
219: ) AS
220: cursor C is select ROWID from IGS_PS_UNT_INLV_HIST_ALL
221: where UNIT_INT_COURSE_LEVEL_CD = X_UNIT_INT_COURSE_LEVEL_CD
222: and HIST_START_DT = X_HIST_START_DT;
223: X_LAST_UPDATE_DATE DATE;
224: X_LAST_UPDATED_BY NUMBER;

Line 266: insert into IGS_PS_UNT_INLV_HIST_ALL (

262: x_last_update_login => X_LAST_UPDATE_LOGIN,
263: x_org_id => igs_ge_gen_003.get_org_id
264: );
265:
266: insert into IGS_PS_UNT_INLV_HIST_ALL (
267: UNIT_INT_COURSE_LEVEL_CD,
268: HIST_START_DT,
269: HIST_END_DT,
270: HIST_WHO,

Line 326: from IGS_PS_UNT_INLV_HIST_ALL

322: HIST_WHO,
323: DESCRIPTION,
324: WEFTSU_FACTOR,
325: CLOSED_IND
326: from IGS_PS_UNT_INLV_HIST_ALL
327: where ROWID = X_ROWID
328: for update nowait;
329: tlinfo c1%rowtype;
330:

Line 414: update IGS_PS_UNT_INLV_HIST_ALL set

410: x_last_updated_by => X_LAST_UPDATED_BY,
411: x_last_update_login => X_LAST_UPDATE_LOGIN
412: );
413:
414: update IGS_PS_UNT_INLV_HIST_ALL set
415: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
416: HIST_WHO = NEW_REFERENCES.HIST_WHO,
417: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
418: WEFTSU_FACTOR = NEW_REFERENCES.WEFTSU_FACTOR,

Line 447: cursor c1 is select rowid from IGS_PS_UNT_INLV_HIST_ALL

443: X_CLOSED_IND in VARCHAR2,
444: X_MODE in VARCHAR2 default 'R',
445: X_ORG_ID in NUMBER
446: ) AS
447: cursor c1 is select rowid from IGS_PS_UNT_INLV_HIST_ALL
448: where UNIT_INT_COURSE_LEVEL_CD = X_UNIT_INT_COURSE_LEVEL_CD
449: and HIST_START_DT = X_HIST_START_DT
450: ;
451: begin

Line 491: delete from IGS_PS_UNT_INLV_HIST_ALL

487: Before_DML (
488: p_action => 'DELETE',
489: x_rowid => X_ROWID
490: );
491: delete from IGS_PS_UNT_INLV_HIST_ALL
492: where ROWID = X_ROWID;
493: if (sql%notfound) then
494: raise no_data_found;
495: end if;