APPS.XLA_AAD_MERGE_PVT dependencies on XLA_LINE_DEFN_ADR_ASSGNS

Line 607: DELETE FROM xla_line_defn_adr_assgns w

603: p_module => l_log_module,
604: p_level => C_LEVEL_STATEMENT);
605: END IF;
606:
607: DELETE FROM xla_line_defn_adr_assgns w
608: WHERE application_id = g_application_id
609: AND amb_context_code = g_amb_context_code
610: AND line_definition_owner_code = C_OWNER_SYSTEM
611: AND NOT EXISTS

Line 613: FROM xla_line_defn_adr_assgns s

609: AND amb_context_code = g_amb_context_code
610: AND line_definition_owner_code = C_OWNER_SYSTEM
611: AND NOT EXISTS
612: (SELECT 1
613: FROM xla_line_defn_adr_assgns s
614: WHERE s.application_id = g_application_id
615: AND s.amb_context_code = g_staging_context_code
616: AND s.event_class_code = w.event_class_code
617: AND s.event_type_code = w.event_type_code

Line 625: trace(p_msg => '# xla_line_defn_adr_assgns deleted = '||SQL%ROWCOUNT,

621: AND s.accounting_line_code = w.accounting_line_code
622: AND s.flexfield_segment_code = w.flexfield_segment_code);
623:
624: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
625: trace(p_msg => '# xla_line_defn_adr_assgns deleted = '||SQL%ROWCOUNT,
626: p_module => l_log_module,
627: p_level => C_LEVEL_STATEMENT);
628: END IF;
629:

Line 902: DELETE FROM xla_line_defn_adr_assgns w

898: p_level => C_LEVEL_STATEMENT);
899: END IF;
900:
901: FORALL i IN 1..l_codes.COUNT
902: DELETE FROM xla_line_defn_adr_assgns w
903: WHERE application_id = g_application_id
904: AND amb_context_code = g_amb_context_code
905: AND event_class_code = l_event_class_codes(i)
906: AND accounting_line_type_code = C_OWNER_SYSTEM

Line 910: trace(p_msg => '# xla_line_defn_adr_assgns deleted = '||SQL%ROWCOUNT,

906: AND accounting_line_type_code = C_OWNER_SYSTEM
907: AND accounting_line_code = l_codes(i);
908:
909: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
910: trace(p_msg => '# xla_line_defn_adr_assgns deleted = '||SQL%ROWCOUNT,
911: p_module => l_log_module,
912: p_level => C_LEVEL_STATEMENT);
913: END IF;
914:

Line 1288: FROM xla_line_defn_adr_assgns

1284: AND value_segment_rule_type_code = C_OWNER_SYSTEM
1285: AND value_segment_rule_code = l_codes(i)
1286: UNION
1287: SELECT application_id
1288: FROM xla_line_defn_adr_assgns
1289: WHERE application_id <> g_application_id
1290: AND amb_context_code = g_amb_context_code
1291: AND segment_rule_appl_id = g_application_id
1292: AND segment_rule_type_code = C_OWNER_SYSTEM

Line 1337: DELETE FROM xla_line_defn_adr_assgns w

1333: p_level => C_LEVEL_STATEMENT);
1334: END IF;
1335:
1336: FORALL i IN 1..l_codes.COUNT
1337: DELETE FROM xla_line_defn_adr_assgns w
1338: WHERE amb_context_code = g_amb_context_code
1339: AND segment_rule_appl_id = g_application_id
1340: AND segment_rule_type_code = C_OWNER_SYSTEM
1341: AND segment_rule_code = l_codes(i);

Line 1344: trace(p_msg => '# xla_line_defn_adr_assgns deleted = '||SQL%ROWCOUNT,

1340: AND segment_rule_type_code = C_OWNER_SYSTEM
1341: AND segment_rule_code = l_codes(i);
1342:
1343: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1344: trace(p_msg => '# xla_line_defn_adr_assgns deleted = '||SQL%ROWCOUNT,
1345: p_module => l_log_module,
1346: p_level => C_LEVEL_STATEMENT);
1347: END IF;
1348:

Line 2035: DELETE FROM xla_line_defn_adr_assgns w

2031: END IF;
2032:
2033: -- ADR assignment is not merged, but overwritten, if the JLD exists in the
2034: -- staging area.
2035: DELETE FROM xla_line_defn_adr_assgns w
2036: WHERE application_id = g_application_id
2037: AND amb_context_code = g_amb_context_code
2038: AND EXISTS (SELECT 1
2039: FROM xla_line_defn_jlt_assgns s

Line 2051: trace(p_msg => '# xla_line_defn_adr_assgns deleted : '||SQL%ROWCOUNT,

2047: AND s.accounting_line_code = w.accounting_line_code);
2048: --AND s.flexfield_segment_code = w.flexfield_segment_code);
2049:
2050: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2051: trace(p_msg => '# xla_line_defn_adr_assgns deleted : '||SQL%ROWCOUNT,
2052: p_module => l_log_module,
2053: p_level => C_LEVEL_STATEMENT);
2054: END IF;
2055:

Line 2263: UPDATE xla_line_defn_adr_assgns

2259: p_module => l_log_module,
2260: p_level => C_LEVEL_STATEMENT);
2261: END IF;
2262:
2263: UPDATE xla_line_defn_adr_assgns
2264: SET amb_context_code = g_amb_context_code
2265: WHERE application_id = g_application_id
2266: AND amb_context_code = g_staging_context_code;
2267:

Line 2269: trace(p_msg => '# xla_line_defn_adr_assgns updated : '||SQL%ROWCOUNT,

2265: WHERE application_id = g_application_id
2266: AND amb_context_code = g_staging_context_code;
2267:
2268: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2269: trace(p_msg => '# xla_line_defn_adr_assgns updated : '||SQL%ROWCOUNT,
2270: p_module => l_log_module,
2271: p_level => C_LEVEL_STATEMENT);
2272: END IF;
2273: