APPS.IEM_DPM_PP_QUEUE_PVT dependencies on IEM_MIGRATION_DETAILS

Line 44: select folder_type, count(*) total from iem_migration_details

40: l_folder_type varchar2(1);
41:
42:
43: cursor c_folder_types is
44: select folder_type, count(*) total from iem_migration_details
45: where folder_status='R'
46: group by folder_type
47: order by decode(folder_type,'H',1,
48: 'N',2,

Line 57: from iem_email_accounts a, iem_email_servers b, iem_migration_details c,

53:
54: cursor c_folder_details( p_type varchar2) is
55: select a.email_account_id,a.email_user||'@'||a.domain as user_name,
56: a.email_password,b.dns_name, b.port, c.migration_id, c.folder_name
57: from iem_email_accounts a, iem_email_servers b, iem_migration_details c,
58: iem_server_groups d, iem_email_server_types e
59: where ( c.folder_status='R' )
60: and c.folder_type= p_type and c.email_account_id=a.email_account_id
61: and a.server_group_id=d.server_group_id

Line 70: iem_migration_details c, iem_email_servers d, iem_server_groups e,

66: cursor c_agent_folder_details( p_type varchar2) is
67: select c.email_account_id,a.email_user||'@'||a.domain as user_name,
68: a.email_password,d.dns_name, d.port, c.migration_id, c.folder_name
69: from iem_agent_accounts a, iem_email_accounts b,
70: iem_migration_details c, iem_email_servers d, iem_server_groups e,
71: iem_email_server_types f
72: where ( c.folder_status='R' )
73: and c.folder_type= p_type and c.email_account_id=a.email_account_id
74: and c.agent_account_id=a.agent_account_id

Line 107: update iem_migration_details a set a.folder_status='D', a.last_update_date=sysdate, a.msg_download_count=

103:
104: --begins here
105:
106: -- first update the Flder_status for all finished account
107: update iem_migration_details a set a.folder_status='D', a.last_update_date=sysdate, a.msg_download_count=
108: (select count(*) from iem_migration_store_temp
109: where dp_status='D' and migration_id = a.migration_id)
110: where a.folder_status='R' and a.msg_record_count =
111: ( (select count(*) from iem_migration_store_temp

Line 117: update iem_migration_details a set a.last_update_date=sysdate, a.msg_download_count=

113: +
114: ( select count(*) from iem_migration_store_temp
115: where dp_status='E' and migration_id = a.migration_id));
116:
117: update iem_migration_details a set a.last_update_date=sysdate, a.msg_download_count=
118: (select count(*) from iem_migration_store_temp
119: where dp_status='D' and migration_id = a.migration_id)
120: where a.folder_status='R';
121:

Line 464: update iem_migration_details set status='E', status_text=l_error

460: where mail_id=p_mail_ids(i);
461:
462: end loop;
463:
464: update iem_migration_details set status='E', status_text=l_error
465: where migration_id=p_migration_id;
466:
467:
468: -- Standard Check Of p_commit.