APPS.AHL_COMPLEX_MX_RWSC_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: AHLWRWSS.pls 120.0.12020000.2 2012/12/14 06:16:28 shnatu noship $ */
3: procedure rosetta_table_copy_in_p5(t out nocopy ahl_complex_mx_rwsc_pvt.visit_ir_uc_details_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE

Line 15: , a12 JTF_VARCHAR2_TABLE_100

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

Line 17: , a14 JTF_VARCHAR2_TABLE_100

13: , a10 JTF_VARCHAR2_TABLE_300
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_300
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100

Line 19: , a16 JTF_VARCHAR2_TABLE_100

15: , a12 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_VARCHAR2_TABLE_300
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100

Line 20: , a17 JTF_VARCHAR2_TABLE_100

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

Line 21: , a18 JTF_VARCHAR2_TABLE_100

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

Line 22: , a19 JTF_VARCHAR2_TABLE_100

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

Line 23: , a20 JTF_VARCHAR2_TABLE_100

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

Line 24: , a21 JTF_VARCHAR2_TABLE_100

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

Line 27: , a24 JTF_VARCHAR2_TABLE_100

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

Line 29: , a26 JTF_VARCHAR2_TABLE_100

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

Line 30: , a27 JTF_VARCHAR2_TABLE_100

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

Line 33: , a30 JTF_VARCHAR2_TABLE_100

29: , a26 JTF_VARCHAR2_TABLE_100
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_NUMBER_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE

Line 39: , a36 JTF_VARCHAR2_TABLE_100

35: , a32 JTF_NUMBER_TABLE
36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_NUMBER_TABLE

Line 40: , a37 JTF_VARCHAR2_TABLE_100

36: , a33 JTF_NUMBER_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_NUMBER_TABLE
44: , a41 JTF_VARCHAR2_TABLE_100

Line 41: , a38 JTF_VARCHAR2_TABLE_100

37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_NUMBER_TABLE
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_NUMBER_TABLE

Line 44: , a41 JTF_VARCHAR2_TABLE_100

40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_NUMBER_TABLE
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_NUMBER_TABLE
46: , a43 JTF_VARCHAR2_TABLE_100
47: );
48: procedure rosetta_table_copy_out_p5(t ahl_complex_mx_rwsc_pvt.visit_ir_uc_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 46: , a43 JTF_VARCHAR2_TABLE_100

42: , a39 JTF_NUMBER_TABLE
43: , a40 JTF_NUMBER_TABLE
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_NUMBER_TABLE
46: , a43 JTF_VARCHAR2_TABLE_100
47: );
48: procedure rosetta_table_copy_out_p5(t ahl_complex_mx_rwsc_pvt.visit_ir_uc_details_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
49: , a1 out nocopy JTF_NUMBER_TABLE
50: , a2 out nocopy JTF_NUMBER_TABLE

Line 51: , a3 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 60: , a12 out nocopy JTF_VARCHAR2_TABLE_100

56: , a8 out nocopy JTF_NUMBER_TABLE
57: , a9 out nocopy JTF_NUMBER_TABLE
58: , a10 out nocopy JTF_VARCHAR2_TABLE_300
59: , a11 out nocopy JTF_NUMBER_TABLE
60: , a12 out nocopy JTF_VARCHAR2_TABLE_100
61: , a13 out nocopy JTF_VARCHAR2_TABLE_300
62: , a14 out nocopy JTF_VARCHAR2_TABLE_100
63: , a15 out nocopy JTF_NUMBER_TABLE
64: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 62: , a14 out nocopy JTF_VARCHAR2_TABLE_100

58: , a10 out nocopy JTF_VARCHAR2_TABLE_300
59: , a11 out nocopy JTF_NUMBER_TABLE
60: , a12 out nocopy JTF_VARCHAR2_TABLE_100
61: , a13 out nocopy JTF_VARCHAR2_TABLE_300
62: , a14 out nocopy JTF_VARCHAR2_TABLE_100
63: , a15 out nocopy JTF_NUMBER_TABLE
64: , a16 out nocopy JTF_VARCHAR2_TABLE_100
65: , a17 out nocopy JTF_VARCHAR2_TABLE_100
66: , a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 64: , a16 out nocopy JTF_VARCHAR2_TABLE_100

60: , a12 out nocopy JTF_VARCHAR2_TABLE_100
61: , a13 out nocopy JTF_VARCHAR2_TABLE_300
62: , a14 out nocopy JTF_VARCHAR2_TABLE_100
63: , a15 out nocopy JTF_NUMBER_TABLE
64: , a16 out nocopy JTF_VARCHAR2_TABLE_100
65: , a17 out nocopy JTF_VARCHAR2_TABLE_100
66: , a18 out nocopy JTF_VARCHAR2_TABLE_100
67: , a19 out nocopy JTF_VARCHAR2_TABLE_100
68: , a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 65: , a17 out nocopy JTF_VARCHAR2_TABLE_100

61: , a13 out nocopy JTF_VARCHAR2_TABLE_300
62: , a14 out nocopy JTF_VARCHAR2_TABLE_100
63: , a15 out nocopy JTF_NUMBER_TABLE
64: , a16 out nocopy JTF_VARCHAR2_TABLE_100
65: , a17 out nocopy JTF_VARCHAR2_TABLE_100
66: , a18 out nocopy JTF_VARCHAR2_TABLE_100
67: , a19 out nocopy JTF_VARCHAR2_TABLE_100
68: , a20 out nocopy JTF_VARCHAR2_TABLE_100
69: , a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 66: , a18 out nocopy JTF_VARCHAR2_TABLE_100

62: , a14 out nocopy JTF_VARCHAR2_TABLE_100
63: , a15 out nocopy JTF_NUMBER_TABLE
64: , a16 out nocopy JTF_VARCHAR2_TABLE_100
65: , a17 out nocopy JTF_VARCHAR2_TABLE_100
66: , a18 out nocopy JTF_VARCHAR2_TABLE_100
67: , a19 out nocopy JTF_VARCHAR2_TABLE_100
68: , a20 out nocopy JTF_VARCHAR2_TABLE_100
69: , a21 out nocopy JTF_VARCHAR2_TABLE_100
70: , a22 out nocopy JTF_NUMBER_TABLE

Line 67: , a19 out nocopy JTF_VARCHAR2_TABLE_100

63: , a15 out nocopy JTF_NUMBER_TABLE
64: , a16 out nocopy JTF_VARCHAR2_TABLE_100
65: , a17 out nocopy JTF_VARCHAR2_TABLE_100
66: , a18 out nocopy JTF_VARCHAR2_TABLE_100
67: , a19 out nocopy JTF_VARCHAR2_TABLE_100
68: , a20 out nocopy JTF_VARCHAR2_TABLE_100
69: , a21 out nocopy JTF_VARCHAR2_TABLE_100
70: , a22 out nocopy JTF_NUMBER_TABLE
71: , a23 out nocopy JTF_NUMBER_TABLE

Line 68: , a20 out nocopy JTF_VARCHAR2_TABLE_100

64: , a16 out nocopy JTF_VARCHAR2_TABLE_100
65: , a17 out nocopy JTF_VARCHAR2_TABLE_100
66: , a18 out nocopy JTF_VARCHAR2_TABLE_100
67: , a19 out nocopy JTF_VARCHAR2_TABLE_100
68: , a20 out nocopy JTF_VARCHAR2_TABLE_100
69: , a21 out nocopy JTF_VARCHAR2_TABLE_100
70: , a22 out nocopy JTF_NUMBER_TABLE
71: , a23 out nocopy JTF_NUMBER_TABLE
72: , a24 out nocopy JTF_VARCHAR2_TABLE_100

Line 69: , a21 out nocopy JTF_VARCHAR2_TABLE_100

65: , a17 out nocopy JTF_VARCHAR2_TABLE_100
66: , a18 out nocopy JTF_VARCHAR2_TABLE_100
67: , a19 out nocopy JTF_VARCHAR2_TABLE_100
68: , a20 out nocopy JTF_VARCHAR2_TABLE_100
69: , a21 out nocopy JTF_VARCHAR2_TABLE_100
70: , a22 out nocopy JTF_NUMBER_TABLE
71: , a23 out nocopy JTF_NUMBER_TABLE
72: , a24 out nocopy JTF_VARCHAR2_TABLE_100
73: , a25 out nocopy JTF_NUMBER_TABLE

Line 72: , a24 out nocopy JTF_VARCHAR2_TABLE_100

68: , a20 out nocopy JTF_VARCHAR2_TABLE_100
69: , a21 out nocopy JTF_VARCHAR2_TABLE_100
70: , a22 out nocopy JTF_NUMBER_TABLE
71: , a23 out nocopy JTF_NUMBER_TABLE
72: , a24 out nocopy JTF_VARCHAR2_TABLE_100
73: , a25 out nocopy JTF_NUMBER_TABLE
74: , a26 out nocopy JTF_VARCHAR2_TABLE_100
75: , a27 out nocopy JTF_VARCHAR2_TABLE_100
76: , a28 out nocopy JTF_NUMBER_TABLE

Line 74: , a26 out nocopy JTF_VARCHAR2_TABLE_100

70: , a22 out nocopy JTF_NUMBER_TABLE
71: , a23 out nocopy JTF_NUMBER_TABLE
72: , a24 out nocopy JTF_VARCHAR2_TABLE_100
73: , a25 out nocopy JTF_NUMBER_TABLE
74: , a26 out nocopy JTF_VARCHAR2_TABLE_100
75: , a27 out nocopy JTF_VARCHAR2_TABLE_100
76: , a28 out nocopy JTF_NUMBER_TABLE
77: , a29 out nocopy JTF_NUMBER_TABLE
78: , a30 out nocopy JTF_VARCHAR2_TABLE_100

Line 75: , a27 out nocopy JTF_VARCHAR2_TABLE_100

71: , a23 out nocopy JTF_NUMBER_TABLE
72: , a24 out nocopy JTF_VARCHAR2_TABLE_100
73: , a25 out nocopy JTF_NUMBER_TABLE
74: , a26 out nocopy JTF_VARCHAR2_TABLE_100
75: , a27 out nocopy JTF_VARCHAR2_TABLE_100
76: , a28 out nocopy JTF_NUMBER_TABLE
77: , a29 out nocopy JTF_NUMBER_TABLE
78: , a30 out nocopy JTF_VARCHAR2_TABLE_100
79: , a31 out nocopy JTF_NUMBER_TABLE

Line 78: , a30 out nocopy JTF_VARCHAR2_TABLE_100

74: , a26 out nocopy JTF_VARCHAR2_TABLE_100
75: , a27 out nocopy JTF_VARCHAR2_TABLE_100
76: , a28 out nocopy JTF_NUMBER_TABLE
77: , a29 out nocopy JTF_NUMBER_TABLE
78: , a30 out nocopy JTF_VARCHAR2_TABLE_100
79: , a31 out nocopy JTF_NUMBER_TABLE
80: , a32 out nocopy JTF_NUMBER_TABLE
81: , a33 out nocopy JTF_NUMBER_TABLE
82: , a34 out nocopy JTF_NUMBER_TABLE

Line 84: , a36 out nocopy JTF_VARCHAR2_TABLE_100

80: , a32 out nocopy JTF_NUMBER_TABLE
81: , a33 out nocopy JTF_NUMBER_TABLE
82: , a34 out nocopy JTF_NUMBER_TABLE
83: , a35 out nocopy JTF_NUMBER_TABLE
84: , a36 out nocopy JTF_VARCHAR2_TABLE_100
85: , a37 out nocopy JTF_VARCHAR2_TABLE_100
86: , a38 out nocopy JTF_VARCHAR2_TABLE_100
87: , a39 out nocopy JTF_NUMBER_TABLE
88: , a40 out nocopy JTF_NUMBER_TABLE

Line 85: , a37 out nocopy JTF_VARCHAR2_TABLE_100

81: , a33 out nocopy JTF_NUMBER_TABLE
82: , a34 out nocopy JTF_NUMBER_TABLE
83: , a35 out nocopy JTF_NUMBER_TABLE
84: , a36 out nocopy JTF_VARCHAR2_TABLE_100
85: , a37 out nocopy JTF_VARCHAR2_TABLE_100
86: , a38 out nocopy JTF_VARCHAR2_TABLE_100
87: , a39 out nocopy JTF_NUMBER_TABLE
88: , a40 out nocopy JTF_NUMBER_TABLE
89: , a41 out nocopy JTF_VARCHAR2_TABLE_100

Line 86: , a38 out nocopy JTF_VARCHAR2_TABLE_100

82: , a34 out nocopy JTF_NUMBER_TABLE
83: , a35 out nocopy JTF_NUMBER_TABLE
84: , a36 out nocopy JTF_VARCHAR2_TABLE_100
85: , a37 out nocopy JTF_VARCHAR2_TABLE_100
86: , a38 out nocopy JTF_VARCHAR2_TABLE_100
87: , a39 out nocopy JTF_NUMBER_TABLE
88: , a40 out nocopy JTF_NUMBER_TABLE
89: , a41 out nocopy JTF_VARCHAR2_TABLE_100
90: , a42 out nocopy JTF_NUMBER_TABLE

Line 89: , a41 out nocopy JTF_VARCHAR2_TABLE_100

85: , a37 out nocopy JTF_VARCHAR2_TABLE_100
86: , a38 out nocopy JTF_VARCHAR2_TABLE_100
87: , a39 out nocopy JTF_NUMBER_TABLE
88: , a40 out nocopy JTF_NUMBER_TABLE
89: , a41 out nocopy JTF_VARCHAR2_TABLE_100
90: , a42 out nocopy JTF_NUMBER_TABLE
91: , a43 out nocopy JTF_VARCHAR2_TABLE_100
92: );
93:

