APPS.IGS_AS_EXM_SUPRVISOR_PKG dependencies on IGS_AS_EXM_SUPRVISOR_ALL

Line 5: old_references IGS_AS_EXM_SUPRVISOR_ALL%RowType;

1: package body IGS_AS_EXM_SUPRVISOR_PKG as
2: /* $Header: IGSDI42B.pls 115.10 2002/12/23 07:08:50 ddey ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_EXM_SUPRVISOR_ALL%RowType;
6: new_references IGS_AS_EXM_SUPRVISOR_ALL%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 6: new_references IGS_AS_EXM_SUPRVISOR_ALL%RowType;

2: /* $Header: IGSDI42B.pls 115.10 2002/12/23 07:08:50 ddey ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_EXM_SUPRVISOR_ALL%RowType;
6: new_references IGS_AS_EXM_SUPRVISOR_ALL%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,
10: x_org_id IN NUMBER DEFAULT NULL,

Line 26: FROM IGS_AS_EXM_SUPRVISOR_ALL

22: ) as
23:
24: CURSOR cur_old_ref_values IS
25: SELECT *
26: FROM IGS_AS_EXM_SUPRVISOR_ALL
27: WHERE rowid = x_rowid;
28:
29: BEGIN
30:

Line 209: FROM IGS_AS_EXM_SUPRVISOR_ALL

205: x_person_id IN NUMBER
206: ) RETURN BOOLEAN AS
207: CURSOR cur_rowid IS
208: SELECT rowid
209: FROM IGS_AS_EXM_SUPRVISOR_ALL
210: WHERE person_id = x_person_id
211: FOR UPDATE NOWAIT;
212:
213: lv_rowid cur_rowid%RowType;

Line 235: FROM IGS_AS_EXM_SUPRVISOR_ALL

231: ) as
232:
233: CURSOR cur_rowid IS
234: SELECT rowid
235: FROM IGS_AS_EXM_SUPRVISOR_ALL
236: WHERE exam_supervisor_type = x_exam_supervisor_type ;
237:
238: lv_rowid cur_rowid%RowType;
239:

Line 262: FROM IGS_AS_EXM_SUPRVISOR_ALL

258: ) as
259:
260: CURSOR cur_rowid IS
261: SELECT rowid
262: FROM IGS_AS_EXM_SUPRVISOR_ALL
263: WHERE responsible_org_unit_cd = x_org_unit_cd
264: AND responsible_ou_start_dt = x_start_dt ;
265:
266: lv_rowid cur_rowid%RowType;

Line 289: FROM IGS_AS_EXM_SUPRVISOR_ALL

285: ) as
286:
287: CURSOR cur_rowid IS
288: SELECT rowid
289: FROM IGS_AS_EXM_SUPRVISOR_ALL
290: WHERE person_id = x_person_id ;
291:
292: lv_rowid cur_rowid%RowType;
293:

Line 397: cursor C is select ROWID from IGS_AS_EXM_SUPRVISOR_ALL

393: X_RESPONSIBLE_OU_START_DT in DATE,
394: X_COMMENTS in VARCHAR2,
395: X_MODE in VARCHAR2 default 'R'
396: ) as
397: cursor C is select ROWID from IGS_AS_EXM_SUPRVISOR_ALL
398: where PERSON_ID = X_PERSON_ID;
399: X_LAST_UPDATE_DATE DATE;
400: X_LAST_UPDATED_BY NUMBER;
401: X_LAST_UPDATE_LOGIN NUMBER;

Line 437: insert into IGS_AS_EXM_SUPRVISOR_ALL (

433: x_last_update_date=>X_LAST_UPDATE_DATE,
434: x_last_updated_by=>X_LAST_UPDATED_BY,
435: x_last_update_login=>X_LAST_UPDATE_LOGIN
436: );
437: insert into IGS_AS_EXM_SUPRVISOR_ALL (
438: ORG_ID,
439: PERSON_ID,
440: EXAM_SUPERVISOR_TYPE,
441: PREVIOUS_SESSIONS,

Line 489: from IGS_AS_EXM_SUPRVISOR_ALL

485: PREVIOUS_SESSIONS,
486: RESPONSIBLE_ORG_UNIT_CD,
487: RESPONSIBLE_OU_START_DT,
488: COMMENTS
489: from IGS_AS_EXM_SUPRVISOR_ALL
490: where ROWID = X_ROWID for update nowait;
491: tlinfo c1%rowtype;
492:
493: begin

Line 575: update IGS_AS_EXM_SUPRVISOR_ALL set

571: x_last_update_date=>X_LAST_UPDATE_DATE,
572: x_last_updated_by=>X_LAST_UPDATED_BY,
573: x_last_update_login=>X_LAST_UPDATE_LOGIN
574: );
575: update IGS_AS_EXM_SUPRVISOR_ALL set
576: EXAM_SUPERVISOR_TYPE = NEW_REFERENCES.EXAM_SUPERVISOR_TYPE,
577: PREVIOUS_SESSIONS = NEW_REFERENCES.PREVIOUS_SESSIONS,
578: RESPONSIBLE_ORG_UNIT_CD = NEW_REFERENCES.RESPONSIBLE_ORG_UNIT_CD,
579: RESPONSIBLE_OU_START_DT = NEW_REFERENCES.RESPONSIBLE_OU_START_DT,

Line 601: cursor c1 is select rowid from IGS_AS_EXM_SUPRVISOR_ALL

597: X_RESPONSIBLE_OU_START_DT in DATE,
598: X_COMMENTS in VARCHAR2,
599: X_MODE in VARCHAR2 default 'R'
600: ) as
601: cursor c1 is select rowid from IGS_AS_EXM_SUPRVISOR_ALL
602: where PERSON_ID = X_PERSON_ID
603: ;
604: begin
605: open c1;

Line 640: delete from IGS_AS_EXM_SUPRVISOR_ALL

636: Before_DML(
637: p_action => 'DELETE',
638: x_rowid => X_ROWID
639: );
640: delete from IGS_AS_EXM_SUPRVISOR_ALL
641: where ROWID = X_ROWID;
642: if (sql%notfound) then
643: raise no_data_found;
644: end if;