49:
50:
51: TYPE PROFILE_ATTRIB_REC_TYPE IS RECORD (
52:
53: ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM,
54: PROFILE_ID NUMBER := FND_API.G_MISS_NUM,
55: PROFILE_ATTRIBUTE VARCHAR2(100) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE_TYPE VARCHAR2(100) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE_VALUE VARCHAR2(100) := FND_API.G_MISS_CHAR
50:
51: TYPE PROFILE_ATTRIB_REC_TYPE IS RECORD (
52:
53: ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM,
54: PROFILE_ID NUMBER := FND_API.G_MISS_NUM,
55: PROFILE_ATTRIBUTE VARCHAR2(100) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE_TYPE VARCHAR2(100) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE_VALUE VARCHAR2(100) := FND_API.G_MISS_CHAR
58: );
51: TYPE PROFILE_ATTRIB_REC_TYPE IS RECORD (
52:
53: ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM,
54: PROFILE_ID NUMBER := FND_API.G_MISS_NUM,
55: PROFILE_ATTRIBUTE VARCHAR2(100) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE_TYPE VARCHAR2(100) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE_VALUE VARCHAR2(100) := FND_API.G_MISS_CHAR
58: );
59:
52:
53: ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM,
54: PROFILE_ID NUMBER := FND_API.G_MISS_NUM,
55: PROFILE_ATTRIBUTE VARCHAR2(100) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE_TYPE VARCHAR2(100) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE_VALUE VARCHAR2(100) := FND_API.G_MISS_CHAR
58: );
59:
60: -- Start of Comments
53: ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM,
54: PROFILE_ID NUMBER := FND_API.G_MISS_NUM,
55: PROFILE_ATTRIBUTE VARCHAR2(100) := FND_API.G_MISS_CHAR,
56: ATTRIBUTE_TYPE VARCHAR2(100) := FND_API.G_MISS_CHAR,
57: ATTRIBUTE_VALUE VARCHAR2(100) := FND_API.G_MISS_CHAR
58: );
59:
60: -- Start of Comments
61: --
157: -- [PERSONALIZATION, 235, USER_ID]. this essentially says that the attribute is
158: -- for the user with id 235 and used for personalization.
159: --
160: -- 5. The main out parameter for this API is x_return_status which returns
161: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
162: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
163: -- FND_API.G_RETURN_ERROR when the API hits an error
164: --
165: -- *****************************************************************************
158: -- for the user with id 235 and used for personalization.
159: --
160: -- 5. The main out parameter for this API is x_return_status which returns
161: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
162: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
163: -- FND_API.G_RETURN_ERROR when the API hits an error
164: --
165: -- *****************************************************************************
166: --
159: --
160: -- 5. The main out parameter for this API is x_return_status which returns
161: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
162: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
163: -- FND_API.G_RETURN_ERROR when the API hits an error
164: --
165: -- *****************************************************************************
166: --
167:
166: --
167:
168: PROCEDURE Create_Profile
169: ( p_api_version_number IN NUMBER,
170: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
171: p_commit IN VARCHAR2 := FND_API.G_FALSE,
172: p_profile_id IN NUMBER,
173: p_profile_name IN VARCHAR2 := NULL,
174: p_profile_type IN VARCHAR2 := NULL,
167:
168: PROCEDURE Create_Profile
169: ( p_api_version_number IN NUMBER,
170: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
171: p_commit IN VARCHAR2 := FND_API.G_FALSE,
172: p_profile_id IN NUMBER,
173: p_profile_name IN VARCHAR2 := NULL,
174: p_profile_type IN VARCHAR2 := NULL,
175: p_profile_desc IN VARCHAR2 := NULL,
222: -- 2. The x_profile_tbl holds the output set from the query. this is a table of type
223: -- JTF_PERZ_PROFILE_PUB.PROFILE_OUT_TBL.
224: --
225: -- 2. The other out parameter for this API is x_return_status which returns
226: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
227: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
228: -- FND_API.G_RETURN_ERROR when the API hits an error
229: --
230: -- *****************************************************************************
223: -- JTF_PERZ_PROFILE_PUB.PROFILE_OUT_TBL.
224: --
225: -- 2. The other out parameter for this API is x_return_status which returns
226: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
227: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
228: -- FND_API.G_RETURN_ERROR when the API hits an error
229: --
230: -- *****************************************************************************
231: --
224: --
225: -- 2. The other out parameter for this API is x_return_status which returns
226: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
227: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
228: -- FND_API.G_RETURN_ERROR when the API hits an error
229: --
230: -- *****************************************************************************
231: --
232:
232:
233:
234: PROCEDURE Get_Profile
235: ( p_api_version_number IN NUMBER,
236: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
237:
238: p_profile_id IN NUMBER,
239: p_profile_name IN VARCHAR2,
240: p_profile_type IN VARCHAR2,
293: -- update. if an attribute being sent in does not exist another attribute is inserted
294: -- against the existing profile.
295: --
296: -- 5. The main out parameter for this API are x_profile_id and x_return_status which returns
297: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
298: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
299: -- FND_API.G_RETURN_ERROR when the API hits an error
300: --
301: -- *****************************************************************************
294: -- against the existing profile.
295: --
296: -- 5. The main out parameter for this API are x_profile_id and x_return_status which returns
297: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
298: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
299: -- FND_API.G_RETURN_ERROR when the API hits an error
300: --
301: -- *****************************************************************************
302: --
295: --
296: -- 5. The main out parameter for this API are x_profile_id and x_return_status which returns
297: -- FND_API.G_RETURN_SUCCESS when the API completes successfully
298: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state
299: -- FND_API.G_RETURN_ERROR when the API hits an error
300: --
301: -- *****************************************************************************
302: --
303:
302: --
303:
304: PROCEDURE Update_Profile
305: ( p_api_version_number IN NUMBER,
306: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
307: p_commit IN VARCHAR2 := FND_API.G_FALSE,
308:
309: p_profile_id IN NUMBER,
310: p_profile_name IN VARCHAR2,
303:
304: PROCEDURE Update_Profile
305: ( p_api_version_number IN NUMBER,
306: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
307: p_commit IN VARCHAR2 := FND_API.G_FALSE,
308:
309: p_profile_id IN NUMBER,
310: p_profile_name IN VARCHAR2,
311: p_profile_type IN VARCHAR2,