[Home] [Help]
PACKAGE: APPS.OKC_QA_CHECK_PVT
Source
1 PACKAGE OKC_QA_CHECK_PVT AS
2 /* $Header: OKCRQACS.pls 120.0 2005/05/25 22:43:28 appldev noship $ */
3 TYPE qa_msg_rec_type IS RECORD (
4 severity OKC_QA_LIST_PROCESSES_V.SEVERITY%TYPE,
5 name OKC_PROCESS_DEFS_V.NAME%TYPE,
6 description OKC_PROCESS_DEFS_V.DESCRIPTION%TYPE,
7 package_name OKC_PROCESS_DEFS_V.PACKAGE_NAME%TYPE,
8 procedure_name OKC_PROCESS_DEFS_V.PROCEDURE_NAME%TYPE,
9 error_status VARCHAR2(1),
10 data VARCHAR2(2000)
11 );
12
13 TYPE qa_msg_tbl_type IS TABLE OF qa_msg_rec_type
14 INDEX BY BINARY_INTEGER;
15
16 pub_qa_msg_tbl qa_msg_tbl_type;
17
18 -- subtype msg_tbl_type is OKC_API.MSG_TBL_TYPE;
19 subtype msg_tbl_type is qa_msg_tbl_type;
20
21 TYPE parameter_type IS RECORD (
22 param_value varchar2(150));
23
24 Type parameter_tbl_type is table of parameter_type INDEX BY BINARY_INTEGER;
25 ---------------------------------------------------------------------------
26 -- GLOBAL MESSAGE CONSTANTS
27 ---------------------------------------------------------------------------
28 G_DEFAULT_QA_CHECK_LIST CONSTANT VARCHAR2(200) := 'DEFAULT QA CHECK LIST';
29 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
30 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKC_NO_PARENT_RECORD';
31 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
32 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
33 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
34 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
35 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
36 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
37 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
38 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
39 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
40 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
41 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
42 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
43 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPERCASE_REQUIRED';
44 G_QA_PROCESS_ERROR CONSTANT VARCHAR2(200) := 'OKC_QA_PROCESS_ERROR';
45
46 ------------------------------------------------------------------------------------
47 -- GLOBAL EXCEPTION
48 ---------------------------------------------------------------------------
49 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
50
51 -- GLOBAL VARIABLES
52 ---------------------------------------------------------------------------
53 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_QA_CHECK_PVT';
54 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
55 ---------------------------------------------------------------------------
56
57 PROCEDURE execute_qa_check_list(
58 p_api_version IN NUMBER,
59 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2,
63 p_qcl_id IN NUMBER,
64 p_chr_id IN NUMBER,
65 p_override_flag IN VARCHAR2 DEFAULT 'N',
66 x_msg_tbl OUT NOCOPY msg_tbl_type);
67
68 END OKC_QA_CHECK_PVT;