3:
4:
5: -- Enter procedure, function bodies as shown below
6: G_PKG_NAME CONSTANT varchar2(30) :='IEM_MSG_ARCHDTLS_PVT ';
7: G_created_updated_by NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
8: G_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID') ) ;
9:
10: PROCEDURE create_item (
11: p_api_version_number IN NUMBER,
4:
5: -- Enter procedure, function bodies as shown below
6: G_PKG_NAME CONSTANT varchar2(30) :='IEM_MSG_ARCHDTLS_PVT ';
7: G_created_updated_by NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
8: G_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID') ) ;
9:
10: PROCEDURE create_item (
11: p_api_version_number IN NUMBER,
12: p_init_msg_list IN VARCHAR2 := null,