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_TAD_PKG dependencies on XLA_CMP_STRING_PKG

Line 1718: l_tmpl_where_segment_null_and := xla_cmp_string_pkg.replace_token

1714: --Build the common token values
1715: FOR i IN p_table_segment_column_names.FIRST..p_table_segment_column_names.LAST
1716: LOOP
1717: --C_TMPL_WHERE_SEGMENT_NULL_ANDS
1718: l_tmpl_where_segment_null_and := xla_cmp_string_pkg.replace_token
1719: ( ''
1720: AND gt.$SEGMENT_COLUMN_NAME$ IS NULL ''
1721: ,''$SEGMENT_COLUMN_NAME$''
1722: ,p_table_segment_column_names(i)

Line 1735: xla_cmp_string_pkg.replace_token

1731: WHEN 1 THEN '' ''
1732: ELSE '' OR ''
1733: END
1734: ||
1735: xla_cmp_string_pkg.replace_token
1736: ( '' gt.$SEGMENT_COLUMN_NAME$ IS NULL
1737: ''
1738: ,''$SEGMENT_COLUMN_NAME$''
1739: ,p_table_segment_column_names(i)

Line 1751: xla_cmp_string_pkg.replace_token

1747: WHEN 1 THEN '' ''
1748: ELSE '' ,''
1749: END
1750: ||
1751: xla_cmp_string_pkg.replace_token
1752: ( '' gt.$SEGMENT_COLUMN_NAME$
1753: ''
1754: ,''$SEGMENT_COLUMN_NAME$''
1755: ,p_table_segment_column_names(i)

Line 1767: xla_cmp_string_pkg.replace_token

1763: WHEN 1 THEN '' ''
1764: ELSE '' ,''
1765: END
1766: ||
1767: xla_cmp_string_pkg.replace_token
1768: ( '' NVL(gt.$SEGMENT_COLUMN_NAME$, gcc.$SEGMENT_COLUMN_NAME$)
1769: ''
1770: ,''$SEGMENT_COLUMN_NAME$''
1771: ,p_table_segment_column_names(i)

Line 1778: l_tmpl_where_segments_equal := xla_cmp_string_pkg.replace_token

1774: l_tmpl_sel_nvl_segment_commas := l_tmpl_sel_nvl_segment_commas
1775: || l_tmpl_sel_nvl_segment_comma;
1776:
1777: --C_TMPL_WHERE_SEGMENTS_EQUAL
1778: l_tmpl_where_segments_equal := xla_cmp_string_pkg.replace_token
1779: ( '' AND gcc.$SEGMENT_COLUMN_NAME$ = gt.$SEGMENT_COLUMN_NAME$
1780: ''
1781: ,''$SEGMENT_COLUMN_NAME$''
1782: ,p_table_segment_column_names(i)

Line 1863: l_update_statement_text:= xla_cmp_string_pkg.replace_token(

1859: --Get the update statement template
1860: l_update_statement_text := g_batch_build_ccid_stmts;
1861:
1862: --Replace the table name token
1863: l_update_statement_text:= xla_cmp_string_pkg.replace_token(
1864: l_update_statement_text
1865: ,''$TABLE_NAME$''
1866: ,NVL(l_current_temp_table_name, '' '')
1867: );

Line 1870: l_update_statement_text:= xla_cmp_string_pkg.replace_token(

1866: ,NVL(l_current_temp_table_name, '' '')
1867: );
1868:
1869: --Replace the common tokens
1870: l_update_statement_text:= xla_cmp_string_pkg.replace_token(
1871: l_update_statement_text
1872: ,''$C_TMPL_WHERE_SEGMENT_NULL_ANDS$''
1873: ,NVL(l_tmpl_where_segment_null_ands, '' '')
1874: );

Line 1876: l_update_statement_text:= xla_cmp_string_pkg.replace_token(

1872: ,''$C_TMPL_WHERE_SEGMENT_NULL_ANDS$''
1873: ,NVL(l_tmpl_where_segment_null_ands, '' '')
1874: );
1875:
1876: l_update_statement_text:= xla_cmp_string_pkg.replace_token(
1877: l_update_statement_text
1878: ,''$C_TMPL_WHERE_SEGMENT_NULL_ORS$''
1879: ,NVL(l_tmpl_where_segment_null_ors, '' '')
1880: );

Line 1882: l_update_statement_text:= xla_cmp_string_pkg.replace_token(

1878: ,''$C_TMPL_WHERE_SEGMENT_NULL_ORS$''
1879: ,NVL(l_tmpl_where_segment_null_ors, '' '')
1880: );
1881:
1882: l_update_statement_text:= xla_cmp_string_pkg.replace_token(
1883: l_update_statement_text
1884: ,''$C_TMPL_UPD_SET_SEGMENT_COMMAS$''
1885: ,NVL(l_tmpl_upd_set_segment_commas, '' '')
1886: );

Line 1888: l_update_statement_text:= xla_cmp_string_pkg.replace_token(

1884: ,''$C_TMPL_UPD_SET_SEGMENT_COMMAS$''
1885: ,NVL(l_tmpl_upd_set_segment_commas, '' '')
1886: );
1887:
1888: l_update_statement_text:= xla_cmp_string_pkg.replace_token(
1889: l_update_statement_text
1890: ,''$C_TMPL_SEL_NVL_SEGMENT_COMMAS$''
1891: ,NVL(l_tmpl_sel_nvl_segment_commas, '' '')
1892: );

Line 1894: l_update_statement_text:= xla_cmp_string_pkg.replace_token(

1890: ,''$C_TMPL_SEL_NVL_SEGMENT_COMMAS$''
1891: ,NVL(l_tmpl_sel_nvl_segment_commas, '' '')
1892: );
1893:
1894: l_update_statement_text:= xla_cmp_string_pkg.replace_token(
1895: l_update_statement_text
1896: ,''$C_TMPL_WHERE_SEGMENTS_EQUALS$''
1897: ,NVL(l_tmpl_where_segments_equals, '' '')
1898: );

Line 1900: l_update_statement_text:= xla_cmp_string_pkg.replace_token(

1896: ,''$C_TMPL_WHERE_SEGMENTS_EQUALS$''
1897: ,NVL(l_tmpl_where_segments_equals, '' '')
1898: );
1899:
1900: l_update_statement_text:= xla_cmp_string_pkg.replace_token(
1901: l_update_statement_text
1902: ,''$C_TMPL_CONCAT_SEGMENTS$''
1903: ,NVL(l_tmpl_concat_segments, '' '')
1904: );

Line 1954: l_update_stmts_wrapper_text:= xla_cmp_string_pkg.replace_token(

1950:
1951: '';
1952:
1953: --Replace the p_chart_of_accounts_id with :1
1954: l_update_stmts_wrapper_text:= xla_cmp_string_pkg.replace_token(
1955: l_update_stmts_wrapper_text
1956: ,''$TRANSACTION_COA_ID$''
1957: ,TO_CHAR(p_chart_of_accounts_id)
1958: );

Line 1959: l_update_stmts_wrapper_text:= xla_cmp_string_pkg.replace_token(

1955: l_update_stmts_wrapper_text
1956: ,''$TRANSACTION_COA_ID$''
1957: ,TO_CHAR(p_chart_of_accounts_id)
1958: );
1959: l_update_stmts_wrapper_text:= xla_cmp_string_pkg.replace_token(
1960: l_update_stmts_wrapper_text
1961: ,''$TRANSACTION_COA_NAME$''
1962: ,NVL(p_chart_of_accounts_name, '' '')
1963: );

Line 1964: l_update_stmts_wrapper_text:= xla_cmp_string_pkg.replace_token(

1960: l_update_stmts_wrapper_text
1961: ,''$TRANSACTION_COA_NAME$''
1962: ,NVL(p_chart_of_accounts_name, '' '')
1963: );
1964: l_update_stmts_wrapper_text:= xla_cmp_string_pkg.replace_token(
1965: l_update_stmts_wrapper_text
1966: ,''$CONCAT_SEGMENTS_TEMPLATE$''
1967: ,NVL(p_concat_segments_template, '' '')
1968: );

Line 1971: l_update_stmts_wrapper_text := xla_cmp_string_pkg.replace_token

1967: ,NVL(p_concat_segments_template, '' '')
1968: );
1969:
1970: --Replace the update statements token
1971: l_update_stmts_wrapper_text := xla_cmp_string_pkg.replace_token
1972: ( l_update_stmts_wrapper_text
1973: ,''$C_TMPL_BATCH_BUILD_CCID_SQL$''
1974: ,l_update_statements_text
1975: );

Line 4115: l_adr_bodies := xla_cmp_string_pkg.replace_token

4111: l_return_value := FALSE;
4112: END IF;
4113:
4114:
4115: l_adr_bodies := xla_cmp_string_pkg.replace_token
4116: ( l_adr_bodies
4117: ,'G_LOG_ENABLED'
4118: ,'xla_cmp_tad_pkg.G_LOG_ENABLED'
4119: );

Line 4121: l_adr_bodies := xla_cmp_string_pkg.replace_token

4117: ,'G_LOG_ENABLED'
4118: ,'xla_cmp_tad_pkg.G_LOG_ENABLED'
4119: );
4120:
4121: l_adr_bodies := xla_cmp_string_pkg.replace_token
4122: ( l_adr_bodies
4123: ,'g_log_enabled'
4124: ,'xla_cmp_tad_pkg.G_LOG_ENABLED'
4125: );

Line 4126: l_adr_bodies := xla_cmp_string_pkg.replace_token

4122: ( l_adr_bodies
4123: ,'g_log_enabled'
4124: ,'xla_cmp_tad_pkg.G_LOG_ENABLED'
4125: );
4126: l_adr_bodies := xla_cmp_string_pkg.replace_token
4127: ( l_adr_bodies
4128: ,'G_LOG_LEVEL'
4129: ,'xla_cmp_tad_pkg.G_LOG_LEVEL'
4130: );

Line 4131: l_adr_bodies := xla_cmp_string_pkg.replace_token

4127: ( l_adr_bodies
4128: ,'G_LOG_LEVEL'
4129: ,'xla_cmp_tad_pkg.G_LOG_LEVEL'
4130: );
4131: l_adr_bodies := xla_cmp_string_pkg.replace_token
4132: ( l_adr_bodies
4133: ,'g_log_level'
4134: ,'xla_cmp_tad_pkg.G_LOG_LEVEL'
4135: );

Line 4137: l_adr_bodies := xla_cmp_string_pkg.replace_token

4133: ,'g_log_level'
4134: ,'xla_cmp_tad_pkg.G_LOG_LEVEL'
4135: );
4136:
4137: l_adr_bodies := xla_cmp_string_pkg.replace_token
4138: ( l_adr_bodies
4139: ,'C_DEFAULT_MODULE'
4140: ,'g_default_module'
4141: );

Line 4142: l_adr_bodies := xla_cmp_string_pkg.replace_token

4138: ( l_adr_bodies
4139: ,'C_DEFAULT_MODULE'
4140: ,'g_default_module'
4141: );
4142: l_adr_bodies := xla_cmp_string_pkg.replace_token
4143: ( l_adr_bodies
4144: ,'C_LEVEL_PROCEDURE'
4145: ,'xla_cmp_tad_pkg.C_LEVEL_PROCEDURE'
4146: );

Line 4572: l_package_spec_text := xla_cmp_string_pkg.replace_token

4568: ,p_replacement_text => p_adr_specs_text
4569: );
4570:
4571: --replace the package name tokens
4572: l_package_spec_text := xla_cmp_string_pkg.replace_token
4573: (
4574: l_package_spec_text
4575: ,'$TAD_PACKAGE_NAME_1$'
4576: ,p_package_name

Line 4579: l_package_spec_text := xla_cmp_string_pkg.replace_token

4575: ,'$TAD_PACKAGE_NAME_1$'
4576: ,p_package_name
4577: );
4578:
4579: l_package_spec_text := xla_cmp_string_pkg.replace_token
4580: (
4581: l_package_spec_text
4582: ,'$TAD_PACKAGE_NAME_2$'
4583: ,RPAD( p_package_name

Line 4590: l_package_spec_text := xla_cmp_string_pkg.replace_token

4586: )
4587: || '|'
4588: );
4589:
4590: l_package_spec_text := xla_cmp_string_pkg.replace_token
4591: (
4592: l_package_spec_text
4593: ,'$TAD_PACKAGE_NAME_3$'
4594: ,UPPER(p_package_name)

Line 4598: l_package_spec_text := xla_cmp_string_pkg.replace_token

4594: ,UPPER(p_package_name)
4595: );
4596:
4597: --replace the application name token
4598: l_package_spec_text := xla_cmp_string_pkg.replace_token
4599: (
4600: l_package_spec_text
4601: ,'$APPLICATION_NAME$'
4602: ,RPAD( g_application_info.application_name

Line 4609: l_package_spec_text := xla_cmp_string_pkg.replace_token

4605: ) || '|'
4606: );
4607:
4608: --replace the application id token
4609: l_package_spec_text := xla_cmp_string_pkg.replace_token
4610: (
4611: l_package_spec_text
4612: ,'$APPLICATION_ID$'
4613: ,RPAD( TO_CHAR(g_application_info.application_id) || ')'

Line 4621: l_package_spec_text := xla_cmp_string_pkg.replace_token

4617: );
4618:
4619:
4620: --replace the TAD info tokens
4621: l_package_spec_text := xla_cmp_string_pkg.replace_token
4622: (
4623: l_package_spec_text
4624: ,'$TAD_CODE$'
4625: ,RPAD( p_account_definition_code

Line 4631: l_package_spec_text := xla_cmp_string_pkg.replace_token

4627: , ' '
4628: )
4629: || '|'
4630: );
4631: l_package_spec_text := xla_cmp_string_pkg.replace_token
4632: (
4633: l_package_spec_text
4634: ,'$TAD_TYPE_CODE$'
4635: ,RPAD( p_account_definition_type_code

Line 4641: l_package_spec_text := xla_cmp_string_pkg.replace_token

4637: , ' '
4638: )
4639: || '|'
4640: );
4641: l_package_spec_text := xla_cmp_string_pkg.replace_token
4642: (
4643: l_package_spec_text
4644: ,'$AMB_CONTEXT_CODE$'
4645: ,RPAD( p_amb_context_code

Line 5039: l_package_body_text := xla_cmp_string_pkg.replace_token

5035: ,p_replacement_text => p_package_name
5036: );
5037:
5038:
5039: l_package_body_text := xla_cmp_string_pkg.replace_token
5040: (
5041: l_package_body_text
5042: ,'$TAD_PACKAGE_NAME_2$'
5043: ,RPAD( p_package_name

Line 5050: l_package_body_text := xla_cmp_string_pkg.replace_token

5046: )
5047: || '|'
5048: );
5049:
5050: l_package_body_text := xla_cmp_string_pkg.replace_token
5051: (
5052: l_package_body_text
5053: ,'$TAD_PACKAGE_NAME_3$'
5054: ,LOWER(p_package_name)

Line 5059: l_package_body_text := xla_cmp_string_pkg.replace_token

5055: );
5056:
5057:
5058: --replace the application name token
5059: l_package_body_text := xla_cmp_string_pkg.replace_token
5060: (
5061: l_package_body_text
5062: ,'$APPLICATION_NAME$'
5063: ,RPAD( g_application_info.application_name

Line 5070: l_package_body_text := xla_cmp_string_pkg.replace_token

5066: ) || '|'
5067: );
5068:
5069: --replace the application id token
5070: l_package_body_text := xla_cmp_string_pkg.replace_token
5071: (
5072: l_package_body_text
5073: ,'$APPLICATION_ID$'
5074: ,RPAD( TO_CHAR(g_application_info.application_id) || ')'

Line 5079: l_package_body_text := xla_cmp_string_pkg.replace_token

5075: , 49
5076: , ' '
5077: ) || '|'
5078: );
5079: l_package_body_text := xla_cmp_string_pkg.replace_token
5080: (
5081: l_package_body_text
5082: ,'$APPLICATION_ID_2$'
5083: ,TO_CHAR(g_application_info.application_id)

Line 5087: l_package_body_text := xla_cmp_string_pkg.replace_token

5083: ,TO_CHAR(g_application_info.application_id)
5084: );
5085:
5086: --replace the TAD info tokens
5087: l_package_body_text := xla_cmp_string_pkg.replace_token
5088: (
5089: l_package_body_text
5090: ,'$TAD_CODE$'
5091: ,RPAD( p_account_definition_code

Line 5097: l_package_body_text := xla_cmp_string_pkg.replace_token

5093: , ' '
5094: )
5095: || '|'
5096: );
5097: l_package_body_text := xla_cmp_string_pkg.replace_token
5098: (
5099: l_package_body_text
5100: ,'$TAD_CODE_2$'
5101: ,p_account_definition_code

Line 5104: l_package_body_text := xla_cmp_string_pkg.replace_token

5100: ,'$TAD_CODE_2$'
5101: ,p_account_definition_code
5102: );
5103:
5104: l_package_body_text := xla_cmp_string_pkg.replace_token
5105: (
5106: l_package_body_text
5107: ,'$TAD_TYPE_CODE$'
5108: ,RPAD( p_account_definition_type_code

Line 5114: l_package_body_text := xla_cmp_string_pkg.replace_token

5110: , ' '
5111: )
5112: || '|'
5113: );
5114: l_package_body_text := xla_cmp_string_pkg.replace_token
5115: (
5116: l_package_body_text
5117: ,'$TAD_TYPE_CODE_2$'
5118: ,p_account_definition_type_code

Line 5121: l_package_body_text := xla_cmp_string_pkg.replace_token

5117: ,'$TAD_TYPE_CODE_2$'
5118: ,p_account_definition_type_code
5119: );
5120:
5121: l_package_body_text := xla_cmp_string_pkg.replace_token
5122: (
5123: l_package_body_text
5124: ,'$AMB_CONTEXT_CODE$'
5125: ,RPAD( p_amb_context_code

Line 5131: l_package_body_text := xla_cmp_string_pkg.replace_token

5127: , ' '
5128: )
5129: || '|'
5130: );
5131: l_package_body_text := xla_cmp_string_pkg.replace_token
5132: (
5133: l_package_body_text
5134: ,'$AMB_CONTEXT_CODE_2$'
5135: ,p_amb_context_code

Line 5304: l_update_statement_text:= xla_cmp_string_pkg.replace_token(

5300: --Get the update statement template
5301: l_update_statement_text := C_TMPL_BATCH_CCID_SEG_UPD_STMT;
5302:
5303: --Replace the table name token
5304: l_update_statement_text:= xla_cmp_string_pkg.replace_token(
5305: l_update_statement_text
5306: ,'$table_name$'
5307: ,NVL(l_current_temp_table_name, ' ')
5308: );

Line 5362: xla_cmp_string_pkg.replace_token(

5358: l_set_clause_text := l_set_clause_text || C_TMPL_SET_CCID;
5359: ELSE
5360: l_set_clause_text := l_set_clause_text || C_TMPL_SET_SEGMENT;
5361: l_set_clause_text :=
5362: xla_cmp_string_pkg.replace_token(
5363: l_set_clause_text
5364: ,'$SEGMENT_COLUMN_NAME$'
5365: ,p_table_of_tad_details(i).flexfield_segment_code
5366: );

Line 5421: l_case_branch_text:= xla_cmp_string_pkg.replace_token(

5417: END LOOP;
5418: END IF;
5419:
5420: --Replace the function name token
5421: l_case_branch_text:= xla_cmp_string_pkg.replace_token(
5422: l_case_branch_text
5423: ,'$ADR_FUNCT_NAME$'
5424: ,l_adr_function_name
5425: );

Line 5452: l_case_branch_text:= xla_cmp_string_pkg.replace_token(

5448: END LOOP;
5449: END;
5450:
5451: --Replace the function source params token
5452: l_case_branch_text:= xla_cmp_string_pkg.replace_token(
5453: l_case_branch_text
5454: ,'$C_TMPL_ADR_FUNCT_PARAMS$'
5455: ,NVL(l_adr_funct_params, ' ')
5456: );

Line 5618: l_tmpl_where_segment_null_and := xla_cmp_string_pkg.replace_token

5614: --Build the common token values
5615: FOR i IN l_table_segment_column_names.FIRST..l_table_segment_column_names.LAST
5616: LOOP
5617: --C_TMPL_WHERE_SEGMENT_NULL_ANDS
5618: l_tmpl_where_segment_null_and := xla_cmp_string_pkg.replace_token
5619: ( '
5620: AND gt.$SEGMENT_COLUMN_NAME$ IS NULL '
5621: ,'$SEGMENT_COLUMN_NAME$'
5622: ,l_table_segment_column_names(i)

Line 5635: xla_cmp_string_pkg.replace_token

5631: WHEN 1 THEN ' '
5632: ELSE ' OR '
5633: END
5634: ||
5635: xla_cmp_string_pkg.replace_token
5636: ( ' gt.$SEGMENT_COLUMN_NAME$ IS NULL
5637: '
5638: ,'$SEGMENT_COLUMN_NAME$'
5639: ,l_table_segment_column_names(i)

Line 5651: xla_cmp_string_pkg.replace_token

5647: WHEN 1 THEN ' '
5648: ELSE ' ,'
5649: END
5650: ||
5651: xla_cmp_string_pkg.replace_token
5652: ( ' gt.$SEGMENT_COLUMN_NAME$
5653: '
5654: ,'$SEGMENT_COLUMN_NAME$'
5655: ,l_table_segment_column_names(i)

Line 5667: xla_cmp_string_pkg.replace_token

5663: WHEN 1 THEN ' '
5664: ELSE ' ,'
5665: END
5666: ||
5667: xla_cmp_string_pkg.replace_token
5668: ( ' NVL(gt.$SEGMENT_COLUMN_NAME$, gcc.$SEGMENT_COLUMN_NAME$)
5669: '
5670: ,'$SEGMENT_COLUMN_NAME$'
5671: ,l_table_segment_column_names(i)

Line 5678: l_tmpl_where_segments_equal := xla_cmp_string_pkg.replace_token

5674: l_tmpl_sel_nvl_segment_commas := l_tmpl_sel_nvl_segment_commas
5675: || l_tmpl_sel_nvl_segment_comma;
5676:
5677: --C_TMPL_WHERE_SEGMENTS_EQUAL
5678: l_tmpl_where_segments_equal := xla_cmp_string_pkg.replace_token
5679: ( ' AND gcc.$SEGMENT_COLUMN_NAME$ = gt.$SEGMENT_COLUMN_NAME$
5680: '
5681: ,'$SEGMENT_COLUMN_NAME$'
5682: ,l_table_segment_column_names(i)

Line 5738: l_update_statement_text:= xla_cmp_string_pkg.replace_token(

5734: --Get the update statement template
5735: l_update_statement_text := C_TMPL_BATCH_BUILD_CCID_STMTS;
5736:
5737: --Replace the table name token
5738: l_update_statement_text:= xla_cmp_string_pkg.replace_token(
5739: l_update_statement_text
5740: ,'$TABLE_NAME$'
5741: ,NVL(l_current_temp_table_name, ' ')
5742: );

Line 5745: l_update_statement_text:= xla_cmp_string_pkg.replace_token(

5741: ,NVL(l_current_temp_table_name, ' ')
5742: );
5743:
5744: --Replace the common tokens
5745: l_update_statement_text:= xla_cmp_string_pkg.replace_token(
5746: l_update_statement_text
5747: ,'$C_TMPL_WHERE_SEGMENT_NULL_ANDS$'
5748: ,NVL(l_tmpl_where_segment_null_ands, ' ')
5749: );

Line 5751: l_update_statement_text:= xla_cmp_string_pkg.replace_token(

5747: ,'$C_TMPL_WHERE_SEGMENT_NULL_ANDS$'
5748: ,NVL(l_tmpl_where_segment_null_ands, ' ')
5749: );
5750:
5751: l_update_statement_text:= xla_cmp_string_pkg.replace_token(
5752: l_update_statement_text
5753: ,'$C_TMPL_WHERE_SEGMENT_NULL_ORS$'
5754: ,NVL(l_tmpl_where_segment_null_ors, ' ')
5755: );

Line 5757: l_update_statement_text:= xla_cmp_string_pkg.replace_token(

5753: ,'$C_TMPL_WHERE_SEGMENT_NULL_ORS$'
5754: ,NVL(l_tmpl_where_segment_null_ors, ' ')
5755: );
5756:
5757: l_update_statement_text:= xla_cmp_string_pkg.replace_token(
5758: l_update_statement_text
5759: ,'$C_TMPL_UPD_SET_SEGMENT_COMMAS$'
5760: ,NVL(l_tmpl_upd_set_segment_commas, ' ')
5761: );

Line 5763: l_update_statement_text:= xla_cmp_string_pkg.replace_token(

5759: ,'$C_TMPL_UPD_SET_SEGMENT_COMMAS$'
5760: ,NVL(l_tmpl_upd_set_segment_commas, ' ')
5761: );
5762:
5763: l_update_statement_text:= xla_cmp_string_pkg.replace_token(
5764: l_update_statement_text
5765: ,'$C_TMPL_SEL_NVL_SEGMENT_COMMAS$'
5766: ,NVL(l_tmpl_sel_nvl_segment_commas, ' ')
5767: );

Line 5769: l_update_statement_text:= xla_cmp_string_pkg.replace_token(

5765: ,'$C_TMPL_SEL_NVL_SEGMENT_COMMAS$'
5766: ,NVL(l_tmpl_sel_nvl_segment_commas, ' ')
5767: );
5768:
5769: l_update_statement_text:= xla_cmp_string_pkg.replace_token(
5770: l_update_statement_text
5771: ,'$C_TMPL_WHERE_SEGMENTS_EQUALS$'
5772: ,NVL(l_tmpl_where_segments_equals, ' ')
5773: );

Line 5775: l_update_statement_text:= xla_cmp_string_pkg.replace_token(

5771: ,'$C_TMPL_WHERE_SEGMENTS_EQUALS$'
5772: ,NVL(l_tmpl_where_segments_equals, ' ')
5773: );
5774:
5775: l_update_statement_text:= xla_cmp_string_pkg.replace_token(
5776: l_update_statement_text
5777: ,'$C_TMPL_CONCAT_SEGMENTS$'
5778: ,NVL(l_tmpl_concat_segments, ' ')
5779: );

Line 5964: || xla_cmp_string_pkg.replace_token

5960:
5961: FOR source_index IN l_table_of_sources.FIRST..l_table_of_sources.LAST
5962: LOOP
5963: l_tmpl_tab_push_interf_sources := l_tmpl_tab_push_interf_sources
5964: || xla_cmp_string_pkg.replace_token
5965: (
5966: C_TMPL_TAB_PUSH_INTERF_SOURCE
5967: ,'$SOURCE_CODE$'
5968: ,NVL( l_table_of_sources(source_index)

Line 5972: || xla_cmp_string_pkg.replace_token

5968: ,NVL( l_table_of_sources(source_index)
5969: , ' ')
5970: );
5971: l_tmpl_tab_pop_interf_sources := l_tmpl_tab_pop_interf_sources
5972: || xla_cmp_string_pkg.replace_token
5973: (
5974: C_TMPL_TAB_POP_INTERF_SOURCE
5975: ,'$SOURCE_CODE$'
5976: ,NVL( l_table_of_sources(source_index)

Line 5986: l_push_interf_statement_text:= xla_cmp_string_pkg.replace_token

5982: l_push_interf_statement_text := C_TMPL_PUSH_INTERF_DATA_STMT;
5983: l_pop_interf_statement_text := C_TMPL_POP_INTERF_DATA_STMT;
5984:
5985: --Replace the table name token
5986: l_push_interf_statement_text:= xla_cmp_string_pkg.replace_token
5987: (
5988: l_push_interf_statement_text
5989: ,'$TABLE_NAME$'
5990: ,NVL(l_current_temp_table_name, ' ')

Line 5992: l_pop_interf_statement_text:= xla_cmp_string_pkg.replace_token

5988: l_push_interf_statement_text
5989: ,'$TABLE_NAME$'
5990: ,NVL(l_current_temp_table_name, ' ')
5991: );
5992: l_pop_interf_statement_text:= xla_cmp_string_pkg.replace_token
5993: (
5994: l_pop_interf_statement_text
5995: ,'$TABLE_NAME$'
5996: ,NVL(l_current_temp_table_name, ' ')

Line 6000: l_push_interf_statement_text:= xla_cmp_string_pkg.replace_token

5996: ,NVL(l_current_temp_table_name, ' ')
5997: );
5998:
5999: --Replace the plsql table name token
6000: l_push_interf_statement_text:= xla_cmp_string_pkg.replace_token
6001: (
6002: l_push_interf_statement_text
6003: ,'$PLSQL_TABLE_NAME$'
6004: ,NVL(l_current_plsql_table_name, ' ')

Line 6006: l_pop_interf_statement_text:= xla_cmp_string_pkg.replace_token

6002: l_push_interf_statement_text
6003: ,'$PLSQL_TABLE_NAME$'
6004: ,NVL(l_current_plsql_table_name, ' ')
6005: );
6006: l_pop_interf_statement_text:= xla_cmp_string_pkg.replace_token
6007: (
6008: l_pop_interf_statement_text
6009: ,'$PLSQL_TABLE_NAME$'
6010: ,NVL(l_current_plsql_table_name, ' ')

Line 6014: l_push_interf_statement_text:= xla_cmp_string_pkg.replace_token

6010: ,NVL(l_current_plsql_table_name, ' ')
6011: );
6012:
6013: --Replace the TAB API package name token
6014: l_push_interf_statement_text:= xla_cmp_string_pkg.replace_token
6015: (
6016: l_push_interf_statement_text
6017: ,'$TAB_API_PACKAGE_NAME$'
6018: ,NVL(l_tab_api_package_name, ' ')

Line 6020: l_pop_interf_statement_text:= xla_cmp_string_pkg.replace_token

6016: l_push_interf_statement_text
6017: ,'$TAB_API_PACKAGE_NAME$'
6018: ,NVL(l_tab_api_package_name, ' ')
6019: );
6020: l_pop_interf_statement_text:= xla_cmp_string_pkg.replace_token
6021: (
6022: l_pop_interf_statement_text
6023: ,'$TAB_API_PACKAGE_NAME$'
6024: ,NVL(l_tab_api_package_name, ' ')

Line 6028: l_push_interf_statement_text:= xla_cmp_string_pkg.replace_token

6024: ,NVL(l_tab_api_package_name, ' ')
6025: );
6026:
6027: --Replace the source list token
6028: l_push_interf_statement_text:= xla_cmp_string_pkg.replace_token
6029: (
6030: l_push_interf_statement_text
6031: ,'$C_TMPL_TAB_PUSH_INTERF_SOURCES$'
6032: ,NVL(l_tmpl_tab_push_interf_sources, ' ')

Line 6034: l_pop_interf_statement_text:= xla_cmp_string_pkg.replace_token

6030: l_push_interf_statement_text
6031: ,'$C_TMPL_TAB_PUSH_INTERF_SOURCES$'
6032: ,NVL(l_tmpl_tab_push_interf_sources, ' ')
6033: );
6034: l_pop_interf_statement_text:= xla_cmp_string_pkg.replace_token
6035: (
6036: l_pop_interf_statement_text
6037: ,'$C_TMPL_TAB_POP_INTERF_SOURCES$'
6038: ,NVL(l_tmpl_tab_pop_interf_sources, ' ')