DBA Data[Home] [Help]

APPS.PV_CMDASHBOARD_UTIL_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package body pv_cmdashboard_util_w as
2: /* $Header: pvxwcdub.pls 120.0 2005/07/05 23:49:54 appldev noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy pv_cmdashboard_util.kpi_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_400
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: ) as

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: pvxwcdub.pls 120.0 2005/07/05 23:49:54 appldev noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy pv_cmdashboard_util.kpi_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_400
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: ) as
9: ddindx binary_integer; indx binary_integer;
10: begin

Line 7: , a4 JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p1(t out nocopy pv_cmdashboard_util.kpi_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_400
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: ) as
9: ddindx binary_integer; indx binary_integer;
10: begin
11: if a0 is not null and a0.count > 0 then

Line 31: , a1 out nocopy JTF_VARCHAR2_TABLE_100

27: end if;
28: end if;
29: end rosetta_table_copy_in_p1;
30: procedure rosetta_table_copy_out_p1(t pv_cmdashboard_util.kpi_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_VARCHAR2_TABLE_100
32: , a2 out nocopy JTF_VARCHAR2_TABLE_400
33: , a3 out nocopy JTF_VARCHAR2_TABLE_100
34: , a4 out nocopy JTF_VARCHAR2_TABLE_100
35: ) as

Line 33: , a3 out nocopy JTF_VARCHAR2_TABLE_100

29: end rosetta_table_copy_in_p1;
30: procedure rosetta_table_copy_out_p1(t pv_cmdashboard_util.kpi_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_VARCHAR2_TABLE_100
32: , a2 out nocopy JTF_VARCHAR2_TABLE_400
33: , a3 out nocopy JTF_VARCHAR2_TABLE_100
34: , a4 out nocopy JTF_VARCHAR2_TABLE_100
35: ) as
36: ddindx binary_integer; indx binary_integer;
37: begin

Line 34: , a4 out nocopy JTF_VARCHAR2_TABLE_100

30: procedure rosetta_table_copy_out_p1(t pv_cmdashboard_util.kpi_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_VARCHAR2_TABLE_100
32: , a2 out nocopy JTF_VARCHAR2_TABLE_400
33: , a3 out nocopy JTF_VARCHAR2_TABLE_100
34: , a4 out nocopy JTF_VARCHAR2_TABLE_100
35: ) as
36: ddindx binary_integer; indx binary_integer;
37: begin
38: if t is null or t.count = 0 then

Line 40: a1 := JTF_VARCHAR2_TABLE_100();

36: ddindx binary_integer; indx binary_integer;
37: begin
38: if t is null or t.count = 0 then
39: a0 := JTF_NUMBER_TABLE();
40: a1 := JTF_VARCHAR2_TABLE_100();
41: a2 := JTF_VARCHAR2_TABLE_400();
42: a3 := JTF_VARCHAR2_TABLE_100();
43: a4 := JTF_VARCHAR2_TABLE_100();
44: else

Line 42: a3 := JTF_VARCHAR2_TABLE_100();

38: if t is null or t.count = 0 then
39: a0 := JTF_NUMBER_TABLE();
40: a1 := JTF_VARCHAR2_TABLE_100();
41: a2 := JTF_VARCHAR2_TABLE_400();
42: a3 := JTF_VARCHAR2_TABLE_100();
43: a4 := JTF_VARCHAR2_TABLE_100();
44: else
45: a0 := JTF_NUMBER_TABLE();
46: a1 := JTF_VARCHAR2_TABLE_100();

Line 43: a4 := JTF_VARCHAR2_TABLE_100();

39: a0 := JTF_NUMBER_TABLE();
40: a1 := JTF_VARCHAR2_TABLE_100();
41: a2 := JTF_VARCHAR2_TABLE_400();
42: a3 := JTF_VARCHAR2_TABLE_100();
43: a4 := JTF_VARCHAR2_TABLE_100();
44: else
45: a0 := JTF_NUMBER_TABLE();
46: a1 := JTF_VARCHAR2_TABLE_100();
47: a2 := JTF_VARCHAR2_TABLE_400();

Line 46: a1 := JTF_VARCHAR2_TABLE_100();

42: a3 := JTF_VARCHAR2_TABLE_100();
43: a4 := JTF_VARCHAR2_TABLE_100();
44: else
45: a0 := JTF_NUMBER_TABLE();
46: a1 := JTF_VARCHAR2_TABLE_100();
47: a2 := JTF_VARCHAR2_TABLE_400();
48: a3 := JTF_VARCHAR2_TABLE_100();
49: a4 := JTF_VARCHAR2_TABLE_100();
50: if t.count > 0 then

Line 48: a3 := JTF_VARCHAR2_TABLE_100();

44: else
45: a0 := JTF_NUMBER_TABLE();
46: a1 := JTF_VARCHAR2_TABLE_100();
47: a2 := JTF_VARCHAR2_TABLE_400();
48: a3 := JTF_VARCHAR2_TABLE_100();
49: a4 := JTF_VARCHAR2_TABLE_100();
50: if t.count > 0 then
51: a0.extend(t.count);
52: a1.extend(t.count);

Line 49: a4 := JTF_VARCHAR2_TABLE_100();

45: a0 := JTF_NUMBER_TABLE();
46: a1 := JTF_VARCHAR2_TABLE_100();
47: a2 := JTF_VARCHAR2_TABLE_400();
48: a3 := JTF_VARCHAR2_TABLE_100();
49: a4 := JTF_VARCHAR2_TABLE_100();
50: if t.count > 0 then
51: a0.extend(t.count);
52: a1.extend(t.count);
53: a2.extend(t.count);

Line 76: , p1_a1 in out nocopy JTF_VARCHAR2_TABLE_100

72: end rosetta_table_copy_out_p1;
73:
74: procedure get_kpis_detail(p_resource_id NUMBER
75: , p1_a0 in out nocopy JTF_NUMBER_TABLE
76: , p1_a1 in out nocopy JTF_VARCHAR2_TABLE_100
77: , p1_a2 in out nocopy JTF_VARCHAR2_TABLE_400
78: , p1_a3 in out nocopy JTF_VARCHAR2_TABLE_100
79: , p1_a4 in out nocopy JTF_VARCHAR2_TABLE_100
80: )

Line 78: , p1_a3 in out nocopy JTF_VARCHAR2_TABLE_100

74: procedure get_kpis_detail(p_resource_id NUMBER
75: , p1_a0 in out nocopy JTF_NUMBER_TABLE
76: , p1_a1 in out nocopy JTF_VARCHAR2_TABLE_100
77: , p1_a2 in out nocopy JTF_VARCHAR2_TABLE_400
78: , p1_a3 in out nocopy JTF_VARCHAR2_TABLE_100
79: , p1_a4 in out nocopy JTF_VARCHAR2_TABLE_100
80: )
81:
82: as

Line 79: , p1_a4 in out nocopy JTF_VARCHAR2_TABLE_100

75: , p1_a0 in out nocopy JTF_NUMBER_TABLE
76: , p1_a1 in out nocopy JTF_VARCHAR2_TABLE_100
77: , p1_a2 in out nocopy JTF_VARCHAR2_TABLE_400
78: , p1_a3 in out nocopy JTF_VARCHAR2_TABLE_100
79: , p1_a4 in out nocopy JTF_VARCHAR2_TABLE_100
80: )
81:
82: as
83: ddp_kpi_set pv_cmdashboard_util.kpi_tbl_type;