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