68: );
69:
70: PROCEDURE Create_Act_Resource
71: ( p_api_version IN NUMBER,
72: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
73: p_commit IN VARCHAR2 := FND_API.G_FALSE,
74: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75: x_return_status OUT NOCOPY VARCHAR2,
76: x_msg_count OUT NOCOPY NUMBER,
69:
70: PROCEDURE Create_Act_Resource
71: ( p_api_version IN NUMBER,
72: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
73: p_commit IN VARCHAR2 := FND_API.G_FALSE,
74: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75: x_return_status OUT NOCOPY VARCHAR2,
76: x_msg_count OUT NOCOPY NUMBER,
77: x_msg_data OUT NOCOPY VARCHAR2,
70: PROCEDURE Create_Act_Resource
71: ( p_api_version IN NUMBER,
72: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
73: p_commit IN VARCHAR2 := FND_API.G_FALSE,
74: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75: x_return_status OUT NOCOPY VARCHAR2,
76: x_msg_count OUT NOCOPY NUMBER,
77: x_msg_data OUT NOCOPY VARCHAR2,
78:
91: -- IN :
92: -- standard IN parameters
93: -- p_api_version IN NUMBER := NULL Required
94: -- p_init_msg_list IN VARCHAR2 Optional
95: -- p_commit IN VARCHAR2 := FND_API.G_FALSE Optional
96: -- p_validation_level IN NUMBER
97: -- := FND_API.G_VALID_LEVEL_FULL,
98: -- API's IN parameters
99: --
93: -- p_api_version IN NUMBER := NULL Required
94: -- p_init_msg_list IN VARCHAR2 Optional
95: -- p_commit IN VARCHAR2 := FND_API.G_FALSE Optional
96: -- p_validation_level IN NUMBER
97: -- := FND_API.G_VALID_LEVEL_FULL,
98: -- API's IN parameters
99: --
100: -- p_Act_Resource_rec IN Act_Resource_rec_type
101: --
112: /****************************************************************************/
113:
114: PROCEDURE Update_Act_Resource
115: ( p_api_version IN NUMBER,
116: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
117: p_commit IN VARCHAR2 := FND_API.G_FALSE,
118: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
119: x_return_status OUT NOCOPY VARCHAR2,
120: x_msg_count OUT NOCOPY NUMBER,
113:
114: PROCEDURE Update_Act_Resource
115: ( p_api_version IN NUMBER,
116: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
117: p_commit IN VARCHAR2 := FND_API.G_FALSE,
118: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
119: x_return_status OUT NOCOPY VARCHAR2,
120: x_msg_count OUT NOCOPY NUMBER,
121: x_msg_data OUT NOCOPY VARCHAR2,
114: PROCEDURE Update_Act_Resource
115: ( p_api_version IN NUMBER,
116: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
117: p_commit IN VARCHAR2 := FND_API.G_FALSE,
118: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
119: x_return_status OUT NOCOPY VARCHAR2,
120: x_msg_count OUT NOCOPY NUMBER,
121: x_msg_data OUT NOCOPY VARCHAR2,
122:
134: -- IN :
135: -- standard IN parameters
136: -- p_api_version IN NUMBER := NULL Required
137: -- p_init_msg_list IN VARCHAR2 Optional
138: -- Default := FND_API.G_FALSE
139: -- p_commit IN VARCHAR2 := FND_API.G_FALSE Optional
140: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141: -- API's IN parameters
142: -- p_Act_Resource_rec IN Act_Resource_rec_type Required
135: -- standard IN parameters
136: -- p_api_version IN NUMBER := NULL Required
137: -- p_init_msg_list IN VARCHAR2 Optional
138: -- Default := FND_API.G_FALSE
139: -- p_commit IN VARCHAR2 := FND_API.G_FALSE Optional
140: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141: -- API's IN parameters
142: -- p_Act_Resource_rec IN Act_Resource_rec_type Required
143: --
136: -- p_api_version IN NUMBER := NULL Required
137: -- p_init_msg_list IN VARCHAR2 Optional
138: -- Default := FND_API.G_FALSE
139: -- p_commit IN VARCHAR2 := FND_API.G_FALSE Optional
140: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141: -- API's IN parameters
142: -- p_Act_Resource_rec IN Act_Resource_rec_type Required
143: --
144: -- standard OUT parameters
152: /*****************************************************************************************/
153:
154: PROCEDURE Delete_Act_Resource
155: ( p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
157: p_commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
153:
154: PROCEDURE Delete_Act_Resource
155: ( p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
157: p_commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2,
154: PROCEDURE Delete_Act_Resource
155: ( p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
157: p_commit IN VARCHAR2 := FND_API.G_FALSE,
158: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2,
162:
176: -- IN :
177: -- standard IN parameters
178: -- p_api_version IN NUMBER := NULL Required
179: -- p_init_msg_list IN VARCHAR2 Optional
180: -- Default := FND_API.G_FALSE
181: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
182: -- API's IN parameters
183: -- p_Resource_rec IN Act_Resource_rec_type Required
184: -- OUT :
177: -- standard IN parameters
178: -- p_api_version IN NUMBER := NULL Required
179: -- p_init_msg_list IN VARCHAR2 Optional
180: -- Default := FND_API.G_FALSE
181: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
182: -- API's IN parameters
183: -- p_Resource_rec IN Act_Resource_rec_type Required
184: -- OUT :
185: -- standard OUT parameters
192: /*****************************************************************************************/
193:
194: PROCEDURE Lock_Act_Resource
195: ( p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,
200: x_msg_data OUT NOCOPY VARCHAR2,
193:
194: PROCEDURE Lock_Act_Resource
195: ( p_api_version IN NUMBER,
196: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,
200: x_msg_data OUT NOCOPY VARCHAR2,
201:
214: -- IN :
215: -- standard IN parameters
216: -- p_api_version IN NUMBER := NULL Required
217: -- p_init_msg_list IN VARCHAR2 Optional
218: -- Default := FND_API.G_FALSE
219: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
220: -- API's IN parameters
221: --
222: -- p_Resource_rec IN Act_Resource_rec_type Required
215: -- standard IN parameters
216: -- p_api_version IN NUMBER := NULL Required
217: -- p_init_msg_list IN VARCHAR2 Optional
218: -- Default := FND_API.G_FALSE
219: -- p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
220: -- API's IN parameters
221: --
222: -- p_Resource_rec IN Act_Resource_rec_type Required
223: --
227: -- x_msg_data OUT VARCHAR2(2000)
228: --
229: --
230: -- Note : 1. p_Resource_rec.activity_product_id is a required parameter
231: -- 2. x_return_status will be FND_API.G_RET_STS_SUCCESS,
232: -- FND_API.G_RET_STS_ERROR, or
233: -- FND_API.G_RET_STS_UNEXP_ERROR
234: --
235: /*****************************************************************************************/
228: --
229: --
230: -- Note : 1. p_Resource_rec.activity_product_id is a required parameter
231: -- 2. x_return_status will be FND_API.G_RET_STS_SUCCESS,
232: -- FND_API.G_RET_STS_ERROR, or
233: -- FND_API.G_RET_STS_UNEXP_ERROR
234: --
235: /*****************************************************************************************/
236:
229: --
230: -- Note : 1. p_Resource_rec.activity_product_id is a required parameter
231: -- 2. x_return_status will be FND_API.G_RET_STS_SUCCESS,
232: -- FND_API.G_RET_STS_ERROR, or
233: -- FND_API.G_RET_STS_UNEXP_ERROR
234: --
235: /*****************************************************************************************/
236:
237: PROCEDURE Validate_Act_Resource
235: /*****************************************************************************************/
236:
237: PROCEDURE Validate_Act_Resource
238: ( p_api_version IN NUMBER,
239: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241: x_return_status OUT NOCOPY VARCHAR2,
242: x_msg_count OUT NOCOPY NUMBER,
243: x_msg_data OUT NOCOPY VARCHAR2,
236:
237: PROCEDURE Validate_Act_Resource
238: ( p_api_version IN NUMBER,
239: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241: x_return_status OUT NOCOPY VARCHAR2,
242: x_msg_count OUT NOCOPY NUMBER,
243: x_msg_data OUT NOCOPY VARCHAR2,
244:
261: -- PROCEDURE
262: -- init_Act_Rsc_Record
263: --
264: -- PURPOSE
265: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
266: ---------------------------------------------------------------------
267: PROCEDURE init_Act_Rsc_Record(
268: x_Act_Resource_rec OUT NOCOPY Act_Resource_rec_type
269: );