DBA Data[Home] [Help]

APPS.IEM_KB_CATEGORIES_PVT dependencies on FND_PROFILE

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

12: p_category_code IN VARCHAR2,
13: p_is_repos IN VARCHAR2,
14: p_category_order IN NUMBER,
15: p_category_desc IN varchar2,
16: p_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
17: p_CREATION_DATE DATE:=SYSDATE,
18: p_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ,
19: p_LAST_UPDATE_DATE DATE:=SYSDATE,
20: p_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ,

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

14: p_category_order IN NUMBER,
15: p_category_desc IN varchar2,
16: p_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
17: p_CREATION_DATE DATE:=SYSDATE,
18: p_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ,
19: p_LAST_UPDATE_DATE DATE:=SYSDATE,
20: p_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ,
21: p_ATTRIBUTE1 VARCHAR2,
22: p_ATTRIBUTE2 VARCHAR2,

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

16: p_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
17: p_CREATION_DATE DATE:=SYSDATE,
18: p_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ,
19: p_LAST_UPDATE_DATE DATE:=SYSDATE,
20: p_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ,
21: p_ATTRIBUTE1 VARCHAR2,
22: p_ATTRIBUTE2 VARCHAR2,
23: p_ATTRIBUTE3 VARCHAR2,
24: p_ATTRIBUTE4 VARCHAR2,

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

40: l_api_name VARCHAR2(255):='create_item';
41: l_api_version_number NUMBER:=1.0;
42: l_seq_id number;
43: l_grp_cnt number;
44: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
45: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
46: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
47:
48: BEGIN

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

41: l_api_version_number NUMBER:=1.0;
42: l_seq_id number;
43: l_grp_cnt number;
44: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
45: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
46: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
47:
48: BEGIN
49: -- Standard Start of API savepoint

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

42: l_seq_id number;
43: l_grp_cnt number;
44: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
45: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
46: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
47:
48: BEGIN
49: -- Standard Start of API savepoint
50: SAVEPOINT create_item_PVT;

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

284: x_msg_data OUT NOCOPY VARCHAR2
285: ) is
286: l_api_name VARCHAR2(255):='update_item';
287: l_api_version_number NUMBER:=1.0;
288: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
289: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
290:
291: BEGIN
292: -- Standard Start of API savepoint

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

285: ) is
286: l_api_name VARCHAR2(255):='update_item';
287: l_api_version_number NUMBER:=1.0;
288: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
289: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
290:
291: BEGIN
292: -- Standard Start of API savepoint
293: SAVEPOINT update_item_PVT;