DBA Data[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;