[Home] [Help]
123: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
124: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
125: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
126: END IF;
127: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
128: OKC_REP_UTIL_PVT.change_contract_status(
129: p_api_version => 1.0,
130: p_init_msg_list => FND_API.G_FALSE,
131: p_contract_id => p_contract_id,
1178: -- Initialize API return status to success
1179: x_return_status := FND_API.G_RET_STS_SUCCESS;
1180:
1181: -- Delete the records. The records are locked in the delete_contract API.
1182: DELETE FROM OKC_REP_CON_STATUS_HIST
1183: WHERE CONTRACT_ID = p_CONTRACT_ID
1184: AND CONTRACT_VERSION_NUM = p_contract_version;
1185:
1186: -- Standard check of p_commit
4605: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4606: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4607: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
4608: END IF;
4609: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
4610: OKC_REP_UTIL_PVT.change_contract_status(
4611: p_api_version => 1.0,
4612: p_init_msg_list => FND_API.G_FALSE,
4613: p_contract_id => p_contract_id,
5040: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5041: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5042: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
5043: END IF;
5044: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
5045: OKC_REP_UTIL_PVT.change_contract_status(
5046: p_api_version => 1.0,
5047: p_init_msg_list => FND_API.G_FALSE,
5048: p_contract_id => p_contract_id,
5419: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5420: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
5421: END IF;
5422:
5423: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
5424: OKC_REP_UTIL_PVT.change_contract_status(
5425: p_api_version => 1.0,
5426: p_init_msg_list => FND_API.G_FALSE,
5427: p_contract_id => p_contract_id,
6238: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
6239: 'Calling OKC_REP_UTIL_PVT.change_contract_status');
6240: END IF;
6241:
6242: -- Update the contract status and add a record in OKC_REP_CON_STATUS_HIST table.
6243: OKC_REP_UTIL_PVT.change_contract_status(
6244: p_api_version => 1.0,
6245: p_init_msg_list => FND_API.G_FALSE,
6246: p_contract_id => p_contract_id,