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_LINE_DEFN_ASSGNS

Line 377: DELETE FROM xla_aad_line_defn_assgns w

373: ,xla_environment_pkg.g_prog_id
374: ,xla_environment_pkg.g_req_Id);
375:
376: -- Delete JLD aasignment that is no longer assigned to the header
377: DELETE FROM xla_aad_line_defn_assgns w
378: WHERE application_id = g_application_id
379: AND amb_context_code = g_amb_context_code
380: AND product_rule_type_code = C_OWNER_SYSTEM
381: AND NOT EXISTS

Line 383: FROM xla_aad_line_defn_assgns s

379: AND amb_context_code = g_amb_context_code
380: AND product_rule_type_code = C_OWNER_SYSTEM
381: AND NOT EXISTS
382: (SELECT 1
383: FROM xla_aad_line_defn_assgns s
384: WHERE s.application_id = g_application_id
385: AND s.amb_context_code = g_staging_context_code
386: AND s.product_rule_type_code = C_OWNER_SYSTEM
387: AND s.product_rule_code = w.product_rule_code

Line 396: trace(p_msg => '# xla_aad_line_defn_assgns deleted = '||l_num_rows,

392:
393: l_num_rows := SQL%ROWCOUNT;
394:
395: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
396: trace(p_msg => '# xla_aad_line_defn_assgns deleted = '||l_num_rows,
397: p_module => l_log_module,
398: p_level => C_LEVEL_STATEMENT);
399: END IF;
400: -- Bug : 9923803

Line 407: p_encoded_message => '# xla_aad_line_defn_assgns deleted = '||l_num_rows,

403: p_amb_context_code => g_amb_context_code,
404: p_application_id => g_application_id,
405: p_request_code => 'IMPORT' ,
406: p_log_type_code => 'MERGE',
407: p_encoded_message => '# xla_aad_line_defn_assgns deleted = '||l_num_rows,
408: p_component_code => 'clean_oracle_aads');
409:
410: -- Delete AC assignment that is no longer assigned to the header
411: DELETE FROM xla_aad_header_ac_assgns w

Line 630: DELETE FROM xla_aad_line_defn_assgns w

626: END IF;
627:
628: -- Delete JLD assignment for those JLD no longer exist
629: FORALL i IN 1..l_codes.COUNT
630: DELETE FROM xla_aad_line_defn_assgns w
631: WHERE application_id = g_application_id
632: AND amb_context_code = g_amb_context_code
633: AND event_class_code = l_event_class_codes(i)
634: AND event_type_code = l_event_type_codes(i)

Line 639: trace(p_msg => '# xla_aad_line_defn_assgns deleted = '||l_num_rows,

635: AND line_definition_owner_code = C_OWNER_SYSTEM
636: AND line_definition_code = l_codes(i);
637: l_num_rows := SQL%ROWCOUNT;
638: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
639: trace(p_msg => '# xla_aad_line_defn_assgns deleted = '||l_num_rows,
640: p_module => l_log_module,
641: p_level => C_LEVEL_STATEMENT);
642: END IF;
643: -- Bug : 9923803

Line 650: p_encoded_message => '# xla_aad_line_defn_assgns deleted = '||l_num_rows,

646: p_amb_context_code => g_amb_context_code,
647: p_application_id => g_application_id,
648: p_request_code => 'IMPORT' ,
649: p_log_type_code => 'MERGE',
650: p_encoded_message => '# xla_aad_line_defn_assgns deleted = '||l_num_rows,
651: p_component_code => 'clean_oracle_jlds');
652:
653: DELETE FROM xla_line_defn_ac_assgns w
654: WHERE application_id = g_application_id

Line 2182: 'XLA_AAD_LINE_DEFN_ASSGNS'

2178: select product_rule_code ,
2179: event_class_code ,
2180: event_type_code ,
2181: line_definition_code ,
2182: 'XLA_AAD_LINE_DEFN_ASSGNS'
2183: from (select product_rule_code ,
2184: event_class_code ,
2185: event_type_code ,
2186: line_definition_code ,

Line 2187: 'XLA_AAD_LINE_DEFN_ASSGNS' ,

2183: from (select product_rule_code ,
2184: event_class_code ,
2185: event_type_code ,
2186: line_definition_code ,
2187: 'XLA_AAD_LINE_DEFN_ASSGNS' ,
2188: amb_context_code,
2189: last_update_date ,
2190: nvl2(lag_date, decode(last_update_date,lag_date, 'True','False'),'False') flag
2191: from

Line 2196: 'XLA_AAD_LINE_DEFN_ASSGNS' ,

2192: (select product_rule_code ,
2193: event_class_code ,
2194: event_type_code ,
2195: line_definition_code ,
2196: 'XLA_AAD_LINE_DEFN_ASSGNS' ,
2197: amb_context_code,
2198: last_update_date ,
2199: lag(last_update_date) over (PARTITION by application_id,
2200: product_rule_code,

Line 2208: from XLA_AAD_LINE_DEFN_ASSGNS

2204: line_definition_code,
2205: line_definition_owner_code
2206: order by amb_context_code
2207: ) lag_date
2208: from XLA_AAD_LINE_DEFN_ASSGNS
2209: order by amb_context_code
2210: ) x
2211: where x.amb_context_code =g_staging_context_code
2212: )

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

2212: )
2213: where flag = 'False';
2214: l_num_rows := SQL%ROWCOUNT;
2215: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2216: trace(p_msg => 'Number of Rows inserted into aads_gt from xla_aad_line_defn_assgns is :'||l_num_rows,
2217: p_module => l_log_module,
2218: p_level => C_LEVEL_PROCEDURE);
2219: END IF;
2220: -- Bug : 9923803

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

2223: p_amb_context_code => g_amb_context_code,
2224: p_application_id => g_application_id,
2225: p_request_code => 'IMPORT' ,
2226: p_log_type_code => 'MERGE',
2227: p_encoded_message =>'Number of Rows inserted into aads_gt from xla_aad_line_defn_assgns is :'||l_num_rows,
2228: p_component_code => 'merge_aads');
2229:
2230: INSERT INTO xla_aads_gt
2231: ( product_rule_code,

Line 2458: DELETE FROM xla_aad_line_defn_assgns w

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
2460: AND amb_context_code = g_amb_context_code
2461: AND EXISTS (SELECT 1
2462: FROM xla_aad_line_defn_assgns s

Line 2462: FROM xla_aad_line_defn_assgns s

2458: DELETE FROM xla_aad_line_defn_assgns w
2459: WHERE application_id = g_application_id
2460: AND amb_context_code = g_amb_context_code
2461: AND EXISTS (SELECT 1
2462: FROM xla_aad_line_defn_assgns s
2463: WHERE s.application_id = g_application_id
2464: AND s.amb_context_code = g_staging_context_code
2465: AND s.product_rule_type_code = w.product_rule_type_code
2466: AND s.product_rule_code = w.product_rule_code

Line 2473: trace(p_msg => '# xla_aad_line_defn_assgns deleted : '||l_num_rows,

2469: AND s.line_definition_owner_code = w.line_definition_owner_code
2470: AND s.line_definition_code = w.line_definition_code);
2471: l_num_rows := SQL%ROWCOUNT;
2472: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2473: trace(p_msg => '# xla_aad_line_defn_assgns deleted : '||l_num_rows,
2474: p_module => l_log_module,
2475: p_level => C_LEVEL_STATEMENT);
2476: END IF;
2477: -- Bug : 9923803

Line 2484: p_encoded_message =>'# xla_aad_line_defn_assgns deleted : '||l_num_rows,

2480: p_amb_context_code => g_amb_context_code,
2481: p_application_id => g_application_id,
2482: p_request_code => 'IMPORT' ,
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

Line 2625: UPDATE xla_aad_line_defn_assgns

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
2627: WHERE application_id = g_application_id
2628: AND amb_context_code = g_staging_context_code;
2629: l_num_rows := SQL%ROWCOUNT;

Line 2631: trace(p_msg => '# xla_aad_line_defn_assgns updated : '||l_num_rows,

2627: WHERE application_id = g_application_id
2628: AND amb_context_code = g_staging_context_code;
2629: l_num_rows := SQL%ROWCOUNT;
2630: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2631: trace(p_msg => '# xla_aad_line_defn_assgns updated : '||l_num_rows,
2632: p_module => l_log_module,
2633: p_level => C_LEVEL_STATEMENT);
2634: END IF;
2635: -- Bug : 9923803

Line 2642: p_encoded_message =>'# xla_aad_line_defn_assgns updated : '||l_num_rows,

2638: p_amb_context_code => g_amb_context_code,
2639: p_application_id => g_application_id,
2640: p_request_code => 'IMPORT' ,
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