70: end if;
71: end if;
72: end rosetta_table_copy_out_p1;
73:
74: procedure rosetta_table_copy_in_p2(t out nocopy jtf_amv_item_pub.char_tab_type, a0 JTF_VARCHAR2_TABLE_200) as
75: ddindx binary_integer; indx binary_integer;
76: begin
77: if a0 is null then
78: t := null;
94: end loop;
95: end if;
96: end if;
97: end rosetta_table_copy_in_p2;
98: procedure rosetta_table_copy_out_p2(t jtf_amv_item_pub.char_tab_type, a0 out nocopy JTF_VARCHAR2_TABLE_200) as
99: ddindx binary_integer; indx binary_integer;
100: begin
101: if t is null then
102: a0 := null;
100: begin
101: if t is null then
102: a0 := null;
103: elsif t.count = 0 then
104: a0 := JTF_VARCHAR2_TABLE_200();
105: else
106: a0 := JTF_VARCHAR2_TABLE_200();
107: if t.count > 0 then
108: a0.extend(t.count);
102: a0 := null;
103: elsif t.count = 0 then
104: a0 := JTF_VARCHAR2_TABLE_200();
105: else
106: a0 := JTF_VARCHAR2_TABLE_200();
107: if t.count > 0 then
108: a0.extend(t.count);
109: ddindx := t.first;
110: indx := 1;
409: , x_return_status out nocopy VARCHAR2
410: , x_msg_count out nocopy NUMBER
411: , x_msg_data out nocopy VARCHAR2
412: , p_item_id NUMBER
413: , p_keyword_tab JTF_VARCHAR2_TABLE_200
414: )
415:
416: as
417: ddp_keyword_tab jtf_amv_item_pub.char_tab_type;
454: , x_return_status out nocopy VARCHAR2
455: , x_msg_count out nocopy NUMBER
456: , x_msg_data out nocopy VARCHAR2
457: , p_item_id NUMBER
458: , p_keyword_tab JTF_VARCHAR2_TABLE_200
459: )
460:
461: as
462: ddp_keyword_tab jtf_amv_item_pub.char_tab_type;
499: , x_return_status out nocopy VARCHAR2
500: , x_msg_count out nocopy NUMBER
501: , x_msg_data out nocopy VARCHAR2
502: , p_item_id NUMBER
503: , p_keyword_tab JTF_VARCHAR2_TABLE_200
504: )
505:
506: as
507: ddp_keyword_tab jtf_amv_item_pub.char_tab_type;
543: , x_return_status out nocopy VARCHAR2
544: , x_msg_count out nocopy NUMBER
545: , x_msg_data out nocopy VARCHAR2
546: , p_item_id NUMBER
547: , x_keyword_tab out nocopy JTF_VARCHAR2_TABLE_200
548: )
549:
550: as
551: ddx_keyword_tab jtf_amv_item_pub.char_tab_type;
585: , x_return_status out nocopy VARCHAR2
586: , x_msg_count out nocopy NUMBER
587: , x_msg_data out nocopy VARCHAR2
588: , p_item_id NUMBER
589: , p_author_tab JTF_VARCHAR2_TABLE_200
590: )
591:
592: as
593: ddp_author_tab jtf_amv_item_pub.char_tab_type;
630: , x_return_status out nocopy VARCHAR2
631: , x_msg_count out nocopy NUMBER
632: , x_msg_data out nocopy VARCHAR2
633: , p_item_id NUMBER
634: , p_author_tab JTF_VARCHAR2_TABLE_200
635: )
636:
637: as
638: ddp_author_tab jtf_amv_item_pub.char_tab_type;
675: , x_return_status out nocopy VARCHAR2
676: , x_msg_count out nocopy NUMBER
677: , x_msg_data out nocopy VARCHAR2
678: , p_item_id NUMBER
679: , p_author_tab JTF_VARCHAR2_TABLE_200
680: )
681:
682: as
683: ddp_author_tab jtf_amv_item_pub.char_tab_type;
719: , x_return_status out nocopy VARCHAR2
720: , x_msg_count out nocopy NUMBER
721: , x_msg_data out nocopy VARCHAR2
722: , p_item_id NUMBER
723: , x_author_tab out nocopy JTF_VARCHAR2_TABLE_200
724: )
725:
726: as
727: ddx_author_tab jtf_amv_item_pub.char_tab_type;