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: , a11 JTF_VARCHAR2_TABLE_100

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: , a11 JTF_VARCHAR2_TABLE_100
15: );

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: , 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

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: , 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

Line 23: , a7 out nocopy JTF_NUMBER_TABLE

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
27: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 24: , a8 out nocopy JTF_NUMBER_TABLE

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
27: , a11 out nocopy JTF_VARCHAR2_TABLE_100
28: );

Line 25: , a9 out nocopy JTF_NUMBER_TABLE

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
27: , a11 out nocopy JTF_VARCHAR2_TABLE_100
28: );
29:

Line 26: , a10 out nocopy JTF_NUMBER_TABLE

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
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

Line 30: procedure rosetta_table_copy_in_p3(t out nocopy ahl_fmp_pvt.applicable_mr_tbl_type, a0 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
32: , a2 JTF_NUMBER_TABLE
33: , a3 JTF_VARCHAR2_TABLE_100
34: , a4 JTF_VARCHAR2_TABLE_100

Line 31: , a1 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
32: , a2 JTF_NUMBER_TABLE
33: , a3 JTF_VARCHAR2_TABLE_100
34: , a4 JTF_VARCHAR2_TABLE_100
35: , a5 JTF_NUMBER_TABLE

Line 32: , a2 JTF_NUMBER_TABLE

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
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

Line 35: , a5 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
39: , a9 JTF_VARCHAR2_TABLE_100

Line 38: , a8 JTF_NUMBER_TABLE

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

Line 40: , a10 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
44: , a1 out nocopy JTF_NUMBER_TABLE

Line 41: , a11 JTF_NUMBER_TABLE

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
44: , a1 out nocopy JTF_NUMBER_TABLE
45: , a2 out nocopy JTF_NUMBER_TABLE

Line 43: procedure rosetta_table_copy_out_p3(t ahl_fmp_pvt.applicable_mr_tbl_type, a0 out nocopy 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
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

Line 44: , a1 out nocopy JTF_NUMBER_TABLE

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
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

Line 45: , a2 out nocopy 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
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

Line 48: , a5 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
52: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 51: , a8 out nocopy JTF_NUMBER_TABLE

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

Line 53: , a10 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:
57: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE

Line 54: , a11 out nocopy JTF_NUMBER_TABLE

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:
57: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE
58: , a1 JTF_NUMBER_TABLE

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

53: , a10 out nocopy JTF_NUMBER_TABLE
54: , a11 out nocopy JTF_NUMBER_TABLE
55: );
56:
57: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE
58: , a1 JTF_NUMBER_TABLE
59: , a2 JTF_NUMBER_TABLE
60: , a3 JTF_NUMBER_TABLE
61: , a4 JTF_NUMBER_TABLE

Line 58: , a1 JTF_NUMBER_TABLE

54: , a11 out nocopy JTF_NUMBER_TABLE
55: );
56:
57: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE
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

Line 59: , a2 JTF_NUMBER_TABLE

55: );
56:
57: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE
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

Line 60: , a3 JTF_NUMBER_TABLE

56:
57: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE
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

Line 61: , a4 JTF_NUMBER_TABLE

