DBA Data[Home] [Help]

PACKAGE: APPS.LNS_PARTICIPANTS_PUB_W

Source


1 package lns_participants_pub_w AUTHID CURRENT_USER as
2   /* $Header: LNS_PART_PUBJ_S.pls 120.6 2011/08/22 10:32:28 gparuchu ship $ */
3   procedure validateparticipant(p0_a0  NUMBER
4     , p0_a1  NUMBER
5     , p0_a2  NUMBER
6     , p0_a3  VARCHAR2
7     , p0_a4  DATE
8     , p0_a5  DATE
9     , p0_a6  NUMBER
10     , p0_a7  NUMBER
11     , p0_a8  NUMBER
12     , p0_a9  VARCHAR2
13     , p0_a10  VARCHAR2
14     , p0_a11  VARCHAR2
15     , p0_a12  VARCHAR2
16     , p0_a13  VARCHAR2
17     , p0_a14  VARCHAR2
18     , p0_a15  VARCHAR2
19     , p0_a16  VARCHAR2
20     , p0_a17  VARCHAR2
21     , p0_a18  VARCHAR2
22     , p0_a19  VARCHAR2
23     , p0_a20  VARCHAR2
24     , p0_a21  VARCHAR2
25     , p0_a22  VARCHAR2
26     , p0_a23  VARCHAR2
27     , p0_a24  VARCHAR2
28     , p0_a25  VARCHAR2
29     , p0_a26  VARCHAR2
30     , p0_a27  VARCHAR2
31     , p0_a28  VARCHAR2
32     , p0_a29  VARCHAR2
33     , p0_a30  NUMBER
34     , p0_a31  NUMBER
35     , p0_a32  NUMBER
36     , p0_a33  NUMBER
37     , p0_a34  VARCHAR2
38     , p0_a35  VARCHAR2
39     , p0_a36  VARCHAR2
40     , p_mode  VARCHAR2
41     , x_return_status out nocopy  VARCHAR2
42     , x_msg_count out nocopy  NUMBER
43     , x_msg_data out nocopy  VARCHAR2
44   );
45   procedure createparticipant(p_init_msg_list  VARCHAR2
46     , p_validation_level  NUMBER
47     , p2_a0  NUMBER
48     , p2_a1  NUMBER
49     , p2_a2  NUMBER
50     , p2_a3  VARCHAR2
51     , p2_a4  DATE
52     , p2_a5  DATE
53     , p2_a6  NUMBER
54     , p2_a7  NUMBER
55     , p2_a8  NUMBER
56     , p2_a9  VARCHAR2
57     , p2_a10  VARCHAR2
58     , p2_a11  VARCHAR2
59     , p2_a12  VARCHAR2
60     , p2_a13  VARCHAR2
61     , p2_a14  VARCHAR2
62     , p2_a15  VARCHAR2
63     , p2_a16  VARCHAR2
64     , p2_a17  VARCHAR2
65     , p2_a18  VARCHAR2
66     , p2_a19  VARCHAR2
67     , p2_a20  VARCHAR2
68     , p2_a21  VARCHAR2
69     , p2_a22  VARCHAR2
70     , p2_a23  VARCHAR2
71     , p2_a24  VARCHAR2
72     , p2_a25  VARCHAR2
73     , p2_a26  VARCHAR2
74     , p2_a27  VARCHAR2
75     , p2_a28  VARCHAR2
76     , p2_a29  VARCHAR2
77     , p2_a30  NUMBER
78     , p2_a31  NUMBER
79     , p2_a32  NUMBER
80     , p2_a33  NUMBER
81     , p2_a34  VARCHAR2
82     , p2_a35  VARCHAR2
83     , p2_a36  VARCHAR2
84     , x_participant_id out nocopy  NUMBER
85     , x_return_status out nocopy  VARCHAR2
86     , x_msg_count out nocopy  NUMBER
87     , x_msg_data out nocopy  VARCHAR2
88   );
89   procedure updateparticipant(p_init_msg_list  VARCHAR2
90     , p_validation_level  NUMBER
91     , p2_a0  NUMBER
92     , p2_a1  NUMBER
93     , p2_a2  NUMBER
94     , p2_a3  VARCHAR2
95     , p2_a4  DATE
96     , p2_a5  DATE
97     , p2_a6  NUMBER
98     , p2_a7  NUMBER
99     , p2_a8  NUMBER
100     , p2_a9  VARCHAR2
101     , p2_a10  VARCHAR2
102     , p2_a11  VARCHAR2
103     , p2_a12  VARCHAR2
104     , p2_a13  VARCHAR2
105     , p2_a14  VARCHAR2
106     , p2_a15  VARCHAR2
107     , p2_a16  VARCHAR2
108     , p2_a17  VARCHAR2
109     , p2_a18  VARCHAR2
110     , p2_a19  VARCHAR2
111     , p2_a20  VARCHAR2
112     , p2_a21  VARCHAR2
113     , p2_a22  VARCHAR2
114     , p2_a23  VARCHAR2
115     , p2_a24  VARCHAR2
116     , p2_a25  VARCHAR2
117     , p2_a26  VARCHAR2
118     , p2_a27  VARCHAR2
119     , p2_a28  VARCHAR2
120     , p2_a29  VARCHAR2
121     , p2_a30  NUMBER
122     , p2_a31  NUMBER
123     , p2_a32  NUMBER
124     , p2_a33  NUMBER
125     , p2_a34  VARCHAR2
126     , p2_a35  VARCHAR2
127     , p2_a36  VARCHAR2
128     , x_object_version_number in out nocopy  NUMBER
129     , x_return_status out nocopy  VARCHAR2
130     , x_msg_count out nocopy  NUMBER
131     , x_msg_data out nocopy  VARCHAR2
132   );
133 end lns_participants_pub_w;