DBA Data[Home] [Help]

APPS.AHL_FMP_PVT_W dependencies on JTF_NUMBER_TABLE

Line 10: , a7 JTF_NUMBER_TABLE

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
14: );

Line 11: , a8 JTF_NUMBER_TABLE

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
14: );
15: procedure rosetta_table_copy_out_p1(t ahl_fmp_pvt.mr_item_instance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

Line 12: , a9 JTF_NUMBER_TABLE

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
14: );
15: procedure rosetta_table_copy_out_p1(t ahl_fmp_pvt.mr_item_instance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
16: , a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 13: , a10 JTF_NUMBER_TABLE

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
14: );
15: procedure rosetta_table_copy_out_p1(t ahl_fmp_pvt.mr_item_instance_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
16: , a1 out nocopy JTF_VARCHAR2_TABLE_100
17: , a2 out nocopy JTF_VARCHAR2_TABLE_4000

Line 22: , a7 out nocopy JTF_NUMBER_TABLE

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

Line 23: , a8 out nocopy JTF_NUMBER_TABLE

19: , a4 out nocopy JTF_VARCHAR2_TABLE_400
20: , a5 out nocopy JTF_VARCHAR2_TABLE_300
21: , a6 out nocopy JTF_VARCHAR2_TABLE_100
22: , a7 out nocopy JTF_NUMBER_TABLE
23: , a8 out nocopy JTF_NUMBER_TABLE
24: , a9 out nocopy JTF_NUMBER_TABLE
25: , a10 out nocopy JTF_NUMBER_TABLE
26: );
27:

Line 24: , a9 out nocopy JTF_NUMBER_TABLE

20: , a5 out nocopy JTF_VARCHAR2_TABLE_300
21: , a6 out nocopy JTF_VARCHAR2_TABLE_100
22: , a7 out nocopy JTF_NUMBER_TABLE
23: , a8 out nocopy JTF_NUMBER_TABLE
24: , a9 out nocopy JTF_NUMBER_TABLE
25: , a10 out nocopy JTF_NUMBER_TABLE
26: );
27:
28: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_pvt.applicable_mr_tbl_type, a0 JTF_NUMBER_TABLE

Line 25: , a10 out nocopy JTF_NUMBER_TABLE

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

Line 28: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_pvt.applicable_mr_tbl_type, a0 JTF_NUMBER_TABLE

24: , a9 out nocopy JTF_NUMBER_TABLE
25: , a10 out nocopy JTF_NUMBER_TABLE
26: );
27:
28: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_pvt.applicable_mr_tbl_type, a0 JTF_NUMBER_TABLE
29: , a1 JTF_NUMBER_TABLE
30: , a2 JTF_NUMBER_TABLE
31: , a3 JTF_VARCHAR2_TABLE_100
32: , a4 JTF_VARCHAR2_TABLE_100

Line 29: , a1 JTF_NUMBER_TABLE

25: , a10 out nocopy JTF_NUMBER_TABLE
26: );
27:
28: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_pvt.applicable_mr_tbl_type, a0 JTF_NUMBER_TABLE
29: , a1 JTF_NUMBER_TABLE
30: , a2 JTF_NUMBER_TABLE
31: , a3 JTF_VARCHAR2_TABLE_100
32: , a4 JTF_VARCHAR2_TABLE_100
33: , a5 JTF_NUMBER_TABLE

Line 30: , a2 JTF_NUMBER_TABLE

26: );
27:
28: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_pvt.applicable_mr_tbl_type, a0 JTF_NUMBER_TABLE
29: , a1 JTF_NUMBER_TABLE
30: , a2 JTF_NUMBER_TABLE
31: , a3 JTF_VARCHAR2_TABLE_100
32: , a4 JTF_VARCHAR2_TABLE_100
33: , a5 JTF_NUMBER_TABLE
34: , a6 JTF_VARCHAR2_TABLE_100

Line 33: , a5 JTF_NUMBER_TABLE

29: , a1 JTF_NUMBER_TABLE
30: , a2 JTF_NUMBER_TABLE
31: , a3 JTF_VARCHAR2_TABLE_100
32: , a4 JTF_VARCHAR2_TABLE_100
33: , a5 JTF_NUMBER_TABLE
34: , a6 JTF_VARCHAR2_TABLE_100
35: , a7 JTF_VARCHAR2_TABLE_100
36: , a8 JTF_NUMBER_TABLE
37: );

Line 36: , a8 JTF_NUMBER_TABLE

