[Home] [Help]
PACKAGE: APPS.JTF_BRMEXPRESSIONLINE_PVT
Source
1 PACKAGE JTF_BRMExpressionLine_PVT AS
2 /* $Header: jtfvbels.pls 120.2 2005/07/05 07:44:23 abraina ship $ */
3
4 TYPE brm_expression_line_rec_type IS RECORD
5 ( EXPRESSION_LINE_ID NUMBER
6 , RULE_ID NUMBER
7 , CREATED_BY NUMBER(15)
8 , CREATION_DATE DATE
9 , LAST_UPDATED_BY NUMBER(15)
10 , LAST_UPDATE_DATE DATE
11 , LAST_UPDATE_LOGIN NUMBER(15)
12 , SORT_SEQUENCE NUMBER(9)
13 , BRM_LEFT_PARENTHESIS_TYPE VARCHAR2(30)
14 , BRM_LEFT_PARENTHESIS_CODE VARCHAR2(30)
15 , LEFT_VALUE VARCHAR2(50)
16 , BRM_OPERATOR_TYPE VARCHAR2(30)
17 , BRM_OPERATOR_CODE VARCHAR2(30)
18 , RIGHT_VALUE VARCHAR2(50)
19 , BRM_RIGHT_PARENTHESIS_TYPE VARCHAR2(30)
20 , BRM_RIGHT_PARENTHESIS_CODE VARCHAR2(30)
21 , BRM_BOOLEAN_OPERATOR_TYPE VARCHAR2(30)
22 , BRM_BOOLEAN_OPERATOR_CODE VARCHAR2(30)
23 , ATTRIBUTE1 VARCHAR2(150)
24 , ATTRIBUTE2 VARCHAR2(150)
25 , ATTRIBUTE3 VARCHAR2(150)
26 , ATTRIBUTE4 VARCHAR2(150)
27 , ATTRIBUTE5 VARCHAR2(150)
28 , ATTRIBUTE6 VARCHAR2(150)
29 , ATTRIBUTE7 VARCHAR2(150)
30 , ATTRIBUTE8 VARCHAR2(150)
31 , ATTRIBUTE9 VARCHAR2(150)
32 , ATTRIBUTE10 VARCHAR2(150)
33 , ATTRIBUTE11 VARCHAR2(150)
34 , ATTRIBUTE12 VARCHAR2(150)
35 , ATTRIBUTE13 VARCHAR2(150)
36 , ATTRIBUTE14 VARCHAR2(150)
37 , ATTRIBUTE15 VARCHAR2(150)
38 , ATTRIBUTE_CATEGORY VARCHAR2(30)
39 , SECURITY_GROUP_ID NUMBER
40 , OBJECT_VERSION_NUMBER NUMBER
41 , APPLICATION_ID NUMBER
42 );
43
44 --------------------------------------------------------------------------
45 -- Start of comments
46 -- API name : Create_ExpressionLine
47 -- Type : Private
48 -- Function : Create record in JTF_BRM_EXPRESSION_LINE table.
49 -- Pre-reqs : None.
50 -- Parameters :
51 -- name direction type required?
52 -- ---- --------- ---- ---------
53 -- p_api_version IN NUMBER required
54 -- p_init_msg_list IN VARCHAR2 optional
55 -- p_commit IN VARCHAR2 optional
56 -- p_validation_level IN NUMBER optional
57 -- x_return_status OUT VARCHAR2 required
58 -- x_msg_count OUT NUMBER required
59 -- x_msg_data OUT VARCHAR2 required
60 -- p_bel_rec IN brm_expression_line_rec_type required
61 -- x_record_id OUT NUMBER required
62 --
63 -- Version : Current version 1.1
64 -- Previous version 1.0
65 -- Initial version 1.0
66 --
67 -- End of comments
68 --------------------------------------------------------------------------
69 PROCEDURE Create_ExpressionLine
70 ( p_api_version IN NUMBER
71 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
72 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
73 , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
74 , x_return_status OUT NOCOPY VARCHAR2
75 , x_msg_count OUT NOCOPY NUMBER
76 , x_msg_data OUT NOCOPY VARCHAR2
77 , p_bel_rec IN brm_expression_line_rec_type
78 , x_record_id OUT NOCOPY NUMBER
79 );
80
81 --------------------------------------------------------------------------
82 -- Start of comments
83 -- API name : Update_ExpressionLine
84 -- Type : Private
85 -- Function : Update record in JTF_BRM_EXPRESSION_LINE table.
86 -- Pre-reqs : None.
87 -- Parameters :
88 -- name direction type required?
89 -- ---- --------- ---- ---------
90 -- p_api_version IN NUMBER required
91 -- p_init_msg_list IN VARCHAR2 optional
92 -- p_commit IN VARCHAR2 optional
93 -- p_validation_level IN NUMBER optional
94 -- x_return_status OUT VARCHAR2 required
95 -- x_msg_count OUT NUMBER required
96 -- x_msg_data OUT VARCHAR2 required
97 -- p_bel_rec IN brm_expression_line_rec_type required
98 --
99 -- Version : Current version 1.1
100 -- Previous version 1.0
101 -- Initial version 1.0
102 --
103 -- Notes:
104 --
105 -- End of comments
106 --------------------------------------------------------------------------
107 PROCEDURE Update_ExpressionLine
108 ( p_api_version IN NUMBER
109 , p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false
110 , p_commit IN VARCHAR2 DEFAULT fnd_api.g_false
111 , p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full
112 , x_return_status OUT NOCOPY VARCHAR2
113 , x_msg_count OUT NOCOPY NUMBER
114 , x_msg_data OUT NOCOPY VARCHAR2
115 , p_bel_rec IN brm_expression_line_rec_type
116 );
117
118
119 --------------------------------------------------------------------------
120 -- Start of comments
121 -- API Name : Delete_ExpressionLine
122 -- Type : Private
123 -- Description : Delete record in JTF_BRM_EXPRESSION_LINE table.
124 -- Pre-reqs : None
125 -- Parameters :
126 -- name direction type required?
127 -- ---- --------- ---- ---------
128 -- p_api_version IN NUMBER required
129 -- p_init_msg_list IN VARCHAR2 optional
130 -- p_commit IN VARCHAR2 optional
131 -- p_validation_level IN NUMBER optional
132 -- x_return_status OUT VARCHAR2 required
133 -- x_msg_count OUT NUMBER required
134 -- x_msg_data OUT VARCHAR2 required
135 -- p_expression_line_id IN NUMBER required
136 --
137 -- Version : Current version 1.1
138 -- Previous version 1.0
139 -- Initial version 1.0
140 --
141 -- Notes: :
142 --
143 -- End of comments
144 --------------------------------------------------------------------------
145 PROCEDURE Delete_ExpressionLine
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_expression_line_id IN NUMBER
154 );
155
156
157 END JTF_BRMExpressionLine_PVT;