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

Line 69: -- Default = FND_API.G_FALSE

65: -- to match channels with the passed item.
66: -- Parameters :
67: -- IN p_api_version NUMBER Required
68: -- p_init_msg_list VARCHAR2 Optional
69: -- Default = FND_API.G_FALSE
70: -- p_commit VARCHAR2 Optional
71: -- Default = FND_API.G_FALSE
72: -- p_validation_level NUMBER Optional
73: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 71: -- Default = FND_API.G_FALSE

67: -- IN p_api_version NUMBER Required
68: -- p_init_msg_list VARCHAR2 Optional
69: -- Default = FND_API.G_FALSE
70: -- p_commit VARCHAR2 Optional
71: -- Default = FND_API.G_FALSE
72: -- p_validation_level NUMBER Optional
73: -- Default = FND_API.G_VALID_LEVEL_FULL
74: -- p_check_login_user VARCHAR2 Optional
75: -- Default = FND_API.G_TRUE

Line 73: -- Default = FND_API.G_VALID_LEVEL_FULL

69: -- Default = FND_API.G_FALSE
70: -- p_commit VARCHAR2 Optional
71: -- Default = FND_API.G_FALSE
72: -- p_validation_level NUMBER Optional
73: -- Default = FND_API.G_VALID_LEVEL_FULL
74: -- p_check_login_user VARCHAR2 Optional
75: -- Default = FND_API.G_TRUE
76: -- Flag for checking user privilege and if user is login.
77: -- p_item_id NUMBER Required

Line 75: -- Default = FND_API.G_TRUE

71: -- Default = FND_API.G_FALSE
72: -- p_validation_level NUMBER Optional
73: -- Default = FND_API.G_VALID_LEVEL_FULL
74: -- p_check_login_user VARCHAR2 Optional
75: -- Default = FND_API.G_TRUE
76: -- Flag for checking user privilege and if user is login.
77: -- p_item_id NUMBER Required
78: -- the id of the item to be matched with channels.
79: -- OUT : x_return_status VARCHAR2

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

