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_PROD_ACCT_HEADERS

Line 476: DELETE FROM xla_prod_acct_headers w

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
478: AND amb_context_code = g_amb_context_code
479: AND product_rule_type_code = C_OWNER_SYSTEM
480: AND NOT EXISTS

Line 482: FROM xla_prod_acct_headers s

478: AND amb_context_code = g_amb_context_code
479: AND product_rule_type_code = C_OWNER_SYSTEM
480: AND NOT EXISTS
481: (SELECT 1
482: FROM xla_prod_acct_headers s
483: WHERE s.application_id = g_application_id
484: AND s.amb_context_code = g_staging_context_code
485: AND s.product_rule_type_code = C_OWNER_SYSTEM
486: AND s.product_rule_code = w.product_rule_code

Line 491: trace(p_msg => '# xla_prod_acct_headers deleted = '||l_num_rows,

487: AND s.event_class_code = w.event_class_code
488: AND s.event_type_code = w.event_type_code);
489: l_num_rows := SQL%ROWCOUNT;
490: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
491: trace(p_msg => '# xla_prod_acct_headers deleted = '||l_num_rows,
492: p_module => l_log_module,
493: p_level => C_LEVEL_STATEMENT);
494: END IF;
495: -- Bug : 9923803

Line 502: p_encoded_message => '# xla_prod_acct_headers deleted = '||l_num_rows,

498: p_amb_context_code => g_amb_context_code,
499: p_application_id => g_application_id,
500: p_request_code => 'IMPORT' ,
501: p_log_type_code => 'MERGE',
502: p_encoded_message => '# xla_prod_acct_headers deleted = '||l_num_rows,
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

Line 1321: UPDATE xla_prod_acct_headers

1317: p_encoded_message => '# xla_line_defn_jlt_assgns clear description = '||l_num_rows,
1318: p_component_code => 'clean_oracle_descriptions');
1319:
1320: FORALL i IN 1..l_codes.COUNT
1321: UPDATE xla_prod_acct_headers
1322: SET description_type_code = NULL
1323: , description_code = NULL
1324: WHERE application_id = g_application_id
1325: AND amb_context_code = g_amb_context_code

Line 1330: trace(p_msg => '# xla_prod_acct_headers clear description = '||l_num_rows,

1326: AND description_type_code = C_OWNER_SYSTEM
1327: AND description_code = l_codes(i);
1328: l_num_rows := SQL%ROWCOUNT;
1329: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1330: trace(p_msg => '# xla_prod_acct_headers clear description = '||l_num_rows,
1331: p_module => l_log_module,
1332: p_level => C_LEVEL_STATEMENT);
1333: END IF;
1334:

Line 1342: p_encoded_message => '# xla_prod_acct_headers clear description = '||l_num_rows,

1338: p_amb_context_code => g_amb_context_code,
1339: p_application_id => g_application_id,
1340: p_request_code => 'IMPORT' ,
1341: p_log_type_code => 'MERGE',
1342: p_encoded_message => '# xla_prod_acct_headers clear description = '||l_num_rows,
1343: p_component_code => 'clean_oracle_descriptions');
1344:
1345: FORALL i IN 1..l_codes.COUNT
1346: DELETE FROM xla_descript_details_tl w

Line 2431: DELETE FROM xla_prod_acct_headers w

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
2433: AND amb_context_code = g_amb_context_code
2434: AND EXISTS (SELECT 1
2435: FROM xla_prod_acct_headers s

Line 2435: FROM xla_prod_acct_headers s

2431: DELETE FROM xla_prod_acct_headers w
2432: WHERE application_id = g_application_id
2433: AND amb_context_code = g_amb_context_code
2434: AND EXISTS (SELECT 1
2435: FROM xla_prod_acct_headers s
2436: WHERE s.application_id = g_application_id
2437: AND s.amb_context_code = g_staging_context_code
2438: AND s.product_rule_type_code = w.product_rule_type_code
2439: AND s.product_rule_code = w.product_rule_code

Line 2444: trace(p_msg => '# xla_prod_acct_headers deleted : '||l_num_rows,

2440: AND s.event_class_code = w.event_class_code
2441: AND s.event_type_code = w.event_type_code);
2442: l_num_rows := SQL%ROWCOUNT;
2443: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2444: trace(p_msg => '# xla_prod_acct_headers deleted : '||l_num_rows,
2445: p_module => l_log_module,
2446: p_level => C_LEVEL_STATEMENT);
2447: END IF;
2448: -- Bug : 9923803

Line 2455: p_encoded_message =>'# xla_prod_acct_headers deleted : '||l_num_rows,

2451: p_amb_context_code => g_amb_context_code,
2452: p_application_id => g_application_id,
2453: p_request_code => 'IMPORT' ,
2454: p_log_type_code => 'MERGE',
2455: p_encoded_message =>'# xla_prod_acct_headers deleted : '||l_num_rows,
2456: p_component_code => 'merge_aads');
2457:
2458: DELETE FROM xla_aad_line_defn_assgns w
2459: WHERE application_id = g_application_id

Line 2605: UPDATE xla_prod_acct_headers

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
2608: AND amb_context_code = g_staging_context_code;
2609: l_num_rows := SQL%ROWCOUNT;

Line 2611: trace(p_msg => '# xla_prod_acct_headers updated : '||l_num_rows,

2607: WHERE application_id = g_application_id
2608: AND amb_context_code = g_staging_context_code;
2609: l_num_rows := SQL%ROWCOUNT;
2610: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2611: trace(p_msg => '# xla_prod_acct_headers updated : '||l_num_rows,
2612: p_module => l_log_module,
2613: p_level => C_LEVEL_STATEMENT);
2614: END IF;
2615: -- Bug : 9923803

Line 2622: p_encoded_message =>'# xla_prod_acct_headers updated : '||l_num_rows,

2618: p_amb_context_code => g_amb_context_code,
2619: p_application_id => g_application_id,
2620: p_request_code => 'IMPORT' ,
2621: p_log_type_code => 'MERGE',
2622: p_encoded_message =>'# xla_prod_acct_headers updated : '||l_num_rows,
2623: p_component_code => 'merge_aads');
2624:
2625: UPDATE xla_aad_line_defn_assgns
2626: SET amb_context_code = g_amb_context_code