1 PACKAGE OKC_TEMPLATE_USAGES_GRP AS
2 /* $Header: OKCGTMPLUSGS.pls 120.1 2005/07/21 17:55:55 vnanjang noship $ */
3
4 ---------------------------------------------------------------------------
5 -- Procedures and Functions
6 ---------------------------------------------------------------------------
7
8 PROCEDURE create_template_usages(
9 p_api_version IN NUMBER,
10 p_init_msg_list IN VARCHAR2 ,
11 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12 p_commit IN VARCHAR2 := FND_API.G_FALSE,
13
14 x_return_status OUT NOCOPY VARCHAR2,
15 x_msg_count OUT NOCOPY NUMBER,
16 x_msg_data OUT NOCOPY VARCHAR2,
17
18 p_document_type IN VARCHAR2,
19 p_document_id IN NUMBER,
20 p_template_id IN NUMBER,
21 p_doc_numbering_scheme IN NUMBER,
22 p_document_number IN VARCHAR2,
23 p_article_effective_date IN DATE,
24 p_config_header_id IN NUMBER,
25 p_config_revision_number IN NUMBER,
26 p_valid_config_yn IN VARCHAR2,
27 p_orig_system_reference_code IN VARCHAR2 := NULL,
28 p_orig_system_reference_id1 IN NUMBER := NULL,
29 p_orig_system_reference_id2 IN NUMBER := NULL,
30
31 p_approval_abstract_text IN CLOB := NULL,
32 p_contract_source_code IN VARCHAR2 := 'STRUCTURED',
33 p_authoring_party_code IN VARCHAR2 := NULL,
34 p_autogen_deviations_flag IN VARCHAR2 := NULL,
35 --Fix for bug# 3990983
36 p_source_change_allowed_flag IN VARCHAR2 := 'Y',
37
38 x_document_type OUT NOCOPY VARCHAR2,
39 x_document_id OUT NOCOPY NUMBER,
40 p_lock_terms_flag IN VARCHAR2 := NULL,
41 p_enable_reporting_flag IN VARCHAR2 := NULL,
42 p_contract_admin_id IN NUMBER := NULL,
43 p_legal_contact_id IN NUMBER := NULL,
44 p_locked_by_user_id IN NUMBER := NULL
45
46 );
47
48 PROCEDURE lock_row(
49 p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2 ,
51
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2,
55
56 p_document_type IN VARCHAR2,
57 p_document_id IN NUMBER,
58
59 p_object_version_number IN NUMBER
60
61 );
62
63 PROCEDURE update_template_usages(
64 p_api_version IN NUMBER,
65 p_init_msg_list IN VARCHAR2 ,
66 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
67 p_commit IN VARCHAR2 := FND_API.G_FALSE,
68
69 x_return_status OUT NOCOPY VARCHAR2,
70 x_msg_count OUT NOCOPY NUMBER,
71 x_msg_data OUT NOCOPY VARCHAR2,
72
73 p_document_type IN VARCHAR2,
74 p_document_id IN NUMBER,
75 p_template_id IN NUMBER := NULL,
76 p_doc_numbering_scheme IN NUMBER := NULL,
77 p_document_number IN VARCHAR2 := NULL,
78 p_article_effective_date IN DATE := NULL,
79 p_config_header_id IN NUMBER := NULL,
80 p_config_revision_number IN NUMBER := NULL,
81 p_valid_config_yn IN VARCHAR2 := NULL,
82 p_orig_system_reference_code IN VARCHAR2 := NULL,
83 p_orig_system_reference_id1 IN NUMBER := NULL,
84 p_orig_system_reference_id2 IN NUMBER := NULL,
85
86 p_approval_abstract_text IN CLOB := NULL,
87 p_contract_source_code IN VARCHAR2 := NULL,
88 p_authoring_party_code IN VARCHAR2 := NULL,
89 p_autogen_deviations_flag IN VARCHAR2 := NULL,
90 --Fix for bug# 3990983
91 p_source_change_allowed_flag IN VARCHAR2 := NULL,
92 p_object_version_number IN NUMBER := NULL,
93 p_lock_terms_flag IN VARCHAR2 := NULL,
94 p_enable_reporting_flag IN VARCHAR2 := NULL,
95 p_contract_admin_id IN NUMBER := NULL,
96 p_legal_contact_id IN NUMBER := NULL,
97 p_locked_by_user_id IN NUMBER := NULL
98 );
99
100 PROCEDURE delete_template_usages(
101 p_api_version IN NUMBER,
102 p_init_msg_list IN VARCHAR2 ,
103 p_commit IN VARCHAR2 := FND_API.G_FALSE,
104
105 x_return_status OUT NOCOPY VARCHAR2,
106 x_msg_count OUT NOCOPY NUMBER,
107 x_msg_data OUT NOCOPY VARCHAR2,
108
109 p_document_type IN VARCHAR2,
110 p_document_id IN NUMBER,
111
112 p_object_version_number IN NUMBER
113 );
114
115 PROCEDURE validate_row(
116 p_api_version IN NUMBER,
117 p_init_msg_list IN VARCHAR2 ,
118 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
119
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2,
123
124 p_document_type IN VARCHAR2,
125 p_document_id IN NUMBER,
126 p_template_id IN NUMBER,
127 p_doc_numbering_scheme IN NUMBER,
128 p_document_number IN VARCHAR2,
129 p_article_effective_date IN DATE,
130 p_config_header_id IN NUMBER,
131 p_config_revision_number IN NUMBER,
132 p_valid_config_yn IN VARCHAR2,
133 p_orig_system_reference_code IN VARCHAR2 := NULL,
134 p_orig_system_reference_id1 IN NUMBER := NULL,
135 p_orig_system_reference_id2 IN NUMBER := NULL,
136
137
138 p_approval_abstract_text IN CLOB := NULL,
139 p_contract_source_code IN VARCHAR2 := 'STRUCTURED',
140 p_authoring_party_code IN VARCHAR2 := NULL,
141 p_autogen_deviations_flag IN VARCHAR2 := NULL,
142 --Fix for bug# 3990983
143 p_source_change_allowed_flag IN VARCHAR2 := 'Y',
144 p_object_version_number IN NUMBER,
145 p_lock_terms_flag IN VARCHAR2 := NULL,
146 p_enable_reporting_flag IN VARCHAR2 := NULL,
147 p_contract_admin_id IN NUMBER := NULL,
148 p_legal_contact_id IN NUMBER := NULL,
149 p_locked_by_user_id IN NUMBER := NULL
150 );
151
152 PROCEDURE Set_Contract_Source(
153 p_api_version IN NUMBER,
154 p_init_msg_list IN VARCHAR2 ,
155 p_commit IN VARCHAR2 := FND_API.G_FALSE,
156
157 x_return_status OUT NOCOPY VARCHAR2,
158 x_msg_count OUT NOCOPY NUMBER,
159 x_msg_data OUT NOCOPY VARCHAR2,
160
161 p_document_type IN VARCHAR2,
162 p_document_id IN NUMBER,
163 p_contract_source_code IN VARCHAR2,
164 p_authoring_party_code IN VARCHAR2,
165 p_validation_string IN VARCHAR2,
166
167 p_document_number IN VARCHAR2 := NULL
168 );
169
170
171 PROCEDURE set_contract_source_details(
172 p_api_version IN NUMBER,
173 p_init_msg_list IN VARCHAR2 ,
174 p_commit IN VARCHAR2 := FND_API.G_FALSE,
175
176 x_return_status OUT NOCOPY VARCHAR2,
177 x_msg_count OUT NOCOPY NUMBER,
178 x_msg_data OUT NOCOPY VARCHAR2,
179
180 p_document_type IN VARCHAR2,
181 p_document_id IN NUMBER,
182 p_contract_source_code IN VARCHAR2,
183 p_authoring_party_code IN VARCHAR2,
184 p_validation_string IN VARCHAR2,
185
186 p_document_number IN VARCHAR2 := NULL,
187 p_enable_reporting_flag IN VARCHAR2 := NULL,
188 p_contract_admin_id IN NUMBER := NULL,
189 p_legal_contact_id IN NUMBER := NULL
190
191 );
192 END OKC_TEMPLATE_USAGES_GRP;