APPS.IEM_DP_MONITORING_PVT dependencies on IEM_DP_ACCT_STATUS

Line 77: SELECT IEM_DP_ACCT_STATUS_S1.nextval

73:
74: --begins here
75:
76: --get next sequential number
77: SELECT IEM_DP_ACCT_STATUS_S1.nextval
78: INTO l_seq_id
79: FROM dual;
80:
81: INSERT INTO IEM_DP_ACCT_STATUS

Line 81: INSERT INTO IEM_DP_ACCT_STATUS

77: SELECT IEM_DP_ACCT_STATUS_S1.nextval
78: INTO l_seq_id
79: FROM dual;
80:
81: INSERT INTO IEM_DP_ACCT_STATUS
82: (
83: DP_ACCT_STATUS_ID,
84: EMAIL_ACCOUNT_ID,
85: INBOX_MSG_COUNT,

Line 204: select count(DP_ACCT_STATUS_ID) into l_count from IEM_DP_ACCT_STATUS where email_account_id=p_acct_id;

200: x_return_status := FND_API.G_RET_STS_SUCCESS;
201:
202: --begins here
203:
204: select count(DP_ACCT_STATUS_ID) into l_count from IEM_DP_ACCT_STATUS where email_account_id=p_acct_id;
205:
206: --Check if account record already exist,
207: -- if existed, updated record
208: -- else create new records.

Line 226: update IEM_DP_ACCT_STATUS set LAST_UPDATE_DATE = sysdate where email_account_id=P_acct_id;

222: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
223: x_return_status := FND_API.G_RET_STS_ERROR;
224: end if;
225: else
226: update IEM_DP_ACCT_STATUS set LAST_UPDATE_DATE = sysdate where email_account_id=P_acct_id;
227: end if;
228: else
229: IEM_DP_MONITORING_PVT.create_dp_acct_status(
230: p_api_version_number => P_Api_Version_Number,

Line 337: UPDATE IEM_DP_ACCT_STATUS

333: x_return_status := FND_API.G_RET_STS_SUCCESS;
334:
335: --begins here
336:
337: UPDATE IEM_DP_ACCT_STATUS
338: set
339: INBOX_MSG_COUNT = P_INBOX_COUNT,
340: PROCESSED_MSG_COUNT = P_PROCESSED_COUNT,
341: RETRY_MSG_COUNT = P_RETRY_COUNT,

Line 827: from iem_mstemail_accounts a, iem_dp_acct_status b, fnd_lookups fl

823: select a.email_account_id, a.email_address, a.active_flag, fl.meaning as account_status,
824: b.last_update_date as processor_status, b.last_update_date as last_run_time,
825: b.inbox_msg_count, b.processed_msg_count, b.retry_msg_count,
826: (select count(*) from iem_dp_logs where email_account_id = a.email_account_id) as log
827: from iem_mstemail_accounts a, iem_dp_acct_status b, fnd_lookups fl
828: where a.email_account_id = b.email_account_id
829: and a.active_flag=fl.lookup_code and fl.lookup_type='IEM_ACCOUNT_STATUS'
830: and a.active_flag='Y' and a.deleted_flag='N'
831: order by a.email_address desc;

Line 839: from iem_mstemail_accounts a, iem_dp_acct_status b,fnd_lookups fl

835: select a.email_account_id, a.email_address, a.active_flag, fl.meaning as account_status,
836: b.last_update_date as processor_status, b.last_update_date as last_run_time,
837: b.inbox_msg_count, b.processed_msg_count, b.retry_msg_count,
838: (select count(*) from iem_dp_logs where email_account_id = a.email_account_id) as log
839: from iem_mstemail_accounts a, iem_dp_acct_status b,fnd_lookups fl
840: where a.email_account_id = b.email_account_id(+) and a.deleted_flag='N'
841: and a.active_flag<>'M'
842: and a.active_flag=fl.lookup_code and fl.lookup_type='IEM_ACCOUNT_STATUS'
843: order by a.email_address desc;