1 PACKAGE OKC_TERMS_DEVIATIONS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCVTDRS.pls 120.1.12000000.3 2007/08/01 11:52:31 ndoddi ship $ */
3
4
5 /*
6 -- PROCEDURE Populate_Template_Articles
7 -- To be used to delete populate the global temp table with articles on
8 -- the current version of the template.
9 */
10 PROCEDURE Populate_Template_Articles (
11 x_return_status OUT NOCOPY VARCHAR2,
12 p_template_id IN NUMBER,
13 p_doc_type IN VARCHAR2
14 );
15
16 /*
17 -- PROCEDURE Populate_Expert_Articles
18 -- To be used to delete populate the global temp table with articles on
19 -- the current version of the Expert.
20 */
21 PROCEDURE Populate_Expert_Articles (
22 x_return_status OUT NOCOPY VARCHAR2,
23 p_document_type IN VARCHAR2,
24 p_document_id IN NUMBER,
25 p_include_exp OUT NOCOPY VARCHAR2,
26 p_seq_id IN NUMBER
27 );
28
29 /*
30 -- PROCEDURE Generate_Terms_Deviations
31 -- This API will be used to generate deviations
32 */
33 PROCEDURE Generate_Terms_Deviations (
34 x_return_status OUT NOCOPY VARCHAR2,
35 x_msg_data OUT NOCOPY VARCHAR2,
36 x_msg_count OUT NOCOPY NUMBER,
37
38 p_doc_type IN VARCHAR2,
39 p_doc_id IN NUMBER,
40 p_template_id IN NUMBER ,
41 p_run_id OUT NOCOPY NUMBER
42 );
43
44 type scn_id_tbl is TABLE of okc_terms_deviations_temp.scn_id%type
45 INDEX BY BINARY_INTEGER;
46 type article_id_tbl is TABLE OF okc_terms_deviations_temp.article_id%type
47 INDEX BY BINARY_INTEGER;
48 type article_version_id_tbl is TABLE OF okc_terms_deviations_temp.article_version_id%type
49 INDEX BY BINARY_INTEGER;
50 type ref_article_id_tbl is TABLE OF okc_terms_deviations_temp.ref_article_id%type
51 INDEX BY BINARY_INTEGER;
52 type ref_article_version_id_tbl is TABLE OF okc_terms_deviations_temp.ref_article_version_id%type
53 INDEX BY BINARY_INTEGER;
54 type display_sequence_tbl is TABLE OF okc_terms_deviations_temp.display_sequence%type
55 INDEX BY BINARY_INTEGER;
56 type label_tbl is TABLE OF okc_terms_deviations_t.label%type
57 INDEX BY BINARY_INTEGER;
58 type mandatory_flag_tbl is TABLE OF okc_terms_deviations_temp.mandatory_flag%type
59 INDEX BY BINARY_INTEGER;
60 type orig_article_id_tbl is TABLE OF okc_terms_deviations_temp.orig_article_id%type
61 INDEX BY BINARY_INTEGER;
62 type section_heading_tbl is TABLE OF okc_terms_deviations_t.section_heading%type
63 INDEX BY BINARY_INTEGER;
64 type article_title_tbl is TABLE OF okc_terms_deviations_t.article_title%type
65 INDEX BY BINARY_INTEGER;
66 type dev_category_tbl is TABLE OF okc_terms_deviations_t.deviation_category%type
67 INDEX BY BINARY_INTEGER;
68 type dev_code_tbl is TABLE OF okc_terms_deviations_t.deviation_code%type
69 INDEX BY BINARY_INTEGER;
70 type dev_category_meaning_tbl is TABLE OF okc_terms_deviations_t.deviation_category_meaning%type
71 INDEX BY BINARY_INTEGER;
72 type dev_code_meaning_tbl is TABLE OF okc_terms_deviations_t.deviation_code_meaning%type
73 INDEX BY BINARY_INTEGER;
74 type art_seq_id_tbl is TABLE OF okc_terms_deviations_t.art_seq_id%type
75 INDEX BY BINARY_INTEGER;
76
77 -- Procedure to insert data into okc_terms_deviations_t table
78 -- this will be a BULK insert as all the parameters passed to
79 -- this routine are table type.
80 Procedure Insert_deviations(
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_data OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84
85 p_seq_id IN Number,
86 p_dev_category IN Varchar2,
87 p_dev_code IN Varchar2,
88 p_dev_category_meaning IN Varchar2,
89 p_dev_code_meaning IN Varchar2,
90 p_dev_category_priority IN Number,
91 p_scn_id IN scn_id_tbl,
92 p_section_heading IN section_heading_tbl,
93 p_label IN label_tbl,
94 p_doc_article_id IN article_id_tbl,
95 p_doc_article_version_id IN article_version_id_tbl,
96 p_ref_article_id IN ref_article_id_tbl,
97 p_ref_article_version_id IN ref_article_version_id_tbl,
98 p_article_title IN article_title_tbl,
99 p_display_sequence IN display_sequence_tbl,
100 p_mandatory_flag IN mandatory_flag_tbl,
101 p_orig_article_id IN orig_article_id_tbl,
102 p_art_seq_id IN art_seq_id_tbl,
103 p_compare_flag IN Varchar2 default 'N',
104 p_doc_type IN Varchar2,
105 p_doc_id IN Number);
106
107
108 -- This procedure will be called from Contracts Purge
109 -- concurrent program. This is used for purging the
110 -- deviations data as it will be generated every time
111 -- user requests for it.
112
113 Procedure Purge_Deviations_Data(
114 errbuf OUT NOCOPY VARCHAR2,
115 retcode OUT NOCOPY VARCHAR2,
116 p_num_days IN NUMBER DEFAULT 3);
117
118 FUNCTION has_deviation_report(
119 p_document_type IN VARCHAR2,
120 p_document_id IN NUMBER
121 ) RETURN VARCHAR2;
122
123 end;