APPS.XLA_AAD_OVERWRITE_PVT dependencies on XLA_LINE_DEFN_ADR_ASSGNS

Line 1037: FROM xla_line_defn_adr_assgns a

1033: ,a.segment_rule_type_code
1034: ,a.segment_rule_code
1035: ,adr.version_from
1036: ,adr.version_to
1037: FROM xla_line_defn_adr_assgns a
1038: ,TABLE(CAST(l_adrs AS xla_component_tbl_type)) adr
1039: WHERE a.amb_context_code = g_amb_context_code
1040: AND a.application_id <> g_application_id
1041: AND a.segment_rule_appl_id = g_application_id

Line 1202: FROM xla_line_defn_adr_assgns xld

1198: ,sysdate
1199: ,xla_environment_pkg.g_prog_appl_id
1200: ,xla_environment_pkg.g_prog_id
1201: ,xla_environment_pkg.g_req_Id
1202: FROM xla_line_defn_adr_assgns xld
1203: WHERE xld.amb_context_code = g_amb_context_code
1204: AND xld.application_id <> g_application_id
1205: AND xld.segment_rule_appl_id = g_application_id
1206: AND NOT EXISTS (SELECT 1

Line 1221: DELETE FROM xla_line_defn_adr_assgns xld

1217: p_level => C_LEVEL_PROCEDURE);
1218: END IF;
1219:
1220: IF (l_count > 0) THEN
1221: DELETE FROM xla_line_defn_adr_assgns xld
1222: WHERE xld.amb_context_code = g_amb_context_code
1223: AND xld.segment_rule_appl_id = g_application_id
1224: AND NOT EXISTS (SELECT 1
1225: FROM xla_seg_rules_b s

Line 1566: UPDATE xla_line_defn_adr_assgns

1562: p_module => l_log_module,
1563: p_level => C_LEVEL_STATEMENT);
1564: END IF;
1565:
1566: UPDATE xla_line_defn_adr_assgns
1567: SET amb_context_code = g_amb_context_code
1568: WHERE amb_context_code = g_staging_context_code;
1569:
1570: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1571: trace(p_msg => '# row moved in xla_line_defn_adr_assgns = '||SQL%ROWCOUNT,

1567: SET amb_context_code = g_amb_context_code
1568: WHERE amb_context_code = g_staging_context_code;
1569:
1570: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1571: trace(p_msg => '# row moved in xla_line_defn_adr_assgns = '||SQL%ROWCOUNT,
1572: p_module => l_log_module,
1573: p_level => C_LEVEL_STATEMENT);
1574: END IF;
1575: