APPS.IEM_DIAG_OES_RULE_PVT dependencies on DUAL

Line 166: select length(l_rule_name) into l_length from dual;

162: END IF;
163:
164: DBMS_SQL.COLUMN_VALUE(l_cursorID1, 1, l_rule_name);
165:
166: select length(l_rule_name) into l_length from dual;
167:
168: if (l_length < 35) then
169: statusStr := 'FAILURE';
170: l_invalidrule_accounts := l_invalidrule_accounts || l_account_rec.email_user || '@' || l_account_rec.domain || ', ';

Line 174: select substr(l_rule_name, 35) into l_rule_apps_name from dual;

170: l_invalidrule_accounts := l_invalidrule_accounts || l_account_rec.email_user || '@' || l_account_rec.domain || ', ';
171: fixInfo := FND_MESSAGE.GET_STRING('IEM', 'IEM_DIAG_HELP');
172: isFatal := 'FALSE';
173: else
174: select substr(l_rule_name, 35) into l_rule_apps_name from dual;
175:
176: if (l_rule_apps_name <> l_apps_link) then
177: statusStr := 'FAILURE';
178: l_invalidrule_accounts := l_invalidrule_accounts || l_account_rec.email_user || '@' || l_account_rec.domain || ', ';