[Home] [Help]
PACKAGE: APPS.AP_WEB_DB_EXPRPT_PKG
Source
1 PACKAGE AP_WEB_DB_EXPRPT_PKG AS
2 /* $Header: apwdbers.pls 120.21.12000000.2 2007/10/11 09:15:03 stalasil ship $ */
3
4 ------------------------
5 -- Types definition
6 ------------------------
7
8 SUBTYPE expHdr_headerID IS AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE;
9 SUBTYPE expHdr_employeeID IS AP_EXPENSE_REPORT_HEADERS.employee_id%TYPE;
10 SUBTYPE expHdr_vouchno IS AP_EXPENSE_REPORT_HEADERS.vouchno%TYPE;
11 SUBTYPE expHdr_total IS AP_EXPENSE_REPORT_HEADERS.total%TYPE;
12 SUBTYPE expHdr_vendorID IS AP_EXPENSE_REPORT_HEADERS.vendor_id%TYPE;
13 SUBTYPE expHdr_vendorSiteID IS AP_EXPENSE_REPORT_HEADERS.vendor_site_id%TYPE;
14 SUBTYPE expHdr_expCheckAddrFlag IS AP_EXPENSE_REPORT_HEADERS.expense_check_address_flag%TYPE;
15 SUBTYPE expHdr_invNum IS AP_EXPENSE_REPORT_HEADERS.invoice_num%TYPE;
16 SUBTYPE expHdr_source IS AP_EXPENSE_REPORT_HEADERS.source%TYPE;
17 SUBTYPE expHdr_expenseStatusCode IS AP_EXPENSE_REPORT_HEADERS.expense_status_code%TYPE;
18 SUBTYPE expHdr_employeeCCID IS AP_EXPENSE_REPORT_HEADERS.employee_ccid%TYPE;
19 SUBTYPE expHdr_description IS AP_EXPENSE_REPORT_HEADERS.description%TYPE;
20 SUBTYPE expHdr_defaultCurrCode IS AP_EXPENSE_REPORT_HEADERS.default_currency_code%TYPE;
21 SUBTYPE expHdr_defaultXchRateType IS AP_EXPENSE_REPORT_HEADERS.default_exchange_rate_type%TYPE;
22 SUBTYPE expHdr_orgID IS AP_EXPENSE_REPORT_HEADERS.org_id%TYPE;
23 SUBTYPE expHdr_wkflApprvdFlag IS AP_EXPENSE_REPORT_HEADERS.workflow_approved_flag%TYPE;
24 SUBTYPE expHdr_flexConcat IS AP_EXPENSE_REPORT_HEADERS.flex_concatenated%TYPE;
25 SUBTYPE expHdr_overrideApprID IS AP_EXPENSE_REPORT_HEADERS.override_approver_id%TYPE;
26 SUBTYPE expHdr_overrideApprName IS AP_EXPENSE_REPORT_HEADERS.override_approver_name%TYPE;
27 SUBTYPE expHdr_amtDueCCardCompany IS AP_EXPENSE_REPORT_HEADERS.amt_due_ccard_company%TYPE;
28 SUBTYPE expHdr_amtDueEmployee IS AP_EXPENSE_REPORT_HEADERS.amt_due_employee%TYPE;
29 SUBTYPE expHdr_bothpayParentId IS AP_EXPENSE_REPORT_HEADERS.bothpay_parent_iD%TYPE;
30 SUBTYPE expHdr_shortpayParentId IS AP_EXPENSE_REPORT_HEADERS.shortpay_parent_id%TYPE;
31 SUBTYPE expHdr_paidOnBehalfEmpID IS AP_EXPENSE_REPORT_HEADERS.paid_on_behalf_employee_id%TYPE;
32 SUBTYPE expHdr_expRptID IS AP_EXPENSE_REPORT_HEADERS.expense_report_id%TYPE;
33 SUBTYPE expHdr_weekEndDate IS AP_EXPENSE_REPORT_HEADERS.week_end_date%TYPE;
34 SUBTYPE expHdr_createdBy IS AP_EXPENSE_REPORT_HEADERS.created_by%TYPE;
35 SUBTYPE expHdr_lastUpdatedBy IS AP_EXPENSE_REPORT_HEADERS.last_updated_by%TYPE;
36 SUBTYPE expHdr_lastUpdateDate IS AP_EXPENSE_REPORT_HEADERS.last_update_date%TYPE;
37 SUBTYPE expHdr_setOfBooksID IS AP_EXPENSE_REPORT_HEADERS.set_of_books_id%TYPE;
38 SUBTYPE expHdr_lastUpdateLogin IS AP_EXPENSE_REPORT_HEADERS.last_update_login%TYPE;
39 SUBTYPE expHdr_applyAdvDefault IS AP_EXPENSE_REPORT_HEADERS.apply_advances_default%TYPE;
40 SUBTYPE expHdr_awtGroupID IS AP_EXPENSE_REPORT_HEADERS.awt_group_id%TYPE;
41 SUBTYPE expHdr_defaultExchDate IS AP_EXPENSE_REPORT_HEADERS.default_exchange_date%TYPE;
42 SUBTYPE expHdr_defaultExchRate IS AP_EXPENSE_REPORT_HEADERS.default_exchange_rate%TYPE;
43 SUBTYPE expHdr_acctsPayCodeCombID IS AP_EXPENSE_REPORT_HEADERS.accts_pay_code_combination_id%TYPE;
44 SUBTYPE expHdr_attrCategory IS AP_EXPENSE_REPORT_HEADERS.attribute_category%TYPE;
45 SUBTYPE expHdr_attr1 IS AP_EXPENSE_REPORT_HEADERS.attribute1%TYPE;
46 SUBTYPE expHdr_attr2 IS AP_EXPENSE_REPORT_HEADERS.attribute2%TYPE;
47 SUBTYPE expHdr_attr3 IS AP_EXPENSE_REPORT_HEADERS.attribute3%TYPE;
48 SUBTYPE expHdr_attr4 IS AP_EXPENSE_REPORT_HEADERS.attribute4%TYPE;
49 SUBTYPE expHdr_attr5 IS AP_EXPENSE_REPORT_HEADERS.attribute5%TYPE;
50 SUBTYPE expHdr_attr6 IS AP_EXPENSE_REPORT_HEADERS.attribute6%TYPE;
51 SUBTYPE expHdr_attr7 IS AP_EXPENSE_REPORT_HEADERS.attribute7%TYPE;
52 SUBTYPE expHdr_attr8 IS AP_EXPENSE_REPORT_HEADERS.attribute8%TYPE;
53 SUBTYPE expHdr_attr9 IS AP_EXPENSE_REPORT_HEADERS.attribute9%TYPE;
54 SUBTYPE expHdr_attr10 IS AP_EXPENSE_REPORT_HEADERS.attribute10%TYPE;
55 SUBTYPE expHdr_attr11 IS AP_EXPENSE_REPORT_HEADERS.attribute11%TYPE;
56 SUBTYPE expHdr_attr12 IS AP_EXPENSE_REPORT_HEADERS.attribute12%TYPE;
57 SUBTYPE expHdr_attr13 IS AP_EXPENSE_REPORT_HEADERS.attribute13%TYPE;
58 SUBTYPE expHdr_attr14 IS AP_EXPENSE_REPORT_HEADERS.attribute14%TYPE;
59 SUBTYPE expHdr_attr15 IS AP_EXPENSE_REPORT_HEADERS.attribute15%TYPE;
60 SUBTYPE expHdr_payemntCurrCode IS AP_EXPENSE_REPORT_HEADERS.payment_currency_code%TYPE;
61 SUBTYPE expHdr_maxAmountApplied IS AP_EXPENSE_REPORT_HEADERS.maximum_amount_to_apply%TYPE;
62
63 /* From DB AP INTERFACE PACKAGE */
64 SUBTYPE finSysParams_checkAddrFlag IS FINANCIALS_SYSTEM_PARAMETERS.expense_check_address_flag%TYPE;
65
66 SUBTYPE glsob_chartOfAccountsID IS GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE;
67
68 SUBTYPE apSetUp_defaultExchRateType IS AP_SYSTEM_PARAMETERS.default_exchange_rate_type%TYPE;
69 SUBTYPE apSetUp_applyAdvDefault IS AP_SYSTEM_PARAMETERS.apply_advances_default%TYPE;
70 SUBTYPE apSetUp_allowAWTFlag IS AP_SYSTEM_PARAMETERS.allow_awt_flag%TYPE;
71 SUBTYPE apSetUp_makeMandatoryFlag IS AP_SYSTEM_PARAMETERS.make_rate_mandatory_flag%TYPE;
72
73
74 /* From DB CCard Package */
75 SUBTYPE cardProgs_vendorID IS AP_CARD_PROGRAMS.vendor_id%TYPE;
76 SUBTYPE cardProgs_vendorSiteID IS AP_CARD_PROGRAMS.vendor_site_id%TYPE;
77
78 ------------------------
79 -- Constants definition
80 ------------------------
81
82 -- Workflow status flags
83 C_WORKFLOW_APPROVED_SAVED CONSTANT VARCHAR2(1) := 'S';
84 C_WORKFLOW_APPROVED_REJECTED CONSTANT VARCHAR2(1) := 'R';
85 C_WORKFLOW_APPROVED_RETURNED CONSTANT VARCHAR2(1) := 'T';
86 C_WORKFLOW_APPROVED_SUBMIT CONSTANT VARCHAR2(1) := '';
87 --ER 1552747 - withdraw expense report
88 C_WORKFLOW_APPROVED_WITHDRAW CONSTANT VARCHAR2(1) := 'W';
89 -- Auditor Requesting More Info
90 C_WORKFLOW_APPROVED_REQUEST CONSTANT VARCHAR2(1) := 'Q';
91 -- Used in query of header and lines
92 C_UserAttributeCode CONSTANT VARCHAR2(50) := 'ICX_HR_PERSON_ID';
93 C_RestorableReportSource CONSTANT VARCHAR2(50) := 'NonValidatedWebExpense';
94
95
96
97 --------------------------------
98 -- Cursor Reference definition
99 --------------------------------
100
101 TYPE RestorableReportsCursor IS REF CURSOR;
102
103 TYPE ExpWorkflowRec IS RECORD (
104 doc_num expHdr_invNum,
105 workflow_flag expHdr_wkflApprvdFlag
106 ); /* end TYPE WorkflowRec */
107
108
109 TYPE ExpInfoRec IS RECORD (
110 emp_id expHdr_employeeID,
111 default_curr_code expHdr_defaultCurrCode,
112 doc_num expHdr_invNum,
113 total expHdr_total,
114 payment_curr_code expHdr_payemntCurrCode,
115 week_end_date expHdr_weekEndDate
116 ); /* end TYPE ExpInfoRec */
117
118 TYPE ExpHeaderRec IS RECORD (
119 template_id VARCHAR2(20),
120 last_receipt_date VARCHAR2(25),
121 description expHdr_description,
122 default_curr_code expHdr_defaultCurrCode,
123 flex_concat expHdr_flexConcat,
124 override_appr_id VARCHAR2(15),
125 override_appr_name expHdr_overrideApprName,
126 emp_id expHdr_employeeID,
127 last_update_date VARCHAR2(25)
128 ); /* end TYPE ExpHeaderRec */
129
130 TYPE XpenseInfoRec IS RECORD (
131 report_header_id expHdr_headerID,
132 document_number expHdr_invNum,
133 employee_id expHdr_employeeID,
134 org_id expHdr_orgID,
135 vouchno expHdr_vouchno,
136 total expHdr_total,
137 vendor_id expHdr_vendorID,
138 vendor_site_id expHdr_vendorSiteID,
139 amt_due_employee expHdr_amtDueEmployee,
140 amt_due_ccard expHdr_amtDueCCardCompany,
141 description expHdr_description,
142 preparer_id expHdr_createdBy,
143 last_update_login expHdr_lastUpdateLogin,
144 last_updated_by expHdr_lastUpdatedBy,
145 workflow_flag VARCHAR2(20),
146 expense_check_address_flag expHdr_expCheckAddrFlag,
147 bothpay_report_header_id expHdr_bothpayParentID,
148 shortpay_parent_id expHdr_shortpayParentID,
149 behalf_employee_id expHdr_paidOnBehalfEmpID, --end of one function
150 approver_id expHdr_overrideApprID,
151 week_end_date expHdr_weekEndDate,
152 set_of_books_id expHdr_setOfBooksID,
153 source expHdr_source,
154 accts_pay_comb_id expHdr_acctsPayCodeCombID,
155 expense_status_code expHdr_expenseStatusCode
156 ); /* end TYPE XpenseInfoRec */
157
158
159 ----------------------------------------------------------------------------------------
160 -- Name: GetEmployeeIdFromBothPayParent
161 -- Desc: get employee_id from both pay parent report
162 -- Input: p_bothpay_parent_id - parent report header id
163 -- Output: p_employee_id - employee_id from both pay parent report
164 ---------------------------------------------------------------------------------------
165 PROCEDURE GetEmployeeIdFromBothPayParent(
166 p_bothpay_parent_id IN NUMBER,
167 p_employee_id OUT NOCOPY NUMBER);
168
169 ----------------------------------------------------------------------------------------
170 -- Name: GetRestorableReportsCursor
171 -- Desc: get invoice_num, employee full name, total, etc. for restorable expense reports
172 -- that employee with P_WebUserID has access to
173 -- Input: P_WebUserID - securing attribute's web_user_id
174 -- Output: p_cursor - cursor reference for RestorableReportsCursor
175 -- that stores information about the selected expense reports
176 -- Returns: true - succeeded
177 -- false - failed
178 ---------------------------------------------------------------------------------------
179 FUNCTION GetRestorableReportsCursor(P_WebUserID IN AK_WEB_USER_SEC_ATTR_VALUES.web_user_id%TYPE,
180 p_cursor OUT NOCOPY RestorableReportsCursor)
181 RETURN BOOLEAN;
182
183
184 ---------------------------------------------------------------------------
185 -- Name: GetExpWorkflowInfo
186 -- Desc: get invoice_num and workflow_approved_flag for a particular
187 -- expense report
188 -- Input: P_ReportID - report_header_id for the expense report
189 -- Output: P_WorkflowRec - stores information about the selected expense report in
190 -- ExpWorkflowRec
191 -- Returns: true - succeeded
192 -- false - failed
193 ---------------------------------------------------------------------------
194 FUNCTION GetExpWorkflowInfo(
195 P_ReportID IN expHdr_headerID,
196 P_WorkflowRec OUT NOCOPY ExpWorkflowRec)
197 RETURN BOOLEAN;
198
199
200 -------------------------------------------------------------------
201 -- Name: GetReportInfo
202 -- Desc: get employee_id, default_currency_code, invoice_num, and total
203 -- for a particular expense report
204 -- Input: p_expenseReportId - report_header_id for the expense report
205 -- Output: p_exp_info_rec - stores information about the selected expense report in
206 -- ExpInfoRec
207 -- Returns: true - succeeded
208 -- false - failed
209 -------------------------------------------------------------------
210 FUNCTION GetReportInfo(
211 p_expenseReportId IN expHdr_headerID,
212 p_exp_info_rec OUT NOCOPY ExpInfoRec
213 ) RETURN BOOLEAN;
214
215
216 -------------------------------------------------------------------------------------
217 -- Name: GetOverrideApproverID
218 -- Desc: get override_approver_id of a particular expense report
219 -- Input: p_report_header_id - report_header_id for the expense report
220 -- Output: p_id - stores override_approver_id of expense report
221 -- Returns: true - succeeded
222 -- false - failed
223 -------------------------------------------------------------------------------------
224 FUNCTION GetOverrideApproverID(p_report_header_id IN expHdr_headerID,
225 p_id OUT NOCOPY expHdr_overrideApprID)
226 RETURN BOOLEAN;
227
228
229 ----------------------------------------------------------------------------------
230 -- Name: GetOrgIdByReportHeaderId
231 -- Desc: get org_id of a particular expense report
232 -- Input: p_header_id - report_header_id for the expense report
233 -- Output: p_org_id - stores org_id of expense report
234 -- Returns: true - succeeded
235 -- false - failed
236 ----------------------------------------------------------------------------------
237 FUNCTION GetOrgIdByReportHeaderId(
238 p_header_id IN expHdr_headerID,
239 p_org_id OUT NOCOPY expHdr_orgID) RETURN BOOLEAN;
240
241 ---------------------------------------------------------------------------------------------
242 -- Name: GetReportHeaderAttributes
243 -- Desc: get hr_employee's default_code_combination_id, employee_id, expense report's
244 -- flex_concatenated, attribute_category, and attributes 1 thru 15
245 -- Input: p_report_header_id - report_header_id for the expense report
246 -- Output:
247 -- Returns: true - succeeded
248 -- false - failed
249 ---------------------------------------------------------------------------------------------
250 -------------------------------------------------------------------
251 FUNCTION GetReportHeaderAttributes(p_report_header_id IN expHdr_headerID,
252 p_default_comb_id OUT NOCOPY HR_EMPLOYEES_CURRENT_V.default_code_combination_id%TYPE,
253 p_emp_id OUT NOCOPY expHdr_employeeID,
254 p_flex_concat OUT NOCOPY expHdr_flexConcat,
255 p_attr_category OUT NOCOPY expHdr_attrCategory,
256 p_attr1 OUT NOCOPY expHdr_attr1,
257 p_attr2 OUT NOCOPY expHdr_attr2,
258 p_attr3 OUT NOCOPY expHdr_attr3,
259 p_attr4 OUT NOCOPY expHdr_attr4,
260 p_attr5 OUT NOCOPY expHdr_attr5,
261 p_attr6 OUT NOCOPY expHdr_attr6,
262 p_attr7 OUT NOCOPY expHdr_attr7,
263 p_attr8 OUT NOCOPY expHdr_attr8,
264 p_attr9 OUT NOCOPY expHdr_attr9,
265 p_attr10 OUT NOCOPY expHdr_attr10,
266 p_attr11 OUT NOCOPY expHdr_attr11,
267 p_attr12 OUT NOCOPY expHdr_attr12,
268 p_attr13 OUT NOCOPY expHdr_attr13,
269 p_attr14 OUT NOCOPY expHdr_attr14,
270 p_attr15 OUT NOCOPY expHdr_attr15)
271 RETURN BOOLEAN;
272 -------------------------------------------------------------------
273
274 -------------------------------------------------------------------
275 -- Name: GetReportHeaderInfo
276 -- Desc: get expense_report_id, description, default_currency_code,
277 -- flex_concatenated, employee_id, override_approver_name, etc.
278 -- for a particular expense report
279 -- Input: P_ReportID - report_header_id for the expense report
280 -- Output: P_ExpHdrRec - stores information about the selected expense report in
281 -- ExpHeaderRec
282 -- Returns: true - succeeded
283 -- false - failed
284 -------------------------------------------------------------------
285 FUNCTION GetReportHeaderInfo(P_ReportID IN expHdr_headerID,
286 P_ExpHdrRec OUT NOCOPY ExpHeaderRec)
287 RETURN BOOLEAN;
288
289 -------------------------------------------------------------------
290 -- Name: GetExpReportExchCurrInfo
291 -- Desc: get default_exchange_rate, precision of the expense report
292 -- and of the default currency
293 -- Input: p_report_id - report_header_id for the expense report
294 -- Output: p_exch_rate - the selected expense report's default exchange rate
295 -- p_reimb_precision - default currency's precision
296 -- Returns: true - succeeded
297 -- false - failed
298 -------------------------------------------------------------------
299 FUNCTION GetExpReportExchCurrInfo(p_report_id IN expHdr_headerID,
300 p_exch_rate OUT NOCOPY expHdr_defaultExchRate,
301 p_reimb_precision OUT NOCOPY FND_CURRENCIES_VL.PRECISION%TYPE
302 ) RETURN BOOLEAN;
303
304 -------------------------------------------------------------------
305 -- Name: GetNextExpReportID
306 -- Desc: get the next sequence for expense report's report_header_id
307 -- column
308 -- Output: p_new_report_id - new report_header_id for expense report
309 -- Returns: true - succeeded
310 -- false - failed
311 -------------------------------------------------------------------
312 FUNCTION GetNextExpReportID(p_new_report_id OUT NOCOPY NUMBER) RETURN BOOLEAN;
313
314 -------------------------------------------------------------------
315 FUNCTION GetNextRptHdrID(p_new_report_id OUT NOCOPY NUMBER) RETURN BOOLEAN;
316 -------------------------------------------------------------------
317
318 -------------------------------------------------------------------
319 -- Name: GetAccountingInfo
320 -- Desc: get some system accounting parameters, chart_of_accounts_id,
321 -- and employee information from the HR tables
322 -- Input: p_report_header_id - report_header_id for a given expense report
323 -- Output: p_sys_apply_advances_default - ap system parameter's apply_advances_default
324 -- p_sys_allow_awt_flag - ap system parameter's allow_awt_flag
325 -- p_sys_default_xrate_type - ap system parameter's default_exchange_rate_type
326 -- p_sys_make_rate_mandatory - ap system parameter's make_rate_mandatory_flag
327 -- p_exp_check_address_flag - HR's or financial system parameter's expense_check_address_flag
328 -- p_default_currency_code - expense report's default_currency_code
329 -- p_week_end_date - expense report's week_end_date
330 -- p_flex_concatenated - expense report's flex_concatenated
331 -- p_employee_id - expense report's employee_id
332 -- Returns: true - succeeded
333 -- false - failed
334 -------------------------------------------------------------------
335 FUNCTION GetAccountingInfo(
336 p_report_header_id IN expHdr_headerID,
337 p_sys_apply_advances_default OUT NOCOPY apSetUp_applyAdvDefault,
338 p_sys_allow_awt_flag OUT NOCOPY apSetUp_allowAWTFlag,
339 p_sys_default_xrate_type OUT NOCOPY apSetUp_defaultExchRateType,
340 p_sys_make_rate_mandatory OUT NOCOPY apSetUp_makeMandatoryFlag,
341 p_exp_check_address_flag OUT NOCOPY finSysParams_checkAddrFlag,
342 p_default_currency_code OUT NOCOPY expHdr_defaultCurrCode,
343 p_week_end_date OUT NOCOPY expHdr_weekEndDate,
344 p_flex_concatenated OUT NOCOPY expHdr_flexConcat,
345 p_employee_id OUT NOCOPY expHdr_employeeID)
346 RETURN BOOLEAN;
347
348 -------------------------------------------------------------------
349 -- Name: GetExpReportInfo
350 -- Desc: get concatenation of card_number/full_name, vendor_id's,
351 -- amt_due_ccard_company, and total for the credit card
352 -- expense report in both pay
353 -- Input: p_report_header_id - report_header_id for the expense report
354 -- Output: p_description - stores concatenation of credit card_number/employee full_name
355 -- p_ccard_amt - expense report's amt_due_ccard_company
356 -- p_total - expense report's total
357 -- Returns: true - succeeded
358 -- false - failed
359 -------------------------------------------------------------------
360 FUNCTION GetExpReportInfo(
361 p_report_header_id IN expHdr_headerID,
362 p_description OUT NOCOPY VARCHAR2,
363 p_ccard_amt OUT NOCOPY expHdr_amtDueCCardCompany,
364 p_total OUT NOCOPY expHdr_total
365 ) RETURN BOOLEAN;
366
367
368 FUNCTION ExpReportShortpaid(P_ReportID IN expHdr_headerID,
369 P_Shortpaid OUT NOCOPY BOOLEAN)
370 RETURN BOOLEAN;
371
372
373 -------------------------------------------------------------------
374 -- Name: InsertReportHeader
375 -- Desc: get
376 -- Input: p_report_header_id - report_header_id for the expense report
377 -- p_ExpReportHeaderInfo -
378 -- Returns: true - succeeded
379 -- false - failed
380 -------------------------------------------------------------------
381 FUNCTION InsertReportHeader(p_xpense_rec IN XpenseInfoRec,
382 p_ExpReportHeaderInfo IN AP_WEB_DFLEX_PKG.ExpReportHeaderRec
383 ) RETURN BOOLEAN;
384
385 -------------------------------------------------------------------
386 -- Name: InsertReportHeaderLikeExisting
387 -- Desc: get
388 -- Input: p_orig_report_header_id - report_header_id for the expense report
389 -- p_xpense_rec
390 -- Returns: true - succeeded
391 -- false - failed
392 -------------------------------------------------------------------
393 FUNCTION InsertReportHeaderLikeExisting(p_orig_report_header_id IN expHdr_headerID,
394 p_xpense_rec IN XpenseInfoRec
395 ) RETURN BOOLEAN;
396
397
398 -------------------------------------------------------------------
399 -- Name: SetDefaultExchRateType
400 -- Desc: Updates ap_expense_report_headers with a new default_exchange_rate_type
401 -- Input: p_report_header_id - report_header_id for the expense report
402 -- p_xrate_type - default_exchange_rate_type
403 -- Returns: true - succeeded
404 -- false - failed
405 -------------------------------------------------------------------
406 FUNCTION SetDefaultExchRateType(p_report_header_id IN expHdr_headerID,
407 p_xrate_type IN expHdr_defaultXchRateType)
408 RETURN BOOLEAN;
409
410 -------------------------------------------------------------------
411 -- Name: SetExpenseHeaderInfo
412 -- Desc: get
413 -- Input: p_report_header_id - report_header_id for the expense report
414 -- p_exp_check_address_flag
415 -- p_source
416 -- p_workflow_approve_flag
417 -- p_sys_apply_advances_default
418 -- p_available_prepays
419 -- p_sys_allow_awt_flag
420 -- p_ven_allow_awt_flag
421 -- p_ven_awt_group_id
422 -- p_sys_default_xrate_type
423 -- p_week_end_date
424 -- p_default_exchange_rate
425 -- p_employee_ccid
426 -- Returns: true - succeeded
427 -- false - failed
428 -------------------------------------------------------------------
429 FUNCTION SetExpenseHeaderInfo(
430 p_report_header_id IN expHdr_headerID,
431 p_exp_check_address_flag IN expHdr_expCheckAddrFlag,
432 p_source IN expHdr_source,
433 p_workflow_approve_flag IN expHdr_wkflApprvdFlag,
434 p_sys_apply_advances_default IN expHdr_applyAdvDefault,
435 p_available_prepays IN NUMBER,
436 p_sys_allow_awt_flag IN AP_SYSTEM_PARAMETERS.allow_awt_flag%TYPE,
437 p_ven_allow_awt_flag IN AP_SUPPLIERS.allow_awt_flag%TYPE,
438 p_ven_awt_group_id IN expHdr_awtGroupID,
439 p_sys_default_xrate_type IN expHdr_defaultXchRateType,
440 p_week_end_date IN expHdr_defaultExchDate,
441 p_default_exchange_rate IN expHdr_defaultExchRate,
442 p_employee_ccid IN expHdr_employeeCCID
443 ) RETURN BOOLEAN;
444
445
446 -------------------------------------------------------------------
447 -- Name: SetAmtDuesAndTotal
448 -- Desc: get
449 -- Input: p_report_header_id - report_header_id for the expense report
450 -- Returns: true - succeeded
451 -- false - failed
452 -------------------------------------------------------------------
453 FUNCTION SetAmtDuesAndTotal(
454 p_report_header_id IN expHdr_headerID,
455 p_amt_due_ccard_company IN expHdr_amtDueCCardCompany,
456 p_amt_due_employee IN expHdr_amtDueEmployee,
457 p_total IN expHdr_total
458 ) RETURN BOOLEAN;
459
460 -------------------------------------------------------------------
461 -- Name: SetBothpayReportHeader
462 -- Desc: get
463 -- Input: p_report_header_id - report_header_id for the expense report
464 -- Returns: true - succeeded
465 -- false - failed
466 -------------------------------------------------------------------
467 FUNCTION SetBothpayReportHeader(
468 p_report_header_id IN expHdr_headerID,
469 p_sub_total IN NUMBER,
470 p_vendor_id IN expHdr_vendorID,
471 p_vendor_site_id IN expHdr_vendorSiteID,
472 p_bothpay_id IN expHdr_bothpayParentID,
473 p_paid_on_behalf_id IN expHdr_paidOnBehalfEmpID,
474 p_total IN expHdr_total DEFAULT NULL,
475 p_amt_due_ccard_company IN expHdr_amtDueCCardCompany DEFAULT NULL,
476 p_employee_id IN expHdr_employeeID DEFAULT NULL,
477 p_description IN expHdr_description DEFAULT NULL,
478 p_source IN expHdr_source DEFAULT NULL,
479 p_accts_comb_id IN expHdr_acctsPayCodeCombID DEFAULT NULL
480 ) RETURN BOOLEAN;
481
482
483 -------------------------------------------------------------------
484 FUNCTION SetWkflApprvdFlag(p_report_header_id IN expHdr_headerID)
485 RETURN BOOLEAN;
486 -------------------------------------------------------------------
487
488 -------------------------------------------------------------------
489 FUNCTION SetWkflApprvdFlag2(p_report_header_id IN expHdr_headerID)
490 RETURN BOOLEAN;
491 -------------------------------------------------------------------
492
493 -------------------------------------------------------------------
494 -- Name: SetWkflApprvdFlagAndSource
495 -- Desc: get
496 -- Input: p_report_header_id - report_header_id for the expense report
497 -- Returns: true - succeeded
498 -- false - failed
499 -------------------------------------------------------------------
500 FUNCTION SetWkflApprvdFlagAndSource(
501 p_report_header_id IN expHdr_headerID,
502 p_flag IN expHdr_wkflApprvdFlag,
503 p_source IN expHdr_source
504 ) RETURN BOOLEAN;
505
506 -------------------------------------------------------------------
507 -- Name: DeleteReportHeaderAtDate
508 -- Desc: get
509 -- Input: P_ReportID - report_header_id for the expense report
510 -- Returns: true - succeeded
511 -- false - failed
512 -------------------------------------------------------------------
513 FUNCTION DeleteReportHeaderAtDate(
514 P_ReportID IN expHdr_headerID,
515 P_LastUpdateDate IN expHdr_lastUpdateDate DEFAULT NULL)
516 RETURN BOOLEAN;
517
518 -------------------------------------------------------------------
519 -- Name: DeleteExpenseReport
520 -- Desc: get
521 -- Input: p_report_header_id - report_header_id for the expense report
522 -- Returns: true - succeeded
523 -- false - failed
524 -------------------------------------------------------------------
525 FUNCTION DeleteExpenseReport(p_report_header_id IN expHdr_headerID)
526 RETURN BOOLEAN;
527
528 -------------------------------------------------------------------
529 -- Name: ResubmitExpenseReport
530 -- Desc: checks to see if report needs to be resubmitted
531 -- Input: p_workflow_approved_flag - workflow_approved_flag for the expense report
532 -- Returns: true - needs to be resubmitted
533 -- false - does not need to be resubmitted
534 -------------------------------------------------------------------
535 FUNCTION ResubmitExpenseReport(p_workflow_approved_flag IN VARCHAR2)
536 RETURN BOOLEAN;
537
538 -------------------------------------------------------------------
539 -- Name: DuplicateHeader
540 -- Desc: duplicates an Expense Report Header
541 -- Input: p_source_report_header_id - source expense report header id
542 -- Returns: p_target_report_header_id - target expense report header id
543 -------------------------------------------------------------------
544 PROCEDURE DuplicateHeader(
545 p_user_id IN NUMBER,
546 p_source_report_header_id IN expHdr_headerID,
547 p_target_report_header_id IN OUT NOCOPY expHdr_headerID);
548
549 --------------------------------------------------------------------------------
550
551 FUNCTION UpdateHeaderTotal(
552 p_report_header_id IN expHdr_headerID
553 ) RETURN BOOLEAN;
554 --------------------------------------------------------------------------------
555 FUNCTION GetReimbCurr(
556 p_expenseReportId IN expHdr_headerID,
557 p_payment_curr_code OUT NOCOPY expHdr_payemntCurrCode
558 ) RETURN BOOLEAN;
559 --------------------------------------------------------------------------------
560 FUNCTION GetHeaderTotal(p_report_header_id IN expHdr_headerID,
561 p_total OUT NOCOPY NUMBER)
562 RETURN BOOLEAN;
563
564 -------------------------------------------------------------------
565 FUNCTION getPaymentDueFromReport(
566 p_report_header_id IN expHdr_headerID,
567 p_paymentDueFromCode OUT NOCOPY VARCHAR2)
568 RETURN BOOLEAN;
569 ------------------------------------------------------------------------------
570
571 FUNCTION getPaymentDueFromReport(p_report_header_id IN expHdr_headerID)
572 RETURN VARCHAR2;
573 -------------------------------------------------------------------
574 FUNCTION getAuditReturnReasonInstr(
575 p_report_header_id IN expHdr_headerID,
576 p_return_reason OUT NOCOPY VARCHAR2,
577 P_return_instruction OUT NOCOPY VARCHAR2)
578 RETURN BOOLEAN;
579 ------------------------------------------------------------------------------
580
581 -------------------------------------------------------------------
582 PROCEDURE clearAuditReturnReasonInstr(
583 p_report_header_id IN expHdr_headerID);
584 ------------------------------------------------------------------------------
585
586 FUNCTION GetDefaultEmpCCID(
587 p_employee_id IN NUMBER,
588 p_default_emp_ccid OUT NOCOPY expHdr_employeeCCID)
589 RETURN BOOLEAN;
590
591 --------------------------------------------------------------------------------
592 FUNCTION GetChartOfAccountsID(
593 p_employee_id IN NUMBER,
594 p_chart_of_accounts_id OUT NOCOPY glsob_chartOfAccountsID)
595 RETURN BOOLEAN;
596
597 --------------------------------------------------------------------------------
598 FUNCTION GetFlexConcactenated(p_parameter_id IN ap_expense_report_params.parameter_id%TYPE,
599 p_FlexConcactenated OUT NOCOPY ap_expense_report_params.FLEX_CONCACTENATED%TYPE)
600 RETURN BOOLEAN;
601
602 --------------------------------------------------------------------------------
603 FUNCTION GetERInvoiceNumber(p_report_header_id IN NUMBER)
604 RETURN VARCHAR2;
605
606 --------------------------------------------------------------------------------
607 FUNCTION GetERWorkflowApprovedFlag(p_report_header_id IN NUMBER)
608 RETURN VARCHAR2;
609
610 --------------------------------------------------------------------------------
611 FUNCTION GetERLastUpdateDate(p_report_header_id IN NUMBER)
612 RETURN VARCHAR2;
613
614 --------------------------------------------------------------------------------
615
616
617 END AP_WEB_DB_EXPRPT_PKG;