32: , a4 JTF_VARCHAR2_TABLE_100
33: , a5 JTF_NUMBER_TABLE
34: , a6 JTF_VARCHAR2_TABLE_100
35: , a7 JTF_VARCHAR2_TABLE_100
36: , a8 JTF_NUMBER_TABLE
37: );
38: procedure rosetta_table_copy_out_p3(t ahl_fmp_pvt.applicable_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_NUMBER_TABLE
40: , a2 out nocopy JTF_NUMBER_TABLE

Line 38: procedure rosetta_table_copy_out_p3(t ahl_fmp_pvt.applicable_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

34: , a6 JTF_VARCHAR2_TABLE_100
35: , a7 JTF_VARCHAR2_TABLE_100
36: , a8 JTF_NUMBER_TABLE
37: );
38: procedure rosetta_table_copy_out_p3(t ahl_fmp_pvt.applicable_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_NUMBER_TABLE
40: , a2 out nocopy JTF_NUMBER_TABLE
41: , a3 out nocopy JTF_VARCHAR2_TABLE_100
42: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 39: , a1 out nocopy JTF_NUMBER_TABLE

35: , a7 JTF_VARCHAR2_TABLE_100
36: , a8 JTF_NUMBER_TABLE
37: );
38: procedure rosetta_table_copy_out_p3(t ahl_fmp_pvt.applicable_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_NUMBER_TABLE
40: , a2 out nocopy JTF_NUMBER_TABLE
41: , a3 out nocopy JTF_VARCHAR2_TABLE_100
42: , a4 out nocopy JTF_VARCHAR2_TABLE_100
43: , a5 out nocopy JTF_NUMBER_TABLE

Line 40: , a2 out nocopy JTF_NUMBER_TABLE

36: , a8 JTF_NUMBER_TABLE
37: );
38: procedure rosetta_table_copy_out_p3(t ahl_fmp_pvt.applicable_mr_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
39: , a1 out nocopy JTF_NUMBER_TABLE
40: , a2 out nocopy JTF_NUMBER_TABLE
41: , a3 out nocopy JTF_VARCHAR2_TABLE_100
42: , a4 out nocopy JTF_VARCHAR2_TABLE_100
43: , a5 out nocopy JTF_NUMBER_TABLE
44: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 43: , a5 out nocopy JTF_NUMBER_TABLE

39: , a1 out nocopy JTF_NUMBER_TABLE
40: , a2 out nocopy JTF_NUMBER_TABLE
41: , a3 out nocopy JTF_VARCHAR2_TABLE_100
42: , a4 out nocopy JTF_VARCHAR2_TABLE_100
43: , a5 out nocopy JTF_NUMBER_TABLE
44: , a6 out nocopy JTF_VARCHAR2_TABLE_100
45: , a7 out nocopy JTF_VARCHAR2_TABLE_100
46: , a8 out nocopy JTF_NUMBER_TABLE
47: );

Line 46: , a8 out nocopy JTF_NUMBER_TABLE

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

Line 49: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE

45: , a7 out nocopy JTF_VARCHAR2_TABLE_100
46: , a8 out nocopy JTF_NUMBER_TABLE
47: );
48:
49: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE
50: , a1 JTF_NUMBER_TABLE
51: , a2 JTF_NUMBER_TABLE
52: , a3 JTF_NUMBER_TABLE
53: , a4 JTF_NUMBER_TABLE

Line 50: , a1 JTF_NUMBER_TABLE

46: , a8 out nocopy JTF_NUMBER_TABLE
47: );
48:
49: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE
50: , a1 JTF_NUMBER_TABLE
51: , a2 JTF_NUMBER_TABLE
52: , a3 JTF_NUMBER_TABLE
53: , a4 JTF_NUMBER_TABLE
54: , a5 JTF_VARCHAR2_TABLE_100

Line 51: , a2 JTF_NUMBER_TABLE

47: );
48:
49: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE
50: , a1 JTF_NUMBER_TABLE
51: , a2 JTF_NUMBER_TABLE
52: , a3 JTF_NUMBER_TABLE
53: , a4 JTF_NUMBER_TABLE
54: , a5 JTF_VARCHAR2_TABLE_100
55: , a6 JTF_VARCHAR2_TABLE_100

Line 52: , a3 JTF_NUMBER_TABLE

48:
49: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE
50: , a1 JTF_NUMBER_TABLE
51: , a2 JTF_NUMBER_TABLE
52: , a3 JTF_NUMBER_TABLE
53: , a4 JTF_NUMBER_TABLE
54: , a5 JTF_VARCHAR2_TABLE_100
55: , a6 JTF_VARCHAR2_TABLE_100
56: , a7 JTF_VARCHAR2_TABLE_100

