APPS.IGS_PE_PERSON_IMAGE_PKG dependencies on IGS_PE_PERSON_IMAGE

Line 1: package body IGS_PE_PERSON_IMAGE_PKG AS

1: package body IGS_PE_PERSON_IMAGE_PKG AS
2: /* $Header: IGSNI17B.pls 115.3 2002/11/29 01:18:23 nsidana ship $ */
3:
4:
5: l_rowid VARCHAR2(25);

Line 6: old_references IGS_PE_PERSON_IMAGE%RowType;

2: /* $Header: IGSNI17B.pls 115.3 2002/11/29 01:18:23 nsidana ship $ */
3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_PE_PERSON_IMAGE%RowType;
7: new_references IGS_PE_PERSON_IMAGE%RowType;
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 7: new_references IGS_PE_PERSON_IMAGE%RowType;

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

Line 22: FROM IGS_PE_PERSON_IMAGE

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

Line 84: FROM IGS_PE_PERSON_IMAGE

80: ) RETURN BOOLEAN AS
81:
82: CURSOR cur_rowid IS
83: SELECT rowid
84: FROM IGS_PE_PERSON_IMAGE
85: WHERE person_id = x_person_id
86: AND image_dt = x_image_dt
87: FOR UPDATE NOWAIT;
88:

Line 111: FROM IGS_PE_PERSON_IMAGE

107: ) AS
108:
109: CURSOR cur_rowid IS
110: SELECT rowid
111: FROM IGS_PE_PERSON_IMAGE
112: WHERE person_id = x_person_id ;
113:
114: lv_rowid cur_rowid%RowType;
115:

Line 219: cursor C is select ROWID from IGS_PE_PERSON_IMAGE

215: X_PERSON_ID in NUMBER,
216: X_IMAGE_DT in out NOCOPY DATE,
217: X_MODE in VARCHAR2 default 'R'
218: ) AS
219: cursor C is select ROWID from IGS_PE_PERSON_IMAGE
220: where PERSON_ID = X_PERSON_ID
221: and IMAGE_DT = NEW_REFERENCES.IMAGE_DT;
222: X_LAST_UPDATE_DATE DATE;
223: X_LAST_UPDATED_BY NUMBER;

Line 256: insert into IGS_PE_PERSON_IMAGE (

252: x_last_updated_by=>X_LAST_UPDATED_BY,
253: x_last_update_login=>X_LAST_UPDATE_LOGIN
254: );
255:
256: insert into IGS_PE_PERSON_IMAGE (
257: PERSON_ID,
258: IMAGE_DT,
259: CREATION_DATE,
260: CREATED_BY,

Line 294: from IGS_PE_PERSON_IMAGE

290: X_PERSON_ID in NUMBER,
291: X_IMAGE_DT in DATE
292: ) AS
293: cursor c1 is select rowid
294: from IGS_PE_PERSON_IMAGE
295: where ROWID = X_ROWID
296: for update nowait;
297: tlinfo c1%rowtype;
298:

Line 324: delete from IGS_PE_PERSON_IMAGE

320: Before_DML(
321: p_action => 'DELETE',
322: x_rowid => X_ROWID
323: );
324: delete from IGS_PE_PERSON_IMAGE
325: where ROWID = X_ROWID;
326: if (sql%notfound) then
327: raise no_data_found;
328: end if;

Line 335: end IGS_PE_PERSON_IMAGE_PKG;

331: x_rowid => X_ROWID
332: );
333: end DELETE_ROW;
334:
335: end IGS_PE_PERSON_IMAGE_PKG;