PACKAGE: APPS.IGS_RU_GROUP_PKG

Source

1 package IGS_RU_GROUP_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSUI04S.pls 115.4 2002/11/29 04:25:48 nsidana ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_SEQUENCE_NUMBER in NUMBER,
7   X_GROUP_NAME in VARCHAR2,
8   X_MODE in VARCHAR2 default 'R'
9   );
10 procedure LOCK_ROW (
11   X_ROWID in VARCHAR2,
12   X_SEQUENCE_NUMBER in NUMBER,
13   X_GROUP_NAME in VARCHAR2
14 );
15 procedure UPDATE_ROW (
16   X_ROWID in VARCHAR2,
17   X_SEQUENCE_NUMBER in NUMBER,
18   X_GROUP_NAME in VARCHAR2,
19   X_MODE in VARCHAR2 default 'R'
20   );
21 procedure ADD_ROW (
22   X_ROWID in out NOCOPY VARCHAR2,
23   X_SEQUENCE_NUMBER in NUMBER,
24   X_GROUP_NAME in VARCHAR2,
25   X_MODE in VARCHAR2 default 'R'
26   );
27 procedure DELETE_ROW (
28   X_ROWID in VARCHAR2
29 );
30 
31  FUNCTION Get_PK_For_Validation (
32     x_sequence_number IN NUMBER
33     )  RETURN BOOLEAN ;
34 
35 
36 FUNCTION GET_UK1_FOR_VALIDATION ( x_group_name   varchar2 )
37                    RETURN BOOLEAN ;
38 
39 PROCEDURE   Check_Constraints (
40                  Column_Name     IN   VARCHAR2    DEFAULT NULL ,
41                  Column_Value    IN   VARCHAR2    DEFAULT NULL
42                                 );
43 
44   PROCEDURE Before_DML (
45     p_action IN VARCHAR2,
46     x_rowid IN VARCHAR2 DEFAULT NULL,
47     x_sequence_number IN NUMBER DEFAULT NULL,
48     x_group_name IN VARCHAR2 DEFAULT NULL,
49     x_creation_date IN DATE DEFAULT NULL,
50     x_created_by IN NUMBER DEFAULT NULL,
51     x_last_update_date IN DATE DEFAULT NULL,
52     x_last_updated_by IN NUMBER DEFAULT NULL,
53     x_last_update_login IN NUMBER DEFAULT NULL
54   ) ;
55 
56 end IGS_RU_GROUP_PKG;