eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMV_CATEGORY_PVT dependencies on FND_API

Line 75: -- Default = FND_API.G_FALSE

71: -- Function : Create channel (sub)category.
72: -- Parameters :
73: -- IN p_api_version IN NUMBER Required
74: -- p_init_msg_list IN VARCHAR2 Optional
75: -- Default = FND_API.G_FALSE
76: -- p_commit IN VARCHAR2 Optional
77: -- Default = FND_API.G_FALSE
78: -- p_validation_level IN NUMBER Optional
79: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 77: -- Default = FND_API.G_FALSE

73: -- IN p_api_version IN NUMBER Required
74: -- p_init_msg_list IN VARCHAR2 Optional
75: -- Default = FND_API.G_FALSE
76: -- p_commit IN VARCHAR2 Optional
77: -- Default = FND_API.G_FALSE
78: -- p_validation_level IN NUMBER Optional
79: -- Default = FND_API.G_VALID_LEVEL_FULL
80: -- p_application_id IN NUMBER Optional
81: -- Default = AMV_UTILITY_PVT.G_AMV_APP_ID (520)

Line 79: -- Default = FND_API.G_VALID_LEVEL_FULL

75: -- Default = FND_API.G_FALSE
76: -- p_commit IN VARCHAR2 Optional
77: -- Default = FND_API.G_FALSE
78: -- p_validation_level IN NUMBER Optional
79: -- Default = FND_API.G_VALID_LEVEL_FULL
80: -- p_application_id IN NUMBER Optional
81: -- Default = AMV_UTILITY_PVT.G_AMV_APP_ID (520)
82: -- application creating the channel
83: -- p_category_name IN VARCHAR2 Required

Line 88: -- Default = FND_API.G_MISS_NUM

84: -- the channel category name. Have to be unique.
85: -- p_description IN VARCHAR2 Optional
86: -- the channel (sub)category description.
87: -- p_parent_category_id IN VARCHAR2 Optional
88: -- Default = FND_API.G_MISS_NUM
89: -- p_parent_category_name IN VARCHAR2 Optional
90: -- Default = FND_API.G_MISS_CHAR
91: -- parent id or name required for creating sub categories.
92: -- p_order IN NUMBER Optional

Line 90: -- Default = FND_API.G_MISS_CHAR

86: -- the channel (sub)category description.
87: -- p_parent_category_id IN VARCHAR2 Optional
88: -- Default = FND_API.G_MISS_NUM
89: -- p_parent_category_name IN VARCHAR2 Optional
90: -- Default = FND_API.G_MISS_CHAR
91: -- parent id or name required for creating sub categories.
92: -- p_order IN NUMBER Optional
93: -- Default = FND_API.G_MISS_NUM
94: -- the order of this catgory among all the categories

Line 93: -- Default = FND_API.G_MISS_NUM

89: -- p_parent_category_name IN VARCHAR2 Optional
90: -- Default = FND_API.G_MISS_CHAR
91: -- parent id or name required for creating sub categories.
92: -- p_order IN NUMBER Optional
93: -- Default = FND_API.G_MISS_NUM
94: -- the order of this catgory among all the categories
95: -- OUT : x_return_status OUT VARCHAR2
96: -- x_msg_count OUT NUMBER
97: -- x_msg_data OUT VARCHAR2

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

104: -- End of comments
105: --
106: PROCEDURE Add_Category
107: ( p_api_version IN NUMBER,
108: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
109: p_commit IN VARCHAR2 := FND_API.G_FALSE,
110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
111: x_return_status OUT NOCOPY VARCHAR2,
112: x_msg_count OUT NOCOPY NUMBER,

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

105: --
106: PROCEDURE Add_Category
107: ( p_api_version IN NUMBER,
108: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
109: p_commit IN VARCHAR2 := FND_API.G_FALSE,
110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
111: x_return_status OUT NOCOPY VARCHAR2,
112: x_msg_count OUT NOCOPY NUMBER,
113: x_msg_data OUT NOCOPY VARCHAR2,

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

106: PROCEDURE Add_Category
107: ( p_api_version IN NUMBER,
108: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
109: p_commit IN VARCHAR2 := FND_API.G_FALSE,
110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
111: x_return_status OUT NOCOPY VARCHAR2,
112: x_msg_count OUT NOCOPY NUMBER,
113: x_msg_data OUT NOCOPY VARCHAR2,
114: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 114: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

110: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
111: x_return_status OUT NOCOPY VARCHAR2,
112: x_msg_count OUT NOCOPY NUMBER,
113: x_msg_data OUT NOCOPY VARCHAR2,
114: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
115: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
116: p_category_name IN VARCHAR2,
117: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,

Line 117: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

113: x_msg_data OUT NOCOPY VARCHAR2,
114: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
115: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
116: p_category_name IN VARCHAR2,
117: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
119: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_order IN NUMBER := FND_API.G_MISS_NUM,
121: x_category_id OUT NOCOPY NUMBER

Line 118: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,

114: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
115: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
116: p_category_name IN VARCHAR2,
117: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
119: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_order IN NUMBER := FND_API.G_MISS_NUM,
121: x_category_id OUT NOCOPY NUMBER
122: );

Line 119: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

115: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
116: p_category_name IN VARCHAR2,
117: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
119: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_order IN NUMBER := FND_API.G_MISS_NUM,
121: x_category_id OUT NOCOPY NUMBER
122: );
123: --

Line 120: p_order IN NUMBER := FND_API.G_MISS_NUM,

116: p_category_name IN VARCHAR2,
117: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
118: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
119: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
120: p_order IN NUMBER := FND_API.G_MISS_NUM,
121: x_category_id OUT NOCOPY NUMBER
122: );
123: --
124: -- Algorithm:

Line 139: -- Default = FND_API.G_FALSE

135: -- p_category_id(preferred) or p_category_name.
136: -- Parameters :
137: -- IN p_api_version IN NUMBER Required
138: -- p_init_msg_list IN VARCHAR2 Optional
139: -- Default = FND_API.G_FALSE
140: -- p_commit IN VARCHAR2 Optional
141: -- Default = FND_API.G_FALSE
142: -- p_validation_level IN NUMBER Optional
143: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 141: -- Default = FND_API.G_FALSE

137: -- IN p_api_version IN NUMBER Required
138: -- p_init_msg_list IN VARCHAR2 Optional
139: -- Default = FND_API.G_FALSE
140: -- p_commit IN VARCHAR2 Optional
141: -- Default = FND_API.G_FALSE
142: -- p_validation_level IN NUMBER Optional
143: -- Default = FND_API.G_VALID_LEVEL_FULL
144: -- p_category_id IN NUMBER Optional
145: -- Default = FND_API.G_MISS_NUM

