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_GRP dependencies on FND_API

Line 28: -- Default = FND_API.G_FALSE

24: -- Function : Create (sub)category.
25: -- Parameters :
26: -- IN p_api_version IN NUMBER Required
27: -- p_init_msg_list IN VARCHAR2 Optional
28: -- Default = FND_API.G_FALSE
29: -- p_commit IN VARCHAR2 Optional
30: -- Default = FND_API.G_FALSE
31: -- p_validation_level IN NUMBER Optional
32: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 30: -- Default = FND_API.G_FALSE

26: -- IN p_api_version IN NUMBER Required
27: -- p_init_msg_list IN VARCHAR2 Optional
28: -- Default = FND_API.G_FALSE
29: -- p_commit IN VARCHAR2 Optional
30: -- Default = FND_API.G_FALSE
31: -- p_validation_level IN NUMBER Optional
32: -- Default = FND_API.G_VALID_LEVEL_FULL
33: -- p_application_id IN NUMBER Required
34: -- application creating the category

Line 32: -- Default = FND_API.G_VALID_LEVEL_FULL

28: -- Default = FND_API.G_FALSE
29: -- p_commit IN VARCHAR2 Optional
30: -- Default = FND_API.G_FALSE
31: -- p_validation_level IN NUMBER Optional
32: -- Default = FND_API.G_VALID_LEVEL_FULL
33: -- p_application_id IN NUMBER Required
34: -- application creating the category
35: -- p_category_name IN VARCHAR2 Required
36: -- the channel category name. Have to be unique.

Line 41: -- Default = FND_API.G_MISS_NUM

37: -- p_description IN VARCHAR2 Optional
38: -- the channel (sub)category description.
39: -- p_parent_category_id IN VARCHAR2 Required
40: -- p_order IN NUMBER Optional
41: -- Default = FND_API.G_MISS_NUM
42: -- the order of this catgory among all the categories
43: -- OUT NOCOPY : x_return_status OUT NOCOPY VARCHAR2
44: -- x_msg_count OUT NOCOPY NUMBER
45: -- x_msg_data OUT NOCOPY VARCHAR2

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

