APPS.OKL_AM_REMARKET_ASSET_PVT dependencies on DUAL

Line 61: FROM DUAL;

57:
58: -- sequence for item_number
59: CURSOR l_seqnextval_csr IS
60: SELECT OKL_IMR_SEQ.NEXTVAL
61: FROM DUAL;
62:
63: l_Item_rec item_rec_type;
64: x_Item_rec item_rec_type;
65: l_commit VARCHAR2(1);

Line 797: SELECT SYSDATE INTO l_sysdate FROM DUAL;

793: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
794: RAISE OKL_API.G_EXCEPTION_ERROR;
795: END IF;
796:
797: SELECT SYSDATE INTO l_sysdate FROM DUAL;
798:
799: -- SECHAWLA 18-OCT-04 3924244 : Added the following validation
800: IF p_item_number IS NOT NULL THEN
801: OPEN l_mtlsystemitems_csr(p_item_number);

Line 2070: SELECT SYSDATE INTO l_sysdate FROM dual;

2066: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2067: RAISE OKL_API.G_EXCEPTION_ERROR;
2068: END IF;
2069:
2070: SELECT SYSDATE INTO l_sysdate FROM dual;
2071:
2072: -- SECHAWLA 21-OCT-04 3924244 : changed header id to line id
2073: IF p_order_line_Id IS NULL OR p_order_line_Id = OKL_API.G_MISS_NUM THEN
2074: x_return_status := OKL_API.G_RET_STS_ERROR;