PACKAGE: APPS.IGS_PE_PERS_RELATION_PKG

Source

1 package  IGS_PE_PERS_RELATION_PKG AS
2   /* $Header: IGSNI31S.pls 120.0 2005/06/01 22:33:28 appldev noship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_PERSON_ID in NUMBER,
7   X_PERSON_ID_ALSO_RELATED_TO in NUMBER,
8   X_PERSON_RELATION_TYPE in VARCHAR2,
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_PERSON_ID_ALSO_RELATED_TO in NUMBER,
15   X_PERSON_RELATION_TYPE in VARCHAR2
16 );
17 
18 procedure DELETE_ROW (
19   X_ROWID in VARCHAR2,
20   x_mode IN VARCHAR2 DEFAULT 'R'
21 );
22 
23   FUNCTION Get_PK_For_Validation (
24     x_person_id IN NUMBER,
25     x_person_id_also_related_to IN NUMBER,
26     x_person_relation_type IN VARCHAR2
27     ) RETURN BOOLEAN;
28 
29   PROCEDURE GET_FK_IGS_PE_PERSON (
30     x_person_id IN NUMBER
31     );
32 
33   PROCEDURE GET_FK_IGS_PE_PERS_RELN_TYP (
34     x_person_relation_type IN VARCHAR2
35     );
36  PROCEDURE Check_Constraints (
37  Column_Name	IN	VARCHAR2	DEFAULT NULL,
38  Column_Value 	IN	VARCHAR2	DEFAULT NULL
39  );
40 PROCEDURE Before_DML (
41     p_action IN VARCHAR2,
42     x_rowid IN  VARCHAR2 DEFAULT NULL,
43     x_person_id IN NUMBER DEFAULT NULL,
44     x_person_id_also_related_to IN NUMBER DEFAULT NULL,
45     x_person_relation_type IN VARCHAR2 DEFAULT NULL,
46     x_creation_date IN DATE DEFAULT NULL,
47     x_created_by IN NUMBER DEFAULT NULL,
48     x_last_update_date IN DATE DEFAULT NULL,
49     x_last_updated_by IN NUMBER DEFAULT NULL,
50     x_last_update_login IN NUMBER DEFAULT NULL
51   );
52 
53 end IGS_PE_PERS_RELATION_PKG;