Line 143: -- Default = FND_API.G_VALID_LEVEL_FULL

139: -- Default = FND_API.G_FALSE
140: -- p_commit IN VARCHAR2 Optional
141: -- Default = FND_API.G_FALSE
142: -- p_validation_level IN NUMBER Optional
143: -- Default = FND_API.G_VALID_LEVEL_FULL
144: -- p_category_id IN NUMBER Optional
145: -- Default = FND_API.G_MISS_NUM
146: -- channel (sub)category id.
147: -- p_category_name IN VARCHAR2 Optional

Line 145: -- Default = FND_API.G_MISS_NUM

141: -- Default = FND_API.G_FALSE
142: -- p_validation_level IN NUMBER Optional
143: -- Default = FND_API.G_VALID_LEVEL_FULL
144: -- p_category_id IN NUMBER Optional
145: -- Default = FND_API.G_MISS_NUM
146: -- channel (sub)category id.
147: -- p_category_name IN VARCHAR2 Optional
148: -- Default = FND_API.G_MISS_CHAR
149: -- channel (sub)category name.

Line 148: -- Default = FND_API.G_MISS_CHAR

144: -- p_category_id IN NUMBER Optional
145: -- Default = FND_API.G_MISS_NUM
146: -- channel (sub)category id.
147: -- p_category_name IN VARCHAR2 Optional
148: -- Default = FND_API.G_MISS_CHAR
149: -- channel (sub)category name.
150: -- p_parent_category_id IN NUMBER Optional
151: -- Default = FND_API.G_MISS_NUM
152: -- p_parent_category_name IN VARCHAR2 Optional

Line 151: -- Default = FND_API.G_MISS_NUM

147: -- p_category_name IN VARCHAR2 Optional
148: -- Default = FND_API.G_MISS_CHAR
149: -- channel (sub)category name.
150: -- p_parent_category_id IN NUMBER Optional
151: -- Default = FND_API.G_MISS_NUM
152: -- p_parent_category_name IN VARCHAR2 Optional
153: -- Default = FND_API.G_MISS_CHAR
154: -- Either pass the channe (sub)category id (preferred)
155: -- or channel (sub)category name

Line 153: -- Default = FND_API.G_MISS_CHAR

149: -- channel (sub)category name.
150: -- p_parent_category_id IN NUMBER Optional
151: -- Default = FND_API.G_MISS_NUM
152: -- p_parent_category_name IN VARCHAR2 Optional
153: -- Default = FND_API.G_MISS_CHAR
154: -- Either pass the channe (sub)category id (preferred)
155: -- or channel (sub)category name
156: -- to identify the channel (sub)category.
157: -- OUT : x_return_status OUT VARCHAR2

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

165: -- End of comments
166: --
167: PROCEDURE Delete_Category
168: ( p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,

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

166: --
167: PROCEDURE Delete_Category
168: ( p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,

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

167: PROCEDURE Delete_Category
168: ( p_api_version IN NUMBER,
169: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
170: p_commit IN VARCHAR2 := FND_API.G_FALSE,
171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 175: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

171: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
176: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
177: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
178: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,

Line 177: p_category_id IN NUMBER := FND_API.G_MISS_NUM,

173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
176: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
177: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
178: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
180: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR
181: );

Line 178: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
176: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
177: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
178: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
180: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR
181: );
182: --

Line 179: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,

175: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
176: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
177: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
178: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
180: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR
181: );
182: --
183: -- Algorithm:

Line 180: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR

176: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
177: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
178: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
180: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR
181: );
182: --
183: -- Algorithm:
184: -- BEGIN

Line 197: -- Default = FND_API.G_FALSE

193: -- Function : sort (sub)category list in ascending or descending order
194: -- Parameters :
195: -- IN p_api_version IN NUMBER Required
196: -- p_init_msg_list IN VARCHAR2 Optional
197: -- Default = FND_API.G_FALSE
198: -- p_commit IN VARCHAR2 Optional
199: -- Default = FND_API.G_FALSE
200: -- p_validation_level IN NUMBER Optional
201: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 199: -- Default = FND_API.G_FALSE

195: -- IN p_api_version IN NUMBER Required
196: -- p_init_msg_list IN VARCHAR2 Optional
197: -- Default = FND_API.G_FALSE
198: -- p_commit IN VARCHAR2 Optional
199: -- Default = FND_API.G_FALSE
200: -- p_validation_level IN NUMBER Optional
201: -- Default = FND_API.G_VALID_LEVEL_FULL
202: -- p_sort_order IN VARCHAR2 Optional
203: -- Default = AMV_CATEGORY_PVT.G_ASC_ORDER

Line 201: -- Default = FND_API.G_VALID_LEVEL_FULL

197: -- Default = FND_API.G_FALSE
198: -- p_commit IN VARCHAR2 Optional
199: -- Default = FND_API.G_FALSE
200: -- p_validation_level IN NUMBER Optional
201: -- Default = FND_API.G_VALID_LEVEL_FULL
202: -- p_sort_order IN VARCHAR2 Optional
203: -- Default = AMV_CATEGORY_PVT.G_ASC_ORDER
204: -- Ascending(ASC) or Descending(DESC) Order.
205: -- p_parent_category_id IN NUMBER Optional

Line 206: -- Default = FND_API.G_MISS_NUM

202: -- p_sort_order IN VARCHAR2 Optional
203: -- Default = AMV_CATEGORY_PVT.G_ASC_ORDER
204: -- Ascending(ASC) or Descending(DESC) Order.
205: -- p_parent_category_id IN NUMBER Optional
206: -- Default = FND_API.G_MISS_NUM
207: -- parent id for sub categories
208: -- p_parent_category_name IN VARCHAR2 Optional
209: -- Default = FND_API.G_MISS_CHAR
210: -- category name for sub categories

Line 209: -- Default = FND_API.G_MISS_CHAR

205: -- p_parent_category_id IN NUMBER Optional
206: -- Default = FND_API.G_MISS_NUM
207: -- parent id for sub categories
208: -- p_parent_category_name IN VARCHAR2 Optional
209: -- Default = FND_API.G_MISS_CHAR
210: -- category name for sub categories
211: -- category name or parent category id should be
212: -- supplied for sorting sub categories
213: -- OUT : x_return_status OUT VARCHAR2

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

