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
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
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
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
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
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
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
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
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
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
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
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
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();
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();
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();
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();
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();
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();
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();
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();
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();
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();
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();
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();
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
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
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
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
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
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
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
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
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
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
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();
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();
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();
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();
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();
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();
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();
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();
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();
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();
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
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
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
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
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
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
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
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
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();
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();
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();
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();
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();
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();
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();
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();
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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