1: package ozf_split_claim_pvt_w AUTHID CURRENT_USER as
2: /* $Header: ozfwspcs.pls 120.4 2011/09/22 09:21:53 bkunjan ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ozf_split_claim_pvt.child_claim_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 ozf_split_claim_pvt_w AUTHID CURRENT_USER as
2: /* $Header: ozfwspcs.pls 120.4 2011/09/22 09:21:53 bkunjan ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ozf_split_claim_pvt.child_claim_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_NUMBER_TABLE
1: package ozf_split_claim_pvt_w AUTHID CURRENT_USER as
2: /* $Header: ozfwspcs.pls 120.4 2011/09/22 09:21:53 bkunjan ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ozf_split_claim_pvt.child_claim_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_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
2: /* $Header: ozfwspcs.pls 120.4 2011/09/22 09:21:53 bkunjan ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ozf_split_claim_pvt.child_claim_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_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
3: procedure rosetta_table_copy_in_p1(t out nocopy ozf_split_claim_pvt.child_claim_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_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_4000
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_4000
12: , a9 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_4000
12: , a9 JTF_NUMBER_TABLE
13: );
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_4000
12: , a9 JTF_NUMBER_TABLE
13: );
14: procedure rosetta_table_copy_out_p1(t ozf_split_claim_pvt.child_claim_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_4000
12: , a9 JTF_NUMBER_TABLE
13: );
14: procedure rosetta_table_copy_out_p1(t ozf_split_claim_pvt.child_claim_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_4000
12: , a9 JTF_NUMBER_TABLE
13: );
14: procedure rosetta_table_copy_out_p1(t ozf_split_claim_pvt.child_claim_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_NUMBER_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_4000
12: , a9 JTF_NUMBER_TABLE
13: );
14: procedure rosetta_table_copy_out_p1(t ozf_split_claim_pvt.child_claim_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_NUMBER_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
19: , a5 out nocopy JTF_NUMBER_TABLE
12: , a9 JTF_NUMBER_TABLE
13: );
14: procedure rosetta_table_copy_out_p1(t ozf_split_claim_pvt.child_claim_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_NUMBER_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_NUMBER_TABLE
13: );
14: procedure rosetta_table_copy_out_p1(t ozf_split_claim_pvt.child_claim_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_NUMBER_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_NUMBER_TABLE
21: , a7 out nocopy JTF_NUMBER_TABLE
14: procedure rosetta_table_copy_out_p1(t ozf_split_claim_pvt.child_claim_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
15: , a1 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_NUMBER_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_NUMBER_TABLE
21: , a7 out nocopy JTF_NUMBER_TABLE
22: , a8 out nocopy JTF_VARCHAR2_TABLE_4000
15: , a1 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_NUMBER_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_NUMBER_TABLE
21: , a7 out nocopy JTF_NUMBER_TABLE
22: , a8 out nocopy JTF_VARCHAR2_TABLE_4000
23: , a9 out nocopy JTF_NUMBER_TABLE
16: , a2 out nocopy JTF_NUMBER_TABLE
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_NUMBER_TABLE
21: , a7 out nocopy JTF_NUMBER_TABLE
22: , a8 out nocopy JTF_VARCHAR2_TABLE_4000
23: , a9 out nocopy JTF_NUMBER_TABLE
24: );
17: , a3 out nocopy JTF_NUMBER_TABLE
18: , a4 out nocopy JTF_NUMBER_TABLE
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_NUMBER_TABLE
21: , a7 out nocopy JTF_NUMBER_TABLE
22: , a8 out nocopy JTF_VARCHAR2_TABLE_4000
23: , a9 out nocopy JTF_NUMBER_TABLE
24: );
25:
19: , a5 out nocopy JTF_NUMBER_TABLE
20: , a6 out nocopy JTF_NUMBER_TABLE
21: , a7 out nocopy JTF_NUMBER_TABLE
22: , a8 out nocopy JTF_VARCHAR2_TABLE_4000
23: , a9 out nocopy JTF_NUMBER_TABLE
24: );
25:
26: procedure create_child_claim_tbl(p_api_version NUMBER
27: , p_init_msg_list VARCHAR2
29: , p_validation_level NUMBER
30: , x_return_status out nocopy VARCHAR2
31: , x_msg_data out nocopy VARCHAR2
32: , x_msg_count out nocopy NUMBER
33: , p7_a0 in out nocopy JTF_NUMBER_TABLE
34: , p7_a1 in out nocopy JTF_NUMBER_TABLE
35: , p7_a2 in out nocopy JTF_NUMBER_TABLE
36: , p7_a3 in out nocopy JTF_NUMBER_TABLE
37: , p7_a4 in out nocopy JTF_NUMBER_TABLE
30: , x_return_status out nocopy VARCHAR2
31: , x_msg_data out nocopy VARCHAR2
32: , x_msg_count out nocopy NUMBER
33: , p7_a0 in out nocopy JTF_NUMBER_TABLE
34: , p7_a1 in out nocopy JTF_NUMBER_TABLE
35: , p7_a2 in out nocopy JTF_NUMBER_TABLE
36: , p7_a3 in out nocopy JTF_NUMBER_TABLE
37: , p7_a4 in out nocopy JTF_NUMBER_TABLE
38: , p7_a5 in out nocopy JTF_NUMBER_TABLE
31: , x_msg_data out nocopy VARCHAR2
32: , x_msg_count out nocopy NUMBER
33: , p7_a0 in out nocopy JTF_NUMBER_TABLE
34: , p7_a1 in out nocopy JTF_NUMBER_TABLE
35: , p7_a2 in out nocopy JTF_NUMBER_TABLE
36: , p7_a3 in out nocopy JTF_NUMBER_TABLE
37: , p7_a4 in out nocopy JTF_NUMBER_TABLE
38: , p7_a5 in out nocopy JTF_NUMBER_TABLE
39: , p7_a6 in out nocopy JTF_NUMBER_TABLE
32: , x_msg_count out nocopy NUMBER
33: , p7_a0 in out nocopy JTF_NUMBER_TABLE
34: , p7_a1 in out nocopy JTF_NUMBER_TABLE
35: , p7_a2 in out nocopy JTF_NUMBER_TABLE
36: , p7_a3 in out nocopy JTF_NUMBER_TABLE
37: , p7_a4 in out nocopy JTF_NUMBER_TABLE
38: , p7_a5 in out nocopy JTF_NUMBER_TABLE
39: , p7_a6 in out nocopy JTF_NUMBER_TABLE
40: , p7_a7 in out nocopy JTF_NUMBER_TABLE
33: , p7_a0 in out nocopy JTF_NUMBER_TABLE
34: , p7_a1 in out nocopy JTF_NUMBER_TABLE
35: , p7_a2 in out nocopy JTF_NUMBER_TABLE
36: , p7_a3 in out nocopy JTF_NUMBER_TABLE
37: , p7_a4 in out nocopy JTF_NUMBER_TABLE
38: , p7_a5 in out nocopy JTF_NUMBER_TABLE
39: , p7_a6 in out nocopy JTF_NUMBER_TABLE
40: , p7_a7 in out nocopy JTF_NUMBER_TABLE
41: , p7_a8 in out nocopy JTF_VARCHAR2_TABLE_4000
34: , p7_a1 in out nocopy JTF_NUMBER_TABLE
35: , p7_a2 in out nocopy JTF_NUMBER_TABLE
36: , p7_a3 in out nocopy JTF_NUMBER_TABLE
37: , p7_a4 in out nocopy JTF_NUMBER_TABLE
38: , p7_a5 in out nocopy JTF_NUMBER_TABLE
39: , p7_a6 in out nocopy JTF_NUMBER_TABLE
40: , p7_a7 in out nocopy JTF_NUMBER_TABLE
41: , p7_a8 in out nocopy JTF_VARCHAR2_TABLE_4000
42: , p7_a9 in out nocopy JTF_NUMBER_TABLE
35: , p7_a2 in out nocopy JTF_NUMBER_TABLE
36: , p7_a3 in out nocopy JTF_NUMBER_TABLE
37: , p7_a4 in out nocopy JTF_NUMBER_TABLE
38: , p7_a5 in out nocopy JTF_NUMBER_TABLE
39: , p7_a6 in out nocopy JTF_NUMBER_TABLE
40: , p7_a7 in out nocopy JTF_NUMBER_TABLE
41: , p7_a8 in out nocopy JTF_VARCHAR2_TABLE_4000
42: , p7_a9 in out nocopy JTF_NUMBER_TABLE
43: , p_mode VARCHAR2
36: , p7_a3 in out nocopy JTF_NUMBER_TABLE
37: , p7_a4 in out nocopy JTF_NUMBER_TABLE
38: , p7_a5 in out nocopy JTF_NUMBER_TABLE
39: , p7_a6 in out nocopy JTF_NUMBER_TABLE
40: , p7_a7 in out nocopy JTF_NUMBER_TABLE
41: , p7_a8 in out nocopy JTF_VARCHAR2_TABLE_4000
42: , p7_a9 in out nocopy JTF_NUMBER_TABLE
43: , p_mode VARCHAR2
44: );
38: , p7_a5 in out nocopy JTF_NUMBER_TABLE
39: , p7_a6 in out nocopy JTF_NUMBER_TABLE
40: , p7_a7 in out nocopy JTF_NUMBER_TABLE
41: , p7_a8 in out nocopy JTF_VARCHAR2_TABLE_4000
42: , p7_a9 in out nocopy JTF_NUMBER_TABLE
43: , p_mode VARCHAR2
44: );
45: procedure update_child_claim_tbl(p_api_version NUMBER
46: , p_init_msg_list VARCHAR2
48: , p_validation_level NUMBER
49: , x_return_status out nocopy VARCHAR2
50: , x_msg_data out nocopy VARCHAR2
51: , x_msg_count out nocopy NUMBER
52: , p7_a0 JTF_NUMBER_TABLE
53: , p7_a1 JTF_NUMBER_TABLE
54: , p7_a2 JTF_NUMBER_TABLE
55: , p7_a3 JTF_NUMBER_TABLE
56: , p7_a4 JTF_NUMBER_TABLE
49: , x_return_status out nocopy VARCHAR2
50: , x_msg_data out nocopy VARCHAR2
51: , x_msg_count out nocopy NUMBER
52: , p7_a0 JTF_NUMBER_TABLE
53: , p7_a1 JTF_NUMBER_TABLE
54: , p7_a2 JTF_NUMBER_TABLE
55: , p7_a3 JTF_NUMBER_TABLE
56: , p7_a4 JTF_NUMBER_TABLE
57: , p7_a5 JTF_NUMBER_TABLE
50: , x_msg_data out nocopy VARCHAR2
51: , x_msg_count out nocopy NUMBER
52: , p7_a0 JTF_NUMBER_TABLE
53: , p7_a1 JTF_NUMBER_TABLE
54: , p7_a2 JTF_NUMBER_TABLE
55: , p7_a3 JTF_NUMBER_TABLE
56: , p7_a4 JTF_NUMBER_TABLE
57: , p7_a5 JTF_NUMBER_TABLE
58: , p7_a6 JTF_NUMBER_TABLE
51: , x_msg_count out nocopy NUMBER
52: , p7_a0 JTF_NUMBER_TABLE
53: , p7_a1 JTF_NUMBER_TABLE
54: , p7_a2 JTF_NUMBER_TABLE
55: , p7_a3 JTF_NUMBER_TABLE
56: , p7_a4 JTF_NUMBER_TABLE
57: , p7_a5 JTF_NUMBER_TABLE
58: , p7_a6 JTF_NUMBER_TABLE
59: , p7_a7 JTF_NUMBER_TABLE
52: , p7_a0 JTF_NUMBER_TABLE
53: , p7_a1 JTF_NUMBER_TABLE
54: , p7_a2 JTF_NUMBER_TABLE
55: , p7_a3 JTF_NUMBER_TABLE
56: , p7_a4 JTF_NUMBER_TABLE
57: , p7_a5 JTF_NUMBER_TABLE
58: , p7_a6 JTF_NUMBER_TABLE
59: , p7_a7 JTF_NUMBER_TABLE
60: , p7_a8 JTF_VARCHAR2_TABLE_4000
53: , p7_a1 JTF_NUMBER_TABLE
54: , p7_a2 JTF_NUMBER_TABLE
55: , p7_a3 JTF_NUMBER_TABLE
56: , p7_a4 JTF_NUMBER_TABLE
57: , p7_a5 JTF_NUMBER_TABLE
58: , p7_a6 JTF_NUMBER_TABLE
59: , p7_a7 JTF_NUMBER_TABLE
60: , p7_a8 JTF_VARCHAR2_TABLE_4000
61: , p7_a9 JTF_NUMBER_TABLE
54: , p7_a2 JTF_NUMBER_TABLE
55: , p7_a3 JTF_NUMBER_TABLE
56: , p7_a4 JTF_NUMBER_TABLE
57: , p7_a5 JTF_NUMBER_TABLE
58: , p7_a6 JTF_NUMBER_TABLE
59: , p7_a7 JTF_NUMBER_TABLE
60: , p7_a8 JTF_VARCHAR2_TABLE_4000
61: , p7_a9 JTF_NUMBER_TABLE
62: , p_mode VARCHAR2
55: , p7_a3 JTF_NUMBER_TABLE
56: , p7_a4 JTF_NUMBER_TABLE
57: , p7_a5 JTF_NUMBER_TABLE
58: , p7_a6 JTF_NUMBER_TABLE
59: , p7_a7 JTF_NUMBER_TABLE
60: , p7_a8 JTF_VARCHAR2_TABLE_4000
61: , p7_a9 JTF_NUMBER_TABLE
62: , p_mode VARCHAR2
63: );
57: , p7_a5 JTF_NUMBER_TABLE
58: , p7_a6 JTF_NUMBER_TABLE
59: , p7_a7 JTF_NUMBER_TABLE
60: , p7_a8 JTF_VARCHAR2_TABLE_4000
61: , p7_a9 JTF_NUMBER_TABLE
62: , p_mode VARCHAR2
63: );
64: end ozf_split_claim_pvt_w;