1: package ahl_ltp_reqst_matrl_pub_w AUTHID CURRENT_USER as
2: /* $Header: AHLWRMTS.pls 115.10 2003/10/29 22:24:33 ssurapan noship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ltp_reqst_matrl_pub.schedule_mr_tbl, 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 ahl_ltp_reqst_matrl_pub_w AUTHID CURRENT_USER as
2: /* $Header: AHLWRMTS.pls 115.10 2003/10/29 22:24:33 ssurapan noship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ltp_reqst_matrl_pub.schedule_mr_tbl, 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 ahl_ltp_reqst_matrl_pub_w AUTHID CURRENT_USER as
2: /* $Header: AHLWRMTS.pls 115.10 2003/10/29 22:24:33 ssurapan noship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ltp_reqst_matrl_pub.schedule_mr_tbl, 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: AHLWRMTS.pls 115.10 2003/10/29 22:24:33 ssurapan noship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_ltp_reqst_matrl_pub.schedule_mr_tbl, 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_NUMBER_TABLE
12: , a9 JTF_DATE_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_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 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_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_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_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_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_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_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_VARCHAR2_TABLE_100
19: , a16 JTF_DATE_TABLE
12: , a9 JTF_DATE_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_VARCHAR2_TABLE_100
19: , a16 JTF_DATE_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_VARCHAR2_TABLE_100
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_NUMBER_TABLE
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_4000
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_4000
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_NUMBER_TABLE
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_4000
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_4000
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_VARCHAR2_TABLE_4000
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_VARCHAR2_TABLE_4000
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_VARCHAR2_TABLE_100
33: );
34: procedure rosetta_table_copy_out_p3(t ahl_ltp_reqst_matrl_pub.schedule_mr_tbl, a0 out nocopy JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_VARCHAR2_TABLE_100
33: );
34: procedure rosetta_table_copy_out_p3(t ahl_ltp_reqst_matrl_pub.schedule_mr_tbl, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_VARCHAR2_TABLE_100
33: );
34: procedure rosetta_table_copy_out_p3(t ahl_ltp_reqst_matrl_pub.schedule_mr_tbl, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_VARCHAR2_TABLE_100
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_VARCHAR2_TABLE_100
33: );
34: procedure rosetta_table_copy_out_p3(t ahl_ltp_reqst_matrl_pub.schedule_mr_tbl, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_VARCHAR2_TABLE_100
39: , a5 out nocopy JTF_NUMBER_TABLE
32: , a29 JTF_VARCHAR2_TABLE_100
33: );
34: procedure rosetta_table_copy_out_p3(t ahl_ltp_reqst_matrl_pub.schedule_mr_tbl, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_VARCHAR2_TABLE_100
39: , a5 out nocopy JTF_NUMBER_TABLE
40: , a6 out nocopy JTF_NUMBER_TABLE
33: );
34: procedure rosetta_table_copy_out_p3(t ahl_ltp_reqst_matrl_pub.schedule_mr_tbl, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_VARCHAR2_TABLE_100
39: , a5 out nocopy JTF_NUMBER_TABLE
40: , a6 out nocopy JTF_NUMBER_TABLE
41: , a7 out nocopy JTF_VARCHAR2_TABLE_100
35: , a1 out nocopy JTF_NUMBER_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_VARCHAR2_TABLE_100
39: , a5 out nocopy JTF_NUMBER_TABLE
40: , a6 out nocopy JTF_NUMBER_TABLE
41: , a7 out nocopy JTF_VARCHAR2_TABLE_100
42: , a8 out nocopy JTF_NUMBER_TABLE
43: , a9 out nocopy JTF_DATE_TABLE
36: , a2 out nocopy JTF_NUMBER_TABLE
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_VARCHAR2_TABLE_100
39: , a5 out nocopy JTF_NUMBER_TABLE
40: , a6 out nocopy JTF_NUMBER_TABLE
41: , a7 out nocopy JTF_VARCHAR2_TABLE_100
42: , a8 out nocopy JTF_NUMBER_TABLE
43: , a9 out nocopy JTF_DATE_TABLE
44: , a10 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_VARCHAR2_TABLE_100
39: , a5 out nocopy JTF_NUMBER_TABLE
40: , a6 out nocopy JTF_NUMBER_TABLE
41: , a7 out nocopy JTF_VARCHAR2_TABLE_100
42: , a8 out nocopy JTF_NUMBER_TABLE
43: , a9 out nocopy JTF_DATE_TABLE
44: , a10 out nocopy JTF_NUMBER_TABLE
45: , a11 out nocopy JTF_NUMBER_TABLE
46: , a12 out nocopy JTF_NUMBER_TABLE
40: , a6 out nocopy JTF_NUMBER_TABLE
41: , a7 out nocopy JTF_VARCHAR2_TABLE_100
42: , a8 out nocopy JTF_NUMBER_TABLE
43: , a9 out nocopy JTF_DATE_TABLE
44: , a10 out nocopy JTF_NUMBER_TABLE
45: , a11 out nocopy JTF_NUMBER_TABLE
46: , a12 out nocopy JTF_NUMBER_TABLE
47: , a13 out nocopy JTF_NUMBER_TABLE
48: , a14 out nocopy JTF_NUMBER_TABLE
41: , a7 out nocopy JTF_VARCHAR2_TABLE_100
42: , a8 out nocopy JTF_NUMBER_TABLE
43: , a9 out nocopy JTF_DATE_TABLE
44: , a10 out nocopy JTF_NUMBER_TABLE
45: , a11 out nocopy JTF_NUMBER_TABLE
46: , a12 out nocopy JTF_NUMBER_TABLE
47: , a13 out nocopy JTF_NUMBER_TABLE
48: , a14 out nocopy JTF_NUMBER_TABLE
49: , a15 out nocopy JTF_VARCHAR2_TABLE_100
42: , a8 out nocopy JTF_NUMBER_TABLE
43: , a9 out nocopy JTF_DATE_TABLE
44: , a10 out nocopy JTF_NUMBER_TABLE
45: , a11 out nocopy JTF_NUMBER_TABLE
46: , a12 out nocopy JTF_NUMBER_TABLE
47: , a13 out nocopy JTF_NUMBER_TABLE
48: , a14 out nocopy JTF_NUMBER_TABLE
49: , a15 out nocopy JTF_VARCHAR2_TABLE_100
50: , a16 out nocopy JTF_DATE_TABLE
43: , a9 out nocopy JTF_DATE_TABLE
44: , a10 out nocopy JTF_NUMBER_TABLE
45: , a11 out nocopy JTF_NUMBER_TABLE
46: , a12 out nocopy JTF_NUMBER_TABLE
47: , a13 out nocopy JTF_NUMBER_TABLE
48: , a14 out nocopy JTF_NUMBER_TABLE
49: , a15 out nocopy JTF_VARCHAR2_TABLE_100
50: , a16 out nocopy JTF_DATE_TABLE
51: , a17 out nocopy JTF_NUMBER_TABLE
44: , a10 out nocopy JTF_NUMBER_TABLE
45: , a11 out nocopy JTF_NUMBER_TABLE
46: , a12 out nocopy JTF_NUMBER_TABLE
47: , a13 out nocopy JTF_NUMBER_TABLE
48: , a14 out nocopy JTF_NUMBER_TABLE
49: , a15 out nocopy JTF_VARCHAR2_TABLE_100
50: , a16 out nocopy JTF_DATE_TABLE
51: , a17 out nocopy JTF_NUMBER_TABLE
52: , a18 out nocopy JTF_VARCHAR2_TABLE_100
47: , a13 out nocopy JTF_NUMBER_TABLE
48: , a14 out nocopy JTF_NUMBER_TABLE
49: , a15 out nocopy JTF_VARCHAR2_TABLE_100
50: , a16 out nocopy JTF_DATE_TABLE
51: , a17 out nocopy JTF_NUMBER_TABLE
52: , a18 out nocopy JTF_VARCHAR2_TABLE_100
53: , a19 out nocopy JTF_NUMBER_TABLE
54: , a20 out nocopy JTF_VARCHAR2_TABLE_100
55: , a21 out nocopy JTF_NUMBER_TABLE
49: , a15 out nocopy JTF_VARCHAR2_TABLE_100
50: , a16 out nocopy JTF_DATE_TABLE
51: , a17 out nocopy JTF_NUMBER_TABLE
52: , a18 out nocopy JTF_VARCHAR2_TABLE_100
53: , a19 out nocopy JTF_NUMBER_TABLE
54: , a20 out nocopy JTF_VARCHAR2_TABLE_100
55: , a21 out nocopy JTF_NUMBER_TABLE
56: , a22 out nocopy JTF_NUMBER_TABLE
57: , a23 out nocopy JTF_VARCHAR2_TABLE_4000
51: , a17 out nocopy JTF_NUMBER_TABLE
52: , a18 out nocopy JTF_VARCHAR2_TABLE_100
53: , a19 out nocopy JTF_NUMBER_TABLE
54: , a20 out nocopy JTF_VARCHAR2_TABLE_100
55: , a21 out nocopy JTF_NUMBER_TABLE
56: , a22 out nocopy JTF_NUMBER_TABLE
57: , a23 out nocopy JTF_VARCHAR2_TABLE_4000
58: , a24 out nocopy JTF_NUMBER_TABLE
59: , a25 out nocopy JTF_NUMBER_TABLE
52: , a18 out nocopy JTF_VARCHAR2_TABLE_100
53: , a19 out nocopy JTF_NUMBER_TABLE
54: , a20 out nocopy JTF_VARCHAR2_TABLE_100
55: , a21 out nocopy JTF_NUMBER_TABLE
56: , a22 out nocopy JTF_NUMBER_TABLE
57: , a23 out nocopy JTF_VARCHAR2_TABLE_4000
58: , a24 out nocopy JTF_NUMBER_TABLE
59: , a25 out nocopy JTF_NUMBER_TABLE
60: , a26 out nocopy JTF_VARCHAR2_TABLE_100
54: , a20 out nocopy JTF_VARCHAR2_TABLE_100
55: , a21 out nocopy JTF_NUMBER_TABLE
56: , a22 out nocopy JTF_NUMBER_TABLE
57: , a23 out nocopy JTF_VARCHAR2_TABLE_4000
58: , a24 out nocopy JTF_NUMBER_TABLE
59: , a25 out nocopy JTF_NUMBER_TABLE
60: , a26 out nocopy JTF_VARCHAR2_TABLE_100
61: , a27 out nocopy JTF_NUMBER_TABLE
62: , a28 out nocopy JTF_NUMBER_TABLE
55: , a21 out nocopy JTF_NUMBER_TABLE
56: , a22 out nocopy JTF_NUMBER_TABLE
57: , a23 out nocopy JTF_VARCHAR2_TABLE_4000
58: , a24 out nocopy JTF_NUMBER_TABLE
59: , a25 out nocopy JTF_NUMBER_TABLE
60: , a26 out nocopy JTF_VARCHAR2_TABLE_100
61: , a27 out nocopy JTF_NUMBER_TABLE
62: , a28 out nocopy JTF_NUMBER_TABLE
63: , a29 out nocopy JTF_VARCHAR2_TABLE_100
57: , a23 out nocopy JTF_VARCHAR2_TABLE_4000
58: , a24 out nocopy JTF_NUMBER_TABLE
59: , a25 out nocopy JTF_NUMBER_TABLE
60: , a26 out nocopy JTF_VARCHAR2_TABLE_100
61: , a27 out nocopy JTF_NUMBER_TABLE
62: , a28 out nocopy JTF_NUMBER_TABLE
63: , a29 out nocopy JTF_VARCHAR2_TABLE_100
64: );
65:
58: , a24 out nocopy JTF_NUMBER_TABLE
59: , a25 out nocopy JTF_NUMBER_TABLE
60: , a26 out nocopy JTF_VARCHAR2_TABLE_100
61: , a27 out nocopy JTF_NUMBER_TABLE
62: , a28 out nocopy JTF_NUMBER_TABLE
63: , a29 out nocopy JTF_VARCHAR2_TABLE_100
64: );
65:
66: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ltp_reqst_matrl_pub.task_details_tbl, a0 JTF_NUMBER_TABLE
62: , a28 out nocopy JTF_NUMBER_TABLE
63: , a29 out nocopy JTF_VARCHAR2_TABLE_100
64: );
65:
66: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ltp_reqst_matrl_pub.task_details_tbl, a0 JTF_NUMBER_TABLE
67: , a1 JTF_NUMBER_TABLE
68: , a2 JTF_NUMBER_TABLE
69: , a3 JTF_VARCHAR2_TABLE_100
70: , a4 JTF_NUMBER_TABLE
63: , a29 out nocopy JTF_VARCHAR2_TABLE_100
64: );
65:
66: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ltp_reqst_matrl_pub.task_details_tbl, a0 JTF_NUMBER_TABLE
67: , a1 JTF_NUMBER_TABLE
68: , a2 JTF_NUMBER_TABLE
69: , a3 JTF_VARCHAR2_TABLE_100
70: , a4 JTF_NUMBER_TABLE
71: , a5 JTF_NUMBER_TABLE
64: );
65:
66: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ltp_reqst_matrl_pub.task_details_tbl, a0 JTF_NUMBER_TABLE
67: , a1 JTF_NUMBER_TABLE
68: , a2 JTF_NUMBER_TABLE
69: , a3 JTF_VARCHAR2_TABLE_100
70: , a4 JTF_NUMBER_TABLE
71: , a5 JTF_NUMBER_TABLE
72: , a6 JTF_NUMBER_TABLE
66: procedure rosetta_table_copy_in_p4(t out nocopy ahl_ltp_reqst_matrl_pub.task_details_tbl, a0 JTF_NUMBER_TABLE
67: , a1 JTF_NUMBER_TABLE
68: , a2 JTF_NUMBER_TABLE
69: , a3 JTF_VARCHAR2_TABLE_100
70: , a4 JTF_NUMBER_TABLE
71: , a5 JTF_NUMBER_TABLE
72: , a6 JTF_NUMBER_TABLE
73: , a7 JTF_VARCHAR2_TABLE_100
74: , a8 JTF_DATE_TABLE
67: , a1 JTF_NUMBER_TABLE
68: , a2 JTF_NUMBER_TABLE
69: , a3 JTF_VARCHAR2_TABLE_100
70: , a4 JTF_NUMBER_TABLE
71: , a5 JTF_NUMBER_TABLE
72: , a6 JTF_NUMBER_TABLE
73: , a7 JTF_VARCHAR2_TABLE_100
74: , a8 JTF_DATE_TABLE
75: , a9 JTF_NUMBER_TABLE
68: , a2 JTF_NUMBER_TABLE
69: , a3 JTF_VARCHAR2_TABLE_100
70: , a4 JTF_NUMBER_TABLE
71: , a5 JTF_NUMBER_TABLE
72: , a6 JTF_NUMBER_TABLE
73: , a7 JTF_VARCHAR2_TABLE_100
74: , a8 JTF_DATE_TABLE
75: , a9 JTF_NUMBER_TABLE
76: , a10 JTF_NUMBER_TABLE
71: , a5 JTF_NUMBER_TABLE
72: , a6 JTF_NUMBER_TABLE
73: , a7 JTF_VARCHAR2_TABLE_100
74: , a8 JTF_DATE_TABLE
75: , a9 JTF_NUMBER_TABLE
76: , a10 JTF_NUMBER_TABLE
77: , a11 JTF_NUMBER_TABLE
78: , a12 JTF_VARCHAR2_TABLE_100
79: , a13 JTF_DATE_TABLE
72: , a6 JTF_NUMBER_TABLE
73: , a7 JTF_VARCHAR2_TABLE_100
74: , a8 JTF_DATE_TABLE
75: , a9 JTF_NUMBER_TABLE
76: , a10 JTF_NUMBER_TABLE
77: , a11 JTF_NUMBER_TABLE
78: , a12 JTF_VARCHAR2_TABLE_100
79: , a13 JTF_DATE_TABLE
80: , a14 JTF_NUMBER_TABLE
73: , a7 JTF_VARCHAR2_TABLE_100
74: , a8 JTF_DATE_TABLE
75: , a9 JTF_NUMBER_TABLE
76: , a10 JTF_NUMBER_TABLE
77: , a11 JTF_NUMBER_TABLE
78: , a12 JTF_VARCHAR2_TABLE_100
79: , a13 JTF_DATE_TABLE
80: , a14 JTF_NUMBER_TABLE
81: );
76: , a10 JTF_NUMBER_TABLE
77: , a11 JTF_NUMBER_TABLE
78: , a12 JTF_VARCHAR2_TABLE_100
79: , a13 JTF_DATE_TABLE
80: , a14 JTF_NUMBER_TABLE
81: );
82: procedure rosetta_table_copy_out_p4(t ahl_ltp_reqst_matrl_pub.task_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
83: , a1 out nocopy JTF_NUMBER_TABLE
84: , a2 out nocopy JTF_NUMBER_TABLE
78: , a12 JTF_VARCHAR2_TABLE_100
79: , a13 JTF_DATE_TABLE
80: , a14 JTF_NUMBER_TABLE
81: );
82: procedure rosetta_table_copy_out_p4(t ahl_ltp_reqst_matrl_pub.task_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
83: , a1 out nocopy JTF_NUMBER_TABLE
84: , a2 out nocopy JTF_NUMBER_TABLE
85: , a3 out nocopy JTF_VARCHAR2_TABLE_100
86: , a4 out nocopy JTF_NUMBER_TABLE
79: , a13 JTF_DATE_TABLE
80: , a14 JTF_NUMBER_TABLE
81: );
82: procedure rosetta_table_copy_out_p4(t ahl_ltp_reqst_matrl_pub.task_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
83: , a1 out nocopy JTF_NUMBER_TABLE
84: , a2 out nocopy JTF_NUMBER_TABLE
85: , a3 out nocopy JTF_VARCHAR2_TABLE_100
86: , a4 out nocopy JTF_NUMBER_TABLE
87: , a5 out nocopy JTF_NUMBER_TABLE
80: , a14 JTF_NUMBER_TABLE
81: );
82: procedure rosetta_table_copy_out_p4(t ahl_ltp_reqst_matrl_pub.task_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
83: , a1 out nocopy JTF_NUMBER_TABLE
84: , a2 out nocopy JTF_NUMBER_TABLE
85: , a3 out nocopy JTF_VARCHAR2_TABLE_100
86: , a4 out nocopy JTF_NUMBER_TABLE
87: , a5 out nocopy JTF_NUMBER_TABLE
88: , a6 out nocopy JTF_NUMBER_TABLE
82: procedure rosetta_table_copy_out_p4(t ahl_ltp_reqst_matrl_pub.task_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
83: , a1 out nocopy JTF_NUMBER_TABLE
84: , a2 out nocopy JTF_NUMBER_TABLE
85: , a3 out nocopy JTF_VARCHAR2_TABLE_100
86: , a4 out nocopy JTF_NUMBER_TABLE
87: , a5 out nocopy JTF_NUMBER_TABLE
88: , a6 out nocopy JTF_NUMBER_TABLE
89: , a7 out nocopy JTF_VARCHAR2_TABLE_100
90: , a8 out nocopy JTF_DATE_TABLE
83: , a1 out nocopy JTF_NUMBER_TABLE
84: , a2 out nocopy JTF_NUMBER_TABLE
85: , a3 out nocopy JTF_VARCHAR2_TABLE_100
86: , a4 out nocopy JTF_NUMBER_TABLE
87: , a5 out nocopy JTF_NUMBER_TABLE
88: , a6 out nocopy JTF_NUMBER_TABLE
89: , a7 out nocopy JTF_VARCHAR2_TABLE_100
90: , a8 out nocopy JTF_DATE_TABLE
91: , a9 out nocopy JTF_NUMBER_TABLE
84: , a2 out nocopy JTF_NUMBER_TABLE
85: , a3 out nocopy JTF_VARCHAR2_TABLE_100
86: , a4 out nocopy JTF_NUMBER_TABLE
87: , a5 out nocopy JTF_NUMBER_TABLE
88: , a6 out nocopy JTF_NUMBER_TABLE
89: , a7 out nocopy JTF_VARCHAR2_TABLE_100
90: , a8 out nocopy JTF_DATE_TABLE
91: , a9 out nocopy JTF_NUMBER_TABLE
92: , a10 out nocopy JTF_NUMBER_TABLE
87: , a5 out nocopy JTF_NUMBER_TABLE
88: , a6 out nocopy JTF_NUMBER_TABLE
89: , a7 out nocopy JTF_VARCHAR2_TABLE_100
90: , a8 out nocopy JTF_DATE_TABLE
91: , a9 out nocopy JTF_NUMBER_TABLE
92: , a10 out nocopy JTF_NUMBER_TABLE
93: , a11 out nocopy JTF_NUMBER_TABLE
94: , a12 out nocopy JTF_VARCHAR2_TABLE_100
95: , a13 out nocopy JTF_DATE_TABLE
88: , a6 out nocopy JTF_NUMBER_TABLE
89: , a7 out nocopy JTF_VARCHAR2_TABLE_100
90: , a8 out nocopy JTF_DATE_TABLE
91: , a9 out nocopy JTF_NUMBER_TABLE
92: , a10 out nocopy JTF_NUMBER_TABLE
93: , a11 out nocopy JTF_NUMBER_TABLE
94: , a12 out nocopy JTF_VARCHAR2_TABLE_100
95: , a13 out nocopy JTF_DATE_TABLE
96: , a14 out nocopy JTF_NUMBER_TABLE
89: , a7 out nocopy JTF_VARCHAR2_TABLE_100
90: , a8 out nocopy JTF_DATE_TABLE
91: , a9 out nocopy JTF_NUMBER_TABLE
92: , a10 out nocopy JTF_NUMBER_TABLE
93: , a11 out nocopy JTF_NUMBER_TABLE
94: , a12 out nocopy JTF_VARCHAR2_TABLE_100
95: , a13 out nocopy JTF_DATE_TABLE
96: , a14 out nocopy JTF_NUMBER_TABLE
97: );
92: , a10 out nocopy JTF_NUMBER_TABLE
93: , a11 out nocopy JTF_NUMBER_TABLE
94: , a12 out nocopy JTF_VARCHAR2_TABLE_100
95: , a13 out nocopy JTF_DATE_TABLE
96: , a14 out nocopy JTF_NUMBER_TABLE
97: );
98:
99: procedure rosetta_table_copy_in_p5(t out nocopy ahl_ltp_reqst_matrl_pub.planned_materials_tbl, a0 JTF_NUMBER_TABLE
100: , a1 JTF_NUMBER_TABLE
95: , a13 out nocopy JTF_DATE_TABLE
96: , a14 out nocopy JTF_NUMBER_TABLE
97: );
98:
99: procedure rosetta_table_copy_in_p5(t out nocopy ahl_ltp_reqst_matrl_pub.planned_materials_tbl, a0 JTF_NUMBER_TABLE
100: , a1 JTF_NUMBER_TABLE
101: , a2 JTF_NUMBER_TABLE
102: , a3 JTF_NUMBER_TABLE
103: , a4 JTF_VARCHAR2_TABLE_100
96: , a14 out nocopy JTF_NUMBER_TABLE
97: );
98:
99: procedure rosetta_table_copy_in_p5(t out nocopy ahl_ltp_reqst_matrl_pub.planned_materials_tbl, a0 JTF_NUMBER_TABLE
100: , a1 JTF_NUMBER_TABLE
101: , a2 JTF_NUMBER_TABLE
102: , a3 JTF_NUMBER_TABLE
103: , a4 JTF_VARCHAR2_TABLE_100
104: , a5 JTF_NUMBER_TABLE
97: );
98:
99: procedure rosetta_table_copy_in_p5(t out nocopy ahl_ltp_reqst_matrl_pub.planned_materials_tbl, a0 JTF_NUMBER_TABLE
100: , a1 JTF_NUMBER_TABLE
101: , a2 JTF_NUMBER_TABLE
102: , a3 JTF_NUMBER_TABLE
103: , a4 JTF_VARCHAR2_TABLE_100
104: , a5 JTF_NUMBER_TABLE
105: , a6 JTF_VARCHAR2_TABLE_100
98:
99: procedure rosetta_table_copy_in_p5(t out nocopy ahl_ltp_reqst_matrl_pub.planned_materials_tbl, a0 JTF_NUMBER_TABLE
100: , a1 JTF_NUMBER_TABLE
101: , a2 JTF_NUMBER_TABLE
102: , a3 JTF_NUMBER_TABLE
103: , a4 JTF_VARCHAR2_TABLE_100
104: , a5 JTF_NUMBER_TABLE
105: , a6 JTF_VARCHAR2_TABLE_100
106: , a7 JTF_DATE_TABLE
100: , a1 JTF_NUMBER_TABLE
101: , a2 JTF_NUMBER_TABLE
102: , a3 JTF_NUMBER_TABLE
103: , a4 JTF_VARCHAR2_TABLE_100
104: , a5 JTF_NUMBER_TABLE
105: , a6 JTF_VARCHAR2_TABLE_100
106: , a7 JTF_DATE_TABLE
107: , a8 JTF_NUMBER_TABLE
108: , a9 JTF_NUMBER_TABLE
103: , a4 JTF_VARCHAR2_TABLE_100
104: , a5 JTF_NUMBER_TABLE
105: , a6 JTF_VARCHAR2_TABLE_100
106: , a7 JTF_DATE_TABLE
107: , a8 JTF_NUMBER_TABLE
108: , a9 JTF_NUMBER_TABLE
109: , a10 JTF_NUMBER_TABLE
110: );
111: procedure rosetta_table_copy_out_p5(t ahl_ltp_reqst_matrl_pub.planned_materials_tbl, a0 out nocopy JTF_NUMBER_TABLE
104: , a5 JTF_NUMBER_TABLE
105: , a6 JTF_VARCHAR2_TABLE_100
106: , a7 JTF_DATE_TABLE
107: , a8 JTF_NUMBER_TABLE
108: , a9 JTF_NUMBER_TABLE
109: , a10 JTF_NUMBER_TABLE
110: );
111: procedure rosetta_table_copy_out_p5(t ahl_ltp_reqst_matrl_pub.planned_materials_tbl, a0 out nocopy JTF_NUMBER_TABLE
112: , a1 out nocopy JTF_NUMBER_TABLE
105: , a6 JTF_VARCHAR2_TABLE_100
106: , a7 JTF_DATE_TABLE
107: , a8 JTF_NUMBER_TABLE
108: , a9 JTF_NUMBER_TABLE
109: , a10 JTF_NUMBER_TABLE
110: );
111: procedure rosetta_table_copy_out_p5(t ahl_ltp_reqst_matrl_pub.planned_materials_tbl, a0 out nocopy JTF_NUMBER_TABLE
112: , a1 out nocopy JTF_NUMBER_TABLE
113: , a2 out nocopy JTF_NUMBER_TABLE
107: , a8 JTF_NUMBER_TABLE
108: , a9 JTF_NUMBER_TABLE
109: , a10 JTF_NUMBER_TABLE
110: );
111: procedure rosetta_table_copy_out_p5(t ahl_ltp_reqst_matrl_pub.planned_materials_tbl, a0 out nocopy JTF_NUMBER_TABLE
112: , a1 out nocopy JTF_NUMBER_TABLE
113: , a2 out nocopy JTF_NUMBER_TABLE
114: , a3 out nocopy JTF_NUMBER_TABLE
115: , a4 out nocopy JTF_VARCHAR2_TABLE_100
108: , a9 JTF_NUMBER_TABLE
109: , a10 JTF_NUMBER_TABLE
110: );
111: procedure rosetta_table_copy_out_p5(t ahl_ltp_reqst_matrl_pub.planned_materials_tbl, a0 out nocopy JTF_NUMBER_TABLE
112: , a1 out nocopy JTF_NUMBER_TABLE
113: , a2 out nocopy JTF_NUMBER_TABLE
114: , a3 out nocopy JTF_NUMBER_TABLE
115: , a4 out nocopy JTF_VARCHAR2_TABLE_100
116: , a5 out nocopy JTF_NUMBER_TABLE
109: , a10 JTF_NUMBER_TABLE
110: );
111: procedure rosetta_table_copy_out_p5(t ahl_ltp_reqst_matrl_pub.planned_materials_tbl, a0 out nocopy JTF_NUMBER_TABLE
112: , a1 out nocopy JTF_NUMBER_TABLE
113: , a2 out nocopy JTF_NUMBER_TABLE
114: , a3 out nocopy JTF_NUMBER_TABLE
115: , a4 out nocopy JTF_VARCHAR2_TABLE_100
116: , a5 out nocopy JTF_NUMBER_TABLE
117: , a6 out nocopy JTF_VARCHAR2_TABLE_100
110: );
111: procedure rosetta_table_copy_out_p5(t ahl_ltp_reqst_matrl_pub.planned_materials_tbl, a0 out nocopy JTF_NUMBER_TABLE
112: , a1 out nocopy JTF_NUMBER_TABLE
113: , a2 out nocopy JTF_NUMBER_TABLE
114: , a3 out nocopy JTF_NUMBER_TABLE
115: , a4 out nocopy JTF_VARCHAR2_TABLE_100
116: , a5 out nocopy JTF_NUMBER_TABLE
117: , a6 out nocopy JTF_VARCHAR2_TABLE_100
118: , a7 out nocopy JTF_DATE_TABLE
112: , a1 out nocopy JTF_NUMBER_TABLE
113: , a2 out nocopy JTF_NUMBER_TABLE
114: , a3 out nocopy JTF_NUMBER_TABLE
115: , a4 out nocopy JTF_VARCHAR2_TABLE_100
116: , a5 out nocopy JTF_NUMBER_TABLE
117: , a6 out nocopy JTF_VARCHAR2_TABLE_100
118: , a7 out nocopy JTF_DATE_TABLE
119: , a8 out nocopy JTF_NUMBER_TABLE
120: , a9 out nocopy JTF_NUMBER_TABLE
115: , a4 out nocopy JTF_VARCHAR2_TABLE_100
116: , a5 out nocopy JTF_NUMBER_TABLE
117: , a6 out nocopy JTF_VARCHAR2_TABLE_100
118: , a7 out nocopy JTF_DATE_TABLE
119: , a8 out nocopy JTF_NUMBER_TABLE
120: , a9 out nocopy JTF_NUMBER_TABLE
121: , a10 out nocopy JTF_NUMBER_TABLE
122: );
123:
116: , a5 out nocopy JTF_NUMBER_TABLE
117: , a6 out nocopy JTF_VARCHAR2_TABLE_100
118: , a7 out nocopy JTF_DATE_TABLE
119: , a8 out nocopy JTF_NUMBER_TABLE
120: , a9 out nocopy JTF_NUMBER_TABLE
121: , a10 out nocopy JTF_NUMBER_TABLE
122: );
123:
124: procedure update_planned_materials(p_api_version NUMBER
117: , a6 out nocopy JTF_VARCHAR2_TABLE_100
118: , a7 out nocopy JTF_DATE_TABLE
119: , a8 out nocopy JTF_NUMBER_TABLE
120: , a9 out nocopy JTF_NUMBER_TABLE
121: , a10 out nocopy JTF_NUMBER_TABLE
122: );
123:
124: procedure update_planned_materials(p_api_version NUMBER
125: , p_init_msg_list VARCHAR2
125: , p_init_msg_list VARCHAR2
126: , p_commit VARCHAR2
127: , p_validation_level NUMBER
128: , p_module_type VARCHAR2
129: , p5_a0 JTF_NUMBER_TABLE
130: , p5_a1 JTF_NUMBER_TABLE
131: , p5_a2 JTF_NUMBER_TABLE
132: , p5_a3 JTF_NUMBER_TABLE
133: , p5_a4 JTF_VARCHAR2_TABLE_100
126: , p_commit VARCHAR2
127: , p_validation_level NUMBER
128: , p_module_type VARCHAR2
129: , p5_a0 JTF_NUMBER_TABLE
130: , p5_a1 JTF_NUMBER_TABLE
131: , p5_a2 JTF_NUMBER_TABLE
132: , p5_a3 JTF_NUMBER_TABLE
133: , p5_a4 JTF_VARCHAR2_TABLE_100
134: , p5_a5 JTF_NUMBER_TABLE
127: , p_validation_level NUMBER
128: , p_module_type VARCHAR2
129: , p5_a0 JTF_NUMBER_TABLE
130: , p5_a1 JTF_NUMBER_TABLE
131: , p5_a2 JTF_NUMBER_TABLE
132: , p5_a3 JTF_NUMBER_TABLE
133: , p5_a4 JTF_VARCHAR2_TABLE_100
134: , p5_a5 JTF_NUMBER_TABLE
135: , p5_a6 JTF_VARCHAR2_TABLE_100
128: , p_module_type VARCHAR2
129: , p5_a0 JTF_NUMBER_TABLE
130: , p5_a1 JTF_NUMBER_TABLE
131: , p5_a2 JTF_NUMBER_TABLE
132: , p5_a3 JTF_NUMBER_TABLE
133: , p5_a4 JTF_VARCHAR2_TABLE_100
134: , p5_a5 JTF_NUMBER_TABLE
135: , p5_a6 JTF_VARCHAR2_TABLE_100
136: , p5_a7 JTF_DATE_TABLE
130: , p5_a1 JTF_NUMBER_TABLE
131: , p5_a2 JTF_NUMBER_TABLE
132: , p5_a3 JTF_NUMBER_TABLE
133: , p5_a4 JTF_VARCHAR2_TABLE_100
134: , p5_a5 JTF_NUMBER_TABLE
135: , p5_a6 JTF_VARCHAR2_TABLE_100
136: , p5_a7 JTF_DATE_TABLE
137: , p5_a8 JTF_NUMBER_TABLE
138: , p5_a9 JTF_NUMBER_TABLE
133: , p5_a4 JTF_VARCHAR2_TABLE_100
134: , p5_a5 JTF_NUMBER_TABLE
135: , p5_a6 JTF_VARCHAR2_TABLE_100
136: , p5_a7 JTF_DATE_TABLE
137: , p5_a8 JTF_NUMBER_TABLE
138: , p5_a9 JTF_NUMBER_TABLE
139: , p5_a10 JTF_NUMBER_TABLE
140: , x_return_status out nocopy VARCHAR2
141: , x_msg_count out nocopy NUMBER
134: , p5_a5 JTF_NUMBER_TABLE
135: , p5_a6 JTF_VARCHAR2_TABLE_100
136: , p5_a7 JTF_DATE_TABLE
137: , p5_a8 JTF_NUMBER_TABLE
138: , p5_a9 JTF_NUMBER_TABLE
139: , p5_a10 JTF_NUMBER_TABLE
140: , x_return_status out nocopy VARCHAR2
141: , x_msg_count out nocopy NUMBER
142: , x_msg_data out nocopy VARCHAR2
135: , p5_a6 JTF_VARCHAR2_TABLE_100
136: , p5_a7 JTF_DATE_TABLE
137: , p5_a8 JTF_NUMBER_TABLE
138: , p5_a9 JTF_NUMBER_TABLE
139: , p5_a10 JTF_NUMBER_TABLE
140: , x_return_status out nocopy VARCHAR2
141: , x_msg_count out nocopy NUMBER
142: , x_msg_data out nocopy VARCHAR2
143: );