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