DBA Data[Home] [Help]

APPS.JTF_RS_GRP_SUM_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 23: , a1 JTF_VARCHAR2_TABLE_100

19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out NOCOPY jtf_rs_grp_sum_pub.grp_sum_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_DATE_TABLE

Line 25: , a3 JTF_VARCHAR2_TABLE_100

21:
22: procedure rosetta_table_copy_in_p1(t out NOCOPY jtf_rs_grp_sum_pub.grp_sum_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_NUMBER_TABLE

Line 28: , a6 JTF_VARCHAR2_TABLE_100

24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_DATE_TABLE
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_NUMBER_TABLE
32: ) as

Line 30: , a8 JTF_VARCHAR2_TABLE_100

26: , a4 JTF_DATE_TABLE
27: , a5 JTF_DATE_TABLE
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: , a9 JTF_NUMBER_TABLE
32: ) as
33: ddindx binary_integer; indx binary_integer;
34: begin

Line 60: , a1 out NOCOPY JTF_VARCHAR2_TABLE_100

56: end if;
57: end if;
58: end rosetta_table_copy_in_p1;
59: procedure rosetta_table_copy_out_p1(t jtf_rs_grp_sum_pub.grp_sum_tbl_type, a0 out NOCOPY JTF_NUMBER_TABLE
60: , a1 out NOCOPY JTF_VARCHAR2_TABLE_100
61: , a2 out NOCOPY JTF_VARCHAR2_TABLE_300
62: , a3 out NOCOPY JTF_VARCHAR2_TABLE_100
63: , a4 out NOCOPY JTF_DATE_TABLE
64: , a5 out NOCOPY JTF_DATE_TABLE

Line 62: , a3 out NOCOPY JTF_VARCHAR2_TABLE_100

58: end rosetta_table_copy_in_p1;
59: procedure rosetta_table_copy_out_p1(t jtf_rs_grp_sum_pub.grp_sum_tbl_type, a0 out NOCOPY JTF_NUMBER_TABLE
60: , a1 out NOCOPY JTF_VARCHAR2_TABLE_100
61: , a2 out NOCOPY JTF_VARCHAR2_TABLE_300
62: , a3 out NOCOPY JTF_VARCHAR2_TABLE_100
63: , a4 out NOCOPY JTF_DATE_TABLE
64: , a5 out NOCOPY JTF_DATE_TABLE
65: , a6 out NOCOPY JTF_VARCHAR2_TABLE_100
66: , a7 out NOCOPY JTF_NUMBER_TABLE

Line 65: , a6 out NOCOPY JTF_VARCHAR2_TABLE_100

61: , a2 out NOCOPY JTF_VARCHAR2_TABLE_300
62: , a3 out NOCOPY JTF_VARCHAR2_TABLE_100
63: , a4 out NOCOPY JTF_DATE_TABLE
64: , a5 out NOCOPY JTF_DATE_TABLE
65: , a6 out NOCOPY JTF_VARCHAR2_TABLE_100
66: , a7 out NOCOPY JTF_NUMBER_TABLE
67: , a8 out NOCOPY JTF_VARCHAR2_TABLE_100
68: , a9 out NOCOPY JTF_NUMBER_TABLE
69: ) as

Line 67: , a8 out NOCOPY JTF_VARCHAR2_TABLE_100

63: , a4 out NOCOPY JTF_DATE_TABLE
64: , a5 out NOCOPY JTF_DATE_TABLE
65: , a6 out NOCOPY JTF_VARCHAR2_TABLE_100
66: , a7 out NOCOPY JTF_NUMBER_TABLE
67: , a8 out NOCOPY JTF_VARCHAR2_TABLE_100
68: , a9 out NOCOPY JTF_NUMBER_TABLE
69: ) as
70: ddindx binary_integer; indx binary_integer;
71: begin

Line 74: a1 := JTF_VARCHAR2_TABLE_100();

70: ddindx binary_integer; indx binary_integer;
71: begin
72: if t is null or t.count = 0 then
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_VARCHAR2_TABLE_100();
75: a2 := JTF_VARCHAR2_TABLE_300();
76: a3 := JTF_VARCHAR2_TABLE_100();
77: a4 := JTF_DATE_TABLE();
78: a5 := JTF_DATE_TABLE();

Line 76: a3 := JTF_VARCHAR2_TABLE_100();

72: if t is null or t.count = 0 then
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_VARCHAR2_TABLE_100();
75: a2 := JTF_VARCHAR2_TABLE_300();
76: a3 := JTF_VARCHAR2_TABLE_100();
77: a4 := JTF_DATE_TABLE();
78: a5 := JTF_DATE_TABLE();
79: a6 := JTF_VARCHAR2_TABLE_100();
80: a7 := JTF_NUMBER_TABLE();

Line 79: a6 := JTF_VARCHAR2_TABLE_100();

75: a2 := JTF_VARCHAR2_TABLE_300();
76: a3 := JTF_VARCHAR2_TABLE_100();
77: a4 := JTF_DATE_TABLE();
78: a5 := JTF_DATE_TABLE();
79: a6 := JTF_VARCHAR2_TABLE_100();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_VARCHAR2_TABLE_100();
82: a9 := JTF_NUMBER_TABLE();
83: else

Line 81: a8 := JTF_VARCHAR2_TABLE_100();

