DBA Data[Home] [Help]

APPS.AHL_PRD_MRSHL_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_prd_mrshl_pvt.unavailable_items_tbl_type, a0 JTF_NUMBER_TABLE

1: package ahl_prd_mrshl_pvt_w AUTHID CURRENT_USER as
2: /* $Header: AHLWPMLS.pls 120.1.12020000.2 2012/12/14 03:35:37 shnatu ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_prd_mrshl_pvt.unavailable_items_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_NUMBER_TABLE

Line 4: , a1 JTF_NUMBER_TABLE

1: package ahl_prd_mrshl_pvt_w AUTHID CURRENT_USER as
2: /* $Header: AHLWPMLS.pls 120.1.12020000.2 2012/12/14 03:35:37 shnatu ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_prd_mrshl_pvt.unavailable_items_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100

Line 7: , a4 JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p2(t out nocopy ahl_prd_mrshl_pvt.unavailable_items_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE

Line 9: , a6 JTF_NUMBER_TABLE

5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100

Line 10: , a7 JTF_NUMBER_TABLE

6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE

Line 11: , a8 JTF_NUMBER_TABLE

7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE

Line 14: , a11 JTF_NUMBER_TABLE

10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100

Line 15: , a12 JTF_NUMBER_TABLE

11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_DATE_TABLE

Line 16: , a13 JTF_NUMBER_TABLE

12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_NUMBER_TABLE

Line 20: , a17 JTF_NUMBER_TABLE

16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_DATE_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_DATE_TABLE

Line 21: , a18 JTF_NUMBER_TABLE

17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_DATE_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_DATE_TABLE
25: , a22 JTF_NUMBER_TABLE

Line 23: , a20 JTF_NUMBER_TABLE

19: , a16 JTF_DATE_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_DATE_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_DATE_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE

Line 25: , a22 JTF_NUMBER_TABLE

21: , a18 JTF_NUMBER_TABLE
22: , a19 JTF_DATE_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_DATE_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE

Line 26: , a23 JTF_NUMBER_TABLE

22: , a19 JTF_DATE_TABLE
23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_DATE_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_300

Line 27: , a24 JTF_NUMBER_TABLE

23: , a20 JTF_NUMBER_TABLE
24: , a21 JTF_DATE_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_300
31: , a28 JTF_VARCHAR2_TABLE_100

Line 29: , a26 JTF_NUMBER_TABLE

25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_VARCHAR2_TABLE_100
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_300
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100

Line 37: , a34 JTF_NUMBER_TABLE

33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_NUMBER_TABLE
41: );

Line 40: , a37 JTF_NUMBER_TABLE

36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_NUMBER_TABLE
41: );
42: procedure rosetta_table_copy_out_p2(t ahl_prd_mrshl_pvt.unavailable_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_300

Line 42: procedure rosetta_table_copy_out_p2(t ahl_prd_mrshl_pvt.unavailable_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_NUMBER_TABLE
41: );
42: procedure rosetta_table_copy_out_p2(t ahl_prd_mrshl_pvt.unavailable_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_300
45: , a3 out nocopy JTF_VARCHAR2_TABLE_300
46: , a4 out nocopy JTF_NUMBER_TABLE

Line 43: , a1 out nocopy JTF_NUMBER_TABLE

39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_NUMBER_TABLE
41: );
42: procedure rosetta_table_copy_out_p2(t ahl_prd_mrshl_pvt.unavailable_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_300
45: , a3 out nocopy JTF_VARCHAR2_TABLE_300
46: , a4 out nocopy JTF_NUMBER_TABLE
47: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 46: , a4 out nocopy JTF_NUMBER_TABLE

42: procedure rosetta_table_copy_out_p2(t ahl_prd_mrshl_pvt.unavailable_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_300
45: , a3 out nocopy JTF_VARCHAR2_TABLE_300
46: , a4 out nocopy JTF_NUMBER_TABLE
47: , a5 out nocopy JTF_VARCHAR2_TABLE_100
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_NUMBER_TABLE
50: , a8 out nocopy JTF_NUMBER_TABLE

Line 48: , a6 out nocopy JTF_NUMBER_TABLE

44: , a2 out nocopy JTF_VARCHAR2_TABLE_300
45: , a3 out nocopy JTF_VARCHAR2_TABLE_300
46: , a4 out nocopy JTF_NUMBER_TABLE
47: , a5 out nocopy JTF_VARCHAR2_TABLE_100
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_NUMBER_TABLE
50: , a8 out nocopy JTF_NUMBER_TABLE
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 49: , a7 out nocopy JTF_NUMBER_TABLE

45: , a3 out nocopy JTF_VARCHAR2_TABLE_300
46: , a4 out nocopy JTF_NUMBER_TABLE
47: , a5 out nocopy JTF_VARCHAR2_TABLE_100
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_NUMBER_TABLE
50: , a8 out nocopy JTF_NUMBER_TABLE
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: , a11 out nocopy JTF_NUMBER_TABLE

Line 50: , a8 out nocopy JTF_NUMBER_TABLE

46: , a4 out nocopy JTF_NUMBER_TABLE
47: , a5 out nocopy JTF_VARCHAR2_TABLE_100
48: , a6 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_NUMBER_TABLE
50: , a8 out nocopy JTF_NUMBER_TABLE
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: , a11 out nocopy JTF_NUMBER_TABLE
54: , a12 out nocopy JTF_NUMBER_TABLE

Line 53: , a11 out nocopy JTF_NUMBER_TABLE

49: , a7 out nocopy JTF_NUMBER_TABLE
50: , a8 out nocopy JTF_NUMBER_TABLE
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: , a11 out nocopy JTF_NUMBER_TABLE
54: , a12 out nocopy JTF_NUMBER_TABLE
55: , a13 out nocopy JTF_NUMBER_TABLE
56: , a14 out nocopy JTF_VARCHAR2_TABLE_100
57: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 54: , a12 out nocopy JTF_NUMBER_TABLE

50: , a8 out nocopy JTF_NUMBER_TABLE
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: , a11 out nocopy JTF_NUMBER_TABLE
54: , a12 out nocopy JTF_NUMBER_TABLE
55: , a13 out nocopy JTF_NUMBER_TABLE
56: , a14 out nocopy JTF_VARCHAR2_TABLE_100
57: , a15 out nocopy JTF_VARCHAR2_TABLE_100
58: , a16 out nocopy JTF_DATE_TABLE

Line 55: , a13 out nocopy JTF_NUMBER_TABLE

51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: , a11 out nocopy JTF_NUMBER_TABLE
54: , a12 out nocopy JTF_NUMBER_TABLE
55: , a13 out nocopy JTF_NUMBER_TABLE
56: , a14 out nocopy JTF_VARCHAR2_TABLE_100
57: , a15 out nocopy JTF_VARCHAR2_TABLE_100
58: , a16 out nocopy JTF_DATE_TABLE
59: , a17 out nocopy JTF_NUMBER_TABLE

Line 59: , a17 out nocopy JTF_NUMBER_TABLE

55: , a13 out nocopy JTF_NUMBER_TABLE
56: , a14 out nocopy JTF_VARCHAR2_TABLE_100
57: , a15 out nocopy JTF_VARCHAR2_TABLE_100
58: , a16 out nocopy JTF_DATE_TABLE
59: , a17 out nocopy JTF_NUMBER_TABLE
60: , a18 out nocopy JTF_NUMBER_TABLE
61: , a19 out nocopy JTF_DATE_TABLE
62: , a20 out nocopy JTF_NUMBER_TABLE
63: , a21 out nocopy JTF_DATE_TABLE

Line 60: , a18 out nocopy JTF_NUMBER_TABLE

56: , a14 out nocopy JTF_VARCHAR2_TABLE_100
57: , a15 out nocopy JTF_VARCHAR2_TABLE_100
58: , a16 out nocopy JTF_DATE_TABLE
59: , a17 out nocopy JTF_NUMBER_TABLE
60: , a18 out nocopy JTF_NUMBER_TABLE
61: , a19 out nocopy JTF_DATE_TABLE
62: , a20 out nocopy JTF_NUMBER_TABLE
63: , a21 out nocopy JTF_DATE_TABLE
64: , a22 out nocopy JTF_NUMBER_TABLE

Line 62: , a20 out nocopy JTF_NUMBER_TABLE

58: , a16 out nocopy JTF_DATE_TABLE
59: , a17 out nocopy JTF_NUMBER_TABLE
60: , a18 out nocopy JTF_NUMBER_TABLE
61: , a19 out nocopy JTF_DATE_TABLE
62: , a20 out nocopy JTF_NUMBER_TABLE
63: , a21 out nocopy JTF_DATE_TABLE
64: , a22 out nocopy JTF_NUMBER_TABLE
65: , a23 out nocopy JTF_NUMBER_TABLE
66: , a24 out nocopy JTF_NUMBER_TABLE

Line 64: , a22 out nocopy JTF_NUMBER_TABLE

60: , a18 out nocopy JTF_NUMBER_TABLE
61: , a19 out nocopy JTF_DATE_TABLE
62: , a20 out nocopy JTF_NUMBER_TABLE
63: , a21 out nocopy JTF_DATE_TABLE
64: , a22 out nocopy JTF_NUMBER_TABLE
65: , a23 out nocopy JTF_NUMBER_TABLE
66: , a24 out nocopy JTF_NUMBER_TABLE
67: , a25 out nocopy JTF_VARCHAR2_TABLE_100
68: , a26 out nocopy JTF_NUMBER_TABLE

Line 65: , a23 out nocopy JTF_NUMBER_TABLE

61: , a19 out nocopy JTF_DATE_TABLE
62: , a20 out nocopy JTF_NUMBER_TABLE
63: , a21 out nocopy JTF_DATE_TABLE
64: , a22 out nocopy JTF_NUMBER_TABLE
65: , a23 out nocopy JTF_NUMBER_TABLE
66: , a24 out nocopy JTF_NUMBER_TABLE
67: , a25 out nocopy JTF_VARCHAR2_TABLE_100
68: , a26 out nocopy JTF_NUMBER_TABLE
69: , a27 out nocopy JTF_VARCHAR2_TABLE_300

Line 66: , a24 out nocopy JTF_NUMBER_TABLE

62: , a20 out nocopy JTF_NUMBER_TABLE
63: , a21 out nocopy JTF_DATE_TABLE
64: , a22 out nocopy JTF_NUMBER_TABLE
65: , a23 out nocopy JTF_NUMBER_TABLE
66: , a24 out nocopy JTF_NUMBER_TABLE
67: , a25 out nocopy JTF_VARCHAR2_TABLE_100
68: , a26 out nocopy JTF_NUMBER_TABLE
69: , a27 out nocopy JTF_VARCHAR2_TABLE_300
70: , a28 out nocopy JTF_VARCHAR2_TABLE_100

Line 68: , a26 out nocopy JTF_NUMBER_TABLE

64: , a22 out nocopy JTF_NUMBER_TABLE
65: , a23 out nocopy JTF_NUMBER_TABLE
66: , a24 out nocopy JTF_NUMBER_TABLE
67: , a25 out nocopy JTF_VARCHAR2_TABLE_100
68: , a26 out nocopy JTF_NUMBER_TABLE
69: , a27 out nocopy JTF_VARCHAR2_TABLE_300
70: , a28 out nocopy JTF_VARCHAR2_TABLE_100
71: , a29 out nocopy JTF_VARCHAR2_TABLE_100
72: , a30 out nocopy JTF_VARCHAR2_TABLE_100

Line 76: , a34 out nocopy JTF_NUMBER_TABLE

72: , a30 out nocopy JTF_VARCHAR2_TABLE_100
73: , a31 out nocopy JTF_VARCHAR2_TABLE_100
74: , a32 out nocopy JTF_VARCHAR2_TABLE_100
75: , a33 out nocopy JTF_VARCHAR2_TABLE_100
76: , a34 out nocopy JTF_NUMBER_TABLE
77: , a35 out nocopy JTF_VARCHAR2_TABLE_100
78: , a36 out nocopy JTF_VARCHAR2_TABLE_100
79: , a37 out nocopy JTF_NUMBER_TABLE
80: );

Line 79: , a37 out nocopy JTF_NUMBER_TABLE

75: , a33 out nocopy JTF_VARCHAR2_TABLE_100
76: , a34 out nocopy JTF_NUMBER_TABLE
77: , a35 out nocopy JTF_VARCHAR2_TABLE_100
78: , a36 out nocopy JTF_VARCHAR2_TABLE_100
79: , a37 out nocopy JTF_NUMBER_TABLE
80: );
81:
82: procedure rosetta_table_copy_in_p4(t out nocopy ahl_prd_mrshl_pvt.available_items_tbl_type, a0 JTF_NUMBER_TABLE
83: , a1 JTF_NUMBER_TABLE

Line 82: procedure rosetta_table_copy_in_p4(t out nocopy ahl_prd_mrshl_pvt.available_items_tbl_type, a0 JTF_NUMBER_TABLE

78: , a36 out nocopy JTF_VARCHAR2_TABLE_100
79: , a37 out nocopy JTF_NUMBER_TABLE
80: );
81:
82: procedure rosetta_table_copy_in_p4(t out nocopy ahl_prd_mrshl_pvt.available_items_tbl_type, a0 JTF_NUMBER_TABLE
83: , a1 JTF_NUMBER_TABLE
84: , a2 JTF_VARCHAR2_TABLE_300
85: , a3 JTF_VARCHAR2_TABLE_300
86: , a4 JTF_NUMBER_TABLE

Line 83: , a1 JTF_NUMBER_TABLE

79: , a37 out nocopy JTF_NUMBER_TABLE
80: );
81:
82: procedure rosetta_table_copy_in_p4(t out nocopy ahl_prd_mrshl_pvt.available_items_tbl_type, a0 JTF_NUMBER_TABLE
83: , a1 JTF_NUMBER_TABLE
84: , a2 JTF_VARCHAR2_TABLE_300
85: , a3 JTF_VARCHAR2_TABLE_300
86: , a4 JTF_NUMBER_TABLE
87: , a5 JTF_VARCHAR2_TABLE_100

Line 86: , a4 JTF_NUMBER_TABLE

82: procedure rosetta_table_copy_in_p4(t out nocopy ahl_prd_mrshl_pvt.available_items_tbl_type, a0 JTF_NUMBER_TABLE
83: , a1 JTF_NUMBER_TABLE
84: , a2 JTF_VARCHAR2_TABLE_300
85: , a3 JTF_VARCHAR2_TABLE_300
86: , a4 JTF_NUMBER_TABLE
87: , a5 JTF_VARCHAR2_TABLE_100
88: , a6 JTF_NUMBER_TABLE
89: , a7 JTF_NUMBER_TABLE
90: , a8 JTF_NUMBER_TABLE

Line 88: , a6 JTF_NUMBER_TABLE

84: , a2 JTF_VARCHAR2_TABLE_300
85: , a3 JTF_VARCHAR2_TABLE_300
86: , a4 JTF_NUMBER_TABLE
87: , a5 JTF_VARCHAR2_TABLE_100
88: , a6 JTF_NUMBER_TABLE
89: , a7 JTF_NUMBER_TABLE
90: , a8 JTF_NUMBER_TABLE
91: , a9 JTF_VARCHAR2_TABLE_100
92: , a10 JTF_VARCHAR2_TABLE_100

Line 89: , a7 JTF_NUMBER_TABLE

85: , a3 JTF_VARCHAR2_TABLE_300
86: , a4 JTF_NUMBER_TABLE
87: , a5 JTF_VARCHAR2_TABLE_100
88: , a6 JTF_NUMBER_TABLE
89: , a7 JTF_NUMBER_TABLE
90: , a8 JTF_NUMBER_TABLE
91: , a9 JTF_VARCHAR2_TABLE_100
92: , a10 JTF_VARCHAR2_TABLE_100
93: , a11 JTF_NUMBER_TABLE

Line 90: , a8 JTF_NUMBER_TABLE

86: , a4 JTF_NUMBER_TABLE
87: , a5 JTF_VARCHAR2_TABLE_100
88: , a6 JTF_NUMBER_TABLE
89: , a7 JTF_NUMBER_TABLE
90: , a8 JTF_NUMBER_TABLE
91: , a9 JTF_VARCHAR2_TABLE_100
92: , a10 JTF_VARCHAR2_TABLE_100
93: , a11 JTF_NUMBER_TABLE
94: , a12 JTF_NUMBER_TABLE

Line 93: , a11 JTF_NUMBER_TABLE

89: , a7 JTF_NUMBER_TABLE
90: , a8 JTF_NUMBER_TABLE
91: , a9 JTF_VARCHAR2_TABLE_100
92: , a10 JTF_VARCHAR2_TABLE_100
93: , a11 JTF_NUMBER_TABLE
94: , a12 JTF_NUMBER_TABLE
95: , a13 JTF_NUMBER_TABLE
96: , a14 JTF_VARCHAR2_TABLE_100
97: , a15 JTF_VARCHAR2_TABLE_100

Line 94: , a12 JTF_NUMBER_TABLE

90: , a8 JTF_NUMBER_TABLE
91: , a9 JTF_VARCHAR2_TABLE_100
92: , a10 JTF_VARCHAR2_TABLE_100
93: , a11 JTF_NUMBER_TABLE
94: , a12 JTF_NUMBER_TABLE
95: , a13 JTF_NUMBER_TABLE
96: , a14 JTF_VARCHAR2_TABLE_100
97: , a15 JTF_VARCHAR2_TABLE_100
98: , a16 JTF_DATE_TABLE

Line 95: , a13 JTF_NUMBER_TABLE

91: , a9 JTF_VARCHAR2_TABLE_100
92: , a10 JTF_VARCHAR2_TABLE_100
93: , a11 JTF_NUMBER_TABLE
94: , a12 JTF_NUMBER_TABLE
95: , a13 JTF_NUMBER_TABLE
96: , a14 JTF_VARCHAR2_TABLE_100
97: , a15 JTF_VARCHAR2_TABLE_100
98: , a16 JTF_DATE_TABLE
99: , a17 JTF_NUMBER_TABLE

Line 99: , a17 JTF_NUMBER_TABLE

95: , a13 JTF_NUMBER_TABLE
96: , a14 JTF_VARCHAR2_TABLE_100
97: , a15 JTF_VARCHAR2_TABLE_100
98: , a16 JTF_DATE_TABLE
99: , a17 JTF_NUMBER_TABLE
100: , a18 JTF_DATE_TABLE
101: , a19 JTF_NUMBER_TABLE
102: , a20 JTF_NUMBER_TABLE
103: , a21 JTF_DATE_TABLE

Line 101: , a19 JTF_NUMBER_TABLE

97: , a15 JTF_VARCHAR2_TABLE_100
98: , a16 JTF_DATE_TABLE
99: , a17 JTF_NUMBER_TABLE
100: , a18 JTF_DATE_TABLE
101: , a19 JTF_NUMBER_TABLE
102: , a20 JTF_NUMBER_TABLE
103: , a21 JTF_DATE_TABLE
104: , a22 JTF_NUMBER_TABLE
105: , a23 JTF_NUMBER_TABLE

Line 102: , a20 JTF_NUMBER_TABLE

98: , a16 JTF_DATE_TABLE
99: , a17 JTF_NUMBER_TABLE
100: , a18 JTF_DATE_TABLE
101: , a19 JTF_NUMBER_TABLE
102: , a20 JTF_NUMBER_TABLE
103: , a21 JTF_DATE_TABLE
104: , a22 JTF_NUMBER_TABLE
105: , a23 JTF_NUMBER_TABLE
106: , a24 JTF_NUMBER_TABLE

Line 104: , a22 JTF_NUMBER_TABLE

100: , a18 JTF_DATE_TABLE
101: , a19 JTF_NUMBER_TABLE
102: , a20 JTF_NUMBER_TABLE
103: , a21 JTF_DATE_TABLE
104: , a22 JTF_NUMBER_TABLE
105: , a23 JTF_NUMBER_TABLE
106: , a24 JTF_NUMBER_TABLE
107: , a25 JTF_VARCHAR2_TABLE_100
108: , a26 JTF_NUMBER_TABLE

Line 105: , a23 JTF_NUMBER_TABLE

101: , a19 JTF_NUMBER_TABLE
102: , a20 JTF_NUMBER_TABLE
103: , a21 JTF_DATE_TABLE
104: , a22 JTF_NUMBER_TABLE
105: , a23 JTF_NUMBER_TABLE
106: , a24 JTF_NUMBER_TABLE
107: , a25 JTF_VARCHAR2_TABLE_100
108: , a26 JTF_NUMBER_TABLE
109: , a27 JTF_VARCHAR2_TABLE_300

Line 106: , a24 JTF_NUMBER_TABLE

102: , a20 JTF_NUMBER_TABLE
103: , a21 JTF_DATE_TABLE
104: , a22 JTF_NUMBER_TABLE
105: , a23 JTF_NUMBER_TABLE
106: , a24 JTF_NUMBER_TABLE
107: , a25 JTF_VARCHAR2_TABLE_100
108: , a26 JTF_NUMBER_TABLE
109: , a27 JTF_VARCHAR2_TABLE_300
110: , a28 JTF_VARCHAR2_TABLE_100

Line 108: , a26 JTF_NUMBER_TABLE

104: , a22 JTF_NUMBER_TABLE
105: , a23 JTF_NUMBER_TABLE
106: , a24 JTF_NUMBER_TABLE
107: , a25 JTF_VARCHAR2_TABLE_100
108: , a26 JTF_NUMBER_TABLE
109: , a27 JTF_VARCHAR2_TABLE_300
110: , a28 JTF_VARCHAR2_TABLE_100
111: , a29 JTF_VARCHAR2_TABLE_100
112: , a30 JTF_VARCHAR2_TABLE_100

Line 113: , a31 JTF_NUMBER_TABLE

109: , a27 JTF_VARCHAR2_TABLE_300
110: , a28 JTF_VARCHAR2_TABLE_100
111: , a29 JTF_VARCHAR2_TABLE_100
112: , a30 JTF_VARCHAR2_TABLE_100
113: , a31 JTF_NUMBER_TABLE
114: , a32 JTF_VARCHAR2_TABLE_100
115: , a33 JTF_NUMBER_TABLE
116: , a34 JTF_NUMBER_TABLE
117: , a35 JTF_VARCHAR2_TABLE_100

Line 115: , a33 JTF_NUMBER_TABLE

111: , a29 JTF_VARCHAR2_TABLE_100
112: , a30 JTF_VARCHAR2_TABLE_100
113: , a31 JTF_NUMBER_TABLE
114: , a32 JTF_VARCHAR2_TABLE_100
115: , a33 JTF_NUMBER_TABLE
116: , a34 JTF_NUMBER_TABLE
117: , a35 JTF_VARCHAR2_TABLE_100
118: , a36 JTF_VARCHAR2_TABLE_100
119: , a37 JTF_VARCHAR2_TABLE_100

Line 116: , a34 JTF_NUMBER_TABLE

112: , a30 JTF_VARCHAR2_TABLE_100
113: , a31 JTF_NUMBER_TABLE
114: , a32 JTF_VARCHAR2_TABLE_100
115: , a33 JTF_NUMBER_TABLE
116: , a34 JTF_NUMBER_TABLE
117: , a35 JTF_VARCHAR2_TABLE_100
118: , a36 JTF_VARCHAR2_TABLE_100
119: , a37 JTF_VARCHAR2_TABLE_100
120: , a38 JTF_NUMBER_TABLE

Line 120: , a38 JTF_NUMBER_TABLE

116: , a34 JTF_NUMBER_TABLE
117: , a35 JTF_VARCHAR2_TABLE_100
118: , a36 JTF_VARCHAR2_TABLE_100
119: , a37 JTF_VARCHAR2_TABLE_100
120: , a38 JTF_NUMBER_TABLE
121: , a39 JTF_VARCHAR2_TABLE_100
122: , a40 JTF_VARCHAR2_TABLE_100
123: , a41 JTF_NUMBER_TABLE
124: );

Line 123: , a41 JTF_NUMBER_TABLE

119: , a37 JTF_VARCHAR2_TABLE_100
120: , a38 JTF_NUMBER_TABLE
121: , a39 JTF_VARCHAR2_TABLE_100
122: , a40 JTF_VARCHAR2_TABLE_100
123: , a41 JTF_NUMBER_TABLE
124: );
125: procedure rosetta_table_copy_out_p4(t ahl_prd_mrshl_pvt.available_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
126: , a1 out nocopy JTF_NUMBER_TABLE
127: , a2 out nocopy JTF_VARCHAR2_TABLE_300

Line 125: procedure rosetta_table_copy_out_p4(t ahl_prd_mrshl_pvt.available_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

121: , a39 JTF_VARCHAR2_TABLE_100
122: , a40 JTF_VARCHAR2_TABLE_100
123: , a41 JTF_NUMBER_TABLE
124: );
125: procedure rosetta_table_copy_out_p4(t ahl_prd_mrshl_pvt.available_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
126: , a1 out nocopy JTF_NUMBER_TABLE
127: , a2 out nocopy JTF_VARCHAR2_TABLE_300
128: , a3 out nocopy JTF_VARCHAR2_TABLE_300
129: , a4 out nocopy JTF_NUMBER_TABLE

Line 126: , a1 out nocopy JTF_NUMBER_TABLE

122: , a40 JTF_VARCHAR2_TABLE_100
123: , a41 JTF_NUMBER_TABLE
124: );
125: procedure rosetta_table_copy_out_p4(t ahl_prd_mrshl_pvt.available_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
126: , a1 out nocopy JTF_NUMBER_TABLE
127: , a2 out nocopy JTF_VARCHAR2_TABLE_300
128: , a3 out nocopy JTF_VARCHAR2_TABLE_300
129: , a4 out nocopy JTF_NUMBER_TABLE
130: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 129: , a4 out nocopy JTF_NUMBER_TABLE

125: procedure rosetta_table_copy_out_p4(t ahl_prd_mrshl_pvt.available_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
126: , a1 out nocopy JTF_NUMBER_TABLE
127: , a2 out nocopy JTF_VARCHAR2_TABLE_300
128: , a3 out nocopy JTF_VARCHAR2_TABLE_300
129: , a4 out nocopy JTF_NUMBER_TABLE
130: , a5 out nocopy JTF_VARCHAR2_TABLE_100
131: , a6 out nocopy JTF_NUMBER_TABLE
132: , a7 out nocopy JTF_NUMBER_TABLE
133: , a8 out nocopy JTF_NUMBER_TABLE

Line 131: , a6 out nocopy JTF_NUMBER_TABLE

127: , a2 out nocopy JTF_VARCHAR2_TABLE_300
128: , a3 out nocopy JTF_VARCHAR2_TABLE_300
129: , a4 out nocopy JTF_NUMBER_TABLE
130: , a5 out nocopy JTF_VARCHAR2_TABLE_100
131: , a6 out nocopy JTF_NUMBER_TABLE
132: , a7 out nocopy JTF_NUMBER_TABLE
133: , a8 out nocopy JTF_NUMBER_TABLE
134: , a9 out nocopy JTF_VARCHAR2_TABLE_100
135: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 132: , a7 out nocopy JTF_NUMBER_TABLE

128: , a3 out nocopy JTF_VARCHAR2_TABLE_300
129: , a4 out nocopy JTF_NUMBER_TABLE
130: , a5 out nocopy JTF_VARCHAR2_TABLE_100
131: , a6 out nocopy JTF_NUMBER_TABLE
132: , a7 out nocopy JTF_NUMBER_TABLE
133: , a8 out nocopy JTF_NUMBER_TABLE
134: , a9 out nocopy JTF_VARCHAR2_TABLE_100
135: , a10 out nocopy JTF_VARCHAR2_TABLE_100
136: , a11 out nocopy JTF_NUMBER_TABLE

Line 133: , a8 out nocopy JTF_NUMBER_TABLE

129: , a4 out nocopy JTF_NUMBER_TABLE
130: , a5 out nocopy JTF_VARCHAR2_TABLE_100
131: , a6 out nocopy JTF_NUMBER_TABLE
132: , a7 out nocopy JTF_NUMBER_TABLE
133: , a8 out nocopy JTF_NUMBER_TABLE
134: , a9 out nocopy JTF_VARCHAR2_TABLE_100
135: , a10 out nocopy JTF_VARCHAR2_TABLE_100
136: , a11 out nocopy JTF_NUMBER_TABLE
137: , a12 out nocopy JTF_NUMBER_TABLE

Line 136: , a11 out nocopy JTF_NUMBER_TABLE

132: , a7 out nocopy JTF_NUMBER_TABLE
133: , a8 out nocopy JTF_NUMBER_TABLE
134: , a9 out nocopy JTF_VARCHAR2_TABLE_100
135: , a10 out nocopy JTF_VARCHAR2_TABLE_100
136: , a11 out nocopy JTF_NUMBER_TABLE
137: , a12 out nocopy JTF_NUMBER_TABLE
138: , a13 out nocopy JTF_NUMBER_TABLE
139: , a14 out nocopy JTF_VARCHAR2_TABLE_100
140: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 137: , a12 out nocopy JTF_NUMBER_TABLE

133: , a8 out nocopy JTF_NUMBER_TABLE
134: , a9 out nocopy JTF_VARCHAR2_TABLE_100
135: , a10 out nocopy JTF_VARCHAR2_TABLE_100
136: , a11 out nocopy JTF_NUMBER_TABLE
137: , a12 out nocopy JTF_NUMBER_TABLE
138: , a13 out nocopy JTF_NUMBER_TABLE
139: , a14 out nocopy JTF_VARCHAR2_TABLE_100
140: , a15 out nocopy JTF_VARCHAR2_TABLE_100
141: , a16 out nocopy JTF_DATE_TABLE

Line 138: , a13 out nocopy JTF_NUMBER_TABLE

134: , a9 out nocopy JTF_VARCHAR2_TABLE_100
135: , a10 out nocopy JTF_VARCHAR2_TABLE_100
136: , a11 out nocopy JTF_NUMBER_TABLE
137: , a12 out nocopy JTF_NUMBER_TABLE
138: , a13 out nocopy JTF_NUMBER_TABLE
139: , a14 out nocopy JTF_VARCHAR2_TABLE_100
140: , a15 out nocopy JTF_VARCHAR2_TABLE_100
141: , a16 out nocopy JTF_DATE_TABLE
142: , a17 out nocopy JTF_NUMBER_TABLE

Line 142: , a17 out nocopy JTF_NUMBER_TABLE

138: , a13 out nocopy JTF_NUMBER_TABLE
139: , a14 out nocopy JTF_VARCHAR2_TABLE_100
140: , a15 out nocopy JTF_VARCHAR2_TABLE_100
141: , a16 out nocopy JTF_DATE_TABLE
142: , a17 out nocopy JTF_NUMBER_TABLE
143: , a18 out nocopy JTF_DATE_TABLE
144: , a19 out nocopy JTF_NUMBER_TABLE
145: , a20 out nocopy JTF_NUMBER_TABLE
146: , a21 out nocopy JTF_DATE_TABLE

Line 144: , a19 out nocopy JTF_NUMBER_TABLE

140: , a15 out nocopy JTF_VARCHAR2_TABLE_100
141: , a16 out nocopy JTF_DATE_TABLE
142: , a17 out nocopy JTF_NUMBER_TABLE
143: , a18 out nocopy JTF_DATE_TABLE
144: , a19 out nocopy JTF_NUMBER_TABLE
145: , a20 out nocopy JTF_NUMBER_TABLE
146: , a21 out nocopy JTF_DATE_TABLE
147: , a22 out nocopy JTF_NUMBER_TABLE
148: , a23 out nocopy JTF_NUMBER_TABLE

Line 145: , a20 out nocopy JTF_NUMBER_TABLE

141: , a16 out nocopy JTF_DATE_TABLE
142: , a17 out nocopy JTF_NUMBER_TABLE
143: , a18 out nocopy JTF_DATE_TABLE
144: , a19 out nocopy JTF_NUMBER_TABLE
145: , a20 out nocopy JTF_NUMBER_TABLE
146: , a21 out nocopy JTF_DATE_TABLE
147: , a22 out nocopy JTF_NUMBER_TABLE
148: , a23 out nocopy JTF_NUMBER_TABLE
149: , a24 out nocopy JTF_NUMBER_TABLE

Line 147: , a22 out nocopy JTF_NUMBER_TABLE

143: , a18 out nocopy JTF_DATE_TABLE
144: , a19 out nocopy JTF_NUMBER_TABLE
145: , a20 out nocopy JTF_NUMBER_TABLE
146: , a21 out nocopy JTF_DATE_TABLE
147: , a22 out nocopy JTF_NUMBER_TABLE
148: , a23 out nocopy JTF_NUMBER_TABLE
149: , a24 out nocopy JTF_NUMBER_TABLE
150: , a25 out nocopy JTF_VARCHAR2_TABLE_100
151: , a26 out nocopy JTF_NUMBER_TABLE

Line 148: , a23 out nocopy JTF_NUMBER_TABLE

144: , a19 out nocopy JTF_NUMBER_TABLE
145: , a20 out nocopy JTF_NUMBER_TABLE
146: , a21 out nocopy JTF_DATE_TABLE
147: , a22 out nocopy JTF_NUMBER_TABLE
148: , a23 out nocopy JTF_NUMBER_TABLE
149: , a24 out nocopy JTF_NUMBER_TABLE
150: , a25 out nocopy JTF_VARCHAR2_TABLE_100
151: , a26 out nocopy JTF_NUMBER_TABLE
152: , a27 out nocopy JTF_VARCHAR2_TABLE_300

Line 149: , a24 out nocopy JTF_NUMBER_TABLE

145: , a20 out nocopy JTF_NUMBER_TABLE
146: , a21 out nocopy JTF_DATE_TABLE
147: , a22 out nocopy JTF_NUMBER_TABLE
148: , a23 out nocopy JTF_NUMBER_TABLE
149: , a24 out nocopy JTF_NUMBER_TABLE
150: , a25 out nocopy JTF_VARCHAR2_TABLE_100
151: , a26 out nocopy JTF_NUMBER_TABLE
152: , a27 out nocopy JTF_VARCHAR2_TABLE_300
153: , a28 out nocopy JTF_VARCHAR2_TABLE_100

Line 151: , a26 out nocopy JTF_NUMBER_TABLE

147: , a22 out nocopy JTF_NUMBER_TABLE
148: , a23 out nocopy JTF_NUMBER_TABLE
149: , a24 out nocopy JTF_NUMBER_TABLE
150: , a25 out nocopy JTF_VARCHAR2_TABLE_100
151: , a26 out nocopy JTF_NUMBER_TABLE
152: , a27 out nocopy JTF_VARCHAR2_TABLE_300
153: , a28 out nocopy JTF_VARCHAR2_TABLE_100
154: , a29 out nocopy JTF_VARCHAR2_TABLE_100
155: , a30 out nocopy JTF_VARCHAR2_TABLE_100

Line 156: , a31 out nocopy JTF_NUMBER_TABLE

152: , a27 out nocopy JTF_VARCHAR2_TABLE_300
153: , a28 out nocopy JTF_VARCHAR2_TABLE_100
154: , a29 out nocopy JTF_VARCHAR2_TABLE_100
155: , a30 out nocopy JTF_VARCHAR2_TABLE_100
156: , a31 out nocopy JTF_NUMBER_TABLE
157: , a32 out nocopy JTF_VARCHAR2_TABLE_100
158: , a33 out nocopy JTF_NUMBER_TABLE
159: , a34 out nocopy JTF_NUMBER_TABLE
160: , a35 out nocopy JTF_VARCHAR2_TABLE_100

Line 158: , a33 out nocopy JTF_NUMBER_TABLE

154: , a29 out nocopy JTF_VARCHAR2_TABLE_100
155: , a30 out nocopy JTF_VARCHAR2_TABLE_100
156: , a31 out nocopy JTF_NUMBER_TABLE
157: , a32 out nocopy JTF_VARCHAR2_TABLE_100
158: , a33 out nocopy JTF_NUMBER_TABLE
159: , a34 out nocopy JTF_NUMBER_TABLE
160: , a35 out nocopy JTF_VARCHAR2_TABLE_100
161: , a36 out nocopy JTF_VARCHAR2_TABLE_100
162: , a37 out nocopy JTF_VARCHAR2_TABLE_100

Line 159: , a34 out nocopy JTF_NUMBER_TABLE

155: , a30 out nocopy JTF_VARCHAR2_TABLE_100
156: , a31 out nocopy JTF_NUMBER_TABLE
157: , a32 out nocopy JTF_VARCHAR2_TABLE_100
158: , a33 out nocopy JTF_NUMBER_TABLE
159: , a34 out nocopy JTF_NUMBER_TABLE
160: , a35 out nocopy JTF_VARCHAR2_TABLE_100
161: , a36 out nocopy JTF_VARCHAR2_TABLE_100
162: , a37 out nocopy JTF_VARCHAR2_TABLE_100
163: , a38 out nocopy JTF_NUMBER_TABLE

Line 163: , a38 out nocopy JTF_NUMBER_TABLE

159: , a34 out nocopy JTF_NUMBER_TABLE
160: , a35 out nocopy JTF_VARCHAR2_TABLE_100
161: , a36 out nocopy JTF_VARCHAR2_TABLE_100
162: , a37 out nocopy JTF_VARCHAR2_TABLE_100
163: , a38 out nocopy JTF_NUMBER_TABLE
164: , a39 out nocopy JTF_VARCHAR2_TABLE_100
165: , a40 out nocopy JTF_VARCHAR2_TABLE_100
166: , a41 out nocopy JTF_NUMBER_TABLE
167: );

Line 166: , a41 out nocopy JTF_NUMBER_TABLE

162: , a37 out nocopy JTF_VARCHAR2_TABLE_100
163: , a38 out nocopy JTF_NUMBER_TABLE
164: , a39 out nocopy JTF_VARCHAR2_TABLE_100
165: , a40 out nocopy JTF_VARCHAR2_TABLE_100
166: , a41 out nocopy JTF_NUMBER_TABLE
167: );
168:
169: procedure rosetta_table_copy_in_p6(t out nocopy ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 JTF_NUMBER_TABLE
170: , a1 JTF_VARCHAR2_TABLE_100

Line 169: procedure rosetta_table_copy_in_p6(t out nocopy ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 JTF_NUMBER_TABLE

165: , a40 out nocopy JTF_VARCHAR2_TABLE_100
166: , a41 out nocopy JTF_NUMBER_TABLE
167: );
168:
169: procedure rosetta_table_copy_in_p6(t out nocopy ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 JTF_NUMBER_TABLE
170: , a1 JTF_VARCHAR2_TABLE_100
171: , a2 JTF_NUMBER_TABLE
172: , a3 JTF_NUMBER_TABLE
173: , a4 JTF_NUMBER_TABLE

Line 171: , a2 JTF_NUMBER_TABLE

167: );
168:
169: procedure rosetta_table_copy_in_p6(t out nocopy ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 JTF_NUMBER_TABLE
170: , a1 JTF_VARCHAR2_TABLE_100
171: , a2 JTF_NUMBER_TABLE
172: , a3 JTF_NUMBER_TABLE
173: , a4 JTF_NUMBER_TABLE
174: , a5 JTF_VARCHAR2_TABLE_300
175: , a6 JTF_VARCHAR2_TABLE_100

Line 172: , a3 JTF_NUMBER_TABLE

168:
169: procedure rosetta_table_copy_in_p6(t out nocopy ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 JTF_NUMBER_TABLE
170: , a1 JTF_VARCHAR2_TABLE_100
171: , a2 JTF_NUMBER_TABLE
172: , a3 JTF_NUMBER_TABLE
173: , a4 JTF_NUMBER_TABLE
174: , a5 JTF_VARCHAR2_TABLE_300
175: , a6 JTF_VARCHAR2_TABLE_100
176: , a7 JTF_NUMBER_TABLE

Line 173: , a4 JTF_NUMBER_TABLE

169: procedure rosetta_table_copy_in_p6(t out nocopy ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 JTF_NUMBER_TABLE
170: , a1 JTF_VARCHAR2_TABLE_100
171: , a2 JTF_NUMBER_TABLE
172: , a3 JTF_NUMBER_TABLE
173: , a4 JTF_NUMBER_TABLE
174: , a5 JTF_VARCHAR2_TABLE_300
175: , a6 JTF_VARCHAR2_TABLE_100
176: , a7 JTF_NUMBER_TABLE
177: , a8 JTF_NUMBER_TABLE

Line 176: , a7 JTF_NUMBER_TABLE

172: , a3 JTF_NUMBER_TABLE
173: , a4 JTF_NUMBER_TABLE
174: , a5 JTF_VARCHAR2_TABLE_300
175: , a6 JTF_VARCHAR2_TABLE_100
176: , a7 JTF_NUMBER_TABLE
177: , a8 JTF_NUMBER_TABLE
178: , a9 JTF_NUMBER_TABLE
179: , a10 JTF_NUMBER_TABLE
180: , a11 JTF_VARCHAR2_TABLE_300

Line 177: , a8 JTF_NUMBER_TABLE

173: , a4 JTF_NUMBER_TABLE
174: , a5 JTF_VARCHAR2_TABLE_300
175: , a6 JTF_VARCHAR2_TABLE_100
176: , a7 JTF_NUMBER_TABLE
177: , a8 JTF_NUMBER_TABLE
178: , a9 JTF_NUMBER_TABLE
179: , a10 JTF_NUMBER_TABLE
180: , a11 JTF_VARCHAR2_TABLE_300
181: , a12 JTF_VARCHAR2_TABLE_100

Line 178: , a9 JTF_NUMBER_TABLE

174: , a5 JTF_VARCHAR2_TABLE_300
175: , a6 JTF_VARCHAR2_TABLE_100
176: , a7 JTF_NUMBER_TABLE
177: , a8 JTF_NUMBER_TABLE
178: , a9 JTF_NUMBER_TABLE
179: , a10 JTF_NUMBER_TABLE
180: , a11 JTF_VARCHAR2_TABLE_300
181: , a12 JTF_VARCHAR2_TABLE_100
182: , a13 JTF_NUMBER_TABLE

Line 179: , a10 JTF_NUMBER_TABLE

175: , a6 JTF_VARCHAR2_TABLE_100
176: , a7 JTF_NUMBER_TABLE
177: , a8 JTF_NUMBER_TABLE
178: , a9 JTF_NUMBER_TABLE
179: , a10 JTF_NUMBER_TABLE
180: , a11 JTF_VARCHAR2_TABLE_300
181: , a12 JTF_VARCHAR2_TABLE_100
182: , a13 JTF_NUMBER_TABLE
183: , a14 JTF_NUMBER_TABLE

Line 182: , a13 JTF_NUMBER_TABLE

178: , a9 JTF_NUMBER_TABLE
179: , a10 JTF_NUMBER_TABLE
180: , a11 JTF_VARCHAR2_TABLE_300
181: , a12 JTF_VARCHAR2_TABLE_100
182: , a13 JTF_NUMBER_TABLE
183: , a14 JTF_NUMBER_TABLE
184: , a15 JTF_NUMBER_TABLE
185: , a16 JTF_NUMBER_TABLE
186: , a17 JTF_NUMBER_TABLE

Line 183: , a14 JTF_NUMBER_TABLE

179: , a10 JTF_NUMBER_TABLE
180: , a11 JTF_VARCHAR2_TABLE_300
181: , a12 JTF_VARCHAR2_TABLE_100
182: , a13 JTF_NUMBER_TABLE
183: , a14 JTF_NUMBER_TABLE
184: , a15 JTF_NUMBER_TABLE
185: , a16 JTF_NUMBER_TABLE
186: , a17 JTF_NUMBER_TABLE
187: , a18 JTF_NUMBER_TABLE

Line 184: , a15 JTF_NUMBER_TABLE

180: , a11 JTF_VARCHAR2_TABLE_300
181: , a12 JTF_VARCHAR2_TABLE_100
182: , a13 JTF_NUMBER_TABLE
183: , a14 JTF_NUMBER_TABLE
184: , a15 JTF_NUMBER_TABLE
185: , a16 JTF_NUMBER_TABLE
186: , a17 JTF_NUMBER_TABLE
187: , a18 JTF_NUMBER_TABLE
188: , a19 JTF_NUMBER_TABLE

Line 185: , a16 JTF_NUMBER_TABLE

181: , a12 JTF_VARCHAR2_TABLE_100
182: , a13 JTF_NUMBER_TABLE
183: , a14 JTF_NUMBER_TABLE
184: , a15 JTF_NUMBER_TABLE
185: , a16 JTF_NUMBER_TABLE
186: , a17 JTF_NUMBER_TABLE
187: , a18 JTF_NUMBER_TABLE
188: , a19 JTF_NUMBER_TABLE
189: , a20 JTF_NUMBER_TABLE

Line 186: , a17 JTF_NUMBER_TABLE

182: , a13 JTF_NUMBER_TABLE
183: , a14 JTF_NUMBER_TABLE
184: , a15 JTF_NUMBER_TABLE
185: , a16 JTF_NUMBER_TABLE
186: , a17 JTF_NUMBER_TABLE
187: , a18 JTF_NUMBER_TABLE
188: , a19 JTF_NUMBER_TABLE
189: , a20 JTF_NUMBER_TABLE
190: , a21 JTF_NUMBER_TABLE

Line 187: , a18 JTF_NUMBER_TABLE

183: , a14 JTF_NUMBER_TABLE
184: , a15 JTF_NUMBER_TABLE
185: , a16 JTF_NUMBER_TABLE
186: , a17 JTF_NUMBER_TABLE
187: , a18 JTF_NUMBER_TABLE
188: , a19 JTF_NUMBER_TABLE
189: , a20 JTF_NUMBER_TABLE
190: , a21 JTF_NUMBER_TABLE
191: , a22 JTF_NUMBER_TABLE

Line 188: , a19 JTF_NUMBER_TABLE

184: , a15 JTF_NUMBER_TABLE
185: , a16 JTF_NUMBER_TABLE
186: , a17 JTF_NUMBER_TABLE
187: , a18 JTF_NUMBER_TABLE
188: , a19 JTF_NUMBER_TABLE
189: , a20 JTF_NUMBER_TABLE
190: , a21 JTF_NUMBER_TABLE
191: , a22 JTF_NUMBER_TABLE
192: , a23 JTF_NUMBER_TABLE

Line 189: , a20 JTF_NUMBER_TABLE

185: , a16 JTF_NUMBER_TABLE
186: , a17 JTF_NUMBER_TABLE
187: , a18 JTF_NUMBER_TABLE
188: , a19 JTF_NUMBER_TABLE
189: , a20 JTF_NUMBER_TABLE
190: , a21 JTF_NUMBER_TABLE
191: , a22 JTF_NUMBER_TABLE
192: , a23 JTF_NUMBER_TABLE
193: , a24 JTF_NUMBER_TABLE

Line 190: , a21 JTF_NUMBER_TABLE

186: , a17 JTF_NUMBER_TABLE
187: , a18 JTF_NUMBER_TABLE
188: , a19 JTF_NUMBER_TABLE
189: , a20 JTF_NUMBER_TABLE
190: , a21 JTF_NUMBER_TABLE
191: , a22 JTF_NUMBER_TABLE
192: , a23 JTF_NUMBER_TABLE
193: , a24 JTF_NUMBER_TABLE
194: , a25 JTF_NUMBER_TABLE

Line 191: , a22 JTF_NUMBER_TABLE

187: , a18 JTF_NUMBER_TABLE
188: , a19 JTF_NUMBER_TABLE
189: , a20 JTF_NUMBER_TABLE
190: , a21 JTF_NUMBER_TABLE
191: , a22 JTF_NUMBER_TABLE
192: , a23 JTF_NUMBER_TABLE
193: , a24 JTF_NUMBER_TABLE
194: , a25 JTF_NUMBER_TABLE
195: );

Line 192: , a23 JTF_NUMBER_TABLE

188: , a19 JTF_NUMBER_TABLE
189: , a20 JTF_NUMBER_TABLE
190: , a21 JTF_NUMBER_TABLE
191: , a22 JTF_NUMBER_TABLE
192: , a23 JTF_NUMBER_TABLE
193: , a24 JTF_NUMBER_TABLE
194: , a25 JTF_NUMBER_TABLE
195: );
196: procedure rosetta_table_copy_out_p6(t ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 193: , a24 JTF_NUMBER_TABLE

189: , a20 JTF_NUMBER_TABLE
190: , a21 JTF_NUMBER_TABLE
191: , a22 JTF_NUMBER_TABLE
192: , a23 JTF_NUMBER_TABLE
193: , a24 JTF_NUMBER_TABLE
194: , a25 JTF_NUMBER_TABLE
195: );
196: procedure rosetta_table_copy_out_p6(t ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
197: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 194: , a25 JTF_NUMBER_TABLE

190: , a21 JTF_NUMBER_TABLE
191: , a22 JTF_NUMBER_TABLE
192: , a23 JTF_NUMBER_TABLE
193: , a24 JTF_NUMBER_TABLE
194: , a25 JTF_NUMBER_TABLE
195: );
196: procedure rosetta_table_copy_out_p6(t ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
197: , a1 out nocopy JTF_VARCHAR2_TABLE_100
198: , a2 out nocopy JTF_NUMBER_TABLE

Line 196: procedure rosetta_table_copy_out_p6(t ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

192: , a23 JTF_NUMBER_TABLE
193: , a24 JTF_NUMBER_TABLE
194: , a25 JTF_NUMBER_TABLE
195: );
196: procedure rosetta_table_copy_out_p6(t ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
197: , a1 out nocopy JTF_VARCHAR2_TABLE_100
198: , a2 out nocopy JTF_NUMBER_TABLE
199: , a3 out nocopy JTF_NUMBER_TABLE
200: , a4 out nocopy JTF_NUMBER_TABLE

Line 198: , a2 out nocopy JTF_NUMBER_TABLE

194: , a25 JTF_NUMBER_TABLE
195: );
196: procedure rosetta_table_copy_out_p6(t ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
197: , a1 out nocopy JTF_VARCHAR2_TABLE_100
198: , a2 out nocopy JTF_NUMBER_TABLE
199: , a3 out nocopy JTF_NUMBER_TABLE
200: , a4 out nocopy JTF_NUMBER_TABLE
201: , a5 out nocopy JTF_VARCHAR2_TABLE_300
202: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 199: , a3 out nocopy JTF_NUMBER_TABLE

195: );
196: procedure rosetta_table_copy_out_p6(t ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
197: , a1 out nocopy JTF_VARCHAR2_TABLE_100
198: , a2 out nocopy JTF_NUMBER_TABLE
199: , a3 out nocopy JTF_NUMBER_TABLE
200: , a4 out nocopy JTF_NUMBER_TABLE
201: , a5 out nocopy JTF_VARCHAR2_TABLE_300
202: , a6 out nocopy JTF_VARCHAR2_TABLE_100
203: , a7 out nocopy JTF_NUMBER_TABLE

Line 200: , a4 out nocopy JTF_NUMBER_TABLE

196: procedure rosetta_table_copy_out_p6(t ahl_prd_mrshl_pvt.mrshl_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
197: , a1 out nocopy JTF_VARCHAR2_TABLE_100
198: , a2 out nocopy JTF_NUMBER_TABLE
199: , a3 out nocopy JTF_NUMBER_TABLE
200: , a4 out nocopy JTF_NUMBER_TABLE
201: , a5 out nocopy JTF_VARCHAR2_TABLE_300
202: , a6 out nocopy JTF_VARCHAR2_TABLE_100
203: , a7 out nocopy JTF_NUMBER_TABLE
204: , a8 out nocopy JTF_NUMBER_TABLE

Line 203: , a7 out nocopy JTF_NUMBER_TABLE

199: , a3 out nocopy JTF_NUMBER_TABLE
200: , a4 out nocopy JTF_NUMBER_TABLE
201: , a5 out nocopy JTF_VARCHAR2_TABLE_300
202: , a6 out nocopy JTF_VARCHAR2_TABLE_100
203: , a7 out nocopy JTF_NUMBER_TABLE
204: , a8 out nocopy JTF_NUMBER_TABLE
205: , a9 out nocopy JTF_NUMBER_TABLE
206: , a10 out nocopy JTF_NUMBER_TABLE
207: , a11 out nocopy JTF_VARCHAR2_TABLE_300

Line 204: , a8 out nocopy JTF_NUMBER_TABLE

200: , a4 out nocopy JTF_NUMBER_TABLE
201: , a5 out nocopy JTF_VARCHAR2_TABLE_300
202: , a6 out nocopy JTF_VARCHAR2_TABLE_100
203: , a7 out nocopy JTF_NUMBER_TABLE
204: , a8 out nocopy JTF_NUMBER_TABLE
205: , a9 out nocopy JTF_NUMBER_TABLE
206: , a10 out nocopy JTF_NUMBER_TABLE
207: , a11 out nocopy JTF_VARCHAR2_TABLE_300
208: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 205: , a9 out nocopy JTF_NUMBER_TABLE

201: , a5 out nocopy JTF_VARCHAR2_TABLE_300
202: , a6 out nocopy JTF_VARCHAR2_TABLE_100
203: , a7 out nocopy JTF_NUMBER_TABLE
204: , a8 out nocopy JTF_NUMBER_TABLE
205: , a9 out nocopy JTF_NUMBER_TABLE
206: , a10 out nocopy JTF_NUMBER_TABLE
207: , a11 out nocopy JTF_VARCHAR2_TABLE_300
208: , a12 out nocopy JTF_VARCHAR2_TABLE_100
209: , a13 out nocopy JTF_NUMBER_TABLE

Line 206: , a10 out nocopy JTF_NUMBER_TABLE

202: , a6 out nocopy JTF_VARCHAR2_TABLE_100
203: , a7 out nocopy JTF_NUMBER_TABLE
204: , a8 out nocopy JTF_NUMBER_TABLE
205: , a9 out nocopy JTF_NUMBER_TABLE
206: , a10 out nocopy JTF_NUMBER_TABLE
207: , a11 out nocopy JTF_VARCHAR2_TABLE_300
208: , a12 out nocopy JTF_VARCHAR2_TABLE_100
209: , a13 out nocopy JTF_NUMBER_TABLE
210: , a14 out nocopy JTF_NUMBER_TABLE

Line 209: , a13 out nocopy JTF_NUMBER_TABLE

205: , a9 out nocopy JTF_NUMBER_TABLE
206: , a10 out nocopy JTF_NUMBER_TABLE
207: , a11 out nocopy JTF_VARCHAR2_TABLE_300
208: , a12 out nocopy JTF_VARCHAR2_TABLE_100
209: , a13 out nocopy JTF_NUMBER_TABLE
210: , a14 out nocopy JTF_NUMBER_TABLE
211: , a15 out nocopy JTF_NUMBER_TABLE
212: , a16 out nocopy JTF_NUMBER_TABLE
213: , a17 out nocopy JTF_NUMBER_TABLE

Line 210: , a14 out nocopy JTF_NUMBER_TABLE

206: , a10 out nocopy JTF_NUMBER_TABLE
207: , a11 out nocopy JTF_VARCHAR2_TABLE_300
208: , a12 out nocopy JTF_VARCHAR2_TABLE_100
209: , a13 out nocopy JTF_NUMBER_TABLE
210: , a14 out nocopy JTF_NUMBER_TABLE
211: , a15 out nocopy JTF_NUMBER_TABLE
212: , a16 out nocopy JTF_NUMBER_TABLE
213: , a17 out nocopy JTF_NUMBER_TABLE
214: , a18 out nocopy JTF_NUMBER_TABLE

Line 211: , a15 out nocopy JTF_NUMBER_TABLE

207: , a11 out nocopy JTF_VARCHAR2_TABLE_300
208: , a12 out nocopy JTF_VARCHAR2_TABLE_100
209: , a13 out nocopy JTF_NUMBER_TABLE
210: , a14 out nocopy JTF_NUMBER_TABLE
211: , a15 out nocopy JTF_NUMBER_TABLE
212: , a16 out nocopy JTF_NUMBER_TABLE
213: , a17 out nocopy JTF_NUMBER_TABLE
214: , a18 out nocopy JTF_NUMBER_TABLE
215: , a19 out nocopy JTF_NUMBER_TABLE

Line 212: , a16 out nocopy JTF_NUMBER_TABLE

208: , a12 out nocopy JTF_VARCHAR2_TABLE_100
209: , a13 out nocopy JTF_NUMBER_TABLE
210: , a14 out nocopy JTF_NUMBER_TABLE
211: , a15 out nocopy JTF_NUMBER_TABLE
212: , a16 out nocopy JTF_NUMBER_TABLE
213: , a17 out nocopy JTF_NUMBER_TABLE
214: , a18 out nocopy JTF_NUMBER_TABLE
215: , a19 out nocopy JTF_NUMBER_TABLE
216: , a20 out nocopy JTF_NUMBER_TABLE

Line 213: , a17 out nocopy JTF_NUMBER_TABLE

209: , a13 out nocopy JTF_NUMBER_TABLE
210: , a14 out nocopy JTF_NUMBER_TABLE
211: , a15 out nocopy JTF_NUMBER_TABLE
212: , a16 out nocopy JTF_NUMBER_TABLE
213: , a17 out nocopy JTF_NUMBER_TABLE
214: , a18 out nocopy JTF_NUMBER_TABLE
215: , a19 out nocopy JTF_NUMBER_TABLE
216: , a20 out nocopy JTF_NUMBER_TABLE
217: , a21 out nocopy JTF_NUMBER_TABLE

Line 214: , a18 out nocopy JTF_NUMBER_TABLE

210: , a14 out nocopy JTF_NUMBER_TABLE
211: , a15 out nocopy JTF_NUMBER_TABLE
212: , a16 out nocopy JTF_NUMBER_TABLE
213: , a17 out nocopy JTF_NUMBER_TABLE
214: , a18 out nocopy JTF_NUMBER_TABLE
215: , a19 out nocopy JTF_NUMBER_TABLE
216: , a20 out nocopy JTF_NUMBER_TABLE
217: , a21 out nocopy JTF_NUMBER_TABLE
218: , a22 out nocopy JTF_NUMBER_TABLE

Line 215: , a19 out nocopy JTF_NUMBER_TABLE

211: , a15 out nocopy JTF_NUMBER_TABLE
212: , a16 out nocopy JTF_NUMBER_TABLE
213: , a17 out nocopy JTF_NUMBER_TABLE
214: , a18 out nocopy JTF_NUMBER_TABLE
215: , a19 out nocopy JTF_NUMBER_TABLE
216: , a20 out nocopy JTF_NUMBER_TABLE
217: , a21 out nocopy JTF_NUMBER_TABLE
218: , a22 out nocopy JTF_NUMBER_TABLE
219: , a23 out nocopy JTF_NUMBER_TABLE

Line 216: , a20 out nocopy JTF_NUMBER_TABLE

212: , a16 out nocopy JTF_NUMBER_TABLE
213: , a17 out nocopy JTF_NUMBER_TABLE
214: , a18 out nocopy JTF_NUMBER_TABLE
215: , a19 out nocopy JTF_NUMBER_TABLE
216: , a20 out nocopy JTF_NUMBER_TABLE
217: , a21 out nocopy JTF_NUMBER_TABLE
218: , a22 out nocopy JTF_NUMBER_TABLE
219: , a23 out nocopy JTF_NUMBER_TABLE
220: , a24 out nocopy JTF_NUMBER_TABLE

Line 217: , a21 out nocopy JTF_NUMBER_TABLE

213: , a17 out nocopy JTF_NUMBER_TABLE
214: , a18 out nocopy JTF_NUMBER_TABLE
215: , a19 out nocopy JTF_NUMBER_TABLE
216: , a20 out nocopy JTF_NUMBER_TABLE
217: , a21 out nocopy JTF_NUMBER_TABLE
218: , a22 out nocopy JTF_NUMBER_TABLE
219: , a23 out nocopy JTF_NUMBER_TABLE
220: , a24 out nocopy JTF_NUMBER_TABLE
221: , a25 out nocopy JTF_NUMBER_TABLE

Line 218: , a22 out nocopy JTF_NUMBER_TABLE

214: , a18 out nocopy JTF_NUMBER_TABLE
215: , a19 out nocopy JTF_NUMBER_TABLE
216: , a20 out nocopy JTF_NUMBER_TABLE
217: , a21 out nocopy JTF_NUMBER_TABLE
218: , a22 out nocopy JTF_NUMBER_TABLE
219: , a23 out nocopy JTF_NUMBER_TABLE
220: , a24 out nocopy JTF_NUMBER_TABLE
221: , a25 out nocopy JTF_NUMBER_TABLE
222: );

Line 219: , a23 out nocopy JTF_NUMBER_TABLE

215: , a19 out nocopy JTF_NUMBER_TABLE
216: , a20 out nocopy JTF_NUMBER_TABLE
217: , a21 out nocopy JTF_NUMBER_TABLE
218: , a22 out nocopy JTF_NUMBER_TABLE
219: , a23 out nocopy JTF_NUMBER_TABLE
220: , a24 out nocopy JTF_NUMBER_TABLE
221: , a25 out nocopy JTF_NUMBER_TABLE
222: );
223:

Line 220: , a24 out nocopy JTF_NUMBER_TABLE

216: , a20 out nocopy JTF_NUMBER_TABLE
217: , a21 out nocopy JTF_NUMBER_TABLE
218: , a22 out nocopy JTF_NUMBER_TABLE
219: , a23 out nocopy JTF_NUMBER_TABLE
220: , a24 out nocopy JTF_NUMBER_TABLE
221: , a25 out nocopy JTF_NUMBER_TABLE
222: );
223:
224: procedure get_unavailable_items(p_api_version NUMBER

Line 221: , a25 out nocopy JTF_NUMBER_TABLE

217: , a21 out nocopy JTF_NUMBER_TABLE
218: , a22 out nocopy JTF_NUMBER_TABLE
219: , a23 out nocopy JTF_NUMBER_TABLE
220: , a24 out nocopy JTF_NUMBER_TABLE
221: , a25 out nocopy JTF_NUMBER_TABLE
222: );
223:
224: procedure get_unavailable_items(p_api_version NUMBER
225: , p_init_msg_list VARCHAR2

Line 237: , p7_a0 out nocopy JTF_NUMBER_TABLE

233: , p6_a3 VARCHAR2
234: , p6_a4 VARCHAR2
235: , p6_a5 VARCHAR2
236: , p6_a6 VARCHAR2
237: , p7_a0 out nocopy JTF_NUMBER_TABLE
238: , p7_a1 out nocopy JTF_NUMBER_TABLE
239: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
240: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
241: , p7_a4 out nocopy JTF_NUMBER_TABLE

Line 238: , p7_a1 out nocopy JTF_NUMBER_TABLE

234: , p6_a4 VARCHAR2
235: , p6_a5 VARCHAR2
236: , p6_a6 VARCHAR2
237: , p7_a0 out nocopy JTF_NUMBER_TABLE
238: , p7_a1 out nocopy JTF_NUMBER_TABLE
239: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
240: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
241: , p7_a4 out nocopy JTF_NUMBER_TABLE
242: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 241: , p7_a4 out nocopy JTF_NUMBER_TABLE

237: , p7_a0 out nocopy JTF_NUMBER_TABLE
238: , p7_a1 out nocopy JTF_NUMBER_TABLE
239: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
240: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
241: , p7_a4 out nocopy JTF_NUMBER_TABLE
242: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
243: , p7_a6 out nocopy JTF_NUMBER_TABLE
244: , p7_a7 out nocopy JTF_NUMBER_TABLE
245: , p7_a8 out nocopy JTF_NUMBER_TABLE

Line 243: , p7_a6 out nocopy JTF_NUMBER_TABLE

239: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
240: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
241: , p7_a4 out nocopy JTF_NUMBER_TABLE
242: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
243: , p7_a6 out nocopy JTF_NUMBER_TABLE
244: , p7_a7 out nocopy JTF_NUMBER_TABLE
245: , p7_a8 out nocopy JTF_NUMBER_TABLE
246: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
247: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 244: , p7_a7 out nocopy JTF_NUMBER_TABLE

240: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
241: , p7_a4 out nocopy JTF_NUMBER_TABLE
242: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
243: , p7_a6 out nocopy JTF_NUMBER_TABLE
244: , p7_a7 out nocopy JTF_NUMBER_TABLE
245: , p7_a8 out nocopy JTF_NUMBER_TABLE
246: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
247: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
248: , p7_a11 out nocopy JTF_NUMBER_TABLE

Line 245: , p7_a8 out nocopy JTF_NUMBER_TABLE

241: , p7_a4 out nocopy JTF_NUMBER_TABLE
242: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
243: , p7_a6 out nocopy JTF_NUMBER_TABLE
244: , p7_a7 out nocopy JTF_NUMBER_TABLE
245: , p7_a8 out nocopy JTF_NUMBER_TABLE
246: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
247: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
248: , p7_a11 out nocopy JTF_NUMBER_TABLE
249: , p7_a12 out nocopy JTF_NUMBER_TABLE

Line 248: , p7_a11 out nocopy JTF_NUMBER_TABLE

244: , p7_a7 out nocopy JTF_NUMBER_TABLE
245: , p7_a8 out nocopy JTF_NUMBER_TABLE
246: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
247: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
248: , p7_a11 out nocopy JTF_NUMBER_TABLE
249: , p7_a12 out nocopy JTF_NUMBER_TABLE
250: , p7_a13 out nocopy JTF_NUMBER_TABLE
251: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
252: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 249: , p7_a12 out nocopy JTF_NUMBER_TABLE

245: , p7_a8 out nocopy JTF_NUMBER_TABLE
246: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
247: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
248: , p7_a11 out nocopy JTF_NUMBER_TABLE
249: , p7_a12 out nocopy JTF_NUMBER_TABLE
250: , p7_a13 out nocopy JTF_NUMBER_TABLE
251: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
252: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
253: , p7_a16 out nocopy JTF_DATE_TABLE

Line 250: , p7_a13 out nocopy JTF_NUMBER_TABLE

246: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
247: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
248: , p7_a11 out nocopy JTF_NUMBER_TABLE
249: , p7_a12 out nocopy JTF_NUMBER_TABLE
250: , p7_a13 out nocopy JTF_NUMBER_TABLE
251: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
252: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
253: , p7_a16 out nocopy JTF_DATE_TABLE
254: , p7_a17 out nocopy JTF_NUMBER_TABLE

Line 254: , p7_a17 out nocopy JTF_NUMBER_TABLE

250: , p7_a13 out nocopy JTF_NUMBER_TABLE
251: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
252: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
253: , p7_a16 out nocopy JTF_DATE_TABLE
254: , p7_a17 out nocopy JTF_NUMBER_TABLE
255: , p7_a18 out nocopy JTF_NUMBER_TABLE
256: , p7_a19 out nocopy JTF_DATE_TABLE
257: , p7_a20 out nocopy JTF_NUMBER_TABLE
258: , p7_a21 out nocopy JTF_DATE_TABLE

Line 255: , p7_a18 out nocopy JTF_NUMBER_TABLE

251: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
252: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
253: , p7_a16 out nocopy JTF_DATE_TABLE
254: , p7_a17 out nocopy JTF_NUMBER_TABLE
255: , p7_a18 out nocopy JTF_NUMBER_TABLE
256: , p7_a19 out nocopy JTF_DATE_TABLE
257: , p7_a20 out nocopy JTF_NUMBER_TABLE
258: , p7_a21 out nocopy JTF_DATE_TABLE
259: , p7_a22 out nocopy JTF_NUMBER_TABLE

Line 257: , p7_a20 out nocopy JTF_NUMBER_TABLE

253: , p7_a16 out nocopy JTF_DATE_TABLE
254: , p7_a17 out nocopy JTF_NUMBER_TABLE
255: , p7_a18 out nocopy JTF_NUMBER_TABLE
256: , p7_a19 out nocopy JTF_DATE_TABLE
257: , p7_a20 out nocopy JTF_NUMBER_TABLE
258: , p7_a21 out nocopy JTF_DATE_TABLE
259: , p7_a22 out nocopy JTF_NUMBER_TABLE
260: , p7_a23 out nocopy JTF_NUMBER_TABLE
261: , p7_a24 out nocopy JTF_NUMBER_TABLE

Line 259: , p7_a22 out nocopy JTF_NUMBER_TABLE

255: , p7_a18 out nocopy JTF_NUMBER_TABLE
256: , p7_a19 out nocopy JTF_DATE_TABLE
257: , p7_a20 out nocopy JTF_NUMBER_TABLE
258: , p7_a21 out nocopy JTF_DATE_TABLE
259: , p7_a22 out nocopy JTF_NUMBER_TABLE
260: , p7_a23 out nocopy JTF_NUMBER_TABLE
261: , p7_a24 out nocopy JTF_NUMBER_TABLE
262: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
263: , p7_a26 out nocopy JTF_NUMBER_TABLE

Line 260: , p7_a23 out nocopy JTF_NUMBER_TABLE

256: , p7_a19 out nocopy JTF_DATE_TABLE
257: , p7_a20 out nocopy JTF_NUMBER_TABLE
258: , p7_a21 out nocopy JTF_DATE_TABLE
259: , p7_a22 out nocopy JTF_NUMBER_TABLE
260: , p7_a23 out nocopy JTF_NUMBER_TABLE
261: , p7_a24 out nocopy JTF_NUMBER_TABLE
262: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
263: , p7_a26 out nocopy JTF_NUMBER_TABLE
264: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300

Line 261: , p7_a24 out nocopy JTF_NUMBER_TABLE

257: , p7_a20 out nocopy JTF_NUMBER_TABLE
258: , p7_a21 out nocopy JTF_DATE_TABLE
259: , p7_a22 out nocopy JTF_NUMBER_TABLE
260: , p7_a23 out nocopy JTF_NUMBER_TABLE
261: , p7_a24 out nocopy JTF_NUMBER_TABLE
262: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
263: , p7_a26 out nocopy JTF_NUMBER_TABLE
264: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
265: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100

Line 263: , p7_a26 out nocopy JTF_NUMBER_TABLE

259: , p7_a22 out nocopy JTF_NUMBER_TABLE
260: , p7_a23 out nocopy JTF_NUMBER_TABLE
261: , p7_a24 out nocopy JTF_NUMBER_TABLE
262: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
263: , p7_a26 out nocopy JTF_NUMBER_TABLE
264: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
265: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
266: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
267: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100

Line 271: , p7_a34 out nocopy JTF_NUMBER_TABLE

267: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
268: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100
269: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
270: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_100
271: , p7_a34 out nocopy JTF_NUMBER_TABLE
272: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
273: , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100
274: , p7_a37 out nocopy JTF_NUMBER_TABLE
275: , x_return_status out nocopy VARCHAR2

Line 274: , p7_a37 out nocopy JTF_NUMBER_TABLE

270: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_100
271: , p7_a34 out nocopy JTF_NUMBER_TABLE
272: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
273: , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100
274: , p7_a37 out nocopy JTF_NUMBER_TABLE
275: , x_return_status out nocopy VARCHAR2
276: , x_msg_count out nocopy NUMBER
277: , x_msg_data out nocopy VARCHAR2
278: );

Line 292: , p7_a0 out nocopy JTF_NUMBER_TABLE

288: , p6_a3 VARCHAR2
289: , p6_a4 VARCHAR2
290: , p6_a5 VARCHAR2
291: , p6_a6 VARCHAR2
292: , p7_a0 out nocopy JTF_NUMBER_TABLE
293: , p7_a1 out nocopy JTF_NUMBER_TABLE
294: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
295: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
296: , p7_a4 out nocopy JTF_NUMBER_TABLE

Line 293: , p7_a1 out nocopy JTF_NUMBER_TABLE

289: , p6_a4 VARCHAR2
290: , p6_a5 VARCHAR2
291: , p6_a6 VARCHAR2
292: , p7_a0 out nocopy JTF_NUMBER_TABLE
293: , p7_a1 out nocopy JTF_NUMBER_TABLE
294: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
295: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
296: , p7_a4 out nocopy JTF_NUMBER_TABLE
297: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 296: , p7_a4 out nocopy JTF_NUMBER_TABLE

292: , p7_a0 out nocopy JTF_NUMBER_TABLE
293: , p7_a1 out nocopy JTF_NUMBER_TABLE
294: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
295: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
296: , p7_a4 out nocopy JTF_NUMBER_TABLE
297: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
298: , p7_a6 out nocopy JTF_NUMBER_TABLE
299: , p7_a7 out nocopy JTF_NUMBER_TABLE
300: , p7_a8 out nocopy JTF_NUMBER_TABLE

Line 298: , p7_a6 out nocopy JTF_NUMBER_TABLE

294: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_300
295: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
296: , p7_a4 out nocopy JTF_NUMBER_TABLE
297: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
298: , p7_a6 out nocopy JTF_NUMBER_TABLE
299: , p7_a7 out nocopy JTF_NUMBER_TABLE
300: , p7_a8 out nocopy JTF_NUMBER_TABLE
301: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
302: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 299: , p7_a7 out nocopy JTF_NUMBER_TABLE

295: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_300
296: , p7_a4 out nocopy JTF_NUMBER_TABLE
297: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
298: , p7_a6 out nocopy JTF_NUMBER_TABLE
299: , p7_a7 out nocopy JTF_NUMBER_TABLE
300: , p7_a8 out nocopy JTF_NUMBER_TABLE
301: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
302: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
303: , p7_a11 out nocopy JTF_NUMBER_TABLE

Line 300: , p7_a8 out nocopy JTF_NUMBER_TABLE

296: , p7_a4 out nocopy JTF_NUMBER_TABLE
297: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
298: , p7_a6 out nocopy JTF_NUMBER_TABLE
299: , p7_a7 out nocopy JTF_NUMBER_TABLE
300: , p7_a8 out nocopy JTF_NUMBER_TABLE
301: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
302: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
303: , p7_a11 out nocopy JTF_NUMBER_TABLE
304: , p7_a12 out nocopy JTF_NUMBER_TABLE

Line 303: , p7_a11 out nocopy JTF_NUMBER_TABLE

299: , p7_a7 out nocopy JTF_NUMBER_TABLE
300: , p7_a8 out nocopy JTF_NUMBER_TABLE
301: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
302: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
303: , p7_a11 out nocopy JTF_NUMBER_TABLE
304: , p7_a12 out nocopy JTF_NUMBER_TABLE
305: , p7_a13 out nocopy JTF_NUMBER_TABLE
306: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
307: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 304: , p7_a12 out nocopy JTF_NUMBER_TABLE

300: , p7_a8 out nocopy JTF_NUMBER_TABLE
301: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
302: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
303: , p7_a11 out nocopy JTF_NUMBER_TABLE
304: , p7_a12 out nocopy JTF_NUMBER_TABLE
305: , p7_a13 out nocopy JTF_NUMBER_TABLE
306: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
307: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
308: , p7_a16 out nocopy JTF_DATE_TABLE

Line 305: , p7_a13 out nocopy JTF_NUMBER_TABLE

301: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
302: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
303: , p7_a11 out nocopy JTF_NUMBER_TABLE
304: , p7_a12 out nocopy JTF_NUMBER_TABLE
305: , p7_a13 out nocopy JTF_NUMBER_TABLE
306: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
307: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
308: , p7_a16 out nocopy JTF_DATE_TABLE
309: , p7_a17 out nocopy JTF_NUMBER_TABLE

Line 309: , p7_a17 out nocopy JTF_NUMBER_TABLE

305: , p7_a13 out nocopy JTF_NUMBER_TABLE
306: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
307: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
308: , p7_a16 out nocopy JTF_DATE_TABLE
309: , p7_a17 out nocopy JTF_NUMBER_TABLE
310: , p7_a18 out nocopy JTF_DATE_TABLE
311: , p7_a19 out nocopy JTF_NUMBER_TABLE
312: , p7_a20 out nocopy JTF_NUMBER_TABLE
313: , p7_a21 out nocopy JTF_DATE_TABLE

Line 311: , p7_a19 out nocopy JTF_NUMBER_TABLE

307: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
308: , p7_a16 out nocopy JTF_DATE_TABLE
309: , p7_a17 out nocopy JTF_NUMBER_TABLE
310: , p7_a18 out nocopy JTF_DATE_TABLE
311: , p7_a19 out nocopy JTF_NUMBER_TABLE
312: , p7_a20 out nocopy JTF_NUMBER_TABLE
313: , p7_a21 out nocopy JTF_DATE_TABLE
314: , p7_a22 out nocopy JTF_NUMBER_TABLE
315: , p7_a23 out nocopy JTF_NUMBER_TABLE

Line 312: , p7_a20 out nocopy JTF_NUMBER_TABLE

308: , p7_a16 out nocopy JTF_DATE_TABLE
309: , p7_a17 out nocopy JTF_NUMBER_TABLE
310: , p7_a18 out nocopy JTF_DATE_TABLE
311: , p7_a19 out nocopy JTF_NUMBER_TABLE
312: , p7_a20 out nocopy JTF_NUMBER_TABLE
313: , p7_a21 out nocopy JTF_DATE_TABLE
314: , p7_a22 out nocopy JTF_NUMBER_TABLE
315: , p7_a23 out nocopy JTF_NUMBER_TABLE
316: , p7_a24 out nocopy JTF_NUMBER_TABLE

Line 314: , p7_a22 out nocopy JTF_NUMBER_TABLE

310: , p7_a18 out nocopy JTF_DATE_TABLE
311: , p7_a19 out nocopy JTF_NUMBER_TABLE
312: , p7_a20 out nocopy JTF_NUMBER_TABLE
313: , p7_a21 out nocopy JTF_DATE_TABLE
314: , p7_a22 out nocopy JTF_NUMBER_TABLE
315: , p7_a23 out nocopy JTF_NUMBER_TABLE
316: , p7_a24 out nocopy JTF_NUMBER_TABLE
317: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
318: , p7_a26 out nocopy JTF_NUMBER_TABLE

Line 315: , p7_a23 out nocopy JTF_NUMBER_TABLE

311: , p7_a19 out nocopy JTF_NUMBER_TABLE
312: , p7_a20 out nocopy JTF_NUMBER_TABLE
313: , p7_a21 out nocopy JTF_DATE_TABLE
314: , p7_a22 out nocopy JTF_NUMBER_TABLE
315: , p7_a23 out nocopy JTF_NUMBER_TABLE
316: , p7_a24 out nocopy JTF_NUMBER_TABLE
317: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
318: , p7_a26 out nocopy JTF_NUMBER_TABLE
319: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300

Line 316: , p7_a24 out nocopy JTF_NUMBER_TABLE

312: , p7_a20 out nocopy JTF_NUMBER_TABLE
313: , p7_a21 out nocopy JTF_DATE_TABLE
314: , p7_a22 out nocopy JTF_NUMBER_TABLE
315: , p7_a23 out nocopy JTF_NUMBER_TABLE
316: , p7_a24 out nocopy JTF_NUMBER_TABLE
317: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
318: , p7_a26 out nocopy JTF_NUMBER_TABLE
319: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
320: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100

Line 318: , p7_a26 out nocopy JTF_NUMBER_TABLE

314: , p7_a22 out nocopy JTF_NUMBER_TABLE
315: , p7_a23 out nocopy JTF_NUMBER_TABLE
316: , p7_a24 out nocopy JTF_NUMBER_TABLE
317: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_100
318: , p7_a26 out nocopy JTF_NUMBER_TABLE
319: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
320: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
321: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
322: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100

Line 323: , p7_a31 out nocopy JTF_NUMBER_TABLE

319: , p7_a27 out nocopy JTF_VARCHAR2_TABLE_300
320: , p7_a28 out nocopy JTF_VARCHAR2_TABLE_100
321: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
322: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
323: , p7_a31 out nocopy JTF_NUMBER_TABLE
324: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
325: , p7_a33 out nocopy JTF_NUMBER_TABLE
326: , p7_a34 out nocopy JTF_NUMBER_TABLE
327: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100

Line 325: , p7_a33 out nocopy JTF_NUMBER_TABLE

321: , p7_a29 out nocopy JTF_VARCHAR2_TABLE_100
322: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
323: , p7_a31 out nocopy JTF_NUMBER_TABLE
324: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
325: , p7_a33 out nocopy JTF_NUMBER_TABLE
326: , p7_a34 out nocopy JTF_NUMBER_TABLE
327: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
328: , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100
329: , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100

Line 326: , p7_a34 out nocopy JTF_NUMBER_TABLE

322: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
323: , p7_a31 out nocopy JTF_NUMBER_TABLE
324: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
325: , p7_a33 out nocopy JTF_NUMBER_TABLE
326: , p7_a34 out nocopy JTF_NUMBER_TABLE
327: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
328: , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100
329: , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100
330: , p7_a38 out nocopy JTF_NUMBER_TABLE

Line 330: , p7_a38 out nocopy JTF_NUMBER_TABLE

326: , p7_a34 out nocopy JTF_NUMBER_TABLE
327: , p7_a35 out nocopy JTF_VARCHAR2_TABLE_100
328: , p7_a36 out nocopy JTF_VARCHAR2_TABLE_100
329: , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100
330: , p7_a38 out nocopy JTF_NUMBER_TABLE
331: , p7_a39 out nocopy JTF_VARCHAR2_TABLE_100
332: , p7_a40 out nocopy JTF_VARCHAR2_TABLE_100
333: , p7_a41 out nocopy JTF_NUMBER_TABLE
334: , x_return_status out nocopy VARCHAR2

Line 333: , p7_a41 out nocopy JTF_NUMBER_TABLE

329: , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100
330: , p7_a38 out nocopy JTF_NUMBER_TABLE
331: , p7_a39 out nocopy JTF_VARCHAR2_TABLE_100
332: , p7_a40 out nocopy JTF_VARCHAR2_TABLE_100
333: , p7_a41 out nocopy JTF_NUMBER_TABLE
334: , x_return_status out nocopy VARCHAR2
335: , x_msg_count out nocopy NUMBER
336: , x_msg_data out nocopy VARCHAR2
337: );

Line 347: , p9_a0 out nocopy JTF_NUMBER_TABLE

343: , p_module_type VARCHAR2
344: , p_unit_header_id NUMBER
345: , p_item_instance_id NUMBER
346: , p_visit_id NUMBER
347: , p9_a0 out nocopy JTF_NUMBER_TABLE
348: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
349: , p9_a2 out nocopy JTF_NUMBER_TABLE
350: , p9_a3 out nocopy JTF_NUMBER_TABLE
351: , p9_a4 out nocopy JTF_NUMBER_TABLE

Line 349: , p9_a2 out nocopy JTF_NUMBER_TABLE

345: , p_item_instance_id NUMBER
346: , p_visit_id NUMBER
347: , p9_a0 out nocopy JTF_NUMBER_TABLE
348: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
349: , p9_a2 out nocopy JTF_NUMBER_TABLE
350: , p9_a3 out nocopy JTF_NUMBER_TABLE
351: , p9_a4 out nocopy JTF_NUMBER_TABLE
352: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
353: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 350: , p9_a3 out nocopy JTF_NUMBER_TABLE

346: , p_visit_id NUMBER
347: , p9_a0 out nocopy JTF_NUMBER_TABLE
348: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
349: , p9_a2 out nocopy JTF_NUMBER_TABLE
350: , p9_a3 out nocopy JTF_NUMBER_TABLE
351: , p9_a4 out nocopy JTF_NUMBER_TABLE
352: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
353: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
354: , p9_a7 out nocopy JTF_NUMBER_TABLE

Line 351: , p9_a4 out nocopy JTF_NUMBER_TABLE

347: , p9_a0 out nocopy JTF_NUMBER_TABLE
348: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
349: , p9_a2 out nocopy JTF_NUMBER_TABLE
350: , p9_a3 out nocopy JTF_NUMBER_TABLE
351: , p9_a4 out nocopy JTF_NUMBER_TABLE
352: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
353: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
354: , p9_a7 out nocopy JTF_NUMBER_TABLE
355: , p9_a8 out nocopy JTF_NUMBER_TABLE

Line 354: , p9_a7 out nocopy JTF_NUMBER_TABLE

350: , p9_a3 out nocopy JTF_NUMBER_TABLE
351: , p9_a4 out nocopy JTF_NUMBER_TABLE
352: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
353: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
354: , p9_a7 out nocopy JTF_NUMBER_TABLE
355: , p9_a8 out nocopy JTF_NUMBER_TABLE
356: , p9_a9 out nocopy JTF_NUMBER_TABLE
357: , p9_a10 out nocopy JTF_NUMBER_TABLE
358: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_300

Line 355: , p9_a8 out nocopy JTF_NUMBER_TABLE

351: , p9_a4 out nocopy JTF_NUMBER_TABLE
352: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
353: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
354: , p9_a7 out nocopy JTF_NUMBER_TABLE
355: , p9_a8 out nocopy JTF_NUMBER_TABLE
356: , p9_a9 out nocopy JTF_NUMBER_TABLE
357: , p9_a10 out nocopy JTF_NUMBER_TABLE
358: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_300
359: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 356: , p9_a9 out nocopy JTF_NUMBER_TABLE

352: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
353: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
354: , p9_a7 out nocopy JTF_NUMBER_TABLE
355: , p9_a8 out nocopy JTF_NUMBER_TABLE
356: , p9_a9 out nocopy JTF_NUMBER_TABLE
357: , p9_a10 out nocopy JTF_NUMBER_TABLE
358: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_300
359: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
360: , p9_a13 out nocopy JTF_NUMBER_TABLE

Line 357: , p9_a10 out nocopy JTF_NUMBER_TABLE

353: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_100
354: , p9_a7 out nocopy JTF_NUMBER_TABLE
355: , p9_a8 out nocopy JTF_NUMBER_TABLE
356: , p9_a9 out nocopy JTF_NUMBER_TABLE
357: , p9_a10 out nocopy JTF_NUMBER_TABLE
358: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_300
359: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
360: , p9_a13 out nocopy JTF_NUMBER_TABLE
361: , p9_a14 out nocopy JTF_NUMBER_TABLE

Line 360: , p9_a13 out nocopy JTF_NUMBER_TABLE

356: , p9_a9 out nocopy JTF_NUMBER_TABLE
357: , p9_a10 out nocopy JTF_NUMBER_TABLE
358: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_300
359: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
360: , p9_a13 out nocopy JTF_NUMBER_TABLE
361: , p9_a14 out nocopy JTF_NUMBER_TABLE
362: , p9_a15 out nocopy JTF_NUMBER_TABLE
363: , p9_a16 out nocopy JTF_NUMBER_TABLE
364: , p9_a17 out nocopy JTF_NUMBER_TABLE

Line 361: , p9_a14 out nocopy JTF_NUMBER_TABLE

357: , p9_a10 out nocopy JTF_NUMBER_TABLE
358: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_300
359: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
360: , p9_a13 out nocopy JTF_NUMBER_TABLE
361: , p9_a14 out nocopy JTF_NUMBER_TABLE
362: , p9_a15 out nocopy JTF_NUMBER_TABLE
363: , p9_a16 out nocopy JTF_NUMBER_TABLE
364: , p9_a17 out nocopy JTF_NUMBER_TABLE
365: , p9_a18 out nocopy JTF_NUMBER_TABLE

Line 362: , p9_a15 out nocopy JTF_NUMBER_TABLE

358: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_300
359: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
360: , p9_a13 out nocopy JTF_NUMBER_TABLE
361: , p9_a14 out nocopy JTF_NUMBER_TABLE
362: , p9_a15 out nocopy JTF_NUMBER_TABLE
363: , p9_a16 out nocopy JTF_NUMBER_TABLE
364: , p9_a17 out nocopy JTF_NUMBER_TABLE
365: , p9_a18 out nocopy JTF_NUMBER_TABLE
366: , p9_a19 out nocopy JTF_NUMBER_TABLE

Line 363: , p9_a16 out nocopy JTF_NUMBER_TABLE

359: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
360: , p9_a13 out nocopy JTF_NUMBER_TABLE
361: , p9_a14 out nocopy JTF_NUMBER_TABLE
362: , p9_a15 out nocopy JTF_NUMBER_TABLE
363: , p9_a16 out nocopy JTF_NUMBER_TABLE
364: , p9_a17 out nocopy JTF_NUMBER_TABLE
365: , p9_a18 out nocopy JTF_NUMBER_TABLE
366: , p9_a19 out nocopy JTF_NUMBER_TABLE
367: , p9_a20 out nocopy JTF_NUMBER_TABLE

Line 364: , p9_a17 out nocopy JTF_NUMBER_TABLE

360: , p9_a13 out nocopy JTF_NUMBER_TABLE
361: , p9_a14 out nocopy JTF_NUMBER_TABLE
362: , p9_a15 out nocopy JTF_NUMBER_TABLE
363: , p9_a16 out nocopy JTF_NUMBER_TABLE
364: , p9_a17 out nocopy JTF_NUMBER_TABLE
365: , p9_a18 out nocopy JTF_NUMBER_TABLE
366: , p9_a19 out nocopy JTF_NUMBER_TABLE
367: , p9_a20 out nocopy JTF_NUMBER_TABLE
368: , p9_a21 out nocopy JTF_NUMBER_TABLE

Line 365: , p9_a18 out nocopy JTF_NUMBER_TABLE

361: , p9_a14 out nocopy JTF_NUMBER_TABLE
362: , p9_a15 out nocopy JTF_NUMBER_TABLE
363: , p9_a16 out nocopy JTF_NUMBER_TABLE
364: , p9_a17 out nocopy JTF_NUMBER_TABLE
365: , p9_a18 out nocopy JTF_NUMBER_TABLE
366: , p9_a19 out nocopy JTF_NUMBER_TABLE
367: , p9_a20 out nocopy JTF_NUMBER_TABLE
368: , p9_a21 out nocopy JTF_NUMBER_TABLE
369: , p9_a22 out nocopy JTF_NUMBER_TABLE

Line 366: , p9_a19 out nocopy JTF_NUMBER_TABLE

362: , p9_a15 out nocopy JTF_NUMBER_TABLE
363: , p9_a16 out nocopy JTF_NUMBER_TABLE
364: , p9_a17 out nocopy JTF_NUMBER_TABLE
365: , p9_a18 out nocopy JTF_NUMBER_TABLE
366: , p9_a19 out nocopy JTF_NUMBER_TABLE
367: , p9_a20 out nocopy JTF_NUMBER_TABLE
368: , p9_a21 out nocopy JTF_NUMBER_TABLE
369: , p9_a22 out nocopy JTF_NUMBER_TABLE
370: , p9_a23 out nocopy JTF_NUMBER_TABLE

Line 367: , p9_a20 out nocopy JTF_NUMBER_TABLE

363: , p9_a16 out nocopy JTF_NUMBER_TABLE
364: , p9_a17 out nocopy JTF_NUMBER_TABLE
365: , p9_a18 out nocopy JTF_NUMBER_TABLE
366: , p9_a19 out nocopy JTF_NUMBER_TABLE
367: , p9_a20 out nocopy JTF_NUMBER_TABLE
368: , p9_a21 out nocopy JTF_NUMBER_TABLE
369: , p9_a22 out nocopy JTF_NUMBER_TABLE
370: , p9_a23 out nocopy JTF_NUMBER_TABLE
371: , p9_a24 out nocopy JTF_NUMBER_TABLE

Line 368: , p9_a21 out nocopy JTF_NUMBER_TABLE

364: , p9_a17 out nocopy JTF_NUMBER_TABLE
365: , p9_a18 out nocopy JTF_NUMBER_TABLE
366: , p9_a19 out nocopy JTF_NUMBER_TABLE
367: , p9_a20 out nocopy JTF_NUMBER_TABLE
368: , p9_a21 out nocopy JTF_NUMBER_TABLE
369: , p9_a22 out nocopy JTF_NUMBER_TABLE
370: , p9_a23 out nocopy JTF_NUMBER_TABLE
371: , p9_a24 out nocopy JTF_NUMBER_TABLE
372: , p9_a25 out nocopy JTF_NUMBER_TABLE

Line 369: , p9_a22 out nocopy JTF_NUMBER_TABLE

365: , p9_a18 out nocopy JTF_NUMBER_TABLE
366: , p9_a19 out nocopy JTF_NUMBER_TABLE
367: , p9_a20 out nocopy JTF_NUMBER_TABLE
368: , p9_a21 out nocopy JTF_NUMBER_TABLE
369: , p9_a22 out nocopy JTF_NUMBER_TABLE
370: , p9_a23 out nocopy JTF_NUMBER_TABLE
371: , p9_a24 out nocopy JTF_NUMBER_TABLE
372: , p9_a25 out nocopy JTF_NUMBER_TABLE
373: , x_return_status out nocopy VARCHAR2

Line 370: , p9_a23 out nocopy JTF_NUMBER_TABLE

366: , p9_a19 out nocopy JTF_NUMBER_TABLE
367: , p9_a20 out nocopy JTF_NUMBER_TABLE
368: , p9_a21 out nocopy JTF_NUMBER_TABLE
369: , p9_a22 out nocopy JTF_NUMBER_TABLE
370: , p9_a23 out nocopy JTF_NUMBER_TABLE
371: , p9_a24 out nocopy JTF_NUMBER_TABLE
372: , p9_a25 out nocopy JTF_NUMBER_TABLE
373: , x_return_status out nocopy VARCHAR2
374: , x_msg_count out nocopy NUMBER

Line 371: , p9_a24 out nocopy JTF_NUMBER_TABLE

367: , p9_a20 out nocopy JTF_NUMBER_TABLE
368: , p9_a21 out nocopy JTF_NUMBER_TABLE
369: , p9_a22 out nocopy JTF_NUMBER_TABLE
370: , p9_a23 out nocopy JTF_NUMBER_TABLE
371: , p9_a24 out nocopy JTF_NUMBER_TABLE
372: , p9_a25 out nocopy JTF_NUMBER_TABLE
373: , x_return_status out nocopy VARCHAR2
374: , x_msg_count out nocopy NUMBER
375: , x_msg_data out nocopy VARCHAR2

Line 372: , p9_a25 out nocopy JTF_NUMBER_TABLE

368: , p9_a21 out nocopy JTF_NUMBER_TABLE
369: , p9_a22 out nocopy JTF_NUMBER_TABLE
370: , p9_a23 out nocopy JTF_NUMBER_TABLE
371: , p9_a24 out nocopy JTF_NUMBER_TABLE
372: , p9_a25 out nocopy JTF_NUMBER_TABLE
373: , x_return_status out nocopy VARCHAR2
374: , x_msg_count out nocopy NUMBER
375: , x_msg_data out nocopy VARCHAR2
376: );