APPS.IEM_CLIENT_PUB dependencies on IEM_MAILITEM_PUB

Line 70: l_tag_key_value_tbl IEM_MAILITEM_PUB.keyVals_tbl_type;

66: l_i_sequence NUMBER;
67: l_m_sequence NUMBER;
68: l_db_server_id NUMBER;
69: l_classification_id NUMBER;
70: l_tag_key_value_tbl IEM_MAILITEM_PUB.keyVals_tbl_type;
71: l_tag_id VARCHAR2(30);
72: l_sr_id NUMBER;
73: l_parent_ih_id NUMBER;
74: l_customer_id NUMBER;

Line 78: l_t_number_tbl IEM_MAILITEM_PUB.t_number_table;

74: l_customer_id NUMBER;
75: l_contact_id NUMBER;
76: l_lead_id NUMBER;
77: l_ih_creator VARCHAR2(1);
78: l_t_number_tbl IEM_MAILITEM_PUB.t_number_table;
79: l_relationship_id NUMBER;
80:
81: BEGIN
82:

Line 129: IEM_MAILITEM_PUB.GetMailItem( p_api_version_number=> 1.0,

125: select decode(p_classification_id,G_NUM_NOP2, null,
126: p_classification_id) into l_classification_id from DUAL;
127:
128: --Call MailItem to get the next available message.
129: IEM_MAILITEM_PUB.GetMailItem( p_api_version_number=> 1.0,
130: p_init_msg_list => 'F',
131: p_commit => 'F',
132: p_resource_id => p_resource_id ,
133: p_tbl => l_t_number_tbl,

Line 2711: IEM_MAILITEM_PUB.DisposeMailItem (p_api_version_number => 1.0,

2707: WHERE rt_interaction_id = l_rt_interaction_id;
2708:
2709: if ( (UPPER(p_action) <> 'X') AND l_mdt_message_id IS NOT NULL) then
2710: begin
2711: IEM_MAILITEM_PUB.DisposeMailItem (p_api_version_number => 1.0,
2712: p_init_msg_list =>'F' ,
2713: p_commit => 'F',
2714: p_message_id => l_mdt_message_id,
2715: x_return_status => l_status,

Line 3600: l_tag_key_value_tbl IEM_MAILITEM_PUB.keyVals_tbl_type;

3596: l_i_sequence NUMBER;
3597: l_m_sequence NUMBER;
3598: l_db_server_id NUMBER;
3599: l_classification_id NUMBER;
3600: l_tag_key_value_tbl IEM_MAILITEM_PUB.keyVals_tbl_type;
3601: l_tag_id VARCHAR2(30);
3602: l_sr_id NUMBER;
3603: l_parent_ih_id NUMBER;
3604: l_customer_id NUMBER;

Line 3662: IEM_MAILITEM_PUB.GetQueueItemData (p_api_version_number => 1.0,

3658: l_mail_item_status := 'A';
3659: end if;
3660:
3661: --Update IEM_RT_PROC_EMAILS with to_agent_id, from_agent_id and status 'A'
3662: IEM_MAILITEM_PUB.GetQueueItemData (p_api_version_number => 1.0,
3663: p_init_msg_list => 'F',
3664: p_commit => 'F',
3665: p_message_id => p_message_id,
3666: p_from_agent_id => p_from_resource_id,

Line 4426: l_tag_key_value_tbl IEM_MAILITEM_PUB.keyVals_tbl_type;

4422: l_i_sequence NUMBER;
4423: l_m_sequence NUMBER;
4424: l_db_server_id NUMBER;
4425: l_classification_id NUMBER;
4426: l_tag_key_value_tbl IEM_MAILITEM_PUB.keyVals_tbl_type;
4427: l_tag_id VARCHAR2(30);
4428: l_sr_id NUMBER;
4429: l_parent_ih_id NUMBER;
4430: l_customer_id NUMBER;

Line 4474: IEM_MAILITEM_PUB.GetQueueItemData (p_api_version_number => 1.0,

4470:
4471: -----------------------Code------------------------
4472:
4473: -- Update IEM_RT_PROC_EMAILS with to_agent_id, from_agent_id and p_status
4474: IEM_MAILITEM_PUB.GetQueueItemData (p_api_version_number => 1.0,
4475: p_init_msg_list => 'F',
4476: p_commit => 'F',
4477: p_message_id => p_message_id,
4478: p_from_agent_id => p_from_resource_id,