1 package fun_rule_criteria_pub_w as
2 /* $Header: FUNXTMRULRCTRWS.pls 120.0 2005/06/20 04:30:00 ammishra noship $ */
3 procedure create_rule_criteria(p_init_msg_list VARCHAR2
4 , p1_a0 NUMBER
5 , p1_a1 NUMBER
6 , p1_a2 NUMBER
7 , p1_a3 VARCHAR2
8 , p1_a4 VARCHAR2
9 , p1_a5 VARCHAR2
10 , p1_a6 DATE
11 , p1_a7 NUMBER
12 , p1_a8 DATE
13 , p1_a9 NUMBER
14 , p1_a10 NUMBER
15 , p1_a11 VARCHAR2
16 , x_criteria_id out nocopy NUMBER
17 , x_return_status out nocopy VARCHAR2
18 , x_msg_count out nocopy NUMBER
19 , x_msg_data out nocopy VARCHAR2
20 );
21 procedure update_rule_criteria(p_init_msg_list VARCHAR2
22 , p1_a0 NUMBER
23 , p1_a1 NUMBER
24 , p1_a2 NUMBER
25 , p1_a3 VARCHAR2
26 , p1_a4 VARCHAR2
27 , p1_a5 VARCHAR2
28 , p1_a6 DATE
29 , p1_a7 NUMBER
30 , p1_a8 DATE
31 , p1_a9 NUMBER
32 , p1_a10 NUMBER
33 , p1_a11 VARCHAR2
34 , p_object_version_number in out nocopy NUMBER
35 , x_return_status out nocopy VARCHAR2
36 , x_msg_count out nocopy NUMBER
37 , x_msg_data out nocopy VARCHAR2
38 );
39 procedure get_rule_criteria_rec(p_init_msg_list VARCHAR2
40 , p_criteria_id NUMBER
41 , p_rule_detail_id NUMBER
42 , p3_a0 out nocopy NUMBER
43 , p3_a1 out nocopy NUMBER
44 , p3_a2 out nocopy NUMBER
45 , p3_a3 out nocopy VARCHAR2
46 , p3_a4 out nocopy VARCHAR2
47 , p3_a5 out nocopy VARCHAR2
48 , p3_a6 out nocopy DATE
49 , p3_a7 out nocopy NUMBER
50 , p3_a8 out nocopy DATE
51 , p3_a9 out nocopy NUMBER
52 , p3_a10 out nocopy NUMBER
53 , p3_a11 out nocopy VARCHAR2
54 , x_return_status out nocopy VARCHAR2
55 , x_msg_count out nocopy NUMBER
56 , x_msg_data out nocopy VARCHAR2
57 );
58 end fun_rule_criteria_pub_w;
[Home] [Help]