[Home] [Help]
PACKAGE: APPS.OKC_QA_PROCS
Source
1 PACKAGE OKC_QA_PROCS AUTHID CURRENT_USER AS
2 /* $Header: OKCRQAPS.pls 120.0 2005/05/25 22:44:15 appldev noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL MESSAGE CONSTANTS
6 ---------------------------------------------------------------------------
7 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
8 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
9 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
10 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
11 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
12 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
13 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
14 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
15 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
16 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
17 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
18 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
19 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
20 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
21 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPERCASE_REQUIRED';
22 G_QA_SUCCESS CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_QA_SUCCESS';
23 G_LINE_COUNT CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_LINE_COUNT';
24 G_PARTY_COUNT CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_PARTY_COUNT';
25
26 ------------------------------------------------------------------------------------
27 -- GLOBAL EXCEPTION
28 ---------------------------------------------------------------------------
29 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
30
31 -- GLOBAL VARIABLES
32 ---------------------------------------------------------------------------
33 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_QA_CHECK_PVT';
34 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
35 ---------------------------------------------------------------------------
36
37 PROCEDURE check_parties(
38 x_return_status OUT NOCOPY VARCHAR2,
39 p_chr_id IN NUMBER,
40 p_party_count IN NUMBER);
41
42 PROCEDURE check_min_lines(
43 x_return_status OUT NOCOPY VARCHAR2,
44 p_chr_id IN NUMBER,
45 p_line_count IN NUMBER);
46
47 END OKC_QA_PROCS;