36:
37: ---------------------------------------------------------------------------
38: -- GLOBAL MESSAGE CONSTANTS
39: ---------------------------------------------------------------------------
40: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
41: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
42: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
43: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
44: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
37: ---------------------------------------------------------------------------
38: -- GLOBAL MESSAGE CONSTANTS
39: ---------------------------------------------------------------------------
40: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
41: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
42: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
43: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
44: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
45: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
38: -- GLOBAL MESSAGE CONSTANTS
39: ---------------------------------------------------------------------------
40: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
41: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
42: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
43: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
44: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
45: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
46: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
39: ---------------------------------------------------------------------------
40: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
41: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
42: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
43: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
44: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
45: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
46: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
47: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
40: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
41: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
42: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
43: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
44: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
45: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
46: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
47: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
48: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
41: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
42: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
43: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
44: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
45: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
46: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
47: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
48: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
49: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
42: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
43: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
44: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
45: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
46: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
47: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
48: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
49: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
50: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
43: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
44: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
45: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
46: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
47: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
48: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
49: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
50: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
51: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
44: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
45: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
46: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
47: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
48: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
49: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
50: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
51: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
52: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
45: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
46: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
47: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
48: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
49: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
50: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
51: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
52: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
53: G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UPPERCASE_REQ';
59:
60: -- GLOBAL VARIABLES
61: ---------------------------------------------------------------------------
62: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_COPY_CONTRACT_PVT';
63: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
64: g_rulv_rec rulv_rec_type;
65: ---------------------------------------------------------------------------
66:
67: TYPE api_components_rec IS RECORD(id NUMBER,
85: --PL/SQL Table to check the party has already copied.
86: --If Yes give the new cpl_id ----Begins
87: ----------------------------------------------------------------------------
88: TYPE party_rec_type IS RECORD (
89: old_cpl_id NUMBER := OKC_API.G_MISS_NUM,
90: new_cpl_id NUMBER := OKC_API.G_MISS_NUM);
91: TYPE party_tbl_type IS TABLE OF party_rec_type
92: INDEX BY BINARY_INTEGER;
93: g_party party_tbl_type;
86: --If Yes give the new cpl_id ----Begins
87: ----------------------------------------------------------------------------
88: TYPE party_rec_type IS RECORD (
89: old_cpl_id NUMBER := OKC_API.G_MISS_NUM,
90: new_cpl_id NUMBER := OKC_API.G_MISS_NUM);
91: TYPE party_tbl_type IS TABLE OF party_rec_type
92: INDEX BY BINARY_INTEGER;
93: g_party party_tbl_type;
94:
104: x_new_lse_ids OUT NOCOPY VARCHAR2);
105:
106: PROCEDURE copy_components(
107: p_api_version IN NUMBER,
108: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
109: x_return_status OUT NOCOPY VARCHAR2,
110: x_msg_count OUT NOCOPY NUMBER,
111: x_msg_data OUT NOCOPY VARCHAR2,
112: p_from_chr_id IN NUMBER,
129:
130:
131: PROCEDURE copy_contract(
132: p_api_version IN NUMBER,
133: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
134: x_return_status OUT NOCOPY VARCHAR2,
135: x_msg_count OUT NOCOPY NUMBER,
136: x_msg_data OUT NOCOPY VARCHAR2,
137: p_commit IN VARCHAR2 DEFAULT 'F',
149: x_chr_id OUT NOCOPY NUMBER);
150:
151: PROCEDURE copy_contract_lines(
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_from_cle_id IN NUMBER,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_from_cle_id IN NUMBER,
158: p_to_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
159: p_to_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
160: p_to_template_yn IN VARCHAR2,
161: p_copy_reference IN VARCHAR2,
162: p_copy_line_party_yn IN VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_from_cle_id IN NUMBER,
158: p_to_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
159: p_to_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
160: p_to_template_yn IN VARCHAR2,
161: p_copy_reference IN VARCHAR2,
162: p_copy_line_party_yn IN VARCHAR2,
163: p_renew_ref_yn IN VARCHAR2,
168: -- topline during update service
169:
170: PROCEDURE copy_contract_header(
171: p_api_version IN NUMBER,
172: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,
175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_from_chr_id IN NUMBER,
187: x_chr_id OUT NOCOPY NUMBER);
188:
189: PROCEDURE copy_contract_line(
190: p_api_version IN NUMBER,
191: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,
194: x_msg_data OUT NOCOPY VARCHAR2,
195: p_from_cle_id IN NUMBER,
193: x_msg_count OUT NOCOPY NUMBER,
194: x_msg_data OUT NOCOPY VARCHAR2,
195: p_from_cle_id IN NUMBER,
196: p_from_chr_id IN NUMBER,
197: p_to_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
198: p_to_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
199: p_lse_id IN NUMBER,
200: p_to_template_yn IN VARCHAR2,
201: p_copy_reference IN VARCHAR2 DEFAULT 'COPY',
194: x_msg_data OUT NOCOPY VARCHAR2,
195: p_from_cle_id IN NUMBER,
196: p_from_chr_id IN NUMBER,
197: p_to_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
198: p_to_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
199: p_lse_id IN NUMBER,
200: p_to_template_yn IN VARCHAR2,
201: p_copy_reference IN VARCHAR2 DEFAULT 'COPY',
202: p_copy_line_party_yn IN VARCHAR2,
208: -- topline during update service
209:
210: PROCEDURE copy_party_roles(
211: p_api_version IN NUMBER,
212: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
213: x_return_status OUT NOCOPY VARCHAR2,
214: x_msg_count OUT NOCOPY NUMBER,
215: x_msg_data OUT NOCOPY VARCHAR2,
216: p_cpl_id IN NUMBER,
213: x_return_status OUT NOCOPY VARCHAR2,
214: x_msg_count OUT NOCOPY NUMBER,
215: x_msg_data OUT NOCOPY VARCHAR2,
216: p_cpl_id IN NUMBER,
217: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
218: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
219: p_rle_code IN VARCHAR2,
220: x_cpl_id OUT NOCOPY NUMBER);
221:
214: x_msg_count OUT NOCOPY NUMBER,
215: x_msg_data OUT NOCOPY VARCHAR2,
216: p_cpl_id IN NUMBER,
217: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
218: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
219: p_rle_code IN VARCHAR2,
220: x_cpl_id OUT NOCOPY NUMBER);
221:
222: PROCEDURE copy_articles(
220: x_cpl_id OUT NOCOPY NUMBER);
221:
222: PROCEDURE copy_articles(
223: p_api_version IN NUMBER,
224: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,
227: x_msg_data OUT NOCOPY VARCHAR2,
228: p_cat_id IN NUMBER,
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,
227: x_msg_data OUT NOCOPY VARCHAR2,
228: p_cat_id IN NUMBER,
229: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
230: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
231: p_sav_sav_release IN VARCHAR2 DEFAULT NULL,
232: x_cat_id OUT NOCOPY NUMBER);
233:
226: x_msg_count OUT NOCOPY NUMBER,
227: x_msg_data OUT NOCOPY VARCHAR2,
228: p_cat_id IN NUMBER,
229: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
230: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
231: p_sav_sav_release IN VARCHAR2 DEFAULT NULL,
232: x_cat_id OUT NOCOPY NUMBER);
233:
234: PROCEDURE copy_latest_articles(
232: x_cat_id OUT NOCOPY NUMBER);
233:
234: PROCEDURE copy_latest_articles(
235: p_api_version IN NUMBER,
236: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
237: x_return_status OUT NOCOPY VARCHAR2,
238: x_msg_count OUT NOCOPY NUMBER,
239: x_msg_data OUT NOCOPY VARCHAR2,
240: p_cat_id IN NUMBER,
237: x_return_status OUT NOCOPY VARCHAR2,
238: x_msg_count OUT NOCOPY NUMBER,
239: x_msg_data OUT NOCOPY VARCHAR2,
240: p_cat_id IN NUMBER,
241: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
242: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
243: x_cat_id OUT NOCOPY NUMBER);
244:
245: PROCEDURE copy_events(
238: x_msg_count OUT NOCOPY NUMBER,
239: x_msg_data OUT NOCOPY VARCHAR2,
240: p_cat_id IN NUMBER,
241: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
242: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
243: x_cat_id OUT NOCOPY NUMBER);
244:
245: PROCEDURE copy_events(
246: p_api_version IN NUMBER,
243: x_cat_id OUT NOCOPY NUMBER);
244:
245: PROCEDURE copy_events(
246: p_api_version IN NUMBER,
247: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
248: x_return_status OUT NOCOPY VARCHAR2,
249: x_msg_count OUT NOCOPY NUMBER,
250: x_msg_data OUT NOCOPY VARCHAR2,
251: p_cnh_id IN NUMBER,
248: x_return_status OUT NOCOPY VARCHAR2,
249: x_msg_count OUT NOCOPY NUMBER,
250: x_msg_data OUT NOCOPY VARCHAR2,
251: p_cnh_id IN NUMBER,
252: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
253: p_to_template_yn IN VARCHAR2,
254: x_cnh_id OUT NOCOPY NUMBER);
255:
256: PROCEDURE copy_rules(
254: x_cnh_id OUT NOCOPY NUMBER);
255:
256: PROCEDURE copy_rules(
257: p_api_version IN NUMBER,
258: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
259: x_return_status OUT NOCOPY VARCHAR2,
260: x_msg_count OUT NOCOPY NUMBER,
261: x_msg_data OUT NOCOPY VARCHAR2,
262: p_rgp_id IN NUMBER,
259: x_return_status OUT NOCOPY VARCHAR2,
260: x_msg_count OUT NOCOPY NUMBER,
261: x_msg_data OUT NOCOPY VARCHAR2,
262: p_rgp_id IN NUMBER,
263: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
264: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
265: p_to_template_yn IN VARCHAR2,
266: x_rgp_id OUT NOCOPY NUMBER);
267:
260: x_msg_count OUT NOCOPY NUMBER,
261: x_msg_data OUT NOCOPY VARCHAR2,
262: p_rgp_id IN NUMBER,
263: p_cle_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
264: p_chr_id IN NUMBER DEFAULT OKC_API.G_MISS_NUM,
265: p_to_template_yn IN VARCHAR2,
266: x_rgp_id OUT NOCOPY NUMBER);
267:
268: -- Bug 2950549 Added following 2 procedures add_concurrent and