DBA Data[Home] [Help]

APPS.IEM_RT_PREPROC_EMAILS_PVT dependencies on FND_PROFILE

Line 22: l_CREATED_BY NUMBER := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

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

Line 24: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_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

Line 26: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;

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,