1 PACKAGE psp_wf_adj_custom AS
2 /* $Header: PSPWFACS.pls 120.1 2006/01/23 19:22:06 vdharmap noship $ */
3
4 /*************************************************************************
5 ** Procedure select_approver_custom returns the approver_id **
6 ** for the given employee. It is called from **
7 ** PSP_WF_ADJ_PKG.SELECT_APPROVER. **
8 **************************************************************************/
9 PROCEDURE SELECT_APPROVER_CUSTOM
10 (itemtype IN VARCHAR2,
11 itemkey IN VARCHAR2,
12 actid IN VARCHAR2,
13 funcmode IN VARCHAR2,
14 p_person_id IN NUMBER,
15 p_assignment_number IN VARCHAR2,
16 p_approver_id OUT NOCOPY NUMBER);
17
18 /*************************************************************************
19 ** Procedure omit_approval_custom returns 'Y' or 'N' **
20 ** It is called from PSP_WF_ADJ_PKG.OMIT_APPROVAL.
21 **************************************************************************/
22 PROCEDURE OMIT_APPROVAL_CUSTOM
23 (itemtype IN VARCHAR2,
24 itemkey IN VARCHAR2,
25 actid IN VARCHAR2,
26 funcmode IN VARCHAR2,
27 p_omit_approval OUT NOCOPY VARCHAR2);
28
29 /*************************************************************************
30 ** Procedure record_creator_custom returns approver id **
31 ** It is called from PSP_WF_ADJ_PKG.record_creator
32 **************************************************************************/
33 PROCEDURE RECORD_CREATOR_CUSTOM
34 (itemtype IN VARCHAR2,
35 itemkey IN VARCHAR2,
36 actid IN VARCHAR2,
37 funcmode IN VARCHAR2,
38 p_custom_approver_id OUT NOCOPY VARCHAR2);
39
40 --- added following 2 user hooks for 4992668
41
42 procedure prorate_dff_hook(p_batch_name in varchar2,
43 p_business_group_id in integer,
44 p_set_of_books_id in integer);
45
46 procedure dff_for_approver(p_batch_name in varchar2,
47 p_run_id in integer,
48 p_business_group_id in integer,
49 p_set_of_books_id in integer);
50 END psp_wf_adj_custom;