74: -- given the content type record.
75: -- Parameters :
76: -- IN p_api_version NUMBER Required
77: -- p_init_msg_list VARCHAR2 Optional
78: -- Default = FND_API.G_FALSE
79: -- p_commit VARCHAR2 Optional
80: -- Default = FND_API.G_FALSE
81: -- p_validation_level NUMBER Optional
82: -- Default = FND_API.G_VALID_LEVEL_FULL
76: -- IN p_api_version NUMBER Required
77: -- p_init_msg_list VARCHAR2 Optional
78: -- Default = FND_API.G_FALSE
79: -- p_commit VARCHAR2 Optional
80: -- Default = FND_API.G_FALSE
81: -- p_validation_level NUMBER Optional
82: -- Default = FND_API.G_VALID_LEVEL_FULL
83: -- p_check_login_user VARCHAR2 Optional
84: -- Default = FND_API.G_TRUE
78: -- Default = FND_API.G_FALSE
79: -- p_commit VARCHAR2 Optional
80: -- Default = FND_API.G_FALSE
81: -- p_validation_level NUMBER Optional
82: -- Default = FND_API.G_VALID_LEVEL_FULL
83: -- p_check_login_user VARCHAR2 Optional
84: -- Default = FND_API.G_TRUE
85: -- Flag for checking user privilege and if user is login.
86: -- p_content_type_name VARCHAR2 Required
80: -- Default = FND_API.G_FALSE
81: -- p_validation_level NUMBER Optional
82: -- Default = FND_API.G_VALID_LEVEL_FULL
83: -- p_check_login_user VARCHAR2 Optional
84: -- Default = FND_API.G_TRUE
85: -- Flag for checking user privilege and if user is login.
86: -- p_content_type_name VARCHAR2 Required
87: -- content type name are required to be unique.
88: -- p_cnt_type_description VARCHAR2 Optional
85: -- Flag for checking user privilege and if user is login.
86: -- p_content_type_name VARCHAR2 Required
87: -- content type name are required to be unique.
88: -- p_cnt_type_description VARCHAR2 Optional
89: -- Default = FND_API.G_MISS_CHAR
90: -- OUT : x_return_status VARCHAR2
91: -- x_msg_count NUMBER
92: -- x_msg_data VARCHAR2
93: -- x_content_type_id NUMBER
98: --
99: PROCEDURE Add_ContentType
100: (
101: p_api_version IN NUMBER,
102: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103: p_commit IN VARCHAR2 := FND_API.G_FALSE,
104: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_msg_count OUT NOCOPY NUMBER,
99: PROCEDURE Add_ContentType
100: (
101: p_api_version IN NUMBER,
102: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103: p_commit IN VARCHAR2 := FND_API.G_FALSE,
104: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_msg_count OUT NOCOPY NUMBER,
107: x_msg_data OUT NOCOPY VARCHAR2,
100: (
101: p_api_version IN NUMBER,
102: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
103: p_commit IN VARCHAR2 := FND_API.G_FALSE,
104: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_msg_count OUT NOCOPY NUMBER,
107: x_msg_data OUT NOCOPY VARCHAR2,
108: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
104: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_msg_count OUT NOCOPY NUMBER,
107: x_msg_data OUT NOCOPY VARCHAR2,
108: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
109: p_content_type_name IN VARCHAR2,
110: p_cnt_type_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: x_content_type_id OUT NOCOPY NUMBER
112: );
106: x_msg_count OUT NOCOPY NUMBER,
107: x_msg_data OUT NOCOPY VARCHAR2,
108: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
109: p_content_type_name IN VARCHAR2,
110: p_cnt_type_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
111: x_content_type_id OUT NOCOPY NUMBER
112: );
113: --
114: -- Algorithm:
140: -- Function : Delete the content type specified by its id or name
141: -- Parameters :
142: -- IN p_api_version NUMBER Required
143: -- p_init_msg_list VARCHAR2 Optional
144: -- Default = FND_API.G_FALSE
145: -- p_commit VARCHAR2 Optional
146: -- Default = FND_API.G_FALSE
147: -- p_validation_level NUMBER Optional
148: -- Default = FND_API.G_VALID_LEVEL_FULL
142: -- IN p_api_version NUMBER Required
143: -- p_init_msg_list VARCHAR2 Optional
144: -- Default = FND_API.G_FALSE
145: -- p_commit VARCHAR2 Optional
146: -- Default = FND_API.G_FALSE
147: -- p_validation_level NUMBER Optional
148: -- Default = FND_API.G_VALID_LEVEL_FULL
149: -- p_check_login_user VARCHAR2 Optional
150: -- Default = FND_API.G_TRUE
144: -- Default = FND_API.G_FALSE
145: -- p_commit VARCHAR2 Optional
146: -- Default = FND_API.G_FALSE
147: -- p_validation_level NUMBER Optional
148: -- Default = FND_API.G_VALID_LEVEL_FULL
149: -- p_check_login_user VARCHAR2 Optional
150: -- Default = FND_API.G_TRUE
151: -- Flag for checking user privilege and if user is login.
152: -- p_content_type_id NUMBER Optional
146: -- Default = FND_API.G_FALSE
147: -- p_validation_level NUMBER Optional
148: -- Default = FND_API.G_VALID_LEVEL_FULL
149: -- p_check_login_user VARCHAR2 Optional
150: -- Default = FND_API.G_TRUE
151: -- Flag for checking user privilege and if user is login.
152: -- p_content_type_id NUMBER Optional
153: -- Default = FND_API.G_MISS_NUM
154: -- p_content_type_name VARCHAR2 Optional
149: -- p_check_login_user VARCHAR2 Optional
150: -- Default = FND_API.G_TRUE
151: -- Flag for checking user privilege and if user is login.
152: -- p_content_type_id NUMBER Optional
153: -- Default = FND_API.G_MISS_NUM
154: -- p_content_type_name VARCHAR2 Optional
155: -- Default = FND_API.G_MISS_CHAR
156: -- Either pass the content type id (preferred) or
157: -- content type name to identify the content type.
151: -- Flag for checking user privilege and if user is login.
152: -- p_content_type_id NUMBER Optional
153: -- Default = FND_API.G_MISS_NUM
154: -- p_content_type_name VARCHAR2 Optional
155: -- Default = FND_API.G_MISS_CHAR
156: -- Either pass the content type id (preferred) or
157: -- content type name to identify the content type.
158: -- OUT : x_return_status VARCHAR2
159: -- x_msg_count NUMBER
164: --
165: PROCEDURE Delete_ContentType
166: (
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
169: p_commit IN VARCHAR2 := FND_API.G_FALSE,
170: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
171: x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,
165: PROCEDURE Delete_ContentType
166: (
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
169: p_commit IN VARCHAR2 := FND_API.G_FALSE,
170: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
171: x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,
173: x_msg_data OUT NOCOPY VARCHAR2,
166: (
167: p_api_version IN NUMBER,
168: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
169: p_commit IN VARCHAR2 := FND_API.G_FALSE,
170: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
171: x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,
173: x_msg_data OUT NOCOPY VARCHAR2,
174: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
170: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
171: x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,
173: x_msg_data OUT NOCOPY VARCHAR2,
174: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
175: p_content_type_id IN NUMBER := FND_API.G_MISS_NUM,
176: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR
177: );
178: --
171: x_return_status OUT NOCOPY VARCHAR2,
172: x_msg_count OUT NOCOPY NUMBER,
173: x_msg_data OUT NOCOPY VARCHAR2,
174: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
175: p_content_type_id IN NUMBER := FND_API.G_MISS_NUM,
176: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR
177: );
178: --
179: -- Algorithm:
172: x_msg_count OUT NOCOPY NUMBER,
173: x_msg_data OUT NOCOPY VARCHAR2,
174: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
175: p_content_type_id IN NUMBER := FND_API.G_MISS_NUM,
176: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR
177: );
178: --
179: -- Algorithm:
180: -- BEGIN
210: -- Function : Change the content type name
211: -- Parameters :
212: -- IN p_api_version NUMBER Required
213: -- p_init_msg_list VARCHAR2 Optional
214: -- Default = FND_API.G_FALSE
215: -- p_commit VARCHAR2 Optional
216: -- Default = FND_API.G_FALSE
217: -- p_validation_level NUMBER Optional
218: -- Default = FND_API.G_VALID_LEVEL_FULL
212: -- IN p_api_version NUMBER Required
213: -- p_init_msg_list VARCHAR2 Optional
214: -- Default = FND_API.G_FALSE
215: -- p_commit VARCHAR2 Optional
216: -- Default = FND_API.G_FALSE
217: -- p_validation_level NUMBER Optional
218: -- Default = FND_API.G_VALID_LEVEL_FULL
219: -- p_check_login_user VARCHAR2 Optional
220: -- Default = FND_API.G_TRUE
214: -- Default = FND_API.G_FALSE
215: -- p_commit VARCHAR2 Optional
216: -- Default = FND_API.G_FALSE
217: -- p_validation_level NUMBER Optional
218: -- Default = FND_API.G_VALID_LEVEL_FULL
219: -- p_check_login_user VARCHAR2 Optional
220: -- Default = FND_API.G_TRUE
221: -- Flag for checking user privilege and if user is login.
222: -- p_content_type_id NUMBER Optional
216: -- Default = FND_API.G_FALSE
217: -- p_validation_level NUMBER Optional
218: -- Default = FND_API.G_VALID_LEVEL_FULL
219: -- p_check_login_user VARCHAR2 Optional
220: -- Default = FND_API.G_TRUE
221: -- Flag for checking user privilege and if user is login.
222: -- p_content_type_id NUMBER Optional
223: -- Default = FND_API.G_MISS_NUM
224: -- p_content_type_name VARCHAR2 Optional
219: -- p_check_login_user VARCHAR2 Optional
220: -- Default = FND_API.G_TRUE
221: -- Flag for checking user privilege and if user is login.
222: -- p_content_type_id NUMBER Optional
223: -- Default = FND_API.G_MISS_NUM
224: -- p_content_type_name VARCHAR2 Optional
225: -- Default = FND_API.G_MISS_CHAR
226: -- Either pass the content type id (preferred) or
227: -- content type name to identify the content type.
221: -- Flag for checking user privilege and if user is login.
222: -- p_content_type_id NUMBER Optional
223: -- Default = FND_API.G_MISS_NUM
224: -- p_content_type_name VARCHAR2 Optional
225: -- Default = FND_API.G_MISS_CHAR
226: -- Either pass the content type id (preferred) or
227: -- content type name to identify the content type.
228: -- p_content_type_new_name VARCHAR2 Optional
229: -- Default = FND_API.G_MISS_CHAR
225: -- Default = FND_API.G_MISS_CHAR
226: -- Either pass the content type id (preferred) or
227: -- content type name to identify the content type.
228: -- p_content_type_new_name VARCHAR2 Optional
229: -- Default = FND_API.G_MISS_CHAR
230: -- p_cnt_type_description VARCHAR2 Optional
231: -- Default = FND_API.G_MISS_CHAR
232: -- OUT : x_return_status VARCHAR2
233: -- x_msg_count NUMBER
227: -- content type name to identify the content type.
228: -- p_content_type_new_name VARCHAR2 Optional
229: -- Default = FND_API.G_MISS_CHAR
230: -- p_cnt_type_description VARCHAR2 Optional
231: -- Default = FND_API.G_MISS_CHAR
232: -- OUT : x_return_status VARCHAR2
233: -- x_msg_count NUMBER
234: -- x_msg_data VARCHAR2
235: -- Notes :
238: --
239: PROCEDURE Update_ContentType
240: (
241: p_api_version IN NUMBER,
242: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
243: p_commit IN VARCHAR2 := FND_API.G_FALSE,
244: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
245: x_return_status OUT NOCOPY VARCHAR2,
246: x_msg_count OUT NOCOPY NUMBER,
239: PROCEDURE Update_ContentType
240: (
241: p_api_version IN NUMBER,
242: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
243: p_commit IN VARCHAR2 := FND_API.G_FALSE,
244: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
245: x_return_status OUT NOCOPY VARCHAR2,
246: x_msg_count OUT NOCOPY NUMBER,
247: x_msg_data OUT NOCOPY VARCHAR2,
240: (
241: p_api_version IN NUMBER,
242: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
243: p_commit IN VARCHAR2 := FND_API.G_FALSE,
244: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
245: x_return_status OUT NOCOPY VARCHAR2,
246: x_msg_count OUT NOCOPY NUMBER,
247: x_msg_data OUT NOCOPY VARCHAR2,
248: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
244: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
245: x_return_status OUT NOCOPY VARCHAR2,
246: x_msg_count OUT NOCOPY NUMBER,
247: x_msg_data OUT NOCOPY VARCHAR2,
248: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
249: p_content_type_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_content_type_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_cnt_type_description IN VARCHAR2 := FND_API.G_MISS_CHAR
245: x_return_status OUT NOCOPY VARCHAR2,
246: x_msg_count OUT NOCOPY NUMBER,
247: x_msg_data OUT NOCOPY VARCHAR2,
248: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
249: p_content_type_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_content_type_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_cnt_type_description IN VARCHAR2 := FND_API.G_MISS_CHAR
253: );
246: x_msg_count OUT NOCOPY NUMBER,
247: x_msg_data OUT NOCOPY VARCHAR2,
248: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
249: p_content_type_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_content_type_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_cnt_type_description IN VARCHAR2 := FND_API.G_MISS_CHAR
253: );
254: --
247: x_msg_data OUT NOCOPY VARCHAR2,
248: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
249: p_content_type_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_content_type_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_cnt_type_description IN VARCHAR2 := FND_API.G_MISS_CHAR
253: );
254: --
255: --
248: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
249: p_content_type_id IN NUMBER := FND_API.G_MISS_NUM,
250: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_content_type_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
252: p_cnt_type_description IN VARCHAR2 := FND_API.G_MISS_CHAR
253: );
254: --
255: --
256: -- Algorithm:
286: -- Function : Get content type record based on its id (preferred) or name.
287: -- Parameters :
288: -- IN p_api_version NUMBER Required
289: -- p_init_msg_list VARCHAR2 Optional
290: -- Default = FND_API.G_FALSE
291: -- p_validation_level NUMBER Optional
292: -- Default = FND_API.G_VALID_LEVEL_FULL
293: -- p_check_login_user VARCHAR2 Optional
294: -- Default = FND_API.G_TRUE
288: -- IN p_api_version NUMBER Required
289: -- p_init_msg_list VARCHAR2 Optional
290: -- Default = FND_API.G_FALSE
291: -- p_validation_level NUMBER Optional
292: -- Default = FND_API.G_VALID_LEVEL_FULL
293: -- p_check_login_user VARCHAR2 Optional
294: -- Default = FND_API.G_TRUE
295: -- Flag for checking user privilege and if user is login.
296: -- p_content_type_id NUMBER Optional
290: -- Default = FND_API.G_FALSE
291: -- p_validation_level NUMBER Optional
292: -- Default = FND_API.G_VALID_LEVEL_FULL
293: -- p_check_login_user VARCHAR2 Optional
294: -- Default = FND_API.G_TRUE
295: -- Flag for checking user privilege and if user is login.
296: -- p_content_type_id NUMBER Optional
297: -- Default = FND_API.G_MISS_NUM
298: -- p_content_type_name VARCHAR2 Optional
293: -- p_check_login_user VARCHAR2 Optional
294: -- Default = FND_API.G_TRUE
295: -- Flag for checking user privilege and if user is login.
296: -- p_content_type_id NUMBER Optional
297: -- Default = FND_API.G_MISS_NUM
298: -- p_content_type_name VARCHAR2 Optional
299: -- Default = FND_API.G_MISS_CHAR
300: -- Either pass the content type id (preferred) or
301: -- content type name to identify the content type record.
295: -- Flag for checking user privilege and if user is login.
296: -- p_content_type_id NUMBER Optional
297: -- Default = FND_API.G_MISS_NUM
298: -- p_content_type_name VARCHAR2 Optional
299: -- Default = FND_API.G_MISS_CHAR
300: -- Either pass the content type id (preferred) or
301: -- content type name to identify the content type record.
302: -- OUT : x_return_status VARCHAR2
303: -- x_msg_count NUMBER
310: --
311: PROCEDURE Get_ContentType
312: (
313: p_api_version IN NUMBER,
314: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
315: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
316: x_return_status OUT NOCOPY VARCHAR2,
317: x_msg_count OUT NOCOPY NUMBER,
318: x_msg_data OUT NOCOPY VARCHAR2,
311: PROCEDURE Get_ContentType
312: (
313: p_api_version IN NUMBER,
314: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
315: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
316: x_return_status OUT NOCOPY VARCHAR2,
317: x_msg_count OUT NOCOPY NUMBER,
318: x_msg_data OUT NOCOPY VARCHAR2,
319: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
315: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
316: x_return_status OUT NOCOPY VARCHAR2,
317: x_msg_count OUT NOCOPY NUMBER,
318: x_msg_data OUT NOCOPY VARCHAR2,
319: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
320: p_content_type_id IN NUMBER := FND_API.G_MISS_NUM,
321: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
322: x_content_type_obj OUT NOCOPY AMV_CONTENT_TYPE_OBJ_TYPE
323: );
316: x_return_status OUT NOCOPY VARCHAR2,
317: x_msg_count OUT NOCOPY NUMBER,
318: x_msg_data OUT NOCOPY VARCHAR2,
319: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
320: p_content_type_id IN NUMBER := FND_API.G_MISS_NUM,
321: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
322: x_content_type_obj OUT NOCOPY AMV_CONTENT_TYPE_OBJ_TYPE
323: );
324: -- Algorithm:
317: x_msg_count OUT NOCOPY NUMBER,
318: x_msg_data OUT NOCOPY VARCHAR2,
319: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
320: p_content_type_id IN NUMBER := FND_API.G_MISS_NUM,
321: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
322: x_content_type_obj OUT NOCOPY AMV_CONTENT_TYPE_OBJ_TYPE
323: );
324: -- Algorithm:
325: -- BEGIN
345: -- Function : Find content type records based on its name or description.
346: -- Parameters :
347: -- IN p_api_version NUMBER Required
348: -- p_init_msg_list VARCHAR2 Optional
349: -- Default = FND_API.G_FALSE
350: -- p_validation_level NUMBER Optional
351: -- Default = FND_API.G_VALID_LEVEL_FULL
352: -- p_check_login_user VARCHAR2 Optional
353: -- Default = FND_API.G_TRUE
347: -- IN p_api_version NUMBER Required
348: -- p_init_msg_list VARCHAR2 Optional
349: -- Default = FND_API.G_FALSE
350: -- p_validation_level NUMBER Optional
351: -- Default = FND_API.G_VALID_LEVEL_FULL
352: -- p_check_login_user VARCHAR2 Optional
353: -- Default = FND_API.G_TRUE
354: -- Flag for checking user privilege and if user is login.
355: -- p_content_type_name VARCHAR2 Optional
349: -- Default = FND_API.G_FALSE
350: -- p_validation_level NUMBER Optional
351: -- Default = FND_API.G_VALID_LEVEL_FULL
352: -- p_check_login_user VARCHAR2 Optional
353: -- Default = FND_API.G_TRUE
354: -- Flag for checking user privilege and if user is login.
355: -- p_content_type_name VARCHAR2 Optional
356: -- The search criteria on name
357: -- Default = FND_API.G_MISS_CHAR
353: -- Default = FND_API.G_TRUE
354: -- Flag for checking user privilege and if user is login.
355: -- p_content_type_name VARCHAR2 Optional
356: -- The search criteria on name
357: -- Default = FND_API.G_MISS_CHAR
358: -- p_cnt_type_description VARCHAR2 Optional
359: -- The search criteria on description
360: -- Default = FND_API.G_MISS_CHAR
361: -- p_subset_request_obj AMV_REQUEST_OBJ_TYPE,
356: -- The search criteria on name
357: -- Default = FND_API.G_MISS_CHAR
358: -- p_cnt_type_description VARCHAR2 Optional
359: -- The search criteria on description
360: -- Default = FND_API.G_MISS_CHAR
361: -- p_subset_request_obj AMV_REQUEST_OBJ_TYPE,
362: -- Required.
363: -- OUT : x_return_status VARCHAR2
364: -- x_msg_count NUMBER
372: --
373: PROCEDURE Find_ContentType
374: (
375: p_api_version IN NUMBER,
376: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
377: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
378: x_return_status OUT NOCOPY VARCHAR2,
379: x_msg_count OUT NOCOPY NUMBER,
380: x_msg_data OUT NOCOPY VARCHAR2,
373: PROCEDURE Find_ContentType
374: (
375: p_api_version IN NUMBER,
376: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
377: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
378: x_return_status OUT NOCOPY VARCHAR2,
379: x_msg_count OUT NOCOPY NUMBER,
380: x_msg_data OUT NOCOPY VARCHAR2,
381: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
377: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
378: x_return_status OUT NOCOPY VARCHAR2,
379: x_msg_count OUT NOCOPY NUMBER,
380: x_msg_data OUT NOCOPY VARCHAR2,
381: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
382: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
383: p_cnt_type_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
384: p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,
385: x_subset_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
378: x_return_status OUT NOCOPY VARCHAR2,
379: x_msg_count OUT NOCOPY NUMBER,
380: x_msg_data OUT NOCOPY VARCHAR2,
381: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
382: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
383: p_cnt_type_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
384: p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,
385: x_subset_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
386: x_content_type_obj_varray OUT NOCOPY AMV_CONTENT_TYPE_OBJ_VARRAY
379: x_msg_count OUT NOCOPY NUMBER,
380: x_msg_data OUT NOCOPY VARCHAR2,
381: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
382: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
383: p_cnt_type_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
384: p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,
385: x_subset_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
386: x_content_type_obj_varray OUT NOCOPY AMV_CONTENT_TYPE_OBJ_VARRAY
387: );