APPS.OKC_REP_CONTRACT_PROCESS_PVT dependencies on DUAL

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

72: END IF;
73: -- Initialize API return status to success
74: x_return_status := FND_API.G_RET_STS_SUCCESS;
75:
76: SELECT OKC_REP_WF_S.nextval INTO l_wf_sequence FROM dual;
77: -- Get contract number
78: OPEN contract_csr;
79: FETCH contract_csr into l_contract_number;
80: IF(contract_csr%NOTFOUND) THEN

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

2758:
2759:
2760: FOR risk_rec IN risk_csr(contract_rec.contract_type, p_source_contract_id) LOOP
2761: -- Get the id column.
2762: -- SELECT OKC_CONTRACT_RISKS_S.nextval INTO l_contract_risk_id FROM dual;
2763:
2764: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2765: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2766: 'Contract Type is: ' || contract_rec.CONTRACT_TYPE);

Line 3531: SELECT 'Y' FROM DUAL

3527:
3528: contract_rec contract_csr%ROWTYPE;
3529: -- Repository Enhancement 12.1 (For Create New Version Action)
3530: CURSOR conterms_exist_csr is
3531: SELECT 'Y' FROM DUAL
3532: WHERE EXISTS (SELECT 'Y'
3533: FROM okc_template_usages
3534: WHERE DOCUMENT_ID = p_contract_id
3535: AND DOCUMENT_TYPE= contract_rec.contract_type);

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

4908: 'User names list ' || l_contract_contacts_all);
4909: END IF;
4910:
4911: --Get item key from sequence
4912: SELECT TO_CHAR(okc_wf_notify_s1.NEXTVAL) INTO l_item_key FROM DUAL;
4913:
4914: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4915: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4916: 'Calling WF_DIRECTORY.createAdHocRole()');