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_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy cn_get_comm_summ_data_pvt.comm_summ_tbl_type, a0 JTF_NUMBER_TABLE

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

Line 8: , a5 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
10: , a7 JTF_NUMBER_TABLE
11: ) as
12: ddindx binary_integer; indx binary_integer;

Line 9: , a6 JTF_NUMBER_TABLE

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
10: , a7 JTF_NUMBER_TABLE
11: ) as
12: ddindx binary_integer; indx binary_integer;
13: begin

Line 10: , a7 JTF_NUMBER_TABLE

6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: ) as
12: ddindx binary_integer; indx binary_integer;
13: begin
14: if a0 is not null and a0.count > 0 then

Line 36: procedure rosetta_table_copy_out_p1(t cn_get_comm_summ_data_pvt.comm_summ_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

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

Line 41: , a5 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
43: , a7 out nocopy JTF_NUMBER_TABLE
44: ) as
45: ddindx binary_integer; indx binary_integer;

Line 42: , a6 out nocopy JTF_NUMBER_TABLE

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
43: , a7 out nocopy JTF_NUMBER_TABLE
44: ) as
45: ddindx binary_integer; indx binary_integer;
46: begin

Line 43: , a7 out nocopy JTF_NUMBER_TABLE

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
43: , a7 out nocopy JTF_NUMBER_TABLE
44: ) as
45: ddindx binary_integer; indx binary_integer;
46: begin
47: if t is null or t.count = 0 then

Line 48: a0 := JTF_NUMBER_TABLE();

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

Line 53: a5 := 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();
55: a7 := JTF_NUMBER_TABLE();
56: else
57: a0 := JTF_NUMBER_TABLE();

Line 54: a6 := JTF_NUMBER_TABLE();

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();
55: a7 := JTF_NUMBER_TABLE();
56: else
57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_VARCHAR2_TABLE_100();

Line 55: a7 := JTF_NUMBER_TABLE();

51: a3 := JTF_DATE_TABLE();
52: a4 := JTF_DATE_TABLE();
53: a5 := JTF_NUMBER_TABLE();
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();

Line 57: a0 := JTF_NUMBER_TABLE();

53: a5 := JTF_NUMBER_TABLE();
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();

Line 62: a5 := 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();
64: a7 := JTF_NUMBER_TABLE();
65: if t.count > 0 then
66: a0.extend(t.count);

Line 63: a6 := JTF_NUMBER_TABLE();

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();
64: a7 := JTF_NUMBER_TABLE();
65: if t.count > 0 then
66: a0.extend(t.count);
67: a1.extend(t.count);

Line 64: a7 := JTF_NUMBER_TABLE();

60: a3 := JTF_DATE_TABLE();
61: a4 := JTF_DATE_TABLE();
62: a5 := JTF_NUMBER_TABLE();
63: a6 := JTF_NUMBER_TABLE();
64: a7 := JTF_NUMBER_TABLE();
65: if t.count > 0 then
66: a0.extend(t.count);
67: a1.extend(t.count);
68: a2.extend(t.count);

Line 95: procedure rosetta_table_copy_in_p2(t out nocopy cn_get_comm_summ_data_pvt.salesrep_tbl_type, a0 JTF_NUMBER_TABLE) as

91: end if;
92: end if;
93: end rosetta_table_copy_out_p1;
94:
95: procedure rosetta_table_copy_in_p2(t out nocopy cn_get_comm_summ_data_pvt.salesrep_tbl_type, a0 JTF_NUMBER_TABLE) as
96: ddindx binary_integer; indx binary_integer;
97: begin
98: if a0 is not null and a0.count > 0 then
99: if a0.count > 0 then

Line 113: procedure rosetta_table_copy_out_p2(t cn_get_comm_summ_data_pvt.salesrep_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

109: end loop;
110: end if;
111: end if;
112: end rosetta_table_copy_in_p2;
113: procedure rosetta_table_copy_out_p2(t cn_get_comm_summ_data_pvt.salesrep_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
114: ddindx binary_integer; indx binary_integer;
115: begin
116: if t is null or t.count = 0 then
117: a0 := JTF_NUMBER_TABLE();

Line 117: a0 := JTF_NUMBER_TABLE();

113: procedure rosetta_table_copy_out_p2(t cn_get_comm_summ_data_pvt.salesrep_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
114: ddindx binary_integer; indx binary_integer;
115: begin
116: if t is null or t.count = 0 then
117: a0 := JTF_NUMBER_TABLE();
118: else
119: a0 := JTF_NUMBER_TABLE();
120: if t.count > 0 then
121: a0.extend(t.count);

Line 119: a0 := JTF_NUMBER_TABLE();

115: begin
116: if t is null or t.count = 0 then
117: a0 := JTF_NUMBER_TABLE();
118: else
119: a0 := JTF_NUMBER_TABLE();
120: if t.count > 0 then
121: a0.extend(t.count);
122: ddindx := t.first;
123: indx := 1;

Line 177: procedure rosetta_table_copy_in_p5(t out nocopy cn_get_comm_summ_data_pvt.pe_info_tbl_type, a0 JTF_NUMBER_TABLE

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

Line 179: , a2 JTF_NUMBER_TABLE

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
183: , a6 JTF_NUMBER_TABLE

Line 180: , a3 JTF_NUMBER_TABLE

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
183: , a6 JTF_NUMBER_TABLE
184: , a7 JTF_NUMBER_TABLE

Line 181: , a4 JTF_NUMBER_TABLE

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
183: , a6 JTF_NUMBER_TABLE
184: , a7 JTF_NUMBER_TABLE
185: , a8 JTF_NUMBER_TABLE

Line 182: , a5 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
183: , a6 JTF_NUMBER_TABLE
184: , a7 JTF_NUMBER_TABLE
185: , a8 JTF_NUMBER_TABLE
186: , a9 JTF_NUMBER_TABLE

Line 183: , a6 JTF_NUMBER_TABLE

179: , a2 JTF_NUMBER_TABLE
180: , a3 JTF_NUMBER_TABLE
181: , a4 JTF_NUMBER_TABLE
182: , a5 JTF_NUMBER_TABLE
183: , a6 JTF_NUMBER_TABLE
184: , a7 JTF_NUMBER_TABLE
185: , a8 JTF_NUMBER_TABLE
186: , a9 JTF_NUMBER_TABLE
187: , a10 JTF_NUMBER_TABLE

Line 184: , a7 JTF_NUMBER_TABLE

180: , a3 JTF_NUMBER_TABLE
181: , a4 JTF_NUMBER_TABLE
182: , a5 JTF_NUMBER_TABLE
183: , a6 JTF_NUMBER_TABLE
184: , a7 JTF_NUMBER_TABLE
185: , a8 JTF_NUMBER_TABLE
186: , a9 JTF_NUMBER_TABLE
187: , a10 JTF_NUMBER_TABLE
188: , a11 JTF_NUMBER_TABLE

Line 185: , a8 JTF_NUMBER_TABLE

181: , a4 JTF_NUMBER_TABLE
182: , a5 JTF_NUMBER_TABLE
183: , a6 JTF_NUMBER_TABLE
184: , a7 JTF_NUMBER_TABLE
185: , a8 JTF_NUMBER_TABLE
186: , a9 JTF_NUMBER_TABLE
187: , a10 JTF_NUMBER_TABLE
188: , a11 JTF_NUMBER_TABLE
189: ) as

Line 186: , a9 JTF_NUMBER_TABLE

182: , a5 JTF_NUMBER_TABLE
183: , a6 JTF_NUMBER_TABLE
184: , a7 JTF_NUMBER_TABLE
185: , a8 JTF_NUMBER_TABLE
186: , a9 JTF_NUMBER_TABLE
187: , a10 JTF_NUMBER_TABLE
188: , a11 JTF_NUMBER_TABLE
189: ) as
190: ddindx binary_integer; indx binary_integer;

Line 187: , a10 JTF_NUMBER_TABLE

183: , a6 JTF_NUMBER_TABLE
184: , a7 JTF_NUMBER_TABLE
185: , a8 JTF_NUMBER_TABLE
186: , a9 JTF_NUMBER_TABLE
187: , a10 JTF_NUMBER_TABLE
188: , a11 JTF_NUMBER_TABLE
189: ) as
190: ddindx binary_integer; indx binary_integer;
191: begin

Line 188: , a11 JTF_NUMBER_TABLE

184: , a7 JTF_NUMBER_TABLE
185: , a8 JTF_NUMBER_TABLE
186: , a9 JTF_NUMBER_TABLE
187: , a10 JTF_NUMBER_TABLE
188: , a11 JTF_NUMBER_TABLE
189: ) as
190: ddindx binary_integer; indx binary_integer;
191: begin
192: if a0 is not null and a0.count > 0 then

Line 218: procedure rosetta_table_copy_out_p5(t cn_get_comm_summ_data_pvt.pe_info_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

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

Line 220: , a2 out nocopy JTF_NUMBER_TABLE

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
224: , a6 out nocopy JTF_NUMBER_TABLE

Line 221: , a3 out nocopy JTF_NUMBER_TABLE

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
224: , a6 out nocopy JTF_NUMBER_TABLE
225: , a7 out nocopy JTF_NUMBER_TABLE

Line 222: , a4 out nocopy JTF_NUMBER_TABLE

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
224: , a6 out nocopy JTF_NUMBER_TABLE
225: , a7 out nocopy JTF_NUMBER_TABLE
226: , a8 out nocopy JTF_NUMBER_TABLE

Line 223: , a5 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
224: , a6 out nocopy JTF_NUMBER_TABLE
225: , a7 out nocopy JTF_NUMBER_TABLE
226: , a8 out nocopy JTF_NUMBER_TABLE
227: , a9 out nocopy JTF_NUMBER_TABLE

Line 224: , a6 out nocopy JTF_NUMBER_TABLE

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
224: , a6 out nocopy JTF_NUMBER_TABLE
225: , a7 out nocopy JTF_NUMBER_TABLE
226: , a8 out nocopy JTF_NUMBER_TABLE
227: , a9 out nocopy JTF_NUMBER_TABLE
228: , a10 out nocopy JTF_NUMBER_TABLE

Line 225: , a7 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
224: , a6 out nocopy JTF_NUMBER_TABLE
225: , a7 out nocopy JTF_NUMBER_TABLE
226: , a8 out nocopy JTF_NUMBER_TABLE
227: , a9 out nocopy JTF_NUMBER_TABLE
228: , a10 out nocopy JTF_NUMBER_TABLE
229: , a11 out nocopy JTF_NUMBER_TABLE

Line 226: , a8 out nocopy JTF_NUMBER_TABLE

222: , a4 out nocopy JTF_NUMBER_TABLE
223: , a5 out nocopy JTF_NUMBER_TABLE
224: , a6 out nocopy JTF_NUMBER_TABLE
225: , a7 out nocopy JTF_NUMBER_TABLE
226: , a8 out nocopy JTF_NUMBER_TABLE
227: , a9 out nocopy JTF_NUMBER_TABLE
228: , a10 out nocopy JTF_NUMBER_TABLE
229: , a11 out nocopy JTF_NUMBER_TABLE
230: ) as

