APPS.CN_SALES_HIER_PUB_W dependencies on JTF_VARCHAR2_TABLE_300

Line 13: procedure rosetta_table_copy_in_p1(t out nocopy cn_sales_hier_pub.hier_tbl_type, a0 JTF_VARCHAR2_TABLE_300

9: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
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

Line 40: procedure rosetta_table_copy_out_p1(t cn_sales_hier_pub.hier_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_300

36: end loop;
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

Line 49: a0 := JTF_VARCHAR2_TABLE_300();

45: ) as
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();

Line 55: a0 := JTF_VARCHAR2_TABLE_300();

51: a2 := 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();

Line 86: , a2 JTF_VARCHAR2_TABLE_300

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
89: ddindx binary_integer; indx binary_integer;
90: begin

Line 111: , a2 out nocopy JTF_VARCHAR2_TABLE_300

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
114: ddindx binary_integer; indx binary_integer;
115: begin

Line 119: a2 := JTF_VARCHAR2_TABLE_300();

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
122: a0 := JTF_VARCHAR2_TABLE_100();
123: a1 := JTF_NUMBER_TABLE();

Line 124: 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
127: a0.extend(t.count);
128: a1.extend(t.count);

Line 162: , p14_a0 out nocopy JTF_VARCHAR2_TABLE_300

158: , p_start_record NUMBER
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

Line 168: , p16_a0 out nocopy JTF_VARCHAR2_TABLE_300

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
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

Line 176: , p18_a2 out nocopy JTF_VARCHAR2_TABLE_300

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
179: )
180: