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_LINE_DEFINITIONS_B

Line 587: FROM xla_line_definitions_b w

583: CURSOR c_all_comps IS
584: SELECT w.event_class_code
585: , w.event_type_code
586: , w.line_definition_code
587: FROM xla_line_definitions_b w
588: WHERE w.application_id = g_application_id
589: AND w.amb_context_code = g_amb_context_code
590: AND w.line_definition_owner_code = C_OWNER_SYSTEM
591: AND NOT EXISTS ( SELECT 1

Line 592: FROM xla_line_definitions_b s

588: WHERE w.application_id = g_application_id
589: AND w.amb_context_code = g_amb_context_code
590: AND w.line_definition_owner_code = C_OWNER_SYSTEM
591: AND NOT EXISTS ( SELECT 1
592: FROM xla_line_definitions_b s
593: WHERE s.application_id = g_application_id
594: AND s.amb_context_code = g_staging_context_code
595: AND s.event_class_code = w.event_class_code
596: AND s.event_type_code = w.event_type_code

Line 906: DELETE FROM xla_line_definitions_b w

902: p_encoded_message => '# xla_line_definitions_tl deleted = '||l_num_rows,
903: p_component_code => 'clean_oracle_jlds');
904:
905: FORALL i IN 1..l_codes.COUNT
906: DELETE FROM xla_line_definitions_b w
907: WHERE application_id = g_application_id
908: AND amb_context_code = g_amb_context_code
909: AND event_class_code = l_event_class_codes(i)
910: AND event_type_code = l_event_type_codes(i)

Line 915: trace(p_msg => '# xla_line_definitions_b deleted = '||l_num_rows,

911: AND line_definition_owner_code = C_OWNER_SYSTEM
912: AND line_definition_code = l_codes(i);
913: l_num_rows:= SQL%ROWCOUNT;
914: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
915: trace(p_msg => '# xla_line_definitions_b deleted = '||l_num_rows,
916: p_module => l_log_module,
917: p_level => C_LEVEL_STATEMENT);
918: END IF;
919: -- Bug : 9923803

Line 926: p_encoded_message => '# xla_line_definitions_b deleted = '||l_num_rows,

922: p_amb_context_code => g_amb_context_code,
923: p_application_id => g_application_id,
924: p_request_code => 'IMPORT' ,
925: p_log_type_code => 'MERGE',
926: p_encoded_message => '# xla_line_definitions_b deleted = '||l_num_rows,
927: p_component_code => 'clean_oracle_jlds');
928:
929: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
930: trace(p_msg => 'END of procedure clean_oracle_jlds',

Line 2738: 'XLA_LINE_DEFINITIONS_B'

2734: )
2735: select event_class_code,
2736: event_type_code,
2737: line_definition_code,
2738: 'XLA_LINE_DEFINITIONS_B'
2739: from
2740: (select event_class_code,
2741: event_type_code,
2742: line_definition_code,

Line 2743: 'XLA_LINE_DEFINITIONS_B',

2739: from
2740: (select event_class_code,
2741: event_type_code,
2742: line_definition_code,
2743: 'XLA_LINE_DEFINITIONS_B',
2744: amb_context_code,
2745: last_update_date ,
2746: nvl2(lag_date, decode(last_update_date,lag_date, 'True','False'),'False') flag
2747: from

Line 2751: 'XLA_LINE_DEFINITIONS_B',

2747: from
2748: (select event_class_code,
2749: event_type_code,
2750: line_definition_code,
2751: 'XLA_LINE_DEFINITIONS_B',
2752: amb_context_code,
2753: last_update_date ,
2754: lag(last_update_date) over (PARTITION by application_id,
2755: event_class_code,

Line 2761: from xla_line_definitions_b

2757: line_definition_code,
2758: line_definition_owner_code
2759: order by amb_context_code
2760: ) lag_date
2761: from xla_line_definitions_b
2762: order by amb_context_code
2763: ) x
2764: where x.amb_context_code =g_staging_context_code
2765: )

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

2766: where flag = 'False';
2767: l_num_rows := SQL%ROWCOUNT;
2768:
2769: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2770: trace(p_msg => 'Number of Rows inserted into aads_gt from xla_line_definitions_b is :'||l_num_rows,
2771: p_module => l_log_module,
2772: p_level => C_LEVEL_PROCEDURE);
2773: END IF;
2774: -- Bug : 9923803

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

2777: p_amb_context_code => g_amb_context_code,
2778: p_application_id => g_application_id,
2779: p_request_code => 'IMPORT' ,
2780: p_log_type_code => 'MERGE',
2781: p_encoded_message =>'Number of Rows inserted into aads_gt from xla_line_definitions_b is :'||l_num_rows,
2782: p_component_code => 'merge_journal_line_defns');
2783:
2784: INSERT INTO xla_aads_gt
2785: ( event_class_code,

Line 3312: DELETE FROM xla_line_definitions_b w

3308: ELSE
3309:
3310: -- Delete the journal line definitions from the working area if it already
3311: -- exists in the staging area
3312: DELETE FROM xla_line_definitions_b w
3313: WHERE application_id = g_application_id
3314: AND amb_context_code = g_amb_context_code
3315: AND EXISTS (SELECT 1
3316: FROM xla_line_definitions_b s

Line 3316: FROM xla_line_definitions_b s

3312: DELETE FROM xla_line_definitions_b w
3313: WHERE application_id = g_application_id
3314: AND amb_context_code = g_amb_context_code
3315: AND EXISTS (SELECT 1
3316: FROM xla_line_definitions_b s
3317: WHERE s.application_id = g_application_id
3318: AND s.amb_context_code = g_staging_context_code
3319: AND s.event_class_code = w.event_class_code
3320: AND s.event_type_code = w.event_type_code

Line 3325: trace(p_msg => '# xla_line_definitions_b deleted : '||l_num_rows,

3321: AND s.line_definition_owner_code = w.line_definition_owner_code
3322: AND s.line_definition_code = w.line_definition_code);
3323: l_num_rows := SQL%ROWCOUNT;
3324: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3325: trace(p_msg => '# xla_line_definitions_b deleted : '||l_num_rows,
3326: p_module => l_log_module,
3327: p_level => C_LEVEL_STATEMENT);
3328: END IF;
3329: -- Bug : 9923803

Line 3336: p_encoded_message =>'# xla_line_definitions_b deleted : '||l_num_rows,

3332: p_amb_context_code => g_amb_context_code,
3333: p_application_id => g_application_id,
3334: p_request_code => 'IMPORT' ,
3335: p_log_type_code => 'MERGE',
3336: p_encoded_message =>'# xla_line_definitions_b deleted : '||l_num_rows,
3337: p_component_code => 'merge_journal_line_defns');
3338:
3339: DELETE FROM xla_line_definitions_tl w
3340: WHERE application_id = g_application_id

Line 3621: UPDATE xla_line_definitions_b

3617:
3618: END IF;
3619:
3620: -- Move the journal line definitions from staging area to working area
3621: UPDATE xla_line_definitions_b
3622: SET amb_context_code = g_amb_context_code
3623: WHERE application_id = g_application_id
3624: AND amb_context_code = g_staging_context_code;
3625: l_num_rows := SQL%ROWCOUNT;

Line 3627: trace(p_msg => '# xla_line_definitions_b updated : '||l_num_rows,

3623: WHERE application_id = g_application_id
3624: AND amb_context_code = g_staging_context_code;
3625: l_num_rows := SQL%ROWCOUNT;
3626: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3627: trace(p_msg => '# xla_line_definitions_b updated : '||l_num_rows,
3628: p_module => l_log_module,
3629: p_level => C_LEVEL_STATEMENT);
3630: END IF;
3631: -- Bug : 9923803

Line 3638: p_encoded_message => '# xla_line_definitions_b updated : '||l_num_rows,

3634: p_amb_context_code => g_amb_context_code,
3635: p_application_id => g_application_id,
3636: p_request_code => 'IMPORT' ,
3637: p_log_type_code => 'MERGE',
3638: p_encoded_message => '# xla_line_definitions_b updated : '||l_num_rows,
3639: p_component_code => 'merge_journal_line_defns');
3640:
3641: UPDATE xla_line_definitions_tl w
3642: SET amb_context_code = g_amb_context_code