1 package PSB_CONSTRAINT_FORMULAS_PVT as
2 /* $Header: PSBVCFPS.pls 120.2 2005/07/13 11:24:07 shtripat ship $ */
3
4 PROCEDURE Insert_Row
5 (
6 p_api_version IN NUMBER,
7 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8 p_commit IN VARCHAR2 := FND_API.G_FALSE,
9 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10 p_return_status OUT NOCOPY VARCHAR2,
11 p_msg_count OUT NOCOPY NUMBER,
12 p_msg_data OUT NOCOPY VARCHAR2,
13 --
14 P_ROWID in OUT NOCOPY VARCHAR2,
15 P_CONSTRAINT_FORMULA_ID in NUMBER,
16 P_CONSTRAINT_ID in NUMBER,
17 P_STEP_NUMBER in NUMBER,
18 P_BUDGET_YEAR_TYPE_ID in NUMBER,
19 P_BALANCE_TYPE in VARCHAR2,
20 P_CURRENCY_CODE in VARCHAR2,
21 P_TEMPLATE_ID in NUMBER,
22 P_SEGMENT1 in VARCHAR2,
23 P_SEGMENT2 in VARCHAR2,
24 P_SEGMENT3 in VARCHAR2,
25 P_SEGMENT4 in VARCHAR2,
26 P_SEGMENT5 in VARCHAR2,
27 P_SEGMENT6 in VARCHAR2,
28 P_SEGMENT7 in VARCHAR2,
29 P_SEGMENT8 in VARCHAR2,
30 P_SEGMENT9 in VARCHAR2,
31 P_SEGMENT10 in VARCHAR2,
32 P_SEGMENT11 in VARCHAR2,
33 P_SEGMENT12 in VARCHAR2,
34 P_SEGMENT13 in VARCHAR2,
35 P_SEGMENT14 in VARCHAR2,
36 P_SEGMENT15 in VARCHAR2,
37 P_SEGMENT16 in VARCHAR2,
38 P_SEGMENT17 in VARCHAR2,
39 P_SEGMENT18 in VARCHAR2,
40 P_SEGMENT19 in VARCHAR2,
41 P_SEGMENT20 in VARCHAR2,
42 P_SEGMENT21 in VARCHAR2,
43 P_SEGMENT22 in VARCHAR2,
44 P_SEGMENT23 in VARCHAR2,
45 P_SEGMENT24 in VARCHAR2,
46 P_SEGMENT25 in VARCHAR2,
47 P_SEGMENT26 in VARCHAR2,
48 P_SEGMENT27 in VARCHAR2,
49 P_SEGMENT28 in VARCHAR2,
50 P_SEGMENT29 in VARCHAR2,
51 P_SEGMENT30 in VARCHAR2,
52 P_AMOUNT in NUMBER,
53 P_PREFIX_OPERATOR in VARCHAR2,
54 P_POSTFIX_OPERATOR in VARCHAR2,
55 P_PAY_ELEMENT_ID in NUMBER,
56 P_PAY_ELEMENT_OPTION_ID in NUMBER,
57 P_ALLOW_MODIFY in VARCHAR2,
58 P_ELEMENT_VALUE in NUMBER,
59 P_ELEMENT_VALUE_TYPE in VARCHAR2,
60 P_EFFECTIVE_START_DATE in DATE,
61 P_EFFECTIVE_END_DATE in DATE,
62 P_ATTRIBUTE1 in VARCHAR2,
63 P_ATTRIBUTE2 in VARCHAR2,
64 P_ATTRIBUTE3 in VARCHAR2,
65 P_ATTRIBUTE4 in VARCHAR2,
66 P_ATTRIBUTE5 in VARCHAR2,
67 P_CONTEXT in VARCHAR2,
68 P_CONCATENATED_SEGMENTS in VARCHAR2,
69 p_Last_Update_Date DATE,
70 p_Last_Updated_By NUMBER,
71 p_Last_Update_Login NUMBER,
72 p_Created_By NUMBER,
73 p_Creation_Date DATE
74 );
75
76 procedure LOCK_ROW (
77 p_api_version IN NUMBER,
78 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
79 p_commit IN VARCHAR2 := FND_API.G_FALSE,
80 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
81 p_return_status OUT NOCOPY VARCHAR2,
82 p_msg_count OUT NOCOPY NUMBER,
83 p_msg_data OUT NOCOPY VARCHAR2,
84 p_lock_row OUT NOCOPY VARCHAR2,
85 --
86 P_CONSTRAINT_FORMULA_ID in NUMBER,
87 P_CONSTRAINT_ID in NUMBER,
88 P_STEP_NUMBER in NUMBER,
89 P_BUDGET_YEAR_TYPE_ID in NUMBER,
90 P_BALANCE_TYPE in VARCHAR2,
91 P_CURRENCY_CODE in VARCHAR2,
92 P_TEMPLATE_ID in NUMBER,
93 P_SEGMENT1 in VARCHAR2,
94 P_SEGMENT2 in VARCHAR2,
95 P_SEGMENT3 in VARCHAR2,
96 P_SEGMENT4 in VARCHAR2,
97 P_SEGMENT5 in VARCHAR2,
98 P_SEGMENT6 in VARCHAR2,
99 P_SEGMENT7 in VARCHAR2,
100 P_SEGMENT8 in VARCHAR2,
101 P_SEGMENT9 in VARCHAR2,
102 P_SEGMENT10 in VARCHAR2,
103 P_SEGMENT11 in VARCHAR2,
104 P_SEGMENT12 in VARCHAR2,
105 P_SEGMENT13 in VARCHAR2,
106 P_SEGMENT14 in VARCHAR2,
107 P_SEGMENT15 in VARCHAR2,
108 P_SEGMENT16 in VARCHAR2,
109 P_SEGMENT17 in VARCHAR2,
110 P_SEGMENT18 in VARCHAR2,
111 P_SEGMENT19 in VARCHAR2,
112 P_SEGMENT20 in VARCHAR2,
113 P_SEGMENT21 in VARCHAR2,
114 P_SEGMENT22 in VARCHAR2,
115 P_SEGMENT23 in VARCHAR2,
116 P_SEGMENT24 in VARCHAR2,
117 P_SEGMENT25 in VARCHAR2,
118 P_SEGMENT26 in VARCHAR2,
119 P_SEGMENT27 in VARCHAR2,
120 P_SEGMENT28 in VARCHAR2,
121 P_SEGMENT29 in VARCHAR2,
122 P_SEGMENT30 in VARCHAR2,
123 P_AMOUNT in NUMBER,
124 P_PREFIX_OPERATOR in VARCHAR2,
125 P_POSTFIX_OPERATOR in VARCHAR2,
126 P_PAY_ELEMENT_ID in NUMBER,
127 P_PAY_ELEMENT_OPTION_ID in NUMBER,
128 P_ALLOW_MODIFY in VARCHAR2,
129 P_ELEMENT_VALUE in NUMBER,
130 P_ELEMENT_VALUE_TYPE in VARCHAR2,
131 P_EFFECTIVE_START_DATE in DATE,
132 P_EFFECTIVE_END_DATE in DATE,
133 P_ATTRIBUTE1 in VARCHAR2,
134 P_ATTRIBUTE2 in VARCHAR2,
135 P_ATTRIBUTE3 in VARCHAR2,
136 P_ATTRIBUTE4 in VARCHAR2,
137 P_ATTRIBUTE5 in VARCHAR2,
138 P_CONTEXT in VARCHAR2,
139 P_CONCATENATED_SEGMENTS in VARCHAR2
140 );
141
142 procedure UPDATE_ROW (
143 p_api_version IN NUMBER,
144 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
145 p_commit IN VARCHAR2 := FND_API.G_FALSE,
146 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
147 p_return_status OUT NOCOPY VARCHAR2,
148 p_msg_count OUT NOCOPY NUMBER,
149 p_msg_data OUT NOCOPY VARCHAR2,
150 --
151 P_CONSTRAINT_FORMULA_ID in NUMBER,
152 P_CONSTRAINT_ID in NUMBER,
153 P_STEP_NUMBER in NUMBER,
154 P_BUDGET_YEAR_TYPE_ID in NUMBER,
155 P_BALANCE_TYPE in VARCHAR2,
156 P_CURRENCY_CODE in VARCHAR2,
157 P_TEMPLATE_ID in NUMBER,
158 P_SEGMENT1 in VARCHAR2,
159 P_SEGMENT2 in VARCHAR2,
160 P_SEGMENT3 in VARCHAR2,
161 P_SEGMENT4 in VARCHAR2,
162 P_SEGMENT5 in VARCHAR2,
163 P_SEGMENT6 in VARCHAR2,
164 P_SEGMENT7 in VARCHAR2,
165 P_SEGMENT8 in VARCHAR2,
166 P_SEGMENT9 in VARCHAR2,
167 P_SEGMENT10 in VARCHAR2,
168 P_SEGMENT11 in VARCHAR2,
169 P_SEGMENT12 in VARCHAR2,
170 P_SEGMENT13 in VARCHAR2,
171 P_SEGMENT14 in VARCHAR2,
172 P_SEGMENT15 in VARCHAR2,
173 P_SEGMENT16 in VARCHAR2,
174 P_SEGMENT17 in VARCHAR2,
175 P_SEGMENT18 in VARCHAR2,
176 P_SEGMENT19 in VARCHAR2,
177 P_SEGMENT20 in VARCHAR2,
178 P_SEGMENT21 in VARCHAR2,
179 P_SEGMENT22 in VARCHAR2,
180 P_SEGMENT23 in VARCHAR2,
181 P_SEGMENT24 in VARCHAR2,
182 P_SEGMENT25 in VARCHAR2,
183 P_SEGMENT26 in VARCHAR2,
184 P_SEGMENT27 in VARCHAR2,
185 P_SEGMENT28 in VARCHAR2,
186 P_SEGMENT29 in VARCHAR2,
187 P_SEGMENT30 in VARCHAR2,
188 P_AMOUNT in NUMBER,
189 P_PREFIX_OPERATOR in VARCHAR2,
190 P_POSTFIX_OPERATOR in VARCHAR2,
191 P_PAY_ELEMENT_ID in NUMBER,
192 P_PAY_ELEMENT_OPTION_ID in NUMBER,
193 P_ALLOW_MODIFY in VARCHAR2,
194 P_ELEMENT_VALUE in NUMBER,
195 P_ELEMENT_VALUE_TYPE in VARCHAR2,
196 P_EFFECTIVE_START_DATE in DATE,
197 P_EFFECTIVE_END_DATE in DATE,
198 P_ATTRIBUTE1 in VARCHAR2,
199 P_ATTRIBUTE2 in VARCHAR2,
200 P_ATTRIBUTE3 in VARCHAR2,
201 P_ATTRIBUTE4 in VARCHAR2,
202 P_ATTRIBUTE5 in VARCHAR2,
203 P_CONTEXT in VARCHAR2,
204 P_CONCATENATED_SEGMENTS in VARCHAR2,
205 p_Last_Update_Date DATE,
206 p_Last_Updated_By NUMBER,
207 p_Last_Update_Login NUMBER
208 );
209
210
211 procedure DELETE_ROW (
212 p_api_version IN NUMBER,
213 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
214 p_commit IN VARCHAR2 := FND_API.G_FALSE,
215 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
216 p_return_status OUT NOCOPY VARCHAR2,
217 p_msg_count OUT NOCOPY NUMBER,
218 p_msg_data OUT NOCOPY VARCHAR2,
219 --
220 P_CONSTRAINT_FORMULA_ID in NUMBER
221 );
222 end PSB_CONSTRAINT_FORMULAS_PVT;