1 package cn_ruleset_pvt_w AUTHID CURRENT_USER as
2 /* $Header: cnwrsets.pls 120.2 2005/10/10 01:06 rramakri noship $ */
3 procedure create_ruleset(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , p_commit VARCHAR2
6 , p_validation_level NUMBER
7 , x_return_status out nocopy VARCHAR2
8 , x_msg_count out nocopy NUMBER
9 , x_msg_data out nocopy VARCHAR2
10 , x_loading_status out nocopy VARCHAR2
11 , x_ruleset_id out nocopy NUMBER
12 , p9_a0 NUMBER
13 , p9_a1 VARCHAR2
14 , p9_a2 VARCHAR2
15 , p9_a3 DATE
16 , p9_a4 DATE
17 , p9_a5 VARCHAR2
18 , p9_a6 NUMBER
19 , p9_a7 VARCHAR2
20 , p9_a8 NUMBER
21 );
22 procedure update_ruleset(p_api_version NUMBER
23 , p_init_msg_list VARCHAR2
24 , p_commit VARCHAR2
25 , p_validation_level NUMBER
26 , x_return_status out nocopy VARCHAR2
27 , x_msg_count out nocopy NUMBER
28 , x_msg_data out nocopy VARCHAR2
29 , x_loading_status out nocopy VARCHAR2
30 , p8_a0 in out nocopy NUMBER
31 , p8_a1 in out nocopy VARCHAR2
32 , p8_a2 in out nocopy VARCHAR2
33 , p8_a3 in out nocopy DATE
34 , p8_a4 in out nocopy DATE
35 , p8_a5 in out nocopy VARCHAR2
36 , p8_a6 in out nocopy NUMBER
37 , p8_a7 in out nocopy VARCHAR2
38 , p8_a8 in out nocopy NUMBER
39 , p9_a0 in out nocopy NUMBER
40 , p9_a1 in out nocopy VARCHAR2
41 , p9_a2 in out nocopy VARCHAR2
42 , p9_a3 in out nocopy DATE
43 , p9_a4 in out nocopy DATE
44 , p9_a5 in out nocopy VARCHAR2
45 , p9_a6 in out nocopy NUMBER
46 , p9_a7 in out nocopy VARCHAR2
47 , p9_a8 in out nocopy NUMBER
48 );
49 end cn_ruleset_pvt_w;