DBA Data[Home] [Help]

APPS.OKL_SETUPPRODUCTS_PVT dependencies on OKL_WF_ITEM_S

Line 996: SELECT okl_wf_item_s.NEXTVAL

992: l_event_name VARCHAR2(240) := 'oracle.apps.okl.llap.productapprovalprocess';
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)

Line 1292: SELECT okl_wf_item_s.NEXTVAL item_key

1288: WHERE DESCRIPTION='OKL LP Product Approval Process';
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;