PACKAGE: APPS.IGS_RU_NAMED_RULE_GR_PKG

Source

1 PACKAGE igs_ru_named_rule_gr_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSUI17S.pls 115.6 2002/11/29 04:29:37 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_S_RETURN_TYPE IN VARCHAR2,
10        x_RUG_SEQUENCE_NUMBER IN NUMBER,
11        x_SELECT_GROUP IN NUMBER,
12        x_MESSAGE_GROUP IN NUMBER,
13       X_MODE in VARCHAR2 default 'R'
14   );
15 
16  procedure LOCK_ROW (
17       X_ROWID in  VARCHAR2,
18        x_GROUP_CD IN VARCHAR2,
19        x_NAME_CD IN VARCHAR2,
20        x_DESCRIPTION IN VARCHAR2,
21        x_S_RETURN_TYPE IN VARCHAR2,
22        x_RUG_SEQUENCE_NUMBER IN NUMBER,
23        x_SELECT_GROUP IN NUMBER,
24        x_MESSAGE_GROUP IN NUMBER  );
25 
26  procedure UPDATE_ROW (
27       X_ROWID in  VARCHAR2,
28        x_GROUP_CD IN VARCHAR2,
29        x_NAME_CD IN VARCHAR2,
30        x_DESCRIPTION IN VARCHAR2,
31        x_S_RETURN_TYPE IN VARCHAR2,
32        x_RUG_SEQUENCE_NUMBER IN NUMBER,
33        x_SELECT_GROUP IN NUMBER,
34        x_MESSAGE_GROUP IN NUMBER,
35       X_MODE in VARCHAR2 default 'R'
36   );
37 
38  procedure ADD_ROW (
39       X_ROWID in out NOCOPY VARCHAR2,
40        x_GROUP_CD IN VARCHAR2,
41        x_NAME_CD IN VARCHAR2,
42        x_DESCRIPTION IN VARCHAR2,
43        x_S_RETURN_TYPE IN VARCHAR2,
44        x_RUG_SEQUENCE_NUMBER IN NUMBER,
45        x_SELECT_GROUP IN NUMBER,
46        x_MESSAGE_GROUP IN NUMBER,
47       X_MODE in VARCHAR2 default 'R'
48   ) ;
49 
50 procedure DELETE_ROW (
51   X_ROWID in VARCHAR2
52 ) ;
53   FUNCTION Get_PK_For_Validation (
54     x_group_cd IN VARCHAR2,
55     x_name_cd IN VARCHAR2
56     ) RETURN BOOLEAN ;
57 
58   PROCEDURE Get_FK_Igs_Ru_Ret_Type (
59     x_s_return_type IN VARCHAR2
60     );
61 
62   PROCEDURE Get_FK_Igs_Ru_Nrg_Group_Cd (
63     x_group_cd IN VARCHAR2
64     );
65 
66   PROCEDURE Get_FK_Igs_Ru_Group_sg (
67     x_sequence_number IN NUMBER
68     );
69 
70   PROCEDURE Get_FK_Igs_Ru_Group_msg (
71     x_sequence_number IN NUMBER
72     );
73 
74   PROCEDURE Get_FK_Igs_Ru_Group_seq (
75     x_sequence_number IN NUMBER
76     );
77 
78   PROCEDURE Check_Constraints (
79 		 Column_Name IN VARCHAR2  DEFAULT NULL,
80 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
81   PROCEDURE Before_DML (
82     p_action IN VARCHAR2,
83     x_rowid IN VARCHAR2 DEFAULT NULL,
84     x_group_cd IN VARCHAR2 DEFAULT NULL,
85     x_name_cd IN VARCHAR2 DEFAULT NULL,
86     x_description IN VARCHAR2 DEFAULT NULL,
87     x_s_return_type IN VARCHAR2 DEFAULT NULL,
88     x_rug_sequence_number IN NUMBER DEFAULT NULL,
89     x_select_group IN NUMBER DEFAULT NULL,
90     x_message_group IN NUMBER DEFAULT NULL,
91     x_creation_date IN DATE DEFAULT NULL,
92     x_created_by IN NUMBER DEFAULT NULL,
93     x_last_update_date IN DATE DEFAULT NULL,
94     x_last_updated_by IN NUMBER DEFAULT NULL,
95     x_last_update_login IN NUMBER DEFAULT NULL
96  );
97 END igs_ru_named_rule_gr_pkg;