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 799: SELECT SYSDATE INTO l_sysdate FROM DUAL;

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

Line 2074: SELECT SYSDATE INTO l_sysdate FROM dual;

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