eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.OZF_PROCESS_SETUP_PVT_W

Source


1 package ozf_process_setup_pvt_w as
2   /* $Header: ozfwpses.pls 120.0 2007/12/21 07:19:21 gdeepika noship $ */
3   procedure rosetta_table_copy_in_p3(t out nocopy ozf_process_setup_pvt.process_setup_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_DATE_TABLE
6     , a3 JTF_NUMBER_TABLE
7     , a4 JTF_DATE_TABLE
8     , a5 JTF_NUMBER_TABLE
9     , a6 JTF_NUMBER_TABLE
10     , a7 JTF_NUMBER_TABLE
11     , a8 JTF_NUMBER_TABLE
12     , a9 JTF_DATE_TABLE
13     , a10 JTF_NUMBER_TABLE
14     , a11 JTF_VARCHAR2_TABLE_100
15     , a12 JTF_NUMBER_TABLE
16     , a13 JTF_NUMBER_TABLE
17     , a14 JTF_VARCHAR2_TABLE_100
18     , a15 JTF_VARCHAR2_TABLE_100
19     , a16 JTF_VARCHAR2_TABLE_100
20     , a17 JTF_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_200
29     , a26 JTF_VARCHAR2_TABLE_200
30     , a27 JTF_VARCHAR2_TABLE_200
31     , a28 JTF_VARCHAR2_TABLE_200
32     , a29 JTF_VARCHAR2_TABLE_200
33     , a30 JTF_VARCHAR2_TABLE_200
34     , a31 JTF_VARCHAR2_TABLE_200
35     , a32 JTF_VARCHAR2_TABLE_200
36     , a33 JTF_NUMBER_TABLE
37     );
38   procedure rosetta_table_copy_out_p3(t ozf_process_setup_pvt.process_setup_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
39     , a1 out nocopy JTF_NUMBER_TABLE
40     , a2 out nocopy JTF_DATE_TABLE
41     , a3 out nocopy JTF_NUMBER_TABLE
42     , a4 out nocopy JTF_DATE_TABLE
43     , a5 out nocopy JTF_NUMBER_TABLE
44     , a6 out nocopy JTF_NUMBER_TABLE
45     , a7 out nocopy JTF_NUMBER_TABLE
46     , a8 out nocopy JTF_NUMBER_TABLE
47     , a9 out nocopy JTF_DATE_TABLE
48     , a10 out nocopy JTF_NUMBER_TABLE
49     , a11 out nocopy JTF_VARCHAR2_TABLE_100
50     , a12 out nocopy JTF_NUMBER_TABLE
51     , a13 out nocopy JTF_NUMBER_TABLE
52     , a14 out nocopy JTF_VARCHAR2_TABLE_100
53     , a15 out nocopy JTF_VARCHAR2_TABLE_100
54     , a16 out nocopy JTF_VARCHAR2_TABLE_100
55     , a17 out nocopy JTF_VARCHAR2_TABLE_100
56     , a18 out nocopy JTF_VARCHAR2_TABLE_200
57     , a19 out nocopy JTF_VARCHAR2_TABLE_200
58     , a20 out nocopy JTF_VARCHAR2_TABLE_200
59     , a21 out nocopy JTF_VARCHAR2_TABLE_200
60     , a22 out nocopy JTF_VARCHAR2_TABLE_200
61     , a23 out nocopy JTF_VARCHAR2_TABLE_200
62     , a24 out nocopy JTF_VARCHAR2_TABLE_200
63     , a25 out nocopy JTF_VARCHAR2_TABLE_200
64     , a26 out nocopy JTF_VARCHAR2_TABLE_200
65     , a27 out nocopy JTF_VARCHAR2_TABLE_200
66     , a28 out nocopy JTF_VARCHAR2_TABLE_200
67     , a29 out nocopy JTF_VARCHAR2_TABLE_200
68     , a30 out nocopy JTF_VARCHAR2_TABLE_200
69     , a31 out nocopy JTF_VARCHAR2_TABLE_200
70     , a32 out nocopy JTF_VARCHAR2_TABLE_200
71     , a33 out nocopy JTF_NUMBER_TABLE
72     );
73 
74   procedure update_process_setup_tbl(p_api_version_number  NUMBER
75     , p_init_msg_list  VARCHAR2
76     , p_commit  VARCHAR2
77     , p_validation_level  NUMBER
78     , x_return_status out nocopy  VARCHAR2
79     , x_msg_count out nocopy  NUMBER
80     , x_msg_data out nocopy  VARCHAR2
81     , p7_a0 JTF_NUMBER_TABLE
82     , p7_a1 JTF_NUMBER_TABLE
83     , p7_a2 JTF_DATE_TABLE
84     , p7_a3 JTF_NUMBER_TABLE
85     , p7_a4 JTF_DATE_TABLE
86     , p7_a5 JTF_NUMBER_TABLE
87     , p7_a6 JTF_NUMBER_TABLE
88     , p7_a7 JTF_NUMBER_TABLE
89     , p7_a8 JTF_NUMBER_TABLE
90     , p7_a9 JTF_DATE_TABLE
91     , p7_a10 JTF_NUMBER_TABLE
92     , p7_a11 JTF_VARCHAR2_TABLE_100
93     , p7_a12 JTF_NUMBER_TABLE
94     , p7_a13 JTF_NUMBER_TABLE
95     , p7_a14 JTF_VARCHAR2_TABLE_100
96     , p7_a15 JTF_VARCHAR2_TABLE_100
97     , p7_a16 JTF_VARCHAR2_TABLE_100
98     , p7_a17 JTF_VARCHAR2_TABLE_100
99     , p7_a18 JTF_VARCHAR2_TABLE_200
100     , p7_a19 JTF_VARCHAR2_TABLE_200
101     , p7_a20 JTF_VARCHAR2_TABLE_200
102     , p7_a21 JTF_VARCHAR2_TABLE_200
103     , p7_a22 JTF_VARCHAR2_TABLE_200
104     , p7_a23 JTF_VARCHAR2_TABLE_200
105     , p7_a24 JTF_VARCHAR2_TABLE_200
106     , p7_a25 JTF_VARCHAR2_TABLE_200
107     , p7_a26 JTF_VARCHAR2_TABLE_200
108     , p7_a27 JTF_VARCHAR2_TABLE_200
109     , p7_a28 JTF_VARCHAR2_TABLE_200
110     , p7_a29 JTF_VARCHAR2_TABLE_200
111     , p7_a30 JTF_VARCHAR2_TABLE_200
112     , p7_a31 JTF_VARCHAR2_TABLE_200
113     , p7_a32 JTF_VARCHAR2_TABLE_200
114     , p7_a33 JTF_NUMBER_TABLE
115   );
116   procedure check_uniq_process_setup(p0_a0  NUMBER
117     , p0_a1  NUMBER
118     , p0_a2  DATE
119     , p0_a3  NUMBER
120     , p0_a4  DATE
121     , p0_a5  NUMBER
122     , p0_a6  NUMBER
123     , p0_a7  NUMBER
124     , p0_a8  NUMBER
125     , p0_a9  DATE
126     , p0_a10  NUMBER
127     , p0_a11  VARCHAR2
128     , p0_a12  NUMBER
129     , p0_a13  NUMBER
130     , p0_a14  VARCHAR2
131     , p0_a15  VARCHAR2
132     , p0_a16  VARCHAR2
133     , p0_a17  VARCHAR2
134     , p0_a18  VARCHAR2
135     , p0_a19  VARCHAR2
136     , p0_a20  VARCHAR2
137     , p0_a21  VARCHAR2
138     , p0_a22  VARCHAR2
139     , p0_a23  VARCHAR2
140     , p0_a24  VARCHAR2
141     , p0_a25  VARCHAR2
142     , p0_a26  VARCHAR2
143     , p0_a27  VARCHAR2
144     , p0_a28  VARCHAR2
145     , p0_a29  VARCHAR2
146     , p0_a30  VARCHAR2
147     , p0_a31  VARCHAR2
148     , p0_a32  VARCHAR2
149     , p0_a33  NUMBER
150     , p_validation_mode  VARCHAR2
151     , x_return_status out nocopy  VARCHAR2
152   );
153   procedure validate_process_setup(p_api_version_number  NUMBER
154     , p_init_msg_list  VARCHAR2
155     , p_validation_level  NUMBER
156     , p_validation_mode  VARCHAR2
157     , p4_a0 JTF_NUMBER_TABLE
158     , p4_a1 JTF_NUMBER_TABLE
159     , p4_a2 JTF_DATE_TABLE
160     , p4_a3 JTF_NUMBER_TABLE
161     , p4_a4 JTF_DATE_TABLE
162     , p4_a5 JTF_NUMBER_TABLE
163     , p4_a6 JTF_NUMBER_TABLE
164     , p4_a7 JTF_NUMBER_TABLE
165     , p4_a8 JTF_NUMBER_TABLE
166     , p4_a9 JTF_DATE_TABLE
167     , p4_a10 JTF_NUMBER_TABLE
168     , p4_a11 JTF_VARCHAR2_TABLE_100
169     , p4_a12 JTF_NUMBER_TABLE
170     , p4_a13 JTF_NUMBER_TABLE
171     , p4_a14 JTF_VARCHAR2_TABLE_100
172     , p4_a15 JTF_VARCHAR2_TABLE_100
173     , p4_a16 JTF_VARCHAR2_TABLE_100
174     , p4_a17 JTF_VARCHAR2_TABLE_100
175     , p4_a18 JTF_VARCHAR2_TABLE_200
176     , p4_a19 JTF_VARCHAR2_TABLE_200
177     , p4_a20 JTF_VARCHAR2_TABLE_200
178     , p4_a21 JTF_VARCHAR2_TABLE_200
179     , p4_a22 JTF_VARCHAR2_TABLE_200
180     , p4_a23 JTF_VARCHAR2_TABLE_200
181     , p4_a24 JTF_VARCHAR2_TABLE_200
182     , p4_a25 JTF_VARCHAR2_TABLE_200
183     , p4_a26 JTF_VARCHAR2_TABLE_200
184     , p4_a27 JTF_VARCHAR2_TABLE_200
185     , p4_a28 JTF_VARCHAR2_TABLE_200
186     , p4_a29 JTF_VARCHAR2_TABLE_200
187     , p4_a30 JTF_VARCHAR2_TABLE_200
188     , p4_a31 JTF_VARCHAR2_TABLE_200
189     , p4_a32 JTF_VARCHAR2_TABLE_200
190     , p4_a33 JTF_NUMBER_TABLE
191     , x_return_status out nocopy  VARCHAR2
192     , x_msg_count out nocopy  NUMBER
193     , x_msg_data out nocopy  VARCHAR2
194   );
195 end ozf_process_setup_pvt_w;