1 package csp_excess_parts_pvt_w AUTHID CURRENT_USER as
2 /* $Header: cspvpexws.pls 120.1 2011/04/09 18:14:18 htank noship $ */
3 procedure populate_excess_list(p0_a0 in out nocopy NUMBER
4 , p0_a1 in out nocopy NUMBER
5 , p0_a2 in out nocopy NUMBER
6 , p0_a3 in out nocopy NUMBER
7 , p0_a4 in out nocopy VARCHAR2
8 , p0_a5 in out nocopy NUMBER
9 , p0_a6 in out nocopy DATE
10 , p0_a7 in out nocopy NUMBER
11 , p0_a8 in out nocopy DATE
12 , p0_a9 in out nocopy NUMBER
13 , p0_a10 in out nocopy VARCHAR2
14 , p0_a11 in out nocopy NUMBER
15 , p0_a12 in out nocopy NUMBER
16 , p0_a13 in out nocopy NUMBER
17 , p0_a14 in out nocopy VARCHAR2
18 , p0_a15 in out nocopy VARCHAR2
19 , p0_a16 in out nocopy VARCHAR2
20 , p0_a17 in out nocopy VARCHAR2
21 , p0_a18 in out nocopy VARCHAR2
22 , p0_a19 in out nocopy VARCHAR2
23 , p0_a20 in out nocopy VARCHAR2
24 , p0_a21 in out nocopy VARCHAR2
25 , p0_a22 in out nocopy VARCHAR2
26 , p0_a23 in out nocopy VARCHAR2
27 , p0_a24 in out nocopy VARCHAR2
28 , p0_a25 in out nocopy VARCHAR2
29 , p0_a26 in out nocopy VARCHAR2
30 , p0_a27 in out nocopy VARCHAR2
31 , p0_a28 in out nocopy VARCHAR2
32 , p0_a29 in out nocopy VARCHAR2
33 , p0_a30 in out nocopy VARCHAR2
34 , p0_a31 in out nocopy NUMBER
35 , p0_a32 in out nocopy VARCHAR2
36 , p0_a33 in out nocopy NUMBER
37 , p0_a34 in out nocopy VARCHAR2
38 , p_is_insert_record VARCHAR2
39 );
40 end csp_excess_parts_pvt_w;