APPS.IEM_AGENT_INBOX_MGMT_PVT dependencies on IEM_AGENT_INBOX_MGMT_PVT

Line 1: package body IEM_AGENT_INBOX_MGMT_PVT as

1: package body IEM_AGENT_INBOX_MGMT_PVT as
2: /* $Header: iemvaimb.pls 120.3 2006/05/01 15:19:49 chtang noship $*/
3: G_PKG_NAME varchar2(100):='IEM_AGENT_INBOX_MGMT_PVT';
4: PROCEDURE search_messages_in_inbox (p_api_version_number IN NUMBER,
5: p_init_msg_list IN VARCHAR2 := NULL,

Line 3: G_PKG_NAME varchar2(100):='IEM_AGENT_INBOX_MGMT_PVT';

1: package body IEM_AGENT_INBOX_MGMT_PVT as
2: /* $Header: iemvaimb.pls 120.3 2006/05/01 15:19:49 chtang noship $*/
3: G_PKG_NAME varchar2(100):='IEM_AGENT_INBOX_MGMT_PVT';
4: PROCEDURE search_messages_in_inbox (p_api_version_number IN NUMBER,
5: p_init_msg_list IN VARCHAR2 := NULL,
6: p_commit IN VARCHAR2 := NULL,
7: p_email_account_id in number,

Line 29: l_post_mdts iem_agent_inbox_mgmt_pvt.temp_message_type;

25: l_api_name VARCHAR2(255):='search_messages_in_inbox';
26: l_api_version_number NUMBER:=1.0;
27: Type get_message_rec is REF CURSOR ;
28: email_dtl_cur get_message_rec;
29: l_post_mdts iem_agent_inbox_mgmt_pvt.temp_message_type;
30: l_party_name hz_parties.party_name%type;
31: l_string varchar2(32767):='';
32: l_query_string1 varchar2(15000):='';
33: l_query_string2 varchar2(15000):='';

Line 350: l_post_mdts iem_agent_inbox_mgmt_pvt.temp_message_type;

346: l_api_name VARCHAR2(255):='get_total_count_in_inbox';
347: l_api_version_number NUMBER:=1.0;
348: Type get_message_rec is REF CURSOR ;
349: email_dtl_cur get_message_rec;
350: l_post_mdts iem_agent_inbox_mgmt_pvt.temp_message_type;
351: l_classification_name iem_route_classifications.name%type;
352: l_party_name hz_parties.party_name%type;
353: l_resource_name jtf_rs_resource_extns_vl.resource_name%type;
354: l_received_date varchar2(500);

Line 874: end IEM_AGENT_INBOX_MGMT_PVT ;

870:
871:
872: END show_agent_list;
873:
874: end IEM_AGENT_INBOX_MGMT_PVT ;