eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_DISCOVERERSQL_PVT dependencies on FND_API

Line 192: -- 2. x_found will return FND_API.G_TRUE if the string has been found.

188: -- PURPOSE
189: -- 1. Will search for the p_search_string variable in the set of strings which compose a workbook
190: -- SQL statement and are stored in the AMS_DISCOVERER_SQL table.
191:
192: -- 2. x_found will return FND_API.G_TRUE if the string has been found.
193:
194: -- 3. x_found_in_str returns the number of the sql string in which the search string was found.
195: -- each SQL string is 2000 characters in length.
196:

Line 256: --set to FND_API.G_TRUE when the first character of the searched for string has been found.

252:
253: --the length of the sub string.
254: l_substr_len number :=0;
255:
256: --set to FND_API.G_TRUE when the first character of the searched for string has been found.
257: l_first_char_found varchar2(1);
258:
259:
260: --the first character being searched for.

Line 290: x_found := FND_API.G_FALSE;

286: l_search_str_len := length(p_search_string);
287: l_search_sub_str := substr(p_search_string,2,l_search_str_len);
288:
289:
290: x_found := FND_API.G_FALSE;
291:
292: --getting the total number of strings that compose the sql statement.
293: Select Count(*)
294: into l_str_count

Line 300: x_found := FND_API.G_FALSE;

296: Where Workbook_name = p_workbook_name
297: And Worksheet_name = p_worksheet_name;
298:
299: if(l_str_count = 0)then
300: x_found := FND_API.G_FALSE;
301: RETURN;
302: end if;
303:
304:

Line 341: l_last_fetch := FND_API.G_TRUE;

337: --out of the fetch string loop.
338: if(l_total_str_len >= p_max_search_len)then
339:
340:
341: l_last_fetch := FND_API.G_TRUE;
342: l_tmp_str := substr(l_sql_table(l_iterator + 1),1,p_max_search_len - 1);
343:
344:
345: l_sql_table(l_iterator + 1) := NULL;

Line 353: if(l_first_char_found = FND_API.G_TRUE)then

349:
350:
351: --If First character of search string has been found in the previous string but
352: --the remainder of previous string is too short to contain the rest of the search string.
353: if(l_first_char_found = FND_API.G_TRUE)then
354:
355: --getting the substring length.
356: l_substr_len := length(l_substr);
357:

Line 365: x_found := FND_API.G_TRUE;

361:
362: if( l_substr||substr(l_sql_table(l_iterator + 1),1,((l_search_str_len-1)-nvl(l_substr_len,0)) ) = l_search_sub_str)then
363:
364:
365: x_found := FND_API.G_TRUE;
366: x_overflow := (l_search_str_len-1)- l_substr_len;
367:
368:
369: exit l_fetch_string;

Line 372: x_found := FND_API.G_FALSE;

368:
369: exit l_fetch_string;
370: else
371:
372: x_found := FND_API.G_FALSE;
373: --calculating the new search position.
374: l_str_pos := l_str_pos + 1;
375:
376:

Line 406: l_first_char_found := FND_API.G_TRUE;

402: --setting current position in sql string.
403: l_str_pos := l_first_char_pos;
404:
405: --indicating that the first character of the searched for string has been found.
406: l_first_char_found := FND_API.G_TRUE;
407:
408:
409: if(l_str_count = 1) then
410: x_found_in_str := l_iterator;

Line 419: x_found := FND_API.G_TRUE;

415:
416: x_position := l_first_char_pos;
417:
418: if(l_search_str_len = 1 )then
419: x_found := FND_API.G_TRUE;
420: exit l_search_string;
421: --there are enough characters left in the current string to find a match.
422: elsif ( (l_str_len - (l_str_pos + 1)) >= (l_search_str_len - 1) )then
423:

Line 431: x_found := FND_API.G_TRUE;

427:
428: --match has been found.
429: if(l_substr = l_search_sub_str )then
430:
431: x_found := FND_API.G_TRUE;
432: exit l_search_string;
433:
434: --no match found, update string search position.
435: else

Line 436: x_found := FND_API.G_FALSE;

432: exit l_search_string;
433:
434: --no match found, update string search position.
435: else
436: x_found := FND_API.G_FALSE;
437: l_str_pos := l_str_pos + 1;
438: end if;
439:
440: --not enough characters remaining in current sql string to perform a match.

Line 456: l_first_char_found := FND_API.G_FALSE;

452: --l_first_char has not been been found in the current string.
453:
454:
455: --indicating that the first character of the searched for string has not been found.
456: l_first_char_found := FND_API.G_FALSE;
457:
458: --indicating that the search string has not been found;
459: x_found := FND_API.G_FALSE;
460:

Line 459: x_found := FND_API.G_FALSE;

455: --indicating that the first character of the searched for string has not been found.
456: l_first_char_found := FND_API.G_FALSE;
457:
458: --indicating that the search string has not been found;
459: x_found := FND_API.G_FALSE;
460:
461: --exit the search string loop and fetch another sql string.
462: exit l_search_string;
463: end if;

Line 470: If(x_found = FND_API.G_TRUE or l_last_fetch = FND_API.G_TRUE )then

466: End Loop l_search_string;--Searching the current strings.
467:
468: --the string has been found , no need to fetch any more sql strings.
469: --OR the max. number of characters have been read.
470: If(x_found = FND_API.G_TRUE or l_last_fetch = FND_API.G_TRUE )then
471:
472: exit l_fetch_string;
473: end If;
474:

Line 538: EXIT WHEN c_master_types%NOTFOUND OR l_found = FND_API.G_TRUE;

534: x_position => l_position,
535: x_overflow => l_overflow
536: );
537:
538: EXIT WHEN c_master_types%NOTFOUND OR l_found = FND_API.G_TRUE;
539: END LOOP;
540: CLOSE c_master_types;
541:
542: x_source_type_code := l_source_type_code;