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