DBA Data[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;