Line 227: , a9 out nocopy JTF_NUMBER_TABLE

223: , a5 out nocopy JTF_NUMBER_TABLE
224: , a6 out nocopy JTF_NUMBER_TABLE
225: , a7 out nocopy JTF_NUMBER_TABLE
226: , a8 out nocopy JTF_NUMBER_TABLE
227: , a9 out nocopy JTF_NUMBER_TABLE
228: , a10 out nocopy JTF_NUMBER_TABLE
229: , a11 out nocopy JTF_NUMBER_TABLE
230: ) as
231: ddindx binary_integer; indx binary_integer;

Line 228: , a10 out nocopy JTF_NUMBER_TABLE

224: , a6 out nocopy JTF_NUMBER_TABLE
225: , a7 out nocopy JTF_NUMBER_TABLE
226: , a8 out nocopy JTF_NUMBER_TABLE
227: , a9 out nocopy JTF_NUMBER_TABLE
228: , a10 out nocopy JTF_NUMBER_TABLE
229: , a11 out nocopy JTF_NUMBER_TABLE
230: ) as
231: ddindx binary_integer; indx binary_integer;
232: begin

Line 229: , a11 out nocopy JTF_NUMBER_TABLE

225: , a7 out nocopy JTF_NUMBER_TABLE
226: , a8 out nocopy JTF_NUMBER_TABLE
227: , a9 out nocopy JTF_NUMBER_TABLE
228: , a10 out nocopy JTF_NUMBER_TABLE
229: , a11 out nocopy JTF_NUMBER_TABLE
230: ) as
231: ddindx binary_integer; indx binary_integer;
232: begin
233: if t is null or t.count = 0 then

Line 234: a0 := JTF_NUMBER_TABLE();

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

Line 236: a2 := JTF_NUMBER_TABLE();

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();
240: a6 := JTF_NUMBER_TABLE();

Line 237: a3 := JTF_NUMBER_TABLE();

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();
240: a6 := JTF_NUMBER_TABLE();
241: a7 := JTF_NUMBER_TABLE();

Line 238: a4 := JTF_NUMBER_TABLE();

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();
240: a6 := JTF_NUMBER_TABLE();
241: a7 := JTF_NUMBER_TABLE();
242: a8 := JTF_NUMBER_TABLE();

Line 239: a5 := 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();
240: a6 := JTF_NUMBER_TABLE();
241: a7 := JTF_NUMBER_TABLE();
242: a8 := JTF_NUMBER_TABLE();
243: a9 := JTF_NUMBER_TABLE();

Line 240: a6 := JTF_NUMBER_TABLE();

236: a2 := JTF_NUMBER_TABLE();
237: a3 := JTF_NUMBER_TABLE();
238: a4 := JTF_NUMBER_TABLE();
239: a5 := JTF_NUMBER_TABLE();
240: a6 := JTF_NUMBER_TABLE();
241: a7 := JTF_NUMBER_TABLE();
242: a8 := JTF_NUMBER_TABLE();
243: a9 := JTF_NUMBER_TABLE();
244: a10 := JTF_NUMBER_TABLE();

Line 241: a7 := JTF_NUMBER_TABLE();

237: a3 := JTF_NUMBER_TABLE();
238: a4 := JTF_NUMBER_TABLE();
239: a5 := JTF_NUMBER_TABLE();
240: a6 := JTF_NUMBER_TABLE();
241: a7 := JTF_NUMBER_TABLE();
242: a8 := JTF_NUMBER_TABLE();
243: a9 := JTF_NUMBER_TABLE();
244: a10 := JTF_NUMBER_TABLE();
245: a11 := JTF_NUMBER_TABLE();

Line 242: a8 := JTF_NUMBER_TABLE();

238: a4 := JTF_NUMBER_TABLE();
239: a5 := JTF_NUMBER_TABLE();
240: a6 := JTF_NUMBER_TABLE();
241: a7 := JTF_NUMBER_TABLE();
242: a8 := JTF_NUMBER_TABLE();
243: a9 := JTF_NUMBER_TABLE();
244: a10 := JTF_NUMBER_TABLE();
245: a11 := JTF_NUMBER_TABLE();
246: else

Line 243: a9 := JTF_NUMBER_TABLE();

239: a5 := JTF_NUMBER_TABLE();
240: a6 := JTF_NUMBER_TABLE();
241: a7 := JTF_NUMBER_TABLE();
242: a8 := JTF_NUMBER_TABLE();
243: a9 := JTF_NUMBER_TABLE();
244: a10 := JTF_NUMBER_TABLE();
245: a11 := JTF_NUMBER_TABLE();
246: else
247: a0 := JTF_NUMBER_TABLE();

