1: package ibe_atp_pvt_w AUTHID CURRENT_USER as
2: /* $Header: IBEVATWS.pls 115.8 2003/08/29 09:09:06 nsultan ship $ */
3: procedure rosetta_table_copy_in_p1(t out NOCOPY ibe_atp_pvt.atp_line_tbl_typ, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
1: package ibe_atp_pvt_w AUTHID CURRENT_USER as
2: /* $Header: IBEVATWS.pls 115.8 2003/08/29 09:09:06 nsultan ship $ */
3: procedure rosetta_table_copy_in_p1(t out NOCOPY ibe_atp_pvt.atp_line_tbl_typ, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
1: package ibe_atp_pvt_w AUTHID CURRENT_USER as
2: /* $Header: IBEVATWS.pls 115.8 2003/08/29 09:09:06 nsultan ship $ */
3: procedure rosetta_table_copy_in_p1(t out NOCOPY ibe_atp_pvt.atp_line_tbl_typ, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
2: /* $Header: IBEVATWS.pls 115.8 2003/08/29 09:09:06 nsultan ship $ */
3: procedure rosetta_table_copy_in_p1(t out NOCOPY ibe_atp_pvt.atp_line_tbl_typ, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_2000
16: );
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_2000
16: );
17: procedure rosetta_table_copy_out_p1(t ibe_atp_pvt.atp_line_tbl_typ, a0 out NOCOPY JTF_NUMBER_TABLE
18: , a1 out NOCOPY JTF_NUMBER_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_2000
16: );
17: procedure rosetta_table_copy_out_p1(t ibe_atp_pvt.atp_line_tbl_typ, a0 out NOCOPY JTF_NUMBER_TABLE
18: , a1 out NOCOPY JTF_NUMBER_TABLE
19: , a2 out NOCOPY JTF_NUMBER_TABLE
20: , a3 out NOCOPY JTF_NUMBER_TABLE
21: , a4 out NOCOPY JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_2000
16: );
17: procedure rosetta_table_copy_out_p1(t ibe_atp_pvt.atp_line_tbl_typ, a0 out NOCOPY JTF_NUMBER_TABLE
18: , a1 out NOCOPY JTF_NUMBER_TABLE
19: , a2 out NOCOPY JTF_NUMBER_TABLE
20: , a3 out NOCOPY JTF_NUMBER_TABLE
21: , a4 out NOCOPY JTF_VARCHAR2_TABLE_100
22: , a5 out NOCOPY JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_2000
16: );
17: procedure rosetta_table_copy_out_p1(t ibe_atp_pvt.atp_line_tbl_typ, a0 out NOCOPY JTF_NUMBER_TABLE
18: , a1 out NOCOPY JTF_NUMBER_TABLE
19: , a2 out NOCOPY JTF_NUMBER_TABLE
20: , a3 out NOCOPY JTF_NUMBER_TABLE
21: , a4 out NOCOPY JTF_VARCHAR2_TABLE_100
22: , a5 out NOCOPY JTF_NUMBER_TABLE
23: , a6 out NOCOPY JTF_NUMBER_TABLE
16: );
17: procedure rosetta_table_copy_out_p1(t ibe_atp_pvt.atp_line_tbl_typ, a0 out NOCOPY JTF_NUMBER_TABLE
18: , a1 out NOCOPY JTF_NUMBER_TABLE
19: , a2 out NOCOPY JTF_NUMBER_TABLE
20: , a3 out NOCOPY JTF_NUMBER_TABLE
21: , a4 out NOCOPY JTF_VARCHAR2_TABLE_100
22: , a5 out NOCOPY JTF_NUMBER_TABLE
23: , a6 out NOCOPY JTF_NUMBER_TABLE
24: , a7 out NOCOPY JTF_VARCHAR2_TABLE_100
18: , a1 out NOCOPY JTF_NUMBER_TABLE
19: , a2 out NOCOPY JTF_NUMBER_TABLE
20: , a3 out NOCOPY JTF_NUMBER_TABLE
21: , a4 out NOCOPY JTF_VARCHAR2_TABLE_100
22: , a5 out NOCOPY JTF_NUMBER_TABLE
23: , a6 out NOCOPY JTF_NUMBER_TABLE
24: , a7 out NOCOPY JTF_VARCHAR2_TABLE_100
25: , a8 out NOCOPY JTF_VARCHAR2_TABLE_100
26: , a9 out NOCOPY JTF_NUMBER_TABLE
19: , a2 out NOCOPY JTF_NUMBER_TABLE
20: , a3 out NOCOPY JTF_NUMBER_TABLE
21: , a4 out NOCOPY JTF_VARCHAR2_TABLE_100
22: , a5 out NOCOPY JTF_NUMBER_TABLE
23: , a6 out NOCOPY JTF_NUMBER_TABLE
24: , a7 out NOCOPY JTF_VARCHAR2_TABLE_100
25: , a8 out NOCOPY JTF_VARCHAR2_TABLE_100
26: , a9 out NOCOPY JTF_NUMBER_TABLE
27: , a10 out NOCOPY JTF_VARCHAR2_TABLE_100
22: , a5 out NOCOPY JTF_NUMBER_TABLE
23: , a6 out NOCOPY JTF_NUMBER_TABLE
24: , a7 out NOCOPY JTF_VARCHAR2_TABLE_100
25: , a8 out NOCOPY JTF_VARCHAR2_TABLE_100
26: , a9 out NOCOPY JTF_NUMBER_TABLE
27: , a10 out NOCOPY JTF_VARCHAR2_TABLE_100
28: , a11 out NOCOPY JTF_NUMBER_TABLE
29: , a12 out NOCOPY JTF_VARCHAR2_TABLE_2000
30: );
24: , a7 out NOCOPY JTF_VARCHAR2_TABLE_100
25: , a8 out NOCOPY JTF_VARCHAR2_TABLE_100
26: , a9 out NOCOPY JTF_NUMBER_TABLE
27: , a10 out NOCOPY JTF_VARCHAR2_TABLE_100
28: , a11 out NOCOPY JTF_NUMBER_TABLE
29: , a12 out NOCOPY JTF_VARCHAR2_TABLE_2000
30: );
31:
32: procedure check_availability(p_quote_header_id NUMBER
33: , p_date_format VARCHAR2
34: , p_lang_code VARCHAR2
35: , x_error_flag out NOCOPY VARCHAR2
36: , x_error_message out NOCOPY VARCHAR2
37: , p5_a0 in out NOCOPY JTF_NUMBER_TABLE
38: , p5_a1 in out NOCOPY JTF_NUMBER_TABLE
39: , p5_a2 in out NOCOPY JTF_NUMBER_TABLE
40: , p5_a3 in out NOCOPY JTF_NUMBER_TABLE
41: , p5_a4 in out NOCOPY JTF_VARCHAR2_TABLE_100
34: , p_lang_code VARCHAR2
35: , x_error_flag out NOCOPY VARCHAR2
36: , x_error_message out NOCOPY VARCHAR2
37: , p5_a0 in out NOCOPY JTF_NUMBER_TABLE
38: , p5_a1 in out NOCOPY JTF_NUMBER_TABLE
39: , p5_a2 in out NOCOPY JTF_NUMBER_TABLE
40: , p5_a3 in out NOCOPY JTF_NUMBER_TABLE
41: , p5_a4 in out NOCOPY JTF_VARCHAR2_TABLE_100
42: , p5_a5 in out NOCOPY JTF_NUMBER_TABLE
35: , x_error_flag out NOCOPY VARCHAR2
36: , x_error_message out NOCOPY VARCHAR2
37: , p5_a0 in out NOCOPY JTF_NUMBER_TABLE
38: , p5_a1 in out NOCOPY JTF_NUMBER_TABLE
39: , p5_a2 in out NOCOPY JTF_NUMBER_TABLE
40: , p5_a3 in out NOCOPY JTF_NUMBER_TABLE
41: , p5_a4 in out NOCOPY JTF_VARCHAR2_TABLE_100
42: , p5_a5 in out NOCOPY JTF_NUMBER_TABLE
43: , p5_a6 in out NOCOPY JTF_NUMBER_TABLE
36: , x_error_message out NOCOPY VARCHAR2
37: , p5_a0 in out NOCOPY JTF_NUMBER_TABLE
38: , p5_a1 in out NOCOPY JTF_NUMBER_TABLE
39: , p5_a2 in out NOCOPY JTF_NUMBER_TABLE
40: , p5_a3 in out NOCOPY JTF_NUMBER_TABLE
41: , p5_a4 in out NOCOPY JTF_VARCHAR2_TABLE_100
42: , p5_a5 in out NOCOPY JTF_NUMBER_TABLE
43: , p5_a6 in out NOCOPY JTF_NUMBER_TABLE
44: , p5_a7 in out NOCOPY JTF_VARCHAR2_TABLE_100
38: , p5_a1 in out NOCOPY JTF_NUMBER_TABLE
39: , p5_a2 in out NOCOPY JTF_NUMBER_TABLE
40: , p5_a3 in out NOCOPY JTF_NUMBER_TABLE
41: , p5_a4 in out NOCOPY JTF_VARCHAR2_TABLE_100
42: , p5_a5 in out NOCOPY JTF_NUMBER_TABLE
43: , p5_a6 in out NOCOPY JTF_NUMBER_TABLE
44: , p5_a7 in out NOCOPY JTF_VARCHAR2_TABLE_100
45: , p5_a8 in out NOCOPY JTF_VARCHAR2_TABLE_100
46: , p5_a9 in out NOCOPY JTF_NUMBER_TABLE
39: , p5_a2 in out NOCOPY JTF_NUMBER_TABLE
40: , p5_a3 in out NOCOPY JTF_NUMBER_TABLE
41: , p5_a4 in out NOCOPY JTF_VARCHAR2_TABLE_100
42: , p5_a5 in out NOCOPY JTF_NUMBER_TABLE
43: , p5_a6 in out NOCOPY JTF_NUMBER_TABLE
44: , p5_a7 in out NOCOPY JTF_VARCHAR2_TABLE_100
45: , p5_a8 in out NOCOPY JTF_VARCHAR2_TABLE_100
46: , p5_a9 in out NOCOPY JTF_NUMBER_TABLE
47: , p5_a10 in out NOCOPY JTF_VARCHAR2_TABLE_100
42: , p5_a5 in out NOCOPY JTF_NUMBER_TABLE
43: , p5_a6 in out NOCOPY JTF_NUMBER_TABLE
44: , p5_a7 in out NOCOPY JTF_VARCHAR2_TABLE_100
45: , p5_a8 in out NOCOPY JTF_VARCHAR2_TABLE_100
46: , p5_a9 in out NOCOPY JTF_NUMBER_TABLE
47: , p5_a10 in out NOCOPY JTF_VARCHAR2_TABLE_100
48: , p5_a11 in out NOCOPY JTF_NUMBER_TABLE
49: , p5_a12 in out NOCOPY JTF_VARCHAR2_TABLE_2000
50: );
44: , p5_a7 in out NOCOPY JTF_VARCHAR2_TABLE_100
45: , p5_a8 in out NOCOPY JTF_VARCHAR2_TABLE_100
46: , p5_a9 in out NOCOPY JTF_NUMBER_TABLE
47: , p5_a10 in out NOCOPY JTF_VARCHAR2_TABLE_100
48: , p5_a11 in out NOCOPY JTF_NUMBER_TABLE
49: , p5_a12 in out NOCOPY JTF_VARCHAR2_TABLE_2000
50: );
51: end ibe_atp_pvt_w;