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

Line 85: -- Default = FND_API.G_FALSE

81: -- given the passed perspective information.
82: -- Parameters :
83: -- IN p_api_version NUMBER Required
84: -- p_init_msg_list VARCHAR2 Optional
85: -- Default = FND_API.G_FALSE
86: -- p_commit VARCHAR2 Optional
87: -- Default = FND_API.G_FALSE
88: -- p_validation_level NUMBER Optional
89: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 87: -- Default = FND_API.G_FALSE

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

Line 89: -- Default = FND_API.G_VALID_LEVEL_FULL

85: -- Default = FND_API.G_FALSE
86: -- p_commit VARCHAR2 Optional
87: -- Default = FND_API.G_FALSE
88: -- p_validation_level NUMBER Optional
89: -- Default = FND_API.G_VALID_LEVEL_FULL
90: -- p_check_login_user VARCHAR2 Optional
91: -- Default = FND_API.G_TRUE
92: -- Flag for checking user privilege and if user is login.
93: -- p_perspective_name VARCHAR2 Required

Line 91: -- Default = FND_API.G_TRUE

87: -- Default = FND_API.G_FALSE
88: -- p_validation_level NUMBER Optional
89: -- Default = FND_API.G_VALID_LEVEL_FULL
90: -- p_check_login_user VARCHAR2 Optional
91: -- Default = FND_API.G_TRUE
92: -- Flag for checking user privilege and if user is login.
93: -- p_perspective_name VARCHAR2 Required
94: -- Perspective_name are required to be unique.
95: -- p_persp_description VARCHAR2 Optional

Line 96: -- Default = FND_API.G_MISS_CHAR

92: -- Flag for checking user privilege and if user is login.
93: -- p_perspective_name VARCHAR2 Required
94: -- Perspective_name are required to be unique.
95: -- p_persp_description VARCHAR2 Optional
96: -- Default = FND_API.G_MISS_CHAR
97: -- The description of perspective
98: -- OUT : x_return_status VARCHAR2
99: -- x_msg_count NUMBER
100: -- x_msg_data VARCHAR2

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

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

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

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

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

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

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

112: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
113: x_return_status OUT NOCOPY VARCHAR2,
114: x_msg_count OUT NOCOPY NUMBER,
115: x_msg_data OUT NOCOPY VARCHAR2,
116: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
117: p_perspective_name IN VARCHAR2,
118: p_persp_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: x_perspective_id OUT NOCOPY NUMBER
120: );

Line 118: p_persp_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

114: x_msg_count OUT NOCOPY NUMBER,
115: x_msg_data OUT NOCOPY VARCHAR2,
116: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
117: p_perspective_name IN VARCHAR2,
118: p_persp_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
119: x_perspective_id OUT NOCOPY NUMBER
120: );
121: --
122: -- Algorithm:

Line 152: -- Default = FND_API.G_FALSE

148: -- Function : Delete the perspective specified by its id or name
149: -- Parameters :
150: -- IN p_api_version NUMBER Required
151: -- p_init_msg_list VARCHAR2 Optional
152: -- Default = FND_API.G_FALSE
153: -- p_commit VARCHAR2 Optional
154: -- Default = FND_API.G_FALSE
155: -- p_validation_level NUMBER Optional
156: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 154: -- Default = FND_API.G_FALSE

150: -- IN p_api_version NUMBER Required
151: -- p_init_msg_list VARCHAR2 Optional
152: -- Default = FND_API.G_FALSE
153: -- p_commit VARCHAR2 Optional
154: -- Default = FND_API.G_FALSE
155: -- p_validation_level NUMBER Optional
156: -- Default = FND_API.G_VALID_LEVEL_FULL
157: -- p_check_login_user VARCHAR2 Optional
158: -- Default = FND_API.G_TRUE

Line 156: -- Default = FND_API.G_VALID_LEVEL_FULL

152: -- Default = FND_API.G_FALSE
153: -- p_commit VARCHAR2 Optional
154: -- Default = FND_API.G_FALSE
155: -- p_validation_level NUMBER Optional
156: -- Default = FND_API.G_VALID_LEVEL_FULL
157: -- p_check_login_user VARCHAR2 Optional
158: -- Default = FND_API.G_TRUE
159: -- Flag for checking user privilege and if user is login.
160: -- p_perspective_id NUMBER Optional

Line 158: -- Default = FND_API.G_TRUE

154: -- Default = FND_API.G_FALSE
155: -- p_validation_level NUMBER Optional
156: -- Default = FND_API.G_VALID_LEVEL_FULL
157: -- p_check_login_user VARCHAR2 Optional
158: -- Default = FND_API.G_TRUE
159: -- Flag for checking user privilege and if user is login.
160: -- p_perspective_id NUMBER Optional
161: -- p_perspective_name VARCHAR2 Optional
162: -- Either pass the perspective id (preferred) or

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

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

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

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

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

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

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