Line 244: a10 := JTF_NUMBER_TABLE();

240: a6 := JTF_NUMBER_TABLE();
241: a7 := JTF_NUMBER_TABLE();
242: a8 := JTF_NUMBER_TABLE();
243: a9 := JTF_NUMBER_TABLE();
244: a10 := JTF_NUMBER_TABLE();
245: a11 := JTF_NUMBER_TABLE();
246: else
247: a0 := JTF_NUMBER_TABLE();
248: a1 := JTF_VARCHAR2_TABLE_100();

Line 245: a11 := JTF_NUMBER_TABLE();

241: a7 := JTF_NUMBER_TABLE();
242: a8 := JTF_NUMBER_TABLE();
243: a9 := JTF_NUMBER_TABLE();
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();

Line 247: a0 := JTF_NUMBER_TABLE();

243: a9 := JTF_NUMBER_TABLE();
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();

Line 249: a2 := 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();
253: a6 := JTF_NUMBER_TABLE();

Line 250: a3 := 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();
253: a6 := JTF_NUMBER_TABLE();
254: a7 := JTF_NUMBER_TABLE();

Line 251: a4 := JTF_NUMBER_TABLE();

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();
253: a6 := JTF_NUMBER_TABLE();
254: a7 := JTF_NUMBER_TABLE();
255: a8 := JTF_NUMBER_TABLE();

Line 252: a5 := 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();
253: a6 := JTF_NUMBER_TABLE();
254: a7 := JTF_NUMBER_TABLE();
255: a8 := JTF_NUMBER_TABLE();
256: a9 := JTF_NUMBER_TABLE();

Line 253: a6 := JTF_NUMBER_TABLE();

249: a2 := JTF_NUMBER_TABLE();
250: a3 := JTF_NUMBER_TABLE();
251: a4 := JTF_NUMBER_TABLE();
252: a5 := JTF_NUMBER_TABLE();
253: a6 := JTF_NUMBER_TABLE();
254: a7 := JTF_NUMBER_TABLE();
255: a8 := JTF_NUMBER_TABLE();
256: a9 := JTF_NUMBER_TABLE();
257: a10 := JTF_NUMBER_TABLE();

Line 254: a7 := JTF_NUMBER_TABLE();

250: a3 := JTF_NUMBER_TABLE();
251: a4 := JTF_NUMBER_TABLE();
252: a5 := JTF_NUMBER_TABLE();
253: a6 := JTF_NUMBER_TABLE();
254: a7 := JTF_NUMBER_TABLE();
255: a8 := JTF_NUMBER_TABLE();
256: a9 := JTF_NUMBER_TABLE();
257: a10 := JTF_NUMBER_TABLE();
258: a11 := JTF_NUMBER_TABLE();

Line 255: a8 := JTF_NUMBER_TABLE();

251: a4 := JTF_NUMBER_TABLE();
252: a5 := JTF_NUMBER_TABLE();
253: a6 := JTF_NUMBER_TABLE();
254: a7 := JTF_NUMBER_TABLE();
255: a8 := JTF_NUMBER_TABLE();
256: a9 := JTF_NUMBER_TABLE();
257: a10 := JTF_NUMBER_TABLE();
258: a11 := JTF_NUMBER_TABLE();
259: if t.count > 0 then

Line 256: a9 := JTF_NUMBER_TABLE();

252: a5 := JTF_NUMBER_TABLE();
253: a6 := JTF_NUMBER_TABLE();
254: a7 := JTF_NUMBER_TABLE();
255: a8 := JTF_NUMBER_TABLE();
256: a9 := JTF_NUMBER_TABLE();
257: a10 := JTF_NUMBER_TABLE();
258: a11 := JTF_NUMBER_TABLE();
259: if t.count > 0 then
260: a0.extend(t.count);

Line 257: a10 := JTF_NUMBER_TABLE();

253: a6 := JTF_NUMBER_TABLE();
254: a7 := JTF_NUMBER_TABLE();
255: a8 := JTF_NUMBER_TABLE();
256: a9 := JTF_NUMBER_TABLE();
257: a10 := JTF_NUMBER_TABLE();
258: a11 := JTF_NUMBER_TABLE();
259: if t.count > 0 then
260: a0.extend(t.count);
261: a1.extend(t.count);

Line 258: a11 := JTF_NUMBER_TABLE();

254: a7 := JTF_NUMBER_TABLE();
255: a8 := JTF_NUMBER_TABLE();
256: a9 := JTF_NUMBER_TABLE();
257: a10 := JTF_NUMBER_TABLE();
258: a11 := JTF_NUMBER_TABLE();
259: if t.count > 0 then
260: a0.extend(t.count);
261: a1.extend(t.count);
262: a2.extend(t.count);

Line 302: , a5 JTF_NUMBER_TABLE

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
306: if a0 is not null and a0.count > 0 then

Line 331: , a5 out nocopy JTF_NUMBER_TABLE

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
335: if t is null or t.count = 0 then

Line 341: a5 := JTF_NUMBER_TABLE();

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();
345: a2 := JTF_VARCHAR2_TABLE_100();

Line 348: a5 := JTF_NUMBER_TABLE();

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);
352: a2.extend(t.count);

