APPS.OKL_COPY_CONTRACT_PVT dependencies on OKC_GOVERNANCES

Line 4159: --Description : Makes a copy of the okc_governances.

4155: --------------------------------------------------------------------------
4156: --Start of Comments
4157: --Bug # 2337570 - TEMPLATE COPY DOES NOT DEFAULT ALL FIELDS ON HEADER
4158: --Procedure Name : Copy_Governances
4159: --Description : Makes a copy of the okc_governances.
4160: -- Local Procedure in OKC_COPY_CONTRACT_PVT - repeated here as governances
4161: -- need to be copied in case of lease contracts. In core contracts
4162: -- governances are copied only if renew reference flag is set to 'Yes'
4163: --------------------------------------------------------------------------

Line 4179: FROM okc_governances_v

4175: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4176:
4177: CURSOR c_governances IS
4178: SELECT id
4179: FROM okc_governances_v
4180: WHERE dnz_chr_id = p_from_chr_id
4181: AND cle_id is null;
4182:
4183: ----------------------------------------------------------------------------

Line 4201: FROM OKC_GOVERNANCES

4197: CLE_ID,
4198: CHR_ID_REFERRED,
4199: CLE_ID_REFERRED,
4200: COPIED_ONLY_YN
4201: FROM OKC_GOVERNANCES
4202: WHERE ID = p_gve_id;
4203: BEGIN
4204: OPEN c_gvev_rec;
4205: FETCH c_gvev_rec

Line 5260: SELECT * FROM okc_governances

5256: SELECT * FROM okc_k_headers_b
5257: WHERE id=p_chr_id;
5258:
5259: CURSOR c2(p_chr_id NUMBER) IS
5260: SELECT * FROM okc_governances
5261: WHERE dnz_chr_id = p_chr_id;
5262:
5263: -- okc_governances_h is not needed
5264: /*

Line 5263: -- okc_governances_h is not needed

5259: CURSOR c2(p_chr_id NUMBER) IS
5260: SELECT * FROM okc_governances
5261: WHERE dnz_chr_id = p_chr_id;
5262:
5263: -- okc_governances_h is not needed
5264: /*
5265: cursor c3(p_chr_id number) is
5266: select * from okc_governances_h
5267: where dnz_chr_id = p_chr_id; */

Line 5266: select * from okc_governances_h

5262:
5263: -- okc_governances_h is not needed
5264: /*
5265: cursor c3(p_chr_id number) is
5266: select * from okc_governances_h
5267: where dnz_chr_id = p_chr_id; */
5268:
5269: CURSOR c4(p_chr_id NUMBER) IS
5270: SELECT

Line 20749: INSERT INTO okc_governances (

20745: LOOP
20746: BEGIN
20747: l_curr_pos := 'okl_copy_lease_contract:18';
20748: l_message := 'OKL_NEW_COPY_GVE_ERROR';
20749: INSERT INTO okc_governances (
20750: ID, DNZ_CHR_ID, CHR_ID,
20751: CLE_ID, CHR_ID_REFERRED, CLE_ID_REFERRED,
20752: ISA_AGREEMENT_ID, COPIED_ONLY_YN, OBJECT_VERSION_NUMBER,
20753: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,

Line 20765: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'ERROR during inser into okc_governances...');

20761: ) RETURNING ID INTO l_gov_id;
20762: EXCEPTION WHEN OTHERS THEN
20763: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
20764: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'sqlcode=' || SQLCODE || ':sqlerrm=' || SQLERRM);
20765: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'ERROR during inser into okc_governances...');
20766: END IF;
20767: RAISE OKC_API.G_EXCEPTION_ERROR;
20768: END;
20769:

Line 20774: /* AKP: We dont need okc_governances_h

20770: l_curr_pos := 'okl_copy_lease_contract:19';
20771: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
20772: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_gov_id=' || l_gov_id);
20773: END IF;
20774: /* AKP: We dont need okc_governances_h
20775: for c3rec in c3(p_chr_id)
20776: loop
20777: l_curr_pos := 'okl_copy_lease_contract:20';
20778: insert into okc_governances_h (

Line 20778: insert into okc_governances_h (

20774: /* AKP: We dont need okc_governances_h
20775: for c3rec in c3(p_chr_id)
20776: loop
20777: l_curr_pos := 'okl_copy_lease_contract:20';
20778: insert into okc_governances_h (
20779: ID, DNZ_CHR_ID, CHR_ID,
20780: CLE_ID, CHR_ID_REFERRED, CLE_ID_REFERRED,
20781: ISA_AGREEMENT_ID, MAJOR_VERSION, OBJECT_VERSION_NUMBER,
20782: COPIED_ONLY_YN, CREATED_BY, CREATION_DATE,