DBA Data[Home] [Help]

APPS.JTF_PERZ_PROFILE_PUB dependencies on FND_API

Line 53: ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM,

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

Line 54: PROFILE_ID NUMBER := FND_API.G_MISS_NUM,

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: );

Line 55: PROFILE_ATTRIBUTE VARCHAR2(100) := FND_API.G_MISS_CHAR,

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:

Line 56: ATTRIBUTE_TYPE VARCHAR2(100) := FND_API.G_MISS_CHAR,

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

Line 57: ATTRIBUTE_VALUE VARCHAR2(100) := FND_API.G_MISS_CHAR

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: --

Line 161: -- FND_API.G_RETURN_SUCCESS when the API completes successfully

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: -- *****************************************************************************

Line 162: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state

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: --

Line 163: -- FND_API.G_RETURN_ERROR when the API hits an error

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:

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

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,

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

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,

Line 226: -- FND_API.G_RETURN_SUCCESS when the API completes successfully

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: -- *****************************************************************************

Line 227: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state

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: --

Line 228: -- FND_API.G_RETURN_ERROR when the API hits an error

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:

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

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,

Line 297: -- FND_API.G_RETURN_SUCCESS when the API completes successfully

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: -- *****************************************************************************

Line 298: -- FND_API.G_RETURN_UNEXPECTED when the API reaches a unxpected state

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: --

Line 299: -- FND_API.G_RETURN_ERROR when the API hits an error

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:

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

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,

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

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,