Line 375: procedure rosetta_table_copy_in_p9(t out nocopy cn_get_comm_summ_data_pvt.pe_ptd_credit_tbl_type, a0 JTF_NUMBER_TABLE

371: end if;
372: end if;
373: end rosetta_table_copy_out_p7;
374:
375: procedure rosetta_table_copy_in_p9(t out nocopy cn_get_comm_summ_data_pvt.pe_ptd_credit_tbl_type, a0 JTF_NUMBER_TABLE
376: , a1 JTF_NUMBER_TABLE
377: ) as
378: ddindx binary_integer; indx binary_integer;
379: begin

Line 376: , a1 JTF_NUMBER_TABLE

372: end if;
373: end rosetta_table_copy_out_p7;
374:
375: procedure rosetta_table_copy_in_p9(t out nocopy cn_get_comm_summ_data_pvt.pe_ptd_credit_tbl_type, a0 JTF_NUMBER_TABLE
376: , a1 JTF_NUMBER_TABLE
377: ) as
378: ddindx binary_integer; indx binary_integer;
379: begin
380: if a0 is not null and a0.count > 0 then

Line 396: procedure rosetta_table_copy_out_p9(t cn_get_comm_summ_data_pvt.pe_ptd_credit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

392: end loop;
393: end if;
394: end if;
395: end rosetta_table_copy_in_p9;
396: procedure rosetta_table_copy_out_p9(t cn_get_comm_summ_data_pvt.pe_ptd_credit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
397: , a1 out nocopy JTF_NUMBER_TABLE
398: ) as
399: ddindx binary_integer; indx binary_integer;
400: begin

Line 397: , a1 out nocopy JTF_NUMBER_TABLE

393: end if;
394: end if;
395: end rosetta_table_copy_in_p9;
396: procedure rosetta_table_copy_out_p9(t cn_get_comm_summ_data_pvt.pe_ptd_credit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
397: , a1 out nocopy JTF_NUMBER_TABLE
398: ) as
399: ddindx binary_integer; indx binary_integer;
400: begin
401: if t is null or t.count = 0 then

Line 402: a0 := JTF_NUMBER_TABLE();

398: ) as
399: ddindx binary_integer; indx binary_integer;
400: begin
401: if t is null or t.count = 0 then
402: a0 := JTF_NUMBER_TABLE();
403: a1 := JTF_NUMBER_TABLE();
404: else
405: a0 := JTF_NUMBER_TABLE();
406: a1 := JTF_NUMBER_TABLE();

Line 403: a1 := JTF_NUMBER_TABLE();

399: ddindx binary_integer; indx binary_integer;
400: begin
401: if t is null or t.count = 0 then
402: a0 := JTF_NUMBER_TABLE();
403: a1 := JTF_NUMBER_TABLE();
404: else
405: a0 := JTF_NUMBER_TABLE();
406: a1 := JTF_NUMBER_TABLE();
407: if t.count > 0 then

Line 405: a0 := JTF_NUMBER_TABLE();

401: if t is null or t.count = 0 then
402: a0 := JTF_NUMBER_TABLE();
403: a1 := JTF_NUMBER_TABLE();
404: else
405: a0 := JTF_NUMBER_TABLE();
406: a1 := JTF_NUMBER_TABLE();
407: if t.count > 0 then
408: a0.extend(t.count);
409: a1.extend(t.count);

Line 406: a1 := JTF_NUMBER_TABLE();

402: a0 := JTF_NUMBER_TABLE();
403: a1 := JTF_NUMBER_TABLE();
404: else
405: a0 := JTF_NUMBER_TABLE();
406: a1 := JTF_NUMBER_TABLE();
407: if t.count > 0 then
408: a0.extend(t.count);
409: a1.extend(t.count);
410: ddindx := t.first;

Line 431: , x_salesrep_tbl out nocopy JTF_NUMBER_TABLE

427: , p_period_id NUMBER
428: , p_analyst_id NUMBER
429: , p_org_id NUMBER
430: , x_total_rows out nocopy NUMBER
431: , x_salesrep_tbl out nocopy JTF_NUMBER_TABLE
432: )
433:
434: as
435: ddx_salesrep_tbl cn_get_comm_summ_data_pvt.salesrep_tbl_type;

Line 470: , p4_a0 out nocopy JTF_NUMBER_TABLE

466: procedure get_quota_summary(p_salesrep_id NUMBER
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

Line 475: , p4_a5 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
477: , p4_a7 out nocopy JTF_NUMBER_TABLE
478: )
479:

Line 476: , p4_a6 out nocopy JTF_NUMBER_TABLE

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
477: , p4_a7 out nocopy JTF_NUMBER_TABLE
478: )
479:
480: as

Line 477: , p4_a7 out nocopy JTF_NUMBER_TABLE

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
477: , p4_a7 out nocopy JTF_NUMBER_TABLE
478: )
479:
480: as
481: ddx_result_tbl cn_get_comm_summ_data_pvt.comm_summ_tbl_type;

Line 517: , p3_a0 out nocopy JTF_NUMBER_TABLE

513:
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

Line 522: , p3_a5 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
524: , p3_a7 out nocopy JTF_NUMBER_TABLE
525: )
526:

Line 523: , p3_a6 out nocopy JTF_NUMBER_TABLE

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
524: , p3_a7 out nocopy JTF_NUMBER_TABLE
525: )
526:
527: as

