DBA Data[Home] [Help]

APPS.CS_TP_CHOICES_PVT_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p1(t out nocopy cs_tp_choices_pvt.choice_list, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
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

Line 24: , a2 JTF_NUMBER_TABLE

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
28: ) as

Line 25: , a3 JTF_NUMBER_TABLE

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
28: ) as
29: ddindx binary_integer; indx binary_integer;

Line 51: procedure rosetta_table_copy_out_p1(t cs_tp_choices_pvt.choice_list, a0 out nocopy JTF_NUMBER_TABLE

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

Line 53: , a2 out nocopy JTF_NUMBER_TABLE

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
57: ) as

Line 54: , a3 out nocopy JTF_NUMBER_TABLE

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
57: ) as
58: ddindx binary_integer; indx binary_integer;

Line 61: a0 := JTF_NUMBER_TABLE();

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

Line 63: a2 := JTF_NUMBER_TABLE();

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();
67: else

Line 64: a3 := JTF_NUMBER_TABLE();

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();
67: else
68: a0 := JTF_NUMBER_TABLE();

Line 68: a0 := 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();
71: a3 := JTF_NUMBER_TABLE();
72: a4 := JTF_VARCHAR2_TABLE_100();

Line 70: a2 := JTF_NUMBER_TABLE();

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();
74: if t.count > 0 then

Line 71: a3 := JTF_NUMBER_TABLE();

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();
74: if t.count > 0 then
75: a0.extend(t.count);

Line 158: , p3_a0 JTF_NUMBER_TABLE

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

Line 160: , p3_a2 JTF_NUMBER_TABLE

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
164: , x_msg_count out nocopy NUMBER

Line 161: , p3_a3 JTF_NUMBER_TABLE

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
164: , x_msg_count out nocopy NUMBER
165: , x_msg_data out nocopy VARCHAR2

Line 215: , p8_a0 out nocopy JTF_NUMBER_TABLE

211: , p_display_order VARCHAR2
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

Line 217: , p8_a2 out nocopy JTF_NUMBER_TABLE

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
221: )

Line 218: , p8_a3 out nocopy JTF_NUMBER_TABLE

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
221: )
222:

Line 270: , p3_a0 JTF_NUMBER_TABLE

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

Line 272: , p3_a2 JTF_NUMBER_TABLE

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
276: , x_msg_count out nocopy NUMBER

Line 273: , p3_a3 JTF_NUMBER_TABLE

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
276: , x_msg_count out nocopy NUMBER
277: , x_msg_data out nocopy VARCHAR2