APPS.IEM_QUEUE_MANAGEMENT_PVT dependencies on IEM_QUEUE_MANAGEMENT_PVT

Line 1: package body IEM_QUEUE_MANAGEMENT_PVT as

1: package body IEM_QUEUE_MANAGEMENT_PVT as
2: /* $Header: iemvqumb.pls 120.4.12010000.2 2008/10/16 09:23:46 shramana ship $*/
3: G_PKG_NAME varchar2(100):='IEM_QUEUE_MANAGEMENT_PVT';
4: PROCEDURE search_messages_in_queue (p_api_version_number IN NUMBER,
5: p_init_msg_list IN VARCHAR2 := NULL,

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

1: package body IEM_QUEUE_MANAGEMENT_PVT as
2: /* $Header: iemvqumb.pls 120.4.12010000.2 2008/10/16 09:23:46 shramana ship $*/
3: G_PKG_NAME varchar2(100):='IEM_QUEUE_MANAGEMENT_PVT';
4: PROCEDURE search_messages_in_queue (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 27: l_post_mdts iem_queue_management_pvt.temp_message_type;

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

Line 367: l_post_mdts iem_queue_management_pvt.temp_message_type;

363: l_api_name VARCHAR2(255):='get_total_count_in_queue';
364: l_api_version_number NUMBER:=1.0;
365: Type get_message_rec is REF CURSOR ;
366: email_dtl_cur get_message_rec;
367: l_post_mdts iem_queue_management_pvt.temp_message_type;
368: l_classification_name iem_route_classifications.name%type;
369: l_party_name hz_parties.party_name%type;
370: l_received_date varchar2(500);
371: l_string varchar2(32767):='';

Line 1121: end IEM_QUEUE_MANAGEMENT_PVT ;

1117:
1118:
1119: END show_resource_group_list;
1120:
1121: end IEM_QUEUE_MANAGEMENT_PVT ;