1 PACKAGE GHG_ORG_ACCOUNT_MAPPINGS_PKG AUTHID CURRENT_USER AS
2 /*$Header: ghgorams.pls 120.1.12020000.3 2013/03/11 04:52:29 mgijare ship $ */
3
4 PROCEDURE insert_row (x_rowid IN OUT NOCOPY VARCHAR2,
5 x_facility_mapping_id NUMBER,
6 x_facility_id NUMBER,
7 x_segment1_low VARCHAR2,
8 x_segment1_high VARCHAR2,
9 x_segment2_low VARCHAR2,
10 x_segment2_high VARCHAR2,
11 x_segment3_low VARCHAR2,
12 x_segment3_high VARCHAR2,
13 x_segment4_low VARCHAR2,
14 x_segment4_high VARCHAR2,
15 x_segment5_low VARCHAR2,
16 x_segment5_high VARCHAR2,
17 x_segment6_low VARCHAR2,
18 x_segment6_high VARCHAR2,
19 x_segment7_low VARCHAR2,
20 x_segment7_high VARCHAR2,
21 x_segment8_low VARCHAR2,
22 x_segment8_high VARCHAR2,
23 x_segment9_low VARCHAR2,
24 x_segment9_high VARCHAR2,
25 x_segment10_low VARCHAR2,
26 x_segment10_high VARCHAR2,
27 x_segment11_low VARCHAR2,
28 x_segment11_high VARCHAR2,
29 x_segment12_low VARCHAR2,
30 x_segment12_high VARCHAR2,
31 x_segment13_low VARCHAR2,
32 x_segment13_high VARCHAR2,
33 x_segment14_low VARCHAR2,
34 x_segment14_high VARCHAR2,
35 x_segment15_low VARCHAR2,
36 x_segment15_high VARCHAR2,
37 x_segment16_low VARCHAR2,
38 x_segment16_high VARCHAR2,
39 x_segment17_low VARCHAR2,
40 x_segment17_high VARCHAR2,
41 x_segment18_low VARCHAR2,
42 x_segment18_high VARCHAR2,
43 x_segment19_low VARCHAR2,
44 x_segment19_high VARCHAR2,
45 x_segment20_low VARCHAR2,
46 x_segment20_high VARCHAR2,
47 x_segment21_low VARCHAR2,
48 x_segment21_high VARCHAR2,
49 x_segment22_low VARCHAR2,
50 x_segment22_high VARCHAR2,
51 x_segment23_low VARCHAR2,
52 x_segment23_high VARCHAR2,
53 x_segment24_low VARCHAR2,
54 x_segment24_high VARCHAR2,
55 x_segment25_low VARCHAR2,
56 x_segment25_high VARCHAR2,
57 x_segment26_low VARCHAR2,
58 x_segment26_high VARCHAR2,
59 x_segment27_low VARCHAR2,
60 x_segment27_high VARCHAR2,
61 x_segment28_low VARCHAR2,
62 x_segment28_high VARCHAR2,
63 x_segment29_low VARCHAR2,
64 x_segment29_high VARCHAR2,
65 x_segment30_low VARCHAR2,
66 x_segment30_high VARCHAR2,
67 x_chart_of_accounts_id NUMBER,
68 x_org_id NUMBER,
69 x_set_of_books_id NUMBER,
70 x_start_date DATE,
71 x_end_date DATE,
72 x_created_by NUMBER,
73 x_creation_date DATE,
74 x_last_updated_by NUMBER,
75 x_last_update_date DATE,
76 x_last_update_login NUMBER);
77
78 PROCEDURE update_row (x_rowid IN OUT NOCOPY VARCHAR2,
79 x_facility_mapping_id NUMBER,
80 x_facility_id NUMBER,
81 x_segment1_low VARCHAR2,
82 x_segment1_high VARCHAR2,
83 x_segment2_low VARCHAR2,
84 x_segment2_high VARCHAR2,
85 x_segment3_low VARCHAR2,
86 x_segment3_high VARCHAR2,
87 x_segment4_low VARCHAR2,
88 x_segment4_high VARCHAR2,
89 x_segment5_low VARCHAR2,
90 x_segment5_high VARCHAR2,
91 x_segment6_low VARCHAR2,
92 x_segment6_high VARCHAR2,
93 x_segment7_low VARCHAR2,
94 x_segment7_high VARCHAR2,
95 x_segment8_low VARCHAR2,
96 x_segment8_high VARCHAR2,
97 x_segment9_low VARCHAR2,
98 x_segment9_high VARCHAR2,
99 x_segment10_low VARCHAR2,
100 x_segment10_high VARCHAR2,
101 x_segment11_low VARCHAR2,
102 x_segment11_high VARCHAR2,
103 x_segment12_low VARCHAR2,
104 x_segment12_high VARCHAR2,
105 x_segment13_low VARCHAR2,
106 x_segment13_high VARCHAR2,
107 x_segment14_low VARCHAR2,
108 x_segment14_high VARCHAR2,
109 x_segment15_low VARCHAR2,
110 x_segment15_high VARCHAR2,
111 x_segment16_low VARCHAR2,
112 x_segment16_high VARCHAR2,
113 x_segment17_low VARCHAR2,
114 x_segment17_high VARCHAR2,
115 x_segment18_low VARCHAR2,
116 x_segment18_high VARCHAR2,
117 x_segment19_low VARCHAR2,
118 x_segment19_high VARCHAR2,
119 x_segment20_low VARCHAR2,
120 x_segment20_high VARCHAR2,
121 x_segment21_low VARCHAR2,
122 x_segment21_high VARCHAR2,
123 x_segment22_low VARCHAR2,
124 x_segment22_high VARCHAR2,
125 x_segment23_low VARCHAR2,
126 x_segment23_high VARCHAR2,
127 x_segment24_low VARCHAR2,
128 x_segment24_high VARCHAR2,
129 x_segment25_low VARCHAR2,
130 x_segment25_high VARCHAR2,
131 x_segment26_low VARCHAR2,
132 x_segment26_high VARCHAR2,
133 x_segment27_low VARCHAR2,
134 x_segment27_high VARCHAR2,
135 x_segment28_low VARCHAR2,
136 x_segment28_high VARCHAR2,
137 x_segment29_low VARCHAR2,
138 x_segment29_high VARCHAR2,
139 x_segment30_low VARCHAR2,
140 x_segment30_high VARCHAR2,
141 x_chart_of_accounts_id NUMBER,
142 x_org_id NUMBER,
143 x_set_of_books_id NUMBER,
144 x_start_date DATE,
145 x_end_date DATE,
146 x_created_by NUMBER,
147 x_creation_date DATE,
148 x_last_updated_by NUMBER,
149 x_last_update_date DATE,
150 x_last_update_login NUMBER);
151
152 PROCEDURE delete_row(x_facility_mapping_id NUMBER);
153
154 PROCEDURE lock_row (x_rowid IN OUT NOCOPY VARCHAR2,
155 x_facility_mapping_id NUMBER,
156 x_facility_id NUMBER,
157 x_segment1_low VARCHAR2,
158 x_segment1_high VARCHAR2,
159 x_segment2_low VARCHAR2,
160 x_segment2_high VARCHAR2,
161 x_segment3_low VARCHAR2,
162 x_segment3_high VARCHAR2,
163 x_segment4_low VARCHAR2,
164 x_segment4_high VARCHAR2,
165 x_segment5_low VARCHAR2,
166 x_segment5_high VARCHAR2,
167 x_segment6_low VARCHAR2,
168 x_segment6_high VARCHAR2,
169 x_segment7_low VARCHAR2,
170 x_segment7_high VARCHAR2,
171 x_segment8_low VARCHAR2,
172 x_segment8_high VARCHAR2,
173 x_segment9_low VARCHAR2,
174 x_segment9_high VARCHAR2,
175 x_segment10_low VARCHAR2,
176 x_segment10_high VARCHAR2,
177 x_segment11_low VARCHAR2,
178 x_segment11_high VARCHAR2,
179 x_segment12_low VARCHAR2,
180 x_segment12_high VARCHAR2,
181 x_segment13_low VARCHAR2,
182 x_segment13_high VARCHAR2,
183 x_segment14_low VARCHAR2,
184 x_segment14_high VARCHAR2,
185 x_segment15_low VARCHAR2,
186 x_segment15_high VARCHAR2,
187 x_segment16_low VARCHAR2,
188 x_segment16_high VARCHAR2,
189 x_segment17_low VARCHAR2,
190 x_segment17_high VARCHAR2,
191 x_segment18_low VARCHAR2,
192 x_segment18_high VARCHAR2,
193 x_segment19_low VARCHAR2,
194 x_segment19_high VARCHAR2,
195 x_segment20_low VARCHAR2,
196 x_segment20_high VARCHAR2,
197 x_segment21_low VARCHAR2,
198 x_segment21_high VARCHAR2,
199 x_segment22_low VARCHAR2,
200 x_segment22_high VARCHAR2,
201 x_segment23_low VARCHAR2,
202 x_segment23_high VARCHAR2,
203 x_segment24_low VARCHAR2,
204 x_segment24_high VARCHAR2,
205 x_segment25_low VARCHAR2,
206 x_segment25_high VARCHAR2,
207 x_segment26_low VARCHAR2,
208 x_segment26_high VARCHAR2,
209 x_segment27_low VARCHAR2,
210 x_segment27_high VARCHAR2,
211 x_segment28_low VARCHAR2,
212 x_segment28_high VARCHAR2,
213 x_segment29_low VARCHAR2,
214 x_segment29_high VARCHAR2,
215 x_segment30_low VARCHAR2,
216 x_segment30_high VARCHAR2,
217 x_chart_of_accounts_id NUMBER,
218 x_org_id NUMBER,
219 x_set_of_books_id NUMBER,
220 x_start_date DATE,
221 x_end_date DATE,
222 x_created_by NUMBER,
223 x_creation_date DATE,
224 x_last_updated_by NUMBER,
225 x_last_update_date DATE,
226 x_last_update_login NUMBER);
227
228 FUNCTION get_mapping_count(v_facility_mapping_id NUMBER) RETURN NUMBER;
229
230 END GHG_ORG_ACCOUNT_MAPPINGS_PKG;
|
|
|