[Home] [Help]
PACKAGE: APPS.OKC_TERMS_QA_PVT
Source
1 PACKAGE OKC_TERMS_QA_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCVDQAS.pls 120.3.12000000.1 2007/01/17 11:32:33 appldev ship $ */
3
4 SUBTYPE qa_result_tbl_type IS OKC_TERMS_QA_GRP.qa_result_tbl_type;
5
6 G_NORMAL_QA CONSTANT VARCHAR2(30) := OKC_TERMS_QA_GRP.G_NORMAL_QA;
7 G_AMEND_QA CONSTANT VARCHAR2(30) := OKC_TERMS_QA_GRP.G_AMEND_QA;
8
9 /*
10 11.5.10+ : Modified to accept addtional in parameter p_validation_level
11 */
12 PROCEDURE qa_doc (
13 p_qa_mode IN VARCHAR2 := G_NORMAL_QA,
14 p_doc_type IN VARCHAR2,
15 p_doc_id IN NUMBER,
16 x_return_status OUT NOCOPY VARCHAR2,
17 x_msg_count OUT NOCOPY NUMBER,
18 x_msg_data OUT NOCOPY VARCHAR2,
19 x_sequence_id OUT NOCOPY NUMBER,
20 x_qa_result_tbl OUT NOCOPY qa_result_tbl_type,
21 x_qa_return_status OUT NOCOPY VARCHAR2,
22 p_validation_level IN VARCHAR2 DEFAULT 'A',
23 p_run_expert_flag IN VARCHAR2 DEFAULT 'Y'); -- Bug 5186245
24
25 PROCEDURE log_qa_messages (
26 x_return_status OUT NOCOPY VARCHAR2,
27 p_qa_result_tbl IN qa_result_tbl_type,
28 x_sequence_id OUT NOCOPY NUMBER);
29
30 PROCEDURE get_qa_code_detail(
31 p_qa_code IN VARCHAR2,
32 x_perform_qa OUT NOCOPY VARCHAR2,
33 x_qa_name OUT NOCOPY VARCHAR2,
34 x_severity_flag OUT NOCOPY VARCHAR2,
35 x_return_status OUT NOCOPY VARCHAR2);
36
37
38 PROCEDURE check_lock_contract(
39 p_qa_mode IN VARCHAR2,
40 p_doc_type IN VARCHAR2,
41 p_doc_id IN NUMBER,
42 x_qa_result_tbl IN OUT NOCOPY qa_result_tbl_type,
43 x_qa_return_status IN OUT NOCOPY VARCHAR2,
44 x_return_status OUT NOCOPY VARCHAR2);
45
46 PROCEDURE check_contract_admin (
47 p_qa_mode IN VARCHAR2,
48 p_doc_type IN VARCHAR2,
49 p_doc_id IN NUMBER,
50 x_qa_result_tbl IN OUT NOCOPY qa_result_tbl_type,
51 x_qa_return_status IN OUT NOCOPY VARCHAR2,
52 x_return_status OUT NOCOPY VARCHAR2);
53
54 END OKC_TERMS_QA_PVT;