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_HEADER_AC_ASSGNS

Line 780: DELETE FROM xla_mpa_header_ac_assgns w

776: p_request_code => 'IMPORT' ,
777: p_log_type_code => 'MERGE',
778: p_encoded_message => '# xla_mpa_jlt_assgns deleted = '||l_num_rows,
779: p_component_code => 'clean_oracle_jlds');
780: DELETE FROM xla_mpa_header_ac_assgns w
781: WHERE application_id = g_application_id
782: AND amb_context_code = g_amb_context_code
783: AND line_definition_owner_code = C_OWNER_SYSTEM
784: AND NOT EXISTS

Line 786: FROM xla_mpa_header_ac_assgns s

782: AND amb_context_code = g_amb_context_code
783: AND line_definition_owner_code = C_OWNER_SYSTEM
784: AND NOT EXISTS
785: (SELECT 1
786: FROM xla_mpa_header_ac_assgns s
787: WHERE s.application_id = g_application_id
788: AND s.amb_context_code = g_staging_context_code
789: AND s.event_class_code = w.event_class_code
790: AND s.event_type_code = w.event_type_code

Line 799: trace(p_msg => '# xla_mpa_header_ac_assgns deleted = '||l_num_rows,

795: AND s.analytical_criterion_type_code = w.analytical_criterion_type_code
796: AND s.analytical_criterion_code = w.analytical_criterion_code);
797: l_num_rows:= SQL%ROWCOUNT;
798: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
799: trace(p_msg => '# xla_mpa_header_ac_assgns deleted = '||l_num_rows,
800: p_module => l_log_module,
801: p_level => C_LEVEL_STATEMENT);
802: END IF;
803: -- Bug : 9923803

Line 810: p_encoded_message => '# xla_mpa_header_ac_assgns deleted = '||l_num_rows,

806: p_amb_context_code => g_amb_context_code,
807: p_application_id => g_application_id,
808: p_request_code => 'IMPORT' ,
809: p_log_type_code => 'MERGE',
810: p_encoded_message => '# xla_mpa_header_ac_assgns deleted = '||l_num_rows,
811: p_component_code => 'clean_oracle_jlds');
812:
813: DELETE FROM xla_mpa_jlt_adr_assgns w
814: WHERE application_id = g_application_id

Line 1040: DELETE FROM xla_mpa_header_ac_assgns w

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
1042: AND amb_context_code = g_amb_context_code
1043: AND event_class_code = l_event_class_codes(i)
1044: AND accounting_line_type_code = C_OWNER_SYSTEM

Line 1048: trace(p_msg => '# xla_mpa_header_ac_assgns deleted = '||l_num_rows,

1044: AND accounting_line_type_code = C_OWNER_SYSTEM
1045: AND accounting_line_code = l_codes(i);
1046: l_num_rows := SQL%ROWCOUNT;
1047: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1048: trace(p_msg => '# xla_mpa_header_ac_assgns deleted = '||l_num_rows,
1049: p_module => l_log_module,
1050: p_level => C_LEVEL_STATEMENT);
1051: END IF;
1052: -- Bug : 9923803

Line 1059: p_encoded_message => '# xla_mpa_header_ac_assgns deleted = '||l_num_rows,

1055: p_amb_context_code => g_amb_context_code,
1056: p_application_id => g_application_id,
1057: p_request_code => 'IMPORT' ,
1058: p_log_type_code => 'MERGE',
1059: p_encoded_message => '# xla_mpa_header_ac_assgns deleted = '||l_num_rows,
1060: p_component_code => 'clean_oracle_jlts');
1061:
1062: FORALL i IN 1..l_codes.COUNT
1063: DELETE FROM xla_mpa_jlt_assgns w

Line 1855: DELETE FROM xla_mpa_header_ac_assgns w

1851: p_level => C_LEVEL_STATEMENT);
1852: END IF;
1853:
1854: FORALL i IN 1..l_codes.COUNT
1855: DELETE FROM xla_mpa_header_ac_assgns w
1856: WHERE amb_context_code = g_amb_context_code
1857: AND analytical_criterion_type_code = C_OWNER_SYSTEM
1858: AND analytical_criterion_code = l_codes(i);
1859:

