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_MPA_JLT_AC_ASSGNS

Line 847: DELETE FROM xla_mpa_jlt_ac_assgns w

843: p_log_type_code => 'MERGE',
844: p_encoded_message => '# xla_mpa_jlt_adr_assgns deleted = '||l_num_rows,
845: p_component_code => 'clean_oracle_jlds');
846:
847: DELETE FROM xla_mpa_jlt_ac_assgns w
848: WHERE application_id = g_application_id
849: AND amb_context_code = g_amb_context_code
850: AND line_definition_owner_code = C_OWNER_SYSTEM
851: AND NOT EXISTS

Line 853: FROM xla_mpa_jlt_ac_assgns s

849: AND amb_context_code = g_amb_context_code
850: AND line_definition_owner_code = C_OWNER_SYSTEM
851: AND NOT EXISTS
852: (SELECT 1
853: FROM xla_mpa_jlt_ac_assgns s
854: WHERE s.application_id = g_application_id
855: AND s.amb_context_code = g_staging_context_code
856: AND s.event_class_code = w.event_class_code
857: AND s.event_type_code = w.event_type_code

Line 868: trace(p_msg => '# xla_mpa_jlt_ac_assgns deleted = '||l_num_rows,

864: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code
865: AND s.analytical_criterion_code = w.analytical_criterion_code);
866: l_num_rows:= SQL%ROWCOUNT;
867: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
868: trace(p_msg => '# xla_mpa_jlt_ac_assgns deleted = '||l_num_rows,
869: p_module => l_log_module,
870: p_level => C_LEVEL_STATEMENT);
871: END IF;
872: -- Bug : 9923803

Line 879: p_encoded_message => '# xla_mpa_jlt_ac_assgns deleted = '||l_num_rows,

875: p_amb_context_code => g_amb_context_code,
876: p_application_id => g_application_id,
877: p_request_code => 'IMPORT' ,
878: p_log_type_code => 'MERGE',
879: p_encoded_message => '# xla_mpa_jlt_ac_assgns deleted = '||l_num_rows,
880: p_component_code => 'clean_oracle_jlds');
881: FORALL i IN 1..l_codes.COUNT
882: DELETE FROM xla_line_definitions_tl w
883: WHERE application_id = g_application_id

Line 1018: DELETE FROM xla_mpa_jlt_ac_assgns w

1014: p_encoded_message => '# xla_mpa_jlt_adr_assgns deleted = '||l_num_rows,
1015: p_component_code => 'clean_oracle_jlts');
1016:
1017: FORALL i IN 1..l_codes.COUNT
1018: DELETE FROM xla_mpa_jlt_ac_assgns w
1019: WHERE application_id = g_application_id
1020: AND amb_context_code = g_amb_context_code
1021: AND event_class_code = l_event_class_codes(i)
1022: AND accounting_line_type_code = C_OWNER_SYSTEM

Line 1026: trace(p_msg => '# xla_mpa_jlt_ac_assgns deleted = '||l_num_rows,

1022: AND accounting_line_type_code = C_OWNER_SYSTEM
1023: AND accounting_line_code = l_codes(i);
1024: l_num_rows := SQL%ROWCOUNT;
1025: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1026: trace(p_msg => '# xla_mpa_jlt_ac_assgns deleted = '||l_num_rows,
1027: p_module => l_log_module,
1028: p_level => C_LEVEL_STATEMENT);
1029: END IF;
1030: -- Bug : 9923803

Line 1037: p_encoded_message => '# xla_mpa_jlt_ac_assgns deleted = '||l_num_rows,

1033: p_amb_context_code => g_amb_context_code,
1034: p_application_id => g_application_id,
1035: p_request_code => 'IMPORT' ,
1036: p_log_type_code => 'MERGE',
1037: p_encoded_message => '# xla_mpa_jlt_ac_assgns deleted = '||l_num_rows,
1038: p_component_code => 'clean_oracle_jlts');
1039: FORALL i IN 1..l_codes.COUNT
1040: DELETE FROM xla_mpa_header_ac_assgns w
1041: WHERE application_id = g_application_id

Line 1867: DELETE FROM xla_mpa_jlt_ac_assgns w

1863: p_level => C_LEVEL_STATEMENT);
1864: END IF;
1865:
1866: FORALL i IN 1..l_codes.COUNT
1867: DELETE FROM xla_mpa_jlt_ac_assgns w
1868: WHERE amb_context_code = g_amb_context_code
1869: AND analytical_criterion_type_code = C_OWNER_SYSTEM
1870: AND analytical_criterion_code = l_codes(i);
1871:

