166: -- value. For example, one could have a record like :
167: -- [BOOKMARK1, STRING, http://www.cnn.com, NULL].
168: --
169: -- 4. The main out parameter for this API is x_return_status which returns
170: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
171: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
172: -- FND_API.G_RETURN_ERROR when the API hits an error
173: --
174: -- *****************************************************************************
167: -- [BOOKMARK1, STRING, http://www.cnn.com, NULL].
168: --
169: -- 4. The main out parameter for this API is x_return_status which returns
170: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
171: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
172: -- FND_API.G_RETURN_ERROR when the API hits an error
173: --
174: -- *****************************************************************************
175: --
168: --
169: -- 4. The main out parameter for this API is x_return_status which returns
170: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
171: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
172: -- FND_API.G_RETURN_ERROR when the API hits an error
173: --
174: -- *****************************************************************************
175: --
176:
175: --
176:
177: PROCEDURE Save_Perz_Data
178: ( p_api_version_number IN NUMBER,
179: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
180: p_commit IN VARCHAR := FND_API.G_FALSE,
181:
182: p_application_id IN NUMBER,
183: p_profile_id IN NUMBER,
176:
177: PROCEDURE Save_Perz_Data
178: ( p_api_version_number IN NUMBER,
179: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
180: p_commit IN VARCHAR := FND_API.G_FALSE,
181:
182: p_application_id IN NUMBER,
183: p_profile_id IN NUMBER,
184: p_profile_name IN VARCHAR2,
264: -- for that value. For example, one could have a record like :
265: -- [BOOKMARK1, STRING, http://www.cnn.com, NULL].
266: --
267: -- 4. The main out parameter for this API is x_return_status which returns
268: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
269: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
270: -- FND_API.G_RETURN_ERROR when the API hits an error
271: -- *******************************************************************************
272:
265: -- [BOOKMARK1, STRING, http://www.cnn.com, NULL].
266: --
267: -- 4. The main out parameter for this API is x_return_status which returns
268: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
269: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
270: -- FND_API.G_RETURN_ERROR when the API hits an error
271: -- *******************************************************************************
272:
273: PROCEDURE Create_Perz_Data
266: --
267: -- 4. The main out parameter for this API is x_return_status which returns
268: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
269: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
270: -- FND_API.G_RETURN_ERROR when the API hits an error
271: -- *******************************************************************************
272:
273: PROCEDURE Create_Perz_Data
274: ( p_api_version_number IN NUMBER,
271: -- *******************************************************************************
272:
273: PROCEDURE Create_Perz_Data
274: ( p_api_version_number IN NUMBER,
275: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
276: p_commit IN VARCHAR := FND_API.G_FALSE,
277:
278: p_application_id IN NUMBER,
279: p_profile_id IN NUMBER,
272:
273: PROCEDURE Create_Perz_Data
274: ( p_api_version_number IN NUMBER,
275: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
276: p_commit IN VARCHAR := FND_API.G_FALSE,
277:
278: p_application_id IN NUMBER,
279: p_profile_id IN NUMBER,
280: p_profile_name IN VARCHAR2,
348: -- 3. The x_data_attrib_tbl holds the output set from the PerzData Attributes.
349: -- This is a table of type JTF_PERZ_DATA_PUB.DATA_ATTRIB_TBL_TYPE.
350: --
351: -- 4. The other out parameter for this API is x_return_status which returns
352: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
353: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
354: -- FND_API.G_RETURN_ERROR when the API hits an error
355: --
356: -- 5. This API will only return one PerzData and it's details.
349: -- This is a table of type JTF_PERZ_DATA_PUB.DATA_ATTRIB_TBL_TYPE.
350: --
351: -- 4. The other out parameter for this API is x_return_status which returns
352: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
353: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
354: -- FND_API.G_RETURN_ERROR when the API hits an error
355: --
356: -- 5. This API will only return one PerzData and it's details.
357: -- If there are more than one retrieved then, this results in an error
350: --
351: -- 4. The other out parameter for this API is x_return_status which returns
352: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
353: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
354: -- FND_API.G_RETURN_ERROR when the API hits an error
355: --
356: -- 5. This API will only return one PerzData and it's details.
357: -- If there are more than one retrieved then, this results in an error
358:
359: -- *****************************************************************************
360:
361: PROCEDURE Get_Perz_Data
362: ( p_api_version_number IN NUMBER,
363: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
364:
365: p_application_id IN NUMBER,
366: p_profile_id IN NUMBER,
367: p_profile_name IN VARCHAR2,
432: -- 3. The x_data_out_tbl holds the output set from the PerzData.
433: -- This is a table of type JTF_PERZ_DATA_PUB.DATA_OUT_TBL_TYPE.
434: --
435: -- 4. The other out parameter for this API is x_return_status which returns
436: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
437: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
438: -- FND_API.G_RETURN_ERROR when the API hits an error
439: --
440: -- *****************************************************************************
433: -- This is a table of type JTF_PERZ_DATA_PUB.DATA_OUT_TBL_TYPE.
434: --
435: -- 4. The other out parameter for this API is x_return_status which returns
436: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
437: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
438: -- FND_API.G_RETURN_ERROR when the API hits an error
439: --
440: -- *****************************************************************************
441:
434: --
435: -- 4. The other out parameter for this API is x_return_status which returns
436: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
437: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
438: -- FND_API.G_RETURN_ERROR when the API hits an error
439: --
440: -- *****************************************************************************
441:
442:
441:
442:
443: PROCEDURE Get_Perz_Data_Summary
444: ( p_api_version_number IN NUMBER,
445: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
446:
447: p_application_id IN NUMBER,
448: p_profile_id IN NUMBER,
449: p_profile_name IN VARCHAR2,
516: -- value. For example, one could have a record like :
517: -- [BOOKMARK1, STRING, http://www.cnn.com, NULL].
518: --
519: -- 5. The main out parameter for this API is x_return_status which returns
520: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
521: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
522: -- FND_API.G_RETURN_ERROR when the API hits an error
523: --
524: -- *****************************************************************************
517: -- [BOOKMARK1, STRING, http://www.cnn.com, NULL].
518: --
519: -- 5. The main out parameter for this API is x_return_status which returns
520: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
521: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
522: -- FND_API.G_RETURN_ERROR when the API hits an error
523: --
524: -- *****************************************************************************
525: --
518: --
519: -- 5. The main out parameter for this API is x_return_status which returns
520: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
521: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
522: -- FND_API.G_RETURN_ERROR when the API hits an error
523: --
524: -- *****************************************************************************
525: --
526:
525: --
526:
527: PROCEDURE Update_Perz_Data
528: ( p_api_version_number IN NUMBER,
529: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
530: p_commit IN VARCHAR := FND_API.G_FALSE,
531:
532: p_application_id IN NUMBER,
533: p_profile_id IN NUMBER,
526:
527: PROCEDURE Update_Perz_Data
528: ( p_api_version_number IN NUMBER,
529: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
530: p_commit IN VARCHAR := FND_API.G_FALSE,
531:
532: p_application_id IN NUMBER,
533: p_profile_id IN NUMBER,
534:
583: -- the application id (p_application_id) and the data id p_perz_data_id are
584: -- required fields.
585: --
586: -- 2. The out parameter for this API is x_return_status which returns
587: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
588: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
589: -- FND_API.G_RETURN_ERROR when the API hits an error
590: --
591: -- *****************************************************************************
584: -- required fields.
585: --
586: -- 2. The out parameter for this API is x_return_status which returns
587: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
588: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
589: -- FND_API.G_RETURN_ERROR when the API hits an error
590: --
591: -- *****************************************************************************
592:
585: --
586: -- 2. The out parameter for this API is x_return_status which returns
587: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
588: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
589: -- FND_API.G_RETURN_ERROR when the API hits an error
590: --
591: -- *****************************************************************************
592:
593: PROCEDURE Delete_Perz_Data
591: -- *****************************************************************************
592:
593: PROCEDURE Delete_Perz_Data
594: ( p_api_version_number IN NUMBER,
595: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
596: p_commit IN VARCHAR := FND_API.G_FALSE,
597:
598: p_application_id IN NUMBER,
599: p_profile_id IN NUMBER,
592:
593: PROCEDURE Delete_Perz_Data
594: ( p_api_version_number IN NUMBER,
595: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
596: p_commit IN VARCHAR := FND_API.G_FALSE,
597:
598: p_application_id IN NUMBER,
599: p_profile_id IN NUMBER,
600: p_perz_data_id IN NUMBER,