APPS.OKL_AM_RESTRUCTURE_QUOTE_PVT dependencies on DUAL

Line 35: SELECT SYSDATE INTO l_db_date FROM DUAL;

31: WHERE K.id = p_khr_id;
32:
33: BEGIN
34: -- Get the sysdate
35: SELECT SYSDATE INTO l_db_date FROM DUAL;
36:
37: -- Set the date_effective_from if null
38: IF ((px_quot_rec.date_effective_from IS NULL) OR
39: (px_quot_rec.date_effective_from = OKL_API.G_MISS_DATE)) THEN

Line 737: SELECT SYSDATE INTO db_sysdate FROM DUAL;

733:
734: BEGIN
735:
736: -- Get the db_sys_date
737: SELECT SYSDATE INTO db_sysdate FROM DUAL;
738:
739: -- Get the DB values for the quote being updated
740: OPEN k_dets_csr(lp_quot_rec.id);
741: FETCH k_dets_csr INTO db_contract_id,

Line 1111: SELECT SYSDATE INTO l_sys_date FROM DUAL;

1107: RAISE OKL_API.G_EXCEPTION_ERROR;
1108: END IF;
1109:
1110: -- RMUNJULU 23-DEC-02 2726739 Added select
1111: SELECT SYSDATE INTO l_sys_date FROM DUAL;
1112:
1113: -- rmunjulu bug 3695751, default all date fields to NULL so that correct date is stamped.
1114: -- issue occurs when g_miss_date passed from rossetta layer does not match okl_api.g_miss_date
1115:

Line 1410: SELECT SYSDATE INTO db_sysdate FROM DUAL;

1406:
1407: -- initialize return variables
1408: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1409:
1410: SELECT SYSDATE INTO db_sysdate FROM DUAL;
1411:
1412: -- Check the values being updated
1413: validate_updated_quote(
1414: p_api_version => p_api_version,