APPS.IGS_AS_EXM_SES_VN_SP_PKG dependencies on IGS_AS_EXM_SES_VN_SP

Line 1: package body IGS_AS_EXM_SES_VN_SP_PKG AS

1: package body IGS_AS_EXM_SES_VN_SP_PKG AS
2: /* $Header: IGSDI13B.pls 115.4 2002/11/28 23:13:32 nsidana ship $ */
3: --w.r.t BUG #1956374 , Procedure assp_val_est_closed reference is changed
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_EXM_SES_VN_SP%RowType;

Line 5: old_references IGS_AS_EXM_SES_VN_SP%RowType;

1: package body IGS_AS_EXM_SES_VN_SP_PKG AS
2: /* $Header: IGSDI13B.pls 115.4 2002/11/28 23:13:32 nsidana ship $ */
3: --w.r.t BUG #1956374 , Procedure assp_val_est_closed reference is changed
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_EXM_SES_VN_SP%RowType;
6: new_references IGS_AS_EXM_SES_VN_SP%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_SES_VN_SP%RowType;

2: /* $Header: IGSDI13B.pls 115.4 2002/11/28 23:13:32 nsidana ship $ */
3: --w.r.t BUG #1956374 , Procedure assp_val_est_closed reference is changed
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_EXM_SES_VN_SP%RowType;
6: new_references IGS_AS_EXM_SES_VN_SP%RowType;
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,
10: x_person_id IN NUMBER DEFAULT NULL,

Line 30: FROM IGS_AS_EXM_SES_VN_SP

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_SES_VN_SP
31: WHERE rowid = x_rowid;
32: BEGIN
33: l_rowid := x_rowid;
34: -- Code for setting the Old and New Reference Values.

Line 165: FROM IGS_AS_EXM_SES_VN_SP

161: x_end_time IN DATE
162: ) RETURN BOOLEAN AS
163: CURSOR cur_rowid IS
164: SELECT rowid
165: FROM IGS_AS_EXM_SES_VN_SP
166: WHERE person_id = x_person_id
167: AND exam_cal_type = x_exam_cal_type
168: AND exam_ci_sequence_number = x_exam_ci_sequence_number
169: AND dt_alias = x_dt_alias

Line 193: FROM IGS_AS_EXM_SES_VN_SP

189: x_ese_id IN NUMBER
190: ) AS
191: CURSOR cur_rowid IS
192: SELECT rowid
193: FROM IGS_AS_EXM_SES_VN_SP
194: WHERE ese_id = x_ese_id ;
195: lv_rowid cur_rowid%RowType;
196: BEGIN
197: Open cur_rowid;

Line 214: FROM IGS_AS_EXM_SES_VN_SP

210: x_exam_supervisor_type IN VARCHAR2
211: ) AS
212: CURSOR cur_rowid IS
213: SELECT rowid
214: FROM IGS_AS_EXM_SES_VN_SP
215: WHERE exam_supervisor_type = x_exam_supervisor_type ;
216: lv_rowid cur_rowid%RowType;
217: BEGIN
218: Open cur_rowid;

Line 235: FROM IGS_AS_EXM_SES_VN_SP

231: x_person_id IN NUMBER
232: ) AS
233: CURSOR cur_rowid IS
234: SELECT rowid
235: FROM IGS_AS_EXM_SES_VN_SP
236: WHERE person_id = x_person_id ;
237: lv_rowid cur_rowid%RowType;
238: BEGIN
239: Open cur_rowid;

Line 358: cursor C is select ROWID from IGS_AS_EXM_SES_VN_SP

354: X_OVERRIDE_START_TIME in DATE,
355: X_OVERRIDE_END_TIME in DATE,
356: X_MODE in VARCHAR2 default 'R'
357: ) AS
358: cursor C is select ROWID from IGS_AS_EXM_SES_VN_SP
359: where PERSON_ID = X_PERSON_ID
360: and EXAM_CAL_TYPE = X_EXAM_CAL_TYPE
361: and EXAM_CI_SEQUENCE_NUMBER = X_EXAM_CI_SEQUENCE_NUMBER
362: and DT_ALIAS = X_DT_ALIAS

Line 410: insert into IGS_AS_EXM_SES_VN_SP (

406: x_last_update_date=>X_LAST_UPDATE_DATE,
407: x_last_updated_by=>X_LAST_UPDATED_BY,
408: x_last_update_login=>X_LAST_UPDATE_LOGIN
409: );
410: insert into IGS_AS_EXM_SES_VN_SP (
411: PERSON_ID,
412: EXAM_CAL_TYPE,
413: EXAM_CI_SEQUENCE_NUMBER,
414: DT_ALIAS,

Line 476: from IGS_AS_EXM_SES_VN_SP

472: ESE_ID,
473: EXAM_SUPERVISOR_TYPE,
474: OVERRIDE_START_TIME,
475: OVERRIDE_END_TIME
476: from IGS_AS_EXM_SES_VN_SP
477: where ROWID = X_ROWID for update nowait;
478: tlinfo c1%rowtype;
479: begin
480: open c1;

Line 566: update IGS_AS_EXM_SES_VN_SP set

562: x_last_update_date=>X_LAST_UPDATE_DATE,
563: x_last_updated_by=>X_LAST_UPDATED_BY,
564: x_last_update_login=>X_LAST_UPDATE_LOGIN
565: );
566: update IGS_AS_EXM_SES_VN_SP set
567: ESE_ID = NEW_REFERENCES.ESE_ID,
568: EXAM_SUPERVISOR_TYPE = NEW_REFERENCES.EXAM_SUPERVISOR_TYPE,
569: OVERRIDE_START_TIME = NEW_REFERENCES.OVERRIDE_START_TIME,
570: OVERRIDE_END_TIME = NEW_REFERENCES.OVERRIDE_END_TIME,

Line 596: cursor c1 is select rowid from IGS_AS_EXM_SES_VN_SP

592: X_OVERRIDE_START_TIME in DATE,
593: X_OVERRIDE_END_TIME in DATE,
594: X_MODE in VARCHAR2 default 'R'
595: ) AS
596: cursor c1 is select rowid from IGS_AS_EXM_SES_VN_SP
597: where PERSON_ID = X_PERSON_ID
598: and EXAM_CAL_TYPE = X_EXAM_CAL_TYPE
599: and EXAM_CI_SEQUENCE_NUMBER = X_EXAM_CI_SEQUENCE_NUMBER
600: and DT_ALIAS = X_DT_ALIAS

Line 652: delete from IGS_AS_EXM_SES_VN_SP

648: Before_DML(
649: p_action => 'DELETE',
650: x_rowid => X_ROWID
651: );
652: delete from IGS_AS_EXM_SES_VN_SP
653: where ROWID = X_ROWID;
654: if (sql%notfound) then
655: raise no_data_found;
656: end if;

Line 736: end IGS_AS_EXM_SES_VN_SP_PKG;

732:
733: END Check_Constraints;
734:
735:
736: end IGS_AS_EXM_SES_VN_SP_PKG;