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

Source


1 package okl_setup_prd_prctempl_pub_w as
2   /* $Header: OKLUPPES.pls 120.2 2005/10/30 04:49:30 appldev noship $ */
3   procedure insert_prd_price_tmpls(p_api_version  NUMBER
4     , p_init_msg_list  VARCHAR2
5     , x_return_status out nocopy  VARCHAR2
6     , x_msg_count out nocopy  NUMBER
7     , x_msg_data out nocopy  VARCHAR2
8     , p6_a0 out nocopy  NUMBER
9     , p6_a1 out nocopy  NUMBER
10     , p6_a2 out nocopy  NUMBER
11     , p6_a3 out nocopy  VARCHAR2
12     , p6_a4 out nocopy  VARCHAR2
13     , p6_a5 out nocopy  VARCHAR2
14     , p6_a6 out nocopy  DATE
15     , p6_a7 out nocopy  DATE
16     , p6_a8 out nocopy  VARCHAR2
17     , p6_a9 out nocopy  NUMBER
18     , p6_a10 out nocopy  DATE
19     , p6_a11 out nocopy  NUMBER
20     , p6_a12 out nocopy  DATE
21     , p6_a13 out nocopy  NUMBER
22     , p5_a0  NUMBER := 0-1962.0724
23     , p5_a1  NUMBER := 0-1962.0724
24     , p5_a2  NUMBER := 0-1962.0724
25     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
26     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
27     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
28     , p5_a6  DATE := fnd_api.g_miss_date
29     , p5_a7  DATE := fnd_api.g_miss_date
30     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
31     , p5_a9  NUMBER := 0-1962.0724
32     , p5_a10  DATE := fnd_api.g_miss_date
33     , p5_a11  NUMBER := 0-1962.0724
34     , p5_a12  DATE := fnd_api.g_miss_date
35     , p5_a13  NUMBER := 0-1962.0724
36   );
37   procedure update_prd_price_tmpls(p_api_version  NUMBER
38     , p_init_msg_list  VARCHAR2
39     , x_return_status out nocopy  VARCHAR2
40     , x_msg_count out nocopy  NUMBER
41     , x_msg_data out nocopy  VARCHAR2
42     , p6_a0 out nocopy  NUMBER
43     , p6_a1 out nocopy  NUMBER
44     , p6_a2 out nocopy  NUMBER
45     , p6_a3 out nocopy  VARCHAR2
46     , p6_a4 out nocopy  VARCHAR2
47     , p6_a5 out nocopy  VARCHAR2
48     , p6_a6 out nocopy  DATE
49     , p6_a7 out nocopy  DATE
50     , p6_a8 out nocopy  VARCHAR2
51     , p6_a9 out nocopy  NUMBER
52     , p6_a10 out nocopy  DATE
53     , p6_a11 out nocopy  NUMBER
54     , p6_a12 out nocopy  DATE
55     , p6_a13 out nocopy  NUMBER
56     , p5_a0  NUMBER := 0-1962.0724
57     , p5_a1  NUMBER := 0-1962.0724
58     , p5_a2  NUMBER := 0-1962.0724
59     , p5_a3  VARCHAR2 := fnd_api.g_miss_char
60     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
61     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
62     , p5_a6  DATE := fnd_api.g_miss_date
63     , p5_a7  DATE := fnd_api.g_miss_date
64     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
65     , p5_a9  NUMBER := 0-1962.0724
66     , p5_a10  DATE := fnd_api.g_miss_date
67     , p5_a11  NUMBER := 0-1962.0724
68     , p5_a12  DATE := fnd_api.g_miss_date
69     , p5_a13  NUMBER := 0-1962.0724
70   );
71   procedure insert_prd_price_tmpls(p_api_version  NUMBER
72     , p_init_msg_list  VARCHAR2
73     , x_return_status out nocopy  VARCHAR2
74     , x_msg_count out nocopy  NUMBER
75     , x_msg_data out nocopy  VARCHAR2
76     , p5_a0 JTF_NUMBER_TABLE
77     , p5_a1 JTF_NUMBER_TABLE
78     , p5_a2 JTF_NUMBER_TABLE
79     , p5_a3 JTF_VARCHAR2_TABLE_200
80     , p5_a4 JTF_VARCHAR2_TABLE_400
81     , p5_a5 JTF_VARCHAR2_TABLE_100
82     , p5_a6 JTF_DATE_TABLE
83     , p5_a7 JTF_DATE_TABLE
84     , p5_a8 JTF_VARCHAR2_TABLE_2000
85     , p5_a9 JTF_NUMBER_TABLE
86     , p5_a10 JTF_DATE_TABLE
87     , p5_a11 JTF_NUMBER_TABLE
88     , p5_a12 JTF_DATE_TABLE
89     , p5_a13 JTF_NUMBER_TABLE
90     , p6_a0 out nocopy JTF_NUMBER_TABLE
91     , p6_a1 out nocopy JTF_NUMBER_TABLE
92     , p6_a2 out nocopy JTF_NUMBER_TABLE
93     , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
94     , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
95     , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
96     , p6_a6 out nocopy JTF_DATE_TABLE
97     , p6_a7 out nocopy JTF_DATE_TABLE
98     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
99     , p6_a9 out nocopy JTF_NUMBER_TABLE
100     , p6_a10 out nocopy JTF_DATE_TABLE
101     , p6_a11 out nocopy JTF_NUMBER_TABLE
102     , p6_a12 out nocopy JTF_DATE_TABLE
103     , p6_a13 out nocopy JTF_NUMBER_TABLE
104   );
105   procedure update_prd_price_tmpls(p_api_version  NUMBER
106     , p_init_msg_list  VARCHAR2
107     , x_return_status out nocopy  VARCHAR2
108     , x_msg_count out nocopy  NUMBER
109     , x_msg_data out nocopy  VARCHAR2
110     , p5_a0 JTF_NUMBER_TABLE
111     , p5_a1 JTF_NUMBER_TABLE
112     , p5_a2 JTF_NUMBER_TABLE
113     , p5_a3 JTF_VARCHAR2_TABLE_200
114     , p5_a4 JTF_VARCHAR2_TABLE_400
115     , p5_a5 JTF_VARCHAR2_TABLE_100
116     , p5_a6 JTF_DATE_TABLE
117     , p5_a7 JTF_DATE_TABLE
118     , p5_a8 JTF_VARCHAR2_TABLE_2000
119     , p5_a9 JTF_NUMBER_TABLE
120     , p5_a10 JTF_DATE_TABLE
121     , p5_a11 JTF_NUMBER_TABLE
122     , p5_a12 JTF_DATE_TABLE
123     , p5_a13 JTF_NUMBER_TABLE
124     , p6_a0 out nocopy JTF_NUMBER_TABLE
125     , p6_a1 out nocopy JTF_NUMBER_TABLE
126     , p6_a2 out nocopy JTF_NUMBER_TABLE
127     , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
128     , p6_a4 out nocopy JTF_VARCHAR2_TABLE_400
129     , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
130     , p6_a6 out nocopy JTF_DATE_TABLE
131     , p6_a7 out nocopy JTF_DATE_TABLE
132     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
133     , p6_a9 out nocopy JTF_NUMBER_TABLE
134     , p6_a10 out nocopy JTF_DATE_TABLE
135     , p6_a11 out nocopy JTF_NUMBER_TABLE
136     , p6_a12 out nocopy JTF_DATE_TABLE
137     , p6_a13 out nocopy JTF_NUMBER_TABLE
138   );
139   procedure check_product_constraints(p_api_version  NUMBER
140     , p_init_msg_list  VARCHAR2
141     , x_return_status out nocopy  VARCHAR2
142     , x_msg_count out nocopy  NUMBER
143     , x_msg_data out nocopy  VARCHAR2
144     , x_validated out nocopy  VARCHAR2
145     , p5_a0  NUMBER := 0-1962.0724
146     , p5_a1  NUMBER := 0-1962.0724
147     , p5_a2  NUMBER := 0-1962.0724
148     , p5_a3  NUMBER := 0-1962.0724
149     , p5_a4  VARCHAR2 := fnd_api.g_miss_char
150     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
151     , p5_a6  NUMBER := 0-1962.0724
152     , p5_a7  VARCHAR2 := fnd_api.g_miss_char
153     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
154     , p5_a9  DATE := fnd_api.g_miss_date
155     , p5_a10  VARCHAR2 := fnd_api.g_miss_char
156     , p5_a11  DATE := fnd_api.g_miss_date
157     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
158     , p5_a13  VARCHAR2 := fnd_api.g_miss_char
159     , p5_a14  VARCHAR2 := fnd_api.g_miss_char
160     , p5_a15  VARCHAR2 := fnd_api.g_miss_char
161     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
162     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
163     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
164     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
165     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
166     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
167     , p5_a22  VARCHAR2 := fnd_api.g_miss_char
168     , p5_a23  VARCHAR2 := fnd_api.g_miss_char
169     , p5_a24  VARCHAR2 := fnd_api.g_miss_char
170     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
171     , p5_a26  VARCHAR2 := fnd_api.g_miss_char
172     , p5_a27  VARCHAR2 := fnd_api.g_miss_char
173     , p5_a28  NUMBER := 0-1962.0724
174     , p5_a29  DATE := fnd_api.g_miss_date
175     , p5_a30  NUMBER := 0-1962.0724
176     , p5_a31  DATE := fnd_api.g_miss_date
177     , p5_a32  NUMBER := 0-1962.0724
178   );
179   procedure check_product_constraints(p_api_version  NUMBER
180     , p_init_msg_list  VARCHAR2
181     , x_return_status out nocopy  VARCHAR2
182     , x_msg_count out nocopy  NUMBER
183     , x_msg_data out nocopy  VARCHAR2
184     , p5_a0 JTF_NUMBER_TABLE
185     , p5_a1 JTF_NUMBER_TABLE
186     , p5_a2 JTF_NUMBER_TABLE
187     , p5_a3 JTF_NUMBER_TABLE
188     , p5_a4 JTF_VARCHAR2_TABLE_200
189     , p5_a5 JTF_VARCHAR2_TABLE_2000
190     , p5_a6 JTF_NUMBER_TABLE
191     , p5_a7 JTF_VARCHAR2_TABLE_100
192     , p5_a8 JTF_VARCHAR2_TABLE_100
193     , p5_a9 JTF_DATE_TABLE
194     , p5_a10 JTF_VARCHAR2_TABLE_100
195     , p5_a11 JTF_DATE_TABLE
196     , p5_a12 JTF_VARCHAR2_TABLE_100
197     , p5_a13 JTF_VARCHAR2_TABLE_500
198     , p5_a14 JTF_VARCHAR2_TABLE_500
199     , p5_a15 JTF_VARCHAR2_TABLE_500
200     , p5_a16 JTF_VARCHAR2_TABLE_500
201     , p5_a17 JTF_VARCHAR2_TABLE_500
202     , p5_a18 JTF_VARCHAR2_TABLE_500
203     , p5_a19 JTF_VARCHAR2_TABLE_500
204     , p5_a20 JTF_VARCHAR2_TABLE_500
205     , p5_a21 JTF_VARCHAR2_TABLE_500
206     , p5_a22 JTF_VARCHAR2_TABLE_500
207     , p5_a23 JTF_VARCHAR2_TABLE_500
208     , p5_a24 JTF_VARCHAR2_TABLE_500
209     , p5_a25 JTF_VARCHAR2_TABLE_500
210     , p5_a26 JTF_VARCHAR2_TABLE_500
211     , p5_a27 JTF_VARCHAR2_TABLE_500
212     , p5_a28 JTF_NUMBER_TABLE
213     , p5_a29 JTF_DATE_TABLE
214     , p5_a30 JTF_NUMBER_TABLE
215     , p5_a31 JTF_DATE_TABLE
216     , p5_a32 JTF_NUMBER_TABLE
217     , x_validated out nocopy  VARCHAR2
218   );
219 end okl_setup_prd_prctempl_pub_w;