[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;