DBA Data[Home] [Help]

APPS.CN_PLAN_TEXTS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 17: , a4 JTF_VARCHAR2_TABLE_100

13: procedure rosetta_table_copy_in_p1(t out nocopy cn_plan_texts_pvt.plan_text_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_NUMBER_TABLE
15: , a2 JTF_NUMBER_TABLE
16: , a3 JTF_NUMBER_TABLE
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_VARCHAR2_TABLE_2000
19: , a6 JTF_VARCHAR2_TABLE_2000
20: , a7 JTF_NUMBER_TABLE
21: , a8 JTF_NUMBER_TABLE

Line 52: , a4 out nocopy JTF_VARCHAR2_TABLE_100

48: procedure rosetta_table_copy_out_p1(t cn_plan_texts_pvt.plan_text_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
49: , a1 out nocopy JTF_NUMBER_TABLE
50: , a2 out nocopy JTF_NUMBER_TABLE
51: , a3 out nocopy JTF_NUMBER_TABLE
52: , a4 out nocopy JTF_VARCHAR2_TABLE_100
53: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
54: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
55: , a7 out nocopy JTF_NUMBER_TABLE
56: , a8 out nocopy JTF_NUMBER_TABLE

Line 65: a4 := JTF_VARCHAR2_TABLE_100();

61: a0 := JTF_NUMBER_TABLE();
62: a1 := JTF_NUMBER_TABLE();
63: a2 := JTF_NUMBER_TABLE();
64: a3 := JTF_NUMBER_TABLE();
65: a4 := JTF_VARCHAR2_TABLE_100();
66: a5 := JTF_VARCHAR2_TABLE_2000();
67: a6 := JTF_VARCHAR2_TABLE_2000();
68: a7 := JTF_NUMBER_TABLE();
69: a8 := JTF_NUMBER_TABLE();

Line 75: a4 := JTF_VARCHAR2_TABLE_100();

71: a0 := JTF_NUMBER_TABLE();
72: a1 := JTF_NUMBER_TABLE();
73: a2 := JTF_NUMBER_TABLE();
74: a3 := JTF_NUMBER_TABLE();
75: a4 := JTF_VARCHAR2_TABLE_100();
76: a5 := JTF_VARCHAR2_TABLE_2000();
77: a6 := JTF_VARCHAR2_TABLE_2000();
78: a7 := JTF_NUMBER_TABLE();
79: a8 := JTF_NUMBER_TABLE();

Line 113: , a1 JTF_VARCHAR2_TABLE_100

109: end if;
110: end rosetta_table_copy_out_p1;
111:
112: procedure rosetta_table_copy_in_p3(t out nocopy cn_plan_texts_pvt.quota_cate_tbl_type, a0 JTF_NUMBER_TABLE
113: , a1 JTF_VARCHAR2_TABLE_100
114: ) as
115: ddindx binary_integer; indx binary_integer;
116: begin
117: if a0 is not null and a0.count > 0 then

Line 134: , a1 out nocopy JTF_VARCHAR2_TABLE_100

130: end if;
131: end if;
132: end rosetta_table_copy_in_p3;
133: procedure rosetta_table_copy_out_p3(t cn_plan_texts_pvt.quota_cate_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
134: , a1 out nocopy JTF_VARCHAR2_TABLE_100
135: ) as
136: ddindx binary_integer; indx binary_integer;
137: begin
138: if t is null or t.count = 0 then

Line 140: a1 := JTF_VARCHAR2_TABLE_100();

136: ddindx binary_integer; indx binary_integer;
137: begin
138: if t is null or t.count = 0 then
139: a0 := JTF_NUMBER_TABLE();
140: a1 := JTF_VARCHAR2_TABLE_100();
141: else
142: a0 := JTF_NUMBER_TABLE();
143: a1 := JTF_VARCHAR2_TABLE_100();
144: if t.count > 0 then

Line 143: a1 := JTF_VARCHAR2_TABLE_100();

139: a0 := JTF_NUMBER_TABLE();
140: a1 := JTF_VARCHAR2_TABLE_100();
141: else
142: a0 := JTF_NUMBER_TABLE();
143: a1 := JTF_VARCHAR2_TABLE_100();
144: if t.count > 0 then
145: a0.extend(t.count);
146: a1.extend(t.count);
147: ddindx := t.first;

Line 355: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

351: , p6_a0 out nocopy JTF_NUMBER_TABLE
352: , p6_a1 out nocopy JTF_NUMBER_TABLE
353: , p6_a2 out nocopy JTF_NUMBER_TABLE
354: , p6_a3 out nocopy JTF_NUMBER_TABLE
355: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
356: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
357: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
358: , p6_a7 out nocopy JTF_NUMBER_TABLE
359: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 426: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

422: , p_validation_level NUMBER
423: , p_role_id NUMBER
424: , p_role_model_id NUMBER
425: , p6_a0 out nocopy JTF_NUMBER_TABLE
426: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
427: , x_return_status out nocopy VARCHAR2
428: , x_msg_count out nocopy NUMBER
429: , x_msg_data out nocopy VARCHAR2
430: )

Line 482: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

478: , p_validation_level NUMBER
479: , p_role_id NUMBER
480: , p_role_model_id NUMBER
481: , p6_a0 out nocopy JTF_NUMBER_TABLE
482: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
483: , x_return_status out nocopy VARCHAR2
484: , x_msg_count out nocopy NUMBER
485: , x_msg_data out nocopy VARCHAR2
486: )

Line 539: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100

535: , p_role_id NUMBER
536: , p_role_model_id NUMBER
537: , p_quota_cate_type VARCHAR2
538: , p7_a0 out nocopy JTF_NUMBER_TABLE
539: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
540: , x_return_status out nocopy VARCHAR2
541: , x_msg_count out nocopy NUMBER
542: , x_msg_data out nocopy VARCHAR2
543: )