APPS.OKL_VERSION_PVT dependencies on OKL_CONTRACT_ASSET_H

Line 48: -- OKL_CONTRACT_ASSET_H

44:
45: -- Start of comments
46: -- Procedure Name : Create_fa_version
47: -- Description : creates Records FA in
48: -- OKL_CONTRACT_ASSET_H
49: -- Business Rules :
50: -- Parameters :
51: -- Version : 1.0
52: -- End of comments

Line 209: -- Now we are going to install into OKL_CONTRACT_ASSET_H table

205: p_token1_value => l_cntrct_number);
206: RAISE OKL_API.G_EXCEPTION_ERROR;
207: END IF;
208:
209: -- Now we are going to install into OKL_CONTRACT_ASSET_H table
210: OKL_VERSION_FA_PUB.create_version_fa(
211: p_api_version => p_api_version,
212: p_init_msg_list => p_init_msg_list,
213: x_return_status => x_return_status,

Line 647: p_token1_value => 'OKL_CONTRACT_ASSET_H');

643: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
644: OKL_API.set_message(p_app_name => G_APP_NAME,
645: p_msg_name => G_CREATE_VER_ERROR,
646: p_token1 => G_COL_NAME_TOKEN,
647: p_token1_value => 'OKL_CONTRACT_ASSET_H');
648: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
649: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
650: OKL_API.set_message(p_app_name => G_APP_NAME,
651: p_msg_name => G_CREATE_VER_ERROR,

Line 653: p_token1_value => 'OKL_CONTRACT_ASSET_H');

649: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
650: OKL_API.set_message(p_app_name => G_APP_NAME,
651: p_msg_name => G_CREATE_VER_ERROR,
652: p_token1 => G_COL_NAME_TOKEN,
653: p_token1_value => 'OKL_CONTRACT_ASSET_H');
654: RAISE OKL_API.G_EXCEPTION_ERROR;
655: END IF;
656: -- Versioning the Install Base information
657: Create_ib_version(p_api_version => p_api_version,

Line 856: -- More thought for Restore of OKL_CONTRACT_ASSET_H and

852: --End Bug# 4558486
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 );

Line 932: DELETE FROM OKL_CONTRACT_ASSET_H

928: -- Deleting the supplier Invoice Details
929: DELETE FROM OKL_SUPP_INVOICE_DTLS_H
930: WHERE cle_id in (select id from okc_k_lines_b where dnz_chr_id = p_chr_id);
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;

Line 1023: DELETE FROM OKL_CONTRACT_ASSET_H

1019: (p_called_from = 'RESTORE_VERSION'
1020: AND (major_version >= l_major_version OR
1021: major_version = -1)));
1022: -- Deleting the FA Version
1023: DELETE FROM OKL_CONTRACT_ASSET_H
1024: WHERE DNZ_CHR_ID = p_chr_id
1025: AND ((MAJOR_VERSION = -1
1026: AND p_called_from = 'ERASE_SAVED_VERSION') OR
1027: (p_called_from = 'RESTORE_VERSION'