DBA Data[Home] [Help]

PACKAGE: APPS.IEX_ROUTING_PVT

Source


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;