1: package ozf_reason_pvt_w as
2: /* $Header: ozfwreas.pls 120.3 2006/05/17 01:16:43 sshivali ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ozf_reason_pvt.action_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
1: package ozf_reason_pvt_w as
2: /* $Header: ozfwreas.pls 120.3 2006/05/17 01:16:43 sshivali ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ozf_reason_pvt.action_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
1: package ozf_reason_pvt_w as
2: /* $Header: ozfwreas.pls 120.3 2006/05/17 01:16:43 sshivali ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ozf_reason_pvt.action_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: );
2: /* $Header: ozfwreas.pls 120.3 2006/05/17 01:16:43 sshivali ship $ */
3: procedure rosetta_table_copy_in_p3(t out nocopy ozf_reason_pvt.action_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: );
10: procedure rosetta_table_copy_out_p3(t ozf_reason_pvt.action_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: );
10: procedure rosetta_table_copy_out_p3(t ozf_reason_pvt.action_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
11: , a1 out nocopy JTF_NUMBER_TABLE
12: , a2 out nocopy JTF_NUMBER_TABLE
13: , a3 out nocopy JTF_NUMBER_TABLE
14: , a4 out nocopy JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: );
10: procedure rosetta_table_copy_out_p3(t ozf_reason_pvt.action_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
11: , a1 out nocopy JTF_NUMBER_TABLE
12: , a2 out nocopy JTF_NUMBER_TABLE
13: , a3 out nocopy JTF_NUMBER_TABLE
14: , a4 out nocopy JTF_VARCHAR2_TABLE_100
15: , a5 out nocopy JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: );
10: procedure rosetta_table_copy_out_p3(t ozf_reason_pvt.action_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
11: , a1 out nocopy JTF_NUMBER_TABLE
12: , a2 out nocopy JTF_NUMBER_TABLE
13: , a3 out nocopy JTF_NUMBER_TABLE
14: , a4 out nocopy JTF_VARCHAR2_TABLE_100
15: , a5 out nocopy JTF_VARCHAR2_TABLE_100
16: );
9: );
10: procedure rosetta_table_copy_out_p3(t ozf_reason_pvt.action_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
11: , a1 out nocopy JTF_NUMBER_TABLE
12: , a2 out nocopy JTF_NUMBER_TABLE
13: , a3 out nocopy JTF_NUMBER_TABLE
14: , a4 out nocopy JTF_VARCHAR2_TABLE_100
15: , a5 out nocopy JTF_VARCHAR2_TABLE_100
16: );
17:
14: , a4 out nocopy JTF_VARCHAR2_TABLE_100
15: , a5 out nocopy JTF_VARCHAR2_TABLE_100
16: );
17:
18: procedure rosetta_table_copy_in_p7(t out nocopy ozf_reason_pvt.reason_tbl_type, a0 JTF_NUMBER_TABLE
19: , a1 JTF_NUMBER_TABLE
20: , a2 JTF_DATE_TABLE
21: , a3 JTF_NUMBER_TABLE
22: , a4 JTF_DATE_TABLE
15: , a5 out nocopy JTF_VARCHAR2_TABLE_100
16: );
17:
18: procedure rosetta_table_copy_in_p7(t out nocopy ozf_reason_pvt.reason_tbl_type, a0 JTF_NUMBER_TABLE
19: , a1 JTF_NUMBER_TABLE
20: , a2 JTF_DATE_TABLE
21: , a3 JTF_NUMBER_TABLE
22: , a4 JTF_DATE_TABLE
23: , a5 JTF_NUMBER_TABLE
17:
18: procedure rosetta_table_copy_in_p7(t out nocopy ozf_reason_pvt.reason_tbl_type, a0 JTF_NUMBER_TABLE
19: , a1 JTF_NUMBER_TABLE
20: , a2 JTF_DATE_TABLE
21: , a3 JTF_NUMBER_TABLE
22: , a4 JTF_DATE_TABLE
23: , a5 JTF_NUMBER_TABLE
24: , a6 JTF_NUMBER_TABLE
25: , a7 JTF_VARCHAR2_TABLE_100
19: , a1 JTF_NUMBER_TABLE
20: , a2 JTF_DATE_TABLE
21: , a3 JTF_NUMBER_TABLE
22: , a4 JTF_DATE_TABLE
23: , a5 JTF_NUMBER_TABLE
24: , a6 JTF_NUMBER_TABLE
25: , a7 JTF_VARCHAR2_TABLE_100
26: , a8 JTF_DATE_TABLE
27: , a9 JTF_DATE_TABLE
20: , a2 JTF_DATE_TABLE
21: , a3 JTF_NUMBER_TABLE
22: , a4 JTF_DATE_TABLE
23: , a5 JTF_NUMBER_TABLE
24: , a6 JTF_NUMBER_TABLE
25: , a7 JTF_VARCHAR2_TABLE_100
26: , a8 JTF_DATE_TABLE
27: , a9 JTF_DATE_TABLE
28: , a10 JTF_VARCHAR2_TABLE_100
42: , a24 JTF_VARCHAR2_TABLE_200
43: , a25 JTF_VARCHAR2_TABLE_200
44: , a26 JTF_VARCHAR2_TABLE_100
45: , a27 JTF_VARCHAR2_TABLE_2000
46: , a28 JTF_NUMBER_TABLE
47: , a29 JTF_VARCHAR2_TABLE_100
48: , a30 JTF_VARCHAR2_TABLE_100
49: , a31 JTF_VARCHAR2_TABLE_100
50: , a32 JTF_NUMBER_TABLE
46: , a28 JTF_NUMBER_TABLE
47: , a29 JTF_VARCHAR2_TABLE_100
48: , a30 JTF_VARCHAR2_TABLE_100
49: , a31 JTF_VARCHAR2_TABLE_100
50: , a32 JTF_NUMBER_TABLE
51: , a33 JTF_VARCHAR2_TABLE_100
52: );
53: procedure rosetta_table_copy_out_p7(t ozf_reason_pvt.reason_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
54: , a1 out nocopy JTF_NUMBER_TABLE
49: , a31 JTF_VARCHAR2_TABLE_100
50: , a32 JTF_NUMBER_TABLE
51: , a33 JTF_VARCHAR2_TABLE_100
52: );
53: procedure rosetta_table_copy_out_p7(t ozf_reason_pvt.reason_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
54: , a1 out nocopy JTF_NUMBER_TABLE
55: , a2 out nocopy JTF_DATE_TABLE
56: , a3 out nocopy JTF_NUMBER_TABLE
57: , a4 out nocopy JTF_DATE_TABLE
50: , a32 JTF_NUMBER_TABLE
51: , a33 JTF_VARCHAR2_TABLE_100
52: );
53: procedure rosetta_table_copy_out_p7(t ozf_reason_pvt.reason_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
54: , a1 out nocopy JTF_NUMBER_TABLE
55: , a2 out nocopy JTF_DATE_TABLE
56: , a3 out nocopy JTF_NUMBER_TABLE
57: , a4 out nocopy JTF_DATE_TABLE
58: , a5 out nocopy JTF_NUMBER_TABLE
52: );
53: procedure rosetta_table_copy_out_p7(t ozf_reason_pvt.reason_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
54: , a1 out nocopy JTF_NUMBER_TABLE
55: , a2 out nocopy JTF_DATE_TABLE
56: , a3 out nocopy JTF_NUMBER_TABLE
57: , a4 out nocopy JTF_DATE_TABLE
58: , a5 out nocopy JTF_NUMBER_TABLE
59: , a6 out nocopy JTF_NUMBER_TABLE
60: , a7 out nocopy JTF_VARCHAR2_TABLE_100
54: , a1 out nocopy JTF_NUMBER_TABLE
55: , a2 out nocopy JTF_DATE_TABLE
56: , a3 out nocopy JTF_NUMBER_TABLE
57: , a4 out nocopy JTF_DATE_TABLE
58: , a5 out nocopy JTF_NUMBER_TABLE
59: , a6 out nocopy JTF_NUMBER_TABLE
60: , a7 out nocopy JTF_VARCHAR2_TABLE_100
61: , a8 out nocopy JTF_DATE_TABLE
62: , a9 out nocopy JTF_DATE_TABLE
55: , a2 out nocopy JTF_DATE_TABLE
56: , a3 out nocopy JTF_NUMBER_TABLE
57: , a4 out nocopy JTF_DATE_TABLE
58: , a5 out nocopy JTF_NUMBER_TABLE
59: , a6 out nocopy JTF_NUMBER_TABLE
60: , a7 out nocopy JTF_VARCHAR2_TABLE_100
61: , a8 out nocopy JTF_DATE_TABLE
62: , a9 out nocopy JTF_DATE_TABLE
63: , a10 out nocopy JTF_VARCHAR2_TABLE_100
77: , a24 out nocopy JTF_VARCHAR2_TABLE_200
78: , a25 out nocopy JTF_VARCHAR2_TABLE_200
79: , a26 out nocopy JTF_VARCHAR2_TABLE_100
80: , a27 out nocopy JTF_VARCHAR2_TABLE_2000
81: , a28 out nocopy JTF_NUMBER_TABLE
82: , a29 out nocopy JTF_VARCHAR2_TABLE_100
83: , a30 out nocopy JTF_VARCHAR2_TABLE_100
84: , a31 out nocopy JTF_VARCHAR2_TABLE_100
85: , a32 out nocopy JTF_NUMBER_TABLE
81: , a28 out nocopy JTF_NUMBER_TABLE
82: , a29 out nocopy JTF_VARCHAR2_TABLE_100
83: , a30 out nocopy JTF_VARCHAR2_TABLE_100
84: , a31 out nocopy JTF_VARCHAR2_TABLE_100
85: , a32 out nocopy JTF_NUMBER_TABLE
86: , a33 out nocopy JTF_VARCHAR2_TABLE_100
87: );
88:
89: procedure create_reason(p_api_version_number NUMBER
178: , p_validation_level NUMBER
179: , x_return_status out nocopy VARCHAR2
180: , x_msg_count out nocopy NUMBER
181: , x_msg_data out nocopy VARCHAR2
182: , p7_a0 JTF_NUMBER_TABLE
183: , p7_a1 JTF_NUMBER_TABLE
184: , p7_a2 JTF_NUMBER_TABLE
185: , p7_a3 JTF_NUMBER_TABLE
186: , p7_a4 JTF_VARCHAR2_TABLE_100
179: , x_return_status out nocopy VARCHAR2
180: , x_msg_count out nocopy NUMBER
181: , x_msg_data out nocopy VARCHAR2
182: , p7_a0 JTF_NUMBER_TABLE
183: , p7_a1 JTF_NUMBER_TABLE
184: , p7_a2 JTF_NUMBER_TABLE
185: , p7_a3 JTF_NUMBER_TABLE
186: , p7_a4 JTF_VARCHAR2_TABLE_100
187: , p7_a5 JTF_VARCHAR2_TABLE_100
180: , x_msg_count out nocopy NUMBER
181: , x_msg_data out nocopy VARCHAR2
182: , p7_a0 JTF_NUMBER_TABLE
183: , p7_a1 JTF_NUMBER_TABLE
184: , p7_a2 JTF_NUMBER_TABLE
185: , p7_a3 JTF_NUMBER_TABLE
186: , p7_a4 JTF_VARCHAR2_TABLE_100
187: , p7_a5 JTF_VARCHAR2_TABLE_100
188: );
181: , x_msg_data out nocopy VARCHAR2
182: , p7_a0 JTF_NUMBER_TABLE
183: , p7_a1 JTF_NUMBER_TABLE
184: , p7_a2 JTF_NUMBER_TABLE
185: , p7_a3 JTF_NUMBER_TABLE
186: , p7_a4 JTF_VARCHAR2_TABLE_100
187: , p7_a5 JTF_VARCHAR2_TABLE_100
188: );
189: procedure check_unique_action(p0_a0 NUMBER