DBA Data[Home] [Help]

APPS.CS_TP_CHOICES_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 23: , a1 JTF_VARCHAR2_TABLE_1000

19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out nocopy cs_tp_choices_pvt.choice_list, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_1000
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100

Line 26: , a4 JTF_VARCHAR2_TABLE_100

22: procedure rosetta_table_copy_in_p1(t out nocopy cs_tp_choices_pvt.choice_list, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_1000
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: ) as
29: ddindx binary_integer; indx binary_integer;
30: begin

Line 27: , a5 JTF_VARCHAR2_TABLE_100

23: , a1 JTF_VARCHAR2_TABLE_1000
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: ) as
29: ddindx binary_integer; indx binary_integer;
30: begin
31: if a0 is not null and a0.count > 0 then

Line 52: , a1 out nocopy JTF_VARCHAR2_TABLE_1000

48: end if;
49: end if;
50: end rosetta_table_copy_in_p1;
51: procedure rosetta_table_copy_out_p1(t cs_tp_choices_pvt.choice_list, a0 out nocopy JTF_NUMBER_TABLE
52: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
53: , a2 out nocopy JTF_NUMBER_TABLE
54: , a3 out nocopy JTF_NUMBER_TABLE
55: , a4 out nocopy JTF_VARCHAR2_TABLE_100
56: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 55: , a4 out nocopy JTF_VARCHAR2_TABLE_100

51: procedure rosetta_table_copy_out_p1(t cs_tp_choices_pvt.choice_list, a0 out nocopy JTF_NUMBER_TABLE
52: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
53: , a2 out nocopy JTF_NUMBER_TABLE
54: , a3 out nocopy JTF_NUMBER_TABLE
55: , a4 out nocopy JTF_VARCHAR2_TABLE_100
56: , a5 out nocopy JTF_VARCHAR2_TABLE_100
57: ) as
58: ddindx binary_integer; indx binary_integer;
59: begin

Line 56: , a5 out nocopy JTF_VARCHAR2_TABLE_100

52: , a1 out nocopy JTF_VARCHAR2_TABLE_1000
53: , a2 out nocopy JTF_NUMBER_TABLE
54: , a3 out nocopy JTF_NUMBER_TABLE
55: , a4 out nocopy JTF_VARCHAR2_TABLE_100
56: , a5 out nocopy JTF_VARCHAR2_TABLE_100
57: ) as
58: ddindx binary_integer; indx binary_integer;
59: begin
60: if t is null or t.count = 0 then

Line 62: a1 := JTF_VARCHAR2_TABLE_1000();

58: ddindx binary_integer; indx binary_integer;
59: begin
60: if t is null or t.count = 0 then
61: a0 := JTF_NUMBER_TABLE();
62: a1 := JTF_VARCHAR2_TABLE_1000();
63: a2 := JTF_NUMBER_TABLE();
64: a3 := JTF_NUMBER_TABLE();
65: a4 := JTF_VARCHAR2_TABLE_100();
66: a5 := JTF_VARCHAR2_TABLE_100();

Line 65: a4 := JTF_VARCHAR2_TABLE_100();

61: a0 := JTF_NUMBER_TABLE();
62: a1 := JTF_VARCHAR2_TABLE_1000();
63: a2 := JTF_NUMBER_TABLE();
64: a3 := JTF_NUMBER_TABLE();
65: a4 := JTF_VARCHAR2_TABLE_100();
66: a5 := JTF_VARCHAR2_TABLE_100();
67: else
68: a0 := JTF_NUMBER_TABLE();
69: a1 := JTF_VARCHAR2_TABLE_1000();

Line 66: a5 := JTF_VARCHAR2_TABLE_100();

62: a1 := JTF_VARCHAR2_TABLE_1000();
63: a2 := JTF_NUMBER_TABLE();
64: a3 := JTF_NUMBER_TABLE();
65: a4 := JTF_VARCHAR2_TABLE_100();
66: a5 := JTF_VARCHAR2_TABLE_100();
67: else
68: a0 := JTF_NUMBER_TABLE();
69: a1 := JTF_VARCHAR2_TABLE_1000();
70: a2 := JTF_NUMBER_TABLE();

Line 69: a1 := JTF_VARCHAR2_TABLE_1000();

65: a4 := JTF_VARCHAR2_TABLE_100();
66: a5 := JTF_VARCHAR2_TABLE_100();
67: else
68: a0 := JTF_NUMBER_TABLE();
69: a1 := JTF_VARCHAR2_TABLE_1000();
70: a2 := JTF_NUMBER_TABLE();
71: a3 := JTF_NUMBER_TABLE();
72: a4 := JTF_VARCHAR2_TABLE_100();
73: a5 := JTF_VARCHAR2_TABLE_100();

Line 72: a4 := JTF_VARCHAR2_TABLE_100();

68: a0 := JTF_NUMBER_TABLE();
69: a1 := JTF_VARCHAR2_TABLE_1000();
70: a2 := JTF_NUMBER_TABLE();
71: a3 := JTF_NUMBER_TABLE();
72: a4 := JTF_VARCHAR2_TABLE_100();
73: a5 := JTF_VARCHAR2_TABLE_100();
74: if t.count > 0 then
75: a0.extend(t.count);
76: a1.extend(t.count);

Line 73: a5 := JTF_VARCHAR2_TABLE_100();

