1: package body okl_receipts_pvt_w as
2: /* $Header: OKLERCTB.pls 120.8 2008/05/14 11:22:38 sosharma noship $ */
3: procedure rosetta_table_copy_in_p14(t out nocopy okl_receipts_pvt.appl_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
1: package body okl_receipts_pvt_w as
2: /* $Header: OKLERCTB.pls 120.8 2008/05/14 11:22:38 sosharma noship $ */
3: procedure rosetta_table_copy_in_p14(t out nocopy okl_receipts_pvt.appl_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
1: package body okl_receipts_pvt_w as
2: /* $Header: OKLERCTB.pls 120.8 2008/05/14 11:22:38 sosharma noship $ */
3: procedure rosetta_table_copy_in_p14(t out nocopy okl_receipts_pvt.appl_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
2: /* $Header: OKLERCTB.pls 120.8 2008/05/14 11:22:38 sosharma noship $ */
3: procedure rosetta_table_copy_in_p14(t out nocopy okl_receipts_pvt.appl_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
3: procedure rosetta_table_copy_in_p14(t out nocopy okl_receipts_pvt.appl_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: ) as
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: ) as
16: ddindx binary_integer; indx binary_integer;
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: ) as
16: ddindx binary_integer; indx binary_integer;
17: begin
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: ) as
16: ddindx binary_integer; indx binary_integer;
17: begin
18: if a0 is not null and a0.count > 0 then
40: end loop;
41: end if;
42: end if;
43: end rosetta_table_copy_in_p14;
44: procedure rosetta_table_copy_out_p14(t okl_receipts_pvt.appl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_NUMBER_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_NUMBER_TABLE
41: end if;
42: end if;
43: end rosetta_table_copy_in_p14;
44: procedure rosetta_table_copy_out_p14(t okl_receipts_pvt.appl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_NUMBER_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_NUMBER_TABLE
49: , a5 out nocopy JTF_VARCHAR2_TABLE_100
42: end if;
43: end rosetta_table_copy_in_p14;
44: procedure rosetta_table_copy_out_p14(t okl_receipts_pvt.appl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_NUMBER_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_NUMBER_TABLE
49: , a5 out nocopy JTF_VARCHAR2_TABLE_100
50: , a6 out nocopy JTF_NUMBER_TABLE
43: end rosetta_table_copy_in_p14;
44: procedure rosetta_table_copy_out_p14(t okl_receipts_pvt.appl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_NUMBER_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_NUMBER_TABLE
49: , a5 out nocopy JTF_VARCHAR2_TABLE_100
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_DATE_TABLE
44: procedure rosetta_table_copy_out_p14(t okl_receipts_pvt.appl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_NUMBER_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_NUMBER_TABLE
49: , a5 out nocopy JTF_VARCHAR2_TABLE_100
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_DATE_TABLE
52: , a8 out nocopy JTF_NUMBER_TABLE
46: , a2 out nocopy JTF_NUMBER_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_NUMBER_TABLE
49: , a5 out nocopy JTF_VARCHAR2_TABLE_100
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_DATE_TABLE
52: , a8 out nocopy JTF_NUMBER_TABLE
53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_NUMBER_TABLE
49: , a5 out nocopy JTF_VARCHAR2_TABLE_100
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_DATE_TABLE
52: , a8 out nocopy JTF_NUMBER_TABLE
53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_NUMBER_TABLE
55: , a11 out nocopy JTF_NUMBER_TABLE
56: ) as
49: , a5 out nocopy JTF_VARCHAR2_TABLE_100
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_DATE_TABLE
52: , a8 out nocopy JTF_NUMBER_TABLE
53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_NUMBER_TABLE
55: , a11 out nocopy JTF_NUMBER_TABLE
56: ) as
57: ddindx binary_integer; indx binary_integer;
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_DATE_TABLE
52: , a8 out nocopy JTF_NUMBER_TABLE
53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_NUMBER_TABLE
55: , a11 out nocopy JTF_NUMBER_TABLE
56: ) as
57: ddindx binary_integer; indx binary_integer;
58: begin
51: , a7 out nocopy JTF_DATE_TABLE
52: , a8 out nocopy JTF_NUMBER_TABLE
53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_NUMBER_TABLE
55: , a11 out nocopy JTF_NUMBER_TABLE
56: ) as
57: ddindx binary_integer; indx binary_integer;
58: begin
59: if t is null or t.count = 0 then
56: ) as
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_NUMBER_TABLE();
62: a2 := JTF_NUMBER_TABLE();
63: a3 := JTF_NUMBER_TABLE();
64: a4 := JTF_NUMBER_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_NUMBER_TABLE();
62: a2 := JTF_NUMBER_TABLE();
63: a3 := JTF_NUMBER_TABLE();
64: a4 := JTF_NUMBER_TABLE();
65: a5 := JTF_VARCHAR2_TABLE_100();
58: begin
59: if t is null or t.count = 0 then
60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_NUMBER_TABLE();
62: a2 := JTF_NUMBER_TABLE();
63: a3 := JTF_NUMBER_TABLE();
64: a4 := JTF_NUMBER_TABLE();
65: a5 := JTF_VARCHAR2_TABLE_100();
66: a6 := JTF_NUMBER_TABLE();
59: if t is null or t.count = 0 then
60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_NUMBER_TABLE();
62: a2 := JTF_NUMBER_TABLE();
63: a3 := JTF_NUMBER_TABLE();
64: a4 := JTF_NUMBER_TABLE();
65: a5 := JTF_VARCHAR2_TABLE_100();
66: a6 := JTF_NUMBER_TABLE();
67: a7 := JTF_DATE_TABLE();
60: a0 := JTF_NUMBER_TABLE();
61: a1 := JTF_NUMBER_TABLE();
62: a2 := JTF_NUMBER_TABLE();
63: a3 := JTF_NUMBER_TABLE();
64: a4 := JTF_NUMBER_TABLE();
65: a5 := JTF_VARCHAR2_TABLE_100();
66: a6 := JTF_NUMBER_TABLE();
67: a7 := JTF_DATE_TABLE();
68: a8 := JTF_NUMBER_TABLE();
62: a2 := JTF_NUMBER_TABLE();
63: a3 := JTF_NUMBER_TABLE();
64: a4 := JTF_NUMBER_TABLE();
65: a5 := JTF_VARCHAR2_TABLE_100();
66: a6 := JTF_NUMBER_TABLE();
67: a7 := JTF_DATE_TABLE();
68: a8 := JTF_NUMBER_TABLE();
69: a9 := JTF_NUMBER_TABLE();
70: a10 := JTF_NUMBER_TABLE();
64: a4 := JTF_NUMBER_TABLE();
65: a5 := JTF_VARCHAR2_TABLE_100();
66: a6 := JTF_NUMBER_TABLE();
67: a7 := JTF_DATE_TABLE();
68: a8 := JTF_NUMBER_TABLE();
69: a9 := JTF_NUMBER_TABLE();
70: a10 := JTF_NUMBER_TABLE();
71: a11 := JTF_NUMBER_TABLE();
72: else
65: a5 := JTF_VARCHAR2_TABLE_100();
66: a6 := JTF_NUMBER_TABLE();
67: a7 := JTF_DATE_TABLE();
68: a8 := JTF_NUMBER_TABLE();
69: a9 := JTF_NUMBER_TABLE();
70: a10 := JTF_NUMBER_TABLE();
71: a11 := JTF_NUMBER_TABLE();
72: else
73: a0 := JTF_NUMBER_TABLE();
66: a6 := JTF_NUMBER_TABLE();
67: a7 := JTF_DATE_TABLE();
68: a8 := JTF_NUMBER_TABLE();
69: a9 := JTF_NUMBER_TABLE();
70: a10 := JTF_NUMBER_TABLE();
71: a11 := JTF_NUMBER_TABLE();
72: else
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
67: a7 := JTF_DATE_TABLE();
68: a8 := JTF_NUMBER_TABLE();
69: a9 := JTF_NUMBER_TABLE();
70: a10 := JTF_NUMBER_TABLE();
71: a11 := JTF_NUMBER_TABLE();
72: else
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_NUMBER_TABLE();
69: a9 := JTF_NUMBER_TABLE();
70: a10 := JTF_NUMBER_TABLE();
71: a11 := JTF_NUMBER_TABLE();
72: else
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_NUMBER_TABLE();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_NUMBER_TABLE();
70: a10 := JTF_NUMBER_TABLE();
71: a11 := JTF_NUMBER_TABLE();
72: else
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_NUMBER_TABLE();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_NUMBER_TABLE();
78: a5 := JTF_VARCHAR2_TABLE_100();
71: a11 := JTF_NUMBER_TABLE();
72: else
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_NUMBER_TABLE();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_NUMBER_TABLE();
78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_NUMBER_TABLE();
72: else
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_NUMBER_TABLE();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_NUMBER_TABLE();
78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_DATE_TABLE();
73: a0 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_NUMBER_TABLE();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_NUMBER_TABLE();
78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_DATE_TABLE();
81: a8 := JTF_NUMBER_TABLE();
75: a2 := JTF_NUMBER_TABLE();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_NUMBER_TABLE();
78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_DATE_TABLE();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_NUMBER_TABLE();
83: a10 := JTF_NUMBER_TABLE();
77: a4 := JTF_NUMBER_TABLE();
78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_DATE_TABLE();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_NUMBER_TABLE();
83: a10 := JTF_NUMBER_TABLE();
84: a11 := JTF_NUMBER_TABLE();
85: if t.count > 0 then
78: a5 := JTF_VARCHAR2_TABLE_100();
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_DATE_TABLE();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_NUMBER_TABLE();
83: a10 := JTF_NUMBER_TABLE();
84: a11 := JTF_NUMBER_TABLE();
85: if t.count > 0 then
86: a0.extend(t.count);
79: a6 := JTF_NUMBER_TABLE();
80: a7 := JTF_DATE_TABLE();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_NUMBER_TABLE();
83: a10 := JTF_NUMBER_TABLE();
84: a11 := JTF_NUMBER_TABLE();
85: if t.count > 0 then
86: a0.extend(t.count);
87: a1.extend(t.count);
80: a7 := JTF_DATE_TABLE();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_NUMBER_TABLE();
83: a10 := JTF_NUMBER_TABLE();
84: a11 := JTF_NUMBER_TABLE();
85: if t.count > 0 then
86: a0.extend(t.count);
87: a1.extend(t.count);
88: a2.extend(t.count);
161: , p5_a33 VARCHAR2
162: , p5_a34 VARCHAR2
163: , p5_a35 NUMBER
164: , p5_a36 NUMBER
165: , p6_a0 JTF_NUMBER_TABLE
166: , p6_a1 JTF_NUMBER_TABLE
167: , p6_a2 JTF_NUMBER_TABLE
168: , p6_a3 JTF_NUMBER_TABLE
169: , p6_a4 JTF_NUMBER_TABLE
162: , p5_a34 VARCHAR2
163: , p5_a35 NUMBER
164: , p5_a36 NUMBER
165: , p6_a0 JTF_NUMBER_TABLE
166: , p6_a1 JTF_NUMBER_TABLE
167: , p6_a2 JTF_NUMBER_TABLE
168: , p6_a3 JTF_NUMBER_TABLE
169: , p6_a4 JTF_NUMBER_TABLE
170: , p6_a5 JTF_VARCHAR2_TABLE_100
163: , p5_a35 NUMBER
164: , p5_a36 NUMBER
165: , p6_a0 JTF_NUMBER_TABLE
166: , p6_a1 JTF_NUMBER_TABLE
167: , p6_a2 JTF_NUMBER_TABLE
168: , p6_a3 JTF_NUMBER_TABLE
169: , p6_a4 JTF_NUMBER_TABLE
170: , p6_a5 JTF_VARCHAR2_TABLE_100
171: , p6_a6 JTF_NUMBER_TABLE
164: , p5_a36 NUMBER
165: , p6_a0 JTF_NUMBER_TABLE
166: , p6_a1 JTF_NUMBER_TABLE
167: , p6_a2 JTF_NUMBER_TABLE
168: , p6_a3 JTF_NUMBER_TABLE
169: , p6_a4 JTF_NUMBER_TABLE
170: , p6_a5 JTF_VARCHAR2_TABLE_100
171: , p6_a6 JTF_NUMBER_TABLE
172: , p6_a7 JTF_DATE_TABLE
165: , p6_a0 JTF_NUMBER_TABLE
166: , p6_a1 JTF_NUMBER_TABLE
167: , p6_a2 JTF_NUMBER_TABLE
168: , p6_a3 JTF_NUMBER_TABLE
169: , p6_a4 JTF_NUMBER_TABLE
170: , p6_a5 JTF_VARCHAR2_TABLE_100
171: , p6_a6 JTF_NUMBER_TABLE
172: , p6_a7 JTF_DATE_TABLE
173: , p6_a8 JTF_NUMBER_TABLE
167: , p6_a2 JTF_NUMBER_TABLE
168: , p6_a3 JTF_NUMBER_TABLE
169: , p6_a4 JTF_NUMBER_TABLE
170: , p6_a5 JTF_VARCHAR2_TABLE_100
171: , p6_a6 JTF_NUMBER_TABLE
172: , p6_a7 JTF_DATE_TABLE
173: , p6_a8 JTF_NUMBER_TABLE
174: , p6_a9 JTF_NUMBER_TABLE
175: , p6_a10 JTF_NUMBER_TABLE
169: , p6_a4 JTF_NUMBER_TABLE
170: , p6_a5 JTF_VARCHAR2_TABLE_100
171: , p6_a6 JTF_NUMBER_TABLE
172: , p6_a7 JTF_DATE_TABLE
173: , p6_a8 JTF_NUMBER_TABLE
174: , p6_a9 JTF_NUMBER_TABLE
175: , p6_a10 JTF_NUMBER_TABLE
176: , p6_a11 JTF_NUMBER_TABLE
177: , x_cash_receipt_id out nocopy NUMBER
170: , p6_a5 JTF_VARCHAR2_TABLE_100
171: , p6_a6 JTF_NUMBER_TABLE
172: , p6_a7 JTF_DATE_TABLE
173: , p6_a8 JTF_NUMBER_TABLE
174: , p6_a9 JTF_NUMBER_TABLE
175: , p6_a10 JTF_NUMBER_TABLE
176: , p6_a11 JTF_NUMBER_TABLE
177: , x_cash_receipt_id out nocopy NUMBER
178: )
171: , p6_a6 JTF_NUMBER_TABLE
172: , p6_a7 JTF_DATE_TABLE
173: , p6_a8 JTF_NUMBER_TABLE
174: , p6_a9 JTF_NUMBER_TABLE
175: , p6_a10 JTF_NUMBER_TABLE
176: , p6_a11 JTF_NUMBER_TABLE
177: , x_cash_receipt_id out nocopy NUMBER
178: )
179:
172: , p6_a7 JTF_DATE_TABLE
173: , p6_a8 JTF_NUMBER_TABLE
174: , p6_a9 JTF_NUMBER_TABLE
175: , p6_a10 JTF_NUMBER_TABLE
176: , p6_a11 JTF_NUMBER_TABLE
177: , x_cash_receipt_id out nocopy NUMBER
178: )
179:
180: as