221: -- End of comments
222: --
223: PROCEDURE Sort_Category
224: ( p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
226: p_commit IN VARCHAR2 := FND_API.G_FALSE,
227: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
228: x_return_status OUT NOCOPY VARCHAR2,
229: x_msg_count OUT NOCOPY NUMBER,

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

222: --
223: PROCEDURE Sort_Category
224: ( p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
226: p_commit IN VARCHAR2 := FND_API.G_FALSE,
227: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
228: x_return_status OUT NOCOPY VARCHAR2,
229: x_msg_count OUT NOCOPY NUMBER,
230: x_msg_data OUT NOCOPY VARCHAR2,

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

223: PROCEDURE Sort_Category
224: ( p_api_version IN NUMBER,
225: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
226: p_commit IN VARCHAR2 := FND_API.G_FALSE,
227: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
228: x_return_status OUT NOCOPY VARCHAR2,
229: x_msg_count OUT NOCOPY NUMBER,
230: x_msg_data OUT NOCOPY VARCHAR2,
231: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 231: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

227: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
228: x_return_status OUT NOCOPY VARCHAR2,
229: x_msg_count OUT NOCOPY NUMBER,
230: x_msg_data OUT NOCOPY VARCHAR2,
231: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
232: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
233: p_sort_order IN VARCHAR2 := AMV_CATEGORY_PVT.G_ASC_ORDER,
234: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
235: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 234: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,

230: x_msg_data OUT NOCOPY VARCHAR2,
231: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
232: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
233: p_sort_order IN VARCHAR2 := AMV_CATEGORY_PVT.G_ASC_ORDER,
234: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
235: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR
236: );
237: --
238: -- Algorithm:

Line 235: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR

231: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
232: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
233: p_sort_order IN VARCHAR2 := AMV_CATEGORY_PVT.G_ASC_ORDER,
234: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
235: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR
236: );
237: --
238: -- Algorithm:
239: -- BEGIN

Line 252: -- Default = FND_API.G_FALSE

248: -- Function : Reorder channel (sub)category list
249: -- Parameters :
250: -- IN p_api_version IN NUMBER Required
251: -- p_init_msg_list IN VARCHAR2 Optional
252: -- Default = FND_API.G_FALSE
253: -- p_commit IN VARCHAR2 Optional
254: -- Default = FND_API.G_FALSE
255: -- p_validation_level NUMBER Optional
256: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 254: -- Default = FND_API.G_FALSE

250: -- IN p_api_version IN NUMBER Required
251: -- p_init_msg_list IN VARCHAR2 Optional
252: -- Default = FND_API.G_FALSE
253: -- p_commit IN VARCHAR2 Optional
254: -- Default = FND_API.G_FALSE
255: -- p_validation_level NUMBER Optional
256: -- Default = FND_API.G_VALID_LEVEL_FULL
257: -- p_category_id_array IN AMV_NUMBER_VARRAY_TYPE
258: -- Required

Line 256: -- Default = FND_API.G_VALID_LEVEL_FULL

252: -- Default = FND_API.G_FALSE
253: -- p_commit IN VARCHAR2 Optional
254: -- Default = FND_API.G_FALSE
255: -- p_validation_level NUMBER Optional
256: -- Default = FND_API.G_VALID_LEVEL_FULL
257: -- p_category_id_array IN AMV_NUMBER_VARRAY_TYPE
258: -- Required
259: -- p_category_new_order IN AMV_NUMBER_VARRAY_TYPE
260: -- Required

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

269: -- End of comments
270: --
271: PROCEDURE Reorder_Category
272: ( p_api_version IN NUMBER,
273: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
274: p_commit IN VARCHAR2 := FND_API.G_FALSE,
275: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
276: x_return_status OUT NOCOPY VARCHAR2,
277: x_msg_count OUT NOCOPY NUMBER,

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

270: --
271: PROCEDURE Reorder_Category
272: ( p_api_version IN NUMBER,
273: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
274: p_commit IN VARCHAR2 := FND_API.G_FALSE,
275: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
276: x_return_status OUT NOCOPY VARCHAR2,
277: x_msg_count OUT NOCOPY NUMBER,
278: x_msg_data OUT NOCOPY VARCHAR2,

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

271: PROCEDURE Reorder_Category
272: ( p_api_version IN NUMBER,
273: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
274: p_commit IN VARCHAR2 := FND_API.G_FALSE,
275: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
276: x_return_status OUT NOCOPY VARCHAR2,
277: x_msg_count OUT NOCOPY NUMBER,
278: x_msg_data OUT NOCOPY VARCHAR2,
279: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 279: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

275: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
276: x_return_status OUT NOCOPY VARCHAR2,
277: x_msg_count OUT NOCOPY NUMBER,
278: x_msg_data OUT NOCOPY VARCHAR2,
279: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
280: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
281: p_category_id_array IN AMV_NUMBER_VARRAY_TYPE,
282: p_category_new_order IN AMV_NUMBER_VARRAY_TYPE
283: );

Line 299: -- Default = FND_API.G_FALSE

295: -- Function : Update channel (sub)category given (sub)category id or name
296: -- Parameters :
297: -- IN p_api_version IN NUMBER Required
298: -- p_init_msg_list IN VARCHAR2 Optional
299: -- Default = FND_API.G_FALSE
300: -- p_commit IN VARCHAR2 Optional
301: -- Default = FND_API.G_FALSE
302: -- p_validation_level IN NUMBER Optional
303: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 301: -- Default = FND_API.G_FALSE

297: -- IN p_api_version IN NUMBER Required
298: -- p_init_msg_list IN VARCHAR2 Optional
299: -- Default = FND_API.G_FALSE
300: -- p_commit IN VARCHAR2 Optional
301: -- Default = FND_API.G_FALSE
302: -- p_validation_level IN NUMBER Optional
303: -- Default = FND_API.G_VALID_LEVEL_FULL
304: -- p_object_version_number IN NUMBER Required
305: -- object version number

Line 303: -- Default = FND_API.G_VALID_LEVEL_FULL

299: -- Default = FND_API.G_FALSE
300: -- p_commit IN VARCHAR2 Optional
301: -- Default = FND_API.G_FALSE
302: -- p_validation_level IN NUMBER Optional
303: -- Default = FND_API.G_VALID_LEVEL_FULL
304: -- p_object_version_number IN NUMBER Required
305: -- object version number
306: -- p_category_id IN NUMBER Required
307: -- channel category id.

Line 312: -- Default = FND_API.G_MISS_NUM

308: -- p_category_name IN VARCHAR2 Optional
309: -- channel category name.
310: -- (sub)category id or name is required
311: -- p_parent_category_id IN NUMBER Optional
312: -- Default = FND_API.G_MISS_NUM
313: -- channel category id.
314: -- p_parent_category_name IN VARCHAR2 Optional
315: -- Default = FND_API.G_MISS_CHAR
316: -- channel category name.

Line 315: -- Default = FND_API.G_MISS_CHAR

311: -- p_parent_category_id IN NUMBER Optional
312: -- Default = FND_API.G_MISS_NUM
313: -- channel category id.
314: -- p_parent_category_name IN VARCHAR2 Optional
315: -- Default = FND_API.G_MISS_CHAR
316: -- channel category name.
317: -- takes either parent id or name. id taken if both passed
318: -- p_category_order IN NUMBER Optional
319: -- new channel category order

Line 323: -- Default = FND_API.G_MISS_CHAR

319: -- new channel category order
320: -- p_category_new_name IN VARCHAR2 Optional
321: -- new channel category name. New name has to be unique
322: -- p_description IN VARCHAR2 Optional
323: -- Default = FND_API.G_MISS_CHAR
324: -- channel category description.
325: -- OUT : x_return_status OUT VARCHAR2
326: -- x_msg_count OUT NUMBER
327: -- x_msg_data OUT VARCHAR2

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

333: -- End of comments
334: --
335: PROCEDURE Update_Category
336: ( p_api_version IN NUMBER,
337: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
338: p_commit IN VARCHAR2 := FND_API.G_FALSE,
339: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
340: x_return_status OUT NOCOPY VARCHAR2,
341: x_msg_count OUT NOCOPY NUMBER,

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

334: --
335: PROCEDURE Update_Category
336: ( p_api_version IN NUMBER,
337: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
338: p_commit IN VARCHAR2 := FND_API.G_FALSE,
339: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
340: x_return_status OUT NOCOPY VARCHAR2,
341: x_msg_count OUT NOCOPY NUMBER,
342: x_msg_data OUT NOCOPY VARCHAR2,

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

335: PROCEDURE Update_Category
336: ( p_api_version IN NUMBER,
337: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
338: p_commit IN VARCHAR2 := FND_API.G_FALSE,
339: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
340: x_return_status OUT NOCOPY VARCHAR2,
341: x_msg_count OUT NOCOPY NUMBER,
342: x_msg_data OUT NOCOPY VARCHAR2,
343: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 343: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

339: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
340: x_return_status OUT NOCOPY VARCHAR2,
341: x_msg_count OUT NOCOPY NUMBER,
342: x_msg_data OUT NOCOPY VARCHAR2,
343: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
344: p_object_version_number IN NUMBER,
345: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
346: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
347: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 346: p_category_id IN NUMBER := FND_API.G_MISS_NUM,

342: x_msg_data OUT NOCOPY VARCHAR2,
343: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
344: p_object_version_number IN NUMBER,
345: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
346: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
347: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
348: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
349: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_category_order IN NUMBER := FND_API.G_MISS_NUM,

Line 347: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

343: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
344: p_object_version_number IN NUMBER,
345: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
346: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
347: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
348: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
349: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_category_order IN NUMBER := FND_API.G_MISS_NUM,
351: p_category_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 348: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,

344: p_object_version_number IN NUMBER,
345: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
346: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
347: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
348: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
349: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_category_order IN NUMBER := FND_API.G_MISS_NUM,
351: p_category_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
352: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 349: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

345: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
346: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
347: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
348: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
349: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_category_order IN NUMBER := FND_API.G_MISS_NUM,
351: p_category_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
352: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
353: );

Line 350: p_category_order IN NUMBER := FND_API.G_MISS_NUM,

346: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
347: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
348: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
349: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_category_order IN NUMBER := FND_API.G_MISS_NUM,
351: p_category_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
352: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
353: );
354: --

Line 351: p_category_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

347: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
348: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
349: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_category_order IN NUMBER := FND_API.G_MISS_NUM,
351: p_category_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
352: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
353: );
354: --
355: -- Algorithm:

Line 352: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR

348: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
349: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
350: p_category_order IN NUMBER := FND_API.G_MISS_NUM,
351: p_category_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
352: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
353: );
354: --
355: -- Algorithm:
356: -- BEGIN

Line 369: -- Default = FND_API.G_FALSE

365: -- Function : Search and return channel (sub)categories
366: -- Parameters :
367: -- IN p_api_version IN NUMBER Required
368: -- p_init_msg_list IN VARCHAR2 Optional
369: -- Default = FND_API.G_FALSE
370: -- p_validation_level NUMBER Optional
371: -- Default = FND_API.G_VALID_LEVEL_FULL
372: -- p_application_id IN NUMBER Optional
373: -- Default = AMV_UTILITY_PVT.G_AMV_APP_ID (520)

Line 371: -- Default = FND_API.G_VALID_LEVEL_FULL

367: -- IN p_api_version IN NUMBER Required
368: -- p_init_msg_list IN VARCHAR2 Optional
369: -- Default = FND_API.G_FALSE
370: -- p_validation_level NUMBER Optional
371: -- Default = FND_API.G_VALID_LEVEL_FULL
372: -- p_application_id IN NUMBER Optional
373: -- Default = AMV_UTILITY_PVT.G_AMV_APP_ID (520)
374: -- application creating the channel
375: -- p_category_name IN VARCHAR2 Optional

Line 378: -- Default = FND_API.G_MISS_NUM

374: -- application creating the channel
375: -- p_category_name IN VARCHAR2 Optional
376: -- Search criteria by name. Default = '%' (everything)
377: -- p_parent_category_id IN NUMBER Optional
378: -- Default = FND_API.G_MISS_NUM
379: -- parent id for sub categories
380: -- p_parent_category_name IN VARCHAR2 Optional
381: -- Default = FND_API.G_MISS_CHAR
382: -- parent name for sub categories

Line 381: -- Default = FND_API.G_MISS_CHAR

377: -- p_parent_category_id IN NUMBER Optional
378: -- Default = FND_API.G_MISS_NUM
379: -- parent id for sub categories
380: -- p_parent_category_name IN VARCHAR2 Optional
381: -- Default = FND_API.G_MISS_CHAR
382: -- parent name for sub categories
383: -- takes either parent id or name. id taken if both passed
384: -- OUT : x_return_status OUT VARCHAR2
385: -- x_msg_count OUT NUMBER

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

393: -- End of comments
394: --
395: PROCEDURE Find_Categories
396: ( p_api_version IN NUMBER,
397: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
398: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
399: x_return_status OUT NOCOPY VARCHAR2,
400: x_msg_count OUT NOCOPY NUMBER,
401: x_msg_data OUT NOCOPY VARCHAR2,

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

394: --
395: PROCEDURE Find_Categories
396: ( p_api_version IN NUMBER,
397: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
398: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
399: x_return_status OUT NOCOPY VARCHAR2,
400: x_msg_count OUT NOCOPY NUMBER,
401: x_msg_data OUT NOCOPY VARCHAR2,
402: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 402: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

398: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
399: x_return_status OUT NOCOPY VARCHAR2,
400: x_msg_count OUT NOCOPY NUMBER,
401: x_msg_data OUT NOCOPY VARCHAR2,
402: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
403: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
404: p_category_name IN VARCHAR2 := '%',
405: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
406: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 405: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,

401: x_msg_data OUT NOCOPY VARCHAR2,
402: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
403: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
404: p_category_name IN VARCHAR2 := '%',
405: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
406: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
407: p_ignore_hierarchy IN VARCHAR2 := FND_API.G_FALSE,
408: p_request_obj IN AMV_REQUEST_OBJ_TYPE,
409: x_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,

Line 406: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

402: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
403: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
404: p_category_name IN VARCHAR2 := '%',
405: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
406: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
407: p_ignore_hierarchy IN VARCHAR2 := FND_API.G_FALSE,
408: p_request_obj IN AMV_REQUEST_OBJ_TYPE,
409: x_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
410: x_chan_category_rec_array OUT NOCOPY AMV_CATEGORY_VARRAY_TYPE

Line 407: p_ignore_hierarchy IN VARCHAR2 := FND_API.G_FALSE,

403: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
404: p_category_name IN VARCHAR2 := '%',
405: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
406: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
407: p_ignore_hierarchy IN VARCHAR2 := FND_API.G_FALSE,
408: p_request_obj IN AMV_REQUEST_OBJ_TYPE,
409: x_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
410: x_chan_category_rec_array OUT NOCOPY AMV_CATEGORY_VARRAY_TYPE
411: );

Line 427: -- Default = FND_API.G_FALSE

423: -- a content channel (sub)category
424: -- Parameters :
425: -- IN p_api_version IN NUMBER Required
426: -- p_init_msg_list IN VARCHAR2 Optional
427: -- Default = FND_API.G_FALSE
428: -- p_validation_level IN NUMBER Optional
429: -- Default = FND_API.G_VALID_LEVEL_FULL
430: -- p_category_id IN NUMBER Required
431: -- p_include_subcats IN VARCHAR2 Optional

Line 429: -- Default = FND_API.G_VALID_LEVEL_FULL

425: -- IN p_api_version IN NUMBER Required
426: -- p_init_msg_list IN VARCHAR2 Optional
427: -- Default = FND_API.G_FALSE
428: -- p_validation_level IN NUMBER Optional
429: -- Default = FND_API.G_VALID_LEVEL_FULL
430: -- p_category_id IN NUMBER Required
431: -- p_include_subcats IN VARCHAR2 Optional
432: -- Default = FND_API.G_FALSE
433: -- OUT : x_return_status OUT VARCHAR2

Line 432: -- Default = FND_API.G_FALSE

428: -- p_validation_level IN NUMBER Optional
429: -- Default = FND_API.G_VALID_LEVEL_FULL
430: -- p_category_id IN NUMBER Required
431: -- p_include_subcats IN VARCHAR2 Optional
432: -- Default = FND_API.G_FALSE
433: -- OUT : x_return_status OUT VARCHAR2
434: -- x_msg_count OUT NUMBER
435: -- x_msg_data OUT VARCHAR2
436: -- x_content_chan_array OUT AMV_CAT_HIERARCHY_VARRAY_TYPE

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

442: -- End of comments
443: --
444: PROCEDURE Get_ChannelsPerCategory
445: ( p_api_version IN NUMBER,
446: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
447: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
448: x_return_status OUT NOCOPY VARCHAR2,
449: x_msg_count OUT NOCOPY NUMBER,
450: x_msg_data OUT NOCOPY VARCHAR2,

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

443: --
444: PROCEDURE Get_ChannelsPerCategory
445: ( p_api_version IN NUMBER,
446: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
447: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
448: x_return_status OUT NOCOPY VARCHAR2,
449: x_msg_count OUT NOCOPY NUMBER,
450: x_msg_data OUT NOCOPY VARCHAR2,
451: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 451: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

447: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
448: x_return_status OUT NOCOPY VARCHAR2,
449: x_msg_count OUT NOCOPY NUMBER,
450: x_msg_data OUT NOCOPY VARCHAR2,
451: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
452: p_category_id IN NUMBER,
453: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
454: x_content_chan_array OUT NOCOPY AMV_CAT_HIERARCHY_VARRAY_TYPE
455: );

Line 453: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,

449: x_msg_count OUT NOCOPY NUMBER,
450: x_msg_data OUT NOCOPY VARCHAR2,
451: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
452: p_category_id IN NUMBER,
453: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
454: x_content_chan_array OUT NOCOPY AMV_CAT_HIERARCHY_VARRAY_TYPE
455: );
456: --
457: -- Algorithm:

Line 471: -- Default = FND_API.G_FALSE

467: -- a content channel (sub)category
468: -- Parameters :
469: -- IN p_api_version IN NUMBER Required
470: -- p_init_msg_list IN VARCHAR2 Optional
471: -- Default = FND_API.G_FALSE
472: -- p_validation_level IN NUMBER Optional
473: -- Default = FND_API.G_VALID_LEVEL_FULL
474: -- p_category_id IN NUMBER Required
475: -- p_include_subcats IN VARCHAR2 Optional

Line 473: -- Default = FND_API.G_VALID_LEVEL_FULL

469: -- IN p_api_version IN NUMBER Required
470: -- p_init_msg_list IN VARCHAR2 Optional
471: -- Default = FND_API.G_FALSE
472: -- p_validation_level IN NUMBER Optional
473: -- Default = FND_API.G_VALID_LEVEL_FULL
474: -- p_category_id IN NUMBER Required
475: -- p_include_subcats IN VARCHAR2 Optional
476: -- Default = FND_API.G_FALSE
477: -- OUT : x_return_status OUT VARCHAR2

Line 476: -- Default = FND_API.G_FALSE

472: -- p_validation_level IN NUMBER Optional
473: -- Default = FND_API.G_VALID_LEVEL_FULL
474: -- p_category_id IN NUMBER Required
475: -- p_include_subcats IN VARCHAR2 Optional
476: -- Default = FND_API.G_FALSE
477: -- OUT : x_return_status OUT VARCHAR2
478: -- x_msg_count OUT NUMBER
479: -- x_msg_data OUT VARCHAR2
480: -- x_items_array OUT AMV_CAT_HIERARCHY_VARRAY_TYPE

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

486: -- End of comments
487: --
488: PROCEDURE Get_ItemsPerCategory
489: ( p_api_version IN NUMBER,
490: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
491: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
492: x_return_status OUT NOCOPY VARCHAR2,
493: x_msg_count OUT NOCOPY NUMBER,
494: x_msg_data OUT NOCOPY VARCHAR2,

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

487: --
488: PROCEDURE Get_ItemsPerCategory
489: ( p_api_version IN NUMBER,
490: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
491: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
492: x_return_status OUT NOCOPY VARCHAR2,
493: x_msg_count OUT NOCOPY NUMBER,
494: x_msg_data OUT NOCOPY VARCHAR2,
495: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 495: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

491: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
492: x_return_status OUT NOCOPY VARCHAR2,
493: x_msg_count OUT NOCOPY NUMBER,
494: x_msg_data OUT NOCOPY VARCHAR2,
495: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
496: p_category_id IN NUMBER,
497: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
498: x_items_array OUT NOCOPY AMV_CAT_HIERARCHY_VARRAY_TYPE
499: );

Line 497: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,

493: x_msg_count OUT NOCOPY NUMBER,
494: x_msg_data OUT NOCOPY VARCHAR2,
495: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
496: p_category_id IN NUMBER,
497: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
498: x_items_array OUT NOCOPY AMV_CAT_HIERARCHY_VARRAY_TYPE
499: );
500: --
501: -- Algorithm:

Line 515: -- Default = FND_API.G_FALSE

511: -- a content channel (sub)category
512: -- Parameters :
513: -- IN p_api_version IN NUMBER Required
514: -- p_init_msg_list IN VARCHAR2 Optional
515: -- Default = FND_API.G_FALSE
516: -- p_validation_level IN NUMBER Optional
517: -- Default = FND_API.G_VALID_LEVEL_FULL
518: -- p_category_id IN NUMBER Required
519: -- p_include_subcats IN VARCHAR2 Optional

Line 517: -- Default = FND_API.G_VALID_LEVEL_FULL

513: -- IN p_api_version IN NUMBER Required
514: -- p_init_msg_list IN VARCHAR2 Optional
515: -- Default = FND_API.G_FALSE
516: -- p_validation_level IN NUMBER Optional
517: -- Default = FND_API.G_VALID_LEVEL_FULL
518: -- p_category_id IN NUMBER Required
519: -- p_include_subcats IN VARCHAR2 Optional
520: -- Default = FND_API.G_FALSE
521: -- OUT : x_return_status OUT VARCHAR2

Line 520: -- Default = FND_API.G_FALSE

516: -- p_validation_level IN NUMBER Optional
517: -- Default = FND_API.G_VALID_LEVEL_FULL
518: -- p_category_id IN NUMBER Required
519: -- p_include_subcats IN VARCHAR2 Optional
520: -- Default = FND_API.G_FALSE
521: -- OUT : x_return_status OUT VARCHAR2
522: -- x_msg_count OUT NUMBER
523: -- x_msg_data OUT VARCHAR2
524: -- x_items_array OUT AMV_CAT_HIERARCHY_VARRAY_TYPE

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

530: -- End of comments
531: --
532: PROCEDURE Get_ItemsPerCategory
533: ( p_api_version IN NUMBER,
534: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
535: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
536: x_return_status OUT NOCOPY VARCHAR2,
537: x_msg_count OUT NOCOPY NUMBER,
538: x_msg_data OUT NOCOPY VARCHAR2,

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

531: --
532: PROCEDURE Get_ItemsPerCategory
533: ( p_api_version IN NUMBER,
534: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
535: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
536: x_return_status OUT NOCOPY VARCHAR2,
537: x_msg_count OUT NOCOPY NUMBER,
538: x_msg_data OUT NOCOPY VARCHAR2,
539: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 539: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

535: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
536: x_return_status OUT NOCOPY VARCHAR2,
537: x_msg_count OUT NOCOPY NUMBER,
538: x_msg_data OUT NOCOPY VARCHAR2,
539: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
540: p_category_id IN NUMBER,
541: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
542: p_request_obj IN AMV_REQUEST_OBJ_TYPE,
543: p_category_sort IN AMV_SORT_OBJ_TYPE,

Line 541: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,

537: x_msg_count OUT NOCOPY NUMBER,
538: x_msg_data OUT NOCOPY VARCHAR2,
539: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
540: p_category_id IN NUMBER,
541: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
542: p_request_obj IN AMV_REQUEST_OBJ_TYPE,
543: p_category_sort IN AMV_SORT_OBJ_TYPE,
544: x_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
545: x_items_array OUT NOCOPY AMV_CAT_HIERARCHY_VARRAY_TYPE

Line 562: -- Default = FND_API.G_FALSE

558: -- Function : Return category id for a category or subcategory name.
559: -- Parameters :
560: -- IN p_api_version IN NUMBER Required
561: -- p_init_msg_list IN VARCHAR2 Optional
562: -- Default = FND_API.G_FALSE
563: -- p_validation_level IN NUMBER Optional
564: -- Default = FND_API.G_VALID_LEVEL_FULL
565: -- p_category_name IN VARCHAR2 Required
566: -- (sub)category id

Line 564: -- Default = FND_API.G_VALID_LEVEL_FULL

560: -- IN p_api_version IN NUMBER Required
561: -- p_init_msg_list IN VARCHAR2 Optional
562: -- Default = FND_API.G_FALSE
563: -- p_validation_level IN NUMBER Optional
564: -- Default = FND_API.G_VALID_LEVEL_FULL
565: -- p_category_name IN VARCHAR2 Required
566: -- (sub)category id
567: -- p_parent_category_id IN NUMBER Optional
568: -- Default = FND_API.G_MISS_NUM

Line 568: -- Default = FND_API.G_MISS_NUM

564: -- Default = FND_API.G_VALID_LEVEL_FULL
565: -- p_category_name IN VARCHAR2 Required
566: -- (sub)category id
567: -- p_parent_category_id IN NUMBER Optional
568: -- Default = FND_API.G_MISS_NUM
569: -- parent category id
570: -- p_parent_category_name IN VARCHAR2 Optional
571: -- Default = FND_API.G_MISS_CHAR
572: -- parent category name

Line 571: -- Default = FND_API.G_MISS_CHAR

567: -- p_parent_category_id IN NUMBER Optional
568: -- Default = FND_API.G_MISS_NUM
569: -- parent category id
570: -- p_parent_category_name IN VARCHAR2 Optional
571: -- Default = FND_API.G_MISS_CHAR
572: -- parent category name
573: -- parent id or name required for subcategory name
574: -- OUT : x_return_status OUT VARCHAR2
575: -- x_msg_count OUT NUMBER

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

583: --
584: --
585: PROCEDURE Fetch_CategoryId
586: ( p_api_version IN NUMBER,
587: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
588: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
589: x_return_status OUT NOCOPY VARCHAR2,
590: x_msg_count OUT NOCOPY NUMBER,
591: x_msg_data OUT NOCOPY VARCHAR2,

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

584: --
585: PROCEDURE Fetch_CategoryId
586: ( p_api_version IN NUMBER,
587: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
588: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
589: x_return_status OUT NOCOPY VARCHAR2,
590: x_msg_count OUT NOCOPY NUMBER,
591: x_msg_data OUT NOCOPY VARCHAR2,
592: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 592: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

588: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
589: x_return_status OUT NOCOPY VARCHAR2,
590: x_msg_count OUT NOCOPY NUMBER,
591: x_msg_data OUT NOCOPY VARCHAR2,
592: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
593: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
594: p_category_name IN VARCHAR2,
595: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
596: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 595: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,

591: x_msg_data OUT NOCOPY VARCHAR2,
592: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
593: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
594: p_category_name IN VARCHAR2,
595: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
596: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
597: x_category_id OUT NOCOPY NUMBER
598: );
599: -- Algorithm:

Line 596: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

592: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
593: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
594: p_category_name IN VARCHAR2,
595: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
596: p_parent_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
597: x_category_id OUT NOCOPY NUMBER
598: );
599: -- Algorithm:
600: -- BEGIN

Line 615: -- Default = FND_API.G_FALSE

611: -- for a category id.
612: -- Parameters :
613: -- IN p_api_version IN NUMBER Required
614: -- p_init_msg_list IN VARCHAR2 Optional
615: -- Default = FND_API.G_FALSE
616: -- p_validation_level IN NUMBER Optional
617: -- Default = FND_API.G_VALID_LEVEL_FULL
618: -- p_category_id IN NUMBER Required
619: -- (sub)category id

Line 617: -- Default = FND_API.G_VALID_LEVEL_FULL

613: -- IN p_api_version IN NUMBER Required
614: -- p_init_msg_list IN VARCHAR2 Optional
615: -- Default = FND_API.G_FALSE
616: -- p_validation_level IN NUMBER Optional
617: -- Default = FND_API.G_VALID_LEVEL_FULL
618: -- p_category_id IN NUMBER Required
619: -- (sub)category id
620: -- OUT : x_return_status OUT VARCHAR2
621: -- x_msg_count OUT NUMBER

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

629: --
630: --
631: PROCEDURE Get_CatParentsHierarchy
632: ( p_api_version IN NUMBER,
633: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
634: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
635: x_return_status OUT NOCOPY VARCHAR2,
636: x_msg_count OUT NOCOPY NUMBER,
637: x_msg_data OUT NOCOPY VARCHAR2,

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

630: --
631: PROCEDURE Get_CatParentsHierarchy
632: ( p_api_version IN NUMBER,
633: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
634: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
635: x_return_status OUT NOCOPY VARCHAR2,
636: x_msg_count OUT NOCOPY NUMBER,
637: x_msg_data OUT NOCOPY VARCHAR2,
638: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 638: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

634: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
635: x_return_status OUT NOCOPY VARCHAR2,
636: x_msg_count OUT NOCOPY NUMBER,
637: x_msg_data OUT NOCOPY VARCHAR2,
638: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
639: p_category_id IN NUMBER,
640: x_category_hierarchy OUT NOCOPY AMV_CAT_HIERARCHY_VARRAY_TYPE
641: );
642: -- Algorithm:

Line 658: -- Default = FND_API.G_FALSE

654: -- for a category id.
655: -- Parameters :
656: -- IN p_api_version IN NUMBER Required
657: -- p_init_msg_list IN VARCHAR2 Optional
658: -- Default = FND_API.G_FALSE
659: -- p_validation_level IN NUMBER Optional
660: -- Default = FND_API.G_VALID_LEVEL_FULL
661: -- p_category_id IN NUMBER Required
662: -- (sub)category id

Line 660: -- Default = FND_API.G_VALID_LEVEL_FULL

656: -- IN p_api_version IN NUMBER Required
657: -- p_init_msg_list IN VARCHAR2 Optional
658: -- Default = FND_API.G_FALSE
659: -- p_validation_level IN NUMBER Optional
660: -- Default = FND_API.G_VALID_LEVEL_FULL
661: -- p_category_id IN NUMBER Required
662: -- (sub)category id
663: -- OUT : x_return_status OUT VARCHAR2
664: -- x_msg_count OUT NUMBER

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

672: --
673: --
674: PROCEDURE Get_CatChildrenHierarchy
675: ( p_api_version IN NUMBER,
676: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
677: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
678: x_return_status OUT NOCOPY VARCHAR2,
679: x_msg_count OUT NOCOPY NUMBER,
680: x_msg_data OUT NOCOPY VARCHAR2,

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

673: --
674: PROCEDURE Get_CatChildrenHierarchy
675: ( p_api_version IN NUMBER,
676: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
677: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
678: x_return_status OUT NOCOPY VARCHAR2,
679: x_msg_count OUT NOCOPY NUMBER,
680: x_msg_data OUT NOCOPY VARCHAR2,
681: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 681: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

677: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
678: x_return_status OUT NOCOPY VARCHAR2,
679: x_msg_count OUT NOCOPY NUMBER,
680: x_msg_data OUT NOCOPY VARCHAR2,
681: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
682: p_category_id IN NUMBER,
683: x_category_hierarchy OUT NOCOPY AMV_CAT_HIERARCHY_VARRAY_TYPE
684: );
685: -- Algorithm:

Line 701: -- Default = FND_API.G_FALSE

697: -- for a channel id.
698: -- Parameters :
699: -- IN p_api_version IN NUMBER Required
700: -- p_init_msg_list IN VARCHAR2 Optional
701: -- Default = FND_API.G_FALSE
702: -- p_validation_level IN NUMBER Optional
703: -- Default = FND_API.G_VALID_LEVEL_FULL
704: -- p_channel_id IN NUMBER Required
705: -- channel id

Line 703: -- Default = FND_API.G_VALID_LEVEL_FULL

699: -- IN p_api_version IN NUMBER Required
700: -- p_init_msg_list IN VARCHAR2 Optional
701: -- Default = FND_API.G_FALSE
702: -- p_validation_level IN NUMBER Optional
703: -- Default = FND_API.G_VALID_LEVEL_FULL
704: -- p_channel_id IN NUMBER Required
705: -- channel id
706: -- OUT : x_return_status OUT VARCHAR2
707: -- x_msg_count OUT NUMBER

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

716: --
717: --
718: PROCEDURE Get_ChnCategoryHierarchy
719: ( p_api_version IN NUMBER,
720: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
721: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
722: x_return_status OUT NOCOPY VARCHAR2,
723: x_msg_count OUT NOCOPY NUMBER,
724: x_msg_data OUT NOCOPY VARCHAR2,

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

717: --
718: PROCEDURE Get_ChnCategoryHierarchy
719: ( p_api_version IN NUMBER,
720: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
721: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
722: x_return_status OUT NOCOPY VARCHAR2,
723: x_msg_count OUT NOCOPY NUMBER,
724: x_msg_data OUT NOCOPY VARCHAR2,
725: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 725: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

721: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
722: x_return_status OUT NOCOPY VARCHAR2,
723: x_msg_count OUT NOCOPY NUMBER,
724: x_msg_data OUT NOCOPY VARCHAR2,
725: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
726: p_channel_id IN NUMBER,
727: x_channel_name OUT NOCOPY VARCHAR2,
728: x_category_hierarchy OUT NOCOPY AMV_CAT_HIERARCHY_VARRAY_TYPE
729: );

Line 745: -- Default = FND_API.G_FALSE

741: -- Function : attaches a category to a parent category
742: -- Parameters :
743: -- IN p_api_version IN NUMBER Required
744: -- p_init_msg_list IN VARCHAR2 Optional
745: -- Default = FND_API.G_FALSE
746: -- p_validation_level IN NUMBER Optional
747: -- Default = FND_API.G_VALID_LEVEL_FULL
748: -- p_category_id IN NUMBER Required
749: -- category id

Line 747: -- Default = FND_API.G_VALID_LEVEL_FULL

743: -- IN p_api_version IN NUMBER Required
744: -- p_init_msg_list IN VARCHAR2 Optional
745: -- Default = FND_API.G_FALSE
746: -- p_validation_level IN NUMBER Optional
747: -- Default = FND_API.G_VALID_LEVEL_FULL
748: -- p_category_id IN NUMBER Required
749: -- category id
750: -- p_parent_category_id IN NUMBER Required
751: -- parent category id

Line 753: -- Default = FND_API.G_FALSE

749: -- category id
750: -- p_parent_category_id IN NUMBER Required
751: -- parent category id
752: -- p_replace_existing IN VARCHAR2 Optional
753: -- Default = FND_API.G_FALSE
754: -- OUT : x_return_status OUT VARCHAR2
755: -- x_msg_count OUT NUMBER
756: -- x_msg_data OUT VARCHAR2
757: -- Version : Current version 1.0

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

762: --
763: --
764: PROCEDURE Add_CategoryParent
765: ( p_api_version IN NUMBER,
766: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
767: p_commit IN VARCHAR2 := FND_API.G_FALSE,
768: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
769: x_return_status OUT NOCOPY VARCHAR2,
770: x_msg_count OUT NOCOPY NUMBER,

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

763: --
764: PROCEDURE Add_CategoryParent
765: ( p_api_version IN NUMBER,
766: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
767: p_commit IN VARCHAR2 := FND_API.G_FALSE,
768: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
769: x_return_status OUT NOCOPY VARCHAR2,
770: x_msg_count OUT NOCOPY NUMBER,
771: x_msg_data OUT NOCOPY VARCHAR2,

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

764: PROCEDURE Add_CategoryParent
765: ( p_api_version IN NUMBER,
766: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
767: p_commit IN VARCHAR2 := FND_API.G_FALSE,
768: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
769: x_return_status OUT NOCOPY VARCHAR2,
770: x_msg_count OUT NOCOPY NUMBER,
771: x_msg_data OUT NOCOPY VARCHAR2,
772: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 772: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

768: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
769: x_return_status OUT NOCOPY VARCHAR2,
770: x_msg_count OUT NOCOPY NUMBER,
771: x_msg_data OUT NOCOPY VARCHAR2,
772: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
773: p_object_version_number IN NUMBER,
774: p_category_id IN NUMBER,
775: p_parent_category_id IN NUMBER,
776: p_replace_existing IN VARCHAR2 := FND_API.G_FALSE

Line 776: p_replace_existing IN VARCHAR2 := FND_API.G_FALSE

772: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
773: p_object_version_number IN NUMBER,
774: p_category_id IN NUMBER,
775: p_parent_category_id IN NUMBER,
776: p_replace_existing IN VARCHAR2 := FND_API.G_FALSE
777: );
778: -- Algorithm:
779: -- BEGIN
780: -- ...

Line 793: -- Default = FND_API.G_FALSE

789: -- Function : removes a category from a parent category
790: -- Parameters :
791: -- IN p_api_version IN NUMBER Required
792: -- p_init_msg_list IN VARCHAR2 Optional
793: -- Default = FND_API.G_FALSE
794: -- p_validation_level IN NUMBER Optional
795: -- Default = FND_API.G_VALID_LEVEL_FULL
796: -- p_category_id IN NUMBER Required
797: -- category id

Line 795: -- Default = FND_API.G_VALID_LEVEL_FULL

791: -- IN p_api_version IN NUMBER Required
792: -- p_init_msg_list IN VARCHAR2 Optional
793: -- Default = FND_API.G_FALSE
794: -- p_validation_level IN NUMBER Optional
795: -- Default = FND_API.G_VALID_LEVEL_FULL
796: -- p_category_id IN NUMBER Required
797: -- category id
798: -- OUT : x_return_status OUT VARCHAR2
799: -- x_msg_count OUT NUMBER

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

806: --
807: --
808: PROCEDURE Remove_CategoryParent
809: ( p_api_version IN NUMBER,
810: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
811: p_commit IN VARCHAR2 := FND_API.G_FALSE,
812: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
813: x_return_status OUT NOCOPY VARCHAR2,
814: x_msg_count OUT NOCOPY NUMBER,

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

807: --
808: PROCEDURE Remove_CategoryParent
809: ( p_api_version IN NUMBER,
810: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
811: p_commit IN VARCHAR2 := FND_API.G_FALSE,
812: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
813: x_return_status OUT NOCOPY VARCHAR2,
814: x_msg_count OUT NOCOPY NUMBER,
815: x_msg_data OUT NOCOPY VARCHAR2,

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

808: PROCEDURE Remove_CategoryParent
809: ( p_api_version IN NUMBER,
810: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
811: p_commit IN VARCHAR2 := FND_API.G_FALSE,
812: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
813: x_return_status OUT NOCOPY VARCHAR2,
814: x_msg_count OUT NOCOPY NUMBER,
815: x_msg_data OUT NOCOPY VARCHAR2,
816: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

Line 816: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

812: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
813: x_return_status OUT NOCOPY VARCHAR2,
814: x_msg_count OUT NOCOPY NUMBER,
815: x_msg_data OUT NOCOPY VARCHAR2,
816: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
817: p_object_version_number IN NUMBER,
818: p_category_id IN NUMBER
819: );
820: -- Algorithm: