18: l_api_version_number NUMBER:=1.0;
19: l_seq_id number;
20: l_grp_cnt number;
21: l_message_id number;
22: l_CREATED_BY NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
23: l_creation_date date := SYSDATE;
24: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
25: l_LAST_UPDATE_DATE DATE:=SYSDATE;
26: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
20: l_grp_cnt number;
21: l_message_id number;
22: l_CREATED_BY NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
23: l_creation_date date := SYSDATE;
24: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
25: l_LAST_UPDATE_DATE DATE:=SYSDATE;
26: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
27:
28: BEGIN
22: l_CREATED_BY NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
23: l_creation_date date := SYSDATE;
24: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
25: l_LAST_UPDATE_DATE DATE:=SYSDATE;
26: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
27:
28: BEGIN
29: -- Standard call to check for call compatibility.
30: IF NOT FND_API.Compatible_API_Call (l_api_version_number,