DBA Data[Home] [Help]

APPS.AMV_CONTENT_TYPE_PVT dependencies on FND_API

Line 78: -- Default = FND_API.G_FALSE

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

Line 80: -- Default = FND_API.G_FALSE

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

Line 82: -- Default = FND_API.G_VALID_LEVEL_FULL

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

Line 84: -- Default = FND_API.G_TRUE

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

Line 89: -- Default = FND_API.G_MISS_CHAR

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

Line 102: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 103: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 104: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 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: );

Line 110: p_cnt_type_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

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:

Line 144: -- Default = FND_API.G_FALSE

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

Line 146: -- Default = FND_API.G_FALSE

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

Line 148: -- Default = FND_API.G_VALID_LEVEL_FULL

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

Line 150: -- Default = FND_API.G_TRUE

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

Line 153: -- Default = FND_API.G_MISS_NUM

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.

Line 155: -- Default = FND_API.G_MISS_CHAR

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

Line 168: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 169: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 170: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 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: --

Line 175: p_content_type_id IN NUMBER := FND_API.G_MISS_NUM,

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:

Line 176: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR

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

Line 214: -- Default = FND_API.G_FALSE

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

Line 216: -- Default = FND_API.G_FALSE

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

Line 218: -- Default = FND_API.G_VALID_LEVEL_FULL

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

Line 220: -- Default = FND_API.G_TRUE

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

Line 223: -- Default = FND_API.G_MISS_NUM

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.

Line 225: -- Default = FND_API.G_MISS_CHAR

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

Line 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

Line 231: -- Default = FND_API.G_MISS_CHAR

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 :

Line 242: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 243: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 244: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 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

Line 249: p_content_type_id IN NUMBER := FND_API.G_MISS_NUM,

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: );

Line 250: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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: --

Line 251: p_content_type_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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: --

Line 252: p_cnt_type_description IN VARCHAR2 := FND_API.G_MISS_CHAR

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:

Line 290: -- Default = FND_API.G_FALSE

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

Line 292: -- Default = FND_API.G_VALID_LEVEL_FULL

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

Line 294: -- Default = FND_API.G_TRUE

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

Line 297: -- Default = FND_API.G_MISS_NUM

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.

Line 299: -- Default = FND_API.G_MISS_CHAR

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

Line 314: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 315: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 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: );

Line 320: p_content_type_id IN NUMBER := FND_API.G_MISS_NUM,

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:

Line 321: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

Line 349: -- Default = FND_API.G_FALSE

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

Line 351: -- Default = FND_API.G_VALID_LEVEL_FULL

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

Line 353: -- Default = FND_API.G_TRUE

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

Line 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,

Line 360: -- Default = FND_API.G_MISS_CHAR

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

Line 376: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 377: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 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,

Line 382: p_content_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

Line 383: p_cnt_type_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

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: );