[Home] [Help]
PACKAGE: APPS.JTF_BRMPROCESS_PVT
Source
1 PACKAGE JTF_BRMProcess_PVT AUTHID CURRENT_USER AS
2 /* $Header: jtfvbprs.pls 120.3 2005/07/05 07:44:39 abraina ship $ */
3 /*#
4 * Private APIs for the Business Rule module.
5 * @rep:scope private
6 * @rep:product JTA
7 * @rep:displayname JTF BRM Process Private API
8 * @rep:lifecycle active
9 * @rep:compatibility S
10 * @rep:category BUSINESS_ENTITY JTA_BUSINESS_RULE
11 */
12
13 TYPE BRM_Process_rec_type IS RECORD
14 ( PROCESS_ID NUMBER
15 , RULE_ID NUMBER
16 , CREATED_BY NUMBER(15)
17 , CREATION_DATE DATE
18 , LAST_UPDATED_BY NUMBER(15)
19 , LAST_UPDATE_DATE DATE
20 , LAST_UPDATE_LOGIN NUMBER(15)
21 , SEEDED_FLAG VARCHAR2(1)
22 , LAST_BRM_CHECK_DATE DATE
23 , BRM_UOM_TYPE VARCHAR2(30)
24 , BRM_CHECK_UOM_CODE VARCHAR2(30)
25 , BRM_CHECK_INTERVAL NUMBER(9)
26 , BRM_TOLERANCE_UOM_CODE VARCHAR2(30)
27 , BRM_TOLERANCE_INTERVAL NUMBER(9)
28 , WORKFLOW_ITEM_TYPE VARCHAR2(8)
29 , WORKFLOW_PROCESS_NAME VARCHAR2(30)
30 , START_DATE_ACTIVE DATE
31 , END_DATE_ACTIVE DATE
32 , ATTRIBUTE1 VARCHAR2(150)
33 , ATTRIBUTE2 VARCHAR2(150)
34 , ATTRIBUTE3 VARCHAR2(150)
35 , ATTRIBUTE4 VARCHAR2(150)
36 , ATTRIBUTE5 VARCHAR2(150)
37 , ATTRIBUTE6 VARCHAR2(150)
38 , ATTRIBUTE7 VARCHAR2(150)
39 , ATTRIBUTE8 VARCHAR2(150)
40 , ATTRIBUTE9 VARCHAR2(150)
41 , ATTRIBUTE10 VARCHAR2(150)
42 , ATTRIBUTE11 VARCHAR2(150)
43 , ATTRIBUTE12 VARCHAR2(150)
44 , ATTRIBUTE13 VARCHAR2(150)
45 , ATTRIBUTE14 VARCHAR2(150)
46 , ATTRIBUTE15 VARCHAR2(150)
47 , ATTRIBUTE_CATEGORY VARCHAR2(30)
48 , SECURITY_GROUP_ID NUMBER
49 , OBJECT_VERSION_NUMBER NUMBER
50 , APPLICATION_ID NUMBER
51 );
52
53 --------------------------------------------------------------------------
54 -- Start of comments
55 -- API name : Create_BRMProcess
56 -- Type : Private
57 -- Function : Create record in JTF_BRM_PROCESSES table.
58 -- Pre-reqs : None.
59 -- Parameters :
60 -- name direction type required?
61 -- ---- --------- ---- ---------
62 -- p_api_version IN NUMBER required
63 -- p_init_msg_list IN VARCHAR2 optional
64 -- p_commit IN VARCHAR2 optional
65 -- p_validation_level IN NUMBER optional
66 -- x_return_status OUT VARCHAR2 required
67 -- x_msg_count OUT NUMBER required
68 -- x_msg_data OUT VARCHAR2 required
69 -- p_BRMProcess_rec IN brm_process_rec_type required
70 -- x_record_id OUT NUMBER required
71 --
72 -- Version : Current version 1.1
73 -- Previous version 1.0
74 -- Initial version 1.0
75 --
76 -- End of comments
77 --------------------------------------------------------------------------
78 /*#
79 * Create record in JTF_BRM_PROCESSES table.
80 * @param p_api_version API Version Required
81 * @param p_init_msg_list Initialize message list flag, Optional Default = FND_API.G_FALSE
82 * @param p_commit Optional Default = FND_API.G_FALSE
83 * @param p_validation_level Optional DEFAULT fnd_api.g_valid_level_full
84 * @param x_return_status Required Length = 1
85 * @param x_msg_count API Error message count, Required
86 * @param x_msg_data API Error message data, Required Length = 2000
87 * @param p_bpr_rec Required take input record type object "BRM_Process_rec_type"
88 * @param x_record_id Required
89 * @rep:scope public
90 * @rep:lifecycle active
91 * @rep:displayname Create BRM Process
92 */
93 PROCEDURE Create_BRMProcess
94 ( p_api_version IN NUMBER
95 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
96 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
97 , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
98 , x_return_status OUT NOCOPY VARCHAR2
99 , x_msg_count OUT NOCOPY NUMBER
100 , x_msg_data OUT NOCOPY VARCHAR2
101 , p_bpr_rec IN BRM_Process_rec_type
102 , x_record_id OUT NOCOPY NUMBER
103 );
104
105 --------------------------------------------------------------------------
106 -- Start of comments
107 -- API name : Update_BRMParameter
108 -- Type : Private
109 -- Function : Update record in JTF_BRM_PROCESSES table.
110 -- Pre-reqs : None.
111 -- Parameters :
112 -- name direction type required?
113 -- ---- --------- ---- ---------
114 -- p_api_version IN NUMBER required
115 -- p_init_msg_list IN VARCHAR2 optional
116 -- p_commit IN VARCHAR2 optional
117 -- p_validation_level IN NUMBER optional
118 -- x_return_status OUT VARCHAR2 required
119 -- x_msg_count OUT NUMBER required
120 -- x_msg_data OUT VARCHAR2 required
121 -- p_BRMProcess_rec IN brm_Process_rec_type required
122 --
123 -- Version : Current version 1.1
124 -- Previous version 1.0
125 -- Initial Version 1.0
126 --
127 -- Notes:
128 --
129 -- End of comments
130 --------------------------------------------------------------------------
131 /*#
132 * Update record in JTF_BRM_PROCESSES table.
133 * @param p_api_version API Version Required
134 * @param p_init_msg_list Initialize message list flag, Optional Default = FND_API.G_FALSE
135 * @param p_commit Optional Default = FND_API.G_FALSE
136 * @param p_validation_level Optional DEFAULT fnd_api.g_valid_level_full
137 * @param x_return_status Required Length = 1
138 * @param x_msg_count API Error message count, Required
139 * @param x_msg_data API Error message data, Required Length = 2000
140 * @param p_bpr_rec Required take input record type object "BRM_Process_rec_type"
141 * @rep:scope public
142 * @rep:lifecycle active
143 * @rep:displayname Update BRM Process
144 */
145 PROCEDURE Update_BRMProcess
146 ( p_api_version IN NUMBER
147 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
148 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
149 , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
150 , x_return_status OUT NOCOPY VARCHAR2
151 , x_msg_count OUT NOCOPY NUMBER
152 , x_msg_data OUT NOCOPY VARCHAR2
153 , p_bpr_rec IN BRM_Process_rec_type
154 );
155
156 --------------------------------------------------------------------------
157 -- Start of comments
158 -- API Name : Delete_BRMParameter
159 -- Type : Private
160 -- Description : Delete record in JTF_BRM_PROCESSES table.
161 -- Pre-reqs : None
162 -- Parameters :
163 -- name direction type required?
164 -- ---- --------- ---- ---------
165 -- p_api_version IN NUMBER required
166 -- p_init_msg_list IN VARCHAR2 optional
167 -- p_commit IN VARCHAR2 optional
168 -- p_validation_level IN NUMBER optional
169 -- x_return_status OUT VARCHAR2 required
170 -- x_msg_count OUT NUMBER required
171 -- x_msg_data OUT VARCHAR2 required
172 -- p_Process_id IN NUMBER required
173 --
174 -- Version : Current version 1.1
175 -- Previous version 1.0
176 -- Initial version 1.0
177 --
178 -- Notes: :
179 --
180 -- End of comments
181 --------------------------------------------------------------------------
182 /*#
183 * Delete record in JTF_BRM_PROCESSES table.
184 * @param p_api_version API Version Required
185 * @param p_init_msg_list Initialize message list flag, Optional Default = FND_API.G_FALSE
186 * @param p_commit Optional Default = FND_API.G_FALSE
187 * @param p_validation_level Optional DEFAULT fnd_api.g_valid_level_full
188 * @param x_return_status Required Length = 1
189 * @param x_msg_count API Error message count, Required
190 * @param x_msg_data API Error message data, Required Length = 2000
191 * @param p_process_id Required input process id to be deleted.
192 * @rep:scope public
193 * @rep:lifecycle active
194 * @rep:displayname Delete BRM Process
195 */
196 PROCEDURE Delete_BRMProcess
197 ( p_api_version IN NUMBER
198 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
199 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
200 , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
201 , x_return_status OUT NOCOPY VARCHAR2
202 , x_msg_count OUT NOCOPY NUMBER
203 , x_msg_data OUT NOCOPY VARCHAR2
204 , p_process_id IN NUMBER
205 );
206
207 END JTF_BRMProcess_PVT;