DBA Data[Home] [Help]

APPS.OKC_CONTRACT_ITEM_PVT dependencies on OKC_API

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

2: /* $Header: OKCCCIMB.pls 120.0 2005/05/26 09:44:03 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_ITEM_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_ITEM_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:
12: -- Start of comments
13: --

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_ITEM_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:
12: -- Start of comments
13: --
14: -- Procedure Name : create_contract_item

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

36: x_return_status => x_return_status,
37: p_cimv_rec => p_cimv_rec,
38: x_cimv_rec => x_cimv_rec);
39: --V
40: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
41: return;
42: end if;
43: l_cvmv_rec.chr_id := p_cimv_rec.DNZ_CHR_ID;
44: OKC_CVM_PVT.update_contract_version(

Line 46: p_init_msg_list => OKC_API.G_FALSE,

42: end if;
43: l_cvmv_rec.chr_id := p_cimv_rec.DNZ_CHR_ID;
44: OKC_CVM_PVT.update_contract_version(
45: p_api_version => p_api_version,
46: p_init_msg_list => OKC_API.G_FALSE,
47: x_return_status => x_return_status,
48: x_msg_count => x_msg_count,
49: x_msg_data => x_msg_data,
50: p_cvmv_rec => l_cvmv_rec,

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

83: x_return_status => x_return_status,
84: p_cimv_rec => p_cimv_rec,
85: x_cimv_rec => x_cimv_rec);
86: --V
87: if (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
88: return;
89: end if;
90: open dnz_csr;
91: fetch dnz_csr into l_cvmv_rec.chr_id;

Line 95: p_init_msg_list => OKC_API.G_FALSE,

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

Line 133: x_return_status := OKC_API.G_RET_STS_SUCCESS;

129: open dnz_csr;
130: fetch dnz_csr into l_cvmv_rec.chr_id;
131: close dnz_csr;
132: if (l_cvmv_rec.chr_id is NULL) then
133: x_return_status := OKC_API.G_RET_STS_SUCCESS;
134: return;
135: end if;
136: --V
137:

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

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

Line 150: p_init_msg_list => OKC_API.G_FALSE,

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