DBA Data[Home] [Help]

APPS.OKL_VERSION_PVT dependencies on OKL_CONTRACT_IB_H

Line 273: -- OKL_CONTRACT_IB_H tables

269: ----------------------------------------------------------------------------------------
270: -- Start of comments
271: -- Procedure Name : Create_ib_version
272: -- Description : creates Records IB in
273: -- OKL_CONTRACT_IB_H tables
274: -- Business Rules :
275: -- Parameters :
276: -- Version : 1.0
277: -- End of comments

Line 405: -- Now we are going to install into OKL_CONTRACT_IB_H table

401: p_token1 => 'CONTRACT_NUMBER',
402: p_token1_value => l_cntrct_number);
403: RAISE OKL_API.G_EXCEPTION_ERROR;
404: END IF;
405: -- Now we are going to install into OKL_CONTRACT_IB_H table
406: OKL_VERSION_IB_PUB.create_version_ib(
407: p_api_version => p_api_version,
408: p_init_msg_list => p_init_msg_list,
409: x_return_status => x_return_status,

Line 669: p_token1_value => 'OKL_CONTRACT_IB_H');

665: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
666: OKL_API.set_message(p_app_name => G_APP_NAME,
667: p_msg_name => G_CREATE_VER_ERROR,
668: p_token1 => G_COL_NAME_TOKEN,
669: p_token1_value => 'OKL_CONTRACT_IB_H');
670: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
671: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
672: OKL_API.set_message(p_app_name => G_APP_NAME,
673: p_msg_name => G_CREATE_VER_ERROR,

Line 675: p_token1_value => 'OKL_CONTRACT_IB_H');

671: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
672: OKL_API.set_message(p_app_name => G_APP_NAME,
673: p_msg_name => G_CREATE_VER_ERROR,
674: p_token1 => G_COL_NAME_TOKEN,
675: p_token1_value => 'OKL_CONTRACT_IB_H');
676: RAISE OKL_API.G_EXCEPTION_ERROR;
677: END IF;
678: OKL_API.END_ACTIVITY (x_msg_count,
679: x_msg_data );

Line 857: -- OKL_CONTRACT_IB_H tables is to be give so untill then we

853: -------------
854:
855:
856: -- More thought for Restore of OKL_CONTRACT_ASSET_H and
857: -- OKL_CONTRACT_IB_H tables is to be give so untill then we
858: -- not code for restore of these tables
859: OKL_API.END_ACTIVITY (x_msg_count,
860: x_msg_data );
861:

Line 935: DELETE FROM OKL_CONTRACT_IB_H

931: -- Deleting the FA Version
932: DELETE FROM OKL_CONTRACT_ASSET_H
933: WHERE DNZ_CHR_ID = p_chr_id;
934: -- Deleting the IB VERSION
935: DELETE FROM OKL_CONTRACT_IB_H
936: WHERE DNZ_CHR_ID = p_chr_id;
937: OKL_API.END_ACTIVITY (x_msg_count,
938: x_msg_data );
939: EXCEPTION

Line 1031: DELETE FROM OKL_CONTRACT_IB_H

1027: (p_called_from = 'RESTORE_VERSION'
1028: AND (major_version >= l_major_version OR
1029: major_version = -1)));
1030: -- Deleting the IB VERSION
1031: DELETE FROM OKL_CONTRACT_IB_H
1032: WHERE DNZ_CHR_ID = p_chr_id
1033: AND ((MAJOR_VERSION = -1
1034: AND p_called_from = 'ERASE_SAVED_VERSION') OR
1035: (p_called_from = 'RESTORE_VERSION'