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_ADR_ASSGNS

Line 813: DELETE FROM xla_mpa_jlt_adr_assgns w

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
815: AND amb_context_code = g_amb_context_code
816: AND line_definition_owner_code = C_OWNER_SYSTEM
817: AND NOT EXISTS

Line 819: FROM xla_mpa_jlt_adr_assgns s

815: AND amb_context_code = g_amb_context_code
816: AND line_definition_owner_code = C_OWNER_SYSTEM
817: AND NOT EXISTS
818: (SELECT 1
819: FROM xla_mpa_jlt_adr_assgns s
820: WHERE s.application_id = g_application_id
821: AND s.amb_context_code = g_staging_context_code
822: AND s.event_class_code = w.event_class_code
823: AND s.event_type_code = w.event_type_code

Line 833: trace(p_msg => '# xla_mpa_jlt_adr_assgns deleted = '||l_num_rows,

829: AND s.mpa_accounting_line_code = w.mpa_accounting_line_code
830: AND s.flexfield_segment_code = w.flexfield_segment_code);
831: l_num_rows:= SQL%ROWCOUNT;
832: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
833: trace(p_msg => '# xla_mpa_jlt_adr_assgns deleted = '||l_num_rows,
834: p_module => l_log_module,
835: p_level => C_LEVEL_STATEMENT);
836: END IF;
837: -- Bug : 9923803

Line 844: p_encoded_message => '# xla_mpa_jlt_adr_assgns deleted = '||l_num_rows,

840: p_amb_context_code => g_amb_context_code,
841: p_application_id => g_application_id,
842: p_request_code => 'IMPORT' ,
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

Line 995: DELETE FROM xla_mpa_jlt_adr_assgns w

991:
992: IF (l_codes.COUNT > 0) THEN
993:
994: FORALL i IN 1..l_codes.COUNT
995: DELETE FROM xla_mpa_jlt_adr_assgns w
996: WHERE application_id = g_application_id
997: AND amb_context_code = g_amb_context_code
998: AND event_class_code = l_event_class_codes(i)
999: AND accounting_line_type_code = C_OWNER_SYSTEM

Line 1003: trace(p_msg => '# xla_mpa_jlt_adr_assgns deleted = '||l_num_rows,

999: AND accounting_line_type_code = C_OWNER_SYSTEM
1000: AND accounting_line_code = l_codes(i);
1001: l_num_rows := SQL%ROWCOUNT;
1002: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1003: trace(p_msg => '# xla_mpa_jlt_adr_assgns deleted = '||l_num_rows,
1004: p_module => l_log_module,
1005: p_level => C_LEVEL_STATEMENT);
1006: END IF;
1007: -- Bug : 9923803

Line 1014: p_encoded_message => '# xla_mpa_jlt_adr_assgns deleted = '||l_num_rows,

1010: p_amb_context_code => g_amb_context_code,
1011: p_application_id => g_application_id,
1012: p_request_code => 'IMPORT' ,
1013: p_log_type_code => 'MERGE',
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

Line 1606: FROM xla_mpa_jlt_adr_assgns

1602: AND segment_rule_type_code = C_OWNER_SYSTEM
1603: AND segment_rule_code = l_codes(i)
1604: UNION
1605: SELECT application_id
1606: FROM xla_mpa_jlt_adr_assgns
1607: WHERE application_id <> g_application_id
1608: AND amb_context_code = g_amb_context_code
1609: AND segment_rule_appl_id = g_application_id
1610: AND segment_rule_type_code = C_OWNER_SYSTEM

Line 1652: DELETE FROM xla_mpa_jlt_adr_assgns w

1648: p_encoded_message =>'# xla_seg_rules_details (value) deleted = '||l_num_rows,
1649: p_component_code => 'clean_oracle_adrs');
1650:
1651: FORALL i IN 1..l_codes.COUNT
1652: DELETE FROM xla_mpa_jlt_adr_assgns w
1653: WHERE amb_context_code = g_amb_context_code
1654: AND segment_rule_appl_id = g_application_id
1655: AND segment_rule_type_code = C_OWNER_SYSTEM
1656: AND segment_rule_code = l_codes(i);

Line 1659: trace(p_msg => '# xla_mpa_jlt_adr_assgns deleted = '||l_num_rows,

1655: AND segment_rule_type_code = C_OWNER_SYSTEM
1656: AND segment_rule_code = l_codes(i);
1657: l_num_rows := SQL%ROWCOUNT;
1658: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1659: trace(p_msg => '# xla_mpa_jlt_adr_assgns deleted = '||l_num_rows,
1660: p_module => l_log_module,
1661: p_level => C_LEVEL_STATEMENT);
1662: END IF;
1663: -- Bug : 9923803

Line 1670: p_encoded_message =>'# xla_mpa_jlt_adr_assgns deleted = '||l_num_rows,

1666: p_amb_context_code => g_amb_context_code,
1667: p_application_id => g_application_id,
1668: p_request_code => 'IMPORT' ,
1669: p_log_type_code => 'MERGE',
1670: p_encoded_message =>'# xla_mpa_jlt_adr_assgns deleted = '||l_num_rows,
1671: p_component_code => 'clean_oracle_adrs');
1672:
1673: FORALL i IN 1..l_codes.COUNT
1674: DELETE FROM xla_line_defn_adr_assgns w

Line 3145: ,'XLA_MPA_JLT_ADR_ASSGNS'

3141: ,mpa_jlt_adr_assgns.line_definition_code
3142: ,mpa_jlt_adr_assgns.accounting_line_code
3143: ,mpa_jlt_adr_assgns.mpa_accounting_line_code
3144: ,mpa_jlt_adr_assgns.segment_rule_code
3145: ,'XLA_MPA_JLT_ADR_ASSGNS'
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

Line 3146: from XLA_MPA_JLT_ADR_ASSGNS mpa_jlt_adr_assgns

3142: ,mpa_jlt_adr_assgns.accounting_line_code
3143: ,mpa_jlt_adr_assgns.mpa_accounting_line_code
3144: ,mpa_jlt_adr_assgns.segment_rule_code
3145: ,'XLA_MPA_JLT_ADR_ASSGNS'
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

Line 3171: FROM XLA_MPA_JLT_ADR_ASSGNS mpa_jlt_adr_assgns1

3167: AND s.accounting_line_type_code = mpa_jlt_adr_assgns.accounting_line_type_code
3168: AND s.accounting_line_code = mpa_jlt_adr_assgns.accounting_line_code
3169: AND s.mpa_option_code = 'NONE')
3170: and (EXISTS(SELECT 1
3171: FROM XLA_MPA_JLT_ADR_ASSGNS mpa_jlt_adr_assgns1
3172: WHERE mpa_jlt_adr_assgns.event_class_code = mpa_jlt_adr_assgns1.event_class_code
3173: and mpa_jlt_adr_assgns.event_type_code = mpa_jlt_adr_assgns1.event_type_code
3174: and mpa_jlt_adr_assgns.line_definition_code = mpa_jlt_adr_assgns1.line_definition_code
3175: and mpa_jlt_adr_assgns.line_definition_owner_code = mpa_jlt_adr_assgns1.line_definition_owner_code

Line 3188: FROM XLA_MPA_JLT_ADR_ASSGNS mpa_jlt_adr_assgns1

3184: and to_char(mpa_jlt_adr_assgns.last_update_date,'DD-MON-YYYY') <> to_char(mpa_jlt_adr_assgns1.last_update_date,'DD-MON-YYYY')
3185: )
3186: OR
3187: NOT EXISTS(SELECT 1
3188: FROM XLA_MPA_JLT_ADR_ASSGNS mpa_jlt_adr_assgns1
3189: WHERE mpa_jlt_adr_assgns.event_class_code = mpa_jlt_adr_assgns1.event_class_code
3190: and mpa_jlt_adr_assgns.event_type_code = mpa_jlt_adr_assgns1.event_type_code
3191: and mpa_jlt_adr_assgns.line_definition_code = mpa_jlt_adr_assgns1.line_definition_code
3192: and mpa_jlt_adr_assgns.line_definition_owner_code = mpa_jlt_adr_assgns1.line_definition_owner_code

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

3201: )
3202: );
3203: l_num_rows := SQL%ROWCOUNT;
3204: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3205: trace(p_msg => 'Number of Rows inserted into aads_gt from xla_mpa_jlt_adr_assgns is :'||l_num_rows,
3206: p_module => l_log_module,
3207: p_level => C_LEVEL_PROCEDURE);
3208: END IF;
3209: -- Bug : 9923803

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

