eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_CONTRACT_PARTY_PVT dependencies on OKC_API

Line 6: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

2: /* $Header: OKCCCPLB.pls 120.0 2005/05/25 19:21:18 appldev noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:
6: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_PARTY_PVT';
8: G_CHILD_RECORD_FOUND CONSTANT varchar2(200) := 'OKC_CHILD_RECORD_FOUND';
9: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
10: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

Line 9: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

5:
6: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_PARTY_PVT';
8: G_CHILD_RECORD_FOUND CONSTANT varchar2(200) := 'OKC_CHILD_RECORD_FOUND';
9: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
10: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
11: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
12: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
13: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

Line 10: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

6: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_PARTY_PVT';
8: G_CHILD_RECORD_FOUND CONSTANT varchar2(200) := 'OKC_CHILD_RECORD_FOUND';
9: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
10: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
11: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
12: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
13: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
14:

Line 11: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_PARTY_PVT';
8: G_CHILD_RECORD_FOUND CONSTANT varchar2(200) := 'OKC_CHILD_RECORD_FOUND';
9: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
10: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
11: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
12: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
13: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
14:
15: -- Start of comments

Line 12: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

8: G_CHILD_RECORD_FOUND CONSTANT varchar2(200) := 'OKC_CHILD_RECORD_FOUND';
9: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
10: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
11: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
12: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
13: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
14:
15: -- Start of comments
16: --

Line 13: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

9: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
10: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
11: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
12: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
13: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
14:
15: -- Start of comments
16: --
17: -- Procedure Name : create_contact

Line 43: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then

39: x_msg_data => x_msg_data,
40: p_ctcv_rec => p_ctcv_rec,
41: x_ctcv_rec => x_ctcv_rec);
42: --V
43: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
44: return;
45: end if;
46: l_cvmv_rec.chr_id := p_ctcv_rec.DNZ_CHR_ID;
47: OKC_CVM_PVT.update_contract_version(

Line 49: p_init_msg_list => OKC_API.G_FALSE,

45: end if;
46: l_cvmv_rec.chr_id := p_ctcv_rec.DNZ_CHR_ID;
47: OKC_CVM_PVT.update_contract_version(
48: p_api_version => p_api_version,
49: p_init_msg_list => OKC_API.G_FALSE,
50: x_return_status => x_return_status,
51: x_msg_count => x_msg_count,
52: x_msg_data => x_msg_data,
53: p_cvmv_rec => l_cvmv_rec,

Line 90: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then

86: x_msg_data => x_msg_data,
87: p_ctcv_rec => p_ctcv_rec,
88: x_ctcv_rec => x_ctcv_rec);
89: --V
90: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
91: return;
92: end if;
93: open dnz_csr;
94: fetch dnz_csr into l_cvmv_rec.chr_id;

Line 98: p_init_msg_list => OKC_API.G_FALSE,

94: fetch dnz_csr into l_cvmv_rec.chr_id;
95: close dnz_csr;
96: OKC_CVM_PVT.update_contract_version(
97: p_api_version => p_api_version,
98: p_init_msg_list => OKC_API.G_FALSE,
99: x_return_status => x_return_status,
100: x_msg_count => x_msg_count,
101: x_msg_data => x_msg_data,
102: p_cvmv_rec => l_cvmv_rec,

Line 135: x_return_status := OKC_API.G_RET_STS_SUCCESS;

131: open dnz_csr;
132: fetch dnz_csr into l_cvmv_rec.chr_id;
133: close dnz_csr;
134: if (l_cvmv_rec.chr_id is NULL) then
135: x_return_status := OKC_API.G_RET_STS_SUCCESS;
136: return;
137: end if;
138: --V
139: okc_ctc_pvt.delete_row(p_api_version => p_api_version,

Line 146: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then

142: x_msg_count => x_msg_count,
143: x_msg_data => x_msg_data,
144: p_ctcv_rec => p_ctcv_rec);
145: --V
146: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
147: return;
148: end if;
149: OKC_CVM_PVT.update_contract_version(
150: p_api_version => p_api_version,

Line 151: p_init_msg_list => OKC_API.G_FALSE,

147: return;
148: end if;
149: OKC_CVM_PVT.update_contract_version(
150: p_api_version => p_api_version,
151: p_init_msg_list => OKC_API.G_FALSE,
152: x_return_status => x_return_status,
153: x_msg_count => x_msg_count,
154: x_msg_data => x_msg_data,
155: p_cvmv_rec => l_cvmv_rec,

Line 234: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then

230: x_msg_data => x_msg_data,
231: p_cplv_rec => p_cplv_rec,
232: x_cplv_rec => x_cplv_rec);
233: --V
234: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
235: return;
236: end if;
237: l_cvmv_rec.chr_id := p_cplv_rec.DNZ_CHR_ID;
238: OKC_CVM_PVT.update_contract_version(

Line 240: p_init_msg_list => OKC_API.G_FALSE,

236: end if;
237: l_cvmv_rec.chr_id := p_cplv_rec.DNZ_CHR_ID;
238: OKC_CVM_PVT.update_contract_version(
239: p_api_version => p_api_version,
240: p_init_msg_list => OKC_API.G_FALSE,
241: x_return_status => x_return_status,
242: x_msg_count => x_msg_count,
243: x_msg_data => x_msg_data,
244: p_cvmv_rec => l_cvmv_rec,

Line 304: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then

300: x_msg_data => x_msg_data,
301: p_cplv_rec => p_cplv_rec,
302: x_cplv_rec => x_cplv_rec);
303: --V
304: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
305: return;
306: end if;
307: open dnz_csr;
308: fetch dnz_csr into l_cvmv_rec.chr_id;

Line 312: p_init_msg_list => OKC_API.G_FALSE,

308: fetch dnz_csr into l_cvmv_rec.chr_id;
309: close dnz_csr;
310: OKC_CVM_PVT.update_contract_version(
311: p_api_version => p_api_version,
312: p_init_msg_list => OKC_API.G_FALSE,
313: x_return_status => x_return_status,
314: x_msg_count => x_msg_count,
315: x_msg_data => x_msg_data,
316: p_cvmv_rec => l_cvmv_rec,

Line 353: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

349: open l_cpl_csr;
350: fetch l_cpl_csr into l_dummy_var;
351: close l_cpl_csr;
352: if (l_dummy_var = 'x') then
353: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
354: p_msg_name => 'OKC_NO_DELETE_IF_CTC_EXIST');
355: x_return_status := OKC_API.G_RET_STS_ERROR;
356: RAISE OKC_API.G_EXCEPTION_ERROR;
357: END IF;

Line 355: x_return_status := OKC_API.G_RET_STS_ERROR;

351: close l_cpl_csr;
352: if (l_dummy_var = 'x') then
353: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
354: p_msg_name => 'OKC_NO_DELETE_IF_CTC_EXIST');
355: x_return_status := OKC_API.G_RET_STS_ERROR;
356: RAISE OKC_API.G_EXCEPTION_ERROR;
357: END IF;
358: --V
359: open dnz_csr;

Line 356: RAISE OKC_API.G_EXCEPTION_ERROR;

352: if (l_dummy_var = 'x') then
353: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
354: p_msg_name => 'OKC_NO_DELETE_IF_CTC_EXIST');
355: x_return_status := OKC_API.G_RET_STS_ERROR;
356: RAISE OKC_API.G_EXCEPTION_ERROR;
357: END IF;
358: --V
359: open dnz_csr;
360: fetch dnz_csr into l_cvmv_rec.chr_id;

Line 363: x_return_status := OKC_API.G_RET_STS_SUCCESS;

359: open dnz_csr;
360: fetch dnz_csr into l_cvmv_rec.chr_id;
361: close dnz_csr;
362: if (l_cvmv_rec.chr_id is NULL) then
363: x_return_status := OKC_API.G_RET_STS_SUCCESS;
364: return;
365: end if;
366: --V
367: okc_cpl_pvt.delete_row(p_api_version => p_api_version,

Line 374: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then

370: x_msg_count => x_msg_count,
371: x_msg_data => x_msg_data,
372: p_cplv_rec => p_cplv_rec);
373: --V
374: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
375: return;
376: end if;
377: OKC_CVM_PVT.update_contract_version(
378: p_api_version => p_api_version,

Line 379: p_init_msg_list => OKC_API.G_FALSE,

375: return;
376: end if;
377: OKC_CVM_PVT.update_contract_version(
378: p_api_version => p_api_version,
379: p_init_msg_list => OKC_API.G_FALSE,
380: x_return_status => x_return_status,
381: x_msg_count => x_msg_count,
382: x_msg_data => x_msg_data,
383: p_cvmv_rec => l_cvmv_rec,