APPS.IGS_AS_STD_EXM_INSTN_PKG dependencies on IGS_AS_STD_EXM_INSTN_ALL

Line 6: old_references IGS_AS_STD_EXM_INSTN_ALL%RowType;

2: /* $Header: IGSDI09B.pls 120.0 2005/07/05 12:08:58 appldev noship $ */
3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_AS_STD_EXM_INSTN_ALL%RowType;
7: new_references IGS_AS_STD_EXM_INSTN_ALL%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,

Line 7: new_references IGS_AS_STD_EXM_INSTN_ALL%RowType;

3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_AS_STD_EXM_INSTN_ALL%RowType;
7: new_references IGS_AS_STD_EXM_INSTN_ALL%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,
11: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 43: FROM IGS_AS_STD_EXM_INSTN_ALL

39: ) AS
40:
41: CURSOR cur_old_ref_values IS
42: SELECT *
43: FROM IGS_AS_STD_EXM_INSTN_ALL
44: WHERE rowid = x_rowid;
45:
46: BEGIN
47:

Line 292: FROM IGS_AS_STD_EXM_INSTN_ALL

288: ) RETURN BOOLEAN AS
289:
290: CURSOR cur_rowid IS
291: SELECT rowid
292: FROM IGS_AS_STD_EXM_INSTN_ALL
293: WHERE std_exm_instn_id = x_std_exm_instn_id
294: FOR UPDATE NOWAIT;
295:
296: lv_rowid cur_rowid%RowType;

Line 328: FROM IGS_AS_STD_EXM_INSTN_ALL

324: x_uoo_id in NUMBER
325: ) RETURN BOOLEAN AS
326: CURSOR cur_sua IS
327: SELECT ROWID
328: FROM IGS_AS_STD_EXM_INSTN_ALL
329: WHERE ass_id = x_ass_id
330: AND exam_cal_type = x_exam_cal_type
331: AND exam_ci_sequence_number = x_exam_ci_sequence_number
332: AND start_time = x_start_time

Line 370: FROM IGS_AS_STD_EXM_INSTN_ALL

366: ) AS
367:
368: CURSOR cur_rowid IS
369: SELECT rowid
370: FROM IGS_AS_STD_EXM_INSTN_ALL
371: WHERE ass_id = x_ass_id
372: AND exam_cal_type = x_exam_cal_type
373: AND exam_ci_sequence_number = x_exam_ci_sequence_number
374: AND dt_alias = x_dt_alias

Line 404: FROM IGS_AS_STD_EXM_INSTN_ALL

400: ) AS
401:
402: CURSOR cur_rowid IS
403: SELECT rowid
404: FROM IGS_AS_STD_EXM_INSTN_ALL
405: WHERE ese_id = x_ese_id ;
406:
407: lv_rowid cur_rowid%RowType;
408:

Line 435: FROM IGS_AS_STD_EXM_INSTN_ALL

431: ) AS
432:
433: CURSOR cur_rowid IS
434: SELECT rowid
435: FROM IGS_AS_STD_EXM_INSTN_ALL
436: WHERE person_id = x_person_id
437: AND course_cd = x_course_cd
438: AND ass_id = x_ass_id
439: AND creation_dt = x_creation_dt

Line 620: cursor C is select ROWID from IGS_AS_STD_EXM_INSTN_ALL

616: -- in call to before_dml as part of SWCR006 build.
617: --svanukur 29-apr-03 changed the where clause to reflect the new PK
618: -- as part of MUS build, # 2829262
619: ---------------------------------------------------------------------------------------*/
620: cursor C is select ROWID from IGS_AS_STD_EXM_INSTN_ALL
621: where STD_EXM_INSTN_ID = X_STD_EXM_INSTN_ID;
622: X_LAST_UPDATE_DATE DATE;
623: X_LAST_UPDATED_BY NUMBER;
624: X_LAST_UPDATE_LOGIN NUMBER;

Line 645: SELECT IGS_AS_STD_EXM_INSTN_ALL_S.nextval

641: IGS_GE_MSG_STACK.ADD;
642: APP_EXCEPTION.RAISE_EXCEPTION;
643: end if;
644:
645: SELECT IGS_AS_STD_EXM_INSTN_ALL_S.nextval
646: INTO X_STD_EXM_INSTN_ID
647: FROM DUAL;
648:
649: Before_DML(

Line 684: insert into IGS_AS_STD_EXM_INSTN_ALL (

680:
681: IF (x_mode = 'S') THEN
682: igs_sc_gen_001.set_ctx('R');
683: END IF;
684: insert into IGS_AS_STD_EXM_INSTN_ALL (
685: ORG_ID,
686: SEAT_NUMBER,
687:
688: TIMESLOT,

Line 804: from IGS_AS_STD_EXM_INSTN_ALL

800: TIMESLOT,
801: TIMESLOT_DURATION,
802: ESE_ID,
803: ATTENDANCE_IND
804: from IGS_AS_STD_EXM_INSTN_ALL
805: where ROWID = X_ROWID for update nowait;
806: tlinfo c1%rowtype;
807:
808: begin

Line 922: update IGS_AS_STD_EXM_INSTN_ALL set

918: );
919: IF (x_mode = 'S') THEN
920: igs_sc_gen_001.set_ctx('R');
921: END IF;
922: update IGS_AS_STD_EXM_INSTN_ALL set
923: SEAT_NUMBER = new_references.SEAT_NUMBER,
924: TIMESLOT = new_references.TIMESLOT,
925: TIMESLOT_DURATION = new_references.TIMESLOT_DURATION,
926: ESE_ID = new_references.ESE_ID,

Line 988: cursor c1 is select rowid from IGS_AS_STD_EXM_INSTN_ALL

984: X_MODE in VARCHAR2 default 'R',
985: x_uoo_id in NUMBER,
986: x_std_exm_instn_id in out NOCOPY NUMBER
987: ) AS
988: cursor c1 is select rowid from IGS_AS_STD_EXM_INSTN_ALL
989: where std_exm_instn_id = X_STD_EXM_INSTN_ID;
990:
991:
992:

Line 1065: delete from IGS_AS_STD_EXM_INSTN_ALL

1061:
1062: IF (x_mode = 'S') THEN
1063: igs_sc_gen_001.set_ctx('R');
1064: END IF;
1065: delete from IGS_AS_STD_EXM_INSTN_ALL
1066: where ROWID = X_ROWID;
1067: if (sql%notfound) then
1068: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1069: igs_ge_msg_stack.add;