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_SALES_HIER_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 14: , a1 JTF_VARCHAR2_TABLE_100

10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy cn_sales_hier_pub.hier_tbl_type, a0 JTF_VARCHAR2_TABLE_300
14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_DATE_TABLE
17: , a4 JTF_DATE_TABLE
18: ) as

Line 15: , a2 JTF_VARCHAR2_TABLE_100

11: end;
12:
13: procedure rosetta_table_copy_in_p1(t out nocopy cn_sales_hier_pub.hier_tbl_type, a0 JTF_VARCHAR2_TABLE_300
14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_DATE_TABLE
17: , a4 JTF_DATE_TABLE
18: ) as
19: ddindx binary_integer; indx binary_integer;

Line 41: , a1 out nocopy JTF_VARCHAR2_TABLE_100

37: end if;
38: end if;
39: end rosetta_table_copy_in_p1;
40: procedure rosetta_table_copy_out_p1(t cn_sales_hier_pub.hier_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
41: , a1 out nocopy JTF_VARCHAR2_TABLE_100
42: , a2 out nocopy JTF_VARCHAR2_TABLE_100
43: , a3 out nocopy JTF_DATE_TABLE
44: , a4 out nocopy JTF_DATE_TABLE
45: ) as

Line 42: , a2 out nocopy JTF_VARCHAR2_TABLE_100

38: end if;
39: end rosetta_table_copy_in_p1;
40: procedure rosetta_table_copy_out_p1(t cn_sales_hier_pub.hier_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300
41: , a1 out nocopy JTF_VARCHAR2_TABLE_100
42: , a2 out nocopy JTF_VARCHAR2_TABLE_100
43: , a3 out nocopy JTF_DATE_TABLE
44: , a4 out nocopy JTF_DATE_TABLE
45: ) as
46: ddindx binary_integer; indx binary_integer;

Line 50: a1 := JTF_VARCHAR2_TABLE_100();

46: ddindx binary_integer; indx binary_integer;
47: begin
48: if t is null or t.count = 0 then
49: a0 := JTF_VARCHAR2_TABLE_300();
50: a1 := JTF_VARCHAR2_TABLE_100();
51: a2 := JTF_VARCHAR2_TABLE_100();
52: a3 := JTF_DATE_TABLE();
53: a4 := JTF_DATE_TABLE();
54: else

Line 51: a2 := JTF_VARCHAR2_TABLE_100();

47: begin
48: if t is null or t.count = 0 then
49: a0 := JTF_VARCHAR2_TABLE_300();
50: a1 := JTF_VARCHAR2_TABLE_100();
51: a2 := JTF_VARCHAR2_TABLE_100();
52: a3 := JTF_DATE_TABLE();
53: a4 := JTF_DATE_TABLE();
54: else
55: a0 := JTF_VARCHAR2_TABLE_300();

Line 56: a1 := JTF_VARCHAR2_TABLE_100();

52: a3 := JTF_DATE_TABLE();
53: a4 := JTF_DATE_TABLE();
54: else
55: a0 := JTF_VARCHAR2_TABLE_300();
56: a1 := JTF_VARCHAR2_TABLE_100();
57: a2 := JTF_VARCHAR2_TABLE_100();
58: a3 := JTF_DATE_TABLE();
59: a4 := JTF_DATE_TABLE();
60: if t.count > 0 then

Line 57: a2 := JTF_VARCHAR2_TABLE_100();

53: a4 := JTF_DATE_TABLE();
54: else
55: a0 := JTF_VARCHAR2_TABLE_300();
56: a1 := JTF_VARCHAR2_TABLE_100();
57: a2 := JTF_VARCHAR2_TABLE_100();
58: a3 := JTF_DATE_TABLE();
59: a4 := JTF_DATE_TABLE();
60: if t.count > 0 then
61: a0.extend(t.count);

