PACKAGE: APPS.IGS_RU_TRG_GROUP_CD_PKG

Source

1 PACKAGE igs_ru_trg_group_cd_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSUI20S.pls 115.6 2002/11/29 04:30:31 nsidana ship $ */
3 
4  procedure INSERT_ROW (
5       X_ROWID in out NOCOPY VARCHAR2,
6        x_GROUP_CD IN VARCHAR2,
7        x_DESCRIPTION IN VARCHAR2,
8       X_MODE in VARCHAR2 default 'R'
9   );
10 
11  procedure LOCK_ROW (
12       X_ROWID in  VARCHAR2,
13        x_GROUP_CD IN VARCHAR2,
14        x_DESCRIPTION IN VARCHAR2  );
15  procedure UPDATE_ROW (
16       X_ROWID in  VARCHAR2,
17        x_GROUP_CD IN VARCHAR2,
18        x_DESCRIPTION IN VARCHAR2,
19       X_MODE in VARCHAR2 default 'R'
20   );
21 
22  procedure ADD_ROW (
23       X_ROWID in out NOCOPY VARCHAR2,
24        x_GROUP_CD IN VARCHAR2,
25        x_DESCRIPTION IN VARCHAR2,
26       X_MODE in VARCHAR2 default 'R'
27   ) ;
28 
29 procedure DELETE_ROW (
30   X_ROWID in VARCHAR2
31 ) ;
32   FUNCTION Get_PK_For_Validation (
33     x_group_cd IN VARCHAR2
34     ) RETURN BOOLEAN ;
35 
36   PROCEDURE Check_Constraints (
37 		 Column_Name IN VARCHAR2  DEFAULT NULL,
38 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
39   PROCEDURE Before_DML (
40     p_action IN VARCHAR2,
41     x_rowid IN VARCHAR2 DEFAULT NULL,
42     x_group_cd IN VARCHAR2 DEFAULT NULL,
43     x_description IN VARCHAR2 DEFAULT NULL,
44     x_creation_date IN DATE DEFAULT NULL,
45     x_created_by IN NUMBER DEFAULT NULL,
46     x_last_update_date IN DATE DEFAULT NULL,
47     x_last_updated_by IN NUMBER DEFAULT NULL,
48     x_last_update_login IN NUMBER DEFAULT NULL
49  );
50 END igs_ru_trg_group_cd_pkg;