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 4497: OKC_CVM_PVT.g_trans_id := 'XX-XX';

4493: END IF;
4494: END LOOP;
4495:
4496: --- Added for Bug# 2606251 --- to increment version for a renewed contract(when staus is changed)
4497: OKC_CVM_PVT.g_trans_id := 'XX-XX';
4498: --- Added for Bug# 2606251 ---
4499:
4500: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
4501: EXCEPTION

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

5330: raise OKC_API.G_EXCEPTION_ERROR;
5331: END IF;
5332:
5333:
5334: OKC_CVM_PVT.g_trans_id := 'XX-XX';
5335:
5336: EXCEPTION
5337: WHEN OKC_API.G_EXCEPTION_ERROR THEN
5338: x_return_status := OKC_API.HANDLE_EXCEPTIONS