PACKAGE: APPS.IGS_PE_PRSID_GRP_SEC_PKG

Source

1 package IGS_PE_PRSID_GRP_SEC_PKG AUTHID CURRENT_USER AS
2   /* $Header: IGSNI23S.pls 115.5 2003/02/18 08:47:25 npalanis ship $ */
3 
4 
5 
6 procedure INSERT_ROW (
7   X_ROWID in out NOCOPY VARCHAR2,
8   X_GROUP_ID in NUMBER,
9   X_PERSON_ID in NUMBER,
10   X_INSERT_IND in VARCHAR2,
11   X_UPDATE_IND in VARCHAR2,
12   X_DELETE_IND in VARCHAR2,
13   X_MODE in VARCHAR2 default 'R'
14   );
15 procedure LOCK_ROW (
16   X_ROWID in VARCHAR2,
17   X_GROUP_ID in NUMBER,
18   X_PERSON_ID in NUMBER,
19   X_INSERT_IND in VARCHAR2,
20   X_UPDATE_IND in VARCHAR2,
21   X_DELETE_IND in VARCHAR2
22 );
23 procedure UPDATE_ROW (
24   X_ROWID in VARCHAR2,
25   X_GROUP_ID in NUMBER,
26   X_PERSON_ID in NUMBER,
27   X_INSERT_IND in VARCHAR2,
28   X_UPDATE_IND in VARCHAR2,
29   X_DELETE_IND in VARCHAR2,
30   X_MODE in VARCHAR2 default 'R'
31   );
32 procedure ADD_ROW (
33   X_ROWID in out NOCOPY VARCHAR2,
34   X_GROUP_ID in NUMBER,
35   X_PERSON_ID in NUMBER,
36   X_INSERT_IND in VARCHAR2,
37   X_UPDATE_IND in VARCHAR2,
38   X_DELETE_IND in VARCHAR2,
39   X_MODE in VARCHAR2 default 'R'
40   );
41 procedure DELETE_ROW (
42   X_ROWID in VARCHAR2
43 );
44 
45   FUNCTION Get_PK_For_Validation (
46     x_group_id IN NUMBER,
47     x_person_id IN NUMBER
48     ) RETURN BOOLEAN ;
49 
50   PROCEDURE GET_FK_IGS_PE_PERSON (
51     x_person_id IN NUMBER
52     );
53 
54   PROCEDURE Check_Constraints (
55  Column_Name	IN	VARCHAR2	DEFAULT NULL,
56  Column_Value 	IN	VARCHAR2	DEFAULT NULL
57  );
58 PROCEDURE Before_DML (
59     p_action IN VARCHAR2,
60     x_rowid IN  VARCHAR2 DEFAULT NULL,
61     x_group_id IN NUMBER DEFAULT NULL,
62     x_person_id IN NUMBER DEFAULT NULL,
63     x_insert_ind IN VARCHAR2 DEFAULT NULL,
64     x_update_ind IN VARCHAR2 DEFAULT NULL,
65     x_delete_ind IN VARCHAR2 DEFAULT NULL,
66     x_creation_date IN DATE DEFAULT NULL,
67     x_created_by IN NUMBER DEFAULT NULL,
68     x_last_update_date IN DATE DEFAULT NULL,
69     x_last_updated_by IN NUMBER DEFAULT NULL,
70     x_last_update_login IN NUMBER DEFAULT NULL
71   );
72 
73 
74 end IGS_PE_PRSID_GRP_SEC_PKG;