1: package body okl_res_pvt_w as
2: /* $Header: OKLIRESB.pls 120.0 2005/07/08 14:23:26 smadhava noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_res_pvt.okl_res_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
1: package body okl_res_pvt_w as
2: /* $Header: OKLIRESB.pls 120.0 2005/07/08 14:23:26 smadhava noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_res_pvt.okl_res_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
1: package body okl_res_pvt_w as
2: /* $Header: OKLIRESB.pls 120.0 2005/07/08 14:23:26 smadhava noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_res_pvt.okl_res_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
2: /* $Header: OKLIRESB.pls 120.0 2005/07/08 14:23:26 smadhava noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_res_pvt.okl_res_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_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_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_NUMBER_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_DATE_TABLE
10: , a7 JTF_NUMBER_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_NUMBER_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_p1;
44: procedure rosetta_table_copy_out_p1(t okl_res_pvt.okl_res_tbl, 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_DATE_TABLE
41: end if;
42: end if;
43: end rosetta_table_copy_in_p1;
44: procedure rosetta_table_copy_out_p1(t okl_res_pvt.okl_res_tbl, 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_DATE_TABLE
49: , a5 out nocopy JTF_NUMBER_TABLE
42: end if;
43: end rosetta_table_copy_in_p1;
44: procedure rosetta_table_copy_out_p1(t okl_res_pvt.okl_res_tbl, 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_DATE_TABLE
49: , a5 out nocopy JTF_NUMBER_TABLE
50: , a6 out nocopy JTF_DATE_TABLE
43: end rosetta_table_copy_in_p1;
44: procedure rosetta_table_copy_out_p1(t okl_res_pvt.okl_res_tbl, 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_DATE_TABLE
49: , a5 out nocopy JTF_NUMBER_TABLE
50: , a6 out nocopy JTF_DATE_TABLE
51: , a7 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_DATE_TABLE
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_NUMBER_TABLE
53: , a9 out nocopy JTF_NUMBER_TABLE
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_DATE_TABLE
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_NUMBER_TABLE
53: , a9 out nocopy JTF_NUMBER_TABLE
54: , a10 out nocopy JTF_NUMBER_TABLE
55: , a11 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_DATE_TABLE
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_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_NUMBER_TABLE
50: , a6 out nocopy JTF_DATE_TABLE
51: , a7 out nocopy JTF_NUMBER_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_DATE_TABLE
51: , a7 out nocopy JTF_NUMBER_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_NUMBER_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_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_NUMBER_TABLE();
62: a2 := JTF_NUMBER_TABLE();
63: a3 := JTF_NUMBER_TABLE();
64: a4 := JTF_DATE_TABLE();
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_NUMBER_TABLE();
62: a2 := JTF_NUMBER_TABLE();
63: a3 := JTF_NUMBER_TABLE();
64: a4 := JTF_DATE_TABLE();
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_NUMBER_TABLE();
62: a2 := JTF_NUMBER_TABLE();
63: a3 := JTF_NUMBER_TABLE();
64: a4 := JTF_DATE_TABLE();
65: a5 := JTF_NUMBER_TABLE();
66: a6 := JTF_DATE_TABLE();
67: a7 := JTF_NUMBER_TABLE();
61: a1 := JTF_NUMBER_TABLE();
62: a2 := JTF_NUMBER_TABLE();
63: a3 := JTF_NUMBER_TABLE();
64: a4 := JTF_DATE_TABLE();
65: a5 := JTF_NUMBER_TABLE();
66: a6 := JTF_DATE_TABLE();
67: a7 := JTF_NUMBER_TABLE();
68: a8 := JTF_NUMBER_TABLE();
69: a9 := JTF_NUMBER_TABLE();
63: a3 := JTF_NUMBER_TABLE();
64: a4 := JTF_DATE_TABLE();
65: a5 := JTF_NUMBER_TABLE();
66: a6 := JTF_DATE_TABLE();
67: a7 := JTF_NUMBER_TABLE();
68: a8 := JTF_NUMBER_TABLE();
69: a9 := JTF_NUMBER_TABLE();
70: a10 := JTF_NUMBER_TABLE();
71: a11 := JTF_NUMBER_TABLE();
64: a4 := JTF_DATE_TABLE();
65: a5 := JTF_NUMBER_TABLE();
66: a6 := JTF_DATE_TABLE();
67: a7 := JTF_NUMBER_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_NUMBER_TABLE();
66: a6 := JTF_DATE_TABLE();
67: a7 := JTF_NUMBER_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_DATE_TABLE();
67: a7 := JTF_NUMBER_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_NUMBER_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_DATE_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_DATE_TABLE();
78: a5 := 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_DATE_TABLE();
78: a5 := JTF_NUMBER_TABLE();
79: a6 := JTF_DATE_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_DATE_TABLE();
78: a5 := JTF_NUMBER_TABLE();
79: a6 := JTF_DATE_TABLE();
80: a7 := JTF_NUMBER_TABLE();
74: a1 := JTF_NUMBER_TABLE();
75: a2 := JTF_NUMBER_TABLE();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_DATE_TABLE();
78: a5 := JTF_NUMBER_TABLE();
79: a6 := JTF_DATE_TABLE();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_NUMBER_TABLE();
76: a3 := JTF_NUMBER_TABLE();
77: a4 := JTF_DATE_TABLE();
78: a5 := JTF_NUMBER_TABLE();
79: a6 := JTF_DATE_TABLE();
80: a7 := JTF_NUMBER_TABLE();
81: a8 := JTF_NUMBER_TABLE();
82: a9 := JTF_NUMBER_TABLE();
83: a10 := JTF_NUMBER_TABLE();
84: a11 := JTF_NUMBER_TABLE();
77: a4 := JTF_DATE_TABLE();
78: a5 := JTF_NUMBER_TABLE();
79: a6 := JTF_DATE_TABLE();
80: a7 := JTF_NUMBER_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_NUMBER_TABLE();
79: a6 := JTF_DATE_TABLE();
80: a7 := JTF_NUMBER_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_DATE_TABLE();
80: a7 := JTF_NUMBER_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_NUMBER_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);
211: , p_init_msg_list VARCHAR2
212: , x_return_status out nocopy VARCHAR2
213: , x_msg_count out nocopy NUMBER
214: , x_msg_data out nocopy VARCHAR2
215: , p5_a0 JTF_NUMBER_TABLE
216: , p5_a1 JTF_NUMBER_TABLE
217: , p5_a2 JTF_NUMBER_TABLE
218: , p5_a3 JTF_NUMBER_TABLE
219: , p5_a4 JTF_DATE_TABLE
212: , x_return_status out nocopy VARCHAR2
213: , x_msg_count out nocopy NUMBER
214: , x_msg_data out nocopy VARCHAR2
215: , p5_a0 JTF_NUMBER_TABLE
216: , p5_a1 JTF_NUMBER_TABLE
217: , p5_a2 JTF_NUMBER_TABLE
218: , p5_a3 JTF_NUMBER_TABLE
219: , p5_a4 JTF_DATE_TABLE
220: , p5_a5 JTF_NUMBER_TABLE
213: , x_msg_count out nocopy NUMBER
214: , x_msg_data out nocopy VARCHAR2
215: , p5_a0 JTF_NUMBER_TABLE
216: , p5_a1 JTF_NUMBER_TABLE
217: , p5_a2 JTF_NUMBER_TABLE
218: , p5_a3 JTF_NUMBER_TABLE
219: , p5_a4 JTF_DATE_TABLE
220: , p5_a5 JTF_NUMBER_TABLE
221: , p5_a6 JTF_DATE_TABLE
214: , x_msg_data out nocopy VARCHAR2
215: , p5_a0 JTF_NUMBER_TABLE
216: , p5_a1 JTF_NUMBER_TABLE
217: , p5_a2 JTF_NUMBER_TABLE
218: , p5_a3 JTF_NUMBER_TABLE
219: , p5_a4 JTF_DATE_TABLE
220: , p5_a5 JTF_NUMBER_TABLE
221: , p5_a6 JTF_DATE_TABLE
222: , p5_a7 JTF_NUMBER_TABLE
216: , p5_a1 JTF_NUMBER_TABLE
217: , p5_a2 JTF_NUMBER_TABLE
218: , p5_a3 JTF_NUMBER_TABLE
219: , p5_a4 JTF_DATE_TABLE
220: , p5_a5 JTF_NUMBER_TABLE
221: , p5_a6 JTF_DATE_TABLE
222: , p5_a7 JTF_NUMBER_TABLE
223: , p5_a8 JTF_NUMBER_TABLE
224: , p5_a9 JTF_NUMBER_TABLE
218: , p5_a3 JTF_NUMBER_TABLE
219: , p5_a4 JTF_DATE_TABLE
220: , p5_a5 JTF_NUMBER_TABLE
221: , p5_a6 JTF_DATE_TABLE
222: , p5_a7 JTF_NUMBER_TABLE
223: , p5_a8 JTF_NUMBER_TABLE
224: , p5_a9 JTF_NUMBER_TABLE
225: , p5_a10 JTF_NUMBER_TABLE
226: , p5_a11 JTF_NUMBER_TABLE
219: , p5_a4 JTF_DATE_TABLE
220: , p5_a5 JTF_NUMBER_TABLE
221: , p5_a6 JTF_DATE_TABLE
222: , p5_a7 JTF_NUMBER_TABLE
223: , p5_a8 JTF_NUMBER_TABLE
224: , p5_a9 JTF_NUMBER_TABLE
225: , p5_a10 JTF_NUMBER_TABLE
226: , p5_a11 JTF_NUMBER_TABLE
227: , p6_a0 out nocopy JTF_NUMBER_TABLE
220: , p5_a5 JTF_NUMBER_TABLE
221: , p5_a6 JTF_DATE_TABLE
222: , p5_a7 JTF_NUMBER_TABLE
223: , p5_a8 JTF_NUMBER_TABLE
224: , p5_a9 JTF_NUMBER_TABLE
225: , p5_a10 JTF_NUMBER_TABLE
226: , p5_a11 JTF_NUMBER_TABLE
227: , p6_a0 out nocopy JTF_NUMBER_TABLE
228: , p6_a1 out nocopy JTF_NUMBER_TABLE
221: , p5_a6 JTF_DATE_TABLE
222: , p5_a7 JTF_NUMBER_TABLE
223: , p5_a8 JTF_NUMBER_TABLE
224: , p5_a9 JTF_NUMBER_TABLE
225: , p5_a10 JTF_NUMBER_TABLE
226: , p5_a11 JTF_NUMBER_TABLE
227: , p6_a0 out nocopy JTF_NUMBER_TABLE
228: , p6_a1 out nocopy JTF_NUMBER_TABLE
229: , p6_a2 out nocopy JTF_NUMBER_TABLE
222: , p5_a7 JTF_NUMBER_TABLE
223: , p5_a8 JTF_NUMBER_TABLE
224: , p5_a9 JTF_NUMBER_TABLE
225: , p5_a10 JTF_NUMBER_TABLE
226: , p5_a11 JTF_NUMBER_TABLE
227: , p6_a0 out nocopy JTF_NUMBER_TABLE
228: , p6_a1 out nocopy JTF_NUMBER_TABLE
229: , p6_a2 out nocopy JTF_NUMBER_TABLE
230: , p6_a3 out nocopy JTF_NUMBER_TABLE
223: , p5_a8 JTF_NUMBER_TABLE
224: , p5_a9 JTF_NUMBER_TABLE
225: , p5_a10 JTF_NUMBER_TABLE
226: , p5_a11 JTF_NUMBER_TABLE
227: , p6_a0 out nocopy JTF_NUMBER_TABLE
228: , p6_a1 out nocopy JTF_NUMBER_TABLE
229: , p6_a2 out nocopy JTF_NUMBER_TABLE
230: , p6_a3 out nocopy JTF_NUMBER_TABLE
231: , p6_a4 out nocopy JTF_DATE_TABLE
224: , p5_a9 JTF_NUMBER_TABLE
225: , p5_a10 JTF_NUMBER_TABLE
226: , p5_a11 JTF_NUMBER_TABLE
227: , p6_a0 out nocopy JTF_NUMBER_TABLE
228: , p6_a1 out nocopy JTF_NUMBER_TABLE
229: , p6_a2 out nocopy JTF_NUMBER_TABLE
230: , p6_a3 out nocopy JTF_NUMBER_TABLE
231: , p6_a4 out nocopy JTF_DATE_TABLE
232: , p6_a5 out nocopy JTF_NUMBER_TABLE
225: , p5_a10 JTF_NUMBER_TABLE
226: , p5_a11 JTF_NUMBER_TABLE
227: , p6_a0 out nocopy JTF_NUMBER_TABLE
228: , p6_a1 out nocopy JTF_NUMBER_TABLE
229: , p6_a2 out nocopy JTF_NUMBER_TABLE
230: , p6_a3 out nocopy JTF_NUMBER_TABLE
231: , p6_a4 out nocopy JTF_DATE_TABLE
232: , p6_a5 out nocopy JTF_NUMBER_TABLE
233: , p6_a6 out nocopy JTF_DATE_TABLE
226: , p5_a11 JTF_NUMBER_TABLE
227: , p6_a0 out nocopy JTF_NUMBER_TABLE
228: , p6_a1 out nocopy JTF_NUMBER_TABLE
229: , p6_a2 out nocopy JTF_NUMBER_TABLE
230: , p6_a3 out nocopy JTF_NUMBER_TABLE
231: , p6_a4 out nocopy JTF_DATE_TABLE
232: , p6_a5 out nocopy JTF_NUMBER_TABLE
233: , p6_a6 out nocopy JTF_DATE_TABLE
234: , p6_a7 out nocopy JTF_NUMBER_TABLE
228: , p6_a1 out nocopy JTF_NUMBER_TABLE
229: , p6_a2 out nocopy JTF_NUMBER_TABLE
230: , p6_a3 out nocopy JTF_NUMBER_TABLE
231: , p6_a4 out nocopy JTF_DATE_TABLE
232: , p6_a5 out nocopy JTF_NUMBER_TABLE
233: , p6_a6 out nocopy JTF_DATE_TABLE
234: , p6_a7 out nocopy JTF_NUMBER_TABLE
235: , p6_a8 out nocopy JTF_NUMBER_TABLE
236: , p6_a9 out nocopy JTF_NUMBER_TABLE
230: , p6_a3 out nocopy JTF_NUMBER_TABLE
231: , p6_a4 out nocopy JTF_DATE_TABLE
232: , p6_a5 out nocopy JTF_NUMBER_TABLE
233: , p6_a6 out nocopy JTF_DATE_TABLE
234: , p6_a7 out nocopy JTF_NUMBER_TABLE
235: , p6_a8 out nocopy JTF_NUMBER_TABLE
236: , p6_a9 out nocopy JTF_NUMBER_TABLE
237: , p6_a10 out nocopy JTF_NUMBER_TABLE
238: , p6_a11 out nocopy JTF_NUMBER_TABLE
231: , p6_a4 out nocopy JTF_DATE_TABLE
232: , p6_a5 out nocopy JTF_NUMBER_TABLE
233: , p6_a6 out nocopy JTF_DATE_TABLE
234: , p6_a7 out nocopy JTF_NUMBER_TABLE
235: , p6_a8 out nocopy JTF_NUMBER_TABLE
236: , p6_a9 out nocopy JTF_NUMBER_TABLE
237: , p6_a10 out nocopy JTF_NUMBER_TABLE
238: , p6_a11 out nocopy JTF_NUMBER_TABLE
239: )
232: , p6_a5 out nocopy JTF_NUMBER_TABLE
233: , p6_a6 out nocopy JTF_DATE_TABLE
234: , p6_a7 out nocopy JTF_NUMBER_TABLE
235: , p6_a8 out nocopy JTF_NUMBER_TABLE
236: , p6_a9 out nocopy JTF_NUMBER_TABLE
237: , p6_a10 out nocopy JTF_NUMBER_TABLE
238: , p6_a11 out nocopy JTF_NUMBER_TABLE
239: )
240:
233: , p6_a6 out nocopy JTF_DATE_TABLE
234: , p6_a7 out nocopy JTF_NUMBER_TABLE
235: , p6_a8 out nocopy JTF_NUMBER_TABLE
236: , p6_a9 out nocopy JTF_NUMBER_TABLE
237: , p6_a10 out nocopy JTF_NUMBER_TABLE
238: , p6_a11 out nocopy JTF_NUMBER_TABLE
239: )
240:
241: as
234: , p6_a7 out nocopy JTF_NUMBER_TABLE
235: , p6_a8 out nocopy JTF_NUMBER_TABLE
236: , p6_a9 out nocopy JTF_NUMBER_TABLE
237: , p6_a10 out nocopy JTF_NUMBER_TABLE
238: , p6_a11 out nocopy JTF_NUMBER_TABLE
239: )
240:
241: as
242: ddp_res_tbl okl_res_pvt.okl_res_tbl;
387: , p_init_msg_list VARCHAR2
388: , x_return_status out nocopy VARCHAR2
389: , x_msg_count out nocopy NUMBER
390: , x_msg_data out nocopy VARCHAR2
391: , p5_a0 JTF_NUMBER_TABLE
392: , p5_a1 JTF_NUMBER_TABLE
393: , p5_a2 JTF_NUMBER_TABLE
394: , p5_a3 JTF_NUMBER_TABLE
395: , p5_a4 JTF_DATE_TABLE
388: , x_return_status out nocopy VARCHAR2
389: , x_msg_count out nocopy NUMBER
390: , x_msg_data out nocopy VARCHAR2
391: , p5_a0 JTF_NUMBER_TABLE
392: , p5_a1 JTF_NUMBER_TABLE
393: , p5_a2 JTF_NUMBER_TABLE
394: , p5_a3 JTF_NUMBER_TABLE
395: , p5_a4 JTF_DATE_TABLE
396: , p5_a5 JTF_NUMBER_TABLE
389: , x_msg_count out nocopy NUMBER
390: , x_msg_data out nocopy VARCHAR2
391: , p5_a0 JTF_NUMBER_TABLE
392: , p5_a1 JTF_NUMBER_TABLE
393: , p5_a2 JTF_NUMBER_TABLE
394: , p5_a3 JTF_NUMBER_TABLE
395: , p5_a4 JTF_DATE_TABLE
396: , p5_a5 JTF_NUMBER_TABLE
397: , p5_a6 JTF_DATE_TABLE
390: , x_msg_data out nocopy VARCHAR2
391: , p5_a0 JTF_NUMBER_TABLE
392: , p5_a1 JTF_NUMBER_TABLE
393: , p5_a2 JTF_NUMBER_TABLE
394: , p5_a3 JTF_NUMBER_TABLE
395: , p5_a4 JTF_DATE_TABLE
396: , p5_a5 JTF_NUMBER_TABLE
397: , p5_a6 JTF_DATE_TABLE
398: , p5_a7 JTF_NUMBER_TABLE
392: , p5_a1 JTF_NUMBER_TABLE
393: , p5_a2 JTF_NUMBER_TABLE
394: , p5_a3 JTF_NUMBER_TABLE
395: , p5_a4 JTF_DATE_TABLE
396: , p5_a5 JTF_NUMBER_TABLE
397: , p5_a6 JTF_DATE_TABLE
398: , p5_a7 JTF_NUMBER_TABLE
399: , p5_a8 JTF_NUMBER_TABLE
400: , p5_a9 JTF_NUMBER_TABLE
394: , p5_a3 JTF_NUMBER_TABLE
395: , p5_a4 JTF_DATE_TABLE
396: , p5_a5 JTF_NUMBER_TABLE
397: , p5_a6 JTF_DATE_TABLE
398: , p5_a7 JTF_NUMBER_TABLE
399: , p5_a8 JTF_NUMBER_TABLE
400: , p5_a9 JTF_NUMBER_TABLE
401: , p5_a10 JTF_NUMBER_TABLE
402: , p5_a11 JTF_NUMBER_TABLE
395: , p5_a4 JTF_DATE_TABLE
396: , p5_a5 JTF_NUMBER_TABLE
397: , p5_a6 JTF_DATE_TABLE
398: , p5_a7 JTF_NUMBER_TABLE
399: , p5_a8 JTF_NUMBER_TABLE
400: , p5_a9 JTF_NUMBER_TABLE
401: , p5_a10 JTF_NUMBER_TABLE
402: , p5_a11 JTF_NUMBER_TABLE
403: , p6_a0 out nocopy JTF_NUMBER_TABLE
396: , p5_a5 JTF_NUMBER_TABLE
397: , p5_a6 JTF_DATE_TABLE
398: , p5_a7 JTF_NUMBER_TABLE
399: , p5_a8 JTF_NUMBER_TABLE
400: , p5_a9 JTF_NUMBER_TABLE
401: , p5_a10 JTF_NUMBER_TABLE
402: , p5_a11 JTF_NUMBER_TABLE
403: , p6_a0 out nocopy JTF_NUMBER_TABLE
404: , p6_a1 out nocopy JTF_NUMBER_TABLE
397: , p5_a6 JTF_DATE_TABLE
398: , p5_a7 JTF_NUMBER_TABLE
399: , p5_a8 JTF_NUMBER_TABLE
400: , p5_a9 JTF_NUMBER_TABLE
401: , p5_a10 JTF_NUMBER_TABLE
402: , p5_a11 JTF_NUMBER_TABLE
403: , p6_a0 out nocopy JTF_NUMBER_TABLE
404: , p6_a1 out nocopy JTF_NUMBER_TABLE
405: , p6_a2 out nocopy JTF_NUMBER_TABLE
398: , p5_a7 JTF_NUMBER_TABLE
399: , p5_a8 JTF_NUMBER_TABLE
400: , p5_a9 JTF_NUMBER_TABLE
401: , p5_a10 JTF_NUMBER_TABLE
402: , p5_a11 JTF_NUMBER_TABLE
403: , p6_a0 out nocopy JTF_NUMBER_TABLE
404: , p6_a1 out nocopy JTF_NUMBER_TABLE
405: , p6_a2 out nocopy JTF_NUMBER_TABLE
406: , p6_a3 out nocopy JTF_NUMBER_TABLE
399: , p5_a8 JTF_NUMBER_TABLE
400: , p5_a9 JTF_NUMBER_TABLE
401: , p5_a10 JTF_NUMBER_TABLE
402: , p5_a11 JTF_NUMBER_TABLE
403: , p6_a0 out nocopy JTF_NUMBER_TABLE
404: , p6_a1 out nocopy JTF_NUMBER_TABLE
405: , p6_a2 out nocopy JTF_NUMBER_TABLE
406: , p6_a3 out nocopy JTF_NUMBER_TABLE
407: , p6_a4 out nocopy JTF_DATE_TABLE
400: , p5_a9 JTF_NUMBER_TABLE
401: , p5_a10 JTF_NUMBER_TABLE
402: , p5_a11 JTF_NUMBER_TABLE
403: , p6_a0 out nocopy JTF_NUMBER_TABLE
404: , p6_a1 out nocopy JTF_NUMBER_TABLE
405: , p6_a2 out nocopy JTF_NUMBER_TABLE
406: , p6_a3 out nocopy JTF_NUMBER_TABLE
407: , p6_a4 out nocopy JTF_DATE_TABLE
408: , p6_a5 out nocopy JTF_NUMBER_TABLE
401: , p5_a10 JTF_NUMBER_TABLE
402: , p5_a11 JTF_NUMBER_TABLE
403: , p6_a0 out nocopy JTF_NUMBER_TABLE
404: , p6_a1 out nocopy JTF_NUMBER_TABLE
405: , p6_a2 out nocopy JTF_NUMBER_TABLE
406: , p6_a3 out nocopy JTF_NUMBER_TABLE
407: , p6_a4 out nocopy JTF_DATE_TABLE
408: , p6_a5 out nocopy JTF_NUMBER_TABLE
409: , p6_a6 out nocopy JTF_DATE_TABLE
402: , p5_a11 JTF_NUMBER_TABLE
403: , p6_a0 out nocopy JTF_NUMBER_TABLE
404: , p6_a1 out nocopy JTF_NUMBER_TABLE
405: , p6_a2 out nocopy JTF_NUMBER_TABLE
406: , p6_a3 out nocopy JTF_NUMBER_TABLE
407: , p6_a4 out nocopy JTF_DATE_TABLE
408: , p6_a5 out nocopy JTF_NUMBER_TABLE
409: , p6_a6 out nocopy JTF_DATE_TABLE
410: , p6_a7 out nocopy JTF_NUMBER_TABLE
404: , p6_a1 out nocopy JTF_NUMBER_TABLE
405: , p6_a2 out nocopy JTF_NUMBER_TABLE
406: , p6_a3 out nocopy JTF_NUMBER_TABLE
407: , p6_a4 out nocopy JTF_DATE_TABLE
408: , p6_a5 out nocopy JTF_NUMBER_TABLE
409: , p6_a6 out nocopy JTF_DATE_TABLE
410: , p6_a7 out nocopy JTF_NUMBER_TABLE
411: , p6_a8 out nocopy JTF_NUMBER_TABLE
412: , p6_a9 out nocopy JTF_NUMBER_TABLE
406: , p6_a3 out nocopy JTF_NUMBER_TABLE
407: , p6_a4 out nocopy JTF_DATE_TABLE
408: , p6_a5 out nocopy JTF_NUMBER_TABLE
409: , p6_a6 out nocopy JTF_DATE_TABLE
410: , p6_a7 out nocopy JTF_NUMBER_TABLE
411: , p6_a8 out nocopy JTF_NUMBER_TABLE
412: , p6_a9 out nocopy JTF_NUMBER_TABLE
413: , p6_a10 out nocopy JTF_NUMBER_TABLE
414: , p6_a11 out nocopy JTF_NUMBER_TABLE
407: , p6_a4 out nocopy JTF_DATE_TABLE
408: , p6_a5 out nocopy JTF_NUMBER_TABLE
409: , p6_a6 out nocopy JTF_DATE_TABLE
410: , p6_a7 out nocopy JTF_NUMBER_TABLE
411: , p6_a8 out nocopy JTF_NUMBER_TABLE
412: , p6_a9 out nocopy JTF_NUMBER_TABLE
413: , p6_a10 out nocopy JTF_NUMBER_TABLE
414: , p6_a11 out nocopy JTF_NUMBER_TABLE
415: )
408: , p6_a5 out nocopy JTF_NUMBER_TABLE
409: , p6_a6 out nocopy JTF_DATE_TABLE
410: , p6_a7 out nocopy JTF_NUMBER_TABLE
411: , p6_a8 out nocopy JTF_NUMBER_TABLE
412: , p6_a9 out nocopy JTF_NUMBER_TABLE
413: , p6_a10 out nocopy JTF_NUMBER_TABLE
414: , p6_a11 out nocopy JTF_NUMBER_TABLE
415: )
416:
409: , p6_a6 out nocopy JTF_DATE_TABLE
410: , p6_a7 out nocopy JTF_NUMBER_TABLE
411: , p6_a8 out nocopy JTF_NUMBER_TABLE
412: , p6_a9 out nocopy JTF_NUMBER_TABLE
413: , p6_a10 out nocopy JTF_NUMBER_TABLE
414: , p6_a11 out nocopy JTF_NUMBER_TABLE
415: )
416:
417: as
410: , p6_a7 out nocopy JTF_NUMBER_TABLE
411: , p6_a8 out nocopy JTF_NUMBER_TABLE
412: , p6_a9 out nocopy JTF_NUMBER_TABLE
413: , p6_a10 out nocopy JTF_NUMBER_TABLE
414: , p6_a11 out nocopy JTF_NUMBER_TABLE
415: )
416:
417: as
418: ddp_res_tbl okl_res_pvt.okl_res_tbl;
535: , p_init_msg_list VARCHAR2
536: , x_return_status out nocopy VARCHAR2
537: , x_msg_count out nocopy NUMBER
538: , x_msg_data out nocopy VARCHAR2
539: , p5_a0 JTF_NUMBER_TABLE
540: , p5_a1 JTF_NUMBER_TABLE
541: , p5_a2 JTF_NUMBER_TABLE
542: , p5_a3 JTF_NUMBER_TABLE
543: , p5_a4 JTF_DATE_TABLE
536: , x_return_status out nocopy VARCHAR2
537: , x_msg_count out nocopy NUMBER
538: , x_msg_data out nocopy VARCHAR2
539: , p5_a0 JTF_NUMBER_TABLE
540: , p5_a1 JTF_NUMBER_TABLE
541: , p5_a2 JTF_NUMBER_TABLE
542: , p5_a3 JTF_NUMBER_TABLE
543: , p5_a4 JTF_DATE_TABLE
544: , p5_a5 JTF_NUMBER_TABLE
537: , x_msg_count out nocopy NUMBER
538: , x_msg_data out nocopy VARCHAR2
539: , p5_a0 JTF_NUMBER_TABLE
540: , p5_a1 JTF_NUMBER_TABLE
541: , p5_a2 JTF_NUMBER_TABLE
542: , p5_a3 JTF_NUMBER_TABLE
543: , p5_a4 JTF_DATE_TABLE
544: , p5_a5 JTF_NUMBER_TABLE
545: , p5_a6 JTF_DATE_TABLE
538: , x_msg_data out nocopy VARCHAR2
539: , p5_a0 JTF_NUMBER_TABLE
540: , p5_a1 JTF_NUMBER_TABLE
541: , p5_a2 JTF_NUMBER_TABLE
542: , p5_a3 JTF_NUMBER_TABLE
543: , p5_a4 JTF_DATE_TABLE
544: , p5_a5 JTF_NUMBER_TABLE
545: , p5_a6 JTF_DATE_TABLE
546: , p5_a7 JTF_NUMBER_TABLE
540: , p5_a1 JTF_NUMBER_TABLE
541: , p5_a2 JTF_NUMBER_TABLE
542: , p5_a3 JTF_NUMBER_TABLE
543: , p5_a4 JTF_DATE_TABLE
544: , p5_a5 JTF_NUMBER_TABLE
545: , p5_a6 JTF_DATE_TABLE
546: , p5_a7 JTF_NUMBER_TABLE
547: , p5_a8 JTF_NUMBER_TABLE
548: , p5_a9 JTF_NUMBER_TABLE
542: , p5_a3 JTF_NUMBER_TABLE
543: , p5_a4 JTF_DATE_TABLE
544: , p5_a5 JTF_NUMBER_TABLE
545: , p5_a6 JTF_DATE_TABLE
546: , p5_a7 JTF_NUMBER_TABLE
547: , p5_a8 JTF_NUMBER_TABLE
548: , p5_a9 JTF_NUMBER_TABLE
549: , p5_a10 JTF_NUMBER_TABLE
550: , p5_a11 JTF_NUMBER_TABLE
543: , p5_a4 JTF_DATE_TABLE
544: , p5_a5 JTF_NUMBER_TABLE
545: , p5_a6 JTF_DATE_TABLE
546: , p5_a7 JTF_NUMBER_TABLE
547: , p5_a8 JTF_NUMBER_TABLE
548: , p5_a9 JTF_NUMBER_TABLE
549: , p5_a10 JTF_NUMBER_TABLE
550: , p5_a11 JTF_NUMBER_TABLE
551: )
544: , p5_a5 JTF_NUMBER_TABLE
545: , p5_a6 JTF_DATE_TABLE
546: , p5_a7 JTF_NUMBER_TABLE
547: , p5_a8 JTF_NUMBER_TABLE
548: , p5_a9 JTF_NUMBER_TABLE
549: , p5_a10 JTF_NUMBER_TABLE
550: , p5_a11 JTF_NUMBER_TABLE
551: )
552:
545: , p5_a6 JTF_DATE_TABLE
546: , p5_a7 JTF_NUMBER_TABLE
547: , p5_a8 JTF_NUMBER_TABLE
548: , p5_a9 JTF_NUMBER_TABLE
549: , p5_a10 JTF_NUMBER_TABLE
550: , p5_a11 JTF_NUMBER_TABLE
551: )
552:
553: as
546: , p5_a7 JTF_NUMBER_TABLE
547: , p5_a8 JTF_NUMBER_TABLE
548: , p5_a9 JTF_NUMBER_TABLE
549: , p5_a10 JTF_NUMBER_TABLE
550: , p5_a11 JTF_NUMBER_TABLE
551: )
552:
553: as
554: ddp_res_tbl okl_res_pvt.okl_res_tbl;