eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_COMP_PLAN_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package body cn_comp_plan_pvt_w as
2: /* $Header: cnwcmpnb.pls 120.2 2005/09/14 03:38 vensrini noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_comp_plan_pvt.comp_plan_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_1900
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package body cn_comp_plan_pvt_w as
2: /* $Header: cnwcmpnb.pls 120.2 2005/09/14 03:38 vensrini noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_comp_plan_pvt.comp_plan_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_1900
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_DATE_TABLE

Line 7: , a4 JTF_VARCHAR2_TABLE_100

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

Line 8: , a5 JTF_VARCHAR2_TABLE_100

4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_1900
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE

Line 10: , a7 JTF_VARCHAR2_TABLE_100

6: , a3 JTF_VARCHAR2_TABLE_1900
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_200

Line 13: , a10 JTF_VARCHAR2_TABLE_100

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

Line 77: , a1 out nocopy JTF_VARCHAR2_TABLE_100

73: end if;
74: end if;
75: end rosetta_table_copy_in_p1;
76: procedure rosetta_table_copy_out_p1(t cn_comp_plan_pvt.comp_plan_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
77: , a1 out nocopy JTF_VARCHAR2_TABLE_100
78: , a2 out nocopy JTF_VARCHAR2_TABLE_100
79: , a3 out nocopy JTF_VARCHAR2_TABLE_1900
80: , a4 out nocopy JTF_VARCHAR2_TABLE_100
81: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 78: , a2 out nocopy JTF_VARCHAR2_TABLE_100

74: end if;
75: end rosetta_table_copy_in_p1;
76: procedure rosetta_table_copy_out_p1(t cn_comp_plan_pvt.comp_plan_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
77: , a1 out nocopy JTF_VARCHAR2_TABLE_100
78: , a2 out nocopy JTF_VARCHAR2_TABLE_100
79: , a3 out nocopy JTF_VARCHAR2_TABLE_1900
80: , a4 out nocopy JTF_VARCHAR2_TABLE_100
81: , a5 out nocopy JTF_VARCHAR2_TABLE_100
82: , a6 out nocopy JTF_DATE_TABLE

Line 80: , a4 out nocopy JTF_VARCHAR2_TABLE_100

76: procedure rosetta_table_copy_out_p1(t cn_comp_plan_pvt.comp_plan_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
77: , a1 out nocopy JTF_VARCHAR2_TABLE_100
78: , a2 out nocopy JTF_VARCHAR2_TABLE_100
79: , a3 out nocopy JTF_VARCHAR2_TABLE_1900
80: , a4 out nocopy JTF_VARCHAR2_TABLE_100
81: , a5 out nocopy JTF_VARCHAR2_TABLE_100
82: , a6 out nocopy JTF_DATE_TABLE
83: , a7 out nocopy JTF_VARCHAR2_TABLE_100
84: , a8 out nocopy JTF_DATE_TABLE

Line 81: , a5 out nocopy JTF_VARCHAR2_TABLE_100

77: , a1 out nocopy JTF_VARCHAR2_TABLE_100
78: , a2 out nocopy JTF_VARCHAR2_TABLE_100
79: , a3 out nocopy JTF_VARCHAR2_TABLE_1900
80: , a4 out nocopy JTF_VARCHAR2_TABLE_100
81: , a5 out nocopy JTF_VARCHAR2_TABLE_100
82: , a6 out nocopy JTF_DATE_TABLE
83: , a7 out nocopy JTF_VARCHAR2_TABLE_100
84: , a8 out nocopy JTF_DATE_TABLE
85: , a9 out nocopy JTF_DATE_TABLE

Line 83: , a7 out nocopy JTF_VARCHAR2_TABLE_100

79: , a3 out nocopy JTF_VARCHAR2_TABLE_1900
80: , a4 out nocopy JTF_VARCHAR2_TABLE_100
81: , a5 out nocopy JTF_VARCHAR2_TABLE_100
82: , a6 out nocopy JTF_DATE_TABLE
83: , a7 out nocopy JTF_VARCHAR2_TABLE_100
84: , a8 out nocopy JTF_DATE_TABLE
85: , a9 out nocopy JTF_DATE_TABLE
86: , a10 out nocopy JTF_VARCHAR2_TABLE_100
87: , a11 out nocopy JTF_VARCHAR2_TABLE_200

Line 86: , a10 out nocopy JTF_VARCHAR2_TABLE_100

82: , a6 out nocopy JTF_DATE_TABLE
83: , a7 out nocopy JTF_VARCHAR2_TABLE_100
84: , a8 out nocopy JTF_DATE_TABLE
85: , a9 out nocopy JTF_DATE_TABLE
86: , a10 out nocopy JTF_VARCHAR2_TABLE_100
87: , a11 out nocopy JTF_VARCHAR2_TABLE_200
88: , a12 out nocopy JTF_VARCHAR2_TABLE_200
89: , a13 out nocopy JTF_VARCHAR2_TABLE_200
90: , a14 out nocopy JTF_VARCHAR2_TABLE_200

Line 109: a1 := JTF_VARCHAR2_TABLE_100();

105: ddindx binary_integer; indx binary_integer;
106: begin
107: if t is null or t.count = 0 then
108: a0 := JTF_NUMBER_TABLE();
109: a1 := JTF_VARCHAR2_TABLE_100();
110: a2 := JTF_VARCHAR2_TABLE_100();
111: a3 := JTF_VARCHAR2_TABLE_1900();
112: a4 := JTF_VARCHAR2_TABLE_100();
113: a5 := JTF_VARCHAR2_TABLE_100();

Line 110: a2 := JTF_VARCHAR2_TABLE_100();

106: begin
107: if t is null or t.count = 0 then
108: a0 := JTF_NUMBER_TABLE();
109: a1 := JTF_VARCHAR2_TABLE_100();
110: a2 := JTF_VARCHAR2_TABLE_100();
111: a3 := JTF_VARCHAR2_TABLE_1900();
112: a4 := JTF_VARCHAR2_TABLE_100();
113: a5 := JTF_VARCHAR2_TABLE_100();
114: a6 := JTF_DATE_TABLE();

Line 112: a4 := JTF_VARCHAR2_TABLE_100();

108: a0 := JTF_NUMBER_TABLE();
109: a1 := JTF_VARCHAR2_TABLE_100();
110: a2 := JTF_VARCHAR2_TABLE_100();
111: a3 := JTF_VARCHAR2_TABLE_1900();
112: a4 := JTF_VARCHAR2_TABLE_100();
113: a5 := JTF_VARCHAR2_TABLE_100();
114: a6 := JTF_DATE_TABLE();
115: a7 := JTF_VARCHAR2_TABLE_100();
116: a8 := JTF_DATE_TABLE();

Line 113: a5 := JTF_VARCHAR2_TABLE_100();

109: a1 := JTF_VARCHAR2_TABLE_100();
110: a2 := JTF_VARCHAR2_TABLE_100();
111: a3 := JTF_VARCHAR2_TABLE_1900();
112: a4 := JTF_VARCHAR2_TABLE_100();
113: a5 := JTF_VARCHAR2_TABLE_100();
114: a6 := JTF_DATE_TABLE();
115: a7 := JTF_VARCHAR2_TABLE_100();
116: a8 := JTF_DATE_TABLE();
117: a9 := JTF_DATE_TABLE();

Line 115: a7 := JTF_VARCHAR2_TABLE_100();

111: a3 := JTF_VARCHAR2_TABLE_1900();
112: a4 := JTF_VARCHAR2_TABLE_100();
113: a5 := JTF_VARCHAR2_TABLE_100();
114: a6 := JTF_DATE_TABLE();
115: a7 := JTF_VARCHAR2_TABLE_100();
116: a8 := JTF_DATE_TABLE();
117: a9 := JTF_DATE_TABLE();
118: a10 := JTF_VARCHAR2_TABLE_100();
119: a11 := JTF_VARCHAR2_TABLE_200();

Line 118: a10 := JTF_VARCHAR2_TABLE_100();

114: a6 := JTF_DATE_TABLE();
115: a7 := JTF_VARCHAR2_TABLE_100();
116: a8 := JTF_DATE_TABLE();
117: a9 := JTF_DATE_TABLE();
118: a10 := JTF_VARCHAR2_TABLE_100();
119: a11 := JTF_VARCHAR2_TABLE_200();
120: a12 := JTF_VARCHAR2_TABLE_200();
121: a13 := JTF_VARCHAR2_TABLE_200();
122: a14 := JTF_VARCHAR2_TABLE_200();

Line 138: a1 := JTF_VARCHAR2_TABLE_100();

134: a26 := JTF_NUMBER_TABLE();
135: a27 := JTF_NUMBER_TABLE();
136: else
137: a0 := JTF_NUMBER_TABLE();
138: a1 := JTF_VARCHAR2_TABLE_100();
139: a2 := JTF_VARCHAR2_TABLE_100();
140: a3 := JTF_VARCHAR2_TABLE_1900();
141: a4 := JTF_VARCHAR2_TABLE_100();
142: a5 := JTF_VARCHAR2_TABLE_100();

Line 139: a2 := JTF_VARCHAR2_TABLE_100();

135: a27 := JTF_NUMBER_TABLE();
136: else
137: a0 := JTF_NUMBER_TABLE();
138: a1 := JTF_VARCHAR2_TABLE_100();
139: a2 := JTF_VARCHAR2_TABLE_100();
140: a3 := JTF_VARCHAR2_TABLE_1900();
141: a4 := JTF_VARCHAR2_TABLE_100();
142: a5 := JTF_VARCHAR2_TABLE_100();
143: a6 := JTF_DATE_TABLE();

Line 141: a4 := JTF_VARCHAR2_TABLE_100();

137: a0 := JTF_NUMBER_TABLE();
138: a1 := JTF_VARCHAR2_TABLE_100();
139: a2 := JTF_VARCHAR2_TABLE_100();
140: a3 := JTF_VARCHAR2_TABLE_1900();
141: a4 := JTF_VARCHAR2_TABLE_100();
142: a5 := JTF_VARCHAR2_TABLE_100();
143: a6 := JTF_DATE_TABLE();
144: a7 := JTF_VARCHAR2_TABLE_100();
145: a8 := JTF_DATE_TABLE();

Line 142: a5 := JTF_VARCHAR2_TABLE_100();

138: a1 := JTF_VARCHAR2_TABLE_100();
139: a2 := JTF_VARCHAR2_TABLE_100();
140: a3 := JTF_VARCHAR2_TABLE_1900();
141: a4 := JTF_VARCHAR2_TABLE_100();
142: a5 := JTF_VARCHAR2_TABLE_100();
143: a6 := JTF_DATE_TABLE();
144: a7 := JTF_VARCHAR2_TABLE_100();
145: a8 := JTF_DATE_TABLE();
146: a9 := JTF_DATE_TABLE();

Line 144: a7 := JTF_VARCHAR2_TABLE_100();

140: a3 := JTF_VARCHAR2_TABLE_1900();
141: a4 := JTF_VARCHAR2_TABLE_100();
142: a5 := JTF_VARCHAR2_TABLE_100();
143: a6 := JTF_DATE_TABLE();
144: a7 := JTF_VARCHAR2_TABLE_100();
145: a8 := JTF_DATE_TABLE();
146: a9 := JTF_DATE_TABLE();
147: a10 := JTF_VARCHAR2_TABLE_100();
148: a11 := JTF_VARCHAR2_TABLE_200();

Line 147: a10 := JTF_VARCHAR2_TABLE_100();

143: a6 := JTF_DATE_TABLE();
144: a7 := JTF_VARCHAR2_TABLE_100();
145: a8 := JTF_DATE_TABLE();
146: a9 := JTF_DATE_TABLE();
147: a10 := JTF_VARCHAR2_TABLE_100();
148: a11 := JTF_VARCHAR2_TABLE_200();
149: a12 := JTF_VARCHAR2_TABLE_200();
150: a13 := JTF_VARCHAR2_TABLE_200();
151: a14 := JTF_VARCHAR2_TABLE_200();

Line 238: , a3 JTF_VARCHAR2_TABLE_100

234:
235: procedure rosetta_table_copy_in_p5(t out nocopy cn_comp_plan_pvt.sales_role_tbl_type, a0 JTF_NUMBER_TABLE
236: , a1 JTF_NUMBER_TABLE
237: , a2 JTF_NUMBER_TABLE
238: , a3 JTF_VARCHAR2_TABLE_100
239: , a4 JTF_VARCHAR2_TABLE_200
240: , a5 JTF_DATE_TABLE
241: , a6 JTF_DATE_TABLE
242: , a7 JTF_NUMBER_TABLE

Line 271: , a3 out nocopy JTF_VARCHAR2_TABLE_100

267: end rosetta_table_copy_in_p5;
268: procedure rosetta_table_copy_out_p5(t cn_comp_plan_pvt.sales_role_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
269: , a1 out nocopy JTF_NUMBER_TABLE
270: , a2 out nocopy JTF_NUMBER_TABLE
271: , a3 out nocopy JTF_VARCHAR2_TABLE_100
272: , a4 out nocopy JTF_VARCHAR2_TABLE_200
273: , a5 out nocopy JTF_DATE_TABLE
274: , a6 out nocopy JTF_DATE_TABLE
275: , a7 out nocopy JTF_NUMBER_TABLE

Line 283: a3 := JTF_VARCHAR2_TABLE_100();

279: if t is null or t.count = 0 then
280: a0 := JTF_NUMBER_TABLE();
281: a1 := JTF_NUMBER_TABLE();
282: a2 := JTF_NUMBER_TABLE();
283: a3 := JTF_VARCHAR2_TABLE_100();
284: a4 := JTF_VARCHAR2_TABLE_200();
285: a5 := JTF_DATE_TABLE();
286: a6 := JTF_DATE_TABLE();
287: a7 := JTF_NUMBER_TABLE();

Line 292: a3 := JTF_VARCHAR2_TABLE_100();

288: else
289: a0 := JTF_NUMBER_TABLE();
290: a1 := JTF_NUMBER_TABLE();
291: a2 := JTF_NUMBER_TABLE();
292: a3 := JTF_VARCHAR2_TABLE_100();
293: a4 := JTF_VARCHAR2_TABLE_200();
294: a5 := JTF_DATE_TABLE();
295: a6 := JTF_DATE_TABLE();
296: a7 := JTF_NUMBER_TABLE();

Line 330: , a3 JTF_VARCHAR2_TABLE_100

326:
327: procedure rosetta_table_copy_in_p7(t out nocopy cn_comp_plan_pvt.srp_plan_assign_tbl_type, a0 JTF_NUMBER_TABLE
328: , a1 JTF_NUMBER_TABLE
329: , a2 JTF_NUMBER_TABLE
330: , a3 JTF_VARCHAR2_TABLE_100
331: , a4 JTF_VARCHAR2_TABLE_400
332: , a5 JTF_VARCHAR2_TABLE_100
333: , a6 JTF_DATE_TABLE
334: , a7 JTF_DATE_TABLE

Line 332: , a5 JTF_VARCHAR2_TABLE_100

328: , a1 JTF_NUMBER_TABLE
329: , a2 JTF_NUMBER_TABLE
330: , a3 JTF_VARCHAR2_TABLE_100
331: , a4 JTF_VARCHAR2_TABLE_400
332: , a5 JTF_VARCHAR2_TABLE_100
333: , a6 JTF_DATE_TABLE
334: , a7 JTF_DATE_TABLE
335: ) as
336: ddindx binary_integer; indx binary_integer;

Line 363: , a3 out nocopy JTF_VARCHAR2_TABLE_100

359: end rosetta_table_copy_in_p7;
360: procedure rosetta_table_copy_out_p7(t cn_comp_plan_pvt.srp_plan_assign_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
361: , a1 out nocopy JTF_NUMBER_TABLE
362: , a2 out nocopy JTF_NUMBER_TABLE
363: , a3 out nocopy JTF_VARCHAR2_TABLE_100
364: , a4 out nocopy JTF_VARCHAR2_TABLE_400
365: , a5 out nocopy JTF_VARCHAR2_TABLE_100
366: , a6 out nocopy JTF_DATE_TABLE
367: , a7 out nocopy JTF_DATE_TABLE

Line 365: , a5 out nocopy JTF_VARCHAR2_TABLE_100

361: , a1 out nocopy JTF_NUMBER_TABLE
362: , a2 out nocopy JTF_NUMBER_TABLE
363: , a3 out nocopy JTF_VARCHAR2_TABLE_100
364: , a4 out nocopy JTF_VARCHAR2_TABLE_400
365: , a5 out nocopy JTF_VARCHAR2_TABLE_100
366: , a6 out nocopy JTF_DATE_TABLE
367: , a7 out nocopy JTF_DATE_TABLE
368: ) as
369: ddindx binary_integer; indx binary_integer;

Line 375: a3 := JTF_VARCHAR2_TABLE_100();

371: if t is null or t.count = 0 then
372: a0 := JTF_NUMBER_TABLE();
373: a1 := JTF_NUMBER_TABLE();
374: a2 := JTF_NUMBER_TABLE();
375: a3 := JTF_VARCHAR2_TABLE_100();
376: a4 := JTF_VARCHAR2_TABLE_400();
377: a5 := JTF_VARCHAR2_TABLE_100();
378: a6 := JTF_DATE_TABLE();
379: a7 := JTF_DATE_TABLE();

Line 377: a5 := JTF_VARCHAR2_TABLE_100();

373: a1 := JTF_NUMBER_TABLE();
374: a2 := JTF_NUMBER_TABLE();
375: a3 := JTF_VARCHAR2_TABLE_100();
376: a4 := JTF_VARCHAR2_TABLE_400();
377: a5 := JTF_VARCHAR2_TABLE_100();
378: a6 := JTF_DATE_TABLE();
379: a7 := JTF_DATE_TABLE();
380: else
381: a0 := JTF_NUMBER_TABLE();

Line 384: a3 := JTF_VARCHAR2_TABLE_100();

380: else
381: a0 := JTF_NUMBER_TABLE();
382: a1 := JTF_NUMBER_TABLE();
383: a2 := JTF_NUMBER_TABLE();
384: a3 := JTF_VARCHAR2_TABLE_100();
385: a4 := JTF_VARCHAR2_TABLE_400();
386: a5 := JTF_VARCHAR2_TABLE_100();
387: a6 := JTF_DATE_TABLE();
388: a7 := JTF_DATE_TABLE();

Line 386: a5 := JTF_VARCHAR2_TABLE_100();

382: a1 := JTF_NUMBER_TABLE();
383: a2 := JTF_NUMBER_TABLE();
384: a3 := JTF_VARCHAR2_TABLE_100();
385: a4 := JTF_VARCHAR2_TABLE_400();
386: a5 := JTF_VARCHAR2_TABLE_100();
387: a6 := JTF_DATE_TABLE();
388: a7 := JTF_DATE_TABLE();
389: if t.count > 0 then
390: a0.extend(t.count);

Line 814: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100

810: , p_search_name VARCHAR2
811: , p_search_date DATE
812: , p_search_status VARCHAR2
813: , p9_a0 out nocopy JTF_NUMBER_TABLE
814: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
815: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
816: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_1900
817: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
818: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 815: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100

811: , p_search_date DATE
812: , p_search_status VARCHAR2
813: , p9_a0 out nocopy JTF_NUMBER_TABLE
814: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
815: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
816: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_1900
817: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
818: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
819: , p9_a6 out nocopy JTF_DATE_TABLE

Line 817: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100

813: , p9_a0 out nocopy JTF_NUMBER_TABLE
814: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
815: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
816: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_1900
817: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
818: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
819: , p9_a6 out nocopy JTF_DATE_TABLE
820: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
821: , p9_a8 out nocopy JTF_DATE_TABLE

Line 818: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100

814: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
815: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
816: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_1900
817: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
818: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
819: , p9_a6 out nocopy JTF_DATE_TABLE
820: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
821: , p9_a8 out nocopy JTF_DATE_TABLE
822: , p9_a9 out nocopy JTF_DATE_TABLE

Line 820: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100

816: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_1900
817: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100
818: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
819: , p9_a6 out nocopy JTF_DATE_TABLE
820: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
821: , p9_a8 out nocopy JTF_DATE_TABLE
822: , p9_a9 out nocopy JTF_DATE_TABLE
823: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
824: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_200

Line 823: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100

819: , p9_a6 out nocopy JTF_DATE_TABLE
820: , p9_a7 out nocopy JTF_VARCHAR2_TABLE_100
821: , p9_a8 out nocopy JTF_DATE_TABLE
822: , p9_a9 out nocopy JTF_DATE_TABLE
823: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
824: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_200
825: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_200
826: , p9_a13 out nocopy JTF_VARCHAR2_TABLE_200
827: , p9_a14 out nocopy JTF_VARCHAR2_TABLE_200

Line 934: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100

930: , p_commit VARCHAR2
931: , p_validation_level NUMBER
932: , p_comp_plan_id NUMBER
933: , p5_a0 out nocopy JTF_NUMBER_TABLE
934: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
935: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
936: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_1900
937: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
938: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 935: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100

931: , p_validation_level NUMBER
932: , p_comp_plan_id NUMBER
933: , p5_a0 out nocopy JTF_NUMBER_TABLE
934: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
935: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
936: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_1900
937: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
938: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
939: , p5_a6 out nocopy JTF_DATE_TABLE

Line 937: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100

933: , p5_a0 out nocopy JTF_NUMBER_TABLE
934: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
935: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
936: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_1900
937: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
938: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
939: , p5_a6 out nocopy JTF_DATE_TABLE
940: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
941: , p5_a8 out nocopy JTF_DATE_TABLE

Line 938: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100

934: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
935: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
936: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_1900
937: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
938: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
939: , p5_a6 out nocopy JTF_DATE_TABLE
940: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
941: , p5_a8 out nocopy JTF_DATE_TABLE
942: , p5_a9 out nocopy JTF_DATE_TABLE

Line 940: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100

936: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_1900
937: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
938: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
939: , p5_a6 out nocopy JTF_DATE_TABLE
940: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
941: , p5_a8 out nocopy JTF_DATE_TABLE
942: , p5_a9 out nocopy JTF_DATE_TABLE
943: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
944: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_200

Line 943: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100

939: , p5_a6 out nocopy JTF_DATE_TABLE
940: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_100
941: , p5_a8 out nocopy JTF_DATE_TABLE
942: , p5_a9 out nocopy JTF_DATE_TABLE
943: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_100
944: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_200
945: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_200
946: , p5_a13 out nocopy JTF_VARCHAR2_TABLE_200
947: , p5_a14 out nocopy JTF_VARCHAR2_TABLE_200

Line 1040: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100

1036: , p_comp_plan_id NUMBER
1037: , p5_a0 out nocopy JTF_NUMBER_TABLE
1038: , p5_a1 out nocopy JTF_NUMBER_TABLE
1039: , p5_a2 out nocopy JTF_NUMBER_TABLE
1040: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
1041: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_200
1042: , p5_a5 out nocopy JTF_DATE_TABLE
1043: , p5_a6 out nocopy JTF_DATE_TABLE
1044: , p5_a7 out nocopy JTF_NUMBER_TABLE

Line 1202: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100

1198: , x_total_rows out nocopy NUMBER
1199: , p4_a0 out nocopy JTF_NUMBER_TABLE
1200: , p4_a1 out nocopy JTF_NUMBER_TABLE
1201: , p4_a2 out nocopy JTF_NUMBER_TABLE
1202: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1203: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_400
1204: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
1205: , p4_a6 out nocopy JTF_DATE_TABLE
1206: , p4_a7 out nocopy JTF_DATE_TABLE

Line 1204: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100

1200: , p4_a1 out nocopy JTF_NUMBER_TABLE
1201: , p4_a2 out nocopy JTF_NUMBER_TABLE
1202: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1203: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_400
1204: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
1205: , p4_a6 out nocopy JTF_DATE_TABLE
1206: , p4_a7 out nocopy JTF_DATE_TABLE
1207: )
1208: