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.

[Home] [Help]

APPS.XLA_AAD_MERGE_PVT dependencies on XLA_LINE_DEFN_ADR_ASSGNS

Line 686: DELETE FROM xla_line_defn_adr_assgns w

682: p_log_type_code => 'MERGE',
683: p_encoded_message => '# xla_line_defn_ac_assgns deleted = '||l_num_rows,
684: p_component_code => 'clean_oracle_jlds');
685:
686: DELETE FROM xla_line_defn_adr_assgns w
687: WHERE application_id = g_application_id
688: AND amb_context_code = g_amb_context_code
689: AND line_definition_owner_code = C_OWNER_SYSTEM
690: AND NOT EXISTS

Line 692: FROM xla_line_defn_adr_assgns s

688: AND amb_context_code = g_amb_context_code
689: AND line_definition_owner_code = C_OWNER_SYSTEM
690: AND NOT EXISTS
691: (SELECT 1
692: FROM xla_line_defn_adr_assgns s
693: WHERE s.application_id = g_application_id
694: AND s.amb_context_code = g_staging_context_code
695: AND s.event_class_code = w.event_class_code
696: AND s.event_type_code = w.event_type_code

Line 704: trace(p_msg => '# xla_line_defn_adr_assgns deleted = '||l_num_rows,

700: AND s.accounting_line_code = w.accounting_line_code
701: AND s.flexfield_segment_code = w.flexfield_segment_code);
702: l_num_rows := SQL%ROWCOUNT;
703: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
704: trace(p_msg => '# xla_line_defn_adr_assgns deleted = '||l_num_rows,
705: p_module => l_log_module,
706: p_level => C_LEVEL_STATEMENT);
707: END IF;
708: -- Bug : 9923803

Line 715: p_encoded_message => '# xla_line_defn_adr_assgns deleted = '||l_num_rows,

711: p_amb_context_code => g_amb_context_code,
712: p_application_id => g_application_id,
713: p_request_code => 'IMPORT' ,
714: p_log_type_code => 'MERGE',
715: p_encoded_message => '# xla_line_defn_adr_assgns deleted = '||l_num_rows,
716: p_component_code => 'clean_oracle_jlds');
717:
718: DELETE FROM xla_line_defn_jlt_assgns w
719: WHERE application_id = g_application_id

Line 1085: DELETE FROM xla_line_defn_adr_assgns w

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
1087: AND amb_context_code = g_amb_context_code
1088: AND event_class_code = l_event_class_codes(i)
1089: AND accounting_line_type_code = C_OWNER_SYSTEM

Line 1093: trace(p_msg => '# xla_line_defn_adr_assgns deleted = '||l_num_rows,

1089: AND accounting_line_type_code = C_OWNER_SYSTEM
1090: AND accounting_line_code = l_codes(i);
1091: l_num_rows := SQL%ROWCOUNT;
1092: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1093: trace(p_msg => '# xla_line_defn_adr_assgns deleted = '||l_num_rows,
1094: p_module => l_log_module,
1095: p_level => C_LEVEL_STATEMENT);
1096: END IF;
1097: -- Bug : 9923803

Line 1104: p_encoded_message => '# xla_line_defn_adr_assgns deleted = '||l_num_rows,

1100: p_amb_context_code => g_amb_context_code,
1101: p_application_id => g_application_id,
1102: p_request_code => 'IMPORT' ,
1103: p_log_type_code => 'MERGE',
1104: p_encoded_message => '# xla_line_defn_adr_assgns deleted = '||l_num_rows,
1105: p_component_code => 'clean_oracle_jlts');
1106: FORALL i IN 1..l_codes.COUNT
1107: DELETE FROM xla_line_defn_ac_assgns w
1108: WHERE application_id = g_application_id

Line 1598: FROM xla_line_defn_adr_assgns

1594: AND value_segment_rule_type_code = C_OWNER_SYSTEM
1595: AND value_segment_rule_code = l_codes(i)
1596: UNION
1597: SELECT application_id
1598: FROM xla_line_defn_adr_assgns
1599: WHERE application_id <> g_application_id
1600: AND amb_context_code = g_amb_context_code
1601: AND segment_rule_appl_id = g_application_id
1602: AND segment_rule_type_code = C_OWNER_SYSTEM

Line 1674: DELETE FROM xla_line_defn_adr_assgns w

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
1675: WHERE amb_context_code = g_amb_context_code
1676: AND segment_rule_appl_id = g_application_id
1677: AND segment_rule_type_code = C_OWNER_SYSTEM
1678: AND segment_rule_code = l_codes(i);

Line 1681: trace(p_msg => '# xla_line_defn_adr_assgns deleted = '||l_num_rows,

1677: AND segment_rule_type_code = C_OWNER_SYSTEM
1678: AND segment_rule_code = l_codes(i);
1679: l_num_rows := SQL%ROWCOUNT;
1680: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1681: trace(p_msg => '# xla_line_defn_adr_assgns deleted = '||l_num_rows,
1682: p_module => l_log_module,
1683: p_level => C_LEVEL_STATEMENT);
1684: END IF;
1685: -- Bug : 9923803

Line 1692: p_encoded_message =>'# xla_line_defn_adr_assgns deleted = '||l_num_rows,

1688: p_amb_context_code => g_amb_context_code,
1689: p_application_id => g_application_id,
1690: p_request_code => 'IMPORT' ,
1691: p_log_type_code => 'MERGE',
1692: p_encoded_message =>'# xla_line_defn_adr_assgns deleted = '||l_num_rows,
1693: p_component_code => 'clean_oracle_adrs');
1694:
1695: -- Delete the ADR
1696: FORALL i IN 1..l_codes.COUNT

