APPS.CN_RATE_DIMENSIONS_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy cn_rate_dimensions_pvt.tiers_tbl_type, a0 JTF_NUMBER_TABLE

1: package cn_rate_dimensions_pvt_w as
2: /* $Header: cnwrdims.pls 120.3 2006/01/18 15:30 jxsingh ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_rate_dimensions_pvt.tiers_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

Line 4: , a1 JTF_NUMBER_TABLE

1: package cn_rate_dimensions_pvt_w as
2: /* $Header: cnwrdims.pls 120.3 2006/01/18 15:30 jxsingh ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_rate_dimensions_pvt.tiers_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

Line 5: , a2 JTF_NUMBER_TABLE

1: package cn_rate_dimensions_pvt_w as
2: /* $Header: cnwrdims.pls 120.3 2006/01/18 15:30 jxsingh ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_rate_dimensions_pvt.tiers_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

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: cnwrdims.pls 120.3 2006/01/18 15:30 jxsingh ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy cn_rate_dimensions_pvt.tiers_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

Line 7: , a4 JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p1(t out nocopy cn_rate_dimensions_pvt.tiers_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: , a8 JTF_VARCHAR2_TABLE_1000

Line 9: , a6 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: , a8 JTF_VARCHAR2_TABLE_1000
12: );
13: procedure rosetta_table_copy_out_p1(t cn_rate_dimensions_pvt.tiers_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 10: , a7 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: , a8 JTF_VARCHAR2_TABLE_1000
12: );
13: procedure rosetta_table_copy_out_p1(t cn_rate_dimensions_pvt.tiers_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE

Line 13: procedure rosetta_table_copy_out_p1(t cn_rate_dimensions_pvt.tiers_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_1000
12: );
13: procedure rosetta_table_copy_out_p1(t cn_rate_dimensions_pvt.tiers_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_NUMBER_TABLE
16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_NUMBER_TABLE

Line 14: , a1 out nocopy JTF_NUMBER_TABLE

10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_1000
12: );
13: procedure rosetta_table_copy_out_p1(t cn_rate_dimensions_pvt.tiers_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_NUMBER_TABLE
16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 15: , a2 out nocopy JTF_NUMBER_TABLE

11: , a8 JTF_VARCHAR2_TABLE_1000
12: );
13: procedure rosetta_table_copy_out_p1(t cn_rate_dimensions_pvt.tiers_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_NUMBER_TABLE
16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_VARCHAR2_TABLE_100
19: , a6 out nocopy JTF_NUMBER_TABLE

Line 16: , a3 out nocopy JTF_NUMBER_TABLE

12: );
13: procedure rosetta_table_copy_out_p1(t cn_rate_dimensions_pvt.tiers_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_NUMBER_TABLE
16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_VARCHAR2_TABLE_100
19: , a6 out nocopy JTF_NUMBER_TABLE
20: , a7 out nocopy JTF_NUMBER_TABLE

Line 17: , a4 out nocopy JTF_NUMBER_TABLE

13: procedure rosetta_table_copy_out_p1(t cn_rate_dimensions_pvt.tiers_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_NUMBER_TABLE
15: , a2 out nocopy JTF_NUMBER_TABLE
16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_VARCHAR2_TABLE_100
19: , a6 out nocopy JTF_NUMBER_TABLE
20: , a7 out nocopy JTF_NUMBER_TABLE
21: , a8 out nocopy JTF_VARCHAR2_TABLE_1000

Line 19: , a6 out nocopy JTF_NUMBER_TABLE

15: , a2 out nocopy JTF_NUMBER_TABLE
16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_VARCHAR2_TABLE_100
19: , a6 out nocopy JTF_NUMBER_TABLE
20: , a7 out nocopy JTF_NUMBER_TABLE
21: , a8 out nocopy JTF_VARCHAR2_TABLE_1000
22: );
23:

Line 20: , a7 out nocopy JTF_NUMBER_TABLE

16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_VARCHAR2_TABLE_100
19: , a6 out nocopy JTF_NUMBER_TABLE
20: , a7 out nocopy JTF_NUMBER_TABLE
21: , a8 out nocopy JTF_VARCHAR2_TABLE_1000
22: );
23:
24: procedure rosetta_table_copy_in_p2(t out nocopy cn_rate_dimensions_pvt.parent_rate_tables_tbl_type, a0 JTF_VARCHAR2_TABLE_100);

Line 35: , p8_a0 JTF_NUMBER_TABLE

31: , p_name VARCHAR2
32: , p_description VARCHAR2
33: , p_dim_unit_code VARCHAR2
34: , p_number_tier NUMBER
35: , p8_a0 JTF_NUMBER_TABLE
36: , p8_a1 JTF_NUMBER_TABLE
37: , p8_a2 JTF_NUMBER_TABLE
38: , p8_a3 JTF_NUMBER_TABLE
39: , p8_a4 JTF_NUMBER_TABLE

Line 36: , p8_a1 JTF_NUMBER_TABLE

32: , p_description VARCHAR2
33: , p_dim_unit_code VARCHAR2
34: , p_number_tier NUMBER
35: , p8_a0 JTF_NUMBER_TABLE
36: , p8_a1 JTF_NUMBER_TABLE
37: , p8_a2 JTF_NUMBER_TABLE
38: , p8_a3 JTF_NUMBER_TABLE
39: , p8_a4 JTF_NUMBER_TABLE
40: , p8_a5 JTF_VARCHAR2_TABLE_100

Line 37: , p8_a2 JTF_NUMBER_TABLE

33: , p_dim_unit_code VARCHAR2
34: , p_number_tier NUMBER
35: , p8_a0 JTF_NUMBER_TABLE
36: , p8_a1 JTF_NUMBER_TABLE
37: , p8_a2 JTF_NUMBER_TABLE
38: , p8_a3 JTF_NUMBER_TABLE
39: , p8_a4 JTF_NUMBER_TABLE
40: , p8_a5 JTF_VARCHAR2_TABLE_100
41: , p8_a6 JTF_NUMBER_TABLE

Line 38: , p8_a3 JTF_NUMBER_TABLE

34: , p_number_tier NUMBER
35: , p8_a0 JTF_NUMBER_TABLE
36: , p8_a1 JTF_NUMBER_TABLE
37: , p8_a2 JTF_NUMBER_TABLE
38: , p8_a3 JTF_NUMBER_TABLE
39: , p8_a4 JTF_NUMBER_TABLE
40: , p8_a5 JTF_VARCHAR2_TABLE_100
41: , p8_a6 JTF_NUMBER_TABLE
42: , p8_a7 JTF_NUMBER_TABLE

Line 39: , p8_a4 JTF_NUMBER_TABLE

35: , p8_a0 JTF_NUMBER_TABLE
36: , p8_a1 JTF_NUMBER_TABLE
37: , p8_a2 JTF_NUMBER_TABLE
38: , p8_a3 JTF_NUMBER_TABLE
39: , p8_a4 JTF_NUMBER_TABLE
40: , p8_a5 JTF_VARCHAR2_TABLE_100
41: , p8_a6 JTF_NUMBER_TABLE
42: , p8_a7 JTF_NUMBER_TABLE
43: , p8_a8 JTF_VARCHAR2_TABLE_1000

Line 41: , p8_a6 JTF_NUMBER_TABLE

37: , p8_a2 JTF_NUMBER_TABLE
38: , p8_a3 JTF_NUMBER_TABLE
39: , p8_a4 JTF_NUMBER_TABLE
40: , p8_a5 JTF_VARCHAR2_TABLE_100
41: , p8_a6 JTF_NUMBER_TABLE
42: , p8_a7 JTF_NUMBER_TABLE
43: , p8_a8 JTF_VARCHAR2_TABLE_1000
44: , p_org_id NUMBER
45: , x_rate_dimension_id in out nocopy NUMBER

Line 42: , p8_a7 JTF_NUMBER_TABLE

38: , p8_a3 JTF_NUMBER_TABLE
39: , p8_a4 JTF_NUMBER_TABLE
40: , p8_a5 JTF_VARCHAR2_TABLE_100
41: , p8_a6 JTF_NUMBER_TABLE
42: , p8_a7 JTF_NUMBER_TABLE
43: , p8_a8 JTF_VARCHAR2_TABLE_1000
44: , p_org_id NUMBER
45: , x_rate_dimension_id in out nocopy NUMBER
46: , x_return_status out nocopy VARCHAR2

Line 59: , p9_a0 JTF_NUMBER_TABLE

55: , p_name VARCHAR2
56: , p_description VARCHAR2
57: , p_dim_unit_code VARCHAR2
58: , p_number_tier NUMBER
59: , p9_a0 JTF_NUMBER_TABLE
60: , p9_a1 JTF_NUMBER_TABLE
61: , p9_a2 JTF_NUMBER_TABLE
62: , p9_a3 JTF_NUMBER_TABLE
63: , p9_a4 JTF_NUMBER_TABLE

Line 60: , p9_a1 JTF_NUMBER_TABLE

56: , p_description VARCHAR2
57: , p_dim_unit_code VARCHAR2
58: , p_number_tier NUMBER
59: , p9_a0 JTF_NUMBER_TABLE
60: , p9_a1 JTF_NUMBER_TABLE
61: , p9_a2 JTF_NUMBER_TABLE
62: , p9_a3 JTF_NUMBER_TABLE
63: , p9_a4 JTF_NUMBER_TABLE
64: , p9_a5 JTF_VARCHAR2_TABLE_100

Line 61: , p9_a2 JTF_NUMBER_TABLE

57: , p_dim_unit_code VARCHAR2
58: , p_number_tier NUMBER
59: , p9_a0 JTF_NUMBER_TABLE
60: , p9_a1 JTF_NUMBER_TABLE
61: , p9_a2 JTF_NUMBER_TABLE
62: , p9_a3 JTF_NUMBER_TABLE
63: , p9_a4 JTF_NUMBER_TABLE
64: , p9_a5 JTF_VARCHAR2_TABLE_100
65: , p9_a6 JTF_NUMBER_TABLE

Line 62: , p9_a3 JTF_NUMBER_TABLE

58: , p_number_tier NUMBER
59: , p9_a0 JTF_NUMBER_TABLE
60: , p9_a1 JTF_NUMBER_TABLE
61: , p9_a2 JTF_NUMBER_TABLE
62: , p9_a3 JTF_NUMBER_TABLE
63: , p9_a4 JTF_NUMBER_TABLE
64: , p9_a5 JTF_VARCHAR2_TABLE_100
65: , p9_a6 JTF_NUMBER_TABLE
66: , p9_a7 JTF_NUMBER_TABLE

Line 63: , p9_a4 JTF_NUMBER_TABLE

59: , p9_a0 JTF_NUMBER_TABLE
60: , p9_a1 JTF_NUMBER_TABLE
61: , p9_a2 JTF_NUMBER_TABLE
62: , p9_a3 JTF_NUMBER_TABLE
63: , p9_a4 JTF_NUMBER_TABLE
64: , p9_a5 JTF_VARCHAR2_TABLE_100
65: , p9_a6 JTF_NUMBER_TABLE
66: , p9_a7 JTF_NUMBER_TABLE
67: , p9_a8 JTF_VARCHAR2_TABLE_1000

Line 65: , p9_a6 JTF_NUMBER_TABLE

61: , p9_a2 JTF_NUMBER_TABLE
62: , p9_a3 JTF_NUMBER_TABLE
63: , p9_a4 JTF_NUMBER_TABLE
64: , p9_a5 JTF_VARCHAR2_TABLE_100
65: , p9_a6 JTF_NUMBER_TABLE
66: , p9_a7 JTF_NUMBER_TABLE
67: , p9_a8 JTF_VARCHAR2_TABLE_1000
68: , p_org_id NUMBER
69: , p_object_version_number in out nocopy NUMBER

Line 66: , p9_a7 JTF_NUMBER_TABLE

62: , p9_a3 JTF_NUMBER_TABLE
63: , p9_a4 JTF_NUMBER_TABLE
64: , p9_a5 JTF_VARCHAR2_TABLE_100
65: , p9_a6 JTF_NUMBER_TABLE
66: , p9_a7 JTF_NUMBER_TABLE
67: , p9_a8 JTF_VARCHAR2_TABLE_1000
68: , p_org_id NUMBER
69: , p_object_version_number in out nocopy NUMBER
70: , x_return_status out nocopy VARCHAR2