APPS.IEM_EMTA_ADMIN_PVT dependencies on IEM_MSTEMAIL_ACCOUNTS

Line 229: select count(*) into l_count from iem_mstemail_accounts where email_account_id=p_email_acct_id;

225:
226:
227: elsif ( p_action = 'update' ) then
228:
229: select count(*) into l_count from iem_mstemail_accounts where email_account_id=p_email_acct_id;
230:
231: if ( l_count = 0 ) then
232: raise IEM_ACCOUT_ID_NOT_EXIST;
233: end if;

Line 370: logMessage := '[Email Account Id does not exist in IEM_MSTEMAIL_ACCOUNTS!]';

366: FND_MSG_PUB.ADD;
367: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
368:
369: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
370: logMessage := '[Email Account Id does not exist in IEM_MSTEMAIL_ACCOUNTS!]';
371: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'IEM.PLSQL.IEM_EMTA_ADMIN_PVT.UPDATE_DP_CONFIG_DATA_WRAP', logMessage);
372: end if;
373: WHEN FND_API.G_EXC_ERROR THEN
374: ROLLBACK TO UPDATE_DP_CONFIG_DATA_WRAP_PVT;

Line 605: account_rec IEM_MSTEMAIL_ACCOUNTS%ROWTYPE;

601:
602: l_acct_info acct_info_tbl;
603: l_count number;
604: Y number;
605: account_rec IEM_MSTEMAIL_ACCOUNTS%ROWTYPE;
606:
607: e_nowait EXCEPTION;
608: PRAGMA EXCEPTION_INIT(e_nowait, -54);
609:

Line 645: from iem_mstemail_accounts where email_account_id=x.email_account_id;

641: update IEM_EMTA_CONFIG_PARAMS set FLAG='A', LAST_UPDATE_DATE=SYSDATE
642: where emta_config_param_id=x.emta_config_param_id;
643:
644: select count(*) into l_count
645: from iem_mstemail_accounts where email_account_id=x.email_account_id;
646:
647: if ( l_count = 0 ) then
648: delete IEM_EMTA_CONFIG_PARAMS where emta_config_param_id=x.emta_config_param_id;
649: else

Line 652: from iem_mstemail_accounts where email_account_id=x.email_account_id;

648: delete IEM_EMTA_CONFIG_PARAMS where emta_config_param_id=x.emta_config_param_id;
649: else
650:
651: select * into account_rec
652: from iem_mstemail_accounts where email_account_id=x.email_account_id;
653:
654: l_acct_info(Y).account_id := x.email_account_id;
655: l_acct_info(Y).action := x.action_type;
656: l_acct_info(Y).update_flag := x.account_update_flag;

Line 717: account_rec IEM_MSTEMAIL_ACCOUNTS%ROWTYPE;

713: l_api_version_number number:=1.0;
714:
715: l_acct_info acct_info_tbl;
716: Y number;
717: account_rec IEM_MSTEMAIL_ACCOUNTS%ROWTYPE;
718:
719: e_nowait EXCEPTION;
720: PRAGMA EXCEPTION_INIT(e_nowait, -54);
721:

Line 809: from iem_mstemail_accounts where email_account_id = p_email_account_id ;

805:
806: --select active_flag, user_name, user_password, encrypt_key, in_host, in_port
807: select active_flag, user_name, in_host, in_port
808: into l_active_flag, l_user_name, l_in_host, l_in_port
809: from iem_mstemail_accounts where email_account_id = p_email_account_id ;
810:
811: /*
812: IEM_UTILS_PVT.IEM_DecryptPassword(
813: p_api_version_number =>1.0,

Line 942: from iem_mstemail_accounts where email_account_id = p_email_account_id ;

938:
939: --select active_flag, user_name, user_password, encrypt_key, in_host, in_port
940: select active_flag, user_name, in_host, in_port
941: into l_active_flag, l_user_name, l_in_host, l_in_port
942: from iem_mstemail_accounts where email_account_id = p_email_account_id ;
943:
944: if ( l_active_flag <> P_ACTIVE_FLAG ) then
945: l_data_changed := 'Y';
946: end if;