APPS.OKC_CNL_PVT dependencies on DUAL

Line 1743: from dual;

1739: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1740:
1741: -- verify that data is within allowable values '(' or ')'
1742: select replace(p_cnlv_rec.left_parenthesis,'(',null) into l_value
1743: from dual;
1744:
1745: IF l_value is not null THEN
1746: select replace(l_value,')',null) into l_value
1747: from dual;

Line 1747: from dual;

1743: from dual;
1744:
1745: IF l_value is not null THEN
1746: select replace(l_value,')',null) into l_value
1747: from dual;
1748: IF l_value is null THEN
1749: raise no_data_found;
1750: ELSE
1751: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 1811: from dual;

1807: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1808:
1809: -- verify that data is within allowable values
1810: select replace(p_cnlv_rec.right_parenthesis,')',null) into l_value
1811: from dual;
1812: IF l_value is not null THEN
1813: select replace(l_value,')',null) into l_value
1814: from dual;
1815: IF l_value is null THEN

Line 1814: from dual;

1810: select replace(p_cnlv_rec.right_parenthesis,')',null) into l_value
1811: from dual;
1812: IF l_value is not null THEN
1813: select replace(l_value,')',null) into l_value
1814: from dual;
1815: IF l_value is null THEN
1816: raise no_data_found;
1817: ELSE
1818: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 1941: select to_char(p_cnlv_rec.right_operand,l_format) from dual;

1937: where aae.id = p_cnlv_rec.aae_id;
1938: IF no_data_found THEN
1939: null;
1940: ELSE
1941: select to_char(p_cnlv_rec.right_operand,l_format) from dual;
1942: IF inconsistent_datatypes THEN
1943: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
1944: p_msg_name => g_invalid_value,
1945: p_token1 => g_col_name_token,

Line 3435: SELECT OKC_CONDITION_LINES_S1.nextval INTO l_id FROM dual;

3431: l_cnlv_rec := null_out_defaults(p_cnlv_rec);
3432: -- Set primary key value
3433: -- IF condition line is created by seed then use sequence generated id
3434: IF l_cnlv_rec.CREATED_BY = 1 THEN
3435: SELECT OKC_CONDITION_LINES_S1.nextval INTO l_id FROM dual;
3436: l_cnlv_rec.ID := l_id;
3437: l_cnlv_rec.seeded_flag := 'Y';
3438: ELSE
3439: l_cnlv_rec.ID := get_seq_id;