176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177: x_return_status OUT NOCOPY VARCHAR2,
178: x_msg_count OUT NOCOPY NUMBER,
179: x_msg_data OUT NOCOPY VARCHAR2,
180: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
181: p_perspective_id IN NUMBER := FND_API.G_MISS_NUM,
182: p_perspective_name IN VARCHAR2 := FND_API.G_MISS_CHAR
183: );
184: --

Line 181: p_perspective_id IN NUMBER := FND_API.G_MISS_NUM,

177: x_return_status OUT NOCOPY VARCHAR2,
178: x_msg_count OUT NOCOPY NUMBER,
179: x_msg_data OUT NOCOPY VARCHAR2,
180: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
181: p_perspective_id IN NUMBER := FND_API.G_MISS_NUM,
182: p_perspective_name IN VARCHAR2 := FND_API.G_MISS_CHAR
183: );
184: --
185: -- Algorithm:

Line 182: p_perspective_name IN VARCHAR2 := FND_API.G_MISS_CHAR

178: x_msg_count OUT NOCOPY NUMBER,
179: x_msg_data OUT NOCOPY VARCHAR2,
180: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
181: p_perspective_id IN NUMBER := FND_API.G_MISS_NUM,
182: p_perspective_name IN VARCHAR2 := FND_API.G_MISS_CHAR
183: );
184: --
185: -- Algorithm:
186: -- BEGIN

Line 220: -- Default = FND_API.G_FALSE

216: -- Function : Change the perspective name
217: -- Parameters :
218: -- IN p_api_version NUMBER Required
219: -- p_init_msg_list VARCHAR2 Optional
220: -- Default = FND_API.G_FALSE
221: -- p_commit VARCHAR2 Optional
222: -- Default = FND_API.G_FALSE
223: -- p_validation_level NUMBER Optional
224: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 222: -- Default = FND_API.G_FALSE

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

Line 224: -- Default = FND_API.G_VALID_LEVEL_FULL

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

Line 226: -- Default = FND_API.G_TRUE

222: -- Default = FND_API.G_FALSE
223: -- p_validation_level NUMBER Optional
224: -- Default = FND_API.G_VALID_LEVEL_FULL
225: -- p_check_login_user VARCHAR2 Optional
226: -- Default = FND_API.G_TRUE
227: -- Flag for checking user privilege and if user is login.
228: -- p_perspective_id NUMBER Optional
229: -- Default = FND_API.G_MISS_NUM
230: -- p_perspective_name VARCHAR2 Optional

Line 229: -- Default = FND_API.G_MISS_NUM

225: -- p_check_login_user VARCHAR2 Optional
226: -- Default = FND_API.G_TRUE
227: -- Flag for checking user privilege and if user is login.
228: -- p_perspective_id NUMBER Optional
229: -- Default = FND_API.G_MISS_NUM
230: -- p_perspective_name VARCHAR2 Optional
231: -- Default = FND_API.G_MISS_CHAR
232: -- Either pass the perspective id (preferred) or
233: -- perspective name to identify the perspective.

Line 231: -- Default = FND_API.G_MISS_CHAR

227: -- Flag for checking user privilege and if user is login.
228: -- p_perspective_id NUMBER Optional
229: -- Default = FND_API.G_MISS_NUM
230: -- p_perspective_name VARCHAR2 Optional
231: -- Default = FND_API.G_MISS_CHAR
232: -- Either pass the perspective id (preferred) or
233: -- perspective name to identify the perspective.
234: -- p_perspective_new_name VARCHAR2 Optional
235: -- Default = FND_API.G_MISS_CHAR

Line 235: -- Default = FND_API.G_MISS_CHAR

231: -- Default = FND_API.G_MISS_CHAR
232: -- Either pass the perspective id (preferred) or
233: -- perspective name to identify the perspective.
234: -- p_perspective_new_name VARCHAR2 Optional
235: -- Default = FND_API.G_MISS_CHAR
236: -- p_persp_description VARCHAR2 Optional
237: -- Default = FND_API.G_MISS_CHAR
238: -- OUT : x_return_status VARCHAR2
239: -- x_msg_count NUMBER

Line 237: -- Default = FND_API.G_MISS_CHAR

233: -- perspective name to identify the perspective.
234: -- p_perspective_new_name VARCHAR2 Optional
235: -- Default = FND_API.G_MISS_CHAR
236: -- p_persp_description VARCHAR2 Optional
237: -- Default = FND_API.G_MISS_CHAR
238: -- OUT : x_return_status VARCHAR2
239: -- x_msg_count NUMBER
240: -- x_msg_data VARCHAR2
241: -- Notes :

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

