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_W dependencies on CN_GET_COMM_SUMM_DATA

Line 1: package body cn_get_comm_summ_data_w as

1: package body cn_get_comm_summ_data_w as
2: /* $Header: cnwcommb.pls 115.3 2001/01/15 18:45:57 pkm ship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:

Line 22: procedure rosetta_table_copy_in_p1(t out cn_get_comm_summ_data.comm_summ_tbl_type, a0 JTF_NUMBER_TABLE

18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out cn_get_comm_summ_data.comm_summ_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_300
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100

Line 61: procedure rosetta_table_copy_out_p1(t cn_get_comm_summ_data.comm_summ_tbl_type, a0 out JTF_NUMBER_TABLE

57: end loop;
58: end if;
59: end if;
60: end rosetta_table_copy_in_p1;
61: procedure rosetta_table_copy_out_p1(t cn_get_comm_summ_data.comm_summ_tbl_type, a0 out JTF_NUMBER_TABLE
62: , a1 out JTF_VARCHAR2_TABLE_300
63: , a2 out JTF_VARCHAR2_TABLE_100
64: , a3 out JTF_VARCHAR2_TABLE_100
65: , a4 out JTF_VARCHAR2_TABLE_100

Line 135: procedure rosetta_table_copy_in_p3(t out cn_get_comm_summ_data.pe_info_tbl_type, a0 JTF_VARCHAR2_TABLE_100

131: end if;
132: end if;
133: end rosetta_table_copy_out_p1;
134:
135: procedure rosetta_table_copy_in_p3(t out cn_get_comm_summ_data.pe_info_tbl_type, a0 JTF_VARCHAR2_TABLE_100
136: , a1 JTF_NUMBER_TABLE
137: , a2 JTF_NUMBER_TABLE
138: , a3 JTF_NUMBER_TABLE
139: , a4 JTF_NUMBER_TABLE

Line 164: procedure rosetta_table_copy_out_p3(t cn_get_comm_summ_data.pe_info_tbl_type, a0 out JTF_VARCHAR2_TABLE_100

160: end loop;
161: end if;
162: end if;
163: end rosetta_table_copy_in_p3;
164: procedure rosetta_table_copy_out_p3(t cn_get_comm_summ_data.pe_info_tbl_type, a0 out JTF_VARCHAR2_TABLE_100
165: , a1 out JTF_NUMBER_TABLE
166: , a2 out JTF_NUMBER_TABLE
167: , a3 out JTF_NUMBER_TABLE
168: , a4 out JTF_NUMBER_TABLE

Line 232: ddx_result_tbl cn_get_comm_summ_data.comm_summ_tbl_type;

228: , p6_a9 out JTF_NUMBER_TABLE
229: , p6_a10 out JTF_NUMBER_TABLE
230: )
231: as
232: ddx_result_tbl cn_get_comm_summ_data.comm_summ_tbl_type;
233: ddindx binary_integer; indx binary_integer;
234: begin
235:
236: -- copy data to the local IN or IN-OUT args, if any

Line 245: cn_get_comm_summ_data.get_quota_summary(p_first,

241:
242:
243:
244: -- here's the delegated call to the old PL/SQL routine
245: cn_get_comm_summ_data.get_quota_summary(p_first,
246: p_last,
247: p_period_id,
248: p_user_id,
249: p_credit_type_id,

Line 260: cn_get_comm_summ_data_w.rosetta_table_copy_out_p1(ddx_result_tbl, p6_a0

256:
257:
258:
259:
260: cn_get_comm_summ_data_w.rosetta_table_copy_out_p1(ddx_result_tbl, p6_a0
261: , p6_a1
262: , p6_a2
263: , p6_a3
264: , p6_a4

Line 293: ddx_ytd_pe_info cn_get_comm_summ_data.pe_info_tbl_type;

289: , x_ytd_total_earnings out NUMBER
290: , x_ptd_total_earnings out NUMBER
291: )
292: as
293: ddx_ytd_pe_info cn_get_comm_summ_data.pe_info_tbl_type;
294: ddx_ptd_pe_info cn_get_comm_summ_data.pe_info_tbl_type;
295: ddindx binary_integer; indx binary_integer;
296: begin
297:

Line 294: ddx_ptd_pe_info cn_get_comm_summ_data.pe_info_tbl_type;

290: , x_ptd_total_earnings out NUMBER
291: )
292: as
293: ddx_ytd_pe_info cn_get_comm_summ_data.pe_info_tbl_type;
294: ddx_ptd_pe_info cn_get_comm_summ_data.pe_info_tbl_type;
295: ddindx binary_integer; indx binary_integer;
296: begin
297:
298: -- copy data to the local IN or IN-OUT args, if any

Line 307: cn_get_comm_summ_data.get_pe_info(p_srp_plan_assign_id,

303:
304:
305:
306: -- here's the delegated call to the old PL/SQL routine
307: cn_get_comm_summ_data.get_pe_info(p_srp_plan_assign_id,
308: p_period_id,
309: p_credit_type_id,
310: ddx_ytd_pe_info,
311: ddx_ptd_pe_info,

Line 319: cn_get_comm_summ_data_w.rosetta_table_copy_out_p3(ddx_ytd_pe_info, p3_a0

315: -- copy data back from the local OUT or IN-OUT args, if any
316:
317:
318:
319: cn_get_comm_summ_data_w.rosetta_table_copy_out_p3(ddx_ytd_pe_info, p3_a0
320: , p3_a1
321: , p3_a2
322: , p3_a3
323: , p3_a4

Line 327: cn_get_comm_summ_data_w.rosetta_table_copy_out_p3(ddx_ptd_pe_info, p4_a0

323: , p3_a4
324: , p3_a5
325: );
326:
327: cn_get_comm_summ_data_w.rosetta_table_copy_out_p3(ddx_ptd_pe_info, p4_a0
328: , p4_a1
329: , p4_a2
330: , p4_a3
331: , p4_a4

Line 346: ddx_result_tbl cn_get_comm_summ_data.pe_info_tbl_type;

342: , p0_a4 out JTF_NUMBER_TABLE
343: , p0_a5 out JTF_NUMBER_TABLE
344: )
345: as
346: ddx_result_tbl cn_get_comm_summ_data.pe_info_tbl_type;
347: ddindx binary_integer; indx binary_integer;
348: begin
349:
350: -- copy data to the local IN or IN-OUT args, if any

Line 353: cn_get_comm_summ_data.get_group_codes(ddx_result_tbl);

349:
350: -- copy data to the local IN or IN-OUT args, if any
351:
352: -- here's the delegated call to the old PL/SQL routine
353: cn_get_comm_summ_data.get_group_codes(ddx_result_tbl);
354:
355: -- copy data back from the local OUT or IN-OUT args, if any
356: cn_get_comm_summ_data_w.rosetta_table_copy_out_p3(ddx_result_tbl, p0_a0
357: , p0_a1

Line 356: cn_get_comm_summ_data_w.rosetta_table_copy_out_p3(ddx_result_tbl, p0_a0

352: -- here's the delegated call to the old PL/SQL routine
353: cn_get_comm_summ_data.get_group_codes(ddx_result_tbl);
354:
355: -- copy data back from the local OUT or IN-OUT args, if any
356: cn_get_comm_summ_data_w.rosetta_table_copy_out_p3(ddx_result_tbl, p0_a0
357: , p0_a1
358: , p0_a2
359: , p0_a3
360: , p0_a4

Line 365: end cn_get_comm_summ_data_w;

361: , p0_a5
362: );
363: end;
364:
365: end cn_get_comm_summ_data_w;