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_AAD_HDR_ACCT_ATTRS

Line 444: DELETE FROM xla_aad_hdr_acct_attrs w

440: p_log_type_code => 'MERGE',
441: p_encoded_message => '# xla_aad_header_ac_assgns deleted = '||l_num_rows,
442: p_component_code => 'clean_oracle_aads');
443:
444: DELETE FROM xla_aad_hdr_acct_attrs w
445: WHERE application_id = g_application_id
446: AND amb_context_code = g_amb_context_code
447: AND product_rule_type_code = C_OWNER_SYSTEM
448: AND NOT EXISTS

Line 450: FROM xla_aad_hdr_acct_attrs s

446: AND amb_context_code = g_amb_context_code
447: AND product_rule_type_code = C_OWNER_SYSTEM
448: AND NOT EXISTS
449: (SELECT 1
450: FROM xla_aad_hdr_acct_attrs s
451: WHERE s.application_id = g_application_id
452: AND s.amb_context_code = g_staging_context_code
453: AND s.product_rule_type_code = C_OWNER_SYSTEM
454: AND s.product_rule_code = w.product_rule_code

Line 461: trace(p_msg => '# xla_aad_hdr_acct_attrs deleted = '||l_num_rows,

457: AND s.accounting_attribute_code = w.accounting_attribute_code);
458: l_num_rows := SQL%ROWCOUNT;
459:
460: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
461: trace(p_msg => '# xla_aad_hdr_acct_attrs deleted = '||l_num_rows,
462: p_module => l_log_module,
463: p_level => C_LEVEL_STATEMENT);
464: END IF;
465:

Line 473: p_encoded_message => '# xla_aad_hdr_acct_attrs deleted = '||l_num_rows,

469: p_amb_context_code => g_amb_context_code,
470: p_application_id => g_application_id,
471: p_request_code => 'IMPORT' ,
472: p_log_type_code => 'MERGE',
473: p_encoded_message => '# xla_aad_hdr_acct_attrs deleted = '||l_num_rows,
474: p_component_code => 'clean_oracle_aads');
475:
476: DELETE FROM xla_prod_acct_headers w
477: WHERE application_id = g_application_id

Line 2241: 'XLA_AAD_HDR_ACCT_ATTRS'

