APPS.HZ_HIERARCHY_V2PUB_JW dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package hz_hierarchy_v2pub_jw as
2: /* $Header: ARH2HIJS.pls 120.2 2005/06/18 04:28:21 jhuang noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy hz_hierarchy_v2pub.related_nodes_list_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package hz_hierarchy_v2pub_jw as
2: /* $Header: ARH2HIJS.pls 120.2 2005/06/18 04:28:21 jhuang noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy hz_hierarchy_v2pub.related_nodes_list_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_DATE_TABLE

Line 7: , a4 JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p1(t out nocopy hz_hierarchy_v2pub.related_nodes_list_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE

Line 8: , a5 JTF_VARCHAR2_TABLE_100

4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: );

Line 14: , a1 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 15: , a2 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 17: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 18: , a5 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 61: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100

57: , p_include_node VARCHAR2
58: , p_effective_date date
59: , p_no_of_records NUMBER
60: , p10_a0 out nocopy JTF_NUMBER_TABLE
61: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
62: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
63: , p10_a3 out nocopy JTF_NUMBER_TABLE
64: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
65: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 62: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100

58: , p_effective_date date
59: , p_no_of_records NUMBER
60: , p10_a0 out nocopy JTF_NUMBER_TABLE
61: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
62: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
63: , p10_a3 out nocopy JTF_NUMBER_TABLE
64: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
65: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
66: , p10_a6 out nocopy JTF_DATE_TABLE

Line 64: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100

60: , p10_a0 out nocopy JTF_NUMBER_TABLE
61: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
62: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
63: , p10_a3 out nocopy JTF_NUMBER_TABLE
64: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
65: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
66: , p10_a6 out nocopy JTF_DATE_TABLE
67: , p10_a7 out nocopy JTF_DATE_TABLE
68: , p10_a8 out nocopy JTF_NUMBER_TABLE

Line 65: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100

61: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
62: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
63: , p10_a3 out nocopy JTF_NUMBER_TABLE
64: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
65: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
66: , p10_a6 out nocopy JTF_DATE_TABLE
67: , p10_a7 out nocopy JTF_DATE_TABLE
68: , p10_a8 out nocopy JTF_NUMBER_TABLE
69: , x_return_status out nocopy VARCHAR2

Line 84: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100

80: , p_include_node VARCHAR2
81: , p_effective_date date
82: , p_no_of_records NUMBER
83: , p10_a0 out nocopy JTF_NUMBER_TABLE
84: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
85: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
86: , p10_a3 out nocopy JTF_NUMBER_TABLE
87: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
88: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 85: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100

81: , p_effective_date date
82: , p_no_of_records NUMBER
83: , p10_a0 out nocopy JTF_NUMBER_TABLE
84: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
85: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
86: , p10_a3 out nocopy JTF_NUMBER_TABLE
87: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
88: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
89: , p10_a6 out nocopy JTF_DATE_TABLE

Line 87: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100

83: , p10_a0 out nocopy JTF_NUMBER_TABLE
84: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
85: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
86: , p10_a3 out nocopy JTF_NUMBER_TABLE
87: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
88: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
89: , p10_a6 out nocopy JTF_DATE_TABLE
90: , p10_a7 out nocopy JTF_DATE_TABLE
91: , p10_a8 out nocopy JTF_NUMBER_TABLE

Line 88: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100

84: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_100
85: , p10_a2 out nocopy JTF_VARCHAR2_TABLE_100
86: , p10_a3 out nocopy JTF_NUMBER_TABLE
87: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_100
88: , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
89: , p10_a6 out nocopy JTF_DATE_TABLE
90: , p10_a7 out nocopy JTF_DATE_TABLE
91: , p10_a8 out nocopy JTF_NUMBER_TABLE
92: , x_return_status out nocopy VARCHAR2

Line 103: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

99: , p_parent_object_type VARCHAR2
100: , p_effective_date date
101: , p_no_of_records NUMBER
102: , p6_a0 out nocopy JTF_NUMBER_TABLE
103: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
104: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
105: , p6_a3 out nocopy JTF_NUMBER_TABLE
106: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
107: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 104: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

100: , p_effective_date date
101: , p_no_of_records NUMBER
102: , p6_a0 out nocopy JTF_NUMBER_TABLE
103: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
104: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
105: , p6_a3 out nocopy JTF_NUMBER_TABLE
106: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
107: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
108: , p6_a6 out nocopy JTF_DATE_TABLE

Line 106: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100

102: , p6_a0 out nocopy JTF_NUMBER_TABLE
103: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
104: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
105: , p6_a3 out nocopy JTF_NUMBER_TABLE
106: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
107: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
108: , p6_a6 out nocopy JTF_DATE_TABLE
109: , p6_a7 out nocopy JTF_DATE_TABLE
110: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 107: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

103: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
104: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
105: , p6_a3 out nocopy JTF_NUMBER_TABLE
106: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
107: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
108: , p6_a6 out nocopy JTF_DATE_TABLE
109: , p6_a7 out nocopy JTF_DATE_TABLE
110: , p6_a8 out nocopy JTF_NUMBER_TABLE
111: , x_return_status out nocopy VARCHAR2