Line 524: , p3_a7 out nocopy JTF_NUMBER_TABLE

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
524: , p3_a7 out nocopy JTF_NUMBER_TABLE
525: )
526:
527: as
528: ddx_result_tbl cn_get_comm_summ_data_pvt.comm_summ_tbl_type;

Line 562: , p4_a0 out nocopy JTF_NUMBER_TABLE

558: procedure get_quota_analyst_summary(p_period_id NUMBER
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

Line 567: , p4_a5 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
569: , p4_a7 out nocopy JTF_NUMBER_TABLE
570: )
571:

Line 568: , p4_a6 out nocopy JTF_NUMBER_TABLE

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
569: , p4_a7 out nocopy JTF_NUMBER_TABLE
570: )
571:
572: as

Line 569: , p4_a7 out nocopy JTF_NUMBER_TABLE

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
569: , p4_a7 out nocopy JTF_NUMBER_TABLE
570: )
571:
572: as
573: ddx_result_tbl cn_get_comm_summ_data_pvt.comm_summ_tbl_type;

Line 610: , p4_a0 out nocopy JTF_NUMBER_TABLE

606: procedure get_salesrep_pe_info(p_salesrep_id NUMBER
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

Line 612: , p4_a2 out nocopy JTF_NUMBER_TABLE

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
616: , p4_a6 out nocopy JTF_NUMBER_TABLE

Line 613: , p4_a3 out nocopy JTF_NUMBER_TABLE

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
616: , p4_a6 out nocopy JTF_NUMBER_TABLE
617: , p4_a7 out nocopy JTF_NUMBER_TABLE

Line 614: , p4_a4 out nocopy JTF_NUMBER_TABLE

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
616: , p4_a6 out nocopy JTF_NUMBER_TABLE
617: , p4_a7 out nocopy JTF_NUMBER_TABLE
618: , p4_a8 out nocopy JTF_NUMBER_TABLE

Line 615: , p4_a5 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
616: , p4_a6 out nocopy JTF_NUMBER_TABLE
617: , p4_a7 out nocopy JTF_NUMBER_TABLE
618: , p4_a8 out nocopy JTF_NUMBER_TABLE
619: , p4_a9 out nocopy JTF_NUMBER_TABLE

Line 616: , p4_a6 out nocopy JTF_NUMBER_TABLE

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
616: , p4_a6 out nocopy JTF_NUMBER_TABLE
617: , p4_a7 out nocopy JTF_NUMBER_TABLE
618: , p4_a8 out nocopy JTF_NUMBER_TABLE
619: , p4_a9 out nocopy JTF_NUMBER_TABLE
620: , p4_a10 out nocopy JTF_NUMBER_TABLE

Line 617: , p4_a7 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
616: , p4_a6 out nocopy JTF_NUMBER_TABLE
617: , p4_a7 out nocopy JTF_NUMBER_TABLE
618: , p4_a8 out nocopy JTF_NUMBER_TABLE
619: , p4_a9 out nocopy JTF_NUMBER_TABLE
620: , p4_a10 out nocopy JTF_NUMBER_TABLE
621: , p4_a11 out nocopy JTF_NUMBER_TABLE

Line 618: , p4_a8 out nocopy JTF_NUMBER_TABLE

614: , p4_a4 out nocopy JTF_NUMBER_TABLE
615: , p4_a5 out nocopy JTF_NUMBER_TABLE
616: , p4_a6 out nocopy JTF_NUMBER_TABLE
617: , p4_a7 out nocopy JTF_NUMBER_TABLE
618: , p4_a8 out nocopy JTF_NUMBER_TABLE
619: , p4_a9 out nocopy JTF_NUMBER_TABLE
620: , p4_a10 out nocopy JTF_NUMBER_TABLE
621: , p4_a11 out nocopy JTF_NUMBER_TABLE
622: )

Line 619: , p4_a9 out nocopy JTF_NUMBER_TABLE

615: , p4_a5 out nocopy JTF_NUMBER_TABLE
616: , p4_a6 out nocopy JTF_NUMBER_TABLE
617: , p4_a7 out nocopy JTF_NUMBER_TABLE
618: , p4_a8 out nocopy JTF_NUMBER_TABLE
619: , p4_a9 out nocopy JTF_NUMBER_TABLE
620: , p4_a10 out nocopy JTF_NUMBER_TABLE
621: , p4_a11 out nocopy JTF_NUMBER_TABLE
622: )
623:

Line 620: , p4_a10 out nocopy JTF_NUMBER_TABLE

616: , p4_a6 out nocopy JTF_NUMBER_TABLE
617: , p4_a7 out nocopy JTF_NUMBER_TABLE
618: , p4_a8 out nocopy JTF_NUMBER_TABLE
619: , p4_a9 out nocopy JTF_NUMBER_TABLE
620: , p4_a10 out nocopy JTF_NUMBER_TABLE
621: , p4_a11 out nocopy JTF_NUMBER_TABLE
622: )
623:
624: as

Line 621: , p4_a11 out nocopy JTF_NUMBER_TABLE

617: , p4_a7 out nocopy JTF_NUMBER_TABLE
618: , p4_a8 out nocopy JTF_NUMBER_TABLE
619: , p4_a9 out nocopy JTF_NUMBER_TABLE
620: , p4_a10 out nocopy JTF_NUMBER_TABLE
621: , p4_a11 out nocopy JTF_NUMBER_TABLE
622: )
623:
624: as
625: ddx_result_tbl cn_get_comm_summ_data_pvt.pe_info_tbl_type;

