1 PACKAGE ap_mo_cache_utils AUTHID CURRENT_USER AS
2 /* $Header: apmocshs.pls 120.12.12010000.2 2008/11/11 13:04:06 dcshanmu ship $ */
3
4 --
5 -- Define a record type that encapsulates one row of operating
6 -- unit attribute
7 --
8 TYPE GlobalsRecord IS RECORD (
9 --
10 -- Generic columns needed by all products
11 --
12 org_id hr_organization_information.organization_id%TYPE,
13 set_of_books_id gl_sets_of_books.set_of_books_id%TYPE,
14 set_of_books_name gl_sets_of_books.name%TYPE,
15 set_of_books_short_name gl_sets_of_books.short_name%TYPE,
16 chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE,
17 enable_budget_control_flag gl_sets_of_books.enable_budgetary_control_flag%TYPE,
18 currency fnd_currencies.currency_code%TYPE,
19 --
20 -- << Begin AP-specific fields >>
21 --
22 sp_base_currency_code ap_system_parameters.base_currency_code%TYPE,
23 sp_multi_currency_flag ap_system_parameters.multi_currency_flag%TYPE,
24 --Bug :2809214 MOAC - Supplier Attribute Change Project
25 --sp_invoice_currency_code ap_product_setup.invoice_currency_code%TYPE,
26 sp_payment_currency_code ap_system_parameters.payment_currency_code%TYPE,
27 sp_confirm_date_inv_num_flag ap_system_parameters.confirm_date_as_inv_num_flag%TYPE,
28 sp_accts_pay_cc_id ap_system_parameters.accts_pay_code_combination_id%TYPE,
29 sp_allow_flex_override_flag ap_system_parameters.allow_flex_override_flag%TYPE,
30 sp_allow_final_match_flag ap_system_parameters.allow_final_match_flag%TYPE,
31 sp_allow_dist_match_flag ap_system_parameters.allow_dist_match_flag%TYPE,
32 sp_gl_date_from_receipt_flag ap_system_parameters.gl_date_from_receipt_flag%TYPE,
33 sp_income_tax_region_flag ap_system_parameters.income_tax_region_flag%TYPE,
34 sp_income_tax_region ap_system_parameters.income_tax_region%TYPE,
35 sp_auto_create_freight_flag ap_system_parameters.auto_create_freight_flag%TYPE,
36 sp_default_freight_cc_id ap_system_parameters.freight_code_combination_id%TYPE,
37 sp_disc_is_inv_less_tax_flag ap_system_parameters.disc_is_inv_less_tax_flag%TYPE,
38 sp_discount_dist_method ap_system_parameters.discount_distribution_method%TYPE,
39 sp_inv_doc_category_override ap_system_parameters.inv_doc_category_override%TYPE,
40 sp_approvals_option ap_system_parameters.approvals_option%TYPE,
41 sp_combined_filing_flag ap_system_parameters.combined_filing_flag%TYPE,
42 sp_allow_awt_flag ap_system_parameters.allow_awt_flag%TYPE,
43 sp_create_awt_dists_type ap_system_parameters.create_awt_dists_type%TYPE,
44 sp_allow_awt_override ap_system_parameters.allow_awt_override%TYPE,
45 sp_awt_include_tax_amt ap_system_parameters.awt_include_tax_amt%TYPE,
46 sp_awt_include_discount_amt ap_system_parameters.awt_include_discount_amt%TYPE,
47 sp_allow_paid_invoice_adjust ap_system_parameters.allow_paid_invoice_adjust%TYPE,
48 sp_add_days_settlement_date ap_system_parameters.add_days_settlement_date%TYPE,
49 sp_prepayment_terms_id ap_system_parameters.prepayment_terms_id%TYPE,
50 sp_ap_prepayment_term_name ap_terms.name%TYPE,
51 sp_prepay_cc_id ap_system_parameters.prepay_code_combination_id%TYPE,
52 sp_future_dated_pmt_acct_s ap_system_parameters.future_dated_pmt_acct_source%TYPE,
53 sp_calc_user_xrate ap_system_parameters.calc_user_xrate%TYPE,
54 sp_make_rate_mandatory_flag ap_system_parameters.make_rate_mandatory_flag%TYPE,
55 sp_def_exchange_rate_type ap_system_parameters.default_exchange_rate_type%TYPE,
56 sp_post_dated_payments_flag ap_system_parameters.post_dated_payments_flag%TYPE,
57 sp_update_pay_site_flag ap_system_parameters.update_pay_site_flag%TYPE,
58 sp_online_print_flag ap_system_parameters.online_print_flag%TYPE,
59 sp_replace_check_flag ap_system_parameters.replace_check_flag%TYPE,
60 sp_auto_calc_interest_flag ap_product_setup.auto_calculate_interest_flag%TYPE,
61 sp_interest_tolerance_amount ap_system_parameters.interest_tolerance_amount%TYPE,
62 sp_interest_accts_pay_ccid ap_system_parameters.interest_accts_pay_ccid%TYPE,
63 --Bug :2809214 MOAC - Supplier Attribute Change Project
64 --5007989, uncommented line below
65 sp_use_bank_charge_flag ap_system_parameters.use_bank_charge_flag%TYPE,
66 sp_allow_supp_bank_override ap_system_parameters.allow_supplier_bank_override%TYPE,
67 sp_pay_doc_category_override ap_system_parameters.pay_doc_category_override%TYPE,
68 sp_days_between_check_cycles ap_system_parameters.days_between_check_cycles%TYPE,
69 sp_approval_workflow_flag ap_system_parameters.approval_workflow_flag%TYPE,
70 sp_allow_force_approval_flag ap_system_parameters.allow_force_approval_flag%TYPE,
71 sp_validate_before_approval ap_system_parameters.validate_before_approval_flag%TYPE,
72 sp_global_attribute_category ap_system_parameters.global_attribute_category%TYPE,
73 sp_global_attribute1 ap_system_parameters.global_attribute1%TYPE,
74 sp_global_attribute2 ap_system_parameters.global_attribute2%TYPE,
75 sp_global_attribute3 ap_system_parameters.global_attribute3%TYPE,
76 sp_global_attribute4 ap_system_parameters.global_attribute4%TYPE,
77 sp_global_attribute5 ap_system_parameters.global_attribute5%TYPE,
78 sp_global_attribute6 ap_system_parameters.global_attribute6%TYPE,
79 sp_global_attribute7 ap_system_parameters.global_attribute7%TYPE,
80 sp_global_attribute8 ap_system_parameters.global_attribute8%TYPE,
81 sp_global_attribute9 ap_system_parameters.global_attribute9%TYPE,
82 sp_global_attribute10 ap_system_parameters.global_attribute10%TYPE,
83 sp_global_attribute11 ap_system_parameters.global_attribute11%TYPE,
84 sp_global_attribute12 ap_system_parameters.global_attribute12%TYPE,
85 sp_global_attribute13 ap_system_parameters.global_attribute13%TYPE,
86 sp_global_attribute14 ap_system_parameters.global_attribute14%TYPE,
87 sp_global_attribute15 ap_system_parameters.global_attribute15%TYPE,
88 sp_global_attribute16 ap_system_parameters.global_attribute16%TYPE,
89 sp_global_attribute17 ap_system_parameters.global_attribute17%TYPE,
90 sp_global_attribute18 ap_system_parameters.global_attribute18%TYPE,
91 sp_global_attribute19 ap_system_parameters.global_attribute19%TYPE,
92 sp_global_attribute20 ap_system_parameters.global_attribute20%TYPE,
93 fsp_purch_encumbrance_flag financials_system_parameters.purch_encumbrance_flag%TYPE,
94 fsp_inventory_org_id financials_system_parameters.inventory_organization_id%TYPE,
95 --Bug :2809214 MOAC - Supplier Attribute Change Project
96 --fsp_match_option ap_product_setup.match_option%TYPE,
97 fsp_vat_country_code financials_system_parameters.vat_country_code%TYPE,
98 sp_aba_bank_account_id ap_system_parameters.ce_bank_acct_use_id%TYPE,
99 sp_aba_bank_account_name ce_bank_accounts.bank_account_name%TYPE,
100 sp_aba_zero_amounts_allowed ce_bank_accounts.zero_amount_allowed%TYPE,
101 sp_aba_max_outlay ce_bank_accounts.max_outlay%TYPE,
102 sp_aba_max_check_amount ce_bank_accounts.max_check_amount%TYPE,
103 sp_aba_min_check_amount ce_bank_accounts.min_check_amount%TYPE,
104 sp_aba_currency_code ce_bank_accounts.currency_code%TYPE,
105 sp_aba_multi_currency_flag ce_bank_accounts.multi_currency_allowed_flag%TYPE,
106 sp_gdct_user_conversion_type gl_daily_conversion_types.user_conversion_type%TYPE,
107 mrc_enabled Varchar2(1) ,
108 sp_allow_interest_invoices ap_system_parameters.auto_calculate_interest_flag%TYPE,
109 sp_approval_timing ap_system_parameters.approval_timing%TYPE, --Bug4299234
110 fsp_misc_charge_ccid financials_system_params_all.misc_charge_ccid%TYPE, --bugfix:4936051
111 --Third Party Payments
112 sp_allow_inv_third_party_ovrd ap_system_parameters.allow_inv_third_party_ovrd%TYPE,
113 sp_allow_pymt_third_party_ovrd ap_system_parameters.allow_pymt_third_party_ovrd%TYPE
114 --
115 -- << End AP-specific fields >>
116 --
117 );
118
119 --
120 -- Define data types (nested tables) for storing columns of
121 -- the widely used operating unit attributes:
122 -- Define a nested table type for storing the org_ids. This is
123 -- mandatory
124 --
125 TYPE OrgIDTable IS TABLE OF hr_organization_information.organization_id%TYPE;
126 -- Other nested table definitions. They should correspond to
127 -- the fields of the record defined above.
128 TYPE SetOfBooksIDTable IS TABLE OF gl_sets_of_books.set_of_books_id%TYPE;
129 TYPE SetOfBooksNameTable IS TABLE OF gl_sets_of_books.name%TYPE;
130 TYPE SetOfBooksShortNameTable IS TABLE OF gl_sets_of_books.short_name%TYPE;
131 TYPE ChartOfAccountsIDTable IS TABLE OF gl_sets_of_books.chart_of_accounts_id%TYPE;
132 TYPE EnableBudgetaryFlagTable IS TABLE OF gl_sets_of_books.enable_budgetary_control_flag%TYPE;
133 TYPE CurrencyCodeTable IS TABLE OF fnd_currencies.currency_code%TYPE;
134 --
135 -- << Begin AP-specific nested tables definitions >>
136 --
137 TYPE BaseCurrencyCodeTable IS TABLE OF ap_system_parameters.base_currency_code%TYPE;
138 TYPE MultiCurrencyFlagTable IS TABLE OF ap_system_parameters.multi_currency_flag%TYPE;
139 TYPE PaymentCurrencyCodeTable IS TABLE OF ap_system_parameters.payment_currency_code%TYPE;
140 TYPE ConfirmDateAsInvNumFlagTable IS TABLE OF ap_system_parameters.confirm_date_as_inv_num_flag%TYPE;
141 TYPE AcctspaycodecombinationidTable IS TABLE OF ap_system_parameters.accts_pay_code_combination_id%TYPE;
142 TYPE allowflexoverrideflagTable IS TABLE OF ap_system_parameters.allow_flex_override_flag%TYPE;
143 TYPE allowfinalmatchflagTable IS TABLE OF ap_system_parameters.allow_final_match_flag%TYPE;
144 TYPE allowdistmatchflagTable IS TABLE OF ap_system_parameters.allow_dist_match_flag%TYPE;
145 TYPE gldatefromreceiptflagTable IS TABLE OF ap_system_parameters.gl_date_from_receipt_flag%TYPE;
146 TYPE incometaxregionflagTable IS TABLE OF ap_system_parameters.income_tax_region_flag%TYPE;
147 TYPE incometaxregionTable IS TABLE OF ap_system_parameters.income_tax_region%TYPE;
148 TYPE autocreatefreightflagTable IS TABLE OF ap_system_parameters.auto_create_freight_flag%TYPE;
149 TYPE freightcodecombinationidTable IS TABLE OF ap_system_parameters.freight_code_combination_id%TYPE;
150 TYPE discisinvlesstaxflagTable IS TABLE OF ap_system_parameters.disc_is_inv_less_tax_flag%TYPE;
151 TYPE discountdistmethodTable IS TABLE OF ap_system_parameters.discount_distribution_method%TYPE;
152 TYPE invdoccategoryoverrideTable IS TABLE OF ap_system_parameters.inv_doc_category_override%TYPE;
153 TYPE approvalsoptionTable IS TABLE OF ap_system_parameters.approvals_option%TYPE;
154 TYPE combinedfilingflagTable IS TABLE OF ap_system_parameters.combined_filing_flag%TYPE;
155 TYPE allowawtflagTable IS TABLE OF ap_system_parameters.allow_awt_flag%TYPE;
156 TYPE createawtdiststypeTable IS TABLE OF ap_system_parameters.create_awt_dists_type%TYPE;
157 TYPE allowawtoverrideTable IS TABLE OF ap_system_parameters.allow_awt_override%TYPE;
158 TYPE awtincludetaxamtTable IS TABLE OF ap_system_parameters.awt_include_tax_amt%TYPE;
159 TYPE awtincludediscountamtTable IS TABLE OF ap_system_parameters.awt_include_discount_amt%TYPE;
160 TYPE allowpaidinvoiceadjustTable IS TABLE OF ap_system_parameters.allow_paid_invoice_adjust%TYPE;
161 TYPE adddayssettlementdateTable IS TABLE OF ap_system_parameters.add_days_settlement_date%TYPE;
162 TYPE prepaymenttermsidTable IS TABLE OF ap_system_parameters.prepayment_terms_id%TYPE;
163 TYPE prepaymenttermnameTable IS TABLE OF ap_terms.name%TYPE;
164 TYPE prepaycodecombinationidTable IS TABLE OF ap_system_parameters.prepay_code_combination_id%TYPE;
165 TYPE futuredatedpmtacctsourceTable IS TABLE OF ap_system_parameters.future_dated_pmt_acct_source%TYPE;
166 TYPE calcuserxrateTable IS TABLE OF ap_system_parameters.calc_user_xrate%TYPE;
167 TYPE makeratemandatoryflagTable IS TABLE OF ap_system_parameters.make_rate_mandatory_flag%TYPE;
168 TYPE defaultexchangeratetypeTable IS TABLE OF ap_system_parameters.default_exchange_rate_type%TYPE;
169 TYPE postdatedpaymentsflagTable IS TABLE OF ap_system_parameters.post_dated_payments_flag%TYPE;
170 TYPE updatepaysiteflagTable IS TABLE OF ap_system_parameters.update_pay_site_flag%TYPE;
171 TYPE onlineprintflagTable IS TABLE OF ap_system_parameters.online_print_flag%TYPE;
172 TYPE replacecheckflagTable IS TABLE OF ap_system_parameters.replace_check_flag%TYPE;
173 TYPE autocalculateinterestflagTable IS TABLE OF ap_product_setup.auto_calculate_interest_flag%TYPE;
174 TYPE interesttoleranceamountTable IS TABLE OF ap_system_parameters.interest_tolerance_amount%TYPE;
175 TYPE interestacctspayccidTable IS TABLE OF ap_system_parameters.interest_accts_pay_ccid%TYPE;
176 /* bug 5007989 */
177 TYPE usebankchargeflagTable IS TABLE OF ap_system_parameters.use_bank_charge_flag%TYPE;
178 TYPE allowsupplierbankoverrideTable IS TABLE OF ap_system_parameters.allow_supplier_bank_override%TYPE;
179 TYPE paydoccategoryoverrideTable IS TABLE OF ap_system_parameters.pay_doc_category_override%TYPE;
180 TYPE daysbetweencheckcyclesTable IS TABLE OF ap_system_parameters.days_between_check_cycles%TYPE;
181 TYPE approvalworkflowflagTable IS TABLE OF ap_system_parameters.approval_workflow_flag%TYPE;
182 TYPE allowforceapprovalflagTable IS Table OF ap_system_parameters.allow_force_approval_flag%TYPE;
183 TYPE validatebeforeapprovalTable IS Table OF ap_system_parameters.validate_before_approval_flag%TYPE;
184 TYPE globalattributecategoryTable IS TABLE OF ap_system_parameters.global_attribute_category%TYPE;
185 TYPE globalattribute1Table IS TABLE OF ap_system_parameters.global_attribute1%TYPE;
186 TYPE purchencumbranceflagTable IS TABLE OF financials_system_parameters.purch_encumbrance_flag%TYPE;
187 TYPE inventoryorganizationidTable IS TABLE OF financials_system_parameters.inventory_organization_id%TYPE;
188 TYPE vatcountrycodeTable IS TABLE OF financials_system_parameters.vat_country_code%TYPE;
189 TYPE bankaccountidTable IS TABLE OF ap_system_parameters.ce_bank_acct_use_id%TYPE;
190 TYPE bankaccountnameTable IS TABLE OF ce_bank_accounts.bank_account_name%TYPE;
191 TYPE zeroamountsallowedTable IS TABLE OF ce_bank_accounts.zero_amount_allowed%TYPE;
192 TYPE maxoutlayTable IS TABLE OF ce_bank_accounts.max_outlay%TYPE;
193 TYPE maxcheckamountTable IS TABLE OF ce_bank_accounts.max_check_amount%TYPE;
194 TYPE mincheckamountTable IS TABLE OF ce_bank_accounts.min_check_amount%TYPE;
195 TYPE bankcurrencycodeTable IS TABLE OF ce_bank_accounts.currency_code%TYPE;
196 TYPE bankmulticurrencyflagTable IS TABLE OF ce_bank_accounts.multi_currency_allowed_flag%TYPE;
197 TYPE userconversiontypeTable IS TABLE OF gl_daily_conversion_types.user_conversion_type%TYPE;
198 TYPE mrcenabledtypeTable IS TABLE OF Varchar2(1) INDEX BY BINARY_INTEGER;
199 TYPE AllowInterestInvoicesTable IS TABLE OF ap_system_parameters.auto_calculate_interest_flag%TYPE;
200 TYPE approval_timingTable IS TABLE OF ap_system_parameters.approval_timing%TYPE; --Bug4299234
201 TYPE MiscChargeCcidTable IS TABLE OF financials_system_parameters.misc_charge_ccid%TYPE; --Bug4936051
202 --Third Party Payments
203 TYPE allowInvThirdPartyOvrdTable IS TABLE OF ap_system_parameters.allow_inv_third_party_ovrd%TYPE;
204 TYPE allowPymtThirdPartyOvrdTable IS TABLE OF ap_system_parameters.allow_pymt_third_party_ovrd%TYPE;
205 -- << End AP-specific nested tables definitions >>
206 --
207 -- Define a record type that encapsulates multiple rows of
208 -- operating unit attributes:
209 --
210 TYPE GlobalsTable IS RECORD(
211 org_id_t OrgIDTable,
212 set_of_books_id_t SetOfBooksIDTable,
213 set_of_books_name_t SetOfBooksNameTable,
214 set_of_books_short_name_t SetOfBooksShortNameTable,
215 chart_of_accounts_id_t ChartOfAccountsIDTable,
216 enable_budget_control_flag_t EnableBudgetaryFlagTable,
217 currency_code_t CurrencyCodeTable,
218 --
219 -- << Begin AP-specific fields >>
220 --
221 sp_base_currency_code_t BaseCurrencyCodeTable,
222 sp_multi_currency_flag_t MultiCurrencyFlagTable,
223 sp_payment_currency_code_t PaymentCurrencyCodeTable,
224 sp_confirm_date_inv_num_flag_t ConfirmDateAsInvNumFlagTable,
225 sp_accts_pay_cc_id_t AcctspaycodecombinationidTable,
226 sp_allow_flex_override_flag_t allowflexoverrideflagTable,
227 sp_allow_final_match_flag_t allowfinalmatchflagTable,
228 sp_allow_dist_match_flag_t allowdistmatchflagTable,
229 sp_gl_date_from_receipt_flag_t gldatefromreceiptflagTable,
230 sp_income_tax_region_flag_t incometaxregionflagTable,
231 sp_income_tax_region_t incometaxregionTable,
232 sp_auto_create_freight_flag_t autocreatefreightflagTable,
233 sp_default_freight_cc_id_t freightcodecombinationidTable,
234 sp_disc_is_inv_less_tax_flag_t discisinvlesstaxflagTable,
235 sp_discount_dist_method_t discountdistmethodTable,
236 sp_inv_doc_category_override_t invdoccategoryoverrideTable,
237 sp_approvals_option_t approvalsoptionTable,
238 sp_combined_filing_flag_t combinedfilingflagTable,
239 sp_allow_awt_flag_t allowawtflagTable,
240 sp_create_awt_dists_type_t createawtdiststypeTable,
241 sp_allow_awt_override_t allowawtoverrideTable,
242 sp_awt_include_tax_amt_t awtincludetaxamtTable,
243 sp_awt_include_discount_amt_t awtincludediscountamtTable,
244 sp_allow_paid_invoice_adjust_t allowpaidinvoiceadjustTable,
245 sp_add_days_settlement_date_t adddayssettlementdateTable,
246 sp_prepayment_terms_id_t prepaymenttermsidTable,
247 sp_ap_prepayment_term_name_t prepaymenttermnameTable,
248 sp_prepay_cc_id_t prepaycodecombinationidTable,
249 sp_future_dated_pmt_acct_s_t futuredatedpmtacctsourceTable,
250 sp_calc_user_xrate_t calcuserxrateTable,
251 sp_make_rate_mandatory_flag_t makeratemandatoryflagTable,
252 sp_def_exchange_rate_type_t defaultexchangeratetypeTable,
253 sp_post_dated_payments_flag_t postdatedpaymentsflagTable,
254 sp_update_pay_site_flag_t updatepaysiteflagTable,
255 sp_online_print_flag_t onlineprintflagTable,
256 sp_replace_check_flag_t replacecheckflagTable,
257 sp_auto_calc_interest_flag_t autocalculateinterestflagTable,
258 sp_interest_tolerance_amount_t interesttoleranceamountTable,
259 sp_interest_accts_pay_ccid_t interestacctspayccidTable,
260 sp_use_bank_charge_flag_t usebankchargeflagTable, /* bug 5007989 */
261 sp_allow_supp_bank_override_t allowsupplierbankoverrideTable,
262 sp_pay_doc_category_override_t paydoccategoryoverrideTable,
263 sp_days_between_check_cycles_t daysbetweencheckcyclesTable,
264 sp_approval_workflow_flag_t approvalworkflowflagTable,
265 sp_allow_force_approval_flag_t allowforceapprovalflagTable,
266 sp_validate_before_approval_t validatebeforeapprovalTable,
267 sp_global_attribute_category_t globalattributecategoryTable,
268 sp_global_attribute1_t globalattribute1Table,
269 sp_global_attribute2_t globalattribute1Table,
270 sp_global_attribute3_t globalattribute1Table,
271 sp_global_attribute4_t globalattribute1Table,
272 sp_global_attribute5_t globalattribute1Table,
273 sp_global_attribute6_t globalattribute1Table,
274 sp_global_attribute7_t globalattribute1Table,
275 sp_global_attribute8_t globalattribute1Table,
276 sp_global_attribute9_t globalattribute1Table,
277 sp_global_attribute10_t globalattribute1Table,
278 sp_global_attribute11_t globalattribute1Table,
279 sp_global_attribute12_t globalattribute1Table,
280 sp_global_attribute13_t globalattribute1Table,
281 sp_global_attribute14_t globalattribute1Table,
282 sp_global_attribute15_t globalattribute1Table,
283 sp_global_attribute16_t globalattribute1Table,
284 sp_global_attribute17_t globalattribute1Table,
285 sp_global_attribute18_t globalattribute1Table,
286 sp_global_attribute19_t globalattribute1Table,
287 sp_global_attribute20_t globalattribute1Table,
288 fsp_purch_encumbrance_flag_t purchencumbranceflagTable,
289 fsp_inventory_org_id_t inventoryorganizationidTable,
290 fsp_vat_country_code_t vatcountrycodeTable,
291 sp_aba_bank_account_id_t bankaccountidTable,
292 sp_aba_bank_account_name_t bankaccountnameTable,
293 sp_aba_zero_amounts_allowed_t zeroamountsallowedTable,
294 sp_aba_max_outlay_t maxoutlayTable,
295 sp_aba_max_check_amount_t maxcheckamountTable,
296 sp_aba_min_check_amount_t mincheckamountTable,
297 sp_aba_currency_code_t bankcurrencycodeTable,
298 sp_aba_multi_currency_flag_t bankmulticurrencyflagTable,
299 sp_gdct_user_conversion_type_t userconversiontypeTable,
300 mrc_enabled_t mrcenabledtypeTable ,
301 sp_allow_interest_invoices_t allowinterestinvoicesTable,
302 sp_approval_timing_t approval_timingTable, --Bug4299234
303 fsp_misc_charge_ccid_t miscchargeccidTable, --Bug4936051
304 --Third Party Payments
305 sp_allow_inv_thrd_prty_ovrd_t allowInvThirdPartyOvrdTable,
306 sp_allow_pymt_thrd_prty_ovrd_t allowPymtThirdPartyOvrdTable
307 -- << End AP-specific fields >>
308 );
309
310
311 --
312 -- This procedure retrieves operating unit attributes from the
313 -- database and stores them into the specified data structure.
314 --
315 PROCEDURE retrieve_globals(p_globals OUT NOCOPY GlobalsTable);
316
317 END ap_mo_cache_utils;