1: package body okl_am_invoices_pvt_w as
2: /* $Header: OKLEAMIB.pls 120.5 2008/06/16 18:34:13 asahoo ship $ */
3: procedure rosetta_table_copy_in_p5(t out nocopy okl_am_invoices_pvt.ariv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_VARCHAR2_TABLE_2000
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_VARCHAR2_TABLE_2000
8: , a5 JTF_NUMBER_TABLE
1: package body okl_am_invoices_pvt_w as
2: /* $Header: OKLEAMIB.pls 120.5 2008/06/16 18:34:13 asahoo ship $ */
3: procedure rosetta_table_copy_in_p5(t out nocopy okl_am_invoices_pvt.ariv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_VARCHAR2_TABLE_2000
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_VARCHAR2_TABLE_2000
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
2: /* $Header: OKLEAMIB.pls 120.5 2008/06/16 18:34:13 asahoo ship $ */
3: procedure rosetta_table_copy_in_p5(t out nocopy okl_am_invoices_pvt.ariv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_VARCHAR2_TABLE_2000
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_VARCHAR2_TABLE_2000
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
3: procedure rosetta_table_copy_in_p5(t out nocopy okl_am_invoices_pvt.ariv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_200
5: , a2 JTF_VARCHAR2_TABLE_2000
6: , a3 JTF_VARCHAR2_TABLE_2000
7: , a4 JTF_VARCHAR2_TABLE_2000
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_DATE_TABLE
41: end if;
42: end if;
43: end rosetta_table_copy_in_p5;
44: procedure rosetta_table_copy_out_p5(t okl_am_invoices_pvt.ariv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_VARCHAR2_TABLE_200
46: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
47: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
48: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
49: , a5 out nocopy JTF_NUMBER_TABLE
42: end if;
43: end rosetta_table_copy_in_p5;
44: procedure rosetta_table_copy_out_p5(t okl_am_invoices_pvt.ariv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_VARCHAR2_TABLE_200
46: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
47: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
48: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
49: , a5 out nocopy JTF_NUMBER_TABLE
50: , a6 out nocopy JTF_DATE_TABLE
43: end rosetta_table_copy_in_p5;
44: procedure rosetta_table_copy_out_p5(t okl_am_invoices_pvt.ariv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_VARCHAR2_TABLE_200
46: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
47: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
48: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
49: , a5 out nocopy JTF_NUMBER_TABLE
50: , a6 out nocopy JTF_DATE_TABLE
51: , a7 out nocopy JTF_NUMBER_TABLE
44: procedure rosetta_table_copy_out_p5(t okl_am_invoices_pvt.ariv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_VARCHAR2_TABLE_200
46: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
47: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
48: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
49: , a5 out nocopy JTF_NUMBER_TABLE
50: , a6 out nocopy JTF_DATE_TABLE
51: , a7 out nocopy JTF_NUMBER_TABLE
52: , a8 out nocopy JTF_DATE_TABLE
57: ddindx binary_integer; indx binary_integer;
58: begin
59: if t is null or t.count = 0 then
60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_VARCHAR2_TABLE_200();
62: a2 := JTF_VARCHAR2_TABLE_2000();
63: a3 := JTF_VARCHAR2_TABLE_2000();
64: a4 := JTF_VARCHAR2_TABLE_2000();
65: a5 := JTF_NUMBER_TABLE();
58: begin
59: if t is null or t.count = 0 then
60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_VARCHAR2_TABLE_200();
62: a2 := JTF_VARCHAR2_TABLE_2000();
63: a3 := JTF_VARCHAR2_TABLE_2000();
64: a4 := JTF_VARCHAR2_TABLE_2000();
65: a5 := JTF_NUMBER_TABLE();
66: a6 := JTF_DATE_TABLE();
59: if t is null or t.count = 0 then
60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_VARCHAR2_TABLE_200();
62: a2 := JTF_VARCHAR2_TABLE_2000();
63: a3 := JTF_VARCHAR2_TABLE_2000();
64: a4 := JTF_VARCHAR2_TABLE_2000();
65: a5 := JTF_NUMBER_TABLE();
66: a6 := JTF_DATE_TABLE();
67: a7 := JTF_NUMBER_TABLE();
60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_VARCHAR2_TABLE_200();
62: a2 := JTF_VARCHAR2_TABLE_2000();
63: a3 := JTF_VARCHAR2_TABLE_2000();
64: a4 := JTF_VARCHAR2_TABLE_2000();
65: a5 := JTF_NUMBER_TABLE();
66: a6 := JTF_DATE_TABLE();
67: a7 := JTF_NUMBER_TABLE();
68: a8 := JTF_DATE_TABLE();
70: a10 := JTF_NUMBER_TABLE();
71: a11 := JTF_NUMBER_TABLE();
72: else
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_VARCHAR2_TABLE_200();
75: a2 := JTF_VARCHAR2_TABLE_2000();
76: a3 := JTF_VARCHAR2_TABLE_2000();
77: a4 := JTF_VARCHAR2_TABLE_2000();
78: a5 := JTF_NUMBER_TABLE();
71: a11 := JTF_NUMBER_TABLE();
72: else
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_VARCHAR2_TABLE_200();
75: a2 := JTF_VARCHAR2_TABLE_2000();
76: a3 := JTF_VARCHAR2_TABLE_2000();
77: a4 := JTF_VARCHAR2_TABLE_2000();
78: a5 := JTF_NUMBER_TABLE();
79: a6 := JTF_DATE_TABLE();
72: else
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_VARCHAR2_TABLE_200();
75: a2 := JTF_VARCHAR2_TABLE_2000();
76: a3 := JTF_VARCHAR2_TABLE_2000();
77: a4 := JTF_VARCHAR2_TABLE_2000();
78: a5 := JTF_NUMBER_TABLE();
79: a6 := JTF_DATE_TABLE();
80: a7 := JTF_NUMBER_TABLE();
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_VARCHAR2_TABLE_200();
75: a2 := JTF_VARCHAR2_TABLE_2000();
76: a3 := JTF_VARCHAR2_TABLE_2000();
77: a4 := JTF_VARCHAR2_TABLE_2000();
78: a5 := JTF_NUMBER_TABLE();
79: a6 := JTF_DATE_TABLE();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_DATE_TABLE();
520: , x_msg_count out nocopy NUMBER
521: , x_msg_data out nocopy VARCHAR2
522: , x_return_status out nocopy VARCHAR2
523: , p5_a0 JTF_NUMBER_TABLE
524: , p5_a1 JTF_VARCHAR2_TABLE_200
525: , p5_a2 JTF_VARCHAR2_TABLE_2000
526: , p5_a3 JTF_VARCHAR2_TABLE_2000
527: , p5_a4 JTF_VARCHAR2_TABLE_2000
528: , p5_a5 JTF_NUMBER_TABLE
521: , x_msg_data out nocopy VARCHAR2
522: , x_return_status out nocopy VARCHAR2
523: , p5_a0 JTF_NUMBER_TABLE
524: , p5_a1 JTF_VARCHAR2_TABLE_200
525: , p5_a2 JTF_VARCHAR2_TABLE_2000
526: , p5_a3 JTF_VARCHAR2_TABLE_2000
527: , p5_a4 JTF_VARCHAR2_TABLE_2000
528: , p5_a5 JTF_NUMBER_TABLE
529: , p5_a6 JTF_DATE_TABLE
522: , x_return_status out nocopy VARCHAR2
523: , p5_a0 JTF_NUMBER_TABLE
524: , p5_a1 JTF_VARCHAR2_TABLE_200
525: , p5_a2 JTF_VARCHAR2_TABLE_2000
526: , p5_a3 JTF_VARCHAR2_TABLE_2000
527: , p5_a4 JTF_VARCHAR2_TABLE_2000
528: , p5_a5 JTF_NUMBER_TABLE
529: , p5_a6 JTF_DATE_TABLE
530: , p5_a7 JTF_NUMBER_TABLE
523: , p5_a0 JTF_NUMBER_TABLE
524: , p5_a1 JTF_VARCHAR2_TABLE_200
525: , p5_a2 JTF_VARCHAR2_TABLE_2000
526: , p5_a3 JTF_VARCHAR2_TABLE_2000
527: , p5_a4 JTF_VARCHAR2_TABLE_2000
528: , p5_a5 JTF_NUMBER_TABLE
529: , p5_a6 JTF_DATE_TABLE
530: , p5_a7 JTF_NUMBER_TABLE
531: , p5_a8 JTF_DATE_TABLE
556: , p6_a21 out nocopy JTF_NUMBER_TABLE
557: , p6_a22 out nocopy JTF_NUMBER_TABLE
558: , p6_a23 out nocopy JTF_DATE_TABLE
559: , p6_a24 out nocopy JTF_NUMBER_TABLE
560: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_2000
561: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
562: , p6_a27 out nocopy JTF_NUMBER_TABLE
563: , p6_a28 out nocopy JTF_NUMBER_TABLE
564: , p6_a29 out nocopy JTF_NUMBER_TABLE
589: , p6_a54 out nocopy JTF_NUMBER_TABLE
590: , p6_a55 out nocopy JTF_DATE_TABLE
591: , p6_a56 out nocopy JTF_NUMBER_TABLE
592: , p6_a57 out nocopy JTF_NUMBER_TABLE
593: , p6_a58 out nocopy JTF_VARCHAR2_TABLE_200
594: , p6_a59 out nocopy JTF_VARCHAR2_TABLE_400
595: , p6_a60 out nocopy JTF_VARCHAR2_TABLE_100
596: , p6_a61 out nocopy JTF_NUMBER_TABLE
597: , p6_a62 out nocopy JTF_VARCHAR2_TABLE_100
758: , p6_a21 out nocopy JTF_NUMBER_TABLE
759: , p6_a22 out nocopy JTF_NUMBER_TABLE
760: , p6_a23 out nocopy JTF_DATE_TABLE
761: , p6_a24 out nocopy JTF_NUMBER_TABLE
762: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_2000
763: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
764: , p6_a27 out nocopy JTF_NUMBER_TABLE
765: , p6_a28 out nocopy JTF_NUMBER_TABLE
766: , p6_a29 out nocopy JTF_NUMBER_TABLE
791: , p6_a54 out nocopy JTF_NUMBER_TABLE
792: , p6_a55 out nocopy JTF_DATE_TABLE
793: , p6_a56 out nocopy JTF_NUMBER_TABLE
794: , p6_a57 out nocopy JTF_NUMBER_TABLE
795: , p6_a58 out nocopy JTF_VARCHAR2_TABLE_200
796: , p6_a59 out nocopy JTF_VARCHAR2_TABLE_400
797: , p6_a60 out nocopy JTF_VARCHAR2_TABLE_100
798: , p6_a61 out nocopy JTF_NUMBER_TABLE
799: , p6_a62 out nocopy JTF_VARCHAR2_TABLE_100
946: , p6_a21 out nocopy JTF_NUMBER_TABLE
947: , p6_a22 out nocopy JTF_NUMBER_TABLE
948: , p6_a23 out nocopy JTF_DATE_TABLE
949: , p6_a24 out nocopy JTF_NUMBER_TABLE
950: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_2000
951: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_300
952: , p6_a27 out nocopy JTF_NUMBER_TABLE
953: , p6_a28 out nocopy JTF_NUMBER_TABLE
954: , p6_a29 out nocopy JTF_NUMBER_TABLE
979: , p6_a54 out nocopy JTF_NUMBER_TABLE
980: , p6_a55 out nocopy JTF_DATE_TABLE
981: , p6_a56 out nocopy JTF_NUMBER_TABLE
982: , p6_a57 out nocopy JTF_NUMBER_TABLE
983: , p6_a58 out nocopy JTF_VARCHAR2_TABLE_200
984: , p6_a59 out nocopy JTF_VARCHAR2_TABLE_400
985: , p6_a60 out nocopy JTF_VARCHAR2_TABLE_100
986: , p6_a61 out nocopy JTF_NUMBER_TABLE
987: , p6_a62 out nocopy JTF_VARCHAR2_TABLE_100
1137: , p9_a21 out nocopy JTF_NUMBER_TABLE
1138: , p9_a22 out nocopy JTF_NUMBER_TABLE
1139: , p9_a23 out nocopy JTF_DATE_TABLE
1140: , p9_a24 out nocopy JTF_NUMBER_TABLE
1141: , p9_a25 out nocopy JTF_VARCHAR2_TABLE_2000
1142: , p9_a26 out nocopy JTF_VARCHAR2_TABLE_300
1143: , p9_a27 out nocopy JTF_NUMBER_TABLE
1144: , p9_a28 out nocopy JTF_NUMBER_TABLE
1145: , p9_a29 out nocopy JTF_NUMBER_TABLE
1170: , p9_a54 out nocopy JTF_NUMBER_TABLE
1171: , p9_a55 out nocopy JTF_DATE_TABLE
1172: , p9_a56 out nocopy JTF_NUMBER_TABLE
1173: , p9_a57 out nocopy JTF_NUMBER_TABLE
1174: , p9_a58 out nocopy JTF_VARCHAR2_TABLE_200
1175: , p9_a59 out nocopy JTF_VARCHAR2_TABLE_400
1176: , p9_a60 out nocopy JTF_VARCHAR2_TABLE_100
1177: , p9_a61 out nocopy JTF_NUMBER_TABLE
1178: , p9_a62 out nocopy JTF_VARCHAR2_TABLE_100