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