1 PACKAGE IEX_ROUTING_PVT AS
2 /* $Header: iexvrous.pls 120.0 2004/01/24 03:28:37 appldev noship $ */
3
4 --TYPE iex_collectors_rec_type IS RECORD
5 --(
6 -- collector_id jtf_customer_profiles_v.collector_id%type
7 --);
8
9 --TYPE iex_collectors_tbl_type IS TABLE OF iex_collectors_rec_type
10 -- INDEX BY BINARY_INTEGER;
11
12 TYPE iex_collectors_tbl_type IS TABLE OF
13 jtf_customer_profiles_v.collector_id%type
14 INDEX BY BINARY_INTEGER;
15
16
17 PROCEDURE isCustomerOverdue ( p_api_version in number,
18 p_init_msg_list in varchar2 default fnd_api.g_false,
19 p_commit in varchar2 default fnd_api.g_false,
20 p_validation_level in number default fnd_api.g_valid_level_full,
21 x_return_status out NOCOPY varchar2,
22 x_msg_count out NOCOPY number,
23 x_msg_data out NOCOPY varchar2,
24 p_customer_id in number,
25 p_customer_overdue out NOCOPY boolean);
26
27 PROCEDURE getCollectors ( p_api_version in number,
28 p_init_msg_list in varchar2 default fnd_api.g_false,
29 p_commit in varchar2 default fnd_api.g_false,
30 p_validation_level in number default fnd_api.g_valid_level_full,
31 x_return_status out NOCOPY varchar2,
32 x_msg_count out NOCOPY number,
33 x_msg_data out NOCOPY varchar2,
34 p_customer_id in number,
35 p_collectors out NOCOPY iex_collectors_tbl_type);
36
37 END IEX_ROUTING_PVT;