DBA Data[Home] [Help]

APPS.IEM_EMAIL_PROC_PVT dependencies on IEM_ROUTE_PUB

Line 32: KeyValuePairs iem_route_pub.KeyVals_tbl_type;

28: l_rt_classification_id number;
29: l_stat varchar2(10);
30: l_out_text varchar2(2000):=' ';
31: l_routing_classification varchar2(300);
32: KeyValuePairs iem_route_pub.KeyVals_tbl_type;
33: l_api_name varchar2(100):='PROC_EMAILS';
34: l_api_version_number number:=1.0;
35: l_Error_Message VARCHAR2(2000);
36: l_call_status BOOLEAN;

Line 37: l_class_val_tbl IEM_ROUTE_PUB.keyVals_tbl_type;

33: l_api_name varchar2(100):='PROC_EMAILS';
34: l_api_version_number number:=1.0;
35: l_Error_Message VARCHAR2(2000);
36: l_call_status BOOLEAN;
37: l_class_val_tbl IEM_ROUTE_PUB.keyVals_tbl_type;
38: l_param_rec_tbl IEM_RULES_ENGINE_PUB.parameter_tbl_type;
39: l_tag_keyval IEM_TAGPROCESS_PUB.keyVals_tbl_type;
40: l_action varchar2(50);
41: l_counter number:=1;

Line 2842: p_keyval in iem_route_pub.keyVals_tbl_type,

2838: end ;
2839:
2840: PROCEDURE IEM_CLASSIFICATION_PROC(
2841: p_email_account_id in number,
2842: p_keyval in iem_route_pub.keyVals_tbl_type,
2843: x_rt_classification_id out NOCOPY number,
2844: x_status out NOCOPY varchar2,
2845: x_out_text out NOCOPY varchar2) IS
2846:

Line 2877: p_keyval in iem_route_pub.keyVals_tbl_type,

2873: END IEM_CLASSIFICATION_PROC;
2874:
2875: PROCEDURE IEM_ROUTING_PROC(
2876: p_email_account_id in number,
2877: p_keyval in iem_route_pub.keyVals_tbl_type,
2878: x_routing_group_id out NOCOPY number,
2879: x_status out NOCOPY varchar2,
2880: x_out_text out NOCOPY varchar2) IS
2881: KeyValuePairs iem_route_pub.KeyVals_tbl_type;

Line 2881: KeyValuePairs iem_route_pub.KeyVals_tbl_type;

2877: p_keyval in iem_route_pub.keyVals_tbl_type,
2878: x_routing_group_id out NOCOPY number,
2879: x_status out NOCOPY varchar2,
2880: x_out_text out NOCOPY varchar2) IS
2881: KeyValuePairs iem_route_pub.KeyVals_tbl_type;
2882: l_counter number;
2883: l_ret_status varchar2(10);
2884: l_msg_count number;
2885: l_msg_data varchar2(500);

Line 2888: IEM_ROUTE_PUB.ROUTE(

2884: l_msg_count number;
2885: l_msg_data varchar2(500);
2886: ROUTE_EXCEPTION EXCEPTION;
2887: BEGIN
2888: IEM_ROUTE_PUB.ROUTE(
2889: P_API_VERSION_NUMBER =>1.0,
2890: P_KEYVALS_TBL =>p_keyval,
2891: P_ACCOUNTID =>p_email_account_id,
2892: X_GROUPID =>x_routing_group_id,

Line 3790: l_class_val_tbl IEM_ROUTE_PUB.keyVals_tbl_type;

3786: x_msg_data OUT NOCOPY VARCHAR2) IS
3787:
3788: l_header_rec iem_ms_base_headers%rowtype;
3789: l_mail_rec iem_rt_proc_emails%rowtype;
3790: l_class_val_tbl IEM_ROUTE_PUB.keyVals_tbl_type;
3791: l_counter number;
3792: l_message_id number;
3793: l_top_intent varchar2(50);
3794: l_top_score number;