1: package ams_dmlift_pvt_w AUTHID CURRENT_USER as
2: /* $Header: amswdlfs.pls 120.1 2005/06/15 23:58:27 appldev $ */
3: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_dmlift_pvt.lift_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
1: package ams_dmlift_pvt_w AUTHID CURRENT_USER as
2: /* $Header: amswdlfs.pls 120.1 2005/06/15 23:58:27 appldev $ */
3: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_dmlift_pvt.lift_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
3: procedure rosetta_table_copy_in_p3(t OUT NOCOPY ams_dmlift_pvt.lift_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
4: , a1 JTF_DATE_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: );
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: );
23: procedure rosetta_table_copy_out_p3(t ams_dmlift_pvt.lift_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: );
23: procedure rosetta_table_copy_out_p3(t ams_dmlift_pvt.lift_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
24: , a1 OUT NOCOPY JTF_DATE_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: );
23: procedure rosetta_table_copy_out_p3(t ams_dmlift_pvt.lift_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
24: , a1 OUT NOCOPY JTF_DATE_TABLE
25: , a2 OUT NOCOPY JTF_NUMBER_TABLE
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: );
23: procedure rosetta_table_copy_out_p3(t ams_dmlift_pvt.lift_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
24: , a1 OUT NOCOPY JTF_DATE_TABLE
25: , a2 OUT NOCOPY JTF_NUMBER_TABLE
26: , a3 OUT NOCOPY JTF_DATE_TABLE
27: , a4 OUT NOCOPY JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: );
23: procedure rosetta_table_copy_out_p3(t ams_dmlift_pvt.lift_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
24: , a1 OUT NOCOPY JTF_DATE_TABLE
25: , a2 OUT NOCOPY JTF_NUMBER_TABLE
26: , a3 OUT NOCOPY JTF_DATE_TABLE
27: , a4 OUT NOCOPY JTF_NUMBER_TABLE
28: , a5 OUT NOCOPY JTF_NUMBER_TABLE
29: , a6 OUT NOCOPY JTF_NUMBER_TABLE
23: procedure rosetta_table_copy_out_p3(t ams_dmlift_pvt.lift_tbl_type, a0 OUT NOCOPY JTF_NUMBER_TABLE
24: , a1 OUT NOCOPY JTF_DATE_TABLE
25: , a2 OUT NOCOPY JTF_NUMBER_TABLE
26: , a3 OUT NOCOPY JTF_DATE_TABLE
27: , a4 OUT NOCOPY JTF_NUMBER_TABLE
28: , a5 OUT NOCOPY JTF_NUMBER_TABLE
29: , a6 OUT NOCOPY JTF_NUMBER_TABLE
30: , a7 OUT NOCOPY JTF_NUMBER_TABLE
31: , a8 OUT NOCOPY JTF_NUMBER_TABLE
24: , a1 OUT NOCOPY JTF_DATE_TABLE
25: , a2 OUT NOCOPY JTF_NUMBER_TABLE
26: , a3 OUT NOCOPY JTF_DATE_TABLE
27: , a4 OUT NOCOPY JTF_NUMBER_TABLE
28: , a5 OUT NOCOPY JTF_NUMBER_TABLE
29: , a6 OUT NOCOPY JTF_NUMBER_TABLE
30: , a7 OUT NOCOPY JTF_NUMBER_TABLE
31: , a8 OUT NOCOPY JTF_NUMBER_TABLE
32: , a9 OUT NOCOPY JTF_NUMBER_TABLE
25: , a2 OUT NOCOPY JTF_NUMBER_TABLE
26: , a3 OUT NOCOPY JTF_DATE_TABLE
27: , a4 OUT NOCOPY JTF_NUMBER_TABLE
28: , a5 OUT NOCOPY JTF_NUMBER_TABLE
29: , a6 OUT NOCOPY JTF_NUMBER_TABLE
30: , a7 OUT NOCOPY JTF_NUMBER_TABLE
31: , a8 OUT NOCOPY JTF_NUMBER_TABLE
32: , a9 OUT NOCOPY JTF_NUMBER_TABLE
33: , a10 OUT NOCOPY JTF_NUMBER_TABLE
26: , a3 OUT NOCOPY JTF_DATE_TABLE
27: , a4 OUT NOCOPY JTF_NUMBER_TABLE
28: , a5 OUT NOCOPY JTF_NUMBER_TABLE
29: , a6 OUT NOCOPY JTF_NUMBER_TABLE
30: , a7 OUT NOCOPY JTF_NUMBER_TABLE
31: , a8 OUT NOCOPY JTF_NUMBER_TABLE
32: , a9 OUT NOCOPY JTF_NUMBER_TABLE
33: , a10 OUT NOCOPY JTF_NUMBER_TABLE
34: , a11 OUT NOCOPY JTF_NUMBER_TABLE
27: , a4 OUT NOCOPY JTF_NUMBER_TABLE
28: , a5 OUT NOCOPY JTF_NUMBER_TABLE
29: , a6 OUT NOCOPY JTF_NUMBER_TABLE
30: , a7 OUT NOCOPY JTF_NUMBER_TABLE
31: , a8 OUT NOCOPY JTF_NUMBER_TABLE
32: , a9 OUT NOCOPY JTF_NUMBER_TABLE
33: , a10 OUT NOCOPY JTF_NUMBER_TABLE
34: , a11 OUT NOCOPY JTF_NUMBER_TABLE
35: , a12 OUT NOCOPY JTF_NUMBER_TABLE
28: , a5 OUT NOCOPY JTF_NUMBER_TABLE
29: , a6 OUT NOCOPY JTF_NUMBER_TABLE
30: , a7 OUT NOCOPY JTF_NUMBER_TABLE
31: , a8 OUT NOCOPY JTF_NUMBER_TABLE
32: , a9 OUT NOCOPY JTF_NUMBER_TABLE
33: , a10 OUT NOCOPY JTF_NUMBER_TABLE
34: , a11 OUT NOCOPY JTF_NUMBER_TABLE
35: , a12 OUT NOCOPY JTF_NUMBER_TABLE
36: , a13 OUT NOCOPY JTF_NUMBER_TABLE
29: , a6 OUT NOCOPY JTF_NUMBER_TABLE
30: , a7 OUT NOCOPY JTF_NUMBER_TABLE
31: , a8 OUT NOCOPY JTF_NUMBER_TABLE
32: , a9 OUT NOCOPY JTF_NUMBER_TABLE
33: , a10 OUT NOCOPY JTF_NUMBER_TABLE
34: , a11 OUT NOCOPY JTF_NUMBER_TABLE
35: , a12 OUT NOCOPY JTF_NUMBER_TABLE
36: , a13 OUT NOCOPY JTF_NUMBER_TABLE
37: , a14 OUT NOCOPY JTF_NUMBER_TABLE
30: , a7 OUT NOCOPY JTF_NUMBER_TABLE
31: , a8 OUT NOCOPY JTF_NUMBER_TABLE
32: , a9 OUT NOCOPY JTF_NUMBER_TABLE
33: , a10 OUT NOCOPY JTF_NUMBER_TABLE
34: , a11 OUT NOCOPY JTF_NUMBER_TABLE
35: , a12 OUT NOCOPY JTF_NUMBER_TABLE
36: , a13 OUT NOCOPY JTF_NUMBER_TABLE
37: , a14 OUT NOCOPY JTF_NUMBER_TABLE
38: , a15 OUT NOCOPY JTF_NUMBER_TABLE
31: , a8 OUT NOCOPY JTF_NUMBER_TABLE
32: , a9 OUT NOCOPY JTF_NUMBER_TABLE
33: , a10 OUT NOCOPY JTF_NUMBER_TABLE
34: , a11 OUT NOCOPY JTF_NUMBER_TABLE
35: , a12 OUT NOCOPY JTF_NUMBER_TABLE
36: , a13 OUT NOCOPY JTF_NUMBER_TABLE
37: , a14 OUT NOCOPY JTF_NUMBER_TABLE
38: , a15 OUT NOCOPY JTF_NUMBER_TABLE
39: , a16 OUT NOCOPY JTF_NUMBER_TABLE
32: , a9 OUT NOCOPY JTF_NUMBER_TABLE
33: , a10 OUT NOCOPY JTF_NUMBER_TABLE
34: , a11 OUT NOCOPY JTF_NUMBER_TABLE
35: , a12 OUT NOCOPY JTF_NUMBER_TABLE
36: , a13 OUT NOCOPY JTF_NUMBER_TABLE
37: , a14 OUT NOCOPY JTF_NUMBER_TABLE
38: , a15 OUT NOCOPY JTF_NUMBER_TABLE
39: , a16 OUT NOCOPY JTF_NUMBER_TABLE
40: , a17 OUT NOCOPY JTF_NUMBER_TABLE
33: , a10 OUT NOCOPY JTF_NUMBER_TABLE
34: , a11 OUT NOCOPY JTF_NUMBER_TABLE
35: , a12 OUT NOCOPY JTF_NUMBER_TABLE
36: , a13 OUT NOCOPY JTF_NUMBER_TABLE
37: , a14 OUT NOCOPY JTF_NUMBER_TABLE
38: , a15 OUT NOCOPY JTF_NUMBER_TABLE
39: , a16 OUT NOCOPY JTF_NUMBER_TABLE
40: , a17 OUT NOCOPY JTF_NUMBER_TABLE
41: , a18 OUT NOCOPY JTF_NUMBER_TABLE
34: , a11 OUT NOCOPY JTF_NUMBER_TABLE
35: , a12 OUT NOCOPY JTF_NUMBER_TABLE
36: , a13 OUT NOCOPY JTF_NUMBER_TABLE
37: , a14 OUT NOCOPY JTF_NUMBER_TABLE
38: , a15 OUT NOCOPY JTF_NUMBER_TABLE
39: , a16 OUT NOCOPY JTF_NUMBER_TABLE
40: , a17 OUT NOCOPY JTF_NUMBER_TABLE
41: , a18 OUT NOCOPY JTF_NUMBER_TABLE
42: );
35: , a12 OUT NOCOPY JTF_NUMBER_TABLE
36: , a13 OUT NOCOPY JTF_NUMBER_TABLE
37: , a14 OUT NOCOPY JTF_NUMBER_TABLE
38: , a15 OUT NOCOPY JTF_NUMBER_TABLE
39: , a16 OUT NOCOPY JTF_NUMBER_TABLE
40: , a17 OUT NOCOPY JTF_NUMBER_TABLE
41: , a18 OUT NOCOPY JTF_NUMBER_TABLE
42: );
43:
36: , a13 OUT NOCOPY JTF_NUMBER_TABLE
37: , a14 OUT NOCOPY JTF_NUMBER_TABLE
38: , a15 OUT NOCOPY JTF_NUMBER_TABLE
39: , a16 OUT NOCOPY JTF_NUMBER_TABLE
40: , a17 OUT NOCOPY JTF_NUMBER_TABLE
41: , a18 OUT NOCOPY JTF_NUMBER_TABLE
42: );
43:
44: procedure check_lift_items(p_validation_mode VARCHAR2
37: , a14 OUT NOCOPY JTF_NUMBER_TABLE
38: , a15 OUT NOCOPY JTF_NUMBER_TABLE
39: , a16 OUT NOCOPY JTF_NUMBER_TABLE
40: , a17 OUT NOCOPY JTF_NUMBER_TABLE
41: , a18 OUT NOCOPY JTF_NUMBER_TABLE
42: );
43:
44: procedure check_lift_items(p_validation_mode VARCHAR2
45: , x_return_status OUT NOCOPY VARCHAR2