1: package body cn_trx_factor_pvt_w as
2: /* $Header: cnwtxftb.pls 120.2 2005/09/14 04:30 rarajara ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_trx_factor_pvt.trx_factor_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 cn_trx_factor_pvt_w as
2: /* $Header: cnwtxftb.pls 120.2 2005/09/14 04:30 rarajara ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_trx_factor_pvt.trx_factor_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 cn_trx_factor_pvt_w as
2: /* $Header: cnwtxftb.pls 120.2 2005/09/14 04:30 rarajara ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_trx_factor_pvt.trx_factor_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: cnwtxftb.pls 120.2 2005/09/14 04:30 rarajara ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_trx_factor_pvt.trx_factor_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_NUMBER_TABLE
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_trx_factor_pvt.trx_factor_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_NUMBER_TABLE
11: ) as
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_NUMBER_TABLE
11: ) as
12: ddindx binary_integer; indx binary_integer;
13: begin
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: ) as
12: ddindx binary_integer; indx binary_integer;
13: begin
14: if a0 is not null and a0.count > 0 then
32: end loop;
33: end if;
34: end if;
35: end rosetta_table_copy_in_p1;
36: procedure rosetta_table_copy_out_p1(t cn_trx_factor_pvt.trx_factor_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_NUMBER_TABLE
40: , a4 out nocopy JTF_NUMBER_TABLE
33: end if;
34: end if;
35: end rosetta_table_copy_in_p1;
36: procedure rosetta_table_copy_out_p1(t cn_trx_factor_pvt.trx_factor_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_NUMBER_TABLE
40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_VARCHAR2_TABLE_100
34: end if;
35: end rosetta_table_copy_in_p1;
36: procedure rosetta_table_copy_out_p1(t cn_trx_factor_pvt.trx_factor_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_NUMBER_TABLE
40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_VARCHAR2_TABLE_100
42: , a6 out nocopy JTF_NUMBER_TABLE
35: end rosetta_table_copy_in_p1;
36: procedure rosetta_table_copy_out_p1(t cn_trx_factor_pvt.trx_factor_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_NUMBER_TABLE
40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_VARCHAR2_TABLE_100
42: , a6 out nocopy JTF_NUMBER_TABLE
43: , a7 out nocopy JTF_NUMBER_TABLE
36: procedure rosetta_table_copy_out_p1(t cn_trx_factor_pvt.trx_factor_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
37: , a1 out nocopy JTF_NUMBER_TABLE
38: , a2 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_NUMBER_TABLE
40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_VARCHAR2_TABLE_100
42: , a6 out nocopy JTF_NUMBER_TABLE
43: , a7 out nocopy JTF_NUMBER_TABLE
44: ) as
38: , a2 out nocopy JTF_NUMBER_TABLE
39: , a3 out nocopy JTF_NUMBER_TABLE
40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_VARCHAR2_TABLE_100
42: , a6 out nocopy JTF_NUMBER_TABLE
43: , a7 out nocopy JTF_NUMBER_TABLE
44: ) as
45: ddindx binary_integer; indx binary_integer;
46: begin
39: , a3 out nocopy JTF_NUMBER_TABLE
40: , a4 out nocopy JTF_NUMBER_TABLE
41: , a5 out nocopy JTF_VARCHAR2_TABLE_100
42: , a6 out nocopy JTF_NUMBER_TABLE
43: , a7 out nocopy JTF_NUMBER_TABLE
44: ) as
45: ddindx binary_integer; indx binary_integer;
46: begin
47: if t is null or t.count = 0 then
44: ) as
45: ddindx binary_integer; indx binary_integer;
46: begin
47: if t is null or t.count = 0 then
48: a0 := JTF_NUMBER_TABLE();
49: a1 := JTF_NUMBER_TABLE();
50: a2 := JTF_NUMBER_TABLE();
51: a3 := JTF_NUMBER_TABLE();
52: a4 := JTF_NUMBER_TABLE();
45: ddindx binary_integer; indx binary_integer;
46: begin
47: if t is null or t.count = 0 then
48: a0 := JTF_NUMBER_TABLE();
49: a1 := JTF_NUMBER_TABLE();
50: a2 := JTF_NUMBER_TABLE();
51: a3 := JTF_NUMBER_TABLE();
52: a4 := JTF_NUMBER_TABLE();
53: a5 := JTF_VARCHAR2_TABLE_100();
46: begin
47: if t is null or t.count = 0 then
48: a0 := JTF_NUMBER_TABLE();
49: a1 := JTF_NUMBER_TABLE();
50: a2 := JTF_NUMBER_TABLE();
51: a3 := JTF_NUMBER_TABLE();
52: a4 := JTF_NUMBER_TABLE();
53: a5 := JTF_VARCHAR2_TABLE_100();
54: a6 := JTF_NUMBER_TABLE();
47: if t is null or t.count = 0 then
48: a0 := JTF_NUMBER_TABLE();
49: a1 := JTF_NUMBER_TABLE();
50: a2 := JTF_NUMBER_TABLE();
51: a3 := JTF_NUMBER_TABLE();
52: a4 := JTF_NUMBER_TABLE();
53: a5 := JTF_VARCHAR2_TABLE_100();
54: a6 := JTF_NUMBER_TABLE();
55: a7 := JTF_NUMBER_TABLE();
48: a0 := JTF_NUMBER_TABLE();
49: a1 := JTF_NUMBER_TABLE();
50: a2 := JTF_NUMBER_TABLE();
51: a3 := JTF_NUMBER_TABLE();
52: a4 := JTF_NUMBER_TABLE();
53: a5 := JTF_VARCHAR2_TABLE_100();
54: a6 := JTF_NUMBER_TABLE();
55: a7 := JTF_NUMBER_TABLE();
56: else
50: a2 := JTF_NUMBER_TABLE();
51: a3 := JTF_NUMBER_TABLE();
52: a4 := JTF_NUMBER_TABLE();
53: a5 := JTF_VARCHAR2_TABLE_100();
54: a6 := JTF_NUMBER_TABLE();
55: a7 := JTF_NUMBER_TABLE();
56: else
57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_NUMBER_TABLE();
51: a3 := JTF_NUMBER_TABLE();
52: a4 := JTF_NUMBER_TABLE();
53: a5 := JTF_VARCHAR2_TABLE_100();
54: a6 := JTF_NUMBER_TABLE();
55: a7 := JTF_NUMBER_TABLE();
56: else
57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_NUMBER_TABLE();
59: a2 := JTF_NUMBER_TABLE();
53: a5 := JTF_VARCHAR2_TABLE_100();
54: a6 := JTF_NUMBER_TABLE();
55: a7 := JTF_NUMBER_TABLE();
56: else
57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_NUMBER_TABLE();
59: a2 := JTF_NUMBER_TABLE();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_NUMBER_TABLE();
54: a6 := JTF_NUMBER_TABLE();
55: a7 := JTF_NUMBER_TABLE();
56: else
57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_NUMBER_TABLE();
59: a2 := JTF_NUMBER_TABLE();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_NUMBER_TABLE();
62: a5 := JTF_VARCHAR2_TABLE_100();
55: a7 := JTF_NUMBER_TABLE();
56: else
57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_NUMBER_TABLE();
59: a2 := JTF_NUMBER_TABLE();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_NUMBER_TABLE();
62: a5 := JTF_VARCHAR2_TABLE_100();
63: a6 := JTF_NUMBER_TABLE();
56: else
57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_NUMBER_TABLE();
59: a2 := JTF_NUMBER_TABLE();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_NUMBER_TABLE();
62: a5 := JTF_VARCHAR2_TABLE_100();
63: a6 := JTF_NUMBER_TABLE();
64: a7 := JTF_NUMBER_TABLE();
57: a0 := JTF_NUMBER_TABLE();
58: a1 := JTF_NUMBER_TABLE();
59: a2 := JTF_NUMBER_TABLE();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_NUMBER_TABLE();
62: a5 := JTF_VARCHAR2_TABLE_100();
63: a6 := JTF_NUMBER_TABLE();
64: a7 := JTF_NUMBER_TABLE();
65: if t.count > 0 then
59: a2 := JTF_NUMBER_TABLE();
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_NUMBER_TABLE();
62: a5 := JTF_VARCHAR2_TABLE_100();
63: a6 := JTF_NUMBER_TABLE();
64: a7 := JTF_NUMBER_TABLE();
65: if t.count > 0 then
66: a0.extend(t.count);
67: a1.extend(t.count);
60: a3 := JTF_NUMBER_TABLE();
61: a4 := JTF_NUMBER_TABLE();
62: a5 := JTF_VARCHAR2_TABLE_100();
63: a6 := JTF_NUMBER_TABLE();
64: a7 := JTF_NUMBER_TABLE();
65: if t.count > 0 then
66: a0.extend(t.count);
67: a1.extend(t.count);
68: a2.extend(t.count);
388: , p_init_msg_list VARCHAR2
389: , p_commit VARCHAR2
390: , p_validation_level NUMBER
391: , p_quota_rule_id NUMBER
392: , p5_a0 out nocopy JTF_NUMBER_TABLE
393: , p5_a1 out nocopy JTF_NUMBER_TABLE
394: , p5_a2 out nocopy JTF_NUMBER_TABLE
395: , p5_a3 out nocopy JTF_NUMBER_TABLE
396: , p5_a4 out nocopy JTF_NUMBER_TABLE
389: , p_commit VARCHAR2
390: , p_validation_level NUMBER
391: , p_quota_rule_id NUMBER
392: , p5_a0 out nocopy JTF_NUMBER_TABLE
393: , p5_a1 out nocopy JTF_NUMBER_TABLE
394: , p5_a2 out nocopy JTF_NUMBER_TABLE
395: , p5_a3 out nocopy JTF_NUMBER_TABLE
396: , p5_a4 out nocopy JTF_NUMBER_TABLE
397: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
390: , p_validation_level NUMBER
391: , p_quota_rule_id NUMBER
392: , p5_a0 out nocopy JTF_NUMBER_TABLE
393: , p5_a1 out nocopy JTF_NUMBER_TABLE
394: , p5_a2 out nocopy JTF_NUMBER_TABLE
395: , p5_a3 out nocopy JTF_NUMBER_TABLE
396: , p5_a4 out nocopy JTF_NUMBER_TABLE
397: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
398: , p5_a6 out nocopy JTF_NUMBER_TABLE
391: , p_quota_rule_id NUMBER
392: , p5_a0 out nocopy JTF_NUMBER_TABLE
393: , p5_a1 out nocopy JTF_NUMBER_TABLE
394: , p5_a2 out nocopy JTF_NUMBER_TABLE
395: , p5_a3 out nocopy JTF_NUMBER_TABLE
396: , p5_a4 out nocopy JTF_NUMBER_TABLE
397: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
398: , p5_a6 out nocopy JTF_NUMBER_TABLE
399: , p5_a7 out nocopy JTF_NUMBER_TABLE
392: , p5_a0 out nocopy JTF_NUMBER_TABLE
393: , p5_a1 out nocopy JTF_NUMBER_TABLE
394: , p5_a2 out nocopy JTF_NUMBER_TABLE
395: , p5_a3 out nocopy JTF_NUMBER_TABLE
396: , p5_a4 out nocopy JTF_NUMBER_TABLE
397: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
398: , p5_a6 out nocopy JTF_NUMBER_TABLE
399: , p5_a7 out nocopy JTF_NUMBER_TABLE
400: , x_return_status out nocopy VARCHAR2
394: , p5_a2 out nocopy JTF_NUMBER_TABLE
395: , p5_a3 out nocopy JTF_NUMBER_TABLE
396: , p5_a4 out nocopy JTF_NUMBER_TABLE
397: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
398: , p5_a6 out nocopy JTF_NUMBER_TABLE
399: , p5_a7 out nocopy JTF_NUMBER_TABLE
400: , x_return_status out nocopy VARCHAR2
401: , x_msg_count out nocopy NUMBER
402: , x_msg_data out nocopy VARCHAR2
395: , p5_a3 out nocopy JTF_NUMBER_TABLE
396: , p5_a4 out nocopy JTF_NUMBER_TABLE
397: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
398: , p5_a6 out nocopy JTF_NUMBER_TABLE
399: , p5_a7 out nocopy JTF_NUMBER_TABLE
400: , x_return_status out nocopy VARCHAR2
401: , x_msg_count out nocopy NUMBER
402: , x_msg_data out nocopy VARCHAR2
403: )