APPS.OKL_COPY_CONTRACT_PVT dependencies on OKC_GOVERNANCES

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

4221: --------------------------------------------------------------------------
4222: --Start of Comments
4223: --Bug # 2337570 - TEMPLATE COPY DOES NOT DEFAULT ALL FIELDS ON HEADER
4224: --Procedure Name : Copy_Governances
4225: --Description : Makes a copy of the okc_governances.
4226: -- Local Procedure in OKC_COPY_CONTRACT_PVT - repeated here as governances
4227: -- need to be copied in case of lease contracts. In core contracts
4228: -- governances are copied only if renew reference flag is set to 'Yes'
4229: --------------------------------------------------------------------------

Line 4245: FROM okc_governances_v

4241: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
4242:
4243: CURSOR c_governances IS
4244: SELECT id
4245: FROM okc_governances_v
4246: WHERE dnz_chr_id = p_from_chr_id
4247: AND cle_id is null;
4248:
4249: ----------------------------------------------------------------------------

Line 4267: FROM OKC_GOVERNANCES

4263: CLE_ID,
4264: CHR_ID_REFERRED,
4265: CLE_ID_REFERRED,
4266: COPIED_ONLY_YN
4267: FROM OKC_GOVERNANCES
4268: WHERE ID = p_gve_id;
4269: BEGIN
4270: OPEN c_gvev_rec;
4271: FETCH c_gvev_rec

Line 5336: SELECT * FROM okc_governances

5332: SELECT * FROM okc_k_headers_b
5333: WHERE id=p_chr_id;
5334:
5335: CURSOR c2(p_chr_id NUMBER) IS
5336: SELECT * FROM okc_governances
5337: WHERE dnz_chr_id = p_chr_id;
5338:
5339: -- okc_governances_h is not needed
5340: /*

Line 5339: -- okc_governances_h is not needed

5335: CURSOR c2(p_chr_id NUMBER) IS
5336: SELECT * FROM okc_governances
5337: WHERE dnz_chr_id = p_chr_id;
5338:
5339: -- okc_governances_h is not needed
5340: /*
5341: cursor c3(p_chr_id number) is
5342: select * from okc_governances_h
5343: where dnz_chr_id = p_chr_id; */

Line 5342: select * from okc_governances_h

5338:
5339: -- okc_governances_h is not needed
5340: /*
5341: cursor c3(p_chr_id number) is
5342: select * from okc_governances_h
5343: where dnz_chr_id = p_chr_id; */
5344:
5345: CURSOR c4(p_chr_id NUMBER) IS
5346: SELECT

Line 20927: INSERT INTO okc_governances (

20923: LOOP
20924: BEGIN
20925: l_curr_pos := 'okl_copy_lease_contract:18';
20926: l_message := 'OKL_NEW_COPY_GVE_ERROR';
20927: INSERT INTO okc_governances (
20928: ID, DNZ_CHR_ID, CHR_ID,
20929: CLE_ID, CHR_ID_REFERRED, CLE_ID_REFERRED,
20930: ISA_AGREEMENT_ID, COPIED_ONLY_YN, OBJECT_VERSION_NUMBER,
20931: CREATED_BY, CREATION_DATE, LAST_UPDATED_BY,

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

20939: ) RETURNING ID INTO l_gov_id;
20940: EXCEPTION WHEN OTHERS THEN
20941: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
20942: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'sqlcode=' || SQLCODE || ':sqlerrm=' || SQLERRM);
20943: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'ERROR during inser into okc_governances...');
20944: END IF;
20945: RAISE OKC_API.G_EXCEPTION_ERROR;
20946: END;
20947:

Line 20952: /* AKP: We dont need okc_governances_h

20948: l_curr_pos := 'okl_copy_lease_contract:19';
20949: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
20950: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_gov_id=' || l_gov_id);
20951: END IF;
20952: /* AKP: We dont need okc_governances_h
20953: for c3rec in c3(p_chr_id)
20954: loop
20955: l_curr_pos := 'okl_copy_lease_contract:20';
20956: insert into okc_governances_h (

Line 20956: insert into okc_governances_h (

20952: /* AKP: We dont need okc_governances_h
20953: for c3rec in c3(p_chr_id)
20954: loop
20955: l_curr_pos := 'okl_copy_lease_contract:20';
20956: insert into okc_governances_h (
20957: ID, DNZ_CHR_ID, CHR_ID,
20958: CLE_ID, CHR_ID_REFERRED, CLE_ID_REFERRED,
20959: ISA_AGREEMENT_ID, MAJOR_VERSION, OBJECT_VERSION_NUMBER,
20960: COPIED_ONLY_YN, CREATED_BY, CREATION_DATE,