APPS.IEM_EMAIL_CATEGORY_MAPS_PVT dependencies on FND_PROFILE

Line 10: p_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

6: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE,
8: p_email_account_id IN NUMBER,
9: p_kb_category_id IN NUMBER,
10: p_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
11: p_CREATION_DATE DATE:=SYSDATE,
12: p_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ,
13: p_LAST_UPDATE_DATE DATE:=SYSDATE,
14: p_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ,

Line 12: p_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ,

8: p_email_account_id IN NUMBER,
9: p_kb_category_id IN NUMBER,
10: p_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
11: p_CREATION_DATE DATE:=SYSDATE,
12: p_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ,
13: p_LAST_UPDATE_DATE DATE:=SYSDATE,
14: p_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ,
15: p_ATTRIBUTE1 VARCHAR2,
16: p_ATTRIBUTE2 VARCHAR2,

Line 14: p_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ,

10: p_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
11: p_CREATION_DATE DATE:=SYSDATE,
12: p_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ,
13: p_LAST_UPDATE_DATE DATE:=SYSDATE,
14: p_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ,
15: p_ATTRIBUTE1 VARCHAR2,
16: p_ATTRIBUTE2 VARCHAR2,
17: p_ATTRIBUTE3 VARCHAR2,
18: p_ATTRIBUTE4 VARCHAR2,

Line 37: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));

33: ) is
34: l_api_name VARCHAR2(255):='create_item';
35: l_api_version_number NUMBER:=1.0;
36: l_cnt number;
37: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
38: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
39: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
40: BEGIN
41: -- Standard Start of API savepoint

Line 38: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;

34: l_api_name VARCHAR2(255):='create_item';
35: l_api_version_number NUMBER:=1.0;
36: l_cnt number;
37: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
38: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
39: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
40: BEGIN
41: -- Standard Start of API savepoint
42: SAVEPOINT create_item_PVT;

Line 39: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;

35: l_api_version_number NUMBER:=1.0;
36: l_cnt number;
37: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
38: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
39: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
40: BEGIN
41: -- Standard Start of API savepoint
42: SAVEPOINT create_item_PVT;
43: -- Standard call to check for call compatibility.