244: --
245: PROCEDURE Update_Perspective
246: (
247: p_api_version IN NUMBER,
248: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
249: p_commit IN VARCHAR2 := FND_API.G_FALSE,
250: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
251: x_return_status OUT NOCOPY VARCHAR2,
252: x_msg_count OUT NOCOPY NUMBER,

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

245: PROCEDURE Update_Perspective
246: (
247: p_api_version IN NUMBER,
248: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
249: p_commit IN VARCHAR2 := FND_API.G_FALSE,
250: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
251: x_return_status OUT NOCOPY VARCHAR2,
252: x_msg_count OUT NOCOPY NUMBER,
253: x_msg_data OUT NOCOPY VARCHAR2,

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

246: (
247: p_api_version IN NUMBER,
248: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
249: p_commit IN VARCHAR2 := FND_API.G_FALSE,
250: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
251: x_return_status OUT NOCOPY VARCHAR2,
252: x_msg_count OUT NOCOPY NUMBER,
253: x_msg_data OUT NOCOPY VARCHAR2,
254: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

250: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
251: x_return_status OUT NOCOPY VARCHAR2,
252: x_msg_count OUT NOCOPY NUMBER,
253: x_msg_data OUT NOCOPY VARCHAR2,
254: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
255: p_perspective_id IN NUMBER := FND_API.G_MISS_NUM,
256: p_perspective_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_perspective_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_persp_description IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 255: p_perspective_id IN NUMBER := FND_API.G_MISS_NUM,

251: x_return_status OUT NOCOPY VARCHAR2,
252: x_msg_count OUT NOCOPY NUMBER,
253: x_msg_data OUT NOCOPY VARCHAR2,
254: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
255: p_perspective_id IN NUMBER := FND_API.G_MISS_NUM,
256: p_perspective_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_perspective_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_persp_description IN VARCHAR2 := FND_API.G_MISS_CHAR
259: );

Line 256: p_perspective_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

252: x_msg_count OUT NOCOPY NUMBER,
253: x_msg_data OUT NOCOPY VARCHAR2,
254: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
255: p_perspective_id IN NUMBER := FND_API.G_MISS_NUM,
256: p_perspective_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_perspective_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_persp_description IN VARCHAR2 := FND_API.G_MISS_CHAR
259: );
260: --

Line 257: p_perspective_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

253: x_msg_data OUT NOCOPY VARCHAR2,
254: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
255: p_perspective_id IN NUMBER := FND_API.G_MISS_NUM,
256: p_perspective_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_perspective_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_persp_description IN VARCHAR2 := FND_API.G_MISS_CHAR
259: );
260: --
261: --

Line 258: p_persp_description IN VARCHAR2 := FND_API.G_MISS_CHAR

254: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
255: p_perspective_id IN NUMBER := FND_API.G_MISS_NUM,
256: p_perspective_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_perspective_new_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
258: p_persp_description IN VARCHAR2 := FND_API.G_MISS_CHAR
259: );
260: --
261: --
262: -- Algorithm:

Line 296: -- Default = FND_API.G_FALSE

292: -- Function : Get perspective record based on its id (preferred) or name.
293: -- Parameters :
294: -- IN p_api_version NUMBER Required
295: -- p_init_msg_list VARCHAR2 Optional
296: -- Default = FND_API.G_FALSE
297: -- p_validation_level NUMBER Optional
298: -- Default = FND_API.G_VALID_LEVEL_FULL
299: -- p_check_login_user VARCHAR2 Optional
300: -- Default = FND_API.G_TRUE

Line 298: -- Default = FND_API.G_VALID_LEVEL_FULL

294: -- IN p_api_version NUMBER Required
295: -- p_init_msg_list VARCHAR2 Optional
296: -- Default = FND_API.G_FALSE
297: -- p_validation_level NUMBER Optional
298: -- Default = FND_API.G_VALID_LEVEL_FULL
299: -- p_check_login_user VARCHAR2 Optional
300: -- Default = FND_API.G_TRUE
301: -- Flag for checking user privilege and if user is login.
302: -- p_perspective_id NUMBER Optional

Line 300: -- Default = FND_API.G_TRUE

296: -- Default = FND_API.G_FALSE
297: -- p_validation_level NUMBER Optional
298: -- Default = FND_API.G_VALID_LEVEL_FULL
299: -- p_check_login_user VARCHAR2 Optional
300: -- Default = FND_API.G_TRUE
301: -- Flag for checking user privilege and if user is login.
302: -- p_perspective_id NUMBER Optional
303: -- p_perspective_name VARCHAR2 Optional
304: -- Either pass the perspective id (preferred) or

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

