1 package PSB_ENTITY_PVT as
2 /* $Header: PSBVENPS.pls 120.2 2005/07/13 11:24:54 shtripat ship $ */
3
4 procedure INSERT_ROW (
5 p_api_version IN NUMBER,
6 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7 p_commit IN VARCHAR2 := FND_API.G_FALSE,
8 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9 p_return_status OUT NOCOPY VARCHAR2,
10 p_msg_count OUT NOCOPY NUMBER,
11 p_msg_data OUT NOCOPY VARCHAR2,
12 --
13 P_ROWID in OUT NOCOPY VARCHAR2,
14 P_ENTITY_ID in NUMBER,
15 P_ENTITY_TYPE in VARCHAR2,
16 P_ENTITY_SUBTYPE in VARCHAR2,
17 P_NAME in VARCHAR2,
18 P_DESCRIPTION in VARCHAR2,
19 P_DATA_EXTRACT_ID in NUMBER,
20 P_SET_OF_BOOKS_ID in NUMBER,
21 P_BUDGET_GROUP_ID in NUMBER := FND_API.G_MISS_NUM,
22 P_ALLOCATION_TYPE in VARCHAR2,
23 P_BUDGET_YEAR_TYPE_ID in NUMBER,
24 P_BALANCE_TYPE in VARCHAR2,
25 P_PARAMETER_AUTOINC_RULE in VARCHAR2,
26 P_PARAMETER_COMPOUND_ANNUALLY in VARCHAR2,
27 P_CURRENCY_CODE in VARCHAR2,
28 P_FTE_CONSTRAINT in VARCHAR2,
29 P_CONSTRAINT_DETAILED_FLAG in VARCHAR2,
30 /* Budget Revision Rules Enhancement Start */
31 P_APPLY_ACCOUNT_SET_FLAG in VARCHAR2,
32 P_BALANCE_ACCOUNT_SET_FLAG in VARCHAR2,
33 /* Budget Revision Rules Enhancement End */
34 P_ATTRIBUTE1 in VARCHAR2,
35 P_ATTRIBUTE2 in VARCHAR2,
36 P_ATTRIBUTE3 in VARCHAR2,
37 P_ATTRIBUTE4 in VARCHAR2,
38 P_ATTRIBUTE5 in VARCHAR2,
39 P_ATTRIBUTE6 in VARCHAR2,
40 P_ATTRIBUTE7 in VARCHAR2,
41 P_ATTRIBUTE8 in VARCHAR2,
42 P_ATTRIBUTE9 in VARCHAR2,
43 P_ATTRIBUTE10 in VARCHAR2,
44 P_CONTEXT in VARCHAR2,
45 P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,
46 P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE,
47 p_Last_Update_Date DATE,
48 p_Last_Updated_By NUMBER,
49 p_Last_Update_Login NUMBER,
50 p_Created_By NUMBER,
51 p_Creation_Date DATE
52 );
53
54 procedure LOCK_ROW (
55 p_api_version IN NUMBER,
56 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57 p_commit IN VARCHAR2 := FND_API.G_FALSE,
58 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59 p_return_status OUT NOCOPY VARCHAR2,
60 p_msg_count OUT NOCOPY NUMBER,
61 p_msg_data OUT NOCOPY VARCHAR2,
62 p_lock_row OUT NOCOPY VARCHAR2,
63 --
64 P_ENTITY_ID in NUMBER,
65 P_ENTITY_TYPE in VARCHAR2,
66 P_ENTITY_SUBTYPE in VARCHAR2,
67 P_NAME in VARCHAR2,
68 P_DESCRIPTION in VARCHAR2,
69 P_DATA_EXTRACT_ID in NUMBER,
70 P_SET_OF_BOOKS_ID in NUMBER,
71 P_BUDGET_GROUP_ID in NUMBER := FND_API.G_MISS_NUM,
72 P_ALLOCATION_TYPE in VARCHAR2,
73 P_BUDGET_YEAR_TYPE_ID in NUMBER,
74 P_BALANCE_TYPE in VARCHAR2,
75 P_PARAMETER_AUTOINC_RULE in VARCHAR2,
76 P_PARAMETER_COMPOUND_ANNUALLY in VARCHAR2,
77 P_CURRENCY_CODE in VARCHAR2,
78 P_FTE_CONSTRAINT in VARCHAR2,
79 P_CONSTRAINT_DETAILED_FLAG in VARCHAR2,
80 /* Budget Revision Rules Enhancement Start */
81 P_APPLY_ACCOUNT_SET_FLAG in VARCHAR2,
82 P_BALANCE_ACCOUNT_SET_FLAG in VARCHAR2,
83 /* Budget Revision Rules Enhancement End */
84 P_ATTRIBUTE1 in VARCHAR2,
85 P_ATTRIBUTE2 in VARCHAR2,
86 P_ATTRIBUTE3 in VARCHAR2,
87 P_ATTRIBUTE4 in VARCHAR2,
88 P_ATTRIBUTE5 in VARCHAR2,
89 P_ATTRIBUTE6 in VARCHAR2,
90 P_ATTRIBUTE7 in VARCHAR2,
91 P_ATTRIBUTE8 in VARCHAR2,
92 P_ATTRIBUTE9 in VARCHAR2,
93 P_ATTRIBUTE10 in VARCHAR2,
94 P_CONTEXT in VARCHAR2,
95 P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,
96 P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE);
97
98 procedure UPDATE_ROW (
99 p_api_version IN NUMBER,
100 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
101 p_commit IN VARCHAR2 := FND_API.G_FALSE,
102 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
103 p_return_status OUT NOCOPY VARCHAR2,
104 p_msg_count OUT NOCOPY NUMBER,
105 p_msg_data OUT NOCOPY VARCHAR2,
106 --
107 P_ENTITY_ID in NUMBER,
108 P_ENTITY_TYPE in VARCHAR2,
109 P_ENTITY_SUBTYPE in VARCHAR2,
110 P_NAME in VARCHAR2,
111 P_DESCRIPTION in VARCHAR2,
112 P_DATA_EXTRACT_ID in NUMBER,
113 P_SET_OF_BOOKS_ID in NUMBER,
114 P_BUDGET_GROUP_ID in NUMBER := FND_API.G_MISS_NUM,
115 P_ALLOCATION_TYPE in VARCHAR2,
116 P_BUDGET_YEAR_TYPE_ID in NUMBER,
117 P_BALANCE_TYPE in VARCHAR2,
118 P_PARAMETER_AUTOINC_RULE in VARCHAR2,
119 P_PARAMETER_COMPOUND_ANNUALLY in VARCHAR2,
120 P_CURRENCY_CODE in VARCHAR2,
121 P_FTE_CONSTRAINT in VARCHAR2,
122 P_CONSTRAINT_DETAILED_FLAG in VARCHAR2,
123 /* Budget Revision Rules Enhancement Start */
124 P_APPLY_ACCOUNT_SET_FLAG in VARCHAR2,
125 P_BALANCE_ACCOUNT_SET_FLAG in VARCHAR2,
126 /* Budget Revision Rules Enhancement End */
127 P_ATTRIBUTE1 in VARCHAR2,
128 P_ATTRIBUTE2 in VARCHAR2,
129 P_ATTRIBUTE3 in VARCHAR2,
130 P_ATTRIBUTE4 in VARCHAR2,
131 P_ATTRIBUTE5 in VARCHAR2,
132 P_ATTRIBUTE6 in VARCHAR2,
133 P_ATTRIBUTE7 in VARCHAR2,
134 P_ATTRIBUTE8 in VARCHAR2,
135 P_ATTRIBUTE9 in VARCHAR2,
136 P_ATTRIBUTE10 in VARCHAR2,
137 P_CONTEXT in VARCHAR2,
138 P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,
139 P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE,
140 p_Last_Update_Date DATE,
141 p_Last_Updated_By NUMBER,
142 p_Last_Update_Login NUMBER
143 );
144
145
146 procedure ADD_ROW(
147 p_api_version IN NUMBER,
148 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
149 p_commit IN VARCHAR2 := FND_API.G_FALSE,
150 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151 p_return_status OUT NOCOPY VARCHAR2,
152 p_msg_count OUT NOCOPY NUMBER,
153 p_msg_data OUT NOCOPY VARCHAR2,
154 --
155 P_ROWID in OUT NOCOPY VARCHAR2,
156 P_ENTITY_ID in NUMBER,
157 P_ENTITY_TYPE in VARCHAR2,
158 P_ENTITY_SUBTYPE in VARCHAR2,
159 P_NAME in VARCHAR2,
160 P_DESCRIPTION in VARCHAR2,
161 P_DATA_EXTRACT_ID in NUMBER,
162 P_SET_OF_BOOKS_ID in NUMBER,
163 P_BUDGET_GROUP_ID in NUMBER := FND_API.G_MISS_NUM,
164 P_ALLOCATION_TYPE in VARCHAR2,
165 P_BUDGET_YEAR_TYPE_ID in NUMBER,
166 P_BALANCE_TYPE in VARCHAR2,
167 P_PARAMETER_AUTOINC_RULE in VARCHAR2,
168 P_PARAMETER_COMPOUND_ANNUALLY in VARCHAR2,
169 P_CURRENCY_CODE in VARCHAR2,
170 P_FTE_CONSTRAINT in VARCHAR2,
171 P_CONSTRAINT_DETAILED_FLAG in VARCHAR2,
172 /* Budget Revision Rules Enhancement Start */
173 P_APPLY_ACCOUNT_SET_FLAG in VARCHAR2,
174 P_BALANCE_ACCOUNT_SET_FLAG in VARCHAR2,
175 /* Budget Revision Rules Enhancement End */
176 P_ATTRIBUTE1 in VARCHAR2,
177 P_ATTRIBUTE2 in VARCHAR2,
178 P_ATTRIBUTE3 in VARCHAR2,
179 P_ATTRIBUTE4 in VARCHAR2,
180 P_ATTRIBUTE5 in VARCHAR2,
181 P_ATTRIBUTE6 in VARCHAR2,
182 P_ATTRIBUTE7 in VARCHAR2,
183 P_ATTRIBUTE8 in VARCHAR2,
184 P_ATTRIBUTE9 in VARCHAR2,
185 P_ATTRIBUTE10 in VARCHAR2,
186 P_CONTEXT in VARCHAR2,
187 P_EFFECTIVE_START_DATE in DATE := FND_API.G_MISS_DATE,
188 P_EFFECTIVE_END_DATE in DATE := FND_API.G_MISS_DATE,
189 p_Last_Update_Date DATE,
190 p_Last_Updated_By NUMBER,
191 p_Last_Update_Login NUMBER,
192 p_Created_By NUMBER,
193 p_Creation_Date DATE
194 );
195
196
197 procedure DELETE_ROW (
198 p_api_version IN NUMBER,
199 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
200 p_commit IN VARCHAR2 := FND_API.G_FALSE,
201 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
202 p_return_status OUT NOCOPY VARCHAR2,
203 p_msg_count OUT NOCOPY NUMBER,
204 p_msg_data OUT NOCOPY VARCHAR2,
205 --
206 P_ENTITY_ID in NUMBER
207 );
208
209
210 end PSB_ENTITY_PVT;