[Home] [Help]
PACKAGE: APPS.AHL_MC_PATH_POSITION_PVT_W
Source
1 package ahl_mc_path_position_pvt_w as
2 /* $Header: AHLWPOSS.pls 120.1 2008/02/29 07:54:36 sathapli ship $ */
3 procedure rosetta_table_copy_in_p1(t out nocopy ahl_mc_path_position_pvt.path_position_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_DATE_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_DATE_TABLE
8 , a5 JTF_NUMBER_TABLE
9 , a6 JTF_NUMBER_TABLE
10 , a7 JTF_NUMBER_TABLE
11 , a8 JTF_NUMBER_TABLE
12 , a9 JTF_VARCHAR2_TABLE_100
13 , a10 JTF_VARCHAR2_TABLE_100
14 , a11 JTF_NUMBER_TABLE
15 , a12 JTF_NUMBER_TABLE
16 , a13 JTF_VARCHAR2_TABLE_100
17 , a14 JTF_VARCHAR2_TABLE_200
18 , a15 JTF_VARCHAR2_TABLE_200
19 , a16 JTF_VARCHAR2_TABLE_200
20 , a17 JTF_VARCHAR2_TABLE_200
21 , a18 JTF_VARCHAR2_TABLE_200
22 , a19 JTF_VARCHAR2_TABLE_200
23 , a20 JTF_VARCHAR2_TABLE_200
24 , a21 JTF_VARCHAR2_TABLE_200
25 , a22 JTF_VARCHAR2_TABLE_200
26 , a23 JTF_VARCHAR2_TABLE_200
27 , a24 JTF_VARCHAR2_TABLE_200
28 , a25 JTF_VARCHAR2_TABLE_200
29 , a26 JTF_VARCHAR2_TABLE_200
30 , a27 JTF_VARCHAR2_TABLE_200
31 , a28 JTF_VARCHAR2_TABLE_200
32 );
33 procedure rosetta_table_copy_out_p1(t ahl_mc_path_position_pvt.path_position_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34 , a1 out nocopy JTF_NUMBER_TABLE
35 , a2 out nocopy JTF_DATE_TABLE
36 , a3 out nocopy JTF_NUMBER_TABLE
37 , a4 out nocopy JTF_DATE_TABLE
38 , a5 out nocopy JTF_NUMBER_TABLE
39 , a6 out nocopy JTF_NUMBER_TABLE
40 , a7 out nocopy JTF_NUMBER_TABLE
41 , a8 out nocopy JTF_NUMBER_TABLE
42 , a9 out nocopy JTF_VARCHAR2_TABLE_100
43 , a10 out nocopy JTF_VARCHAR2_TABLE_100
44 , a11 out nocopy JTF_NUMBER_TABLE
45 , a12 out nocopy JTF_NUMBER_TABLE
46 , a13 out nocopy JTF_VARCHAR2_TABLE_100
47 , a14 out nocopy JTF_VARCHAR2_TABLE_200
48 , a15 out nocopy JTF_VARCHAR2_TABLE_200
49 , a16 out nocopy JTF_VARCHAR2_TABLE_200
50 , a17 out nocopy JTF_VARCHAR2_TABLE_200
51 , a18 out nocopy JTF_VARCHAR2_TABLE_200
52 , a19 out nocopy JTF_VARCHAR2_TABLE_200
53 , a20 out nocopy JTF_VARCHAR2_TABLE_200
54 , a21 out nocopy JTF_VARCHAR2_TABLE_200
55 , a22 out nocopy JTF_VARCHAR2_TABLE_200
56 , a23 out nocopy JTF_VARCHAR2_TABLE_200
57 , a24 out nocopy JTF_VARCHAR2_TABLE_200
58 , a25 out nocopy JTF_VARCHAR2_TABLE_200
59 , a26 out nocopy JTF_VARCHAR2_TABLE_200
60 , a27 out nocopy JTF_VARCHAR2_TABLE_200
61 , a28 out nocopy JTF_VARCHAR2_TABLE_200
62 );
63
64 procedure create_position_id(p_api_version NUMBER
65 , p_init_msg_list VARCHAR2
66 , p_commit VARCHAR2
67 , p_validation_level NUMBER
68 , x_return_status out nocopy VARCHAR2
69 , x_msg_count out nocopy NUMBER
70 , x_msg_data out nocopy VARCHAR2
71 , p7_a0 JTF_NUMBER_TABLE
72 , p7_a1 JTF_NUMBER_TABLE
73 , p7_a2 JTF_DATE_TABLE
74 , p7_a3 JTF_NUMBER_TABLE
75 , p7_a4 JTF_DATE_TABLE
76 , p7_a5 JTF_NUMBER_TABLE
77 , p7_a6 JTF_NUMBER_TABLE
78 , p7_a7 JTF_NUMBER_TABLE
79 , p7_a8 JTF_NUMBER_TABLE
80 , p7_a9 JTF_VARCHAR2_TABLE_100
81 , p7_a10 JTF_VARCHAR2_TABLE_100
82 , p7_a11 JTF_NUMBER_TABLE
83 , p7_a12 JTF_NUMBER_TABLE
84 , p7_a13 JTF_VARCHAR2_TABLE_100
85 , p7_a14 JTF_VARCHAR2_TABLE_200
86 , p7_a15 JTF_VARCHAR2_TABLE_200
87 , p7_a16 JTF_VARCHAR2_TABLE_200
88 , p7_a17 JTF_VARCHAR2_TABLE_200
89 , p7_a18 JTF_VARCHAR2_TABLE_200
90 , p7_a19 JTF_VARCHAR2_TABLE_200
91 , p7_a20 JTF_VARCHAR2_TABLE_200
92 , p7_a21 JTF_VARCHAR2_TABLE_200
93 , p7_a22 JTF_VARCHAR2_TABLE_200
94 , p7_a23 JTF_VARCHAR2_TABLE_200
95 , p7_a24 JTF_VARCHAR2_TABLE_200
96 , p7_a25 JTF_VARCHAR2_TABLE_200
97 , p7_a26 JTF_VARCHAR2_TABLE_200
98 , p7_a27 JTF_VARCHAR2_TABLE_200
99 , p7_a28 JTF_VARCHAR2_TABLE_200
100 , p_position_ref_meaning VARCHAR2
101 , p_position_ref_code VARCHAR2
102 , x_position_id out nocopy NUMBER
103 );
104 function get_posref_by_path(p0_a0 JTF_NUMBER_TABLE
105 , p0_a1 JTF_NUMBER_TABLE
106 , p0_a2 JTF_DATE_TABLE
107 , p0_a3 JTF_NUMBER_TABLE
108 , p0_a4 JTF_DATE_TABLE
109 , p0_a5 JTF_NUMBER_TABLE
110 , p0_a6 JTF_NUMBER_TABLE
111 , p0_a7 JTF_NUMBER_TABLE
112 , p0_a8 JTF_NUMBER_TABLE
113 , p0_a9 JTF_VARCHAR2_TABLE_100
114 , p0_a10 JTF_VARCHAR2_TABLE_100
115 , p0_a11 JTF_NUMBER_TABLE
116 , p0_a12 JTF_NUMBER_TABLE
117 , p0_a13 JTF_VARCHAR2_TABLE_100
118 , p0_a14 JTF_VARCHAR2_TABLE_200
119 , p0_a15 JTF_VARCHAR2_TABLE_200
120 , p0_a16 JTF_VARCHAR2_TABLE_200
121 , p0_a17 JTF_VARCHAR2_TABLE_200
122 , p0_a18 JTF_VARCHAR2_TABLE_200
123 , p0_a19 JTF_VARCHAR2_TABLE_200
124 , p0_a20 JTF_VARCHAR2_TABLE_200
125 , p0_a21 JTF_VARCHAR2_TABLE_200
126 , p0_a22 JTF_VARCHAR2_TABLE_200
127 , p0_a23 JTF_VARCHAR2_TABLE_200
128 , p0_a24 JTF_VARCHAR2_TABLE_200
129 , p0_a25 JTF_VARCHAR2_TABLE_200
130 , p0_a26 JTF_VARCHAR2_TABLE_200
131 , p0_a27 JTF_VARCHAR2_TABLE_200
132 , p0_a28 JTF_VARCHAR2_TABLE_200
133 , p_code_flag VARCHAR2
134 ) return varchar2;
135 procedure check_pos_ref_path(p_from_csi_id NUMBER
136 , p_to_csi_id NUMBER
137 , ddrosetta_retval_bool OUT NOCOPY NUMBER
138 );
139 function encode(p0_a0 JTF_NUMBER_TABLE
140 , p0_a1 JTF_NUMBER_TABLE
141 , p0_a2 JTF_DATE_TABLE
142 , p0_a3 JTF_NUMBER_TABLE
143 , p0_a4 JTF_DATE_TABLE
144 , p0_a5 JTF_NUMBER_TABLE
145 , p0_a6 JTF_NUMBER_TABLE
146 , p0_a7 JTF_NUMBER_TABLE
147 , p0_a8 JTF_NUMBER_TABLE
148 , p0_a9 JTF_VARCHAR2_TABLE_100
149 , p0_a10 JTF_VARCHAR2_TABLE_100
150 , p0_a11 JTF_NUMBER_TABLE
151 , p0_a12 JTF_NUMBER_TABLE
152 , p0_a13 JTF_VARCHAR2_TABLE_100
153 , p0_a14 JTF_VARCHAR2_TABLE_200
154 , p0_a15 JTF_VARCHAR2_TABLE_200
155 , p0_a16 JTF_VARCHAR2_TABLE_200
156 , p0_a17 JTF_VARCHAR2_TABLE_200
157 , p0_a18 JTF_VARCHAR2_TABLE_200
158 , p0_a19 JTF_VARCHAR2_TABLE_200
159 , p0_a20 JTF_VARCHAR2_TABLE_200
160 , p0_a21 JTF_VARCHAR2_TABLE_200
161 , p0_a22 JTF_VARCHAR2_TABLE_200
162 , p0_a23 JTF_VARCHAR2_TABLE_200
163 , p0_a24 JTF_VARCHAR2_TABLE_200
164 , p0_a25 JTF_VARCHAR2_TABLE_200
165 , p0_a26 JTF_VARCHAR2_TABLE_200
166 , p0_a27 JTF_VARCHAR2_TABLE_200
167 , p0_a28 JTF_VARCHAR2_TABLE_200
168 ) return varchar2;
169 end ahl_mc_path_position_pvt_w;