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_AAD_MERGE_PVT dependencies on XLA_ACCTG_METHOD_RULES

Line 6104: FROM xla_acctg_method_rules w

6100: IS
6101: --Added the below cursor for bug 14359104
6102: CURSOR c_slam IS
6103: SELECT s.accounting_method_type_code, s.accounting_method_code, s.product_rule_type_code, s.product_rule_code
6104: FROM xla_acctg_method_rules w
6105: , xla_acctg_method_rules s
6106: WHERE s.application_id = g_application_id
6107: AND s.amb_context_code = g_staging_context_code
6108: AND s.accounting_method_type_code = w.accounting_method_type_code

Line 6105: , xla_acctg_method_rules s

6101: --Added the below cursor for bug 14359104
6102: CURSOR c_slam IS
6103: SELECT s.accounting_method_type_code, s.accounting_method_code, s.product_rule_type_code, s.product_rule_code
6104: FROM xla_acctg_method_rules w
6105: , xla_acctg_method_rules s
6106: WHERE s.application_id = g_application_id
6107: AND s.amb_context_code = g_staging_context_code
6108: AND s.accounting_method_type_code = w.accounting_method_type_code
6109: AND s.accounting_method_code = w.accounting_method_code

Line 6145: DELETE FROM xla_acctg_method_rules w

6141:
6142: IF (l_product_rule_code.COUNT > 0) THEN
6143:
6144: FORALL i IN 1..l_acct_method_code.COUNT
6145: DELETE FROM xla_acctg_method_rules w
6146: WHERE amb_context_code = g_amb_context_code
6147: AND application_id = g_application_id
6148: AND accounting_method_type_code = l_acct_method_type_code(i)
6149: AND accounting_method_code = l_acct_method_code(i)

Line 6165: p_encoded_message => '# xla_acctg_method_rules delete : '||l_num_rows,

6161: p_amb_context_code => g_amb_context_code,
6162: p_application_id => g_application_id,
6163: p_request_code => 'IMPORT' ,
6164: p_log_type_code => 'MERGE',
6165: p_encoded_message => '# xla_acctg_method_rules delete : '||l_num_rows,
6166: p_component_code => 'merge_acctg_methods');
6167:
6168:
6169: end if;

Line 6172: UPDATE xla_acctg_method_rules

6168:
6169: end if;
6170:
6171: -- Move the SLAM from staging area to working area
6172: UPDATE xla_acctg_method_rules
6173: SET amb_context_code = g_amb_context_code
6174: WHERE amb_context_code = g_staging_context_code
6175: AND application_id = g_application_id;
6176: l_num_rows := SQL%ROWCOUNT;

Line 6190: p_encoded_message => '# xla_acctg_method_rules update : '||l_num_rows,

6186: p_amb_context_code => g_amb_context_code,
6187: p_application_id => g_application_id,
6188: p_request_code => 'IMPORT' ,
6189: p_log_type_code => 'MERGE',
6190: p_encoded_message => '# xla_acctg_method_rules update : '||l_num_rows,
6191: p_component_code => 'merge_acctg_methods');
6192: /********* End of Code Change for Bug 14359104 ************************/
6193:
6194: INSERT INTO xla_acctg_methods_b

Line 6284: UPDATE xla_acctg_method_rules xamr

6280: p_log_type_code => 'MERGE',
6281: p_encoded_message => '# row inserted in xla_acctg_methods_tl = '||l_num_rows,
6282: p_component_code => 'merge_acctg_methods');
6283:
6284: UPDATE xla_acctg_method_rules xamr
6285: SET amb_context_code = g_amb_context_code
6286: WHERE amb_context_code = g_staging_context_code
6287: AND NOT EXISTS (SELECT 1
6288: FROM xla_acctg_method_rules xamr2

Line 6288: FROM xla_acctg_method_rules xamr2

6284: UPDATE xla_acctg_method_rules xamr
6285: SET amb_context_code = g_amb_context_code
6286: WHERE amb_context_code = g_staging_context_code
6287: AND NOT EXISTS (SELECT 1
6288: FROM xla_acctg_method_rules xamr2
6289: WHERE xamr2.amb_context_code = g_amb_context_code
6290: AND xamr2.accounting_method_type_code = xamr.accounting_method_type_code
6291: AND xamr2.accounting_method_code = xamr.accounting_method_code
6292: AND xamr2.application_id = g_application_id);

Line 6343: FROM xla_acctg_method_rules

6339: FROM (SELECT distinct product_rule_type_code
6340: , product_rule_code
6341: , accounting_method_type_code
6342: , accounting_method_code
6343: FROM xla_acctg_method_rules
6344: WHERE amb_context_code = g_staging_context_code);
6345: l_num_rows := SQL%ROWCOUNT;
6346: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6347: trace(p_msg => '# row inserted in xla_acctg_method_rules = '||l_num_rows,

Line 6347: trace(p_msg => '# row inserted in xla_acctg_method_rules = '||l_num_rows,

6343: FROM xla_acctg_method_rules
6344: WHERE amb_context_code = g_staging_context_code);
6345: l_num_rows := SQL%ROWCOUNT;
6346: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6347: trace(p_msg => '# row inserted in xla_acctg_method_rules = '||l_num_rows,
6348: p_module => l_log_module,
6349: p_level => C_LEVEL_STATEMENT);
6350: END IF;
6351: -- Bug : 9923803

Line 6358: p_encoded_message => '# row inserted in xla_acctg_method_rules = '||l_num_rows,

6354: p_amb_context_code => g_amb_context_code,
6355: p_application_id => g_application_id,
6356: p_request_code => 'IMPORT' ,
6357: p_log_type_code => 'MERGE',
6358: p_encoded_message => '# row inserted in xla_acctg_method_rules = '||l_num_rows,
6359: p_component_code => 'merge_acctg_methods');
6360: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
6361: trace(p_msg => 'END of procedure merge_acctg_methods',
6362: p_module => l_log_module,