APPS.AHL_FMP_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_pvt.mr_item_instance_tbl_type, a0 JTF_VARCHAR2_TABLE_100

1: package ahl_fmp_pvt_w AUTHID CURRENT_USER as
2: /* $Header: AHLWFMPS.pls 120.2.12020000.3 2013/04/01 02:06:13 sracha ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_pvt.mr_item_instance_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_4000
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_400

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package ahl_fmp_pvt_w AUTHID CURRENT_USER as
2: /* $Header: AHLWFMPS.pls 120.2.12020000.3 2013/04/01 02:06:13 sracha ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_pvt.mr_item_instance_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_4000
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_400
8: , a5 JTF_VARCHAR2_TABLE_300

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: AHLWFMPS.pls 120.2.12020000.3 2013/04/01 02:06:13 sracha ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_pvt.mr_item_instance_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_4000
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_400
8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_NUMBER_TABLE

Line 9: , a6 JTF_VARCHAR2_TABLE_100

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

Line 14: , a11 JTF_VARCHAR2_TABLE_100

10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: );
16: procedure rosetta_table_copy_out_p1(t ahl_fmp_pvt.mr_item_instance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
17: , a1 out nocopy JTF_VARCHAR2_TABLE_100
18: , a2 out nocopy JTF_VARCHAR2_TABLE_4000

Line 16: procedure rosetta_table_copy_out_p1(t ahl_fmp_pvt.mr_item_instance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: );
16: procedure rosetta_table_copy_out_p1(t ahl_fmp_pvt.mr_item_instance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
17: , a1 out nocopy JTF_VARCHAR2_TABLE_100
18: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
19: , a3 out nocopy JTF_VARCHAR2_TABLE_100
20: , a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 17: , a1 out nocopy JTF_VARCHAR2_TABLE_100

13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_VARCHAR2_TABLE_100
15: );
16: procedure rosetta_table_copy_out_p1(t ahl_fmp_pvt.mr_item_instance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
17: , a1 out nocopy JTF_VARCHAR2_TABLE_100
18: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
19: , a3 out nocopy JTF_VARCHAR2_TABLE_100
20: , a4 out nocopy JTF_VARCHAR2_TABLE_400
21: , a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 19: , a3 out nocopy JTF_VARCHAR2_TABLE_100

15: );
16: procedure rosetta_table_copy_out_p1(t ahl_fmp_pvt.mr_item_instance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
17: , a1 out nocopy JTF_VARCHAR2_TABLE_100
18: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
19: , a3 out nocopy JTF_VARCHAR2_TABLE_100
20: , a4 out nocopy JTF_VARCHAR2_TABLE_400
21: , a5 out nocopy JTF_VARCHAR2_TABLE_300
22: , a6 out nocopy JTF_VARCHAR2_TABLE_100
23: , a7 out nocopy JTF_NUMBER_TABLE

Line 22: , a6 out nocopy JTF_VARCHAR2_TABLE_100

18: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
19: , a3 out nocopy JTF_VARCHAR2_TABLE_100
20: , a4 out nocopy JTF_VARCHAR2_TABLE_400
21: , a5 out nocopy JTF_VARCHAR2_TABLE_300
22: , a6 out nocopy JTF_VARCHAR2_TABLE_100
23: , a7 out nocopy JTF_NUMBER_TABLE
24: , a8 out nocopy JTF_NUMBER_TABLE
25: , a9 out nocopy JTF_NUMBER_TABLE
26: , a10 out nocopy JTF_NUMBER_TABLE

Line 27: , a11 out nocopy JTF_VARCHAR2_TABLE_100

23: , a7 out nocopy JTF_NUMBER_TABLE
24: , a8 out nocopy JTF_NUMBER_TABLE
25: , a9 out nocopy JTF_NUMBER_TABLE
26: , a10 out nocopy JTF_NUMBER_TABLE
27: , a11 out nocopy JTF_VARCHAR2_TABLE_100
28: );
29:
30: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_pvt.applicable_mr_tbl_type, a0 JTF_NUMBER_TABLE
31: , a1 JTF_NUMBER_TABLE

Line 33: , a3 JTF_VARCHAR2_TABLE_100

29:
30: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_pvt.applicable_mr_tbl_type, a0 JTF_NUMBER_TABLE
31: , a1 JTF_NUMBER_TABLE
32: , a2 JTF_NUMBER_TABLE
33: , a3 JTF_VARCHAR2_TABLE_100
34: , a4 JTF_VARCHAR2_TABLE_100
35: , a5 JTF_NUMBER_TABLE
36: , a6 JTF_VARCHAR2_TABLE_100
37: , a7 JTF_VARCHAR2_TABLE_100

Line 34: , a4 JTF_VARCHAR2_TABLE_100

30: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_pvt.applicable_mr_tbl_type, a0 JTF_NUMBER_TABLE
31: , a1 JTF_NUMBER_TABLE
32: , a2 JTF_NUMBER_TABLE
33: , a3 JTF_VARCHAR2_TABLE_100
34: , a4 JTF_VARCHAR2_TABLE_100
35: , a5 JTF_NUMBER_TABLE
36: , a6 JTF_VARCHAR2_TABLE_100
37: , a7 JTF_VARCHAR2_TABLE_100
38: , a8 JTF_NUMBER_TABLE

Line 36: , a6 JTF_VARCHAR2_TABLE_100

32: , a2 JTF_NUMBER_TABLE
33: , a3 JTF_VARCHAR2_TABLE_100
34: , a4 JTF_VARCHAR2_TABLE_100
35: , a5 JTF_NUMBER_TABLE
36: , a6 JTF_VARCHAR2_TABLE_100
37: , a7 JTF_VARCHAR2_TABLE_100
38: , a8 JTF_NUMBER_TABLE
39: , a9 JTF_VARCHAR2_TABLE_100
40: , a10 JTF_NUMBER_TABLE

Line 37: , a7 JTF_VARCHAR2_TABLE_100

33: , a3 JTF_VARCHAR2_TABLE_100
34: , a4 JTF_VARCHAR2_TABLE_100
35: , a5 JTF_NUMBER_TABLE
36: , a6 JTF_VARCHAR2_TABLE_100
37: , a7 JTF_VARCHAR2_TABLE_100
38: , a8 JTF_NUMBER_TABLE
39: , a9 JTF_VARCHAR2_TABLE_100
40: , a10 JTF_NUMBER_TABLE
41: , a11 JTF_NUMBER_TABLE

Line 39: , a9 JTF_VARCHAR2_TABLE_100

35: , a5 JTF_NUMBER_TABLE
36: , a6 JTF_VARCHAR2_TABLE_100
37: , a7 JTF_VARCHAR2_TABLE_100
38: , a8 JTF_NUMBER_TABLE
39: , a9 JTF_VARCHAR2_TABLE_100
40: , a10 JTF_NUMBER_TABLE
41: , a11 JTF_NUMBER_TABLE
42: );
43: procedure rosetta_table_copy_out_p3(t ahl_fmp_pvt.applicable_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 46: , a3 out nocopy JTF_VARCHAR2_TABLE_100

42: );
43: procedure rosetta_table_copy_out_p3(t ahl_fmp_pvt.applicable_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
44: , a1 out nocopy JTF_NUMBER_TABLE
45: , a2 out nocopy JTF_NUMBER_TABLE
46: , a3 out nocopy JTF_VARCHAR2_TABLE_100
47: , a4 out nocopy JTF_VARCHAR2_TABLE_100
48: , a5 out nocopy JTF_NUMBER_TABLE
49: , a6 out nocopy JTF_VARCHAR2_TABLE_100
50: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 47: , a4 out nocopy JTF_VARCHAR2_TABLE_100

43: procedure rosetta_table_copy_out_p3(t ahl_fmp_pvt.applicable_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
44: , a1 out nocopy JTF_NUMBER_TABLE
45: , a2 out nocopy JTF_NUMBER_TABLE
46: , a3 out nocopy JTF_VARCHAR2_TABLE_100
47: , a4 out nocopy JTF_VARCHAR2_TABLE_100
48: , a5 out nocopy JTF_NUMBER_TABLE
49: , a6 out nocopy JTF_VARCHAR2_TABLE_100
50: , a7 out nocopy JTF_VARCHAR2_TABLE_100
51: , a8 out nocopy JTF_NUMBER_TABLE

Line 49: , a6 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 50: , a7 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 52: , a9 out nocopy JTF_VARCHAR2_TABLE_100

48: , a5 out nocopy JTF_NUMBER_TABLE
49: , a6 out nocopy JTF_VARCHAR2_TABLE_100
50: , a7 out nocopy JTF_VARCHAR2_TABLE_100
51: , a8 out nocopy JTF_NUMBER_TABLE
52: , a9 out nocopy JTF_VARCHAR2_TABLE_100
53: , a10 out nocopy JTF_NUMBER_TABLE
54: , a11 out nocopy JTF_NUMBER_TABLE
55: );
56:

Line 62: , a5 JTF_VARCHAR2_TABLE_100

58: , a1 JTF_NUMBER_TABLE
59: , a2 JTF_NUMBER_TABLE
60: , a3 JTF_NUMBER_TABLE
61: , a4 JTF_NUMBER_TABLE
62: , a5 JTF_VARCHAR2_TABLE_100
63: , a6 JTF_VARCHAR2_TABLE_100
64: , a7 JTF_VARCHAR2_TABLE_100
65: , a8 JTF_VARCHAR2_TABLE_100
66: , a9 JTF_VARCHAR2_TABLE_100

Line 63: , a6 JTF_VARCHAR2_TABLE_100

59: , a2 JTF_NUMBER_TABLE
60: , a3 JTF_NUMBER_TABLE
61: , a4 JTF_NUMBER_TABLE
62: , a5 JTF_VARCHAR2_TABLE_100
63: , a6 JTF_VARCHAR2_TABLE_100
64: , a7 JTF_VARCHAR2_TABLE_100
65: , a8 JTF_VARCHAR2_TABLE_100
66: , a9 JTF_VARCHAR2_TABLE_100
67: );

Line 64: , a7 JTF_VARCHAR2_TABLE_100

60: , a3 JTF_NUMBER_TABLE
61: , a4 JTF_NUMBER_TABLE
62: , a5 JTF_VARCHAR2_TABLE_100
63: , a6 JTF_VARCHAR2_TABLE_100
64: , a7 JTF_VARCHAR2_TABLE_100
65: , a8 JTF_VARCHAR2_TABLE_100
66: , a9 JTF_VARCHAR2_TABLE_100
67: );
68: procedure rosetta_table_copy_out_p5(t ahl_fmp_pvt.applicable_activities_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 65: , a8 JTF_VARCHAR2_TABLE_100

61: , a4 JTF_NUMBER_TABLE
62: , a5 JTF_VARCHAR2_TABLE_100
63: , a6 JTF_VARCHAR2_TABLE_100
64: , a7 JTF_VARCHAR2_TABLE_100
65: , a8 JTF_VARCHAR2_TABLE_100
66: , a9 JTF_VARCHAR2_TABLE_100
67: );
68: procedure rosetta_table_copy_out_p5(t ahl_fmp_pvt.applicable_activities_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
69: , a1 out nocopy JTF_NUMBER_TABLE

Line 66: , a9 JTF_VARCHAR2_TABLE_100

62: , a5 JTF_VARCHAR2_TABLE_100
63: , a6 JTF_VARCHAR2_TABLE_100
64: , a7 JTF_VARCHAR2_TABLE_100
65: , a8 JTF_VARCHAR2_TABLE_100
66: , a9 JTF_VARCHAR2_TABLE_100
67: );
68: procedure rosetta_table_copy_out_p5(t ahl_fmp_pvt.applicable_activities_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
69: , a1 out nocopy JTF_NUMBER_TABLE
70: , a2 out nocopy JTF_NUMBER_TABLE

Line 73: , a5 out nocopy JTF_VARCHAR2_TABLE_100

69: , a1 out nocopy JTF_NUMBER_TABLE
70: , a2 out nocopy JTF_NUMBER_TABLE
71: , a3 out nocopy JTF_NUMBER_TABLE
72: , a4 out nocopy JTF_NUMBER_TABLE
73: , a5 out nocopy JTF_VARCHAR2_TABLE_100
74: , a6 out nocopy JTF_VARCHAR2_TABLE_100
75: , a7 out nocopy JTF_VARCHAR2_TABLE_100
76: , a8 out nocopy JTF_VARCHAR2_TABLE_100
77: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 74: , a6 out nocopy JTF_VARCHAR2_TABLE_100

70: , a2 out nocopy JTF_NUMBER_TABLE
71: , a3 out nocopy JTF_NUMBER_TABLE
72: , a4 out nocopy JTF_NUMBER_TABLE
73: , a5 out nocopy JTF_VARCHAR2_TABLE_100
74: , a6 out nocopy JTF_VARCHAR2_TABLE_100
75: , a7 out nocopy JTF_VARCHAR2_TABLE_100
76: , a8 out nocopy JTF_VARCHAR2_TABLE_100
77: , a9 out nocopy JTF_VARCHAR2_TABLE_100
78: );

Line 75: , a7 out nocopy JTF_VARCHAR2_TABLE_100

71: , a3 out nocopy JTF_NUMBER_TABLE
72: , a4 out nocopy JTF_NUMBER_TABLE
73: , a5 out nocopy JTF_VARCHAR2_TABLE_100
74: , a6 out nocopy JTF_VARCHAR2_TABLE_100
75: , a7 out nocopy JTF_VARCHAR2_TABLE_100
76: , a8 out nocopy JTF_VARCHAR2_TABLE_100
77: , a9 out nocopy JTF_VARCHAR2_TABLE_100
78: );
79:

Line 76: , a8 out nocopy JTF_VARCHAR2_TABLE_100

72: , a4 out nocopy JTF_NUMBER_TABLE
73: , a5 out nocopy JTF_VARCHAR2_TABLE_100
74: , a6 out nocopy JTF_VARCHAR2_TABLE_100
75: , a7 out nocopy JTF_VARCHAR2_TABLE_100
76: , a8 out nocopy JTF_VARCHAR2_TABLE_100
77: , a9 out nocopy JTF_VARCHAR2_TABLE_100
78: );
79:
80: procedure rosetta_table_copy_in_p7(t out nocopy ahl_fmp_pvt.applicable_programs_tbl_type, a0 JTF_NUMBER_TABLE

Line 77: , a9 out nocopy JTF_VARCHAR2_TABLE_100

73: , a5 out nocopy JTF_VARCHAR2_TABLE_100
74: , a6 out nocopy JTF_VARCHAR2_TABLE_100
75: , a7 out nocopy JTF_VARCHAR2_TABLE_100
76: , a8 out nocopy JTF_VARCHAR2_TABLE_100
77: , a9 out nocopy JTF_VARCHAR2_TABLE_100
78: );
79:
80: procedure rosetta_table_copy_in_p7(t out nocopy ahl_fmp_pvt.applicable_programs_tbl_type, a0 JTF_NUMBER_TABLE
81: , a1 JTF_VARCHAR2_TABLE_200

Line 83: , a3 JTF_VARCHAR2_TABLE_100

79:
80: procedure rosetta_table_copy_in_p7(t out nocopy ahl_fmp_pvt.applicable_programs_tbl_type, a0 JTF_NUMBER_TABLE
81: , a1 JTF_VARCHAR2_TABLE_200
82: , a2 JTF_VARCHAR2_TABLE_200
83: , a3 JTF_VARCHAR2_TABLE_100
84: , a4 JTF_NUMBER_TABLE
85: , a5 JTF_VARCHAR2_TABLE_300
86: , a6 JTF_VARCHAR2_TABLE_300
87: , a7 JTF_NUMBER_TABLE

Line 90: , a10 JTF_VARCHAR2_TABLE_100

86: , a6 JTF_VARCHAR2_TABLE_300
87: , a7 JTF_NUMBER_TABLE
88: , a8 JTF_VARCHAR2_TABLE_200
89: , a9 JTF_VARCHAR2_TABLE_2000
90: , a10 JTF_VARCHAR2_TABLE_100
91: , a11 JTF_VARCHAR2_TABLE_100
92: , a12 JTF_NUMBER_TABLE
93: , a13 JTF_DATE_TABLE
94: , a14 JTF_DATE_TABLE

Line 91: , a11 JTF_VARCHAR2_TABLE_100

87: , a7 JTF_NUMBER_TABLE
88: , a8 JTF_VARCHAR2_TABLE_200
89: , a9 JTF_VARCHAR2_TABLE_2000
90: , a10 JTF_VARCHAR2_TABLE_100
91: , a11 JTF_VARCHAR2_TABLE_100
92: , a12 JTF_NUMBER_TABLE
93: , a13 JTF_DATE_TABLE
94: , a14 JTF_DATE_TABLE
95: , a15 JTF_VARCHAR2_TABLE_100

Line 95: , a15 JTF_VARCHAR2_TABLE_100

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

Line 96: , a16 JTF_VARCHAR2_TABLE_100

92: , a12 JTF_NUMBER_TABLE
93: , a13 JTF_DATE_TABLE
94: , a14 JTF_DATE_TABLE
95: , a15 JTF_VARCHAR2_TABLE_100
96: , a16 JTF_VARCHAR2_TABLE_100
97: , a17 JTF_DATE_TABLE
98: , a18 JTF_DATE_TABLE
99: , a19 JTF_VARCHAR2_TABLE_100
100: , a20 JTF_VARCHAR2_TABLE_2000

Line 99: , a19 JTF_VARCHAR2_TABLE_100

95: , a15 JTF_VARCHAR2_TABLE_100
96: , a16 JTF_VARCHAR2_TABLE_100
97: , a17 JTF_DATE_TABLE
98: , a18 JTF_DATE_TABLE
99: , a19 JTF_VARCHAR2_TABLE_100
100: , a20 JTF_VARCHAR2_TABLE_2000
101: , a21 JTF_DATE_TABLE
102: , a22 JTF_VARCHAR2_TABLE_100
103: , a23 JTF_VARCHAR2_TABLE_500

Line 102: , a22 JTF_VARCHAR2_TABLE_100

98: , a18 JTF_DATE_TABLE
99: , a19 JTF_VARCHAR2_TABLE_100
100: , a20 JTF_VARCHAR2_TABLE_2000
101: , a21 JTF_DATE_TABLE
102: , a22 JTF_VARCHAR2_TABLE_100
103: , a23 JTF_VARCHAR2_TABLE_500
104: , a24 JTF_NUMBER_TABLE
105: );
106: procedure rosetta_table_copy_out_p7(t ahl_fmp_pvt.applicable_programs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 109: , a3 out nocopy JTF_VARCHAR2_TABLE_100

105: );
106: procedure rosetta_table_copy_out_p7(t ahl_fmp_pvt.applicable_programs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
107: , a1 out nocopy JTF_VARCHAR2_TABLE_200
108: , a2 out nocopy JTF_VARCHAR2_TABLE_200
109: , a3 out nocopy JTF_VARCHAR2_TABLE_100
110: , a4 out nocopy JTF_NUMBER_TABLE
111: , a5 out nocopy JTF_VARCHAR2_TABLE_300
112: , a6 out nocopy JTF_VARCHAR2_TABLE_300
113: , a7 out nocopy JTF_NUMBER_TABLE

Line 116: , a10 out nocopy JTF_VARCHAR2_TABLE_100

112: , a6 out nocopy JTF_VARCHAR2_TABLE_300
113: , a7 out nocopy JTF_NUMBER_TABLE
114: , a8 out nocopy JTF_VARCHAR2_TABLE_200
115: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
116: , a10 out nocopy JTF_VARCHAR2_TABLE_100
117: , a11 out nocopy JTF_VARCHAR2_TABLE_100
118: , a12 out nocopy JTF_NUMBER_TABLE
119: , a13 out nocopy JTF_DATE_TABLE
120: , a14 out nocopy JTF_DATE_TABLE

Line 117: , a11 out nocopy JTF_VARCHAR2_TABLE_100

113: , a7 out nocopy JTF_NUMBER_TABLE
114: , a8 out nocopy JTF_VARCHAR2_TABLE_200
115: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
116: , a10 out nocopy JTF_VARCHAR2_TABLE_100
117: , a11 out nocopy JTF_VARCHAR2_TABLE_100
118: , a12 out nocopy JTF_NUMBER_TABLE
119: , a13 out nocopy JTF_DATE_TABLE
120: , a14 out nocopy JTF_DATE_TABLE
121: , a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 121: , a15 out nocopy JTF_VARCHAR2_TABLE_100

117: , a11 out nocopy JTF_VARCHAR2_TABLE_100
118: , a12 out nocopy JTF_NUMBER_TABLE
119: , a13 out nocopy JTF_DATE_TABLE
120: , a14 out nocopy JTF_DATE_TABLE
121: , a15 out nocopy JTF_VARCHAR2_TABLE_100
122: , a16 out nocopy JTF_VARCHAR2_TABLE_100
123: , a17 out nocopy JTF_DATE_TABLE
124: , a18 out nocopy JTF_DATE_TABLE
125: , a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 122: , a16 out nocopy JTF_VARCHAR2_TABLE_100

118: , a12 out nocopy JTF_NUMBER_TABLE
119: , a13 out nocopy JTF_DATE_TABLE
120: , a14 out nocopy JTF_DATE_TABLE
121: , a15 out nocopy JTF_VARCHAR2_TABLE_100
122: , a16 out nocopy JTF_VARCHAR2_TABLE_100
123: , a17 out nocopy JTF_DATE_TABLE
124: , a18 out nocopy JTF_DATE_TABLE
125: , a19 out nocopy JTF_VARCHAR2_TABLE_100
126: , a20 out nocopy JTF_VARCHAR2_TABLE_2000

Line 125: , a19 out nocopy JTF_VARCHAR2_TABLE_100

121: , a15 out nocopy JTF_VARCHAR2_TABLE_100
122: , a16 out nocopy JTF_VARCHAR2_TABLE_100
123: , a17 out nocopy JTF_DATE_TABLE
124: , a18 out nocopy JTF_DATE_TABLE
125: , a19 out nocopy JTF_VARCHAR2_TABLE_100
126: , a20 out nocopy JTF_VARCHAR2_TABLE_2000
127: , a21 out nocopy JTF_DATE_TABLE
128: , a22 out nocopy JTF_VARCHAR2_TABLE_100
129: , a23 out nocopy JTF_VARCHAR2_TABLE_500

Line 128: , a22 out nocopy JTF_VARCHAR2_TABLE_100

124: , a18 out nocopy JTF_DATE_TABLE
125: , a19 out nocopy JTF_VARCHAR2_TABLE_100
126: , a20 out nocopy JTF_VARCHAR2_TABLE_2000
127: , a21 out nocopy JTF_DATE_TABLE
128: , a22 out nocopy JTF_VARCHAR2_TABLE_100
129: , a23 out nocopy JTF_VARCHAR2_TABLE_500
130: , a24 out nocopy JTF_NUMBER_TABLE
131: );
132:

Line 147: , p14_a0 out nocopy JTF_VARCHAR2_TABLE_100

143: , p_unique_inst_flag VARCHAR2
144: , p_sort_flag VARCHAR2
145: , p_consider_fleet_flag VARCHAR2
146: , p_flt_range_calc_date date
147: , p14_a0 out nocopy JTF_VARCHAR2_TABLE_100
148: , p14_a1 out nocopy JTF_VARCHAR2_TABLE_100
149: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_4000
150: , p14_a3 out nocopy JTF_VARCHAR2_TABLE_100
151: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 148: , p14_a1 out nocopy JTF_VARCHAR2_TABLE_100

144: , p_sort_flag VARCHAR2
145: , p_consider_fleet_flag VARCHAR2
146: , p_flt_range_calc_date date
147: , p14_a0 out nocopy JTF_VARCHAR2_TABLE_100
148: , p14_a1 out nocopy JTF_VARCHAR2_TABLE_100
149: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_4000
150: , p14_a3 out nocopy JTF_VARCHAR2_TABLE_100
151: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_400
152: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 150: , p14_a3 out nocopy JTF_VARCHAR2_TABLE_100

146: , p_flt_range_calc_date date
147: , p14_a0 out nocopy JTF_VARCHAR2_TABLE_100
148: , p14_a1 out nocopy JTF_VARCHAR2_TABLE_100
149: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_4000
150: , p14_a3 out nocopy JTF_VARCHAR2_TABLE_100
151: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_400
152: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_300
153: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_100
154: , p14_a7 out nocopy JTF_NUMBER_TABLE

Line 153: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_100

149: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_4000
150: , p14_a3 out nocopy JTF_VARCHAR2_TABLE_100
151: , p14_a4 out nocopy JTF_VARCHAR2_TABLE_400
152: , p14_a5 out nocopy JTF_VARCHAR2_TABLE_300
153: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_100
154: , p14_a7 out nocopy JTF_NUMBER_TABLE
155: , p14_a8 out nocopy JTF_NUMBER_TABLE
156: , p14_a9 out nocopy JTF_NUMBER_TABLE
157: , p14_a10 out nocopy JTF_NUMBER_TABLE

Line 158: , p14_a11 out nocopy JTF_VARCHAR2_TABLE_100

154: , p14_a7 out nocopy JTF_NUMBER_TABLE
155: , p14_a8 out nocopy JTF_NUMBER_TABLE
156: , p14_a9 out nocopy JTF_NUMBER_TABLE
157: , p14_a10 out nocopy JTF_NUMBER_TABLE
158: , p14_a11 out nocopy JTF_VARCHAR2_TABLE_100
159: );
160: procedure get_applicable_mrs(p_api_version NUMBER
161: , p_init_msg_list VARCHAR2
162: , p_commit VARCHAR2

Line 178: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100

174: , p_insert_into_tmp_tbl VARCHAR2
175: , p15_a0 out nocopy JTF_NUMBER_TABLE
176: , p15_a1 out nocopy JTF_NUMBER_TABLE
177: , p15_a2 out nocopy JTF_NUMBER_TABLE
178: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
179: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_100
180: , p15_a5 out nocopy JTF_NUMBER_TABLE
181: , p15_a6 out nocopy JTF_VARCHAR2_TABLE_100
182: , p15_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 179: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_100

175: , p15_a0 out nocopy JTF_NUMBER_TABLE
176: , p15_a1 out nocopy JTF_NUMBER_TABLE
177: , p15_a2 out nocopy JTF_NUMBER_TABLE
178: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
179: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_100
180: , p15_a5 out nocopy JTF_NUMBER_TABLE
181: , p15_a6 out nocopy JTF_VARCHAR2_TABLE_100
182: , p15_a7 out nocopy JTF_VARCHAR2_TABLE_100
183: , p15_a8 out nocopy JTF_NUMBER_TABLE

Line 181: , p15_a6 out nocopy JTF_VARCHAR2_TABLE_100

177: , p15_a2 out nocopy JTF_NUMBER_TABLE
178: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
179: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_100
180: , p15_a5 out nocopy JTF_NUMBER_TABLE
181: , p15_a6 out nocopy JTF_VARCHAR2_TABLE_100
182: , p15_a7 out nocopy JTF_VARCHAR2_TABLE_100
183: , p15_a8 out nocopy JTF_NUMBER_TABLE
184: , p15_a9 out nocopy JTF_VARCHAR2_TABLE_100
185: , p15_a10 out nocopy JTF_NUMBER_TABLE

Line 182: , p15_a7 out nocopy JTF_VARCHAR2_TABLE_100

178: , p15_a3 out nocopy JTF_VARCHAR2_TABLE_100
179: , p15_a4 out nocopy JTF_VARCHAR2_TABLE_100
180: , p15_a5 out nocopy JTF_NUMBER_TABLE
181: , p15_a6 out nocopy JTF_VARCHAR2_TABLE_100
182: , p15_a7 out nocopy JTF_VARCHAR2_TABLE_100
183: , p15_a8 out nocopy JTF_NUMBER_TABLE
184: , p15_a9 out nocopy JTF_VARCHAR2_TABLE_100
185: , p15_a10 out nocopy JTF_NUMBER_TABLE
186: , p15_a11 out nocopy JTF_NUMBER_TABLE

Line 184: , p15_a9 out nocopy JTF_VARCHAR2_TABLE_100

180: , p15_a5 out nocopy JTF_NUMBER_TABLE
181: , p15_a6 out nocopy JTF_VARCHAR2_TABLE_100
182: , p15_a7 out nocopy JTF_VARCHAR2_TABLE_100
183: , p15_a8 out nocopy JTF_NUMBER_TABLE
184: , p15_a9 out nocopy JTF_VARCHAR2_TABLE_100
185: , p15_a10 out nocopy JTF_NUMBER_TABLE
186: , p15_a11 out nocopy JTF_NUMBER_TABLE
187: );
188: procedure get_pm_applicable_mrs(p_api_version NUMBER

Line 201: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100

197: , p8_a1 out nocopy JTF_NUMBER_TABLE
198: , p8_a2 out nocopy JTF_NUMBER_TABLE
199: , p8_a3 out nocopy JTF_NUMBER_TABLE
200: , p8_a4 out nocopy JTF_NUMBER_TABLE
201: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
202: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
203: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
204: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
205: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 202: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100

198: , p8_a2 out nocopy JTF_NUMBER_TABLE
199: , p8_a3 out nocopy JTF_NUMBER_TABLE
200: , p8_a4 out nocopy JTF_NUMBER_TABLE
201: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
202: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
203: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
204: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
205: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
206: , p9_a0 out nocopy JTF_NUMBER_TABLE

Line 203: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100

199: , p8_a3 out nocopy JTF_NUMBER_TABLE
200: , p8_a4 out nocopy JTF_NUMBER_TABLE
201: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
202: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
203: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
204: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
205: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
206: , p9_a0 out nocopy JTF_NUMBER_TABLE
207: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200

Line 204: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100

200: , p8_a4 out nocopy JTF_NUMBER_TABLE
201: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
202: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
203: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
204: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
205: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
206: , p9_a0 out nocopy JTF_NUMBER_TABLE
207: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
208: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200

Line 205: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100

201: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
202: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
203: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
204: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
205: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
206: , p9_a0 out nocopy JTF_NUMBER_TABLE
207: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
208: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
209: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 209: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100

205: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
206: , p9_a0 out nocopy JTF_NUMBER_TABLE
207: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
208: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
209: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
210: , p9_a4 out nocopy JTF_NUMBER_TABLE
211: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
212: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_300
213: , p9_a7 out nocopy JTF_NUMBER_TABLE

Line 216: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100

212: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_300
213: , p9_a7 out nocopy JTF_NUMBER_TABLE
214: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200
215: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_2000
216: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
217: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
218: , p9_a12 out nocopy JTF_NUMBER_TABLE
219: , p9_a13 out nocopy JTF_DATE_TABLE
220: , p9_a14 out nocopy JTF_DATE_TABLE

Line 217: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100

213: , p9_a7 out nocopy JTF_NUMBER_TABLE
214: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200
215: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_2000
216: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
217: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
218: , p9_a12 out nocopy JTF_NUMBER_TABLE
219: , p9_a13 out nocopy JTF_DATE_TABLE
220: , p9_a14 out nocopy JTF_DATE_TABLE
221: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 221: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100

217: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
218: , p9_a12 out nocopy JTF_NUMBER_TABLE
219: , p9_a13 out nocopy JTF_DATE_TABLE
220: , p9_a14 out nocopy JTF_DATE_TABLE
221: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
222: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
223: , p9_a17 out nocopy JTF_DATE_TABLE
224: , p9_a18 out nocopy JTF_DATE_TABLE
225: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 222: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100

218: , p9_a12 out nocopy JTF_NUMBER_TABLE
219: , p9_a13 out nocopy JTF_DATE_TABLE
220: , p9_a14 out nocopy JTF_DATE_TABLE
221: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
222: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
223: , p9_a17 out nocopy JTF_DATE_TABLE
224: , p9_a18 out nocopy JTF_DATE_TABLE
225: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
226: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_2000

Line 225: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100

221: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
222: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
223: , p9_a17 out nocopy JTF_DATE_TABLE
224: , p9_a18 out nocopy JTF_DATE_TABLE
225: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
226: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_2000
227: , p9_a21 out nocopy JTF_DATE_TABLE
228: , p9_a22 out nocopy JTF_VARCHAR2_TABLE_100
229: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500

Line 228: , p9_a22 out nocopy JTF_VARCHAR2_TABLE_100

224: , p9_a18 out nocopy JTF_DATE_TABLE
225: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
226: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_2000
227: , p9_a21 out nocopy JTF_DATE_TABLE
228: , p9_a22 out nocopy JTF_VARCHAR2_TABLE_100
229: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
230: , p9_a24 out nocopy JTF_NUMBER_TABLE
231: );
232: procedure get_mr_applicability(p_api_version NUMBER

Line 246: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100

242: , p_include_donotimplmt VARCHAR2
243: , p11_a0 out nocopy JTF_NUMBER_TABLE
244: , p11_a1 out nocopy JTF_NUMBER_TABLE
245: , p11_a2 out nocopy JTF_NUMBER_TABLE
246: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
247: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
248: , p11_a5 out nocopy JTF_NUMBER_TABLE
249: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
250: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 247: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100

243: , p11_a0 out nocopy JTF_NUMBER_TABLE
244: , p11_a1 out nocopy JTF_NUMBER_TABLE
245: , p11_a2 out nocopy JTF_NUMBER_TABLE
246: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
247: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
248: , p11_a5 out nocopy JTF_NUMBER_TABLE
249: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
250: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
251: , p11_a8 out nocopy JTF_NUMBER_TABLE

Line 249: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100

245: , p11_a2 out nocopy JTF_NUMBER_TABLE
246: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
247: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
248: , p11_a5 out nocopy JTF_NUMBER_TABLE
249: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
250: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
251: , p11_a8 out nocopy JTF_NUMBER_TABLE
252: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
253: , p11_a10 out nocopy JTF_NUMBER_TABLE

Line 250: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100

246: , p11_a3 out nocopy JTF_VARCHAR2_TABLE_100
247: , p11_a4 out nocopy JTF_VARCHAR2_TABLE_100
248: , p11_a5 out nocopy JTF_NUMBER_TABLE
249: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
250: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
251: , p11_a8 out nocopy JTF_NUMBER_TABLE
252: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
253: , p11_a10 out nocopy JTF_NUMBER_TABLE
254: , p11_a11 out nocopy JTF_NUMBER_TABLE

Line 252: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100

248: , p11_a5 out nocopy JTF_NUMBER_TABLE
249: , p11_a6 out nocopy JTF_VARCHAR2_TABLE_100
250: , p11_a7 out nocopy JTF_VARCHAR2_TABLE_100
251: , p11_a8 out nocopy JTF_NUMBER_TABLE
252: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100
253: , p11_a10 out nocopy JTF_NUMBER_TABLE
254: , p11_a11 out nocopy JTF_NUMBER_TABLE
255: );
256: end ahl_fmp_pvt_w;