DBA Data[Home] [Help]

APPS.OKC_CONTRACT_PVT dependencies on OKC_CVM_PVT

Line 243: x_out_rec OKC_CVM_PVT.cvmv_rec_type;

239: l_init_msg_list VARCHAR2(1) := 'F';
240: x_return_status VARCHAR2(1);
241: x_msg_count NUMBER;
242: x_msg_data VARCHAR2(2000);
243: x_out_rec OKC_CVM_PVT.cvmv_rec_type;
244: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
245: BEGIN
246:
247: -- initialize return status

Line 244: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;

240: x_return_status VARCHAR2(1);
241: x_msg_count NUMBER;
242: x_msg_data VARCHAR2(2000);
243: x_out_rec OKC_CVM_PVT.cvmv_rec_type;
244: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
245: BEGIN
246:
247: -- initialize return status
248: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 253: OKC_CVM_PVT.update_contract_version(

249:
250: -- assign/populate contract header id
251: l_cvmv_rec.chr_id := p_chr_id;
252:
253: OKC_CVM_PVT.update_contract_version(
254: p_api_version => l_api_version,
255: p_init_msg_list => l_init_msg_list,
256: x_return_status => x_return_status,
257: x_msg_count => x_msg_count,

Line 294: x_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;

290: p_init_msg_list VARCHAR2(1) := 'F';
291: x_return_status VARCHAR2(1);
292: x_msg_count NUMBER;
293: x_msg_data VARCHAR2(2000);
294: x_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
295:
296: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
297: BEGIN
298:

Line 296: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;

292: x_msg_count NUMBER;
293: x_msg_data VARCHAR2(2000);
294: x_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
295:
296: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
297: BEGIN
298:
299: x_return_status := OKC_API.G_RET_STS_SUCCESS;
300:

Line 307: OKC_CVM_PVT.update_row(

303: -- Major version update is not allowed
304: l_cvmv_rec.major_version := OKC_API.G_MISS_NUM;
305:
306: -- update contract version number
307: OKC_CVM_PVT.update_row(
308: p_api_version,
309: p_init_msg_list,
310: x_return_status,
311: x_msg_count,

Line 317: OKC_CVM_PVT.g_trans_id := dbms_transaction.local_transaction_id;

313: l_cvmv_rec,
314: x_cvmv_rec);
315:
316: -- assign current trasaction id to global_trans_id
317: OKC_CVM_PVT.g_trans_id := dbms_transaction.local_transaction_id;
318: return x_return_status;
319: EXCEPTION
320: WHEN OTHERS THEN
321: -- store SQL error message on message stack

Line 339: x_out_rec OKC_CVM_PVT.cvmv_rec_type;

335: l_init_msg_list VARCHAR2(1) := 'F';
336: x_return_status VARCHAR2(1);
337: x_msg_count NUMBER;
338: x_msg_data VARCHAR2(2000);
339: x_out_rec OKC_CVM_PVT.cvmv_rec_type;
340: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
341: BEGIN
342:
343: -- initialize return status

Line 340: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;

336: x_return_status VARCHAR2(1);
337: x_msg_count NUMBER;
338: x_msg_data VARCHAR2(2000);
339: x_out_rec OKC_CVM_PVT.cvmv_rec_type;
340: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
341: BEGIN
342:
343: -- initialize return status
344: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 349: OKC_CVM_PVT.create_contract_version(

345:
346: -- assign/populate contract header id
347: l_cvmv_rec.chr_id := p_chr_id;
348:
349: OKC_CVM_PVT.create_contract_version(
350: p_api_version => l_api_version,
351: p_init_msg_list => l_init_msg_list,
352: x_return_status => x_return_status,
353: x_msg_count => x_msg_count,

Line 383: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;

379: l_init_msg_list VARCHAR2(1) := 'F';
380: x_return_status VARCHAR2(1);
381: x_msg_count NUMBER;
382: x_msg_data VARCHAR2(2000);
383: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
384: BEGIN
385:
386: -- initialize return status
387: x_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 392: OKC_CVM_PVT.delete_contract_version(

388:
389: -- assign/populate contract header id
390: l_cvmv_rec.chr_id := p_chr_id;
391:
392: OKC_CVM_PVT.delete_contract_version(
393: p_api_version => l_api_version,
394: p_init_msg_list => l_init_msg_list,
395: x_return_status => x_return_status,
396: x_msg_count => x_msg_count,

Line 4439: OKC_CVM_PVT.g_trans_id := 'XX-XX';

4435: END IF;
4436: END LOOP;
4437:
4438: --- Added for Bug# 2606251 --- to increment version for a renewed contract(when staus is changed)
4439: OKC_CVM_PVT.g_trans_id := 'XX-XX';
4440: --- Added for Bug# 2606251 ---
4441:
4442: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
4443: EXCEPTION

Line 5172: OKC_CVM_PVT.g_trans_id := 'XX-XX';

5168: raise OKC_API.G_EXCEPTION_ERROR;
5169: END IF;
5170:
5171:
5172: OKC_CVM_PVT.g_trans_id := 'XX-XX';
5173:
5174: EXCEPTION
5175: WHEN OKC_API.G_EXCEPTION_ERROR THEN
5176: x_return_status := OKC_API.HANDLE_EXCEPTIONS