PACKAGE: APPS.IGS_RU_TURIN_RULE_GR_PKG

Source

1 PACKAGE igs_ru_turin_rule_gr_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSUI19S.pls 115.6 2002/11/29 04:30:13 nsidana ship $ */
3 
4  procedure INSERT_ROW (
5       X_ROWID in out NOCOPY VARCHAR2,
6        x_GROUP_CD IN VARCHAR2,
7        x_NAME_CD IN VARCHAR2,
8        x_DESCRIPTION IN VARCHAR2,
9        x_RUG_SEQUENCE_NUMBER IN NUMBER,
10       X_MODE in VARCHAR2 default 'R'
11   );
12 
13  procedure LOCK_ROW (
14       X_ROWID in  VARCHAR2,
15        x_GROUP_CD IN VARCHAR2,
16        x_NAME_CD IN VARCHAR2,
17        x_DESCRIPTION IN VARCHAR2,
18        x_RUG_SEQUENCE_NUMBER IN NUMBER  );
19  procedure UPDATE_ROW (
20       X_ROWID in  VARCHAR2,
21        x_GROUP_CD IN VARCHAR2,
22        x_NAME_CD IN VARCHAR2,
23        x_DESCRIPTION IN VARCHAR2,
24        x_RUG_SEQUENCE_NUMBER IN NUMBER,
25       X_MODE in VARCHAR2 default 'R'
26   );
27 
28  procedure ADD_ROW (
29       X_ROWID in out NOCOPY VARCHAR2,
30        x_GROUP_CD IN VARCHAR2,
31        x_NAME_CD IN VARCHAR2,
32        x_DESCRIPTION IN VARCHAR2,
33        x_RUG_SEQUENCE_NUMBER IN NUMBER,
34       X_MODE in VARCHAR2 default 'R'
35   ) ;
36 
37 procedure DELETE_ROW (
38   X_ROWID in VARCHAR2
39 ) ;
40   FUNCTION Get_PK_For_Validation (
41     x_group_cd IN VARCHAR2,
42     x_name_cd IN VARCHAR2
43     ) RETURN BOOLEAN ;
44 
45   FUNCTION Get_UK_For_Validation (
46     x_rug_sequence_number IN NUMBER
47     ) RETURN BOOLEAN;
48 
49   PROCEDURE Get_FK_Igs_Ru_Group (
50     x_sequence_number IN NUMBER
51     );
52 
53   PROCEDURE Get_FK_Igs_Ru_Trg_Group_Cd (
54     x_group_cd IN VARCHAR2
55     );
56 
57   PROCEDURE Check_Constraints (
58 		 Column_Name IN VARCHAR2  DEFAULT NULL,
59 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
60   PROCEDURE Before_DML (
61     p_action IN VARCHAR2,
62     x_rowid IN VARCHAR2 DEFAULT NULL,
63     x_group_cd IN VARCHAR2 DEFAULT NULL,
64     x_name_cd IN VARCHAR2 DEFAULT NULL,
65     x_description IN VARCHAR2 DEFAULT NULL,
66     x_rug_sequence_number IN NUMBER DEFAULT NULL,
67     x_creation_date IN DATE DEFAULT NULL,
68     x_created_by IN NUMBER DEFAULT NULL,
69     x_last_update_date IN DATE DEFAULT NULL,
70     x_last_updated_by IN NUMBER DEFAULT NULL,
71     x_last_update_login IN NUMBER DEFAULT NULL
72  );
73 END igs_ru_turin_rule_gr_pkg;