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_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy cn_comp_plan_pvt.comp_plan_tbl_type, a0 JTF_NUMBER_TABLE

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

Line 29: , a26 JTF_NUMBER_TABLE

25: , a22 JTF_VARCHAR2_TABLE_200
26: , a23 JTF_VARCHAR2_TABLE_200
27: , a24 JTF_VARCHAR2_TABLE_200
28: , a25 JTF_VARCHAR2_TABLE_200
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: ) as
32: ddindx binary_integer; indx binary_integer;
33: begin

Line 30: , a27 JTF_NUMBER_TABLE

26: , a23 JTF_VARCHAR2_TABLE_200
27: , a24 JTF_VARCHAR2_TABLE_200
28: , a25 JTF_VARCHAR2_TABLE_200
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: ) as
32: ddindx binary_integer; indx binary_integer;
33: begin
34: if a0 is not null and a0.count > 0 then

Line 76: procedure rosetta_table_copy_out_p1(t cn_comp_plan_pvt.comp_plan_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

72: end loop;
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

Line 102: , a26 out nocopy JTF_NUMBER_TABLE

98: , a22 out nocopy JTF_VARCHAR2_TABLE_200
99: , a23 out nocopy JTF_VARCHAR2_TABLE_200
100: , a24 out nocopy JTF_VARCHAR2_TABLE_200
101: , a25 out nocopy JTF_VARCHAR2_TABLE_200
102: , a26 out nocopy JTF_NUMBER_TABLE
103: , a27 out nocopy JTF_NUMBER_TABLE
104: ) as
105: ddindx binary_integer; indx binary_integer;
106: begin

Line 103: , a27 out nocopy JTF_NUMBER_TABLE

99: , a23 out nocopy JTF_VARCHAR2_TABLE_200
100: , a24 out nocopy JTF_VARCHAR2_TABLE_200
101: , a25 out nocopy JTF_VARCHAR2_TABLE_200
102: , a26 out nocopy JTF_NUMBER_TABLE
103: , a27 out nocopy JTF_NUMBER_TABLE
104: ) as
105: ddindx binary_integer; indx binary_integer;
106: begin
107: if t is null or t.count = 0 then

Line 108: a0 := JTF_NUMBER_TABLE();

104: ) as
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();

Line 134: a26 := JTF_NUMBER_TABLE();

130: a22 := JTF_VARCHAR2_TABLE_200();
131: a23 := JTF_VARCHAR2_TABLE_200();
132: a24 := JTF_VARCHAR2_TABLE_200();
133: a25 := JTF_VARCHAR2_TABLE_200();
134: a26 := JTF_NUMBER_TABLE();
135: a27 := JTF_NUMBER_TABLE();
136: else
137: a0 := JTF_NUMBER_TABLE();
138: a1 := JTF_VARCHAR2_TABLE_100();

Line 135: a27 := JTF_NUMBER_TABLE();

131: a23 := JTF_VARCHAR2_TABLE_200();
132: a24 := JTF_VARCHAR2_TABLE_200();
133: a25 := JTF_VARCHAR2_TABLE_200();
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();

Line 137: a0 := JTF_NUMBER_TABLE();

133: a25 := JTF_VARCHAR2_TABLE_200();
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();

Line 163: a26 := JTF_NUMBER_TABLE();

159: a22 := JTF_VARCHAR2_TABLE_200();
160: a23 := JTF_VARCHAR2_TABLE_200();
161: a24 := JTF_VARCHAR2_TABLE_200();
162: a25 := JTF_VARCHAR2_TABLE_200();
163: a26 := JTF_NUMBER_TABLE();
164: a27 := JTF_NUMBER_TABLE();
165: if t.count > 0 then
166: a0.extend(t.count);
167: a1.extend(t.count);

Line 164: a27 := JTF_NUMBER_TABLE();

160: a23 := JTF_VARCHAR2_TABLE_200();
161: a24 := JTF_VARCHAR2_TABLE_200();
162: a25 := JTF_VARCHAR2_TABLE_200();
163: a26 := JTF_NUMBER_TABLE();
164: a27 := JTF_NUMBER_TABLE();
165: if t.count > 0 then
166: a0.extend(t.count);
167: a1.extend(t.count);
168: a2.extend(t.count);

