APPS.OKC_REP_CONTRACT_IMP_PVT dependencies on DUAL

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

194: -- Initialize API return status to success
195: x_return_status := FND_API.G_RET_STS_SUCCESS;
196:
197: IF p_create_contract = fnd_api.g_true THEN
198: SELECT okc_rep_import_run_id_s.NEXTVAL INTO l_run_id FROM dual;
199: END IF;
200:
201: --Call API to populate Header and controls
202: populate_contract_hdr(p_api_version => p_api_version,

Line 307: SELECT OKC_REP_IMP_CONTRACTS_T_S.NEXTVAL INTO x_imp_contract_id FROM dual;

303: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
305: END IF;
306:
307: SELECT OKC_REP_IMP_CONTRACTS_T_S.NEXTVAL INTO x_imp_contract_id FROM dual;
308:
309:
310: INSERT INTO okc_rep_imp_contracts_t(run_id,
311: imp_contract_id,

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

809: END IF;
810:
811: --create a run id sequence and populate the run_id column in all the interface tables
812:
813: SELECT okc_rep_import_run_id_s.NEXTVAL INTO l_run_id FROM dual;
814:
815: --stamp the request id column for the records that are being imported.
816: --update OKC_REP_IMP_CONTRACTS_T with the run_id and request_id generated
817: