DBA Data[Home] [Help]

PACKAGE: APPS.OKL_CURE_WF

Source


1 PACKAGE OKL_CURE_WF AUTHID CURRENT_USER as
2 /* $Header: OKLCOWFS.pls 115.1 2003/04/24 22:03:15 jsanju noship $ */
3 
4 
5   ---------------------------------------------------------------------------
6   -- GLOBAL VARIABLES
7   ---------------------------------------------------------------------------
8   G_PKG_NAME              CONSTANT VARCHAR2(200)
9                                             := 'OKL_CURE_WF';
10   G_APP_NAME              CONSTANT VARCHAR2(3)   := OKC_API.G_APP_NAME;
11   G_UNEXPECTED_ERROR      CONSTANT VARCHAR2(200)
12                                             := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
13   G_SQLERRM_TOKEN        CONSTANT VARCHAR2(200) := 'SQLERRM';
14   G_SQLCODE_TOKEN        CONSTANT VARCHAR2(200) := 'SQLCODE';
15   PG_DEBUG NUMBER     := TO_NUMBER(NVL(FND_PROFILE.value('OKL_DEBUG_LEVEL'), '20'));
16 
17 
18 
19 PROCEDURE  approve_cure_reports
20              (  p_api_version          IN NUMBER
21                ,p_init_msg_list        IN VARCHAR2 DEFAULT OKC_API.G_TRUE
22                ,p_commit               IN VARCHAR2 DEFAULT OKC_API.G_FALSE
23                ,p_report_id            IN NUMBER
24                ,x_return_status       OUT NOCOPY VARCHAR2
25                ,x_msg_count           OUT NOCOPY NUMBER
26                ,x_msg_data            OUT NOCOPY VARCHAR2
27                );
28 
29 
30 /**
31   called from the workflow to update cure reports based on
32   the approval
33  **/
34 
35   PROCEDURE set_approval_status (itemtype        in varchar2,
36                                  itemkey         in varchar2,
37                                  actid           in number,
38                                  funcmode        in varchar2,
39                                  result       out nocopy varchar2);
40 
41 
42   PROCEDURE set_reject_status (itemtype        in varchar2,
43                                  itemkey         in varchar2,
44                                  actid           in number,
45                                  funcmode        in varchar2,
46                                  result       out nocopy varchar2);
47 
48 
49 end OKL_CURE_WF;