PACKAGE: APPS.CSP_PART_SEARCH_PVT_W

Source

1 package csp_part_search_pvt_w AUTHID CURRENT_USER as
2   /* $Header: cspvsrcws.pls 120.0.12010000.2 2009/08/20 12:12:21 htank noship $ */
3   procedure rosetta_table_copy_in_p2(t out nocopy csp_part_search_pvt.required_parts_tbl, a0 JTF_NUMBER_TABLE
4     , a1 JTF_VARCHAR2_TABLE_100
5     , a2 JTF_NUMBER_TABLE
6     );
7   procedure rosetta_table_copy_out_p2(t csp_part_search_pvt.required_parts_tbl, a0 out nocopy JTF_NUMBER_TABLE
8     , a1 out nocopy JTF_VARCHAR2_TABLE_100
9     , a2 out nocopy JTF_NUMBER_TABLE
10     );
11 
12   procedure search(p0_a0 JTF_NUMBER_TABLE
13     , p0_a1 JTF_VARCHAR2_TABLE_100
14     , p0_a2 JTF_NUMBER_TABLE
15     , p1_a0  VARCHAR2
16     , p1_a1  NUMBER
17     , p1_a2  NUMBER
18     , p1_a3  NUMBER
19     , p1_a4  NUMBER
20     , p1_a5  NUMBER
21     , p1_a6  NUMBER
22     , p1_a7  VARCHAR2
23     , p1_a8  NUMBER
24     , p1_a9  DATE
25     , p1_a10  VARCHAR2
26     , p1_a11  NUMBER
27     , p1_a12  NUMBER
28     , p1_a13  VARCHAR2
29     , p1_a14  NUMBER
30     , p1_a15  VARCHAR2
31     , p1_a16  NUMBER
32     , p1_a17  NUMBER
33     , p1_a18  NUMBER
34     , p1_a19  NUMBER
35     , x_return_status out nocopy  VARCHAR2
36     , x_msg_data out nocopy  VARCHAR2
37     , x_msg_count out nocopy  VARCHAR2
38   );
39 end csp_part_search_pvt_w;