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
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
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
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
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
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
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
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
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
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
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:
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: );