Line 235: procedure rosetta_table_copy_in_p5(t out nocopy cn_comp_plan_pvt.sales_role_tbl_type, a0 JTF_NUMBER_TABLE

231: end if;
232: end if;
233: end rosetta_table_copy_out_p1;
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

Line 236: , a1 JTF_NUMBER_TABLE

232: end if;
233: end rosetta_table_copy_out_p1;
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

Line 237: , a2 JTF_NUMBER_TABLE

233: end rosetta_table_copy_out_p1;
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

Line 242: , a7 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
243: ) as
244: ddindx binary_integer; indx binary_integer;
245: begin
246: if a0 is not null and a0.count > 0 then

Line 268: procedure rosetta_table_copy_out_p5(t cn_comp_plan_pvt.sales_role_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

264: end loop;
265: end if;
266: end if;
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

Line 269: , a1 out nocopy JTF_NUMBER_TABLE

265: end if;
266: end if;
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

Line 270: , a2 out nocopy JTF_NUMBER_TABLE

266: end if;
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

Line 275: , a7 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
276: ) as
277: ddindx binary_integer; indx binary_integer;
278: begin
279: if t is null or t.count = 0 then

Line 280: a0 := JTF_NUMBER_TABLE();

276: ) as
277: ddindx binary_integer; indx binary_integer;
278: begin
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();

Line 281: a1 := JTF_NUMBER_TABLE();

277: ddindx binary_integer; indx binary_integer;
278: begin
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();

Line 282: a2 := JTF_NUMBER_TABLE();

278: begin
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();

Line 287: a7 := 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();
288: else
289: a0 := JTF_NUMBER_TABLE();
290: a1 := JTF_NUMBER_TABLE();
291: a2 := JTF_NUMBER_TABLE();

Line 289: a0 := JTF_NUMBER_TABLE();

285: a5 := JTF_DATE_TABLE();
286: a6 := JTF_DATE_TABLE();
287: a7 := JTF_NUMBER_TABLE();
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();

Line 290: a1 := JTF_NUMBER_TABLE();

286: a6 := JTF_DATE_TABLE();
287: a7 := JTF_NUMBER_TABLE();
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();

Line 291: a2 := JTF_NUMBER_TABLE();

287: a7 := JTF_NUMBER_TABLE();
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();

Line 296: a7 := 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();
297: if t.count > 0 then
298: a0.extend(t.count);
299: a1.extend(t.count);
300: a2.extend(t.count);

Line 327: procedure rosetta_table_copy_in_p7(t out nocopy cn_comp_plan_pvt.srp_plan_assign_tbl_type, a0 JTF_NUMBER_TABLE

323: end if;
324: end if;
325: end rosetta_table_copy_out_p5;
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

Line 328: , a1 JTF_NUMBER_TABLE

324: end if;
325: end rosetta_table_copy_out_p5;
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

Line 329: , a2 JTF_NUMBER_TABLE

325: end rosetta_table_copy_out_p5;
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

Line 360: procedure rosetta_table_copy_out_p7(t cn_comp_plan_pvt.srp_plan_assign_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

356: end loop;
357: end if;
358: end if;
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

Line 361: , a1 out nocopy JTF_NUMBER_TABLE

357: end if;
358: end if;
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

Line 362: , a2 out nocopy JTF_NUMBER_TABLE

358: end if;
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

Line 372: a0 := JTF_NUMBER_TABLE();

368: ) as
369: ddindx binary_integer; indx binary_integer;
370: begin
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();

Line 373: a1 := JTF_NUMBER_TABLE();

369: ddindx binary_integer; indx binary_integer;
370: begin
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();

Line 374: a2 := JTF_NUMBER_TABLE();

370: begin
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();

Line 381: a0 := JTF_NUMBER_TABLE();

377: a5 := JTF_VARCHAR2_TABLE_100();
378: a6 := JTF_DATE_TABLE();
379: a7 := JTF_DATE_TABLE();
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();

Line 382: a1 := JTF_NUMBER_TABLE();

378: a6 := JTF_DATE_TABLE();
379: a7 := JTF_DATE_TABLE();
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();

Line 383: a2 := JTF_NUMBER_TABLE();

379: a7 := JTF_DATE_TABLE();
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();

Line 813: , p9_a0 out nocopy JTF_NUMBER_TABLE

809: , p_fetch_size NUMBER
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

Line 839: , p9_a26 out nocopy JTF_NUMBER_TABLE

835: , p9_a22 out nocopy JTF_VARCHAR2_TABLE_200
836: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_200
837: , p9_a24 out nocopy JTF_VARCHAR2_TABLE_200
838: , p9_a25 out nocopy JTF_VARCHAR2_TABLE_200
839: , p9_a26 out nocopy JTF_NUMBER_TABLE
840: , p9_a27 out nocopy JTF_NUMBER_TABLE
841: , x_total_record out nocopy NUMBER
842: , x_return_status out nocopy VARCHAR2
843: , x_msg_count out nocopy NUMBER

Line 840: , p9_a27 out nocopy JTF_NUMBER_TABLE

836: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_200
837: , p9_a24 out nocopy JTF_VARCHAR2_TABLE_200
838: , p9_a25 out nocopy JTF_VARCHAR2_TABLE_200
839: , p9_a26 out nocopy JTF_NUMBER_TABLE
840: , p9_a27 out nocopy JTF_NUMBER_TABLE
841: , x_total_record out nocopy NUMBER
842: , x_return_status out nocopy VARCHAR2
843: , x_msg_count out nocopy NUMBER
844: , x_msg_data out nocopy VARCHAR2

Line 933: , p5_a0 out nocopy JTF_NUMBER_TABLE

929: , p_init_msg_list VARCHAR2
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

Line 959: , p5_a26 out nocopy JTF_NUMBER_TABLE

955: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_200
956: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_200
957: , p5_a24 out nocopy JTF_VARCHAR2_TABLE_200
958: , p5_a25 out nocopy JTF_VARCHAR2_TABLE_200
959: , p5_a26 out nocopy JTF_NUMBER_TABLE
960: , p5_a27 out nocopy JTF_NUMBER_TABLE
961: , x_return_status out nocopy VARCHAR2
962: , x_msg_count out nocopy NUMBER
963: , x_msg_data out nocopy VARCHAR2

Line 960: , p5_a27 out nocopy JTF_NUMBER_TABLE

956: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_200
957: , p5_a24 out nocopy JTF_VARCHAR2_TABLE_200
958: , p5_a25 out nocopy JTF_VARCHAR2_TABLE_200
959: , p5_a26 out nocopy JTF_NUMBER_TABLE
960: , p5_a27 out nocopy JTF_NUMBER_TABLE
961: , x_return_status out nocopy VARCHAR2
962: , x_msg_count out nocopy NUMBER
963: , x_msg_data out nocopy VARCHAR2
964: )

Line 1037: , p5_a0 out nocopy JTF_NUMBER_TABLE

1033: , p_init_msg_list VARCHAR2
1034: , p_commit VARCHAR2
1035: , p_validation_level NUMBER
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

Line 1038: , p5_a1 out nocopy JTF_NUMBER_TABLE

1034: , p_commit VARCHAR2
1035: , p_validation_level NUMBER
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

Line 1039: , p5_a2 out nocopy JTF_NUMBER_TABLE

1035: , p_validation_level NUMBER
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

Line 1044: , p5_a7 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
1045: , x_return_status out nocopy VARCHAR2
1046: , x_msg_count out nocopy NUMBER
1047: , x_msg_data out nocopy VARCHAR2
1048: )

Line 1199: , p4_a0 out nocopy JTF_NUMBER_TABLE

1195: procedure get_assigned_salesreps(p_comp_plan_id NUMBER
1196: , p_range_low NUMBER
1197: , p_range_high NUMBER
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

Line 1200: , p4_a1 out nocopy JTF_NUMBER_TABLE

1196: , p_range_low NUMBER
1197: , p_range_high NUMBER
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

Line 1201: , p4_a2 out nocopy JTF_NUMBER_TABLE

1197: , p_range_high NUMBER
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