[Home] [Help]
PACKAGE: APPS.OKL_ECH_PVT_W
Source
1 package okl_ech_pvt_w as
2 /* $Header: OKLIECHS.pls 120.1 2005/10/30 04:58:38 appldev noship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy okl_ech_pvt.okl_ech_tbl, 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_100
8 , a5 JTF_VARCHAR2_TABLE_100
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_DATE_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_DATE_TABLE
13 , a10 JTF_NUMBER_TABLE
14 );
15 procedure rosetta_table_copy_out_p1(t okl_ech_pvt.okl_ech_tbl, 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_100
20 , a5 out nocopy JTF_VARCHAR2_TABLE_100
21 , a6 out nocopy JTF_NUMBER_TABLE
22 , a7 out nocopy JTF_DATE_TABLE
23 , a8 out nocopy JTF_NUMBER_TABLE
24 , a9 out nocopy JTF_DATE_TABLE
25 , a10 out nocopy JTF_NUMBER_TABLE
26 );
27
28 procedure insert_row(p_api_version NUMBER
29 , p_init_msg_list VARCHAR2
30 , x_return_status out nocopy VARCHAR2
31 , x_msg_count out nocopy NUMBER
32 , x_msg_data out nocopy VARCHAR2
33 , p5_a0 NUMBER
34 , p5_a1 NUMBER
35 , p5_a2 NUMBER
36 , p5_a3 VARCHAR2
37 , p5_a4 VARCHAR2
38 , p5_a5 VARCHAR2
39 , p5_a6 NUMBER
40 , p5_a7 DATE
41 , p5_a8 NUMBER
42 , p5_a9 DATE
43 , p5_a10 NUMBER
44 , p6_a0 out nocopy NUMBER
45 , p6_a1 out nocopy NUMBER
46 , p6_a2 out nocopy NUMBER
47 , p6_a3 out nocopy VARCHAR2
48 , p6_a4 out nocopy VARCHAR2
49 , p6_a5 out nocopy VARCHAR2
50 , p6_a6 out nocopy NUMBER
51 , p6_a7 out nocopy DATE
52 , p6_a8 out nocopy NUMBER
53 , p6_a9 out nocopy DATE
54 , p6_a10 out nocopy NUMBER
55 );
56 procedure insert_row(p_api_version NUMBER
57 , p_init_msg_list VARCHAR2
58 , x_return_status out nocopy VARCHAR2
59 , x_msg_count out nocopy NUMBER
60 , x_msg_data out nocopy VARCHAR2
61 , p5_a0 JTF_NUMBER_TABLE
62 , p5_a1 JTF_NUMBER_TABLE
63 , p5_a2 JTF_NUMBER_TABLE
64 , p5_a3 JTF_VARCHAR2_TABLE_100
65 , p5_a4 JTF_VARCHAR2_TABLE_100
66 , p5_a5 JTF_VARCHAR2_TABLE_100
67 , p5_a6 JTF_NUMBER_TABLE
68 , p5_a7 JTF_DATE_TABLE
69 , p5_a8 JTF_NUMBER_TABLE
70 , p5_a9 JTF_DATE_TABLE
71 , p5_a10 JTF_NUMBER_TABLE
72 , p6_a0 out nocopy JTF_NUMBER_TABLE
73 , p6_a1 out nocopy JTF_NUMBER_TABLE
74 , p6_a2 out nocopy JTF_NUMBER_TABLE
75 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
76 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
77 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
78 , p6_a6 out nocopy JTF_NUMBER_TABLE
79 , p6_a7 out nocopy JTF_DATE_TABLE
80 , p6_a8 out nocopy JTF_NUMBER_TABLE
81 , p6_a9 out nocopy JTF_DATE_TABLE
82 , p6_a10 out nocopy JTF_NUMBER_TABLE
83 );
84 procedure update_row(p_api_version NUMBER
85 , p_init_msg_list VARCHAR2
86 , x_return_status out nocopy VARCHAR2
87 , x_msg_count out nocopy NUMBER
88 , x_msg_data out nocopy VARCHAR2
89 , p5_a0 NUMBER
90 , p5_a1 NUMBER
91 , p5_a2 NUMBER
92 , p5_a3 VARCHAR2
93 , p5_a4 VARCHAR2
94 , p5_a5 VARCHAR2
95 , p5_a6 NUMBER
96 , p5_a7 DATE
97 , p5_a8 NUMBER
98 , p5_a9 DATE
99 , p5_a10 NUMBER
100 , p6_a0 out nocopy NUMBER
101 , p6_a1 out nocopy NUMBER
102 , p6_a2 out nocopy NUMBER
103 , p6_a3 out nocopy VARCHAR2
104 , p6_a4 out nocopy VARCHAR2
105 , p6_a5 out nocopy VARCHAR2
106 , p6_a6 out nocopy NUMBER
107 , p6_a7 out nocopy DATE
108 , p6_a8 out nocopy NUMBER
109 , p6_a9 out nocopy DATE
110 , p6_a10 out nocopy NUMBER
111 );
112 procedure update_row(p_api_version NUMBER
113 , p_init_msg_list VARCHAR2
114 , x_return_status out nocopy VARCHAR2
115 , x_msg_count out nocopy NUMBER
116 , x_msg_data out nocopy VARCHAR2
117 , p5_a0 JTF_NUMBER_TABLE
118 , p5_a1 JTF_NUMBER_TABLE
119 , p5_a2 JTF_NUMBER_TABLE
120 , p5_a3 JTF_VARCHAR2_TABLE_100
121 , p5_a4 JTF_VARCHAR2_TABLE_100
122 , p5_a5 JTF_VARCHAR2_TABLE_100
123 , p5_a6 JTF_NUMBER_TABLE
124 , p5_a7 JTF_DATE_TABLE
125 , p5_a8 JTF_NUMBER_TABLE
126 , p5_a9 JTF_DATE_TABLE
127 , p5_a10 JTF_NUMBER_TABLE
128 , p6_a0 out nocopy JTF_NUMBER_TABLE
129 , p6_a1 out nocopy JTF_NUMBER_TABLE
130 , p6_a2 out nocopy JTF_NUMBER_TABLE
131 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
132 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
133 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
134 , p6_a6 out nocopy JTF_NUMBER_TABLE
135 , p6_a7 out nocopy JTF_DATE_TABLE
136 , p6_a8 out nocopy JTF_NUMBER_TABLE
137 , p6_a9 out nocopy JTF_DATE_TABLE
138 , p6_a10 out nocopy JTF_NUMBER_TABLE
139 );
140 procedure delete_row(p_api_version NUMBER
141 , p_init_msg_list VARCHAR2
142 , x_return_status out nocopy VARCHAR2
143 , x_msg_count out nocopy NUMBER
144 , x_msg_data out nocopy VARCHAR2
145 , p5_a0 NUMBER
146 , p5_a1 NUMBER
147 , p5_a2 NUMBER
148 , p5_a3 VARCHAR2
149 , p5_a4 VARCHAR2
150 , p5_a5 VARCHAR2
151 , p5_a6 NUMBER
152 , p5_a7 DATE
153 , p5_a8 NUMBER
154 , p5_a9 DATE
155 , p5_a10 NUMBER
156 );
157 procedure delete_row(p_api_version NUMBER
158 , p_init_msg_list VARCHAR2
159 , x_return_status out nocopy VARCHAR2
160 , x_msg_count out nocopy NUMBER
161 , x_msg_data out nocopy VARCHAR2
162 , p5_a0 JTF_NUMBER_TABLE
163 , p5_a1 JTF_NUMBER_TABLE
164 , p5_a2 JTF_NUMBER_TABLE
165 , p5_a3 JTF_VARCHAR2_TABLE_100
166 , p5_a4 JTF_VARCHAR2_TABLE_100
167 , p5_a5 JTF_VARCHAR2_TABLE_100
168 , p5_a6 JTF_NUMBER_TABLE
169 , p5_a7 JTF_DATE_TABLE
170 , p5_a8 JTF_NUMBER_TABLE
171 , p5_a9 JTF_DATE_TABLE
172 , p5_a10 JTF_NUMBER_TABLE
173 );
174 end okl_ech_pvt_w;