DBA Data[Home] [Help]

PACKAGE: APPS.PSP_WF_ADJ_CUSTOM

Source


1 PACKAGE psp_wf_adj_custom AUTHID CURRENT_USER 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;