[Home] [Help]
PACKAGE: APPS.AP_WEB_DB_AP_INT_PKG
Source
1 PACKAGE AP_WEB_DB_AP_INT_PKG AUTHID CURRENT_USER AS
2 /* $Header: apwdbaps.pls 120.18.12010000.4 2009/12/14 14:08:45 dsadipir ship $ */
3
4 SUBTYPE expHdr_headerID IS AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE;
5 SUBTYPE expHdr_defaultExchRate IS AP_EXPENSE_REPORT_HEADERS.default_exchange_rate%TYPE;
6
7 /* Financials System Parameters */
8 ---------------------------------------------------------------------------------------------------
9 SUBTYPE finSysParams_checkAddrFlag IS FINANCIALS_SYSTEM_PARAMETERS.expense_check_address_flag%TYPE;
10 ---------------------------------------------------------------------------------------------------
11
12 ---------------------------------------------------------------------------------------------------
13 SUBTYPE apSetUp_baseCurrencyCode IS AP_SYSTEM_PARAMETERS.base_currency_code%TYPE;
14 SUBTYPE apSetUp_expenseReportID IS AP_SYSTEM_PARAMETERS.expense_report_id%TYPE;
15 SUBTYPE apSetUp_multiCurrencyFlag IS AP_SYSTEM_PARAMETERS.multi_currency_flag%TYPE;
16 SUBTYPE apSetUp_defaultExchRateType IS AP_SYSTEM_PARAMETERS.default_exchange_rate_type%TYPE;
17 SUBTYPE apSetUp_autoTaxCalcFlag IS AP_SYSTEM_PARAMETERS.AUTO_TAX_CALC_FLAG%TYPE;
18 SUBTYPE apSetUp_autoTaxCalcOverride IS AP_SYSTEM_PARAMETERS.AUTO_TAX_CALC_OVERRIDE%TYPE;
19 SUBTYPE apSetUp_amtInclTaxOverride IS AP_SYSTEM_PARAMETERS.AMOUNT_INCLUDES_TAX_OVERRIDE%TYPE;
20 SUBTYPE apSetUp_setOfBooksID IS AP_SYSTEM_PARAMETERS.set_of_books_id%TYPE;
21 SUBTYPE apSetUp_paymentCurrCode IS AP_SYSTEM_PARAMETERS.payment_currency_code%TYPE;
25 SUBTYPE apSetUp_defaultAWTGroupID IS AP_SYSTEM_PARAMETERS.default_awt_group_id%TYPE;
22 SUBTYPE apSetUp_applyAdvDefault IS AP_SYSTEM_PARAMETERS.apply_advances_default%TYPE;
23 SUBTYPE apSetUp_allowAWTFlag IS AP_SYSTEM_PARAMETERS.allow_awt_flag%TYPE;
24 SUBTYPE apSetUp_allowAWTOverride IS AP_SYSTEM_PARAMETERS.allow_awt_override%TYPE;
26 SUBTYPE apSetUp_vatCode IS AP_SYSTEM_PARAMETERS.vat_code%TYPE;
27 SUBTYPE apSetUp_makeMandatoryFlag IS AP_SYSTEM_PARAMETERS.make_rate_mandatory_flag%TYPE;
28 ---------------------------------------------------------------------------------------------------
29 /* PO Vendors */
30 ---------------------------------------------------------------------------------------------------
31 SUBTYPE vendors_vendorID IS AP_SUPPLIERS.vendor_id%TYPE;
32 SUBTYPE vendors_paymentCurrCode IS AP_SUPPLIERS.payment_currency_code%TYPE;
33 SUBTYPE vendors_allowAWTFlag IS AP_SUPPLIERS.allow_awt_flag%TYPE;
34 SUBTYPE vendors_awtGroupID IS AP_SUPPLIERS.awt_group_id%TYPE;
35 SUBTYPE vendors_employeeID IS AP_SUPPLIERS.employee_id%TYPE;
36 SUBTYPE vendors_payGroupLookupCode IS AP_SUPPLIERS.pay_group_lookup_code%TYPE;
37 SUBTYPE vendors_vendorName IS AP_SUPPLIERS.vendor_name%TYPE;
38 SUBTYPE vendors_setOfBooksID IS AP_SUPPLIERS.set_of_books_id%TYPE;
39 SUBTYPE vendors_acctsPayCodeCombID IS AP_SUPPLIERS.accts_pay_code_combination_id%TYPE;
40 -------------------------------------------------------------------------------
41
42 --------------------
43 /* PO Vendor Sites */
44 -------------------------------------------------------------------------------
45 SUBTYPE vendorSites_vendorSiteID IS AP_SUPPLIER_SITES.vendor_site_id%TYPE;
46 SUBTYPE vendorSites_vendorID IS AP_SUPPLIER_SITES.vendor_id%TYPE;
47 SUBTYPE vendorSites_payGroupLookupCode IS AP_SUPPLIER_SITES.pay_group_lookup_code%TYPE;
48 SUBTYPE vendorSites_invCurrCode IS AP_SUPPLIER_SITES.invoice_currency_code%TYPE;
49 SUBTYPE vendorSites_acctsPayCodeCombID IS AP_SUPPLIER_SITES.accts_pay_code_combination_id%TYPE;
50 -------------------------------------------------------------------------------
51
52 --------------------
53 /* GL Sets Of Books */
54 ---------------------------------------------------------------------------------------------------
55 SUBTYPE glsob_chartOfAccountsID IS GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;
56 SUBTYPE glsob_setOfBooksID IS GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
57 SUBTYPE glsob_name IS GL_SETS_OF_BOOKS.name%TYPE;
58 ---------------------------------------------------------------------------------------------------
59 /* AP Web Signing Limits */
60
61 ---------------------------------------------------------------------------------------------------
62 SUBTYPE signingLimits_signingLimit IS AP_WEB_SIGNING_LIMITS.signing_limit%TYPE;
63 SUBTYPE signingLimits_docType IS AP_WEB_SIGNING_LIMITS.document_type%TYPE;
64 SUBTYPE signingLimits_employeeID IS AP_WEB_SIGNING_LIMITS.employee_id%TYPE;
65 SUBTYPE signingLimits_costCenter IS AP_WEB_SIGNING_LIMITS.cost_center%TYPE;
66 SUBTYPE signingLimits_orgID IS AP_WEB_SIGNING_LIMITS.org_id%TYPE;
67 ---------------------------------------------------------------------------------------------------
68
69 /*AP Invoices */
70 ---------------------------------------------------------------------------------------------------
71 SUBTYPE invoices_invCurrCode IS AP_INVOICES.invoice_currency_code%TYPE;
72 ---------------------------------------------------------------------------------------------------
73
74 /*AP Invoices Interface */
75 ---------------------------------------------------------------------------------------------------
76 SUBTYPE invIntf_invID IS AP_INVOICES_INTERFACE.invoice_id%TYPE;
77 SUBTYPE invIntf_invNum IS AP_INVOICES_INTERFACE.invoice_num%TYPE;
78 SUBTYPE invIntf_partyID IS AP_INVOICES_INTERFACE.party_id%TYPE;
79 SUBTYPE invIntf_partySiteID IS AP_INVOICES_INTERFACE.party_site_id%TYPE;
80 SUBTYPE invIntf_vendorID IS AP_INVOICES_INTERFACE.vendor_id%TYPE;
81 SUBTYPE invIntf_vendorSiteID IS AP_INVOICES_INTERFACE.vendor_site_id%TYPE;
82 SUBTYPE invIntf_invAmt IS AP_INVOICES_INTERFACE.invoice_amount%TYPE;
83 SUBTYPE invIntf_invCurrCode IS AP_INVOICES_INTERFACE.invoice_currency_code%TYPE;
84 SUBTYPE invIntf_source IS AP_INVOICES_INTERFACE.source%TYPE;
85 SUBTYPE invIntf_docCategoryCode IS AP_INVOICES_INTERFACE.doc_category_code%TYPE;
86 SUBTYPE invIntf_invTypeCode IS AP_INVOICES_INTERFACE.invoice_type_lookup_code%TYPE;
87 SUBTYPE invIntf_acctsPayCCID IS AP_INVOICES_INTERFACE.accts_pay_code_combination_id%TYPE;
88 ---------------------------------------------------------------------------------------------------
89
90
91
92 /* AP Expense Feed Dists */
93 ---------------------------------------------------------------------------------------------------
94 SUBTYPE expFeedDists_distID IS AP_EXPENSE_FEED_DISTS.feed_distribution_id%TYPE;
95 SUBTYPE expFeedDists_description IS AP_EXPENSE_FEED_DISTS.description%TYPE;
96 SUBTYPE expFeedDists_mgrApprvlID IS AP_EXPENSE_FEED_DISTS.manager_approval_id%TYPE;
97 SUBTYPE expFeedDists_statusLookupCode IS AP_EXPENSE_FEED_DISTS.status_lookup_code%TYPE;
98 SUBTYPE expFeedDists_feedLineID IS AP_EXPENSE_FEED_DISTS.feed_line_id%TYPE;
99 SUBTYPE expFeedDists_amount IS AP_EXPENSE_FEED_DISTS.amount%TYPE;
100 SUBTYPE expFeedDists_distCodeCombID IS AP_EXPENSE_FEED_DISTS.dist_code_combination_id%TYPE;
101 SUBTYPE expFeedDists_amtInclTaxFlag IS AP_EXPENSE_FEED_DISTS.amount_includes_tax_flag%TYPE;
102 SUBTYPE expFeedDists_taxCode IS AP_EXPENSE_FEED_DISTS.tax_code%TYPE;
103 SUBTYPE expFeedDists_empVerifID IS AP_EXPENSE_FEED_DISTS.employee_verification_id%TYPE;
104 SUBTYPE expFeedDists_acctSegValue IS AP_EXPENSE_FEED_DISTS.account_segment_value%TYPE;
105 SUBTYPE expFeedDists_costCenter IS AP_EXPENSE_FEED_DISTS.cost_center%TYPE;
106 SUBTYPE expFeedDists_statusChangeDate IS AP_EXPENSE_FEED_DISTS.status_change_date%TYPE;
107 ---------------------------------------------------------------------------------------------------
108
109
110 /*AP Invoices Lines Interface */
111 ---------------------------------------------------------------------------------------------------
112 SUBTYPE invLines_invID IS AP_INVOICE_LINES_INTERFACE.invoice_id%type;
113 SUBTYPE invLines_invLineID IS AP_INVOICE_LINES_INTERFACE.invoice_line_id%type;
114 SUBTYPE invLines_lineNum IS AP_INVOICE_LINES_INTERFACE.line_number%type;
115 SUBTYPE invLines_lineTypeLookupCode IS AP_INVOICE_LINES_INTERFACE.line_type_lookup_code%type;
116 SUBTYPE invLines_amount IS AP_INVOICE_LINES_INTERFACE.amount%type;
117 SUBTYPE invLines_accountingDate IS AP_INVOICE_LINES_INTERFACE.accounting_date%type;
118 SUBTYPE invLines_distCodeCombID IS AP_INVOICE_LINES_INTERFACE.dist_code_combination_id%type;
119 SUBTYPE invLines_crdCardTrxID IS AP_INVOICE_LINES_INTERFACE.credit_card_trx_id%type;
120 SUBTYPE invLines_description IS AP_INVOICE_LINES_INTERFACE.description%type;
121 ---------------------------------------------------------------------------------------------------
122
123 /*AP Invoices All */
124 ---------------------------------------------------------------------------------------------------
125 SUBTYPE invAll_exchangeRate IS AP_INVOICES_ALL.exchange_rate%TYPE;
126 SUBTYPE invAll_id IS AP_INVOICES_ALL.invoice_id%TYPE;
127 SUBTYPE invAll_invoiceAmount IS AP_INVOICES_ALL.invoice_amount%TYPE;
128 SUBTYPE invAll_baseAmount IS AP_INVOICES_ALL.base_amount%TYPE;
129 ---------------------------------------------------------------------------------------------------
130
131 /* AP Tax Codes */
132
133 ---------------------------------------------------------------------------------------------------
134 SUBTYPE taxCodes_name IS AP_TAX_CODES.name%TYPE;
135 SUBTYPE taxCodes_webEnabledFlag IS AP_TAX_CODES.web_enabled_flag%TYPE;
136 SUBTYPE taxCodes_taxID IS AP_TAX_CODES.TAX_ID%TYPE;
137 SUBTYPE taxCodes_inactiveDate IS AP_TAX_CODES.inactive_date%TYPE;
138 ---------------------------------------------------------------------------------------------------
139
140
141
142 C_No CONSTANT VARCHAR2(1) := 'N';
143 C_TaxCalcLevelNone CONSTANT VARCHAR2(1) := 'N';
144
145 TYPE TaxCodeCursor IS REF CURSOR;
146 TYPE CostCenterValidCursor IS REF CURSOR;
147
148 TYPE APSysInfoRec IS RECORD (
149 base_currency apSetUp_baseCurrencyCode,
150 default_exchange_rate_type apSetUp_defaultExchRateType,
151 base_curr_name FND_CURRENCIES_VL.name%TYPE,
152 sys_multi_curr_flag apSetUp_multiCurrencyFlag
153 );
154
155 --------------------------------------------------------------------------------
156 FUNCTION get_ap_system_params(
157 p_base_curr_code OUT NOCOPY apSetUp_baseCurrencyCode,
158 p_set_of_books_id OUT NOCOPY apSetUp_setOfBooksID,
159 p_expense_report_id OUT NOCOPY apSetUp_expenseReportID,
160 p_default_exch_rate_type OUT NOCOPY apSetUp_defaultExchRateType) RETURN BOOLEAN;
161 --------------------------------------------------------------------------------
162
163 --------------------------------------------------------------------------------
164 FUNCTION GetCurrNameForCurrCode(
165 p_curr_code IN FND_CURRENCIES_VL.currency_code%TYPE,
166 p_curr_name OUT NOCOPY FND_CURRENCIES_VL.name%TYPE
167 ) RETURN BOOLEAN;
168
169 --------------------------------------------------------------------------------
170 FUNCTION GetBaseCurrInfo(
171 p_base_curr_code OUT NOCOPY apSetUp_baseCurrencyCode
172 ) RETURN BOOLEAN;
173
174 -------------------------------------------------------------------
175 FUNCTION GetAPSysCurrencySetupInfo(p_sys_info_rec OUT NOCOPY APSysInfoRec
176 ) RETURN BOOLEAN;
177
178 -------------------------------------------------------------------
179 PROCEDURE GetDefaultExchange(p_default_exchange_rate_type OUT NOCOPY VARCHAR2);
180
181
182 ----------------------------------------------------------
183 FUNCTION GetVendorInfoOfEmp(
184 p_employee_id IN vendors_employeeID,
185 p_vendor_id OUT NOCOPY vendors_vendorID,
186 p_vend_pay_curr_code OUT NOCOPY vendors_paymentCurrCode,
187 p_vend_pay_curr_name OUT NOCOPY FND_CURRENCIES_VL.name%TYPE
188 ) RETURN BOOLEAN;
189
190 ----------------------------------------------------------
191 FUNCTION GetVendorAWTSetupForExpRpt(
192 p_report_header_id IN expHdr_headerID,
193 p_ven_allow_awt_flag OUT NOCOPY vendors_allowAWTFlag,
194 p_ven_awt_group_id OUT NOCOPY vendors_awtGroupID
195 ) RETURN BOOLEAN;
196
197 -------------------------------------------------------------------
198 FUNCTION GetCOAofSOB(
199 p_chart_of_accounts OUT NOCOPY glsob_chartOfAccountsID
200 ) RETURN BOOLEAN;
201
202 -------------------------------------------------------------------
203 FUNCTION GetSOB(
204 p_set_of_books_id OUT NOCOPY glsob_setOfBooksID
205 ) RETURN BOOLEAN;
206
207 -------------------------------------------------------------------
208 FUNCTION ApproverHasAuthority(
209 p_approver_id IN signingLimits_employeeID,
210 p_doc_cost_center IN signingLimits_costCenter,
211 p_approval_amount IN NUMBER,
212 p_reimb_precision IN FND_CURRENCIES_VL.PRECISION%TYPE,
213 p_item_type IN signingLimits_docType,
214 p_payment_curr_code IN VARCHAR2,
215 p_week_end_date IN DATE,
216 p_has_authority OUT NOCOPY BOOLEAN
217 ) RETURN BOOLEAN;
218
219 -------------------------------------------------------------------
220 /*Bug 2743726: New procedure for checking cost center value set
221 alphanumeric_flag is checked or not.
222 */
223 -------------------------------------------------------------------
224 PROCEDURE IsCostCenterUpperCase(
225 p_doc_cost_center IN VARCHAR2,
226 Is_Cost_Center_UpperCase_flag OUT NOCOPY VARCHAR2
227 );
228 -------------------------------------------------------------------
229
230
231 --------------------------------------------------------------------------------
232 FUNCTION CostCenterValid(
233 p_cost_center IN expFeedDists_costCenter,
234 p_valid OUT NOCOPY BOOLEAN,
235 p_employee_id IN NUMBER DEFAULT null
236 ) RETURN BOOLEAN;
237 --------------------------------------------------------------------------------
238
239 --------------------------------------------------------------------------------
240 FUNCTION GetExpenseClearingCCID(
241 p_ccid OUT NOCOPY NUMBER,
242 p_card_program_id IN NUMBER,
243 p_employee_id IN NUMBER,
244 p_as_of_date IN DATE
245 ) RETURN BOOLEAN;
246
247 -----------------------------------------------------
248 FUNCTION GetAvailablePrepayments(
249 p_employee_id IN vendors_employeeID,
250 p_default_currency_code IN invoices_invCurrCode,
251 p_available_prepays OUT NOCOPY NUMBER
252 ) RETURN BOOLEAN;
253
254 -------------------------------------------------------------------
255 FUNCTION GetVendorID(
256 p_employee_id IN vendors_employeeID,
257 p_vendor_id OUT NOCOPY vendors_vendorID
258 ) RETURN BOOLEAN;
259 -------------------------------------------------------------------
260
261 -------------------------------------------------------------------
262 FUNCTION GetVendorSitesCodeCombID(
263 p_vendor_site_id IN vendorSites_vendorSiteID,
264 p_code_comb_id OUT NOCOPY vendorSites_acctsPayCodeCombID
265 ) RETURN BOOLEAN;
266 -------------------------------------------------------------------
267
268 -------------------------------------------------------------------
269 FUNCTION GetVendorCodeCombID(
270 p_vendor_id IN vendors_vendorID,
271 p_accts_pay OUT NOCOPY vendors_acctsPayCodeCombID
272 ) RETURN BOOLEAN;
273 -------------------------------------------------------------------
274
275 -------------------------------------------------------------------
276 FUNCTION GetPayGroupLookupCode(
277 p_vendor_id IN vendorSites_vendorID,
278 p_vendor_site_id IN vendorSites_vendorSiteID,
279 p_pay_group_code OUT NOCOPY vendorSites_payGroupLookupCode
280 ) RETURN BOOLEAN;
281
282 --------------------------------------------------------------------------------
283 -- Bug: 6838894
284 FUNCTION InsertInvoiceInterface(
285 p_invoice_id IN invIntf_invID,
286 p_party_id IN invIntf_partyID,
287 p_vendor_id IN invIntf_vendorID,
288 p_vendor_site_id IN invIntf_vendorSiteID,
289 p_sum IN invIntf_invAmt,
290 p_invoice_curr_code IN invIntf_invCurrCode,
291 p_source IN invIntf_source,
295 p_invoice_type_lookup_code IN invIntf_invTypeCode,
292 p_pay_group_lookup_code IN vendorSites_payGroupLookupCode,
293 p_org_id IN NUMBER,
294 p_doc_category_code IN invIntf_docCategoryCode,
296 p_accts_pay_ccid IN invIntf_acctsPayCCID,
297 p_party_site_id IN invIntf_partySiteID default null,
298 p_terms_id IN AP_TERMS.TERM_ID%TYPE default null
299 ) RETURN BOOLEAN;
300
301 --------------------------------------------------------------------------------
302 FUNCTION InsertInvoiceLinesInterface(
303 p_invoice_id IN invLines_invID,
304 p_invoice_line_id IN invLines_invLineID,
305 p_count IN invLines_lineNum,
306 p_linetype IN invLines_lineTypeLookupCode,
307 p_amount IN invLines_amount,
308 p_trxn_date IN invLines_accountingDate,
309 p_ccid IN invLines_distCodeCombID,
310 p_card_trxn_id IN invLines_crdCardTrxID,
311 p_description IN invLines_description,
312 p_org_id IN NUMBER
313
314 ) RETURN BOOLEAN;
315
316 --------------------------------------------------------------------------------
317 FUNCTION GetNextInvoiceId(
318 p_invoice_id OUT NOCOPY NUMBER
319 ) RETURN BOOLEAN;
320
321 --------------------------------------------------------------------------------
322 FUNCTION GetNextInvoiceLineId(
323 p_invoice_line_id OUT NOCOPY NUMBER
324 ) RETURN BOOLEAN;
325
326 -------------------------------------------------------------------
327 FUNCTION IsTaxCodeWebEnabled(
328 P_ExpTypeDefaultTaxCode IN taxCodes_name,
329 p_tax_web_enabled OUT NOCOPY taxCodes_webEnabledFlag
330 ) RETURN BOOLEAN;
331
332 PROCEDURE GenTaxFunctions;
333
334
335 --------------------------------------------------------------------------------
336 FUNCTION GetInvoiceAmt(
337 p_invoiceId IN invAll_id,
338 p_invoiceAmt OUT NOCOPY invLines_amount,
339 p_exchangeRate OUT NOCOPY invAll_exchangeRate,
340 p_minAcctUnit OUT NOCOPY FND_CURRENCIES_VL.minimum_accountable_unit%TYPE ,
341 p_precision OUT NOCOPY FND_CURRENCIES_VL.PRECISION%TYPE
342 ) RETURN BOOLEAN;
343 --------------------------------------------------------------------------------
344
345 --------------------------------------------------------------------------------
346 FUNCTION SetInvoiceAmount(
347 p_invoiceId IN invAll_id,
348 p_invoiceAmt IN invAll_invoiceAmount,
349 p_baseAmt IN invAll_baseAmount
350 ) RETURN BOOLEAN;
351 --------------------------------------------------------------------------------
352
353 -------------------------------------------------------------------
354 FUNCTION GetVatCode(
355 P_TaxCodeID IN taxCodes_taxID,
356 p_VatCode OUT NOCOPY taxCodes_name
357 ) RETURN BOOLEAN;
358 -------------------------------------------------------------------
359
360 -------------------------------------------------------------------
361 FUNCTION GetTaxCodeID(
362 P_VatCode IN taxCodes_name,
363 P_TaxCodeID OUT NOCOPY taxCodes_taxID
364 ) RETURN BOOLEAN;
365 -------------------------------------------------------------------
366
367 -------------------------------------------------------------------
368 FUNCTION GetTaxCodeID(
369 P_VatCode IN taxCodes_name,
370 P_ExpLine_Date IN DATE,
371 P_TaxCodeID OUT NOCOPY taxCodes_taxID
372 ) RETURN BOOLEAN;
373 -------------------------------------------------------------------
374
375 FUNCTION GetRoundingErrorCCID(
376 p_ccid OUT NOCOPY NUMBER
377 ) RETURN BOOLEAN;
378
379 --------------------------------------------------------------------------------
380
381 -------------------------------------------------------------------
382 FUNCTION getTemplateCostCenter(
383 p_parameter_id IN NUMBER
384 ) RETURN VARCHAR2;
385 -------------------------------------------------------------------
386
387 -------------------------------------------------------------------
388 FUNCTION isCostCenterExistOnTemplate(
389 p_expense_report_id IN NUMBER
390 ) RETURN VARCHAR2;
391
392 -------------------------------------------------------------------
393 FUNCTION GetExpenseClearingCCID(
394 p_trx_id NUMBER
395 ) RETURN NUMBER;
396
397 -----------------------------------------------------
398
399 ---------------------------------------------------------------------
400 PROCEDURE GetDefaultExchangeRates(
401 p_default_exchange_rates OUT NOCOPY VARCHAR2,
402 p_exchange_rate_allowance OUT NOCOPY NUMBER
403 );
404 ---------------------------------------------------------------------
405
406
407 END AP_WEB_DB_AP_INT_PKG;