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_LVL_PKG dependencies on IGS_PS_UNIT_LVL_ALL

Line 5: old_references IGS_PS_UNIT_LVL_ALL%RowType;

1: package body IGS_PS_UNIT_LVL_PKG AS
2: /* $Header: IGSPI40B.pls 115.10 2003/11/07 12:55:30 nalkumar ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_UNIT_LVL_ALL%RowType;
6: new_references IGS_PS_UNIT_LVL_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_UNIT_LVL_ALL%RowType;

2: /* $Header: IGSPI40B.pls 115.10 2003/11/07 12:55:30 nalkumar ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_UNIT_LVL_ALL%RowType;
6: new_references IGS_PS_UNIT_LVL_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 28: FROM IGS_PS_UNIT_LVL_ALL

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

Line 77: v_unit_cd IGS_PS_UNIT_LVL_ALL.unit_cd%TYPE;

73: p_inserting IN BOOLEAN DEFAULT FALSE,
74: p_updating IN BOOLEAN DEFAULT FALSE,
75: p_deleting IN BOOLEAN DEFAULT FALSE
76: ) AS
77: v_unit_cd IGS_PS_UNIT_LVL_ALL.unit_cd%TYPE;
78: v_version_number IGS_PS_UNIT_LVL_ALL.version_number%TYPE;
79: v_unit_level IGS_PS_UNIT_LVL_ALL.unit_level%TYPE;
80: v_wam_weighting IGS_PS_UNIT_LVL_ALL.wam_weighting%TYPE;
81: v_message_name VARCHAR2(30);

Line 78: v_version_number IGS_PS_UNIT_LVL_ALL.version_number%TYPE;

74: p_updating IN BOOLEAN DEFAULT FALSE,
75: p_deleting IN BOOLEAN DEFAULT FALSE
76: ) AS
77: v_unit_cd IGS_PS_UNIT_LVL_ALL.unit_cd%TYPE;
78: v_version_number IGS_PS_UNIT_LVL_ALL.version_number%TYPE;
79: v_unit_level IGS_PS_UNIT_LVL_ALL.unit_level%TYPE;
80: v_wam_weighting IGS_PS_UNIT_LVL_ALL.wam_weighting%TYPE;
81: v_message_name VARCHAR2(30);
82: BEGIN

Line 79: v_unit_level IGS_PS_UNIT_LVL_ALL.unit_level%TYPE;

75: p_deleting IN BOOLEAN DEFAULT FALSE
76: ) AS
77: v_unit_cd IGS_PS_UNIT_LVL_ALL.unit_cd%TYPE;
78: v_version_number IGS_PS_UNIT_LVL_ALL.version_number%TYPE;
79: v_unit_level IGS_PS_UNIT_LVL_ALL.unit_level%TYPE;
80: v_wam_weighting IGS_PS_UNIT_LVL_ALL.wam_weighting%TYPE;
81: v_message_name VARCHAR2(30);
82: BEGIN
83: -- Set variables.

Line 80: v_wam_weighting IGS_PS_UNIT_LVL_ALL.wam_weighting%TYPE;

76: ) AS
77: v_unit_cd IGS_PS_UNIT_LVL_ALL.unit_cd%TYPE;
78: v_version_number IGS_PS_UNIT_LVL_ALL.version_number%TYPE;
79: v_unit_level IGS_PS_UNIT_LVL_ALL.unit_level%TYPE;
80: v_wam_weighting IGS_PS_UNIT_LVL_ALL.wam_weighting%TYPE;
81: v_message_name VARCHAR2(30);
82: BEGIN
83: -- Set variables.
84: IF p_deleting THEN

Line 160: FROM igs_ps_unit_lvl_all

156: x_course_version_number IN NUMBER
157: ) AS
158: CURSOR cur_rowid IS
159: SELECT rowid
160: FROM igs_ps_unit_lvl_all
161: WHERE course_cd = x_course_cd
162: AND course_version_number = x_course_version_number;
163: lv_rowid cur_rowid%RowType;
164: BEGIN

Line 281: FROM IGS_PS_UNIT_LVL_ALL

277: ) RETURN BOOLEAN AS
278:
279: CURSOR cur_rowid IS
280: SELECT rowid
281: FROM IGS_PS_UNIT_LVL_ALL
282: WHERE unit_cd = x_unit_cd
283: AND version_number = x_version_number
284: AND course_cd = x_course_cd
285: AND course_version_number = x_course_version_number

Line 311: FROM IGS_PS_UNIT_LVL_ALL

307: ) AS
308:
309: CURSOR cur_rowid IS
310: SELECT rowid
311: FROM IGS_PS_UNIT_LVL_ALL
312: WHERE unit_cd = x_unit_cd
313: AND version_number = x_version_number ;
314:
315: lv_rowid cur_rowid%RowType;

Line 431: FROM igs_ps_unit_lvl_all

427: X_COURSE_VERSION_NUMBER IN NUMBER
428: ) AS
429: CURSOR C IS
430: SELECT ROWID
431: FROM igs_ps_unit_lvl_all
432: WHERE unit_cd = x_unit_cd
433: AND version_number = x_version_number
434: AND course_cd = x_course_cd
435: AND course_version_number = x_course_version_number;

Line 476: insert into IGS_PS_UNIT_LVL_ALL (

472: x_course_cd => X_COURSE_CD,
473: x_course_version_number => X_COURSE_VERSION_NUMBER
474: );
475:
476: insert into IGS_PS_UNIT_LVL_ALL (
477: UNIT_CD,
478: VERSION_NUMBER,
479: UNIT_LEVEL,
480: WAM_WEIGHTING,

Line 531: from IGS_PS_UNIT_LVL_ALL

527: ) AS
528: cursor c1 is select
529: UNIT_LEVEL,
530: WAM_WEIGHTING
531: from IGS_PS_UNIT_LVL_ALL
532: where ROWID = X_ROWID for update nowait;
533: tlinfo c1%rowtype;
534:
535: begin

Line 609: update IGS_PS_UNIT_LVL_ALL set

605: x_last_update_login => X_LAST_UPDATE_LOGIN,
606: x_course_cd => X_COURSE_CD,
607: x_course_version_number => X_COURSE_VERSION_NUMBER
608: );
609: update IGS_PS_UNIT_LVL_ALL set
610: UNIT_LEVEL = NEW_REFERENCES.UNIT_LEVEL,
611: WAM_WEIGHTING = NEW_REFERENCES.WAM_WEIGHTING,
612: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
613: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 641: FROM igs_ps_unit_lvl_all

637: X_COURSE_VERSION_NUMBER NUMBER
638: ) AS
639: CURSOR c1 IS
640: SELECT rowid
641: FROM igs_ps_unit_lvl_all
642: WHERE unit_cd = x_unit_cd
643: AND version_number = x_version_number
644: AND course_cd = x_course_cd
645: AND course_version_number = x_course_version_number;

Line 684: delete from IGS_PS_UNIT_LVL_ALL

680: begin
681: Before_DML( p_action => 'DELETE',
682: x_rowid => X_ROWID
683: );
684: delete from IGS_PS_UNIT_LVL_ALL
685: where ROWID = X_ROWID;
686: if (sql%notfound) then
687: raise no_data_found;
688: end if;