[Home] [Help]
PACKAGE: APPS.JTF_BRMRULE_PVT
Source
1 PACKAGE JTF_BRMRule_PVT AS
2 /* $Header: jtfvbrs.pls 120.2 2005/07/05 07:45:04 abraina ship $ */
3
4 TYPE BRM_Rule_rec_type IS RECORD
5 ( RULE_ID NUMBER
6 , BRM_OBJECT_TYPE VARCHAR2(30)
7 , BRM_OBJECT_CODE VARCHAR2(30)
8 , SEEDED_FLAG VARCHAR2(1)
9 , VIEW_DEFINITION LONG
10 , VIEW_NAME VARCHAR2(30)
11 , RULE_OWNER NUMBER(15)
12 , START_DATE_ACTIVE DATE
13 , END_DATE_ACTIVE DATE
14 , ATTRIBUTE1 VARCHAR2(150)
15 , ATTRIBUTE2 VARCHAR2(150)
16 , ATTRIBUTE3 VARCHAR2(150)
17 , ATTRIBUTE4 VARCHAR2(150)
18 , ATTRIBUTE5 VARCHAR2(150)
19 , ATTRIBUTE6 VARCHAR2(150)
20 , ATTRIBUTE7 VARCHAR2(150)
21 , ATTRIBUTE8 VARCHAR2(150)
22 , ATTRIBUTE9 VARCHAR2(150)
23 , ATTRIBUTE10 VARCHAR2(150)
24 , ATTRIBUTE11 VARCHAR2(150)
25 , ATTRIBUTE12 VARCHAR2(150)
26 , ATTRIBUTE13 VARCHAR2(150)
27 , ATTRIBUTE14 VARCHAR2(150)
28 , ATTRIBUTE15 VARCHAR2(150)
29 , ATTRIBUTE_CATEGORY VARCHAR2(150)
30 , RULE_NAME VARCHAR2(30)
31 , RULE_DESCRIPTION VARCHAR2(2000)
32 , CREATION_DATE DATE
33 , CREATED_BY NUMBER(15)
34 , LAST_UPDATE_DATE DATE
35 , LAST_UPDATED_BY NUMBER(15)
36 , LAST_UPDATE_LOGIN NUMBER(15)
37 , SECURITY_GROUP_ID NUMBER
38 , OBJECT_VERSION_NUMBER NUMBER
39 , APPLICATION_ID NUMBER
40 );
41
42 --------------------------------------------------------------------------
43 -- Start of comments
44 -- API name : Create_BRMRule
45 -- Type : Private
46 -- Function : Create record in JTF_BRM_RULES_B and _TL tables.
47 -- Pre-reqs : None.
48 -- Parameters :
49 -- name direction type required?
50 -- ---- --------- ---- ---------
51 -- p_api_version IN NUMBER required
52 -- p_init_msg_list IN VARCHAR2 optional
53 -- p_commit IN VARCHAR2 optional
54 -- p_validation_level IN NUMBER optional
55 -- x_return_status OUT VARCHAR2 required
56 -- x_msg_count OUT NUMBER required
57 -- x_msg_data OUT VARCHAR2 required
58 -- p_br_rec IN BRM_Rule_rec_type required
59 -- x_record_id OUT NUMBER required
60 --
61 -- Version : Current version 1.1
62 -- Previous version 1.0
63 -- Initial version 1.1
64 --
65 -- End of comments
66 --------------------------------------------------------------------------
67
68 PROCEDURE Create_BRMRule
69 ( p_api_version IN NUMBER
70 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
71 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
72 , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
73 , x_return_status OUT NOCOPY VARCHAR2
74 , x_msg_count OUT NOCOPY NUMBER
75 , x_msg_data OUT NOCOPY VARCHAR2
76 , p_br_rec IN BRM_Rule_rec_type
77 , x_record_id OUT NOCOPY NUMBER
78 );
79
80 --------------------------------------------------------------------------
81 -- Start of comments
82 -- API name : Update_BRMRule
83 -- Type : Private
84 -- Function : Update record in JTF_BRM_RULES_B and _TL tables.
85 -- Pre-reqs : None.
86 -- Parameters :
87 -- name direction type required?
88 -- ---- --------- ---- ---------
89 -- p_api_version IN NUMBER required
90 -- p_init_msg_list IN VARCHAR2 optional
91 -- p_commit IN VARCHAR2 optional
92 -- p_validation_level IN NUMBER optional
93 -- x_return_status OUT VARCHAR2 required
94 -- x_msg_count OUT NUMBER required
95 -- x_msg_data OUT VARCHAR2 required
96 -- p_br_rec IN BRM_Rule_rec_type required
97 --
98 -- Version : Current version 1.1
99 -- Previous version 1.0
100 -- Initial version 1.0
101 --
102 -- Notes:
103 --
104 -- End of comments
105 --------------------------------------------------------------------------
106 PROCEDURE Update_BRMRule
107 ( p_api_version IN NUMBER
108 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
109 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
110 , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
111 , x_return_status OUT NOCOPY VARCHAR2
112 , x_msg_count OUT NOCOPY NUMBER
113 , x_msg_data OUT NOCOPY VARCHAR2
114 , p_br_rec IN BRM_Rule_rec_type
115 );
116
117 --------------------------------------------------------------------------
118 -- Start of comments
119 -- API Name : Delete_BRMRule
120 -- Type : Private
121 -- Description : Delete record in JTF_BRM_RULES_B and _TL tables.
122 -- Pre-reqs : None
123 -- Parameters :
124 -- name direction type required?
125 -- ---- --------- ---- ---------
126 -- p_api_version IN NUMBER required
127 -- p_init_msg_list IN VARCHAR2 optional
128 -- p_commit IN VARCHAR2 optional
129 -- p_validation_level IN NUMBER optional
130 -- x_return_status OUT VARCHAR2 required
131 -- x_msg_count OUT NUMBER required
132 -- x_msg_data OUT VARCHAR2 required
133 -- p_rule_id IN NUMBER required
134 --
135 -- Version : Current version 1.1
136 -- Previous version 1.0
137 -- Initial version 1.0
138 --
139 -- Notes: :
140 --
141 -- End of comments
142 --------------------------------------------------------------------------
143
144 PROCEDURE Delete_BRMRule
145 ( p_api_version IN NUMBER
146 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
147 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
148 , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
149 , x_return_status OUT NOCOPY VARCHAR2
150 , x_msg_count OUT NOCOPY NUMBER
151 , x_msg_data OUT NOCOPY VARCHAR2
152 , p_rule_id IN NUMBER
153 );
154 --------------------------------------------------------------------------
155 -- Start of comments
156 -- API Name : Add_Language
157 -- Type : Private
158 -- Description : Additional Language processing for JTF_BRM_RULES_B and
159 -- _TL tables.
160 -- Pre-reqs : None
161 -- Parameters : None
162 -- Version : Current version 1.0
163 -- Previous version none
164 -- Initial version 1.0
165 --
166 -- Notes:
167 --
168 -- End of comments
169 --------------------------------------------------------------------------
170 PROCEDURE Add_Language;
171
172 --------------------------------------------------------------------------
173 -- Start of comments
174 -- API Name : Translate_Row
175 -- Type : Private
176 -- Description : Additional Language processing for JTF_BRM_RULES_B and
177 -- _TL tables. Used in the FNDLOAD definition file (.lct)
178 -- Pre-reqs : None
179 -- Parameters : None
180 -- Version : Current version 1.0
181 -- Previous version none
182 -- Initial version 1.0
183 --
184 -- Notes:
185 --
186 -- End of comments
187 --------------------------------------------------------------------------
188 PROCEDURE Translate_Row
189 ( p_rule_id IN NUMBER
190 , p_rule_name IN VARCHAR2
191 , p_rule_description IN VARCHAR2
192 , p_owner IN VARCHAR2
193 );
194
195 --------------------------------------------------------------------------
196 -- Start of comments
197 -- API Name : Load_Row
198 -- Type : Private
199 -- Description : Additional Language processing for JTF_BRM_RULES_B and
200 -- _TL tables. Used in the FNDLOAD definition file (.lct)
201 -- Pre-reqs : None
202 -- Parameters : None
203 -- Version : Current version 1.0
204 -- Previous version none
205 -- Initial version 1.0
206 --
207 -- Notes:
208 --
209 -- End of comments
210 --------------------------------------------------------------------------
211 PROCEDURE Load_Row
212 ( p_rule_id IN NUMBER
213 , p_br_rec IN BRM_Rule_rec_type
214 , p_owner IN VARCHAR2
215 );
216
217 END JTF_BRMRule_PVT;