[Home] [Help]
PACKAGE: APPS.CSP_REQ_LINE_DETAILS_PVT_W
Source
1 package csp_req_line_details_pvt_w AUTHID CURRENT_USER as
2 /* $Header: csprqldpvtws.pls 120.1 2010/12/07 06:21:13 hhaugeru noship $ */
3 procedure rosetta_table_copy_in_p3(t out nocopy csp_req_line_details_pvt.req_line_details_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_DATE_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_DATE_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_VARCHAR2_TABLE_100
11 , a8 JTF_NUMBER_TABLE
12 );
13 procedure rosetta_table_copy_out_p3(t csp_req_line_details_pvt.req_line_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14 , a1 out nocopy JTF_NUMBER_TABLE
15 , a2 out nocopy JTF_NUMBER_TABLE
16 , a3 out nocopy JTF_DATE_TABLE
17 , a4 out nocopy JTF_NUMBER_TABLE
18 , a5 out nocopy JTF_DATE_TABLE
19 , a6 out nocopy JTF_NUMBER_TABLE
20 , a7 out nocopy JTF_VARCHAR2_TABLE_100
21 , a8 out nocopy JTF_NUMBER_TABLE
22 );
23
24 procedure create_req_line_details(p_api_version_number NUMBER
25 , p_init_msg_list VARCHAR2
26 , p_commit VARCHAR2
27 , p_validation_level NUMBER
28 , p4_a0 JTF_NUMBER_TABLE
29 , p4_a1 JTF_NUMBER_TABLE
30 , p4_a2 JTF_NUMBER_TABLE
31 , p4_a3 JTF_DATE_TABLE
32 , p4_a4 JTF_NUMBER_TABLE
33 , p4_a5 JTF_DATE_TABLE
34 , p4_a6 JTF_NUMBER_TABLE
35 , p4_a7 JTF_VARCHAR2_TABLE_100
36 , p4_a8 JTF_NUMBER_TABLE
37 , p5_a0 out nocopy JTF_NUMBER_TABLE
38 , p5_a1 out nocopy JTF_NUMBER_TABLE
39 , p5_a2 out nocopy JTF_NUMBER_TABLE
40 , p5_a3 out nocopy JTF_DATE_TABLE
41 , p5_a4 out nocopy JTF_NUMBER_TABLE
42 , p5_a5 out nocopy JTF_DATE_TABLE
43 , p5_a6 out nocopy JTF_NUMBER_TABLE
44 , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
45 , p5_a8 out nocopy JTF_NUMBER_TABLE
46 , x_return_status out nocopy VARCHAR2
47 , x_msg_count out nocopy NUMBER
48 , x_msg_data out nocopy VARCHAR2
49 );
50 procedure update_req_line_details(p_api_version_number NUMBER
51 , p_init_msg_list VARCHAR2
52 , p_commit VARCHAR2
53 , p_validation_level NUMBER
54 , p4_a0 JTF_NUMBER_TABLE
55 , p4_a1 JTF_NUMBER_TABLE
56 , p4_a2 JTF_NUMBER_TABLE
57 , p4_a3 JTF_DATE_TABLE
58 , p4_a4 JTF_NUMBER_TABLE
59 , p4_a5 JTF_DATE_TABLE
60 , p4_a6 JTF_NUMBER_TABLE
61 , p4_a7 JTF_VARCHAR2_TABLE_100
62 , p4_a8 JTF_NUMBER_TABLE
63 , x_return_status out nocopy VARCHAR2
64 , x_msg_count out nocopy NUMBER
65 , x_msg_data out nocopy VARCHAR2
66 );
67 procedure delete_req_line_details(p_api_version_number NUMBER
68 , p_init_msg_list VARCHAR2
69 , p_commit VARCHAR2
70 , p_validation_level NUMBER
71 , p4_a0 JTF_NUMBER_TABLE
72 , p4_a1 JTF_NUMBER_TABLE
73 , p4_a2 JTF_NUMBER_TABLE
74 , p4_a3 JTF_DATE_TABLE
75 , p4_a4 JTF_NUMBER_TABLE
76 , p4_a5 JTF_DATE_TABLE
77 , p4_a6 JTF_NUMBER_TABLE
78 , p4_a7 JTF_VARCHAR2_TABLE_100
79 , p4_a8 JTF_NUMBER_TABLE
80 , x_return_status out nocopy VARCHAR2
81 , x_msg_count out nocopy NUMBER
82 , x_msg_data out nocopy VARCHAR2
83 );
84 end csp_req_line_details_pvt_w;