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
10: , a7 JTF_NUMBER_TABLE
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
10: , a7 JTF_NUMBER_TABLE
11: ) as
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
43: , a7 out nocopy JTF_NUMBER_TABLE
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
43: , a7 out nocopy JTF_NUMBER_TABLE
44: ) as
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();
55: a7 := JTF_NUMBER_TABLE();
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();
55: a7 := JTF_NUMBER_TABLE();
56: else
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();
64: a7 := JTF_NUMBER_TABLE();
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();
64: a7 := JTF_NUMBER_TABLE();
65: if t.count > 0 then
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
477: , p4_a7 out nocopy JTF_NUMBER_TABLE
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
477: , p4_a7 out nocopy JTF_NUMBER_TABLE
478: )
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
524: , p3_a7 out nocopy JTF_NUMBER_TABLE
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
524: , p3_a7 out nocopy JTF_NUMBER_TABLE
525: )
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
569: , p4_a7 out nocopy JTF_NUMBER_TABLE
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
569: , p4_a7 out nocopy JTF_NUMBER_TABLE
570: )