1 PACKAGE cn_rules_disp_pub AUTHID CURRENT_USER AS
2 -- $Header: cnpruls.pls 115.4 2003/05/26 12:10:57 pramadas ship $
3
4 TYPE rls_dsp_rec_type IS RECORD
5 ( rule_name VARCHAR2(80) ,
6 rule_level NUMBER(15),
7 rule_revenue_class VARCHAR2(80),
8 rule_expression VARCHAR2(2000) );
9
10 TYPE rls_dsp_tbl_type IS TABLE OF rls_dsp_rec_type
11 INDEX BY BINARY_INTEGER;
12
13
14 -- API name : Get_rules
15 -- Type : Public.
16 -- Pre-reqs :
17 -- Usage :
18 --+
19 -- Desc :
20 --
21 --
22 --+
23 -- Parameters :
24 -- OUT : x_rules_display_tbl rls_dsp_tbl_type :Output table
25 -- OUT : x_rules_count NUMBER : Size of the table
26 -- IN : p_ruleset_id NUMBER : Currently not used
27 -- IN : p_parent_id NUMBER : The rule_id of the parent
28 --
29 --+
30 -- Version : Current version 1.0
31 -- Initial version 1.0
32 --+
33 -- Notes :
34 --+
35 -- End of comments
36
37 PROCEDURE get_rules
38 (
39 p_api_version IN NUMBER,
40 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
41 p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
42
43 x_return_status OUT NOCOPY VARCHAR2,
44 x_msg_count OUT NOCOPY NUMBER,
45 x_msg_data OUT NOCOPY VARCHAR2,
46 x_loading_status OUT NOCOPY VARCHAR2,
47
48 p_ruleset_id IN NUMBER ,
49 p_parent_id IN NUMBER ,
50 p_date IN DATE,
51 p_start_record IN NUMBER := 1,
52 p_increment_count IN NUMBER,
53
54 x_rules_display_tbl OUT NOCOPY rls_dsp_tbl_type,
55 x_rules_count OUT NOCOPY NUMBER
56 );
57
58 END cn_rules_disp_pub ;
59