DBA Data[Home] [Help]

APPS.OKL_AM_CONTRACT_PRTFL_PVT dependencies on DUAL

Line 110: SELECT SYSDATE INTO l_sysdate FROM DUAL;

106: RAISE OKL_API.G_EXCEPTION_ERROR;
107: END IF;
108:
109: -- SECHAWLA Bug # 2726739 : using sysdate as transaction date for currency conversion routines
110: SELECT SYSDATE INTO l_sysdate FROM DUAL;
111:
112: IF p_contract_id IS NULL OR p_contract_id = OKL_API.G_MISS_NUM THEN
113: x_return_status := OKL_API.G_RET_STS_ERROR;
114: -- Contarct ID is required

Line 1231: SELECT SYSDATE INTO l_sysdate FROM dual;

1227: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1228: RAISE OKL_API.G_EXCEPTION_ERROR;
1229: END IF;
1230:
1231: SELECT SYSDATE INTO l_sysdate FROM dual;
1232:
1233: l_total_count := 0;
1234: l_process_count := 0;
1235: