APPS.IGS_PS_UNIT_LVL_HIST_PKG dependencies on IGS_PS_UNIT_LVL_HIST_ALL

Line 5: old_references IGS_PS_UNIT_LVL_HIST_ALL%RowType;

1: package body IGS_PS_UNIT_LVL_HIST_PKG AS
2: /* $Header: IGSPI41B.pls 115.7 2003/11/05 18:39:40 ijeddy ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_UNIT_LVL_HIST_ALL%RowType;
6: new_references IGS_PS_UNIT_LVL_HIST_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_UNIT_LVL_HIST_ALL%RowType;

2: /* $Header: IGSPI41B.pls 115.7 2003/11/05 18:39:40 ijeddy ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_UNIT_LVL_HIST_ALL%RowType;
6: new_references IGS_PS_UNIT_LVL_HIST_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 32: FROM IGS_PS_UNIT_LVL_HIST_ALL

28: ) AS
29:
30: CURSOR cur_old_ref_values IS
31: SELECT *
32: FROM IGS_PS_UNIT_LVL_HIST_ALL
33: WHERE rowid = x_rowid;
34:
35: BEGIN
36:

Line 174: FROM IGS_PS_UNIT_LVL_HIST_ALL

170: ) RETURN BOOLEAN AS
171:
172: CURSOR cur_rowid IS
173: SELECT rowid
174: FROM IGS_PS_UNIT_LVL_HIST_ALL
175: WHERE unit_cd = x_unit_cd
176: AND version_number = x_version_number
177: AND hist_start_dt = x_hist_start_dt
178: AND course_cd = x_course_cd

Line 205: FROM IGS_PS_UNIT_LVL_HIST_ALL

201: ) AS
202:
203: CURSOR cur_rowid IS
204: SELECT rowid
205: FROM IGS_PS_UNIT_LVL_HIST_ALL
206: WHERE unit_cd = x_unit_cd
207: AND version_number = x_version_number ;
208:
209: lv_rowid cur_rowid%RowType;

Line 361: cursor C is select ROWID from IGS_PS_UNIT_LVL_HIST_ALL

357: X_COURSE_CD IN VARCHAR2,
358: X_COURSE_VERSION_NUMBER IN NUMBER
359:
360: ) AS
361: cursor C is select ROWID from IGS_PS_UNIT_LVL_HIST_ALL
362: where UNIT_CD = X_UNIT_CD
363: AND VERSION_NUMBER = X_VERSION_NUMBER
364: AND HIST_START_DT = X_HIST_START_DT
365: AND course_cd = x_course_cd

Line 411: insert into IGS_PS_UNIT_LVL_HIST_ALL (

407: x_course_cd => X_COURSE_CD,
408: x_course_version_number => X_COURSE_VERSION_NUMBER
409:
410: );
411: insert into IGS_PS_UNIT_LVL_HIST_ALL (
412: UNIT_CD,
413: VERSION_NUMBER,
414: HIST_START_DT,
415: HIST_END_DT,

Line 477: from IGS_PS_UNIT_LVL_HIST_ALL

473: HIST_END_DT,
474: HIST_WHO,
475: UNIT_LEVEL,
476: WAM_WEIGHTING
477: from IGS_PS_UNIT_LVL_HIST_ALL
478: where ROWID = X_ROWID for update nowait;
479: tlinfo c1%rowtype;
480:
481: begin

Line 565: update IGS_PS_UNIT_LVL_HIST_ALL set

561: x_course_cd => X_COURSE_CD,
562: x_course_version_number => X_COURSE_VERSION_NUMBER
563:
564: );
565: update IGS_PS_UNIT_LVL_HIST_ALL set
566: HIST_END_DT = NEW_REFERENCES.HIST_END_DT,
567: HIST_WHO = NEW_REFERENCES.HIST_WHO,
568: UNIT_LEVEL = NEW_REFERENCES.UNIT_LEVEL,
569: WAM_WEIGHTING = NEW_REFERENCES.WAM_WEIGHTING,

Line 600: cursor c1 is select rowid from IGS_PS_UNIT_LVL_HIST_ALL

596: X_ORG_ID in NUMBER,
597: X_COURSE_CD VARCHAR2,
598: X_COURSE_VERSION_NUMBER NUMBER
599: ) AS
600: cursor c1 is select rowid from IGS_PS_UNIT_LVL_HIST_ALL
601: where UNIT_CD = X_UNIT_CD
602: and VERSION_NUMBER = X_VERSION_NUMBER
603: and HIST_START_DT = X_HIST_START_DT
604: AND course_cd = x_course_cd

Line 652: delete from IGS_PS_UNIT_LVL_HIST_ALL

648: begin
649: Before_DML( p_action => 'DELETE',
650: x_rowid => X_ROWID
651: );
652: delete from IGS_PS_UNIT_LVL_HIST_ALL
653: where ROWID = X_ROWID;
654: if (sql%notfound) then
655: raise no_data_found;
656: end if;