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.XLA_CMP_EXTRACT_PKG dependencies on XLA_CMP_STRING_PKG

Line 5681: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_number$' ,nvl(TO_CHAR(l_source_num),' '));

5677: END IF;
5678:
5679: -- Bugfix 4417664 (replace REPLACE with replace_token)
5680:
5681: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_number$' ,nvl(TO_CHAR(l_source_num),' '));
5682: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$line_number$' ,nvl(TO_CHAR(l_line_number),' '));
5683: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$object_name$' ,nvl(l_object_name,' '));
5684: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$object_type_code$' ,nvl(l_object_type_code ,' '));
5685: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_application_id$',nvl(l_source_appl_id,' '));

Line 5682: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$line_number$' ,nvl(TO_CHAR(l_line_number),' '));

5678:
5679: -- Bugfix 4417664 (replace REPLACE with replace_token)
5680:
5681: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_number$' ,nvl(TO_CHAR(l_source_num),' '));
5682: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$line_number$' ,nvl(TO_CHAR(l_line_number),' '));
5683: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$object_name$' ,nvl(l_object_name,' '));
5684: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$object_type_code$' ,nvl(l_object_type_code ,' '));
5685: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_application_id$',nvl(l_source_appl_id,' '));
5686: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_type_code$' ,nvl(l_source_type_code,' '));

Line 5683: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$object_name$' ,nvl(l_object_name,' '));

5679: -- Bugfix 4417664 (replace REPLACE with replace_token)
5680:
5681: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_number$' ,nvl(TO_CHAR(l_source_num),' '));
5682: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$line_number$' ,nvl(TO_CHAR(l_line_number),' '));
5683: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$object_name$' ,nvl(l_object_name,' '));
5684: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$object_type_code$' ,nvl(l_object_type_code ,' '));
5685: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_application_id$',nvl(l_source_appl_id,' '));
5686: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_type_code$' ,nvl(l_source_type_code,' '));
5687: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_code$' ,nvl(l_source_code,' '));

Line 5684: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$object_type_code$' ,nvl(l_object_type_code ,' '));

5680:
5681: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_number$' ,nvl(TO_CHAR(l_source_num),' '));
5682: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$line_number$' ,nvl(TO_CHAR(l_line_number),' '));
5683: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$object_name$' ,nvl(l_object_name,' '));
5684: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$object_type_code$' ,nvl(l_object_type_code ,' '));
5685: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_application_id$',nvl(l_source_appl_id,' '));
5686: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_type_code$' ,nvl(l_source_type_code,' '));
5687: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_code$' ,nvl(l_source_code,' '));
5688: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_value$' ,nvl(l_source_value,' '));

Line 5685: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_application_id$',nvl(l_source_appl_id,' '));

5681: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_number$' ,nvl(TO_CHAR(l_source_num),' '));
5682: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$line_number$' ,nvl(TO_CHAR(l_line_number),' '));
5683: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$object_name$' ,nvl(l_object_name,' '));
5684: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$object_type_code$' ,nvl(l_object_type_code ,' '));
5685: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_application_id$',nvl(l_source_appl_id,' '));
5686: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_type_code$' ,nvl(l_source_type_code,' '));
5687: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_code$' ,nvl(l_source_code,' '));
5688: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_value$' ,nvl(l_source_value,' '));
5689: IF l_source_meaning IS NOT NULL THEN

Line 5686: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_type_code$' ,nvl(l_source_type_code,' '));

5682: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$line_number$' ,nvl(TO_CHAR(l_line_number),' '));
5683: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$object_name$' ,nvl(l_object_name,' '));
5684: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$object_type_code$' ,nvl(l_object_type_code ,' '));
5685: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_application_id$',nvl(l_source_appl_id,' '));
5686: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_type_code$' ,nvl(l_source_type_code,' '));
5687: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_code$' ,nvl(l_source_code,' '));
5688: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_value$' ,nvl(l_source_value,' '));
5689: IF l_source_meaning IS NOT NULL THEN
5690: --