77: a4 := JTF_DATE_TABLE();
78: a5 := JTF_DATE_TABLE();
79: a6 := JTF_VARCHAR2_TABLE_100();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_VARCHAR2_TABLE_100();
82: a9 := JTF_NUMBER_TABLE();
83: else
84: a0 := JTF_NUMBER_TABLE();
85: a1 := JTF_VARCHAR2_TABLE_100();

Line 85: a1 := JTF_VARCHAR2_TABLE_100();

81: a8 := JTF_VARCHAR2_TABLE_100();
82: a9 := JTF_NUMBER_TABLE();
83: else
84: a0 := JTF_NUMBER_TABLE();
85: a1 := JTF_VARCHAR2_TABLE_100();
86: a2 := JTF_VARCHAR2_TABLE_300();
87: a3 := JTF_VARCHAR2_TABLE_100();
88: a4 := JTF_DATE_TABLE();
89: a5 := JTF_DATE_TABLE();

Line 87: a3 := JTF_VARCHAR2_TABLE_100();

83: else
84: a0 := JTF_NUMBER_TABLE();
85: a1 := JTF_VARCHAR2_TABLE_100();
86: a2 := JTF_VARCHAR2_TABLE_300();
87: a3 := JTF_VARCHAR2_TABLE_100();
88: a4 := JTF_DATE_TABLE();
89: a5 := JTF_DATE_TABLE();
90: a6 := JTF_VARCHAR2_TABLE_100();
91: a7 := JTF_NUMBER_TABLE();

Line 90: a6 := JTF_VARCHAR2_TABLE_100();

86: a2 := JTF_VARCHAR2_TABLE_300();
87: a3 := JTF_VARCHAR2_TABLE_100();
88: a4 := JTF_DATE_TABLE();
89: a5 := JTF_DATE_TABLE();
90: a6 := JTF_VARCHAR2_TABLE_100();
91: a7 := JTF_NUMBER_TABLE();
92: a8 := JTF_VARCHAR2_TABLE_100();
93: a9 := JTF_NUMBER_TABLE();
94: if t.count > 0 then

Line 92: a8 := JTF_VARCHAR2_TABLE_100();

88: a4 := JTF_DATE_TABLE();
89: a5 := JTF_DATE_TABLE();
90: a6 := JTF_VARCHAR2_TABLE_100();
91: a7 := JTF_NUMBER_TABLE();
92: a8 := JTF_VARCHAR2_TABLE_100();
93: a9 := JTF_NUMBER_TABLE();
94: if t.count > 0 then
95: a0.extend(t.count);
96: a1.extend(t.count);

Line 143: , p14_a1 out NOCOPY JTF_VARCHAR2_TABLE_100

139: , p_group_id NUMBER
140: , p_group_usage VARCHAR2
141: , x_total_rows out NOCOPY NUMBER
142: , p14_a0 out NOCOPY JTF_NUMBER_TABLE
143: , p14_a1 out NOCOPY JTF_VARCHAR2_TABLE_100
144: , p14_a2 out NOCOPY JTF_VARCHAR2_TABLE_300
145: , p14_a3 out NOCOPY JTF_VARCHAR2_TABLE_100
146: , p14_a4 out NOCOPY JTF_DATE_TABLE
147: , p14_a5 out NOCOPY JTF_DATE_TABLE

Line 145: , p14_a3 out NOCOPY JTF_VARCHAR2_TABLE_100

141: , x_total_rows out NOCOPY NUMBER
142: , p14_a0 out NOCOPY JTF_NUMBER_TABLE
143: , p14_a1 out NOCOPY JTF_VARCHAR2_TABLE_100
144: , p14_a2 out NOCOPY JTF_VARCHAR2_TABLE_300
145: , p14_a3 out NOCOPY JTF_VARCHAR2_TABLE_100
146: , p14_a4 out NOCOPY JTF_DATE_TABLE
147: , p14_a5 out NOCOPY JTF_DATE_TABLE
148: , p14_a6 out NOCOPY JTF_VARCHAR2_TABLE_100
149: , p14_a7 out NOCOPY JTF_NUMBER_TABLE

Line 148: , p14_a6 out NOCOPY JTF_VARCHAR2_TABLE_100

144: , p14_a2 out NOCOPY JTF_VARCHAR2_TABLE_300
145: , p14_a3 out NOCOPY JTF_VARCHAR2_TABLE_100
146: , p14_a4 out NOCOPY JTF_DATE_TABLE
147: , p14_a5 out NOCOPY JTF_DATE_TABLE
148: , p14_a6 out NOCOPY JTF_VARCHAR2_TABLE_100
149: , p14_a7 out NOCOPY JTF_NUMBER_TABLE
150: , p14_a8 out NOCOPY JTF_VARCHAR2_TABLE_100
151: , p14_a9 out NOCOPY JTF_NUMBER_TABLE
152: )

Line 150: , p14_a8 out NOCOPY JTF_VARCHAR2_TABLE_100

146: , p14_a4 out NOCOPY JTF_DATE_TABLE
147: , p14_a5 out NOCOPY JTF_DATE_TABLE
148: , p14_a6 out NOCOPY JTF_VARCHAR2_TABLE_100
149: , p14_a7 out NOCOPY JTF_NUMBER_TABLE
150: , p14_a8 out NOCOPY JTF_VARCHAR2_TABLE_100
151: , p14_a9 out NOCOPY JTF_NUMBER_TABLE
152: )
153: as
154: ddx_result_tbl jtf_rs_grp_sum_pub.grp_sum_tbl_type;