APPS.IGS_AS_EXMVNU_SESAVL_PKG dependencies on IGS_AS_EXMVNU_SESAVL_ALL

Line 4: old_references IGS_AS_EXMVNU_SESAVL_ALL%RowType;

1: package body IGS_AS_EXMVNU_SESAVL_PKG AS
2: /* $Header: IGSDI14B.pls 115.8 2003/04/14 09:24:20 anilk ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AS_EXMVNU_SESAVL_ALL%RowType;
5: new_references IGS_AS_EXMVNU_SESAVL_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_AS_EXMVNU_SESAVL_ALL%RowType;

1: package body IGS_AS_EXMVNU_SESAVL_PKG AS
2: /* $Header: IGSDI14B.pls 115.8 2003/04/14 09:24:20 anilk ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AS_EXMVNU_SESAVL_ALL%RowType;
5: new_references IGS_AS_EXMVNU_SESAVL_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 29: FROM IGS_AS_EXMVNU_SESAVL_ALL

25: ) AS
26:
27: CURSOR cur_old_ref_values IS
28: SELECT *
29: FROM IGS_AS_EXMVNU_SESAVL_ALL
30: WHERE rowid = x_rowid;
31:
32: BEGIN
33:

Line 189: FROM IGS_AS_EXMVNU_SESAVL_ALL

185: ) RETURN BOOLEAN AS
186:
187: CURSOR cur_rowid IS
188: SELECT rowid
189: FROM IGS_AS_EXMVNU_SESAVL_ALL
190: WHERE venue_cd = x_venue_cd
191: AND exam_cal_type = x_exam_cal_type
192: AND exam_ci_sequence_number = x_exam_ci_sequence_number
193: AND dt_alias = x_dt_alias

Line 220: FROM IGS_AS_EXMVNU_SESAVL_ALL

216: ) AS
217:
218: CURSOR cur_rowid IS
219: SELECT rowid
220: FROM IGS_AS_EXMVNU_SESAVL_ALL
221: WHERE ese_id = x_ese_id ;
222:
223: lv_rowid cur_rowid%RowType;
224:

Line 252: FROM IGS_AS_EXMVNU_SESAVL_ALL

248: ) AS
249:
250: CURSOR cur_rowid IS
251: SELECT rowid
252: FROM IGS_AS_EXMVNU_SESAVL_ALL
253: WHERE exam_cal_type = x_exam_cal_type
254: AND exam_ci_sequence_number = x_exam_ci_sequence_number
255: AND dt_alias = x_dt_alias
256: AND dai_sequence_number = x_dai_sequence_number

Line 284: FROM IGS_AS_EXMVNU_SESAVL_ALL

280: ) AS
281:
282: CURSOR cur_rowid IS
283: SELECT rowid
284: FROM IGS_AS_EXMVNU_SESAVL_ALL
285: WHERE venue_cd = x_venue_cd ;
286:
287: lv_rowid cur_rowid%RowType;
288:

Line 411: cursor C is select ROWID from IGS_AS_EXMVNU_SESAVL_ALL

407: X_ESE_ID in NUMBER,
408: X_COMMENTS in VARCHAR2,
409: X_MODE in VARCHAR2 default 'R'
410: ) AS
411: cursor C is select ROWID from IGS_AS_EXMVNU_SESAVL_ALL
412: where VENUE_CD = X_VENUE_CD
413: and EXAM_CAL_TYPE = X_EXAM_CAL_TYPE
414: and EXAM_CI_SEQUENCE_NUMBER = X_EXAM_CI_SEQUENCE_NUMBER
415: and DT_ALIAS = X_DT_ALIAS

Line 475: insert into IGS_AS_EXMVNU_SESAVL_ALL (

471: x_last_update_date=>X_LAST_UPDATE_DATE,
472: x_last_updated_by=>X_LAST_UPDATED_BY,
473: x_last_update_login=>X_LAST_UPDATE_LOGIN
474: );
475: insert into IGS_AS_EXMVNU_SESAVL_ALL (
476: ORG_ID,
477: VENUE_CD,
478: EXAM_CAL_TYPE,
479: EXAM_CI_SEQUENCE_NUMBER,

Line 542: from IGS_AS_EXMVNU_SESAVL_all

538: ) AS
539: cursor c1 is select
540: ESE_ID,
541: COMMENTS
542: from IGS_AS_EXMVNU_SESAVL_all
543: where ROWID = X_ROWID
544: for update nowait;
545: tlinfo c1%rowtype;
546:

Line 645: update IGS_AS_EXMVNU_SESAVL_ALL set

641: X_PROGRAM_UPDATE_DATE := SYSDATE;
642: end if;
643: end if;
644:
645: update IGS_AS_EXMVNU_SESAVL_ALL set
646: ESE_ID = new_references.ESE_ID,
647: COMMENTS = new_references.COMMENTS,
648: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
649: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 678: cursor c1 is select rowid from IGS_AS_EXMVNU_SESAVL_ALL

674: X_ESE_ID in NUMBER,
675: X_COMMENTS in VARCHAR2,
676: X_MODE in VARCHAR2 default 'R'
677: ) AS
678: cursor c1 is select rowid from IGS_AS_EXMVNU_SESAVL_ALL
679: where VENUE_CD = X_VENUE_CD
680: and EXAM_CAL_TYPE = X_EXAM_CAL_TYPE
681: and EXAM_CI_SEQUENCE_NUMBER = X_EXAM_CI_SEQUENCE_NUMBER
682: and DT_ALIAS = X_DT_ALIAS

Line 731: delete from IGS_AS_EXMVNU_SESAVL_ALL

727: Before_DML(
728: p_action => 'DELETE',
729: x_rowid => X_ROWID
730: );
731: delete from IGS_AS_EXMVNU_SESAVL_ALL
732: where ROWID = X_ROWID;
733: if (sql%notfound) then
734: raise no_data_found;
735: end if;