1 package IGS_PE_PERSON_IMAGE_PKG AUTHID CURRENT_USER AS
2 /* $Header: IGSNI17S.pls 115.3 2002/11/29 01:18:30 nsidana ship $ */
3
4
5 procedure INSERT_ROW (
6 X_ROWID in out NOCOPY VARCHAR2,
7 X_PERSON_ID in NUMBER,
8 X_IMAGE_DT in out NOCOPY DATE,
9 X_MODE in VARCHAR2 default 'R'
10 );
11 procedure LOCK_ROW (
12 X_ROWID in VARCHAR2,
13 X_PERSON_ID in NUMBER,
14 X_IMAGE_DT in DATE
15 );
16 procedure DELETE_ROW (
17 X_ROWID in VARCHAR2
18 );
19
20 FUNCTION Get_PK_For_Validation (
21 x_person_id IN NUMBER,
22 x_image_dt IN DATE
23 )RETURN BOOLEAN;
24
25 PROCEDURE GET_FK_IGS_PE_PERSON (
26 x_person_id IN NUMBER
27 );
28
29 PROCEDURE Before_DML (
30 p_action IN VARCHAR2,
31 x_rowid IN VARCHAR2 DEFAULT NULL,
32 x_person_id IN NUMBER DEFAULT NULL,
33 x_image_dt IN DATE DEFAULT NULL,
34 x_creation_date IN DATE DEFAULT NULL,
35 x_created_by IN NUMBER DEFAULT NULL,
36 x_last_update_date IN DATE DEFAULT NULL,
37 x_last_updated_by IN NUMBER DEFAULT NULL,
38 x_last_update_login IN NUMBER DEFAULT NULL
39 );
40
41 end IGS_PE_PERSON_IMAGE_PKG;