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_COMMON_PKG

Line 1982: xla_cmp_common_pkg.dump_text

1978:
1979: --Dump the dynamic statement
1980: IF (xla_cmp_tad_pkg.C_LEVEL_STATEMENT >= xla_cmp_tad_pkg.g_log_level)
1981: THEN
1982: xla_cmp_common_pkg.dump_text
1983: (
1984: p_text => l_update_stmts_wrapper_text
1985: );
1986: END IF;

Line 3126: g_application_info xla_cmp_common_pkg.lt_application_info;

3122:
3123: --Set the message mode to use the message stack instead of raising an exception
3124: g_msg_mode CONSTANT VARCHAR2(1) := G_OA_MESSAGE;
3125:
3126: g_application_info xla_cmp_common_pkg.lt_application_info;
3127: g_user_name VARCHAR2(2000); --100 in the table
3128:
3129: --
3130:

Line 3313: --Retrieve and set the User Name (xla_cmp_common_pkg.get_user_name)

3309: END IF;
3310:
3311: l_return_value := TRUE;
3312: /*
3313: --Retrieve and set the User Name (xla_cmp_common_pkg.get_user_name)
3314: --Set the application id
3315: --Retrieve and set the Application Information (xla_cmp_common_pkg.get_application_info)
3316: --Build and set the Transaction Account Builder package name (get_tab_api_package_name)
3317: --Retrieve and set the object name affixes (get_distinct_affixes)

Line 3315: --Retrieve and set the Application Information (xla_cmp_common_pkg.get_application_info)

3311: l_return_value := TRUE;
3312: /*
3313: --Retrieve and set the User Name (xla_cmp_common_pkg.get_user_name)
3314: --Set the application id
3315: --Retrieve and set the Application Information (xla_cmp_common_pkg.get_application_info)
3316: --Build and set the Transaction Account Builder package name (get_tab_api_package_name)
3317: --Retrieve and set the object name affixes (get_distinct_affixes)
3318: */
3319: --Retrieve current user name

Line 3320: IF NOT xla_cmp_common_pkg.get_user_name

3316: --Build and set the Transaction Account Builder package name (get_tab_api_package_name)
3317: --Retrieve and set the object name affixes (get_distinct_affixes)
3318: */
3319: --Retrieve current user name
3320: IF NOT xla_cmp_common_pkg.get_user_name
3321: (
3322: p_user_id => g_user_id
3323: ,p_user_name => g_user_name
3324: )

Line 3336: IF NOT xla_cmp_common_pkg.get_application_info

3332: END IF;
3333: END IF;
3334:
3335: --Retrieve and set the application info
3336: IF NOT xla_cmp_common_pkg.get_application_info
3337: (
3338: p_application_id => p_application_id
3339: ,p_application_info => g_application_info
3340: )

Line 3547: lr_application_info xla_cmp_common_pkg.lt_application_info;

3543: IS
3544: l_return_value BOOLEAN;
3545:
3546: l_user_name VARCHAR2(30);
3547: lr_application_info xla_cmp_common_pkg.lt_application_info;
3548: l_amb_context_code VARCHAR2(30);
3549: i NUMBER;
3550: l_msg_count NUMBER;
3551: l_msg_data VARCHAR2(2000);

Line 3713: lr_application_info xla_cmp_common_pkg.lt_application_info;

3709: IS
3710: l_return_value BOOLEAN;
3711:
3712: l_user_name VARCHAR2(30);
3713: lr_application_info xla_cmp_common_pkg.lt_application_info;
3714: l_tad_coa_id NUMBER;
3715: l_count_missing_required_tat NUMBER;
3716: l_uncomp_tat_name VARCHAR2(80);
3717: l_tad_package_name VARCHAR2(30);

Line 3884: <> xla_cmp_common_pkg.G_COMPILE_STATUS_CODE_COMPILED

3880: WHERE xtat.application_id = p_application_id
3881: AND xtat.enabled_flag = 'Y'
3882: AND ( xtat.compile_status_code IS NULL
3883: OR xtat.compile_status_code
3884: <> xla_cmp_common_pkg.G_COMPILE_STATUS_CODE_COMPILED
3885: )
3886: AND ROWNUM = 1;
3887: EXCEPTION
3888: WHEN NO_DATA_FOUND