52: -- End of comments
53: --
54: PROCEDURE Add_Category
55: ( p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57: p_commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,

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

53: --
54: PROCEDURE Add_Category
55: ( p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57: p_commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,
61: x_msg_data OUT NOCOPY VARCHAR2,

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

54: PROCEDURE Add_Category
55: ( p_api_version IN NUMBER,
56: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
57: p_commit IN VARCHAR2 := FND_API.G_FALSE,
58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,
61: x_msg_data OUT NOCOPY VARCHAR2,
62: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

58: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
59: x_return_status OUT NOCOPY VARCHAR2,
60: x_msg_count OUT NOCOPY NUMBER,
61: x_msg_data OUT NOCOPY VARCHAR2,
62: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
63: p_application_id IN NUMBER,
64: p_category_name IN VARCHAR2,
65: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_parent_category_id IN NUMBER,

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

61: x_msg_data OUT NOCOPY VARCHAR2,
62: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
63: p_application_id IN NUMBER,
64: p_category_name IN VARCHAR2,
65: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_parent_category_id IN NUMBER,
67: p_order IN NUMBER := FND_API.G_MISS_NUM,
68: x_category_id OUT NOCOPY NUMBER
69: );

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

63: p_application_id IN NUMBER,
64: p_category_name IN VARCHAR2,
65: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
66: p_parent_category_id IN NUMBER,
67: p_order IN NUMBER := FND_API.G_MISS_NUM,
68: x_category_id OUT NOCOPY NUMBER
69: );
70: --
71: -- Algorithm:

Line 86: -- Default = FND_API.G_FALSE

82: -- p_category_name along with p_parent_category_id.
83: -- Parameters :
84: -- IN p_api_version IN NUMBER Required
85: -- p_init_msg_list IN VARCHAR2 Optional
86: -- Default = FND_API.G_FALSE
87: -- p_commit IN VARCHAR2 Optional
88: -- Default = FND_API.G_FALSE
89: -- p_validation_level IN NUMBER Optional
90: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 88: -- Default = FND_API.G_FALSE

84: -- IN p_api_version IN NUMBER Required
85: -- p_init_msg_list IN VARCHAR2 Optional
86: -- Default = FND_API.G_FALSE
87: -- p_commit IN VARCHAR2 Optional
88: -- Default = FND_API.G_FALSE
89: -- p_validation_level IN NUMBER Optional
90: -- Default = FND_API.G_VALID_LEVEL_FULL
91: -- p_category_id IN NUMBER Optional
92: -- Default = FND_API.G_MISS_NUM

Line 90: -- Default = FND_API.G_VALID_LEVEL_FULL

86: -- Default = FND_API.G_FALSE
87: -- p_commit IN VARCHAR2 Optional
88: -- Default = FND_API.G_FALSE
89: -- p_validation_level IN NUMBER Optional
90: -- Default = FND_API.G_VALID_LEVEL_FULL
91: -- p_category_id IN NUMBER Optional
92: -- Default = FND_API.G_MISS_NUM
93: -- channel (sub)category id.
94: -- p_category_name IN VARCHAR2 Optional

Line 92: -- Default = FND_API.G_MISS_NUM

88: -- Default = FND_API.G_FALSE
89: -- p_validation_level IN NUMBER Optional
90: -- Default = FND_API.G_VALID_LEVEL_FULL
91: -- p_category_id IN NUMBER Optional
92: -- Default = FND_API.G_MISS_NUM
93: -- channel (sub)category id.
94: -- p_category_name IN VARCHAR2 Optional
95: -- Default = FND_API.G_MISS_CHAR
96: -- channel (sub)category name.

Line 95: -- Default = FND_API.G_MISS_CHAR

91: -- p_category_id IN NUMBER Optional
92: -- Default = FND_API.G_MISS_NUM
93: -- channel (sub)category id.
94: -- p_category_name IN VARCHAR2 Optional
95: -- Default = FND_API.G_MISS_CHAR
96: -- channel (sub)category name.
97: -- p_parent_category_id IN NUMBER Optional
98: -- Default = FND_API.G_MISS_NUM
99: -- parent id for (sub) category

Line 98: -- Default = FND_API.G_MISS_NUM

94: -- p_category_name IN VARCHAR2 Optional
95: -- Default = FND_API.G_MISS_CHAR
96: -- channel (sub)category name.
97: -- p_parent_category_id IN NUMBER Optional
98: -- Default = FND_API.G_MISS_NUM
99: -- parent id for (sub) category
100: -- OUT NOCOPY : x_return_status OUT NOCOPY VARCHAR2
101: -- x_msg_count OUT NOCOPY NUMBER
102: -- x_msg_data OUT NOCOPY VARCHAR2

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

108: -- End of comments
109: --
110: PROCEDURE Delete_Category
111: ( p_api_version IN NUMBER,
112: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
113: p_commit IN VARCHAR2 := FND_API.G_FALSE,
114: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,

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

109: --
110: PROCEDURE Delete_Category
111: ( p_api_version IN NUMBER,
112: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
113: p_commit IN VARCHAR2 := FND_API.G_FALSE,
114: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,

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

110: PROCEDURE Delete_Category
111: ( p_api_version IN NUMBER,
112: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
113: p_commit IN VARCHAR2 := FND_API.G_FALSE,
114: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,
118: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

114: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
115: x_return_status OUT NOCOPY VARCHAR2,
116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,
118: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
119: p_application_id IN NUMBER,
120: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
121: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM

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

116: x_msg_count OUT NOCOPY NUMBER,
117: x_msg_data OUT NOCOPY VARCHAR2,
118: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
119: p_application_id IN NUMBER,
120: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
121: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM
123: );
124: --

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

117: x_msg_data OUT NOCOPY VARCHAR2,
118: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
119: p_application_id IN NUMBER,
120: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
121: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM
123: );
124: --
125: -- Algorithm:

Line 122: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM

118: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
119: p_application_id IN NUMBER,
120: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
121: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
122: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM
123: );
124: --
125: -- Algorithm:
126: -- BEGIN

Line 139: -- Default = FND_API.G_FALSE

135: -- Function : sort (sub)category list in ascending or descending order
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_sort_order IN VARCHAR2 Optional
145: -- Default = AMV_CATEGORY_PVT.G_ASC_ORDER

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_sort_order IN VARCHAR2 Optional
145: -- Default = AMV_CATEGORY_PVT.G_ASC_ORDER
146: -- Ascending(ASC) or Descending(DESC) Order.
147: -- p_parent_category_id IN NUMBER Optional

Line 148: -- Default = FND_API.G_MISS_NUM

144: -- p_sort_order IN VARCHAR2 Optional
145: -- Default = AMV_CATEGORY_PVT.G_ASC_ORDER
146: -- Ascending(ASC) or Descending(DESC) Order.
147: -- p_parent_category_id IN NUMBER Optional
148: -- Default = FND_API.G_MISS_NUM
149: -- parent id for sub categories
150: -- OUT NOCOPY : x_return_status OUT NOCOPY VARCHAR2
151: -- x_msg_count OUT NOCOPY NUMBER
152: -- x_msg_data OUT NOCOPY VARCHAR2

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

158: -- End of comments
159: --
160: PROCEDURE Sort_Category
161: ( p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
163: p_commit IN VARCHAR2 := FND_API.G_FALSE,
164: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
165: x_return_status OUT NOCOPY VARCHAR2,
166: x_msg_count OUT NOCOPY NUMBER,

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

159: --
160: PROCEDURE Sort_Category
161: ( p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
163: p_commit IN VARCHAR2 := FND_API.G_FALSE,
164: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
165: x_return_status OUT NOCOPY VARCHAR2,
166: x_msg_count OUT NOCOPY NUMBER,
167: x_msg_data OUT NOCOPY VARCHAR2,

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

160: PROCEDURE Sort_Category
161: ( p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
163: p_commit IN VARCHAR2 := FND_API.G_FALSE,
164: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
165: x_return_status OUT NOCOPY VARCHAR2,
166: x_msg_count OUT NOCOPY NUMBER,
167: x_msg_data OUT NOCOPY VARCHAR2,
168: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

164: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
165: x_return_status OUT NOCOPY VARCHAR2,
166: x_msg_count OUT NOCOPY NUMBER,
167: x_msg_data OUT NOCOPY VARCHAR2,
168: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
169: p_application_id IN NUMBER,
170: p_sort_order IN VARCHAR2 := AMV_CATEGORY_PVT.G_ASC_ORDER,
171: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM
172: );

Line 171: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM

167: x_msg_data OUT NOCOPY VARCHAR2,
168: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
169: p_application_id IN NUMBER,
170: p_sort_order IN VARCHAR2 := AMV_CATEGORY_PVT.G_ASC_ORDER,
171: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM
172: );
173: --
174: -- Algorithm:
175: -- BEGIN

Line 188: -- Default = FND_API.G_FALSE

184: -- Function : Reorder (sub)category list
185: -- Parameters :
186: -- IN p_api_version IN NUMBER Required
187: -- p_init_msg_list IN VARCHAR2 Optional
188: -- Default = FND_API.G_FALSE
189: -- p_commit IN VARCHAR2 Optional
190: -- Default = FND_API.G_FALSE
191: -- p_validation_level NUMBER Optional
192: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 190: -- Default = FND_API.G_FALSE

186: -- IN p_api_version IN NUMBER Required
187: -- p_init_msg_list IN VARCHAR2 Optional
188: -- Default = FND_API.G_FALSE
189: -- p_commit IN VARCHAR2 Optional
190: -- Default = FND_API.G_FALSE
191: -- p_validation_level NUMBER Optional
192: -- Default = FND_API.G_VALID_LEVEL_FULL
193: -- p_category_id_array IN AMV_NUMBER_VARRAY_TYPE
194: -- Required

Line 192: -- Default = FND_API.G_VALID_LEVEL_FULL

188: -- Default = FND_API.G_FALSE
189: -- p_commit IN VARCHAR2 Optional
190: -- Default = FND_API.G_FALSE
191: -- p_validation_level NUMBER Optional
192: -- Default = FND_API.G_VALID_LEVEL_FULL
193: -- p_category_id_array IN AMV_NUMBER_VARRAY_TYPE
194: -- Required
195: -- p_category_new_order IN AMV_NUMBER_VARRAY_TYPE
196: -- Required

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

205: -- End of comments
206: --
207: PROCEDURE Reorder_Category
208: ( p_api_version IN NUMBER,
209: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
210: p_commit IN VARCHAR2 := FND_API.G_FALSE,
211: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,

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

206: --
207: PROCEDURE Reorder_Category
208: ( p_api_version IN NUMBER,
209: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
210: p_commit IN VARCHAR2 := FND_API.G_FALSE,
211: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,
214: x_msg_data OUT NOCOPY VARCHAR2,

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

207: PROCEDURE Reorder_Category
208: ( p_api_version IN NUMBER,
209: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
210: p_commit IN VARCHAR2 := FND_API.G_FALSE,
211: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,
214: x_msg_data OUT NOCOPY VARCHAR2,
215: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

211: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,
214: x_msg_data OUT NOCOPY VARCHAR2,
215: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
216: p_application_id IN NUMBER,
217: p_category_id_array IN AMV_CATEGORY_PVT.AMV_NUMBER_VARRAY_TYPE,
218: p_category_new_order IN AMV_CATEGORY_PVT.AMV_NUMBER_VARRAY_TYPE
219: );

Line 235: -- Default = FND_API.G_FALSE

231: -- Function : Update (sub)category given (sub)category id or name
232: -- Parameters :
233: -- IN p_api_version IN NUMBER Required
234: -- p_init_msg_list IN VARCHAR2 Optional
235: -- Default = FND_API.G_FALSE
236: -- p_commit IN VARCHAR2 Optional
237: -- Default = FND_API.G_FALSE
238: -- p_validation_level IN NUMBER Optional
239: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 237: -- Default = FND_API.G_FALSE

233: -- IN p_api_version IN NUMBER Required
234: -- p_init_msg_list IN VARCHAR2 Optional
235: -- Default = FND_API.G_FALSE
236: -- p_commit IN VARCHAR2 Optional
237: -- Default = FND_API.G_FALSE
238: -- p_validation_level IN NUMBER Optional
239: -- Default = FND_API.G_VALID_LEVEL_FULL
240: -- p_object_version_number IN NUMBER Required
241: -- object version number

Line 239: -- Default = FND_API.G_VALID_LEVEL_FULL

235: -- Default = FND_API.G_FALSE
236: -- p_commit IN VARCHAR2 Optional
237: -- Default = FND_API.G_FALSE
238: -- p_validation_level IN NUMBER Optional
239: -- Default = FND_API.G_VALID_LEVEL_FULL
240: -- p_object_version_number IN NUMBER Required
241: -- object version number
242: -- p_category_id IN NUMBER Required
243: -- channel category id.

Line 248: -- Default = FND_API.G_MISS_NUM

244: -- p_category_name IN VARCHAR2 Optional
245: -- channel category name.
246: -- (sub)category id or name is required
247: -- p_parent_category_id IN NUMBER Optional
248: -- Default = FND_API.G_MISS_NUM
249: -- channel category id.
250: -- p_category_order IN NUMBER Optional
251: -- new channel category order
252: -- p_category_new_name IN VARCHAR2 Optional

Line 255: -- Default = FND_API.G_MISS_CHAR

251: -- new channel category order
252: -- p_category_new_name IN VARCHAR2 Optional
253: -- new channel category name. New name has to be unique
254: -- p_description IN VARCHAR2 Optional
255: -- Default = FND_API.G_MISS_CHAR
256: -- channel category description.
257: -- OUT NOCOPY : x_return_status OUT NOCOPY VARCHAR2
258: -- x_msg_count OUT NOCOPY NUMBER
259: -- x_msg_data OUT NOCOPY VARCHAR2

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

265: -- End of comments
266: --
267: PROCEDURE Update_Category
268: ( p_api_version IN NUMBER,
269: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
270: p_commit IN VARCHAR2 := FND_API.G_FALSE,
271: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
272: x_return_status OUT NOCOPY VARCHAR2,
273: x_msg_count OUT NOCOPY NUMBER,

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

266: --
267: PROCEDURE Update_Category
268: ( p_api_version IN NUMBER,
269: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
270: p_commit IN VARCHAR2 := FND_API.G_FALSE,
271: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
272: x_return_status OUT NOCOPY VARCHAR2,
273: x_msg_count OUT NOCOPY NUMBER,
274: x_msg_data OUT NOCOPY VARCHAR2,

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

267: PROCEDURE Update_Category
268: ( p_api_version IN NUMBER,
269: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
270: p_commit IN VARCHAR2 := FND_API.G_FALSE,
271: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
272: x_return_status OUT NOCOPY VARCHAR2,
273: x_msg_count OUT NOCOPY NUMBER,
274: x_msg_data OUT NOCOPY VARCHAR2,
275: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

271: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
272: x_return_status OUT NOCOPY VARCHAR2,
273: x_msg_count OUT NOCOPY NUMBER,
274: x_msg_data OUT NOCOPY VARCHAR2,
275: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
276: p_object_version_number IN NUMBER,
277: p_application_id IN NUMBER,
278: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
279: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

274: x_msg_data OUT NOCOPY VARCHAR2,
275: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
276: p_object_version_number IN NUMBER,
277: p_application_id IN NUMBER,
278: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
279: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
281: p_category_order IN NUMBER := FND_API.G_MISS_NUM,
282: p_category_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

275: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
276: p_object_version_number IN NUMBER,
277: p_application_id IN NUMBER,
278: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
279: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
281: p_category_order IN NUMBER := FND_API.G_MISS_NUM,
282: p_category_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR

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

276: p_object_version_number IN NUMBER,
277: p_application_id IN NUMBER,
278: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
279: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
281: p_category_order IN NUMBER := FND_API.G_MISS_NUM,
282: p_category_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
284: );

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

277: p_application_id IN NUMBER,
278: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
279: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
281: p_category_order IN NUMBER := FND_API.G_MISS_NUM,
282: p_category_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
284: );
285: --

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

278: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
279: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
281: p_category_order IN NUMBER := FND_API.G_MISS_NUM,
282: p_category_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
284: );
285: --
286: -- Algorithm:

Line 283: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR

279: p_category_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
281: p_category_order IN NUMBER := FND_API.G_MISS_NUM,
282: p_category_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_description IN VARCHAR2 := FND_API.G_MISS_CHAR
284: );
285: --
286: -- Algorithm:
287: -- BEGIN

Line 300: -- Default = FND_API.G_FALSE

296: -- Function : Search and return (sub)categories
297: -- Parameters :
298: -- IN p_api_version IN NUMBER Required
299: -- p_init_msg_list IN VARCHAR2 Optional
300: -- Default = FND_API.G_FALSE
301: -- p_validation_level NUMBER Optional
302: -- Default = FND_API.G_VALID_LEVEL_FULL
303: -- p_application_id IN NUMBER Required
304: -- application creating the channel

Line 302: -- Default = FND_API.G_VALID_LEVEL_FULL

298: -- IN p_api_version IN NUMBER Required
299: -- p_init_msg_list IN VARCHAR2 Optional
300: -- Default = FND_API.G_FALSE
301: -- p_validation_level NUMBER Optional
302: -- Default = FND_API.G_VALID_LEVEL_FULL
303: -- p_application_id IN NUMBER Required
304: -- application creating the channel
305: -- p_category_name IN VARCHAR2 Optional
306: -- Search criteria by name. Default = '%' (everything)

Line 308: -- Default = FND_API.G_MISS_NUM

304: -- application creating the channel
305: -- p_category_name IN VARCHAR2 Optional
306: -- Search criteria by name. Default = '%' (everything)
307: -- p_parent_category_id IN NUMBER Optional
308: -- Default = FND_API.G_MISS_NUM
309: -- parent id for sub categories
310: -- OUT NOCOPY : x_return_status OUT NOCOPY VARCHAR2
311: -- x_msg_count OUT NOCOPY NUMBER
312: -- x_msg_data OUT NOCOPY VARCHAR2

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

319: -- End of comments
320: --
321: PROCEDURE Find_Categories
322: ( p_api_version IN NUMBER,
323: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
324: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
325: x_return_status OUT NOCOPY VARCHAR2,
326: x_msg_count OUT NOCOPY NUMBER,
327: x_msg_data OUT NOCOPY VARCHAR2,

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

320: --
321: PROCEDURE Find_Categories
322: ( p_api_version IN NUMBER,
323: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
324: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
325: x_return_status OUT NOCOPY VARCHAR2,
326: x_msg_count OUT NOCOPY NUMBER,
327: x_msg_data OUT NOCOPY VARCHAR2,
328: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

324: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
325: x_return_status OUT NOCOPY VARCHAR2,
326: x_msg_count OUT NOCOPY NUMBER,
327: x_msg_data OUT NOCOPY VARCHAR2,
328: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
329: p_application_id IN NUMBER,
330: p_category_name IN VARCHAR2 := '%',
331: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
332: p_ignore_hierarchy IN VARCHAR2 := FND_API.G_FALSE,

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

327: x_msg_data OUT NOCOPY VARCHAR2,
328: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
329: p_application_id IN NUMBER,
330: p_category_name IN VARCHAR2 := '%',
331: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
332: p_ignore_hierarchy IN VARCHAR2 := FND_API.G_FALSE,
333: p_request_obj IN AMV_CATEGORY_PVT.AMV_REQUEST_OBJ_TYPE,
334: x_return_obj OUT NOCOPY AMV_CATEGORY_PVT.AMV_RETURN_OBJ_TYPE,
335: x_chan_category_rec_array OUT NOCOPY AMV_CATEGORY_PVT.AMV_CATEGORY_VARRAY_TYPE

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

328: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
329: p_application_id IN NUMBER,
330: p_category_name IN VARCHAR2 := '%',
331: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
332: p_ignore_hierarchy IN VARCHAR2 := FND_API.G_FALSE,
333: p_request_obj IN AMV_CATEGORY_PVT.AMV_REQUEST_OBJ_TYPE,
334: x_return_obj OUT NOCOPY AMV_CATEGORY_PVT.AMV_RETURN_OBJ_TYPE,
335: x_chan_category_rec_array OUT NOCOPY AMV_CATEGORY_PVT.AMV_CATEGORY_VARRAY_TYPE
336: );

Line 351: -- Default = FND_API.G_FALSE

347: -- Function : Return all channels under a (sub)category
348: -- Parameters :
349: -- IN p_api_version IN NUMBER Required
350: -- p_init_msg_list IN VARCHAR2 Optional
351: -- Default = FND_API.G_FALSE
352: -- p_validation_level IN NUMBER Optional
353: -- Default = FND_API.G_VALID_LEVEL_FULL
354: -- p_category_id IN NUMBER Required
355: -- p_include_subcats IN VARCHAR2 Optional

Line 353: -- Default = FND_API.G_VALID_LEVEL_FULL

349: -- IN p_api_version IN NUMBER Required
350: -- p_init_msg_list IN VARCHAR2 Optional
351: -- Default = FND_API.G_FALSE
352: -- p_validation_level IN NUMBER Optional
353: -- Default = FND_API.G_VALID_LEVEL_FULL
354: -- p_category_id IN NUMBER Required
355: -- p_include_subcats IN VARCHAR2 Optional
356: -- Default = FND_API.G_FALSE
357: -- OUT : x_return_status OUT VARCHAR2

Line 356: -- Default = FND_API.G_FALSE

352: -- p_validation_level IN NUMBER Optional
353: -- Default = FND_API.G_VALID_LEVEL_FULL
354: -- p_category_id IN NUMBER Required
355: -- p_include_subcats IN VARCHAR2 Optional
356: -- Default = FND_API.G_FALSE
357: -- OUT : x_return_status OUT VARCHAR2
358: -- x_msg_count OUT NUMBER
359: -- x_msg_data OUT VARCHAR2
360: -- x_content_chan_array OUT AMV_CAT_HIERARCHY_VARRAY_TYPE

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

366: -- End of comments
367: --
368: PROCEDURE Get_ChannelsPerCategory
369: ( p_api_version IN NUMBER,
370: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
371: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
372: x_return_status OUT NOCOPY VARCHAR2,
373: x_msg_count OUT NOCOPY NUMBER,
374: x_msg_data OUT NOCOPY VARCHAR2,

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

367: --
368: PROCEDURE Get_ChannelsPerCategory
369: ( p_api_version IN NUMBER,
370: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
371: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
372: x_return_status OUT NOCOPY VARCHAR2,
373: x_msg_count OUT NOCOPY NUMBER,
374: x_msg_data OUT NOCOPY VARCHAR2,
375: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

371: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
372: x_return_status OUT NOCOPY VARCHAR2,
373: x_msg_count OUT NOCOPY NUMBER,
374: x_msg_data OUT NOCOPY VARCHAR2,
375: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
376: p_category_id IN NUMBER,
377: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
378: x_content_chan_array OUT NOCOPY AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE
379: );

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

373: x_msg_count OUT NOCOPY NUMBER,
374: x_msg_data OUT NOCOPY VARCHAR2,
375: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
376: p_category_id IN NUMBER,
377: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
378: x_content_chan_array OUT NOCOPY AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE
379: );
380: --
381: -- Algorithm:

Line 395: -- Default = FND_API.G_FALSE

391: -- Function : Return category id for a category or subcategory name.
392: -- Parameters :
393: -- IN p_api_version IN NUMBER Required
394: -- p_init_msg_list IN VARCHAR2 Optional
395: -- Default = FND_API.G_FALSE
396: -- p_validation_level IN NUMBER Optional
397: -- Default = FND_API.G_VALID_LEVEL_FULL
398: -- p_category_name IN VARCHAR2 Required
399: -- (sub)category id

Line 397: -- Default = FND_API.G_VALID_LEVEL_FULL

393: -- IN p_api_version IN NUMBER Required
394: -- p_init_msg_list IN VARCHAR2 Optional
395: -- Default = FND_API.G_FALSE
396: -- p_validation_level IN NUMBER Optional
397: -- Default = FND_API.G_VALID_LEVEL_FULL
398: -- p_category_name IN VARCHAR2 Required
399: -- (sub)category id
400: -- p_parent_category_id IN NUMBER Optional
401: -- Default = FND_API.G_MISS_NUM

Line 401: -- Default = FND_API.G_MISS_NUM

397: -- Default = FND_API.G_VALID_LEVEL_FULL
398: -- p_category_name IN VARCHAR2 Required
399: -- (sub)category id
400: -- p_parent_category_id IN NUMBER Optional
401: -- Default = FND_API.G_MISS_NUM
402: -- parent category id
403: -- OUT : x_return_status OUT VARCHAR2
404: -- x_msg_count OUT NUMBER
405: -- x_msg_data OUT VARCHAR2

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

412: --
413: --
414: PROCEDURE Fetch_CategoryId
415: ( p_api_version IN NUMBER,
416: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
417: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
418: x_return_status OUT NOCOPY VARCHAR2,
419: x_msg_count OUT NOCOPY NUMBER,
420: x_msg_data OUT NOCOPY VARCHAR2,

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

413: --
414: PROCEDURE Fetch_CategoryId
415: ( p_api_version IN NUMBER,
416: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
417: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
418: x_return_status OUT NOCOPY VARCHAR2,
419: x_msg_count OUT NOCOPY NUMBER,
420: x_msg_data OUT NOCOPY VARCHAR2,
421: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

417: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
418: x_return_status OUT NOCOPY VARCHAR2,
419: x_msg_count OUT NOCOPY NUMBER,
420: x_msg_data OUT NOCOPY VARCHAR2,
421: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
422: p_application_id IN NUMBER,
423: p_category_name IN VARCHAR2,
424: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
425: x_category_id OUT NOCOPY NUMBER

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

420: x_msg_data OUT NOCOPY VARCHAR2,
421: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
422: p_application_id IN NUMBER,
423: p_category_name IN VARCHAR2,
424: p_parent_category_id IN NUMBER := FND_API.G_MISS_NUM,
425: x_category_id OUT NOCOPY NUMBER
426: );
427: -- Algorithm:
428: -- BEGIN

Line 443: -- Default = FND_API.G_FALSE

439: -- for a category id.
440: -- Parameters :
441: -- IN p_api_version IN NUMBER Required
442: -- p_init_msg_list IN VARCHAR2 Optional
443: -- Default = FND_API.G_FALSE
444: -- p_validation_level IN NUMBER Optional
445: -- Default = FND_API.G_VALID_LEVEL_FULL
446: -- p_category_id IN NUMBER Required
447: -- (sub)category id

Line 445: -- Default = FND_API.G_VALID_LEVEL_FULL

441: -- IN p_api_version IN NUMBER Required
442: -- p_init_msg_list IN VARCHAR2 Optional
443: -- Default = FND_API.G_FALSE
444: -- p_validation_level IN NUMBER Optional
445: -- Default = FND_API.G_VALID_LEVEL_FULL
446: -- p_category_id IN NUMBER Required
447: -- (sub)category id
448: -- OUT : x_return_status OUT VARCHAR2
449: -- x_msg_count OUT NUMBER

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

457: --
458: --
459: PROCEDURE Get_CatParentsHierarchy
460: ( p_api_version IN NUMBER,
461: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
462: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
463: x_return_status OUT NOCOPY VARCHAR2,
464: x_msg_count OUT NOCOPY NUMBER,
465: x_msg_data OUT NOCOPY VARCHAR2,

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

458: --
459: PROCEDURE Get_CatParentsHierarchy
460: ( p_api_version IN NUMBER,
461: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
462: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
463: x_return_status OUT NOCOPY VARCHAR2,
464: x_msg_count OUT NOCOPY NUMBER,
465: x_msg_data OUT NOCOPY VARCHAR2,
466: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

462: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
463: x_return_status OUT NOCOPY VARCHAR2,
464: x_msg_count OUT NOCOPY NUMBER,
465: x_msg_data OUT NOCOPY VARCHAR2,
466: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
467: p_category_id IN NUMBER,
468: x_category_hierarchy OUT NOCOPY AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE
469: );
470: -- Algorithm:

Line 486: -- Default = FND_API.G_FALSE

482: -- for a category id.
483: -- Parameters :
484: -- IN p_api_version IN NUMBER Required
485: -- p_init_msg_list IN VARCHAR2 Optional
486: -- Default = FND_API.G_FALSE
487: -- p_validation_level IN NUMBER Optional
488: -- Default = FND_API.G_VALID_LEVEL_FULL
489: -- p_category_id IN NUMBER Required
490: -- (sub)category id

Line 488: -- Default = FND_API.G_VALID_LEVEL_FULL

484: -- IN p_api_version IN NUMBER Required
485: -- p_init_msg_list IN VARCHAR2 Optional
486: -- Default = FND_API.G_FALSE
487: -- p_validation_level IN NUMBER Optional
488: -- Default = FND_API.G_VALID_LEVEL_FULL
489: -- p_category_id IN NUMBER Required
490: -- (sub)category id
491: -- OUT : x_return_status OUT VARCHAR2
492: -- x_msg_count OUT NUMBER

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

500: --
501: --
502: PROCEDURE Get_CatChildrenHierarchy
503: ( p_api_version IN NUMBER,
504: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
505: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
506: x_return_status OUT NOCOPY VARCHAR2,
507: x_msg_count OUT NOCOPY NUMBER,
508: x_msg_data OUT NOCOPY VARCHAR2,

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

501: --
502: PROCEDURE Get_CatChildrenHierarchy
503: ( p_api_version IN NUMBER,
504: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
505: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
506: x_return_status OUT NOCOPY VARCHAR2,
507: x_msg_count OUT NOCOPY NUMBER,
508: x_msg_data OUT NOCOPY VARCHAR2,
509: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

505: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
506: x_return_status OUT NOCOPY VARCHAR2,
507: x_msg_count OUT NOCOPY NUMBER,
508: x_msg_data OUT NOCOPY VARCHAR2,
509: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
510: p_category_id IN NUMBER,
511: x_category_hierarchy OUT NOCOPY AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE
512: );
513: -- Algorithm:

Line 529: -- Default = FND_API.G_FALSE

525: -- for a channel id.
526: -- Parameters :
527: -- IN p_api_version IN NUMBER Required
528: -- p_init_msg_list IN VARCHAR2 Optional
529: -- Default = FND_API.G_FALSE
530: -- p_validation_level IN NUMBER Optional
531: -- Default = FND_API.G_VALID_LEVEL_FULL
532: -- p_channel_id IN NUMBER Required
533: -- channel id

Line 531: -- Default = FND_API.G_VALID_LEVEL_FULL

527: -- IN p_api_version IN NUMBER Required
528: -- p_init_msg_list IN VARCHAR2 Optional
529: -- Default = FND_API.G_FALSE
530: -- p_validation_level IN NUMBER Optional
531: -- Default = FND_API.G_VALID_LEVEL_FULL
532: -- p_channel_id IN NUMBER Required
533: -- channel id
534: -- OUT : x_return_status OUT VARCHAR2
535: -- x_msg_count OUT NUMBER

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

544: --
545: --
546: PROCEDURE Get_ChnCategoryHierarchy
547: ( p_api_version IN NUMBER,
548: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
549: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
550: x_return_status OUT NOCOPY VARCHAR2,
551: x_msg_count OUT NOCOPY NUMBER,
552: x_msg_data OUT NOCOPY VARCHAR2,

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

545: --
546: PROCEDURE Get_ChnCategoryHierarchy
547: ( p_api_version IN NUMBER,
548: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
549: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
550: x_return_status OUT NOCOPY VARCHAR2,
551: x_msg_count OUT NOCOPY NUMBER,
552: x_msg_data OUT NOCOPY VARCHAR2,
553: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

549: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
550: x_return_status OUT NOCOPY VARCHAR2,
551: x_msg_count OUT NOCOPY NUMBER,
552: x_msg_data OUT NOCOPY VARCHAR2,
553: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
554: p_channel_id IN NUMBER,
555: x_channel_name OUT NOCOPY VARCHAR2,
556: x_category_hierarchy OUT NOCOPY AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE
557: );

Line 572: -- Default = FND_API.G_FALSE

568: -- a content channel (sub)category
569: -- Parameters :
570: -- IN p_api_version IN NUMBER Required
571: -- p_init_msg_list IN VARCHAR2 Optional
572: -- Default = FND_API.G_FALSE
573: -- p_validation_level IN NUMBER Optional
574: -- Default = FND_API.G_VALID_LEVEL_FULL
575: -- p_category_id IN NUMBER Required
576: -- p_include_subcats IN VARCHAR2 Optional

Line 574: -- Default = FND_API.G_VALID_LEVEL_FULL

570: -- IN p_api_version IN NUMBER Required
571: -- p_init_msg_list IN VARCHAR2 Optional
572: -- Default = FND_API.G_FALSE
573: -- p_validation_level IN NUMBER Optional
574: -- Default = FND_API.G_VALID_LEVEL_FULL
575: -- p_category_id IN NUMBER Required
576: -- p_include_subcats IN VARCHAR2 Optional
577: -- Default = FND_API.G_FALSE
578: -- OUT : x_return_status OUT VARCHAR2

Line 577: -- Default = FND_API.G_FALSE

573: -- p_validation_level IN NUMBER Optional
574: -- Default = FND_API.G_VALID_LEVEL_FULL
575: -- p_category_id IN NUMBER Required
576: -- p_include_subcats IN VARCHAR2 Optional
577: -- Default = FND_API.G_FALSE
578: -- OUT : x_return_status OUT VARCHAR2
579: -- x_msg_count OUT NUMBER
580: -- x_msg_data OUT VARCHAR2
581: -- x_items_array OUT AMV_CAT_HIERARCHY_VARRAY_TYPE

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

587: -- End of comments
588: --
589: PROCEDURE Get_ItemsPerCategory
590: ( p_api_version IN NUMBER,
591: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
592: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
593: x_return_status OUT NOCOPY VARCHAR2,
594: x_msg_count OUT NOCOPY NUMBER,
595: x_msg_data OUT NOCOPY VARCHAR2,

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

588: --
589: PROCEDURE Get_ItemsPerCategory
590: ( p_api_version IN NUMBER,
591: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
592: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
593: x_return_status OUT NOCOPY VARCHAR2,
594: x_msg_count OUT NOCOPY NUMBER,
595: x_msg_data OUT NOCOPY VARCHAR2,
596: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

592: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
593: x_return_status OUT NOCOPY VARCHAR2,
594: x_msg_count OUT NOCOPY NUMBER,
595: x_msg_data OUT NOCOPY VARCHAR2,
596: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
597: p_category_id IN NUMBER,
598: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
599: p_request_obj IN AMV_CATEGORY_PVT.AMV_REQUEST_OBJ_TYPE,
600: p_category_sort IN AMV_CATEGORY_PVT.AMV_SORT_OBJ_TYPE,

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

594: x_msg_count OUT NOCOPY NUMBER,
595: x_msg_data OUT NOCOPY VARCHAR2,
596: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
597: p_category_id IN NUMBER,
598: p_include_subcats IN VARCHAR2 := FND_API.G_FALSE,
599: p_request_obj IN AMV_CATEGORY_PVT.AMV_REQUEST_OBJ_TYPE,
600: p_category_sort IN AMV_CATEGORY_PVT.AMV_SORT_OBJ_TYPE,
601: x_return_obj OUT NOCOPY AMV_CATEGORY_PVT.AMV_RETURN_OBJ_TYPE,
602: x_items_array OUT NOCOPY AMV_CATEGORY_PVT.AMV_CAT_HIERARCHY_VARRAY_TYPE

Line 619: -- Default = FND_API.G_FALSE

615: -- Function : attaches a category to a parent category
616: -- Parameters :
617: -- IN p_api_version IN NUMBER Required
618: -- p_init_msg_list IN VARCHAR2 Optional
619: -- Default = FND_API.G_FALSE
620: -- p_validation_level IN NUMBER Optional
621: -- Default = FND_API.G_VALID_LEVEL_FULL
622: -- p_category_id IN NUMBER Required
623: -- category id

Line 621: -- Default = FND_API.G_VALID_LEVEL_FULL

617: -- IN p_api_version IN NUMBER Required
618: -- p_init_msg_list IN VARCHAR2 Optional
619: -- Default = FND_API.G_FALSE
620: -- p_validation_level IN NUMBER Optional
621: -- Default = FND_API.G_VALID_LEVEL_FULL
622: -- p_category_id IN NUMBER Required
623: -- category id
624: -- p_parent_category_id IN NUMBER Required
625: -- parent category id

Line 627: -- Default = FND_API.G_FALSE

623: -- category id
624: -- p_parent_category_id IN NUMBER Required
625: -- parent category id
626: -- p_replace_existing IN VARCHAR2 Optional
627: -- Default = FND_API.G_FALSE
628: -- OUT : x_return_status OUT VARCHAR2
629: -- x_msg_count OUT NUMBER
630: -- x_msg_data OUT VARCHAR2
631: -- Version : Current version 1.0

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

636: --
637: --
638: PROCEDURE Add_CategoryParent
639: ( p_api_version IN NUMBER,
640: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
641: p_commit IN VARCHAR2 := FND_API.G_FALSE,
642: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
643: x_return_status OUT NOCOPY VARCHAR2,
644: x_msg_count OUT NOCOPY NUMBER,

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

637: --
638: PROCEDURE Add_CategoryParent
639: ( p_api_version IN NUMBER,
640: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
641: p_commit IN VARCHAR2 := FND_API.G_FALSE,
642: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
643: x_return_status OUT NOCOPY VARCHAR2,
644: x_msg_count OUT NOCOPY NUMBER,
645: x_msg_data OUT NOCOPY VARCHAR2,

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

638: PROCEDURE Add_CategoryParent
639: ( p_api_version IN NUMBER,
640: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
641: p_commit IN VARCHAR2 := FND_API.G_FALSE,
642: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
643: x_return_status OUT NOCOPY VARCHAR2,
644: x_msg_count OUT NOCOPY NUMBER,
645: x_msg_data OUT NOCOPY VARCHAR2,
646: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

642: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
643: x_return_status OUT NOCOPY VARCHAR2,
644: x_msg_count OUT NOCOPY NUMBER,
645: x_msg_data OUT NOCOPY VARCHAR2,
646: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
647: p_object_version_number IN NUMBER,
648: p_category_id IN NUMBER,
649: p_parent_category_id IN NUMBER,
650: p_replace_existing IN VARCHAR2 := FND_API.G_FALSE

Line 650: p_replace_existing IN VARCHAR2 := FND_API.G_FALSE

646: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
647: p_object_version_number IN NUMBER,
648: p_category_id IN NUMBER,
649: p_parent_category_id IN NUMBER,
650: p_replace_existing IN VARCHAR2 := FND_API.G_FALSE
651: );
652: -- Algorithm:
653: -- BEGIN
654: -- ...

Line 667: -- Default = FND_API.G_FALSE

663: -- Function : removes a category from a parent category
664: -- Parameters :
665: -- IN p_api_version IN NUMBER Required
666: -- p_init_msg_list IN VARCHAR2 Optional
667: -- Default = FND_API.G_FALSE
668: -- p_validation_level IN NUMBER Optional
669: -- Default = FND_API.G_VALID_LEVEL_FULL
670: -- p_category_id IN NUMBER Required
671: -- category id

Line 669: -- Default = FND_API.G_VALID_LEVEL_FULL

665: -- IN p_api_version IN NUMBER Required
666: -- p_init_msg_list IN VARCHAR2 Optional
667: -- Default = FND_API.G_FALSE
668: -- p_validation_level IN NUMBER Optional
669: -- Default = FND_API.G_VALID_LEVEL_FULL
670: -- p_category_id IN NUMBER Required
671: -- category id
672: -- OUT : x_return_status OUT VARCHAR2
673: -- x_msg_count OUT NUMBER

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

680: --
681: --
682: PROCEDURE Remove_CategoryParent
683: ( p_api_version IN NUMBER,
684: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
685: p_commit IN VARCHAR2 := FND_API.G_FALSE,
686: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
687: x_return_status OUT NOCOPY VARCHAR2,
688: x_msg_count OUT NOCOPY NUMBER,

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

681: --
682: PROCEDURE Remove_CategoryParent
683: ( p_api_version IN NUMBER,
684: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
685: p_commit IN VARCHAR2 := FND_API.G_FALSE,
686: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
687: x_return_status OUT NOCOPY VARCHAR2,
688: x_msg_count OUT NOCOPY NUMBER,
689: x_msg_data OUT NOCOPY VARCHAR2,

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

682: PROCEDURE Remove_CategoryParent
683: ( p_api_version IN NUMBER,
684: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
685: p_commit IN VARCHAR2 := FND_API.G_FALSE,
686: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
687: x_return_status OUT NOCOPY VARCHAR2,
688: x_msg_count OUT NOCOPY NUMBER,
689: x_msg_data OUT NOCOPY VARCHAR2,
690: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

686: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
687: x_return_status OUT NOCOPY VARCHAR2,
688: x_msg_count OUT NOCOPY NUMBER,
689: x_msg_data OUT NOCOPY VARCHAR2,
690: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
691: p_object_version_number IN NUMBER,
692: p_category_id IN NUMBER
693: );
694: -- Algorithm: