1 package cn_quota_rule_pvt_w as
2 /* $Header: cnwqtrls.pls 120.2 2005/09/14 04:29 rarajara ship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy cn_quota_rule_pvt.quota_rule_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_VARCHAR2_TABLE_100
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_VARCHAR2_TABLE_1900
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_NUMBER_TABLE
14 );
15 procedure rosetta_table_copy_out_p1(t cn_quota_rule_pvt.quota_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16 , a1 out nocopy JTF_NUMBER_TABLE
17 , a2 out nocopy JTF_VARCHAR2_TABLE_100
18 , a3 out nocopy JTF_VARCHAR2_TABLE_100
19 , a4 out nocopy JTF_NUMBER_TABLE
20 , a5 out nocopy JTF_NUMBER_TABLE
21 , a6 out nocopy JTF_VARCHAR2_TABLE_1900
22 , a7 out nocopy JTF_NUMBER_TABLE
23 , a8 out nocopy JTF_NUMBER_TABLE
24 , a9 out nocopy JTF_NUMBER_TABLE
25 , a10 out nocopy JTF_NUMBER_TABLE
26 );
27
28 procedure validate_quota_rule(p_api_version NUMBER
29 , p_init_msg_list VARCHAR2
30 , p_commit VARCHAR2
31 , p_validation_level NUMBER
32 , p_action VARCHAR2
33 , p5_a0 in out nocopy NUMBER
34 , p5_a1 in out nocopy NUMBER
35 , p5_a2 in out nocopy VARCHAR2
36 , p5_a3 in out nocopy VARCHAR2
37 , p5_a4 in out nocopy NUMBER
38 , p5_a5 in out nocopy NUMBER
39 , p5_a6 in out nocopy VARCHAR2
40 , p5_a7 in out nocopy NUMBER
41 , p5_a8 in out nocopy NUMBER
42 , p5_a9 in out nocopy NUMBER
43 , p5_a10 in out nocopy NUMBER
44 , p6_a0 NUMBER
45 , p6_a1 NUMBER
46 , p6_a2 VARCHAR2
47 , p6_a3 VARCHAR2
48 , p6_a4 NUMBER
49 , p6_a5 NUMBER
50 , p6_a6 VARCHAR2
51 , p6_a7 NUMBER
52 , p6_a8 NUMBER
53 , p6_a9 NUMBER
54 , p6_a10 NUMBER
55 , x_return_status out nocopy VARCHAR2
56 , x_msg_count out nocopy NUMBER
57 , x_msg_data out nocopy VARCHAR2
58 );
59 procedure create_quota_rule(p_api_version NUMBER
60 , p_init_msg_list VARCHAR2
61 , p_commit VARCHAR2
62 , p_validation_level NUMBER
63 , p4_a0 in out nocopy NUMBER
64 , p4_a1 in out nocopy NUMBER
65 , p4_a2 in out nocopy VARCHAR2
66 , p4_a3 in out nocopy VARCHAR2
67 , p4_a4 in out nocopy NUMBER
68 , p4_a5 in out nocopy NUMBER
69 , p4_a6 in out nocopy VARCHAR2
70 , p4_a7 in out nocopy NUMBER
71 , p4_a8 in out nocopy NUMBER
72 , p4_a9 in out nocopy NUMBER
73 , p4_a10 in out nocopy NUMBER
74 , x_return_status out nocopy VARCHAR2
75 , x_msg_count out nocopy NUMBER
76 , x_msg_data out nocopy VARCHAR2
77 );
78 procedure update_quota_rule(p_api_version NUMBER
79 , p_init_msg_list VARCHAR2
80 , p_commit VARCHAR2
81 , p_validation_level NUMBER
82 , p4_a0 in out nocopy NUMBER
83 , p4_a1 in out nocopy NUMBER
84 , p4_a2 in out nocopy VARCHAR2
85 , p4_a3 in out nocopy VARCHAR2
86 , p4_a4 in out nocopy NUMBER
87 , p4_a5 in out nocopy NUMBER
88 , p4_a6 in out nocopy VARCHAR2
89 , p4_a7 in out nocopy NUMBER
90 , p4_a8 in out nocopy NUMBER
91 , p4_a9 in out nocopy NUMBER
92 , p4_a10 in out nocopy NUMBER
93 , x_return_status out nocopy VARCHAR2
94 , x_msg_count out nocopy NUMBER
95 , x_msg_data out nocopy VARCHAR2
96 );
97 procedure delete_quota_rule(p_api_version NUMBER
98 , p_init_msg_list VARCHAR2
99 , p_commit VARCHAR2
100 , p_validation_level NUMBER
101 , p4_a0 in out nocopy NUMBER
102 , p4_a1 in out nocopy NUMBER
103 , p4_a2 in out nocopy VARCHAR2
104 , p4_a3 in out nocopy VARCHAR2
105 , p4_a4 in out nocopy NUMBER
106 , p4_a5 in out nocopy NUMBER
107 , p4_a6 in out nocopy VARCHAR2
108 , p4_a7 in out nocopy NUMBER
109 , p4_a8 in out nocopy NUMBER
110 , p4_a9 in out nocopy NUMBER
111 , p4_a10 in out nocopy NUMBER
112 , x_return_status out nocopy VARCHAR2
113 , x_msg_count out nocopy NUMBER
114 , x_msg_data out nocopy VARCHAR2
115 );
116 end cn_quota_rule_pvt_w;