APPS.IGS_AS_EXM_LOC_SPVSR_PKG dependencies on IGS_AS_EXM_LOC_SPVSR

Line 1: package body IGS_AS_EXM_LOC_SPVSR_PKG AS

1: package body IGS_AS_EXM_LOC_SPVSR_PKG AS
2: /* $Header: IGSDI25B.pls 115.6 2003/10/30 13:27:53 rghosh ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_EXM_LOC_SPVSR%RowType;

Line 5: old_references IGS_AS_EXM_LOC_SPVSR%RowType;

1: package body IGS_AS_EXM_LOC_SPVSR_PKG AS
2: /* $Header: IGSDI25B.pls 115.6 2003/10/30 13:27:53 rghosh ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_EXM_LOC_SPVSR%RowType;
6: new_references IGS_AS_EXM_LOC_SPVSR%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_AS_EXM_LOC_SPVSR%RowType;

2: /* $Header: IGSDI25B.pls 115.6 2003/10/30 13:27:53 rghosh ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_AS_EXM_LOC_SPVSR%RowType;
6: new_references IGS_AS_EXM_LOC_SPVSR%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 22: FROM IGS_AS_EXM_LOC_SPVSR

18: ) AS
19:
20: CURSOR cur_old_ref_values IS
21: SELECT *
22: FROM IGS_AS_EXM_LOC_SPVSR
23: WHERE rowid = x_rowid;
24:
25: BEGIN
26:

Line 121: FROM IGS_AS_EXM_LOC_SPVSR

117: ) RETURN BOOLEAN AS
118:
119: CURSOR cur_rowid IS
120: SELECT rowid
121: FROM IGS_AS_EXM_LOC_SPVSR
122: WHERE person_id = x_person_id
123: AND exam_location_cd = x_exam_location_cd
124: FOR UPDATE NOWAIT;
125:

Line 149: FROM IGS_AS_EXM_LOC_SPVSR

145: ) AS
146:
147: CURSOR cur_rowid IS
148: SELECT rowid
149: FROM IGS_AS_EXM_LOC_SPVSR
150: WHERE person_id = x_person_id ;
151:
152: lv_rowid cur_rowid%RowType;
153:

Line 176: FROM IGS_AS_EXM_LOC_SPVSR

172: ) AS
173:
174: CURSOR cur_rowid IS
175: SELECT rowid
176: FROM IGS_AS_EXM_LOC_SPVSR
177: WHERE exam_location_cd = x_location_cd ;
178:
179: lv_rowid cur_rowid%RowType;
180:

Line 274: cursor C is select ROWID from IGS_AS_EXM_LOC_SPVSR

270: X_PERSON_ID in NUMBER,
271: X_EXAM_LOCATION_CD in VARCHAR2,
272: X_MODE in VARCHAR2 default 'R'
273: ) AS
274: cursor C is select ROWID from IGS_AS_EXM_LOC_SPVSR
275: where PERSON_ID = X_PERSON_ID
276: and EXAM_LOCATION_CD = X_EXAM_LOCATION_CD;
277: X_LAST_UPDATE_DATE DATE;
278: X_LAST_UPDATED_BY NUMBER;

Line 311: insert into IGS_AS_EXM_LOC_SPVSR (

307: x_last_update_date=>X_LAST_UPDATE_DATE,
308: x_last_updated_by=>X_LAST_UPDATED_BY,
309: x_last_update_login=>X_LAST_UPDATE_LOGIN
310: );
311: insert into IGS_AS_EXM_LOC_SPVSR (
312: PERSON_ID,
313: EXAM_LOCATION_CD,
314: CREATION_DATE,
315: CREATED_BY,

Line 346: from IGS_AS_EXM_LOC_SPVSR

342: X_EXAM_LOCATION_CD in VARCHAR2
343: ) AS
344: cursor c1 is select
345: ROWID
346: from IGS_AS_EXM_LOC_SPVSR
347: where ROWID = X_ROWID for update nowait;
348: tlinfo c1%rowtype;
349:
350: begin

Line 371: delete from IGS_AS_EXM_LOC_SPVSR

367: Before_DML(
368: p_action => 'DELETE',
369: x_rowid => X_ROWID
370: );
371: delete from IGS_AS_EXM_LOC_SPVSR
372: where ROWID = X_ROWID;
373: if (sql%notfound) then
374: raise no_data_found;
375: end if;

Line 402: end IGS_AS_EXM_LOC_SPVSR_PKG;

398: END IF;
399:
400: END Check_Constraints;
401:
402: end IGS_AS_EXM_LOC_SPVSR_PKG;