1 PACKAGE OKC_TEMPLATE_USAGES_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKCVTMPLUSGS.pls 120.2.12020000.2 2012/07/18 11:20:13 harchand ship $ */
3
4 ---------------------------------------------------------------------------
5 -- Procedures and Functions
6 ---------------------------------------------------------------------------
7
8 PROCEDURE insert_row(
9 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10 x_return_status OUT NOCOPY VARCHAR2,
11
12 p_document_type IN VARCHAR2,
13 p_document_id IN NUMBER,
14 p_template_id IN NUMBER,
15 p_doc_numbering_scheme IN NUMBER,
16 p_document_number IN VARCHAR2,
17 p_article_effective_date IN DATE,
18 p_config_header_id IN NUMBER,
19 p_config_revision_number IN NUMBER,
20 p_valid_config_yn IN VARCHAR2,
21 p_orig_system_reference_code IN VARCHAR2 := NULL,
22 p_orig_system_reference_id1 IN NUMBER := NULL,
23 p_orig_system_reference_id2 IN NUMBER := NULL,
24
25 --added for 10+ word integration and deviations report
26 p_authoring_party_code IN VARCHAR2 := NULL, --default based on doc_type
27 p_contract_source_code IN VARCHAR2 := 'STRUCTURED',
28 p_approval_abstract_text IN CLOB := NULL,
29 p_autogen_deviations_flag IN VARCHAR2 := NULL,
30 --added for bug# 3990983
31 p_source_change_allowed_flag IN VARCHAR2 := 'Y',
32 x_document_type OUT NOCOPY VARCHAR2,
33 x_document_id OUT NOCOPY NUMBER,
34 p_lock_terms_flag IN VARCHAR2 := NULL,
35 p_enable_reporting_flag IN VARCHAR2 := NULL,
36 p_contract_admin_id IN NUMBER := NULL,
37 p_legal_contact_id IN NUMBER := NULL,
38 p_locked_by_user_id IN NUMBER := NULL,
39 p_contract_expert_finish_flag IN VARCHAR2 := NULL
40 );
41
42 PROCEDURE lock_row(
43 x_return_status OUT NOCOPY VARCHAR2,
44
45 p_document_type IN VARCHAR2,
46 p_document_id IN NUMBER,
47
48 p_object_version_number IN NUMBER
49 );
50
51 PROCEDURE update_row(
52 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
53 x_return_status OUT NOCOPY VARCHAR2,
54
55 p_document_type IN VARCHAR2,
56 p_document_id IN NUMBER,
57 p_template_id IN NUMBER := NULL,
58 p_doc_numbering_scheme IN NUMBER := NULL,
59 p_document_number IN VARCHAR2 := NULL,
60 p_article_effective_date IN DATE := NULL,
61 p_config_header_id IN NUMBER := NULL,
62 p_config_revision_number IN NUMBER := NULL,
63 p_valid_config_yn IN VARCHAR2 := NULL,
64 p_orig_system_reference_code IN VARCHAR2 := NULL,
65 p_orig_system_reference_id1 IN NUMBER := NULL,
66 p_orig_system_reference_id2 IN NUMBER := NULL,
67
68 p_object_version_number IN NUMBER := NULL,
69
70 --added for 10+ word integration and deviations report
71 p_authoring_party_code IN VARCHAR2 := NULL, -- default- not updated.
72 p_contract_source_code IN VARCHAR2 := NULL,
73 p_approval_abstract_text IN CLOB := NULL,
74 p_autogen_deviations_flag IN VARCHAR2 := NULL,
75 --added for bug# 3990983
76 p_source_change_allowed_flag IN VARCHAR2 := NULL ,
77 p_lock_terms_flag IN VARCHAR2 := NULL,
78 p_enable_reporting_flag IN VARCHAR2 := NULL,
79 p_contract_admin_id IN NUMBER := NULL,
80 p_legal_contact_id IN NUMBER := NULL,
81 p_locked_by_user_id IN NUMBER := NULL
82 );
83
84 PROCEDURE delete_row(
85 x_return_status OUT NOCOPY VARCHAR2,
86
87 p_document_type IN VARCHAR2,
88 p_document_id IN NUMBER,
89
90 p_object_version_number IN NUMBER
91 , p_retain_lock_xprt_yn IN VARCHAR2 := 'N'
92 );
93
94 PROCEDURE validate_row(
95 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
96 x_return_status OUT NOCOPY VARCHAR2,
97
98 p_document_type IN VARCHAR2,
99 p_document_id IN NUMBER,
100 p_template_id IN NUMBER,
101 p_doc_numbering_scheme IN NUMBER,
102 p_document_number IN VARCHAR2,
103 p_article_effective_date IN DATE,
104 p_config_header_id IN NUMBER,
105 p_config_revision_number IN NUMBER,
106 p_valid_config_yn IN VARCHAR2,
107 p_orig_system_reference_code IN VARCHAR2 := NULL,
108 p_orig_system_reference_id1 IN NUMBER := NULL,
109 p_orig_system_reference_id2 IN NUMBER := NULL,
110
111 p_object_version_number IN NUMBER,
112
113 --added for 10+ word integration and deviations report
114 p_authoring_party_code IN VARCHAR2 := NULL, --default based on doc_type
115 p_contract_source_code IN VARCHAR2 := 'STRUCTURED',
116 p_approval_abstract_text IN CLOB := NULL,
117 p_autogen_deviations_flag IN VARCHAR2 := NULL,
118 --added for bug# 3990983
119 p_source_change_allowed_flag IN VARCHAR2 := 'Y',
120 p_lock_terms_flag IN VARCHAR2 := NULL,
121 p_enable_reporting_flag IN VARCHAR2 := NULL,
122 p_contract_admin_id IN NUMBER := NULL,
123 p_legal_contact_id IN NUMBER := NULL,
124 p_locked_by_user_id IN NUMBER := NULL
125 );
126
127 FUNCTION get_rec (
128 p_document_type IN VARCHAR2,
129 p_document_id IN NUMBER,
130
131 x_template_id OUT NOCOPY NUMBER,
132 x_doc_numbering_scheme OUT NOCOPY NUMBER,
133 x_document_number OUT NOCOPY VARCHAR2,
134 x_article_effective_date OUT NOCOPY DATE,
135 x_config_header_id OUT NOCOPY NUMBER,
136 x_config_revision_number OUT NOCOPY NUMBER,
137 x_valid_config_yn OUT NOCOPY VARCHAR2,
138 x_orig_system_reference_code OUT NOCOPY VARCHAR2,
139 x_orig_system_reference_id1 OUT NOCOPY NUMBER,
140 x_orig_system_reference_id2 OUT NOCOPY NUMBER,
141 x_object_version_number OUT NOCOPY NUMBER,
142 x_created_by OUT NOCOPY NUMBER,
143 x_creation_date OUT NOCOPY DATE,
144 x_last_updated_by OUT NOCOPY NUMBER,
145 x_last_update_login OUT NOCOPY NUMBER,
146 x_last_update_date OUT NOCOPY DATE,
147
148 --added for 10+ word integration and deviations report
149 x_authoring_party_code OUT NOCOPY VARCHAR2 ,
150 x_contract_source_code OUT NOCOPY VARCHAR2 ,
151 x_approval_abstract_text OUT NOCOPY CLOB ,
152 x_autogen_deviations_flag OUT NOCOPY VARCHAR2 ,
153 --added for bug# 3990983
154 x_source_change_allowed_flag OUT NOCOPY VARCHAR2 ,
155 x_lock_terms_flag OUT NOCOPY VARCHAR2,
156 x_enable_reporting_flag OUT NOCOPY VARCHAR2,
157 x_contract_admin_id OUT NOCOPY NUMBER,
158 x_legal_contact_id OUT NOCOPY NUMBER,
159 x_locked_by_user_id OUT NOCOPY NUMBER
160 ) RETURN VARCHAR2;
161
162
163 FUNCTION Create_Version(
164 p_doc_type IN VARCHAR2,
165 p_doc_id IN NUMBER,
166 p_major_version IN NUMBER
167 ) RETURN VARCHAR2;
168
169 FUNCTION Restore_Version(
170 p_doc_type IN VARCHAR2,
171 p_doc_id IN NUMBER,
172 p_major_version NUMBER
173 ) RETURN VARCHAR2;
174
175 --This Function is called from Versioning API OKC_VERSION_PVT
176 -- to delete template usages for specified version of document
177
178 FUNCTION Delete_Version(
179 p_doc_type IN VARCHAR2,
180 p_doc_id IN NUMBER,
181 p_major_version IN NUMBER
182 ) RETURN VARCHAR2;
183
184 PROCEDURE Update_Template_Id(
185 x_return_status OUT NOCOPY VARCHAR2,
186 p_old_template_id IN NUMBER,
187 p_new_template_id IN NUMBER
188 );
189 PROCEDURE Delete_Set(
190 x_return_status OUT NOCOPY VARCHAR2,
191 p_template_id IN NUMBER
192 );
193 END OKC_TEMPLATE_USAGES_PVT;