APPS.IGS_RE_DFLT_MS_SET_PKG dependencies on IGS_RE_DFLT_MS_SET_ALL

Line 4: old_references IGS_RE_DFLT_MS_SET_ALL%RowType;

1: package body IGS_RE_DFLT_MS_SET_PKG as
2: /* $Header: IGSRI06B.pls 115.7 2002/11/29 03:32:37 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_RE_DFLT_MS_SET_ALL%RowType;
5: new_references IGS_RE_DFLT_MS_SET_ALL%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 5: new_references IGS_RE_DFLT_MS_SET_ALL%RowType;

1: package body IGS_RE_DFLT_MS_SET_PKG as
2: /* $Header: IGSRI06B.pls 115.7 2002/11/29 03:32:37 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_RE_DFLT_MS_SET_ALL%RowType;
5: new_references IGS_RE_DFLT_MS_SET_ALL%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,
9: x_course_cd IN VARCHAR2 DEFAULT NULL,

Line 26: FROM IGS_RE_DFLT_MS_SET_ALL

22: x_org_id IN NUMBER DEFAULT NULL
23: ) AS
24: CURSOR cur_old_ref_values IS
25: SELECT *
26: FROM IGS_RE_DFLT_MS_SET_ALL
27: WHERE rowid = x_rowid;
28: BEGIN
29: l_rowid := x_rowid;
30: -- Code for setting the Old and New Reference Values.

Line 169: FROM IGS_RE_DFLT_MS_SET_ALL

165: ) RETURN BOOLEAN
166: AS
167: CURSOR cur_rowid IS
168: SELECT rowid
169: FROM IGS_RE_DFLT_MS_SET_ALL
170: WHERE course_cd = x_course_cd
171: AND version_number = x_version_number
172: AND milestone_type = x_milestone_type
173: AND attendance_type = x_attendance_type

Line 193: FROM IGS_RE_DFLT_MS_SET_ALL

189: x_attendance_type IN VARCHAR2
190: ) AS
191: CURSOR cur_rowid IS
192: SELECT rowid
193: FROM IGS_RE_DFLT_MS_SET_ALL
194: WHERE attendance_type = x_attendance_type ;
195: lv_rowid cur_rowid%RowType;
196: BEGIN
197: Open cur_rowid;

Line 214: FROM IGS_RE_DFLT_MS_SET_ALL

210: x_version_number IN NUMBER
211: ) AS
212: CURSOR cur_rowid IS
213: SELECT rowid
214: FROM IGS_RE_DFLT_MS_SET_ALL
215: WHERE course_cd = x_course_cd
216: AND version_number = x_version_number ;
217: lv_rowid cur_rowid%RowType;
218: BEGIN

Line 235: FROM IGS_RE_DFLT_MS_SET_ALL

231: x_milestone_type IN VARCHAR2
232: ) AS
233: CURSOR cur_rowid IS
234: SELECT rowid
235: FROM IGS_RE_DFLT_MS_SET_ALL
236: WHERE milestone_type = x_milestone_type ;
237: lv_rowid cur_rowid%RowType;
238: BEGIN
239: Open cur_rowid;

Line 336: cursor C is select ROWID from IGS_RE_DFLT_MS_SET_ALL

332: X_COMMENTS in VARCHAR2,
333: X_MODE in VARCHAR2 default 'R',
334: X_ORG_ID in NUMBER
335: ) as
336: cursor C is select ROWID from IGS_RE_DFLT_MS_SET_ALL
337: where COURSE_CD = X_COURSE_CD
338: and VERSION_NUMBER = X_VERSION_NUMBER
339: and MILESTONE_TYPE = X_MILESTONE_TYPE
340: and ATTENDANCE_TYPE = X_ATTENDANCE_TYPE

Line 383: insert into IGS_RE_DFLT_MS_SET_ALL (

379: x_last_update_date => X_LAST_UPDATE_DATE,
380: x_last_update_login => X_LAST_UPDATE_LOGIN,
381: x_org_id => igs_ge_gen_003.get_org_id
382: );
383: insert into IGS_RE_DFLT_MS_SET_ALL (
384: COURSE_CD,
385: VERSION_NUMBER,
386: MILESTONE_TYPE,
387: ATTENDANCE_TYPE,

Line 436: from IGS_RE_DFLT_MS_SET_ALL

432: ) as
433: cursor c1 is select
434: OFFSET_DAYS,
435: COMMENTS
436: from IGS_RE_DFLT_MS_SET_ALL
437: where ROWID = X_ROWID
438: for update nowait;
439: tlinfo c1%rowtype;
440: begin

Line 513: update IGS_RE_DFLT_MS_SET_ALL set

509: x_last_updated_by => X_LAST_UPDATED_BY,
510: x_last_update_date => X_LAST_UPDATE_DATE,
511: x_last_update_login => X_LAST_UPDATE_LOGIN
512: );
513: update IGS_RE_DFLT_MS_SET_ALL set
514: OFFSET_DAYS = NEW_REFERENCES.OFFSET_DAYS,
515: COMMENTS = NEW_REFERENCES.COMMENTS,
516: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
517: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 538: cursor c1 is select rowid from IGS_RE_DFLT_MS_SET_ALL

534: X_COMMENTS in VARCHAR2,
535: X_MODE in VARCHAR2 default 'R',
536: X_ORG_ID in NUMBER
537: ) as
538: cursor c1 is select rowid from IGS_RE_DFLT_MS_SET_ALL
539: where COURSE_CD = X_COURSE_CD
540: and VERSION_NUMBER = X_VERSION_NUMBER
541: and MILESTONE_TYPE = X_MILESTONE_TYPE
542: and ATTENDANCE_TYPE = X_ATTENDANCE_TYPE

Line 582: delete from IGS_RE_DFLT_MS_SET_ALL

578: procedure DELETE_ROW (
579: X_ROWID in VARCHAR2
580: ) as
581: begin
582: delete from IGS_RE_DFLT_MS_SET_ALL
583: where ROWID = X_ROWID;
584: if (sql%notfound) then
585: raise no_data_found;
586: end if;