1 package cn_srp_paygroup_pvt_w as
2 /* $Header: cnwsdpgs.pls 120.1 2005/09/14 03:43:26 vensrini noship $ */
3 procedure create_srp_pay_group(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , p_commit VARCHAR2
6 , p_validation_level NUMBER
7 , x_return_status out nocopy VARCHAR2
8 , x_loading_status out nocopy VARCHAR2
9 , x_msg_count out nocopy NUMBER
10 , x_msg_data out nocopy VARCHAR2
11 , p8_a0 in out nocopy NUMBER
12 , p8_a1 in out nocopy NUMBER
13 , p8_a2 in out nocopy NUMBER
14 , p8_a3 in out nocopy DATE
15 , p8_a4 in out nocopy DATE
16 , p8_a5 in out nocopy VARCHAR2
17 , p8_a6 in out nocopy NUMBER
18 , p8_a7 in out nocopy NUMBER
19 , p8_a8 in out nocopy NUMBER
20 , p8_a9 in out nocopy VARCHAR2
21 , p8_a10 in out nocopy VARCHAR2
22 , p8_a11 in out nocopy VARCHAR2
23 , p8_a12 in out nocopy VARCHAR2
24 , p8_a13 in out nocopy VARCHAR2
25 , p8_a14 in out nocopy VARCHAR2
26 , p8_a15 in out nocopy VARCHAR2
27 , p8_a16 in out nocopy VARCHAR2
28 , p8_a17 in out nocopy VARCHAR2
29 , p8_a18 in out nocopy VARCHAR2
30 , p8_a19 in out nocopy VARCHAR2
31 , p8_a20 in out nocopy VARCHAR2
32 , p8_a21 in out nocopy VARCHAR2
33 , p8_a22 in out nocopy VARCHAR2
34 , p8_a23 in out nocopy VARCHAR2
35 , p8_a24 in out nocopy VARCHAR2
36 );
37 procedure update_srp_pay_group(p_api_version NUMBER
38 , p_init_msg_list VARCHAR2
39 , p_commit VARCHAR2
40 , p_validation_level NUMBER
41 , x_return_status out nocopy VARCHAR2
42 , x_loading_status out nocopy VARCHAR2
43 , x_msg_count out nocopy NUMBER
44 , x_msg_data out nocopy VARCHAR2
45 , p8_a0 in out nocopy NUMBER
46 , p8_a1 in out nocopy NUMBER
47 , p8_a2 in out nocopy NUMBER
48 , p8_a3 in out nocopy DATE
49 , p8_a4 in out nocopy DATE
50 , p8_a5 in out nocopy VARCHAR2
51 , p8_a6 in out nocopy NUMBER
52 , p8_a7 in out nocopy NUMBER
53 , p8_a8 in out nocopy NUMBER
54 , p8_a9 in out nocopy VARCHAR2
55 , p8_a10 in out nocopy VARCHAR2
56 , p8_a11 in out nocopy VARCHAR2
57 , p8_a12 in out nocopy VARCHAR2
58 , p8_a13 in out nocopy VARCHAR2
59 , p8_a14 in out nocopy VARCHAR2
60 , p8_a15 in out nocopy VARCHAR2
61 , p8_a16 in out nocopy VARCHAR2
62 , p8_a17 in out nocopy VARCHAR2
63 , p8_a18 in out nocopy VARCHAR2
64 , p8_a19 in out nocopy VARCHAR2
65 , p8_a20 in out nocopy VARCHAR2
66 , p8_a21 in out nocopy VARCHAR2
67 , p8_a22 in out nocopy VARCHAR2
68 , p8_a23 in out nocopy VARCHAR2
69 , p8_a24 in out nocopy VARCHAR2
70 );
71 procedure delete_srp_pay_group(p_api_version NUMBER
72 , p_init_msg_list VARCHAR2
73 , p_commit VARCHAR2
74 , p_validation_level NUMBER
75 , x_return_status out nocopy VARCHAR2
76 , x_loading_status out nocopy VARCHAR2
77 , x_msg_count out nocopy NUMBER
78 , x_msg_data out nocopy VARCHAR2
79 , p8_a0 NUMBER
80 , p8_a1 NUMBER
81 , p8_a2 NUMBER
82 , p8_a3 DATE
83 , p8_a4 DATE
84 , p8_a5 VARCHAR2
85 , p8_a6 NUMBER
86 , p8_a7 NUMBER
87 , p8_a8 NUMBER
88 , p8_a9 VARCHAR2
89 , p8_a10 VARCHAR2
90 , p8_a11 VARCHAR2
91 , p8_a12 VARCHAR2
92 , p8_a13 VARCHAR2
93 , p8_a14 VARCHAR2
94 , p8_a15 VARCHAR2
95 , p8_a16 VARCHAR2
96 , p8_a17 VARCHAR2
97 , p8_a18 VARCHAR2
98 , p8_a19 VARCHAR2
99 , p8_a20 VARCHAR2
100 , p8_a21 VARCHAR2
101 , p8_a22 VARCHAR2
102 , p8_a23 VARCHAR2
103 , p8_a24 VARCHAR2
104 );
105 procedure valid_delete_srp_pay_group(p0_a0 NUMBER
106 , p0_a1 NUMBER
107 , p0_a2 NUMBER
108 , p0_a3 DATE
109 , p0_a4 DATE
110 , p0_a5 VARCHAR2
111 , p0_a6 NUMBER
112 , p0_a7 NUMBER
113 , p0_a8 NUMBER
114 , p0_a9 VARCHAR2
115 , p0_a10 VARCHAR2
116 , p0_a11 VARCHAR2
117 , p0_a12 VARCHAR2
118 , p0_a13 VARCHAR2
119 , p0_a14 VARCHAR2
120 , p0_a15 VARCHAR2
121 , p0_a16 VARCHAR2
122 , p0_a17 VARCHAR2
123 , p0_a18 VARCHAR2
124 , p0_a19 VARCHAR2
125 , p0_a20 VARCHAR2
126 , p0_a21 VARCHAR2
127 , p0_a22 VARCHAR2
128 , p0_a23 VARCHAR2
129 , p0_a24 VARCHAR2
130 , p_init_msg_list VARCHAR2
131 , x_loading_status out nocopy VARCHAR2
132 , x_return_status out nocopy VARCHAR2
133 , x_msg_count out nocopy NUMBER
134 , x_msg_data out nocopy VARCHAR2
135 );
136 end cn_srp_paygroup_pvt_w;