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_GET_COMM_SUMM_DATA_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package body cn_get_comm_summ_data_pvt_w as
2: /* $Header: cnwcommb.pls 120.4 2005/10/24 07:22 sjustina noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_get_comm_summ_data_pvt.comm_summ_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package body cn_get_comm_summ_data_pvt_w as
2: /* $Header: cnwcommb.pls 120.4 2005/10/24 07:22 sjustina noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_get_comm_summ_data_pvt.comm_summ_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE

Line 37: , a1 out nocopy JTF_VARCHAR2_TABLE_100

33: end if;
34: end if;
35: end rosetta_table_copy_in_p1;
36: procedure rosetta_table_copy_out_p1(t cn_get_comm_summ_data_pvt.comm_summ_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_VARCHAR2_TABLE_100
38: , a2 out nocopy JTF_VARCHAR2_TABLE_100
39: , a3 out nocopy JTF_DATE_TABLE
40: , a4 out nocopy JTF_DATE_TABLE
41: , a5 out nocopy JTF_NUMBER_TABLE

Line 38: , a2 out nocopy JTF_VARCHAR2_TABLE_100

34: end if;
35: end rosetta_table_copy_in_p1;
36: procedure rosetta_table_copy_out_p1(t cn_get_comm_summ_data_pvt.comm_summ_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_VARCHAR2_TABLE_100
38: , a2 out nocopy JTF_VARCHAR2_TABLE_100
39: , a3 out nocopy JTF_DATE_TABLE
40: , a4 out nocopy JTF_DATE_TABLE
41: , a5 out nocopy JTF_NUMBER_TABLE
42: , a6 out nocopy JTF_NUMBER_TABLE

Line 49: a1 := JTF_VARCHAR2_TABLE_100();

45: ddindx binary_integer; indx binary_integer;
46: begin
47: if t is null or t.count = 0 then
48: a0 := JTF_NUMBER_TABLE();
49: a1 := JTF_VARCHAR2_TABLE_100();
50: a2 := JTF_VARCHAR2_TABLE_100();
51: a3 := JTF_DATE_TABLE();
52: a4 := JTF_DATE_TABLE();
53: a5 := JTF_NUMBER_TABLE();

Line 50: a2 := JTF_VARCHAR2_TABLE_100();

46: begin
47: if t is null or t.count = 0 then
48: a0 := JTF_NUMBER_TABLE();
49: a1 := JTF_VARCHAR2_TABLE_100();
50: a2 := JTF_VARCHAR2_TABLE_100();
51: a3 := JTF_DATE_TABLE();
52: a4 := JTF_DATE_TABLE();
53: a5 := JTF_NUMBER_TABLE();
54: a6 := JTF_NUMBER_TABLE();

Line 58: a1 := JTF_VARCHAR2_TABLE_100();

54: a6 := JTF_NUMBER_TABLE();
55: a7 := JTF_NUMBER_TABLE();
56: else
57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_VARCHAR2_TABLE_100();
59: a2 := JTF_VARCHAR2_TABLE_100();
60: a3 := JTF_DATE_TABLE();
61: a4 := JTF_DATE_TABLE();
62: a5 := JTF_NUMBER_TABLE();

Line 59: a2 := JTF_VARCHAR2_TABLE_100();

55: a7 := JTF_NUMBER_TABLE();
56: else
57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_VARCHAR2_TABLE_100();
59: a2 := JTF_VARCHAR2_TABLE_100();
60: a3 := JTF_DATE_TABLE();
61: a4 := JTF_DATE_TABLE();
62: a5 := JTF_NUMBER_TABLE();
63: a6 := JTF_NUMBER_TABLE();

Line 136: procedure rosetta_table_copy_in_p3(t out nocopy cn_get_comm_summ_data_pvt.group_code_tbl_type, a0 JTF_VARCHAR2_TABLE_100) as

132: end if;
133: end if;
134: end rosetta_table_copy_out_p2;
135:
136: procedure rosetta_table_copy_in_p3(t out nocopy cn_get_comm_summ_data_pvt.group_code_tbl_type, a0 JTF_VARCHAR2_TABLE_100) as
137: ddindx binary_integer; indx binary_integer;
138: begin
139: if a0 is not null and a0.count > 0 then
140: if a0.count > 0 then

Line 154: procedure rosetta_table_copy_out_p3(t cn_get_comm_summ_data_pvt.group_code_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

150: end loop;
151: end if;
152: end if;
153: end rosetta_table_copy_in_p3;
154: procedure rosetta_table_copy_out_p3(t cn_get_comm_summ_data_pvt.group_code_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
155: ddindx binary_integer; indx binary_integer;
156: begin
157: if t is null or t.count = 0 then
158: a0 := JTF_VARCHAR2_TABLE_100();

Line 158: a0 := JTF_VARCHAR2_TABLE_100();

154: procedure rosetta_table_copy_out_p3(t cn_get_comm_summ_data_pvt.group_code_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
155: ddindx binary_integer; indx binary_integer;
156: begin
157: if t is null or t.count = 0 then
158: a0 := JTF_VARCHAR2_TABLE_100();
159: else
160: a0 := JTF_VARCHAR2_TABLE_100();
161: if t.count > 0 then
162: a0.extend(t.count);

Line 160: a0 := JTF_VARCHAR2_TABLE_100();

156: begin
157: if t is null or t.count = 0 then
158: a0 := JTF_VARCHAR2_TABLE_100();
159: else
160: a0 := JTF_VARCHAR2_TABLE_100();
161: if t.count > 0 then
162: a0.extend(t.count);
163: ddindx := t.first;
164: indx := 1;

Line 178: , a1 JTF_VARCHAR2_TABLE_100

174: end if;
175: end rosetta_table_copy_out_p3;
176:
177: procedure rosetta_table_copy_in_p5(t out nocopy cn_get_comm_summ_data_pvt.pe_info_tbl_type, a0 JTF_NUMBER_TABLE
178: , a1 JTF_VARCHAR2_TABLE_100
179: , a2 JTF_NUMBER_TABLE
180: , a3 JTF_NUMBER_TABLE
181: , a4 JTF_NUMBER_TABLE
182: , a5 JTF_NUMBER_TABLE

Line 219: , a1 out nocopy JTF_VARCHAR2_TABLE_100

215: end if;
216: end if;
217: end rosetta_table_copy_in_p5;
218: procedure rosetta_table_copy_out_p5(t cn_get_comm_summ_data_pvt.pe_info_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
219: , a1 out nocopy JTF_VARCHAR2_TABLE_100
220: , a2 out nocopy JTF_NUMBER_TABLE
221: , a3 out nocopy JTF_NUMBER_TABLE
222: , a4 out nocopy JTF_NUMBER_TABLE
223: , a5 out nocopy JTF_NUMBER_TABLE

Line 235: a1 := JTF_VARCHAR2_TABLE_100();

231: ddindx binary_integer; indx binary_integer;
232: begin
233: if t is null or t.count = 0 then
234: a0 := JTF_NUMBER_TABLE();
235: a1 := JTF_VARCHAR2_TABLE_100();
236: a2 := JTF_NUMBER_TABLE();
237: a3 := JTF_NUMBER_TABLE();
238: a4 := JTF_NUMBER_TABLE();
239: a5 := JTF_NUMBER_TABLE();

Line 248: a1 := JTF_VARCHAR2_TABLE_100();

244: a10 := JTF_NUMBER_TABLE();
245: a11 := JTF_NUMBER_TABLE();
246: else
247: a0 := JTF_NUMBER_TABLE();
248: a1 := JTF_VARCHAR2_TABLE_100();
249: a2 := JTF_NUMBER_TABLE();
250: a3 := JTF_NUMBER_TABLE();
251: a4 := JTF_NUMBER_TABLE();
252: a5 := JTF_NUMBER_TABLE();

Line 298: , a1 JTF_VARCHAR2_TABLE_100

294: end if;
295: end rosetta_table_copy_out_p5;
296:
297: procedure rosetta_table_copy_in_p7(t out nocopy cn_get_comm_summ_data_pvt.salesrep_info_tbl_type, a0 JTF_VARCHAR2_TABLE_400
298: , a1 JTF_VARCHAR2_TABLE_100
299: , a2 JTF_VARCHAR2_TABLE_100
300: , a3 JTF_VARCHAR2_TABLE_100
301: , a4 JTF_VARCHAR2_TABLE_100
302: , a5 JTF_NUMBER_TABLE

Line 299: , a2 JTF_VARCHAR2_TABLE_100

295: end rosetta_table_copy_out_p5;
296:
297: procedure rosetta_table_copy_in_p7(t out nocopy cn_get_comm_summ_data_pvt.salesrep_info_tbl_type, a0 JTF_VARCHAR2_TABLE_400
298: , a1 JTF_VARCHAR2_TABLE_100
299: , a2 JTF_VARCHAR2_TABLE_100
300: , a3 JTF_VARCHAR2_TABLE_100
301: , a4 JTF_VARCHAR2_TABLE_100
302: , a5 JTF_NUMBER_TABLE
303: ) as

Line 300: , a3 JTF_VARCHAR2_TABLE_100

296:
297: procedure rosetta_table_copy_in_p7(t out nocopy cn_get_comm_summ_data_pvt.salesrep_info_tbl_type, a0 JTF_VARCHAR2_TABLE_400
298: , a1 JTF_VARCHAR2_TABLE_100
299: , a2 JTF_VARCHAR2_TABLE_100
300: , a3 JTF_VARCHAR2_TABLE_100
301: , a4 JTF_VARCHAR2_TABLE_100
302: , a5 JTF_NUMBER_TABLE
303: ) as
304: ddindx binary_integer; indx binary_integer;

Line 301: , a4 JTF_VARCHAR2_TABLE_100

297: procedure rosetta_table_copy_in_p7(t out nocopy cn_get_comm_summ_data_pvt.salesrep_info_tbl_type, a0 JTF_VARCHAR2_TABLE_400
298: , a1 JTF_VARCHAR2_TABLE_100
299: , a2 JTF_VARCHAR2_TABLE_100
300: , a3 JTF_VARCHAR2_TABLE_100
301: , a4 JTF_VARCHAR2_TABLE_100
302: , a5 JTF_NUMBER_TABLE
303: ) as
304: ddindx binary_integer; indx binary_integer;
305: begin

Line 327: , a1 out nocopy JTF_VARCHAR2_TABLE_100

323: end if;
324: end if;
325: end rosetta_table_copy_in_p7;
326: procedure rosetta_table_copy_out_p7(t cn_get_comm_summ_data_pvt.salesrep_info_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_400
327: , a1 out nocopy JTF_VARCHAR2_TABLE_100
328: , a2 out nocopy JTF_VARCHAR2_TABLE_100
329: , a3 out nocopy JTF_VARCHAR2_TABLE_100
330: , a4 out nocopy JTF_VARCHAR2_TABLE_100
331: , a5 out nocopy JTF_NUMBER_TABLE

Line 328: , a2 out nocopy JTF_VARCHAR2_TABLE_100

324: end if;
325: end rosetta_table_copy_in_p7;
326: procedure rosetta_table_copy_out_p7(t cn_get_comm_summ_data_pvt.salesrep_info_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_400
327: , a1 out nocopy JTF_VARCHAR2_TABLE_100
328: , a2 out nocopy JTF_VARCHAR2_TABLE_100
329: , a3 out nocopy JTF_VARCHAR2_TABLE_100
330: , a4 out nocopy JTF_VARCHAR2_TABLE_100
331: , a5 out nocopy JTF_NUMBER_TABLE
332: ) as

Line 329: , a3 out nocopy JTF_VARCHAR2_TABLE_100

325: end rosetta_table_copy_in_p7;
326: procedure rosetta_table_copy_out_p7(t cn_get_comm_summ_data_pvt.salesrep_info_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_400
327: , a1 out nocopy JTF_VARCHAR2_TABLE_100
328: , a2 out nocopy JTF_VARCHAR2_TABLE_100
329: , a3 out nocopy JTF_VARCHAR2_TABLE_100
330: , a4 out nocopy JTF_VARCHAR2_TABLE_100
331: , a5 out nocopy JTF_NUMBER_TABLE
332: ) as
333: ddindx binary_integer; indx binary_integer;

Line 330: , a4 out nocopy JTF_VARCHAR2_TABLE_100

326: procedure rosetta_table_copy_out_p7(t cn_get_comm_summ_data_pvt.salesrep_info_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_400
327: , a1 out nocopy JTF_VARCHAR2_TABLE_100
328: , a2 out nocopy JTF_VARCHAR2_TABLE_100
329: , a3 out nocopy JTF_VARCHAR2_TABLE_100
330: , a4 out nocopy JTF_VARCHAR2_TABLE_100
331: , a5 out nocopy JTF_NUMBER_TABLE
332: ) as
333: ddindx binary_integer; indx binary_integer;
334: begin

Line 337: a1 := JTF_VARCHAR2_TABLE_100();

333: ddindx binary_integer; indx binary_integer;
334: begin
335: if t is null or t.count = 0 then
336: a0 := JTF_VARCHAR2_TABLE_400();
337: a1 := JTF_VARCHAR2_TABLE_100();
338: a2 := JTF_VARCHAR2_TABLE_100();
339: a3 := JTF_VARCHAR2_TABLE_100();
340: a4 := JTF_VARCHAR2_TABLE_100();
341: a5 := JTF_NUMBER_TABLE();

Line 338: a2 := JTF_VARCHAR2_TABLE_100();

334: begin
335: if t is null or t.count = 0 then
336: a0 := JTF_VARCHAR2_TABLE_400();
337: a1 := JTF_VARCHAR2_TABLE_100();
338: a2 := JTF_VARCHAR2_TABLE_100();
339: a3 := JTF_VARCHAR2_TABLE_100();
340: a4 := JTF_VARCHAR2_TABLE_100();
341: a5 := JTF_NUMBER_TABLE();
342: else

Line 339: a3 := JTF_VARCHAR2_TABLE_100();

335: if t is null or t.count = 0 then
336: a0 := JTF_VARCHAR2_TABLE_400();
337: a1 := JTF_VARCHAR2_TABLE_100();
338: a2 := JTF_VARCHAR2_TABLE_100();
339: a3 := JTF_VARCHAR2_TABLE_100();
340: a4 := JTF_VARCHAR2_TABLE_100();
341: a5 := JTF_NUMBER_TABLE();
342: else
343: a0 := JTF_VARCHAR2_TABLE_400();

Line 340: a4 := JTF_VARCHAR2_TABLE_100();

336: a0 := JTF_VARCHAR2_TABLE_400();
337: a1 := JTF_VARCHAR2_TABLE_100();
338: a2 := JTF_VARCHAR2_TABLE_100();
339: a3 := JTF_VARCHAR2_TABLE_100();
340: a4 := JTF_VARCHAR2_TABLE_100();
341: a5 := JTF_NUMBER_TABLE();
342: else
343: a0 := JTF_VARCHAR2_TABLE_400();
344: a1 := JTF_VARCHAR2_TABLE_100();

Line 344: a1 := JTF_VARCHAR2_TABLE_100();

340: a4 := JTF_VARCHAR2_TABLE_100();
341: a5 := JTF_NUMBER_TABLE();
342: else
343: a0 := JTF_VARCHAR2_TABLE_400();
344: a1 := JTF_VARCHAR2_TABLE_100();
345: a2 := JTF_VARCHAR2_TABLE_100();
346: a3 := JTF_VARCHAR2_TABLE_100();
347: a4 := JTF_VARCHAR2_TABLE_100();
348: a5 := JTF_NUMBER_TABLE();

Line 345: a2 := JTF_VARCHAR2_TABLE_100();

341: a5 := JTF_NUMBER_TABLE();
342: else
343: a0 := JTF_VARCHAR2_TABLE_400();
344: a1 := JTF_VARCHAR2_TABLE_100();
345: a2 := JTF_VARCHAR2_TABLE_100();
346: a3 := JTF_VARCHAR2_TABLE_100();
347: a4 := JTF_VARCHAR2_TABLE_100();
348: a5 := JTF_NUMBER_TABLE();
349: if t.count > 0 then

Line 346: a3 := JTF_VARCHAR2_TABLE_100();

342: else
343: a0 := JTF_VARCHAR2_TABLE_400();
344: a1 := JTF_VARCHAR2_TABLE_100();
345: a2 := JTF_VARCHAR2_TABLE_100();
346: a3 := JTF_VARCHAR2_TABLE_100();
347: a4 := JTF_VARCHAR2_TABLE_100();
348: a5 := JTF_NUMBER_TABLE();
349: if t.count > 0 then
350: a0.extend(t.count);

Line 347: a4 := JTF_VARCHAR2_TABLE_100();

343: a0 := JTF_VARCHAR2_TABLE_400();
344: a1 := JTF_VARCHAR2_TABLE_100();
345: a2 := JTF_VARCHAR2_TABLE_100();
346: a3 := JTF_VARCHAR2_TABLE_100();
347: a4 := JTF_VARCHAR2_TABLE_100();
348: a5 := JTF_NUMBER_TABLE();
349: if t.count > 0 then
350: a0.extend(t.count);
351: a1.extend(t.count);

Line 471: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

467: , p_period_id NUMBER
468: , p_credit_type_id NUMBER
469: , p_org_id NUMBER
470: , p4_a0 out nocopy JTF_NUMBER_TABLE
471: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
472: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
473: , p4_a3 out nocopy JTF_DATE_TABLE
474: , p4_a4 out nocopy JTF_DATE_TABLE
475: , p4_a5 out nocopy JTF_NUMBER_TABLE

Line 472: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100

468: , p_credit_type_id NUMBER
469: , p_org_id NUMBER
470: , p4_a0 out nocopy JTF_NUMBER_TABLE
471: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
472: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
473: , p4_a3 out nocopy JTF_DATE_TABLE
474: , p4_a4 out nocopy JTF_DATE_TABLE
475: , p4_a5 out nocopy JTF_NUMBER_TABLE
476: , p4_a6 out nocopy JTF_NUMBER_TABLE

Line 518: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100

514: procedure get_quota_manager_summary(p_period_id NUMBER
515: , p_credit_type_id NUMBER
516: , p_org_id NUMBER
517: , p3_a0 out nocopy JTF_NUMBER_TABLE
518: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
519: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
520: , p3_a3 out nocopy JTF_DATE_TABLE
521: , p3_a4 out nocopy JTF_DATE_TABLE
522: , p3_a5 out nocopy JTF_NUMBER_TABLE

Line 519: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100

515: , p_credit_type_id NUMBER
516: , p_org_id NUMBER
517: , p3_a0 out nocopy JTF_NUMBER_TABLE
518: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
519: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
520: , p3_a3 out nocopy JTF_DATE_TABLE
521: , p3_a4 out nocopy JTF_DATE_TABLE
522: , p3_a5 out nocopy JTF_NUMBER_TABLE
523: , p3_a6 out nocopy JTF_NUMBER_TABLE

Line 563: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

559: , p_credit_type_id NUMBER
560: , p_org_id NUMBER
561: , p_analyst_id NUMBER
562: , p4_a0 out nocopy JTF_NUMBER_TABLE
563: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
564: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
565: , p4_a3 out nocopy JTF_DATE_TABLE
566: , p4_a4 out nocopy JTF_DATE_TABLE
567: , p4_a5 out nocopy JTF_NUMBER_TABLE

Line 564: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100

560: , p_org_id NUMBER
561: , p_analyst_id NUMBER
562: , p4_a0 out nocopy JTF_NUMBER_TABLE
563: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
564: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
565: , p4_a3 out nocopy JTF_DATE_TABLE
566: , p4_a4 out nocopy JTF_DATE_TABLE
567: , p4_a5 out nocopy JTF_NUMBER_TABLE
568: , p4_a6 out nocopy JTF_NUMBER_TABLE

Line 611: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

607: , p_period_id NUMBER
608: , p_credit_type_id NUMBER
609: , p_org_id NUMBER
610: , p4_a0 out nocopy JTF_NUMBER_TABLE
611: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
612: , p4_a2 out nocopy JTF_NUMBER_TABLE
613: , p4_a3 out nocopy JTF_NUMBER_TABLE
614: , p4_a4 out nocopy JTF_NUMBER_TABLE
615: , p4_a5 out nocopy JTF_NUMBER_TABLE

Line 666: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100

662: procedure get_manager_pe_info(p_period_id NUMBER
663: , p_credit_type_id NUMBER
664: , p_org_id NUMBER
665: , p3_a0 out nocopy JTF_NUMBER_TABLE
666: , p3_a1 out nocopy JTF_VARCHAR2_TABLE_100
667: , p3_a2 out nocopy JTF_NUMBER_TABLE
668: , p3_a3 out nocopy JTF_NUMBER_TABLE
669: , p3_a4 out nocopy JTF_NUMBER_TABLE
670: , p3_a5 out nocopy JTF_NUMBER_TABLE

Line 719: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100

715: , p_credit_type_id NUMBER
716: , p_org_id NUMBER
717: , p_analyst_id NUMBER
718: , p4_a0 out nocopy JTF_NUMBER_TABLE
719: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
720: , p4_a2 out nocopy JTF_NUMBER_TABLE
721: , p4_a3 out nocopy JTF_NUMBER_TABLE
722: , p4_a4 out nocopy JTF_NUMBER_TABLE
723: , p4_a5 out nocopy JTF_NUMBER_TABLE

Line 773: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100

769:
770: procedure get_salesrep_details(p_salesrep_id NUMBER
771: , p_org_id NUMBER
772: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_400
773: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
774: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
775: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
776: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_100
777: , p2_a5 out nocopy JTF_NUMBER_TABLE

Line 774: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100

770: procedure get_salesrep_details(p_salesrep_id NUMBER
771: , p_org_id NUMBER
772: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_400
773: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
774: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
775: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
776: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_100
777: , p2_a5 out nocopy JTF_NUMBER_TABLE
778: )

Line 775: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100

771: , p_org_id NUMBER
772: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_400
773: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
774: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
775: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
776: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_100
777: , p2_a5 out nocopy JTF_NUMBER_TABLE
778: )
779:

Line 776: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_100

772: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_400
773: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
774: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
775: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
776: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_100
777: , p2_a5 out nocopy JTF_NUMBER_TABLE
778: )
779:
780: as

Line 808: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100

804: end;
805:
806: procedure get_manager_details(p_org_id NUMBER
807: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_400
808: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
809: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
810: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_100
811: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_100
812: , p1_a5 out nocopy JTF_NUMBER_TABLE

Line 809: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100

805:
806: procedure get_manager_details(p_org_id NUMBER
807: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_400
808: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
809: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
810: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_100
811: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_100
812: , p1_a5 out nocopy JTF_NUMBER_TABLE
813: )

Line 810: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_100

806: procedure get_manager_details(p_org_id NUMBER
807: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_400
808: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
809: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
810: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_100
811: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_100
812: , p1_a5 out nocopy JTF_NUMBER_TABLE
813: )
814:

Line 811: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_100

807: , p1_a0 out nocopy JTF_VARCHAR2_TABLE_400
808: , p1_a1 out nocopy JTF_VARCHAR2_TABLE_100
809: , p1_a2 out nocopy JTF_VARCHAR2_TABLE_100
810: , p1_a3 out nocopy JTF_VARCHAR2_TABLE_100
811: , p1_a4 out nocopy JTF_VARCHAR2_TABLE_100
812: , p1_a5 out nocopy JTF_NUMBER_TABLE
813: )
814:
815: as

Line 841: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100

837:
838: procedure get_analyst_details(p_org_id NUMBER
839: , p_analyst_id NUMBER
840: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_400
841: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
842: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
843: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
844: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_100
845: , p2_a5 out nocopy JTF_NUMBER_TABLE

Line 842: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100

838: procedure get_analyst_details(p_org_id NUMBER
839: , p_analyst_id NUMBER
840: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_400
841: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
842: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
843: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
844: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_100
845: , p2_a5 out nocopy JTF_NUMBER_TABLE
846: )

Line 843: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100

839: , p_analyst_id NUMBER
840: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_400
841: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
842: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
843: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
844: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_100
845: , p2_a5 out nocopy JTF_NUMBER_TABLE
846: )
847:

Line 844: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_100

840: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_400
841: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
842: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_100
843: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_100
844: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_100
845: , p2_a5 out nocopy JTF_NUMBER_TABLE
846: )
847:
848: as

Line 875: , x_result_tbl out nocopy JTF_VARCHAR2_TABLE_100

871: );
872: end;
873:
874: procedure get_group_codes(p_org_id NUMBER
875: , x_result_tbl out nocopy JTF_VARCHAR2_TABLE_100
876: )
877:
878: as
879: ddx_result_tbl cn_get_comm_summ_data_pvt.group_code_tbl_type;