APPS.IEM_ARCH_PVT dependencies on IEM_ARCHIVED_FOLDERS

Line 202: update iem_archived_folders

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'
204: where arch_folder_id=l_arch_Folder_id;
205: ELSE
206: update iem_Arch_Requests

Line 255: l_arch_folder IEM_ARCHIVED_FOLDERS.ARCH_FOLDER_NAME%TYPE;

251: x_msg_data OUT NOCOPY VARCHAR2
252: ) IS
253: l_api_name VARCHAR2(255):='delete_request';
254: l_api_version_number NUMBER:=1.0;
255: l_arch_folder IEM_ARCHIVED_FOLDERS.ARCH_FOLDER_NAME%TYPE;
256: l_arch_folder_id IEM_ARCHIVED_FOLDERS.ARCH_FOLDER_ID%TYPE;
257: l_email_account_id IEM_EMAIL_ACCOUNTS.EMAIL_ACCOUNT_ID%TYPE;
258: l_ret_status varchar2(10);
259: l_out_text varchar2(500);

Line 256: l_arch_folder_id IEM_ARCHIVED_FOLDERS.ARCH_FOLDER_ID%TYPE;

252: ) IS
253: l_api_name VARCHAR2(255):='delete_request';
254: l_api_version_number NUMBER:=1.0;
255: l_arch_folder IEM_ARCHIVED_FOLDERS.ARCH_FOLDER_NAME%TYPE;
256: l_arch_folder_id IEM_ARCHIVED_FOLDERS.ARCH_FOLDER_ID%TYPE;
257: l_email_account_id IEM_EMAIL_ACCOUNTS.EMAIL_ACCOUNT_ID%TYPE;
258: l_ret_status varchar2(10);
259: l_out_text varchar2(500);
260: ERROR_FOLDER_DELETION EXCEPTION;