[Home] [Help]
47: l_rt_classification_id number;
48: l_stat varchar2(10);
49: l_out_text varchar2(2000):=' ';
50: l_routing_classification varchar2(300);
51: KeyValuePairs iem_route_pub.KeyVals_tbl_type;
52: l_api_name varchar2(100):='PROC_EMAILS';
53: l_api_version_number number:=1.0;
54: l_Error_Message VARCHAR2(2000);
55: l_call_status BOOLEAN;
52: l_api_name varchar2(100):='PROC_EMAILS';
53: l_api_version_number number:=1.0;
54: l_Error_Message VARCHAR2(2000);
55: l_call_status BOOLEAN;
56: l_class_val_tbl IEM_ROUTE_PUB.keyVals_tbl_type;
57: l_param_rec_tbl IEM_RULES_ENGINE_PUB.parameter_tbl_type;
58: l_tag_keyval IEM_TAGPROCESS_PUB.keyVals_tbl_type;
59: l_action varchar2(50);
60: l_counter number:=1;
3933: end ;
3934:
3935: PROCEDURE IEM_CLASSIFICATION_PROC(
3936: p_email_account_id in number,
3937: p_keyval in iem_route_pub.keyVals_tbl_type,
3938: x_rt_classification_id out NOCOPY number,
3939: x_status out NOCOPY varchar2,
3940: x_out_text out NOCOPY varchar2) IS
3941:
3968: END IEM_CLASSIFICATION_PROC;
3969:
3970: PROCEDURE IEM_ROUTING_PROC(
3971: p_email_account_id in number,
3972: p_keyval in iem_route_pub.keyVals_tbl_type,
3973: x_routing_group_id out NOCOPY number,
3974: x_status out NOCOPY varchar2,
3975: x_out_text out NOCOPY varchar2) IS
3976: KeyValuePairs iem_route_pub.KeyVals_tbl_type;
3972: p_keyval in iem_route_pub.keyVals_tbl_type,
3973: x_routing_group_id out NOCOPY number,
3974: x_status out NOCOPY varchar2,
3975: x_out_text out NOCOPY varchar2) IS
3976: KeyValuePairs iem_route_pub.KeyVals_tbl_type;
3977: l_counter number;
3978: l_ret_status varchar2(10);
3979: l_msg_count number;
3980: l_msg_data varchar2(500);
3979: l_msg_count number;
3980: l_msg_data varchar2(500);
3981: ROUTE_EXCEPTION EXCEPTION;
3982: BEGIN
3983: IEM_ROUTE_PUB.ROUTE(
3984: P_API_VERSION_NUMBER =>1.0,
3985: P_KEYVALS_TBL =>p_keyval,
3986: P_ACCOUNTID =>p_email_account_id,
3987: X_GROUPID =>x_routing_group_id,
4881: x_msg_data OUT NOCOPY VARCHAR2) IS
4882:
4883: l_header_rec iem_ms_base_headers%rowtype;
4884: l_mail_rec iem_rt_proc_emails%rowtype;
4885: l_class_val_tbl IEM_ROUTE_PUB.keyVals_tbl_type;
4886: l_counter number;
4887: l_message_id number;
4888: l_top_intent varchar2(50);
4889: l_top_score number;
5983: l_service_request_rec CS_ServiceRequest_PUB.service_request_rec_type;
5984: p_notes CS_ServiceRequest_PUB.notes_table;
5985: p_contacts CS_ServiceRequest_PUB.contacts_table;
5986: l_sr_create_out_rec CS_ServiceRequest_PUB.sr_create_out_rec_type;
5987: p_keyVals_tbl IEM_ROUTE_PUB.keyVals_tbl_type;
5988:
5989: l_notes CS_ServiceRequest_PUB.notes_table;
5990: l_contacts CS_ServiceRequest_PUB.contacts_table;
5991: l_summary_prefix VARCHAR2(80);