Line 2858: 'XLA_LINE_DEFN_ADR_ASSGNS'

2854: event_type_code,
2855: line_definition_code,
2856: accounting_line_code,
2857: segment_rule_code,
2858: 'XLA_LINE_DEFN_ADR_ASSGNS'
2859: from
2860: (select event_class_code,
2861: event_type_code,
2862: line_definition_code,

Line 2865: 'XLA_LINE_DEFN_ADR_ASSGNS',

2861: event_type_code,
2862: line_definition_code,
2863: accounting_line_code,
2864: segment_rule_code,
2865: 'XLA_LINE_DEFN_ADR_ASSGNS',
2866: amb_context_code,
2867: last_update_date ,
2868: nvl2(lag_date, decode(last_update_date,lag_date, 'True','False'),'False') flag
2869: from

Line 2875: 'XLA_LINE_DEFN_ADR_ASSGNS',

2871: event_type_code,
2872: line_definition_code,
2873: accounting_line_code,
2874: segment_rule_code,
2875: 'XLA_LINE_DEFN_ADR_ASSGNS',
2876: amb_context_code,
2877: last_update_date,
2878: lag(last_update_date) over (PARTITION by application_id,
2879: event_class_code,

Line 2889: from XLA_LINE_DEFN_ADR_ASSGNS

2885: segment_rule_code,
2886: segment_rule_type_code
2887: order by amb_context_code
2888: ) lag_date
2889: from XLA_LINE_DEFN_ADR_ASSGNS
2890: order by amb_context_code
2891: ) x
2892: where x.amb_context_code = g_staging_context_code
2893: )

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

2893: )
2894: where flag = 'False';
2895: l_num_rows := SQL%ROWCOUNT;
2896: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2897: trace(p_msg => 'Number of Rows inserted into aads_gt from xla_line_defn_adr_assgns is :'||l_num_rows,
2898: p_module => l_log_module,
2899: p_level => C_LEVEL_PROCEDURE);
2900: END IF;
2901: -- Bug : 9923803

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

2904: p_amb_context_code => g_amb_context_code,
2905: p_application_id => g_application_id,
2906: p_request_code => 'IMPORT' ,
2907: p_log_type_code => 'MERGE',
2908: p_encoded_message =>'Number of Rows inserted into aads_gt from xla_line_defn_adr_assgns is :'||l_num_rows,
2909: p_component_code => 'merge_journal_line_defns');
2910:
2911: INSERT INTO xla_aads_gt
2912: ( event_class_code,

Line 3399: DELETE FROM xla_line_defn_adr_assgns w

3395: p_component_code => 'merge_journal_line_defns');
3396:
3397: -- ADR assignment is not merged, but overwritten, if the JLD exists in the
3398: -- staging area.
3399: DELETE FROM xla_line_defn_adr_assgns w
3400: WHERE application_id = g_application_id
3401: AND amb_context_code = g_amb_context_code
3402: AND EXISTS (SELECT 1
3403: FROM xla_line_defn_jlt_assgns s

Line 3416: trace(p_msg => '# xla_line_defn_adr_assgns deleted : '||l_num_rows,

3412: --AND s.flexfield_segment_code = w.flexfield_segment_code);
3413: l_num_rows := SQL%ROWCOUNT;
3414:
3415: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3416: trace(p_msg => '# xla_line_defn_adr_assgns deleted : '||l_num_rows,
3417: p_module => l_log_module,
3418: p_level => C_LEVEL_STATEMENT);
3419: END IF;
3420: -- Bug : 9923803

Line 3427: p_encoded_message =>'# xla_line_defn_adr_assgns deleted : '||l_num_rows,

3423: p_amb_context_code => g_amb_context_code,
3424: p_application_id => g_application_id,
3425: p_request_code => 'IMPORT' ,
3426: p_log_type_code => 'MERGE',
3427: p_encoded_message =>'# xla_line_defn_adr_assgns deleted : '||l_num_rows,
3428: p_component_code => 'merge_journal_line_defns');
3429:
3430: DELETE FROM xla_line_defn_ac_assgns w
3431: WHERE application_id = g_application_id

Line 3720: UPDATE xla_line_defn_adr_assgns

3716: p_log_type_code => 'MERGE',
3717: p_encoded_message => '# xla_line_defn_jlt_assgns updated : '||l_num_rows,
3718: p_component_code => 'merge_journal_line_defns');
3719:
3720: UPDATE xla_line_defn_adr_assgns
3721: SET amb_context_code = g_amb_context_code
3722: WHERE application_id = g_application_id
3723: AND amb_context_code = g_staging_context_code;
3724: l_num_rows := SQL%ROWCOUNT;

Line 3726: trace(p_msg => '# xla_line_defn_adr_assgns updated : '||l_num_rows,

3722: WHERE application_id = g_application_id
3723: AND amb_context_code = g_staging_context_code;
3724: l_num_rows := SQL%ROWCOUNT;
3725: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3726: trace(p_msg => '# xla_line_defn_adr_assgns updated : '||l_num_rows,
3727: p_module => l_log_module,
3728: p_level => C_LEVEL_STATEMENT);
3729: END IF;
3730: -- Bug : 9923803

Line 3737: p_encoded_message => '# xla_line_defn_adr_assgns updated : '||l_num_rows,

3733: p_amb_context_code => g_amb_context_code,
3734: p_application_id => g_application_id,
3735: p_request_code => 'IMPORT' ,
3736: p_log_type_code => 'MERGE',
3737: p_encoded_message => '# xla_line_defn_adr_assgns updated : '||l_num_rows,
3738: p_component_code => 'merge_journal_line_defns');
3739:
3740: UPDATE xla_line_defn_ac_assgns
3741: SET amb_context_code = g_amb_context_code