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_MIGRATION_PVT dependencies on FND_PROFILE

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

44: l_status_text varchar2(1000);
45: l_ack_flag number:=0;
46: cursor c_agent is select agent_account_id,resource_id from iem_agent_accounts
47: where email_account_id= l_email_account_id;
48: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
49: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
50: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
51: l_mig_id number;
52: l_logmessage varchar2(1000);

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

45: l_ack_flag number:=0;
46: cursor c_agent is select agent_account_id,resource_id from iem_agent_accounts
47: where email_account_id= l_email_account_id;
48: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
49: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
50: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
51: l_mig_id number;
52: l_logmessage varchar2(1000);
53: x_folder_tbl jtf_varchar2_table_100:=jtf_varchar2_table_100() ;

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

46: cursor c_agent is select agent_account_id,resource_id from iem_agent_accounts
47: where email_account_id= l_email_account_id;
48: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
49: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
50: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
51: l_mig_id number;
52: l_logmessage varchar2(1000);
53: x_folder_tbl jtf_varchar2_table_100:=jtf_varchar2_table_100() ;
54: Type get_folder_data is REF CURSOR;

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

216: l_contact_id number;
217: l_resource_id number;
218: l_relationship_id number;
219: l_party_id number;
220: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
221: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
222: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
223: l_proc_status varchar2(100);
224: l_mail_type number;

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

217: l_resource_id number;
218: l_relationship_id number;
219: l_party_id number;
220: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
221: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
222: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
223: l_proc_status varchar2(100);
224: l_mail_type number;
225: l_received_Date date;

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

218: l_relationship_id number;
219: l_party_id number;
220: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
221: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
222: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
223: l_proc_status varchar2(100);
224: l_mail_type number;
225: l_received_Date date;
226: l_folder_type varchar2(10);

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

458: x_priority number;
459: l_read number;
460: l_expiration date;
461: l_ret number;
462: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
463: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
464: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
465: l_hist_date date;
466: l_hist_count number;

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

459: l_read number;
460: l_expiration date;
461: l_ret number;
462: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
463: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
464: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
465: l_hist_date date;
466: l_hist_count number;
467: l_mig_status varchar2(1);

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

460: l_expiration date;
461: l_ret number;
462: l_CREATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID'));
463: l_LAST_UPDATED_BY NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('USER_ID')) ;
464: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
465: l_hist_date date;
466: l_hist_count number;
467: l_mig_status varchar2(1);
468: l_content blob;

Line 1374: l_created_by:=nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1);

1370: cursor c_rule is select email_user,domain from iem_email_accounts
1371: where upper(email_user) not in ('ACKNOWLEDGEMENTS');
1372: begin
1373: -- Migrate Email Account Config Data
1374: l_created_by:=nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1);
1375: l_LAST_UPDATED_BY:=nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1);
1376: l_last_update_login:=nvl(TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')),-1);
1377: for v1 in c_account LOOP
1378: l_email_Account_id:=v1.email_account_id;

Line 1375: l_LAST_UPDATED_BY:=nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1);

1371: where upper(email_user) not in ('ACKNOWLEDGEMENTS');
1372: begin
1373: -- Migrate Email Account Config Data
1374: l_created_by:=nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1);
1375: l_LAST_UPDATED_BY:=nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1);
1376: l_last_update_login:=nvl(TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')),-1);
1377: for v1 in c_account LOOP
1378: l_email_Account_id:=v1.email_account_id;
1379: l_acct_language:=v1.acct_language;

Line 1376: l_last_update_login:=nvl(TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')),-1);

1372: begin
1373: -- Migrate Email Account Config Data
1374: l_created_by:=nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1);
1375: l_LAST_UPDATED_BY:=nvl(TO_NUMBER (FND_PROFILE.VALUE('USER_ID')),-1);
1376: l_last_update_login:=nvl(TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')),-1);
1377: for v1 in c_account LOOP
1378: l_email_Account_id:=v1.email_account_id;
1379: l_acct_language:=v1.acct_language;
1380: l_template_profile:=to_number(FND_PROFILE.VALUE_SPECIFIC('IEM_TEMPLATE_CATEGORY_ID')) ;

Line 1380: l_template_profile:=to_number(FND_PROFILE.VALUE_SPECIFIC('IEM_TEMPLATE_CATEGORY_ID')) ;

1376: l_last_update_login:=nvl(TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')),-1);
1377: for v1 in c_account LOOP
1378: l_email_Account_id:=v1.email_account_id;
1379: l_acct_language:=v1.acct_language;
1380: l_template_profile:=to_number(FND_PROFILE.VALUE_SPECIFIC('IEM_TEMPLATE_CATEGORY_ID')) ;
1381: select to_number(decode(FND_PROFILE.VALUE_SPECIFIC('IEM_ACCOUNT_SENDER_NAME'),'ACCOUNT',0,1)) into
1382: l_sender_profile from dual;
1383: select dns_name,port
1384: into l_in_host,l_in_port

Line 1381: select to_number(decode(FND_PROFILE.VALUE_SPECIFIC('IEM_ACCOUNT_SENDER_NAME'),'ACCOUNT',0,1)) into

1377: for v1 in c_account LOOP
1378: l_email_Account_id:=v1.email_account_id;
1379: l_acct_language:=v1.acct_language;
1380: l_template_profile:=to_number(FND_PROFILE.VALUE_SPECIFIC('IEM_TEMPLATE_CATEGORY_ID')) ;
1381: select to_number(decode(FND_PROFILE.VALUE_SPECIFIC('IEM_ACCOUNT_SENDER_NAME'),'ACCOUNT',0,1)) into
1382: l_sender_profile from dual;
1383: select dns_name,port
1384: into l_in_host,l_in_port
1385: from iem_email_servers a,iem_email_server_types b

Line 1432: l_sc_lang:=FND_PROFILE.VALUE('IEM_SC_DEFAULT_LANG');

1428: l_deleted_flag:='N';
1429: end if;
1430: begin
1431: if v1.sc_lang is null then
1432: l_sc_lang:=FND_PROFILE.VALUE('IEM_SC_DEFAULT_LANG');
1433: else
1434: l_sc_lang:=v1.sc_lang;
1435: end if;
1436: exception when others then -- just incase the 1159 column is not present.

Line 1437: l_sc_lang:=FND_PROFILE.VALUE('IEM_SC_DEFAULT_LANG');

1433: else
1434: l_sc_lang:=v1.sc_lang;
1435: end if;
1436: exception when others then -- just incase the 1159 column is not present.
1437: l_sc_lang:=FND_PROFILE.VALUE('IEM_SC_DEFAULT_LANG');
1438: end;
1439: insert into iem_mstemail_accounts
1440: (EMAIL_ACCOUNT_ID,
1441: EMAIL_ADDRESS ,