[Home] [Help]
PACKAGE: APPS.OKL_FORMULAFUNCTION_PVT
Source
1 PACKAGE OKL_FORMULAFUNCTION_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRFNCS.pls 115.2 2002/02/18 20:16:19 pkm ship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL MESSAGE CONSTANTS
6 ---------------------------------------------------------------------------
7 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
8 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
9 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
10 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
11 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
12 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
13 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
14 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
15 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
16 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
17 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
18 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKC_SQLerrm';
19 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKC_SQLcode';
20 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPER_CASE_REQUIRED';
21 G_ONE_DOI CONSTANT VARCHAR2(200) := 'OKC_ONE_DOI';
22
23 ---------------------------------------------------------------------------
24 -- GLOBAL VARIABLES
25 ---------------------------------------------------------------------------
26 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_FORMULAFUNCTION_PVT';
27 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
28
29
30 ---------------------------------------------------------------------------
31 -- GLOBAL EXCEPTION
32 ---------------------------------------------------------------------------
33 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
34
35
36 ---------------------------------------------------------------------------
37 -- Procedures and Functions
38 ---------------------------------------------------------------------------
39
40 -- PROCEDURE qc;
41 -- PROCEDURE change_version;
42 -- PROCEDURE api_copy;
43 -- PROCEDURE add_language;
44
45 FUNCTION GET_TAX_VALUE(
46 p_contract_id IN NUMBER,
47 p_line_id IN NUMBER )
48 RETURN NUMBER;
49
50 FUNCTION GET_BONUS_VALUE(
51 p_contract_id IN NUMBER,
52 p_line_id IN NUMBER )
53 RETURN NUMBER;
54
55 FUNCTION GET_REVENUE_VALUE(
56 p_contract_id IN NUMBER,
57 p_line_id IN NUMBER )
58 RETURN NUMBER;
59
60 END OKL_FORMULAFUNCTION_PVT;