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