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

Line 2009: p_package_spec_text := xla_cmp_string_pkg.replace_token

2005: END IF;
2006:
2007: --take the package specification template
2008: --replace the package name tokens
2009: p_package_spec_text := xla_cmp_string_pkg.replace_token
2010: (
2011: C_TMPL_TAB_PACKAGE_SPEC
2012: ,'$TAB_API_PACKAGE_NAME_1$'
2013: ,g_tab_api_package_name

Line 2016: p_package_spec_text := xla_cmp_string_pkg.replace_token

2012: ,'$TAB_API_PACKAGE_NAME_1$'
2013: ,g_tab_api_package_name
2014: );
2015:
2016: p_package_spec_text := xla_cmp_string_pkg.replace_token
2017: (
2018: p_package_spec_text
2019: ,'$TAB_API_PACKAGE_NAME_2$'
2020: ,RPAD( g_tab_api_package_name

Line 2028: p_package_spec_text := xla_cmp_string_pkg.replace_token

2024: || '|'
2025: );
2026:
2027: --replace the application name token
2028: p_package_spec_text := xla_cmp_string_pkg.replace_token
2029: (
2030: p_package_spec_text
2031: ,'$APPLICATION_NAME$'
2032: ,RPAD( g_application_info.application_name

Line 2039: p_package_spec_text := xla_cmp_string_pkg.replace_token

2035: ) || '|'
2036: );
2037:
2038: --replace the application id token
2039: p_package_spec_text := xla_cmp_string_pkg.replace_token
2040: (
2041: p_package_spec_text
2042: ,'$APPLICATION_ID$'
2043: ,RPAD( TO_CHAR(g_application_info.application_id) || ')'

Line 2063: p_package_spec_text := xla_cmp_string_pkg.replace_token

2059: l_return_value := FALSE;
2060: END IF;
2061:
2062: --replace the history token
2063: p_package_spec_text := xla_cmp_string_pkg.replace_token
2064: (
2065: p_package_spec_text
2066: ,'$HISTORY$'
2067: ,RPAD( l_history

Line 2094: p_package_spec_text := xla_cmp_string_pkg.replace_token(

2090: l_return_value := FALSE;
2091: END IF;
2092:
2093: --replace the record type declarations token
2094: p_package_spec_text := xla_cmp_string_pkg.replace_token(
2095: p_package_spec_text
2096: ,'$TAB_REC_TYPE_DECLARATIONS$'
2097: ,l_tab_rec_type_declarations
2098: );

Line 2101: p_package_spec_text := xla_cmp_string_pkg.replace_token(

2097: ,l_tab_rec_type_declarations
2098: );
2099:
2100: --replace the table type declarations token
2101: p_package_spec_text := xla_cmp_string_pkg.replace_token(
2102: p_package_spec_text
2103: ,'$TAB_TABLE_TYPE_DECLARATIONS$'
2104: ,l_table_type_declarations
2105: );

Line 2108: p_package_spec_text := xla_cmp_string_pkg.replace_token(

2104: ,l_table_type_declarations
2105: );
2106:
2107: --replace the table variable declarations token
2108: p_package_spec_text := xla_cmp_string_pkg.replace_token(
2109: p_package_spec_text
2110: ,'$TAB_TABLE_VAR_DECLARATIONS$'
2111: ,l_table_var_declarations
2112: );

Line 2115: p_package_spec_text := xla_cmp_string_pkg.replace_token(

2111: ,l_table_var_declarations
2112: );
2113:
2114: --replace the write procedure declarations token
2115: p_package_spec_text := xla_cmp_string_pkg.replace_token(
2116: p_package_spec_text
2117: ,'$TAB_WRITE_PROC_DECLARATIONS$'
2118: ,l_write_proc_declarations
2119: );

Line 2122: p_package_spec_text := xla_cmp_string_pkg.replace_token(

2118: ,l_write_proc_declarations
2119: );
2120:
2121: --replace the read procedure declarations token
2122: p_package_spec_text := xla_cmp_string_pkg.replace_token(
2123: p_package_spec_text
2124: ,'$TAB_READ_PROC_DECLARATIONS$'
2125: ,l_read_proc_declarations
2126: );

Line 2286: l_record_type_declar := xla_cmp_string_pkg.replace_token

2282: l_write_proc_declar := C_TMPL_TAB_WRITE_PROC_DECLAR;
2283: l_read_proc_declar := C_TMPL_TAB_READ_PROC_DECLAR;
2284:
2285: --replace the object_name_affix
2286: l_record_type_declar := xla_cmp_string_pkg.replace_token
2287: (
2288: l_record_type_declar
2289: ,'$OBJECT_NAME_AFFIX$'
2290: ,CASE

Line 2295: l_table_type_declar := xla_cmp_string_pkg.replace_token

2291: WHEN g_all_object_name_affixes(affix_index) IS NULL THEN ' '
2292: ELSE '_' || g_all_object_name_affixes(affix_index)
2293: END
2294: );
2295: l_table_type_declar := xla_cmp_string_pkg.replace_token
2296: (
2297: l_table_type_declar
2298: ,'$OBJECT_NAME_AFFIX$'
2299: ,CASE

Line 2304: l_table_var_declar := xla_cmp_string_pkg.replace_token

2300: WHEN g_all_object_name_affixes(affix_index) IS NULL THEN ' '
2301: ELSE '_' || g_all_object_name_affixes(affix_index)
2302: END
2303: );
2304: l_table_var_declar := xla_cmp_string_pkg.replace_token
2305: (
2306: l_table_var_declar
2307: ,'$OBJECT_NAME_AFFIX$'
2308: ,CASE

Line 2321: l_write_proc_declar := xla_cmp_string_pkg.replace_token

2317: ,' '
2318: )
2319: END
2320: );
2321: l_write_proc_declar := xla_cmp_string_pkg.replace_token
2322: (
2323: l_write_proc_declar
2324: ,'$OBJECT_NAME_AFFIX$'
2325: ,CASE

Line 2330: l_read_proc_declar := xla_cmp_string_pkg.replace_token

2326: WHEN g_all_object_name_affixes(affix_index) IS NULL THEN ' '
2327: ELSE '_' || g_all_object_name_affixes(affix_index)
2328: END
2329: );
2330: l_read_proc_declar := xla_cmp_string_pkg.replace_token
2331: (
2332: l_read_proc_declar
2333: ,'$OBJECT_NAME_AFFIX$'
2334: ,CASE

Line 2407: l_source_rec_field_declar := xla_cmp_string_pkg.replace_token

2403: l_source_rec_field_declar := C_TMPL_SOURCE_REC_FIELD_DECLAR;
2404: l_source_proc_param_declar := C_TMPL_SOURCE_PROC_PARAM_DECLA;
2405:
2406: --replace the source code
2407: l_source_rec_field_declar := xla_cmp_string_pkg.replace_token
2408: (
2409: l_source_rec_field_declar
2410: ,'$SOURCE_CODE$'
2411: ,RPAD( LOWER(source_rec.source_code)

Line 2417: l_source_proc_param_declar := xla_cmp_string_pkg.replace_token

2413: ,' '
2414: )
2415: );
2416: --replace the source code
2417: l_source_proc_param_declar := xla_cmp_string_pkg.replace_token
2418: (
2419: l_source_proc_param_declar
2420: ,'$SOURCE_CODE$'
2421: ,RPAD( LOWER(source_rec.source_code)

Line 2459: l_source_rec_field_declar := xla_cmp_string_pkg.replace_token

2455: END IF;
2456:
2457: END CASE;
2458:
2459: l_source_rec_field_declar := xla_cmp_string_pkg.replace_token
2460: (
2461: l_source_rec_field_declar
2462: ,'$SOURCE_SPECIFIC_DATATYPE$'
2463: ,RPAD( l_datatype_specific_declar

Line 2469: l_source_proc_param_declar := xla_cmp_string_pkg.replace_token

2465: ,' '
2466: )
2467: );
2468:
2469: l_source_proc_param_declar := xla_cmp_string_pkg.replace_token
2470: (
2471: l_source_proc_param_declar
2472: ,'$SOURCE_GENERIC_DATATYPE$'
2473: ,RPAD( l_datatype_generic_declar

Line 2501: l_record_type_declar := xla_cmp_string_pkg.replace_token

2497: END IF;
2498: END LOOP;
2499:
2500: --replace the source field declarations
2501: l_record_type_declar := xla_cmp_string_pkg.replace_token
2502: (
2503: l_record_type_declar
2504: ,'$SOURCE_REC_FIELD_DECLARATIONS$'
2505: ,NVL(l_source_rec_field_declars, ' ')

Line 2509: l_write_proc_declar := xla_cmp_string_pkg.replace_token

2505: ,NVL(l_source_rec_field_declars, ' ')
2506: );
2507:
2508: --replace the source parameter declarations
2509: l_write_proc_declar := xla_cmp_string_pkg.replace_token
2510: (
2511: l_write_proc_declar
2512: ,'$SOURCE_PROC_PARAM_DECLARATIONS$'
2513: ,NVL(l_source_proc_param_declars, ' ')

Line 2719: l_package_body_text := xla_cmp_string_pkg.replace_token

2715: --take the package body template
2716: l_package_body_text := C_TMPL_TAB_PACKAGE_BODY;
2717:
2718: --replace the package name tokens
2719: l_package_body_text := xla_cmp_string_pkg.replace_token
2720: (
2721: l_package_body_text
2722: ,'$TAB_API_PACKAGE_NAME_1$'
2723: ,g_tab_api_package_name

Line 2726: l_package_body_text := xla_cmp_string_pkg.replace_token

2722: ,'$TAB_API_PACKAGE_NAME_1$'
2723: ,g_tab_api_package_name
2724: );
2725:
2726: l_package_body_text := xla_cmp_string_pkg.replace_token
2727: (
2728: l_package_body_text
2729: ,'$TAB_API_PACKAGE_NAME_2$'
2730: ,RPAD( g_tab_api_package_name

Line 2737: l_package_body_text := xla_cmp_string_pkg.replace_token

2733: )
2734: || '|'
2735: );
2736:
2737: l_package_body_text := xla_cmp_string_pkg.replace_token
2738: (
2739: l_package_body_text
2740: ,'$TAB_API_PACKAGE_NAME_3$'
2741: ,LOWER(g_tab_api_package_name)

Line 2744: l_package_body_text := xla_cmp_string_pkg.replace_token

2740: ,'$TAB_API_PACKAGE_NAME_3$'
2741: ,LOWER(g_tab_api_package_name)
2742: );
2743:
2744: l_package_body_text := xla_cmp_string_pkg.replace_token
2745: (
2746: l_package_body_text
2747: ,'$oracle_user_name$'
2748: ,LOWER(g_application_info.oracle_username)

Line 2759: l_package_body_text := xla_cmp_string_pkg.replace_token

2755: ,p_level => C_LEVEL_STATEMENT);
2756: END IF;
2757:
2758: --replace the application name token
2759: l_package_body_text := xla_cmp_string_pkg.replace_token
2760: (
2761: l_package_body_text
2762: ,'$APPLICATION_NAME$'
2763: ,RPAD( g_application_info.application_name

Line 2770: l_package_body_text := xla_cmp_string_pkg.replace_token

2766: ) || '|'
2767: );
2768:
2769: --replace the application id token
2770: l_package_body_text := xla_cmp_string_pkg.replace_token
2771: (
2772: l_package_body_text
2773: ,'$APPLICATION_ID$'
2774: ,RPAD( TO_CHAR(g_application_info.application_id) || ')'

Line 2779: l_package_body_text := xla_cmp_string_pkg.replace_token

2775: , 49
2776: , ' '
2777: ) || '|'
2778: );
2779: l_package_body_text := xla_cmp_string_pkg.replace_token
2780: (
2781: l_package_body_text
2782: ,'$APPLICATION_ID_2$'
2783: ,TO_CHAR(g_application_info.application_id)

Line 2808: l_package_body_text := xla_cmp_string_pkg.replace_token

2804: l_return_value := FALSE;
2805: END IF;
2806:
2807: --replace the history token
2808: l_package_body_text := xla_cmp_string_pkg.replace_token
2809: (
2810: l_package_body_text
2811: ,'$HISTORY$'
2812: ,RPAD( l_history

Line 2988: l_write_proc_impl := xla_cmp_string_pkg.replace_token

2984: l_read_proc_impl := C_TMPL_TAB_READ_PROC_IMPL;
2985: l_reset_interface_proc_stmt := C_TMPL_TAB_RESET_ONLINE_INT_ST;
2986:
2987: --replace package name tokens
2988: l_write_proc_impl := xla_cmp_string_pkg.replace_token
2989: (
2990: l_write_proc_impl
2991: ,'$TAB_API_PACKAGE_NAME_3$'
2992: ,LOWER(g_tab_api_package_name)

Line 2995: l_read_proc_impl := xla_cmp_string_pkg.replace_token

2991: ,'$TAB_API_PACKAGE_NAME_3$'
2992: ,LOWER(g_tab_api_package_name)
2993: );
2994:
2995: l_read_proc_impl := xla_cmp_string_pkg.replace_token
2996: (
2997: l_read_proc_impl
2998: ,'$TAB_API_PACKAGE_NAME_3$'
2999: ,LOWER(g_tab_api_package_name)

Line 3004: l_write_proc_impl := xla_cmp_string_pkg.replace_token

3000: );
3001:
3002:
3003: --replace object name affix tokens
3004: l_write_proc_impl := xla_cmp_string_pkg.replace_token
3005: (
3006: l_write_proc_impl
3007: ,'$OBJECT_NAME_AFFIX$'
3008: ,CASE

Line 3013: l_read_proc_impl := xla_cmp_string_pkg.replace_token

3009: WHEN g_all_object_name_affixes(affix_index) IS NULL THEN ' '
3010: ELSE '_' || g_all_object_name_affixes(affix_index)
3011: END
3012: );
3013: l_read_proc_impl := xla_cmp_string_pkg.replace_token
3014: (
3015: l_read_proc_impl
3016: ,'$OBJECT_NAME_AFFIX$'
3017: ,CASE

Line 3023: l_reset_interface_proc_stmt := xla_cmp_string_pkg.replace_token

3019: ELSE '_' || g_all_object_name_affixes(affix_index)
3020: END
3021: );
3022:
3023: l_reset_interface_proc_stmt := xla_cmp_string_pkg.replace_token
3024: (
3025: l_reset_interface_proc_stmt
3026: ,'$OBJECT_NAME_AFFIX$.'
3027: ,CASE

Line 3100: l_source_proc_param_declar := xla_cmp_string_pkg.replace_token

3096: l_source_proc_param_declar := C_TMPL_SOURCE_PROC_PARAM_DECLA;
3097: l_source_rec_field_assgn := C_TMPL_SOURCE_REC_FIELD_ASSGN;
3098:
3099: --replace the source code tokens
3100: l_source_proc_param_declar := xla_cmp_string_pkg.replace_token
3101: (
3102: l_source_proc_param_declar
3103: ,'$SOURCE_CODE$'
3104: ,RPAD( LOWER(source_rec.source_code)

Line 3109: l_source_rec_field_assgn := xla_cmp_string_pkg.replace_token

3105: ,34
3106: ,' '
3107: )
3108: );
3109: l_source_rec_field_assgn := xla_cmp_string_pkg.replace_token
3110: (
3111: l_source_rec_field_assgn
3112: ,'$SOURCE_CODE_LEFT$'
3113: ,RPAD( LOWER(source_rec.source_code)

Line 3118: l_source_rec_field_assgn := xla_cmp_string_pkg.replace_token

3114: ,30
3115: ,' '
3116: )
3117: );
3118: l_source_rec_field_assgn := xla_cmp_string_pkg.replace_token
3119: (
3120: l_source_rec_field_assgn
3121: ,'$SOURCE_CODE_RIGHT$'
3122: ,LOWER(source_rec.source_code)

Line 3156: l_source_proc_param_declar := xla_cmp_string_pkg.replace_token

3152: END IF;
3153:
3154: END CASE;
3155:
3156: l_source_proc_param_declar := xla_cmp_string_pkg.replace_token
3157: (
3158: l_source_proc_param_declar
3159: ,'$SOURCE_GENERIC_DATATYPE$'
3160: ,RPAD( l_datatype_generic_declar

Line 3189: l_write_proc_impl := xla_cmp_string_pkg.replace_token

3185: END IF;
3186: END LOOP;
3187:
3188: --replace the source parameter declarations
3189: l_write_proc_impl := xla_cmp_string_pkg.replace_token
3190: (
3191: l_write_proc_impl
3192: ,'$SOURCE_PROC_PARAM_DECLARATIONS$'
3193: ,NVL(l_source_proc_param_declars, ' ')

Line 3197: l_write_proc_impl := xla_cmp_string_pkg.replace_token

3193: ,NVL(l_source_proc_param_declars, ' ')
3194: );
3195:
3196: --replace the source field assignments
3197: l_write_proc_impl := xla_cmp_string_pkg.replace_token
3198: (
3199: l_write_proc_impl
3200: ,'$SOURCE_REC_FIELD_ASSIGNMENTS$'
3201: ,NVL(l_source_rec_field_assgns, ' ')

Line 3204: l_write_proc_impl := xla_cmp_string_pkg.replace_token

3200: ,'$SOURCE_REC_FIELD_ASSIGNMENTS$'
3201: ,NVL(l_source_rec_field_assgns, ' ')
3202: );
3203: --replace the affixes
3204: l_write_proc_impl := xla_cmp_string_pkg.replace_token
3205: (
3206: l_write_proc_impl
3207: ,'$OBJECT_NAME_AFFIX$'
3208: ,CASE

Line 3404: l_global_table_name := xla_cmp_string_pkg.replace_token

3400: --build the global temporary table name
3401: --get the template for the table name
3402: l_global_table_name := C_TMPL_TAB_GLOBAL_TABLE_NAME;
3403: --replace the product abbreviation
3404: l_global_table_name := xla_cmp_string_pkg.replace_token
3405: (
3406: l_global_table_name
3407: ,'$PRODUCT_ABBR$'
3408: ,g_application_info.product_abbreviation

Line 3411: l_global_table_name := xla_cmp_string_pkg.replace_token

3407: ,'$PRODUCT_ABBR$'
3408: ,g_application_info.product_abbreviation
3409: );
3410: --replace the object_name_affix
3411: l_global_table_name := xla_cmp_string_pkg.replace_token
3412: (
3413: l_global_table_name
3414: ,'$OBJECT_NAME_AFFIX$'
3415: ,CASE

Line 3425: l_plsql_table_name := xla_cmp_string_pkg.replace_token

3421: --build the plsql table name
3422: --get the template for the table name
3423: l_plsql_table_name := C_TMPL_TAB_PLSQL_TABLE_NAME;
3424: --replace the product abbreviation
3425: l_plsql_table_name := xla_cmp_string_pkg.replace_token
3426: (
3427: l_plsql_table_name
3428: ,'$PRODUCT_ABBR$'
3429: ,g_application_info.product_abbreviation

Line 3432: l_plsql_table_name := xla_cmp_string_pkg.replace_token

3428: ,'$PRODUCT_ABBR$'
3429: ,g_application_info.product_abbreviation
3430: );
3431: --replace the object_name_affix
3432: l_plsql_table_name := xla_cmp_string_pkg.replace_token
3433: (
3434: l_plsql_table_name
3435: ,'$OBJECT_NAME_AFFIX$'
3436: ,CASE

Line 3759: l_table_creation_text := xla_cmp_string_pkg.replace_token

3755:
3756: --get the table creation template
3757: l_table_creation_text := C_TMPL_TAB_GLOBAL_TEMP_TABLE;
3758: --replace the oracle user name
3759: l_table_creation_text := xla_cmp_string_pkg.replace_token
3760: (
3761: l_table_creation_text
3762: ,'$ORACLE_USER_NAME$'
3763: ,g_application_info.oracle_username

Line 3766: l_table_creation_text := xla_cmp_string_pkg.replace_token

3762: ,'$ORACLE_USER_NAME$'
3763: ,g_application_info.oracle_username
3764: );
3765: --replace the global table name
3766: l_table_creation_text := xla_cmp_string_pkg.replace_token
3767: (
3768: l_table_creation_text
3769: ,'$GLOBAL_TABLE_NAME$'
3770: ,l_global_table_name

Line 3838: l_source_table_field_declar := xla_cmp_string_pkg.replace_token

3834: --get the template for the source record field declaration
3835: l_source_table_field_declar := C_TMPL_SOURCE_TABLE_FIELD_DECL;
3836:
3837: --replace the source code
3838: l_source_table_field_declar := xla_cmp_string_pkg.replace_token
3839: (
3840: l_source_table_field_declar
3841: ,'$SOURCE_CODE$'
3842: ,RPAD( source_rec.source_code

Line 3874: l_source_table_field_declar := xla_cmp_string_pkg.replace_token

3870: END IF;
3871:
3872: END CASE;
3873:
3874: l_source_table_field_declar := xla_cmp_string_pkg.replace_token
3875: (
3876: l_source_table_field_declar
3877: ,'$SOURCE_SPECIFIC_DATATYPE$'
3878: ,RPAD( l_datatype_specific_declar

Line 3898: l_table_creation_text := xla_cmp_string_pkg.replace_token

3894: END IF;
3895: END LOOP;
3896:
3897: --replace the source field declarations token
3898: l_table_creation_text := xla_cmp_string_pkg.replace_token
3899: (
3900: l_table_creation_text
3901: ,'$SOURCE_TABLE_FIELD_DECLARATIONS$'
3902: ,NVL(l_source_table_field_declars, ' ')

Line 4408: l_write_proc_name := xla_cmp_string_pkg.replace_token

4404: RAISE le_fatal_error;
4405: END IF;
4406:
4407: --Build the proc names
4408: l_write_proc_name := xla_cmp_string_pkg.replace_token
4409: (
4410: C_TMPL_TAB_WRITE_PROC_NAME
4411: ,'$OBJECT_NAME_AFFIX$'
4412: ,CASE

Line 4418: l_read_proc_name := xla_cmp_string_pkg.replace_token

4414: ELSE '_' || l_object_name_affix
4415: END
4416: );
4417:
4418: l_read_proc_name := xla_cmp_string_pkg.replace_token
4419: (
4420: C_TMPL_TAB_READ_PROC_NAME
4421: ,'$OBJECT_NAME_AFFIX$'
4422: ,CASE