1 package cn_paygroup_pvt_w as
2 /* $Header: cnwpgrps.pls 120.2 2005/09/14 03:39 vensrini noship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy cn_paygroup_pvt.paygroup_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_100
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_VARCHAR2_TABLE_100
7 , a4 JTF_DATE_TABLE
8 , a5 JTF_DATE_TABLE
9 , a6 JTF_VARCHAR2_TABLE_100
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_VARCHAR2_TABLE_200
12 , a9 JTF_VARCHAR2_TABLE_200
13 , a10 JTF_VARCHAR2_TABLE_200
14 , a11 JTF_VARCHAR2_TABLE_200
15 , a12 JTF_VARCHAR2_TABLE_200
16 , a13 JTF_VARCHAR2_TABLE_200
17 , a14 JTF_VARCHAR2_TABLE_200
18 , a15 JTF_VARCHAR2_TABLE_200
19 , a16 JTF_VARCHAR2_TABLE_200
20 , a17 JTF_VARCHAR2_TABLE_200
21 , a18 JTF_VARCHAR2_TABLE_200
22 , a19 JTF_VARCHAR2_TABLE_200
23 , a20 JTF_VARCHAR2_TABLE_200
24 , a21 JTF_VARCHAR2_TABLE_200
25 , a22 JTF_VARCHAR2_TABLE_200
26 , a23 JTF_NUMBER_TABLE
27 , a24 JTF_NUMBER_TABLE
28 );
29 procedure rosetta_table_copy_out_p1(t cn_paygroup_pvt.paygroup_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
30 , a1 out nocopy JTF_VARCHAR2_TABLE_100
31 , a2 out nocopy JTF_VARCHAR2_TABLE_100
32 , a3 out nocopy JTF_VARCHAR2_TABLE_100
33 , a4 out nocopy JTF_DATE_TABLE
34 , a5 out nocopy JTF_DATE_TABLE
35 , a6 out nocopy JTF_VARCHAR2_TABLE_100
36 , a7 out nocopy JTF_VARCHAR2_TABLE_100
37 , a8 out nocopy JTF_VARCHAR2_TABLE_200
38 , a9 out nocopy JTF_VARCHAR2_TABLE_200
39 , a10 out nocopy JTF_VARCHAR2_TABLE_200
40 , a11 out nocopy JTF_VARCHAR2_TABLE_200
41 , a12 out nocopy JTF_VARCHAR2_TABLE_200
42 , a13 out nocopy JTF_VARCHAR2_TABLE_200
43 , a14 out nocopy JTF_VARCHAR2_TABLE_200
44 , a15 out nocopy JTF_VARCHAR2_TABLE_200
45 , a16 out nocopy JTF_VARCHAR2_TABLE_200
46 , a17 out nocopy JTF_VARCHAR2_TABLE_200
47 , a18 out nocopy JTF_VARCHAR2_TABLE_200
48 , a19 out nocopy JTF_VARCHAR2_TABLE_200
49 , a20 out nocopy JTF_VARCHAR2_TABLE_200
50 , a21 out nocopy JTF_VARCHAR2_TABLE_200
51 , a22 out nocopy JTF_VARCHAR2_TABLE_200
52 , a23 out nocopy JTF_NUMBER_TABLE
53 , a24 out nocopy JTF_NUMBER_TABLE
54 );
55
56 procedure create_paygroup(p_api_version NUMBER
57 , p_init_msg_list VARCHAR2
58 , p_commit VARCHAR2
59 , p_validation_level NUMBER
60 , x_return_status out nocopy VARCHAR2
61 , x_msg_count out nocopy NUMBER
62 , x_msg_data out nocopy VARCHAR2
63 , p7_a0 in out nocopy NUMBER
64 , p7_a1 in out nocopy VARCHAR2
65 , p7_a2 in out nocopy VARCHAR2
66 , p7_a3 in out nocopy VARCHAR2
67 , p7_a4 in out nocopy DATE
68 , p7_a5 in out nocopy DATE
69 , p7_a6 in out nocopy VARCHAR2
70 , p7_a7 in out nocopy VARCHAR2
71 , p7_a8 in out nocopy VARCHAR2
72 , p7_a9 in out nocopy VARCHAR2
73 , p7_a10 in out nocopy VARCHAR2
74 , p7_a11 in out nocopy VARCHAR2
75 , p7_a12 in out nocopy VARCHAR2
76 , p7_a13 in out nocopy VARCHAR2
77 , p7_a14 in out nocopy VARCHAR2
78 , p7_a15 in out nocopy VARCHAR2
79 , p7_a16 in out nocopy VARCHAR2
80 , p7_a17 in out nocopy VARCHAR2
81 , p7_a18 in out nocopy VARCHAR2
82 , p7_a19 in out nocopy VARCHAR2
83 , p7_a20 in out nocopy VARCHAR2
84 , p7_a21 in out nocopy VARCHAR2
85 , p7_a22 in out nocopy VARCHAR2
86 , p7_a23 in out nocopy NUMBER
87 , p7_a24 in out nocopy NUMBER
88 , x_loading_status out nocopy VARCHAR2
89 , x_status out nocopy VARCHAR2
90 );
91 procedure update_paygroup(p_api_version NUMBER
92 , p_init_msg_list VARCHAR2
93 , p_commit VARCHAR2
94 , p_validation_level NUMBER
95 , x_return_status out nocopy VARCHAR2
96 , x_msg_count out nocopy NUMBER
97 , x_msg_data out nocopy VARCHAR2
98 , p7_a0 in out nocopy NUMBER
99 , p7_a1 in out nocopy VARCHAR2
100 , p7_a2 in out nocopy VARCHAR2
101 , p7_a3 in out nocopy VARCHAR2
102 , p7_a4 in out nocopy DATE
103 , p7_a5 in out nocopy DATE
104 , p7_a6 in out nocopy VARCHAR2
105 , p7_a7 in out nocopy VARCHAR2
106 , p7_a8 in out nocopy VARCHAR2
107 , p7_a9 in out nocopy VARCHAR2
108 , p7_a10 in out nocopy VARCHAR2
109 , p7_a11 in out nocopy VARCHAR2
110 , p7_a12 in out nocopy VARCHAR2
111 , p7_a13 in out nocopy VARCHAR2
112 , p7_a14 in out nocopy VARCHAR2
113 , p7_a15 in out nocopy VARCHAR2
114 , p7_a16 in out nocopy VARCHAR2
115 , p7_a17 in out nocopy VARCHAR2
116 , p7_a18 in out nocopy VARCHAR2
117 , p7_a19 in out nocopy VARCHAR2
118 , p7_a20 in out nocopy VARCHAR2
119 , p7_a21 in out nocopy VARCHAR2
120 , p7_a22 in out nocopy VARCHAR2
121 , p7_a23 in out nocopy NUMBER
122 , p7_a24 in out nocopy NUMBER
123 , x_status out nocopy VARCHAR2
124 , x_loading_status out nocopy VARCHAR2
125 );
126 procedure delete_paygroup(p_api_version NUMBER
127 , p_init_msg_list VARCHAR2
128 , p_commit VARCHAR2
129 , p_validation_level NUMBER
130 , x_return_status out nocopy VARCHAR2
131 , x_msg_count out nocopy NUMBER
132 , x_msg_data out nocopy VARCHAR2
133 , p7_a0 in out nocopy NUMBER
134 , p7_a1 in out nocopy VARCHAR2
135 , p7_a2 in out nocopy VARCHAR2
136 , p7_a3 in out nocopy VARCHAR2
137 , p7_a4 in out nocopy DATE
138 , p7_a5 in out nocopy DATE
139 , p7_a6 in out nocopy VARCHAR2
140 , p7_a7 in out nocopy VARCHAR2
141 , p7_a8 in out nocopy VARCHAR2
142 , p7_a9 in out nocopy VARCHAR2
143 , p7_a10 in out nocopy VARCHAR2
144 , p7_a11 in out nocopy VARCHAR2
145 , p7_a12 in out nocopy VARCHAR2
146 , p7_a13 in out nocopy VARCHAR2
147 , p7_a14 in out nocopy VARCHAR2
148 , p7_a15 in out nocopy VARCHAR2
149 , p7_a16 in out nocopy VARCHAR2
150 , p7_a17 in out nocopy VARCHAR2
151 , p7_a18 in out nocopy VARCHAR2
152 , p7_a19 in out nocopy VARCHAR2
153 , p7_a20 in out nocopy VARCHAR2
154 , p7_a21 in out nocopy VARCHAR2
155 , p7_a22 in out nocopy VARCHAR2
156 , p7_a23 in out nocopy NUMBER
157 , p7_a24 in out nocopy NUMBER
158 , x_status out nocopy VARCHAR2
159 , x_loading_status out nocopy VARCHAR2
160 );
161 end cn_paygroup_pvt_w;