APPS.OKC_REP_CLOSEOUT_PVT dependencies on DUAL

Line 1562: SELECT okc_rep_import_run_id_s.NEXTVAL INTO l_run_id FROM dual;

1558: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1560: END IF;
1561:
1562: SELECT okc_rep_import_run_id_s.NEXTVAL INTO l_run_id FROM dual;
1563:
1564: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1565: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1566: 'l_run_id : '||l_run_id);

Line 2214: --create the contract for individual PO

2210: WHEN No_Data_Found THEN
2211: NULL;
2212: END;
2213:
2214: --create the contract for individual PO
2215:
2216: OKC_REP_CONTRACT_IMP_PVT.create_contract( p_api_version => p_api_version,
2217: p_document_rec => l_document_rec,
2218: p_contract_rec => p_contract_rec,

Line 2243: --copy the deliverables from source to target contract(i.e from mass closeout contract to individual PO contract)

2239: OPEN c_get_tgt_contract;
2240: FETCH c_get_tgt_contract INTO l_target_contract_id;
2241: CLOSE c_get_tgt_contract;
2242:
2243: --copy the deliverables from source to target contract(i.e from mass closeout contract to individual PO contract)
2244: copy_deliverables( p_api_version => 1.0,
2245: p_init_msg_list => FND_API.G_FALSE,
2246: p_commit => p_commit,
2247: p_source_contract_type => 'REP_CCC',

Line 2262: --update supplier information on the individual Po Del

2258: RAISE OKC_API.G_EXCEPTION_ERROR;
2259: END IF;
2260: --------------------------------------------------------
2261:
2262: --update supplier information on the individual Po Del
2263:
2264: UPDATE okc_deliverables set EXTERNAL_PARTY_ID =
2265: (SELECT PARTY_ID
2266: FROM okc_rep_contract_parties