2237: select product_rule_code ,
2238: event_class_code ,
2239: accounting_attribute_code,
2240: source_code,
2241: 'XLA_AAD_HDR_ACCT_ATTRS'
2242: from
2243: (select product_rule_code
2244: ,event_class_code
2245: ,accounting_attribute_code

Line 2247: ,'XLA_AAD_HDR_ACCT_ATTRS'

2243: (select product_rule_code
2244: ,event_class_code
2245: ,accounting_attribute_code
2246: ,source_code
2247: ,'XLA_AAD_HDR_ACCT_ATTRS'
2248: ,amb_context_code
2249: ,last_update_date
2250: ,nvl2(lag_date, decode(last_update_date,lag_date, 'True','False'),'False') flag
2251: from

Line 2256: ,'XLA_AAD_HDR_ACCT_ATTRS'

2252: (select product_rule_code
2253: ,event_class_code
2254: ,accounting_attribute_code
2255: ,source_code
2256: ,'XLA_AAD_HDR_ACCT_ATTRS'
2257: ,amb_context_code
2258: ,last_update_date
2259: ,lag(last_update_date) over (PARTITION by application_id
2260: ,product_rule_code

Line 2267: from XLA_AAD_HDR_ACCT_ATTRS

2263: ,accounting_attribute_code
2264: ,event_type_code
2265: order by amb_context_code
2266: ) lag_date
2267: from XLA_AAD_HDR_ACCT_ATTRS
2268: order by amb_context_code
2269: ) x
2270: where x.amb_context_code =g_staging_context_code
2271: )

Line 2276: trace(p_msg => 'Number of Rows inserted into aads_gt from xla_aad_hdr_acct_attrs is :'||l_num_rows,

2272: where flag = 'False';
2273: l_num_rows := SQL%ROWCOUNT;
2274:
2275: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2276: trace(p_msg => 'Number of Rows inserted into aads_gt from xla_aad_hdr_acct_attrs is :'||l_num_rows,
2277: p_module => l_log_module,
2278: p_level => C_LEVEL_PROCEDURE);
2279: END IF;
2280: -- Bug : 9923803

Line 2287: p_encoded_message =>'Number of Rows inserted into aads_gt from xla_aad_hdr_acct_attrs is :'||l_num_rows,

2283: p_amb_context_code => g_amb_context_code,
2284: p_application_id => g_application_id,
2285: p_request_code => 'IMPORT' ,
2286: p_log_type_code => 'MERGE',
2287: p_encoded_message =>'Number of Rows inserted into aads_gt from xla_aad_hdr_acct_attrs is :'||l_num_rows,
2288: p_component_code => 'merge_aads');
2289:
2290: INSERT INTO xla_aads_gt
2291: ( product_rule_code,

Line 2487: DELETE FROM xla_aad_hdr_acct_attrs w

2483: p_log_type_code => 'MERGE',
2484: p_encoded_message =>'# xla_aad_line_defn_assgns deleted : '||l_num_rows,
2485: p_component_code => 'merge_aads');
2486:
2487: DELETE FROM xla_aad_hdr_acct_attrs w
2488: WHERE application_id = g_application_id
2489: AND amb_context_code = g_amb_context_code
2490: AND EXISTS (SELECT 1
2491: FROM xla_aad_hdr_acct_attrs s

Line 2491: FROM xla_aad_hdr_acct_attrs s

2487: DELETE FROM xla_aad_hdr_acct_attrs w
2488: WHERE application_id = g_application_id
2489: AND amb_context_code = g_amb_context_code
2490: AND EXISTS (SELECT 1
2491: FROM xla_aad_hdr_acct_attrs s
2492: WHERE s.application_id = g_application_id
2493: AND s.amb_context_code = g_staging_context_code
2494: AND s.product_rule_type_code = w.product_rule_type_code
2495: AND s.product_rule_code = w.product_rule_code

Line 2645: UPDATE xla_aad_hdr_acct_attrs

2641: p_log_type_code => 'MERGE',
2642: p_encoded_message =>'# xla_aad_line_defn_assgns updated : '||l_num_rows,
2643: p_component_code => 'merge_aads');
2644:
2645: UPDATE xla_aad_hdr_acct_attrs
2646: SET amb_context_code = g_amb_context_code
2647: WHERE application_id = g_application_id
2648: AND amb_context_code = g_staging_context_code;
2649: l_num_rows := SQL%ROWCOUNT;

Line 2651: trace(p_msg => '# xla_aad_hdr_acct_attrs updated : '||l_num_rows,

2647: WHERE application_id = g_application_id
2648: AND amb_context_code = g_staging_context_code;
2649: l_num_rows := SQL%ROWCOUNT;
2650: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2651: trace(p_msg => '# xla_aad_hdr_acct_attrs updated : '||l_num_rows,
2652: p_module => l_log_module,
2653: p_level => C_LEVEL_STATEMENT);
2654: END IF;
2655: -- Bug : 9923803

Line 2662: p_encoded_message =>'# xla_aad_hdr_acct_attrs updated : '||l_num_rows,

2658: p_amb_context_code => g_amb_context_code,
2659: p_application_id => g_application_id,
2660: p_request_code => 'IMPORT' ,
2661: p_log_type_code => 'MERGE',
2662: p_encoded_message =>'# xla_aad_hdr_acct_attrs updated : '||l_num_rows,
2663: p_component_code => 'merge_aads');
2664:
2665: UPDATE xla_aad_header_ac_assgns
2666: SET amb_context_code = g_amb_context_code