DBA Data[Home] [Help]

APPS.OZF_REASON_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p3(t out nocopy ozf_reason_pvt.action_tbl_type, a0 JTF_NUMBER_TABLE

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

Line 4: , a1 JTF_NUMBER_TABLE

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

Line 5: , a2 JTF_NUMBER_TABLE

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: );

Line 6: , a3 JTF_NUMBER_TABLE

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

Line 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

Line 11: , a1 out nocopy 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
15: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 12: , a2 out nocopy JTF_NUMBER_TABLE

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: );

Line 13: , a3 out nocopy JTF_NUMBER_TABLE

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:

Line 18: procedure rosetta_table_copy_in_p7(t out nocopy ozf_reason_pvt.reason_tbl_type, a0 JTF_NUMBER_TABLE

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

Line 19: , a1 JTF_NUMBER_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

Line 21: , a3 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

Line 23: , a5 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
26: , a8 JTF_DATE_TABLE
27: , a9 JTF_DATE_TABLE

Line 24: , a6 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
28: , a10 JTF_VARCHAR2_TABLE_100

Line 46: , a28 JTF_NUMBER_TABLE

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

Line 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

Line 53: procedure rosetta_table_copy_out_p7(t ozf_reason_pvt.reason_tbl_type, a0 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

Line 54: , a1 out nocopy JTF_NUMBER_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

Line 56: , a3 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

Line 58: , a5 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
61: , a8 out nocopy JTF_DATE_TABLE
62: , a9 out nocopy JTF_DATE_TABLE

Line 59: , a6 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
63: , a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 81: , a28 out nocopy JTF_NUMBER_TABLE

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

Line 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

Line 182: , p7_a0 JTF_NUMBER_TABLE

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

Line 183: , p7_a1 JTF_NUMBER_TABLE

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

Line 184: , p7_a2 JTF_NUMBER_TABLE

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: );

Line 185: , p7_a3 JTF_NUMBER_TABLE

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