3212: p_amb_context_code => g_amb_context_code,
3213: p_application_id => g_application_id,
3214: p_request_code => 'IMPORT' ,
3215: p_log_type_code => 'MERGE',
3216: p_encoded_message =>'Number of Rows inserted into aads_gt from xla_mpa_jlt_adr_assgns is :'||l_num_rows,
3217: p_component_code => 'merge_journal_line_defns');
3218:
3219: INSERT INTO xla_aads_gt
3220: ( event_class_code

Line 3533: DELETE FROM xla_mpa_jlt_adr_assgns w

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
3533: DELETE FROM xla_mpa_jlt_adr_assgns w
3534: WHERE application_id = g_application_id
3535: AND amb_context_code = g_amb_context_code
3536: AND EXISTS (
3537: SELECT 1

Line 3560: trace(p_msg => '# xla_mpa_jlt_adr_assgns deleted : '||l_num_rows,

3556: AND s.accounting_line_code = w.accounting_line_code
3557: AND s.mpa_option_code = 'NONE');
3558: l_num_rows := SQL%ROWCOUNT;
3559: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3560: trace(p_msg => '# xla_mpa_jlt_adr_assgns deleted : '||l_num_rows,
3561: p_module => l_log_module,
3562: p_level => C_LEVEL_STATEMENT);
3563: END IF;
3564: -- Bug : 9923803

Line 3571: p_encoded_message => '# xla_mpa_jlt_adr_assgns deleted : '||l_num_rows,

3567: p_amb_context_code => g_amb_context_code,
3568: p_application_id => g_application_id,
3569: p_request_code => 'IMPORT' ,
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

Line 3800: UPDATE xla_mpa_jlt_adr_assgns

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
3802: WHERE application_id = g_application_id
3803: AND amb_context_code = g_staging_context_code;
3804: l_num_rows := SQL%ROWCOUNT;

Line 3806: trace(p_msg => '# xla_mpa_jlt_adr_assgns updated : '||l_num_rows,

3802: WHERE application_id = g_application_id
3803: AND amb_context_code = g_staging_context_code;
3804: l_num_rows := SQL%ROWCOUNT;
3805: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3806: trace(p_msg => '# xla_mpa_jlt_adr_assgns updated : '||l_num_rows,
3807: p_module => l_log_module,
3808: p_level => C_LEVEL_STATEMENT);
3809: END IF;
3810: -- Bug : 9923803

Line 3817: p_encoded_message => '# xla_mpa_jlt_adr_assgns updated : '||l_num_rows,

3813: p_amb_context_code => g_amb_context_code,
3814: p_application_id => g_application_id,
3815: p_request_code => 'IMPORT' ,
3816: p_log_type_code => 'MERGE',
3817: p_encoded_message => '# xla_mpa_jlt_adr_assgns updated : '||l_num_rows,
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.