75:
76:
77: PROCEDURE Create_Comp_Dim_Member (
78: p_api_version IN NUMBER ,
79: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
80: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
81: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
82: p_return_status OUT NOCOPY VARCHAR2 ,
83: p_msg_count OUT NOCOPY NUMBER ,
76:
77: PROCEDURE Create_Comp_Dim_Member (
78: p_api_version IN NUMBER ,
79: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
80: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
81: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
82: p_return_status OUT NOCOPY VARCHAR2 ,
83: p_msg_count OUT NOCOPY NUMBER ,
84: p_msg_data OUT NOCOPY VARCHAR2 ,
77: PROCEDURE Create_Comp_Dim_Member (
78: p_api_version IN NUMBER ,
79: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
80: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
81: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
82: p_return_status OUT NOCOPY VARCHAR2 ,
83: p_msg_count OUT NOCOPY NUMBER ,
84: p_msg_data OUT NOCOPY VARCHAR2 ,
85: --
120:
121:
122: PROCEDURE Member_Insert_Row (
123: p_api_version IN NUMBER ,
124: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
125: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
127: p_return_status OUT NOCOPY VARCHAR2 ,
128: p_msg_count OUT NOCOPY NUMBER ,
121:
122: PROCEDURE Member_Insert_Row (
123: p_api_version IN NUMBER ,
124: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
125: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
127: p_return_status OUT NOCOPY VARCHAR2 ,
128: p_msg_count OUT NOCOPY NUMBER ,
129: p_msg_data OUT NOCOPY VARCHAR2 ,
122: PROCEDURE Member_Insert_Row (
123: p_api_version IN NUMBER ,
124: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
125: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
126: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
127: p_return_status OUT NOCOPY VARCHAR2 ,
128: p_msg_count OUT NOCOPY NUMBER ,
129: p_msg_data OUT NOCOPY VARCHAR2 ,
130: --
146:
147:
148: PROCEDURE Member_Update_Row (
149: p_api_version IN NUMBER ,
150: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
151: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
152: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
153: p_return_status OUT NOCOPY VARCHAR2 ,
154: p_msg_count OUT NOCOPY NUMBER ,
147:
148: PROCEDURE Member_Update_Row (
149: p_api_version IN NUMBER ,
150: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
151: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
152: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
153: p_return_status OUT NOCOPY VARCHAR2 ,
154: p_msg_count OUT NOCOPY NUMBER ,
155: p_msg_data OUT NOCOPY VARCHAR2 ,
148: PROCEDURE Member_Update_Row (
149: p_api_version IN NUMBER ,
150: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
151: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
152: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
153: p_return_status OUT NOCOPY VARCHAR2 ,
154: p_msg_count OUT NOCOPY NUMBER ,
155: p_msg_data OUT NOCOPY VARCHAR2 ,
156: --
172: --Added param p_value_set_id.
173:
174: PROCEDURE Member_Delete_Row (
175: p_api_version IN NUMBER ,
176: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
177: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
179: p_return_status OUT NOCOPY VARCHAR2 ,
180: p_msg_count OUT NOCOPY NUMBER ,
173:
174: PROCEDURE Member_Delete_Row (
175: p_api_version IN NUMBER ,
176: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
177: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
179: p_return_status OUT NOCOPY VARCHAR2 ,
180: p_msg_count OUT NOCOPY NUMBER ,
181: p_msg_data OUT NOCOPY VARCHAR2 ,
174: PROCEDURE Member_Delete_Row (
175: p_api_version IN NUMBER ,
176: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
177: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
178: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
179: p_return_status OUT NOCOPY VARCHAR2 ,
180: p_msg_count OUT NOCOPY NUMBER ,
181: p_msg_data OUT NOCOPY VARCHAR2 ,
182: --
201:
202:
203: PROCEDURE Attribute_Insert_Row (
204: p_api_version IN NUMBER ,
205: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
206: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
207: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
208: p_return_status OUT NOCOPY VARCHAR2 ,
209: p_msg_count OUT NOCOPY NUMBER ,
202:
203: PROCEDURE Attribute_Insert_Row (
204: p_api_version IN NUMBER ,
205: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
206: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
207: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
208: p_return_status OUT NOCOPY VARCHAR2 ,
209: p_msg_count OUT NOCOPY NUMBER ,
210: p_msg_data OUT NOCOPY VARCHAR2 ,
203: PROCEDURE Attribute_Insert_Row (
204: p_api_version IN NUMBER ,
205: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
206: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
207: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
208: p_return_status OUT NOCOPY VARCHAR2 ,
209: p_msg_count OUT NOCOPY NUMBER ,
210: p_msg_data OUT NOCOPY VARCHAR2 ,
211: --
228:
229:
230: PROCEDURE Attribute_Update_Row (
231: p_api_version IN NUMBER ,
232: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
233: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
234: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
235: p_return_status OUT NOCOPY VARCHAR2 ,
236: p_msg_count OUT NOCOPY NUMBER ,
229:
230: PROCEDURE Attribute_Update_Row (
231: p_api_version IN NUMBER ,
232: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
233: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
234: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
235: p_return_status OUT NOCOPY VARCHAR2 ,
236: p_msg_count OUT NOCOPY NUMBER ,
237: p_msg_data OUT NOCOPY VARCHAR2 ,
230: PROCEDURE Attribute_Update_Row (
231: p_api_version IN NUMBER ,
232: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
233: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
234: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
235: p_return_status OUT NOCOPY VARCHAR2 ,
236: p_msg_count OUT NOCOPY NUMBER ,
237: p_msg_data OUT NOCOPY VARCHAR2 ,
238: --
253: );
254:
255: PROCEDURE Attribute_Delete_Row (
256: p_api_version IN NUMBER ,
257: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
258: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
259: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
260: p_return_status OUT NOCOPY VARCHAR2 ,
261: p_msg_count OUT NOCOPY NUMBER ,
254:
255: PROCEDURE Attribute_Delete_Row (
256: p_api_version IN NUMBER ,
257: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
258: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
259: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
260: p_return_status OUT NOCOPY VARCHAR2 ,
261: p_msg_count OUT NOCOPY NUMBER ,
262: p_msg_data OUT NOCOPY VARCHAR2 ,
255: PROCEDURE Attribute_Delete_Row (
256: p_api_version IN NUMBER ,
257: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
258: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
259: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
260: p_return_status OUT NOCOPY VARCHAR2 ,
261: p_msg_count OUT NOCOPY NUMBER ,
262: p_msg_data OUT NOCOPY VARCHAR2 ,
263: --
286:
287: PROCEDURE Check_Unique_Member
288: (
289: p_api_version IN NUMBER,
290: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
291: p_commit IN VARCHAR2 := FND_API.G_FALSE,
292: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
293: p_return_status OUT NOCOPY VARCHAR2,
294: p_msg_count OUT NOCOPY NUMBER,
287: PROCEDURE Check_Unique_Member
288: (
289: p_api_version IN NUMBER,
290: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
291: p_commit IN VARCHAR2 := FND_API.G_FALSE,
292: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
293: p_return_status OUT NOCOPY VARCHAR2,
294: p_msg_count OUT NOCOPY NUMBER,
295: p_msg_data OUT NOCOPY VARCHAR2,
288: (
289: p_api_version IN NUMBER,
290: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
291: p_commit IN VARCHAR2 := FND_API.G_FALSE,
292: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
293: p_return_status OUT NOCOPY VARCHAR2,
294: p_msg_count OUT NOCOPY NUMBER,
295: p_msg_data OUT NOCOPY VARCHAR2,
296: --
308: --Bug#4002913: Added the parameter p_calendar_id
309: --Bug#4096945: Added the parameters p_current_period_flag,p_cal_period_id
310: PROCEDURE Validate_Cal_Period_Member (
311: p_api_version IN NUMBER,
312: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
313: x_return_status OUT NOCOPY VARCHAR2,
314: x_msg_count OUT NOCOPY NUMBER,
315: x_msg_data OUT NOCOPY VARCHAR2,
316: --