APPS.IEM_ARCH_FLDS_PVT dependencies on IEM_ARCHIVED_FOLDERS

Line 42: select iem_archived_folders_s1.nextval into l_seq_id from dual;

38: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
39: END IF;
40: x_return_status := FND_API.G_RET_STS_SUCCESS;
41: SAVEPOINT IEM_ARCHFLD_PVT;
42: select iem_archived_folders_s1.nextval into l_seq_id from dual;
43: select nvl(max(FOLDER_SEQ_NUM),0)+1
44: INTO l_fld_id
45: FROM IEM_ARCHIVED_FOLDERS
46: where email_account_id=p_email_account_id

Line 45: FROM IEM_ARCHIVED_FOLDERS

41: SAVEPOINT IEM_ARCHFLD_PVT;
42: select iem_archived_folders_s1.nextval into l_seq_id from dual;
43: select nvl(max(FOLDER_SEQ_NUM),0)+1
44: INTO l_fld_id
45: FROM IEM_ARCHIVED_FOLDERS
46: where email_account_id=p_email_account_id
47: and FOLDER_NAME=p_folder;
48: l_arch_folder:='Arch'||p_email_account_id||p_folder||l_fld_id;
49: INSERT INTO IEM_ARCHIVED_FOLDERS

Line 49: INSERT INTO IEM_ARCHIVED_FOLDERS

45: FROM IEM_ARCHIVED_FOLDERS
46: where email_account_id=p_email_account_id
47: and FOLDER_NAME=p_folder;
48: l_arch_folder:='Arch'||p_email_account_id||p_folder||l_fld_id;
49: INSERT INTO IEM_ARCHIVED_FOLDERS
50: (ARCH_FOLDER_ID,
51: ARCH_FOLDER_NAME,
52: FOLDER_NAME,
53: FOLDER_SEQ_NUM,