DBA Data[Home] [Help]

PACKAGE: APPS.OKL_POOLCONC_PVT_W

Source


1 package okl_poolconc_pvt_w AUTHID CURRENT_USER as
2   /* $Header: OKLESZCS.pls 120.2 2007/12/18 06:50:48 ssdeshpa ship $ */
3   procedure rosetta_table_copy_in_p74(t out nocopy okl_poolconc_pvt.error_message_type, a0 JTF_VARCHAR2_TABLE_2000);
4   procedure rosetta_table_copy_out_p74(t okl_poolconc_pvt.error_message_type, a0 out nocopy JTF_VARCHAR2_TABLE_2000);
5 
6   procedure add_pool_contents_ui(p_api_version  NUMBER
7     , p_init_msg_list  VARCHAR2
8     , x_return_status out nocopy  VARCHAR2
9     , x_msg_count out nocopy  NUMBER
10     , x_msg_data out nocopy  VARCHAR2
11     , x_request_id out nocopy  NUMBER
12     , p_sty_id1  NUMBER
13     , p_sty_id2  NUMBER
14     , p_stream_type_subclass  VARCHAR2
15     , p_multi_org  VARCHAR2
16     , p6_a0  NUMBER := 0-1962.0724
17     , p6_a1  VARCHAR2 := fnd_api.g_miss_char
18     , p6_a2  VARCHAR2 := fnd_api.g_miss_char
19     , p6_a3  NUMBER := 0-1962.0724
20     , p6_a4  VARCHAR2 := fnd_api.g_miss_char
21     , p6_a5  NUMBER := 0-1962.0724
22     , p6_a6  NUMBER := 0-1962.0724
23     , p6_a7  VARCHAR2 := fnd_api.g_miss_char
24     , p6_a8  NUMBER := 0-1962.0724
25     , p6_a9  DATE := fnd_api.g_miss_date
26     , p6_a10  DATE := fnd_api.g_miss_date
27     , p6_a11  DATE := fnd_api.g_miss_date
28     , p6_a12  DATE := fnd_api.g_miss_date
29     , p6_a13  NUMBER := 0-1962.0724
30     , p6_a14  VARCHAR2 := fnd_api.g_miss_char
31     , p6_a15  VARCHAR2 := fnd_api.g_miss_char
32     , p6_a16  NUMBER := 0-1962.0724
33     , p6_a17  NUMBER := 0-1962.0724
34     , p6_a18  VARCHAR2 := fnd_api.g_miss_char
35     , p6_a19  VARCHAR2 := fnd_api.g_miss_char
36     , p6_a20  VARCHAR2 := fnd_api.g_miss_char
37     , p6_a21  NUMBER := 0-1962.0724
38     , p6_a22  NUMBER := 0-1962.0724
39     , p6_a23  NUMBER := 0-1962.0724
40     , p6_a24  NUMBER := 0-1962.0724
41     , p6_a25  NUMBER := 0-1962.0724
42     , p6_a26  NUMBER := 0-1962.0724
43     , p6_a27  NUMBER := 0-1962.0724
44     , p6_a28  VARCHAR2 := fnd_api.g_miss_char
45     , p6_a29  VARCHAR2 := fnd_api.g_miss_char
46     , p6_a30  VARCHAR2 := fnd_api.g_miss_char
47     , p6_a31  VARCHAR2 := fnd_api.g_miss_char
48     , p6_a32  DATE := fnd_api.g_miss_date
49     , p6_a33  DATE := fnd_api.g_miss_date
50     , p6_a34  NUMBER := 0-1962.0724
51     , p6_a35  NUMBER := 0-1962.0724
52     , p6_a36  DATE := fnd_api.g_miss_date
53     , p6_a37  DATE := fnd_api.g_miss_date
54     , p6_a38  VARCHAR2 := fnd_api.g_miss_char
55     , p6_a39  VARCHAR2 := fnd_api.g_miss_char
56   );
57   procedure cleanup_pool_contents_ui(p_api_version  NUMBER
58     , p_init_msg_list  VARCHAR2
59     , x_return_status out nocopy  VARCHAR2
60     , x_msg_count out nocopy  NUMBER
61     , x_msg_data out nocopy  VARCHAR2
62     , x_request_id out nocopy  NUMBER
63     , p_stream_type_subclass  VARCHAR2
64     , p_multi_org  VARCHAR2
65     , p_action_code  VARCHAR2
66     , p6_a0  NUMBER := 0-1962.0724
67     , p6_a1  VARCHAR2 := fnd_api.g_miss_char
68     , p6_a2  VARCHAR2 := fnd_api.g_miss_char
69     , p6_a3  NUMBER := 0-1962.0724
70     , p6_a4  VARCHAR2 := fnd_api.g_miss_char
71     , p6_a5  NUMBER := 0-1962.0724
72     , p6_a6  NUMBER := 0-1962.0724
73     , p6_a7  VARCHAR2 := fnd_api.g_miss_char
74     , p6_a8  NUMBER := 0-1962.0724
75     , p6_a9  DATE := fnd_api.g_miss_date
76     , p6_a10  DATE := fnd_api.g_miss_date
77     , p6_a11  DATE := fnd_api.g_miss_date
78     , p6_a12  DATE := fnd_api.g_miss_date
79     , p6_a13  NUMBER := 0-1962.0724
80     , p6_a14  VARCHAR2 := fnd_api.g_miss_char
81     , p6_a15  VARCHAR2 := fnd_api.g_miss_char
82     , p6_a16  NUMBER := 0-1962.0724
83     , p6_a17  NUMBER := 0-1962.0724
84     , p6_a18  VARCHAR2 := fnd_api.g_miss_char
85     , p6_a19  VARCHAR2 := fnd_api.g_miss_char
86     , p6_a20  VARCHAR2 := fnd_api.g_miss_char
87     , p6_a21  NUMBER := 0-1962.0724
88     , p6_a22  NUMBER := 0-1962.0724
89     , p6_a23  NUMBER := 0-1962.0724
90     , p6_a24  NUMBER := 0-1962.0724
91     , p6_a25  NUMBER := 0-1962.0724
92     , p6_a26  NUMBER := 0-1962.0724
93     , p6_a27  NUMBER := 0-1962.0724
94     , p6_a28  VARCHAR2 := fnd_api.g_miss_char
95     , p6_a29  VARCHAR2 := fnd_api.g_miss_char
96     , p6_a30  VARCHAR2 := fnd_api.g_miss_char
97     , p6_a31  VARCHAR2 := fnd_api.g_miss_char
98     , p6_a32  DATE := fnd_api.g_miss_date
99     , p6_a33  DATE := fnd_api.g_miss_date
100     , p6_a34  NUMBER := 0-1962.0724
101     , p6_a35  NUMBER := 0-1962.0724
102     , p6_a36  DATE := fnd_api.g_miss_date
103     , p6_a37  DATE := fnd_api.g_miss_date
104     , p6_a38  VARCHAR2 := fnd_api.g_miss_char
105     , p6_a39  VARCHAR2 := fnd_api.g_miss_char
106   );
107 end okl_poolconc_pvt_w;