314: --
315: PROCEDURE Get_Perspective
316: (
317: p_api_version IN NUMBER,
318: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
319: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
320: x_return_status OUT NOCOPY VARCHAR2,
321: x_msg_count OUT NOCOPY NUMBER,
322: x_msg_data OUT NOCOPY VARCHAR2,

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

315: PROCEDURE Get_Perspective
316: (
317: p_api_version IN NUMBER,
318: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
319: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
320: x_return_status OUT NOCOPY VARCHAR2,
321: x_msg_count OUT NOCOPY NUMBER,
322: x_msg_data OUT NOCOPY VARCHAR2,
323: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

319: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
320: x_return_status OUT NOCOPY VARCHAR2,
321: x_msg_count OUT NOCOPY NUMBER,
322: x_msg_data OUT NOCOPY VARCHAR2,
323: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
324: p_perspective_id IN NUMBER := FND_API.G_MISS_NUM,
325: p_perspective_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
326: x_perspective_obj OUT NOCOPY AMV_PERSPECTIVE_OBJ_TYPE
327: );

Line 324: p_perspective_id IN NUMBER := FND_API.G_MISS_NUM,

320: x_return_status OUT NOCOPY VARCHAR2,
321: x_msg_count OUT NOCOPY NUMBER,
322: x_msg_data OUT NOCOPY VARCHAR2,
323: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
324: p_perspective_id IN NUMBER := FND_API.G_MISS_NUM,
325: p_perspective_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
326: x_perspective_obj OUT NOCOPY AMV_PERSPECTIVE_OBJ_TYPE
327: );
328: -- Algorithm:

Line 325: p_perspective_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

321: x_msg_count OUT NOCOPY NUMBER,
322: x_msg_data OUT NOCOPY VARCHAR2,
323: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
324: p_perspective_id IN NUMBER := FND_API.G_MISS_NUM,
325: p_perspective_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
326: x_perspective_obj OUT NOCOPY AMV_PERSPECTIVE_OBJ_TYPE
327: );
328: -- Algorithm:
329: -- BEGIN

Line 353: -- Default = FND_API.G_FALSE

349: -- Function : Find perspective records based on its id (preferred) or name.
350: -- Parameters :
351: -- IN p_api_version NUMBER Required
352: -- p_init_msg_list VARCHAR2 Optional
353: -- Default = FND_API.G_FALSE
354: -- p_validation_level NUMBER Optional
355: -- Default = FND_API.G_VALID_LEVEL_FULL
356: -- p_check_login_user VARCHAR2 Optional
357: -- Default = FND_API.G_TRUE

Line 355: -- Default = FND_API.G_VALID_LEVEL_FULL

351: -- IN p_api_version NUMBER Required
352: -- p_init_msg_list VARCHAR2 Optional
353: -- Default = FND_API.G_FALSE
354: -- p_validation_level NUMBER Optional
355: -- Default = FND_API.G_VALID_LEVEL_FULL
356: -- p_check_login_user VARCHAR2 Optional
357: -- Default = FND_API.G_TRUE
358: -- Flag for checking user privilege and if user is login.
359: -- p_perspective_name VARCHAR2 Optional

Line 357: -- Default = FND_API.G_TRUE

353: -- Default = FND_API.G_FALSE
354: -- p_validation_level NUMBER Optional
355: -- Default = FND_API.G_VALID_LEVEL_FULL
356: -- p_check_login_user VARCHAR2 Optional
357: -- Default = FND_API.G_TRUE
358: -- Flag for checking user privilege and if user is login.
359: -- p_perspective_name VARCHAR2 Optional
360: -- The search criteria on perspective name
361: -- Default = FND_API.G_MISS_CHAR

Line 361: -- Default = FND_API.G_MISS_CHAR

357: -- Default = FND_API.G_TRUE
358: -- Flag for checking user privilege and if user is login.
359: -- p_perspective_name VARCHAR2 Optional
360: -- The search criteria on perspective name
361: -- Default = FND_API.G_MISS_CHAR
362: -- p_perspective_name VARCHAR2 Optional
363: -- The search criteria on perspective name
364: -- Default = FND_API.G_MISS_CHAR
365: -- p_persp_description VARCHAR2 Optional

Line 364: -- Default = FND_API.G_MISS_CHAR

360: -- The search criteria on perspective name
361: -- Default = FND_API.G_MISS_CHAR
362: -- p_perspective_name VARCHAR2 Optional
363: -- The search criteria on perspective name
364: -- Default = FND_API.G_MISS_CHAR
365: -- p_persp_description VARCHAR2 Optional
366: -- The search criteria on perspective description
367: -- Default = FND_API.G_MISS_CHAR
368: -- p_subset_request_obj AMV_REQUEST_OBJ_TYPE,

Line 367: -- Default = FND_API.G_MISS_CHAR

363: -- The search criteria on perspective name
364: -- Default = FND_API.G_MISS_CHAR
365: -- p_persp_description VARCHAR2 Optional
366: -- The search criteria on perspective description
367: -- Default = FND_API.G_MISS_CHAR
368: -- p_subset_request_obj AMV_REQUEST_OBJ_TYPE,
369: -- Required.
370: -- OUT : x_return_status VARCHAR2
371: -- x_msg_count NUMBER

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

