eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEM_EMAIL_SERVERS_PVT dependencies on FND_PROFILE

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

41: l_es_count number:=0;
42: l_seq_id number;
43: l_grp_cnt number;
44: l_type_cnt number;
45: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
46: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
47: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
48:
49: IEM_DUP_EMAIL_SERVER EXCEPTION;

Line 46: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;

42: l_seq_id number;
43: l_grp_cnt number;
44: l_type_cnt number;
45: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
46: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
47: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
48:
49: IEM_DUP_EMAIL_SERVER EXCEPTION;
50: IEM_NON_EXISTENT_SERVER_GRP EXCEPTION;

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

43: l_grp_cnt number;
44: l_type_cnt number;
45: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
46: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
47: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
48:
49: IEM_DUP_EMAIL_SERVER EXCEPTION;
50: IEM_NON_EXISTENT_SERVER_GRP EXCEPTION;
51:

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

253: l_count number;
254: l_email_server_id number;
255: l_data varchar2(300);
256: l_email_server_type varchar2(20);
257: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
258: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
259: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
260:
261: EXCP_EMAIL_SERVER EXCEPTION;

Line 258: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;

254: l_email_server_id number;
255: l_data varchar2(300);
256: l_email_server_type varchar2(20);
257: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
258: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
259: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
260:
261: EXCP_EMAIL_SERVER EXCEPTION;
262:

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

255: l_data varchar2(300);
256: l_email_server_type varchar2(20);
257: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
258: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
259: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
260:
261: EXCP_EMAIL_SERVER EXCEPTION;
262:
263: BEGIN

Line 294: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

290: p_port => p_port,
291: p_server_type_id => p_server_type_id,
292: p_rt_availability => p_rt_availability,
293: p_server_group_id => p_server_group_id,
294: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
295: p_CREATION_DATE =>SYSDATE,
296: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
297: p_LAST_UPDATE_DATE =>SYSDATE,
298: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,

Line 296: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

292: p_rt_availability => p_rt_availability,
293: p_server_group_id => p_server_group_id,
294: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
295: p_CREATION_DATE =>SYSDATE,
296: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
297: p_LAST_UPDATE_DATE =>SYSDATE,
298: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
299: p_ATTRIBUTE1 =>null,
300: p_ATTRIBUTE2 =>null,

Line 298: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,

294: p_CREATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
295: p_CREATION_DATE =>SYSDATE,
296: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
297: p_LAST_UPDATE_DATE =>SYSDATE,
298: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
299: p_ATTRIBUTE1 =>null,
300: p_ATTRIBUTE2 =>null,
301: p_ATTRIBUTE3 =>null,
302: p_ATTRIBUTE4 =>null,

Line 519: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;

515: l_api_version_number NUMBER:=1.0;
516: l_es_count NUMBER:=0;
517: l_type_cnt NUMBER;
518: l_grp_cnt NUMBER;
519: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
520: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
521: IEM_DUP_EMAIL_SERVER EXCEPTION;
522: IEM_NON_EXISTENT_SERVER_GRP EXCEPTION;
523:

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

516: l_es_count NUMBER:=0;
517: l_type_cnt NUMBER;
518: l_grp_cnt NUMBER;
519: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
520: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
521: IEM_DUP_EMAIL_SERVER EXCEPTION;
522: IEM_NON_EXISTENT_SERVER_GRP EXCEPTION;
523:
524: BEGIN

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

721: l_count number;
722: l_data varchar2(300);
723: l_email_server_id number;
724: l_email_server_type varchar2(20);
725: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
726: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
727: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
728:
729: EXCP_EMAIL_SERVER EXCEPTION;

Line 726: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;

722: l_data varchar2(300);
723: l_email_server_id number;
724: l_email_server_type varchar2(20);
725: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
726: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
727: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
728:
729: EXCP_EMAIL_SERVER EXCEPTION;
730:

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

723: l_email_server_id number;
724: l_email_server_type varchar2(20);
725: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
726: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
727: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
728:
729: EXCP_EMAIL_SERVER EXCEPTION;
730:
731: BEGIN

Line 763: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),

759: p_port => p_port,
760: p_server_type_id => p_server_type_id,
761: p_rt_availability => p_rt_availability,
762: p_server_group_id => p_server_group_id,
763: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
764: p_LAST_UPDATE_DATE =>SYSDATE,
765: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
766: p_ATTRIBUTE1 =>null,
767: p_ATTRIBUTE2 =>null,

Line 765: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,

761: p_rt_availability => p_rt_availability,
762: p_server_group_id => p_server_group_id,
763: p_LAST_UPDATED_BY =>TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),
764: p_LAST_UPDATE_DATE =>SYSDATE,
765: p_LAST_UPDATE_LOGIN=>TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ,
766: p_ATTRIBUTE1 =>null,
767: p_ATTRIBUTE2 =>null,
768: p_ATTRIBUTE3 =>null,
769: p_ATTRIBUTE4 =>null,