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_HEADER_AC_ASSGNS

Line 411: DELETE FROM xla_aad_header_ac_assgns w

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
412: WHERE application_id = g_application_id
413: AND amb_context_code = g_amb_context_code
414: AND product_rule_type_code = C_OWNER_SYSTEM
415: AND NOT EXISTS

Line 417: FROM xla_aad_header_ac_assgns s

413: AND amb_context_code = g_amb_context_code
414: AND product_rule_type_code = C_OWNER_SYSTEM
415: AND NOT EXISTS
416: (SELECT 1
417: FROM xla_aad_header_ac_assgns s
418: WHERE s.application_id = g_application_id
419: AND s.amb_context_code = g_staging_context_code
420: AND s.product_rule_type_code = C_OWNER_SYSTEM
421: AND s.product_rule_code = w.product_rule_code

Line 429: trace(p_msg => '# xla_aad_header_ac_assgns deleted = '||l_num_rows,

425: AND s.analytical_criterion_code = w.analytical_criterion_code);
426:
427: l_num_rows := SQL%ROWCOUNT;
428: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
429: trace(p_msg => '# xla_aad_header_ac_assgns deleted = '||l_num_rows,
430: p_module => l_log_module,
431: p_level => C_LEVEL_STATEMENT);
432: END IF;
433:

Line 441: p_encoded_message => '# xla_aad_header_ac_assgns deleted = '||l_num_rows,

437: p_amb_context_code => g_amb_context_code,
438: p_application_id => g_application_id,
439: p_request_code => 'IMPORT' ,
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

Line 1830: DELETE FROM xla_aad_header_ac_assgns w

1826: END IF;
1827:
1828: -- Delete reference to the AC
1829: FORALL i IN 1..l_codes.COUNT
1830: DELETE FROM xla_aad_header_ac_assgns w
1831: WHERE application_id = g_application_id
1832: AND amb_context_code = g_amb_context_code
1833: AND analytical_criterion_type_code = C_OWNER_SYSTEM
1834: AND analytical_criterion_code = l_codes(i);

Line 1837: trace(p_msg => '# xla_aad_header_ac_assgns deleted = '||SQL%ROWCOUNT,

1833: AND analytical_criterion_type_code = C_OWNER_SYSTEM
1834: AND analytical_criterion_code = l_codes(i);
1835:
1836: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1837: trace(p_msg => '# xla_aad_header_ac_assgns deleted = '||SQL%ROWCOUNT,
1838: p_module => l_log_module,
1839: p_level => C_LEVEL_STATEMENT);
1840: END IF;
1841:

Line 2301: 'XLA_AAD_HEADER_AC_ASSGNS'

2297: select product_rule_code,
2298: event_class_code,
2299: event_type_code,
2300: analytical_criterion_code,
2301: 'XLA_AAD_HEADER_AC_ASSGNS'
2302: from (select product_rule_code,
2303: event_class_code,
2304: event_type_code,
2305: analytical_criterion_code,

Line 2306: 'XLA_AAD_HEADER_AC_ASSGNS',

2302: from (select product_rule_code,
2303: event_class_code,
2304: event_type_code,
2305: analytical_criterion_code,
2306: 'XLA_AAD_HEADER_AC_ASSGNS',
2307: amb_context_code,
2308: last_update_date ,
2309: nvl2(lag_date, decode(last_update_date,lag_date, 'True','False'),'False') flag
2310: from

Line 2315: 'XLA_AAD_HEADER_AC_ASSGNS',

2311: (select product_rule_code,
2312: event_class_code,
2313: event_type_code,
2314: analytical_criterion_code,
2315: 'XLA_AAD_HEADER_AC_ASSGNS',
2316: amb_context_code,
2317: last_update_date ,
2318: lag(last_update_date) over (PARTITION by application_id,
2319: product_rule_code,

Line 2327: from XLA_AAD_HEADER_AC_ASSGNS

2323: analytical_criterion_code,
2324: analytical_criterion_type_code
2325: order by amb_context_code
2326: ) lag_date
2327: from XLA_AAD_HEADER_AC_ASSGNS
2328: order by amb_context_code
2329: ) x
2330: where x.amb_context_code =g_staging_context_code
2331: )

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

2332: where flag = 'False';
2333: l_num_rows := SQL%ROWCOUNT;
2334:
2335: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2336: trace(p_msg => 'Number of Rows inserted into aads_gt from xla_aad_header_ac_assgns is :'||l_num_rows,
2337: p_module => l_log_module,
2338: p_level => C_LEVEL_PROCEDURE);
2339: END IF;
2340: -- Bug : 9923803

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

2343: p_amb_context_code => g_amb_context_code,
2344: p_application_id => g_application_id,
2345: p_request_code => 'IMPORT' ,
2346: p_log_type_code => 'MERGE',
2347: p_encoded_message =>'Number of Rows inserted into aads_gt from xla_aad_header_ac_assgns is :'||l_num_rows,
2348: p_component_code => 'merge_aads');
2349:
2350:
2351: UPDATE xla_product_rules_b pr

Line 2500: DELETE FROM xla_aad_header_ac_assgns w

2496: AND s.event_class_code = w.event_class_code
2497: AND s.event_type_code = w.event_type_code
2498: AND s.accounting_attribute_code = w.accounting_attribute_code);
2499:
2500: DELETE FROM xla_aad_header_ac_assgns w
2501: WHERE application_id = g_application_id
2502: AND amb_context_code = g_amb_context_code
2503: AND EXISTS (SELECT 1
2504: FROM xla_aad_header_ac_assgns s

Line 2504: FROM xla_aad_header_ac_assgns s

2500: DELETE FROM xla_aad_header_ac_assgns w
2501: WHERE application_id = g_application_id
2502: AND amb_context_code = g_amb_context_code
2503: AND EXISTS (SELECT 1
2504: FROM xla_aad_header_ac_assgns s
2505: WHERE s.application_id = g_application_id
2506: AND s.amb_context_code = g_staging_context_code
2507: AND s.event_class_code = w.event_class_code
2508: AND s.event_type_code = w.event_type_code

Line 2515: trace(p_msg => '# xla_aad_header_ac_assgns deleted : '||l_num_rows,

2511: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code
2512: AND s.analytical_criterion_code = w.analytical_criterion_code);
2513: l_num_rows := SQL%ROWCOUNT;
2514: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2515: trace(p_msg => '# xla_aad_header_ac_assgns deleted : '||l_num_rows,
2516: p_module => l_log_module,
2517: p_level => C_LEVEL_STATEMENT);
2518: END IF;
2519: -- Bug : 9923803

Line 2526: p_encoded_message =>'# xla_aad_header_ac_assgns deleted : '||l_num_rows,

2522: p_amb_context_code => g_amb_context_code,
2523: p_application_id => g_application_id,
2524: p_request_code => 'IMPORT' ,
2525: p_log_type_code => 'MERGE',
2526: p_encoded_message =>'# xla_aad_header_ac_assgns deleted : '||l_num_rows,
2527: p_component_code => 'merge_aads');
2528: END IF;
2529:
2530: -- Move the AAD from staging area to working area

Line 2665: UPDATE xla_aad_header_ac_assgns

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
2667: WHERE application_id = g_application_id
2668: AND amb_context_code = g_staging_context_code;
2669: l_num_rows := SQL%ROWCOUNT;

Line 2671: trace(p_msg => '# xla_aad_header_ac_assgns updated : '||l_num_rows,

2667: WHERE application_id = g_application_id
2668: AND amb_context_code = g_staging_context_code;
2669: l_num_rows := SQL%ROWCOUNT;
2670: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2671: trace(p_msg => '# xla_aad_header_ac_assgns updated : '||l_num_rows,
2672: p_module => l_log_module,
2673: p_level => C_LEVEL_STATEMENT);
2674: END IF;
2675: -- Bug : 9923803

Line 2682: p_encoded_message =>'# xla_aad_header_ac_assgns updated : '||l_num_rows,

2678: p_amb_context_code => g_amb_context_code,
2679: p_application_id => g_application_id,
2680: p_request_code => 'IMPORT' ,
2681: p_log_type_code => 'MERGE',
2682: p_encoded_message =>'# xla_aad_header_ac_assgns updated : '||l_num_rows,
2683: p_component_code => 'merge_aads');
2684: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2685: trace(p_msg => 'END of procedure merge_aads',
2686: p_module => l_log_module,