Line 4215: xla_cmp_common_pkg.G_COMPILE_STATUS_CODE_COMPILED

4211:
4212: --Update the compilation status of the TAD
4213: IF NOT update_tad_compilation_status
4214: ( p_compilation_status_code =>
4215: xla_cmp_common_pkg.G_COMPILE_STATUS_CODE_COMPILED
4216: ,p_application_id => p_application_id
4217: ,p_account_definition_code => p_account_definition_code
4218: ,p_account_definition_type_code => p_account_definition_type_code
4219: ,p_amb_context_code => p_amb_context_code

Line 4249: xla_cmp_common_pkg.G_COMPILE_STATUS_CODE_ERROR

4245: THEN
4246: --update the compilation status to error
4247: IF NOT update_tad_compilation_status
4248: ( p_compilation_status_code =>
4249: xla_cmp_common_pkg.G_COMPILE_STATUS_CODE_ERROR
4250: ,p_application_id => p_application_id
4251: ,p_account_definition_code => p_account_definition_code
4252: ,p_account_definition_type_code => p_account_definition_type_code
4253: ,p_amb_context_code => p_amb_context_code

Line 4564: l_package_spec_text:= xla_cmp_common_pkg.replace_token

4560: );
4561: */
4562:
4563: --replace the ADR functions declarations token
4564: l_package_spec_text:= xla_cmp_common_pkg.replace_token
4565: (
4566: p_original_text => l_package_spec_text
4567: ,p_token => '$TAD_ADR_FUNCT_SPECS$'
4568: ,p_replacement_text => p_adr_specs_text

Line 4981: l_package_body_text:= xla_cmp_common_pkg.replace_token

4977: --take the package body template
4978: l_package_body_text := C_TMPL_TAD_PACKAGE_BODY;
4979:
4980: --replace the ADR functions bodies token
4981: l_package_body_text:= xla_cmp_common_pkg.replace_token
4982: (
4983: p_original_text => l_package_body_text
4984: ,p_token => '$TAD_ADR_FUNCT_BODIES$'
4985: ,p_replacement_text => p_adr_bodies_text

Line 4989: l_package_body_text:= xla_cmp_common_pkg.replace_token

4985: ,p_replacement_text => p_adr_bodies_text
4986: );
4987:
4988: --replace the push interface data update statements token
4989: l_package_body_text:= xla_cmp_common_pkg.replace_token
4990: (
4991: p_original_text => l_package_body_text
4992: ,p_token => '$C_TMPL_PUSH_INTERF_DATA_STMTS$'
4993: ,p_replacement_text => NVL(l_push_interf_statements_text, ' ')

Line 4997: l_package_body_text:= xla_cmp_common_pkg.replace_token

4993: ,p_replacement_text => NVL(l_push_interf_statements_text, ' ')
4994: );
4995:
4996: --replace the pop interface data update statements token
4997: l_package_body_text:= xla_cmp_common_pkg.replace_token
4998: (
4999: p_original_text => l_package_body_text
5000: ,p_token => '$C_TMPL_POP_INTERF_DATA_STMTS$'
5001: ,p_replacement_text => NVL(l_pop_interf_statements_text, ' ')

Line 5005: l_package_body_text:= xla_cmp_common_pkg.replace_token

5001: ,p_replacement_text => NVL(l_pop_interf_statements_text, ' ')
5002: );
5003:
5004: --replace the update statements token
5005: l_package_body_text:= xla_cmp_common_pkg.replace_token
5006: (
5007: p_original_text => l_package_body_text
5008: ,p_token => '$C_TMPL_BATCH_CCID_SEG_UPD_STMTS$'
5009: ,p_replacement_text => NVL(l_update_statements_text, ' ')

Line 5013: l_package_body_text:= xla_cmp_common_pkg.replace_token

5009: ,p_replacement_text => NVL(l_update_statements_text, ' ')
5010: );
5011:
5012: --replace the ccid processing statements token
5013: l_package_body_text:= xla_cmp_common_pkg.replace_token
5014: (
5015: p_original_text => l_package_body_text
5016: ,p_token => '$C_TMPL_BATCH_BUILD_CCID_STMTS$'
5017: ,p_replacement_text => NVL(l_batch_ccid_proc_stmts_text, ' ')

Line 5031: l_package_body_text:= xla_cmp_common_pkg.replace_token

5027: );
5028: Introducing the following due to the bug 6354106
5029: */
5030:
5031: l_package_body_text:= xla_cmp_common_pkg.replace_token
5032: (
5033: p_original_text => l_package_body_text
5034: ,p_token => '$TAD_PACKAGE_NAME_1$'
5035: ,p_replacement_text => p_package_name

Line 5251: l_set_clause_text:= xla_cmp_common_pkg.replace_token

5247: --Chain the current case branch with the existing ones
5248: l_case_branches_text := l_case_branches_text || l_case_branch_text;
5249:
5250: --Replace the current case branches to the current set clause
5251: l_set_clause_text:= xla_cmp_common_pkg.replace_token
5252: (
5253: p_original_text => l_set_clause_text
5254: ,p_token => '$CASE_BRANCHES$'
5255: ,p_replacement_text => NVL(l_case_branches_text, ' ')

Line 5263: l_update_statement_text:= xla_cmp_common_pkg.replace_token

5259: l_set_clauses_text := l_set_clauses_text || l_set_clause_text;
5260:
5261: --Replace the accumulated update set clauses
5262: --in the current upd statement
5263: l_update_statement_text:= xla_cmp_common_pkg.replace_token
5264: (
5265: p_original_text => l_update_statement_text
5266: ,p_token => '$C_TMPL_SET_CLAUSES$'
5267: ,p_replacement_text => NVL(l_set_clauses_text, ' ')

Line 5326: l_set_clause_text:= xla_cmp_common_pkg.replace_token

5322: THEN
5323: --Chain the current case branch with the existing ones
5324: l_case_branches_text := l_case_branches_text || l_case_branch_text;
5325: --Replace the current case branches in the current set clause
5326: l_set_clause_text:= xla_cmp_common_pkg.replace_token
5327: (
5328: p_original_text => l_set_clause_text
5329: ,p_token => '$CASE_BRANCHES$'
5330: ,p_replacement_text => NVL(l_case_branches_text, ' ')

Line 5384: l_case_branch_text:= xla_cmp_common_pkg.replace_token

5380: --Get the TAT code of the current detail
5381: l_current_account_type_code := p_table_of_tad_details(i).account_type_code;
5382:
5383: --Replace the account type token in the new branch
5384: l_case_branch_text:= xla_cmp_common_pkg.replace_token
5385: (
5386: p_original_text => l_case_branch_text
5387: ,p_token => '$ACCOUNT_TYPE$'
5388: ,p_replacement_text => NVL(l_current_account_type_code, ' ')

Line 5463: l_set_clause_text:= xla_cmp_common_pkg.replace_token

5459: --Add the case branch text to the existing ones
5460: l_case_branches_text := l_case_branches_text || l_case_branch_text;
5461:
5462: --Replace the current case branches in the current set clause
5463: l_set_clause_text:= xla_cmp_common_pkg.replace_token
5464: (
5465: p_original_text => l_set_clause_text
5466: ,p_token => '$CASE_BRANCHES$'
5467: ,p_replacement_text => NVL(l_case_branches_text, ' ')

Line 5474: l_update_statement_text:= xla_cmp_common_pkg.replace_token

5470: --Concatenate the current set clause to the already existing ones
5471: l_set_clauses_text := l_set_clauses_text || l_set_clause_text;
5472:
5473: --Replace the accumulated update set clauses in the current upd statement
5474: l_update_statement_text:= xla_cmp_common_pkg.replace_token
5475: (
5476: p_original_text => l_update_statement_text
5477: ,p_token => '$C_TMPL_SET_CLAUSES$'
5478: ,p_replacement_text => NVL(l_set_clauses_text, ' ')