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.JTF_DPF_W

Source


1 package jtf_dpf_w AUTHID CURRENT_USER as
2   /* $Header: jtfdpws.pls 120.2 2005/10/25 05:19:31 psanyal ship $ */
3   procedure rosetta_table_copy_in_p9(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.new_rule_param_tbl, a0 JTF_VARCHAR2_TABLE_100
4     , a1 JTF_VARCHAR2_TABLE_100
5     , a2 JTF_VARCHAR2_TABLE_100
6     );
7   procedure rosetta_table_copy_out_p9(t jtf_dpf.new_rule_param_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
8     , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
9     , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
10     );
11 
12   procedure rosetta_table_copy_in_p11(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.new_phys_non_def_tbl, a0 JTF_NUMBER_TABLE
13     , a1 JTF_NUMBER_TABLE
14     );
15   procedure rosetta_table_copy_out_p11(t jtf_dpf.new_phys_non_def_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
16     , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
17     );
18 
19   procedure rosetta_table_copy_in_p13(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.new_next_log_non_def_tbl, a0 JTF_NUMBER_TABLE
20     , a1 JTF_NUMBER_TABLE
21     );
22   procedure rosetta_table_copy_out_p13(t jtf_dpf.new_next_log_non_def_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
23     , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
24     );
25 
26   procedure rosetta_table_copy_in_p15(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.new_phys_attribs_tbl, a0 JTF_VARCHAR2_TABLE_100
27     , a1 JTF_VARCHAR2_TABLE_300
28     );
29   procedure rosetta_table_copy_out_p15(t jtf_dpf.new_phys_attribs_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
30     , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
31     );
32 
33   procedure rosetta_table_copy_in_p16(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.dpf_tbl, a0 JTF_NUMBER_TABLE
34     , a1 JTF_VARCHAR2_TABLE_100
35     , a2 JTF_VARCHAR2_TABLE_100
36     , a3 JTF_VARCHAR2_TABLE_100
37     , a4 JTF_VARCHAR2_TABLE_100
38     , a5 JTF_VARCHAR2_TABLE_100
39     , a6 JTF_VARCHAR2_TABLE_200
40     , a7 JTF_VARCHAR2_TABLE_100
41     , a8 JTF_VARCHAR2_TABLE_100
42     , a9 JTF_VARCHAR2_TABLE_100
43     , a10 JTF_VARCHAR2_TABLE_100
44     , a11 JTF_VARCHAR2_TABLE_100
45     );
46   procedure rosetta_table_copy_out_p16(t jtf_dpf.dpf_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
47     , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
48     , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
49     , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
50     , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
51     , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
52     , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
53     , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
54     , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
55     , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
56     , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
57     , a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
58     );
59 
60   procedure rosetta_table_copy_in_p17(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.logical_tbl, a0 JTF_NUMBER_TABLE
61     , a1 JTF_VARCHAR2_TABLE_100
62     , a2 JTF_VARCHAR2_TABLE_100
63     , a3 JTF_VARCHAR2_TABLE_100
64     , a4 JTF_VARCHAR2_TABLE_200
65     , a5 JTF_VARCHAR2_TABLE_300
66     , a6 JTF_VARCHAR2_TABLE_100
67     , a7 JTF_NUMBER_TABLE
68     , a8 JTF_VARCHAR2_TABLE_100
69     );
70   procedure rosetta_table_copy_out_p17(t jtf_dpf.logical_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
71     , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
72     , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
73     , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
74     , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
75     , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
76     , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
77     , a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
78     , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
79     );
80 
81   procedure rosetta_table_copy_in_p18(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.physical_tbl, a0 JTF_NUMBER_TABLE
82     , a1 JTF_VARCHAR2_TABLE_100
83     , a2 JTF_VARCHAR2_TABLE_100
84     );
85   procedure rosetta_table_copy_out_p18(t jtf_dpf.physical_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
86     , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
87     , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
88     );
89 
90   procedure rosetta_table_copy_in_p19(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.physical_non_default_tbl, a0 JTF_VARCHAR2_TABLE_100
91     , a1 JTF_NUMBER_TABLE
92     , a2 JTF_VARCHAR2_TABLE_100
93     , a3 JTF_VARCHAR2_TABLE_100
94     , a4 JTF_VARCHAR2_TABLE_100
95     , a5 JTF_NUMBER_TABLE
96     , a6 JTF_VARCHAR2_TABLE_100
97     );
98   procedure rosetta_table_copy_out_p19(t jtf_dpf.physical_non_default_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
99     , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
100     , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
101     , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
102     , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
103     , a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
104     , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
105     );
106 
107   procedure rosetta_table_copy_in_p20(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.rule_tbl, a0 JTF_NUMBER_TABLE
108     , a1 JTF_VARCHAR2_TABLE_100
109     , a2 JTF_VARCHAR2_TABLE_100
110     , a3 JTF_VARCHAR2_TABLE_100
111     , a4 JTF_VARCHAR2_TABLE_100
112     , a5 JTF_VARCHAR2_TABLE_100
113     );
114   procedure rosetta_table_copy_out_p20(t jtf_dpf.rule_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
115     , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
116     , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
117     , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
118     , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
119     , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
120     );
121 
122   procedure rosetta_table_copy_in_p21(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.next_logical_default_tbl, a0 JTF_VARCHAR2_TABLE_100
123     , a1 JTF_NUMBER_TABLE
124     , a2 JTF_VARCHAR2_TABLE_100
125     , a3 JTF_VARCHAR2_TABLE_100
126     , a4 JTF_VARCHAR2_TABLE_100
127     , a5 JTF_VARCHAR2_TABLE_100
128     );
129   procedure rosetta_table_copy_out_p21(t jtf_dpf.next_logical_default_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
130     , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
131     , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
132     , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
133     , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
134     , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
135     );
136 
137   procedure rosetta_table_copy_in_p22(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.next_logical_non_default_tbl, a0 JTF_VARCHAR2_TABLE_100
138     , a1 JTF_NUMBER_TABLE
139     , a2 JTF_VARCHAR2_TABLE_100
140     , a3 JTF_VARCHAR2_TABLE_100
141     , a4 JTF_VARCHAR2_TABLE_100
142     , a5 JTF_VARCHAR2_TABLE_100
143     , a6 JTF_VARCHAR2_TABLE_100
144     , a7 JTF_VARCHAR2_TABLE_100
145     );
146   procedure rosetta_table_copy_out_p22(t jtf_dpf.next_logical_non_default_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
147     , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
148     , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
149     , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
150     , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
151     , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
152     , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
153     , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
154     );
155 
156   procedure rosetta_table_copy_in_p23(t OUT NOCOPY /* file.sql.39 change */ jtf_dpf.physical_attribs_tbl, a0 JTF_NUMBER_TABLE
157     , a1 JTF_VARCHAR2_TABLE_100
158     , a2 JTF_VARCHAR2_TABLE_300
159     );
160   procedure rosetta_table_copy_out_p23(t jtf_dpf.physical_attribs_tbl, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
161     , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
162     , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
163     );
164 
165   procedure get(asn  VARCHAR2
166     , p_lang IN OUT NOCOPY /* file.sql.39 change */  VARCHAR2
167     , descrs_only  number
168     , p3_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
169     , p3_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
170     , p3_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
171     , p3_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
172     , p3_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
173     , p3_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
174     , p3_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
175     , p3_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
176     , p3_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
177     , p3_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
178     , p3_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
179     , p3_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
180     , p4_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
181     , p4_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
182     , p4_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
183     , p4_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
184     , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
185     , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
186     , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
187     , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
188     , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
189     , p5_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
190     , p5_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
191     , p5_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
192     , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
193     , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
194     , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
195     , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
196     , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
197     , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
198     , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
199     , p7_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
200     , p7_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
201     , p7_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
202     , p7_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
203     , p7_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
204     , p7_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
205     , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
206     , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
207     , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
208     , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
209     , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
210     , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
211     , p9_a0 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
212     , p9_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
213     , p9_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
214     , p9_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
215     , p9_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
216     , p9_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
217     , p9_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
218     , p9_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
219     , p10_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
220     , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
221     , p10_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
222   );
223   function rule_update(p_rule_id  NUMBER
224     , p1_a0  VARCHAR2 := fnd_api.g_miss_char
225     , p1_a1  VARCHAR2 := fnd_api.g_miss_char
226     , p1_a2  VARCHAR2 := fnd_api.g_miss_char
227   ) return number;
228   function rule_new(p_asn  VARCHAR2
229     , p_name  VARCHAR2
230     , p_descr  VARCHAR2
231     , p3_a0 JTF_VARCHAR2_TABLE_100
232     , p3_a1 JTF_VARCHAR2_TABLE_100
233     , p3_a2 JTF_VARCHAR2_TABLE_100
234   ) return number;
235   procedure rule_set_params(p_rule_id  NUMBER
236     , p1_a0 JTF_VARCHAR2_TABLE_100
237     , p1_a1 JTF_VARCHAR2_TABLE_100
238     , p1_a2 JTF_VARCHAR2_TABLE_100
239   );
240   function phys_update(p_ppid  NUMBER
241     , p1_a0  VARCHAR2 := fnd_api.g_miss_char
242     , p1_a1  VARCHAR2 := fnd_api.g_miss_char
243     , p1_a2  VARCHAR2 := fnd_api.g_miss_char
244   ) return number;
245   procedure phys_attribs_update(p_ppid  NUMBER
246     , p1_a0 JTF_VARCHAR2_TABLE_100
247     , p1_a1 JTF_VARCHAR2_TABLE_300
248   );
249   function flow_update(p_logical_flow_id  NUMBER
250     , p1_a0  VARCHAR2 := fnd_api.g_miss_char
251     , p1_a1  VARCHAR2 := fnd_api.g_miss_char
252     , p1_a2  VARCHAR2 := fnd_api.g_miss_char
253     , p1_a3  VARCHAR2 := fnd_api.g_miss_char
254     , p1_a4  VARCHAR2 := fnd_api.g_miss_char
255     , p1_a5  VARCHAR2 := fnd_api.g_miss_char
256     , p1_a6  NUMBER := 0-1962.0724
257     , p1_a7  NUMBER := 0-1962.0724
258   ) return number;
259   function logical_update(p_logical_page_id  NUMBER
260     , p1_a0  VARCHAR2 := fnd_api.g_miss_char
261     , p1_a1  VARCHAR2 := fnd_api.g_miss_char
262     , p1_a2  VARCHAR2 := fnd_api.g_miss_char
263     , p1_a3  VARCHAR2 := fnd_api.g_miss_char
264     , p1_a4  VARCHAR2 := fnd_api.g_miss_char
265     , p1_a5  VARCHAR2 := fnd_api.g_miss_char
266     , p1_a6  NUMBER := 0-1962.0724
267   ) return number;
268   procedure logical_set_non_default_phys(p_logical_page_id  NUMBER
269     , p1_a0 JTF_NUMBER_TABLE
270     , p1_a1 JTF_NUMBER_TABLE
271   );
272   procedure next_logical_set_non_default(p_flow_id  NUMBER
273     , p_log_page_id  NUMBER
274     , p2_a0 JTF_NUMBER_TABLE
275     , p2_a1 JTF_NUMBER_TABLE
276   );
277 end jtf_dpf_w;