Line 5687: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_code$' ,nvl(l_source_code,' '));

5683: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$object_name$' ,nvl(l_object_name,' '));
5684: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$object_type_code$' ,nvl(l_object_type_code ,' '));
5685: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_application_id$',nvl(l_source_appl_id,' '));
5686: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_type_code$' ,nvl(l_source_type_code,' '));
5687: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_code$' ,nvl(l_source_code,' '));
5688: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_value$' ,nvl(l_source_value,' '));
5689: IF l_source_meaning IS NOT NULL THEN
5690: --
5691: l_sql_statement := REPLACE(l_sql_statement,'$source_meaning$' ,C_MEANING_NOT_NULL);

Line 5688: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_value$' ,nvl(l_source_value,' '));

5684: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$object_type_code$' ,nvl(l_object_type_code ,' '));
5685: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_application_id$',nvl(l_source_appl_id,' '));
5686: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_type_code$' ,nvl(l_source_type_code,' '));
5687: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_code$' ,nvl(l_source_code,' '));
5688: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_value$' ,nvl(l_source_value,' '));
5689: IF l_source_meaning IS NOT NULL THEN
5690: --
5691: l_sql_statement := REPLACE(l_sql_statement,'$source_meaning$' ,C_MEANING_NOT_NULL);
5692: l_sql_statement := REPLACE(l_sql_statement,'$source_meaning$' ,nvl(l_source_meaning,' '));

Line 5694: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_meaning$' ,C_MEANING_NULL);

5690: --
5691: l_sql_statement := REPLACE(l_sql_statement,'$source_meaning$' ,C_MEANING_NOT_NULL);
5692: l_sql_statement := REPLACE(l_sql_statement,'$source_meaning$' ,nvl(l_source_meaning,' '));
5693: ELSE
5694: l_sql_statement := xla_cmp_string_pkg.replace_token(l_sql_statement,'$source_meaning$' ,C_MEANING_NULL);
5695: END IF;
5696:
5697: ELSE
5698: l_sql_statement :=' ';

Line 5854: l_sql_statement := xla_cmp_string_pkg.replace_token( l_sql_statement,'$hdr_tabs$',

5850: , p_procedure => p_procedure
5851: );
5852:
5853: -- Bugfix 4417664
5854: l_sql_statement := xla_cmp_string_pkg.replace_token( l_sql_statement,'$hdr_tabs$',
5855: nvl(GenerateFromHdrTabs (
5856: --
5857: p_array_table_name
5858: , p_array_parent_table_index

Line 5877: l_sql_statement := xla_cmp_string_pkg.replace_token( l_sql_statement,'$hdr_clauses$',

5873: ), ' ')
5874: );
5875:
5876:
5877: l_sql_statement := xla_cmp_string_pkg.replace_token( l_sql_statement,'$hdr_clauses$',
5878: nvl(GenerateHdrWhereClause (
5879: --
5880: p_array_table_name
5881: , p_array_parent_table_index

Line 6048: l_sql_statement := xla_cmp_string_pkg.replace_token( l_sql_statement,'$line_tabs$',

6044: , p_procedure => p_procedure
6045: );
6046:
6047: -- Bugfix 4417664
6048: l_sql_statement := xla_cmp_string_pkg.replace_token( l_sql_statement,'$line_tabs$',
6049: nvl(GenerateFromLineTabs (
6050: --
6051: p_array_table_name
6052: , p_array_parent_table_index

Line 6070: l_sql_statement := xla_cmp_string_pkg.replace_token( l_sql_statement,'$line_clauses$',

6066: , p_array_view_application_id
6067: ),' ')
6068: );
6069:
6070: l_sql_statement := xla_cmp_string_pkg.replace_token( l_sql_statement,'$line_clauses$',
6071: nvl(GenerateLineWhereClause (
6072: --
6073: p_array_table_name
6074: , p_array_parent_table_index