Line 53: , a4 JTF_NUMBER_TABLE

49: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE
50: , a1 JTF_NUMBER_TABLE
51: , a2 JTF_NUMBER_TABLE
52: , a3 JTF_NUMBER_TABLE
53: , a4 JTF_NUMBER_TABLE
54: , a5 JTF_VARCHAR2_TABLE_100
55: , a6 JTF_VARCHAR2_TABLE_100
56: , a7 JTF_VARCHAR2_TABLE_100
57: , a8 JTF_VARCHAR2_TABLE_100

Line 60: procedure rosetta_table_copy_out_p5(t ahl_fmp_pvt.applicable_activities_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

56: , a7 JTF_VARCHAR2_TABLE_100
57: , a8 JTF_VARCHAR2_TABLE_100
58: , a9 JTF_VARCHAR2_TABLE_100
59: );
60: procedure rosetta_table_copy_out_p5(t ahl_fmp_pvt.applicable_activities_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
61: , a1 out nocopy JTF_NUMBER_TABLE
62: , a2 out nocopy JTF_NUMBER_TABLE
63: , a3 out nocopy JTF_NUMBER_TABLE
64: , a4 out nocopy JTF_NUMBER_TABLE

Line 61: , a1 out nocopy JTF_NUMBER_TABLE

57: , a8 JTF_VARCHAR2_TABLE_100
58: , a9 JTF_VARCHAR2_TABLE_100
59: );
60: procedure rosetta_table_copy_out_p5(t ahl_fmp_pvt.applicable_activities_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
61: , a1 out nocopy JTF_NUMBER_TABLE
62: , a2 out nocopy JTF_NUMBER_TABLE
63: , a3 out nocopy JTF_NUMBER_TABLE
64: , a4 out nocopy JTF_NUMBER_TABLE
65: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 62: , a2 out nocopy JTF_NUMBER_TABLE

58: , a9 JTF_VARCHAR2_TABLE_100
59: );
60: procedure rosetta_table_copy_out_p5(t ahl_fmp_pvt.applicable_activities_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
61: , a1 out nocopy JTF_NUMBER_TABLE
62: , a2 out nocopy JTF_NUMBER_TABLE
63: , a3 out nocopy JTF_NUMBER_TABLE
64: , a4 out nocopy JTF_NUMBER_TABLE
65: , a5 out nocopy JTF_VARCHAR2_TABLE_100
66: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 63: , a3 out nocopy JTF_NUMBER_TABLE

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

Line 64: , a4 out nocopy JTF_NUMBER_TABLE

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

Line 72: procedure rosetta_table_copy_in_p7(t out nocopy ahl_fmp_pvt.applicable_programs_tbl_type, a0 JTF_NUMBER_TABLE

68: , a8 out nocopy JTF_VARCHAR2_TABLE_100
69: , a9 out nocopy JTF_VARCHAR2_TABLE_100
70: );
71:
72: procedure rosetta_table_copy_in_p7(t out nocopy ahl_fmp_pvt.applicable_programs_tbl_type, a0 JTF_NUMBER_TABLE
73: , a1 JTF_VARCHAR2_TABLE_200
74: , a2 JTF_VARCHAR2_TABLE_200
75: , a3 JTF_VARCHAR2_TABLE_100
76: , a4 JTF_NUMBER_TABLE

Line 76: , a4 JTF_NUMBER_TABLE

72: procedure rosetta_table_copy_in_p7(t out nocopy ahl_fmp_pvt.applicable_programs_tbl_type, a0 JTF_NUMBER_TABLE
73: , a1 JTF_VARCHAR2_TABLE_200
74: , a2 JTF_VARCHAR2_TABLE_200
75: , a3 JTF_VARCHAR2_TABLE_100
76: , a4 JTF_NUMBER_TABLE
77: , a5 JTF_VARCHAR2_TABLE_300
78: , a6 JTF_VARCHAR2_TABLE_300
79: , a7 JTF_NUMBER_TABLE
80: , a8 JTF_VARCHAR2_TABLE_200

Line 79: , a7 JTF_NUMBER_TABLE

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

Line 84: , a12 JTF_NUMBER_TABLE

80: , a8 JTF_VARCHAR2_TABLE_200
81: , a9 JTF_VARCHAR2_TABLE_2000
82: , a10 JTF_VARCHAR2_TABLE_100
83: , a11 JTF_VARCHAR2_TABLE_100
84: , a12 JTF_NUMBER_TABLE
85: , a13 JTF_DATE_TABLE
86: , a14 JTF_DATE_TABLE
87: , a15 JTF_VARCHAR2_TABLE_100
88: , a16 JTF_VARCHAR2_TABLE_100

Line 96: , a24 JTF_NUMBER_TABLE

92: , a20 JTF_VARCHAR2_TABLE_2000
93: , a21 JTF_DATE_TABLE
94: , a22 JTF_VARCHAR2_TABLE_100
95: , a23 JTF_VARCHAR2_TABLE_500
96: , a24 JTF_NUMBER_TABLE
97: );
98: procedure rosetta_table_copy_out_p7(t ahl_fmp_pvt.applicable_programs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
99: , a1 out nocopy JTF_VARCHAR2_TABLE_200
100: , a2 out nocopy JTF_VARCHAR2_TABLE_200

Line 98: procedure rosetta_table_copy_out_p7(t ahl_fmp_pvt.applicable_programs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

94: , a22 JTF_VARCHAR2_TABLE_100
95: , a23 JTF_VARCHAR2_TABLE_500
96: , a24 JTF_NUMBER_TABLE
97: );
98: procedure rosetta_table_copy_out_p7(t ahl_fmp_pvt.applicable_programs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
99: , a1 out nocopy JTF_VARCHAR2_TABLE_200
100: , a2 out nocopy JTF_VARCHAR2_TABLE_200
101: , a3 out nocopy JTF_VARCHAR2_TABLE_100
102: , a4 out nocopy JTF_NUMBER_TABLE

Line 102: , a4 out nocopy JTF_NUMBER_TABLE

98: procedure rosetta_table_copy_out_p7(t ahl_fmp_pvt.applicable_programs_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
99: , a1 out nocopy JTF_VARCHAR2_TABLE_200
100: , a2 out nocopy JTF_VARCHAR2_TABLE_200
101: , a3 out nocopy JTF_VARCHAR2_TABLE_100
102: , a4 out nocopy JTF_NUMBER_TABLE
103: , a5 out nocopy JTF_VARCHAR2_TABLE_300
104: , a6 out nocopy JTF_VARCHAR2_TABLE_300
105: , a7 out nocopy JTF_NUMBER_TABLE
106: , a8 out nocopy JTF_VARCHAR2_TABLE_200

Line 105: , a7 out nocopy JTF_NUMBER_TABLE

101: , a3 out nocopy JTF_VARCHAR2_TABLE_100
102: , a4 out nocopy JTF_NUMBER_TABLE
103: , a5 out nocopy JTF_VARCHAR2_TABLE_300
104: , a6 out nocopy JTF_VARCHAR2_TABLE_300
105: , a7 out nocopy JTF_NUMBER_TABLE
106: , a8 out nocopy JTF_VARCHAR2_TABLE_200
107: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
108: , a10 out nocopy JTF_VARCHAR2_TABLE_100
109: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 110: , a12 out nocopy JTF_NUMBER_TABLE

106: , a8 out nocopy JTF_VARCHAR2_TABLE_200
107: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
108: , a10 out nocopy JTF_VARCHAR2_TABLE_100
109: , a11 out nocopy JTF_VARCHAR2_TABLE_100
110: , a12 out nocopy JTF_NUMBER_TABLE
111: , a13 out nocopy JTF_DATE_TABLE
112: , a14 out nocopy JTF_DATE_TABLE
113: , a15 out nocopy JTF_VARCHAR2_TABLE_100
114: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 122: , a24 out nocopy JTF_NUMBER_TABLE

118: , a20 out nocopy JTF_VARCHAR2_TABLE_2000
119: , a21 out nocopy JTF_DATE_TABLE
120: , a22 out nocopy JTF_VARCHAR2_TABLE_100
121: , a23 out nocopy JTF_VARCHAR2_TABLE_500
122: , a24 out nocopy JTF_NUMBER_TABLE
123: );
124:
125: procedure get_mr_affected_items(p_api_version NUMBER
126: , p_init_msg_list VARCHAR2

Line 144: , p12_a7 out nocopy JTF_NUMBER_TABLE

140: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
141: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_400
142: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_300
143: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
144: , p12_a7 out nocopy JTF_NUMBER_TABLE
145: , p12_a8 out nocopy JTF_NUMBER_TABLE
146: , p12_a9 out nocopy JTF_NUMBER_TABLE
147: , p12_a10 out nocopy JTF_NUMBER_TABLE
148: );

Line 145: , p12_a8 out nocopy JTF_NUMBER_TABLE

141: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_400
142: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_300
143: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
144: , p12_a7 out nocopy JTF_NUMBER_TABLE
145: , p12_a8 out nocopy JTF_NUMBER_TABLE
146: , p12_a9 out nocopy JTF_NUMBER_TABLE
147: , p12_a10 out nocopy JTF_NUMBER_TABLE
148: );
149: procedure get_applicable_mrs(p_api_version NUMBER

Line 146: , p12_a9 out nocopy JTF_NUMBER_TABLE

142: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_300
143: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
144: , p12_a7 out nocopy JTF_NUMBER_TABLE
145: , p12_a8 out nocopy JTF_NUMBER_TABLE
146: , p12_a9 out nocopy JTF_NUMBER_TABLE
147: , p12_a10 out nocopy JTF_NUMBER_TABLE
148: );
149: procedure get_applicable_mrs(p_api_version NUMBER
150: , p_init_msg_list VARCHAR2

Line 147: , p12_a10 out nocopy JTF_NUMBER_TABLE

143: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
144: , p12_a7 out nocopy JTF_NUMBER_TABLE
145: , p12_a8 out nocopy JTF_NUMBER_TABLE
146: , p12_a9 out nocopy JTF_NUMBER_TABLE
147: , p12_a10 out nocopy JTF_NUMBER_TABLE
148: );
149: procedure get_applicable_mrs(p_api_version NUMBER
150: , p_init_msg_list VARCHAR2
151: , p_commit VARCHAR2

Line 161: , p12_a0 out nocopy JTF_NUMBER_TABLE

157: , p_mr_header_id NUMBER
158: , p_components_flag VARCHAR2
159: , p_include_donotimplmt VARCHAR2
160: , p_visit_type_code VARCHAR2
161: , p12_a0 out nocopy JTF_NUMBER_TABLE
162: , p12_a1 out nocopy JTF_NUMBER_TABLE
163: , p12_a2 out nocopy JTF_NUMBER_TABLE
164: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
165: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 162: , p12_a1 out nocopy JTF_NUMBER_TABLE

158: , p_components_flag VARCHAR2
159: , p_include_donotimplmt VARCHAR2
160: , p_visit_type_code VARCHAR2
161: , p12_a0 out nocopy JTF_NUMBER_TABLE
162: , p12_a1 out nocopy JTF_NUMBER_TABLE
163: , p12_a2 out nocopy JTF_NUMBER_TABLE
164: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
165: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
166: , p12_a5 out nocopy JTF_NUMBER_TABLE

Line 163: , p12_a2 out nocopy JTF_NUMBER_TABLE

159: , p_include_donotimplmt VARCHAR2
160: , p_visit_type_code VARCHAR2
161: , p12_a0 out nocopy JTF_NUMBER_TABLE
162: , p12_a1 out nocopy JTF_NUMBER_TABLE
163: , p12_a2 out nocopy JTF_NUMBER_TABLE
164: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
165: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
166: , p12_a5 out nocopy JTF_NUMBER_TABLE
167: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 166: , p12_a5 out nocopy JTF_NUMBER_TABLE

162: , p12_a1 out nocopy JTF_NUMBER_TABLE
163: , p12_a2 out nocopy JTF_NUMBER_TABLE
164: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
165: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
166: , p12_a5 out nocopy JTF_NUMBER_TABLE
167: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
168: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
169: , p12_a8 out nocopy JTF_NUMBER_TABLE
170: );

Line 169: , p12_a8 out nocopy JTF_NUMBER_TABLE

165: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
166: , p12_a5 out nocopy JTF_NUMBER_TABLE
167: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
168: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
169: , p12_a8 out nocopy JTF_NUMBER_TABLE
170: );
171: procedure get_pm_applicable_mrs(p_api_version NUMBER
172: , p_init_msg_list VARCHAR2
173: , p_commit VARCHAR2

Line 179: , p8_a0 out nocopy JTF_NUMBER_TABLE

175: , x_return_status out nocopy VARCHAR2
176: , x_msg_count out nocopy NUMBER
177: , x_msg_data out nocopy VARCHAR2
178: , p_item_instance_id NUMBER
179: , p8_a0 out nocopy JTF_NUMBER_TABLE
180: , p8_a1 out nocopy JTF_NUMBER_TABLE
181: , p8_a2 out nocopy JTF_NUMBER_TABLE
182: , p8_a3 out nocopy JTF_NUMBER_TABLE
183: , p8_a4 out nocopy JTF_NUMBER_TABLE

Line 180: , p8_a1 out nocopy JTF_NUMBER_TABLE

176: , x_msg_count out nocopy NUMBER
177: , x_msg_data out nocopy VARCHAR2
178: , p_item_instance_id NUMBER
179: , p8_a0 out nocopy JTF_NUMBER_TABLE
180: , p8_a1 out nocopy JTF_NUMBER_TABLE
181: , p8_a2 out nocopy JTF_NUMBER_TABLE
182: , p8_a3 out nocopy JTF_NUMBER_TABLE
183: , p8_a4 out nocopy JTF_NUMBER_TABLE
184: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 181: , p8_a2 out nocopy JTF_NUMBER_TABLE

177: , x_msg_data out nocopy VARCHAR2
178: , p_item_instance_id NUMBER
179: , p8_a0 out nocopy JTF_NUMBER_TABLE
180: , p8_a1 out nocopy JTF_NUMBER_TABLE
181: , p8_a2 out nocopy JTF_NUMBER_TABLE
182: , p8_a3 out nocopy JTF_NUMBER_TABLE
183: , p8_a4 out nocopy JTF_NUMBER_TABLE
184: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
185: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 182: , p8_a3 out nocopy JTF_NUMBER_TABLE

178: , p_item_instance_id NUMBER
179: , p8_a0 out nocopy JTF_NUMBER_TABLE
180: , p8_a1 out nocopy JTF_NUMBER_TABLE
181: , p8_a2 out nocopy JTF_NUMBER_TABLE
182: , p8_a3 out nocopy JTF_NUMBER_TABLE
183: , p8_a4 out nocopy JTF_NUMBER_TABLE
184: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
185: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
186: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 183: , p8_a4 out nocopy JTF_NUMBER_TABLE

179: , p8_a0 out nocopy JTF_NUMBER_TABLE
180: , p8_a1 out nocopy JTF_NUMBER_TABLE
181: , p8_a2 out nocopy JTF_NUMBER_TABLE
182: , p8_a3 out nocopy JTF_NUMBER_TABLE
183: , p8_a4 out nocopy JTF_NUMBER_TABLE
184: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
185: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
186: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
187: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100

Line 189: , p9_a0 out nocopy JTF_NUMBER_TABLE

185: , p8_a6 out nocopy JTF_VARCHAR2_TABLE_100
186: , p8_a7 out nocopy JTF_VARCHAR2_TABLE_100
187: , p8_a8 out nocopy JTF_VARCHAR2_TABLE_100
188: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
189: , p9_a0 out nocopy JTF_NUMBER_TABLE
190: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
191: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
192: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
193: , p9_a4 out nocopy JTF_NUMBER_TABLE

Line 193: , p9_a4 out nocopy JTF_NUMBER_TABLE

189: , p9_a0 out nocopy JTF_NUMBER_TABLE
190: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_200
191: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
192: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
193: , p9_a4 out nocopy JTF_NUMBER_TABLE
194: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
195: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_300
196: , p9_a7 out nocopy JTF_NUMBER_TABLE
197: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200

Line 196: , p9_a7 out nocopy JTF_NUMBER_TABLE

192: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
193: , p9_a4 out nocopy JTF_NUMBER_TABLE
194: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_300
195: , p9_a6 out nocopy JTF_VARCHAR2_TABLE_300
196: , p9_a7 out nocopy JTF_NUMBER_TABLE
197: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200
198: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_2000
199: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
200: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 201: , p9_a12 out nocopy JTF_NUMBER_TABLE

197: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200
198: , p9_a9 out nocopy JTF_VARCHAR2_TABLE_2000
199: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
200: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
201: , p9_a12 out nocopy JTF_NUMBER_TABLE
202: , p9_a13 out nocopy JTF_DATE_TABLE
203: , p9_a14 out nocopy JTF_DATE_TABLE
204: , p9_a15 out nocopy JTF_VARCHAR2_TABLE_100
205: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 213: , p9_a24 out nocopy JTF_NUMBER_TABLE

209: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_2000
210: , p9_a21 out nocopy JTF_DATE_TABLE
211: , p9_a22 out nocopy JTF_VARCHAR2_TABLE_100
212: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
213: , p9_a24 out nocopy JTF_NUMBER_TABLE
214: );
215: end ahl_fmp_pvt_w;