DBA Data[Home] [Help]

APPS.CN_GET_COMM_SUMM_DATA_PVT_W dependencies on JTF_DATE_TABLE

Line 6: , a3 JTF_DATE_TABLE

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

Line 7: , a4 JTF_DATE_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

Line 39: , a3 out nocopy JTF_DATE_TABLE

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

Line 40: , a4 out nocopy JTF_DATE_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

Line 51: a3 := JTF_DATE_TABLE();

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();

Line 52: a4 := JTF_DATE_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

Line 60: a3 := JTF_DATE_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();
64: a7 := JTF_NUMBER_TABLE();

Line 61: a4 := JTF_DATE_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

Line 473: , p4_a3 out nocopy JTF_DATE_TABLE

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

Line 474: , p4_a4 out nocopy JTF_DATE_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: )

Line 520: , p3_a3 out nocopy JTF_DATE_TABLE

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

Line 521: , p3_a4 out nocopy JTF_DATE_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: )

Line 565: , p4_a3 out nocopy JTF_DATE_TABLE

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

Line 566: , p4_a4 out nocopy JTF_DATE_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: )