1 PACKAGE AP_WEB_EXPENSE_WF AS
2 /* $Header: apwxwkfs.pls 120.37 2008/01/07 07:27:17 stalasil ship $ */
3
4 -- Constant names for projects workflow
5 C_CreditLineVersion CONSTANT NUMBER := 1;
6 C_NoMultiLineVersion CONSTANT NUMBER := 2;
7 C_ProjectIntegrationVersion CONSTANT NUMBER := 1;
8 C_11_0_3Version CONSTANT NUMBER := 2;
9 C_OIEH_Version CONSTANT NUMBER := 3;
10 C_OIEJ_Version CONSTANT NUMBER := 4;
11 C_R120_Version CONSTANT NUMBER := 5;
12 -- Constants used to indicate where ER submit from
13 C_SUBMIT_FROM_OIE CONSTANT VARCHAR2(1) := 'Y';
14 C_SUBMIT_FROM_BG CONSTANT VARCHAR2(1) := 'N';
15 --C_Unchanged CONSTANT VARCHAR2(1) := 'U';
16
17 FUNCTION GetFlowVersion(p_item_type IN VARCHAR2,
18 p_item_key IN VARCHAR2) RETURN NUMBER;
19
20 PROCEDURE StartExpenseReportProcess(p_report_header_id IN NUMBER,
21 p_preparer_id IN NUMBER,
22 p_employee_id IN NUMBER,
23 p_document_number IN VARCHAR2,
24 p_total IN NUMBER,
25 p_new_total IN NUMBER,
26 p_reimb_curr IN VARCHAR2,
27 p_cost_center IN VARCHAR2,
28 p_purpose IN VARCHAR2,
29 p_approver_id IN NUMBER,
30 p_week_end_date IN DATE,
31 p_workflow_flag IN VARCHAR2,
32 p_submit_from_oie IN VARCHAR2,
33 p_event_raised IN VARCHAR2 DEFAULT 'N');
34
35 PROCEDURE APValidateExpenseReport(p_item_type IN VARCHAR2,
36 p_item_key IN VARCHAR2,
37 p_actid IN NUMBER,
38 p_funmode IN VARCHAR2,
39 p_result OUT NOCOPY VARCHAR2);
40
41 PROCEDURE DoAPValidation(p_item_type IN VARCHAR2,
42 p_item_key IN VARCHAR2,
43 p_report_header_id IN AP_EXPENSE_REPORT_HEADERS.report_header_id%TYPE);
44
45
46 -------------------------------------------------------------------------------
47 PROCEDURE CashLineErrorsAP(document_id in varchar2,
48 display_type in varchar2,
49 document in out nocopy clob,
50 document_type in out nocopy varchar2);
51 -------------------------------------------------------------------------------
52 -------------------------------------------------------------------------------
53 PROCEDURE CashLineErrorsPreparer(document_id in varchar2,
54 display_type in varchar2,
55 document in out nocopy clob,
56 document_type in out nocopy varchar2);
57 -------------------------------------------------------------------------------
58 -------------------------------------------------------------------------------
59 PROCEDURE CCardLineErrorsAP(document_id in varchar2,
60 display_type in varchar2,
61 document in out nocopy clob,
62 document_type in out nocopy varchar2);
63 -------------------------------------------------------------------------------
64 -------------------------------------------------------------------------------
65 PROCEDURE CCardLineErrorsPreparer(document_id in varchar2,
66 display_type in varchar2,
67 document in out nocopy clob,
68 document_type in out nocopy varchar2);
69 -------------------------------------------------------------------------------
70
71 PROCEDURE BuildBothpayExpReport(p_item_type IN VARCHAR2,
72 p_item_key IN VARCHAR2,
73 p_actid IN NUMBER,
74 p_funmode IN VARCHAR2,
75 p_result OUT NOCOPY VARCHAR2);
76
77 PROCEDURE FindVendor(p_item_type IN VARCHAR2,
78 p_item_key IN VARCHAR2,
79 p_actid IN NUMBER,
80 p_funmode IN VARCHAR2,
81 p_result OUT NOCOPY VARCHAR2);
82
83 PROCEDURE CheckIfBothpay(p_item_type IN VARCHAR2,
84 p_item_key IN VARCHAR2,
85 p_actid IN NUMBER,
86 p_funmode IN VARCHAR2,
87 p_result OUT NOCOPY VARCHAR2);
88
89 PROCEDURE CheckIfSplit(p_item_type IN VARCHAR2,
90 p_item_key IN VARCHAR2,
91 p_actid IN NUMBER,
92 p_funmode IN VARCHAR2,
93 p_result OUT NOCOPY VARCHAR2);
94
95 PROCEDURE BuildManagerApprvlMessage(p_item_type IN VARCHAR2,
96 p_item_key IN VARCHAR2,
97 p_actid IN NUMBER,
98 p_funmode IN VARCHAR2,
99 p_result OUT NOCOPY VARCHAR2);
100
101 PROCEDURE ManagerApproved(p_item_type IN VARCHAR2,
102 p_item_key IN VARCHAR2,
103 p_actid IN NUMBER,
104 p_funmode IN VARCHAR2,
105 p_result OUT NOCOPY VARCHAR2);
106
107 PROCEDURE CheckSumMissingReceipts(p_item_type IN VARCHAR2,
108 p_item_key IN VARCHAR2,
109 p_actid IN NUMBER,
110 p_funmode IN VARCHAR2,
111 p_result OUT NOCOPY VARCHAR2);
112
113 PROCEDURE AnyReceiptRequired(p_item_type IN VARCHAR2,
114 p_item_key IN VARCHAR2,
115 p_actid IN NUMBER,
116 p_funmode IN VARCHAR2,
117 p_result OUT NOCOPY VARCHAR2);
118
119 PROCEDURE AnyJustificationRequired(p_item_type IN VARCHAR2,
120 p_item_key IN VARCHAR2,
121 p_actid IN NUMBER,
122 p_funmode IN VARCHAR2,
123 p_result OUT NOCOPY VARCHAR2);
124
125 PROCEDURE CreditLinesOnly(p_item_type IN VARCHAR2,
126 p_item_key IN VARCHAR2,
127 p_actid IN NUMBER,
128 p_funmode IN VARCHAR2,
129 p_result OUT NOCOPY VARCHAR2);
130
131 PROCEDURE APReviewComplete(p_item_type IN VARCHAR2,
132 p_item_key IN VARCHAR2,
133 p_actid IN NUMBER,
134 p_funmode IN VARCHAR2,
135 p_result OUT NOCOPY VARCHAR2);
136
137 PROCEDURE AnyAPAdjustments(p_item_type IN VARCHAR2,
138 p_item_key IN VARCHAR2,
139 p_actid IN NUMBER,
140 p_funmode IN VARCHAR2,
141 p_result OUT NOCOPY VARCHAR2);
142
143 PROCEDURE AllPassAPApproval(p_item_type IN VARCHAR2,
144 p_item_key IN VARCHAR2,
145 p_actid IN NUMBER,
146 p_funmode IN VARCHAR2,
147 p_result OUT NOCOPY VARCHAR2);
148
149 PROCEDURE Approved(p_item_type IN VARCHAR2,
150 p_item_key IN VARCHAR2,
151 p_actid IN NUMBER,
152 p_funmode IN VARCHAR2,
153 p_result OUT NOCOPY VARCHAR2);
154
155 PROCEDURE SplitExpenseReport(p_item_type IN VARCHAR2,
156 p_item_key IN VARCHAR2,
157 p_actid IN NUMBER,
158 p_funmode IN VARCHAR2,
159 p_result OUT NOCOPY VARCHAR2);
160
161 PROCEDURE DeleteExpenseReport(p_item_type IN VARCHAR2,
162 p_item_key IN VARCHAR2,
163 p_actid IN NUMBER,
164 p_funmode IN VARCHAR2,
165 p_result OUT NOCOPY VARCHAR2);
166
167 /*PROCEDURE StartAPApprvlSubProcess(p_item_type IN VARCHAR2,
168 p_item_key IN VARCHAR2,
169 p_actid IN NUMBER,
170 p_funmode IN VARCHAR2,
171 p_result OUT NOCOPY VARCHAR2);
172
173 PROCEDURE StartManagerApprvlSubProcess(p_item_type IN VARCHAR2,
174 p_item_key IN VARCHAR2,
175 p_actid IN NUMBER,
176 p_funmode IN VARCHAR2,
177 p_result OUT NOCOPY VARCHAR2);
178 */
179
180 PROCEDURE GetPreparerManager(p_item_type IN VARCHAR2,
181 p_item_key IN VARCHAR2,
182 p_actid IN NUMBER,
183 p_funmode IN VARCHAR2,
184 p_result OUT NOCOPY VARCHAR2);
185
186 PROCEDURE GetApproverManager(p_item_type IN VARCHAR2,
187 p_item_key IN VARCHAR2,
188 p_actid IN NUMBER,
189 p_funmode IN VARCHAR2,
190 p_result OUT NOCOPY VARCHAR2);
191
192 PROCEDURE ApproverProvided(p_item_type IN VARCHAR2,
193 p_item_key IN VARCHAR2,
194 p_actid IN NUMBER,
195 p_funmode IN VARCHAR2,
196 p_result OUT NOCOPY VARCHAR2);
197
198 PROCEDURE SameCostCenters(p_item_type IN VARCHAR2,
199 p_item_key IN VARCHAR2,
200 p_actid IN NUMBER,
201 p_funmode IN VARCHAR2,
202 p_result OUT NOCOPY VARCHAR2);
203
204 PROCEDURE SetApproverEqualManager(p_item_type IN VARCHAR2,
205 p_item_key IN VARCHAR2,
206 p_actid IN NUMBER,
207 p_funmode IN VARCHAR2,
208 p_result OUT NOCOPY VARCHAR2);
209
210 PROCEDURE RecordForwardFromInfo(p_item_type IN VARCHAR2,
211 p_item_key IN VARCHAR2,
212 p_actid IN NUMBER,
213 p_funmode IN VARCHAR2,
214 p_result OUT NOCOPY VARCHAR2);
215
216 PROCEDURE ManagerNotEqualToApprover(p_item_type IN VARCHAR2,
217 p_item_key IN VARCHAR2,
218 p_actid IN NUMBER,
219 p_funmode IN VARCHAR2,
220 p_result OUT NOCOPY VARCHAR2);
221
222 PROCEDURE NotifyPreparer(p_item_type IN VARCHAR2,
223 p_item_key IN VARCHAR2,
224 p_actid IN NUMBER,
225 p_funmode IN VARCHAR2,
226 p_result OUT NOCOPY VARCHAR2);
227
228 PROCEDURE OpenExp(p1 varchar2,
229 p2 varchar2,
230 p11 varchar2 Default NULL);
231
232
233 PROCEDURE SetPersonAs(p_manager_id IN NUMBER,
234 p_item_type IN VARCHAR2,
235 p_item_key IN VARCHAR2,
236 p_manager_target IN VARCHAR2);
237
238 PROCEDURE GetManager(p_employee_id IN HR_EMPLOYEES_CURRENT_V.employee_id%TYPE,
239 p_manager_id OUT NOCOPY HR_EMPLOYEES_CURRENT_V.employee_id%TYPE);
240
241 -- 3257576 added new parameters p_error_message, p_instructions,
242 -- p_special_instr
243 PROCEDURE GetFinalApprover(p_employee_id IN NUMBER,
244 p_override_approver_id IN NUMBER,
245 p_emp_cost_center IN VARCHAR2,
246 p_doc_cost_center IN VARCHAR2,
247 p_approval_amount IN NUMBER,
248 p_item_key IN VARCHAR2,
249 p_item_type IN VARCHAR2,
250 p_final_approver_id OUT NOCOPY NUMBER,
251 p_error_message OUT NOCOPY VARCHAR2,
252 p_instructions OUT NOCOPY VARCHAR2,
253 p_special_instr OUT NOCOPY VARCHAR2);
254
255 PROCEDURE AMEEnabled(p_item_type IN VARCHAR2,
256 p_item_key IN VARCHAR2,
257 p_actid IN NUMBER,
258 p_funmode IN VARCHAR2,
259 p_result OUT NOCOPY VARCHAR2);
260
261 PROCEDURE FirstApprover(p_item_type IN VARCHAR2,
262 p_item_key IN VARCHAR2,
263 p_actid IN NUMBER,
264 p_funmode IN VARCHAR2,
265 p_result OUT NOCOPY VARCHAR2);
266
267 PROCEDURE ResetEmpCostCenter(p_item_type IN VARCHAR2,
268 p_item_key IN VARCHAR2,
269 p_actid IN NUMBER,
270 p_funmode IN VARCHAR2,
271 p_result OUT NOCOPY VARCHAR2);
272
273 PROCEDURE ApprovalForwarded(p_item_type IN VARCHAR2,
274 p_item_key IN VARCHAR2,
275 p_actid IN NUMBER,
276 p_funmode IN VARCHAR2,
277 p_result OUT NOCOPY VARCHAR2);
278
279 PROCEDURE PayablesReviewed(p_item_type IN VARCHAR2,
280 p_item_key IN VARCHAR2,
281 p_actid IN NUMBER,
282 p_funmode IN VARCHAR2,
283 p_result OUT NOCOPY VARCHAR2);
284
285 PROCEDURE EmployeeEqualsToPreparer(p_item_type IN VARCHAR2,
286 p_item_key IN VARCHAR2,
287 p_actid IN NUMBER,
288 p_funmode IN VARCHAR2,
289 p_result OUT NOCOPY VARCHAR2);
290
291 PROCEDURE EmployeeApprovalRequired(p_item_type IN VARCHAR2,
292 p_item_key IN VARCHAR2,
293 p_actid IN NUMBER,
294 p_funmode IN VARCHAR2,
295 p_result OUT NOCOPY VARCHAR2);
296
297 PROCEDURE DetermineStartFromProcess(p_item_type IN VARCHAR2,
298 p_item_key IN VARCHAR2,
299 p_actid IN NUMBER,
300 p_funmode IN VARCHAR2,
301 p_result OUT NOCOPY VARCHAR2);
302
303 PROCEDURE SetRejectStatusAndResetAttr(p_item_type IN VARCHAR2,
304 p_item_key IN VARCHAR2,
305 p_actid IN NUMBER,
306 p_funmode IN VARCHAR2,
307 p_result OUT NOCOPY VARCHAR2);
308
309 PROCEDURE SetEmployeeAsApprover(p_item_type IN VARCHAR2,
310 p_item_key IN VARCHAR2,
311 p_actid IN NUMBER,
312 p_funmode IN VARCHAR2,
313 p_result OUT NOCOPY VARCHAR2);
314
315 PROCEDURE MissingReceiptShortPay(p_item_type IN VARCHAR2,
316 p_item_key IN VARCHAR2,
317 p_actid IN NUMBER,
318 p_funmode IN VARCHAR2,
319 p_result OUT NOCOPY VARCHAR2);
320
321 PROCEDURE PolicyViolationShortPay(p_item_type IN VARCHAR2,
322 p_item_key IN VARCHAR2,
323 p_actid IN NUMBER,
324 p_funmode IN VARCHAR2,
325 p_result OUT NOCOPY VARCHAR2);
326
327 PROCEDURE StartFromAPApproval(p_item_type IN VARCHAR2,
328 p_item_key IN VARCHAR2,
329 p_actid IN NUMBER,
330 p_funmode IN VARCHAR2,
331 p_result OUT NOCOPY VARCHAR2);
332
333 PROCEDURE StartFromManagerApproval(p_item_type IN VARCHAR2,
334 p_item_key IN VARCHAR2,
335 p_actid IN NUMBER,
336 p_funmode IN VARCHAR2,
337 p_result OUT NOCOPY VARCHAR2);
338
339 PROCEDURE StartPolicyShortPayProcess(p_item_type IN VARCHAR2,
340 p_item_key IN VARCHAR2,
341 p_actid IN NUMBER,
342 p_funmode IN VARCHAR2,
343 p_result OUT NOCOPY VARCHAR2);
344
345 PROCEDURE StartNoReceiptsShortPayProcess(p_item_type IN VARCHAR2,
346 p_item_key IN VARCHAR2,
347 p_actid IN NUMBER,
348 p_funmode IN VARCHAR2,
349 p_result OUT NOCOPY VARCHAR2);
350
351
352 PROCEDURE CheckIfShortPaid(p_item_type IN VARCHAR2,
353 p_item_key IN VARCHAR2,
354 p_actid IN NUMBER,
355 p_funmode IN VARCHAR2,
356 p_result OUT NOCOPY VARCHAR2);
357
358
359 PROCEDURE RequireProofOfPayment(p_item_type IN VARCHAR2,
360 p_item_key IN VARCHAR2,
361 p_actid IN NUMBER,
362 p_funmode IN VARCHAR2,
363 p_result OUT NOCOPY VARCHAR2);
364
365 PROCEDURE GenerateExpLines(document_id IN VARCHAR2,
366 display_type IN VARCHAR2,
367 document IN OUT NOCOPY VARCHAR2,
368 document_type IN OUT NOCOPY VARCHAR2);
369
370 PROCEDURE GenerateDocumentAttributeValue(document_id IN VARCHAR2,
371 display_type IN VARCHAR2,
372 document IN OUT NOCOPY VARCHAR2,
373 document_type IN OUT NOCOPY VARCHAR2);
374
375 PROCEDURE GenerateAdjustmentInfo(document_id IN VARCHAR2,
376 display_type IN VARCHAR2,
377 document IN OUT NOCOPY VARCHAR2,
378 document_type IN OUT NOCOPY VARCHAR2);
379
380 PROCEDURE GenerateAdjustmentInfoClob(document_id IN VARCHAR2,
381 display_type IN VARCHAR2,
382 document IN OUT NOCOPY CLOB,
383 document_type IN OUT NOCOPY VARCHAR2);
384
385 PROCEDURE ResetLineInfo(document_id IN VARCHAR2,
386 display_type IN VARCHAR2,
387 document IN OUT NOCOPY VARCHAR2,
388 document_type IN OUT NOCOPY VARCHAR2);
389
390 PROCEDURE CallbackFunction( p_s_item_type IN VARCHAR2,
391 p_s_item_key IN VARCHAR2,
392 p_n_actid IN NUMBER,
393 p_s_command IN VARCHAR2,
394 p_s_result OUT NOCOPY VARCHAR2);
395
396 PROCEDURE IsPreparerToAuditorTransferred(
397 p_item_type IN VARCHAR2,
398 p_item_key IN VARCHAR2,
399 p_actid IN NUMBER,
400 p_funmode IN VARCHAR2,
401 p_result OUT NOCOPY VARCHAR2);
402
403 PROCEDURE IsApprovalRequestTransferred(
404 p_item_type IN VARCHAR2,
405 p_item_key IN VARCHAR2,
406 p_actid IN NUMBER,
407 p_funmode IN VARCHAR2,
408 p_result OUT NOCOPY VARCHAR2);
409
410 PROCEDURE CheckWFAdminNote(
411 p_item_type IN VARCHAR2,
412 p_item_key IN VARCHAR2,
413 p_actid IN NUMBER,
414 p_funmode IN VARCHAR2,
415 p_result OUT NOCOPY VARCHAR2);
416
417 PROCEDURE SetReturnStatusAndResetAttr(p_item_type IN VARCHAR2,
418 p_item_key IN VARCHAR2,
419 p_actid IN NUMBER,
420 p_funmode IN VARCHAR2,
421 p_result OUT NOCOPY VARCHAR2);
422
423 PROCEDURE SetFromRoleBeforeApproval(
424 p_item_type IN VARCHAR2,
425 p_item_key IN VARCHAR2,
426 p_actid IN NUMBER,
427 p_funmode IN VARCHAR2,
428 p_result OUT NOCOPY VARCHAR2);
429
430 PROCEDURE SetFromRolePreparer(
431 p_item_type IN VARCHAR2,
432 p_item_key IN VARCHAR2,
433 p_actid IN NUMBER,
434 p_funmode IN VARCHAR2,
435 p_result OUT NOCOPY VARCHAR2);
436
437 PROCEDURE SetFromRoleEmployee(
438 p_item_type IN VARCHAR2,
439 p_item_key IN VARCHAR2,
440 p_actid IN NUMBER,
441 p_funmode IN VARCHAR2,
442 p_result OUT NOCOPY VARCHAR2);
443
444 PROCEDURE SetFromRoleForwardFrom(
445 p_item_type IN VARCHAR2,
446 p_item_key IN VARCHAR2,
447 p_actid IN NUMBER,
448 p_funmode IN VARCHAR2,
449 p_result OUT NOCOPY VARCHAR2);
450
451 PROCEDURE SetFromRoleApprover(
452 p_item_type IN VARCHAR2,
453 p_item_key IN VARCHAR2,
454 p_actid IN NUMBER,
455 p_funmode IN VARCHAR2,
456 p_result OUT NOCOPY VARCHAR2);
457
458 PROCEDURE SetStatusApproverAndDate(
459 p_item_type IN VARCHAR2,
460 p_item_key IN VARCHAR2,
461 p_actid IN NUMBER,
462 p_funmode IN VARCHAR2,
463 p_result OUT NOCOPY VARCHAR2);
464
465 PROCEDURE ZeroFindApproverCount(p_item_type IN VARCHAR2,
466 p_item_key IN VARCHAR2,
467 p_actid IN NUMBER,
468 p_funmode IN VARCHAR2,
469 p_result OUT NOCOPY VARCHAR2);
470
471 --ER 1552747 - withdraw expense report
472 PROCEDURE WithdrawExpenseRep(
473 p_rep_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE);
474
475 PROCEDURE GenerateExpClobLines(document_id IN VARCHAR2,
476 display_type IN VARCHAR2,
477 document IN OUT NOCOPY CLOB,
478 document_type IN OUT NOCOPY VARCHAR2);
479
480 ---------------------------------------------------------
481 PROCEDURE determineMileageAdjusted(p_item_type IN VARCHAR2,
482 p_item_key IN VARCHAR2,
483 p_actid IN NUMBER,
484 p_funmode IN VARCHAR2,
485 p_result OUT NOCOPY VARCHAR2);
486
487 ---------------------------------------------------------
488 PROCEDURE getScheduleLineArray(
489 p_report_header_id IN NUMBER,
490 p_distribution_line_number IN NUMBER,
491 p_employee_id IN NUMBER,
492 p_cumulative_mileage IN NUMBER,
493 p_schedule_line_array OUT NOCOPY AP_WEB_DB_SCHLINE_PKG.Schedule_Line_Array);
494 ---------------------------------------------------------
495
496 PROCEDURE updateCumulativeMileage(
497 p_cumulative_mileage IN AP_WEB_EMPLOYEE_INFO.NUMERIC_VALUE%TYPE,
498 p_period_id IN AP_WEB_EMPLOYEE_INFO.PERIOD_ID%TYPE,
499 p_employee_id IN AP_WEB_EMPLOYEE_INFO.EMPLOYEE_ID%TYPE);
500
501 ---------------------------------------------------------
502 FUNCTION getRate(
503 p_sh_distance_uom IN AP_POL_HEADERS.distance_uom%TYPE,
504 p_sh_currency_code IN AP_POL_HEADERS.currency_code%TYPE,
505 p_mileage_line IN AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Rec,
506 p_schedule_line IN AP_WEB_DB_SCHLINE_PKG.Schedule_Line_Rec)
507 RETURN NUMBER;
508
509 ---------------------------------------------------------
510 PROCEDURE copyMileageArray(
511 p_from_array IN AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Array,
512 p_to_array OUT NOCOPY AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Array);
513
514 ---------------------------------------------------------
515 PROCEDURE addToMileageArray(
516 p_index IN NUMBER,
517 p_new_dist_number IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
518 p_trip_dist IN AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE,
519 p_daily_distance IN AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE,
520 p_rate IN AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE,
521 p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
522 p_from_index IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
523 p_mileage_line_array IN OUT NOCOPY AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Array);
524
525 ---------------------------------------------------------
526 PROCEDURE updateNewDistNumber(
527 p_index IN NUMBER,
528 p_last_index IN NUMBER,
529 p_added_total IN NUMBER,
530 p_mileage_line_array IN OUT NOCOPY AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Array);
531
532 ---------------------------------------------------------
533 PROCEDURE processCrossThreshold(
534 p_ml_index IN NUMBER,
535 p_sh_distance_uom IN AP_POL_HEADERS.DISTANCE_UOM%TYPE,
536 p_sh_currency_code IN AP_POL_HEADERS.CURRENCY_CODE%TYPE,
537 p_schedule_line_array IN AP_WEB_DB_SCHLINE_PKG.Schedule_Line_Array,
538 p_mileage_line_array_count IN OUT NOCOPY NUMBER,
539 p_cumulative_mileage IN OUT NOCOPY AP_WEB_EMPLOYEE_INFO.NUMERIC_VALUE%TYPE,
540 p_mileage_line_array IN OUT NOCOPY AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Array);
541
542 ---------------------------------------------------------
543 PROCEDURE ProcessMileageLines(p_item_type IN VARCHAR2,
544 p_item_key IN VARCHAR2,
545 p_actid IN NUMBER,
546 p_funmode IN VARCHAR2,
547 p_result OUT NOCOPY VARCHAR2);
548
549 ---------------------------------------------------------
550 PROCEDURE hasCompanyViolations( p_item_type IN VARCHAR2,
551 p_item_key IN VARCHAR2,
552 p_actid IN NUMBER,
553 p_funmode IN VARCHAR2,
554 p_result OUT NOCOPY VARCHAR2);
555 ---------------------------------------------------------
556
557 -------------------------------------------------------------------------------
558 PROCEDURE AddToHeaderErrors(p_item_type IN VARCHAR2,
559 p_item_key IN VARCHAR2,
560 p_header_error IN VARCHAR2);
561 -------------------------------------------------------------------------------
562 PROCEDURE GenerateHeaderErrors(document_id IN VARCHAR2,
563 display_type IN VARCHAR2,
564 document IN OUT NOCOPY VARCHAR2,
565 document_type IN OUT NOCOPY VARCHAR2);
566 -------------------------------------------------------------------------------
567
568 -------------------------------------------------------------------------------
569 PROCEDURE GenerateAmountMsg(document_id IN VARCHAR2,
570 display_type IN VARCHAR2,
571 document IN OUT NOCOPY VARCHAR2,
572 document_type IN OUT NOCOPY VARCHAR2);
573
574 -------------------------------------------------------------------------------
575
576 -------------------------------------------------------------------------------
577 PROCEDURE GetRespAppInfo(p_item_key IN VARCHAR2,
578 p_resp_id OUT NOCOPY NUMBER,
579 P_appl_id OUT NOCOPY NUMBER);
580 -------------------------------------------------------------------------------
581
582 ---------------------------------------------------------
583 PROCEDURE GetAuditType( p_item_type IN VARCHAR2,
584 p_item_key IN VARCHAR2,
585 p_actid IN NUMBER,
586 p_funmode IN VARCHAR2,
587 p_result OUT NOCOPY VARCHAR2);
588 ---------------------------------------------------------
589
590 ---------------------------------------------------------
591 PROCEDURE ResetWFNote(p_item_type IN VARCHAR2,
592 p_item_key IN VARCHAR2,
593 p_actid IN NUMBER,
594 p_funmode IN VARCHAR2,
595 p_result OUT NOCOPY VARCHAR2);
596 ---------------------------------------------------------
597
598 PROCEDURE AddToOtherErrors(p_item_type IN VARCHAR2,
599 p_item_key IN VARCHAR2,
600 p_other_error IN VARCHAR2);
601 -------------------------------------------------------------------------------
602
603 /**
604 * jrautiai ADJ Fix start
605 */
606
607 /**
608 * Setting the from field to AP. Used for adjustment and shortpay notifications.
609 */
610 PROCEDURE SetFromRoleAP(
611 p_item_type IN VARCHAR2,
612 p_item_key IN VARCHAR2,
613 p_actid IN NUMBER,
614 p_funmode IN VARCHAR2,
615 p_result OUT NOCOPY VARCHAR2);
616
617 /**
618 * Build the policy violation message, this is used to detect whether
619 * we are building a policy or missing receipt notification.
620 */
621 PROCEDURE SetPolicyInfo(p_item_type IN VARCHAR2,
622 p_item_key IN VARCHAR2,
623 p_actid IN NUMBER,
624 p_funmode IN VARCHAR2,
625 p_result OUT NOCOPY VARCHAR2);
626
627 /**
628 * Build the missing receipts message, this is used to detect whether
629 * we are building a policy or missing receipt notification.
630 */
631 PROCEDURE SetMissingReceiptInfo(p_item_type IN VARCHAR2,
632 p_item_key IN VARCHAR2,
633 p_actid IN NUMBER,
634 p_funmode IN VARCHAR2,
635 p_result OUT NOCOPY VARCHAR2);
636
637 /**
638 * This procedure was modified with adding a parameter indicating the notification type.
639 * This is called by the wrappers above.
640 */
641 PROCEDURE SetShortPaidLinesInfo(p_item_type IN VARCHAR2,
642 p_item_key IN VARCHAR2,
643 p_actid IN NUMBER,
644 p_funmode IN VARCHAR2,
645 p_notification_type IN VARCHAR2,
646 p_result OUT NOCOPY VARCHAR2);
647
648 /**
649 * Build the provide missing info to AP message.
650 */
651 PROCEDURE SetProvideMissingInfo(p_item_type IN VARCHAR2,
652 p_item_key IN VARCHAR2,
653 p_actid IN NUMBER,
654 p_funmode IN VARCHAR2,
655 p_result OUT NOCOPY VARCHAR2);
656 ------------------------------------------------------------------------
657
658 /**
659 * Moved the constants to the package specification, so they are visible for other packages too.
660 */
661 C_BothPay CONSTANT VARCHAR2(10) := 'BOTH';
662 C_CompanyPay CONSTANT VARCHAR2(10) := 'COMPANY';
663 C_IndividualPay CONSTANT VARCHAR2(10) := 'INDIVIDUAL';
664
665 PROCEDURE ResetShortpayAdjustmentInfo(p_item_type IN VARCHAR2,
666 p_item_key IN VARCHAR2,
667 p_actid IN NUMBER,
668 p_funmode IN VARCHAR2,
669 p_result OUT NOCOPY VARCHAR2);
670
671 /**
672 * jrautiai ADJ Fix end
673 */
674
675 ------------------------------------------------------------------------
676 PROCEDURE CheckAPReviewResult(
677 p_item_type IN VARCHAR2,
678 p_item_key IN VARCHAR2,
679 p_actid IN NUMBER,
680 p_funmode IN VARCHAR2,
681 p_result OUT NOCOPY VARCHAR2);
682 ------------------------------------------------------------------------
683
684 ------------------------------------------------------------------------
685 PROCEDURE AddToAuditQueue(
686 p_item_type IN VARCHAR2,
687 p_item_key IN VARCHAR2,
688 p_actid IN NUMBER,
689 p_funmode IN VARCHAR2,
690 p_result OUT NOCOPY VARCHAR2);
691 ------------------------------------------------------------------------
692
693 ------------------------------------------------------------------------
694 PROCEDURE RemoveFromAuditQueue(
695 p_item_type IN VARCHAR2,
696 p_item_key IN VARCHAR2,
697 p_actid IN NUMBER,
698 p_funmode IN VARCHAR2,
699 p_result OUT NOCOPY VARCHAR2);
700 ------------------------------------------------------------------------
701
702 ------------------------------------------------------------------------
703 PROCEDURE StoreNote(
704 p_item_type IN VARCHAR2,
705 p_item_key IN VARCHAR2,
706 p_actid IN NUMBER,
707 p_funmode IN VARCHAR2,
708 p_result IN OUT NOCOPY VARCHAR2);
709 ------------------------------------------------------------------------
710
711
712 --Notification Esc :
713 -----------------------------------------------------------------------
714 procedure GetJobLevelAndSupervisor(
715 p_personId IN NUMBER,
716 p_jobLevel OUT NOCOPY NUMBER);
717 ------------------------------------------------------------------------
718
719 ------------------------------------------------------------------------
720 PROCEDURE IsEmployeeTerminated(p_item_type IN VARCHAR2,
721 p_item_key IN VARCHAR2,
722 p_actid IN NUMBER,
723 p_funmode IN VARCHAR2,
724 p_result OUT NOCOPY VARCHAR2);
725 ------------------------------------------------------------------------
726 ------------------------------------------------------------------------
727 PROCEDURE IsEmployeeActive(p_item_type IN VARCHAR2,
728 p_item_key IN VARCHAR2,
729 p_actid IN NUMBER,
730 p_funmode IN VARCHAR2,
731 p_result OUT NOCOPY VARCHAR2);
732 ------------------------------------------------------------------------
733
734 ------------------------------------------------------------------------
735 PROCEDURE IsManagerActive(p_item_type IN VARCHAR2,
736 p_item_key IN VARCHAR2,
737 p_actid IN NUMBER,
738 p_funmode IN VARCHAR2,
739 p_result OUT NOCOPY VARCHAR2);
740 ------------------------------------------------------------------------
741
742
743 -- 3257576 - Gets the manager info and sets p_error_message, p_instructions
744 -- p_special_instr if manager is terminated or does not exist or is suspended
745 ------------------------------------------------------------------------
746 PROCEDURE GetManagerInfoAndCheckStatus(
747 p_employee_id IN NUMBER,
748 p_employee_name IN VARCHAR2,
749 p_manager_id OUT NOCOPY NUMBER,
750 p_manager_name OUT NOCOPY VARCHAR2,
751 p_manager_status OUT NOCOPY VARCHAR2,
752 p_error_message OUT NOCOPY VARCHAR2,
753 p_instructions OUT NOCOPY VARCHAR2,
754 p_special_instr OUT NOCOPY VARCHAR2
755 );
756 ------------------------------------------------------------------------
757
758 --Bug 3389386
759 ------------------------------------------------------------------------
760 Procedure SetExpenseStatusCode(p_report_header_id IN Number);
761 ------------------------------------------------------------------------
762
763 --Bug 2777245
764 ------------------------------------------------------------------------
765 Procedure UpdateHeaderLines(
766 p_report_header_id IN Number);
767 ------------------------------------------------------------------------
768
769 ------------------------------------------------------------------------
770 Procedure RaiseSubmitEvent(
771 p_report_header_id IN Number,
772 p_workflow_appr_flag IN VARCHAR2);
773 ------------------------------------------------------------------------
774 ------------------------------------------------------------------------
775 PROCEDURE InitSubmit(
776 p_item_type IN VARCHAR2,
777 p_item_key IN VARCHAR2,
778 p_actid IN NUMBER,
779 p_funmode IN VARCHAR2,
780 p_result IN OUT NOCOPY VARCHAR2);
781 ------------------------------------------------------------------------
782
783 ------------------------------------------------------------------------
784 FUNCTION CheckAccess(
785 p_ntf_id IN NUMBER,
786 p_item_key IN NUMBER,
787 p_user_name IN VARCHAR2) RETURN VARCHAR2;
788 ------------------------------------------------------------------------
789
790 PROCEDURE AMERequestApproval(p_item_type IN VARCHAR2,
791 p_item_key IN VARCHAR2,
792 p_actid IN NUMBER,
793 p_funmode IN VARCHAR2,
794 p_result OUT NOCOPY VARCHAR2);
795
796 PROCEDURE AMEGetApprovalType(p_item_type IN VARCHAR2,
797 p_item_key IN VARCHAR2,
798 p_actid IN NUMBER,
799 p_funmode IN VARCHAR2,
800 p_result OUT NOCOPY VARCHAR2);
801
802 PROCEDURE AMEPropagateApprovalResult(p_item_type IN VARCHAR2,
803 p_item_key IN VARCHAR2,
804 p_actid IN NUMBER,
805 p_funmode IN VARCHAR2,
806 p_result OUT NOCOPY VARCHAR2);
807
808 PROCEDURE AMEGetApprovalResult(p_item_type IN VARCHAR2,
809 p_item_key IN VARCHAR2,
810 p_actid IN NUMBER,
811 p_funmode IN VARCHAR2,
812 p_result OUT NOCOPY VARCHAR2);
813
814 PROCEDURE AMECompleteApproval(p_item_type IN VARCHAR2,
815 p_item_key IN VARCHAR2,
816 p_actid IN NUMBER,
817 p_funmode IN VARCHAR2,
818 p_result OUT NOCOPY VARCHAR2);
819
820 PROCEDURE AMESetCurrentApprover(p_item_type IN VARCHAR2,
821 p_item_key IN VARCHAR2,
822 p_actid IN NUMBER,
823 p_funmode IN VARCHAR2,
824 p_result OUT NOCOPY VARCHAR2);
825
826 FUNCTION IsExpAccountsUpdated(p_report_line_id IN NUMBER) RETURN VARCHAR2;
827
828 FUNCTION getItemKey(p_notification_id IN NUMBER) RETURN VARCHAR2;
829
830 ------------------------------------------------------------------------
831 PROCEDURE IsPreparerActive(p_item_type IN VARCHAR2,
832 p_item_key IN VARCHAR2,
833 p_actid IN NUMBER,
834 p_funmode IN VARCHAR2,
835 p_result OUT NOCOPY VARCHAR2);
836 ------------------------------------------------------------------------
837
838 END AP_WEB_EXPENSE_WF;