APPS.OKC_REP_CONTRACT_PROCESS_PVT dependencies on OKC_REP_CONTRACT_VERS

Line 1620: FROM okc_rep_contract_vers

1616: WHERE contract_id = p_contract_id;
1617:
1618: CURSOR prev_con_vers_status (p_contract_id IN NUMBER, p_con_version IN NUMBER) IS
1619: SELECT contract_status_code
1620: FROM okc_rep_contract_vers
1621: WHERE contract_id = p_contract_id
1622: AND contract_version_num = p_con_version - 1;
1623:
1624: contract_rec contract_csr%ROWTYPE;

Line 2223: FROM OKC_REP_CONTRACT_VERS

2219: CONTRACT_LAST_UPDATED_BY,
2220: CONTRACT_LAST_UPDATE_DATE,
2221: REFERENCE_DOCUMENT_TYPE,
2222: REFERENCE_DOCUMENT_NUMBER
2223: FROM OKC_REP_CONTRACT_VERS
2224: WHERE contract_id = p_contract_id
2225: AND contract_version_num = l_prev_version;
2226:
2227: -- Also, we need to delete this history table record that has been copied to

Line 2229: DELETE FROM OKC_REP_CONTRACT_VERS

2225: AND contract_version_num = l_prev_version;
2226:
2227: -- Also, we need to delete this history table record that has been copied to
2228: -- the main table
2229: DELETE FROM OKC_REP_CONTRACT_VERS
2230: WHERE contract_id = p_contract_id
2231: AND contract_version_num = l_prev_version;
2232: END IF; -- (contract_rec.contract_version_num > 1)
2233:

Line 3588: 'Populating contract header record in OKC_REP_CONTRACT_VERS');

3584: -----------------------------------------------------
3585:
3586: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3587: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3588: 'Populating contract header record in OKC_REP_CONTRACT_VERS');
3589: END IF;
3590: -- Copy the header record to versions table
3591: INSERT INTO OKC_REP_CONTRACT_VERS(
3592: CONTRACT_ID,

Line 3591: INSERT INTO OKC_REP_CONTRACT_VERS(

3587: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3588: 'Populating contract header record in OKC_REP_CONTRACT_VERS');
3589: END IF;
3590: -- Copy the header record to versions table
3591: INSERT INTO OKC_REP_CONTRACT_VERS(
3592: CONTRACT_ID,
3593: CONTRACT_VERSION_NUM,
3594: CONTRACT_NUMBER,
3595: CONTRACT_TYPE,

Line 4023: FROM OKC_REP_CONTRACT_VERS

4019: WHERE contract_id = p_contract_id;
4020:
4021: CURSOR arch_contract_csr (l_contract_version NUMBER) IS
4022: SELECT contract_effective_date, contract_expiration_date
4023: FROM OKC_REP_CONTRACT_VERS
4024: WHERE contract_id = p_contract_id
4025: AND contract_version_num = l_contract_version;
4026:
4027: contract_rec contract_csr%ROWTYPE;

Line 5022: 'Updating okc_rep_contracts_all and okc_rep_contract_vers with wf_exp_ntf_item_key ' || l_item_key);

5018: itemkey => l_item_key);
5019:
5020: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5021: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5022: 'Updating okc_rep_contracts_all and okc_rep_contract_vers with wf_exp_ntf_item_key ' || l_item_key);
5023: END IF;
5024:
5025: --update contracts with sent notifications
5026: UPDATE okc_rep_contracts_all c

Line 5032: UPDATE okc_rep_contract_vers c

5028: WHERE c.contract_id = p_contract_id
5029: AND c.contract_version_num = p_contract_version;
5030:
5031: --update contract versions with sent notifications
5032: UPDATE okc_rep_contract_vers c
5033: SET c.wf_exp_ntf_item_key = l_item_key
5034: WHERE c.contract_id = p_contract_id
5035: AND c.contract_version_num = p_contract_version;
5036: