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.12010000.2 2009/08/04 17:22:15 rnagaraj ship $ */
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 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_VARCHAR2_TABLE_200
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_NUMBER_TABLE
32: ) as
33: ddindx binary_integer; indx binary_integer;
34: begin

Line 31: , a28 JTF_NUMBER_TABLE

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

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

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

Line 105: , a27 out nocopy JTF_NUMBER_TABLE

101: , a23 out nocopy JTF_VARCHAR2_TABLE_200
102: , a24 out nocopy JTF_VARCHAR2_TABLE_200
103: , a25 out nocopy JTF_VARCHAR2_TABLE_200
104: , a26 out nocopy JTF_VARCHAR2_TABLE_200
105: , a27 out nocopy JTF_NUMBER_TABLE
106: , a28 out nocopy JTF_NUMBER_TABLE
107: ) as
108: ddindx binary_integer; indx binary_integer;
109: begin

Line 106: , a28 out nocopy JTF_NUMBER_TABLE

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

Line 111: a0 := JTF_NUMBER_TABLE();

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

Line 138: a27 := JTF_NUMBER_TABLE();

134: a23 := JTF_VARCHAR2_TABLE_200();
135: a24 := JTF_VARCHAR2_TABLE_200();
136: a25 := JTF_VARCHAR2_TABLE_200();
137: a26 := JTF_VARCHAR2_TABLE_200();
138: a27 := JTF_NUMBER_TABLE();
139: a28 := JTF_NUMBER_TABLE();
140: else
141: a0 := JTF_NUMBER_TABLE();
142: a1 := JTF_VARCHAR2_TABLE_100();

Line 139: a28 := JTF_NUMBER_TABLE();

135: a24 := JTF_VARCHAR2_TABLE_200();
136: a25 := JTF_VARCHAR2_TABLE_200();
137: a26 := JTF_VARCHAR2_TABLE_200();
138: a27 := JTF_NUMBER_TABLE();
139: a28 := JTF_NUMBER_TABLE();
140: else
141: a0 := JTF_NUMBER_TABLE();
142: a1 := JTF_VARCHAR2_TABLE_100();
143: a2 := JTF_VARCHAR2_TABLE_100();

Line 141: a0 := JTF_NUMBER_TABLE();

137: a26 := JTF_VARCHAR2_TABLE_200();
138: a27 := JTF_NUMBER_TABLE();
139: a28 := JTF_NUMBER_TABLE();
140: else
141: a0 := JTF_NUMBER_TABLE();
142: a1 := JTF_VARCHAR2_TABLE_100();
143: a2 := JTF_VARCHAR2_TABLE_100();
144: a3 := JTF_VARCHAR2_TABLE_1900();
145: a4 := JTF_VARCHAR2_TABLE_100();

Line 168: a27 := JTF_NUMBER_TABLE();

164: a23 := JTF_VARCHAR2_TABLE_200();
165: a24 := JTF_VARCHAR2_TABLE_200();
166: a25 := JTF_VARCHAR2_TABLE_200();
167: a26 := JTF_VARCHAR2_TABLE_200();
168: a27 := JTF_NUMBER_TABLE();
169: a28 := JTF_NUMBER_TABLE();
170: if t.count > 0 then
171: a0.extend(t.count);
172: a1.extend(t.count);

Line 169: a28 := JTF_NUMBER_TABLE();

165: a24 := JTF_VARCHAR2_TABLE_200();
166: a25 := JTF_VARCHAR2_TABLE_200();
167: a26 := JTF_VARCHAR2_TABLE_200();
168: a27 := JTF_NUMBER_TABLE();
169: a28 := JTF_NUMBER_TABLE();
170: if t.count > 0 then
171: a0.extend(t.count);
172: a1.extend(t.count);
173: a2.extend(t.count);

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

238: end if;
239: end if;
240: end rosetta_table_copy_out_p1;
241:
242: procedure rosetta_table_copy_in_p5(t out nocopy cn_comp_plan_pvt.sales_role_tbl_type, a0 JTF_NUMBER_TABLE
243: , a1 JTF_NUMBER_TABLE
244: , a2 JTF_NUMBER_TABLE
245: , a3 JTF_VARCHAR2_TABLE_100
246: , a4 JTF_VARCHAR2_TABLE_200

Line 243: , a1 JTF_NUMBER_TABLE

239: end if;
240: end rosetta_table_copy_out_p1;
241:
242: procedure rosetta_table_copy_in_p5(t out nocopy cn_comp_plan_pvt.sales_role_tbl_type, a0 JTF_NUMBER_TABLE
243: , a1 JTF_NUMBER_TABLE
244: , a2 JTF_NUMBER_TABLE
245: , a3 JTF_VARCHAR2_TABLE_100
246: , a4 JTF_VARCHAR2_TABLE_200
247: , a5 JTF_DATE_TABLE

Line 244: , a2 JTF_NUMBER_TABLE

240: end rosetta_table_copy_out_p1;
241:
242: procedure rosetta_table_copy_in_p5(t out nocopy cn_comp_plan_pvt.sales_role_tbl_type, a0 JTF_NUMBER_TABLE
243: , a1 JTF_NUMBER_TABLE
244: , a2 JTF_NUMBER_TABLE
245: , a3 JTF_VARCHAR2_TABLE_100
246: , a4 JTF_VARCHAR2_TABLE_200
247: , a5 JTF_DATE_TABLE
248: , a6 JTF_DATE_TABLE

Line 249: , a7 JTF_NUMBER_TABLE

245: , a3 JTF_VARCHAR2_TABLE_100
246: , a4 JTF_VARCHAR2_TABLE_200
247: , a5 JTF_DATE_TABLE
248: , a6 JTF_DATE_TABLE
249: , a7 JTF_NUMBER_TABLE
250: ) as
251: ddindx binary_integer; indx binary_integer;
252: begin
253: if a0 is not null and a0.count > 0 then

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

271: end loop;
272: end if;
273: end if;
274: end rosetta_table_copy_in_p5;
275: procedure rosetta_table_copy_out_p5(t cn_comp_plan_pvt.sales_role_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
276: , a1 out nocopy JTF_NUMBER_TABLE
277: , a2 out nocopy JTF_NUMBER_TABLE
278: , a3 out nocopy JTF_VARCHAR2_TABLE_100
279: , a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 276: , a1 out nocopy JTF_NUMBER_TABLE

272: end if;
273: end if;
274: end rosetta_table_copy_in_p5;
275: procedure rosetta_table_copy_out_p5(t cn_comp_plan_pvt.sales_role_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
276: , a1 out nocopy JTF_NUMBER_TABLE
277: , a2 out nocopy JTF_NUMBER_TABLE
278: , a3 out nocopy JTF_VARCHAR2_TABLE_100
279: , a4 out nocopy JTF_VARCHAR2_TABLE_200
280: , a5 out nocopy JTF_DATE_TABLE

Line 277: , a2 out nocopy JTF_NUMBER_TABLE

273: end if;
274: end rosetta_table_copy_in_p5;
275: procedure rosetta_table_copy_out_p5(t cn_comp_plan_pvt.sales_role_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
276: , a1 out nocopy JTF_NUMBER_TABLE
277: , a2 out nocopy JTF_NUMBER_TABLE
278: , a3 out nocopy JTF_VARCHAR2_TABLE_100
279: , a4 out nocopy JTF_VARCHAR2_TABLE_200
280: , a5 out nocopy JTF_DATE_TABLE
281: , a6 out nocopy JTF_DATE_TABLE

Line 282: , a7 out nocopy JTF_NUMBER_TABLE

278: , a3 out nocopy JTF_VARCHAR2_TABLE_100
279: , a4 out nocopy JTF_VARCHAR2_TABLE_200
280: , a5 out nocopy JTF_DATE_TABLE
281: , a6 out nocopy JTF_DATE_TABLE
282: , a7 out nocopy JTF_NUMBER_TABLE
283: ) as
284: ddindx binary_integer; indx binary_integer;
285: begin
286: if t is null or t.count = 0 then

Line 287: a0 := JTF_NUMBER_TABLE();

283: ) as
284: ddindx binary_integer; indx binary_integer;
285: begin
286: if t is null or t.count = 0 then
287: a0 := JTF_NUMBER_TABLE();
288: a1 := JTF_NUMBER_TABLE();
289: a2 := JTF_NUMBER_TABLE();
290: a3 := JTF_VARCHAR2_TABLE_100();
291: a4 := JTF_VARCHAR2_TABLE_200();

Line 288: a1 := JTF_NUMBER_TABLE();

284: ddindx binary_integer; indx binary_integer;
285: begin
286: if t is null or t.count = 0 then
287: a0 := JTF_NUMBER_TABLE();
288: a1 := JTF_NUMBER_TABLE();
289: a2 := JTF_NUMBER_TABLE();
290: a3 := JTF_VARCHAR2_TABLE_100();
291: a4 := JTF_VARCHAR2_TABLE_200();
292: a5 := JTF_DATE_TABLE();

Line 289: a2 := JTF_NUMBER_TABLE();

285: begin
286: if t is null or t.count = 0 then
287: a0 := JTF_NUMBER_TABLE();
288: a1 := JTF_NUMBER_TABLE();
289: a2 := JTF_NUMBER_TABLE();
290: a3 := JTF_VARCHAR2_TABLE_100();
291: a4 := JTF_VARCHAR2_TABLE_200();
292: a5 := JTF_DATE_TABLE();
293: a6 := JTF_DATE_TABLE();

Line 294: a7 := JTF_NUMBER_TABLE();

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

Line 296: a0 := JTF_NUMBER_TABLE();

292: a5 := JTF_DATE_TABLE();
293: a6 := JTF_DATE_TABLE();
294: a7 := JTF_NUMBER_TABLE();
295: else
296: a0 := JTF_NUMBER_TABLE();
297: a1 := JTF_NUMBER_TABLE();
298: a2 := JTF_NUMBER_TABLE();
299: a3 := JTF_VARCHAR2_TABLE_100();
300: a4 := JTF_VARCHAR2_TABLE_200();

Line 297: a1 := JTF_NUMBER_TABLE();

293: a6 := JTF_DATE_TABLE();
294: a7 := JTF_NUMBER_TABLE();
295: else
296: a0 := JTF_NUMBER_TABLE();
297: a1 := JTF_NUMBER_TABLE();
298: a2 := JTF_NUMBER_TABLE();
299: a3 := JTF_VARCHAR2_TABLE_100();
300: a4 := JTF_VARCHAR2_TABLE_200();
301: a5 := JTF_DATE_TABLE();

Line 298: a2 := JTF_NUMBER_TABLE();

294: a7 := JTF_NUMBER_TABLE();
295: else
296: a0 := JTF_NUMBER_TABLE();
297: a1 := JTF_NUMBER_TABLE();
298: a2 := JTF_NUMBER_TABLE();
299: a3 := JTF_VARCHAR2_TABLE_100();
300: a4 := JTF_VARCHAR2_TABLE_200();
301: a5 := JTF_DATE_TABLE();
302: a6 := JTF_DATE_TABLE();

Line 303: a7 := JTF_NUMBER_TABLE();

299: a3 := JTF_VARCHAR2_TABLE_100();
300: a4 := JTF_VARCHAR2_TABLE_200();
301: a5 := JTF_DATE_TABLE();
302: a6 := JTF_DATE_TABLE();
303: a7 := JTF_NUMBER_TABLE();
304: if t.count > 0 then
305: a0.extend(t.count);
306: a1.extend(t.count);
307: a2.extend(t.count);

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

330: end if;
331: end if;
332: end rosetta_table_copy_out_p5;
333:
334: procedure rosetta_table_copy_in_p7(t out nocopy cn_comp_plan_pvt.srp_plan_assign_tbl_type, a0 JTF_NUMBER_TABLE
335: , a1 JTF_NUMBER_TABLE
336: , a2 JTF_NUMBER_TABLE
337: , a3 JTF_VARCHAR2_TABLE_100
338: , a4 JTF_VARCHAR2_TABLE_400

Line 335: , a1 JTF_NUMBER_TABLE

331: end if;
332: end rosetta_table_copy_out_p5;
333:
334: procedure rosetta_table_copy_in_p7(t out nocopy cn_comp_plan_pvt.srp_plan_assign_tbl_type, a0 JTF_NUMBER_TABLE
335: , a1 JTF_NUMBER_TABLE
336: , a2 JTF_NUMBER_TABLE
337: , a3 JTF_VARCHAR2_TABLE_100
338: , a4 JTF_VARCHAR2_TABLE_400
339: , a5 JTF_VARCHAR2_TABLE_100

Line 336: , a2 JTF_NUMBER_TABLE

332: end rosetta_table_copy_out_p5;
333:
334: procedure rosetta_table_copy_in_p7(t out nocopy cn_comp_plan_pvt.srp_plan_assign_tbl_type, a0 JTF_NUMBER_TABLE
335: , a1 JTF_NUMBER_TABLE
336: , a2 JTF_NUMBER_TABLE
337: , a3 JTF_VARCHAR2_TABLE_100
338: , a4 JTF_VARCHAR2_TABLE_400
339: , a5 JTF_VARCHAR2_TABLE_100
340: , a6 JTF_DATE_TABLE

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

363: end loop;
364: end if;
365: end if;
366: end rosetta_table_copy_in_p7;
367: procedure rosetta_table_copy_out_p7(t cn_comp_plan_pvt.srp_plan_assign_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
368: , a1 out nocopy JTF_NUMBER_TABLE
369: , a2 out nocopy JTF_NUMBER_TABLE
370: , a3 out nocopy JTF_VARCHAR2_TABLE_100
371: , a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 368: , a1 out nocopy JTF_NUMBER_TABLE

364: end if;
365: end if;
366: end rosetta_table_copy_in_p7;
367: procedure rosetta_table_copy_out_p7(t cn_comp_plan_pvt.srp_plan_assign_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
368: , a1 out nocopy JTF_NUMBER_TABLE
369: , a2 out nocopy JTF_NUMBER_TABLE
370: , a3 out nocopy JTF_VARCHAR2_TABLE_100
371: , a4 out nocopy JTF_VARCHAR2_TABLE_400
372: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 369: , a2 out nocopy JTF_NUMBER_TABLE

365: end if;
366: end rosetta_table_copy_in_p7;
367: procedure rosetta_table_copy_out_p7(t cn_comp_plan_pvt.srp_plan_assign_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
368: , a1 out nocopy JTF_NUMBER_TABLE
369: , a2 out nocopy JTF_NUMBER_TABLE
370: , a3 out nocopy JTF_VARCHAR2_TABLE_100
371: , a4 out nocopy JTF_VARCHAR2_TABLE_400
372: , a5 out nocopy JTF_VARCHAR2_TABLE_100
373: , a6 out nocopy JTF_DATE_TABLE

Line 379: a0 := JTF_NUMBER_TABLE();

375: ) as
376: ddindx binary_integer; indx binary_integer;
377: begin
378: if t is null or t.count = 0 then
379: a0 := JTF_NUMBER_TABLE();
380: a1 := JTF_NUMBER_TABLE();
381: a2 := JTF_NUMBER_TABLE();
382: a3 := JTF_VARCHAR2_TABLE_100();
383: a4 := JTF_VARCHAR2_TABLE_400();

Line 380: a1 := JTF_NUMBER_TABLE();

376: ddindx binary_integer; indx binary_integer;
377: begin
378: if t is null or t.count = 0 then
379: a0 := JTF_NUMBER_TABLE();
380: a1 := JTF_NUMBER_TABLE();
381: a2 := JTF_NUMBER_TABLE();
382: a3 := JTF_VARCHAR2_TABLE_100();
383: a4 := JTF_VARCHAR2_TABLE_400();
384: a5 := JTF_VARCHAR2_TABLE_100();

Line 381: a2 := JTF_NUMBER_TABLE();

377: begin
378: if t is null or t.count = 0 then
379: a0 := JTF_NUMBER_TABLE();
380: a1 := JTF_NUMBER_TABLE();
381: a2 := JTF_NUMBER_TABLE();
382: a3 := JTF_VARCHAR2_TABLE_100();
383: a4 := JTF_VARCHAR2_TABLE_400();
384: a5 := JTF_VARCHAR2_TABLE_100();
385: a6 := JTF_DATE_TABLE();

Line 388: a0 := JTF_NUMBER_TABLE();

384: a5 := JTF_VARCHAR2_TABLE_100();
385: a6 := JTF_DATE_TABLE();
386: a7 := JTF_DATE_TABLE();
387: else
388: a0 := JTF_NUMBER_TABLE();
389: a1 := JTF_NUMBER_TABLE();
390: a2 := JTF_NUMBER_TABLE();
391: a3 := JTF_VARCHAR2_TABLE_100();
392: a4 := JTF_VARCHAR2_TABLE_400();

Line 389: a1 := JTF_NUMBER_TABLE();

385: a6 := JTF_DATE_TABLE();
386: a7 := JTF_DATE_TABLE();
387: else
388: a0 := JTF_NUMBER_TABLE();
389: a1 := JTF_NUMBER_TABLE();
390: a2 := JTF_NUMBER_TABLE();
391: a3 := JTF_VARCHAR2_TABLE_100();
392: a4 := JTF_VARCHAR2_TABLE_400();
393: a5 := JTF_VARCHAR2_TABLE_100();

Line 390: a2 := JTF_NUMBER_TABLE();

386: a7 := JTF_DATE_TABLE();
387: else
388: a0 := JTF_NUMBER_TABLE();
389: a1 := JTF_NUMBER_TABLE();
390: a2 := JTF_NUMBER_TABLE();
391: a3 := JTF_VARCHAR2_TABLE_100();
392: a4 := JTF_VARCHAR2_TABLE_400();
393: a5 := JTF_VARCHAR2_TABLE_100();
394: a6 := JTF_DATE_TABLE();

Line 829: , p9_a0 out nocopy JTF_NUMBER_TABLE

825: , p_fetch_size NUMBER
826: , p_search_name VARCHAR2
827: , p_search_date DATE
828: , p_search_status VARCHAR2
829: , p9_a0 out nocopy JTF_NUMBER_TABLE
830: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
831: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_100
832: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_1900
833: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 856: , p9_a27 out nocopy JTF_NUMBER_TABLE

852: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_200
853: , p9_a24 out nocopy JTF_VARCHAR2_TABLE_200
854: , p9_a25 out nocopy JTF_VARCHAR2_TABLE_200
855: , p9_a26 out nocopy JTF_VARCHAR2_TABLE_200
856: , p9_a27 out nocopy JTF_NUMBER_TABLE
857: , p9_a28 out nocopy JTF_NUMBER_TABLE
858: , x_total_record out nocopy NUMBER
859: , x_return_status out nocopy VARCHAR2
860: , x_msg_count out nocopy NUMBER

Line 857: , p9_a28 out nocopy JTF_NUMBER_TABLE

853: , p9_a24 out nocopy JTF_VARCHAR2_TABLE_200
854: , p9_a25 out nocopy JTF_VARCHAR2_TABLE_200
855: , p9_a26 out nocopy JTF_VARCHAR2_TABLE_200
856: , p9_a27 out nocopy JTF_NUMBER_TABLE
857: , p9_a28 out nocopy JTF_NUMBER_TABLE
858: , x_total_record out nocopy NUMBER
859: , x_return_status out nocopy VARCHAR2
860: , x_msg_count out nocopy NUMBER
861: , x_msg_data out nocopy VARCHAR2

Line 951: , p5_a0 out nocopy JTF_NUMBER_TABLE

947: , p_init_msg_list VARCHAR2
948: , p_commit VARCHAR2
949: , p_validation_level NUMBER
950: , p_comp_plan_id NUMBER
951: , p5_a0 out nocopy JTF_NUMBER_TABLE
952: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
953: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
954: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_1900
955: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 978: , p5_a27 out nocopy JTF_NUMBER_TABLE

974: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_200
975: , p5_a24 out nocopy JTF_VARCHAR2_TABLE_200
976: , p5_a25 out nocopy JTF_VARCHAR2_TABLE_200
977: , p5_a26 out nocopy JTF_VARCHAR2_TABLE_200
978: , p5_a27 out nocopy JTF_NUMBER_TABLE
979: , p5_a28 out nocopy JTF_NUMBER_TABLE
980: , x_return_status out nocopy VARCHAR2
981: , x_msg_count out nocopy NUMBER
982: , x_msg_data out nocopy VARCHAR2

Line 979: , p5_a28 out nocopy JTF_NUMBER_TABLE

975: , p5_a24 out nocopy JTF_VARCHAR2_TABLE_200
976: , p5_a25 out nocopy JTF_VARCHAR2_TABLE_200
977: , p5_a26 out nocopy JTF_VARCHAR2_TABLE_200
978: , p5_a27 out nocopy JTF_NUMBER_TABLE
979: , p5_a28 out nocopy JTF_NUMBER_TABLE
980: , x_return_status out nocopy VARCHAR2
981: , x_msg_count out nocopy NUMBER
982: , x_msg_data out nocopy VARCHAR2
983: )

Line 1057: , p5_a0 out nocopy JTF_NUMBER_TABLE

1053: , p_init_msg_list VARCHAR2
1054: , p_commit VARCHAR2
1055: , p_validation_level NUMBER
1056: , p_comp_plan_id NUMBER
1057: , p5_a0 out nocopy JTF_NUMBER_TABLE
1058: , p5_a1 out nocopy JTF_NUMBER_TABLE
1059: , p5_a2 out nocopy JTF_NUMBER_TABLE
1060: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
1061: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_200

Line 1058: , p5_a1 out nocopy JTF_NUMBER_TABLE

1054: , p_commit VARCHAR2
1055: , p_validation_level NUMBER
1056: , p_comp_plan_id NUMBER
1057: , p5_a0 out nocopy JTF_NUMBER_TABLE
1058: , p5_a1 out nocopy JTF_NUMBER_TABLE
1059: , p5_a2 out nocopy JTF_NUMBER_TABLE
1060: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
1061: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_200
1062: , p5_a5 out nocopy JTF_DATE_TABLE

Line 1059: , p5_a2 out nocopy JTF_NUMBER_TABLE

1055: , p_validation_level NUMBER
1056: , p_comp_plan_id NUMBER
1057: , p5_a0 out nocopy JTF_NUMBER_TABLE
1058: , p5_a1 out nocopy JTF_NUMBER_TABLE
1059: , p5_a2 out nocopy JTF_NUMBER_TABLE
1060: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
1061: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_200
1062: , p5_a5 out nocopy JTF_DATE_TABLE
1063: , p5_a6 out nocopy JTF_DATE_TABLE

Line 1064: , p5_a7 out nocopy JTF_NUMBER_TABLE

1060: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
1061: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_200
1062: , p5_a5 out nocopy JTF_DATE_TABLE
1063: , p5_a6 out nocopy JTF_DATE_TABLE
1064: , p5_a7 out nocopy JTF_NUMBER_TABLE
1065: , x_return_status out nocopy VARCHAR2
1066: , x_msg_count out nocopy NUMBER
1067: , x_msg_data out nocopy VARCHAR2
1068: )

Line 1221: , p4_a0 out nocopy JTF_NUMBER_TABLE

1217: procedure get_assigned_salesreps(p_comp_plan_id NUMBER
1218: , p_range_low NUMBER
1219: , p_range_high NUMBER
1220: , x_total_rows out nocopy NUMBER
1221: , p4_a0 out nocopy JTF_NUMBER_TABLE
1222: , p4_a1 out nocopy JTF_NUMBER_TABLE
1223: , p4_a2 out nocopy JTF_NUMBER_TABLE
1224: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1225: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_400

Line 1222: , p4_a1 out nocopy JTF_NUMBER_TABLE

1218: , p_range_low NUMBER
1219: , p_range_high NUMBER
1220: , x_total_rows out nocopy NUMBER
1221: , p4_a0 out nocopy JTF_NUMBER_TABLE
1222: , p4_a1 out nocopy JTF_NUMBER_TABLE
1223: , p4_a2 out nocopy JTF_NUMBER_TABLE
1224: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1225: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_400
1226: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 1223: , p4_a2 out nocopy JTF_NUMBER_TABLE

1219: , p_range_high NUMBER
1220: , x_total_rows out nocopy NUMBER
1221: , p4_a0 out nocopy JTF_NUMBER_TABLE
1222: , p4_a1 out nocopy JTF_NUMBER_TABLE
1223: , p4_a2 out nocopy JTF_NUMBER_TABLE
1224: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_100
1225: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_400
1226: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
1227: , p4_a6 out nocopy JTF_DATE_TABLE