[Home] [Help]
PACKAGE: APPS.CN_ROLE_PMT_PLANS_PVT_W
Source
1 package cn_role_pmt_plans_pvt_w AUTHID CURRENT_USER as
2 /* $Header: cnwrptps.pls 120.6 2005/09/14 03:42 vensrini noship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy cn_role_pmt_plans_pvt.role_pmt_plan_rec_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_DATE_TABLE
9 , a6 JTF_DATE_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_200
27 );
28 procedure rosetta_table_copy_out_p1(t cn_role_pmt_plans_pvt.role_pmt_plan_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
29 , a1 out nocopy JTF_NUMBER_TABLE
30 , a2 out nocopy JTF_VARCHAR2_TABLE_100
31 , a3 out nocopy JTF_VARCHAR2_TABLE_100
32 , a4 out nocopy JTF_NUMBER_TABLE
33 , a5 out nocopy JTF_DATE_TABLE
34 , a6 out nocopy JTF_DATE_TABLE
35 , a7 out nocopy JTF_NUMBER_TABLE
36 , a8 out nocopy JTF_VARCHAR2_TABLE_100
37 , a9 out nocopy JTF_VARCHAR2_TABLE_200
38 , a10 out nocopy JTF_VARCHAR2_TABLE_200
39 , a11 out nocopy JTF_VARCHAR2_TABLE_200
40 , a12 out nocopy JTF_VARCHAR2_TABLE_200
41 , a13 out nocopy JTF_VARCHAR2_TABLE_200
42 , a14 out nocopy JTF_VARCHAR2_TABLE_200
43 , a15 out nocopy JTF_VARCHAR2_TABLE_200
44 , a16 out nocopy JTF_VARCHAR2_TABLE_200
45 , a17 out nocopy JTF_VARCHAR2_TABLE_200
46 , a18 out nocopy JTF_VARCHAR2_TABLE_200
47 , a19 out nocopy JTF_VARCHAR2_TABLE_200
48 , a20 out nocopy JTF_VARCHAR2_TABLE_200
49 , a21 out nocopy JTF_VARCHAR2_TABLE_200
50 , a22 out nocopy JTF_VARCHAR2_TABLE_200
51 , a23 out nocopy JTF_VARCHAR2_TABLE_200
52 );
53
54 procedure create_role_pmt_plan(p_api_version NUMBER
55 , p_init_msg_list VARCHAR2
56 , p_commit VARCHAR2
57 , p_validation_level NUMBER
58 , x_return_status out nocopy VARCHAR2
59 , x_loading_status out nocopy VARCHAR2
60 , x_msg_count out nocopy NUMBER
61 , x_msg_data out nocopy VARCHAR2
62 , p8_a0 NUMBER
63 , p8_a1 NUMBER
64 , p8_a2 VARCHAR2
65 , p8_a3 VARCHAR2
66 , p8_a4 NUMBER
67 , p8_a5 DATE
68 , p8_a6 DATE
69 , p8_a7 NUMBER
70 , p8_a8 VARCHAR2
71 , p8_a9 VARCHAR2
72 , p8_a10 VARCHAR2
73 , p8_a11 VARCHAR2
74 , p8_a12 VARCHAR2
75 , p8_a13 VARCHAR2
76 , p8_a14 VARCHAR2
77 , p8_a15 VARCHAR2
78 , p8_a16 VARCHAR2
79 , p8_a17 VARCHAR2
80 , p8_a18 VARCHAR2
81 , p8_a19 VARCHAR2
82 , p8_a20 VARCHAR2
83 , p8_a21 VARCHAR2
84 , p8_a22 VARCHAR2
85 , p8_a23 VARCHAR2
86 );
87 procedure update_role_pmt_plan(p_api_version NUMBER
88 , p_init_msg_list VARCHAR2
89 , p_commit VARCHAR2
90 , p_validation_level NUMBER
91 , x_return_status out nocopy VARCHAR2
92 , x_loading_status out nocopy VARCHAR2
93 , x_msg_count out nocopy NUMBER
94 , x_msg_data out nocopy VARCHAR2
95 , p8_a0 NUMBER
96 , p8_a1 NUMBER
97 , p8_a2 VARCHAR2
98 , p8_a3 VARCHAR2
99 , p8_a4 NUMBER
100 , p8_a5 DATE
101 , p8_a6 DATE
102 , p8_a7 NUMBER
103 , p8_a8 VARCHAR2
104 , p8_a9 VARCHAR2
105 , p8_a10 VARCHAR2
106 , p8_a11 VARCHAR2
107 , p8_a12 VARCHAR2
108 , p8_a13 VARCHAR2
109 , p8_a14 VARCHAR2
110 , p8_a15 VARCHAR2
111 , p8_a16 VARCHAR2
112 , p8_a17 VARCHAR2
113 , p8_a18 VARCHAR2
114 , p8_a19 VARCHAR2
115 , p8_a20 VARCHAR2
116 , p8_a21 VARCHAR2
117 , p8_a22 VARCHAR2
118 , p8_a23 VARCHAR2
119 , p_ovn NUMBER
120 , p10_a0 NUMBER
121 , p10_a1 NUMBER
122 , p10_a2 VARCHAR2
123 , p10_a3 VARCHAR2
124 , p10_a4 NUMBER
125 , p10_a5 DATE
126 , p10_a6 DATE
127 , p10_a7 NUMBER
128 , p10_a8 VARCHAR2
129 , p10_a9 VARCHAR2
130 , p10_a10 VARCHAR2
131 , p10_a11 VARCHAR2
132 , p10_a12 VARCHAR2
133 , p10_a13 VARCHAR2
134 , p10_a14 VARCHAR2
135 , p10_a15 VARCHAR2
136 , p10_a16 VARCHAR2
137 , p10_a17 VARCHAR2
138 , p10_a18 VARCHAR2
139 , p10_a19 VARCHAR2
140 , p10_a20 VARCHAR2
141 , p10_a21 VARCHAR2
142 , p10_a22 VARCHAR2
143 , p10_a23 VARCHAR2
144 );
145 procedure delete_role_pmt_plan(p_api_version NUMBER
146 , p_init_msg_list VARCHAR2
147 , p_commit VARCHAR2
148 , p_validation_level NUMBER
149 , x_return_status out nocopy VARCHAR2
150 , x_loading_status out nocopy VARCHAR2
151 , x_msg_count out nocopy NUMBER
152 , x_msg_data out nocopy VARCHAR2
153 , p8_a0 NUMBER
154 , p8_a1 NUMBER
155 , p8_a2 VARCHAR2
156 , p8_a3 VARCHAR2
157 , p8_a4 NUMBER
158 , p8_a5 DATE
159 , p8_a6 DATE
160 , p8_a7 NUMBER
161 , p8_a8 VARCHAR2
162 , p8_a9 VARCHAR2
163 , p8_a10 VARCHAR2
164 , p8_a11 VARCHAR2
165 , p8_a12 VARCHAR2
166 , p8_a13 VARCHAR2
167 , p8_a14 VARCHAR2
168 , p8_a15 VARCHAR2
169 , p8_a16 VARCHAR2
170 , p8_a17 VARCHAR2
171 , p8_a18 VARCHAR2
172 , p8_a19 VARCHAR2
173 , p8_a20 VARCHAR2
174 , p8_a21 VARCHAR2
175 , p8_a22 VARCHAR2
176 , p8_a23 VARCHAR2
177 );
178 end cn_role_pmt_plans_pvt_w;