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_PRODUCT_RULES_TL

Line 201: , xla_product_rules_tl t

197: SELECT distinct t.name
198: FROM xla_product_rules_b w
199: , xla_product_rules_b s
200: , xla_staging_components_h h
201: , xla_product_rules_tl t
202: WHERE w.version_num > h.version_num
203: AND w.amb_context_code = g_amb_context_code
204: AND w.application_id = g_application_id
205: AND w.product_rule_type_code = s.product_rule_type_code

Line 507: DELETE FROM xla_product_rules_tl w

503: p_component_code => 'clean_oracle_aads');
504:
505: -- Delete AAD that is not in the staging area
506: FORALL i IN 1..l_codes.COUNT
507: DELETE FROM xla_product_rules_tl w
508: WHERE application_id = g_application_id
509: AND amb_context_code = g_amb_context_code
510: AND product_rule_type_code = C_OWNER_SYSTEM
511: AND product_rule_code = l_codes(i);

Line 514: trace(p_msg => '# xla_product_rules_tl deleted = '||l_num_rows,

510: AND product_rule_type_code = C_OWNER_SYSTEM
511: AND product_rule_code = l_codes(i);
512: l_num_rows := SQL%ROWCOUNT;
513: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
514: trace(p_msg => '# xla_product_rules_tl deleted = '||l_num_rows,
515: p_module => l_log_module,
516: p_level => C_LEVEL_STATEMENT);
517: END IF;
518: -- Bug : 9923803

Line 525: p_encoded_message => '# xla_product_rules_tl deleted = '||l_num_rows,

521: p_amb_context_code => g_amb_context_code,
522: p_application_id => g_application_id,
523: p_request_code => 'IMPORT' ,
524: p_log_type_code => 'MERGE',
525: p_encoded_message => '# xla_product_rules_tl deleted = '||l_num_rows,
526: p_component_code => 'clean_oracle_aads');
527:
528: FORALL i IN 1..l_codes.COUNT
529: DELETE FROM xla_product_rules_b w

Line 2405: DELETE FROM xla_product_rules_tl w

