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_PERD_STATUS_PVT_W

Source


1 package okl_perd_status_pvt_w as
2   /* $Header: OKLEPSMS.pls 120.1 2005/07/11 14:19:33 asawanka noship $ */
3   procedure rosetta_table_copy_in_p1(t out nocopy okl_perd_status_pvt.period_tbl_type, a0 JTF_NUMBER_TABLE
4     , a1 JTF_NUMBER_TABLE
5     , a2 JTF_VARCHAR2_TABLE_100
6     , a3 JTF_DATE_TABLE
7     , a4 JTF_NUMBER_TABLE
8     , a5 JTF_VARCHAR2_TABLE_100
9     , a6 JTF_DATE_TABLE
10     , a7 JTF_DATE_TABLE
11     , a8 JTF_VARCHAR2_TABLE_100
12     , a9 JTF_NUMBER_TABLE
13     , a10 JTF_NUMBER_TABLE
14     , a11 JTF_NUMBER_TABLE
15     , a12 JTF_VARCHAR2_TABLE_100
16     , a13 JTF_DATE_TABLE
17     , a14 JTF_NUMBER_TABLE
18     , a15 JTF_NUMBER_TABLE
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_DATE_TABLE
26     , a23 JTF_DATE_TABLE
27     , a24 JTF_NUMBER_TABLE
28     , a25 JTF_VARCHAR2_TABLE_100
29     );
30   procedure rosetta_table_copy_out_p1(t okl_perd_status_pvt.period_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31     , a1 out nocopy JTF_NUMBER_TABLE
32     , a2 out nocopy JTF_VARCHAR2_TABLE_100
33     , a3 out nocopy JTF_DATE_TABLE
34     , a4 out nocopy JTF_NUMBER_TABLE
35     , a5 out nocopy JTF_VARCHAR2_TABLE_100
36     , a6 out nocopy JTF_DATE_TABLE
37     , a7 out nocopy JTF_DATE_TABLE
38     , a8 out nocopy JTF_VARCHAR2_TABLE_100
39     , a9 out nocopy JTF_NUMBER_TABLE
40     , a10 out nocopy JTF_NUMBER_TABLE
41     , a11 out nocopy JTF_NUMBER_TABLE
42     , a12 out nocopy JTF_VARCHAR2_TABLE_100
43     , a13 out nocopy JTF_DATE_TABLE
44     , a14 out nocopy JTF_NUMBER_TABLE
45     , a15 out nocopy JTF_NUMBER_TABLE
46     , a16 out nocopy JTF_VARCHAR2_TABLE_200
47     , a17 out nocopy JTF_VARCHAR2_TABLE_200
48     , a18 out nocopy JTF_VARCHAR2_TABLE_200
49     , a19 out nocopy JTF_VARCHAR2_TABLE_200
50     , a20 out nocopy JTF_VARCHAR2_TABLE_200
51     , a21 out nocopy JTF_VARCHAR2_TABLE_200
52     , a22 out nocopy JTF_DATE_TABLE
53     , a23 out nocopy JTF_DATE_TABLE
54     , a24 out nocopy JTF_NUMBER_TABLE
55     , a25 out nocopy JTF_VARCHAR2_TABLE_100
56     );
57 
58   procedure search_period_status(p_api_version  NUMBER
59     , p_init_msg_list  VARCHAR2
60     , x_return_status out nocopy  VARCHAR2
61     , x_msg_count out nocopy  NUMBER
62     , x_msg_data out nocopy  VARCHAR2
63     , p6_a0 out nocopy JTF_NUMBER_TABLE
64     , p6_a1 out nocopy JTF_NUMBER_TABLE
65     , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
66     , p6_a3 out nocopy JTF_DATE_TABLE
67     , p6_a4 out nocopy JTF_NUMBER_TABLE
68     , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
69     , p6_a6 out nocopy JTF_DATE_TABLE
70     , p6_a7 out nocopy JTF_DATE_TABLE
71     , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
72     , p6_a9 out nocopy JTF_NUMBER_TABLE
73     , p6_a10 out nocopy JTF_NUMBER_TABLE
74     , p6_a11 out nocopy JTF_NUMBER_TABLE
75     , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
76     , p6_a13 out nocopy JTF_DATE_TABLE
77     , p6_a14 out nocopy JTF_NUMBER_TABLE
78     , p6_a15 out nocopy JTF_NUMBER_TABLE
79     , p6_a16 out nocopy JTF_VARCHAR2_TABLE_200
80     , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
81     , p6_a18 out nocopy JTF_VARCHAR2_TABLE_200
82     , p6_a19 out nocopy JTF_VARCHAR2_TABLE_200
83     , p6_a20 out nocopy JTF_VARCHAR2_TABLE_200
84     , p6_a21 out nocopy JTF_VARCHAR2_TABLE_200
85     , p6_a22 out nocopy JTF_DATE_TABLE
86     , p6_a23 out nocopy JTF_DATE_TABLE
87     , p6_a24 out nocopy JTF_NUMBER_TABLE
88     , p6_a25 out nocopy JTF_VARCHAR2_TABLE_100
89     , p5_a0  NUMBER := 0-1962.0724
90     , p5_a1  NUMBER := 0-1962.0724
91     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
92     , p5_a3  DATE := fnd_api.g_miss_date
93     , p5_a4  NUMBER := 0-1962.0724
94     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
95     , p5_a6  DATE := fnd_api.g_miss_date
96     , p5_a7  DATE := fnd_api.g_miss_date
97     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
98     , p5_a9  NUMBER := 0-1962.0724
99     , p5_a10  NUMBER := 0-1962.0724
100     , p5_a11  NUMBER := 0-1962.0724
101     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
102     , p5_a13  DATE := fnd_api.g_miss_date
103     , p5_a14  NUMBER := 0-1962.0724
104     , p5_a15  NUMBER := 0-1962.0724
105     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
106     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
107     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
108     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
109     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
110     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
111     , p5_a22  DATE := fnd_api.g_miss_date
112     , p5_a23  DATE := fnd_api.g_miss_date
113     , p5_a24  NUMBER := 0-1962.0724
114     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
115   );
116   procedure update_period_status(p_api_version  NUMBER
117     , p_init_msg_list  VARCHAR2
118     , x_return_status out nocopy  VARCHAR2
119     , x_msg_count out nocopy  NUMBER
120     , x_msg_data out nocopy  VARCHAR2
121     , p5_a0 JTF_NUMBER_TABLE
122     , p5_a1 JTF_NUMBER_TABLE
123     , p5_a2 JTF_VARCHAR2_TABLE_100
124     , p5_a3 JTF_DATE_TABLE
125     , p5_a4 JTF_NUMBER_TABLE
126     , p5_a5 JTF_VARCHAR2_TABLE_100
127     , p5_a6 JTF_DATE_TABLE
128     , p5_a7 JTF_DATE_TABLE
129     , p5_a8 JTF_VARCHAR2_TABLE_100
130     , p5_a9 JTF_NUMBER_TABLE
131     , p5_a10 JTF_NUMBER_TABLE
132     , p5_a11 JTF_NUMBER_TABLE
133     , p5_a12 JTF_VARCHAR2_TABLE_100
134     , p5_a13 JTF_DATE_TABLE
135     , p5_a14 JTF_NUMBER_TABLE
136     , p5_a15 JTF_NUMBER_TABLE
137     , p5_a16 JTF_VARCHAR2_TABLE_200
138     , p5_a17 JTF_VARCHAR2_TABLE_200
139     , p5_a18 JTF_VARCHAR2_TABLE_200
140     , p5_a19 JTF_VARCHAR2_TABLE_200
141     , p5_a20 JTF_VARCHAR2_TABLE_200
142     , p5_a21 JTF_VARCHAR2_TABLE_200
143     , p5_a22 JTF_DATE_TABLE
144     , p5_a23 JTF_DATE_TABLE
145     , p5_a24 JTF_NUMBER_TABLE
146     , p5_a25 JTF_VARCHAR2_TABLE_100
147   );
148   procedure update_perd_row(p_api_version  NUMBER
149     , p_init_msg_list  VARCHAR2
150     , x_return_status out nocopy  VARCHAR2
151     , x_msg_count out nocopy  NUMBER
152     , x_msg_data out nocopy  VARCHAR2
153     , p5_a0  NUMBER := 0-1962.0724
154     , p5_a1  NUMBER := 0-1962.0724
155     , p5_a2  VARCHAR2 := fnd_api.g_miss_char
156     , p5_a3  DATE := fnd_api.g_miss_date
157     , p5_a4  NUMBER := 0-1962.0724
158     , p5_a5  VARCHAR2 := fnd_api.g_miss_char
159     , p5_a6  DATE := fnd_api.g_miss_date
160     , p5_a7  DATE := fnd_api.g_miss_date
161     , p5_a8  VARCHAR2 := fnd_api.g_miss_char
162     , p5_a9  NUMBER := 0-1962.0724
163     , p5_a10  NUMBER := 0-1962.0724
164     , p5_a11  NUMBER := 0-1962.0724
165     , p5_a12  VARCHAR2 := fnd_api.g_miss_char
166     , p5_a13  DATE := fnd_api.g_miss_date
167     , p5_a14  NUMBER := 0-1962.0724
168     , p5_a15  NUMBER := 0-1962.0724
169     , p5_a16  VARCHAR2 := fnd_api.g_miss_char
170     , p5_a17  VARCHAR2 := fnd_api.g_miss_char
171     , p5_a18  VARCHAR2 := fnd_api.g_miss_char
172     , p5_a19  VARCHAR2 := fnd_api.g_miss_char
173     , p5_a20  VARCHAR2 := fnd_api.g_miss_char
174     , p5_a21  VARCHAR2 := fnd_api.g_miss_char
175     , p5_a22  DATE := fnd_api.g_miss_date
176     , p5_a23  DATE := fnd_api.g_miss_date
177     , p5_a24  NUMBER := 0-1962.0724
178     , p5_a25  VARCHAR2 := fnd_api.g_miss_char
179   );
180 end okl_perd_status_pvt_w;