[Home] [Help]
16: select name||','||a.route_classification_id name from iem_route_classifications a,iem_account_route_class b
17: where a.route_classification_id=b.route_classification_id
18: and b.email_account_id=l_email_account_id
19: union
20: select 'Inbox' from dual
21: union
22: select 'Drafts' from dual
23: union
24: select 'Resolved' from dual
18: and b.email_account_id=l_email_account_id
19: union
20: select 'Inbox' from dual
21: union
22: select 'Drafts' from dual
23: union
24: select 'Resolved' from dual
25: union
26: select 'Sent' from dual
20: select 'Inbox' from dual
21: union
22: select 'Drafts' from dual
23: union
24: select 'Resolved' from dual
25: union
26: select 'Sent' from dual
27: union
28: select 'Deleted' from dual
22: select 'Drafts' from dual
23: union
24: select 'Resolved' from dual
25: union
26: select 'Sent' from dual
27: union
28: select 'Deleted' from dual
29: union
30: select 'Admin' from dual
24: select 'Resolved' from dual
25: union
26: select 'Sent' from dual
27: union
28: select 'Deleted' from dual
29: union
30: select 'Admin' from dual
31: union
32: select 'Retry' from dual;
26: select 'Sent' from dual
27: union
28: select 'Deleted' from dual
29: union
30: select 'Admin' from dual
31: union
32: select 'Retry' from dual;
33: l_total_count number;
34: l_str varchar2(255);
28: select 'Deleted' from dual
29: union
30: select 'Admin' from dual
31: union
32: select 'Retry' from dual;
33: l_total_count number;
34: l_str varchar2(255);
35: G_IM_LINK varchar2(255);
36: G_FOLDER varchar2(255);
118: and rti.expire = 'N') and a.email_type = 'O' and a.folder_uid > 0
119: and a.folder_name = 'Drafts' and part.ref_key = a.rt_media_item_id
120: and part.part_type = 'HEADERS' and part.delete_flag <> 'Y';
121: end if;
122: select IEM_MIGRATION_DETAILS_S1.nextval into l_mig_id from dual;
123: insert into IEM_MIGRATION_DETAILS
124: (migration_id,
125: agent_account_id,
126: email_account_id,
175: and rt_classification_id=l_class_id and agent_id=0;
176: l_status_text:='Succesfully Count for Folder ';
177: l_status:='S';
178: end if;
179: select IEM_MIGRATION_DETAILS_S1.nextval into l_mig_id from dual;
180: insert into IEM_MIGRATION_DETAILS
181: (migration_id,
182: email_account_id,
183: folder_name,
253: l_media_id:=v1.ih_media_item_id;
254: select creation_date into l_received_Date from jtf_ih_media_items
255: where media_id=l_media_id;
256: l_received_date:=sysdate;
257: select iem_ms_base_headers_s1.nextval into l_message_id from dual;
258:
259: insert into iem_arch_msgdtls
260: (MESSAGE_ID ,
261: EMAIL_ACCOUNT_ID ,
539: l_mig_rec.from_str:=v1.sender_name;
540: l_mig_rec.message_size:=v1.message_size;
541:
542: -- Create Record into Worklist Queue.
543: select IEM_MIGRATION_STORE_TEMP_s1.nextval into l_mig_rec.mail_id from dual;
544: insert into iem_migration_store_temp
545: (MAIL_ID,
546: MESSAGE_ID ,
547: MIGRATION_ID,
799: if l_hist_flag='O' then -- To avoid duplicate
800: delete from iem_migration_Store_temp where migration_id=p_migration_id and message_id=l_msg_table(i);
801: end if;
802: l_mig_Rec.message_id:=l_msg_table(i);
803: select IEM_MIGRATION_STORE_TEMP_s1.nextval into l_mig_rec.mail_id from dual;
804: l_mig_rec.folder_name:=l_folder_name;
805: l_mig_rec.message_type:=l_folder_type;
806: l_mig_rec.email_account_id:=l_email_account_id;
807: l_content:=empty_blob();
1130: -- record in iem_post_mdts.otherwise the loop will be never
1131: -- ending
1132: select nvl(max(message_id),0) into l_id from iem_post_mdts;
1133: LOOP
1134: select iem_ms_base_headers_s1.nextval into l_id1 from dual;
1135: exit when l_id1>l_id;
1136: END LOOP;
1137: end if;
1138: else
1378: l_email_Account_id:=v1.email_account_id;
1379: l_acct_language:=v1.acct_language;
1380: l_template_profile:=to_number(FND_PROFILE.VALUE_SPECIFIC('IEM_TEMPLATE_CATEGORY_ID')) ;
1381: select to_number(decode(FND_PROFILE.VALUE_SPECIFIC('IEM_ACCOUNT_SENDER_NAME'),'ACCOUNT',0,1)) into
1382: l_sender_profile from dual;
1383: select dns_name,port
1384: into l_in_host,l_in_port
1385: from iem_email_servers a,iem_email_server_types b
1386: where a.server_type_id=b.email_server_type_id and
1406: BEGIN
1407: select kem_flag into l_flag from iem_email_Accounts
1408: where email_account_id=v1.email_Account_id;
1409: if l_flag is null then
1410: select decode(v1.acct_language,'GB',1,2) into l_flag from dual;
1411: end if;
1412:
1413: EXCEPTION WHEN OTHERS THEN
1414: -- This is 1159 ..
1411: end if;
1412:
1413: EXCEPTION WHEN OTHERS THEN
1414: -- This is 1159 ..
1415: select decode(v1.acct_language,'GB',1,2) into l_flag from dual;
1416: END;
1417: ELSE
1418: l_flag:=0;
1419: END IF;
1547: l_last_update_login);
1548:
1549: -- Insert into IEM_INTENT_DTLS
1550: for v3 in c1 LOOP
1551: select iem_intent_dtls_s1.nextval into l_intent_dtl_id from dual;
1552: l_mod:=mod(v3.score*100,10);
1553: if (l_mod=0 or l_mod>=5) then
1554: l_weight:=ceil(v3.score*10);
1555: else
1610: where deleted_flag is null; -- So that can be re runnable..
1611: -- Reset the Sequence to have highest email account id id
1612: select nvl(max(email_account_id),0) into l_max_id from iem_mstemail_accounts;
1613: LOOP
1614: select iem_mstemail_accounts_s1.nextval into l_val from dual;
1615: exit when l_val>l_max_id;
1616: END LOOP;
1617:
1618: -- Reset the Sequence to have highest agent id
1618: -- Reset the Sequence to have highest agent id
1619:
1620: select nvl(max(agent_id),0) into l_max_id from iem_agents;
1621: LOOP
1622: select iem_agents_s1.nextval into l_val from dual;
1623: exit when l_val>l_max_id;
1624: END LOOP;
1625:
1626: -- Reset the Sequence to have highest intent id
1626: -- Reset the Sequence to have highest intent id
1627:
1628: select nvl(max(intent_id),0) into l_max_id from iem_intents;
1629: LOOP
1630: select iem_intents_s1.nextval into l_val from dual;
1631: exit when l_val>l_max_id;
1632: END LOOP;
1633: -- Deleting OES Rule
1634: for v1 in c_rule LOOP