APPS.IEM_DPM_PP_QUEUE_PVT dependencies on IEM_MIGRATION_STORE_TEMP

Line 108: (select count(*) from iem_migration_store_temp

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
112: where dp_status='D' and migration_id = a.migration_id)

Line 111: ( (select count(*) from iem_migration_store_temp

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
112: where dp_status='D' and migration_id = a.migration_id)
113: +
114: ( select count(*) from iem_migration_store_temp
115: where dp_status='E' and migration_id = a.migration_id));

Line 114: ( select count(*) from iem_migration_store_temp

110: where a.folder_status='R' and a.msg_record_count =
111: ( (select count(*) from iem_migration_store_temp
112: where dp_status='D' and migration_id = a.migration_id)
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

Line 118: (select count(*) from iem_migration_store_temp

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:
122: x := 1;

Line 134: select count(*) into l_available from iem_migration_store_temp

130: if ( l_folder_type='I' or l_folder_type='D' ) then
131:
132: FOR v_agent_folder_details IN c_agent_folder_details(l_folder_type) LOOP
133:
134: select count(*) into l_available from iem_migration_store_temp
135: where migration_id=v_agent_folder_details.migration_id
136: and mig_status<>'E' and dp_status is null;
137:
138: if ( l_available > 0 ) then

Line 162: select count(*) into l_available from iem_migration_store_temp

158: end if;
159: else
160: FOR v_folder_details IN c_folder_details(l_folder_type) LOOP
161:
162: select count(*) into l_available from iem_migration_store_temp
163: where migration_id=v_folder_details.migration_id
164: and mig_status<>'E' and dp_status is null;
165:
166: if ( l_available > 0 ) then

Line 272: l_queue_rec iem_migration_store_temp%rowtype;

268: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
269: l_msg_count NUMBER := 0;
270: l_msg_data VARCHAR2(2000);
271:
272: l_queue_rec iem_migration_store_temp%rowtype;
273: l_batch number;
274: i number;
275: l_mail_ids JTF_NUMBER_TABLE := jtf_number_Table();
276: l_msg_uids JTF_NUMBER_TABLE := jtf_number_Table();

Line 312: from iem_migration_store_temp

308:
309: i := 1;
310:
311: for y in ( select mail_id
312: from iem_migration_store_temp
313: where migration_id=p_migration_id and mig_status<>'E'and dp_status is null
314: order by creation_date asc )
315: loop
316:

Line 319: select * into l_queue_rec from iem_migration_store_temp

315: loop
316:
317: BEGIN
318:
319: select * into l_queue_rec from iem_migration_store_temp
320: where migration_id=p_migration_id and mig_status<>'E' and dp_status is null
321: and mail_id=y.mail_id
322: FOR UPDATE NOWAIT;
323:

Line 336: update iem_migration_store_temp set dp_status ='A', last_update_date=sysdate

332: l_msg_uids(i) := l_queue_rec.msg_uid;
333: l_subjects(i) := l_queue_rec.subject;
334: l_rfc_msgids(i) := l_queue_rec.RFC822_message_id;
335:
336: update iem_migration_store_temp set dp_status ='A', last_update_date=sysdate
337: where migration_id=p_migration_id and mail_id=l_queue_rec.mail_id;
338:
339: i := i + 1;
340:

Line 428: l_error IEM_MIGRATION_STORE_TEMP.error_text%type;

424: l_msg_count NUMBER := 0;
425: l_msg_data VARCHAR2(2000);
426:
427: i number;
428: l_error IEM_MIGRATION_STORE_TEMP.error_text%type;
429:
430:
431: BEGIN
432: -- Standard Start of API savepoint

Line 459: update iem_migration_store_temp set dp_status='E', error_text=l_error

455: l_error := substr(p_error,1,1000);
456:
457: For i in 1..p_mail_ids.count loop
458:
459: update iem_migration_store_temp set dp_status='E', error_text=l_error
460: where mail_id=p_mail_ids(i);
461:
462: end loop;
463: