APPS.IEM_ARCH_MSGDTLS_PVT dependencies on FND_PROFILE

Line 7: G_created_updated_by NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;

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,

Line 8: G_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID') ) ;

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,

Line 67: l_created_updated_by NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));

63: l_msg_data VARCHAR2(2000);
64: i INTEGER;
65:
66: --Changes for Bug no 7293941
67: l_created_updated_by NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
68: L_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID') ) ;
69:
70: BEGIN
71: -- Standard Start of API savepoint

Line 68: L_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID') ) ;

64: i INTEGER;
65:
66: --Changes for Bug no 7293941
67: l_created_updated_by NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
68: L_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID') ) ;
69:
70: BEGIN
71: -- Standard Start of API savepoint
72: SAVEPOINT create_arch_msgdtls_PVT;