DBA Data[Home] [Help]

PACKAGE: APPS.OKL_COMMON_FUNCTIONS

Source


1 PACKAGE OKL_COMMON_FUNCTIONS AUTHID CURRENT_USER AS
2 /* $Header: OKLRCOMS.pls 115.1 2002/08/09 16:48:05 pdevaraj noship $ */
3 
4   ---------------------------------------------------------------------------
5   -- GLOBAL MESSAGE CONSTANTS
6   ---------------------------------------------------------------------------
7   G_FND_APP			      CONSTANT VARCHAR2(200) := okl_api.G_FND_APP;
8   G_INVALID_VALUE		      CONSTANT VARCHAR2(200) := okl_api.G_INVALID_VALUE;
9   G_ERROR		            CONSTANT VARCHAR2(200) := 'OKL_ERROR';
10   G_UNEXPECTED_ERROR		CONSTANT VARCHAR2(200) := 'OKL_UNEXPECTED_ERROR';
11   G_SQLERRM_TOKEN             CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
12   G_SQLCODE_TOKEN             CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
13   ---------------------------------------------------------------------------
14   -- GLOBAL VARIABLES
15   ---------------------------------------------------------------------------
16   G_PKG_NAME			CONSTANT VARCHAR2(200) := 'OKL_COMMON_FUNCTIONS';
17   G_APP_NAME			CONSTANT VARCHAR2(3)   :=  'OKL';
18 
19   ---------------------------------------------------------------------------
20   -- Procedures and Functions
21   ---------------------------------------------------------------------------
22 
23   ---------------------------------------------------------------------------
24   -- Returns Unrefunded Cures
25   ---------------------------------------------------------------------------
26   FUNCTION get_unrefunded_cures(
27      p_contract_id		IN NUMBER,
28      x_unrefunded_cures	      OUT NOCOPY NUMBER)
29   RETURN VARCHAR2;
30 
31   ---------------------------------------------------------------------------
32   -- Returns get_cured_status
33   ---------------------------------------------------------------------------
34   FUNCTION get_cured_status (p_contract_number IN NUMBER)
35   RETURN VARCHAR2;
36 
37   pragma restrict_references(get_cured_status, WNDS,WNPS,RNPS);
38 
39 END OKL_COMMON_FUNCTIONS;