Line 91: , a43 out nocopy JTF_VARCHAR2_TABLE_100

87: , a39 out nocopy JTF_NUMBER_TABLE
88: , a40 out nocopy JTF_NUMBER_TABLE
89: , a41 out nocopy JTF_VARCHAR2_TABLE_100
90: , a42 out nocopy JTF_NUMBER_TABLE
91: , a43 out nocopy JTF_VARCHAR2_TABLE_100
92: );
93:
94: procedure rosetta_table_copy_in_p8(t out nocopy ahl_complex_mx_rwsc_pvt.instance_routings_tbl_type, a0 JTF_NUMBER_TABLE
95: , a1 JTF_NUMBER_TABLE

Line 98: , a4 JTF_VARCHAR2_TABLE_100

94: procedure rosetta_table_copy_in_p8(t out nocopy ahl_complex_mx_rwsc_pvt.instance_routings_tbl_type, a0 JTF_NUMBER_TABLE
95: , a1 JTF_NUMBER_TABLE
96: , a2 JTF_NUMBER_TABLE
97: , a3 JTF_NUMBER_TABLE
98: , a4 JTF_VARCHAR2_TABLE_100
99: , a5 JTF_VARCHAR2_TABLE_100
100: );
101: procedure rosetta_table_copy_out_p8(t ahl_complex_mx_rwsc_pvt.instance_routings_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_NUMBER_TABLE

Line 99: , a5 JTF_VARCHAR2_TABLE_100

95: , a1 JTF_NUMBER_TABLE
96: , a2 JTF_NUMBER_TABLE
97: , a3 JTF_NUMBER_TABLE
98: , a4 JTF_VARCHAR2_TABLE_100
99: , a5 JTF_VARCHAR2_TABLE_100
100: );
101: procedure rosetta_table_copy_out_p8(t ahl_complex_mx_rwsc_pvt.instance_routings_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_NUMBER_TABLE
103: , a2 out nocopy JTF_NUMBER_TABLE

Line 105: , a4 out nocopy JTF_VARCHAR2_TABLE_100

101: procedure rosetta_table_copy_out_p8(t ahl_complex_mx_rwsc_pvt.instance_routings_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
102: , a1 out nocopy JTF_NUMBER_TABLE
103: , a2 out nocopy JTF_NUMBER_TABLE
104: , a3 out nocopy JTF_NUMBER_TABLE
105: , a4 out nocopy JTF_VARCHAR2_TABLE_100
106: , a5 out nocopy JTF_VARCHAR2_TABLE_100
107: );
108:
109: procedure get_visit_ir_uc_details(p_api_version NUMBER

Line 106: , a5 out nocopy JTF_VARCHAR2_TABLE_100

102: , a1 out nocopy JTF_NUMBER_TABLE
103: , a2 out nocopy JTF_NUMBER_TABLE
104: , a3 out nocopy JTF_NUMBER_TABLE
105: , a4 out nocopy JTF_VARCHAR2_TABLE_100
106: , a5 out nocopy JTF_VARCHAR2_TABLE_100
107: );
108:
109: procedure get_visit_ir_uc_details(p_api_version NUMBER
110: , p_init_msg_list VARCHAR2

Line 121: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100

117: , p_visit_id NUMBER
118: , p9_a0 out nocopy JTF_NUMBER_TABLE
119: , p9_a1 out nocopy JTF_NUMBER_TABLE
120: , p9_a2 out nocopy JTF_NUMBER_TABLE
121: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_100
122: , p9_a4 out nocopy JTF_NUMBER_TABLE
123: , p9_a5 out nocopy JTF_NUMBER_TABLE
124: , p9_a6 out nocopy JTF_NUMBER_TABLE
125: , p9_a7 out nocopy JTF_NUMBER_TABLE

Line 130: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100

126: , p9_a8 out nocopy JTF_NUMBER_TABLE
127: , p9_a9 out nocopy JTF_NUMBER_TABLE
128: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_300
129: , p9_a11 out nocopy JTF_NUMBER_TABLE
130: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
131: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_300
132: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_100
133: , p9_a15 out nocopy JTF_NUMBER_TABLE
134: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 132: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_100

128: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_300
129: , p9_a11 out nocopy JTF_NUMBER_TABLE
130: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
131: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_300
132: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_100
133: , p9_a15 out nocopy JTF_NUMBER_TABLE
134: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
135: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
136: , p9_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 134: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100

130: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100
131: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_300
132: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_100
133: , p9_a15 out nocopy JTF_NUMBER_TABLE
134: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
135: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
136: , p9_a18 out nocopy JTF_VARCHAR2_TABLE_100
137: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
138: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100

Line 135: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100

131: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_300
132: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_100
133: , p9_a15 out nocopy JTF_NUMBER_TABLE
134: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
135: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
136: , p9_a18 out nocopy JTF_VARCHAR2_TABLE_100
137: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
138: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100
139: , p9_a21 out nocopy JTF_VARCHAR2_TABLE_100

Line 136: , p9_a18 out nocopy JTF_VARCHAR2_TABLE_100

132: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_100
133: , p9_a15 out nocopy JTF_NUMBER_TABLE
134: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
135: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
136: , p9_a18 out nocopy JTF_VARCHAR2_TABLE_100
137: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
138: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100
139: , p9_a21 out nocopy JTF_VARCHAR2_TABLE_100
140: , p9_a22 out nocopy JTF_NUMBER_TABLE

Line 137: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100

133: , p9_a15 out nocopy JTF_NUMBER_TABLE
134: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
135: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
136: , p9_a18 out nocopy JTF_VARCHAR2_TABLE_100
137: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
138: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100
139: , p9_a21 out nocopy JTF_VARCHAR2_TABLE_100
140: , p9_a22 out nocopy JTF_NUMBER_TABLE
141: , p9_a23 out nocopy JTF_NUMBER_TABLE

Line 138: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100

134: , p9_a16 out nocopy JTF_VARCHAR2_TABLE_100
135: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
136: , p9_a18 out nocopy JTF_VARCHAR2_TABLE_100
137: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
138: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100
139: , p9_a21 out nocopy JTF_VARCHAR2_TABLE_100
140: , p9_a22 out nocopy JTF_NUMBER_TABLE
141: , p9_a23 out nocopy JTF_NUMBER_TABLE
142: , p9_a24 out nocopy JTF_VARCHAR2_TABLE_100

Line 139: , p9_a21 out nocopy JTF_VARCHAR2_TABLE_100

135: , p9_a17 out nocopy JTF_VARCHAR2_TABLE_100
136: , p9_a18 out nocopy JTF_VARCHAR2_TABLE_100
137: , p9_a19 out nocopy JTF_VARCHAR2_TABLE_100
138: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100
139: , p9_a21 out nocopy JTF_VARCHAR2_TABLE_100
140: , p9_a22 out nocopy JTF_NUMBER_TABLE
141: , p9_a23 out nocopy JTF_NUMBER_TABLE
142: , p9_a24 out nocopy JTF_VARCHAR2_TABLE_100
143: , p9_a25 out nocopy JTF_NUMBER_TABLE

Line 142: , p9_a24 out nocopy JTF_VARCHAR2_TABLE_100

138: , p9_a20 out nocopy JTF_VARCHAR2_TABLE_100
139: , p9_a21 out nocopy JTF_VARCHAR2_TABLE_100
140: , p9_a22 out nocopy JTF_NUMBER_TABLE
141: , p9_a23 out nocopy JTF_NUMBER_TABLE
142: , p9_a24 out nocopy JTF_VARCHAR2_TABLE_100
143: , p9_a25 out nocopy JTF_NUMBER_TABLE
144: , p9_a26 out nocopy JTF_VARCHAR2_TABLE_100
145: , p9_a27 out nocopy JTF_VARCHAR2_TABLE_100
146: , p9_a28 out nocopy JTF_NUMBER_TABLE

Line 144: , p9_a26 out nocopy JTF_VARCHAR2_TABLE_100

140: , p9_a22 out nocopy JTF_NUMBER_TABLE
141: , p9_a23 out nocopy JTF_NUMBER_TABLE
142: , p9_a24 out nocopy JTF_VARCHAR2_TABLE_100
143: , p9_a25 out nocopy JTF_NUMBER_TABLE
144: , p9_a26 out nocopy JTF_VARCHAR2_TABLE_100
145: , p9_a27 out nocopy JTF_VARCHAR2_TABLE_100
146: , p9_a28 out nocopy JTF_NUMBER_TABLE
147: , p9_a29 out nocopy JTF_NUMBER_TABLE
148: , p9_a30 out nocopy JTF_VARCHAR2_TABLE_100

Line 145: , p9_a27 out nocopy JTF_VARCHAR2_TABLE_100

141: , p9_a23 out nocopy JTF_NUMBER_TABLE
142: , p9_a24 out nocopy JTF_VARCHAR2_TABLE_100
143: , p9_a25 out nocopy JTF_NUMBER_TABLE
144: , p9_a26 out nocopy JTF_VARCHAR2_TABLE_100
145: , p9_a27 out nocopy JTF_VARCHAR2_TABLE_100
146: , p9_a28 out nocopy JTF_NUMBER_TABLE
147: , p9_a29 out nocopy JTF_NUMBER_TABLE
148: , p9_a30 out nocopy JTF_VARCHAR2_TABLE_100
149: , p9_a31 out nocopy JTF_NUMBER_TABLE

Line 148: , p9_a30 out nocopy JTF_VARCHAR2_TABLE_100

144: , p9_a26 out nocopy JTF_VARCHAR2_TABLE_100
145: , p9_a27 out nocopy JTF_VARCHAR2_TABLE_100
146: , p9_a28 out nocopy JTF_NUMBER_TABLE
147: , p9_a29 out nocopy JTF_NUMBER_TABLE
148: , p9_a30 out nocopy JTF_VARCHAR2_TABLE_100
149: , p9_a31 out nocopy JTF_NUMBER_TABLE
150: , p9_a32 out nocopy JTF_NUMBER_TABLE
151: , p9_a33 out nocopy JTF_NUMBER_TABLE
152: , p9_a34 out nocopy JTF_NUMBER_TABLE

Line 154: , p9_a36 out nocopy JTF_VARCHAR2_TABLE_100

150: , p9_a32 out nocopy JTF_NUMBER_TABLE
151: , p9_a33 out nocopy JTF_NUMBER_TABLE
152: , p9_a34 out nocopy JTF_NUMBER_TABLE
153: , p9_a35 out nocopy JTF_NUMBER_TABLE
154: , p9_a36 out nocopy JTF_VARCHAR2_TABLE_100
155: , p9_a37 out nocopy JTF_VARCHAR2_TABLE_100
156: , p9_a38 out nocopy JTF_VARCHAR2_TABLE_100
157: , p9_a39 out nocopy JTF_NUMBER_TABLE
158: , p9_a40 out nocopy JTF_NUMBER_TABLE

Line 155: , p9_a37 out nocopy JTF_VARCHAR2_TABLE_100

151: , p9_a33 out nocopy JTF_NUMBER_TABLE
152: , p9_a34 out nocopy JTF_NUMBER_TABLE
153: , p9_a35 out nocopy JTF_NUMBER_TABLE
154: , p9_a36 out nocopy JTF_VARCHAR2_TABLE_100
155: , p9_a37 out nocopy JTF_VARCHAR2_TABLE_100
156: , p9_a38 out nocopy JTF_VARCHAR2_TABLE_100
157: , p9_a39 out nocopy JTF_NUMBER_TABLE
158: , p9_a40 out nocopy JTF_NUMBER_TABLE
159: , p9_a41 out nocopy JTF_VARCHAR2_TABLE_100

Line 156: , p9_a38 out nocopy JTF_VARCHAR2_TABLE_100

152: , p9_a34 out nocopy JTF_NUMBER_TABLE
153: , p9_a35 out nocopy JTF_NUMBER_TABLE
154: , p9_a36 out nocopy JTF_VARCHAR2_TABLE_100
155: , p9_a37 out nocopy JTF_VARCHAR2_TABLE_100
156: , p9_a38 out nocopy JTF_VARCHAR2_TABLE_100
157: , p9_a39 out nocopy JTF_NUMBER_TABLE
158: , p9_a40 out nocopy JTF_NUMBER_TABLE
159: , p9_a41 out nocopy JTF_VARCHAR2_TABLE_100
160: , p9_a42 out nocopy JTF_NUMBER_TABLE

Line 159: , p9_a41 out nocopy JTF_VARCHAR2_TABLE_100

155: , p9_a37 out nocopy JTF_VARCHAR2_TABLE_100
156: , p9_a38 out nocopy JTF_VARCHAR2_TABLE_100
157: , p9_a39 out nocopy JTF_NUMBER_TABLE
158: , p9_a40 out nocopy JTF_NUMBER_TABLE
159: , p9_a41 out nocopy JTF_VARCHAR2_TABLE_100
160: , p9_a42 out nocopy JTF_NUMBER_TABLE
161: , p9_a43 out nocopy JTF_VARCHAR2_TABLE_100
162: , x_return_status out nocopy VARCHAR2
163: , x_msg_count out nocopy NUMBER

Line 161: , p9_a43 out nocopy JTF_VARCHAR2_TABLE_100

157: , p9_a39 out nocopy JTF_NUMBER_TABLE
158: , p9_a40 out nocopy JTF_NUMBER_TABLE
159: , p9_a41 out nocopy JTF_VARCHAR2_TABLE_100
160: , p9_a42 out nocopy JTF_NUMBER_TABLE
161: , p9_a43 out nocopy JTF_VARCHAR2_TABLE_100
162: , x_return_status out nocopy VARCHAR2
163: , x_msg_count out nocopy NUMBER
164: , x_msg_data out nocopy VARCHAR2
165: );

Line 176: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100

172: , p6_a0 in out nocopy JTF_NUMBER_TABLE
173: , p6_a1 in out nocopy JTF_NUMBER_TABLE
174: , p6_a2 in out nocopy JTF_NUMBER_TABLE
175: , p6_a3 in out nocopy JTF_NUMBER_TABLE
176: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
177: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
178: , x_return_status out nocopy VARCHAR2
179: , x_msg_count out nocopy NUMBER
180: , x_msg_data out nocopy VARCHAR2

Line 177: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100

173: , p6_a1 in out nocopy JTF_NUMBER_TABLE
174: , p6_a2 in out nocopy JTF_NUMBER_TABLE
175: , p6_a3 in out nocopy JTF_NUMBER_TABLE
176: , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_100
177: , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_100
178: , x_return_status out nocopy VARCHAR2
179: , x_msg_count out nocopy NUMBER
180: , x_msg_data out nocopy VARCHAR2
181: );