[Home] [Help]
PACKAGE: APPS.OKL_IRV_PVT_W
Source
1 package okl_irv_pvt_w as
2 /* $Header: OKLIIRVS.pls 120.2 2005/07/22 10:04:35 smadhava noship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy okl_irv_pvt.okl_irv_tbl, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_NUMBER_TABLE
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_irv_pvt.okl_irv_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_NUMBER_TABLE
19 , a4 out nocopy JTF_NUMBER_TABLE
20 , a5 out nocopy JTF_NUMBER_TABLE
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 NUMBER
37 , p5_a4 NUMBER
38 , p5_a5 NUMBER
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 NUMBER
48 , p6_a4 out nocopy NUMBER
49 , p6_a5 out nocopy NUMBER
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_NUMBER_TABLE
65 , p5_a4 JTF_NUMBER_TABLE
66 , p5_a5 JTF_NUMBER_TABLE
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_NUMBER_TABLE
76 , p6_a4 out nocopy JTF_NUMBER_TABLE
77 , p6_a5 out nocopy JTF_NUMBER_TABLE
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 NUMBER
93 , p5_a4 NUMBER
94 , p5_a5 NUMBER
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 NUMBER
104 , p6_a4 out nocopy NUMBER
105 , p6_a5 out nocopy NUMBER
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_NUMBER_TABLE
121 , p5_a4 JTF_NUMBER_TABLE
122 , p5_a5 JTF_NUMBER_TABLE
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_NUMBER_TABLE
132 , p6_a4 out nocopy JTF_NUMBER_TABLE
133 , p6_a5 out nocopy JTF_NUMBER_TABLE
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 NUMBER
149 , p5_a4 NUMBER
150 , p5_a5 NUMBER
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_NUMBER_TABLE
166 , p5_a4 JTF_NUMBER_TABLE
167 , p5_a5 JTF_NUMBER_TABLE
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_irv_pvt_w;