85: --
86: PROCEDURE Request_ItemMatch
87: (
88: p_api_version IN NUMBER,
89: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
90: p_commit IN VARCHAR2 := FND_API.G_FALSE,
91: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92: x_return_status OUT NOCOPY VARCHAR2,
93: x_msg_count OUT NOCOPY NUMBER,

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

86: PROCEDURE Request_ItemMatch
87: (
88: p_api_version IN NUMBER,
89: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
90: p_commit IN VARCHAR2 := FND_API.G_FALSE,
91: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92: x_return_status OUT NOCOPY VARCHAR2,
93: x_msg_count OUT NOCOPY NUMBER,
94: x_msg_data OUT NOCOPY VARCHAR2,

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

87: (
88: p_api_version IN NUMBER,
89: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
90: p_commit IN VARCHAR2 := FND_API.G_FALSE,
91: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92: x_return_status OUT NOCOPY VARCHAR2,
93: x_msg_count OUT NOCOPY NUMBER,
94: x_msg_data OUT NOCOPY VARCHAR2,
95: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

91: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92: x_return_status OUT NOCOPY VARCHAR2,
93: x_msg_count OUT NOCOPY NUMBER,
94: x_msg_data OUT NOCOPY VARCHAR2,
95: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
96: p_item_id IN NUMBER
97: );
98: --
99: -- Algorithm:

Line 112: -- Default = FND_API.G_FALSE

108: -- to match items with the passed channel.
109: -- Parameters :
110: -- IN p_api_version NUMBER Required
111: -- p_init_msg_list VARCHAR2 Optional
112: -- Default = FND_API.G_FALSE
113: -- p_commit VARCHAR2 Optional
114: -- Default = FND_API.G_FALSE
115: -- p_validation_level NUMBER Optional
116: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 114: -- Default = FND_API.G_FALSE

110: -- IN p_api_version NUMBER Required
111: -- p_init_msg_list VARCHAR2 Optional
112: -- Default = FND_API.G_FALSE
113: -- p_commit VARCHAR2 Optional
114: -- Default = FND_API.G_FALSE
115: -- p_validation_level NUMBER Optional
116: -- Default = FND_API.G_VALID_LEVEL_FULL
117: -- p_check_login_user VARCHAR2 Optional
118: -- Default = FND_API.G_TRUE

Line 116: -- Default = FND_API.G_VALID_LEVEL_FULL

112: -- Default = FND_API.G_FALSE
113: -- p_commit VARCHAR2 Optional
114: -- Default = FND_API.G_FALSE
115: -- p_validation_level NUMBER Optional
116: -- Default = FND_API.G_VALID_LEVEL_FULL
117: -- p_check_login_user VARCHAR2 Optional
118: -- Default = FND_API.G_TRUE
119: -- Flag for checking user privilege and if user is login.
120: -- p_channel_id NUMBER Required

Line 118: -- Default = FND_API.G_TRUE

114: -- Default = FND_API.G_FALSE
115: -- p_validation_level NUMBER Optional
116: -- Default = FND_API.G_VALID_LEVEL_FULL
117: -- p_check_login_user VARCHAR2 Optional
118: -- Default = FND_API.G_TRUE
119: -- Flag for checking user privilege and if user is login.
120: -- p_channel_id NUMBER Required
121: -- the id of the channel to be matched with items.
122: -- OUT : x_return_status VARCHAR2

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

128: --
129: PROCEDURE Request_ChannelMatch
130: (
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
133: p_commit IN VARCHAR2 := FND_API.G_FALSE,
134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135: x_return_status OUT NOCOPY VARCHAR2,
136: x_msg_count OUT NOCOPY NUMBER,

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

129: PROCEDURE Request_ChannelMatch
130: (
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
133: p_commit IN VARCHAR2 := FND_API.G_FALSE,
134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135: x_return_status OUT NOCOPY VARCHAR2,
136: x_msg_count OUT NOCOPY NUMBER,
137: x_msg_data OUT NOCOPY VARCHAR2,

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

130: (
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
133: p_commit IN VARCHAR2 := FND_API.G_FALSE,
134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135: x_return_status OUT NOCOPY VARCHAR2,
136: x_msg_count OUT NOCOPY NUMBER,
137: x_msg_data OUT NOCOPY VARCHAR2,
138: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

134: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
135: x_return_status OUT NOCOPY VARCHAR2,
136: x_msg_count OUT NOCOPY NUMBER,
137: x_msg_data OUT NOCOPY VARCHAR2,
138: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
139: p_channel_id IN NUMBER
140: );
141: --
142: -- Algorithm:

Line 157: -- Default = FND_API.G_FALSE

153: -- provide a way to stop the engine.
154: -- Parameters :
155: -- IN p_api_version NUMBER Required
156: -- p_init_msg_list VARCHAR2 Optional
157: -- Default = FND_API.G_FALSE
158: -- p_commit VARCHAR2 Optional
159: -- Default = FND_API.G_FALSE
160: -- p_validation_level NUMBER Optional
161: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 159: -- Default = FND_API.G_FALSE

155: -- IN p_api_version NUMBER Required
156: -- p_init_msg_list VARCHAR2 Optional
157: -- Default = FND_API.G_FALSE
158: -- p_commit VARCHAR2 Optional
159: -- Default = FND_API.G_FALSE
160: -- p_validation_level NUMBER Optional
161: -- Default = FND_API.G_VALID_LEVEL_FULL
162: -- p_check_login_user VARCHAR2 Optional
163: -- Default = FND_API.G_TRUE

Line 161: -- Default = FND_API.G_VALID_LEVEL_FULL

157: -- Default = FND_API.G_FALSE
158: -- p_commit VARCHAR2 Optional
159: -- Default = FND_API.G_FALSE
160: -- p_validation_level NUMBER Optional
161: -- Default = FND_API.G_VALID_LEVEL_FULL
162: -- p_check_login_user VARCHAR2 Optional
163: -- Default = FND_API.G_TRUE
164: -- Flag for checking user privilege and if user is login.
165: -- OUT : x_return_status VARCHAR2

Line 163: -- Default = FND_API.G_TRUE

159: -- Default = FND_API.G_FALSE
160: -- p_validation_level NUMBER Optional
161: -- Default = FND_API.G_VALID_LEVEL_FULL
162: -- p_check_login_user VARCHAR2 Optional
163: -- Default = FND_API.G_TRUE
164: -- Flag for checking user privilege and if user is login.
165: -- OUT : x_return_status VARCHAR2
166: -- x_msg_count NUMBER
167: -- x_msg_data VARCHAR2

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

171: --
172: PROCEDURE Stop_MatchingEngine
173: (
174: p_api_version IN NUMBER,
175: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
176: p_commit IN VARCHAR2 := FND_API.G_FALSE,
177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
178: x_return_status OUT NOCOPY VARCHAR2,
179: x_msg_count OUT NOCOPY NUMBER,

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

172: PROCEDURE Stop_MatchingEngine
173: (
174: p_api_version IN NUMBER,
175: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
176: p_commit IN VARCHAR2 := FND_API.G_FALSE,
177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
178: x_return_status OUT NOCOPY VARCHAR2,
179: x_msg_count OUT NOCOPY NUMBER,
180: x_msg_data OUT NOCOPY VARCHAR2,

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

173: (
174: p_api_version IN NUMBER,
175: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
176: p_commit IN VARCHAR2 := FND_API.G_FALSE,
177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
178: x_return_status OUT NOCOPY VARCHAR2,
179: x_msg_count OUT NOCOPY NUMBER,
180: x_msg_data OUT NOCOPY VARCHAR2,
181: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE

Line 181: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE

177: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
178: x_return_status OUT NOCOPY VARCHAR2,
179: x_msg_count OUT NOCOPY NUMBER,
180: x_msg_data OUT NOCOPY VARCHAR2,
181: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE
182: );
183: --
184: --------------------------------------------------------------------------------
185: -- Start of comments

Line 218: -- Default = FND_API.G_FALSE

214: -- and do the matching, process approval.
215: -- Parameters :
216: -- IN p_api_version NUMBER Required
217: -- p_init_msg_list VARCHAR2 Optional
218: -- Default = FND_API.G_FALSE
219: -- p_commit VARCHAR2 Optional
220: -- Default = FND_API.G_FALSE
221: -- p_validation_level NUMBER Optional
222: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 220: -- Default = FND_API.G_FALSE

216: -- IN p_api_version NUMBER Required
217: -- p_init_msg_list VARCHAR2 Optional
218: -- Default = FND_API.G_FALSE
219: -- p_commit VARCHAR2 Optional
220: -- Default = FND_API.G_FALSE
221: -- p_validation_level NUMBER Optional
222: -- Default = FND_API.G_VALID_LEVEL_FULL
223: -- p_check_login_user VARCHAR2 Optional
224: -- Default = FND_API.G_TRUE

Line 222: -- Default = FND_API.G_VALID_LEVEL_FULL

218: -- Default = FND_API.G_FALSE
219: -- p_commit VARCHAR2 Optional
220: -- Default = FND_API.G_FALSE
221: -- p_validation_level NUMBER Optional
222: -- Default = FND_API.G_VALID_LEVEL_FULL
223: -- p_check_login_user VARCHAR2 Optional
224: -- Default = FND_API.G_TRUE
225: -- Flag for checking user privilege and if user is login.
226: -- p_item_id NUMBER Required

Line 224: -- Default = FND_API.G_TRUE

220: -- Default = FND_API.G_FALSE
221: -- p_validation_level NUMBER Optional
222: -- Default = FND_API.G_VALID_LEVEL_FULL
223: -- p_check_login_user VARCHAR2 Optional
224: -- Default = FND_API.G_TRUE
225: -- Flag for checking user privilege and if user is login.
226: -- p_item_id NUMBER Required
227: -- the id of the item to be matched with channels.
228: -- OUT : x_return_status VARCHAR2

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

234: --
235: PROCEDURE Match_ItemWithChannels
236: (
237: p_api_version IN NUMBER,
238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239: p_commit IN VARCHAR2 := FND_API.G_FALSE,
240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241: x_return_status OUT NOCOPY VARCHAR2,
242: x_msg_count OUT NOCOPY NUMBER,

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

235: PROCEDURE Match_ItemWithChannels
236: (
237: p_api_version IN NUMBER,
238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239: p_commit IN VARCHAR2 := FND_API.G_FALSE,
240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241: x_return_status OUT NOCOPY VARCHAR2,
242: x_msg_count OUT NOCOPY NUMBER,
243: x_msg_data OUT NOCOPY VARCHAR2,

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

236: (
237: p_api_version IN NUMBER,
238: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
239: p_commit IN VARCHAR2 := FND_API.G_FALSE,
240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241: x_return_status OUT NOCOPY VARCHAR2,
242: x_msg_count OUT NOCOPY NUMBER,
243: x_msg_data OUT NOCOPY VARCHAR2,
244: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
241: x_return_status OUT NOCOPY VARCHAR2,
242: x_msg_count OUT NOCOPY NUMBER,
243: x_msg_data OUT NOCOPY VARCHAR2,
244: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
245: p_item_id IN NUMBER
246: );
247: --
248: -- Algorithm:

Line 272: -- Default = FND_API.G_FALSE

268: -- and do the matching, process approval....
269: -- Parameters :
270: -- IN p_api_version NUMBER Required
271: -- p_init_msg_list VARCHAR2 Optional
272: -- Default = FND_API.G_FALSE
273: -- p_commit VARCHAR2 Optional
274: -- Default = FND_API.G_FALSE
275: -- p_validation_level NUMBER Optional
276: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 274: -- Default = FND_API.G_FALSE

270: -- IN p_api_version NUMBER Required
271: -- p_init_msg_list VARCHAR2 Optional
272: -- Default = FND_API.G_FALSE
273: -- p_commit VARCHAR2 Optional
274: -- Default = FND_API.G_FALSE
275: -- p_validation_level NUMBER Optional
276: -- Default = FND_API.G_VALID_LEVEL_FULL
277: -- p_check_login_user VARCHAR2 Optional
278: -- Default = FND_API.G_TRUE

Line 276: -- Default = FND_API.G_VALID_LEVEL_FULL

272: -- Default = FND_API.G_FALSE
273: -- p_commit VARCHAR2 Optional
274: -- Default = FND_API.G_FALSE
275: -- p_validation_level NUMBER Optional
276: -- Default = FND_API.G_VALID_LEVEL_FULL
277: -- p_check_login_user VARCHAR2 Optional
278: -- Default = FND_API.G_TRUE
279: -- Flag for checking user privilege and if user is login.
280: -- p_channel_id NUMBER Required

Line 278: -- Default = FND_API.G_TRUE

274: -- Default = FND_API.G_FALSE
275: -- p_validation_level NUMBER Optional
276: -- Default = FND_API.G_VALID_LEVEL_FULL
277: -- p_check_login_user VARCHAR2 Optional
278: -- Default = FND_API.G_TRUE
279: -- Flag for checking user privilege and if user is login.
280: -- p_channel_id NUMBER Required
281: -- the id of the channel to be matched with items.
282: -- OUT : x_return_status VARCHAR2

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

288: --
289: PROCEDURE Match_ChannelWithItems
290: (
291: p_api_version IN NUMBER,
292: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
293: p_commit IN VARCHAR2 := FND_API.G_FALSE,
294: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
295: x_return_status OUT NOCOPY VARCHAR2,
296: x_msg_count OUT NOCOPY NUMBER,

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

289: PROCEDURE Match_ChannelWithItems
290: (
291: p_api_version IN NUMBER,
292: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
293: p_commit IN VARCHAR2 := FND_API.G_FALSE,
294: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
295: x_return_status OUT NOCOPY VARCHAR2,
296: x_msg_count OUT NOCOPY NUMBER,
297: x_msg_data OUT NOCOPY VARCHAR2,

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

290: (
291: p_api_version IN NUMBER,
292: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
293: p_commit IN VARCHAR2 := FND_API.G_FALSE,
294: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
295: x_return_status OUT NOCOPY VARCHAR2,
296: x_msg_count OUT NOCOPY NUMBER,
297: x_msg_data OUT NOCOPY VARCHAR2,
298: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

294: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
295: x_return_status OUT NOCOPY VARCHAR2,
296: x_msg_count OUT NOCOPY NUMBER,
297: x_msg_data OUT NOCOPY VARCHAR2,
298: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
299: p_channel_id IN NUMBER
300: );
301: --
302: -- Algorithm:

Line 325: -- Default = FND_API.G_FALSE

321: -- has the match. If so, also return the approval status.
322: -- Parameters :
323: -- IN p_api_version NUMBER Required
324: -- p_init_msg_list VARCHAR2 Optional
325: -- Default = FND_API.G_FALSE
326: -- p_validation_level NUMBER Optional
327: -- Default = FND_API.G_VALID_LEVEL_FULL
328: -- p_check_login_user VARCHAR2 Optional
329: -- Default = FND_API.G_TRUE

Line 327: -- Default = FND_API.G_VALID_LEVEL_FULL

323: -- IN p_api_version NUMBER Required
324: -- p_init_msg_list VARCHAR2 Optional
325: -- Default = FND_API.G_FALSE
326: -- p_validation_level NUMBER Optional
327: -- Default = FND_API.G_VALID_LEVEL_FULL
328: -- p_check_login_user VARCHAR2 Optional
329: -- Default = FND_API.G_TRUE
330: -- Flag for checking user privilege and if user is login.
331: -- p_channel_id NUMBER Required

Line 329: -- Default = FND_API.G_TRUE

325: -- Default = FND_API.G_FALSE
326: -- p_validation_level NUMBER Optional
327: -- Default = FND_API.G_VALID_LEVEL_FULL
328: -- p_check_login_user VARCHAR2 Optional
329: -- Default = FND_API.G_TRUE
330: -- Flag for checking user privilege and if user is login.
331: -- p_channel_id NUMBER Required
332: -- the id of the channel to be matched.
333: -- p_item_id NUMBER Required

Line 340: -- return FND_API.G_TRUE if exists,

336: -- x_msg_count NUMBER
337: -- x_msg_data VARCHAR2
338: -- x_match_exist_flag VARCHAR2
339: -- the flag of existence of the match.
340: -- return FND_API.G_TRUE if exists,
341: -- Otherwise return FND_API.G_FALSE.
342: -- x_approval_status VARCHAR2
343: -- return the approval status if the match exists.
344: -- Notes :

Line 341: -- Otherwise return FND_API.G_FALSE.

337: -- x_msg_data VARCHAR2
338: -- x_match_exist_flag VARCHAR2
339: -- the flag of existence of the match.
340: -- return FND_API.G_TRUE if exists,
341: -- Otherwise return FND_API.G_FALSE.
342: -- x_approval_status VARCHAR2
343: -- return the approval status if the match exists.
344: -- Notes :
345: --

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

347: --
348: PROCEDURE Check_ExistItemChlMatch
349: (
350: p_api_version IN NUMBER,
351: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
352: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
353: x_return_status OUT NOCOPY VARCHAR2,
354: x_msg_count OUT NOCOPY NUMBER,
355: x_msg_data OUT NOCOPY VARCHAR2,

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

348: PROCEDURE Check_ExistItemChlMatch
349: (
350: p_api_version IN NUMBER,
351: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
352: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
353: x_return_status OUT NOCOPY VARCHAR2,
354: x_msg_count OUT NOCOPY NUMBER,
355: x_msg_data OUT NOCOPY VARCHAR2,
356: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

352: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
353: x_return_status OUT NOCOPY VARCHAR2,
354: x_msg_count OUT NOCOPY NUMBER,
355: x_msg_data OUT NOCOPY VARCHAR2,
356: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
357: p_channel_id IN NUMBER,
358: p_item_id IN NUMBER,
359: x_match_exist_flag OUT NOCOPY VARCHAR2,
360: x_approval_status OUT NOCOPY VARCHAR2

Line 383: -- Default = FND_API.G_FALSE

379: -- This will completely check if the channel match the item.
380: -- Parameters :
381: -- IN p_api_version NUMBER Required
382: -- p_init_msg_list VARCHAR2 Optional
383: -- Default = FND_API.G_FALSE
384: -- p_validation_level NUMBER Optional
385: -- Default = FND_API.G_VALID_LEVEL_FULL
386: -- p_check_login_user VARCHAR2 Optional
387: -- Default = FND_API.G_TRUE

Line 385: -- Default = FND_API.G_VALID_LEVEL_FULL

381: -- IN p_api_version NUMBER Required
382: -- p_init_msg_list VARCHAR2 Optional
383: -- Default = FND_API.G_FALSE
384: -- p_validation_level NUMBER Optional
385: -- Default = FND_API.G_VALID_LEVEL_FULL
386: -- p_check_login_user VARCHAR2 Optional
387: -- Default = FND_API.G_TRUE
388: -- Flag for checking user privilege and if user is login.
389: -- p_item_id NUMBER Required

Line 387: -- Default = FND_API.G_TRUE

383: -- Default = FND_API.G_FALSE
384: -- p_validation_level NUMBER Optional
385: -- Default = FND_API.G_VALID_LEVEL_FULL
386: -- p_check_login_user VARCHAR2 Optional
387: -- Default = FND_API.G_TRUE
388: -- Flag for checking user privilege and if user is login.
389: -- p_item_id NUMBER Required
390: -- the id of the item to be matched.
391: -- p_channel_id NUMBER Required

Line 407: -- The matching result: return FND_API.G_TRUE if matched

403: -- OUT : x_return_status VARCHAR2
404: -- x_msg_count NUMBER
405: -- x_msg_data VARCHAR2
406: -- x_match_flag VARCHAR2
407: -- The matching result: return FND_API.G_TRUE if matched
408: -- return FND_API.G_FALSE otherwise
409: -- Notes : Compare procedure Check_MatchingCondition
410: -- with Check_MatchingCondition2.
411: -- Check_MatchingCondition: Use variable static sql statments.

Line 408: -- return FND_API.G_FALSE otherwise

404: -- x_msg_count NUMBER
405: -- x_msg_data VARCHAR2
406: -- x_match_flag VARCHAR2
407: -- The matching result: return FND_API.G_TRUE if matched
408: -- return FND_API.G_FALSE otherwise
409: -- Notes : Compare procedure Check_MatchingCondition
410: -- with Check_MatchingCondition2.
411: -- Check_MatchingCondition: Use variable static sql statments.
412: -- Check_MatchingCondition: Use native dynamic sql statments.

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

417: --
418: PROCEDURE Check_MatchingCondition
419: (
420: p_api_version IN NUMBER,
421: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
422: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
423: x_return_status OUT NOCOPY VARCHAR2,
424: x_msg_count OUT NOCOPY NUMBER,
425: x_msg_data OUT NOCOPY VARCHAR2,

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

418: PROCEDURE Check_MatchingCondition
419: (
420: p_api_version IN NUMBER,
421: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
422: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
423: x_return_status OUT NOCOPY VARCHAR2,
424: x_msg_count OUT NOCOPY NUMBER,
425: x_msg_data OUT NOCOPY VARCHAR2,
426: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

422: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
423: x_return_status OUT NOCOPY VARCHAR2,
424: x_msg_count OUT NOCOPY NUMBER,
425: x_msg_data OUT NOCOPY VARCHAR2,
426: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
427: p_item_id IN NUMBER,
428: p_channel_id IN NUMBER,
429: p_match_on_author_flag IN VARCHAR2,
430: p_match_on_keyword_flag IN VARCHAR2,

Line 458: -- Default = FND_API.G_FALSE

454: -- This will completely check if the channel match the item.
455: -- Parameters :
456: -- IN p_api_version NUMBER Required
457: -- p_init_msg_list VARCHAR2 Optional
458: -- Default = FND_API.G_FALSE
459: -- p_validation_level NUMBER Optional
460: -- Default = FND_API.G_VALID_LEVEL_FULL
461: -- p_check_login_user VARCHAR2 Optional
462: -- Default = FND_API.G_TRUE

Line 460: -- Default = FND_API.G_VALID_LEVEL_FULL

456: -- IN p_api_version NUMBER Required
457: -- p_init_msg_list VARCHAR2 Optional
458: -- Default = FND_API.G_FALSE
459: -- p_validation_level NUMBER Optional
460: -- Default = FND_API.G_VALID_LEVEL_FULL
461: -- p_check_login_user VARCHAR2 Optional
462: -- Default = FND_API.G_TRUE
463: -- Flag for checking user privilege and if user is login.
464: -- p_item_id NUMBER Required

Line 462: -- Default = FND_API.G_TRUE

458: -- Default = FND_API.G_FALSE
459: -- p_validation_level NUMBER Optional
460: -- Default = FND_API.G_VALID_LEVEL_FULL
461: -- p_check_login_user VARCHAR2 Optional
462: -- Default = FND_API.G_TRUE
463: -- Flag for checking user privilege and if user is login.
464: -- p_item_id NUMBER Required
465: -- the id of the item to be matched.
466: -- p_channel_id NUMBER Required

Line 482: -- The matching result: return FND_API.G_TRUE if matched

478: -- OUT : x_return_status VARCHAR2
479: -- x_msg_count NUMBER
480: -- x_msg_data VARCHAR2
481: -- x_match_flag VARCHAR2
482: -- The matching result: return FND_API.G_TRUE if matched
483: -- return FND_API.G_FALSE otherwise
484: -- Notes : Compare procedure Check_MatchingCondition
485: -- with Check_MatchingCondition2.
486: -- Check_MatchingCondition: Use variable static sql statments.

Line 483: -- return FND_API.G_FALSE otherwise

479: -- x_msg_count NUMBER
480: -- x_msg_data VARCHAR2
481: -- x_match_flag VARCHAR2
482: -- The matching result: return FND_API.G_TRUE if matched
483: -- return FND_API.G_FALSE otherwise
484: -- Notes : Compare procedure Check_MatchingCondition
485: -- with Check_MatchingCondition2.
486: -- Check_MatchingCondition: Use variable static sql statments.
487: -- Check_MatchingCondition: Use native dynamic sql statments.

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

492: --
493: PROCEDURE Check_MatchingCondition2
494: (
495: p_api_version IN NUMBER,
496: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
497: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
498: x_return_status OUT NOCOPY VARCHAR2,
499: x_msg_count OUT NOCOPY NUMBER,
500: x_msg_data OUT NOCOPY VARCHAR2,

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

493: PROCEDURE Check_MatchingCondition2
494: (
495: p_api_version IN NUMBER,
496: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
497: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
498: x_return_status OUT NOCOPY VARCHAR2,
499: x_msg_count OUT NOCOPY NUMBER,
500: x_msg_data OUT NOCOPY VARCHAR2,
501: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

497: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
498: x_return_status OUT NOCOPY VARCHAR2,
499: x_msg_count OUT NOCOPY NUMBER,
500: x_msg_data OUT NOCOPY VARCHAR2,
501: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
502: p_item_id IN NUMBER,
503: p_channel_id IN NUMBER,
504: p_match_on_author_flag IN VARCHAR2,
505: p_match_on_keyword_flag IN VARCHAR2,

Line 534: -- Default = FND_API.G_FALSE

530: -- Call approval process procedure if needed.
531: -- Parameters :
532: -- IN p_api_version NUMBER Required
533: -- p_init_msg_list VARCHAR2 Optional
534: -- Default = FND_API.G_FALSE
535: -- p_commit VARCHAR2 Optional
536: -- Default = FND_API.G_FALSE
537: -- p_validation_level NUMBER Optional
538: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 536: -- Default = FND_API.G_FALSE

532: -- IN p_api_version NUMBER Required
533: -- p_init_msg_list VARCHAR2 Optional
534: -- Default = FND_API.G_FALSE
535: -- p_commit VARCHAR2 Optional
536: -- Default = FND_API.G_FALSE
537: -- p_validation_level NUMBER Optional
538: -- Default = FND_API.G_VALID_LEVEL_FULL
539: -- p_check_login_user VARCHAR2 Optional
540: -- Default = FND_API.G_TRUE

Line 538: -- Default = FND_API.G_VALID_LEVEL_FULL

534: -- Default = FND_API.G_FALSE
535: -- p_commit VARCHAR2 Optional
536: -- Default = FND_API.G_FALSE
537: -- p_validation_level NUMBER Optional
538: -- Default = FND_API.G_VALID_LEVEL_FULL
539: -- p_check_login_user VARCHAR2 Optional
540: -- Default = FND_API.G_TRUE
541: -- Flag for checking user privilege and if user is login.
542: -- p_category_id NUMBER Optional

Line 540: -- Default = FND_API.G_TRUE

536: -- Default = FND_API.G_FALSE
537: -- p_validation_level NUMBER Optional
538: -- Default = FND_API.G_VALID_LEVEL_FULL
539: -- p_check_login_user VARCHAR2 Optional
540: -- Default = FND_API.G_TRUE
541: -- Flag for checking user privilege and if user is login.
542: -- p_category_id NUMBER Optional
543: -- Default = FND_API.G_MISS_NUM
544: -- p_channel_id NUMBER Optional

Line 543: -- Default = FND_API.G_MISS_NUM

539: -- p_check_login_user VARCHAR2 Optional
540: -- Default = FND_API.G_TRUE
541: -- Flag for checking user privilege and if user is login.
542: -- p_category_id NUMBER Optional
543: -- Default = FND_API.G_MISS_NUM
544: -- p_channel_id NUMBER Optional
545: -- Default = FND_API.G_MISS_NUM
546: -- the id of the channel to be matched. If missing,
547: -- the item is pushed to the category identified by

Line 545: -- Default = FND_API.G_MISS_NUM

541: -- Flag for checking user privilege and if user is login.
542: -- p_category_id NUMBER Optional
543: -- Default = FND_API.G_MISS_NUM
544: -- p_channel_id NUMBER Optional
545: -- Default = FND_API.G_MISS_NUM
546: -- the id of the channel to be matched. If missing,
547: -- the item is pushed to the category identified by
548: -- p_category_id.
549: -- p_item_id NUMBER Required

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

561: --
562: PROCEDURE Do_ItemChannelMatch
563: (
564: p_api_version IN NUMBER,
565: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
566: p_commit IN VARCHAR2 := FND_API.G_FALSE,
567: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
568: x_return_status OUT NOCOPY VARCHAR2,
569: x_msg_count OUT NOCOPY NUMBER,

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

562: PROCEDURE Do_ItemChannelMatch
563: (
564: p_api_version IN NUMBER,
565: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
566: p_commit IN VARCHAR2 := FND_API.G_FALSE,
567: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
568: x_return_status OUT NOCOPY VARCHAR2,
569: x_msg_count OUT NOCOPY NUMBER,
570: x_msg_data OUT NOCOPY VARCHAR2,

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

563: (
564: p_api_version IN NUMBER,
565: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
566: p_commit IN VARCHAR2 := FND_API.G_FALSE,
567: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
568: x_return_status OUT NOCOPY VARCHAR2,
569: x_msg_count OUT NOCOPY NUMBER,
570: x_msg_data OUT NOCOPY VARCHAR2,
571: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

567: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
568: x_return_status OUT NOCOPY VARCHAR2,
569: x_msg_count OUT NOCOPY NUMBER,
570: x_msg_data OUT NOCOPY VARCHAR2,
571: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
572: p_application_id IN NUMBER := G_AMV_APP_ID,
573: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
574: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
575: p_item_id IN NUMBER,

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

569: x_msg_count OUT NOCOPY NUMBER,
570: x_msg_data OUT NOCOPY VARCHAR2,
571: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
572: p_application_id IN NUMBER := G_AMV_APP_ID,
573: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
574: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
575: p_item_id IN NUMBER,
576: p_table_name_code IN VARCHAR2,
577: p_match_type IN VARCHAR2

Line 574: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,

570: x_msg_data OUT NOCOPY VARCHAR2,
571: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
572: p_application_id IN NUMBER := G_AMV_APP_ID,
573: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
574: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
575: p_item_id IN NUMBER,
576: p_table_name_code IN VARCHAR2,
577: p_match_type IN VARCHAR2
578: );

Line 604: -- Default = FND_API.G_FALSE

600: -- Call approval process procedure if needed.
601: -- Parameters :
602: -- IN p_api_version NUMBER Required
603: -- p_init_msg_list VARCHAR2 Optional
604: -- Default = FND_API.G_FALSE
605: -- p_commit VARCHAR2 Optional
606: -- Default = FND_API.G_FALSE
607: -- p_validation_level NUMBER Optional
608: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 606: -- Default = FND_API.G_FALSE

602: -- IN p_api_version NUMBER Required
603: -- p_init_msg_list VARCHAR2 Optional
604: -- Default = FND_API.G_FALSE
605: -- p_commit VARCHAR2 Optional
606: -- Default = FND_API.G_FALSE
607: -- p_validation_level NUMBER Optional
608: -- Default = FND_API.G_VALID_LEVEL_FULL
609: -- p_check_login_user VARCHAR2 Optional
610: -- Default = FND_API.G_TRUE

Line 608: -- Default = FND_API.G_VALID_LEVEL_FULL

604: -- Default = FND_API.G_FALSE
605: -- p_commit VARCHAR2 Optional
606: -- Default = FND_API.G_FALSE
607: -- p_validation_level NUMBER Optional
608: -- Default = FND_API.G_VALID_LEVEL_FULL
609: -- p_check_login_user VARCHAR2 Optional
610: -- Default = FND_API.G_TRUE
611: -- Flag for checking user privilege and if user is login.
612: -- p_category_id NUMBER Optional

Line 610: -- Default = FND_API.G_TRUE

606: -- Default = FND_API.G_FALSE
607: -- p_validation_level NUMBER Optional
608: -- Default = FND_API.G_VALID_LEVEL_FULL
609: -- p_check_login_user VARCHAR2 Optional
610: -- Default = FND_API.G_TRUE
611: -- Flag for checking user privilege and if user is login.
612: -- p_category_id NUMBER Optional
613: -- Default = FND_API.G_MISS_NUM
614: -- p_channel_id NUMBER Optional

Line 613: -- Default = FND_API.G_MISS_NUM

609: -- p_check_login_user VARCHAR2 Optional
610: -- Default = FND_API.G_TRUE
611: -- Flag for checking user privilege and if user is login.
612: -- p_category_id NUMBER Optional
613: -- Default = FND_API.G_MISS_NUM
614: -- p_channel_id NUMBER Optional
615: -- Default = FND_API.G_MISS_NUM
616: -- the id of the channel to be matched. If missing,
617: -- the item is pushed to the category identified by

Line 615: -- Default = FND_API.G_MISS_NUM

611: -- Flag for checking user privilege and if user is login.
612: -- p_category_id NUMBER Optional
613: -- Default = FND_API.G_MISS_NUM
614: -- p_channel_id NUMBER Optional
615: -- Default = FND_API.G_MISS_NUM
616: -- the id of the channel to be matched. If missing,
617: -- the item is pushed to the category identified by
618: -- p_category_id.
619: -- p_item_id NUMBER Required

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

633: --
634: PROCEDURE Do_ItemChannelMatch
635: (
636: p_api_version IN NUMBER,
637: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
638: p_commit IN VARCHAR2 := FND_API.G_FALSE,
639: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
640: x_return_status OUT NOCOPY VARCHAR2,
641: x_msg_count OUT NOCOPY NUMBER,

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

634: PROCEDURE Do_ItemChannelMatch
635: (
636: p_api_version IN NUMBER,
637: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
638: p_commit IN VARCHAR2 := FND_API.G_FALSE,
639: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
640: x_return_status OUT NOCOPY VARCHAR2,
641: x_msg_count OUT NOCOPY NUMBER,
642: x_msg_data OUT NOCOPY VARCHAR2,

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

635: (
636: p_api_version IN NUMBER,
637: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
638: p_commit IN VARCHAR2 := FND_API.G_FALSE,
639: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
640: x_return_status OUT NOCOPY VARCHAR2,
641: x_msg_count OUT NOCOPY NUMBER,
642: x_msg_data OUT NOCOPY VARCHAR2,
643: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

639: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
640: x_return_status OUT NOCOPY VARCHAR2,
641: x_msg_count OUT NOCOPY NUMBER,
642: x_msg_data OUT NOCOPY VARCHAR2,
643: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
644: p_application_id IN NUMBER := G_AMV_APP_ID,
645: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
646: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
647: p_item_id IN NUMBER,

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

641: x_msg_count OUT NOCOPY NUMBER,
642: x_msg_data OUT NOCOPY VARCHAR2,
643: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
644: p_application_id IN NUMBER := G_AMV_APP_ID,
645: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
646: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
647: p_item_id IN NUMBER,
648: p_table_name_code IN VARCHAR2,
649: p_match_type IN VARCHAR2,

Line 646: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,

642: x_msg_data OUT NOCOPY VARCHAR2,
643: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
644: p_application_id IN NUMBER := G_AMV_APP_ID,
645: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
646: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
647: p_item_id IN NUMBER,
648: p_table_name_code IN VARCHAR2,
649: p_match_type IN VARCHAR2,
650: p_territory_tbl IN terr_id_tbl_type

Line 678: -- Default = FND_API.G_FALSE

674: -- Call approval process procedure if needed.
675: -- Parameters :
676: -- IN p_api_version NUMBER Required
677: -- p_init_msg_list VARCHAR2 Optional
678: -- Default = FND_API.G_FALSE
679: -- p_commit VARCHAR2 Optional
680: -- Default = FND_API.G_FALSE
681: -- p_validation_level NUMBER Optional
682: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 680: -- Default = FND_API.G_FALSE

676: -- IN p_api_version NUMBER Required
677: -- p_init_msg_list VARCHAR2 Optional
678: -- Default = FND_API.G_FALSE
679: -- p_commit VARCHAR2 Optional
680: -- Default = FND_API.G_FALSE
681: -- p_validation_level NUMBER Optional
682: -- Default = FND_API.G_VALID_LEVEL_FULL
683: -- p_check_login_user VARCHAR2 Optional
684: -- Default = FND_API.G_TRUE

Line 682: -- Default = FND_API.G_VALID_LEVEL_FULL

678: -- Default = FND_API.G_FALSE
679: -- p_commit VARCHAR2 Optional
680: -- Default = FND_API.G_FALSE
681: -- p_validation_level NUMBER Optional
682: -- Default = FND_API.G_VALID_LEVEL_FULL
683: -- p_check_login_user VARCHAR2 Optional
684: -- Default = FND_API.G_TRUE
685: -- Flag for checking user privilege and if user is login.
686: -- p_category_id NUMBER Optional

Line 684: -- Default = FND_API.G_TRUE

680: -- Default = FND_API.G_FALSE
681: -- p_validation_level NUMBER Optional
682: -- Default = FND_API.G_VALID_LEVEL_FULL
683: -- p_check_login_user VARCHAR2 Optional
684: -- Default = FND_API.G_TRUE
685: -- Flag for checking user privilege and if user is login.
686: -- p_category_id NUMBER Optional
687: -- Default = FND_API.G_MISS_NUM
688: -- p_channel_id NUMBER Optional

Line 687: -- Default = FND_API.G_MISS_NUM

683: -- p_check_login_user VARCHAR2 Optional
684: -- Default = FND_API.G_TRUE
685: -- Flag for checking user privilege and if user is login.
686: -- p_category_id NUMBER Optional
687: -- Default = FND_API.G_MISS_NUM
688: -- p_channel_id NUMBER Optional
689: -- Default = FND_API.G_MISS_NUM
690: -- the id of the channel to be matched. If missing,
691: -- the item is pushed to the category identified by

Line 689: -- Default = FND_API.G_MISS_NUM

685: -- Flag for checking user privilege and if user is login.
686: -- p_category_id NUMBER Optional
687: -- Default = FND_API.G_MISS_NUM
688: -- p_channel_id NUMBER Optional
689: -- Default = FND_API.G_MISS_NUM
690: -- the id of the channel to be matched. If missing,
691: -- the item is pushed to the category identified by
692: -- p_category_id.
693: -- p_item_id NUMBER Required

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

707: --
708: PROCEDURE Remove_ItemChannelMatch
709: (
710: p_api_version IN NUMBER,
711: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
712: p_commit IN VARCHAR2 := FND_API.G_FALSE,
713: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
714: x_return_status OUT NOCOPY VARCHAR2,
715: x_msg_count OUT NOCOPY NUMBER,

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

708: PROCEDURE Remove_ItemChannelMatch
709: (
710: p_api_version IN NUMBER,
711: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
712: p_commit IN VARCHAR2 := FND_API.G_FALSE,
713: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
714: x_return_status OUT NOCOPY VARCHAR2,
715: x_msg_count OUT NOCOPY NUMBER,
716: x_msg_data OUT NOCOPY VARCHAR2,

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

709: (
710: p_api_version IN NUMBER,
711: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
712: p_commit IN VARCHAR2 := FND_API.G_FALSE,
713: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
714: x_return_status OUT NOCOPY VARCHAR2,
715: x_msg_count OUT NOCOPY NUMBER,
716: x_msg_data OUT NOCOPY VARCHAR2,
717: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

713: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
714: x_return_status OUT NOCOPY VARCHAR2,
715: x_msg_count OUT NOCOPY NUMBER,
716: x_msg_data OUT NOCOPY VARCHAR2,
717: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
718: p_application_id IN NUMBER := G_AMV_APP_ID,
719: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
720: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
721: p_item_id IN NUMBER,

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

715: x_msg_count OUT NOCOPY NUMBER,
716: x_msg_data OUT NOCOPY VARCHAR2,
717: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
718: p_application_id IN NUMBER := G_AMV_APP_ID,
719: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
720: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
721: p_item_id IN NUMBER,
722: p_table_name_code IN VARCHAR2,
723: p_territory_id IN NUMBER := FND_API.G_MISS_NUM

Line 720: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,

716: x_msg_data OUT NOCOPY VARCHAR2,
717: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
718: p_application_id IN NUMBER := G_AMV_APP_ID,
719: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
720: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
721: p_item_id IN NUMBER,
722: p_table_name_code IN VARCHAR2,
723: p_territory_id IN NUMBER := FND_API.G_MISS_NUM
724: );

Line 723: p_territory_id IN NUMBER := FND_API.G_MISS_NUM

719: p_category_id IN NUMBER := FND_API.G_MISS_NUM,
720: p_channel_id IN NUMBER := FND_API.G_MISS_NUM,
721: p_item_id IN NUMBER,
722: p_table_name_code IN VARCHAR2,
723: p_territory_id IN NUMBER := FND_API.G_MISS_NUM
724: );
725: --
726: -- Algorithm:
727: -- BEGIN

Line 753: -- Default = FND_API.G_FALSE

749: -- Function : return all the territories(id and name) for the specified user.
750: -- Parameters :
751: -- IN p_api_version NUMBER Required
752: -- p_init_msg_list VARCHAR2 Optional
753: -- Default = FND_API.G_FALSE
754: -- p_check_login_user VARCHAR2 Optional
755: -- Default = FND_API.G_TRUE
756: -- Flag for checking user privilege and if user is login.
757: -- p_resource_id NUMBER Required

Line 755: -- Default = FND_API.G_TRUE

751: -- IN p_api_version NUMBER Required
752: -- p_init_msg_list VARCHAR2 Optional
753: -- Default = FND_API.G_FALSE
754: -- p_check_login_user VARCHAR2 Optional
755: -- Default = FND_API.G_TRUE
756: -- Flag for checking user privilege and if user is login.
757: -- p_resource_id NUMBER Required
758: -- This should be the resource id.
759: -- p_resource_type VARCHAR2 optional

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

769: --
770: PROCEDURE Get_UserTerritory
771: (
772: p_api_version IN NUMBER,
773: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
774: x_return_status OUT NOCOPY VARCHAR2,
775: x_msg_count OUT NOCOPY NUMBER,
776: x_msg_data OUT NOCOPY VARCHAR2,
777: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

773: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
774: x_return_status OUT NOCOPY VARCHAR2,
775: x_msg_count OUT NOCOPY NUMBER,
776: x_msg_data OUT NOCOPY VARCHAR2,
777: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
778: p_resource_id IN NUMBER,
779: p_resource_type IN VARCHAR2 := 'RS_EMPLOYEE',
780: x_terr_id_tbl OUT NOCOPY terr_id_tbl_type,
781: x_terr_name_tbl OUT NOCOPY terr_name_tbl_type

Line 794: -- Default = FND_API.G_FALSE

790: -- Function : return all the territories(id and name) for the specified user.
791: -- Parameters :
792: -- IN p_api_version NUMBER Required
793: -- p_init_msg_list VARCHAR2 Optional
794: -- Default = FND_API.G_FALSE
795: -- p_check_login_user VARCHAR2 Optional
796: -- Default = FND_API.G_TRUE
797: -- Flag for checking user privilege and if user is login.
798: -- p_terr_id NUMBER Required

Line 796: -- Default = FND_API.G_TRUE

792: -- IN p_api_version NUMBER Required
793: -- p_init_msg_list VARCHAR2 Optional
794: -- Default = FND_API.G_FALSE
795: -- p_check_login_user VARCHAR2 Optional
796: -- Default = FND_API.G_TRUE
797: -- Flag for checking user privilege and if user is login.
798: -- p_terr_id NUMBER Required
799: -- The should be the resource id.
800: -- OUT : x_return_status VARCHAR2

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

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

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

811: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
812: x_return_status OUT NOCOPY VARCHAR2,
813: x_msg_count OUT NOCOPY NUMBER,
814: x_msg_data OUT NOCOPY VARCHAR2,
815: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
816: p_terr_id IN NUMBER,
817: p_table_name_code IN VARCHAR2,
818: x_item_id_tbl OUT NOCOPY terr_id_tbl_type
819: );