PACKAGE: APPS.IEM_SEARCHMESSAGE_PVT_W

Source

1 package iem_searchmessage_pvt_w AUTHID CURRENT_USER as
2   /* $Header: iemsearchs.pls 120.0 2005/06/02 13:44:47 appldev noship $ */
3   procedure rosetta_table_copy_in_p1(t out nocopy iem_searchmessage_pvt.message_rec_tbl, a0 JTF_NUMBER_TABLE
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_VARCHAR2_TABLE_500
6     , a3 JTF_VARCHAR2_TABLE_2000
7     , a4 JTF_VARCHAR2_TABLE_2000
8     , a5 JTF_VARCHAR2_TABLE_100
9     );
10   procedure rosetta_table_copy_out_p1(t iem_searchmessage_pvt.message_rec_tbl, a0 out nocopy JTF_NUMBER_TABLE
11     , a1 out nocopy JTF_NUMBER_TABLE
12     , a2 out nocopy JTF_VARCHAR2_TABLE_500
13     , a3 out nocopy JTF_VARCHAR2_TABLE_2000
14     , a4 out nocopy JTF_VARCHAR2_TABLE_2000
15     , a5 out nocopy JTF_VARCHAR2_TABLE_100
16     );
17 
18   procedure searchmessages(p_api_version_number  NUMBER
19     , p_init_msg_list  VARCHAR2
20     , p_commit  VARCHAR2
21     , p_email_account_id  NUMBER
22     , p_resource_id  NUMBER
23     , p_email_queue  VARCHAR2
24     , p_sent_date_from  VARCHAR2
25     , p_sent_date_to  VARCHAR2
26     , p_received_date_from  date
27     , p_received_date_to  date
28     , p_from_str  VARCHAR2
29     , p_recepients  VARCHAR2
30     , p_cc_flag  VARCHAR2
31     , p_subject  VARCHAR2
32     , p_message_body  VARCHAR2
33     , p_customer_id  NUMBER
34     , p_classification  VARCHAR2
35     , p_resolved_agent  VARCHAR2
36     , p_resolved_group  VARCHAR2
37     , p19_a0 out nocopy JTF_NUMBER_TABLE
38     , p19_a1 out nocopy JTF_NUMBER_TABLE
39     , p19_a2 out nocopy JTF_VARCHAR2_TABLE_500
40     , p19_a3 out nocopy JTF_VARCHAR2_TABLE_2000
41     , p19_a4 out nocopy JTF_VARCHAR2_TABLE_2000
42     , p19_a5 out nocopy JTF_VARCHAR2_TABLE_100
43     , x_return_status out nocopy  VARCHAR2
44     , x_msg_count out nocopy  NUMBER
45     , x_msg_data out nocopy  VARCHAR2
46   );
47 end iem_searchmessage_pvt_w;