DBA Data[Home] [Help]

APPS.AHL_MEL_CDL_ATA_SEQS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_mel_cdl_ata_seqs_pvt.ata_sequence_tbl_type, a0 JTF_NUMBER_TABLE

1: package body ahl_mel_cdl_ata_seqs_pvt_w as
2: /* $Header: AHLWATAB.pls 120.1 2005/09/12 04:08 tamdas noship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_mel_cdl_ata_seqs_pvt.ata_sequence_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_NUMBER_TABLE

1: package body ahl_mel_cdl_ata_seqs_pvt_w as
2: /* $Header: AHLWATAB.pls 120.1 2005/09/12 04:08 tamdas noship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_mel_cdl_ata_seqs_pvt.ata_sequence_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_NUMBER_TABLE

1: package body ahl_mel_cdl_ata_seqs_pvt_w as
2: /* $Header: AHLWATAB.pls 120.1 2005/09/12 04:08 tamdas noship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_mel_cdl_ata_seqs_pvt.ata_sequence_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: AHLWATAB.pls 120.1 2005/09/12 04:08 tamdas noship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ahl_mel_cdl_ata_seqs_pvt.ata_sequence_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE

Line 9: , a6 JTF_NUMBER_TABLE

5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_200
13: , a10 JTF_VARCHAR2_TABLE_200

Line 10: , a7 JTF_NUMBER_TABLE

6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_200
13: , a10 JTF_VARCHAR2_TABLE_200
14: , a11 JTF_VARCHAR2_TABLE_200

Line 72: procedure rosetta_table_copy_out_p3(t ahl_mel_cdl_ata_seqs_pvt.ata_sequence_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

68: end loop;
69: end if;
70: end if;
71: end rosetta_table_copy_in_p3;
72: procedure rosetta_table_copy_out_p3(t ahl_mel_cdl_ata_seqs_pvt.ata_sequence_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
73: , a1 out nocopy JTF_NUMBER_TABLE
74: , a2 out nocopy JTF_NUMBER_TABLE
75: , a3 out nocopy JTF_NUMBER_TABLE
76: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 73: , a1 out nocopy JTF_NUMBER_TABLE

69: end if;
70: end if;
71: end rosetta_table_copy_in_p3;
72: procedure rosetta_table_copy_out_p3(t ahl_mel_cdl_ata_seqs_pvt.ata_sequence_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
73: , a1 out nocopy JTF_NUMBER_TABLE
74: , a2 out nocopy JTF_NUMBER_TABLE
75: , a3 out nocopy JTF_NUMBER_TABLE
76: , a4 out nocopy JTF_VARCHAR2_TABLE_100
77: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 74: , a2 out nocopy JTF_NUMBER_TABLE

70: end if;
71: end rosetta_table_copy_in_p3;
72: procedure rosetta_table_copy_out_p3(t ahl_mel_cdl_ata_seqs_pvt.ata_sequence_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
73: , a1 out nocopy JTF_NUMBER_TABLE
74: , a2 out nocopy JTF_NUMBER_TABLE
75: , a3 out nocopy JTF_NUMBER_TABLE
76: , a4 out nocopy JTF_VARCHAR2_TABLE_100
77: , a5 out nocopy JTF_VARCHAR2_TABLE_100
78: , a6 out nocopy JTF_NUMBER_TABLE

Line 75: , a3 out nocopy JTF_NUMBER_TABLE

71: end rosetta_table_copy_in_p3;
72: procedure rosetta_table_copy_out_p3(t ahl_mel_cdl_ata_seqs_pvt.ata_sequence_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
73: , a1 out nocopy JTF_NUMBER_TABLE
74: , a2 out nocopy JTF_NUMBER_TABLE
75: , a3 out nocopy JTF_NUMBER_TABLE
76: , a4 out nocopy JTF_VARCHAR2_TABLE_100
77: , a5 out nocopy JTF_VARCHAR2_TABLE_100
78: , a6 out nocopy JTF_NUMBER_TABLE
79: , a7 out nocopy JTF_NUMBER_TABLE

Line 78: , a6 out nocopy JTF_NUMBER_TABLE

74: , a2 out nocopy JTF_NUMBER_TABLE
75: , a3 out nocopy JTF_NUMBER_TABLE
76: , a4 out nocopy JTF_VARCHAR2_TABLE_100
77: , a5 out nocopy JTF_VARCHAR2_TABLE_100
78: , a6 out nocopy JTF_NUMBER_TABLE
79: , a7 out nocopy JTF_NUMBER_TABLE
80: , a8 out nocopy JTF_VARCHAR2_TABLE_100
81: , a9 out nocopy JTF_VARCHAR2_TABLE_200
82: , a10 out nocopy JTF_VARCHAR2_TABLE_200

Line 79: , a7 out nocopy JTF_NUMBER_TABLE

75: , a3 out nocopy JTF_NUMBER_TABLE
76: , a4 out nocopy JTF_VARCHAR2_TABLE_100
77: , a5 out nocopy JTF_VARCHAR2_TABLE_100
78: , a6 out nocopy JTF_NUMBER_TABLE
79: , a7 out nocopy JTF_NUMBER_TABLE
80: , a8 out nocopy JTF_VARCHAR2_TABLE_100
81: , a9 out nocopy JTF_VARCHAR2_TABLE_200
82: , a10 out nocopy JTF_VARCHAR2_TABLE_200
83: , a11 out nocopy JTF_VARCHAR2_TABLE_200

Line 102: a0 := JTF_NUMBER_TABLE();

98: ) as
99: ddindx binary_integer; indx binary_integer;
100: begin
101: if t is null or t.count = 0 then
102: a0 := JTF_NUMBER_TABLE();
103: a1 := JTF_NUMBER_TABLE();
104: a2 := JTF_NUMBER_TABLE();
105: a3 := JTF_NUMBER_TABLE();
106: a4 := JTF_VARCHAR2_TABLE_100();

Line 103: a1 := JTF_NUMBER_TABLE();

99: ddindx binary_integer; indx binary_integer;
100: begin
101: if t is null or t.count = 0 then
102: a0 := JTF_NUMBER_TABLE();
103: a1 := JTF_NUMBER_TABLE();
104: a2 := JTF_NUMBER_TABLE();
105: a3 := JTF_NUMBER_TABLE();
106: a4 := JTF_VARCHAR2_TABLE_100();
107: a5 := JTF_VARCHAR2_TABLE_100();

Line 104: a2 := JTF_NUMBER_TABLE();

100: begin
101: if t is null or t.count = 0 then
102: a0 := JTF_NUMBER_TABLE();
103: a1 := JTF_NUMBER_TABLE();
104: a2 := JTF_NUMBER_TABLE();
105: a3 := JTF_NUMBER_TABLE();
106: a4 := JTF_VARCHAR2_TABLE_100();
107: a5 := JTF_VARCHAR2_TABLE_100();
108: a6 := JTF_NUMBER_TABLE();

Line 105: a3 := JTF_NUMBER_TABLE();

101: if t is null or t.count = 0 then
102: a0 := JTF_NUMBER_TABLE();
103: a1 := JTF_NUMBER_TABLE();
104: a2 := JTF_NUMBER_TABLE();
105: a3 := JTF_NUMBER_TABLE();
106: a4 := JTF_VARCHAR2_TABLE_100();
107: a5 := JTF_VARCHAR2_TABLE_100();
108: a6 := JTF_NUMBER_TABLE();
109: a7 := JTF_NUMBER_TABLE();

Line 108: a6 := JTF_NUMBER_TABLE();

104: a2 := JTF_NUMBER_TABLE();
105: a3 := JTF_NUMBER_TABLE();
106: a4 := JTF_VARCHAR2_TABLE_100();
107: a5 := JTF_VARCHAR2_TABLE_100();
108: a6 := JTF_NUMBER_TABLE();
109: a7 := JTF_NUMBER_TABLE();
110: a8 := JTF_VARCHAR2_TABLE_100();
111: a9 := JTF_VARCHAR2_TABLE_200();
112: a10 := JTF_VARCHAR2_TABLE_200();

Line 109: a7 := JTF_NUMBER_TABLE();

105: a3 := JTF_NUMBER_TABLE();
106: a4 := JTF_VARCHAR2_TABLE_100();
107: a5 := JTF_VARCHAR2_TABLE_100();
108: a6 := JTF_NUMBER_TABLE();
109: a7 := JTF_NUMBER_TABLE();
110: a8 := JTF_VARCHAR2_TABLE_100();
111: a9 := JTF_VARCHAR2_TABLE_200();
112: a10 := JTF_VARCHAR2_TABLE_200();
113: a11 := JTF_VARCHAR2_TABLE_200();

Line 129: a0 := JTF_NUMBER_TABLE();

125: a23 := JTF_VARCHAR2_TABLE_200();
126: a24 := JTF_VARCHAR2_TABLE_32767();
127: a25 := JTF_VARCHAR2_TABLE_100();
128: else
129: a0 := JTF_NUMBER_TABLE();
130: a1 := JTF_NUMBER_TABLE();
131: a2 := JTF_NUMBER_TABLE();
132: a3 := JTF_NUMBER_TABLE();
133: a4 := JTF_VARCHAR2_TABLE_100();

Line 130: a1 := JTF_NUMBER_TABLE();

126: a24 := JTF_VARCHAR2_TABLE_32767();
127: a25 := JTF_VARCHAR2_TABLE_100();
128: else
129: a0 := JTF_NUMBER_TABLE();
130: a1 := JTF_NUMBER_TABLE();
131: a2 := JTF_NUMBER_TABLE();
132: a3 := JTF_NUMBER_TABLE();
133: a4 := JTF_VARCHAR2_TABLE_100();
134: a5 := JTF_VARCHAR2_TABLE_100();

Line 131: a2 := JTF_NUMBER_TABLE();

127: a25 := JTF_VARCHAR2_TABLE_100();
128: else
129: a0 := JTF_NUMBER_TABLE();
130: a1 := JTF_NUMBER_TABLE();
131: a2 := JTF_NUMBER_TABLE();
132: a3 := JTF_NUMBER_TABLE();
133: a4 := JTF_VARCHAR2_TABLE_100();
134: a5 := JTF_VARCHAR2_TABLE_100();
135: a6 := JTF_NUMBER_TABLE();

Line 132: a3 := JTF_NUMBER_TABLE();

128: else
129: a0 := JTF_NUMBER_TABLE();
130: a1 := JTF_NUMBER_TABLE();
131: a2 := JTF_NUMBER_TABLE();
132: a3 := JTF_NUMBER_TABLE();
133: a4 := JTF_VARCHAR2_TABLE_100();
134: a5 := JTF_VARCHAR2_TABLE_100();
135: a6 := JTF_NUMBER_TABLE();
136: a7 := JTF_NUMBER_TABLE();

Line 135: a6 := JTF_NUMBER_TABLE();

131: a2 := JTF_NUMBER_TABLE();
132: a3 := JTF_NUMBER_TABLE();
133: a4 := JTF_VARCHAR2_TABLE_100();
134: a5 := JTF_VARCHAR2_TABLE_100();
135: a6 := JTF_NUMBER_TABLE();
136: a7 := JTF_NUMBER_TABLE();
137: a8 := JTF_VARCHAR2_TABLE_100();
138: a9 := JTF_VARCHAR2_TABLE_200();
139: a10 := JTF_VARCHAR2_TABLE_200();

Line 136: a7 := JTF_NUMBER_TABLE();

132: a3 := JTF_NUMBER_TABLE();
133: a4 := JTF_VARCHAR2_TABLE_100();
134: a5 := JTF_VARCHAR2_TABLE_100();
135: a6 := JTF_NUMBER_TABLE();
136: a7 := JTF_NUMBER_TABLE();
137: a8 := JTF_VARCHAR2_TABLE_100();
138: a9 := JTF_VARCHAR2_TABLE_200();
139: a10 := JTF_VARCHAR2_TABLE_200();
140: a11 := JTF_VARCHAR2_TABLE_200();

Line 221: procedure rosetta_table_copy_in_p5(t out nocopy ahl_mel_cdl_ata_seqs_pvt.mo_procedure_tbl_type, a0 JTF_NUMBER_TABLE

217: end if;
218: end if;
219: end rosetta_table_copy_out_p3;
220:
221: procedure rosetta_table_copy_in_p5(t out nocopy ahl_mel_cdl_ata_seqs_pvt.mo_procedure_tbl_type, a0 JTF_NUMBER_TABLE
222: , a1 JTF_NUMBER_TABLE
223: , a2 JTF_NUMBER_TABLE
224: , a3 JTF_NUMBER_TABLE
225: , a4 JTF_VARCHAR2_TABLE_100

Line 222: , a1 JTF_NUMBER_TABLE

218: end if;
219: end rosetta_table_copy_out_p3;
220:
221: procedure rosetta_table_copy_in_p5(t out nocopy ahl_mel_cdl_ata_seqs_pvt.mo_procedure_tbl_type, a0 JTF_NUMBER_TABLE
222: , a1 JTF_NUMBER_TABLE
223: , a2 JTF_NUMBER_TABLE
224: , a3 JTF_NUMBER_TABLE
225: , a4 JTF_VARCHAR2_TABLE_100
226: , a5 JTF_NUMBER_TABLE

Line 223: , a2 JTF_NUMBER_TABLE

219: end rosetta_table_copy_out_p3;
220:
221: procedure rosetta_table_copy_in_p5(t out nocopy ahl_mel_cdl_ata_seqs_pvt.mo_procedure_tbl_type, a0 JTF_NUMBER_TABLE
222: , a1 JTF_NUMBER_TABLE
223: , a2 JTF_NUMBER_TABLE
224: , a3 JTF_NUMBER_TABLE
225: , a4 JTF_VARCHAR2_TABLE_100
226: , a5 JTF_NUMBER_TABLE
227: , a6 JTF_VARCHAR2_TABLE_100

Line 224: , a3 JTF_NUMBER_TABLE

220:
221: procedure rosetta_table_copy_in_p5(t out nocopy ahl_mel_cdl_ata_seqs_pvt.mo_procedure_tbl_type, a0 JTF_NUMBER_TABLE
222: , a1 JTF_NUMBER_TABLE
223: , a2 JTF_NUMBER_TABLE
224: , a3 JTF_NUMBER_TABLE
225: , a4 JTF_VARCHAR2_TABLE_100
226: , a5 JTF_NUMBER_TABLE
227: , a6 JTF_VARCHAR2_TABLE_100
228: , a7 JTF_VARCHAR2_TABLE_200

Line 226: , a5 JTF_NUMBER_TABLE

222: , a1 JTF_NUMBER_TABLE
223: , a2 JTF_NUMBER_TABLE
224: , a3 JTF_NUMBER_TABLE
225: , a4 JTF_VARCHAR2_TABLE_100
226: , a5 JTF_NUMBER_TABLE
227: , a6 JTF_VARCHAR2_TABLE_100
228: , a7 JTF_VARCHAR2_TABLE_200
229: , a8 JTF_VARCHAR2_TABLE_200
230: , a9 JTF_VARCHAR2_TABLE_200

Line 284: procedure rosetta_table_copy_out_p5(t ahl_mel_cdl_ata_seqs_pvt.mo_procedure_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

280: end loop;
281: end if;
282: end if;
283: end rosetta_table_copy_in_p5;
284: procedure rosetta_table_copy_out_p5(t ahl_mel_cdl_ata_seqs_pvt.mo_procedure_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
285: , a1 out nocopy JTF_NUMBER_TABLE
286: , a2 out nocopy JTF_NUMBER_TABLE
287: , a3 out nocopy JTF_NUMBER_TABLE
288: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 285: , a1 out nocopy JTF_NUMBER_TABLE

281: end if;
282: end if;
283: end rosetta_table_copy_in_p5;
284: procedure rosetta_table_copy_out_p5(t ahl_mel_cdl_ata_seqs_pvt.mo_procedure_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
285: , a1 out nocopy JTF_NUMBER_TABLE
286: , a2 out nocopy JTF_NUMBER_TABLE
287: , a3 out nocopy JTF_NUMBER_TABLE
288: , a4 out nocopy JTF_VARCHAR2_TABLE_100
289: , a5 out nocopy JTF_NUMBER_TABLE

Line 286: , a2 out nocopy JTF_NUMBER_TABLE

282: end if;
283: end rosetta_table_copy_in_p5;
284: procedure rosetta_table_copy_out_p5(t ahl_mel_cdl_ata_seqs_pvt.mo_procedure_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
285: , a1 out nocopy JTF_NUMBER_TABLE
286: , a2 out nocopy JTF_NUMBER_TABLE
287: , a3 out nocopy JTF_NUMBER_TABLE
288: , a4 out nocopy JTF_VARCHAR2_TABLE_100
289: , a5 out nocopy JTF_NUMBER_TABLE
290: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 287: , a3 out nocopy JTF_NUMBER_TABLE

283: end rosetta_table_copy_in_p5;
284: procedure rosetta_table_copy_out_p5(t ahl_mel_cdl_ata_seqs_pvt.mo_procedure_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
285: , a1 out nocopy JTF_NUMBER_TABLE
286: , a2 out nocopy JTF_NUMBER_TABLE
287: , a3 out nocopy JTF_NUMBER_TABLE
288: , a4 out nocopy JTF_VARCHAR2_TABLE_100
289: , a5 out nocopy JTF_NUMBER_TABLE
290: , a6 out nocopy JTF_VARCHAR2_TABLE_100
291: , a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 289: , a5 out nocopy JTF_NUMBER_TABLE

285: , a1 out nocopy JTF_NUMBER_TABLE
286: , a2 out nocopy JTF_NUMBER_TABLE
287: , a3 out nocopy JTF_NUMBER_TABLE
288: , a4 out nocopy JTF_VARCHAR2_TABLE_100
289: , a5 out nocopy JTF_NUMBER_TABLE
290: , a6 out nocopy JTF_VARCHAR2_TABLE_100
291: , a7 out nocopy JTF_VARCHAR2_TABLE_200
292: , a8 out nocopy JTF_VARCHAR2_TABLE_200
293: , a9 out nocopy JTF_VARCHAR2_TABLE_200

Line 311: a0 := JTF_NUMBER_TABLE();

307: ) as
308: ddindx binary_integer; indx binary_integer;
309: begin
310: if t is null or t.count = 0 then
311: a0 := JTF_NUMBER_TABLE();
312: a1 := JTF_NUMBER_TABLE();
313: a2 := JTF_NUMBER_TABLE();
314: a3 := JTF_NUMBER_TABLE();
315: a4 := JTF_VARCHAR2_TABLE_100();

Line 312: a1 := JTF_NUMBER_TABLE();

308: ddindx binary_integer; indx binary_integer;
309: begin
310: if t is null or t.count = 0 then
311: a0 := JTF_NUMBER_TABLE();
312: a1 := JTF_NUMBER_TABLE();
313: a2 := JTF_NUMBER_TABLE();
314: a3 := JTF_NUMBER_TABLE();
315: a4 := JTF_VARCHAR2_TABLE_100();
316: a5 := JTF_NUMBER_TABLE();

Line 313: a2 := JTF_NUMBER_TABLE();

309: begin
310: if t is null or t.count = 0 then
311: a0 := JTF_NUMBER_TABLE();
312: a1 := JTF_NUMBER_TABLE();
313: a2 := JTF_NUMBER_TABLE();
314: a3 := JTF_NUMBER_TABLE();
315: a4 := JTF_VARCHAR2_TABLE_100();
316: a5 := JTF_NUMBER_TABLE();
317: a6 := JTF_VARCHAR2_TABLE_100();

Line 314: a3 := JTF_NUMBER_TABLE();

310: if t is null or t.count = 0 then
311: a0 := JTF_NUMBER_TABLE();
312: a1 := JTF_NUMBER_TABLE();
313: a2 := JTF_NUMBER_TABLE();
314: a3 := JTF_NUMBER_TABLE();
315: a4 := JTF_VARCHAR2_TABLE_100();
316: a5 := JTF_NUMBER_TABLE();
317: a6 := JTF_VARCHAR2_TABLE_100();
318: a7 := JTF_VARCHAR2_TABLE_200();

Line 316: a5 := JTF_NUMBER_TABLE();

312: a1 := JTF_NUMBER_TABLE();
313: a2 := JTF_NUMBER_TABLE();
314: a3 := JTF_NUMBER_TABLE();
315: a4 := JTF_VARCHAR2_TABLE_100();
316: a5 := JTF_NUMBER_TABLE();
317: a6 := JTF_VARCHAR2_TABLE_100();
318: a7 := JTF_VARCHAR2_TABLE_200();
319: a8 := JTF_VARCHAR2_TABLE_200();
320: a9 := JTF_VARCHAR2_TABLE_200();

Line 335: a0 := JTF_NUMBER_TABLE();

331: a20 := JTF_VARCHAR2_TABLE_200();
332: a21 := JTF_VARCHAR2_TABLE_200();
333: a22 := JTF_VARCHAR2_TABLE_100();
334: else
335: a0 := JTF_NUMBER_TABLE();
336: a1 := JTF_NUMBER_TABLE();
337: a2 := JTF_NUMBER_TABLE();
338: a3 := JTF_NUMBER_TABLE();
339: a4 := JTF_VARCHAR2_TABLE_100();

Line 336: a1 := JTF_NUMBER_TABLE();

332: a21 := JTF_VARCHAR2_TABLE_200();
333: a22 := JTF_VARCHAR2_TABLE_100();
334: else
335: a0 := JTF_NUMBER_TABLE();
336: a1 := JTF_NUMBER_TABLE();
337: a2 := JTF_NUMBER_TABLE();
338: a3 := JTF_NUMBER_TABLE();
339: a4 := JTF_VARCHAR2_TABLE_100();
340: a5 := JTF_NUMBER_TABLE();

Line 337: a2 := JTF_NUMBER_TABLE();

333: a22 := JTF_VARCHAR2_TABLE_100();
334: else
335: a0 := JTF_NUMBER_TABLE();
336: a1 := JTF_NUMBER_TABLE();
337: a2 := JTF_NUMBER_TABLE();
338: a3 := JTF_NUMBER_TABLE();
339: a4 := JTF_VARCHAR2_TABLE_100();
340: a5 := JTF_NUMBER_TABLE();
341: a6 := JTF_VARCHAR2_TABLE_100();

Line 338: a3 := JTF_NUMBER_TABLE();

334: else
335: a0 := JTF_NUMBER_TABLE();
336: a1 := JTF_NUMBER_TABLE();
337: a2 := JTF_NUMBER_TABLE();
338: a3 := JTF_NUMBER_TABLE();
339: a4 := JTF_VARCHAR2_TABLE_100();
340: a5 := JTF_NUMBER_TABLE();
341: a6 := JTF_VARCHAR2_TABLE_100();
342: a7 := JTF_VARCHAR2_TABLE_200();

Line 340: a5 := JTF_NUMBER_TABLE();

336: a1 := JTF_NUMBER_TABLE();
337: a2 := JTF_NUMBER_TABLE();
338: a3 := JTF_NUMBER_TABLE();
339: a4 := JTF_VARCHAR2_TABLE_100();
340: a5 := JTF_NUMBER_TABLE();
341: a6 := JTF_VARCHAR2_TABLE_100();
342: a7 := JTF_VARCHAR2_TABLE_200();
343: a8 := JTF_VARCHAR2_TABLE_200();
344: a9 := JTF_VARCHAR2_TABLE_200();

Line 418: procedure rosetta_table_copy_in_p7(t out nocopy ahl_mel_cdl_ata_seqs_pvt.relationship_tbl_type, a0 JTF_NUMBER_TABLE

414: end if;
415: end if;
416: end rosetta_table_copy_out_p5;
417:
418: procedure rosetta_table_copy_in_p7(t out nocopy ahl_mel_cdl_ata_seqs_pvt.relationship_tbl_type, a0 JTF_NUMBER_TABLE
419: , a1 JTF_NUMBER_TABLE
420: , a2 JTF_NUMBER_TABLE
421: , a3 JTF_NUMBER_TABLE
422: , a4 JTF_VARCHAR2_TABLE_100

Line 419: , a1 JTF_NUMBER_TABLE

415: end if;
416: end rosetta_table_copy_out_p5;
417:
418: procedure rosetta_table_copy_in_p7(t out nocopy ahl_mel_cdl_ata_seqs_pvt.relationship_tbl_type, a0 JTF_NUMBER_TABLE
419: , a1 JTF_NUMBER_TABLE
420: , a2 JTF_NUMBER_TABLE
421: , a3 JTF_NUMBER_TABLE
422: , a4 JTF_VARCHAR2_TABLE_100
423: , a5 JTF_VARCHAR2_TABLE_200

Line 420: , a2 JTF_NUMBER_TABLE

416: end rosetta_table_copy_out_p5;
417:
418: procedure rosetta_table_copy_in_p7(t out nocopy ahl_mel_cdl_ata_seqs_pvt.relationship_tbl_type, a0 JTF_NUMBER_TABLE
419: , a1 JTF_NUMBER_TABLE
420: , a2 JTF_NUMBER_TABLE
421: , a3 JTF_NUMBER_TABLE
422: , a4 JTF_VARCHAR2_TABLE_100
423: , a5 JTF_VARCHAR2_TABLE_200
424: , a6 JTF_VARCHAR2_TABLE_200

Line 421: , a3 JTF_NUMBER_TABLE

417:
418: procedure rosetta_table_copy_in_p7(t out nocopy ahl_mel_cdl_ata_seqs_pvt.relationship_tbl_type, a0 JTF_NUMBER_TABLE
419: , a1 JTF_NUMBER_TABLE
420: , a2 JTF_NUMBER_TABLE
421: , a3 JTF_NUMBER_TABLE
422: , a4 JTF_VARCHAR2_TABLE_100
423: , a5 JTF_VARCHAR2_TABLE_200
424: , a6 JTF_VARCHAR2_TABLE_200
425: , a7 JTF_VARCHAR2_TABLE_200

Line 477: procedure rosetta_table_copy_out_p7(t ahl_mel_cdl_ata_seqs_pvt.relationship_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

473: end loop;
474: end if;
475: end if;
476: end rosetta_table_copy_in_p7;
477: procedure rosetta_table_copy_out_p7(t ahl_mel_cdl_ata_seqs_pvt.relationship_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
478: , a1 out nocopy JTF_NUMBER_TABLE
479: , a2 out nocopy JTF_NUMBER_TABLE
480: , a3 out nocopy JTF_NUMBER_TABLE
481: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 478: , a1 out nocopy JTF_NUMBER_TABLE

474: end if;
475: end if;
476: end rosetta_table_copy_in_p7;
477: procedure rosetta_table_copy_out_p7(t ahl_mel_cdl_ata_seqs_pvt.relationship_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
478: , a1 out nocopy JTF_NUMBER_TABLE
479: , a2 out nocopy JTF_NUMBER_TABLE
480: , a3 out nocopy JTF_NUMBER_TABLE
481: , a4 out nocopy JTF_VARCHAR2_TABLE_100
482: , a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 479: , a2 out nocopy JTF_NUMBER_TABLE

475: end if;
476: end rosetta_table_copy_in_p7;
477: procedure rosetta_table_copy_out_p7(t ahl_mel_cdl_ata_seqs_pvt.relationship_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
478: , a1 out nocopy JTF_NUMBER_TABLE
479: , a2 out nocopy JTF_NUMBER_TABLE
480: , a3 out nocopy JTF_NUMBER_TABLE
481: , a4 out nocopy JTF_VARCHAR2_TABLE_100
482: , a5 out nocopy JTF_VARCHAR2_TABLE_200
483: , a6 out nocopy JTF_VARCHAR2_TABLE_200

Line 480: , a3 out nocopy JTF_NUMBER_TABLE

476: end rosetta_table_copy_in_p7;
477: procedure rosetta_table_copy_out_p7(t ahl_mel_cdl_ata_seqs_pvt.relationship_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
478: , a1 out nocopy JTF_NUMBER_TABLE
479: , a2 out nocopy JTF_NUMBER_TABLE
480: , a3 out nocopy JTF_NUMBER_TABLE
481: , a4 out nocopy JTF_VARCHAR2_TABLE_100
482: , a5 out nocopy JTF_VARCHAR2_TABLE_200
483: , a6 out nocopy JTF_VARCHAR2_TABLE_200
484: , a7 out nocopy JTF_VARCHAR2_TABLE_200

Line 502: a0 := JTF_NUMBER_TABLE();

498: ) as
499: ddindx binary_integer; indx binary_integer;
500: begin
501: if t is null or t.count = 0 then
502: a0 := JTF_NUMBER_TABLE();
503: a1 := JTF_NUMBER_TABLE();
504: a2 := JTF_NUMBER_TABLE();
505: a3 := JTF_NUMBER_TABLE();
506: a4 := JTF_VARCHAR2_TABLE_100();

Line 503: a1 := JTF_NUMBER_TABLE();

499: ddindx binary_integer; indx binary_integer;
500: begin
501: if t is null or t.count = 0 then
502: a0 := JTF_NUMBER_TABLE();
503: a1 := JTF_NUMBER_TABLE();
504: a2 := JTF_NUMBER_TABLE();
505: a3 := JTF_NUMBER_TABLE();
506: a4 := JTF_VARCHAR2_TABLE_100();
507: a5 := JTF_VARCHAR2_TABLE_200();

Line 504: a2 := JTF_NUMBER_TABLE();

500: begin
501: if t is null or t.count = 0 then
502: a0 := JTF_NUMBER_TABLE();
503: a1 := JTF_NUMBER_TABLE();
504: a2 := JTF_NUMBER_TABLE();
505: a3 := JTF_NUMBER_TABLE();
506: a4 := JTF_VARCHAR2_TABLE_100();
507: a5 := JTF_VARCHAR2_TABLE_200();
508: a6 := JTF_VARCHAR2_TABLE_200();

Line 505: a3 := JTF_NUMBER_TABLE();

501: if t is null or t.count = 0 then
502: a0 := JTF_NUMBER_TABLE();
503: a1 := JTF_NUMBER_TABLE();
504: a2 := JTF_NUMBER_TABLE();
505: a3 := JTF_NUMBER_TABLE();
506: a4 := JTF_VARCHAR2_TABLE_100();
507: a5 := JTF_VARCHAR2_TABLE_200();
508: a6 := JTF_VARCHAR2_TABLE_200();
509: a7 := JTF_VARCHAR2_TABLE_200();

Line 524: a0 := JTF_NUMBER_TABLE();

520: a18 := JTF_VARCHAR2_TABLE_200();
521: a19 := JTF_VARCHAR2_TABLE_200();
522: a20 := JTF_VARCHAR2_TABLE_100();
523: else
524: a0 := JTF_NUMBER_TABLE();
525: a1 := JTF_NUMBER_TABLE();
526: a2 := JTF_NUMBER_TABLE();
527: a3 := JTF_NUMBER_TABLE();
528: a4 := JTF_VARCHAR2_TABLE_100();

Line 525: a1 := JTF_NUMBER_TABLE();

521: a19 := JTF_VARCHAR2_TABLE_200();
522: a20 := JTF_VARCHAR2_TABLE_100();
523: else
524: a0 := JTF_NUMBER_TABLE();
525: a1 := JTF_NUMBER_TABLE();
526: a2 := JTF_NUMBER_TABLE();
527: a3 := JTF_NUMBER_TABLE();
528: a4 := JTF_VARCHAR2_TABLE_100();
529: a5 := JTF_VARCHAR2_TABLE_200();

Line 526: a2 := JTF_NUMBER_TABLE();

522: a20 := JTF_VARCHAR2_TABLE_100();
523: else
524: a0 := JTF_NUMBER_TABLE();
525: a1 := JTF_NUMBER_TABLE();
526: a2 := JTF_NUMBER_TABLE();
527: a3 := JTF_NUMBER_TABLE();
528: a4 := JTF_VARCHAR2_TABLE_100();
529: a5 := JTF_VARCHAR2_TABLE_200();
530: a6 := JTF_VARCHAR2_TABLE_200();

Line 527: a3 := JTF_NUMBER_TABLE();

523: else
524: a0 := JTF_NUMBER_TABLE();
525: a1 := JTF_NUMBER_TABLE();
526: a2 := JTF_NUMBER_TABLE();
527: a3 := JTF_NUMBER_TABLE();
528: a4 := JTF_VARCHAR2_TABLE_100();
529: a5 := JTF_VARCHAR2_TABLE_200();
530: a6 := JTF_VARCHAR2_TABLE_200();
531: a7 := JTF_VARCHAR2_TABLE_200();

Line 610: , p9_a0 in out nocopy JTF_NUMBER_TABLE

606: , p_module_type VARCHAR2
607: , x_return_status out nocopy VARCHAR2
608: , x_msg_count out nocopy NUMBER
609: , x_msg_data out nocopy VARCHAR2
610: , p9_a0 in out nocopy JTF_NUMBER_TABLE
611: , p9_a1 in out nocopy JTF_NUMBER_TABLE
612: , p9_a2 in out nocopy JTF_NUMBER_TABLE
613: , p9_a3 in out nocopy JTF_NUMBER_TABLE
614: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100

Line 611: , p9_a1 in out nocopy JTF_NUMBER_TABLE

607: , x_return_status out nocopy VARCHAR2
608: , x_msg_count out nocopy NUMBER
609: , x_msg_data out nocopy VARCHAR2
610: , p9_a0 in out nocopy JTF_NUMBER_TABLE
611: , p9_a1 in out nocopy JTF_NUMBER_TABLE
612: , p9_a2 in out nocopy JTF_NUMBER_TABLE
613: , p9_a3 in out nocopy JTF_NUMBER_TABLE
614: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
615: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100

Line 612: , p9_a2 in out nocopy JTF_NUMBER_TABLE

608: , x_msg_count out nocopy NUMBER
609: , x_msg_data out nocopy VARCHAR2
610: , p9_a0 in out nocopy JTF_NUMBER_TABLE
611: , p9_a1 in out nocopy JTF_NUMBER_TABLE
612: , p9_a2 in out nocopy JTF_NUMBER_TABLE
613: , p9_a3 in out nocopy JTF_NUMBER_TABLE
614: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
615: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
616: , p9_a6 in out nocopy JTF_NUMBER_TABLE

Line 613: , p9_a3 in out nocopy JTF_NUMBER_TABLE

609: , x_msg_data out nocopy VARCHAR2
610: , p9_a0 in out nocopy JTF_NUMBER_TABLE
611: , p9_a1 in out nocopy JTF_NUMBER_TABLE
612: , p9_a2 in out nocopy JTF_NUMBER_TABLE
613: , p9_a3 in out nocopy JTF_NUMBER_TABLE
614: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
615: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
616: , p9_a6 in out nocopy JTF_NUMBER_TABLE
617: , p9_a7 in out nocopy JTF_NUMBER_TABLE

Line 616: , p9_a6 in out nocopy JTF_NUMBER_TABLE

612: , p9_a2 in out nocopy JTF_NUMBER_TABLE
613: , p9_a3 in out nocopy JTF_NUMBER_TABLE
614: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
615: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
616: , p9_a6 in out nocopy JTF_NUMBER_TABLE
617: , p9_a7 in out nocopy JTF_NUMBER_TABLE
618: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
619: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_200
620: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_200

Line 617: , p9_a7 in out nocopy JTF_NUMBER_TABLE

613: , p9_a3 in out nocopy JTF_NUMBER_TABLE
614: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
615: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_100
616: , p9_a6 in out nocopy JTF_NUMBER_TABLE
617: , p9_a7 in out nocopy JTF_NUMBER_TABLE
618: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
619: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_200
620: , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_200
621: , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_200

Line 741: , p9_a0 in out nocopy JTF_NUMBER_TABLE

737: , p_module_type VARCHAR2
738: , x_return_status out nocopy VARCHAR2
739: , x_msg_count out nocopy NUMBER
740: , x_msg_data out nocopy VARCHAR2
741: , p9_a0 in out nocopy JTF_NUMBER_TABLE
742: , p9_a1 in out nocopy JTF_NUMBER_TABLE
743: , p9_a2 in out nocopy JTF_NUMBER_TABLE
744: , p9_a3 in out nocopy JTF_NUMBER_TABLE
745: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100

Line 742: , p9_a1 in out nocopy JTF_NUMBER_TABLE

738: , x_return_status out nocopy VARCHAR2
739: , x_msg_count out nocopy NUMBER
740: , x_msg_data out nocopy VARCHAR2
741: , p9_a0 in out nocopy JTF_NUMBER_TABLE
742: , p9_a1 in out nocopy JTF_NUMBER_TABLE
743: , p9_a2 in out nocopy JTF_NUMBER_TABLE
744: , p9_a3 in out nocopy JTF_NUMBER_TABLE
745: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
746: , p9_a5 in out nocopy JTF_NUMBER_TABLE

Line 743: , p9_a2 in out nocopy JTF_NUMBER_TABLE

739: , x_msg_count out nocopy NUMBER
740: , x_msg_data out nocopy VARCHAR2
741: , p9_a0 in out nocopy JTF_NUMBER_TABLE
742: , p9_a1 in out nocopy JTF_NUMBER_TABLE
743: , p9_a2 in out nocopy JTF_NUMBER_TABLE
744: , p9_a3 in out nocopy JTF_NUMBER_TABLE
745: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
746: , p9_a5 in out nocopy JTF_NUMBER_TABLE
747: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 744: , p9_a3 in out nocopy JTF_NUMBER_TABLE

740: , x_msg_data out nocopy VARCHAR2
741: , p9_a0 in out nocopy JTF_NUMBER_TABLE
742: , p9_a1 in out nocopy JTF_NUMBER_TABLE
743: , p9_a2 in out nocopy JTF_NUMBER_TABLE
744: , p9_a3 in out nocopy JTF_NUMBER_TABLE
745: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
746: , p9_a5 in out nocopy JTF_NUMBER_TABLE
747: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
748: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_200

Line 746: , p9_a5 in out nocopy JTF_NUMBER_TABLE

742: , p9_a1 in out nocopy JTF_NUMBER_TABLE
743: , p9_a2 in out nocopy JTF_NUMBER_TABLE
744: , p9_a3 in out nocopy JTF_NUMBER_TABLE
745: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
746: , p9_a5 in out nocopy JTF_NUMBER_TABLE
747: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_100
748: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_200
749: , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_200
750: , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_200

Line 863: , p9_a0 in out nocopy JTF_NUMBER_TABLE

859: , p_module_type VARCHAR2
860: , x_return_status out nocopy VARCHAR2
861: , x_msg_count out nocopy NUMBER
862: , x_msg_data out nocopy VARCHAR2
863: , p9_a0 in out nocopy JTF_NUMBER_TABLE
864: , p9_a1 in out nocopy JTF_NUMBER_TABLE
865: , p9_a2 in out nocopy JTF_NUMBER_TABLE
866: , p9_a3 in out nocopy JTF_NUMBER_TABLE
867: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100

Line 864: , p9_a1 in out nocopy JTF_NUMBER_TABLE

860: , x_return_status out nocopy VARCHAR2
861: , x_msg_count out nocopy NUMBER
862: , x_msg_data out nocopy VARCHAR2
863: , p9_a0 in out nocopy JTF_NUMBER_TABLE
864: , p9_a1 in out nocopy JTF_NUMBER_TABLE
865: , p9_a2 in out nocopy JTF_NUMBER_TABLE
866: , p9_a3 in out nocopy JTF_NUMBER_TABLE
867: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
868: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_200

Line 865: , p9_a2 in out nocopy JTF_NUMBER_TABLE

861: , x_msg_count out nocopy NUMBER
862: , x_msg_data out nocopy VARCHAR2
863: , p9_a0 in out nocopy JTF_NUMBER_TABLE
864: , p9_a1 in out nocopy JTF_NUMBER_TABLE
865: , p9_a2 in out nocopy JTF_NUMBER_TABLE
866: , p9_a3 in out nocopy JTF_NUMBER_TABLE
867: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
868: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_200
869: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_200

Line 866: , p9_a3 in out nocopy JTF_NUMBER_TABLE

862: , x_msg_data out nocopy VARCHAR2
863: , p9_a0 in out nocopy JTF_NUMBER_TABLE
864: , p9_a1 in out nocopy JTF_NUMBER_TABLE
865: , p9_a2 in out nocopy JTF_NUMBER_TABLE
866: , p9_a3 in out nocopy JTF_NUMBER_TABLE
867: , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
868: , p9_a5 in out nocopy JTF_VARCHAR2_TABLE_200
869: , p9_a6 in out nocopy JTF_VARCHAR2_TABLE_200
870: , p9_a7 in out nocopy JTF_VARCHAR2_TABLE_200