DBA Data[Home] [Help]

APPS.JTF_MSITE_GRP_W dependencies on JTF_NUMBER_TABLE

Line 23: , a1 JTF_NUMBER_TABLE

19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p7(t out jtf_msite_grp.msite_currencies_tbl_type, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100

Line 24: , a2 JTF_NUMBER_TABLE

20: end;
21:
22: procedure rosetta_table_copy_in_p7(t out jtf_msite_grp.msite_currencies_tbl_type, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: ) as

Line 25: , a3 JTF_NUMBER_TABLE

21:
22: procedure rosetta_table_copy_in_p7(t out jtf_msite_grp.msite_currencies_tbl_type, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: ) as
29: ddindx binary_integer; indx binary_integer;

Line 26: , a4 JTF_NUMBER_TABLE

22: procedure rosetta_table_copy_in_p7(t out jtf_msite_grp.msite_currencies_tbl_type, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE
27: , a5 JTF_VARCHAR2_TABLE_100
28: ) as
29: ddindx binary_integer; indx binary_integer;
30: begin

Line 52: , a1 out JTF_NUMBER_TABLE

48: end if;
49: end if;
50: end rosetta_table_copy_in_p7;
51: procedure rosetta_table_copy_out_p7(t jtf_msite_grp.msite_currencies_tbl_type, a0 out JTF_VARCHAR2_TABLE_100
52: , a1 out JTF_NUMBER_TABLE
53: , a2 out JTF_NUMBER_TABLE
54: , a3 out JTF_NUMBER_TABLE
55: , a4 out JTF_NUMBER_TABLE
56: , a5 out JTF_VARCHAR2_TABLE_100

Line 53: , a2 out JTF_NUMBER_TABLE

49: end if;
50: end rosetta_table_copy_in_p7;
51: procedure rosetta_table_copy_out_p7(t jtf_msite_grp.msite_currencies_tbl_type, a0 out JTF_VARCHAR2_TABLE_100
52: , a1 out JTF_NUMBER_TABLE
53: , a2 out JTF_NUMBER_TABLE
54: , a3 out JTF_NUMBER_TABLE
55: , a4 out JTF_NUMBER_TABLE
56: , a5 out JTF_VARCHAR2_TABLE_100
57: ) as

Line 54: , a3 out JTF_NUMBER_TABLE

50: end rosetta_table_copy_in_p7;
51: procedure rosetta_table_copy_out_p7(t jtf_msite_grp.msite_currencies_tbl_type, a0 out JTF_VARCHAR2_TABLE_100
52: , a1 out JTF_NUMBER_TABLE
53: , a2 out JTF_NUMBER_TABLE
54: , a3 out JTF_NUMBER_TABLE
55: , a4 out JTF_NUMBER_TABLE
56: , a5 out JTF_VARCHAR2_TABLE_100
57: ) as
58: ddindx binary_integer; indx binary_integer;

Line 55: , a4 out JTF_NUMBER_TABLE

51: procedure rosetta_table_copy_out_p7(t jtf_msite_grp.msite_currencies_tbl_type, a0 out JTF_VARCHAR2_TABLE_100
52: , a1 out JTF_NUMBER_TABLE
53: , a2 out JTF_NUMBER_TABLE
54: , a3 out JTF_NUMBER_TABLE
55: , a4 out JTF_NUMBER_TABLE
56: , a5 out JTF_VARCHAR2_TABLE_100
57: ) as
58: ddindx binary_integer; indx binary_integer;
59: begin

Line 62: a1 := JTF_NUMBER_TABLE();

58: ddindx binary_integer; indx binary_integer;
59: begin
60: if t is null or t.count = 0 then
61: a0 := JTF_VARCHAR2_TABLE_100();
62: a1 := JTF_NUMBER_TABLE();
63: a2 := JTF_NUMBER_TABLE();
64: a3 := JTF_NUMBER_TABLE();
65: a4 := JTF_NUMBER_TABLE();
66: a5 := 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_VARCHAR2_TABLE_100();
62: a1 := JTF_NUMBER_TABLE();
63: a2 := JTF_NUMBER_TABLE();
64: a3 := JTF_NUMBER_TABLE();
65: a4 := JTF_NUMBER_TABLE();
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_VARCHAR2_TABLE_100();
62: a1 := JTF_NUMBER_TABLE();
63: a2 := JTF_NUMBER_TABLE();
64: a3 := JTF_NUMBER_TABLE();
65: a4 := JTF_NUMBER_TABLE();
66: a5 := JTF_VARCHAR2_TABLE_100();
67: else
68: a0 := JTF_VARCHAR2_TABLE_100();

Line 65: a4 := JTF_NUMBER_TABLE();

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

Line 69: a1 := JTF_NUMBER_TABLE();

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

Line 70: a2 := JTF_NUMBER_TABLE();

66: a5 := JTF_VARCHAR2_TABLE_100();
67: else
68: a0 := JTF_VARCHAR2_TABLE_100();
69: a1 := JTF_NUMBER_TABLE();
70: a2 := JTF_NUMBER_TABLE();
71: a3 := JTF_NUMBER_TABLE();
72: a4 := JTF_NUMBER_TABLE();
73: a5 := JTF_VARCHAR2_TABLE_100();
74: if t.count > 0 then

Line 71: a3 := JTF_NUMBER_TABLE();

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

Line 72: a4 := JTF_NUMBER_TABLE();

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

Line 150: procedure rosetta_table_copy_in_p9(t out jtf_msite_grp.msite_orgids_tbl_type, a0 JTF_NUMBER_TABLE

146: end if;
147: end if;
148: end rosetta_table_copy_out_p8;
149:
150: procedure rosetta_table_copy_in_p9(t out jtf_msite_grp.msite_orgids_tbl_type, a0 JTF_NUMBER_TABLE
151: , a1 JTF_VARCHAR2_TABLE_100
152: ) as
153: ddindx binary_integer; indx binary_integer;
154: begin

Line 171: procedure rosetta_table_copy_out_p9(t jtf_msite_grp.msite_orgids_tbl_type, a0 out JTF_NUMBER_TABLE

167: end loop;
168: end if;
169: end if;
170: end rosetta_table_copy_in_p9;
171: procedure rosetta_table_copy_out_p9(t jtf_msite_grp.msite_orgids_tbl_type, a0 out JTF_NUMBER_TABLE
172: , a1 out JTF_VARCHAR2_TABLE_100
173: ) as
174: ddindx binary_integer; indx binary_integer;
175: begin

Line 177: a0 := JTF_NUMBER_TABLE();

173: ) as
174: ddindx binary_integer; indx binary_integer;
175: begin
176: if t is null or t.count = 0 then
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_VARCHAR2_TABLE_100();
179: else
180: a0 := JTF_NUMBER_TABLE();
181: a1 := JTF_VARCHAR2_TABLE_100();

Line 180: a0 := JTF_NUMBER_TABLE();

176: if t is null or t.count = 0 then
177: a0 := JTF_NUMBER_TABLE();
178: a1 := JTF_VARCHAR2_TABLE_100();
179: else
180: a0 := JTF_NUMBER_TABLE();
181: a1 := JTF_VARCHAR2_TABLE_100();
182: if t.count > 0 then
183: a0.extend(t.count);
184: a1.extend(t.count);

Line 200: procedure rosetta_table_copy_in_p10(t out jtf_msite_grp.msite_delete_tbl_type, a0 JTF_NUMBER_TABLE

196: end if;
197: end if;
198: end rosetta_table_copy_out_p9;
199:
200: procedure rosetta_table_copy_in_p10(t out jtf_msite_grp.msite_delete_tbl_type, a0 JTF_NUMBER_TABLE
201: , a1 JTF_NUMBER_TABLE
202: ) as
203: ddindx binary_integer; indx binary_integer;
204: begin

Line 201: , a1 JTF_NUMBER_TABLE

197: end if;
198: end rosetta_table_copy_out_p9;
199:
200: procedure rosetta_table_copy_in_p10(t out jtf_msite_grp.msite_delete_tbl_type, a0 JTF_NUMBER_TABLE
201: , a1 JTF_NUMBER_TABLE
202: ) as
203: ddindx binary_integer; indx binary_integer;
204: begin
205: if a0 is not null and a0.count > 0 then

Line 221: procedure rosetta_table_copy_out_p10(t jtf_msite_grp.msite_delete_tbl_type, a0 out JTF_NUMBER_TABLE

217: end loop;
218: end if;
219: end if;
220: end rosetta_table_copy_in_p10;
221: procedure rosetta_table_copy_out_p10(t jtf_msite_grp.msite_delete_tbl_type, a0 out JTF_NUMBER_TABLE
222: , a1 out JTF_NUMBER_TABLE
223: ) as
224: ddindx binary_integer; indx binary_integer;
225: begin

Line 222: , a1 out JTF_NUMBER_TABLE

218: end if;
219: end if;
220: end rosetta_table_copy_in_p10;
221: procedure rosetta_table_copy_out_p10(t jtf_msite_grp.msite_delete_tbl_type, a0 out JTF_NUMBER_TABLE
222: , a1 out JTF_NUMBER_TABLE
223: ) as
224: ddindx binary_integer; indx binary_integer;
225: begin
226: if t is null or t.count = 0 then

Line 227: a0 := JTF_NUMBER_TABLE();

223: ) as
224: ddindx binary_integer; indx binary_integer;
225: begin
226: if t is null or t.count = 0 then
227: a0 := JTF_NUMBER_TABLE();
228: a1 := JTF_NUMBER_TABLE();
229: else
230: a0 := JTF_NUMBER_TABLE();
231: a1 := JTF_NUMBER_TABLE();

Line 228: a1 := JTF_NUMBER_TABLE();

224: ddindx binary_integer; indx binary_integer;
225: begin
226: if t is null or t.count = 0 then
227: a0 := JTF_NUMBER_TABLE();
228: a1 := JTF_NUMBER_TABLE();
229: else
230: a0 := JTF_NUMBER_TABLE();
231: a1 := JTF_NUMBER_TABLE();
232: if t.count > 0 then

Line 230: a0 := JTF_NUMBER_TABLE();

226: if t is null or t.count = 0 then
227: a0 := JTF_NUMBER_TABLE();
228: a1 := JTF_NUMBER_TABLE();
229: else
230: a0 := JTF_NUMBER_TABLE();
231: a1 := JTF_NUMBER_TABLE();
232: if t.count > 0 then
233: a0.extend(t.count);
234: a1.extend(t.count);

Line 231: a1 := JTF_NUMBER_TABLE();

227: a0 := JTF_NUMBER_TABLE();
228: a1 := JTF_NUMBER_TABLE();
229: else
230: a0 := JTF_NUMBER_TABLE();
231: a1 := JTF_NUMBER_TABLE();
232: if t.count > 0 then
233: a0.extend(t.count);
234: a1.extend(t.count);
235: ddindx := t.first;

Line 250: procedure rosetta_table_copy_in_p11(t out jtf_msite_grp.msite_prtyids_tbl_type, a0 JTF_NUMBER_TABLE) as

246: end if;
247: end if;
248: end rosetta_table_copy_out_p10;
249:
250: procedure rosetta_table_copy_in_p11(t out jtf_msite_grp.msite_prtyids_tbl_type, a0 JTF_NUMBER_TABLE) as
251: ddindx binary_integer; indx binary_integer;
252: begin
253: if a0 is not null and a0.count > 0 then
254: if a0.count > 0 then

Line 268: procedure rosetta_table_copy_out_p11(t jtf_msite_grp.msite_prtyids_tbl_type, a0 out JTF_NUMBER_TABLE) as

264: end loop;
265: end if;
266: end if;
267: end rosetta_table_copy_in_p11;
268: procedure rosetta_table_copy_out_p11(t jtf_msite_grp.msite_prtyids_tbl_type, a0 out JTF_NUMBER_TABLE) as
269: ddindx binary_integer; indx binary_integer;
270: begin
271: if t is null or t.count = 0 then
272: a0 := JTF_NUMBER_TABLE();

Line 272: a0 := JTF_NUMBER_TABLE();

268: procedure rosetta_table_copy_out_p11(t jtf_msite_grp.msite_prtyids_tbl_type, a0 out JTF_NUMBER_TABLE) as
269: ddindx binary_integer; indx binary_integer;
270: begin
271: if t is null or t.count = 0 then
272: a0 := JTF_NUMBER_TABLE();
273: else
274: a0 := JTF_NUMBER_TABLE();
275: if t.count > 0 then
276: a0.extend(t.count);

Line 274: a0 := JTF_NUMBER_TABLE();

270: begin
271: if t is null or t.count = 0 then
272: a0 := JTF_NUMBER_TABLE();
273: else
274: a0 := JTF_NUMBER_TABLE();
275: if t.count > 0 then
276: a0.extend(t.count);
277: ddindx := t.first;
278: indx := 1;

Line 297: , p6_a0 JTF_NUMBER_TABLE

293: , p_commit VARCHAR2
294: , x_return_status out VARCHAR2
295: , x_msg_count out NUMBER
296: , x_msg_data out VARCHAR2
297: , p6_a0 JTF_NUMBER_TABLE
298: , p6_a1 JTF_NUMBER_TABLE
299: )
300: as
301: ddp_msite_id_tbl jtf_msite_grp.msite_delete_tbl_type;

Line 298: , p6_a1 JTF_NUMBER_TABLE

294: , x_return_status out VARCHAR2
295: , x_msg_count out NUMBER
296: , x_msg_data out VARCHAR2
297: , p6_a0 JTF_NUMBER_TABLE
298: , p6_a1 JTF_NUMBER_TABLE
299: )
300: as
301: ddp_msite_id_tbl jtf_msite_grp.msite_delete_tbl_type;
302: ddindx binary_integer; indx binary_integer;

Line 481: , p7_a1 JTF_NUMBER_TABLE

477: , x_msg_count out NUMBER
478: , x_msg_data out VARCHAR2
479: , p_msite_id NUMBER
480: , p7_a0 JTF_VARCHAR2_TABLE_100
481: , p7_a1 JTF_NUMBER_TABLE
482: , p7_a2 JTF_NUMBER_TABLE
483: , p7_a3 JTF_NUMBER_TABLE
484: , p7_a4 JTF_NUMBER_TABLE
485: , p7_a5 JTF_VARCHAR2_TABLE_100

Line 482: , p7_a2 JTF_NUMBER_TABLE

478: , x_msg_data out VARCHAR2
479: , p_msite_id NUMBER
480: , p7_a0 JTF_VARCHAR2_TABLE_100
481: , p7_a1 JTF_NUMBER_TABLE
482: , p7_a2 JTF_NUMBER_TABLE
483: , p7_a3 JTF_NUMBER_TABLE
484: , p7_a4 JTF_NUMBER_TABLE
485: , p7_a5 JTF_VARCHAR2_TABLE_100
486: )

Line 483: , p7_a3 JTF_NUMBER_TABLE

479: , p_msite_id NUMBER
480: , p7_a0 JTF_VARCHAR2_TABLE_100
481: , p7_a1 JTF_NUMBER_TABLE
482: , p7_a2 JTF_NUMBER_TABLE
483: , p7_a3 JTF_NUMBER_TABLE
484: , p7_a4 JTF_NUMBER_TABLE
485: , p7_a5 JTF_VARCHAR2_TABLE_100
486: )
487: as

Line 484: , p7_a4 JTF_NUMBER_TABLE

480: , p7_a0 JTF_VARCHAR2_TABLE_100
481: , p7_a1 JTF_NUMBER_TABLE
482: , p7_a2 JTF_NUMBER_TABLE
483: , p7_a3 JTF_NUMBER_TABLE
484: , p7_a4 JTF_NUMBER_TABLE
485: , p7_a5 JTF_VARCHAR2_TABLE_100
486: )
487: as
488: ddp_msite_currencies_tbl jtf_msite_grp.msite_currencies_tbl_type;

Line 535: , p7_a0 JTF_NUMBER_TABLE

531: , x_return_status out VARCHAR2
532: , x_msg_count out NUMBER
533: , x_msg_data out VARCHAR2
534: , p_msite_id NUMBER
535: , p7_a0 JTF_NUMBER_TABLE
536: , p7_a1 JTF_VARCHAR2_TABLE_100
537: )
538: as
539: ddp_msite_orgids_tbl jtf_msite_grp.msite_orgids_tbl_type;