[Home] [Help]
PACKAGE: APPS.JTS_CONFIGURATION_PVT_W
Source
1 package jts_configuration_pvt_w AUTHID CURRENT_USER as
2 /* $Header: jtswcfgs.pls 115.4 2002/03/22 19:07:54 pkm ship $ */
3 procedure rosetta_table_copy_in_p5(t out jts_configuration_pvt.config_rec_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_VARCHAR2_TABLE_100
5 , a2 JTF_VARCHAR2_TABLE_300
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_VARCHAR2_TABLE_100
8 , a5 JTF_VARCHAR2_TABLE_100
9 , a6 JTF_VARCHAR2_TABLE_100
10 , a7 JTF_VARCHAR2_TABLE_100
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 , a24 JTF_VARCHAR2_TABLE_200
28 , a25 JTF_DATE_TABLE
29 , a26 JTF_NUMBER_TABLE
30 , a27 JTF_DATE_TABLE
31 , a28 JTF_NUMBER_TABLE
32 , a29 JTF_NUMBER_TABLE
33 , a30 JTF_VARCHAR2_TABLE_100
34 , a31 JTF_VARCHAR2_TABLE_100
35 );
36 procedure rosetta_table_copy_out_p5(t jts_configuration_pvt.config_rec_tbl_type, a0 out JTF_NUMBER_TABLE
37 , a1 out JTF_VARCHAR2_TABLE_100
38 , a2 out JTF_VARCHAR2_TABLE_300
39 , a3 out JTF_NUMBER_TABLE
40 , a4 out JTF_VARCHAR2_TABLE_100
41 , a5 out JTF_VARCHAR2_TABLE_100
42 , a6 out JTF_VARCHAR2_TABLE_100
43 , a7 out JTF_VARCHAR2_TABLE_100
44 , a8 out JTF_VARCHAR2_TABLE_100
45 , a9 out JTF_VARCHAR2_TABLE_200
46 , a10 out JTF_VARCHAR2_TABLE_200
47 , a11 out JTF_VARCHAR2_TABLE_200
48 , a12 out JTF_VARCHAR2_TABLE_200
49 , a13 out JTF_VARCHAR2_TABLE_200
50 , a14 out JTF_VARCHAR2_TABLE_200
51 , a15 out JTF_VARCHAR2_TABLE_200
52 , a16 out JTF_VARCHAR2_TABLE_200
53 , a17 out JTF_VARCHAR2_TABLE_200
54 , a18 out JTF_VARCHAR2_TABLE_200
55 , a19 out JTF_VARCHAR2_TABLE_200
56 , a20 out JTF_VARCHAR2_TABLE_200
57 , a21 out JTF_VARCHAR2_TABLE_200
58 , a22 out JTF_VARCHAR2_TABLE_200
59 , a23 out JTF_VARCHAR2_TABLE_200
60 , a24 out JTF_VARCHAR2_TABLE_200
61 , a25 out JTF_DATE_TABLE
62 , a26 out JTF_NUMBER_TABLE
63 , a27 out JTF_DATE_TABLE
64 , a28 out JTF_NUMBER_TABLE
65 , a29 out JTF_NUMBER_TABLE
66 , a30 out JTF_VARCHAR2_TABLE_100
67 , a31 out JTF_VARCHAR2_TABLE_100
68 );
69
70 procedure create_configuration(p_api_version NUMBER
71 , x_config_id out NUMBER
72 , x_return_status out VARCHAR2
73 , x_msg_count out NUMBER
74 , x_msg_data out VARCHAR2
75 , p1_a0 NUMBER := 0-1962.0724
76 , p1_a1 VARCHAR2 := fnd_api.g_miss_char
77 , p1_a2 VARCHAR2 := fnd_api.g_miss_char
78 , p1_a3 NUMBER := 0-1962.0724
79 , p1_a4 VARCHAR2 := fnd_api.g_miss_char
80 , p1_a5 VARCHAR2 := fnd_api.g_miss_char
81 , p1_a6 VARCHAR2 := fnd_api.g_miss_char
82 , p1_a7 VARCHAR2 := fnd_api.g_miss_char
83 , p1_a8 VARCHAR2 := fnd_api.g_miss_char
84 , p1_a9 VARCHAR2 := fnd_api.g_miss_char
85 , p1_a10 VARCHAR2 := fnd_api.g_miss_char
86 , p1_a11 VARCHAR2 := fnd_api.g_miss_char
87 , p1_a12 VARCHAR2 := fnd_api.g_miss_char
88 , p1_a13 VARCHAR2 := fnd_api.g_miss_char
89 , p1_a14 VARCHAR2 := fnd_api.g_miss_char
90 , p1_a15 VARCHAR2 := fnd_api.g_miss_char
91 , p1_a16 VARCHAR2 := fnd_api.g_miss_char
92 , p1_a17 VARCHAR2 := fnd_api.g_miss_char
93 , p1_a18 VARCHAR2 := fnd_api.g_miss_char
94 , p1_a19 VARCHAR2 := fnd_api.g_miss_char
95 , p1_a20 VARCHAR2 := fnd_api.g_miss_char
96 , p1_a21 VARCHAR2 := fnd_api.g_miss_char
97 , p1_a22 VARCHAR2 := fnd_api.g_miss_char
98 , p1_a23 VARCHAR2 := fnd_api.g_miss_char
99 , p1_a24 VARCHAR2 := fnd_api.g_miss_char
100 , p1_a25 DATE := fnd_api.g_miss_date
101 , p1_a26 NUMBER := 0-1962.0724
102 , p1_a27 DATE := fnd_api.g_miss_date
103 , p1_a28 NUMBER := 0-1962.0724
104 , p1_a29 NUMBER := 0-1962.0724
105 , p1_a30 VARCHAR2 := fnd_api.g_miss_char
106 , p1_a31 VARCHAR2 := fnd_api.g_miss_char
107 );
108 procedure get_configuration(p_api_version NUMBER
109 , p_init_msg_list VARCHAR2
110 , p_config_id NUMBER
111 , p3_a0 out NUMBER
112 , p3_a1 out VARCHAR2
113 , p3_a2 out VARCHAR2
114 , p3_a3 out NUMBER
115 , p3_a4 out VARCHAR2
116 , p3_a5 out VARCHAR2
117 , p3_a6 out VARCHAR2
118 , p3_a7 out VARCHAR2
119 , p3_a8 out VARCHAR2
120 , p3_a9 out VARCHAR2
121 , p3_a10 out VARCHAR2
122 , p3_a11 out VARCHAR2
123 , p3_a12 out VARCHAR2
124 , p3_a13 out VARCHAR2
125 , p3_a14 out VARCHAR2
126 , p3_a15 out VARCHAR2
127 , p3_a16 out VARCHAR2
128 , p3_a17 out VARCHAR2
129 , p3_a18 out VARCHAR2
130 , p3_a19 out VARCHAR2
131 , p3_a20 out VARCHAR2
132 , p3_a21 out VARCHAR2
133 , p3_a22 out VARCHAR2
134 , p3_a23 out VARCHAR2
135 , p3_a24 out VARCHAR2
136 , p3_a25 out DATE
137 , p3_a26 out NUMBER
138 , p3_a27 out DATE
139 , p3_a28 out NUMBER
140 , p3_a29 out NUMBER
141 , p3_a30 out VARCHAR2
142 , p3_a31 out VARCHAR2
143 , x_return_status out VARCHAR2
144 , x_msg_count out NUMBER
145 , x_msg_data out VARCHAR2
146 );
147 procedure get_configurations(p_api_version NUMBER
148 , p_where_clause VARCHAR2
149 , p_order_by VARCHAR2
150 , p_how_to_order VARCHAR2
151 , p4_a0 out JTF_NUMBER_TABLE
152 , p4_a1 out JTF_VARCHAR2_TABLE_100
153 , p4_a2 out JTF_VARCHAR2_TABLE_300
154 , p4_a3 out JTF_NUMBER_TABLE
155 , p4_a4 out JTF_VARCHAR2_TABLE_100
156 , p4_a5 out JTF_VARCHAR2_TABLE_100
157 , p4_a6 out JTF_VARCHAR2_TABLE_100
158 , p4_a7 out JTF_VARCHAR2_TABLE_100
159 , p4_a8 out JTF_VARCHAR2_TABLE_100
160 , p4_a9 out JTF_VARCHAR2_TABLE_200
161 , p4_a10 out JTF_VARCHAR2_TABLE_200
162 , p4_a11 out JTF_VARCHAR2_TABLE_200
163 , p4_a12 out JTF_VARCHAR2_TABLE_200
164 , p4_a13 out JTF_VARCHAR2_TABLE_200
165 , p4_a14 out JTF_VARCHAR2_TABLE_200
166 , p4_a15 out JTF_VARCHAR2_TABLE_200
167 , p4_a16 out JTF_VARCHAR2_TABLE_200
168 , p4_a17 out JTF_VARCHAR2_TABLE_200
169 , p4_a18 out JTF_VARCHAR2_TABLE_200
170 , p4_a19 out JTF_VARCHAR2_TABLE_200
171 , p4_a20 out JTF_VARCHAR2_TABLE_200
172 , p4_a21 out JTF_VARCHAR2_TABLE_200
173 , p4_a22 out JTF_VARCHAR2_TABLE_200
174 , p4_a23 out JTF_VARCHAR2_TABLE_200
175 , p4_a24 out JTF_VARCHAR2_TABLE_200
176 , p4_a25 out JTF_DATE_TABLE
177 , p4_a26 out JTF_NUMBER_TABLE
178 , p4_a27 out JTF_DATE_TABLE
179 , p4_a28 out JTF_NUMBER_TABLE
180 , p4_a29 out JTF_NUMBER_TABLE
181 , p4_a30 out JTF_VARCHAR2_TABLE_100
182 , p4_a31 out JTF_VARCHAR2_TABLE_100
183 , x_return_status out VARCHAR2
184 , x_msg_count out NUMBER
185 , x_msg_data out VARCHAR2
186 );
187 end jts_configuration_pvt_w;