Line 84: procedure rosetta_table_copy_in_p3(t out nocopy cn_sales_hier_pub.grp_tbl_type, a0 JTF_VARCHAR2_TABLE_100

80: end if;
81: end if;
82: end rosetta_table_copy_out_p1;
83:
84: procedure rosetta_table_copy_in_p3(t out nocopy cn_sales_hier_pub.grp_tbl_type, a0 JTF_VARCHAR2_TABLE_100
85: , a1 JTF_NUMBER_TABLE
86: , a2 JTF_VARCHAR2_TABLE_300
87: , a3 JTF_VARCHAR2_TABLE_100
88: ) as

Line 87: , a3 JTF_VARCHAR2_TABLE_100

83:
84: procedure rosetta_table_copy_in_p3(t out nocopy cn_sales_hier_pub.grp_tbl_type, a0 JTF_VARCHAR2_TABLE_100
85: , a1 JTF_NUMBER_TABLE
86: , a2 JTF_VARCHAR2_TABLE_300
87: , a3 JTF_VARCHAR2_TABLE_100
88: ) as
89: ddindx binary_integer; indx binary_integer;
90: begin
91: if a0 is not null and a0.count > 0 then

Line 109: procedure rosetta_table_copy_out_p3(t cn_sales_hier_pub.grp_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

105: end loop;
106: end if;
107: end if;
108: end rosetta_table_copy_in_p3;
109: procedure rosetta_table_copy_out_p3(t cn_sales_hier_pub.grp_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
110: , a1 out nocopy JTF_NUMBER_TABLE
111: , a2 out nocopy JTF_VARCHAR2_TABLE_300
112: , a3 out nocopy JTF_VARCHAR2_TABLE_100
113: ) as

Line 112: , a3 out nocopy JTF_VARCHAR2_TABLE_100

108: end rosetta_table_copy_in_p3;
109: procedure rosetta_table_copy_out_p3(t cn_sales_hier_pub.grp_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
110: , a1 out nocopy JTF_NUMBER_TABLE
111: , a2 out nocopy JTF_VARCHAR2_TABLE_300
112: , a3 out nocopy JTF_VARCHAR2_TABLE_100
113: ) as
114: ddindx binary_integer; indx binary_integer;
115: begin
116: if t is null or t.count = 0 then

Line 117: a0 := JTF_VARCHAR2_TABLE_100();

113: ) as
114: ddindx binary_integer; indx binary_integer;
115: begin
116: if t is null or t.count = 0 then
117: a0 := JTF_VARCHAR2_TABLE_100();
118: a1 := JTF_NUMBER_TABLE();
119: a2 := JTF_VARCHAR2_TABLE_300();
120: a3 := JTF_VARCHAR2_TABLE_100();
121: else

Line 120: a3 := JTF_VARCHAR2_TABLE_100();

116: if t is null or t.count = 0 then
117: a0 := JTF_VARCHAR2_TABLE_100();
118: a1 := JTF_NUMBER_TABLE();
119: a2 := JTF_VARCHAR2_TABLE_300();
120: a3 := JTF_VARCHAR2_TABLE_100();
121: else
122: a0 := JTF_VARCHAR2_TABLE_100();
123: a1 := JTF_NUMBER_TABLE();
124: a2 := JTF_VARCHAR2_TABLE_300();

Line 122: a0 := JTF_VARCHAR2_TABLE_100();

118: a1 := JTF_NUMBER_TABLE();
119: a2 := JTF_VARCHAR2_TABLE_300();
120: a3 := JTF_VARCHAR2_TABLE_100();
121: else
122: a0 := JTF_VARCHAR2_TABLE_100();
123: a1 := JTF_NUMBER_TABLE();
124: a2 := JTF_VARCHAR2_TABLE_300();
125: a3 := JTF_VARCHAR2_TABLE_100();
126: if t.count > 0 then

Line 125: a3 := JTF_VARCHAR2_TABLE_100();

121: else
122: a0 := JTF_VARCHAR2_TABLE_100();
123: a1 := JTF_NUMBER_TABLE();
124: a2 := JTF_VARCHAR2_TABLE_300();
125: a3 := JTF_VARCHAR2_TABLE_100();
126: if t.count > 0 then
127: a0.extend(t.count);
128: a1.extend(t.count);
129: a2.extend(t.count);

Line 163: , p14_a1 out nocopy JTF_VARCHAR2_TABLE_100

159: , p_increment_count NUMBER
160: , p_start_record_grp NUMBER
161: , p_increment_count_grp NUMBER
162: , p14_a0 out nocopy JTF_VARCHAR2_TABLE_300
163: , p14_a1 out nocopy JTF_VARCHAR2_TABLE_100
164: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_100
165: , p14_a3 out nocopy JTF_DATE_TABLE
166: , p14_a4 out nocopy JTF_DATE_TABLE
167: , x_mgr_count out nocopy NUMBER

Line 164: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_100

160: , p_start_record_grp NUMBER
161: , p_increment_count_grp NUMBER
162: , p14_a0 out nocopy JTF_VARCHAR2_TABLE_300
163: , p14_a1 out nocopy JTF_VARCHAR2_TABLE_100
164: , p14_a2 out nocopy JTF_VARCHAR2_TABLE_100
165: , p14_a3 out nocopy JTF_DATE_TABLE
166: , p14_a4 out nocopy JTF_DATE_TABLE
167: , x_mgr_count out nocopy NUMBER
168: , p16_a0 out nocopy JTF_VARCHAR2_TABLE_300

Line 169: , p16_a1 out nocopy JTF_VARCHAR2_TABLE_100

165: , p14_a3 out nocopy JTF_DATE_TABLE
166: , p14_a4 out nocopy JTF_DATE_TABLE
167: , x_mgr_count out nocopy NUMBER
168: , p16_a0 out nocopy JTF_VARCHAR2_TABLE_300
169: , p16_a1 out nocopy JTF_VARCHAR2_TABLE_100
170: , p16_a2 out nocopy JTF_VARCHAR2_TABLE_100
171: , p16_a3 out nocopy JTF_DATE_TABLE
172: , p16_a4 out nocopy JTF_DATE_TABLE
173: , x_srp_count out nocopy NUMBER

Line 170: , p16_a2 out nocopy JTF_VARCHAR2_TABLE_100

166: , p14_a4 out nocopy JTF_DATE_TABLE
167: , x_mgr_count out nocopy NUMBER
168: , p16_a0 out nocopy JTF_VARCHAR2_TABLE_300
169: , p16_a1 out nocopy JTF_VARCHAR2_TABLE_100
170: , p16_a2 out nocopy JTF_VARCHAR2_TABLE_100
171: , p16_a3 out nocopy JTF_DATE_TABLE
172: , p16_a4 out nocopy JTF_DATE_TABLE
173: , x_srp_count out nocopy NUMBER
174: , p18_a0 out nocopy JTF_VARCHAR2_TABLE_100

Line 174: , p18_a0 out nocopy JTF_VARCHAR2_TABLE_100

170: , p16_a2 out nocopy JTF_VARCHAR2_TABLE_100
171: , p16_a3 out nocopy JTF_DATE_TABLE
172: , p16_a4 out nocopy JTF_DATE_TABLE
173: , x_srp_count out nocopy NUMBER
174: , p18_a0 out nocopy JTF_VARCHAR2_TABLE_100
175: , p18_a1 out nocopy JTF_NUMBER_TABLE
176: , p18_a2 out nocopy JTF_VARCHAR2_TABLE_300
177: , p18_a3 out nocopy JTF_VARCHAR2_TABLE_100
178: , x_grp_count out nocopy NUMBER

Line 177: , p18_a3 out nocopy JTF_VARCHAR2_TABLE_100

173: , x_srp_count out nocopy NUMBER
174: , p18_a0 out nocopy JTF_VARCHAR2_TABLE_100
175: , p18_a1 out nocopy JTF_NUMBER_TABLE
176: , p18_a2 out nocopy JTF_VARCHAR2_TABLE_300
177: , p18_a3 out nocopy JTF_VARCHAR2_TABLE_100
178: , x_grp_count out nocopy NUMBER
179: )
180:
181: as