Line 1861: trace(p_msg => '# xla_mpa_header_ac_assgns deleted = '||SQL%ROWCOUNT,

1857: AND analytical_criterion_type_code = C_OWNER_SYSTEM
1858: AND analytical_criterion_code = l_codes(i);
1859:
1860: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1861: trace(p_msg => '# xla_mpa_header_ac_assgns deleted = '||SQL%ROWCOUNT,
1862: p_module => l_log_module,
1863: p_level => C_LEVEL_STATEMENT);
1864: END IF;
1865:

Line 3062: ,'XLA_MPA_HEADER_AC_ASSGNS'

3058: ,mpa_hdr_ac_assgns.event_type_code
3059: ,mpa_hdr_ac_assgns.line_definition_code
3060: ,mpa_hdr_ac_assgns.accounting_line_code
3061: ,mpa_hdr_ac_assgns.analytical_criterion_code
3062: ,'XLA_MPA_HEADER_AC_ASSGNS'
3063: from XLA_MPA_HEADER_AC_ASSGNS mpa_hdr_ac_assgns
3064: where mpa_hdr_ac_assgns.application_id = g_application_id
3065: and mpa_hdr_ac_assgns.amb_context_code = g_staging_context_code
3066: and (EXISTS(SELECT 1

Line 3063: from XLA_MPA_HEADER_AC_ASSGNS mpa_hdr_ac_assgns

3059: ,mpa_hdr_ac_assgns.line_definition_code
3060: ,mpa_hdr_ac_assgns.accounting_line_code
3061: ,mpa_hdr_ac_assgns.analytical_criterion_code
3062: ,'XLA_MPA_HEADER_AC_ASSGNS'
3063: from XLA_MPA_HEADER_AC_ASSGNS mpa_hdr_ac_assgns
3064: where mpa_hdr_ac_assgns.application_id = g_application_id
3065: and mpa_hdr_ac_assgns.amb_context_code = g_staging_context_code
3066: and (EXISTS(SELECT 1
3067: FROM XLA_MPA_HEADER_AC_ASSGNS mpa_hdr_ac_assgns1

Line 3067: FROM XLA_MPA_HEADER_AC_ASSGNS mpa_hdr_ac_assgns1

3063: from XLA_MPA_HEADER_AC_ASSGNS mpa_hdr_ac_assgns
3064: where mpa_hdr_ac_assgns.application_id = g_application_id
3065: and mpa_hdr_ac_assgns.amb_context_code = g_staging_context_code
3066: and (EXISTS(SELECT 1
3067: FROM XLA_MPA_HEADER_AC_ASSGNS mpa_hdr_ac_assgns1
3068: WHERE mpa_hdr_ac_assgns.event_class_code = mpa_hdr_ac_assgns1.event_class_code
3069: and mpa_hdr_ac_assgns.event_type_code = mpa_hdr_ac_assgns1.event_type_code
3070: and mpa_hdr_ac_assgns.line_definition_code = mpa_hdr_ac_assgns1.line_definition_code
3071: and mpa_hdr_ac_assgns.line_definition_owner_code = mpa_hdr_ac_assgns1.line_definition_owner_code

Line 3091: FROM XLA_MPA_HEADER_AC_ASSGNS mpa_hdr_ac_assgns1

3087: and s.mpa_option_code = 'NONE'
3088: )
3089: OR
3090: NOT EXISTS(SELECT 1
3091: FROM XLA_MPA_HEADER_AC_ASSGNS mpa_hdr_ac_assgns1
3092: WHERE mpa_hdr_ac_assgns.event_class_code = mpa_hdr_ac_assgns1.event_class_code
3093: and mpa_hdr_ac_assgns.event_type_code = mpa_hdr_ac_assgns1.event_type_code
3094: and mpa_hdr_ac_assgns.line_definition_code = mpa_hdr_ac_assgns1.line_definition_code
3095: and mpa_hdr_ac_assgns.line_definition_owner_code = mpa_hdr_ac_assgns1.line_definition_owner_code

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

3111: )
3112: );
3113: l_num_rows := SQL%ROWCOUNT;
3114: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3115: trace(p_msg => 'Number of Rows inserted into aads_gt from xla_mpa_header_ac_assgns is :'||l_num_rows,
3116: p_module => l_log_module,
3117: p_level => C_LEVEL_PROCEDURE);
3118: END IF;
3119: -- Bug : 9923803

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

3122: p_amb_context_code => g_amb_context_code,
3123: p_application_id => g_application_id,
3124: p_request_code => 'IMPORT' ,
3125: p_log_type_code => 'MERGE',
3126: p_encoded_message =>'Number of Rows inserted into aads_gt from xla_mpa_header_ac_assgns is :'||l_num_rows,
3127: p_component_code => 'merge_journal_line_defns');
3128:
3129: INSERT INTO xla_aads_gt
3130: (

Line 3490: DELETE FROM xla_mpa_header_ac_assgns w

3486: p_log_type_code => 'MERGE',
3487: p_encoded_message => '# xla_mpa_jlt_assgns deleted : '||l_num_rows,
3488: p_component_code => 'merge_journal_line_defns');
3489:
3490: DELETE FROM xla_mpa_header_ac_assgns w
3491: WHERE application_id = g_application_id
3492: AND amb_context_code = g_amb_context_code
3493: AND EXISTS (
3494: SELECT 1

Line 3495: FROM xla_mpa_header_ac_assgns s

3491: WHERE application_id = g_application_id
3492: AND amb_context_code = g_amb_context_code
3493: AND EXISTS (
3494: SELECT 1
3495: FROM xla_mpa_header_ac_assgns s
3496: WHERE s.application_id = g_application_id
3497: AND s.amb_context_code = g_staging_context_code
3498: AND s.event_class_code = w.event_class_code
3499: AND s.event_type_code = w.event_type_code

Line 3517: trace(p_msg => '# xla_mpa_header_ac_assgns deleted : '||l_num_rows,

3513: AND s.accounting_line_code = w.accounting_line_code
3514: AND s.mpa_option_code = 'NONE');
3515: l_num_rows := SQL%ROWCOUNT;
3516: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3517: trace(p_msg => '# xla_mpa_header_ac_assgns deleted : '||l_num_rows,
3518: p_module => l_log_module,
3519: p_level => C_LEVEL_STATEMENT);
3520: END IF;
3521: -- Bug : 9923803

Line 3528: p_encoded_message => '# xla_mpa_header_ac_assgns deleted : '||l_num_rows,

3524: p_amb_context_code => g_amb_context_code,
3525: p_application_id => g_application_id,
3526: p_request_code => 'IMPORT' ,
3527: p_log_type_code => 'MERGE',
3528: p_encoded_message => '# xla_mpa_header_ac_assgns deleted : '||l_num_rows,
3529: p_component_code => 'merge_journal_line_defns');
3530:
3531: -- ADR assignments are not merged, but overwritten, if the MPA JLT exists in
3532: -- the staging area

Line 3780: UPDATE xla_mpa_header_ac_assgns

3776: p_log_type_code => 'MERGE',
3777: p_encoded_message => '# xla_mpa_jlt_assgns updated : '||l_num_rows,
3778: p_component_code => 'merge_journal_line_defns');
3779:
3780: UPDATE xla_mpa_header_ac_assgns
3781: SET amb_context_code = g_amb_context_code
3782: WHERE application_id = g_application_id
3783: AND amb_context_code = g_staging_context_code;
3784: l_num_rows := SQL%ROWCOUNT;

Line 3786: trace(p_msg => '# xla_mpa_header_ac_assgns updated : '||l_num_rows,

3782: WHERE application_id = g_application_id
3783: AND amb_context_code = g_staging_context_code;
3784: l_num_rows := SQL%ROWCOUNT;
3785: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3786: trace(p_msg => '# xla_mpa_header_ac_assgns updated : '||l_num_rows,
3787: p_module => l_log_module,
3788: p_level => C_LEVEL_STATEMENT);
3789: END IF;
3790: -- Bug : 9923803

Line 3797: p_encoded_message => '# xla_mpa_header_ac_assgns updated : '||l_num_rows,

3793: p_amb_context_code => g_amb_context_code,
3794: p_application_id => g_application_id,
3795: p_request_code => 'IMPORT' ,
3796: p_log_type_code => 'MERGE',
3797: p_encoded_message => '# xla_mpa_header_ac_assgns updated : '||l_num_rows,
3798: p_component_code => 'merge_journal_line_defns');
3799:
3800: UPDATE xla_mpa_jlt_adr_assgns
3801: SET amb_context_code = g_amb_context_code