379: --
380: PROCEDURE Find_Perspective
381: (
382: p_api_version IN NUMBER,
383: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
384: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
385: x_return_status OUT NOCOPY VARCHAR2,
386: x_msg_count OUT NOCOPY NUMBER,
387: x_msg_data OUT NOCOPY VARCHAR2,

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

380: PROCEDURE Find_Perspective
381: (
382: p_api_version IN NUMBER,
383: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
384: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
385: x_return_status OUT NOCOPY VARCHAR2,
386: x_msg_count OUT NOCOPY NUMBER,
387: x_msg_data OUT NOCOPY VARCHAR2,
388: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

384: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
385: x_return_status OUT NOCOPY VARCHAR2,
386: x_msg_count OUT NOCOPY NUMBER,
387: x_msg_data OUT NOCOPY VARCHAR2,
388: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
389: p_perspective_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
390: p_persp_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
391: p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,
392: x_subset_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,

Line 389: p_perspective_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

385: x_return_status OUT NOCOPY VARCHAR2,
386: x_msg_count OUT NOCOPY NUMBER,
387: x_msg_data OUT NOCOPY VARCHAR2,
388: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
389: p_perspective_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
390: p_persp_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
391: p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,
392: x_subset_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
393: x_perspective_obj_varray OUT NOCOPY AMV_PERSPECTIVE_OBJ_VARRAY

Line 390: p_persp_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

386: x_msg_count OUT NOCOPY NUMBER,
387: x_msg_data OUT NOCOPY VARCHAR2,
388: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
389: p_perspective_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
390: p_persp_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
391: p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,
392: x_subset_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
393: x_perspective_obj_varray OUT NOCOPY AMV_PERSPECTIVE_OBJ_VARRAY
394: );

Line 416: -- Default = FND_API.G_FALSE

412: -- item.
413: -- Parameters :
414: -- IN p_api_version NUMBER Required
415: -- p_init_msg_list VARCHAR2 Optional
416: -- Default = FND_API.G_FALSE
417: -- p_commit VARCHAR2 Optional
418: -- Default = FND_API.G_FALSE
419: -- p_validation_level NUMBER Optional
420: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 418: -- Default = FND_API.G_FALSE

414: -- IN p_api_version NUMBER Required
415: -- p_init_msg_list VARCHAR2 Optional
416: -- Default = FND_API.G_FALSE
417: -- p_commit VARCHAR2 Optional
418: -- Default = FND_API.G_FALSE
419: -- p_validation_level NUMBER Optional
420: -- Default = FND_API.G_VALID_LEVEL_FULL
421: -- p_check_login_user VARCHAR2 Optional
422: -- Default = FND_API.G_TRUE

Line 420: -- Default = FND_API.G_VALID_LEVEL_FULL

416: -- Default = FND_API.G_FALSE
417: -- p_commit VARCHAR2 Optional
418: -- Default = FND_API.G_FALSE
419: -- p_validation_level NUMBER Optional
420: -- Default = FND_API.G_VALID_LEVEL_FULL
421: -- p_check_login_user VARCHAR2 Optional
422: -- Default = FND_API.G_TRUE
423: -- Flag for checking user privilege and if user is login.
424: -- p_item_id NUMBER Required

Line 422: -- Default = FND_API.G_TRUE

418: -- Default = FND_API.G_FALSE
419: -- p_validation_level NUMBER Optional
420: -- Default = FND_API.G_VALID_LEVEL_FULL
421: -- p_check_login_user VARCHAR2 Optional
422: -- Default = FND_API.G_TRUE
423: -- Flag for checking user privilege and if user is login.
424: -- p_item_id NUMBER Required
425: -- The item id to be add the perspectives.
426: -- p_perspective_array AMV_NUMBER_VARRAY_TYPE

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

435: --
436: PROCEDURE Add_ItemPersps
437: (
438: p_api_version IN NUMBER,
439: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
440: p_commit IN VARCHAR2 := FND_API.G_FALSE,
441: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
442: x_return_status OUT NOCOPY VARCHAR2,
443: x_msg_count OUT NOCOPY NUMBER,

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

436: PROCEDURE Add_ItemPersps
437: (
438: p_api_version IN NUMBER,
439: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
440: p_commit IN VARCHAR2 := FND_API.G_FALSE,
441: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
442: x_return_status OUT NOCOPY VARCHAR2,
443: x_msg_count OUT NOCOPY NUMBER,
444: x_msg_data OUT NOCOPY VARCHAR2,

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

437: (
438: p_api_version IN NUMBER,
439: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
440: p_commit IN VARCHAR2 := FND_API.G_FALSE,
441: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
442: x_return_status OUT NOCOPY VARCHAR2,
443: x_msg_count OUT NOCOPY NUMBER,
444: x_msg_data OUT NOCOPY VARCHAR2,
445: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

441: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
442: x_return_status OUT NOCOPY VARCHAR2,
443: x_msg_count OUT NOCOPY NUMBER,
444: x_msg_data OUT NOCOPY VARCHAR2,
445: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
446: p_item_id IN NUMBER,
447: p_perspective_array IN AMV_NUMBER_VARRAY_TYPE
448: );
449: --

Line 481: -- Default = FND_API.G_FALSE

477: -- Function : Add the specified perspective to the specified item.
478: -- Parameters :
479: -- IN p_api_version NUMBER Required
480: -- p_init_msg_list VARCHAR2 Optional
481: -- Default = FND_API.G_FALSE
482: -- p_commit VARCHAR2 Optional
483: -- Default = FND_API.G_FALSE
484: -- p_validation_level NUMBER Optional
485: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 483: -- Default = FND_API.G_FALSE

479: -- IN p_api_version NUMBER Required
480: -- p_init_msg_list VARCHAR2 Optional
481: -- Default = FND_API.G_FALSE
482: -- p_commit VARCHAR2 Optional
483: -- Default = FND_API.G_FALSE
484: -- p_validation_level NUMBER Optional
485: -- Default = FND_API.G_VALID_LEVEL_FULL
486: -- p_check_login_user VARCHAR2 Optional
487: -- Default = FND_API.G_TRUE

Line 485: -- Default = FND_API.G_VALID_LEVEL_FULL

481: -- Default = FND_API.G_FALSE
482: -- p_commit VARCHAR2 Optional
483: -- Default = FND_API.G_FALSE
484: -- p_validation_level NUMBER Optional
485: -- Default = FND_API.G_VALID_LEVEL_FULL
486: -- p_check_login_user VARCHAR2 Optional
487: -- Default = FND_API.G_TRUE
488: -- Flag for checking user privilege and if user is login.
489: -- p_item_id NUMBER Required

Line 487: -- Default = FND_API.G_TRUE

483: -- Default = FND_API.G_FALSE
484: -- p_validation_level NUMBER Optional
485: -- Default = FND_API.G_VALID_LEVEL_FULL
486: -- p_check_login_user VARCHAR2 Optional
487: -- Default = FND_API.G_TRUE
488: -- Flag for checking user privilege and if user is login.
489: -- p_item_id NUMBER Required
490: -- The item id to be add the perspectives.
491: -- p_perspective_id NUMBER Required

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

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

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

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

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

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

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

506: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
507: x_return_status OUT NOCOPY VARCHAR2,
508: x_msg_count OUT NOCOPY NUMBER,
509: x_msg_data OUT NOCOPY VARCHAR2,
510: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
511: p_item_id IN NUMBER,
512: p_perspective_id IN NUMBER
513: );
514: --

Line 551: -- Default = FND_API.G_FALSE

547: -- from the specified item.
548: -- Parameters :
549: -- IN p_api_version NUMBER Required
550: -- p_init_msg_list VARCHAR2 Optional
551: -- Default = FND_API.G_FALSE
552: -- p_commit VARCHAR2 Optional
553: -- Default = FND_API.G_FALSE
554: -- p_validation_level NUMBER Optional
555: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 553: -- Default = FND_API.G_FALSE

549: -- IN p_api_version NUMBER Required
550: -- p_init_msg_list VARCHAR2 Optional
551: -- Default = FND_API.G_FALSE
552: -- p_commit VARCHAR2 Optional
553: -- Default = FND_API.G_FALSE
554: -- p_validation_level NUMBER Optional
555: -- Default = FND_API.G_VALID_LEVEL_FULL
556: -- p_check_login_user VARCHAR2 Optional
557: -- Default = FND_API.G_TRUE

Line 555: -- Default = FND_API.G_VALID_LEVEL_FULL

551: -- Default = FND_API.G_FALSE
552: -- p_commit VARCHAR2 Optional
553: -- Default = FND_API.G_FALSE
554: -- p_validation_level NUMBER Optional
555: -- Default = FND_API.G_VALID_LEVEL_FULL
556: -- p_check_login_user VARCHAR2 Optional
557: -- Default = FND_API.G_TRUE
558: -- Flag for checking user privilege and if user is login.
559: -- p_item_id NUMBER Required

Line 557: -- Default = FND_API.G_TRUE

553: -- Default = FND_API.G_FALSE
554: -- p_validation_level NUMBER Optional
555: -- Default = FND_API.G_VALID_LEVEL_FULL
556: -- p_check_login_user VARCHAR2 Optional
557: -- Default = FND_API.G_TRUE
558: -- Flag for checking user privilege and if user is login.
559: -- p_item_id NUMBER Required
560: -- The item id to be add the perspectives.
561: -- p_perspective_array AMV_NUMBER_VARRAY_TYPE

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

571: --
572: PROCEDURE Delete_ItemPersps
573: (
574: p_api_version IN NUMBER,
575: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
576: p_commit IN VARCHAR2 := FND_API.G_FALSE,
577: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
578: x_return_status OUT NOCOPY VARCHAR2,
579: x_msg_count OUT NOCOPY NUMBER,

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

572: PROCEDURE Delete_ItemPersps
573: (
574: p_api_version IN NUMBER,
575: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
576: p_commit IN VARCHAR2 := FND_API.G_FALSE,
577: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
578: x_return_status OUT NOCOPY VARCHAR2,
579: x_msg_count OUT NOCOPY NUMBER,
580: x_msg_data OUT NOCOPY VARCHAR2,

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

573: (
574: p_api_version IN NUMBER,
575: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
576: p_commit IN VARCHAR2 := FND_API.G_FALSE,
577: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
578: x_return_status OUT NOCOPY VARCHAR2,
579: x_msg_count OUT NOCOPY NUMBER,
580: x_msg_data OUT NOCOPY VARCHAR2,
581: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

577: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
578: x_return_status OUT NOCOPY VARCHAR2,
579: x_msg_count OUT NOCOPY NUMBER,
580: x_msg_data OUT NOCOPY VARCHAR2,
581: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
582: p_item_id IN NUMBER,
583: p_perspective_array IN AMV_NUMBER_VARRAY_TYPE
584: );
585: --

Line 623: -- Default = FND_API.G_FALSE

619: -- Function : Delete the specified perspective from the specified item.
620: -- Parameters :
621: -- IN p_api_version NUMBER Required
622: -- p_init_msg_list VARCHAR2 Optional
623: -- Default = FND_API.G_FALSE
624: -- p_commit VARCHAR2 Optional
625: -- Default = FND_API.G_FALSE
626: -- p_validation_level NUMBER Optional
627: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 625: -- Default = FND_API.G_FALSE

621: -- IN p_api_version NUMBER Required
622: -- p_init_msg_list VARCHAR2 Optional
623: -- Default = FND_API.G_FALSE
624: -- p_commit VARCHAR2 Optional
625: -- Default = FND_API.G_FALSE
626: -- p_validation_level NUMBER Optional
627: -- Default = FND_API.G_VALID_LEVEL_FULL
628: -- p_check_login_user VARCHAR2 Optional
629: -- Default = FND_API.G_TRUE

Line 627: -- Default = FND_API.G_VALID_LEVEL_FULL

623: -- Default = FND_API.G_FALSE
624: -- p_commit VARCHAR2 Optional
625: -- Default = FND_API.G_FALSE
626: -- p_validation_level NUMBER Optional
627: -- Default = FND_API.G_VALID_LEVEL_FULL
628: -- p_check_login_user VARCHAR2 Optional
629: -- Default = FND_API.G_TRUE
630: -- Flag for checking user privilege and if user is login.
631: -- p_item_id NUMBER Required

Line 629: -- Default = FND_API.G_TRUE

625: -- Default = FND_API.G_FALSE
626: -- p_validation_level NUMBER Optional
627: -- Default = FND_API.G_VALID_LEVEL_FULL
628: -- p_check_login_user VARCHAR2 Optional
629: -- Default = FND_API.G_TRUE
630: -- Flag for checking user privilege and if user is login.
631: -- p_item_id NUMBER Required
632: -- The item id to be add the perspectives.
633: -- p_perspective_id NUMBER Optional

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

642: --
643: PROCEDURE Delete_ItemPersps
644: (
645: p_api_version IN NUMBER,
646: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
647: p_commit IN VARCHAR2 := FND_API.G_FALSE,
648: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
649: x_return_status OUT NOCOPY VARCHAR2,
650: x_msg_count OUT NOCOPY NUMBER,

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

643: PROCEDURE Delete_ItemPersps
644: (
645: p_api_version IN NUMBER,
646: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
647: p_commit IN VARCHAR2 := FND_API.G_FALSE,
648: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
649: x_return_status OUT NOCOPY VARCHAR2,
650: x_msg_count OUT NOCOPY NUMBER,
651: x_msg_data OUT NOCOPY VARCHAR2,

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

644: (
645: p_api_version IN NUMBER,
646: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
647: p_commit IN VARCHAR2 := FND_API.G_FALSE,
648: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
649: x_return_status OUT NOCOPY VARCHAR2,
650: x_msg_count OUT NOCOPY NUMBER,
651: x_msg_data OUT NOCOPY VARCHAR2,
652: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

648: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
649: x_return_status OUT NOCOPY VARCHAR2,
650: x_msg_count OUT NOCOPY NUMBER,
651: x_msg_data OUT NOCOPY VARCHAR2,
652: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
653: p_item_id IN NUMBER,
654: p_perspective_id IN NUMBER := FND_API.G_MISS_NUM
655: );
656: --

Line 654: p_perspective_id IN NUMBER := FND_API.G_MISS_NUM

650: x_msg_count OUT NOCOPY NUMBER,
651: x_msg_data OUT NOCOPY VARCHAR2,
652: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
653: p_item_id IN NUMBER,
654: p_perspective_id IN NUMBER := FND_API.G_MISS_NUM
655: );
656: --
657: -- Algorithm:
658: -- BEGIN

Line 695: -- Default = FND_API.G_FALSE

691: -- and add the passed perspectives to the item.
692: -- Parameters :
693: -- IN p_api_version NUMBER Required
694: -- p_init_msg_list VARCHAR2 Optional
695: -- Default = FND_API.G_FALSE
696: -- p_commit VARCHAR2 Optional
697: -- Default = FND_API.G_FALSE
698: -- p_validation_level NUMBER Optional
699: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 697: -- Default = FND_API.G_FALSE

693: -- IN p_api_version NUMBER Required
694: -- p_init_msg_list VARCHAR2 Optional
695: -- Default = FND_API.G_FALSE
696: -- p_commit VARCHAR2 Optional
697: -- Default = FND_API.G_FALSE
698: -- p_validation_level NUMBER Optional
699: -- Default = FND_API.G_VALID_LEVEL_FULL
700: -- p_check_login_user VARCHAR2 Optional
701: -- Default = FND_API.G_TRUE

Line 699: -- Default = FND_API.G_VALID_LEVEL_FULL

695: -- Default = FND_API.G_FALSE
696: -- p_commit VARCHAR2 Optional
697: -- Default = FND_API.G_FALSE
698: -- p_validation_level NUMBER Optional
699: -- Default = FND_API.G_VALID_LEVEL_FULL
700: -- p_check_login_user VARCHAR2 Optional
701: -- Default = FND_API.G_TRUE
702: -- Flag for checking user privilege and if user is login.
703: -- p_item_id NUMBER Required

Line 701: -- Default = FND_API.G_TRUE

697: -- Default = FND_API.G_FALSE
698: -- p_validation_level NUMBER Optional
699: -- Default = FND_API.G_VALID_LEVEL_FULL
700: -- p_check_login_user VARCHAR2 Optional
701: -- Default = FND_API.G_TRUE
702: -- Flag for checking user privilege and if user is login.
703: -- p_item_id NUMBER Required
704: -- The item id to be add the perspectives.
705: -- p_perspective_array AMV_NUMBER_VARRAY_TYPE

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

714: --
715: PROCEDURE Update_ItemPersps
716: (
717: p_api_version IN NUMBER,
718: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
719: p_commit IN VARCHAR2 := FND_API.G_FALSE,
720: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
721: x_return_status OUT NOCOPY VARCHAR2,
722: x_msg_count OUT NOCOPY NUMBER,

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

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

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

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

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

720: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
721: x_return_status OUT NOCOPY VARCHAR2,
722: x_msg_count OUT NOCOPY NUMBER,
723: x_msg_data OUT NOCOPY VARCHAR2,
724: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
725: p_item_id IN NUMBER,
726: p_perspective_array IN AMV_NUMBER_VARRAY_TYPE
727: );
728: --

Line 743: -- Default = FND_API.G_FALSE

739: -- Function : Get all the perspectives for the specified item.
740: -- Parameters :
741: -- IN p_api_version NUMBER Required
742: -- p_init_msg_list VARCHAR2 Optional
743: -- Default = FND_API.G_FALSE
744: -- p_validation_level NUMBER Optional
745: -- Default = FND_API.G_VALID_LEVEL_FULL
746: -- p_check_login_user VARCHAR2 Optional
747: -- Default = FND_API.G_TRUE

Line 745: -- Default = FND_API.G_VALID_LEVEL_FULL

741: -- IN p_api_version NUMBER Required
742: -- p_init_msg_list VARCHAR2 Optional
743: -- Default = FND_API.G_FALSE
744: -- p_validation_level NUMBER Optional
745: -- Default = FND_API.G_VALID_LEVEL_FULL
746: -- p_check_login_user VARCHAR2 Optional
747: -- Default = FND_API.G_TRUE
748: -- Flag for checking user privilege and if user is login.
749: -- p_item_id NUMBER Required

Line 747: -- Default = FND_API.G_TRUE

743: -- Default = FND_API.G_FALSE
744: -- p_validation_level NUMBER Optional
745: -- Default = FND_API.G_VALID_LEVEL_FULL
746: -- p_check_login_user VARCHAR2 Optional
747: -- Default = FND_API.G_TRUE
748: -- Flag for checking user privilege and if user is login.
749: -- p_item_id NUMBER Required
750: -- The item id to be add the perspectives.
751: -- OUT : x_return_status VARCHAR2

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

759: --
760: PROCEDURE Get_ItemPersps
761: (
762: p_api_version IN NUMBER,
763: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
764: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
765: x_return_status OUT NOCOPY VARCHAR2,
766: x_msg_count OUT NOCOPY NUMBER,
767: x_msg_data OUT NOCOPY VARCHAR2,

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

760: PROCEDURE Get_ItemPersps
761: (
762: p_api_version IN NUMBER,
763: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
764: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
765: x_return_status OUT NOCOPY VARCHAR2,
766: x_msg_count OUT NOCOPY NUMBER,
767: x_msg_data OUT NOCOPY VARCHAR2,
768: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,

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

764: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
765: x_return_status OUT NOCOPY VARCHAR2,
766: x_msg_count OUT NOCOPY NUMBER,
767: x_msg_data OUT NOCOPY VARCHAR2,
768: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
769: p_item_id IN NUMBER,
770: x_perspective_obj_varray OUT NOCOPY AMV_PERSPECTIVE_OBJ_VARRAY
771: );
772: --