Line 1873: trace(p_msg => '# xla_mpa_jlt_ac_assgns deleted = '||SQL%ROWCOUNT,

1869: AND analytical_criterion_type_code = C_OWNER_SYSTEM
1870: AND analytical_criterion_code = l_codes(i);
1871:
1872: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1873: trace(p_msg => '# xla_mpa_jlt_ac_assgns deleted = '||SQL%ROWCOUNT,
1874: p_module => l_log_module,
1875: p_level => C_LEVEL_STATEMENT);
1876: END IF;*/ -- commented bug6696939
1877:

Line 3234: ,'XLA_MPA_JLT_AC_ASSGNS'

3230: ,mpa_jlt_ac_assgns.line_definition_code
3231: ,mpa_jlt_ac_assgns.accounting_line_code
3232: ,mpa_jlt_ac_assgns.mpa_accounting_line_code
3233: ,mpa_jlt_ac_assgns.analytical_criterion_code
3234: ,'XLA_MPA_JLT_AC_ASSGNS'
3235: from XLA_MPA_JLT_AC_ASSGNS mpa_jlt_ac_assgns
3236: where mpa_jlt_ac_assgns.application_id = g_application_id
3237: and mpa_jlt_ac_assgns.amb_context_code = g_staging_context_code
3238: and (EXISTS(SELECT 1

Line 3235: from XLA_MPA_JLT_AC_ASSGNS mpa_jlt_ac_assgns

3231: ,mpa_jlt_ac_assgns.accounting_line_code
3232: ,mpa_jlt_ac_assgns.mpa_accounting_line_code
3233: ,mpa_jlt_ac_assgns.analytical_criterion_code
3234: ,'XLA_MPA_JLT_AC_ASSGNS'
3235: from XLA_MPA_JLT_AC_ASSGNS mpa_jlt_ac_assgns
3236: where mpa_jlt_ac_assgns.application_id = g_application_id
3237: and mpa_jlt_ac_assgns.amb_context_code = g_staging_context_code
3238: and (EXISTS(SELECT 1
3239: FROM XLA_MPA_JLT_AC_ASSGNS mpa_jlt_ac_assgns1

Line 3239: FROM XLA_MPA_JLT_AC_ASSGNS mpa_jlt_ac_assgns1

3235: from XLA_MPA_JLT_AC_ASSGNS mpa_jlt_ac_assgns
3236: where mpa_jlt_ac_assgns.application_id = g_application_id
3237: and mpa_jlt_ac_assgns.amb_context_code = g_staging_context_code
3238: and (EXISTS(SELECT 1
3239: FROM XLA_MPA_JLT_AC_ASSGNS mpa_jlt_ac_assgns1
3240: WHERE mpa_jlt_ac_assgns.event_class_code = mpa_jlt_ac_assgns1.event_class_code
3241: and mpa_jlt_ac_assgns.event_type_code = mpa_jlt_ac_assgns1.event_type_code
3242: and mpa_jlt_ac_assgns.line_definition_code = mpa_jlt_ac_assgns1.line_definition_code
3243: and mpa_jlt_ac_assgns.line_definition_owner_code = mpa_jlt_ac_assgns1.line_definition_owner_code

Line 3265: FROM XLA_MPA_JLT_AC_ASSGNS mpa_jlt_ac_assgns1

3261: and s.mpa_option_code = 'NONE'
3262: )
3263: OR
3264: NOT EXISTS(SELECT 1
3265: FROM XLA_MPA_JLT_AC_ASSGNS mpa_jlt_ac_assgns1
3266: WHERE mpa_jlt_ac_assgns.event_class_code = mpa_jlt_ac_assgns1.event_class_code
3267: and mpa_jlt_ac_assgns.event_type_code = mpa_jlt_ac_assgns1.event_type_code
3268: and mpa_jlt_ac_assgns.line_definition_code = mpa_jlt_ac_assgns1.line_definition_code
3269: and mpa_jlt_ac_assgns.line_definition_owner_code = mpa_jlt_ac_assgns1.line_definition_owner_code

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

3287: )
3288: );
3289: l_num_rows := SQL%ROWCOUNT;
3290: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3291: trace(p_msg => 'Number of Rows inserted into aads_gt from xla_mpa_jlt_ac_assgns is :'||l_num_rows,
3292: p_module => l_log_module,
3293: p_level => C_LEVEL_PROCEDURE);
3294: END IF;
3295: -- Bug : 9923803

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

3298: p_amb_context_code => g_amb_context_code,
3299: p_application_id => g_application_id,
3300: p_request_code => 'IMPORT' ,
3301: p_log_type_code => 'MERGE',
3302: p_encoded_message =>'Number of Rows inserted into aads_gt from xla_mpa_jlt_ac_assgns is :'||l_num_rows,
3303: p_component_code => 'merge_journal_line_defns');
3304:
3305: IF (g_analyzed_flag = 'Y') THEN
3306: null;

Line 3574: DELETE FROM xla_mpa_jlt_ac_assgns w

3570: p_log_type_code => 'MERGE',
3571: p_encoded_message => '# xla_mpa_jlt_adr_assgns deleted : '||l_num_rows,
3572: p_component_code => 'merge_journal_line_defns');
3573:
3574: DELETE FROM xla_mpa_jlt_ac_assgns w
3575: WHERE application_id = g_application_id
3576: AND amb_context_code = g_amb_context_code
3577: AND EXISTS (
3578: SELECT 1

Line 3579: FROM xla_mpa_jlt_ac_assgns s

3575: WHERE application_id = g_application_id
3576: AND amb_context_code = g_amb_context_code
3577: AND EXISTS (
3578: SELECT 1
3579: FROM xla_mpa_jlt_ac_assgns s
3580: WHERE s.application_id = g_application_id
3581: AND s.amb_context_code = g_staging_context_code
3582: AND s.event_class_code = w.event_class_code
3583: AND s.event_type_code = w.event_type_code

Line 3604: trace(p_msg => '# xla_mpa_jlt_ac_assgns deleted : '||l_num_rows,

3600: AND s.mpa_option_code = 'NONE');
3601:
3602: l_num_rows := SQL%ROWCOUNT;
3603: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3604: trace(p_msg => '# xla_mpa_jlt_ac_assgns deleted : '||l_num_rows,
3605: p_module => l_log_module,
3606: p_level => C_LEVEL_STATEMENT);
3607: END IF;
3608: -- Bug : 9923803

Line 3615: p_encoded_message => '# xla_mpa_jlt_ac_assgns deleted : '||l_num_rows,

3611: p_amb_context_code => g_amb_context_code,
3612: p_application_id => g_application_id,
3613: p_request_code => 'IMPORT' ,
3614: p_log_type_code => 'MERGE',
3615: p_encoded_message => '# xla_mpa_jlt_ac_assgns deleted : '||l_num_rows,
3616: p_component_code => 'merge_journal_line_defns');
3617:
3618: END IF;
3619:

Line 3822: UPDATE xla_mpa_jlt_ac_assgns

3818: p_component_code => 'merge_journal_line_defns');
3819:
3820: -- For AC that is not going to be overwritten by those in staging area, it
3821: -- must not exist in the staging area. Therefore, it must not be inherited.
3822: UPDATE xla_mpa_jlt_ac_assgns
3823: SET mpa_inherit_ac_flag = 'N'
3824: WHERE application_id = g_application_id
3825: AND amb_context_code = g_amb_context_code;
3826:

Line 3827: UPDATE xla_mpa_jlt_ac_assgns

3823: SET mpa_inherit_ac_flag = 'N'
3824: WHERE application_id = g_application_id
3825: AND amb_context_code = g_amb_context_code;
3826:
3827: UPDATE xla_mpa_jlt_ac_assgns
3828: SET amb_context_code = g_amb_context_code
3829: WHERE application_id = g_application_id
3830: AND amb_context_code = g_staging_context_code;
3831: l_num_rows := SQL%ROWCOUNT;

Line 3833: trace(p_msg => '# xla_mpa_jlt_ac_assgns updated : '||l_num_rows,

3829: WHERE application_id = g_application_id
3830: AND amb_context_code = g_staging_context_code;
3831: l_num_rows := SQL%ROWCOUNT;
3832: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3833: trace(p_msg => '# xla_mpa_jlt_ac_assgns updated : '||l_num_rows,
3834: p_module => l_log_module,
3835: p_level => C_LEVEL_STATEMENT);
3836: END IF;
3837: -- Bug : 9923803

Line 3844: p_encoded_message => '# xla_mpa_jlt_ac_assgns updated : '||l_num_rows,

3840: p_amb_context_code => g_amb_context_code,
3841: p_application_id => g_application_id,
3842: p_request_code => 'IMPORT' ,
3843: p_log_type_code => 'MERGE',
3844: p_encoded_message => '# xla_mpa_jlt_ac_assgns updated : '||l_num_rows,
3845: p_component_code => 'merge_journal_line_defns');
3846: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3847: trace(p_msg => 'END of procedure merge_journal_line_defns',
3848: p_module => l_log_module,