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.AME_ATTRIBUTE_USAGES_API dependencies on FND_GLOBAL

Line 192: if trim(strIn) is null or instrb(strIn,fnd_global.local_chr(32)||fnd_global.local_chr(32)) = 0 then

188: *******************************************************************************************/
189: procedure REMOVE_EXTRA_SPACES(strIn in out nocopy varchar2) is
190: begin
191: loop
192: if trim(strIn) is null or instrb(strIn,fnd_global.local_chr(32)||fnd_global.local_chr(32)) = 0 then
193: exit;
194: end if;
195: strIn:=replace (strIn,fnd_global.local_chr(32)||fnd_global.local_chr(32),fnd_global.local_chr(32));
196: end loop;

Line 195: strIn:=replace (strIn,fnd_global.local_chr(32)||fnd_global.local_chr(32),fnd_global.local_chr(32));

191: loop
192: if trim(strIn) is null or instrb(strIn,fnd_global.local_chr(32)||fnd_global.local_chr(32)) = 0 then
193: exit;
194: end if;
195: strIn:=replace (strIn,fnd_global.local_chr(32)||fnd_global.local_chr(32),fnd_global.local_chr(32));
196: end loop;
197: end REMOVE_EXTRA_SPACES;
198: procedure PRESERVE_LINE_ITEM_ID_LIST(
199: X_ATTRIBUTE_ID number,

Line 235: queryString := replace(queryString,fnd_global.local_chr(9),fnd_global.local_chr(32));

231: end if;
232: queryString :=X_QUERY_STRING_INOUT;
233: lineItemQuery :=X_LINE_ITEM_ID_QUERY;
234:
235: queryString := replace(queryString,fnd_global.local_chr(9),fnd_global.local_chr(32));
236: queryString := replace(queryString,fnd_global.local_chr(10),fnd_global.local_chr(32));
237: queryString := replace(queryString,fnd_global.local_chr(13),fnd_global.local_chr(32));
238: REMOVE_EXTRA_SPACES(queryString);
239: queryString := replace(queryString,'('||fnd_global.local_chr(32),'(');

Line 236: queryString := replace(queryString,fnd_global.local_chr(10),fnd_global.local_chr(32));

232: queryString :=X_QUERY_STRING_INOUT;
233: lineItemQuery :=X_LINE_ITEM_ID_QUERY;
234:
235: queryString := replace(queryString,fnd_global.local_chr(9),fnd_global.local_chr(32));
236: queryString := replace(queryString,fnd_global.local_chr(10),fnd_global.local_chr(32));
237: queryString := replace(queryString,fnd_global.local_chr(13),fnd_global.local_chr(32));
238: REMOVE_EXTRA_SPACES(queryString);
239: queryString := replace(queryString,'('||fnd_global.local_chr(32),'(');
240: queryString := replace(queryString,fnd_global.local_chr(32)||')',')');

Line 237: queryString := replace(queryString,fnd_global.local_chr(13),fnd_global.local_chr(32));

233: lineItemQuery :=X_LINE_ITEM_ID_QUERY;
234:
235: queryString := replace(queryString,fnd_global.local_chr(9),fnd_global.local_chr(32));
236: queryString := replace(queryString,fnd_global.local_chr(10),fnd_global.local_chr(32));
237: queryString := replace(queryString,fnd_global.local_chr(13),fnd_global.local_chr(32));
238: REMOVE_EXTRA_SPACES(queryString);
239: queryString := replace(queryString,'('||fnd_global.local_chr(32),'(');
240: queryString := replace(queryString,fnd_global.local_chr(32)||')',')');
241:

Line 239: queryString := replace(queryString,'('||fnd_global.local_chr(32),'(');

235: queryString := replace(queryString,fnd_global.local_chr(9),fnd_global.local_chr(32));
236: queryString := replace(queryString,fnd_global.local_chr(10),fnd_global.local_chr(32));
237: queryString := replace(queryString,fnd_global.local_chr(13),fnd_global.local_chr(32));
238: REMOVE_EXTRA_SPACES(queryString);
239: queryString := replace(queryString,'('||fnd_global.local_chr(32),'(');
240: queryString := replace(queryString,fnd_global.local_chr(32)||')',')');
241:
242: lineItemQuery := replace(lineItemQuery,fnd_global.local_chr(9),fnd_global.local_chr(32));
243: lineItemQuery := replace(lineItemQuery,fnd_global.local_chr(10),fnd_global.local_chr(32));

Line 240: queryString := replace(queryString,fnd_global.local_chr(32)||')',')');

236: queryString := replace(queryString,fnd_global.local_chr(10),fnd_global.local_chr(32));
237: queryString := replace(queryString,fnd_global.local_chr(13),fnd_global.local_chr(32));
238: REMOVE_EXTRA_SPACES(queryString);
239: queryString := replace(queryString,'('||fnd_global.local_chr(32),'(');
240: queryString := replace(queryString,fnd_global.local_chr(32)||')',')');
241:
242: lineItemQuery := replace(lineItemQuery,fnd_global.local_chr(9),fnd_global.local_chr(32));
243: lineItemQuery := replace(lineItemQuery,fnd_global.local_chr(10),fnd_global.local_chr(32));
244: lineItemQuery := replace(lineItemQuery,fnd_global.local_chr(13),fnd_global.local_chr(32));

Line 242: lineItemQuery := replace(lineItemQuery,fnd_global.local_chr(9),fnd_global.local_chr(32));

238: REMOVE_EXTRA_SPACES(queryString);
239: queryString := replace(queryString,'('||fnd_global.local_chr(32),'(');
240: queryString := replace(queryString,fnd_global.local_chr(32)||')',')');
241:
242: lineItemQuery := replace(lineItemQuery,fnd_global.local_chr(9),fnd_global.local_chr(32));
243: lineItemQuery := replace(lineItemQuery,fnd_global.local_chr(10),fnd_global.local_chr(32));
244: lineItemQuery := replace(lineItemQuery,fnd_global.local_chr(13),fnd_global.local_chr(32));
245: REMOVE_EXTRA_SPACES(lineItemQuery);
246: --remove leading and trailing spaces from lineItemQuery

Line 243: lineItemQuery := replace(lineItemQuery,fnd_global.local_chr(10),fnd_global.local_chr(32));

239: queryString := replace(queryString,'('||fnd_global.local_chr(32),'(');
240: queryString := replace(queryString,fnd_global.local_chr(32)||')',')');
241:
242: lineItemQuery := replace(lineItemQuery,fnd_global.local_chr(9),fnd_global.local_chr(32));
243: lineItemQuery := replace(lineItemQuery,fnd_global.local_chr(10),fnd_global.local_chr(32));
244: lineItemQuery := replace(lineItemQuery,fnd_global.local_chr(13),fnd_global.local_chr(32));
245: REMOVE_EXTRA_SPACES(lineItemQuery);
246: --remove leading and trailing spaces from lineItemQuery
247: lineItemQuery := trim(lineItemQuery);

Line 244: lineItemQuery := replace(lineItemQuery,fnd_global.local_chr(13),fnd_global.local_chr(32));

240: queryString := replace(queryString,fnd_global.local_chr(32)||')',')');
241:
242: lineItemQuery := replace(lineItemQuery,fnd_global.local_chr(9),fnd_global.local_chr(32));
243: lineItemQuery := replace(lineItemQuery,fnd_global.local_chr(10),fnd_global.local_chr(32));
244: lineItemQuery := replace(lineItemQuery,fnd_global.local_chr(13),fnd_global.local_chr(32));
245: REMOVE_EXTRA_SPACES(lineItemQuery);
246: --remove leading and trailing spaces from lineItemQuery
247: lineItemQuery := trim(lineItemQuery);
248:

Line 569: X_TEMP_LINE_QUERY := replace(X_TEMP_LINE_QUERY, fnd_global.local_chr(9), fnd_global.local_chr(32));

565: if X_ORDER_BY_POSITION > 0 then
566: X_LINE_ITEM_QUERY := substrb(X_LINE_ITEM_ID_QUERY,1, X_ORDER_BY_POSITION-1);
567: elsif X_ORDER_POSITION > 0 and X_BY_POSITION > 0 then
568: -- Replace the blank space with tab space
569: X_TEMP_LINE_QUERY := replace(X_TEMP_LINE_QUERY, fnd_global.local_chr(9), fnd_global.local_chr(32));
570: -- Replace the blank space with new-line
571: X_TEMP_LINE_QUERY := replace(X_TEMP_LINE_QUERY, fnd_global.local_chr(10), fnd_global.local_chr(32));
572: -- Replace the blank space with carraige-return
573: X_TEMP_LINE_QUERY := replace(X_TEMP_LINE_QUERY, fnd_global.local_chr(13), fnd_global.local_chr(32));

Line 571: X_TEMP_LINE_QUERY := replace(X_TEMP_LINE_QUERY, fnd_global.local_chr(10), fnd_global.local_chr(32));

567: elsif X_ORDER_POSITION > 0 and X_BY_POSITION > 0 then
568: -- Replace the blank space with tab space
569: X_TEMP_LINE_QUERY := replace(X_TEMP_LINE_QUERY, fnd_global.local_chr(9), fnd_global.local_chr(32));
570: -- Replace the blank space with new-line
571: X_TEMP_LINE_QUERY := replace(X_TEMP_LINE_QUERY, fnd_global.local_chr(10), fnd_global.local_chr(32));
572: -- Replace the blank space with carraige-return
573: X_TEMP_LINE_QUERY := replace(X_TEMP_LINE_QUERY, fnd_global.local_chr(13), fnd_global.local_chr(32));
574: -- Extract the characters between order and by
575: X_TEMP_LINE_QUERY := substrb(X_TEMP_LINE_QUERY, X_ORDER_POSITION+5, X_BY_POSITION - (X_ORDER_POSITION+5));

Line 573: X_TEMP_LINE_QUERY := replace(X_TEMP_LINE_QUERY, fnd_global.local_chr(13), fnd_global.local_chr(32));

569: X_TEMP_LINE_QUERY := replace(X_TEMP_LINE_QUERY, fnd_global.local_chr(9), fnd_global.local_chr(32));
570: -- Replace the blank space with new-line
571: X_TEMP_LINE_QUERY := replace(X_TEMP_LINE_QUERY, fnd_global.local_chr(10), fnd_global.local_chr(32));
572: -- Replace the blank space with carraige-return
573: X_TEMP_LINE_QUERY := replace(X_TEMP_LINE_QUERY, fnd_global.local_chr(13), fnd_global.local_chr(32));
574: -- Extract the characters between order and by
575: X_TEMP_LINE_QUERY := substrb(X_TEMP_LINE_QUERY, X_ORDER_POSITION+5, X_BY_POSITION - (X_ORDER_POSITION+5));
576: if trim(X_TEMP_LINE_QUERY) is null then
577: X_LINE_ITEM_QUERY := substrb(X_LINE_ITEM_ID_QUERY, 1, X_ORDER_POSITION -1);