DBA Data[Home] [Help]

PACKAGE: APPS.OKC_QA_GENERAL_CHECKLISTS

Source


1 PACKAGE OKC_QA_GENERAL_CHECKLISTS AUTHID CURRENT_USER AS
2 /* $Header: OKCRQAGS.pls 120.0 2005/05/25 19:30:45 appldev 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) := 'ERROR_MESSAGE';
10   G_SQLCODE_TOKEN               CONSTANT VARCHAR2(200) := 'ERROR_CODE';
11   G_QA_SUCCESS   		CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_QA_SUCCESS';
12 
13   ------------------------------------------------------------------------------------
14   -- GLOBAL EXCEPTION
15   ---------------------------------------------------------------------------
16   G_EXCEPTION_HALT_VALIDATION	EXCEPTION;
17 
18   -- GLOBAL VARIABLES
19   ---------------------------------------------------------------------------
20   G_PKG_NAME		CONSTANT VARCHAR2(30) := 'OKC_QA_GENERAL_CHECKLISTS';
21   G_APP_NAME		CONSTANT VARCHAR2(3)  :=  OKC_API.G_APP_NAME;
22   ---------------------------------------------------------------------------
23 
24 PROCEDURE check_euro_currency(
25     x_return_status            OUT NOCOPY VARCHAR2,
26     p_chr_id                   IN  NUMBER
27   ) ;
28 
29 PROCEDURE check_email_address(
30     x_return_status            OUT NOCOPY VARCHAR2,
31     p_chr_id                   IN  NUMBER);
32 
33 PROCEDURE check_email_address_role(
34     x_return_status            OUT NOCOPY VARCHAR2,
35     p_chr_id                   IN  NUMBER,
36     p_rle_code                 IN  VARCHAR2);
37 
38 END OKC_QA_GENERAL_CHECKLISTS;