[Home] [Help]
PACKAGE: APPS.OKL_PA_DATA_INTEGRITY
Source
1 PACKAGE OKL_PA_DATA_INTEGRITY AS
2 /* $Header: OKLRPAQS.pls 120.0 2005/08/11 09:54:22 abindal noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL MESSAGE CONSTANTS
6 ---------------------------------------------------------------------------
7 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
8 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
9 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
10 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
11 --
12 G_QA_SUCCESS CONSTANT VARCHAR2(200) := 'OKL_PROGRAM_QA_SUCCESS';
13 ------------------------------------------------------------------------------------
14 -- GLOBAL EXCEPTION
15 ---------------------------------------------------------------------------
16 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
17
18 -- GLOBAL VARIABLES
19 ---------------------------------------------------------------------------
20 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PA_DATA_INTEGRITY';
21 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
22 ---------------------------------------------------------------------------
23
24 --------------------------------------------------------------------------------------
25 -- Start of comments
26 --
27 -- Procedure Name : check_functional_constraints
28 -- Description : This procedure checks for the valid effective dates of the associated
29 -- objects and the valid status for lease application template and lease
30 -- contract template associated to vendor agreement
31 -- Business Rules :
32 -- Parameters :
33 -- Version : 1.0
34 -- End of comments
35 --------------------------------------------------------------------------------------
36 PROCEDURE check_functional_constraints(
37 x_return_status OUT NOCOPY VARCHAR2,
38 p_chr_id IN NUMBER);
39
40 END OKL_PA_DATA_INTEGRITY;