1 package ahl_mc_node_pub_w as
2 /* $Header: AHLPNOWS.pls 120.1 2005/07/30 23:03 tamdas noship $ */
3 procedure process_node(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , p_commit VARCHAR2
6 , p_validation_level NUMBER
7 , p_module_type VARCHAR2
8 , x_return_status out nocopy VARCHAR2
9 , x_msg_count out nocopy NUMBER
10 , x_msg_data out nocopy VARCHAR2
11 , p8_a0 in out nocopy NUMBER
12 , p8_a1 in out nocopy NUMBER
13 , p8_a2 in out nocopy NUMBER
14 , p8_a3 in out nocopy VARCHAR2
15 , p8_a4 in out nocopy VARCHAR2
16 , p8_a5 in out nocopy VARCHAR2
17 , p8_a6 in out nocopy VARCHAR2
18 , p8_a7 in out nocopy VARCHAR2
19 , p8_a8 in out nocopy VARCHAR2
20 , p8_a9 in out nocopy VARCHAR2
21 , p8_a10 in out nocopy NUMBER
22 , p8_a11 in out nocopy NUMBER
23 , p8_a12 in out nocopy NUMBER
24 , p8_a13 in out nocopy VARCHAR2
25 , p8_a14 in out nocopy NUMBER
26 , p8_a15 in out nocopy DATE
27 , p8_a16 in out nocopy DATE
28 , p8_a17 in out nocopy NUMBER
29 , p8_a18 in out nocopy NUMBER
30 , p8_a19 in out nocopy VARCHAR2
31 , p8_a20 in out nocopy VARCHAR2
32 , p8_a21 in out nocopy VARCHAR2
33 , p8_a22 in out nocopy VARCHAR2
34 , p8_a23 in out nocopy VARCHAR2
35 , p8_a24 in out nocopy VARCHAR2
36 , p8_a25 in out nocopy VARCHAR2
37 , p8_a26 in out nocopy VARCHAR2
38 , p8_a27 in out nocopy VARCHAR2
39 , p8_a28 in out nocopy VARCHAR2
40 , p8_a29 in out nocopy VARCHAR2
41 , p8_a30 in out nocopy VARCHAR2
42 , p8_a31 in out nocopy VARCHAR2
43 , p8_a32 in out nocopy VARCHAR2
44 , p8_a33 in out nocopy VARCHAR2
45 , p8_a34 in out nocopy VARCHAR2
46 , p8_a35 in out nocopy VARCHAR2
47 , p8_a36 in out nocopy NUMBER
48 , p9_a0 in out nocopy JTF_NUMBER_TABLE
49 , p9_a1 in out nocopy JTF_NUMBER_TABLE
50 , p9_a2 in out nocopy JTF_VARCHAR2_TABLE_100
51 , p9_a3 in out nocopy JTF_VARCHAR2_TABLE_100
52 , p9_a4 in out nocopy JTF_VARCHAR2_TABLE_100
53 , p9_a5 in out nocopy JTF_NUMBER_TABLE
54 , p9_a6 in out nocopy JTF_NUMBER_TABLE
55 , p9_a7 in out nocopy JTF_NUMBER_TABLE
56 , p9_a8 in out nocopy JTF_VARCHAR2_TABLE_100
57 , p9_a9 in out nocopy JTF_VARCHAR2_TABLE_200
58 , p9_a10 in out nocopy JTF_VARCHAR2_TABLE_200
59 , p9_a11 in out nocopy JTF_VARCHAR2_TABLE_200
60 , p9_a12 in out nocopy JTF_VARCHAR2_TABLE_200
61 , p9_a13 in out nocopy JTF_VARCHAR2_TABLE_200
62 , p9_a14 in out nocopy JTF_VARCHAR2_TABLE_200
63 , p9_a15 in out nocopy JTF_VARCHAR2_TABLE_200
64 , p9_a16 in out nocopy JTF_VARCHAR2_TABLE_200
65 , p9_a17 in out nocopy JTF_VARCHAR2_TABLE_200
66 , p9_a18 in out nocopy JTF_VARCHAR2_TABLE_200
67 , p9_a19 in out nocopy JTF_VARCHAR2_TABLE_200
68 , p9_a20 in out nocopy JTF_VARCHAR2_TABLE_200
69 , p9_a21 in out nocopy JTF_VARCHAR2_TABLE_200
70 , p9_a22 in out nocopy JTF_VARCHAR2_TABLE_200
71 , p9_a23 in out nocopy JTF_VARCHAR2_TABLE_200
72 , p9_a24 in out nocopy JTF_VARCHAR2_TABLE_100
73 , p9_a25 in out nocopy JTF_NUMBER_TABLE
74 , p10_a0 in out nocopy JTF_NUMBER_TABLE
75 , p10_a1 in out nocopy JTF_NUMBER_TABLE
76 , p10_a2 in out nocopy JTF_VARCHAR2_TABLE_100
77 , p10_a3 in out nocopy JTF_NUMBER_TABLE
78 , p10_a4 in out nocopy JTF_NUMBER_TABLE
79 , p10_a5 in out nocopy JTF_DATE_TABLE
80 , p10_a6 in out nocopy JTF_DATE_TABLE
81 , p10_a7 in out nocopy JTF_NUMBER_TABLE
82 , p10_a8 in out nocopy JTF_NUMBER_TABLE
83 , p10_a9 in out nocopy JTF_NUMBER_TABLE
84 , p10_a10 in out nocopy JTF_VARCHAR2_TABLE_100
85 , p10_a11 in out nocopy JTF_VARCHAR2_TABLE_200
86 , p10_a12 in out nocopy JTF_VARCHAR2_TABLE_200
87 , p10_a13 in out nocopy JTF_VARCHAR2_TABLE_200
88 , p10_a14 in out nocopy JTF_VARCHAR2_TABLE_200
89 , p10_a15 in out nocopy JTF_VARCHAR2_TABLE_200
90 , p10_a16 in out nocopy JTF_VARCHAR2_TABLE_200
91 , p10_a17 in out nocopy JTF_VARCHAR2_TABLE_200
92 , p10_a18 in out nocopy JTF_VARCHAR2_TABLE_200
93 , p10_a19 in out nocopy JTF_VARCHAR2_TABLE_200
94 , p10_a20 in out nocopy JTF_VARCHAR2_TABLE_200
95 , p10_a21 in out nocopy JTF_VARCHAR2_TABLE_200
96 , p10_a22 in out nocopy JTF_VARCHAR2_TABLE_200
97 , p10_a23 in out nocopy JTF_VARCHAR2_TABLE_200
98 , p10_a24 in out nocopy JTF_VARCHAR2_TABLE_200
99 , p10_a25 in out nocopy JTF_VARCHAR2_TABLE_200
100 , p10_a26 in out nocopy JTF_VARCHAR2_TABLE_100
101 );
102 procedure delete_nodes(p_api_version NUMBER
103 , p_init_msg_list VARCHAR2
104 , p_commit VARCHAR2
105 , p_validation_level NUMBER
106 , x_return_status out nocopy VARCHAR2
107 , x_msg_count out nocopy NUMBER
108 , x_msg_data out nocopy VARCHAR2
109 , p7_a0 JTF_NUMBER_TABLE
110 , p7_a1 JTF_NUMBER_TABLE
111 , p7_a2 JTF_NUMBER_TABLE
112 , p7_a3 JTF_VARCHAR2_TABLE_100
113 , p7_a4 JTF_VARCHAR2_TABLE_100
114 , p7_a5 JTF_VARCHAR2_TABLE_100
115 , p7_a6 JTF_VARCHAR2_TABLE_100
116 , p7_a7 JTF_VARCHAR2_TABLE_100
117 , p7_a8 JTF_VARCHAR2_TABLE_100
118 , p7_a9 JTF_VARCHAR2_TABLE_100
119 , p7_a10 JTF_NUMBER_TABLE
120 , p7_a11 JTF_NUMBER_TABLE
121 , p7_a12 JTF_NUMBER_TABLE
122 , p7_a13 JTF_VARCHAR2_TABLE_100
123 , p7_a14 JTF_NUMBER_TABLE
124 , p7_a15 JTF_DATE_TABLE
125 , p7_a16 JTF_DATE_TABLE
126 , p7_a17 JTF_NUMBER_TABLE
127 , p7_a18 JTF_NUMBER_TABLE
128 , p7_a19 JTF_VARCHAR2_TABLE_100
129 , p7_a20 JTF_VARCHAR2_TABLE_200
130 , p7_a21 JTF_VARCHAR2_TABLE_200
131 , p7_a22 JTF_VARCHAR2_TABLE_200
132 , p7_a23 JTF_VARCHAR2_TABLE_200
133 , p7_a24 JTF_VARCHAR2_TABLE_200
134 , p7_a25 JTF_VARCHAR2_TABLE_200
135 , p7_a26 JTF_VARCHAR2_TABLE_200
136 , p7_a27 JTF_VARCHAR2_TABLE_200
137 , p7_a28 JTF_VARCHAR2_TABLE_200
138 , p7_a29 JTF_VARCHAR2_TABLE_200
139 , p7_a30 JTF_VARCHAR2_TABLE_200
140 , p7_a31 JTF_VARCHAR2_TABLE_200
141 , p7_a32 JTF_VARCHAR2_TABLE_200
142 , p7_a33 JTF_VARCHAR2_TABLE_200
143 , p7_a34 JTF_VARCHAR2_TABLE_200
144 , p7_a35 JTF_VARCHAR2_TABLE_100
145 , p7_a36 JTF_NUMBER_TABLE
146 );
147 end ahl_mc_node_pub_w;