DBA Data[Home] [Help]

APPS.OKL_SETUPPRODUCTS_PVT dependencies on DUAL

Line 997: FROM dual;

993:
994: -- Selects the nextval from sequence, used later for defining event key
995: CURSOR okl_key_csr IS
996: SELECT okl_wf_item_s.NEXTVAL
997: FROM dual;
998:
999: -- Get product Details
1000: CURSOR c_fetch_pdt_dtls(p_pdt_id OKl_products_V.ID%TYPE)
1001: IS

Line 1293: FROM dual;

1289: -- modification of where condn by dcshanmu for bug 5999276 starts
1290:
1291: CURSOR l_wf_item_key_csr IS
1292: SELECT okl_wf_item_s.NEXTVAL item_key
1293: FROM dual;
1294:
1295: l_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1296: l_api_version NUMBER := 1.0;
1297: l_api_name CONSTANT VARCHAR2(30) := 'set_additionalparameters';