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')) ,
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,
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,
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
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
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;
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
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;