2401: p_log_type_code => 'MERGE',
2402: p_encoded_message =>'# xla_product_rules_b deleted : '||l_num_rows,
2403: p_component_code => 'merge_aads');
2404:
2405: DELETE FROM xla_product_rules_tl w
2406: WHERE application_id = g_application_id
2407: AND amb_context_code = g_amb_context_code
2408: AND EXISTS (SELECT 1
2409: FROM xla_product_rules_tl s

Line 2409: FROM xla_product_rules_tl s

2405: DELETE FROM xla_product_rules_tl w
2406: WHERE application_id = g_application_id
2407: AND amb_context_code = g_amb_context_code
2408: AND EXISTS (SELECT 1
2409: FROM xla_product_rules_tl s
2410: WHERE s.application_id = g_application_id
2411: AND s.amb_context_code = g_staging_context_code
2412: AND s.product_rule_type_code = w.product_rule_type_code
2413: AND s.product_rule_code = w.product_rule_code

Line 2417: trace(p_msg => '# xla_product_rules_tl deleted : '||l_num_rows,

2413: AND s.product_rule_code = w.product_rule_code
2414: AND s.language = w.language);
2415: l_num_rows := SQL%ROWCOUNT;
2416: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2417: trace(p_msg => '# xla_product_rules_tl deleted : '||l_num_rows,
2418: p_module => l_log_module,
2419: p_level => C_LEVEL_STATEMENT);
2420: END IF;
2421: -- Bug : 9923803

Line 2428: p_encoded_message =>'# xla_product_rules_tl deleted : '||l_num_rows,

2424: p_amb_context_code => g_amb_context_code,
2425: p_application_id => g_application_id,
2426: p_request_code => 'IMPORT' ,
2427: p_log_type_code => 'MERGE',
2428: p_encoded_message =>'# xla_product_rules_tl deleted : '||l_num_rows,
2429: p_component_code => 'merge_aads');
2430:
2431: DELETE FROM xla_prod_acct_headers w
2432: WHERE application_id = g_application_id

Line 2551: UPDATE xla_product_rules_tl w

2547: p_log_type_code => 'MERGE',
2548: p_encoded_message =>'# xla_product_rules_b updated : '||l_num_rows,
2549: p_component_code => 'merge_aads');
2550:
2551: UPDATE xla_product_rules_tl w
2552: SET amb_context_code = g_amb_context_code
2553: WHERE application_id = g_application_id
2554: AND amb_context_code = g_staging_context_code
2555: AND NOT EXISTS (SELECT 1

Line 2556: FROM xla_product_rules_tl s

2552: SET amb_context_code = g_amb_context_code
2553: WHERE application_id = g_application_id
2554: AND amb_context_code = g_staging_context_code
2555: AND NOT EXISTS (SELECT 1
2556: FROM xla_product_rules_tl s
2557: WHERE s.application_id = g_application_id
2558: AND s.amb_context_code = g_amb_context_code
2559: AND s.product_rule_type_code = w.product_rule_type_code
2560: AND s.name = w.name

Line 2564: trace(p_msg => '# xla_product_rules_tl 1 updated : '||l_num_rows,

2560: AND s.name = w.name
2561: AND s.language = w.language);
2562: l_num_rows := SQL%ROWCOUNT;
2563: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2564: trace(p_msg => '# xla_product_rules_tl 1 updated : '||l_num_rows,
2565: p_module => l_log_module,
2566: p_level => C_LEVEL_STATEMENT);
2567: END IF;
2568: -- Bug : 9923803

Line 2575: p_encoded_message =>'# xla_product_rules_tl 1 updated : '||l_num_rows,

2571: p_amb_context_code => g_amb_context_code,
2572: p_application_id => g_application_id,
2573: p_request_code => 'IMPORT' ,
2574: p_log_type_code => 'MERGE',
2575: p_encoded_message =>'# xla_product_rules_tl 1 updated : '||l_num_rows,
2576: p_component_code => 'merge_aads');
2577:
2578: UPDATE xla_product_rules_tl w
2579: SET amb_context_code = g_amb_context_code

Line 2578: UPDATE xla_product_rules_tl w

2574: p_log_type_code => 'MERGE',
2575: p_encoded_message =>'# xla_product_rules_tl 1 updated : '||l_num_rows,
2576: p_component_code => 'merge_aads');
2577:
2578: UPDATE xla_product_rules_tl w
2579: SET amb_context_code = g_amb_context_code
2580: , name = substr('('||product_rule_code||') '||name,1,80)
2581: WHERE application_id = g_application_id
2582: AND amb_context_code = g_staging_context_code

Line 2584: FROM xla_product_rules_tl s

2580: , name = substr('('||product_rule_code||') '||name,1,80)
2581: WHERE application_id = g_application_id
2582: AND amb_context_code = g_staging_context_code
2583: AND EXISTS (SELECT 1
2584: FROM xla_product_rules_tl s
2585: WHERE s.application_id = g_application_id
2586: AND s.amb_context_code = g_amb_context_code
2587: AND s.product_rule_type_code = w.product_rule_type_code
2588: AND s.name = w.name

Line 2592: trace(p_msg => '# xla_product_rules_tl 2 updated : '||l_num_rows,

2588: AND s.name = w.name
2589: AND s.language = w.language);
2590: l_num_rows := SQL%ROWCOUNT;
2591: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2592: trace(p_msg => '# xla_product_rules_tl 2 updated : '||l_num_rows,
2593: p_module => l_log_module,
2594: p_level => C_LEVEL_STATEMENT);
2595: END IF;
2596: -- Bug : 9923803

Line 2603: p_encoded_message =>'# xla_product_rules_tl 2 updated : '||l_num_rows,

2599: p_amb_context_code => g_amb_context_code,
2600: p_application_id => g_application_id,
2601: p_request_code => 'IMPORT' ,
2602: p_log_type_code => 'MERGE',
2603: p_encoded_message =>'# xla_product_rules_tl 2 updated : '||l_num_rows,
2604: p_component_code => 'merge_aads');
2605: UPDATE xla_prod_acct_headers
2606: SET amb_context_code = g_amb_context_code
2607: WHERE application_id = g_application_id