APPS.AHL_FMP_EFFECTIVITY_DTL_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package ahl_fmp_effectivity_dtl_pvt_w AUTHID CURRENT_USER as
2: /* $Header: AHLWMEDS.pls 120.3.12020000.2 2012/12/13 05:54:31 shnatu ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_effectivity_dtl_pvt.effectivity_detail_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: AHLWMEDS.pls 120.3.12020000.2 2012/12/13 05:54:31 shnatu ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_effectivity_dtl_pvt.effectivity_detail_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_DATE_TABLE

Line 7: , a4 JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_fmp_effectivity_dtl_pvt.effectivity_detail_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE

Line 9: , a6 JTF_VARCHAR2_TABLE_100

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

Line 12: , a9 JTF_VARCHAR2_TABLE_100

8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_200
16: , a13 JTF_VARCHAR2_TABLE_200

Line 13: , a10 JTF_VARCHAR2_TABLE_100

9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_VARCHAR2_TABLE_200
16: , a13 JTF_VARCHAR2_TABLE_200
17: , a14 JTF_VARCHAR2_TABLE_200

Line 14: , a11 JTF_VARCHAR2_TABLE_100

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

Line 35: , a32 JTF_VARCHAR2_TABLE_100

31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_DATE_TABLE
33: , a30 JTF_NUMBER_TABLE
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
36: );
37: procedure rosetta_table_copy_out_p1(t ahl_fmp_effectivity_dtl_pvt.effectivity_detail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
38: , a1 out nocopy JTF_NUMBER_TABLE
39: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 39: , a2 out nocopy JTF_VARCHAR2_TABLE_100

35: , a32 JTF_VARCHAR2_TABLE_100
36: );
37: procedure rosetta_table_copy_out_p1(t ahl_fmp_effectivity_dtl_pvt.effectivity_detail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
38: , a1 out nocopy JTF_NUMBER_TABLE
39: , a2 out nocopy JTF_VARCHAR2_TABLE_100
40: , a3 out nocopy JTF_VARCHAR2_TABLE_100
41: , a4 out nocopy JTF_VARCHAR2_TABLE_100
42: , a5 out nocopy JTF_NUMBER_TABLE
43: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 40: , a3 out nocopy JTF_VARCHAR2_TABLE_100

36: );
37: procedure rosetta_table_copy_out_p1(t ahl_fmp_effectivity_dtl_pvt.effectivity_detail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
38: , a1 out nocopy JTF_NUMBER_TABLE
39: , a2 out nocopy JTF_VARCHAR2_TABLE_100
40: , a3 out nocopy JTF_VARCHAR2_TABLE_100
41: , a4 out nocopy JTF_VARCHAR2_TABLE_100
42: , a5 out nocopy JTF_NUMBER_TABLE
43: , a6 out nocopy JTF_VARCHAR2_TABLE_100
44: , a7 out nocopy JTF_DATE_TABLE

Line 41: , a4 out nocopy JTF_VARCHAR2_TABLE_100

37: procedure rosetta_table_copy_out_p1(t ahl_fmp_effectivity_dtl_pvt.effectivity_detail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
38: , a1 out nocopy JTF_NUMBER_TABLE
39: , a2 out nocopy JTF_VARCHAR2_TABLE_100
40: , a3 out nocopy JTF_VARCHAR2_TABLE_100
41: , a4 out nocopy JTF_VARCHAR2_TABLE_100
42: , a5 out nocopy JTF_NUMBER_TABLE
43: , a6 out nocopy JTF_VARCHAR2_TABLE_100
44: , a7 out nocopy JTF_DATE_TABLE
45: , a8 out nocopy JTF_DATE_TABLE

Line 43: , a6 out nocopy JTF_VARCHAR2_TABLE_100

39: , a2 out nocopy JTF_VARCHAR2_TABLE_100
40: , a3 out nocopy JTF_VARCHAR2_TABLE_100
41: , a4 out nocopy JTF_VARCHAR2_TABLE_100
42: , a5 out nocopy JTF_NUMBER_TABLE
43: , a6 out nocopy JTF_VARCHAR2_TABLE_100
44: , a7 out nocopy JTF_DATE_TABLE
45: , a8 out nocopy JTF_DATE_TABLE
46: , a9 out nocopy JTF_VARCHAR2_TABLE_100
47: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 46: , a9 out nocopy JTF_VARCHAR2_TABLE_100

42: , a5 out nocopy JTF_NUMBER_TABLE
43: , a6 out nocopy JTF_VARCHAR2_TABLE_100
44: , a7 out nocopy JTF_DATE_TABLE
45: , a8 out nocopy JTF_DATE_TABLE
46: , a9 out nocopy JTF_VARCHAR2_TABLE_100
47: , a10 out nocopy JTF_VARCHAR2_TABLE_100
48: , a11 out nocopy JTF_VARCHAR2_TABLE_100
49: , a12 out nocopy JTF_VARCHAR2_TABLE_200
50: , a13 out nocopy JTF_VARCHAR2_TABLE_200

Line 47: , a10 out nocopy JTF_VARCHAR2_TABLE_100

43: , a6 out nocopy JTF_VARCHAR2_TABLE_100
44: , a7 out nocopy JTF_DATE_TABLE
45: , a8 out nocopy JTF_DATE_TABLE
46: , a9 out nocopy JTF_VARCHAR2_TABLE_100
47: , a10 out nocopy JTF_VARCHAR2_TABLE_100
48: , a11 out nocopy JTF_VARCHAR2_TABLE_100
49: , a12 out nocopy JTF_VARCHAR2_TABLE_200
50: , a13 out nocopy JTF_VARCHAR2_TABLE_200
51: , a14 out nocopy JTF_VARCHAR2_TABLE_200

Line 48: , a11 out nocopy JTF_VARCHAR2_TABLE_100

44: , a7 out nocopy JTF_DATE_TABLE
45: , a8 out nocopy JTF_DATE_TABLE
46: , a9 out nocopy JTF_VARCHAR2_TABLE_100
47: , a10 out nocopy JTF_VARCHAR2_TABLE_100
48: , a11 out nocopy JTF_VARCHAR2_TABLE_100
49: , a12 out nocopy JTF_VARCHAR2_TABLE_200
50: , a13 out nocopy JTF_VARCHAR2_TABLE_200
51: , a14 out nocopy JTF_VARCHAR2_TABLE_200
52: , a15 out nocopy JTF_VARCHAR2_TABLE_200

Line 69: , a32 out nocopy JTF_VARCHAR2_TABLE_100

65: , a28 out nocopy JTF_NUMBER_TABLE
66: , a29 out nocopy JTF_DATE_TABLE
67: , a30 out nocopy JTF_NUMBER_TABLE
68: , a31 out nocopy JTF_NUMBER_TABLE
69: , a32 out nocopy JTF_VARCHAR2_TABLE_100
70: );
71:
72: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_effectivity_dtl_pvt.effty_ext_detail_tbl_type, a0 JTF_NUMBER_TABLE
73: , a1 JTF_NUMBER_TABLE

Line 74: , a2 JTF_VARCHAR2_TABLE_100

70: );
71:
72: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_effectivity_dtl_pvt.effty_ext_detail_tbl_type, a0 JTF_NUMBER_TABLE
73: , a1 JTF_NUMBER_TABLE
74: , a2 JTF_VARCHAR2_TABLE_100
75: , a3 JTF_VARCHAR2_TABLE_100
76: , a4 JTF_NUMBER_TABLE
77: , a5 JTF_VARCHAR2_TABLE_400
78: , a6 JTF_VARCHAR2_TABLE_100

Line 75: , a3 JTF_VARCHAR2_TABLE_100

71:
72: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_effectivity_dtl_pvt.effty_ext_detail_tbl_type, a0 JTF_NUMBER_TABLE
73: , a1 JTF_NUMBER_TABLE
74: , a2 JTF_VARCHAR2_TABLE_100
75: , a3 JTF_VARCHAR2_TABLE_100
76: , a4 JTF_NUMBER_TABLE
77: , a5 JTF_VARCHAR2_TABLE_400
78: , a6 JTF_VARCHAR2_TABLE_100
79: , a7 JTF_VARCHAR2_TABLE_100

Line 78: , a6 JTF_VARCHAR2_TABLE_100

74: , a2 JTF_VARCHAR2_TABLE_100
75: , a3 JTF_VARCHAR2_TABLE_100
76: , a4 JTF_NUMBER_TABLE
77: , a5 JTF_VARCHAR2_TABLE_400
78: , a6 JTF_VARCHAR2_TABLE_100
79: , a7 JTF_VARCHAR2_TABLE_100
80: , a8 JTF_VARCHAR2_TABLE_100
81: , a9 JTF_VARCHAR2_TABLE_100
82: , a10 JTF_VARCHAR2_TABLE_300

Line 79: , a7 JTF_VARCHAR2_TABLE_100

75: , a3 JTF_VARCHAR2_TABLE_100
76: , a4 JTF_NUMBER_TABLE
77: , a5 JTF_VARCHAR2_TABLE_400
78: , a6 JTF_VARCHAR2_TABLE_100
79: , a7 JTF_VARCHAR2_TABLE_100
80: , a8 JTF_VARCHAR2_TABLE_100
81: , a9 JTF_VARCHAR2_TABLE_100
82: , a10 JTF_VARCHAR2_TABLE_300
83: , a11 JTF_VARCHAR2_TABLE_100

Line 80: , a8 JTF_VARCHAR2_TABLE_100

76: , a4 JTF_NUMBER_TABLE
77: , a5 JTF_VARCHAR2_TABLE_400
78: , a6 JTF_VARCHAR2_TABLE_100
79: , a7 JTF_VARCHAR2_TABLE_100
80: , a8 JTF_VARCHAR2_TABLE_100
81: , a9 JTF_VARCHAR2_TABLE_100
82: , a10 JTF_VARCHAR2_TABLE_300
83: , a11 JTF_VARCHAR2_TABLE_100
84: , a12 JTF_VARCHAR2_TABLE_200

Line 81: , a9 JTF_VARCHAR2_TABLE_100

77: , a5 JTF_VARCHAR2_TABLE_400
78: , a6 JTF_VARCHAR2_TABLE_100
79: , a7 JTF_VARCHAR2_TABLE_100
80: , a8 JTF_VARCHAR2_TABLE_100
81: , a9 JTF_VARCHAR2_TABLE_100
82: , a10 JTF_VARCHAR2_TABLE_300
83: , a11 JTF_VARCHAR2_TABLE_100
84: , a12 JTF_VARCHAR2_TABLE_200
85: , a13 JTF_VARCHAR2_TABLE_200

Line 83: , a11 JTF_VARCHAR2_TABLE_100

79: , a7 JTF_VARCHAR2_TABLE_100
80: , a8 JTF_VARCHAR2_TABLE_100
81: , a9 JTF_VARCHAR2_TABLE_100
82: , a10 JTF_VARCHAR2_TABLE_300
83: , a11 JTF_VARCHAR2_TABLE_100
84: , a12 JTF_VARCHAR2_TABLE_200
85: , a13 JTF_VARCHAR2_TABLE_200
86: , a14 JTF_VARCHAR2_TABLE_200
87: , a15 JTF_VARCHAR2_TABLE_200

Line 104: , a32 JTF_VARCHAR2_TABLE_100

100: , a28 JTF_NUMBER_TABLE
101: , a29 JTF_DATE_TABLE
102: , a30 JTF_NUMBER_TABLE
103: , a31 JTF_NUMBER_TABLE
104: , a32 JTF_VARCHAR2_TABLE_100
105: );
106: procedure rosetta_table_copy_out_p3(t ahl_fmp_effectivity_dtl_pvt.effty_ext_detail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
107: , a1 out nocopy JTF_NUMBER_TABLE
108: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 108: , a2 out nocopy JTF_VARCHAR2_TABLE_100

104: , a32 JTF_VARCHAR2_TABLE_100
105: );
106: procedure rosetta_table_copy_out_p3(t ahl_fmp_effectivity_dtl_pvt.effty_ext_detail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
107: , a1 out nocopy JTF_NUMBER_TABLE
108: , a2 out nocopy JTF_VARCHAR2_TABLE_100
109: , a3 out nocopy JTF_VARCHAR2_TABLE_100
110: , a4 out nocopy JTF_NUMBER_TABLE
111: , a5 out nocopy JTF_VARCHAR2_TABLE_400
112: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 109: , a3 out nocopy JTF_VARCHAR2_TABLE_100

105: );
106: procedure rosetta_table_copy_out_p3(t ahl_fmp_effectivity_dtl_pvt.effty_ext_detail_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
107: , a1 out nocopy JTF_NUMBER_TABLE
108: , a2 out nocopy JTF_VARCHAR2_TABLE_100
109: , a3 out nocopy JTF_VARCHAR2_TABLE_100
110: , a4 out nocopy JTF_NUMBER_TABLE
111: , a5 out nocopy JTF_VARCHAR2_TABLE_400
112: , a6 out nocopy JTF_VARCHAR2_TABLE_100
113: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 112: , a6 out nocopy JTF_VARCHAR2_TABLE_100

108: , a2 out nocopy JTF_VARCHAR2_TABLE_100
109: , a3 out nocopy JTF_VARCHAR2_TABLE_100
110: , a4 out nocopy JTF_NUMBER_TABLE
111: , a5 out nocopy JTF_VARCHAR2_TABLE_400
112: , a6 out nocopy JTF_VARCHAR2_TABLE_100
113: , a7 out nocopy JTF_VARCHAR2_TABLE_100
114: , a8 out nocopy JTF_VARCHAR2_TABLE_100
115: , a9 out nocopy JTF_VARCHAR2_TABLE_100
116: , a10 out nocopy JTF_VARCHAR2_TABLE_300

Line 113: , a7 out nocopy JTF_VARCHAR2_TABLE_100

109: , a3 out nocopy JTF_VARCHAR2_TABLE_100
110: , a4 out nocopy JTF_NUMBER_TABLE
111: , a5 out nocopy JTF_VARCHAR2_TABLE_400
112: , a6 out nocopy JTF_VARCHAR2_TABLE_100
113: , a7 out nocopy JTF_VARCHAR2_TABLE_100
114: , a8 out nocopy JTF_VARCHAR2_TABLE_100
115: , a9 out nocopy JTF_VARCHAR2_TABLE_100
116: , a10 out nocopy JTF_VARCHAR2_TABLE_300
117: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 114: , a8 out nocopy JTF_VARCHAR2_TABLE_100

110: , a4 out nocopy JTF_NUMBER_TABLE
111: , a5 out nocopy JTF_VARCHAR2_TABLE_400
112: , a6 out nocopy JTF_VARCHAR2_TABLE_100
113: , a7 out nocopy JTF_VARCHAR2_TABLE_100
114: , a8 out nocopy JTF_VARCHAR2_TABLE_100
115: , a9 out nocopy JTF_VARCHAR2_TABLE_100
116: , a10 out nocopy JTF_VARCHAR2_TABLE_300
117: , a11 out nocopy JTF_VARCHAR2_TABLE_100
118: , a12 out nocopy JTF_VARCHAR2_TABLE_200

Line 115: , a9 out nocopy JTF_VARCHAR2_TABLE_100

111: , a5 out nocopy JTF_VARCHAR2_TABLE_400
112: , a6 out nocopy JTF_VARCHAR2_TABLE_100
113: , a7 out nocopy JTF_VARCHAR2_TABLE_100
114: , a8 out nocopy JTF_VARCHAR2_TABLE_100
115: , a9 out nocopy JTF_VARCHAR2_TABLE_100
116: , a10 out nocopy JTF_VARCHAR2_TABLE_300
117: , a11 out nocopy JTF_VARCHAR2_TABLE_100
118: , a12 out nocopy JTF_VARCHAR2_TABLE_200
119: , a13 out nocopy JTF_VARCHAR2_TABLE_200

Line 117: , a11 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 138: , a32 out nocopy JTF_VARCHAR2_TABLE_100

134: , a28 out nocopy JTF_NUMBER_TABLE
135: , a29 out nocopy JTF_DATE_TABLE
136: , a30 out nocopy JTF_NUMBER_TABLE
137: , a31 out nocopy JTF_NUMBER_TABLE
138: , a32 out nocopy JTF_VARCHAR2_TABLE_100
139: );
140:
141: procedure process_effectivity_detail(p_api_version NUMBER
142: , p_init_msg_list VARCHAR2

Line 152: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100

148: , x_msg_count out nocopy NUMBER
149: , x_msg_data out nocopy VARCHAR2
150: , p9_a0 in out nocopy JTF_NUMBER_TABLE
151: , p9_a1 in out nocopy JTF_NUMBER_TABLE
152: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
153: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
154: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
155: , p9_a5 in out nocopy JTF_NUMBER_TABLE
156: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 153: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100

149: , x_msg_data out nocopy VARCHAR2
150: , p9_a0 in out nocopy JTF_NUMBER_TABLE
151: , p9_a1 in out nocopy JTF_NUMBER_TABLE
152: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
153: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
154: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
155: , p9_a5 in out nocopy JTF_NUMBER_TABLE
156: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
157: , p9_a7 in out nocopy JTF_DATE_TABLE

Line 154: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100

150: , p9_a0 in out nocopy JTF_NUMBER_TABLE
151: , p9_a1 in out nocopy JTF_NUMBER_TABLE
152: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
153: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
154: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
155: , p9_a5 in out nocopy JTF_NUMBER_TABLE
156: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
157: , p9_a7 in out nocopy JTF_DATE_TABLE
158: , p9_a8 in out nocopy JTF_DATE_TABLE

Line 156: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100

152: , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
153: , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
154: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
155: , p9_a5 in out nocopy JTF_NUMBER_TABLE
156: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
157: , p9_a7 in out nocopy JTF_DATE_TABLE
158: , p9_a8 in out nocopy JTF_DATE_TABLE
159: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
160: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100

Line 159: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100

155: , p9_a5 in out nocopy JTF_NUMBER_TABLE
156: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
157: , p9_a7 in out nocopy JTF_DATE_TABLE
158: , p9_a8 in out nocopy JTF_DATE_TABLE
159: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
160: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
161: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
162: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_200
163: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_200

Line 160: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100

156: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
157: , p9_a7 in out nocopy JTF_DATE_TABLE
158: , p9_a8 in out nocopy JTF_DATE_TABLE
159: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
160: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
161: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
162: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_200
163: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_200
164: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_200

Line 161: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100

157: , p9_a7 in out nocopy JTF_DATE_TABLE
158: , p9_a8 in out nocopy JTF_DATE_TABLE
159: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_100
160: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_100
161: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_100
162: , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_200
163: , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_200
164: , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_200
165: , p9_a15 in out nocopy JTF_VARCHAR2_TABLE_200

Line 182: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_100

178: , p9_a28 in out nocopy JTF_NUMBER_TABLE
179: , p9_a29 in out nocopy JTF_DATE_TABLE
180: , p9_a30 in out nocopy JTF_NUMBER_TABLE
181: , p9_a31 in out nocopy JTF_NUMBER_TABLE
182: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_100
183: , p10_a0 in out nocopy JTF_NUMBER_TABLE
184: , p10_a1 in out nocopy JTF_NUMBER_TABLE
185: , p10_a2 in out nocopy JTF_VARCHAR2_TABLE_100
186: , p10_a3 in out nocopy JTF_VARCHAR2_TABLE_100

Line 185: , p10_a2 in out nocopy JTF_VARCHAR2_TABLE_100

181: , p9_a31 in out nocopy JTF_NUMBER_TABLE
182: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_100
183: , p10_a0 in out nocopy JTF_NUMBER_TABLE
184: , p10_a1 in out nocopy JTF_NUMBER_TABLE
185: , p10_a2 in out nocopy JTF_VARCHAR2_TABLE_100
186: , p10_a3 in out nocopy JTF_VARCHAR2_TABLE_100
187: , p10_a4 in out nocopy JTF_NUMBER_TABLE
188: , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_400
189: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 186: , p10_a3 in out nocopy JTF_VARCHAR2_TABLE_100

182: , p9_a32 in out nocopy JTF_VARCHAR2_TABLE_100
183: , p10_a0 in out nocopy JTF_NUMBER_TABLE
184: , p10_a1 in out nocopy JTF_NUMBER_TABLE
185: , p10_a2 in out nocopy JTF_VARCHAR2_TABLE_100
186: , p10_a3 in out nocopy JTF_VARCHAR2_TABLE_100
187: , p10_a4 in out nocopy JTF_NUMBER_TABLE
188: , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_400
189: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
190: , p10_a7 in out nocopy JTF_VARCHAR2_TABLE_100

Line 189: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100

185: , p10_a2 in out nocopy JTF_VARCHAR2_TABLE_100
186: , p10_a3 in out nocopy JTF_VARCHAR2_TABLE_100
187: , p10_a4 in out nocopy JTF_NUMBER_TABLE
188: , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_400
189: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
190: , p10_a7 in out nocopy JTF_VARCHAR2_TABLE_100
191: , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100
192: , p10_a9 in out nocopy JTF_VARCHAR2_TABLE_100
193: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_300

Line 190: , p10_a7 in out nocopy JTF_VARCHAR2_TABLE_100

186: , p10_a3 in out nocopy JTF_VARCHAR2_TABLE_100
187: , p10_a4 in out nocopy JTF_NUMBER_TABLE
188: , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_400
189: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
190: , p10_a7 in out nocopy JTF_VARCHAR2_TABLE_100
191: , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100
192: , p10_a9 in out nocopy JTF_VARCHAR2_TABLE_100
193: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_300
194: , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_100

Line 191: , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100

187: , p10_a4 in out nocopy JTF_NUMBER_TABLE
188: , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_400
189: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
190: , p10_a7 in out nocopy JTF_VARCHAR2_TABLE_100
191: , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100
192: , p10_a9 in out nocopy JTF_VARCHAR2_TABLE_100
193: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_300
194: , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_100
195: , p10_a12 in out nocopy JTF_VARCHAR2_TABLE_200

Line 192: , p10_a9 in out nocopy JTF_VARCHAR2_TABLE_100

188: , p10_a5 in out nocopy JTF_VARCHAR2_TABLE_400
189: , p10_a6 in out nocopy JTF_VARCHAR2_TABLE_100
190: , p10_a7 in out nocopy JTF_VARCHAR2_TABLE_100
191: , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100
192: , p10_a9 in out nocopy JTF_VARCHAR2_TABLE_100
193: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_300
194: , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_100
195: , p10_a12 in out nocopy JTF_VARCHAR2_TABLE_200
196: , p10_a13 in out nocopy JTF_VARCHAR2_TABLE_200

Line 194: , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_100

190: , p10_a7 in out nocopy JTF_VARCHAR2_TABLE_100
191: , p10_a8 in out nocopy JTF_VARCHAR2_TABLE_100
192: , p10_a9 in out nocopy JTF_VARCHAR2_TABLE_100
193: , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_300
194: , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_100
195: , p10_a12 in out nocopy JTF_VARCHAR2_TABLE_200
196: , p10_a13 in out nocopy JTF_VARCHAR2_TABLE_200
197: , p10_a14 in out nocopy JTF_VARCHAR2_TABLE_200
198: , p10_a15 in out nocopy JTF_VARCHAR2_TABLE_200

Line 215: , p10_a32 in out nocopy JTF_VARCHAR2_TABLE_100

211: , p10_a28 in out nocopy JTF_NUMBER_TABLE
212: , p10_a29 in out nocopy JTF_DATE_TABLE
213: , p10_a30 in out nocopy JTF_NUMBER_TABLE
214: , p10_a31 in out nocopy JTF_NUMBER_TABLE
215: , p10_a32 in out nocopy JTF_VARCHAR2_TABLE_100
216: , p_mr_header_id NUMBER
217: , p_mr_effectivity_id NUMBER
218: );
219: end ahl_fmp_effectivity_dtl_pvt_w;