APPS.OKC_REP_CONTRACT_PROCESS_PVT dependencies on DUAL

Line 85: SELECT OKC_REP_WF_S.nextval INTO l_wf_sequence FROM dual;

81: END IF;
82: -- Initialize API return status to success
83: x_return_status := FND_API.G_RET_STS_SUCCESS;
84:
85: SELECT OKC_REP_WF_S.nextval INTO l_wf_sequence FROM dual;
86: -- Get contract number
87: OPEN contract_csr;
88: FETCH contract_csr into l_contract_number,l_contract_type,l_org_id,l_contract_version;
89: IF(contract_csr%NOTFOUND) THEN

Line 2932: -- SELECT OKC_CONTRACT_RISKS_S.nextval INTO l_contract_risk_id FROM dual;

2928:
2929:
2930: FOR risk_rec IN risk_csr(contract_rec.contract_type, p_source_contract_id) LOOP
2931: -- Get the id column.
2932: -- SELECT OKC_CONTRACT_RISKS_S.nextval INTO l_contract_risk_id FROM dual;
2933:
2934: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2935: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2936: 'Contract Type is: ' || contract_rec.CONTRACT_TYPE);

Line 3974: SELECT 'Y' FROM DUAL

3970:
3971: contract_rec contract_csr%ROWTYPE;
3972: -- Repository Enhancement 12.1 (For Create New Version Action)
3973: CURSOR conterms_exist_csr is
3974: SELECT 'Y' FROM DUAL
3975: WHERE EXISTS (SELECT 'Y'
3976: FROM okc_template_usages
3977: WHERE DOCUMENT_ID = p_contract_id
3978: AND DOCUMENT_TYPE= contract_rec.contract_type);

Line 4998: SELECT OKC_REP_WF_SIGN_S.nextval INTO l_wf_sequence FROM dual;

4994: END IF;
4995: -- Initialize API return status to success
4996: x_return_status := FND_API.G_RET_STS_SUCCESS;
4997:
4998: SELECT OKC_REP_WF_SIGN_S.nextval INTO l_wf_sequence FROM dual;
4999: -- Get contract number
5000: OPEN contract_csr;
5001: FETCH contract_csr INTO contract_rec;
5002: IF(contract_csr%NOTFOUND) THEN

Line 5831: SELECT TO_CHAR(okc_wf_notify_s1.NEXTVAL) INTO l_item_key FROM DUAL;

5827: 'User names list ' || l_contract_contacts_all);
5828: END IF;
5829:
5830: --Get item key from sequence
5831: SELECT TO_CHAR(okc_wf_notify_s1.NEXTVAL) INTO l_item_key FROM DUAL;
5832:
5833: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5834: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5835: 'Calling WF_DIRECTORY.createAdHocRole()');

Line 7440: SELECT EGO_EXTFWK_S.NEXTVAL INTO l_extension_id_vers FROM dual;

7436: --No API's in EGO to copy data from one object to another.
7437: --insert data from okc_rep_contracts_all_ext_b table to okc_rep_contract_vers_ext_b
7438:
7439: FOR c_get_uda_attr_for_con_rec IN c_get_uda_attr_for_con LOOP
7440: SELECT EGO_EXTFWK_S.NEXTVAL INTO l_extension_id_vers FROM dual;
7441:
7442: INSERT INTO okc_rep_contracts_all_ext_b(EXTENSION_ID,
7443: ATTR_GROUP_ID,
7444: CONTRACT_TYPE,