1 package cn_quota_assign_pvt_w as
2 /* $Header: cnwpnags.pls 120.4 2006/05/11 06:06 kjayapau noship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy cn_quota_assign_pvt.quota_assign_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_VARCHAR2_TABLE_100
7 , a4 JTF_VARCHAR2_TABLE_1900
8 , a5 JTF_DATE_TABLE
9 , a6 JTF_DATE_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_NUMBER_TABLE
13 , a10 JTF_VARCHAR2_TABLE_100
14 );
15 procedure rosetta_table_copy_out_p1(t cn_quota_assign_pvt.quota_assign_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
16 , a1 out nocopy JTF_NUMBER_TABLE
17 , a2 out nocopy JTF_NUMBER_TABLE
18 , a3 out nocopy JTF_VARCHAR2_TABLE_100
19 , a4 out nocopy JTF_VARCHAR2_TABLE_1900
20 , a5 out nocopy JTF_DATE_TABLE
21 , a6 out nocopy JTF_DATE_TABLE
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_VARCHAR2_TABLE_100
26 );
27
28 procedure create_quota_assign(p_api_version NUMBER
29 , p_init_msg_list VARCHAR2
30 , p_commit VARCHAR2
31 , p_validation_level NUMBER
32 , p4_a0 in out nocopy NUMBER
33 , p4_a1 in out nocopy NUMBER
34 , p4_a2 in out nocopy NUMBER
35 , p4_a3 in out nocopy VARCHAR2
36 , p4_a4 in out nocopy VARCHAR2
37 , p4_a5 in out nocopy DATE
38 , p4_a6 in out nocopy DATE
39 , p4_a7 in out nocopy NUMBER
40 , p4_a8 in out nocopy NUMBER
41 , p4_a9 in out nocopy NUMBER
42 , p4_a10 in out nocopy VARCHAR
43 , x_return_status out nocopy VARCHAR2
44 , x_msg_count out nocopy NUMBER
45 , x_msg_data out nocopy VARCHAR2
46 );
47 procedure update_quota_assign(p_api_version NUMBER
48 , p_init_msg_list VARCHAR2
49 , p_commit VARCHAR2
50 , p_validation_level NUMBER
51 , p4_a0 in out nocopy NUMBER
52 , p4_a1 in out nocopy NUMBER
53 , p4_a2 in out nocopy NUMBER
54 , p4_a3 in out nocopy VARCHAR2
55 , p4_a4 in out nocopy VARCHAR2
56 , p4_a5 in out nocopy DATE
57 , p4_a6 in out nocopy DATE
58 , p4_a7 in out nocopy NUMBER
59 , p4_a8 in out nocopy NUMBER
60 , p4_a9 in out nocopy NUMBER
61 , p4_a10 in out nocopy VARCHAR
62 , x_return_status out nocopy VARCHAR2
63 , x_msg_count out nocopy NUMBER
64 , x_msg_data out nocopy VARCHAR2
65 );
66 procedure delete_quota_assign(p_api_version NUMBER
67 , p_init_msg_list VARCHAR2
68 , p_commit VARCHAR2
69 , p_validation_level NUMBER
70 , p4_a0 NUMBER
71 , p4_a1 NUMBER
72 , p4_a2 NUMBER
73 , p4_a3 VARCHAR2
74 , p4_a4 VARCHAR2
75 , p4_a5 DATE
76 , p4_a6 DATE
77 , p4_a7 NUMBER
78 , p4_a8 NUMBER
79 , p4_a9 NUMBER
80 , p4_a10 VARCHAR
81 , x_return_status out nocopy VARCHAR2
82 , x_msg_count out nocopy NUMBER
83 , x_msg_data out nocopy VARCHAR2
84 );
85 procedure get_quota_assign(p_api_version NUMBER
86 , p_init_msg_list VARCHAR2
87 , p_commit VARCHAR2
88 , p_validation_level NUMBER
89 , p_comp_plan_id NUMBER
90 , p5_a0 out nocopy JTF_NUMBER_TABLE
91 , p5_a1 out nocopy JTF_NUMBER_TABLE
92 , p5_a2 out nocopy JTF_NUMBER_TABLE
93 , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
94 , p5_a4 out nocopy JTF_VARCHAR2_TABLE_1900
95 , p5_a5 out nocopy JTF_DATE_TABLE
96 , p5_a6 out nocopy JTF_DATE_TABLE
97 , p5_a7 out nocopy JTF_NUMBER_TABLE
98 , p5_a8 out nocopy JTF_NUMBER_TABLE
99 , p5_a9 out nocopy JTF_NUMBER_TABLE
100 , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
101 , x_return_status out nocopy VARCHAR2
102 , x_msg_count out nocopy NUMBER
103 , x_msg_data out nocopy VARCHAR2
104 );
105 end cn_quota_assign_pvt_w;