[Home] [Help]
PACKAGE: APPS.OKL_FORMULAVALIDATE_PVT
Source
1 PACKAGE OKL_FORMULAVALIDATE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLRVALS.pls 115.2 2002/02/18 20:17:22 pkm ship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL MESSAGE CONSTANTS
6 ---------------------------------------------------------------------------
7 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
8 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKL_API.G_FORM_UNABLE_TO_RESERVE_REC;
9 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_DELETED;
10 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKL_API.G_FORM_RECORD_CHANGED;
11 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKL_API.G_RECORD_LOGICALLY_DELETED;
12 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
13 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
14 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
15 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_PARENT_TABLE_TOKEN;
16 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKL_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 G_FMA_RECURSION CONSTANT VARCHAR2(200) := 'OKL_FMA_RECURSION';
24 G_RECURSION_TOKEN CONSTANT VARCHAR2(200) := 'OKL_RECURSION_TOKEN';
25 G_PRM_MISMATCH CONSTANT VARCHAR2(200) := 'OKL_PRM_MISMATCH';
26 G_PRM_MISMATCH_TOKEN CONSTANT VARCHAR2(200) := 'OKL_PRM_MISMATCH_TOKEN';
27 G_CTX_GROUP_NOTFOUND CONSTANT VARCHAR2(200) := 'OKL_CTX_GROUP_NOTFOUND';
28 G_CTX_GROUP_TOKEN CONSTANT VARCHAR2(200) := 'OKL_CTX_GROUP_TOKEN';
29
30 ---------------------------------------------------------------------------
31 -- GLOBAL VARIABLES
32 ---------------------------------------------------------------------------
33 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_FORMULAVALIDATION_PVT';
34 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
35 ---------------------------------------------------------------------------
36 -- GLOBAL EXCEPTION
37 ---------------------------------------------------------------------------
38 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
39
40 G_RET_STS_RECURSION_ERROR CONSTANT VARCHAR2(1) := 'R';
41 G_RET_STS_PRM_MISMATCH_ERROR CONSTANT VARCHAR2(1) := 'P';
42
43
44 /** SBALASHA001 -
45 INFO: Subtype defined for calling EVA APIs **/
46 SUBTYPE CtxParameter_rec IS OKL_FORMULAEVALUATE_PVT.CtxParameter_rec;
47 SUBTYPE CtxParameter_tbl IS OKL_FORMULAEVALUATE_PVT.CtxParameter_tbl;
48
49 /** SBALASHA001 -
50 INFO: Record to hold id. **/
51 TYPE fmaopd_rec IS RECORD (
52 id NUMBER
53 );
54
55 /** SBALASHA001 -
56 INFO: Table to hold fmaopd_rec records. **/
57 TYPE FmaOpd_tbl IS TABLE OF fmaopd_rec INDEX BY BINARY_INTEGER;
58
59
60
61 ---------------------------------------------------------------------------
62 -- Procedures and Functions
63 ---------------------------------------------------------------------------
64
65 PROCEDURE VAL_ValidateFormula(
66 p_api_version IN NUMBER
67 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
68 ,x_return_status OUT NOCOPY VARCHAR2
69 ,x_msg_count OUT NOCOPY NUMBER
70 ,x_msg_data OUT NOCOPY VARCHAR2
71 ,x_validate_status OUT NOCOPY VARCHAR2
72 ,p_fma_id IN NUMBER
73 ,p_cgr_id IN NUMBER);
74
75 END OKL_FORMULAVALIDATE_PVT;