APPS.IGS_AS_EXAM_INSTANCE_PKG dependencies on IGS_AS_EXAM_INSTANCE_ALL

Line 4: old_references IGS_AS_EXAM_INSTANCE_ALL%RowType;

1: package body IGS_AS_EXAM_INSTANCE_PKG AS
2: /* $Header: IGSDI04B.pls 115.8 2003/04/14 09:16:54 anilk ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AS_EXAM_INSTANCE_ALL%RowType;
5: new_references IGS_AS_EXAM_INSTANCE_ALL%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 5: new_references IGS_AS_EXAM_INSTANCE_ALL%RowType;

1: package body IGS_AS_EXAM_INSTANCE_PKG AS
2: /* $Header: IGSDI04B.pls 115.8 2003/04/14 09:16:54 anilk ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AS_EXAM_INSTANCE_ALL%RowType;
5: new_references IGS_AS_EXAM_INSTANCE_ALL%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,
9: x_org_id IN NUMBER DEFAULT NULL,

Line 35: FROM IGS_AS_EXAM_INSTANCE_ALL

31: x_last_update_login IN NUMBER DEFAULT NULL
32: ) AS
33: CURSOR cur_old_ref_values IS
34: SELECT *
35: FROM IGS_AS_EXAM_INSTANCE_ALL
36: WHERE rowid = x_rowid;
37: BEGIN
38: l_rowid := x_rowid;
39: -- Code for setting the Old and New Reference Values.

Line 218: FROM IGS_AS_EXAM_INSTANCE_ALL

214: x_venue_cd IN VARCHAR2
215: ) RETURN BOOLEAN AS
216: CURSOR cur_rowid IS
217: SELECT rowid
218: FROM IGS_AS_EXAM_INSTANCE_ALL
219: WHERE ass_id = x_ass_id
220: AND exam_cal_type = x_exam_cal_type
221: AND exam_ci_sequence_number = x_exam_ci_sequence_number
222: AND dt_alias = x_dt_alias

Line 245: FROM IGS_AS_EXAM_INSTANCE_ALL

241: x_ass_id IN NUMBER
242: ) AS
243: CURSOR cur_rowid IS
244: SELECT rowid
245: FROM IGS_AS_EXAM_INSTANCE_ALL
246: WHERE ass_id = x_ass_id ;
247: lv_rowid cur_rowid%RowType;
248: BEGIN
249: Open cur_rowid;

Line 271: FROM IGS_AS_EXAM_INSTANCE_ALL

267: x_end_time IN DATE
268: ) AS
269: CURSOR cur_rowid IS
270: SELECT rowid
271: FROM IGS_AS_EXAM_INSTANCE_ALL
272: WHERE exam_cal_type = x_exam_cal_type
273: AND exam_ci_sequence_number = x_exam_ci_sequence_number
274: AND dt_alias = x_dt_alias
275: AND dai_sequence_number = x_dai_sequence_number

Line 297: FROM IGS_AS_EXAM_INSTANCE_ALL

293: x_ese_id IN NUMBER
294: ) AS
295: CURSOR cur_rowid IS
296: SELECT rowid
297: FROM IGS_AS_EXAM_INSTANCE_ALL
298: WHERE ese_id = x_ese_id ;
299: lv_rowid cur_rowid%RowType;
300: BEGIN
301: Open cur_rowid;

Line 318: FROM IGS_AS_EXAM_INSTANCE_ALL

314: x_person_id IN NUMBER
315: ) AS
316: CURSOR cur_rowid IS
317: SELECT rowid
318: FROM IGS_AS_EXAM_INSTANCE_ALL
319: WHERE collect_person_id = x_person_id ;
320: lv_rowid cur_rowid%RowType;
321: BEGIN
322: Open cur_rowid;

Line 339: FROM IGS_AS_EXAM_INSTANCE_ALL

335: x_venue_cd IN VARCHAR2
336: ) AS
337: CURSOR cur_rowid IS
338: SELECT rowid
339: FROM IGS_AS_EXAM_INSTANCE_ALL
340: WHERE venue_cd = x_venue_cd ;
341: lv_rowid cur_rowid%RowType;
342: BEGIN
343: Open cur_rowid;

Line 481: cursor C is select ROWID from IGS_AS_EXAM_INSTANCE_ALL

477: X_WORKED_SCRIPT_INSTRUCTIONS in VARCHAR2,
478: X_COMMENTS in VARCHAR2,
479: X_MODE in VARCHAR2 default 'R'
480: ) As
481: cursor C is select ROWID from IGS_AS_EXAM_INSTANCE_ALL
482: where ASS_ID = X_ASS_ID
483: and EXAM_CAL_TYPE = X_EXAM_CAL_TYPE
484: and EXAM_CI_SEQUENCE_NUMBER = X_EXAM_CI_SEQUENCE_NUMBER
485: and DT_ALIAS = X_DT_ALIAS

Line 539: insert into IGS_AS_EXAM_INSTANCE_ALL (

535: x_last_update_date=>X_LAST_UPDATE_DATE,
536: x_last_updated_by=>X_LAST_UPDATED_BY,
537: x_last_update_login=>X_LAST_UPDATE_LOGIN
538: );
539: insert into IGS_AS_EXAM_INSTANCE_ALL (
540: ASS_ID,
541: ORG_ID,
542: EXAM_CAL_TYPE,
543: EXAM_CI_SEQUENCE_NUMBER,

Line 627: from IGS_AS_EXAM_INSTANCE_ALL

623: SPECIAL_ANNOUNCEMENTS,
624: SPECIAL_INSTRUCTIONS,
625: WORKED_SCRIPT_INSTRUCTIONS,
626: COMMENTS
627: from IGS_AS_EXAM_INSTANCE_ALL
628: where ROWID = X_ROWID for update nowait;
629: tlinfo c1%rowtype;
630: begin
631: open c1;

Line 742: update IGS_AS_EXAM_INSTANCE_ALL set

738: x_last_update_date=>X_LAST_UPDATE_DATE,
739: x_last_updated_by=>X_LAST_UPDATED_BY,
740: x_last_update_login=>X_LAST_UPDATE_LOGIN
741: );
742: update IGS_AS_EXAM_INSTANCE_ALL set
743: ESE_ID = NEW_REFERENCES.ESE_ID,
744: COLLECT_PERSON_ID = NEW_REFERENCES.COLLECT_PERSON_ID,
745: SPECIAL_SESSION_IND = NEW_REFERENCES.SPECIAL_SESSION_IND,
746: OVERRIDE_START_TIME = NEW_REFERENCES.OVERRIDE_START_TIME,

Line 783: cursor c1 is select rowid from IGS_AS_EXAM_INSTANCE_ALL

779: X_WORKED_SCRIPT_INSTRUCTIONS in VARCHAR2,
780: X_COMMENTS in VARCHAR2,
781: X_MODE in VARCHAR2 default 'R'
782: ) AS
783: cursor c1 is select rowid from IGS_AS_EXAM_INSTANCE_ALL
784: where ASS_ID = X_ASS_ID
785: and EXAM_CAL_TYPE = X_EXAM_CAL_TYPE
786: and EXAM_CI_SEQUENCE_NUMBER = X_EXAM_CI_SEQUENCE_NUMBER
787: and DT_ALIAS = X_DT_ALIAS

Line 850: delete from IGS_AS_EXAM_INSTANCE_ALL

846: Before_DML(
847: p_action => 'DELETE',
848: x_rowid => X_ROWID
849: );
850: delete from IGS_AS_EXAM_INSTANCE_ALL
851: where ROWID = X_ROWID;
852: if (sql%notfound) then
853: raise no_data_found;
854: end if;