[Home] [Help]
PACKAGE: APPS.OKC_TERMS_QA_GRP
Source
1 PACKAGE OKC_TERMS_QA_GRP AS
2 /* $Header: OKCGDQAS.pls 120.1 2006/06/20 21:58:34 rvohra noship $ */
3
4 TYPE qa_result_rec_type IS RECORD (
5 Document_type VARCHAR2(30),
6 Document_id NUMBER,
7 Sequence_id NUMBER,
8 Error_record_type VARCHAR2(30),
9 Title VARCHAR2(240),
10 Article_ID NUMBER,
11 Deliverable_Id NUMBER,
12 Section_Name VARCHAR2(240),
13 Error_severity VARCHAR2(1),
14 QA_Code VARCHAR2(30),
15 Message_name VARCHAR2(30),
16 Problem_short_desc VARCHAR2(2000),
17 Problem_details VARCHAR2(2000),
18 Problem_details_short VARCHAR2(2000),
19 Suggestion VARCHAR2(2000),
20 Creation_date DATE,
21 Reference_Column1 VARCHAR2(2000),
22 Reference_Column2 VARCHAR2(2000),
23 Reference_Column3 VARCHAR2(2000),
24 Reference_Column4 VARCHAR2(2000),
25 Reference_Column5 VARCHAR2(2000),
26 error_record_type_name Varchar2(2000),
27 error_severity_name Varchar2(2000)
28 );
29
30 TYPE qa_result_tbl_type IS TABLE OF qa_result_rec_type INDEX BY BINARY_INTEGER;
31
32 -- declaring record type for deliverable due date events
33 TYPE BUSDOCDATES_REC_TYPE IS RECORD (
34 event_code VARCHAR2(30),
35 event_date DATE
36 );
37
38 -- declaring table of records
39 TYPE BUSDOCDATES_TBL_TYPE IS TABLE OF BUSDOCDATES_REC_TYPE INDEX BY BINARY_INTEGER;
40
41
42 ---------------------------------------------------------------------------
43 -- GLOBAL CONSTANTS
44 ---------------------------------------------------------------------------
45
46 G_NORMAL_QA CONSTANT VARCHAR2(30) := 'NORMAL';
47 G_AMEND_QA CONSTANT VARCHAR2(30) := 'AMEND';
48
49 G_QA_STS_SUCCESS CONSTANT varchar2(1) := 'S';
50 G_QA_STS_ERROR CONSTANT varchar2(1) := 'E';
51 G_QA_STS_WARNING CONSTANT varchar2(1) := 'W';
52
53
54 /* version 1, logs valiation messages in OKC_QA_ERRORS_T table
55 returns x_sequence_id as out parameter
56 11.5.10+ : Modified to accept addtional in parameter p_validation_level
57 p_commit DEFAULT FND_API.G_TRUE added to ensure backward compatibility,
58 pass as FND_API.G_FALSE if do not want to commit changes
59 */
60 PROCEDURE QA_Doc (
61 p_api_version IN NUMBER,
62 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_data OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66
67 p_qa_mode IN VARCHAR2 DEFAULT G_NORMAL_QA,
68 p_doc_type IN VARCHAR2,
69 p_doc_id IN NUMBER,
70
71 x_sequence_id OUT NOCOPY NUMBER,
72 x_qa_return_status OUT NOCOPY VARCHAR2,
73 p_qa_terms_only IN VARCHAR2 DEFAULT 'N',
74 p_validation_level IN VARCHAR2 DEFAULT 'A',
75 p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE,
76 p_run_expert_flag IN VARCHAR2 DEFAULT 'Y' -- Bug 5186245
77 );
78
79 /* version 2, does not log valiation messages in OKC_QA_ERRORS_T table
80 returns x_qa_result_tbl as out parameter
81 11.5.10+: No modification
82 */
83 PROCEDURE QA_Doc (
84 p_api_version IN NUMBER,
85 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_data OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89
90 p_qa_mode IN VARCHAR2 DEFAULT G_NORMAL_QA,
91 p_doc_type IN VARCHAR2,
92 p_doc_id IN NUMBER,
93
94 x_qa_result_tbl OUT NOCOPY qa_result_tbl_type,
95 x_qa_return_status OUT NOCOPY VARCHAR2,
96 p_qa_terms_only IN VARCHAR2 DEFAULT 'N' ,
97 p_run_expert_flag IN VARCHAR2 DEFAULT 'Y' -- Bug 5186245
98 );
99
100 /* version 3, does not log valiation messages in OKC_QA_ERRORS_T table
101 returns x_qa_result_tbl as out parameter, takes in additional parameter
102 p_bus_doc_date_events_tbl
103 11.5.10+: No modification
104 */
105 PROCEDURE QA_Doc (
106 p_api_version IN NUMBER,
107 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_data OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER,
111
112 p_qa_mode IN VARCHAR2 DEFAULT G_NORMAL_QA,
113 p_doc_type IN VARCHAR2,
114 p_doc_id IN NUMBER,
115
116 x_qa_result_tbl OUT NOCOPY qa_result_tbl_type,
117 x_qa_return_status OUT NOCOPY VARCHAR2,
118
119 p_bus_doc_date_events_tbl IN BUSDOCDATES_TBL_TYPE,
120 p_run_expert_flag IN VARCHAR2 DEFAULT 'Y' -- Bug 5186245
121 );
122
123 PROCEDURE Check_Terms(
124 x_return_status OUT NOCOPY VARCHAR2,
125 p_chr_id IN NUMBER
126 );
127
128 END OKC_TERMS_QA_GRP;