APPS.IGS_AS_EXM_INS_SPVSR_PKG dependencies on IGS_AS_EXM_INS_SPVSR

Line 1: package body IGS_AS_EXM_INS_SPVSR_PKG AS

1: package body IGS_AS_EXM_INS_SPVSR_PKG AS
2: /* $Header: IGSDI11B.pls 115.4 2002/11/28 23:12:54 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AS_EXM_INS_SPVSR%RowType;
5: new_references IGS_AS_EXM_INS_SPVSR%RowType;

Line 4: old_references IGS_AS_EXM_INS_SPVSR%RowType;

1: package body IGS_AS_EXM_INS_SPVSR_PKG AS
2: /* $Header: IGSDI11B.pls 115.4 2002/11/28 23:12:54 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AS_EXM_INS_SPVSR%RowType;
5: new_references IGS_AS_EXM_INS_SPVSR%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 5: new_references IGS_AS_EXM_INS_SPVSR%RowType;

1: package body IGS_AS_EXM_INS_SPVSR_PKG AS
2: /* $Header: IGSDI11B.pls 115.4 2002/11/28 23:12:54 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AS_EXM_INS_SPVSR%RowType;
5: new_references IGS_AS_EXM_INS_SPVSR%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2 DEFAULT NULL,
9: x_person_id IN NUMBER DEFAULT NULL,

Line 30: FROM IGS_AS_EXM_INS_SPVSR

26: x_last_update_login IN NUMBER DEFAULT NULL
27: ) AS
28: CURSOR cur_old_ref_values IS
29: SELECT *
30: FROM IGS_AS_EXM_INS_SPVSR
31: WHERE rowid = x_rowid;
32: BEGIN
33: l_rowid := x_rowid;
34: -- Code for setting the Old and New Reference Values.

Line 184: FROM IGS_AS_EXM_INS_SPVSR

180: x_venue_cd IN VARCHAR2
181: )return boolean AS
182: CURSOR cur_rowid IS
183: SELECT rowid
184: FROM IGS_AS_EXM_INS_SPVSR
185: WHERE person_id = x_person_id
186: AND ass_id = x_ass_id
187: AND exam_cal_type = x_exam_cal_type
188: AND exam_ci_sequence_number = x_exam_ci_sequence_number

Line 220: FROM IGS_AS_EXM_INS_SPVSR

216: x_venue_cd IN VARCHAR2
217: ) AS
218: CURSOR cur_rowid IS
219: SELECT rowid
220: FROM IGS_AS_EXM_INS_SPVSR
221: WHERE ass_id = x_ass_id
222: AND exam_cal_type = x_exam_cal_type
223: AND exam_ci_sequence_number = x_exam_ci_sequence_number
224: AND dt_alias = x_dt_alias

Line 248: FROM IGS_AS_EXM_INS_SPVSR

244: x_ese_id IN NUMBER
245: ) AS
246: CURSOR cur_rowid IS
247: SELECT rowid
248: FROM IGS_AS_EXM_INS_SPVSR
249: WHERE ese_id = x_ese_id ;
250: lv_rowid cur_rowid%RowType;
251: BEGIN
252: Open cur_rowid;

Line 269: FROM IGS_AS_EXM_INS_SPVSR

265: x_exam_supervisor_type IN VARCHAR2
266: ) AS
267: CURSOR cur_rowid IS
268: SELECT rowid
269: FROM IGS_AS_EXM_INS_SPVSR
270: WHERE exam_supervisor_type = x_exam_supervisor_type ;
271: lv_rowid cur_rowid%RowType;
272: BEGIN
273: Open cur_rowid;

Line 290: FROM IGS_AS_EXM_INS_SPVSR

286: x_person_id IN NUMBER
287: ) AS
288: CURSOR cur_rowid IS
289: SELECT rowid
290: FROM IGS_AS_EXM_INS_SPVSR
291: WHERE person_id = x_person_id ;
292: lv_rowid cur_rowid%RowType;
293: BEGIN
294: Open cur_rowid;

Line 418: cursor C is select ROWID from IGS_AS_EXM_INS_SPVSR

414: X_OVERRIDE_START_TIME in DATE,
415: X_OVERRIDE_END_TIME in DATE,
416: X_MODE in VARCHAR2 default 'R'
417: ) AS
418: cursor C is select ROWID from IGS_AS_EXM_INS_SPVSR
419: where PERSON_ID = X_PERSON_ID
420: and ASS_ID = X_ASS_ID
421: and EXAM_CAL_TYPE = X_EXAM_CAL_TYPE
422: and EXAM_CI_SEQUENCE_NUMBER = X_EXAM_CI_SEQUENCE_NUMBER

Line 472: insert into IGS_AS_EXM_INS_SPVSR (

468: x_last_update_date=>X_LAST_UPDATE_DATE,
469: x_last_updated_by=>X_LAST_UPDATED_BY,
470: x_last_update_login=>X_LAST_UPDATE_LOGIN
471: );
472: insert into IGS_AS_EXM_INS_SPVSR (
473: PERSON_ID,
474: ASS_ID,
475: EXAM_CAL_TYPE,
476: EXAM_CI_SEQUENCE_NUMBER,

Line 541: from IGS_AS_EXM_INS_SPVSR

537: ESE_ID,
538: EXAM_SUPERVISOR_TYPE,
539: OVERRIDE_START_TIME,
540: OVERRIDE_END_TIME
541: from IGS_AS_EXM_INS_SPVSR
542: where ROWID = X_ROWID for update nowait;
543: tlinfo c1%rowtype;
544: begin
545: open c1;

Line 633: update IGS_AS_EXM_INS_SPVSR set

629: x_last_update_date=>X_LAST_UPDATE_DATE,
630: x_last_updated_by=>X_LAST_UPDATED_BY,
631: x_last_update_login=>X_LAST_UPDATE_LOGIN
632: );
633: update IGS_AS_EXM_INS_SPVSR set
634: ESE_ID = NEW_REFERENCES.ESE_ID,
635: EXAM_SUPERVISOR_TYPE = NEW_REFERENCES.EXAM_SUPERVISOR_TYPE,
636: OVERRIDE_START_TIME = NEW_REFERENCES.OVERRIDE_START_TIME,
637: OVERRIDE_END_TIME = NEW_REFERENCES.OVERRIDE_END_TIME,

Line 664: cursor c1 is select rowid from IGS_AS_EXM_INS_SPVSR

660: X_OVERRIDE_START_TIME in DATE,
661: X_OVERRIDE_END_TIME in DATE,
662: X_MODE in VARCHAR2 default 'R'
663: ) AS
664: cursor c1 is select rowid from IGS_AS_EXM_INS_SPVSR
665: where PERSON_ID = X_PERSON_ID
666: and ASS_ID = X_ASS_ID
667: and EXAM_CAL_TYPE = X_EXAM_CAL_TYPE
668: and EXAM_CI_SEQUENCE_NUMBER = X_EXAM_CI_SEQUENCE_NUMBER

Line 723: delete from IGS_AS_EXM_INS_SPVSR

719: Before_DML(
720: p_action => 'DELETE',
721: x_rowid => X_ROWID
722: );
723: delete from IGS_AS_EXM_INS_SPVSR
724: where ROWID = X_ROWID;
725: if (sql%notfound) then
726: raise no_data_found;
727: end if;

Line 813: end IGS_AS_EXM_INS_SPVSR_PKG;

809: APP_EXCEPTION.RAISE_EXCEPTION;
810: END IF;
811: END IF;
812: END Check_Constraints;
813: end IGS_AS_EXM_INS_SPVSR_PKG;