57: procedure rosetta_table_copy_in_p5(t out nocopy ahl_fmp_pvt.applicable_activities_tbl_type, a0 JTF_NUMBER_TABLE
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

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

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
71: , a3 out nocopy JTF_NUMBER_TABLE
72: , a4 out nocopy JTF_NUMBER_TABLE

Line 69: , a1 out nocopy JTF_NUMBER_TABLE

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
71: , a3 out nocopy JTF_NUMBER_TABLE
72: , a4 out nocopy JTF_NUMBER_TABLE
73: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 70: , a2 out nocopy JTF_NUMBER_TABLE

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
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

Line 71: , a3 out nocopy JTF_NUMBER_TABLE

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
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

Line 72: , a4 out nocopy JTF_NUMBER_TABLE

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
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

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

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
82: , a2 JTF_VARCHAR2_TABLE_200
83: , a3 JTF_VARCHAR2_TABLE_100
84: , a4 JTF_NUMBER_TABLE

Line 84: , a4 JTF_NUMBER_TABLE

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
88: , a8 JTF_VARCHAR2_TABLE_200

Line 87: , a7 JTF_NUMBER_TABLE

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
88: , a8 JTF_VARCHAR2_TABLE_200
89: , a9 JTF_VARCHAR2_TABLE_2000
90: , a10 JTF_VARCHAR2_TABLE_100
91: , a11 JTF_VARCHAR2_TABLE_100

Line 92: , a12 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
96: , a16 JTF_VARCHAR2_TABLE_100

Line 104: , a24 JTF_NUMBER_TABLE

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
107: , a1 out nocopy JTF_VARCHAR2_TABLE_200
108: , a2 out nocopy JTF_VARCHAR2_TABLE_200

Line 106: procedure rosetta_table_copy_out_p7(t ahl_fmp_pvt.applicable_programs_tbl_type, a0 out nocopy JTF_NUMBER_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
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

Line 110: , a4 out nocopy JTF_NUMBER_TABLE

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
114: , a8 out nocopy JTF_VARCHAR2_TABLE_200

Line 113: , a7 out nocopy JTF_NUMBER_TABLE

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
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

Line 118: , a12 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
122: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 130: , a24 out nocopy JTF_NUMBER_TABLE

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:
133: procedure get_mr_affected_items(p_api_version NUMBER
134: , p_init_msg_list VARCHAR2

Line 154: , p14_a7 out nocopy JTF_NUMBER_TABLE

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
158: , p14_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 155: , p14_a8 out nocopy JTF_NUMBER_TABLE

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
158: , p14_a11 out nocopy JTF_VARCHAR2_TABLE_100
159: );

Line 156: , p14_a9 out nocopy JTF_NUMBER_TABLE

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
158: , p14_a11 out nocopy JTF_VARCHAR2_TABLE_100
159: );
160: procedure get_applicable_mrs(p_api_version NUMBER

Line 157: , p14_a10 out nocopy JTF_NUMBER_TABLE

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
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

Line 175: , p15_a0 out nocopy JTF_NUMBER_TABLE

171: , p_visit_type_code VARCHAR2
172: , p_consider_fleet_flag VARCHAR2
173: , p_flt_range_calc_date date
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

Line 176: , p15_a1 out nocopy JTF_NUMBER_TABLE

172: , p_consider_fleet_flag VARCHAR2
173: , p_flt_range_calc_date date
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

Line 177: , p15_a2 out nocopy JTF_NUMBER_TABLE

173: , p_flt_range_calc_date date
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

Line 180: , p15_a5 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
184: , p15_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 183: , p15_a8 out nocopy JTF_NUMBER_TABLE

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

Line 185: , p15_a10 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
189: , p_init_msg_list VARCHAR2

Line 186: , p15_a11 out nocopy JTF_NUMBER_TABLE

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
189: , p_init_msg_list VARCHAR2
190: , p_commit VARCHAR2

Line 196: , p8_a0 out nocopy JTF_NUMBER_TABLE

192: , x_return_status out nocopy VARCHAR2
193: , x_msg_count out nocopy NUMBER
194: , x_msg_data out nocopy VARCHAR2
195: , p_item_instance_id NUMBER
196: , p8_a0 out nocopy JTF_NUMBER_TABLE
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

Line 197: , p8_a1 out nocopy JTF_NUMBER_TABLE

193: , x_msg_count out nocopy NUMBER
194: , x_msg_data out nocopy VARCHAR2
195: , p_item_instance_id NUMBER
196: , p8_a0 out nocopy JTF_NUMBER_TABLE
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

Line 198: , p8_a2 out nocopy JTF_NUMBER_TABLE

194: , x_msg_data out nocopy VARCHAR2
195: , p_item_instance_id NUMBER
196: , p8_a0 out nocopy JTF_NUMBER_TABLE
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

Line 199: , p8_a3 out nocopy JTF_NUMBER_TABLE

195: , p_item_instance_id NUMBER
196: , p8_a0 out nocopy JTF_NUMBER_TABLE
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

Line 200: , p8_a4 out nocopy JTF_NUMBER_TABLE

196: , p8_a0 out nocopy JTF_NUMBER_TABLE
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

Line 206: , p9_a0 out nocopy JTF_NUMBER_TABLE

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
210: , p9_a4 out nocopy JTF_NUMBER_TABLE

Line 210: , p9_a4 out nocopy JTF_NUMBER_TABLE

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
214: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_200

Line 213: , p9_a7 out nocopy JTF_NUMBER_TABLE

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
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

Line 218: , p9_a12 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
222: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 230: , p9_a24 out nocopy JTF_NUMBER_TABLE

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
233: , p_init_msg_list VARCHAR2
234: , p_commit VARCHAR2

Line 243: , p11_a0 out nocopy JTF_NUMBER_TABLE

239: , p_item_instance_id NUMBER
240: , p_mr_header_id NUMBER
241: , p_components_flag VARCHAR2
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

Line 244: , p11_a1 out nocopy JTF_NUMBER_TABLE

240: , p_mr_header_id NUMBER
241: , p_components_flag VARCHAR2
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

Line 245: , p11_a2 out nocopy JTF_NUMBER_TABLE

241: , p_components_flag VARCHAR2
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

Line 248: , p11_a5 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
252: , p11_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 251: , p11_a8 out nocopy JTF_NUMBER_TABLE

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

Line 253: , p11_a10 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;

Line 254: , p11_a11 out nocopy JTF_NUMBER_TABLE

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;