[Home] [Help]
PACKAGE: APPS.HZ_HIERARCHY_V2PUB_JW
Source
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
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
19 , a6 out nocopy JTF_DATE_TABLE
20 , a7 out nocopy JTF_DATE_TABLE
21 , a8 out nocopy JTF_NUMBER_TABLE
22 );
23
24 procedure is_top_parent_1(p_init_msg_list VARCHAR2
25 , p_hierarchy_type VARCHAR2
26 , p_parent_id NUMBER
27 , p_parent_table_name VARCHAR2
28 , p_parent_object_type VARCHAR2
29 , p_effective_date date
30 , x_result out nocopy VARCHAR2
31 , x_return_status out nocopy VARCHAR2
32 , x_msg_count out nocopy NUMBER
33 , x_msg_data out nocopy VARCHAR2
34 );
35 procedure check_parent_child_2(p_init_msg_list VARCHAR2
36 , p_hierarchy_type VARCHAR2
37 , p_parent_id NUMBER
38 , p_parent_table_name VARCHAR2
39 , p_parent_object_type VARCHAR2
40 , p_child_id NUMBER
41 , p_child_table_name VARCHAR2
42 , p_child_object_type VARCHAR2
43 , p_effective_date date
44 , x_result out nocopy VARCHAR2
45 , x_level_number out nocopy NUMBER
46 , x_return_status out nocopy VARCHAR2
47 , x_msg_count out nocopy NUMBER
48 , x_msg_data out nocopy VARCHAR2
49 );
50 procedure get_parent_nodes_3(p_init_msg_list VARCHAR2
51 , p_hierarchy_type VARCHAR2
52 , p_child_id NUMBER
53 , p_child_table_name VARCHAR2
54 , p_child_object_type VARCHAR2
55 , p_parent_table_name VARCHAR2
56 , p_parent_object_type VARCHAR2
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
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
70 , x_msg_count out nocopy NUMBER
71 , x_msg_data out nocopy VARCHAR2
72 );
73 procedure get_child_nodes_4(p_init_msg_list VARCHAR2
74 , p_hierarchy_type VARCHAR2
75 , p_parent_id NUMBER
76 , p_parent_table_name VARCHAR2
77 , p_parent_object_type VARCHAR2
78 , p_child_table_name VARCHAR2
79 , p_child_object_type VARCHAR2
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
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
93 , x_msg_count out nocopy NUMBER
94 , x_msg_data out nocopy VARCHAR2
95 );
96 procedure get_top_parent_nodes_5(p_init_msg_list VARCHAR2
97 , p_hierarchy_type VARCHAR2
98 , p_parent_table_name VARCHAR2
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
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
112 , x_msg_count out nocopy NUMBER
113 , x_msg_data out nocopy VARCHAR2
114 );
115 end hz_hierarchy_v2pub_jw;