Line 665: , p3_a0 out nocopy JTF_NUMBER_TABLE

661:
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

Line 667: , p3_a2 out nocopy JTF_NUMBER_TABLE

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
671: , p3_a6 out nocopy JTF_NUMBER_TABLE

Line 668: , p3_a3 out nocopy JTF_NUMBER_TABLE

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
671: , p3_a6 out nocopy JTF_NUMBER_TABLE
672: , p3_a7 out nocopy JTF_NUMBER_TABLE

Line 669: , p3_a4 out nocopy JTF_NUMBER_TABLE

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
671: , p3_a6 out nocopy JTF_NUMBER_TABLE
672: , p3_a7 out nocopy JTF_NUMBER_TABLE
673: , p3_a8 out nocopy JTF_NUMBER_TABLE

Line 670: , p3_a5 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
671: , p3_a6 out nocopy JTF_NUMBER_TABLE
672: , p3_a7 out nocopy JTF_NUMBER_TABLE
673: , p3_a8 out nocopy JTF_NUMBER_TABLE
674: , p3_a9 out nocopy JTF_NUMBER_TABLE

Line 671: , p3_a6 out nocopy JTF_NUMBER_TABLE

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
671: , p3_a6 out nocopy JTF_NUMBER_TABLE
672: , p3_a7 out nocopy JTF_NUMBER_TABLE
673: , p3_a8 out nocopy JTF_NUMBER_TABLE
674: , p3_a9 out nocopy JTF_NUMBER_TABLE
675: , p3_a10 out nocopy JTF_NUMBER_TABLE

Line 672: , p3_a7 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
671: , p3_a6 out nocopy JTF_NUMBER_TABLE
672: , p3_a7 out nocopy JTF_NUMBER_TABLE
673: , p3_a8 out nocopy JTF_NUMBER_TABLE
674: , p3_a9 out nocopy JTF_NUMBER_TABLE
675: , p3_a10 out nocopy JTF_NUMBER_TABLE
676: , p3_a11 out nocopy JTF_NUMBER_TABLE

Line 673: , p3_a8 out nocopy JTF_NUMBER_TABLE

669: , p3_a4 out nocopy JTF_NUMBER_TABLE
670: , p3_a5 out nocopy JTF_NUMBER_TABLE
671: , p3_a6 out nocopy JTF_NUMBER_TABLE
672: , p3_a7 out nocopy JTF_NUMBER_TABLE
673: , p3_a8 out nocopy JTF_NUMBER_TABLE
674: , p3_a9 out nocopy JTF_NUMBER_TABLE
675: , p3_a10 out nocopy JTF_NUMBER_TABLE
676: , p3_a11 out nocopy JTF_NUMBER_TABLE
677: )

Line 674: , p3_a9 out nocopy JTF_NUMBER_TABLE

670: , p3_a5 out nocopy JTF_NUMBER_TABLE
671: , p3_a6 out nocopy JTF_NUMBER_TABLE
672: , p3_a7 out nocopy JTF_NUMBER_TABLE
673: , p3_a8 out nocopy JTF_NUMBER_TABLE
674: , p3_a9 out nocopy JTF_NUMBER_TABLE
675: , p3_a10 out nocopy JTF_NUMBER_TABLE
676: , p3_a11 out nocopy JTF_NUMBER_TABLE
677: )
678:

Line 675: , p3_a10 out nocopy JTF_NUMBER_TABLE

671: , p3_a6 out nocopy JTF_NUMBER_TABLE
672: , p3_a7 out nocopy JTF_NUMBER_TABLE
673: , p3_a8 out nocopy JTF_NUMBER_TABLE
674: , p3_a9 out nocopy JTF_NUMBER_TABLE
675: , p3_a10 out nocopy JTF_NUMBER_TABLE
676: , p3_a11 out nocopy JTF_NUMBER_TABLE
677: )
678:
679: as

Line 676: , p3_a11 out nocopy JTF_NUMBER_TABLE

672: , p3_a7 out nocopy JTF_NUMBER_TABLE
673: , p3_a8 out nocopy JTF_NUMBER_TABLE
674: , p3_a9 out nocopy JTF_NUMBER_TABLE
675: , p3_a10 out nocopy JTF_NUMBER_TABLE
676: , p3_a11 out nocopy JTF_NUMBER_TABLE
677: )
678:
679: as
680: ddx_result_tbl cn_get_comm_summ_data_pvt.pe_info_tbl_type;

Line 718: , p4_a0 out nocopy JTF_NUMBER_TABLE

