DBA Data[Home] [Help]

APPS.IEM_SPV_MONITORING_PVT_W dependencies on JTF_NUMBER_TABLE

Line 13: procedure rosetta_table_copy_in_p1(t out nocopy iem_spv_monitoring_pvt.email_activity_tbl, a0 JTF_NUMBER_TABLE

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy iem_spv_monitoring_pvt.email_activity_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_300
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_NUMBER_TABLE

Line 14: , a1 JTF_NUMBER_TABLE

10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy iem_spv_monitoring_pvt.email_activity_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_300
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_NUMBER_TABLE

Line 16: , a3 JTF_NUMBER_TABLE

12:
13: procedure rosetta_table_copy_in_p1(t out nocopy iem_spv_monitoring_pvt.email_activity_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_300
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE

Line 17: , a4 JTF_NUMBER_TABLE

13: procedure rosetta_table_copy_in_p1(t out nocopy iem_spv_monitoring_pvt.email_activity_tbl, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_300
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_NUMBER_TABLE

Line 18: , a5 JTF_NUMBER_TABLE

14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_VARCHAR2_TABLE_300
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_NUMBER_TABLE

Line 19: , a6 JTF_NUMBER_TABLE

15: , a2 JTF_VARCHAR2_TABLE_300
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_NUMBER_TABLE

Line 20: , a7 JTF_NUMBER_TABLE

16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_NUMBER_TABLE
24: , a11 JTF_VARCHAR2_TABLE_100

Line 21: , a8 JTF_NUMBER_TABLE

17: , a4 JTF_NUMBER_TABLE
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_NUMBER_TABLE
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_VARCHAR2_TABLE_100

Line 22: , a9 JTF_NUMBER_TABLE

18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_NUMBER_TABLE
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_VARCHAR2_TABLE_100
26: ) as

Line 23: , a10 JTF_NUMBER_TABLE

19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_NUMBER_TABLE
22: , a9 JTF_NUMBER_TABLE
23: , a10 JTF_NUMBER_TABLE
24: , a11 JTF_VARCHAR2_TABLE_100
25: , a12 JTF_VARCHAR2_TABLE_100
26: ) as
27: ddindx binary_integer; indx binary_integer;

Line 56: procedure rosetta_table_copy_out_p1(t iem_spv_monitoring_pvt.email_activity_tbl, a0 out nocopy JTF_NUMBER_TABLE

52: end loop;
53: end if;
54: end if;
55: end rosetta_table_copy_in_p1;
56: procedure rosetta_table_copy_out_p1(t iem_spv_monitoring_pvt.email_activity_tbl, a0 out nocopy JTF_NUMBER_TABLE
57: , a1 out nocopy JTF_NUMBER_TABLE
58: , a2 out nocopy JTF_VARCHAR2_TABLE_300
59: , a3 out nocopy JTF_NUMBER_TABLE
60: , a4 out nocopy JTF_NUMBER_TABLE

Line 57: , a1 out nocopy JTF_NUMBER_TABLE

53: end if;
54: end if;
55: end rosetta_table_copy_in_p1;
56: procedure rosetta_table_copy_out_p1(t iem_spv_monitoring_pvt.email_activity_tbl, a0 out nocopy JTF_NUMBER_TABLE
57: , a1 out nocopy JTF_NUMBER_TABLE
58: , a2 out nocopy JTF_VARCHAR2_TABLE_300
59: , a3 out nocopy JTF_NUMBER_TABLE
60: , a4 out nocopy JTF_NUMBER_TABLE
61: , a5 out nocopy JTF_NUMBER_TABLE

Line 59: , a3 out nocopy JTF_NUMBER_TABLE

55: end rosetta_table_copy_in_p1;
56: procedure rosetta_table_copy_out_p1(t iem_spv_monitoring_pvt.email_activity_tbl, a0 out nocopy JTF_NUMBER_TABLE
57: , a1 out nocopy JTF_NUMBER_TABLE
58: , a2 out nocopy JTF_VARCHAR2_TABLE_300
59: , a3 out nocopy JTF_NUMBER_TABLE
60: , a4 out nocopy JTF_NUMBER_TABLE
61: , a5 out nocopy JTF_NUMBER_TABLE
62: , a6 out nocopy JTF_NUMBER_TABLE
63: , a7 out nocopy JTF_NUMBER_TABLE

Line 60: , a4 out nocopy JTF_NUMBER_TABLE

56: procedure rosetta_table_copy_out_p1(t iem_spv_monitoring_pvt.email_activity_tbl, a0 out nocopy JTF_NUMBER_TABLE
57: , a1 out nocopy JTF_NUMBER_TABLE
58: , a2 out nocopy JTF_VARCHAR2_TABLE_300
59: , a3 out nocopy JTF_NUMBER_TABLE
60: , a4 out nocopy JTF_NUMBER_TABLE
61: , a5 out nocopy JTF_NUMBER_TABLE
62: , a6 out nocopy JTF_NUMBER_TABLE
63: , a7 out nocopy JTF_NUMBER_TABLE
64: , a8 out nocopy JTF_NUMBER_TABLE

Line 61: , a5 out nocopy JTF_NUMBER_TABLE

57: , a1 out nocopy JTF_NUMBER_TABLE
58: , a2 out nocopy JTF_VARCHAR2_TABLE_300
59: , a3 out nocopy JTF_NUMBER_TABLE
60: , a4 out nocopy JTF_NUMBER_TABLE
61: , a5 out nocopy JTF_NUMBER_TABLE
62: , a6 out nocopy JTF_NUMBER_TABLE
63: , a7 out nocopy JTF_NUMBER_TABLE
64: , a8 out nocopy JTF_NUMBER_TABLE
65: , a9 out nocopy JTF_NUMBER_TABLE

Line 62: , a6 out nocopy JTF_NUMBER_TABLE

58: , a2 out nocopy JTF_VARCHAR2_TABLE_300
59: , a3 out nocopy JTF_NUMBER_TABLE
60: , a4 out nocopy JTF_NUMBER_TABLE
61: , a5 out nocopy JTF_NUMBER_TABLE
62: , a6 out nocopy JTF_NUMBER_TABLE
63: , a7 out nocopy JTF_NUMBER_TABLE
64: , a8 out nocopy JTF_NUMBER_TABLE
65: , a9 out nocopy JTF_NUMBER_TABLE
66: , a10 out nocopy JTF_NUMBER_TABLE

Line 63: , a7 out nocopy JTF_NUMBER_TABLE

59: , a3 out nocopy JTF_NUMBER_TABLE
60: , a4 out nocopy JTF_NUMBER_TABLE
61: , a5 out nocopy JTF_NUMBER_TABLE
62: , a6 out nocopy JTF_NUMBER_TABLE
63: , a7 out nocopy JTF_NUMBER_TABLE
64: , a8 out nocopy JTF_NUMBER_TABLE
65: , a9 out nocopy JTF_NUMBER_TABLE
66: , a10 out nocopy JTF_NUMBER_TABLE
67: , a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 64: , a8 out nocopy JTF_NUMBER_TABLE

60: , a4 out nocopy JTF_NUMBER_TABLE
61: , a5 out nocopy JTF_NUMBER_TABLE
62: , a6 out nocopy JTF_NUMBER_TABLE
63: , a7 out nocopy JTF_NUMBER_TABLE
64: , a8 out nocopy JTF_NUMBER_TABLE
65: , a9 out nocopy JTF_NUMBER_TABLE
66: , a10 out nocopy JTF_NUMBER_TABLE
67: , a11 out nocopy JTF_VARCHAR2_TABLE_100
68: , a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 65: , a9 out nocopy JTF_NUMBER_TABLE

61: , a5 out nocopy JTF_NUMBER_TABLE
62: , a6 out nocopy JTF_NUMBER_TABLE
63: , a7 out nocopy JTF_NUMBER_TABLE
64: , a8 out nocopy JTF_NUMBER_TABLE
65: , a9 out nocopy JTF_NUMBER_TABLE
66: , a10 out nocopy JTF_NUMBER_TABLE
67: , a11 out nocopy JTF_VARCHAR2_TABLE_100
68: , a12 out nocopy JTF_VARCHAR2_TABLE_100
69: ) as

Line 66: , a10 out nocopy JTF_NUMBER_TABLE

62: , a6 out nocopy JTF_NUMBER_TABLE
63: , a7 out nocopy JTF_NUMBER_TABLE
64: , a8 out nocopy JTF_NUMBER_TABLE
65: , a9 out nocopy JTF_NUMBER_TABLE
66: , a10 out nocopy JTF_NUMBER_TABLE
67: , a11 out nocopy JTF_VARCHAR2_TABLE_100
68: , a12 out nocopy JTF_VARCHAR2_TABLE_100
69: ) as
70: ddindx binary_integer; indx binary_integer;

Line 73: a0 := JTF_NUMBER_TABLE();

69: ) as
70: ddindx binary_integer; indx binary_integer;
71: begin
72: if t is null or t.count = 0 then
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_VARCHAR2_TABLE_300();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_NUMBER_TABLE();

Line 74: a1 := JTF_NUMBER_TABLE();

70: ddindx binary_integer; indx binary_integer;
71: begin
72: if t is null or t.count = 0 then
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_VARCHAR2_TABLE_300();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_NUMBER_TABLE();
78: a5 := JTF_NUMBER_TABLE();

Line 76: a3 := JTF_NUMBER_TABLE();

72: if t is null or t.count = 0 then
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_VARCHAR2_TABLE_300();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_NUMBER_TABLE();
78: a5 := JTF_NUMBER_TABLE();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_NUMBER_TABLE();

Line 77: a4 := JTF_NUMBER_TABLE();

73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_VARCHAR2_TABLE_300();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_NUMBER_TABLE();
78: a5 := JTF_NUMBER_TABLE();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_NUMBER_TABLE();

Line 78: a5 := JTF_NUMBER_TABLE();

74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_VARCHAR2_TABLE_300();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_NUMBER_TABLE();
78: a5 := JTF_NUMBER_TABLE();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_NUMBER_TABLE();

Line 79: a6 := JTF_NUMBER_TABLE();

75: a2 := JTF_VARCHAR2_TABLE_300();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_NUMBER_TABLE();
78: a5 := JTF_NUMBER_TABLE();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_NUMBER_TABLE();
83: a10 := JTF_NUMBER_TABLE();

Line 80: a7 := JTF_NUMBER_TABLE();

76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_NUMBER_TABLE();
78: a5 := JTF_NUMBER_TABLE();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_NUMBER_TABLE();
83: a10 := JTF_NUMBER_TABLE();
84: a11 := JTF_VARCHAR2_TABLE_100();

Line 81: a8 := JTF_NUMBER_TABLE();

77: a4 := JTF_NUMBER_TABLE();
78: a5 := JTF_NUMBER_TABLE();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_NUMBER_TABLE();
83: a10 := JTF_NUMBER_TABLE();
84: a11 := JTF_VARCHAR2_TABLE_100();
85: a12 := JTF_VARCHAR2_TABLE_100();

Line 82: a9 := JTF_NUMBER_TABLE();

78: a5 := JTF_NUMBER_TABLE();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_NUMBER_TABLE();
83: a10 := JTF_NUMBER_TABLE();
84: a11 := JTF_VARCHAR2_TABLE_100();
85: a12 := JTF_VARCHAR2_TABLE_100();
86: else

Line 83: a10 := JTF_NUMBER_TABLE();

79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_NUMBER_TABLE();
83: a10 := JTF_NUMBER_TABLE();
84: a11 := JTF_VARCHAR2_TABLE_100();
85: a12 := JTF_VARCHAR2_TABLE_100();
86: else
87: a0 := JTF_NUMBER_TABLE();

Line 87: a0 := JTF_NUMBER_TABLE();

83: a10 := JTF_NUMBER_TABLE();
84: a11 := JTF_VARCHAR2_TABLE_100();
85: a12 := JTF_VARCHAR2_TABLE_100();
86: else
87: a0 := JTF_NUMBER_TABLE();
88: a1 := JTF_NUMBER_TABLE();
89: a2 := JTF_VARCHAR2_TABLE_300();
90: a3 := JTF_NUMBER_TABLE();
91: a4 := JTF_NUMBER_TABLE();

Line 88: a1 := JTF_NUMBER_TABLE();

84: a11 := JTF_VARCHAR2_TABLE_100();
85: a12 := JTF_VARCHAR2_TABLE_100();
86: else
87: a0 := JTF_NUMBER_TABLE();
88: a1 := JTF_NUMBER_TABLE();
89: a2 := JTF_VARCHAR2_TABLE_300();
90: a3 := JTF_NUMBER_TABLE();
91: a4 := JTF_NUMBER_TABLE();
92: a5 := JTF_NUMBER_TABLE();

Line 90: a3 := JTF_NUMBER_TABLE();

86: else
87: a0 := JTF_NUMBER_TABLE();
88: a1 := JTF_NUMBER_TABLE();
89: a2 := JTF_VARCHAR2_TABLE_300();
90: a3 := JTF_NUMBER_TABLE();
91: a4 := JTF_NUMBER_TABLE();
92: a5 := JTF_NUMBER_TABLE();
93: a6 := JTF_NUMBER_TABLE();
94: a7 := JTF_NUMBER_TABLE();

Line 91: a4 := JTF_NUMBER_TABLE();

87: a0 := JTF_NUMBER_TABLE();
88: a1 := JTF_NUMBER_TABLE();
89: a2 := JTF_VARCHAR2_TABLE_300();
90: a3 := JTF_NUMBER_TABLE();
91: a4 := JTF_NUMBER_TABLE();
92: a5 := JTF_NUMBER_TABLE();
93: a6 := JTF_NUMBER_TABLE();
94: a7 := JTF_NUMBER_TABLE();
95: a8 := JTF_NUMBER_TABLE();

Line 92: a5 := JTF_NUMBER_TABLE();

88: a1 := JTF_NUMBER_TABLE();
89: a2 := JTF_VARCHAR2_TABLE_300();
90: a3 := JTF_NUMBER_TABLE();
91: a4 := JTF_NUMBER_TABLE();
92: a5 := JTF_NUMBER_TABLE();
93: a6 := JTF_NUMBER_TABLE();
94: a7 := JTF_NUMBER_TABLE();
95: a8 := JTF_NUMBER_TABLE();
96: a9 := JTF_NUMBER_TABLE();

Line 93: a6 := JTF_NUMBER_TABLE();

89: a2 := JTF_VARCHAR2_TABLE_300();
90: a3 := JTF_NUMBER_TABLE();
91: a4 := JTF_NUMBER_TABLE();
92: a5 := JTF_NUMBER_TABLE();
93: a6 := JTF_NUMBER_TABLE();
94: a7 := JTF_NUMBER_TABLE();
95: a8 := JTF_NUMBER_TABLE();
96: a9 := JTF_NUMBER_TABLE();
97: a10 := JTF_NUMBER_TABLE();

Line 94: a7 := JTF_NUMBER_TABLE();

90: a3 := JTF_NUMBER_TABLE();
91: a4 := JTF_NUMBER_TABLE();
92: a5 := JTF_NUMBER_TABLE();
93: a6 := JTF_NUMBER_TABLE();
94: a7 := JTF_NUMBER_TABLE();
95: a8 := JTF_NUMBER_TABLE();
96: a9 := JTF_NUMBER_TABLE();
97: a10 := JTF_NUMBER_TABLE();
98: a11 := JTF_VARCHAR2_TABLE_100();

Line 95: a8 := JTF_NUMBER_TABLE();

91: a4 := JTF_NUMBER_TABLE();
92: a5 := JTF_NUMBER_TABLE();
93: a6 := JTF_NUMBER_TABLE();
94: a7 := JTF_NUMBER_TABLE();
95: a8 := JTF_NUMBER_TABLE();
96: a9 := JTF_NUMBER_TABLE();
97: a10 := JTF_NUMBER_TABLE();
98: a11 := JTF_VARCHAR2_TABLE_100();
99: a12 := JTF_VARCHAR2_TABLE_100();

Line 96: a9 := JTF_NUMBER_TABLE();

92: a5 := JTF_NUMBER_TABLE();
93: a6 := JTF_NUMBER_TABLE();
94: a7 := JTF_NUMBER_TABLE();
95: a8 := JTF_NUMBER_TABLE();
96: a9 := JTF_NUMBER_TABLE();
97: a10 := JTF_NUMBER_TABLE();
98: a11 := JTF_VARCHAR2_TABLE_100();
99: a12 := JTF_VARCHAR2_TABLE_100();
100: if t.count > 0 then

Line 97: a10 := JTF_NUMBER_TABLE();

93: a6 := JTF_NUMBER_TABLE();
94: a7 := JTF_NUMBER_TABLE();
95: a8 := JTF_NUMBER_TABLE();
96: a9 := JTF_NUMBER_TABLE();
97: a10 := JTF_NUMBER_TABLE();
98: a11 := JTF_VARCHAR2_TABLE_100();
99: a12 := JTF_VARCHAR2_TABLE_100();
100: if t.count > 0 then
101: a0.extend(t.count);

Line 140: procedure rosetta_table_copy_in_p3(t out nocopy iem_spv_monitoring_pvt.agent_activity_tbl, a0 JTF_NUMBER_TABLE

136: end if;
137: end if;
138: end rosetta_table_copy_out_p1;
139:
140: procedure rosetta_table_copy_in_p3(t out nocopy iem_spv_monitoring_pvt.agent_activity_tbl, a0 JTF_NUMBER_TABLE
141: , a1 JTF_NUMBER_TABLE
142: , a2 JTF_VARCHAR2_TABLE_800
143: , a3 JTF_NUMBER_TABLE
144: , a4 JTF_NUMBER_TABLE

Line 141: , a1 JTF_NUMBER_TABLE

137: end if;
138: end rosetta_table_copy_out_p1;
139:
140: procedure rosetta_table_copy_in_p3(t out nocopy iem_spv_monitoring_pvt.agent_activity_tbl, a0 JTF_NUMBER_TABLE
141: , a1 JTF_NUMBER_TABLE
142: , a2 JTF_VARCHAR2_TABLE_800
143: , a3 JTF_NUMBER_TABLE
144: , a4 JTF_NUMBER_TABLE
145: , a5 JTF_NUMBER_TABLE

Line 143: , a3 JTF_NUMBER_TABLE

139:
140: procedure rosetta_table_copy_in_p3(t out nocopy iem_spv_monitoring_pvt.agent_activity_tbl, a0 JTF_NUMBER_TABLE
141: , a1 JTF_NUMBER_TABLE
142: , a2 JTF_VARCHAR2_TABLE_800
143: , a3 JTF_NUMBER_TABLE
144: , a4 JTF_NUMBER_TABLE
145: , a5 JTF_NUMBER_TABLE
146: , a6 JTF_NUMBER_TABLE
147: , a7 JTF_VARCHAR2_TABLE_500

Line 144: , a4 JTF_NUMBER_TABLE

140: procedure rosetta_table_copy_in_p3(t out nocopy iem_spv_monitoring_pvt.agent_activity_tbl, a0 JTF_NUMBER_TABLE
141: , a1 JTF_NUMBER_TABLE
142: , a2 JTF_VARCHAR2_TABLE_800
143: , a3 JTF_NUMBER_TABLE
144: , a4 JTF_NUMBER_TABLE
145: , a5 JTF_NUMBER_TABLE
146: , a6 JTF_NUMBER_TABLE
147: , a7 JTF_VARCHAR2_TABLE_500
148: , a8 JTF_NUMBER_TABLE

Line 145: , a5 JTF_NUMBER_TABLE

141: , a1 JTF_NUMBER_TABLE
142: , a2 JTF_VARCHAR2_TABLE_800
143: , a3 JTF_NUMBER_TABLE
144: , a4 JTF_NUMBER_TABLE
145: , a5 JTF_NUMBER_TABLE
146: , a6 JTF_NUMBER_TABLE
147: , a7 JTF_VARCHAR2_TABLE_500
148: , a8 JTF_NUMBER_TABLE
149: , a9 JTF_VARCHAR2_TABLE_100

Line 146: , a6 JTF_NUMBER_TABLE

142: , a2 JTF_VARCHAR2_TABLE_800
143: , a3 JTF_NUMBER_TABLE
144: , a4 JTF_NUMBER_TABLE
145: , a5 JTF_NUMBER_TABLE
146: , a6 JTF_NUMBER_TABLE
147: , a7 JTF_VARCHAR2_TABLE_500
148: , a8 JTF_NUMBER_TABLE
149: , a9 JTF_VARCHAR2_TABLE_100
150: , a10 JTF_VARCHAR2_TABLE_100

Line 148: , a8 JTF_NUMBER_TABLE

144: , a4 JTF_NUMBER_TABLE
145: , a5 JTF_NUMBER_TABLE
146: , a6 JTF_NUMBER_TABLE
147: , a7 JTF_VARCHAR2_TABLE_500
148: , a8 JTF_NUMBER_TABLE
149: , a9 JTF_VARCHAR2_TABLE_100
150: , a10 JTF_VARCHAR2_TABLE_100
151: ) as
152: ddindx binary_integer; indx binary_integer;

Line 179: procedure rosetta_table_copy_out_p3(t iem_spv_monitoring_pvt.agent_activity_tbl, a0 out nocopy JTF_NUMBER_TABLE

175: end loop;
176: end if;
177: end if;
178: end rosetta_table_copy_in_p3;
179: procedure rosetta_table_copy_out_p3(t iem_spv_monitoring_pvt.agent_activity_tbl, a0 out nocopy JTF_NUMBER_TABLE
180: , a1 out nocopy JTF_NUMBER_TABLE
181: , a2 out nocopy JTF_VARCHAR2_TABLE_800
182: , a3 out nocopy JTF_NUMBER_TABLE
183: , a4 out nocopy JTF_NUMBER_TABLE

Line 180: , a1 out nocopy JTF_NUMBER_TABLE

176: end if;
177: end if;
178: end rosetta_table_copy_in_p3;
179: procedure rosetta_table_copy_out_p3(t iem_spv_monitoring_pvt.agent_activity_tbl, a0 out nocopy JTF_NUMBER_TABLE
180: , a1 out nocopy JTF_NUMBER_TABLE
181: , a2 out nocopy JTF_VARCHAR2_TABLE_800
182: , a3 out nocopy JTF_NUMBER_TABLE
183: , a4 out nocopy JTF_NUMBER_TABLE
184: , a5 out nocopy JTF_NUMBER_TABLE

Line 182: , a3 out nocopy JTF_NUMBER_TABLE

178: end rosetta_table_copy_in_p3;
179: procedure rosetta_table_copy_out_p3(t iem_spv_monitoring_pvt.agent_activity_tbl, a0 out nocopy JTF_NUMBER_TABLE
180: , a1 out nocopy JTF_NUMBER_TABLE
181: , a2 out nocopy JTF_VARCHAR2_TABLE_800
182: , a3 out nocopy JTF_NUMBER_TABLE
183: , a4 out nocopy JTF_NUMBER_TABLE
184: , a5 out nocopy JTF_NUMBER_TABLE
185: , a6 out nocopy JTF_NUMBER_TABLE
186: , a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 183: , a4 out nocopy JTF_NUMBER_TABLE

179: procedure rosetta_table_copy_out_p3(t iem_spv_monitoring_pvt.agent_activity_tbl, a0 out nocopy JTF_NUMBER_TABLE
180: , a1 out nocopy JTF_NUMBER_TABLE
181: , a2 out nocopy JTF_VARCHAR2_TABLE_800
182: , a3 out nocopy JTF_NUMBER_TABLE
183: , a4 out nocopy JTF_NUMBER_TABLE
184: , a5 out nocopy JTF_NUMBER_TABLE
185: , a6 out nocopy JTF_NUMBER_TABLE
186: , a7 out nocopy JTF_VARCHAR2_TABLE_500
187: , a8 out nocopy JTF_NUMBER_TABLE

Line 184: , a5 out nocopy JTF_NUMBER_TABLE

180: , a1 out nocopy JTF_NUMBER_TABLE
181: , a2 out nocopy JTF_VARCHAR2_TABLE_800
182: , a3 out nocopy JTF_NUMBER_TABLE
183: , a4 out nocopy JTF_NUMBER_TABLE
184: , a5 out nocopy JTF_NUMBER_TABLE
185: , a6 out nocopy JTF_NUMBER_TABLE
186: , a7 out nocopy JTF_VARCHAR2_TABLE_500
187: , a8 out nocopy JTF_NUMBER_TABLE
188: , a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 185: , a6 out nocopy JTF_NUMBER_TABLE

181: , a2 out nocopy JTF_VARCHAR2_TABLE_800
182: , a3 out nocopy JTF_NUMBER_TABLE
183: , a4 out nocopy JTF_NUMBER_TABLE
184: , a5 out nocopy JTF_NUMBER_TABLE
185: , a6 out nocopy JTF_NUMBER_TABLE
186: , a7 out nocopy JTF_VARCHAR2_TABLE_500
187: , a8 out nocopy JTF_NUMBER_TABLE
188: , a9 out nocopy JTF_VARCHAR2_TABLE_100
189: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 187: , a8 out nocopy JTF_NUMBER_TABLE

183: , a4 out nocopy JTF_NUMBER_TABLE
184: , a5 out nocopy JTF_NUMBER_TABLE
185: , a6 out nocopy JTF_NUMBER_TABLE
186: , a7 out nocopy JTF_VARCHAR2_TABLE_500
187: , a8 out nocopy JTF_NUMBER_TABLE
188: , a9 out nocopy JTF_VARCHAR2_TABLE_100
189: , a10 out nocopy JTF_VARCHAR2_TABLE_100
190: ) as
191: ddindx binary_integer; indx binary_integer;

Line 194: a0 := JTF_NUMBER_TABLE();

190: ) as
191: ddindx binary_integer; indx binary_integer;
192: begin
193: if t is null or t.count = 0 then
194: a0 := JTF_NUMBER_TABLE();
195: a1 := JTF_NUMBER_TABLE();
196: a2 := JTF_VARCHAR2_TABLE_800();
197: a3 := JTF_NUMBER_TABLE();
198: a4 := JTF_NUMBER_TABLE();

Line 195: a1 := JTF_NUMBER_TABLE();

191: ddindx binary_integer; indx binary_integer;
192: begin
193: if t is null or t.count = 0 then
194: a0 := JTF_NUMBER_TABLE();
195: a1 := JTF_NUMBER_TABLE();
196: a2 := JTF_VARCHAR2_TABLE_800();
197: a3 := JTF_NUMBER_TABLE();
198: a4 := JTF_NUMBER_TABLE();
199: a5 := JTF_NUMBER_TABLE();

Line 197: a3 := JTF_NUMBER_TABLE();

193: if t is null or t.count = 0 then
194: a0 := JTF_NUMBER_TABLE();
195: a1 := JTF_NUMBER_TABLE();
196: a2 := JTF_VARCHAR2_TABLE_800();
197: a3 := JTF_NUMBER_TABLE();
198: a4 := JTF_NUMBER_TABLE();
199: a5 := JTF_NUMBER_TABLE();
200: a6 := JTF_NUMBER_TABLE();
201: a7 := JTF_VARCHAR2_TABLE_500();

Line 198: a4 := JTF_NUMBER_TABLE();

194: a0 := JTF_NUMBER_TABLE();
195: a1 := JTF_NUMBER_TABLE();
196: a2 := JTF_VARCHAR2_TABLE_800();
197: a3 := JTF_NUMBER_TABLE();
198: a4 := JTF_NUMBER_TABLE();
199: a5 := JTF_NUMBER_TABLE();
200: a6 := JTF_NUMBER_TABLE();
201: a7 := JTF_VARCHAR2_TABLE_500();
202: a8 := JTF_NUMBER_TABLE();

Line 199: a5 := JTF_NUMBER_TABLE();

195: a1 := JTF_NUMBER_TABLE();
196: a2 := JTF_VARCHAR2_TABLE_800();
197: a3 := JTF_NUMBER_TABLE();
198: a4 := JTF_NUMBER_TABLE();
199: a5 := JTF_NUMBER_TABLE();
200: a6 := JTF_NUMBER_TABLE();
201: a7 := JTF_VARCHAR2_TABLE_500();
202: a8 := JTF_NUMBER_TABLE();
203: a9 := JTF_VARCHAR2_TABLE_100();

Line 200: a6 := JTF_NUMBER_TABLE();

196: a2 := JTF_VARCHAR2_TABLE_800();
197: a3 := JTF_NUMBER_TABLE();
198: a4 := JTF_NUMBER_TABLE();
199: a5 := JTF_NUMBER_TABLE();
200: a6 := JTF_NUMBER_TABLE();
201: a7 := JTF_VARCHAR2_TABLE_500();
202: a8 := JTF_NUMBER_TABLE();
203: a9 := JTF_VARCHAR2_TABLE_100();
204: a10 := JTF_VARCHAR2_TABLE_100();

Line 202: a8 := JTF_NUMBER_TABLE();

198: a4 := JTF_NUMBER_TABLE();
199: a5 := JTF_NUMBER_TABLE();
200: a6 := JTF_NUMBER_TABLE();
201: a7 := JTF_VARCHAR2_TABLE_500();
202: a8 := JTF_NUMBER_TABLE();
203: a9 := JTF_VARCHAR2_TABLE_100();
204: a10 := JTF_VARCHAR2_TABLE_100();
205: else
206: a0 := JTF_NUMBER_TABLE();

Line 206: a0 := JTF_NUMBER_TABLE();

202: a8 := JTF_NUMBER_TABLE();
203: a9 := JTF_VARCHAR2_TABLE_100();
204: a10 := JTF_VARCHAR2_TABLE_100();
205: else
206: a0 := JTF_NUMBER_TABLE();
207: a1 := JTF_NUMBER_TABLE();
208: a2 := JTF_VARCHAR2_TABLE_800();
209: a3 := JTF_NUMBER_TABLE();
210: a4 := JTF_NUMBER_TABLE();

Line 207: a1 := JTF_NUMBER_TABLE();

203: a9 := JTF_VARCHAR2_TABLE_100();
204: a10 := JTF_VARCHAR2_TABLE_100();
205: else
206: a0 := JTF_NUMBER_TABLE();
207: a1 := JTF_NUMBER_TABLE();
208: a2 := JTF_VARCHAR2_TABLE_800();
209: a3 := JTF_NUMBER_TABLE();
210: a4 := JTF_NUMBER_TABLE();
211: a5 := JTF_NUMBER_TABLE();

Line 209: a3 := JTF_NUMBER_TABLE();

205: else
206: a0 := JTF_NUMBER_TABLE();
207: a1 := JTF_NUMBER_TABLE();
208: a2 := JTF_VARCHAR2_TABLE_800();
209: a3 := JTF_NUMBER_TABLE();
210: a4 := JTF_NUMBER_TABLE();
211: a5 := JTF_NUMBER_TABLE();
212: a6 := JTF_NUMBER_TABLE();
213: a7 := JTF_VARCHAR2_TABLE_500();

Line 210: a4 := JTF_NUMBER_TABLE();

206: a0 := JTF_NUMBER_TABLE();
207: a1 := JTF_NUMBER_TABLE();
208: a2 := JTF_VARCHAR2_TABLE_800();
209: a3 := JTF_NUMBER_TABLE();
210: a4 := JTF_NUMBER_TABLE();
211: a5 := JTF_NUMBER_TABLE();
212: a6 := JTF_NUMBER_TABLE();
213: a7 := JTF_VARCHAR2_TABLE_500();
214: a8 := JTF_NUMBER_TABLE();

Line 211: a5 := JTF_NUMBER_TABLE();

207: a1 := JTF_NUMBER_TABLE();
208: a2 := JTF_VARCHAR2_TABLE_800();
209: a3 := JTF_NUMBER_TABLE();
210: a4 := JTF_NUMBER_TABLE();
211: a5 := JTF_NUMBER_TABLE();
212: a6 := JTF_NUMBER_TABLE();
213: a7 := JTF_VARCHAR2_TABLE_500();
214: a8 := JTF_NUMBER_TABLE();
215: a9 := JTF_VARCHAR2_TABLE_100();

Line 212: a6 := JTF_NUMBER_TABLE();

208: a2 := JTF_VARCHAR2_TABLE_800();
209: a3 := JTF_NUMBER_TABLE();
210: a4 := JTF_NUMBER_TABLE();
211: a5 := JTF_NUMBER_TABLE();
212: a6 := JTF_NUMBER_TABLE();
213: a7 := JTF_VARCHAR2_TABLE_500();
214: a8 := JTF_NUMBER_TABLE();
215: a9 := JTF_VARCHAR2_TABLE_100();
216: a10 := JTF_VARCHAR2_TABLE_100();

Line 214: a8 := JTF_NUMBER_TABLE();

210: a4 := JTF_NUMBER_TABLE();
211: a5 := JTF_NUMBER_TABLE();
212: a6 := JTF_NUMBER_TABLE();
213: a7 := JTF_VARCHAR2_TABLE_500();
214: a8 := JTF_NUMBER_TABLE();
215: a9 := JTF_VARCHAR2_TABLE_100();
216: a10 := JTF_VARCHAR2_TABLE_100();
217: if t.count > 0 then
218: a0.extend(t.count);

Line 256: , p3_a0 out nocopy JTF_NUMBER_TABLE

252:
253: procedure get_email_activity(p_api_version_number NUMBER
254: , p_init_msg_list VARCHAR2
255: , p_commit VARCHAR2
256: , p3_a0 out nocopy JTF_NUMBER_TABLE
257: , p3_a1 out nocopy JTF_NUMBER_TABLE
258: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_300
259: , p3_a3 out nocopy JTF_NUMBER_TABLE
260: , p3_a4 out nocopy JTF_NUMBER_TABLE

Line 257: , p3_a1 out nocopy JTF_NUMBER_TABLE

253: procedure get_email_activity(p_api_version_number NUMBER
254: , p_init_msg_list VARCHAR2
255: , p_commit VARCHAR2
256: , p3_a0 out nocopy JTF_NUMBER_TABLE
257: , p3_a1 out nocopy JTF_NUMBER_TABLE
258: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_300
259: , p3_a3 out nocopy JTF_NUMBER_TABLE
260: , p3_a4 out nocopy JTF_NUMBER_TABLE
261: , p3_a5 out nocopy JTF_NUMBER_TABLE

Line 259: , p3_a3 out nocopy JTF_NUMBER_TABLE

255: , p_commit VARCHAR2
256: , p3_a0 out nocopy JTF_NUMBER_TABLE
257: , p3_a1 out nocopy JTF_NUMBER_TABLE
258: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_300
259: , p3_a3 out nocopy JTF_NUMBER_TABLE
260: , p3_a4 out nocopy JTF_NUMBER_TABLE
261: , p3_a5 out nocopy JTF_NUMBER_TABLE
262: , p3_a6 out nocopy JTF_NUMBER_TABLE
263: , p3_a7 out nocopy JTF_NUMBER_TABLE

Line 260: , p3_a4 out nocopy JTF_NUMBER_TABLE

256: , p3_a0 out nocopy JTF_NUMBER_TABLE
257: , p3_a1 out nocopy JTF_NUMBER_TABLE
258: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_300
259: , p3_a3 out nocopy JTF_NUMBER_TABLE
260: , p3_a4 out nocopy JTF_NUMBER_TABLE
261: , p3_a5 out nocopy JTF_NUMBER_TABLE
262: , p3_a6 out nocopy JTF_NUMBER_TABLE
263: , p3_a7 out nocopy JTF_NUMBER_TABLE
264: , p3_a8 out nocopy JTF_NUMBER_TABLE

Line 261: , p3_a5 out nocopy JTF_NUMBER_TABLE

257: , p3_a1 out nocopy JTF_NUMBER_TABLE
258: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_300
259: , p3_a3 out nocopy JTF_NUMBER_TABLE
260: , p3_a4 out nocopy JTF_NUMBER_TABLE
261: , p3_a5 out nocopy JTF_NUMBER_TABLE
262: , p3_a6 out nocopy JTF_NUMBER_TABLE
263: , p3_a7 out nocopy JTF_NUMBER_TABLE
264: , p3_a8 out nocopy JTF_NUMBER_TABLE
265: , p3_a9 out nocopy JTF_NUMBER_TABLE

Line 262: , p3_a6 out nocopy JTF_NUMBER_TABLE

258: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_300
259: , p3_a3 out nocopy JTF_NUMBER_TABLE
260: , p3_a4 out nocopy JTF_NUMBER_TABLE
261: , p3_a5 out nocopy JTF_NUMBER_TABLE
262: , p3_a6 out nocopy JTF_NUMBER_TABLE
263: , p3_a7 out nocopy JTF_NUMBER_TABLE
264: , p3_a8 out nocopy JTF_NUMBER_TABLE
265: , p3_a9 out nocopy JTF_NUMBER_TABLE
266: , p3_a10 out nocopy JTF_NUMBER_TABLE

Line 263: , p3_a7 out nocopy JTF_NUMBER_TABLE

259: , p3_a3 out nocopy JTF_NUMBER_TABLE
260: , p3_a4 out nocopy JTF_NUMBER_TABLE
261: , p3_a5 out nocopy JTF_NUMBER_TABLE
262: , p3_a6 out nocopy JTF_NUMBER_TABLE
263: , p3_a7 out nocopy JTF_NUMBER_TABLE
264: , p3_a8 out nocopy JTF_NUMBER_TABLE
265: , p3_a9 out nocopy JTF_NUMBER_TABLE
266: , p3_a10 out nocopy JTF_NUMBER_TABLE
267: , p3_a11 out nocopy JTF_VARCHAR2_TABLE_100

Line 264: , p3_a8 out nocopy JTF_NUMBER_TABLE

260: , p3_a4 out nocopy JTF_NUMBER_TABLE
261: , p3_a5 out nocopy JTF_NUMBER_TABLE
262: , p3_a6 out nocopy JTF_NUMBER_TABLE
263: , p3_a7 out nocopy JTF_NUMBER_TABLE
264: , p3_a8 out nocopy JTF_NUMBER_TABLE
265: , p3_a9 out nocopy JTF_NUMBER_TABLE
266: , p3_a10 out nocopy JTF_NUMBER_TABLE
267: , p3_a11 out nocopy JTF_VARCHAR2_TABLE_100
268: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 265: , p3_a9 out nocopy JTF_NUMBER_TABLE

261: , p3_a5 out nocopy JTF_NUMBER_TABLE
262: , p3_a6 out nocopy JTF_NUMBER_TABLE
263: , p3_a7 out nocopy JTF_NUMBER_TABLE
264: , p3_a8 out nocopy JTF_NUMBER_TABLE
265: , p3_a9 out nocopy JTF_NUMBER_TABLE
266: , p3_a10 out nocopy JTF_NUMBER_TABLE
267: , p3_a11 out nocopy JTF_VARCHAR2_TABLE_100
268: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
269: , x_return_status out nocopy VARCHAR2

Line 266: , p3_a10 out nocopy JTF_NUMBER_TABLE

262: , p3_a6 out nocopy JTF_NUMBER_TABLE
263: , p3_a7 out nocopy JTF_NUMBER_TABLE
264: , p3_a8 out nocopy JTF_NUMBER_TABLE
265: , p3_a9 out nocopy JTF_NUMBER_TABLE
266: , p3_a10 out nocopy JTF_NUMBER_TABLE
267: , p3_a11 out nocopy JTF_VARCHAR2_TABLE_100
268: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
269: , x_return_status out nocopy VARCHAR2
270: , x_msg_count out nocopy NUMBER

Line 324: , p5_a0 out nocopy JTF_NUMBER_TABLE

320: , p_init_msg_list VARCHAR2
321: , p_commit VARCHAR2
322: , p_resource_role NUMBER
323: , p_resource_name VARCHAR2
324: , p5_a0 out nocopy JTF_NUMBER_TABLE
325: , p5_a1 out nocopy JTF_NUMBER_TABLE
326: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_800
327: , p5_a3 out nocopy JTF_NUMBER_TABLE
328: , p5_a4 out nocopy JTF_NUMBER_TABLE

Line 325: , p5_a1 out nocopy JTF_NUMBER_TABLE

321: , p_commit VARCHAR2
322: , p_resource_role NUMBER
323: , p_resource_name VARCHAR2
324: , p5_a0 out nocopy JTF_NUMBER_TABLE
325: , p5_a1 out nocopy JTF_NUMBER_TABLE
326: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_800
327: , p5_a3 out nocopy JTF_NUMBER_TABLE
328: , p5_a4 out nocopy JTF_NUMBER_TABLE
329: , p5_a5 out nocopy JTF_NUMBER_TABLE

Line 327: , p5_a3 out nocopy JTF_NUMBER_TABLE

323: , p_resource_name VARCHAR2
324: , p5_a0 out nocopy JTF_NUMBER_TABLE
325: , p5_a1 out nocopy JTF_NUMBER_TABLE
326: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_800
327: , p5_a3 out nocopy JTF_NUMBER_TABLE
328: , p5_a4 out nocopy JTF_NUMBER_TABLE
329: , p5_a5 out nocopy JTF_NUMBER_TABLE
330: , p5_a6 out nocopy JTF_NUMBER_TABLE
331: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_500

Line 328: , p5_a4 out nocopy JTF_NUMBER_TABLE

324: , p5_a0 out nocopy JTF_NUMBER_TABLE
325: , p5_a1 out nocopy JTF_NUMBER_TABLE
326: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_800
327: , p5_a3 out nocopy JTF_NUMBER_TABLE
328: , p5_a4 out nocopy JTF_NUMBER_TABLE
329: , p5_a5 out nocopy JTF_NUMBER_TABLE
330: , p5_a6 out nocopy JTF_NUMBER_TABLE
331: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_500
332: , p5_a8 out nocopy JTF_NUMBER_TABLE

Line 329: , p5_a5 out nocopy JTF_NUMBER_TABLE

325: , p5_a1 out nocopy JTF_NUMBER_TABLE
326: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_800
327: , p5_a3 out nocopy JTF_NUMBER_TABLE
328: , p5_a4 out nocopy JTF_NUMBER_TABLE
329: , p5_a5 out nocopy JTF_NUMBER_TABLE
330: , p5_a6 out nocopy JTF_NUMBER_TABLE
331: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_500
332: , p5_a8 out nocopy JTF_NUMBER_TABLE
333: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100

Line 330: , p5_a6 out nocopy JTF_NUMBER_TABLE

326: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_800
327: , p5_a3 out nocopy JTF_NUMBER_TABLE
328: , p5_a4 out nocopy JTF_NUMBER_TABLE
329: , p5_a5 out nocopy JTF_NUMBER_TABLE
330: , p5_a6 out nocopy JTF_NUMBER_TABLE
331: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_500
332: , p5_a8 out nocopy JTF_NUMBER_TABLE
333: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100
334: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 332: , p5_a8 out nocopy JTF_NUMBER_TABLE

328: , p5_a4 out nocopy JTF_NUMBER_TABLE
329: , p5_a5 out nocopy JTF_NUMBER_TABLE
330: , p5_a6 out nocopy JTF_NUMBER_TABLE
331: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_500
332: , p5_a8 out nocopy JTF_NUMBER_TABLE
333: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_100
334: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
335: , x_return_status out nocopy VARCHAR2
336: , x_msg_count out nocopy NUMBER