DBA Data[Home] [Help]

APPS.CN_SALES_HIER_PUB_W dependencies on JTF_DATE_TABLE

Line 16: , a3 JTF_DATE_TABLE

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;
20: begin

Line 17: , a4 JTF_DATE_TABLE

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;
20: begin
21: if a0 is not null and a0.count > 0 then

Line 43: , a3 out nocopy JTF_DATE_TABLE

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;
47: begin

Line 44: , a4 out nocopy JTF_DATE_TABLE

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;
47: begin
48: if t is null or t.count = 0 then

Line 52: a3 := JTF_DATE_TABLE();

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();
56: a1 := JTF_VARCHAR2_TABLE_100();

Line 53: a4 := JTF_DATE_TABLE();

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();
56: a1 := JTF_VARCHAR2_TABLE_100();
57: a2 := JTF_VARCHAR2_TABLE_100();

Line 58: a3 := 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);
62: a1.extend(t.count);

Line 59: a4 := JTF_DATE_TABLE();

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);
62: a1.extend(t.count);
63: a2.extend(t.count);

Line 165: , p14_a3 out nocopy JTF_DATE_TABLE

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
169: , p16_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 166: , p14_a4 out nocopy JTF_DATE_TABLE

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
169: , p16_a1 out nocopy JTF_VARCHAR2_TABLE_100
170: , p16_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 171: , p16_a3 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
175: , p18_a1 out nocopy JTF_NUMBER_TABLE

Line 172: , p16_a4 out nocopy JTF_DATE_TABLE

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
175: , p18_a1 out nocopy JTF_NUMBER_TABLE
176: , p18_a2 out nocopy JTF_VARCHAR2_TABLE_300