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_ASSGNS

Line 748: DELETE FROM xla_mpa_jlt_assgns w

744: p_request_code => 'IMPORT' ,
745: p_log_type_code => 'MERGE',
746: p_encoded_message => '# xla_line_defn_jlt_assgns deleted = '||l_num_rows,
747: p_component_code => 'clean_oracle_jlds');
748: DELETE FROM xla_mpa_jlt_assgns w
749: WHERE application_id = g_application_id
750: AND amb_context_code = g_amb_context_code
751: AND line_definition_owner_code = C_OWNER_SYSTEM
752: AND NOT EXISTS

Line 754: FROM xla_mpa_jlt_assgns s

750: AND amb_context_code = g_amb_context_code
751: AND line_definition_owner_code = C_OWNER_SYSTEM
752: AND NOT EXISTS
753: (SELECT 1
754: FROM xla_mpa_jlt_assgns s
755: WHERE s.application_id = g_application_id
756: AND s.amb_context_code = g_staging_context_code
757: AND s.event_class_code = w.event_class_code
758: AND s.event_type_code = w.event_type_code

Line 767: trace(p_msg => '# xla_mpa_jlt_assgns deleted = '||l_num_rows,

763: AND s.mpa_accounting_line_type_code = w.mpa_accounting_line_type_code
764: AND s.mpa_accounting_line_code = w.mpa_accounting_line_code);
765: l_num_rows := SQL%ROWCOUNT;
766: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
767: trace(p_msg => '# xla_mpa_jlt_assgns deleted = '||l_num_rows,
768: p_module => l_log_module,
769: p_level => C_LEVEL_STATEMENT);
770: END IF;
771: -- Bug : 9923803

Line 778: p_encoded_message => '# xla_mpa_jlt_assgns deleted = '||l_num_rows,

774: p_amb_context_code => g_amb_context_code,
775: p_application_id => g_application_id,
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

Line 1063: DELETE FROM xla_mpa_jlt_assgns w

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
1064: WHERE application_id = g_application_id
1065: AND amb_context_code = g_amb_context_code
1066: AND event_class_code = l_event_class_codes(i)
1067: AND accounting_line_type_code = C_OWNER_SYSTEM

Line 1071: trace(p_msg => '# xla_mpa_jlt_assgns deleted = '||l_num_rows,

1067: AND accounting_line_type_code = C_OWNER_SYSTEM
1068: AND accounting_line_code = l_codes(i);
1069: l_num_rows := SQL%ROWCOUNT;
1070: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1071: trace(p_msg => '# xla_mpa_jlt_assgns deleted = '||l_num_rows,
1072: p_module => l_log_module,
1073: p_level => C_LEVEL_STATEMENT);
1074: END IF;
1075: -- Bug : 9923803

Line 1082: p_encoded_message => '# xla_mpa_jlt_assgns deleted = '||l_num_rows,

1078: p_amb_context_code => g_amb_context_code,
1079: p_application_id => g_application_id,
1080: p_request_code => 'IMPORT' ,
1081: p_log_type_code => 'MERGE',
1082: p_encoded_message => '# xla_mpa_jlt_assgns deleted = '||l_num_rows,
1083: p_component_code => 'clean_oracle_jlts');
1084: FORALL i IN 1..l_codes.COUNT
1085: DELETE FROM xla_line_defn_adr_assgns w
1086: WHERE application_id = g_application_id

Line 2991: ,'XLA_MPA_JLT_ASSGNS'

2987: ,mpa_jlt_assgns.event_type_code
2988: ,mpa_jlt_assgns.line_definition_code
2989: ,mpa_jlt_assgns.accounting_line_code
2990: ,mpa_jlt_assgns.mpa_accounting_line_code
2991: ,'XLA_MPA_JLT_ASSGNS'
2992: from XLA_MPA_JLT_ASSGNS mpa_jlt_assgns
2993: where mpa_jlt_assgns.application_id = g_application_id
2994: and mpa_jlt_assgns.amb_context_code = g_staging_context_code
2995: AND EXISTS (

Line 2992: from XLA_MPA_JLT_ASSGNS mpa_jlt_assgns

2988: ,mpa_jlt_assgns.line_definition_code
2989: ,mpa_jlt_assgns.accounting_line_code
2990: ,mpa_jlt_assgns.mpa_accounting_line_code
2991: ,'XLA_MPA_JLT_ASSGNS'
2992: from XLA_MPA_JLT_ASSGNS mpa_jlt_assgns
2993: where mpa_jlt_assgns.application_id = g_application_id
2994: and mpa_jlt_assgns.amb_context_code = g_staging_context_code
2995: AND EXISTS (
2996: SELECT 1

Line 3005: FROM XLA_MPA_JLT_ASSGNS mpa_jlt_assgns1

3001: AND xal.accounting_line_type_code = mpa_jlt_assgns.accounting_line_type_code
3002: AND xal.accounting_line_code = mpa_jlt_assgns.accounting_line_code
3003: AND xal.mpa_option_code = 'ACCRUAL')
3004: AND (EXISTS (SELECT 1
3005: FROM XLA_MPA_JLT_ASSGNS mpa_jlt_assgns1
3006: WHERE mpa_jlt_assgns.event_class_code = mpa_jlt_assgns1.event_class_code
3007: and mpa_jlt_assgns.event_type_code = mpa_jlt_assgns1.event_type_code
3008: and mpa_jlt_assgns.line_definition_code = mpa_jlt_assgns1.line_definition_code
3009: and mpa_jlt_assgns.line_definition_owner_code = mpa_jlt_assgns1.line_definition_owner_code

Line 3020: FROM XLA_MPA_JLT_ASSGNS mpa_jlt_assgns1

3016: and to_char(mpa_jlt_assgns.last_update_date,'DD-MON-YYYY') <> to_char(mpa_jlt_assgns1.last_update_date,'DD-MON-YYYY')
3017: )
3018: OR
3019: NOT EXISTS (SELECT 1
3020: FROM XLA_MPA_JLT_ASSGNS mpa_jlt_assgns1
3021: WHERE mpa_jlt_assgns.event_class_code = mpa_jlt_assgns1.event_class_code
3022: and mpa_jlt_assgns.event_type_code = mpa_jlt_assgns1.event_type_code
3023: and mpa_jlt_assgns.line_definition_code = mpa_jlt_assgns1.line_definition_code
3024: and mpa_jlt_assgns.line_definition_owner_code = mpa_jlt_assgns1.line_definition_owner_code

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

3031: )
3032: );
3033: l_num_rows := SQL%ROWCOUNT;
3034: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3035: trace(p_msg => 'Number of Rows inserted into aads_gt from xla_mpa_jlt_assgns is :'||l_num_rows,
3036: p_module => l_log_module,
3037: p_level => C_LEVEL_PROCEDURE);
3038: END IF;
3039: -- Bug : 9923803

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

3042: p_amb_context_code => g_amb_context_code,
3043: p_application_id => g_application_id,
3044: p_request_code => 'IMPORT' ,
3045: p_log_type_code => 'MERGE',
3046: p_encoded_message =>'Number of Rows inserted into aads_gt from xla_mpa_jlt_assgns is :'||l_num_rows,
3047: p_component_code => 'merge_journal_line_defns');
3048:
3049: INSERT INTO xla_aads_gt
3050: ( event_class_code

Line 3150: FROM xla_mpa_jlt_assgns s

3146: from XLA_MPA_JLT_ADR_ASSGNS mpa_jlt_adr_assgns
3147: where mpa_jlt_adr_assgns.application_id = g_application_id
3148: and mpa_jlt_adr_assgns.amb_context_code = g_staging_context_code
3149: and EXISTS ( SELECT 1
3150: FROM xla_mpa_jlt_assgns s
3151: WHERE s.application_id = g_application_id
3152: AND s.amb_context_code = g_staging_context_code
3153: AND s.event_class_code = mpa_jlt_adr_assgns.event_class_code
3154: AND s.event_type_code = mpa_jlt_adr_assgns.event_type_code

Line 3462: DELETE FROM xla_mpa_jlt_assgns w

3458: p_encoded_message =>'# xla_line_defn_ac_assgns deleted : '||l_num_rows,
3459: p_component_code => 'merge_journal_line_defns');
3460:
3461: -- bug8635648 MPA JLT's deleted even when no data for JLT's in Staging Table
3462: DELETE FROM xla_mpa_jlt_assgns w
3463: WHERE application_id = g_application_id
3464: AND amb_context_code = g_amb_context_code
3465: AND EXISTS (
3466: SELECT 1

Line 3476: trace(p_msg => '# xla_mpa_jlt_assgns deleted : '||l_num_rows,

3472: AND xal.accounting_line_code = w.accounting_line_code
3473: AND xal.mpa_option_code = 'ACCRUAL');
3474: l_num_rows := SQL%ROWCOUNT;
3475: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3476: trace(p_msg => '# xla_mpa_jlt_assgns deleted : '||l_num_rows,
3477: p_module => l_log_module,
3478: p_level => C_LEVEL_STATEMENT);
3479: END IF;
3480: -- Bug : 9923803

Line 3487: p_encoded_message => '# xla_mpa_jlt_assgns deleted : '||l_num_rows,

3483: p_amb_context_code => g_amb_context_code,
3484: p_application_id => g_application_id,
3485: p_request_code => 'IMPORT' ,
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

Line 3538: FROM xla_mpa_jlt_assgns s

3534: WHERE application_id = g_application_id
3535: AND amb_context_code = g_amb_context_code
3536: AND EXISTS (
3537: SELECT 1
3538: FROM xla_mpa_jlt_assgns s
3539: WHERE s.application_id = g_application_id
3540: AND s.amb_context_code = g_staging_context_code
3541: AND s.event_class_code = w.event_class_code
3542: AND s.event_type_code = w.event_type_code

Line 3760: UPDATE xla_mpa_jlt_assgns

3756: p_log_type_code => 'MERGE',
3757: p_encoded_message => '# xla_line_defn_ac_assgns updated : '||l_num_rows,
3758: p_component_code => 'merge_journal_line_defns');
3759:
3760: UPDATE xla_mpa_jlt_assgns
3761: SET amb_context_code = g_amb_context_code
3762: WHERE application_id = g_application_id
3763: AND amb_context_code = g_staging_context_code;
3764: l_num_rows := SQL%ROWCOUNT;

Line 3766: trace(p_msg => '# xla_mpa_jlt_assgns updated : '||l_num_rows,

3762: WHERE application_id = g_application_id
3763: AND amb_context_code = g_staging_context_code;
3764: l_num_rows := SQL%ROWCOUNT;
3765: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3766: trace(p_msg => '# xla_mpa_jlt_assgns updated : '||l_num_rows,
3767: p_module => l_log_module,
3768: p_level => C_LEVEL_STATEMENT);
3769: END IF;
3770: -- Bug : 9923803

Line 3777: p_encoded_message => '# xla_mpa_jlt_assgns updated : '||l_num_rows,

3773: p_amb_context_code => g_amb_context_code,
3774: p_application_id => g_application_id,
3775: p_request_code => 'IMPORT' ,
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