1 PACKAGE AP_WEB_EXPENSE_WF AUTHID CURRENT_USER AS
2 /* $Header: apwxwkfs.pls 120.41.12020000.3 2013/01/29 11:20:37 saprayag 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 UpdateApproverIdInHeaders(
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 CheckWFAdminNote(
418 p_item_type IN VARCHAR2,
419 p_item_key IN VARCHAR2,
420 p_actid IN NUMBER,
421 p_funmode IN VARCHAR2,
422 p_result OUT NOCOPY VARCHAR2);
423
424 PROCEDURE SetReturnStatusAndResetAttr(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 SetFromRoleBeforeApproval(
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 SetFromRolePreparer(
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 SetFromRoleEmployee(
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 SetFromRoleForwardFrom(
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 SetFromRoleApprover(
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 SetStatusApproverAndDate(
466 p_item_type IN VARCHAR2,
467 p_item_key IN VARCHAR2,
468 p_actid IN NUMBER,
469 p_funmode IN VARCHAR2,
470 p_result OUT NOCOPY VARCHAR2);
471
472 PROCEDURE ZeroFindApproverCount(p_item_type IN VARCHAR2,
473 p_item_key IN VARCHAR2,
474 p_actid IN NUMBER,
475 p_funmode IN VARCHAR2,
476 p_result OUT NOCOPY VARCHAR2);
477
478 --ER 1552747 - withdraw expense report
479 PROCEDURE WithdrawExpenseRep(
480 p_rep_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE);
481
482 PROCEDURE GenerateExpClobLines(document_id IN VARCHAR2,
483 display_type IN VARCHAR2,
484 document IN OUT NOCOPY CLOB,
485 document_type IN OUT NOCOPY VARCHAR2);
486
487 ---------------------------------------------------------
488 PROCEDURE determineMileageAdjusted(p_item_type IN VARCHAR2,
489 p_item_key IN VARCHAR2,
490 p_actid IN NUMBER,
491 p_funmode IN VARCHAR2,
492 p_result OUT NOCOPY VARCHAR2);
493
494 ---------------------------------------------------------
495 PROCEDURE getScheduleLineArray(
496 p_report_header_id IN NUMBER,
497 p_distribution_line_number IN NUMBER,
498 p_employee_id IN NUMBER,
499 p_cumulative_mileage IN NUMBER,
500 p_schedule_line_array OUT NOCOPY AP_WEB_DB_SCHLINE_PKG.Schedule_Line_Array);
501 ---------------------------------------------------------
502
503 PROCEDURE updateCumulativeMileage(
504 p_cumulative_mileage IN AP_WEB_EMPLOYEE_INFO.NUMERIC_VALUE%TYPE,
505 p_period_id IN AP_WEB_EMPLOYEE_INFO.PERIOD_ID%TYPE,
506 p_employee_id IN AP_WEB_EMPLOYEE_INFO.EMPLOYEE_ID%TYPE);
507
508 ---------------------------------------------------------
509 FUNCTION getRate(
510 p_sh_distance_uom IN AP_POL_HEADERS.distance_uom%TYPE,
511 p_sh_currency_code IN AP_POL_HEADERS.currency_code%TYPE,
512 p_mileage_line IN AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Rec,
513 p_schedule_line IN AP_WEB_DB_SCHLINE_PKG.Schedule_Line_Rec)
514 RETURN NUMBER;
515
516 ---------------------------------------------------------
517 PROCEDURE copyMileageArray(
518 p_from_array IN AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Array,
519 p_to_array OUT NOCOPY AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Array);
520
521 ---------------------------------------------------------
522 PROCEDURE addToMileageArray(
523 p_index IN NUMBER,
524 p_new_dist_number IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
525 p_trip_dist IN AP_EXPENSE_REPORT_LINES.TRIP_DISTANCE%TYPE,
526 p_daily_distance IN AP_EXPENSE_REPORT_LINES.DAILY_DISTANCE%TYPE,
527 p_rate IN AP_EXPENSE_REPORT_LINES.avg_mileage_rate%TYPE,
528 p_report_header_id IN AP_EXPENSE_REPORT_LINES.report_header_id%TYPE,
529 p_from_index IN AP_EXPENSE_REPORT_LINES.distribution_line_number%TYPE,
530 p_mileage_line_array IN OUT NOCOPY AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Array);
531
532 ---------------------------------------------------------
533 PROCEDURE updateNewDistNumber(
534 p_index IN NUMBER,
535 p_last_index IN NUMBER,
536 p_added_total IN NUMBER,
537 p_mileage_line_array IN OUT NOCOPY AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Array);
538
539 ---------------------------------------------------------
540 PROCEDURE processCrossThreshold(
541 p_ml_index IN NUMBER,
542 p_sh_distance_uom IN AP_POL_HEADERS.DISTANCE_UOM%TYPE,
543 p_sh_currency_code IN AP_POL_HEADERS.CURRENCY_CODE%TYPE,
544 p_schedule_line_array IN AP_WEB_DB_SCHLINE_PKG.Schedule_Line_Array,
545 p_mileage_line_array_count IN OUT NOCOPY NUMBER,
546 p_cumulative_mileage IN OUT NOCOPY AP_WEB_EMPLOYEE_INFO.NUMERIC_VALUE%TYPE,
547 p_mileage_line_array IN OUT NOCOPY AP_WEB_DB_EXPLINE_PKG.Mileage_Line_Array);
548
549 ---------------------------------------------------------
550 PROCEDURE ProcessMileageLines(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 PROCEDURE hasCompanyViolations( p_item_type IN VARCHAR2,
558 p_item_key IN VARCHAR2,
559 p_actid IN NUMBER,
560 p_funmode IN VARCHAR2,
561 p_result OUT NOCOPY VARCHAR2);
562 ---------------------------------------------------------
563
564 -------------------------------------------------------------------------------
565 PROCEDURE AddToHeaderErrors(p_item_type IN VARCHAR2,
566 p_item_key IN VARCHAR2,
567 p_header_error IN VARCHAR2);
568 -------------------------------------------------------------------------------
569 PROCEDURE GenerateHeaderErrors(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 PROCEDURE GenerateAmountMsg(document_id IN VARCHAR2,
577 display_type IN VARCHAR2,
578 document IN OUT NOCOPY VARCHAR2,
579 document_type IN OUT NOCOPY VARCHAR2);
580
581 -------------------------------------------------------------------------------
582
583 -------------------------------------------------------------------------------
584 PROCEDURE GetRespAppInfo(p_item_key IN VARCHAR2,
585 p_resp_id OUT NOCOPY NUMBER,
586 P_appl_id OUT NOCOPY NUMBER);
587 -------------------------------------------------------------------------------
588
589 ---------------------------------------------------------
590 PROCEDURE GetAuditType( p_item_type IN VARCHAR2,
591 p_item_key IN VARCHAR2,
592 p_actid IN NUMBER,
593 p_funmode IN VARCHAR2,
594 p_result OUT NOCOPY VARCHAR2);
595 ---------------------------------------------------------
596
597 ---------------------------------------------------------
598 PROCEDURE ResetWFNote(p_item_type IN VARCHAR2,
599 p_item_key IN VARCHAR2,
600 p_actid IN NUMBER,
601 p_funmode IN VARCHAR2,
602 p_result OUT NOCOPY VARCHAR2);
603 ---------------------------------------------------------
604
605 PROCEDURE AddToOtherErrors(p_item_type IN VARCHAR2,
606 p_item_key IN VARCHAR2,
607 p_other_error IN VARCHAR2);
608 -------------------------------------------------------------------------------
609
610 /**
611 * jrautiai ADJ Fix start
612 */
613
614 /**
615 * Setting the from field to AP. Used for adjustment and shortpay notifications.
616 */
617 PROCEDURE SetFromRoleAP(
618 p_item_type IN VARCHAR2,
619 p_item_key IN VARCHAR2,
620 p_actid IN NUMBER,
621 p_funmode IN VARCHAR2,
622 p_result OUT NOCOPY VARCHAR2);
623
624 /**
625 * Build the policy violation message, this is used to detect whether
626 * we are building a policy or missing receipt notification.
627 */
628 PROCEDURE SetPolicyInfo(p_item_type IN VARCHAR2,
629 p_item_key IN VARCHAR2,
630 p_actid IN NUMBER,
631 p_funmode IN VARCHAR2,
632 p_result OUT NOCOPY VARCHAR2);
633
634 /**
635 * Build the missing receipts message, this is used to detect whether
636 * we are building a policy or missing receipt notification.
637 */
638 PROCEDURE SetMissingReceiptInfo(p_item_type IN VARCHAR2,
639 p_item_key IN VARCHAR2,
640 p_actid IN NUMBER,
641 p_funmode IN VARCHAR2,
642 p_result OUT NOCOPY VARCHAR2);
643
644 /**
645 * This procedure was modified with adding a parameter indicating the notification type.
646 * This is called by the wrappers above.
647 */
648 PROCEDURE SetShortPaidLinesInfo(p_item_type IN VARCHAR2,
649 p_item_key IN VARCHAR2,
650 p_actid IN NUMBER,
651 p_funmode IN VARCHAR2,
652 p_notification_type IN VARCHAR2,
653 p_result OUT NOCOPY VARCHAR2);
654
655 /**
656 * Build the provide missing info to AP message.
657 */
658 PROCEDURE SetProvideMissingInfo(p_item_type IN VARCHAR2,
659 p_item_key IN VARCHAR2,
660 p_actid IN NUMBER,
661 p_funmode IN VARCHAR2,
662 p_result OUT NOCOPY VARCHAR2);
663 ------------------------------------------------------------------------
664
665 /**
666 * Moved the constants to the package specification, so they are visible for other packages too.
667 */
668 C_BothPay CONSTANT VARCHAR2(10) := 'BOTH';
669 C_CompanyPay CONSTANT VARCHAR2(10) := 'COMPANY';
670 C_IndividualPay CONSTANT VARCHAR2(10) := 'INDIVIDUAL';
671
672 PROCEDURE ResetShortpayAdjustmentInfo(p_item_type IN VARCHAR2,
673 p_item_key IN VARCHAR2,
674 p_actid IN NUMBER,
675 p_funmode IN VARCHAR2,
676 p_result OUT NOCOPY VARCHAR2);
677
678 /**
679 * jrautiai ADJ Fix end
680 */
681
682 ------------------------------------------------------------------------
683 PROCEDURE CheckAPReviewResult(
684 p_item_type IN VARCHAR2,
685 p_item_key IN VARCHAR2,
686 p_actid IN NUMBER,
687 p_funmode IN VARCHAR2,
688 p_result OUT NOCOPY VARCHAR2);
689 ------------------------------------------------------------------------
690
691 ------------------------------------------------------------------------
692 PROCEDURE AddToAuditQueue(
693 p_item_type IN VARCHAR2,
694 p_item_key IN VARCHAR2,
695 p_actid IN NUMBER,
696 p_funmode IN VARCHAR2,
697 p_result OUT NOCOPY VARCHAR2);
698 ------------------------------------------------------------------------
699
700 ------------------------------------------------------------------------
701 PROCEDURE RemoveFromAuditQueue(
702 p_item_type IN VARCHAR2,
703 p_item_key IN VARCHAR2,
704 p_actid IN NUMBER,
705 p_funmode IN VARCHAR2,
706 p_result OUT NOCOPY VARCHAR2);
707 ------------------------------------------------------------------------
708
709 ------------------------------------------------------------------------
710 PROCEDURE StoreNote(
711 p_item_type IN VARCHAR2,
712 p_item_key IN VARCHAR2,
713 p_actid IN NUMBER,
714 p_funmode IN VARCHAR2,
715 p_result IN OUT NOCOPY VARCHAR2);
716 ------------------------------------------------------------------------
717
718
719 --Notification Esc :
720 -----------------------------------------------------------------------
721 procedure GetJobLevelAndSupervisor(
722 p_personId IN NUMBER,
723 p_jobLevel OUT NOCOPY NUMBER);
724 ------------------------------------------------------------------------
725
726 ------------------------------------------------------------------------
727 PROCEDURE IsEmployeeTerminated(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 PROCEDURE IsEmployeeActive(p_item_type IN VARCHAR2,
735 p_item_key IN VARCHAR2,
736 p_actid IN NUMBER,
737 p_funmode IN VARCHAR2,
738 p_result OUT NOCOPY VARCHAR2);
739 ------------------------------------------------------------------------
740
741 ------------------------------------------------------------------------
742 PROCEDURE IsManagerActive(p_item_type IN VARCHAR2,
743 p_item_key IN VARCHAR2,
744 p_actid IN NUMBER,
745 p_funmode IN VARCHAR2,
746 p_result OUT NOCOPY VARCHAR2);
747 ------------------------------------------------------------------------
748
749
750 -- 3257576 - Gets the manager info and sets p_error_message, p_instructions
751 -- p_special_instr if manager is terminated or does not exist or is suspended
752 ------------------------------------------------------------------------
753 PROCEDURE GetManagerInfoAndCheckStatus(
754 p_employee_id IN NUMBER,
755 p_employee_name IN VARCHAR2,
756 p_manager_id OUT NOCOPY NUMBER,
757 p_manager_name OUT NOCOPY VARCHAR2,
758 p_manager_status OUT NOCOPY VARCHAR2,
759 p_error_message OUT NOCOPY VARCHAR2,
760 p_instructions OUT NOCOPY VARCHAR2,
761 p_special_instr OUT NOCOPY VARCHAR2
762 );
763 ------------------------------------------------------------------------
764
765 --Bug 3389386
766 ------------------------------------------------------------------------
767 Procedure SetExpenseStatusCode(p_report_header_id IN Number);
768 ------------------------------------------------------------------------
769
770 --Bug 2777245
771 ------------------------------------------------------------------------
772 Procedure UpdateHeaderLines(
773 p_report_header_id IN Number);
774 ------------------------------------------------------------------------
775
776 ------------------------------------------------------------------------
777 Procedure RaiseSubmitEvent(
778 p_report_header_id IN Number,
779 p_workflow_appr_flag IN VARCHAR2);
780 ------------------------------------------------------------------------
781 ------------------------------------------------------------------------
782 PROCEDURE InitSubmit(
783 p_item_type IN VARCHAR2,
784 p_item_key IN VARCHAR2,
785 p_actid IN NUMBER,
786 p_funmode IN VARCHAR2,
787 p_result IN OUT NOCOPY VARCHAR2);
788 ------------------------------------------------------------------------
789
790 ------------------------------------------------------------------------
791 FUNCTION CheckAccess(
792 p_ntf_id IN NUMBER,
793 p_item_key IN NUMBER,
794 p_user_name IN VARCHAR2) RETURN VARCHAR2;
795 ------------------------------------------------------------------------
796
797 PROCEDURE AMERequestApproval(p_item_type IN VARCHAR2,
798 p_item_key IN VARCHAR2,
799 p_actid IN NUMBER,
800 p_funmode IN VARCHAR2,
801 p_result OUT NOCOPY VARCHAR2);
802
803 PROCEDURE AMEGetApprovalType(p_item_type IN VARCHAR2,
804 p_item_key IN VARCHAR2,
805 p_actid IN NUMBER,
806 p_funmode IN VARCHAR2,
807 p_result OUT NOCOPY VARCHAR2);
808
809 PROCEDURE AMEPropagateApprovalResult(p_item_type IN VARCHAR2,
810 p_item_key IN VARCHAR2,
811 p_actid IN NUMBER,
812 p_funmode IN VARCHAR2,
813 p_result OUT NOCOPY VARCHAR2);
814
815 PROCEDURE AMEGetApprovalResult(p_item_type IN VARCHAR2,
816 p_item_key IN VARCHAR2,
817 p_actid IN NUMBER,
818 p_funmode IN VARCHAR2,
819 p_result OUT NOCOPY VARCHAR2);
820
821 PROCEDURE AMECompleteApproval(p_item_type IN VARCHAR2,
822 p_item_key IN VARCHAR2,
823 p_actid IN NUMBER,
824 p_funmode IN VARCHAR2,
825 p_result OUT NOCOPY VARCHAR2);
826
827 PROCEDURE AMESetCurrentApprover(p_item_type IN VARCHAR2,
828 p_item_key IN VARCHAR2,
829 p_actid IN NUMBER,
830 p_funmode IN VARCHAR2,
831 p_result OUT NOCOPY VARCHAR2);
832
833 FUNCTION IsExpAccountsUpdated(p_report_line_id IN NUMBER) RETURN VARCHAR2;
834
835 FUNCTION getItemKey(p_notification_id IN NUMBER) RETURN VARCHAR2;
836
837 ------------------------------------------------------------------------
838 PROCEDURE IsPreparerActive(p_item_type IN VARCHAR2,
839 p_item_key IN VARCHAR2,
840 p_actid IN NUMBER,
841 p_funmode IN VARCHAR2,
842 p_result OUT NOCOPY VARCHAR2);
843 ------------------------------------------------------------------------
844
845 ------------------------------------------------------------------------
846 PROCEDURE WaitForImagedReceipts(p_item_type IN VARCHAR2,
847 p_item_key IN VARCHAR2,
848 p_actid IN NUMBER,
849 p_funmode IN VARCHAR2,
850 p_result OUT NOCOPY VARCHAR2);
851 ------------------------------------------------------------------------
852
853 ------------------------------------------------------------------------
854 PROCEDURE CompleteReceiptsBlock(p_report_header_id IN VARCHAR2);
855 ------------------------------------------------------------------------
856
857 ----------------------------------------------------------------------
858 PROCEDURE CheckForManagerReApproval(p_item_type IN VARCHAR2,
859 p_item_key IN VARCHAR2,
860 p_actid IN NUMBER,
861 p_funmode IN VARCHAR2,
862 p_result OUT NOCOPY VARCHAR2);
863 ----------------------------------------------------------------------
864
865 ----------------------------------------------------------------------
866 PROCEDURE SetImageReceiptsStatus(p_item_type IN VARCHAR2,
867 p_item_key IN VARCHAR2,
868 p_actid IN NUMBER,
869 p_funmode IN VARCHAR2,
870 p_result OUT NOCOPY VARCHAR2);
871 ----------------------------------------------------------------------
872
873 ----------------------------------------------------------------------
874 PROCEDURE SetOriginalReceiptsStatus(p_item_type IN VARCHAR2,
875 p_item_key IN VARCHAR2,
876 p_actid IN NUMBER,
877 p_funmode IN VARCHAR2,
878 p_result OUT NOCOPY VARCHAR2);
879 ----------------------------------------------------------------------
880
881 ----------------------------------------------------------------------
882 PROCEDURE UpdateExpenseStatusCode(p_item_type IN VARCHAR2,
883 p_item_key IN VARCHAR2,
884 p_actid IN NUMBER,
885 p_funmode IN VARCHAR2,
886 p_result OUT NOCOPY VARCHAR2);
887 ----------------------------------------------------------------------
888
889 ----------------------------------------------------------------------
890 PROCEDURE CheckShortPayRecptType(p_item_type IN VARCHAR2,
891 p_item_key IN VARCHAR2,
892 p_actid IN NUMBER,
893 p_funmode IN VARCHAR2,
894 p_result OUT NOCOPY VARCHAR2);
895 ----------------------------------------------------------------------
896
897 -------------------------------------------------------------------------------------
898 FUNCTION GetImageMissingJustification(p_report_header_id IN NUMBER) RETURN VARCHAR2;
899 --------------------------------------------------------------------------------------
900
901 ---------------------------------------------------------------------------------------
902 PROCEDURE AMEAbortRequestApprovals(
903 p_rep_header_id IN AP_WEB_DB_EXPLINE_PKG.expLines_headerID,
904 p_withdraw IN VARCHAR2 DEFAULT 'N');
905 ---------------------------------------------------------------------------------------
906
907 -------------------------------------------------------------------------------------
908 FUNCTION IsBothPayReportExists(p_report_header_id IN NUMBER) RETURN BOOLEAN;
909 --------------------------------------------------------------------------------------
910
911 --------------------------------------------------------------------------------------
912 FUNCTION CheckSurrogateManager(p_employeeId IN NUMBER,
913 p_manager_id IN NUMBER,
914 p_surrogate_mgr_id IN NUMBER) RETURN BOOLEAN;
915 --------------------------------------------------------------------------------------
916
917 END AP_WEB_EXPENSE_WF;
[Home] [Help]