1042:
1043: l_param2 VARCHAR2(256);
1044: l_param3 VARCHAR2(256);
1045: l_param_tag VARCHAR2(30);
1046: l_userid NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
1047: l_login NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ;
1048:
1049: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
1050: l_msg_count NUMBER := 0;
1043: l_param2 VARCHAR2(256);
1044: l_param3 VARCHAR2(256);
1045: l_param_tag VARCHAR2(30);
1046: l_userid NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
1047: l_login NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ;
1048:
1049: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
1050: l_msg_count NUMBER := 0;
1051: l_msg_data VARCHAR2(2000);