APPS.GMD_UTILITY_PKG dependencies on DUAL

Line 55: SELECT MOD(q_count,2) into x_result from sys.dual;

51: END IF;
52: END LOOP;
53:
54: IF q_count > 0 THEN
55: SELECT MOD(q_count,2) into x_result from sys.dual;
56: IF x_result > 0 THEN
57: FND_MESSAGE.SET_NAME('GMD','GMD_INVALID_OPERANDS');
58: FND_MSG_PUB.ADD;
59: x_return_status := FND_API.G_RET_STS_ERROR;

Line 201: stmt_str := 'SELECT '||replace(pexp,substr(format_profile,0,1),'.')||' from dual ';

197: --RLNAGARA Bug 5006158
198:
199: format_profile := FND_PROFILE.VALUE('ICX_NUMERIC_CHARACTERS');
200: IF substr(format_profile,0,1) <> '.' THEN
201: stmt_str := 'SELECT '||replace(pexp,substr(format_profile,0,1),'.')||' from dual ';
202: ELSE
203: stmt_str := 'SELECT '||pexp||' from dual ';
204: END IF;
205:

Line 203: stmt_str := 'SELECT '||pexp||' from dual ';

199: format_profile := FND_PROFILE.VALUE('ICX_NUMERIC_CHARACTERS');
200: IF substr(format_profile,0,1) <> '.' THEN
201: stmt_str := 'SELECT '||replace(pexp,substr(format_profile,0,1),'.')||' from dual ';
202: ELSE
203: stmt_str := 'SELECT '||pexp||' from dual ';
204: END IF;
205:
206: --RLNAGARA Bug5006158
207: