APPS.IEM_ARCH_PVT dependencies on IEM_ARCH_REQUESTS

Line 45: select iem_arch_requests_s1.nextval into l_seq_id from dual;

41: x_return_status := FND_API.G_RET_STS_SUCCESS;
42: SAVEPOINT SUBMIT_REQUEST_PVT;
43: -- Create a New Request Id
44: IF p_message_id.count>0 THEN --There are messages to process
45: select iem_arch_requests_s1.nextval into l_seq_id from dual;
46:
47: -- Creating the Source message ids in the archive details table
48: IEM_ARCH_DTLS_PVT. create_item (p_api_version_number=>1.0 ,
49: p_init_msg_list=>'F' ,

Line 68: IEM_ARCH_REQUESTS_PVT.create_item (p_api_version_number=>1.0 ,

64: END IF;
65: l_arch_count:=p_message_id.count;
66:
67: --Finally Create a request in the archive request table
68: IEM_ARCH_REQUESTS_PVT.create_item (p_api_version_number=>1.0 ,
69: p_init_msg_list=>'F' ,
70: p_commit=>'F',
71: p_request_id=>l_seq_id ,
72: p_arch_criteria=>p_search_criteria,

Line 199: update iem_Arch_Requests

195: and nvl(media_id,1)>0; -- ignoring data with no media id info where media id=0
196: -- If media id is null we should not ignore as it might be due to
197: -- some processing error like move or delete message error
198: IF l_arch_count=0 THEN
199: update iem_Arch_Requests
200: set status='C'
201: where Request_id=p_request_id;
202: update iem_archived_folders
203: set arch_folder_status='O'

Line 206: update iem_Arch_Requests

202: update iem_archived_folders
203: set arch_folder_status='O'
204: where arch_folder_id=l_arch_Folder_id;
205: ELSE
206: update iem_Arch_Requests
207: set status='E',
208: arch_comment=nvl(l_out_text,' ')||nvl(m_out_text,' ')
209: where Request_id=p_request_id;
210: END IF;

Line 263: l_req_type iem_arch_requests.request_type%type;

259: l_out_text varchar2(500);
260: ERROR_FOLDER_DELETION EXCEPTION;
261: ERROR_CANCEL_REQUEST EXCEPTION;
262: l_oes_ret_code number;
263: l_req_type iem_arch_requests.request_type%type;
264:
265: BEGIN
266: -- Standard call to check for call compatibility.
267: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

Line 275: delete from IEM_ARCH_REQUESTS

271: THEN
272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273: END IF;
274: x_return_status := FND_API.G_RET_STS_SUCCESS;
275: delete from IEM_ARCH_REQUESTS
276: where request_id=p_request_id;
277: delete from IEM_ARCHIVED_DTLS
278: where request_id=p_request_id;
279: -- Standard Check Of p_commit.

Line 377: from iem_arch_requests

373: select to_date(p_date,p_date_format) into l_date from dual;
374: BEGIN
375: select to_char(max(creation_date),p_date_format)
376: into x_arch_date
377: from iem_arch_requests
378: where email_account_id=p_email_account_id
379: and folder_name=p_folder and status ='C';
380: EXCEPTION WHEN OTHERS THEN
381: x_arch_date:=null;

Line 402: from iem_arch_requests

398: close c1;
399: end if;
400: l_count:=x_msg_table.count;
401: select count(*) into l_proc_count
402: from iem_arch_requests
403: where email_account_id=p_email_account_id
404: and folder_name=p_folder
405: and status in ('S','E','P');
406: IF l_proc_count=0 and l_count>0 then

Line 427: select request_id,request_type from iem_arch_Requests

423: PROCEDURE PROC_REQUESTS(ERRBUF OUT NOCOPY VARCHAR2,
424: ERRRET OUT NOCOPY VARCHAR2,
425: p_api_version_number in number:= 1.0) IS
426: cursor c1 is
427: select request_id,request_type from iem_arch_Requests
428: where status='S'
429: order by creation_date for update;
430: l_ret_status varchar2(10);
431: l_msg_data varchar2(1000);

Line 440: update iem_arch_Requests

436: BEGIN
437: LOOP -- Outer Loop
438: l_proc_flag:='F';
439: for v1 in c1 LOOP
440: update iem_arch_Requests
441: set status='I'
442: where request_id=v1.request_id;
443: l_request_id:=v1.request_id;
444: l_req_type:=v1.request_type;