714: procedure get_analyst_pe_info(p_period_id NUMBER
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

Line 720: , p4_a2 out nocopy JTF_NUMBER_TABLE

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
724: , p4_a6 out nocopy JTF_NUMBER_TABLE

Line 721: , p4_a3 out nocopy JTF_NUMBER_TABLE

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
724: , p4_a6 out nocopy JTF_NUMBER_TABLE
725: , p4_a7 out nocopy JTF_NUMBER_TABLE

Line 722: , p4_a4 out nocopy JTF_NUMBER_TABLE

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
724: , p4_a6 out nocopy JTF_NUMBER_TABLE
725: , p4_a7 out nocopy JTF_NUMBER_TABLE
726: , p4_a8 out nocopy JTF_NUMBER_TABLE

Line 723: , p4_a5 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
724: , p4_a6 out nocopy JTF_NUMBER_TABLE
725: , p4_a7 out nocopy JTF_NUMBER_TABLE
726: , p4_a8 out nocopy JTF_NUMBER_TABLE
727: , p4_a9 out nocopy JTF_NUMBER_TABLE

Line 724: , p4_a6 out nocopy JTF_NUMBER_TABLE

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
724: , p4_a6 out nocopy JTF_NUMBER_TABLE
725: , p4_a7 out nocopy JTF_NUMBER_TABLE
726: , p4_a8 out nocopy JTF_NUMBER_TABLE
727: , p4_a9 out nocopy JTF_NUMBER_TABLE
728: , p4_a10 out nocopy JTF_NUMBER_TABLE

Line 725: , p4_a7 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
724: , p4_a6 out nocopy JTF_NUMBER_TABLE
725: , p4_a7 out nocopy JTF_NUMBER_TABLE
726: , p4_a8 out nocopy JTF_NUMBER_TABLE
727: , p4_a9 out nocopy JTF_NUMBER_TABLE
728: , p4_a10 out nocopy JTF_NUMBER_TABLE
729: , p4_a11 out nocopy JTF_NUMBER_TABLE

Line 726: , p4_a8 out nocopy JTF_NUMBER_TABLE

722: , p4_a4 out nocopy JTF_NUMBER_TABLE
723: , p4_a5 out nocopy JTF_NUMBER_TABLE
724: , p4_a6 out nocopy JTF_NUMBER_TABLE
725: , p4_a7 out nocopy JTF_NUMBER_TABLE
726: , p4_a8 out nocopy JTF_NUMBER_TABLE
727: , p4_a9 out nocopy JTF_NUMBER_TABLE
728: , p4_a10 out nocopy JTF_NUMBER_TABLE
729: , p4_a11 out nocopy JTF_NUMBER_TABLE
730: )

Line 727: , p4_a9 out nocopy JTF_NUMBER_TABLE

723: , p4_a5 out nocopy JTF_NUMBER_TABLE
724: , p4_a6 out nocopy JTF_NUMBER_TABLE
725: , p4_a7 out nocopy JTF_NUMBER_TABLE
726: , p4_a8 out nocopy JTF_NUMBER_TABLE
727: , p4_a9 out nocopy JTF_NUMBER_TABLE
728: , p4_a10 out nocopy JTF_NUMBER_TABLE
729: , p4_a11 out nocopy JTF_NUMBER_TABLE
730: )
731:

Line 728: , p4_a10 out nocopy JTF_NUMBER_TABLE

724: , p4_a6 out nocopy JTF_NUMBER_TABLE
725: , p4_a7 out nocopy JTF_NUMBER_TABLE
726: , p4_a8 out nocopy JTF_NUMBER_TABLE
727: , p4_a9 out nocopy JTF_NUMBER_TABLE
728: , p4_a10 out nocopy JTF_NUMBER_TABLE
729: , p4_a11 out nocopy JTF_NUMBER_TABLE
730: )
731:
732: as

Line 729: , p4_a11 out nocopy JTF_NUMBER_TABLE

725: , p4_a7 out nocopy JTF_NUMBER_TABLE
726: , p4_a8 out nocopy JTF_NUMBER_TABLE
727: , p4_a9 out nocopy JTF_NUMBER_TABLE
728: , p4_a10 out nocopy JTF_NUMBER_TABLE
729: , p4_a11 out nocopy JTF_NUMBER_TABLE
730: )
731:
732: as
733: ddx_result_tbl cn_get_comm_summ_data_pvt.pe_info_tbl_type;

Line 777: , p2_a5 out nocopy JTF_NUMBER_TABLE

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
781: ddx_result_tbl cn_get_comm_summ_data_pvt.salesrep_info_tbl_type;

Line 812: , p1_a5 out nocopy JTF_NUMBER_TABLE

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
816: ddx_result_tbl cn_get_comm_summ_data_pvt.salesrep_info_tbl_type;

Line 845: , p2_a5 out nocopy JTF_NUMBER_TABLE

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
849: ddx_result_tbl cn_get_comm_summ_data_pvt.salesrep_info_tbl_type;

Line 898: , p3_a0 in out nocopy JTF_NUMBER_TABLE

894:
895: procedure get_ptd_credit(p_salesrep_id NUMBER
896: , p_payrun_id NUMBER
897: , p_org_id NUMBER
898: , p3_a0 in out nocopy JTF_NUMBER_TABLE
899: , p3_a1 in out nocopy JTF_NUMBER_TABLE
900: )
901:
902: as

Line 899: , p3_a1 in out nocopy JTF_NUMBER_TABLE

895: procedure get_ptd_credit(p_salesrep_id NUMBER
896: , p_payrun_id NUMBER
897: , p_org_id NUMBER
898: , p3_a0 in out nocopy JTF_NUMBER_TABLE
899: , p3_a1 in out nocopy JTF_NUMBER_TABLE
900: )
901:
902: as
903: ddx_result_tbl cn_get_comm_summ_data_pvt.pe_ptd_credit_tbl_type;