69: a1 := JTF_VARCHAR2_TABLE_1000();
70: a2 := JTF_NUMBER_TABLE();
71: a3 := JTF_NUMBER_TABLE();
72: a4 := JTF_VARCHAR2_TABLE_100();
73: a5 := JTF_VARCHAR2_TABLE_100();
74: if t.count > 0 then
75: a0.extend(t.count);
76: a1.extend(t.count);
77: a2.extend(t.count);

Line 159: , p3_a1 JTF_VARCHAR2_TABLE_1000

155: procedure sort_choices(p_api_version_number NUMBER
156: , p_init_msg_list VARCHAR2
157: , p_commit VARCHAR
158: , p3_a0 JTF_NUMBER_TABLE
159: , p3_a1 JTF_VARCHAR2_TABLE_1000
160: , p3_a2 JTF_NUMBER_TABLE
161: , p3_a3 JTF_NUMBER_TABLE
162: , p3_a4 JTF_VARCHAR2_TABLE_100
163: , p3_a5 JTF_VARCHAR2_TABLE_100

Line 162: , p3_a4 JTF_VARCHAR2_TABLE_100

158: , p3_a0 JTF_NUMBER_TABLE
159: , p3_a1 JTF_VARCHAR2_TABLE_1000
160: , p3_a2 JTF_NUMBER_TABLE
161: , p3_a3 JTF_NUMBER_TABLE
162: , p3_a4 JTF_VARCHAR2_TABLE_100
163: , p3_a5 JTF_VARCHAR2_TABLE_100
164: , x_msg_count out nocopy NUMBER
165: , x_msg_data out nocopy VARCHAR2
166: , x_return_status out nocopy VARCHAR2

Line 163: , p3_a5 JTF_VARCHAR2_TABLE_100

159: , p3_a1 JTF_VARCHAR2_TABLE_1000
160: , p3_a2 JTF_NUMBER_TABLE
161: , p3_a3 JTF_NUMBER_TABLE
162: , p3_a4 JTF_VARCHAR2_TABLE_100
163: , p3_a5 JTF_VARCHAR2_TABLE_100
164: , x_msg_count out nocopy NUMBER
165: , x_msg_data out nocopy VARCHAR2
166: , x_return_status out nocopy VARCHAR2
167: )

Line 216: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_1000

212: , x_msg_count out nocopy NUMBER
213: , x_msg_data out nocopy VARCHAR2
214: , x_return_status out nocopy VARCHAR2
215: , p8_a0 out nocopy JTF_NUMBER_TABLE
216: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_1000
217: , p8_a2 out nocopy JTF_NUMBER_TABLE
218: , p8_a3 out nocopy JTF_NUMBER_TABLE
219: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
220: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 219: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100

215: , p8_a0 out nocopy JTF_NUMBER_TABLE
216: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_1000
217: , p8_a2 out nocopy JTF_NUMBER_TABLE
218: , p8_a3 out nocopy JTF_NUMBER_TABLE
219: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
220: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
221: )
222:
223: as

Line 220: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100

216: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_1000
217: , p8_a2 out nocopy JTF_NUMBER_TABLE
218: , p8_a3 out nocopy JTF_NUMBER_TABLE
219: , p8_a4 out nocopy JTF_VARCHAR2_TABLE_100
220: , p8_a5 out nocopy JTF_VARCHAR2_TABLE_100
221: )
222:
223: as
224: ddx_choice_list_to_show cs_tp_choices_pvt.choice_list;

Line 271: , p3_a1 JTF_VARCHAR2_TABLE_1000

267: procedure update_choices(p_api_version_number NUMBER
268: , p_init_msg_list VARCHAR2
269: , p_commit VARCHAR
270: , p3_a0 JTF_NUMBER_TABLE
271: , p3_a1 JTF_VARCHAR2_TABLE_1000
272: , p3_a2 JTF_NUMBER_TABLE
273: , p3_a3 JTF_NUMBER_TABLE
274: , p3_a4 JTF_VARCHAR2_TABLE_100
275: , p3_a5 JTF_VARCHAR2_TABLE_100

Line 274: , p3_a4 JTF_VARCHAR2_TABLE_100

270: , p3_a0 JTF_NUMBER_TABLE
271: , p3_a1 JTF_VARCHAR2_TABLE_1000
272: , p3_a2 JTF_NUMBER_TABLE
273: , p3_a3 JTF_NUMBER_TABLE
274: , p3_a4 JTF_VARCHAR2_TABLE_100
275: , p3_a5 JTF_VARCHAR2_TABLE_100
276: , x_msg_count out nocopy NUMBER
277: , x_msg_data out nocopy VARCHAR2
278: , x_return_status out nocopy VARCHAR2

Line 275: , p3_a5 JTF_VARCHAR2_TABLE_100

271: , p3_a1 JTF_VARCHAR2_TABLE_1000
272: , p3_a2 JTF_NUMBER_TABLE
273: , p3_a3 JTF_NUMBER_TABLE
274: , p3_a4 JTF_VARCHAR2_TABLE_100
275: , p3_a5 JTF_VARCHAR2_TABLE_100
276: , x_msg_count out nocopy NUMBER
277: , x_msg_data out nocopy VARCHAR2
278: , x_return_status out nocopy VARCHAR2
279: )